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
67 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
102 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 ...
2
votes
2answers
503 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
722 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
0answers
33 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
2answers
423 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
2k 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
156 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
90 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
110 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 ...
1
vote
1answer
244 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
56 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. ...
0
votes
0answers
184 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 ...
1
vote
0answers
17 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
104 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
93 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
421 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
62 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
802 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
363 views

Postgis csv and error loading into mysql

I want to load spatial data into MySQL using a CSV I have generated from a Postgres table and when loading it into MySQL database using phpmyadmin it complains "Cannot get geometry object from data ...
1
vote
2answers
384 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 ...
1
vote
1answer
357 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 ...
0
votes
0answers
234 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 ...
7
votes
3answers
18k 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. ...
0
votes
1answer
248 views

How to export Spatial data from MsSQL to MySQL using OpenSource/Free tools

I have a few tables with geometry fields in MsSQL Server 2008. I would like to export the whole table with data to MsSQL Server. Are there any open source/free tools that does this job?
1
vote
1answer
493 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 ...
2
votes
1answer
1k views

QGIS 2.0 without MySQL connector

On a mac (Mountain Lion), after a major upgrade to GDAL (1.10) and related frameworks from KyngChaos page, QGIS 2.0 doesn't show any MySQL connector: Add Vector > Database > ... The driver ...
1
vote
2answers
371 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 ...
4
votes
3answers
2k views

Moving from MapInfo to web mapping

I use MapInfo and have a lot of data in .tab format that I would like to put into a database in order to access it through a website. I would like to continue using MapInfo as my GIS programme and ...
2
votes
1answer
110 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: ...
1
vote
0answers
117 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). ...
0
votes
0answers
31 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
58 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 ...
1
vote
1answer
519 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
0answers
65 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 ...
8
votes
5answers
13k 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
1answer
182 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
80 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 ...
0
votes
0answers
122 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
742 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.
3
votes
1answer
417 views

Why is GeoNetwork not displaying any maps?

I've just installed GeoNetwork 2.6.4 on CentOS 6.2 using MySQL as the database backend. Now, when I go to the web interface, I see the main web site, but no maps are displayed. On the geonetwork ...
0
votes
1answer
48 views

Could SQL performance be increased by storing rotations of the data?

I'm working on a project where this kind of SQL Psuedocode would apply: SELECT * FROM objects WHERE (distance My inputs are latitude and longitude, and my database holds latitude and longitude. ...
1
vote
1answer
464 views

Postgis functionalities in Microsoft SQL Server

I'm using Postgresql 8.4, Postgis 1.5 for My GIS works. Planning to change my Database to Microsoft SQL Server 2012. Can we use all the Postgis functionalities in Microsoft SQL Server 2012. Please ...
3
votes
2answers
1k views

How did QGIS fix a shapefile's character encoding, and can I do this on the command line with ogr2ogr?

Solved: I'm not sure why, but it works fine if I specify --config SHAPE_ENCODING "ISO-8859-1" in my ogr2ogr command. For whatever reason, this allowed ogr2ogr to go from the original TigerLine ...
1
vote
1answer
371 views

Error during conversion of shapefile to MySQL using ogr2ogr

I have installed MS4W in Windows 7. I get an error when I try to convert a shapefile to MySQL database using GDAL/OGR ogr2ogr. This is the command I'm trying: C:\ms4w\tools\gdal-ogr>ogr2ogr -f ...
3
votes
1answer
712 views

Does MySQL only support bounding boxes calculations instead of the real polygon geometry?

Within our company we are deciding which DBMS we will use to store spatial data. IT wants MySQL with the Spatial extension because there is already knowledge about handling MySQL DB. We are doing ...
0
votes
1answer
3k views

Does MySQL has function which will return the points inside polygon?

I have MySQL database with polygons, and also the database with points (column longitude and column latitude), is it possible to return all points inside one polygon? Thanks!
1
vote
0answers
2k views

Google map did not update new geolocation when I moved the marker to new position

This is my google map code. I'm trying to update new latitude and longitude when i moved the existing marker to new position. But I don't understand why the following google map code is not updating ...
0
votes
0answers
30 views

Backup in Mysql periodically

I have trouble scheduling a backup in mysql periodically, most of the tools do not recognize the geometric field, for example navicat which says Can not get geometry object from data you send to ...
0
votes
2answers
569 views

Spatial databases in location based search

I'm developing a location based application in which i was in the plan of dividing the globe into grids and when the client requests information, will create a table or similar data model which will ...