View In:   ArcGIS Online Map Viewer

Name: CreveCoeur.SDE.ssPressurizedMain

Display Field: FACILITYID

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: 771339.4897928461
YMin: 935798.4247316122
XMax: 911176.806246262
YMax: 1105321.8084531948
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: Force
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 2
• Value: 2
  Label: Low Pressure
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 115, 223, 255]
  Width: 2
• Value: 3
  Label: Non-CD-FM
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [129, 0, 143, 255]
  Width: 2
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 )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITYID )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• 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: S, modelName: System , Coded Values: [S: Sanitary sewer] , [D: Storm sewer] , [C: Combined sewer] )
• LENGTH ( type: esriFieldTypeInteger, 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 )
• LEN_SRC ( type: esriFieldTypeString, alias: LEN_SRC, editable: true, nullable: true, length: 50, defaultValue: null, 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 )
• ALTID ( type: esriFieldTypeString, alias: ALTID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ALTID )
• 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: NONE, modelName: REHABTYPE , Coded Values: [CPP: Cured-in-Place] , [PLP: Plastic Lined] , [PTRP: Point Repair] , ...8 more... )
• 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: NONMSD, modelName: MXASSETLOC )
• 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... )
• STATUS ( type: esriFieldTypeSmallInteger, alias: STATUS, editable: true, nullable: true, defaultValue: 1, modelName: STATUS , Coded Values: [1: Active] , [2: Abandoned] , [3: Removed] , ...5 more... )
• LAST_JOBID ( type: esriFieldTypeString, alias: LAST_JOBID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAST_JOBID )
• RCH ( type: esriFieldTypeString, alias: RCH, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RCH )
• FMRISK ( type: esriFieldTypeString, alias: FMRISK, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FMRISK , Coded Values: [HIGH: HIGH] , [MED: MEDIUM] , [LOW: LOW] , ...2 more... )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )
• 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 )
• PIPEMATERIAL ( type: esriFieldTypeString, alias: PipeMaterial, editable: true, nullable: true, length: 50, defaultValue: null, 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... )
• SANITARYCONNECTIONFLAG ( type: esriFieldTypeString, alias: SanitaryConnectionFlag, editable: true, nullable: true, length: 50, defaultValue: Y, modelName: SanitaryConnectionFlag , Coded Values: [Y: Yes Allowed] , [N: Not Allowed] )
• INSERVICEDATE ( type: esriFieldTypeDate, alias: INSERVICEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSERVICEDATE )
• MXCREATIONSTATE ( type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, editable: true, nullable: true, defaultValue: 1, modelName: MXCREATIONSTATE )
• LAST_MODIFIED_BY ( type: esriFieldTypeString, alias: LAST_MODIFIED_BY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAST_MODIFIED_BY )
• LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_MODIFIED_DATE )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• FMFREQCD21 ( type: esriFieldTypeString, alias: FMFREQCD21, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FMFREQCD21 , Coded Values: [FIVE YEAR: FIVE YEAR] , [YEARLY: YEARLY] )

Types:

ID: 1
Name: Force
Domains:
• ENABLED:
  Inherited
• SYSTEM:
  Inherited
• LEN_SRC:
  Inherited
• OWNERSHIP:
  Inherited
• REHABTYPE:
  Inherited
• SOURCE:
  Inherited
• STATUS:
  Inherited
• FMRISK:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPECROSSSECTION:
  Inherited
• SANITARYCONNECTIONFLAG:
  Inherited
• FMFREQCD21:
  Inherited
