Latest Contributions by JaredPilbeam2

Looking for some help. The title of my post isn't the greatest. What I'm trying to do is update an empty field (Pdfs) of my feature class with a full URL that's pulled from HTML of a webpage. I'm matching the ALT values of the webpage with the DXF_TEXT column in the feature class and writing the matching URL into the Pdfs column. # existing column in the table of my feature class DXF_TEXT 01-01A-E 01-01A-W 01-01B-E 01-01B-W   import requests from bs4 import BeautifulSoup from urllib.parse import urljoin import arcpy base_url = "https://www.willcountysoa.com/section/TaxMaps/wheatland.htm" resp = requests.get(base_url) soup = BeautifulSoup(resp.text, "html.parser") taxmapgrid_feature = r'\path\to\featureclass' # dictionary of ALT text to the corresponding URL. alt_to_url = {} for a in soup.find_all("area"): alt = a.get("alt") if alt: alt_to_url[alt] = urljoin(base_url, a["href"]) # Match the ALT values with the DXF_TEXT column in the feature class and # write the matching URL into the Pdfs column. with arcpy.da.UpdateCursor(taxmapgrid_feature, ["DXF_TEXT", "Pdfs"]) as cursor: for row in cursor: row[1] = alt_to_url.get(row[0]) print(row) cursor.updateRow(row) This code will run without error and print but no values are put into the table. Prints: ['01-24B-E', None] ['01-24B-W', None] ['02-24C-E', None] ['02-24C-W', None]   ... View more

This seems really basic but I can't wrap my head around it. When you use the Geocode File tool to geocode a CSV file and set the Output Fields to Location Only for clarity it gives you a Shape X and Shape Y field. The coordinate system of the locator on our Portal is NAD 1983 StatePlane Illinois East FIPS 1201 (US Feet). So, the values are in this CRS, I assume. And they look like this, for example: Shape X Shape Y 1079735.426634 1755288.295226 1073135.900792 1775480.932334 1045202.383496 1836304.838901  What are these field values? They aren't mentioned here. Can I get decimal degrees from them?  EDIT: here is a test address--1029 Shagbark Ct Apt 2e, New Lenox, IL 60451 ... View more

This code is in the def execute() function of a python toolbox. A table is geocoded. Then I want to remove spaces in two column names with the same out file parameter.  The tool runs without error, and the file is saved to a directory. But, the spaces are not removed. I'm thinking this is because the arcpy.geocoding.GeocodeFile() function hasn't been returned yet. Can anyone clue me in? def execute(self, parameters, messages): """The source code of the tool.""" import arcpy import os import pandas as pd outfile = parameters[1].valueAsText outloc = os.path.dirname(outfile) outname = os.path.basename(outfile) arcpy.geocoding.GeocodeFile( in_table=parameters[0].valueAsText, locator="https://filepathto/GeocodeServer/Locators/Locator_AddPts", address_fields="'Address or Place' ADDRESS VISIBLE NONE;Address2 <None> VISIBLE NONE;Address3 <None> VISIBLE NONE;Neighborhood <None> VISIBLE NONE;City CITY VISIBLE NONE;County COUNTY VISIBLE NONE;State STATE VISIBLE NONE;ZIP ZIPCODE VISIBLE NONE;ZIP4 <None> VISIBLE NONE;Country <None> VISIBLE NONE", output_type="CSV", output_location=outloc, output_name=outname, country=None, location_type="ROUTING_LOCATION", category=None, output_fields="LOCATION_ONLY" ) # Pandas section ------ df = pd.read_csv(parameters[1].valueAsText) #replace white space in column name with no white space df = pd.DataFrame(columns=['Shape X','Shape Y']) df.columns = [col.replace(' ','') if isinstance(col, str) else col for col in df.columns] df.to_csv(os.path.join(parameters[1].valueAsText)) return   I tried putting the pandas section in this section of the python toolbox, but it produces an error and I'm not even sure what goes here. def postExecute(self, parameters): """This method takes place after outputs are processed and added to the display.""" return   ... View more

Is BUG-000103046 really fixed? I'm in Pro v. 3.5.2 and I can not add a locator to a project from an Enterprise Portal using the Catalog. I can navigate to the locator I want but when I click it it never loads. The one time I got it to show up in Catalog it was broke.   ... View more

I'm attempting to create a python toolbox script that geocodes a CSV. It will be my version of the Geocode Addresses tool. What do I need to do to get the Field parameter to accept the 'ADDRESS' field of my CSV? Right now, the 3rd param accepts a Field datatype. I didn't see a good option in parameter controls either. If i run this tool as is I receive errors. Two of the errors mention needing an output parameter, which I'll get to. I'm assuming Error 000800 is referring to the Field parameter, but beyond that I don't really know. Maybe it's in the script itself.   class GeocodeFile: def __init__(self): """Define the tool (tool name is the name of the class).""" self.label = "Geocode File" self.description = "Geocodes a local file and saves it back to the same directory." self.params = arcpy.GetParameterInfo() def getParameterInfo(self): """Define the tool parameters.""" # 1st param param0 = arcpy.Parameter( displayName="Your CSV", name="your_csv", datatype="DEFile", parameterType='Required', direction='Input' ) # 2nd param param1 = arcpy.Parameter( displayName="Geocoder", name='geocoder', datatype="DEAddressLocator", parameterType='Required', direction='Input' ) # 3rd param param2 = arcpy.Parameter( displayName="Field", name='fields', datatype="Field", parameterType='Required', direction='Input', ) # param2.controlCLSID = '{172840BF-D385-4F83-80E8-2AC3B79EB0E0}' # param2.value="ADDRESS" params = [param0,param1,param2] return params def isLicensed(self): """Set whether the tool is licensed to execute.""" return True def updateParameters(self, parameters): """Modify the values and properties of parameters before internal validation is performed. This method is called whenever a parameter has been changed.""" return def updateMessages(self, parameters): """Modify the messages created by internal validation for each tool parameter. This method is called after internal validation.""" return def execute(self, parameters, messages): """The source code of the tool.""" import arcpy arcpy.geocoding.GeocodeFile( in_table=parameters[0].valueAsText, locator=parameters[1].valueAsText, address_fields=parameters[2].valueAsText, output_type=parameters[0].valueAsText, # output_location=r"C:\Users\test", # output_name="geocodedfile", # country=None, # location_type="ROUTING_LOCATION", # category=None, # output_fields="ALL" ) return def postExecute(self, parameters): """This method takes place after outputs are processed and added to the display.""" return       ... View more