I have table in db that contains nonspatal data (no geometry) just x,y field. Is it possible to add table to geoserver as Feature Type ?.
Thx Grega
Grega Bizjak schrieb:
I have table in db that contains nonspatal data (no geometry) just x,y field. Is it possible to add table to geoserver as Feature Type ?.
Thx Grega
------------------------------------------------------------------------
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Dear Grega,
if you have access to postgis, it's simple to build a geometry column out of your dbf in three steps:
Import dbf-table to postgis.
Use "AddgeometryColumn" Function to add a geometry column to your table.
UPDATE <TABLE_NAME> SET the_geom = (GeometryFromText('POINT(' || x || ' ' || y || ')',YOUR_EPSG_CODE))
Best reagrds, Till
----------------------------------------------------------
terrestris GmbH & Co. KG
Irmintrudisstrasse 17
53111 Bonn
Germany
Till Adams
Geschäftsführung
Tel: +49 (0)228 / 962 899-52
Fax: +49 (0)228 / 962 899-57
adams@anonymised.com http://www.terrestris.de
Amtsgericht Bonn, HRA 6835
---------------------------------------------------------
Komplementärin:
terrestris Verwaltungs GmbH
vertreten durch:
Hinrich Paulsen, Till Adams
Grega Bizjak ha scritto:
I have table in db that contains nonspatal data (no geometry) just x,y field. Is it possible to add table to geoserver as Feature Type ?.
It is possible, but GeoServer will use it as a geometryless data type,
that is, it won't give any special meaning to x and y.
There is a datastore that allows to perform that kind of mapping,
known as the geometryless datastore, but I frankly never used it so
I have no idea about its state. As far as I can see it's not even in
the geotools build...
Rob, cc'ed, may know more, both about the availability and about
the functionality.
In the meantime, the other suggestion about how to create a real
postgis geometry is a good workaround.
Cheers
Andrea
I remember having read support for SQL function calls in Deegree. Check
this page:
http://www.deegree.org/docs/wfs/deegree_wfs_configuration_2006-10-26.htm
l
But I am not sure if you can perform transactions using this method.
Hope it helps.
Upendra
-----Original Message-----
From: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net] On Behalf Of
Andrea Aime
Sent: Wednesday, January 09, 2008 9:43 AM
To: Grega Bizjak
Cc: Rob Atkinson; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] non spatial data
Grega Bizjak ha scritto:
I have table in db that contains nonspatal data (no geometry) just
x,y field. Is it possible to add table to geoserver as Feature Type ?.
It is possible, but GeoServer will use it as a geometryless data type,
that is, it won't give any special meaning to x and y.
There is a datastore that allows to perform that kind of mapping, known
as the geometryless datastore, but I frankly never used it so I have no
idea about its state. As far as I can see it's not even in the geotools
build...
Rob, cc'ed, may know more, both about the availability and about the
functionality.
In the meantime, the other suggestion about how to create a real postgis
geometry is a good workaround.
Cheers
Andrea
------------------------------------------------------------------------
-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for just about anything Open
Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketp
lace
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
I guess you can also create a view in the database which contains an
SQL function call which converts the x,y fields into geometry type. The
view can be used in the geoserver configuration instead of a table. Does
this make sense?
Upendra
-----Original Message-----
From: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net] On Behalf Of
Andrea Aime
Sent: Wednesday, January 09, 2008 9:43 AM
To: Grega Bizjak
Cc: Rob Atkinson; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] non spatial data
Grega Bizjak ha scritto:
I have table in db that contains nonspatal data (no geometry) just
x,y field. Is it possible to add table to geoserver as Feature Type ?.
It is possible, but GeoServer will use it as a geometryless data type,
that is, it won't give any special meaning to x and y.
There is a datastore that allows to perform that kind of mapping, known
as the geometryless datastore, but I frankly never used it so I have no
idea about its state. As far as I can see it's not even in the geotools
build...
Rob, cc'ed, may know more, both about the availability and about the
functionality.
In the meantime, the other suggestion about how to create a real postgis
geometry is a good workaround.
Cheers
Andrea
------------------------------------------------------------------------
-
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for just about anything Open
Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketp
lace
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Yep, this is exactly what the geometryless data store does.
what version of geoserver are you using? I think 1.6 would be the one
to aim at. There are some dependencies on another unsupported module
I was trying to decouple when the branch to geotools 2.4 and a whole
raft of GeoAPI changes got in the way, I'll need to dive back in and
assess what needs to be done.
Rob
On Jan 10, 2008 1:43 AM, Andrea Aime <aaime@anonymised.com> wrote:
Grega Bizjak ha scritto:
> I have table in db that contains nonspatal data (no geometry) just x,y
> field. Is it possible to add table to geoserver as Feature Type ?.It is possible, but GeoServer will use it as a geometryless data type,
that is, it won't give any special meaning to x and y.
There is a datastore that allows to perform that kind of mapping,
known as the geometryless datastore, but I frankly never used it so
I have no idea about its state. As far as I can see it's not even in
the geotools build...Rob, cc'ed, may know more, both about the availability and about
the functionality.
In the meantime, the other suggestion about how to create a real
postgis geometry is a good workaround.
Cheers
Andrea
Curently we use gs 1.5.4 (stable).
Thx Grega
-----Original Message-----
From: Rob Atkinson [mailto:robatkinson101@anonymised.com]
Sent: Wednesday, January 09, 2008 11:37 PM
To: Grega Bizjak
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] non spatial data
Yep, this is exactly what the geometryless data store does.
what version of geoserver are you using? I think 1.6 would be the one
to aim at. There are some dependencies on another unsupported module
I was trying to decouple when the branch to geotools 2.4 and a whole
raft of GeoAPI changes got in the way, I'll need to dive back in and
assess what needs to be done.
Rob
On Jan 10, 2008 1:43 AM, Andrea Aime <aaime@anonymised.com> wrote:
Grega Bizjak ha scritto:
> I have table in db that contains nonspatal data (no geometry) just
x,y
> field. Is it possible to add table to geoserver as Feature Type ?.
It is possible, but GeoServer will use it as a geometryless data type,
that is, it won't give any special meaning to x and y.
There is a datastore that allows to perform that kind of mapping,
known as the geometryless datastore, but I frankly never used it so
I have no idea about its state. As far as I can see it's not even in
the geotools build...Rob, cc'ed, may know more, both about the availability and about
the functionality.
In the meantime, the other suggestion about how to create a real
postgis geometry is a good workaround.
Cheers
Andrea