View source

 SELECT xmlelement(name a, xmlattibutes('/srv/map/'||date||'/' as href)) as date,
               pings, positions, bssids, waypoints, tracks, itracks, media, pmedia, 
               xmlelement(name a, xmlattributes(city_url as href),city_url) as city
   FROM frida.overview
  WHERE date IS NOT NULL