Name: Houston_WaterMain

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

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: -10654380.1906056
YMin: 3442367.0222833
XMax: -10584551.2083894
YMax: 3517621.12762043
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[165,83,183,255],"width":1}},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• UFID (type: esriFieldTypeInteger, alias: UFID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PLANNUMBER (type: esriFieldTypeString, alias: Plan Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PLANDATE (type: esriFieldTypeDate, alias: Plan Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSERVICEDATE (type: esriFieldTypeDate, alias: In Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SUBTYPECD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [PVC: PVC], [DI: Ductile Iron], [STL: Steel], ... 13 more ...)
• WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [POT: Potable], [NOPC: Non-Potable], [NOPW: Non-Potable Well Collector])
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [E: Features Being Used and Maintained], [P: Proposed], [A: Abandoned], ... 2 more ...)
• MEASUREDLENGTH (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 1000000000])
• PIPETYPE (type: esriFieldTypeString, alias: Pipe Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [P: Pinchable], [NP: Non-Pinchable])
• LENGTH (type: esriFieldTypeString, alias: Length, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PROJECTTYPE (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [BG: Budgeted Job], [C: Private Construction], [JOB: City Job], ... 10 more ...)
• DIAMETER (type: esriFieldTypeDouble, alias: Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Unknown], [0: Other], [0.5: 0.5"], ... 40 more ...)
• Length_Miles (type: esriFieldTypeDouble, alias: Length_Miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OVER_40_Years (type: esriFieldTypeDouble, alias: OVER_40_Years, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BETWEEN_30_TO_39_YEARS (type: esriFieldTypeDouble, alias: BETWEEN_30_To_39_Years, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BETWEEN_20_TO_29_YEARS (type: esriFieldTypeDouble, alias: BETWEEN_20_TO_29_YEARS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BETWEEN_10_TO_19_YEARS (type: esriFieldTypeDouble, alias: BETWEEN_10_TO_19_YEARS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNDER_10_YEARS (type: esriFieldTypeDouble, alias: UNDER_10_YEARS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• SUBTYPECD: 1
• WATERTYPE: POT
• LIFECYCLESTATUS: E

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/6/2023 1:21:10 PM

Schema Last Edit Date: 3/6/2023 1:21:10 PM

Data Last Edit Date: 3/6/2023 1:21:10 PM

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