Name: Water Services

Display Field: AM_ID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 304590.11569999997
YMin: 4889647.2555
XMax: 313085.89159999974
YMax: 4898496.624500001
Spatial Reference: 26918  (26918)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [59, 160, 247, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• OBJECTID ( type: esriFieldTypeOID, alias: System ID )
• Id ( type: esriFieldTypeString, alias: Id (obsolete), length: 50 )
• WS_ID ( type: esriFieldTypeString, alias: WS_ID (obsolete), length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Water_Service_ID ( type: esriFieldTypeString, alias: Water_Service_ID (obsolete), length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• Street ( type: esriFieldTypeString, alias: Street Name, length: 50 )
• Address ( type: esriFieldTypeString, alias: Address (Civic), length: 50 )
• Unit_Number ( type: esriFieldTypeString, alias: Address (Unit Number), length: 50 )
• Qualifier ( type: esriFieldTypeString, alias: Address (Qualifier), length: 50 )
• Upper_Number ( type: esriFieldTypeString, alias: Address (Upper Number), length: 50 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• City_Size ( type: esriFieldTypeString, alias: Pipe Size (City), length: 50 )
• City_Matl ( type: esriFieldTypeString, alias: Pipe Material (City), length: 50 )
• City_Instl ( type: esriFieldTypeString, alias: Pipe Installation Date (City), length: 50 )
• City_Year ( type: esriFieldTypeString, alias: Pipe Installation Year (City), length: 50 )
• Cust_Size ( type: esriFieldTypeString, alias: Pipe Size (Customer), length: 50 )
• Cust_Matl ( type: esriFieldTypeString, alias: Pipe Material (Customer), length: 50 )
• Cust_Instl ( type: esriFieldTypeString, alias: Pipe Installation Date (Customer), length: 50 )
• Cust_Year ( type: esriFieldTypeString, alias: Pipe Installation Year (Customer), length: 50 )
• Flow_CB ( type: esriFieldTypeString, alias: Flow At Curb Box, length: 50 )
• Flow_Unit ( type: esriFieldTypeString, alias: Flow At Curb Box (Unit), length: 50 )
• CB_DATE_FL ( type: esriFieldTypeString, alias: Flow At Curb Box (Date), length: 50 )
• DepthCityS ( type: esriFieldTypeString, alias: Depth of City Service, length: 50 )
• DepthCustS ( type: esriFieldTypeString, alias: Depth of Customer Service, length: 50 )
• Couplings ( type: esriFieldTypeString, alias: Couplings, length: 50 )
• Multiple_at_Location ( type: esriFieldTypeString, alias: Multiple_at_Location, length: 50 )
• Ignore ( type: esriFieldTypeString, alias: Ignore, length: 50 )
• Done ( type: esriFieldTypeString, alias: Done, length: 50 )
• Added ( type: esriFieldTypeString, alias: Added, length: 50 )
• GIS_Work_Year ( type: esriFieldTypeString, alias: GIS_Work_Year, length: 50 )
• PDF_Link ( type: esriFieldTypeString, alias: PDF Link, length: 50 )
• Link_Prefix ( type: esriFieldTypeString, alias: PDF Link Prefix, length: 150 )
• Link_Sufix ( type: esriFieldTypeString, alias: PDF Link Sufix, length: 50 )
• UNIONS ( type: esriFieldTypeString, alias: UNIONS, length: 50 )
• COVER ( type: esriFieldTypeString, alias: COVER, length: 50 )
• CORR_PROT ( type: esriFieldTypeString, alias: Corrosion Protection, length: 50 )
• CORR_PROT_ ( type: esriFieldTypeString, alias: CORR_PROT_, length: 50 )
• CORR_INSTL ( type: esriFieldTypeString, alias: Corrosion Protection (Install Date), length: 50 )
• FLOW_METER ( type: esriFieldTypeString, alias: Flow At Meter, length: 50 )
• FLOW_MET_1 ( type: esriFieldTypeString, alias: Flow At Meter (Pressure), length: 50 )
• MTR_DATE_D ( type: esriFieldTypeString, alias: Flow At Meter (Date), length: 50 )
• CLNGMTHD ( type: esriFieldTypeString, alias: Cleaning Method, length: 50 )
• DATE_CLND ( type: esriFieldTypeString, alias: Date Cleaned, length: 50 )
• IO1 ( type: esriFieldTypeString, alias: Instruction Order 1, length: 50 )
• IO2 ( type: esriFieldTypeString, alias: Instruction Order 2, length: 50 )
• Field25 ( type: esriFieldTypeString, alias: Field25, length: 50 )
• Field26 ( type: esriFieldTypeString, alias: Field26, length: 50 )
• FLOW_CB_PS ( type: esriFieldTypeString, alias: Flow At Curb Box (Pressure), length: 50 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape Geometry )
• StreetName ( type: esriFieldTypeString, alias: Street Name, length: 200 )
• Segment_ID ( type: esriFieldTypeInteger, alias: Segment_ID )
• ES_ID ( type: esriFieldTypeInteger, alias: ES_ID )
• AM_ID ( type: esriFieldTypeString, alias: AM_ID, length: 20 )
• CRID ( type: esriFieldTypeString, alias: CRID, length: 20 )
• Project_Title ( type: esriFieldTypeString, alias: Project_Title, length: 200 )
• Responsible_Department ( type: esriFieldTypeString, alias: Responsible_Department, length: 100 )
• Service_Area ( type: esriFieldTypeString, alias: Service_Area, length: 50 )
• Project_Type ( type: esriFieldTypeString, alias: Project_Type, length: 50 )
• Project_Description ( type: esriFieldTypeString, alias: Project_Description, length: 250 )
• Project_Cost_2024 ( type: esriFieldTypeDouble, alias: Project_Cost_2024 )
• Project_Budget_Year ( type: esriFieldTypeString, alias: Project_Budget_Year, length: 20 )
• Project_Timing ( type: esriFieldTypeString, alias: Project_Timing, length: 20 )
• Risk_Score ( type: esriFieldTypeSmallInteger, alias: Risk_Score )
• Current_PoF ( type: esriFieldTypeSmallInteger, alias: Current_PoF )
• CoF ( type: esriFieldTypeSmallInteger, alias: CoF )
• Current_Replacement_Value ( type: esriFieldTypeDouble, alias: Current_Replacement_Value )
• Asset_Risk_Score ( type: esriFieldTypeSmallInteger, alias: Asset_Risk_Score )

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

  Iteminfo   Thumbnail   Metadata