MySQL is an open-source, relational database management system. Place you question on MySQL Spatial Extensions here.
5
votes
1answer
282 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
241 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
47 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 ...
0
votes
1answer
76 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 ...
2
votes
0answers
88 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
151 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
202 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
97 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
31 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
147 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
21 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
86 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
34 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
36 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
0answers
42 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 ...
0
votes
0answers
20 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 ...
0
votes
0answers
73 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?
0
votes
0answers
147 views
Qgis Mysql data import and show on the map based on coordinates
I have a mysql table with points with some attributes (name, lat, long, elevation, ect...)
I import to Qgis with the Add Raster -> Database -> Mysql function.
The connection is succesfull and I can ...
0
votes
0answers
279 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
0answers
114 views
How to find points, sort them based on closeness, and get 1-20, 21-40, etc. Efficiently using Myisam and mysql
Note: In this question I want actual mysql command that I should send. Not concept, and stuff.
This question is similar with how to find 20 closest points efficiently
However in that question I ...
0
votes
0answers
59 views
How to add RTree index to myISAM
I used PhPMyadmin
I click add index and what I see is
Action Keyname Type Unique Packed Field Cardinality Collation Null Comment
Edit Drop PRIMARY BTREE Yes No BusinessID 2 ...
