Name: Culverts

Display Field: SHAPE_1

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This file was originally created around 2004 from information gathered by Public Works’GIS field crew.Field breakdown: The unique identifier is in the AssetID [Culvert ID] field. The SHAPE_1 [Culvert Shape] field uses the CulvertShape domain to describe the shape of the feature. The DIAMETER__ [Diameter (in)], WIDTH__IN_ [Width (in)], and HEIGHT__IN_ [Height (in)] fields capture the size and dimensions of the feature by using the CulvertDiameter and CulvertDimensions domains. The material is described by the CulvertMaterial domain in the MATERIALS_ [Material] field. The CONDITION [Condition] field uses the BasicCondition domain to express the results of a condition assessment (note that this field has not been updated since the culverts were originally entered). Due to VUEWorks (Public Works’ work order system), care must be taken when deleting features. The IDs cannot be reused and must be retired after a deletion. This feature class has not had any post-VUEWorks deletions.

Copyright Text: City of Galveston

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: 3210918.3244064
YMin: 13602587.6585125
XMax: 3325691.90522623
YMax: 13693528.3417883
Spatial Reference: 102740 (2278)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSDashDotDot","color":[230,152,0,255],"width":2}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

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: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SHAPE_1 (type: esriFieldTypeString, alias: Culvert Shape, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Monolithic: Monolithic], [Round: Round])
• WITH_IN_ (type: esriFieldTypeSmallInteger, alias: Width (in), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: 1], [2: 2], ... 23 more ...)
• HEIGHT_IN (type: esriFieldTypeSmallInteger, alias: Height (in), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: 1], [2: 2], ... 23 more ...)
• MATERIALS_ (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CI: Cast Iron], [Concrete: Concrete], [CP: Corrugated Pipe], ... 3 more ...)
• CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor])
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ASSETID (type: esriFieldTypeSmallInteger, alias: Culvert ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeSmallInteger, alias: Diameter (in), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [6: 6], [8: 8], ... 9 more ...)
• CREATED_USER (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• CREATED_DATE (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• LAST_EDITED_USER (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• LAST_EDITED_DATE (type: esriFieldTypeDate, alias: Last Edited Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• COUNCILDIST (type: esriFieldTypeSmallInteger, alias: Council District, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 3 more ...)
• DATAINSTALL (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Z_MIN (type: esriFieldTypeDouble, alias: Z_MIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Z_MAX (type: esriFieldTypeDouble, alias: Z_MAX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Z_MEAN (type: esriFieldTypeDouble, alias: Z_MEAN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLENGTH (type: esriFieldTypeDouble, alias: SLENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MIN_SLOPE (type: esriFieldTypeDouble, alias: MIN_SLOPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAX_SLOPE (type: esriFieldTypeDouble, alias: MAX_SLOPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AVG_SLOPE (type: esriFieldTypeDouble, alias: AVG_SLOPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Culverts
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/28/2022 10:13:52 PM

Schema Last Edit Date: 1/28/2022 10:13:52 PM

Data Last Edit Date: 1/28/2022 10:13:52 PM

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