Tango.info venue code: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 12: | Line 12: | ||
== Codes before 2011-09-08 == | == Codes before 2011-09-08 == | ||
e.g. ARBUE, UN/LOCODE for [[Buenos Aires]] (https://tango.info/ARBUE) | e.g. ARBUE, UN/LOCODE for [[Buenos Aires]] (https://tango.info/ARBUE) | ||
*ARBUE-CN - [[Salon Canning|Salon '''C'''a'''n'''ning]] ( | *ARBUE-CN - [[Salon Canning|Salon '''C'''a'''n'''ning]] (https://tango.info/ARBUE-CN) | ||
*ARBUE-CS - Club '''C'''a'''s'''tel ( | *ARBUE-CS - Club '''C'''a'''s'''tel (https://tango.info/ARBUE-CS) | ||
== Duplicates in the old system== | == Duplicates in the old system== |
Revision as of 2012-11-04T10:53:10
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