View In:   ArcGIS Online Map Viewer

Name: Sewer Pump Station

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: e632556336ef499a84fd8a97908d040d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 75000.0

Max Scale: 0.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: 2015114.0518806428
YMin: 692281.0781622685
XMax: 2080535.0666517592
YMax: 778909.515207395
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: OWNEDBY
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: <all other values>
UniqueValueInfos:
• Value: 1
  Label: Cary
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Private
  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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: OWNEDBY

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• ESTINSTALLYEAR ( type: esriFieldTypeSmallInteger, alias: Estimated Install Year, editable: true, nullable: true, defaultValue: null, modelName: ESTINSTALLYEARINT )
• NAME ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NAME )
• STATIONID ( type: esriFieldTypeString, alias: Station ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STATIONID )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRESS )
• PUMPTYPE ( type: esriFieldTypeString, alias: Pump Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PUMPTYPE , Coded Values: [DRYPIT: Dry Pit] , [SUBMERS: Submersible] )
• PUMPMAN ( type: esriFieldTypeString, alias: Pump Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PUMPMAN )
• NUMOFPUMP ( type: esriFieldTypeDouble, alias: Number of Pumps, editable: true, nullable: true, defaultValue: null, modelName: NUMOFPUMP )
• FIRMCAP ( type: esriFieldTypeDouble, alias: Firm Capacity, editable: true, nullable: true, defaultValue: null, modelName: FIRMCAP )
• TDH ( type: esriFieldTypeDouble, alias: Total Dynamic Head, editable: true, nullable: true, defaultValue: null, modelName: TDH )
• WWTELEV ( type: esriFieldTypeDouble, alias: Wet Well Top Elevation, editable: true, nullable: true, defaultValue: null, modelName: WWTELEV )
• WWFELEV ( type: esriFieldTypeDouble, alias: Wet Well Floor Elevation, editable: true, nullable: true, defaultValue: null, modelName: WWFELEV )
• TIER ( type: esriFieldTypeDouble, alias: Tier, editable: true, nullable: true, defaultValue: null, modelName: TIER , Coded Values: [1: 1] , [2: 2] , [3: 3] )
• GRINDER ( type: esriFieldTypeString, alias: Grinder, editable: true, nullable: true, length: 3, defaultValue: null, modelName: GRINDER , Coded Values: [Yes: Yes] , [No: No] )
• BACKUPPWR ( type: esriFieldTypeString, alias: Backup Power, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BACKUPPWR , Coded Values: [Yes: Yes] , [No: No] )
• ODORCNTRLDEV ( type: esriFieldTypeString, alias: Odor Control Device, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ODORCNTRLDEV , Coded Values: [Yes: Yes] , [No: No] )
• BARSCREEN ( type: esriFieldTypeString, alias: Bar Screen, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BARSCREEN , Coded Values: [Yes: Yes] , [No: No] )
• FLOODPLAIN ( type: esriFieldTypeString, alias: Floodplain, editable: true, nullable: true, length: 3, defaultValue: null, modelName: FLOODPLAIN , Coded Values: [Yes: Yes] , [No: No] )
• FLOODPROOF ( type: esriFieldTypeString, alias: Floodproofed, editable: true, nullable: true, length: 3, defaultValue: null, modelName: FLOODPROOF , Coded Values: [Yes: Yes] , [No: No] )
• FUELTANK ( type: esriFieldTypeString, alias: Fuel Tank, editable: true, nullable: true, length: 3, defaultValue: null, modelName: FUELTANK , Coded Values: [Yes: Yes] , [No: No] )
• FUELTANKSIZE ( type: esriFieldTypeDouble, alias: Fuel Tank Size, editable: true, nullable: true, defaultValue: null, modelName: FUELTANKSIZE )
• NUMGEN ( type: esriFieldTypeDouble, alias: Number of Generators, editable: true, nullable: true, defaultValue: null, modelName: NUMGEN )
• GENSIZE ( type: esriFieldTypeDouble, alias: Generator Size, editable: true, nullable: true, defaultValue: null, modelName: GENSIZE )
• CHEMFEED ( type: esriFieldTypeString, alias: Chemical Feed, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CHEMFEED , Coded Values: [Yes: Yes] , [No: No] )
• CHEMTYPE ( type: esriFieldTypeString, alias: Chemical Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CHEMTYPE , Coded Values: [CN: Calcium Nitrate] , [FC: Ferric Chloride] , [FS: Ferrous Sulfate] )
• SCADA ( type: esriFieldTypeString, alias: SCADA, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SCADA , Coded Values: [SCADA: SCADA] , [DIALER: DIALER] , [BOTH: SCADA/Dialer] )
• STATUS ( type: esriFieldTypeString, alias: Mapping Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS , Coded Values: [Existing: Existing] , [Proposed: Proposed] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [4: Aqua] , [7: Apex] , [13: Chatham County] , ...5 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [7: Apex] , [4: Aqua] , [1: Cary] , ...5 more... )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• UTILEXTPERMNUM ( type: esriFieldTypeString, alias: Utility Extension Permit Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UTILEXTPERMNUM )
• RECORDNAME ( type: esriFieldTypeString, alias: Record Name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: RECORDNAME )
• RECORDNUM ( type: esriFieldTypeString, alias: Record Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RECORDNUM )
• RECORDSOURCE ( type: esriFieldTypeString, alias: Record Source, editable: true, nullable: true, length: 25, defaultValue: null, modelName: RECORDSOURCE , Coded Values: [Auto: Auto Generated] , [Construction: Construction] , [Construction (Permitted): Construction (Permitted)] , ...6 more... )
• RECORDNOTES ( type: esriFieldTypeString, alias: Record Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RECORDNOTES )
• SURVEYDATE ( type: esriFieldTypeDate, alias: Survey Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SURVEYDATE )
• SURVEYNAME ( type: esriFieldTypeString, alias: Survey Name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: SURVEYNAME )
• SURVEYPROJNUM ( type: esriFieldTypeString, alias: Survey Project Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SURVEYPROJNUM )
• SURVEYSOURCE ( type: esriFieldTypeString, alias: Survey Source, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SURVEYSOURCE , Coded Values: [Consultant: Consultant Resources] , [Town: Town Resources] , [Record Drawing: Survey Submitted with Record Drawing] , ...1 more... )
• SURVEYQUALHORZ ( type: esriFieldTypeString, alias: Survey Quality, Horizontal, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SURVEYQUALHORZ , Coded Values: [AA: AA (PLS certified survey per NCBELS)] , [A: A (PLS certified survey per NCBELS)] , [B: B (PLS certified survey per NCBELS)] , ...6 more... )
• SURVEYQUALVERT ( type: esriFieldTypeString, alias: Survey Quality, Vertical, editable: true, nullable: true, length: 40, defaultValue: null, modelName: SURVEYQUALVERT , Coded Values: [A: A (PLS certified survey per NCBELS)] , [B: B (PLS certified survey per NCBELS)] , [C: C (PLS certified survey per NCBELS)] , ...3 more... )
• SURVEYDATUMHORZ ( type: esriFieldTypeString, alias: Survey Datum, Horizontal Survey Datum, Horizontal, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SURVEYDATUMHORZ , Coded Values: [NAD27: NAD27] , [NAD8386: NAD83 (1986)] , [NAD8396: NAD83 (CORS96)] , ...4 more... )
• SURVEYDATUMVERT ( type: esriFieldTypeString, alias: Survey Datum, Vertical, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SURVEYDATUMVERT , Coded Values: [NGVD29: NGVD29] , [NAVD88: NAVD88] )
• SURVEYPOSTPROCESSERROR ( type: esriFieldTypeDouble, alias: Survey Post Process Error, editable: true, nullable: true, defaultValue: null, modelName: SURVEYPOSTPROCESSERROR )
• DEEDREF ( type: esriFieldTypeString, alias: Deed Reference, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DEEDREF )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOTES )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• CREATED_USER ( type: esriFieldTypeString, alias: Created User, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER, required: true )
• CREATED_DATE ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE, required: true )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER, required: true )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE, required: true )
• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: Ancillary Role, editable: true, nullable: true, defaultValue: 0, modelName: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: 1
Name: Cary
Domains:
• PUMPTYPE:
  Inherited
