Questions tagged [mariadb]

an open source relational database.

Filter by
Sorted by
Tagged with
0
votes
0answers
54 views

ogr2ogr in QGIS v3.8 vs. v3.20 - swapped coordinates from swissgrid to WGS84 when import to MariaDB 10.4.19-

I have a shapefile to be imported to db. in QGIS 3.8 the following worked: ogr2ogr -f ....... -t_srs "+proj=latlong +datum=WGS84 +axis=neu +wktext" but with the latest QGIS 3.20 coordinates ...
1
vote
1answer
52 views

MariaDB St_Within

Recently I noticed that ST_Within stopped working properly on some features. The geometry that breaks st_within has 1337 vertices (ESRI arc - many segments 1cm distance). If I reduce the vertices ...
1
vote
1answer
89 views

Extract top, bottom, left, and right (as numeric values) from a polygon in MariaDB?

Is there a way to extract the minimum and maximum x and y values separately from a polygon value in MariaDB (I'm using 10.5.8 with no extensions)? Eg: set @poly = ST_GeomFromText('POLYGON((1.2 1.2,2 1,...
1
vote
2answers
273 views

Can ST_BUFFER and ST_WITHIN be used for linestrings within a linestring?

I am working with MariaDB and trying to get data based on the condition of linestrings that are within another linestring. To allow linestrings not having to be exactly within (due to GPX variability ...
0
votes
1answer
609 views

MariaDB vs Postgres (POSTGIS) perfomance difference?

Has anyone used mariaDB for storing spatial data? I am using postgis now. My queries are mostly "finding peope within certain radius". Happn app an app which shows you "the people you crossed path ...
1
vote
1answer
1k views

Need to connect to MySQL or MariaDB databases in QGIS 3.4+

I need to connect to MySQL/MariaDB database tables where my geographic data is stored. I used to be able to do this in earlier versions of QGIS, but that option disappeared ~ QGIS 2.14. Are there any ...
1
vote
2answers
275 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
199 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
347 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
273 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 ...
0
votes
1answer
438 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
2k 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 ...
1
vote
1answer
146 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, ...