[Geoserver-users] follow-up on failing BBOX filter on ArcSDE

GeoServer GeoServer User
1

Hi list,

does anyone know if there was any follow-up on the issue raised here:

http://opensource-archive.org/showthread.php?p=30279

?

TIA.

Best regards,
Bart

2

Hi Bart,

could you open a jira for this for the arcsde module? it seems I missed the
discussion on the users list and wasn't aware of this.

best regards,
Gabriel
On Monday 24 November 2008 10:29:09 bartvde@anonymised.com wrote:

Hi list,

does anyone know if there was any follow-up on the issue raised here:

http://opensource-archive.org/showthread.php?p=30279

?

TIA.

Best regards,
Bart

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge Build the coolest Linux based applications with Moblin SDK & win
great prizes Grand prize is a trip for two to an Open Source event anywhere
in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

3

Hi Gabriel,

done, see:

http://jira.codehaus.org/browse/GEOS-2453

Best regards,
Bart

Hi Bart,

could you open a jira for this for the arcsde module? it seems I missed
the
discussion on the users list and wasn't aware of this.

best regards,
Gabriel
On Monday 24 November 2008 10:29:09 bartvde@anonymised.com wrote:

Hi list,

does anyone know if there was any follow-up on the issue raised here:

http://opensource-archive.org/showthread.php?p=30279

?

TIA.

Best regards,
Bart

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge Build the coolest Linux based applications with Moblin SDK &
win
great prizes Grand prize is a trip for two to an Open Source event
anywhere
in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

4

Hej

To my knowledge, ArcSDE is the only datastore that supports several spatial columns in the same DB table.
When defining an ArcSDE layer, the spatial column to be used must be named and is stored in the layer definition in the SDE LAYERS table.
This may be the reason, depending on how GeoTools is accessing the ArcSDE layer.

Best Regards


Andreas Oxenstierna

Telefon direkt 040-16 70 17
Mobil 0734-12 80 17
andreas.oxenstierna@anonymised.com
SWECO Position AB

Hans Michelsensgatan 2
Box 286
201 22 Malmö
Telefon 040-16 70 00
www.sweco.se






-----Ursprungligt meddelande-----
Från: bartvde@anonymised.com [mailto:bartvde@anonymised.com]
Skickat: den 27 november 2008 13:31
Till: Gabriel Roldán
Kopia: geoserver-users@lists.sourceforge.net; JECHEVE@anonymised.com
Ämne: Re: [Geoserver-users] follow-up on failing BBOX filter on ArcSDE

Hi Gabriel,

done, see:

http://jira.codehaus.org/browse/GEOS-2453

Best regards,
Bart

Hi Bart,

could you open a jira for this for the arcsde module? it seems I
missed the discussion on the users list and wasn’t aware of this.

best regards,
Gabriel
On Monday 24 November 2008 10:29:09 bartvde@anonymised.com wrote:

Hi list,

does anyone know if there was any follow-up on the issue raised here:

http://opensource-archive.org/showthread.php?p=30279

?

TIA.

Best regards,
Bart

---- This SF.Net email is sponsored by the Moblin Your Move
Developer’s challenge Build the coolest Linux based applications with
Moblin SDK & win great prizes Grand prize is a trip for two to an
Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

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

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

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

5

PostGIS supports multiple spatial columns too afaik.
I guess the thing to do is that if a property name is not specified the
bounding box should be applied to all geometry columns?

Gabriel

On Thursday 27 November 2008 10:54:36 Oxenstierna Andreas wrote:

Hej

To my knowledge, ArcSDE is the only datastore that supports several spatial
columns in the same DB table. When defining an ArcSDE layer, the spatial
column to be used must be named and is stored in the layer definition in
the SDE LAYERS table. This may be the reason, depending on how GeoTools is
accessing the ArcSDE layer.

Best Regards

________________________________

Andreas Oxenstierna

Telefon direkt 040-16 70 17
Mobil 0734-12 80 17
andreas.oxenstierna@anonymised.com
SWECO Position AB

Hans Michelsensgatan 2
Box 286
201 22 Malmö
Telefon 040-16 70 00
www.sweco.se

