Skip to main content
SimilarExport ZIP
100%

Power BI query om onvolledige en foute adressen van provinciehuizen te verbeteren en verrijken met LocatieServer

✓ Published0🌍 Public
FFrieseWoudloper
Last edited Dec 27, 2019
Created on Dec 27, 2019

This Power Query example cleans and enriches incomplete or incorrect addresses of provincial government buildings (provinciehuizen) by geocoding them through the LocatieServer API. It first transforms the input address list, then constructs a URL query for the Nationaal Georegister’s free geocoding endpoint, fetching JSON attributes like postcode, street name, and coordinates. Using Power Query’s table functions (`Table.AddColumn`, `Table.ReplaceValue`, `Table.SplitColumn`), it extracts longitude and latitude, then removes intermediate columns. The data source is a hardcoded gist list, and the output includes structured address components and map-ready coordinates.

AI-generated description

Similar vizzes

Loading thumbnail…

Geocoding van adressen met LocatieServer en Power Query in Power BI

This example demonstrates geocoding of childcare facility addresses from a Dutch open dataset by enriching it with geographic coordinates and neighborhood codes. It shows how Power Query in Power BI transforms tabular address data into mapped points. The workflow uses the LocatieServer API (nationaalgeoregister.nl) to fetch JSON responses, extracting attributes like wijkcode, buurtcode, and centroid coordinates. It constructs URLs from combined address fields, parses the JSON documents with `Json.Document`, and splits the resulting `centroide_ll` coordinates into separate longitude and latitude columns using `Table.SplitColumn`. The final table removes helper columns, leaving ready-to-use spatial data for visualization.

FFrieseWoudloper
85% match
Loading thumbnail…

Bestanden voor blog post over Power BI, Leaflet en R

This visualization combines a map of earthquake data with a line chart of annual seismic activity. Using R, the gist by FrieseWoudloper plots earthquake locations in the Netherlands on a Leaflet map, with points colored and sized by magnitude. A separate panel displays yearly earthquake counts. The visualization integrates R with Power BI, and the map layer is built with Leaflet, allowing interactive exploration of the data points with tooltips showing location, date, magnitude, and depth.

FFrieseWoudloper
60% match
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
59% match
Loading thumbnail…

R-script dat aan de hand van de gegevens uit het objectenportaal van de provincie Groningen, de BAG en de Zonneatlas bepaald welke panden van de provincie Groningen wel/niet geschikt zijn voor het opwekken van zonne-energie

This R Markdown analysis determines which buildings in the province of Groningen are suitable for solar energy generation, based on open data from the provincial object portal, the BAG (Basisregistratie Adressen en Gebouwen), and the Zonatlas. It shows the workflow from downloading building and address data via WFS APIs to converting address objects into building polygons using the `httr`, `sp`, and `rgdal` packages. The script also integrates municipal boundaries to apply the correct Zonatlas layer, producing a reproducible geospatial assessment.

FFrieseWoudloper
58% match
Loading thumbnail…

R script om te demonstreren hoe je WFS paging kunt implementeren in R

This example shows how to retrieve all Dutch address objects (verblijfsobjecten) in the town of Zuidhorn from the BAG Web Feature Service (WFS) using paging to handle large result sets. The code first queries the server’s maximum page size via GetCapabilities, then counts matching features, and finally fetches them page by page using `startindex` while sorting by identifier. It uses the `httr`, `xml2`, and `sf` R packages to parse the WFS responses and convert the resulting GeoJSON into simple features, which are then mapped with the `tmap` package. The data source is the national georegister’s BAG WFS endpoint.

FFrieseWoudloper
56% 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
55% match
Loading thumbnail…

R-script voor het downloaden en converteren van een JSON-bestand met locaties van jachthavens converteren naar shape-bestand

This example demonstrates how to download JSON data containing marina locations from a Dutch tourism website and convert it into a shapefile. The script shows the process of fetching data via an HTTP POST request with a custom header, parsing the JSON response, extracting attributes like address and contact details from nested HTML, and then transforming geographic coordinates from WGS84 to the Dutch RD coordinate system using the `sp` and `rgdal` packages. It uses `httr` for the API request, `jsonlite` for JSON parsing, and `XML` for handling HTML content within the JSON. The final shapefile is written with `writeOGR`.

FFrieseWoudloper
55% match
Loading thumbnail…

Gist b4906c8537f6ba2797c4

This example demonstrates how to filter Dutch spatial planning areas (bestemmingsplannen) by their legal status and geographic code, using an OGC Styled Layer Descriptor (SLD). The visualization shows only features where the plan status matches one of four values (concept, voorontwerp, ontwerp, vastgesteld) and where the plangebied identifier begins with "NL.IMRO.0053". The SLD employs an XML-based filter structure with `ogc:PropertyIsEqualTo` and `ogc:PropertyIsLike` to select specific map layers. The rendering relies on GeoServer or a deegree-based server interpreting the SLD, applying the filter to the `BP:Bestemmingsplangebied` layer, and drawing only the matching geometries.

FFrieseWoudloper
55% match