2 585
edições
Linha 101: | Linha 101: | ||
-- select cover_cells_level, count(*) n_municipios from (select isolabel_ext, cover_cells_level, cover from report.v003_osmc_coverage_export WHERE isolabel_ext LIKE 'CO-%-%') tt group by 1 order by 1; | -- select cover_cells_level, count(*) n_municipios from (select isolabel_ext, cover_cells_level, cover from report.v003_osmc_coverage_export WHERE isolabel_ext LIKE 'CO-%-%') tt group by 1 order by 1; | ||
-- COPY (SELECT isolabel_ext, status, cover, overlay FROM report.v003_osmc_coverage_export WHERE isolabel_ext LIKE ' | -- COPY (SELECT isolabel_ext, status, cover, overlay FROM report.v003_osmc_coverage_export WHERE isolabel_ext LIKE 'CO-%-%') TO 'out.csv' CSV HEADER; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
A seguir apenas dois exemplos, [https://afa.codes/CM-CE-Yoko CM-CE-Yoko] (com ''overlay'' no centro urbano) e [https://afa.codes/CM-NO-Dembo Dembo no Norte] (ex. "46B4" cai na área de ''overlay''). | A seguir apenas dois exemplos, [https://afa.codes/CM-CE-Yoko CM-CE-Yoko] (com ''overlay'' no centro urbano) e [https://afa.codes/CM-NO-Dembo Dembo no Norte] (ex. "46B4" cai na área de ''overlay''). |
edições