Latest Contributions by AdamCrateau1

I have a server with Server and Desktop installed locally.  I'm trying to run an arcpy script as a scheduled task, 'out-of-process', and it is not working.  Interesting some basic arcpy functions, such as arcpy.Exists(), are working, but most of the functions are not.  Also, when I explore into the arcpy folders in C:\Program Files\ArcGIS\Desktop10.2\arcpy\arcpy, many of my python scripts have corresponding compiled version (.pyc).  I believe I am pointed to the correct python.exe, as Desktop was installed after Server.  Any thoughts on what is happening? ... View more

Hello, We have an SDE database on a SQL machine in our MS Server-stack.  We would like to run some python/arcpy scripts from this machine as scheduled tasks.  We use OS-authentication, and the tasks would be run under a 'Service Account' login.  Do we need ArcGIS Desktop installed on that machine in order to call arcpy commands within a script? Some insight:  On this machine there is a Python27 folder at the root level, which has one subfolder:  ArcGISx6410.2 Thanks,  Adam ... View more

I need to create a script that will copy our county's parcel data, maintained in SDE/SQL, to a file geodatabase.  This script will be run as a scheduled task over the weekend.  What GP tool do you recommend for this process? Consider that our schema is 'set in stone' and we have no relationship classes to maintain.  I have tested both CopyFeatures_management and FeatureClassToFeatureClass_conversion.  Both work.  FC to FC is slightly faster, but speed is not really an issue.  In theory, CopyFeatures, run with Overwrite = True, matches our workflow as we are not converting to a shapefile or coverage.  FeatureClassToGeodatabase_conversion may be the best tool, as there are about 25 feature classes that need to be copied. Also, I need to ensure that the machine running the script is able to connect to the SDE data.  We are using DBO-schema with OS authentication. The script will likely be run by the same server that houses our SDE.  Does anyone have experience with a similar scenario? Thanks,  Adam ... View more

Does anyone have any experience with PIP, or Pip-Win for installing/managing third-party packages?  I would like to utilize 'reportlab', an OSS package for creating PDFs.  Currently, my only python interpreter/installation is c:\python27\ArcGIS10.2\.   Do I need a separate Python installation to add a package such as reportlab or mathplotlib?  My end goal is to utilize reportlab within ArcMap, using a custom script. ... View more

My primary goal will be to create add-ins using Python that include some GUIs.  Beyond that, I'm interested in creating some stand alone Python apps and wondering what is the best all around development package.  Many Thanks ... View more

