alexanno

-- http://overpass-turbo.eu/
-- https://gist.github.com/atlefren/60234fb68d8299136c05
-- http://www.norkart.no/produkt/datavarehus/


-- toalett og kommunekart
SELECT 
f.cartodb_id,
f.the_geom_webmercator,
f.the_geom,

bsweger

Useful Pandas Snippets

A personal diary of DataFrame munging over the years.

Data Types and Conversion

Convert Series datatype to numeric (will error if column has non-numeric values)
(h/t @makmanalp)

jvilledieu

How to use Neo4j to analyse the Offshore Leaks : the case of Azerbaijan

This interactive Neo4j graph tutorial shows how to use Neo4j to analyse the Offshore Leaks : the case of Azerbaijan.

---

guilbep

module.exports = function(grunt) {

  // Project configuration.
  grunt.initConfig({
    pkg: grunt.file.readJSON('package.json'),
    copy: {
      main: {
        files: [{
          expand: true,
          cwd: './partials/',

creg-ny-baa

# Run in QGIS python console for read-only view of CartoDB table
# Substitute your user name and query on first two lines
cartoName = ""  # PUT YOUR USER NAME IN THE QUOTES
cartoQuery = "" # PUT YOUR QUERY IN THE QUOTES

import urllib

cartoUrl = 'http://{}.cartodb.com/api/v2/sql?format=GeoJSON&q={}'.format(cartoName, cartoQuery)
response = urllib.urlopen(cartoUrl)
content = response.read()

iros

var interactive = new Miso.Storyboard({
  // our initial state will be loading
  initial : 'loading',

  scenes : {

    loading: {
      enter : function() {
        // show that we are in a loading state
        $('#loading').show();

pwenzel

# Local Dates: 
git log --date=local --pretty=format:"%h%x09%an%x09%ad%x09%s" > commits.local.tsv.txt

# ISO Dates:
git log --date=iso --pretty=format:"%h%x09%an%x09%ad%x09%s" > commits.iso.tsv.txt

palewire

Locating the story: The latest in mapping

A collection of links for a NICAR 2012 presentation. It will suggest broad themes for the past year, and try to support them with examples from work in the field. This is a work in progress. Feel free to crap on it, or add your own ideas.

Escape from Google Maps

• Google changed the rules of the game. There are now usage limits. Read about them here
• TileMill, custom tiles, need examples
• Links to ranty blog posts from Nestoria guy and others
• One replacement is simple line maps drawn using HTML5 technologies like SVG, Canvas and VML. You saw this example a lot in election maps during the GOP primaries, like NYT, WaPo, HuffPo, LAT

eyeseast

#!/usr/bin/env python
import argparse
import datetime
import httplib2
import json
import sys
import urllib

BASE = "https://api.twitter.com/1/statuses/user_timeline.json?"

n1k0

var page = new WebPage(),
    address, output, size;
    
//capture and captureSelector functions adapted from CasperJS - https://github.com/n1k0/casperjs
capture = function(targetFile, clipRect) {
    var previousClipRect;
    var clipRect = {top: 0, left:0, width: 40, height: 40};
    if (clipRect) {
        if (!isType(clipRect, "object")) {
            throw new Error("clipRect must be an Object instance.");