[Geoserver-users] Geometry column

GeoServer GeoServer User
1

Hi,

Our team has some questions which we hope GeoServer can help us with.

  1. We are currently using PostgreSQL with PostGIS, and PostGIS stores the geometries in a geometry column. Please correct me if I am wrong, but is this only specific to PostGreSQL with PostGIS? In other words, if we were to change the database we want to use, can GeoServer still function without this geometry column?

  2. Then how would my map knows what to draw without the geometry column? Is it possible to draw a feature just from plain coordinates?

Regards,
Lee Wai See

[This e-mail is confidential and may be priviledged. If you are not the
intended recipient, please kindly notify us immediately and delete the message
from your system; please do not copy or use it for any purpose, nor disclose
its contents to any other person. Thank you.]
---ST Electronics Group---

–
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.4/449 - Release Date: 9/15/2006

2

Hi Ivan,

Thanks for reply. Please bear with me, but could you please elaborate on
these two points?

1.

it only needs
to know what GeoServer can offer.

2.

and if you want to draw map from plain coordinates you can export
postgres table to shape file.

Thanks a lot.

Regards,
Wai See

Postgres/Postgis is only one of the sources GeoServer accepts. Thats
the nice thing with geoserver, your map doesnt need to know about
geometry column or postgres or about geoserver sources, it only needs
to know what GeoServer can offer.

and if you want to draw map from plain coordinates you can export
postgres table to shape file.

hope i helped

regards!

On 9/21/06, Lee Wai See <leewse@anonymised.com> wrote:

Hi,

Our team has some questions which we hope GeoServer can help us with.

We are currently using PostgreSQL with PostGIS, and PostGIS stores the
geometries in a geometry column. Please correct me if I am wrong, but is
this only specific to PostGreSQL with PostGIS? In other words, if we
were to
change the database we want to use, can GeoServer still function without
this geometry column?

2. Then how would my map knows what to draw without the geometry
column?
Is it possible to draw a feature just from plain coordinates?

Regards,
Lee Wai See

  [This e-mail is confidential and may be priviledged. If you are not
the
intended recipient, please kindly notify us immediately and delete the
message
from your system; please do not copy or use it for any purpose, nor
disclose
its contents to any other person. Thank you.]
---ST Electronics Group---

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.4/449 - Release Date:
9/15/2006

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Ivan Grcic
National IT coordinator
Iaeste Croatia

Email: ivan.grcic@anonymised.com
Tel: +385 98 567 457

3

Hi,
I think it depends on the DataStore you use … GeoServer needs Features with a geometry attribute plus a Coordinate Reference System. Is up to you or your datastore provide those information.

On 9/21/06, Lee Wai See <leewse@anonymised.com > wrote:

Hi,

Our team has some questions which we hope GeoServer can help us with.

  1. We are currently using PostgreSQL with PostGIS, and PostGIS stores the geometries in a geometry column. Please correct me if I am wrong, but is this only specific to PostGreSQL with PostGIS? In other words, if we were to change the database we want to use, can GeoServer still function without this geometry column?

  2. Then how would my map knows what to draw without the geometry column? Is it possible to draw a feature just from plain coordinates?

Regards,
Lee Wai See

[This e-mail is confidential and may be priviledged. If you are not the
intended recipient, please kindly notify us immediately and delete the message
from your system; please do not copy or use it for any purpose, nor disclose

its contents to any other person. Thank you.]
---ST Electronics Group---

–
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.4/449 - Release Date: 9/15/2006

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net’s Techsay panel and you’ll get the chance to share your
opinions on IT & business topics through brief surveys – and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

Eng. Alessio Fabiani
Vice President/CTO GeoSolutions

http://www.geo-solutions.it

4

You're actually probably wanting the 'geometryless' module, if you're wanting to get geometries just from coordinates. It's a part of geotools, but we're not shipping it with GeoServer yet. So if you look at that code, you can find a jdbc datastore that just reads coordinates from x and y columns.

best regards,

Chris

leewse@anonymised.com wrote:

Hi Ivan,

Thanks for reply. Please bear with me, but could you please elaborate on
these two points?

1.

