There's a few questions like this on Stack Overflow but because i can't find any quite similar enough for me to follow. I'm looking to select rows from db which are within x miles of a target. example table columns: | city_name(varchar) | lat(decimal) | lon(decimal) | query effect i'm looking for (either using php or mysql) $target...
I'm trying to change the application schema of a database in Postgres...so I need to copy data from one table to another. In the original table, co-ordinates are specified as numeric values in two separate columns, one for the x value and one for the y value. In the new table, the co-ordinates need to be stored as one value of the point ...
I'm writing a game where a large number of objects will have "area effects" over a region of a tiled 2D map. Required features: Several of these area effects may overlap and affect the same tile It must be possible to very efficiently access the list of effects for any given tile The area effects can have arbitrary shapes but will u...
I'm using MySQL GIS and Spatial Extensions. I've a table with "circular" regions described by latitude, longitude and radius. I need a query to get all the rows whose region include a given point defined by a latitude and a longitude. The "circular" regions can intersect and therefore the point can fall in more than one region. ...
Im building an application where vehicles coordinates are being logged by GPS. I want to implement a couple of features to start with, such as: realtime tracking of vehicles history tracking of vehicles keeping locations and area's for customer records I need some guidelines as where to start on database and application design. Anyth...
I have a dataset containing the start and end points (both OSGB36 and corresponding WGS84 coordinates) of sections of a road network. I am able to import this data in SQL and create geometry and geography data types for the start and end points and for the entire object (LINESTRING etc). Viewing the coordinates in SQL query window enab...
Hi I am building a GIS application for some organisation and was thinking of using Open Source Software MapWindowGIS....and .Net Framework Can anyone tell me how good it is and will i be able to perform Spatial Query using this ....? How is the help amnd Support if i get stuck in any problem... Thanks & Regards, ...
I'm writing a game in which the player may manipulate a great many objects at one time. I would like the player to be able to select objects according to the distances between them. Given the locations of all objects, a starting object, and a distance threshold, what is the fastest way to find the subset containing the starting object f...
I'm looking for ways to programmatically convert my GPS logs to images and would like to do this in Ruby... if that's an acceptable tool. I have no GIS background whatsoever but as a programmer i think it's an interesting problem to look at. Here is what I have come up with so far. First you'll need some kind of graphing library. I went...
I'm trying to form a query that returns a list of entities within a given rectangle, using SDO_WITHIN_DISTANCE. The query I've made seems like it should work, but Oracle is giving me some strange errors. Here's the query: SELECT * FROM TBLENTITYLOCATION TL INNER JOIN TBLENTITY TE ON TE.ENTITYID=TL.ENTITYID WHERE SDO_WITH...
Just to clarify up-front: I'm talking about unioning geometry, not the SQL keyword UNION. I'm trying to move some spatial data from Postgres with PostGIS to SQL Server 2008. It was fine until I saw a statement like this: SELECT GeomUnion(the_geom) FROM some_table This unions all geometry in that column and return it as one result (si...
Hello All, Im using zend framework with mysql, im using Zend_Db_Table_Abstract to run queries. i have spatial field in a table : country; +------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+---------+------+-----+---------+----------------+ | id...
We're building a small-sized GIS Web application (as a school project) right now. In terms of spatial database support and capabilities, which is better? :) thanks everyone! ...
Hi folks, I have (what I think) is a simple Sql Server spatial query: Grab all the USA States that exist inside some 4 sided polygon (ie. the viewport/bounding box of a web page's google/bing map) SELECT CAST(2 AS TINYINT) AS LocationType, a.Name AS FullName, StateId, a.Name, Boundary.STAsText() AS Boundary, CentrePoint.STAsT...
Is it possible to connect Oracle with ArcGIS for doing spatial query? ...
I'm trying to input some data into a PostgreSQL 8.4 database with a PostGIS template. I'm unable to UPDATE polygons: > UPDATE my_table SET coords = POINT(1, 1) UPDATE 0 1 > UPDATE my_table SET box = POLYGON(((1, 1), (2, 3), (3, 3), (1, 1))) ERROR: function polygon(record) does not exist > UPDATE my_table SET box = POLYGON((1, 1), (2,...
I want to specify a box (i.e. 2 points) and select all the linestrings that are either within or intersect the box. SELECT * FROM pub_trail_segment WHERE st_force_2d(pub_trail_segment.geometry) && ST_SetSRID(ST_MakeBox2D(ST_GeomFromEWKT('SRID=4326;POINT(48.25077560316286 -124.46710205078124)'), ST_GeomFromEWKT('SRID=4326;POINT(50.474370...
Hi, I've been using subsonic for quite a while now and I seem pretty confident about using it in my thesis. What I'm not sure about is how will it handle geometry data types. Anyone has an idea?? ...
Is there a way to subtract a geometry from another? A kind of reverse STUnion.. The problem I am having is that I need to ensure a shape fits within another (without changing the larger shape). I thought I could use the STIntersection to get the shape thats "in". However, STIntersection is not accurate and produces a shape that can (an...
what is a better way to store spatial data in MySQL (say tracks) internally or as references to the external flat files? ...