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

              (SELECT Sum(St_length(way)) / 1000 
               FROM   planet_osm_line 
               WHERE  highway = 'tertiary'
               AND (NAME is NULL OR ref is NULL)));    

-- km of residential roads 
INSERT INTO retrospective 

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

-- km of motorways without names since post
INSERT INTO retrospective 
