Tuesday, October 19, 2010
Thursday, October 14, 2010
Project 3: GIS and Economic Development - Data
This map compares four demographic parameters with the locations of the two Better Books stores and competitor store locations.
This map is the first stage in a market analysis for a bookstore company, Best Books, in San Francisco, CA. This map identifies the one mile market zone around each of the two store locations and also the relative percentages of homes with occupants who have pursued college.
This map is the first stage in a market analysis for a bookstore company, Best Books, in San Francisco, CA. This map identifies the one mile market zone around each of the two store locations and also the relative percentages of homes with occupants who have pursued college.
Monday, October 11, 2010
Greenspace in Marin City --> Results Week!
Attached please find a PowerPoint presentation related to the work assignment in the Results Week of Project 2 (Special Topics in GIS)
PowerPoint presentation regarding Greenspace in Marin City, California and efforts to offset utility costs for the Marin City Center
PowerPoint presentation regarding Greenspace in Marin City, California and efforts to offset utility costs for the Marin City Center
Sunday, October 3, 2010
Marin City, CA Greenspace (Project 2, Part 2 - Analysis)
Percent tree cover was determined for five neighborhoods in Marin City, California in an effort to demonstrate to the Marin City Manager of the importance of retaining and expanding the city's greenspace.
Calculations were performed to determine the carbon storage and carbon sequestration in the trees in each of the five neighborhoods.
Calculations were performed to determine the carbon storage and carbon sequestration in the trees in each of the five neighborhoods.
Monday, September 27, 2010
Week 4: Marin City, CA Greenspace Study
The attached maps present imagery of Marin City, CA that has been reclassified to depict the regions throughout the city that are dominated by trees, grass, and impervious layers. The first map shows the location of Marin City by providing inset maps of both Marin County and the group of San Francisco Bay Area Counties.
The second map presents just the Marin City data frame that was generated in ArcInfo 9.3.1 so the classification can be more clearly evaluated or examined.
Metadata Screenshot
The second map presents just the Marin City data frame that was generated in ArcInfo 9.3.1 so the classification can be more clearly evaluated or examined.
Metadata Screenshot
Saturday, September 25, 2010
Analysis: Asthma Hospitalizations in San Francisco Related to Air Quality
Three maps, attached, describe the assessment of air quality in the San Francisco Bay Area counties and their relationship with asthma hospitalization rates.
Tuesday, September 7, 2010
Prepare: Air Pollution, Asthma, and Race in the San Francisco Bay Area
The following hyperlinks show the metadata that was created to correspond with four excel data files corresponding to air quality and human health parameters in the San Francisco Bay area counties.
Metadata for asthma hospitalization rates
Metadata for demographics in the San Francisco Bay Area
Metadata for ozone concentrations
Metadata for particulate matter concentrations
The two excel spreadsheets listed below correspond to the merging of: 1) asthma hospitalization data and demographics and, 2) atmospheric ozone and particulate matter concentrations.
Merged data files for asthma hospitalization and race
Merged data files for ozone and particulate matter
Process Summary for
Prepare I: Air Pollution, Asthma, and Race in the San Francisco Bay Area
Brian E. Rood
September 7, 2010
Objective:
To gather data from typical public-access sites that will be incorporated into a comprehensive GIS that will elucidate the relationship between air quality, human health, and race in the San Francisco Bay Area counties.
Data Gathering:
Demographic data was parsed out from the US Census 2000 website,(http://factfinder.census.gov/servlet/datasetmainpageservlet) to identify the racial composition of the San Francisco Bay Area counties.
Asthma hospitalization rates (sorted by race) were manually transcribed from the California County Asthma Hopitalization Chart Book (Data from 1998-2000), California Department of Health Services. 9/03.
Air quality data (ozone and particulate matter) were both downloaded from the Bay Area Air Quality Management District (BAAQMD)(http://www.baaqmd.gov)
Data Handling:
The downloaded data were copied into separate MS Excel spreadsheets.
The resulting spreadsheets were modified to a format that would be
suitable to merge into the attribute table of existing shapefiles provided
by Ms. Trisha Holtzclaw. FID numbers were incorporated into the
spreadsheets that would be matched with the pre-existing FID values in
the shapefiles.
Documentation:
The metadata for the spreadsheets were updates in ArcCatalog using the
metadata file editor function. In the meantime, I realized that it would be
most appropriate to first merge the demographic and asthma
hospitalization rate files because these data would ultimately be merged
with the county shapefile (polygons), and the ozone and particulate
should be merged because they would be joined with the air monitoring
stations layer (point shapefile). Once these spreadsheets were
appropriately merged, then the metadata files could be updated.
Future Expectation:
The collected and modified data will be examined and incorporated into
a comprehensive GIS that will help us better understand patterns and
correlations of air quality, race, and human health in the San Francisco
Bay Area counties.
Metadata for asthma hospitalization rates
Metadata for demographics in the San Francisco Bay Area
Metadata for ozone concentrations
Metadata for particulate matter concentrations
The two excel spreadsheets listed below correspond to the merging of: 1) asthma hospitalization data and demographics and, 2) atmospheric ozone and particulate matter concentrations.
Merged data files for asthma hospitalization and race
Merged data files for ozone and particulate matter
Process Summary for
Prepare I: Air Pollution, Asthma, and Race in the San Francisco Bay Area
Brian E. Rood
September 7, 2010
Objective:
To gather data from typical public-access sites that will be incorporated into a comprehensive GIS that will elucidate the relationship between air quality, human health, and race in the San Francisco Bay Area counties.
Data Gathering:
Demographic data was parsed out from the US Census 2000 website,(http://factfinder.census.gov/servlet/datasetmainpageservlet) to identify the racial composition of the San Francisco Bay Area counties.
Asthma hospitalization rates (sorted by race) were manually transcribed from the California County Asthma Hopitalization Chart Book (Data from 1998-2000), California Department of Health Services. 9/03.
Air quality data (ozone and particulate matter) were both downloaded from the Bay Area Air Quality Management District (BAAQMD)(http://www.baaqmd.gov)
Data Handling:
The downloaded data were copied into separate MS Excel spreadsheets.
The resulting spreadsheets were modified to a format that would be
suitable to merge into the attribute table of existing shapefiles provided
by Ms. Trisha Holtzclaw. FID numbers were incorporated into the
spreadsheets that would be matched with the pre-existing FID values in
the shapefiles.
Documentation:
The metadata for the spreadsheets were updates in ArcCatalog using the
metadata file editor function. In the meantime, I realized that it would be
most appropriate to first merge the demographic and asthma
hospitalization rate files because these data would ultimately be merged
with the county shapefile (polygons), and the ozone and particulate
should be merged because they would be joined with the air monitoring
stations layer (point shapefile). Once these spreadsheets were
appropriately merged, then the metadata files could be updated.
Future Expectation:
The collected and modified data will be examined and incorporated into
a comprehensive GIS that will help us better understand patterns and
correlations of air quality, race, and human health in the San Francisco
Bay Area counties.
Subscribe to:
Posts (Atom)
