Latest Contributions by MihaKlemencic

I am writing a python script. In certain part of the script I would like to create a connection to MS Access database. Based on argument the script would read ID of the municipality and use it for other operations. Below is the part of JS script which connects and reads data from MS Access Database and I would like to use it in python script. appDB = WScript.CreateObject("ADODB.Connection");     appDB.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Database);//path to database is already defined at the begining of code     str = "SELECT mun.id, mun.alias FROM mun WHERE (mun.alias)='" + municipality + "';"; appRS = appDB.Execute(str); midOb = appRS("id").Value; appRS.close; appDB.close; #WScript.Echo(alias); #WScript.Echo(idMun); #WScript.Echo(mun_code);‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ArcGIS version: 9.1-9.3. I hope you remember old times  ... View more

I am new to python and I would to like to count the number of features in each feature class that meet certain criteria. In geodatabase I have many feature classes. One of the attribute field has values "number/number" --> 50/2, 99/6 I would to like to loop each feature class, select layer by attribute and count selected features, which contain sign "/" and print the result. Below is python code: import arcpy #Set the input workspace arcpy.env.workspace = "d:/TMP/miha_k/zirovnica/novo/test.gdb" fcs = arcpy.ListFeatureClasses() cursor = arcpy.SearchCursor(fcs) for row in fcs:       arcpy.SelectLayerByAttribute_management(fcs, "NEW_SELECTION", "PARCELA LIKE '%/%'")       arcpy.GetCount_management(fcs)       print row‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I would appreciate your help  ... View more

I would like write RGB values of each polygon in attribute table and then convert to excel/CSV/txt file. I found this script that writes RGB values for each polygon into attribute table. I created new script as it shows on this page. However when I run the tool, I get a message: Executing: rgbValues D:\temp\GIS\eGeologija\KRANJ\SIMBOLOGIJA krpoly_opis_polygon # Start Time: Mon Feb 06 18:15:25 2017 Running script rgbValues... STARTED ====================================================================== D:\temp\GIS\eGeologija\KRANJ\SIMBOLOGIJA\TempGDB.gdb Path: D:\temp\GIS\eGeologija\KRANJ\SHP\krpoly.shp Spatial Reference: D48_Slovenia_TM TEMPS SET _R field exists _G field exists _B field exists ====================================================================== * FREQUENCIES & TEMP CARTO TILES Failed script rgbValues... Traceback (most recent call last): File "D:\temp\GIS\eGeologija\RGB_values.py", line 107, in <module> arcpy.Frequency_analysis(LayerPath, TempFrequency, FieldName, "") File "c:\program files (x86)\arcgis\desktop10.5\arcpy\arcpy\analysis.py", line 1276, in Frequency raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000735: Frequency Field(s): Value is required Failed to execute (Frequency). Failed to execute (rgbValues). Failed at Mon Feb 06 18:15:26 2017 (Elapsed Time: 0.45 seconds) Line 107 represents this line of code: arcpy.Frequency_analysis(LayerPath, TempFrequency, FieldName, ""). Here I do not know how to reapir script so I would appreciate your help! ... View more

I am looking for tool to spatial sort polygons in shapefile. Sorting should be done on certain attribute which is more important than others: Polygons with atribute values Ced must be spatially sorted on top, then Bud, Gog and so on. Polygons with values Bid must be spatially sorted on the bottom. I need this shapefile structure for symbolizing layer in gis software (developed inside company)which does not support symbol levels in cartography as ArcGIS does. I found 4 tools: Sort (Data management): this tool has 5 predefined algorithms but does not allow spatially sort by attributes and two other tools: http://www.arcgis.com/home/item.html?id=b28e04f7d4e846229a2580f0cbdd29e1  and http://www.arcgis.com/home/item.html?id=d2ce3b7b11314d9cbc3f588f4d01c0a8. I assume that these 2 tools also do not allow polygons to be spatially sorted by attributes. what about qgis plugin? Any other solution? ... View more

Hi! I'm looking for solution to create a script for importing only one band from orthphotos, then reclassifying into 2 classes, subtracting them and export as polygons. Orthophotos are from 2011 and 2014 and are stored in 2 directories (for example D:\2011\ and D:\2014\). Overlapping orthophotos have same name except the new ones have letter "A" at the end - the old one has name E063462.tif - Band_3 and the new one E063462A.tif - Band_3. The script should find identical orthophotos, load only one band and then run processes as it is shown in picture below. ... View more