View In:   ArcGIS Online Map Viewer

Name: Lead & Copper - Address Point

Display Field: SocketID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 24000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: -8939270.445848973
YMin: 3003130.99632654
XMax: -8926079.760439089
YMax: 3011085.3108667876
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ProjRevStat
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Not Started
  Label: Not Started
  Description:
  Symbol:
  
• Value: In Progress
  Label: In Progress
  Description:
  Symbol:
  
• Value: Completed
  Label: Completed
  Description:
  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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ProjRevStat

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• UTLNotes ( type: esriFieldTypeString, alias: UTL Notes, editable: true, nullable: true, length: 15, defaultValue: null, modelName: UTLNotes )
• SocketID ( type: esriFieldTypeString, alias: Socket ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SocketID )
• FullAddress ( type: esriFieldTypeString, alias: Full Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FullAddress )
• Apt ( type: esriFieldTypeString, alias: Apt, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Apt )
• SensitivePop ( type: esriFieldTypeString, alias: Sensitive Population?, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SensitivePop , Coded Values: [No: No] , [Yes - School: Yes - School] , [Yes - Day Care: Yes - Day Care] , ...2 more... )
• DisadvNbhd ( type: esriFieldTypeString, alias: Disadvantaged Neighborhood?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DisadvNbhd , Coded Values: [Yes: Yes] , [No: No] )
• SysOwnSvcLinMat ( type: esriFieldTypeString, alias: System-Owned Portion Service Line Material, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SysOwnSvcLinMat , Coded Values: [Lead: Lead] , [Galvanized: Galvanized] , [Non-Lead - Copper: Non-Lead - Copper] , ...7 more... )
• FormerlyLead1 ( type: esriFieldTypeString, alias: System Svc Line: Previously Lead?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FormerlyLead1 )
• InstallYear1 ( type: esriFieldTypeSmallInteger, alias: System Svc Line: Install Year, editable: true, nullable: true, defaultValue: null, modelName: InstallYear1 )
• SvcLineSize1 ( type: esriFieldTypeString, alias: System Svc Line: Size, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SvcLineSize1 , Coded Values: [0.625: 5/8"] , [0.75: 3/4"] , [1: 1"] , ...10 more... )
• OTHERCONNECTOR1 ( type: esriFieldTypeString, alias: System-Other: Is there Lead Connector?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OTHERCONNECTOR1 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• OTHERCONNMAT1 ( type: esriFieldTypeString, alias: System-Other: Connector Material Type (Not exceeding 2 feet), editable: true, nullable: true, length: 10, defaultValue: null, modelName: OTHERCONNMAT1 , Coded Values: [Lead: Lead] , [Brass: Brass] , [Copper: Copper] , ...1 more... )
• LEADSOLDER1 ( type: esriFieldTypeString, alias: System-Other: Is there Lead Solder?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEADSOLDER1 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• OTHERLEAD1 ( type: esriFieldTypeString, alias: System-Other: Fittings and Equip that Contain Lead, editable: true, nullable: true, length: 250, defaultValue: null, modelName: OTHERLEAD1 )
• MatClassBasis1 ( type: esriFieldTypeString, alias: System Svc Line: Basis of Material Class, editable: true, nullable: true, length: 45, defaultValue: null, modelName: MatClassBasis1 , Coded Values: [Install record (eg. tap card): Install record (eg. tap card)] , [Installation date after lead ban: Installation date after lead ban] , [Service line diameter is > 2 inches: Service line diameter is > 2 inches] , ...5 more... )
• FieldVerified1 ( type: esriFieldTypeString, alias: System: Material Field Verified?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FieldVerified1 , Coded Values: [Yes: Yes] , [No: No] )
• FieldMethod1 ( type: esriFieldTypeString, alias: System: Field Verification Method, editable: true, nullable: true, length: 45, defaultValue: null, modelName: FieldMethod1 , 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] , ...5 more... )
• FieldDate1 ( type: esriFieldTypeDate, alias: System: Field Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FieldDate1 )
• Notes1 ( type: esriFieldTypeString, alias: System Svc Line: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes1 )
• CustOwnSvcLinMat ( type: esriFieldTypeString, alias: Customer-Owned Portion Service Line Material, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CustOwnSvcLinMat , Coded Values: [Lead: Lead] , [Galvanized: Galvanized] , [Non-Lead - Copper: Non-Lead - Copper] , ...7 more... )
• InstallYear2 ( type: esriFieldTypeSmallInteger, alias: Customer Svc Line: Install Year, editable: true, nullable: true, defaultValue: null, modelName: InstallYear2 )
• SvcLineSize2 ( type: esriFieldTypeString, alias: Customer Svc Line: Size, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SvcLineSize2 , Coded Values: [0.625: 5/8"] , [0.75: 3/4"] , [1: 1"] , ...10 more... )
• OTHERCONNECTOR2 ( type: esriFieldTypeString, alias: Customer-Other: Is there Lead Connector?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OTHERCONNECTOR2 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• OTHERCONNMAT2 ( type: esriFieldTypeString, alias: Customer-Other: Connector Material Type (Not exceeding 2 feet), editable: true, nullable: true, length: 10, defaultValue: null, modelName: OTHERCONNMAT2 , Coded Values: [Lead: Lead] , [Brass: Brass] , [Copper: Copper] , ...1 more... )
• LEADSOLDER2 ( type: esriFieldTypeString, alias: Customer-Other: Is there Lead Solder?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LEADSOLDER2 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• OTHERLEAD2 ( type: esriFieldTypeString, alias: Customer-Other: Fittings and Equip that Contain Lead, editable: true, nullable: true, length: 250, defaultValue: null, modelName: OTHERLEAD2 )
• MatClassBasis2 ( type: esriFieldTypeString, alias: Customer Svc Line: Basis of Material Class, editable: true, nullable: true, length: 45, defaultValue: null, modelName: MatClassBasis2 , Coded Values: [Install record (eg. tap card): Install record (eg. tap card)] , [Installation date after lead ban: Installation date after lead ban] , [Service line diameter is > 2 inches: Service line diameter is > 2 inches] , ...5 more... )
• FieldVerified2 ( type: esriFieldTypeString, alias: Customer: Material Field Verified?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FieldVerified2 , Coded Values: [Yes: Yes] , [No: No] )
• FieldMethod2 ( type: esriFieldTypeString, alias: Customer: Field Verification Method, editable: true, nullable: true, length: 45, defaultValue: null, modelName: FieldMethod2 , 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] , ...5 more... )
• FieldDate2 ( type: esriFieldTypeDate, alias: Customer: Field Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FieldDate2 )
• Notes2 ( type: esriFieldTypeString, alias: Customer Svc Line: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes2 )
• EntireSvcLinMat ( type: esriFieldTypeString, alias: Entire Svc Line Material Class, editable: true, nullable: true, length: 35, defaultValue: null, modelName: EntireSvcLinMat , Coded Values: [Lead: Lead] , [Galvanized Requiring Replacement: Galvanized Requiring Replacement] , [Non-Lead: Non-Lead] , ...1 more... )
• BuildingType ( type: esriFieldTypeString, alias: Building Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BuildingType , Coded Values: [Single Family Residence: Single Family Residence] , [Multiple Family Residence: Multiple Family Residence] , [Mixed Use: Mixed Use] , ...2 more... )
• TEIRTYPE ( type: esriFieldTypeString, alias: Tier Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TEIRTYPE , Coded Values: [Teir 1: Teir 1] , [Teir 2: Teir 2] , [Teir 3: Teir 3] , ...2 more... )
• PointOfUseTreatment ( type: esriFieldTypeString, alias: Point-of-Entry or Point-of-Use Treatment?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PointOfUseTreatment , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• InteriorCopperLeadSolder ( type: esriFieldTypeString, alias: Interior Copper Pipes with Lead Solder?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InteriorCopperLeadSolder , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• LCRSamplingSite ( type: esriFieldTypeString, alias: Current LCR Sampling Site?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LCRSamplingSite , Coded Values: [Yes: Yes] , [No: No] )
• SysOwnLSLRDate ( type: esriFieldTypeDate, alias: Date of System-Owned LSLR, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SysOwnLSLRDate )
• CustOwnLSLRDate ( type: esriFieldTypeDate, alias: Date of Customer-Owned LSLR, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CustOwnLSLRDate )
• Folio ( type: esriFieldTypeString, alias: Parcel Folio, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Folio )
• YearBuilt ( type: esriFieldTypeSmallInteger, alias: BCPA Year Built, editable: true, nullable: true, defaultValue: null, modelName: YearBuilt )
• ReplaceStatus1 ( type: esriFieldTypeString, alias: Replacement Status: System-Owned, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ReplaceStatus1 , Coded Values: [Planned: Planned] , [Completed: Completed] )
• ReplaceStatus2 ( type: esriFieldTypeString, alias: Replacement Status: Customer-Owned, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ReplaceStatus2 , Coded Values: [Offer Made: Offer Made] , [Planned: Planned] , [Completed: Completed] )
• ReplaceItem ( type: esriFieldTypeString, alias: Replacement Item, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ReplaceItem , Coded Values: [Curb Stop: Curb Stop] , [Corp Stop: Corp Stop] , [Svc Line - Customer Side: Svc Line - Customer Side] , ...2 more... )
• ReplaceMaterial ( type: esriFieldTypeString, alias: ReplaceMaterial, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ReplaceMaterial )
• ReplaceDate ( type: esriFieldTypeDate, alias: ReplaceDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ReplaceDate )
• ProjRevStat ( type: esriFieldTypeString, alias: Project Review Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ProjRevStat , Coded Values: [Not Started: Not Started] , [In Progress: In Progress] , [Completed: Completed] )
• UTLComments ( type: esriFieldTypeString, alias: UTL Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: UTLComments )
• Issue ( type: esriFieldTypeString, alias: Issue, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Issue )
• Match ( type: esriFieldTypeString, alias: Match, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Match )
• Neighborhood ( type: esriFieldTypeString, alias: Neighborhood Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Neighborhood )
• CREATOR ( type: esriFieldTypeString, alias: CREATOR, editable: false, nullable: true, length: 128, defaultValue: null, modelName: CREATOR )
• CREATIONDATE ( type: esriFieldTypeDate, alias: CREATIONDATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATIONDATE )
• EDITOR ( type: esriFieldTypeString, alias: EDITOR, editable: false, nullable: true, length: 128, defaultValue: null, modelName: EDITOR )
• EDITDATE ( type: esriFieldTypeDate, alias: EDITDATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EDITDATE )

Types:

ID: Not Started
Name: Not Started
Domains:
• SensitivePop:
  Inherited
• DisadvNbhd:
  Inherited
• SysOwnSvcLinMat:
  Inherited
• SvcLineSize1:
  Inherited
• OTHERCONNECTOR1:
  Inherited
• OTHERCONNMAT1:
  Inherited
• LEADSOLDER1:
  Inherited
• MatClassBasis1:
  Inherited
• FieldVerified1:
  Inherited
• FieldMethod1:
  Inherited
• CustOwnSvcLinMat:
  Inherited
• SvcLineSize2:
  Inherited
• OTHERCONNECTOR2:
  Inherited
• OTHERCONNMAT2:
  Inherited
• LEADSOLDER2:
  Inherited
• MatClassBasis2:
  Inherited
• FieldVerified2:
  Inherited
• FieldMethod2:
  Inherited
• EntireSvcLinMat:
  Inherited
• BuildingType:
  Inherited
• TEIRTYPE:
  Inherited
• PointOfUseTreatment:
  Inherited
• InteriorCopperLeadSolder:
  Inherited
• LCRSamplingSite:
  Inherited
• ReplaceStatus1:
  Inherited
• ReplaceStatus2:
  Inherited
• ReplaceItem:
  Inherited
• ProjRevStat:
  Inherited
Templates:
• Name: Not Started
  Description:
  Prototype:
  ReplaceDate: null
  Neighborhood: null
  UTLNotes: null
  SocketID: null
  FullAddress: null
  Apt: null
  SensitivePop: null
  DisadvNbhd: null
  SysOwnSvcLinMat: null
  FormerlyLead1: null
  InstallYear1: null
  SvcLineSize1: null
  OTHERCONNECTOR1: null
  OTHERCONNMAT1: null
  LEADSOLDER1: null
  OTHERLEAD1: null
  MatClassBasis1: null
  FieldVerified1: null
  FieldMethod1: null
  FieldDate1: null
  Notes1: null
  CustOwnSvcLinMat: null
  InstallYear2: null
  SvcLineSize2: null
  OTHERCONNECTOR2: null
  OTHERCONNMAT2: null
  LEADSOLDER2: null
  OTHERLEAD2: null
  MatClassBasis2: null
  FieldVerified2: null
  FieldMethod2: null
  FieldDate2: null
  Notes2: null
  EntireSvcLinMat: null
  BuildingType: null
  TEIRTYPE: null
  PointOfUseTreatment: null
  InteriorCopperLeadSolder: null
  LCRSamplingSite: null
  SysOwnLSLRDate: null
  CustOwnLSLRDate: null
  Folio: null
  YearBuilt: null
  ReplaceStatus1: null
  ReplaceStatus2: null
  ReplaceItem: null
  ReplaceMaterial: null
  ProjRevStat: Not Started
  UTLComments: null
  Issue: null
  Match: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: In Progress
Name: In Progress
Domains:
• SensitivePop:
  Inherited
• DisadvNbhd:
  Inherited
• SysOwnSvcLinMat:
  Inherited
• SvcLineSize1:
  Inherited
• OTHERCONNECTOR1:
  Inherited
• OTHERCONNMAT1:
  Inherited
• LEADSOLDER1:
  Inherited
• MatClassBasis1:
  Inherited
• FieldVerified1:
  Inherited
• FieldMethod1:
  Inherited
• CustOwnSvcLinMat:
  Inherited
• SvcLineSize2:
  Inherited
• OTHERCONNECTOR2:
  Inherited
• OTHERCONNMAT2:
  Inherited
• LEADSOLDER2:
  Inherited
• MatClassBasis2:
  Inherited
• FieldVerified2:
  Inherited
• FieldMethod2:
  Inherited
• EntireSvcLinMat:
  Inherited
• BuildingType:
  Inherited
• TEIRTYPE:
  Inherited
• PointOfUseTreatment:
  Inherited
• InteriorCopperLeadSolder:
  Inherited
• LCRSamplingSite:
  Inherited
• ReplaceStatus1:
  Inherited
• ReplaceStatus2:
  Inherited
• ReplaceItem:
  Inherited
• ProjRevStat:
  Inherited
Templates:
• Name: In Progress
  Description:
  Prototype:
  ReplaceDate: null
  Neighborhood: null
  UTLNotes: null
  SocketID: null
  FullAddress: null
  Apt: null
  SensitivePop: null
  DisadvNbhd: null
  SysOwnSvcLinMat: null
  FormerlyLead1: null
  InstallYear1: null
  SvcLineSize1: null
  OTHERCONNECTOR1: null
  OTHERCONNMAT1: null
  LEADSOLDER1: null
  OTHERLEAD1: null
  MatClassBasis1: null
  FieldVerified1: null
  FieldMethod1: null
  FieldDate1: null
  Notes1: null
  CustOwnSvcLinMat: null
  InstallYear2: null
  SvcLineSize2: null
  OTHERCONNECTOR2: null
  OTHERCONNMAT2: null
  LEADSOLDER2: null
  OTHERLEAD2: null
  MatClassBasis2: null
  FieldVerified2: null
  FieldMethod2: null
  FieldDate2: null
  Notes2: null
  EntireSvcLinMat: null
  BuildingType: null
  TEIRTYPE: null
  PointOfUseTreatment: null
  InteriorCopperLeadSolder: null
  LCRSamplingSite: null
  SysOwnLSLRDate: null
  CustOwnLSLRDate: null
  Folio: null
  YearBuilt: null
  ReplaceStatus1: null
  ReplaceStatus2: null
  ReplaceItem: null
  ReplaceMaterial: null
  ProjRevStat: In Progress
  UTLComments: null
  Issue: null
  Match: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Completed
Name: Completed
Domains:
• SensitivePop:
  Inherited
• DisadvNbhd:
  Inherited
• SysOwnSvcLinMat:
  Inherited
• SvcLineSize1:
  Inherited
• OTHERCONNECTOR1:
  Inherited
• OTHERCONNMAT1:
  Inherited
• LEADSOLDER1:
  Inherited
• MatClassBasis1:
  Inherited
• FieldVerified1:
  Inherited
• FieldMethod1:
  Inherited
• CustOwnSvcLinMat:
  Inherited
• SvcLineSize2:
  Inherited
• OTHERCONNECTOR2:
  Inherited
• OTHERCONNMAT2:
  Inherited
• LEADSOLDER2:
  Inherited
• MatClassBasis2:
  Inherited
• FieldVerified2:
  Inherited
• FieldMethod2:
  Inherited
• EntireSvcLinMat:
  Inherited
• BuildingType:
  Inherited
• TEIRTYPE:
  Inherited
• PointOfUseTreatment:
  Inherited
• InteriorCopperLeadSolder:
  Inherited
• LCRSamplingSite:
  Inherited
• ReplaceStatus1:
  Inherited
• ReplaceStatus2:
  Inherited
• ReplaceItem:
  Inherited
• ProjRevStat:
  Inherited
Templates:
• Name: Completed
  Description:
  Prototype:
  ReplaceDate: null
  Neighborhood: null
  UTLNotes: null
  SocketID: null
  FullAddress: null
  Apt: null
  SensitivePop: null
  DisadvNbhd: null
  SysOwnSvcLinMat: null
  FormerlyLead1: null
  InstallYear1: null
  SvcLineSize1: null
  OTHERCONNECTOR1: null
  OTHERCONNMAT1: null
  LEADSOLDER1: null
  OTHERLEAD1: null
  MatClassBasis1: null
  FieldVerified1: null
  FieldMethod1: null
  FieldDate1: null
  Notes1: null
  CustOwnSvcLinMat: null
  InstallYear2: null
  SvcLineSize2: null
  OTHERCONNECTOR2: null
  OTHERCONNMAT2: null
  LEADSOLDER2: null
  OTHERLEAD2: null
  MatClassBasis2: null
  FieldVerified2: null
  FieldMethod2: null
  FieldDate2: null
  Notes2: null
  EntireSvcLinMat: null
  BuildingType: null
  TEIRTYPE: null
  PointOfUseTreatment: null
  InteriorCopperLeadSolder: null
  LCRSamplingSite: null
  SysOwnLSLRDate: null
  CustOwnLSLRDate: null
  Folio: null
  YearBuilt: null
  ReplaceStatus1: null
  ReplaceStatus2: null
  ReplaceItem: null
  ReplaceMaterial: null
  ProjRevStat: Completed
  UTLComments: null
  Issue: null
  Match: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

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: CREATIONDATE
• Creator Field: CREATOR
• Edit Date Field: EDITDATE
• Editor Field: EDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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