{ "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
}
]
}