A. SUMMARY Medical provider confirmed COVID-19 cases and confirmed COVID-19 related deaths in San Francisco, CA aggregated by several different geographic areas and normalized by 2016-2020 American Community Survey (ACS) 5-year estimates for population data to calculate rate per 10,000 residents. On September 12, 2021, a new case definition of COVID-19 was introduced that includes criteria for enumerating new infections after previous probable or confirmed infections (also known as reinfections). A reinfection is defined as a confirmed positive PCR lab test more than 90 days after a positive PCR or antigen test. The first reinfection case was identified on December 7, 2021. Cases and deaths are both mapped to the residence of the individual, not to where they were infected or died. For example, if one was infected in San Francisco at work but lives in the East Bay, those are not counted as SF Cases or if one dies in Zuckerberg San Francisco General but is from another county, that is also not counted in this dataset. Dataset is cumulative and covers cases going back to 3/2/2020 when testing began. Geographic areas summarized are: 1. Analysis Neighborhoods 2. Census Tracts 3. Census Zip Code Tabulation Areas B. HOW THE DATASET IS CREATED Addresses from medical data are geocoded by the San Francisco Department of Public Health (SFDPH). Those addresses are spatially joined to the geographic areas. Counts are generated based on the number of address points that match each geographic area. The 2016-2020 American Community Survey (ACS) population estimates provided by the Census are used to create a rate which is equal to ([count] / [acs_population]) * 10000) representing the number of cases per 10,000 residents. C. UPDATE PROCESS Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 7:30 Pacific Time. D. HOW TO USE THIS DATASET San Francisco population estimates for geographic regions can be found in a view based on the San Francisco Population and Demographic Census dataset. These population estimates are from the 2016-2020 5-year American Community Survey (ACS). Privacy rules in effect To protect privacy, certain rules are in effect: 1. Case counts greater than 0 and less than 10 are dropped - these will be null (blank) values 2. Death counts greater than 0 and less than 10 are dropped - these will be null (blank) values 3. Cases and deaths dropped altogether for areas where acs_population < 1000 Rate suppression in effect where counts lower than 20 Rates are not calculated unless the case count is greater than or equal to 20. Rates are generally unstable at small numbers, so we avoid calculating them directly. We advise you to apply the same approach as this is best practice in epidemiology. A note on Census ZIP Code Tabulation Areas (ZCTAs) ZIP Code Tabulation Areas are special boundaries created by the U.S. Census based on ZIP Codes developed by the USPS. They are not, however, the same thing. ZCTAs are areal representations of routes. Read how the Census develops ZCTAs on their website. Row included for Citywide case counts, incidence rate, and deaths A single row is included that has the Citywide case counts and incidence rate. This can be used for comparisons. Citywide will capture all cases regardless of address quality. While some cases cannot be mapped to sub-areas like Census Tracts, ongo
A. SUMMARY This dataset contains COVID-19 positive confirmed cases aggregated by several different geographic areas and by day. COVID-19 cases are mapped to the residence of the individual and shown on the date the positive test was collected. In addition, 2016-2020 American Community Survey (ACS) population estimates are included to calculate the cumulative rate per 10,000 residents. Dataset covers cases going back to 3/2/2020 when testing began. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available. Data updated daily. Geographic areas summarized are: 1. Analysis Neighborhoods 2. Census Tracts 3. Census Zip Code Tabulation Areas B. HOW THE DATASET IS CREATED Addresses from the COVID-19 case data are geocoded by the San Francisco Department of Public Health (SFDPH). Those addresses are spatially joined to the geographic areas. Counts are generated based on the number of address points that match each geographic area for a given date. The 2016-2020 American Community Survey (ACS) population estimates provided by the Census are used to create a cumulative rate which is equal to ([cumulative count up to that date] / [acs_population]) * 10000) representing the number of total cases per 10,000 residents (as of the specified date). COVID-19 case data undergo quality assurance and other data verification processes and are continually updated to maximize completeness and accuracy of information. This means data may change for previous days as information is updated. C. UPDATE PROCESS Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 05:00 Pacific Time. D. HOW TO USE THIS DATASET San Francisco population estimates for geographic regions can be found in a view based on the San Francisco Population and Demographic Census dataset. These population estimates are from the 2016-2020 5-year American Community Survey (ACS). This dataset can be used to track the spread of COVID-19 throughout the city, in a variety of geographic areas. Note that the new cases column in the data represents the number of new cases confirmed in a certain area on the specified day, while the cumulative cases column is the cumulative total of cases in a certain area as of the specified date. Privacy rules in effect To protect privacy, certain rules are in effect: 1. Any area with a cumulative case count less than 10 are dropped for all days the cumulative count was less than 10. These will be null values. 2. Once an area has a cumulative case count of 10 or greater, that area will have a new row of case data every day following. 3. Cases are dropped altogether for areas where acs_population < 1000 4. Deaths data are not included in this dataset for privacy reasons. The low COVID-19 death rate in San Francisco, along with other publicly available information on deaths, means that deaths data by geography and day is too granular and potentially risky. Read more in our privacy guidelines Rate suppression in effect where counts lower than 20 Rates are not calculated unless the cumulative case count is greater than or equal to 20. Rates are generally unstable at small numbers, so we avoid calculating them directly. We advise you to apply the same approach as this is best practice in epidemiology. A note on Census ZIP Code Tabulation Areas (ZCTAs) ZIP Code Tabulation Areas are spec
https://www.usa.gov/government-workshttps://www.usa.gov/government-works
This dataset contains model-based county estimates for drug-poisoning mortality.
Deaths are classified using the International Classification of Diseases, Tenth Revision (ICD–10). Drug-poisoning deaths are defined as having ICD–10 underlying cause-of-death codes X40–X44 (unintentional), X60–X64 (suicide), X85 (homicide), or Y10–Y14 (undetermined intent).
Estimates are based on the National Vital Statistics System multiple cause-of-death mortality files (1). Age-adjusted death rates (deaths per 100,000 U.S. standard population for 2000) are calculated using the direct method. Populations used for computing death rates for 2011–2016 are postcensal estimates based on the 2010 U.S. census. Rates for census years are based on populations enumerated in the corresponding censuses. Rates for noncensus years before 2010 are revised using updated intercensal population estimates and may differ from rates previously published.
Death rates for some states and years may be low due to a high number of unresolved pending cases or misclassification of ICD–10 codes for unintentional poisoning as R99, “Other ill-defined and unspecified causes of mortality” (2). For example, this issue is known to affect New Jersey in 2009 and West Virginia in 2005 and 2009 but also may affect other years and other states. Drug poisoning death rates may be underestimated in those instances.
Smoothed county age-adjusted death rates (deaths per 100,000 population) were obtained according to methods described elsewhere (3–5). Briefly, two-stage hierarchical models were used to generate empirical Bayes estimates of county age-adjusted death rates due to drug poisoning for each year. These annual county-level estimates “borrow strength” across counties to generate stable estimates of death rates where data are sparse due to small population size (3,5). Estimates for 1999-2015 have been updated, and may differ slightly from previously published estimates. Differences are expected to be minimal, and may result from different county boundaries used in this release (see below) and from the inclusion of an additional year of data. Previously published estimates can be found here for comparison.(6) Estimates are unavailable for Broomfield County, Colorado, and Denali County, Alaska, before 2003 (7,8). Additionally, Clifton Forge County, Virginia only appears on the mortality files prior to 2003, while Bedford City, Virginia was added to Bedford County in 2015 and no longer appears in the mortality file in 2015. These counties were therefore merged with adjacent counties where necessary to create a consistent set of geographic units across the time period. County boundaries are largely consistent with the vintage 2005-2007 bridged-race population file geographies, with the modifications noted previously (7,8).
REFERENCES 1. National Center for Health Statistics. National Vital Statistics System: Mortality data. Available from: http://www.cdc.gov/nchs/deaths.htm.
CDC. CDC Wonder: Underlying cause of death 1999–2016. Available from: http://wonder.cdc.gov/wonder/help/ucd.html.
Rossen LM, Khan D, Warner M. Trends and geographic patterns in drug-poisoning death rates in the U.S., 1999–2009. Am J Prev Med 45(6):e19–25. 2013.
Rossen LM, Khan D, Warner M. Hot spots in mortality from drug poisoning in the United States, 2007–2009. Health Place 26:14–20. 2014.
Rossen LM, Khan D, Hamilton B, Warner M. Spatiotemporal variation in selected health outcomes from the National Vital Statistics System. Presented at: 2015 National Conference on Health Statistics, August 25, 2015, Bethesda, MD. Available from: http://www.cdc.gov/nchs/ppt/nchs2015/Rossen_Tuesday_WhiteOak_BB3.pdf.
Rossen LM, Bastian B, Warner M, and Khan D. NCHS – Drug Poisoning Mortality by County: United States, 1999-2015. Available from: https://data.cdc.gov/NCHS/NCHS-Drug-Poisoning-Mortality-by-County-United-Sta/pbkm-d27e.
National Center for Health Statistics. County geography changes: 1990–2012. Available from: http://www.cdc.gov/nchs/data/nvss/bridged_race/County_Geography_Changes.pdf.
National Center for Health Statistics. County geography changes: 1990–2015. Available from: https://www.cdc.gov/nchs/nvss/bridged_race/county_geography-_changes2015.pdf.
Number of deaths and mortality rates, by age group, sex, and place of residence, 1991 to most recent year.
This layer shows particulate matter in the air sized 2.5 micrometers of smaller (PM 2.5). The data is aggregated from NASA Socioeconomic Data and Applications Center (SEDAC) gridded data into country boundaries, administrative 1 boundaries, and 50 km hex bins. The unit of measurement is micrograms per cubic meter.The layer shows the annual average PM 2.5 from 1998 to 2016, highlighting if the overall mean for an area meets the World Health Organization guideline of 10 micrograms per cubic meter annually. Areas that don't meet the guideline and are above the threshold are shown in red, and areas that are lower than the guideline are in grey.The data is averaged for each year and over the the 19 years to provide an overall picture of air quality globally. Some of the things we can learn from this layer:What is the average annual PM 2.5 value over 19 years? (1998-2016)What is the annual average PM 2.5 value for each year from 1998 to 2016?What is the statistical trend for PM 2.5 over the 19 years? (downward or upward)Are there hot spots (or cold spots) of PM 2.5 over the 19 years?How many people are impacted by the air quality in an area?What is the death rate caused by the joint effects of air pollution?Choose a different attribute to symbolize in order to reveal any of the patterns above.A space time cube was performed on a multidimensional mosaic version of the data in order to derive an emerging hot spot analysis, trends, and a 19-year average. The country and administrative 1 layers provide a population-weighted PM 2.5 value to emphasize which areas have a higher human impact. Citations:van Donkelaar, A., R. V. Martin, M. Brauer, N. C. Hsu, R. A. Kahn, R. C. Levy, A. Lyapustin, A. M. Sayer, and D. M. Winker. 2018. Global Annual PM2.5 Grids from MODIS, MISR and SeaWiFS Aerosol Optical Depth (AOD) with GWR, 1998-2016. Palisades, NY: NASA Socioeconomic Data and Applications Center (SEDAC). https://doi.org/10.7927/H4ZK5DQS. Accessed 1 April 2020van Donkelaar, A., R. V. Martin, M. Brauer, N. C. Hsu, R. A. Kahn, R. C. Levy, A. Lyapustin, A. M. Sayer, and D. M. Winker. 2016. Global Estimates of Fine Particulate Matter Using a Combined Geophysical-Statistical Method with Information from Satellites. Environmental Science & Technology 50 (7): 3762-3772. https://doi.org/10.1021/acs.est.5b05833.Boundaries and population figures:Antarctica is excluded from all maps because it was not included in the original NASA grids.50km hex bins generated using the Generate Tessellation tool - projected to Behrmann Equal Area projection for analysesPopulation figures generated using Zonal Statistics from the World Population Estimate 2016 layer from ArcGIS Living Atlas.Administrative boundaries from World Administrative Divisions layer from ArcGIS Living Atlas - projected to Behrmann Equal Area projection for analyses and hosted in Web MercatorSources: Garmin, CIA World FactbookPopulation figures generated using Zonal Statistics from the World Population Estimate 2016 layer from ArcGIS Living Atlas.Country boundaries from Esri 2019 10.8 Data and Maps - projected to Behrmann Equal Area projection for analyses and hosted in Web Mercator. Sources: Garmin, Factbook, CIAPopulation figures attached to the country boundaries come from the World Population Estimate 2016 Sources Living Atlas layer Data processing notes:NASA's GeoTIFF files for 19 years (1998-2016) were first brought into ArcGIS Pro 2.5.0 and put into a multidimensional mosaic dataset.For each geography level, the following was performed: Zonal Statistics were run against the mosaic as a multidimensional layer.A Space Time Cube was created to compare the 19 years of PM 2.5 values and detect hot/cold spot patterns. To learn more about Space Time Cubes, visit this page.The Space Time Cube is processed for Emerging Hot Spots where we gain the trends and hot spot results.The layers are hosted in Web Mercator Auxillary Sphere projection, but were processed using an equal area projection: Behrmann. If using this layer for analysis, it is recommended to start by projecting the data back to Behrmann.The country and administrative layer were dissolved and joined with population figures in order to visualize human impact.The dissolve tool ensures that each geographic area is only symbolized once within the map.Country boundaries were generalized post-analysis for visualization purposes. The tolerance used was 700m. If performing analysis with this layer, find detailed country boundaries in ArcGIS Living Atlas. To create the population-weighted attributes on the country and Admin 1 layers, the hex value population values were used to create the weighting. Within each hex bin, the total population figure and average PM 2.5 were multiplied.The hex bins were converted into centroids and the PM2.5 and population figures were summarized within the country and Admin 1 boundaries.The summation of the PM 2.5 values were then divided by the total population of each geography. This population value was determined by summarizing the population values from the hex bins within each geography.Some artifacts in the hex bin layer as a result of the input NASA rasters. Because the gridded surface is created from multiple satellites, there are strips within some areas that are a result of satellite paths. Some areas also have more of a continuous pattern between hex bins as a result of the input rasters.Within the country layer, an air pollution attributable death rate is included. 2016 figures are offered by the World Health Organization (WHO). Values are offered as a mean, upper value, lower value, and also offered as age standardized. Values are for deaths caused by all possible air pollution related diseases, for both sexes, and all age groups. For more information visit this page, and here for methodology. According to WHO, the world average was 95 deaths per 100,000 people.To learn the techniques used in this analysis, visit the Learn ArcGIS lesson Investigate Pollution Patterns with Space-Time Analysis by Esri's Kevin Bulter and Lynne Buie.
This layer shows particulate matter in the air sized 2.5 micrometers of smaller (PM 2.5). The data is aggregated from NASA Socioeconomic Data and Applications Center (SEDAC) gridded data into country boundaries, administrative 1 boundaries, and 50 km hex bins. The unit of measurement is micrograms per cubic meter.The layer shows the annual average PM 2.5 from 1998 to 2016, highlighting if the overall mean for an area meets the World Health Organization guideline of 10 micrograms per cubic meter annually. Areas that don't meet the guideline and are above the threshold are shown in red, and areas that are lower than the guideline are in grey.The data is averaged for each year and over the the 19 years to provide an overall picture of air quality globally. Some of the things we can learn from this layer:What is the average annual PM 2.5 value over 19 years? (1998-2016)What is the annual average PM 2.5 value for each year from 1998 to 2016?What is the statistical trend for PM 2.5 over the 19 years? (downward or upward)Are there hot spots (or cold spots) of PM 2.5 over the 19 years?How many people are impacted by the air quality in an area?What is the death rate caused by the joint effects of air pollution?Choose a different attribute to symbolize in order to reveal any of the patterns above.A space time cube was performed on a multidimensional mosaic version of the data in order to derive an emerging hot spot analysis, trends, and a 19-year average. The country and administrative 1 layers provide a population-weighted PM 2.5 value to emphasize which areas have a higher human impact. Citations:van Donkelaar, A., R. V. Martin, M. Brauer, N. C. Hsu, R. A. Kahn, R. C. Levy, A. Lyapustin, A. M. Sayer, and D. M. Winker. 2018. Global Annual PM2.5 Grids from MODIS, MISR and SeaWiFS Aerosol Optical Depth (AOD) with GWR, 1998-2016. Palisades, NY: NASA Socioeconomic Data and Applications Center (SEDAC). https://doi.org/10.7927/H4ZK5DQS. Accessed 1 April 2020van Donkelaar, A., R. V. Martin, M. Brauer, N. C. Hsu, R. A. Kahn, R. C. Levy, A. Lyapustin, A. M. Sayer, and D. M. Winker. 2016. Global Estimates of Fine Particulate Matter Using a Combined Geophysical-Statistical Method with Information from Satellites. Environmental Science & Technology 50 (7): 3762-3772. https://doi.org/10.1021/acs.est.5b05833.Boundaries and population figures:Antarctica is excluded from all maps because it was not included in the original NASA grids.50km hex bins generated using the Generate Tessellation tool - projected to Behrmann Equal Area projection for analysesPopulation figures generated using Zonal Statistics from the World Population Estimate 2016 layer from ArcGIS Living Atlas.Administrative boundaries from World Administrative Divisions layer from ArcGIS Living Atlas - projected to Behrmann Equal Area projection for analyses and hosted in Web MercatorSources: Garmin, CIA World FactbookPopulation figures generated using Zonal Statistics from the World Population Estimate 2016 layer from ArcGIS Living Atlas.Country boundaries from Esri 2019 10.8 Data and Maps - projected to Behrmann Equal Area projection for analyses and hosted in Web Mercator. Sources: Garmin, Factbook, CIAPopulation figures attached to the country boundaries come from the World Population Estimate 2016 Sources Living Atlas layer Data processing notes:NASA's GeoTIFF files for 19 years (1998-2016) were first brought into ArcGIS Pro 2.5.0 and put into a multidimensional mosaic dataset.For each geography level, the following was performed: Zonal Statistics were run against the mosaic as a multidimensional layer.A Space Time Cube was created to compare the 19 years of PM 2.5 values and detect hot/cold spot patterns. To learn more about Space Time Cubes, visit this page.The Space Time Cube is processed for Emerging Hot Spots where we gain the trends and hot spot results.The layers are hosted in Web Mercator Auxillary Sphere projection, but were processed using an equal area projection: Behrmann. If using this layer for analysis, it is recommended to start by projecting the data back to Behrmann.The country and administrative layer were dissolved and joined with population figures in order to visualize human impact.The dissolve tool ensures that each geographic area is only symbolized once within the map.Country boundaries were generalized post-analysis for visualization purposes. The tolerance used was 700m. If performing analysis with this layer, find detailed country boundaries in ArcGIS Living Atlas. To create the population-weighted attributes on the country and Admin 1 layers, the hex value population values were used to create the weighting. Within each hex bin, the total population figure and average PM 2.5 were multiplied.The hex bins were converted into centroids and the PM2.5 and population figures were summarized within the country and Admin 1 boundaries.The summation of the PM 2.5 values were then divided by the total population of each geography. This population value was determined by summarizing the population values from the hex bins within each geography.Some artifacts in the hex bin layer as a result of the input NASA rasters. Because the gridded surface is created from multiple satellites, there are strips within some areas that are a result of satellite paths. Some areas also have more of a continuous pattern between hex bins as a result of the input rasters.Within the country layer, an air pollution attributable death rate is included. 2016 figures are offered by the World Health Organization (WHO). Values are offered as a mean, upper value, lower value, and also offered as age standardized. Values are for deaths caused by all possible air pollution related diseases, for both sexes, and all age groups. For more information visit this page, and here for methodology. According to WHO, the world average was 95 deaths per 100,000 people.To learn the techniques used in this analysis, visit the Learn ArcGIS lesson Investigate Pollution Patterns with Space-Time Analysis by Esri's Kevin Bulter and Lynne Buie.
This layer shows particulate matter in the air sized 2.5 micrometers of smaller (PM 2.5). The data is aggregated from NASA Socioeconomic Data and Applications Center (SEDAC) gridded data into country boundaries, administrative 1 boundaries, and 50 km hex bins. The unit of measurement is micrograms per cubic meter.The layer shows the annual average PM 2.5 from 1998 to 2016, highlighting if the overall mean for an area meets the World Health Organization guideline of 10 micrograms per cubic meter annually. Areas that don't meet the guideline and are above the threshold are shown in red, and areas that are lower than the guideline are in grey.The data is averaged for each year and over the the 19 years to provide an overall picture of air quality globally. Some of the things we can learn from this layer:What is the average annual PM 2.5 value over 19 years? (1998-2016)What is the annual average PM 2.5 value for each year from 1998 to 2016?What is the statistical trend for PM 2.5 over the 19 years? (downward or upward)Are there hot spots (or cold spots) of PM 2.5 over the 19 years?How many people are impacted by the air quality in an area?What is the death rate caused by the joint effects of air pollution?Choose a different attribute to symbolize in order to reveal any of the patterns above.A space time cube was performed on a multidimensional mosaic version of the data in order to derive an emerging hot spot analysis, trends, and a 19-year average. The country and administrative 1 layers provide a population-weighted PM 2.5 value to emphasize which areas have a higher human impact. Citations:van Donkelaar, A., R. V. Martin, M. Brauer, N. C. Hsu, R. A. Kahn, R. C. Levy, A. Lyapustin, A. M. Sayer, and D. M. Winker. 2018. Global Annual PM2.5 Grids from MODIS, MISR and SeaWiFS Aerosol Optical Depth (AOD) with GWR, 1998-2016. Palisades, NY: NASA Socioeconomic Data and Applications Center (SEDAC). https://doi.org/10.7927/H4ZK5DQS. Accessed 1 April 2020van Donkelaar, A., R. V. Martin, M. Brauer, N. C. Hsu, R. A. Kahn, R. C. Levy, A. Lyapustin, A. M. Sayer, and D. M. Winker. 2016. Global Estimates of Fine Particulate Matter Using a Combined Geophysical-Statistical Method with Information from Satellites. Environmental Science & Technology 50 (7): 3762-3772. https://doi.org/10.1021/acs.est.5b05833.Boundaries and population figures:Antarctica is excluded from all maps because it was not included in the original NASA grids.50km hex bins generated using the Generate Tessellation tool - projected to Behrmann Equal Area projection for analysesPopulation figures generated using Zonal Statistics from the World Population Estimate 2016 layer from ArcGIS Living Atlas.Administrative boundaries from World Administrative Divisions layer from ArcGIS Living Atlas - projected to Behrmann Equal Area projection for analyses and hosted in Web MercatorSources: Garmin, CIA World FactbookPopulation figures generated using Zonal Statistics from the World Population Estimate 2016 layer from ArcGIS Living Atlas.Country boundaries from Esri 2019 10.8 Data and Maps - projected to Behrmann Equal Area projection for analyses and hosted in Web Mercator. Sources: Garmin, Factbook, CIAPopulation figures attached to the country boundaries come from the World Population Estimate 2016 Sources Living Atlas layer Data processing notes:NASA's GeoTIFF files for 19 years (1998-2016) were first brought into ArcGIS Pro 2.5.0 and put into a multidimensional mosaic dataset.For each geography level, the following was performed: Zonal Statistics were run against the mosaic as a multidimensional layer.A Space Time Cube was created to compare the 19 years of PM 2.5 values and detect hot/cold spot patterns. To learn more about Space Time Cubes, visit this page.The Space Time Cube is processed for Emerging Hot Spots where we gain the trends and hot spot results.The layers are hosted in Web Mercator Auxillary Sphere projection, but were processed using an equal area projection: Behrmann. If using this layer for analysis, it is recommended to start by projecting the data back to Behrmann.The country and administrative layer were dissolved and joined with population figures in order to visualize human impact.The dissolve tool ensures that each geographic area is only symbolized once within the map.Country boundaries were generalized post-analysis for visualization purposes. The tolerance used was 700m. If performing analysis with this layer, find detailed country boundaries in ArcGIS Living Atlas. To create the population-weighted attributes on the country and Admin 1 layers, the hex value population values were used to create the weighting. Within each hex bin, the total population figure and average PM 2.5 were multiplied.The hex bins were converted into centroids and the PM2.5 and population figures were summarized within the country and Admin 1 boundaries.The summation of the PM 2.5 values were then divided by the total population of each geography. This population value was determined by summarizing the population values from the hex bins within each geography.Some artifacts in the hex bin layer as a result of the input NASA rasters. Because the gridded surface is created from multiple satellites, there are strips within some areas that are a result of satellite paths. Some areas also have more of a continuous pattern between hex bins as a result of the input rasters.Within the country layer, an air pollution attributable death rate is included. 2016 figures are offered by the World Health Organization (WHO). Values are offered as a mean, upper value, lower value, and also offered as age standardized. Values are for deaths caused by all possible air pollution related diseases, for both sexes, and all age groups. For more information visit this page, and here for methodology. According to WHO, the world average was 95 deaths per 100,000 people.To learn the techniques used in this analysis, visit the Learn ArcGIS lesson Investigate Pollution Patterns with Space-Time Analysis by Esri's Kevin Bulter and Lynne Buie.
This layer shows particulate matter in the air sized 2.5 micrometers of smaller (PM 2.5). The data is aggregated from NASA Socioeconomic Data and Applications Center (SEDAC) gridded data into country boundaries, administrative 1 boundaries, and 50 km hex bins. The unit of measurement is micrograms per cubic meter.The layer shows the annual average PM 2.5 from 1998 to 2016, highlighting if the overall mean for an area meets the World Health Organization guideline of 10 micrograms per cubic meter annually. Areas that don't meet the guideline and are above the threshold are shown in red, and areas that are lower than the guideline are in grey.The data is averaged for each year and over the the 19 years to provide an overall picture of air quality globally. Some of the things we can learn from this layer:What is the average annual PM 2.5 value over 19 years? (1998-2016)What is the annual average PM 2.5 value for each year from 1998 to 2016?What is the statistical trend for PM 2.5 over the 19 years? (downward or upward)Are there hot spots (or cold spots) of PM 2.5 over the 19 years?How many people are impacted by the air quality in an area?What is the death rate caused by the joint effects of air pollution?Choose a different attribute to symbolize in order to reveal any of the patterns above.A space time cube was performed on a multidimensional mosaic version of the data in order to derive an emerging hot spot analysis, trends, and a 19-year average. The country and administrative 1 layers provide a population-weighted PM 2.5 value to emphasize which areas have a higher human impact. Citations:van Donkelaar, A., R. V. Martin, M. Brauer, N. C. Hsu, R. A. Kahn, R. C. Levy, A. Lyapustin, A. M. Sayer, and D. M. Winker. 2018. Global Annual PM2.5 Grids from MODIS, MISR and SeaWiFS Aerosol Optical Depth (AOD) with GWR, 1998-2016. Palisades, NY: NASA Socioeconomic Data and Applications Center (SEDAC). https://doi.org/10.7927/H4ZK5DQS. Accessed 1 April 2020van Donkelaar, A., R. V. Martin, M. Brauer, N. C. Hsu, R. A. Kahn, R. C. Levy, A. Lyapustin, A. M. Sayer, and D. M. Winker. 2016. Global Estimates of Fine Particulate Matter Using a Combined Geophysical-Statistical Method with Information from Satellites. Environmental Science & Technology 50 (7): 3762-3772. https://doi.org/10.1021/acs.est.5b05833.Boundaries and population figures:Antarctica is excluded from all maps because it was not included in the original NASA grids.50km hex bins generated using the Generate Tessellation tool - projected to Behrmann Equal Area projection for analysesPopulation figures generated using Zonal Statistics from the World Population Estimate 2016 layer from ArcGIS Living Atlas.Administrative boundaries from World Administrative Divisions layer from ArcGIS Living Atlas - projected to Behrmann Equal Area projection for analyses and hosted in Web MercatorSources: Garmin, CIA World FactbookPopulation figures generated using Zonal Statistics from the World Population Estimate 2016 layer from ArcGIS Living Atlas.Country boundaries from Esri 2019 10.8 Data and Maps - projected to Behrmann Equal Area projection for analyses and hosted in Web Mercator. Sources: Garmin, Factbook, CIAPopulation figures attached to the country boundaries come from the World Population Estimate 2016 Sources Living Atlas layer Data processing notes:NASA's GeoTIFF files for 19 years (1998-2016) were first brought into ArcGIS Pro 2.5.0 and put into a multidimensional mosaic dataset.For each geography level, the following was performed: Zonal Statistics were run against the mosaic as a multidimensional layer.A Space Time Cube was created to compare the 19 years of PM 2.5 values and detect hot/cold spot patterns. To learn more about Space Time Cubes, visit this page.The Space Time Cube is processed for Emerging Hot Spots where we gain the trends and hot spot results.The layers are hosted in Web Mercator Auxillary Sphere projection, but were processed using an equal area projection: Behrmann. If using this layer for analysis, it is recommended to start by projecting the data back to Behrmann.The country and administrative layer were dissolved and joined with population figures in order to visualize human impact.The dissolve tool ensures that each geographic area is only symbolized once within the map.Country boundaries were generalized post-analysis for visualization purposes. The tolerance used was 700m. If performing analysis with this layer, find detailed country boundaries in ArcGIS Living Atlas. To create the population-weighted attributes on the country and Admin 1 layers, the hex value population values were used to create the weighting. Within each hex bin, the total population figure and average PM 2.5 were multiplied.The hex bins were converted into centroids and the PM2.5 and population figures were summarized within the country and Admin 1 boundaries.The summation of the PM 2.5 values were then divided by the total population of each geography. This population value was determined by summarizing the population values from the hex bins within each geography.Some artifacts in the hex bin layer as a result of the input NASA rasters. Because the gridded surface is created from multiple satellites, there are strips within some areas that are a result of satellite paths. Some areas also have more of a continuous pattern between hex bins as a result of the input rasters.Within the country layer, an air pollution attributable death rate is included. 2016 figures are offered by the World Health Organization (WHO). Values are offered as a mean, upper value, lower value, and also offered as age standardized. Values are for deaths caused by all possible air pollution related diseases, for both sexes, and all age groups. For more information visit this page, and here for methodology. According to WHO, the world average was 95 deaths per 100,000 people.To learn the techniques used in this analysis, visit the Learn ArcGIS lesson Investigate Pollution Patterns with Space-Time Analysis by Esri's Kevin Bulter and Lynne Buie.
This table contains 2394 series, with data for years 1991 - 1991 (not all combinations necessarily have data for all years). This table contains data described by the following dimensions (Not all combinations are available): Geography (1 items: Canada ...), Population group (19 items: Entire cohort; Income adequacy quintile 1 (lowest);Income adequacy quintile 2;Income adequacy quintile 3 ...), Age (14 items: At 25 years; At 30 years; At 40 years; At 35 years ...), Sex (3 items: Both sexes; Females; Males ...), Characteristics (3 items: Life expectancy; High 95% confidence interval; life expectancy; Low 95% confidence interval; life expectancy ...).
Not seeing a result you expected?
Learn how you can add new datasets to our index.
A. SUMMARY Medical provider confirmed COVID-19 cases and confirmed COVID-19 related deaths in San Francisco, CA aggregated by several different geographic areas and normalized by 2016-2020 American Community Survey (ACS) 5-year estimates for population data to calculate rate per 10,000 residents. On September 12, 2021, a new case definition of COVID-19 was introduced that includes criteria for enumerating new infections after previous probable or confirmed infections (also known as reinfections). A reinfection is defined as a confirmed positive PCR lab test more than 90 days after a positive PCR or antigen test. The first reinfection case was identified on December 7, 2021. Cases and deaths are both mapped to the residence of the individual, not to where they were infected or died. For example, if one was infected in San Francisco at work but lives in the East Bay, those are not counted as SF Cases or if one dies in Zuckerberg San Francisco General but is from another county, that is also not counted in this dataset. Dataset is cumulative and covers cases going back to 3/2/2020 when testing began. Geographic areas summarized are: 1. Analysis Neighborhoods 2. Census Tracts 3. Census Zip Code Tabulation Areas B. HOW THE DATASET IS CREATED Addresses from medical data are geocoded by the San Francisco Department of Public Health (SFDPH). Those addresses are spatially joined to the geographic areas. Counts are generated based on the number of address points that match each geographic area. The 2016-2020 American Community Survey (ACS) population estimates provided by the Census are used to create a rate which is equal to ([count] / [acs_population]) * 10000) representing the number of cases per 10,000 residents. C. UPDATE PROCESS Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 7:30 Pacific Time. D. HOW TO USE THIS DATASET San Francisco population estimates for geographic regions can be found in a view based on the San Francisco Population and Demographic Census dataset. These population estimates are from the 2016-2020 5-year American Community Survey (ACS). Privacy rules in effect To protect privacy, certain rules are in effect: 1. Case counts greater than 0 and less than 10 are dropped - these will be null (blank) values 2. Death counts greater than 0 and less than 10 are dropped - these will be null (blank) values 3. Cases and deaths dropped altogether for areas where acs_population < 1000 Rate suppression in effect where counts lower than 20 Rates are not calculated unless the case count is greater than or equal to 20. Rates are generally unstable at small numbers, so we avoid calculating them directly. We advise you to apply the same approach as this is best practice in epidemiology. A note on Census ZIP Code Tabulation Areas (ZCTAs) ZIP Code Tabulation Areas are special boundaries created by the U.S. Census based on ZIP Codes developed by the USPS. They are not, however, the same thing. ZCTAs are areal representations of routes. Read how the Census develops ZCTAs on their website. Row included for Citywide case counts, incidence rate, and deaths A single row is included that has the Citywide case counts and incidence rate. This can be used for comparisons. Citywide will capture all cases regardless of address quality. While some cases cannot be mapped to sub-areas like Census Tracts, ongo