On 2015-01-23 2:31 PM, Jeff McKenna wrote:
Hi Pasquale,

Did you resolve this issue?

If I had to guess, it would be that this issue is caused by PostGIS
using an older PROJ4 library for projections, that does not contain the
EPSG (SRID) that you need (5223 or http://epsg.io/5223).

You could use the commandline utility psql and check if your PostGIS
installation includes that spatial reference, with a command such as:

   select srid,srtext from spatial_ref_sys where srid = '5223';

My guess is that this will return 0 rows for you.

You could actually INSERT this missing SRID into that spatial reference
table (by searching the PostGIS mailing list for that exact command),
or, easier, don't use this missing SRID for now :)

-jeff




Actually that page (http://epsg.io/5223) already has a 'PostGIS' link on it with the command to use!!!! (below, in the "Export" section). You can run this command directly through pssql !!!!



INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 5223, 'EPSG', 5223, '+proj=tmerc +lat_0=0 +lon_0=12 +k=0.9996 +x_0=500000 +y_0=500000 +datum=WGS84 +units=m +no_defs ', 'PROJCS["WGS 84 / Gabon TM",GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",12],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",500000],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","5223"]]');



-jeff


--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/




_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to