Name: Centerline_Ditch_Inspections_Table

Display Field: FULL_STR_NAME

Type: Table

Description: Data is never removed from table When new inspections are collected on previously inspected ditches, all records retained so reports can be built showing progress of ditch over time. the Table is related to the DBO.Centerlines layer by STR_SEG_ID_D. A "VIEW" layer with the joined table was created in the SDE and Published to REST. the VIEW is used to symbolize centerlines based off the rating (color Good=green) within this table. View layer: https://maps.lafayettela.gov/arcgis/rest/services/BaseLayers/DITCH_INSPECTION_WITH_CENTERLINES_VIEW/MapServer/1editable REST service for table: https://maps.lafayettela.gov/arcgis/rest/services/EditableLayers/Centerlines_With_Ditch_Inspections/MapServer

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• STR_SEG_ID_D (type: esriFieldTypeDouble, alias: STR_SEG_ID_D, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [19980101000000 - 30000105000000])
• FULL_STR_NAME (type: esriFieldTypeString, alias: Full Street Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• InspectionDate (type: esriFieldTypeString, alias: Inspection Date, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Odd_Rating (type: esriFieldTypeString, alias: Odd Side Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Moderate: Moderate], [Bad: Bad], ... 1 more ...)
• Even_Rating (type: esriFieldTypeString, alias: Even Side Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Moderate: Moderate], [Bad: Bad], ... 1 more ...)
• OverAllDitchRating (type: esriFieldTypeString, alias: Overall Ditch Rating, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Good: Good], [Moderate: Moderate], [Bad: Bad], ... 1 more ...)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Excavation_Completed (type: esriFieldTypeDateOnly, alias: Excavation Completion Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape_Length (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Centerline_Ditch_Inspections_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• STR_SEG_ID_D: 19990101000000

Relationships:

• DBO.Centerlines (0) -- Related To: DBO.Centerlines (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/26/2026 7:23:32 PM

Schema Last Edit Date: 3/26/2026 7:23:27 PM

Data Last Edit Date: 3/2/2026 8:15:46 PM

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