Name: Water Main

Display Field: UNITID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 60000

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: 1792360.2430999996
YMin: 5809636.527
XMax: 1806151.8657
YMax: 5824130.6448
Spatial Reference: 2193  (2193)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 112, 255, 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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• COMPKEY ( type: esriFieldTypeInteger, alias: Compkey )
• UNITID ( type: esriFieldTypeString, alias: Unit ID 1, length: 20 )
• UNITID2 ( type: esriFieldTypeString, alias: Unit ID 2, length: 20 )
• COMPTYPE ( type: esriFieldTypeSmallInteger, alias: COMPTYPE )
• MAINCOMP1 ( type: esriFieldTypeSmallInteger, alias: MAINCOMP1 )
• MAINCOMP2 ( type: esriFieldTypeSmallInteger, alias: MAINCOMP2 )
• MAINKEY1 ( type: esriFieldTypeInteger, alias: Mainkey 1 )
• MAINKEY2 ( type: esriFieldTypeInteger, alias: Mainkey 2 )
• ADDRKEY ( type: esriFieldTypeInteger, alias: Address )
• FLAT ( type: esriFieldTypeString, alias: Address - Flat Number, length: 10 )
• HOUSENO ( type: esriFieldTypeString, alias: Address - House No, length: 10 )
• STNAME ( type: esriFieldTypeString, alias: Address - Street Name, length: 28 , Coded Values: [ABBEY: ABBEY] )
• STTYPE ( type: esriFieldTypeString, alias: Address - Street Type, length: 4 , Coded Values: [AV: AVENUE] , [BD: BOULEVARD] , [CIR: CIRCLE] , ...34 more... )
• ADDRQUAL ( type: esriFieldTypeString, alias: Location/Notes, length: 254 )
• LOC_AREA ( type: esriFieldTypeString, alias: Area, length: 10 , Coded Values: [6203: 6203 - MIGRATION] , [6208: 6208 - MIGRATION] , [6217: 6217 - MIGRATION] , ...224 more... )
• SUBAREA ( type: esriFieldTypeString, alias: Pipe ID, length: 50 )
• DISTRICT ( type: esriFieldTypeString, alias: District, length: 10 , Coded Values: [109: 109] , [BM: BM - BEERESCOURT/MAEROA] , [CO: CO - CENTRAL] , ...15 more... )
• LOC ( type: esriFieldTypeString, alias: Location, length: 10 , Coded Values: [BERM: BERM -] , [CARP: CARP - IN CARPARK] , [CONC: CONC - ON CONCRETE PAD] , ...84 more... )
• MAPNO ( type: esriFieldTypeString, alias: Map No, length: 20 )
• UNITTYPE ( type: esriFieldTypeString, alias: Water Main Type, length: 10 , Coded Values: [BULK: BULK - WATER BULK MAIN] , [FLUSH: FLUSH - FLUSH POINT PIPE] , [MAIN: MAIN - WATER MAIN] , ...6 more... )
• DIAM ( type: esriFieldTypeDouble, alias: Diameter mm )
• PIPELEN ( type: esriFieldTypeDouble, alias: Length m )
• PIPETYPE ( type: esriFieldTypeString, alias: Material, length: 10 )
• MATERIAL ( type: esriFieldTypeString, alias: Material Description, length: 10 , Coded Values: [AC: AC - ASBESTOS CEMENT] , [ACMDPE: ACMDPE - MDPE IN ASBESTOS CEMENT DUCT] , [ALK: ALK - ALKATHENE:LDPE OR HDPE] , ...22 more... )
• CLASS ( type: esriFieldTypeString, alias: Class, length: 10 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...13 more... )
• JTTYPE ( type: esriFieldTypeString, alias: Joint Type, length: 10 )
• SURF ( type: esriFieldTypeString, alias: Aerial/Ducted, length: 10 , Coded Values: [AEEB: AEEB - EXPOSED AERIAL BRIDGE] , [AER: AER - AERIAL PIPE] , [AERB: AERB - AERIAL BRIDGE] , ...10 more... )
• SOILTYPE ( type: esriFieldTypeString, alias: Soil Type, length: 10 )
• PRESZONE ( type: esriFieldTypeString, alias: Pressure Zone, length: 10 , Coded Values: [BLUE: BLUE - STANDARD PRESSURE ZONE] , [GRN: GRN - ROTOTUNA PRESSURE ZONE(GREEN)] , [ORAN: ORAN - NEWCASTLE PRESSURE ZONE] , ...1 more... )
• INSTDATE ( type: esriFieldTypeDate, alias: Installed Date, length: 8 )
• SERVSTAT ( type: esriFieldTypeString, alias: Service Status, length: 10 , Coded Values: [A: A - ARCHIVED (ABANDONED/EXPIRED)] , [AS: AS - REMOVED FROM SERVICE, IN STOCK] , [C: C - CURRENT (LIVE)] , ...6 more... )
• OWN ( type: esriFieldTypeString, alias: Ownership, length: 10 , Coded Values: [HCC: HCC - HAMILTON CITY COUNCIL] , [PVT: PVT - PRIVATELY OWNED] , [UNKNOWN: UNKNOWN - OWNER UNKNOWN] , ...1 more... )
• BUDGETKEY ( type: esriFieldTypeInteger, alias: Budget )
• BGTNO ( type: esriFieldTypeString, alias: Budget No., length: 50 )
• ASBLT ( type: esriFieldTypeString, alias: Asbuilt Plan, length: 50 )
• RESPONSIBILITY ( type: esriFieldTypeString, alias: Responsibility, length: 10 , Coded Values: [CITI: CITI - CITIPARKS] , [DEL: DEL - CITY DELIVERY] , [HORC: HORC - HAMILTON ORGANIC RECYCLG CNTRE] , ...12 more... )
• SPECINST ( type: esriFieldTypeString, alias: Comments, length: 2000 )
• SAFETY_MSG_FLAG ( type: esriFieldTypeString, alias: Safety Message Flag, length: 1 )
• FIN_ACQPROJ ( type: esriFieldTypeString, alias: FIN Acquisition Project, length: 20 )
• FIN_PARENT_COMPKEY ( type: esriFieldTypeDouble, alias: FIN Parent Compkey )
• FIN_BOOKID ( type: esriFieldTypeString, alias: FIN Book ID, length: 15 )
• FIN_CONCOST ( type: esriFieldTypeDouble, alias: FIN Construction Cost )
• FIN_DISPPROJ ( type: esriFieldTypeString, alias: FIN Disposal Project, length: 20 )
• FIN_BASELIFECODE ( type: esriFieldTypeString, alias: FIN Baselife Code, length: 10 )
• FIN_BASELIFE ( type: esriFieldTypeDouble, alias: FIN Baselife )
• FIN_PLN_RENEWALCODE ( type: esriFieldTypeString, alias: FIN Planned Renewal, length: 10 )
• FIN_PLN_RENEWALYR ( type: esriFieldTypeDate, alias: FIN Planned Renewal Date, length: 8 )
• FIN_REP_UNITRATE ( type: esriFieldTypeDouble, alias: FIN Replacement Unit Rate )
• FIN_UNQ_REPCOST ( type: esriFieldTypeDouble, alias: FIN Unique Replacement Cost )
• ENTERED_DATE ( type: esriFieldTypeDate, alias: GIS Entered Date, length: 8 )
• MODIFIED_DATE ( type: esriFieldTypeDate, alias: GIS Modified Date, length: 8 )
• MODIFIED_BY ( type: esriFieldTypeString, alias: GIS Modified By, length: 10 )
• ATTRIBUTE_ACCURACY ( type: esriFieldTypeInteger, alias: Attribute Accuracy , Coded Values: [1: 1 - Accurate (100%)] , [2: 2 - Minor inaccuracies(+/-5%)] , [3: 3 - 50% estimated (+/-20%)] , ...2 more... )
• GEOGRAPHIC_ACCURACY ( type: esriFieldTypeInteger, alias: Positional Accuracy , Coded Values: [1: 1 - Accurate or surveyed (100%)] , [2: 2 - Minor inaccuracies, offsets, some surveyed (+/-5%)] , [3: 3 - 50% estimated (+/-20%)] , ...2 more... )
• CRITICALITY ( type: esriFieldTypeString, alias: Criticality, length: 10 )
• CRITICALITY_ASSESSED ( type: esriFieldTypeDate, alias: Criticality Assessed Date, length: 8 )
• RISK ( type: esriFieldTypeDouble, alias: Risk )
• RISK_ASSESSED ( type: esriFieldTypeDate, alias: Risk Assessed Date, length: 8 )
• PARLINENO ( type: esriFieldTypeString, alias: PARLINENO, length: 2 )
• VALDATE ( type: esriFieldTypeDate, alias: Archive Date, length: 8 )
• MWH_PIPE_NO ( type: esriFieldTypeDouble, alias: MWH_PIPE_NO )
• MWH_PLAN_N ( type: esriFieldTypeString, alias: MWH_PLAN_N, length: 17 )
• MWH_PLAN_FLAG ( type: esriFieldTypeString, alias: MWH_PLAN_FLAG, length: 11 )
• MWH_MATERIAL_L ( type: esriFieldTypeString, alias: MWH_MATERIAL_L, length: 12 )
• MWH_MATR_FLAG ( type: esriFieldTypeString, alias: MWH_MATR_FLAG, length: 12 )
• MWH_DIAMETER_L ( type: esriFieldTypeDouble, alias: MWH_DIAMETER_L )
• MWH_DIAM_FLAG ( type: esriFieldTypeString, alias: MWH_DIAM_FLAG, length: 11 )
• MWH_DIST_PROP ( type: esriFieldTypeDouble, alias: MWH_DIST_PROP )
• MWH_DIST_BK ( type: esriFieldTypeDouble, alias: MWH_DIST_BK )
• MWH_COMMENTS_L ( type: esriFieldTypeString, alias: MWH_COMMENTS_L, length: 37 )
• MWH_BASE_ISSUE ( type: esriFieldTypeString, alias: MWH_BASE_ISSUE, length: 50 )
• HCC_QA ( type: esriFieldTypeString, alias: HCC_QA, length: 500 )
• HCC_CHECKED ( type: esriFieldTypeString, alias: HCC_CHECKED, length: 15 )
• GEOADMIN_INT ( type: esriFieldTypeDouble, alias: GeoAdmin Use - Number Type )
• GEOADMIN_CHAR ( type: esriFieldTypeString, alias: GeoAdmin Use - String Type, length: 1000 )
• SEGMENTID ( type: esriFieldTypeString, alias: Segment Derived Compkey, length: 15 )
• SEG_START ( type: esriFieldTypeString, alias: Segment Start Node, length: 20 )
• SEG_END ( type: esriFieldTypeString, alias: Segment End Node, length: 20 )
• SEG_LENGTH ( type: esriFieldTypeDouble, alias: Segment Length m )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• DATA_SOURCE ( type: esriFieldTypeString, alias: Data Source, length: 30 )
• EXTERNAL_REF ( type: esriFieldTypeString, alias: External Reference, length: 25 )
• GIS_ONLY ( type: esriFieldTypeString, alias: GIS Record Only, length: 1 )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Relationships:

• Service Line (5) -- Related To: Water Service Line/Connection (4)
• Valve (0) -- Related To: Water Valve (0)
• Meter (2) -- Related To: Water Meter (2)
• Hydrant (1) -- Related To: Water Hydrant (1)
• Storage Unit Upstream (6) -- Related To: Water Storage Unit (8)
• Storage Unit Downstream (7) -- Related To: Water Storage Unit (8)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata