Activities
Angoca actively collaborates by resolving
notes
Tools
Angoca submits data to OpenStreetMap using
JOSM
Angoca submits data to OpenStreetMap using
MapComplete
Angoca uses
Overpass turbo
, an OSM database search tool, and is willing to advise on it
Angoca uses
OsmAnd
, mobile map viewing & navigation app.
Android logo
Angoca uses an
Android
mobile device.
Angoca is a motorist.
Angoca
is a bicyclist.
Social
Angoca uses
Discord
as
@angoca#0865
Angoca can be contacted by
e-mail
via this wiki.
Angoca has an account on GitHub as
@angoca
Angoca can be found at LinkedIn as
angoca
Interests
I appreciate the work done to develop OSM’s
Data items
and I support their continued use and development.
My main interest in OSM is mapping my birth city,
Bogotá
Colombia
. However, over the years, I have worked on various projects and am still working on some of them, most unrelated to Bogotá or Colombia.
This is the list of things I have done (without any particular order), which are not necessary mapping stuff but related in some way to OpenStreetMap.
Notes
Mapping
I improved the map data where I worked by correcting all related issues. This keeps
my HDYC profile
in good shape.
Bogota
Keep Bogota’s administrative boundaries and postal codes in good shape, including rural vs urban limits, localities, UPZs, and neighborhoods. These are some Overpass Turbo queries to show (and verify) that:
Draw the ciclovías of Bogotá -
This project involved some Kaart mappers:
Juan Melo
on
OSM
and
Jorge Aguirre
on
OSM
. It was a great project because we had to define something new with the current tagging system in OpenStreetMap.
Map the mall
Plaza Norte
, at the north of Bogotá with high detail:
Map fire stations in Bogota.
Map the public transportation system in Bogotá. Initially, the bus stops in the central area.
Colombia
Boundaries
Check the boundaries and coastline of Colombia, as well as the regions and departments.
Waterways
Standardize the name of rivers and streams in Colombia by including the work Río or Quebrada accordingly.
Correct the flow (loops) and connect rivers and streams in Colombia thanks to
Correct the transitions from River to Stream (invalid) using a file from WaterwayMap.
Development
Bogota
Create a local chapter called
MaptimeBogota
to strengthen the community and share knowledge about OSM.
Add the local communities and their social networks to
Participate in several FLISoLs in Bogotá and coordinate the participation of OSM in other cities.
Colombia
Welcome new users by sending a message via
Be part of the
AC3
(Asociación de Cartografía Colaborativa de Colombia) founders, an Association that aims to be the local OSM chapter in Colombia.
Create accounts in the most popular social networks for OSM Colombia.
Define a list of ways to improve the
OSM map in Colombia
Latam
Organize the
State of the Map Latam 2025
, playing the role of Secretary.
To help the organization of the
State of the Map Latam 2024
To help organize
osm.lat
with multiple services on the cloud and locally on my server (geoserver, password vault, pad hedgedoc, forms, blog WordPress, status).
Led the Latam community by inviting other communities to organize bi-monthly virtual meetings.
Organize all wiki pages related to Latam and put them under
ES:LatAm
Interview Colombian and Latam community members as part of the celebration of the 20th years of OSM.
Promote the Welcome tool
in other countries to send customized messages to newcomers.
Wiki
Colombia
Data items and tags
I reviewed the wiki for descriptions of pages and data items -
Category:Data item issues
. I created thousands of pages for Spanish keys and values (tags) and synchronised the description in the Page description with the Data Item. Now, the page
ES:Objetos del mapa
has all entries in Spanish.
Part of the idea to create hundreds of tags comes from
User talk:Maro21
I have made more than 10K changes to the wiki.
Correct the status of all tags (in all languages), keys, and values in this wiki. There were about 2000 edits.
Category:Feature descriptions with incorrect status value
Validate the status spelling in wiki pages by querying the SQLite database from taginfo.
Translations
Tutorials
Photos
As I mentioned, I have started the local chapter of
Maptime in Bogota
. I have already organized some mapping parties by convoking people with
MeetUp
and
Kommunity
to gather data from the field. Due to COVID-19, I have organized virtual events to resolve notes about the city and Colombia in general and integrate the community. These events helped us improve the Colombian part of this wiki by adjusting the documentation and creating new sections on topics not discussed or explained before.
I have collected many SITP bus stops in Bogota and several routes of this transport system. I have created a project based on this freedom to provide a free map for Bogota citizens. It is called
BogoMap
Presentations
OpenStreetMap and Wikimedia: Two worlds full of data telling histories (OpenStreetMap y Wikimedia: Dos mundos llenos de datos que cuentan historias) -
WikiCon Colombia
, Wikimedia Colombia, 2025, Bogotá, Colombia.
OpenStreetMap in Latam - IDE Chile International Conference, 2025, Santiago, Chile.
Indoor and 3D mapping in OpenStreetMap (Mapeo de interiores y 3D en OpenStreetMap) -
State of the Map Latam 2025
, 2025, Medellín, Colombia.
Stop being a newbie in OSM: The many ways you can develop your skills (Dejar de ser un novato en OSM: Los múltiples caminos en los que puedes desarrollar tus habilidades) -
State of the Map Latam 2025
, 2025, Medellín, Colombia.
OpenStreetMap in Latin America and the next State of the Map Latam (OpenStreetMap en América Latina y el próximo State of the Map) -
Taller Datos Abiertos y Mapas Colaborativos: Uniendo Comunidades y Tecnología (IDE uah TomTom)
, 2025, Santiago, Chile.
How to map a basin (
Cómo mapear una cuenca
) - State of the Map Latam 2024 Belém, 2024, Belém, Brazil.
Support of Membership campaign -
Board OpenStreetMap Foundation - OSMF Meeting
, 2024, Colombia, online.
Introduction to OpenStreetMap Notes resolution (Introdução ao OpenStreetMap com resolução de notas (em espanhol)) - UMBRAOSM, 2024, Brazil, online.
OSM Welcome tool to send a welcome message to newbies (Ferramenta de boas-vindas do OpenStreetMap para dar as boas-vindas a novos contribuidores de mapas) - UMBRAOSM, 2024, Brazil, online.
OSM and Wikimedia (OSM y Wikimedia) -
FLISoL Bogotá 2024
, 2024, Bogotá, Colombia.
Improving the map around your house (Mejorando el mapa de tu casa) -
FLISoL Bogotá 2024
, 2024, Bogotá, Colombia.
Making the most of your ActionCam (GoPro) photos (Aprovechando las fotos de tu ActionCam (GoPro)) -
FLISoL Bogotá 2024
, 2024, Bogotá, Colombia.
Purposeful drone flying (Vuelo de drones con propósito) -
FLISoL Bogotá 2024
, 2024, Bogotá, Colombia.
I'm mapping (Mapeando ando) -
FLISoL Cajicá 2024
, 2024, Cajicá, Colombia. With Juan Carlos Melo and Angie Lorena Trujillo.
Educative georeferencing and Open Source Software (Georreferenciación educativa y Software Libre) -
FLISoL San José de Pare 2024
, 2024, San José de Pare, Colombia - Online.
OpenStreetMap, data for life (OpenStreetMap, datos para la vida) - FLISoL Bogotá 2023, 2023, Bogotá, Colombia.
Let's map your house in OpenStreetMap - Workshop (Mapeemos tu casa en OpenStreetMap - Taller) - FLISoL Bogota 2022, 2022, Colombia, online.
Mapping my territory with communities (Mapeando Mi Territorio con Comunidades) - Cátedra Abierta Orlando Fals Borda - OIR UNAD, 2022, Colombia, online.
Profiles
Things To-Do
Check the peaks, if the are located at the top, using "curvas de nivel". And validate the height with the lines - altitude.
Add many entries about Colombia in Name Suggestion Index. Commerce.
Improve the Colombian boundaries - check the limits.
Add municipality boundaries across Colombia, with relations, with label position.
Separate waterways from other objects., specially boundaries.
Fix all Wikipedia and Wikidata entries in Colombia (almost done thanks to Maheusz tool).
Write more levels about LearnOverpass.
Write an article about how to solve OSM notes in LearnOSM (Write it with Pao).
Integrate these reqs with Terranote to create better notes -
Complete the OSM notes profile project.
Create quizes about OSM Colombia. There is one for SotM.
Actualmente, mi principal interés en OSM es mapear mi ciudad natal,
Bogotá
Colombia
. A lo largo de los años he enfocado mis esfuerzos en estos elementos:
Mapear los sistemas de transporte público.
Mantener los límites administrativos y códigos postales de Bogotá.
Mantener las fronteras de Colombia y línea costera, como también las regiones y departamentos.
Resolver notas.
Ajustar las página del wiki y mantener sincronizado la traducción español-ingles.
De manera general mejorar el mapa.
Inicié el capítulo local de
Maptime in Bogota
. He hecho algunas fiestas de mapeo convocando gente por medio de
MeetUp
and
Kommunity
para levantar datos en terreno. Debido al Covid-19, he organizado eventos virutales para resolver notas de la ciudad, y también para integrar la comunidad. Estos eventos han ayudado a mejorar el wiki de la parte colombiana, ajustando la documentación y creando nuevas secciones de temas no discutidos o explicados antes.
También, me preocupo por las direcciones y nombramiento de calles en Colombia, las cuales no siempre se han mapeado correctamente, por lo que he creado un artículo en el wiki como también un desafío en MapRoulette con expresiones regular para corregir esto.
He recolectado muchos paraderos de buses del SITP en Bogotá, al igual que los trayectos de varias rutas de este sistema de transporte. He creado un proyecto basado en esta libertad, el cual busca ofrecer un mapa gratis para los bogotanos. Se llama
BogoMap
Dans ce moment, mon intérêt principal dans OSM est faire du mapping de ma villa de naissance,
Bogotá
Colombia
. Tout au long des années, j'ai concentré mes efforts dans les éléments suivants
Faire du mapping sur les systèmes de transport publique.
Maintenir les limites administratives et des code postaux à Bogota.
Maintenir les frontières et la côte maritime de Colombie, et aussi les régions et départements.
Résoudre des notes.
Ajuster les pages du ás wiki et maintenir synchronisé la traduction espagnol-anglais.
Améliorer de manière général la carte.
J'ai commencé le chapitre local de
Maptime in Bogota
. J'ai organisé de fêtes de mapping en appelant les gens par
MeetUp
et
Kommunity
pour collecter des données sur le terrain. Dû au Covid-19, j'ai commencé à organiser des évènements virtuels pour résoudre des notes de la ville, ainsi intégrer la communauté. Ces évènements ont aidé à améliorer les articles du wiki associé a la Colombie, en ajustant la documentation et en créant des sections de sujets non discuté ou expliqué avant.
Aussi, je suis concerné pour les adresses et le nommage des rues en Colombie, lesquelles ne sont toujours pas bien designer sur la carte. Pour cette raison, j'ai créé un article dans le wiki, ainsi j'ai créé un défi sur MapRoulette avec des expression régulieres pour corriger ceci.
J'ai pris de donnés de arrêts de bus du SITP à Bogota, et aussi certains trajets de routes de ce système de transport. J'ai créé un projet basé sur cette liberté, lequel a pour but fournir une carte gratuite pour les citoyens à Bogota. Il s'appelle
BogoMap
Grupo de usuarios local
MaptimeBogota
Encuentros
Cuándo:
Casi todos los sábados en la mañana
Dónde:
OSM BigBlueButton
mapa
Siguiente:
2021-11-27
Lista de correo
sin lista de correo
Sitio web
maptime.io/bogota
Imagen
Contact
My contact details are on my
OSM profile
Monitoring my areas
This is the way I monitor the areas where I have worked a lot.
Plaza Norte
Prado Veraniego Sur y Atabanza
Nicolás de Federmán
Aguas internacionales de Colombia
Venezuela - Golfo
Nicaragua, Costa Rica - EEZ
Continente América
TagInfo queries
Bajando el siguiente archivo, expandiéndolo y después abriéndolo con sqlite:
-- Quantity of pages per status (spelling difference).
select approval_status, count(*) from wikipages group by approval_status;
-- List of pages for a given spelling status
-- (output Wiki table)
select '|' || lang || '
|' || approval_status || '
|' ||
'https://wiki.openstreetmap.org/w/index.php?title='
|| case lang when 'en' then '' when 'de' then 'DE:' when 'es' then 'ES:' when 'fr' then 'FR:' when 'it' then 'IT:' when 'ja' then 'JA:' when 'nl' then 'NL:' when 'ru' then 'RU:' else UPPER(SUBSTR(lang,1,1)) || LOWER(SUBSTR(lang,2,LENGTH(lang))) || ':' end
||
case tag = key when true then 'Key:' || key else 'Tag:' || key || '%3D' || value end || '&action=edit
','-'
from wikipages
where tag <> key
and approval_status in ('deprecated')
order by approval_status, key, value;
-- List of pages for the same tag in different language with different status
-- (output Wiki table)
select '|' || ot.lang || '
|' || ot.approval_status || '
|' || en.approval_status || '
|' || en.tag || '
|' ||
'https://wiki.openstreetmap.org/w/index.php?title='
|| case ot.lang when 'en' then '' when 'de' then 'DE:' when 'es' then 'ES:' when 'fr' then 'FR:' when 'it' then 'IT:' when 'ja' then 'JA:' when 'nl' then 'NL:' when 'ru' then 'RU:' else UPPER(SUBSTR(ot.lang,1,1)) || LOWER(SUBSTR(ot.lang,2,LENGTH(ot.lang))) || ':' end
||
case en.tag = en.key when true then 'Key:' || ot.key else 'Tag:' || ot.key || '%3D' || ot.value end || '&action=edit
','-'
from wikipages en join wikipages ot
on en.tag = ot.tag
where ot.lang <> 'en'
and en.lang = 'en'
and lower(en.approval_status) <> lower(ot.approval_status)
order by en.approval_status, ot.approval_status, en.tag
Hacer un query que muestre las etiquetas que sean más usadas de 10K y que aún sean in use.
Hacer un query que muestre las etiquetas con de facto y que tengan menos de 10K de uso.