ProximityOne Home Page Resources to create and apply insight

  Situation & Outlook
  - S&O Desktop
  - S&O Profiles|Reports
    > Comparative
    > Narrative
    > Site Analysis

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

  - 2060 Demographic
    ... all county interactive table
  - 2030 Demographic-Economic
  - Single Year of Age

  GIS Thematic Mapping
    Visual Analysis Tools

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

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

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

Decision-Making Information Blog
- examining neighborhood change

Support & Technical Assistance
- help using these resources

Outlook2020 Trend Analysis
... software tool to view/analyze Outlook 2020 Estimates & Projections

Access U.S. by county annual demographic estimates and projections, 2010 through 2020, by using the Outlook 2020 interactive table. A Web page is displayed showing the population by 5 year age cohort other age groups and by year for the selected county.

The Outlook2020 Trend Analysis Windows-based software, described in this section, enables analysis of the Outlook 2020 estimates and projections. The software greatly enhances what can be done using only the Web-based viewer.
  1. display the estimates and projections in a grid, similar to the Web page display.
  2. show annual age-cohort population data as a percent of total population.
  3. save the grid display of population or percent data as an Excel file.
  4. select two or more counties and aggregate the data for the composite area.
  5. create percentage views and save to Excel just like for a single county.
    -- features 4 and 5 enable aggregation of the estimates & projections to a metro or part metro.
  6. use a metro listbox to automatically select all metro counties.
  7. use CompareAreas feature to compare any one area with another area, optionally multi-county.
  8. all U.S. counties and all metros are supported.

Start-up View
Start Outlook2020 using the desktop icon. The start-up view appears as shown below. The start-up view illustrates one of the basic features of the application. Johnson County, KS is selected in the lower left listbox. When this selection is run (dbl-click the county name), the total population by age profile is displayed in the grid. The leftmost column shows age group. The remaining columns show annual population estimates and projections to 2020. The year is shown in the top cell of the column.

Click graphic for larger view.

Percent of Total by Year
Click the "Show % of Total" button to view cells as a percent of total population.

Click graphic for larger view.

Select/Sum all Counties in a Metro
In this view, the Phoenix, AZ metro is dbl-clicked in metro listbox. The two component counties are displayed in the lower/county listbox. Multi-selecting both counties, the Run button is clicked. The grid refreshes with the sum of both counties, or the metro total. Perform a similar application for any metro.
Click graphic for larger view.

Saving Grid to Excel File -- the Metro
In this view, the File>SaveGridAs feature is used to save the current grid cells to an Excel file. The file was saved as c:\outlook2020\phoenix_metro.xls; it will be used in a comparative analysis reviewed below.
Click graphic for larger view.

Grid to Excel File -- a Metro Component County
In this view, the File>SaveGridAs feature is used to save the current grid cells to an Excel file. Maricopa County is dbl-clicked; the grid populates with population values for this one county. The file was saved as c:\outlook2020\maricopa.xls; it will be used in a comparative analysis reviewed below.
Click graphic for larger view.

Comparative Analysis
What part of the Phoenix metro is comprised by Maricopa County? The File>Comparative Analysis feature is used to compare Maricopa County (the numerator by cell) to the Phoenix metro (the denominator by cell). The following view shows that Maricopa County comprises 89.7 percent of the Phoenix metro population ages 0-4 years. The percent of this age group accounted for this county as a percent of total metro is slowly declining since 2010. Smaller Pinal County has a relatively increasing rate for this age group.

Click graphic for larger view.

Steps to Prepare a Comparative Analysis
  1. Develop the "numerator" area grid display.
  2. Use File>SaveGridAs and save this grid display to an Excel file with a meaningful name (e.g., Harris.xls)
  3. Develop the "denominator" area grid display.
  4. Use File>SaveGridAs and save this grid display to an Excel file with a meaningful name (e.g., Houston_metro.xls)
  5. Start File>CompareAreas and follow prompts.
  6. When prompted to open numerator file, use XLS file saved in step 2.
  7. When prompted to open denominator file, use XLS file saved in step 4.
  8. Comparison displays in grid; optionally save as Excel file.

More About Analyses & Insights
Questions that can be answered with this tool ...
  • what part of the Kansas City metro is comprised by the Missouri counties?
  • in total population? as a percent of metro?
  • how is this projected to trend 2010 through 2020?
  • what do these analyses suggest about trends by age cohort by county for metro?

User Group Access
Members of the ProximityOne User Group may install the Outlook2020 software and perform operations described in this section. Join the User Group now, there is no fee. See Outlook2020 installation notes

Demographic-Economic Projections
More about ProximityOne demographic-economic estimates and projections:
  • Outlook 2018 | Outlook 2030 | Outlook 2060 | Quarterly 3 year
  • integrated multi-sourced Situation & Outlook demographic-economic data

To install Outlook2020, run the Outlook2020 installer. Take all defaults. After installation, start Outlook2020 using the desktop icon.

Terms of Use. Estimates and projections accessible via this Web page and in related files are proprietary to ProximityOne. The data may be used in any manner without further authorization except that the data may not be redistributed. There is no warranty or guarantee of any type. The user is solely responsible for any use.

Support & DMI Web Sessions
Learn more about using resources described in this section. Join us in a Decision-Making Information Web 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. We can address your specific questions about using metro and county demographic economic data and related applications.

Additional Information
ProximityOne develops geographic-demographic-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 ProximityOne (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