7,487 reputation
32666
bio website worldviewsolutions.com
location Virginia
age 40
visits member for 4 years, 9 months
seen 2 hours ago

GIS Application Developer for Worldview Solutions. http://www.linkedin.com/pub/jay-cummins/a/330/842


Apr
16
accepted How can you tell which port number an existing Database Connection is configured for?
Apr
16
revised How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?
added 926 characters in body
Apr
16
revised How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?
swapped out the anonymized plan with the actual w/ times
Apr
16
comment How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?
I don't have a number on the spatial fragmentation, but it isn't fragmented much on the test dataset (but it has potential to become fragmented).
Apr
16
comment How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?
The featureclass was loaded in ArcCatalog (so no options other than create/delete), which results in a GIST index. I did change the tablespace of the spatial index (to a faster disk).
Apr
16
revised How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?
added table extent and shape extent
Apr
16
accepted How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
Apr
16
revised How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?
edited title
Apr
16
revised How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?
added the create table
Apr
16
comment How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?
I think I need to clear things up in my question! The performance issue is with a table using st_geometry (Esri) as the storage type. When I re-created the table with postgis storage type, it was pretty good (as good as can be expected when selecting out 30% of the rows spatially).
Apr
16
comment How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?
@JohnBarça: no luck on the st_geometry table.
Apr
16
comment How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?
The storage for the actual table is in st_geometry--I created the PostGIS table for troubleshooting. The PostGIS table is good, but I can't use PostGIS storage (see gis.stackexchange.com/a/138842/31 ).
Apr
16
asked How can I speed up a slow ArcGIS Server 10.2 - PostgreSQL (9.2) ST_Intersects query?
Apr
10
comment Why is ArcMap leaving connections “<IDLE> in transaction”?
Good to know--although my data isn't in a map service yet (but it will be).
Apr
10
comment Why is ArcMap leaving connections “<IDLE> in transaction”?
I can confirm that this is still happening in 10.2 (PostgreSQL 9.2)
Apr
8
answered How can you tell which port number an existing Database Connection is configured for?
Apr
1
comment How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
Just got a call from Esri this morning. It is a bug, but I haven't got a number for it yet. But the short version is that it is a known issue and don't use PG_GEOMETRY for large tables.
Apr
1
asked How do you unregister a table from a esri geodatabase?
Mar
31
revised Is there PostGIS equivalent to arcpy.sa.Slice() function?
Added explanation on what slice does.
Mar
30
comment Is there PostGIS equivalent to arcpy.sa.Slice() function?
@artwork21 I was hoping to bring the raster piece into the existing database transaction.