Latest Contributions by DavidBuehler

‎08-30-2017

Robert - http://comgis.ci.marshfield.wi.us/test%20url%20pass/?esearch=CC7_B_6_2&slayer=0&exprnum=0

‎08-30-2017

Hi Robert, I am having an issue where the search url does not immediately zoom to the result(s) like your demo (ArcGIS Web Application). I am using the export url to zoom specifically to a grave site. The url works opening the application and then nothing. It does not display that a site was passed into it, until I click the widget. I have a attached my settings. Did I miss something? Does it not like custom map titles/projections?

‎08-17-2017

Hi Chris, I saw that link too. I am not sure it is possible for what I want to do. I want to select what is already there from one of three different parcel sets, and I don't need to add anything. The features already exist. I just need the user to select them and feed the model. I guess one what I know it works is use the Select Feature tool on the particular feature class/layer and then load that as the parameter value in the model. I was hoping that you open the model, the model says, "Hey select me a layer and some parcels", then proceed. I guess there is going to have to be a disconnect.

‎08-17-2017

I feel like I am either over thinking this or I am missing something. What I would like to do is have the user pick an input layer (feature class), set the field to dissolve on, and then finally select the parcels interactively using a tool or thee tool "Select Features" from the standard toolbar. Is this possible?

‎06-27-2017

We too are still having issues.

‎06-14-2017

Hi Ben, I have a working theory now after thinking a little more on what you suggested. I noticed if a layer is fully qualified, meaning it goes all the way https://.../..../..../rest/parcels/MapServer/14 it gives a popup in Workforce, but if you use up to the MapServer part it doesn't give you a popup. Which is annoying because if you have a bundled map service it is generally bundled for a reason, but it not a total deal breaker to individually breakdown rest end points. I think it will be a little more work than I had anticipated, but workable. Thanks for the suggestion, and confirming that indeed you can have a supporting layer have a pop up.

‎06-12-2017

I see you can configure a web map to support additional layers in WorkForce (https://workforce.arcgis.com/projects) beyond just the base map for the dispatcher and the worker maps. For example adding a parcel layer or an address layer for context to where something is getting dispatched. What I would like to know is if popups for those supporting layers (like parcels or addresses) are supported for clicking on the feature and gleaning additional information like a parcel number or ownership information from the map display? It does not appear to be possible, even though I setup the popups for those layers. Any thoughts? Is this something can be put into a future release?

‎03-17-2017

I build my own base maps. I am not a fan of the web mercator auxiliary sphere. We prefer our local projection. When I do use an ESRI base map, I tend to use the aerials, as those are the most useful for us, but tend to lack the resolution we need for most our projects.

‎02-08-2017

How did you solve this?

‎02-06-2017

From a user stand point with one device and multiple users of that device. It would be great, if there were some global settings for all users. Specifically, when it comes to "Location" settings under a profile. First up, there should be a log out button, so different users do not have to remember to switch users, especially for those of us that do not want to mess with over arching profiles for the device. Second, regardless of who is signed in, the location options should push through. It should not be specific to a user that, "this user is going to use the high accuracy GPS, and user gets the default on the device." This is because if you have a high accuracy GPS receiver that will pair with the device, why not use it, and allow the user to choose not to use it. That way instead of setting up different profiles and having to go back in and set up the location profile, it is a global setting regardless of who is signed-in. One and done.

‎01-23-2017

Good Morning Ian, I must be missing something. In figuring out why I have a syntax errors, what I have found is break is for a loop, and result in results.getOutput was not defined. If I take out the break and replace it with a print statement, it actually just flies right through and does everything and does not stop. Here is what I got so far. Lines 15-23 are based on what you responded with. Suggestions? # import modules import arcpy # Set workspaces scratchWorkspace = r'C:\GISScripts\Scratch\Scratch.gdb' selectExport = r'C:\GISScripts\Scratch\ReversedGeoCoded.gdb\GeoConcernsV2' missingAddresses = "Match_Address" ci = "ConcernID" sql = """{} is NULL AND {} is not NULL""".format(missingAddresses, ci) #If there are any records that meet the sql variable then proceed, else just print something and/or end arcpy.MakeFeatureLayer_management(selectExport, 'temp_Layer', sql) # It tells me result was not defined result = arcpy.GetCount_management('temp_Layer') if int(result.getOutput(0)) > 0: pass # break kept giving me a syntax error which is due to it not being a loop else: print "Goodbye!" #print "Export Only missing Addresses" #raw_input("Press enter to continue ;)") # Select concerns that have missing addresses and send them to a scratch workspace for geocoding arcpy.FeatureClassToFeatureClass_conversion(selectExport, scratchWorkspace, "NoAddresses", sql) #print "Export Successful" #print "Are You Ready to Start Reverse Geocoding?" #raw_input("Press enter to continue ;)") # Reverse Geocode the missing addresses that were selected from the main concern features arcpy.ReverseGeocode_geocoding(in_features="C:/GISScripts/Scratch/Scratch.gdb/NoAddresses", in_address_locator="C:/GISScripts/Scratch/Scratch.gdb/NearestAddress", out_feature_class="C:/GISScripts/Scratch/Scratch.gdb/R1T", address_type="ADDRESS", search_distance="100 Meters") #arcpy.ReverseGeocode_geocoding(in_features="C:/GISScripts/Scratch/Scratch.gdb/NoAddresses", in_address_locator="C:/GISScripts/Scratch/AddressLocator.gdb/NearestAddress", out_feature_class="C:/GISScripts/Scratch/ReversedGeoCoded.gdb/R1T", address_type="ADDRESS", search_distance="100 Meters") #Keeps Bombing Upon completion of reverse geocoding against the file geodatabase. It does not make it to the delete management function #print "Reverse Geocode Successful" arcpy.Delete_management(r'C:\GISScripts\Scratch\Scratch.gdb\NoAddresses') # print "Feature class deleted." del selectExport # print "deleted variable for connection. Would you like to Exit?" # raw_input("Press enter to exit ;)") # Set workspace for Editing Session workspace = r'C:\GISScripts\Scratch\ReversedGeoCoded.gdb' #print "Workspace Created" # Start edit session edit = arcpy.da.Editor(workspace) edit.startEditing(False, False) edit.startOperation() #print "I am going to crash" #print "Edit Session Started" # Join and Calculate targetFeatures = r'C:\GISScripts\Scratch\ReversedGeoCoded.gdb\GeoConcernsV2' joinFeatures = r'C:\GISScripts\Scratch\Scratch.gdb\R1T' #print "Joining Valaribles are created" fieldmappings = arcpy.FieldMappings() fieldmappings.addTable(targetFeatures) fieldmappings.addTable(joinFeatures) print "Fieldmapping created" layerName1 = "joinedTJ_view" layerName2 = "GREAddress_view" print "Joining variables created" #Failes somewhere in here #raw_input("Press enter to continue ;)") arcpy.MakeFeatureLayer_management(joinFeatures, "joinedTJ_view") arcpy.MakeFeatureLayer_management(targetFeatures, "GREAddress_view") print "Made Layers" arcpy.AddJoin_management("GREAddress_view", "ConcernID", "joinedTJ_view", "ConcernID", "KEEP_COMMON") print [i.name for i in arcpy.ListFields('GREAddress_view')] print "Joined Up Sir" fieldName1 = u'GeoConcernsV2.Match_Address' fieldName2 = u'R1T.REV_Street' calcExpression ="!"+ fieldName2 +"!" # Replace a layer/table view name with a path to a dataset (which can be a layer file) or create the layer/table view within the script # The following inputs are layers or table views: "GeoReporting Features" arcpy.CalculateField_management(layerName2, fieldName1, calcExpression, "PYTHON_9.3") print "Field Calculation Done" arcpy.RemoveJoin_management(layerName2,"R1T") print "Removed Join" arcpy.Delete_management(r'C:\GISScripts\Scratch\Scratch.gdb\R1T') print "Feature class deleted" # Close edit session edit.stopOperation() edit.stopEditing(True)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎01-20-2017

I am going to be real honest I am not sure how to format the script in order to get it to check if there are "new" features and then process it, or just move on if there are no new ones. Now that i have a working reverse geocoding script, I would like to take it to that that level. I am trying to minimize the locking time so that is why it exports out a subset first then joins it back and field calculates. If there is a better way to do this I am all ears. Otherwise, below is the code I have, and it will be run as a scheduled task. Any help would be much appreciated. Line 27 is what i am asking #------------------------------------------------------------------------------- # Name: module1 # Purpose: # # Author: Dbuehler # # Created: 19/10/2016 # Copyright: (c) Dbuehler 2016 # Licence: <your licence> #------------------------------------------------------------------------------- #---------------------------------------------------------------------------------------------------- # The First part of this script pulls out concerns with missing addresses and places it in a temporary feature class for geocoding. It then reverse geocodes against that outputted selection, and cleans up the selection feature class. #---------------------------------------------------------------------------------------------------- # import modules import arcpy # Set workspaces scratchWorkspace = r'C:\GISScripts\Scratch\Scratch.gdb' selectExport = r'C:\GISScripts\GRSTasksConnection.sde\GIS2.GIS.GeoConcernsV2' missingAddresses = "Match_Address" ci = "ConcernID" sql = """{} is NULL AND {} is not NULL""".format(missingAddresses, ci) #If there are any records that meet the sql variable from selectexport then proceed, else just print something and/or end #print "Export Only missing Addresses" #raw_input("Press enter to continue ;)") # Select concerns that have missing addresses and send them to a scratch workspace for geocoding arcpy.FeatureClassToFeatureClass_conversion(selectExport, scratchWorkspace, "NoAddresses", sql) #print "Export Successful" #print "Are You Ready to Start Reverse Geocoding?" #raw_input("Press enter to continue ;)") # Reverse Geocode the missing addresses that were selected from the main concern features arcpy.ReverseGeocode_geocoding(in_features="C:/GISScripts/Scratch/Scratch.gdb/NoAddresses", in_address_locator="C:/GISScripts/Scratch/Scratch.gdb/NearestAddress", out_feature_class="C:/GISScripts/Scratch/Scratch.gdb/R1T", address_type="ADDRESS", search_distance="100 Meters") #arcpy.ReverseGeocode_geocoding(in_features="C:/GISScripts/Scratch/Scratch.gdb/NoAddresses", in_address_locator="C:/GISScripts/Scratch/AddressLocator.gdb/NearestAddress", out_feature_class="C:/GISScripts/Scratch/ReversedGeoCoded.gdb/R1T", address_type="ADDRESS", search_distance="100 Meters") #Keeps Bombing Upon completion of reverse geocoding against the file geodatabase. It does not make it to the delete management function #print "Reverse Geocode Successful" arcpy.Delete_management(r'C:\GISScripts\Scratch\Scratch.gdb\NoAddresses') # print "Feature class deleted." del selectExport # print "deleted variable for connection. Would you like to Exit?" # raw_input("Press enter to exit ;)") # Set workspace for Editing Session workspace = r'C:\GISScripts\GRSTasksConnection.sde' #print "Workspace Created" # Start edit session edit = arcpy.da.Editor(workspace) edit.startEditing(False, False) edit.startOperation() #print "I am going to crash" #print "Edit Session Started" # Join and Calculate targetFeatures = r'C:\GISScripts\GRSTasksConnection.sde\GIS2.GIS.GeoConcernsV2' joinFeatures = r'C:\GISScripts\Scratch\Scratch.gdb\R1T' #print "Joining Valaribles are created" fieldmappings = arcpy.FieldMappings() fieldmappings.addTable(targetFeatures) fieldmappings.addTable(joinFeatures) #print "Fieldmapping created" layerName1 = "joinedTJ_view" layerName2 = "GREAddress_view" #print "Joining variables created" #Failes somewhere in here #raw_input("Press enter to continue ;)") arcpy.MakeFeatureLayer_management(joinFeatures, "joinedTJ_view") arcpy.MakeFeatureLayer_management(targetFeatures, "GREAddress_view") #print "Made Layers" arcpy.AddJoin_management("GREAddress_view", "ConcernID", "joinedTJ_view", "ConcernID", "KEEP_COMMON") #print [i.name for i in arcpy.ListFields('GREAddress_view')] #print "Joined Up Sir" fieldName1 = u'COMGIS2.GIS.GeoConcernsV2.Match_Address' fieldName2 = u'R1T.REV_Street' calcExpression ="!"+ fieldName2 +"!" # Replace a layer/table view name with a path to a dataset (which can be a layer file) or create the layer/table view within the script # The following inputs are layers or table views: "GeoReporting Features" arcpy.CalculateField_management(layerName2, fieldName1, calcExpression, "PYTHON_9.3") #print "Field Calculation Done" arcpy.RemoveJoin_management(layerName2,"R1T") #print "Removed Join" arcpy.Delete_management(r'C:\GISScripts\Scratch\Scratch.gdb\R1T') #print "Feature class deleted" # Close edit session edit.stopOperation() edit.stopEditing(True)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎01-20-2017

Ok, after several months of trouble shooting and tech support, I think we have a winner. When the script would run via idle, pyscripter, the task scheduler, etc. it was trying to use the 32 bit-version not the 64 bit-version. It blows up with the 32 bit-version, but is perfectly ok with the 64 bit-version. All I did was reconstitute the script and set it to use the 64 bit-version in the task scheduler and it works. I will post more if anyone wants to know more.

‎12-14-2016

Here is an example set up Test1 has the tables that contain ownership and GIS1 is where the parcels are. I do not think this is possible to have a live connection, less they were both in GIS1 or both in Test1.

‎12-14-2016

Thank you for sharing that link. This might be a basic question, but how does the "Register with Geodatabase" tool know to register the table from database 2 with geodatabase1 through connection xyz?

Online Status	Offline
Date Last Visited	‎04-03-2024 11:21 AM

My Ideas

Latest Contributions by DavidBuehler

Re: Pass Search Parameter in URL

Re: Pass Search Parameter in URL

Re: Interactively Selecting Features as a Model Parameter in Model Builder

Interactively Selecting Features as a Model Parameter in Model Builder

Re: Explorer app not honoring layer visibility in web map

Re: Popups in Workforce

Popups in Workforce

Re: What do you think of the Local Government Basemaps solution?

Re: Error in created of Layer in ArcGIS for Developers -> How can resolve this?

Global Setting for Collector for ArcGIS

Re: If then/else python to meet criteria or end script

If then/else python to meet criteria or end script

Re: Python Script Reverse Geocoding Fails

Re: Best way to join to multiple databases

Re: Best way to join to multiple databases

Re: Widgets in Development

Delete empty folder says 1 item in it

Convert hosted feature class into separate items f...

Re: Calculating Max and Second Max with counts of ...

Re: Custom report with a spot displaying the most ...