CV XE GIS Home Page

  ProximityOne Main

  Situation & Outlook

  S&O Metro Reports

  New Topics & Updates

  Related Sections
  - Applications Gallery
  - States
  - School Districts
  - Metros
  - Congressional
  - Counties
  - Census Tracts
  - Block Groups
  - Census Blocks
  - ZIP Codes
  - Urban Areas

  - County Interactive
  - 5-year Projections
  - Quarterly Projections
  - 2030 Projections
  - 2060 Projections

    Visual Analysis

  Interactive Tables

  National Scope
  Demographic Change
  - States
  - Metros
  - Congressional Dist
  - School Districts
  - Counties
  - Cities/Places
  - Census Tracts

Decision-Making Information
  information resources & solutions
  (888) DMI-SOLN
  (888) 364-7656

Put data to work more effectively.
Certificate in Data Analytics

Visual analysis with ProximityOne tools
click graphic for info; hover to pause

visually analyze clients/markets
site analysis using 1 mile radius


$median household income
patterns by census tract - Houston

hover to pause

113th Congressional Districts

Click for info

US Asian Indian population 2010

Click for info

geocoded students and school
McKinney ISD, TX

Click for info

geocoded students and school
with tax parcels & streets

Click for info

high school attendance zones
with schools by type

Click for info

%high school graduates by
census tract - Puerto Rico

Click for info

Austin, TX MSA counties &
places 10K+ population markers

Click for info

Appalachia counties (green) &
coalfield counties (orange)

Click for info

China provinces percent urban &
cities (markers) by state plan

Click for info

Honolulu census tracts (red)
& census blocks

Central Park area NYC

Click for info

Kansas City Metro & Counties
Home Depot locations (markers)

Click for info

World Cities; focus on Spain

Click for info

Data Analytics Blog
Mapping Statistical Data

Support & Technical Assistance
help using these resources

  -- determine/assign latitude-longitude and geocodes to addresses
  -- assign subject matter attributes/demographics to addresses

The AddressCoder software is used to assign latitude-longitude coordinates and geocodes to addresses. Geocodes include the census block where the address is located. The addresses are provided by the user and may be from any source. The AddressCoder Level 1 software is available for personal use to ProximityOne User Group members at no fee. See installation details. See terms of use.

The AddressCoder Level 2 provides additional features including:
  • licensed for business use.
  • faster processing.
  • more accurate coding through use of extended digital map database.
  • ability to create a locations shapefile for use in mapping and GIS applications.
  • ability to add subject matter attributes to each location record.
    ... such as median household income from ACS.

Illustrating Geocoded Locations in Context
How the geocoded data can be used .. the following graphic shows use of geocoded locations (red markers) in context of the Kansas City metro (bold brown boundary), 115th Congressional Districts (CDs -- bold black boundary, white labels) and patterns of median household income by census tract. Pointer in 115th CD "2003" -- Kansas CD 03.

... View developed using CV XE GIS. Map your own locations with geography of interest.

See more about using geocoded locations in GIS applications below in this section

Related Resources
  • Location-Based Geocodes & Demographics
    .. enter an address; geocodes & demographic attributes shown on return page
  • CV XE GIS software
    .. import and map/geospatially analyze geocode address data

Using the AddressCoder
To use the AddressCoder software, start the application and open an address file. With the address file open, click the Start button (left panel) to process the file that has been opened. As address records are processed, the latitude, longitude, 115th congressional district code and census block code are determined. These items are output immediately to the grid showing in the address line/row. At the end of the processing the updated grid is output to an Excel (XLS) file. See about installing the application below in this section.

Start-up View
The following graphic shows the AddressCoder start-up view. The grid is populated with the addresses contained in the address file c:\addresscoder\address_set2.xls (provided during installation).

Address Processing View
The following graphic shows the view after processing has been completed. The grid is populated with the addresses contained in the address file c:\addresscoder\address_set2.xls updated with the latitude, longitude, congressional district code and block code.

As addresses are processed, the updated address row/record is displayed in the listbox shown in the left panel.

Opening an Address File
To open an address file use the File>Open Address File on the toolbar. A file open dialog is started and the input file (must be an Excel/XLS structured file) to be processed may be selected from any drive/folder.

A new address input file may be opened at any time: upon start-up or after another address file has been processed.

