select '@id', count(*) from network2clean where @id is not null;
select 'abutters', count(*) from network2clean where abutters is not null;
select 'access', count(*) from network2clean where access is not null;
select 'addr_city', count(*) from network2clean where addr_city is not null;
select 'addr_house', count(*) from network2clean where addr_house is not null;
select 'addr_postc', count(*) from network2clean where addr_postc is not null;
select 'addr_stree', count(*) from network2clean where addr_stree is not null;
select 'addr_subur', count(*) from network2clean where addr_subur is not null;
select 'admin_leve', count(*) from network2clean where admin_leve is not null;
select 'alt_name', count(*) from network2clean where alt_name is not null;
select 'amenity', count(*) from network2clean where amenity is not null;
select 'area', count(*) from network2clean where area is not null;
select 'attributio', count(*) from network2clean where attributio is not null;
select 'bicycle', count(*) from network2clean where bicycle is not null;
select 'bridge', count(*) from network2clean where bridge is not null;
select 'bridge_n_1', count(*) from network2clean where bridge_n_1 is not null;
select 'bridge_nam', count(*) from network2clean where bridge_nam is not null;
select 'comment', count(*) from network2clean where comment is not null;
select 'completion', count(*) from network2clean where completion is not null;
select 'constructi', count(*) from network2clean where constructi is not null;
select 'continues', count(*) from network2clean where continues is not null;
select 'created_by', count(*) from network2clean where created_by is not null;
select 'cutting', count(*) from network2clean where cutting is not null;
select 'cycleway', count(*) from network2clean where cycleway is not null;
select 'cycleway_1', count(*) from network2clean where cycleway_1 is not null;
select 'cycleway_l', count(*) from network2clean where cycleway_l is not null;
select 'cycleway_r', count(*) from network2clean where cycleway_r is not null;
select 'destinat_1', count(*) from network2clean where destinat_1 is not null;
select 'destinatio', count(*) from network2clean where destinatio is not null;
select 'embankment', count(*) from network2clean where embankment is not null;
select 'fixme', count(*) from network2clean where fixme is not null;
select 'flood_pron', count(*) from network2clean where flood_pron is not null;
select 'foot', count(*) from network2clean where foot is not null;
select 'ford', count(*) from network2clean where ford is not null;
select 'geom', count(*) from network2clean where geom is not null;
select 'gid', count(*) from network2clean where gid is not null;
select 'goods', count(*) from network2clean where goods is not null;
select 'height', count(*) from network2clean where height is not null;
select 'hgv', count(*) from network2clean where hgv is not null;
select 'highway', count(*) from network2clean where highway is not null;
select 'history', count(*) from network2clean where history is not null;
select 'horse', count(*) from network2clean where horse is not null;
select 'id', count(*) from network2clean where id is not null;
select 'incline', count(*) from network2clean where incline is not null;
select 'int_name', count(*) from network2clean where int_name is not null;
select 'is_in', count(*) from network2clean where is_in is not null;
select 'junction', count(*) from network2clean where junction is not null;
select 'landuse', count(*) from network2clean where landuse is not null;
select 'lanes', count(*) from network2clean where lanes is not null;
select 'lanes_back', count(*) from network2clean where lanes_back is not null;
select 'lanes_bus_', count(*) from network2clean where lanes_bus_ is not null;
select 'lanes_forw', count(*) from network2clean where lanes_forw is not null;
select 'layer', count(*) from network2clean where layer is not null;
select 'lcn', count(*) from network2clean where lcn is not null;
select 'leisure', count(*) from network2clean where leisure is not null;
select 'level', count(*) from network2clean where level is not null;
select 'lit', count(*) from network2clean where lit is not null;
select 'man_made', count(*) from network2clean where man_made is not null;
select 'maxheight', count(*) from network2clean where maxheight is not null;
select 'maxheight_', count(*) from network2clean where maxheight_ is not null;
select 'maxspeed', count(*) from network2clean where maxspeed is not null;
select 'maxspeed_b', count(*) from network2clean where maxspeed_b is not null;
select 'maxspeed_c', count(*) from network2clean where maxspeed_c is not null;
select 'maxspeed_f', count(*) from network2clean where maxspeed_f is not null;
select 'maxspeed_r', count(*) from network2clean where maxspeed_r is not null;
select 'maxspeed_s', count(*) from network2clean where maxspeed_s is not null;
select 'maxweight', count(*) from network2clean where maxweight is not null;
select 'motor_vehi', count(*) from network2clean where motor_vehi is not null;
select 'motorcar', count(*) from network2clean where motorcar is not null;
select 'motorcycle', count(*) from network2clean where motorcycle is not null;
select 'motorroad', count(*) from network2clean where motorroad is not null;
select 'mtb', count(*) from network2clean where mtb is not null;
select 'mtb_name', count(*) from network2clean where mtb_name is not null;
select 'mtb_scale', count(*) from network2clean where mtb_scale is not null;
select 'name', count(*) from network2clean where name is not null;
select 'name_ru', count(*) from network2clean where name_ru is not null;
select 'name_sourc', count(*) from network2clean where name_sourc is not null;
select 'natural', count(*) from network2clean where natural is not null;
select 'network2clean', count(*) from network2clean where network2clean is not null;
select 'noexit', count(*) from network2clean where noexit is not null;
select 'note', count(*) from network2clean where note is not null;
select 'odbl', count(*) from network2clean where odbl is not null;
select 'oneway', count(*) from network2clean where oneway is not null;
select 'operator', count(*) from network2clean where operator is not null;
select 'psv', count(*) from network2clean where psv is not null;
select 'railway', count(*) from network2clean where railway is not null;
select 'rcn', count(*) from network2clean where rcn is not null;
select 'rcn_ref', count(*) from network2clean where rcn_ref is not null;
select 'ref', count(*) from network2clean where ref is not null;
select 'restrict_1', count(*) from network2clean where restrict_1 is not null;
select 'restrictio', count(*) from network2clean where restrictio is not null;
select 'roundabout', count(*) from network2clean where roundabout is not null;
select 'route', count(*) from network2clean where route is not null;
select 'sac_scale', count(*) from network2clean where sac_scale is not null;
select 'segregated', count(*) from network2clean where segregated is not null;
select 'service', count(*) from network2clean where service is not null;
select 'sidewalk', count(*) from network2clean where sidewalk is not null;
select 'smoothness', count(*) from network2clean where smoothness is not null;
select 'source', count(*) from network2clean where source is not null;
select 'source_acc', count(*) from network2clean where source_acc is not null;
select 'source_bri', count(*) from network2clean where source_bri is not null;
select 'source_cyc', count(*) from network2clean where source_cyc is not null;
select 'source_geo', count(*) from network2clean where source_geo is not null;
select 'source_lcn', count(*) from network2clean where source_lcn is not null;
select 'source_m_1', count(*) from network2clean where source_m_1 is not null;
select 'source_max', count(*) from network2clean where source_max is not null;
select 'source_nam', count(*) from network2clean where source_nam is not null;
select 'source_one', count(*) from network2clean where source_one is not null;
select 'source_r_1', count(*) from network2clean where source_r_1 is not null;
select 'source_ref', count(*) from network2clean where source_ref is not null;
select 'source_sur', count(*) from network2clean where source_sur is not null;
select 'surface', count(*) from network2clean where surface is not null;
select 'todo', count(*) from network2clean where todo is not null;
select 'toll', count(*) from network2clean where toll is not null;
select 'tracktype', count(*) from network2clean where tracktype is not null;
select 'traffic_ca', count(*) from network2clean where traffic_ca is not null;
select 'trail_visi', count(*) from network2clean where trail_visi is not null;
select 'tunnel', count(*) from network2clean where tunnel is not null;
select 'turn_lan_1', count(*) from network2clean where turn_lan_1 is not null;
select 'turn_lan_2', count(*) from network2clean where turn_lan_2 is not null;
select 'turn_lanes', count(*) from network2clean where turn_lanes is not null;
select 'type', count(*) from network2clean where type is not null;
select 'undefined', count(*) from network2clean where undefined is not null;
select 'unsigned', count(*) from network2clean where unsigned is not null;
select 'vehicle', count(*) from network2clean where vehicle is not null;
select 'website', count(*) from network2clean where website is not null;
select 'width', count(*) from network2clean where width is not null;