Name: Booster Pump

Display Field: STNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

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: 1797901.9828
YMin: 5814580.4904
XMax: 1801471.4747
YMax: 5821992.6059
Spatial Reference: 2193 (2193)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"b5da03e5861048b8d8637e57d8c3f310","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABRUlEQVRIieXVP0/CQBzG8S8thRYIoYD/FzXGaDBMujk6ujg5+AJ8S26svgUd1MnFuBAGN4yYYFKJFoSmtLYOTIiUehUWn+2Su+eT3C+5izPlxGcK7Fy9n/kQi1qqJvzz+339egSoGb3TbEImLokbpv3JdlGTgVEA4HBDZymjCAOVqjG0nu0MxuXmqc1L1wEGA9IUiZVMgvJ8CmXCdYYCDMvF8Xz2FtN4QKvncvvc4aFlcVIqRgcAMorEVkEbLAqgqzIXdZPmhxM4M+EZFLRBqeV6gfuEgUbHBiCvBleEBhzP58126fU9Hk2bu2aX8lyKnCr/DdBo96lUDZKyhK7KHKxmKRVTE8+FBtZzSY4282G3/x4QzT8BdhfSxAQf2FDAWi4p1v4T8Go5wmUArucHA5d1MxLwPcPA8XLk7xKgNhaYQqYOfAG841NHMaz6lQAAAABJRU5ErkJggg==","contentType":"image/png","width":18,"height":18,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

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: Unit ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• COMPTYPE (type: esriFieldTypeSmallInteger, alias: COMPTYPE, 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: Location/Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• LOC_AREA (type: esriFieldTypeString, alias: Area, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [6203: 6203 - MIGRATION], [6208: 6208 - MIGRATION], [6217: 6217 - MIGRATION], ... 224 more ...)
• DISTRICT (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [109: 109], [BM: BM - BEERESCOURT/MAEROA], [CO: CO - CENTRAL], ... 15 more ...)
• LOC (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [BERM: BERM -], [CARP: CARP - IN CARPARK], [CONC: CONC - ON CONCRETE PAD], ... 84 more ...)
• MAPNO (type: esriFieldTypeString, alias: Map No, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UNITTYPE (type: esriFieldTypeString, alias: Equipment Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [ABS: ABS - ABS PUMP], [FLYGT: FLYGT - FLYGT PUMP], [HOMA: HOMA - HOMA PUMP], ... 5 more ...)
• MFGKEY (type: esriFieldTypeInteger, alias: Manufacturer, SQL Type: sqlTypeOther, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MODELNO (type: esriFieldTypeString, alias: Model No., SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SERNO (type: esriFieldTypeString, alias: Serial No., SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OPERLIC (type: esriFieldTypeString, alias: Operating Licence, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PURCCOST (type: esriFieldTypeDouble, alias: Purchase Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WARREXP (type: esriFieldTypeDate, alias: Warranty Expire, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WARRUSG (type: esriFieldTypeDouble, alias: Warranty Usage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EXPECTLIFE (type: esriFieldTypeDouble, alias: Expected Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EXPECTLIFEUOM (type: esriFieldTypeString, alias: Expected Life UOM, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• AVGMONUSG (type: esriFieldTypeDouble, alias: Average Monthly Usage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AVGMONUSGUOM (type: esriFieldTypeString, alias: Average Monthly Usage UOM, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• USGTOT (type: esriFieldTypeDouble, alias: Total Usage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MTBF (type: esriFieldTypeDouble, alias: MTBF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MTBFUOM (type: esriFieldTypeString, alias: MTBFUOM, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• POSITION (type: esriFieldTypeInteger, alias: Position, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMPLEXKEY (type: esriFieldTypeInteger, alias: Complex, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SITEKEY (type: esriFieldTypeInteger, alias: Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MFGDATE (type: esriFieldTypeDate, alias: Manufactured Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PURCDATE (type: esriFieldTypeDate, alias: Purchased Date, SQL Type: sqlTypeOther, length: 8, 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: Ownership, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, 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 Plan, 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)
• 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)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: Booster Pump
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• COMPTYPE: 3
• SERVSTAT: C

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   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat