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 |
|
Apr 22 |
awarded | Popular Question |
|
Mar 15 |
asked | How to bulk import ESRI projections into Postgis |
|
Mar 5 |
asked | Installing GDAL with Java Bindings (gdal.jar) on Ubuntu 12.10 |
|
Mar 1 |
awarded | Commentator |
|
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. |
|
Feb 28 |
asked | Fastest way to convert shapefile to postgis in java |
|
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 |
