tomasholderness’s gists

tomasholderness / GA_link_point_to_line_script.py

Last active May 12, 2019 09:15

Create line geometry between a point and nearest line in PostGIS using Python and GeoAlchemy2

	# Tom 17/05/2012

	# Example GeoAlchemy script.

	from sqlalchemy import create_engine, distinct, func, MetaData, Sequence
	from sqlalchemy.ext.declarative import declarative_base
	from sqlalchemy.orm import sessionmaker
	from geoalchemy2 import Geometry

	# Database connection

tomasholderness / leaflet_poly_selection.html

Last active July 30, 2018 16:03

Use Leaflet.draw to generate polygon WKT for interactive map selection

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<title>Leaflet · Selection</title>

	<!-- Tom Holderness - 2013 -->

	<!--Styles -->
	<link href="resources/css/leaflet.css" rel="stylesheet"/>

tomasholderness / twitter_polarity.ipynb

Last active February 22, 2018 21:19

Plot polarity (sentiment) of tweets using TextBlob

Sorry, something went wrong. Reload?

Sorry, we cannot display this file.

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

tomasholderness / pjkt_video

Last active August 29, 2015 14:02

Video embedding in PetaJakarta.org

	<div id="headerwrap">
	<div class="container">
	<div class="jumbotron" style="padding-top:0px;">
	<h1 id="title">PetaJakarta.org/banjir</h1>
	<p class="lead"><b>petajakarta.org/banjir</b> is an open source, community-led platform to collect and disseminate information about flooding and critical water infrastructure in Jakarta</p>
	<div id="video">
	<p><iframe width="560" height="315" src="//www.youtube.com/embed/QubtNdfLQHk?rel=0" frameborder="0" allowfullscreen></iframe></p>
	</div>
	</div>
	</div><!-- /container -->

tomasholderness / Twitter (json format).js

Last active August 29, 2015 14:20 — forked from gnip/Twitter (json format).js

Sample Tweet

	{
	"coordinates": { type: 'Point', coordinates: [ 40.027435,-105.251945 ] },
	"created_at": "Thu Oct 21 16:02:46 +0000 2010",
	"favorited": false,
	"truncated": false,
	"id_str": "28039652140",
	"entities": {
	"urls": [
	{
	"expanded_url": null,

tomasholderness / sample_cognicity_flood_report_v1.json

Last active August 29, 2015 14:25

Sample flood report from CogniCity (PetaJakarta.org)

Sorry, something went wrong. Reload?

Sorry, we cannot display this file.

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

tomasholderness / 37628c0.patch.sql

Last active November 24, 2015 10:55

Patch for cognicity-schema 2.0.x commit 37628c0

	ALTER TABLE all_reports ADD COLUMN status character varying DEFAULT 'confirmed';
	COMMENT ON COLUMN all_reports.status IS '{character varying} Status of the report (defaults to confirmed)';

tomasholderness / 6418f4.patch.sql

Created November 24, 2015 10:55

Patch for cognicity-schema 2.0.x commit 6418f4

ALTER TABLE tweet_reports ADD column tweet_id bigint;

tomasholderness / chip_countdown.html

Created November 30, 2015 00:46

Updated Countdown for CHIP, with timezone!

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="UTF-8">
	<script src="https://code.jquery.com/jquery-2.1.4.js"></script>
	<script src="jquery.countdown-2.1.0/jquery.countdown.js"></script>
	<script src="http://momentjs.com/downloads/moment.js"></script>
	<script src="http://momentjs.com/downloads/moment-timezone.js"></script>
	</head>
	<body>

tomasholderness / genangan.json

Created June 6, 2016 04:59

GDC Sample

[{"_notes":[],"group_terdampak/jml_orang_pengungsi":75,"_bamboo_dataset_id":"","_tags":[],"_xform_id_string":"form_laporan_genangan_v2","group_location/gps":"-6.1822678 106.8287187 0.0 20.0","meta/instanceID":"uuid:5a14b798-1910-41c3-8728-6d6bcfdf2d97","_duration":"","group_terdampak/jml_orang_terdampak":75,"group_terdampak/jml_kk_pengungsi":10,"group_flood/rekomendasi_banjir":"penurapan","_geolocation":[-6.1822678,106.8287187],"group_surveyor/surveyor":"Puji Astuti","_edited":false,"group_location/total_rt":3,"_status":"submitted_via_web","kota":"jakarta_timur","group_location/kelurahan":"cililitan","_uuid":"5a14b798-1910-41c3-8728-6d6bcfdf2d97","group_flood/tinggi_banjir":"10_70","group_surveyor/organisasi":"Kpbk Jakarta timur","_submitted_by":null,"group_location/rw":7,"group_location/rt":"1,5,7","formhub/uuid":"e7ba4b6ac8154449b81e29efb600b505","group_flood/picture":"1459825750578.jpg","_submission_time":"2016-04-05T03:16:59","kecamatan":"kramat_jati","_version":"201603080102","_attachments":[{"mimetype":

Tomas Holderness tomasholderness