FDO spatial query

4 messages Options
Embed this post
Permalink
bebeto

FDO spatial query

Reply Threaded More More options
Print post
Permalink
hi, I need to create FDO query to return set of points in specific order.
To explain problem easiest way - imagine you have predefined route (line) and want to return list gas stations (points) along that route with nearest first.

Only solution I was able to create was FDO_SELECT command with SpatialOperations.SpatialOperations_Intersects filter
(usually they are in some short distance to this line, but make it simplier and assume points are exactly on line)
collection of points returned was ok, but in random order.

Any ideas (even with different technology like FDO) how to solve this are welcome. My goal is to manage geometry only with using some library and do not write complex algorithms dealing with different geom. types like linestring curvestring etc.
Dan Stoica

RE: FDO spatial query

Reply Threaded More More options
Print post
Permalink
The short answer is: no, you cannot solve the problem without post processing the points.

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of bebeto
Sent: Monday, March 09, 2009 1:00 PM
To: [hidden email]
Subject: [fdo-users] FDO spatial query


hi, I need to create FDO query to return set of points in specific order.
To explain problem easiest way - imagine you have predefined route (line)
and want to return list gas stations (points) along that route with nearest
first.

Only solution I was able to create was FDO_SELECT command with
SpatialOperations.SpatialOperations_Intersects filter
(usually they are in some short distance to this line, but make it simplier
and assume points are exactly on line)
collection of points returned was ok, but in random order.

Any ideas (even with different technology like FDO) how to solve this are
welcome. My goal is to manage geometry only with using some library and do
not write complex algorithms dealing with different geom. types like
linestring curvestring etc.
--
View this message in context: http://n2.nabble.com/FDO-spatial-query-tp2450209p2450209.html
Sent from the FDO Users mailing list archive at Nabble.com.

_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
bebeto

RE: FDO spatial query

Reply Threaded More More options
Print post
Permalink
And any idea for some library which can do such postprocessing? Have checked JTS suite but does not support curvestrings :(

Dan Stoica wrote:
The short answer is: no, you cannot solve the problem without post processing the points.

-----Original Message-----
From: fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] On Behalf Of bebeto
Sent: Monday, March 09, 2009 1:00 PM
To: fdo-users@lists.osgeo.org
Subject: [fdo-users] FDO spatial query


hi, I need to create FDO query to return set of points in specific order.
To explain problem easiest way - imagine you have predefined route (line)
and want to return list gas stations (points) along that route with nearest
first.

Only solution I was able to create was FDO_SELECT command with
SpatialOperations.SpatialOperations_Intersects filter
(usually they are in some short distance to this line, but make it simplier
and assume points are exactly on line)
collection of points returned was ok, but in random order.

Any ideas (even with different technology like FDO) how to solve this are
welcome. My goal is to manage geometry only with using some library and do
not write complex algorithms dealing with different geom. types like
linestring curvestring etc.
--
View this message in context: http://n2.nabble.com/FDO-spatial-query-tp2450209p2450209.html
Sent from the FDO Users mailing list archive at Nabble.com.

_______________________________________________
fdo-users mailing list
fdo-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
fdo-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users
Dan Stoica

RE: FDO spatial query

Reply Threaded More More options
Print post
Permalink
I'm not aware of such library. But it's quite easy to write some code to do this. E.g, for points, something like this:

Define a structure myPt={featid, x, y, x0, y0} where (x0,y0) is your point of reference.
- execute the spatial query and save the points into myPt items.
- sort the list of myPts by distance between (x,y) and (x0,y0).


-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of bebeto
Sent: Tuesday, March 10, 2009 5:23 AM
To: [hidden email]
Subject: RE: [fdo-users] FDO spatial query


And any idea for some library which can do such postprocessing? Have checked
JTS suite but does not support curvestrings :(


Dan Stoica wrote:

>
> The short answer is: no, you cannot solve the problem without post
> processing the points.
>
> -----Original Message-----
> From: [hidden email]
> [mailto:[hidden email]] On Behalf Of bebeto
> Sent: Monday, March 09, 2009 1:00 PM
> To: [hidden email]
> Subject: [fdo-users] FDO spatial query
>
>
> hi, I need to create FDO query to return set of points in specific order.
> To explain problem easiest way - imagine you have predefined route (line)
> and want to return list gas stations (points) along that route with
> nearest
> first.
>
> Only solution I was able to create was FDO_SELECT command with
> SpatialOperations.SpatialOperations_Intersects filter
> (usually they are in some short distance to this line, but make it
> simplier
> and assume points are exactly on line)
> collection of points returned was ok, but in random order.
>
> Any ideas (even with different technology like FDO) how to solve this are
> welcome. My goal is to manage geometry only with using some library and do
> not write complex algorithms dealing with different geom. types like
> linestring curvestring etc.
> --
> View this message in context:
> http://n2.nabble.com/FDO-spatial-query-tp2450209p2450209.html
> Sent from the FDO Users mailing list archive at Nabble.com.
>
> _______________________________________________
> fdo-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> _______________________________________________
> fdo-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
>

--
View this message in context: http://n2.nabble.com/FDO-spatial-query-tp2450209p2454115.html
Sent from the FDO Users mailing list archive at Nabble.com.

_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users