-----Ursprungligt meddelande-----
Från: bartvde@anonymised.com [mailto:bartvde@anonymised.com]
Skickat: den 27 november 2008 13:31
Till: Gabriel Roldán
Kopia: geoserver-users@lists.sourceforge.net; JECHEVE@anonymised.com
Ämne: Re: [Geoserver-users] follow-up on failing BBOX filter on ArcSDE

Hi Gabriel,

done, see:

http://jira.codehaus.org/browse/GEOS-2453

Best regards,
Bart

> Hi Bart,
>
> could you open a jira for this for the arcsde module? it seems I
> missed the discussion on the users list and wasn't aware of this.
>
> best regards,
> Gabriel
>
> On Monday 24 November 2008 10:29:09 bartvde@anonymised.com wrote:
>> Hi list,
>>
>> does anyone know if there was any follow-up on the issue raised here:
>>
>> http://opensource-archive.org/showthread.php?p=30279
>>
>> ?
>>
>> TIA.
>>
>> Best regards,
>> Bart
>>
>>
>> ---------------------------------------------------------------------
>> ---- This SF.Net email is sponsored by the Moblin Your Move
>> Developer's challenge Build the coolest Linux based applications with
>> Moblin SDK & win great prizes Grand prize is a trip for two to an
>> Open Source event anywhere in the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> Geoserver-users mailing list
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge Build the coolest Linux based applications with Moblin SDK & win
great prizes Grand prize is a trip for two to an Open Source event anywhere
in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

6

Guess not. The ArcSDE layer is defined as

,. You may check all columns and/or the SDE LAYERS table for all ArcSDE layers using the specified table and which spatial columns that are used.
However, ArcSDE layers should be read from the SDE LAYERS table, and there you can find the spatial column to use (in the column SPATIAL_COLUMN), together with other needed information like SRS.

Best regards


Andreas Oxenstierna

Telefon direkt 040-16 70 17
Mobil 0734-12 80 17
andreas.oxenstierna@anonymised.com
SWECO Position AB

Hans Michelsensgatan 2
Box 286
201 22 Malmö
Telefon 040-16 70 00
www.sweco.se






-----Ursprungligt meddelande-----
Från: Gabriel Roldán [mailto:groldan@anonymised.com]
Skickat: den 27 november 2008 14:13
Till: Oxenstierna Andreas
Kopia: bartvde@anonymised.com; geoserver-users@lists.sourceforge.net; JECHEVE@anonymised.com
Ämne: Re: SV: [Geoserver-users] follow-up on failing BBOX filter on ArcSDE

PostGIS supports multiple spatial columns too afaik.
I guess the thing to do is that if a property name is not specified the bounding box should be applied to all geometry columns?

Gabriel

On Thursday 27 November 2008 10:54:36 Oxenstierna Andreas wrote:

Hej

To my knowledge, ArcSDE is the only datastore that supports several
spatial columns in the same DB table. When defining an ArcSDE layer,
the spatial column to be used must be named and is stored in the layer
definition in the SDE LAYERS table. This may be the reason, depending
on how GeoTools is accessing the ArcSDE layer.

Best Regards

Andreas Oxenstierna

Telefon direkt 040-16 70 17
Mobil 0734-12 80 17
andreas.oxenstierna@anonymised.com
SWECO Position AB

Hans Michelsensgatan 2
Box 286
201 22 Malmö
Telefon 040-16 70 00
www.sweco.se

-----Ursprungligt meddelande-----
Från: bartvde@anonymised.com [mailto:bartvde@anonymised.com]
Skickat: den 27 november 2008 13:31
Till: Gabriel Roldán
Kopia: geoserver-users@lists.sourceforge.net; JECHEVE@anonymised.com
Ämne: Re: [Geoserver-users] follow-up on failing BBOX filter on ArcSDE

Hi Gabriel,

done, see:

http://jira.codehaus.org/browse/GEOS-2453

Best regards,
Bart

Hi Bart,

could you open a jira for this for the arcsde module? it seems I
missed the discussion on the users list and wasn’t aware of this.

best regards,
Gabriel

On Monday 24 November 2008 10:29:09 bartvde@anonymised.com wrote:

Hi list,

does anyone know if there was any follow-up on the issue raised here:

http://opensource-archive.org/showthread.php?p=30279

?

TIA.

Best regards,
Bart

–
---- This SF.Net email is sponsored by the Moblin Your Move
Developer’s challenge Build the coolest Linux based applications
with Moblin SDK & win great prizes Grand prize is a trip for two to
an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

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

— This SF.Net email is sponsored by the Moblin Your Move Developer’s
challenge Build the coolest Linux based applications with Moblin SDK &
win great prizes Grand prize is a trip for two to an Open Source event
anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

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

7

Oxenstierna Andreas ha scritto:

Hej
To my knowledge, ArcSDE is the only datastore that supports several spatial columns in the same DB table.

Nope, all jdbc databases support multiple geom columns. But they don't
allow you to define the default one, if you want to use the others
in WMS you have to ask about them explicitly in the SLD or to
in the bbox filter (and thus make a POST request, you're right
it does not work for a GET one).

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

8

In my understanding a single sde layer can hold more than one spatial column.
It's just that it won't wor with, eg. ArcMap, but certainly do with the Java
and C APIs.

On Thursday 27 November 2008 11:19:59 Oxenstierna Andreas wrote:

Guess not. The ArcSDE layer is defined as <table>,<spatial column>. You may
check all columns and/or the SDE LAYERS table for all ArcSDE layers using
the specified table and which spatial columns that are used. However,
ArcSDE layers should be read from the SDE LAYERS table, and there you can
find the spatial column to use (in the column SPATIAL_COLUMN), together
with other needed information like SRS.

We're using the ArcSDE Java API to hit an ArcSDE server, no direct connection
to the database, so we don't have access to the sde_layers table, but the sde
gateway does. We can just ask the SeLayer instance about its spatial columns,
if I'm not missing something.

Gabriel

Best regards

________________________________

Andreas Oxenstierna

Telefon direkt 040-16 70 17
Mobil 0734-12 80 17
andreas.oxenstierna@anonymised.com
SWECO Position AB

Hans Michelsensgatan 2
Box 286
201 22 Malmö
Telefon 040-16 70 00
www.sweco.se

-----Ursprungligt meddelande-----
Från: Gabriel Roldán [mailto:groldan@anonymised.com]
Skickat: den 27 november 2008 14:13
Till: Oxenstierna Andreas
Kopia: bartvde@anonymised.com; geoserver-users@lists.sourceforge.net;
JECHEVE@anonymised.com Ämne: Re: SV: [Geoserver-users] follow-up on failing
BBOX filter on ArcSDE

PostGIS supports multiple spatial columns too afaik.
I guess the thing to do is that if a property name is not specified the
bounding box should be applied to all geometry columns?

Gabriel

