View In:   ArcGIS Online Map Viewer

Name: LCRR Service Connections

Display Field: CSTMR_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: eb4307ed53c04655960961a1251d3185

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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: -8916520.5629
YMin: 4288808.95275
XMax: 6634407.760200001
YMax: 8665554.418093937
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Lead | Galvanized Requiring Replacement
  Label: Lead | Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  
• Value: Lead | Lead
  Label: Lead | Lead
  Description: N/A
  Symbol:
  
• Value: Lead | Non-Lead
  Label: Lead | Non-Lead
  Description: N/A
  Symbol:
  
• Value: Lead | Unknown
  Label: Lead | Unknown
  Description: N/A
  Symbol:
  
• Value: Non-Lead | Galvanized Requiring Replacement
  Label: Non-Lead | Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  
• Value: Non-Lead | Lead
  Label: Non-Lead | Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead | Non-Lead
  Label: Non-Lead | Non-Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead | Unknown
  Label: Non-Lead | Unknown
  Description: N/A
  Symbol:
  
• Value: Unknown | Galvanized Requiring Replacement
  Label: Unknown | Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  
• Value: Unknown | Lead
  Label: Unknown | Lead
  Description: N/A
  Symbol:
  
• Value: Unknown | Non-Lead
  Label: Unknown | Non-Lead
  Description: N/A
  Symbol:
  
• Value: Unknown | Unknown
  Label: Unknown | Unknown
  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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_by ( type: esriFieldTypeString, alias: created_by, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_by )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_by ( type: esriFieldTypeString, alias: last_edited_by, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_by )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• EPA_ID ( type: esriFieldTypeString, alias: EPA Unique Identifier, editable: false, nullable: true, length: 255, defaultValue: null, modelName: EPA_ID )
