crstn’s gists

crstn / ACM SIGSPATIAL GIS 13

Created May 19, 2014 15:25

GIScience conference proceedings titles

	Sweeping a Terrain by Collaborative Aerial Vehicles
	Computing Highly Occluded Paths on a Terrain
	On IO-efficient Viewshed Algorithms and Their Accuracy
	Virtual Traffic for Real-World Challenges
	An Opportunistic Client User Interface to Support Centralized Ride Share Planning
	Evaluating Eco-Driving Advice Using GPS/CANBus Data
	Energy-Optimal Routes for Electric Vehicles
	Analysis and Evaluation of the Slugging Form of Ridesharing
	Mapping Spatial Data to RDF: a SPARQL Endpoint for Brussels
	Spatiotemporal Braitenberg Vehicles

crstn / evac_zones-simplified.geojson

Created August 11, 2014 17:02

NYC Flood Evacuation Zones Map

Sorry, something went wrong. Reload?

Sorry, we cannot display this file.

Sorry, this file is invalid so it cannot be displayed.

crstn / index.html

Created August 20, 2015 22:43

	<html>
	<head>
	<title>Leaflet template</title>
	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.css"/>
	<script src="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.js"></script>
	<script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script>
	<script src="https://raw.githubusercontent.com/calvinmetcalf/leaflet-ajax/master/dist/leaflet.ajax.min.js"></script>
	<style>
	html, body, #map {
	height: 100%;

crstn / asylum-data.csv

Last active September 3, 2015 15:05

Asylum data used in my blog post on refugee numbers in Europe: http://carsten.io/which-countries-should-be-able-to-handle-the-strain-in-the-european-migration-crisis/

name	Est. GDP in USD 2015	Applicants since 2011	Est. Pop 2015	Applicants by pop	Applicants by GDP
Austria	380.555	104489	8.556	12.21236559	274.5700359
Belgium	463.799	79209	11.239	7.047691076	170.7830332
Bulgaria	51.551	27124	7.166	3.785096288	526.1585614
Denmark	297.359	35302	5.629	6.271451412	118.7184514
Finland	235.276	14361	5.506	2.60824555	61.03895
France	2469.530	255800	64.213	3.983617025	103.5824631
Germany	3413.483	547034	81.360	6.723623402	160.2568403
Greece	207.148	42800	10.993	3.893386701	206.6155599
Hungary	126.691	129203	9.857	13.10774069	1019.82777

crstn / enviroCar-track-1.json

Created October 13, 2015 15:10

enviroCar Track

This file has been truncated, but you can view the full file.

	{
	"features": [
	{
	"type": "Feature",
	"properties": {
	"phenomenons": {
	"Engine Load": {
	"value": 25.490196228027344
	},
	"GPS PDOP": {

crstn / tomcat-users.xml

Created October 15, 2015 14:51

Tomcat user configuration for Strabon

	<?xml version='1.0' encoding='utf-8'?>
	<tomcat-users xmlns="http://tomcat.apache.org/xml"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://tomcat.apache.org/xml tomcat-users.xsd"
	version="1.0">
	<user username="endpoint" password="endpoint" roles="manager"/>
	</tomcat-users>

crstn / definer.sql

Last active August 31, 2016 04:17

Editing data in a CartoDB table via Leaflet with leaflet.draw plugin. Heavily inspired by http://blog.cartodb.com/read-and-write-to-cartodb-with-the-leaflet-draw-plugin/.

	DROP FUNCTION IF EXISTS carsten_upsert_pois(int[], text[]);

	-- Returns a set of op,cartodb_id values where op means:
	--
	-- deleted: -1
	-- updated: 0
	-- inserted: 1
	--
	CREATE OR REPLACE FUNCTION carsten_upsert_pois(
	cartodb_ids integer[],

crstn / rats-dynamic.html

Last active March 15, 2021 10:31

Examples for GeoViz lecture, borrowed from http://maptimeboston.github.io/d3-maptime/

	<html>

	<head>
	<title>A D3 chart</title>
	<script src="http://d3js.org/d3.v6.min.js" charset="utf-8"></script>
	</head>

	<body>

	<script>

crstn / voronoi.r

Created January 17, 2018 09:05

This is a small fix of Carson Farmer's Voronoi Polygons function (http://carsonfarmer.com/2009/09/voronoi-polygons-with-r/) which also copies the input points layer's CRS string over to the output polygons.

	voronoipolygons = function(layer) {
	require(deldir)
	crds = layer@coords
	z = deldir(crds[,1], crds[,2])
	w = tile.list(z)
	polys = vector(mode='list', length=length(w))
	require(sp)
	for (i in seq(along=polys)) {
	pcrds = cbind(w[[i]]$x, w[[i]]$y)
	pcrds = rbind(pcrds, pcrds[1,])

crstn / datashader.ipynb

Created May 2, 2018 20:20

Sorry, something went wrong. Reload?

Sorry, we cannot display this file.

Sorry, this file is invalid so it cannot be displayed.

Carsten Keßler crstn