[Geoserver-users] Geometry column

GeoServer GeoServer User
1

Hi,

Can anyone help answer my query below? Thanks a lot.

Regards,
Wai See

-----Original Message-----
From: Lee Wai See [mailto:leewse@anonymised.com]
Sent: Monday, September 25, 2006 2:37 PM
To: 'Chris Holmes'
Cc: 'geoserver-users@lists.sourceforge.net'
Subject: RE: [Geoserver-users] Geometry column

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

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

2

Hi Lee,

Accessing PostgreSQL/PostGIS directly should be faster then going
through GeoServer first. If you have application that works well with
accessing/updating PostGIS directly you may as well continue to do it
like that. GeoServer should be used then to publish your data trough
some of services it offers!

regards,
Ivan

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

Hi,

Can anyone help answer my query below? Thanks a lot.

Regards,
Wai See

-----Original Message-----
From: Lee Wai See [mailto:leewse@anonymised.com]
Sent: Monday, September 25, 2006 2:37 PM
To: 'Chris Holmes'
Cc: 'geoserver-users@lists.sourceforge.net'
Subject: RE: [Geoserver-users] Geometry column

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

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.9/457 - Release Date: 9/26/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

I am still at very begining with using the GeoServer, so still havent
tried to use WFS-T features. And I think there isn't many applications
that support it. I still have to research that area :slight_smile:

But I think that both ways (direct access to PostgreSQL and WFS-T)
should work fine, allthough I think that direct access is a bit
faster, especially for large amount of features.

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

Hi Ivan,

Thanks for the reply. But what would be the implications of not using WFS-T
for feature updates, if any?

Regards,
Lee Wai See

-----Original Message-----
From: Ivan Grcic [mailto:igrcic@anonymised.com]
Sent: Wednesday, September 27, 2006 6:20 PM
To: Lee Wai See
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Geometry column

Hi Lee,

Accessing PostgreSQL/PostGIS directly should be faster then going
through GeoServer first. If you have application that works well with
accessing/updating PostGIS directly you may as well continue to do it
like that. GeoServer should be used then to publish your data trough
some of services it offers!

regards,
Ivan

On 9/27/06, Lee Wai See <leewse@anonymised.com> wrote:
> Hi,
>
> Can anyone help answer my query below? Thanks a lot.
>
> Regards,
> Wai See
>
> -----Original Message-----
> From: Lee Wai See [mailto:leewse@anonymised.com]
> Sent: Monday, September 25, 2006 2:37 PM
> To: 'Chris Holmes'
> Cc: 'geoserver-users@lists.sourceforge.net'
> Subject: RE: [Geoserver-users] Geometry column
>
> 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
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.405 / Virus Database: 268.12.9/457 - Release Date: 9/26/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

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

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

--
Ivan Grcic
National IT coordinator
Iaeste Croatia

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

4

Yeah, that would be my guess as well.

In the future we hope to make GeoServer as fast as anyone inserting by hand, and indeed faster in cases where people don't optimize (using WKB instead of WKT, ect.). Ideally we could also let people do an 'insert' with a shapefile or other formats that are smaller than GML. But for now the parsing of GML and inserting in to GeoServer is slower than it would be to go straight through JDBC.

best regards,

Chris

Ivan Grcic wrote:

Hi Lee,

Accessing PostgreSQL/PostGIS directly should be faster then going
through GeoServer first. If you have application that works well with
accessing/updating PostGIS directly you may as well continue to do it
like that. GeoServer should be used then to publish your data trough
some of services it offers!

regards,
Ivan

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

Hi,

Can anyone help answer my query below? Thanks a lot.

Regards,
Wai See

-----Original Message-----
From: Lee Wai See [mailto:leewse@anonymised.com]
Sent: Monday, September 25, 2006 2:37 PM
To: 'Chris Holmes'
Cc: 'geoserver-users@lists.sourceforge.net'
Subject: RE: [Geoserver-users] Geometry column

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

--
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

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.9/457 - Release Date: 9/26/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

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