The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
41 views

Index Page with data driven pages

I am trying to create an index page using a customized index polygon featureclass that I created. Is there a way to do that without using the grid index features tool, which is more for set sized ...
1
vote
0answers
33 views

How to index mbtiles to speed up load time?

I have created a mbtile based on OpenStreetMap data with Maperitive using the command: generate-mbtiles file=Path\filename.mbtiles maxzoom=16 Loading the file in QGIS 2.14.0 and zooming takes 15-30 ...
2
votes
1answer
78 views

Running Gevel on PostGIS 2.0

I have found Gevel, a tool enabling the visualization of the content of the GiST indices in Postgres. In particular, I am interested to use it to visualize the RTree spatial index in PostGIS. Does it ...
0
votes
1answer
88 views

How to improve PostGIS raster query

I have this query SELECT data_type, data_time, model_name, ST_Value(raw_data, 1, 202,417) AS val_0 FROM data WHERE data_type = 'type_a' AND data_time >= '2015-12-06 00:00:00' AND ...
0
votes
2answers
96 views

Will .sbn and .sbx files (spatial index) speed up operations in GDAL/OGR?

I'm trying to intersect large datasets in OGR and python using SQL queries like ST_Intersects and ST_Contains. These operations run very fast in ArcMap but I'm designing a system to automate them, ...
1
vote
2answers
138 views

AddIndex_Management throws maximum open cursors exceeded

The following script is run to create indexes across all the feature classes within a particular dataset: import arcpy import os.path def listFcsInGDB(): for fds in arcpy.ListDatasets("FRED.GS*",...
4
votes
2answers
207 views

PostGIS: Strategy for fastest select by BBox with an ORDER BY polygon area clause. Cluster?

Update 2 (below) suggests 14% of the table geometries are stored out-of-line with the rest of the table records. This may be a useful clue. The Problem: We've got a table with appx 170,000 WGS84 ...
2
votes
1answer
273 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
1answer
88 views

Factors in computing scoring for place name searches, like Geonames

As part of the FULL response style, the GeoNames search API returns results like the following: <geonames style="FULL"> <totalResultsCount>510</totalResultsCount> <geoname&...
1
vote
2answers
111 views

What index to use in this situation

I am working with 3 tables with 3 x 500 000 rows. There is one column that gives each object a unique ID (UIDN), there also is a column with the geom data (the_geom). There also are some other columns ...
1
vote
1answer
810 views

How to build, store and index a road network from a digital city map

I'm totally new to this domain so my question may sound like a little bit silly…… I'm eager to know how to extract, store and index the coordinates of the road segments(edges) and intersections or ...
10
votes
5answers
796 views

How to improve performance when using ArcGIS cursors in Python with big tables?

I have a pretty big point feature class in a file geodatabase (~4 000 000 records). This is a regular grid of points with a 100m resolution. I need to perform a kind of generalization on this layer. ...
2
votes
0answers
183 views

Trajectory Indexing: How could I store and index the large trajectory dataset generated by cars' GPS?

I have a large trajectory dataset generated by cars' GPS. Since I will do some data mining work on them, I need an efficient way to store and index them. I read some papers about Trajectory Indexing (...
2
votes
3answers
532 views

How to create a constant numeration of ID (indexing) in an attribute table (ArcMap)

Is it possible to create a constant indexing (as a numbers) in an attribute table of the theme with many objects that manner that it will remain (will not change) during update of this theme? I found ...
1
vote
3answers
1k views

Does arcpy.SearchCursor function support field indexing?

Does the arcpy.SearchCursor function support field indexing? In the sample script below, can I sent my cursor to loop through the values in the first field by setting an index to search the first ...
1
vote
2answers
2k views

ArcGIS field calculator: VBScript get data from previous row

When using the field calculator, how do I get data from the previous row in VBScript? In Python I'd do something like this: for index, row in enumerate(rows,start=1): row[index-1] += 5 I'm ...
15
votes
1answer
176 views

Alternative indexing methods for point set operations

It is common to use a bounding box spatial index to improve performance when working with a large number of features. Where operations are performed against individual geometries with a large number ...