Skip to content

Instantly share code, notes, and snippets.

@luisbosque
luisbosque / postgis-gis.md
Created January 24, 2018 15:29 — forked from pramsey/postgis-gis.md
Carto Cosmos PostGIS && GIS Talk Notes

PostGIS && GIS

cdb-manager

A simple browser-based terminal for running SQL against Carto using the SQL API

  • http://github.com/cartodb/cdb-manager
  • git clone git@github.com:CartoDB/cdb-manager.git
  • When you're done cloning, enter the directory and run ./httpserv.py
  • Point your browser at http://localhost:8000
@luisbosque
luisbosque / gist:5513fa88b5087434089d
Created August 26, 2015 11:06
Export to csv format the list of remote branches and their "owners"
for i in `git branch -a |grep remotes |awk '{print $1}' | cut -d"/" -f 3,4,5 |grep -v ^master$ |grep -v ^HEAD$`; do echo "`git log -1 --pretty=format:\"%an (%ae)\" origin/$i`|$i"; done |sort > /tmp/branches.csv
  1. Colorful (2010) [T]

    Probably not the title that most people expected to see in the #1 slot. I urge everyone to give it a shot though. No other film has ever brought me through a greater spectrum of emotions. It's a supernatural film, but the characters are so well fleshed out and developed that they feel real. I've probably seen a hundred films since, but none have compared.

  2. Time of Eve (2010) [T]

Director: Yasuhiro Yoshiura - "Sometime in future Japan, androids have been involved in every aspect of peoples lives. One day, upon checking his android's behavioral log, Rikuo, a student, noticed his android's returning times have been odd recently. With his friend Masaki, they found out the place where his android, Sammy, have been visiting: a small cafe called Eve no Jikan where an

Keybase proof

I hereby claim:

  • I am luisbosque on github.
  • I am luisico (https://keybase.io/luisico) on keybase.
  • I have a public key whose fingerprint is 8565 0834 1A4C A24D 435D 529F CCE9 263C 8046 53EF

To claim this, I am signing this object:

@luisbosque
luisbosque / cdb_import.sh
Last active December 19, 2015 01:29
Import CartoDB file with cURL
#!/bin/bash
CDB_USER=$1
API_KEY=$2
IMPORT_FILE=$3
PROTOCOL=https
DEBUG=false
ITEM_ID_REGEX='\"([0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12})\"'
if [[ -z $CDB_USER ]]
#!/bin/bash
CHEF_CONF="/etc/default/chef-client"
if [[ -f $CHEF_CONF ]]
then
. $CHEF_CONF
fi
if [[ $BOOTSTRAP != 1 ]]