ArcGIS REST Services Directory
Login
|
Get Token
Home
>
services
>
MarineLitterWatch
>
MarineLitterWatch_backend (FeatureServer)
>
All Layers and Tables
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:
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
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:
N/A
Description:
N/A
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
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, defaultValue: null, modelName: pk_beachcode )
fk_communitycode
( type: esriFieldTypeString, alias: fk_communitycode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: fk_communitycode )
fk_user_id
( type: esriFieldTypeGUID, alias: fk_user_id, editable: true, nullable: true, length: 38, defaultValue: null, modelName: fk_user_id )
name
( type: esriFieldTypeString, alias: name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: name )
countrycode
( type: esriFieldTypeString, alias: countrycode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: countrycode )
external_link
( type: esriFieldTypeString, alias: external_link, editable: true, nullable: true, length: 500, defaultValue: null, modelName: external_link )
description
( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: description )
security_info
( type: esriFieldTypeString, alias: security_info, editable: true, nullable: true, length: 200, defaultValue: null, modelName: security_info )
length
( type: esriFieldTypeInteger, alias: length, editable: true, nullable: true, defaultValue: null, modelName: length )
national_reference
( type: esriFieldTypeString, alias: national_reference, editable: true, nullable: true, length: 50, defaultValue: null, modelName: national_reference )
beach_type
( type: esriFieldTypeString, alias: beach_type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: beach_type )
beach_location
( type: esriFieldTypeString, alias: beach_location, editable: true, nullable: true, length: 20, defaultValue: null, modelName: beach_location )
itemlist
( type: esriFieldTypeString, alias: itemlist, editable: true, nullable: true, length: 500, defaultValue: null, modelName: itemlist )
items_list
( type: esriFieldTypeString, alias: items_list, editable: true, nullable: true, length: 500, defaultValue: null, modelName: items_list )
beach_type_id
( type: esriFieldTypeInteger, alias: beach_type_id, editable: true, nullable: true, defaultValue: null, modelName: beach_type_id )
beach_location_id
( type: esriFieldTypeInteger, alias: beach_location_id, editable: true, nullable: true, defaultValue: null, modelName: beach_location_id )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
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:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID, required: true )
pk_category_id
( type: esriFieldTypeInteger, alias: pk_category_id, editable: false, nullable: false, defaultValue: null, modelName: pk_category_id )
update_process
( type: esriFieldTypeString, alias: update_process, editable: true, nullable: true, length: 1, defaultValue: null, modelName: update_process )
update_date
( type: esriFieldTypeDate, alias: update_date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: update_date )
display_order
( type: esriFieldTypeSmallInteger, alias: display_order, editable: true, nullable: true, defaultValue: null, modelName: display_order )
Templates:
Name: LitterWatchDB.DBO.Category
Description:
Prototype:
update_date:
null
update_process:
null
display_order:
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:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
pfk_category_id
( type: esriFieldTypeInteger, alias: pfk_category_id, editable: true, nullable: true, defaultValue: null, modelName: pfk_category_id )
pfk_language_id
( type: esriFieldTypeInteger, alias: pfk_language_id, editable: true, nullable: true, defaultValue: null, modelName: pfk_language_id )
category_description
( type: esriFieldTypeString, alias: category_description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: category_description )
Templates:
Name: LitterWatchDB.DBO.Category_Desc
Description:
Prototype:
pfk_language_id:
null
category_description:
null
pfk_category_id:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.Community
(3)
Name:
LitterWatchDB.DBO.Community
Display Field:
name
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
pk_communitycode
( type: esriFieldTypeString, alias: pk_communitycode, editable: true, nullable: false, length: 255, defaultValue: null, modelName: pk_communitycode )
name
( type: esriFieldTypeString, alias: name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: name )
website
( type: esriFieldTypeString, alias: website, editable: true, nullable: true, length: 255, defaultValue: null, modelName: website )
contact
( type: esriFieldTypeString, alias: contact, editable: true, nullable: true, length: 255, defaultValue: null, modelName: contact )
description
( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: description )
display_order
( type: esriFieldTypeInteger, alias: display_order, editable: true, nullable: true, defaultValue: null, modelName: display_order )
fk_user_id
( type: esriFieldTypeGUID, alias: fk_user_id, editable: true, nullable: true, length: 38, defaultValue: null, modelName: fk_user_id )
itemlist
( type: esriFieldTypeString, alias: itemlist, editable: true, nullable: true, length: 500, defaultValue: null, modelName: itemlist )
countrycode
( type: esriFieldTypeString, alias: countrycode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: countrycode )
type
( type: esriFieldTypeString, alias: type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: type )
Templates:
Name: LitterWatchDB.DBO.Community
Description:
Prototype:
countrycode:
null
type:
null
pk_communitycode:
name:
null
website:
null
contact:
null
description:
null
display_order:
null
fk_user_id:
null
itemlist:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.Event
(4)
Name:
LitterWatchDB.DBO.Event
Display Field:
pk_eventcode
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
pk_eventcode
( type: esriFieldTypeString, alias: pk_eventcode, editable: true, nullable: false, length: 5, defaultValue: null, modelName: pk_eventcode )
fk_beachcode
( type: esriFieldTypeString, alias: fk_beachcode, editable: true, nullable: false, length: 5, defaultValue: null, modelName: fk_beachcode )
fk_communitycode
( type: esriFieldTypeString, alias: fk_communitycode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: fk_communitycode )
start_date
( type: esriFieldTypeDate, alias: start_date, editable: true, nullable: false, length: 8, defaultValue: null, precision: 1, modelName: start_date )
description
( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 500, defaultValue: null, modelName: description )
created
( type: esriFieldTypeDate, alias: created, editable: true, nullable: false, length: 8, defaultValue: null, precision: 1, modelName: created )
updated
( type: esriFieldTypeDate, alias: updated, editable: true, nullable: false, length: 8, defaultValue: null, precision: 1, modelName: updated )
fk_user_id
( type: esriFieldTypeGUID, alias: fk_user_id, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: fk_user_id )
itemlist
( type: esriFieldTypeString, alias: itemlist, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: itemlist )
IsPublic
( type: esriFieldTypeSmallInteger, alias: IsPublic, editable: true, nullable: true, defaultValue: null, modelName: IsPublic )
people_attended
( type: esriFieldTypeInteger, alias: people_attended, editable: true, nullable: true, defaultValue: null, modelName: people_attended )
summary
( type: esriFieldTypeString, alias: summary, editable: true, nullable: true, length: 500, defaultValue: null, modelName: summary )
end_date
( type: esriFieldTypeDate, alias: end_date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: end_date )
release_date
( type: esriFieldTypeDate, alias: release_date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: release_date )
event_type
( type: esriFieldTypeSmallInteger, alias: event_type, editable: true, nullable: true, defaultValue: null, modelName: event_type )
Templates:
Name: LitterWatchDB.DBO.Event
Description:
Prototype:
release_date:
null
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
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.Item
(5)
Name:
LitterWatchDB.DBO.Item
Display Field:
pfk_itemcode
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
pfk_itemcode
( type: esriFieldTypeInteger, alias: pfk_itemcode, editable: true, nullable: false, defaultValue: null, modelName: pfk_itemcode )
itemcount
( type: esriFieldTypeInteger, alias: itemcount, editable: true, nullable: true, defaultValue: null, modelName: itemcount )
pfk_survey_id
( type: esriFieldTypeGUID, alias: pfk_survey_id, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: pfk_survey_id )
Templates:
Name: LitterWatchDB.DBO.Item
Description:
Prototype:
itemcount:
null
pfk_survey_id:
{00000000-0000-0000-0000-000000000000}
pfk_itemcode:
0
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:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
pfk_item_code
( type: esriFieldTypeInteger, alias: pfk_item_code, editable: true, nullable: true, defaultValue: null, modelName: pfk_item_code )
pfk_language_id
( type: esriFieldTypeInteger, alias: pfk_language_id, editable: true, nullable: true, defaultValue: null, modelName: pfk_language_id )
item_description
( type: esriFieldTypeString, alias: item_description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: item_description )
item_description_long
( type: esriFieldTypeString, alias: item_description_long, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: item_description_long )
Templates:
Name: LitterWatchDB.DBO.ItemLookup_Desc
Description:
Prototype:
item_description:
null
item_description_long:
null
pfk_item_code:
null
pfk_language_id:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.Language
(7)
Name:
LitterWatchDB.DBO.Language
Display Field:
language_description
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID, required: true )
pk_language_id
( type: esriFieldTypeInteger, alias: pk_language_id, editable: false, nullable: false, defaultValue: null, modelName: pk_language_id )
language_description
( type: esriFieldTypeString, alias: language_description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: language_description )
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:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
fk_user_id
( type: esriFieldTypeGUID, alias: fk_user_id, editable: true, nullable: true, length: 38, defaultValue: null, modelName: fk_user_id )
create_date
( type: esriFieldTypeDate, alias: create_date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: create_date )
update_date
( type: esriFieldTypeDate, alias: update_date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: update_date )
GlobalID
( type: esriFieldTypeGUID, alias: GlobalID, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: GlobalID )
Comments
( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: Comments )
other_items
( type: esriFieldTypeString, alias: other_items, editable: true, nullable: true, length: 200, defaultValue: null, modelName: other_items )
other_comments
( type: esriFieldTypeString, alias: other_comments, editable: true, nullable: true, length: 200, defaultValue: null, modelName: other_comments )
group_people
( type: esriFieldTypeInteger, alias: group_people, editable: true, nullable: true, defaultValue: null, modelName: group_people )
fk_eventcode
( type: esriFieldTypeString, alias: fk_eventcode, editable: true, nullable: false, length: 5, defaultValue: null, modelName: fk_eventcode )
QualityCheck
( type: esriFieldTypeSmallInteger, alias: QualityCheck, editable: true, nullable: true, defaultValue: null, modelName: QualityCheck )
Templates:
Name: LitterWatchDB.DBO.SURVEY
Description:
Prototype:
fk_eventcode:
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
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:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID, required: true )
network_id
( type: esriFieldTypeInteger, alias: network_id, editable: false, nullable: false, defaultValue: null, modelName: network_id )
network_name
( type: esriFieldTypeString, alias: network_name, editable: true, nullable: false, length: 50, defaultValue: null, modelName: network_name )
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:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: objectid )
fk_communitycode
( type: esriFieldTypeString, alias: fk_communitycode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: fk_communitycode )
user_token
( type: esriFieldTypeString, alias: user_token, editable: true, nullable: false, length: 255, defaultValue: null, modelName: user_token )
user_social_network
( type: esriFieldTypeSmallInteger, alias: user_social_network, editable: true, nullable: true, defaultValue: null, modelName: user_social_network )
username
( type: esriFieldTypeString, alias: username, editable: true, nullable: true, length: 50, defaultValue: null, modelName: username )
countrycode
( type: esriFieldTypeString, alias: countrycode, editable: true, nullable: true, length: 50, defaultValue: null, modelName: countrycode )
GlobalID
( type: esriFieldTypeGUID, alias: GlobalID, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: GlobalID )
account_status
( type: esriFieldTypeInteger, alias: account_status, editable: true, nullable: true, defaultValue: null, modelName: account_status )
email
( type: esriFieldTypeString, alias: email, editable: true, nullable: true, length: 255, defaultValue: null, modelName: email )
activation_token
( type: esriFieldTypeString, alias: activation_token, editable: true, nullable: true, length: 255, defaultValue: null, modelName: activation_token )
registration_time
( type: esriFieldTypeDate, alias: registration_time, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: registration_time )
reset_token
( type: esriFieldTypeString, alias: reset_token, editable: true, nullable: true, length: 255, defaultValue: null, modelName: reset_token )
reset_expire
( type: esriFieldTypeDate, alias: reset_expire, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: reset_expire )
last_login
( type: esriFieldTypeDate, alias: last_login, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: last_login )
Templates:
Name: LitterWatchDB.dbo.users
Description:
Prototype:
reset_expire:
null
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
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.ItemLookup
(11)
Name:
LitterWatchDB.DBO.ItemLookup
Display Field:
generalname
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
pk_itemcode
( type: esriFieldTypeInteger, alias: pk_itemcode, editable: true, nullable: false, defaultValue: null, modelName: pk_itemcode )
fk_category_id
( type: esriFieldTypeInteger, alias: fk_category_id, editable: true, nullable: true, defaultValue: null, modelName: fk_category_id )
generalcode
( type: esriFieldTypeString, alias: generalcode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: generalcode )
level1_materials
( type: esriFieldTypeString, alias: level1_materials, editable: true, nullable: true, length: 255, defaultValue: null, modelName: level1_materials )
level2_generaluse
( type: esriFieldTypeString, alias: level2_generaluse, editable: true, nullable: true, length: 255, defaultValue: null, modelName: level2_generaluse )
level3
( type: esriFieldTypeString, alias: level3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: level3 )
generalname
( type: esriFieldTypeString, alias: generalname, editable: true, nullable: true, length: 255, defaultValue: null, modelName: generalname )
description
( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: description )
material
( type: esriFieldTypeString, alias: material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: material )
purpose
( type: esriFieldTypeString, alias: purpose, editable: true, nullable: true, length: 255, defaultValue: null, modelName: purpose )
usage
( type: esriFieldTypeString, alias: usage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: usage )
source
( type: esriFieldTypeString, alias: source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: source )
problem1
( type: esriFieldTypeString, alias: problem1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: problem1 )
problem2
( type: esriFieldTypeString, alias: problem2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: problem2 )
core
( type: esriFieldTypeInteger, alias: core, editable: true, nullable: true, defaultValue: null, modelName: core )
beach
( type: esriFieldTypeInteger, alias: beach, editable: true, nullable: true, defaultValue: null, modelName: beach )
seafloor
( type: esriFieldTypeInteger, alias: seafloor, editable: true, nullable: true, defaultValue: null, modelName: seafloor )
floating
( type: esriFieldTypeInteger, alias: floating, editable: true, nullable: true, defaultValue: null, modelName: floating )
biota
( type: esriFieldTypeInteger, alias: biota, editable: true, nullable: true, defaultValue: null, modelName: biota )
micro
( type: esriFieldTypeInteger, alias: micro, editable: true, nullable: true, defaultValue: null, modelName: micro )
regional
( type: esriFieldTypeString, alias: regional, editable: true, nullable: true, length: 255, defaultValue: null, modelName: regional )
update_date
( type: esriFieldTypeDate, alias: update_date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: update_date )
update_process
( type: esriFieldTypeString, alias: update_process, editable: true, nullable: true, length: 255, defaultValue: null, modelName: update_process )
IsToplist
( type: esriFieldTypeSmallInteger, alias: IsToplist, editable: true, nullable: true, defaultValue: null, modelName: IsToplist )
Templates:
Name: LitterWatchDB.DBO.ItemLookup
Description:
Prototype:
update_process:
null
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
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:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: objectid )
pfk_beachlocation_id
( type: esriFieldTypeInteger, alias: pfk_beachlocation_id, editable: true, nullable: true, defaultValue: null, modelName: pfk_beachlocation_id )
pfk_language_id
( type: esriFieldTypeInteger, alias: pfk_language_id, editable: true, nullable: true, defaultValue: null, modelName: pfk_language_id )
beachlocation_description
( type: esriFieldTypeString, alias: beachlocation_description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: beachlocation_description )
Templates:
Name: LitterWatchDB.DBO.beach_location
Description:
Prototype:
pfk_language_id:
null
beachlocation_description:
null
pfk_beachlocation_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:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
objectid
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: objectid )
pfk_beachtype_id
( type: esriFieldTypeInteger, alias: pfk_beachtype_id, editable: true, nullable: true, defaultValue: null, modelName: pfk_beachtype_id )
pfk_language_id
( type: esriFieldTypeInteger, alias: pfk_language_id, editable: true, nullable: true, defaultValue: null, modelName: pfk_language_id )
beachtype_description
( type: esriFieldTypeString, alias: beachtype_description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: beachtype_description )
Templates:
Name: LitterWatchDB.DBO.beach_type
Description:
Prototype:
pfk_language_id:
null
beachtype_description:
null
pfk_beachtype_id:
null
Drawing Tool: esriFeatureEditToolNone
Table:
LitterWatchDB.DBO.COUNTRY
(14)
Name:
LitterWatchDB.DBO.COUNTRY
Display Field:
CountryName
Type:
Table
Geometry Type:
N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount:
1000000
Supported Query Formats:
JSON, geoJSON, PBF
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
CountryCode
( type: esriFieldTypeString, alias: CountryCode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CountryCode )
CountryName
( type: esriFieldTypeString, alias: CountryName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CountryName )
Templates:
Name: LitterWatchDB.DBO.COUNTRY
Description:
Prototype:
CountryCode:
null
CountryName:
null
Drawing Tool: esriFeatureEditToolNone