Hi Michael, I hope the following helps:
1) Even though you do not have the spatial option, you can still use locator which is basically a cut down version of spatial. Thus creating the spatial objects in a new column on your db table from your lon / lat. You when then be able to use the oracle-ng spatial plugin for GS. 2) You can pass OGC filters in your request to get the data you require from WFS. Cheers, Steve -----Original Message----- From: Michael Bowman [mailto:[email protected]] Sent: 13 June 2011 16:31 To: [email protected] Subject: [Geoserver-users] Serving Twitter data via GeoServer Trying again... this didn't seem to go through last night. ----- Forwarded Message ----- From: Michael Bowman <[email protected]> To: "[email protected]" <[email protected]> Sent: Sunday, June 12, 2011 8:29 PM Subject: Serving Twitter data via GeoServer 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 DISCLAIMER: This email may contain confidential information and is intended only for the use of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you are hereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it or attached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at Infotech or [email protected] and delete the original message. ------------------------------------------------------------------------------ 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
