Streets Shapefiles Structure and Content
File Organization
on CD-ROM
Address Match-Code Software
Download Honolulu County, HI Streets Shapefiles
|
|
Address Matching and Geocoding Resources: Proximity Streets Shapefiles
-- locating addresses, assigning latitude-longitude, census tract lookup
Address matching and geocoding resources have improved dramatically in recent years.
Files derived from the Census 2000 TIGER/Line files have improved access to better
address matching and geographic coding content. The underlying principle used in the address
matching involves assigning geographic codes (such as a census tract
or school district) and latitude-longitude based on the address location matched to a street
line segment.
To perform address matching and geocoding, an address-oriented file and a geographic base file
are required. The streets shapefiles dbase file provides the geographic base file.
These shapefiles cover all types of roads ranging
from interstate highways to jeep trails.
They cover the U.S. from wall-to-wall though degree of coverage is
usually best in metropolitan areas and larger places.
Within some limits, these files provide descriptive attributes of every road/street segment in the
U.S. as
characterized
between each set of intersections. We know the name, address ranges,
geographic codes, demographic, and other
characteristics of each side of these road/street segments and the latitude-longitude of each
intersection (to and from nodes at each end of the road/street segment).
Shapefiles, a term corresponding to a specific way in which cartographic areas structured in a data file
context, may be used for applications broader than address matching and geocoding.
Streets shapefiles may be used to view street locations and their attributes superimposed on other layers
such as county or ZIP code boundaries using mapping software. The same mapping/GIS software
can use the shapefile dbfs (dbase files) as an address matching geographic base file.
Streets shapefiles, derived from the Census Bureau
TIGER/Line files (UA version - see technical documentation for details),
have been developed by Proximity for the U.S. These shapefiles provide an affordable and accurate
means of address matching and geocoding your address-oriented data
(though the quality and usefulness of address structures is not as good in more rural areas
characterized by RFD and related non-street property locators). In addition, the streets shapefiles have been augmented to associate the
ZIP code, census tract and census block code with any street segment (intersection to intersection) in the U.S.
This enables you to associate the street segment with its corresponding demographic attributes of the
ZIP code, census tract, or census block on each side of the street
segment.
You can directly tie in data from the Census Tracts Demographics files
(specialized extracts of tract level data) that provide demographic
data on the population, income, and population below poverty level.
Shapefiles and TIGER [goto top]
TIGER/Line files refer to public use files developed by the Census Bureau from the internal
TIGER (Topologically Integrated Geographic Encoding and Referencing) database. The TIGER/Line files
are updated periodically. While TIGER/Line files may be described as digital map representations
of earth surface features, and are organized in a database-like structure, TIGER/Line files
have little inherent value. The raw data in the TIGER/Line files always requires further processing
to derive useful data to go into other applications.
Development of the shapefiles are one major way that the TIGER/Line files are transformed to make the
raw data more useful.
Proximity Streets Shapefiles [goto top]
A summary description of the Proximity streets shapefiles (available by
electronic transfer or on CD-ROM) is provided in the table presented below.
See ordering information.
A standardized naming convention is used of the form MSSCCCT.EXT where M is a constant, SS
is the FIPS state code, CCC is the county FIPS code, T is the type of file [set], and EXT is
the file extension. Filenames used in the show the names as they exist for Honolulu County (county 003), HI
(state 15). Streets shapefiles are organized by county by state as suggested by this file naming
convention.
The basic files are used to perform address matching where all that is needed is to assign
a latitude-longitude code to the matched address record.
The Geographic Base Files (extended files) provide 1) a supplemental geocodes file that enables you to also assign
any of the geocodes included in the file to the matched address record and 2) a supplemental file
containing the to/from latitude and longitude for each TIGER/Line ID.
| Basic Files |
| File Name | Description |
M15003R.DBF
M15003R.SHP
M15003R.SHX |
Primary streets shapefile set (line shapefile)
Key fields in the shapefile dbf include:
TLID, TIGER/Line ID
FEDIRP, Feature direction prefix (street name prefix)
FENAME, Feature name (street name)
FETYPE, Feature type (street type)
FEDIRS, Feature direction suffix (street name suffix)
CFCC, Census Feature Classification Code (type of road classification)
FRADDL, from address left
TOADDL, to address left
FRADDL, from address right
TOADDL, the to address right
ZIPL, ZIP code on the left of segment
ZIPR, ZIP code on the right of segment
FNODE, from node id (N)
TNODE, to node id, (N)
LENGTH, length in miles, (N)
|
M15003N.DBF
M15003N.SHP
M15003N.SHX |
Street segment nodes shapefile set (point shapefile)
Single field in the shapefile dbf:
NODE ID -- corresponds to R file NODE values
|
| M15003D.DBF |
Additional address range data (dbf only)
Key fields in the dbf include:
TLID, TIGER/Line ID
FRADDL2, from address left
TOADDL2, to address left
FRADDR2, from address right
TOADDR2, to address right
ZIPL2, ZIP code on the left of segment
ZIPL2, ZIP code on the right of segment
|
| M15003A.DBF |
Alternate feature (street) names (dbf only)
Key fields in the dbf include:
TLID, TIGER/Line ID
FEDIR2, Feature direction prefix (street name prefix)
FENAME2, Feature name (street name)
FETYPE2, Feature name (street type)
FEDIRS2, Feature direction suffix (street name suffix)
|
| M15003Z.DBF |
ZIP+4 data (dbf only)
Fields in the dbf include:
TLID, TIGER/Line ID
ZIP4L, ZIP+4 on the left of segment
ZIP4R, ZIP+4 on the right of segment |
|
Geographic Base Files; Extended Streets Database Files |
| M150033.DBF |
Geocodes and Fields (dbf only)
Fields in the dbf include:
TLID, TIGER/Line ID
FNODE, from node id (N)
TNODE, to node id, (N)
LENGTH, length in miles, (N)
FEDIRP, Feature direction prefix (street name prefix)
FENAME, Feature name (street name)
FETYPE, Feature type (street type)
FEDIRS, Feature direction suffix (street name suffix)
CFCC, Census Feature Classification Code (type of road classification)
FRADDL, from address left
TOADDL, to address left
FRADDL, from address right
TOADDL, the to address right
STATEL, FIPS state code, left side of segment
STATER, FIPS state code, right side of segment
COUNTYL, FIPS county code, left side of segment
COUNTYR, FIPS county code, right side of segment
COUSUBL, FIPS county division code, left side of segment
COUSUBR, FIPS county division code, right side of segment
SUBMCDL, FIPS county subdivision code, left side of segment
SUBMCDR, FIPS county subdivision code, right side of segment
PLACEL, FIPS place code, left side of segment
PLACER, FIPS place code, right side of segment
ZIPL, ZIP code on the left of segment
ZIPR, ZIP code on the right of segment
TRACTL, census tract code, left side of segment
TRACTR, census tract code, right side of segment
BLOCKL, census block code, left side of segment
BLOCKR, census block code, right side of segment
|
| M15003L.DBF |
TLID Nodes Latitude/Longitude Coordinates (dbf only)
Fields in the dbf include:
TLID, TIGER/Line ID
FRLONG, From node longitude
FRLAT, From node latitude
TOLONG. To node longitude
TOLAT, To node latitude
|
File Organization on CD-ROM [goto top]
Files contained on CD-ROM are organized in state-by-state folders. For example, CD-ROM 2 (of 5 total)
contains these folders:
M13
M15
M15001.ZIP
M15003.ZIP
M15005.ZIP
M15007.ZIP
M15009.ZIP
M16
M17
M18
M19
M20
M21
M22
M23
M24
M25
The folder number, e.g., 15 in M15, corresponds to the state FIPS code. As the state FIPS code for
Hawaii is 15, the folder M15 contains Hawaii streets shapefiles. Each state folder contains a zip file
that includes the files described in the above table (basic files) for each county. As shown in the above
folder display, there are 5 zip files in the M15 folder, one for each county. As described in the
above description of the files for M15003, the zip files are named in the manner MSSCCC.ZIP where SS is the state
FIPS code and CCC is the county FIPS code. A listing of all state and county FIPS codes is located
at [PDF] and [ASCII] text format.
Address Match-Code Software [goto top]
The Proximity Address Match-Code (AMC) software is designed to address match and geocode user supplied,
address-oriented data, with the streets shapefiles.
The AMC software performs these operations:
- Batch or interactive address matching and geocoding.
- Executes with GUI or in silent mode (callable by other software).
- Can be used in WinCGI applications to perform Web-based processing on your server.
-- passes matched codes to a file that your software can further manipulate.
- Lookup a single address keyed into a screen displayed edit box
returning census tract code, related site location codes, latitude-longitude, and
demographic profile of the area containing the address.
- Functions a census tract locator
- Geocoding with latitude-longitude assignment and code assignment to census block level.
Use AMC with Hawaii-based Street Shapefiles and Extended Files [goto top]
See how the AMC software operates first-hand. Follow these steps:
- Download the Honolulu County, HI
basic streets shapefiles and extended files. Expand this zip file to the folder c:\amc.
- Download AMC demo and
expand this file to the folder c:\amc.
- See the the extended description of the AMC software.
- Start the AMCDemo application like any Windows application: c:\amc\amcdemo.exe.
- The screen appears showing two address lines in the topmost edit box.
- Click the Start button and the following steps take place, operating on the
specified address,
- The address line is parsed and the results displayed.
- The city, state, ZIP line is parsed and the results displayed.
- This sequence of background steps takes place:
- Using the ZIP code and address line, the address is matched to the M15003R.DBF file.
- Based on the extended geocode file, the tract and block codes are assigned to the
address.
- Based on the tract code, selected items from the Census Tracts Demographics file
are accessed for the tract in which the address is located.
- Based on the extended TLID lat-long file, the latitude and longitude are assigned
to the address.
- The results of these processing steps are displayed in the lower display box.
Some items to note.
-
The parsing operation is based on a user controllable dictionary. The dictionary
application follows a set of rules that control how some parsing decisions are made. You can either
take control of the process or accept the defaults.
-
Where is the default address? This address was selected as it is the address of Kahala Elementary
School. This school is used in an example of a mapping application that can be
viewed here. A map showing the exact location of the school may be
viewed here. In this map you can see Kilauea Avenue to the left of the
school icon. Comparing codes to the results you obtained in the AMCDemo application, you can also
confirm that the school is located tract 0005 (shown in the map as "5") and in census block 1005.
- Other Addresses? The broader area may be viewed here. In this map, you can also see
Kalani High School. The address of Kalani High School is 4680 Kalanianaole Highway, Honolulu, HI 96821-1241.
Try this address in the AMCDemo application. If you copy and paste the address in the two lines, please insure
that true spaces are between the words and numbers.
- Another address. Liliuokalani Elementary School, located at
3633 Waialae Avenue, Honolulu, HI 96816-3235 does not display using the Factfinder mapping resource.
Not a fault of Factfinder, the inability of Factfinder to display the address is because the
original
file processed by
Factfinder
is not loaded with the lat-long for the school.
AMC Applications Using the Honolulu County Files.
The full set of basic streets shapefiles and extended files for Honolulu County, HI may
be downloaded
and expanded for review and familiarization.
The zip file expands to the files listed in the above table. There are 35,612 street segments in this
streets shapefile.
You can use the M15003R shapefile set directly with the no-fee ArcExplorer software or the ArcView
software.
goto top
|
