Questions tagged [spatial]

Spatial data types store geometric data, that is data related to an object's position in space.

Spatial data types store an object's position in space, colloquially these types are "geometric" or "geographic", and operating on them will make use of geodesic or Cartesian calculations. The applied field devoted to spatial data is Geographic Information Systems (GIS); the GIS Stack Exchange should be considered for questions with this tag.

Many popular databases engines now include support of spatial data types, including:

3312 questions
1
vote
1 answer

Issue of large average intensity values while creating point pattern from a data frame using Spatstat in R

I am using the Spatstat package in R for spatial point analysis. My dataset comprises location coordinates i.e. latitude and longitude of some event upto 6 places of decimal. It has some 9898 observations. Here`s the output of the summary for the…
brock
  • 181
  • 2
  • 10
1
vote
2 answers

I need an algorithm for merging/joining a range of segments into a range of polylines

I have a range of segments that at most intersect with each other at their ends. I want to merge these segments into polylines. Is there an algorithm that does this in O(N_segments) without using extra storage (e.g. without having to build a tree…
gnzlbg
  • 7,135
  • 5
  • 53
  • 106
1
vote
1 answer

Spatial database vs. Geo database

Do they mean one and the same. After reading through many links & references, could not clearly spot the difference between these two. In simple terms whats the difference between these two?
1
vote
0 answers

How can I create and query 3D Spatial Objects in Sql Server?

Instead of using the 2D Spatial Data Type (multipolygon) to create a 3D geometry object, is there any other way of creating and querying 3D Solids? Any library with Spatial Extension methods that allows us to support 3D in SQL Server? I am looking…
user6602462
1
vote
1 answer

How to optimize scan of 1 huge file / table in Hive to confirm/check if lat long point is contained in a wkt geometry shape

I am currently trying to associate each lat long ping from a device to its ZIP code. I have de-normalized lat long device ping data and created a cross-product/ Cartesian product join table in which each row has the ST_Point(long,lat),…
mgm_data
  • 57
  • 1
  • 10
1
vote
2 answers

Self-authored package: load plot method for spatialPolygonsDataFrame

I'm writing my own R package and would like to plot a spatialPolygonsDataFrame object. If I were writing it as a script I would simply load the necessary packages (maptools, rgdal, and rgeos) with library() and plot with plot(x). When writing a…
Phil
  • 4,344
  • 2
  • 23
  • 33
1
vote
1 answer

Plotting Shapefile on ggmap

I am attempting to plot several shapefiles on top of a map generated through ggmap. This is working well, however I want to constrain the view area to the shapefile (and not rely on the zoom argument in ggmaps). I've done this by getting the…
Gio Circo
  • 332
  • 2
  • 9
1
vote
1 answer

MySQL: get record within polygon

I have a table in database with following with latitude and longitude attribute CREATE TABLE `companies` ( `ID` int(11) NOT NULL, `title` varchar(255) NOT NULL, `latitude` decimal(12,8) NOT NULL, `longitude` decimal(12,8) NOT NULL )…
Naseer Panhwer
  • 169
  • 1
  • 1
  • 10
1
vote
1 answer

Heat Map of Spatial Data in Python

Im am writing a Python Code. My dataset is composed of three columns, the firs two are the coordinates, and the third is a heat estimation X Y heat 0 497935.000000 179719.000000 0.048428 1 …
Duccio Piovani
  • 1,410
  • 2
  • 15
  • 27
1
vote
1 answer

Error in xy.coords(x, y, xlabel, ylabel, log) : 'x' is a list, but does not have components 'x' and 'y'

I try to plot the variogram in R. When I run the below code: library(geoR) Data = as.geodata(Data2, coords.col=1:2, data.col=3) VG = variog(Data2,estimator.type="classical") VG.fit = variofit(VG, ini.cov.pars =c(0.095,1.4), cov.model="gaussian", …
1
vote
1 answer

Which NoSQL technology for Geospatial and Time Queries?

I am looking for a NoSQL technology that meets the requirement of being able to process geospatial as well as time queries on a large scale with decent performance. I want to batch-process several hundred of GBs to TBs of data with the proposed…
j9dy
  • 2,029
  • 3
  • 25
  • 39
1
vote
1 answer

R - How to add SpatialLine attributes to its endpoint?

Given is a SpatialLine and a Spatialpoint at its end. An attribute of the line (e.g. the length) should be add as information to the point. How to do this? library(sp) l1 = cbind(c(1,2,3,4),c(3,2,2,4)) rownames(l1) = letters[1:4] Sl1 = Line(l1) Ll1…
N'ya
  • 347
  • 3
  • 13
1
vote
0 answers

STUnion on whole spatial tables in SQL Server 2012

I've just started with SQL Server, coming from an Arcpy/ArcGIS/python geospatial background. I've been searching for a while for the answer to this question but have only found examples for using STUnion on two shapes. I have 2 spatial tables, table…
1
vote
1 answer

Ckan spatial queries using solr doesn't work

I install the ckanext-spatial into a working ckan instance running in a debian8 virtual machine in virtualbox. I create some example data with geoJson information and test the spatial query and everything was working ok. A day after, I initialize…
miguelbgouveia
  • 2,963
  • 6
  • 29
  • 48
1
vote
1 answer

Over Function in R gives unexpected results

I want to perform an over from the sp package. However, the results I am getting are unexpected. My polygon overlays with nine Points. However, after the over() it only returns 1 point. Why is that? Here a reproducible example! library(sp) # The…
four-eyes
  • 10,740
  • 29
  • 111
  • 220
1 2 3
99
100