UMBRAOSM
 Aplicativo GPS 
Aplicativo de GPS Off-line com Openstreetmap.

                 Exemplos Overpass-Turbo

Fonte: Mapeador Tomio: https://docs.google.com/document/d/1U6AdN_4KkZW59Q3jR5S50kUulvGT-LrLlv1zbEQNJjM/edit

 

Consultas Overpass

 

Índice:

 

  1. Lombadas no Brasil (apenas nodes, gera dados csv para criar alertas no Garmin).

 

  1. Lombadas no Brasil (node/way/relation, visualiza no mapa, exporta gpx/kml).

 

  1. Lombadas em uma cidade (identificadas por tipo, apenas nodes, gera dados csv).

 

  1. Pedágios com tarifas no Brasil (apenas nodes, dados em csv, tarifas).

 

  1. Pedágios com tarifas no Brasil (node/way/relation, dados csv, tarifas).

 

  1. Localiza pedágio de determinada cidade (Paraibuna).

 

  1. Milestones (marcos quilométricos) no Brasil, em coordenadas csv.

 

  1. Milestones de uma cidade, com a label do km em cores (node, mapa, gpx, kml).

 

  1. Milestones do Brasil que não tem a tag ref (node, mapa, gpx, kml).

 

  1. Localiza polícias rodoviárias com a tag police=traffic_police (as áreas foram transformadas em center).

 

  1. Localiza marcos km (milestones) nas vias, próximos 30m da tag police=traffic_police.

 

  1. Limite de cidades (traffic_sign=city_limit), consulta para obter name (dados csv).

 

  1. Limite de cidades (city_limit), obtém as coordenadas dos pontos (dados csv).

 

  1. Limite de cidades (city_limit) do Brasil (node/way/relation, mapa, gpx, kml).

 

  1. Radares no Brasil (node/way/relation, mapa, gpx, kml).

 

  1. Radares em Jaraguá do Sul (node/way/relation, mapa, gpx, kml).

 

  1. Radares em Jaraguá, exibe a velocidade do radar com cores e labels (node/way/relation, mapa, gpx, kml).

 

  1. Postos Combustíveis em Jaraguá do Sul, obtém centros geométricos “center” (node/way/relation, mapa, gpx, kml).

 

  1. Consulta muito interessante da Mapbox, com labels e vias em cores diferentes. [estudar como é feita]

 

  1. Estradas rurais de Jaraguá do Sul (node/way/relation, mapa, gpx, kml).

 

  1. Estradas rurais principais de Jaraguá do Sul, com a ref “JGS” (node/way/relation, mapa, gpx, kml).

 

  1. Localiza todas as vias que contenham “JGS” na tag “name” ou “alt_name”.

 

  1. Estacionamentos localizados no raio de 1000m de um ponto estabelecido (node/way, mapa, gpx, kml).

 

  1. Obtém os elementos de uma relação (node/way/relation, mapa, gpx, kml).

 

  1. Obtém as coordenadas dos pontos de uma relação (dados csv).

[usar nos radares]

 

  1. Hidrantes adicionados por determinado usuário (node/way/relation, mapa, gpx, kml).

[emergency=hydrant and user:nnn]

 

  1. Edições de um usuário (user) em Jaraguá do Sul.

 

  1. Pontes de Jaraguá do Sul.

 

  1. Todas as edificações que tem “building:levels” maior que 01 andar.

 

  1. Todas as edificações que tem “building:levels” maior que 01 andar e não são building=house.

 

  1. Totais de comprimentos de vias conforme as superfícies (Jaraguá do Sul).

 

  1. Obtém, visualiza e colore as superfícies das vias (Jaraguá do Sul).

[ bom para aprender sobre styles]

 

  1. Obtém as ruas que não tem a tag “surface” (Jaraguá do Sul).

 

  1. Obtém os dados das vias de Jaraguá do Sul, para usar no UMAP.

 

  1. Obtém vias “unpaved” e colore em vermelho (Jaraguá do Sul).

 

  1. Obtém todas as vias com a “surface=unpaved” (Jaraguá do Sul).

 

  1. Obtém todas as vias com a “surface= paved” (Jaraguá do Sul).

 

  1. Obtém todas as ruas menores que 10 m (width<10) de Jaraguá do Sul.

 

  1. Obtém todas as calçadas menores que 2 m (sidewalk<2) em Jaraguá do Sul.

 

  1. Obtém todas as ruas que não tem a tag de calçada (sidewalk:width) em Jaraguá do Sul.

 

  1. Obtém os comprimentos de vias, conforme a pavimentação, de um bairro (Tifa Monos) de Jaraguá do Sul (usando geocode).

 

  1. Obtém os comprimentos de vias, conforme a pavimentação, de um bairro (Ilha da Figueira) de Jaraguá do Sul (usando area).

 

  1. Localiza todas as servidões do bairro Centro, de Jaraguá do Sul (mapa).

 

  1. Lista pelo nome, todas as servidões do bairro Centro de Jaraguá do Sul.

 

  1. Localiza todas as vias com um determinado nome (Tobias), em Jaraguá do Sul.

 

  1. Lista todas as vias com um determinado nome (Tobias), em Jaraguá do Sul.

 

  1. Lista os “addr:subur” de objetos de um determinado bairro. Serve para verificar se estão cadastrados nos bairros corretos.

 

  1. Lista os “addr:suburb” cadastrados na cidade. Serve para verificar erros de grafia na tag.

 

  1. Obtém todos os cursos de água (waterway=*) sem a tag “name” de Jaraguá do Sul.

 

  1. Obtém os rios (waterway=river) sem a tag “name” de Jaraguá do Sul.

 

  1. Obtém a relação que compõe os limites de um município (São João do Itaperiú). Pode ser usada para conseguir o arquivo gpx/kml do município.

 

******************************************************************************************************

 

  1. Lombadas no Brasil (apenas nodes, gera dados csv para criar alertas no Garmin):

 

http://overpass-turbo.eu/s/vUY

 

