Use the SQL example here to efficiently update CartoDB tables. See both the INSERT and UPDATE variants
Andrew W. Hill andrewxhill
andrewxhill
/ cdb_import.sh
Created
June 28, 2013 13:43
— forked from luisbosque/cdb_import.sh
Import CartoDB file with cURL (Mac version)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| CDB_USER=$1 | |
| API_KEY=$2 | |
| IMPORT_FILE=$3 | |
| if [[ -z $CDB_USER ]] | |
| then | |
| echo "Missing user" | |
| fi |
andrewxhill
/ README.md
Last active
December 18, 2015 02:58
— forked from jatorre/gist:3892665
Efficient bulk update and insert
andrewxhill
/ index.html
Last active
December 11, 2015 02:39
— forked from anonymous/index.html
Exploding globe in D3
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <meta http-equiv="Content-Type" content="text/html;charset=utf-8"> | |
| <title>Exploding world</title> | |
| <script src="http://d3js.org/d3.v3.min.js"></script> | |
| <script src="http://libs.cartocdn.com/cartodb.js/v2/cartodb.js"></script> | |
| <style type="text/css"> | |
| body{ |
andrewxhill
/ index.html
Last active
December 10, 2015 22:38
— forked from javisantana/index.html
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <html> | |
| <head> | |
| <link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v2/themes/css/cartodb.css" /> | |
| <script src="http://libs.cartocdn.com/cartodb.js/v2/cartodb.js"></script> | |
| <style> | |
| html, body {padding: 0; margin: 0;} | |
| #map { width: 100%; height:100%; background: black;} | |
| #menu { position: absolute; top: 5; right: 5; width: 400px; height:60px; background: transparent;} | |
| #menu a { | |
| margin: 0 5px 0 0; |
andrewxhill
/ index.html
Created
January 9, 2013 18:53
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <html> | |
| <head> | |
| <link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v2/themes/css/cartodb.css" /> | |
| <script src="http://libs.cartocdn.com/cartodb.js/v2/cartodb.js"></script> | |
| <style> | |
| html, body {padding: 0; margin: 0;} | |
| #map { width: 100%; height:100%; background: black;} | |
| #menu { position: absolute; top: 5; right: 5; width: 400px; height:60px; background: transparent;} | |
| #menu a { | |
| margin: 0 5px 0 0; |
andrewxhill
/ cartodb_test.md
Created
August 21, 2012 16:49
— forked from anonymous/cartodb_test.md
cartodb_test.md
andrewxhill
/ cartodb_test.html
Created
August 21, 2012 15:31
— forked from anonymous/cartodb_test.html
cartodb_test.html
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <html><body><h1>Summary</h1> <h3>40 Tests Run with 1 Failures - 2012-08-21 11:30</h3> <table border="1"><tr><th>#</th><th>production</th><th>staging</th><th>sql</th><th>carto</th></tr> | |
| <tr> | |
| <td class="test_count">10</td> | |
| <td class="production_img"><a href='http://examples.cartodb.com/tiles/carto_tests/0/0/0.png?style=%23carto_tests+%7Bmarker-fill%3A%23ff7%3B+marker-max-error%3A0.762117952967%3B+marker-line-opacity%3A0.954313683078%3B+marker-allow-overlap%3Afalse%3B+polygon-fill%3Argba%28255%2C+255%2C+0%2C+1%29%3B+marker-spacing%3A16.0%3B+marker-width%3A4.0%3B+marker-height%3A3.0%3B+marker-opacity%3A0.667163700797%3B+line-color%3Agreen%3B+line-gamma%3A0.524514770107%3B+line-cap%3Around%3B+polygon-opacity%3A0.814145908039%3B+marker-type%3Aarrow%3B+polygon-gamma%3A0.296743932444%3B+line-dasharray%3A2%2C10%3B+line-join%3Amiter%3B+marker-placement%3Aline%3B+line-width%3A12.0%3B+marker-line-color%3Argb%28155%2C+133%2C+0%29%3B+line-opacity%3A0.749564105384%3B+marker-line-width%3A4.0%3 |
andrewxhill
/ collectionsmetadata.json
Created
May 19, 2011 00:50
— forked from tucotuco/collectionsmetadata.json
Third pass at collections metadata JSON from Andrew
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "collection":{ | |
| "source":"World Wildlife Fund (WWF)", | |
| "type":"Ecoregion", | |
| "name":"World Ecoregions", | |
| "description":"The WWF's Conservation Science Program (CSP) has developed a biogeographic regionalization of the Earth's terrestrial biodiversity. WWF termed the biogeographic units ecoregions, defined as relatively large units of land or water containing distinct assemblages of natural communities sharing a large majority of species, dynamics, and environmental conditions. Ecoregions represent the original distribution of distinct assemblages of species and communities.", | |
| "url":"http://www.worldwildlife.org/science/ecoregions/item1267.html", | |
| "agreements":{ | |
| "0":{"url": "http://www.worldwildlife.org/agreement.html" | |
| "text": "A brief overview of the TOS", |
NewerOlder