Name: Bridges

Display Field: bridge_name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Has Views: true

Source Schema Changes Allowed: true

Views

Description: Polygon features representing bridge extents extracted from externally hosted RAMM database. Data is extracted from Auckland Transport copy of RAMM database that is updated via a replication process. Attributes are sourced from the br_bridge table and all associated lookup tables to convert coded values into more meaningful descriptions. Data stored in GIS is refreshed regularly via an FME workbench. Charmaine Okros (Asset Systems) is the business owner of all RAMM data.

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1711946.6721
YMin: 5874065.493
XMax: 1825022.7933
YMax: 5998112.9085
Spatial Reference: 2193 (2193)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSForwardDiagonal","color":[130,130,130,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[104,104,104,255],"width":3}},"label":"","description":""},"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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• bridge_id (type: esriFieldTypeInteger, alias: Bridge ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bridge_no (type: esriFieldTypeString, alias: Bridge No, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• bridge_name (type: esriFieldTypeString, alias: Bridge Name, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• local_desc (type: esriFieldTypeString, alias: Local Description, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• plate_year (type: esriFieldTypeSmallInteger, alias: Plate Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• asset_owner (type: esriFieldTypeString, alias: Asset Owner, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• culvert_sw (type: esriFieldTypeString, alias: Culvert, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• road_id (type: esriFieldTypeInteger, alias: Road ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• road_name (type: esriFieldTypeString, alias: Road Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• start_m (type: esriFieldTypeInteger, alias: Start, SQL Type: sqlTypeOther, nullable: true, editable: true)
• end_m (type: esriFieldTypeInteger, alias: End, SQL Type: sqlTypeOther, nullable: true, editable: true)
• traffic_direction (type: esriFieldTypeString, alias: Traffic Direction, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• bridge_type (type: esriFieldTypeString, alias: Bridge Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Bridges
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/12/2025 1:31:04 PM

Schema Last Edit Date: 3/12/2025 1:04:45 PM

Data Last Edit Date: 3/12/2025 1:31:04 PM

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