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