D-Net

COPY grid_institutes    (grid_id,name,wikipedia_url,email_address,established) FROM '/Users/michele/Develop/dnet45/dnet-orgs-database-application/data/grid-2019-05-06/full_tables/institutes.csv' CSV HEADER;

COPY grid_geonames      (geonames_city_id,city,nuts_level1_code,nuts_level1_name,nuts_level2_code,nuts_level2_name,nuts_level3_code,nuts_level3_name,geonames_admin1_code,geonames_admin1_name,geonames_admin1_ascii_name,geonames_admin2_code,geonames_admin2_name,geonames_admin2_ascii_name) FROM '/Users/michele/Develop/dnet45/dnet-orgs-database-application/data/grid-2019-05-06/full_tables/geonames.csv' CSV HEADER;

COPY grid_addresses     (grid_id,line_1,line_2,line_3,lat,lng,postcode,is_primary,city,state,state_code,country,country_code,geonames_city_id) FROM '/Users/michele/Develop/dnet45/dnet-orgs-database-application/data/grid-2019-05-06/full_tables/addresses.csv' CSV HEADER;

COPY grid_relationships (grid_id,relationship_type,related_grid_id) FROM '/Users/michele/Develop/dnet45/dnet-orgs-database-application/data/grid-2019-05-06/full_tables/relationships.csv' CSV HEADER;

INSERT INTO organizations(id, name, lat, lng, city, country, source) (SELECT 'openaire____::'||md5(o.grid_id), o.name, a.lat, a.lng, a.city, a.country_code, 'grid.ac' FROM grid_institutes o LEFT OUTER JOIN grid_addresses a ON (o.grid_id=a.grid_id)) ON CONFLICT DO NOTHING;

INSERT INTO other_ids    (id, otherid, type)                         (SELECT 'openaire____::'||md5(grid_id), grid_id,     'grid.ac'                                    FROM grid_institutes   ) ON CONFLICT DO NOTHING;

INSERT INTO other_ids    (id, otherid, type)                         (SELECT 'openaire____::'||md5(grid_id), external_id, external_id_type                             FROM grid_external_ids ) ON CONFLICT DO NOTHING;

INSERT INTO relationships(id1, reltype, id2)                         (SELECT 'openaire____::'||md5(grid_id), relationship_type, 'openaire____::'||md5(related_grid_id) FROM grid_relationships) ON CONFLICT DO NOTHING;

INSERT INTO types        (id, type)                                  (SELECT 'openaire____::'||md5(grid_id), type                                                      FROM grid_types        ) ON CONFLICT DO NOTHING;

INSERT INTO urls         (id, url)                                   (SELECT 'openaire____::'||md5(grid_id), link                                                      FROM grid_links        ) ON CONFLICT DO NOTHING;