Name: Wastewater Main

Display Field: UNITID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1794787.7282
YMin: 5810438.6862
XMax: 1805490.014
YMax: 5824126.1243
Spatial Reference: 2193 (2193)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"UNITTYPE","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,0,255],"width":6},"value":"INT","label":"Interceptor"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,192,182,255],"toColor":[252,192,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[180,252,179,255],"toColor":[180,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[188,179,252,255],"toColor":[188,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,245,252,255],"toColor":[182,245,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,248,199,255],"toColor":[252,248,199,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,251,255],"toColor":[252,215,251,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,221,252,255],"toColor":[194,221,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,252,223,255],"toColor":[202,252,223,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[240,184,252,255],"toColor":[240,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,214,255],"toColor":[252,182,214,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[230,252,179,255],"toColor":[230,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,228,215,255],"toColor":[252,228,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,222,179,255],"toColor":[252,222,179,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: UNITTYPE

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• COMPKEY (type: esriFieldTypeInteger, alias: Compkey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNITID (type: esriFieldTypeString, alias: Upstream Unit ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UNITID2 (type: esriFieldTypeString, alias: Downstream Unit ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• COMPTYPE (type: esriFieldTypeSmallInteger, alias: COMPTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINCOMP1 (type: esriFieldTypeSmallInteger, alias: MAINCOMP1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINCOMP2 (type: esriFieldTypeSmallInteger, alias: MAINCOMP2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDRKEY (type: esriFieldTypeInteger, alias: Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FLAT (type: esriFieldTypeString, alias: Address - Flat Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• HOUSENO (type: esriFieldTypeString, alias: Address - House No, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• STNAME (type: esriFieldTypeString, alias: Address - Street Name, SQL Type: sqlTypeOther, length: 28, nullable: true, editable: true, Coded Values: [ABBEY: ABBEY])
• STTYPE (type: esriFieldTypeString, alias: Address - Street Type, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [AV: AVENUE], [BD: BOULEVARD], [CIR: CIRCLE], ... 34 more ...)
• ADDRQUAL (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SUBAREA (type: esriFieldTypeString, alias: Interceptor, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [CI: CI - CENTRAL INTERCEPTOR], [EI: EI - EASTERN INTERCEPTOR], [FEI: FEI - FAR EASTERN INTERCEPTOR], ... 2 more ...)
• LOC (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [CARP: CARP - IN CARPARK], [FPTH: FPTH - IN FOOTPATH], [GULL: GULL - IN GULLY], ... 27 more ...)
• MAPNO (type: esriFieldTypeString, alias: Grid No_, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UNITTYPE (type: esriFieldTypeString, alias: Main Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [INT: INT - INTERCEPTOR], [RM: RM - RISING MAIN], [SIPH: SIPH - SIPHON PIPE], ... 4 more ...)
• SURF (type: esriFieldTypeString, alias: Aerial/Ducted, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [AEEB: AEEB - EXPOSED AERIAL BRIDGE], [AER: AER - AERIAL PIPE], [AERB: AERB - AERIAL BRIDGE], ... 7 more ...)
• PIPETYPE (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PIPEDESC (type: esriFieldTypeString, alias: Material Description, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [ABS: ABS - ABS PLASTIC PIPE], [AC: AC - ASBESTOS CEMENT], [ACUPVC: ACUPVC - UPVC IN ASBESTOS CEMENT DUCT], ... 31 more ...)
• CLASS (type: esriFieldTypeString, alias: Pipe Class, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [12.5: 12.5], [B: B], [C: C], ... 13 more ...)
• PIPELEN (type: esriFieldTypeDouble, alias: LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPEDIAM (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UPSDPTH (type: esriFieldTypeDouble, alias: Upstream Depth m, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DWNDPTH (type: esriFieldTypeDouble, alias: Downstream Depth m, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UPSELEV (type: esriFieldTypeDouble, alias: Upstream Invert Level, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DWNELEV (type: esriFieldTypeDouble, alias: Downstream Invert level, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JTTYPE (type: esriFieldTypeString, alias: Joint Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• INSTDATE (type: esriFieldTypeDate, alias: Installed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SERVSTAT (type: esriFieldTypeString, alias: Service Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [A: A - ARCHIVED (ABANDONED/EXPIRED)], [AS: AS - REMOVED FROM SERVICE, IN STOCK], [C: C - CURRENT (LIVE)], ... 6 more ...)
• OWN (type: esriFieldTypeString, alias: Shape.STLength(), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: false, Coded Values: [HCC: HCC - HAMILTON CITY COUNCIL], [PVT: PVT - PRIVATELY OWNED], [UNKNOWN: UNKNOWN - OWNER UNKNOWN], ... 1 more ...)
• BUDGETKEY (type: esriFieldTypeInteger, alias: Budget, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BGTNO (type: esriFieldTypeString, alias: Budget No_, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ASBLT (type: esriFieldTypeString, alias: Asbuilt, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RESPONSIBILITY (type: esriFieldTypeString, alias: Responsibility, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [CITI: CITI - CITIPARKS], [DEL: DEL - CITY DELIVERY], [HORC: HORC - HAMILTON ORGANIC RECYCLG CNTRE], ... 12 more ...)
• SPECINST (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• SAFETY_MSG_FLAG (type: esriFieldTypeString, alias: Safety Message Flag, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• FIN_ACQPROJ (type: esriFieldTypeString, alias: FIN Acquisition Project, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FIN_PARENT_COMPKEY (type: esriFieldTypeDouble, alias: FIN Parent Compkey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIN_BOOKID (type: esriFieldTypeString, alias: FIN Book ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• FIN_CONCOST (type: esriFieldTypeDouble, alias: FIN Construction Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIN_DISPPROJ (type: esriFieldTypeString, alias: FIN Disposal Project, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FIN_BASELIFECODE (type: esriFieldTypeString, alias: FIN Baselife Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FIN_BASELIFE (type: esriFieldTypeDouble, alias: FIN Baselife, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIN_PLN_RENEWALCODE (type: esriFieldTypeString, alias: FIN Planned Renewal, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FIN_PLN_RENEWALYR (type: esriFieldTypeDate, alias: FIN Planned Renewal Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FIN_REP_UNITRATE (type: esriFieldTypeDouble, alias: FIN Replacement Unit Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIN_UNQ_REPCOST (type: esriFieldTypeDouble, alias: FIN Unique Replacement Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENTERED_DATE (type: esriFieldTypeDate, alias: GIS Entered Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• MODIFIED_DATE (type: esriFieldTypeDate, alias: GIS Modified Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• MODIFIED_BY (type: esriFieldTypeString, alias: GIS Modified By, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: false)
• ATTRIBUTE_ACCURACY (type: esriFieldTypeInteger, alias: Attribute Accuracy, SQL Type: sqlTypeOther, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CRITICALITY_ASSESSED (type: esriFieldTypeDate, alias: Criticality Assessed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RISK (type: esriFieldTypeDouble, alias: Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RISK_ASSESSED (type: esriFieldTypeDate, alias: Risk Assessed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• VALDATE (type: esriFieldTypeDate, alias: Archive Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PARLINENO (type: esriFieldTypeString, alias: PARLINENO, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• MAINKEY1 (type: esriFieldTypeInteger, alias: Upstream Compkey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINKEY2 (type: esriFieldTypeInteger, alias: Downstream Compkey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GEOADMIN_INT (type: esriFieldTypeDouble, alias: GeoAdmin Use - Number Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GEOADMIN_CHAR (type: esriFieldTypeString, alias: GeoAdmin Use - String Type, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: INT
Name: INT
Domains:

• Field Name: STNAME
  Inherited
  
• Field Name: STTYPE
  Inherited
  
• Field Name: SUBAREA
  Inherited
  
• Field Name: LOC
  Inherited
  
• Field Name: UNITTYPE
  Inherited
  
• Field Name: SURF
  Inherited
  
• Field Name: PIPEDESC
  Inherited
  
• Field Name: CLASS
  Inherited
  
• Field Name: SERVSTAT
  Inherited
  
• Field Name: OWN
  Inherited
  
• Field Name: RESPONSIBILITY
  Inherited
  
• Field Name: ATTRIBUTE_ACCURACY
  Inherited
  
• Field Name: GEOGRAPHIC_ACCURACY
  Inherited
  
Templates:

Name: INT
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• COMPTYPE: 21
• UNITTYPE: INT
• SERVSTAT: C

---

Relationships:

• Pump Station Downstream (0) -- Related To: Wastewater Pump Station (16)
• Pump Station Upstream (1) -- Related To: Wastewater Pump Station (16)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/21/2019 12:28:55 AM

Schema Last Edit Date: 5/21/2019 12:28:55 AM

Data Last Edit Date: 5/21/2019 12:28:55 AM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat