12% and counting

“Street names are more than just navigational tools; they're memories etched into our neighborhoods.”

Project Summary

This project explores gender representation in Amsterdam's street names. Using PostGIS within PostgreSQL for spatial analysis and GeoPandas for additional calculations in Python, I categorized street names by gender, plants, places, object, animals and other. The analysis measured both the total number and length of streets associated with each classification in Amsterdam.

Dataset

1. Open source data
2. Adminstrative boundaries

The following where the steps taken to accomplish the project.

1. Data cleaning

Process

Data cleaning was conducted to address redundancies and duplicates, a necessary step before analysis. A prominent issue was the occurrence of multiple OpenStreetMap (OSM) IDs linked to identical road names, which is shown below.

Duplicates

To address the multiple OSM ID problem, I performed a geometry union on the road segments sharing identical names, producing a consolidated geometry.

2. Curating data for analysis

Process

I categorized the data set into six distinct classifications: gender (female & male), plants, places, animals, objects, and other. Representative examples of these categories are as follows:

• Gender: Rembrandt plein, Marie Heineken plein, Nannie van Wehlstraat etc.
• Plants: Lindengracht en -straat,Rozenstraat en -gracht , and similiar.
• Places: Oost, Noord, Westerpark, and similar.
• Animals: Berenstraat,Hartenstraat, and similiar.
• Objects: "molen," "huis," "haven," "kerk," and related terms.
• Other: stars, events, activities, and uncategorized entries."

3. Data Analysis

Process

For each category, I calculated: the percentage of roads bearing names from that category, the total length of those roads, and the percentage of each road type within that category.

Data Sources

• HDX OSM data, https://data.humdata.org/dataset/hotosm_nld_roads
• DIVA GIS, https://diva-gis.org/data.html

Sources

• Road names : https://nl.wikipedia.org/wiki/Lijst_van_straten_in_Amsterdam#Namenlijst
• Gender API: https://genderize.io/