MySQL is an open-source, relational database management system. Place you question on MySQL Spatial Extensions here.
0
votes
0answers
23 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
31 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
27 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
127 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
27 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
0
votes
0answers
31 views
How to add vertices to existing linestrings in mysql?
Is it possible to add a Point at the end of a Linestring in MySql?
For example I have a Linestring as
Linestring(1 2, 1 4, 1 6)
and I want to add a Point
Point(1 7)
at the end (output should ...
1
vote
1answer
55 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?
0
votes
0answers
15 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
67 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 ...
0
votes
1answer
67 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
0answers
64 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
540 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
124 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
140 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
260 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 ...
