Name: Stormwater Culvert

Display Field: STNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 10000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1792488.4912
YMin: 5808774.0075
XMax: 1804347.4899
YMax: 5823974.0718
Spatial Reference: 2193 (2193)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"17841a6c2d381adf4a4b370123cbe265","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAALCAYAAAB/Ca1DAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA6ElEQVQokbWSsWrCUBSGv2sSELuULj6IQxKXTl1bCyVNdSu0uApd+gIthb5A+wA1ySD4ECaBguDWUTenLh1c9F6hg4iJN7XoP/4cPr5zOCZ7jnlQoBPipddEuwDsAEeWGH96TLOGijM74BbBC4qZDiQEhlLcA9UjCz/XMPW5q0e4UvIIVHRApZgLeE99etobxh4JcM4/Y24WtTcs65hLZIFhiblZpj+44Gcr0I04RfKKYojQ3xCFsZjx4HR5Tm8I8w0lHbHgKm4xKV7uV+BESp7cD0ZJk68MMPFp/AW0mvf4Btrr3d4fewm4Rz+fQTGDBAAAAABJRU5ErkJggg==","contentType":"image/png","width":15,"height":8,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":false,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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: Upstream Unit ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UNITID2 (type: esriFieldTypeString, alias: Downstream Unit ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• COMPTYPE (type: esriFieldTypeSmallInteger, alias: COMPTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINCOMP1 (type: esriFieldTypeSmallInteger, alias: MAINCOMP1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINCOMP2 (type: esriFieldTypeSmallInteger, alias: MAINCOMP2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINKEY1 (type: esriFieldTypeInteger, alias: Upstream Compkey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINKEY2 (type: esriFieldTypeInteger, alias: Downstream Compkey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REFERENCE (type: esriFieldTypeInteger, alias: Reference ID, 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)
• MAPNO (type: esriFieldTypeString, alias: Map No, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• US_NORTHING (type: esriFieldTypeString, alias: Upstream Northing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• US_EASTING (type: esriFieldTypeString, alias: Upstream Easting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DS_NORTHING (type: esriFieldTypeString, alias: Downstream Northing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DS_EASTING (type: esriFieldTypeString, alias: Downstream Easting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UNITTYPE (type: esriFieldTypeString, alias: Culvert Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [CULVERT: CULVERT])
• CULVERTLEN (type: esriFieldTypeDouble, alias: Length m, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONMATL (type: esriFieldTypeString, alias: Construction Material, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [AC: AC - ASBESTOS CEMENT], [ALU: ALU - ALUFLO], [AQCELL: AQCELL - AQUA CELL], ... 17 more ...)
• CULV_SHAPE (type: esriFieldTypeString, alias: Shape, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DIMENSIONS (type: esriFieldTypeString, alias: Dimensions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OVER_HT (type: esriFieldTypeDouble, alias: Overtopping Height m, SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_ELEVATION (type: esriFieldTypeDouble, alias: Upstream Elevation m, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DS_ELEVATION (type: esriFieldTypeDouble, alias: Downstream Elevation m, SQL Type: sqlTypeOther, 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)
• 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: 50, 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 ...)
• VALDATE (type: esriFieldTypeDate, alias: Archive 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)
• DATA_SOURCE (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• EXTERNAL_REF (type: esriFieldTypeString, alias: External Reference, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• GIS_ONLY (type: esriFieldTypeString, alias: GIS Record Only, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)

Templates:

Name: Stormwater Culvert
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• COMPTYPE: 72
• SERVSTAT: C

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/13/2023 2:54:38 AM

Schema Last Edit Date: 3/13/2023 2:54:38 AM

Data Last Edit Date: 3/13/2023 2:54:38 AM

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