Hello, I'm having trouble with schema issues when converting a fixed length text file to a gdb table.  My workflow is: 1. convert fixed-length to comma-separated using python's csv module 2. create table from csv file using TableToTable_conversion The original fixed-length file looks like this: R75190  083W05AA03300  00000003268   INDIAN WELLS            LP  S 302GOLF COURSE ESTATES                     00004600000.00R45 00006200000010116000016316000013951011152002       92401000 1010000000000000000000200201402RITCHIE,ADAM S &                RITCHIE,TRACEY L                3268 INDIAN WELLS LP S                                          SALEM           OR9730222700025BS R581 SSAL.A    00002637.72 R75191  083W05AA03400  00000003264   INDIAN WELLS            LP  S 302GOLF COURSE ESTATES                     00004700000.14R41 00006200000009804000016004000013761011152002       92401000 1010001480000826200300200201340JAMES-BELDEN,DEEDE M            3264 INDIAN WELLS LP S                                                                          SALEM           OR9730221880475WD R581 SSAL.A    00002601.80 R75192  083W05AA03500  00000003258   INDIAN WELLS            LP  S 302GOLF COURSE ESTATES                     00004800000.15R41Z00005730000009363000015093000016652010071997       92401000 1010001299000312199900199701398DUUS,CATHERINE M                3258 INDIAN WELL LOOP S                                                                         SALEM           OR9730215820524WD R581 SSAL.A    00003039.98 R75193  083W05AA03600  00000003254   INDIAN WELLS            LP  S 302GOLF COURSE ESTATES                     00004900000.15R41Z00005730000009363000015093000016652010071997       92401000 1010002180000713200900199701398WALLACE,CONSTANCE M             3254 INDIAN WELLS LP S                                                                          SALEM           OR9730230850148WD R581 SSAL.A    00003039.98 My TXT to CSV code looks like this: import csv, os, datetime, arcpy workfolder = arcpy.GetParameterAsText(0) inputfile = arcpy.GetParameterAsText(1) outfile = arcpy.GetParameterAsText(2) schemafile = workfolder + '\\schema.ini' outputfile = workfolder + '\\' + outfile if os.path.exists(schemafile):     os.remove(schemafile) if os.path.exists(outputfile):     os.remove(outputfile) #--------------------------------------------- def validate(date_text):     date_text = date_text.zfill(8)     year = date_text[4:]     month = date_text[0:2]     day = date_text[2:4]     date_sorted = year+month+day     try:         return datetime.datetime.strptime(date_sorted,'%Y%m%d')     except ValueError:         return "" #---------------------------------------------- with open(outputfile, 'wb') as outcsvfile:     filewriter = csv.writer(outcsvfile,quoting=csv.QUOTE_MINIMAL)     # Add header row     filewriter.writerow(['PropID','Taxlot','StNumInit','StNumSx','StName','StType','StDirPx','StDirSx','Zip3','SubName','Block',             'Lot','Acres','StatClass','RMVLand','RMVImp','RMVTotal','AssdValue','LastApprDt','Zoning','CodeArea','MultCode','PropClass',             'SalePrice','SaleDateTxt','SaleCode','YearConst','LivingArea','OwnerName','OwnerAdd1','OwnerAdd2','OwnerAdd3','OwnerCity',             'OwnerState','OwnerZip','DeedRef','MaintCode','NbrhdCode','TaxBalance','SaleDate'])     # Iterate through file, assign variables and write to CSV file     with open(inputfile, 'r') as TSGinputfile:         for line in TSGinputfile.readlines():             PropID = line[0:8]             Taxlot = line[8:23]             StNumInit = line[23:34]             StNumSx = line[34:37]             StName = line[37:61]             StType = line[61:63]             StDirPx = line[63:65]             StDirSx = line[65:67]             Zip3 = line[67:70]             SubName = line[70:110]             Block = line[110:113]             Lot = line[113:116]             Acres = line[116:124]             StatClass = line[124:128]             RMVLand = line[128:137]             RMVImp = line[137:146]             RMVTotal = line[146:155]             AssdValue = line[155:164]             LastApprDt = line[164:172]             Zoning = line[172:179]             CodeArea = line[179:187]             MultCode = line[187:188]             PropClass = line[188:191]             SalePrice = line[191:200]             SaleDateTxt = line[200:208]             SaleCode = line[208:210]             YearConst = line[210:214]             LivingArea = line[214:219]             OwnerName = line[219:251]             OwnerAdd1 = line[251:283]             OwnerAdd2 = line[283:315]             OwnerAdd3 = line[315:347]             OwnerCity = line[347:363]             OwnerState = line[363:365]             OwnerZip = line[365:370]             DeedRef = line[370:381]             MaintCode = line[381:386]             NbrhdCode = line[386:396]             TaxBalance = line[396:407]             SaleDate = validate(SaleDateTxt)             if Taxlot <> '':                 filewriter.writerow([PropID,Taxlot,StNumInit,StNumSx,StName,StType,StDirPx,StDirSx,Zip3,SubName,Block,Lot,Acres,                     StatClass,RMVLand,RMVImp,RMVTotal,AssdValue,LastApprDt,Zoning,CodeArea,MultCode,PropClass,SalePrice,SaleDateTxt,                     SaleCode,YearConst,LivingArea,OwnerName,OwnerAdd1,OwnerAdd2,OwnerAdd3,OwnerCity,OwnerState,OwnerZip,DeedRef,                     MaintCode,NbrhdCode,TaxBalance,SaleDate]) My CSV to Table code looks like this: import arcpy, os input_csv = arcpy.GetParameterAsText(0) gdbfolder = arcpy.GetParameterAsText(1) table_name = arcpy.GetParameterAsText(2) arcpy.env.workspace = gdbfolder out_table = os.path.join(gdbfolder,table_name) if os.path.exists('schemafile.ini'):     os.remove('schemafile.ini') arcpy.env.overwriteOutput = True arcpy.TableToTable_conversion(input_csv,gdbfolder,table_name,"#",     """PropID "PropID" true true false 8 Text 0 0 ,First,#,input_csv,PropID,-1,-1;     Taxlot "Taxlot" true true false 15 Text 0 0 ,First,#,input_csv,Taxlot,-1,-1;     StNumInit "StNumInit" true true false 11 Text 0 0 ,First,#,input_csv,StNumInit,-1,-1;     StNumSx "StNumSx" true true false 3 Text 0 0 ,First,#,input_csv,StNumSx,-1,-1;     StName "StName" true true false 24 Text 0 0 ,First,#,input_csv,StName,-1,-1;     StType "StType" true true false 2 Text 0 0 ,First,#,input_csv,StType,-1,-1;     StDirPx "StDirPx" true true false 2 Text 0 0 ,First,#,input_csv,StDirPx,-1,-1;     StDirSx "StDirSx" true true false 2 Text 0 0 ,First,#,input_csv,StDirSx,-1,-1;     Zip3 "Zip3" true true false 3 Text 0 0 ,First,#,input_csv,Zip3,-1,-1;     SubName "SubName" true true false 40 Text 0 0 ,First,#,input_csv,SubName,-1,-1;     Block "Block" true true false 3 Text 0 0 ,First,#,input_csv,Block,-1,-1;     Lot "Lot" true true false 3 Text 0 0 ,First,#,input_csv,Lot,-1,-1;     Acres "Acres" true true false 8 Double 0 0 ,First,#,input_csv,Acres,-1,-1;     StatClass "StatClass" true true false 4 Text 0 0 ,First,#,input_csv,StatClass,-1,-1;     RMVLand "RMVLand" true true false 4 Long 0 0 ,First,#,input_csv,RMVLand,-1,-1;     RMVImp "RMVImp" true true false 4 Long 0 0 ,First,#,input_csv,RMVImp,-1,-1;     RMVTotal "RMVTotal" true true false 4 Long 0 0 ,First,#,input_csv,RMVTotal,-1,-1;     AssdValue "AssdValue" true true false 4 Long 0 0 ,First,#,input_csv,AssdValue,-1,-1;     LastApprDt "LastApprDt" true true false 8 Text 0 0 ,First,#,input_csv,LastApprDt,-1,-1;     Zoning "Zoning" true true false 7 Text 0 0 ,First,#,input_csv,Zoning,-1,-1;     CodeArea "CodeArea" true true false 8 Text 0 0 ,First,#,input_csv,CodeArea,-1,-1;     MultCode "MultCode" true true false 1 Text 0 0 ,First,#,input_csv,MultCode,-1,-1;     PropClass "PropClass" true true false 3 Text 0 0 ,First,#,input_csv,PropClass,-1,-1;     SalePrice "SalePrice" true true false 4 Long 0 0 ,First,#,input_csv,SalePrice,-1,-1;     SaleDateTxt "SaleDateTxt" true true false 8 Text 0 0 ,First,#,input_csv,SaleDateTxt,-1,-1;     SaleCode "SaleCode" true true false 2 Text 0 0 ,First,#,input_csv,SaleCode,-1,-1;     YearConst "YearConst" true true false 4 Text 0 0 ,First,#,input_csv,YearConst,-1,-1;     LivingArea "LivingArea" true true false 5 Text 0 0 ,First,#,input_csv,LivingArea,-1,-1;     OwnerName "OwnerName" true true false 32 Text 0 0 ,First,#,input_csv,OwnerName,-1,-1;     OwnerAdd1 "OwnerAdd1" true true false 32 Text 0 0 ,First,#,input_csv,OwnerAdd1,-1,-1;     OwnerAdd2 "OwnerAdd2" true true false 32 Text 0 0 ,First,#,input_csv,OwnerAdd2,-1,-1;     OwnerAdd3 "OwnerAdd3" true true false 32 Text 0 0 ,First,#,input_csv,OwnerAdd3,-1,-1;     OwnerCity "OwnerCity" true true false 16 Text 0 0 ,First,#,input_csv,OwnerCity,-1,-1;     OwnerState "OwnerState" true true false 2 Text 0 0 ,First,#,input_csv,OwnerState,-1,-1;     OwnerZip "OwnerZip" true true false 5 Text 0 0 ,First,#,input_csv,OwnerZip,-1,-1;     DeedRef "DeedRef" true true false 11 Text 0 0 ,First,#,input_csv,DeedRef,-1,-1;     MaintCode "MaintCode" true true false 5 Text 0 0 ,First,#,input_csv,MaintCode,-1,-1;     NbrhdCode "NbrhdCode" true true false 10 Text 0 0 ,First,#,input_csv,NbrhdCode,-1,-1;     TaxBalance "TaxBalance" true true false 8 Double 0 0 ,First,#,input_csv,TaxBalance,-1,-1;     SaleDate "SaleDate" true true false 8 Date 0 0 ,First,#,input_csv,SaleDate,-1,-1""","#") The TableToTable tool is not honoring the field mapping I include in the code.  For example, OwnerZip is a Long Integer in my output table, and all the text fields are length = 255.   One solution I haven't tried yet is to read the input file one line at a time and insert it into a table using an insertCursor.  This would bypass the need for a csv file.  Any suggestions?  Many Thanks, Adam ... View more

