{ "layers": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 0, "name": "LitterWatchDB.dbo.BEACH", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryMultipoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 62, 0, 176, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.68872780728E7, "ymin": -4583431.436500002, "xmax": 1.85283500061E7, "ymax": 1.50868348948E7, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "pk_beachcode", "type": "esriFieldTypeString", "alias": "pk_beachcode", "length": 5, "domain": null }, { "name": "fk_communitycode", "type": "esriFieldTypeString", "alias": "fk_communitycode", "length": 255, "domain": null }, { "name": "fk_user_id", "type": "esriFieldTypeGUID", "alias": "fk_user_id", "length": 38, "domain": null }, { "name": "name", "type": "esriFieldTypeString", "alias": "name", "length": 255, "domain": null }, { "name": "countrycode", "type": "esriFieldTypeString", "alias": "countrycode", "length": 255, "domain": null }, { "name": "external_link", "type": "esriFieldTypeString", "alias": "external_link", "length": 500, "domain": null }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "length": 200, "domain": null }, { "name": "security_info", "type": "esriFieldTypeString", "alias": "security_info", "length": 200, "domain": null }, { "name": "length", "type": "esriFieldTypeInteger", "alias": "length", "domain": null }, { "name": "national_reference", "type": "esriFieldTypeString", "alias": "national_reference", "length": 50, "domain": null }, { "name": "beach_type", "type": "esriFieldTypeString", "alias": "beach_type", "length": 50, "domain": null }, { "name": "beach_location", "type": "esriFieldTypeString", "alias": "beach_location", "length": 20, "domain": null }, { "name": "itemlist", "type": "esriFieldTypeString", "alias": "itemlist", "length": 500, "domain": null }, { "name": "items_list", "type": "esriFieldTypeString", "alias": "items_list", "length": 500, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "beach_type_id", "type": "esriFieldTypeInteger", "alias": "beach_type_id", "domain": null }, { "name": "beach_location_id", "type": "esriFieldTypeInteger", "alias": "beach_location_id", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": null, "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "LitterWatchDB.DBO.Category", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "update_process", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "pk_category_id", "type": "esriFieldTypeInteger", "alias": "pk_category_id", "domain": null }, { "name": "update_process", "type": "esriFieldTypeString", "alias": "update_process", "length": 1, "domain": null }, { "name": "update_date", "type": "esriFieldTypeDate", "alias": "update_date", "length": 8, "domain": null }, { "name": "display_order", "type": "esriFieldTypeSmallInteger", "alias": "display_order", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "LitterWatchDB.DBO.Category_Desc", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "category_description", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "pfk_category_id", "type": "esriFieldTypeInteger", "alias": "pfk_category_id", "domain": null }, { "name": "pfk_language_id", "type": "esriFieldTypeInteger", "alias": "pfk_language_id", "domain": null }, { "name": "category_description", "type": "esriFieldTypeString", "alias": "category_description", "length": 255, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 3, "name": "LitterWatchDB.DBO.Community", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "pk_communitycode", "type": "esriFieldTypeString", "alias": "pk_communitycode", "length": 255, "domain": null }, { "name": "name", "type": "esriFieldTypeString", "alias": "name", "length": 255, "domain": null }, { "name": "website", "type": "esriFieldTypeString", "alias": "website", "length": 255, "domain": null }, { "name": "contact", "type": "esriFieldTypeString", "alias": "contact", "length": 255, "domain": null }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "length": 255, "domain": null }, { "name": "display_order", "type": "esriFieldTypeInteger", "alias": "display_order", "domain": null }, { "name": "fk_user_id", "type": "esriFieldTypeGUID", "alias": "fk_user_id", "length": 38, "domain": null }, { "name": "itemlist", "type": "esriFieldTypeString", "alias": "itemlist", "length": 500, "domain": null }, { "name": "countrycode", "type": "esriFieldTypeString", "alias": "countrycode", "length": 10, "domain": null }, { "name": "type", "type": "esriFieldTypeString", "alias": "type", "length": 255, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 4, "name": "LitterWatchDB.DBO.Event", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "pk_eventcode", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "pk_eventcode", "type": "esriFieldTypeString", "alias": "pk_eventcode", "length": 5, "domain": null }, { "name": "fk_beachcode", "type": "esriFieldTypeString", "alias": "fk_beachcode", "length": 5, "domain": null }, { "name": "fk_communitycode", "type": "esriFieldTypeString", "alias": "fk_communitycode", "length": 255, "domain": null }, { "name": "start_date", "type": "esriFieldTypeDate", "alias": "start_date", "length": 8, "domain": null }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "length": 500, "domain": null }, { "name": "created", "type": "esriFieldTypeDate", "alias": "created", "length": 8, "domain": null }, { "name": "updated", "type": "esriFieldTypeDate", "alias": "updated", "length": 8, "domain": null }, { "name": "fk_user_id", "type": "esriFieldTypeGUID", "alias": "fk_user_id", "length": 38, "domain": null }, { "name": "itemlist", "type": "esriFieldTypeString", "alias": "itemlist", "length": 4000, "domain": null }, { "name": "IsPublic", "type": "esriFieldTypeSmallInteger", "alias": "IsPublic", "domain": null }, { "name": "people_attended", "type": "esriFieldTypeInteger", "alias": "people_attended", "domain": null }, { "name": "summary", "type": "esriFieldTypeString", "alias": "summary", "length": 500, "domain": null }, { "name": "end_date", "type": "esriFieldTypeDate", "alias": "end_date", "length": 8, "domain": null }, { "name": "release_date", "type": "esriFieldTypeDate", "alias": "release_date", "length": 8, "domain": null }, { "name": "event_type", "type": "esriFieldTypeSmallInteger", "alias": "event_type", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 5, "name": "LitterWatchDB.DBO.Item", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "pfk_itemcode", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "pfk_itemcode", "type": "esriFieldTypeInteger", "alias": "pfk_itemcode", "domain": null }, { "name": "itemcount", "type": "esriFieldTypeInteger", "alias": "itemcount", "domain": null }, { "name": "pfk_survey_id", "type": "esriFieldTypeGUID", "alias": "pfk_survey_id", "length": 38, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 6, "name": "LitterWatchDB.DBO.ItemLookup_Desc", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "item_description", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "pfk_item_code", "type": "esriFieldTypeInteger", "alias": "pfk_item_code", "domain": null }, { "name": "pfk_language_id", "type": "esriFieldTypeInteger", "alias": "pfk_language_id", "domain": null }, { "name": "item_description", "type": "esriFieldTypeString", "alias": "item_description", "length": 255, "domain": null }, { "name": "item_description_long", "type": "esriFieldTypeString", "alias": "item_description_long", "length": 2000, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 7, "name": "LitterWatchDB.DBO.Language", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "language_description", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "pk_language_id", "type": "esriFieldTypeInteger", "alias": "pk_language_id", "domain": null }, { "name": "language_description", "type": "esriFieldTypeString", "alias": "language_description", "length": 255, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 8, "name": "LitterWatchDB.DBO.SURVEY", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Comments", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "fk_user_id", "type": "esriFieldTypeGUID", "alias": "fk_user_id", "length": 38, "domain": null }, { "name": "create_date", "type": "esriFieldTypeDate", "alias": "create_date", "length": 8, "domain": null }, { "name": "update_date", "type": "esriFieldTypeDate", "alias": "update_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 2000, "domain": null }, { "name": "other_items", "type": "esriFieldTypeString", "alias": "other_items", "length": 200, "domain": null }, { "name": "other_comments", "type": "esriFieldTypeString", "alias": "other_comments", "length": 200, "domain": null }, { "name": "group_people", "type": "esriFieldTypeInteger", "alias": "group_people", "domain": null }, { "name": "fk_eventcode", "type": "esriFieldTypeString", "alias": "fk_eventcode", "length": 5, "domain": null }, { "name": "QualityCheck", "type": "esriFieldTypeSmallInteger", "alias": "QualityCheck", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 9, "name": "LitterWatchDB.DBO.social_networks", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "network_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "network_id", "type": "esriFieldTypeSmallInteger", "alias": "network_id", "domain": null }, { "name": "network_name", "type": "esriFieldTypeString", "alias": "network_name", "length": 50, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 10, "name": "LitterWatchDB.dbo.users", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "username", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "fk_communitycode", "type": "esriFieldTypeString", "alias": "fk_communitycode", "length": 255, "domain": null }, { "name": "user_token", "type": "esriFieldTypeString", "alias": "user_token", "length": 255, "domain": null }, { "name": "user_social_network", "type": "esriFieldTypeSmallInteger", "alias": "user_social_network", "domain": null }, { "name": "username", "type": "esriFieldTypeString", "alias": "username", "length": 50, "domain": null }, { "name": "countrycode", "type": "esriFieldTypeString", "alias": "countrycode", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "account_status", "type": "esriFieldTypeInteger", "alias": "account_status", "domain": null }, { "name": "email", "type": "esriFieldTypeString", "alias": "email", "length": 255, "domain": null }, { "name": "activation_token", "type": "esriFieldTypeString", "alias": "activation_token", "length": 255, "domain": null }, { "name": "registration_time", "type": "esriFieldTypeDate", "alias": "registration_time", "length": 8, "domain": null }, { "name": "reset_token", "type": "esriFieldTypeString", "alias": "reset_token", "length": 255, "domain": null }, { "name": "reset_expire", "type": "esriFieldTypeDate", "alias": "reset_expire", "length": 8, "domain": null }, { "name": "last_login", "type": "esriFieldTypeDate", "alias": "last_login", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 11, "name": "LitterWatchDB.DBO.ItemLookup", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "generalname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "pk_itemcode", "type": "esriFieldTypeInteger", "alias": "pk_itemcode", "domain": null }, { "name": "fk_category_id", "type": "esriFieldTypeInteger", "alias": "fk_category_id", "domain": null }, { "name": "generalcode", "type": "esriFieldTypeString", "alias": "generalcode", "length": 255, "domain": null }, { "name": "level1_materials", "type": "esriFieldTypeString", "alias": "level1_materials", "length": 255, "domain": null }, { "name": "level2_generaluse", "type": "esriFieldTypeString", "alias": "level2_generaluse", "length": 255, "domain": null }, { "name": "level3", "type": "esriFieldTypeString", "alias": "level3", "length": 255, "domain": null }, { "name": "generalname", "type": "esriFieldTypeString", "alias": "generalname", "length": 255, "domain": null }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "length": 255, "domain": null }, { "name": "material", "type": "esriFieldTypeString", "alias": "material", "length": 255, "domain": null }, { "name": "purpose", "type": "esriFieldTypeString", "alias": "purpose", "length": 255, "domain": null }, { "name": "usage", "type": "esriFieldTypeString", "alias": "usage", "length": 255, "domain": null }, { "name": "source", "type": "esriFieldTypeString", "alias": "source", "length": 255, "domain": null }, { "name": "problem1", "type": "esriFieldTypeString", "alias": "problem1", "length": 255, "domain": null }, { "name": "problem2", "type": "esriFieldTypeString", "alias": "problem2", "length": 255, "domain": null }, { "name": "core", "type": "esriFieldTypeInteger", "alias": "core", "domain": null }, { "name": "beach", "type": "esriFieldTypeInteger", "alias": "beach", "domain": null }, { "name": "seafloor", "type": "esriFieldTypeInteger", "alias": "seafloor", "domain": null }, { "name": "floating", "type": "esriFieldTypeInteger", "alias": "floating", "domain": null }, { "name": "biota", "type": "esriFieldTypeInteger", "alias": "biota", "domain": null }, { "name": "micro", "type": "esriFieldTypeInteger", "alias": "micro", "domain": null }, { "name": "regional", "type": "esriFieldTypeString", "alias": "regional", "length": 255, "domain": null }, { "name": "update_date", "type": "esriFieldTypeDate", "alias": "update_date", "length": 8, "domain": null }, { "name": "update_process", "type": "esriFieldTypeString", "alias": "update_process", "length": 255, "domain": null }, { "name": "IsToplist", "type": "esriFieldTypeSmallInteger", "alias": "IsToplist", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 12, "name": "LitterWatchDB.DBO.beach_location", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "beachlocation_description", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "pfk_beachlocation_id", "type": "esriFieldTypeInteger", "alias": "pfk_beachlocation_id", "domain": null }, { "name": "pfk_language_id", "type": "esriFieldTypeInteger", "alias": "pfk_language_id", "domain": null }, { "name": "beachlocation_description", "type": "esriFieldTypeString", "alias": "beachlocation_description", "length": 50, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 13, "name": "LitterWatchDB.DBO.beach_type", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "beachtype_description", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "pfk_beachtype_id", "type": "esriFieldTypeInteger", "alias": "pfk_beachtype_id", "domain": null }, { "name": "pfk_language_id", "type": "esriFieldTypeInteger", "alias": "pfk_language_id", "domain": null }, { "name": "beachtype_description", "type": "esriFieldTypeString", "alias": "beachtype_description", "length": 50, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 14, "name": "LitterWatchDB.DBO.COUNTRY", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CountryName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CountryCode", "type": "esriFieldTypeString", "alias": "CountryCode", "length": 255, "domain": null }, { "name": "CountryName", "type": "esriFieldTypeString", "alias": "CountryName", "length": 255, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }