Latest Contributions by BlakeTerhune

Mark a reply as the Correct Answer ... View more

Have you tried using the find and replace data Source feature in ArcCatalog? ArcGIS Help 10.1 - Setting data sources ... View more

Looks like you accidentally posted this in the GeoNet Help section. It should probably be in ArcGIS API for JavaScript ... View more

Our City government keeps accurate address data for permitting, billing, and emergency response. Our GIS serves as the authority system of record for addresses so all other systems for permitting, work orders, utility billing, emergency response, etc rely on accurate addresses in GIS to perform their particular function well and be compatible with the other integrated systems. GIS also keeps our addresses as a point feature class, which allows us to build a composite address locator that first uses address point for the most accurate result, then street ranges for the next best guess. The composite address locator is used for various adhoc geocoding operations. ... View more

always provide a return of some sort, otherwise it is a crap shoot I like this suggestion from Dan Patterson​. In addition Joshua Bixby​ recommends using one return for a single exit point (like Dan's "better format" code above), rather than having multiple returns. The Python Code Style agrees. When a function grows in complexity it is not uncommon to use multiple return statements inside the function’s body. However, in order to keep a clear intent and a sustainable readability level, it is preferable to avoid returning meaningful values from many output points in the body. ... View more

I haven't done this, but maybe you can find something useful in this Esri Blog post about ARCREST. Spatialize Your Water Utility Data with ArcGIS | ArcGIS Blog ... View more

This functionality already exists in the attribute table of the layer you've made the selection. ArcGIS Help 10.1 - Exporting tables It will export only the selected features by default. Just choose "Text File" as your format and it is formatted with comma delimiters. If you like, you can just change the file extension to csv in the export dialog before you click OK. ... View more

Posting Code blocks in the new GeoNet ... View more

Try switching the inputs, so the near features are the points and the input features are the shorelines. ... View more

It looks like you may have some incorrect indentation in the delete paths section. Here's your same code with the correct indentation: ### __________________DELETE PATHS ASSOCIATED WITH MXD___________ ### print("Time to delete") if os.path.exists(WorkPath):     print("deleting...")     try:         shutil.rmtree(WorkPath)     except:         raise else:     print("No such path:" + WorkPath) print("Deleted working and scratch folders in the MXD location:" + path) shutil.rmtree(ProjFolder) print("Deleted the project table output folder in" + TabPath) shutil.rmtree(GDBpath) print("Deleted the project geodatabase in the MXD location:" + path) ... View more

I post fewer than 10 questions per month are posted on GeoNet. Sometimes (or rarely) will contact Esri support if a question was unanswered on GeoNet. I would wait up to one week to get an answer on a GeoNet question before contacting Esri. If it is an urgent question I would probably go straight to Esri support. I would sometimes not bother contacting Esri support after posting an unanswered question on GeoNet just because it isn't urgent or mission critical. Yes. If there is someone capable of answering my question, I would always appreciate the information; I don't care if they are from Esri or Antarctica. ... View more

I didn't think about doing this either. Interesting idea, I'll have to give it a try. ... View more

We use cx_Oracle as well. Here's a sample snippet that I use. import cx_Oracle try:     oracle_db = u'UserNameHere/PasswordHere@DatabaseNameHere'     sql = "SELECT * FROM TABLE_NAME"     cnxn = cx_Oracle.connect(oracle_db)     sqlcursor = cnxn.cursor()     sqlcursor.execute(sql)     sqlresult = sqlcursor.fetchall()     # Validate and process result except Exception as err:     print err finally:     sqlresult = None     if 'sqlcursor' in locals():         sqlcursor.close()         del sqlcursor     if 'cnxn' in locals():         cnxn.close()         del cnxn The result table can be returned in different ways, so you should validate it before you try to process it. Valid SQL query but no rows returned: empty list [] Exactly one row with only one field value returned: single item tuple in a list [(val,)] More than one row returned with more than one field: list of tuples, each row being a tuple [(val, val), (val, val)] The third scenario is the most common, and what you should expect with the SQL query you posted. The number of tuples is the number of rows. The number of items in each tuple is the number of fields. ... View more

Nailed it. Thanks Joshua! ... View more