Tagged Questions

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
42 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
13 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
413 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
71 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
119 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
51 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
49 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
25 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
36 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
36 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
97 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
18 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
31 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
0answers
48 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 ...
0
votes
0answers
23 views

Basic Intersect in mysql

I've looked all over but can't find a simple snippet of mysql spatial intersect. Does mysql support it? Does anyone have a working exmaple? Thanks
0
votes
1answer
222 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
108 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
52 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 ...
0
votes
2answers
60 views

How do I find major locations within postal codes from GeoNames?

I'm trying to narrow down my postal code table and limit the number or rows to 1 per postal code. I've not had a problem with Canada and the USA. However with Great Britain the data from GeoNames ...
0
votes
0answers
109 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
0answers
39 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
15 views

Update joined tables fields when the mysql database is updated

Using Qgis i joined feature tables with tables from my mysql database. I imported the database 's tables as new vector layers. Is there any way to update the joined tables fields each time mysql ...
0
votes
0answers
59 views

Geoserver Choropleth Map with Shapefile and MySQL Database

I'm learn to use GeoServer and i would know if it possible to bind Shapefile with MySQL Database ? (GeoServer) I would like get an choropleth map. I use this shapefile : ...
0
votes
1answer
69 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 ...
1
vote
1answer
281 views

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

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
32 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 ...
1
vote
1answer
171 views

Export XML Data to a MySQL DB

Hi I have a XML file which I created from the overpass api. I'd like to load this data from this file into a mysql database. I've been using this code to test, but none of the data loads. LOAD XML ...
1
vote
2answers
118 views

MySQL Polygon (Spatial) Insert Statement works sporadically

I know that MySQL doesn't have great spatial support at the moment, but is it that buggy that my insert statements would work sporadically? In general, longer coordinates seem to be failing on insert ...
0
votes
0answers
140 views

Merge long/lat points within a bounding box depending on a radius in MySQL

Here is a pic of what I basically want to achieve: http://i.stack.imgur.com/gjbfa.png So as the title says, I want to merge long/lat points which they're radius (of 25Kms for example) touch inside a ...
2
votes
1answer
503 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 ...
3
votes
1answer
372 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 ...
0
votes
2answers
197 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
1answer
155 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 ...
0
votes
0answers
45 views

How to export QGIS elevation data to Mysql WAMP

is there a way to export elevation data from QGIS to wamp server(mysql)? please help me. I need to store all the data to mysql wamp.. thanks!
1
vote
0answers
80 views

Is there a pgRouting-like library for MySQL?

As described in the OsmDB.pm page I have created a schema in MySQL from an OSM file. Now I have to find the length of the shortest path between two given points (preferably using the A* algorithm). ...
2
votes
1answer
84 views

How to use GDAL to import lat/lon points from ESRI File Geodatabas into MySQL

I have a file geodatabase from here: ftp://ftp.csc.noaa.gov/temp/MarineCadastre/AIS.SampleData.zip Using ogrinfo, I can see that it contains a layer called "Broadcast_" that has lat/lon points: ...
0
votes
0answers
29 views

Overlapping of two layers in MySQL spacial extensions

I have been into GIS for almost a week now. Right now, I am learning MySQL spacial extensions. I have a question regarding the functions MySQL provides: I have a table that consists of LineString, ...
0
votes
0answers
50 views

PoI Range query

I have a dataset of 100,000 PoIs represented by (id, name, longitude, latitude).. I would like to perform a large number (around 10,000) search operations on this dataset. each search operation ...
0
votes
0answers
67 views

Best OpenSource Database to serve images on web?

I am using a mysql database where I store images as blobs. From here, I serve them on the web. Does anyone know if there is another opensource option that works better? I would need something to ...
1
vote
0answers
51 views

Web Application/Android Application [closed]

I want to develop a web application/android app which has following functions. Runs OpenStreetMaps Creating Markers Changing colors of the markers Connecting all to a MySQL Database Please let me ...
1
vote
1answer
129 views

is MySQL spatial ready for production?

currently I'm using PostgreSQL/PostGIS for a small spatial project. Last week the project manager asked me if we could migrate to MySQL with Spatial Extension. I know MySQL but have no experience ...
1
vote
1answer
125 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 ...
3
votes
2answers
466 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 ...
1
vote
2answers
248 views

Connect AutoCAD Map 3D 2014 with MySQL

I need to connect AutoCAD Map 3D 2014 with an Spatial MySQL database (version 5.5) but first I have to install "libmysql.dll" to connect as specified in the software user's manual. This file is ...
0
votes
1answer
134 views

Query MYSQL database inside a python plugin

I am new to QGIS python development and I have a requirement to query the database and depending on the result do some processing in QGIS. I found how to create a connection to mysql db on python ...
0
votes
0answers
62 views

Export additional data with ogr2ogr

I am trying to import my ESRI-shapefile with OGR2OGR to an existing mysql table. This works fine but unfortunately only the featureID and the geometry data is exported. How do I add the labels of the ...
1
vote
1answer
331 views

Geoserver - problem with MySQL support (impossible to create MySQL store at all)

I need to access spatial data in MySQL database with Geoserver. Official user manual states: just download package, extract it into WEB-INF/lib directory and all will be OK. Instead, just nothing ...
0
votes
0answers
104 views

How to select features within a distance using mysql?

I have create a table (munuments) that holds some monuments. Given some location (lat,lng), i wanna get all monuments on the same city, where i am. This is trivial, with reverse geocoding using ...
1
vote
3answers
505 views

Simple WMS server

Is there a way to implement a WMS server using only php or python cgi and mysql? I can't use geoserver or mapserver and postgres and any other software as they are not provided by the administrator.
0
votes
0answers
11 views

Can we use bounding box with Mysql? [duplicate]

I need to show the data from the database, but only those data in the current user's view. I need bounding box option for that. Is it possible with mysql?