Skip to content

Instantly share code, notes, and snippets.

Loading
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 07:39
Bouwdossier IIIF Manifest
{
"@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 December 18, 2018 16:39
Dienst der Publieke Werken
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@bertspaan
bertspaan / 1_relive-tracker_1534868008125-iPhone8,4.csv
Last active September 1, 2018 14:05
Maptime Amsterdam - Deep Mapping
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 February 13, 2017 20:42
Outputs all street names in NYC Space/Time Directory's `nyc-streets` dataset
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 February 9, 2017 16:10
Building Inspector ETL script for NYC Space/Time Directory (adapted)
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@bertspaan
bertspaan / maps-by-decade.sql
Created June 14, 2016 16:29
Maps by Decade
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