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
35 views

Convert Ordnance Survery (GB) Easting/Northing data to WGS84 lat/long

This is my first venture into GIS datasets. I've decided to start a little project which will eventually hook into the Google Maps api to overlay/plot/pin from data in my database. I've started ...
0
votes
0answers
28 views

Define points within multiple lines

I have points set in certain radius. I want to define points within certain lines which represent natural and structural borders (streets(red), rail road tracks(green), water barriers(light blue), ...
0
votes
0answers
18 views

Do not see any map in MySQL Work Bench spatial view

I am following this link where it says the spatial view in MySQL Work Bench shows GIS data overlaid on top of a map. I have MySQL 5.7 and MySQL Workbench Community (GPL) for Mac OS X version 6.3.5 CE ...
1
vote
1answer
42 views

Problem loading from MySQL in QGIS 2.10 on Mac

I cannot load a vector layer from MySQL in QGIS 2.10 (Pisa) on a Mac. If I goto Layer -> Add Layer -> Add Vector Layer -> Database I do not see MySQL in the drop down. I found this link. I did not ...
0
votes
0answers
39 views

MySql - Location tagging like Instagram

I want users to tag a location using google place search, save it to database and make it so others can find it by city, country or state... A good example is Instagram What I tried: store cities ...
2
votes
0answers
30 views

Find closest points between two tables in MySQL with Spatial extensions

I have a two tables: one with trackings points and one with shops. I want the trackings points that have 1 or more shops within a certain distance from that point. What I have now: SELECT a.*, b....
4
votes
1answer
77 views

How do I update joined data from MySQL programmatically?

I have a point vector layer (Sensores) in my QGIS project, I also have a MySQL database layer (SensoresDB) containing only data. I have joined these two layers in order to geographically reference my ...
1
vote
0answers
62 views

Geojson taking long time to load in google map from database

I am trying to load a GeoJSON file from a MySQL database but it is taking about 6-10 seconds to load the data into the map. This is what I have done so far. I generate a GeoJSON file after doing a ...
0
votes
1answer
30 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? ...
1
vote
3answers
71 views

Querying dataset with .shp file?

I'm new to GIS tech. Please excuse me since I'm not yet familiar into using GIS. I will be using a very large dataset (yfcc100m dataset, a dataset containing metadata of Flickr's photos/video) which ...
0
votes
0answers
15 views

QGIS and mysql administration - How to update a multiple select values

I have a mysql DB with spatial information. I would like to admin this DB from QGIS. I have the following situation: TABLE_A id | title | point 1 | item1 | point(x1,y1) 2 | ...
0
votes
1answer
61 views

Plotting lat long on World Map [closed]

I have lat long coordinates of various merchant ships of the world, say 50000. And I have around 100 instances of coordinates (lat long) of each of these ships at various timestamps. I have them on ...
3
votes
2answers
165 views

How to show QGIS maps in android application?

I have created map using QGIS software and trying to display data-set records on that map. Also developed android application where user want to see that map. But I am stuck in how to show this QGIS ...
1
vote
1answer
55 views

MySQL database layers invisible in QGIS

I'm encoutering a problem when connecting a MySQL database to QGIS. When the connection is established and a layer is imported, the layer itself will not render and thus isn't visible. The layer ...
1
vote
0answers
36 views

Ogr2ogr: Shape to MySQL. Delete (or ignore) “geometry_columns” and “spatial_ref_sys”

Im exporting a shapefile to my MySQL database. But as standard it also add the additional metadata tables: "geometry_columns" and "spatial_ref_sys" Is there a way to either delete these tables or ...
1
vote
2answers
90 views

Reduce query time when using both MySQL and PostgreSQL with PostGIS

I am doing a tracking query. The device is sending its location data, timestamp to store in MySQL Database. I want to show the query result of every point with its nearest POI. The POI database is ...
0
votes
2answers
78 views

Displaying MySQL database as layer on map?

I have a mysql database with lat/long/name and I would like to show them on the map as a layer (that is if I update my database you would see the changes when you reload the page or redraw). Esri ...
2
votes
0answers
37 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 = SQLAlchemy(...
2
votes
1answer
80 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
159 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
2answers
91 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
57 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
267 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
70 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
63 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
98 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
79 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
28 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
83 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
33 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 ,23....
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
378 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 ...
0
votes
0answers
84 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
69 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
32 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 28....
0
votes
0answers
51 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
32 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 450,...
2
votes
2answers
3k 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
2k 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
165 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
291 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
136 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 %H:%M:%S"...
1
vote
1answer
102 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
1answer
33 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 ST_DWithin(a....
4
votes
1answer
287 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
135 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 ( ...
3
votes
1answer
1k 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
598 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 ...
2
votes
2answers
123 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
405 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 ...