{ "layers": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 0, "name": "LitterWatchDB.dbo.BEACH", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryMultipoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "pk_beachcode", "type": "esriFieldTypeString", "alias": "pk_beachcode", "domain": null, "editable": true, "nullable": false, "length": 5, "defaultValue": null, "modelName": "pk_beachcode" }, { "name": "fk_communitycode", "type": "esriFieldTypeString", "alias": "fk_communitycode", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "fk_communitycode" }, { "name": "fk_user_id", "type": "esriFieldTypeGUID", "alias": "fk_user_id", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "fk_user_id" }, { "name": "name", "type": "esriFieldTypeString", "alias": "name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "name" }, { "name": "countrycode", "type": "esriFieldTypeString", "alias": "countrycode", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "countrycode" }, { "name": "external_link", "type": "esriFieldTypeString", "alias": "external_link", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "external_link" }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "description" }, { "name": "security_info", "type": "esriFieldTypeString", "alias": "security_info", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "security_info" }, { "name": "length", "type": "esriFieldTypeInteger", "alias": "length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "length" }, { "name": "national_reference", "type": "esriFieldTypeString", "alias": "national_reference", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "national_reference" }, { "name": "beach_type", "type": "esriFieldTypeString", "alias": "beach_type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "beach_type" }, { "name": "beach_location", "type": "esriFieldTypeString", "alias": "beach_location", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "beach_location" }, { "name": "itemlist", "type": "esriFieldTypeString", "alias": "itemlist", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "itemlist" }, { "name": "items_list", "type": "esriFieldTypeString", "alias": "items_list", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "items_list" }, { "name": "beach_type_id", "type": "esriFieldTypeInteger", "alias": "beach_type_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "beach_type_id" }, { "name": "beach_location_id", "type": "esriFieldTypeInteger", "alias": "beach_location_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "beach_location_id" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.dbo.BEACH", "description": "", "prototype": { "attributes": { "beach_location_id": null, "pk_beachcode": " ", "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 } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 100000, "tileMaxRecordCount": 100000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "LitterWatchDB.DBO.Category", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "pk_category_id", "globalIdField": "", "displayField": "update_process", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "pk_category_id", "type": "esriFieldTypeOID", "alias": "pk_category_id", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "pk_category_id" }, { "name": "update_process", "type": "esriFieldTypeString", "alias": "update_process", "domain": null, "editable": false, "nullable": true, "length": 1, "defaultValue": null, "modelName": "update_process" }, { "name": "update_date", "type": "esriFieldTypeDate", "alias": "update_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "update_date" }, { "name": "display_order", "type": "esriFieldTypeSmallInteger", "alias": "display_order", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "display_order" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.Category", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "LitterWatchDB.DBO.Category_Desc", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "category_description", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "pfk_category_id", "type": "esriFieldTypeInteger", "alias": "pfk_category_id", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "pfk_category_id" }, { "name": "pfk_language_id", "type": "esriFieldTypeInteger", "alias": "pfk_language_id", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "pfk_language_id" }, { "name": "category_description", "type": "esriFieldTypeString", "alias": "category_description", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "category_description" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.Category_Desc", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 3, "name": "LitterWatchDB.DBO.Community", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "pk_communitycode", "type": "esriFieldTypeString", "alias": "pk_communitycode", "domain": null, "editable": false, "nullable": false, "length": 255, "defaultValue": null, "modelName": "pk_communitycode" }, { "name": "name", "type": "esriFieldTypeString", "alias": "name", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "name" }, { "name": "website", "type": "esriFieldTypeString", "alias": "website", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "website" }, { "name": "contact", "type": "esriFieldTypeString", "alias": "contact", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "contact" }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "description" }, { "name": "display_order", "type": "esriFieldTypeInteger", "alias": "display_order", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "display_order" }, { "name": "fk_user_id", "type": "esriFieldTypeGUID", "alias": "fk_user_id", "domain": null, "editable": false, "nullable": true, "length": 38, "defaultValue": null, "modelName": "fk_user_id" }, { "name": "itemlist", "type": "esriFieldTypeString", "alias": "itemlist", "domain": null, "editable": false, "nullable": true, "length": 500, "defaultValue": null, "modelName": "itemlist" }, { "name": "countrycode", "type": "esriFieldTypeString", "alias": "countrycode", "domain": null, "editable": false, "nullable": true, "length": 10, "defaultValue": null, "modelName": "countrycode" }, { "name": "type", "type": "esriFieldTypeString", "alias": "type", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "type" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.Community", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 4, "name": "LitterWatchDB.DBO.Event", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "pk_eventcode", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "pk_eventcode", "type": "esriFieldTypeString", "alias": "pk_eventcode", "domain": null, "editable": false, "nullable": false, "length": 5, "defaultValue": null, "modelName": "pk_eventcode" }, { "name": "fk_beachcode", "type": "esriFieldTypeString", "alias": "fk_beachcode", "domain": null, "editable": false, "nullable": false, "length": 5, "defaultValue": null, "modelName": "fk_beachcode" }, { "name": "fk_communitycode", "type": "esriFieldTypeString", "alias": "fk_communitycode", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "fk_communitycode" }, { "name": "start_date", "type": "esriFieldTypeDate", "alias": "start_date", "domain": null, "editable": false, "nullable": false, "length": 8, "defaultValue": null, "modelName": "start_date" }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "domain": null, "editable": false, "nullable": true, "length": 500, "defaultValue": null, "modelName": "description" }, { "name": "created", "type": "esriFieldTypeDate", "alias": "created", "domain": null, "editable": false, "nullable": false, "length": 8, "defaultValue": null, "modelName": "created" }, { "name": "updated", "type": "esriFieldTypeDate", "alias": "updated", "domain": null, "editable": false, "nullable": false, "length": 8, "defaultValue": null, "modelName": "updated" }, { "name": "fk_user_id", "type": "esriFieldTypeGUID", "alias": "fk_user_id", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": "{00000000-0000-0000-0000-000000000000}", "modelName": "fk_user_id" }, { "name": "itemlist", "type": "esriFieldTypeString", "alias": "itemlist", "domain": null, "editable": false, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "itemlist" }, { "name": "IsPublic", "type": "esriFieldTypeSmallInteger", "alias": "IsPublic", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "IsPublic" }, { "name": "people_attended", "type": "esriFieldTypeInteger", "alias": "people_attended", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "people_attended" }, { "name": "summary", "type": "esriFieldTypeString", "alias": "summary", "domain": null, "editable": false, "nullable": true, "length": 500, "defaultValue": null, "modelName": "summary" }, { "name": "end_date", "type": "esriFieldTypeDate", "alias": "end_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "end_date" }, { "name": "release_date", "type": "esriFieldTypeDate", "alias": "release_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "release_date" }, { "name": "event_type", "type": "esriFieldTypeSmallInteger", "alias": "event_type", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "event_type" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.Event", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 5, "name": "LitterWatchDB.DBO.Item", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "pfk_itemcode", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "pfk_itemcode", "type": "esriFieldTypeInteger", "alias": "pfk_itemcode", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "pfk_itemcode" }, { "name": "itemcount", "type": "esriFieldTypeInteger", "alias": "itemcount", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "itemcount" }, { "name": "pfk_survey_id", "type": "esriFieldTypeGUID", "alias": "pfk_survey_id", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": "{00000000-0000-0000-0000-000000000000}", "modelName": "pfk_survey_id" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.Item", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 6, "name": "LitterWatchDB.DBO.ItemLookup_Desc", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "item_description", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "pfk_item_code", "type": "esriFieldTypeInteger", "alias": "pfk_item_code", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "pfk_item_code" }, { "name": "pfk_language_id", "type": "esriFieldTypeInteger", "alias": "pfk_language_id", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "pfk_language_id" }, { "name": "item_description", "type": "esriFieldTypeString", "alias": "item_description", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "item_description" }, { "name": "item_description_long", "type": "esriFieldTypeString", "alias": "item_description_long", "domain": null, "editable": false, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "item_description_long" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.ItemLookup_Desc", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 7, "name": "LitterWatchDB.DBO.Language", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "pk_language_id", "globalIdField": "", "displayField": "language_description", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "pk_language_id", "type": "esriFieldTypeOID", "alias": "pk_language_id", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "pk_language_id" }, { "name": "language_description", "type": "esriFieldTypeString", "alias": "language_description", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "language_description" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.Language", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 8, "name": "LitterWatchDB.DBO.SURVEY", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Comments", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "fk_user_id", "type": "esriFieldTypeGUID", "alias": "fk_user_id", "domain": null, "editable": false, "nullable": true, "length": 38, "defaultValue": null, "modelName": "fk_user_id" }, { "name": "create_date", "type": "esriFieldTypeDate", "alias": "create_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "create_date" }, { "name": "update_date", "type": "esriFieldTypeDate", "alias": "update_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "update_date" }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": "{00000000-0000-0000-0000-000000000000}", "modelName": "GlobalID" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": false, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Comments" }, { "name": "other_items", "type": "esriFieldTypeString", "alias": "other_items", "domain": null, "editable": false, "nullable": true, "length": 200, "defaultValue": null, "modelName": "other_items" }, { "name": "other_comments", "type": "esriFieldTypeString", "alias": "other_comments", "domain": null, "editable": false, "nullable": true, "length": 200, "defaultValue": null, "modelName": "other_comments" }, { "name": "group_people", "type": "esriFieldTypeInteger", "alias": "group_people", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "group_people" }, { "name": "fk_eventcode", "type": "esriFieldTypeString", "alias": "fk_eventcode", "domain": null, "editable": false, "nullable": false, "length": 5, "defaultValue": null, "modelName": "fk_eventcode" }, { "name": "QualityCheck", "type": "esriFieldTypeSmallInteger", "alias": "QualityCheck", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "QualityCheck" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.SURVEY", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 9, "name": "LitterWatchDB.DBO.social_networks", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "network_id", "globalIdField": "", "displayField": "network_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "network_id", "type": "esriFieldTypeOID", "alias": "network_id", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "network_id" }, { "name": "network_name", "type": "esriFieldTypeString", "alias": "network_name", "domain": null, "editable": false, "nullable": false, "length": 50, "defaultValue": null, "modelName": "network_name" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.social_networks", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 10, "name": "LitterWatchDB.dbo.users", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "username", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "fk_communitycode", "type": "esriFieldTypeString", "alias": "fk_communitycode", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "fk_communitycode" }, { "name": "user_token", "type": "esriFieldTypeString", "alias": "user_token", "domain": null, "editable": false, "nullable": false, "length": 255, "defaultValue": null, "modelName": "user_token" }, { "name": "user_social_network", "type": "esriFieldTypeSmallInteger", "alias": "user_social_network", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "user_social_network" }, { "name": "username", "type": "esriFieldTypeString", "alias": "username", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "username" }, { "name": "countrycode", "type": "esriFieldTypeString", "alias": "countrycode", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "countrycode" }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": "{00000000-0000-0000-0000-000000000000}", "modelName": "GlobalID" }, { "name": "account_status", "type": "esriFieldTypeInteger", "alias": "account_status", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "account_status" }, { "name": "email", "type": "esriFieldTypeString", "alias": "email", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "email" }, { "name": "activation_token", "type": "esriFieldTypeString", "alias": "activation_token", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "activation_token" }, { "name": "registration_time", "type": "esriFieldTypeDate", "alias": "registration_time", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "registration_time" }, { "name": "reset_token", "type": "esriFieldTypeString", "alias": "reset_token", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "reset_token" }, { "name": "reset_expire", "type": "esriFieldTypeDate", "alias": "reset_expire", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "reset_expire" }, { "name": "last_login", "type": "esriFieldTypeDate", "alias": "last_login", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_login" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.dbo.users", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 11, "name": "LitterWatchDB.DBO.ItemLookup", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "generalname", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "pk_itemcode", "type": "esriFieldTypeInteger", "alias": "pk_itemcode", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "pk_itemcode" }, { "name": "fk_category_id", "type": "esriFieldTypeInteger", "alias": "fk_category_id", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "fk_category_id" }, { "name": "generalcode", "type": "esriFieldTypeString", "alias": "generalcode", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "generalcode" }, { "name": "level1_materials", "type": "esriFieldTypeString", "alias": "level1_materials", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "level1_materials" }, { "name": "level2_generaluse", "type": "esriFieldTypeString", "alias": "level2_generaluse", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "level2_generaluse" }, { "name": "level3", "type": "esriFieldTypeString", "alias": "level3", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "level3" }, { "name": "generalname", "type": "esriFieldTypeString", "alias": "generalname", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "generalname" }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "description" }, { "name": "material", "type": "esriFieldTypeString", "alias": "material", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "material" }, { "name": "purpose", "type": "esriFieldTypeString", "alias": "purpose", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "purpose" }, { "name": "usage", "type": "esriFieldTypeString", "alias": "usage", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "usage" }, { "name": "source", "type": "esriFieldTypeString", "alias": "source", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "source" }, { "name": "problem1", "type": "esriFieldTypeString", "alias": "problem1", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "problem1" }, { "name": "problem2", "type": "esriFieldTypeString", "alias": "problem2", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "problem2" }, { "name": "core", "type": "esriFieldTypeInteger", "alias": "core", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "core" }, { "name": "beach", "type": "esriFieldTypeInteger", "alias": "beach", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "beach" }, { "name": "seafloor", "type": "esriFieldTypeInteger", "alias": "seafloor", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "seafloor" }, { "name": "floating", "type": "esriFieldTypeInteger", "alias": "floating", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "floating" }, { "name": "biota", "type": "esriFieldTypeInteger", "alias": "biota", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "biota" }, { "name": "micro", "type": "esriFieldTypeInteger", "alias": "micro", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "micro" }, { "name": "regional", "type": "esriFieldTypeString", "alias": "regional", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "regional" }, { "name": "update_date", "type": "esriFieldTypeDate", "alias": "update_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "update_date" }, { "name": "update_process", "type": "esriFieldTypeString", "alias": "update_process", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "update_process" }, { "name": "IsToplist", "type": "esriFieldTypeSmallInteger", "alias": "IsToplist", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "IsToplist" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.ItemLookup", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 12, "name": "LitterWatchDB.DBO.beach_location", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "beachlocation_description", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "pfk_beachlocation_id", "type": "esriFieldTypeInteger", "alias": "pfk_beachlocation_id", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "pfk_beachlocation_id" }, { "name": "pfk_language_id", "type": "esriFieldTypeInteger", "alias": "pfk_language_id", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "pfk_language_id" }, { "name": "beachlocation_description", "type": "esriFieldTypeString", "alias": "beachlocation_description", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "beachlocation_description" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.beach_location", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 13, "name": "LitterWatchDB.DBO.beach_type", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "beachtype_description", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "pfk_beachtype_id", "type": "esriFieldTypeInteger", "alias": "pfk_beachtype_id", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "pfk_beachtype_id" }, { "name": "pfk_language_id", "type": "esriFieldTypeInteger", "alias": "pfk_language_id", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "pfk_language_id" }, { "name": "beachtype_description", "type": "esriFieldTypeString", "alias": "beachtype_description", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "beachtype_description" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.beach_type", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 14, "name": "LitterWatchDB.DBO.COUNTRY", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "CountryName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CountryCode", "type": "esriFieldTypeString", "alias": "CountryCode", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CountryCode" }, { "name": "CountryName", "type": "esriFieldTypeString", "alias": "CountryName", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CountryName" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LitterWatchDB.DBO.COUNTRY", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 } ] }