Name: Culvert Inspections

Display Field: Road_Name

Type: Table

Geometry Type: N/A

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

Service Item Id: 07cfc99123274dc8a4dc6360b8dfbf4c

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CULVERT_ID ( type: esriFieldTypeSmallInteger, alias: CULVERT_ID )
• CulvertLocation ( type: esriFieldTypeString, alias: Culvert Location, length: 255 , Coded Values: [Ent: Entrance] , [CL: Center Line] )
• CulvertType ( type: esriFieldTypeString, alias: Culvert Type, length: 255 , Coded Values: [Road Culvert: Road Culvert] , [Cross Culvert: Cross Culvert] , [Culvert: Culvert] , ...14 more... )
• CulvertOther ( type: esriFieldTypeString, alias: Culvert Other, length: 255 )
• CulvertMaterial ( type: esriFieldTypeString, alias: Culvert Material, length: 255 , Coded Values: [M: Metal] , [P: Plastic] , [Box Beam Bridge: Box Beam Bridge] , ...21 more... )
• Diameter_mm ( type: esriFieldTypeDouble, alias: Diameter (mm) )
• DepthOfCover_m ( type: esriFieldTypeDouble, alias: Depth of Cover (m) )
• WaterInCulvert ( type: esriFieldTypeDouble, alias: % water in culvert )
• Collapsed ( type: esriFieldTypeString, alias: Collapsed?, length: 255 , Coded Values: [F: Full] , [P: Partial] )
• BottomRustedOut ( type: esriFieldTypeString, alias: Bottom Rusted Out?, length: 255 , Coded Values: [F: Full] , [P: Partial] )
• Blocked ( type: esriFieldTypeString, alias: Blocked?, length: 255 , Coded Values: [F: Full] , [P: Partial] )
• Buried ( type: esriFieldTypeString, alias: Buried?, length: 255 , Coded Values: [F: Full] , [P: Partial] )
• CivicAddress ( type: esriFieldTypeString, alias: Civic Address, length: 255 )
• Road_Name ( type: esriFieldTypeString, alias: Road_Name, length: 255 )
• InspectorName ( type: esriFieldTypeString, alias: Inspector Name, length: 255 )
• DateOfInspection ( type: esriFieldTypeDate, alias: Date Of Inspection, length: 8 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 500 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• parentGUID ( type: esriFieldTypeGUID, alias: parentGUID, length: 38 )
• Inspection_Year ( type: esriFieldTypeSmallInteger, alias: Inspection_Year )
• N_S_E_W_INVERT ( type: esriFieldTypeString, alias: N/S/E/W_INVERT, length: 255 , Coded Values: [N: North] , [E: East] , [S: South] , ...1 more... )
• BURIED_DEPTH ( type: esriFieldTypeDouble, alias: BURIED_DEPTH )
• N_S_E_W__INVERT2 ( type: esriFieldTypeString, alias: N/S/E/W_ INVERT2, length: 255 , Coded Values: [N: North] , [E: East] , [S: South] , ...1 more... )
• BURIED_DEPTH_2 ( type: esriFieldTypeDouble, alias: BURIED_DEPTH_2 )

Relationships:

• SDE.GB_Culverts (1) -- Related To: Culvert (47)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata