spatial Questions
2
Solved
What is Google map's spatial reference system using when you enter a lat, long into the maps search bar?
I've found hints that it might be WGS84 but after converting to that coordinate system, not...
Lex asked 4/11, 2009 at 21:57
1
I've based my query below to select points near a spatial point called point on the other SO solution, but I've not been able to get it to return any results, for the past few hours, and I'm a bit ...
Soapy asked 21/2, 2012 at 12:53
1
Solved
This is a basic question but unfortunately I could not find the relevant command elsewhere.
Is there a way i can convert a Spatial Points Dataframe to an ordinary dataframe in R.
e.g. if the ordi...
Glazunov asked 17/2, 2012 at 18:52
10
Imagines there's a 2D space and in this space there are circles that grow at different constant rates. What's an efficient data structure for storing theses circles, such that I can query "Which ci...
Semipro asked 27/1, 2012 at 10:18
1
Solved
Hello I have a network in R using the igraph library
Vertices: 616
Edges: 6270
Directed: TRUE
No graph attributes.
Vertex attributes: name, Lat, Lon.
Edge attributes: V3.
How can I generate ...
1
Solved
I have multipolygon that looks like a star with an empty hole in a middle:
image
How do I transform this multipolygon into a single polygon or multipolygon that also includes the hole in a middle,...
Douro asked 1/2, 2012 at 4:9
8
I'm using Python in an attempt to analyse a large chunk of empiric measurements. In essence, I've two functions transforming the empiric data which also takes 3 'count' parameters - and retur...
Bilodeau asked 21/1, 2012 at 15:33
2
Solved
So I have a spatialpolygons object in R; but I am not sure why I am unable to retrieve the "area" slot from it.
Here's my R session:
> spatialpolygons
An object of class "SpatialPolygons"
Slot...
1
How can I query the postgres Point type from clojureql? I wish to use the PostGIS functionality but clojureql does not seem to include this.
Katha asked 10/7, 2011 at 17:38
3
Solved
I need to use an existing PostGIS database from my Rails application. So far I am able to access the DB just fine, GeoRuby nicely converts the 'geom' column into a Point object.
What I am looking ...
Tamer asked 7/10, 2009 at 14:10
1
In my 2D game, I have static and dynamic objects. There can be multiple cameras. My problem: Determine objects that intersect with the current camera's view rectangle.
Currently, I simply iterate ...
1
I have 2 tables one with points as geographies and other with polygons as geographies. I am able to find which polygon a single point falls(from the point table) by the following query:
DECLARE @p...
2
I am trying to calculate distance between two locations using spatial functions in both Mysql and PostgresSQL. I have taken the latitude and longitude from Google. The details are below
Location o...
4
I have about 75 million records in a SQL Server 2008 R2 Express database. Each is a lat long corresponding to some value. The table has geography column. I am trying to find one nearest neighbor fo...
Kelbee asked 11/7, 2011 at 18:42
1
Solved
I'm seeing some strange performance issues on SQL Server 2008 with a nullable geography column with a spatial index. Each null value is stored as a root node within the spatial index.
E.g. A table...
Fiddlededee asked 10/2, 2011 at 8:32
1
Solved
I am trying to work out the most efficient query to get points within a radius of a given point. The results do not have to be very accurate so I would favor speed over accuracy.
We have tried usi...
Appliance asked 16/6, 2011 at 12:13
2
I am fairly new to R, but not to ArcView. I am plotting some two-mode data, and want to convert the plot to a shapefile. Specifically, I would like to convert the vertices and the edges, if possibl...
2
Solved
I am interested in good literature about spatial indexes. Which one are in use, comparisons between them in speed, space requirements, spatial queries performance when using them etc.
Dunigan asked 11/4, 2011 at 20:25
1
Solved
I'm trying to draw a google maps that has multiple Circle overlays, however I do not want to reveal the correct center of the radius.
So for example, myLatlng is my lat/lon center of the radius, I...
Ostracon asked 28/3, 2011 at 13:59
2
Update:
Link to my test dataset
I have some data like this:
10.0 11.0 0.5
10.0 12.0 0.5
10.0 14.5 0.5
10.0 16.0 0.5
10.0 18.5 0.5
10.0 19.0 0.5
10.0 19.5 0.5
10.0 20.0 0.5
Using Gnuplot, I co...
1
Solved
I have a database with a field for spatial data and a cakephp interface for it. In MySQL I can save the data by doing:
INSERT INTO nodes (Location) VALUES (GeomFromText('POINT(42.450071 -76.487664...
2
Solved
SpatialKey generates some really nice looking heatmaps, and we're looking into what's involved in doing this for an internal project to visualize large amounts of points. I'm looking for feedback o...
Tucson asked 5/2, 2010 at 17:22
1
Solved
Hi have some question regarding spatial and temporal locality. I have read in the course theory that
spatial locality
If one item is referenced, the likelihood of other address close by will be r...
Mathewmathews asked 3/11, 2010 at 21:52
3
Solved
Does anyone know (ideally, with a reference), whether the VS2010 release of LinqToSQL or EntityFramework v4 will support queries over the SQL 2008 spatial data types?
Sconce asked 21/8, 2009 at 22:47
© 2022 - 2024 — McMap. All rights reserved.