Note: 'route' refers to an entire route, comprised of one or more 'section's and
described with a single route number. 'Section' is a piece of one 'route'. Each record in
these databases represents one section.
- Detailed_Description:
- Entity_Type:
- Entity_Type_Label: r3nwr_road.dbf
-
- Attribute:
- Attribute_Label: ELEM_ID
- Attribute_Definition: Element ID. unique identifier for each section that
combines ORG_CODE, RTE_NO, and SEC_NO. Allows any record to be combined with any other
record in the system and still be unique.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: ORG_CODE
- Attribute_Definition: Five digit organization code that uniquely identifies a
Service organization that is staffed and funded.
- Attribute_Definition_Source: USFWS, national data standard for organization
code
- Attribute:
- Attribute_Label: RTE_NO
- Attribute_Definition: The route number of the route
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: SEC_NO
- Attribute_Definition: The section number of the road. Every RTE_NO has at least
one SEC_NO
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: PROP_NO
- Attribute_Definition: Property Number. USFWS defined number associated with the
road or section.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: COMMENT
- Attribute_Definition: Collector comments at the time of rating.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: GPS_DATE
- Attribute_Definition: Date of the collection and rating of this record.
The format is YYYYDDMM
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: DATAFILE
- Attribute_Definition: Filename of the Trimble pathfinder Global
Positioning System corrected files (*.cor) used for exporting to Arc View shapefiles
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: SEC_LENGTH
- Attribute_Definition: The length in miles of each section of road.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: RTE_NAME
- Attribute_Definition: The name of the route
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: F_CLASS
- Attribute_Definition: : The Functional Class of the route. See Appendix 2
of the FWS Road Inventory report for definition of USFWS functional classes.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: ADT
- Attribute_Definition: Average Daily Traffic
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: RTE_LENGTH
- Attribute_Definition: The length of the entire route in which a section is a
part of.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: ADT_DATE
- Attribute_Definition: Date of the ADT data.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: SURF_TYPE
- Attribute_Definition: Surface type of the section at the time of rating
(GPS_DATE). Can be any of the following: AS = ASPHALT, CO = CONCRETE, GR = GRAVEL, NA =
NATIVE.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: LANES
- Attribute_Definition: Number of lanes of each section.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: PAVE_WIDTH
- Attribute_Definition: Width of each section in feet (regardless of
surface type)
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: CONDITION
- Attribute_Definition: Condition of section based on rating. Conditions
are: EXCELLENT, GOOD, FAIR, POOR, FAILED.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: COST
- Attribute_Definition: Cost to improve section to excellent condition. A
cost per mile is determined and multiplied by the SEC_LENGTH.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: COND_INDEX
- Attribute_Definition: The condition index of the parking lot. This number
is derived from dividing the COST by the cost this parking lot would be if it was in POOR
or worse condition.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: PHOTO_NO
- Attribute_Definition: Photograph number of the photograph taken at the
beginning of this section.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: COMMENT
- Attribute_Definition: Same as COMMENT above
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: STATION
- Attribute_Definition: USFWS Station in which the section is associated
with.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: SEC_FROM
- Attribute_Definition: Start description of the section
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: SEC_TO
- Attribute_Definition: End description of the section
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: SEC_LENGTH
- Attribute_Definition: Not used
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: TERRAIN
- Attribute_Definition: Type of terrain the section is located on. Can be
one of the following: LEVEL, ROLLING, MOUNTAINOUS.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_RAVELLIN
- Attribute_Definition: Rating from 0-4 of the Ravelling, if asphalt.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_FLUSHING
- Attribute_Definition: Rating from 0-4 of the Flushing, if asphalt
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_POLISHIN
- Attribute_Definition: Rating from 0-4 of the Polishing, if asphalt
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_RUTTING
- Attribute_Definition: Rating from 0-4 of the Rutting, if asphalt
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_TRANS
- Attribute_Definition: Rating from 0-4 of the Transverse Cracking, if
asphalt
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_TRANSEAL
- Attribute_Definition: If transverse cracks are sealed, 0, if not, 1, if
asphalt
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_LONG
- Attribute_Definition: Rating from 0-4 of the Longitudinal Cracking, if
asphalt
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_LONGSEAL
- Attribute_Definition: If longitudinal cracks are sealed, 0, if not, 1, if
asphalt
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_BLOCK
- Attribute_Definition: Rating from 0-4 of the Block Cracking, if asphalt
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_ALLIGATO
- Attribute_Definition: Rating from 0-4 of the Alligator Cracking, if
asphalt
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_POTHOLES
- Attribute_Definition: Rating from 0-4 of the Potholes, if asphalt
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_PATCHES
- Attribute_Definition: Rating from 0-4 of the Patches, if asphalt
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: A_PATCHCON
- Attribute_Definition: Rating from 0-4 of the Patch Condition, if asphalt
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: C_WEAR
- Attribute_Definition: Rating from 0-4 of the Wearing, if concrete
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: C_SCALING
- Attribute_Definition: Rating from 0-4 of the Scaling, if concrete
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: C_POPOUTS
- Attribute_Definition: Rating from 0-4 of the Popouts, if concrete
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: C_REINFORC
- Attribute_Definition: Rating from 0-4 of the Reinforcement, if concrete
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: C_LONGJOIN
- Attribute_Definition: Rating from 0-4 of the Longitudinal Joints, if
concrete
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: C_TRANSJOI
- Attribute_Definition: Rating from 0-4 of the Transverse Joints, if
concrete
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: C_CRACKS
- Attribute_Definition: Rating from 0-4 of the Cracking, if concrete
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: C_BLOWUPS
- Attribute_Definition: Rating from 0-4 of the Blowups, if concrete
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: C_PATCHES
- Attribute_Definition: Rating from 0-4 of the Patches, if concrete
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: G_DRAIN
- Attribute_Definition: Rating from 0-4 of the Drainage, if gravel
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: G_IFDITCH
- Attribute_Definition: Rating from 0-4 of the Ditch Condition, if gravel
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: G_CROWN
- Attribute_Definition: Rating from 0-4 of the Crown, if gravel
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: G_GRAVEL
- Attribute_Definition: Rating from 0-4 of the Gravel Layer, if gravel
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: G_WASHBOAR
- Attribute_Definition: Rating from 0-4 of the Washboarding, if gravel
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: G_RUTTING
- Attribute_Definition: Rating from 0-4 of the Rutting, if gravel
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: G_POTHOLES
- Attribute_Definition: Rating from 0-4 of the Potholes, if gravel
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: G_DUST
- Attribute_Definition: Rating from 0-4 of the Dust, if gravel
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: G_AGGREGAT
- Attribute_Definition: Rating from 0-4 of the Loose Aggregate, if gravel
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: N_DRAIN
- Attribute_Definition: Rating from 0-4 of the Drainage, if native
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: N_IFDITCH
- Attribute_Definition: Rating from 0-4 of the Ditch Condition, if native
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: N_CROWN
- Attribute_Definition: Rating from 0-4 of the Crown, if native
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: N_WASHBOAR
- Attribute_Definition: Rating from 0-4 of the Washboarding, if native
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: N_RUTTING
- Attribute_Definition: Rating from 0-4 of the Rutting, if native
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: N_POTHOLES
- Attribute_Definition: Rating from 0-4 of the Potholes, if native
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: N_DUST
- Attribute_Definition: Rating from 0-4 of the Dust, if native
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: STATE
- Attribute_Definition: The state in which this route is located
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: DISTRICT
- Attribute_Definition: The congressional district in which this route is
located
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: COUNTY
- Attribute_Definition: The county in which this route is located
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: PROP_DESC
- Attribute_Definition: The property description of this route. Should
always be "FWS Roads" or "FWS Road"
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: VISITORS
- Attribute_Definition: Number of visitors the station receives each year
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: MAN_NAME
- Attribute_Definition: The manager or project leader's name at the time of
rating.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: MAN_PHONE
- Attribute_Definition: The manager or project leader's phone number at the
time of rating
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: MAN_ADDRES
- Attribute_Definition: The location address of the station's office. This
station may share an office with several other stations.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: RTE_DESC
- Attribute_Definition: The description of the location of this route.
(From and To)
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: PAVED_MI
- Attribute_Definition: The paved mileage for this route
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: UNPAVED_MI
- Attribute_Definition: The unpaved mileage for this route
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: RATING
- Attribute_Definition: The condition rating of this section (0 - 10) based
on calculations of ratings in attributes (A_RAVELLIN) - (C_DUST)
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: CRS_PAGE
- Attribute_Definition: The Condition Rating Sheet number in the written
report that this section is described on.
- Attribute_Definition_Source:
- Attribute:
- Attribute_Label: LAYOUT
- Attribute_Definition: Orientation of the CRS page. (Landscape or
Portrait)
- Attribute_Definition_Source: