Tag: Esri Data
In these trying economic times it’s especially important to understand the local characteristics of the marketplace before you make a decision on where to invest in a business. In many cases I wonder if people perform even the most basic market research.
Take Redlands, CA for example: a town of some 69,790 people according to our 2009 data update. There are some eight Sushi restaurants (as well as eight Thai restaurants) in this one, relatively small city. This is on top of the many, many other restaurants in town: over 100 in the case of Redlands.
Could there really be a market for this many restaurants?
Out of curiosity I decided to take a look using the new version of ESRI Business Analyst Online. Using Business Analyst Online I was quickly able to select the city and run a Retail MarketPlace Profile report. This is an extremely valuable report in that it gives you a picture of the supply and demand for specific goods and services within your area of interest.
Using this report I was quickly able to get a picture of what was going on: there is a great deal more supply for eateries than the citizens of Redlands demand. In this case: $42,000,000 per year more supply than demand. Now in the case of Redlands this may not be a bad thing. It means that this little historic city can (and is) attracting people from outside the city to come eat at its restaurants, bringing more tax dollars to the city.
However, when I look at the other details of the report one particular line item catches my eye: a dirth of supply for electronics and appliance stores. And it’s true: I’ve lived in this city for almost 5 years now, and every time I’ve gone out to purchase an appliance or a piece of electronics I’ve had to go out of my way to other cities.
So check out the Retail MarketPlace report – it’s one quick way to understand your market.
Note to any prospective restaurant owners though: we’re well covered for raw fish in this town!
The 2009 update to Address Coder, Esri’s stand-alone geocoding and data appending software, started shipping this week. The update includes Tele Atlas geocoding reference data (based on February 2009 data) and Esri’s 2009 demographic and Tapestry data.
We made some minor changes to the user interface to improve the setup of geocoding/data appending jobs.
In addition, we added a new feature ‘Append Closest to Site’. It allows users to determine, from a list of stores for example, which store is closest to an address record. When using this feature, the output file includes a field called CLOSEST_ID that indicates the closest store’s ID. This feature can be used by retailers for determining which customers are in a store’s trade area; or for determining the right merchandise mix for a store. It can even help sales managers determine sales territories.
by Kyle Watson
Earl Nordstrand, our fearless leader has come up with a cool challenge for the 2009 User Conference. He created six US maps highlighting a demographic scenario available as part of ESRI’s demographic data and in the Business Analyst Products. The six maps will hang in the San Diego Convention Center lobby. They all look alike, yet there are clues on each that make them vastly different.
Here are the six demographic scenarios you have to link to each map:
- 2009 Unemployment Rate
- 2000 – 2009 Population: Annual Compound Growth Rate
- 2000 Vacant Housing Units: Seasonal/Recreational/Occasional Use
- 2009 Population 15+ by Marital Status: Never married
- 2009 Diversity Index
- 2009 Average Family Size
Think you can pinpoint all six? Come by the Commercial Solutions island and we’ll tell you the answers.
For now…here’s a live look into the “Official ESRI Map Challenge Laboratory War Room/Hallway”. Jim and James are giving the final check check check 1,2′s.
by Catherine Spisszak
While on my normal last-minute rush to buy Father’s Day gifts last night, I realized I was again faced with predicament of buying presents for men that have everything and ask for nothing. The classic gift ideas include clothing, tools or sporting equipment; however, my father could probably circumnavigate the earth three times with all of his ties and I think he has the #1 Dad coffee mug in every color.
In the spirit of Father’s Day, let’s investigate consumer spending on the typical gifts for dad.
In South Padre Island, Texas, households will spend $321.72 on average on men’s apparel in 2009.
In Shaver Lake, California, the Spending Potential Index for shaving needs is 88 (ironically, 12% below the national average – an index of 100 represents the national average).
In Tool City, Texas the Spending Potential Index for power tools is 51 and 76 for hand tools – again, both below the national average.
Households in Fisher Island, FL will spend $27 on average Hunting and Fishing Equipment in 2009, 30% lower than the national average.
Finally, dads in Chevy Chase Village, Maryland can look forward to higher price presents. That area boasts the highest Spending Potential Index for both television purchases and photo equipment and supply purchases at 450 and 425 respectively.
To find out what other goods and services are represented in the Esri Consumer Spending database, please visit http://www.esri.com/data/esri_data/index.html and a special Happy Father’s Day wish to all the dads out there.
by Catherine Spisszak
Esri is proud to announce the release of its 2009/2014 Updated Demographic Data. The 2009 data is currently available in Esri Business Analyst Online and for all ad hoc data only orders.
In the past year, changes in the nation’s economy have become extremely personal. The failure of the subprime mortgage market in 2007 extended its impact in 2008, shaking the foundations of the U.S. economy and in some capacity touching every household in the country. Following are some of the key demographic changes for the United States in 2009:
- Foreclosures up 81% in 2008, with sharp increases since January 2009
- 2009 median home value at $162,000, down 11.3% from 2008
- 2008–2009 median home value declined in more than two-thirds of U.S. counties
- Unemployment rate up to 10.6% (not seasonally adjusted)
- Job loss at 5.6 million in past year
- Median household income decline in 37% of U.S. counties
- Median net worth decline by 7.6% to less than $98,000
- Fastest-growing areas, 2000–2009:
- Flagler County, Florida;
- Kendall County, Illinois (Chicago metro area);
- Rockwall County, Texas (Dallas-Fort Worth metro area);
- Pinal County, Arizona (Phoenix metro area)
- Fastest-growing ZIP Codes, 2000–2009: 89084—North Las Vegas, Nevada; 89086—North Las Vegas, Nevada; 89138—Las Vegas, Nevada; and 80238—Denver, Colorado
Esri’s Updated Demographics are available in a variety of geographies, formats, and variables. For more information please visit http://www.esri.com/data/esri_data/index.html
The weather is starting to get warmer in the Northeast – the trees are starting to bud and you need to start mowing your lawn again. This means that it’s time for the people affectionately referred to as “snowbirds” to start to migrate back north, along with the never ending flocks of Canadian Geese. “Snowbirds” are the people that have the luxury of spending the winter months in warmer locations. Esri’s Quarterly Population and Household Updates can be used to view periodic fluctuations in the data, such as seasonal population shifts. Population and household totals are provided for eight quarters for the current year and the preceding year. Some notable seasonal fluctuations include Key West, FL which will see a 1.43% decrease in population from Q1 (January 1, 2009) to Q3 (July 1, 2009), which includes my aunt by the way. Areas in Colorado and Utah experience population increases from January 1st, 2009 to April 1st, 2009 from those lucky people that are employed seasonally in the ski areas during the winter season. Silverthorne, CO experienced a 1.26% increase and Vernal, UT saw a 0.63% increase from Q1 to Q2. And for those of us that have to stay in the same place all year long, you can learn more about Esri’s Quarterly Population and Household Updates at http://www.esri.com/data/esri_data/demographic.html
The weather is starting to get warmer in the Northeast – the trees are starting to bud and you need to start mowing your lawn again. This means that it’s time for the people affectionately referred to as “snowbirds” to start to migrate back north, along with the never ending flocks of Canadian Geese. “Snowbirds” are the people that have the luxury of spending the winter months in warmer locations.
Esri’s Quarterly Population and Household Updates can be used to view periodic fluctuations in the data, such as seasonal population shifts. Population and household totals are provided for eight quarters for the current year and the preceding year.
Some notable seasonal fluctuations include Key West, FL which will see a 1.43% decrease in population from Q1 (January 1, 2009) to Q3 (July 1, 2009), which includes my aunt by the way. Areas in Colorado and Utah experience population increases from January 1st, 2009 to April 1st, 2009 from those lucky people that are employed seasonally in the ski areas during the winter season. Silverthorne, CO experienced a 1.26% increase and Vernal, UT saw a 0.63% increase from Q1 to Q2.
And for those of us that have to stay in the same place all year long, you can learn more about Esri’s Quarterly Population and Household Updates at http://www.esri.com/data/esri_data/demographic.html
by Kyle Watson
I’ve been playing around with our 2009 demographic data. Here’s a preview of it showing a nationwide look at our changing workforce. I knew of Michigan and South Carolina’s recent struggles, but I didn’t realize other parts of the Deep South and PacNW were so severely hit. Are they are a step behind the nation…or a step ahead?
Here’s some context regarding the map above from our Data Development team:
The US Labor Force is forecasted to shed nearly 5.6 million jobs by July 2009 as compared to the year prior. With the exception of Wyoming (hello mineral wealth, among other industries), all states suffer some level of employment loss, as highlighted in the darker areas on the map. Regionally, almost 2 million of these job losses are concentrated in the Southern states, followed by 1.4 million in the Midwest and one million in the Northeast.
Here’s another national look, this time showing unemployment rates by county. West Coast – Yikes.
Here’s a further breakdown of this map looking at the unemployment stats.
- 16.7% …where I live now (San Bernardino County, CA)
- 10.4% …where I grew up (Livingston County, MI)
- 14.9% …where my wife grew up (Delta County, MI)
- 7.9% …where my parents live (Brown County, WI)
- 9.6% …where my best friend lives (Hennepin County, MN)
- 16.7% …where I went to college (Ingham County, MI…Go Spartans)
- 13.7% …where I had an internship (Multnomah County, OR)
- 9.9% …where I caught a rainbow trout (Kenai Peninsula Borough, AK)
Looks like the safe bet is to move into my parent’s basement. Not sure I could deal with that many sausage and cheese eating Green Bay Packers fans in one town though. Better off staying put and riding out this economic cold snap!
by Jim Herries
Joseph Kerski, ESRI Education Manager, posted a nice blog titled “What Is My Neighborhood Really Like?” last week about ESRI’s free ZIP Lookup Tool. Thanks, Joseph, for the plug! It’s one of my favorite free things that ESRI does, and I’m not just saying that because our team is going to update that tool soon.
Based on our statistics, it’s also a favorite of many people who know ESRI but don’t know we have data like this; and of people who know data like this but don’t know about ESRI. Why the popularity?
When I want a sure-fire way to warm up a room of people to what I do, what ESRI does, what demographic data really is, I start with the Free ZIP Lookup tool. Usually I go for that person in the audience who’s giving you that face that says “look, I’m here but I’m on the fence about this topic.” So I pretend I’m a Radio Shack employee again (from 1988, $3.35 an hour plus commission pushing everything from diodes to 286 computers) and I ask them for their home ZIP Code.
I type in the ZIP Code — it is the perfect demo because you only have to type five numbers, press enter, and a page full of data pops up. Try it yourself — what I enjoy is the interaction with the crowd, as we read through the names of the top segments in the ZIP Code, e.g.
Second in wealth to Top Rung but first for conspicuous consumption, Connoisseurs residents are well educated and somewhat older, with a median age of 47.3 years. Although residents appear closer to retirement than child rearing age, many of these married couples have children who still live at home. Their neighborhoods tend to be older bastions of affluence where the median home value is $706,720. Growth in these neighborhoods is slow. Residents spend money for nice homes, cars, clothes, and vacations. Exercise is a priority; they work out weekly at a club or other facility, ski, play golf, snorkel, play tennis, practice yoga, and jog. Active in the community, they work for political candidates or parties, write or visit elected officials, and participate in local civic issues.
Why does this break the ice? Everyone in the room looks at the person you called on for the ZIP Code to validate whether he or she is a “Connoisseur” as described, or someone quite different. Suddenly, demographic data is not a dry recitation of facts and figures, it becomes a conversation…I’ve had people shout out “do my ZIP Code next.”
Try it out, and post your favorite “ZIP Lookup Tool” story here…
by Kyle Watson
ArcGIS Business Analyst for the desktop comes with a plethora of valuable tools, sometimes we hear, “wow, I had no idea that did that…cool!”. Here’s a great one that maybe you haven’t used: the Summarize Points Report.
Here’s what is does: It allows you to (1) quickly total up the number of locations (often businesses, customers, or competitors, etc.) within a given area and then (2) summarize site specific values for your trade area or any other polygon layer such as sales volume, total employees, or number of transactions. The tool summarizes points within a polygon; for example, you can use this tool to:
- Calculate how many customers are within a 5-mile radius of your franchise PLUS how much they’ve purchased at your store.
- Determine how many ATM locations are within a group of census tracts PLUS the total dollar amount withdrawn within each of the tracts.
Here is a simple graphic explanation:
In this example the Summarize Points Report totals up four points (ATM locations) in a polygon (census tract) and also totals up any volumetric field in the ATM database ($100 worth of individual transactions). The output options are a thematic map layer and corresponding presentation-ready report.
Many of these individual functions are available in ArcGIS now (ex: Spatial Join, Summarize Statistics, etc.) but the Summarize Points Report in Business Analyst bundles it in one simple workflow. Try it now at: Business Analyst menu > Run reports > Point and ranking based reports > Summarize Points Report.
Keep it real,
When I joined the ArcGIS Business Analyst team about a year ago I was astounded by the depth and breadth of data that we ship with the Business Analyst products — over 11,000 variables on current year and five year forecast demographics, thousands of variables on consumer spending habits, over 12,000,000 businesses, crime data, traffic congestion data, banking data — this list just goes on and on and on.
If you want to see just how insane it gets take a look at this:
Households that used three or more packages of dog biscuits in the last month?? You’re kidding me?
It turns out we’re not just creating all this data for fun. It’s actually vital for learning where a business can be successful or determining ways in which a business can be made more successful. You can use it to laser focus your marketing … or to help you decide which product lines to carry in a store … or to help determine whether a particular location is still viable for business.
If you want to see more drill down to the Esri data pages on esri.com at http://www.esri.com/data/esri_data
Have fun exploring…