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.
Mar
12
asked Using Postgis spatial index in st_distance operation based upon explicit SRID column
Feb
26
accepted Postgis Functional Index on st_pointonsurface() Ignored
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
revised Postgis Functional Index on st_pointonsurface() Ignored
post explain results
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
revised Postgis Functional Index on st_pointonsurface() Ignored
join the table on itself to reduce confusion
Feb
24
revised Postgis Functional Index on st_pointonsurface() Ignored
use multipolygon rather than point
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.
Feb
23
asked Postgis Functional Index on st_pointonsurface() Ignored
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
revised ArcGIS Runtime Java SDK SocketTimeoutException : “Read timed out” On Long Running Job
added 4 characters in body
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
revised ArcGIS Runtime Java SDK SocketTimeoutException : “Read timed out” On Long Running Job
added 15 characters in body
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
31
revised ArcGIS Runtime Java SDK SocketTimeoutException : “Read timed out” On Long Running Job
added 559 characters in body
Jan
31
asked ArcGIS Runtime Java SDK SocketTimeoutException : “Read timed out” On Long Running Job
Jan
29
asked Copy specfic layer to new datasource using OGR Swig Java bindings
Jan
28
comment No Exception Handling in GDAL/OGR java bindings: ogr.UseExceptions() has no effect
I'm using 2.0.1