In a database, a mechanism for optimizing access to data based on the spatial column(s) of a data table.

learn more… | top users | synonyms

1
vote
1answer
302 views

create polygon adjacency matrix using python

I am trying to create an adjacency matrix from a set of polygons. That is, I have a bunch of polygons and I want to identify which polygons have a common edge or "touch" each other. Once I find this ...
1
vote
2answers
276 views

How to work with the STRtree Index when object in the index change it's position?

I'm work with the NTS(NetTopologySuite), I get large amounts of Point geometries, for fast querying the point object, I make the STRtree Index like this, STRtree tree = new STRtree(); foreach (var p ...
1
vote
1answer
57 views

Basic sp-gist indexing?

Please forgive a very, very elementary question. I am using a PostgreSQL 9.3.5 database, and one of the tables stores longitude and latitude. (These are two separate columns.) I would like to do ...
1
vote
0answers
37 views

Silly problem with spatial index?

I explain : I've got a points layer in .shp, it's allright, no problem with display( pan, zoom it's ok)… But when I create a spatial index, display of the map becomes crazy. It's not easy to explain ...
1
vote
1answer
41 views

Index to speed up ST_HausdorffDistance?

When comparing similarity of linestrings with ST_HausdorffDistance (or another type of similarity function), is there a way to use an index to speed up the search for similar linestrings?
1
vote
0answers
29 views

Cannot see shapes in ArcCatalog or ArcMap after creating spatial indexes? [closed]

I created a spatial index on a feature class, but when I try to load it in ArcMap, I cannot see the shapes. When I remove the spatial index, I can see the shapes in ArcMap/ArcCatalog.
1
vote
1answer
71 views

PostGIS Spatial Index not used after copying table

I am copying a PostGIS database from my computer to our webserver. I always had problems to copy the entire database using pg_dump and pg_restore so I am creating a new database on the server and copy ...
1
vote
0answers
75 views

mongoDB query not working as expected

My mongoDB collection has all three types of shapes. A point is stored as { 'CE_NO': '_', 'E_NAME': 'RAILWAY BOOKING CENTER', 'SRCTYPE': 'Facility', 'geom': { 'coordinates': [ ...
1
vote
0answers
53 views

Indexing GIS data associated with user with timestamp

I have data for each user in this format user1:(timestamp,lattitude,longitude) user1:(timestamp1,lattitude1,longitude1)..... Here the 1 at the end of timestamp/lat/long is to specify a different ...
1
vote
0answers
214 views

Adding multiple layers to Tilemill from a single sqlite DB

This is a repost of a question I had over at the MapBox support board. Since I wasn't having much luck over there, I'm hoping I would have better success here. I'm having trouble adding more than a ...
0
votes
1answer
31 views

How to create my own remote sensing index?

Using Landsat images how do I create my own indices to extract particular landuse? Are there any tool/ software for creating indices?
0
votes
1answer
124 views

Spatial search performance on a collection of Points in a PostGis database

Let's assume you have a huge PostGis spatial table (using Postgresql 9.2, postgis 1.5) : BIGTABLE ( p Point, someData varchar ) which contains millions of records. Each record has been created ...
0
votes
0answers
20 views

Pointers to open source C/C++ code for converting Lat/Lon data into geo-spatial indices in a triangular or hexagonal grid?

I have a streaming data application which needs equal area geo-spatial indexing of input Lat/Lon observational data for locality of referencing. From reading, it would seem that a triangular or ...
0
votes
0answers
47 views

How to serialize a HTML form to GeoJSON data?

I'm developing a Cordova/PhoneGap mobile application and using NodeJS for server and MongoDB as database. I need to serialize GPS data from mobile phone to send it to my webservice with latitude and ...
0
votes
1answer
248 views

Is it possible to use JTS for calculations on data in geographic coordinates?

I have some spatial data that has all of its coordinates as lat/lon pairs (with about 10 digits decimal precision), it's stored in a database as WGS84 data. Some of the data is represented as polygons ...
0
votes
1answer
57 views

Is there a way to force ArcCatalog to use a specific tessellation scheme for a SQL Server spatial index?

If I Recalculate a spatial index from ArcCatalog, the tessellation scheme is always set to "Geometry Grid". Even when the previous index was Geometry auto grid. ArcCatalog always changes it back. ...
0
votes
0answers
246 views

Spatialite, to speed performance, when should I create Views, Indexes or additional spatial tables?

I’ve got a large Spatialite database with a table of lines (roads, rail and water). I created a spatial index of the geometry to speed things up. This works amazingly well when I’m zoomed in ...