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
5824
Posts created
288
Kudos given
836
Solutions
2934
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
|
POST
|
Are you trying to Sum the two lists together based on the index of each list? Ex: listA = [1,2,3,4,3,2,1] listB = [7,8,9,5,4,3,1] index[0] = 7 + 1 = 8 index[1] = 8 + 2 = 10 index[2] = 9 + 3 = 12 If you are, you can use the following code to do this: import os
listA = [1,2,3,4,3,2,1]
listB = [7,8,9,5,4,3,1]
listC = []
x = 0
while x < len(listA):
listC.append(listB + listA )
x += 1
print listC
... View more
07-20-2011
07:41 AM
|
0
|
0
|
2982
|
|
POST
|
Thanks, Ruth! The 'replaceDataSource' method was exactly what I needed. I was able to get this working with the following code:
import arcpy
from arcpy import env
from arcpy import mapping
env.workspace = workspace = arcpy.GetParameterAsText(0)
env.overwriteOutput = True
mxdList = arcpy.ListFiles("*.mxd")
for mxd in mxdList:
mxd = workspace + "\\" + mxd
print mxd + " is being processed"
mxd = mapping.MapDocument(mxd)
for df in mapping.ListDataFrames(mxd, "*"):
for lyr in mapping.ListLayers(mxd, "*", df):
lyr.replaceDataSource(arcpy.GetParameterAsText(1), "SDE_WORKSPACE", "")
print "Successfully updated data sources"
mxd.save()
del mxd
... View more
07-19-2011
11:17 AM
|
2
|
4
|
2207
|
|
POST
|
You can use the 'Create File Geodatabase' or 'Create Personal Geodatabase' tool to create a 9.3 geodatabase and then copy the data from your 10 geodatabase to the 9.3 geodatabase using ArcGIS 10.
... View more
07-18-2011
11:59 AM
|
0
|
0
|
428
|
|
POST
|
It looks you are missing a ',' between OBJECTID and SDE for the -C option. Here is an example on registering a table: SQL> CREATE TABLE building (OBJECTID INTEGER, shape SDE.ST_GEOMETRY);
SQL> INSERT INTO building VALUES (1, SDE.ST_Polygon ('polygon ((0 0, 0 10, 10 10, 10 0, 0 0))', 2));
SQL> INSERT INTO building VALUES (2, SDE.ST_Polygon ('polygon ((20 0, 30 20, 40 0, 20 0))', 2));
SQL> INSERT INTO building VALUES (3, SDE.ST_Polygon ('polygon ((20 30, 25 35, 30 30, 20 30))', 2));
SQL> create index bf_indx on building(shape) indextype is SDE.ST_spatial_index parameters = ('SDE.ST_grids=1,0,0 SDE.ST_srid=2');
$ sdelayer -o regiSDE.STer -l building,shape -e nac+ -C OBJECTID,SDE -P HIGH -t SDE.ST_GEOMETRY -i 5151 -u vector -p vector
... View more
07-18-2011
11:53 AM
|
0
|
0
|
1077
|
|
POST
|
Try removing the 417th file and then re-execute the script to see if it works. The file may be corrupted.
... View more
07-18-2011
11:30 AM
|
0
|
0
|
1205
|
|
POST
|
Is it possible to change the data source of an MXD to another SDE geodatabase? I've tried this, but have only been able to get this to work when switching versions within the same SDE geodatabase. Ex: import arcpy
from arcpy import env
env.workspace = workspace = r"C:\temp\python"
env.overwriteOutput = True
mxdList = arcpy.ListFiles("*.mxd")
for mxd in mxdList:
mxd2 = workspace + "\\" + mxd
mapdoc = arcpy.mapping.MapDocument(mxd2)
mapdoc.findAndReplaceWorkspacePaths(r"C:\TEMP\Python\VECTOR_Default.sde", r"C:\TEMP\Python\VECTOR_QAQC.sde")
mapdoc.save()
del mapdoc The above code works as I am switching from one version (SDE.Default) to another version (SDE.QAQC) within the same VECTOR geodatabase. When I try to switch to another SDE geodatabase that contains the same feature class (same owner and feature class name, just different database), it does not work. Ex: import arcpy
from arcpy import env
env.workspace = workspace = r"C:\temp\python"
env.overwriteOutput = True
mxdList = arcpy.ListFiles("*.mxd")
for mxd in mxdList:
mxd2 = workspace + "\\" + mxd
mapdoc = arcpy.mapping.MapDocument(mxd2)
mapdoc.findAndReplaceWorkspacePaths(r"C:\TEMP\Python\VECTOR_Default.sde", r"C:\TEMP\Python\RASTER_Default.sde")
mapdoc.save()
del mapdoc Thanks for any suggestions!
... View more
07-18-2011
11:14 AM
|
1
|
6
|
5331
|
|
POST
|
Below is an example on how you can do this using the Field Calculator. Be sure to check 'Python' at the top and 'Show Codeblock'. Under 'Pre-logic Script Code' enter the following: def update():
import arcpy
list = []
rows = arcpy.SearchCursor(r"C:\data\Parcels")
for row in rows:
list.append(row.AREA)
S = sum(list)
del row, rows
rows = arcpy.UpdateCursor(r"C:\data\Parcels")
for row in rows:
row.AREA2 = S
val = row.AREA2
del row, rows
return val Then, under the second block enter: update()
... View more
07-08-2011
05:35 AM
|
0
|
0
|
1140
|
|
POST
|
Below is an example on how to do this. The code adds all the shapefiles first two characters to a list, then removes the duplicates. It will then merge the related shapefiles together to one shapefile. lstFCs = arcpy.ListFeatureClasses("*")
list1 = []
# Append first two characters of each shapefile to list
for fc in lstFCs:
list1.append(fc[0:2])
# Remove duplicates from list
list1 = dict.fromkeys(list1)
list1 = list1.keys()
# Merge feature classes
for n in list1:
m = str(n) + "*"
lstFCs = arcpy.ListFeatureClasses(m)
arcpy.Merge_management(lstFCs, n + "_merge")
... View more
07-07-2011
04:08 AM
|
0
|
0
|
1205
|
|
POST
|
In order to update the symbology for layers within MXD using another MXD as the source, you will need to use the 'arcpy.mapping.ListLayers' function rather the the 'arcpy.mapping.Layer'. Here is an example below on how you can accomplish this:
import arcpy
mxd = arcpy.mapping.MapDocument(r"C:\temp\Final_Project.mxd")
df = arcpy.mapping.ListDataFrames(mxd, "*")[0]
lstLayers = arcpy.mapping.ListLayers(mxd, "Rivers*", df)
mxd2 = arcpy.mapping.MapDocument(r"C:\temp\Source.mxd")
df2 = arcpy.mapping.ListDataFrames(mxd2, "*")[0]
for layer in lstLayers:
updateLayer = layer
sourceLayer = arcpy.mapping.ListLayers(mxd2, "River", df2)[0]
arcpy.mapping.UpdateLayer(df, updateLayer, sourceLayer, True)
mxd.save()
print "Updated symbology successfully"
del mxd You can copy/paste the syntax above to update the Roads and Building layers as well.
... View more
06-27-2011
08:19 AM
|
0
|
0
|
871
|
|
POST
|
If you have an ArcEditor license for ArcGIS 10 you can use the 'arcpy.FlipLine_edit' function to reverse the direction of your polyline data.
... View more
06-27-2011
06:52 AM
|
0
|
0
|
970
|
|
POST
|
I would recommend using the arcpy.AddFieldDelimiters function to select the field your using. That way you can be sure you have the expression correct. Ex: fc = "Roads"
Segment_ID = arcpy.AddFieldDelimiters(fc, "Segment_ID")
Expression = "Segment_ID = 'C1'" Give that a go and see if you receive the correct results.
... View more
06-23-2011
09:40 AM
|
0
|
0
|
863
|
|
POST
|
The append should work inside or outside an edit session. If you perform the append outside of an edit session, make sure the 'Connection Details' within the connection properties of the geodatabase are set to the version you wish to update.
... View more
06-23-2011
03:48 AM
|
0
|
0
|
699
|
|
POST
|
You can use the arcpy.Append_management command to do this.
... View more
06-23-2011
03:25 AM
|
0
|
0
|
1984
|
|
POST
|
Can you upload your model as well? This will help a lot. Thanks!
... View more
06-17-2011
12:06 PM
|
0
|
0
|
4691
|
|
POST
|
I'm a little confused on your local variables: # Local variables:
Test = Expression
Test_UnsplitLine = Test
ROUTE_FINAL = Test_UnsplitLine
ROUTE_FINAL__2_ = ROUTE_FINAL
Route_Real_OUTPUT_gdb = "G:\\40\\Scratch\\Real_OUTPUT.gdb" It appears you have variables set to other variables. Could you explain what you would like the code to do and I can figure out the correct syntax? Thanks!
... View more
06-15-2011
12:27 PM
|
0
|
0
|
4691
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-25-2026 04:16 AM | |
| 1 | 03-16-2026 01:00 PM | |
| 1 | 12-22-2025 10:39 AM | |
| 1 | 01-20-2026 04:04 AM | |
| 1 | 12-29-2025 06:27 AM |
Activity Feed
- Posted Re: Indexes Mismatch issues on ArcGIS Enterprise Portal Questions. Monday
- Got a Kudo for Migrate Content for ArcGIS Enterprise/ArcGIS Online. 03-31-2026 05:49 AM
- Posted Re: Migrate Content for ArcGIS Enterprise/ArcGIS Online on ArcGIS Enterprise Documents. 03-27-2026 12:23 PM
- Posted Re: Migrate Content for ArcGIS Enterprise/ArcGIS Online on ArcGIS Enterprise Documents. 03-27-2026 05:39 AM
- Posted Re: Licenses for the parallel prod on ArcGIS Enterprise Questions. 03-26-2026 03:54 AM
- Got a Kudo for Send E-mail Notifications with ArcGIS Notebooks - Online. 03-25-2026 12:52 PM
- Got a Kudo for Re: Licenses for the parallel prod. 03-25-2026 05:53 AM
- Posted Re: Licenses for the parallel prod on ArcGIS Enterprise Questions. 03-25-2026 04:16 AM
- Kudoed Re: How can GIS help us understand energy system vulnerabilities better? for George_Thompson. 03-25-2026 04:11 AM
- Posted Re: Powershell DSC multiple ArcGIS Server sites on ArcGIS Enterprise Questions. 03-24-2026 08:19 AM
- Posted Re: WebGISDR Failed to back up the Relational Data Store to Azure Storage due to timeout on High Availability and Disaster Recovery Questions. 03-24-2026 06:50 AM
- Posted Re: Powershell DSC multiple ArcGIS Server sites on ArcGIS Enterprise Questions. 03-24-2026 06:43 AM
- Posted Re: Automate ArcGIS Enterprise Backup on ArcGIS Enterprise Documents. 03-20-2026 03:56 AM
- Got a Kudo for Compress Geodatabase. 03-17-2026 05:29 PM
- Got a Kudo for Re: Change Portal Admin URL in Portal Administrator Directory. 03-17-2026 07:18 AM
- Posted Re: Change Portal Admin URL in Portal Administrator Directory on ArcGIS Enterprise Portal Questions. 03-16-2026 01:00 PM
- Kudoed Re: Restriction or Hiding "Organization" for RyanUthoff. 03-16-2026 12:50 PM
- Posted Re: Migrate Content for ArcGIS Enterprise/ArcGIS Online on ArcGIS Enterprise Documents. 03-16-2026 05:52 AM
- Posted Re: Migrate Content for ArcGIS Enterprise/ArcGIS Online on ArcGIS Enterprise Documents. 03-13-2026 04:16 AM
- Posted Re: Migrate Content for ArcGIS Enterprise/ArcGIS Online on ArcGIS Enterprise Documents. 03-09-2026 08:47 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
Friday
|