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

Vapaat yritystontit

No description available for layer avoindata:Vapaat_yritystontit (Vapaat_yritystontit)

Tables

Column Descriptions

Vapaat yritystontitpoint, Avoindatavapaat yritystontit, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 71 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 71.
jhs_tunnus int Data source did not contain a description for jhs_tunnus. Column is empty.
osoite string Data source did not contain a description for osoite. Column osoite has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Aallonhalkoja and maximum string is Verkkosaarenranta.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 71 rows, out of which 1 are empty, making the null percent 1.41. Minimum value is 589 and maximum value is 27301.
rakennusoi int Data source did not contain a description for rakennusoi. Column rakennusoi has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 210 and maximum value is 30200.
kayttotark string Data source did not contain a description for kayttotark. Column kayttotark has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is AK-1 and maximum string is TYYK.
kayttotar0 string Data source did not contain a description for kayttotar0. Column kayttotar0 has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Asuinkerrostalojen kortte... and first 25 characters of maximum string: Ympäristöhaittoja aiheutt...
lisatietoj string Data source did not contain a description for lisatietoj. Column lisatietoj has 71 rows, out of which 50 are empty, making the null percent 70.42. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vuokrattu 3kk irtisanomis...
luokka string Data source did not contain a description for luokka. Column luokka has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is K and maximum string is T.
e int Data source did not contain a description for e. Column e has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 25493361 and maximum value is 25510143.
n int Data source did not contain a description for n. Column n has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 6671244 and maximum value is 6685587.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helskinki/MAKA.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POINT (24.88023469830941 ... and first 25 characters of maximum string: POINT (25.182943264402414...
geom_center_x float Longitude of center. Column geom_center_x has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.88 and maximum value is 25.18.
geom_center_y float Latitude of center. Column geom_center_y has 71 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.28.
geom_type string Geometry type. Column geom_type has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT.
orig_extractdate string The date when the data was originally fetched from the source.

Vapaat yritystontitpoint, Avoindatavapaat yritystontit, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 71 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 71.
jhs_tunnus int Data source did not contain a description for jhs_tunnus. Column is empty.
osoite string Data source did not contain a description for osoite. Column osoite has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Aallonhalkoja and maximum string is Verkkosaarenranta.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 71 rows, out of which 1 are empty, making the null percent 1.41. Minimum value is 589 and maximum value is 27301.
rakennusoi int Data source did not contain a description for rakennusoi. Column rakennusoi has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 210 and maximum value is 30200.
kayttotark string Data source did not contain a description for kayttotark. Column kayttotark has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is AK-1 and maximum string is TYYK.
kayttotar0 string Data source did not contain a description for kayttotar0. Column kayttotar0 has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Asuinkerrostalojen kortte... and first 25 characters of maximum string: Ympäristöhaittoja aiheutt...
lisatietoj string Data source did not contain a description for lisatietoj. Column lisatietoj has 71 rows, out of which 50 are empty, making the null percent 70.42. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vuokrattu 3kk irtisanomis...
luokka string Data source did not contain a description for luokka. Column luokka has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is K and maximum string is T.
e int Data source did not contain a description for e. Column e has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 25493361 and maximum value is 25510143.
n int Data source did not contain a description for n. Column n has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 6671244 and maximum value is 6685587.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helskinki/MAKA.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POINT (24.88023469830941 ... and first 25 characters of maximum string: POINT (25.182943264402414...
geom_center_x float Longitude of center. Column geom_center_x has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.88 and maximum value is 25.18.
geom_center_y float Latitude of center. Column geom_center_y has 71 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.28.
geom_type string Geometry type. Column geom_type has 71 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT.

Additional Info

Last Updated July 7, 2022
Created July 7, 2022