Latest Contributions by ScottBlankenbeckler

‎04-03-2012

One of the first things you should look for is how your fields are named. Although Excel will allow you to put anything in the first row, ArcMap does not. If you have any special characters or spaces in your field headers ArcMap will not read it. Also look for spaces at the beginning and end of your field headers. Can you submit a screenshot of a csv that does not load. We may be able to point out where the error is occuring.

‎04-02-2012

Have you tried including Depot B in the Orders feature with the AssignmentRule set to (1) Preserve route and relative sequence? This will allow you to always make Depot B the last stop before returning to Depot A.

‎03-22-2012

I am getting a new error when I try to load a table from SDE can anyone interpret One or more layers failed to draw: SATDEL_ADM.Routes20120315_SHP: Underlying DBMS error [ORA-29902: error in executing ODCIIndexStart() routine ORA-00933: SQL command not properly ended ORA-06512: at "SYS.DBMS_SQL", line 1053 ORA-06512: at "SDE.SPX_UTIL", line 1428 ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 139 ::SELECT 1 SHAPE, ROUTES20120315_SHP.OBJECTID, ROUTES20120315_SHP.SHAPE.points,ROUTES20120315_SHP.SHAPE.numpts,ROUTES20120315_SHP.SHAPE.entity,ROUTES20120315_SHP.SHAPE.minx,ROUTES20120315_SHP.SHAPE.miny,ROUTES20120315_SHP.SHAPE.maxx,ROUTES20120315_SHP.SHAPE.maxy,ROUTES20120315_SHP.rowid FROM SATDEL_ADM.ROUTES20120315_SHP ROUTES20120315_SHP WHERE SDE.ST_EnvIntersects(ROUTES20120315_SHP.SHAPE,:1,:2,:3,:4) = 1 ] [SATDEL_ADM.Routes20120315_SHP] I am getting a similar error message when I try to delete from the same database. But I do not get this message from all themes in the database. Client - ArcGIS 10.0 SP4 Database - Oracle 11g SDE - 10.1 Layer(s) with problem created prior to applying SP4. Any layer created after applying SP4 does not generate this error (adding, accessing, or deleting).

‎03-22-2012

Is there a way to set the maximum speed a vehicle can travel in python between 2 points on a Vehicle Routing Problem?

‎03-14-2012

Good Afternoon, I am trying to make routes for a series of depots. My first pass thru the code works fine but the second pass always fails. Any help would be appreciated selected_locs = (["Location 1","X1234"],["Location 2","Y1234"], etc) for x in selected_locs: Cloc = x[0] drpkey = str(x[1]) outDirectionsFile = "E:/Output" + "/" + Cloc + "_Directions.xml" orders_out = "E:\\\Test.gdb\\Orders_"+ Czip routes_out = "E:\\\Test.gdb\\Routes_" + Czip arcpy.SelectLayerByAttribute_management(Geo_Orders_Layer, "NEW_SELECTION", "\"LOCATION\" = '"+ Cloc +"'") if ordrs <1: print Cloc + ": C R A S H ! ! ! ! ! ! No Deliveries Geocoded" else: print Cloc + " deliveries: " + str(ordrs) arcpy.AddLocations_na(VRP_Setup, "Orders", Geo_Orders_Layer, "Name # #;Description Full_Add #;ServiceTime SRVTIME 0.34;TimeWindowStart1 # #;TimeWindowEnd1 # #;TimeWindowStart2 # #;TimeWindowEnd2 # #;MaxViolationTime1 # #;MaxViolationTime2 # #;DeliveryQuantities # #;PickupQuantities # #;Revenue # #;SpecialtyNames CRID #;AssignmentRule # 3;RouteName # #;Sequence # #;CurbApproach # 0", "5000 Meters", "", "'SDC Edge Source' SHAPE", "MATCH_TO_CLOSEST", "CLEAR", "NO_SNAP", "5 Meters", "INCLUDE", "'SDC Edge Source' #") Expression = "\"Name\" = '"+drpkey+"'" arcpy.SelectLayerByAttribute_management(Depots_All_Layer, "NEW_SELECTION", Expression) if pos < 1: writeLog( "\t"+drpkey + " not found. (C R A S H ! ! !)") elif pos>1: writeLog( "\t Too many Depot's found. (C R A S H ! ! !)") else: writeLog( "\t Depot found and loaded.") arcpy.AddLocations_na(VRP_Setup, "Depots", Depots_All_Layer, "Name Name #;Description Description #;TimeWindowStart1 TimeWindowStart1 #;TimeWindowEnd1 TimeWindowEnd1 #;TimeWindowStart2 TimeWindowStart2 #;TimeWindowEnd2 TimeWindowEnd2 #;CurbApproach CurbApproach 0", "5000 Meters", "", "'SDC Edge Source' SHAPE", "MATCH_TO_CLOSEST", "CLEAR", "NO_SNAP", "5 Meters", "INCLUDE", "'SDC Edge Source' #") arcpy.AddLocations_na(VRP_Setup, "Routes", Route_Template, "Name Name #;Description Description #;StartDepotName StartDepotName #;EndDepotName EndDepotName #;StartDepotServiceTime StartDepotServiceTime #;EndDepotServiceTime EndDepotServiceTime #;EarliestStartTime EarliestStartTime '8:00:00 AM';LatestStartTime LatestStartTime '10:00:00 AM';ArriveDepartDelay ArriveDepartDelay #;Capacities Capacities #;FixedCost FixedCost #;CostPerUnitTime CostPerUnitTime 1;CostPerUnitDistance CostPerUnitDistance #;OvertimeStartTime OvertimeStartTime #;CostPerUnitOvertime CostPerUnitOvertime #;MaxOrderCount MaxOrderCount 30;MaxTotalTime MaxTotalTime #;MaxTotalTravelTime MaxTotalTravelTime #;MaxTotalDistance MaxTotalDistance #;SpecialtyNames SpecialtyNames #;AssignmentRule AssignmentRule 1", "5000 Meters", "", "'SDC Edge Source' SHAPE", "MATCH_TO_CLOSEST", "CLEAR", "NO_SNAP", "5 Meters", "INCLUDE", "'SDC Edge Source' #") arcpy.CalculateField_management(Route_Template, "StartDepotName", "'"+drpkey+"'", "PYTHON", "") arcpy.CalculateField_management(Route_Template, "EndDepotName", "'"+drpkey+"'", "PYTHON", "") arcpy.AddLocations_na(VRP_Setup, "Breaks", Breaks_Template, "RouteName RouteName #;Precedence Precedence 1;ServiceTime ServiceTime 60;TimeWindowStart TimeWindowStart #;TimeWindowEnd TimeWindowEnd #;MaxViolationTime MaxViolationTime #;MaxTravelTimeBetweenBreaks MaxTravelTimeBetweenBreaks #;IsPaid IsPaid 1;Sequence # #;MaxCumulWorkTime # #", "5000 Meters", "", "'SDC Edge Source' SHAPE", "MATCH_TO_CLOSEST", "CLEAR", "NO_SNAP", "5 Meters", "INCLUDE", "'SDC Edge Source' #") arcpy.AddLocations_na(VRP_Setup, "Specialties", Specialties_Template, "Name Name #;Description Description #", "5000 Meters", "", "'SDC Edge Source' SHAPE", "MATCH_TO_CLOSEST", "CLEAR", "NO_SNAP", "5 Meters", "INCLUDE", "'SDC Edge Source' #") arcpy.Directions_na(VRP_Setup, "XML", outDirectionsFile, "Miles", "REPORT_TIME", "") arcpy.CopyFeatures_management(Orders, orders_out, "", "0", "0", "0") arcpy.CopyFeatures_management(Routes, routes_out, "", "0", "0", "0") Everything works fine first time thru but when it starts the second pass everything up to the Directions command works but the solve/directions fails with an error Traceback (most recent call last): File "test.py", line 191, in <module> arcpy.Directions_na(VRP_Setup, "XML", outDirectionsFile, "Miles", "REPORT_TIME", "") File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\na.py", line 440, in Directions raise e arcgisscripting.ExecuteError: ERROR 030092: VRP Solver failed due to invalid input. Invalid input in the NA classes. Failed to execute (Directions).

