View In:   ArcGIS Online Map Viewer

Name: CreveCoeur.SDE.swCasing

Display Field: UPSTREAMSTRUCTURE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 15000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 796105.756861262
YMin: 943422.6424227804
XMax: 909946.1551642604
YMax: 1074713.0501170307
Spatial Reference: 102696  (102696)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Access Tunnel
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
• Value: 2
  Label: Casement
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 2
• Value: 3
  Label: Conduit Bridge
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [230, 230, 0, 255]
  Width: 2
• Value: 5
  Label: Existing Pipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 76, 0, 255]
  Width: 0
• Value: 4
  Label: Protective Tunnel
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 3
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SUBTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• UPSTREAMSTRUCTURE ( type: esriFieldTypeString, alias: UPSTREAMSTRUCTURE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UPSTREAMSTRUCTURE )
• DOWNSTREAMSTRUCTURE ( type: esriFieldTypeString, alias: DOWNSTREAMSTRUCTURE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DOWNSTREAMSTRUCTURE )
• UPSTREAMINVERT ( type: esriFieldTypeDouble, alias: UPSTREAMINVERT, editable: true, nullable: true, defaultValue: null, modelName: UPSTREAMINVERT )
• DOWNSTREAMINVERT ( type: esriFieldTypeDouble, alias: DOWNSTREAMINVERT, editable: true, nullable: true, defaultValue: null, modelName: DOWNSTREAMINVERT )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITYID )
• SUBTYPE ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 1, modelName: Subtype )
• SYSTEM ( type: esriFieldTypeString, alias: System, editable: true, nullable: true, length: 50, defaultValue: D, modelName: System , Coded Values: [S: Sanitary sewer] , [D: Storm sewer] , [C: Combined sewer] )
• LENGTH ( type: esriFieldTypeSmallInteger, alias: LENGTH, editable: true, nullable: true, defaultValue: null, modelName: LENGTH )
• WIDTH ( type: esriFieldTypeDouble, alias: WIDTH, editable: true, nullable: true, defaultValue: null, modelName: WIDTH )
• HEIGHT ( type: esriFieldTypeDouble, alias: HEIGHT, editable: true, nullable: true, defaultValue: null, modelName: HEIGHT )
• PIPEMATERIAL ( type: esriFieldTypeString, alias: PipeMaterial, editable: true, nullable: false, length: 50, defaultValue: UNK, modelName: PipeMaterial , Coded Values: [ABS: Acrylonitrile Butadiene Styrene] , [ACP: Asbestos Cement] , [BRK: Brick] , ...39 more... )
• PIPECROSSSECTION ( type: esriFieldTypeString, alias: PipeCrossSection, editable: true, nullable: true, length: 50, defaultValue: CIRC, modelName: PipeCrossSection , Coded Values: [ARCH: Arch Shape] , [CIRC: Circular] , [DETE: Detention/Retention Area] , ...9 more... )
• LEN_SRC ( type: esriFieldTypeString, alias: Len_Src, editable: true, nullable: true, length: 50, defaultValue: C, modelName: Len_Src , Coded Values: [A: Actual] , [C: Calculated] )
• OWNERSHIP ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 50, defaultValue: 1, modelName: Ownership , Coded Values: [1: MSD] , [2: Private] , [3: County] , ...8 more... )
• OPID ( type: esriFieldTypeString, alias: OPID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OPID )
• MAPDATE ( type: esriFieldTypeDate, alias: MAPDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MAPDATE )
• PJOBID ( type: esriFieldTypeString, alias: PJOBID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PJOBID )
• MSLINK ( type: esriFieldTypeInteger, alias: MSLINK, editable: true, nullable: true, defaultValue: null, modelName: MSLINK )
• CCTV_ID ( type: esriFieldTypeString, alias: CCTV_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CCTV_ID )
• UNPLACEDLATERALPOINTS ( type: esriFieldTypeSmallInteger, alias: UNPLACEDLATERALPOINTS, editable: true, nullable: true, defaultValue: null, modelName: UNPLACEDLATERALPOINTS )
• PARPIPENO ( type: esriFieldTypeSmallInteger, alias: PARPIPENO, editable: true, nullable: true, defaultValue: 0, modelName: PARPIPENO )
• ROWLOC ( type: esriFieldTypeString, alias: ROWLOC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ROWLOC , Coded Values: [F: Front] , [R: Rear] , [U: Undetermined] )
• INSERVICEDATE ( type: esriFieldTypeDate, alias: INSERVICEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSERVICEDATE )
• COMBINEDID ( type: esriFieldTypeString, alias: COMBINEDID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMBINEDID )
• REHABDATE ( type: esriFieldTypeDate, alias: REHABDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REHABDATE )
• REHABTYPE ( type: esriFieldTypeString, alias: REHABTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REHABTYPE , Coded Values: [CPP: Cured-in-Place] , [PLP: Plastic Lined] , [PTRP: Point Repair] , ...8 more... )
• MXCREATIONSTATE ( type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, editable: true, nullable: true, defaultValue: null, modelName: MXCREATIONSTATE )
• MXSITEID ( type: esriFieldTypeString, alias: MXSITEID, editable: true, nullable: true, length: 8, defaultValue: CS, modelName: MXSITEID )
• MXASSETNUM ( type: esriFieldTypeString, alias: MXASSETNUM, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MXASSETNUM )
• MXASSETLOC ( type: esriFieldTypeString, alias: MXASSETLOC, editable: true, nullable: true, length: 40, defaultValue: null, modelName: MXASSETLOC )
• STATUS ( type: esriFieldTypeSmallInteger, alias: STATUS, editable: true, nullable: true, defaultValue: 1, modelName: STATUS , Coded Values: [1: Active] , [2: Abandoned] , [3: Removed] , ...5 more... )
• LAST_MODIFIED_BY ( type: esriFieldTypeString, alias: LAST_MODOFIED_BY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAST_MODOFIED_BY )
• LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_MODIFIED_DATE )
• ROWSTAMP ( type: esriFieldTypeString, alias: ROWSTAMP, editable: true, nullable: true, length: 50, defaultValue: 0, modelName: ROWSTAMP )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURCE , Coded Values: [Survey: Survey grade < 1 ft] , [Mapping: Mapping grade < 3 ft] , [Aerial: Relative to aerial photo] , ...1 more... )
• LAST_JOBID ( type: esriFieldTypeString, alias: LAST_JOBID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAST_JOBID )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Types:

