View In:   ArcGIS Online Map Viewer

Name: Service Line Points

Display Field: custname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: dad7caeca8894de59f50286348571c0c

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 2485332.9381545484
YMin: 363539.1098151505
XMax: 2516068.511197716
YMax: 400848.7359831482
Spatial Reference: 2930  (2930)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Symbology
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: LL
  Label: Private Side Lead | City Side Lead
  Description: N/A
  Symbol:
  
• Value: LN
  Label: Private Side Lead | City Side Non-Lead
  Description: N/A
  Symbol:
  
• Value: NL
  Label: Private Side Non-Lead | City Side Lead
  Description: N/A
  Symbol:
  
• Value: NN
  Label: Private Side Non-Lead | Private Side Non-Lead
  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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Symbology

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSETWORKS_ID ( type: esriFieldTypeString, alias: Asset Works ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETWORKS_ID )
• utilassetid ( type: esriFieldTypeString, alias: Utility Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: utilassetid )
• utilmaterial ( type: esriFieldTypeString, alias: Utility Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: utilmaterial , Coded Values: [L: Lead] , [C: Copper] , [HDPE: HDPE] , ...12 more... )
• utildiameter ( type: esriFieldTypeDouble, alias: Utility Diameter, editable: true, nullable: true, defaultValue: null, modelName: utildiameter , Coded Values: [0.5: 1/2"] , [0.625: 5/8"] , [0.75: 3/4"] , ...10 more... )
• utilinstalldate ( type: esriFieldTypeDate, alias: Utility Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: utilinstalldate )
• utilverified ( type: esriFieldTypeString, alias: Utility Side Verified, editable: true, nullable: true, length: 50, defaultValue: null, modelName: utilverified , Coded Values: [Yes: Yes] , [No: No] )
• utilreplace ( type: esriFieldTypeString, alias: Utility Replacement Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: utilreplace , Coded Values: [DNR: Doesn't Need Replacement] , [NR: Needs Replacement] , [SR: Scheduled Replacement] , ...1 more... )
• utilscheddate ( type: esriFieldTypeDate, alias: Utility Scheduled Replacement Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: utilscheddate )
• utilsource ( type: esriFieldTypeString, alias: Utility Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: utilsource , Coded Values: [Previous eval: Previous Materials Evaluation] , [Installation record: Installation record (e.g., tap card)] , [Installed after lead ban: Installation date after lead ban (1986)] , ...6 more... )
• utilstatus ( type: esriFieldTypeString, alias: Utility Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: utilstatus , Coded Values: [Unknown: Unknown] , [Lead: Lead] , [Non-Lead: Non-Lead] , ...1 more... )
• utilreason ( type: esriFieldTypeString, alias: Utility Reason for Replacement, editable: true, nullable: true, length: 50, defaultValue: null, modelName: utilreason , Coded Values: [L: Lead] , [O: Other] )
• custassetid ( type: esriFieldTypeString, alias: Customer Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custassetid )
• custmaterial ( type: esriFieldTypeString, alias: Customer Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custmaterial , Coded Values: [L: Lead] , [C: Copper] , [HDPE: HDPE] , ...12 more... )
• Symbology ( type: esriFieldTypeString, alias: Symbology, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Symbology , Coded Values: [LL: Lead | Lead] , [LG: Lead | Galvanized Requiring Replacement] , [LN: Lead | Non-Lead] , ...13 more... )
• custdiameter ( type: esriFieldTypeDouble, alias: Customer Diameter, editable: true, nullable: true, defaultValue: null, modelName: custdiameter , Coded Values: [0.5: 1/2"] , [0.625: 5/8"] , [0.75: 3/4"] , ...10 more... )
• custreason ( type: esriFieldTypeString, alias: Customer Reason for Replacement, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custreason , Coded Values: [L: Lead] , [O: Other] )
• custinstalldate ( type: esriFieldTypeDate, alias: Customer Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custinstalldate )
• custverified ( type: esriFieldTypeString, alias: Customer Side Verified, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custverified , Coded Values: [Yes: Yes] , [No: No] )
• custreplace ( type: esriFieldTypeString, alias: Customer Replacement Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custreplace , Coded Values: [DNR: Doesn't Need Replacement] , [NR: Needs Replacement] , [SR: Scheduled Replacement] , ...1 more... )
• custscheddate ( type: esriFieldTypeDate, alias: Customer Scheduled Replacement Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: custscheddate )
• custsource ( type: esriFieldTypeString, alias: Customer Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custsource , Coded Values: [Previous eval: Previous Materials Evaluation] , [Installation record: Installation record (e.g., tap card)] , [Installed after lead ban: Installation date after lead ban (1986)] , ...6 more... )
• custstatus ( type: esriFieldTypeString, alias: Customer Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custstatus , Coded Values: [Unknown: Unknown] , [Lead: Lead] , [Non-Lead: Non-Lead] , ...1 more... )
• custnotified ( type: esriFieldTypeString, alias: Customer Notified?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custnotified , Coded Values: [Yes: Yes] , [No: No] )
• notifydate ( type: esriFieldTypeDate, alias: Notified Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: notifydate )
• yearstrucbuilt ( type: esriFieldTypeInteger, alias: Year Structure Built, editable: true, nullable: true, defaultValue: null, modelName: yearstrucbuilt )
• custname ( type: esriFieldTypeString, alias: Customer Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: custname )
• custaddress ( type: esriFieldTypeString, alias: Customer Address, editable: true, nullable: true, length: 500, defaultValue: null, modelName: custaddress )
• buildingtype ( type: esriFieldTypeString, alias: Building Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: buildingtype , Coded Values: [SF: Single-Family] , [MF: Multi-Family] , [SCH_CC: School/Child Care] , ...4 more... )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: comments )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• utillinstallyear ( type: esriFieldTypeInteger, alias: Utility Install Year, editable: true, nullable: true, defaultValue: null, modelName: utillinstallyear )
• custinstallyear ( type: esriFieldTypeInteger, alias: Customer Install Year, editable: true, nullable: true, defaultValue: null, modelName: custinstallyear )
• taxkey ( type: esriFieldTypeString, alias: Tax key, editable: true, nullable: true, length: 255, defaultValue: null, modelName: taxkey )
• utilverifyyear ( type: esriFieldTypeInteger, alias: Utility Side Year verified, editable: true, nullable: true, defaultValue: null, modelName: utilverifyyear )
• custverifyyear ( type: esriFieldTypeInteger, alias: Customer Side Year verified, editable: true, nullable: true, defaultValue: null, modelName: custverifyyear )
• utilityfieldverify ( type: esriFieldTypeString, alias: Utility Field Verified, editable: true, nullable: true, length: 255, defaultValue: null, modelName: utilityfieldverify , Coded Values: [Y: Yes] , [N: No] , [Needs: Needs Verification] )
• utilityfieldverifyyear ( type: esriFieldTypeInteger, alias: Utility Field Verified Year, editable: true, nullable: true, defaultValue: null, modelName: utilityfieldverifyyear )
• utilityfieldsource ( type: esriFieldTypeString, alias: Utility Field Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: utilityfieldsource , Coded Values: [Customer Self id: Customer self-identification] , [CCTV - Internal: CCTV investigation at curb stop - internal] , [CCTV - External: CCTV investigation at curb stop - external] , ...5 more... )
• customerfieldverified ( type: esriFieldTypeString, alias: Customer Field Verified, editable: true, nullable: true, length: 255, defaultValue: null, modelName: customerfieldverified , Coded Values: [Y: Yes] , [N: No] , [Needs: Needs Verification] )
• custfieldverifyyear ( type: esriFieldTypeInteger, alias: Customer Field Verified Year, editable: true, nullable: true, defaultValue: null, modelName: custfieldverifyyear )
• custfieldsource ( type: esriFieldTypeString, alias: Customer Field Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: custfieldsource , Coded Values: [Customer Self id: Customer self-identification] , [CCTV - Internal: CCTV investigation at curb stop - internal] , [CCTV - External: CCTV investigation at curb stop - external] , ...5 more... )
• notesmatclassification ( type: esriFieldTypeString, alias: Notes Material Classification, editable: true, nullable: true, length: 500, defaultValue: null, modelName: notesmatclassification )
• materialsprevlead ( type: esriFieldTypeString, alias: Material Previously Lead, editable: true, nullable: true, length: 255, defaultValue: null, modelName: materialsprevlead , Coded Values: [Y: Yes] , [N: No] , [Unk: Unknown] )
• leadgoosneck ( type: esriFieldTypeString, alias: Lead Gooseneck Present, editable: true, nullable: true, length: 255, defaultValue: null, modelName: leadgoosneck , Coded Values: [Yes: Yes] , [No: No] )
• treatmentpresent ( type: esriFieldTypeString, alias: Treatment Present, editable: true, nullable: true, length: 255, defaultValue: null, modelName: treatmentpresent , Coded Values: [Y: Yes] , [N: No] , [Unk: Unknown] )
• bldgplumbmat1 ( type: esriFieldTypeString, alias: Building Plumbing Material 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: bldgplumbmat1 , Coded Values: [L: Lead] , [C: Copper] , [CLS: Copper with Lead Solder] , ...3 more... )
• bldgplumbmat2 ( type: esriFieldTypeString, alias: Building Plumbing Material 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: bldgplumbmat2 , Coded Values: [L: Lead] , [C: Copper] , [CLS: Copper with Lead Solder] , ...3 more... )
• bldgmatinstallyear ( type: esriFieldTypeInteger, alias: Building Material Install Year, editable: true, nullable: true, defaultValue: null, modelName: bldgmatinstallyear )
• custinuse ( type: esriFieldTypeString, alias: Customer In Use, editable: true, nullable: true, length: 255, defaultValue: null, modelName: custinuse , Coded Values: [Y: Yes] , [N: No] , [Unk: Unknown] )
• utilinuse ( type: esriFieldTypeString, alias: Utility In Use, editable: true, nullable: true, length: 255, defaultValue: null, modelName: utilinuse , Coded Values: [Y: Yes] , [N: No] , [Unk: Unknown] )
• custschedyear ( type: esriFieldTypeInteger, alias: Customer Scheduled Replacement year, editable: true, nullable: true, defaultValue: null, modelName: custschedyear )
• utilschedyear ( type: esriFieldTypeInteger, alias: Utility Scheduled Replacement year, editable: true, nullable: true, defaultValue: null, modelName: utilschedyear )

Types:

ID: LL
Name: Private Side Lead | City Side Lead
Domains:
• utilmaterial:
  Inherited
• utildiameter:
  Inherited
• utilverified:
  Inherited
• utilreplace:
  Inherited
• utilsource:
  Inherited
• utilstatus:
  Inherited
• utilreason:
  Inherited
• custmaterial:
  Inherited
• Symbology:
  Inherited
• custdiameter:
  Inherited
• custreason:
  Inherited
• custverified:
  Inherited
• custreplace:
  Inherited
• custsource:
  Inherited
• custstatus:
  Inherited
• custnotified:
  Inherited
• buildingtype:
  Inherited
• utilityfieldverify:
  Inherited
• utilityfieldsource:
  Inherited
• customerfieldverified:
  Inherited
• custfieldsource:
  Inherited
• materialsprevlead:
  Inherited
• leadgoosneck:
  Inherited
• treatmentpresent:
  Inherited
• bldgplumbmat1:
  Inherited
• bldgplumbmat2:
  Inherited
• custinuse:
  Inherited
• utilinuse:
  Inherited
Templates:
• Name: Private Side Lead | City Side Lead
  Description:
  Prototype:
  custmaterial: null
  custschedyear: null
  ASSETWORKS_ID: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilreplace: null
  utilscheddate: null
  utilsource: null
  utilstatus: null
  utilreason: null
  custassetid: null
  Symbology: LL
  custdiameter: null
  custreason: null
  custinstalldate: null
  custverified: null
  custreplace: null
  custscheddate: null
  custsource: null
  custstatus: null
  custnotified: null
  notifydate: null
  yearstrucbuilt: null
  custname: null
  custaddress: null
  buildingtype: null
  comments: null
  utilschedyear: null
  utilinuse: null
  custinuse: null
  bldgmatinstallyear: null
  bldgplumbmat2: null
  utillinstallyear: null
  custinstallyear: null
  taxkey: null
  utilverifyyear: null
  custverifyyear: null
  utilityfieldverify: null
  utilityfieldverifyyear: null
  utilityfieldsource: null
  customerfieldverified: null
  custfieldverifyyear: null
  custfieldsource: null
  notesmatclassification: null
  materialsprevlead: null
  leadgoosneck: null
  treatmentpresent: null
  bldgplumbmat1: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: LN
Name: Private Side Lead | City Side Non-Lead
Domains:
• utilmaterial:
  Inherited
• utildiameter:
  Inherited
• utilverified:
  Inherited
• utilreplace:
  Inherited
• utilsource:
  Inherited
• utilstatus:
  Inherited
• utilreason:
  Inherited
• custmaterial:
  Inherited
• Symbology:
  Inherited
• custdiameter:
  Inherited
• custreason:
  Inherited
• custverified:
  Inherited
• custreplace:
  Inherited
• custsource:
  Inherited
• custstatus:
  Inherited
• custnotified:
  Inherited
• buildingtype:
  Inherited
• utilityfieldverify:
  Inherited
• utilityfieldsource:
  Inherited
• customerfieldverified:
  Inherited
• custfieldsource:
  Inherited
• materialsprevlead:
  Inherited
• leadgoosneck:
  Inherited
• treatmentpresent:
  Inherited
• bldgplumbmat1:
  Inherited
• bldgplumbmat2:
  Inherited
• custinuse:
  Inherited
• utilinuse:
  Inherited
Templates:
• Name: Private Side Lead | City Side Non-Lead
  Description:
  Prototype:
  custmaterial: null
  custschedyear: null
  ASSETWORKS_ID: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilreplace: null
  utilscheddate: null
  utilsource: null
  utilstatus: null
  utilreason: null
  custassetid: null
  Symbology: LN
  custdiameter: null
  custreason: null
  custinstalldate: null
  custverified: null
  custreplace: null
  custscheddate: null
  custsource: null
  custstatus: null
  custnotified: null
  notifydate: null
  yearstrucbuilt: null
  custname: null
  custaddress: null
  buildingtype: null
  comments: null
  utilschedyear: null
  utilinuse: null
  custinuse: null
  bldgmatinstallyear: null
  bldgplumbmat2: null
  utillinstallyear: null
  custinstallyear: null
  taxkey: null
  utilverifyyear: null
  custverifyyear: null
  utilityfieldverify: null
  utilityfieldverifyyear: null
  utilityfieldsource: null
  customerfieldverified: null
  custfieldverifyyear: null
  custfieldsource: null
  notesmatclassification: null
  materialsprevlead: null
  leadgoosneck: null
  treatmentpresent: null
  bldgplumbmat1: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: NL
Name: Private Side Non-Lead | City Side Lead
Domains:
• utilmaterial:
  Inherited
• utildiameter:
  Inherited
• utilverified:
  Inherited
• utilreplace:
  Inherited
• utilsource:
  Inherited
• utilstatus:
  Inherited
• utilreason:
  Inherited
• custmaterial:
  Inherited
• Symbology:
  Inherited
• custdiameter:
  Inherited
• custreason:
  Inherited
• custverified:
  Inherited
• custreplace:
  Inherited
• custsource:
  Inherited
• custstatus:
  Inherited
• custnotified:
  Inherited
• buildingtype:
  Inherited
• utilityfieldverify:
  Inherited
• utilityfieldsource:
  Inherited
• customerfieldverified:
  Inherited
• custfieldsource:
  Inherited
• materialsprevlead:
  Inherited
• leadgoosneck:
  Inherited
• treatmentpresent:
  Inherited
• bldgplumbmat1:
  Inherited
• bldgplumbmat2:
  Inherited
• custinuse:
  Inherited
• utilinuse:
  Inherited
Templates:
• Name: Private Side Non-Lead | City Side Lead
  Description:
  Prototype:
  custmaterial: null
  custschedyear: null
  ASSETWORKS_ID: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilreplace: null
  utilscheddate: null
  utilsource: null
  utilstatus: null
  utilreason: null
  custassetid: null
  Symbology: NL
  custdiameter: null
  custreason: null
  custinstalldate: null
  custverified: null
  custreplace: null
  custscheddate: null
  custsource: null
  custstatus: null
  custnotified: null
  notifydate: null
  yearstrucbuilt: null
  custname: null
  custaddress: null
  buildingtype: null
  comments: null
  utilschedyear: null
  utilinuse: null
  custinuse: null
  bldgmatinstallyear: null
  bldgplumbmat2: null
  utillinstallyear: null
  custinstallyear: null
  taxkey: null
  utilverifyyear: null
  custverifyyear: null
  utilityfieldverify: null
  utilityfieldverifyyear: null
  utilityfieldsource: null
  customerfieldverified: null
  custfieldverifyyear: null
  custfieldsource: null
  notesmatclassification: null
  materialsprevlead: null
  leadgoosneck: null
  treatmentpresent: null
  bldgplumbmat1: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: NN
Name: Private Side Non-Lead | Private Side Non-Lead
Domains:
• utilmaterial:
  Inherited
• utildiameter:
  Inherited
• utilverified:
  Inherited
• utilreplace:
  Inherited
• utilsource:
  Inherited
• utilstatus:
  Inherited
• utilreason:
  Inherited
• custmaterial:
  Inherited
• Symbology:
  Inherited
• custdiameter:
  Inherited
• custreason:
  Inherited
• custverified:
  Inherited
• custreplace:
  Inherited
• custsource:
  Inherited
• custstatus:
  Inherited
• custnotified:
  Inherited
• buildingtype:
  Inherited
• utilityfieldverify:
  Inherited
• utilityfieldsource:
  Inherited
• customerfieldverified:
  Inherited
• custfieldsource:
  Inherited
• materialsprevlead:
  Inherited
• leadgoosneck:
  Inherited
• treatmentpresent:
  Inherited
• bldgplumbmat1:
  Inherited
• bldgplumbmat2:
  Inherited
• custinuse:
  Inherited
• utilinuse:
  Inherited
Templates:
• Name: Private Side Non-Lead | Private Side Non-Lead
  Description:
  Prototype:
  custmaterial: null
  custschedyear: null
  ASSETWORKS_ID: null
  utilassetid: null
  utilmaterial: null
  utildiameter: null
  utilinstalldate: null
  utilverified: null
  utilreplace: null
  utilscheddate: null
  utilsource: null
  utilstatus: null
  utilreason: null
  custassetid: null
  Symbology: NN
  custdiameter: null
  custreason: null
  custinstalldate: null
  custverified: null
  custreplace: null
  custscheddate: null
  custsource: null
  custstatus: null
  custnotified: null
  notifydate: null
  yearstrucbuilt: null
  custname: null
  custaddress: null
  buildingtype: null
  comments: null
  utilschedyear: null
  utilinuse: null
  custinuse: null
  bldgmatinstallyear: null
  bldgplumbmat2: null
  utillinstallyear: null
  custinstallyear: null
  taxkey: null
  utilverifyyear: null
  custverifyyear: null
  utilityfieldverify: null
  utilityfieldverifyyear: null
  utilityfieldsource: null
  customerfieldverified: null
  custfieldverifyyear: null
  custfieldsource: null
  notesmatclassification: null
  materialsprevlead: null
  leadgoosneck: null
  treatmentpresent: null
  bldgplumbmat1: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

Supports Coordinates Quantization: true

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