View In:   ArcGIS Online Map Viewer

Name: SuffolkGIS.DBO.PumpStation

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: c2cc4e5fccbe4edb826a5dac515f4e3d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: 1.2016419048999995E7
YMin: 3411790.074000001
XMax: 1.2095379361000001E7
YMax: 3499741.6360000074
Spatial Reference: 102747  (2284)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [168, 159, 35, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FACILITYID )
• PUMPSTATIONAREA ( type: esriFieldTypeString, alias: PUMPSTATIONAREA, editable: true, nullable: true, length: 60, defaultValue: null, modelName: PUMPSTATIONAREA )
• SERVICEAREA ( type: esriFieldTypeString, alias: SERVICEAREA, editable: true, nullable: true, length: 6, defaultValue: null, modelName: SERVICEAREA )
• POSTING ( type: esriFieldTypeString, alias: POSTING, editable: true, nullable: true, length: 20, defaultValue: U, modelName: POSTING , Coded Values: [1: Conceptual] , [2: Approved] , [3: Under Construction] , ...5 more... )
• PSTYPE ( type: esriFieldTypeString, alias: PSTYPE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PSTYPE , Coded Values: [D: Dry Well/Wet Well] , [S: Submersible] , [V: Vacuum] , ...1 more... )
• GPS ( type: esriFieldTypeString, alias: GPS, editable: true, nullable: true, length: 1, defaultValue: N, modelName: GPS , Coded Values: [Y: Yes] , [N: No] )
• VERTICALDATUM ( type: esriFieldTypeString, alias: VERTICALDATUM, editable: true, nullable: true, length: 10, defaultValue: 88, modelName: VERTICALDATUM , Coded Values: [88: NAVD88] , [29: NGVD29] , [O: Other] , ...1 more... )
• ABOVGROUND ( type: esriFieldTypeString, alias: ABOVGROUND, editable: true, nullable: true, length: 3, defaultValue: Y, modelName: ABOVGROUND , Coded Values: [Y: Yes] , [N: No] )
• FLOORELEV ( type: esriFieldTypeDouble, alias: FLOORELEV, editable: true, nullable: true, defaultValue: null, modelName: FLOORELEV )
• GENERATOR ( type: esriFieldTypeString, alias: GENERATOR, editable: true, nullable: true, length: 3, defaultValue: null, modelName: GENERATOR , Coded Values: [Y: Yes] , [N: No] )
• PROJECTNO ( type: esriFieldTypeString, alias: PROJECTNO, editable: true, nullable: true, length: 18, defaultValue: null, modelName: PROJECTNO )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURCE )
• NOPUMPS ( type: esriFieldTypeInteger, alias: NOPUMPS, editable: true, nullable: true, defaultValue: null, modelName: NOPUMPS )
• TERMINAL ( type: esriFieldTypeString, alias: TERMINAL, editable: true, nullable: true, length: 3, defaultValue: null, modelName: TERMINAL , Coded Values: [Y: Yes] , [N: No] )
• RECEIVER ( type: esriFieldTypeString, alias: RECEIVER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RECEIVER )
• DISCHARGE1 ( type: esriFieldTypeString, alias: DISCHARGE1, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DISCHARGE1 )
• DISCHARGE2 ( type: esriFieldTypeString, alias: DISCHARGE2, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DISCHARGE2 )
• PUMPLEADON ( type: esriFieldTypeDouble, alias: PUMPLEADON, editable: true, nullable: true, defaultValue: null, modelName: PUMPLEADON )
• PUMPLAG1ON ( type: esriFieldTypeDouble, alias: PUMPLAG1ON, editable: true, nullable: true, defaultValue: null, modelName: PUMPLAG1ON )
• PUMPLAG2ON ( type: esriFieldTypeDouble, alias: PUMPLAG2ON, editable: true, nullable: true, defaultValue: null, modelName: PUMPLAG2ON )
• PUMPOFFELEV ( type: esriFieldTypeDouble, alias: PUMPOFFELEV, editable: true, nullable: true, defaultValue: null, modelName: PUMPOFFELEV )
• PUMPCENTERELEV ( type: esriFieldTypeDouble, alias: PUMPCENTERELEV, editable: true, nullable: true, defaultValue: null, modelName: PUMPCENTERELEV )
• WWSHAPE ( type: esriFieldTypeString, alias: WWSHAPE, editable: true, nullable: true, length: 3, defaultValue: U, modelName: WWSHAPE , Coded Values: [U: UNK] , [C: Circular] , [R: Rectangular] , ...2 more... )
• WWLENGTH ( type: esriFieldTypeDouble, alias: WWLENGTH, editable: true, nullable: true, defaultValue: null, modelName: WWLENGTH )
• WWBREADTH ( type: esriFieldTypeDouble, alias: WWBREADTH, editable: true, nullable: true, defaultValue: null, modelName: WWBREADTH )
• WWDEPTH ( type: esriFieldTypeDouble, alias: WWDEPTH, editable: true, nullable: true, defaultValue: null, modelName: WWDEPTH )
• WWVOLUME ( type: esriFieldTypeDouble, alias: WWVOLUME, editable: true, nullable: true, defaultValue: null, modelName: WWVOLUME )
• WW_INV_ELEV ( type: esriFieldTypeDouble, alias: WW_INV_ELEV, editable: true, nullable: true, defaultValue: null, modelName: WW_INV_ELEV )
• WW_OVERFLOW_PT ( type: esriFieldTypeString, alias: WW_OVERFLOW_PT, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WW_OVERFLOW_PT )
• WW_OVERFLOW_ELEV ( type: esriFieldTypeDouble, alias: WW_OVERFLOW_ELEV, editable: true, nullable: true, defaultValue: null, modelName: WW_OVERFLOW_ELEV )
• HW_ALARM ( type: esriFieldTypeDouble, alias: HW_ALARM, editable: true, nullable: true, defaultValue: null, modelName: HW_ALARM )
• HW_DEPTH ( type: esriFieldTypeDouble, alias: HW_DEPTH, editable: true, nullable: true, defaultValue: null, modelName: HW_DEPTH )
• DIA_SEAL_ELEV ( type: esriFieldTypeDouble, alias: DIA_SEAL_ELEV, editable: true, nullable: true, defaultValue: null, modelName: DIA_SEAL_ELEV )
• POWERACCTNUM ( type: esriFieldTypeString, alias: POWERACCTNUM, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POWERACCTNUM )
• POWERMETERNUM ( type: esriFieldTypeString, alias: POWERMETERNUM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: POWERMETERNUM )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: WARRANTYDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTYDATE )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CONDITION )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: CONDITIONDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITIONDATE )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 75, defaultValue: null, modelName: COMMENTS )
• PORTGENPLUG ( type: esriFieldTypeString, alias: PORTGENPLUG, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PORTGENPLUG )
• PORTGENPLUGSIZE ( type: esriFieldTypeString, alias: PORTGENPLUGSIZE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PORTGENPLUGSIZE )
• PORTGENCOMMENTS ( type: esriFieldTypeString, alias: PORTGENCOMMENTS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PORTGENCOMMENTS )
• MINPORTGENSIZE ( type: esriFieldTypeString, alias: MINPORTGENSIZE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MINPORTGENSIZE )
• EPC_SUCTION ( type: esriFieldTypeString, alias: EPC_SUCTION, editable: true, nullable: true, length: 5, defaultValue: null, modelName: EPC_SUCTION , Coded Values: [Y: Yes] , [N: NO] , [UNK: Unknown] )
• EPC_DISCHARGE ( type: esriFieldTypeString, alias: EPC_DISCHARGE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: EPC_DISCHARGE , Coded Values: [Y: Yes] , [N: NO] , [UNK: Unknown] )
• EPC_PIPESIZE ( type: esriFieldTypeDouble, alias: EPC_PIPESIZE, editable: true, nullable: true, defaultValue: null, modelName: EPC_PIPESIZE )
• EPC_CONNSIZE ( type: esriFieldTypeDouble, alias: EPC_CONNSIZE, editable: true, nullable: true, defaultValue: null, modelName: EPC_CONNSIZE )
• TRANSFER_SWITCH ( type: esriFieldTypeString, alias: TRANSFER_SWITCH, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TRANSFER_SWITCH , Coded Values: [Y: Yes] , [N: No] , [U: UNK] )
• SWITCH_TYPE ( type: esriFieldTypeString, alias: SWITCH_TYPE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SWITCH_TYPE , Coded Values: [A: Automatic] , [M: Manual] , [U: UNK] )
• SWITCH_AMP ( type: esriFieldTypeString, alias: SWITCH_AMP, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SWITCH_AMP )
• SWITCH_VOLTAGE ( type: esriFieldTypeString, alias: SWITCH_VOLTAGE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SWITCH_VOLUME )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION )
• VAC_HW_LO_ELEV ( type: esriFieldTypeDouble, alias: VAC_HW_LO_ELEV, editable: true, nullable: true, defaultValue: null, modelName: VAC_HW_LO_ELEV )
• VAC_HW_LO_RESET_ELEV ( type: esriFieldTypeDouble, alias: VAC_HW_LO_RESET_ELEV, editable: true, nullable: true, defaultValue: null, modelName: VAC_HW_LO_RESET_ELEV )
• VAC_OFF_PRESSURE ( type: esriFieldTypeDouble, alias: VAC_OFF_PRESSURE, editable: true, nullable: true, defaultValue: null, modelName: VAC_OFF_PRESSURE )
• VAC_ON_PRESSURE ( type: esriFieldTypeDouble, alias: VAC_ON_PRESSURE, editable: true, nullable: true, defaultValue: null, modelName: VAC_ON_PRESSURE )
• TELOG ( type: esriFieldTypeString, alias: TELOG, editable: true, nullable: true, length: 1, defaultValue: null, modelName: TELOG , Coded Values: [Y: Yes] , [N: No] )
• PUMPOFFDEPTH ( type: esriFieldTypeDouble, alias: PUMPOFFDEPTH, editable: true, nullable: true, defaultValue: null, modelName: PUMPOFFDEPTH )
• PUMPLEADONDEPTH ( type: esriFieldTypeDouble, alias: PUMPLEADONDEPTH, editable: true, nullable: true, defaultValue: null, modelName: PUMPLEADONDEPTH )
• PUMPLAGON1DEPTH ( type: esriFieldTypeDouble, alias: PUMPLAGON1DEPTH, editable: true, nullable: true, defaultValue: null, modelName: PUMPLAGON1DEPTH )
• PUMPLAGON2DEPTH ( type: esriFieldTypeDouble, alias: PUMPLAGON2DEPTH, editable: true, nullable: true, defaultValue: null, modelName: PUMPLAGON2DEPTH )
• WW_OVERFLOW_DEPTH ( type: esriFieldTypeDouble, alias: WW_OVERFLOW_DEPTH, editable: true, nullable: true, defaultValue: null, modelName: WW_OVERFLOW_DEPTH )
• HIGHTARGETELEV ( type: esriFieldTypeDouble, alias: HIGHTARGETELEV, editable: true, nullable: true, defaultValue: null, modelName: HIGHTARGETELEV )
• GlobalID ( type: esriFieldTypeString, alias: GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GlobalID )
• PUMPCENTERDEPTH ( type: esriFieldTypeDouble, alias: PUMPCENTERDEPTH, editable: true, nullable: true, defaultValue: null, modelName: PUMPCENTERDEPTH )
• DIA_SEAL_DEPTH ( type: esriFieldTypeDouble, alias: DIA_SEAL_DEPTH, editable: true, nullable: true, defaultValue: null, modelName: DIA_SEAL_DEPTH )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 254, defaultValue: null, modelName: created_us )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_da )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 254, defaultValue: null, modelName: last_edite )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edi_1 )
• BACKUP_FLOAT_ON_DEPTH ( type: esriFieldTypeDouble, alias: BACKUP_FLOAT_ON_DEPTH, editable: true, nullable: true, defaultValue: null, modelName: BACKUP_FLOAT_ON_DEPTH )
• BACKUP_FLOAT_OFF_DEPTH ( type: esriFieldTypeDouble, alias: BACKUP_FLOAT_OFF_DEPTH, editable: true, nullable: true, defaultValue: null, modelName: BACKUP_FLOAT_OFF_DEPTH )
• BACKUP_FLOAT_ON_ELEV ( type: esriFieldTypeDouble, alias: BACKUP_FLOAT_ON_ELEV, editable: true, nullable: true, defaultValue: null, modelName: BACKUP_FLOAT_ON_ELEV )
• BACKUP_FLOAT_OFF_ELEV ( type: esriFieldTypeDouble, alias: BACKUP_FLOAT_OFF_ELEV, editable: true, nullable: true, defaultValue: null, modelName: BACKUP_FLOAT_OFF_ELEV )
• BYPASSPUMP ( type: esriFieldTypeString, alias: BYPASSPUMP, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BYPASSPUMP )
• BYPASSHOSESIZE ( type: esriFieldTypeDouble, alias: BYPASSHOSESIZE, editable: true, nullable: true, defaultValue: null, modelName: BYPASSHOSESIZE )
• BYPASS_SPEED ( type: esriFieldTypeInteger, alias: BYPASS_SPEED, editable: true, nullable: true, defaultValue: null, modelName: BYPASS_SPEED )
• CriticalReason ( type: esriFieldTypeString, alias: CriticalReason, editable: true, nullable: true, length: 75, defaultValue: null, modelName: CriticalReason )

Templates:

• Name: SuffolkGIS.DBO.PumpStation
  Description:
  Prototype:
  BYPASS_SPEED: null
  CriticalReason: null
  FACILITYID: null
  PUMPSTATIONAREA: null
  SERVICEAREA: null
  POSTING: U
  PSTYPE: null
  GPS: N
  VERTICALDATUM: 88
  ABOVGROUND: Y
  FLOORELEV: null
  GENERATOR: null
  PROJECTNO: null
  SOURCE: null
  NOPUMPS: null
  TERMINAL: null
  RECEIVER: null
  DISCHARGE1: null
  DISCHARGE2: null
  PUMPLEADON: null
  PUMPLAG1ON: null
  PUMPLAG2ON: null
  PUMPOFFELEV: null
  PUMPCENTERELEV: null
  WWSHAPE: U
  WWLENGTH: null
  WWBREADTH: null
  WWDEPTH: null
  WWVOLUME: null
  WW_INV_ELEV: null
  WW_OVERFLOW_PT: null
  WW_OVERFLOW_ELEV: null
  HW_ALARM: null
  HW_DEPTH: null
  DIA_SEAL_ELEV: null
  POWERACCTNUM: null
  POWERMETERNUM: null
  INSTALLDATE: null
  WARRANTYDATE: null
  CONDITION: null
  CONDITIONDATE: null
  COMMENTS: null
  PORTGENPLUG: null
  PORTGENPLUGSIZE: null
  PORTGENCOMMENTS: null
  MINPORTGENSIZE: null
  EPC_SUCTION: null
  EPC_DISCHARGE: null
  EPC_PIPESIZE: null
  EPC_CONNSIZE: null
  TRANSFER_SWITCH: null
  SWITCH_TYPE: null
  SWITCH_AMP: null
  SWITCH_VOLTAGE: null
  LOCATION: null
  VAC_HW_LO_ELEV: null
  VAC_HW_LO_RESET_ELEV: null
  VAC_OFF_PRESSURE: null
  VAC_ON_PRESSURE: null
  TELOG: null
  PUMPOFFDEPTH: null
  PUMPLEADONDEPTH: null
  PUMPLAGON1DEPTH: null
  PUMPLAGON2DEPTH: null
  WW_OVERFLOW_DEPTH: null
  HIGHTARGETELEV: null
  GlobalID: null
  PUMPCENTERDEPTH: null
  DIA_SEAL_DEPTH: null
  BYPASSHOSESIZE: null
  BYPASSPUMP: null
  BACKUP_FLOAT_OFF_ELEV: null
  BACKUP_FLOAT_ON_ELEV: null
  BACKUP_FLOAT_ON_DEPTH: null
  BACKUP_FLOAT_OFF_DEPTH: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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: false

Supports Coordinates Quantization: true

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