*/ Demographic Economic Data Explorer API Tool
CV XE GIS Home Page






  ProximityOne Main

  Geospatial Analytics
    VDA Web GIS
    VDA Desktop GIS
    DEDE Data Access

  S&O Metro Reports

  New Topics & Updates

  ACS 2022
  ACS 2021
  ACS 2020

  Situation & Outlook

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


  CV XE GIS
    Visual Analysis



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





Data Analytics Blog
Power of Combining Maps with Data

Support & Technical Assistance
help using these resources



Demographic Economic Data Explorer 2 (DEDE2)

December 2023 .. did you know .. based on ACS data, the U.S. population ages 65 years and over increased by 43-percent from 2010 to 2022? See this and related measures in the table below. Click graphic for larger view.


These annual data were developed using the DEDE2 tool. Create data extracts like these for geographic areas down to the Census block group level. Choose from thousands of subject matter items.

Use the DEDE2 tool to easily create a demographic time-series view/dataset for a geographic area, 2010 to 2022 annually, based on American Community Survey (ACS) data. Little learning or preparation. Select your own subject matter from any of the detailed subject matter summary files. DEDE2 uses API methods that are both fast and require little source data disk space on your computer.

Topics
  01 About DEDE2
  02 An Illustrative Basic View
  03 Installation & Use
  04 Operation
  05 Output and Usage
  06 Creating a GeoList File
  07 Special Usage Notes
  08 Terms of Use
  09 Examples

01 About DEDE2 .. goto top
The DEDE2 tool features specialized capabilities related to companion Demographic Economic Data Explorer (DEDE). DEDE2 is focused on using ACS data. Use DEDE2 to easily create:
  • "geographic composite" files
  • time series data files

02 An Illustrative Basic View .. goto top
The following view illustrates use of the "Run GeoList File" button that starts DEDE2 and generates the data view shown in the grid. Each row in the grid is based on the "GeoList File" file specified below the "Run GeoList File" button. In this example there 23 rows in the file "geo_irvinesd.txt" (Irvine School District, CA). In this case, each row corresponds to a year, ranging from 2010 through 2022. It is easy to see that the total population has changed from 189,219 (2010) to 279.828 (2022) based on ACS 1-year estimates. Optionally click on the "Create XLS" buton to save the grid content as an XLS file.

The "Run GeoList File" operation uses the Subject Matter Items File. This example, and the default/start-up file is "C:\dede2\items_acs_base.txt". Samples of this file are included with the installer. This file determines the subject matter items retrieved and displayed in the grid.

The first 4 columns in the grid are:
Sumlev .. geographic summary level
Year1 .. ACS program year
ACSPGM .. 1 for ACS one year estimates, 5 for ACS 5 year estimates
GEOID .. geocode for area

03 Installation & Use .. goto top
To install DEDE2 on any Windows computer, run the installer.
Register for more installer and usage information. See terms of use.

04 Operation .. goto top
Quickstart 1 ..
  Click the Run One button to view attributes for one selected geographic area.
  A message is displayed showing attributes specified in the Items edit box
    - for the summary level, year, ACS 1/5 and geography specified in the Geocode edit box.

Examples:
040-05-1-48 results in 2005 estimates for Texas (48)
040-22-1-48 results in 2022 estimates for Texas (48)

Using Ctri-C will copy the content of the message to clipboard.

Quickstart 2 ..
  Click the Run GeoList File button to view attributes/create a file for:
    - Geolist file specified in GeoList File edit box
    - in combination with the Subject Matter Items File.

GeoList File
  The GeoList File edit box below the Run GeoList button the geographic area selection.
  Easily switch specifications with a keystoke or two.
    no spaces in Geoccde string
    default: 140-19-5-04013216813
    structure: SUM-YR-T-GEOCODE
    SUM .. summary level
    YR .. ACS year: 10 to 22 annually (any one year per run)
    T .. type .. 1 for one year estimates, 5 for 5 year estimates
    GEOCODE structured as required for summary level

GeoList Files Included with Installer

  • geo_us.txt .. U.S. geography time series file
      one line for each year; specifies 1 year estimates.
  • geo_irvinesd.txt .. Irvine, CA school district time series file
      one line for each year; specifies 1 year estimates.
  • geo_lagunacomposite.txt .. Laguna Beach, CA composite file
      one line for each area; specifies 5 year estimates.
  • geo_lagunacity.txt .. laguna Beach, CA time series file
      one line for each year; specifies 5 year estimates.
  • geo_lagunatract.txt.. laguna Beach, CA selected tract time series file
      one line for each year; specifies 5 year estimates.

Scope of Summary Levels Supported & Examples Working Geocode Strings
010: United States (geoid not used)
      010-22-5-
