|
Rank: Advanced Member
Joined: 2/14/2008 Posts: 37 Points: 32
|
suggest: locale=Chatenay-Malabry city=Paris
|
|
Rank: Member
Joined: 5/20/2008 Posts: 20 Points: 60
|
The city is "Châtenay-Malabry", it's downsouth from Paris. Your Overlord is right !
|
|
Rank: Administration
Joined: 2/10/2008 Posts: 336 Points: 1,027
|
Great stuff guys. I'll take a look at all of these threads. One of the things that I will be putting in a future build(probably the next one) will be metropolitan areas of cities. That way all of the little places around London, Paris, New York, Los Angeles, etc... will still be filterable by the larger city name.
|
|
Rank: Member
Joined: 5/20/2008 Posts: 20 Points: 60
|
Your Overlord wrote:One of the things that I will be putting in a future build(probably the next one) will be metropolitan areas of cities. That way all of the little places around London, Paris, New York, Los Angeles, etc... will still be filterable by the larger city name. Nice !
|
|
Rank: Advanced Member
Joined: 2/14/2008 Posts: 37 Points: 32
|
ssellers wrote:The city is "Châtenay-Malabry", it's downsouth from Paris. Your Overlord is right ! Well I know I should defer to ssellers but... isn't it this place http://en.wikipedia.org/wiki/Ch%C3%A2tenay-Malabry ? Now maybe it is formally a city, by whatever definition, but for London at least YO was using the metropolitan area of London to cover "City" in the database e.g. shows in the City of Westminster, are nevertheless given London as the City
|
|
Rank: Administration
Joined: 2/10/2008 Posts: 336 Points: 1,027
|
Treadmore wrote:ssellers wrote:The city is "Châtenay-Malabry", it's downsouth from Paris. Your Overlord is right ! Well I know I should defer to ssellers but... isn't it this place http://en.wikipedia.org/wiki/Ch%C3%A2tenay-Malabry ? Now maybe it is formally a city, by whatever definition, but for London at least YO was using the metropolitan area of London to cover "City" in the database e.g. shows in the City of Westminster, are nevertheless given London as the City I am actually no longer doing that on purpose. You were one of the people who convinced me that I should be more accurate with the city names. Mikezep61 convinced me that I should be more accurate on whether a given date is disputed or not. Many of the choices that I made early in the project were made basically to solve a problem that I had at the time, or to preserve something that I originally wanted in the project, like being able to sort on Cityname. I am going to transfer that ability to sorting on metropolitan area as a way of preserving that feature, and use the more specific name for the cityname to be as accurate as possible. If Westminster is its own city then I would like to make that the city name. Which show is in Westminster?
|
|
Rank: Administration
Joined: 2/10/2008 Posts: 336 Points: 1,027
|
ssellers wrote:The city is "Châtenay-Malabry", it's downsouth from Paris. Your Overlord is right ! Following changes to be reflected in data version 7 Renamed city 'Chatenay-Malabry' to 'Châtenay-Malabry'
|
|
Rank: Advanced Member
Joined: 2/14/2008 Posts: 37 Points: 32
|
Your Overlord wrote:Treadmore wrote:... Now maybe it is formally a city, by whatever definition, but for London at least YO was using the metropolitan area of London to cover "City" in the database e.g. shows in the City of Westminster, are nevertheless given London as the City I am actually no longer doing that on purpose. You were one of the people who convinced me that I should be more accurate with the city names. damn!
|
|
Rank: Administration
Joined: 2/10/2008 Posts: 336 Points: 1,027
|
^^
So which show is in Westminster as opposed to London?
|
|
Rank: Advanced Member
Joined: 2/14/2008 Posts: 37 Points: 32
|
off-topic but a quick reply, the Marquee Club is in Soho, City of Westminster, for instance
Soho=a district City of Westminster is a city, obvioulsy and it's in the London Metropolitan area
|
|
Rank: Advanced Member
Joined: 2/14/2008 Posts: 37 Points: 32
|
Some other's I posted elsewhere - do you want me to start a thread on each of these? Marquee Club, Soho, City of Westminster Playhouse Theatre, Strand, City of Westminster Hornsey Wood Tavern, Finsbury Park, Haringey Cook's Ferry Inn, Edmonton, Enfield Maida Vale Studios, Maida Vale, City of Westminster ("BBC TV Studios" ) Lime Grove Studios, Shepherd's Bush, Hammersmith
|
|
Rank: Administration
Joined: 2/10/2008 Posts: 336 Points: 1,027
|
Ok, yes, please make a post for each. Since I only have Venue, City and locale, I may not be able to accommodate all of the changes, but I will try. EDIT: no need to make separate posts for these changes. I am already working on them.
|
|
Rank: Administration
Joined: 2/10/2008 Posts: 336 Points: 1,027
|
Treadmore wrote:Some other's I posted elsewhere - do you want me to start a thread on each of these? Marquee Club, Soho, City of Westminster Playhouse Theatre, Strand, City of Westminster Hornsey Wood Tavern, Finsbury Park, Haringey Cook's Ferry Inn, Edmonton, Enfield Maida Vale Studios, Maida Vale, City of Westminster ("BBC TV Studios" ) Lime Grove Studios, Shepherd's Bush, Hammersmith It looks like both Edmonton and Enfield are cities. Are you saying that the Cook's Ferry Inn is in the city of Enfield, but a district of Edmonton?
|
|
Rank: Administration
Joined: 2/10/2008 Posts: 336 Points: 1,027
|
Treadmore wrote:Some other's I posted elsewhere - do you want me to start a thread on each of these? Marquee Club, Soho, City of Westminster Playhouse Theatre, Strand, City of Westminster Hornsey Wood Tavern, Finsbury Park, Haringey Cook's Ferry Inn, Edmonton, Enfield Maida Vale Studios, Maida Vale, City of Westminster ("BBC TV Studios" ) Lime Grove Studios, Shepherd's Bush, Hammersmith Following changes to be reflected in data version 7 Added city of 'Westminster' and geocoded it Changed the city for 'Marquee Club' from 'London' to 'Westminster' Added the locale of 'Soho' and assigned it to all of the Marquee dates Changed the city for 'Playhouse Theatre' from 'London' to 'Westminster' Added city of 'Haringey' and geocoded it Changed the city for 'Hornsey Wood Tavern' from 'London' to 'Haringey' Added locale of 'Finsbury Park' and assigned it to the 'Hornsey Wood Tavern' date Changed the city for 'Maida Vale Studio 4' from 'London' to 'Westminster' Added the city of 'Hammersmith' and geocoded it Changed the city for 'BBC TV Lime Grove Studio G' from 'London' to 'Hammersmith'
|
|
Rank: Advanced Member
Joined: 2/14/2008 Posts: 37 Points: 32
|
Sorry, I had to sleep I should have put more detail in some of those because my list above is misleading. Enfield, Haringey and Hammersmith are all boroughs, (Metropolitan) London Boroughs. So they're not cities in their own right. In the "Venue, Locale, City" scheme, then your revisions are ok if you allow borough=city. If, not then, mark them as in London, and you then have a choice for locale, in each case. Sorry for the confusion YO!
|
|
Rank: Administration
Joined: 2/10/2008 Posts: 336 Points: 1,027
|
Treadmore wrote:Sorry, I had to sleep I should have put more detail in some of those because my list above is misleading. Enfield, Haringey and Hammersmith are all boroughs, (Metropolitan) London Boroughs. So they're not cities in their own right. In the "Venue, Locale, City" scheme, then your revisions are ok if you allow borough=city. If, not then, mark them as in London, and you then have a choice for locale, in each case. Sorry for the confusion YO! Man, England is complicated! Are those Boroughs inside London proper or are they just in the metropolitan areas? Westminster seems to be just as close to the center of London as some of the others are. I'm not trying to display a mailing address here, just some location information. Does someone living in the UK consider the Marquee to be in London or Westminster?
|
|
Rank: Advanced Member
Joined: 2/14/2008 Posts: 37 Points: 32
|
Your Overlord wrote:Man, England is complicated! It's just that it's not always possible to be consistent i.e. sometimes a district name would mean more to most people than the borough name and vice-versa. I'm sure it's the same the world-over The boroughs above are in London Metropolitan area. London City is literally a square mile in area - tiny. City of Westminster isn't large either, and in most people's mind is associated with Parliament and politics. To be a little more helpful (I hope!): For the Marquee, most folk would just think "London"; I think "Soho, London" would do. For Playhouse Theatre, most people would probably think "West End (London)" - but the West End is not even a formal district, let alone Borough! "Strand (London)" should do. "Finsbury Park" is reasonably well-known I think; "Finsbury Park, London" should do. Enfield is undoubtedly better known than Edmonton (even most UK folk that had heard of a place called Edmonton would think of Canada!). So I'd suggest "Enfield, London". I'd suggest "Maida Vale, London". Because the venue is the very well-known BBC TV studios, then "Shepherd's Bush, London" is best. Any other venue, I'd have suggested "Hammersmith, London" probably. How else can I help? I'll look through the latest release again, and see if anything could be better described - but accurracy and common understanding are not the same! And being limited to "locale, city" is tough.
|
|
Rank: Administration
Joined: 2/10/2008 Posts: 336 Points: 1,027
|
Alright, it wouldn't be very difficult to add another field for locations in England if need be and it seems like it would simplify things. If I added another field for Borough or District do you think that we could nail all of these places down to the following? Venue: The name of the building they played in Locale: secondary location information such as the name of the school where a show was played or the name of the radio show that they were recording District/Borough: I could call this one a district or a borough for any given date if I set it up correctly. Cityname: the name of the city. Every show is in a city. It must be. Metropolitan area: a catch all to make all of the areas around big cities filterable based on the big city.
|
|
Rank: Advanced Member
Joined: 2/14/2008 Posts: 37 Points: 32
|
sorry for delay All that would work, but I guess it's the same everywhere - not just England, right? Regarding City - not every show was in a city, Guildford springs to mind as one case in England. With the current "venue, locale, city" there's honestly very little that needs changing in the db: it's more a case of adding locale names. I think we could make that work - I'll try to help whichever way
|
|
Rank: Administration
Joined: 2/10/2008 Posts: 336 Points: 1,027
|
I undid these two changes and set them both back to 'London'
Changed the city for 'Hornsey Wood Tavern' from 'London' to 'Haringey' Changed the city for 'BBC TV Lime Grove Studio G' from 'London' to 'Hammersmith'
|
|
Guest |