Latest Contributions by BlakeTerhune

arcpy.ArcSDESQLExecute() returns a boolean TRUE if a select statement was valid but no rows were returned. In your case, you're executing a procedure and I think it's just telling you the procedure ran successfully. ...for statements that do not return rows, it will return an indication of the success or failure of the statement (True for success; None for failure). Maybe try reformatting your SQL into a select statement to trick it into expecting rows back. ... View more

The Office of Policy Development and Research (PD&R) U.S. Department of Housing and Urban Development has a page with eGIS API and Metadata Documentation that some field names and descriptions of their data. Maybe some of it will be applicable to the housing data you're working with. eGIS Docs Page | HUD USER  ... View more

Wouldn't this return unwanted results if the street name started with CIR? For example: W CIRCLE VIEW DR I'm doing something similar and I use str.rpartition() head, sep, tail = st_name.rpartition(" CIR") if tail == '':     return head‍‍‍‍‍‍‍‍‍‍‍‍ If the tail partition string is empty, you know there is nothing else after the separator and it's safe to return the head. Edit: Also tagging https://community.esri.com/community/developers/gis-developers/python?sr=search&searchId=08a40ef2-e9bb-4c41-a843-b13ab3d6c973&searchIndex=0‌ ... View more

Tagging https://community.esri.com/community/developers/web-developers/arcgis-rest-api?sr=search&searchId=5def9e1c-dd15-4387-b63e-319f2ddad1f5&searchIndex=0‌ ... View more

Esri's documentation says a hosted feature layer is a type of hosted web layer. About hosted web layers—ArcGIS Online Help | ArcGIS  I think the "hosted" term is just to be more specific that it's something external from ArcGIS Online. This is probably just a change in naming compared to what you saw two years ago. ... View more

You're right, it does not return a formal table object, rather just a list of lists full of the row values. If you know the field names of what you're querying and just want to be able to refer to the fields in your code you could do one of the following: Assign the index value of the row list to a variable named as the field name Create a dictionary of dictionaries (edit: some interesting suff here) Look into using the named tuple. If you need an actual table of some kind, you could use GP tools in arcpy to create a table in memory and populate it with your query data, then save it out somewhere. Or, if you're just doing select queries, maybe you can just do a series of table views/feature layers with where clauses until you have what you need. Apologies if I'm just completely missing the mark here because I'm not entirely sure what exactly you're trying to accomplish. ... View more

Did you try arcpy.ArcSDESQLExecute()? ... View more

I would also like to point out that you can't edit a code block in place. You have to left click in it to select the block, then repeat the steps above to open the syntax highlighter. ... View more

I'm not an add-in wiz but here's some info on https://community.esri.com/docs/DOC-8691-posting-code-with-syntax-highlighting-on-geonet  ... View more

This can be done with Python but it isn't "dynamic." You would have to run the script each time you wanted the domain to be updated with new coded values. Is that acceptable? ... View more

I chose to use a toolbox script tool so I could create parameter input boxes with ArcToolbox, then the user just selects a database connection that has already been created; no need to enter user/pass every time. I know it's not an add-in but maybe you can convince whomever that a script tool is just as easy. ... View more

Take a look at ArcREST. https://community.esri.com/community/developers/gis-developers/python?sr=search&searchId=6bd1be40-c109-45f5-9987-87ec25ceb705&searchIndex=0‌ ... View more

Great resource, thanks for sharing. Their owl icon just looks like a guy with a huge beard. ... View more

Tagging thehttps://community.esri.com/community/developers/native-app-developers/arcgis-runtime-sdk-for-java?sr=search&searchId=56e58b47-0721-4b8b-8e45-cffa316621c9&searchIndex=1‌ community for better visibility of your question. ... View more

Yes. Like Brittney mentioned, you create fireCursor with only one field (city) so it will only have one index position, which is 0. The other problem is that your recreating cityList in your loop for each row so it will only ever have the last row value in it. You'd have to create your list variable before you get into the loop. cityList = [] with arcpy.da.SearchCursor(inTable, ["city"]) as fireCursor:     for row in fireCursor:         cityName = row[0]         if cityName not in cityList:             cityList.append(cityName)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Alternatively, you can simplify the whole thing by using set comprehension. cityList = {row[0] for row in arcpy.da.SearchCursor(inTable, ["city"])}‍‍‍‍‍ Which gives you a set object that only has the unique values in the city field of inTable. If this was in a RDBMS like SQL Server or Oracle, you could use a sql_clause parameter when you create the search cursor and use DISTINCT. ... View more