a4a:Convenções/Dados/Export

Openaddresses.io

Conforme git/openaddresses/CONTRIBUTING.md e versão de julho de 2023 de Cartago, podemos importar e exportar:

DROP VIEW IF EXISTS co_marco202307_limpo_cartago_vw
;
CREATE VIEW co_marco202307_limpo_cartago_vw AS 
 SELECT * FROM (
   SELECT house_number AS number,
        via_name AS street,
        NULL as unit,
        lat, lon,
        'Cartago' AS city,
        NULL AS postcode,
        NULL AS district,
        'VC' AS region, -- Valle del Cauca
        geohash9 AS id,
        -- ('01'::bit(2) || natcod.b32ghs_to_vbit(geohash9))::bit(64)::bigint AS id,
        NULL AS addrtype,
        NULL AS notes
   FROM co_marco202307_limpo_fdw
   WHERE NOT(has_dup_address) AND dpto_mpio=76147
 ) t
 ORDER BY id
;

copy (select * from co_marco202307_limpo_cartago_vw) to '/tmp/co202307_cartago_ghs.csv' CSV HEADER;
-- copy (select * from co_marco202307_limpo_cartago_vw) to '/tmp/co202307_cartago_int.csv' CSV HEADER;