Latest Contributions by BartKowalski

Hi, I wrote a script that updates a feature class from SQL server. It is exactly the same script as http://forums.arcgis.com/threads/45954-Can-t-view-created-feature-class except I am connecting to a different database, and the template FC is different. I noticed when I include field names longer then 10 characters, the code chokes And I get the "File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\arcobjects\_base.py", line 35, in __setattr__     return setattr(self._arc_object, attr, ao) RuntimeError: ERROR 999999: Error executing function." error. I can't figure out the problem especially since the previosu code also contained feature names > 10 characters. Does anyone have a suggestion about this? THanks, BArt import arcpy import pyodbc from arcpy import env cnxn = pyodbc.connect('Driver={SQL Server Native Client 10.0};UID=user;PWD=Password;SERVER=spk-db11sac.spk.ds.usace.army.mil; DATABASE=FTO_OE; APP=MyApp') cursor=cnxn.cursor() cursor.execute("select Grid_ID, UniqueID, Date_Found, Quantity, Northing, Easting, Depth, Grid_Alias, AAR_ID, Initial_ID, Final_ID, Risk_Code, MM_Type, Contractor, Burial_Pit, Weight from dbo.View_MEC_FeatureClass") #,Report_Type, Operation_Class,Operation_ID, Report_Date, AAR_Description, Original_MM_Nomenclature, Model_Description, Survey_Instrument, Modification_Notes,") rows = cursor.fetchall() env.overwriteOutput = True env.workspace = r"G:\Temp\Bart\fort_ord.gdb" template = r"G:\Fort_Ord_GIS\Master_Coverage\Fort_Ord.gdb\env_haz_remediation\oe_item_point" config_keyword = "" OETabl = arcpy.CreateTable_management(r"G:\Temp\Bart", "OETabl.dbf", template) Wcur = arcpy.InsertCursor(OETabl) for row in rows:     t_row                   = Wcur.newRow()     t_row.UniqueID          = row.UniqueID     t_row.Date_Found        = row.Date_Found     #t_row.Operation_Class   = row.Operation_Class  !!!GET ERROR MESSAGE ON COMMENTED OUT LINES!!!     #t_row.Operation_ID      = row.Operation_ID     t_row.Grid_ID           = row.Grid_ID     t_row.AAR_ID            = row.AAR_ID     t_row.Report_Type       = row.Report_Type     #t_row.Report_Date       = row.Report_Date     #t_row.AAR_Description   = row.AAR_Description     t_row.Northing          = row.Northing     t_row.Easting           = row.Easting     t_row.Quantity          = row.Quantity     t_row.Depth             = row.Depth     t_row.Weight            = row.Weight     t_row.Initial_ID        = row.Initial_ID     t_row.Final_ID          = row.Final_ID     #t_row.Model_Description = row.Model_Description     t_row.Risk_Code         = row.Risk_Code     t_row.MM_Type           = row.MM_Type     t_row.Contractor        = row.Contractor     t_row.Burial_Pit        = row.Burial_Pit     #t_row.Survey_Instrument = row.Survey_Instrument     #t_row.Modification_Notes = row.Modification_Notes     #t_row.Original_MM_Nomenclature = row.Original_MM_Nomenclature     Wcur.insertRow(t_row) try:     in_Table = OETabl     x_coords = "Easting"     y_coords = "Northing"     out_layer = "OE_layer"     saved_layer = r"G:\Temp\Bart\Layers\OE.lyr"     spRef = r"C:\Program Files (x86)\ArcGIS\Desktop10.0\Coordinate Systems\Projected Coordinate Systems\State Plane\NAD 1983 (US Feet)\NAD 1983 StatePlane California IV FIPS 0404 (US Feet).prj"     arcpy.MakeXYEventLayer_management(in_Table, x_coords, y_coords, out_layer, spRef)     saved_layer2 = arcpy.SaveToLayerFile_management(out_layer, saved_layer) except:     print arcpy.GetMessages() inFeatures = saved_layer2 outLocation = r"G:\Temp\Bart\Scratch.gdb" outFeatureClass = "OEupdate" outFC = outLocation + "\\" + outFeatureClass if arcpy.Exists(outFC)==True:     arcpy.Delete_management(outFC)         arcpy.FeatureClassToFeatureClass_conversion(inFeatures, outLocation, outFeatureClass) cnxn.commit() cursor.close() cnxn.close() del row del rows del cursor del cnxn ... View more

