MySQL implements spatial extensions following the specification of the Open Geospatial Consortium (OGC).
Questions tagged [mysql-spatial]
52 questions
0
votes
0 answers
Why point insertion giving error?
I am using this statement to insert data into database.
cursor.execute('INSERT INTO scats_data(id,geometry,NB_SCATS_SITE,QT_INTERVAL_COUNT,NB_DETECTOR,DAY_OF_WEEK,V00,V01,V02,V03,V04,V05,\
…
Arjun Chaudhary
- 2,373
- 2
- 19
- 36
0
votes
1 answer
MySQL spatial query
I had a normal table. Now i added a spatial column
ALTER TABLE roadData ADD pt POINT ;
and now my table has null values :
Now in MySQL tutorial insert statement is used:
INSERT INTO geom VALUES (ST_GeomFromText('POINT(1 1)'));
but i want to to…
Arjun Chaudhary
- 2,373
- 2
- 19
- 36
0
votes
1 answer
MYSQL geospatial function using table data and ST_Distance_Sphere
This is my query which attempts to return the distance from a specific point to all the records in a table.
This is the Table creation
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fname` varchar(45) DEFAULT NULL,
`lname`…
Count Zero
- 237
- 2
- 13
0
votes
1 answer
NHibernate.Spatial.MySQL: Null geometries and "No persister for: GeoAPI.Geometries.IGeometry" error
I am attempting to create a simple demo solution using NHibernate.Spatial.MySQL (version 4.0.4.4001). The solution is available here: https://github.com/andrerav/NHibernate.Spatial.MySql.Demo
The mapping seems to work at least for inserts -- the…
andrerav
- 404
- 5
- 14
0
votes
1 answer
MySQL: can't returning a POINT type using WHERE clause
i have some points stored in a MySQL database, they are stored as POINT types with an x and y value. I am trying to search and return specific points using the x and y values in a WHERE clause.
heres an example of a query i am trying to get…
ThriceGood
- 1,633
- 3
- 25
- 43
0
votes
2 answers
How to pass a value returned from inner query to outer query
I am using a nested query for fetching records within a certain radius. I want to order the response by distance and also pass the distance as one of the parameter in response. here is the query I a using for same.
select…
Zach
- 9,989
- 19
- 70
- 107
-3
votes
1 answer
Spatial query in sql database
hi I am currently developing a geo location based app which updates the user's location and displays the shops around him, I am using ordinary sql queries in sql database .My php code to select the shops around the user is :
/*
*…
user3781907
- 109
- 1
- 4
- 13