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

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Mar
13
comment Using Postgis spatial index in st_distance operation based upon explicit SRID column
@user30184 I considered doing this, but my understanding is that using the geography type would result in distance/area calculations that are much less accurate than using a projected coordinate system. If that wasn't the case, it would definitely solve the issue.
Feb
26
comment Postgis Functional Index on st_pointonsurface() Ignored
It did work, but would be nice to avoid the extra cte. Its odd that postgres can't figure out that it needs to use the index
Feb
24
comment Postgis Functional Index on st_pointonsurface() Ignored
I added explain results to the question
Feb
24
comment Postgis Functional Index on st_pointonsurface() Ignored
I edited it to be more clear, I'm actually intersecting the centroid of the geometry with the MultiPolygon of the same table
Feb
24
comment Postgis Functional Index on st_pointonsurface() Ignored
The actual table I am using contains millions of rows and is being joined with itself with st_intersects(geom,pointonsurface), but I have tested this against various tables and seemingly under no circumstances is the index ever used. I know pointonsurface is not always a centroid, but is more concise than centermost_possible_point_within_polygon. Index should work the same on either function.
Jan
31
comment ArcGIS Runtime Java SDK SocketTimeoutException : “Read timed out” On Long Running Job
I'm executing a local geoprocessing service (.gpk file) on a local server that calls an analysis operation so, I'm not actually connecting to a remote ArcGIS server instance, just using what comes packaged with the Runtime SDK. I used gp.setStatusCallback() to poll for messages/status, but still get the exception. Are you suggesting that I make the operation within the .gpk file asynchronous?
Jan
31
comment ArcGIS Runtime Java SDK SocketTimeoutException : “Read timed out” On Long Running Job
I am running the job asynchronously in the code above, but still get the SocketTimeoutException. I'm still a bit confused as to how/where I would set the property on the server - is it just an environment variable?.
Jan
31
comment ArcGIS Runtime Java SDK SocketTimeoutException : “Read timed out” On Long Running Job
@Vince I don't see any option on 'com.esri.client.local.LocalServer' to set that property. Are you referring to another class?
Jan
28
comment No Exception Handling in GDAL/OGR java bindings: ogr.UseExceptions() has no effect
I'm using 2.0.1
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.