040: State (SS)
      040-22-5-06
050: County (SSCCC)
      050-22-5-06059
140: Census Tract (SSCCCTTTTTT)
      Census 2020 code used 2021 forward; Census 2010 code used 2010 through 2020
      140-22-5-06059062605
150: Block group (SSCCCTTTTTTB)
      Census 2020 code used 2021 forward; Census 2010 code used 2010 through 2020
      150-22-5-060590626051
160: City/Place group (SSPPPPP)
      geocodes and boundaries update annually; most do not change
      160-22-5-0639178
300: CBSA, MSA/MISA (MMMMM) .. 2020 version only available for ACS2022
      300-22-5-31080
400: Urban Area (UUUUU)
      Census 2020 code used 2021 forward; Census 2010 code used 2010 through 2020
      Definition different for Census 2010 and 2020
      400-22-5-51445
500: 118th Congressional District (SSCC)
      CD Sessions differ across ACS program years
      500-22-5-0647
610: 2022 State Legislative District - Upper (SSDDD) .. only available for ACS2022
      610-22-5-06036
620: 2022 State Legislative District - Lower (SSDDD) .. only available for ACS2022
      620-22-5-06072
860: ZIP Code area (ZZZZZ)
      Census 2020 code used 2021 forward; Census 2010 code used 2010 through 2020
      860-22-5-92651
970: School District Unified (SSDDDDD)
      geocodes and boundaries update annually; most do not change
      970-22-5-0620370

Subject Matter Item Files

Subject Matter Item Files (SMIF) control what subject matter items are extracted to the grid. SMIFs are text files that include a row for each item extracted. SMIF lines include the ACS item code, a shortname for the item and a description of the item. Several SMIFs are included with the installer. You can create your own. The number of items limit is 50 in one run. Ready to use SMIFs include:

  • items_acs_base.txt
  • items_acs_age49.txt
  • items_acs_movers_b07204.txt

The set of 25 items included in the "items_acs_base.txt" default Subject Matter Items File are shown below.
.. use leftmost 11 characters for item codes.
NAME NAME NAME
B01001_001E TotPop Total Population
B01001_002E MPop Male
B01001_026E FPop Female
B02001_002E White1 White alone
B02001_003E Black1 Black or African American alone
B02001_004E AIAN1 American Indian and Alaska Native alone
B02001_005E Asian1 Asian alone
B02001_006E NHOPI1 Native Hawaiian and Other Pacific Islander alone
B02001_007E Other1 Some other race alone
B02001_008E Multi Two or more races
B03002_012E Hisp Hispanic (any race)
B09020_001E Pop65up Population 65 years and over
B11002_001E PopHH Population in Households
B11001_001E HH Total Households
B11001_002E Fam Family Households
B25003_001E TotHsg Total housing units
B25003_002E OwnOcc Owner occupied units
B25003_003E RntOcc Renter occupied units
B25002_003E Vacant Vacant units
B25105_001E MDMTHHC Median Monthly Housing Costs (Dollars)
B19013_001E MHI Median Household Income
B19113_001E MFI Median Family Income
B25077_001E MHV Median housing value
B25064_001E MdRent Median gross rent


05 Output and Usage .. goto top

When DEDE2 is started, the SMIF subject matter is retrieved for each record in the Geocode File. The results are displayed in the grid. A row is displayed in the grid for each Geocode File record retrieved. If not Geocode File record can be retrieved, no record is written to the grid. The grid output may be optionally saved as an XLS file.

06 Creating a GeoList File .. goto top

The following lines comprise the geo_lagunacity.txt geolist file included with the installer.
.. the summary level is set at 160 -- city/place
.. there are 23 lines corresponding to data years 2010 through 2022.
.. as this is a city under 65,000 population, the ACS 5 year program is selected.
.. the city geocode is 0638178.
160-10-5-0639178
160-11-5-0639178
160-12-5-0639178
160-13-5-0639178
160-14-5-0639178
160-15-5-0639178
160-16-5-0639178
160-17-5-0639178
160-18-5-0639178
160-19-5-0639178
160-20-5-0639178
160-21-5-0639178
160-22-5-0639178

To modify this file and save it as Fresno city, CA, change the "5-0639178" to "1-0627000" and save the file as fresnocity.txt.
Get the Fresno place code here: https://proximityone.com/cities.htm#table
160-10-1-0627000
160-11-1-0627000
160-12-1-0627000
160-13-1-0627000
160-14-1-0627000
160-15-1-0627000
160-16-1-0627000
160-17-1-0627000
160-18-1-0627000
160-19-1-0627000
160-20-1-0627000
160-21-1-0627000
160-22-1-0627000

07 Special Usage Notes .. goto top

These data are statistical survey estimates based on the Census Bureau American Community Survey (ACS) program. The estimates are subject errors of estimation and other errors. ACS data are available as "1-year" and "5-year" periods. These data are released annually. The 2022 ACS 1-year data were released in September 2023; The 2022 ACS 5-year data were released in December 2023.

Time series data based on ACS data can be inherently challenging due to changes made from year-to-year in the geography (geocodes and/or geographic area) for which data are tabulated/published and the definition/item name for the subject matter tabulated.

The ACS "1-year" data are estimates corresponding to one year; for example ACS 2022 1-year estimates are data based on survey respondents for calendar year 2022.

The ACS "5-year" data are estimates corresponding to a 5-year period; for example ACS 2022 5-year estimates are data based on survey respondents for the calendar years 2018 through 2022. In this example, these are not data for 2022, but rather the period 2018 through 2022. They can also be thought of as estimates centric to 2020.

The 2020 ACS 1-year estimates are not available because of the impact of the COVID-19 pandemic on data collection.

If data are not available for a specific API call, no data are written to the grid. Reasons include:
.. an 2020 ACS 1 year estimate is referenced in the call (data not tabulated).
.. the geocode referenced has changed and not available in the call.

Congressional District geolist files
Using the cd0647.txt geolist file results in the data retrieved as shown below.
.. these data are for CD 47 in Orange County, CA.
.. note the congressional district vintage differs over time even though the CD geocode might exist.
.. the geographic boundary for CDs may vary and the data noncomparable from year to year.
.. in this application, the data for 2021 CD 0647 (116th Congress) total population of 701,834
      is not comparable to the data for 2022 CD 0647 (118th Congress) total population of 752,940.
500 10 1 0647 Congressional District 47 (111th Congress), California 634506
500 11 1 0647 Congressional District 47 (112th Congress), California 637759
500 12 1 0647 Congressional District 47 (113th Congress), California 722624
500 13 1 0647 Congressional District 47 (113th Congress), California 721957
500 14 1 0647 Congressional District 47 (114th Congress), California 718747
500 15 1 0647 Congressional District 47 (114th Congress), California 718339
500 16 1 0647 Congressional District 47 (115th Congress), California 714311
500 17 1 0647 Congressional District 47 (115th Congress), California 723526
500 18 1 0647 Congressional District 47 (116th Congress), California 710853
500 19 1 0647 Congressional District 47 (116th Congress), California 717594
500 21 1 0647 Congressional District 47 (116th Congress), California 701834
500 22 1 0647 Congressional District 47 (118th Congress), California 752940

08 Terms of Use .. goto top
There is no warranty for any aspect of using the DEDE tools or data. The user is responsible for any use. Data output from using DEDE may be used without restriction.

09 Application Examples .. goto top
School District Time Series
This example illustrates use of DEDE2 to develop time series demographic profiles/datasets for Rutherford County School District, TN (Federal code 4703690) and Murfreesboro City Elementary School District, TN (Federal code 4703150) annually for 2010 through 2022 based on the American Community Survey (ACS) 5-year estimates. Note that these years are the ACS program years. See this related interactive table to examine these and all school districts.

Two graphics and links to related excel file are shown below. These data are the DEDE2 output generated when using the subject matter items file, displayed as a graphic below the two district profiles.

Each district profile shows a row for each year, 2010 through 2022. Codes and area names are shown at the left with the demographic data values shown in the rightmost columns. The headers provide abbreviated names that are further described in the subject matter items file below.

Rutherford County School District, TN
The following graphic illustrates that the total population for the County school district changed from 147,702 to 190,215 over the period. The DEDE2 user can use any set of subject matter items from the ACS summary file; for example the school age population, enrollment, educational attainment, etc.


click to access all columns Excel file

Murfreesboro City Elementary School District, TN
The following graphic illustrates that the total population for the City school district changed from 102,815 to 153,512 over the period. In this case, the City school district in geographically contained within the County school district.


click to access all columns Excel file

Subject Matter Items File .. used for above DEDE2 runs


Mapping & Geospatial Analysis of the School Districts
The following graphic shows a lay-of-the-land view of the two school districts. Use the Open VDA Web GIS resource (more about to create this view or other similar views. This view shows K-12 schools as markers.

Click here to start Open VDA Web GIS .. nothing to install, no registration, no fee.
.. see the related Examining a School District tutorial for step-by-step instructions. .. note that DEDE2 and VDA Web GIS are separate, but related, applications.



End of this application example .. goto top


ProximityOne User Group
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 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 www.twitter.com/proximityone. 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 © . Proximity. All Rights Reserved.
Sitemap |  Contact Us |  News