<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yiv0866937124"><div id="yui_3_16_0_ym19_1_1484936534572_8348"><div style="color:#000;background-color:#fff;font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;" id="yui_3_16_0_ym19_1_1484936534572_8347"><div id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5240">Chakir,</div><div id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5241"><br clear="none"></div><div dir="ltr" id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5242"><div dir="ltr" id="yui_3_16_0_ym19_1_1484936534572_8355">I never have used geography instead of geometry in PostGIS. However, I know than you can cast this type to geometry by adding <font id="yui_3_16_0_ym19_1_1484936534572_8975" face="Courier New, courier, monaco, monospace, sans-serif">::geometry</font> to it, so as a workaround you can try the following:</div><div dir="ltr" id="yui_3_16_0_ym19_1_1484936534572_8628"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1484936534572_8627"><font id="yui_3_16_0_ym19_1_1484936534572_8786" face="Courier New, courier, monaco, monospace, sans-serif">SELECT AddGeometryColumn('<table name>', 'geom2', 4326, '<type>', 2);</font></div><div dir="ltr" id="yui_3_16_0_ym19_1_1484936534572_8625"><font id="yui_3_16_0_ym19_1_1484936534572_8785" face="Courier New, courier, monaco, monospace, sans-serif">UPDATE <table_name> SET geom2 = geom::geometry;</font></div><div dir="ltr" id="yui_3_16_0_ym19_1_1484936534572_8570"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1484936534572_8895">Finally, in you MAP file point to the new geom2 column (i.e. <font id="yui_3_16_0_ym19_1_1484936534572_8907" face="Courier New, courier, monaco, monospace, sans-serif">DATA "geom2 FROM <table_name></font>)</div><div dir="ltr" id="yui_3_16_0_ym19_1_1484936534572_8941"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1484936534572_8942">Cheers<br></div></div></div></div></div><div class=".yiv0866937124yahoo_quoted" id="yui_3_16_0_ym19_1_1484936534572_8405"> <div id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5061" style="font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"> <div id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5060" style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1484936534572_8404"><br></div><div class="yiv0866937124yqt4181256258" id="yiv0866937124yqt39344"><div dir="ltr" id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5059"> <font id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5275" face="Arial" size="2"> </font><hr size="1"> <b><span style="font-weight:bold;">From:</span></b> ferdaousse chakir <ferdaousse.chakir@gmail.com><br clear="none"> <b><span style="font-weight:bold;">To:</span></b> mapserver-users@lists.osgeo.org <br clear="none"> <b><span style="font-weight:bold;">Sent:</span></b> Friday, January 20, 2017 10:14 AM<br clear="none"> <b><span style="font-weight:bold;">Subject:</span></b> [mapserver-users] Postgis geography data<br clear="none"> </div> <div class="yiv0866937124y_msg_container" id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5066"><br clear="none"><div id="yiv0866937124"><div dir="ltr" id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5067">Hi everyone,<div id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5068">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 :) :) .</div><div id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5315">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 .</div><div id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5316">I'm wondering if mapserver support postgis geography data type or not ?</div><div id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5317">Any ideas ?? :)<br clear="all"><div id="yiv0866937124yui_3_16_0_ym19_1_1484936534572_5318"><br clear="none"></div>-- <br clear="none"><div class="yiv0866937124gmail_signature"><div dir="ltr"><div><div dir="ltr">
<div style="background-color:rgb(255,255,255);"><i><span style="color:rgb(34,34,34);"><font face="'times new roman', serif" size="2"><b>Ferdaousse Chakir</b></font></span></i></div>
<div style="background-color:rgb(255,255,255);"><i><font face="Georgia" size="2" color="#262626"><span style="color:rgb(34,34,34);">Élève-Ingénieur en 3ème Année -Mastère (Architecture des systèmes d'informations géographiques)</span></font></i></div><div style="background-color:rgb(255,255,255);"><i><font face="Georgia" size="2" color="#262626"><span style="color:rgb(34,34,34);">Ecole Nationale des Sciences Géographiques-Champs sur marne France</span></font></i></div>
<div style="background-color:rgb(255,255,255);"><font size="2"><br clear="none"></font></div>
<div style="background-color:rgb(255,255,255);"><i><font size="2"><span style="color:rgb(38,38,38);"><b><font face="'times new roman', serif">Mobile : 06.67.45.00.60</font><br style="font-family:georgia, serif;" clear="none"><font face="'times new roman', serif">E-mail :</font></b></span><b style="font-family:arial, sans-serif;"><span style="font-family:georgia, serif;"><span style="color:rgb(38,38,38);"> </span><u><font color="#993399"><a rel="nofollow" shape="rect" ymailto="mailto:ferdaousse.chakir@gmail.com" target="_blank" href="mailto:ferdaousse.chakir@gmail.com">ferdaousse.chakir@gmail.com</a></font></u></span></b></font></i></div></div></div></div></div>
</div></div></div><br clear="none">_______________________________________________<br clear="none">mapserver-users mailing list<br clear="none"><a rel="nofollow" shape="rect" ymailto="mailto:mapserver-users@lists.osgeo.org" target="_blank" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br clear="none"><br clear="none"></div></div> </div> </div> </div></div></body></html>