Latest Contributions by JamesCrandall

https://github.com/arcpy/update-hosted-feature-service/blob/master/update.py We implemented this for our AGOL org account and it's still running just fine to update various Service Definition items (although we're migrating these off hosted more and more). To compliment the AGOLHandler class we also employed the setttings.ini and base64 into the scripts to provide a little bit of security (it really just removes transparency and not really a complete secure solution) and does just fine for logging in/out of AGOL. https://blogs.esri.com/esri/arcgis/2014/01/24/updating-your-hosted-feature-service-for-10-2/ ... View more

We've been doing this for several years by simply keeping it all in procedural code and a linked server instance (you're just managing non-spatial data).  Have the assessor setup a view, you create a linked server instance on your db and then you can just access the attributes as needed with a Stored Procedure or other. ... View more

definitely. ... View more

Actually for example "select count(name) from isolines where name='2620_1159'" works perfectly against Oracle.   Since I only need to know if there are records or not, the SQL statement select max(name) from isolines where name='2620_1159' is a usefull alternative (by checking for empty results as shown in python below). So why don't you just implement that with cx_Oracle?   arcpy is excellent at a lot of things, but perhaps SQL procedural language is not one of them. import cx_Oracle ### Build a DSN (can be substituted for a TNS name)     dsn = cx_Oracle.makedsn(ip, port, SID) oradb = cx_Oracle.connect("user", "password", dsn) cursor = oradb.cursor() sqlQry = """select count(name) from isolines where name='2620_1159'""" cursor.execute(sqlQry) cxRows = cursor.fetchall() #try to count rows if cursor.rowcount == 0:    print 'no rows in cursor' else:    for row in cxRows:       'do stuff with row'‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I tend to agree that there is a need to move into FileGeodatabases rather than those personal GDB's.  Other than that, you can try to join the path and feature class name together instead of raw strings. Instead of r'Y:\projects\dnr_svmp2016\db\SVMP_2000_2015_DB.v52_20170803\SVMP_DB_v5.2_20170803_AB.mdb\site_samples'‍ Try import os gdb = r'Y:\projects\dnr_svmp2016\db\SVMP_2000_2015_DB.v52_20170803\SVMP_DB_v5.2_20170803_AB.mdb' featureclass_name = r'site_samples' featureclass = os.path.join(gdb, featureclass_name) if arcpy.Exists(featureclass):    'do stuff‍‍‍‍‍‍‍ ... View more

Thanks David! ... View more

Does anyone have an example of what the service looks like that allows for downloading sessions in IE?  I'm planning to just write it in python and publish as a GP service on our ArcGIS Server but would like to understand what the script needs to do. ... View more

Robert -- it was just easier to start over from scratch, thanks for the encouragement.  I was able to get things to load as intended and can now focus on building in the functionality.  It's probably a good thing that I'm having to redo/rinse/repeat until I get it setup correctly. I will say that there's just a lot of little details, spread out over components, that all need to be set correctly.  Sorry for the lack of details here but it's just a general observation for those intending to dig into building these things out from an example. ... View more

Yes it is.  Well, sort of -- I've taken an existing widget, renamed things and removed a lot of the functionality. I'll take another stab at the widget code -- perhaps there's simply an incorrect declaration of something. Thank you! ... View more

The search field we are using contains nulls and empty string values, however when we configured the widget to "Hide Null data in widget results and popups" there are some that still show up in the drop-down list. The Expression set to "is" with the "Unique" property. Is this expected? Thanks! ... View more

I'll be using the grouped table to join back in with the feature class and calculating a field. ... View more

Excellent!  I'll give it a go as well. ... View more

Ah -- that was my goof.  Yes, you are correct it generates the desired output. Double award points for questioning my obvious flawed assessment! ... View more