{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 4, "name": "Playing Fields - Maintenance", "type": "Table", "description": "The \u201cPlaying Fields Maintenance\u201d table is used to store records of maintenance activities undertaken on playing fields in Strathcona County by Recreation, Parks and Culture. The records contain information on the type of maintenance activity completed, start and end dates and times, person who completed the work, comments and allows for photo attachments to be used as needed.\u201cPlaying Fields\" are outdoor areas of land covered in grass and/or loose shale designed to facilitate organized and unorganized recreation that are owned or maintained by Strathcona County. These areas are commonly sport fields with designated boundaries for particular activities (i.e. soccer field) but can also allow general recreation and may not have specific visible boundaries on-site. It includes the bounds of the area as designated by Strathcona County and are always within a 'Park'. These typically include soccer field, football fields and baseball diamonds. Similar items excluded include Basketball Courts and outdoor rinks.", "copyrightText": "Data Steward: Recreation, Parks and Culture, Strathcona County\nData Custodian: Information Technology Services, GIS Branch, Strathcona County", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "Playing Field", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentGlobalID", "composite": false, "catalogID": "{5DCB8935-5C9B-49CA-BE5E-AA6EC604C280}" } ], "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": [], "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "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": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "MaintenanceType", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "MaintenanceType", "type": "esriFieldTypeString", "alias": "Maintenance Type", "domain": { "type": "codedValue", "name": "PlayingFieldMaintenance_Type", "description": "Maintenance Type text domain for Playing Fields FC related Maintenance table", "codedValues": [ { "name": "Slice Aerate", "code": "Slice Aerate" }, { "name": "Core Aerate", "code": "Core Aerate" }, { "name": "Deeptine Aerate", "code": "Deeptine Aerate" }, { "name": "Top dress", "code": "Top dress" }, { "name": "Seed", "code": "Seed" }, { "name": "Fertilize", "code": "Fertilize" }, { "name": "Turf Sweep", "code": "Turf Sweep" }, { "name": "Soil Test", "code": "Soil Test" }, { "name": "Goal Mouth Replacement", "code": "Goal Mouth Replacement" }, { "name": "De-thatch", "code": "De-thatch" }, { "name": "Line painting", "code": "Line painting" }, { "name": "Broadleaf Weed Count", "code": "Broadleaf Weed Count" }, { "name": "Baseball Drag Matting", "code": "Baseball Drag Matting" }, { "name": "Baseball Tine Groom", "code": "Baseball Tine Groom" }, { "name": "Baseball Mound Repair", "code": "Baseball Mound Repair" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "MaintenanceType" }, { "name": "DateStarted", "type": "esriFieldTypeDate", "alias": "Date (Started)", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "DateStarted" }, { "name": "DateEnded", "type": "esriFieldTypeDate", "alias": "Date (Ended)", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "DateEnded" }, { "name": "CompletedBy", "type": "esriFieldTypeString", "alias": "Completed By", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "CompletedBy" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Comments" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "Last Edited User", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "Last Edited Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "Global ID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "ParentGlobalID", "type": "esriFieldTypeGUID", "alias": "Parent Global ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "ParentGlobalID" } ], "indexes": [ { "name": "R485_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_485", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" }, { "name": "GDB_6071_ParentG", "isAscending": true, "isUnique": false, "description": "", "fields": "ParentGlobalID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Playing Fields - Maintenance", "description": "", "prototype": { "attributes": { "ParentGlobalID": null, "MaintenanceType": " ", "DateStarted": -2209161600000, "DateEnded": -2209161600000, "CompletedBy": " ", "Comments": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Update,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "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": "Attachment ID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "Global ID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "Attachment 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": 1000, "maxRecordCountFactor": 1 }