Templates:
• Name: Force
  Description:
  Prototype:
  PIPEMATERIAL: null
  SOURCE: null
  MXASSETLOC: NONMSD
  REHABTYPE: NONE
  MXASSETNUM: null
  FACILITYID: null
  REHABDATE: null
  PIPECROSSSECTION: CIRC
  INSERVICEDATE: null
  LEN_SRC: null
  SUBTYPE: 1
  ENABLED: 1
  FMFREQCD21: null
  SYSTEM: S
  LENGTH: null
  WIDTH: null
  HEIGHT: null
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  ALTID: null
  COMBINEDID: null
  MXSITEID: CS
  ROWSTAMP: 0
  STATUS: 1
  LAST_JOBID: null
  RCH: null
  FMRISK: null
  LAST_MODIFIED_DATE: null
  UPSTREAMSTRUCTURE: null
  DOWNSTREAMSTRUCTURE: null
  UPSTREAMINVERT: null
  DOWNSTREAMINVERT: null
  SANITARYCONNECTIONFLAG: Y
  MXCREATIONSTATE: 1
  LAST_MODIFIED_BY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Low Pressure
Domains:
• ENABLED:
  Inherited
• SYSTEM:
  Inherited
• LEN_SRC:
  Inherited
• OWNERSHIP:
  Inherited
• REHABTYPE:
  Inherited
• SOURCE:
  Inherited
• STATUS:
  Inherited
• FMRISK:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPECROSSSECTION:
  Inherited
• SANITARYCONNECTIONFLAG:
  Inherited
• FMFREQCD21:
  Inherited
Templates:
• Name: Low Pressure
  Description:
  Prototype:
  PIPEMATERIAL: null
  SOURCE: null
  MXASSETLOC: NONMSD
  REHABTYPE: NONE
  MXASSETNUM: null
  FACILITYID: null
  REHABDATE: null
  PIPECROSSSECTION: CIRC
  INSERVICEDATE: null
  LEN_SRC: null
  SUBTYPE: 2
  ENABLED: 1
  FMFREQCD21: null
  SYSTEM: S
  LENGTH: null
  WIDTH: null
  HEIGHT: null
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  ALTID: null
  COMBINEDID: null
  MXSITEID: CS
  ROWSTAMP: 0
  STATUS: 1
  LAST_JOBID: null
  RCH: null
  FMRISK: null
  LAST_MODIFIED_DATE: null
  UPSTREAMSTRUCTURE: null
  DOWNSTREAMSTRUCTURE: null
  UPSTREAMINVERT: null
  DOWNSTREAMINVERT: null
  SANITARYCONNECTIONFLAG: Y
  MXCREATIONSTATE: 1
  LAST_MODIFIED_BY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: Non-CD-FM
Domains:
• ENABLED:
  Inherited
• SYSTEM:
  Inherited
• LEN_SRC:
  Inherited
• OWNERSHIP:
  Inherited
• REHABTYPE:
  Inherited
• SOURCE:
  Inherited
• STATUS:
  Inherited
• FMRISK:
  Inherited
• PIPEMATERIAL:
  Inherited
• PIPECROSSSECTION:
  Inherited
• SANITARYCONNECTIONFLAG:
  Inherited
• FMFREQCD21:
  Inherited
Templates:
• Name: Non-CD-FM
  Description:
  Prototype:
  PIPEMATERIAL: null
  SOURCE: null
  MXASSETLOC: NONMSD
  REHABTYPE: NONE
  MXASSETNUM: null
  FACILITYID: null
  REHABDATE: null
  PIPECROSSSECTION: CIRC
  INSERVICEDATE: null
  LEN_SRC: null
  SUBTYPE: 3
  ENABLED: 1
  FMFREQCD21: null
  SYSTEM: S
  LENGTH: null
  WIDTH: null
  HEIGHT: null
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  ALTID: null
  COMBINEDID: null
  MXSITEID: CS
  ROWSTAMP: 0
  STATUS: 1
  LAST_JOBID: null
  RCH: null
  FMRISK: null
  LAST_MODIFIED_DATE: null
  UPSTREAMSTRUCTURE: null
  DOWNSTREAMSTRUCTURE: null
  UPSTREAMINVERT: null
  DOWNSTREAMINVERT: null
  SANITARYCONNECTIONFLAG: Y
  MXCREATIONSTATE: 1
  LAST_MODIFIED_BY: 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