Name: Water Service Line Valve

Display Field: STNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000

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: 1794680.3698000005
YMin: 5810707.4651
XMax: 1805634.3830000004
YMax: 5823877.6974
Spatial Reference: 2193  (2193)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• COMPKEY ( type: esriFieldTypeInteger, alias: Compkey )
• UNITID ( type: esriFieldTypeString, alias: Unit ID, length: 20 )
• COMPTYPE ( type: esriFieldTypeSmallInteger, alias: COMPTYPE )
• 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 Valve Type, length: 10 , Coded Values: [AIRV: AIRV - AIR VALVE] , [BFLY: BFLY - BUTTERFLY] , [CHECK: CHECK - CHECK/NON RETURN VALVE] , ...6 more... )
• VALVESZ ( type: esriFieldTypeDouble, alias: Valve Size mm )
• MFGKEY ( type: esriFieldTypeInteger, alias: Manufacturer , Coded Values: [2: FLYGT - FULLERS PUMP /TRIMATE] , [3: HOMA - WAIKATO PUMP/WALLACE PUMPS] , [1001: ABS - MONO PUMPS] , ...54 more... )
• MANUFCODE ( type: esriFieldTypeString, alias: Manufacturer Code, length: 10 )
• MODELNO ( type: esriFieldTypeString, alias: Model No., length: 50 )
• SERNO ( type: esriFieldTypeString, alias: Serial No., length: 50 )
• 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... )
• HIGHPRES ( type: esriFieldTypeDouble, alias: Max. Op Pressure )
• LOWPRES ( type: esriFieldTypeDouble, alias: Min. Op Pressure )
• VALVESTAT ( type: esriFieldTypeString, alias: Valve Status, length: 10 )
• DIR ( type: esriFieldTypeString, alias: Direction to Open, length: 1 )
• NOTURNS ( type: esriFieldTypeString, alias: No. of Turns, length: 4 )
• COATED ( type: esriFieldTypeString, alias: Coated, length: 1 )
• 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 )
• SLKEY ( type: esriFieldTypeInteger, alias: Service Line )
• MAINKEY ( type: esriFieldTypeInteger, alias: Water Main )
• 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... )
• VALDATE ( type: esriFieldTypeDate, alias: Archive Date, length: 8 )
• 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 )
• 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 )
• PURPOSE ( type: esriFieldTypeString, alias: Asset Purpose, length: 50 )

Relationships:

• Service Line (4) -- Related To: Water Service Line/Connection (4)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata