Road Surface Condition<\/SPAN>. The condition of the road surface can be broken down in a few different ways: <\/SPAN><\/SPAN><\/P>a). The simplest would be the field, \u201cRecommended_Works\u201d. This is a 1-5 ranking that relates to the work required to repair the road. Here is an example screen shot of the rankings from the road data sheets that were sent as part of the project. This gives a fairly clear overview of which roads are in poor shape vs which are in good shape.<\/SPAN><\/SPAN><\/P><\/LI><\/OL><\/LI><\/OL><\/P>
b). For each defect type (ie, each type of crack, such as alligator, longitudinal, transverse, etc ), the severity and density were assessed separately. For instance, a road could have 1 or 2 very deep potholes so the Severity would be high, but the Density (distribution along the whole road segment) would be low. Therefore, you could choose to map the results in a very detailed way by visualizing the severity and/or density of each defect type. Alternatively we created some fields at the end of the attribute table that summarize this information. <\/SPAN><\/SPAN><\/P>\u201cSeverity_Summary\u201d \u2013 for each road segment, this field adds the number of severity scores together and weights them based on if they were Low, Medium, or High. The equation is: (# of Low severity scores x 1)+(# of Medium severity scores x 2)+(# of High severity scores x 3) = Severity Summary Score<\/SPAN><\/SPAN><\/P><\/LI><\/OL>\u201cDensity_Summary\u201d \u2013 same as above, but for density<\/SPAN><\/SPAN><\/P><\/LI><\/OL>\u201cSeverity_Plus_Density\u201d \u2013 Sum of \u201cSeverity_Summary\u201d and \u201cDensity_Summary\u201d.<\/SPAN><\/SPAN><\/P><\/LI><\/OL><\/LI><\/OL>Road Base Condition:<\/SPAN><\/SPAN> There was not a detailed condition assessment of the road base done during this assessment. I believe a part of the recommendations from the project were to undertake geotechnical investigations to confirm road base condition. We do have one field that notes if road base failure was evident \u2013 \u201cRoad_Base_Failure_Yes_No\"<\/SPAN><\/SPAN><\/P><\/LI><\/OL>I hope this answers your questions, but if you need anything further please let me know.<\/SPAN><\/SPAN><\/P>Thanks,<\/SPAN><\/SPAN><\/P>Brendan<\/SPAN><\/SPAN><\/P><\/P>
<\/P>
<\/P><\/DIV><\/DIV><\/DIV>",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": true,
"relationships": [],
"isDataVersioned": false,
"isDataArchived": true,
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": true,
"startArchivingMoment": 1644014491000
},
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": true,
"supportsCalculate": true,
"supportsASyncCalculate": true,
"supportsDatumTransformation": true,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsQueryWithDatumTransformation": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
]
},
"hasGeometryProperties": true,
"geometryProperties": {
"shapeLengthFieldName": "Shape__Length",
"units": "esriMeters"
},
"hasMetadata": true,
"extent": {
"xmin": 563496.9490999999,
"ymin": 5607297.1205,
"xmax": 566225.3550000004,
"ymax": 5610594.5001,
"spatialReference": {
"wkid": 26911,
"latestWkid": 26911,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"sourceSpatialReference": {
"wkid": 26911,
"latestWkid": 26911,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -5120900,
"falseY": -9998100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": 0,
"mUnits": 1
},
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
156,
156,
156,
255
],
"width": 1
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"hasM": false,
"hasZ": true,
"enableZDefaults": false,
"supportsVCSProjection": true,
"allowGeometryUpdates": true,
"allowTrueCurvesUpdates": true,
"onlyAllowTrueCurveUpdatesByTrueCurveClients": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": true,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "STREETNAME",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "ASSET_ID",
"type": "esriFieldTypeString",
"alias": "ASSET_ID",
"domain": null,
"editable": true,
"nullable": false,
"length": 15,
"defaultValue": null,
"modelName": "ASSET_ID"
},
{
"name": "HIST_RID",
"type": "esriFieldTypeString",
"alias": "HIST_RID",
"domain": null,
"editable": true,
"nullable": false,
"length": 15,
"defaultValue": null,
"modelName": "HIST_RID"
},
{
"name": "STREETNAME",
"type": "esriFieldTypeString",
"alias": "STREETNAME",
"domain": null,
"editable": true,
"nullable": false,
"length": 45,
"defaultValue": null,
"modelName": "STREETNAME"
},
{
"name": "SURFACE",
"type": "esriFieldTypeString",
"alias": "SURFACE",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "SURFACE"
},
{
"name": "ROAD_CAT",
"type": "esriFieldTypeSmallInteger",
"alias": "ROAD_CAT",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "ROAD_CAT"
},
{
"name": "ROAD_TYPE",
"type": "esriFieldTypeString",
"alias": "ROAD_TYPE",
"domain": null,
"editable": true,
"nullable": false,
"length": 40,
"defaultValue": null,
"modelName": "ROAD_TYPE"
},
{
"name": "RD_CLASS",
"type": "esriFieldTypeString",
"alias": "RD_CLASS",
"domain": null,
"editable": true,
"nullable": false,
"length": 25,
"defaultValue": null,
"modelName": "RD_CLASS"
},
{
"name": "YRBUILT",
"type": "esriFieldTypeSmallInteger",
"alias": "YRBUILT",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "YRBUILT"
},
{
"name": "INSERVICE",
"type": "esriFieldTypeSmallInteger",
"alias": "INSERVICE",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "INSERVICE"
},
{
"name": "SW_SIDES",
"type": "esriFieldTypeSmallInteger",
"alias": "SW_SIDES",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "SW_SIDES"
},
{
"name": "SW_LENGTH",
"type": "esriFieldTypeDouble",
"alias": "SW_LENGTH",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "S_LENGH"
},
{
"name": "CRB_SIDES",
"type": "esriFieldTypeSmallInteger",
"alias": "CRB_SIDES",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "CURB_SIDES"
},
{
"name": "CRB_LENGTH",
"type": "esriFieldTypeString",
"alias": "CRB_LENGTH",
"domain": null,
"editable": true,
"nullable": false,
"length": 25,
"defaultValue": null,
"modelName": "CRB_LENGTH"
},
{
"name": "CRB_LENGTH1",
"type": "esriFieldTypeDouble",
"alias": "CRB_LENGTH1",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CRB_LENGTH1"
},
{
"name": "CRB_LENGTH2",
"type": "esriFieldTypeDouble",
"alias": "CRB_LENGTH2",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CRB_LENGTH2"
},
{
"name": "T_LENGTH",
"type": "esriFieldTypeDouble",
"alias": "T_LENGTH",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "T_LENGTH"
},
{
"name": "OWNERSHIP",
"type": "esriFieldTypeString",
"alias": "OWNERSHIP",
"domain": null,
"editable": true,
"nullable": false,
"length": 15,
"defaultValue": null,
"modelName": "OWNERSHIP"
},
{
"name": "OWNERNAME",
"type": "esriFieldTypeString",
"alias": "OWNERNAME",
"domain": null,
"editable": true,
"nullable": false,
"length": 30,
"defaultValue": null,
"modelName": "OWNERNAME"
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "STATUS",
"domain": null,
"editable": true,
"nullable": false,
"length": 15,
"defaultValue": null,
"modelName": "STATUS"
},
{
"name": "OP_STATUS",
"type": "esriFieldTypeString",
"alias": "OP_STATUS",
"domain": null,
"editable": true,
"nullable": false,
"length": 15,
"defaultValue": null,
"modelName": "OP_STATUS"
},
{
"name": "TCA_STATUS",
"type": "esriFieldTypeString",
"alias": "TCA_STATUS",
"domain": null,
"editable": true,
"nullable": false,
"length": 15,
"defaultValue": null,
"modelName": "TCA_STATUS"
},
{
"name": "REM_LIFE",
"type": "esriFieldTypeString",
"alias": "REM_LIFE",
"domain": null,
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "REM_LIFE"
},
{
"name": "SURF_COND",
"type": "esriFieldTypeSmallInteger",
"alias": "SURF_COND",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "SURF_COND"
},
{
"name": "USELIFE_SURF",
"type": "esriFieldTypeSmallInteger",
"alias": "USELIFE_SURF",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "USELIFE_SURF"
},
{
"name": "USELIFE_BASE",
"type": "esriFieldTypeSmallInteger",
"alias": "USELIFE_BASE",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "USELIFE_BASE"
},
{
"name": "COMMENTS",
"type": "esriFieldTypeString",
"alias": "COMMENTS",
"domain": null,
"editable": true,
"nullable": true,
"length": 80,
"defaultValue": null,
"modelName": "COMMENTS"
},
{
"name": "ASSET_SORT",
"type": "esriFieldTypeSmallInteger",
"alias": "ASSET_SORT",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "ASSET_SORT"
},
{
"name": "MOD_DESC",
"type": "esriFieldTypeString",
"alias": "MOD_DESC",
"domain": null,
"editable": true,
"nullable": true,
"length": 70,
"defaultValue": null,
"modelName": "MOD_DESC"
},
{
"name": "MOD_BY",
"type": "esriFieldTypeString",
"alias": "MOD_BY",
"domain": null,
"editable": true,
"nullable": true,
"length": 15,
"defaultValue": null,
"modelName": "MOD_BY"
},
{
"name": "MOD_DATE",
"type": "esriFieldTypeDate",
"alias": "MOD_DATE",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "MOD_DATE"
},
{
"name": "TCA_NOTES",
"type": "esriFieldTypeString",
"alias": "TCA_NOTES",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "TCA_NOTES"
},
{
"name": "INSPECTIONS",
"type": "esriFieldTypeString",
"alias": "INSPECTIONS",
"domain": null,
"editable": true,
"nullable": true,
"length": 150,
"defaultValue": null,
"modelName": "INSPECTIONS"
},
{
"name": "RDCAT2011",
"type": "esriFieldTypeSmallInteger",
"alias": "RDCAT2011",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "RDCAT2011"
},
{
"name": "GIS_Length",
"type": "esriFieldTypeInteger",
"alias": "GIS_Length",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "GIS_Length"
},
{
"name": "NameLength",
"type": "esriFieldTypeString",
"alias": "NameLength",
"domain": null,
"editable": true,
"nullable": true,
"length": 80,
"defaultValue": null,
"modelName": "NameLength"
},
{
"name": "BASE_DATE",
"type": "esriFieldTypeSmallInteger",
"alias": "BASE DATE",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "BASE_DATE"
},
{
"name": "SURF_DATE",
"type": "esriFieldTypeSmallInteger",
"alias": "SURF DATE",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "SURF_DATE"
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "created_user"
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "created_date"
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "last_edited_user"
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "last_edited_date"
},
{
"name": "NEWID",
"type": "esriFieldTypeString",
"alias": "NEWID",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "NEWID"
},
{
"name": "OLDID",
"type": "esriFieldTypeString",
"alias": "OLDID",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "OLDID"
},
{
"name": "Density_Summary",
"type": "esriFieldTypeSmallInteger",
"alias": "Density Summary",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Density_Summary"
},
{
"name": "Recommended_Timing",
"type": "esriFieldTypeString",
"alias": "Recommended Timing",
"domain": null,
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "Recommended_Timing"
},
{
"name": "Recommended_Works",
"type": "esriFieldTypeSmallInteger",
"alias": "Recommended Works",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Recommended_Works"
},
{
"name": "Road_Base_Failure_Yes_No",
"type": "esriFieldTypeString",
"alias": "Evidence of Road Base Failure",
"domain": null,
"editable": true,
"nullable": true,
"length": 5,
"defaultValue": null,
"modelName": "Road_B_YN"
},
{
"name": "Severity_Plus_Density",
"type": "esriFieldTypeSmallInteger",
"alias": "Severity Plus Density",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Severity_Plus_Density"
},
{
"name": "Severity_Summary",
"type": "esriFieldTypeSmallInteger",
"alias": "Severity_Summary",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Severity_Summary"
},
{
"name": "Inspection_Date",
"type": "esriFieldTypeDate",
"alias": "Inspection Date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "Inspection_Date"
},
{
"name": "Inspector",
"type": "esriFieldTypeString",
"alias": "Inspector",
"domain": null,
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "Inspector"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "Shape__Length",
"type": "esriFieldTypeDouble",
"alias": "Shape.STLength()",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "Shape.STLength()"
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "Shape"
},
"indexes": [
{
"name": "UUID_2086",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "gdb_ct3_2086",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "S1519_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"types": [],
"templates": [
{
"name": "Roads",
"description": "",
"prototype": {
"attributes": {
"Inspector": null,
"ASSET_ID": " ",
"HIST_RID": " ",
"STREETNAME": " ",
"SURFACE": null,
"ROAD_CAT": null,
"ROAD_TYPE": " ",
"RD_CLASS": " ",
"YRBUILT": 0,
"INSERVICE": 0,
"SW_SIDES": 0,
"SW_LENGTH": 0,
"CRB_SIDES": 0,
"CRB_LENGTH": " ",
"CRB_LENGTH1": null,
"CRB_LENGTH2": null,
"T_LENGTH": 0,
"OWNERSHIP": " ",
"OWNERNAME": " ",
"STATUS": " ",
"OP_STATUS": " ",
"TCA_STATUS": " ",
"REM_LIFE": null,
"SURF_COND": null,
"USELIFE_SURF": null,
"USELIFE_BASE": null,
"COMMENTS": null,
"ASSET_SORT": null,
"MOD_DESC": null,
"MOD_BY": null,
"MOD_DATE": null,
"TCA_NOTES": null,
"INSPECTIONS": null,
"RDCAT2011": null,
"GIS_Length": null,
"NameLength": null,
"BASE_DATE": null,
"SURF_DATE": null,
"created_user": null,
"created_date": null,
"last_edited_user": null,
"last_edited_date": null,
"NEWID": null,
"OLDID": null,
"Density_Summary": null,
"Recommended_Timing": null,
"Recommended_Works": null,
"Road_Base_Failure_Yes_No": null,
"Severity_Plus_Density": null,
"Severity_Summary": null,
"Inspection_Date": null
}
},
"drawingTool": "esriFeatureEditToolLine"
}
],
"maxRecordCount": 2000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking",
"useStandardizedQueries": true,
"standardMaxRecordCount": 8000,
"tileMaxRecordCount": 4000,
"standardMaxRecordCountNoGeometry": 32000,
"maxRecordCountFactor": 1,
"serviceItemId": "e78da369ed9a48a086985e0f28abf62d"
}