Latest Contributions by jaykapalczynski

Im trying to do this and stuck Take a JSON string with address and distance set those to variables Geocode the Address to get an XY and set those to Variables Buffer a polygon of the state using the distance variable created from the DataInput JSON  Define the State Boundary Buffer the State Boundary and set into memory Test ot see if the point is within that Buffered State Boundary Return True if its within and False if Outside the Buffered State Boundary ERROR: Traceback (most recent call last): File "E:\ArcGIS Server\ArcGIS\xxxxxxxx.py", line 87, in <module> results = arcpy.SelectLayerByLocation_management(ptGeometry, 'INTERSECT', 'IN_MEMORY/BufferGeom') File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\management.py", line 7891, in SelectLayerByLocation raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000368: Invalid input data. Failed to execute (SelectLayerByLocation). Can Anyone see anything obvious as to why I am tripping this error? import arcpy import requests import json import uuid #dataInputParameter1 = arcpy.GetParameterAsText(0) dataInputParameter1 = '{"Location":[{"address":"6188 Maddox Blvd, Chincoteague, VA, 23336","distance":"12" }]}' # ADD ADDITIONAL VARIABLE FOR RETURN RESULT varResult = "true" textDict = json.loads(dataInputParameter1) langs = [] for SpecificLocation in textDict['Location']: varsearchAddress = SpecificLocation["address"] varsearchDistance = SpecificLocation["distance"] print ("address: " + varsearchAddress) print ("distance: " + varsearchDistance) print "" # LOCAL VARIABLES coordinates = "" countList = [] countyField = "FIPS2" countList2 = [] finalList = [] txt_list = "" txt_list2 = "" data = "" # GEOCODERS geoCodeUrl = r"https://gismaps.vita.virginia.gov/arcgis/rest/services/Geocoding/VGIN_Composite_Locator/GeocodeServer/findAddressCandidates" searchAddress = varsearchAddress searchDistance = varsearchDistance # CONVERT MILE TO METERS FOR SPATIAL BUFFER distanceMeters = int(varsearchDistance) * 1609.34 def singleAdressGeocode(address, geoCodeUrl, outSR = "4326"): #def singleAdressGeocode(address, geoCodeUrl, outSR = "26917"): ##clean up the address for url encoding address = address.replace(" ", "+") address = address.replace(",", "%3B") #send address to geocode service lookup = requests.get(geoCodeUrl + "?SingleLine=" + address + "&outSR=" + outSR + "&maxLocations=1&f=pjson") data = lookup.json() if data["candidates"]: ##coords = data["candidates"][0]["location"] ##return coords return data else: ##no results return "Address not geocoded: " + address # DEFINE VARIABLES FOR THE ADDRESS AND X AND Y VALUES geocodeResult = singleAdressGeocode(searchAddress, geoCodeUrl) addressResult = geocodeResult["candidates"][0]["address"] coordinateX = geocodeResult["candidates"][0]["location"]["x"] coordinateY = geocodeResult["candidates"][0]["location"]["y"] strcoordinateX = str(coordinateX) strcoordinateY = str(coordinateY) arcpy.env.workspace = r"E:/ArcGISProjects/CountySelection/xxxxx.sde" # CREATE THE POINT FROM THE X AND Y point = arcpy.Point(coordinateX, coordinateY) ptGeometry = arcpy.PointGeometry(point) # DEFINE THE STATE FEATURE CLASS arcpy.MakeFeatureLayer_management(r"E:/ArcGISProjects/CountySelection/xxxxx.sde/Boundary", "state_lyr") # BUFFER THE STATE LAYER AND PUT IT IN MEMORY arcpy.Buffer_analysis('state_lyr', 'IN_MEMORY/BufferGeom', distanceMeters) # TEST TO SEE IF POINT IS INSIDE THE BUFFERED GEOMETRY results = arcpy.SelectLayerByLocation_management(ptGeometry, 'INTERSECT', 'IN_MEMORY/BufferGeom') #Test if there are any polygons points: if int(arcpy.GetCount_management('IN_MEMORY/BufferGeom').getOutput(0))==0: raise Exception("Selected points do not overlap any polygons.") print "Selected points do not overlap any polygons." varResult = "true"‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I have a scenario where: Feature Class       I have Event Data - Feature Class with point locations etc. Tables      1 to 1 - Citizen Info (this data could be added to the event data FC)       1 to Many - Species present Table (need to add multiple species associated with the Event FC)      1 to 1 - Bear Info Table      1 to 1 - Sick Dead Table      1 to 1 - Hemorrhagic Info Table The three last tables above are categories that may or may not be populated.  But they will be related back to the Event Data Feature Class. Is there a way that I can trigger a connection to one of the 3 tables (Bear, Sick, Hemorrhagic) from the Event Data FC. User Story A user adds and Event The form will have options to add data to the related table "Citizen Info" (again I think this can be added to the FC) The form will have options to add data (1 or many) to the related Species Table If there is a bear present the form will present the option to add data to the related Bear Info Table OR If there is a sick or dead animals present the form will present the option to add data to the related Sick Dead Table OR If there is a hemorrhagic present the form will present the option to add data to the related Hemorrhagic Info Table Please see attachment I am trying to find a solution that will allow me to add data to the Event Table, Citizen Info, and Species Info in the same fashion  BUT I then want three other RELATED tables there that can be selected to enter data to 1 or all of the Bear, Sick Dead or Hemorrhagic tables. I am not sure if this can be done with Survey123 Can I add data to a FC and have 3 different Related Tables and be able to choose which one I want to add data to? ... View more

