237
edições
osmc:Metodologia/Algoritmo SQL/Lib/Cpp (ver código-fonte)
Edição das 18h27min de 21 de agosto de 2024
, 21 agostosem sumário de edição
Sem resumo de edição |
Sem resumo de edição |
||
| Linha 6: | Linha 6: | ||
* deinterleaveBitsEven | * deinterleaveBitsEven | ||
* neighbors_raw | * neighbors_raw | ||
Funções para estimar custo em horas, para copiar e colar template do PostGIS (para Afacodes CM): | Funções para estimar custo em horas, para copiar e colar template do PostGIS (para Afacodes CM): | ||
| Linha 15: | Linha 11: | ||
**[https://github.com/postgis/postgis/blob/stable-3.4/postgis/lwgeom_functions_basic.c#L2911 lwgeom_in_geohash] | **[https://github.com/postgis/postgis/blob/stable-3.4/postgis/lwgeom_functions_basic.c#L2911 lwgeom_in_geohash] | ||
**[https://github.com/postgis/postgis/blob/stable-3.4/postgis/postgis.sql.in#L5361 wrap to c++] | **[https://github.com/postgis/postgis/blob/stable-3.4/postgis/postgis.sql.in#L5361 wrap to c++] | ||
* decode CM: https://postgis.net/docs/ST_Box2dFromGeoHash.html | * decode CM: https://postgis.net/docs/ST_Box2dFromGeoHash.html | ||
**[https://github.com/postgis/postgis/blob/stable-3.4/postgis/lwgeom_in_geohash.c#L77 box2d_from_geohash] | **[https://github.com/postgis/postgis/blob/stable-3.4/postgis/lwgeom_in_geohash.c#L77 box2d_from_geohash] | ||
**[https://github.com/postgis/postgis/blob/stable-3.4/postgis/postgis.sql.in#L5379 wrap to c++] | **[https://github.com/postgis/postgis/blob/stable-3.4/postgis/postgis.sql.in#L5379 wrap to c++] | ||
* decode CM: https://postgis.net/docs/ST_GeomFromGeoHash.html | * decode CM: https://postgis.net/docs/ST_GeomFromGeoHash.html | ||
**[https://github.com/postgis/postgis/blob/stable-3.4/postgis/postgis.sql.in#L5386 wrap to c++ box2d_from_geohash] | **[https://github.com/postgis/postgis/blob/stable-3.4/postgis/postgis.sql.in#L5386 wrap to c++ box2d_from_geohash] | ||
* decode CM: https://postgis.net/docs/ST_PointFromGeoHash.html | * decode CM: https://postgis.net/docs/ST_PointFromGeoHash.html | ||
**[https://github.com/postgis/postgis/blob/stable-3.4/postgis/lwgeom_in_geohash.c#L103 lwgeom_in_geohash] | **[https://github.com/postgis/postgis/blob/stable-3.4/postgis/lwgeom_in_geohash.c#L103 lwgeom_in_geohash] | ||
| Linha 32: | Linha 25: | ||
natcod.hiddenBig_to_vBit | * natcod.hiddenBig_to_vBit | ||
* natcod.vBit_to_hiddenBig | |||
natcod.vBit_to_hiddenBig | * grid_cm.cover_to_xy | ||
* grid_cm.cover_to_xy | |||
* osmc.cell_relate (https://github.com/osm-codes/GGeohash/blob/main/src/step03def-lib.sql) | |||
* osmc.neighborsl0 | |||
grid_cm.cover_to_xy | * para as próximas, da uma olhada nas "oficiais" em https://wiki.addressforall.org/doc/osmc:Metodologia/Algoritmo_SQL/Lib#Construtor_do_identificador_cbits | ||
grid_cm.cover_to_xy | |||
osmc.cell_relate (https://github.com/osm-codes/GGeohash/blob/main/src/step03def-lib.sql) | |||
osmc.neighborsl0 | |||
osmc | |||
== Decisões de projeto pendentes == | == Decisões de projeto pendentes == | ||