Hi Andrea
I can confirm that Geoserver NOW has access to the geometry_columns view and
now it works.
But still, if I declare an SRS I would expect that SRS being specified in the
query to the database?
Thanks for your answer!
Regards, Casper
From: [email protected] [mailto:[email protected]] On Behalf Of Andrea
Aime
Sent: 17. december 2014 09:26
To: Casper Børgesen (CABO)
Cc: [email protected]
Subject: Re: [Geoserver-users] Geoserver, PostGIS, WFS query not using the
spatial index.
On Wed, Dec 17, 2014 at 9:01 AM, Casper Børgesen (CABO)
<[email protected]<mailto:[email protected]>> wrote:
Hi.
I have some problems with GeoServer (2.5.2) and PostGIS (2.1.1). When I make a
WFS request to a view on my database, I get a SELECT query like this:
SELECT "id",encode(ST_AsEWKB("geometry"),'base64') as "geometry" FROM
"public"."my_table" WHERE "geometry" && ST_GeomFromText('POLYGON
((891837.6082013508 6147533.812230958, 891837.6082013508 6148331.277858112,
893164.795314311 6148331.277858112, 893164.795314311 6147533.812230958,
891837.6082013508 6147533.812230958))', ST_SRID("geometry")) LIMIT 1000000
GeoServer falls back on this syntax when the srid of the geometry is not known.
Can you verify the geoserver user can access the geometry_columns view?
Cheers
Andrea
--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.
Please, notice that GeoSolutions will be closed for seasonal holidays
from December the 24th to January the 6th
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i
file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo
è consentito esclusivamente al destinatario del messaggio, per le finalità
indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne
il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di
procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro
sistema. Conservare il messaggio stesso, divulgarlo anche in parte,
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse,
costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for the
attention and use of the named addressee(s) and may be confidential or
proprietary in nature or covered by the provisions of privacy act (Legislative
Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in
accord with its purpose, any disclosure, reproduction, copying, distribution,
or either dissemination, either whole or partial, is strictly forbidden except
previous formal approval of the named addressee(s). If you are not the intended
recipient, please contact immediately the sender by telephone, fax or e-mail
and delete the information in this message that has been received in error. The
sender does not give any warranty or accept liability as the content, accuracy
or completeness of sent messages and accepts no responsibility for changes
made after they were sent or for other risks which arise as a result of e-mail
transmission, viruses, etc.
-------------------------------------------------------
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
