Name: Stormwater_Network_Lines

Display Field: ENABLED

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text: Metropolitan St. Louis Sewer District (MSD), St. Louis County Department of Public Works

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: -10101419.0924767
YMin: 4636773.80178259
XMax: -10033411.3252216
YMax: 4703208.89203483
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,223,255,255],"width":1.5}},"scaleSymbols":true,"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)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• UPSTREAMSTRUCTURE (type: esriFieldTypeString, alias: UPSTREAMSTRUCTURE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DOWNSTREAMSTRUCTURE (type: esriFieldTypeString, alias: DOWNSTREAMSTRUCTURE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UPSTREAMINVERT (type: esriFieldTypeDouble, alias: UPSTREAMINVERT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOWNSTREAMINVERT (type: esriFieldTypeDouble, alias: DOWNSTREAMINVERT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SUBTYPE (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SYSTEM (type: esriFieldTypeString, alias: System, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [S: Sanitary sewer], [D: Storm sewer], [C: Combined sewer])
• LENGTH (type: esriFieldTypeSmallInteger, alias: LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WIDTH (type: esriFieldTypeDouble, alias: WIDTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HEIGHT (type: esriFieldTypeDouble, alias: HEIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPEMATERIAL (type: esriFieldTypeString, alias: PipeMaterial, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ABS: Acrylonitrile Butadiene Styrene], [AC: Asbestos Cement], [BR: Brick], ... 24 more ...)
• PIPECROSSSECTION (type: esriFieldTypeString, alias: PipeCrossSection, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [A: Arched], [B: Barrel], [E: Egg-Shaped], ... 8 more ...)
• LEN_SRC (type: esriFieldTypeString, alias: Len_Src, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [A: Actual], [C: Calculated])
• OWNERSHIP (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: MSD], [2: Private], [3: County], ... 8 more ...)
• OPID (type: esriFieldTypeString, alias: OPID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MAPDATE (type: esriFieldTypeDate, alias: MAPDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PJOBID (type: esriFieldTypeString, alias: PJOBID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MSLINK (type: esriFieldTypeInteger, alias: MSLINK, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CCTV_ID (type: esriFieldTypeString, alias: CCTV_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UNPLACEDLATERALPOINTS (type: esriFieldTypeSmallInteger, alias: UNPLACEDLATERALPOINTS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PARPIPENO (type: esriFieldTypeSmallInteger, alias: PARPIPENO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROWLOC (type: esriFieldTypeString, alias: ROWLOC, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [F: Front], [R: Rear], [U: Undetermined])
• INSERVICEDATE (type: esriFieldTypeDate, alias: INSERVICEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMBINEDID (type: esriFieldTypeString, alias: COMBINEDID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• REHABDATE (type: esriFieldTypeDate, alias: REHABDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REHABTYPE (type: esriFieldTypeString, alias: REHABTYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [FF: Fold and Form], [GRC: Glass Reinforced Cement], [N: None], ... 11 more ...)
• MXCREATIONSTATE (type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MXSITEID (type: esriFieldTypeString, alias: MXSITEID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MXASSETNUM (type: esriFieldTypeString, alias: MXASSETNUM, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• MXASSETLOC (type: esriFieldTypeString, alias: MXASSETLOC, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• LAST_MODIFIED_BY (type: esriFieldTypeString, alias: LAST_MODIFIED_BY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ROWSTAMP (type: esriFieldTypeString, alias: ROWSTAMP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SOURCE (type: esriFieldTypeString, alias: SOURCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Survey: Survey grade < 1 ft], [Mapping: Mapping grade < 3 ft], [Aerial: Relative to aerial photo], ... 1 more ...)
• STATUS (type: esriFieldTypeSmallInteger, alias: STATUS, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Active], [2: Abandoned], [3: Removed], ... 5 more ...)
• LAST_MODIFIED_DATE (type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LAST_JOBID (type: esriFieldTypeString, alias: LAST_JOBID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• HAZARDTYPE (type: esriFieldTypeString, alias: HAZARDTYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: NONE], [5: Explosive], [6: Radioactive], ... 8 more ...)
• HAZARD_ENTRY (type: esriFieldTypeString, alias: HAZARD_ENTRY, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [0: None], [1: Caution], [2: Do Not Enter], ... 1 more ...)
• EXTERNALID (type: esriFieldTypeString, alias: EXTERNALID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Stormwater_Network_Lines
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• HAZARDTYPE: 1
• SUBTYPE: 1
• SYSTEM: D
• PIPECROSSSECTION: C
• LEN_SRC: C
• OWNERSHIP: 1
• PARPIPENO: 0
• MXSITEID: CS
• ROWSTAMP: 0
• STATUS: 1
• HAZARD_ENTRY: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/24/2024 5:49:13 PM

Schema Last Edit Date: 4/24/2024 5:49:13 PM

Data Last Edit Date: 4/24/2024 5:49:13 PM

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