Showing posts with label Tools. Show all posts
Showing posts with label Tools. Show all posts

Friday, May 28, 2010

State of Metropolitan America: Benchmarking Austin Metro Area with New Tool

Comparing metro regions has gotten a little bit easier with the Brookings Institution’s State of Metropolitan America report and accompanying interactive indicator map.

Released in early May, the indicator map brings together a range of data including Population, Demographics, Immigration, Educational Attainment, Work, Commuting Patterns, and Income & Poverty all accessible with only a few clicks of the mouse. Each of the subject areas include a range of indicators that are displayed using graduated symbols grouping the data by both percent and numeric value, depending on the setting. The data is also readily available as a table and downloadable as a .csv file.

The metro areas map includes the indicators for the 100 largest Metropolitan Statistical Areas in the nation, including six in Texas: Dallas-Fort Worth-Arlington, Houston-Sugarland-Baytown, San Antonio, Austin-Round Rock-San Marcos, El Paso, and McAllen-Edinburg-Mission. There is also a map setting to examine the data for selected cities, suburbs, and states. Here is an example of the map interface.

(Click image for larger)


Austin-Round Rock-San Marcos MSA is ranked 1st of the 100 largest metro regions in the percentage of workers that work at home (6.2%). This probably is not a surprise to many who have examined Austin's Creative and Entrepreneurial Culture.

I took a few minutes to play with this tool to see how the Austin metro region stands in a few other interesting indicators. All of these data come from the Census Bureau's American Community Survey 2008 estimates and benchmarked against the 100 metro regions in the Brookings report.

Austin-Round Rock-San Marcos, TX ranks
  • Third for highest percentage of the total population that has moved within the last year at 22.3%. This includes migration into the region and those relocating within the region.
  • Third highest percentage of the total population that is of working age (defined as 18-64) at 66.3%.
  • Eighth highest in percentage of the White population with a high school diploma (95.3%), but only fifty-first for percent of the Hispanic population with a high school diploma (64.2%).
  • Eighth highest percentage of the total population with a bachelor's degree at 38.2%.
  • Tenth in wage-equality by gender with a male to female ratio of 1.12.
  • Ranks near the bottom (84th) in median hourly wage earnings for people with less than a High School degree at $10.18.
  • Sixth highest in percentage of total jobs in professional, scientific, and management industries at 14.6%.
  • Highest median household income of the six metro regions in Texas that are profiled in the tool. Twenty-Eighth highest in U.S. at $59,400.

And,

  • Ninth highest in percentage of workers carpooling to work at 13.2%.

Chris Ramser

Tuesday, March 23, 2010

Tracking Census 2010 Participation Rates while the Census is being conducted

Yes that's right, it is being done! Check out this posting from our Census coordination blog.

Here's a few highlights from that post.

The current national participation rate stands at 16% as of March 23rd. Here's what the rate looks like for Capital Area counties versus the Census 2000 rate.



And here are the Top 10 cities in the Capital Area region.



For all cities in the region, see this spreadsheet. We'll probably look at this again in the next coming weeks.

Data from the Census Bureau's Take 10 Map, http://2010.census.gov/2010census/take10map/

Chris Ramser

Friday, December 4, 2009

Community Visioning

This week we participated in a webinar by the Center for Rural Entrepreneurship focused on a community visioning process they have been working on in two beta communities: Brookfield Missouri and Garden County, Nebraska both of which have been struggling with depopulation over the past couple of decades.

The community visioning process included looking at standard metrics like income, sales, students, tax base, workers, and health care patients. The focus was to look at a possible alternate scenario to the trend and to develop a strategy based on the alternate scenario.

The scenario they came up with was to increase youth attractions by 10% and increase business development by 10%. Both communities showed signs of stabilization or growth in the outward years of the 45 year projections.

Data for these reports were provided by Headwaters Economics, which if you haven't checked out their site, we encourage you to do so. They have some pretty extensive profiles for every county in the country and can even generate aggregate county profiles and profiles for cities using a free piece of software. Check out this tool here.

Chris Ramser

Thursday, October 22, 2009

GovScan

As planners working in the public sector, we're constantly looking for opportunities to learn from experiences in other communities. In fact, I'm convinced that planners came up with the term "best practices" just to assuage our guilt about stealing good ideas from each other. Eric Ervin, part of the wonderful economic gardening team in Littleton, CO, is making our job a little easier. Eric recently launched a state and local government search engine, GovScan, which he built on Google's Custom Search Engine platform. It's a great resource, but I'm going to have to talk to him about CAPCOG's ranking when searching for GIS in Texas. Brian Kelsey

Tuesday, October 13, 2009

Mapping for Everyone

Check out ESRI's Mapping for Everyone website. You can load the map with several types of ESRI's current demographic data, such as unemployment rate, median household income, and population density. ESRI posted a blog last night announcing the new, free service.

Monday, September 14, 2009

Data Tools

I mentioned a few weeks ago that we've been working with the National Association of Development Organizations (NADO) on a training curriculum for economic developers interested in learning more about data analysis and regional strategies. We pilot tested the workshop with the Michigan Association of Regions in July and we did another run at NADO's annual conference in Chicago earlier this month.

Scroll down to Professional and Organizational Development and look for the Know Your Region presentations on the NADO website. It's difficult to follow PowerPoint slides after the fact, but you'll be able to find footnotes and examples for all the data tools we discussed. If you want help finding data for your community, let us know. Brian Kelsey

Monday, August 17, 2009

Areas "Hard to Count" by Census Mapped

(Cross-posted from CAPCOG Census Coordination Blog)

The “Hard to Count (HTC) Score” was developed by the U.S. Census Bureau to help identify areas that might be difficult to enumerate during Census 2010. The HTC score was calculated for every Census tract in the nation using twelve socioeconomic, demographic, and housing variables from Census 2000 that were correlated with high non-response rates. Online Maps have been developed showing this data for the Capital Area.

Online Map HTC Score 70+ (click for here for interactive map)



Online Map HTC Score 30-69 (click for interactive map)


For assistance with the map contact Chris Ramser, 512-916-6184.

Hard to Count Scores range from 0-132. Areas with the highest scores (e.g., over 70) are likely to have relatively high nonresponse and undercount rates, while areas with the lowest scores are likely to be areas with low rates. These high HTC areas may warrant increased level of focus for Census outreach activities.

The first map developed by the Capital Area Council of Governments shows the location of Census tracts in our region with a 70+ HTC score, while the second shows tracts with a score 30 to 69. When you visit one of the maps, click on a shaded area to view Census 2000 data about that Census tract. The field names in the table have been abbreviated, but this definition file contains an explanation of each variable. Also, the KML or KMZ files for each map are posted below for download, allowing users to view the data in Google Earth.

KML or KMZ files
HTC Score 70+ KML

HTC Score 30-69 KMZ

KML and KMZ files can be viewed in the free software, Google Earth, which provides for additional functionality. Google Earth contains preloaded data such as schools, churches and other places of interest that may be used to identify partners or locations for outreach efforts. Users can also select an individual tract or tracts with a score over a certain number.

Monday, July 13, 2009

Asset Mapping: Telling Good Stories About Your Community's Competitive Advantage

We've been busy this summer collecting data for a regional asset map, which will go into our new economic development strategy for 2010-2015. Asset mapping is really just planning jargon for doing what all good economic developers do anyway: maintaining an inventory of all the things that make your city or county a competitive location for business, people, etc.

Here are two examples I really like because they are web-based and interactive, as opposed to a document that sits on a shelf somewhere:

Twin Cities Compass
Florida's Great Northwest

The communication medium is critical for getting information across to people, especially when you are talking about community and economic research. Florida's Great Northwest asset mapping website works equally well with site selectors, media, elected officials, and the general public. This is what differentiates economic development programs these days.

Thursday, July 2, 2009

Ever Wonder About Fast Growing Industries Outside Austin?

