Re: [Geoserver-users] Point Geometry in lon/lat columns of non-spatial db
On Mon, Sep 15, 2014 at 1:42 PM, Andrea Aime wrote: > Or we could just implement a GUI for gt-transform, it is supposed to have > management for that > problem too (turn two columns into a single point inside geoserver) > Good thinking, going for the general purpose solution. Was thinking of calling it "Java Views" or something (in order to be similar to SQL views). "Transform view", "Local View" or "View" is probably just better. -- Jody -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Point Geometry in lon/lat columns of non-spatial db
On Mon, Sep 15, 2014 at 6:30 PM, Jody Garnett wrote: > We had a generic "geometryless" JDBC datastore which could use any > database via identifying a lat/lon column. > > You are welcome to resurrect that project: > > > https://github.com/geotools/geotools/tree/2.7.x/modules/unsupported/geometryless > > Or we could just implement a GUI for gt-transform, it is supposed to have management for that problem too (turn two columns into a single point inside geoserver) Cheers Andrea -- == GeoServer Professional Services from the experts! Visit http://goo.gl/NWWaa2 for more information. == 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 --- -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Point Geometry in lon/lat columns of non-spatial db
We had a generic "geometryless" JDBC datastore which could use any database via identifying a lat/lon column. You are welcome to resurrect that project: https://github.com/geotools/geotools/tree/2.7.x/modules/unsupported/geometryless -- Jody Jody Garnett On Thu, Sep 11, 2014 at 7:10 AM, Nachtigall, Jens (init) < jens.nachtig...@init.de> wrote: > Hi, > > > > is it possible to use a db, say Oracle **without** its spatial extension > as a Data source in GeoServer, where the Point geometry is simply stored in > two separate columns? > > > > The columns are simply “lon” and “lat” containing floats. > > > > That is, can I simply map these lon/lat columns in GeoServer and let > GeoServer know that these are my geometry? > > Best, > > Jens > > > > > -- > Want excitement? > Manually upgrade your production database. > When you want reliability, choose Perforce > Perforce version control. Predictably reliable. > > http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk > ___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Point Geometry in lon/lat columns of non-spatial db
Hi, > The real question is: Why would you like to do so? You do not need to pay for > Oracle locator and with it you can add a new column of datatype SDO_GEOM into > your table and populate it from your X and Y columns. If you have an old > system in production and X/Y are updated from some application, make a > trigger and do inserts and updates into SDO_GEOM every time when X or Y are > touched. Thanks for your clarification, I thought Oracle Spatial was required. I am happy with using Oracle Locator then. Best, Jens -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Point Geometry in lon/lat columns of non-spatial db
Hi, I would say that it will not work out-of-the-box because GeoServer does not have X/Y or CSV datastore and what could be done with Mapserver through the GDAL virtual format http://www.gdal.org/drv_vrt.html is not supported. But if you absolutely need such feature it is for sure doable. You can contract a Geoserver developer to make a new datastore or if you are in a hurry you can install Mapserver to read X/Y data from Oracle, publish it as WMS and cascade that layer with Geoserver. The real question is: Why would you like to do so? You do not need to pay for Oracle locator and with it you can add a new column of datatype SDO_GEOM into your table and populate it from your X and Y columns. If you have an old system in production and X/Y are updated from some application, make a trigger and do inserts and updates into SDO_GEOM every time when X or Y are touched. -Jukka Rahkonen- Lähettäjä: Nachtigall, Jens (init) [mailto:jens.nachtig...@init.de] Lähetetty: 12. syyskuuta 2014 15:52 Vastaanottaja: geoserver-users@lists.sourceforge.net Aihe: Re: [Geoserver-users] Point Geometry in lon/lat columns of non-spatial db A "does not work, you must use a spatial db to hold point coordinates" would help me, too ;) Does nobody know? Cheers, Jens -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Point Geometry in lon/lat columns of non-spatial db
A "does not work, you must use a spatial db to hold point coordinates" would help me, too ;) Does nobody know? Cheers, Jens -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Point Geometry in lon/lat columns of non-spatial db
Yes, I need it for OGC services, that is WFS and WMS. Von: Eric Jarvies [mailto:7...@ericjarvies.com] Gesendet: Donnerstag, 11. September 2014 16:41 An: Nachtigall, Jens (init) Cc: geoserver-users@lists.sourceforge.net Betreff: Re: [Geoserver-users] Point Geometry in lon/lat columns of non-spatial db Jens, Did you need GeoServer for some specific purpose for said X|Y coordinates -like creating a WMS layer? If there is no 'good' reason to use GeoServer then said data can simply be accessed via your webcore(read Leaflet or OpenLayer and node.js, as an example). Eric On Sep 11, 2014, at 7:10 AM, Nachtigall, Jens (init) mailto:jens.nachtig...@init.de>> wrote: Hi, is it possible to use a db, say Oracle *without* its spatial extension as a Data source in GeoServer, where the Point geometry is simply stored in two separate columns? The columns are simply "lon" and "lat" containing floats. That is, can I simply map these lon/lat columns in GeoServer and let GeoServer know that these are my geometry? Best, Jens -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
Re: [Geoserver-users] Point Geometry in lon/lat columns of non-spatial db
Jens, Did you need GeoServer for some specific purpose for said X|Y coordinates -like creating a WMS layer? If there is no ‘good’ reason to use GeoServer then said data can simply be accessed via your webcore(read Leaflet or OpenLayer and node.js, as an example). Eric On Sep 11, 2014, at 7:10 AM, Nachtigall, Jens (init) wrote: > Hi, > > is it possible to use a db, say Oracle *without* its spatial extension as a > Data source in GeoServer, where the Point geometry is simply stored in two > separate columns? > > The columns are simply “lon” and “lat” containing floats. > > That is, can I simply map these lon/lat columns in GeoServer and let > GeoServer know that these are my geometry? > Best, > Jens > > -- > Want excitement? > Manually upgrade your production database. > When you want reliability, choose Perforce > Perforce version control. Predictably reliable. > http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk___ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
[Geoserver-users] Point Geometry in lon/lat columns of non-spatial db
Hi, is it possible to use a db, say Oracle *without* its spatial extension as a Data source in GeoServer, where the Point geometry is simply stored in two separate columns? The columns are simply "lon" and "lat" containing floats. That is, can I simply map these lon/lat columns in GeoServer and let GeoServer know that these are my geometry? Best, Jens -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk___ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
