- Android botany climate change Data handling Data sources decision support tool forest GIS GIS software GRASS GIS history LibreOffice / OpenOffice Mobile tools Modelling online mapping Open access Operating system QGIS R computing environment research tools Software release Spatialite SQLite statistics tools Ubuntu Uncategorized vegetation
December 2013 M T W T F S S « Sep 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Tag Archives: SQL
Suppose you have a vector layer in your GRASS GIS database and you want to find all duplicate values in one of the columns of the attribute table of that layer? If you are using SQLite or PostgreSQL as the … Continue reading
I wrote before on using concatenate in OpenOffice / LibreOffice and how this alternatively can be done in R using the paste function. You can do the same in SQLite using a query too.
I came across this post by underdark about how to select a random sample from a table in PostgreSQL. You can achieve the same (selecting 1000 random features from a table) in SQLite using something like below:
The problem with copy data from e.g., an excel or calc sheet into an SQLite database (or any database I reckon) is that the data you copy might include an carriage return. I found this out the hard way after … Continue reading