To download the data set, please sign up or log in
Sulut (Taitorakennerekisteri)
Tables
-
Trex sulut, Avointrex sulut, Full historyTSV
No description available for layer avoin:TREX_SULUT (Sulut (Taitorakennerekisteri))
-
Trex sulut, Avointrex sulut, LatestTSV
No description available for layer avoin:TREX_SULUT (Sulut (Taitorakennerekisteri))
Column Descriptions
Trex sulut, Avointrex sulut, Latest
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for ID. Column id has 41 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 41. |
| oid | string | Data source did not contain a description for OID. Column oid has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1.2.246.578.1.20.1 and maximum string is 1.2.246.578.1.20.3222. |
| tila | string | Data source did not contain a description for TILA. Column tila has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: kaytossa. |
| nykyinen_o | string | Data source did not contain a description for NYKYINEN_O. Column nykyinen_o has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: nimi:Väylävirasto,yTunnus... |
| keskipiste | int | Data source did not contain a description for KESKIPISTE. Column keskipiste has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 325984 and maximum value is 659888. |
| keskipist0 | int | Data source did not contain a description for KESKIPIST0. Column keskipist0 has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6742981 and maximum value is 7051892. |
| keskipist1 | string | Data source did not contain a description for KESKIPIST1. Column keskipist1 has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: lat:60.8109488587007,lon:... and first 25 characters of maximum string: lat:63.5949644791057,lon:... |
| tunnus | string | Data source did not contain a description for TUNNUS. Column tunnus has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kan-1 and maximum string is Kan-3222. |
| sijaintiku | string | Data source did not contain a description for SIJAINTIKU. Column sijaintiku has 41 rows, out of which 32 are empty, making the null percent 78.05. Minimum string is and maximum string is tunnus:936,nimi:Virrat. |
| tieosoitte | string | Data source did not contain a description for TIEOSOITTE. Column is empty. |
| nimi | string | Data source did not contain a description for NIMI. Column nimi has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahkiolahden sulku and maximum string is V??ksyn sulku. |
| nykyinenku | string | Data source did not contain a description for NYKYINENKU. Column nykyinenku has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: nimi:Väylävirasto,yTunnus... |
| vesivaylao | string | Data source did not contain a description for VESIVAYLAO. Column is empty. |
| paivitetty | timestamp | Data source did not contain a description for PAIVITETTY. Column paivitetty has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-02-21 00:00:00 and maximum value is 2020-08-18 00:00:00. |
| rakenneluo | string | Data source did not contain a description for RAKENNELUO. Column rakenneluo has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: tunnus:KR,nimi:Sulut. |
| sijaintisu | string | Data source did not contain a description for SIJAINTISU. Column is empty. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (23.73029801124169 ... and first 25 characters of maximum string: POINT (30.132962641923672... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23.73 and maximum value is 30.13. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.81 and maximum value is 63.60. |
| geom_type | string | Geometry type. Column geom_type has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT. |
Trex sulut, Avointrex sulut, Full history
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for ID. Column id has 41 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 41. |
| oid | string | Data source did not contain a description for OID. Column oid has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1.2.246.578.1.20.1 and maximum string is 1.2.246.578.1.20.3222. |
| tila | string | Data source did not contain a description for TILA. Column tila has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: kaytossa. |
| nykyinen_o | string | Data source did not contain a description for NYKYINEN_O. Column nykyinen_o has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: nimi:Väylävirasto,yTunnus... |
| keskipiste | int | Data source did not contain a description for KESKIPISTE. Column keskipiste has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 325984 and maximum value is 659888. |
| keskipist0 | int | Data source did not contain a description for KESKIPIST0. Column keskipist0 has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6742981 and maximum value is 7051892. |
| keskipist1 | string | Data source did not contain a description for KESKIPIST1. Column keskipist1 has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: lat:60.8109488587007,lon:... and first 25 characters of maximum string: lat:63.5949644791057,lon:... |
| tunnus | string | Data source did not contain a description for TUNNUS. Column tunnus has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kan-1 and maximum string is Kan-3222. |
| sijaintiku | string | Data source did not contain a description for SIJAINTIKU. Column sijaintiku has 41 rows, out of which 32 are empty, making the null percent 78.05. Minimum string is and maximum string is tunnus:936,nimi:Virrat. |
| tieosoitte | string | Data source did not contain a description for TIEOSOITTE. Column is empty. |
| nimi | string | Data source did not contain a description for NIMI. Column nimi has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahkiolahden sulku and maximum string is V??ksyn sulku. |
| nykyinenku | string | Data source did not contain a description for NYKYINENKU. Column nykyinenku has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: nimi:Väylävirasto,yTunnus... |
| vesivaylao | string | Data source did not contain a description for VESIVAYLAO. Column is empty. |
| paivitetty | timestamp | Data source did not contain a description for PAIVITETTY. Column paivitetty has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-02-21 00:00:00 and maximum value is 2020-08-18 00:00:00. |
| rakenneluo | string | Data source did not contain a description for RAKENNELUO. Column rakenneluo has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: tunnus:KR,nimi:Sulut. |
| sijaintisu | string | Data source did not contain a description for SIJAINTISU. Column is empty. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (23.73029801124169 ... and first 25 characters of maximum string: POINT (30.132962641923672... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23.73 and maximum value is 30.13. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 41 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.81 and maximum value is 63.60. |
| geom_type | string | Geometry type. Column geom_type has 41 rows, out of which 0 are empty, making the null percent 0.00. 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. |
Additional Info
| Last Updated | September 10, 2020 |
|---|---|
| Created | September 10, 2020 |