442 reputation
612
bio website
location
age
visits member for 2 years, 7 months
seen Jun 24 at 4:12

Feb
13
awarded  Yearling
Feb
9
asked Renaming Columns in Geotools FeatureType
Nov
1
awarded  Popular Question
Aug
16
awarded  Nice Question
Aug
16
accepted Acquiring ArcGIS-like speed in Postgis
Aug
16
comment Acquiring ArcGIS-like speed in Postgis
Thanks that gets me down to, 3.63 minutes! I would have never thought a union would be faster. This answer is really going to make me rethink the way I do queries from now on.
Aug
13
comment Acquiring ArcGIS-like speed in Postgis
@NicklasAvén Yes, I included the links to the exact datasets I used in the post
Aug
12
comment Acquiring ArcGIS-like speed in Postgis
@NathanW Explain Analyze results are added to post now.
Aug
12
revised Acquiring ArcGIS-like speed in Postgis
added 186 characters in body
Aug
12
revised Acquiring ArcGIS-like speed in Postgis
added 1 characters in body
Aug
11
comment Acquiring ArcGIS-like speed in Postgis
st_intersects() includes a bounding box query before performing any intersection testing in postgis 2.x so unfortunately that won't save any time.
Aug
11
revised Acquiring ArcGIS-like speed in Postgis
added 142 characters in body
Aug
11
comment Solutions for fast operations on large GIS datasets
I posted a new question about the problems I am having with postgis as this question would become way to ambiguous otherwise.
Aug
11
revised Solutions for fast operations on large GIS datasets
added 414 characters in body
Aug
11
asked Acquiring ArcGIS-like speed in Postgis
Aug
4
asked Solutions for fast operations on large GIS datasets
Jan
20
awarded  Nice Question
Jan
14
awarded  Scholar
Jan
14
accepted Optimal video cards for GIS programs
Jan
14
awarded  Supporter