Latest Contributions by HalinaLewandowski

Excel to Table does not process records with dates set to xx/xx/1900... as soon as I change date(s) to xx/xx/1910 it works fine.  ... View more

New release 2.3 PRO has a map properties option to clip drawing layer(s) beyond specified extent. I used the "Clip to the outline of the feature" option, then I specified which layer should be excluded from this clip. The project map looks fine. However when map is exported to pdf, it looses some of that setup and draws undesired layers beyond clip boundaries (therefore pdf is useless) Any suggestions? ... View more

I'm trying to delete all features from the SDE layer that has topology... the script fails on the arcpy.DeleteFeatures...  ERROR: arcgisscripting.ExecuteError: ERROR 999999: Error executing function. A class in the topology necessitates validation being run within an edit session. [county.GIS_SDE.BldgInsp] Failed to execute (DeleteFeatures). Here is what I have: SDE_bldginsp = county_con + os.sep + "county.GIS_SDE.bldginsp"  areafield = "SHAPE.area"  sde_concounty = sdeConnClass.SDE_Connection(gis_server, gis_dbcounty,'gis_sde','gis_sde') county_con = sde_concounty.connection gv.SDE_countyconnection = county_con bldginspSDE_layer = "bldginsp_layer" arcpy.MakeFeatureLayer_management(SDE_bldginsp, bldginspSDE_layer, "", "", "") query = areafield + " > 0" arcpy.SelectLayerByAttribute_management(bldginspSDE_layer, "NEW_SELECTION", query) try:    with arcpy.da.Editor(countyconnection) as edit:      print " deleting old features."      arcpy.SelectLayerByAttribute_management(bldginspSDE_layer, "NEW_SELECTION", query)      arcpy.DeleteFeatures_management(bldginspSDE_layer)      print "Deleted selected features from bldginsp "      # APPEND local DORSalTx to SDE DORSalTx...      fclist = [bldginsp_county_city_erased]      arcpy.Append_management(fclist, bldginspSDE_layer)      msg = "bldginsp updated sucessfully"      print msg      logging.info(msg)      #print msg except arcpy.ExecuteError: print(arcpy.GetMessages(2)) ... View more