Tag Archives: find address

New 2016 Digital Roads Database

.. new resources for updated geographic reference and statistical mapping and geography for routing logistics and optimization .. The Census Bureau TIGER/Line is a continuously updated geographic database used for geographic reference and geospatial processing of data from various Census statistical programs including the decennial census Census 2010 and American Community Survey (ACS 2014). The public use version of TIGER is released annually that includes updates developed during the year. ProximityOne integrates the TIGER geographic updates in the Digital Map Database. Warren Glimpse, founder of ProximityOne, developed the GBF/DIME used as the prototype for TIGER/Line development.  See related Web section for more details, interactive table and access to GIS resources.

The TIGER database includes many types of files and data. The data are developed in the form of shapefiles and dbase files that may be used directly with the ProximityOne CV XE GIS software at no fee. Perform wide-ranging mapping and geospatial analysis applications using these GIS resources. See more aboutmapping statistical data.

TIGER/Line Roads Data
This section is focused mainly on the use of the TIGER/Line “edges” shapefile. The edges shapefile U.S. wall-to-wall street/road coverage in the form of line shapefiles. Lines classified as roads are intersection-to-intersection road segments. Line segment fields include name, left- and right-side high and low addresses, and many related attributes.

Use the U.S. by county interactive table below to examine attributes of TIGER 2016 street/road coverage. ProximityOne developed these county summary data by processing each county edges shapefile. See about using the edges shapefile with the CV XE GIS software below in this section.

Illustrative Applications
The following sequence of graphics shows an example of a “road segment” in context of related geography. These applications focus on an area in Kansas City, MO (Jackson County),. Jackson County has 52,139 TIGER 2016 road segments. See the related step-by-step summary of how you can create these and similar map views using CV XE GIS below in this section.

Road Segment Map View & Profile
– Starbucks locations shown as red markers; pointer on road segment by a Starbucks location.
– View illustrates how non-Census, non-statistical data can be integrated with TIGER.
– Clicking on the road segment (in GIS operation), a mini-profile displays.
– The profile shows attributes of the selected road segment.
.. the TLID value shows the unique ID for this segment among all segments in U.S.
.. left- and right-side high and low address ranges and included in the profile.

Corresponding Census Block Profile
– The road segments are boundaries for census blocks.
– The census block boundaries are shown using a related TIGER blocks shapefile.
– The more that 11 million census blocks cover the U.S. wall-to-wall.
– The census block code (290950073002017) is shown as a label in the map graphic and in the profile.

Neighborhood & Shopping Area View
– A zoom-out shows the location, roads and blocks for a broader areas.

Regional View
– A further zoom-out shows the focus area view in context of the metro counties (a related TIGER shapefile)
– The January 2016 Kansas City city area (orange cross-hatch pattern) is shown using a related TIGER 2016 shapefile.

TIGER 2016 Roads
TIGER/Line 2016 vintage files were released in August 2016. While many aspects of road coverage remain as described in this section, TIGER/line 2016 includes many updates as well as “new vintage” geography for school districts, state legislative districts, congressional districts and other political/statistical area geography.
• More about TIGER 2016.
• More about TIGER/Line in general.

TIGER 2016 Road/Street Name/Address Coverage
— Interactive Table
The following graphic illustrates use of the interactive table to examine the number and characteristics of road segments by county. This view shows the top 10 counties based on the number of total road segments.

– click graphic for larger view

Using TIGER/Line with CV XE GIS
These operations require a Windows computer with Internet connection
1. Install the ProximityOne CV XE GIS
… run the CV XE GIS installer
… take all defaults during installation
2. Download the TIGER Roads project fileset
… requires ProximityOne User Group ID (join now)
… unzip TIGER Roads GIS project files to local folder c:\tiger2016
3. Open the c:\tiger2016\riger2016_kc.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named c:\tiger2016\tiger2016_kc.gis
4. Done. The start-up view is shown at top of this section.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Relating Addresses to Digital Road Segments

.. enter an address on a Google Maps page, or many other similar Web-based “find address” tools, and view that address on a map. View street detail easily. But a view of the digital road segment is not available. Answers to these questions are not available:
• what are the demographic-economic attributes for that location?
• what are the left and right side address ranges for that road segment?
• what are the geocodes on the left and right sides of that road segment?
• what are the end-point coordinates for the road segment?
• how does that road segment (the route) extend through the city or county?

Use methods described in this section to answer these types of questions and examine “Address to Digital Road Segment” relationships. An example is used that features an address shown as a red marker in the banner graphic at the top of this page (Kansas City, MO area). That address is also used in the interactive data access form below. Use these resources and methods for most addresses in the U.S. Tools reviewed here are available at no fee. Use related Web section for full functionality.

Viewing Address/Location in Context of Digital Roads
In the following graphic, a geocoded address (point shapefile) is shown as a red marker (see pointer) in context of roads (streets/lines shapefile). The Identify tool is used to show the profile of associated road segment (TLID=91447676) — an intersection to intersection segment of Oak St. Performing a query on the roads shapefile/layer to locate ID 91447676, the segment is displayed as yellow-highlighted. This application/view is reviewed in this section.

Finding Address Attributes
Use the form below to find attributes for an address. To get started, click the Find button with default settings. Results are returned/displayed on this same page. More in general, key in an address of interest, select the type of geography (more about this below) and click Find. Try your own addresses of interest; use this tool to meet recurring address lookups. Not clear on all the steps? Join us in a Data Analytics Lab session, get answers to questions.

Click following graphic for full functionality:

About the Data Content and Structure
When the Find button (above) is clicked, this page refreshes with returned data based on your query — the values entered/selected in the section above the Find button. The first portion of the data displayed provide a structured display of selected subject matter items (ACS 5-year estimates) for the type of geography selected (e.g. tracts) for that area in which the address is located. The scope of those items could be substantially expanded.

Following that portion of the display are the geographic attributes displayed as JSON output resulting from the geocoder processing of the address. This is the display content below the text “Summary of address sent and matched results:”.

Road Segment Attributes
See road segment attributes for this address under “Summary of address sent and matched results:” and “Address: {“. See that the road segment ID is shown by “tigerLineId”: “91447676”. This ID uniquely identifies this road segment among all of the more than 45 million road segments in the U.S. (see more detail in related section).

Viewing the Address with GIS Tools
1. Install CV XE GIS software (if already installed, skip step 1).
.. Install package — Windows 32/64
.. Start-up Readme
2. After installation, with CV XE GIS running, open a GIS project:
.. Use File>Open>Dialog and open the GIS project named c:\cvxe\1\cvxe_us2.gis. Perform these steps:
2.1. In the Legend Panel, uncheck layers $MHI x BG and Locations.
2.2. Use the Add Layer button to add the layer c:\cvxe\1\$$address1.shp.
.. address used in this application now appears as red marker
.. this single point shapefile was created using the CV XE Tools>FindAddress
2.3. In Legend Panel, check layer Jackson Cty MO roads.
.. now, all roads in the county can be viewed with marker.
.. optionally zoom-in to develop view like shown at top of this page.

.. view developed with ProximityOne CV XE GIS and related GIS project.

2.4. Use GIS Tools>FindShape tool to show all occurrences of “Oak St”
.. on the FindShape form the FULLNAME field is selected and set to “like” Oak St% .. all road segments having name like “Oak St%” are highlighted in yellow.

.. view developed with ProximityOne CV XE GIS and related GIS project.

2.5. Use GIS data table feature to show all occurrences of “Oak St” as table.
.. there are 155 road segment, shown in the next graphic with left and right-side address ranges .. optionally export for use in other applications.

Not clear on all the steps? Join us in a Data Analytics Lab session, get answers to questions.

Census Block Code
See section starting with “2010 Census Blocks”. In the default address run, the census block shows as “GEOID”: “290950066002016”: … state: 29 … county: 095 … tract: 006600 … block: 2016. Other items, such as the TIGER/Line segment ID and segment side, can also be important for some applications.

Any given address or location is contained with several types of statistical areas (e.g. census tract or block group) and political areas (e.g. city or county). We may want to know the demographic-economic characteristics of a location for any one or several of these geographies. Use the interactive tool on this page to access those data. For example, access/view the median household income of the location/address block group or the median household income the location/address city.

Join me in a Data Analytics Lab session to discuss more details about analyzing citizen voting age population and use of data analytics to develop further detail related to your interests.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Creating & Using Address Shapefiles

… there are many online tools that enable you to key in an address and show the location on a map. This section is focused on creating and using address-based point shapefiles in a GIS context. These methods provide similar information, showing the addresses on a map, but also enable a wide range of analytical capabilities. For example, find out how many of your addresses are in one county or census tract. Or, determine the census block or school district for each address.

Visualize Address Locations

The above views illustrates use of Find Address tool, described below, to locate/show addresses listed below. Marker/locations are shown with different markers based on a query. Markers are labeled with the point ID.
1100 Main St, Kansas City, MO 64105
1301 Wyandotte St, Kansas City, MO 64105
1701 W. 39th Street, Kansas City, MO 64111
4101 Main Street, Kansas City, MO 64111
302 Nichols Rd., Kansas City, MO 64112
6100 Broadmoor St, Mission, KS 66202
5800 Antioch Rd, Merriam, KS 66202
11815 E Highway 40, Independence, MO 64055

Use the no-fee ProximityOne User Group version of the CV XE GIS software to enter addresses, show them on a map and automatically save the shapefile for reuse in the existing or other GIS projects.

Entering Addresses
Install CV XE GIS software and enter your User Group userid. Start CV XE GIS and select the Tools>Find Address feature.

After clicking Tools>Find Address, prompt appears showing default address. Enter an address or use the default value; click OK. Optionally continue adding addresses.  End the process by entering null address (no value). The first step is illustrated in the following graphic using an address in the Kansas City, MO area.

Shapefile Automatically Created
The default point shapefile name c:\cvxe\1\$$address1.shp is created as shown in message in the graphic below. In this example, only one address was entered. The address location is shown by the red marker. The shapefile is added to the existing GIS project. See legend panel top left in the graphic.

Using the Results
The next graphic illustrates using the Identify tool to click on point which displays the mini-profile for the selected point/address. Address/point attributes that are automatically created include the point number and address in ‘name’ field. Use other features of the software to modify the marker/point appearance, label the addresses or add other attributes to each address.

Unlike online address-locators and display services, using the GIS operation you can determine which in which census block or other political/statistical areas (congressional district, school district, etc.) the address is located. If your point shapefile contains many addresses there are also geospatial analysis tools that can be used. Use the site analysis feature select a group of addresses, visually on the map, and create/display a profile of aggregated data for the selection of points.

Contextual View of Matched Road/Street Segment
You can also view the address locations in context of the matched street segment. The next graphic shows a zoom-in view. The roads/streets layer has made active (click on layer name in legend panel). The Identify tool is used to create mini-profile of matched street segment as shown in the graphic below.

By using the road segment attributes, the census block code (and higher level geocodes) can be determined/assigned. See more about the road segment attributes.

There are many other tools to create address-based point shapefiles. For example, you might have a file with existing latitude-longitude values/fields. In this case, the Find Address or Find Address-Batch operation is not needed — the latitude-longitude values have already been assigned. Creating a point shapefile by importing records with existing latitude-longitude will be reviewed in an upcoming blog post.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data.