2 391
edições
osmc:Metodologia/Algoritmo SQL: mudanças entre as edições
osmc:Metodologia/Algoritmo SQL (ver código-fonte)
Edição das 07h29min de 3 de junho de 2024
, 3 junho→Sem recorte: sql rev prefix
(add img e SQL) |
m (→Sem recorte: sql rev prefix) |
||
| Linha 260: | Linha 260: | ||
UNION ALL | UNION ALL | ||
SELECT | SELECT 18+(row_number() over()) as gid, | ||
76::bit(10) || (natcod.baseh_to_vbit('0'||lower(code),16)) as cbits, | 76::bit(10) || (natcod.baseh_to_vbit('0'||lower(code),16)) as cbits, | ||
code as b16_label, ' | code as b16_label, | ||
'0'||lower(code) as prefix, | |||
'BR', NULL as bbox, false as is_contained, | |||
NULL as geom, -- st_intersect(geom_BR,geom_cell) | NULL as geom, -- st_intersect(geom_BR,geom_cell) | ||
geom as geom_cell, geom4326 | geom as geom_cell, geom4326 | ||
| Linha 271: | Linha 272: | ||
$f$; | $f$; | ||
COMMENT ON FUNCTION osmc.L0cover_br_geoms() | COMMENT ON FUNCTION osmc.L0cover_br_geoms() | ||
IS 'L0cover BR from configs ingest into osmc.coverage using osmc.l0cover_upsert().' | IS 'L0cover BR from configs ingest (gid<=18) into osmc.coverage using osmc.l0cover_upsert().' | ||
; | ; | ||
</syntaxhighlight> | </syntaxhighlight> | ||