Asemakaavojen rakennus- ja rakennekohtainen suojelu

Tables

Ak Srline, Opendataak SrTSV
Aineisto sisältää tiedon asemakaavoihin merkityistä rakennus- ja rakennekohtaisista suojelumerkinnöistä. Suojelu on ilmaistu sr- kaavamääryksellä.
Ak Srpolygon, Opendataak SrTSV
Aineisto sisältää tiedon asemakaavoihin merkityistä rakennus- ja rakennekohtaisista suojelumerkinnöistä. Suojelu on ilmaistu sr- kaavamääryksellä.

Column Descriptions

Ak Srpolygon, Opendataak Sr

Column	Type	Comment
maarays	string	Data source did not contain a description for MAARAYS. Column maarays has 782 rows, out of which 13 are empty, making the null percent 1.66. Minimum string is and maximum string is sr-17.
kaupungino	int	Data source did not contain a description for KAUPUNGINO. Column kaupungino has 782 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 9 and maximum value is 312.
kortteli	int	Data source did not contain a description for KORTTELI. Column kortteli has 782 rows, out of which 30 are empty, making the null percent 3.84. Minimum value is 0 and maximum value is 9903.
tontti	int	Data source did not contain a description for TONTTI. Column tontti has 782 rows, out of which 30 are empty, making the null percent 3.84. Minimum value is 0 and maximum value is 133.
rakennus_n	int	Data source did not contain a description for RAKENNUS_N. Column rakennus_n has 782 rows, out of which 422 are empty, making the null percent 53.96. Minimum value is 0 and maximum value is 36.
kauposan_n	string	Data source did not contain a description for KAUPOSAN_N. Column kauposan_n has 782 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ALA-PISPALA and maximum string is VIINIKKA.
rakennukse	string	Data source did not contain a description for RAKENNUKSE. Column rakennukse has 782 rows, out of which 356 are empty, making the null percent 45.52. Minimum string is and maximum string is LANKARULLAKIOSKI.
osoite	string	Data source did not contain a description for OSOITE. Column osoite has 782 rows, out of which 20 are empty, making the null percent 2.56. Minimum string is and maximum string is AHLMANINTIE 23b.
raku_kirj	int	Data source did not contain a description for RAKU_KIRJ. Column raku_kirj has 782 rows, out of which 20 are empty, making the null percent 2.56. Minimum value is 0 and maximum value is 381.
luokitusta	string	Data source did not contain a description for LUOKITUSTA. Column luokitusta has 782 rows, out of which 118 are empty, making the null percent 15.09. Minimum string is and maximum string is RKM I.
kaava_nro	int	Data source did not contain a description for KAAVA_NRO. Column kaava_nro has 782 rows, out of which 11 are empty, making the null percent 1.41. Minimum value is 4639 and maximum value is 8652.
vahv_hyv_p	timestamp	Data source did not contain a description for VAHV_HYV_P. Column vahv_hyv_p has 782 rows, out of which 12 are empty, making the null percent 1.53. Minimum value is 1975-03-06 00:00:00 and maximum value is 2017-11-28 00:00:00.
muu_suojel	string	Data source did not contain a description for MUU_SUOJEL. Column muu_suojel has 782 rows, out of which 762 are empty, making the null percent 97.44. Minimum string is and maximum string is KIRKKOLAKI.
mi_symbolo	string	Data source did not contain a description for MI_SYMBOLO. Column mi_symbolo has 782 rows, out of which 27 are empty, making the null percent 3.45. First 25 characters of minimum string: ... and first 25 characters of maximum string: Pen (2, 2, 11556864) Brus...
mi_prinx	int	Data source did not contain a description for MI_PRINX. Column mi_prinx has 782 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 837.
geom_geojson	string	Geometry in GeoJSON format.
orig_extractdate	string	The date when the data was originally fetched from the source.

Ak Srline, Opendataak Sr

Column	Type	Comment
maarays	string	Data source did not contain a description for MAARAYS. Column maarays has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ju/s and maximum string is sra-1.
kaupungino	int	Data source did not contain a description for KAUPUNGINO. Column kaupungino has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 20 and maximum value is 109.
kortteli	int	Data source did not contain a description for KORTTELI. Column kortteli has 7 rows, out of which 2 are empty, making the null percent 28.57. Minimum value is 1 and maximum value is 956.
tontti	int	Data source did not contain a description for TONTTI. Column tontti has 7 rows, out of which 2 are empty, making the null percent 28.57. Minimum value is 1 and maximum value is 40.
rakennus_n	string	Data source did not contain a description for RAKENNUS_N. Column rakennus_n has 7 rows, out of which 6 are empty, making the null percent 85.71. The single string value is: .
kauposan_n	string	Data source did not contain a description for KAUPOSAN_N. Column kauposan_n has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is FINLAYSON and maximum string is MESSUKYLÄ.
rakennukse	string	Data source did not contain a description for RAKENNUKSE. Column rakennukse has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: FINLAYSONIN PORTTI... and first 25 characters of maximum string: MESSUKYLÄN VANHAN HAUTAUS...
osoite	string	Data source did not contain a description for OSOITE. Column osoite has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is KOULUKATU 11 and maximum string is MESSUKYLÄNKATU.
raku_kirj	int	Data source did not contain a description for RAKU_KIRJ. Column raku_kirj has 7 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 204.
luokitusta	string	Data source did not contain a description for LUOKITUSTA. Column luokitusta has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: KM I... and first 25 characters of maximum string: RKM I, valtakunnallisesti...
kaava_nro	int	Data source did not contain a description for KAAVA_NRO. Column kaava_nro has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6177 and maximum value is 7827.
vahv_hyv_p	timestamp	Data source did not contain a description for VAHV_HYV_P. Column vahv_hyv_p has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1984-08-06 00:00:00 and maximum value is 2002-10-30 00:00:00.
muu_suojel	string	Data source did not contain a description for MUU_SUOJEL. Column is empty.
mi_symbolo	string	Data source did not contain a description for MI_SYMBOLO. Column mi_symbolo has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pen (6, 2, 11556864).
mi_prinx	int	Data source did not contain a description for MI_PRINX. Column mi_prinx has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 299 and maximum value is 426.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (23.7484202356... and first 25 characters of maximum string: LINESTRING (23.8444289627...
geom_center_x	double	Longitude of the centroid of the geometry. Column is empty.
geom_center_y	double	Latitude of the centroid of the geometry. Column is empty.
geom_type	string	Geometry type. Column geom_type has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	April 12, 2019
Created	September 26, 2018