def __init__(self, args):
os.chdir(os.path.split(args[0])[0])
self.step = 0
self.ExecPath = os.getcwd()
self.Logfilename = os.path.join(self.ExecPath, "tempLog.log")
self.log(" " + file("rev.txt").read())
#~ self.SysInfo()
# Check out necessary licenses
if arcpy.CheckExtension("spatial") == "Available":
arcpy.CheckOutExtension("Spatial")
else:
self.log(" No Spatial Analyst license available, bailing")
raise Exception("No Spatial Analyst license available")
arcpy.env.overwriteOutput = True
# Load required toolboxes...
if os.path.exists(
"C:\Program Files (x86)\ArcGIS\Desktop10.4\ArcToolbox\Toolboxes"
):
basepath = "C:\Program Files (x86)\ArcGIS\Desktop10.4\ArcToolbox\Toolboxes"
elif os.path.exists(
"C:\Program Files\ArcGIS\Desktop10.4\ArcToolbox\Toolboxes"):
basepath = "C:\Program Files\ArcGIS\Desktop10.4\ArcToolbox\Toolboxes"
else:
raise Exception, "Could not locate the spatial analyst toolbox, stopping"
arcpy.AddToolbox(os.path.join(basepath, "Spatial Analyst Tools.tbx"))
arcpy.AddToolbox(os.path.join(basepath, "Conversion Tools.tbx"))
arcpy.AddToolbox(os.path.join(basepath, "Data Management Tools.tbx"))
self.Basin = ""
self.units = {}
self.models = {}
lastmodelpath = os.path.join(os.getcwd(), "LastModel.wip")
self.log(" Looking for " + lastmodelpath)
if os.path.exists(lastmodelpath):
self.log(" Found LastModel.wip")
l = open(lastmodelpath, "r")
self.Workspace = l.readline().split(',')[0]
l.close()
self.log(" Working in %s" % self.Workspace)
else:
self.log(" LastModel.wip not found")
self.Workspace = self.ExecPath
if string.count(args[0], "TopoHydro") == 0:
self.SetEnvVar()
else:
self.log(" Not calling SetEnv for TopoHydro")
def UpdateStreets(arcpy):
try:
# Create the Geoprocessor object
#gp = arcgisscripting.create()
# Load required toolboxes...
#gp.AddToolbox("E:/Program Files/ArcGIS/ArcToolbox/Toolboxes/Data Management Tools.tbx")
arcpy.AddToolbox("C:/Program Files (x86)/ArcGIS/Desktop10.0/ArcToolbox/Toolboxes/Data Management Tools.tbx")
# Local variables...
Append_Pub_1_Streets_Success = "Database Connections\\xxx@xxx-1_pub.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets"
Delete_Pub_1_Streets_Success = "Database Connections\\xxx@xxx-1_pub.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets"
Append_Pub_1_xxxStreets_Success = "Database Connections\\xxx@xxx-1_pub.sde\\SDE.DBO.xxxStreets"
Delete_Pub_1_xxxStreets_Success = "Database Connections\\xxx@xxx-1_pub.sde\\SDE.DBO.xxxStreets"
Pub1_Streets = "Database Connections\\xxx@xxx-1_pub.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets"
Prod_2_Streets = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets"
Pub_1_xxxStreets = "Database Connections\\xxx@xxx-1_pub.sde\\SDE.DBO.xxxStreets"
Prod_2_xxxStreets = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets"
# Process: Delete Features...
arcpy.DeleteFeatures_management(Pub1_Streets)
# Process: Append...
arcpy.Append_management("'Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets'", Pub1_Streets, "NO_TEST", "IDNUM 'IDNUM' true true false 4 Long 0 10 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,IDNUM,-1,-1;PREFIX 'PREFIX' true true false 2 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,PREFIX,-1,-1;STREETNAME 'STREETNAME' true true false 30 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,STREETNAME,-1,-1;STREETTYPE 'STREETTYPE' true true false 4 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,STREETTYPE,-1,-1;SUFFIX 'SUFFIX' true true false 2 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,SUFFIX,-1,-1;CFCC 'CFCC' true true false 3 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,CFCC,-1,-1;CITY_L 'CITY_L' true true false 3 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,CITY_L,-1,-1;CITY_R 'CITY_R' true true false 3 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,CITY_R,-1,-1;FROMLEFT 'FROMLEFT' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,FROMLEFT,-1,-1;TOLEFT 'TOLEFT' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,TOLEFT,-1,-1;FROMRIGHT 'FROMRIGHT' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,FROMRIGHT,-1,-1;TORIGHT 'TORIGHT' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,TORIGHT,-1,-1;ZIP_L 'ZIP_L' true true false 5 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,ZIP_L,-1,-1;ZIP_R 'ZIP_R' true true false 5 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,ZIP_R,-1,-1;POLICE_L 'POLICE_L' true true false 15 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,POLICE_L,-1,-1;POLICE_R 'POLICE_R' true true false 15 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,POLICE_R,-1,-1;FIRE_L 'FIRE_L' true true false 15 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,FIRE_L,-1,-1;FIRE_R 'FIRE_R' true true false 15 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,FIRE_R,-1,-1;EMS_L 'EMS_L' true true false 15 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,EMS_L,-1,-1;EMS_R 'EMS_R' true true false 15 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,EMS_R,-1,-1;P_BEAT_L 'P_BEAT_L' true true false 16 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,P_BEAT_L,-1,-1;P_BEAT_R 'P_BEAT_R' true true false 16 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,P_BEAT_R,-1,-1;MAP_PAGE1 'MAP_PAGE1' true true false 10 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,MAP_PAGE1,-1,-1;MAP_PAGE2 'MAP_PAGE2' true true false 10 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,MAP_PAGE2,-1,-1;MAP_PAGE3 'MAP_PAGE3' true true false 10 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,MAP_PAGE3,-1,-1;X1 'X1' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,X1,-1,-1;Y1 'Y1' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,Y1,-1,-1;X2 'X2' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,X2,-1,-1;Y2 'Y2' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,Y2,-1,-1;TYPE 'TYPE' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,TYPE,-1,-1;LABELTYPE 'LABELTYPE' true true false 4 Long 0 10 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,LABELTYPE,-1,-1;LESN 'LESN' true true false 5 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,LESN,-1,-1;RESN 'RESN' true true false 5 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,RESN,-1,-1;NAME 'NAME' true true false 30 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,NAME,-1,-1;STREET 'STREET' true true false 72 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,STREET,-1,-1;LEGALNAME 'LEGALNAME' true true false 36 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,LEGALNAME,-1,-1;SURF_TYPE 'SURF_TYPE' true true false 20 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,SURF_TYPE,-1,-1;SPEED 'SPEED' true true false 4 Long 0 10 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,SPEED,-1,-1;LCITY 'LCITY' true true false 32 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,LCITY,-1,-1;RCITY 'RCITY' true true false 32 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,RCITY,-1,-1;ONEWAY 'ONEWAY' true true false 5 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,ONEWAY,-1,-1;NAMED 'NAMED' true true false 36 Date 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,NAMED,-1,-1;ADDRESSED 'ADDRESSED' true true false 36 Date 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,ADDRESSED,-1,-1;NAMELOW 'NAMELOW' true true false 36 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,NAMELOW,-1,-1;SOURCETHM 'SOURCETHM' true true false 16 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,SOURCETHM,-1,-1;LENGTH 'LENGTH' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,LENGTH,-1,-1;COUNTY 'COUNTY' true true false 16 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,COUNTY,-1,-1;REVERSED 'REVERSED' true true false 16 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,REVERSED,-1,-1;BLM 'BLM' true true false 12 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,BLM,-1,-1;USFS 'USFS' true true false 12 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,USFS,-1,-1;MP_DIST 'MP_DIST' true true false 8 Double 4 12 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,MP_DIST,-1,-1;MP_BEG 'MP_BEG' true true false 8 Double 4 12 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,MP_BEG,-1,-1;MP_END 'MP_END' true true false 8 Double 4 12 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,MP_END,-1,-1;ROADNUMB 'ROADNUMB' true true false 2 Short 0 5 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,ROADNUMB,-1,-1;FLIPME 'FLIPME' true true false 2 Short 0 5 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,FLIPME,-1,-1;SHAPE_LENG 'SHAPE_LENG' true true false 8 Double 11 18 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,SHAPE_LENG,-1,-1;CROSS2 'CROSS2' true true false 254 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,CROSS2,-1,-1;CROSS1 'CROSS1' true true false 254 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,CROSS1,-1,-1;New_Type 'New_Type' true true false 8 Double 8 38 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,New_Type,-1,-1;Shape.len 'Shape.len' false false true 0 Double 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets,Shape.len,-1,-1", "")
# Process: Delete Features (2)...
arcpy.DeleteFeatures_management(Pub_1_xxxStreets)
# Process: Append (2)...
arcpy.Append_management("'Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets'", Pub_1_xxxStreets, "NO_TEST", "OBJECTID 'OBJECTID' true true false 8 Double 0 10 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,OBJECTID,-1,-1;IDNUM 'IDNUM' true true false 8 Double 0 10 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,IDNUM,-1,-1;PREFIX 'PREFIX' true true false 2 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,PREFIX,-1,-1;STREETNAME 'STREETNAME' true true false 30 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,STREETNAME,-1,-1;STREETTYPE 'STREETTYPE' true true false 4 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,STREETTYPE,-1,-1;SUFFIX 'SUFFIX' true true false 2 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,SUFFIX,-1,-1;CFCC 'CFCC' true true false 3 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,CFCC,-1,-1;CITY_L 'CITY_L' true true false 3 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,CITY_L,-1,-1;CITY_R 'CITY_R' true true false 3 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,CITY_R,-1,-1;FROMLEFT 'FROMLEFT' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,FROMLEFT,-1,-1;TOLEFT 'TOLEFT' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,TOLEFT,-1,-1;FROMRIGHT 'FROMRIGHT' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,FROMRIGHT,-1,-1;TORIGHT 'TORIGHT' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,TORIGHT,-1,-1;ZIP_L 'ZIP_L' true true false 5 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,ZIP_L,-1,-1;ZIP_R 'ZIP_R' true true false 5 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,ZIP_R,-1,-1;POLICE_L 'POLICE_L' true true false 15 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,POLICE_L,-1,-1;POLICE_R 'POLICE_R' true true false 15 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,POLICE_R,-1,-1;FIRE_L 'FIRE_L' true true false 15 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,FIRE_L,-1,-1;FIRE_R 'FIRE_R' true true false 15 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,FIRE_R,-1,-1;EMS_L 'EMS_L' true true false 15 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,EMS_L,-1,-1;EMS_R 'EMS_R' true true false 15 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,EMS_R,-1,-1;P_BEAT_L 'P_BEAT_L' true true false 16 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,P_BEAT_L,-1,-1;P_BEAT_R 'P_BEAT_R' true true false 16 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,P_BEAT_R,-1,-1;MAP_PAGE1 'MAP_PAGE1' true true false 10 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,MAP_PAGE1,-1,-1;MAP_PAGE2 'MAP_PAGE2' true true false 10 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,MAP_PAGE2,-1,-1;MAP_PAGE3 'MAP_PAGE3' true true false 10 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,MAP_PAGE3,-1,-1;X1 'X1' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,X1,-1,-1;Y1 'Y1' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,Y1,-1,-1;X2 'X2' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,X2,-1,-1;Y2 'Y2' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,Y2,-1,-1;TYPE 'TYPE' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,TYPE,-1,-1;LABELTYPE 'LABELTYPE' true true false 8 Double 0 10 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,LABELTYPE,-1,-1;LESN 'LESN' true true false 5 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,LESN,-1,-1;RESN 'RESN' true true false 5 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,RESN,-1,-1;NAME 'NAME' true true false 30 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,NAME,-1,-1;STREET 'STREET' true true false 72 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,STREET,-1,-1;LEGALNAME 'LEGALNAME' true true false 36 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,LEGALNAME,-1,-1;SURF_TYPE 'SURF_TYPE' true true false 20 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,SURF_TYPE,-1,-1;SPEED 'SPEED' true true false 8 Double 0 10 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,SPEED,-1,-1;LCITY 'LCITY' true true false 32 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,LCITY,-1,-1;RCITY 'RCITY' true true false 32 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,RCITY,-1,-1;ONEWAY 'ONEWAY' true true false 5 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,ONEWAY,-1,-1;NAMED 'NAMED' true true false 36 Date 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,NAMED,-1,-1;ADDRESSED 'ADDRESSED' true true false 36 Date 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,ADDRESSED,-1,-1;NAMELOW 'NAMELOW' true true false 36 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,NAMELOW,-1,-1;SOURCETHM 'SOURCETHM' true true false 16 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,SOURCETHM,-1,-1;LENGTH 'LENGTH' true true false 8 Double 0 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,LENGTH,-1,-1;COUNTY 'COUNTY' true true false 16 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,COUNTY,-1,-1;REVERSED 'REVERSED' true true false 16 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,REVERSED,-1,-1;BLM 'BLM' true true false 12 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,BLM,-1,-1;USFS 'USFS' true true false 12 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,USFS,-1,-1;MP_DIST 'MP_DIST' true true false 8 Double 4 14 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,MP_DIST,-1,-1;MP_BEG 'MP_BEG' true true false 8 Double 4 14 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,MP_BEG,-1,-1;MP_END 'MP_END' true true false 8 Double 4 14 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,MP_END,-1,-1;ROADNUMB 'ROADNUMB' true true false 4 Long 0 10 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,ROADNUMB,-1,-1;FLIPME 'FLIPME' true true false 4 Long 0 10 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,FLIPME,-1,-1;SHAPE_LENG 'SHAPE_LENG' true true false 8 Double 11 19 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,SHAPE_LENG,-1,-1;CROSS1 'CROSS1' true true false 254 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,CROSS1,-1,-1;CROSS2 'CROSS2' true true false 254 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,CROSS2,-1,-1;Shape.len 'Shape.len' false false true 0 Double 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets,Shape.len,-1,-1", "")
except:
print 'Errors occurred in UpdateStreetsPub1_def'
raise
def onClick(self):
arcpy.AddToolbox(r'c:\Pfafstetter\AddIn\Install\Otto_Pfafstetter.tbx')
toolboxName = 'Otto_Pfafstetter'
toolName = 'Pfafstetter'
toolboxPath = r'c:\Pfafstetter\AddIn\Install\Otto_Pfafstetter.tbx'
pythonaddins.GPToolDialog(toolboxPath, toolName)
pass
def test_point_data(self):
arcpy.AddToolbox(self.toolbox_path)
# Create an output location in scratch that uses a common prefix and random suffix
# This helps prevent conflicts if things don't get cleaned up.
temp_output = path.join(
"%scratchGDB%",
"test_point_data_{}".format(random.randint(0, 9999)))
# Execute the tool
arcpy.TestableBufferTool_TT(self.point_path, temp_output)
# Build the location of the answer
answer_output = path.join(self.database_path, "test_point_data_answer")
# Compare the temp_output to the known answer.
result = arcpy.FeatureCompare_management(
in_base_features=answer_output,
in_test_features=temp_output,
sort_field=["Value"],
continue_compare=True)
# If it returns false, something has gone wrong, so fail the test.
if result.getOutput(1) != 'true':
print(result.getMessages())
self.assertEqual(result.getOutput(1), 'true')
# Clean up after ourselves
arcpy.Delete_management(temp_output)
def setUp(self):
arcpy.env.overwriteOutput = True
self.parent_directory = path.dirname(path.expandvars(__file__))
self.data_directory = path.join(self.parent_directory, "data")
arcpy.AddToolbox(
path.join(path.dirname(self.parent_directory),
"SimpleToolbox.pyt"))
def UpdateStreets(arcpy):
try:
# Create the Geoprocessor object
#gp = arcgisscripting.create()
# Load required toolboxes...
#gp.AddToolbox("E:/Program Files/ArcGIS/ArcToolbox/Toolboxes/Data Management Tools.tbx")
#gp.AddToolbox("C:/Documents and Settings/djrenz/Application Data/ESRI/ArcToolbox/My Toolboxes/_David_general.tbx")
arcpy.AddToolbox("C:/Program Files (x86)/ArcGIS/Desktop10.0/ArcToolbox/Toolboxes/Data Management Tools.tbx")
# Local variables...
Streets_Layer = "dispatchstreets_Copy_Layer"
Input_Streets = "\\\\172.16.217.1\\ecsostreets\\shp\\Streets.shp"
Workspace = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.DBTools"
Med_Streets_Unique_Temp = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.Cartegraph\\SDE.DBO.xxx_Streets_Unique_temp"
xxx_Streets_Unique_Delete_Results = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.Cartegraph\\SDE.DBO.xxx_Streets_Unique"
Append_Results = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.Cartegraph\\SDE.DBO.xxx_Streets_Unique"
Existing_xxx_Streets_Unique_ = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.Cartegraph\\SDE.DBO.xxx_Streets_Unique"
Append_Prod_2_xxx_Streets_Success = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets"
xxx_Streets_Delete_Results = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets"
xxx_Streets = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.xxxStreets"
Medstreets_Layer = "dispatchstreets_Copy_Layer"
Delete_Streets_Result_ = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets"
Streets_Append_Success = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets"
Delete_xxx_streets_unique_temp = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.Cartegraph\\SDE.DBO.xxx_Streets_Unique_temp"
Prod_1_xxx_Streets_Unique_temp = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.Cartegraph\\SDE.DBO.xxx_Streets_Unique_temp"
Copied_Input_Streets = "F:\\Processes\\UpdateStreets\\Temp\\dispatchstreets_Copy.shp"
Prod_1_Streets = "Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.ReferenceData_County\\SDE.DBO.Streets"
Delete_Success = "F:\\Processes\\UpdateStreets\\Temp\\dispatchstreets_Copy.shp"
#try:
# gp.Delete_management(Copied_Input_Streets, "ShapeFile")
#except:
# print "Nothing to delete here : " + Copied_Input_Streets
time.sleep(10)
print "Beginning"
try:
arcpy.Delete_management(Copied_Input_Streets, "")
except:
print "Nothing to delete here 2"
# Process: Copy...
try:
arcpy.Copy_management(Input_Streets, Copied_Input_Streets, "ShapeFile")
except:
arcpy.Delete_management(Copied_Input_Streets, "")
arcpy.Copy_management(Input_Streets, Copied_Input_Streets, "ShapeFile")
time.sleep(5)
# Process: Make Feature Layer...
arcpy.MakeFeatureLayer_management(Copied_Input_Streets, Streets_Layer, "", Workspace, "IDNUM IDNUM VISIBLE NONE;PREFIX PREFIX VISIBLE NONE;STREETNAME STREETNAME VISIBLE NONE;STREETTYPE STREETTYPE VISIBLE NONE;SUFFIX SUFFIX VISIBLE NONE;CFCC CFCC VISIBLE NONE;CITY_L CITY_L VISIBLE NONE;CITY_R CITY_R VISIBLE NONE;FROMLEFT FROMLEFT VISIBLE NONE;TOLEFT TOLEFT VISIBLE NONE;FROMRIGHT FROMRIGHT VISIBLE NONE;TORIGHT TORIGHT VISIBLE NONE;ZIP_L ZIP_L VISIBLE NONE;ZIP_R ZIP_R VISIBLE NONE;POLICE_L POLICE_L VISIBLE NONE;POLICE_R POLICE_R VISIBLE NONE;FIRE_L FIRE_L VISIBLE NONE;FIRE_R FIRE_R VISIBLE NONE;EMS_L EMS_L VISIBLE NONE;EMS_R EMS_R VISIBLE NONE;P_BEAT_L P_BEAT_L VISIBLE NONE;P_BEAT_R P_BEAT_R VISIBLE NONE;MAP_PAGE1 MAP_PAGE1 VISIBLE NONE;MAP_PAGE2 MAP_PAGE2 VISIBLE NONE;MAP_PAGE3 MAP_PAGE3 VISIBLE NONE;X1 X1 VISIBLE NONE;Y1 Y1 VISIBLE NONE;X2 X2 VISIBLE NONE;Y2 Y2 VISIBLE NONE;TYPE TYPE VISIBLE NONE;LABELTYPE LABELTYPE VISIBLE NONE;LESN LESN VISIBLE NONE;RESN RESN VISIBLE NONE;NAME NAME VISIBLE NONE;STREET STREET VISIBLE NONE;LEGALNAME LEGALNAME VISIBLE NONE;SURF_TYPE SURF_TYPE VISIBLE NONE;SPEED SPEED VISIBLE NONE;LCITY LCITY VISIBLE NONE;RCITY RCITY VISIBLE NONE;ONEWAY ONEWAY VISIBLE NONE;NAMED NAMED VISIBLE NONE;ADDRESSED ADDRESSED VISIBLE NONE;NAMELOW NAMELOW VISIBLE NONE;LENGTH LENGTH VISIBLE NONE;COUNTY COUNTY VISIBLE NONE;REVERSED REVERSED VISIBLE NONE;BLM BLM VISIBLE NONE;USFS USFS VISIBLE NONE;MP_DIST MP_DIST VISIBLE NONE;MP_BEG MP_BEG VISIBLE NONE;MP_END MP_END VISIBLE NONE;ROADNUMB ROADNUMB VISIBLE NONE;FLIPME FLIPME VISIBLE NONE;SHAPE_LENG SHAPE_LENG VISIBLE NONE;TCFCC TCFCC VISIBLE NONE;NEW_TYPE NEW_TYPE VISIBLE NONE")
print "Make feature layer :: " + Copied_Input_Streets
time.sleep(5)
# Process: Select Layer By Attribute...
#gp.SelectLayerByAttribute_management(Streets_Layer, "NEW_SELECTION", "\"POLICE_L\" LIKE 'M%' OR \"POLICE_R\" LIKE 'M%'")
arcpy.SelectLayerByAttribute_management(Streets_Layer, "NEW_SELECTION", "\"P_L\" LIKE 'M%' OR \"P_R\" LIKE 'M%'")
print "Select layer by attribute : " + Streets_Layer
time.sleep(5)
# Process: Delete...
arcpy.Delete_management(Prod_1_xxx_Streets_Unique_temp, "FeatureClass")
time.sleep(5)
# Process: Dissolve...
arcpy.Dissolve_management(Medstreets_Layer, Med_Streets_Unique_Temp, "NAME", "", "MULTI_PART", "DISSOLVE_LINES")
time.sleep(5)
# Process: Delete Features...
try:
arcpy.DeleteFeatures_management(Existing_xxx_Streets_Unique_)
except:
print "Delete Existing xxx Streets Unique is a no go."
time.sleep(5)
# Process: Append...
arcpy.Append_management("'Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.Cartegraph\\SDE.DBO.xxx_Streets_Unique_temp'", Existing_xxx_Streets_Unique_, "NO_TEST", "NAME 'NAME' true true false 254 Text 0 0 ,First,#,Database Connections\\xxx@xxx-2_prod.sde\\SDE.DBO.Cartegraph\\SDE.DBO.xxx_Streets_Unique_temp,NAME,-1,-1;Shape.len 'Shape.len' false false true 0 Double 0 0 ,First,#", "")
time.sleep(5)
# Process: Delete Features (2)...
arcpy.DeleteFeatures_management(xxx_Streets)
time.sleep(5)
arcpy.Append_management("dispatchstreets_Copy_Layer", xxx_Streets, "NO_TEST", "OBJECTID 'OBJECTID' true true false 8 Double 0 10 ,First,#;IDNUM 'IDNUM' true true false 8 Double 0 10 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,IDNUM,-1,-1;PREFIX 'PREFIX' true true false 2 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,PREFIX,-1,-1;STREETNAME 'STREETNAME' true true false 30 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,STREETNAME,-1,-1;STREETTYPE 'STREETTYPE' true true false 4 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,STREETTYPE,-1,-1;SUFFIX 'SUFFIX' true true false 2 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,SUFFIX,-1,-1;CFCC 'CFCC' true true false 3 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,CFCC,-1,-1;CITY_L 'CITY_L' true true false 3 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,CITY_L,-1,-1;CITY_R 'CITY_R' true true false 3 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,CITY_R,-1,-1;FROMLEFT 'FROMLEFT' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,FROMLEFT,-1,-1;TOLEFT 'TOLEFT' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,TOLEFT,-1,-1;FROMRIGHT 'FROMRIGHT' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,FROMRIGHT,-1,-1;TORIGHT 'TORIGHT' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,TORIGHT,-1,-1;ZIP_L 'ZIP_L' true true false 5 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,ZIP_L,-1,-1;ZIP_R 'ZIP_R' true true false 5 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,ZIP_R,-1,-1;POLICE_L 'POLICE_L' true true false 15 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,POLICE_L,-1,-1;POLICE_R 'POLICE_R' true true false 15 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,POLICE_R,-1,-1;FIRE_L 'FIRE_L' true true false 15 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,FIRE_L,-1,-1;FIRE_R 'FIRE_R' true true false 15 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,FIRE_R,-1,-1;EMS_L 'EMS_L' true true false 15 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,EMS_L,-1,-1;EMS_R 'EMS_R' true true false 15 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,EMS_R,-1,-1;P_BEAT_L 'P_BEAT_L' true true false 16 Text 0 0 ,First,#;P_BEAT_R 'P_BEAT_R' true true false 16 Text 0 0 ,First,#;MAP_PAGE1 'MAP_PAGE1' true true false 10 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,MAP_PAGE1,-1,-1;MAP_PAGE2 'MAP_PAGE2' true true false 10 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,MAP_PAGE2,-1,-1;MAP_PAGE3 'MAP_PAGE3' true true false 10 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,MAP_PAGE3,-1,-1;X1 'X1' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,X1,-1,-1;Y1 'Y1' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,Y1,-1,-1;X2 'X2' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,X2,-1,-1;Y2 'Y2' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,Y2,-1,-1;TYPE 'TYPE' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,TYPE,-1,-1;LABELTYPE 'LABELTYPE' true true false 8 Double 0 10 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,LABELTYPE,-1,-1;LESN 'LESN' true true false 5 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,LESN,-1,-1;RESN 'RESN' true true false 5 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,RESN,-1,-1;NAME 'NAME' true true false 30 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,NAME,-1,-1;STREET 'STREET' true true false 72 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,STREET,-1,-1;LEGALNAME 'LEGALNAME' true true false 36 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,LEGALNAME,-1,-1;SURF_TYPE 'SURF_TYPE' true true false 20 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,SURF_TYPE,-1,-1;SPEED 'SPEED' true true false 8 Double 0 10 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,SPEED,-1,-1;LCITY 'LCITY' true true false 32 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,LCITY,-1,-1;RCITY 'RCITY' true true false 32 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,RCITY,-1,-1;ONEWAY 'ONEWAY' true true false 5 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,ONEWAY,-1,-1;NAMED 'NAMED' true true false 36 Date 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,NAMED,-1,-1;ADDRESSED 'ADDRESSED' true true false 36 Date 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,ADDRESSED,-1,-1;NAMELOW 'NAMELOW' true true false 36 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,NAMELOW,-1,-1;SOURCETHM 'SOURCETHM' true true false 16 Text 0 0 ,First,#;LENGTH 'LENGTH' true true false 8 Double 0 19 ,First,#;COUNTY 'COUNTY' true true false 16 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,COUNTY,-1,-1;REVERSED 'REVERSED' true true false 16 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,REVERSED,-1,-1;BLM 'BLM' true true false 12 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,BLM,-1,-1;USFS 'USFS' true true false 12 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,USFS,-1,-1;MP_DIST 'MP_DIST' true true false 8 Double 4 14 ,First,#;MP_BEG 'MP_BEG' true true false 8 Double 4 14 ,First,#;MP_END 'MP_END' true true false 8 Double 4 14 ,First,#;ROADNUMB 'ROADNUMB' true true false 4 Long 0 10 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,ROADNUMB,-1,-1;FLIPME 'FLIPME' true true false 4 Long 0 10 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,FLIPME,-1,-1;SHAPE_LENG 'SHAPE_LENG' true true false 8 Double 11 19 ,First,#;CROSS1 'CROSS1' true true false 254 Text 0 0 ,First,#;CROSS2 'CROSS2' true true false 254 Text 0 0 ,First,#;Shape.len 'Shape.len' false false true 0 Double 0 0 ,First,#", "")
print "Append : " + xxx_Streets
time.sleep(5)
# Process: Delete Features (4)...
arcpy.DeleteFeatures_management(Prod_1_Streets)
time.sleep(5)
# Process: Append (4)...
arcpy.Append_management("F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp", Prod_1_Streets, "NO_TEST", "IDNUM 'IDNUM' true true false 4 Long 0 10 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,IDNUM,-1,-1;PREFIX 'PREFIX' true true false 2 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,PREFIX,-1,-1;STREETNAME 'STREETNAME' true true false 30 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,STREETNAME,-1,-1;STREETTYPE 'STREETTYPE' true true false 4 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,STREETTYPE,-1,-1;SUFFIX 'SUFFIX' true true false 2 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,SUFFIX,-1,-1;CFCC 'CFCC' true true false 3 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,CFCC,-1,-1;CITY_L 'CITY_L' true true false 3 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,CITY_L,-1,-1;CITY_R 'CITY_R' true true false 3 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,CITY_R,-1,-1;FROMLEFT 'FROMLEFT' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,FROMLEFT,-1,-1;TOLEFT 'TOLEFT' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,TOLEFT,-1,-1;FROMRIGHT 'FROMRIGHT' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,FROMRIGHT,-1,-1;TORIGHT 'TORIGHT' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,TORIGHT,-1,-1;ZIP_L 'ZIP_L' true true false 5 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,ZIP_L,-1,-1;ZIP_R 'ZIP_R' true true false 5 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,ZIP_R,-1,-1;POLICE_L 'POLICE_L' true true false 15 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,POLICE_L,-1,-1;POLICE_R 'POLICE_R' true true false 15 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,POLICE_R,-1,-1;FIRE_L 'FIRE_L' true true false 15 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,FIRE_L,-1,-1;FIRE_R 'FIRE_R' true true false 15 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,FIRE_R,-1,-1;EMS_L 'EMS_L' true true false 15 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,EMS_L,-1,-1;EMS_R 'EMS_R' true true false 15 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,EMS_R,-1,-1;P_BEAT_L 'P_BEAT_L' true true false 16 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,P_BEAT_L,-1,-1;P_BEAT_R 'P_BEAT_R' true true false 16 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,P_BEAT_R,-1,-1;MAP_PAGE1 'MAP_PAGE1' true true false 10 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,MAP_PAGE1,-1,-1;MAP_PAGE2 'MAP_PAGE2' true true false 10 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,MAP_PAGE2,-1,-1;MAP_PAGE3 'MAP_PAGE3' true true false 10 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,MAP_PAGE3,-1,-1;X1 'X1' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,X1,-1,-1;Y1 'Y1' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,Y1,-1,-1;X2 'X2' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,X2,-1,-1;Y2 'Y2' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,Y2,-1,-1;TYPE 'TYPE' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,TYPE,-1,-1;LABELTYPE 'LABELTYPE' true true false 4 Long 0 10 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,LABELTYPE,-1,-1;LESN 'LESN' true true false 5 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,LESN,-1,-1;RESN 'RESN' true true false 5 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,RESN,-1,-1;NAME 'NAME' true true false 30 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,NAME,-1,-1;STREET 'STREET' true true false 72 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,STREET,-1,-1;LEGALNAME 'LEGALNAME' true true false 36 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,LEGALNAME,-1,-1;SURF_TYPE 'SURF_TYPE' true true false 20 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,SURF_TYPE,-1,-1;SPEED 'SPEED' true true false 4 Long 0 10 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,SPEED,-1,-1;LCITY 'LCITY' true true false 32 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,LCITY,-1,-1;RCITY 'RCITY' true true false 32 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,RCITY,-1,-1;ONEWAY 'ONEWAY' true true false 5 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,ONEWAY,-1,-1;NAMED 'NAMED' true true false 36 Date 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,NAMED,-1,-1;ADDRESSED 'ADDRESSED' true true false 36 Date 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,ADDRESSED,-1,-1;NAMELOW 'NAMELOW' true true false 36 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,NAMELOW,-1,-1;SOURCETHM 'SOURCETHM' true true false 16 Text 0 0 ,First,#;LENGTH 'LENGTH' true true false 8 Double 0 19 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,LENGTH,-1,-1;COUNTY 'COUNTY' true true false 16 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,COUNTY,-1,-1;REVERSED 'REVERSED' true true false 16 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,REVERSED,-1,-1;BLM 'BLM' true true false 12 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,BLM,-1,-1;USFS 'USFS' true true false 12 Text 0 0 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,USFS,-1,-1;MP_DIST 'MP_DIST' true true false 8 Double 4 12 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,MP_DIST,-1,-1;MP_BEG 'MP_BEG' true true false 8 Double 4 12 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,MP_BEG,-1,-1;MP_END 'MP_END' true true false 8 Double 4 12 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,MP_END,-1,-1;ROADNUMB 'ROADNUMB' true true false 2 Short 0 5 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,ROADNUMB,-1,-1;FLIPME 'FLIPME' true true false 2 Short 0 5 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,FLIPME,-1,-1;SHAPE_LENG 'SHAPE_LENG' true true false 8 Double 11 18 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,SHAPE_LENG,-1,-1;CROSS2 'CROSS2' true true false 254 Text 0 0 ,First,#;CROSS1 'CROSS1' true true false 254 Text 0 0 ,First,#;New_Type 'New_Type' true true false 8 Double 8 38 ,First,#,F:\\Processes\\UpdateStreets\Temp\\dispatchstreets_Copy.shp,NEW_TYPE,-1,-1;Shape.len 'Shape.len' false false true 0 Double 0 0 ,First,#", "")
time.sleep(5)
# Process: Delete (2)...
arcpy.Delete_management(Copied_Input_Streets, "ShapeFile")
del arcpy
except:
print 'Errors occurred in UpdateStreetsProd2_def'
raise
# -*- coding: utf-8 -*-
import arcpy
arcpy.AddToolbox(
"C:/Program Files (x86)/DataEast/XTools Pro/Toolbox/XTools Pro.tbx")
arcpy.XToolsGP_CreateRandomSamplingPoints(
"#", "443411.478917272 7444278.59767323 511098.432642961 7465590.76076364",
"#", "#", "CONSTANT", "TOTAL", "10", "#", "CONSTANT", "1 Meters", "#",
"Unknown")
# Chnage the address for the TauDEM toolbox
# Import arcpy module
print "importing arcpy (this takes a while)..."
import arcpy
from arcpy import env
from arcpy.sa import *
import numpy
import math
import os
import matplotlib.pyplot as plt
import scipy
import json
# Load required toolboxes
arcpy.AddToolbox("C:/Program Files/TauDEM/TauDEM5Arc/TauDEM Tools.tbx")
arcpy.ImportToolbox("C:/Program Files/TauDEM/TauDEM5Arc/TauDEM Tools.tbx")
arcpy.gp.toolbox = "C:/Program Files/TauDEM/TauDEM5Arc/TauDEM Tools.tbx"
# Check out any necessary licenses
arcpy.CheckOutExtension("spatial")
env.overwriteOutput = True
# ******************************************************************************
def move_to_next_pixel(fdr, row, col):
# get the fdr pixel value (x,y)
value = fdr[row, col]
#
# /4/3/2/
from ..esri.Geometry import line_to_endpoints
import arcpy
arcpy.AddToolbox('../Utilities.pyt')
related_layers = [{
'layer': 'storm_pipe',
'related': 'storm_struc',
'from_foreign_key': 'from_struc_id',
'to_foreign_key': 'to_struc_id',
'reference_key': 'cid'
}]
for layer in related_layers:
print('processing layer {}...'.format(layer['layer']))
# create the points layer
foreign_key = 'related_oid'
points = 'in_memory/end_point'
points = arcpy.Utilities.LineEndPoints(layer['layer'], 'false',
points).getOutput(0)
print('points layer created: {}'.format(points))
# spatially join to the related point layer
joined_points = 'in_memory/joined_points'
joined_points = arcpy.SpatialJoin_analysis(points, layer['related'],
joined_points).getOutput(0)
print('spatial join completed: {}'.format(joined_points))
# add a join on the line layer
line_layer = arcpy.MakeFeatureLayer_management(layer['layer'],
except Exception as e:
# If an error occurred, print line number and error message
import traceback
import sys
tb = sys.exc_info()[2]
print("Line {0}".format(tb.tb_lineno))
print(e.message)
arcpy.Compact_management(templ)
arcpy.Compact_management(wrkspc)
mxd_nA = out_fc + '\\IGT4SAR.mxd'
##mxd_nB = "%r"%mxd_nA
##mxd_name = mxd_nB[2:-1]
##
mxd = arcpy.mapping.MapDocument(mxd_nA)
df = arcpy.mapping.ListDataFrames(mxd)[0]
df.spatialReference = sr
# Add the SARToolBox
arcpy.AddToolbox("C:\\MapSAR_Ex\\Tools\\SAR_Toolbox100.tbx")
mxd.save()
del mxd
##
def CalculateLastTwoFields(inTable, freqTable, newView, expression):
'''
Calculates the TTL_ZONING field. Then calls the script that concatenates the TTL_ZONING field based
on the PARCELID field. Calculates MULTZONE field based on the frequency of the PARCELID field.
'''
try:
ScriptUtils.AddMsgAndPrint("\tProcessing the TTL_ZONING field...", 0)
# Process: Add TTL_ZONING Field
arcpy.AddField_management(inTable, "TTL_ZONING", "TEXT", "", "", "100", "", "NULLABLE", "NON_REQUIRED", "")
# Process: Calculate TTL_ZONING Field
codeblk = "#"
if inTable.find("Flood") != -1:
codeblk = '''def GetFZone(plotcode):
if (plotcode == 4):
return "A"
if (plotcode == 9):
return "AE"
if (plotcode == 23):
return "AE"
if (plotcode < 4):
return "X"'''
arcpy.CalculateField_management(inTable, "TTL_ZONING", expression, "PYTHON", codeblk)
# Process: Run Concatenate
ScriptUtils.AddMsgAndPrint("\tConcatenating data...", 0)
arcpy.AddToolbox(r"J:\pva\Toolboxes\Concatenate\Concatenate.tbx")
arcpy.Concatenate_pvaConcatenate(inTable, "PVA_Parcel_PARCELID", "TTL_ZONING")
# Process: Make Table View
arcpy.MakeTableView_management(ConcatOutput_dbf, newView)
# Process: Make Table View
Frequency_View = "Frequency_" + newView
arcpy.MakeTableView_management(freqTable, Frequency_View)
# Process: Add Field
ScriptUtils.AddMsgAndPrint("\tProcessing the MULTZONE field...", 0)
arcpy.AddField_management(newView, "MULTZONE", "TEXT", "", "", "5", "", "NULLABLE", "NON_REQUIRED", "")
# Process: Add Join
arcpy.AddJoin_management(newView, "UniqueID", Frequency_View, "PVA_Parcel_PARCELID", "KEEP_ALL")
# Process: Calculate Field
fieldName = ""
fieldObjList = arcpy.ListFields(newView)
for field in fieldObjList:
if "MULTZONE" in field.name:
fieldName = field.name
calcExp = "SetMultiZone( !{0}.FREQUENCY! )".format(os.path.basename(freqTable))
codeblk = '''def SetMultiZone(frequency):
value = ""
if frequency == 1:
value = "NO"
if frequency > 1:
value = "YES"
return value'''
# ScriptUtils.AddMsgAndPrint("\t\t---fieldName: {0}\n\t\t--- calcExp: {1}".format(fieldName, calcExp), 0)
arcpy.CalculateField_management(newView, fieldName, calcExp, "PYTHON", codeblk)
del newView, Frequency_View
except:
# Return any Python specific errors
tb = sys.exc_info()[2]
tbinfo = traceback.format_tb(tb)[0]
pymsg = "PYTHON ERRORS:\n Traceback Info:\n{0}\n Error Info:\n {1}: {2}\n".format(tbinfo, str(sys.exc_type), str(sys.exc_value))
tmRun = time.strftime("%X", time.localtime())
endTime = time.time()
prodInfo = "\tScript errored after running for {0} seconds.".format(str(round((endTime - startTime))))
msg = "\n\n\tScript error at: {0}\n{1}\n\n{2}".format(tmRun, prodInfo, pymsg)
ScriptUtils.AddMsgAndPrint(msg, 2)
#To run from command terminal:
# Start > Run > cmd
# P: & cd P:\connectivity\ & C:\Python27\ArcGIS10.4\python.exe mbon_connectivity.py
# ---------------------------------------------------------------------------
# Import arcpy module
#import arcgisscripting as ap, shutil, os, csv, sys
import arcpy as ap, shutil, os, csv, sys
# get input arguments
runs_csv = sys.argv[1] #"P:\\connectivity\\runs_todo.csv"
cache_dir = "P:\\MGET_cache"
#gp = arcgisscripting.create()
ap.AddToolbox(
'C:\\Program Files\\GeoEco\\ArcGISToolbox\\Marine Geospatial Ecology Tools.tbx',
'GeoEco')
# read in csv with runs per row and variables per column
csv_file = open(runs_csv, 'r')
runs = csv.DictReader(csv_file)
# iterate over runs
for run in runs: # run = runs.next()
if run['do'] == 'FALSE':
continue
# assign variables
for var in run.keys():
globals()[var] = run[var]
# CONSTANT DECLARATIONS
SPECIES_TABLE = r"E:\cottaan\My Documents\ArcGIS\jsonToFeaturesOutput\New File Geodatabase.gdb\SpeciesData"
EXTENT_FC = "in_memory\\RangesFC"
OUTPUT_PATH = "E:/cottaan/My Documents/ArcGIS/jsonToFeaturesOutput/zip/"
SPECIES_FEATURE_LAYER_NAME = "AllSpecies"
# INPUT PARAMETERS
arcpy.MakeFeatureLayer_management(
r"E:\cottaan\My Documents\ArcGIS\IUCN_species2011.gdb\AllSpecies",
SPECIES_FEATURE_LAYER_NAME)
scratchFC = r"E:\cottaan\My Documents\ArcGIS\jsonToFeaturesOutput\New File Geodatabase.gdb\tmp"
# ENVIRONMENT VARIABLES
arcpy.env.overwriteOutput = True
arcpy.AddToolbox(
r"E:\cottaan\My Documents\ArcGIS\Toolboxes\geoprocessing-tools-for-hadoop-master\HadoopTools.pyt"
)
# CREATE A TABLE OF UNIQUE SPECIES TO ITERATE THROUGH
print "Creating unique species table"
# arcpy.Frequency_analysis(SPECIES_FEATURE_LAYER_NAME, SPECIES_TABLE, "speciesid2")
count = str(arcpy.GetCount_management(SPECIES_TABLE))
counter = 1
# ITERATE THROUGH THE SPECIES TO OUTPUT THE RASTER FOR EACH ONE
print "Iterating through species"
AllSpecies = arcpy.SearchCursor(SPECIES_TABLE)
for species in AllSpecies:
id = species.speciesid2
if (id !=
None): # for some reason a NULL is a space in the FREQUENCY table
# ---------------------------------------------------------------------------
# CityDataTruncateParcels.py
# This uses the new arcpy library for ArcGIS 10.0 and higher only.
# (generated by ArcGIS/ModelBuilder)
# ---------------------------------------------------------------------------
# Import system modules
import arcpy
import sys, string, os
# Load required toolboxes...pick the ones from the appropriate Program Files directory
#arcpy.AddToolbox("C:/Program Files/ArcGIS/Desktop10.2/ArcToolbox/Toolboxes/Data Management Tools.tbx")
arcpy.AddToolbox(
"C:/Program Files (x86)/ArcGIS/Desktop10.2/ArcToolbox/Toolboxes/Data Management Tools.tbx"
)
# Local variables...
Geodb_parcels = "C:\\FME Training\\ESRI\\Resources\\VancouverCity.gdb\\Property\\Parcels"
Geodb_parcel_ids = "C:\\FMEData2014\\ESRI\\Resources\\VancouverCity.gdb\\Property\\Parcel_Ids"
# Process: Delete Rows...
arcpy.DeleteRows_management(Geodb_parcels)
arcpy.DeleteRows_management(Geodb_parcel_ids)
import arcpy
import os
import time
arcpy.AddToolbox("https://hydro.arcgis.com/arcgis/services;Tools/Hydrology",
"hydro")
arcpy.env.workspace = arcpy.env.workspace
arcpy.env.overwriteOutput = True
arcpy.env.addOutputsToMap = False
fc = arcpy.GetParameterAsText(0)
Station_ID = arcpy.GetParameterAsText(1)
out_fc = arcpy.env.workspace
expression = '!{0}!.replace("-", "").replace(" ","")'.format(Station_ID)
arcpy.CalculateField_management(fc, Station_ID, expression, "PYTHON")
field = arcpy.ListFields(fc, Station_ID)
with arcpy.da.SearchCursor(fc, ["SHAPE@", Station_ID]) as cursor_fc:
for row_fc in cursor_fc:
out_path = os.path.join(out_fc, row_fc[1])
result = arcpy.Watershed_hydro(InputPoints=row_fc[0],
PointIDField="",
SnapDistance="",
SnapDistanceUnits="Meters",
DataSourceResolution="FINEST",
Generalize=False,
ReturnSnappedPoints=False)
while result.status < 4:
time.sleep(0.1)
arcpy.management.CopyFeatures(result.getOutput(0), out_path)
# ------------------------------------------------------------------------
''' --------------------------------------------------------------
Date Started: October 25, 2012
Author: Denis Potvin
lost track of modifications.
this latest version:
- cleaned up some code
- mxd should have only Direct connect to BCGW
- fixed where clause1 for the client name
--------------------------------------------------------------'''
import arcpy, math, getpass, sys, re, os, textwrap
'''
# for accessing XTools toolbox
if arcpy.GetInstallInfo("desktop")["Version"] == '10.1':
toolboxPath = r'E:\sw_nt\DataEast\XToolsPro 10.1\Toolbox\XTOOLS PRO.tbx' # new ver of Xtools for 10.1
else:
toolboxPath = r'E:\sw_nt\DataEast\XToolsPro 10.2\Toolbox\XTOOLS PRO.tbx' # old ver of Xtools for 10.0
arcpy.AddToolbox(toolboxPath)
arcpy.gp.toolbox = toolboxPath
'''
#print "arg0 = " + sys.argv[0]
class myMXD(object):
''' creates a class to take in tenure stage, file number, parcel numbers, dimensions
inset map will zoom into the parcel, main map will zoom to entire extent
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
# Import system modules...
import sys, os, arcpy
from arcpy.sa import *
# Path to custom toolbox...
scriptdir = os.path.dirname(sys.argv[0])
toolboxpath = scriptdir + "\\..\\toolbox\\LandAdvisor-ITCP.tbx"
arcpy.AddToolbox(toolboxpath)
# Check out any necessary licenses...
arcpy.CheckOutExtension("spatial")
# Script Arguments...
InputRaster = sys.argv[1]
RasterMaskSingleValue = sys.argv[2]
OutputRaster = sys.argv[3]
# Calculation - actual / max
InputRaster = Raster(InputRaster)
ResultRaster = InputRaster / ZonalStatistics(Raster(RasterMaskSingleValue),
"VALUE", InputRaster, "MAXIMUM")
ResultRaster.save(OutputRaster)
elif python_version == 26:
print '*****Using Python 26 to run this script*****'
print''
print''
#Import system modules
import sys, string
#the next two lines are required if you have ever uninstalled the Python that came with ArcGIS and put a new one on
from dbfpy import dbf
from win32com.client import Dispatch
gp = Dispatch('esriGeoprocessing.GpDispatch.1')
# Check out any necessary licenses
gp.CheckOutExtension("spatial")
gp.CheckOutExtension("3D")
# Load required toolboxes...
gp.AddToolbox("C:/Program Files/ArcGIS/ArcToolbox/Toolboxes/Spatial Analyst Tools.tbx")
gp.AddToolbox("C:/Program Files/ArcGIS/ArcToolbox/Toolboxes/Data Management Tools.tbx")
gp.AddToolbox("C:/Program Files/ArcGIS/ArcToolbox/Toolboxes/3D Analyst Tools.tbx")
gp.AddToolbox("C:/Program Files/ArcGIS/ArcToolbox/Toolboxes/Analysis Tools.tbx")
gp.AddToolbox("C:/Program Files/ArcGIS/ArcToolbox/Toolboxes/Conversion Tools.tbx")
gp.OverWriteOutput = 1
### Import system modules
#################################################################
#Use this for PYTHON 2.5
elif python_version == 25:
print '*****Using Python 25 to run this script*****'
print''
print''
import arcgisscripting, csv
