View In:   ArcGIS Online Map Viewer

Name: CreveCoeur.SDE.ssCleanout

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

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: 771347.7394482605
YMin: 939683.2598096952
XMax: 911116.9149618447
YMax: 1101127.1196641177
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: Cleanout
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Emergency Tank Truck Connection
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Flushing Structure
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Pigging Station
  Description: N/A
  Symbol:
  
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: 20, 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: 2, defaultValue: S, modelName: System , Coded Values: [S: Sanitary sewer] , [D: Storm sewer] , [C: Combined sewer] )
• 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 )
• GPS_X ( type: esriFieldTypeDouble, alias: GPS_X, editable: true, nullable: true, defaultValue: null, modelName: GPS_X , Range: [747600, 927675] )
• GPS_Y ( type: esriFieldTypeDouble, alias: GPS_Y, editable: true, nullable: true, defaultValue: null, modelName: GPS_Y , Range: [930040, 1115040] )
• GPS_Z ( type: esriFieldTypeDouble, alias: GPS_Z, editable: true, nullable: true, defaultValue: null, modelName: GPS_Z )
• 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: 20, defaultValue: null, modelName: COMBINEDID )
• 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... )
• 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 )
• HAZARDTYPE ( type: esriFieldTypeString, alias: HAZARDTYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HAZARDTYPE , Coded Values: [1: NONE] , [5: Explosive] , [6: Radioactive] , ...8 more... )
• TOPELEVATION ( type: esriFieldTypeDouble, alias: TopElevation, editable: true, nullable: true, defaultValue: null, modelName: TopElevation )
• INVERTELEVATION ( type: esriFieldTypeDouble, alias: InvertElevation, editable: true, nullable: true, defaultValue: null, modelName: InvertElevation )
• SYMBOLROTATION ( type: esriFieldTypeDate, alias: SYMBOLROTATION, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SYMBOLROTATION )
• 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 )
• INSERVICEDATE ( type: esriFieldTypeDate, alias: INSERVICEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSERVICEDATE )
• HAZARD_ENTRY ( type: esriFieldTypeString, alias: HAZARD_ENTRY, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HAZARD_ENTRY , Coded Values: [0: None] , [1: Caution] , [2: Do Not Enter] , ...1 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Types:

ID: 1
Name: Cleanout
Domains:
• ENABLED:
  Inherited
• SYSTEM:
  Inherited
• OWNERSHIP:
  Inherited
• GPS_X:
  Inherited
• GPS_Y:
  Inherited
• STATUS:
  Inherited
• SOURCE:
  Inherited
• HAZARDTYPE:
  Inherited
• HAZARD_ENTRY:
  Inherited
Templates:
• Name: Combined sewer
  Description:
  Prototype:
  MXASSETLOC: null
  STATUS: 1
  COMBINEDID: null
  FACILITYID: null
  SYMBOLROTATION: null
  SYSTEM: C
  SUBTYPE: 1
  ENABLED: 1
  HAZARD_ENTRY: null
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  GPS_X: null
  GPS_Y: null
  GPS_Z: null
  ALTID: null
  MXSITEID: CS
  MXASSETNUM: null
  ROWSTAMP: 0
  SOURCE: null
  LAST_JOBID: null
  HAZARDTYPE: null
  TOPELEVATION: null
  INVERTELEVATION: null
  MXCREATIONSTATE: 1
  LAST_MODIFIED_BY: null
  LAST_MODIFIED_DATE: null
  INSERVICEDATE: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Sanitary sewer
  Description:
  Prototype:
  MXASSETLOC: null
  STATUS: 1
  COMBINEDID: null
  FACILITYID: null
  SYMBOLROTATION: null
  SYSTEM: S
  SUBTYPE: 1
  ENABLED: 1
  HAZARD_ENTRY: null
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  GPS_X: null
  GPS_Y: null
  GPS_Z: null
  ALTID: null
  MXSITEID: CS
  MXASSETNUM: null
  ROWSTAMP: 0
  SOURCE: null
  LAST_JOBID: null
  HAZARDTYPE: null
  TOPELEVATION: null
  INVERTELEVATION: null
  MXCREATIONSTATE: 1
  LAST_MODIFIED_BY: null
  LAST_MODIFIED_DATE: null
  INSERVICEDATE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Emergency Tank Truck Connection
Domains:
• ENABLED:
  Inherited
• SYSTEM:
  Inherited
• OWNERSHIP:
  Inherited
• GPS_X:
  Inherited
• GPS_Y:
  Inherited
• STATUS:
  Inherited
• SOURCE:
  Inherited
• HAZARDTYPE:
  Inherited
• HAZARD_ENTRY:
  Inherited
Templates:
• Name: Emergency Tank Truck Connection
  Description:
  Prototype:
  HAZARD_ENTRY: null
  INSERVICEDATE: null
  FACILITYID: null
  ENABLED: 1
  SUBTYPE: 3
  SYSTEM: S
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  GPS_X: null
  GPS_Y: null
  GPS_Z: null
  ALTID: null
  COMBINEDID: null
  MXSITEID: CS
  MXASSETNUM: null
  MXASSETLOC: null
  STATUS: 1
  ROWSTAMP: 0
  SOURCE: null
  LAST_JOBID: null
  HAZARDTYPE: null
  TOPELEVATION: null
  INVERTELEVATION: null
  SYMBOLROTATION: null
  MXCREATIONSTATE: 1
  LAST_MODIFIED_BY: null
  LAST_MODIFIED_DATE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Flushing Structure
Domains:
• ENABLED:
  Inherited
• SYSTEM:
  Inherited
• OWNERSHIP:
  Inherited
• GPS_X:
  Inherited
• GPS_Y:
  Inherited
• STATUS:
  Inherited
• SOURCE:
  Inherited
• HAZARDTYPE:
  Inherited
• HAZARD_ENTRY:
  Inherited
Templates:
• Name: Flushing Structure
  Description:
  Prototype:
  HAZARD_ENTRY: null
  INSERVICEDATE: null
  FACILITYID: null
  ENABLED: 1
  SUBTYPE: 2
  SYSTEM: S
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  GPS_X: null
  GPS_Y: null
  GPS_Z: null
  ALTID: null
  COMBINEDID: null
  MXSITEID: CS
  MXASSETNUM: null
  MXASSETLOC: null
  STATUS: 1
  ROWSTAMP: 0
  SOURCE: null
  LAST_JOBID: null
  HAZARDTYPE: null
  TOPELEVATION: null
  INVERTELEVATION: null
  SYMBOLROTATION: null
  MXCREATIONSTATE: 1
  LAST_MODIFIED_BY: null
  LAST_MODIFIED_DATE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Pigging Station
Domains:
• ENABLED:
  Inherited
• SYSTEM:
  Inherited
• OWNERSHIP:
  Inherited
• GPS_X:
  Inherited
• GPS_Y:
  Inherited
• STATUS:
  Inherited
• SOURCE:
  Inherited
• HAZARDTYPE:
  Inherited
• HAZARD_ENTRY:
  Inherited
Templates:
• Name: Pigging Station
  Description:
  Prototype:
  HAZARD_ENTRY: null
  INSERVICEDATE: null
  FACILITYID: null
  ENABLED: 1
  SUBTYPE: 4
  SYSTEM: S
  OWNERSHIP: 1
  OPID: null
  MAPDATE: null
  PJOBID: null
  MSLINK: null
  GPS_X: null
  GPS_Y: null
  GPS_Z: null
  ALTID: null
  COMBINEDID: null
  MXSITEID: CS
  MXASSETNUM: null
  MXASSETLOC: null
  STATUS: 1
  ROWSTAMP: 0
  SOURCE: null
  LAST_JOBID: null
  HAZARDTYPE: null
  TOPELEVATION: null
  INVERTELEVATION: null
  SYMBOLROTATION: null
  MXCREATIONSTATE: 1
  LAST_MODIFIED_BY: null
  LAST_MODIFIED_DATE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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