[Geoserver-devel] [jira] (GEOS-5270) SQL Views bounding box parameter

Tue, 14 Aug 2012 07:09:36 -0700

Issue Type: Improvement Improvement
Assignee: Andrea Aime
Created: 14/Aug/12 9:08 AM
Description:

We have data in a table with latitude and longitude values which we present to GeoServer in the form of a view

SELECT id, GeomFromText(concat('POINT(',lng,' ',lat,')')) as pt
FROM table

We then produce point icons with GeoServer.
The table consist of 100000 points and GeoServer fetches the data over and over again. The time consuming part is the data transfer from database to GeoServer. It would be an improvement to be able to send the bounding box for the SQL View data to be fetched.
Environment: NA
Project: GeoServer
Priority: Minor Minor
Reporter: Jonas Reinhardt
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators.
For more information on JIRA, see: http://www.atlassian.com/software/jira 
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

Reply via email to