Maptime Amsterdam

Want to learn how to make beautiful maps? Let's do it together! Beginners very welcome!

This repository contains the website, resources and presentations for Maptime Amsterdam.

For more information about Maptime, see Maptime HQ's website.

Maptime Amsterdam is hosted by Waag Society, and is supported by FIWARE and Smart City SDK.

Buildings GeoJSON

To create the GeoJSON file containing buildings data, do the following:

• Download BAG data file (1.3 GB)
• Import data into PostgreSQL/PostGIS database with NLExtract's Bag-extract
• Create buildings table:

CREATE SCHEMA bert; -- Yes, you need this schema 😑

CREATE TABLE bert.panden_amsterdam AS SELECT
  DISTINCT ON (p.identificatie)
  p.identificatie::bigint, bouwjaar::int,
  ST_Transform(p.geovlak, 4326) AS geom,
  openbareruimtenaam, huisnummer, huisletter, huisnummertoevoeging, postcode,
  wp.woonplaatsnaam AS plaatsnaam
FROM verblijfsobjectactueelbestaand v
JOIN verblijfsobjectpandactueel vp
  ON vp.identificatie = v.identificatie
JOIN pandactueelbestaand p
  ON vp.gerelateerdpand = p.identificatie
JOIN nummeraanduidingactueelbestaand na
  ON v.hoofdadres = na.identificatie
JOIN openbareruimteactueelbestaand obr
  ON na.gerelateerdeopenbareruimte = obr.identificatie
JOIN woonplaatsactueelbestaand wp
  ON obr.gerelateerdewoonplaats = wp.identificatie
 WHERE wp.identificatie = 3594

• Run ruby buildings.rb

Save a single building as SVG from PostgreSQL

SELECT
  ST_AsSVG(ST_Scale(ST_Translate(ST_Transform(geom, 28992), -121849, -487326), 2, 2))
FROM
  bert.panden_amsterdam
WHERE
  openbareruimtenaam = 'Nieuwmarkt' AND huisnummer = 4
LIMIT 1