You can't load projected coordinates into geography, you'll need to load to geometry, then re-project to 4326 and cast to geography if you really want to use geography (why do you want to if your data is all neatly contained in Belgium and already projected?)
P. On Tue, Apr 10, 2012 at 4:50 PM, Philippe <watche...@gmail.com> wrote: > Hello, > I'm running into an issue loading data from the Belgium IGN. > I can transform a shapefile into Postgis loadable data with Geometry but not > Geography. I can't imagine why. Any ideas ? Thanks > > > The following works > /usr/lib/postgresql/9.1/bin/shp2pgsql -WLATIN1 -s3812 -d -I > /home/postgres/warehouse/shapes/BE/vector/Shape_L08/commune_polygon.shp > be_ign > /tmp/be_ign.sql > > The following fails > /usr/lib/postgresql/9.1/bin/shp2pgsql -WLATIN1 -s3812 -G -d -I > /home/postgres/warehouse/shapes/BE/vector/Shape_L08/commune_polygon.shp > be_ign > /tmp/be_ign.sql > > with > "Shapefile type: Polygon > Postgis type: MULTIPOLYGON[2] > Invalid SRID for geography type: ee4" > > Although 0xee4=3812 which is the EPSG for the Lambert 2008 projection used > by that file. And my spatial ref table contains it: > > public=# select * from spatial_ref_sys where auth_srid=3812; > srid | 3812 > auth_name | EPSG > auth_srid | 3812 > srtext | PROJCS["ETRS89 / Belgian Lambert > 2008",GEOGCS["ETRS89",DATUM["European_Terrestrial_Reference_System_1989",SPHEROID["GRS > 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","6258"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4258"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Lambert_Conformal_Conic_2SP"],PARAMETER["standard_parallel_1",49.83333333333334],PARAMETER["standard_parallel_2",51.16666666666666],PARAMETER["latitude_of_origin",50.797815],PARAMETER["central_meridian",4.359215833333333],PARAMETER["false_easting",649328],PARAMETER["false_northing",665262],AUTHORITY["EPSG","3812"],AXIS["X",EAST],AXIS["Y",NORTH]] > proj4text | +proj=lcc +lat_1=49.83333333333334 +lat_2=51.16666666666666 > +lat_0=50.797815 +lon_0=4.359215833333333 +x_0=649328 +y_0=665262 > +ellps=GRS80 +units=m +no_defs > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
