Reputation
530
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
7 14
Impact
~21k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Feb
14
awarded  Yearling
Dec
24
asked Building CartoDB from source using updated dependencies on Ubuntu 13.10
Aug
15
awarded  Notable Question
Jun
5
awarded  Tumbleweed
May
29
revised Solving flagrant shared object errors when compiling postgis 2.1SVN from source on Ubuntu 12.04
deleted 2 characters in body
May
29
asked Solving flagrant shared object errors when compiling postgis 2.1SVN from source on Ubuntu 12.04
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.