Questions tagged [mariadb]

an open source relational database.

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

How to import shapefile into MySQL with Python

Let's see if you could help me with this: I try to upload a gpkg (geo-referenced) file (table) to a MariadB server (MySQL). Not in PostgreSQL, Mariadb-(MySQL) If I import from an OSGeo4W in the ...
user avatar
1 vote
0 answers
47 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 ...
user avatar
2 votes
1 answer
69 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 ...
user avatar
0 votes
0 answers
36 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 ...
user avatar
0 votes
0 answers
63 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 ...
user avatar
0 votes
0 answers
83 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 ...
user avatar
1 vote
1 answer
98 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 ...
user avatar
1 vote
1 answer
200 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,...
user avatar
  • 111
2 votes
2 answers
416 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 ...
user avatar
  • 21
0 votes
1 answer
894 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 ...
user avatar
1 vote
1 answer
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 ...
user avatar
  • 86
1 vote
2 answers
324 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 ...
user avatar
  • 21
1 vote
0 answers
242 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 ...
user avatar
1 vote
1 answer
353 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. ...
user avatar
1 vote
0 answers
284 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 ...
user avatar
0 votes
1 answer
483 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? ...
user avatar
  • 269
3 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 ...
user avatar
1 vote
1 answer
155 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 ...
user avatar
  • 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, ...
user avatar
  • 111