[mapserver-users] Postgis geography data

[Carlos Ruiz]

Chakir,
I never have used geography instead of geometry in PostGIS. However, I know than you can cast this type to geometry by adding ::geometry to it, so as a workaround you can try the following:
SELECT AddGeometryColumn('<table name>', 'geom2', 4326, '<type>', 2);UPDATE <table_name> SET geom2 = geom::geometry;
Finally, in you MAP file point to the new geom2 column (i.e. DATA "geom2 FROM <table_name>)
Cheers
   
   From: ferdaousse chakir <ferdaousse.chakir at gmail.com>
 To: mapserver-users at lists.osgeo.org 
 Sent: Friday, January 20, 2017 10:14 AM
 Subject: [mapserver-users] Postgis geography data
  
Hi everyone,I already asked this question , but infortunally no one answered, so , i'm gonna ask it again hopefully i'll get an answer this time :) :) .I'm trying to display a spatial table (Postgis) with mapserver.the problem is my spatial data is a geography type not geometry so the postgis functions used by mapserver doesn't work .I'm wondering if mapserver support postgis geography data type or not ?Any ideas ?? :)

-- 
Ferdaousse ChakirÉlève-Ingénieur en 3ème Année -Mastère (Architecture des systèmes d'informations géographiques)Ecole Nationale des Sciences Géographiques-Champs sur marne France
Mobile : 06.67.45.00.60
E-mail : ferdaousse.chakir at gmail.com
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20170120/fc2cdc99/attachment.htm>