Questions tagged [mariadb]
an open source relational database.
19
questions
1
vote
0
answers
55
views
MariaDB set geometry field SRID SQL error
I'm trying to update a geometry field and set its SRID using the following statement which works fine in MySQL 8 but throws the following error in mariadb 10.3.37:
sql error 1064 check the manual that ...
- 111
1
vote
1
answer
322
views
Creating a Point with SRID - MariaDB
I have a table containing a longitude and latitude (as doubles) in MariaDB. What I'm trying to do is create a point with a specific SRID - 4326. The current way that I create a point is by using the ...
2
votes
1
answer
280
views
ST_Within is only working on selective rows
I have two tables (Table1, 10k rows, and Table2, 100k rows). Table1 contains latitude and longitude columns while Table2 contains a geometry column (representing a polygon). I wanted to merge these ...
- 23
0
votes
0
answers
58
views
Spatially Joining two tables
I have two tables in MariaDB. I am trying to join these two tables (Table 1 and Table 2). Table 1 contains Longitude and Latitude columns and Table 2 contains a MultiPolygonGeom column, which contains ...
- 23
1
vote
0
answers
142
views
Writing a dataframe, with shapely object, to database
I find such limited resources for my problems and have looked for a similar problem online, but didn't have any luck.
I have the following Pandas, not geopandas, dataframe:
RecAreaName ...
0
votes
0
answers
138
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
1
vote
1
answer
242
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
1
answer
410
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,...
- 111
2
votes
2
answers
737
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 ...
- 21
2
votes
1
answer
2k
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 ...
- 191
1
vote
2
answers
2k
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 ...
- 86
1
vote
2
answers
448
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 ...
- 21
1
vote
0
answers
314
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 ...
- 11
1
vote
1
answer
369
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
0
answers
298
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 ...
- 11
0
votes
1
answer
589
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?
...
- 269
4
votes
0
answers
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 ...
- 223
1
vote
1
answer
172
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 ...
- 123
1
vote
1
answer
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, ...
- 111