Skip to main content
SimilarExport ZIP
100%

Playing around with geopy using "Geburtsorte" - Data from Moers - [https://www.offenesdatenportal.de/dataset/geburtsorte-der-moerser-bevoelkerung]

✓ Published0🌍 Public
PP3nny
Last edited Feb 17, 2016
Created on Feb 17, 2016

This example visualizes the birthplaces of Moers’ population, mapping place names and counts from the city’s open data portal onto a geographic context. It uses Python with `pandas` to load and clean a CSV file, dropping rows for unknown or unclear entries, and prepares the data for geocoding. The code imports `geopy` to convert the listed birth locations into coordinates, which would then support plotting on a map, though no specific mapping or rendering library is shown in the provided excerpts.

AI-generated description

Similar vizzes

Loading thumbnail…

Geocoding example - uses PDOK LocationServer

This example demonstrates geocoding Dutch childcare locations by mapping street addresses to geographic coordinates. It shows the first 100 entries from a national childcare registry, displaying their matched BAG object IDs and centroid coordinates. The code uses the `httr` package to query the PDOK LocationServer API, while `dplyr` and `purrr` handle data manipulation and iterative geocoding. The input data is sourced from a CSV file provided by the Landelijk Register Kinderopvang. Each address is processed through the API’s free endpoint, returning the closest match’s details, which are then combined with the original dataset for display.

FFrieseWoudloper
63% match
Loading thumbnail…

Data about the different quarters of Cologne, Germany

This visualization presents a multi-faceted demographic profile of Cologne’s 86 districts using a CSV from a public gist, with each row representing a district. It shows how metrics like population density, age distribution, and migration background vary across the city through an interactive scatter plot, where each point is a district colored by its borough. Built with D3’s `forceSimulation` for layout and `geoPath`-based Voronoi tessellation for district shapes, the tooltip dumps all raw column values on hover. The data source is the city’s open statistics portal, loaded directly into the page for filtering.

PP3nny
60% match
Loading thumbnail…

Convert Messy Spreadsheet of Berlin Street Names to GeoJSON

This visualization converts a messy CSV file of Berlin street names into a GeoJSON FeatureCollection. The XQuery script uses `csv:parse` and `map:merge` to clean the data, expanding abbreviations like "dr" to "doctor" and normalizing gender fields. It then calls the Mapbox Geocoding API via `http:send-request` to retrieve geometry for each street address, bounded to Berlin’s coordinates. The resulting features are assembled with `array` and output as JSON, ready for mapping.

CCliffordAnderson
58% match
Loading thumbnail…

Gist ed318d44833c6e35336fbf5dff774017

This example visualizes Dutch neighborhood-level geographic data by combining CBS microsubsidy statistics with municipal boundary geometries. It first fetches neighborhood polygons from the national georegister WFS service, parsing the Well-Known Text geometry strings, and then joins these with the statistical dataset. The visualization maps the subsidy figures onto the neighborhood shapes, likely using a choropleth approach to show geographic distribution. The code relies on the `cbsodata` API for the statistical data and pandas for data manipulation, while the geometries are loaded directly from the WFS endpoint.

FFrieseWoudloper
58% match
Loading thumbnail…

Search where people are moving in Germany

This visualization maps migration flows between Germany’s 30 largest cities by querying Bing for each pair of city names in the pattern “von [source] nach [target] gezogen.” The code, written in Python, uses the `pattern.web` library’s Bing search engine and records the result counts as a CSV of source-target-weight triples. The resulting directed graph likely plots city nodes with edge thickness proportional to the number of search hits, showing where people move most frequently.

MMoritzStefaner
57% match
Loading thumbnail…

just a bookmark of random psql queries.

This example visualizes spatial relationships between neighborhoods, city blocks, and demographic data in Portland and Laurelhurst through a series of SQL queries. The code shows how geographic joins and intersections are performed using PostGIS functions like `ST_Intersects`, combining building footprints, block polygons, and census block-group data. The queries calculate race-based percentages, such as percent white and percent black, from census fields like `h7x002` and `h7x003`, while filtering for specific places and positive population counts. The gist demonstrates iterative query building for choropleth-style analysis, revealing how raw geographic and tabular data are merged to support subsequent mapping or charting in a visualization tool.

CCaged
57% match
Loading thumbnail…

Data Cleansing an offenen Daten aus Köln

This example demonstrates data cleansing of open data from Cologne, specifically a list of siren locations. It first displays a pandas DataFrame of the raw dataset, showing attributes like address, district, and mast height, then addresses the question of which siren has the tallest mast. The notebook uses pandas to load and inspect the tabular data from the gist source, with the goal of preparing it for further analysis or visualization.

PP3nny
56% match
Loading thumbnail…

Gist 5053ebcce793d11bc765

This example maps all Dutch municipalities in 2014, highlighting those with fewer than 20,000 residents in red on top of the full country outline. It uses the `rgdal` and `rgeos` libraries to read shapefile data from a ZIP downloaded from twiav.nl, then computes population density via `gArea()` and identifies the least dense municipality. The visualization shows a static choropleth-style base map with an overlaid selection, while also printing tabular summaries like counts per safety region and the names of the least dense area. It does not animate or use interactive frameworks, relying solely on base R plotting.

FFrieseWoudloper
56% match