[postgis-users] asGML Error

[Dane Springmeyer]

David,

Okay. I'm not familiar with that example, but it seems to read in  
georss rather than GML.

Perhaps you can hand form your coordinates into georss suitable for  
loading into that example by:

1) Converting your geometries to EPSG:4326 srid
2) Concatenating the geometries together with the georss xml
3) Giving the file a header with a scripting language or javascript

1 and 2 can be accomplished like so:

Drop table if exists test;
Select ST_GeomFromEWKT('SRID=24877;POINT(723852.689845968  
9683464.33250772)') as geometry, '1995-12-12T05:00:00Z'::text as time  
into test;

Select '<item><pubDate>' || time || '</pubDate><geo:lat>' ||  
ST_Y(ST_Transform(geometry,4326))
|| '</geo:lat><geo:long>' || ST_X(ST_Transform(geometry,4326)) || '</ 
geo:long></item>' from test;

which gives:

<item><pubDate>1995-12-12T05:00:00Z</ 
pubDate><geo:lat>-78.9862916594766</ 
geo:lat><geo:long>-2.86196482025465</geo:long></item>

and looks somewhat similar to what is used in the point track example: http://openlayers.org/dev/examples/xml/track1.xml

Does that help?

Dane


On Aug 15, 2008, at 6:04 PM, David Calle wrote:

> Hi Dane...
>
> Yeah... I'm using OpenLayers....
> I'neet to use the Track Point Marker example where the xml file it't  
> indispensable...
> But for example>
>                 the coords of my city in my xml file
>                              713620.5057, 9673754.1986
>                and the coords of my city in the example map
>                        -79.86664 -20.54546
>
> Because I'm using this function
>             x(the_geom), y(the_geom)
>
> If I use asewkb(the_geom)>
>    "\001\001\000\000 -a\000\000\240}3a\031\027&A;\347\243\012AxbA"
>
> And with asewkt(the_geom)>
>
> "SRID=24877;POINT(723852.689845968 9683464.33250772)"
>
>
>
>
> 2008/8/15 Dane Springmeyer <blake at hailmail.net>
> Hi David,
>
> 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.
>
> So, you are not web to GML.
>
> Cheers,
>
> Dane
>
>
> On Aug 15, 2008, at 5:35 PM, David Calle wrote:
>
> Hi List,
> I need to convert my geometry to GPS position.... I'm trying with
> asgml(geometry)
> But I have this error.. ERROR:  Only GML 2 and GML 3 are supported
>
> And this is my version of postgis..
> "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)"
>
> I need this, because I need to generate a xml file with the GPS  
> format of my points...
>
> Thanks Advanced...!!
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080815/6cbf84b5/attachment.html>