You might also give consideration to making your FIDs global with
respect to a network of Web Feature Servers. We've addressed this by
using the IP address of the WFS in our FID generation algorithm. Then
if you ever have a requirement for truly global FID's across a WAN, you
have a workable approach.
-----Original Message-----
From: geoserver-devel-admin@lists.sourceforge.net
[mailto:geoserver-devel-admin@lists.sourceforge.net] On
Behalf Of geoserver-devel-request@lists.sourceforge.net
Sent: Friday, February 11, 2005 12:43 PM
To: geoserver-devel@lists.sourceforge.net
Subject: Geoserver-devel digest, Vol 1 #563 - 8 msgsSend Geoserver-devel mailing list submissions to
geoserver-devel@lists.sourceforge.netTo subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
or, via email, send a message with subject or body 'help' to
geoserver-devel-request@lists.sourceforge.netYou can reach the person managing the list at
geoserver-devel-admin@lists.sourceforge.netWhen replying, please edit your Subject line so it is more
specific than "Re: Contents of Geoserver-devel digest..."Today's Topics:
1. how are unique FID's generated by Geoserver? (Thijs Brentjens)
2. Re: how are unique FID's generated by Geoserver? (Jody Garnett)
3. MySQL and Geoserver (Erie, Edward C.)
4. Re: how are unique FID's generated by Geoserver? (Chris Holmes)
5. Re: MySQL and Geoserver (Chris Holmes)
6. Re: how are unique FID's generated by Geoserver? (David Zwiers)
7. Re: sorting WFS results (David Zwiers)
8. Re: sorting WFS results (Chris Holmes)--__--__--
Message: 1
Date: Fri, 11 Feb 2005 17:17:03 +0100
To: geoserver-devel <geoserver-devel@lists.sourceforge.net>
From: Thijs Brentjens <thijs.brentjens@anonymised.com>
Subject: [Geoserver-devel] how are unique FID's generated by
Geoserver?Hi list,
Maybe this is a pure Geotools issue, but it's also very
related to Geoserver. A year ago, there has been discussion
how Geoserver should acquire the values for fid's when
inserting features (and in that case it was on an Oracle
database). The idea was to have a few options for genration
of fid's (e.g. a sequence is specified in the database, some
trigger is used or use some algorithm that inserts the
max-value), that a user could configure.I can't really find what has been implemented on this, but as
far as I understand from the Geotools sources, the max-value
of all current features is used now to get the next value for
the FID. This resembles a sequence somehow, but in a way it
is dangerous. Because when multiple users send a transaction,
it can cause new fids not to be unique (or is that accounted
for?). However, I also noticed in
org.geotools.data.jdbc.JDBCFeatureWriter
in the fid_exp-stuff (sorry for calling it that way), that
there is some check done if the fid-column is AutoIncrement,
and if so, that a null-value is inserted for the fid, so that
the database generates the value.Can anyone tell me whether this is used by Geoserver (I'm
especially interested how Geoserver deals with this on an
Oracle database)? Because in
org.geotools.data.jdbc.JDBCDataStore.JDBCFeatureWriter, there
still is the method write(), which only checks the max-value....In short, can anyone tell me how Geoserver generates new fids
nowadays?Thanks!
Best regards,
Thijs------------------------------------------------------------
Geodan IT b.v.
President Kennedylaan 1
1079 MB Amsterdam (NL)
------------------------------------------------------------
Tel: +31 (0)20 - 5711 311
Fax: +31 (0)20 - 5711 333
------------------------------------------------------------
E-mail: thijs.brentjens@anonymised.com
Website: www.geodan.nl
Disclaimer: www.geodan.nl/disclaimer
--------------------------------------------------------------__--__--
Message: 2
Date: Fri, 11 Feb 2005 10:19:55 -0800
From: Jody Garnett <jgarnett@anonymised.com>
To: Thijs Brentjens <thijs.brentjens@anonymised.com>
Cc: geoserver-devel <geoserver-devel@lists.sourceforge.net>
Subject: Re: [Geoserver-devel] how are unique FID's generated
by Geoserver?Hi Thijs Brentjens:
This issue has been "solved" in the design of Geotools - and
is available in Geotools 2.1. GoeServer development has just
switched over to 2.1 - I think GeoServer 1.3 when it is
available will be the first to make use of this capability.My project, uDig, is also based on GeoTools 2.1 and have just
been applying some fixes to the Postgis Datastore to make fid
generation (and thus editing) work by default.Cheers,
Jody> Hi list,
>
> Maybe this is a pure Geotools issue, but it's also very related to
> Geoserver. A year ago, there has been discussion how
Geoserver should
> acquire the values for fid's when inserting features (and
in that case
> it was on an Oracle database). The idea was to have a few
options for
> genration of fid's (e.g. a sequence is specified in the
database, some
> trigger is used or use some algorithm that inserts the max-value),
> that a user could configure.
>
> I can't really find what has been implemented on this, but
as far as I
> understand from the Geotools sources, the max-value of all current
> features is used now to get the next value for the FID.
This resembles
> a sequence somehow, but in a way it is dangerous. Because when
> multiple users send a transaction, it can cause new fids not to be
> unique (or is that accounted for?). However, I also noticed in
> org.geotools.data.jdbc.JDBCFeatureWriter in the
fid_exp-stuff (sorry
> for calling it that way), that there is some check done if the
> fid-column is AutoIncrement, and if so, that a null-value
is inserted
> for the fid, so that the database generates the value.
>
> Can anyone tell me whether this is used by Geoserver (I'm
especially
> interested how Geoserver deals with this on an Oracle database)?
> Because in org.geotools.data.jdbc.JDBCDataStore.JDBCFeatureWriter,
> there still is the method write(), which only checks the
max-value....
>
> In short, can anyone tell me how Geoserver generates new
fids nowadays?
>
> Thanks!
>
> Best regards,
> Thijs
>
>
>
>
>
>
> ------------------------------------------------------------
> Geodan IT b.v.
> President Kennedylaan 1
> 1079 MB Amsterdam (NL)
> ------------------------------------------------------------
> Tel: +31 (0)20 - 5711 311
> Fax: +31 (0)20 - 5711 333
> ------------------------------------------------------------
> E-mail: thijs.brentjens@anonymised.com
> Website: www.geodan.nl
> Disclaimer: www.geodan.nl/disclaimer
> ------------------------------------------------------------
>
>
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide Read honest
& candid
> reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start
reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Geoserver-devel mailing list
> Geoserver-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel--__--__--
Message: 3
Date: Fri, 11 Feb 2005 13:42:31 -0500
From: "Erie, Edward C." <edward.erie@anonymised.com>
To: <geoserver-devel@lists.sourceforge.net>
Subject: [Geoserver-devel] MySQL and GeoserverI am having difficulty retrieving data through WMS. I have
set up MySql = as the datastore and have a table called plot.
In this table i have a = column called geo that represents
the interface Geometry. Geoserver is = set up properly and I
can access the data through a GetFeature call to = the WFS.
When i perform the following http call =
http://localhost:8080/geoserver/wms?request=3DGetMap&bbox=3D13
0,75,150,85=
&Format=3Dimage/png&width=3D600&height=3D400&layers=3Dplot&sty
les=3Dnorma=
l i retrieve an empty png file. The geometry data for
column geo are = all points that fall within this bounding
box. I looked at the sql that = was being used by the WMS to
access the geometry data and it was the =
following:SELECT primaryKey, AsText(geo) AS geo FROM plot WHERE
MBRIntersects(geo, = Geometry FromText('POLYGON ((130 75, 130
85, 150 85, 150 75, 130 75))', -1));I noticed that the MBRIntersects method was being used. Is
this = correct? Shouldn't it be using the MBRWithin method?
I re-ran the = query with the MBRWithin method and my results
returned correctly. Any = help would be appreciated!!! =20Thanks
Ed--__--__--
Message: 4
Date: Fri, 11 Feb 2005 15:11:00 -0500 (EST)
From: Chris Holmes <cholmes@anonymised.com>
To: Jody Garnett <jgarnett@anonymised.com>
cc: Thijs Brentjens <thijs.brentjens@anonymised.com>,
geoserver-devel <geoserver-devel@lists.sourceforge.net>
Subject: Re: [Geoserver-devel] how are unique FID's generated
by Geoserver?> Hi Thijs Brentjens:
>
> This issue has been "solved" in the design of Geotools - and is
> available in Geotools 2.1. GoeServer development has just switched
> over to 2.1 - I think GeoServer 1.3 when it is available
will be the
> first to make use of this capability.
Huh? Can you give details on how it is 'solved'? Are you
sure it's not on 2.0? I'm pretty sure all the fid generation
stuff made it in to 2.0.> My project, uDig, is also based on GeoTools 2.1 and have just been
> applying some fixes to the Postgis Datastore to make fid generation
> (and thus editing) work by default.
Thijs is interested in Oracle. Is uDig supporting oracle
jody? And what is the nature of your fixes?Also, I don't think oracle in 2.0 uses the jdbc feature
writer any more.
I think it uses the text feature writer. I'll dig into it
next week to figure out how it's working these days. But I'm
_pretty_ sure that oracle in geoserver does make use of the
auto increment for fid generation if it is available. I
think that may have been one of the reasons I switched over
to a text feature writer (though I could be wrong about that).Chris
>
> Cheers,
> Jody
>
> > Hi list,
> >
> > Maybe this is a pure Geotools issue, but it's also very
related to
> > Geoserver. A year ago, there has been discussion how Geoserver
> > should acquire the values for fid's when inserting
features (and in
> > that case it was on an Oracle database). The idea was to
have a few
> > options for genration of fid's (e.g. a sequence is
specified in the
> > database, some trigger is used or use some algorithm that inserts
> > the max-value), that a user could configure.
> >
> > I can't really find what has been implemented on this,
but as far as
> > I understand from the Geotools sources, the max-value of
all current
> > features is used now to get the next value for the FID. This
> > resembles a sequence somehow, but in a way it is
dangerous. Because
> > when multiple users send a transaction, it can cause new
fids not to
> > be unique (or is that accounted for?). However, I also noticed in
> > org.geotools.data.jdbc.JDBCFeatureWriter in the
fid_exp-stuff (sorry
> > for calling it that way), that there is some check done if the
> > fid-column is AutoIncrement, and if so, that a null-value is
> > inserted for the fid, so that the database generates the value.
> >
> > Can anyone tell me whether this is used by Geoserver (I'm
especially
> > interested how Geoserver deals with this on an Oracle database)?
> > Because in org.geotools.data.jdbc.JDBCDataStore.JDBCFeatureWriter,
> > there still is the method write(), which only checks the
max-value....
> >
> > In short, can anyone tell me how Geoserver generates new
fids nowadays?
> >
> > Thanks!
> >
> > Best regards,
> > Thijs
> >
> >
> >
> >
> >
> >
> > ------------------------------------------------------------
> > Geodan IT b.v.
> > President Kennedylaan 1
> > 1079 MB Amsterdam (NL)
> > ------------------------------------------------------------
> > Tel: +31 (0)20 - 5711 311
> > Fax: +31 (0)20 - 5711 333
> > ------------------------------------------------------------
> > E-mail: thijs.brentjens@anonymised.com
> > Website: www.geodan.nl
> > Disclaimer: www.geodan.nl/disclaimer
> > ------------------------------------------------------------
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide Read
honest & candid
> > reviews on hundreds of IT Products from real users.
> > Discover which products truly live up to the hype. Start
reading now.
> > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> > _______________________________________________
> > Geoserver-devel mailing list
> > Geoserver-devel@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide Read honest
& candid
> reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start
reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Geoserver-devel mailing list
> Geoserver-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>--
--__--__--
Message: 5
Date: Fri, 11 Feb 2005 15:15:51 -0500 (EST)
From: Chris Holmes <cholmes@anonymised.com>
To: "Erie, Edward C." <edward.erie@anonymised.com>
cc: geoserver-devel@lists.sourceforge.net
Subject: Re: [Geoserver-devel] MySQL and GeoserverIt very well could be that the call is wrong. Which is why
MySQL is not included in the standard distribution of
GeoServer, it's a beta download.Are you sure it should be within? I'm happy to change it - I
think I'm the MySQL module maintainer by default, since no
one else has really picked it up. But I have not really
looked into it to make sure the calls are exactly right.
Does a within return a NOT DISJOINT? Because that's what a
bounding box should be. I think a within may miss features
that cross the border of the bounding box, that aren't
completely within.Chris
----- Original Message -----
From: "Erie, Edward C." <edward.erie@anonymised.com>
To: <geoserver-devel@lists.sourceforge.net>
Sent: Friday, February 11, 2005 1:42 PM
Subject: [Geoserver-devel] MySQL and GeoserverI am having difficulty retrieving data through WMS. I have
set up MySql
as the datastore and have a table called plot. In this table
i have a
column called geo that represents the interface Geometry.
Geoserver is
set up properly and I can access the data through a
GetFeature call to the
WFS. When i perform the following http call
http://localhost:8080/geoserver/wms?request=GetMap&bbox=130,75
,150,85&Format=image/png&width=600&height=400&layers=plot&styl
es=normal
i retrieve an empty png file. The geometry data for column
geo are all
points that fall within this bounding box. I looked at the
sql that was
being used by the WMS to access the geometry data and it was the
following:SELECT primaryKey, AsText(geo) AS geo FROM plot WHERE
MBRIntersects(geo,
Geometry
FromText('POLYGON ((130 75, 130 85, 150 85, 150 75, 130 75))', -1));I noticed that the MBRIntersects method was being used. Is
this correct?
Shouldn't it be using the MBRWithin method? I re-ran the
query with the
MBRWithin method and my results returned correctly. Any help
would be
appreciated!!!Thanks
Ed--
--__--__--
Message: 6
Subject: Re: [Geoserver-devel] how are unique FID's generated
by Geoserver?
From: David Zwiers <dzwiers@anonymised.com>
To: Chris Holmes <cholmes@anonymised.com>
Cc: Jody Garnett <jgarnett@anonymised.com>,
Thijs Brentjens <thijs.brentjens@anonymised.com>,
geoserver-devel <geoserver-devel@lists.sourceforge.net>
Date: Fri, 11 Feb 2005 12:27:22 -0800Chris, Thijs,
Jesse and Jody were working on this. From what I can gather, the
FidMappers for the specific datastores were not always being used ...
basically they forced the datastore's version to be used if
it existed.
This work was all completed in context with PostGis.Oracle is one of the datastores we intend to make use of in
the future,
but unfortunately it will not be part of our next release as this has
not yet been tested in uDig.David
On Fri, 2005-02-11 at 12:11, Chris Holmes wrote:
> > Hi Thijs Brentjens:
> >
> > This issue has been "solved" in the design of Geotools - and is
> > available in Geotools 2.1. GoeServer development has just
switched over
> > to 2.1 - I think GeoServer 1.3 when it is available will
be the first to
> > make use of this capability.
> Huh? Can you give details on how it is 'solved'? Are you
sure it's not
> on 2.0? I'm pretty sure all the fid generation stuff made
it in to 2.0.
>
> > My project, uDig, is also based on GeoTools 2.1 and have
just been
> > applying some fixes to the Postgis Datastore to make fid
generation (and
> > thus editing) work by default.
> Thijs is interested in Oracle. Is uDig supporting oracle
jody? And what
> is the nature of your fixes?
>
> Also, I don't think oracle in 2.0 uses the jdbc feature
writer any more.
> I think it uses the text feature writer. I'll dig into it
next week to
> figure out how it's working these days. But I'm _pretty_
sure that oracle
> in geoserver does make use of the auto increment for fid
generation if it
> is available. I think that may have been one of the
reasons I switched
> over to a text feature writer (though I could be wrong about that).
>
> Chris
>
> >
> > Cheers,
> > Jody
> >
> > > Hi list,
> > >
> > > Maybe this is a pure Geotools issue, but it's also very
related to
> > > Geoserver. A year ago, there has been discussion how
Geoserver should
> > > acquire the values for fid's when inserting features
(and in that case
> > > it was on an Oracle database). The idea was to have a
few options for
> > > genration of fid's (e.g. a sequence is specified in the
database, some
> > > trigger is used or use some algorithm that inserts the
max-value),
> > > that a user could configure.
> > >
> > > I can't really find what has been implemented on this,
but as far as I
> > > understand from the Geotools sources, the max-value of
all current
> > > features is used now to get the next value for the FID.
This resembles
> > > a sequence somehow, but in a way it is dangerous. Because when
> > > multiple users send a transaction, it can cause new
fids not to be
> > > unique (or is that accounted for?). However, I also noticed in
> > > org.geotools.data.jdbc.JDBCFeatureWriter in the
fid_exp-stuff (sorry
> > > for calling it that way), that there is some check done if the
> > > fid-column is AutoIncrement, and if so, that a
null-value is inserted
> > > for the fid, so that the database generates the value.
> > >
> > > Can anyone tell me whether this is used by Geoserver
(I'm especially
> > > interested how Geoserver deals with this on an Oracle
database)?
> > > Because in
org.geotools.data.jdbc.JDBCDataStore.JDBCFeatureWriter,
> > > there still is the method write(), which only checks
the max-value....
> > >
> > > In short, can anyone tell me how Geoserver generates
new fids nowadays?
> > >
> > > Thanks!
> > >
> > > Best regards,
> > > Thijs
> > >
> > >
> > >
> > >
> > >
> > >
> > > ------------------------------------------------------------
> > > Geodan IT b.v.
> > > President Kennedylaan 1
> > > 1079 MB Amsterdam (NL)
> > > ------------------------------------------------------------
> > > Tel: +31 (0)20 - 5711 311
> > > Fax: +31 (0)20 - 5711 333
> > > ------------------------------------------------------------
> > > E-mail: thijs.brentjens@anonymised.com
> > > Website: www.geodan.nl
> > > Disclaimer: www.geodan.nl/disclaimer
> > > ------------------------------------------------------------
> > >
> > >
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > SF email is sponsored by - The IT Product Guide
> > > Read honest & candid reviews on hundreds of IT Products
from real users.
> > > Discover which products truly live up to the hype.
Start reading now.
> > > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> > > _______________________________________________
> > > Geoserver-devel mailing list
> > > Geoserver-devel@lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/geoserver-devel
> >
> >
> >
> >
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products
from real users.
> > Discover which products truly live up to the hype. Start
reading now.
> > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> > _______________________________________________
> > Geoserver-devel mailing list
> > Geoserver-devel@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/geoserver-devel
> >--__--__--
Message: 7
Subject: Re: [Geoserver-devel] sorting WFS results
From: David Zwiers <dzwiers@anonymised.com>
To: Chris Holmes <cholmes@anonymised.com>
Cc: Norman Barker <normanb@anonymised.com>,
geoserver-devel@lists.sourceforge.net
Date: Fri, 11 Feb 2005 12:32:38 -0800The WFS 1.1 spec is not yet released, and is still under revisions. It
currently has GML 3.0 Level 0 (SFS for gml) and the Filter 1.1 spec as
the major changes.The Filter 1.1 spec is really just an extension from what I could see
(only looked it over briefly). They added a couple operands, one of
which was SortBy.I wouldn't recommend that Geoserver goes into GML 3.0 Level 0, as GML
3.0 is outdated, and would likely we replaced with a 3.1.1
version very
shortly after.The Filter additions would be relatively simple, and map very
closely to
simple SQL statements ... we would just have to add the Interfaces to
GT. The only issues for SortBy come when your data isn't in a DB (Shp,
GML) where this would have to occur in memory ... so something smart
would have to occur there.David
Sorry for the brain dump ... just a couple thoughts
On Thu, 2005-02-10 at 14:19, Chris Holmes wrote:
> > Norman, Chris,
> >
> > Sorting is part of the Filter 1.1, and WFS 1.1
specifications which have
> > been approved/proposed by the OGC. This is not currently
supported by
> > Geoserver, but would be a great addition.
> Cool, let's definitely do it. I have not yet seen the new
specs, but
> we should do what we can to get them implemented relatively
soon. Is
> there anything that looked very hard in them?
>
> Chris
>
> >
> > This would be a fairly easy addition after converting to
the new XML
> > framework in Geotools.
> >
> > David
> >
> > On Thu, 2005-02-10 at 09:29, Chris Holmes wrote:
> > > > Hi,
> > > >
> > > > we have set up GeoServer here in the UK and have
connected it to a MySQL
> > > > spatial database.
> > > >
> > > > The problem we have is that we would like to sort the
results returned
> > > > by the WFS by date,lat,lon, currently they don't come
back in a sorted
> > > > order. Has anyone got around this? I appreciate
sorting is part of the
> > > > WFS spec, but it would be a nice to have!
> > >
> > > I have not heard anyone request this before, but I
don't think it would be
> > > that hard to do. We could add a vendor specific
'orderby' param, and pass
> > > that off as a hint in the GeoTools query - datastores
that could handle it
> > > could turn it into sql.
> > >
> > > You can go ahead and submit it to the JIRA task tracker
(there are
> > > instructions in the documentation), and someone might
eventually get to
> > > it. If you can do Java programming I can point you in
the right
> > > direction, or we can find someone who you could pay to
implement it. I
> > > don't think it would take more than a day or two to do.
> > >
> > > >
> > > > Many thanks,
> > > >
> > > > Norman Barker
> > > >
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > SF email is sponsored by - The IT Product Guide
> > > > Read honest & candid reviews on hundreds of IT
Products from real users.
> > > > Discover which products truly live up to the hype.
Start reading now.
> > > > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> > > > _______________________________________________
> > > > Geoserver-devel mailing list
> > > > Geoserver-devel@lists.sourceforge.net
> > > > https://lists.sourceforge.net/lists/listinfo/geoserver-devel
> > > >
> >
> >
> >
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products
from real users.
> > Discover which products truly live up to the hype. Start
reading now.
> > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> > _______________________________________________
> > Geoserver-devel mailing list
> > Geoserver-devel@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/geoserver-devel
> >--__--__--
Message: 8
Date: Fri, 11 Feb 2005 15:41:29 -0500 (EST)
From: Chris Holmes <cholmes@anonymised.com>
To: David Zwiers <dzwiers@anonymised.com>
cc: Norman Barker <normanb@anonymised.com>,
<geoserver-devel@lists.sourceforge.net>
Subject: Re: [Geoserver-devel] sorting WFS results> The WFS 1.1 spec is not yet released, and is still under
revisions. It
> currently has GML 3.0 Level 0 (SFS for gml) and the Filter
1.1 spec as
> the major changes.
You sure? The ogc newsletter:
http://www.opengeospatial.org/press/?page=newsletterr#D1 says
that they
were approved in nyc with an electronic vote, and would be
released soon.> The Filter 1.1 spec is really just an extension from what I
could see
> (only looked it over briefly). They added a couple operands, one of
> which was SortBy.
>
> I wouldn't recommend that Geoserver goes into GML 3.0 Level
0, as GML
> 3.0 is outdated, and would likely we replaced with a 3.1.1
version very
> shortly after.
Well are the 3.1.1 improvements relevant for Level 0? If
they aren't then
we might not have to change anything. And generating 3.0
Level 0 should
be pretty trivial I think, just a few names change vs. 2.1> The Filter additions would be relatively simple, and map
very closely to
> simple SQL statements ... we would just have to add the
Interfaces to
> GT. The only issues for SortBy come when your data isn't in
a DB (Shp,
> GML) where this would have to occur in memory ... so something smart
> would have to occur there.
I'd say to start just throw an exception, we can figure out
the smarts
later - like when we have an embedded spatial db to dump the
stuff into
and cache the non-db datastores.Chris
>
> David
>
> Sorry for the brain dump ... just a couple thoughts
>
> On Thu, 2005-02-10 at 14:19, Chris Holmes wrote:
> > > Norman, Chris,
> > >
> > > Sorting is part of the Filter 1.1, and WFS 1.1
specifications which have
> > > been approved/proposed by the OGC. This is not
currently supported by
> > > Geoserver, but would be a great addition.
> > Cool, let's definitely do it. I have not yet seen the
new specs, but
> > we should do what we can to get them implemented
relatively soon. Is
> > there anything that looked very hard in them?
> >
> > Chris
> >
> > >
> > > This would be a fairly easy addition after converting
to the new XML
> > > framework in Geotools.
> > >
> > > David
> > >
> > > On Thu, 2005-02-10 at 09:29, Chris Holmes wrote:
> > > > > Hi,
> > > > >
> > > > > we have set up GeoServer here in the UK and have
connected it to a MySQL
> > > > > spatial database.
> > > > >
> > > > > The problem we have is that we would like to sort
the results returned
> > > > > by the WFS by date,lat,lon, currently they don't
come back in a sorted
> > > > > order. Has anyone got around this? I appreciate
sorting is part of the
> > > > > WFS spec, but it would be a nice to have!
> > > >
> > > > I have not heard anyone request this before, but I
don't think it would be
> > > > that hard to do. We could add a vendor specific
'orderby' param, and pass
> > > > that off as a hint in the GeoTools query - datastores
that could handle it
> > > > could turn it into sql.
> > > >
> > > > You can go ahead and submit it to the JIRA task
tracker (there are
> > > > instructions in the documentation), and someone might
eventually get to
> > > > it. If you can do Java programming I can point you
in the right
> > > > direction, or we can find someone who you could pay
to implement it. I
> > > > don't think it would take more than a day or two to do.
> > > >
> > > > >
> > > > > Many thanks,
> > > > >
> > > > > Norman Barker
> > > > >
> > > > >
> > > > >
> > > > > -------------------------------------------------------
> > > > > SF email is sponsored by - The IT Product Guide
> > > > > Read honest & candid reviews on hundreds of IT
Products from real users.
> > > > > Discover which products truly live up to the hype.
Start reading now.
> > > > > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> > > > > _______________________________________________
> > > > > Geoserver-devel mailing list
> > > > > Geoserver-devel@lists.sourceforge.net
> > > > > https://lists.sourceforge.net/lists/listinfo/geoserver-devel
> > > > >
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > SF email is sponsored by - The IT Product Guide
> > > Read honest & candid reviews on hundreds of IT Products
from real users.
> > > Discover which products truly live up to the hype.
Start reading now.
> > > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> > > _______________________________________________
> > > Geoserver-devel mailing list
> > > Geoserver-devel@lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/geoserver-devel
> > >
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products
from real users.
> Discover which products truly live up to the hype. Start
reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Geoserver-devel mailing list
> Geoserver-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>--
--__--__--
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-develEnd of Geoserver-devel Digest