POST
|
Thanks for the ideas. I will give it a try and see what happens. I am running a SAS script that calls Python to extract and manipulate spatial data from our corporate database. The script extracts and renames a copy of the required data without issue, converts FEATURE VERTICES to POINTS without issue and only when it tries to ADD XY COORDINATES the issue occurs. The ADD XY COORDINATE process does not die right away. Sometimes it gets to 85% complete and other times to over 90% before it dies. When it dies, it shuts everything down except the warning pop up. I will check the background processing option and see what happens. Thanks again. Greg
... View more
10-19-2015
06:14 AM
|
0
|
0
|
649
|
POST
|
Recently upgraded to 10.3 and now geoprocessing that ran fine in 10.0 fails and dumps this error. EnumerateLoadedModules64 failed with error 0 Nothing changed but the version. Did I miss a setting in the 10.3 setup? It was installed remotely by our service desk. Online research shows it might be related to available resources, Oracle version and/or database load. desktop has i7 processor 3.2ghxcpu 16 gb of ram 15.9 gb avail mem 31.9 gb virtual mem 15.9 gb page file database is in Oracle 11g Any ideas?
... View more
10-07-2015
09:04 AM
|
0
|
2
|
3649
|
POST
|
Hi Greg, You can use a wildcard in the ListFields function, and then pass the returned list to the DeleteField function. Ex: fc = r"C:\temp\test.gdb\project"
list = []
PR = "some text"
for field in arcpy.ListFields(fc, "FID_GE41_REG_SBPD_MOB_"+PR+"_WOR_*"):
list.append(field.name)
arcpy.DeleteField_management(fc, list) This worked. Thank you very much.
... View more
08-27-2013
07:12 AM
|
0
|
0
|
937
|
POST
|
Hi Greg, You can use a wildcard in the ListFields function, and then pass the returned list to the DeleteField function. Ex: fc = r"C:\temp\test.gdb\project"
list = []
PR = "some text"
for field in arcpy.ListFields(fc, "FID_GE41_REG_SBPD_MOB_"+PR+"_WOR_*"):
list.append(field.name)
arcpy.DeleteField_management(fc, list) Hello JSkinn3, I will give it a try and let you know what happens. Thanks Greg
... View more
08-27-2013
07:06 AM
|
0
|
0
|
937
|
POST
|
You don't mention what error you are getting back. I assume you can drop the field if you hard code the field name? Have you tried printing out "FID_GE41_REG_SBPD_MOB_"+PR+"_WOR_9" , or comaparing it to the field name as returned by ListFields, to make sure it resolves as a match for your field name? Is PR (9) a string or int? Hello mdenil, Yes, I can drop the field if it is hard coded. The issue stems from the automatic renaming of the field after an Intersect. The long field name gets FID_ then is concatenated and given a number. The number is changing depending on when the code is run and how many times the code is run. As a Python noob, I banged away at trying various things for wildcards ("%", +%+, etc) and got numerous error messages. "%" gives; not all arguments converted during string formatting This lead me to think it was a INT versus string issue. The +PR+ system argument has been converted to a string. Is the 9 an INT when it is inside the " "? Thanks. Greg
... View more
08-27-2013
07:05 AM
|
0
|
0
|
937
|
POST
|
Hello, I am trying to put a wildcard inside this delete field. I am using PythonWin 2.6 and hitting Feature Class data in SDE. I already use a system argument inside the field name and had to convert it to a string for it to work. Is that the problem with trying to use a wildcard for a number inside a string? arcpy.DeleteField_management(PROJ4_ADMIN_DELETE_AFTER_TEST, "FID_GE41_REG_SBPD_MOB_"+PR+"_WOR_9") I would like to use a wildcard for the number 9 in the field name. Thanks in advance for any input you may have. Greg
... View more
08-27-2013
05:11 AM
|
0
|
5
|
2409
|
POST
|
Hello Forum users, I am running a SAS script that uses a Python script to work on an ArcGIS 10 SDE Feature Class. The Python script does everything to the Feature Class it is supposed to do but when it finishes does not leave a record of its success or failure in the SAS log tab. The SAS log only sees Python opening and then once it is finished closing. What I need to see is a log showing the success or failure of the Python portion of the code. Is there a way of getting Python to dump a log file out to specific location while it is running in SAS? Thanks for any input you may have. Greg Ps. I think it???s time to take a Python course!
... View more
10-29-2012
10:38 AM
|
0
|
2
|
1720
|
POST
|
Thank you Wayne and Jake. You both deserve the green check mark for providing the answer. Thanks again. Greg Parent
... View more
10-12-2012
09:50 AM
|
0
|
0
|
1376
|
POST
|
Hello ArcGIS Forum Users, I have been able to use Python to copy a polyline dataset and add four fields (FROM_X, TO_X, FROM_Y, TO_Y) but am having trouble with populating the fields with the appropriate information. I would like to use Python to populate them in the following manner: FROM_X = X Coordinate of Line Start TO_X = X Coordinate of Line End FROM_Y = Y Coordinate of Line Start TO_Y = Y Coordinate of Line End I know it can be done manually by opening the datasets attribute table, right clicking on a field, selecting Calculate Geometry and then the appropriate Property but I would like to have a Python script be able to do this so it can be embedded in a SAS script. The COPY and ADD FIELD Python script works in SAS so I am hoping the CALCULATE FIELD will as well. I tried using the Data Management - Fields - Calculate Field and its Python option for FROM_X using: arcpy.CalculateField_management(dataset, fieldname, !FROM_X!.firstpoint.x,"PYTHON_9.3","") The script runs without errors but does nothing to my dataset. I suspect I am missing a step but do not know what to do next. Any input you may provide is greatly appreciated. Thank you. Greg Parent
... View more
10-12-2012
05:53 AM
|
0
|
3
|
3837
|
POST
|
Hello ESRI Help Forum users, I am trying to generate minimum, maximum and average offset statistics between two datasets. The first dataset is made up of polygons that represent Townships, Ranges and Sections (TRS - based on the Dominion Land Survey), the second dataset is road arcs. There is an offset between the two datasets that varies across the full extent. The road arcs are GPS compliant, the TRS are a mathematical construct. Any ideas how to proceed? Here's a picture to show the offset. [ATTACH=CONFIG]15921[/ATTACH] Thanks in advance for any input you may provide. G Parent
... View more
07-10-2012
07:16 AM
|
0
|
0
|
1544
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|