Using RTreeIntersects - not a function

[ckgoo...@gmail.com]

Hi.  I use Spatialite from within an SQLite3 prompt on Windows.

When I start a session I type:

.load mod_spatialite.dll

This has allowed me to use function calls like ST_Distance and MakeCircle.

When I try a statement using RTreeIntersects I get an error saying it isn’t a function.  The v4.2.0 documentation at:

http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html

says it is in the Geocallbacks module.

However, the documentation for Spatialite 5.1.0 at:

http://www.gaia-gis.it/gaia-sins/spatialite-sql-latest.html#p13

doesn’t have the RTreeIntersects   function. 

Is it superseded by functions like MbrIntersects?

Best, Chris

[a.fu...@lqt.it]

On Sun, 4 Aug 2024 21:55:36 +0100, ckgoo...@gmail.com wrote:

> When I try a statement using RTreeIntersects I get an error saying it
> isn't a function. The v4.2.0 documentation at:
>

> http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html [1]

>
> says it is in the Geocallbacks module.
>

Hi Chris,

don't waste time on obsolete modules that are
no longer supported.

The GeoCallback module was a failed attempt which,
when proven by the facts, turned out to be a dead
end and which was therefore subsequently removed.

My personal advice is to use the SpatialIndex in
its canonical form of an inner subquery requesting
for a rectangular "search_frame" of reasonale
dimensions.

If for some reason you prefer to use a brute
force approach based on ST_Contains() or
ST_Intersects() instead then use a circle of
suitable radius constructed by MakeCircle()

Don't waste time with MBR-based functions because
they are either outdated stuff or are essentially
intended to be used internally by the SpatialIndex
logic.

bye Sandro

[ckgoo...@gmail.com]

Hello Sandro, you wrote:
> My personal advice is to use the SpatialIndex in its canonical form of an inner subquery requesting for a rectangular "search_frame" of reasonale dimensions.

I was only using the RTreeIntersects function as this is what was in the Cookbook page:
http://www.gaia-gis.it/gaia-sins/spatialite-cookbook/html/neighbours.html

Doing a another google though has just given me:
https://www.gaia-gis.it/gaia-sins/spatialite-cookbook-5/cookbook_topics.04.html
Is this the latest and correct version to learn from?

Best, Chris

--
You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to spatialite-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/spatialite-users/38571812d1e1801761ddcc7ae3200584%40lqt.it.

[a.fu...@lqt.it]

On Mon, 5 Aug 2024 07:14:45 +0100, ckgoo...@gmail.com wrote:
> Doing a another google though has just given me:
>
> https://www.gaia-gis.it/gaia-sins/spatialite-cookbook-5/cookbook_topics.04.html
> Is this the latest and correct version to learn from?
>

Hi Chris,

yes, it's the latest but not necessarily the "correct"
version to learn from.

they follow different approaches and cover different
aspects; one is surely outdated, the other is less
complete.

Read them both and you won't be wrong for sure.

bye Sandro