ID: 1
Name: Acces Tunnel
Domains:
• ENABLED:
  Inherited
• SYSTEM:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPECROSSSECTION:
  Inherited
• LEN_SRC:
  Inherited
• OWNERSHIP:
  Inherited
• ROWLOC:
  Inherited
• REHABTYPE:
  Coded Values: [CPP: Cured-in-Place] , [PLP: Plastic Lined] , [PTRP: Point Repair] , ...9 more...
• STATUS:
  Inherited
• SOURCE:
  Inherited
Templates:
• Name: Access Tunnel
  Description:
  Prototype:
  PIPEMATERIAL: UNK
  PIPECROSSSECTION: CIRC
  MXASSETLOC: null
  LAST_MODIFIED_DATE: null
  MXCREATIONSTATE: 1
  UNPLACEDLATERALPOINTS: null
  LAST_JOBID: null
  REHABTYPE: null
  LEN_SRC: C
  HEIGHT: null
  SUBTYPE: 1
  FACILITYID: null
  ENABLED: 1
  UPSTREAMSTRUCTURE: null
  DOWNSTREAMSTRUCTURE: null
  UPSTREAMINVERT: null
  DOWNSTREAMINVERT: null
  SYSTEM: D
  LENGTH: null
  WIDTH: null
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  CCTV_ID: null
  PARPIPENO: 0
  ROWLOC: null
  INSERVICEDATE: null
  COMBINEDID: null
  REHABDATE: null
  MXSITEID: CS
  MXASSETNUM: null
  STATUS: 1
  LAST_MODIFIED_BY: null
  ROWSTAMP: 0
  SOURCE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Casement
Domains:
• ENABLED:
  Inherited
• SYSTEM:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPECROSSSECTION:
  Inherited
• LEN_SRC:
  Inherited
• OWNERSHIP:
  Inherited
• ROWLOC:
  Inherited
• REHABTYPE:
  Coded Values: [CPP: Cured-in-Place] , [PLP: Plastic Lined] , [PTRP: Point Repair] , ...9 more...
• STATUS:
  Inherited
• SOURCE:
  Inherited
Templates:
• Name: Casement
  Description:
  Prototype:
  PIPEMATERIAL: UNK
  PIPECROSSSECTION: CIRC
  MXASSETLOC: null
  LAST_MODIFIED_DATE: null
  MXCREATIONSTATE: 1
  UNPLACEDLATERALPOINTS: null
  LAST_JOBID: null
  REHABTYPE: null
  LEN_SRC: C
  HEIGHT: null
  SUBTYPE: 2
  FACILITYID: null
  ENABLED: 1
  UPSTREAMSTRUCTURE: null
  DOWNSTREAMSTRUCTURE: null
  UPSTREAMINVERT: null
  DOWNSTREAMINVERT: null
  SYSTEM: D
  LENGTH: null
  WIDTH: null
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  CCTV_ID: null
  PARPIPENO: 0
  ROWLOC: null
  INSERVICEDATE: null
  COMBINEDID: null
  REHABDATE: null
  MXSITEID: CS
  MXASSETNUM: null
  STATUS: 1
  LAST_MODIFIED_BY: null
  ROWSTAMP: 0
  SOURCE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: Conduit Bridge
