Site Selection Analysis for New Store
This was a fun project with lots of real world applications! The color of the slides gets a little lost in the background but I still think they are visible.
Thursday, October 28, 2010
Project 3-GIS & Economics
Project 3-Final Report for Better Books, Inc
Site Selection Analysis for New Store
This was a fun project with lots of real world applications! The color of the slides gets a little lost in the background but I still think they are visible.
Site Selection Analysis for New Store
This was a fun project with lots of real world applications! The color of the slides gets a little lost in the background but I still think they are visible.
Sunday, October 24, 2010
Project 3-GIS & Economics
Part 2-Analysis for siting a new store for the Better Books franchise.
Step 1- Review market areas
This portion of the project analyzes two market conditions. The first map shows the market areas around both hypothetical stores representing the area responsible for 60% of all sales. This also contained another polygon surrounding the 60% area showing the area of 80% of the sales. It was deemed that the most important measure was the concentration of sales closest to the book stores, so only the 60% area is shown. The household income and the Book Lover Club members are also shown.The second map shows the area around each store showing driving times to the stores for 1 minute and 3 minutes. After reviewing both of these markets and comparing against demographics, such as total population, annual population growth, household income and average home valuation it was determined that that the Steiner store has a population that is growing and has a higher net worth and higher home values. Comparing the statistics of drive time to the stores, the population surrounding the Steiner store is over three times larger within 1 minute and over 2 times larger than the Bosworth store. The net worth, and home valuations are still higher in the Steiner neighborhoods. In both cases the Bosworth area has a higher average household income but it is also noted that the Book Lover Club annual sales are consistently higher for the Steiner store. It was determined that the Steiner Store is the model store.
Step 2-Review potential book store sites.
Three sites have been determined for new stores. The are the Northwest, Southwest and East Central locations. The following map shows a 1 mile buffer radius from the potential stores with the census blocks shown that have their centroid within the 1 mile buffer. The demographics for these stores have also been examined. At first glance the East Central appears to be the most desirable location for a new store as it has the highest overall population, the highest number of households and highest number of Book Lover Club members. However currently there are 12 competitor stores within a 1 mile radius of this location. It is also noted that although the Northwest store has the lowest overall population, it has the highest average household income, highest average net worth and highest home values. The Northwest location has only 4 competing stores within the 1 mile buffer and the 2nd highest number of Book Lover Club members. It appears at this point in the analysis, the Northwest location will have the best possibility of success based on these statistics and factors. No real estate costs were determined for any of these sites.
Step 1- Review market areas
This portion of the project analyzes two market conditions. The first map shows the market areas around both hypothetical stores representing the area responsible for 60% of all sales. This also contained another polygon surrounding the 60% area showing the area of 80% of the sales. It was deemed that the most important measure was the concentration of sales closest to the book stores, so only the 60% area is shown. The household income and the Book Lover Club members are also shown.The second map shows the area around each store showing driving times to the stores for 1 minute and 3 minutes. After reviewing both of these markets and comparing against demographics, such as total population, annual population growth, household income and average home valuation it was determined that that the Steiner store has a population that is growing and has a higher net worth and higher home values. Comparing the statistics of drive time to the stores, the population surrounding the Steiner store is over three times larger within 1 minute and over 2 times larger than the Bosworth store. The net worth, and home valuations are still higher in the Steiner neighborhoods. In both cases the Bosworth area has a higher average household income but it is also noted that the Book Lover Club annual sales are consistently higher for the Steiner store. It was determined that the Steiner Store is the model store.
Step 2-Review potential book store sites.
Three sites have been determined for new stores. The are the Northwest, Southwest and East Central locations. The following map shows a 1 mile buffer radius from the potential stores with the census blocks shown that have their centroid within the 1 mile buffer. The demographics for these stores have also been examined. At first glance the East Central appears to be the most desirable location for a new store as it has the highest overall population, the highest number of households and highest number of Book Lover Club members. However currently there are 12 competitor stores within a 1 mile radius of this location. It is also noted that although the Northwest store has the lowest overall population, it has the highest average household income, highest average net worth and highest home values. The Northwest location has only 4 competing stores within the 1 mile buffer and the 2nd highest number of Book Lover Club members. It appears at this point in the analysis, the Northwest location will have the best possibility of success based on these statistics and factors. No real estate costs were determined for any of these sites.
Monday, October 18, 2010
Project 3-GIS & Economic Development
Week 1-Prepare Data
This week's submittal represents a hypothetical book store chain in San Francisco, CA. The Better Books store is trying to determine where to open a new store. The maps represent the following: Map 1 is the demographics of the area, Map 2 shows a 1 mile buffer radius around each store and how many of the Better Book Lover's club reside within those buffers. Map 3 shows the market areas based on U.S. Census data showing the census blocks that their centroid within the 1 mile buffer. Map 4 shows the market areas overlaid with the the percentage of the population that has had some college. The project to this point has been straightforward except for loading these large (12-15mb) maps into this blog. I had to compress the size, so the quality of the maps is not as clear as I would like. In addition to these maps a calculation page was prepared showing average household income, number of households and average home values within the market areas.
This week's submittal represents a hypothetical book store chain in San Francisco, CA. The Better Books store is trying to determine where to open a new store. The maps represent the following: Map 1 is the demographics of the area, Map 2 shows a 1 mile buffer radius around each store and how many of the Better Book Lover's club reside within those buffers. Map 3 shows the market areas based on U.S. Census data showing the census blocks that their centroid within the 1 mile buffer. Map 4 shows the market areas overlaid with the the percentage of the population that has had some college. The project to this point has been straightforward except for loading these large (12-15mb) maps into this blog. I had to compress the size, so the quality of the maps is not as clear as I would like. In addition to these maps a calculation page was prepared showing average household income, number of households and average home values within the market areas.
Monday, October 11, 2010
Project 2-GIS and Landscape Design
Report Week-Marin, California Tree Study
Project Goals--To show the number of trees and the energy savings associated with trees.
and to show the number of trees that need to be planted to offset ½ of the energy costs associated with the proposed Marin City Center.
This map is to show the number of trees in the neighborhoods and the energy savings based an average cost of $4.39 per tree.
This map shows the Proposed Marin City Center.
Overall I thought this was a fun project and has a number of real world applications. It would seem that many municipalities will be undertaking studies like this to determine if the cost of mapping, planting and maintenance are beneficial to the city. As can be seen, an energy savings is only one of the benefits. Other benefits include: stormwater management, help with soil erosion, carbon storage and sequestration and an increase in property values.
Calculating the energy costs and the number of trees that needed to be planted for the proposed Marin City Center had a few challenges, as there was limited information on the building sizes or number of building proposed. I made a "crude" count of the buildings for my calculations and ultimately ended with around 1,200 trees that needed to be planted to offset ½ of the energy costs for the proposed City Center.
Project Goals--To show the number of trees and the energy savings associated with trees.
and to show the number of trees that need to be planted to offset ½ of the energy costs associated with the proposed Marin City Center.
This map is to show the number of trees in the neighborhoods and the energy savings based an average cost of $4.39 per tree.
This map shows the Proposed Marin City Center.
Overall I thought this was a fun project and has a number of real world applications. It would seem that many municipalities will be undertaking studies like this to determine if the cost of mapping, planting and maintenance are beneficial to the city. As can be seen, an energy savings is only one of the benefits. Other benefits include: stormwater management, help with soil erosion, carbon storage and sequestration and an increase in property values.
Calculating the energy costs and the number of trees that needed to be planted for the proposed Marin City Center had a few challenges, as there was limited information on the building sizes or number of building proposed. I made a "crude" count of the buildings for my calculations and ultimately ended with around 1,200 trees that needed to be planted to offset ½ of the energy costs for the proposed City Center.
Monday, October 4, 2010
Project 2-GIS & Landscape Design/Management
Part 2-Analysis
This phase of the project utilized a number of the Spatial Analyst tools. The biggest challenges came with the processing phases. Initially the image files (photos) were evaluated using the Isocluster tool, followed by the software using the Maximum Likelihood evaluator. This was to classify the images into 50 classes. Initially this process failed many times. I was able to get it to process using 25 classes. Later the instructor provided a 50 class raster using the mosaic tool. I then changed my strategy from using the 7 images I had converted to using the provided mosaic file. The next steps involved identifying the pixel values to determine the types of land classes. The goal being to classify into 3 classes, either Trees, Grass or Impermeable surfaces. I then used the Reclass tool to classify the 50 classes into three classes. This process ultimately failed over 15 times, however through a consultation with my GIS internship supervisor, I found some work-arounds using the Extract by Attributes. After this Extract by Attributes the software had no issues reclassifying the raster to 3 classes. Another part of this whole process involved using the Extract by Mask tool to make the project relevant to just the neighborhoods of the study area. Finally the tables were manipulated using the field calculator to compute percentages of trees, carbon storage and carbon sequestration, followed by constructing the graphs to add to the maps.
Despite some processing frustrations, I learned a number of things about the Spatial Analyst tool set and classifying and reclassifying rasters
This phase of the project utilized a number of the Spatial Analyst tools. The biggest challenges came with the processing phases. Initially the image files (photos) were evaluated using the Isocluster tool, followed by the software using the Maximum Likelihood evaluator. This was to classify the images into 50 classes. Initially this process failed many times. I was able to get it to process using 25 classes. Later the instructor provided a 50 class raster using the mosaic tool. I then changed my strategy from using the 7 images I had converted to using the provided mosaic file. The next steps involved identifying the pixel values to determine the types of land classes. The goal being to classify into 3 classes, either Trees, Grass or Impermeable surfaces. I then used the Reclass tool to classify the 50 classes into three classes. This process ultimately failed over 15 times, however through a consultation with my GIS internship supervisor, I found some work-arounds using the Extract by Attributes. After this Extract by Attributes the software had no issues reclassifying the raster to 3 classes. Another part of this whole process involved using the Extract by Mask tool to make the project relevant to just the neighborhoods of the study area. Finally the tables were manipulated using the field calculator to compute percentages of trees, carbon storage and carbon sequestration, followed by constructing the graphs to add to the maps.
Despite some processing frustrations, I learned a number of things about the Spatial Analyst tool set and classifying and reclassifying rasters
Project 2-GIS & Landscape Design/Management
Part 1-Base Map of Marin Study Area
Base Map of Marin, California study area.
Subscribe to:
Posts (Atom)