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.

Monday, July 26, 2010

Sunday, July 11, 2010

Pensacola Rectified





http://students.uwf.edu/scm19/pensacola_321.xps


This worked out OK. The biggest problem I had was finding the picture points in the instructions. duh. Then there was the problem with the system crash, and subsequent data loss when I pushed zoom extents in the edit mode.

I have collected picture points in the field, and I had a class on what was done with them back in the day of stereo plotters. This is great fun, even though the program is sticky.

Tuesday, July 6, 2010

Module 2


Remote Sensing: Module2 This is the hyper link to the index sheet for the work.

Tuesday, April 6, 2010

Google Map Wind Farm

For this lab I researched the internet for electric transmission corridors, bird fly ways, average annual wind. Then I opened ArcGIS and a U.S. population shape file in the WGS 84 projection.

I decided that the best place to put a wind farm in the Great Lakes would be a place where the population density was limited so I made a four color population map. Then I geo-referenced the images I downloaded on that map and exported them and posted them as a image over lay on Google map.

T. Boone Pickens said that the only way to make wind power work was to connect it to the existing grid, so I posted the grid map to Google first. I used the polyline tool to transcribe to My Places. The grid map provided three possibilities for the site location along Lake Superior where the average annual wind sped would make the facility cost effective. Then I posted the bird fly way over lay. That eliminated two possibilities right away.

This image is the remaining possibility as determined by the Grid Tie Cost Parameter.

Tuesday, March 30, 2010

Wednesday, March 24, 2010

Monday, March 8, 2010

Sunday, February 28, 2010




I had to range grade the consumption to limit the classes to 5.

Monday, February 22, 2010

Population Change by Census Region


First Draft

Population Change by State




I inserted a scale in ArcGIS over Alaska, used the measure tool then divided the measured distance by the scale distance got a percentage, and used that percentage to resize the state in AI. Hawaii seemed fine.

Friday, February 12, 2010

Hispanic Population

After many trials I was able to post this at 11 x 8.5 with the prescribed neat line.

Friday, February 5, 2010

Florida Keys




This took some time. I was expecting AI to be more like Photoshop. I am getting the hang of it. I still can't animate a .gif.

Sunday, January 10, 2010

Bad Map


This is a colorful plan view of the north end of Long Island, NY. It does impart some information, but the purpose is to be colorful.

Good Map

This is a clean map with a clear purpose, and understandable symbolization. The level of difficulty of the data collection is intriguing to me. I "quick tested" the scale of the map against the current edge of water survey it seems OK. I was surprised to see how much of the Harbour had been filled in.