Kaavahakemisto alue maanalainenkaava voimassa

Tables

Kaavahakemisto Alue Maanalainenkaava Voimassapolygon, Avoindatakaavahakemisto Alue Maanalainenkaava 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 Alue Maanalainenkaava Voimassapolygon, Avoindatakaavahakemisto Alue Maanalainenkaava Voimassa

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 239 and maximum value is 4394.
tyyppi	string	Data source did not contain a description for tyyppi. Column tyyppi has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Maanalainen kaava.
kaavatunnu	int	Data source did not contain a description for kaavatunnu. Column kaavatunnu has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6044 and maximum value is 12333.
luokka	string	Data source did not contain a description for luokka. Column luokka has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Voimassa.
alkuperain	boolean	Data source did not contain a description for alkuperain.
pintaala	float	Data source did not contain a description for pintaala. Column pintaala has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 152.76 and maximum value is 474226.59.
korkeusjar	string	Data source did not contain a description for korkeusjar. Column korkeusjar has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N2000 and maximum string is NN.
sijaintial	int	Data source did not contain a description for sijaintial. Column sijaintial has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 45.
hyvaksymis	timestamp	Data source did not contain a description for hyvaksymis.
lainvoimai	date	Data source did not contain a description for lainvoimai. Column is empty.
voimaantul	date	Data source did not contain a description for voimaantul. Column is empty.
vahvistami	date	Data source did not contain a description for vahvistami. Column is empty.
luontipvm	date	Data source did not contain a description for luontipvm. Column is empty.
muokkauspv	date	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 33 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	date	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 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((24.930160... and first 25 characters of maximum string: POLYGON ((25.034406134850...
geom_center_x	double	Longitude of the centroid of the geometry. Column geom_center_x has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.88 and maximum value is 25.10.
geom_center_y	double	Latitude of the centroid of the geometry. Column geom_center_y has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.16 and maximum value is 60.23.
geom_type	string	Geometry type. Column geom_type has 33 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	May 4, 2019
Created	November 21, 2018