Thanks to Workforce Solutions Rural Capital Area for publishing an excellent new resource for labor market information in the region. As you can probably guess, we're big fans of one-stop shopping for understanding key trends. This new data tool covers much of what you need to know about local economies outside Austin. Go check it out.

Monday, June 15, 2009

Career Clusters

Seedco published an interesting report last month called A Tale of Two Systems: Linking Economic Development and Workforce Development. Promoting collaboration among economic development, workforce training, and education has been a cause du jour for some time, and I'm glad to see researchers weighing in with case studies of actual projects. Hopefully one day somebody will take a look at what's going on in Texas.

We tackle this challenge in a slightly different way. In addition to running committees that involve people from economic development, workforce development, and education, one of CAPCOG's primary roles is to create information--data sets, maps, presentations, this blog--that provide opportunities for collaboration. For example, we've partnered with Workforce Solutions Rural Capital Area to provide labor market information tied to Career Clusters, which form the basis of career and technical education programs in secondary schools. Here's a table showing the 16 federally-defined Career Clusters and the job outlook for the Capital Area between 2009 and 2014. Click on the image for a larger version (source: EMSI).



School districts can use this information in several ways: (1) to prioritize career and technical education course offerings based on regional labor market trends (e.g., which Career Clusters give our students the greatest opportunity to find a well-paying job in a growing field?); (2) to emphasize the connection between secondary education and workforce availability (which can be very helpful for encouraging businesses to offer internships, job shadowing, etc.; and (3) to help students understand career options after high school, regardless of whether or not they decide to pursue postsecondary education immediately.

Brian Kelsey

Friday, May 15, 2009

Green Jobs

EMSI (one of the data providers we use) has published a helpful guide to understanding green jobs for the economic and workforce development worlds.

There is, of course, some disagreement about whether or not "green" jobs are really all that different from existing jobs (i.e. Does a HVAC technician go from a non-green job to a green job if he or she learns how to do an energy audit?). But the important point here is that, if you are interested in understanding and measuring the Capital Area's green workforce assets, then there is information available to help you.

Here's a list of occupations ranked by full-time jobs in the Capital Area that EMSI has identified as part of a solar power cluster:

Construction laborers
Operating engineers and other construction equipment operators
Electrical and electronic equipment assemblers
Electricians
Electrical engineers
Construction managers
Electrical and electronic engineering technicians
Welders, cutters, solderers, and brazers
Electromechanical equipment assemblers
Helpers--Installation, maintenance, and repair workers
Helpers, electricians
Electrical and electronics repairers, commercial and industrial equipment
Structural metal fabricators and fitters
Installation, maintenance, and repair workers, all other
Helpers, construction trades, all other

These occupations represent approximately 31,000 full-time jobs in the Capital Area, and there are expected to be more than 7,000 openings for workers in the next five years. Wages range from an average of $10.88 for entry-level to $24.07 for experienced workers. Education and training requirements for these jobs in the Capital Area are as follows:

20% require short-term on-the-job training
45% require moderate-term on-the-job training
14% require long-term on-the-job training
21% require postsecondary education

Finally, here's a map showing where these jobs are located by zip code in the Capital Area. The darker shades of green indicate where jobs are concentrated.

(Click on image for a larger version)



Source: EMSI

If you'd like more information about green jobs in your community, let us know, and we'd be happy to help you identify data available for your work.

Brian Kelsey

Thursday, April 30, 2009

Making Data Easier

Google is upping the ante again in its quest to make data more accessible and easier to work with. The company has launched search capability for public data, and they've kicked off by providing access to unemployment and population statistics. Type "Williamson County population" into Google, for example, and then click on the chart at the top of the search results. It will bring you to an interactive map that shows population change in Williamson County over time and allows you to compare Williamson County to other counties in the U.S. in a matter of seconds.

Add this new service to a growing list of tools like Gapminder and Many Eyes and you get the feeling that we're on the cusp of a giant leap forward in how people access and use public data to communicate. At the very least, presentations are getting a whole lot easier.

Brian Kelsey