Description: FIELD_NAMEFIELD_TYPECOMMENTOBJECTID_1OIDSHAPEGeometryPointOBJECTIDIntegerCurrent asset IDCB_TYPEStringCatch basin type e.g. 'Single' or 'Double.' Values including the text 'RYCB' identify features that are rear yard catch basinsCB_SIZEStringNominal size e.g. 'Large' or 'Small'DESRIPTIONStringCB_GRATEStringDescription of grateCommentStringNote 'Est install spatial join' identifies records where estimated install date was obtained from the oldest install date from intersecting storm mainsT_GDoubleTop grade. Usually obtained from design drawingN_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersE_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersS_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersW_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersNE_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersSE_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersSW_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersNW_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersStreetStringINSTALL_YEARDateInstall year formatted as YYYY-MM-DDEST_INSTALL_YEARSmallIntegerEstimated install year formatted as YYYYEX_CB_to_SANStringI believe this field was previously used to identified combined sewers which have since been exported into the EX_CB_to_SAN layer in the sanitary feature datasetDCBStringValues of 'DCB' identify double catch basins
Description: FIELD_NAMEFIELD_TYPECOMMENTOBJECTID_1OIDSHAPEGeometryPointOBJECTIDIntegerStmMHIDIntegerCurrent asset IDCommentStringNote 'Est. install from Spatial Join' identifies records where estimated install date was obtained from the oldest install date from intersecting storm mainsN_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersE_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersS_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersW_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersNE_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersSE_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersSW_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersNW_InvertDoubleInvert elevation. Not often used in favour of inverts in sanitary main layersT_GDoubleTop grade. Usually obtained from design drawing.Road_NameStringIntersectionStringEST_INSTALL_YEARSmallIntegerEstimated install year formatted as YYYY. See notes in Comments field explaining some of these recordsINSTALL_YEARDateInstall year formatted as YYYYMMDDCB_MHStringValue of 'CB_MH' identifies catch basin manholesDCB_MHStringValue of 'DCB_MH' identifies double catch basin manholesDCBStringValue of 'DCB' identifies double catch basin manholes
Description: FIELD_NAMEFIELD_TYPECOMMENTOBJECTIDOIDSHAPEGeometryLineSHAPE_LengthDoubleOBJECTID_1IntegerStmIDIntegerCurrent asset IDFromStmMHIntegerNot in useToStmMHIntegerNot in useCommentStringOLDIDIntegerMaterialStringPipe material e.g. 'PVC', 'PVC - Ribbed', 'PVC - Ribbed 320 kPa'SlopeDoubleSlope in %. Usually obtained from design drawingTGDoubleTop grade elevation. Usually obtained from design drawingUpInvertDoubleDwnInvertDoubleDiamMMDoubleDWG1StringDWG2StringDWG3StringRoadNameStringFromStreetStringToStreetStringInstallatiSmallIntegerShape_LengDoubleImprovNoStringFrom previous asset management plan?ImprovDescStringFrom previous asset management plan?ReplNoStringFrom previous asset management plan?ReplDescStringFrom previous asset management plan?ConditionStringFrom previous asset management plan?AddToVadimStringFrom previous asset management plan?InspecYearIntegerFrom previous asset management plan?AssetClassIntegerFrom previous asset management plan?SizeClassStringFrom previous asset management plan?Length_ActDoubleLength field of record. Units in meters. Usually obtained from design drawings.Field_LengthDoubleLength obtained from field inspection. Units metersYear_Installation_SourceStringProcess_StageStringCLI_ECA_OWNERSHIPStringIndicates whether assets are city owned and operated or currently operated by developer with ownership to be transferred in the future
Description: FIELD_NAMEFIELD_TYPECOMMENTOBJECTID_1OIDSHAPEGeometryLineOBJECTIDIntegerStmIDIntegerCurrent asset IDFromStmMHIntegerUpstream manhole IDToStmMHIntegerDownstream manhole IDCommentStringOLDIDIntegerMaterialStringPipe material e.g. 'PVC', 'Reinforced Concrete' etc.SlopeDoubleSlope %. Usually obtained from design drawingTGDoubleTop grade elevation. Usually obtained from design drawingUpInvertDoubleUpstream invert elevation. Usually obtained from design drawingDwnInvertDoubleDownstream invert elevation. Usually obtained from design drawingDiamMMDoubleNominal pipe diameter in millimetersDWG1StringDWG2StringDWG3StringRoadNameStringFromStreetStringToStreetStringInstallatiSmallIntegerInstallation date formatted as YYYYShape_LengDoubleImprovNoStringFrom previous asset management plan?ImprovDescStringFrom previous asset management plan?ReplNoStringFrom previous asset management plan?ReplDescStringFrom previous asset management plan?ConditionStringFrom previous asset management plan?AddToVadimStringFrom previous asset management plan?InspecYearIntegerFrom previous asset management plan?AssetClassIntegerFrom previous asset management plan?SizeClassStringLength_ActDoubleLength field of record. Units in meters. Usually obtained from design drawings.Field_LengthDoubleLength obtained from field inspection. Units metersSHAPE_LengthDoubleYear_Installation_SourceStringProcess_StageStringCLI_ECA_OWNERSHIPStringIndicates whether assets are city owned and operated or currently operated by developer with ownership to be transferred in the future
Description: FIELD_NAMEFIELD_TYPECOMMENTOBJECTIDOIDSHAPEGeometryLineCV_SHAPEStringCulvert shape e.g. 'CIRCULAR', 'BOX'CV_SIZEIntegerCulvert size in millimetersLengthSingleSHAPE_LengthDouble
Description: FIELD_NAMEFIELD_TYPECOMMENTOBJECTID_1OIDSHAPEGeometryPointOBJECTIDIntegerCulvertIDDoubleCulvertLocationStringRoadNameStringConstructionYearDoubleYear of construction formatted as YYYYCrossingTypeStringCulvertType1StringCulvertType2StringCulvertType3StringNoOfSpansDoubleTotalSpanDoubleLengthDoubleCulvertValueDoublePriorityRankingStringUnitCostDoubleReplacementCostDoubleCommentsStringCulvertClassStringRoadNameFullStringFromStreetStringToStreetStringOSIM_NumberStringCulvert_NameStringOSIM_Report_Introduction_2009StringOSIM_2009_Report_LinkStringOSIM_Report_Introduction_2010StringOSIM_2010_Report_LinkStringOSIM_Report_Introduction_2012StringOSIM_Report_Link_2012StringOSIM_Report_Introduction_2014StringOSIM_Report_Link_2014StringOSIM_Report_Introduction_2016StringOSIM_Report_Link_2016StringOSIMStringOSIM_Report_Introduction_2018StringOSIM_Report_Link_2018String
Description: FIELD_NAMEFIELD_TYPECOMMENTOBJECTID_1OIDSHAPEGeometryPolygonOBJECTIDIntegerNameStringCurrent Asset IDLocationStringDesc_StringIdentifies type of facilityRecieving_StringYear_ConstStringYear constructed, formatted as YYYYConstructiStringShape_LengDoubleStmPNDIDSmallIntegerSHAPE_LengthDoubleSHAPE_AreaDoubleCLI_ECA_OWNERSHIPStringIndicates whether assets are city owned and operated or currently operated by developer with ownership to be transferred in the futureLatitudeDoubleGeographic Y coordinate of polygon centroidLongitudeDoubleGeographic X coordinate of polygon centroid