• TIER:
  Inherited
• GRINDER:
  Inherited
• BACKUPPWR:
  Inherited
• ODORCNTRLDEV:
  Inherited
• BARSCREEN:
  Inherited
• FLOODPLAIN:
  Inherited
• FLOODPROOF:
  Inherited
• FUELTANK:
  Inherited
• CHEMFEED:
  Inherited
• CHEMTYPE:
  Inherited
• SCADA:
  Inherited
• STATUS:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ACTIVEFLAG:
  Inherited
• RECORDSOURCE:
  Inherited
• SURVEYSOURCE:
  Inherited
• SURVEYQUALHORZ:
  Inherited
• SURVEYQUALVERT:
  Inherited
• SURVEYDATUMHORZ:
  Inherited
• SURVEYDATUMVERT:
  Inherited
• ENABLED:
  Inherited
• AncillaryRole:
  Inherited
Templates:
• Name: 1
  Description:
  Prototype:
  AncillaryRole: 0
  ENABLED: 1
  FACILITYID: null
  INSTALLDATE: null
  ESTINSTALLYEAR: null
  NAME: null
  STATIONID: null
  ADDRESS: null
  PUMPTYPE: null
  PUMPMAN: null
  NUMOFPUMP: null
  FIRMCAP: null
  TDH: null
  WWTELEV: null
  WWFELEV: null
  TIER: null
  GRINDER: null
  BACKUPPWR: null
  ODORCNTRLDEV: null
  BARSCREEN: null
  FLOODPLAIN: null
  FLOODPROOF: null
  FUELTANK: null
  FUELTANKSIZE: null
  NUMGEN: null
  GENSIZE: null
  CHEMFEED: null
  CHEMTYPE: null
  SCADA: null
  STATUS: null
  OWNEDBY: 1
  MAINTBY: 1
  ACTIVEFLAG: 1
  UTILEXTPERMNUM: null
  RECORDNAME: null
  RECORDNUM: null
  RECORDSOURCE: null
  RECORDNOTES: null
  SURVEYDATE: null
  SURVEYNAME: null
  SURVEYPROJNUM: null
  SURVEYSOURCE: null
  SURVEYQUALHORZ: null
  SURVEYQUALVERT: null
  SURVEYDATUMHORZ: null
  SURVEYDATUMVERT: null
  SURVEYPOSTPROCESSERROR: null
  DEEDREF: null
  NOTES: null
  ROTATION: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Private
