View In:   ArcGIS Online map viewer

Name: SewerEdit2.DBO.wLCRR_Data

Display Field: SERVICEADD

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

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: -119214200
YMin: -96198500
XMax: 3.3173628924191892E7
YMax: 2544404.898309648
Spatial Reference: 102729  (2272)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: STATUS
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [230, 0, 0, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label:
UniqueValueInfos:
• Value: Both Complete
  Label: Both Complete
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [76, 230, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Customer Side Complete
  Label: Customer Side Complete
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [197, 0, 255, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: HSWA Side Complete
  Label: HSWA Side Complete
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [255, 170, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: STATUS

Fields:

• OBJECTID_1 ( type: esriFieldTypeOID , alias: OBJECTID_1 , editable: false , nullable: false )
• OBJECTID ( type: esriFieldTypeInteger , alias: OBJECTID , editable: true , nullable: true )
• SERVICEADD ( type: esriFieldTypeString , alias: SERVICEADD , editable: true , nullable: true , length: 75 )
• ACCOUNT_ ( type: esriFieldTypeString , alias: ACCOUNT_ , editable: true , nullable: true , length: 10 )
• POINT_X ( type: esriFieldTypeDouble , alias: POINT_X , editable: true , nullable: true )
• POINT_Y ( type: esriFieldTypeDouble , alias: POINT_Y , editable: true , nullable: true )
• ACCOUNTNUM ( type: esriFieldTypeInteger , alias: ACCOUNTNUM , editable: true , nullable: true )
• ACCOUNTTYP ( type: esriFieldTypeString , alias: ACCOUNTTYP , editable: true , nullable: true , length: 20 )
• InvType ( type: esriFieldTypeString , alias: InvType , editable: true , nullable: true , length: 50 , Coded Values: [I: Initial] , [U: Update] , [A: Add] , ...1 more... )
• RplcDt ( type: esriFieldTypeString , alias: RplcDt , editable: true , nullable: true , length: 50 )
• OwnType ( type: esriFieldTypeString , alias: OwnType , editable: true , nullable: true , length: 50 , Coded Values: [J: Joint] , [S: System] , [C: Customer] )
• SLAddr1 ( type: esriFieldTypeString , alias: SLAddr1 , editable: true , nullable: true , length: 50 )
• Sch ( type: esriFieldTypeString , alias: Sch , editable: true , nullable: true , length: 50 , Coded Values: [N: No] , [YE: Yes - Elementary] , [YS: Yes - Secondary] , ...1 more... )
• ChCare ( type: esriFieldTypeString , alias: ChCare , editable: true , nullable: true , length: 50 , Coded Values: [N: No] , [Y: Yes] )
• SysMat ( type: esriFieldTypeString , alias: SysMat , editable: true , nullable: true , length: 50 , Coded Values: [A: Lead] , [B: Lead-lined galvanized] , [E: Cast iron - lined] , ...14 more... )
• PrevLead ( type: esriFieldTypeString , alias: PrevLead , editable: true , nullable: true , length: 50 , Coded Values: [Y: Yes] , [N: No] , [S: Not Sure] )
• SysConn ( type: esriFieldTypeString , alias: SysConn , editable: true , nullable: true , length: 50 , Coded Values: [Y: Yes] , [N: No] , [S: Not Sure] )
• SysInstl ( type: esriFieldTypeString , alias: SysInstl , editable: true , nullable: true , length: 50 , Coded Values: [A: Pre - 1901] , [B: 1901 - 1910] , [C: 1911 - 1920] , ...11 more... )
• SysInstl2 ( type: esriFieldTypeString , alias: SysInstl2 , editable: true , nullable: true , length: 50 )
• SLDiam ( type: esriFieldTypeString , alias: SLDiam , editable: true , nullable: true , length: 50 )
• SysBas1 ( type: esriFieldTypeString , alias: SysBas1 , editable: true , nullable: true , length: 50 , Coded Values: [A: Records review] , [B: Modeling/statistical analysis] , [C: Water sampling (no CCT)] , ...1 more... )
• SysVer ( type: esriFieldTypeString , alias: SysVer , editable: true , nullable: true , length: 50 , Coded Values: [E: Visual inspection at existing access point] , [F: CCTV inspection inside pipe - full length] , [G: CCTV inspection outside pipe - at curb box] , ...4 more... )
• SysVerDt ( type: esriFieldTypeDate , alias: SysVerDt , editable: true , nullable: true , length: 8 )
• SysTxt ( type: esriFieldTypeString , alias: SysTxt , editable: true , nullable: true , length: 50 )
• CustMat ( type: esriFieldTypeString , alias: CustMat , editable: true , nullable: true , length: 50 , Coded Values: [A: Lead] , [B: Lead-lined galvanized] , [E: Cast iron - lined] , ...14 more... )
• CustConn ( type: esriFieldTypeString , alias: CustConn , editable: true , nullable: true , length: 50 , Coded Values: [Y: Yes] , [N: No] , [S: Not Sure] )
• CusInstl ( type: esriFieldTypeString , alias: CusInstl , editable: true , nullable: true , length: 50 , Coded Values: [A: Pre - 1901] , [B: 1901 - 1910] , [C: 1911 - 1920] , ...11 more... )
• CustInstl2 ( type: esriFieldTypeString , alias: CustInstl2 , editable: true , nullable: true , length: 50 )
• CustBas1 ( type: esriFieldTypeString , alias: CustBas1 , editable: true , nullable: true , length: 50 , Coded Values: [A: Records review] , [B: Modeling/statistical analysis] , [C: Water sampling (no CCT)] , ...1 more... )
• CustVer ( type: esriFieldTypeString , alias: CustVer , editable: true , nullable: true , length: 50 , Coded Values: [E: Visual inspection at existing access point] , [F: CCTV inspection inside pipe - full length] , [G: CCTV inspection outside pipe - at curb box] , ...4 more... )
• CustVerDt ( type: esriFieldTypeDate , alias: CustVerDt , editable: true , nullable: true , length: 8 )
• CustTxt ( type: esriFieldTypeString , alias: CustTxt , editable: true , nullable: true , length: 50 )
• SLConn ( type: esriFieldTypeString , alias: SLConn , editable: true , nullable: true , length: 50 , Coded Values: [S: Single Family Residence] , [M: Multiple Family Residence] , [O: Building/Other] )
• POE ( type: esriFieldTypeString , alias: POE , editable: true , nullable: true , length: 50 , Coded Values: [Y: Yes] , [N: No] , [S: Not Sure] )
• Solder ( type: esriFieldTypeString , alias: Solder , editable: true , nullable: true , length: 50 , Coded Values: [Y: Yes] , [N: No] , [S: Not Sure] )
• LCR_Site ( type: esriFieldTypeString , alias: LCR_Site , editable: true , nullable: true , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• DateStamp ( type: esriFieldTypeString , alias: DateStamp , editable: true , nullable: true , length: 50 )
• PRV ( type: esriFieldTypeString , alias: PRV , editable: true , nullable: true , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• BACKFLOW ( type: esriFieldTypeString , alias: BACKFLOW , editable: true , nullable: true , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• NOTES1 ( type: esriFieldTypeString , alias: NOTES1 , editable: true , nullable: true , length: 50 )
• NOTES2 ( type: esriFieldTypeString , alias: NOTES2 , editable: true , nullable: true , length: 50 )
• NOTES3 ( type: esriFieldTypeString , alias: NOTES3 , editable: true , nullable: true , length: 50 )
• NOTES4 ( type: esriFieldTypeString , alias: NOTES4 , editable: true , nullable: true , length: 50 )
• SRVLNCLS ( type: esriFieldTypeString , alias: SRVLNCLS , editable: true , nullable: true , length: 50 )
• STATUS ( type: esriFieldTypeString , alias: STATUS , editable: true , nullable: true , length: 50 , Coded Values: [Both Complete: Both Complete] , [Customer Side Complete: Customer Side Complete] , [HSWA Side Complete: HSWA Side Complete] )
• SysBas2 ( type: esriFieldTypeString , alias: SysBas2 , editable: true , nullable: true , length: 50 , Coded Values: [A: Records review] , [B: Modeling/statistical analysis] , [C: Water sampling (no CCT)] , ...1 more... )
• CustBas2 ( type: esriFieldTypeString , alias: CustBas2 , editable: true , nullable: true , length: 50 , Coded Values: [A: Records review] , [B: Modeling/statistical analysis] , [C: Water sampling (no CCT)] , ...1 more... )
• ADDY1 ( type: esriFieldTypeString , alias: ADDY1 , editable: true , nullable: true , length: 50 )
• ADDY2 ( type: esriFieldTypeString , alias: ADDY2 , editable: true , nullable: true , length: 50 )
• CITY ( type: esriFieldTypeString , alias: CITY , editable: true , nullable: true , length: 50 )
• ZIP ( type: esriFieldTypeString , alias: ZIP , editable: true , nullable: true , length: 50 )
• SYSTEM ( type: esriFieldTypeString , alias: SYSTEM , editable: true , nullable: true , length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• Notification ( type: esriFieldTypeString , alias: Notification , editable: true , nullable: true , length: 100 )

Types:

ID: Both Complete
Name: Both Complete
Domains:
• InvType:
  Inherited
• OwnType:
  Inherited
• Sch:
  Inherited
• ChCare:
  Inherited
• SysMat:
  Inherited
• PrevLead:
  Inherited
• SysConn:
  Inherited
• SysInstl:
  Inherited
• SysBas1:
  Inherited
• SysVer:
  Inherited
• CustMat:
  Inherited
• CustConn:
  Inherited
• CusInstl:
  Inherited
• CustBas1:
  Inherited
• CustVer:
  Inherited
• SLConn:
  Inherited
• POE:
  Inherited
• Solder:
  Inherited
• LCR_Site:
  Inherited
• PRV:
  Inherited
• BACKFLOW:
  Inherited
• STATUS:
  Inherited
• SysBas2:
  Inherited
• CustBas2:
  Inherited
Templates:
• Name: Both Complete
  Description:
  Prototype:
  SYSTEM: null
  Notification: null
  OBJECTID: null
  SERVICEADD: null
  ACCOUNT_: null
  POINT_X: null
  POINT_Y: null
  ACCOUNTNUM: null
  ACCOUNTTYP: null
  InvType: null
  RplcDt: null
  OwnType: null
  SLAddr1: null
  Sch: null
  ChCare: null
  SysMat: null
  PrevLead: null
  SysConn: null
  SysInstl: null
  SysInstl2: null
  SLDiam: null
  SysBas1: null
  SysVer: null
  SysVerDt: null
  SysTxt: null
  CustMat: null
  CustConn: null
  CusInstl: null
  CustInstl2: null
  CustBas1: null
  CustVer: null
  CustVerDt: null
  CustTxt: null
  SLConn: null
  POE: null
  Solder: null
  LCR_Site: null
  DateStamp: null
  PRV: null
  BACKFLOW: null
  NOTES1: null
  NOTES2: null
  NOTES3: null
  NOTES4: null
  SRVLNCLS: null
  STATUS: Both Complete
  SysBas2: null
  CustBas2: null
  ADDY1: null
  ADDY2: null
  CITY: null
  ZIP: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Customer Side Complete
Name: Customer Side Complete
Domains:
• InvType:
  Inherited
• OwnType:
  Inherited
• Sch:
  Inherited
• ChCare:
  Inherited
• SysMat:
  Inherited
• PrevLead:
  Inherited
• SysConn:
  Inherited
• SysInstl:
  Inherited
• SysBas1:
  Inherited
• SysVer:
  Inherited
• CustMat:
  Inherited
• CustConn:
  Inherited
• CusInstl:
  Inherited
• CustBas1:
  Inherited
• CustVer:
  Inherited
• SLConn:
  Inherited
• POE:
  Inherited
• Solder:
  Inherited
• LCR_Site:
  Inherited
• PRV:
  Inherited
• BACKFLOW:
  Inherited
• STATUS:
  Inherited
• SysBas2:
  Inherited
• CustBas2:
  Inherited
Templates:
• Name: Customer Side Complete
  Description:
  Prototype:
  SYSTEM: null
  Notification: null
  OBJECTID: null
  SERVICEADD: null
  ACCOUNT_: null
  POINT_X: null
  POINT_Y: null
  ACCOUNTNUM: null
  ACCOUNTTYP: null
  InvType: null
  RplcDt: null
  OwnType: null
  SLAddr1: null
  Sch: null
  ChCare: null
  SysMat: null
  PrevLead: null
  SysConn: null
  SysInstl: null
  SysInstl2: null
  SLDiam: null
  SysBas1: null
  SysVer: null
  SysVerDt: null
  SysTxt: null
  CustMat: null
  CustConn: null
  CusInstl: null
  CustInstl2: null
  CustBas1: null
  CustVer: null
  CustVerDt: null
  CustTxt: null
  SLConn: null
  POE: null
  Solder: null
  LCR_Site: null
  DateStamp: null
  PRV: null
  BACKFLOW: null
  NOTES1: null
  NOTES2: null
  NOTES3: null
  NOTES4: null
  SRVLNCLS: null
  STATUS: Customer Side Complete
  SysBas2: null
  CustBas2: null
  ADDY1: null
  ADDY2: null
  CITY: null
  ZIP: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: HSWA Side Complete
Name: HSWA Side Complete
Domains:
• InvType:
  Inherited
• OwnType:
  Inherited
• Sch:
  Inherited
• ChCare:
  Inherited
• SysMat:
  Inherited
• PrevLead:
  Inherited
• SysConn:
  Inherited
• SysInstl:
  Inherited
• SysBas1:
  Inherited
• SysVer:
  Inherited
• CustMat:
  Inherited
• CustConn:
  Inherited
• CusInstl:
  Inherited
• CustBas1:
  Inherited
• CustVer:
  Inherited
• SLConn:
  Inherited
• POE:
  Inherited
• Solder:
  Inherited
• LCR_Site:
  Inherited
• PRV:
  Inherited
• BACKFLOW:
  Inherited
• STATUS:
  Inherited
• SysBas2:
  Inherited
• CustBas2:
  Inherited
Templates:
• Name: HSWA Side Complete
  Description:
  Prototype:
  SYSTEM: null
  Notification: null
  OBJECTID: null
  SERVICEADD: null
  ACCOUNT_: null
  POINT_X: null
  POINT_Y: null
  ACCOUNTNUM: null
  ACCOUNTTYP: null
  InvType: null
  RplcDt: null
  OwnType: null
  SLAddr1: null
  Sch: null
  ChCare: null
  SysMat: null
  PrevLead: null
  SysConn: null
  SysInstl: null
  SysInstl2: null
  SLDiam: null
  SysBas1: null
  SysVer: null
  SysVerDt: null
  SysTxt: null
  CustMat: null
  CustConn: null
  CusInstl: null
  CustInstl2: null
  CustBas1: null
  CustVer: null
  CustVerDt: null
  CustTxt: null
  SLConn: null
  POE: null
  Solder: null
  LCR_Site: null
  DateStamp: null
  PRV: null
  BACKFLOW: null
  NOTES1: null
  NOTES2: null
  NOTES3: null
  NOTES4: null
  SRVLNCLS: null
  STATUS: HSWA Side Complete
  SysBas2: null
  CustBas2: null
  ADDY1: null
  ADDY2: null
  CITY: null
  ZIP: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Create,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   Validate SQL   Generate Renderer   Return Updates