Hi, I've written a script that connects to a SQL Server via pyodbc, and creates a feature class from a table. The code runs fine, but one in Arc, I don't see my feature class, although the attributes are all there. I am new to python, and can't figure out what I am missing. import arcpy #reload(arcpy) import pyodbc from arcpy import env cnxn = pyodbc.connect('Driver={SQL Server Native Client 10.0};UID=ID;PWD=Password;SERVER=spk-db11sac.spk.ds.usace.army.mil; DATABASE=ftord; APP=MyApp') cursor=cnxn.cursor() cursor.execute("select aquifer, site_id, well_name, station_name, well_type, welltype_desc, northing, easting, coord_source, toc, ground_elev, top_screen_depth, bot_screen_depth, total_depth, diameter, installer, date_inst, date_aban, destroyed, purge_vol, norm_dtw, pump_depth, comments, well_status, destruction_rationale, date_destroyed, ref_document, destruct_permit_number from dbo.Wells_view") rows = cursor.fetchall() env.overwriteOutput = True env.workspace = r"G:\Fort_Ord_GIS\Master_Coverage\Fort_Ord.gdb" template = r"G:\Fort_Ord_GIS\Master_Coverage\Fort_Ord.gdb\improvement_well\water_well_point" Wells = arcpy.CreateFeatureclass_management(r"G:\Temp\Bart\scratch.gdb", "ODB11", "POINT",'', "DISABLED", "DISABLED", template) #arcpy.AddField_management(Wells,'SubTypeIdentifier','TEXT') arcpy.AddField_management(Wells,'PKWellID','TEXT')  arcpy.AddField_management(Wells,'PKMApID','TEXT') arcpy.AddField_management(Wells,'FKMetalID','TEXT') arcpy.AddField_management(Wells,'FKMediaID','TEXT') arcpy.AddField_management(Wells,'FKCoordbtID','TEXT') arcpy.AddField_management(Wells,'FKMnwellID','TEXT') arcpy.AddField_management(Wells,'WellCatDOM','TEXT') arcpy.AddField_management(Wells,'WellTypDOM','TEXT') arcpy.AddField_management(Wells,'WellStaDOM','TEXT') arcpy.AddField_management(Wells,'CaseMatDOM','TEXT') arcpy.AddField_management(Wells,'ConstTyDOM','TEXT') #arcpy.AddField_management(Wells,'HoleDia','TEXT') arcpy.AddField_management(Wells,'DiaUOM','TEXT') #arcpy.AddField_management(Wells,'Depthto1st','TEXT') #arcpy.AddField_management(Wells,'Depthtowat','TEXT') #arcpy.AddField_management(Wells,'Depthtobdk','TEXT') #arcpy.AddField_management(Wells,'Totaldepth','TEXT') #arcpy.AddField_management(Wells,'ReferElev','TEXT') #arcpy.AddField_management(Wells,'ElevUOM','TEXT') arcpy.AddField_management(Wells,'DepthUOM','TEXT') #arcpy.AddField_management(Wells,'Capacity','TEXT') arcpy.AddField_management(Wells,'CapacUOM','TEXT') arcpy.AddField_management(Wells,'FKWpumpID','TEXT') arcpy.AddField_management(Wells,'FKWpumpID','TEXT') arcpy.AddField_management(Wells,'FKTankID','TEXT') arcpy.AddField_management(Wells,'FKInstInID','TEXT') arcpy.AddField_management(Wells,'FKBuildngID','TEXT') arcpy.AddField_management(Wells,'FKProjectID','TEXT') arcpy.AddField_management(Wells,'FKStationID','TEXT') arcpy.AddField_management(Wells,'FKFulzoneID','TEXT') arcpy.AddField_management(Wells,'FKWatsectID','TEXT') arcpy.AddField_management(Wells,'FKGaszoneID','TEXT') arcpy.AddField_management(Wells,'FKHcszoneID','TEXT') arcpy.AddField_management(Wells,'FKStosectID','TEXT') arcpy.AddField_management(Wells,'Narrative','TEXT') Wcur = arcpy.InsertCursor(Wells) for row in rows:         #print row.well_name         t_row = Wcur.newRow()         t_row.PKWellID = row.well_name         t_row.WellStaDOM = row.welltype_desc         Wcur.insertRow(t_row) #for row in rows:         #t_row = Wcur.newRow()         #t_row.PKWellID2 = row.station_name         #Wcur.insertRow(t_row) cnxn.commit() cursor.close() cnxn.close() del row del rows del cursor del cnxn Help greatly appreciated in advance. BArt ... View more

