MySQL is an open-source, relational database management system. Place you question on MySQL Spatial Extensions here.

learn more… | top users | synonyms

1
vote
1answer
37 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
0answers
15 views

How to add ST_GeomFromEWKT in mysql?

I am using geoalchemy2 with mysql database. I have a polygon field. While inserting I am getting this error - from appmain import application from flask_sqlalchemy import SQLAlchemy db = ...
-1
votes
0answers
21 views

Export Mysql position data to PostGIS

I have a million points of position data on my MySQL database. I want to export it and put it on my PostGIS database, so I can open the data position using openGeo application. So what should I do ...
0
votes
0answers
22 views

Creating line-strings from points in MySQL

I am extracting the lat/long information from Geo-tagged images and storing them in MySQL. I want to get a line-string from the points, I looked into the GROUP_CONCAT() function but I am not able to ...
1
vote
1answer
36 views

Import streetdata from OSM file to MySQL

I'm trying to import the address data of a specific country from an OSM file in a MySQL DB. I tried to insert the data with osmosis and also to filter them with osmfilter bevor run OSM, but without ...
0
votes
1answer
24 views

Can't add POINT NOT NULL column to MySQL table

I recently upgraded to MySQL 5.7.9 & am using MyISAM for my table engine. Adding a new POINT column like so: ALTER TABLE <table> ADD centroid POINT NOT NULL; gives this error: ERROR ...
0
votes
0answers
28 views

mysql query to find area overlap

I have US zipcodes data in a mysql table where each zipcode shape is stored as polygon. From a given point (latitude and longitude) I want to know the zipcodes that overlap within 1 mile radius and ...
1
vote
1answer
59 views

Importing GeoJSON into MySQL?

I want to import GeoJSON data into MySQL to compare performance with other databases. Is there any way I can import following data into MySQL. And if it possible, how to create table for such records. ...
1
vote
1answer
41 views

Making table from MySQL query with ArcPy?

I am trying to interact directly with data from a MySQL database in ArcMap using Python. So far, I have successfully connected the database using the MySQLdb.connect() function and have successfully ...
0
votes
0answers
38 views

GeoServer support for WKT geospatial data that is read from a database

I have geospatial data stored in a MemSQL database in the Well-Known Text (WKT) format. I would like to visualize it in GeoServer. MemSQL supports the MySQL Wire Protocol and therefore I used the ...
1
vote
1answer
73 views

Cloud based database solution [closed]

I'm looking for a cloud based database solution where I can store about 1 GB worth of tabular data and both myself and my client can access to perform SQL queries. I'm looking for this database to ...
1
vote
1answer
34 views

Postgis/SpatiaLite SQL query to connect MySQL, Access or Oracle database

In SpatiaLite or Postgis, how can one create a SQL query to read a table from a MySql or Oracle database? I don't know **the correct SQL syntax to connect to a table in a MySql or Oracle database ...
1
vote
0answers
19 views

Export SQL table with images to Qgis

In MySQL Workbench 6.3 CE I created a table with some columns. One of this columns is of data type 'BLOB' to insert an image. Now i am looking for a way to export this table and import this table ...
1
vote
0answers
48 views

Using MySQL vector with QGIS?

I have a problem with mysql vector; when I connect to the MySQL table (containing a geometry column), the attribute table is loaded correctly, the map is centered properly but the geometries are not ...
1
vote
0answers
24 views

Querying for points within polygon in MySQL?

