7,430 reputation
32666
bio website worldviewsolutions.com
location Virginia
age 40
visits member for 4 years, 8 months
seen 5 hours ago

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


1d
awarded  Nice Answer
Mar
16
comment How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
I've submitted to tech support.
Mar
16
comment How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
There's no where from the definition query and there is no where from ArcMap (which is where I would expect something...like the extent of the data frame). If I manually issue a shape && geometry query, PostGIS will do the spatial index scan and is really fast.
Mar
16
comment How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
Wow...hives! There are other parts of this database that will send you into cardiac arrest!
Mar
14
revised How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
edited title
Mar
13
comment How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
No issues with the same featureclass with st_geometry.
Mar
13
comment How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
No...I scrubbed the table name and accidentally dropped the schema. 'sde' is the name of the database (its an existing db, not one i created). It isn't a query layer, although I had similar performance issues with a query layer(same st_asewkb(ST_setSRID(zzzztablenamezzzz.shape,-1)) pattern). yes, registered with SDE.
Mar
13
revised How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
added 8 characters in body
Mar
13
asked How to improve ArcGIS Desktop 10.2.2 and Postgres 9.2 PostGIS geometry performance?
Mar
12
revised Getting FeatureTemplate dialog form ArcObjects?
corrected template spelling
Mar
12
answered When i'm in editing mode in QGIS, how do I make the selection color transparent?
Mar
11
awarded  Popular Question
Mar
10
accepted What is the proj4 for World Behrmann (54017)?
Mar
10
comment What is the proj4 for World Behrmann (54017)?
@user30184: that's what I'm using now. Feel free to add that as an answer.
Mar
10
asked What is the proj4 for World Behrmann (54017)?
Mar
10
comment Database connection times - PostGreSQL vs Oracle (ArcSDE)
You work up some initial, quick & dirty config values here: pgtune.leopard.in.ua
Mar
6
asked Which version(s) of ArcGIS API are compatible with ArcGIS 10.2?
Mar
6
awarded  Famous Question
Feb
23
comment What software do you use as complementary to your GIS desktop/server?
A coworker showed be that a month or so ago, which is great if you are bouncing around different VMs or servers. Still use Clickie on my workstation because the left hand holds my coffee.
Feb
17
comment How can you tell which port number an existing Database Connection is configured for?
The postgresql.conf is server-side and I already know what ports I'm running, both 5432 and 5433 (and 5434 and 5435 but those don't have the same databases on them). How would a user who doesn't have administrative access to the database server, know the connection after it has been created.