Name: Inspection Points

Display Field: Client

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: -9708157.37346314
YMin: 254382.425045361
XMax: 3796168.64867736
YMax: 5195514.33331029
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":null}

HasZ: true

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Client (type: esriFieldTypeString, alias: Client, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• utilitymaterial (type: esriFieldTypeString, alias: Utility Side Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Unknown - Likely Lead: Unknown - Likely Lead], [Unknown - Not Likely Lead: Unknown - Not Likely Lead], ... 19 more ...)
• utilityfieldverified (type: esriFieldTypeString, alias: Utility Side Field Verified?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• utilstatus (type: esriFieldTypeSmallInteger, alias: Utility Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Lead], [2: Non-Lead], ... 2 more ...)
• customermaterial (type: esriFieldTypeString, alias: Customer SIde Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Unknown - Likely Lead: Unknown - Likely Lead], [Unknown - Not Likely Lead: Unknown - Not Likely Lead], ... 19 more ...)
• customerfieldverified (type: esriFieldTypeString, alias: Customer Side Field Verified?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• custstatus (type: esriFieldTypeSmallInteger, alias: Customer Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Lead], [2: Non-Lead], ... 2 more ...)
• TicketSubmittedBy (type: esriFieldTypeString, alias: Ticket Submitted By, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ElectricStatus (type: esriFieldTypeString, alias: Electric Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Unmarked: Unmarked], [Marked: Marked])
• GasStatus (type: esriFieldTypeString, alias: Gas Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Unmarked: Unmarked], [Marked: Marked])
• CommStatus (type: esriFieldTypeString, alias: Communication/Fiber Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Unmarked: Unmarked], [Marked: Marked])
• WaterStatus (type: esriFieldTypeString, alias: Water Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Unmarked: Unmarked], [Marked: Marked])
• SewerStatus (type: esriFieldTypeString, alias: Sewer Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Unmarked: Unmarked], [Marked: Marked])
• DateLocatesVerified (type: esriFieldTypeDate, alias: Date Locates Vaeified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OriginalTicketNumber (type: esriFieldTypeString, alias: Original Ticket Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• OrigTicketSubmitDate (type: esriFieldTypeDate, alias: Original Ticket Submission Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TicketExpireDate (type: esriFieldTypeDate, alias: Ticket Expiration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InspectionStatus (type: esriFieldTypeString, alias: Inspection Status, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Ready For Daylighting: Ready For Daylighting], [Skipped: Skipped], [Ready for Restoration: Daylighting Complete: Ready for Restoration], ... 1 more ...)
• ReasonSkipped (type: esriFieldTypeString, alias: Reason Skipped, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Needs Locate: Needs Locate], [Obstruction: Obstruction], [No Street Access: No Street Access], ... 3 more ...)
• DaylightingDate (type: esriFieldTypeDate, alias: Daylighting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DaylightingOperator (type: esriFieldTypeString, alias: Daylighting Operator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DaylightingNotes (type: esriFieldTypeString, alias: Dayligting Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: Inspection Points
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilitymaterialbasis: Visual - Excavation
• utilityfieldverified: Yes
• utilfieldverifmethod: Vacuum Excavation
• custmaterialbasis: Visual - Excavation
• customerfieldverified: Yes
• custfieldverifmethod: Vacuum Excavation
• GasStatus: Unmarked
• CommStatus: Unmarked
• WaterStatus: Unmarked
• SewerStatus: Unmarked

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/29/2025 6:16:53 PM

Schema Last Edit Date: 7/29/2025 6:16:53 PM

Data Last Edit Date: 7/29/2025 6:16:53 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat