Questions tagged [mariadb]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
67 views

MySQL, geoPHP, select sites near the current site

I'm working with archaeological sites, stored as polygons in a MariaDB 10.3 table, and I have PHP 7.2 with GEOS and geoPHP available. I'm creating a page that displays all the related information for ...
1
vote
0answers
98 views

Which approach is faster for getting all POIs from MySQL/MariaDB with PHP/Laravel [closed]

Correct me if I'm wrong. There are three approaches to get the nearest homes, users have created in my website: To create a table with two columns(latitude, longitude) that both of them are float ...
1
vote
1answer
292 views

Data exchange QGIS SQL

I am a new user of QGIS. I was surprised how easy it is to visualize data from a SQL database in QGIS. Now I wonder if it is possible that changes in the database can be passed on directly to QGIS. ...
1
vote
0answers
243 views

Is it possible to incorporate QGIS shapefile / polygon to XAMPP?

I want to make a website using XAMPP but it must include a map of our city. I used QGIS to produce a shapefile of our city. I also want to use MySQL / MariaDB as the database but I don't know how to ...
1
vote
1answer
100 views

Database Tiled Aggregation request

We have a table in MariaDB that contains a lot of point of interest. These POI have a list of numerical attribute such has occurrence, weight, etc. We are looking for a way to aggregate these POI by ...
1
vote
1answer
1k views

What options are there for geolocation-aware SQL databses? [closed]

I need to implement an SQL database that can make queries using geo-location based logic. e.g. select rows within 500m of coordinate x, y What options are available to do this with sqlite, mySQL, ...
0
votes
1answer
258 views

Storing bounding box in database (mariaDB)?

Is there a bounding box type or a nearest equivalent for specifying a column the will store an extent (SE-NW) and how would I then query the database to find entries where a point exists within it? ...
3
votes
0answers
1k views

Is there something like postgis for mariaDB? [closed]

Someone told me that PostGIS exists. Currently I'm storing latitude and longitude information un a MariaDB, but I want to know if there is something similar for MariaDB. Unfortunately, migrating to ...