Tango.info venue code
(Redirected from Tango.info location code)
Jump to navigation
Jump to search
Overview
A tango.info venue code (formerly location code) is a tango.info object code composed of a city code, mostly a lower case representation of a UN/LOCODE, and a substring, consisting of two letters and 3 numbers.
regex: [a-z]{7}[0-9]{3}
e.g. deberms001, deberms002
- city by UN/LOCODE: DEBER, lower case: deber
- venue 2-char short code: MS, lower case ms
- serial number: 001, 002
Codes before 2011-09-08
e.g. ARBUE, UN/LOCODE for Buenos Aires (https://tango.info/ARBUE)
- ARBUE-CN - Salon Canning (https://tango.info/ARBUE-CN)
- ARBUE-CS - Club Castel (https://tango.info/ARBUE-CS)
Duplicates in the old system
- DEBER-BL https://tango.info/deberbl001 https://tango.info/deberbl002
- Gasthaus Babel, Belle Etage
- DEBER-BP https://tango.info/deberbp001 https://tango.info/deberbp002
- new address in 2011
- DEBER-MS https://tango.info/deberms001 https://tango.info/deberms002
- address change
- DEBER-OB https://tango.info/deberob001 https://tango.info/deberob002
- name change in ??
- DEBER-RW https://tango.info/deberrw001 https://tango.info/deberrw002
- room change
- DEBER-VV https://tango.info/debervv001 https://tango.info/debervv002
- one address until 2009
SQL - Find wiki articles with an old code
SELECT page_id, page_title, page_is_redirect FROM mul_page WHERE 1 AND page_namespace = 0 AND mul_page.page_title RLIKE '_[A-Z]{5}-[A-Z]{2}_' AND page_is_redirect = 0 ORDER BY page_title