Latest Contributions by GeoJosh

‎07-08-2020

You're right, but there's still a large number of organizations who haven't made the switch yet. This line of code should work if the OP can bypass the cert verification step OR make the request over HTTPS.

‎07-08-2020

John, It looks like the server's certificate can't be validated. Have a look at the top comment in the StackOverflow discussion below. Creating a new SSLContext and passing it with the request should resolve the issue. python - urllib and "SSL: CERTIFICATE_VERIFY_FAILED" Error - Stack Overflow -Josh

‎07-02-2020

Hey Joe, If you have access to the REST endpoint of the service and Python 3, you can get this done using ArcPy. Here's a quick example I spun up. It's not perfect, but I ran it on a few different feature layers and it seems to work. import requests import json import arcpy # Set variables featureLayerURL = "https://sampleserver6.arcgisonline.com/arcgis/rest/services/DamageAssessmentStatePlane/FeatureServer/0" fgdbPath = r"C:\temp\test.gdb" featureClassName = "TEST1" featureClassGeometry = "POINT" # Get feature layer information in JSON format r = requests.get(featureLayerURL + "?f=json") # Get field information from the response fields = json.loads(r.text)["fields"] # Maps feature layer field types to feature class field types field_types = { "esriFieldTypeString": "TEXT", "esriFieldTypeDate": "DATE", "esriFieldTypeDouble": "DOUBLE", "esriFieldTypeInteger": "SHORT" } # Creates a new feature class fc = arcpy.CreateFeatureclass_management(out_path=fgdbPath, out_name=featureClassName, geometry_type=featureClassGeometry) # Adds a new field to the feature class for each entry in the "fields" variable, except for ObjectID and GlobalID. for field in fields: if field["type"] == "esriFieldTypeOID" or field["type"] == "esriFieldTypeGlobalID": pass else: arcpy.AddField_management(in_table=fc, field_name=field["name"], field_type=field_types[field["type"]], field_alias=field["alias"], field_is_nullable=field["nullable"], field_length=field["length"])

‎06-18-2020

Hi Joe, Typically, I install Anaconda. I do this for a few reason: It installs a package and environment manager (conda) The base environment includes a huge number of popular packages by default. Jupyter Notebook is installed alongside the environment. https://www.anaconda.com/products/individual -Josh

‎06-17-2020

Aaron, Go to ArcGIS Server Manager > Services > System and turn on the "CachingControllers" service, if it's turned off. -Josh

‎06-12-2020

Hi Michelle, The first portion of the formula needs to be in parentheses like this: ([Volume_2020] - [Volume_2019]) / [Volume_2019] Otherwise, the division will be performed before the subtraction due to order of operations. Let me know if this works! Best, Josh

‎06-12-2020

Peter, It looks like the get_members() function returns a dictionary that contains three lists: users, admins, and owners. The contents of these lists are strings, so it doesn't look like we can derive the full name of each user as-is. However, using list comprehensions, you can create a list of <User> objects whose username appears in the resulting dictionary from get_members(). From this new list, you can print each user's name using the fullName property. See the code below: # Authentication portalURL = "" username = "" password = "" org_gis = GIS(portalURL, username, password) # Get a list of groups that have "SA" in the title. sa_groups = org_gis.groups.search('title:SA') # Get a list of all users in the portal (max 1000 users). all_users = org_gis.users.search(max_users=1000) # Select the third group in the list g = sa_groups[2] # Get a dictionary of all users, admins, owners of the group. response = g.get_members() # Create a list of user objects whose usernames appear in the "users" list of the "response" dictionary. lst = [u for u in all_users if u.username in response["users"]] # Print the full name of each user in the list. for user in lst: print(user.fullName)

‎04-10-2020

