Latest Contributions by JaredPilbeam2

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

Where do I go to install modules to run in AGOL Notebooks? I've read you can import them by running in a cell, for ex: !pip install geopandas   But, why isn't arcpy accessible?  ... View more