Kaavahakemisto tunnus maanalainenkaava voimassa

Tables

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

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 36 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5846 and maximum value is 10958.
kaavatunnu	int	Data source did not contain a description for kaavatunnu. Column kaavatunnu has 36 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.
tyyppi	string	Data source did not contain a description for tyyppi. Column tyyppi has 36 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.
luokka	string	Data source did not contain a description for luokka. Column luokka has 36 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	int	Data source did not contain a description for teksti. Column teksti has 36 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.
tekstifont	string	Data source did not contain a description for tekstifont. Column tekstifont has 36 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 36 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 36 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 36 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 36 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.880433266430... and first 25 characters of maximum string: POLYGON ((25.033788159156...
geom_center_x	double	Longitude of the centroid of the geometry. Column geom_center_x has 36 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 36 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 36 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