Domains:
• PUMPTYPE:
  Inherited
• TIER:
  Inherited
• GRINDER:
  Inherited
• BACKUPPWR:
  Inherited
• ODORCNTRLDEV:
  Inherited
• BARSCREEN:
  Inherited
• FLOODPLAIN:
  Inherited
• FLOODPROOF:
  Inherited
• FUELTANK:
  Inherited
• CHEMFEED:
  Inherited
• CHEMTYPE:
  Inherited
• SCADA:
  Inherited
• STATUS:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ACTIVEFLAG:
  Inherited
• RECORDSOURCE:
  Inherited
• SURVEYSOURCE:
  Inherited
• SURVEYQUALHORZ:
  Inherited
• SURVEYQUALVERT:
  Inherited
• SURVEYDATUMHORZ:
  Inherited
• SURVEYDATUMVERT:
  Inherited
• ENABLED:
  Inherited
• AncillaryRole:
  Inherited
Templates:
• Name: 2
  Description:
  Prototype:
  AncillaryRole: 0
  ENABLED: 1
  FACILITYID: null
  INSTALLDATE: null
  ESTINSTALLYEAR: null
  NAME: null
  STATIONID: null
  ADDRESS: null
  PUMPTYPE: null
  PUMPMAN: null
  NUMOFPUMP: null
  FIRMCAP: null
  TDH: null
  WWTELEV: null
  WWFELEV: null
  TIER: null
  GRINDER: null
  BACKUPPWR: null
  ODORCNTRLDEV: null
  BARSCREEN: null
  FLOODPLAIN: null
  FLOODPROOF: null
  FUELTANK: null
  FUELTANKSIZE: null
  NUMGEN: null
  GENSIZE: null
  CHEMFEED: null
  CHEMTYPE: null
  SCADA: null
  STATUS: null
  OWNEDBY: 2
  MAINTBY: 1
  ACTIVEFLAG: 1
  UTILEXTPERMNUM: null
  RECORDNAME: null
  RECORDNUM: null
  RECORDSOURCE: null
  RECORDNOTES: null
  SURVEYDATE: null
  SURVEYNAME: null
  SURVEYPROJNUM: null
  SURVEYSOURCE: null
  SURVEYQUALHORZ: null
  SURVEYQUALVERT: null
  SURVEYDATUMHORZ: null
  SURVEYDATUMVERT: null
  SURVEYPOSTPROCESSERROR: null
  DEEDREF: null
  NOTES: null
  ROTATION: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata