igrek8

WITH RECURSIVE doc_key_and_value_recursive (
  KEY,
  value
) AS (
  SELECT
    t.key,
    t.value
  FROM
    stories_collection AS item,
    json_each(item.data) AS t

jsanz

How to set up a quick geocoding system on google spreadsheets.

1. Create a new spreadsheet
2. Open the Scripts editor and paste the script attached
3. Use on your spreadsheet this new formula

=searchMapzen(place_cell,mapzen_api_key)

andrewxhill

CREATE AGGREGATE vector_sum (
    sfunc = AXH_Vector_Sum,
    basetype = int[],
    stype = int[],
    initcond = '{0}'
);

DROP FUNCTION IF EXISTS AXH_Vector_Sum(int[], int[]);
CREATE OR REPLACE FUNCTION AXH_Vector_Sum(int[], int[]) 
    RETURNS int[] AS $$

mattbaker

This example expects to have d3.min.js and d3.layout.min.js in the same directory as pie.js and pie_serv.js.

Run with node pie_serv.js

adammiller

var simplifyPath = function( points, tolerance ) {

	// helper classes 
	var Vector = function( x, y ) {
		this.x = x;
		this.y = y;
		
	};
	var Line = function( p1, p2 ) {
		this.p1 = p1;