Hi Mark, <br><br>Yes, that helps. I'll see if i missed the proj4 installation along the way, or if, more probably i am simply feeding PostGIS lat/long data that is not in decimal degrees. <br><br>I'll let you know if it doesn't work.
<br><br>Thanks, <br><br>Giuseppe <br><br><br><br><div><span class="gmail_quote">On 4/11/07, <b class="gmail_sendername">Mark Cave-Ayland</b> <<a href="mailto:mark.cave-ayland@ilande.co.uk">mark.cave-ayland@ilande.co.uk
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">On Wed, 2007-04-11 at 13:58 +0200, Giuseppe Molinario wrote:<br>> Hi everyone,
<br><br>Hi Guiseppe,<br><br>> I have a question regarding the creation in PostGIS of a table that<br>> contains information coming from a NMEA GPRMC text string. I get<br>> Lat/long coordinates which are then put into their respective columns.
<br>> A geometry field is then created using the SRID # 4326 (WGS84 Datum -<br>> Geographic).<br>><br>> 1. What format of Lat/long coordinates does PostGIS accept? GPRMC has<br>> the coordinate in this format:
ddmm.mmmmm.<br><br>PostGIS accepts coordinates in decimal degrees.<br><br>> 2. How do I project the points into WGS84UTM33N? My final goal is to<br>> overlay these points as a PostGIS layer on a webmap (Mapserver based)
<br>> over other data I have which is in that projection.<br><br>The transform() function should be able to do what you need here if you<br>use a version of PostGIS that has been compiled with the PROJ.4<br>reprojection library.
<br><br>> 3. Do you know if Mapserver will re-project on the fly in my case?<br>> ever? or do I have to take care of this in PostGIS?<br><br>Yes. Mapserver can also reproject layers on-the-fly using PROJ.4. There<br>
are plenty of examples on the Mapserver website at<br><a href="http://mapserver.gis.umn.edu">http://mapserver.gis.umn.edu</a>.<br><br><br>HTH,<br><br>Mark.<br><br><br>_______________________________________________<br>postgis-users mailing list
<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br></blockquote></div><br>