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
59 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
1answer
100 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
46 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 ...
7
votes
5answers
8k 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 ...
0
votes
1answer
119 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 ...
3
votes
3answers
2k views

mysql database of bars, pubs and restaurants in the united states and maybe canada

I am mostly seeking Bars and Pubs but Restaurants are a very nice bonus. I need a database with zipcode, city, state, longitude, latitude, establishment name, establishment contact information, maybe ...
0
votes
0answers
59 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
84 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
392 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?
0
votes
0answers
170 views

Compiling MySQL and Sqlite drivers for GDAL/OGR 1.10.1

IF YOU WANT SHORT QUESTION GOTO QUESTION SECTION I have builded GDAL 1.10.1 with the instructions in BuildingOnWindow. By the default OGR drivers dont support MySQL, PostgreSQL/PostGIS, Sqlite, ESRI ...
3
votes
1answer
351 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
46 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
236 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
958 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
267 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
566 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
1k 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
1k 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
22 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
1answer
327 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 ...
0
votes
2answers
281 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 ...
2
votes
2answers
528 views

MySQL with geoserver

I am storing all my features in mysql db and I am getting them with ajax and adding to the openlayers map. Now I have to many features and it's taking a lot of time to get all of them and adding them, ...
1
vote
0answers
146 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 ...
5
votes
3answers
243 views

Should We Be Using a GIS?

I'm actually a graphic designer - the manufacturing company I work for wants to develop a map with layers for Regional Sales Managers territories, Internal Sales Associates territories, Local Rep ...
1
vote
1answer
570 views

Creating database for climate data with MySQL

I'm working on a project using climate data and MySQL. Before I start to work, what's your advice on the best way to complete this task. I plan on using the following workflow: Analyse the ...
0
votes
1answer
284 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 ...
2
votes
1answer
159 views

Fast zipcode detection from latitude/longitude

I need a way to get the zipcode of a lat/long pair fast (<10 ms), and at a high rate (thousands of qps) I've loaded a shapefile from the US Census Bureau into a mysql database with spatial ...
1
vote
1answer
71 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 ...
1
vote
0answers
233 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
1answer
206 views

How to set style in the database (QGIS)

Is it possible to set style layers in the database? (QGIS) [MySQL database] I would like to set and share my style to other users when they open the layer it's still as my style. Thank you
0
votes
1answer
115 views

Creating an Address Locator with a Database of Geo Information

I am trying to build an Address Locator for ArcGIS 10.1. I would like to use a Microsoft Server MySQL database where location information is stored using an alias, an address, and XY coordinates. What ...
2
votes
0answers
140 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
128 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
2answers
174 views

Mysql to nosql. Best solution?

We are working on our new vehicle tracking system. We have been making use of mySQL for the past two years. However we have been discussing moving to a noSQL database. We have a high number of reads ...
4
votes
1answer
10k views

Drawing polyline that grows as the car moves by taking data from MySql and PHP in Google API

I wanted to show the polyline on google Map as car moves with animation (like in this site: http://econym.org.uk/gmap/example_cartrip2.htm) by taking data from MySQL and PHP. For that i refered the ...
1
vote
2answers
284 views

Geoserver - Key Authentication against a MySql Database

I am trying to implement a token based security scheme with Geoserver. What we need to do is send the client a license key when they log into our primary application. This license key is generated by ...
1
vote
2answers
299 views

How does MYSQL accept the WKT representation of a polygon with holes?

I have a set of coordinates that creates a polygon with holes in it. I'm using qgis with mmqgis to extract. How does MYSQL accept the WKT representation of a polygon with holes? By holes I mean ...
0
votes
1answer
834 views

How do I write a MYSQL spatial query to find all polygons (rectangle) that contain any points in a table?

Something like: SELECT * from polygons WHERE bounds CONTAINS(SELECT geom_point from points) Can someone help me out with the syntax? Bounds will always be a rectangular polygon and everything is in ...
2
votes
0answers
197 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 ...
0
votes
0answers
585 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 ...
1
vote
0answers
353 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 ...
-2
votes
1answer
130 views

Qgis: Select multiple layers in sql-Filter [closed]

I have a Shape-File with lines of streets. Now I want qgis only to show the categories: Type: primary and Type: secondary and Type: motorway. How do I do this? This doesn't work: "type" = 'primary' ...
2
votes
1answer
269 views

PostgreSQL, find points near points

I'm going to have a database with a 'people' table and a 'shops' table. I'd like to find all people within 500m of a shop, and details from both tables. I'm used to working with mySQL, but I'm ...
1
vote
1answer
221 views

How to add MS SQL table using python console?

I have MS SQL Server 2008 R2 database. How to add MS SQL Table using python console in QGIS?
4
votes
2answers
591 views

Which spatial DBMS should I select?

I found there are a number of RDMS have the spatial capability e.g. mysql, postgreSQL I considering which I should go forward! I would like to store the lat lon coord from the tracker to the db ...
1
vote
0answers
64 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
56 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 ...
2
votes
0answers
161 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 ...
1
vote
1answer
4k 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 ...