Skip to content

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
;