-
Notifications
You must be signed in to change notification settings - Fork 2
Get CSV and analyse
Peter edited this page Aug 7, 2018
·
1 revision
--- Get a csv ---
create table wdosm.GE_noWdId (
osm_type char,osm_id bigint, wd_member_ids text
);
copy wdosm.GE_noWdId from '/tmp/GE_noWdId.csv' CSV HEADER;
--- Suspects heuristic1 ---
with t as (
select osm_type,osm_id, wdosm.wd_id_unformat(wd_member_ids) as members
from wdosm.ge_nowdid
) select wdosm.osm_link(osm_id,osm_type)
from t
where jsonb_int_maxval(members)>3 and jsonb_object_length(members)=1
;