Latest Contributions by GaryEhrhardt

I have a very simple python script that does a compress on one of our enterprise GDB's. The script used to successfully run every night but is now receiving the following error: "ERROR 000837: The workspace is not the correct workspace type" There have been 2 recent changes to our environment - one of which must be a contributing factor to this script now erroring out. The first is upgrading from ArcGIS 10.0 SP4 to ArcGIS 10.1 SP1. The other is that we are now running this script on a new server where the old server had 32 bit processing, and the new server is 64 bit. Here is the script that worked on our old server: import arcgisscripting gp = arcgisscripting.create() gp.toolbox = "management" gp.compress("Database Connections\sde_loader@bierstadt.sde") Running the same script on the new server (only change being the db connection) errored out. I tried updating the python code as follows: import arcpy arcpy.ClearWorkspaceCache_management() arcpy.Compress_management("Database Connections\saxon2_bierstadt_sde_loader.sde") This also received the same error (000837) Any ideas on what may be causing this error would be much appreciated. Gary ... View more

I've written a python script that loops thru all records in a shapefile, checks each record for certain criteria and prints out certain fields from the records that meet the condition. That is working fine. Now instead of printing the results, I want to write these certain fields to either a text file or an excel file. Any suggestions on what commands or simple block of code might accompliss this? Here is my script that prints my results: import arcpy from arcpy import env env.workspace = "C:/workspace" pin_hold = "999999999999" area_hold = 0 township_hold = "" section_hold = "" quarter_hold = "" parcelname_hold = "" public_hold = "" corrsource_hold = "" text_file = open("rename_pins.txt", "w") rows = arcpy.SearchCursor("parcels_Identity6.SHP", "", "", "", "PIN; PARCELNAME; BLMPIN; TRANSFER; PUBLIC_; PARCEL_KEY; CORR_SOURC; Shape_area; Shape_len; Id; Township; Section; Quarter", "PIN A") for row in rows:     if row.PIN == pin_hold:         if row.Shape_area > area_hold:             area_hold = row.Shape_area             township_hold = row.Township             section_hold = row.Section             quarter_hold = row.Quarter             parcelname_hold = row.PARCELNAME             public_hold = row.PUBLIC_             corrsource_hold = row.CORR_SOURC     else:         if pin_hold[0:4] != township_hold or pin_hold[4:6] != section_hold or pin_hold[6] != quarter_hold:             print pin_hold + ' ' + str(area_hold) + ' ' + parcelname_hold + ' ' + public_hold + ' ' + corrsource_hold         pin_hold = row.PIN         area_hold = row.Shape_area         township_hold = row.Township         section_hold = row.Section         quarter_hold = row.Quarter         parcelname_hold = row.PARCELNAME         public_hold = row.PUBLIC_         corrsource_hold = row.CORR_SOURC print 'completed' Thanks, Gary ... View more

I have created several custom forms for easier collection of data in ArcPad. The forms that contain comboboxes (for FC's with domains) are not showing up in ArcPad. Instead, the generic list of attributes show up when collecting data for such a FC. The custom forms that do not have any comboboxes on them show up just fine in ArcPad. Anyone have any idea what I may be missing? We are using ArcPad 8.0 SP3 Thanks, Gary ... View more

All, Point and line data were collected with a Trimble GeoXH. When I checked in this data to my PGDB vis ArcPad Data Manager, I received a message that said that everything was successfully checked in. The line data did process successfully. However for the point data, Only the attributes seem to exist for my new points. The attribute table for my point layer shows rows for each new point collected. But nothing is showing up spatially - no points drawn in ArcMap. Has anyone come across such a scenario? Any ideas for a fix? Thanks, Gary ... View more