802 reputation
214
bio website
location England, United Kingdom
age 37
visits member for 2 years, 10 months
seen May 22 at 13:12
stats profile views 122
I am a GIS Consultant. I love C# and Java type languages and have dabbled in VB a long time ago.

May
10
comment Quick way to make a convex hull
@whuber - yeh, those are really good ideas - I think the only drawback on this methodology are the actual spatial and attribute selection functions - they take an absolute age!, and I have put a spatial index on the point featureclasses! However this may be due to fact SDE is running on a crappy desktop box, I am now in the middle of transferring the data onto a proper server with the appropriate SDE tuning for vector data. I will feed back when I get a result. PS - I think it may be worth writing this up as an answer then I can award you the points etc.
May
10
comment Quick way to make a convex hull
@whuber - I have put your idea into Python code now and it seems to have worked excellently for a feature class of 11 million points - it cut down the processing to 750K points and the convex hull was perfect. Now doing a 16 million one, but alas no luck yet - I have applied a new spatial index in the hope it will speed things up.
May
10
comment Quick way to make a convex hull
@Hornbydd - I didn't actually know that, but thanks, I will look into that.
May
8
comment Quick way to make a convex hull
@whuber - yep totally agree with your thoughts. Just trying to work out whether your original idea would work...there's definitely something it it :)
May
8
comment Quick way to make a convex hull
@whuber - the performance issue is: looping through ALL the points in the search cursor to put them into an array in order to make a multipoint out of them - that takes a crazy amount of time!
May
8
comment Quick way to make a convex hull
No - using Oracle. That's an option, to use the database side - but I'm just working through Python at the moment.
May
8
comment Quick way to make a convex hull
No - I am creating a convex hull FROM the points, but first you must create a mulitpoint first, then call the convexHull() function.
Oct
31
comment How to migrate an extension from ArcGIS 9.3.1 to 10?
@KirkKuykendall - yep, that microsoft article worked for me too - it was so obvious in the end (NOT!). Thanks, this has been a lifesaver.
Jun
27
comment Using primary keys with SDE (Oracle) best practice?
Ahh - I see the doc provides most answers - a case of RTFM! Cheers.
Jun
22
comment Using primary keys with SDE (Oracle) best practice?
I'm not doing any spatial queries - I'm only trying to get an id for a country and then use that id in a junction table to associate with another entity - thus maintaining a M-M relationship with my data. And I'm not creating any spatial views.
Jun
22
comment Using primary keys with SDE (Oracle) best practice?
Should I be concerned with USER_SDO_GEOM_METADATA if I add my own primary key?
May
11
comment Spatial Definition Queries?
I am so happy to have found this out - it's just the ticket!!!
May
11
comment Spatial Definition Queries?
Really! That could work!
May
11
comment Spatial Definition Queries?
Yes, I have seen this, but I think you would have to create a new FC from the resulting featureCursor. What I really want to do is limit the features spatially just before ILayer gets added to the TOC in ArcMap.
May
11
comment Spatial Definition Queries?
Just load it into ArcMap as normal. Basically I know you can do a Layer Definition on a layer then load into ArcMap but that only works with attributes, not the spatial column - I was just wondering if I may have missed anything, and it was in fact possible to do a spatial definition query. This would definitley need to be done with rasters too.
Mar
23
comment Deploying Custom dll Commands etc in ArcGIS 10
Yes - the walkthrough doesn't reflect the default location - as it is missing the {Manufacturer] placeholder. Subtle but vital. Cheers.
Mar
2
comment How to create floating-only window in ArcMap?
I like this NativeWindow way - very clean.
Feb
28
comment Accessing ArcGIS layers from seperate thread
Its horrifically complicated - you think they would have sorted this after all these years!!
Feb
14
comment Adding Button as Icon and Text to toolbar in ArcMap
I think it should probably be set up through NewDocument method of a bland Extension class. (I tried to find an example of this question on the forums but obviously used the wrong search words - nice find!)
Feb
9
comment Adding Button as Icon and Text to toolbar in ArcMap
This only shows the icon - but I also need text next to it as well. I think it has something to do with: ESRI.ArcGIS.SystemUI.esriCommandStyles.esriCommandStyleIconAndText