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

learn more… | top users | synonyms

-2
votes
1answer
104 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
206 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
2answers
234 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 ...
0
votes
0answers
54 views

How to add attribute from analysis to database mySQL?

I need to prepare a GIS for a customer. They insist to use a MySQL-Database (not the best option, I know). They need to digitize some geometries (areas) and add some attributes. The geometries and ...
0
votes
1answer
98 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 ...
4
votes
2answers
322 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
58 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
1answer
183 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?
1
vote
0answers
48 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
133 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
129 views

Check Geodatabase attribute against an external 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 ...
0
votes
1answer
137 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
3k 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 ...
1
vote
0answers
269 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 ...
2
votes
0answers
213 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 ...
5
votes
1answer
561 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 ...
1
vote
1answer
525 views

How to connect to MySQL from QGIS in Ubuntu10?

I have just installed Quantum GIS 1.8.0 on my Ubuntu 10. I want to add a MySql table as a data source but I can't see any options for connecting to mysql. Can any one guide me how to connect to ...
1
vote
1answer
257 views

QGIS crashes when adding vector layer from mysql or testing connection to mysql

For a while I have been adding layers from my mySql database and all went well. Then I got crashes when adding new vector layers. Then I only got crashes and it is not possible to add layers from ...
3
votes
1answer
132 views

Why can't I edit polygons once they have been saved to MySQL?

I have a simple table with an id field and a polygon field in mySql. Using QGIS I can add new polygons and give them an id. Before saving them I can also edit them. But once a polygon has been saved ...
3
votes
2answers
816 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 ...
4
votes
1answer
205 views

How to join MySQL data with GIS data using arcpy?

Here is my problem, I have a MySQL database with table in it that has 4 columns: ID, Owner, Address, Legal. And I also have an ArcGIS GDB that has a parcel layer that has in it a PID field. I am ...
4
votes
1answer
3k views

Convert Shapefile to MySql

I have used Grass GIS imported a .shp file; I now want to export this file to MySQL. I understood that MySQL will contain the function of all three the files necessary in a Shape file system (.shp - ...
1
vote
1answer
151 views

How can i symbolize a map dynamically by data stored in mysql database in many tables (these tables have relationship through Primary Key and FK)

How can i symbolize a map dynamically by data stored in mysql database in many tables (these tables have relationship through Primary Key and FK). For instance "Disease Name"(chosen from drop down ...
3
votes
1answer
502 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 ...
7
votes
1answer
200 views

What constitutes a valid spatial layer when connecting QGIS to MySQL?

I'm trying to work with a MySQL 5.5 table using QGIS 1.8. I can do "Add Vector Layer", choose "Database", and successfully connect to the MySQL connection I previously set up. QGIS shows me a ...
3
votes
0answers
238 views

Problem connecting QGIS to MySQL [closed]

I'm trying to create a new vector layer and store it in a MySql-database, but when I test the connection I get an error with no detailed information at all. If I give an erroneus password I get a ...
2
votes
1answer
229 views

How to do Reverse Geocoding from MySQL/PostGIS Sql ???

I want to do reverse geocoding from MySQL or PostGIS SQL. I have shapefile up to town level of India. So I have a geometry boundary for each town. What I want is to first find the nearest point ...
2
votes
2answers
862 views

Drop Markers and MarkerCluster together from database

I've been working on my map which gets it's details from a MySQL database. I use MarkerCluster Plus to cluster my markers but would like to add the drop animation to it. I found this thread, but ...
1
vote
2answers
161 views

How to get only one feature from MySQL?

I would like to get only one feature from a MySQL database. What am I currently doing? I use the Add Vector Layer functionality in QGis to get the features (polygons) from the MySQL database. They ...
1
vote
1answer
181 views

How to change the path to the mysql socket in Quantum GIS?

I would like to use Mysql in QGIS. But when I want to create a new connection to the database (Add Vector Layer), I can't connect because QGIS is looking for /tmp/mysql.sock But I'm using XAMPP ...
2
votes
0answers
277 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 ...
1
vote
2answers
663 views

How to overlay points from MySQL served by Geoserver on an Openlayers map?

This might be a very basic question as I am new to GeoServer. What I am trying to do: I have a MySQL table that stores data attached to a spatial point and have latitude and longitude columns to ...
-1
votes
1answer
346 views

Is it possible to show markers from MySQL database with Javascript?

I'm interested if it's possible to show markers (latit, longit) from MySQL database with Javascript libraries like Leaflet?
3
votes
2answers
6k 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. ...
1
vote
1answer
137 views

How can I Transfer mysql wkt directly into a postgis table?

I have wkt geometry data in mysql stored in blob format. I need to get this data into a postgis db and am looking for the quickest-easiest way to do it. I have managed to select the data "ASTEXT" but ...
2
votes
0answers
127 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
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)' ), ...
3
votes
1answer
7k 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 ...
0
votes
0answers
403 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 ...
0
votes
1answer
621 views

Reference materials for learning Google API V3 with PHP and MySQL (tracking)

I am new to this Google API. Now i wanted to learn Google API with PHP and MySQL. Actually i wanted to create an application that will track x,y coordinates coordinates on real time bases for ...
2
votes
1answer
660 views

MySQL GeoSpatial function for ST_Distance_Spheroid? Metric used in return Type of GLength?

Is there a ST_Distance_Sphere, ST_Distance_Spheroid equivalent function in MySQL's GeoSpatial Support? If not, any way to emulate this? What is the metric used in return type of ...
2
votes
1answer
494 views

How to speed up this simple MySQL points in the box query

MySQL doesn't have nearest neighbor search so. So I try to come up with a "distance" that's reasonable so the number of returned query is around 20-200. That way innodb doesn't have to compute ...
3
votes
1answer
3k views

Establishing a MySQL connection in ArcGIS 10

Is it possible to create a connection to a MySQL database in ArcGIS 10?
6
votes
1answer
262 views

Trigger geocoding without having to visit page

I'm using Google's geocoder to store results in database then display them on a map on another page. The problem is that each company profile page needs to be visited before it's geocoded. Is there a ...
0
votes
0answers
246 views

MySQL SQL command to find points within a rectangle with spatial extension and index [duplicate]

Possible Duplicate: how to find 20 closest points efficiently How to find points, sort them based on closeness, and get 1-20, 21-40, etc. Efficiently using Myisam and mysql Actually I ...
7
votes
3answers
2k views

how to find 20 closest points efficiently

Say I want to find 20 closest business near me. My table structure is like this: BusinessID varchar(250) utf8_unicode_ci No None Browse distinct values Change Drop ...
3
votes
1answer
324 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
378 views

shp2MySQL GIS Import Coordinates Not Correct

I'm attempting to import the Chicago Neighborhood Boundaries into a MySQL database from the shape files available at ...
2
votes
2answers
417 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 ...
1
vote
1answer
300 views

Calculate MBR envelope for different geometry shapes in different rows

I have some different kinds of geometry (Polygons and line strings) stored in my mysql database. On different rows. I know I can retrieve the envelope of one row with: SELECT Envelope(zoneShape) FROM ...