• STRT_ADD ( type: esriFieldTypeString, alias: Street Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STRT_ADD )
• CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CITY )
• STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STATE )
• ZIP ( type: esriFieldTypeSmallInteger, alias: Zip Code (5-Digit), editable: true, nullable: true, defaultValue: null, modelName: ZIP )
• CSTMR_NAME ( type: esriFieldTypeString, alias: Customer Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CSTMR_NAME )
• CSTMR_EMAIL ( type: esriFieldTypeString, alias: Customer Email, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CSTMR_EMAIL )
• CSTMR_PHONE ( type: esriFieldTypeString, alias: Customer Phone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CSTMR_PHONE )
• SENS_POP ( type: esriFieldTypeString, alias: Sensitive Population?, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: SENS_POP , Coded Values: [Unknown: Unknown] , [No: No] , [Yes - School: Yes - School] , ...3 more... )
• DISADV_NGHBR ( type: esriFieldTypeString, alias: Disadvantaged Neighborhood?, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: DISADV_NGHBR , Coded Values: [Unknown: Unknown] , [No: No] , [Yes: Yes] )
• PUB_ASSETID ( type: esriFieldTypeString, alias: Public Assett ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PUB_ASSETID )
• PUB_MATERIAL ( type: esriFieldTypeString, alias: Public Material Classification, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: PUB_MATERIAL , Coded Values: [Unknown: Unknown] , [Lead: Lead] , [Galvanized: Galvanized] , ...6 more... )
• PUB_PREVLEAD ( type: esriFieldTypeString, alias: Public Previously Lead, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: PUB_PREVLEAD , Coded Values: [Unknown: Unknown] , [Yes: Yes] , [No: No] )
• PUB_INSTDATE ( type: esriFieldTypeDate, alias: Public Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PUB_INSTDATE )
• PUB_REPLDATE ( type: esriFieldTypeDate, alias: Public Replacement Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PUB_REPLDATE )
• PUB_REPSTATUS ( type: esriFieldTypeString, alias: Public Replacement Status, editable: false, nullable: true, length: 255, defaultValue: Unknown, modelName: PUB_REPSTATUS , Coded Values: [Unknown: Unknown] , [Potential: Potential] , [Required: Required] , ...2 more... )
• PUB_DIAM ( type: esriFieldTypeDouble, alias: Public Diameter, editable: true, nullable: true, defaultValue: -1, modelName: PUB_DIAM , Coded Values: [-1: Unknown] , [0: Unknown | < 2"] , [99: Unknown | > 2"] , ...27 more... )
• PUB_CLASSBASIS ( type: esriFieldTypeString, alias: Public Basis of Classification, editable: true, nullable: true, length: 255, defaultValue: Not Specified, modelName: PUB_CLASSBASIS , Coded Values: [Previous Materials Classification: Previous Materials Classification] , [Installation Record (e.g. tap card): Installation Record (e.g. tap card)] , [Installation date after lead ban: Installation date after lead ban] , ...8 more... )
• PUB_FLDVERSTATUS ( type: esriFieldTypeString, alias: Public Field Verification Status, editable: true, nullable: true, length: 255, defaultValue: Not Specified, modelName: PUB_FLDVERSTATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Completed: Completed] , ...3 more... )
• PUB_FLDVERMETHOD ( type: esriFieldTypeString, alias: Public Field Verification Method, editable: true, nullable: true, length: 255, defaultValue: Not Specified, modelName: PUB_FLDVERMETHOD , Coded Values: [Customer self-identification: Customer self-identification] , [CCTV investigation at curb stop - internal: CCTV investigation at curb stop - internal] , [CCTV investigation at curb stop - external: CCTV investigation at curb stop - external] , ...7 more... )
• PUB_FLDVERDATE ( type: esriFieldTypeDate, alias: Public Field Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PUB_FLDVERDATE )
• PUB_NOTES ( type: esriFieldTypeString, alias: Public General Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PUB_NOTES )
• PUB_LEADSTATUS ( type: esriFieldTypeString, alias: Public Lead Status, editable: false, nullable: true, length: 255, defaultValue: Unknown, modelName: PUB_LEADSTATUS , Coded Values: [Lead: Lead] , [Non-Lead: Non-Lead] , [Unknown: Unknown] )
• PRI_ASSETID ( type: esriFieldTypeString, alias: Private Account ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRI_ASSETID )
• PRI_MATERIAL ( type: esriFieldTypeString, alias: Private Material Classification, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: PRI_MATERIAL , Coded Values: [Unknown: Unknown] , [Lead: Lead] , [Galvanized: Galvanized] , ...6 more... )
• PRI_INSTDATE ( type: esriFieldTypeDate, alias: Private Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PRI_INSTDATE )
• PRI_REPLDATE ( type: esriFieldTypeDate, alias: Private Replacement Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PRI_REPLDATE )
• PRI_REPLNOTIFDATE ( type: esriFieldTypeDate, alias: Private Customer Reported Replacement Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PRI_REPLNOTIFDATE )
• PRI_REPSTATUS ( type: esriFieldTypeString, alias: Private Replacement Status, editable: false, nullable: true, length: 255, defaultValue: Unknown, modelName: PRI_REPSTATUS , Coded Values: [Unknown: Unknown] , [Potential: Potential] , [Required: Required] , ...3 more... )
• PRI_DIAM ( type: esriFieldTypeDouble, alias: Private Diameter, editable: true, nullable: true, defaultValue: -1, modelName: PRI_DIAM , Coded Values: [-1: Unknown] , [0: Unknown | < 2"] , [99: Unknown | > 2"] , ...27 more... )
• PRI_CLASSBASIS ( type: esriFieldTypeString, alias: Private Basis of Classification, editable: true, nullable: true, length: 255, defaultValue: Not Specified, modelName: PRI_CLASSBASIS , Coded Values: [Previous Materials Classification: Previous Materials Classification] , [Installation Record (e.g. tap card): Installation Record (e.g. tap card)] , [Installation date after lead ban: Installation date after lead ban] , ...8 more... )
• PRI_FLDVERSTATUS ( type: esriFieldTypeString, alias: Private Field Verification Status, editable: true, nullable: true, length: 255, defaultValue: Not Specified, modelName: PRI_FLDVERSTATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Completed: Completed] , ...3 more... )
• PRI_FLDVERMETHOD ( type: esriFieldTypeString, alias: Private Field Verification Method, editable: true, nullable: true, length: 255, defaultValue: Not Specified, modelName: PRI_FLDVERMETHOD , Coded Values: [Customer self-identification: Customer self-identification] , [CCTV investigation at curb stop - internal: CCTV investigation at curb stop - internal] , [CCTV investigation at curb stop - external: CCTV investigation at curb stop - external] , ...7 more... )
• PRI_FLDVERDATE ( type: esriFieldTypeDate, alias: Private Field Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PRI_FLDVERDATE )
• PRI_NOTES ( type: esriFieldTypeString, alias: Private General Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRI_NOTES )
• PRI_LEADSTATUS ( type: esriFieldTypeString, alias: Private Lead Status, editable: false, nullable: true, length: 255, defaultValue: Unknown, modelName: PRI_LEADSTATUS , Coded Values: [Lead: Lead] , [Non-Lead: Non-Lead] , [Galvanized Requiring Replacement: Galvanized Requiring Replacement] , ...1 more... )
• FULL_LEADSTATUS ( type: esriFieldTypeString, alias: Full Line Lead Status, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: FULL_LEADSTATUS , Coded Values: [Lead: Lead] , [Non-Lead: Non-Lead] , [Galvanized Requiring Replacement: Galvanized Requiring Replacement] , ...1 more... )
• LEADCONNECTOR ( type: esriFieldTypeString, alias: Lead Connector Status, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: LEADCONNECTOR , Coded Values: [Unknown: Unknown] , [Removed: Removed] , [Not Present: Not Present] , ...1 more... )
• LEADSOLDER ( type: esriFieldTypeString, alias: Lead Solder Status, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: LEADSOLDER , Coded Values: [Unknown: Unknown] , [No: No] , [Yes: Yes] )
• OTHRFITTINGS ( type: esriFieldTypeString, alias: Describe Other Lead Fittings/Equipment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTHRFITTINGS )
• SRVC_TYPE ( type: esriFieldTypeString, alias: Facility Type Serviced, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: SRVC_TYPE , Coded Values: [Single Family Residence: Single Family Residence] , [Muliple Family Residence: Muliple Family Residence] , [School/Childcare Facility: School/Childcare Facility] , ...5 more... )
• PNT_TRTMNT ( type: esriFieldTypeString, alias: Point-of-Entry or Point-of-Use Treatment, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: PNT_TRTMNT , Coded Values: [Unknown: Unknown] , [Yes: Yes] , [No: No] )
• INTERIORPLUMBING ( type: esriFieldTypeString, alias: Interior Pre-Ban Copper w/Lead Solder, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: INTERIORPLUMBING , Coded Values: [Unknown: Unknown] , [Yes: Yes] , [No: No] )
• CURRNT_SAMPL_STE ( type: esriFieldTypeString, alias: Current Compliance Sampling Site?, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: CURRNT_SAMPL_STE , Coded Values: [Unknown: Unknown] , [Yes: Yes] , [No: No] )
• NRST_PRCL_DTE ( type: esriFieldTypeDate, alias: Nearest Parcel Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NRST_PRCL_DTE )
• NRST_MAIN_DTE ( type: esriFieldTypeDate, alias: Nearest Main Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NRST_MAIN_DTE )
• PUB_PREDICTED_MAT ( type: esriFieldTypeString, alias: PUB_PREDICTED_MAT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PUB_PREDICTED_MAT )
• PUB_PREDICTED_PROB ( type: esriFieldTypeDouble, alias: PUB_PREDICTED_PROB, editable: true, nullable: true, defaultValue: null, modelName: PUB_PREDICTED_PROB )
• PRI_PREDICTED_MAT ( type: esriFieldTypeString, alias: PRI_PREDICTED_MAT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRI_PREDICTED_MAT )
• PRI_PREDICTED_PROB ( type: esriFieldTypeDouble, alias: PRI_PREDICTED_PROB, editable: true, nullable: true, defaultValue: null, modelName: PRI_PREDICTED_PROB )
• FULL_PREDICTED_MAT ( type: esriFieldTypeString, alias: FULL_PREDICTED_MAT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FULL_PREDICTED_MAT )
• PUB_EPA_PRED_MAT ( type: esriFieldTypeString, alias: PUB_EPA_PRED_MAT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PUB_EPA_PRED_MAT )
• PUB_NC_PRED_MAT ( type: esriFieldTypeString, alias: PUB_NC_PRED_MAT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PUB_NC_PRED_MAT )
• PRI_NC_PRED_MAT ( type: esriFieldTypeString, alias: PRI_NC_PRED_MAT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRI_NC_PRED_MAT )
• PRI_EPA_PRED_MAT ( type: esriFieldTypeString, alias: PRI_EPA_PRED_MAT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRI_EPA_PRED_MAT )

