{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 53, "name": "Culvert Inspections", "type": "Table", "description": "DescriptionGIS Staff PublisherStephanie WenHelpdesk Ticket URLhttps://ithelp.grey.ca/a/tickets/29763DescriptionIncludes, Driveway Culverts, GSCA Culverts, Storm Culverts, Utility Box Culverts, Road Culverts, Golf Course Culverts, etc.Dataset UsageVertiGIS, Culvert inspections, Culvert comparison app.Data SourceMember municipality Municipality of Georgian BluffsRecord AttachmentsRelated TablesData Criticality3Security ClassificationInternalImportance ClassificationOperationalSensitive DataYesCuratorBrian AndersonCurator Job TitleAsset Management CoordinatorCurator Emailbanderson@georgianbluffs.caCurator DepartmentOtherCurator ResponsibilitiesCollect_and_Manage,MaintainMaintenance and Update FrequencyWeeklyUpdate History20250725Published Map Service(s)Service_GeorgianBluffs_CulvertInspectionsPublicly AvailableNot publicly availableOpen DataNot Published to Open DataOffline (sync)Not OfflineOther CommentsPermissionsAssign permissions to map service if published.GroupPermissionsOther DepartmentRestrictedMember Municipality StaffView,Add,Delete,Update_Attributes,Update_Attibutes_and_GeometryGrey County StaffRestrictedPublicRestrictedOBJECTIDDo Not DisplayCULVERT_IDDisplayROAD_SEGMENTDisplay - Is it possible to pull in the nearest road segment? This will work >95% of the timeASSET_NAMEDisplayCULVERT_SHAPEDisplayMATERIALDisplayNUMBER_OF_ SPANSDisplayDIA (MM)DisplayWIDTH (MM)DisplayHEIGHT (MM)DisplayLENGTH (M)DisplayPERCHED_HT (MM)DisplayCENTRELINE_ELEVATIONDisplayN/S/E/W_INVERTDisplayBURIED_DEPTH_DisplayINVERT_ELEVATION_1Calculation? - As per Jerry's notes is this possible to be calculated based on Centreline_elevation and Buried_Depth?N/S/E/W_ INVERT2DisplayBURIED_DEPTH_2DisplayINVERT_ELEVATION_2Calculation? - As per Jerry's notes is this possible to be calculated based on Centreline_elevation and Buried_Depth?GSCA_IDKeep - Do Not DisplayAssetNOKeep - Do Not DisplayMain_WaterKeep - Do Not DisplayWatercouseKeep - Do Not DisplaySubwatershKeep - Do Not DisplayOrder_4_SuKeep - Do Not DisplayOrder_5_SuKeep - Do Not DisplayOrder_6_SuKeep - Do Not DisplayType of WatercourseKeep - Do Not DisplayStream_WidKeep - Do Not DisplayUTM_EastinKeep - Do Not DisplayUTM_NorthiKeep - Do Not DisplayProper_NamKeep All - Filter Down To Just Township Owned (Considering the work, best to keep all if needed for future storm water management studies)Crossing_cKeep - Do Not DisplayglobalidKeep - Do Not DisplayGB Culvert #Keep - Do Not DisplayPart of a municipal drain?Displaycreated_userPlease Advise - I Don't Think We Needcreated_datePlease Advise - I Don't Think We Needlast_edited_userPlease Advise - I think we should in the backgroundlast_edited_datePlease Advise - I think we should in the backgroundLatitudeKeep - Do Not DisplayLongitudeKeep - Do Not DisplayMERGE_SRCPlease Advise - I Don't Think We Need", "copyrightText": null, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "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": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "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": "Road_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CULVERT_ID", "type": "esriFieldTypeSmallInteger", "alias": "CULVERT_ID", "domain": null }, { "name": "CulvertLocation", "type": "esriFieldTypeString", "alias": "Culvert Location", "length": 255, "domain": { "type": "codedValue", "name": "Location", "description": "", "codedValues": [ { "name": "Entrance", "code": "Ent" }, { "name": "Center Line", "code": "CL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CulvertType", "type": "esriFieldTypeString", "alias": "Culvert Type", "length": 255, "domain": { "type": "codedValue", "name": "CulvertType", "description": "Culvert Type", "codedValues": [ { "name": "Road Culvert", "code": "Road Culvert" }, { "name": "Cross Culvert", "code": "Cross Culvert" }, { "name": "Culvert", "code": "Culvert" }, { "name": "Driveway Culvert", "code": "Driveway Culvert" }, { "name": "Farm Culvert", "code": "Farm Culvert" }, { "name": "Fire Hydrant Culvert", "code": "Fire Hydrant Culvert" }, { "name": "Golf Course Hydrant", "code": "Golf Course Hydrant" }, { "name": "Lawn Culvert", "code": "Lawn Culvert" }, { "name": "Retension Pond Grate", "code": "Retension Pond Grate" }, { "name": "Road Cross Culvert", "code": "Road Cross Culvert" }, { "name": "Major Road Culvert", "code": "Major Road Culvert" }, { "name": "Trail Culvert", "code": "Trail Culvert" }, { "name": "Utility Box Culvert", "code": "Utility Box Culvert" }, { "name": "Walkaway Culvert", "code": "Walkaway Culvert" }, { "name": "Yard Culvert", "code": "Yard Culvert" }, { "name": "Storm Culvert", "code": "Storm Culvert" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CulvertOther", "type": "esriFieldTypeString", "alias": "Culvert Other", "length": 255, "domain": null }, { "name": "CulvertMaterial", "type": "esriFieldTypeString", "alias": "Culvert Material", "length": 255, "domain": { "type": "codedValue", "name": "Material", "description": "Material for Culvert Inspections", "codedValues": [ { "name": "Metal", "code": "M" }, { "name": "Plastic", "code": "P" }, { "name": "Box Beam Bridge", "code": "Box Beam Bridge" }, { "name": "CIP Concrete", "code": "CIP Concrete" }, { "name": "Conc", "code": "Conc" }, { "name": "Concrete Girder Bridge", "code": "Concrete Girder Bridge" }, { "name": "Concrete Rigid Frame", "code": "Concrete Rigid Frame" }, { "name": "Concrete Rigid Frame - CIP", "code": "Concrete Rigid Frame - CIP" }, { "name": "CSP", "code": "CSP" }, { "name": "Double CSP Culvert", "code": "Double CSP Culvert" }, { "name": "Double SPCSP", "code": "Double SPCSP" }, { "name": "Open Bottom", "code": "Open Bottom" }, { "name": "Open Bottom Concrete Culvert", "code": "Open Bottom Concrete Culvert" }, { "name": "Poly", "code": "Poly" }, { "name": "Precast Concrete Girders", "code": "Precast Concrete Girders" }, { "name": "Quadruple CSP Culvert", "code": "Quadruple CSP Culvert" }, { "name": "Rigid Frame", "code": "Rigid Frame" }, { "name": "Rigid Frame Box Culvert", "code": "Rigid Frame Box Culvert" }, { "name": "SPCSP Culvert", "code": "SPCSP Culvert" }, { "name": "SPCSP on Concrete Foundation", "code": "SPCSP on Concrete Foundation" }, { "name": "Steel & Concrete Girder Bridge", "code": "Steel & Concrete Girder Bridge" }, { "name": "Steel Girder Bridge", "code": "Steel Girder Bridge" }, { "name": "Triple CSP Culvert", "code": "Triple CSP Culvert" }, { "name": "Twin CSP ", "code": "Twin CSP " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Diameter_mm", "type": "esriFieldTypeDouble", "alias": "Diameter (mm)", "domain": null }, { "name": "DepthOfCover_m", "type": "esriFieldTypeDouble", "alias": "Depth of Cover (m)", "domain": null }, { "name": "WaterInCulvert", "type": "esriFieldTypeDouble", "alias": "% water in culvert", "domain": null }, { "name": "Collapsed", "type": "esriFieldTypeString", "alias": "Collapsed?", "length": 255, "domain": { "type": "codedValue", "name": "FullPartial", "description": "Full or Partial", "codedValues": [ { "name": "Full", "code": "F" }, { "name": "Partial", "code": "P" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BottomRustedOut", "type": "esriFieldTypeString", "alias": "Bottom Rusted Out?", "length": 255, "domain": { "type": "codedValue", "name": "FullPartial", "description": "Full or Partial", "codedValues": [ { "name": "Full", "code": "F" }, { "name": "Partial", "code": "P" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Blocked", "type": "esriFieldTypeString", "alias": "Blocked?", "length": 255, "domain": { "type": "codedValue", "name": "FullPartial", "description": "Full or Partial", "codedValues": [ { "name": "Full", "code": "F" }, { "name": "Partial", "code": "P" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Buried", "type": "esriFieldTypeString", "alias": "Buried?", "length": 255, "domain": { "type": "codedValue", "name": "FullPartial", "description": "Full or Partial", "codedValues": [ { "name": "Full", "code": "F" }, { "name": "Partial", "code": "P" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CivicAddress", "type": "esriFieldTypeString", "alias": "Civic Address", "length": 255, "domain": null }, { "name": "Road_Name", "type": "esriFieldTypeString", "alias": "Road_Name", "length": 255, "domain": null }, { "name": "InspectorName", "type": "esriFieldTypeString", "alias": "Inspector Name", "length": 255, "domain": null }, { "name": "DateOfInspection", "type": "esriFieldTypeDate", "alias": "Date Of Inspection", "length": 8, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 500, "domain": null }, { "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 }, { "name": "Inspection_Year", "type": "esriFieldTypeSmallInteger", "alias": "Inspection_Year", "domain": null }, { "name": "N_S_E_W_INVERT", "type": "esriFieldTypeString", "alias": "N/S/E/W_INVERT", "length": 255, "domain": { "type": "codedValue", "name": "Direction", "description": "Roadside Directions for ditch and road surface inspections.", "codedValues": [ { "name": "North", "code": "N" }, { "name": "East", "code": "E" }, { "name": "South", "code": "S" }, { "name": "West", "code": "W" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BURIED_DEPTH", "type": "esriFieldTypeDouble", "alias": "BURIED_DEPTH", "domain": null }, { "name": "N_S_E_W__INVERT2", "type": "esriFieldTypeString", "alias": "N/S/E/W_ INVERT2", "length": 255, "domain": { "type": "codedValue", "name": "Direction", "description": "Roadside Directions for ditch and road surface inspections.", "codedValues": [ { "name": "North", "code": "N" }, { "name": "East", "code": "E" }, { "name": "South", "code": "S" }, { "name": "West", "code": "W" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BURIED_DEPTH_2", "type": "esriFieldTypeDouble", "alias": "BURIED_DEPTH_2", "domain": null } ], "indexes": [ { "name": "R156_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_156", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1007_parentG", "fields": "parentGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "SDE.GB_Culverts", "relatedTableId": 47, "role": "esriRelRoleDestination", "keyField": "parentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{5CF0EB6D-519F-4741-90C6-F33BCC91802D}" } ], "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" }