{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "Litter Receptacle", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "

Locations of litter receptacles in Strathcona County. Attachments are enabled to attach photos of the litter receptacle, and <\/SPAN>there are also additional related tables to store information for service and maintenance events. <\/SPAN><\/SPAN><\/P>

<\/P>

<\/P><\/DIV><\/DIV><\/DIV>", "copyrightText": "Recreation, Parks and Culture, Strathcona County", "editFieldsInfo": { "creationDateField": "CreatedOn", "creatorField": "CreatedBy", "editDateField": "ModifiedOn", "editorField": "ModifiedBy" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "Litter_Service_Event", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": true, "catalogID": "{2F5B8A26-ED1C-4AE4-BCB0-21DAA39E224E}" }, { "id": 2, "name": "Litter_Maintenance_Event", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": true, "catalogID": "{E76EF193-6E71-4792-87D2-E9C432D5FDBE}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "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, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "extent": { "xmin": 41824.984899999574, "ymin": 5917011.336959771, "xmax": 73870.57830000017, "ymax": 5954057.943381157, "spatialReference": { "wkid": 102187, "latestWkid": 3776, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5622600, "falseY": -10001100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 102187, "latestWkid": 3776, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5622600, "falseY": -10001100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 102187, "latestWkid": 3776, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5622600, "falseY": -10001100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 156, 156, 156, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "LitterReceptacleID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "LitterReceptacleID", "type": "esriFieldTypeInteger", "alias": "Litter Receptacle ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LitterReceptacleID" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Location" }, { "name": "ParkID", "type": "esriFieldTypeInteger", "alias": "Park ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ParkID" }, { "name": "ContainerType", "type": "esriFieldTypeString", "alias": "Container Type", "domain": { "type": "codedValue", "name": "Litter_Container_Type", "description": "Type of litter receptacle", "codedValues": [ { "name": "Architectural", "code": "Architectural" }, { "name": "Barrel", "code": "Barrel" }, { "name": "Combination", "code": "Combination" }, { "name": "Recycle", "code": "Recycle" }, { "name": "Wood Slat", "code": "Wood Slat" }, { "name": "Other", "code": "Other" }, { "name": "Organic", "code": "Organic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ContainerType" }, { "name": "InstallType", "type": "esriFieldTypeString", "alias": "Install Type", "domain": { "type": "codedValue", "name": "Litter_Install_Type", "description": "How is the litter receptacle installed", "codedValues": [ { "name": "Piling Anchors", "code": "Piling Anchors" }, { "name": "Screw Anchors", "code": "Screw Anchors" }, { "name": "Post in Hole", "code": "Post in Hole" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "InstallType" }, { "name": "ServicingResponsibility", "type": "esriFieldTypeString", "alias": "Servicing Responsibility", "domain": { "type": "codedValue", "name": "Litter_Responsibility", "description": "Responsibility for litter control", "codedValues": [ { "name": "Turf Maintenance", "code": "Turf Maintenance" }, { "name": "Other", "code": "Other" }, { "name": "Mowing and Waste Diversion", "code": "Mowing and Waste Diversion" }, { "name": "Broadmoor Golf Course", "code": "Broadmoor Golf Course" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ServicingResponsibility" }, { "name": "LitterRoute", "type": "esriFieldTypeString", "alias": "Litter Route", "domain": { "type": "codedValue", "name": "Litter_Route", "description": "Type of route for litter control", "codedValues": [ { "name": "Open Space", "code": "Open Space" }, { "name": "Roadways", "code": "Roadways" }, { "name": "Facility", "code": "Facility" }, { "name": "Organic", "code": "Organic" }, { "name": "Recycle", "code": "Recycle" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LitterRoute" }, { "name": "SummerFrequency", "type": "esriFieldTypeString", "alias": "Summer Frequency", "domain": { "type": "codedValue", "name": "Litter_Frequency", "description": "Frequency of litter pickup for litter control", "codedValues": [ { "name": "Weekly", "code": "Weekly" }, { "name": "Enhanced", "code": "Enhanced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SummerFrequency" }, { "name": "WinterFrequency", "type": "esriFieldTypeString", "alias": "Winter Frequency", "domain": { "type": "codedValue", "name": "Litter_Frequency", "description": "Frequency of litter pickup for litter control", "codedValues": [ { "name": "Weekly", "code": "Weekly" }, { "name": "Enhanced", "code": "Enhanced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "WinterFrequency" }, { "name": "Plaque", "type": "esriFieldTypeString", "alias": "Plaque", "domain": { "type": "codedValue", "name": "YESNO_Text_duplicate", "description": "A Yes/No Text domain with a duplicate split domain policy", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Plaque" }, { "name": "BoardMaterial", "type": "esriFieldTypeString", "alias": "Board Material", "domain": { "type": "codedValue", "name": "Litter_Board_Material", "description": "Type of litter board material", "codedValues": [ { "name": "Wood", "code": "Wood" }, { "name": "Composite", "code": "Composite" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "BoardMaterial" }, { "name": "BoardCondition", "type": "esriFieldTypeString", "alias": "Board Condition", "domain": { "type": "codedValue", "name": "Parks_Condition_NA_text", "description": "Condition of a parks asset, text not numeric", "codedValues": [ { "name": "1 - Excellent", "code": "1 - Excellent" }, { "name": "2 - Good", "code": "2 - Good" }, { "name": "3 - Fair", "code": "3 - Fair" }, { "name": "4 - Poor", "code": "4 - Poor" }, { "name": "5 - Very Poor", "code": "5 - Very Poor" }, { "name": "Not applicable", "code": "Not applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "BoardCondition" }, { "name": "ParkDevOverallCondition", "type": "esriFieldTypeString", "alias": "Park Dev Overall Condition", "domain": { "type": "codedValue", "name": "Parks_Condition_text", "description": "Condition of a parks asset, text not numeric (no N/A)", "codedValues": [ { "name": "1 - Excellent", "code": "1 - Excellent" }, { "name": "2 - Good", "code": "2 - Good" }, { "name": "3 - Fair", "code": "3 - Fair" }, { "name": "4 - Poor", "code": "4 - Poor" }, { "name": "5 - Very Poor", "code": "5 - Very Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "ParkDevOverallCondition" }, { "name": "TurfMaintOverallCondition", "type": "esriFieldTypeString", "alias": "Turf Maint Overall Condition", "domain": { "type": "codedValue", "name": "Parks_Condition_text", "description": "Condition of a parks asset, text not numeric (no N/A)", "codedValues": [ { "name": "1 - Excellent", "code": "1 - Excellent" }, { "name": "2 - Good", "code": "2 - Good" }, { "name": "3 - Fair", "code": "3 - Fair" }, { "name": "4 - Poor", "code": "4 - Poor" }, { "name": "5 - Very Poor", "code": "5 - Very Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "TurfMaintOverallCondition" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Litter_Status", "description": "Status of litter bins for litter control", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "De-activated", "code": "De-activated" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Status" }, { "name": "YearInstalled", "type": "esriFieldTypeSmallInteger", "alias": "Year Installed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YearInstalled" }, { "name": "ReplacementDate", "type": "esriFieldTypeDate", "alias": "Replacement Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ReplacementDate" }, { "name": "LastInspected", "type": "esriFieldTypeDate", "alias": "Last Inspected", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastInspected" }, { "name": "InspectedBy", "type": "esriFieldTypeString", "alias": "Inspected By", "domain": { "type": "codedValue", "name": "Parks_ParkDev_Inspectors", "description": "List of RPC Park Development inspectors", "codedValues": [ { "name": "Brad Carvery", "code": "Brad Carvery" }, { "name": "Brent Gauvreau", "code": "Brent Gauvreau" }, { "name": "Cathy Reed", "code": "Cathy Reed" }, { "name": "Cole Minchinton", "code": "Cole Minchinton" }, { "name": "Dan McLachlin", "code": "Dan McLachlin" }, { "name": "Daniel Bunzenmeyer", "code": "Daniel Bunzenmeyer" }, { "name": "Dylan Kelly", "code": "Dylan Kelly" }, { "name": "George Rudiak", "code": "George Rudiak" }, { "name": "Jeff Caine", "code": "Jeff Caine" }, { "name": "Kalin Dyrland", "code": "Kalin Dyrland" }, { "name": "Katie Dyrland", "code": "Katie Dyrland" }, { "name": "Kelly Kennedy", "code": "Kelly Kennedy" }, { "name": "Kevin Karlowich", "code": "Kevin Karlowich" }, { "name": "Kristian Fleischauer", "code": "Kristian Fleischauer" }, { "name": "Kyle Serrick", "code": "Kyle Serrick" }, { "name": "Michelle Cook", "code": "Michelle Cook" }, { "name": "Tylan Dannish", "code": "Tylan Dannish" }, { "name": "Tyson Newman", "code": "Tyson Newman" }, { "name": "Wayne Gulka", "code": "Wayne Gulka" }, { "name": "Wayne Niedzielski", "code": "Wayne Niedzielski" }, { "name": "Shawn Crosby", "code": "Shawn Crosby" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "InspectedBy" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Comments" }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "Created By", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CreatedBy" }, { "name": "CreatedOn", "type": "esriFieldTypeDate", "alias": "Created On", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreatedOn" }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "Modified By", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ModifiedBy" }, { "name": "ModifiedOn", "type": "esriFieldTypeDate", "alias": "Modified On", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ModifiedOn" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "ParkName", "type": "esriFieldTypeString", "alias": "Park Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ParkName" }, { "name": "SideWireRack", "type": "esriFieldTypeString", "alias": "Side Wire Rack", "domain": { "type": "codedValue", "name": "YESNO_Text_duplicate", "description": "A Yes/No Text domain with a duplicate split domain policy", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SideWireRack" }, { "name": "RouteOrder", "type": "esriFieldTypeInteger", "alias": "Route Order", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RouteOrder" }, { "name": "EnhancedOrder", "type": "esriFieldTypeInteger", "alias": "Enhanced Order", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EnhancedOrder" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R431_pk", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_431", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" }, { "name": "S272_idx", "isAscending": true, "isUnique": true, "description": "", "fields": "Shape" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Litter Receptacle", "description": "", "prototype": { "attributes": { "RouteOrder": null, "SideWireRack": null, "LitterReceptacleID": null, "Location": null, "ParkID": null, "ContainerType": null, "InstallType": null, "ServicingResponsibility": null, "LitterRoute": null, "SummerFrequency": null, "WinterFrequency": null, "Plaque": null, "BoardMaterial": null, "BoardCondition": null, "ParkDevOverallCondition": null, "TurfMaintOverallCondition": null, "Status": null, "YearInstalled": null, "ReplacementDate": null, "LastInspected": null, "InspectedBy": null, "Comments": null, "ParkName": null, "EnhancedOrder": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "Litter_Service_Event", "type": "Table", "description": "This table contains server records on litter receptacles in Strathcona County. The join is based on the litter receptacle Global ID.", "copyrightText": "Recreation, Parks and Culture, Strathcona County", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "Litter_Receptacle", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentGUID", "composite": true, "catalogID": "{2F5B8A26-ED1C-4AE4-BCB0-21DAA39E224E}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Date", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ParentGUID", "type": "esriFieldTypeGUID", "alias": "Parent GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "ParentGUID" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Service Event Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "CompletedBy", "type": "esriFieldTypeString", "alias": "Completed By", "domain": { "type": "codedValue", "name": "Parks_TurfMaint_Staff", "description": "List of RPC Turf Maintenance staff", "codedValues": [ { "name": "Candace Moir", "code": "Candace Moir" }, { "name": "Kris Eskelson", "code": "Kris Eskelson" }, { "name": "Murray Fikowski", "code": "Murray Fikowski" }, { "name": "Colten Larsen", "code": "Colten Larsen" }, { "name": "Kyle Eskelson", "code": "Kyle Eskelson" }, { "name": "Nick Harder", "code": "Nick Harder" }, { "name": "Amber Weber", "code": "Amber Weber" }, { "name": "Nathan Ewasiuk", "code": "Nathan Ewasiuk" }, { "name": "Kurtis VanSteenbergen", "code": "Kurtis VanSteenbergen" }, { "name": "Rebeca Gibson", "code": "Rebeca Gibson" }, { "name": "Max Atchison", "code": "Max Atchison" }, { "name": "Ava Schultz", "code": "Ava Schultz" }, { "name": "Amy Malo", "code": "Amy Malo" }, { "name": "Tyler Parker", "code": "Tyler Parker" }, { "name": "Dan Simons", "code": "Dan Simons" }, { "name": "Drake Kremer", "code": "Drake Kremer" }, { "name": "Kathleen Peckham", "code": "Kathleen Peckham" }, { "name": "Cam Reagan", "code": "Cam Reagan" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "CompletedBy" }, { "name": "BagRemoved", "type": "esriFieldTypeString", "alias": "Bag Removed", "domain": { "type": "codedValue", "name": "YESNO_Text_duplicate", "description": "A Yes/No Text domain with a duplicate split domain policy", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "No", "modelName": "BagRemoved" }, { "name": "RequestedService", "type": "esriFieldTypeString", "alias": "Requested Service", "domain": { "type": "codedValue", "name": "YESNO_Text_duplicate", "description": "A Yes/No Text domain with a duplicate split domain policy", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "No", "modelName": "RequestedService" }, { "name": "UnauthorizedDisposal", "type": "esriFieldTypeString", "alias": "Unauthorized Disposal", "domain": { "type": "codedValue", "name": "YESNO_Text_duplicate", "description": "A Yes/No Text domain with a duplicate split domain policy", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "No", "modelName": "UnauthorizedDisposal" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Comments" } ], "indexes": [ { "name": "R433_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "GDB_5641_ParentG", "isAscending": true, "isUnique": false, "description": "", "fields": "ParentGUID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Litter_Service_Event", "description": "", "prototype": { "attributes": { "UnauthorizedDisposal": "No", "ParentGUID": null, "Date": null, "CompletedBy": null, "BagRemoved": "No", "RequestedService": "No", "Comments": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 3, "name": "Litter_Maintenance_Event", "type": "Table", "description": "This table contains maintenance records on litter receptacles in Strathcona County. The join is based on the litter receptacle Global ID.", "copyrightText": "Recreation, Parks and Culture, Strathcona County", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "Litter_Receptacle", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentGUID", "composite": true, "catalogID": "{E76EF193-6E71-4792-87D2-E9C432D5FDBE}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Date", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ParentGUID", "type": "esriFieldTypeGUID", "alias": "Parent GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "ParentGUID" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Maintenance Event Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "CompletedBy", "type": "esriFieldTypeString", "alias": "Completed By", "domain": { "type": "codedValue", "name": "Parks_TurfMaint_Staff", "description": "List of RPC Turf Maintenance staff", "codedValues": [ { "name": "Candace Moir", "code": "Candace Moir" }, { "name": "Kris Eskelson", "code": "Kris Eskelson" }, { "name": "Murray Fikowski", "code": "Murray Fikowski" }, { "name": "Colten Larsen", "code": "Colten Larsen" }, { "name": "Kyle Eskelson", "code": "Kyle Eskelson" }, { "name": "Nick Harder", "code": "Nick Harder" }, { "name": "Amber Weber", "code": "Amber Weber" }, { "name": "Nathan Ewasiuk", "code": "Nathan Ewasiuk" }, { "name": "Kurtis VanSteenbergen", "code": "Kurtis VanSteenbergen" }, { "name": "Rebeca Gibson", "code": "Rebeca Gibson" }, { "name": "Max Atchison", "code": "Max Atchison" }, { "name": "Ava Schultz", "code": "Ava Schultz" }, { "name": "Amy Malo", "code": "Amy Malo" }, { "name": "Tyler Parker", "code": "Tyler Parker" }, { "name": "Dan Simons", "code": "Dan Simons" }, { "name": "Drake Kremer", "code": "Drake Kremer" }, { "name": "Kathleen Peckham", "code": "Kathleen Peckham" }, { "name": "Cam Reagan", "code": "Cam Reagan" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "CompletedBy" }, { "name": "LidReplacement", "type": "esriFieldTypeString", "alias": "Lid Replacement", "domain": { "type": "codedValue", "name": "YESNO_Text_duplicate", "description": "A Yes/No Text domain with a duplicate split domain policy", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "No", "modelName": "LidReplacement" }, { "name": "BarrelReplacement", "type": "esriFieldTypeString", "alias": "Barrel Replacement", "domain": { "type": "codedValue", "name": "YESNO_Text_duplicate", "description": "A Yes/No Text domain with a duplicate split domain policy", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "No", "modelName": "BarrelReplacement" }, { "name": "Reattachment", "type": "esriFieldTypeString", "alias": "Reattachment", "domain": { "type": "codedValue", "name": "YESNO_Text_duplicate", "description": "A Yes/No Text domain with a duplicate split domain policy", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "No", "modelName": "Reattachment" }, { "name": "Graffiti", "type": "esriFieldTypeString", "alias": "Graffiti", "domain": { "type": "codedValue", "name": "YESNO_Text_duplicate", "description": "A Yes/No Text domain with a duplicate split domain policy", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "No", "modelName": "Graffiti" }, { "name": "Other", "type": "esriFieldTypeString", "alias": "Other", "domain": { "type": "codedValue", "name": "YESNO_Text_duplicate", "description": "A Yes/No Text domain with a duplicate split domain policy", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "No", "modelName": "Other" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Comments" } ], "indexes": [ { "name": "R434_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "GDB_5642_ParentG", "isAscending": true, "isUnique": false, "description": "", "fields": "ParentGUID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Litter_Maintenance_Event", "description": "", "prototype": { "attributes": { "Other": "No", "ParentGUID": null, "Date": null, "CompletedBy": null, "LidReplacement": "No", "BarrelReplacement": "No", "Reattachment": "No", "Graffiti": "No", "Comments": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 } ] }