‎02-10-2012

Is it better to store my network dataset within SDE, FGDB, or leave it as a shapefile? I know that there is additional overhead when storing address locators in the FGDB and SDE but is this a similar problem with the network dataset used in network analysis?

‎02-08-2012

Simple question - When using network analyst and I get a solve failed message is there anywhere I can go to see more on this message? When running regular geoproccessing tools I can view the results and get more info but I have not found a "results" window for the network analyst tools.

‎12-01-2011

So you need something like... arcpy.ImportToolbox("full path to toolbox/toolboxname.tbx") arcpy.gp.toolbox = "full path to toolbox/toolboxname.tbx"; arcpy.gp.toolboxname(any parameters)

‎12-01-2011

That fixed it. Much thanks. New problem. Any way to set it up so that it creates a split zip file of 5MB max size. i.e. the original file is just over 10.7MB using the code above but my email server will only allow a 10MB file. If I can split the file into a split zip of 5MB parts I can send it as two emails.

‎11-30-2011

Jason, I am using your code to zip up a single file in a directory. However the zip file and the original file(*.txt) are the same size (i.e. 0% compression) what would cause this and what do I need to look for to correct it.

‎11-30-2011

Alex, When I try to use your code I get the following error Traceback (most recent call last): File "email.py", line 26, in <module> import smtplib File "c:\Python26\ArcGIS10.0\lib\smtplib.py", line 46, in <module> import email.utils File "C:\GISData\Scripts\email.py", line 31, in <module> smtpserver = smtplib.SMTP("smtp.gmail.com",587) #the technical stuff AttributeError: 'module' object has no attribute 'SMTP' Any clue on what is happening?

‎10-28-2011

I was wondering if it is possible to connect to an already published address locator service with python. If so how would I accomplish this? I would need a map point returned for use further down in my workflow.

‎10-27-2011

Figured it out. Just needed to set the output coord system for the geocode to a projected coord system and it still gave me x/y in lat/long but allowed to do near table in meters.

‎10-27-2011

The problem is thus... I need to get the X/Y of the initial point but it needs to be in DD. This value is passed back to a map service. But I also need to calculate the distance from the above point to surrounding polygons but need to give that data in meters or feet. Since all of this will be done for a web application time is critical. The fewer geoprocesses I need to employ the better.

‎10-27-2011

I am trying to use the generate near table to get distances from a point to all surrounding polygons, but have a couple questions. Input Feature and Near Features (Coord system) - GCS_WGS_1984 1. How do I get the output NEAR_DIST to display meters 2. If 1 is not possible without re-projecting data how do I convert NEAR_DIST to meters 3. What is the unit of measure for the output? Changing the output coordinate system does not change the values of NEAR_DIST. example: NEAR_DIST 0.071014 (? units)

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by ScottBlankenbeckler

Re: Problem using .csv files to geocode addresses in ArcGIS 9.

Re: One of my Depots MUST BE the last one.

Error

Max Speed

VRP - Looping

Network Dataset storage

Solve Failed?

Re: Run custom toolbox from Python

Re: Unzip in Python Script

Re: Unzip in Python Script

Re: Sending e-mail following completion of python script

Address locator service

Re: Generate Near Table

Re: Generate Near Table

Generate Near Table

Save Expression in Query Layer Window