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

learn more… | top users | synonyms

3
votes
1answer
608 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
0answers
165 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 ...
2
votes
2answers
326 views

Aggregate/dissolve MySQL geometry

On Centos, I have a MySQL 5 database with a MyISAM table that has a geometry column with a spatial index, containing US county boundaries. Trying to combine/aggregate/dissolve some of these into as ...
0
votes
0answers
9 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
18 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.
1
vote
1answer
1k views

geoserver wms layer is very slow

I am using open-layers to display a map and I have vectors layer with some features that I'm loading with ajax from MySql, and I'm using geoserver to load all the background from shp files(like ...
2
votes
2answers
94 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
6k 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 ...
1
vote
0answers
82 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
83 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
94 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?
0
votes
0answers
384 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
233 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
0answers
61 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
1answer
239 views

How to get a centroid of a closed line in MYSQL

I have a table that contains only closed lines (lines where endpoint is the same as startpoint). I would need to find a centroid for those lines. How would I be able to achieve it? It does not ...
0
votes
1answer
508 views

PHP/MySQL, PostgreSQL spatial queries. Find a polygon that contains a coordinate? [closed]

I am building a non mapping javascript app and I am wanting to take a lat/long coordinate and query a MySQL table of polygons for the one that contains the point. I have looked into MySQL spatial ...
1
vote
0answers
96 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 ...
0
votes
1answer
418 views

Getting fail to store Polygon Shape Object in Geometry Datatype with hibernate spatial API

Tried to store Polygon shape in database with HibernateSpatial API. I have followed this tutorial to store values. I am using Mysql as my database server. So Made some couple of changes for my ...
2
votes
0answers
182 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
1answer
150 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
290 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
362 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 ...
5
votes
1answer
6k views

Establishing a MySQL connection in ArcGIS 10

Is it possible to create a connection to a MySQL database in ArcGIS 10?
0
votes
0answers
124 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
3answers
550 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
1answer
579 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, ...
2
votes
1answer
8k views

How to geocode addresses from MySQL and add them like markers to the Google map?

I'm using Google Maps API and Google Geocoding for geocoding addresses. I have table named 'users' and column named 'location' in MySQL database. Column 'location' contains addresses. I need to ...
6
votes
3answers
3k 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
1k views

Import MySQL data to QGIS with a plugin

Does anyone know about a plugin that can import a MySQL database into QGIS?
2
votes
0answers
235 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
198 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 ...
1
vote
3answers
575 views

Create ESRI shape file with attributes from mySQL

I have some geometry which can be perceived as regions within a country and wish to create a shape file which contains all the regions along with some attributes (e.g. name, population, area code, etc ...
2
votes
1answer
843 views

Reverse Geocoding - calculate every time, or store result in database?

Several questions, such as this one, discuss whether to store only lat/long in the database & calculate the street address every time it is needed, but they seem to miss a few points & seem to ...
1
vote
0answers
60 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
74 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
220 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
115 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: ...
2
votes
2answers
601 views

Map Coordinates to Neighborhoods from MySQL Table

I have a MySQL database with a set of coordinates and a shape file (Zillow Neighborhood Database for Chicago) containing the boundaries for each neighborhood which I have converted to a spatial ...
0
votes
2answers
2k views

How to join MySQL database to QGIS polygons

I Have an *.sql file that has no spatial information. For every record there is an id. I also have a Qgis project with polygons without any id. How can i connect the polygons with the database? I ...
0
votes
2answers
508 views

storing images in mysql from WebGIS applications

I'm a complete amateur at writing code. I would like to make an application for storing LNG, lat, and other data, as well as images in mysql. I've set up, I made a separate application for storing ...
1
vote
1answer
5k views

How to find points inside each polygon in Mysql?

I have points table (with latitude and longitude columns) and polygons table with geometry stored in Mysql. I want to get points inside one polygon, for example in polygon which has column ...
1
vote
0answers
274 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
173 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 ...
1
vote
1answer
292 views

Converting Heatmap into Grid of Points to regenerate less accurate Heatmap?

Question: How do you take a heatmap generated using a GIS software (arcgis, qgis...) and convert it into a uniform grid array of points which can be used to regenerate the heatmap (although with ...
0
votes
0answers
76 views

schools are included as nodes, while others are areas - how to get all of them?

goal: want to extract schools from Overpass-api: now with an update: the allready exinsting code runs nicely. At the moment it is no problem that i do not catch the shools as ways nodes or rleatins. ...
1
vote
0answers
304 views

parsing an osm-file with PHP simpleXML :: getting a few more tags

I am new to PHP's SimpleXML. upate: The original version of this question was derived from here: OSM Data parsing to get the nodes with child I am thankful that hakre offered a great example in ...
0
votes
1answer
149 views

MYSQL 5.6 Cluster / chain points by distance to any other point without millions of calculations?

I have a table of approx 10,000 - 20,000 dynamic points across the globe stored as lon/lat points. I want to cluster any point within (roughly) 3km of any other point into one point (and return the ...
0
votes
1answer
670 views

overpass-api or osmconvert: which method is more appropiate to use for files from 10 to 400 mb? [closed]

new to openstreetmap and this technology. update: some mentioned postgis: well - The database schema of postgis allready contains the following tables: nodes, ways, relations, node_tags, way_tags, ...
0
votes
0answers
94 views

Can I update my Goole Earth browser in real time?

I am about to start a project that will entail updating my Google Earth browser with data from a MySQL database package (WAMP) like is the case for web pages, but after thinking about it I really did ...
3
votes
2answers
1k views

CartoDB - update existing table from external data (i.e. Mysql database)

I would like my CartoDB data to be updated, using external data (mysql database, I run and manage locally using php scripts), so that the CartDB table gets updated with the most recent data, whenever ...