Hello All,

I have a company-internal application that I wrote that searches twitter for a 
large group of keywords and then stores the corresponding tweets in a database. 
The front-end for it allows the user to then search through the data and 
optionally generate a kml file. Now, another group in the company wants me to 
publish all of the data via wfs for use in ArcMap. I'm new to GeoServer and 
feel like I'm missing something obvious, so hopefully someone here can help me 
out quickly (without much ridicule ;-). I have two questions:

1) The each row in my table has a separate latitude and longitude column (we're 
using oracle, but don't have oracle-spatial). I can't seem to figure out how to 
publish this data without having them combined into a single geometry column. 
I've searched the mailing list and have heard people talk of an 
old/unsupported/broken geometryless plugin. Also read that it could be done 
with the application-schema plugin, but can't find a simple example of how to 
use it to serve this type of data.

2) We've accumulated about 20k rows in the database, and that's growing by a 
few hundred a day. With the front-end + kml, it cuts down the number of tweets 
in the kml file and the timestamps keep everything from showing up on the 
display all at once. How do I do something similar with GeoServer? At first 
glance, it looks like I'll only be able to do just a dump of everything in the 
database...


Thanks in advance for the help!
-Michael
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to