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

Rakennustapaohjeet

Rakennustapaohjeet

Tables

Column Descriptions

Rakennustapaohjeet, Postgisrakennustapaohjeet

Column Type Comment
id_1 int Data source did not contain a description for id_1. Column id_1 has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 24.
id int Data source did not contain a description for id. Column id has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
kaavan_nro int Data source did not contain a description for kaavan_nro. Column kaavan_nro has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 56 and maximum value is 1028.
kaava string Data source did not contain a description for kaava. Column kaava has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asemamäki II and maximum string is Jaatilanrinne.
sitovuus string Data source did not contain a description for sitovuus. Column sitovuus has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ei tiedossa... and first 25 characters of maximum string: Sitova, valmistunut kaava...
pvm timestamp Data source did not contain a description for pvm. Column pvm has 24 rows, out of which 2 are empty, making the null percent 8.33. Minimum value is 1978-12-11 00:00:00 and maximum value is 2016-02-08 00:00:00.
linkki string Data source did not contain a description for linkki. Column linkki has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: http://www.jamsa.fi/image... and first 25 characters of maximum string: http://www.jamsa.fi/image...
pykl string Data source did not contain a description for pykl. Column pykl has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ? and maximum string is § 39.
pttj string Data source did not contain a description for pttj. Column pttj has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ? and maximum string is Kvalt.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 24 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 (((25.141066... and first 25 characters of maximum string: MULTIPOLYGON (((25.198452...
geom_center_x double Longitude of the centroid of the geometry. Column geom_center_x has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.85 and maximum value is 25.39.
geom_center_y double Latitude of the centroid of the geometry. Column geom_center_y has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 61.86 and maximum value is 61.98.
geom_type string Geometry type. Column geom_type has 24 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 April 12, 2019
Created November 24, 2018