it only needs
to know what GeoServer can offer.

2.

and if you want to draw map from plain coordinates you can export
postgres table to shape file.

Thanks a lot.

Regards,
Wai See

Postgres/Postgis is only one of the sources GeoServer accepts. Thats
the nice thing with geoserver, your map doesnt need to know about
geometry column or postgres or about geoserver sources, it only needs
to know what GeoServer can offer.

and if you want to draw map from plain coordinates you can export
postgres table to shape file.

hope i helped

regards!

On 9/21/06, Lee Wai See <leewse@anonymised.com> wrote:

Hi,

Our team has some questions which we hope GeoServer can help us with.

We are currently using PostgreSQL with PostGIS, and PostGIS stores the
geometries in a geometry column. Please correct me if I am wrong, but is
this only specific to PostGreSQL with PostGIS? In other words, if we
were to
change the database we want to use, can GeoServer still function without
this geometry column?

2. Then how would my map knows what to draw without the geometry
column?
Is it possible to draw a feature just from plain coordinates?

Regards,
Lee Wai See

  [This e-mail is confidential and may be priviledged. If you are not
the
intended recipient, please kindly notify us immediately and delete the
message
from your system; please do not copy or use it for any purpose, nor
disclose
its contents to any other person. Thank you.]
---ST Electronics Group---

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.4/449 - Release Date:
9/15/2006

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Ivan Grcic
National IT coordinator
Iaeste Croatia

Email: ivan.grcic@anonymised.com
Tel: +385 98 567 457

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:1003,45129245234807785049143!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

5

Thanks for the replies. Suppose we keep the geometry column, how does it
compare in terms of performance between these two: sending a request to
GeoServer to update the feature geometry vs having our application access
PostGreSQL directly and call PostGIS functions to update the geometry
column?

Thanks.

Regards,
Wai See

-----Original Message-----
From: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net] On Behalf Of Chris
Holmes
Sent: Sunday, September 24, 2006 10:22 PM
To: leewse@anonymised.com
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Geometry column

You're actually probably wanting the 'geometryless' module, if you're
wanting to get geometries just from coordinates. It's a part of
geotools, but we're not shipping it with GeoServer yet. So if you look
at that code, you can find a jdbc datastore that just reads coordinates
from x and y columns.

best regards,

Chris

leewse@anonymised.com wrote:

Hi Ivan,

Thanks for reply. Please bear with me, but could you please elaborate on
these two points?

1.

it only needs
to know what GeoServer can offer.

2.

and if you want to draw map from plain coordinates you can export
postgres table to shape file.

Thanks a lot.

Regards,
Wai See

Postgres/Postgis is only one of the sources GeoServer accepts. Thats
the nice thing with geoserver, your map doesnt need to know about
geometry column or postgres or about geoserver sources, it only needs
to know what GeoServer can offer.

and if you want to draw map from plain coordinates you can export
postgres table to shape file.

hope i helped

regards!

On 9/21/06, Lee Wai See <leewse@anonymised.com> wrote:

Hi,

Our team has some questions which we hope GeoServer can help us with.

We are currently using PostgreSQL with PostGIS, and PostGIS stores the
geometries in a geometry column. Please correct me if I am wrong, but is
this only specific to PostGreSQL with PostGIS? In other words, if we
were to
change the database we want to use, can GeoServer still function without
this geometry column?

2. Then how would my map knows what to draw without the geometry
column?
Is it possible to draw a feature just from plain coordinates?

Regards,
Lee Wai See

  [This e-mail is confidential and may be priviledged. If you are not
the
intended recipient, please kindly notify us immediately and delete the
message
from your system; please do not copy or use it for any purpose, nor
disclose
its contents to any other person. Thank you.]
---ST Electronics Group---

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.4/449 - Release Date:
9/15/2006

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

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys -- and earn cash

http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Ivan Grcic
National IT coordinator
Iaeste Croatia

Email: ivan.grcic@anonymised.com
Tel: +385 98 567 457

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share

your

opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:1003,45129245234807785049143!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.8/455 - Release Date: 9/22/2006

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.8/455 - Release Date: 9/22/2006