User:Krauss/Lembretes

Outras paginas:

• User:Krauss/QualidadeBR-multipolygons
• ... revisar

Ajuste de imagens

http://www.georeferencer.com/

Exemplos de polígonos brasileiros

• multiplygon com buracos: "faculty Instituto de Ciências Exatas", https://www.openstreetmap.org/relation/3758

osm2pgsql

Em geral `apt` será inutil, precisa construir versao atualizada do zero conforme https://switch2osm.org/manually-building-a-tile-server-16-04-2-lts/

Atual osm2pgsql version 0.96.0 (64 bit id space)

Usando osm2pgsql -E 4326 -c -d pgsnapshot -U postgres -W -H localhost --slim --hstore --extra-attributes brazil-latest.osm.pbf. Faltou indicar numero de CPUs.

Resultado:

Completed planet_osm_polygon
Stopped table: planet_osm_ways in 474s
Osm2pgsql took 2472s overall

osmosis

• Osmosis/PostGIS_Setup
• Osmosis/Examples
• Osmosis/Detailed_Usage_0.46

Overpass

Repostar similar a https://help.openstreetmap.org/questions/19774/how-to-get-bbox-of-city

• https://github.com/mocnik-science/osm-python-tools
  https://help.openstreetmap.org/questions/19774/how-to-get-bbox-of-city/19832
• ...

Simplest get BBOX: [out:json]; (relation["ISO3166-2"="BR-SP"][boundary=administrative];); out bb;

Verificar: http://overpass-turbo.eu/ https://s2.sidewalklabs.com

Jump maps

Testar no Firefox http://dudarev.github.io/mapjumper/

Geo URI

• instalei mas não salta pro OSM, requer software para tratar.. Aparentemente inutil. https://addons.mozilla.org/pt-BR/firefox/addon/geo-uri-handler
• Elefante, parece também nao ser adequado, https://wiki.openstreetmap.org/wiki/Fotomobil.at_OSM_wordpress_plugin

Consultas

Pequeno gist.

-- para Telegram https://t.me/OSMBrasil_Comunidade/36377
select osm_id, tags->'highway'||' '||COALESCE(tags->'bridge','') as highway, 
       st_geohash(ST_PointOnSurface(way),8) as geohash, 
       round(st_length(way,true)/1000.0,1) km  
from planet_osm_roads 
where tags->'name' ilike '%Pan%Nordestina%' 
order by 3;

Importações prefeituras

Unificar e reorganizar:

• https://wiki.openstreetmap.org/wiki/Importa%C3%A7%C3%A3o_de_endere%C3%A7os_do_Brasil
• https://wiki.openstreetmap.org/wiki/WikiProject_Brazil/Importa%C3%A7%C3%B5es/Prefeituras

regras e definicoes

• Key:addr
  • Interpolação ver tb Key:addr#Tags_for_interpolation_ways) e JOSM/Plugins/AddrInterpolation
• ...
• w:House_numbering
• Pt:Import
• Pt:Import/Catalogue/Brazil PMPA Addresses Import

Problemas e solucoes

• CNEFE e [endereços IBGE no openaddresses/issues/4238](https://github.com/openaddresses/openaddresses/issues/4238)