734 reputation
622
bio website
location England, United Kingdom
age 39
visits member for 4 years, 3 months
seen yesterday
I am a GIS Consultant. I love C# and Java type languages and have dabbled in VB a long time ago.

Jun
4
asked ListFeatureClasses brings back more than expected
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.
May
8
asked Quick way to make a convex hull
May
5
accepted ITopologicalOperator and Z Values
May
2
awarded  Popular Question
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.
Sep
25
awarded  Popular Question
Jul
22
awarded  Yearling
Jun
27
accepted Using primary keys with ArcSDE (Oracle)?
Jun
27
comment Using primary keys with ArcSDE (Oracle)?
Ahh - I see the doc provides most answers - a case of RTFM! Cheers.
Jun
22
revised Using primary keys with ArcSDE (Oracle)?
added 502 characters in body
Jun
22
revised Using primary keys with ArcSDE (Oracle)?
added 807 characters in body
Jun
22
revised Using primary keys with ArcSDE (Oracle)?
added 3 characters in body
Jun
22
comment Using primary keys with ArcSDE (Oracle)?
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.