Skip to content

Instantly share code, notes, and snippets.

Bert Spaan bertspaan

View GitHub Profile
View mosbekke.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View waar-ben-ik.svg
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@bertspaan
bertspaan / manifest.json
Last active May 17, 2019
Bouwdossier IIIF Manifest
View manifest.json
{
"@context": "http://iiif.io/api/presentation/2/context.json",
"@id": "https://api.data.amsterdam.nl/api/stadsarchief/bouwdossiers/15530",
"@type": "sc:Manifest",
"label": "Bouwdossier",
"sequences": [
{
"@type": "sc:Sequence",
"@id": "https://api.data.amsterdam.nl/api/stadsarchief/bouwdossiers/15530/sequence",
"canvases": [
@bertspaan
bertspaan / vakken.geojson
Last active Dec 18, 2018
Dienst der Publieke Werken
View vakken.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View 1_relive-tracker_1534868008125-iPhone8,4.csv
lon lat ele time skyhawk_strava_velocity_smooth
4.901851 52.385264 1.49 2018-08-21T16:13:27.297Z
4.901612 52.385418 0.94 2018-08-21T16:13:28.074Z 0.32
4.901550 52.385461 0.81 2018-08-21T16:13:29.004Z 0.32
4.901504 52.385496 0.72 2018-08-21T16:13:30.003Z 0.00
4.901473 52.385523 0.69 2018-08-21T16:13:31.003Z 0.00
4.901460 52.385541 0.71 2018-08-21T16:13:32.003Z 0.00
4.901462 52.385550 0.79 2018-08-21T16:13:33.003Z 0.00
4.901482 52.385550 0.92 2018-08-21T16:13:34.003Z 0.00
4.901518 52.385541 1.10 2018-08-21T16:13:35.002Z 0.00
@bertspaan
bertspaan / space-time-streets.js
Created Feb 13, 2017
Outputs all street names in NYC Space/Time Directory's `nyc-streets` dataset
View space-time-streets.js
const H = require('highland')
const request = require('request')
H(request('http://s3.amazonaws.com/spacetime-nypl-org/datasets/nyc-streets/nyc-streets.objects.ndjson'))
.split()
.compact()
.map(JSON.parse)
.pluck('name')
.uniq()
.toArray((streets) => {
@bertspaan
bertspaan / README.md
Created Feb 9, 2017
Building Inspector ETL script for NYC Space/Time Directory (adapted)
View README.md
View enumeration-districts.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View maps-by-decade.sql
SELECT decade * 10 AS decade,
ST_AsGeoJSON(ST_Union(geometry))::json AS geometry,
COUNT(*) AS count
FROM (
SELECT
geometry, ((
date_part('year', lower(validsince)) +
date_part('year', upper(validuntil))
) / 2)::int / 10 AS decade
FROM
You can’t perform that action at this time.