Vizzuality/cartodb — Issue #201: Import of shapefile file with reprojection
Author: jatorre
Created: 2011-10-24 15:02:41+00:00
State: open
Labels: IO

When trying to load the shapefile described on this page:

http://www.urbanresearchmaps.org/plurality/methodology.htm

It loads but the record become empty.

I reprojected it using og2ogr like:

ogr2ogr -t_srs EPSG:4326 blocks.shp NYCblocks10_PL2k_2010_plurality_change_CUNYCenterforUrbanResearch.shp

And then the reprojected file worked. Maybe we could use ogr2ogr to reproject before loading to postgresql. I think it seems to be more consistent and it detects better the source projection.

The workflow could be:

1) Ask via ogrinfo if the shapefile is not in 4326
2) Reporject using ogr2ogr to another shapefile file
3) Import then to postgresql