Tag: Esri Data
by James Killick
The team working on Business Analyst Online is hard at work on the next release of the product, and we’ve got some really exciting new features on the way. One of them you will enjoy just for the sheer fun of exploring…
I’m sure you are familiar with the three basic maps you get in consumer online maps — streets, aerial and terrain. If you’re already a user of Business Analyst Online you will know that we provide access to not just three maps, but hundreds and hundreds of maps – maps on demographics, consumer spending, market segmentation and more.
In the next release of Business Analyst Online, we’re releasing thousands of more maps based on our Market Potential data. With this data you can start to drill into the nitty gritty details of information that may be of relevance to your particular store or business. Here’s a tiny, tiny sample of the kind of new things you will be able to map:
Here’s how you will get to it in Business Analyst Online (note the search capability):
And here’s how it will look in Business Analyst Online — in this case where people watch American Idol the most in the San Francisco Bay Area:
Have fun exploring!
By Lucy Guerra
Esri has launched the Ideas Site to collect information from you, our users, about what you like about Esri products, what you don’t like, what’s giving you trouble, and what you think will solve the problem. Simply click here to go to the Business Analyst section of the Ideas site where you can:
So please… share your ideas, share with friends, and share this link!
By Catherine Spisszak
It’s the time of year to start filling out those college basketball tournament brackets again. Whether you have followed college basketball all season long or pick your winners arbitrarily (by mascots or team colors like I sometimes do), the college basketball tournament is exciting to follow.
ESRI Market Potential Data can be used to reveal trends in the country’s interest in college basketball. The map above illustrates the Market Potential Index for watching college basketball on television. An index greater than 100 indicates that the area has a higher likelihood to watch college basketball on TV than the national average. For example, those areas with an index of 116 are 16% or more likely to watch college basketball on television than the national average. This map was developed using Esri Market Potential Data and the Business Analyst Desktop product.
Now let’s see how the metro areas of this year’s number one seeds stack up against each other demographically.
2009 Total Population:
- Syracuse, New York Metro area has the highest population of the four with 650,974.
- Durham-Chapel Hill, North Carolina Metro area comes in second with 493,505 people.
- Third is Lexington, Fayette, KY Metro area with 459,814 people.
- And fourth is Lawrence, Kansas with 113,982 people.
2009 Percent of Population Age 25 Years or Older with a Bachelor, Graduate, or Professional Degree:
- Lawrence, Kansas with 45.3% of the population
- Durham – Chapel Hill, North Carolina with 41.4% of the population
- Lexington-Fayette, Kentucky with 31.7% of the population
- Syracuse, New York with 26.3% of the population
2009 Median Age:
- Lawrence, Kansas is the youngest with a median age of 28.2
- Lexington-Fayette, Kentucky – 35.5
- Durham-Chapel Hill, North Carolina – 35.6
- Syracuse, New York – 38.0
2009 Unemployment Rate:
- Lawrence, Kansas – 6.9
- Lexington-Fayette, Kentucky – 7.9
- Syracuse, New York – 9.2
- Durham-Chapel Hill, North Carolina – 11.2
2009 Population Density:
- Lawrence, Kansas – 249.5 people per square mile
- Syracuse, New York – 272.4 people per square mile
- Durham-Chapel Hill, North Carolina – 279.6 people per square mile
- Lexington-Fayette, Kentucky – 310.9 people per square mile
So it appears that Lawrence, Kansas is the youngest, most highly educated, least densely populated area with the lowest unemployment rate of the four, according to Esri Updated Demographic Data. Maybe this will lead to a Kansas victory!
All of the Esri Data referenced above are available in the Business Analyst products. For more information about Esri Data please visit http://www.esri.com/data/esri_data/index.html
Good luck with those brackets!
By Catherine Spisszak
You should be receiving your Census 2010 form soon. Forms will be mailed to homes in March. This Census will be much different than years past. The most significant feature of the next census will be the omission of the long form. The short census questionnaire provides only the complete counts of population, households, and housing units plus the characteristics of sex, age, race, Hispanic origin, household relationship, occupancy, and tenure. Every other variable was previously collected from the sample long form. Now data about income, education, employment, language, migration, citizenship, marital status, and housing characteristics, such as value and rent, will be obtained from the American Community Survey (ACS), which is separate from Census 2010 and is subject to a different release schedule.
The Census 2010 data will be released by the Census Bureau according to the following schedule:
- December 31, 2010: Census 2010 population by state must be provided to Congress for reapportionment.
- April 1, 2011: Under PL 94-171, redistricting counts must be provided to the states. Redistricting data commonly include total population, population 18 years and over, population by race/Hispanic origin, and total housing units, to the block level. Data are released by the Census Bureau on a flow basis, by state, starting in January.
- Summer 2011: likely release of all complete-count census tables by the Census.
For more information on the Census 2010 release dates, please visit http://2010.census.gov/2010census/how/key-dates.php Esri plans to release the Census 2010 data across the Business Analyst products in phases after the Census Bureau has completed a release. There will be a short gap between when the data is released by the Census Bureau and when it is integrated into the Business Analyst products due to time needed to process, load, and test the data in the Business Analyst products.
Esri will release 2010/2015 Demographic Updates in Q2 of 2010. ESRI will continue to produce annual updates after 2010, evolving our methodology to use ACS as well as our other sources.
Stay tuned for more blog posts about Census 2010 and ACS and have fun filling out those Census forms!
By Catherine Spisszak
Right now, we are in the heat of watching all of the cold winter sports of the 2010 Winter Olympics. Whether you prefer figure skating, downhill skiing, or are intrigued by the sport of curling, the Olympics offer something for everyone. The personal stories of the individual athlete’s struggles, achievements, and triumphs are so inspirational – which is what keeps me glued to my television during both the summer and winter games.
First, a bit of trivia – Which country has the highest number of total medals from the Winter Olympics?
You must read these Winter Olympic-inspired facts from Esri before I provide the answer:
- There are 633 businesses in the U.S. that are classified specifically as skiing centers and resorts (SIC Code 701110), 72 of which are in New York.
- There are 2,352 businesses in the U.S. that are classified specifically as skating rinks (SIC Code 799901), 135 of which are in Pennsylvania.
- The Market Potential Index for watching alpine skiing/ski jumping on television in the last year in Verdi-Mogul, Nevada is 144, indicating that residents of this area are 44% more likely to watch skiing on television than the national average.
- In Grand Pass village, Missouri, residents are 8% less likely than the national average to watch ice hockey on television. The Market Potential index in that area is 92.
- In Black Diamond city, Washington the Market Potential Index for downhill skiing is 123, meaning the likelihood to downhill ski is 23% higher there than the U.S. average.
- Now to ice skating…the Market Potential Index for ice skating in Lutz, Florida is 112, or the residents there are 12% more likely to ice skate than the U.S. average. In Spindale town, North Carolina the index is lower at 89, 11% lower than the national average.
- The Market Potential Index for snowboarding in Telluride town, CO is 325, 225% higher than the national average. In Boardman, Ohio the index is 86, 14% lower than the U.S. average.
All of the Esri Data referenced above, including the business counts, are available in the Business Analyst products. For more information about Esri Data please visit http://www.esri.com/data/esri_data/index.html
Now back to the trivia question – the country with the most medals from the Winter Olympic Games is Norway. The U.S. isn’t far behind though, and Team U.S.A. is off to a very impressive start in 2010!
Go Team USA!
by Kyle Watson
Ah the BIG TEN. The major collegiate athletic conference that isn’t vewy good at math (currently 11 teams) is looking to add a 12th. Who will it be? The rumored suspects are Missouri, Rutgers, Pitt, Syracuse, Cincinnati, Iowa State, and Notre Dame. I’ve even heard the Detroit Lions threw their name in the hat?
So let’s have some fun using Business Analyst Desktop to analyze the potential suitors. First, I added the existing and potential conference locations using the “Store Setup – empty layer” feature. There I went clicking on the map, building a database, all the while using the ArcGIS Online imagery to pan and find the college campuses. Then I added all the respective states using the Standard Levels of Geography Trade Area tool. Here’s a nice map showing this:
I then went a step further by looking at the traditional recruiting grounds, those within a 3 hour drive from each school. I created Drive Time Trade Areas to do so. This is giving me a pretty good idea of who might be following my football and basketball games – that ole brand loyalty if you will. Continuing on I load the top-35 U.S. television and radio markets. Because in the end the conference brass wants more people watching games – AND watching the ads that pay the bills. So as you can see below there are some key markets (areas in black) that the BIG TEN is missing out on. The addition of Missouri or Rutgers would introduce sizable new revenue streams.
But just how sizable? How many people can I reach? Let’s use the Market Ranking Report find out. If I analyze current population for new top-35 U.S. television boundaries within 3 hour’s drive of Rutgers and Mizzou I can see there’s real opportunity to be had. If I add a Rutgers – I potentially am adding about 32 million people. With one school I am adding nearly half of the ENTIRE population of the existing BIG TEN coverage area (There’s 68 million, I determined this using Business Analyst’s Spatial Overlay tool). Or a Mizzou will give me nearly 6 million new viewers/fans/alums/couch potatoes/merchandise purchasers – this is still a large figure.
To close out – let’s take a look at the “geographic approach” and stay within our backyard. Because well, Rutgers is a world away from typical BIG TEN Country in New Jersey (do you like taking 2-hr bus rides to class across their billion urban campuses?) and Mizzou – they’re doing just fine in the Big 12 (and uh, there are no Z’s in Missouri, sorry. Math is one thing, spelling is another – fail). Let’s get back in our existing BIG TEN recruiting land and pick the logical choice.
That leaves us with Notre Dame. It makes too much sense that it hurts, doesn’t it? Yes they turned their nose up at an expansion offer in 1999 and have their fat TV contract with NBC. But seriously Notre Dame, your team has been AWFUL – it’s not the 1940s and you need the conference now. Need another reason, get this – the central most location of all existing schools (using the Mean Store Center tool in Business Analyst) is 20 miles west of South Bend!!! That’s your 12th team.
Hope you found this informatively fun…and how you can apply some real tools and workflows. Go Spartans!
by Catherine Spisszak
Halloween is here and I thought you might find these facts using Esri Data interesting:
- Bone Gap Village, IL has a total population of 262. 25.0% of the residents are under 18 and of trick or treating age.
- 17.4% of the population in Tombstone City, AZ can trick or treat this year as they are younger than 18.
- Bates City, MO has an index of 72 for purchasing a horror video/DVD in the last month, 28% lower than the national demand.
- The index in Jasonville city, IN for buying a horror video/DVD in the last month is 201, 101% higher than the national demand.
- Deadwood city, SD has an index of 93 for buying prepackaged, loose candy in the last 6 months, 7% lower than the national demand.
- The index in Pumpkin Center, NC index for buying prepackaged, loose candy in the last 6 months is 104, 4% higher than the national demand.
For more information on Esri Data please visit http://www.esri.com/data/esri_data/index.html
Green is the new black. From reusable bags at the supermarket and energy efficient appliances to hybrid cars and recycling, we are all trying to do our part. Esri Data can be used to identify some interesting trends in our efforts to be green.
The U.S. city with the highest likelihood to buy foods labeled as natural or organic is Telluride, Colorado. That city boasts a Market Potential Index (MPI) of 217. An MPI compares the demand for a specific product or service in an area to the national demand for that product or service. The index is tabulated to represent a value of 100 as the overall demand for the United States. Therefore, the MPI of 217 in Telluride means the demand for food labeled as natural or organic is 117% higher than in the U.S. The city of Mount Healthy,Ohio has a much lower index at 64, falling below the national average.
Telluride, Colorado also ranks very high in the likelihood to participate in an environmental group with an MPI of 284. However, the number one spot is held by Bonanza, Colorado with an MPI of 297. Helper, Utah has an MPI of 84, meaning demand to participate in environmental groups is 16% lower than in the U.S. as a whole.
Finally, Warm River, ID lays claim to the highest MPI for recycling products in the last year at 192. Green, Ohio has an index of 119, making them 19% more likely to recycle than the U.S. Both Sodaville, Oregon and Glassport, Pennsylvania have an index of 90 for recycling products in the last year.
To perform the above analysis, I took the Market Potential data in comma delimited format and imported it into Excel to perform sorts and searches. Esri Data can be utilized in this manner, or the data can be analyzed in reports or thematic maps on both Business Analyst Online and Business Analyst Desktop. For more information about Esri Market Potential data please visit http://www.esri.com/data/esri_data/market-potential.html
Stay tuned for more examples of how Esri Data can reveal trends in going green. And until then…keep reducing, reusing, and recycling!
by Catherine Spisszak
Chicago may have Wrigley Field and deep dish pizza; but, according to a recent study by Forbes magazine, the Chicago metro area is the most stressful city to live in the U.S. Los Angeles, California; New York, New York; Cleveland, Ohio; and Providence, Rhode Island round out the top five.
To conduct the study, Forbes examined unemployment figures, cost of living, median home prices, weather and population in the forty largest metro areas in the country. The population density figures used in the study were provided by Esri.
To read the article or view the full list of cities, visit America’s Most Stressful Cities.
I hope your city isn’t too high on the list!
by Catherine Spisszak
Football fans…your wait is over.
The start of the 2009 football season is upon us. But more importantly, so is the start of the 2009 fantasy football leagues. Our 2009 Market Potential database includes data for Participation in a fantasy sports league in the last 12 months, so I thought it would be interesting to analyze the indexes across the country.
Counties shaded dark red indicate high demand, with indexes of 121-159. Counties shaded dark blue have very low indexes, ranging from 36 to 57, well below the U.S. average. To create this map, I simply loaded a comma delimited file into Business Analyst.
Residents of Radford city, Virginia have the highest likelihood to participate in fantasy sports leagues with an index of 159, 59% higher than the U.S. average. Forsyth County, Georgia comes in second with an index of 155, followed by Sherburne County, MN; Elbert County, CO; and Loudoun County, VA.
My county (Lehigh County, PA) has an index of 108. I am doing my part by participating, and was even lucky enough to draft Adrian Peterson (…so let’s just hope that he doesn’t get hurt, because I don’t have much of a team without him).
Esri has added more than 200 new products to its 2009 Market Potential variable list. To see which items were added and learn more about this database, please visit http://www.esri.com/data/esri_data/market-potential.html