All Layers and Tables (Stormwater

Layers:

Layer: Stormwater Channel (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Seven legacy systems were migrated to Auckland Council’s GIS environment where the creation of new assets and maintenance of existing assets are now being undertaken. Using asbuilts sent to the stormwater team from development engineers and/or internal projects, the geometry and attributes of stormwater assets are captured using standard ArcGIS editing functionality. Whilst due care has been taken to capture the assets as accurately as possible, the data is indicative and cannot be considered to align to any particular boundaries or features including cadastral.

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

,LINE","label":"Public lined"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.2},"value":"INSR,PARKS,LINE","label":"Public lined"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.2},"value":"INSR,STORMWATER,FLUM","label":"Public lined"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.2},"value":"INSR,STORMWATER,LINE","label":"Public lined"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.2},"value":"INSR,TRANSPORT,FLUM","label":"Public lined"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.2},"value":"INSR,TRANSPORT,LINE","label":"Public lined"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.2},"value":"UNVF,PARKS,LINE","label":"Public lined"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.2},"value":"UNVF,STORMWATER,FLUM","label":"Public lined"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.2},"value":"UNVF,STORMWATER,LINE","label":"Public lined"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.2},"value":"UNVF,TRANSPORT,FLUM","label":"Public lined"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.2},"value":"UNVF,TRANSPORT,LINE","label":"Public lined"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"INSR,DBRD,UNLI","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"INSR,,","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"INSR,,SWAL","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"INSR,NZTA,","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"INSR,PARKS,FLUM","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"INSR,PARKS,UNLI","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"INSR,STORMWATER,","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"INSR,STORMWATER,SWAL","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"INSR,STORMWATER,UNLI","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"UNVF,,","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"UNVF,PARKS,SWAL","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"UNVF,STORMWATER,SWAL","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"UNVF,STORMWATER,UNLI","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"UNVF,TRANSPORT,SWAL","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"UNVF,TRANSPORT,UNLI","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":0.4},"value":"INSR,TRANSPORT,SWAL","label":"Public Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":0.4},"value":"INSR,PRIVATE,","label":"Private Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":0.4},"value":"INSR,PRIVATE,LINE","label":"Private Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":0.4},"value":"INSR,PRIVATE,SWAL","label":"Private Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":0.4},"value":"INSR,PRIVATE,UNLI","label":"Private Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":0.4},"value":"UNVF,PRIVATE,FLUM","label":"Private Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":0.4},"value":"UNVF,PRIVATE,LINE","label":"Private Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":0.4},"value":"UNVF,PRIVATE,SWAL","label":"Private Watercourse"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":0.4},"value":"UNVF,PRIVATE,UNLI","label":"Private Watercourse"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[113,52,148,255],"toColor":[113,52,148,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[150,168,49,255],"toColor":[150,168,49,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[47,149,161,255],"toColor":[47,149,161,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[163,41,53,255],"toColor":[163,41,53,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[32,138,72,255],"toColor":[32,138,72,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[63,87,138,255],"toColor":[63,87,138,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[156,109,44,255],"toColor":[156,109,44,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[148,72,114,255],"toColor":[148,72,114,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[80,173,43,255],"toColor":[80,173,43,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[60,43,171,255],"toColor":[60,43,171,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[32,56,140,255],"toColor":[32,56,140,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[176,37,150,255],"toColor":[176,37,150,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[163,98,82,255],"toColor":[163,98,82,255]}]}}},"scaleSymbols":true,"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:

CREATOR (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
SW_ACTIVITY_TYPE (type: esriFieldTypeString, alias: Activity Type, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [CONV: Conversion], [DISP: Disposal or Deletion], [NCAP: New Capital], ... 10 more ...)
SW_ASBUILT_REGISTER_ID (type: esriFieldTypeString, alias: As Built Register ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: false)
SW_ASSET_OWNER (type: esriFieldTypeString, alias: Asset Owner, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [DOC: Department of Conservation], [NZTA: New Zealand Transport Agency], [PARKS: AC - Parks], ... 9 more ...)
SW_ASSET_TYPE (type: esriFieldTypeString, alias: Asset Type, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [CONS: Constructed Overland Flow Path], [FLUM: Flume Channel], [LINE: Lined Channel], ... 3 more ...)
SW_CRE (type: esriFieldTypeString, alias: CRE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [HIBISCUS_COAST: Hibiscus Coast], [ISLANDS: Islands], [KAIPARA: Kaipara], ... 8 more ...)
SW_DATUM_CONFIDENCE_AUK1946 (type: esriFieldTypeString, alias: Auckland 1946 Confidence, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: false, Coded Values: [VDAUK1946: Auckland 1946 Survey], [VDAUK1946CAL: Auckland 1946 Calculated])
SW_DATUM_CONFIDENCE_NZVD2016 (type: esriFieldTypeString, alias: NZVD2016 Confidence, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: false, Coded Values: [VD2016: NZVD2016 Survey], [VD2016CAL: NZVD2016 Calculated])
SW_DECOMMISSION_DATE (type: esriFieldTypeDate, alias: Decommission Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
SW_EASEMENT_REFERENCE (type: esriFieldTypeString, alias: Easement Reference, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: false)
SW_FISH_PASS_STRUCTURE_TYPE (type: esriFieldTypeString, alias: Fish Pass Structure Type, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [BAFL: Baffles], [NONE: None], [RAMP: Fish Ramp], ... 2 more ...)
SW_GIS_ID (type: esriFieldTypeString, alias: GIS ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: false)
SW_GRADIENT_PC (type: esriFieldTypeSmallInteger, alias: Gradient (%), SQL Type: sqlTypeOther, nullable: true, editable: false)
SW_INSTALLATION_DATE (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
SW_INVERT_LEVEL_DOWNSTREAM_M (type: esriFieldTypeDouble, alias: Invert Level - Downstream (m), SQL Type: sqlTypeOther, nullable: true, editable: false)
SW_INVERT_LEVEL_DS_M_NZVD2016 (type: esriFieldTypeDouble, alias: Down Stream Invert Level (m) NZVD2016, SQL Type: sqlTypeOther, nullable: true, editable: false)
SW_INVERT_LEVEL_UPSTREAM_M (type: esriFieldTypeDouble, alias: Invert Level - Upstream (m), SQL Type: sqlTypeOther, nullable: true, editable: false)
SW_INVERT_LEVEL_US_M_NZVD2016 (type: esriFieldTypeDouble, alias: Up Stream Invert Level (m) NZVD2016, SQL Type: sqlTypeOther, nullable: true, editable: false)
SW_LEGACY_SOURCE_DOCUMENT_REF (type: esriFieldTypeString, alias: Legacy Source Document Ref, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: false)
SW_LENGTH_GIS_M (type: esriFieldTypeDouble, alias: Length - GIS (m), SQL Type: sqlTypeOther, nullable: true, editable: false)
SW_LOCAL_BOARD (type: esriFieldTypeString, alias: Local Board, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [100: Albert-Eden], [105: Devonport-Takapuna], [110: Franklin], ... 18 more ...)
SW_MATERIAL_BASE (type: esriFieldTypeString, alias: Material - Base, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [CONC: Concrete], [ERTH: Earth], [ERWR: Ceramic / Earthenware], ... 7 more ...)
SW_MATERIAL_TRUE_LEFT_BANK (type: esriFieldTypeString, alias: Material - True Left Bank, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [CONC: Concrete], [ERWR: Ceramic / Earthenware], [GABI: Gabion Basket], ... 4 more ...)
SW_MATERIAL_TRUE_RIGHT_BANK (type: esriFieldTypeString, alias: Material - True Right Bank, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [CONC: Concrete], [ERWR: Ceramic / Earthenware], [GABI: Gabion Basket], ... 4 more ...)
SW_OPERATIONAL_AREA (type: esriFieldTypeString, alias: Operational Area, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [SC: Stormwater Central], [SN: Stormwater North], [SS: Stormwater South], ... 1 more ...)
SW_PROJECT_OR_SUBDIVISION_NO (type: esriFieldTypeString, alias: Project or Subdivision No, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: false)
SW_SAP_ID (type: esriFieldTypeString, alias: SAP ID, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: false)
SW_SHAPE (type: esriFieldTypeString, alias: SW Shape, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [ARCH: Arched], [BOX: Box], [CIRC: Circular], ... 10 more ...)
SW_STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [ABAN: Abandoned], [DATA: Data Error], [DECO: Decommissioned], ... 5 more ...)
SW_STATUS_CHANGE_REASON (type: esriFieldTypeString, alias: Status Change Reason, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [BOVR: Buildover], [ENDL: End Of Useful Life], [INCP: Inadequate Capacity], ... 5 more ...)
SW_STORMWATER_CATCHMENT (type: esriFieldTypeString, alias: Stormwater Catchment, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: false, Coded Values: [085: Awaruku], [088: Campbells Bay], [090: Castor Bay], ... 229 more ...)
SW_WIDTH_BASE_MM (type: esriFieldTypeInteger, alias: Width - Base (mm), SQL Type: sqlTypeOther, nullable: true, editable: false)
SW_WIDTH_TOP_MM (type: esriFieldTypeInteger, alias: Width - Top (mm), SQL Type: sqlTypeOther, nullable: true, editable: false)
VALIDATIONSTATE (type: esriFieldTypeSmallInteger, alias: Validation State, SQL Type: sqlTypeOther, nullable: true, editable: false, Coded Values: [0: Not Valid], [1: Not Valid and Public], [2: Valid and Private], ... 1 more ...)
GlobalID_1 (type: esriFieldTypeGlobalID, alias: GlobalID_1, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

Field Name: SW_ACTIVITY_TYPE
Inherited
Field Name: SW_ASSET_OWNER
Inherited
Field Name: SW_ASSET_TYPE
Inherited
Field Name: SW_CRE
Inherited
Field Name: SW_DATUM_CONFIDENCE_AUK1946
Inherited
Field Name: SW_DATUM_CONFIDENCE_NZVD2016
Inherited
Field Name: SW_FISH_PASS_STRUCTURE_TYPE
Inherited
Field Name: SW_LOCAL_BOARD
Inherited
Field Name: SW_MATERIAL_BASE
Inherited
Field Name: SW_MATERIAL_TRUE_LEFT_BANK
Inherited
Field Name: SW_MATERIAL_TRUE_RIGHT_BANK
Inherited
Field Name: SW_OPERATIONAL_AREA
Inherited
Field Name: SW_SHAPE
Inherited
Field Name: SW_STATUS
Inherited
Field Name: SW_STATUS_CHANGE_REASON
Inherited
Field Name: SW_STORMWATER_CATCHMENT
Inherited
Field Name: VALIDATIONSTATE
Inherited

Field Name: SW_ACTIVITY_TYPE
Inherited
Field Name: SW_ASSET_OWNER
Inherited
Field Name: SW_ASSET_TYPE
Inherited
Field Name: SW_CRE
Inherited
Field Name: SW_DATUM_CONFIDENCE_AUK1946
Inherited
Field Name: SW_DATUM_CONFIDENCE_NZVD2016
Inherited
Field Name: SW_FISH_PASS_STRUCTURE_TYPE
Inherited
Field Name: SW_LOCAL_BOARD
Inherited
Field Name: SW_MATERIAL_BASE
Inherited
Field Name: SW_MATERIAL_TRUE_LEFT_BANK
Inherited
Field Name: SW_MATERIAL_TRUE_RIGHT_BANK
Inherited
Field Name: SW_OPERATIONAL_AREA
Inherited
Field Name: SW_SHAPE
Inherited
Field Name: SW_STATUS
Inherited
Field Name: SW_STATUS_CHANGE_REASON
Inherited
Field Name: SW_STORMWATER_CATCHMENT
Inherited
Field Name: VALIDATIONSTATE
Inherited

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (Stormwater_Channel)

Layers:

Layer: Stormwater Channel (0)