Skip to content

Instantly share code, notes, and snippets.

Bert Spaan bertspaan

Block or report user

Report or block bertspaan

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
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": [
View Sportaanbieders - sportaanbieders.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 10 columns, instead of 2. in line 7.
Sport,Naam,Website,Naam accommodatie,Adres accommodatie,Postcode accommodatie,Plaats accommodatie,Stadsdeel,Aangepast sporten,KvK
Aangepast sporten,AmRoDa,www.amroda.nl,De Drie Hoven,L. Bouwmeesterstraat 377,1065NS,Amsterdam,Nieuw-West,ja,41213300
Aangepast sporten,Friendship Sports Centre,www.friendshipsportscentre.nl,Friendship Sports Centre,Beemsterstraat 652,1027ED,Amsterdam,Noord,ja,34152839
Aangepast sporten,Hart in beweging,www.casareade.nl,Reade sportcentrum,Dr. Jan van Breemenstraat 2,1056AB,Amsterdam,West,ja,34321379
Aangepast sporten,PWA Manege | Vereniging Paardrijden Gehandicapten,www.pwamanege.nl,Prins Willem-Alexander manege,Loosdrechtdreef 9,1108AZ,Amsterdam,Zuidoost,ja,40533448
Aangepast sporten,Reade,www.reade.nl,Jan van Breemen instituut,Dr. Jan van Breemenstraat 2,1056AB,Amsterdam,Nieuw-West,ja,
Aangepast sporten,Stichting Paardrijden Gehandicapten Amstelveen,www.spga.nl,SEIN Manege de Cruquiushoeve,Spieringweg 801,2142ED,Amsterdam,Buiten Amsterdam,ja,34217276
Aangepast sporten,Stichting P
@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.