Sunday, October 31, 2010

Project 3 Report



Business Expansion
By: Stephen Macdonald
October 31, 2010

This is a study of the business environment for a proposed expansion of the Better Books chain in the San Francisco, California market.
Better Books wishes to open a new store. The goal of this study is to test six potential markets in the San Francisco area to find the market location that best matches the demographic profile of its stores and minimizes cannibalization.

The comparative data used for this iteration are census block details for population and income, the number, size, and location of the competition, and the stores buyer’s club database.

The Steiner location is by far the best performer of the two stores being in a high density, high income neighborhood, and although it revenues from sales is almost 30% higher than the Bosworth location none of the potential sites has comparable demographics. Both the Steiner and the Bosworth stores are on a major road providing easy access and high visibility to the site.

The East Central location is near the highway, but not near a ramp giving it visibility, but not access, also the number of competitors and cannibalization is high. The Southwest site is a commercial site in the poorest residential area in the survey. The Northwest site is the furthest site from the other two stores, but it has a high cannibalization rate from both stores, indicating that these buyers are willing to travel a long distance to shop at Better Books. The population density and the household income are comparable to the Bosworth location, but the available site is a considerable way from a major street.


CONCLUSION

Being that the completion in the northwest market is limited, and the demographics are comparable, I suggest that management revisit the northwest target market and seek out another site on a major road with better visibility.

Monday, October 18, 2010

Saturday, October 16, 2010

Prepare Week – Market Analysis


I picked up a few tricks from the
ESRI Cartography Class. The Extents rectangle on the study area map is one of the frame properties, and I am trying to work on my colors.
I draped the income map over the hillshade layer to see if slope was a factor.

Thursday, October 14, 2010

Sunday, October 3, 2010

Sunday, September 19, 2010

San Francisco Public Health



The purpose of this project was to reexamine and attempt to identify variables in the outdoor physical environmental that could be related to an elevated risk in asthma hospitalization rates in the San Francisco Bay Area Urban Area. A report developed by the Bayview Hunters Point Health and Environmental Assessment Task Force in 1996 indicated that the risk of non elderly adult asthma was 2.2% higher than the national average . The attempt here was to go from a general hypothesis that a detectable anthropogenic vector was involved, and the effect will be manifested in the census tracking information.

This project blended census spatial and relational population data with civil, health, and pollution spatial and relational data to produce a series of 10 maps that evolve the data to the point where some field validation can take place at a relatively low cost.

While the technological developments of the 21st century can blend an data quickly in previously unimaginable number of permutations there is no escaping GIGO. GIGO means garbage in, Garbage out. This analysis produced result and presented a recommendation for increased funding at a specific area with a census group that is similar to the national asthma sensitive census group, but without some form of ground truth, there is no way to know if that particular blacks population center is historically vulnerable to previously mentioned vectors.

Some of the included data will be valuable after processing to go out, canvas the identified population center, and improve on the reliability of the preliminary conclusion. Using the monthly data for the vectors a seasonal outbreak can be forecast ( if there is a relationship ) Then local road maps could be generated breaking the area into manageable canvassing zones that can expected be covered in a reasonable amount of time with a finite number of people.

San Francisco Bay Area Urban Area is a huge area to cover with a trained canvassing team. It is essential that specific areas of a specific size can be identified to ensure the hypothesis is adequately measured in the field to validate the procedure as feasible, and the site as a training site for remote sensing. The land based air quality monitors are poorly managed, and the data stream is spotty at best. The next level of research needs real time data from satellites and from the hospitals to adequately define the health parameters in the urban areas.