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

learn more… | top users | synonyms

0
votes
0answers
3 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
0answers
29 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
29 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
21 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.*, ...
-3
votes
0answers
17 views

Integrating WAMP with ArcGIS

How can I integrate WAMP with ArcMap in order to dynamically query from the MySQL database and display a pointer in ArcMap? This is intended for real-time vehicle tracking.
4
votes
1answer
54 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
37 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
23 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
52 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
11 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
31 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
140 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
35 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
30 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 ...
0
votes
2answers
54 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 ...
-1
votes
1answer
43 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
25 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 = ...
2
votes
1answer
51 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
91 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
57 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
41 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
176 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
55 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
51 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
83 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
62 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
24 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
74 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
31 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
327 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
66 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
61 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
23 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
50 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
28 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
2k 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
1k 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
142 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
251 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
121 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
89 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
261 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
115 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
31 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
260 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
127 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
966 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
520 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
110 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 ...