SpatiaLite field
- Column name:
time - Type:
VARCHAR - Example value:
2014/04/25 20:30:00
WHERE clause for temporal subset query
DATETIME(
Tobias Preuss johnjohndoe
johnjohndoe
/ .gitignore
Created
March 4, 2014 09:00
— forked from mbostock/.block
View .gitignore
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| build | |
| node_modules | |
| .DS_Store |
johnjohndoe
/ aerzte-berlin-lichtenberg.geojson
Created
March 10, 2014 09:05
Ärzte in Berlin Lichtenberg, Datenquelle: http://daten.berlin.de/datensaetze/%C3%A4rzte-im-bezirk-lichtenberg
View aerzte-berlin-lichtenberg.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
johnjohndoe
/ Bundestagswahlkeise-2013-Berlin.geojson
Last active
August 29, 2015 13:58
Geometrien der Bundestagswahlkeise 2013 in Berlin, http://daten.berlin.de/datensaetze/geometrien-der-bundestagswahlkeise-2013-berlin, Amt für Statistik Berlin-Brandenburg,ogr2ogr -f GeoJSON -s_srs EPSG:3857 -t_srs EPSG:4326 Wahlkreise.geojson Wahlkreise.shp
johnjohndoe
/ water_level_saxony.py
Last active
August 29, 2015 13:58
Pegelstände-Scraper für Sachsen, http://scraperwiki.com
View water_level_saxony.py
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env python | |
| import scraperwiki | |
| import requests | |
| import lxml.html | |
| from collections import namedtuple | |
| from datetime import datetime | |
johnjohndoe
/ Landkreise-Brandenburg.geojson
Created
April 17, 2014 13:37
Landkreise Brandenburg, Quelle: http://www.geo.brandenburg.de/ows/fesch01.cgi?REQUEST=GetCapabilities&SERVICE=wfs&VERSION=1.1.1&EXCEPTIONS=ogc.xml
View Landkreise-Brandenburg.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
johnjohndoe
/ Kindertagesstätten-in-Berlin-Marzahn-Hellersdorf.geojson
Created
April 21, 2014 21:38
Kindertagesstätten in Berlin (Marzahn-Hellersdorf), Quelle: http://daten.berlin.de/datensaetze/kindertagesst%C3%A4tten-marzahn-hellersdorf
View Kindertagesstätten-in-Berlin-Marzahn-Hellersdorf.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
View QGIS-temporal-query.md
johnjohndoe
/ mount-encrypted-partition.md
Last active
August 29, 2015 14:01
How to mount an encrypted home partition?
View mount-encrypted-partition.md
How to mount an encrypted home partition?
First add the passphrase
$ sudo ecryptfs-add-passphrase --fnek
Which gets me the following information:
Inserted auth tok with sig [aaaaaaaaaaaaaaaa] into the user session keyring
View rsync-backup.md
Backup via rsync
$ rsync -rt --delete --delete-excluded --links \
--exclude-from '/home/user/rsync-home-exclude.txt' /home/user/ server:/backups/home
View android-shell-commands.md
Convert file names to lowercase
$> for i in $(find . -type f -name "*[A-Z]*"); do mv "$i" "$(echo $i | tr A-Z a-z)"; doneReplace hyphen with underbar in all files
$> for i in $(find . -type f -name "*[a-z]*"); do mv "$i" "$(echo $i | tr '-' '_')"; doneOlderNewer