Spatialite Views

creation of a view runnable on spatialite and compliant with qgis:

CREATE VIEW ucs_2013 as
select
    rowid as rowid,
    ucs2007 as ucs2007,
    geometry as geometry
from
    ucs2013;



insert into views_geometry_columns(view_name,view_geometry,view_rowid,f_table_name,f_geometry_column,read_only)
values('ucs_2013','geometry','rowid','_ucs2013','geometry',1);



IS IMPORTANT TO USE THE ALIAS OTHERWISE THE QGIS SPATIALITE PROVIDER COULD WORK BAD
ALSO IS IMPORTANT TO HAVE THE ROWID field available in the view.

How find a text inside all files of a folder

It return the list of files and the lines where the text is founded.

example: fnd all the files where there is the string FILTERITEM (case sensitive)

find . -type f -fprint /dev/stderr -exec cat {} \; | grep FILTERITEM

How decompile zip file in own folders

Using the unzip.exe from GNU-Win.

Is possible to use this script:

for /R D:\DA_FARE\11-lidar\copia-da-j-x-ozon\ORIG %f IN (*.zip) do cd %~df%~pf & c:\my-programs\unzip\unzip.exe -o %f