<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">David,<div><br></div><div>Okay. I'm not familiar with that example, but it seems to read in georss rather than GML.</div><div><div><div><br></div><div>Perhaps you can hand form your coordinates into georss suitable for loading into that example by:</div><div><br></div><div>1) Converting your geometries to EPSG:4326 srid</div><div>2) Concatenating the geometries together with the georss xml</div><div>3) Giving the file a header with a scripting language or javascript</div><div><br></div><div>1 and 2 can be accomplished like so:</div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; ">Drop <span style="color: #0000cc">table</span> <span style="color: #0000cc">if</span> <span style="color: #0000cc">exists</span> test;</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; color: rgb(255, 47, 81); "><span style="color: #000000">Select ST_GeomFromEWKT(</span>'SRID=24877;POINT(723852.689845968 9683464.33250772)'<span style="color: #000000">) </span><span style="color: #0000cc">as</span><span style="color: #000000"> geometry, </span>'1995-12-12T05:00:00Z'<span style="color: #000000">::text </span><span style="color: #0000cc">as</span><span style="color: #000000"> </span><span style="color: #0000cc">time</span><span style="color: #000000"> </span><span style="color: #0000cc">into</span><span style="color: #000000"> test;</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; min-height: 15px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; ">Select <span style="color: #ff2f51">'<item><pubDate>'</span> || <span style="color: #0000cc">time</span> || <span style="color: #ff2f51">'</pubDate><geo:lat>'</span> || ST_Y(ST_Transform(geometry,4326)) </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; ">|| <span style="color: #ff2f51">'</geo:lat><geo:long>'</span> || ST_X(ST_Transform(geometry,4326)) || <span style="color: #ff2f51">'</geo:long></item>'</span> <span style="color: #0000cc">from</span> test;</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; ">which gives:</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; "><item><pubDate>1995-12-12T05:00:00Z</pubDate><geo:lat>-78.9862916594766</geo:lat><geo:long>-2.86196482025465</geo:long></item></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; ">and looks somewhat similar to what is used in the point track example: <span class="Apple-style-span" style="font-family: Helvetica; "><a href="http://openlayers.org/dev/examples/xml/track1.xml">http://openlayers.org/dev/examples/xml/track1.xml</a></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; "><font class="Apple-style-span" face="Helvetica"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; "><font class="Apple-style-span" face="Helvetica">Does that help?</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; "><font class="Apple-style-span" face="Helvetica"><br></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; ">Dane</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal 'Lucida Grande'; "><br></div></div><div>On Aug 15, 2008, at 6:04 PM, David Calle wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr">Hi Dane...<br><br>Yeah... I'm using OpenLayers.... <br>I'neet to use the Track Point Marker example where the xml file it't indispensable...<br>But for example> <br> the coords of my city in my xml file <br> 713620.5057, 9673754.1986<br> and the coords of my city in the example map <br> -79.86664 -20.54546<br><br>Because I'm using this function<br> x(the_geom), y(the_geom)<br> <br>If I use asewkb(the_geom)><br> "\001\001\000\000 -a\000\000\240}3a\031\027&A;\347\243\012AxbA"<br><br>And with asewkt(the_geom)><br><br>"SRID=24877;POINT(723852.689845968 9683464.33250772)"<br> <br><br><br><br><div class="gmail_quote">2008/8/15 Dane Springmeyer <span dir="ltr"><<a href="mailto:blake@hailmail.net">blake@hailmail.net</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Hi David,<br> <br> I'm not sure about that error, but if you are exporting from postgis to be able to be read into an OpenLayers map you can also use the WKT format, as well as GeoJson and KML.<br> <br> So, you are not web to GML.<br> <br> Cheers,<br> <br> Dane<div><div></div><div class="Wj3C7c"><br> <br> On Aug 15, 2008, at 5:35 PM, David Calle wrote:<br> <br> </div></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="Wj3C7c"> Hi List,<br> I need to convert my geometry to GPS position.... I'm trying with<br> asgml(geometry)<br> But I have this error.. ERROR: Only GML 2 and GML 3 are supported<br> <br> And this is my version of postgis..<br> "POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS DBPROC="0.3.0" RELPROC="1.3.3" (needs proc upgrade)"<br> <br> I need this, because I need to generate a xml file with the GPS format of my points...<br> <br> Thanks Advanced...!!<br></div></div> _______________________________________________<br> postgis-users mailing list<br> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> </blockquote> <br> _______________________________________________<br> postgis-users mailing list<br> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> </blockquote></div><br></div> _______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>http://postgis.refractions.net/mailman/listinfo/postgis-users<br></blockquote></div><br></div></body></html>