On Thursday 27 November 2008 10:54:36 Oxenstierna Andreas wrote:
> Hej
>
> To my knowledge, ArcSDE is the only datastore that supports several
> spatial columns in the same DB table. When defining an ArcSDE layer,
> the spatial column to be used must be named and is stored in the layer
> definition in the SDE LAYERS table. This may be the reason, depending
> on how GeoTools is accessing the ArcSDE layer.
>
> Best Regards
>
> ________________________________
>
> Andreas Oxenstierna
>
> Telefon direkt 040-16 70 17
> Mobil 0734-12 80 17
> andreas.oxenstierna@anonymised.com
> SWECO Position AB
>
> Hans Michelsensgatan 2
> Box 286
> 201 22 Malmö
> Telefon 040-16 70 00
> www.sweco.se
>
>
>
>
>
>
>
>
> -----Ursprungligt meddelande-----
> Från: bartvde@anonymised.com [mailto:bartvde@anonymised.com]
> Skickat: den 27 november 2008 13:31
> Till: Gabriel Roldán
> Kopia: geoserver-users@lists.sourceforge.net; JECHEVE@anonymised.com
> Ämne: Re: [Geoserver-users] follow-up on failing BBOX filter on ArcSDE
>
> Hi Gabriel,
>
> done, see:
>
> http://jira.codehaus.org/browse/GEOS-2453
>
> Best regards,
> Bart
>
> > Hi Bart,
> >
> > could you open a jira for this for the arcsde module? it seems I
> > missed the discussion on the users list and wasn't aware of this.
> >
> > best regards,
> > Gabriel
> >
> > On Monday 24 November 2008 10:29:09 bartvde@anonymised.com wrote:
> >> Hi list,
> >>
> >> does anyone know if there was any follow-up on the issue raised here:
> >>
> >> http://opensource-archive.org/showthread.php?p=30279
> >>
> >> ?
> >>
> >> TIA.
> >>
> >> Best regards,
> >> Bart
> >>
> >>
> >> -------------------------------------------------------------------
> >> --
> >> ---- This SF.Net email is sponsored by the Moblin Your Move
> >> Developer's challenge Build the coolest Linux based applications
> >> with Moblin SDK & win great prizes Grand prize is a trip for two to
> >> an Open Source event anywhere in the world
> >> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> >> _______________________________________________
> >> Geoserver-users mailing list
> >> Geoserver-users@lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
> ----------------------------------------------------------------------
> --- This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge Build the coolest Linux based applications with Moblin SDK &
> win great prizes Grand prize is a trip for two to an Open Source event
> anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

9

Andrea so what JDBC backed datastores do upon a bbox filter with no attribute
set? do they filter by all the spatial cols or just the default one? (wonder
since at least in theory the different spatial cols may be in different CRS's
meaning and extra step to transform the CRS to the column's native one before
issueing the request)

On Thursday 27 November 2008 11:28:40 Andrea Aime wrote:

Oxenstierna Andreas ha scritto:
> Hej
>
> To my knowledge, ArcSDE is the only datastore that supports several
> spatial columns in the same DB table.

Nope, all jdbc databases support multiple geom columns. But they don't
allow you to define the default one, if you want to use the others
in WMS you have to ask about them explicitly in the SLD or to
in the bbox filter (and thus make a POST request, you're right
it does not work for a GET one).

Cheers
Andrea

10

Gabriel Roldán ha scritto:

Andrea so what JDBC backed datastores do upon a bbox filter with no attribute set? do they filter by all the spatial cols or just the default one? (wonder since at least in theory the different spatial cols may be in different CRS's meaning and extra step to transform the CRS to the column's native one before issueing the request)

We use the default geometry only as far as I remember.
Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

11

With the sde commands you define an ArcSDE layer with one specific spatial column, SRS, spatial index etc. So you can define several ArcSDE layers on the same table, with different or the same spatial columns. I do not remember how SeLayer exposes this.

Yes, ArcGIS (ArcObjects / Geodatabase) does not support this. The APIs (including ArcInfo workstation) supports it, as far I am aware of.

Andreas

-----Ursprungligt meddelande-----
Från: Gabriel Roldán [mailto:groldan@anonymised.com]
Skickat: den 27 november 2008 14:35
Till: Oxenstierna Andreas
Kopia: bartvde@anonymised.com; geoserver-users@lists.sourceforge.net; JECHEVE@anonymised.com
Ämne: Re: SV: SV: [Geoserver-users] follow-up on failing BBOX filter on ArcSDE

In my understanding a single sde layer can hold more than one spatial column.
It’s just that it won’t wor with, eg. ArcMap, but certainly do with the Java and C APIs.

On Thursday 27 November 2008 11:19:59 Oxenstierna Andreas wrote:

Guess not. The ArcSDE layer is defined as

,.
You may check all columns and/or the SDE LAYERS table for all ArcSDE
layers using the specified table and which spatial columns that are
used. However, ArcSDE layers should be read from the SDE LAYERS table,
and there you can find the spatial column to use (in the column
SPATIAL_COLUMN), together with other needed information like SRS.
We’re using the ArcSDE Java API to hit an ArcSDE server, no direct connection to the database, so we don’t have access to the sde_layers table, but the sde gateway does. We can just ask the SeLayer instance about its spatial columns, if I’m not missing something.