Domains:
• ENABLED:
  Inherited
• SYSTEM:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPECROSSSECTION:
  Inherited
• LEN_SRC:
  Inherited
• OWNERSHIP:
  Inherited
• ROWLOC:
  Inherited
• REHABTYPE:
  Coded Values: [CPP: Cured-in-Place] , [PLP: Plastic Lined] , [PTRP: Point Repair] , ...9 more...
• STATUS:
  Inherited
• SOURCE:
  Inherited
Templates:
• Name: Conduit Bridge
  Description:
  Prototype:
  PIPEMATERIAL: UNK
  PIPECROSSSECTION: CIRC
  MXASSETLOC: null
  LAST_MODIFIED_DATE: null
  MXCREATIONSTATE: 1
  UNPLACEDLATERALPOINTS: null
  LAST_JOBID: null
  REHABTYPE: null
  LEN_SRC: C
  HEIGHT: null
  SUBTYPE: 3
  FACILITYID: null
  ENABLED: 1
  UPSTREAMSTRUCTURE: null
  DOWNSTREAMSTRUCTURE: null
  UPSTREAMINVERT: null
  DOWNSTREAMINVERT: null
  SYSTEM: D
  LENGTH: null
  WIDTH: null
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  CCTV_ID: null
  PARPIPENO: 0
  ROWLOC: null
  INSERVICEDATE: null
  COMBINEDID: null
  REHABDATE: null
  MXSITEID: CS
  MXASSETNUM: null
  STATUS: 1
  LAST_MODIFIED_BY: null
  ROWSTAMP: 0
  SOURCE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 5
Name: Existing Pipe
Domains:
• ENABLED:
  Inherited
• SYSTEM:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPECROSSSECTION:
  Inherited
• LEN_SRC:
  Inherited
• OWNERSHIP:
  Inherited
• ROWLOC:
  Inherited
• REHABTYPE:
  Coded Values: [CPP: Cured-in-Place] , [PLP: Plastic Lined] , [PTRP: Point Repair] , ...9 more...
• STATUS:
  Inherited
• SOURCE:
  Inherited
Templates:
• Name: Existing Pipe
  Description:
  Prototype:
  PIPEMATERIAL: UNK
  PIPECROSSSECTION: CIRC
  MXASSETLOC: null
  LAST_MODIFIED_DATE: null
  MXCREATIONSTATE: 1
  UNPLACEDLATERALPOINTS: null
  LAST_JOBID: null
  REHABTYPE: null
  LEN_SRC: C
  HEIGHT: null
  SUBTYPE: 5
  FACILITYID: null
  ENABLED: 1
  UPSTREAMSTRUCTURE: null
  DOWNSTREAMSTRUCTURE: null
  UPSTREAMINVERT: null
  DOWNSTREAMINVERT: null
  SYSTEM: D
  LENGTH: null
  WIDTH: null
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  CCTV_ID: null
  PARPIPENO: 0
  ROWLOC: null
  INSERVICEDATE: null
  COMBINEDID: null
  REHABDATE: null
  MXSITEID: CS
  MXASSETNUM: null
  STATUS: 1
  LAST_MODIFIED_BY: null
  ROWSTAMP: 0
  SOURCE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: Protective Tunnel
Domains:
• ENABLED:
  Inherited
• SYSTEM:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPECROSSSECTION:
  Inherited
• LEN_SRC:
  Inherited
• OWNERSHIP:
  Inherited
• ROWLOC:
  Inherited
• REHABTYPE:
  Coded Values: [CPP: Cured-in-Place] , [PLP: Plastic Lined] , [PTRP: Point Repair] , ...9 more...
• STATUS:
  Inherited
• SOURCE:
  Inherited
Templates:
• Name: Protective Tunnel
  Description:
  Prototype:
  PIPEMATERIAL: UNK
  PIPECROSSSECTION: CIRC
  MXASSETLOC: null
  LAST_MODIFIED_DATE: null
  MXCREATIONSTATE: 1
  UNPLACEDLATERALPOINTS: null
  LAST_JOBID: null
  REHABTYPE: null
  LEN_SRC: C
  HEIGHT: null
  SUBTYPE: 4
  FACILITYID: null
  ENABLED: 1
  UPSTREAMSTRUCTURE: null
  DOWNSTREAMSTRUCTURE: null
  UPSTREAMINVERT: null
  DOWNSTREAMINVERT: null
  SYSTEM: D
  LENGTH: null
  WIDTH: null
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  CCTV_ID: null
  PARPIPENO: 0
  ROWLOC: null
  INSERVICEDATE: null
  COMBINEDID: null
  REHABDATE: null
  MXSITEID: CS
  MXASSETNUM: null
  STATUS: 1
  LAST_MODIFIED_BY: null
  ROWSTAMP: 0
  SOURCE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata