# Presentation: 506432

## Local Employment Dynamics’OnTheMap v. 3All New Information

- Colleen D. Flannery
- Dorothy J. Paugh
- October 2008

**Notes:**
The Census Bureau has a powerful array of new tools to assist economic developers, planners, businesses and communities, thanks to a partnership between the U.S. Census Bureau and 50 states and territories. With the inclusion of New York data in December 2008, LED data will describe more than ninety percent of workers.  

Local Employment Dynamics (LED) produces measures about employment and workers for pre-defined and even custom local areas. 
The employment information is available by age and gender, by industry (offering SIC or NAICS 2, 3 and 4-digit detail) and includes information on earnings,turnover, new hires and more.  
The data sets are dynamic, showing job gains and losses, new hires and separations over time.  Each quarter the data are refreshed, about nine months after the end of the quarter. 

## Uses for OnTheMap

**Economic Planning & Time Series**
-      - Where is the labor supply located?
-        - Which industries are growing or declining over
-           time?
**Transportation planning & analysis**
-      - Between which areas do workers commute?
**Emergency management**
-      - Daytime population estimates

**Notes:**
OnTheMap is a terrific tool for 
Economic Planning
      - Where is the labor supply located?
      - Where should a company locate a new building/shop
Transportation planning & analysis
      - Between which areas do workers commute?
Emergency management
      - Daytime population estimates

## When there was...

**...****a bridge collapse in Minneapolis,**
**...****a proposed plant closure in Missouri,**
**...****a hurricane headed for the east coast,**
**...****a rash of wild fires in California,**
**...****a flood in Iowa**
**What kind of economic information did OnTheMap provide?**

**Notes:**
State and local officials assessed the impacts of these actual events using LED’s OnTheMap.

## Emergency Response

**Potential Economic Impact of Flooding in Des Moines, IA**

- Detailed GIS analyses using OnTheMap’s underlying data

- Analyses at the Census Block level of geographical detail

**Notes:**
These are two examples – the Northern California wildfires and the flooding along the Mississippi river, in which we took the data out of the application and brought it into a more powerful GIS system.  As with all OnTheMap data, the detail is at the block level and the analyses are only limited by your analytical questions.

For more information on downloading the underlying data, please see the Download the Data link in the OnTheMap Help page.

## Impact of I-35W Bridge Collapse

**Notes:**
This shows OnTheMap’s displays and reports produced to assess the impact of this tragic incident.  It depicts and describes where those who work in the Central Business district live so officials can estimate how many workers would have used that bridge for their daily commute and recommend alternate travel routes.  

## AP:  “The flooding in Cedar Rapids swamped 1,300 city blocks, forced 24,000 people to flee their homes...”

**AP:  “The flooding in Cedar Rapids swamped 1,300 city blocks, forced 24,000 people to flee their homes...”**

- Analysis uses 1 mile buffer on either side of river

**Notes:**
These reports and maps were produced using OnTheMap in the aftermath of the Cedar Rapids Iowa flood in 2008.

## AP:  “9.2 square miles of the city affected by flooding” 

**Notes:**
These reports and maps helped officials estimate economic impact to residents and workers affected by flooding.

## Hurricane Gustav

**Work Area Profile Map 2006**
-  Shows where workers employed in the selection area work
-  Estimated path of Gustav based on NWS data
-  Buffer of 50 miles.
-  Approx. 840,000 jobs in this selection
-  Each point shows jobs in a single Census Tract

**Notes:**
Hurricane Gustav is another example of using OnTheMap. This map shows and estimate of the potential impact of Hurricane Gustav as it moved into Louisiana.  
This Work Area Profile Analysis was created using the Ring/Buffer tool with a 50 mile radius.  The path was based upon the actual path of Gustav as reported by the National Weather Service. 
 In this example, there are about 840,000 jobs from 2006 located in the selection area.

## Hurricane Hanna

**Notes:**
At 2 PM on September 4, 2008 the National Weather Service issued this projection and advisory as Hurricane Hanna was making its way towards the East Coast.
OnTheMap shows how many jobs were located in the projected path through 8 AM Saturday in North Carolina.

## Hurricane Hanna

**Work Area Profile Map 2006**
** ****Shows where workers employed in the selection area work**
** ****Projected path of Hanna based on NWS data**
** ****Plume selection from 20 miles to 150 miles**
** ****Approx. 3.9 million jobs in this selection **

**Notes:**
Using the plume tool gave a rough approximating of the Hurricane’s path. The selection area contained  3.9 million jobs in 2006. The plume started at 20 miles and ended at 150 miles radius.  This also shows a n excerpt from the Work Area Profile report. Analysis was mapped at the county level of precision.

## Mapping the Impact of Potential Plant Layoffs

**Notes:**
The Census Bureau would never identify a specific company, but this map created by the state of Missouri.  It gauges the effect of the layoff of one shift at a local auto plant, indicating by colors where these workers live.

## Local Employment Dynamics (LED) Partnership

- Partnership between 50 states and territories
- Newest partners = USVI, Puerto Rico
- In process of joining  =  CT
- Not in partnership  = MA, NH*** **
- Data Sharing
- Local knowledge
- Comparable data for all states, counties, regions, WIAs
- Innovative and Cost-Effective
- Uses *existing* data
- Creates *new* data products

**requires legislative change*

**Notes:**
The Local Employment Dynamics – or LED – Partnership currently joins together 50 state and territorial partners with the U.S. Census Bureau to create a national, longitudinal infrastructure of employment data.
The strengths of this partnership rest on a state-federal data sharing model that combines local knowledge, a national frame, and cutting-edge economic and statistical modeling techniques.
In addition, because the LED Partnership uses existing datasets to create new data products, it is VERY cost-effective.  There are no additional surveys, no response burden.
Among the new data products created by the LED Partnership is OnTheMap.

## States in LED Partnership

**Notes:**
This is a voluntary partnership between the states and the U.S. Census Bureau.
 The state Labor Market Information (LMI) agencies supply key data from unemployment wage records and from businesses each quarter.
 The Census Bureau merges the data from the LMIs with data from different administrative sources, censuses and surveys to produce new data and products about jobs, workers, industries and your local economy. These data are called “quarterly workforce indicators.”
 With 50 partners, currently only a few states are not yet participating.  This map shows the non-partners (Puerto Rico, Connecticut, Massachussetts and New Hampshire) in white.  (Puerto Rico has since joined.) The plain blue states are partners that are not yet in OnTheMap but may have data in the other online tools like QWI Online and Industry Focus.  The remaining partner states are scheduled to appear in OnTheMap by May, 2009.

## www.census.gov

- Click on Local Employment Dynamics
- Or click on Data Tools
- Or use the url:  http://lehd.did.census.gov

**Notes:**
The easiest way to get to the LED data is to go to www.census.gov.

Click on the link in Business & Industry to get to Local Employment Dynamics.

## Local Employment Dynamics @ http://lehd.did.census.gov 

**Local Employment Dynamics @ ****http://lehd.did.census.gov**** **

**Notes:**
Key features on the home page include QuickLinks to three very powerful analytic tools:  QWI Online, On the Map, Industry Focus as well as information for state partners and website users.  
The center section provides the latest news about the LED program:  new partners, the latest releases and information about training.  
Q&A about LED are located prominently on the home page.  The LED site is searchable using Google, which confines its search to the LED pages only.

## Version 1 (2006)
Version 2 (2007)
Version 3 (2008):
45 States
5 Years of Data (2002-2006)
New User Interface
Segmented Data (age, income, industry clusters)
Improved Analyses/Maps/Reports

- Version 1 (2006)
- Version 2 (2007)
- Version 3 (2008):
- 45 States
- 5 Years of Data (2002-2006)
- New User Interface
- Segmented Data (age, income, industry clusters)
- Improved Analyses/Maps/Reports

**Notes:**
OnTheMap application is a free, online, publicly available application that shows where workers live and where people work. 
OnTheMap Version 1 was created for one pilot state in 2006.
As a result of the good feedback from Version 1, we developed Version 2 which was released in 2007 and extended to 42 states for 3 years of data.
Version 3, released in September 2008,  includes 45 states and 5 years of data makes big improvements to the User Interface and breaks new ground by adding segmented data, to give users 10 times the amount of data previously available.  

## More Advances in OTM Version 3

- Search names (even ZIP codes)
- Easier zoom & pan
- 4 standard steps for all analyses
- New Area Profile map overlays
- Better area selection tools
- More geographic report choices (“roll ups”)
- Animation of point/thermal overlays

**Notes:**
Version 3:
Expanded Name Searching utility – now all geographical layers are included – so you can search for Kirtland (AFB) even though you haven’t turned on the military base layer.  Can also search for ZIP Codes. 
Much easier manipulation of the map, including pan and zoom.
A persistent Control Panel that can be minimized by the user.
All analyses have been generalized to 4 steps.
New Area Profile map overlays that were not available in Version 2.
Improved area selection tools.
User control of geographical rollups in shed reports, AND
Animation of the map overlays for multiple years.

## 5 Steps for Creating OTM Maps and Reports

- Define Analytical Question
- Search for Name/Pan & Zoom in Map
- Turn on/off Geographic Layers & Labels
- Create Analysis
- View, Save or Print the Map and Report

**Notes:**
5 steps to get data from OnTheMap:
Step 1 – defines the question –important for any type of statistical analysis. In this step, users start to think about geography, job type or labor segment, and analysis type.
Step 2 focuses on locating a geographical area of interest.
Step 3,  (optional) focuses on the map details that will display.
Step 4  performs the analysis.
Step 5 brings the results of our analysis.  Results can be saved or printed.

## Selecting Your Basic Geography

- Type in the name or number of any of the areas shown in the dropdown box.

**Notes:**
There are 2 screens to the OnTheMap application: The Entry Page and the main Map Viewer page. There is also a Text-Only Tool.

##  The Control Panel

- Search = Find Your Area

- Map Key = Legend, Scale

- Layers = Add/Remove Map Features

**Notes:**
A new Control Panel appears to the left of the map viewer and contains all of the settings, legends, and tools needed to interpret and interact with the map. Five control tabs support the geographic name search function, the map key, geographic layer controls, analysis settings, and permit the user to customize both the maps and reports. The Control Panel design allows users to modify settings without the need to reload the entire map. All data settings are controlled through the Analysis tab, which has four steps that sequentially guide users through the map and report creation process. When a point or thermal map is produced, the Control Panel provides a summary list of all user defined settings. 
The Control Panel appears on the left and contains all of the settings, legends and tools for interacting with the map. There are five control tabs at the top of the panel. 

## Type “Las C” in Search

**Notes:**
The Control Panel – part which is shown here – contains all of the tools that users will need to perfom analyses in OnTheMap.
The Control Panel has 5 tabs across the top–they are:
The Search tab – Lets users search for names among the geographic layers and quickly zoom to the area of interest.
The Map Key tab – This shows users some basic information about the layers, the zoom scale, and – after we’ve created a map overlay – the key for the data.
The Layers tab – This allows users to make layers and labels visible or invisible.
The Analysis tab – This is where the magic happens.  This tab lets users define and run their analyses.
The Results tab – This tab is empty to start but will become populated with results once an analysis has been created.

The Search (formerly Place Name Lookup in OnTheMap Version 2) has been expanded. In addition to the use of city, county and state place names, users in version 3 can also enter the name of a metropolitan area (CBSA), congressional district, county subdivision, military base, tribal area, Workforce Investment Area (WIA), WIRED Region, One-Stop Career Center, or ZIP code (ZCTA). The verification screen in the prior version has been replaced by a listing of place name options incorporated into the control panel portion of the map viewer. 

## Removing the Clutter (Layers)

**Notes:**
The Layers tab lets you choose the layers that will appear on the base map.  The layer itself and its labels can be turned on separately.
If the checkbox is grayed out, such as State Legislative Districts, it means that layer is not currently available in the application. 
If the Layer name is gray and italicized, it means the layer is not available at the current zoom level.  
The layer and its labels can still be turned on, although they will not appear until an appropriate zoom level is reached.

##  The Control Panel:  Setting Your Choices

- Analysis = Select Data, Select Area(s), Set Map/Report Type

**Notes:**
Analysis – This tab contains all of the settings and tools needed to produce a workforce map and report. By working through the four successive steps, users can choose the data settings (or accept the defaults), select a study area, and define the map/report output. 

##   Step 1.  Data Settings

- Live or Work
- Year(s)
- Job Type
- Labor Market Segments

**Notes:**
The heart of the OnTheMap application lies in the Analysis tab. 
The first step in the Analysis tab has four data settings:
 Live or Work, Years, Job Type, and Labor Market Segments. 

The default Job Type is Primary (highest-paying job a worker holds) and default Labor Market Segment is All Jobs and All Workers.  

## Home/Residential Areaor Workplace Area

**Home/Residential Area****or Workplace Area**

**Home Area** -- Where workers live
**Workplace Area** --  Where workers work

- Live or Work limits report options

**Notes:**
This selection is important because it limits the type of analysis and report that you can generate.  Home Area, where workers live, leads to  a Home Area Profile or a Commute Shed but not a labor shed report. 
If the study area is a workplace, results may include a Work Area profile (with Quarterly Workforce Indicators) or else a Labor shed report map with report, but not  a commute shed.

## Where, When, Which, Who

**Where, When, Which, Who**

- Study Area

- Year

- Job Type

- Worker Characteristics

**Notes:**
After choosing Home or Work, choose years, job type and finally all or focus on particular segments of the labor market—by age group, earnings group or Industry class.

## Step 2.  Study Area Selection

- Select Study Area by:
- Layer **(City, County, WIA, ZIP Code)**
- Freehand
- Ring/Buffer, etc.

*New Features!*
- Donuts, Plumes
- Multiple Selection
- Editing of Selection

**Notes:**
Step 2: Study Area Selection
Select geography for the home/work option from Step 1.
5 geography selection tools + a reuse option
Layer – All available geographic layers
Freehand – Draw any selection area in the map viewer
Ring/Buffer – Buffer a point or line
Donut – The area between an inner and outer circle
Plume – Simulates a hurricane or aerosol chemical release
New Features:
Selection Preview
Multipoint Selection
Edit Lines
Freehand
Ring/Buffer
Plume
Reuse Selections
The second step, called Study Area Selection, offers several tools for choosing our selection area for analysis. This is a direct reflection of the Live or Work choice we made back in Step 1.  There are 5 selection tools here, as well as a Reuse Earlier Selection option.  No matter the selection tool used, OnTheMap will aggregate workforce data for all Census Blocks within the area covered by the selection shape.  
Virtually every geography that can be Searched or added to the base map is available for selection.  

If one of the selection tools is active,it will not be possible to navigate in the map viewer. Click on “Navigate” in order to resume regular navigation moves on the map viewer.

## Selecting by Layer 

**Selecting by Layer **

**Notes:**
Choose the layer to be used for selecting the study area.

## Freehand Selection and Edit Option 

*New Feature!* Modify freehand, buffer, plume, etc.

**Notes:**
This is where the user gets to define a custom area to study, one not pre-defined as a geographic area. 
While holding down the left mouse button, I can draw the exact selection area I desire.
Once it’s drawn, it can be edited by grabbing the lighter colored circles on its perimeter. 
Keep in mind, freehand selections cannot be exactly replicated in future sessions.

## Buffer Selection: Set Width of Corridor & Draw Line

**Buffer Selection: Set Width of Corridor & Draw Line**

**Notes:**
This selection tool lets the user set a radius and plot a point to create a ring, or draw a line to create a corridor as the study area.

## Step 3: Advanced Area Selection(optional)

- Not covered today
- However, the selection tools are the SAME as in Step 2
- Allows for:
- Paired Areas, or
- Complex Modifications to First Area Selection
- Note: Paired area selection can change available data items in reports

**Notes:**
Step 3 of the Analysis tab covers more advanced selection options.  This step allows for the creation of a Paired Area or complex modifications to the initial study area.  The default is “Skip this Step.”  Click next to continue to Step 4. 

## 4. Choosing Map and Report Type

- Map/Report = Profile of workers in selected area or travel patterns of workers

**Notes:**
The final step, called Map Overlay and Report, highlights the two analysis types offered in OnTheMap. With the choices already made by the user, there are two different types of map overlays and two different types of reports available for viewing.  
The Area Profile Analysis shows information about the selection area only (also called the origin).  
The Shed Analysis shows information about where workers are going (also called the destination). 
To generate the analysis, click Go! in the top right of the control panel.
Rollup areas  - This feature aggregates information on workers by selected boundary layers; up to select three areas (defaults are cities/towns, counties and states) 
New Feature! Results by ZIP Codes, WIAs, Congressional Districts.  Rollups yield the top ten resultsfor all areas  except for State which yields the top five. 
Map precision is still under development. Leave it setat “Block” unless selection area is VERY large.

## Key Definitions for Analysis

- Area Profile
- Shows Work or Home locations *within* the selection area only.
- Shed
- Show where workers are going:
- Labor Shed shows workers going Home
- Commute Shed shows workers going to Work
- Display
- Points represent each Census Block with jobs
- Thermals represent density- average # per square mile

**Notes:**
It’s important to know that the area profile report only shows data within the study area.

The Labor Shed Analysis will display home locations of workers employed within the study area.  
In a Labor Shed, the work location is the origin, it maps the home locations (destinations.)  

The Commute Shed Analysis will display employment locations of workers residing in the study area.  
In a Commute Shed, the home location is the origin, it maps the employment locations as destinations. 

## Analysis Type:  Labor Shed (Thermals)

- Where Workers Live who are Employed in
- Chapel Hill & Carrboro, NC

- Thermal
- Key

- North Arrow

- Scale Bar

**Notes:**
This display shows where the study area’s workers live.  The thermals’ color gradations are based on the density (number of persons who reside there and work in Chapel Hill or Carrboro per square mile.)

## Labor Shed Report

- -  Reports home location at 3 selected geographic levels (aka, rollups)

**Notes:**
Reports include the top 5 states or the top 10  home locations for any of the other geographic levels selected from the Rollups dropdown (shown middle left on the screen). Choose only three.

For a labor shed, the “origin” is work so the “destination” that is visually plotted on the map with points and/or thermals and the area described in the reports are the homes of those who work in the study area.

## Analysis Type: Work Area Profile

- Where Workers are Employed within Lincoln, NE

**Notes:**
This is the map of workers with points within Lincoln, NE.  Each point represents workers within one census block.  Check the map key to see what numbers correspond to the different sizes and colors of the points.  This will change for every map.

## Area Profile Report

- 3 Age categories
- 3 Earnings categories
- 3 Industry categories
- QWI (for Work Areas)

**Notes:**
The Area Profile Report shows 20 industry sectors. Paired Area Profile Reports show only the 3 industry classes.
† Rollups are not available for Paired Area Shed Reports.
 OnTheMap3 allows users to analyze certain segments of the workforce. The  20 industry sectors in the work area profile reports have been compressed into 3 industry classes. 
Users should note that an Area Profile Report is not available when a Paired Area and Labor Market Segment are chosen.

##  The Go Button

*** *****The Go Button**

**Notes:**
Once processing is complete, the Results tab becomes active in the control panel.  There are 3 sections in the Results tab, Overlay Controls, Report Output Options, and Analysis Settings.  Point and Thermal Overlays for the most recent year, and an outline around the selection area will be active in the Overlay Control panel.  

##  The Results Tab

- Animate with Points and/or Thermals

- Output to HTML, XLS, PDF

- Legend of Selected Settings

**Notes:**
HTML is the first output option for reports, and the report will pop up in a new tab or window.  As in version 2, the Area Profile report displays job totals, 3 age breakouts, 3 earnings breakouts, and 20 industry breakouts for the selected years.  

## Time Series Animation: Points and Thermals

- 2006

- 2005

**Notes:**
Time-Series Animation 
In OnTheMap Version 3, up to three of the five years of data will be simultaneously available for display in the overlay map. Additionally, users can view labor market changes (in point or thermal form) across those three selected years in an animated map sequence. 

## Other Controls

**Other Controls**

**Notes:**
At the top right of the map viewer, from left to right,  are  Hide/Show Tabs, Print Map, Link to Me, Previous, and Clear Overlays.  
The Hide/Show Tabs allows the user to toggle the Control Panel on and off, allowing the map viewer to occupy the full screen if desired. 
The Print Map button is fairly self-explanatory.
 The Link to Me button can be very useful for sharing or saving analyses.  Simply click the button, and all of the current analysis settings on the screen will be saved in your web browser’s URL, which can then be copied and pasted into an email or any web browser.  
The Previous button will return the map viewer to the previous extent, allowing users to quickly go back to the previous scale or map location.  
The Clear Overlays button will clear all overlays from the map viewer.  This includes Points, Thermals, Selection Outline, and Selection Fill.  Although clearing overlays is not necessary, many users may prefer to have a clean base map before beginning a new analysis.

## Keep in Mind...

**LED not quite national in scope. **
**LED does not yet include military, self-employed or federal workers.**
**Data in *****OnTheMap***** refreshed annually. **

**Notes:**
Regarding residency patterns across state lines, cross-state flows on the Labor shed side are complete for each state whether or not the neighbor state is in the LED partnership.  However, no cross-state flows are available for commute sheds.

Federal civilian and self-employed workers are planned for inclusion within the next few years. 

QWI Online and Industry Focus online tools publish new data every quarter, while OnTheMap receives new data annually in December in 2009 and thereafter.

## Local Employment Dynamics

***Local Employment Dynamics***
***Annual Partners Meeting***
***Washington, DC****
***March 5-6, 2009***
****in downtown Washington, DC***

**Notes:**
To be held at the Brookings Institution near the DuPont Circle Metro stop.  

## Contact Us

*Local Employment Dynamics*
- _[http://lehd.did.census.gov](http://lehd.did.census.gov/)_* *
*Please send your comments to*:
- _CES.Local.Employment.Dynamics@census.gov_.
*Join the OnTheMap ListServ*
- _[lehd-](mailto:lehd-onthemap@lists.census.gov)__[onthemap](mailto:lehd-onthemap@lists.census.gov)__[@lists.census.gov](mailto:lehd-onthemap@lists.census.gov)_

**Notes:**
Self-explanatory.