POST
|
Hello folks, I???m working on a routing analysis and I think I???m going the right direction, just going the hard way. I???m also a novice with Network Analysis so please let me know if I???m missing something obvious. I???m trying to create routes for street sign inspections. There will be 6 routes (inspectors) that need to inspect about 55k signs over several days. They all start and stop at the same location each day. It looks like the Vehicle Routing Problem is the way to do this; each sign as an order. From what I have been able to gather multiday, routes cannot be created. Is this correct? Is there a more appropriate method to get the analysis I???m after? Thank you Alan
... View more
08-28-2013
05:59 AM
|
0
|
1
|
2509
|
POST
|
I'll go with the append. Don't! Going the Python route (reading the join tables(s) into a dictionary using a search cursor and then updating the main table via an update cursor is by far the fastest method. This is true in v10.0 and below, but is especially true in v10.1+ using ethe data access cursors. In addition to faster processing, this method is far more flexible in that allows for all sorts of error handeling and whatnot through conditional expressions. For example, say you want to get the fields "ADDRESS" and "CITY" into the main table (key field being "NAME"): #UNTESTED!
lutTbl = r"C:\temp\test.gdb\lookuptable"
mainTbl = "r"C:\temp\test.gdb\maintable"
lutDict= dict([(r[0], (r[1], r[2])) for r in arcpy.da.SearchCursor(lutTbl, ["NAME","ADDRESS","CITY")])
arcpy.AddField_managment(mainTbl, "ADDRESS", "TEXT", "", "", "75")
arcpy.AddField_managment(mainTbl, "CITY", "TEXT", "", "", "30")
updateRows = arcpy.da.UpdateCursor(mainTbl, ["NAME","ADDRESS","CITY"])
for updateRow in updateRows:
nameValue = updateRow[0]
if nameValue in lutDict:
updateRow[1] = lutDict[nameValue][1] #Address
updateRow[2] = lutDict[nameValue][2] #City
else:
print "Could not locate address/city info for " + str(nameValue)
updateRows.updateRow(updateRow)
del updateRow, updateRows I went ahead and went down this path as it will work better for me in the long run. I have to figure out how to "easily" include updates from additional tables. The only hiccup was something with the index. I'm novice with python so it may be something I should know. Instead of updateRow[1] = lutDict[nameValue][1] I had to use row[1] = PADataDict[PKValue][0] It was almost like once it got into the if statement the index 0 was the first value, not the key. Thank you for the help. Alan
... View more
08-12-2013
11:04 AM
|
1
|
0
|
2867
|
POST
|
Assuming the join fields are indexed on all of the tables, option 1 blew away cursors under the pre-da version cursors. Have not tested the da version cursors. However, even ArcObjects cursors perform slower than joins, so I doubt Option 2 would work faster even with a da cursor. Hitting tables with repeated queries is much slower than a join, which does just one correlation of the tables, because each new query has to reset the table read, as far as I know. Main reason to not use joins would be if there was a 1:M or M:M relationship to traverse. That's kind of what I figured; just needed some one else to back me up. 😄 I'll go with the append. Thank you Alan
... View more
08-09-2013
12:08 PM
|
0
|
0
|
2867
|
POST
|
Ok I have a feature class (260k records) and 3 tables. I need to get specific information (about 20 fields) from each into a new feature class. I have several different ways to do this and I???m curious if anyone has done any performance testing and knows which of my options would be ???best???. Option 1 I could create several joins and append the data into the new feature class, with some additional field calculations for cleanup. Option 2 Create a python script that would loop through each record, search cursor the other tables for data, then insert cursor into the new feature class. Thank you Alan
... View more
08-09-2013
11:09 AM
|
0
|
21
|
9093
|
POST
|
Can someone tell me what the Contour Index is supposed to represent? It is either 0 or 1 and how topo lines are symbolized in the template. Thanks, Patricia The index contour is there to help certain elevations stand out so it is easier to read. For example, I have 1ft contour feature class. Any contour with an elevation divisible by 5 I have as my index contour. As far as symbology, just make them a little bit different so they stand out; thicker lines, different dash lengths. Alan
... View more
07-26-2013
10:32 AM
|
0
|
0
|
460
|
POST
|
Are you in an edit session and you can edit both layers when you run the tools? Yes I have been in an edit session and verified I could edit when I attempted to run the tool. The tool still does fails when selecting the abandoned features on the enterprise database.
... View more
06-13-2013
09:00 AM
|
0
|
0
|
1630
|
POST
|
I do have a few additional fields in the wMain feature class that are not part of the local gov schema, but I don't think that is the issue because the tool works when it outputs to the file geodatabase. /shrug
... View more
06-13-2013
08:52 AM
|
0
|
0
|
1630
|
POST
|
Alan, Are both the water layers and the abandon layers editable? Yes, I can edit the feature classes.
... View more
06-13-2013
08:50 AM
|
0
|
0
|
1630
|
POST
|
Hello, I am having an issue with the Abandon Features script from the Water Utility Network Editing tools. I am trying to abandon a feature from the wMain feature class. If the the abandon features are set to go to the wAbandonedLine feature class on my enterprise geodatabase it will fail with the below message. If I set it to the wAbandonedLine in the file geodatabase that came with the tools it works fine. It is a 10.1 SP1 environment. The enterprise geodatabase is using the SQL geometry spatail type. Any ideas? Executing: AbandonFeatures 'Water Mains' "Water Abandoned Lines" "Water Abandoned Points" true LINETYPE POINTTYPE "Record Set"
Start Time: Fri May 10 09:05:12 2013
Running script AbandonFeatures...
Starting Abandon Selected Features Script
Processing Parameters
Abandoning Selected Features in GISData.GISADMIN.wMain
Water Mains is a Polyline with 1 selected
Traceback (most recent call last):
File "C:\IS_Support\UtilityNetworkEditingfor10.1\Application\Abandon Tools\AbandonSelectedFeatures.py", line 204, in <module>
newRow.setValue(fieldName, row.getValue(fieldName))
File "c:\program files (x86)\arcgis\desktop10.1\arcpy\arcpy\arcobjects\arcobjects.py", line 1040, in setValue
return convertArcObjectToPythonObject(self._arc_object.SetValue(*gp_fixargs(args)))
RuntimeError: ERROR 999999: Error executing function.
Field is not editable.
ERROR 999999: Error executing function.
Field is not editable.
Script Complete
Completed script AbandonFeatures...
Failed to execute (AbandonFeatures).
Failed at Fri May 10 09:05:13 2013 (Elapsed Time: 1.00 seconds)
... View more
05-10-2013
06:07 AM
|
0
|
16
|
4137
|
POST
|
Is this what you are looking for? http://www.arcgis.com/home/item.html?id=aedc78ca0be54a3b9bf4789aadb84f1d Yes it is thank you. For some reason I was unable to find it. Alan
... View more
04-08-2013
04:40 AM
|
0
|
0
|
349
|
POST
|
Hello, Is there an X-Ray for ArcMap 10.1? I have found X-Ray for ArcMap 10 and X-Ray for ArcCatalog 10.1; neither of which work to document mxd files for 10.1. Any suggestions? Thank you Alan
... View more
04-02-2013
05:13 AM
|
0
|
2
|
2275
|
POST
|
Hello folks, Does anyone have a good system for the way they organize services? I figured I would not put services at the root just to help keep things organized. I made a folder each for basemaps, cached data, and dynamic data. After make a few services and setting up a few apps, this organzation is starting to seem clunky. Should I just put them all in root? Anyone have alternatives to share? Thank you Alan
... View more
01-03-2013
10:03 AM
|
0
|
1
|
748
|
POST
|
Yeah it took me a bit to get it as well. The ArcSDE Command Line tools do not need to be installed unless you want to run stuff with a command line or need to do some major troubleshoot. Hi, I'm trying to wrap my head around this, as I setup my test server for our upgrade. I have set up my server with Windows Server 2008 R2 sp1 and SQL Server 2012 standard edition. I have installed ArcGIS desktop 10.1 + sp1 I ran through the ArcGIS for Server 10.1 sp1 installer but did not create a ArcGIS Server site. (essentially I needed the authorization file for the create enterprise geodatabase tool ) I then ran the tool > 'Create Enterprise Geodatabase' I loaded some data into the geodatabase, registered as versioned. When exploring the schema all the SDE and GDB tables are present. Am I missing something? Do I need to install ArcSDE 10.1 to get the multi user/versioning/history capabilties of ArcSDE, or as this discussion indicates this is now inherent in the desktop. I still am not 100% clear why I would need to install the ArcSDE application server or command line tools. If I am managing data via desktop (ArcMap & ArcCatalog) I do not need to install anything further If I am managing data via web editing tools I do need to install the ArcSDE application server. Thank you for any clarification you can provide. Fiona
... View more
12-21-2012
11:58 AM
|
0
|
0
|
675
|
POST
|
http://www.arcgis.com/home/item.html?id=5f799e6d23d94e25b5aaaf2a58e63fb1
... View more
11-05-2012
11:00 AM
|
0
|
0
|
818
|
POST
|
Hello, I�??m having an issue with Map Topology and using the Align Edge tool. Apparently it can only include features from the same data source and all feature classes have to have write access. I have a Land Use and Zoning feature class that needs to be aligned to a Parcel feature class. Since the user does not have write access to the Parcel feature class, it cannot be part of the map topology. Does anyone have any recommendations or suggestions for another method that is as easy as the Align Edge? We are using 10.1. Thank you Alan
... View more
11-05-2012
04:10 AM
|
0
|
2
|
425
|
Title | Kudos | Posted |
---|---|---|
1 | 08-12-2013 11:04 AM | |
1 | 05-10-2012 11:01 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|