?

Log in

No account? Create an account
Canonicalizing locations from user input - brad's life [entries|archive|friends|userinfo]
Brad Fitzpatrick

[ website | bradfitz.com ]
[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

Canonicalizing locations from user input [Jan. 8th, 2007|08:14 pm]
Brad Fitzpatrick
[Tags|, ]

I've been working on improving (redoing) the LJ directory which hasn't gotten love in ages. The new design is wonderful and the subject of a future post, but I wanted to share this table first:

RU--Москва76190(Moscow)
RU--Moscow70213(Moscow)
RU--70188
RU--Санкт-Петербург14703(Saint Petersburg)
RU--Saint-Petersburg4844(Saint Petersburg)
RU--Питер4614(Saint Petersburg)
RU--SPb4209(Saint Petersburg)
RU--москва3743(Moscow)
RU--Новосибирск2887
RU--Екатеринбург2429
RU--Novosibirsk2345
RU--Moskow2232(Moscow)
RU--СПб2170(Saint Petersburg)
RU--Msk2012(Moscow)
RU--St.Petersburg1866(Saint Petersburg)
RU--St. Petersburg1533(Saint Petersburg)
RU--Нижний Новгород1503
RU--Samara1497
RU--Самара1349
RU--Ростов-на-Дону1214
RU--Челябинск1201
RU--Казань1150
RU--Уфа1057
RU-Moscow-Moscow1055(Moscow)
RU--Иркутск1036
RU-Москва-Москва1033(Moscow)
RU--Воронеж1028
RU--Калининград999
RU--Kazan965
RU--Ufa956
RU--Петербург954(Saint Petersburg)
RU--Красноярск950
RU--Vladivostok936
RU--Краснодар935
RU--Kaliningrad932
RU--Владивосток923
RU--Пермь913
RU--Ekaterinburg898
RU--Perm866
RU--Omsk820

The data for Australia is also bad, but nowhere near this bad.

Clearly some canonicalization is in order! (Don't worry, I'll never change what appears on profile pages.... just how searches are grouped...)
LinkReply

Comments:
From: ex_oru427
2007-01-09 06:02 am (UTC)
спасибо:) теперь с тобой можно немного общаться по русски, я понимаю:)
(Reply) (Thread)
[User Picture]From: thewalkingman
2007-01-09 06:06 am (UTC)
Pinko lover.
(Reply) (Thread)
[User Picture]From: robbat2
2007-01-09 06:13 am (UTC)
Are you over in .ru again or something?
(Reply) (Thread)
[User Picture]From: brad
2007-01-09 08:30 am (UTC)
Nope.
(Reply) (Parent) (Thread)
[User Picture]From: forgers
2007-01-09 08:10 am (UTC)

interesting stats

It doesn't add up to the 700,000 Sup cited! Although big, ЖЖ never felt *so* big. These numbers look about right. Notice the unbelievable centralization -- it's as if NY would exceed all other US cities combined.

I wonder if some GeoIP research is in order! That would be fun. Weigh by frequency, guess "primary" location, see patterns, identify true nomads!
(Reply) (Thread)
[User Picture]From: brad
2007-01-09 08:29 am (UTC)

Re: interesting stats

These are just the people who choose to list themselves in the directory and publish their location info. You can do either, both, or neither.
(Reply) (Parent) (Thread)
[User Picture]From: no_sex_plz
2007-01-09 08:56 am (UTC)

Re: interesting stats

I live in StPete, russia, but chose Futuna Islands as my location. It just sounds much cooler.
(Reply) (Parent) (Thread)
[User Picture]From: mariana_ten
2007-01-09 08:55 am (UTC)
Wow... O.o"
Good luck with all that...
(Reply) (Thread)
From: shell_c
2007-01-09 11:13 am (UTC)
Omsk = Омск
(Reply) (Parent) (Thread)
[User Picture]From: brad
2007-01-09 04:26 pm (UTC)
Новосибирск = Novosibirsk
Екатеринбург = Ekaterinburg
Самара = Samara
....
....
etc
(Reply) (Parent) (Thread)
[User Picture]From: aidan4
2007-01-09 09:30 am (UTC)
Yeah, this was always a problem for me when I was trying to find new friends in Saint-Petersburg :)
(Reply) (Thread)