Latest Contributions by DylanHarwell

That was trick! Thank you for your help, I'm such a noob at this.  ... View more

I read that wiki, not sure how to do this: 'Access your add-in project's Properties page through its context menu.' ... View more

The config was auto generated, and I have not touched it since adding the button to the project. Looks like it added _Module, _Group1, _Button1 to the namespace name. Do these all need to be identical? ... View more

Hi Uma, thanks for the reply! So when I try just that line and click the button in Pro it grays out and nothing happens. I tried a variety of the suggestions on the stackoverflow site and it's the same behavior, button grays out on first click and no browser window opens. The final suggestion seemed promising but did not work. What is commented out is what I tried just before that.  namespace StreetViewButton { internal class OpenGoogle : Button { protected override void OnClick() { var processes = Process.GetProcessesByName("Chrome"); var path = processes.FirstOrDefault()?.MainModule?.FileName; string url = "http://google.com"; //System.Diagnostics.Process myProcess = new System.Diagnostics.Process(); //myProcess.StartInfo.UseShellExecute = true; //myProcess.StartInfo.FileName = url; Process.Start(path, url); } } } ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I just ran into a situation where I needed to figure out field mapping with Python, and my situation is slightly different than the examples posted here so I thought I'd share my solution.  The Problem: We have a web map that has what we call 'compiled layers'. These are layers built from features joined to SQL Server views, which can be incredibly slow and impractical on a web map. I built a python module to reuse in scripts that run every night and perform the join, delete and append to target feature classes in our database. Originally these were set up with models, but now we are going to create a lot more and that is the reason behind scripting this. Whenever these models were first created, the target feature class only contained a subset of fields from the joined tables - so field mapping came into play.  The examples above assume that you know what fields you are mapping, or that you already have a field map string. The method I came up with is generic enough to create a field map with no knowledge of the append fields or target fields. And since we are an organization, some trickery is involved to match the fields created after the join since they aren't just a field name but are something like <DB name>.DBO.<feature name>. For info on what the EmailService module is and how to get email notifications when scripts fail, check this out.  #------------------------------------------------------------------------------- # Name: CompiledLayers.py # # Author: Dylan Harwell - GIS Tech - City of GJ # # Created: 25/04/2019 # Copyright: (c) dylanh 2019 # #------------------------------------------------------------------------------- import arcpy arcpy.env.overwriteOutput = True class CompiledLayers(object): """Custom class to create compiled layers in lieu of joined layers on web maps.""" def __init__(self): self.ignore = ['OBJECTID', 'Shape', 'Shape.STArea()', 'Shape.STLength()', 'STArea()', 'STLength()', 'GlobalID', 'ESRI_OID', 'SHAPE' ] def createCompiledLayer(self, join_fc, in_field, join_table, join_field, join_type, target_fc): """Makes feature layer, joins to sql server table, sets up fieldmapping, deletes and appends target feature class in gjgisweb.sde.""" arcpy.MakeFeatureLayer_management(join_fc, 'temp_lyr') arcpy.AddJoin_management('temp_lyr', in_field, join_table, join_field, join_type) target_fields = [f for f in arcpy.ListFields(target_fc) if f.name not in self.ignore] append_fields = [f for f in arcpy.ListFields('temp_lyr') if f.name.split('.')[-1] not in self.ignore] fields_to_map = [] for a in append_fields: for t in target_fields: if a.name.split('.')[-1].lower() == t.name.lower(): fields_to_map.append((a.name, t.name)) fieldmapping = arcpy.FieldMappings() for fields in fields_to_map: field_map = arcpy.FieldMap() field_map.addInputField('temp_lyr', fields[0]) field_map.addInputField(target_fc, fields[1]) fieldmapping.addFieldMap(field_map) arcpy.DeleteFeatures_management(target_fc) arcpy.Append_management('temp_lyr', target_fc, 'NO_TEST', fieldmapping) def main(): pass if __name__ == '__main__': main() ################### Example of using this module in a script ######################## import CompiledLayers as CL import EmailService as ES def getTime(): """Function to fetch current date and time.""" date_time = time.strftime("%Y%m%d") + "_" + time.strftime("%H%M%S") return date_time # Set path to log file log = 'T:...\\Log\\CompileNorthstarTrashParcels' + getTime() + '.txt' # Set variables join_fc = 'T:...\\dbConnections\\gjgisprod.sde\\gjgisprod.DBO.Parcel' in_field = 'PARCEL_NUM' join_table = 'T:...\\dbConnections\\ns.sde\\Northstar64_Live.dbo.gj_trashdata' join_field = 'PARCEL' join_type = 'KEEP_COMMON' target_fc = 'T:...\\dbConnections\\gjgisweb.sde\\gjgisweb.DBO.CompiledLayers\\gjgisweb.DBO.northstarTrashParcels' with open(log, 'w') as log_file: try: log_file.write('Calling CompiledLayers module at ' + getTime() + '\n') compiler = CL.CompiledLayers() compiler.createCompiledLayer(join_fc, in_field, join_table, join_field, join_type, target_fc) log_file.write('Succeeded creating compiled layer at ' + getTime()) except Exception as e: log_file.write('Failed at ' + getTime() + '\n') log_file.write(e.message) # Send email to server admin if script fails service = ES.EmailService() subject = 'Server Script Failure!' body = 'CompiledNorthstarTrashParcels.py failed' recip = 'jacksont@gjcity.org' service.configMessage(subject, body) service.sendEmail(recip)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Gotta love those extremely insightful error messages ... View more

Have you tried the old 'unplug and plug back in' technique? ... View more

Same thoughts. Each click, even just toggling layers on and off in the TOC, causes everything to gray out for several seconds. Also this Basic Geoprocessing in Pro is SLOW ... View more

Yea that is odd. I was not generating lines when I ran this analysis, only polygons. I was doing 4 and 8 minute drive times, and I noticed the 4 minute polygons would turn out pretty detailed and follow roads around large open space areas. But the 8 minute polygons were much more generalized in the middle and all the open space areas with no roads were filled in. ... View more

I decided to just do it all in Pro from now on to stay consistent, and I think I remember liking the way the Pro polys looked more lol ... View more

I've compared both and the polygons still were slightly different. Not as radically different as in this example though. ... View more