Templates:

• Name: LCRR Service Connections
  Description:
  Prototype:
  PRI_NC_PRED_MAT: null
  PUB_NC_PRED_MAT: null
  PRI_EPA_PRED_MAT: null
  PUB_EPA_PRED_MAT: null
  FULL_PREDICTED_MAT: null
  PRI_PREDICTED_PROB: null
  PRI_PREDICTED_MAT: null
  PUB_PREDICTED_PROB: null
  STRT_ADD: null
  CITY: null
  STATE: null
  ZIP: null
  CSTMR_NAME: null
  CSTMR_EMAIL: null
  CSTMR_PHONE: null
  SENS_POP: Unknown
  DISADV_NGHBR: Unknown
  PUB_ASSETID: null
  PUB_MATERIAL: Unknown
  PUB_PREVLEAD: Unknown
  PUB_INSTDATE: null
  PUB_REPLDATE: null
  PUB_PREDICTED_MAT: null
  PUB_DIAM: -1
  PUB_CLASSBASIS: Not Specified
  PUB_FLDVERSTATUS: Not Specified
  PUB_FLDVERMETHOD: Not Specified
  PUB_FLDVERDATE: null
  PUB_NOTES: null
  NRST_MAIN_DTE: null
  PRI_ASSETID: null
  PRI_MATERIAL: Unknown
  PRI_INSTDATE: null
  PRI_REPLDATE: null
  PRI_REPLNOTIFDATE: null
  NRST_PRCL_DTE: null
  PRI_DIAM: -1
  PRI_CLASSBASIS: Not Specified
  PRI_FLDVERSTATUS: Not Specified
  PRI_FLDVERMETHOD: Not Specified
  PRI_FLDVERDATE: null
  PRI_NOTES: null
  CURRNT_SAMPL_STE: Unknown
  FULL_LEADSTATUS: Unknown
  LEADCONNECTOR: Unknown
  LEADSOLDER: Unknown
  OTHRFITTINGS: null
  SRVC_TYPE: Unknown
  PNT_TRTMNT: Unknown
  INTERIORPLUMBING: Unknown
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• to related records (0) -- Related To: Field Incident Coordination (3)
• to related records (1) -- Related To: Compliance Sampling (2)
• to related records (2) -- Related To: Post-Replacement Sampling (7)
• to related records (3) -- Related To: Field Verification Coordination (4)
• to related records (4) -- Related To: Replacement Coordination (8)
• to related records (5) -- Related To: Flushing Coordination (5)
• to related records (6) -- Related To: Sample Kit Coordination (9)
• to related records (7) -- Related To: Pitcher Filter Coordination (6)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_by
• Edit Date Field: last_edited_date
• Editor Field: last_edited_by

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata