1. Home
  2. Datasets
  3. Sijoitussopimus alue
To download the data set, please sign up or log in

Sijoitussopimus alue

No description available for layer avoindata:Sijoitussopimus_alue (Sijoitussopimus_alue)

Tables

Column Descriptions

Sijoitussopimus aluepolygon, Avoindatasijoitussopimus alue, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 1266.
hakemus string Data source did not contain a description for hakemus. Column hakemus has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Sijoitussopimus.
hakemustun string Data source did not contain a description for hakemustun. Column hakemustun has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is SL1900509 and maximum string is SL2200483.
laji string Data source did not contain a description for laji. Column laji has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Katu- ja vihertyöt... and first 25 characters of maximum string: Vesi / viemäri, Rakennus,...
voimassaol date Data source did not contain a description for voimassaol. Column is empty.
osoite string Data source did not contain a description for osoite. Column osoite has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Ahdekaunokintie 1 ja 2 and maximum string is Äijänpolku 3.
kaupungino string Data source did not contain a description for kaupungino. Column kaupungino has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 10 SÖRNÄINEN and maximum string is 9 KAIVOPUISTO.
geometryty string Data source did not contain a description for geometryty. Column geometryty has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_Polygon.
voimassao0 timestamp Data source did not contain a description for voimassao0. Column voimassao0 has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2021-07-07 00:00:00 and maximum value is 2022-07-06 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POLYGON ((24.836711717536... and first 25 characters of maximum string: POLYGON ((25.228110999999...
geom_center_x float Longitude of center. Column geom_center_x has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.84 and maximum value is 25.23.
geom_center_y float Latitude of center. Column geom_center_y has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.15 and maximum value is 60.29.
geom_type string Geometry type. Column geom_type has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POLYGON.

Sijoitussopimus aluepolygon, Avoindatasijoitussopimus alue, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 1266.
hakemus string Data source did not contain a description for hakemus. Column hakemus has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Sijoitussopimus.
hakemustun string Data source did not contain a description for hakemustun. Column hakemustun has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is SL1900509 and maximum string is SL2200483.
laji string Data source did not contain a description for laji. Column laji has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Katu- ja vihertyöt... and first 25 characters of maximum string: Vesi / viemäri, Rakennus,...
voimassaol date Data source did not contain a description for voimassaol. Column is empty.
osoite string Data source did not contain a description for osoite. Column osoite has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Ahdekaunokintie 1 ja 2 and maximum string is Äijänpolku 3.
kaupungino string Data source did not contain a description for kaupungino. Column kaupungino has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 10 SÖRNÄINEN and maximum string is 9 KAIVOPUISTO.
geometryty string Data source did not contain a description for geometryty. Column geometryty has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_Polygon.
voimassao0 timestamp Data source did not contain a description for voimassao0. Column voimassao0 has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2021-07-07 00:00:00 and maximum value is 2022-07-06 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POLYGON ((24.836711717536... and first 25 characters of maximum string: POLYGON ((25.228110999999...
geom_center_x float Longitude of center. Column geom_center_x has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.84 and maximum value is 25.23.
geom_center_y float Latitude of center. Column geom_center_y has 1240 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.15 and maximum value is 60.29.
geom_type string Geometry type. Column geom_type has 1240 rows, out of which 0 are empty, making the null percent 0. 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 July 7, 2022
Created July 5, 2022