Population and housing information extracted from decennial census Public Law 94-171 redistricting summary files for Washington state for years 2000 and 2010.

My ArcGIS StoryMap is centered around The Green Book, an annual travel guide that allowed African Americans to travel safely during the height of the Jim Crow Era in the United States. More specifically, The Green Book listed establishments, such as hotels and restaurants, that would openly accept and welcome black customers into their businesses. As someone who is interested in the intersection between STEM and the humanities, I wanted to utilize The Science of Where to formulate a project that would reveal important historical implications to the public. Therefore, my overarching goal was to map each location in The Green Book in order to draw significant conclusions regarding racial segregation in one of the largest cities in the entire world.Although a more detailed methodology of my work can be found in the project itself, the following is a step by step walkthrough of my overall scientific process:Develop a question in relation to The Green Book to be solved through the completion of the project.Perform background research on The Green Book to gain a more comprehensive understanding of the subject matter.Formulate a hypothesis that answers the proposed question based on the background research.Transcribe names and addresses for each of the hotel listings in The Green Book into a comma separated values file.Transcribe names and addresses for each of the restaurants listings in The Green Book into a comma separated values file.Repeat Steps 4 and 5 for the 1940, 1950, 1960, and 1966 publications of The Green Book. In total, there should be eight unique database files (1940 New York City Hotels, 1940 New York City Restaurants, 1950 New York City Hotels, 1950 New York City Restaurants, 1960 New York City Hotels, 1960 New York City Restaurants, 1966 New York City Hotels, and 1966 New York City Restaurants.)Construct an address locator that references a New York City street base map to plot the information from the databases in Step 6 as points on a map.Manually plot locations that the address locator did not automatically match on the map.Repeat Steps 7 and 8 for all eight database files.Find and match the point locations for each listing in The Green Book with historical photographs.Generate a map tour using the geotagged images for each point from Step 10.Create a point density heat map for the locations in all eight database files.Research and obtain professional and historically accurate racial demographic data for New York City during the same time period as when The Green Book was published.Generate a hot spot map of the black population percentage using the demographic data.Analyze any geospatial trends between the point density heat maps for The Green Book and the black population percentage hot spot maps from the demographic data.Research and obtain professional and historically accurate redlining data for New York City during the same time period as when The Green Book was published.Overlay the points from The Green Book listings from Step 9 on top of the redlining shapefile.Count the number of point features completely located within each redlining zone ranking utilizing the spatial join tool.Plot the data recorded from Step 18 in the form of graphs.Analyze any geospatial trends between the listings for The Green Book and its location relative to the redlining ranking zones.Draw conclusions from the analyses in Steps 15 and 20 to present a justifiable rationale for the results._Student Generated Maps:New York City Pin Location Maphttps://arcg.is/15i4nj1940 New York City Hotels Maphttps://arcg.is/WuXeq1940 New York City Restaurants Maphttps://arcg.is/L4aqq1950 New York City Hotels Maphttps://arcg.is/1CvTGj1950 New York City Restaurants Maphttps://arcg.is/0iSG4r1960 New York City Hotels Maphttps://arcg.is/1DOzeT1960 New York City Restaurants Maphttps://arcg.is/1rWKTj1966 New York City Hotels Maphttps://arcg.is/4PjOK1966 New York City Restaurants Maphttps://arcg.is/1zyDTv11930s Manhattan Black Population Percentage Enumeration District Maphttps://arcg.is/1rKSzz1930s Manhattan Black Population Percentage Hot Spot Map (Same as Previous)https://arcg.is/1rKSzz1940 Hotels Point Density Heat Maphttps://arcg.is/jD1Ki1940 Restaurants Point Density Heat Maphttps://arcg.is/1aKbTS1940 Hotels Redlining Maphttps://arcg.is/8b10y1940 Restaurants Redlining Maphttps://arcg.is/9WrXv1950 Hotels Redlining Maphttps://arcg.is/ruGiP1950 Restaurants Redlining Maphttps://arcg.is/0qzfvC01960 Hotels Redlining Maphttps://arcg.is/1KTHLK01960 Restaurants Redlining Maphttps://arcg.is/0jiu9q1966 Hotels Redlining Maphttps://arcg.is/PXKn41966 Restaurants Redlining Maphttps://arcg.is/uCD05_Bibliography:Image Credits (In Order of Appearance)Header/Thumbnail Image:Student Generated Collage (Created Using Pictures from the Schomburg Center for Research in Black Culture, Manuscripts, Archives and Rare Books Division, The New York Public Library, https://digitalcollections.nypl.org/collections/the-green-book#/?tab=about.)Mob Violence Image:Kelley, Robert W. “A Mob Rocks an out of State Car Passing.” Life Magazine, www.life.com/history/school-integration-clinton-history, The Green Book Example Image:Schomburg Center for Research in Black Culture, Manuscripts, Archives and Rare Books Division, The New York Public Library Digital Collections, https://images.nypl.org/index.php?id=5207583&t=w. 1940s Borough of Manhattan Hotels and Restaurants Photographs:“Manhattan 1940s Tax Photos.” NYC Municipal Archives Collections, The New York City Department of Records & Information Services, https://nycma.lunaimaging.com/luna/servlet/NYCMA~5~5?cic=NYCMA~5~5.Figure 1:Student Generated GraphFigure 2:Student Generated GraphFigure 3:Student Generated GraphGIS DataThe Green Book Database:Student Generated (See Above)The Green Book Listings Maps:Student Generated (See Above)The Green Book Point Density Heat Maps:Student Generated (See Above)The Green Book Road Trip Map:Student GeneratedLION New York City Single Line Street Base Map:https://www1.nyc.gov/site/planning/data-maps/open-data/dwn-lion.page 1930s Manhattan Census Data:https://s4.ad.brown.edu/Projects/UTP2/ncities.htm Mapping Inequality Redlining Data:https://dsl.richmond.edu/panorama/redlining/#loc=12/40.794/-74.072&city=manhattan-ny&text=downloads 1940 The Green Book Document:Schomburg Center for Research in Black Culture, Manuscripts, Archives and Rare Books Division, The New York Public Library. "The Negro Motorist Green-Book: 1940" The New York Public Library Digital Collections, 1940, https://digitalcollections.nypl.org/items/dc858e50-83d3-0132-2266-58d385a7b928. 1950 The Green Book Document:Schomburg Center for Research in Black Culture, Manuscripts, Archives and Rare Books Division, The New York Public Library. "The Negro Motorist Green-Book: 1950" The New York Public Library Digital Collections, 1950, https://digitalcollections.nypl.org/items/283a7180-87c6-0132-13e6-58d385a7b928. 1960 The Green Book Document:Schomburg Center for Research in Black Culture, Manuscripts, Archives and Rare Books Division, The New York Public Library. "The Travelers' Green Book: 1960" The New York Public Library Digital Collections, 1960, https://digitalcollections.nypl.org/items/a7bf74e0-9427-0132-17bf-58d385a7b928. 1966 The Green Book Document:Schomburg Center for Research in Black Culture, Manuscripts, Archives and Rare Books Division, The New York Public Library. "Travelers' Green Book: 1966-67 International Edition" The New York Public Library Digital Collections, 1966, https://digitalcollections.nypl.org/items/27516920-8308-0132-5063-58d385a7bbd0. Hyperlink Credits (In Order of Appearance)Referenced Hyperlink #1: Coen, Ross. “Sundown Towns.” Black Past, 23 Aug. 2020, blackpast.org/african-american-history/sundown-towns.Referenced Hyperlink #2: Foster, Mark S. “In the Face of ‘Jim Crow’: Prosperous Blacks and Vacations, Travel and Outdoor Leisure, 1890-1945.” The Journal of Negro History, vol. 84, no. 2, 1999, pp. 130–149., doi:10.2307/2649043. Referenced Hyperlink #3:Driskell, Jay. “An Atlas of Self-Reliance: The Negro Motorist's Green Book (1937-1964).” National Museum of American History, Smithsonian Institution, 30 July 2015, americanhistory.si.edu/blog/negro-motorists-green-book. Referenced Hyperlink #4:Kahn, Eve M. “The 'Green Book' Legacy, a Beacon for Black Travelers.” The New York Times, The New York Times, 6 Aug. 2015, www.nytimes.com/2015/08/07/arts/design/the-green-book-legacy-a-beacon-for-black-travelers.html. Referenced Hyperlink #5:Giorgis, Hannah. “The Documentary Highlighting the Real 'Green Book'.” The Atlantic, Atlantic Media Company, 25 Feb. 2019, www.theatlantic.com/entertainment/archive/2019/02/real-green-book-preserving-stories-of-jim-crow-era-travel/583294/. Referenced Hyperlink #6:Staples, Brent. “Traveling While Black: The Green Book's Black History.” The New York Times, The New York Times, 25 Jan. 2019, www.nytimes.com/2019/01/25/opinion/green-book-black-travel.html. Referenced Hyperlink #7:Pollak, Michael. “How Official Is Official?” The New York Times, The New York Times, 15 Oct. 2010, www.nytimes.com/2010/10/17/nyregion/17fyi.html. Referenced Hyperlink #8:“New Name: Avenue Becomes a Boulevard.” The New York Times, The New York Times, 22 Oct. 1987, www.nytimes.com/1987/10/22/nyregion/new-name-avenue-becomes-a-boulevard.html. Referenced Hyperlink #9:Norris, Frank. “Racial Dynamism in Los Angeles, 1900–1964.” Southern California Quarterly, vol. 99, no. 3, 2017, pp. 251–289., doi:10.1525/scq.2017.99.3.251. Referenced Hyperlink #10:Shertzer, Allison, et al. Urban Transition Historical GIS Project, 2016, https://s4.ad.brown.edu/Projects/UTP2/ncities.htm. Referenced Hyperlink #11:Mitchell, Bruce. “HOLC ‘Redlining’ Maps: The Persistent Structure Of Segregation And Economic Inequality.” National Community Reinvestment Coalition, 20 Mar. 2018,

