Daily
From FridaV
SELECT xmlelement(name a, xmlattributes('/srv/map/'||date||'/' as href),to_char(date,'YYYY-MM-DD Dy')) as date,
name,
xmlelement(name a, xmlattributes(frida.data_url(date,vehicle_id) as href),files) as files,
pings, positions, bssids, waypoints, tracks, itracks, media, pmedia,
xmlelement(name a, xmlattributes(city_url as href),px.basename(city_url)) as city
FROM frida.overview_date_vehicle
WHERE date IS NOT NULL
AND date >= date'2004-01-01'
ORDER BY to_char(date,'YYYY-MM-DD Dy') DESC
