Tango.info venue code: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(29 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
[[ | [[Category:Tango.info]] | ||
A | [[Category:Identifier]] | ||
==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. | |||
e.g. ARBUE | [[regex]]: [a-z]{7}[0-9]{3} | ||
*ARBUE-CN - Salon '''C'''a'''n'''ning | |||
*ARBUE-CS - Club '''C'''a'''s'''tel | 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|Salon '''C'''a'''n'''ning]] (https://tango.info/ARBUE-CN) | |||
*ARBUE-CS - Club '''C'''a'''s'''tel (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 |
Latest revision as of 2013-12-21T08:34:14
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