Esercizio timemanager
4
Thu Oct 16 00:19:13 +0000 2014 > 20141016 00:19:13 (Ymd HH:MM:SS) SELECT idt, geom, "ID", "ID_TWEET", "DATA", "GEO_LATY", "GEO_LONGX", "GEO_SORGENTE", "GEO_ARGOMENTO", "GEO_KEY", "GEO_FRAME", '2014' || CASE WHEN substring("DATA" from 5 for 3)='Oct' THEN '10' WHEN substring("DATA" from 5 for 3)='Nov' THEN '11' ELSE '12' END || '' || substring("DATA" from 9 for 2) || ' ' || substring("DATA" from 12 for 8) as data_time_manager, '2014' || CASE WHEN substring("DATA" from 5 for 3)='Oct' THEN '10' WHEN substring("DATA" from 5 for 3)='Nov' THEN '11' ELSE '12' END || '' || substring("DATA" from 9 for 2) || ' ' || CASE WHEN char_length((substring("DATA" from 12 for 2)::double precision + 6)::text) = 2 THEN ((substring("DATA" from 12 for 2)::double precision + 6)::text) ELSE '0' || (substring("DATA" from 12 for 2)::double precision + 6) END ||
-
Upload
city-planner-it -
Category
Software
-
view
83 -
download
1
Transcript of Esercizio timemanager
Thu Oct 16 00:19:13 +0000 2014 > 20141016 00:19:13 (Ymd HH:MM:SS) SELECT idt, geom, "ID", "ID_TWEET", "DATA", "GEO_LATY", "GEO_LONGX", "GEO_SORGENTE", "GEO_ARGOMENTO", "GEO_KEY", "GEO_FRAME",
'2014' || CASE
WHEN substring("DATA" from 5 for 3)='Oct' THEN '10' WHEN substring("DATA" from 5 for 3)='Nov' THEN '11' ELSE '12'
END || '' || substring("DATA" from 9 for 2) || ' ' || substring("DATA" from 12 for 8) as data_time_manager, '2014' || CASE
WHEN substring("DATA" from 5 for 3)='Oct' THEN '10' WHEN substring("DATA" from 5 for 3)='Nov' THEN '11' ELSE '12'
END || '' || substring("DATA" from 9 for 2) || ' ' || CASE
WHEN char_length((substring("DATA" from 12 for 2)::double precision + 6)::text) = 2 THEN ((substring("DATA" from 12 for 2)::double precision + 6)::text)
ELSE '0' || (substring("DATA" from 12 for 2)::double precision + 6) END ||
substring("DATA" from 14 for 3)|| substring("DATA" from 17 for 3)
as data_time_manager_end
FROM "pt_twitter04u_GEO" LIMIT 100
ffmpeg framerate 1/5 i /home/pjh/Scrivania/video/ren/frame%03d.png c:v libx264 r 30 pix_fmt yuv420p /home/pjh/Scrivania/video/ren/out.mp4
