Description: FIELD_NAMEFIELD_TYPECOMMENTOBJECTIDOIDSHAPEGeometryPointHydrantPointIDIntegercurrent ID fieldQuadNumStringhistorical system for feature identifiers. These IDs still refer to historical documents but as features are replaced they are not regenerated.SectionStringcontains the hydrant flushing section. A prefix of '-' indicates the hydrant is not to be included in the flushing program and can be used in a definition query to not display them on the flushing maps.OBJECTID_1IntegerCableCad_FH_IDDoubleARCMAP_valve_ID_No_DoubleArcMap_Hyd_Point_No_DoubleLocationStringStreetStringAddressDoubleCROSS_STREET_1StringCROSS_STREET__2StringTOP_NUT_ELEVATIONDoublecurrently maintained by Engineering and as such this field is not currently considered authoritative. When a hydrant is newly installed replaced or subject to a repair that alters the top nut elevation the current procedure is for the data custodian in Environemtnal Services to notify the Technical Services Coordinates in Engineering so the survey crew can be dispatched to collect updated information.OWNERStringfield not currently relevant as all features in this layer should be city-ownedYEARDoubleINSTALL_DATEDoubleContains the most up to date hydrant install dates. Install date currently entered in format of YYYYMMDD. Many estimates entered as YYYY0101. Dates currently entered should represent the project or repair completion date as defined by Environmental Services. This data should have a high degree of completness for newer data with older data requiring verification.INITIAL_STATIC_PRESSUREDoubleINITIAL_FLOWDoubleRESIDUAL_FLOW_AT_20_PSIDoubleTEST_DATEStringSIZEDoubleNUMBER_OF_NOZZLESDoubleNOZZLE_ONE_SIZEDoubleNOZZLE_2_SIZEDoubleNOZZLE_3_SIZEDoubleSELF_DRAININGStringDIRECTION_TO_OPENStringBREAK_AWAY_FLANGEStringLATERAL_SIZEDoubleISOLATION_VALVEStringMAIN_TO_VALVE_DISTANCEDoubleVALVE_TO_HYDRANT_DISTANCEDoubleTIE_1StringTIE_2StringCATHODIC_PROTECTIONStringCATHODIC_PROTECTION_INSTALL_DATEStringANTI_TAMPER_DEVICEStringLOCATION_MARKERStringCOLOUR_CODEDStringPAINT_DATEStringINSPECTION_DATEStringFLUSH_DATEStringSHOVEL_DATEStringQUADRANT_NUMBERStringArcMap_Hyd_Point_No_1StringI_O___DATEStringRepair_commentStringused to document any relevant details related to repairs. Completeness of this data unknownGPM___psi_resStringDate_TestedStringTime_24hrsStringBR_VLVStringINSTLLDStringSIZE1StringMAKE1StringTypeStringTIEStringN_S_E_W_OF_FHStringOPENSStringTURNSStringSET_INStringRECORD_REVSN_DATEStringI_O_DATEStringI_OStringREMARKStringcurrently used to document general information and to document Form 1 ID.out_of_serviceStringstores Y/N values to log which hydrants are currently operable. Null means has not been placed out of service since this field was added.CL_PROFILEStringdate_out_of_servStringdate a hydrant was most recently booked out of service. Dates stored as YYYYMMDDdate_in_servStringdate the hydrant was most recently placed back in service. Dates stored as YYYYMMDDHYD_MODELStringvalidated through domains related to the subtypes in HYD_Make_Int (see below)HYD_MAKE_INTSmallIntegersubtype field that stores an integer that relates to a coded value domain (see below)PUMPERStringspecifies whether or not there is a pumper port (Y/N).
Copyright Text: Make and model result of field survey by Dale Haskell and Steve Garrow in early 2020.
Description: Attribute Field Notes: FIELD_NAMEFIELD_TYPECOMMENTOBJECTIDOIDSHAPEGeometryPointAddressStringValveIDIntegercurrent asset ID for this layerTypeStringcurrently used as the primary asset type field. Field not complete. The overwhelming majority of features in this layer should be 'CS' for curb stopInstalledStringcontains the installation dates if known. This field is also not completeCommentsStringSubTypeStringoptionally used to qualify the Type field
Description: Attribute Field Notes: FIELD_NAMEFIELD_TYPECOMMENTOBJECTIDOIDSHAPEGeometryPointAM_IDIntegercurrent asset ID for this layerAddressStringTypeStringcurrently used as the primary asset type field. Field not complete.SubTypeStringoptionally used to qualify the Type fieldInstalledStringcontains the installation dates if known.CommentsString
Description: FIELD_NAMEFIELD_TYPECOMMENTOBJECTID_1OIDSHAPEGeometryPointOBJECTIDIntegerValveIDIntegercurrent asset ID for this layerAddressStringQuadNumStringCCadIDSmallIntegerTypreStringused to classify valve type. Usually this classification refers more to function than make/model.CommentsStringSectionStringcontains the hydrant flushing section. A prefix of '-' indicates the valve is not to be included in the flushing program and can be used in a definition query to not display them on the flushing maps.OWNERSHIPStringnot currently relevant as all features in this layer should be city-ownedInstalledStringInstall date currently entered in format of YYYYMMDD. Many estimates entered as YYYY0101. Dates currently entered should represent the project or repair completion date as defined by Environmental Services. This data should have a high degree of completness for newer data with older data requiring verification.SubTypeStringoptionally used to qualify the Type fieldChamberStringto be used in the future to indicate if a valve chamber exists
Copyright Text: Belleville Water
Dillon
City of Belleville
Date_of_Break
(
type: esriFieldTypeDate, alias: Date of Break, length: 8
)
Pipe_Age_At_Break
(
type: esriFieldTypeSmallInteger, alias: Pipe Age At Break
)
Probable_Cause_of_Break
(
type: esriFieldTypeString, alias: Probable Cause of Break, length: 50
, Coded Values:
[Wood Blocking Under Pipe: Wood Blocking Under Pipe]
, [Rock Next to Pipe: Rock Next to Pipe]
, [Proximity to Other Infrastructure: Proximity to Other Infrastructure]
, ...7 more...
)
Description: FIELD_NAMEFIELD_TYPECOMMENTOBJECTIDOIDSHAPEGeometryPointPipe_Sample_IDStringCurrent ID fieldSample_DateIntegerStreet_NameStringLocation_AddressStringPipe_Nominal_Inside_Diam_mmSmallIntegerMaterial_OriginalStringMaterial_NewStringPipe_Section_LenthSingleCoupling_1StringCoupling_2StringLocation_DescriptionString
Description: FIELD_NAMEFIELD_TYPECOMMENTOBJECTID_1OIDSHAPEGeometryPointOBJECTIDIntegercurrent ID fieldValveIDIntegerobsolete (it's believed that nodes (valves and fittings) were combined in one dataset at some point in time (possibly in CableCAD prior to GIS adoption) so water main segments could have a definitive FROM and TO node)AddressStringQuadNumStringhistorical system for feature identifiers. These IDs still refer to historical documents but as features are replaced they are not regenerated. Typre is currently used as the primary asset type fieldCCadIDSmallIntegerTypreStringcurrently used as the primary asset type fieldSubTypeStringoptionally used to qualify the type fieldInstalledStringInstall date currently entered in format of YYYYMMDD. Many estimates entered as YYYY0101. Dates currently entered should represent the project or repair completion date as defined by Environmental Services. This data should have a high degree of completness for newer data with older data requiring verification.CommentsStringcurrently used to document Form 1 ID.OWNERSHIPStringnot currently relevant as all features in this layer should be city-owned
Copyright Text: Belleville Water
Dillon
City of Belleville
Description: Attribute Field Notes: FIELD_NAMEFIELD_TYPECOMMENTOBJECTID_1OIDSHAPEGeometryLineOBJECTIDIntegerCurrent asset IDWaterIDDoubleStreetNameStringDiameterDoublePipeLengthDoubleManually entered pipe length. This is the length of record although the accuracy cannot be guaranteed, particularly with older recordsMaterialStringPipe material. It's preferred that this data be enterred with material and dimension ratio or other qualifying information e.g. 'PVC DR-18' or 'CPP AWWA 303' but this information is not always availableInstallatiStringInstall date currently entered in format of YYYYMMDD. Many estimates entered as YYYY0101. Dates currently entered should represent the project or repair completion date as defined by Environmental Services. This data should have a high degree of completness for newer data with older data requiring verification.ReliningMaStringReliningDaStringFromValveIntegerToValveIntegerRoadNameFuStringFromStreetStringToStreetStringCommentStringShape_LengDoubleImprovNoStringFrom previous asset management plan?ImprovDescStringFrom previous asset management plan?ReplNoStringFrom previous asset management plan?ReplDescStringFrom previous asset management plan?ConditionSingleFrom previous asset management plan?OWNERSHIPStringShould be irrelevant as all features should be city-ownedAddToVadimStringFrom previous asset management plan?YearInspecIntegerFrom previous asset management plan?SizeClassStringFrom previous asset management plan?DuplicateSmallIntegerSHAPE_LengthDouble
Description: FIELD_NAMEFIELD_TYPECOMMENTOBJECTIDOIDSHAPEGeometryLineAM_IDIntegerCurrent asset IDIdStringWS_IDStringCommentsStringContains many repair-related notes added from service cards when digitizedWater_Service_IDStringLocationStringStreetStringAddressStringUnit_NumberStringQualifierStringUpper_NumberStringNotesStringCity_SizeStringUnits represent nominal size of city-owned portion in millimetersCity_MatlStringPipe material of city-owned portionCity_InstlStringInstall date in format of YYYYMMDD with many dates where only year is known entered as January 1st e.g. 20230101City_YearStringCust_SizeStringUnits represent nominal size of privately owned portion in millimetersCust_MatlStringPipe material of privately owned portionCust_InstlStringInstall date in format of YYYYMMDD with many dates where only year is known entered as January 1st e.g. 20230101Cust_YearStringFlow_CBStringFlow rate recorded at curb box in imperial gallons per minuteFlow_UnitStringNot currently used as all records should be in imperial gallons per minuteCB_DATE_FLStringInspection date curb box flow rate recordedDepthCitySStringDepthCustSStringCouplingsStringMultiple_at_LocationStringIgnoreStringDoneStringAddedStringGIS_Work_YearStringPDF_LinkStringIntended to link to water cardLink_PrefixStringPrefix for 'PDF_Link' fieldLink_SufixStringSuffix for 'PDF_Link' fieldUNIONSStringCOVERStringCORR_PROTStringCORR_PROT_StringCORR_INSTLStringFLOW_METERStringFlow rate recorded at water meter in imperial gallons per minuteFLOW_MET_1StringMTR_DATE_DStringInspection date water meter flow rate recordedCLNGMTHDStringCleaning method if service has been rejuvinated e.g. sand blastingDATE_CLNDStringDate service rejuvinated/cleanedIO1StringWork assignment associated with curb box inspectionIO2StringInstruction order (Vadim) associated with meter inspectionField25StringField26StringFLOW_CB_PSStringSHAPE_LengthDouble
Description: This dataset contains parcels that are serviced by the City sanitary collection system or one of the City water distribution systems. The data was derived from several sources including MPAC, the City's existing GIS records and other miscellaneous records (service cards, list of septic systems, list of customers from Finance). The parcels are classified by data source in the attribute table for both water and sanitary service.