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
15 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 ...
2
votes
1answer
16 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
23 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
47 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
59 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
39 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
25 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
131 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
76 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
39 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
103 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 ...
0
votes
1answer
109 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
92 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
8 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
16 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
55 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 ...
2
votes
0answers
241 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
52 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
50 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
56 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
24 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
107 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
121 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 ...
1
vote
1answer
129 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
43 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
71 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 ...
2
votes
0answers
150 views

Get Distance between two point on linestring using mysql Spatial

I have a linestring and two point on this linestrin according to my picture i want distance between two point as base of linestring please hellp me
2
votes
0answers
3k views

How to get multiple dynamic custom markers on map using MapBox in MySQL and PHP?

Can anyone help me to get multiple custom markers on mapbox using lat/long from the database MySQL. I want to use 2 types of markers on the map, for which I have two separate table of lat/longs in the ...
2
votes
1answer
103 views

Why are a polygon's vertices jumbled after importing KML into MySQL?

This is original KML : <Polygon><outerBoundaryIs><LinearRing><coordinates>104.700355,-3.056064 104.632127,-3.103623 104.608924,-3.103169 104.570166,-3.102411 ...
1
vote
1answer
173 views

How to find a point on linestring and in a range of 10 meter

i have a linestring which is show in diagram and i have a point which is some time on the linestring or out of linestring but in range which is red line and some time its is out of range so how can i ...
1
vote
0answers
248 views

Route tracking on google map php

i have to make a software which is track a vehicle on Google map using GPS. I have almost done this project but i am stuck at a point, the client require a system that track the bus in a route. I am ...
0
votes
0answers
15 views

mysql data automatically updates

Is my sql data automatically updated in qgis? We have connected the mysql with qgis but data is not updated automatically. Is there any other way to connect the datasource with qgis?
0
votes
0answers
82 views

GIS Street Maps

I am extremely new to GIS, but very interested in it. I am trying to create a php application that can display a map, and based on the address show like a 1 mile radius all around and the color each ...
1
vote
1answer
432 views

What options are there for geolocation-aware SQL databses?

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
0answers
45 views

Distance Hexagons in CartoDB

I found this blog very interesting and the maps very cool. The code used to produce the hexagon distance maps is not working for me however. This is the code used (from github): select * from ( ...
5
votes
3answers
2k views

How to know if a point is inside a rectangle on the map?

I have four points that represent a rectangle (a,b,c,d). I got these points from mobile GPS. In my database I have this table of business locations: bussId | longitude | latitude ...
2
votes
1answer
502 views

Import MySQL data to QGIS with a plugin

Does anyone know about a plugin that can import a MySQL database into QGIS?
0
votes
3answers
353 views

Read GeoTIFF file with php or javascript

Sorry, I am newbie with GeoTIFF files. I want to create a project that a person can upload a GeoTIFF file and the web application saves the lat/long of the picture into the database, the server side ...
1
vote
0answers
149 views

How to check if a point is within bounded rectangle from Java

I make an AJAX request to retrieve data from a mysql database. I add the data to google.maps.Data layer as geojson. I would only like to load the data based on the viewport. To obtain the viewport ...
1
vote
1answer
130 views

Java library for reading geojson from MySQL

I am looking for a way to retrieve mysql geometry data as geojson from the database either using a java library or for converting wkt to geojson using either java or javascript. Currently I am doing ...
0
votes
0answers
46 views

MySQL Select rows where line strings are within a bounding box

I have a MySQL DB with some spatial data stored in a table after being input via ogr2ogr from a shapefile. The structure is similar to the following: OGR_FID int SHAPE geometry (all line ...
1
vote
0answers
51 views

how manage mysql spatial polygons in parent child style

I want to store location-polygon data in a parent-child relation. I am using spatial data in MySQL and Google map for polygon. Eg: World 1.1 US 1.2 China 1.3 Japan 1.4 South Africa 1.4.1 Pretoria ...
1
vote
0answers
67 views

QGIS crashes when trying to display features form MySQL

I import shapefiles into MySQL using the following command: ogr2ogr -f MySQL MySQL:GIS,host=localhost,user=root,password=root /home/user/Public/myshape.shp -nln Shape_table -update -overwrite -lco ...
1
vote
2answers
181 views

Choosing web mapping API to use with MySQL for making map of one country? [duplicate]

I hope this question isn't too general, but I'm new to using maps, I'd like to make a map of one country on which I can plot points according to their geocodes from my mysql database, and to have the ...
0
votes
0answers
28 views

Where is user from 'manage.py migrate' stored?

I'm following Geodjango setup as described here: https://docs.djangoproject.com/en/dev/ref/contrib/gis/tutorial/#introduction When accessed localhost/admin/ to get to admin page, I get username\pass ...
0
votes
0answers
80 views

mysql foreign data wrapper for postgres with parameter substitution

I have created a mysql_fdw for my postgres and when i try to run the one with a subquerry that has parameter substitution it does create a table but on querying the foreign table it throws an error: ...
1
vote
1answer
149 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 ...
1
vote
1answer
1k 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> ...
1
vote
0answers
213 views

Openlayers Map Marker / Popup Behaviour Mobile Devices

Quick overview. i am creating a site with a map using Openlayers and Open Street Maps. User clicks on map and fills out a popup form and submits form. Markers appear at lonlat points where map was ...
0
votes
1answer
119 views

converting random point order into polygons

We received a kml file with polygons but the points are not in a logical sequence and we end up with strange overlapping shapes that are supposed to be an open polygon. We did identify a point near ...