Gabriel

Best regards

Andreas Oxenstierna

Telefon direkt 040-16 70 17
Mobil 0734-12 80 17
andreas.oxenstierna@anonymised.com
SWECO Position AB

Hans Michelsensgatan 2
Box 286
201 22 Malmö
Telefon 040-16 70 00
www.sweco.se

-----Ursprungligt meddelande-----
Från: Gabriel Roldán [mailto:groldan@anonymised.com]
Skickat: den 27 november 2008 14:13
Till: Oxenstierna Andreas
Kopia: bartvde@anonymised.com; geoserver-users@lists.sourceforge.net;
JECHEVE@anonymised.com Ämne: Re: SV: [Geoserver-users] follow-up on
failing BBOX filter on ArcSDE

PostGIS supports multiple spatial columns too afaik.
I guess the thing to do is that if a property name is not specified
the bounding box should be applied to all geometry columns?

Gabriel

On Thursday 27 November 2008 10:54:36 Oxenstierna Andreas wrote:

Hej

To my knowledge, ArcSDE is the only datastore that supports several
spatial columns in the same DB table. When defining an ArcSDE layer,
the spatial column to be used must be named and is stored in the
layer definition in the SDE LAYERS table. This may be the reason,
depending on how GeoTools is accessing the ArcSDE layer.

Best Regards

Andreas Oxenstierna

Telefon direkt 040-16 70 17
Mobil 0734-12 80 17
andreas.oxenstierna@anonymised.com
SWECO Position AB

Hans Michelsensgatan 2
Box 286
201 22 Malmö
Telefon 040-16 70 00
www.sweco.se

-----Ursprungligt meddelande-----
Från: bartvde@anonymised.com [mailto:bartvde@anonymised.com]
Skickat: den 27 november 2008 13:31
Till: Gabriel Roldán
Kopia: geoserver-users@lists.sourceforge.net; JECHEVE@anonymised.com
Ämne: Re: [Geoserver-users] follow-up on failing BBOX filter on
ArcSDE

Hi Gabriel,

done, see:

http://jira.codehaus.org/browse/GEOS-2453

Best regards,
Bart

Hi Bart,

could you open a jira for this for the arcsde module? it seems I
missed the discussion on the users list and wasn’t aware of this.

best regards,
Gabriel

On Monday 24 November 2008 10:29:09 bartvde@anonymised.com wrote:

Hi list,

does anyone know if there was any follow-up on the issue raised here:

http://opensource-archive.org/showthread.php?p=30279

?

TIA.

Best regards,
Bart

–

---- This SF.Net email is sponsored by the Moblin Your Move
Developer’s challenge Build the coolest Linux based applications
with Moblin SDK & win great prizes Grand prize is a trip for two
to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

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

–
— This SF.Net email is sponsored by the Moblin Your Move
Developer’s challenge Build the coolest Linux based applications
with Moblin SDK & win great prizes Grand prize is a trip for two to
an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

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

12

Hi Bart,
the issue is fixed on trunk and 1.7.x

Best regards,

Gabriel

On Thursday 27 November 2008 10:30:30 bartvde@anonymised.com wrote:

Hi Gabriel,

done, see:

http://jira.codehaus.org/browse/GEOS-2453

Best regards,
Bart

> Hi Bart,
>
> could you open a jira for this for the arcsde module? it seems I missed
> the
> discussion on the users list and wasn't aware of this.
>
> best regards,
> Gabriel
>
> On Monday 24 November 2008 10:29:09 bartvde@anonymised.com wrote:
>> Hi list,
>>
>> does anyone know if there was any follow-up on the issue raised here:
>>
>> http://opensource-archive.org/showthread.php?p=30279
>>
>> ?
>>
>> TIA.
>>
>> Best regards,
>> Bart
>>
>>
>> ------------------------------------------------------------------------
>>- This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge Build the coolest Linux based applications with Moblin SDK &
>> win
>> great prizes Grand prize is a trip for two to an Open Source event
>> anywhere
>> in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> Geoserver-users mailing list
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users