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
3k 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> <styleUrl>#m_ylw-...
3
votes
1answer
311 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 ...
1
vote
0answers
262 views

ogr2gr loading spatial data into mysql

I am trying to load shapefile into mysql (MYISAM) using ogr2ogr and i get an error that says failed to fetch the requested layer. What could be wrong with my statement is it the issue with quotes or ...
1
vote
0answers
19 views

How to style GeoJSON features with attributes from MySQL in Openlayers 3

I got some GeoJSON-features from a file. The attributes of the features are stored in a database (MySQL), because I need them there for some interactions with users. On the other hand some of these ...
1
vote
1answer
210 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 ...
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
1answer
350 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 ...
3
votes
1answer
47 views

ArcPy: Connect to MySQL database

My project aims at updating automatically point feature classes in a ESRI local geodatabase using MySQL tables with X,Y coordinates. The updates should be launched with the Windows task-scheduler. I ...
1
vote
1answer
47 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 ...
4
votes
2answers
617 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 ...
0
votes
2answers
79 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
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), ...
2
votes
0answers
175 views

Populating ESRI GeoPortal programmatically? [closed]

I'm trying to find either some documentation or an example of how to manually populate the GeoPortal metadata datastore. I'm using a MySQL backend. Given a ISO XML file I can manually harvest it but ...
1
vote
1answer
49 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
2answers
110 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 ...
1
vote
1answer
711 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, ...
0
votes
1answer
32 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
21 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
43 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
37 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
80 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
42k 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
29k 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
75 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
60 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
76 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
102 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
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
75 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
181 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
298 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
39 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
95 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
vote
2answers
107 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
90 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
44 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(...
6
votes
1answer
8k 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
300 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
2k 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
97 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
66 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
78 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
78 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
105 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
87 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
30 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
97 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
35 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 ...