[mapserver-users] postgres layer not visible

[Jeff McKenna]

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



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



On 2015-01-20 5:59 AM, Maiorano Pasquale wrote:
> Dear Jeff,
>
> I implemented your advice  and set the OIDS=true. Now the utility
> shp2img return the following:
>
> … error executing query: ERRORE: find_SRID() could not find the
> corresponding SRID…. Take into account that the used SRID is directly
> returned by the QGIS plugin named “RT MapServer export. “.
>
> Any further idea to fix this new problem???
>
> Regards,
>
> Pasquale
>
>
>