I have polygon in this format POLYGON(23.816364700000001 87.574939799999996 ,23.814872699999999 87.572279100000003 ,23.812595399999999 87.572279100000003 ,23.809925700000001 87.571678300000002 ...
0
votes
0answers
14 views

How to Aggregate data locations using 2010 Census block [duplicate]

I want to aggregate locations data specifically taxi drop off and pick points to census blocks to show taxi demand at a block level. I have a huge dataset of taxi drop off and pick up points around ...
1
vote
1answer
258 views

Adding custom polygons in google maps

Do you have any experience with adding custom polygons in to the google maps? I have made polygons from raster layer. And my goal is to show this layer in google maps. For now i have experience with ...
1
vote
0answers
41 views

mysql query to transpose latitude and longitude of a polygon

I have mysql table with shape column that stores the latitude and longitude, I need to write a sql query that transposes latitude as longitude and vice versa. I couldn't find any easy to get this ...
2
votes
1answer
46 views

Can qgis cooperate with phpmyadmin?

Can this two cooperate together? I am asking this, because I have database in myadmin with column for long. and lat. informations. Is there a way to connect qgis with myadmin? Or what type of ...
1
vote
0answers
17 views

How to show neighboring polygons and polygon in which point exists

We have a table which has polygon related data stored. For finding if a point (long,lat) is within that polygon I am using following query in mysql SET @vasantKunjSectorC = 'polygon((77.161266 ...
0
votes
0answers
44 views

Creating Tile server without using any Base Map

I have a database of points with coordinates on server (MySQL + PHP). I need to create a transparent (without an image of map) tiles with the points (one tile can be several points) format (x) (y) ...
3
votes
0answers
27 views

Optimisation of MySQL JOIN based on a Within match

I have a table of points and boundaries, and am trying to add the boundary ID which a point is within. However, using a LEFT JOIN ON Within(location, boundary) it is taking about 3.5 hours match ...
2
votes
2answers
768 views

Take data (points) from MySQL to Leaflet Map using PHP and Ajax

I have records with lat and lngs in a MySQL database and I want to add them to a Leaflet map as markers. I have tried a couple of methods but none seem to work. When the webpage opens the map doesn't ...
3
votes
1answer
708 views

Submit form information from a leaflet popup to MySQL table

I have a leaflet map and I want to have the user fill out a form in a leaflet popup and upon clicking the 'submit' button - the information in the form will be inserted into my MySQL database. As a ...
0
votes
0answers
107 views

How can I connect MYSQL database in python for QGIS desktop Application?

I am following below process. 1 - Setting You must install a MySQL driver before doing anything. Unlike PHP, only the SQLite driver is installed by default with Python. The most used package to do ...
3
votes
1answer
171 views

MySQL select linestrings into a multilinestring

I have a mysql column of linestring type with 2000 linestrings (high water mark values to be more specific). I want to merge them into one multilinestring so i can see what the shape of these values ...
0
votes
0answers
81 views

why did my python mysql script stop working, with error on fetchone()?

This code was working a couple weeks ago, then without changing anything, it started throwing an error. Here's the code: #Query climate table sFrom = dateIncrement.strftime("%Y-%m-%d ...
1
vote
1answer
75 views

Where to store lat/lon data with additional informations?

I have huge database of lat/lon GPS coordinate points. For every point, I have several other variables (height, surface type, temperature, pressure...). Also, data will be changed every day and old ...
0
votes
0answers
203 views

Geo spatial extensions in MariaDB vs MySQL

MariaDB is interchangeable with MySQL, but are there any differences in terms of each respective GIS features? Switching from one to the other is still a drop-in replacement with geo data types or ...
0
votes
0answers
92 views

What is the best way to store GML polygons in MySQL?

I have large .GML files with polygons of regions around the country, some are a single polygon, some are multiPolygon. What is the best way to store this in MySQL? I was assuming that I would ...
0
votes
1answer
29 views

Get percentage based on counts

I have the following query which gives me two columns store and customer_count...one row per store. SELECT a.id AS store,count(b.*) AS customer_count FROM stores a, customers b WHERE ...
4
votes
1answer
222 views

Find number of points within certain radius of a set of points

I have two tables. One is a list of stores (with lat/long). The other is a list of customer addresses (with lat/long). What I want is a query that will return the number of customers within a certain ...
1
vote
2answers
111 views

Make layer with TileStache from MySQL database

I am unsuccessful in attempt to make layer with TileStache whitch gets data from MySQL. I found simple MySQL table structure (http://howto-use-mysql-spatial-ext.blogspot.com/): create table Points ( ...
0
votes
0answers
71 views

Street maps with php and mysql

I am trying to create a website that can show how much the houses in the area are worth. I am able to get gis data, but not exactly sure what to do with it or what exactly is needed. I am extremely ...
3
votes
1answer
609 views

What are the limitations of using MySQL with ArcGIS?

I recently connected a MySQL database to ArcGIS by adding an OLE DB Connection. I can view the tables just fine; however, my XY data will not show up on the map directly from the MySQL table, I have ...
1
vote
2answers
392 views

Shapefile to Mysql error using ogr2ogr

I'm following this tutorial. I installed the “GDAL Complete” Framework from kyngchaos.com and I tested the installation on Mac. I have GDAL 1.11.2, released 2015/02/10. When I am trying to run this ...
0
votes
0answers
165 views

Installing mysql_fdw on Windows

I want to create a join between a spatial database (PostGIS) and a non spatial database from MySQL. Both databases have a unique ID who can be joined. I found a way to do this with PostgreSQL and a ...
0
votes
0answers
9 views

Shapefile (dbf) to MySQL conversion? [duplicate]

Is it possible to convert the exported data of shapefile to MySQL? I want to use MySQL instead of dbf since dbf are prone to corruption.
0
votes
0answers
18 views

Connect MySQL spatial database with ArcGIS10 [duplicate]

I'd like to know if there is any way to connect a MySQL spatial database with ArcGIS10. I use to connect these databases using ODBC driver but it doesn't work for spatial connections.
2
votes
2answers
94 views

escape quote in mapfile layer

I'm using mapserver 6 with mysql 5.5. It work like a charme, almost... The layer part of my mapfile is LAYER NAME "monsatR_mySQL" TYPE POINT STATUS ON CONNECTIONTYPE OGR ...
3
votes
0answers
348 views

Why are OGR (MySQL / PostGIS) connections extremely slow in QGIS 2.0 - 2.8 (when compared to QGIS 1.8)?

In our project we have been using QGIS 1.8 Lisboa with a MySQL database placed on a server accessed via local network since two years. Everything is working fine and quick. The vector layers can be ...
1
vote
0answers
82 views

Open source UML modeling software (GIS)

I am wondering is there any opensource UML to Postgresql Mysql tables conversion software which also includes the geospatial datatypes ? Note:I want conversion from UML to database. and NOT ...
0
votes
0answers
83 views

Problem with MySQL CENTROID() in 5.6

We're testing out an upgrade to MySQL 5.6 to take advantage of it's enhanced GIS functionality, and we ran into this problem: SET @mpoly = GeomFromText('MULTIPOLYGON(((0 0,0 2,2 2,2 0,0 0)),((0 4,0 ...
0
votes
1answer
94 views

MySQL primary key column not visible in QGIS 2.6

I've tried adding a vector from Mysql table (Mysql 5.1, MyISAM) to QGIS 2.6. All columns are visible except Primary key column(s). Could anyone confirm this behaviour? Could we consider it a bug?
2
votes
0answers
41 views

Can joined tables be served by QGIS Server WFS?

I'm trying to figure out whether it's just me, or if I'm forgetting a setting. I have a shapefile which I make available for WFS-requests. Now I added a join (to a MySQL table). I tried playing ...
0
votes
0answers
387 views

Exporting spatial object in mysql to shapefile with spatial reference

Info: Win7, MySQL 5.x and OSGEO4W 1.11 To import a shapeafile to MySQL I use this ogr2ogr command: ogr2ogr -f MySQL MySQL:gis,user=root,password=password C:\posto_pianco.shp -nln pianco_post -a_srs ...
1
vote
1answer
235 views

find lat,long inside polygon with regular interval of time using mysql

I have table latest location there i have lat and long with device id. one more table with fencing name,there i have polygon points. so now how i can check point lies inside polygon. i need this ...
2
votes
1answer
220 views

How to get coordinates by click on map and send coordinate to MySQL?

I'm building my own web map. Now I want to get the coordinates by click on the map and send the coordinates to MySQL. I tried OpenLayers to get the coordinates from Openstreetmap,but I didn't know ...
1
vote
0answers
61 views

how to use a database's table data in QGIS [closed]

I have already loaded a MySQL database as a layer, one of the tables contains data that are coordinates of some places, how to plot these data on a map(for example google maps)?
1
vote
0answers
96 views

QGIS MySql database queries over 4000

When i open file of QGIS 2.6.1 with 32 layers whose tables all come from the same database, i see that by just opening the file, QGIS already sends 4100+ "SELECT..."-questions to the database, and ...