452 reputation
614
bio website
location
age
visits member for 2 years, 8 months
seen Sep 5 at 22:26

Mar
1
comment Fastest way to convert shapefile to postgis in java
The problem is that I want to change the column name "the_geom" to "geom". I have found no way to do this with geotools except for creating a new feature type and then iterating through each feature to copy individual attributes to the new feature type. Just for the name change! Furthermore, even when I employ the method shown, it still takes multiples of the time it takes to complete in shp2pgsql. In fact, this method is actually the benchmark I used in my post now that I think about it. When it used individual commits I didn't have the time to let it finish.
Feb
28
comment Fastest way to convert shapefile to postgis in java
I have gdal/ogr and have read about the java bindings. This may be the way to go ultimately, especially since I also need to read from file geodatabases anyway; however, I am not looking forward to the hell of tying to figure out how to get maven to use the shared object files correctly.
Feb
28
comment Fastest way to convert shapefile to postgis in java
@iant I already have a python script that wraps shp2pgsql and allows for merging a directory of shapefiles. It generally works, but it is a crude hack --and I have inherited an existing code base in java and so I wan to keep stick with java where possible. Furthermore, while I often feel that goetools is overkill, it is at least good for figuring out the projection of a shapefile, which shp2pgsql simply does not do.
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
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
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.
Jan
14
comment Optimal video cards for GIS programs
So if I have a giant 500,000 parcel dataset with many complex polygons, having 2 GB GDDR5 vs 1 GB GDDR RAM would have essentially no effect? Aren't video cards supposed to speed up rendering of complex shapes?
Jan
14
comment Optimal video cards for GIS programs
I never thought about that, I always figured 7200 RPM was about as fast as would ever be necessary. Wouldn't the hard drive bottleneck only apply when reading and writing from a file? I mean once you load a shapefile into arcmap, isn't what you are viewing essentially held in memory. I mean if I scroll/zoom in on a parcel dataset arcmap doesn't need to read the file from the hard drive again to accomplish that task.