First attempt, I want to create a table at CartoDB from another Postgis database:
snow:Docker-Postgis alasarr$ ogr2ogr --config CARTODB_API_KEY daf3960b41733ef71e03ea77019642761d547f5b -f CartoDB "CartoDB:alasarr" PG:"host=192.168.59.103 user=postgres dbname=eiel_huesca port=5433" "geometries_eiel.alumbrado_ok"
// output
CartoDB driver does not support data source creation.
Second attempt, I try that ogr2ogr create a table at CartoDB from a Shapefile:
snow:Docker-Postgis alasarr$ ogr2ogr --config CARTODB_API_KEY XXXX -f CartoDB "CartoDB:alasarr" ~/dev/naturalearth/ne_110m_admin_0_countries/ne_110m_admin_0_countries.shp
// output:
CartoDB driver does not support data source creation.
Third attempt:
- I import the shapefile at CartoDB.
- Truncate the table. Truncate table ne_110m_admin_0_countries;
- I try to import using ogr2ogr.
Here the command:
ogr2ogr --config CARTODB_API_KEY XXXX -f CartoDB "CartoDB:alasarr" -append -t_srs EPSG:4326 ~/dev/naturalearth/ne_110m_admin_0_countries/ne_110m_admin_0_countries.shp
//output
ERROR 1: HTTP error code : 400
ERROR 1: Error returned by server : relation "ne_110m_admin_0_countries" already exists
ERROR 1: Terminating translation prematurely after failed
translation of layer ne_110m_admin_0_countries (use -skipfailures to skip errors)
I'm using Gdal 1.11.0 that in theory supports CartoDB format.
Any ideas? Should I try with a newer version of GDAL.
No comments:
Post a Comment