Hi Natalie, I think you need to run calculate() on a feature layer, not the feature service. Try the code below: import arcgis import arcpy from arcgis.gis import GIS from arcgis import features from arcgis.features import FeatureLayer gis = GIS('https://arcgis.com', 'xxxxxx', 'xxxxxx') arcpy.env.overwriteOutput = True trap_count = gis.content.get("b6b9c68fa42b408a88c68aa9e18593d5") trap_count trap_count_lyr = trap_count.layers[0] # replace the 0 with the actual layer index trap_count_lyr .calculate(where="fid > 0", calc_expression=[{"field": "TotalArmyworms", "sqlExpression" : "Nu_W_YellowStripedArmyworm + Nu_BerthArmyworm" }]) -Josh

‎04-07-2020

Hello Louis, Take a look at the technical article linked below. It walks through how to list all dependencies using the ArcGIS API for Python's dependent_upon() and dependent_to() functions. Some tweaking will be required to get it to list specific layers, but hopefully this is a good place to start. How To: Find dependencies in Portal for ArcGIS using ArcGIS API for Python Best, Josh

‎04-01-2020

Jose, You cannot directly edit feature services in ArcMap. You need to first create a local copy of the data. About editing data from feature services—Help | ArcGIS for Desktop -Josh

‎04-01-2020

Hey Todd, I haven't confirmed this yet, but I believe you need to use the Oauth2 workflow. This requires creating an Application item in ArcGIS online and obtaining a client ID and client secret. More detail in the doc below: Working with different authentication schemes | ArcGIS for Developers -Josh

‎04-01-2020

Hey Jack, It sounds like you're not connected to an active Portal/ArcGIS Online organization. Try launching ArcGIS Administrator on your machine and check the Portal connections. Use ArcGIS Desktop with your portal—Portal for ArcGIS (10.5.x) | Documentation for ArcGIS Enterprise -Josh

‎03-30-2020

Hey Rex, I'd first use the requests module to get the json response, then load it as a dictionary. From there, you can use panda's from_dict function to create the DataFrame from the series. Something like this: import numpy as np import pandas as pd import requests import json r = requests.get('https://www.purpleair.com/json?show=39183|31221|31179|31185|2827|12785|35779|15947|46911|3095|35885|10286|33089|38627|34099|27405|21109|27825|34579|34109|27401|21111|27873|34747|26961|38253|34153|27807|27833|27863|22355|9930|2221|8244|8248|4427|2944|2514|15019|28651|47173|25361|36607|37575|4591|6612|36139|30739|5512|3157|34933|38835|48625|34951|2239|12016|34803|14687|26249|35693|36965|34847|34797|44553|39593|46293|48047|30169') dictionary = json.loads(r.text) results = dictionary["results"] df = pd.read_json(df.results.to_json(), orient='index') Now the data is a DataFrame, as opposed to a Series. Hope this helps! Best, Josh Edit: Modified the last line of code to reflect @joshua Bixby's suggestion. Thanks a lot!

‎02-18-2020

Hello, Can you use the first workaround listed in the technical article below? Basically, you can configure a list widget to show related records. How To: Show related records in Operations Dashboard for ArcGIS -Josh

‎01-24-2020

Jim, Try this: arcpy.CalculateField_management("Underground.dbf", "Conduit", '"2\" HDPE"', "PYTHON3")‍‍‍‍ You need a forward back slash (\) before the parentheses ("). Otherwise, the Python interpreter will think you are trying to close the string. Best, Josh

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by GeoJosh

Re: Python script stopped working. Need help

Re: Python script stopped working. Need help

Re: How to copy feature layer schema without downloading?

Re: Python Install

Re: I am having difficulty getting going offline.

Re: Percentage Change Calculation

Re: get list of group members but profile name not username

Re: calculate function in python jupyter notebook

Re: List all items on a portal consuming a specific web layer

Re: Edit ArcGIS Online feature layer in ArcMap

Re: How do I find/change my password (social vs. direct)

Re: arcgis not connected

Re: Convert Pandas Series to Dataframe or run query on series data?

Re: Pop-up display issue

Re: Using " instead of inches in a field

Re: Component Registration Issue in Distributed HA...

Re: Registering SQL Database Instance in a Cluster

Re: No data monitoring

Re: No data monitoring

Re: Is there a way to access Monitor 2024 KPI data...