Skip to content

Instantly share code, notes, and snippets.

@bmcbride
bmcbride / polygon_insert.sql
Created December 4, 2015 21:28 — forked from andrewxhill/polygon_insert.sql
Polygon insert Named Function
View polygon_insert.sql
-- Create a function withn the security set to Definer so that it can insert
CREATE OR REPLACE FUNCTION AXH_NewMinneapolis(integer, geometry) RETURNS integer
AS 'INSERT INTO minneapolis (parent_id, the_geom) (SELECT id, geom FROM (SELECT $1 id,$2 geom) a WHERE ST_NPoints(geom) < 100) RETURNING cartodb_id;'
LANGUAGE SQL
SECURITY DEFINER
RETURNS NULL ON NULL INPUT;
--Grant access to the public user
GRANT EXECUTE ON FUNCTION AXH_NewMinneapolis(integer, geometry) TO publicuser;
@bmcbride
bmcbride / find-in-json.js
Last active November 17, 2019 00:28 — forked from iwek/find-in-json.js
View find-in-json.js
//return an array of objects according to key, value, or key and value matching
function getObjects(obj, key, val) {
var objects = [];
for (var i in obj) {
if (!obj.hasOwnProperty(i)) continue;
if (typeof obj[i] == 'object') {
objects = objects.concat(getObjects(obj[i], key, val));
} else
//if key matches and value matches or if key matches and value is not passed (eliminating the case where key matches but passed value does not)
if (i == key && obj[i] == val || i == key && val == '') { //
View cartodb-utils.py
import os
import urllib
import urllib2
import base64
import json
import sys
import argparse
try:
import requests
except ImportError: