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

learn more… | top users | synonyms

2
votes
1answer
276 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
1answer
623 views

What options are there for geolocation-aware SQL databses? [on hold]

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, ...
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? ...
0
votes
0answers
259 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 ...
1
vote
0answers
25 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
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 ...
0
votes
0answers
28 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 ...
5
votes
1answer
1k views

Calculating distance in WGS84 (MySQL and Geoserver)

Here is the environment in which I work: An application using geo-referenced data Database MySQL 5.5, storing georeferenced points A Geoserver server, connected to the MySQL database Here is the ...
2
votes
0answers
20 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.*, ...
4
votes
2answers
508 views

Plotting X, Y coordinates generated from MySQL database in QGIS

Currently running QGIS 1.8.0 on Mac OS X 10.8.4. I can plot points on a map using the "Add delimited text layer" plugin to get x-y coordinates from a text file. However, I'd like to be able to ...
1
vote
1answer
2k views

Creating MySQL database for storing imported KML?

I need to create a MySQL database for storing coordinates from a KML file with the structure as follows: <Placemark> <name>someplace</name> ...
-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.
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 ...
4
votes
1answer
53 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 ...
10
votes
3answers
37k views

Find points within a distance using MySQL

I have a mySQL table with user name, latitude and longitude of the user. I would like to get a list of user who are inside the circle or square of a given latitude and longitude with given distance. ...
11
votes
10answers
26k views

How to Geocode 300,000 addresses on the fly?

I have a database which has 300,000 address, which are to be shown on map. I know if I geo-code all the address it will be too expensive for me. So I was wondering if it is possible to geo-code the ...
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 ...
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
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 ...
1
vote
1answer
96 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
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 ...
5
votes
2answers
297 views

Should We Be Using a GIS? [closed]

I'm actually a graphic designer - the manufacturing company I work for wants to develop a map with layers for Regional Sales Managers territories, Internal Sales Associates territories, Local Rep ...
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
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 ...
-1
votes
1answer
42 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 ...
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 ...
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 ...
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 = ...
1
vote
1answer
88 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
56 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 ...
6
votes
1answer
7k views

Converting Shapefile to MySQL?

I have used Grass GIS imported a .shp file; I now want to export this file to MySQL. I understood that MySQL will contain the function of all three the files necessary in a Shape file system (.shp - ...
1
vote
1answer
171 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. ...
5
votes
2answers
1k views

Large loads geojson from mysql to leaflet?

I have a mysql database with +25K rows including geometry and other attributes. Using a mysql2geojson php script I then added it to a leaflet map. It is super slow now, what can I do to boost the ...
1
vote
1answer
90 views

Get all points with in some range of a point (or range of point) in MySQL

I have got a list of points and a fixed range (10m). So what I have to do is for each point I have to find all the points present in a table with the 10m range of the given point. For example: Let ...
1
vote
1answer
190 views

Check Personal Geodatabase attribute against external MySQL database?

I have a Personal Geodatabase to which editors enter values from some field inputs. I would like some of the entries, eg Project No ( whose name is unique and has some some related attributes like ...
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
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
61 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 ...
2
votes
1answer
44 views

Update joined table fields when a MySQL database is updated

Using Qgis I joined feature tables with tables from a MySQL database. I imported the database's tables as new vector layers. Is there any way to update the joined table's fields each time the MySQL ...
1
vote
1answer
326 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 ...
2
votes
1answer
60 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 ...
2
votes
1answer
350 views

Connecting CartoDB to existing MySQL database

I'm trying to create a simple heat map based on longitudinal and latitudinal map coordinates that can be transferred from a database on MySQL that I've created. I read that CartoDB can be connected to ...