Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About JakeSkinner
JakeSkinner
Esri Esteemed Contributor
since
07-04-2014
Friday
5838
Posts created
291
Kudos given
836
Solutions
2940
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by JakeSkinner
|
DOC
|
@RickeyFight , Change the below lines: tokenURL = 'https://www.arcgis.com/sharing/rest/generateToken'
params = {'f': 'pjson', 'username': username, 'password': password, 'referer': 'http://www.arcgis.com'} to the following: tokenURL = 'https://<portalURL>/<webadaptor>/sharing/rest/generateToken/'
params = {'f': 'pjson', 'username': username, 'password': password, 'referer': '<portalURL>'} Replace the <portalURL>/<webadaptor> with the URL to your portal (i.e. https://gis.esri.com/portal). And, the referer to the portal URL (i.e. https://gis.esri.com).
... View more
05-15-2024
08:06 AM
|
0
|
0
|
12066
|
|
DOC
|
@RickeyFight can you describe what your doing when you say you locked down the service? Are you only sharing the service to your Organization?
... View more
05-14-2024
04:16 PM
|
0
|
0
|
12104
|
|
POST
|
Hi @KåreMølgaardRasmussen, The below sample will export the attachments to a directory: import os, arcpy
# Variables
tbl = r"C:\Temp\Python\Test.gdb\Graffiti__ATTACH" # Path to attachment table
fldBLOB = 'DATA' # Field name of Blob data type field in attachment table
fldAttName = 'ATT_NAME' # Field name in attachment table that contains attachment name
outFolder = r"C:\Temp\Python\Attachments" # Output folder to export attachments to
with arcpy.da.SearchCursor(tbl,[fldBLOB,fldAttName]) as cursor:
for row in cursor:
binaryRep = row[0]
fileName = row[1]
# save to disk
open(outFolder + os.sep + fileName, 'wb').write(binaryRep.tobytes())
print('Finished')
... View more
05-14-2024
11:07 AM
|
0
|
0
|
4616
|
|
POST
|
Hi @RobertoRossi, 1. Set your Map's coordinate's system to a Projected Coordinate system 2. Change the Map's units at the bottom to the measurement of your choice The Edit Vertices should now reflect this. Ex:
... View more
05-14-2024
11:04 AM
|
2
|
0
|
1505
|
|
POST
|
Another option I use a lot is updating the feature service using a dictionary and an update cursor, rather than a join. Below is an example: # Create dictionary
print("Create dictionary")
tblDict = {}
with arcpy.da.SearchCursor(tbl, ["name","band_3_progress", "sent_to", "released_by", "pub_date"]) as cursor:
for row in cursor:
tblDict.setdefault(row[0], [])
tblDict[row[0]].append(row[1])
tblDict[row[0]].append(row[2])
tblDict[row[0]].append(row[3])
tblDict[row[0]].append(row[4])
del cursor
# Update feature service
print("Updating feature service")
with arcpy.da.UpdateCursor(fsURL, ["name","band_3_progress", "sent_to", "released_by", "pub_date"]) as cursor:
for row in cursor:
row[1] = tblDict[row[0]][0]
row[2] = tblDict[row[0]][1]
row[3] = tblDict[row[0]][2]
row[4] = tblDict[row[0]][3]
cursor.updateRow(row)
del cursor
... View more
05-13-2024
06:04 AM
|
0
|
0
|
2318
|
|
POST
|
I would highly recommend the more frequently used services be switched to dedicated. I typically only recommend a few services be set to shared instance type.
... View more
05-13-2024
05:23 AM
|
4
|
5
|
9923
|
|
POST
|
Hi @Yogesh_Chavan, are you services configured with Shared or Dedicated instances? I've seen this error before when all services are configured with Shared. Try changing the services to Dedicated. https://enterprise.arcgis.com/en/server/latest/administer/windows/configure-service-instance-settings.htm#ESRI_SECTION1_C6A867B5D3C543668798F75139028A99
... View more
05-13-2024
04:17 AM
|
3
|
1
|
9936
|
|
POST
|
How many fields are you updating in the feature service?
... View more
05-13-2024
04:08 AM
|
0
|
2
|
2331
|
|
POST
|
Hi @GeoKate, Have you tried using truncate instead of delete rows? This is faster and may get you past your error.
... View more
05-10-2024
12:39 PM
|
0
|
0
|
2361
|
|
POST
|
@EdX1 , take a look at the following document. It contains a script that will compress your geodatabase and output a DeltaCounts.csv file showing the before and after counts of the A & D tables.
... View more
04-26-2024
10:19 AM
|
0
|
0
|
4513
|
|
DOC
|
To maintain optimal performance for a traditionally versioned geodatabase, it's a best practice to compress your geodatabase on a regular basis. To achieve a full compress to state 0, it's necessary to remove all locks from the geodatabase. Locks can be created from users accessing the geodatabase in desktop applications, such as ArcGIS Pro, and from ArcGIS Server services that are referencing data from the geodatabase. This script will stop ArcGIS Server services that are currently running, disconnect all users from the geodatabase, block further connections to the geodatabase, reconcile/post all versions, and compress the geodatabase. After the geodatabase is compressed, the script will rebuild indexes and recalculate stats on versioned feature classes, and then finally restart the previous running services. Additionally, the script will output a CSV file showing the before and after counts of the A & D tables, also known as the Delta tables. This will allow you to easily see if the versioned feature classes have been compressed. Also, the script will report the before and after state id of the geodatabase. Some optional parameters within the script include sending e-mail notifications. If the script executes successfully, an e-mail will be sent attaching the CSV file of the delta table counts, and a message of the before and after state id. If an error occurs, an e-mail will be sent including a log file reporting the error and the line within the script that caused the error. A quick note, all geodatabase replicas should be synced before this script is executed Video of workflow:
... View more
04-26-2024
10:15 AM
|
10
|
8
|
6589
|
|
POST
|
Hi @Sven_Harpering, You can use the report property: https://developers.arcgis.com/python/guide/administering-your-gis/#:~:text=Pandas%20DataFrame%20table-,pro_license.report,-Entitlement
... View more
04-26-2024
08:18 AM
|
1
|
1
|
1977
|
|
DOC
|
@SallyBickel @Chase_RSO what IDE are you using to execute the script? Try running the IDE as an Administrator (i.e. right-click on IDE > Run As Administrator). Do you still receive the same error?
... View more
04-24-2024
05:30 AM
|
0
|
0
|
16917
|
|
POST
|
@RaenaBallantyne_DeMaris that may be the case. You can add a try/except to bypass this error. Ex: # Iterate through fruit list
for fruit in fruitList:
with arcpy.da.SearchCursor(farmLocations, ["LocCode"], f"Fruits LIKE '%{fruit}%'") as cursor:
for row in cursor:
# Create CSV file for each fruit
csvOutput = fr'{csvDirectory}\{fruit}.csv'
output_file = open(csvOutput, 'w')
header = 'LocCode, ProjName\n'
output_file.write(header)
try:
for project in projectsDict[row[0]]:
output = f'{row[0]}, {project}\n'
output_file.write(output)
except KeyError:
pass
del cursor
... View more
04-23-2024
09:20 AM
|
1
|
0
|
3145
|
|
POST
|
@BlakeTerhune I believe the documentation states that it's not required when using it within a with statement, but I've found there can still be locks when I do not explicitly remove the cursor using del cursor.
... View more
04-23-2024
07:49 AM
|
0
|
0
|
3171
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 4 weeks ago | |
| 4 | 05-07-2020 05:14 PM | |
| 1 | 03-25-2026 04:16 AM | |
| 1 | 03-16-2026 01:00 PM | |
| 1 | 12-22-2025 10:39 AM |
Activity Feed
- Posted Re: Update ArcGIS Server Services after SQL Server Instance and/or Network File Share Change on ArcGIS Enterprise Documents. Friday
- Kudoed Re: Survey123 to Survey123 data append for JamesTedrick. Thursday
- Posted Re: Update ArcGIS Server Services after SQL Server Instance and/or Network File Share Change on ArcGIS Enterprise Documents. Thursday
- Posted Re: Update ArcGIS Server Services after SQL Server Instance and/or Network File Share Change on ArcGIS Enterprise Documents. Wednesday
- Posted Re: Update ArcGIS Server Services after SQL Server Instance and/or Network File Share Change on ArcGIS Enterprise Documents. Wednesday
- Posted Re: Report ArcGIS Enterprise/ArcGIS Online Item Dependencies on ArcGIS Enterprise Documents. Monday
- Got a Kudo for Report ArcGIS Enterprise/ArcGIS Online Item Dependencies. a week ago
- Got a Kudo for Re: Remove empty tilecache 11.3 before upgrade to 12.1. 4 weeks ago
- Posted Re: Remove empty tilecache 11.3 before upgrade to 12.1 on ArcGIS Enterprise Questions. 4 weeks ago
- Posted Re: Remove empty tilecache 11.3 before upgrade to 12.1 on ArcGIS Enterprise Questions. 4 weeks ago
- Got a Kudo for Create ArcGIS Server Statistics Report. 4 weeks ago
- Posted Re: Migrate Content for ArcGIS Enterprise/ArcGIS Online on ArcGIS Enterprise Documents. 07-01-2026 07:38 AM
- Got a Kudo for Re: what happens when you accidentally close a map or layout window in your project?. 06-27-2026 06:33 PM
- Posted Re: Migrate Content for ArcGIS Enterprise/ArcGIS Online on ArcGIS Enterprise Documents. 06-25-2026 01:08 PM
- Posted Re: Migrate Content for ArcGIS Enterprise/ArcGIS Online on ArcGIS Enterprise Documents. 06-24-2026 03:58 AM
- Posted Re: Migrate Built-In Named User accounts to Enterprise Named User accounts (Active Directory/SAML) in ArcGIS Enterprise/ArcGIS Online on ArcGIS Enterprise Documents. 06-07-2026 07:12 AM
- Got a Kudo for Send E-mail Notifications with ArcGIS Notebooks - Online. 06-05-2026 05:39 AM
- Kudoed Three easy steps to copy an ArcGIS Dashboard for BrittneyWhite1. 06-05-2026 04:39 AM
- Posted Re: Best way to migrate hosted feature services from 10.9.1 to 11.5? on ArcGIS Enterprise Questions. 05-28-2026 05:33 AM
- Posted Re: Migrate Content for ArcGIS Enterprise/ArcGIS Online on ArcGIS Enterprise Documents. 05-26-2026 04:41 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
Friday
|