[Geoserver-users] Point Geometry in lon/lat columns of non-spatial db

GeoServer GeoServer User
1

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

2

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) <Jens.Nachtigall@anonymised.com99...> 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

3

Yes, I need it for OGC services, that is WFS and WMS.

···

Von: Eric Jarvies [mailto:7@anonymised.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) <Jens.Nachtigall@anonymised.com…> 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

4

A „does not work, you must use a spatial db to hold point coordinates” would help me, too :wink: Does nobody know?

Cheers,

Jens

5

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 Garnett

On Thu, Sep 11, 2014 at 7:10 AM, Nachtigall, Jens (init) <Jens.Nachtigall@anonymised.com> 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@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

6

On Mon, Sep 15, 2014 at 6:30 PM, Jody Garnett <jody.garnett@anonymised.com>
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

-------------------------------------------------------

7

On Mon, Sep 15, 2014 at 1:42 PM, Andrea Aime <andrea.aime@anonymised.com>
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