Layer: Material Self-Report (ID:0)

View In: Map Viewer

Name: Material Self-Report

Display Field: InventoryID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Feature storage for customer self-reported service line materials

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:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[78,78,78,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
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)
lcrr_PublicStatus (type: esriFieldTypeString, alias: Public Status [LCRR], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Received: Received], [Under Review: Under Review], [More Information Needed: More Information Needed], ... 2 more ...)
srv_StartTime (type: esriFieldTypeDate, alias: Start Time [Survey], SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
srv_EndTime (type: esriFieldTypeDate, alias: End Time [Survey], SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
srv_Username (type: esriFieldTypeString, alias: Username [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_DeviceID (type: esriFieldTypeString, alias: Device ID [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_LocInventoryIDProvided (type: esriFieldTypeString, alias: Location – Inventory ID Provided [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_LocNorthStarAccountProvide (type: esriFieldTypeString, alias: Location – NorthStar Account Provided [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_LocAddressType (type: esriFieldTypeString, alias: Location – Address Type [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [lookup: Select from our list of service addresses (preferred method)], [geocode: Search for any Norfolk addresses (alternative method)], [manual: Enter your full address (alternative method)])
srv_LocStreetNameLookup (type: esriFieldTypeString, alias: Location – Street Name Lookup [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_LocBuildingNumberLookup (type: esriFieldTypeString, alias: Location – Building Number Lookup [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_LocUnitNumberLookup (type: esriFieldTypeString, alias: Location – Unit Number Lookup [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_LocGeocodedAddess (type: esriFieldTypeString, alias: Location – Geocoded Addess [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_LocManualAddress (type: esriFieldTypeString, alias: Location – Manual Address [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_LocXY (type: esriFieldTypeString, alias: Location – XY [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_TestPerformed (type: esriFieldTypeString, alias: Test – Performed [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
srv_TestScratchResults (type: esriFieldTypeString, alias: Test – Scratch Results [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Plastic: The pipe is smooth and red, blue, black, or white [Plastic]], [Copper: The pipe is color of a penny (copper, dull brown or greenish) [Copper]], [Brass: The pipe is dark yellow or golden [Brass]], ... 3 more ...)
srv_TestScratchFailReason (type: esriFieldTypeString, alias: Test – Scratch Fail Reason [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_TestMagnetResults (type: esriFieldTypeString, alias: Test – Magnet Results [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Magnetic: The magnet sticks to the pipe [Galvanized Steel]], [Not Magnetic: The magnet does not stick to the pipe [Plastic, Copper, Brass, or Lead]], [Other: I could not perform the magnet test (please describe why)])
srv_TestMagnetFailReason (type: esriFieldTypeString, alias: Test – Magnet Fail Reason [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_TestFailIssues (type: esriFieldTypeString, alias: Test – Fail Issues [Survey], SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true, Coded Values: [Could_not_find_service_line: I could not find my service line], [Could_not_reach_service_line: I could not reach my service line], [Need_assistance_with_tests: I need assistance with performing the tests], ... 2 more ...)
srv_TestFailIssuesOther (type: esriFieldTypeString, alias: Test – Fail Issues Other [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_UserFullName (type: esriFieldTypeString, alias: User – Full Name [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_UserPhoneNumber (type: esriFieldTypeString, alias: User – Phone Number [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_UserEmailAddress (type: esriFieldTypeString, alias: User – Email Address [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_UserShowProgress (type: esriFieldTypeString, alias: User – Show Progress [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
srv_UserResidence (type: esriFieldTypeString, alias: User – Residence [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Own: Own], [Rent: Rent], [Other: Other (please describe)])
srv_UserResidenceOther (type: esriFieldTypeString, alias: User – Residence Other [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_UserReplacementInfo (type: esriFieldTypeString, alias: User – Replacement Info [Survey], SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
srv_UserReplacementDate (type: esriFieldTypeString, alias: User – Replacement Date [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_UserReplacementMaterial (type: esriFieldTypeString, alias: User – Replacement Material [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Non-Lead - Other: Non-Lead - Other], [Non-Lead - Copper: Non-Lead - Copper], [Non-Lead - Plastic: Non-Lead - Plastic], ... 1 more ...)
srv_UserReplaceMaterialOther (type: esriFieldTypeString, alias: User – Replacement Material Other [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_UserMaterialSource (type: esriFieldTypeString, alias: User – Material Source [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_UserMaterialSourceOther (type: esriFieldTypeString, alias: User – Material Source Other [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
srv_UserMaterial (type: esriFieldTypeString, alias: User – Material [Survey], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Non-Lead - Other: Non-Lead - Other], [Non-Lead - Copper: Non-Lead - Copper], [Non-Lead - Plastic: Non-Lead - Plastic], ... 2 more ...)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/16/2026 1:37:47 PM

Schema Last Edit Date: 8/26/2026 1:12:44 PM

Data Last Edit Date: 9/16/2026 1:37:47 PM

Supported Operations: Add Features Apply Edits Generate Renderer Validate SQL Get Estimates ConvertFormat