View In:   ArcGIS Online map viewer

Name: Critical (Water Service Connections)

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 24000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: 1606502.5528437009
YMin: 872723.9753276659
XMax: 1772006.3648293912
YMax: 1069712.1026902944
Spatial Reference: 2273  (2273)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• FACILITYID ( type: esriFieldTypeString , alias: Facility Identifier , editable: true , nullable: true , length: 40 )
• LEGACYID ( type: esriFieldTypeString , alias: LEGACYID , editable: true , nullable: true , length: 255 )
• LIFECYCLESTATUS ( type: esriFieldTypeString , alias: Lifecycle Status , editable: true , nullable: true , length: 25 , Coded Values: [Abandoned: Abandoned] , [Active: Active] , [ActiveNew: Active-New] , ...8 more... )
• CONDITION ( type: esriFieldTypeSmallInteger , alias: Condition , editable: true , nullable: true , Coded Values: [1: Excellent] , [2: Very Good] , [3: Good] , ...4 more... )
• CONDITIONDATE ( type: esriFieldTypeDate , alias: Condition Date , editable: true , nullable: true , length: 8 )
• METSERVICE ( type: esriFieldTypeString , alias: Metered Service , editable: true , nullable: true , length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• SERVICETYPE ( type: esriFieldTypeString , alias: Service Type , editable: true , nullable: true , length: 50 , Coded Values: [Domestic: Domestic] , [Commercial: Commercial] , [Industrial: Industrial] , ...3 more... )
• INSTALLDATE ( type: esriFieldTypeDate , alias: Install Date , editable: true , nullable: true , length: 8 )
• INSTALLEDBY ( type: esriFieldTypeString , alias: Installed By , editable: true , nullable: true , length: 100 , Coded Values: [LCWSC: LCWSC] , [Contractor: Contractor] , [Other: Other] )
• INSTALLCOST ( type: esriFieldTypeDouble , alias: Install Cost , editable: true , nullable: true )
• LOCDESC ( type: esriFieldTypeString , alias: Location Description , editable: true , nullable: true , length: 200 )
• CRITICAL ( type: esriFieldTypeSmallInteger , alias: CriticalCustomer , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• LOCATIONNO ( type: esriFieldTypeInteger , alias: Location Number , editable: true , nullable: true )
• PCRF ( type: esriFieldTypeString , alias: PCRF , editable: true , nullable: true , length: 12 )
• STREETLOCATION ( type: esriFieldTypeString , alias: Street Location , editable: true , nullable: true , length: 10 )
• STREETNAME ( type: esriFieldTypeString , alias: Street Name , editable: true , nullable: true , length: 25 )
• ADDRESS ( type: esriFieldTypeString , alias: Address , editable: true , nullable: true , length: 37 )
• MH ( type: esriFieldTypeSmallInteger , alias: Valves , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• ACCOUNTNO ( type: esriFieldTypeInteger , alias: Account Number , editable: true , nullable: true )
• HOMEPHONE ( type: esriFieldTypeString , alias: HOMEPHONE , editable: true , nullable: true , length: 12 )
• FIRSTNAME ( type: esriFieldTypeString , alias: First Name , editable: true , nullable: true , length: 20 )
• LASTNAME ( type: esriFieldTypeString , alias: Last Name , editable: true , nullable: true , length: 40 )
• FULLNAME ( type: esriFieldTypeString , alias: Full Name , editable: true , nullable: true , length: 62 )
• METERSRNO ( type: esriFieldTypeString , alias: Meter Serial Number , editable: true , nullable: true , length: 50 )
• METERNOTES ( type: esriFieldTypeString , alias: Meter Notes , editable: true , nullable: true , length: 255 )
• ROTATION ( type: esriFieldTypeDouble , alias: Rotation , editable: true , nullable: true )
• ENABLED ( type: esriFieldTypeSmallInteger , alias: Enabled , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger , alias: Active Flag , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger , alias: Owned By , editable: true , nullable: true , Coded Values: [1: LCWSC] , [2: City of Clinton] , [3: Greenville Water System] , ...9 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger , alias: Managed By , editable: true , nullable: true , Coded Values: [1: LCWSC] , [2: City of Clinton] , [3: Greenville Water System] , ...9 more... )
• SAMPLESTATION ( type: esriFieldTypeString , alias: Sampling Station , editable: true , nullable: true , length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• TCR ( type: esriFieldTypeString , alias: Total Coliform Rule , editable: true , nullable: true , length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• DBP ( type: esriFieldTypeString , alias: Disinfection By Product , editable: true , nullable: true , length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• CAPTUREMETH ( type: esriFieldTypeString , alias: Capture Method , editable: true , nullable: true , length: 100 , Coded Values: [ASB: Asbuilt/Record Drawing] , [DES: Design Drawing] , [GEO: Geocoded] , ...6 more... )
• CAPTUREDATE ( type: esriFieldTypeDate , alias: Capture Date , editable: true , nullable: true , length: 8 )
• LASTUPDATE ( type: esriFieldTypeDate , alias: Last Update Date , editable: true , nullable: true , length: 8 )
• LASTEDITOR ( type: esriFieldTypeString , alias: Last Editor , editable: true , nullable: true , length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• MTRDIAM ( type: esriFieldTypeString , alias: MTRDIAM , editable: true , nullable: true , length: 10 )
• MTRMFG ( type: esriFieldTypeString , alias: MTRMFG , editable: true , nullable: true , length: 50 )
• CUSTSERMAT ( type: esriFieldTypeString , alias: CUSTSCRMAT , editable: true , nullable: true , length: 25 )
• LCWSCSERMAT ( type: esriFieldTypeString , alias: LCWSCSERMAT , editable: true , nullable: true , length: 25 )
• ColiformSiteNo_ ( type: esriFieldTypeSmallInteger , alias: ColiformSiteNo , editable: true , nullable: true )
• PRV ( type: esriFieldTypeString , alias: PRV , editable: true , nullable: true , length: 25 )

Templates:

• Name: Active
  Description:
  Prototype:
  LEGACYID: null
  CONDITIONDATE: null
  LOCDESC: null
  ROTATION: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  PRV: null
  FACILITYID: null
  LIFECYCLESTATUS: Active
  CONDITION: null
  METSERVICE: Yes
  SERVICETYPE: null
  INSTALLDATE: null
  INSTALLEDBY: null
  INSTALLCOST: null
  CRITICAL: 0
  LOCATIONNO: null
  PCRF: null
  STREETLOCATION: null
  STREETNAME: null
  ADDRESS: null
  MH: null
  ACCOUNTNO: null
  HOMEPHONE: null
  FIRSTNAME: null
  LASTNAME: null
  FULLNAME: null
  METERSRNO: null
  METERNOTES: null
  MAINTBY: 1
  SAMPLESTATION: null
  TCR: null
  DBP: null
  CAPTUREMETH: null
  CAPTUREDATE: null
  LASTUPDATE: null
  LASTEDITOR: null
  ColiformSiteNo_: null
  MTRDIAM: null
  MTRMFG: null
  CUSTSERMAT: null
  LCWSCSERMAT: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Inactive
  Description:
  Prototype:
  LEGACYID: null
  CONDITIONDATE: null
  LOCDESC: null
  ROTATION: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  PRV: null
  FACILITYID: null
  LIFECYCLESTATUS: Inactive
  CONDITION: null
  METSERVICE: Yes
  SERVICETYPE: null
  INSTALLDATE: null
  INSTALLEDBY: null
  INSTALLCOST: null
  CRITICAL: 0
  LOCATIONNO: null
  PCRF: null
  STREETLOCATION: null
  STREETNAME: null
  ADDRESS: null
  MH: null
  ACCOUNTNO: null
  HOMEPHONE: null
  FIRSTNAME: null
  LASTNAME: null
  FULLNAME: null
  METERSRNO: null
  METERNOTES: null
  MAINTBY: 1
  SAMPLESTATION: null
  TCR: null
  DBP: null
  CAPTUREMETH: null
  CAPTUREDATE: null
  LASTUPDATE: null
  LASTEDITOR: null
  ColiformSiteNo_: null
  MTRDIAM: null
  MTRMFG: null
  CUSTSERMAT: null
  LCWSCSERMAT: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Create,Delete,Query,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supported Operations:   Query   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates