troy

# usage: redfin-images "http://www.redfin.com/WA/Seattle/123-Home-Row-12345/home/1234567"
function redfin-images() {
 wget -O - $1 | grep "full:" | awk -F \" '{print $4}' | xargs wget -
}

sneeu

-- Schema and import for Yahoo GeoPlanet data into a PostgreSQL database.

CREATE TABLE places (
    woe_id VARCHAR(15) PRIMARY KEY,
    iso VARCHAR(6),
    name TEXT,
    language VARCHAR(6),
    place_type VARCHAR(15),
    parent_woe_id VARCHAR(15)
);

EspadaV8

#!/bin/bash
#===============================================================================
#
# FILE: getgeo.sh
#
# USAGE: ./getgeo.sh
#
# DESCRIPTION: run the script so that the geodata will be downloaded and inserted into your
# database
#

andrewharvey

#!/usr/bin/python

# This script  should be considered CC0 licensed

# the deg2num function is from http://wiki.openstreetmap.org/wiki/Slippy_map_tilenames#lon.2Flat_to_tile_numbers_2
import math

def deg2num(lat_deg, lon_deg, zoom):
    lat_rad = math.radians(lat_deg)
    n = 2.0 ** zoom

kleinmatic

Open Source code doesn’t always come in big complex packages. At ProPublica we sometimes share small, simple snippets of using GitHub "Gists." These Gists range from single-byte file delimiters to an entire JavaScript framework for making stepper graphics. They rarely have documentation and don’t even always have names, but they can be super-useful. Here are some we’ve shared over the past few years:

• A simple way to grab remote template elements in your Rails app (after Brian Boyer's RemoteSnippets) https://gist.github.com/1664329
• A single byte gist that contains ASCII character 28, which the FEC uses as a field delimiter. https://gist.github.com/2191300
• A [quine](http://en.wikipedia.org/wiki/Quine_(computing) in Ruby https://gist.github.com/523940
• Check links on a page using JavaScript [https://gist.github.com/

mapmeld

/*
   Red Pen turns red (and blue!) dots on Field Papers tiles into markers automatically
   Tested with Sharpie and PaperMate ballpoint pens
   Write a description to save the marker
   I don't understand the server-side installation or the QR-scanning, so I'm using a bookmarklet
   Client-side HTML5 Canvas for tile inspection
*/

// collect the most zoomed-in tiles from the scan
var zoomimgs = document.getElementsByTagName("img");

migurski

from sys import argv
from shapely.ops import polygonize
from shapely.geometry import asShape, LineString

import json

if __name__ == '__main__':

    input = argv[1]
    input = json.load(open(input))

scw

#!/usr/bin/env python
# distance_from_shore.py: compute true distance between points 
# and closest geometry.

# shaun walbridge, 2012.05.15

# TODO: no indexing used currently, could stand if performance needs 
# improving (currently runs in ~1.5hr for 13k points)

from geopy import distance

mbostock

var fs = require("fs");

var roundPrecision = 1e6;

fs.readFile("/dev/stdin", "utf-8", function(error, input) {
  var collection = JSON.parse(input);
  switch (collection.type) {
    case "FeatureCollection": return cleanupFeatureCollection(collection);
    case "GeometryCollection": return cleanupGeometryCollection(collection);
    default: throw "unknown type: " + collection.type;

andrewxhill

WITH RECURSIVE dims AS (SELECT 2*sqrt(sum(ST_Area(the_geom))) as d, sqrt(sum(ST_Area(the_geom)))/20 as w, count(*) as rows FROM osm_export_polygon WHERE the_geom IS NOT NULL),
	geoms AS (SELECT the_geom, ST_YMax(the_geom)-ST_YMin(the_geom) as height FROM osm_export_polygon WHERE the_geom IS NOT NULL ORDER BY ST_YMax(the_geom)-ST_YMin(the_geom)  DESC),
	geomval AS (SELECT the_geom, row_number() OVER (ORDER BY height DESC) as id from geoms),
	positions(the_geom,x_offset,y_offset,new_row,row_offset) AS (
		(SELECT the_geom, 0.0::float, 0.0::float, FALSE, 2 from geomval limit 1)
		UNION ALL
			(
			SELECT
				(SELECT the_geom FROM geomval WHERE id = p.row_offset),
					CASE WHEN