On Mon, Jun 13, 2011 at 5:30 PM, Michael Bowman <[email protected]> wrote: > 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.
We have no way to map x/y data as points now, the code assumes you have a proper geometry. As Steve said, locator is enough and you can build actual points out of it. Alternatively you could implement x/y point mapping in java code and donate it to GeoServer (or have someone do it for you). > 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... You can either use filtering or display them progressively using superoverlays, though afaik the current superoverlay code works properly only if the source data set is not dynamic Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ 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
