View In:
  ArcGIS Online Map Viewer
 Name: CreveCoeur.SDE.SSP
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: 786389.6122515947
YMin: 946018.9531750306
XMax: 910804.194786761
YMax: 1087305.2608249485
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:  
Default Label:  N/A
UniqueValueInfos: 
- 
Value:  1
 Label:  Check Valve
 Description:  N/A
 Symbol:
- 
Value:  2
 Label:  Combination
 Description:  N/A
 Symbol:
- 
Value:  0
 Label:  Pump
 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
)
- 
ELEVATION
(
type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION
)
- 
FACILITYID
(
type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID
)
- 
SUBTYPE
(
type: esriFieldTypeInteger, alias: SUBTYPE, editable: true, nullable: true, defaultValue: 0, modelName: Subtype
)
- 
SYSTEM
(
type: esriFieldTypeString, alias: SYSTEM, editable: true, nullable: true, length: 255, defaultValue: S, modelName: SYSTEM
, Coded Values: 
[S: Sanitary sewer]
, [D: Storm sewer]
, [C: Combined sewer]
)
- 
PJOBID
(
type: esriFieldTypeString, alias: PJOBID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PJOBID
)
- 
PARCELID
(
type: esriFieldTypeString, alias: PARCELID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PARCELID
)
- 
LATERALID
(
type: esriFieldTypeString, alias: LATERALID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LATERALID
)
- 
MSLINK
(
type: esriFieldTypeInteger, alias: MSLINK, editable: true, nullable: true, defaultValue: null, modelName: MSLINK
)
- 
PUMPTYPE
(
type: esriFieldTypeString, alias: PUMPTYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PUMPTYPE
)
- 
ENABLED
(
type: esriFieldTypeSmallInteger, alias: ENABLED, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED
, Coded Values: 
[0: False]
, [1: True]
)
- 
OWNERSHIP
(
type: esriFieldTypeString, alias: OWNERSHIP, editable: true, nullable: true, length: 50, defaultValue: 2, modelName: OWNERSHIP
, Coded Values: 
[1: MSD]
, [2: Private]
, [3: County]
, ...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: 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
)
- 
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
)
- 
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...
)
- 
GPS_X
(
type: esriFieldTypeDouble, alias: GPS_X, editable: true, nullable: true, defaultValue: null, modelName: GPS_X
)
- 
GPS_Y
(
type: esriFieldTypeDouble, alias: GPS_Y, editable: true, nullable: true, defaultValue: null, modelName: GPS_Y
)
- 
GPS_Z
(
type: esriFieldTypeDouble, alias: GPS_Z, editable: true, nullable: true, defaultValue: null, modelName: GPS_Z
)
- 
LAST_JOBID
(
type: esriFieldTypeString, alias: LAST_JOBID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAST_JOBID
)
- 
INSTALLDATE
(
type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE
)
- 
LOCATIONDESCRIPTION
(
type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATIONDESCRIPTION
)
- 
LIFECYCLESTATUS
(
type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LifecycleStatus
)
- 
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
)
Types:
ID: 1
Name: Check Valve
Domains:
- 
SYSTEM:
 Inherited
- 
ENABLED:
 Inherited
- 
OWNERSHIP:
 Inherited
- 
STATUS:
 Inherited
- 
SOURCE:
 Inherited
Templates:
- 
Name: Check Valve
 Description:
 Prototype:
LAST_MODIFIED_DATE:  null
 LAST_MODIFIED_BY:  null
 ELEVATION:  null
 FACILITYID:  null
 SUBTYPE:  1
 SYSTEM:  S
 PJOBID:  null
 PARCELID:  null
 LATERALID:  null
 MSLINK:  null
 PUMPTYPE:  null
 ENABLED:  1
 OWNERSHIP:  2
 MXSITEID:  CS
 MXASSETNUM:  null
 MXASSETLOC:  null
 STATUS:  1
 ROWSTAMP:  0
 OPID:  null
 MAPDATE:  null
 SOURCE:  null
 GPS_X:  null
 GPS_Y:  null
 GPS_Z:  null
 LAST_JOBID:  null
 INSTALLDATE:  null
 LOCATIONDESCRIPTION:  null
 LIFECYCLESTATUS:  null
 INSERVICEDATE:  null
 MXCREATIONSTATE:  1
 
 Drawing Tool: esriFeatureEditToolPoint
ID: 2
Name: Combination
Domains:
- 
SYSTEM:
 Inherited
- 
ENABLED:
 Inherited
- 
OWNERSHIP:
 Inherited
- 
STATUS:
 Inherited
- 
SOURCE:
 Inherited
Templates:
- 
Name: Combination
 Description:
 Prototype:
LAST_MODIFIED_DATE:  null
 LAST_MODIFIED_BY:  null
 ELEVATION:  null
 FACILITYID:  null
 SUBTYPE:  2
 SYSTEM:  S
 PJOBID:  null
 PARCELID:  null
 LATERALID:  null
 MSLINK:  null
 PUMPTYPE:  null
 ENABLED:  1
 OWNERSHIP:  2
 MXSITEID:  CS
 MXASSETNUM:  null
 MXASSETLOC:  null
 STATUS:  1
 ROWSTAMP:  0
 OPID:  null
 MAPDATE:  null
 SOURCE:  null
 GPS_X:  null
 GPS_Y:  null
 GPS_Z:  null
 LAST_JOBID:  null
 INSTALLDATE:  null
 LOCATIONDESCRIPTION:  null
 LIFECYCLESTATUS:  null
 INSERVICEDATE:  null
 MXCREATIONSTATE:  1
 
 Drawing Tool: esriFeatureEditToolPoint
ID: 0
Name: Pump
Domains:
- 
SYSTEM:
 Inherited
- 
ENABLED:
 Inherited
- 
OWNERSHIP:
 Inherited
- 
STATUS:
 Inherited
- 
SOURCE:
 Inherited
Templates:
- 
Name: Sanitary SSP
 Description:
 Prototype:
MXASSETLOC:  null
 STATUS:  1
 OWNERSHIP:  2
 PUMPTYPE:  null
 INSERVICEDATE:  null
 ENABLED:  1
 SUBTYPE:  0
 FACILITYID:  null
 LAST_MODIFIED_DATE:  null
 ELEVATION:  null
 SYSTEM:  S
 PJOBID:  null
 PARCELID:  null
 LATERALID:  null
 MSLINK:  null
 MXSITEID:  CS
 MXASSETNUM:  null
 ROWSTAMP:  0
 OPID:  null
 MAPDATE:  null
 SOURCE:  null
 GPS_X:  null
 GPS_Y:  null
 GPS_Z:  null
 LAST_JOBID:  null
 INSTALLDATE:  null
 LOCATIONDESCRIPTION:  null
 LIFECYCLESTATUS:  null
 MXCREATIONSTATE:  1
 LAST_MODIFIED_BY:  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