Name: NJ LEAD PROJECT

Display Field: Owner_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10524884.6622977
YMin: 4612729.06114541
XMax: -8303166.6919
YMax: 5037589.49705179
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"if($feature.utilverified != \"Yes\" && $feature.custverified != \"Yes\") {return \" ●●\"}\nelse if($feature.utilverified != \"Yes\" && $feature.custverified == \"Yes\") {return \"●\"}\nelse if($feature.custverified != \"Yes\" && $feature.utilverified == \"Yes\") {return \" ●\"}","title":"Unverified Service Lines"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":true,"stackAlignment":"textSymbol","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":5000,"name":"Class 1","priority":0,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":-2,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Arial","size":10,"style":"normal","weight":"normal","decoration":"none"}}}]}

HasZ: false

HasM: true

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PBCU_Sample_Site (type: esriFieldTypeString, alias: PBCU Sample Site ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Street Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• zipcode (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• town (type: esriFieldTypeString, alias: Town, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• lot (type: esriFieldTypeString, alias: Lot (Optional), SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• block (type: esriFieldTypeString, alias: Block (Optional), SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• easting (type: esriFieldTypeString, alias: Easting (X) Optional, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• northing (type: esriFieldTypeString, alias: Northing (Y) (Optional), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Latitude (type: esriFieldTypeString, alias: Latitude (Optional), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Longitude (type: esriFieldTypeString, alias: Longitude (Optional), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• locationident (type: esriFieldTypeString, alias: Location Identifier (Optional), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• bothsidesstatus (type: esriFieldTypeString, alias: Service Line Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [L: Lead], [G: Galvanized], [LC: Lead connector], ... 2 more ...)
• SuspectedLead (type: esriFieldTypeString, alias: Suspected to be lead?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• utilmaterial (type: esriFieldTypeString, alias: Utility Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [L: Lead], [G: Galvanized Iron/Steel], [C: Copper], ... 4 more ...)
• utilmaterial_other (type: esriFieldTypeString, alias: Other Util Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• custmaterial (type: esriFieldTypeString, alias: Customer Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [L: Lead], [G: Galvanized Iron/Steel], [C: Copper], ... 4 more ...)
• custmaterial_other (type: esriFieldTypeString, alias: Other Cust Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• utilinstalldate (type: esriFieldTypeString, alias: Install Date / Year (Utility), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• custinstalldate (type: esriFieldTypeString, alias: Install Date / Year (Customer), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• servicelinelength (type: esriFieldTypeInteger, alias: Service Line Length (ft.) (Optional), SQL Type: sqlTypeOther, nullable: true, editable: true)
• utilverifmethod (type: esriFieldTypeString, alias: PCWS Service Line - Verification Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [R: Distribution system resources, including DS maps, drawings], [RRN: Records: residential and non-residential building resources], [F1: Field/visual inspection without full excavation], ... 6 more ...)
• utilverifmethod_other (type: esriFieldTypeString, alias: PCWS Service Line - Other Source , SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• util_reason (type: esriFieldTypeString, alias: PCWS Service Line - Reasoning, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• util_steps_ID (type: esriFieldTypeString, alias: PCWS Service Line - Steps to be taken to ID, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• custverifmethod (type: esriFieldTypeString, alias: Customer Service Line - Verification Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [R: Distribution system resources, including DS maps, drawings], [RRN: Records: residential and non-residential building resources], [F1: Field/visual inspection without full excavation], ... 6 more ...)
• custverifmethod_other (type: esriFieldTypeString, alias: Customer Service Line - Other Source , SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• cust_reason (type: esriFieldTypeString, alias: Customer Service Line - Reasoning, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• cust_steps_ID (type: esriFieldTypeString, alias: Customer Service Line - Steps to be taken to ID, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• Attachments (type: esriFieldTypeString, alias: Attachments? Optional), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• utildiameter (type: esriFieldTypeDouble, alias: Utility Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 1/2"], [0.75: 3/4"], [1: 1"], ... 8 more ...)
• custdiameter (type: esriFieldTypeDouble, alias: Customer Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 1/2"], [0.75: 3/4"], [1: 1"], ... 8 more ...)
• bldgtype (type: esriFieldTypeString, alias: Building Type (Optional), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [School or Childcare Center: School or Childcare Center], [Child-care (In-home): Child-care (In-home)], [Other non-residential: Other non-residential], ... 2 more ...)
• pcwscomments (type: esriFieldTypeString, alias: PCWS Comments (Optional), SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• DEP_Comments (type: esriFieldTypeString, alias: DEP Comments (Leave Blank), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GISID (type: esriFieldTypeString, alias: GISID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• utilstatus (type: esriFieldTypeSmallInteger, alias: utilstatus, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Lead], [2: Non-Lead], ... 1 more ...)
• custstatus (type: esriFieldTypeSmallInteger, alias: custstatus, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Lead], [2: Non-Lead], ... 1 more ...)
• custverifdate (type: esriFieldTypeDate, alias: custverifdate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• utilverified (type: esriFieldTypeString, alias: utilverified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• custverified (type: esriFieldTypeString, alias: custverified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Owner_Name (type: esriFieldTypeString, alias: Owner Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• accountid (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LeadConnector (type: esriFieldTypeString, alias: Lead Connector?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])

Templates:

Name: Lead | Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 1
• zipcode: 07826
• town: Branchville
• custstatus: 1
Name: Lead | Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 1
• zipcode: 07826
• town: Branchville
• custstatus: 3
Name: Lead | Non-Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 1
• zipcode: 07826
• town: Branchville
• custstatus: 2
Name: Lead | Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 1
• zipcode: 07826
• town: Branchville
• custstatus: 0
Name: Galvanized Requiring Replacement | Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 3
• zipcode: 07826
• town: Branchville
• custstatus: 1
Name: Galvanized Requiring Replacement | Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 3
• zipcode: 07826
• town: Branchville
• custstatus: 3
Name: Galvanized Requiring Replacement | Non-Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 3
• zipcode: 07826
• town: Branchville
• custstatus: 2
Name: Galvanized Requiring Replacement | Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 3
• zipcode: 07826
• town: Branchville
• custstatus: 0
Name: Non-Lead | Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 2
• zipcode: 07826
• town: Branchville
• custstatus: 1
Name: Non-Lead | Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 2
• zipcode: 07826
• town: Branchville
• custstatus: 3
Name: Non-Lead | Non-Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 2
• zipcode: 07826
• town: Branchville
• custstatus: 2
Name: Non-Lead | Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 2
• zipcode: 07826
• town: Branchville
• custstatus: 0
Name: Unknown | Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 0
• zipcode: 07826
• town: Branchville
• custstatus: 1
Name: Unknown | Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 0
• zipcode: 07826
• town: Branchville
• custstatus: 3
Name: Unknown | Non-Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 0
• zipcode: 07826
• town: Branchville
• custstatus: 2
Name: Unknown | Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 0
• zipcode: 07826
• town: Branchville
• custstatus: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/13/2024 3:25:09 PM

Schema Last Edit Date: 2/13/2024 3:22:53 PM

Data Last Edit Date: 2/13/2024 3:25:09 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat