               (SELECT Sum(St_length(way)) / 1000 
                FROM   planet_osm_line 
                WHERE  highway = 'secondary'
-               AND (NAME is NULL OR ref is NULL)
-               AND osm_timestamp > '2015-12-02 19:37:00-08'));  
+               AND (NAME is NULL AND ref is NULL)
+               AND osm_timestamp > '2015-12-02 19:37:00-08'
+               AND osm_id > 0));  
 
 -- km of tertiary roads since post 
 INSERT INTO retrospective 

              (SELECT Sum(St_length(way)) / 1000 
               FROM   planet_osm_line 
               WHERE  highway = 'primary'
               AND (NAME is NULL OR ref is NULL)
               AND osm_timestamp > '2015-12-02 19:37:00-08')); 

-- km of secondary roads since post
INSERT INTO retrospective 

              (SELECT Sum(St_length(way)) / 1000 
               FROM   planet_osm_line 
               WHERE  highway = 'tertiary'
               AND (NAME is NULL AND ref is NULL)
               AND osm_timestamp > '2015-12-02 19:37:00-08'
               AND osm_id > 0));    

-- km of residential roads since post
INSERT INTO retrospective 
