Name: Lateral Inspections

Display Field:

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: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","label":"Survey Point","symbol":{"color":[116,181,102,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,0,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

HasZ: false

HasM: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• permit_number (type: esriFieldTypeString, alias: Permit Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• permit_address (type: esriFieldTypeString, alias: Permit Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• name_of_inspector (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• weather_conditions (type: esriFieldTypeString, alias: Weather Conditions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• commentsreasons_for_violations (type: esriFieldTypeString, alias: Reasons for violations, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• FirmName (type: esriFieldTypeString, alias: Inspector Firm Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Citizens: Citizens], [DLZ: DLZ], [Etica_Group: Etica Group], ... 2 more ...)
• TypeofInspection (type: esriFieldTypeString, alias: Type of Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [New_Connection: New Connection], [Repair: Repair], [Abandonment: Abandonment], ... 4 more ...)
• type_of_inspection_other (type: esriFieldTypeString, alias: Other - Type of Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PermitOnSite (type: esriFieldTypeString, alias: Permit on site?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ApprovedPipeMaterial (type: esriFieldTypeString, alias: Approved pipe material per Sec. 303.02?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• BellsFacingUpstream (type: esriFieldTypeString, alias: Bells facing upstream per Sec. 401.02.3?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• TracerWirePresent (type: esriFieldTypeString, alias: Tracer wire present per Sec. 401.07?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes_10_ga_gravity: Yes, 10 ga gravity], [No: No], [Not_required: Not required], ... 1 more ...)
• tracer_wire_present_other (type: esriFieldTypeString, alias: Other - Tracer wire present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TracerWireSplice (type: esriFieldTypeString, alias: Tracer wire splice per Sec. 401.07?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• No8StoneBeddingUnderPipe (type: esriFieldTypeString, alias: No. 8 stone bedding present under pipe per Sec. 401.06.1?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• MinimumLateralDepth (type: esriFieldTypeString, alias: Minimum lateral depth 3' outside the ROW/easement and 4' within ROW/easement per Sec. 201.06?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• LateralMinimum (type: esriFieldTypeString, alias: Lateral minimum 5 feet from side property line per Sec. 201.07?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SlipJointUtilized (type: esriFieldTypeString, alias: Slip joint utilized (if applicable) per Sec. 402.04?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not_required: Not required])
• SaddleConnection (type: esriFieldTypeString, alias: Saddle connection to sewer main?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• IfSaddleConnection (type: esriFieldTypeString, alias: If saddle connection, per Sec. 402.05?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• GlueFitting (type: esriFieldTypeString, alias: Glue fitting at lateral stub connection?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• IfNotGlueFitting (type: esriFieldTypeString, alias: If not glue fitting, non-shear coupling used per Sec. 401.09b?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CleanoutWithin (type: esriFieldTypeString, alias: Building cleanout within 18"-60" of foundation per Sec. 201.08?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CleanoutsSpaced (type: esriFieldTypeString, alias: Cleanouts spaced maximum of 100' apart per Sec. 201.08?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• InspectionPassOrFail (type: esriFieldTypeString, alias: Inspection Pass or Fail?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Pass: Pass], [Fail: Fail])
• date_and_time_of_inspection (type: esriFieldTypeDate, alias: Date and Time of Inspection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• row_cleanout_installed_per_sec_ (type: esriFieldTypeString, alias: ROW cleanout installed per Sec. 201.08?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Not_Required: Not Required])
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• nearest_citizens_mh_id_number (type: esriFieldTypeString, alias: Nearest Citizens MH ID Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• distance_from_lateral_connectio (type: esriFieldTypeString, alias: Distance from Lateral Connection to MH Above, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/5/2026 5:47:20 PM

Schema Last Edit Date: 5/5/2025 5:16:21 PM

Data Last Edit Date: 6/5/2026 5:47:20 PM

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