Appendix J_Database_Data_Dictionary.xlsx
XLSX spreadsheet 36 KB Posted
- Solicitation number
- 693C7322R000014
View the file
Other files
Show all 25
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
CUMULATIVE_STATUS
| CUMULATIVE_STATUS | ||||
| COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COMMENTS |
| OBJECTID | NUMBER(38,0) | No | Internal sequential number required by ESRI Geodatabase. | |
| GLOBAL_ID | VARCHAR2(38 CHAR) | No | Global ID - Unique identifier with time stamp | |
| AGENCY | VARCHAR2(5 BYTE) | No | Land Management Agency (NPS, BOR, FWS) | |
| UNIT_ID | VARCHAR2(10 BYTE) | No | Unique code assigned within orginazation to differenciate collection units (NPS- PARK_ALPHA, FWS - ORG_CODE, BOR-AREA_OFFICE) | |
| CYCLE | NUMBER(2,1) | No | 6 | Current RIP cycle |
| INITIALS | VARCHAR2(5 BYTE) | No | Initials of person making adjustment to database | |
| ENTRY_DATE | DATE | No | Date of change | |
| COMMENTS | VARCHAR2(200 BYTE) | No | These notes indicate how the park database has progressed through the various stages of processing toward final completion status. | |
| UNIT_NAME | VARCHAR2(100 BYTE) | No | Name of Unit |
EXCEPTION_NOTES
| EXCEPTION_NOTES | ||||
| COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COMMENTS |
| OBJECTID | NUMBER(38,0) | No | Internal sequential number required by ESRI Geodatabase. | |
| GLOBAL_ID | VARCHAR2(38 CHAR) | No | Global ID - Unique identifier with time stamp | |
| AGENCY |
tc={6234A052-408E-4776-AEC5-50165B9F5BAD}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| How do we determine overlaps - FWS & BOR both have the same parking lots when the names are different | VARCHAR2(5 BYTE) | No | Land Management Agency (NPS, BOR, FWS) | ||
| COLLECTION_TYPE | |||||
| ROUTE_IDENT | VARCHAR2(15 BYTE) | No | Unique record identifier: PARK_ALPHA – RTE_NO | ||
| CYCLE | NUMBER(2,1) | No | 6 | Current RIP cycle | |
| UNIT_ID | VARCHAR2(4 BYTE) | No | Unique four letter code assigned to NPS unit. | ||
| ENTRY_DATE | DATE | No | Date of change | ||
| INITIALS | VARCHAR2(5 BYTE) | No | Initials of person making adjustment to database | ||
| REMARKS | CLOB | Yes | Remarks for the data contractor | ||
| BEG_MP | NUMBER(7,3) | No | Starting Mile Point | ||
| END_MP | NUMBER(7,3) | Yes | Ending Mile Point | ||
| REASON | VARCHAR2(25 BYTE) | Yes | Reason | ||
| FORCED_PCR | NUMBER(1,0) | Yes | Forced PCR Flag: Identifies when a DCV route has a majority of its PCR assessed manually. Default: “0” (No majority or forced PCR). Flag: “1” (Forced PCR on majority of route). | ||
| PCR | NUMBER(3,0) | Yes | Pavement Condition Rating |
FEATURES
| FEATURES | ||||||
| COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | CONSTRAINT | USE A LOOKUP TABLE | COMMENTS |
| OBJECTID | NUMBER(38,0) | No | No | Internal sequential number required by ESRI Geodatabase. | ||
| GLOBAL_ID | VARCHAR2(38 CHAR) | No | No | Global ID - Unique identifier with time stamp | ||
| AGENCY | VARCHAR2(5 BYTE) | No | FK | Yes | Land Management Agency (NPS, BOR, FWS) | |
| REGION | VARCHAR2(100 BYTE) | Yes | Yes | Internal Agency Region | ||
| ROUTE_IDENT | VARCHAR2(25 BYTE) | No | FK | No | Unique record identifier: PARK_ALPHA – RTE_NO | |
| UNIT_ID | VARCHAR2(10 BYTE) | No | FK | Yes | Unique code assigned within orginazation to differenciate collection units (NPS- PARK_ALPHA, FWS - ORG_CODE, BOR-AREA_OFFICE) | |
| CYCLE_COLLECTED | NUMBER(2,1) | RIP cycle feature was collected | ||||
| INSP_DATE | DATE | Data Collection Date | ||||
| ASSET_TYPE | Road or Parking lot | |||||
| FEATURE_EVENT | FK | Feature Type - pulled from Lookup table | ||||
| EVENT_DESCRIPTION | MP or speed limit | |||||
| FEATURE_GEOMETRY | Line or Point | |||||
| EVENT_CODE | Sign or agency code | |||||
| STR_NUMBER | Structure number - BIP,WIP # etc | |||||
| BEG_MP | Starting Mile Point | |||||
| END_MP | Ending Mile Point | |||||
| BEG_LAT | GPS Latitude Coordinate at BEG_MP (decimal degrees) | |||||
| BEG_LON | GPS Longitude Coordinate at BEG_MP (decimal degrees) | |||||
| END_LAT | GPS Latitude Coordinate at END_MP (decimal degrees) | |||||
| END_LON | GPS Longitude Coordinate at END_MP (decimal degrees) | |||||
| SIDE | Event Location relative to lane driven. No blank entries allowed. | |||||
| CURB | VARCHAR2(35 BYTE) | No | 'NOT APPLICABLE' | Type of Curb present anywhere in Parking Lots - Curb is NOT collected for any roads. Please see the CURB_TYPES table for a listing of the possible Curb types. | ||
| CURB_GUTTER | VARCHAR2(35 BYTE) | No | 'NOT APPLICABLE' | Type of Curb and Gutter present anywhere in Parking Lots - Curb is NOT collected for any roads. Please see the CURB_GUTTER_TYPES table for a listing of the possible Curb and Gutter types. | ||
| CURB_RECOMMENDATION | VARCHAR2(20 BYTE) | No | 'NOT APPLICABLE' | Manually Assigned Curb Rating. Please see the CURB_RECOMMENDATIONS table for a listing of the possible Curb ratings. | ||
| AVG_CURB_REVEAL | NUMBER(2,0) | Yes | NULL | Average height of Curb visible (rounded to nearest inches). Used only on Parking Lots - Curb is NOT collected for any roads. | ||
| ADA_SPACES | NUMBER(3,0) | Yes | Description Needed | |||
| LIGHTPOLES | NUMBER(3,0) | Yes | Description Needed | |||
| PKG_SPACES | NUMBER(4,0) | Yes | Number of parking spaces |
PARKING Feature Class
| PARKING Feature Class | ||||
| COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COMMENTS |
| OBJECTID | NUMBER(38,0) | No | Internal sequential number required by ESRI Geodatabase. | |
| GLOBAL_ID | VARCHAR2(38 CHAR) | No | Global ID - Unique identifier with time stamp | |
| SHAPE | ST_GEOMETRY | Yes | ESRI Generated field holding the types of geometry (ST_GEOMETRY) | |
| AGENCY | VARCHAR2(5 BYTE) | No | Land Management Agency (NPS, BOR, FWS) | |
| ROUTE_IDENT | VARCHAR2(15 BYTE) | No | Unique record identifier: PARK_ALPHA – RTE_NO | |
| CYCLE | NUMBER(2,1) | No | Current RIP cycle | |
| UNIT_ID | VARCHAR2(10 BYTE) | No | Unique code assigned within orginazation to differenciate collection units (NPS- PARK_ALPHA, FWS - ORG_CODE, BOR-AREA_OFFICE) | |
| ROUTE_NUM | VARCHAR2(15 BYTE) | No | FWS Route Number. Extracted from the NAT_RTE_ID. | |
| SURF_TYPE | VARCHAR2(2 BYTE) | No | Surface type for the majority of the route. Please see the SURFACE_TYPES table for a listing of the possible PAVED and UNPAVED surface types. | |
| LOT_AREA | NUMBER(11,2) | Yes | BOR database field; Same as SQFT. Consider removal. | |
| SQ_FEET | NUMBER(7,0) | No | -1 | Area of route in square feet. |
| CENT_LAT | NUMBER(9,6) | Yes | GPS Latitude Coordinate at route centroid (decimal degrees) | |
| CENT_LONG | NUMBER(9,6) | Yes | GPS Longitude Coordinate at route centroid (decimal degrees) | |
| SHAPE.AREA | Double | |||
| SHAPE.LEN | Double |
ROAD_CONDITION
| ROAD_CONDITION | ||||
| COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COMMENTS |
| OBJECTID | NUMBER(38,0) | No | Internal sequential number required by ESRI Geodatabase. | |
| GLOBAL_ID | VARCHAR2(38 CHAR) | No | Global ID - Unique identifier with time stamp | |
| AGENCY | VARCHAR2(5 BYTE) | No | Land Management Agency (NPS, BOR, FWS) | |
| UNIT_ID | VARCHAR2(10 BYTE) | No | Unique code assigned within orginazation to differenciate collection units (NPS- PARK_ALPHA, FWS - ORG_CODE, BOR-AREA_OFFICE) | |
| ROUTE_IDENT | VARCHAR2(15 BYTE) | No | Unique record identifier: PARK_ALPHA – RTE_NO | |
| ROUTE_NUM | VARCHAR2(15 BYTE) | No | FHWA-RIP Route Number unique to linear referencing system | |
| CYCLE | NUMBER(2,1) | Yes | The Cycle that the data was collected. Routes that were not collected should be coded as NC. | |
| STATE | VARCHAR2(2 BYTE) | No | ALL: State abbreviation in which the interval is located. |
SURF_TYPE VARCHAR2(2 BYTE) No ALL: Surface type for interval of road being collected. Please see the SURFACE_TYPES table for a listing of the possible PAVED and UNPAVED surface types.
COLL_METHOD VARCHAR2(10 BYTE) No ALL: Method by which the data is collected.
INSP_DATE DATE Yes ALL: Data Collection Date.
INSPECTOR VARCHAR2(30 BYTE) Yes ALL: Name of the field collector
BEG_MP NUMBER(7,3) No ALL: Starting Mile Point
END_MP NUMBER(7,3) No ALL: Ending Mile Point
INT_LENGTH NUMBER(x,x) Yes ALL: Interval Length = Measured in feet (END_MP - BEG_MP) * 5280)
| RTE_LENGTH | NUMBER(7,3) | Yes | Length of route in miles. Calculated from GIS or prior GPS readings | |
| NUM_LANES | NUMBER(1,0) | No | -1 | Number of travel lanes on route. |
| LANE_NO | NUMBER(1,0) | Yes | The number assigned to the lane in which the DCV collected data. Numbered 1,2,3, etc. from centerline or median from left to right. | |
| LANE_WIDTH | NUMBER(7,1) | No | -1 | ALL: Lane Width = From inside centerline to inside fogline. When there is no fogline present, from inside centerline to edge-of-pavement. When no striping at all, one-half PAVE_WIDTH (for 2-lane roads). |
ROAD_WIDTH NUMBER(7,1) No -1 ALL: Paved Width = From edge-of-pavement to edge-of-pavement.
| SHOULDER_WIDTH_R | NUMBER(7,1) | Yes | Fog line to pavement edge |
| SHOULDER_WIDTH_L | NUMBER(7,1) | Yes | Fog line to pavement edge |
| FUNCTIONAL_CLASS | NVARCHAR2(10 CHAR) | Yes | |
| REMARKS | CLOB | Yes | ALL: Any remarks needed regarding the collection or data of the tenth section. |
| URGENT_REMARKS | NVARCHAR2(255 CHAR) | Yes | Urgent remarks on record and data collection operations. |
| REMARKS_REPORT | CLOB | Yes | Remarks describing special circumstances related to this park that will appear exactly as written in the report. |
| TREATMENT | VARCHAR2(50 BYTE) | Yes | ALL: Recommended repair type based on distress ratings. |
TREATMENT_COST NUMBER(9,0) Yes ALL: Cost of recommended repair for this section.
TREATMENT_DESCRIPTION VARCHAR2(255 BYTE) Yes ALL: Description of the recommended treatment.
UNPAVED_RATING NUMBER(3,0) No -1 DYNAMIC-UNPAVED: DYNAMIC-UNPAVED: Condition Rating for unpaved routes. A PASER score is arrived at based on the scores of the distresses (excludes dust). The score would be populated here and would be 1,2,3,4, or 5.
UNP_CROWN_SCORE NUMBER(1,0) No -1 DYNAMIC-UNPAVED: DYNAMIC-UNPAVED: This will be scored based on the longest length of Crown after weighting has occurred. Should only be be populated with 1,2, or 3.
UNP_CROWN_URG NUMBER(4,1) No -1 DYNAMIC-UNPAVED: DYNAMIC-UNPAVED: Crown - urgent severity. LENGTH NOT PERCENTAGE. Measured in feet. This will be the raw length in feet (from GPS breadcrumbs) of crown of URGENT severity. This number would be populated prior to any weighting.
UNP_CROWN_HI NUMBER(4,1) No -1 DYNAMIC-UNPAVED: Crown - high severity. LENGTH NOT PERCENTAGE. Measured in feet. This will be the raw length in feet (from GPS breadcrumbs) of crown of HIGH severity. This number would be populated prior to any weighting.
UNP_CROWN_MED NUMBER(4,1) No -1 DYNAMIC-UNPAVED: Crown - medium severity. LENGTH NOT PERCENTAGE. Measured in feet. This will be the raw length in feet (from GPS breadcrumbs) of crown of MEDIUM severity. This number would be populated prior to any weighting.
UNP_CROWN_LOW NUMBER(4,1) No -1 DYNAMIC-UNPAVED: Crown - low severity. LENGTH NOT PERCENTAGE. Measured in feet. This will be the raw length in feet (from GPS breadcrumbs) of crown of LOW severity. This number would be populated prior to any weighting.
| UNP_CROWN_REPORT | NVARCHAR2(20 CHAR) | Yes | Text version of segment severity for Crown distress: High, Med, or Low | |
| UNP_DRAIN_REPORT | NVARCHAR2(20 CHAR) | Yes | Text version of segment severity for Drainage distress: High, Med, or Low | |
| UNP_RUT_WB_REPORT | NVARCHAR2(20 CHAR) | Yes | Text version of segment severity for Rutting & Washboarding distress: High, Med, or Low | |
| UNP_POT_LA_REPORT | NVARCHAR2(20 CHAR) | Yes | Text version of segment severity for Potholes & Loose Aggregate distress: High, Med, or Low | |
| UNP_DUST_REPORT | NVARCHAR2(20 CHAR) | Yes | Text version of segment severity for Dust distress: High, Med, or Low | |
| PAVED_RATING | NUMBER(3,0) | No | -1 | DCV/DYNAMIC-ASPHALT: Pavement Condition Rating: PCR = (0.60*SCR)+(0.40*RCI) |
IF SCR = -1, then the formula simply reduces to: PCR = RCI.
IF RCI = “-1” meaning roughness was not collected for the route, then the formula simply becomes PCR = SCR.
DCV_SCR NUMBER(3,0) No -1 DCV/DYNAMIC-ASPHALT: Surface Condition Rating: SCR = Lowest Index Value of [SC_INDEX or TC_INDEX or PATCH_INDEX or RUT_INDEX].
| DCV_RCI | NUMBER(3,0) | No | -1 | DCV ONLY: Roughness will only be rated on paved routes longer than 0.5 miles and with a posted speed limit of 25mph or higher. The following Roughness Condition Index (RCI) will be used for each category. |
| AC_INDEX | NUMBER(3,0) | No | -1 | DCV/DYNAMIC-ASPHALT: Alligator Cracking Index: AC_INDEX = 100 - (40 * ( (AC_LOW / 35) + (AC_MED / 15) + (AC_HI / 5) ) ). Should be a number between 0 and 100, rounded to the nearest whole number. |
LC_INDEX NUMBER(3,0) No -1 DCV/DYNAMIC-ASPHALT: Longitudinal Cracking Index: LC_INDEX = 100 - (40 * ( (LC_LOW / 175) + (LC_MED / 75) + (LC_HI / 25) ) )
| MRL_LC_SEV | ||||
| TC_INDEX | NUMBER(3,0) | No | -1 | DCV/DYNAMIC-ASPHALT: Transverse Cracking Index: TC_INDEX = (100 - (40 * ( (TC_LOW / ((INT_LENGTH / 105.6) * 21.1)) + (TC_MED / ((INT_LENGTH / 105.6) * 4.4)) + (TC_HI / ((INT_LENGTH / 105.6) * 2.6)) ) ) ) |
PATCH_INDEX NUMBER(3,0) No -1 DCV/DYNAMIC-ASPHALT: Patching Index: PATCH_INDEX = 100 - (40 * (PATCHING / 80) )
RUT_INDEX NUMBER(3,0) No -1 DCV/DYNAMIC-ASPHALT: Rutting Index: RUT_INDEX = 100 - (40 * ( (RUT_LOW / 535) + (RUT_MED / 205) + (RUT_HI / 40) ) ). MRL - number input
SC_INDEX NUMBER(3,0) No -1 DCV ONLY: Structural Cracking Index: SC_INDEX = 100 - ((100 - AC_INDEX) + (100 – LC_INDEX))
| PATCHING | NUMBER(7,2) | Yes | Patching (percentage of the total lane area). |
| MRL_RATING_METHOD | VARCHAR2(9 BYTE) | No | MRL Rating method - Simple or Detailed |
| CO_JOINT_FAULT_INDEX | NUMBER(3,0) | Yes | Manual Rating PCR Index Score for CONCRETE Joint Faulting (Excellent = 97; Good = 90; Fair = 73; Poor = 53) |
| CO_JOINT_DISTRESS_INDEX | NUMBER(3,0) | Yes | Manual Rating PCR Index Score for CONCRETE Joint Distresses (Excellent = 97; Good = 90; Fair = 73) |
| CO_SLAB_CRACK_INDEX | NUMBER(3,0) | Yes | Manual Rating PCR Index Score for CONCRETE Slab Cracking (Excellent = 97; Good = 90; Fair = 73; Poor-53 = 53; Poor-30 = 30) |
| CO_DELAM_POP_INDEX | NUMBER(3,0) | Yes | Manual Rating PCR Index Score for CONCRETE Surface Delamination and Popouts (Excellent = 97; Good = 90; Fair = 73; Poor = 53) |
| CO_PATCH_INDEX | NUMBER(3,0) | Yes | Patch index equals (100 - 40*Percent of patching / 80) |
| DCV_D_LANE_WIDTH | NUMBER(7,3) | Yes | DCV: Distress Lane Width: Software or operator measured. Do NOT use as LANE_WIDTH. This field is used in INDEX calculation only. |
DCV_FORCED_PCR NUMBER(1,0) Yes DCV: When a manual PCR is applied to DCV route this field will be populated with “YES” when not applied, field will be “NO.”
DCV_IRI_AVG NUMBER(7,1) Yes DCV: IRI_AVG = Average of Left Wheelpath IRI_L and Right Wheelpath IRI_R: (( IRI_L + IRI_R) / 2). When IRI_FLAG = 1 then IRI_AVG = -1. The IRI_AVG High Limit is 999.9
DCV_IRI_SD NUMBER(7,1) Yes DCV: Standard deviation of original roughness data for the Left Wheelpath and the Right Wheelpath. The IRI_AVG High Limit is 999.9
DCV_IRI_L NUMBER(7,1) Yes DCV: Left Wheelpath IRI. The IRI_AVG High Limit is 999.9
DCV_IRI_R NUMBER(7,1) Yes DCV: Right Wheelpath IRI. The IRI_AVG High Limit is 999.9
| DCV_IRI_FLAG | NUMBER(1,0) | Yes | DCV: IRI Flag: The IRI Flag indicates invalid or non-attainable IRI. Default = “0”. Flag = 1" (Invalid IRI Data or when ROUTE_ID.IRI_STATUS = NO). |
| DCV_RUT_AVG | NUMBER(7,2) | Yes | DCV: Average Rut Depth value (both wheel paths). |
DCV_RUT_MAX NUMBER(7,2) Yes DCV: Maximum Rut Depth value (both wheel paths)
DCV_RUT_SD NUMBER(7,1) Yes DCV: Standard Deviation of Left Wheelpath and Right Wheelpath Rut Depth values
DCV_RUT_LOW NUMBER(3,0) Yes DCV: Percent of LOW severity ruts in Left Wheelpath based on 20 ruts, plus percent of LOW severity ruts in Right Wheelpath based on 20 ruts. A LOW severity rut is > or = 0.20” and < or = 0.49”
DCV_RUT_MED NUMBER(3,0) Yes DCV: Percent of MEDIUM severity ruts in Left Wheelpath based on 20 ruts, plus percent of MEDIUM severity ruts in Right Wheelpath based on 20 ruts. A MEDIUM severity rut is > or = 0.50” and < or = 0.99”
DCV_RUT_HI NUMBER(3,0) Yes DCV: Percent of HIGH severity ruts in Left Wheelpath based on 20 ruts, plus percent of HIGH severity ruts in Right Wheelpath based on 20 ruts. A HIGH severity rut is > or = 1.00”
DCV_AC_LOW NUMBER(7,2) Yes DCV: Alligator Cracking - low severity. Percentage of summarized segment that has Low severity selected. Percentage should be multiplied by 100 and reported to 2 decimals.
DCV_AC_MED NUMBER(7,2) Yes DCV: Alligator Cracking - medium severity. Percentage of summarized segment that has Medium severity selected. Percentage should be multiplied by 100 and reported to 2 decimals.
DCV_AC_HI NUMBER(7,2) Yes DCV: Alligator Cracking - high severity. Percentage of summarized segment that has High severity selected. Percentage should be multiplied by 100 and reported to 2 decimals.
DCV_LC_LOW NUMBER(7,2) Yes DCV: Longitudinal Cracking - low severity (percent based on length of lane). % of length with low severity longitudinal cracks per lane, multiplied by 100.
DCV_LC_MED NUMBER(7,2) Yes DCV: Longitudinal Cracking - medium severity (percent based on length of lane). % of length with medium severity longitudinal cracks per lane, multiplied by 100.
DCV_LC_HI NUMBER(7,2) Yes DCV: Longitudinal Cracking - high severity (percent based on length of lane). % of length with high severity longitudinal cracks per lane, multiplied by 100
DCV_TC_LOW NUMBER(7,2) Yes DCV: Transverse Cracking - low severity (total number of full length cracks based on LANE_WIDTH). Number of low severity full lane width cracks per summarized segment.
DCV_TC_MED NUMBER(7,2) Yes DCV: Transverse Cracking - medium severity (total number of full length cracks based on LANE_WIDTH). Number of medium severity full lane width cracks per summarized segment.
DCV_TC_HI NUMBER(7,2) Yes DCV: Transverse Cracking - high severity total number of full length cracks based on LANE_WIDTH. Number of high severity full lane width cracks per summarized segment.
DCV_VIDEO NUMBER(3,0) Yes DCV: Three digit set number that was assigned in the field by the DCV crew.
DCV_IMAGE_NAME VARCHAR2(16 BYTE) Yes DCV: JPEG Image Reference Number (Contractor designated)
DCV_SPEED NUMBER(2,0) Yes DCV: Collection Vehicle Test Speed
| DCV_CONSTR_FLAG | NUMBER(1,0) | Yes | DCV: Construction Flag: The Construction Flag indicates that there is construction on the road at the time of data collection. Value of 1" indicates construction on road. Default = “0”. Flag = "1" (Construction on Road Occurrence). | |
| DCV_DOR_FLAG | NUMBER(1,0) | Yes | DCV: Debris On Road Flag: The Debris on Road Flag indicates that the debris on road inhibits accurate data collection. Value of 1" indicates debris on road (water, leaves, dirt, etc.). Default = “0”. Flag = "1" (Debris On Road Occurrence). | |
| QUICK_RATING | VARCHAR2(20 BYTE) | No | 'NOT APPLICABLE' | Field used to input Quick Rating value for ASPHALT and CONCRETE routes. CONCRETE MRLs with FC 3-6 ONLY get a Quick Rating. When the Quick Rating does NOT equal NOT APPLICABLE, the other distress values MUST equal to NOT APPLICABLE. |
ROADS Feature Class
| ROADS FEATURE CLASS | ||||
| COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COMMENTS |
| OBJECTID | NUMBER(38,0) | No | Internal sequential number required by ESRI Geodatabase. | |
| GLOBAL_ID | VARCHAR2(38 CHAR) | No | Global ID - Unique identifier with time stamp | |
| SHAPE | ST_GEOMETRY | Yes | ESRI Generated field holding the types of geometry (ST_GEOMETRY) | |
| AGENCY | VARCHAR2(5 BYTE) | No | Land Management Agency (NPS, BOR, FWS) | |
| ROUTE_IDENT | VARCHAR2(25 BYTE) | No | Unique record identifier: UNIT_ID – RTE_NO | |
| CYCLE | NUMBER(2,1) | Yes | Current RIP cycle | |
| UNIT_ID | VARCHAR2(10 BYTE) | No | Unique code assigned within orginazation to differenciate collection units (NPS- PARK_ALPHA, FWS - ORG_CODE, BOR-AREA_OFFICE) | |
| ROUTE_NUM | VARCHAR2(6 BYTE) | Yes | Route number of the BOR asset | |
| ROUTE_LENGTH | NUMBER(7,3) | Yes | Length of the entire route in miles | |
| SURF_TYPE | VARCHAR2(2 BYTE) | No | Surface type for the majority of the route. Please see the SURFACE_TYPES table for a listing of the possible PAVED and UNPAVED surface types. | |
| SOURCE | VARCHAR2(50 BYTE) | Yes | ||
| SHAPE.LEN | Double |
ROUTE_GPS
| ROUTE_GPS | ||||
| COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COMMENTS |
| OBJECTID | NUMBER(38,0) | No | Internal sequential number required by ESRI Geodatabase. | |
| ROUTE_IDENT | VARCHAR2(15 BYTE) | No | Unique record identifier: PARK_ALPHA – RTE_NO | |
| CYCLE | NUMBER(2,1) | No | Current RIP cycle | |
| UNIT_ID | VARCHAR2(4 BYTE) | No | Unique four letter code assigned to NPS unit. | |
| MILEAGE_GPS_MATCH_CYCLE | NUMBER(1,1) | Yes | Indicates whether to use LANE_MILES, PAVE_WIDTH, LANE_WIDTH, PAVED_MI, UNPAVED_MI, RTE_LENGTH, and the route’s GPS information from the previous cycle’s ROUTE_GPS table. (Cycle Number) | |
| MILEAGE_GPS_MATCH_ITERATION | NUMBER(1,0) | Yes | IF ROUTE_ID.MILEAGE_GPS_MATCH = 6, this field will indicate which iteration to match to. Otherwise the value will be "1". | |
| STATE | VARCHAR2(2 BYTE) | Yes | State abbreviation in which route resides | |
| MP | NUMBER(7,3) | No | Mile Post of GPS coordinate | |
| GPS_LAT | NUMBER(9,6) | Yes | GPS Latitude Coordinate at BEG_MP (decimal degrees) | |
| GPS_LON | NUMBER(9,6) | Yes | GPS Longitude Coordinate at BEG_MP (decimal degrees) | |
| GPS_ELEV | NUMBER(7,1) | Yes | GPS Elevation at BEG_MP (feet) | |
| CROSS_SLOPE | NUMBER(7,1) | Yes | Cross Fall: % Cross slope at station | |
| GRADE | NUMBER(7,1) | Yes | Grade: % Profile slope at station | |
| HEADING | NUMBER(7,1) | Yes | Heading Relative to True North | |
| INSP_DATE | DATE | Yes | DCV Collection Date of when GPS was collected. | |
| COMMENTS | CLOB | Yes | Source of any digitized data |
ROUTE_ID
| ROUTE_ID | ||||
| COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COMMENTS |
| OBJECTID | NUMBER(38,0) | No | Internal sequential number required by ESRI Geodatabase. | |
| GLOBAL_ID | VARCHAR2(38 CHAR) | No | Global ID - Unique identifier with time stamp | |
| AGENCY | VARCHAR2(5 BYTE) | No | Land Management Agency (NPS, BOR, FWS) | |
| REGION | VARCHAR2(100 BYTE) | Yes | Internal Agency Region | |
| ROUTE_IDENT | VARCHAR2(25 BYTE) | No | Unique record identifier: PARK_ALPHA – RTE_NO | |
| CYCLE | NUMBER(2,1) | Yes | Current RIP cycle | |
| UNIT_ID | VARCHAR2(10 BYTE) | No | Unique code assigned within orginazation to differenciate collection units (NPS- PARK_ALPHA, FWS - ORG_CODE, BOR-AREA_OFFICE) | |
| CYCLE_COLLECTED | VARCHAR2(2 BYTE) | Yes | The Cycle that the data was collected. Routes that were not collected should be coded as NC. | |
| ROUTE_NUM | VARCHAR2(15 BYTE) | No | FHWA-RIP Route Number unique to linear referencing system | |
| ROUTE_NAME | VARCHAR2(100 BYTE) | Yes | Route Name | |
| FROM_DESC | VARCHAR2(255 BYTE) | Yes | Description of beginning point of route. | |
| TO_DESC | VARCHAR2(255 BYTE) | Yes | Description of end point of route. | |
| INSP_DATE | DATE | Yes | Data Collection Date: Only populate if route was rated for condition. | |
| FUNCT_CLASS | NUMBER(1,0) | Yes | Functional Classification (1-8) | |
| USER_ACCESS | VARCHAR2(20 BYTE) | Yes | Access Designation for ALL ROUTES (Public or Nonpublic). | |
| STATE1 | VARCHAR2(2 BYTE) | Yes | State abbreviation in which route resides | |
| STATE1 | VARCHAR2(2 BYTE) | Yes | Additional state in which route resides | |
| STATE1 | VARCHAR2(2 BYTE) | Yes | Additional state in which route resides | |
| ASSET_NUM | VARCHAR2(15 BYTE) | Yes | Agency Asset number associated with Route. | |
| SUB_UNIT | VARCHAR2(50 BYTE) | Yes | Agency Sub-Unit in which Route resides. Leave field empty when an Agency site is NOT split into Sub-Units. | |
| COLL_METHOD | VARCHAR2(10 BYTE) | Yes | Method by which route was collected. Routes that were not collected should be coded as NC. | |
| CONCESSION | NUMBER(1,0) | No | 0 | Concession Flag: Value of 1 indicates that Route is maintained by Concessionaire. Default: 0. Flag: 1 (Concession route). |
| MILEAGE_GPS_MATCH_CYCLE | NUMBER(1,1) | No | -1 | Indicates whether to use PAVED_MI, UNPAVED_MI, RTE_LENGTH, and the route’s GPS information from the previous cycle’s ROUTE_GPS table. (Cycle Number) |
| MILEAGE_GPS_MATCH_ITERATION | NUMBER(1,0) | No | -1 | IF ROUTE_ID.MILEAGE_GPS_MATCH = 6, this field will indicate which iteration to match to. Otherwise the value will be 1. |
| PAVED_LENGTH | NUMBER(7,3) | Yes | 0 | Length of paved portion of route in miles. |
| UNPAVED_LENGTH | NUMBER(7,3) | Yes | 0 | Length of unpaved portion of route in miles. Routes can have both paved and unpaved mileage |
| RTE_LENGTH | NUMBER(7,3) | No | 0 | RTE_LENGTH = PAVED_MI + UNPAVED_MI |
| SURF_TYPE | VARCHAR2(2 BYTE) | No | Surface type for the majority of the route. Please see the SURFACE_TYPES table for a listing of the possible PAVED and UNPAVED surface types. | |
| UNPAVED_STATUS | VARCHAR2(4 BYTE) | No | NULL | Indicates whether the route is paved, unpaved, or both. (“YES, “NO”, “BOTH”) |
| SQFT | NUMBER(7,0) | No | -1 | Area of route/parking lot in square feet. |
| LANE_NO | NUMBER(1,0) | No | -1 | The number assigned to the lane in which data was collected. Numbered 1,2,3, etc. from centerline or median from left to right. All non-linear features or routes not collected should be populated with -1. |
| NUM_LANES | NUMBER(1,0) | No | -1 | Number of travel lanes on route. |
| WIDTH_FLAG | NUMBER(1,0) | No | 0 | Width Flag: Used to indicates if new widths need to be taken for the record by the DATA CONTRACTOR. Value of 1 indicates that a new width must be taken. Default: “0”. Flag: 1 (Width Flag). |
| DISTRESS_FLAG | NUMBER(1,0) | No | 0 | Distress Flag: Used to indicate if distress to reported for the record by the DATA CONTRACTOR. Value of 1 indicates that distress must be taken. Default: “0”. Flag: 1 (Distress Flag). |
| ROAD_WIDTH | NUMBER(7,1) | No | -1 | Weighted Average Road Width for entire route for DCV routes. Calculated using PMS_20.PAVE_WIDTH weighted by PMS_20.INT_LENGTH. MRL PAVE_WIDTH value is field collected. |
| LANE_MILES | NUMBER(7,3) | No | -1 | DCV and MRL routes Lane Miles = (PAVE_WIDTH x PAVED_MI) / 11 foot lane. Parking Area Lane Miles = SQ_FEET / 5280 / 11. Manually Rated Polygons = SQ_FEET / 5280 / 11. Unpaved Routes = Not reported. (Represents a summation of all Subcomponent records for Summary Routes) |
| AREA_MAP | VARCHAR2(20 BYTE) | Yes | Reference Area Map Number for current cycle report. | |
| COMMENTS | CLOB | Yes | General remarks on record and data collection operations. | |
| ROUTE_PARENT | VARCHAR2(20 BYTE) | Yes | Field specifies if record should be reported in the Route ID Report (populate field with REPORT) or if it’s a subcomponent and must appear in the Subcomponent Route ID Report (populate field with a valid ROUTE_IDENT). | |
| SUBCOMPONENT | NUMBER(1,0) | No | 0 | Subcomponent Flag: Identifies a route as a Subcomponent of another park route: Value of 1 indicates that route is a Subcomponent route. Default: 0. Flag: 1 (Subcomponent Flag). |
| BEG_LAT | NUMBER(9,6) | Yes | GPS Latitude Coordinate at BEG_MP (decimal degrees), Parking the centroid Latitude | |
| BEG_LON | NUMBER(9,6) | Yes | GPS Longitude Coordinate at BEG_MP (decimal degrees), Parking the centroid Longitude | |
| END_LAT | NUMBER(9,6) | Yes | GPS Latitude Coordinate at End of route milepost (decimal degrees) | |
| END_LON | NUMBER(9,6) | Yes | GPS Longitude Coordinate at End of route milepost (decimal degrees) | |
| WIP_DATA | NUMBER(3,0) | No | -1 | WIP Data: Used to indicates total retaining wall count on the route. Default: “-1” (indicates no data available). Other values are actual retaining wall count. |
| GIP_DATA | NUMBER(3,0) | No | -1 | GIP Data: Used to indicates total barrier count on the route. Default: “-1” (indicates no data available). Other values are actual barrier count. |
| ACTION_TIMESTAMP | DATE | Yes | The date an alignment action (Add New, Match, Remove, Combine, and Split) took place on the record. | |
| ALIGNMENT_ACTION | VARCHAR2(15 BYTE) | Yes | The action performed on the record. Please see the ALIGNMENT_ACTION table for a listing of the possible Alignment Action values. | |
| TEMP_RIP_ID | VARCHAR2(15 BYTE) | Yes | TEMP_RIP_ID is created and used by the Alignment Tool. | |
| RTE_SERIES | NUMBER(4,0) | Yes | The series of numbers that the RTE_NO falls into (Values are 100,200,300,400,500,600,700,800,900,1000,5000). Value is calculated by triggers from ROUTE_IDENT. | |
| FURTHER_ACTION_REQ | NUMBER(1,0) | No | 0 | Field is used to show if follow-up work is required (i.e., if route was added during Alignment) before route entry is considered complete. Default: 0 (Route ID is up-to-date). Flag: 1 (Route ID is NOT up-to-date. A common use of value 1 will be to show the PKG need to be collected by the DCV.) |
| LANE_WIDTH | NUMBER(7,1) | No | -1 | Weighted calculated Lane Width |
| BEG_MP_DCV | NUMBER(7,3) | Yes | -1 | Starting Mile Point for DCV Route |
| END_MP_DCV | NUMBER(7,3) | Yes | -1 | Ending Mile Point for DCV Route |
| PARTNER | VARCHAR2(5 BYTE) | No | The partnering agency that requested this data to be collected for the Road Inventory Program: NPS, FWS, USACE, BLM, USFS, BOR. | |
| FLTP | VARCHAR2(3 BYTE) | Yes | Indicates if the route is eligible for funding under the Federal Lands Transportation Program. | |
| NHS_MI | NUMBER(7,3) | No | -1 | Indicates how many miles are in the National Highway System (NHS) network. |
| OWNER | VARCHAR2(25 BYTE) | Yes | Entity who ownes the feature | |
| MAINTAINER | VARCHAR2(25 BYTE) | Yes | Entity responsible for maintaining the feature | |
| FACILITY_TYPE | VARCHAR2(40 BYTE) | Yes | HPMS manual one way, two way, ramp or Parking - match HPMS | |
| ASSET_TYPE | VARCHAR2(20 BYTE) | Yes | Road or parking | |
| COUNTY_CODE | NUMBER(4,0) | Yes | FIPS code | |
| TIER | NUMBER(1,0) | Yes | FWS priority level | |
| REPORT_COMMENTS | CLOB | Yes | Urgent items to address and show on report - specific to current cycle | |
| ISVALID | NUMBER(1,0) | Yes | Used for Rival appliction | |
| LENGTH_UNIT | NUMBER(2,0) | Yes | Unit of measure - miles, feet | |
| DISTRICT | VARCHAR2(50 BYTE) | Yes | FWS - Congressional District code |
WIDTH_MEASURE
| WIDTH_MEASURE | ||||
| COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COMMENTS |
| OBJECTID | NUMBER(38,0) | No | Internal sequential number required by ESRI Geodatabase. | |
| GLOBAL_ID | VARCHAR2(38 CHAR) | No | Global ID - Unique identifier with time stamp | |
| AGENCY | VARCHAR2(5 BYTE) | No | Land Management Agency (NPS, BOR, FWS) | |
| ROUTE_IDENT | VARCHAR2(15 BYTE) | No | Unique record identifier: PARK_ALPHA – RTE_NO | |
| CYCLE | NUMBER(2,1) | No | Current RIP cycle | |
| UNIT_ID | VARCHAR2(4 BYTE) | No | Unique four letter code assigned to NPS unit. | |
| MEASUREMENT_MP | NUMBER(7,3) | Yes | The Mile Post where the measurement was taken. | |
| BEG_MP | NUMBER(7,3) | No | The beginning Mile Post for the section of road for which the width measurement is to be used. | |
| END_MP | NUMBER(7,3) | Yes | The ending Mile Post for the section of road for which the width measurement is to be used. | |
| LANE_WIDTH | NUMBER(7,1) | Yes | From inside centerline to inside fogline. When no fogline, from inside centerline to edge-of-pavement. When no striping at all, PAVE_WIDTH / NO_LANES. | |
| PAVE_WIDTH | NUMBER(7,1) | Yes | From edge of pavement to edge of pavement. | |
| SHOULDER_WIDTH | NUMBER(7,1) | Primary lane - Fog line to edge of pavement. | ||
| BIKE_LANE_WIDTH | NUMBER(7,1) | |||
| COMMENTS | CLOB | Yes | Remarks describing special circumstances related to this park. |
File details come from the government source that posted it. Updated .