id |
int |
Data source did not contain a description for id. Column id has 2129 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 2129. |
hakemus |
string |
Data source did not contain a description for hakemus. Column hakemus has 2129 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Aluevuokraus. |
hakemustun |
string |
Data source did not contain a description for hakemustun. Column hakemustun has 2129 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is AL1900073-4 and maximum string is AL2201896. |
tyo_alkaa |
date |
Data source did not contain a description for tyo_alkaa. Column is empty. |
tyo_paatty |
date |
Data source did not contain a description for tyo_paatty. Column is empty. |
tyon_tarko |
string |
Data source did not contain a description for tyon_tarko. Column tyon_tarko has 2129 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Alue telineosien varastoi... and first 25 characters of maximum string: Väliaikaisten portaiden s... |
osoite |
string |
Data source did not contain a description for osoite. Column osoite has 2129 rows, out of which 5 are empty, making the null percent 0.23. Minimum string is and maximum string is Zaidankatu 2, 7. |
kaupungino |
string |
Data source did not contain a description for kaupungino. Column kaupungino has 2129 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. |
status |
string |
Data source did not contain a description for status. Column status has 2129 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Käynnissä and maximum string is Tuleva. |
hakija |
string |
Data source did not contain a description for hakija. Column hakija has 2129 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 1RAKENNUSPALVELUT OY and maximum string is Yleisradio Oy. |
tyon_suori |
string |
Data source did not contain a description for tyon_suori. Column tyon_suori has 2129 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: 1RAKENNUSPALVELUT OY... and first 25 characters of maximum string: YPR Yleinen Pohjarakennus... |
geometryty |
string |
Data source did not contain a description for geometryty. Column geometryty has 2129 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_Polygon. |
tyo_alkaa_c12 |
timestamp |
Data source did not contain a description for tyo_alkaa_c12. Column tyo_alkaa_c12 has 2129 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2018-10-24 00:00:00 and maximum value is 2022-12-01 00:00:00. |
tyo_paatt0 |
timestamp |
Data source did not contain a description for tyo_paatt0. Column tyo_paatt0 has 2129 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2020-01-31 00:00:00 and maximum value is 2028-03-12 00:00:00. |
geom_geojson |
string |
Geometry in GeoJSON format. |
geom_geotext |
string |
Geometry as GeoText. Column geom_geotext has 2129 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.841539000000... and first 25 characters of maximum string: POLYGON ((25.229586999999... |
geom_center_x |
float |
Longitude of center. Column geom_center_x has 2129 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 2129 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 2129 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POLYGON. |