Name: PBMI Segments Inspections

Display Field: ARCGIS_USER_NAME

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• FROM_DATE (type: esriFieldTypeDate, alias: From Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IS_ALT_SEGMENT_YN (type: esriFieldTypeInteger, alias: Is Alternate Segment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• ROUTE_ID (type: esriFieldTypeString, alias: TDOT Route or Ramp ID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• EVENT_ID (type: esriFieldTypeString, alias: Event ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SEGMENTID_QUARTER (type: esriFieldTypeString, alias: Segment ID (Quarter), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeInteger, alias: County, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 01-Anderson], [2: 02-Bedford], [3: 03-Benton], ... 92 more ...)
• FROM_MEASURE_MILE (type: esriFieldTypeDouble, alias: From Measure (Begin Log Mile), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TO_MEASURE_MILE (type: esriFieldTypeDouble, alias: To Measure (End Log Mile), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FROM_LATITUDE_DD (type: esriFieldTypeDouble, alias: Begin Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FROM_LONGITUDE_DD (type: esriFieldTypeDouble, alias: Begin Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TO_LATITUDE_DD (type: esriFieldTypeDouble, alias: End Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TO_LONGITUDE_DD (type: esriFieldTypeDouble, alias: End Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REGION (type: esriFieldTypeInteger, alias: Region, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISTRICT (type: esriFieldTypeInteger, alias: District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEGMENT_LENGTH (type: esriFieldTypeDouble, alias: Segment Length (Linear Feet), SQL Type: sqlTypeOther, nullable: true, editable: true)
• IS_RAMP_YN (type: esriFieldTypeInteger, alias: Is Ramp, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• IS_INTERSTATE_YN (type: esriFieldTypeInteger, alias: Is Interstate, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• FISCAL_YEAR (type: esriFieldTypeInteger, alias: Fiscal Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QUARTER (type: esriFieldTypeInteger, alias: Quarter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONTRACT_ID (type: esriFieldTypeString, alias: Contract ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [PB2401: Region 3 North PBMC], [PB2402: Region 3 South PBMC], [PB2403: Region 4 West PBMC], ... 7 more ...)
• EVALUATION_ID (type: esriFieldTypeString, alias: Evaluation ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [E01: Evaluation Period 01], [E02: Evaluation Period 02], [E03: Evaluation Period 03], ... 18 more ...)
• INSPECTION_PROGRAM (type: esriFieldTypeString, alias: Inspection Program, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [PBMC: PBMC], [NON_PBMC: Non-PBMC])
• SEGMENT_NUMBER (type: esriFieldTypeInteger, alias: Segment Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEGMENT_STATUS (type: esriFieldTypeInteger, alias: Segment Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Reserve Segment], [1: Active Segment], [99: Alternate Site Required])
• INSPECTION_STATUS (type: esriFieldTypeInteger, alias: Inspection Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needs Inspection], [10: Inspection Completed], [20: QC in Progress], ... 4 more ...)
• SKIP_SEGMENT_REASON (type: esriFieldTypeInteger, alias: Skip Segment Reason, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Safety], [2: Active construction], [3: Bridge >250 feet], ... 2 more ...)
• INSPECTION_COMPLETED (type: esriFieldTypeInteger, alias: Inspection completed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• PERIOD_START_DATE (type: esriFieldTypeDate, alias: Evaluation Period Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PERIOD_END_DATE (type: esriFieldTypeDate, alias: Evaluation Period End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ASSIGNED_TO (type: esriFieldTypeString, alias: Inspection Assigned To, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PARENTGLOBALID (type: esriFieldTypeGUID, alias: Parent Global ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• DISPUTE_RES_DATE (type: esriFieldTypeDate, alias: Dispute Resolution Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DISPUTE_RES_COMMENT (type: esriFieldTypeString, alias: Dispute Resolution Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ARCGIS_USER_NAME (type: esriFieldTypeString, alias: ARCGIS_USER_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LANE_P_SURFACE_TYPE (type: esriFieldTypeInteger, alias: Road Surface Type?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Rigid], [1: Flexible], [2: Both])
• SHLDR_P_PRESENT_YN (type: esriFieldTypeInteger, alias: Paved Shoulder Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• SHLDR_P_SURFACE_TYPE (type: esriFieldTypeInteger, alias: Paved Shoulder Surface Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Rigid], [1: Flexible], [2: Both])
• SHLDR_U_PRESENT_YN (type: esriFieldTypeInteger, alias: Unpaved Shoulder Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• DITCH_P_PRESENT_YN (type: esriFieldTypeInteger, alias: Paved Ditches Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• DITCH_U_PRESENT_YN (type: esriFieldTypeInteger, alias: Unpaved Ditches Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• CNG_PRESENT_YN (type: esriFieldTypeInteger, alias: Are Curb and Gutter Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• PIPE_PRESENT_YN (type: esriFieldTypeInteger, alias: Are Pipes Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• INLETS_PRESENT_YN (type: esriFieldTypeInteger, alias: Are Drainage Inlets Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• FENCE_PRESENT_YN (type: esriFieldTypeInteger, alias: Fencing present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• TREES_PRESENT_YN (type: esriFieldTypeInteger, alias: Are Brush and Trees Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• SIGN_PRESENT_YN (type: esriFieldTypeInteger, alias: Are Traffic Signs Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• NOISE_WALL_PRESENT_YN (type: esriFieldTypeInteger, alias: Are Noise Walls Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• GR_PRESENT_YN (type: esriFieldTypeInteger, alias: Is Guardrail or Cable Barrier Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• ATTEN_PRESENT_YN (type: esriFieldTypeInteger, alias: Are Attenuators Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• CONC_BARRIER_PRESENT_YN (type: esriFieldTypeInteger, alias: Are Concrete Barriers Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• RET_WALL_PRESENT_YN (type: esriFieldTypeInteger, alias: Are Retaining or MSE Walls Present?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• INSPECTION_DATE (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LANE_P_FLEX_POTHOLE_PF (type: esriFieldTypeInteger, alias: Travel Lane, Paved, Flexible, Potholes - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• LANE_P_FLEX_POTHOLE_NOTE (type: esriFieldTypeString, alias: Travel Lane, Paved, Flexible, Potholes - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LANE_P_FLEX_EXPOSED_BASE_PF (type: esriFieldTypeInteger, alias: Travel Lane, Paved, Flexible, Exposed Base - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• LANE_P_FLEX_EXPOSED_BASE_NOTE (type: esriFieldTypeString, alias: Travel Lane, Paved, Flexible, Exposed Base - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LANE_P_FLEX_JOINT_UNSEAL_PF (type: esriFieldTypeInteger, alias: Travel Lane, Paved, Flexible, Joint, Unsealed, Percent - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• LANE_P_FLEX_JOINT_UNSEAL_NOTE (type: esriFieldTypeString, alias: Travel Lane, Paved, Flexible, Joint, Unsealed, Percent - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LANE_P_RIGID_POTHOLE_PF (type: esriFieldTypeInteger, alias: Travel Lane, Paved, Rigid, Potholes - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• LANE_P_RIGID_POTHOLE_NOTE (type: esriFieldTypeString, alias: Travel Lane, Paved, Rigid, Potholes - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LANE_P_RIGID_JOINT_MATL_PF (type: esriFieldTypeInteger, alias: Travel Lane, Paved, Rigid, Joint, Material - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• LANE_P_RIGID_JOINT_MATL_NOTE (type: esriFieldTypeString, alias: Travel Lane, Paved, Rigid, Joint, Material - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LANE_P_RIGID_SPALL_PF (type: esriFieldTypeInteger, alias: Travel Lane, Paved, Rigid, Spalling - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• LANE_P_RIGID_SPALL_NOTE (type: esriFieldTypeString, alias: Travel Lane, Paved, Rigid, Spalling - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LANE_P_RIGID_VERT_DEVIATE_PF (type: esriFieldTypeInteger, alias: Travel Lane, Paved, Rigid, Vertical Deviation - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• LANE_P_RIGID_VERT_DEVIATE_NOTE (type: esriFieldTypeString, alias: Travel Lane, Paved, Rigid, Vertical Deviation - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SHLDR_P_FLEX_POTHOLE_PF (type: esriFieldTypeInteger, alias: Shoulder, Paved, Flexible, Potholes - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SHLDR_P_FLEX_POTHOLE_NOTE (type: esriFieldTypeString, alias: Shoulder, Paved, Flexible, Potholes - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SHLDR_P_RUMBLE_PF (type: esriFieldTypeInteger, alias: Shoulder, Paved, Rumble Strip - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• SHLDR_P_RUMBLE_NOTE (type: esriFieldTypeString, alias: Shoulder, Paved, Rumble Strip - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SHLDR_P_DIFFERENTIAL_PF (type: esriFieldTypeInteger, alias: Shoulder, Paved, Travel Lane - Shoulder Edge Differential - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SHLDR_P_DIFFERENTIAL_NOTE (type: esriFieldTypeString, alias: Shoulder, Paved, Travel Lane - Shoulder Edge Differential - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SHLDR_P_JOINT_UNSEAL_PCT_PF (type: esriFieldTypeInteger, alias: Shoulder, Paved, Joint, Unsealed, Percent - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SHLDR_P_JOINT_UNSEAL_PCT_NOTE (type: esriFieldTypeString, alias: Shoulder, Paved, Joint, Unsealed, Percent - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SHLDR_P_FLEX_SETTLE_HEAVE_PF (type: esriFieldTypeInteger, alias: Shoulder, Paved, Flexible, Settlement/Heaving - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SHLDR_P_FLEX_SETTLE_HEAVE_NOTE (type: esriFieldTypeString, alias: Shoulder, Paved, Flexible, Settlement/Heaving - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SHLDR_U_BUILDUP_PF (type: esriFieldTypeInteger, alias: Shoulder, Unpaved, Buildup - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SHLDR_U_BUILDUP_NOTE (type: esriFieldTypeString, alias: Shoulder, Unpaved, Buildup - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SHLDR_U_BUILDUP_FAIL_AMT (type: esriFieldTypeInteger, alias: Shoulder, Unpaved, Buildup - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SHLDR_U_DROPOFF_PF (type: esriFieldTypeInteger, alias: Shoulder, Unpaved, Edge Drop Off - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SHLDR_U_DROPOFF_NOTE (type: esriFieldTypeString, alias: Shoulder, Unpaved, Edge Drop Off - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SHLDR_U_DROPOFF_FAIL_AMT (type: esriFieldTypeInteger, alias: Shoulder, Unpaved, Edge Drop Off - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DITCH_U_BLOCK_PF (type: esriFieldTypeInteger, alias: Ditch, Unpaved, Blocked - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• DITCH_U_BLOCK_NOTE (type: esriFieldTypeString, alias: Ditch, Unpaved, Blocked - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DITCH_U_EROSION_PF (type: esriFieldTypeInteger, alias: Ditch, Unpaved, Erosion - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• DITCH_U_EROSION_NOTE (type: esriFieldTypeString, alias: Ditch, Unpaved, Erosion - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FNB_SLOPE_EROSION_PF (type: esriFieldTypeInteger, alias: Front/Back Slope, Erosion - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• FNB_SLOPE_EROSION_NOTE (type: esriFieldTypeString, alias: Front/Back Slope, Erosion - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DITCH_P_BLOCK_PF (type: esriFieldTypeInteger, alias: Ditch, Paved, Blocked - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• DITCH_P_BLOCK_NOTE (type: esriFieldTypeString, alias: Ditch, Paved, Blocked - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DITCH_P_EROSION_PF (type: esriFieldTypeInteger, alias: Ditch, Paved, Erosion - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• DITCH_P_EROSION_NOTE (type: esriFieldTypeString, alias: Ditch, Paved, Erosion - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DITCH_P_SETTLING_PF (type: esriFieldTypeInteger, alias: Ditch, Paved, Settling - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• DITCH_P_SETTLING_NOTE (type: esriFieldTypeString, alias: Ditch, Paved, Settling - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DITCH_P_CRACKING_PF (type: esriFieldTypeInteger, alias: Ditch, Paved, Cracking - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• DITCH_P_CRACKING_NOTE (type: esriFieldTypeString, alias: Ditch, Paved, Cracking - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNG_SETTLEMENT_PF (type: esriFieldTypeInteger, alias: Curb and Gutter, Settlement - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CNG_SETTLEMENT_NOTE (type: esriFieldTypeString, alias: Curb and Gutter, Settlement - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNG_STR_DAMAGE_PF (type: esriFieldTypeInteger, alias: Curb and Gutter, Structural Damage - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CNG_STR_DAMAGE_NOTE (type: esriFieldTypeString, alias: Curb and Gutter, Structural Damage - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNG_ALIGN_PF (type: esriFieldTypeInteger, alias: Curb and Gutter, Alignment - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CNG_ALIGN_NOTE (type: esriFieldTypeString, alias: Curb and Gutter, Alignment - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PIPE_OBSTRUCT_PF (type: esriFieldTypeInteger, alias: Pipe, Obstruction - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• PIPE_OBSTRUCT_NOTE (type: esriFieldTypeString, alias: Pipe, Obstruction - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PIPE_OBSTRUCT_FAIL_AMT (type: esriFieldTypeInteger, alias: Pipe, Obstruction - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPE_EROSION_PF (type: esriFieldTypeInteger, alias: Pipe, Erosion - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• PIPE_EROSION_NOTE (type: esriFieldTypeString, alias: Pipe, Erosion - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PIPE_EROSION_FAIL_AMT (type: esriFieldTypeInteger, alias: Pipe, Erosion - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPE_END_PROTECT_PF (type: esriFieldTypeInteger, alias: Pipe, End Protection - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• PIPE_END_PROTECT_NOTE (type: esriFieldTypeString, alias: Pipe, End Protection - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PIPE_END_PROTECT_FAIL_AMT (type: esriFieldTypeInteger, alias: Pipe, End Protection - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPE_STR_DAMAGE_CORR_PF (type: esriFieldTypeInteger, alias: Pipe, Structural Damage/Corrosion - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• PIPE_STR_DAMAGE_CORR_NOTE (type: esriFieldTypeString, alias: Pipe, Structural Damage/Corrosion - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PIPE_STR_DAMAGE_CORR_FAIL_AMT (type: esriFieldTypeInteger, alias: Pipe, Structural Damage/Corrosion - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPE_ROAD_SETTLEMENT_PF (type: esriFieldTypeInteger, alias: Pipe, Roadway Settlement - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• PIPE_ROAD_SETTLEMENT_NOTE (type: esriFieldTypeString, alias: Pipe, Roadway Settlement - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PIPE_ROAD_SETTLEMENT_FAIL_AMT (type: esriFieldTypeInteger, alias: Pipe, Roadway Settlement - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INLETS_OBSTRUCT_PF (type: esriFieldTypeInteger, alias: Inlets, Obstruction - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• INLETS_OBSTRUCT_NOTE (type: esriFieldTypeString, alias: Inlets, Obstruction - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INLETS_STR_DAMAGE_PF (type: esriFieldTypeInteger, alias: Inlets, Structural Damage - Grates - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• INLETS_STR_DAMAGE_NOTE (type: esriFieldTypeString, alias: Inlets, Structural Damage - Grates - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INLETS_EROSION_PF (type: esriFieldTypeInteger, alias: Inlets, Erosion - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• INLETS_EROSION_NOTE (type: esriFieldTypeString, alias: Inlets, Erosion - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INLETS_SURF_DAMAGE_PF (type: esriFieldTypeInteger, alias: Inlets, Surface Damage - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• INLETS_SURF_DAMAGE_NOTE (type: esriFieldTypeString, alias: Inlets, Surface Damage - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INLETS_APRON_DAMAGE_PF (type: esriFieldTypeInteger, alias: Inlets, Apron Damage - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• INLETS_APRON_DAMAGE_NOTE (type: esriFieldTypeString, alias: Inlets, Apron Damage - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INLETS_JOINT_UNSEAL_PF (type: esriFieldTypeInteger, alias: Inlets, Unsealed Joints - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• INLETS_JOINT_UNSEAL_NOTE (type: esriFieldTypeString, alias: Inlets, Unsealed Joints - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MISC_DRAIN_OBSTRUCT_PF (type: esriFieldTypeInteger, alias: Misc. Drainage, Obstruction - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• MISC_DRAIN_OBSTRUCT_NOTE (type: esriFieldTypeString, alias: Misc. Drainage, Obstruction - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MISC_DRAIN_END_CONDITION_PF (type: esriFieldTypeInteger, alias: Misc. Drainage, End Condition - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• MISC_DRAIN_END_CONDITION_NOTE (type: esriFieldTypeString, alias: Misc. Drainage, End Condition - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MISC_DRAIN_RODENT_SCREEN_PF (type: esriFieldTypeInteger, alias: Misc. Drainage, Under Drain Rodent Screen - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• MISC_DRAIN_RODENT_SCREEN_NOTE (type: esriFieldTypeString, alias: Misc. Drainage, Under Drain Rodent Screen - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MISC_DRAIN_ILLICIT_DISCHG_PF (type: esriFieldTypeInteger, alias: Misc. Drainage, Illicit Discharge - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• MISC_DRAIN_ILLICIT_DISCHG_NOTE (type: esriFieldTypeString, alias: Misc. Drainage, Illicit Discharge - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MOW_HEIGHT_PF (type: esriFieldTypeInteger, alias: Mowing, Grass Height - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• MOW_HEIGHT_NOTE (type: esriFieldTypeString, alias: Mowing, Grass Height - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TREES_OVERHANG_PF (type: esriFieldTypeInteger, alias: Brush and Trees, Overhang - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• TREES_OVERHANG_NOTE (type: esriFieldTypeString, alias: Brush and Trees, Overhang - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TREES_OVERHANG_HEIGHT_PF (type: esriFieldTypeInteger, alias: Brush and Trees, Overhang - Height:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• TREES_VERT_CLEAR_PF (type: esriFieldTypeInteger, alias: Brush and Trees, Vertical Clearance - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• TREES_VERT_CLEAR_NOTE (type: esriFieldTypeString, alias: Brush and Trees, Vertical Clearance - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TREES_SIGN_VISIBILITY_PF (type: esriFieldTypeInteger, alias: Brush and Trees, Sign Visibility - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• TREES_SIGN_VISIBILITY_NOTE (type: esriFieldTypeString, alias: Brush and Trees, Sign Visibility - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TREES_DEAD_LEAN_PF (type: esriFieldTypeInteger, alias: Brush and Trees, Dead or Leaning Tree Hazard - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• TREES_DEAD_LEAN_NOTE (type: esriFieldTypeString, alias: Brush and Trees, Dead or Leaning Tree Hazard - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TREES_SIGHT_DISTANCE_PF (type: esriFieldTypeInteger, alias: Brush and Trees, Sight Distance - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• TREES_SIGHT_DISTANCE_NOTE (type: esriFieldTypeString, alias: Brush and Trees, Sight Distance - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TREES_HEADWALL_PF (type: esriFieldTypeInteger, alias: Brush and Trees, Around Headwall - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• TREES_HEADWALL_NOTE (type: esriFieldTypeString, alias: Brush and Trees, Around Headwall - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TREES_4IN_DIA_OFFSET_PF (type: esriFieldTypeInteger, alias: Brush and Trees, >4in. Trunk Diameter, Road Offset - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• TREES_4IN_DIA_OFFSET_NOTE (type: esriFieldTypeString, alias: Brush and Trees, >4in. Trunk Diameter, Road Offset - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SWEEP_CONT_ACCUM_NO_CNG_PF (type: esriFieldTypeInteger, alias: Sweeping, Continuous Accumulation - Without Curb and Gutter - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SWEEP_CONT_ACCUM_NO_CNG_NOTE (type: esriFieldTypeString, alias: Sweeping, Continuous Accumulation - Without Curb and Gutter - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SWEEP_CONT_ACCUM_CNG_BARR_PF (type: esriFieldTypeInteger, alias: Sweeping, Continuous Accumulation - Curb and Gutter or Concrete Barrier - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SWEEP_CONT_ACCUM_CNG_BARR_NOTE (type: esriFieldTypeString, alias: Sweeping, Continuous Accumulation - Curb and Gutter or Concrete Barrier - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SWEEP_MAX_ACCUM_CNG_BARR_PF (type: esriFieldTypeInteger, alias: Sweeping, Maximum Accumulation - Curb and Gutter or Concrete Barrier - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SWEEP_MAX_ACCUM_CNG_BARR_NOTE (type: esriFieldTypeString, alias: Sweeping, Maximum Accumulation - Curb and Gutter or Concrete Barrier - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TURF_BARE_GROUND_PF (type: esriFieldTypeInteger, alias: Turf Condition, Bare Ground - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• TURF_BARE_GROUND_NOTE (type: esriFieldTypeString, alias: Turf Condition, Bare Ground - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NOISE_WALL_UNWANT_VEG_PF (type: esriFieldTypeInteger, alias: Noise Wall, Unwanted Vegetation - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• NOISE_WALL_UNWANT_VEG_NOTE (type: esriFieldTypeString, alias: Noise Wall, Unwanted Vegetation - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NOISE_WALL_OVERHANG_PF (type: esriFieldTypeInteger, alias: Noise Wall, Overhanging Branches - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• NOISE_WALL_OVERHANG_NOTE (type: esriFieldTypeString, alias: Noise Wall, Overhanging Branches - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NOISE_WALL_DAM_PF (type: esriFieldTypeInteger, alias: Noise Wall, Damage - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• NOISE_WALL_DAM_NOTE (type: esriFieldTypeString, alias: Noise Wall, Damage - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NOISE_WALL_LEANING_VEG_PF (type: esriFieldTypeInteger, alias: Noise Wall, Leaning Vegetation - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• NOISE_WALL_LEANING_VEG_NOTE (type: esriFieldTypeString, alias: Noise Wall, Leaning Vegetation - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RET_WALL_VEG_PF (type: esriFieldTypeInteger, alias: Retaining and MSE Walls, Vegetation - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• RET_WALL_VEG_NOTE (type: esriFieldTypeString, alias: Retaining and MSE Walls, Vegetation - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RET_WALL_BRANCHES_PF (type: esriFieldTypeInteger, alias: Retaining and MSE Walls, Branches - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• RET_WALL_BRANCHES_NOTE (type: esriFieldTypeString, alias: Retaining and MSE Walls, Branches - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GR_CABLE_DAMAGE_PF (type: esriFieldTypeInteger, alias: Guardrail/Cable Barrier, Functional Damage - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• GR_CABLE_DAMAGE_NOTE (type: esriFieldTypeString, alias: Guardrail/Cable Barrier, Functional Damage - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GR_CABLE_DAMAGE_DATE (type: esriFieldTypeDate, alias: Guardrail/Cable Barrier, Functional Damage - Date:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONC_BARRIER_DAMAGE_PF (type: esriFieldTypeInteger, alias: Concrete Barrier, Functional Damage - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• CONC_BARRIER_DAMAGE_NOTE (type: esriFieldTypeString, alias: Concrete Barrier, Functional Damage - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ATTENUATOR_DAMAGE_PF (type: esriFieldTypeInteger, alias: Attenuators, Impact Attenuators - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• ATTENUATOR_DAMAGE_NOTE (type: esriFieldTypeString, alias: Attenuators, Impact Attenuators - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GRAFFITI_PRESENCE_PF (type: esriFieldTypeInteger, alias: Graffiti, Graffiti - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• GRAFFITI_PRESENCE_NOTE (type: esriFieldTypeString, alias: Graffiti, Graffiti - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FENCE_COMPRESSION_PF (type: esriFieldTypeInteger, alias: Fence, Compression - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• FENCE_COMPRESSION_NOTE (type: esriFieldTypeString, alias: Fence, Compression - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FENCE_OPENING_PF (type: esriFieldTypeInteger, alias: Fence, Opening - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• FENCE_OPENING_NOTE (type: esriFieldTypeString, alias: Fence, Opening - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FENCE_OPEN_GATE_PF (type: esriFieldTypeInteger, alias: Fence, Open Gate - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• FENCE_OPEN_GATE_NOTE (type: esriFieldTypeString, alias: Fence, Open Gate - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RET_WALL_SPALL_PF (type: esriFieldTypeInteger, alias: Retaining and MSE Walls, Concrete Spalls - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• RET_WALL_SPALL_NOTE (type: esriFieldTypeString, alias: Retaining and MSE Walls, Concrete Spalls - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RET_WALL_WEEP_HOLE_PF (type: esriFieldTypeInteger, alias: Retaining and MSE Walls, Weep Holes - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• RET_WALL_WEEP_HOLE_NOTE (type: esriFieldTypeString, alias: Retaining and MSE Walls, Weep Holes - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_WARNING_LIGHTS_PF (type: esriFieldTypeInteger, alias: Signs, Visibility - Warning Lights - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• SIGN_WARNING_LIGHTS_NOTE (type: esriFieldTypeString, alias: Signs, Visibility - Warning Lights - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_WARNING_LIGHTS_FAIL_AMT (type: esriFieldTypeInteger, alias: Signs, Visibility - Warning Lights - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_10_PERCENT_DAM_PF (type: esriFieldTypeInteger, alias: Signs, Visibility - 10% Damage - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SIGN_10_PERCENT_DAM_NOTE (type: esriFieldTypeString, alias: Signs, Visibility - 10% Damage - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_10_PERCENT_DAM_FAIL_AMT (type: esriFieldTypeInteger, alias: Signs, Visibility - 10% Damage - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_CONVEYS_MSG_PF (type: esriFieldTypeInteger, alias: Signs, Visibility - Conveys Message - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SIGN_CONVEYS_MSG_NOTE (type: esriFieldTypeString, alias: Signs, Visibility - Conveys Message - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_CONVEYS_MSG_FAIL_AMT (type: esriFieldTypeInteger, alias: Signs, Visibility - Conveys Message - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_ROTATION_PF (type: esriFieldTypeInteger, alias: Signs, Visibility - Rotation - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SIGN_ROTATION_NOTE (type: esriFieldTypeString, alias: Signs, Visibility - Rotation - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_ROTATION_FAIL_AMT (type: esriFieldTypeInteger, alias: Signs, Visibility - Rotation - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_REFLECTIVITY_PF (type: esriFieldTypeInteger, alias: Signs, Visibility - Reflectivity - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SIGN_REFLECTIVITY_NOTE (type: esriFieldTypeString, alias: Signs, Visibility - Reflectivity - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_REFLECTIVITY_FAIL_AMT (type: esriFieldTypeInteger, alias: Signs, Visibility - Reflectivity - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_HEIGHT_CNG_PF (type: esriFieldTypeInteger, alias: Signs, Height - With Curb and Gutter - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SIGN_HEIGHT_CNG_NOTE (type: esriFieldTypeString, alias: Signs, Height - With Curb and Gutter - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_HEIGHT_CNG_FAIL_AMT (type: esriFieldTypeInteger, alias: Signs, Height - With Curb and Gutter - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_HEIGHT_SHLD_PF (type: esriFieldTypeInteger, alias: Signs, Height - Shoulder - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SIGN_HEIGHT_SHLD_NOTE (type: esriFieldTypeString, alias: Signs, Height - Shoulder - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_HEIGHT_SHLD_FAIL_AMT (type: esriFieldTypeInteger, alias: Signs, Height - Shoulder - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_LEAN_PF (type: esriFieldTypeInteger, alias: Signs, Lean - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SIGN_LEAN_NOTE (type: esriFieldTypeString, alias: Signs, Lean - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_LEAN_FAIL_AMT (type: esriFieldTypeInteger, alias: Signs, Lean - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_HARDWARE_PF (type: esriFieldTypeInteger, alias: Signs, Hardware - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SIGN_HARDWARE_NOTE (type: esriFieldTypeString, alias: Signs, Hardware - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_HARDWARE_FAIL_AMT (type: esriFieldTypeInteger, alias: Signs, Hardware - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_BENT_PF (type: esriFieldTypeInteger, alias: Signs, Bent - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SIGN_BENT_NOTE (type: esriFieldTypeString, alias: Signs, Bent - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_BENT_FAIL_AMT (type: esriFieldTypeInteger, alias: Signs, Bent - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_BREAK_SUPPORT_PF (type: esriFieldTypeInteger, alias: Signs, Breakaway Support - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• SIGN_BREAK_SUPPORT_NOTE (type: esriFieldTypeString, alias: Signs, Breakaway Support - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_BREAK_SUPPORT_FAIL_AMT (type: esriFieldTypeInteger, alias: Signs, Breakaway Support - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGN_UCHANNEL_PF (type: esriFieldTypeInteger, alias: Signs, U-Channel - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• SIGN_UCHANNEL_NOTE (type: esriFieldTypeString, alias: Signs, U-Channel support - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIGN_UCHANNEL_FAIL_AMT (type: esriFieldTypeInteger, alias: Signs, U-Channel support - Failure Amount:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJ_MARK_LEANING_PF (type: esriFieldTypeInteger, alias: Object Markers, Leaning - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• OBJ_MARK_LEANING_NOTE (type: esriFieldTypeString, alias: Object Markers, Leaning - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OBJ_MARK_MISSING_PF (type: esriFieldTypeInteger, alias: Object Markers, Missing - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• OBJ_MARK_MISSING_NOTE (type: esriFieldTypeString, alias: Object Markers, Missing - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GLARE_10_PERCENT_DAMAGE_PF (type: esriFieldTypeInteger, alias: Glare Screens, >10% Missing/Damage - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• GLARE_10_PERCENT_DAMAGE_NOTE (type: esriFieldTypeString, alias: Glare Screens, >10% Missing/Damage - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PM_LONG_CLEAR_VIS_PF (type: esriFieldTypeInteger, alias: Pavement Markings, Longitudinal, Longitudinal, Clear and Visable - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail])
• PM_LONG_CLEAR_VIS_NOTE (type: esriFieldTypeString, alias: Pavement Markings, Longitudinal, Clear and Visable - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PM_WORD_CLEAR_VIS_PF (type: esriFieldTypeInteger, alias: Pavement Markings, Words and Symbols, Words and Symbols Clear and Visable - Pass-Fail:, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Pass], [1: Fail], [2: N/A])
• PM_WORD_CLEAR_VIS_NOTE (type: esriFieldTypeString, alias: Pavement Markings, Words and Symbols, Words and Symbols Clear and Visable - Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INSPECTION_GENERAL_NOTES (type: esriFieldTypeString, alias: General Inspection Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CREATED_DATE (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• LAST_EDITED_DATE (type: esriFieldTypeDate, alias: Last Edited Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: PBMI Segments Inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• PBMI_SEGMENTS (0) -- Related To: PBMI Segments (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/28/2026 4:55:43 PM

Schema Last Edit Date: 9/28/2026 4:55:43 PM

Data Last Edit Date: 9/28/2026 4:55:43 PM

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