Datasets created for the BEHI follow watershed boundaries as defined by Woodward and Durall (1996). As part of the U.S.-Mexico Border Field Coordinating Committee Issues Team, Woodward and Durall used surface-water drainage basins as the primary basis for defining and delineating the extent of the border area from a shared-water resources perspective. In order to provide integrated datasets in the border region, local and regional BEHI datasets have been clipped to this boundary. A map of this extent can be found at: <http://borderhealth.cr.usgs.gov>.
This feature class is a binational compilation of transportation data (roads) for use in the USGS's BEHI. This dataset is being completed as datasets become available. See the completion report section for more details.
Since each country/agency has their own attribution system, a generalized attribution system was developed in order to integrate the data. When possible, the original category types were preserved is an attribute when reassigning the new values.
The Texas transportation data is at 1:12,000 scale and was obtained from Texas Natural Resource Information System (TNRIS) in September of 2006. The Mexico transportation data is at 1:50,000 scale and was obtained from the Instituto Nacional de Estadistica, Geografia, e Informatica (INEGI) in August of 2006. The Juárez, Chihuahua data is accurate within +/- 5 meters and was obtained from the Instituto Municipal de Investigacion y Planeacion (IMIP) in 2005.
Furthermore, this dataset was created to provide resource managers, public officials, researchers, and the general public with ready access to accurate, impartial, scientific information to strike a balance among human needs for resource utilization, environmental quality, and human health.
Any errors that were present in the original data persist in this dataset.
Depending on scale, these data may not align spatially in areas that display data from multiple agencies.
Errors in the original data persist in this dataset.
For Mexico, this dataset includes data for all but 8 50k INEGI quads that satisfy both of the following: 1. Intersect BEHI study areas 4-8, 2. That are south and east of INEGI quad H13A21.
The 8 quads missing data are: G14A47, H14C62, H14C63, H13D59, H13D65, H13D54, H13D74, H13D86.
*Note* In Juárez, Chihuahua, IMIP transportation data was used rather than INEGI transportation data.
2. The hierarchy was determined by visual interpretation, connectivity, descriptors, and comparison to existing maps and aerial photos.
3. Calculated values for the Binat_type field with Visual Basic code. Below is a sample of code used to determine which codes (FCCs) from the original data get reclassified as Binat_type number 1 (Primary routes).
Dim x As Integer If [FCC] = "A40" Then x = 1 ElseIf [FCC] = "A41" Then x = 1 '(and so on, for ALL FCC codes) End If
Where binat_type = x
4. Once the original data had an assigned Binat_type, the original data were merged into one dataset.
5. Descriptions provided by the source agencies regarding the transportation data were preserved. However, different agencies stored the descriptions in different ways and also stored different types of descriptors. Some examples include whether or not the road is paved and the number of lanes. The transportation descriptions for TNRIS data were already in one field, but some INEGI road descriptions were spread over several fields and needed to be concatenated. Below is the SQL code used to do this:
[TIPO] & " , " & [CARRILES] & " Carriles , " & " Derecho" & [DERECHO] & " , " & [Mexico_roads.CONDICION]
*note: The Calles and Caminos data from INEGI had simple descriptions that were originally in only one field.
For IMIP roads descriptions, which were originally in 2 fields, the code to concatenate was:
[Vias] & " , " & [Pavi]
6. INEGI data in subarea 8 were missing descriptors, so descriptions were assigned based on data with the same FCC code in other areas.
i.e.: Dim x As String If FCC = '3192' Then x = "Pavimentada, 2 Carriles , Derecho Libre , en operacion" End If
Where description = x
7. Final Binational Transportation Symbology:
Binat_type 1 = red, size 1.7; Binat_type 2 = black, size1.2; Binat_type 3 = gray, size .8
Below are the descriptions of the INEGI codes (FC) and the binat_type values that they were assigned to.
Carreteras (Highways) FC values:
FC , Binat type, Tipo 3186, 1, Pavimentada 3187, 1, Pavimentada 3191, 1, Pavimentada 3192, 1, Pavimentada 3193, 1, Pavimentada 3195, 1, Pavimentada 3199, 1, Pavimentada 3200, 1, Pavimentada 3202, 1, Pavimentada 3206, 1, Pavimentada 3208, 1, Pavimentada 3212, 1, Pavimentada 3220, 1, Pavimentada 3224, 1, Pavimentada 3225, 1, Pavimentada 3226, 1, Pavimentada 3227, 2, Terraceria 3230, 2, Terraceria 3234, 1, Pavimentada 3235, 1, Pavimentada 3236, 2, Terraceria
Caminos (Roads) FC Values:
FC Code, Binational Type, Tipo
3171, 3, Brecha 3172, 3, Vereda
Calles (Streets) FC Values:
FC Code, Binational Type, Tipo
3165, 3, Tercer Orden 3166, 2, Segundo Orden 3167, 1, Primer Orden 3168, 3, Cuarto Orden
Other INEGI FC Codes with no description:
FC Values, Binational Type 3197, 2 3491, 2 3495, 3 3496, 2 3641, 3 3643, 3 3647, 3 3840, 3 3861, 2 3864, 3
These are the descriptions of the TNRIS Codes (FCC) and their respective binat_type values:
FCC value, Description, Binational type
A15, Primary road with limited access or interstate hwy, separated, 1 A21, Primary Highways without limited access, unseparated, 1 A25, Primary Highways without limited access, separated, 1 A30, Secondary state and county highways, major category, 2 A31, Secondary state and county highways, unseparated, 2 A35, Secondary state and county highways, separated, 2 A40, Local, neighborhood, rural road, city street, major category, 3 A41, Local, neighborhood, rural road, city street, unseparated, 3 A43, Local, neighborhood, rural road, city street, unseparated underpassing, 3 A45, Local, neighborhood, rural road, city street, separated, 3 A50, Vehicular (4WD) Trail, major category, 3 A51, Vehicular (4WD) Trail, unseparated , 3 A60, At-grade ramp or connecting road not associated with a limited access highway, 2 A61, Cul-de-Sac, the closed end of a road that forms a loop or turn around, 3 A62, Traffic Circle, the portion of a road or intersection of roads forming a round, 3 A63, Access Ramp, the portion of a road that forms a cloverleaf or limited access, 2 A64, Service Road, provides access to businesses and rest areas, 2 A69, Ferry Crossing, Vehicular, Year-Round, 3 A70, Other Thoroughfare major category, 3 A71, Walkway, for pedestrians, usually unnamed, 3 A73, Alley, road for service vehicles, located at the rear of buildings, 3 A74, Driveway, usually privately owned and unnamed, 3 A75, Road, parking area, 3
These are the descriptions of the IMIP codes (VIA):
VIAs, Binational type
Acceso controlado, 1 Colectora, 3 Complementaria, 2 Primaria de trafico lento (si, pavi), 1 Primaria de trafico lento (no, pavi), 2 Primaria de trafico rapido, 1 Secundaria, 2 Sin clasificacion, 3