Address Input Files
The address input file must be in Excel (XLS) structure. Two columns are required in the XLS input file: address ID (column 1) and fully formed one-line address (column 2). The one-line address should be structured like "221 South Seneca, Wichita, KS 67213" (omit quotes). Coding rules include:
  • 5-digit ZIP codes are optional but suggested.
  • Column 1 (ID) may be left empty/blank.
  • The address string is not case sensitive.
  • For most accurate processing, special characters should be avoided.
  • There is no need nor provision for "second line" in the address; do not use second line address (such as Apt. 1).
  • Commas delimiting the address field components (street, city, state) are not required but suggested.

Output Files
Upon completion of coding, the updated grid with four output fields is written to an Excel (XLS) file and a completion message is displayed. If the input file is named c:\addresscoder\address_set1.xls, the output file will be named c:\addresscoder\address_set1_coded.xls. The characters "_coded" are inserted into the input file name before the dot and extension (before .xls). If the output file exists, it will automatically overwritten. At that time the program may be closed or another address file may be opened and processed.

During processing, as each address is coded, the results of coding and data assignment are written to the file c:\addresscoder\coded.dbf. This file is overwritten each time the Start button is used. In the event a long geocoding process is interrupted, the coded.dbf file contains all records processed up to that point (last address processed).

The statusbar is shown at the bottom of the AddressCoder form. Various information is presented in the statusbar. When an address file is opened, the name/path of the file is shown in panel 2 of the statusbar. The number of records appears following the file name. As processing occurs, the record number is shown in panel 1 of the statusbar.

Access the Settings form from the main menu: File>Settings>Start-up INI. Use the Setting form to set selected attributes for AddressCoder start-up and operation.

Mapping/Geospatial Analysis Applications
How the geocoded data can be used .. the following graphic shows use of geocoded locations (red markers) in context of the Dallas, TX city (cross-hatched area), counties and patterns of median household income by census tract. This view shows geocoded points based on the address file c:\addresscoder\address_set3.xls (Trader Joes locations in Texas). The shapefile created by AddressCoder is shown visually using the CV XE GIS softwrae. The identify tool (at pointer) is used to click on location/marker and display a mini-profile. The mini-profile shows attributes for this point that were generated using AddressCoder. The shapefile created by AddressCoder can be used with any GIS software.

... View developed using CV XE GIS. Map your own locations with geography of interest.

Zoom-in View
A zoom-in view to the above location shows this address in context of streets and other features. The marker is labeled with the address used in the original source file (c:\addresscoder\address_set3.xls).

... View developed using CV XE GIS.

Installation .. goto top
Install the AddressCoder software on any Windows computer. Internet is required to install and use the software. Run the AddressCoder Installer. When prompted, enter your userid and password (both case sensitive) provided separately. By default all files installed are located in the folder c:\addresscoder (recommended). The AddressCoder software can be installed on any drive/folder. However, the documentation assumes that the application has been installed in c:\addresscoder. Upon completing installation, the application is ready to use. To remove the application entirely, delete the c:\addresscoder folder.

Included with the installer are three sample address files. The files are named c:\addresscoder\address_set?.xls where ? has the values 1, 2, 3. The files are included to illustrate the process of opening a different address input file. At start-up, the file c:\addresscoder\address_set1.xls is automatically opened.

Terms of Use
AddressCoder is proprietary software resource developed by ProximityOne. Licensed users may use AddressCoder Level 1 for personal use only and subject to installation terms. The software may not be distributed to others. The software is not authorized for use in consulting, professional advice, business or commercial applications.

While best efforts are made to develop the most accurate geodcoding and address processing, there is no warranty about any aspect of use of the AddressCoder software. Any use of the software is solely at the discretion of the user.

ProximityOne User Group -- goto top
Join the ProximityOne User Group to keep up-to-date with new developments relating to metros and component geography decision-making information resources. Receive updates and access to tools and resources available only to members. Use this form to join the User Group.

Support Using these Resources
Learn more about accessing and using demographic-economic data and related analytical tools. Join us in a Data Analytics Lab session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants.

Additional Information
ProximityOne develops geodemographic-economic data and analytical tools and helps organizations knit together and use diverse data in a decision-making and analytical framework. We develop custom demographic/economic estimates and projections, develop geographic and geocoded address files, and assist with impact and geospatial analyses. Wide-ranging organizations use our tools (software, data, methodologies) to analyze their own data integrated with other data. Follow ProximityOne on Twitter at Contact us (888-364-7656) with questions about data covered in this section or to discuss custom estimates, projections or analyses for your areas of interest.

Copyright © . ProximityOne. All Rights Reserved.
Sitemap | Contact Us | News