               (SELECT Sum(St_length(way)) / 1000 
                FROM   planet_osm_line 
                WHERE  highway = 'tertiary'
-               AND (NAME is NULL OR ref is NULL)));    
+               AND (NAME is NULL AND ref is NULL) AND osm_id > 0));    
 
 -- km of residential roads 
 INSERT INTO retrospective 

VALUES      ( 'secondary_km', 
              (SELECT Sum(St_length(way)) / 1000 
               FROM   planet_osm_line 
               WHERE  highway = 'secondary'));

-- km of secondary roads without names
INSERT INTO retrospective 

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

-- km of secondary roads since post
INSERT INTO retrospective 