Hello, I'm attempting to write a script that takes in a CSV file and utilizes an arcpy.TableToTable_conversion() to create a table in a geodatabase.  I would like to take advantage of Field Mapping functionality in arcpy so that I can reliably/consistently create a table with the same attributes.  Based on some direction I've found on this forum, I've tried the following code.  It creates a table but does not honor the length values of the various string fields (i.e. all string fields are length = 255): def GetFieldMaps():     tblFieldMaps = []     tblFieldMaps.append(["PropID"         ,"PropID"         ,"String",8])     tblFieldMaps.append(["Taxlot"         ,"PropID"         ,"String",15])     tblFieldMaps.append(["StreetNo"       ,"StreetNo"       ,"String",11])     tblFieldMaps.append(["StreetNoSx"     ,"StreetNoSx"     ,"String",3])     tblFieldMaps.append(["StreetName"     ,"StreetName"     ,"String",24])     tblFieldMaps.append(["StreetType"     ,"StreetType"     ,"String",2])     tblFieldMaps.append(["StreetDirPx"    ,"StreetDirPx"    ,"String",2])     tblFieldMaps.append(["StreetDirSx"    ,"StreetDirSx"    ,"String",2])     tblFieldMaps.append(["Zip3"           ,"Zip3"           ,"Short" ,3])     tblFieldMaps.append(["SubName"        ,"SubName"        ,"String",40])     tblFieldMaps.append(["Block"          ,"Block"          ,"String",3])     tblFieldMaps.append(["Lot"            ,"Lot"            ,"String",3])     tblFieldMaps.append(["Acres"          ,"Acres"          ,"Double",8,2])     tblFieldMaps.append(["StatClass"      ,"StatClass"      ,"String",4])     tblFieldMaps.append(["RMVLand"        ,"RMVLand"        ,"Long"  ,9])     tblFieldMaps.append(["RMVImp"         ,"RMVImp"         ,"Long"  ,9])     tblFieldMaps.append(["RMVTotal"       ,"RMVTotal"       ,"Long"  ,9])     tblFieldMaps.append(["AssdValue"      ,"AssdValue"      ,"Long"  ,9])     tblFieldMaps.append(["LastApprDate"   ,"LastApprDate"   ,"String",8])     tblFieldMaps.append(["Zoning"         ,"Zoning"         ,"String",7])     tblFieldMaps.append(["CodeArea"       ,"CodeArea"       ,"String",8])     tblFieldMaps.append(["MultCodeArea"   ,"MultCodeArea"   ,"String",1])     tblFieldMaps.append(["PropClass"      ,"PropClass"      ,"String",3])     tblFieldMaps.append(["SalePrice"      ,"SalePrice"      ,"Long"  ,9])     tblFieldMaps.append(["SaleDateText"   ,"SaleDateText"   ,"String",8])     tblFieldMaps.append(["SaleCode"       ,"SaleCode"       ,"String",2])     tblFieldMaps.append(["YearConst"      ,"YearConst"      ,"String",4])     tblFieldMaps.append(["GrossLivingArea","GrossLivingArea","String",5])     tblFieldMaps.append(["OwnerName"      ,"OwnerName"      ,"String",32])     tblFieldMaps.append(["OwnerAdd"       ,"OwnerAdd"       ,"String",32])     tblFieldMaps.append(["OwnerAdd1"      ,"OwnerAdd1"      ,"String",32])     tblFieldMaps.append(["OwnerAdd2"      ,"OwnerAdd2"      ,"String",32])     tblFieldMaps.append(["OwnerCity"      ,"OwnerCity"      ,"String",16])     tblFieldMaps.append(["OwnerState"     ,"OwnerState"     ,"String",2])     tblFieldMaps.append(["OwnerZip"       ,"OwnerZip"       ,"String",5])     tblFieldMaps.append(["DeedRef"        ,"DeedRef"        ,"String",11])     tblFieldMaps.append(["MaintCode"      ,"MaintCode"      ,"String",5])     tblFieldMaps.append(["NbrhdCode"      ,"NbrhdCode"      ,"String",10])     tblFieldMaps.append(["CurLeviedTax"   ,"CurLeviedTax"   ,"Double",11,2])     tblFieldMaps.append(["SaleDate"       ,"SaleDate"       ,"Date"]) def GetFieldMappings(out_table,fieldmaplist):     try:         fieldmappings = arcpy.FieldMappings()         for field in fieldmaplist:             fldmap = arcpy.FieldMap()             fldmap.addInputField(out_table,field[0])             fld = fldmap.outputField             fld.name = field[1]             fld.aliasName = field[1]             fld.type = field[2]             fld.length = field[3]             fldmap.outputField = fld             fieldmappings.addFieldMap(fldmap)             print "Added field %s" % (field[1])         return fieldmappings     except Exception as e:         print e tableFieldMaps = GetFieldMaps() fieldmappings = GetFieldMappings(out_table,tableFieldMaps) arcpy.TableToTable_conversion(input_csv,gdbfolder,table_name,fieldmappings) ... View more

Hello.  I would like to know if the Ground-to-Grid Correction in ArcMap is an object that can be accessed.  If so, how?   Thanks, Adam ... View more