meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 4 months |
| seen | Apr 2 at 4:24 | |
| stats | profile views | 18 |
|
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. |
