[Geoserver-users] GeoRSS / getfeature

Hi
I’m playing around with the georss output of GeoServer (1.6.4):
http://www.sogis1.so.ch:8080/geoserver/wms/reflect?layers=sogis:geo_lieferungen_v&format=rss
(about 1800 features, so I takes a few seconds in the browser).

Now I’ve got some questions:
a) Is it possible to change the title’s behaviour? (Point the link to something else than the getfeature request).
b) Is there a way to access (from the freemarker templates) the position of the geo-tag (where the marker is placed in e.g. google maps)?
c) The getfeature request from the feed above throws an error:

<?xml version="1.0" ?>



error:Translator error
Translator error
Error reading Features
Could not aquire feature:org.geotools.data.DataSourceException: Error Performing SQL query: SELECT "gem_bfs", "gmde_name", "nf_geomete", "datum", "filename", encode(asBinary(force_2d("wkb_geometry"),'XDR'),'base64') FROM "avdpool"."geo_lieferungen_v" WHERE () LIMIT 10
Error Performing SQL query: SELECT "gem_bfs", "gmde_name", "nf_geomete", "datum", "filename", encode(asBinary(force_2d("wkb_geometry"),'XDR'),'base64') FROM "avdpool"."geo_lieferungen_v" WHERE () LIMIT 10
ERROR: syntax error at or near ")"

Other layers/feeds are working.

regards
Stefan

Mit freundlichem Gruss
Stefan Ziegler
Leiter Aufsicht

Kanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
Rötistrasse 4
4501 Solothurn
Telefon 032 627 75 96
Telefax 032 627 75 98
stefan.ziegler@anonymised.com
http://www.so.ch

Hi Stefan,

Ziegler Stefan wrote:

Hi
I'm playing around with the georss output of GeoServer (1.6.4):
http://www.sogis1.so.ch:8080/geoserver/wms/reflect?layers=sogis:geo_lieferungen_v&format=rss
(about 1800 features, so I takes a few seconds in the browser).

Now I've got some questions:
a) Is it possible to change the title's behaviour? (Point the link to something else than the getfeature request).

Not current, its hardcoded in. But i think this is probably something that could be templated. Want to file a jira feature request?

b) Is there a way to access (from the freemarker templates) the position of the geo-tag (where the marker is placed in e.g. google maps)?

So actually using a point different from what its geometry is? There is no way to current do this... but again perhaps something we could handle in a template.

c) The getfeature request from the feed above throws an error:

<?xml version="1.0" ?>
<ServiceExceptionReport
version="1.2.0"
xmlns="http://www.opengis.net/ogc&quot;
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;
xsi:schemaLocation="http://www.opengis.net/ogc http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd&quot;&gt;
<ServiceException>
error:Translator error
Translator error
Error reading Features
Could not aquire feature:org.geotools.data.DataSourceException: Error Performing SQL query: SELECT &quot;gem_bfs&quot;, &quot;gmde_name&quot;, &quot;nf_geomete&quot;, &quot;datum&quot;, &quot;filename&quot;, encode(asBinary(force_2d(&quot;wkb_geometry&quot;),&apos;XDR&apos;),&apos;base64&apos;) FROM &quot;avdpool&quot;.&quot;geo_lieferungen_v&quot; WHERE () LIMIT 10
Error Performing SQL query: SELECT &quot;gem_bfs&quot;, &quot;gmde_name&quot;, &quot;nf_geomete&quot;, &quot;datum&quot;, &quot;filename&quot;, encode(asBinary(force_2d(&quot;wkb_geometry&quot;),&apos;XDR&apos;),&apos;base64&apos;) FROM &quot;avdpool&quot;.&quot;geo_lieferungen_v&quot; WHERE () LIMIT 10
ERROR: syntax error at or near &quot;)&quot;
</ServiceException></ServiceExceptionReport>

Other layers/feeds are working.

Seems the query is a miss and its having problems encoding the featureId parameter in SQL. I wonder, based on that feature id it looks like your table does not have a primary key? If this is the case adding a key should fix the problem.

regards
Stefan

Mit freundlichem Gruss
Stefan Ziegler
Leiter Aufsicht

Kanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
Rötistrasse 4
4501 Solothurn
Telefon 032 627 75 96
Telefax 032 627 75 98
stefan.ziegler@anonymised.com
http://www.so.ch

!DSPAM:4007,4840123c87902092453641!

------------------------------------------------------------------------

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

!DSPAM:4007,4840123c87902092453641!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,4840123c87902092453641!

--
Justin Deoliveira
The Open Planning Project
jdeolive@anonymised.com