All Layers and Tables (wm_Stormwater

Layers:

Layer: Inlets And Outlets (0)

Name:

Display Field:

Type:

Geometry Type:

Has Views:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,168,2,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"transparency":0,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
CREATOR (type: esriFieldTypeString, alias: CREATOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
EDITOR (type: esriFieldTypeString, alias: EDITOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CREATED (type: esriFieldTypeDate, alias: CREATED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
EDITED (type: esriFieldTypeDate, alias: EDITED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
VALIDATIONSTATE (type: esriFieldTypeSmallInteger, alias: VALIDATIONSTATE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Not Valid], [1: Not Valid and Public], [2: Valid and Private], ... 1 more ...)
RELIABILITY_GEOMETRY (type: esriFieldTypeString, alias: RELIABILITY_GEOMETRY, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 6 more ...)
Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
GlobalID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
PARENTID (type: esriFieldTypeString, alias: PARENTID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SW_FACILITY_TYPE (type: esriFieldTypeSmallInteger, alias: SW_FACILITY_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_OBJECTTYPE (type: esriFieldTypeString, alias: SW_OBJECTTYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SW_AS_BUILT_DOCUMENT_URL (type: esriFieldTypeString, alias: SW_AS_BUILT_DOCUMENT_URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SW_SAP_OBJECT_NUMBER (type: esriFieldTypeString, alias: SW_SAP_OBJECT_NUMBER, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SW_ACTIVITY_TYPE (type: esriFieldTypeString, alias: SW_ACTIVITY_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [CONV: Conversion], [DISP: Disposal or Deletion], [NCAP: New Capital], ... 10 more ...)
SW_AREA_M2 (type: esriFieldTypeDouble, alias: SW_AREA_M2, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_ASBUILT_REGISTER_ID (type: esriFieldTypeString, alias: SW_ASBUILT_REGISTER_ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SW_ASSET_MAINTAINER (type: esriFieldTypeString, alias: SW_ASSET_MAINTAINER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [DOC: Department of Conservation], [NZTA: New Zealand Transport Agency], [PARKS: AC - Parks], ... 7 more ...)
SW_ASSET_OWNER (type: esriFieldTypeString, alias: SW_ASSET_OWNER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [DOC: Department of Conservation], [NZTA: New Zealand Transport Agency], [PARKS: AC - Parks], ... 7 more ...)
SW_ASSET_TYPE (type: esriFieldTypeString, alias: SW_ASSET_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [PNTI: Inlet (No Structure) Point], [PNTO: Outlet (No Structure) Point], [STDI: Standard Inlet], ... 1 more ...)
SW_CAP_CLIMATE_CHANGE_ALLOWANCE (type: esriFieldTypeString, alias: SW_CAP_CLIMATE_CHANGE_ALLOWANCE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: )
SW_CAP_EXIST_RECURR_INTERVAL (type: esriFieldTypeSmallInteger, alias: SW_CAP_EXIST_RECURR_INTERVAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAP_FUTURE_RECURR_INTERVAL (type: esriFieldTypeSmallInteger, alias: SW_CAP_FUTURE_RECURR_INTERVAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAPACITY_COMMENTS (type: esriFieldTypeString, alias: SW_CAPACITY_COMMENTS, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SW_CAPACITY_COMPANY (type: esriFieldTypeString, alias: SW_CAPACITY_COMPANY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_CAPACITY_DEV_SCENARIO (type: esriFieldTypeString, alias: SW_CAPACITY_DEV_SCENARIO, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
SW_CAPACITY_EXISTING_FLOW_RATE (type: esriFieldTypeInteger, alias: SW_CAPACITY_EXISTING_FLOW_RATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAPACITY_FUTURE_FLOW_RATE (type: esriFieldTypeInteger, alias: SW_CAPACITY_FUTURE_FLOW_RATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAPACITY_MODEL_DATE (type: esriFieldTypeDate, alias: SW_CAPACITY_MODEL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_CAPACITY_MODEL_SOURCE (type: esriFieldTypeString, alias: SW_CAPACITY_MODEL_SOURCE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_CAPACITY_MODEL_TYPE (type: esriFieldTypeString, alias: SW_CAPACITY_MODEL_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [1D: One Dimensional], [1D2D: One and Two Dimensional], [2D: Two Dimensional], ... 1 more ...)
SW_CAPACITY_NEW_MODEL_UNDERWAY (type: esriFieldTypeString, alias: SW_CAPACITY_NEW_MODEL_UNDERWAY, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: )
SW_CAPACITY_RAINFALL_EVENT_YR (type: esriFieldTypeSmallInteger, alias: SW_CAPACITY_RAINFALL_EVENT_YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAPACITY_SOFTWARE_USED (type: esriFieldTypeString, alias: SW_CAPACITY_SOFTWARE_USED, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_CAPACITY_SOFTWARE_VERSION (type: esriFieldTypeString, alias: SW_CAPACITY_SOFTWARE_VERSION, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SW_CONDITION_DATE (type: esriFieldTypeDate, alias: SW_CONDITION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_CONDITION_RATING (type: esriFieldTypeString, alias: SW_CONDITION_RATING, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [1: Very Good], [2: Good], [3: Average], ... 2 more ...)
SW_CONDITION_SERVICE_PEAK (type: esriFieldTypeDouble, alias: SW_CONDITION_SERVICE_PEAK, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CONDITION_STRUCTURAL_GRADE (type: esriFieldTypeDouble, alias: SW_CONDITION_STRUCTURAL_GRADE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CONDITION_STRUCTURAL_MEAN (type: esriFieldTypeDouble, alias: SW_CONDITION_STRUCTURAL_MEAN, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CONDITION_STRUCTURAL_PEAK (type: esriFieldTypeDouble, alias: SW_CONDITION_STRUCTURAL_PEAK, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CONSENT_DATE (type: esriFieldTypeDate, alias: SW_CONSENT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_CONSENT_EXPIRY_DATE (type: esriFieldTypeDate, alias: SW_CONSENT_EXPIRY_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_CONSENT_ID (type: esriFieldTypeString, alias: SW_CONSENT_ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_COVER_TYPE (type: esriFieldTypeString, alias: SW_COVER_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [DOME: Scruffy Domed Steel Grill], [GRAT: Grated], [NONE: None], ... 2 more ...)
SW_CRE (type: esriFieldTypeString, alias: SW_CRE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [HIBISCUS_COAST: Hibiscus Coast], [ISLANDS: Islands], [KAIPARA: Kaipara], ... 7 more ...)
SW_CRITICALITY_RATING_DATE (type: esriFieldTypeDate, alias: SW_CRITICALITY_RATING_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_CRITICALITY_RATING_SOURCE (type: esriFieldTypeString, alias: SW_CRITICALITY_RATING_SOURCE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [MANL: Manual Override of Model], [MODL: Data Source from Model])
SW_CRITICALITY_RATING_VALUE (type: esriFieldTypeString, alias: SW_CRITICALITY_RATING_VALUE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [1: Not Critical], [2: Low], [3: Medium], ... 2 more ...)
SW_DECOMMISSION_DATE (type: esriFieldTypeDate, alias: SW_DECOMMISSION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_DESCRIPTION (type: esriFieldTypeString, alias: SW_DESCRIPTION, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SW_DIAMETER_CONNECTION_MM (type: esriFieldTypeInteger, alias: SW_DIAMETER_CONNECTION_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_DISSIPATING_STRUCTURE_TYPE (type: esriFieldTypeString, alias: SW_DISSIPATING_STRUCTURE_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [APRN: Apron], [BUBB: Bubble Up Chamber], [CONC: Concrete], ... 7 more ...)
SW_FISH_PASS_STRUCTURE_TYPE (type: esriFieldTypeString, alias: SW_FISH_PASS_STRUCTURE_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [BAFL: Baffles], [NONE: None], [RAMP: Fish Ramp], ... 2 more ...)
SW_HAS_BACKFLOW_VALVE (type: esriFieldTypeString, alias: SW_HAS_BACKFLOW_VALVE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
SW_HAS_FLAP_GATE (type: esriFieldTypeString, alias: SW_HAS_FLAP_GATE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
SW_HAS_GRATE_OR_GRILL (type: esriFieldTypeString, alias: SW_HAS_GRATE_OR_GRILL, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
SW_HAS_SAFETY_FENCE (type: esriFieldTypeString, alias: SW_HAS_SAFETY_FENCE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
SW_HAS_SCADA_SYSTEM (type: esriFieldTypeString, alias: SW_HAS_SCADA_SYSTEM, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
SW_INSTALLATION_DATE (type: esriFieldTypeDate, alias: SW_INSTALLATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_INVERT_LEVEL_M (type: esriFieldTypeDouble, alias: SW_INVERT_LEVEL_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_LEGACY_ASSET_ID (type: esriFieldTypeString, alias: SW_LEGACY_ASSET_ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_LEGACY_SOURCE_DOCUMENT_REF (type: esriFieldTypeString, alias: SW_LEGACY_SOURCE_DOCUMENT_REF, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_LENGTH_MM (type: esriFieldTypeInteger, alias: SW_LENGTH_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_LOCAL_BOARD (type: esriFieldTypeString, alias: SW_LOCAL_BOARD, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [100: Albert-Eden], [105: Devonport-Takapuna], [110: Franklin], ... 18 more ...)
SW_MANUFACTURER (type: esriFieldTypeString, alias: SW_MANUFACTURER, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_MATERIAL (type: esriFieldTypeString, alias: SW_MATERIAL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABCM: Asbestos Cement], [ALKA: Alkathene], [ALUM: Aluminium], ... 32 more ...)
SW_OPERATIONAL_AREA (type: esriFieldTypeString, alias: SW_OPERATIONAL_AREA, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [SC: Stormwater Central], [SN: Stormwater North], [SS: Stormwater South], ... 1 more ...)
SW_PROJECT_OR_SUBDIVISION_NO (type: esriFieldTypeString, alias: SW_PROJECT_OR_SUBDIVISION_NO, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_RECEIVING_ENVIRONMENT (type: esriFieldTypeString, alias: SW_RECEIVING_ENVIRONMENT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [AQFR: Aquifer], [CHNL: Channel], [CMAB: Coastal Marine Area Beach], ... 5 more ...)
SW_RELIABILITY_DIAMETER (type: esriFieldTypeString, alias: SW_RELIABILITY_DIAMETER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 7 more ...)
SW_RELIABILITY_INSTALLATION (type: esriFieldTypeString, alias: SW_RELIABILITY_INSTALLATION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 7 more ...)
SW_RELIABILITY_MATERIAL (type: esriFieldTypeString, alias: SW_RELIABILITY_MATERIAL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 7 more ...)
SW_RENEWAL_MODEL_DATE (type: esriFieldTypeDate, alias: SW_RENEWAL_MODEL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_RENEWAL_MODEL_INCL_FORECAST (type: esriFieldTypeString, alias: SW_RENEWAL_MODEL_INCL_FORECAST, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
SW_RENEWAL_MODEL_TYPE (type: esriFieldTypeString, alias: SW_RENEWAL_MODEL_TYPE, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SW_RENEWAL_REMAINING_LIFE (type: esriFieldTypeSmallInteger, alias: SW_RENEWAL_REMAINING_LIFE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_RISK (type: esriFieldTypeString, alias: SW_RISK, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [1: Not at Risk], [2: Low], [3: Medium], ... 2 more ...)
SW_RISK_DATE (type: esriFieldTypeDate, alias: SW_RISK_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_SAP_ID (type: esriFieldTypeString, alias: SW_SAP_ID, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
SW_STATUS (type: esriFieldTypeString, alias: SW_STATUS, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABAN: Abandoned], [DATA: Data Error], [DECO: Decommissioned], ... 3 more ...)
SW_STATUS_CHANGE_REASON (type: esriFieldTypeString, alias: SW_STATUS_CHANGE_REASON, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [BOVR: Buildover], [ENDL: End Of Useful Life], [INCP: Inadequate Capacity], ... 5 more ...)
SW_STORMWATER_CATCHMENT (type: esriFieldTypeString, alias: SW_STORMWATER_CATCHMENT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [085: Awaruku], [088: Campbells Bay], [090: Castor Bay], ... 229 more ...)
SW_VALUATION_ANNUAL_DEPREC (type: esriFieldTypeDouble, alias: SW_VALUATION_ANNUAL_DEPREC, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_VALUATION_DATE (type: esriFieldTypeDate, alias: SW_VALUATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_VALUATION_DEPREC_REPL_COST (type: esriFieldTypeDouble, alias: SW_VALUATION_DEPREC_REPL_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_VALUATION_EXPECTED_LIFE (type: esriFieldTypeSmallInteger, alias: SW_VALUATION_EXPECTED_LIFE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_VALUATION_OPT_REPL_COST (type: esriFieldTypeDouble, alias: SW_VALUATION_OPT_REPL_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_VALUATION_UNIT_COST (type: esriFieldTypeDouble, alias: SW_VALUATION_UNIT_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_WIDTH_MM (type: esriFieldTypeInteger, alias: SW_WIDTH_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_GIS_ID (type: esriFieldTypeString, alias: SW_GIS_ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Range: [1/1/1990 12:00:00 AM - 1/1/2050 12:00:00 AM])
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Range: [1/1/1990 12:00:00 AM - 1/1/2050 12:00:00 AM])

Templates:

VALIDATIONSTATE: 0

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Layer: Soakage System (1)

Name:

Display Field:

Type:

Geometry Type:

Has Views:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[132,108,252,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,255,255],"width":0.75}}},"transparency":0,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
CREATOR (type: esriFieldTypeString, alias: CREATOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
EDITOR (type: esriFieldTypeString, alias: EDITOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CREATED (type: esriFieldTypeDate, alias: CREATED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
EDITED (type: esriFieldTypeDate, alias: EDITED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
VALIDATIONSTATE (type: esriFieldTypeSmallInteger, alias: VALIDATIONSTATE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Not Valid], [1: Not Valid and Public], [2: Valid and Private], ... 1 more ...)
RELIABILITY_GEOMETRY (type: esriFieldTypeString, alias: RELIABILITY_GEOMETRY, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 6 more ...)
Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
GlobalID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
PARENTID (type: esriFieldTypeString, alias: PARENTID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SW_FACILITY_TYPE (type: esriFieldTypeSmallInteger, alias: SW_FACILITY_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_OBJECTTYPE (type: esriFieldTypeString, alias: SW_OBJECTTYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SW_AS_BUILT_DOCUMENT_URL (type: esriFieldTypeString, alias: SW_AS_BUILT_DOCUMENT_URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SW_SAP_OBJECT_NUMBER (type: esriFieldTypeString, alias: SW_SAP_OBJECT_NUMBER, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SW_ACTIVITY_TYPE (type: esriFieldTypeString, alias: SW_ACTIVITY_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [CAVE: Cavern], [CHMB: Chamber], [INFL: Infiltration Basin], ... 2 more ...)
SW_AREA_CONTRIB_CATCHMENT_M2 (type: esriFieldTypeInteger, alias: SW_AREA_CONTRIB_CATCHMENT_M2, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_ASBUILT_REGISTER_ID (type: esriFieldTypeString, alias: SW_ASBUILT_REGISTER_ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SW_ASSET_MAINTAINER (type: esriFieldTypeString, alias: SW_ASSET_MAINTAINER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [DOC: Department of Conservation], [NZTA: New Zealand Transport Agency], [PARKS: AC - Parks], ... 7 more ...)
SW_ASSET_OWNER (type: esriFieldTypeString, alias: SW_ASSET_OWNER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [DOC: Department of Conservation], [NZTA: New Zealand Transport Agency], [PARKS: AC - Parks], ... 7 more ...)
SW_ASSET_TYPE (type: esriFieldTypeString, alias: SW_ASSET_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [BRDG: Bridge], [BUBB: Bubble Up Catchpit], [CART: Cartridge Filter], ... 93 more ...)
SW_CAP_CLIMATE_CHANGE_ALLOWANCE (type: esriFieldTypeString, alias: SW_CAP_CLIMATE_CHANGE_ALLOWANCE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: )
SW_CAP_EXIST_RECURR_INTERVAL (type: esriFieldTypeSmallInteger, alias: SW_CAP_EXIST_RECURR_INTERVAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAP_FUTURE_RECURR_INTERVAL (type: esriFieldTypeSmallInteger, alias: SW_CAP_FUTURE_RECURR_INTERVAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAPACITY_COMMENTS (type: esriFieldTypeString, alias: SW_CAPACITY_COMMENTS, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SW_CAPACITY_COMPANY (type: esriFieldTypeString, alias: SW_CAPACITY_COMPANY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_CAPACITY_DEV_SCENARIO (type: esriFieldTypeString, alias: SW_CAPACITY_DEV_SCENARIO, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
SW_CAPACITY_EXISTING_FLOW_RATE (type: esriFieldTypeInteger, alias: SW_CAPACITY_EXISTING_FLOW_RATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAPACITY_FUTURE_FLOW_RATE (type: esriFieldTypeInteger, alias: SW_CAPACITY_FUTURE_FLOW_RATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAPACITY_MODEL_DATE (type: esriFieldTypeDate, alias: SW_CAPACITY_MODEL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_CAPACITY_MODEL_SOURCE (type: esriFieldTypeString, alias: SW_CAPACITY_MODEL_SOURCE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_CAPACITY_MODEL_TYPE (type: esriFieldTypeString, alias: SW_CAPACITY_MODEL_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [1D: One Dimensional], [1D2D: One and Two Dimensional], [2D: Two Dimensional], ... 1 more ...)
SW_CAPACITY_NEW_MODEL_UNDERWAY (type: esriFieldTypeString, alias: SW_CAPACITY_NEW_MODEL_UNDERWAY, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: )
SW_CAPACITY_RAINFALL_EVENT_YR (type: esriFieldTypeSmallInteger, alias: SW_CAPACITY_RAINFALL_EVENT_YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAPACITY_SOFTWARE_USED (type: esriFieldTypeString, alias: SW_CAPACITY_SOFTWARE_USED, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_CAPACITY_SOFTWARE_VERSION (type: esriFieldTypeString, alias: SW_CAPACITY_SOFTWARE_VERSION, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SW_CONDITION_DATE (type: esriFieldTypeDate, alias: SW_CONDITION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_CONDITION_RATING (type: esriFieldTypeString, alias: SW_CONDITION_RATING, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [1: Very Good], [2: Good], [3: Average], ... 2 more ...)
SW_CRE (type: esriFieldTypeString, alias: SW_CRE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [HIBISCUS_COAST: Hibiscus Coast], [ISLANDS: Islands], [KAIPARA: Kaipara], ... 7 more ...)
SW_CRITICALITY_RATING_DATE (type: esriFieldTypeDate, alias: SW_CRITICALITY_RATING_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_CRITICALITY_RATING_SOURCE (type: esriFieldTypeString, alias: SW_CRITICALITY_RATING_SOURCE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [MANL: Manual Override of Model], [MODL: Data Source from Model])
SW_CRITICALITY_RATING_VALUE (type: esriFieldTypeString, alias: SW_CRITICALITY_RATING_VALUE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [1: Not Critical], [2: Low], [3: Medium], ... 2 more ...)
SW_DECOMMISSION_DATE (type: esriFieldTypeDate, alias: SW_DECOMMISSION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_DEPTH_STORAGE_M (type: esriFieldTypeDouble, alias: SW_DEPTH_STORAGE_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_DEPTH_TO_BEDROCK_M (type: esriFieldTypeDouble, alias: SW_DEPTH_TO_BEDROCK_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_DEPTH_TO_INVERT_M (type: esriFieldTypeDouble, alias: SW_DEPTH_TO_INVERT_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_DEPTH_TO_WATER_TABLE_M (type: esriFieldTypeDouble, alias: SW_DEPTH_TO_WATER_TABLE_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_DESCRIPTION (type: esriFieldTypeString, alias: SW_DESCRIPTION, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SW_DIAMETER_MANHOLE_MM (type: esriFieldTypeInteger, alias: SW_DIAMETER_MANHOLE_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_DIAMETER_MM (type: esriFieldTypeInteger, alias: SW_DIAMETER_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_DISCHARGE_MECHANISM (type: esriFieldTypeString, alias: SW_DISCHARGE_MECHANISM, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [BORE: Bore], [FRAC: Fractured Wall or Base], [TREN: Trench])
SW_EASEMENT_REFERENCE (type: esriFieldTypeString, alias: SW_EASEMENT_REFERENCE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_HAS_BYPASS (type: esriFieldTypeString, alias: SW_HAS_BYPASS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
SW_INSTALLATION_DATE (type: esriFieldTypeDate, alias: SW_INSTALLATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_INVERT_LEVEL_M (type: esriFieldTypeDouble, alias: SW_INVERT_LEVEL_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_IS_LINED (type: esriFieldTypeString, alias: SW_IS_LINED, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
SW_LEGACY_ASSET_ID (type: esriFieldTypeString, alias: SW_LEGACY_ASSET_ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_LEGACY_SOURCE_DOCUMENT_REF (type: esriFieldTypeString, alias: SW_LEGACY_SOURCE_DOCUMENT_REF, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_LENGTH_M (type: esriFieldTypeDouble, alias: SW_LENGTH_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_LID_LEVEL_M (type: esriFieldTypeDouble, alias: SW_LID_LEVEL_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_LOCAL_BOARD (type: esriFieldTypeString, alias: SW_LOCAL_BOARD, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [100: Albert-Eden], [105: Devonport-Takapuna], [110: Franklin], ... 18 more ...)
SW_NAME (type: esriFieldTypeString, alias: SW_NAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_NUMBER_BORES (type: esriFieldTypeSmallInteger, alias: SW_NUMBER_BORES, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_OPERATIONAL_AREA (type: esriFieldTypeString, alias: SW_OPERATIONAL_AREA, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [SC: Stormwater Central], [SN: Stormwater North], [SS: Stormwater South], ... 1 more ...)
SW_PROJECT_OR_SUBDIVISION_NO (type: esriFieldTypeString, alias: SW_PROJECT_OR_SUBDIVISION_NO, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_RELIABILITY_DEPTH (type: esriFieldTypeString, alias: SW_RELIABILITY_DEPTH, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 7 more ...)
SW_RELIABILITY_DIAMETER (type: esriFieldTypeString, alias: SW_RELIABILITY_DIAMETER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 7 more ...)
SW_RELIABILITY_INSTALLATION (type: esriFieldTypeString, alias: SW_RELIABILITY_INSTALLATION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 7 more ...)
SW_RENEWAL_MODEL_DATE (type: esriFieldTypeDate, alias: SW_RENEWAL_MODEL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_RENEWAL_MODEL_INCL_FORECAST (type: esriFieldTypeString, alias: SW_RENEWAL_MODEL_INCL_FORECAST, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
SW_RENEWAL_MODEL_TYPE (type: esriFieldTypeString, alias: SW_RENEWAL_MODEL_TYPE, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SW_RENEWAL_REMAINING_LIFE (type: esriFieldTypeSmallInteger, alias: SW_RENEWAL_REMAINING_LIFE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_RISK (type: esriFieldTypeString, alias: SW_RISK, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [1: Not at Risk], [2: Low], [3: Medium], ... 2 more ...)
SW_RISK_DATE (type: esriFieldTypeDate, alias: SW_RISK_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_SAP_ID (type: esriFieldTypeString, alias: SW_SAP_ID, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
SW_SOAKAGE_GEOLOGY (type: esriFieldTypeString, alias: SW_SOAKAGE_GEOLOGY, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [BSLT: Fractured Basalt], [SCOR: Scoria], [WAIT: Waitemata Series])
SW_STATUS (type: esriFieldTypeString, alias: SW_STATUS, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABAN: Abandoned], [DATA: Data Error], [DECO: Decommissioned], ... 3 more ...)
SW_STATUS_CHANGE_REASON (type: esriFieldTypeString, alias: SW_STATUS_CHANGE_REASON, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [BOVR: Buildover], [ENDL: End Of Useful Life], [INCP: Inadequate Capacity], ... 5 more ...)
SW_STORAGE_CAPACITY_M3 (type: esriFieldTypeInteger, alias: SW_STORAGE_CAPACITY_M3, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_STORMWATER_CATCHMENT (type: esriFieldTypeString, alias: SW_STORMWATER_CATCHMENT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [085: Awaruku], [088: Campbells Bay], [090: Castor Bay], ... 229 more ...)
SW_SUB_CATCHMENT (type: esriFieldTypeString, alias: SW_SUB_CATCHMENT, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_VALUATION_ANNUAL_DEPREC (type: esriFieldTypeDouble, alias: SW_VALUATION_ANNUAL_DEPREC, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_VALUATION_DATE (type: esriFieldTypeDate, alias: SW_VALUATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_VALUATION_DEPREC_REPL_COST (type: esriFieldTypeDouble, alias: SW_VALUATION_DEPREC_REPL_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_VALUATION_EXPECTED_LIFE (type: esriFieldTypeSmallInteger, alias: SW_VALUATION_EXPECTED_LIFE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_VALUATION_OPT_REPL_COST (type: esriFieldTypeDouble, alias: SW_VALUATION_OPT_REPL_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_VALUATION_UNIT_COST (type: esriFieldTypeDouble, alias: SW_VALUATION_UNIT_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_WIDTH_M (type: esriFieldTypeDouble, alias: SW_WIDTH_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_GIS_ID (type: esriFieldTypeString, alias: SW_GIS_ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Range: [1/1/1990 12:00:00 AM - 1/1/2050 12:00:00 AM])
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Range: [1/1/1990 12:00:00 AM - 1/1/2050 12:00:00 AM])

Templates:

VALIDATIONSTATE: 0

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Layer: Pipes (2)

Name:

Display Field:

Type:

Geometry Type:

Has Views:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[244,146,236,255],"width":1.5}},"transparency":0,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
CREATOR (type: esriFieldTypeString, alias: CREATOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
EDITOR (type: esriFieldTypeString, alias: EDITOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CREATED (type: esriFieldTypeDate, alias: CREATED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
EDITED (type: esriFieldTypeDate, alias: EDITED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
VALIDATIONSTATE (type: esriFieldTypeSmallInteger, alias: VALIDATIONSTATE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Not Valid], [1: Not Valid and Public], [2: Valid and Private], ... 1 more ...)
PARENTID (type: esriFieldTypeString, alias: PARENTID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SPLIT (type: esriFieldTypeSmallInteger, alias: SPLIT, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
RELIABILITY_GEOMETRY (type: esriFieldTypeString, alias: RELIABILITY_GEOMETRY, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 6 more ...)
Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
GlobalID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
SW_FACILITY_TYPE (type: esriFieldTypeSmallInteger, alias: SW_FACILITY_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_OBJECTTYPE (type: esriFieldTypeString, alias: SW_OBJECTTYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SW_AS_BUILT_DOCUMENT_URL (type: esriFieldTypeString, alias: SW_AS_BUILT_DOCUMENT_URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SW_SAP_OBJECT_NUMBER (type: esriFieldTypeString, alias: SW_SAP_OBJECT_NUMBER, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SW_ACTIVITY_TYPE (type: esriFieldTypeString, alias: SW_ACTIVITY_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [CONV: Conversion], [DISP: Disposal or Deletion], [NCAP: New Capital], ... 10 more ...)
SW_ASBUILT_REGISTER_ID (type: esriFieldTypeString, alias: SW_ASBUILT_REGISTER_ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SW_ASSET_MAINTAINER (type: esriFieldTypeString, alias: SW_ASSET_MAINTAINER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [DOC: Department of Conservation], [NZTA: New Zealand Transport Agency], [PARKS: AC - Parks], ... 7 more ...)
SW_ASSET_OWNER (type: esriFieldTypeString, alias: SW_ASSET_OWNER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [DOC: Department of Conservation], [NZTA: New Zealand Transport Agency], [PARKS: AC - Parks], ... 7 more ...)
SW_ASSET_TYPE (type: esriFieldTypeString, alias: SW_ASSET_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [BRDG: Pipe Bridge], [CULV: Culvert], [GRVY: Gravity Main], ... 5 more ...)
SW_BEDDING_TYPE (type: esriFieldTypeString, alias: SW_BEDDING_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [CONC: Concrete], [GAP11: Aggregate Passing 11mm Screen], [GAP7: Aggregate Passing 7mm Screen], ... 6 more ...)
SW_CAP_CLIMATE_CHANGE_ALLOWANCE (type: esriFieldTypeString, alias: SW_CAP_CLIMATE_CHANGE_ALLOWANCE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: )
SW_CAP_EXIST_RECURR_INTERVAL (type: esriFieldTypeSmallInteger, alias: SW_CAP_EXIST_RECURR_INTERVAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAP_FUTURE_RECURR_INTERVAL (type: esriFieldTypeSmallInteger, alias: SW_CAP_FUTURE_RECURR_INTERVAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAPACITY_COMMENTS (type: esriFieldTypeString, alias: SW_CAPACITY_COMMENTS, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SW_CAPACITY_COMPANY (type: esriFieldTypeString, alias: SW_CAPACITY_COMPANY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_CAPACITY_DEV_SCENARIO (type: esriFieldTypeString, alias: SW_CAPACITY_DEV_SCENARIO, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
SW_CAPACITY_EXISTING_FLOW_RATE (type: esriFieldTypeInteger, alias: SW_CAPACITY_EXISTING_FLOW_RATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAPACITY_FUTURE_FLOW_RATE (type: esriFieldTypeInteger, alias: SW_CAPACITY_FUTURE_FLOW_RATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAPACITY_MODEL_DATE (type: esriFieldTypeDate, alias: SW_CAPACITY_MODEL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_CAPACITY_MODEL_SOURCE (type: esriFieldTypeString, alias: SW_CAPACITY_MODEL_SOURCE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_CAPACITY_MODEL_TYPE (type: esriFieldTypeString, alias: SW_CAPACITY_MODEL_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [1D: One Dimensional], [1D2D: One and Two Dimensional], [2D: Two Dimensional], ... 1 more ...)
SW_CAPACITY_NEW_MODEL_UNDERWAY (type: esriFieldTypeString, alias: SW_CAPACITY_NEW_MODEL_UNDERWAY, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: )
SW_CAPACITY_RAINFALL_EVENT_YR (type: esriFieldTypeSmallInteger, alias: SW_CAPACITY_RAINFALL_EVENT_YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CAPACITY_SOFTWARE_USED (type: esriFieldTypeString, alias: SW_CAPACITY_SOFTWARE_USED, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_CAPACITY_SOFTWARE_VERSION (type: esriFieldTypeString, alias: SW_CAPACITY_SOFTWARE_VERSION, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SW_CONDITION_DATE (type: esriFieldTypeDate, alias: SW_CONDITION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_CONDITION_RATING (type: esriFieldTypeString, alias: SW_CONDITION_RATING, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [1: Very Good], [2: Good], [3: Average], ... 2 more ...)
SW_CONDITION_SERVICE_PEAK (type: esriFieldTypeDouble, alias: SW_CONDITION_SERVICE_PEAK, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CONDITION_STRUCTURAL_GRADE (type: esriFieldTypeDouble, alias: SW_CONDITION_STRUCTURAL_GRADE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CONDITION_STRUCTURAL_MEAN (type: esriFieldTypeDouble, alias: SW_CONDITION_STRUCTURAL_MEAN, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CONDITION_STRUCTURAL_PEAK (type: esriFieldTypeDouble, alias: SW_CONDITION_STRUCTURAL_PEAK, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_CRE (type: esriFieldTypeString, alias: SW_CRE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [HIBISCUS_COAST: Hibiscus Coast], [ISLANDS: Islands], [KAIPARA: Kaipara], ... 7 more ...)
SW_CRITICALITY_RATING_DATE (type: esriFieldTypeDate, alias: SW_CRITICALITY_RATING_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_CRITICALITY_RATING_SOURCE (type: esriFieldTypeString, alias: SW_CRITICALITY_RATING_SOURCE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [MANL: Manual Override of Model], [MODL: Data Source from Model])
SW_CRITICALITY_RATING_VALUE (type: esriFieldTypeString, alias: SW_CRITICALITY_RATING_VALUE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [1: Not Critical], [2: Low], [3: Medium], ... 2 more ...)
SW_DECOMMISSION_DATE (type: esriFieldTypeDate, alias: SW_DECOMMISSION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_DEPTH_DOWNSTREAM_M (type: esriFieldTypeDouble, alias: SW_DEPTH_DOWNSTREAM_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_DEPTH_UPSTREAM_M (type: esriFieldTypeDouble, alias: SW_DEPTH_UPSTREAM_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_DESCRIPTION (type: esriFieldTypeString, alias: SW_DESCRIPTION, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SW_DIAMETER_LINING_MM (type: esriFieldTypeInteger, alias: SW_DIAMETER_LINING_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_DIAMETER_MM (type: esriFieldTypeInteger, alias: SW_DIAMETER_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_DIAMETER_TYPE (type: esriFieldTypeString, alias: SW_DIAMETER_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [EXTD: External Diameter], [INTD: Internal Diameter])
SW_DROP_TYPE_DOWNSTREAM (type: esriFieldTypeString, alias: SW_DROP_TYPE_DOWNSTREAM, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [CASC: Cascade], [EXTD: External Drop], [INTD: Internal Drop], ... 1 more ...)
SW_FISH_PASS_STRUCTURE_TYPE (type: esriFieldTypeString, alias: SW_FISH_PASS_STRUCTURE_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [BAFL: Baffles], [NONE: None], [RAMP: Fish Ramp], ... 2 more ...)
SW_GRADIENT_PC (type: esriFieldTypeSmallInteger, alias: SW_GRADIENT_PC, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_HEIGHT_MM (type: esriFieldTypeInteger, alias: SW_HEIGHT_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_INSTALLATION_DATE (type: esriFieldTypeDate, alias: SW_INSTALLATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_INSTALLATION_TYPE (type: esriFieldTypeString, alias: SW_INSTALLATION_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [BORE: Bore], [BURT: Pipe Bursting], [HZDD: Horizontal Direction Drilling], ... 6 more ...)
SW_INVERT_LEVEL_DOWNSTREAM_M (type: esriFieldTypeDouble, alias: SW_INVERT_LEVEL_DOWNSTREAM_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_INVERT_LEVEL_UPSTREAM_M (type: esriFieldTypeDouble, alias: SW_INVERT_LEVEL_UPSTREAM_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_IS_LINED (type: esriFieldTypeString, alias: SW_IS_LINED, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
SW_JOINT_TYPE (type: esriFieldTypeString, alias: SW_JOINT_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [FLAN: Flanged Joint], [FLSH: Flush Joint], [FUSE: Fused Joint - Pipe Welded], ... 5 more ...)
SW_LEGACY_ASSET_ID (type: esriFieldTypeString, alias: SW_LEGACY_ASSET_ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_LEGACY_SOURCE_DOCUMENT_REF (type: esriFieldTypeString, alias: SW_LEGACY_SOURCE_DOCUMENT_REF, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_LENGTH_GIS_M (type: esriFieldTypeDouble, alias: SW_LENGTH_GIS_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_LINING_DATE (type: esriFieldTypeDate, alias: SW_LINING_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_LOCAL_BOARD (type: esriFieldTypeString, alias: SW_LOCAL_BOARD, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [100: Albert-Eden], [105: Devonport-Takapuna], [110: Franklin], ... 18 more ...)
SW_MANUFACTURER (type: esriFieldTypeString, alias: SW_MANUFACTURER, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_MATERIAL (type: esriFieldTypeString, alias: SW_MATERIAL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABCM: Asbestos Cement], [ALKA: Alkathene], [ALUM: Aluminium], ... 32 more ...)
SW_MATERIAL_resolved (type: esriFieldTypeString, alias: SW_MATERIAL_resolved, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
SW_MATERIAL_GRADE (type: esriFieldTypeString, alias: SW_MATERIAL_GRADE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_MATERIAL_LINING (type: esriFieldTypeString, alias: SW_MATERIAL_LINING, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [CIPP: Cured In Place Polymer], [CLAY: Clay], [CONC: Concrete, Shotcrete, etc], ... 10 more ...)
SW_MATERIAL_SUBGROUP (type: esriFieldTypeString, alias: SW_MATERIAL_SUBGROUP, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [SPUN: Spun Concrete], [REIN: Reinforced Concrete], [ALUF: ALUFLO], ... 8 more ...)
SW_OPERATIONAL_AREA (type: esriFieldTypeString, alias: SW_OPERATIONAL_AREA, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [SC: Stormwater Central], [SN: Stormwater North], [SS: Stormwater South], ... 1 more ...)
SW_PROJECT_OR_SUBDIVISION_NO (type: esriFieldTypeString, alias: SW_PROJECT_OR_SUBDIVISION_NO, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SW_RELIABILITY_DEPTH (type: esriFieldTypeString, alias: SW_RELIABILITY_DEPTH, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 7 more ...)
SW_RELIABILITY_DIAMETER (type: esriFieldTypeString, alias: SW_RELIABILITY_DIAMETER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 7 more ...)
SW_RELIABILITY_INSTALLATION (type: esriFieldTypeString, alias: SW_RELIABILITY_INSTALLATION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 7 more ...)
SW_RELIABILITY_MATERIAL (type: esriFieldTypeString, alias: SW_RELIABILITY_MATERIAL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABP1: Legacy Council As Built Plan 1], [ABPL: As Built Plan], [CCTV: CCTV Survey], ... 7 more ...)
SW_RENEWAL_MODEL_DATE (type: esriFieldTypeDate, alias: SW_RENEWAL_MODEL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_RENEWAL_MODEL_INCL_FORECAST (type: esriFieldTypeString, alias: SW_RENEWAL_MODEL_INCL_FORECAST, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
SW_RENEWAL_MODEL_TYPE (type: esriFieldTypeString, alias: SW_RENEWAL_MODEL_TYPE, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SW_RENEWAL_REMAINING_LIFE (type: esriFieldTypeSmallInteger, alias: SW_RENEWAL_REMAINING_LIFE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_REPLACED_ASSET (type: esriFieldTypeString, alias: SW_REPLACED_ASSET, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
SW_RISK (type: esriFieldTypeString, alias: SW_RISK, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [1: Not at Risk], [2: Low], [3: Medium], ... 2 more ...)
SW_RISK_DATE (type: esriFieldTypeDate, alias: SW_RISK_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_SAP_ID (type: esriFieldTypeString, alias: SW_SAP_ID, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
SW_SHAPE (type: esriFieldTypeString, alias: SW_SHAPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ARCH: Arched], [BOX: Box], [CIRC: Circular], ... 10 more ...)
SW_STATUS (type: esriFieldTypeString, alias: SW_STATUS, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [ABAN: Abandoned], [DATA: Data Error], [DECO: Decommissioned], ... 3 more ...)
SW_STATUS_CHANGE_REASON (type: esriFieldTypeString, alias: SW_STATUS_CHANGE_REASON, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [BOVR: Buildover], [ENDL: End Of Useful Life], [INCP: Inadequate Capacity], ... 5 more ...)
SW_STORMWATER_CATCHMENT (type: esriFieldTypeString, alias: SW_STORMWATER_CATCHMENT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [085: Awaruku], [088: Campbells Bay], [090: Castor Bay], ... 229 more ...)
SW_VALUATION_ANNUAL_DEPREC (type: esriFieldTypeDouble, alias: SW_VALUATION_ANNUAL_DEPREC, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_VALUATION_DATE (type: esriFieldTypeDate, alias: SW_VALUATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SW_VALUATION_DEPREC_REPL_COST (type: esriFieldTypeDouble, alias: SW_VALUATION_DEPREC_REPL_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_VALUATION_EXPECTED_LIFE (type: esriFieldTypeSmallInteger, alias: SW_VALUATION_EXPECTED_LIFE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_VALUATION_OPT_REPL_COST (type: esriFieldTypeDouble, alias: SW_VALUATION_OPT_REPL_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_VALUATION_UNIT_COST (type: esriFieldTypeDouble, alias: SW_VALUATION_UNIT_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_WIDTH_MM (type: esriFieldTypeInteger, alias: SW_WIDTH_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
SW_GIS_ID (type: esriFieldTypeString, alias: SW_GIS_ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Range: [1/1/1990 12:00:00 AM - 1/1/2050 12:00:00 AM])
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Range: [1/1/1990 12:00:00 AM - 1/1/2050 12:00:00 AM])
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

VALIDATIONSTATE: 0

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: