Tango.info venue code: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
(Undo revision 21760 by Belmonte (Talk))
No edit summary
 
(23 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[category:identifiers]]
[[Category:Tango.info]]
A t.i location code (venue code) is composed of a city code, mostly a [[UN/LOCODE]], and a substring, which currently consitsts of two letter.
[[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, UN/LOCODE for [[Buenos Aires]] (http://www.tango.info/ARBUE)
[[regex]]: [a-z]{7}[0-9]{3}
*ARBUE-CN - [[Salon Canning|Salon '''C'''a'''n'''ning]] (http://www.tango.info/ARBUE-CN)
 
*ARBUE-CS - Club '''C'''a'''s'''tel (http://www.tango.info/ARBUE-CS)
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)

Duplicates in the old system

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
Retrieved from "https://tango.info/x/wiki/w/index.php?title=Tango.info_venue_code&oldid=61521"