Original datasource is a postgis db table "Verkavelingen" using epsg 31370 as is my project file EPSG:31370 OTF

I have used CartoDB QGIS plugin to export that table to a dataset on CartoDB "verkavelingen20151107" and import that dataset back again in QGIS.

As you can see below my data has 'shifted' somehow and is not on its original location... Same shift happening when viewing data on the CartoDB website.

Using CartoDB SQL command SELECT ST_Srid(the_geom) FROM verkavelingen20151107 I see my data is in 4326.

Using OpenLayers plugin in QGIS my original dataset shows up fine on Google/OSM background layers.

I'm using QGIS 2.12 & postgresql 9.4.5

Can someone help me out ?



This query:

SELECT ST_Srid(the_geom) FROM verkavelingen20151107

will always return 4326 as the_geom type is fixed by the system, and CartoDB always supposes that 4326 is the projection of the data unless the source file specifies it otherwise.

If you're using QGIS, I would recommend to transform your layer to 4326 before uploading to CartoDB.

  • Tested and works :-) I assumed that CartoDB would reproject on-the-fly to 4326 if original crs was given. Cheers for following up my question ! – Steven De Vriendt Nov 16 '15 at 20:18
  • I'd say I should be doing the reprojection too. If you have an example when this does not happen so that we could reproduce and check internally what the system does, don't hesitate to let me know. – iriberri Nov 17 '15 at 9:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.