[mapserver-users] postgres layer not visible

[Jeff McKenna]

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/