Just looking for a simple zoom ...  I don't think I need to query anything....I am adding a feature to a graphics layer....then want to zoom to that Graphics Layer Thoughts? var mapright = new Map({ basemap: "dark-gray", layers: [resultsLayer2, resultsLayer4] }); var viewright = new MapView({ container: "viewDivright", map: mapright }); function displayResultsUniqueID(results) { var features2 = results.features.map(function (graphic) { graphic.symbol = { type: "simple-fill", // autocasts as new SimpleFillSymbol() color: [51, 51, 204, 0.9], style: "solid", outline: { // autocasts as new SimpleLineSymbol() color: "white", width: 1 } }; return graphic; }); window.resultsLayer2.addMany(features2); viewright.goTo(features2.Extent); }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I am having issues with a a WHEREClause....anyone see anything wrong here. THIS WORKS FINE inputFeatureclass = r"E:/ArcGISProjects/County/xxx.sde/FeatureClassName" dataInputParameter2 = "{9A35172E-071F-4A33-B191-172A9B4B02AE}" whereClause = "FIELDNAME = " + "'" + dataInputParameter2 + "'" fields = ['ID', 'FIELDNAME', 'UNIQUEID', 'OBJECTID'] with arcpy.da.SearchCursor(inputFeatureclass, fields, whereClause) as cursor: for row in cursor: print "--QUERY RESULT FROM MAIN FEATURE SERVICE ------" print('{0}, {1}, {2}, {3}'.format(row[0], row[1], row[2], row[3])) print ""‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ BUT NOW TRYING TO USE -- SelectByAttrbute inputFeatureclass = r"E:/ArcGISProjects/County/xxx.sde/FeatureClassName" dataInputParameter2 = "{9A35172E-071F-4A33-B191-172A9B4B02AE}" whereClause = "FIELDNAME = " + "'" + dataInputParameter2 + "'" results2 = arcpy.SelectLayerByAttribute_management(inputFeatureclass, 'NEW_SELECTION', whereClause)‍‍‍‍‍‍‍‍‍‍‍‍ Now I get this error when trying SelectByAttrbute NOTE:  This is a GUID field data type in SDE SQL Server db Traceback (most recent call last): File "E:\ArcGISProjects\County\Python\UpdateGeometryJSON.py", line 94, in <module> results2 = arcpy.SelectLayerByAttribute_management(inputFeatureclass, 'NEW_SELECTION', whereClause) File "C:\Program Files (x86)\ArcGIS\Desktop10.5\ArcPy\arcpy\management.py", line 7744, in SelectLayerByAttribute raise e ExecuteError: Failed to execute. Parameters are not valid. The value cannot be a feature class ERROR 000840: The value is not a Raster Layer. ERROR 000840: The value is not a Mosaic Layer. Failed to execute (SelectLayerByAttribute). ... View more