Find alternative way to store data in CartoDB without using the GUI.

[raquelalegre]

It'd be nice to automate data ingestion in CartoDB instead of using the web GUI all the time, which makes things a bit more obscure and unreliable. Workflow is not straight forward and uses Ruby which I'm not an expert at. I'm trying to get up to speed on this following CartoDB's Map Academy short courses.

[raquelalegre]

Testing ogr2ogr:

ogr2ogr -t_srs EPSG:4326 --config CARTODB_API_KEY XXXXX -f CartoDB "CartoDB:account" PG:"host=host user=postgres dbname=db port=port" "<tablenamesrc>"

The CartoDB API Key can be found in the user settings menu under Configuration > Avatar > Your API Keys.

[raquelalegre]

@juliaschaumeier it'd be nice to give another go at this for bulk data ingestion.

[juliaschaumeier]

@raquel-ucl told me about this post on how to write data to CartoDB using Python:
http://gis.stackexchange.com/questions/94982/what-is-the-simplest-way-to-write-data-to-cartodb-using-python