{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Rock Cut - Inspections", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "INSPECTORS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ROCK_CUT_ID", "type": "esriFieldTypeString", "alias": "Rock Cut ID", "length": 255, "domain": null }, { "name": "ROCK_CUT_NUMBER", "type": "esriFieldTypeInteger", "alias": "Rock Cut Number", "domain": null }, { "name": "INSPECTORS", "type": "esriFieldTypeString", "alias": "Inspectors", "length": 50, "domain": null }, { "name": "INSPECTION_DATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "VISIT_TYPE", "type": "esriFieldTypeString", "alias": "Visit Type", "length": 1, "domain": { "type": "codedValue", "name": "GeoTech_VisitType", "description": "Domain for visit type", "codedValues": [ { "name": "Inspection", "code": "I" }, { "name": "Rockfall", "code": "R" }, { "name": "Request", "code": "Q" }, { "name": "Data update", "code": "D" }, { "name": "Lidar", "code": "L" }, { "name": "UAS", "code": "U" }, { "name": "Other", "code": "O" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HAZARD_TYPE", "type": "esriFieldTypeString", "alias": "Hazard Type", "length": 1, "domain": { "type": "codedValue", "name": "GeoTech_HazardType", "description": "Domain for hazard type", "codedValues": [ { "name": "Rock", "code": "R" }, { "name": "Hybrid", "code": "H" }, { "name": "Soil", "code": "S" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GENERAL_COMMENTS", "type": "esriFieldTypeString", "alias": "General Comments", "length": 1000, "domain": null }, { "name": "MITIGATION_COMMENTS", "type": "esriFieldTypeString", "alias": "Mitigation Comments", "length": 1000, "domain": null }, { "name": "FINAL_RATING", "type": "esriFieldTypeString", "alias": "Final Rating", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_CutRating", "description": "Domain for cut rating", "codedValues": [ { "name": "A", "code": "A" }, { "name": "B+", "code": "B+" }, { "name": "B", "code": "B" }, { "name": "C", "code": "C" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RHR", "type": "esriFieldTypeSmallInteger", "alias": "Rock Hazard Rating Score", "domain": null }, { "name": "ROCK_TYPE", "type": "esriFieldTypeString", "alias": "Rock Type", "length": 255, "domain": null }, { "name": "PREDOMINATE_FAILURE_TYPE", "type": "esriFieldTypeString", "alias": "Predominant Failure Type", "length": 35, "domain": null }, { "name": "SLOPE_PRESPLIT", "type": "esriFieldTypeString", "alias": "Slope Presplit", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_Yes_No", "description": "Domain for Yes No fields", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SLOPE_RAMP_BENCH", "type": "esriFieldTypeString", "alias": "Slope Ramp/Bench", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_Yes_No", "description": "Domain for Yes No fields", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SLOPE_OVERHANGS", "type": "esriFieldTypeString", "alias": "Slope Overhangs", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_SlopeOverhangs", "description": "Domain for amount of slope overhangs", "codedValues": [ { "name": "None", "code": "N" }, { "name": "Some overhangs", "code": "SO" }, { "name": "Overhangs", "code": "O" }, { "name": "Large overhangs", "code": "LO" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BLOCK_GEOMETRY", "type": "esriFieldTypeString", "alias": "Block Geometry", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_BlockGeometry", "description": "Domain for block geometry", "codedValues": [ { "name": "Platy", "code": "P" }, { "name": "Tabular", "code": "T" }, { "name": "Blocky", "code": "B" }, { "name": "Round", "code": "R" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BLOCK_SIZE_PER_EVENT", "type": "esriFieldTypeString", "alias": "Block Size or Volume per Event", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_BlockSize", "description": "Domain for block size or volume per event", "codedValues": [ { "name": "1 ft or 3 yrd (cubed)", "code": "1" }, { "name": "2 ft or 6 yrd (cubed)", "code": "2" }, { "name": "3 ft or 9 yrd (cubed)", "code": "3" }, { "name": ">4 ft or >12 yrd (cubed)", "code": ">4" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OVERALL_MOISTURE_CONTENT", "type": "esriFieldTypeString", "alias": "Overall Moisture Content", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_Moisture", "description": "Domain for overall moisture content", "codedValues": [ { "name": "Dry", "code": "DY" }, { "name": "Damp", "code": "DA" }, { "name": "Seepage", "code": "S" }, { "name": "Flow", "code": "F" }, { "name": "Heavy Flow", "code": "HF" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ROCKFALL_FREQUENCY", "type": "esriFieldTypeString", "alias": "Rockfall Frequency", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_RockfallFrequency", "description": "Domain for rockfall frequency", "codedValues": [ { "name": "None", "code": "N" }, { "name": ">2 years", "code": "2" }, { "name": "1 or 2 years", "code": "1" }, { "name": "Yearly or Seasonal", "code": "Y" }, { "name": "Year Round or Severe Events", "code": "S" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "JOINT_ORIENTATION", "type": "esriFieldTypeString", "alias": "Joint Orientation\n", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_JointOrientation", "description": "Domain for joint orientation", "codedValues": [ { "name": "Discontinuous with favorable orientations", "code": "DF" }, { "name": "Discontinuous with random (both favorable and unfavorable) orientations", "code": "DR" }, { "name": "Discontinuous with adverse orientations", "code": "DA" }, { "name": "Continuous joints with adverse orientations", "code": "CJ" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ROCK_FRICTION", "type": "esriFieldTypeString", "alias": "Rock Friction", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_RockFriction", "description": "Domain for rock friction", "codedValues": [ { "name": "Rough/Irregular", "code": "R" }, { "name": "Undulating", "code": "U" }, { "name": "Planar", "code": "P" }, { "name": "Data not available", "code": "NA" }, { "name": "Clay-infilled or slickensided", "code": "C" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DIFFERENTIAL_EROSION_FEATURES", "type": "esriFieldTypeString", "alias": "Differential Erosion Features", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_ErosionFeatures", "description": "Domain for differential erosion features", "codedValues": [ { "name": "Few", "code": "F" }, { "name": "Occasional", "code": "O" }, { "name": "Many", "code": "MY" }, { "name": "Major", "code": "MJ" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DIFFERENTIAL_EROSION_RATE", "type": "esriFieldTypeString", "alias": "Differential Erosion Rate", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_ErosionRate", "description": "Domain for differential erosion rate", "codedValues": [ { "name": "Small", "code": "S" }, { "name": "Moderate", "code": "M" }, { "name": "Large", "code": "L" }, { "name": "Extreme", "code": "E" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DITCH_WIDTH", "type": "esriFieldTypeSmallInteger", "alias": "Ditch Width", "domain": null }, { "name": "DITCH_DEPTH_MEASURED", "type": "esriFieldTypeString", "alias": "Ditch Depth Measured", "length": 35, "domain": null }, { "name": "ROCKFALL_OVERWHELM_DITCH", "type": "esriFieldTypeString", "alias": "Rockfall Overwhelm Ditch", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_Yes_No", "description": "Domain for Yes No fields", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PERCENT_RETAINED_IN_DITCH", "type": "esriFieldTypeSmallInteger", "alias": "Percent Retained in Ditch", "domain": { "type": "range", "name": "GeoTech_RetainInDitch", "description": "Domain for percent of rockfall retain in ditch", "range": [ 0, 100 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SLOPE_PROFILE", "type": "esriFieldTypeString", "alias": "Slope Profile", "length": 35, "domain": null }, { "name": "SLOPE_LENGTH", "type": "esriFieldTypeSmallInteger", "alias": "Slope Length", "domain": null }, { "name": "SLOPE_HEIGHT", "type": "esriFieldTypeSmallInteger", "alias": "Slope Height", "domain": null }, { "name": "SLOPE_HEIGHT_SCORE", "type": "esriFieldTypeSmallInteger", "alias": "Slope Height Score", "domain": null }, { "name": "SLOPE_ANGLE_DIP", "type": "esriFieldTypeString", "alias": "Slope Angle and Direction", "length": 50, "domain": null }, { "name": "PAVED_WIDTH", "type": "esriFieldTypeSmallInteger", "alias": "Paved Width", "domain": null }, { "name": "PAVED_WIDTH_SCORE", "type": "esriFieldTypeSmallInteger", "alias": "Paved Width Score\n", "domain": null }, { "name": "SPEED_LIMIT", "type": "esriFieldTypeSmallInteger", "alias": "Speed Limit", "domain": { "type": "codedValue", "name": "GeoTech_SpeedLimit", "description": "Domain for speed limit", "codedValues": [ { "name": "20 MPH", "code": 20 }, { "name": "25 MPH", "code": 25 }, { "name": "30 MPH", "code": 30 }, { "name": "35 MPH", "code": 35 }, { "name": "40 MPH", "code": 40 }, { "name": "45 MPH", "code": 45 }, { "name": "50 MPH", "code": 50 }, { "name": "55 MPH", "code": 55 }, { "name": "60 MPH", "code": 60 }, { "name": "65 MPH", "code": 65 }, { "name": "Data not available", "code": -99 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AADT", "type": "esriFieldTypeInteger", "alias": "AADT\n", "domain": null }, { "name": "AADT_YEAR", "type": "esriFieldTypeString", "alias": "AADT Year", "length": 4, "domain": null }, { "name": "CUMULATIVE_ACCIDENT_HISTORY", "type": "esriFieldTypeString", "alias": "Cumulative Accident History", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_Accident", "description": "Domain for cumulative accident history", "codedValues": [ { "name": "None", "code": "N" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": ">4", "code": ">4" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AVERAGE_VEHICLE_RISK_SCORE", "type": "esriFieldTypeSmallInteger", "alias": "Average Vehicle Risk\n", "domain": null }, { "name": "SIGHT_DISTANCE", "type": "esriFieldTypeSmallInteger", "alias": "Sight Distance", "domain": null }, { "name": "SIGHT_DISTANCE_SCORE", "type": "esriFieldTypeSmallInteger", "alias": "Sight Distance Score", "domain": null }, { "name": "ROCKFALL_VOLUME", "type": "esriFieldTypeString", "alias": "Rockfall Volume", "length": 4, "domain": { "type": "codedValue", "name": "GeoTech_RockfallVolume", "description": "Domain for recent rockfall volume", "codedValues": [ { "name": "Less than one yard", "code": "<1" }, { "name": "One to five yards", "code": "1-5" }, { "name": "Six to 10 yards", "code": "6-10" }, { "name": "Greater than 10 yards", "code": ">10" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ROCKFALL_REACH_ROAD", "type": "esriFieldTypeString", "alias": "Rockfall Reach Road", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_ReachRoad", "description": "Domain for reach roadway", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Shoulder only", "code": "S" }, { "name": "Travel lane", "code": "T" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ROCKFALL_BLOCKS_INVOLVED", "type": "esriFieldTypeString", "alias": "Rockfall Blocks Involved", "length": 2, "domain": { "type": "codedValue", "name": "GeoTech_BlocksInvolved", "description": "Domain for block size involved", "codedValues": [ { "name": "Single block", "code": "S" }, { "name": "Many blocks", "code": "M" }, { "name": "Data not available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LARGEST_ROCK", "type": "esriFieldTypeString", "alias": "Size of Largest Fallen Rock", "length": 255, "domain": null }, { "name": "PROJECT_NUMBER", "type": "esriFieldTypeString", "alias": "Project Number", "length": 75, "domain": null }, { "name": "YEAR_REMEDIATED", "type": "esriFieldTypeString", "alias": "Year Remediated", "length": 75, "domain": null }, { "name": "ASSET", "type": "esriFieldTypeString", "alias": "Asset", "length": 255, "domain": null }, { "name": "REL_GID", "type": "esriFieldTypeGUID", "alias": "REL_GID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_794", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G26755REL_GID", "fields": "REL_GID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_794", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GDB_HWY.HWY_ADMIN.GeoTech_Points", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "REL_GID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1711116861000 } }