Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About JaredPilbeam2
JaredPilbeam2
MVP Alum
since
10-17-2017
Friday
719
Posts created
481
Kudos given
30
Solutions
123
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(2 Idea Submissions)Latest Contributions by JaredPilbeam2
|
POST
|
This question is based off of another one I just had. I can't seem to update a feature dataset in a sql server enterprise geodatabase. I have sysadmin user role access to the database. One thing I've tried is copying the path of the connection file from an ArcPro project and using that in the script. This particular script here works perfect if I use it on a file geodatabase inside a folder. Basically, I'm not sure how to connect to the enterprise geodatabase. """
update the feature classes in the feature dataset gisedit.DBO.dFIRM_2019_Effective
from the shapefiles in this directory:
\\gisfile\GISsources\Federal\FEMA\DFIRM\EffectiveProducts\SHP\17197C_WillCo_FIRMdb
"""
import arcpy
from arcpy import env
import os
#shapefile variable
shp = r'\\gisfile\GISsources\Federal\FEMA\DFIRM\
EffectiveProducts\SHP\17197C_WillCo_FIRMdb'
#sde connection file variable
sde = r'C:\Users\jpilbeam\AppData\Local\Temp\ArcGISProTemp11396\
d532de7f-5c8c-43c9-94bc-3cf9407b9505\gissql.sde\dFIRM_2019_Effective'
env.workspace = shp
#populate the fcList
fcList = arcpy.ListFeatureClasses()
env.workspace = sde
env.overwriteOutput = True
#iterate list of shapefiles and copy to sde feature dataset
for shapefile in fcList:
in_shapefile = os.path.join(shp, shapefile)
out_featureclass = os.path.splitext(shapefile)[0]
print('Copying %s to %s' %(in_shapefile, out_featureclass))
arcpy.CopyFeatures_management(in_shapefile, out_featureclass)
##
print("done") Error: Traceback (most recent call last):
File "\\gisfile\GISstaff\Jared\Python Scripts\ArcGISPro\dFIRM.py", line 30, in <module>
arcpy.CopyFeatures_management(in_shapefile, out_featureclass)
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 2948, in CopyFeatures
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 2945, in CopyFeatures
retval = convertArcObjectToPythonObject(gp.CopyFeatures_management(*gp_fixargs((in_features, out_feature_class, config_keyword, spatial_grid_1, spatial_grid_2, spatial_grid_3), True)))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 506, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000733: Output Feature Class: Same as input Input Features
Failed to execute (CopyFeatures).
EDIT: I forgot to mention that the shapefiles and the features in the dataset have the same names. I need to update the dataset every month with these shapefiles.
... View more
08-06-2019
12:18 PM
|
0
|
4
|
7410
|
|
POST
|
Lance Cole Right, those paths are set right in my actual code. Here are the files I'm testing on. Ultimately, I'm updating a feature dataset in the sql server database using a sde connection file. Current Code: """
update the feature classes in the feature dataset gisedit.DBO.dFIRM_2019_Effective
from the shapefiles in this directory:
\\gisfile\GISsources\Federal\FEMA\DFIRM\EffectiveProducts\SHP\17197C_WillCo_FIRMdb
"""
import arcpy
from arcpy import env
import os
shp = r'\\gisfile\GISstaff\Jared\Test\shapefiles'
gdb = r'\gisfile\GISstaff\Jared\Test\TestFGDB.gdb\dFIRM_2019_Effective'
env.workspace = shp
fcList = arcpy.ListFeatureClasses()
env.workspace = gdb
env.overwriteOutput = True
for shapefile in fcList:
print(shapefile)
in_shapefile = os.path.join(shp, shapefile)
print(in_shapefile)
out_featureclass = os.path.splitext(shapefile)[0]
print(out_featureclass, "\n")
print('Copying %s to %s' %(in_shapefile, out_featureclass))
arcpy.CopyFeatures_management(in_shapefile, out_featureclass)
##
print("done")
... View more
08-02-2019
08:17 AM
|
0
|
1
|
6371
|
|
POST
|
Lance, The CopyFeatures function failed: ERROR 000733: Output Feature Class: Same as input Input Features
Failed to execute (CopyFeatures). There were no errors up to that point. The print statement on your line 17 printed this: Copying pathto\Test\shapefiles\S_BASE_INDEX.shp to S_BASE_INDEX Apparently, it doesn't like that the shapefiles and the feature classes have the same names.
... View more
08-02-2019
07:11 AM
|
0
|
3
|
6371
|
|
POST
|
Joe, I attempted to put together what I thought you were saying more or less. So far, I haven't got it to work. I put the error below the code. I thought I'd try deleting the feature classes in the dataset first, then copy the shapefiles into that dataset. import arcpy
from arcpy import env
import os
#directory of shapefiles
shps = r'pathto\Test\shapefiles'
#directory of FCs in dataset
dataset = r'pathto\TestFGDB.gdb\dFIRM_2019_Effective'
#create lists for shapefiles and FCs
shpList = arcpy.ListFeatureClasses()
fcList = arcpy.ListFeatureClasses()
#iterate FC list, delete FCs, copy shapefiles to dataset
for fc in fcList:
arcpy.Delete_management(dataset, "FEATURECLASS") #(in_data, data_type)
arcpy.CopyFeatures_management(shpList, dataset) #(in_features, out_feature_class)
print("done") line 15, in <module>
for fc in fcList:
TypeError: 'NoneType' object is not iterable
... View more
08-01-2019
11:18 AM
|
0
|
5
|
6371
|
|
POST
|
Is there a way I can copy shapefiles in a directory to an Enterprise Geodatabase Feature Dataset in a stand-alone script? As a monthly update, the shapefiles would replace/update feature classes with the same names in a feature dataset. I've attempted to copy a shapefile using an SDE connection file with arcpy.CopyFeatures. The script ran but nothing happened. import arcpy
from arcpy import env
import os
ws = env.workspace = r'path\to\34512.shp'
out_ws = r'path\to\gissql(2).sde'
fcList = arcpy.ListFeatureClasses(ws)
for shapefile in fcList:
out_featureclass = os.path.join(out_ws, os.path.splitext(shapefile)[0])
arcpy.CopyFeatures_management(shapefile, out_featureclass)
... View more
07-31-2019
02:26 PM
|
0
|
10
|
7741
|
|
POST
|
That did it, thanks! for root, dirnames, filenames in os.walk(im): #iterate directory
for fname in filenames:
if fname.endswith(('.JPG', '.jpg')):
with open(os.path.join(root, fname), 'rb') as image: #file path and name
exif = exifread.process_file(image)
dt = str(exif['EXIF DateTimeOriginal']) #get 'Date Taken' from JPG
ds = time.strptime(dt, '%Y:%m:%d %H:%M:%S')
nt = time.strftime("%Y-%m-%d",ds)
newname = fname[:-4].replace(' ','_').replace('(','').replace(')','').replace('.','') + '_' + nt + ".jpg"
#print(newname)
image.close()
os.rename(os.path.join(root,fname), os.path.join(root,newname))
... View more
07-24-2019
06:57 AM
|
0
|
0
|
3582
|
|
POST
|
I tried this, but the repeats were still skipped: for root, dirnames, filenames in os.walk(im): #iterate directory
for fname in filenames:
if fname.endswith('.JPG'):
with open(os.path.join(root, fname), 'rb') as image: #file path and name
exif = exifread.process_file(image)
dt = str(exif['EXIF DateTimeOriginal']) #get 'Date Taken' from JPG
ds = time.strptime(dt, '%Y:%m:%d %H:%M:%S')
nt = time.strftime("%Y-%m-%d",ds)
newname = fname[:-4].replace(' ','_').replace('(','').replace(')','').replace('.','') + '_' + nt + ".jpg"
print(newname) prints: 7400010_2018-04-25.jpg
7400015_2018-04-25.jpg
7400016_2018-04-25.jpg
7400017_2018-04-25.jpg
...
... View more
07-23-2019
01:58 PM
|
0
|
2
|
3582
|
|
POST
|
Randy, that works nice, but is it possible to put the whole directory into a list?
... View more
07-23-2019
01:53 PM
|
0
|
0
|
3582
|
|
POST
|
Joshua, that appended JPG to the end of the date and skipped the repeats:
... View more
07-23-2019
01:22 PM
|
0
|
0
|
3582
|
|
POST
|
Hello, I have a lot of JPEGs in a Windows directory. In most cases these JPEGs do not have similar filenames. On the other hand, there are some repeats: Using exifread, I'm appending the 'date taken' to the end of the seven digit number of the filenames. This script gets me close, but it's not exactly doing what I want. It skips the files with similar names (e.g. 7400010 (2), 7400010b). Also, after running the script I'm having trouble avoiding the '.' of the file extension. Ideally, I'd like every filename to have this structure: 7400010_2018-04-25. And as far as the files with similar names goes, how do I preserve the (2) and the b? """
Loops through folder and adds the 'Date Taken' from JPG
"""
import arcpy, sys
import exifread
from exifread import exif
import os
##import time
from datetime import datetime
im = r"\\path\to\pics2\CH74"
for root, dirnames, filenames in os.walk(im): #iterate directory
for fname in filenames:
if fname.endswith('.JPG'):
with open(os.path.join(root, fname), 'rb') as image: #file path and name
exif = exifread.process_file(image)
dt = str(exif['EXIF DateTimeOriginal']) #get 'Date Taken' from JPG
ds = time.strptime(dt, '%Y:%m:%d %H:%M:%S')
nt = time.strftime("%Y-%m-%d",ds)
newname = fname[0:8] + "_" + nt + ".jpg"
image.close()
os.rename(os.path.join(root,fname), os.path.join(root,newname)) Here's how the filenames look after running this script:
... View more
07-23-2019
12:23 PM
|
0
|
8
|
3737
|
|
POST
|
Weng, It is Collector for ArcGIS, actually. Version 18.0.3. I should've mentioned that.
... View more
06-20-2019
07:07 AM
|
0
|
0
|
1329
|
|
POST
|
I can't find a way to change the green symbols in the map? There doesn't seem to be a way to do it in the CSS. On the other hand, I was able to change the number to light blue in the panel at least. Version: 2.9.0 JS API: 3.27 Here's the app: https://webapp.willcountyillinois.com/gisweb/2019_July4th/index.html
... View more
06-18-2019
12:35 PM
|
0
|
1
|
1348
|
|
POST
|
Hello, how do I lose what appears to be a subtitle ('1035243.583' in the popup box)? The number itself is from the attribute field called "Easting". I only want to see 'Post Number: 2610010'. In the web map Easting doesn't appear in the popup:
... View more
06-13-2019
12:12 PM
|
0
|
2
|
1417
|
|
POST
|
Thanks to GeoNet, here's the work around I eventually came up with seeing that using Python to update a raster field isn't supported. In the end I didn't use a raster field at all. I had a text field with a unique ID that matched the file name of JPGs in a directory. I used a script that updated another text field named 'Photo' with the full name of the JPG. Then I used arcpy.EnableAttachments_management(), which created a related table that can store rasters. Finally, I used arcpy.AddAttachments_management(), which populated the related table. Working with attachments was also helpful. '''the purpose of this script is to update the 'Photo' field in the fc
with the file path of the same name.
'''
import arcpy, os
ws = r'path\to\Projects\DOT_SignInventory\pics'
jpgs = {} # empty dictionary
for dirName, subdirList, fileList in os.walk(ws):
for fname in fileList:
jpgs[fname[:-4]] = os.path.join(dirName,fname)
for jpg in jpgs:
print(jpg)
fc = r'path\to\Projects\DOT_SignInventory\Data2.gdb\WCDOT_Signs'
fields = ['OID@', 'Post_Number', 'Photo']
with arcpy.da.UpdateCursor(fc, fields) as cursor:
for row in cursor:
try:
row[2] = jpgs[row[1]]
cursor.updateRow(row)
except KeyError:
print("No photo for: {}".format(row[1]))
del cursor
... View more
04-24-2019
08:06 AM
|
0
|
0
|
3660
|
|
POST
|
Hello, The intention of this script is to update the 'Photo' field of a feature class table with the full path of a JPG based on the 'Post_Number' field. The problem is only the first seven digits of the JPG matches the unique ID in the 'Post_Number' field. The rest of the file name is a date. I've placed a string index number variable in a for loop that gets the JPG by the first seven digits. A dictionary is then built off the existing paths without the date. The cursor is then supposed to update the 'Photo' field. The script runs without error but the Photo field isn't updated?? I'm thinking the 'var' variable is in the wrong place. '''Python 3.6.6. The purpose of this script is to update the 'Photo' field in the fc
with the full path of a JPG.
'''
import arcpy, os
ws = r'path\to\Projects\DOT_SignInventory\pics'
jpgs = {} # empty dictionary
for dirName, subdirList, fileList in os.walk(ws):
for fname in fileList:
var = fname[:7] # get first seven digits of file name
jpgs[var[:-4]] = os.path.join(dirName,var)
fc = r'path\to\Projects\DOT_SignInventory\Data2.gdb\WCDOT_Signs'
fields = ['OID@', 'Post_Number', 'Photo'] # fields of FC
with arcpy.da.UpdateCursor(fc, fields) as cursor:
for row in cursor:
try:
row[2] = jpgs[row[1]]
cursor.updateRow(row)
except KeyError:
print("No photo for: {}".format(row[1]))
del cursor
Here's how the JPG looks in the directory: Here's how I want the Photo field to be updated. Right now it's empty. Both fields are text fields.
... View more
04-23-2019
01:32 PM
|
0
|
1
|
1352
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 06-25-2026 12:25 PM | |
| 1 | 05-04-2026 08:45 AM | |
| 1 | 04-20-2026 01:20 PM | |
| 1 | 07-24-2025 01:27 PM | |
| 1 | 11-13-2025 08:22 AM |
Activity Feed
- Kudoed trigger embed code widget through button widget for tendtreesTC. Friday
- Posted Select Data Widget Repetitive Data Actions on ArcGIS Experience Builder Questions. Friday
- Posted Disperse Markers Sort Symbology on ArcGIS Pro Questions. a week ago
- Kudoed Dynamic Solution for Overlapping Points for TanGnar. 2 weeks ago
- Posted Use Select Widget with List widget and Selections Disappear on ArcGIS Experience Builder Questions. 3 weeks ago
- Kudoed List Widget loses selection when Map is clicked for vijaybadugu. 3 weeks ago
- Kudoed Dynamically showing a PDF file in Embed widget for ChristopherKreuter. 3 weeks ago
- Kudoed Re: Dynamically showing a PDF file in Embed widget for apgis16. 3 weeks ago
- Kudoed Custom print layout for widget that uses map series to print multi-page report and honors element selection? for AllisonMartin. 06-26-2026 02:30 PM
- Kudoed Print a map series within Experience Builder? for HayleyL. 06-26-2026 02:27 PM
- Got a Kudo for Re: Update table so column one stores the value of matching value from column two. 06-25-2026 12:26 PM
- Posted Re: Update table so column one stores the value of matching value from column two on Python Questions. 06-25-2026 12:25 PM
- Posted Re: Update table so column one stores the value of matching value from column two on Python Questions. 06-25-2026 12:21 PM
- Posted Update table so column one stores the value of matching value from column two on Python Questions. 06-25-2026 12:08 PM
- Kudoed Embedded PDFs not showing for Ed_. 06-23-2026 11:28 AM
- Kudoed Open a PDF when Clicking on Polyline in Web Map for MHO_Harbors. 06-22-2026 11:11 AM
- Kudoed Zone Lookup for Brian_McLeer. 06-22-2026 07:47 AM
- Kudoed CSV Geocoder Widget for Brian_McLeer. 06-18-2026 06:25 AM
- Kudoed Re: Copying a common widget to be customized for abureaux. 05-18-2026 02:19 PM
- Kudoed Exporting from the widget table directly to PDF for doronwen. 05-14-2026 09:24 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
Friday
|