To download the data set, please sign up or log in

Kaavahakemisto tunnus KHn nimenmuutoskaava voimassa

Kaavahakemisto tunnus KHn nimenmuutoskaava voimassa

Tables

  • Kaavahakemisto Tunnus Khn Nimenmuutoskaava Voimassapolygon, Avoindatakaavahakemisto Tunnus Khn Nimenmuutoskaava VoimassaTSV

    Rakennuskiellot-aineisto on Helsingin kaupunkiympäristötoimialan kaupunkimittauspalvelujen yhteen kokoama teemakartta kaupungissa voimassa olevista rakennuskieltoalueista. Alue tai kiinteistö voidaan asettaa rakennuskieltoon asema- tai yleiskaavan laatimista, muuttamista tai suunnittelun jatkamista varten. Helsingin kaupungin organisaatiomuutoksen myötä rakennuskiellon määrääjänä on 1.6.2017 alkaen toiminut kaupunkiympäristölautakunta. Tätä ennen rakennuskielto on määrätty kaupunginhallituksen toimesta. Rakennuskielloista on julkaistu seuraavat ominaisuustiedot: id, tyyppi, tunnus, antaja, laadun tunnus, laatu, voimaantulopvm, päättymispvm, päätöspvm, kunta, kohteen luontipvm, kohteen edellinen muokkauspvm, aineiston omistaja, tietopalvelun tallennuspvm. Aineiston ylläpidosta vastaa...

Column Descriptions

Kaavahakemisto Tunnus Khn Nimenmuutoskaava Voimassapolygon, Avoindatakaavahakemisto Tunnus Khn Nimenmuutoskaava Voimassa

Column Type Comment
id int Data source did not contain a description for id. Column id has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5854 and maximum value is 11590.
kaavatunnu string Data source did not contain a description for kaavatunnu. Column kaavatunnu has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2018-3 and maximum string is kh2017-239.
tyyppi string Data source did not contain a description for tyyppi. Column tyyppi has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: KHn nimenmuutoskaava.
luokka string Data source did not contain a description for luokka. Column luokka has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Voimassa.
teksti string Data source did not contain a description for teksti. Column teksti has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2018-3 and maximum string is kh2017-239.
tekstifont string Data source did not contain a description for tekstifont. Column tekstifont has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Arial Narrow.
tekstikoko float Data source did not contain a description for tekstikoko. Column tekstikoko has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 14.20.
tekstisuun int Data source did not contain a description for tekstisuun. Column tekstisuun has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
luontipvm string Data source did not contain a description for luontipvm. Column is empty.
muokkauspv string Data source did not contain a description for muokkauspv. Column is empty.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Helsinki/KAMI.
paivitetty string Data source did not contain a description for paivitetty. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POLYGON ((24.964366305524... and first 25 characters of maximum string: POLYGON ((25.223812534196...
geom_center_x double Longitude of the centroid of the geometry. Column geom_center_x has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.91 and maximum value is 25.22.
geom_center_y double Latitude of the centroid of the geometry. Column geom_center_y has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.15 and maximum value is 60.27.
geom_type string Geometry type. Column geom_type has 30 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created November 21, 2018