Hi, I am trying to connect to an external SQL server with a table with an x and y fields using pyodbc. Next I am making an XYEventLayer using arcpy, and then converting the XYEventLayer to a feature class. When I run the code outside of ArcView it chokes and says the dataset is not supported or does not exist.  I am not sure if calling the APP keyword is the correct way to do this. When I use the ???arcpy.ListDatasets()??? command I just get ???()??? return. Thank you in advance for your help import arcpy import pyodbc from arcpy import env cnxn = pyodbc.connect('Driver={SQL Server Native Client 10.0};UID=user;PWD=Pass;SERVER=****.usace.army.mil; DATABASE=ftord; APP=MyApp') arcpy.env.workspace= 'MyApp' in_Table = "dbo.Wells_view" y_coords = "northing" x_coords = "easting" out_layer = "wells" arcpy.env.overwriteOutput = 'true' saved_Layer = r"G:\Temp\Bart\layers\Wells.lyr" arcpy.MakeXYEventLayer_management(in_Table, x_coords, y_coords, out_layer) arcpy.FeatureClassToFeatureClass_conversion("Wells", r"G:\Temp\Bart\scratch.gdb", "wells") ... View more

Howdie, I just wrote my first python script that copies an even layer to a shp (yay!). It works fine when I run it in python window with the mxd already open. However, if I run the code without  opening the mxd, I get the dataset "does not exist" error message, and if I run it outside of ArcMap entirely, I get a bunch of error messages. Ultimately, I want to schedule a task that runs the python script like an executable. I understand that the first case is probably due to the fact that I don't have a full path, but it is an event layer, so I am not sure what to put in the path. Any help would be greatly appreciated. Thanks, import arcpy #set the overwrite option arcpy.env.overwriteOutput = 'true' #define the mxd mxd = arcpy.mapping.MapDocument(r"G:\Temp\Bart\mxds\Parcel_map.mxd") #copy specified layer to a new shapefile arcpy.CopyFeatures_management("Transfer Status","G:\Temp\Bart\Shapefiles\PyTest6.shp") ... View more

Hi , I'm unable to define new template locations in the registry. When I go to HKEY_LOCAL_MACHINE\Software\ESRI\Desktop10.0 I don't see any other options. I am running ArcMap 10 on win 7 64 bit. I did not have this issue with XP. Thanks in advance for your help. ... View more

Hi. I've been using the CalulateAcres.dll script (http://arcscripts.esri.com/details.asp?dbid=12307) all the way through version 10 on XP. Recently we've upgraded to 64 bit running on Win 7. For a reason unknown to me, I can no longer add that dll or others to ArcMap. Any ideas on getting around this issue? I am not sure if it is Win 7, or 64bit issue. Thanks in advance. ... View more