New answers tagged mysql
As MariaDB is a fork of MySQL, I believe it has al the same spatial functionality, which is considerably less than Postgis, but sufficient for your query. You can't GROUP BY a bounding box as such, but you can summarize attributes where the geometries bounding boxes intersect some input geometry. In MySQL/MariaDB, functions that operate on bounding boxes ...
As stated here link to previous article while it is possible to add the data to MySQL common wisdom advises against this practice. Most of the tools have been developed to import OSM data in PostgresQL + PostGIS databases, for RDBMS or using GDAL toolkit, to convert OSM XML data to SpatiaLite file database.
the problem was: you cannot create a not null column on a table with existing rows without providing a default (I was unable to do this). the correct sequence: alter table <table> add column centroid point (add the column, no constraint) update <table> set centroid = ST_Centroid(shape) (i.e. populate the column with values) alter table ...
Top 50 recent answers are included