ArcGIS REST Services Directory
Login
|
Get Token
Home
>
services
>
MarineLitterWatch
>
MarineLitterWatch_backend (FeatureServer)
>
All Layers and Tables
Help
|
API Reference
JSON
All Layers and Tables (MarineLitterWatch/MarineLitterWatch_backend)
Layers:
Layer:
LitterWatchDB.dbo.BEACH
(0)
Name:
LitterWatchDB.dbo.BEACH
Display Field:
name
Type:
Feature Layer
Geometry Type:
esriGeometryMultipoint
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
XMin: -7206799
YMin: -2879995.102499999
XMax: 8387012.321400002
YMax: 1.3116946605700001E7
Spatial Reference: 102100 (3857)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[62, 0, 176, 255]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
Label:
Description:
Transparency:
0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
pk_beachcode
( type: esriFieldTypeString , alias: pk_beachcode , editable: true , nullable: true , length: 5 )
fk_communitycode
( type: esriFieldTypeString , alias: fk_communitycode , editable: true , nullable: true , length: 255 )
fk_user_id
( type: esriFieldTypeGUID , alias: fk_user_id , editable: true , nullable: true , length: 38 )
name
( type: esriFieldTypeString , alias: name , editable: true , nullable: true , length: 255 )
countrycode
( type: esriFieldTypeString , alias: countrycode , editable: true , nullable: true , length: 255 )
external_link
( type: esriFieldTypeString , alias: external_link , editable: true , nullable: true , length: 500 )
description
( type: esriFieldTypeString , alias: description , editable: true , nullable: true , length: 200 )
security_info
( type: esriFieldTypeString , alias: security_info , editable: true , nullable: true , length: 200 )
length
( type: esriFieldTypeInteger , alias: length , editable: true , nullable: true )
national_reference
( type: esriFieldTypeString , alias: national_reference , editable: true , nullable: true , length: 50 )
beach_type
( type: esriFieldTypeString , alias: beach_type , editable: true , nullable: true , length: 50 )
beach_location
( type: esriFieldTypeString , alias: beach_location , editable: true , nullable: true , length: 20 )
itemlist
( type: esriFieldTypeString , alias: itemlist , editable: true , nullable: true , length: 500 )
items_list
( type: esriFieldTypeString , alias: items_list , editable: true , nullable: true , length: 500 )
beach_type_id
( type: esriFieldTypeInteger , alias: beach_type_id , editable: true , nullable: true )
beach_location_id
( type: esriFieldTypeInteger , alias: beach_location_id , editable: true , nullable: true )
OBJECTID
( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.dbo.BEACH
Description:
Prototype:
beach_location_id:
null
pk_beachcode:
null
fk_communitycode:
null
fk_user_id:
null
name:
null
countrycode:
null
external_link:
null
description:
null
security_info:
null
length:
null
national_reference:
null
beach_type:
null
beach_location:
null
itemlist:
null
items_list:
null
beach_type_id:
null
Drawing Tool: esriFeatureEditToolPoint
Tables:
Table:
LitterWatchDB.DBO.Category
(1)
Name:
LitterWatchDB.DBO.Category
Display Field:
update_process
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
pk_category_id
( type: esriFieldTypeOID , alias: pk_category_id , editable: false , nullable: false )
update_process
( type: esriFieldTypeString , alias: update_process , editable: true , nullable: true , length: 1 )
update_date
( type: esriFieldTypeDate , alias: update_date , editable: true , nullable: true , length: 8 )
display_order
( type: esriFieldTypeSmallInteger , alias: display_order , editable: true , nullable: true )
OBJECTID
( type: esriFieldTypeInteger , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.Category
Description:
Prototype:
display_order:
null
update_date:
null
update_process:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.Category_Desc
(2)
Name:
LitterWatchDB.DBO.Category_Desc
Display Field:
category_description
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
pfk_category_id
( type: esriFieldTypeInteger , alias: pfk_category_id , editable: true , nullable: true )
pfk_language_id
( type: esriFieldTypeInteger , alias: pfk_language_id , editable: true , nullable: true )
category_description
( type: esriFieldTypeString , alias: category_description , editable: true , nullable: true , length: 255 )
OBJECTID
( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.Category_Desc
Description:
Prototype:
category_description:
null
pfk_category_id:
null
pfk_language_id:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.Community
(3)
Name:
LitterWatchDB.DBO.Community
Display Field:
name
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
pk_communitycode
( type: esriFieldTypeString , alias: pk_communitycode , editable: true , nullable: false , length: 255 )
name
( type: esriFieldTypeString , alias: name , editable: true , nullable: true , length: 255 )
website
( type: esriFieldTypeString , alias: website , editable: true , nullable: true , length: 255 )
contact
( type: esriFieldTypeString , alias: contact , editable: true , nullable: true , length: 255 )
description
( type: esriFieldTypeString , alias: description , editable: true , nullable: true , length: 255 )
display_order
( type: esriFieldTypeInteger , alias: display_order , editable: true , nullable: true )
fk_user_id
( type: esriFieldTypeGUID , alias: fk_user_id , editable: true , nullable: true , length: 38 )
itemlist
( type: esriFieldTypeString , alias: itemlist , editable: true , nullable: true , length: 500 )
countrycode
( type: esriFieldTypeString , alias: countrycode , editable: true , nullable: true , length: 10 )
type
( type: esriFieldTypeString , alias: type , editable: true , nullable: true , length: 255 )
OBJECTID
( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.Community
Description:
Prototype:
type:
null
pk_communitycode:
name:
null
website:
null
contact:
null
description:
null
display_order:
null
fk_user_id:
null
itemlist:
null
countrycode:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.Event
(4)
Name:
LitterWatchDB.DBO.Event
Display Field:
pk_eventcode
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
pk_eventcode
( type: esriFieldTypeString , alias: pk_eventcode , editable: true , nullable: false , length: 5 )
fk_beachcode
( type: esriFieldTypeString , alias: fk_beachcode , editable: true , nullable: false , length: 5 )
fk_communitycode
( type: esriFieldTypeString , alias: fk_communitycode , editable: true , nullable: true , length: 255 )
start_date
( type: esriFieldTypeDate , alias: start_date , editable: true , nullable: false , length: 8 )
description
( type: esriFieldTypeString , alias: description , editable: true , nullable: true , length: 500 )
created
( type: esriFieldTypeDate , alias: created , editable: true , nullable: false , length: 8 )
updated
( type: esriFieldTypeDate , alias: updated , editable: true , nullable: false , length: 8 )
fk_user_id
( type: esriFieldTypeGUID , alias: fk_user_id , editable: true , nullable: false , length: 38 )
itemlist
( type: esriFieldTypeString , alias: itemlist , editable: true , nullable: true , length: 4000 )
IsPublic
( type: esriFieldTypeSmallInteger , alias: IsPublic , editable: true , nullable: true )
people_attended
( type: esriFieldTypeInteger , alias: people_attended , editable: true , nullable: true )
summary
( type: esriFieldTypeString , alias: summary , editable: true , nullable: true , length: 500 )
end_date
( type: esriFieldTypeDate , alias: end_date , editable: true , nullable: true , length: 8 )
release_date
( type: esriFieldTypeDate , alias: release_date , editable: true , nullable: true , length: 8 )
event_type
( type: esriFieldTypeSmallInteger , alias: event_type , editable: true , nullable: true )
OBJECTID
( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.Event
Description:
Prototype:
event_type:
null
pk_eventcode:
fk_beachcode:
fk_communitycode:
null
start_date:
-2209161600000
description:
null
created:
-2209161600000
updated:
-2209161600000
fk_user_id:
{00000000-0000-0000-0000-000000000000}
itemlist:
null
IsPublic:
null
people_attended:
null
summary:
null
end_date:
null
release_date:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.Item
(5)
Name:
LitterWatchDB.DBO.Item
Display Field:
pfk_itemcode
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
pfk_itemcode
( type: esriFieldTypeInteger , alias: pfk_itemcode , editable: true , nullable: false )
itemcount
( type: esriFieldTypeInteger , alias: itemcount , editable: true , nullable: true )
pfk_survey_id
( type: esriFieldTypeGUID , alias: pfk_survey_id , editable: true , nullable: false , length: 38 )
OBJECTID
( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.Item
Description:
Prototype:
pfk_survey_id:
{00000000-0000-0000-0000-000000000000}
pfk_itemcode:
0
itemcount:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.ItemLookup_Desc
(6)
Name:
LitterWatchDB.DBO.ItemLookup_Desc
Display Field:
item_description
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
pfk_item_code
( type: esriFieldTypeInteger , alias: pfk_item_code , editable: true , nullable: true )
pfk_language_id
( type: esriFieldTypeInteger , alias: pfk_language_id , editable: true , nullable: true )
item_description
( type: esriFieldTypeString , alias: item_description , editable: true , nullable: true , length: 255 )
item_description_long
( type: esriFieldTypeString , alias: item_description_long , editable: true , nullable: true , length: 2000 )
OBJECTID
( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.ItemLookup_Desc
Description:
Prototype:
item_description_long:
null
pfk_item_code:
null
pfk_language_id:
null
item_description:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.Language
(7)
Name:
LitterWatchDB.DBO.Language
Display Field:
language_description
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
pk_language_id
( type: esriFieldTypeOID , alias: pk_language_id , editable: false , nullable: false )
language_description
( type: esriFieldTypeString , alias: language_description , editable: true , nullable: true , length: 255 )
OBJECTID
( type: esriFieldTypeInteger , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.Language
Description:
Prototype:
language_description:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.SURVEY
(8)
Name:
LitterWatchDB.DBO.SURVEY
Display Field:
Comments
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
fk_user_id
( type: esriFieldTypeGUID , alias: fk_user_id , editable: true , nullable: true , length: 38 )
create_date
( type: esriFieldTypeDate , alias: create_date , editable: true , nullable: true , length: 8 )
update_date
( type: esriFieldTypeDate , alias: update_date , editable: true , nullable: true , length: 8 )
GlobalID
( type: esriFieldTypeGUID , alias: GlobalID , editable: true , nullable: false , length: 38 )
Comments
( type: esriFieldTypeString , alias: Comments , editable: true , nullable: true , length: 2000 )
other_items
( type: esriFieldTypeString , alias: other_items , editable: true , nullable: true , length: 200 )
other_comments
( type: esriFieldTypeString , alias: other_comments , editable: true , nullable: true , length: 200 )
group_people
( type: esriFieldTypeInteger , alias: group_people , editable: true , nullable: true )
fk_eventcode
( type: esriFieldTypeString , alias: fk_eventcode , editable: true , nullable: false , length: 5 )
QualityCheck
( type: esriFieldTypeSmallInteger , alias: QualityCheck , editable: true , nullable: true )
OBJECTID
( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.SURVEY
Description:
Prototype:
QualityCheck:
null
fk_user_id:
null
create_date:
null
update_date:
null
GlobalID:
{00000000-0000-0000-0000-000000000000}
Comments:
null
other_items:
null
other_comments:
null
group_people:
null
fk_eventcode:
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.social_networks
(9)
Name:
LitterWatchDB.DBO.social_networks
Display Field:
network_name
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
network_id
( type: esriFieldTypeOID , alias: network_id , editable: false , nullable: false )
network_name
( type: esriFieldTypeString , alias: network_name , editable: true , nullable: false , length: 50 )
OBJECTID
( type: esriFieldTypeInteger , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.social_networks
Description:
Prototype:
network_name:
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.dbo.users
(10)
Name:
LitterWatchDB.dbo.users
Display Field:
username
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
fk_communitycode
( type: esriFieldTypeString , alias: fk_communitycode , editable: true , nullable: true , length: 255 )
user_token
( type: esriFieldTypeString , alias: user_token , editable: true , nullable: false , length: 255 )
user_social_network
( type: esriFieldTypeSmallInteger , alias: user_social_network , editable: true , nullable: true )
username
( type: esriFieldTypeString , alias: username , editable: true , nullable: true , length: 50 )
countrycode
( type: esriFieldTypeString , alias: countrycode , editable: true , nullable: true , length: 50 )
GlobalID
( type: esriFieldTypeGUID , alias: GlobalID , editable: true , nullable: false , length: 38 )
account_status
( type: esriFieldTypeInteger , alias: account_status , editable: true , nullable: true )
email
( type: esriFieldTypeString , alias: email , editable: true , nullable: true , length: 255 )
activation_token
( type: esriFieldTypeString , alias: activation_token , editable: true , nullable: true , length: 255 )
registration_time
( type: esriFieldTypeDate , alias: registration_time , editable: true , nullable: true , length: 8 )
reset_token
( type: esriFieldTypeString , alias: reset_token , editable: true , nullable: true , length: 255 )
reset_expire
( type: esriFieldTypeDate , alias: reset_expire , editable: true , nullable: true , length: 8 )
last_login
( type: esriFieldTypeDate , alias: last_login , editable: true , nullable: true , length: 8 )
objectid
( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.dbo.users
Description:
Prototype:
last_login:
null
fk_communitycode:
null
user_token:
user_social_network:
null
username:
null
countrycode:
null
GlobalID:
{00000000-0000-0000-0000-000000000000}
account_status:
null
email:
null
activation_token:
null
registration_time:
null
reset_token:
null
reset_expire:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.ItemLookup
(11)
Name:
LitterWatchDB.DBO.ItemLookup
Display Field:
generalname
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
pk_itemcode
( type: esriFieldTypeInteger , alias: pk_itemcode , editable: true , nullable: false )
fk_category_id
( type: esriFieldTypeInteger , alias: fk_category_id , editable: true , nullable: true )
generalcode
( type: esriFieldTypeString , alias: generalcode , editable: true , nullable: true , length: 255 )
level1_materials
( type: esriFieldTypeString , alias: level1_materials , editable: true , nullable: true , length: 255 )
level2_generaluse
( type: esriFieldTypeString , alias: level2_generaluse , editable: true , nullable: true , length: 255 )
level3
( type: esriFieldTypeString , alias: level3 , editable: true , nullable: true , length: 255 )
generalname
( type: esriFieldTypeString , alias: generalname , editable: true , nullable: true , length: 255 )
description
( type: esriFieldTypeString , alias: description , editable: true , nullable: true , length: 255 )
material
( type: esriFieldTypeString , alias: material , editable: true , nullable: true , length: 255 )
purpose
( type: esriFieldTypeString , alias: purpose , editable: true , nullable: true , length: 255 )
usage
( type: esriFieldTypeString , alias: usage , editable: true , nullable: true , length: 255 )
source
( type: esriFieldTypeString , alias: source , editable: true , nullable: true , length: 255 )
problem1
( type: esriFieldTypeString , alias: problem1 , editable: true , nullable: true , length: 255 )
problem2
( type: esriFieldTypeString , alias: problem2 , editable: true , nullable: true , length: 255 )
core
( type: esriFieldTypeInteger , alias: core , editable: true , nullable: true )
beach
( type: esriFieldTypeInteger , alias: beach , editable: true , nullable: true )
seafloor
( type: esriFieldTypeInteger , alias: seafloor , editable: true , nullable: true )
floating
( type: esriFieldTypeInteger , alias: floating , editable: true , nullable: true )
biota
( type: esriFieldTypeInteger , alias: biota , editable: true , nullable: true )
micro
( type: esriFieldTypeInteger , alias: micro , editable: true , nullable: true )
regional
( type: esriFieldTypeString , alias: regional , editable: true , nullable: true , length: 255 )
update_date
( type: esriFieldTypeDate , alias: update_date , editable: true , nullable: true , length: 8 )
update_process
( type: esriFieldTypeString , alias: update_process , editable: true , nullable: true , length: 255 )
IsToplist
( type: esriFieldTypeSmallInteger , alias: IsToplist , editable: true , nullable: true )
OBJECTID
( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.ItemLookup
Description:
Prototype:
IsToplist:
null
pk_itemcode:
0
fk_category_id:
null
generalcode:
null
level1_materials:
null
level2_generaluse:
null
level3:
null
generalname:
null
description:
null
material:
null
purpose:
null
usage:
null
source:
null
problem1:
null
problem2:
null
core:
null
beach:
null
seafloor:
null
floating:
null
biota:
null
micro:
null
regional:
null
update_date:
null
update_process:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.beach_location
(12)
Name:
LitterWatchDB.DBO.beach_location
Display Field:
beachlocation_description
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
pfk_beachlocation_id
( type: esriFieldTypeInteger , alias: pfk_beachlocation_id , editable: true , nullable: true )
pfk_language_id
( type: esriFieldTypeInteger , alias: pfk_language_id , editable: true , nullable: true )
beachlocation_description
( type: esriFieldTypeString , alias: beachlocation_description , editable: true , nullable: true , length: 50 )
objectid
( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.beach_location
Description:
Prototype:
beachlocation_description:
null
pfk_beachlocation_id:
null
pfk_language_id:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.beach_type
(13)
Name:
LitterWatchDB.DBO.beach_type
Display Field:
beachtype_description
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
pfk_beachtype_id
( type: esriFieldTypeInteger , alias: pfk_beachtype_id , editable: true , nullable: true )
pfk_language_id
( type: esriFieldTypeInteger , alias: pfk_language_id , editable: true , nullable: true )
beachtype_description
( type: esriFieldTypeString , alias: beachtype_description , editable: true , nullable: true , length: 50 )
objectid
( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.beach_type
Description:
Prototype:
beachtype_description:
null
pfk_beachtype_id:
null
pfk_language_id:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.COUNTRY
(14)
Name:
LitterWatchDB.DBO.COUNTRY
Display Field:
CountryName
Type:
Table
Geometry Type:
N/A
Description:
Definition Expression:
N/A
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, AMF, geoJSON
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
CountryCode
( type: esriFieldTypeString , alias: CountryCode , editable: true , nullable: true , length: 255 )
CountryName
( type: esriFieldTypeString , alias: CountryName , editable: true , nullable: true , length: 255 )
OBJECTID
( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
Templates:
Name: LitterWatchDB.DBO.COUNTRY
Description:
Prototype:
CountryName:
null
CountryCode:
null
Drawing Tool: esriFeatureEditToolNone