Tango.info venue code: Difference between revisions

From tango.info wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(19 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[category:tango.info]]
[[Category:Tango.info]]
[[category:identifiers]]
[[Category:Identifier]]
A [[tango.info location]] code (venue code) is a [[tango.info code]] composed of a city code, mostly a [[UN/LOCODE]], and a substring, which currently consitsts of two letter.
==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"