[out:csv(::lon,::lat,::type)][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

 

(

  node["traffic_calming"="bump"](area.searchArea);     

  node["traffic_calming"="hump"](area.searchArea);

  node["traffic_calming"="table"](area.searchArea);

);

 

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Lombadas no Brasil (node/way/relation, visualiza no mapa, exporta gpx/kml):

[bump, hump, table, sem yes]

 

http://overpass-turbo.eu/s/HNT

 

[out:json][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

(

  node["traffic_calming"="table"](area.searchArea);

  way["traffic_calming"="table"](area.searchArea);

  relation["traffic_calming"="table"](area.searchArea);

  node["traffic_calming"="hump"](area.searchArea);

  way["traffic_calming"="hump"](area.searchArea);

  relation["traffic_calming"="hump"](area.searchArea);

  node["traffic_calming"="bump"](area.searchArea);

  way["traffic_calming"="bump"](area.searchArea);

  relation["traffic_calming"="bump"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

******************************************************************************************************

 

  1. Lombadas em uma cidade (identificadas por tipo, apenas nodes, gera dados csv):

 

http://overpass-turbo.eu/s/HNN

 

[out:csv(::lat,::lon,"traffic_calming")][timeout:900];

{{geocodeArea:Guaramirim}}->.searchArea;

(

  node["traffic_calming"="bump"](area.searchArea);     

  node["traffic_calming"="hump"](area.searchArea);

  node["traffic_calming"="table"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Pedágios com tarifas no Brasil (apenas nodes, dados em csv, tarifas):

 

http://overpass-turbo.eu/s/HNW

 

[out:csv(::lon,::lat,"charge","barrier",::type,::id)][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

(

  node["barrier"="toll_booth"]["charge"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Pedágios com tarifas no Brasil (node/way/relation, dados csv, tarifas):

 

http://overpass-turbo.eu/s/HNX

 

[out:csv(::lon,::lat,"charge","barrier",::type,::id)][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

(

  node["barrier"="toll_booth"]["charge"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

******************************************************************************************************

 

  1. Localiza pedágio de determinada cidade (Paraibuna):

 

http://overpass-turbo.eu/s/HQi

 

[out:json][timeout:25];

{{geocodeArea:Paraibuna}}->.searchArea;

(

  node["barrier"="toll_booth"](area.searchArea);

  way["barrier"="toll_booth"](area.searchArea);

  relation["barrier"="toll_booth"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Milestones (marcos quilométricos) no Brasil, em coordenadas csv:

 

http://overpass-turbo.eu/s/HO9

 

[out:csv(::lon,::lat,"distance","ref",::type,::id)][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

(

node["highway"="milestone"](area.searchArea);

  );

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Milestones de uma cidade, com a label do km em cores (node, mapa, gpx, kml):

 

http://overpass-turbo.eu/s/HNZ

 

[out:json][timeout:900];

{{geocodeArea:Jaragua do Sul}}->.searchArea;

(

  node["highway"="milestone"](area.searchArea);

  );

out body;

>;

out skel qt;

 

{{style:

 

node[highway]{

  text: distance;

  color:red;

}

}}

 

******************************************************************************************************

 

  1. Milestones do Brasil que não tem a tag ref (node, mapa, gpx, kml):

 

https://overpass-turbo.eu/s/GlS

 

[out:json][timeout:250];

{{geocodeArea:Brasil}}->.searchArea;

(

  node["highway"="milestone"][!"ref"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Localiza polícias rodoviárias com a tag police=traffic_police (as áreas foram transformadas em center):

 

http://overpass-turbo.eu/s/CMw

 

[out:json][timeout:100];

 

{{geocodeArea:brasil}}->.searchArea;

 

(

 node["police"="traffic_police"](area.searchArea);

  way["police"="traffic_police"](area.searchArea);

  relation["police"="traffic_police"](area.searchArea);

);

 

out center;

 

******************************************************************************************************

 

  1. Localiza os marcos km (milestones) nas vias, próximos 30m da tag police=traffic_police:

[faz duas pesquisas e depois cruza os dados]

 

http://overpass-turbo.eu/s/HQf

 

[out:json][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

 

// determine set of police=taffic_police

(

  node[police=traffic_police](area.searchArea);

  way[police=traffic_police](area.searchArea);

  rel[police=traffic_police](area.searchArea);

)->.polices; // put them into the set "polices"

 

// determine set of milestone

(

  node[highway=milestone](area.searchArea);

  way[highway=milestone](area.searchArea);

  rel[highway=milestone](area.searchArea);

)->.miles; // put them into the set "miles"

 

// determine set of milestone proximo police

(

  node.miles(around.polices:30);

  way.miles(around.polices:30);

  rel.miles(around.polices:30);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Limite de cidades (traffic_sign=city_limit), consulta para obter name (dados csv):

 

http://overpass-turbo.eu/s/HOn

 

[out:csv(::lon,::lat,"traffic_sign","name",::type,::id)][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

(

  node["traffic_sign"="city_limit"]["name"](area.searchArea);

  way["traffic_sign"="city_limit"]["name"](area.searchArea);

  relation["traffic_sign"="city_limit"]["name"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Limite de cidades (city_limit), obtém as coordenadas dos pontos (dados csv):

 

http://overpass-turbo.eu/s/AEd

 

[out:csv(::lon,::lat,"name")][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

 

(

  node["traffic_sign"="city_limit"](area.searchArea);     

);

 

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Limite de cidades (city_limit) do Brasil (node/way/relation, mapa, gpx, kml):

 

http://overpass-turbo.eu/s/HOo

 

[out:json][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

(

  node["traffic_sign"="city_limit"]["name"](area.searchArea);

  way["traffic_sign"="city_limit"]["name"](area.searchArea);

  relation["traffic_sign"="city_limit"]["name"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Radares no Brasil (node/way/relation, mapa, gpx, kml):

 

http://overpass-turbo.eu/s/HOq

 

[out:json][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

(

  node["highway"="speed_camera"](area.searchArea);

  way["highway"="speed_camera"](area.searchArea);

  relation["highway"="speed_camera"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Radares em Jaraguá do Sul (node/way/relation, mapa, gpx, kml):

 

http://overpass-turbo.eu/s/HOs

 

[out:json][timeout:25];

{{geocodeArea:Jaragua do Sul}}->.searchArea;

(

  node["highway"="speed_camera"](area.searchArea);

  way["highway"="speed_camera"](area.searchArea);

  relation["highway"="speed_camera"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Radares em Jaraguá, exibe a velocidade do radar com cores e labels (node/way/relation, mapa, gpx, kml):

[boa para fazer a verificação visual e identificar erros]

 

http://overpass-turbo.eu/s/HOt

 

[out:json][timeout:900];

{{geocodeArea:Jaragua do Sul}}->.searchArea;

(

  node["highway"="speed_camera"](area.searchArea);

  way["highway"="speed_camera"](area.searchArea);

  relation["highway"="speed_camera"](area.searchArea);

);

out body;

>;

out skel qt;

 

{{style:

node[maxspeed]{

  text: maxspeed;

  color:green;

}

}}

 

******************************************************************************************************

 

  1. Postos Combustíveis em Jaraguá do Sul (node/way/relation, mapa, gpx, kml):

[transforma áreas/polígonos em centros geométricos “center”]

 

http://overpass-turbo.eu/s/HOv

 

[out:json][timeout:100];

{{geocodeArea:jaragua do sul}}->.searchArea;

(

  node["amenity"="fuel"](area.searchArea);

  way["amenity"="fuel"](area.searchArea);

  relation["amenity"="fuel"](area.searchArea);

);

out center;

 

******************************************************************************************************

 

******************************************************************************************************

 

  1. Consulta muito interessante da Mapbox, com labels e vias em cores diferentes:

[estudar como é feita]

 

http://overpass-turbo.eu/s/wsW

 

/*

This has been generated by the overpass-turbo wizard.

The original search was:

“type=restriction”

*/

[out:json][timeout:300];

// gather results

(

  // query part for: “type=restriction”

  node["highway"="traffic_signals"]({{bbox}});

  node["highway"="motorway_junction"]({{bbox}});

  way["maxspeed"]({{bbox}});

  way["access"]({{bbox}});

  way["destination"]({{bbox}});

  way["lanes"]({{bbox}});

  way[~"^turn:.*$"~"."]({{bbox}});

  relation["type"="restriction"]({{bbox}});

);

// print results

out body;

>;

out skel qt;

 

{{style:

node[highway=traffic_signals]{

  symbol-size:10;

  fill-color:red;

}

 

node[highway=motorway_junction]{

  text: ref;

}

 

way[destination]{

  text: destination;

}

 

way[maxspeed]{

  text: maxspeed;

  color:green;

}

way[access]{

  color:red;

  text: access;

}

way[turn:lanes],way[turn:lanes:forward],way[turn:lanes:backward]{

  color: yellow;

}

}}

 

******************************************************************************************************

 

  1. Estradas rurais de Jaraguá do Sul (node/way/relation, mapa, gpx, kml):

 

http://overpass-turbo.eu/s/ugc

 

/*

This has been generated by the overpass-turbo wizard.

The original search was:

“(highway=unclassified) or (highway=tertiary and ref=*) or (highway=secondary and ref=*) in "Jaragua do Sul"”

*/

[out:json][timeout:25];

// fetch area “Jaragua do Sul” to search in

{{geocodeArea:Jaragua do Sul}}->.searchArea;

// gather results

(

  // query part for: “highway=unclassified”

  node["highway"="unclassified"](area.searchArea);

  way["highway"="unclassified"](area.searchArea);

  relation["highway"="unclassified"](area.searchArea);

  // query part for: “highway=tertiary and ref=*”

  node["highway"="tertiary"]["ref"](area.searchArea);

  way["highway"="tertiary"]["ref"](area.searchArea);

  relation["highway"="tertiary"]["ref"](area.searchArea);

  // query part for: “highway=secondary and ref=*”

  node["highway"="secondary"]["ref"](area.searchArea);

  way["highway"="secondary"]["ref"](area.searchArea);

  relation["highway"="secondary"]["ref"](area.searchArea);

);

// print results

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Estradas rurais principais de Jaraguá do Sul, com a ref “JGS” (node/way/relation, mapa, gpx, kml):

 

http://overpass-turbo.eu/s/uga

 

/*

This has been generated by the overpass-turbo wizard.

The original search was:

“ref~"^JGS*" in "Jaragua do Sul"”

*/

[out:json][timeout:25];

// fetch area “Jaragua do Sul” to search in

{{geocodeArea:Jaragua do Sul}}->.searchArea;

// gather results

(

  // query part for: “ref~/^JGS[…]”

  node["ref"~"^JGS*"](area.searchArea);

  way["ref"~"^JGS*"](area.searchArea);

  relation["ref"~"^JGS*"](area.searchArea);

);

// print results

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Localiza todas as vias que contenham “JGS” na tag name ou alt_name:

[vias rurais de Jaraguá do Sul]

 

https://overpass-turbo.eu/s/HQk

 

[out:json][timeout:25];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["name"~"^JGS*"](area.searchArea);

  way["alt_name"~"^JGS*"](area.searchArea);

 );

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Estacionamentos localizados no raio de 1000m de um ponto estabelecido (node/way, mapa, gpx, kml):

 

http://overpass-turbo.eu/s/HPH

 

(

node

     (around:1000,45.80264, 9.09477)

      ["amenity"="parking"];

way

      (around:1000,45.80264, 9.09477)

      ["amenity"="parking"];

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Obtém os elementos de uma relação (node/way/relation, mapa, gpx, kml):

 

https://overpass-turbo.eu/s/HPL

 

[out:json];relation(2081626);out geom;

 

******************************************************************************************************

 

  1. Obtém as coordenadas dos pontos de uma relação (dados csv):

[usar nos radares]

 

https://gis.stackexchange.com/questions/164333/how-to-plot-a-list-of-points-on-overpass-turbo-openstreetmap

 

https://overpass-turbo.eu/s/HPJ

 

[out:csv(::lat,::lon;false)];

relation(6728746);

>;

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Hidrantes adicionados por determinado usuário (node/way/relation, mapa, gpx, kml):

[emergency=hydrant and user:nnn]

 

https://overpass-turbo.eu/s/ApN

 

[out:json][timeout:25];

{{geocodeArea:Santa Catarina}}->.searchArea;

(

node["emergency"="fire_hydrant"](user:"Tomio")(area.searchArea);

way["emergency"="fire_hydrant"](user:"Tomio")(area.searchArea);

relation["emergency"="fire_hydrant"](user:"Tomio")(area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Edições de um usuário (user) em Jaraguá do Sul:

 

https://overpass-turbo.eu/s/G4p

 

/*

This has been generated by the overpass-turbo wizard.

The original search was:

“user:Rafaelli in "Jaraguá do Sul"”

*/

[out:json][timeout:25];

// fetch area “Jaraguá do Sul” to search in

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

// gather results

(

  // query part for: “user:Rafaelli”

  node(user:"Rafaelli")(area.searchArea);

  way(user:"Rafaelli")(area.searchArea);

  relation(user:"Rafaelli")(area.searchArea);

);

// print results

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Pontes de Jaraguá do Sul:

 

https://overpass-turbo.eu/s/Gm3

 

[out:json][timeout:250];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["bridge"="yes"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]

  (area.searchArea);

  );

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Todas as edificações que tem “building:levels” maior que 01 andar:

 

https://overpass-turbo.eu/s/H10

 

[out:json][timeout:125];

{{geocodeArea:jaraguá do Sul}}->.searchArea;

(

  node["building:levels"](if: t["building:levels"] > 1)(area.searchArea);

  way["building:levels"](if: t["building:levels"] > 1)(area.searchArea);

  relation["building:levels"](if: t["building:levels"] > 1)(area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Todas as edificações que tem “building:levels” maior que 01 andar e não são building=house:

 

https://overpass-turbo.eu/s/H1o

 

[out:json][timeout:125];

{{geocodeArea:jaraguá do Sul}}->.searchArea;

(

  node["building:levels"](if: t["building:levels"] > 1)

  ["building"!="house"]

  (area.searchArea);

  way["building:levels"](if: t["building:levels"] > 1)

  ["building"!="house"]

  (area.searchArea);

  relation["building:levels"](if: t["building:levels"] > 1)

  ["building"!="house"]

  (area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Totais de comprimentos de vias conforme as superfícies (Jaraguá do Sul):

 

Elaborado pelo naoliv, exclui alguns tipos de vias:

https://overpass-turbo.eu/s/FSq  ou

https://overpass-turbo.eu/s/G4l

 

[out:csv(surface,length)];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]["surface"](area.searchArea);

for (t["surface"])

{

   make stat surface=_.val,

       count=count(ways),length=sum(length());

   out;

}

 

******************************************************************************************************

 

  1. Obtém, visualiza e colore as superfícies das vias (Jaraguá do Sul):

[Exclui alguns tipos de vias, bom para aprender sobre styles]

 

Dois tipos de consulta foram feitos:

 

-- Versão definitiva contendo labels/etiquetas com as superfícies:

https://overpass-turbo.eu/s/GDr

 

[out:json][timeout:25];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

   way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]["surface"](area.searchArea);

  );

out body;

>;

out skel qt;

 

{{style:

way[surface=asphalt]{

  color:black;

} 

way[surface=sett]{

  color:green;

}

way[surface=paving_stones]{

  color:red;

}

way[surface=compacted]{

  color:brown;

}  

way[surface=concrete]{

  color:blue;

}

way[surface=paved]{

  color:magenta;

} 

way[surface=unpaved]{

  color:yellow;

}

way[surface]{

  text: surface;

}

}}

 

-- Versão definitiva sem as labels/etiquetas das superfícies:

https://overpass-turbo.eu/s/GDs

 

[out:json][timeout:25];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

   way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]["surface"](area.searchArea);

  );

out body;

>;

out skel qt;

 

{{style:

way[surface=asphalt]{

  color:black;

} 

way[surface=sett]{

  color:green;

}

way[surface=paving_stones]{

  color:red;

}

way[surface=compacted]{

  color:brown;

}  

way[surface=concrete]{

  color:blue;

}

way[surface=paved]{

  color:magenta;

} 

way[surface=unpaved]{

  color:yellow;

}

}}

 

******************************************************************************************************

 

******************************************************************************************************

 

  1. Obtém as ruas que não tem a tag “surface” (Jaraguá do Sul):

[exclui alguns tipos de vias]

 

https://overpass-turbo.eu/s/GlT

 

[out:json][timeout:250];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]

  [!"surface"]

  (area.searchArea);

  );

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Obtém os dados das vias de Jaraguá do Sul, para usar no UMAP:

 

Essa consulta pode ser inserida no Umap e escolhido qual dado quer representar na label, tipo largura da rua, da calçada, tipo de pavimentação,....

 

https://overpass-turbo.eu/s/Gh0

 

[out:json][timeout:25];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

   way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"](area.searchArea);

  );

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Obtém vias “unpaved” e colore em vermelho (Jaraguá do Sul):

[exclui alguns tipos de vias]

 

https://overpass-turbo.eu/s/GhY

 

[out:json][timeout:25];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

   way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]["surface"](area.searchArea);

  );

out body;

>;

out skel qt;

 

{{style:

way[surface=unpaved]{

  color:red;

} 

}}

 

******************************************************************************************************

 

  1. Obtém todas as vias com a “surface=unpaved” (Jaraguá do Sul):

[exclui alguns tipos de vias]

 

https://overpass-turbo.eu/s/GD8

 

[out:json][timeout:25];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]["surface"="unpaved"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Obtém todas as vias com a “surface= paved” (Jaraguá do Sul);

[exclui alguns tipos de vias]

 

https://overpass-turbo.eu/s/GD7

 

[out:json][timeout:25];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]["surface"="paved"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

******************************************************************************************************

 

  1. Obtém todas as ruas menores que 10 m (width<10) de Jaraguá do Sul:

 

https://overpass-turbo.eu/s/GiA

 

[out:json][timeout:125];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["highway"]["width"](if: t["width"] < 10)(area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Obtém todas as calçadas menores que 2 m (sidewalk<2) em Jaraguá do Sul:

 

https://overpass-turbo.eu/s/Gik

 

[out:json][timeout:125];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["highway"]["sidewalk:width"](if: t["sidewalk:width"] < 2)(area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Obtém todas as ruas que não tem a tag de calçada (sidewalk:width) em Jaraguá do Sul:

 

http://overpass-turbo.eu/s/Gm6

 

[out:json][timeout:250];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]

 [!"sidewalk:width"]

  (area.searchArea);

  );

out body;

>;

out skel qt;

 

******************************************************************************************************

******************************************************************************************************

 

  1. Obtém os comprimentos de vias, conforme a pavimentação, de um bairro (Tifa Monos) de Jaraguá do Sul: (usando geocode)

 

https://overpass-turbo.eu/s/HJB

 

[out:csv(surface,length)];

{{geocodeArea:Tifa Monos,Jaraguá do Sul}}->.searchArea;

way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]["surface"](area.searchArea);

for (t["surface"])

{

   make stat surface=_.val,

       count=count(ways),length=sum(length());

   out;

}

 

******************************************************************************************************

 

  1. Obtém os comprimentos de vias, conforme a pavimentação, de um bairro (Ilha da Figueira) de Jaraguá do Sul: (usando area)

 

A pesquisa usando o geocode “Ilha da Figueira” não retornava nenhum resultado. Isso deve-se ao Overpass usar o primeiro resultado de busca do Nominatim. Na pesquisa abaixo, foi preciso usar a área da relação (relation) que continha o bairro. A relação era a 3501795 (bairro Ilha da Figueira) e foi somado 360000000, para identificar como relação no overpass com uso de “area”.

 

https://overpass-turbo.eu/s/HJC

 

[out:csv(surface,length)];

area(3603501795)->.searchArea;

way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]["surface"](area.searchArea);

for (t["surface"])

{

   make stat surface=_.val,

       count=count(ways),length=sum(length());

   out;

}

 

******************************************************************************************************

 

******************************************************************************************************

 

  1. Localiza todas as servidões do bairro Centro, de Jaraguá do Sul:

[name=Servidão…]

 

http://overpass-turbo.eu/s/Gi4

 

[out:json][timeout:25];

{{geocodeArea:centro,jaraguá do sul}}->.searchArea;

(

way["name"~"^Servidão*"](area.searchArea);

  );

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Lista pelo nome, todas as servidões do bairro Centro de Jaraguá do Sul:

[name=Servidão…]

 

http://overpass-turbo.eu/s/Gil

 

[out:csv("name")][timeout:900];

{{geocodeArea:centro,jaraguá do sul}}->.searchArea;

(

way["name"~"^Servidão*"](area.searchArea);

  );

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Localiza todas as vias com um determinado nome (Tobias), em Jaraguá do Sul:

 

http://overpass-turbo.eu/s/HQb

 

[out:json][timeout:25];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

way["name"~"Tobias"](area.searchArea);

  );

out body;

>;

out skel qt;

 

******************************************************************************************************

 

******************************************************************************************************

 

  1. Lista todas as vias com um determinado nome (Tobias), em Jaraguá do Sul:

 

http://overpass-turbo.eu/s/HQd

 

[out:csv("name",::type,::id)][timeout:900];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

way["name"~"Tobias"](area.searchArea);

  );

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Lista os “addr:subur” de objetos de um determinado bairro. Serve para verificar se estão cadastrados nos bairros corretos:

 

http://overpass-turbo.eu/s/HQg

 

[out:csv("addr:suburb",::type,::id)][timeout:900];

{{geocodeArea:São Luís,jaraguá do sul}}->.searchArea;

(

node["addr:suburb"](area.searchArea);

  way["addr:suburb"](area.searchArea);

  relation["addr:suburb"](area.searchArea);

  );

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Lista os “addr:suburb” cadastrados na cidade. Serve para verificar erros de grafia na tag:

[os resultados podem ser copiados para planilha libreoffice, organizados cfe bairros]

 

https://overpass-turbo.eu/s/H9U

 

[out:csv("addr:suburb",::type,::id)][timeout:900];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

node["addr:suburb"](area.searchArea);

  way["addr:suburb"](area.searchArea);

  relation["addr:suburb"](area.searchArea);

  );

out body;

>;

out skel qt;

******************************************************************************************************

 

  1. Obtém todos os cursos de água (waterway=*) sem a tag “name” de Jaraguá do Sul:

 

https://overpass-turbo.eu/s/HZf

 

[out:json][timeout:250];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

   way["waterway"][!"name"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Obtém os rios (waterway=river) sem a tag “name” de Jaraguá do Sul:

 

https://overpass-turbo.eu/s/HZh

 

[out:json][timeout:250];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["waterway"="river"][!"name"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

  1. Obtém a relação que compõe os limites de um municipio (São João do Itaperiú). Pode ser usada para conseguir o arquivo gpx/kml do município:

 

https://overpass-turbo.eu/s/HZr

 

[out:json][timeout:25];

{{geocodeArea:São João do Itaperiú}}->.searchArea;

(

  relation["admin_level"="8"](area.searchArea);

);

out body;

>;

out skel qt;

 

******************************************************************************************************

 

******************************************************************************************************

 

Informações sobre Overpass:

 

https://wiki.openstreetmap.org/wiki/Overpass_API

 

https://wiki.openstreetmap.org/wiki/Overpass_turbo

 

https://wiki.openstreetmap.org/wiki/Overpass_API/Language_Guide

 

https://wiki.openstreetmap.org/wiki/Overpass_turbo#Map

 

https://wiki.openstreetmap.org/wiki/Overpass_turbo/Examples

 

https://wiki.openstreetmap.org/wiki/Overpass_API/Advanced_examples

 

https://wiki.openstreetmap.org/wiki/Overpass_API/Overpass_API_by_Example

 

https://wiki.openstreetmap.org/wiki/Overpass_API/Overpass_QL

 

https://wiki.openstreetmap.org/wiki/Overpass_API/Sparse_Editing

 

https://wiki.openstreetmap.org/wiki/Overpass_turbo/MapCSS

 

https://wiki.openstreetmap.org/wiki/Overpass_API/Overpass_QL#Print_.28out.29

 

Outros exemplos de Overpass e usuários:

 

https://wiki.openstreetmap.org/wiki/Overpass_turbo/Examples/Postal_Codes_Quality_Assurance

 

https://wiki.openstreetmap.org/wiki/Public_transport/Quality_Assurance

 

https://wiki.openstreetmap.org/wiki/User:Soldier_Boy/overpass-turbo

 

https://wiki.openstreetmap.org/wiki/User:CristianCantoro#Overpass_turbo_queries

 

https://wiki.openstreetmap.org/wiki/User:Hanoj/overpass

  • [name]: select only elements that have a name.
  • [highway~"bus_stop|tram_stop"]: select only elements that have a highway tag that contains bus_stop or tram_stop (the meaning of the given regular expression).
  • [name][highway~"bus_stop|tram_stop"]: select only elements that fulfill both conditions.
  • [name][railway~"halt|station|tram_stop"]: select only elements that have a name tag and that have a railway tag which contains halt, station, or tram_stop.
  • [name][highway~"bus_stop|tram_stop"];[name][railway~"halt|station|tram_stop"];: selects all elements that fulfill at least one of the two before listed conditions.

 

Estudar sobre extrair coordenadas de nós de way:

 

https://gis.stackexchange.com/questions/156972/determine-angle-of-street-by-parsing-an-overpass-turbo-output-xml

 

Em estudo:

 

Extração de radares em csv:

 

[out:csv(::lon,::lat,"highway","maxspeed",::type,::id)][timeout:900];

{{geocodeArea:Santa Catarina}}->.searchArea;

(

  node["highway"="speed_camera"](area.searchArea);

  way["highway"="speed_camera"](area.searchArea);

  relation["highway"="speed_camera"](area.searchArea);

);

out body;

>;

out skel qt;

 

(ver também o speed_display)

 

Outro:

 

[out:csv(::lon,::lat,"highway","maxspeed",::type,::id)][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

(

 node["maxspeed"]["highway"](area.searchArea);  

);

out body;

>;

out skel qt;

 

Comprimento das JGS de Jaraguá do Sul, conforme a pavimentação:

 

https://overpass-turbo.eu/s/HUT

 

[out:csv(surface,length)];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["name"~"^JGS*"]["surface"](area.searchArea);

  way["alt_name"~"^JGS*"]["surface"](area.searchArea);

 );

for (t["surface"])

{

   make stat surface=_.val,

       count=count(ways),length=sum(length());

   out;

}

 

Mapa das JGS de Jaraguá do Sul, conforme a pavimentação:

 

https://overpass-turbo.eu/s/HUV

 

[out:json][timeout:25];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

  way["name"~"^JGS*"]["surface"](area.searchArea);

  way["alt_name"~"^JGS*"]["surface"](area.searchArea);

 );

out body;

>;

out skel qt;

 

{{style:

way[surface=asphalt]{

  color:black;

} 

way[surface=sett]{

  color:green;

}

way[surface=paving_stones]{

  color:red;

}

way[surface=compacted]{

  color:brown;

}  

way[surface=concrete]{

  color:blue;

}

way[surface=paved]{

  color:magenta;

} 

way[surface=unpaved]{

  color:yellow;

}

}}

 

Marcos quilométricos (highway=milestone) das rodovias estaduais de Santa Catarina:  [ponto + ref] e label com o km

 

https://overpass-turbo.eu/s/IXn

 

[out:json][timeout:900];

{{geocodeArea:Santa Catarina}}->.searchArea;

(

  node["highway"="milestone"]["ref"~"^SC*"](area.searchArea);

  );

out body;

>;

out skel qt;

 

{{style:

 

node[highway]{

  text: distance;

  color:red;

}

}}

 

Marcos quilométricos (highway=milestone) das rodovias estaduais de Santa Catarina:  [ponto + ref] e sem a label com o km

 

https://overpass-turbo.eu/s/IXo

 

[out:json][timeout:900];

{{geocodeArea:Santa Catarina}}->.searchArea;

(

  node["highway"="milestone"]["ref"~"^SC*"](area.searchArea);

  );

out body;

>;

out skel qt;

 

Marcos quilométricos (highway=milestone) das rodovias estaduais de Santa Catarina que não possuem “ref”:

 

https://overpass-turbo.eu/s/IXq

 

[out:json][timeout:900];

{{geocodeArea:Santa Catarina}}->.searchArea;

(

  node["highway"="milestone"][!"ref"](area.searchArea);

  );

out body;

>;

out skel qt;

 

Marcos quilométricos (highway=milestone) e acessos das rodovias estaduais de Santa Catarina:  [ponto + ref] e sem a label com o km

 

https://overpass-turbo.eu/s/IZ9

 

[out:json][timeout:900];

{{geocodeArea:Santa Catarina}}->.searchArea;

(

  node["highway"="milestone"]["ref"~"^SC*"](area.searchArea);

  node["highway"="milestone"]["description"](area.searchArea);

 

  );

out body;

>;

out skel qt;

 

Consulta para saber as ruas que contém o CEP (postal_code) cadastrado. Serve também para detectar erros.

 

https://overpass-turbo.eu/s/J6Z

 

  [out:csv(::type,::id,postal_code,name,::count)];

  area[name="Jaraguá do Sul"]->.a;

  ( node(area.a)[postal_code];

    way(area.a)[postal_code];

    rel(area.a)[postal_code];

  );

  out;

  out count;

 

Consulta para estudar o padrão usado na way. Gera csv com campos separados por “|”

 

https://overpass-turbo.eu/s/J70

 

/*

This has been generated by the overpass-turbo wizard.

The original search was:

“"andachtsstätte" in essen”

*/

[out:csv("name", "addr:street", "addr:housenumber", "addr:postcode", "addr:city", ::id, ::type, "service_times", "contact:website"; true; "|")][timeout:25];

// fetch area “essen” to search in

{{geocodeArea:essen}}->.searchArea;

// gather results

(

  // query part for: “"andachtsstätte"”

  way["amenity"="place_of_worship"]["denomination"="roman_catholic"]["building"~"church|cathedral"](area.searchArea);

);

// print results

 

out body;

>;

out skel qt;

 

Consulta para ver radares sem velocidade (tag maxspeed):

 

http://overpass-turbo.eu/s/JRm

 

[out:json][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

(

  node["highway"="speed_camera"][!"maxspeed"](area.searchArea);

  way["highway"="speed_camera"][!"maxspeed"](area.searchArea);

  relation["highway"="speed_camera"][!"maxspeed"](area.searchArea);

);

out body;

>;

out skel qt;

 

Em testes:

 

Obter todos os radares separados por velocidade (csv), inclusive sem tag de velocidade:

 

[out:csv(::lat,::lon,"maxspeed",::type,::id)][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

(

  node["highway"="speed_camera"]["maxspeed"="20"](area.searchArea);

  way["highway"="speed_camera"]["maxspeed"="20"](area.searchArea);

  relation["highway"="speed_camera"]["maxspeed"="20"](area.searchArea);

);

out body;

(

  node["highway"="speed_camera"]["maxspeed"="30"](area.searchArea);

  way["highway"="speed_camera"]["maxspeed"="30"](area.searchArea);

  relation["highway"="speed_camera"]["maxspeed"="30"](area.searchArea);

);

out body; 

(

  node["highway"="speed_camera"]["maxspeed"="40"](area.searchArea);

  way["highway"="speed_camera"]["maxspeed"="40"](area.searchArea);

  relation["highway"="speed_camera"]["maxspeed"="40"](area.searchArea);

);

out body;

(

  node["highway"="speed_camera"]["maxspeed"="50"](area.searchArea);

  way["highway"="speed_camera"]["maxspeed"="50"](area.searchArea);

  relation["highway"="speed_camera"]["maxspeed"="50"](area.searchArea);

);

out body; 

(

  node["highway"="speed_camera"]["maxspeed"="60"](area.searchArea);

  way["highway"="speed_camera"]["maxspeed"="60"](area.searchArea);

  relation["highway"="speed_camera"]["maxspeed"="60"](area.searchArea);

);

out body;

(

  node["highway"="speed_camera"]["maxspeed"="70"](area.searchArea);

  way["highway"="speed_camera"]["maxspeed"="70"](area.searchArea);

  relation["highway"="speed_camera"]["maxspeed"="70"](area.searchArea);

);

out body; 

(

  node["highway"="speed_camera"]["maxspeed"="80"](area.searchArea);

  way["highway"="speed_camera"]["maxspeed"="80"](area.searchArea);

  relation["highway"="speed_camera"]["maxspeed"="80"](area.searchArea);

);

out body;

(

  node["highway"="speed_camera"]["maxspeed"="90"](area.searchArea);

  way["highway"="speed_camera"]["maxspeed"="90"](area.searchArea);

  relation["highway"="speed_camera"]["maxspeed"="90"](area.searchArea);

);

out body;

(

  node["highway"="speed_camera"]["maxspeed"="100"](area.searchArea);

  way["highway"="speed_camera"]["maxspeed"="100"](area.searchArea);

  relation["highway"="speed_camera"]["maxspeed"="100"](area.searchArea);

);

out body; 

(

  node["highway"="speed_camera"]["maxspeed"="110"](area.searchArea);

  way["highway"="speed_camera"]["maxspeed"="110"](area.searchArea);

  relation["highway"="speed_camera"]["maxspeed"="110"](area.searchArea);

);

out body;

(

  node["highway"="speed_camera"]["maxspeed"="120"](area.searchArea);

  way["highway"="speed_camera"]["maxspeed"="120"](area.searchArea);

  relation["highway"="speed_camera"]["maxspeed"="120"](area.searchArea);

);

out body;

(

  node["highway"="speed_camera"][!"maxspeed"](area.searchArea);

  way["highway"="speed_camera"][!"maxspeed"](area.searchArea);

  relation["highway"="speed_camera"][!"maxspeed"](area.searchArea);

);

out body;

>;

out skel qt;

 

Sem arquivo csv, apenas visual:

 

http://overpass-turbo.eu/s/JRQ

 

[out:json][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

(

  node["highway"="speed_camera"](area.searchArea);

  way["highway"="speed_camera"](area.searchArea);

  relation["highway"="speed_camera"](area.searchArea);

);

out body;

>;

out skel qt;

 

Marcos quilometricos de SC:

arquivo csv

 

http://overpass-turbo.eu/s/K4z

 

[out:csv(::lon,::lat,"ref","distance","description",::type,::id)][timeout:900];

{{geocodeArea:Santa Catarina}}->.searchArea;

(

  node["highway"="milestone"](area.searchArea);

  );

out body;

>;

out skel qt;

 

Todas as ruas municipais com largura maior de 12.99m (as estruturais de Jgs tem 13m)/tá pegando as servidões tb:

 

https://overpass-turbo.eu/s/KQj

 

[out:json][timeout:125];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["highway"]["width"](if: t["width"] > 12.99)(area.searchArea);

);

out body;

>;

out skel qt;

 

https://overpass-turbo.eu/s/KQk

 

[out:csv("name")][timeout:250];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["highway"]["name"]["width"](if: t["width"] > 12.99)(area.searchArea);

);

out body;

>;

out skel qt;

 

Procura marco km dentro de uma box definida:

 

https://overpass-turbo.eu/s/KQH

 

[out:json][timeout:900];

{{geocodeArea:Santa Catarina}}->.searchArea;

(

  node["highway"="milestone"]["ref"~"^SC*"](-53.857727,-27.418975,-51.803284,-26.203155);

  node["highway"="milestone"]["description"](-53.857727,-27.418975,-51.803284,-26.203155);

);

out body;

>;

out skel qt;

 

A box foi definida usando:

 

http://lxbarth.com/bbox/

 

Use shift + click e arraste sobre o mapa para ter as coordenadas da box

 

PAra obter as mesorregiões catarinenses:

 

https://overpass-turbo.eu/s/KSe

 

[out:json][timeout:250];

{{geocodeArea:Santa Catarina}}->.searchArea;

(

  relation["admin_level"="5"](area.searchArea);

);

out body;

>;

out skel qt;

 

Para obter os marcos km dentro de uma mesorregião catarinense:

 

(mesorregião do oeste catarinense)

https://overpass-turbo.eu/s/KSi

 

[out:json][timeout:900];

{{geocodeArea:mesorregião do oeste catarinense}}->.searchArea;

(

  node["highway"="milestone"]["ref"~"^SC*"](area.searchArea);

  node["highway"="milestone"]["description"](area.searchArea);

 

  );

out body;

>;

out skel qt;

 

mesorregião serrana: https://overpass-turbo.eu/s/KSk

mesorregião do norte catarinense:  https://overpass-turbo.eu/s/KSm

mesorregião do vale do itajaí: https://overpass-turbo.eu/s/KSn

mesorregião da grande florianópolis: https://overpass-turbo.eu/s/KSo

mesorregião do sul catarinense: https://overpass-turbo.eu/s/KSp

mesorregião do oeste catarinense: https://overpass-turbo.eu/s/KSi

 

Para obter a mesorregião do oeste catarinense, apartir de uma relação:

Mesorregião do Oeste Catarinense:

https://overpass-turbo.eu/s/KSv

[out:json];relation(4096471);out geom;

 

Mesorregião do Norte Catarinense:

https://www.openstreetmap.org/relation/3871700

[out:json];relation(3871700);out geom;

 

Mesorregião Serrana:

https://www.openstreetmap.org/relation/4097611

[out:json];relation(4097611);out geom;

 

Mesorregião do Sul Catarinense:

https://www.openstreetmap.org/relation/4097613

[out:json];relation(4097613);out geom;

 

Mesorregião da Grande Florianópolis:

https://www.openstreetmap.org/relation/4097612

[out:json];relation(4097612);out geom;

 

Mesorregião do Vale do Itajaí:

https://www.openstreetmap.org/relation/4097614

[out:json];relation(4097614);out geom;

 

Obtém todos os objetos que possuem addr:city mas o nome é diferente de “Jaraguá do Sul”: (serve para verificar erros de grafia)

 

http://overpass-turbo.eu/s/KWT

 

[out:json][timeout:250];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

  node["addr:city"]["addr:city"!~"Jaraguá do Sul"](area.searchArea);

  way["addr:city"]["addr:city"!~"Jaraguá do Sul"](area.searchArea);

  relation["addr:city"]["addr:city"!~"Jaraguá do Sul"](area.searchArea);

);

out body;

>;

out skel qt;

 

Obtém todos os objetos que possuem addr:suburb mas o nome do bairro está cadastrado errado dentro do limite administrativo bairro: (serve para verificar erros de grafia ou objetos cadastrados em bairros errados):

 

http://overpass-turbo.eu/s/KWU

 

[out:json][timeout:250];

{{geocodeArea:Barra do Rio Cerro,Jaraguá do Sul}}->.searchArea;

(

  node["addr:suburb"]["addr:suburb"!~"Barra do Rio Cerro"](area.searchArea);

  way["addr:suburb"]["addr:suburb"!~"Barra do Rio Cerro"](area.searchArea);

  relation["addr:suburb"]["addr:suburb"!~"Barra do Rio Cerro"](area.searchArea);

);

out body;

>;

out skel qt;

 

pedágios no Estado de São Paulo:

(Nominatim mudou a indexação, chamando primeiro a cidade de São Paulo. A consulta abaixo está chamando apenas a cidade de SP)

 

http://overpass-turbo.eu/s/M0K

 

[out:json][timeout:900];

{{geocodeArea:São Paulo,Brasil}}->.searchArea;

(

  node["barrier"="toll_booth"]["charge"](area.searchArea);

);

out body;

>;

out skel qt;

 

Assim, a consulta de pedágios foi refeita alterando o geocode e forçando achar o estado de SP através do admin_level=4:

 

http://overpass-turbo.eu/s/Md5

 

[out:json][timeout:900];

( area[name="São Paulo"][admin_level=4]; )->.searchArea;

(

  node["barrier"="toll_booth"]["charge"](area.searchArea);

);

out body;

>;

out skel qt;

 

Ficou fácil para achar outros estados como Rio de Janeiro:

 

http://overpass-turbo.eu/s/Md6

 

[out:json][timeout:900];

( area[name="Rio de Janeiro"][admin_level=4]; )->.searchArea;

(

  node["barrier"="toll_booth"]["charge"](area.searchArea);

);

out body;

>;

out skel qt;

 

Testes:

 

[out:json][timeout:900];

( area[name="São Paulo"][admin_level=4]; )->.searchArea;

(

  way["building"="roof"]["layer"="1"]["name"~"^Pedágio*"](area.searchArea);

);

out body;

>;

out;

 

[out:csv("name",::id)][timeout:900];

( area[name="São Paulo"][admin_level=4]; )->.searchArea;

(

  way["building"="roof"]["layer"="1"]["name"~"^Pedágio*"](area.searchArea);

);

out body;

>;

out;

 

PEsquisa das vias de mãos únicas de Jaraguá:

(exclui algumas vias da pesquisa)

 

https://overpass-turbo.eu/s/Mtr

 

[out:json][timeout:100];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

// gather results

(

  way["oneway"="yes"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]

(area.searchArea);

);

out body;

>;

out skel qt;

 

Pesquisa todas as vias com nome “Servidão” e mostra a largura da via e se tem sidewalk cadastrado:

 

http://overpass-turbo.eu/s/OeY

 

[out:csv("name","width","sidewalk",::id)][timeout:900];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

way["name"~"^Servidão*"](area.searchArea);

  );

out meta;

>;

out meta qt;

 

---------------------------------------------------------------------------------------

 

vias sem sidewalk:width

https://overpass-turbo.eu/s/Ofa

 

[out:json][timeout:250];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]

  [!"sidewalk:width"]

  (area.searchArea);

  );

out body;

>;

out skel qt;

 

-----------------------------------------------------------------------------------

vias sem sidewalk

https://overpass-turbo.eu/s/Ofc

 

[out:json][timeout:250];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["highway"]["highway"!~"^(construction|cycleway|footway|path|proposed|service|track)$"]

  [!"sidewalk"]

  (area.searchArea);

  );

out body;

>;

out skel qt;

 

Pedágios de um estado, sem a tag Direction:

 

https://overpass-turbo.eu/s/Ryb

 

[out:json][timeout:250];

{{geocodeArea:Paraná}}->.searchArea;

(

   node["barrier"="toll_booth"][!"direction"](area.searchArea);

);

out body;

>;

out skel qt;

 

Pesquisar pedágios de um estado, sem a tag direction:

http://overpass-turbo.eu/s/Ryh

 

[out:json][timeout:900];

( area[name="São Paulo"][admin_level=4]; )->.searchArea;

(

  node["barrier"="toll_booth"]["charge"][!"direction"](area.searchArea);

);

out body;

>;

out skel qt;

 

Pedágios do Brasil sem direction:

 

http://overpass-turbo.eu/s/Ryi

 

[out:json][timeout:900];

( area[name="Brasil"][admin_level=2]; )->.searchArea;

(

  node["barrier"="toll_booth"]["charge"][!"direction"](area.searchArea);

);

out body;

>;

out skel qt;

 

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

 

Pedágios do Brasil, sem a tag direction, em vias de mão única:

 

https://overpass-turbo.eu/s/RH9

 

area[name="Brasil"]->.a;

node["barrier"="toll_booth"][!"direction"](area.a);

way(bn)["highway"]["oneway"="yes"];

node(w)["barrier"="toll_booth"][!"direction"];

out skel;

 

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

 

Pedágios do Brasil, sem a tag direction, em vias de mão dupla:

(sem a tag oneway, mas também não pega as tag oneway=no)

 

https://overpass-turbo.eu/s/RHc

 

area[name="Brasil"]->.a;

node["barrier"="toll_booth"][!"direction"](area.a);

way(bn)["highway"][!"oneway"];

node(w)["barrier"="toll_booth"][!"direction"];

out skel;

 

Precisa fazer um k-v pra tirar as oneway=yes de todas as outras vias (oneway=*) ou incluir (oneway=no) para pesquisar

 

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

 

Pedágios do Brasil, que tem um telhado (building=roof) no entorno de 30m:

 

http://overpass-turbo.eu/s/110X

 

[out:json][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

 

// localiza os pontos de pedagios

(

  node[barrier=toll_booth][charge](area.searchArea);

)->.pedag;

 

// localiza os telhados proximos 30m de pontos de pedagios

(

  node[building=roof](around.pedag:30);

  way[building=roof](around.pedag:30);

);

 

out body;

>;

out skel qt;

 

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

 

´pontos de pedágios do brasil:

 

http://overpass-turbo.eu/s/110Y

 

[out:json][timeout:900];

{{geocodeArea:Brasil}}->.searchArea;

 

// localiza os pontos de pedagios

(

  node[barrier=toll_booth][charge](area.searchArea);

);

 

out body;

>;

out skel qt;

 

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

 

** Ruas residenciais e coletoras que não tem a superfície de asfalto:

https://overpass-turbo.eu/s/1ouO

 

[out:json][timeout:250];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

way["highway"="residential"]["surface"!~"asphalt"](area.searchArea);

way["highway"="tertiary"]["surface"!~"asphalt"](area.searchArea);

);

out body;

>;

out skel qt;

 

*** Listagem das estradas rurais principais (tertiary, secondary e primary) e das estradas rurais secundárias (unclassifield), classificadas conforme Plano Diretor:

 

https://overpass-turbo.eu/s/1qUt

 

[out:csv(name,alt_name,highway,surface,width,"sidewalk:width",::id)];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

  way["name"~"^JGS*"](area.searchArea);

  way["alt_name"~"^JGS*"](area.searchArea);

 );

out meta;

 

*** Mapas das Ruas de Jaraguá do Sul, conforme a pavimentação:

 

https://overpass-turbo.eu/s/1qUj

 

[out:json][timeout:250];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

  way["name"~"^Rua*"]["surface"](area.searchArea);

  way["alt_name"~"^Rua*"]["surface"](area.searchArea);

 );

out body;

>;

out skel qt;

 

{{style:

way[surface=asphalt]{

  color:black;

} 

way[surface=sett]{

  color:green;

}

way[surface=paving_stones]{

  color:red;

}

way[surface=compacted]{

  color:brown;

}  

way[surface=concrete]{

  color:blue;

}

way[surface=paved]{

  color:magenta;

} 

way[surface=unpaved]{

  color:yellow;

}

}}

 

*** consulta overpass excelente, para checar check_date por ano de cadastro e com cores, dentro de uma box:

https://overpass-turbo.eu/s/1l1x

 

[out:json][timeout:25];

nwr({{bbox}})[check_date]->.temp;

.temp out body;

.temp >;

out skel;               

 

node.temp;

convert node

  ::id=id(), 

  older0=date(t["check_date"])<date("{{date}}"),                                     

  older365=date(t["check_date"])<date("{{date:365days}}"),

  older2y=date(t["check_date"])<date("{{date:2years}}"),

  older4y=date(t["check_date"])<date("{{date:4years}}")

;

out;

 

way.temp;

convert way

  ::id=id(),

  older0=date(t["check_date"])<date("{{date}}"),                                     

  older365=date(t["check_date"])<date("{{date:365days}}"),

  older2y=date(t["check_date"])<date("{{date:2years}}"),

  older4y=date(t["check_date"])<date("{{date:4years}}")

;

out;

 

rel.temp;

convert relation

  ::id=id(), 

  older0=date(t["check_date"])<date("{{date}}"),                                     

  older365=date(t["check_date"])<date("{{date:365days}}"),

  older2y=date(t["check_date"])<date("{{date:2years}}"),

  older4y=date(t["check_date"])<date("{{date:4years}}")

;              

out;                                     

 

{{style:

 

node,way{

  width:0;

  fill-opacity:0;

  }

       

node[check_date], way[check_date], relation[check_date] way {

  color: blue;

  width: 10;

  }

        

node[older0=1],way[older0=1], relation[older0=1] way{

  color: green;

  }

        

node[older365=1],way[older365=1], relation[older365=1] way{

  color: yellow;

  }

 

node[older2y=1],way[older2y=1], relation[older2y=1] way{

  color: orange;

  }

 

node[older4y=1],way[older4y=1], relation[older4y=1] way{

  color: red;

  }

 

}}

 

*** Vias sem pavimentação em jgs:

 

 https://overpass-turbo.eu/s/1sI9

 

https://overpass-turbo.eu/s/1sIb

 

*** Vias sem asfalto:

 

[out:json][timeout:250];

{{geocodeArea:Jaraguá do Sul}}->.searchArea;

(

way["highway"="residential"]["surface"!~"asphalt"](area.searchArea);

way["highway"="tertiary"]["surface"!~"asphalt"](area.searchArea);

);

out body;

>;

out skel qt;

 

[out:json][timeout:125];

{{geocodeArea:jaraguá do sul}}->.searchArea;

(

   way["highway"]["highway"!~"^(living_street|construction|cycleway|footway|path|proposed|service|track)$"]["surface"="compacted"](area.searchArea);

   way["highway"]["highway"!~"^(living_street|construction|cycleway|footway|path|proposed|service|track)$"]["surface"="unpaved"](area.searchArea);

  );

out body;

>;

out skel qt;

 

{{style:

way[surface=compacted]{

  color:red;

} 

way[surface=unpaved]{

  color:red;

}

}}

 

** vias com tag “paved”:

 

https://overpass-turbo.eu/s/1uyN

 

 

=== Consulta de Vilas ===

[out:json][timeout:25];
// fetch area “Recife” to search in
{{geocodeArea:Pernambuco}}->.searchArea;
// gather results
(
  // query part for: “amenity=place_of_worship”
  node[“place”=”village”](area.searchArea);
  way[“placeplace”=”village”](area.searchArea);
  relation[“place”=”village”](area.searchArea);
);
// print results
out body;
>;
out skel qt;

===============================================

Consulta Bbox - Rua sem Nome

[out:xml]/*fixed by auto repair*/[timeout:250];

( 

way["highway"="residential"]["name"!~"."]({{bbox}});

);

out meta;/*fixed by auto repair*/

>;

out meta qt;/*fixed by auto repair*/

 

https://overpass-turbo.eu/s/1nEA

====================================================

Consulta de Abreviação de Nomes de Ruas. 

 

/*

Pesquisa de abreviacoes no OSM. Gera pontos geograficos no mapa.

*/

[out:json][timeout:900];

{{geocodeArea:Pernambuco}}->.searchArea;

(

  // Enderecos

  way[highway][“name”~”^Av\\.”,i](area.searchArea);

  way[highway][“name”~”^Al\\.”,i](area.searchArea);

  way[highway][“name”~”^R\\.”,i](area.searchArea);

  way[highway][“name”~”Tr\\.”,i](area.searchArea);

  way[highway][“name”~”Tv\\.”,i](area.searchArea);

  way[highway][“name”~”Tra\\.”,i](area.searchArea);

  way[highway][“name”~”Trav\\.”,i](area.searchArea);

  way[highway][“name”~”Pç\\.”,i](area.searchArea);

  way[highway][“name”~”Pça\\.”,i](area.searchArea);

  way[highway][“name”~”Estr\\.”,i](area.searchArea);

  way[highway][“name”~”Serv\\.”,i](area.searchArea);

  way[highway][“name”~”Jd\\.”,i](area.searchArea);

  way[highway][“name”~”Lot\\.”,i](area.searchArea);

  way[highway][“name”~”Bal\\.”,i](area.searchArea);

  way[highway][“name”~”Mun\\.”,i](area.searchArea);

  way[highway][“name”~”Pte\\.”,i](area.searchArea);

  way[highway][“name”~”Rod\\.”,i](area.searchArea);

 

  // Profissoes

  way[highway][“name”~”Dr\\.”,i](area.searchArea);

  way[highway][“name”~”Dra\\.”,i](area.searchArea);

  way[highway][“name”~”Prof\\.”,i](area.searchArea);

  way[highway][“name”~”Profa\\.”,i](area.searchArea);

  way[highway][“name”~”Eng.\\.”,i](area.searchArea);

  way[highway][“name”~”Arq.\\.”,i](area.searchArea);

  way[highway][“name”~”Jorn.\\.”,i](area.searchArea);

  way[highway][“name”~”Med.\\.”,i](area.searchArea);

 

  // Religiosos

  way[highway][“name”~”Pe\\.”,i](area.searchArea);

  way[highway][“name”~”Con\\.”,i](area.searchArea);

  way[highway][“name”~”Ma\\.”,i](area.searchArea);

  way[highway][“name”~”Rev\\.”,i](area.searchArea);

  way[highway][“name”~”Mons\\.”,i](area.searchArea);

  way[highway][“name”~”St\\.”,i](area.searchArea);

  way[highway][“name”~”Sto\\.”,i](area.searchArea);

  way[highway][“name”~”Sta\\.”,i](area.searchArea);

 

  // Militares

  way[highway][“name”~”Mal\\.”,i](area.searchArea);

  way[highway][“name”~”Gen\\.”,i](area.searchArea);

  way[highway][“name”~”Gal\\.”,i](area.searchArea);

  way[highway][“name”~”Cel\\.”,i](area.searchArea);

  way[highway][“name”~”Alm\\.”,i](area.searchArea);

  way[highway][“name”~”Cap\\.”,i](area.searchArea);

  way[highway][“name”~”Capt\\.”,i](area.searchArea);

  way[highway][“name”~”Comte\\.”,i](area.searchArea);

  way[highway][“name”~”Com\\.”,i](area.searchArea);

  way[highway][“name”~”Col\\.”,i](area.searchArea);

  way[highway][“name”~”Cel\\.”,i](area.searchArea);

  way[highway][“name”~”Brig\\.”,i](area.searchArea);

  way[highway][“name”~”Ten\\.”,i](area.searchArea);

  way[highway][“name”~”Sgt\\.”,i](area.searchArea);

  way[highway][“name”~”Sarg\\.”,i](area.searchArea);

  way[highway][“name”~”Exp\\.”,i](area.searchArea);

 

  // Administrativos

  way[highway][“name”~”Pres\\.”,i](area.searchArea);

  way[highway][“name”~”Presid\\.”,i](area.searchArea);

  way[highway][“name”~”Gov\\.”,i](area.searchArea);

  way[highway][“name”~”Pref\\.”,i](area.searchArea);

  way[highway][“name”~”Ver\\.”,i](area.searchArea);

  way[highway][“name”~”Dep\\.”,i](area.searchArea);

  way[highway][“name”~”Min\\.”,i](area.searchArea);

  way[highway][“name”~”Des\\.”,i](area.searchArea);

  way[highway][“name”~”Cons\\.”,i](area.searchArea);

 

  // Tratamento

  way[highway][“name”~”Sr\\.”,i](area.searchArea);

  way[highway][“name”~”Sra\\.”,i](area.searchArea);

 

  // Diversos

  way[highway][“name”~”º”](area.searchArea);

  way[highway][“name”~”ª”](area.searchArea);

  way[highway][“name”~”°”](area.searchArea);

);

out body;

>;

out skel qt;

===================================================================

Seleciona as vias sem nome no raio de 2km, das cidades menores que 10k hab

 

[out:json][timeout:125];

{{geocodeArea:Pará BR}}->.searchArea;

 

// determina as cidades com populacao menor que 10k hab

(

  node["place"="town"]["population"](if: t["population"] < 10000)(area.searchArea);

)->.cidades;

 

// determina as vias sem nome

(

way[highway][!"name"](area.searchArea);

)->.viassemnome;

 

// seleciona as vias sem nome no raio de 2km, das cidades menores que 10k hab

(

  node.viassemnome(around.cidades:2000);

  way.viassemnome(around.cidades:2000);

  rel.viassemnome(around.cidades:2000);

);

 

out body;

>;

out skel qt;


https://overpass-turbo.eu/s/1nEF  

 

Fonte: Google Drive com  arquivos do Over-pass - Tomio.

https://docs.google.com/document/d/1U6AdN_4KkZW59Q3jR5S50kUulvGT-LrLlv1zbEQNJjM/edit

OSMAND_1