View In:   ArcGIS Online Map Viewer

Name: Lead Service Line Tracking

Display Field: address

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 149a69b710eb409f91382faa0886765f

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

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: 1536007.0082413107
YMin: 7157585.023495898
XMax: 4.0252801632896125E7
YMax: 1.9249010590268314E7
Spatial Reference: 102743  (3566)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: address )
• location ( type: esriFieldTypeString, alias: Other Location Identifier, editable: true, nullable: true, length: 256, defaultValue: null, modelName: location )
• sensitivepop ( type: esriFieldTypeString, alias: Sensitive Population, editable: true, nullable: true, length: 15, defaultValue: null, modelName: sensitivepop , Coded Values: [Yes - School: Yes - School] , [Yes - Day Care: Yes - Day Care] , [Yes - Other: Yes - Other] , ...1 more... )
• disadvantaged ( type: esriFieldTypeString, alias: Disadvantaged Neighborhood, editable: true, nullable: true, length: 15, defaultValue: null, modelName: disadvantaged , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• utilmaterial ( type: esriFieldTypeString, alias: City Service Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: utilmaterial , Coded Values: [Unknown - Material Unknown: Unknown - Material Unknown] , [Unknown - Likely Lead: Unknown - Likely Lead] , [Unknown - Unlikely Lead: Unknown - Unlikely Lead] , ...6 more... )
• everlead ( type: esriFieldTypeString, alias: Ever Lead?, editable: true, nullable: true, length: 15, defaultValue: null, modelName: everlead , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• utilinstalldate ( type: esriFieldTypeDate, alias: City Service Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: utilinstalldate )
• utildiameter ( type: esriFieldTypeDouble, alias: City Service Diameter, editable: true, nullable: true, defaultValue: null, modelName: utildiameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more... )
• utilsource ( type: esriFieldTypeString, alias: City Service 1st Point Verification Method, editable: true, nullable: true, length: 255, defaultValue: null, modelName: utilsource , Coded Values: [Visual inspection at meter pit: Visual inspection at meter pit] , [Installation record (e.g., tap card): Installation record (e.g., tap card)] , [Customer self-verification: Customer self-verification] , ...13 more... )
• utilverified ( type: esriFieldTypeString, alias: City Service Side Verified, editable: true, nullable: true, length: 255, defaultValue: null, modelName: utilverified , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• utilverifmethod ( type: esriFieldTypeString, alias: City Service 2nd Point Verification Method, editable: true, nullable: true, length: 100, defaultValue: null, modelName: utilverifmethod , Coded Values: [Installation Record: Installation Record] , [Visual inspection at meter pit: Visual inspection at meter pit] , [Customer self-identification: Customer self-identification] , ...6 more... )
• utilverifdate ( type: esriFieldTypeDate, alias: City Service 2nd Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: utilverifdate )
• utilnotes ( type: esriFieldTypeString, alias: City Service Side Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: utilnotes )
• custmaterial ( type: esriFieldTypeString, alias: Customer Service Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: custmaterial , Coded Values: [Unknown - Material Unknown: Unknown - Material Unknown] , [Unknown - Likely Lead: Unknown - Likely Lead] , [Unknown - Unlikely Lead: Unknown - Unlikely Lead] , ...6 more... )
• custinstalldate ( type: esriFieldTypeDate, alias: Customer Service Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custinstalldate )
• custdiameter ( type: esriFieldTypeDouble, alias: Customer Service Diameter, editable: true, nullable: true, defaultValue: null, modelName: custdiameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more... )
• custsource ( type: esriFieldTypeString, alias: Customer Service 1st Point Verification Method, editable: true, nullable: true, length: 255, defaultValue: null, modelName: custsource , Coded Values: [Visual inspection at meter pit: Visual inspection at meter pit] , [Installation record (e.g., tap card): Installation record (e.g., tap card)] , [Customer self-verification: Customer self-verification] , ...13 more... )
• custverified ( type: esriFieldTypeString, alias: Customer Service Side Verified, editable: true, nullable: true, length: 255, defaultValue: null, modelName: custverified , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• custverifmethod ( type: esriFieldTypeString, alias: Customer Service 2nd Point Verification Method, editable: true, nullable: true, length: 100, defaultValue: null, modelName: custverifmethod , Coded Values: [Visual Inspection: Visual Inspection] , [Lead Test Kit: Lead Test Kit] , [Plumbing Records: Plumbing Records] , ...2 more... )
• custverifdate ( type: esriFieldTypeDate, alias: Customer Service 2nd Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custverifdate )
• custnotes ( type: esriFieldTypeString, alias: Customer Service Side Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: custnotes )
• bothsidesstatus ( type: esriFieldTypeString, alias: Entire Service Line Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: bothsidesstatus , Coded Values: [Unknown: Unknown] , [Lead: Lead] , [Non-Lead: Non-Lead] , ...2 more... )
• leadconnector ( type: esriFieldTypeString, alias: Lead Connector, editable: true, nullable: true, length: 15, defaultValue: null, modelName: leadconnector , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• leadsolder ( type: esriFieldTypeString, alias: Lead Solder, editable: true, nullable: true, length: 15, defaultValue: null, modelName: leadsolder , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• otherfittings ( type: esriFieldTypeString, alias: Other Fittings Containing Lead, editable: true, nullable: true, length: 100, defaultValue: null, modelName: otherfittings )
• buildingtype ( type: esriFieldTypeString, alias: Building Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: buildingtype , Coded Values: [Single Family Residence: Single Family Residence] , [Multiple Family Residence: Multiple Family Residence] , [Building: Building] , ...3 more... )
• pointofentry ( type: esriFieldTypeString, alias: Point-of-Entry or Point-of-Use, editable: true, nullable: true, length: 15, defaultValue: null, modelName: pointofentry , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• copperwithlead ( type: esriFieldTypeString, alias: Copper Pipes with Lead Solder Before Lead Ban, editable: true, nullable: true, length: 15, defaultValue: null, modelName: copperwithlead , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• samplingsite ( type: esriFieldTypeString, alias: Current LCR Sampling Site, editable: true, nullable: true, length: 15, defaultValue: null, modelName: samplingsite , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• replacestatus ( type: esriFieldTypeString, alias: Replacement Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: replacestatus , Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement] , [Needs Replacement: Needs Replacement] , [Scheduled Replacement: Scheduled Replacement] , ...2 more... )
• scheddate ( type: esriFieldTypeDate, alias: City Side Scheduled Replacement Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: scheddate )
• utilreplacedate ( type: esriFieldTypeDate, alias: City Side Replacement Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: utilreplacedate )
• custscheddate ( type: esriFieldTypeDate, alias: Customer Side Scheduled Replacement Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custscheddate )
• custreplacedate ( type: esriFieldTypeDate, alias: Customer Side Replacement Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custreplacedate )
• replacereason ( type: esriFieldTypeString, alias: Reason for Replacement, editable: true, nullable: true, length: 255, defaultValue: null, modelName: replacereason , Coded Values: [Lead: Lead] , [Other: Other] )
• yearstructbuilt ( type: esriFieldTypeSmallInteger, alias: Year Structure Built, editable: true, nullable: true, defaultValue: null, modelName: yearstructbuilt )
• created_user ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user, required: true )
• created_date ( type: esriFieldTypeDate, alias: CreationDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ppmaterial ( type: esriFieldTypeString, alias: Premise Plumbing Material, editable: true, nullable: true, length: 256, defaultValue: null, modelName: ppmaterial , Coded Values: [Unknown - Material Unknown: Unknown - Material Unknown] , [Unknown - Likely Lead: Unknown - Likely Lead] , [Unknown - Unlikely Lead: Unknown - Unlikely Lead] , ...6 more... )
• ppinstalldate ( type: esriFieldTypeDate, alias: Premise Plumbing Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ppinstalldate )
• ppdiameter ( type: esriFieldTypeDouble, alias: Premise Plumbing Diameter, editable: true, nullable: true, defaultValue: null, modelName: ppdiameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more... )
• ppsource ( type: esriFieldTypeString, alias: Premise Plumbing Verification Method, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ppsource , Coded Values: [Visual Inspection: Visual Inspection] , [Lead Test Kit: Lead Test Kit] , [Plumbing Records: Plumbing Records] , ...2 more... )
• ppverified ( type: esriFieldTypeString, alias: Premise Plumbing Side Verified, editable: true, nullable: true, length: 256, defaultValue: null, modelName: ppverified , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• ppnotes ( type: esriFieldTypeString, alias: Premise Plumbing Side Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: ppnotes )
• utilstatus ( type: esriFieldTypeString, alias: City Service Status, editable: true, nullable: true, length: 100, defaultValue: null, modelName: utilstatus , Coded Values: [Unknown: Unknown] , [Lead: Lead] , [Non-Lead: Non-Lead] , ...2 more... )
• custstatus ( type: esriFieldTypeString, alias: Customer Service Status, editable: true, nullable: true, length: 100, defaultValue: null, modelName: custstatus , Coded Values: [Unknown: Unknown] , [Lead: Lead] , [Non-Lead: Non-Lead] , ...2 more... )
• ppstatus ( type: esriFieldTypeString, alias: Premise Plumbing Status, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ppstatus , Coded Values: [Unknown: Unknown] , [Lead: Lead] , [Non-Lead: Non-Lead] , ...2 more... )
• utilmaterialspecifics ( type: esriFieldTypeString, alias: City Material Specific Type of Plastic, editable: true, nullable: true, length: 50, defaultValue: null, modelName: utilmaterialspecifics , Coded Values: [PVC: PVC] , [HDPE: HDPE] , [Poly: Poly] , ...1 more... )
• custmaterialspecifics ( type: esriFieldTypeString, alias: Customer Material Specific Type of Plastic, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custmaterialspecifics , Coded Values: [PVC: PVC] , [HDPE: HDPE] , [Poly: Poly] , ...1 more... )
• ppmaterialspecifics ( type: esriFieldTypeString, alias: Premise Plumbing Material Specific Type of Plastic, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ppmaterialspecifics , Coded Values: [PVC: PVC] , [HDPE: HDPE] , [Poly: Poly] , ...1 more... )
• utilverifdate1 ( type: esriFieldTypeDate, alias: City Service 1st Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: utilverifdate1 )
• custverifdate1 ( type: esriFieldTypeDate, alias: Customer Service 1st Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custverifdate1 )
• ppverifdate1 ( type: esriFieldTypeDate, alias: Premise Plumbing 1st Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ppverifdate1 )
• RandNumSelector ( type: esriFieldTypeSmallInteger, alias: Random Number, editable: true, nullable: true, defaultValue: null, modelName: RandNumSelector )
• custnotification1 ( type: esriFieldTypeString, alias: 1st Customer Notification Method, editable: true, nullable: true, length: 100, defaultValue: null, modelName: custnotification1 , Coded Values: [Email: Email] , [Phone: Phone] , [Text: Text] , ...3 more... )
• custnotification1date ( type: esriFieldTypeDate, alias: 1st Customer Notification Method Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custnotification1date )
• custnotification2 ( type: esriFieldTypeString, alias: 2nd Customer Notification Method, editable: true, nullable: true, length: 100, defaultValue: null, modelName: custnotification2 , Coded Values: [Email: Email] , [Phone: Phone] , [Text: Text] , ...3 more... )
• custnotification2date ( type: esriFieldTypeDate, alias: 2nd Customer Notification Method Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custnotification2date )
• custnotification3 ( type: esriFieldTypeString, alias: 3rd Customer Notification Method, editable: true, nullable: true, length: 100, defaultValue: null, modelName: custnotification3 , Coded Values: [Email: Email] , [Phone: Phone] , [Text: Text] , ...3 more... )
• custnotification3date ( type: esriFieldTypeDate, alias: 3rd Customer Notification Method Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custnotification3date )
• custnotification4 ( type: esriFieldTypeString, alias: 4th Customer Notification Method, editable: true, nullable: true, length: 100, defaultValue: null, modelName: custnotification4 , Coded Values: [Email: Email] , [Phone: Phone] , [Text: Text] , ...3 more... )
• custnotification4date ( type: esriFieldTypeDate, alias: 4th Customer Notification Method Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custnotification4date )
• utilexcavatedetail ( type: esriFieldTypeString, alias: 1st Point City Excavation Location Details, editable: true, nullable: true, length: 255, defaultValue: null, modelName: utilexcavatedetail )
• custexcavatedetail ( type: esriFieldTypeString, alias: 1st Point Customer Excavation Location Details, editable: true, nullable: true, length: 255, defaultValue: null, modelName: custexcavatedetail )
• ppexcavatedetail ( type: esriFieldTypeString, alias: 1st Point Premise Plumbing Excavation Location Details, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ppexcavatedetail )
• utilexcavatedetail2 ( type: esriFieldTypeString, alias: 2nd Point City Excavation Location Details, editable: true, nullable: true, length: 255, defaultValue: null, modelName: utilexcavatedetail2 )
• custexcavatedetail2 ( type: esriFieldTypeString, alias: 2nd Point Customer Excavation Location Details, editable: true, nullable: true, length: 255, defaultValue: null, modelName: custexcavatedetail2 )
• YearStructureBuildMethod ( type: esriFieldTypeString, alias: Year Structure Built Method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YearStructureBuildMethod , Coded Values: [Aerial: Aerial] , [County Parcel: County Parcel] , [Final Plat: Final Plat] , ...2 more... )
• BuildingTypeDesc ( type: esriFieldTypeString, alias: Building Type Description for Other, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BuildingTypeDesc )

Templates:

• Name: Unknown | Unknown | Unknown
  Description:
  Prototype:
  ppnotes: null
  utilstatus: Unknown
  custstatus: Unknown
  YearStructureBuildMethod: null
  address: null
  location: null
  sensitivepop: null
  disadvantaged: null
  utilmaterial: null
  everlead: null
  utilinstalldate: null
  utildiameter: null
  utilsource: null
  utilverified: null
  utilverifmethod: null
  utilverifdate: null
  utilnotes: null
  custmaterial: null
  custinstalldate: null
  custdiameter: null
  custsource: null
  custverified: null
  custverifmethod: null
  custverifdate: null
  custnotes: null
  bothsidesstatus: null
  leadconnector: null
  leadsolder: null
  otherfittings: null
  buildingtype: null
  pointofentry: null
  copperwithlead: null
  samplingsite: null
  replacestatus: null
  scheddate: null
  utilreplacedate: null
  custscheddate: null
  custreplacedate: null
  replacereason: null
  yearstructbuilt: null
  custexcavatedetail2: null
  utilexcavatedetail2: null
  ppexcavatedetail: null
  custexcavatedetail: null
  BuildingTypeDesc: null
  ppmaterial: null
  ppinstalldate: null
  ppdiameter: null
  ppsource: null
  ppverified: null
  ppstatus: Unknown
  utilmaterialspecifics: null
  custmaterialspecifics: null
  ppmaterialspecifics: null
  utilverifdate1: null
  custverifdate1: null
  ppverifdate1: null
  RandNumSelector: null
  custnotification1: null
  custnotification1date: null
  custnotification2: null
  custnotification2date: null
  custnotification3: null
  custnotification3date: null
  custnotification4: null
  custnotification4date: null
  utilexcavatedetail: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports OidReservation: true

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

Supports Coordinates Quantization: true

Child Resources:

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