{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 46, "name": "Hydrant Inspections", "type": "Table", "description": "DescriptionGIS Staff PublisherStephanie WenHelpdesk Ticket URLhttps://ithelp.grey.ca/a/tickets/23923?current_tab=detailsDescriptionTable containing information on the inspections of hydrants in Georgian Bluffs, gathered in Field Maps.Dataset UsageField MapsData SourceMember municipality Georgian BluffsRecord AttachmentsPhotosRelated TablesGB HydrantsData Criticality2Security ClassificationInternalImportance ClassificationOperationalSensitive DataNoCuratorTom InnesCurator Job TitleOperations CoordinatorCurator Emailtinnes@georgianbluffs.caCurator DepartmentOtherCurator ResponsibilitiesCollect_and_Manage,Maintain,Oversight_Control_AccessMaintenance and Update FrequencyWeeklyUpdate HistoryJul-25Published Map Service(s)Publicly AvailableNot publicly availableOpen DataNot Published to Open DataOffline (sync)Offline (Sync) EnabledOther CommentsPermissionsAssign permissions to map service if published.GroupPermissionsOther DepartmentView,Add,Delete,Update_Attributes,Update_Attibutes_and_GeometryMember Municipality StaffViewGrey County StaffViewPublicRestricted", "copyrightText": null, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "supportsAttachmentsResizing": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Marker", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeInteger", "alias": "Asset ID", "domain": null }, { "name": "Marker", "type": "esriFieldTypeString", "alias": "Marker Installed", "length": 255, "domain": { "type": "codedValue", "name": "Yes/No", "description": "Gives Yes or No for columns", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MarkerType", "type": "esriFieldTypeString", "alias": "Marker Type", "length": 255, "domain": { "type": "codedValue", "name": "Hydrant Marker Material", "description": "Type of marker material used for hydrants", "codedValues": [ { "name": "Plastic", "code": "Plastic" }, { "name": "Steel", "code": "Steel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 255, "domain": null }, { "name": "AccessMaintained", "type": "esriFieldTypeString", "alias": "Access Maintained", "length": 255, "domain": { "type": "codedValue", "name": "Hydrant Maintenance Type", "description": "Type of maintenance for hydrant inspections", "codedValues": [ { "name": "Brushing", "code": "Brushing" }, { "name": "Mowing", "code": "Mowing" }, { "name": "Trimming", "code": "Trimming" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RequiresPainting", "type": "esriFieldTypeString", "alias": "Requires Painting", "length": 255, "domain": { "type": "codedValue", "name": "Yes/No", "description": "Gives Yes or No for columns", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "ParentGUID", "type": "esriFieldTypeGUID", "alias": "ParentGUID", "length": 38, "domain": null } ], "indexes": [ { "name": "R143_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_143", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_990_ParentGU", "fields": "ParentGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GB_Hydrants", "relatedTableId": 44, "role": "esriRelRoleDestination", "keyField": "ParentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{2B6F3049-5800-43B2-ACF7-309C542289D6}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "07cfc99123274dc8a4dc6360b8dfbf4c" }