spatial Questions
1
Solved
I am currently working on an optimization problem that requires finding all points greater than (or in some cases less than) a particular point in all cardinal directions. For example, in 2D, I mig...
Zima asked 11/3, 2014 at 23:14
2
Solved
I am fluent in SQL but new to using the SQL Geometry features. I have what is probably a very basic problem to solve, but I haven't found any good resources online that explain how to use geometry ...
Outburst asked 10/2, 2014 at 6:10
2
Solved
I have a SpatialPolygonsDataFrame with 11589 objects of class "polygons". 10699 of those objects consists of exactly 1 polygon, however the rest of those objects consists of multiple polygons (2 to...
Faddist asked 23/2, 2014 at 17:8
3
Solved
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 sa...
Melanous asked 20/7, 2010 at 18:37
3
Solved
I have a dataset with minute by minute GPS coordinates recorded by a persons cellphone. I.e. the dataset has 1440 rows with LON/LAT values. Based on the data I would like a point estimate (lon/lat ...
Dodds asked 6/6, 2012 at 4:12
4
Solved
Let's say I have this lon/lat: 33.33333,22.22222
How can I randomly select another lon/lat within an X miles/km radius?
Thanks,
Overlook asked 28/3, 2011 at 14:54
1
Solved
I am trying to get the minimum distance between a given point and the coast. My example is the distance of Madrid to the coast:
library(rgeos)
library(maptools)
coast <- readShapeLines("Natural...
4
Solved
I'm getting ready to start a project where I will be building a recommendation engine for restaurants. I have been waffling between neo4j (graph db) and mongodb (document db). my nodes/documents wi...
0
This example should be reproducible, the first part (with large polygons) works, the second fails:
library(raster)
USA.altitude <- getData('alt', country='USA')
lower48 <- USA.alt[[1]]
Sr...
Unsaid asked 4/1, 2014 at 0:19
1
Using R, I am trying to extract data from a raster layer using a polygon layer. The polygons are much smaller than the raster cells:
Now I call extract() from raster library:
a <- extract(raste...
2
Solved
I have a dataset with about 100000 points and another dataset with roughly 3000 polygons. For each of the points I need to find the nearest polygon (spatial match). Points inside a polygon should m...
Owens asked 13/4, 2013 at 19:46
2
Solved
Long long struggles with this...
Basically I have a model-first EF5 object with a DbGeography property. I would like to apply a JsonConverter that let's it roundtrip as simple latitude/longitude v...
Sim asked 3/1, 2013 at 21:10
1
Solved
I am trying to measure distances between objects of interests (in this example year rings in trees) using R. My earlier attempt was so complicated that I have difficulties reproducing the solution ...
1
I'm trying to create spatial index over table column (bbox polygon default NULL) but get error: All parts of a SPATIAL index must be NOT NULL.
Problem is that I supposed some rows would contain NU...
Heretofore asked 13/10, 2011 at 9:59
1
Solved
When I apply STBuffer(1) to a Point in SQL Server Spatial, they show up as an oblong circle, instead of a perfect circle. Why is this?
Amble asked 30/10, 2013 at 20:21
1
Solved
I have a set of points and want to find the convex hull. When I give them to scipy.spatial (either ConvexHull or Delaunay), I just get the original set of points back. By construction, this should ...
Tobacco asked 15/10, 2013 at 21:55
4
Solved
I'm trying to calculate area of polyline like that
string poly = "POLYGON ((637604.918432772 2230520.64934531,
637622.257266129 2230419.44632915, 637279.107128549 2230192.04910755, 636765.470527...
Shoffner asked 19/5, 2013 at 23:28
1
Solved
I have a SpatialLinesDataFrame with streets and I have a list of GPS coordinates. What I need to do is to get out the 10 closest street names for each individual GPS coordinate.
Is there a functio...
2
Solved
If I had both SQL Server 2008 and SQL Server 2012 installed locally, I would simply try this for myself; however I only have the newer version installed and would like to keep it that way.
SQL Se...
Mccallister asked 3/2, 2013 at 18:30
5
Problem Statement:
I have the following problem:
There are more than a billion points in 3D space. The goal is to find the top N points which has largest number of neighbors within given distance ...
Stitt asked 14/8, 2010 at 5:30
1
I'm cooking up some spatial examples and have decided to give Dapper a go, although EF has spatial support, and I'm loving having control over my SQL again (Thanks Sam & Marc).
However, I need...
Metacarpal asked 6/8, 2013 at 18:48
1
Solved
I have spatial lines as 'list':
> SL1
[[1]]
class : SpatialLines
nfeatures : 1
extent : 253641, 268641, 2621722, 2621722 (xmin, xmax, ymin, ymax)
coord. ref. : +proj=utm +zone=46 +datum=WGS84...
Depend asked 2/8, 2013 at 18:8
2
I'm trying to create a table under SQL Server 2008 containing a GEOMETRY column and a calculated variation thereof.
Considering the following table where the calculated column returns a buffered g...
Firedamp asked 23/10, 2008 at 19:0
4
Solved
I understand the definitions of the terms, but I am having trouble applying their concepts to code. For an exercise, we are asked to describe if the following code is spatial or temporal:
for (int...
1
Hello, i have the following code in SQL Server, why if i want to
calculate the sTArea of @geog fails and with @geom succeed?, how can i
convert this polygon from geometry to geography datatype ...
© 2022 - 2024 — McMap. All rights reserved.