Stack Overflow
Stack Overflow

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

Spatial, strangle lines when using Map View

I'm attempting to make my first spatial map using SQL developer and map view. And this polygon with hole has me stuck: screenshot! Here's the insert code I used: insert into FIELDS values( 3, MDSYS.SDO_GEOMETRY(2003, NULL, NULL,…
meta
  • 153
  • 12
1
vote
1 answer

How to perform spatial joins in ravendb

I have a large collection of documents containing geospatial point data (among other data). I have another large collection of documents containing polygons (among other data). I want to filter queries on the point data by whether the points are…
AdamAL
  • 1,571
  • 2
  • 14
  • 25
1
vote
2 answers

Can I convert kernel density plots to raster and then overlay them using map algebra?

I am currently exploring three shapefiles, each with point data, and all confined to the same window. I also have them in ppp format which I've used to create kernel density maps. plot(density.ppp(smktppp, 0.5, edge=T), main="Supermarket…
skyandbuildings
  • 9
  • 1
1
vote
0 answers

How to bind a C# DataSet with info from SQL Server query to a Telerik Radmap VisualizationLayer

I have a DataSet with information from a SQL Server query SELECT TOP (1000) [Id] ,[Name] ,[placemark] FROM [testmap].[dbo].[table1] with the following result: Result query (click to see image) SQL Management Studio also can show Spatial…
Luis Leon Gonzalez
  • 81
  • 9
1
vote
1 answer

How to query location "within" in OrientDB 2.2.x Spatial Module in Java?

I'mm trying to implement OrientDB Spatial Module and need some help on coding it in Java. How do I do the equivalent query in Java: select *,ST_Distance_Sphere(location,ST_GeomFromText('POINT(12.4696635 41.8894657)')) as distance from Points where…
ikevin8me
  • 4,253
  • 5
  • 44
  • 84
1
vote
1 answer

How to create index for spatial module for OrientDB (2.2.x)?

OrientDB has been upgrade to Spatial Module feature from 2.2. What is the Java equivalent to create the index for this: CREATE INDEX ON (geometry-field) SPATIAL ENGINE LUCENE say, for the example: ODocument location = new…
ikevin8me
  • 4,253
  • 5
  • 44
  • 84
1
vote
1 answer

Mapping to com.vividsolutions.jts.geom.Point invalid endian flag

I am working on a project where I will be retrieving a user's latitude and longitude. From this, I would like to store it into the database as a Point. However, when I attempt to do so I have run into the following error: …
Alien
  • 444
  • 2
  • 9
  • 28
1
vote
1 answer

Polygon and line input for point output (in R)

I'd like to create a a .shp file or data table of coordinates where the output point features are where line endpoints touch at a point on the polygon boundary and where lines cross polygon boundaries. No points are generated in the output where…
David Alexander
  • 25
  • 5
1
vote
2 answers

Spatial functions in HIVE

We are in the process of migrating from traditional RDMS technologies to HIVE and in the process we have few questions on HIVE spatial capabilties. 1) Mapping of operation dbo.fHTMToString spatial from sql server operation to HIVE 2) Mapping of…
ashish
  • 13
  • 5
1
vote
0 answers

Oracle Spatial - spatial index on time-varying data

I am trying to design a datamodel on geodetic data which performs decently as the data grow over time. However all ideas I got have hit a couple of limitations by Oracle. These are the requirements: the data to store are 2-dimensional points with…
Antonio
  • 1,178
  • 14
  • 14
1
vote
1 answer

Pyproj distance between points and between a point and polygon

I want to calculate projected distance between two points and between a point a polygon. All coordinates are specified under same projection lat,lon (WGS84). I calculated the distance between a point and a polygon using pyproj as follows: from…
kitchenprinzessin
  • 1,023
  • 3
  • 14
  • 30
1
vote
2 answers

Date range query using Lucene spatial search / DateRangePrefixTree?

I'm using Lucene 6.3, but I am not able to figure out what is wrong with the following very basic search query. It simply adds to documents each with a single date range and then tries to search on a greater range the should find both documents.…
Daniel Gerson
  • 2,159
  • 1
  • 19
  • 29
1
vote
1 answer

Update several rows simultaneously SQL server

I'm in the process of creating a table that lists cities, state, zip, and long/lat. I've created another column (called GeoLoc) in my table that uses the geography data type. I would like to combine my latitude and longitude columns into the GeoLoc…
Anthony Sims
  • 171
  • 4
  • 15
1
vote
1 answer

Using linestring in SQL Server Reporting Services maps

When creating SQL Server report with a map I am having difficulties using linestring. To give some background I have several Routes that consist of several segments (linestrings) that data comes in multiple times an hour and it is desired to take…
user3096487
  • 349
  • 1
  • 2
  • 14
1
vote
2 answers

Algorithm to connect multiple points without inclusion

I am searching for an algorithm to connect multiple points without including one of the points. The requirement is that all points are connected but no points are in the interior of the resulting polygon. I was not sure what the technical term for…
Bel
  • 55
  • 6
1 2 3
…
99 100