MonetDB: geo-update - Added function SHPload for loading a Shape...

2021-06-23 Thread Bernardo Mota
Changeset: 2f1c32a39772 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2f1c32a39772 Modified Files: sql/backends/monet5/vaults/shp/75_shp.sql sql/backends/monet5/vaults/shp/shp.c sql/backends/monet5/vaults/shp/shp.h sql/backends/monet5/vaults/shp/shp.mal

MonetDB: geo-update - Merge default into geo-update.

2021-08-24 Thread Bernardo Mota
Changeset: b038c760fcca for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b038c760fcca Removed Files: ChangeLog.Oct2020 NT/ChangeLog.Oct2020 clients/ChangeLog.Oct2020 clients/mapilib/ChangeLog.Oct2020 clients/odbc/ChangeLog.Oct2020

MonetDB: geo-update - Branch merge

2021-08-24 Thread Bernardo Mota
Changeset: a9abb1bbdf08 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a9abb1bbdf08 Modified Files: geom/monetdb5/geom.c Branch: geo-update Log Message: Branch merge diffs (290 lines): diff --git a/geom/monetdb5/geom.c b/geom/monetdb5/geom.c --- a/geom/monetdb5/geom.c +++

MonetDB: geo-update - Added schema to the argument list of shplo...

2021-08-24 Thread Bernardo Mota
Changeset: eee8df92b7c6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/eee8df92b7c6 Modified Files: sql/backends/monet5/vaults/shp/75_shp.sql sql/backends/monet5/vaults/shp/shp.c sql/backends/monet5/vaults/shp/shp.h sql/backends/monet5/vaults/shp/shp.mal

MonetDB: geo-update - Small fix for QGIS (change type to geometr...

2021-08-24 Thread Bernardo Mota
Changeset: f30df59c968e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f30df59c968e Modified Files: geom/monetdb5/geom.c geom/sql/40_geom.sql Branch: geo-update Log Message: Small fix for QGIS (change type to geometry_type in sys.geometry_columns) plus fix in

MonetDB: geo-update - Fixed wkbHEAP/wkbaHEAP and small patch on ...

2021-08-24 Thread Bernardo Mota
Changeset: 18e7c7ba9654 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/18e7c7ba9654 Modified Files: geom/monetdb5/geom.c Branch: geo-update Log Message: Fixed wkbHEAP/wkbaHEAP and small patch on cleanup (wkbUnionAggrSubGroupedCand) diffs (42 lines): diff --git

MonetDB: geo-update - Fixed a merge

2021-09-01 Thread Bernardo Mota
Changeset: 2db68096ac73 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2db68096ac73 Modified Files: geom/monetdb5/geom.c sql/backends/monet5/vaults/shp/shp.c Branch: geo-update Log Message: Fixed a merge diffs (246 lines): diff --git a/geom/monetdb5/geom.c

MonetDB: geo-update - Refactored code, improved Point-In-Polygon...

2021-09-01 Thread Bernardo Mota
Changeset: eea7c545ffe7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/eea7c545ffe7 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h Branch: geo-update Log Message: Refactored code, improved Point-In-Polygon calculation diffs (truncated from 1066 to 300 lines):

MonetDB: geo-update - Added GeoPolygon data type to also represe...

2021-09-03 Thread Bernardo Mota
Changeset: 79f196ea8e2c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/79f196ea8e2c Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h Branch: geo-update Log Message: Added GeoPolygon data type to also represent the interior rings of a Polygon. Added GeoPolygon to

MonetDB: geo-update - Refactored code, added Covers() operation,...

2021-09-02 Thread Bernardo Mota
Changeset: 8f964ad6520e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8f964ad6520e Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geom.mal geom/sql/40_geom.sql Branch: geo-update Log Message: Refactored code, added Covers()

MonetDB: geo-update - Added wkbUnionAggrSubGroupedCand function ...

2021-08-12 Thread Bernardo Mota
Changeset: 096b6a5df0c1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/096b6a5df0c1 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geom.mal Branch: geo-update Log Message: Added wkbUnionAggrSubGroupedCand function to add support for using

MonetDB: geo-update - Fixed a bug in shapefile loading regarding...

2021-09-23 Thread Bernardo Mota
Changeset: fbaa5b03981a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fbaa5b03981a Modified Files: sql/backends/monet5/vaults/shp/shp.c Branch: geo-update Log Message: Fixed a bug in shapefile loading regarding upper case table names. diffs (23 lines): diff --git

MonetDB: geo-update - Fixed formatting.

2021-09-23 Thread Bernardo Mota
Changeset: e9e3355b22c2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e9e3355b22c2 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h Branch: geo-update Log Message: Fixed formatting. diffs (truncated from 8058 to 300 lines): diff --git a/geom/monetdb5/geom.c

MonetDB: geo-update - Merge with default

2021-09-23 Thread Bernardo Mota
Changeset: 26e222e7ea58 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/26e222e7ea58 Modified Files: sql/scripts/51_sys_schema_extension.sql sql/test/BugTracker-2020/Tests/wrong-key-error.Bug-6983.test Branch: geo-update Log Message: Merge with default diffs (truncated

MonetDB: geo-update - Fixed frees in Collect group by operation.

2021-09-23 Thread Bernardo Mota
Changeset: 9b7559b71224 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9b7559b71224 Modified Files: geom/monetdb5/geom.c Branch: geo-update Log Message: Fixed frees in Collect group by operation. diffs (257 lines): diff --git a/geom/monetdb5/geom.c b/geom/monetdb5/geom.c ---

MonetDB: geo-update - "Collect Group By" op now working for inpu...

2021-09-23 Thread Bernardo Mota
Changeset: e80661a98d05 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e80661a98d05 Modified Files: geom/monetdb5/geom.c Branch: geo-update Log Message: "Collect Group By" op now working for inputs which are not ordered. Missing some frees and some optimizations. diffs (124

MonetDB: geo-update - Using BATproejct when ordering input inste...

2021-09-27 Thread Bernardo Mota
Changeset: eb4af5e703db for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/eb4af5e703db Modified Files: geom/monetdb5/geom.c Branch: geo-update Log Message: Using BATproejct when ordering input instead of doing it myself, fixed unused variables. diffs (237 lines): diff --git

MonetDB: geo-update - Unused variable fix

2021-09-30 Thread Bernardo Mota
Changeset: 4494a74949b6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4494a74949b6 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h Branch: geo-update Log Message: Unused variable fix diffs (truncated from 305 to 300 lines): diff --git a/geom/monetdb5/geom.c

MonetDB: geo-update - Small fix on dwithin, added shortcuts for ...

2021-09-30 Thread Bernardo Mota
Changeset: 4bfd248c9b10 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4bfd248c9b10 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h Branch: geo-update Log Message: Small fix on dwithin, added shortcuts for 0 distances in distance functions and removed srid

MonetDB: geo-update - Changed the DistancePointLine operation to...

2021-09-30 Thread Bernardo Mota
Changeset: 24a06489f813 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/24a06489f813 Modified Files: geom/monetdb5/geom.c Branch: geo-update Log Message: Changed the DistancePointLine operation to better fit the current GeoLines structure (which needs to be changed later).

MonetDB: geo-update - Fixed the st_collect aggregate to also sup...

2021-10-04 Thread Bernardo Mota
Changeset: f821bf402bf8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f821bf402bf8 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h Branch: geo-update Log Message: Fixed the st_collect aggregate to also support non-grouped aggregation. Also changed the module

MonetDB: geo-update - Corrected aggregate SQL command.

2021-10-04 Thread Bernardo Mota
Changeset: d54bb1e603eb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d54bb1e603eb Modified Files: geom/sql/40_geom.sql Branch: geo-update Log Message: Corrected aggregate SQL command. diffs (9 lines): diff --git a/geom/sql/40_geom.sql b/geom/sql/40_geom.sql ---

MonetDB: geo-update - Changed st_collect aggregate MAL function ...

2021-10-04 Thread Bernardo Mota
Changeset: 57b3b0306af6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/57b3b0306af6 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.mal geom/sql/40_geom.sql Branch: geo-update Log Message: Changed st_collect aggregate MAL function name. diffs (45 lines):

MonetDB: geo-update - Fixed Collect function, now does what it's...

2021-09-21 Thread Bernardo Mota
Changeset: cc9861b85628 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cc9861b85628 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geom.mal geom/sql/40_geom.sql Branch: geo-update Log Message: Fixed Collect function, now does what

MonetDB: geo-update - Fixed GDKRealloc call.

2021-11-22 Thread Bernardo Mota
Changeset: 941f95cfdc71 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/941f95cfdc71 Modified Files: sql/backends/monet5/vaults/shp/shp.c Branch: geo-update Log Message: Fixed GDKRealloc call. diffs (14 lines): diff --git a/sql/backends/monet5/vaults/shp/shp.c

MonetDB: geo-update - Merged.

2021-11-22 Thread Bernardo Mota
Changeset: adf21ae4aa9d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/adf21ae4aa9d Modified Files: geom/monetdb5/geom.c Branch: geo-update Log Message: Merged. diffs (47 lines): diff --git a/geom/monetdb5/geom.c b/geom/monetdb5/geom.c --- a/geom/monetdb5/geom.c +++

MonetDB: geo-update - Reduced the number of distance calculation...

2021-11-22 Thread Bernardo Mota
Changeset: a8c9c85140c2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a8c9c85140c2 Modified Files: geom/monetdb5/geom.c Branch: geo-update Log Message: Reduced the number of distance calculations done in Line-Line distance operations (removed redundant calculations). diffs

MonetDB: geo-update - Added first version of bulk distance funct...

2021-11-22 Thread Bernardo Mota
Changeset: 0074c4e37d27 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0074c4e37d27 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geomBulk.c geom/sql/40_geom.sql Branch: geo-update Log Message: Added first version of bulk distance

MonetDB: geo-update - Fixed memory leaks.

2021-12-02 Thread Bernardo Mota
Changeset: 8c4f69604a96 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8c4f69604a96 Modified Files: geom/monetdb5/geom.c sql/backends/monet5/vaults/shp/shp.c Branch: geo-update Log Message: Fixed memory leaks. diffs (truncated from 367 to 300 lines): diff --git

MonetDB: geo-update - GEOS type conversion is only done once in ...

2021-11-30 Thread Bernardo Mota
Changeset: 291ecf019da8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/291ecf019da8 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geomBulk.c Branch: geo-update Log Message: GEOS type conversion is only done once in join filter; More signatures; Some small cleanups

MonetDB: geo-update - First version of the distance filter funct...

2021-11-30 Thread Bernardo Mota
Changeset: 96c494c40104 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/96c494c40104 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/sql/40_geom.sql Branch: geo-update Log Message: First version of the distance filter functions. diffs (truncated

MonetDB: geo-update - Distance for geographies now calculates th...

2021-07-20 Thread Bernardo Mota
Changeset: bf48f38d5105 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bf48f38d5105 Modified Files: geom/monetdb5/geom.c Branch: geo-update Log Message: Distance for geographies now calculates the perpendicular of a point in a line. diffs (165 lines): diff --git

MonetDB: geo-update - Added simpler data types to represent geom...

2021-07-20 Thread Bernardo Mota
Changeset: 8a27bd9efb0f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8a27bd9efb0f Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h Branch: geo-update Log Message: Added simpler data types to represent geometries (instead of using GEOSGeom) and refactored the

MonetDB: geo-update - Fixes for shpload and multi-geometry fix o...

2021-07-21 Thread Bernardo Mota
Changeset: f2dbd19053bc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f2dbd19053bc Modified Files: geom/monetdb5/geom.c sql/backends/monet5/vaults/shp/75_shp.sql sql/backends/monet5/vaults/shp/shp.c Branch: geo-update Log Message: Fixes for shpload and

MonetDB: geo-update - Added DWithinGeographic and IntersectsGeog...

2021-07-16 Thread Bernardo Mota
Changeset: ccd852067e23 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ccd852067e23 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geom.mal geom/sql/40_geom.sql Branch: geo-update Log Message: Added DWithinGeographic and

MonetDB: geo-update - First version of distance calculation for ...

2021-07-16 Thread Bernardo Mota
Changeset: db68ff963637 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/db68ff963637 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geom.mal geom/sql/40_geom.sql Branch: geo-update Log Message: First version of distance calculation

MonetDB: geo-update - Initial implementation of bounding box fun...

2022-04-08 Thread Bernardo Mota
Changeset: 54459064f670 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/54459064f670 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h Branch: geo-update Log Message: Initial implementation of bounding box function (geodeticEdgeBoundingBox) diffs (271 lines):

MonetDB: geo-update - Backout of commits 85590, 85589, 85588 and...

2022-05-18 Thread Bernardo Mota
Changeset: c7eb7021c894 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c7eb7021c894 Removed Files: geom/monetdb5/cleanup.md geom/monetdb5/geod.c geom/monetdb5/geod.h geom/monetdb5/geom_io.c geom/monetdb5/geom_io.h geom/monetdb5/geom_srid.c

MonetDB: geo-update - Modularisation of the geom module: moved g...

2022-05-18 Thread Bernardo Mota
Changeset: a7968048094f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a7968048094f Added Files: geom/monetdb5/geod.c geom/monetdb5/geod.h geom/monetdb5/geom_atoms.c geom/monetdb5/geom_atoms.h geom/sql/39_spatial_ref_sys.sql Modified Files:

MonetDB: geo-update - Fixed CMake file to find proj lib

2022-06-01 Thread Bernardo Mota
Changeset: 9ad000cb0f71 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9ad000cb0f71 Modified Files: cmake/Modules/FindProj.cmake Branch: geo-update Log Message: Fixed CMake file to find proj lib diffs (12 lines): diff --git a/cmake/Modules/FindProj.cmake

MonetDB: geo-update - First implementation for ST_MakeLine aggre...

2022-06-01 Thread Bernardo Mota
Changeset: 8715067844c5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8715067844c5 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/sql/40_geom.sql Branch: geo-update Log Message: First implementation for ST_MakeLine aggregate diffs (240 lines):

MonetDB: geo-update - Fix non-existing bounding box on polygon f...

2022-06-15 Thread Bernardo Mota
Changeset: 6ca55805d7cd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6ca55805d7cd Modified Files: geom/monetdb5/geod.c geom/monetdb5/geom.c Branch: geo-update Log Message: Fix non-existing bounding box on polygon for distancegeographic, makeline temporary fix diffs

MonetDB: geo-update - Updated PROJ library calls to latest versi...

2022-05-24 Thread Bernardo Mota
Changeset: 26c8480c79a9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/26c8480c79a9 Added Files: geom/sql/functions/Tests/ST_Transform.reqtests geom/sql/functions/Tests/ST_Transform.test Modified Files: geom/lib/libgeom.h geom/monetdb5/geom.c

MonetDB: geo-update - Split up SQL functions

2022-05-11 Thread Bernardo Mota
Changeset: 15c74f6662c2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/15c74f6662c2 Added Files: geom/sql/40_geom_OGC.sql geom/sql/40_geom_PostGIS.sql Modified Files: geom/lib/libgeom.c geom/lib/libgeom.h geom/monetdb5/CMakeLists.txt

MonetDB: geo-update - Missing files from last commit; Divided th...

2022-05-11 Thread Bernardo Mota
Changeset: d34e2d0e2e93 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d34e2d0e2e93 Added Files: geom/monetdb5/geom_io.c geom/monetdb5/geom_io.h geom/monetdb5/geom_srid.c geom/monetdb5/geom_srid.h geom/monetdb5/mbr.c geom/monetdb5/mbr.h

MonetDB: geo-update - Moved geodetic functions to geod.c/geod.h ...

2022-05-11 Thread Bernardo Mota
Changeset: 3360b0e53c0c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3360b0e53c0c Added Files: geom/monetdb5/cleanup.md geom/monetdb5/geod.c geom/monetdb5/geod.h geom/sql/spatial_ref_sys.sql Modified Files: geom/monetdb5/CMakeLists.txt

MonetDB: geo-update - Moved MBR functions to mbr.c/mbr.h

2022-05-11 Thread Bernardo Mota
Changeset: 02776ff8b690 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/02776ff8b690 Modified Files: geom/monetdb5/cleanup.md geom/monetdb5/geod.c geom/monetdb5/geod.h geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geomBulk.c Branch:

MonetDB: geo-update-dev - Add RTREEexists and RTREEaddmbr to gdk...

2022-08-25 Thread Bernardo Mota
Changeset: 1aec5bc9342a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1aec5bc9342a Modified Files: gdk/gdk_rtree.c gdk/gdk_rtree.h Branch: geo-update-dev Log Message: Add RTREEexists and RTREEaddmbr to gdk_rtree, small improvements on search. diffs (117 lines): diff

MonetDB: geo-update-dev - Improved ST_Intersects with RTree inde...

2022-08-25 Thread Bernardo Mota
Changeset: 2d3073d9a61c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2d3073d9a61c Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geomBulk.c geom/sql/40_geom.sql Branch: geo-update-dev Log Message: Improved ST_Intersects with

MonetDB: geo-update-dev - Added non-index version of st_intersec...

2022-08-25 Thread Bernardo Mota
Changeset: 379916008131 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/379916008131 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geomBulk.c geom/sql/40_geom.sql Branch: geo-update-dev Log Message: Added non-index version of

MonetDB: geo-update-dev - Merge with Stefanos cmake.

2022-10-19 Thread Bernardo Mota
Changeset: 9c330ca1b2e3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9c330ca1b2e3 Branch: geo-update-dev Log Message: Merge with Stefanos cmake. diffs (38 lines): diff --git a/cmake/Modules/FindRTree.cmake b/cmake/Modules/FindRTree.cmake --- a/cmake/Modules/FindRTree.cmake +++

MonetDB: geo-update-dev - Improved the RTREEdestroy function, ch...

2022-10-19 Thread Bernardo Mota
Changeset: 9d099829ebf5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9d099829ebf5 Modified Files: gdk/gdk_rtree.c geom/monetdb5/geom.c geom/sql/40_geom.sql Branch: geo-update-dev Log Message: Improved the RTREEdestroy function, changed the conditions for

MonetDB: geo-update-dev - Added rtree function ID to optimizers,...

2022-10-19 Thread Bernardo Mota
Changeset: 236e4049396c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/236e4049396c Modified Files: monetdb5/optimizer/opt_mitosis.c monetdb5/optimizer/opt_prelude.c monetdb5/optimizer/opt_prelude.h Branch: geo-update-dev Log Message: Added rtree function ID to

MonetDB: geo-update-dev - DWithin with RTree index implementatio...

2022-10-31 Thread Bernardo Mota
Changeset: e7f20b0bc1d8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e7f20b0bc1d8 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geomBulk.c geom/sql/40_geom.sql monetdb5/optimizer/opt_mitosis.c Branch: geo-update-dev Log

MonetDB: geo-update-dev - WIP locking + multi-threaded

2022-09-08 Thread Bernardo Mota
Changeset: 5718439adb42 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5718439adb42 Modified Files: gdk/gdk_rtree.c geom/monetdb5/geomBulk.c Branch: geo-update-dev Log Message: WIP locking + multi-threaded diffs (70 lines): diff --git a/gdk/gdk_rtree.c

MonetDB: geo-update-dev - Added RTREEdestroy to free the rtree s...

2022-10-04 Thread Bernardo Mota
Changeset: 6dac84827ce4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6dac84827ce4 Modified Files: gdk/gdk.h gdk/gdk_rtree.c geom/monetdb5/geom.c geom/monetdb5/geomBulk.c Branch: geo-update-dev Log Message: Added RTREEdestroy to free the rtree structure

MonetDB: geo-update-dev - Added BATcheckrtree to load rtree from...

2022-10-04 Thread Bernardo Mota
Changeset: d382d0c04eb4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d382d0c04eb4 Modified Files: gdk/gdk_rtree.c gdk/gdk_rtree.h Branch: geo-update-dev Log Message: Added BATcheckrtree to load rtree from disk using the librtree brst read. diffs (219 lines): diff

MonetDB: geo-update-dev - Write and read the bsrt rtree files fr...

2022-10-04 Thread Bernardo Mota
Changeset: d04d3b23a2f8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d04d3b23a2f8 Modified Files: gdk/gdk_rtree.c geom/monetdb5/geomBulk.c Branch: geo-update-dev Log Message: Write and read the bsrt rtree files from the BAT farm directory, with the appropriate BAT id

MonetDB: geo-update-dev - Added logical references to RTree func...

2022-10-12 Thread Bernardo Mota
Changeset: acddb6337e36 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/acddb6337e36 Removed Files: gdk/gdk_rtree.h Modified Files: gdk/gdk.h gdk/gdk_private.h gdk/gdk_rtree.c geom/monetdb5/geod.c Branch: geo-update-dev Log Message: Added logical

MonetDB: geo-update - Define M_PI and M_PI_2 for MS compilation ...

2022-10-12 Thread Bernardo Mota
Changeset: 2a71660baa69 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2a71660baa69 Modified Files: geom/monetdb5/geod.c Branch: geo-update Log Message: Define M_PI and M_PI_2 for MS compilation (math constants are not always defined) diffs (16 lines): diff --git

MonetDB: geo-update-dev - Small cleanups on geomBulk.c

2022-10-03 Thread Bernardo Mota
Changeset: 188164651dec for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/188164651dec Modified Files: geom/monetdb5/geomBulk.c Branch: geo-update-dev Log Message: Small cleanups on geomBulk.c diffs (193 lines): diff --git a/geom/monetdb5/geomBulk.c b/geom/monetdb5/geomBulk.c ---

MonetDB: geo-update-dev - persistRtree added, using the rtree li...

2022-10-03 Thread Bernardo Mota
Changeset: f197af35b40a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f197af35b40a Modified Files: gdk/gdk_rtree.c gdk/gdk_rtree.h Branch: geo-update-dev Log Message: persistRtree added, using the rtree lib write function. RTree is stored in file, but not loaded.

MonetDB: geo-update-dev - Added RTREEdestroy calls to the approp...

2022-10-14 Thread Bernardo Mota
Changeset: 66b3286e1e9a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/66b3286e1e9a Modified Files: gdk/gdk.h gdk/gdk_align.c gdk/gdk_bat.c gdk/gdk_batop.c gdk/gdk_bbp.c gdk/gdk_rtree.c gdk/gdk_storage.c Branch: geo-update-dev Log

MonetDB: geo-update-dev - Use non-index version of intersects if...

2022-10-14 Thread Bernardo Mota
Changeset: c8ed99d620c5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c8ed99d620c5 Modified Files: gdk/gdk.h gdk/gdk_rtree.c geom/monetdb5/geomBulk.c Branch: geo-update-dev Log Message: Use non-index version of intersects if RTree was not created, fixes to

MonetDB: geo-update-dev - Implemented the rtree build in the bul...

2022-08-09 Thread Bernardo Mota
Changeset: f8a1ea4c5709 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f8a1ea4c5709 Modified Files: geom/monetdb5/geod.c geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geomBulk.c geom/monetdb5/geom_atoms.c geom/sql/40_geom.sql

MonetDB: geo-update-dev - Compilation files for rtree index. Som...

2022-08-09 Thread Bernardo Mota
Changeset: 9f09f9207549 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9f09f9207549 Added Files: cmake/Modules/FindRTree.cmake Modified Files: cmake/monetdb-defines.cmake cmake/monetdb-findpackages.cmake cmake/monetdb-options.cmake

MonetDB: geo-update-dev - First version of rtree index (using li...

2022-08-09 Thread Bernardo Mota
Changeset: 4720c5def5d1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4720c5def5d1 Added Files: gdk/gdk_rtree.c gdk/gdk_rtree.h Modified Files: gdk/gdk.h Branch: geo-update-dev Log Message: First version of rtree index (using librtree). BATrtree builds the index

MonetDB: geo-update-dev - Renamed function to not overlap with l...

2022-08-09 Thread Bernardo Mota
Changeset: b6e9b926536e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b6e9b926536e Modified Files: sql/storage/objectset.c Branch: geo-update-dev Log Message: Renamed function to not overlap with librtree API diffs (43 lines): diff --git a/sql/storage/objectset.c

MonetDB: geo-update - Fixed ST_Transform bulk version: wasn't sa...

2022-12-07 Thread Bernardo Mota
Changeset: 3ab464af9d50 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3ab464af9d50 Modified Files: geom/monetdb5/geomBulk.c Branch: geo-update Log Message: Fixed ST_Transform bulk version: wasn't saving transformed geoms to out BAT. diffs (21 lines): diff --git

MonetDB: geo-update - Fixed GRANT command on filter functions.

2022-11-25 Thread Bernardo Mota
Changeset: 163c1032997a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/163c1032997a Modified Files: geom/monetdb5/geom_upgrade.c geom/sql/40_geom.sql Branch: geo-update Log Message: Fixed GRANT command on filter functions. diffs (30 lines): diff --git

MonetDB: geo-update - Added wkbIntersectsRTree JOIN filter funct...

2022-11-15 Thread Bernardo Mota
Changeset: 1f5de5c7bc94 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1f5de5c7bc94 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geomBulk.c Branch: geo-update Log Message: Added wkbIntersectsRTree JOIN filter function. Fixed

MonetDB: geo-update - Updated geom_upgrade.c SQL upgrade code: i...

2022-11-22 Thread Bernardo Mota
Changeset: 644c65affafb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/644c65affafb Modified Files: geom/monetdb5/geom_upgrade.c Branch: geo-update Log Message: Updated geom_upgrade.c SQL upgrade code: it now drops SQL functions which were changed and creates the new SQL

MonetDB: geo-update - Added GRANTE EXECUTE commands to new geom ...

2022-11-22 Thread Bernardo Mota
Changeset: 83a69380f638 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/83a69380f638 Modified Files: geom/sql/40_geom.sql Branch: geo-update Log Message: Added GRANTE EXECUTE commands to new geom SQL functions. diffs (39 lines): diff --git a/geom/sql/40_geom.sql

MonetDB: geo-update - Fixed sql_upgrades code for the shp module...

2022-11-22 Thread Bernardo Mota
Changeset: be683bdd665a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/be683bdd665a Modified Files: sql/backends/monet5/sql_upgrades.c Branch: geo-update Log Message: Fixed sql_upgrades code for the shp module. It now correctly drops the old shapefile functions, if found

MonetDB: geo-update - Changed minimum GEOS version from 3.8.0 to...

2022-11-08 Thread Bernardo Mota
Changeset: 715a5e0060fe for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/715a5e0060fe Modified Files: MonetDB.spec Branch: geo-update Log Message: Changed minimum GEOS version from 3.8.0 to 3.10.0 (we use the GEOSDistanceWithin from 3.10). diffs (12 lines): diff --git

MonetDB: geo-update - Added DWithin test.

2022-11-10 Thread Bernardo Mota
Changeset: e5c1648b1c98 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e5c1648b1c98 Added Files: geom/sql/functions/Tests/ST_DWithin.reqtest geom/sql/functions/Tests/ST_DWithin.test Modified Files: geom/sql/functions/Tests/All

MonetDB: geo-update - Added ST_DwithinRTree test.

2022-11-10 Thread Bernardo Mota
Changeset: d73d831a6364 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d73d831a6364 Added Files: geom/sql/functions/Tests/ST_DWithinRTree.reqtest geom/sql/functions/Tests/ST_DWithinRTree.test Branch: geo-update Log Message: Added ST_DwithinRTree test. diffs (107 lines):

MonetDB: geo-update - Added test for ST_Intersects. Added test t...

2022-11-10 Thread Bernardo Mota
Changeset: b899b549728a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b899b549728a Added Files: geom/sql/functions/Tests/ST_Intersects.reqtest geom/sql/functions/Tests/ST_Intersects.test geom/sql/functions/Tests/loadTestPolygons.test Modified Files:

MonetDB: geo-update - Added test to create RTree geometries. Add...

2022-11-10 Thread Bernardo Mota
Changeset: b9744423b10d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b9744423b10d Added Files: geom/sql/functions/Tests/ST_IntersectsRTree.reqtest geom/sql/functions/Tests/ST_IntersectsRTree.test geom/sql/functions/Tests/createRTreeIndex.test Modified Files:

MonetDB: geo-update-dev - Added HAVE_RTREE guard to gdk.h

2022-11-04 Thread Bernardo Mota
Changeset: fc0df8d6cb5c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fc0df8d6cb5c Modified Files: gdk/gdk.h Branch: geo-update-dev Log Message: Added HAVE_RTREE guard to gdk.h diffs (16 lines): diff --git a/gdk/gdk.h b/gdk/gdk.h --- a/gdk/gdk.h +++ b/gdk/gdk.h @@ -351,10

MonetDB: geo-update-dev - More HAVE_RTREE conditions in gdk and ...

2022-11-04 Thread Bernardo Mota
Changeset: 3dd5eca81c5b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3dd5eca81c5b Modified Files: gdk/gdk.h gdk/gdk_private.h Branch: geo-update-dev Log Message: More HAVE_RTREE conditions in gdk and gdk_private diffs (70 lines): diff --git a/gdk/gdk.h b/gdk/gdk.h

MonetDB: geo-update-dev - Removed return type from filter functi...

2022-11-04 Thread Bernardo Mota
Changeset: 6bba03960bba for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6bba03960bba Modified Files: geom/sql/40_geom.sql Branch: geo-update-dev Log Message: Removed return type from filter function declaration. diffs (12 lines): diff --git a/geom/sql/40_geom.sql

MonetDB: geo-update - Merged geo-update-dev into geo-update.

2022-11-04 Thread Bernardo Mota
Changeset: 285afea1c28b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/285afea1c28b Modified Files: geom/monetdb5/geod.c Branch: geo-update Log Message: Merged geo-update-dev into geo-update. diffs (truncated from 2338 to 300 lines): diff --git a/cmake/Modules/FindRTree.cmake

MonetDB: geo-update-dev - Fixed jump-misses-init error in Collec...

2022-11-04 Thread Bernardo Mota
Changeset: a0d85d00c331 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a0d85d00c331 Modified Files: gdk/gdk_rtree.c geom/monetdb5/geom.c Branch: geo-update-dev Log Message: Fixed jump-misses-init error in Collect, added HAVE_RTREE guards in gdk_rtree.c. diffs (37

MonetDB: geo-update-dev - Removed RTREEdestroy and RTREEfree fro...

2022-11-04 Thread Bernardo Mota
Changeset: dc593b1dcb39 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/dc593b1dcb39 Modified Files: gdk/gdk.h gdk/gdk_rtree.c Branch: geo-update-dev Log Message: Removed RTREEdestroy and RTREEfree from the HAVE_RTREE guard, made them no-ops in the case of not having the

MonetDB: geo-update - Merge with default.

2022-11-04 Thread Bernardo Mota
Changeset: 4237b6ee7478 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4237b6ee7478 Removed Files: debian/libmonetdb25.install Modified Files: .hgtags MonetDB.spec debian/changelog debian/control debian/libmonetdb26.install

MonetDB: geo-update-dev - Improved the shortcuts in the geodetic...

2022-11-02 Thread Bernardo Mota
Changeset: c752424323df for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c752424323df Modified Files: geom/monetdb5/geod.c Branch: geo-update-dev Log Message: Improved the shortcuts in the geodetic functions, stopping execution once we reach the minimum distance we stop

MonetDB: geo-update-dev - Collect op cleanup

2022-11-02 Thread Bernardo Mota
Changeset: 1214a87431e6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1214a87431e6 Modified Files: geom/monetdb5/geod.c geom/monetdb5/geom.c geom/sql/40_geom.sql Branch: geo-update-dev Log Message: Collect op cleanup diffs (136 lines): diff --git

MonetDB: geo-update-dev - Geom and GeomBulk cleanup and fixes, a...

2022-11-02 Thread Bernardo Mota
Changeset: c26a27dc94d8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c26a27dc94d8 Modified Files: geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geomBulk.c Branch: geo-update-dev Log Message: Geom and GeomBulk cleanup and fixes, added HAVE_RTREE

MonetDB: geo-update-dev - Small cleanups

2022-11-02 Thread Bernardo Mota
Changeset: b9fd67825632 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b9fd67825632 Modified Files: geom/monetdb5/geod.c sql/backends/monet5/sql_upgrades.c Branch: geo-update-dev Log Message: Small cleanups diffs (113 lines): diff --git a/geom/monetdb5/geod.c

MonetDB: geo-update-dev - Reorganized SQL functions in 40_geom a...

2022-11-02 Thread Bernardo Mota
Changeset: 747ccab8bae0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/747ccab8bae0 Modified Files: geom/sql/40_geom.sql sql/backends/monet5/sql_upgrades.c Branch: geo-update-dev Log Message: Reorganized SQL functions in 40_geom and fixed the SQL code update for the

MonetDB: geo-update - Added ST_Collect scalar version, previousl...

2022-11-09 Thread Bernardo Mota
Changeset: 9612b6c5098a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9612b6c5098a Modified Files: geom/monetdb5/geod.c geom/monetdb5/geod.h geom/monetdb5/geom.c geom/monetdb5/geom.h geom/sql/40_geom.sql Branch: geo-update Log Message: Added

MonetDB: geo-update - Expanded ST_Collect test.

2022-11-09 Thread Bernardo Mota
Changeset: d094ce4aecf7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d094ce4aecf7 Modified Files: geom/sql/functions/Tests/ST_Collect.test Branch: geo-update Log Message: Expanded ST_Collect test. diffs (145 lines): diff --git a/geom/sql/functions/Tests/ST_Collect.test

MonetDB: geo-update - Added test for ST_MakeLine aggregate.

2022-11-09 Thread Bernardo Mota
Changeset: cd304b4b0d77 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cd304b4b0d77 Added Files: geom/sql/functions/Tests/ST_MakeLine.test Modified Files: geom/sql/functions/Tests/All Branch: geo-update Log Message: Added test for ST_MakeLine aggregate. diffs (62