Latest Contributions by BruceHarold

Hi Nelson This is a known issue we're working on - if an ETL tool is the first background GP process in any session it will fail.  Run another GP tool first (Get Count if you can't think of anything else) and then the ETL processes.  They should then work. Regards ... View more

Hi The arcpy.Describe object also returns the subtypeFieldName. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//000v0000002s000000.htm Regards ... View more

Hi Joe The best way for us to support address cases is to have sample data, which means attaching files to thread posts if using the forum.  If you are OK doing that then it works for us too, otherwise by support call works too. Regards ... View more

Hi Joe The address grammar is where new "patterns" can be defined for the new geocoding engine.  We're hoping that for major market locators that nobody will have to change the grammar, we would prefer users notify us about cases which cause issues (as you have done) and we re-publish the .lot.xml files on the geocoding resource centre.  I think your EXT issue will be resolved by Brad editing some other element values and not changing any grammar. Service Pack 1 for ArcGIS 10 will include many improvements to the geocoding experience with 10 locators. Regards ... View more

Hello Joe If you are customizing a 9.x locator you do so exactly as always with the collection of files you mention.  The Geocode directory under your ArcGIS 10 install is still there, but you may notice it is empty.  Simply copy your custom rule base files into the Geocode and Locators directories and you can create and use custom 9.x locators in ArcGIS 10. 10.x locators use the all-new geocoding engine in ArcGIS 10.   These are customizable via editing the .lot.xml file(s) in the Locators driectory.  Documentation for this is still under construction, but you should be able to see similarities with the CLS file elements. Regards ... View more

Hi Another approach might be a list comprehension: ptTupleList = [(p.shape.firstPoint.X,p.shape.firstPoint.Y) for p in arcpy.SearchCursor(myFC)] ...will give you a list of (X,Y) tuples. Also, please keep an eye on the GP gallery, there is a hull tool in the works for footprints of address points.  It may be out in September. Regards ... View more

Hi The 8.x tools are not shipped in ArcGIS 10, so the mif2shape.exe wrapper to do this conversion is not in 10.  The Data Interoperability extension is the correct ArcGIS product for conversion of 3rd party formats, although you may find other products capable of converting MIF data. Regards ... View more

Hi List comprehensions are an ideal way to get a list of field values: myList = [f.getValue(someField) for f in arcpy.SearchCursor(someFC)] SearchCursor arguments can include a SQL query, or can access a feature layer and therefore its selection set. Regards ... View more

Hi Don't forget that you can make your code workspace-portable by using the AddFieldDelimiters method to wrap field names, and Python's repr function to quote string literals in the SQL expression. Something like: uid =  row.getValue('uid') state = row.getValue('state') ws = gp.Describe(USA_State).path gp.Select_analysis(USA_State, USA_State_Select, gp.AddFieldDelimiters(ws,'UID') + " <> " + repr(uid) AND " + gp.AddFieldDelimiters(ws,'STATE')  + " = " + repr(state)) Regards ... View more

Nicholas The Data Interoperability extension solves this sort of problem.  You can get an evaluation license if you want to learn how. Regards ... View more

Hi Nelson Welcome to the arcane world of regular expressions! You are going to need to build a more complex regular expression definition to pick up the address components.  For example this pattern parses the case "500-600 George St": ([0-9]+)(-*)([0-9]*) ([a-z ][A-Z ]+) You will then need to grab the parts from the resulting matched_parts list: `_matched_parts{0}' has value `500' `_matched_parts{1}' has value `-' `_matched_parts{2}' has value `600' `_matched_parts{3}' has value `George St' Regards ... View more

Hi You might try importing sys and testing sys.executable, in process that is ArcMap.exe (or Catalog). Regards ... View more

Hello Jeremy Yes, you can update your feature class geometry with a cursor writing to the shape field with points made from the northing and easting values.  Make a Point from each XY then a PointGeometry, then write the value.  Don't forget to set the spatial reference for the cursor if the feature class coordinate system is different form the XY values. Regards ... View more

The Delete Rows GP tool will truncate the table. Regards ... View more

Hi Locators recognize field names in tables to use as input fields, like address, city, state, zip.  You might have better luck creating a script tool with a recordset input parameter and using an empty template table with these fields already set up; then the user will be able to input multiple records and the script will have an in-memory table to geocode. Regards ... View more