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

Kaavahakemisto tunnus kaava voimassa

Kaavahakemisto tunnus kaava voimassa

Tables

Column Descriptions

Kaavahakemisto Tunnus Kaava Voimassapolygon, Avoindatakaavahakemisto Tunnus Kaava Voimassa

Column Type Comment
id int Data source did not contain a description for id. Column id has 5557 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5814 and maximum value is 11626.
kaavatunnu int Data source did not contain a description for kaavatunnu. Column kaavatunnu has 5557 rows, out of which 15 are empty, making the null percent 0.27. Minimum value is 117 and maximum value is 999999.
tyyppi string Data source did not contain a description for tyyppi. Column tyyppi has 5557 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kaava.
luokka string Data source did not contain a description for luokka. Column luokka has 5557 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 5557 rows, out of which 15 are empty, making the null percent 0.27. Minimum value is 117 and maximum value is 999999.
tekstifont string Data source did not contain a description for tekstifont. Column tekstifont has 5557 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 5557 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 5557 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 5557 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.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created August 7, 2018