All GHiGs datasets cover the whole of Scotland and have been derived by Greenspace Scotland over the project period of September 2020 to April 2021. Principal third party data suppliers include: - Ordnance Survey (greenspace and water body data) - Scottish Government (Scotland's Heat Map) - Energy Saving Trust (Home Analytics) Please reference the Data Guide and Methodology report (attached to the metadata record as an associated resource) and send any further queries on the quality/ accuracy of the data to parkpower@greenspacescotland.org.uk. GHiGs Settlements: A public summary of indicators for GHiGs analysis of low carbon heat based on data aggregated to Scotland's 516 settlements. Settlement boundaries are from 2012 derived from National Records of Scotland to be consistent with those used by Scotland's Heat Map v.2. Settlements are defined as places with populations greater than 500. Approximately 90% of Scotland's population lives in settlements. It is not clear why Scotland's Heat Map is using the NRS 2012 settlement boundaries rather than the more recent NRS 2016 settlement boundaries. Attributes were derived from Scotland's Heat Map with additional attributes from GHiGs analysis and EST Home Analytics GHiGs Settlements by LA: A more comprehensive spreadsheet of tables used for National Findings Report and all indicators for GHiGs analysis of low carbon heat based on data aggregated to Scotland's 516 settlements and, separately, the 32 Local Authorities. Settlement data aggregated to Local Authority geographies and presented based on OS BoundaryLine Local Authority boundaries. The data excludes areas outside settlements and therefore does NOT represent figures for complete local authorities. This is particularly evident for Local Authorities with more significant populations and businesses located outside of settlements. It includes most indicators used in the GHiGs National Findings report based on analysis of low carbon heat related data aggregated to Scotland's 516 settlements and then aggregated to 32 Local Authorities. GHiGs greenspaces: Boundaries derived from OS Mastermap Greenspace. Attributes derived from Scotland's Heat Map v.2 with additional attributes from GHiGs analysis (see our Methodology Report) and EST Home Analytics GHiGs strategic greenspaces: Subset of GHiGs Greenspaces based on selection criteria to identify the 3% (3,446) of national greenspace sites with high potential for supply of ground source heat (based on areal size / capacity) and have been classified as 'high' based on local linear heat density. These sites are likely to be the strongest candidates for larger scale ground source heat solutions, potentially storing and feeding low grade heat into low carbon district heat networks. The 'GSHP_Strategic_Importance' indicator category of 'VERY HIGH' was used to select this subset GHiGs static water bodies: Relatively static water bodies greater than 1000m2 in area in proximity to urban settlements including canals, lochs, lakes, flooded quarries/pits etc. derived largely from OS Mastermap Greenspace. This data does not include rivers. GHiGs DHN highest viability (Linear Heat Density 16000 kWh/m/yr): Linear Heat Density model created by Ramboll to highlight areas where District Heat Networks (DHNs) have highest viability based on heat demand from all buildings. Areas identifies have high levels of heat demand density and are therefore highly suitable for DHNs - source of heat demand data: Scotland's Heat Map v2. GHiGs DHN high viability (Linear Heat Density 8000 kWh/m/yr): Linear Heat Density model created by Ramboll to highlight areas where District Heat Networks (DHNs) have high viability based on heat demand from all buildings - source of heat demand data: Scotland's Heat Map v2. GHiGs DHN viable (Linear Heat Density 4000 kWh/m/yr): Linear Heat Density model created by Ramboll to highlight areas where District Heat Networks (DHNs) are viable based on heat demand from all buildings. Threshold of 4000 is widely used across the industry for Linear Heat Density modelling to identify areas with DHN viability. Polygons of area less than 250m2 were deleted which reduced the number of polygon features by 80% to cut file size. Source of heat demand data: Scotland's Heat Map v2. GHiGs DHN highest viability public buildings only (Linear Heat Density 16000 kWh/m/yr): Linear Heat Density model created by Ramboll based on a best estimate of public buildings to highlight areas where District Heat Networks have highest viable based on heat demand from only public buildings. Source of heat demand data: Scotland's Heat Map v2. GHiGs DHN high viability public buildings only (Linear Heat Density 8000 kWh/m/yr): Linear Heat Density model created by Ramboll based on a best estimate of public buildings to highlight areas where District Heat Networks have high viability based on heat demand from only public buildings. Source of heat demand data: Scotland's Heat Map v2. GHiGs DHN viable public buildings only (Linear Heat Density 4000 kWh/m/yr): Linear Heat Density model created by Ramboll based on a best estimate of public buildings to highlight areas where District Heat Networks are viable based on heat demand from only public buildings. Threshold of 4000 is widely used across the industry for Linear Heat Density modelling to identify areas with DHN viability - source of heat demand data: Scotland's Heat Map v2. GHiGs public buildings: Subset of Scotland's Heat Map at building level where buildings are assessed as likely to be publicly owned based on a selection of 125 OS AddressBase codes (see GHiGs Methodology report for details). This is the best available approximation of publicly owned buildings but will exclude those publicly owned buildings which are leased to third parties for more commercial-type services. This same identification method was the basis for creating the 3 Linear Heat Density map layers for public buildings only. GHiGs public buildings with heat demand greater than 50 MWh/year: Subset of 'GHiGs public buildings' dataset based on a filter for all those public buildings with an annual heat demand of 50 MWh or more. Multi-occupancy buildings like flatted properties are treated as separate buildings and therefore they are unlikely to appear in this dataset. GHiGs public buildings (>200 MWh) near greenspaces (>200 MWh): Subset of 'GHiGs public buildings' dataset where: (1) buildings are assessed as likely to be publicly owned based on a selection of 125 OS AddressBase codes and have a heat demand of at least 200 MWh; AND (2) they are located within 50m of a greenspace that, based on 20% space utilisation, could meet at least 200 MWh in terms of heat production from its available area. In effect this is a subset of public building locations that offers the strongest opportunities for larger scale GSHP projects based on use of nearby greenspace. Multi-occupancy buildings like flatted properties are treated as separate buildings and therefore examples such as high rise flats next to larger areas of greenspace are unlikely to appear in this dataset. GHiGs waste disposal sites: Potential sources of waste heat from waste disposal sites to feed into district heat networks - source: SEPA registered waste sites All GHiGs datasets cover Scotland and have been derived over the project period of September 2020 to April 2021. Principal third party data suppliers include: * Ordnance Survey (greenspace and water body data) * Scottish Government (Scotland's Heat Map) * Energy Saving Trust (Home Analytics)

Introduction

We are enclosing the database used in our research titled "Concentration and Geospatial Modelling of Health Development Offices' Accessibility for the Total and Elderly Populations in Hungary", along with our statistical calculations. For the sake of reproducibility, further information can be found in the file Short_Description_of_Data_Analysis.pdf and Statistical_formulas.pdf

The sharing of data is part of our aim to strengthen the base of our scientific research. As of March 7, 2024, the detailed submission and analysis of our research findings to a scientific journal has not yet been completed.

The dataset was expanded on 23rd September 2024 to include SPSS statistical analysis data, a heatmap, and buffer zone analysis around the Health Development Offices (HDOs) created in QGIS software.

Short Description of Data Analysis and Attached Files (datasets):

Our research utilised data from 2022, serving as the basis for statistical standardisation. The 2022 Hungarian census provided an objective basis for our analysis, with age group data available at the county level from the Hungarian Central Statistical Office (KSH) website. The 2022 demographic data provided an accurate picture compared to the data available from the 2023 microcensus. The used calculation is based on our standardisation of the 2022 data. For xlsx files, we used MS Excel 2019 (version: 1808, build: 10406.20006) with the SOLVER add-in.

Hungarian Central Statistical Office served as the data source for population by age group, county, and regions: https://www.ksh.hu/stadat_files/nep/hu/nep0035.html, (accessed 04 Jan. 2024.) with data recorded in MS Excel in the Data_of_demography.xlsx file.

In 2022, 108 Health Development Offices (HDOs) were operational, and it's noteworthy that no developments have occurred in this area since 2022. The availability of these offices and the demographic data from the Central Statistical Office in Hungary are considered public interest data, freely usable for research purposes without requiring permission.

The contact details for the Health Development Offices were sourced from the following page (Hungarian National Population Centre (NNK)): https://www.nnk.gov.hu/index.php/efi (n=107). The Semmelweis University Health Development Centre was not listed by NNK, hence it was separately recorded as the 108th HDO. More information about the office can be found here: https://semmelweis.hu/egeszsegfejlesztes/en/ (n=1). (accessed 05 Dec. 2023.)

Geocoordinates were determined using Google Maps (N=108): https://www.google.com/maps. (accessed 02 Jan. 2024.) Recording of geocoordinates (latitude and longitude according to WGS 84 standard), address data (postal code, town name, street, and house number), and the name of each HDO was carried out in the: Geo_coordinates_and_names_of_Hungarian_Health_Development_Offices.csv file.

The foundational software for geospatial modelling and display (QGIS 3.34), an open-source software, can be downloaded from:

https://qgis.org/en/site/forusers/download.html. (accessed 04 Jan. 2024.)

The HDOs_GeoCoordinates.gpkg QGIS project file contains Hungary's administrative map and the recorded addresses of the HDOs from the

Geo_coordinates_and_names_of_Hungarian_Health_Development_Offices.csv file,

imported via .csv file.

The OpenStreetMap tileset is directly accessible from www.openstreetmap.org in QGIS. (accessed 04 Jan. 2024.)

The Hungarian county administrative boundaries were downloaded from the following website: https://data2.openstreetmap.hu/hatarok/index.php?admin=6 (accessed 04 Jan. 2024.)

HDO_Buffers.gpkg is a QGIS project file that includes the administrative map of Hungary, the county boundaries, as well as the HDO offices and their corresponding buffer zones with a radius of 7.5 km.

Heatmap.gpkg is a QGIS project file that includes the administrative map of Hungary, the county boundaries, as well as the HDO offices and their corresponding heatmap (Kernel Density Estimation).

A brief description of the statistical formulas applied is included in the Statistical_formulas.pdf.

Recording of our base data for statistical concentration and diversification measurement was done using MS Excel 2019 (version: 1808, build: 10406.20006) in .xlsx format.

• Aggregated number of HDOs by county: Number_of_HDOs.xlsx
• Standardised data (Number of HDOs per 100,000 residents): Standardized_data.xlsx
• Calculation of the Lorenz curve: Lorenz_curve.xlsx
• Calculation of the Gini index: Gini_Index.xlsx
• Calculation of the LQ index: LQ_Index.xlsx
• Calculation of the Herfindahl-Hirschman Index: Herfindahl_Hirschman_Index.xlsx
• Calculation of the Entropy index: Entropy_Index.xlsx
• Regression and correlation analysis calculation: Regression_correlation.xlsx

Using the SPSS 29.0.1.0 program, we performed the following statistical calculations with the databases Data_HDOs_population_without_outliers.sav and Data_HDOs_population.sav:

• Regression curve estimation with elderly population and number of HDOs, excluding outlier values (Types of analyzed equations: Linear, Logarithmic, Inverse, Quadratic, Cubic, Compound, Power, S, Growth, Exponential, Logistic, with summary and ANOVA analysis table): Curve_estimation_elderly_without_outlier.spv
• Pearson correlation table between the total population, elderly population, and number of HDOs per county, excluding outlier values such as Budapest and Pest County: Pearson_Correlation_populations_HDOs_number_without_outliers.spv.
• Dot diagram including total population and number of HDOs per county, excluding outlier values such as Budapest and Pest Counties: Dot_HDO_total_population_without_outliers.spv.
• Dot diagram including elderly (64<) population and number of HDOs per county, excluding outlier values such as Budapest and Pest Counties: Dot_HDO_elderly_population_without_outliers.spv
• Regression curve estimation with total population and number of HDOs, excluding outlier values (Types of analyzed equations: Linear, Logarithmic, Inverse, Quadratic, Cubic, Compound, Power, S, Growth, Exponential, Logistic, with summary and ANOVA analysis table): Curve_estimation_without_outlier.spv
• Dot diagram including elderly (64<) population and number of HDOs per county: Dot_HDO_elderly_population.spv
• Dot diagram including total population and number of HDOs per county: Dot_HDO_total_population.spv
• Pearson correlation table between the total population, elderly population, and number of HDOs per county: Pearson_Correlation_populations_HDOs_number.spv
• Regression curve estimation with total population and number of HDOs, (Types of analyzed equations: Linear, Logarithmic, Inverse, Quadratic, Cubic, Compound, Power, S, Growth, Exponential, Logistic, with summary and ANOVA analysis table): Curve_estimation_total_population.spv

For easier readability, the files have been provided in both SPV and PDF formats.

The translation of these supplementary files into English was completed on 23rd Sept. 2024.

If you have any further questions regarding the dataset, please contact the corresponding author: domjan.peter@phd.semmelweis.hu

Dataset used in the research https://doi.org/10.3886/E214781V1.

Relationship between space syntax parameters and POI shopping node KDE under different search radii.

Relationship between pedestrian travel mode, time, and distance.

OPGD for the spatial distribution of milk tea stores in the third ring road of Wuhan City.