The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
24 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
38 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> ...
1
vote
2answers
98 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 ...
0
votes
0answers
42 views

Suggestions on how to create an Owner Index for a Plat Book?

I've been tasked with creating a county wide plat book for publication this june. The cartography portion is fairly straightforward as I am using ESRI's Data Driven pages for ArcInfo 10 to produce the ...
1
vote
1answer
166 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 ...
9
votes
5answers
470 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. ...
1
vote
0answers
81 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
185 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
479 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
1k 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 ...
14
votes
1answer
165 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 ...