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

learn more… | top users | synonyms

5
votes
1answer
711 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 ...
3
votes
1answer
522 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
141 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 ...
1
vote
1answer
154 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 ...
2
votes
0answers
15 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
59 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
0answers
247 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 ...
2
votes
0answers
175 views

How can I improve my Ray casting algorithm?

I have been using the following function below which have been working well to decide if a point in the polygon but once I have many points which is building the polygon say over few thousand it seems ...
2
votes
0answers
256 views

Different results given by PostGIS and MySQL?

I'm developing a spatial database of administrative areas. I started out with PostGIS, but as MySQL is being used in our other projects, I thought I would at least try to create a spatial-enabled ...
2
votes
0answers
360 views

How to access mysql data from python built-in console?

I'm writing a QGIS Plugin, and somewhere I want to present data from a MySQL database. It's simple data(strings,etc), not Geospatial, or vector data. I'm familiar with querying databases from python ...
2
votes
0answers
147 views

How to populate ESRI GeoPortal programmatically?

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
0answers
26 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 ...
1
vote
0answers
88 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
0answers
40 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
40 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
0answers
68 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
0answers
125 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 ...
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 ...
1
vote
0answers
87 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). ...
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 ...
1
vote
0answers
172 views

GeoTools: SimpleFeatureCollection to KML error CoordinateReferenceSystem

I want to export a SimpleFeatureCollection (Read from a MySQL DB) to a KML file, here is my code used to read the infos into the console: private void featureCollectionToKML(SimpleFeatureCollection ...
1
vote
0answers
314 views

Problem importing ESRI shapefile information to MySQL

I recently updated to Qgis 2.0 and therefore the "exporttomysql" plugin does not work anymore. What I want to do is exporting the geometry information of a shapefile(Polygon) into a MySQL database. I ...
1
vote
0answers
169 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
451 views

Check if a point is near a linestring with MySQL Spatial Extension (untrustable)

I have to discover if a given point is at least 500 meters (ou other distance) from a route line that exist in my database recorded using the MySQL Spatial. I see there is no similar function in ...
1
vote
0answers
67 views

Solve Mysql Spatial error

Converting shp2mysql will leads an null value in geom filed. how to rectify the the problem. shp2mysql -s 32643 landuse landuse LIS >landuse.sql
1
vote
0answers
59 views

how to use ArcGIS cloud hosted map with custom data from mysql

I have map hosted on ArcGIS.com which I can use and embed in my webpage. I have few tables with latitude-longitude in mysql. is there anyway I can add it as marker overlay layer on map taken from ...
1
vote
0answers
401 views

OpenLayers & MySQL

I have a MySQL database full of data about students (name, age, school, university, city, etc). What I want to do is to transform the data I got to markers on the map. To be more specific, I will for ...
1
vote
0answers
24 views

How to make some constraint to be evaluated first in mysql?

SELECT BusinessID FROM tableauxiliary WHERE MBRContains( GeomFromText ( 'MULTIPOINT(-6.1928749092968 106.7651250907,-6.1771250907032 106.7808749093)' ), ...
1
vote
0answers
113 views

refactoring an XSLT processor with minor changes

having an extremely large xml-file - which is derived from the field of geo informatics. i got it from a German subsite or the OpenStreetMap-Project: the Geograpical-Engineering-site that deilvers a ...
0
votes
0answers
10 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
46 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 ...
0
votes
0answers
19 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 ( ...
0
votes
0answers
29 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 ...
0
votes
0answers
21 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
42 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: ...
0
votes
0answers
28 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
0answers
133 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
44 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
75 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
0answers
40 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 ...
0
votes
0answers
188 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 ...
0
votes
0answers
54 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!
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
54 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
69 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 ...
0
votes
0answers
67 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
110 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 ...
0
votes
0answers
24 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
0answers
751 views

Convert a decimal degree to meters from the MySQL Spatial GLength

The MySQL Spatial function GLength returns the distance between two points, this distance is in the same unit from the projection. Since I'm using the WGS84 (SRID:4326) the answer will be with ...
0
votes
0answers
484 views

Implementing custom (Vincenty/Haversine formula) functions for MySQL vs Using PostGIS?

I currently am using MySQL for all of my relational data. I have hit a crossroads with geo calculations. Since, MySQL does not have good support for spatial functions, I am contemplating on using ...