Viitaniemi
Viitaniemi is a neighborhood in the Nisula district of Jyväskylä, Finland.[1] It was built during 1959–1964.[2][3] In 1962, the landmark of the suburb, Viitatorni designed by Alvar Aalto, was built.[2] Viitaniemi is considered to be an architecturally significant area.[3]
Viitaniemi | |
|---|---|
Suburb of Jyväskylä | |
 Viitatorni | |
| Country |  |
| Province | Western Finland |
| Region | Central Finland |
| Sub-region | Jyväskylä sub-region |
| City | Jyväskylä |
| Ward | Kantakaupunki |
| Time zone | UTC+2 (EET) |
| • Summer (DST) | UTC+3 (EEST) |
| Postal code | 40720 JYVÄSKYLÄ |
Gallery
Viitaniemi school
Row houses in Viitaniemi
An apartment building
gollark: Also, the latest update to something doesn't show on the user-visible revisions page, which is a minor nitpick but I mildly dislike it.
gollark: This isn't really ideal, as I think I'm duplicating data a bit (timestamps), updating a page involves more work, and more importantly the `revisions` thing doesn't have any relevant information beyond what's available from `pages`.
gollark: Basically, when there's a new revision, the apiosystem reads the current content out of `pages`, compresses it, generates and serializes the metadata, then shoves in a row into `revisions`.
gollark: As of now I do this:```sqlCREATE TABLE pages ( title TEXT NOT NULL UNIQUE, content TEXT NOT NULL, updated INTEGER NOT NULL, created INTEGER NOT NULL);CREATE TABLE revisions ( page TEXT NOT NULL REFERENCES pages(title), timestamp INTEGER NOT NULL, meta BLOB NOT NULL, -- contains revision metadata and type -- ChangeContent { size } is the only one here for now full_data BLOB -- contains optionally compressed text);```but it is not ideal.
gollark: Yes. Please hold on while I post the schæma.
References
- "Jyväskylän karttapalvelu". kartta.jkl.fi (in Finnish). Retrieved 2017-09-08.
- "Jyväskylän kaupunki: Kaupunkirakennepalvelut: Viitaniemi". www.jkl.fi (in Finnish). Retrieved 2017-09-08.
- "RKY ι Museovirasto". www.rky.fi. Retrieved 2017-09-08.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.