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

Rautatierumpu (Taitorakennerekisteri)

Rautatierumpu (Taitorakennerekisteri)

Tables

Column Descriptions

Trex rautatierumpu, Avointrex rautatierumpu, Latest

Column Type Comment
id int Data source did not contain a description for ID. Column id has 6189 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 6189.
oid string Data source did not contain a description for OID. Column oid has 6189 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.14.1000 and maximum string is 1.2.246.578.1.14.999.
tila string Data source did not contain a description for TILA. Column tila has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is kaytossa and maximum string is taytetty.
nykyinen_o string Data source did not contain a description for NYKYINEN_O. Column nykyinen_o has 6189 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 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 194597 and maximum value is 701980.
keskipist0 int Data source did not contain a description for KESKIPIST0. Column keskipist0 has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6640616 and maximum value is 7489359.
keskipist1 string Data source did not contain a description for KESKIPIST1. Column keskipist1 has 6189 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:59.8427949368286,lon:... and first 25 characters of maximum string: lat:67.4902106525773,lon:...
tunnus string Data source did not contain a description for TUNNUS. Column tunnus has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is R-1000 and maximum string is R-999.
rataosoitt string Data source did not contain a description for RATAOSOITT. Column rataosoitt has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: ratanumero:001,ratakilome... and first 25 characters of maximum string: ratanumero:YV 060,ratakil...
sijaintiku string Data source did not contain a description for SIJAINTIKU. Column sijaintiku has 6189 rows, out of which 3 are empty, making the null percent 0.05. Minimum string is and maximum string is tunnus:992,nimi:Äänekoski.
nimi string Data source did not contain a description for NIMI. Column nimi has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aatamilan rumpu and maximum string is Yrttivuori.
nykyinenku string Data source did not contain a description for NYKYINENKU. Column nykyinenku has 6189 rows, out of which 2 are empty, making the null percent 0.03. Minimum string is and maximum string is nimi:Yksityinen.
paivitetty timestamp Data source did not contain a description for PAIVITETTY. Column paivitetty has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2019-06-16 00:00:00 and maximum value is 2020-08-31 00:00:00.
rakenneluo string Data source did not contain a description for RAKENNELUO. Column rakenneluo has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: tunnus:R,nimi:Rautatierum...
sijaintisu string Data source did not contain a description for SIJAINTISU. Column is empty.
kokonaisle string Data source did not contain a description for KOKONAISLE. Column kokonaisle has 6189 rows, out of which 5869 are empty, making the null percent 94.83. Minimum string is and maximum string is arvo:9,yksikko:metri.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 6189 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 (21.2232082961998 6... and first 25 characters of maximum string: POINT (30.944573958021206...
geom_center_x float Longitude of center. Column geom_center_x has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.22 and maximum value is 30.94.
geom_center_y float Latitude of center. Column geom_center_y has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.84 and maximum value is 67.49.
geom_type string Geometry type. Column geom_type has 6189 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 rautatierumpu, Avointrex rautatierumpu, Full history

Column Type Comment
id int Data source did not contain a description for ID. Column id has 6189 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 6189.
oid string Data source did not contain a description for OID. Column oid has 6189 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.14.1000 and maximum string is 1.2.246.578.1.14.999.
tila string Data source did not contain a description for TILA. Column tila has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is kaytossa and maximum string is taytetty.
nykyinen_o string Data source did not contain a description for NYKYINEN_O. Column nykyinen_o has 6189 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 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 194597 and maximum value is 701980.
keskipist0 int Data source did not contain a description for KESKIPIST0. Column keskipist0 has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6640616 and maximum value is 7489359.
keskipist1 string Data source did not contain a description for KESKIPIST1. Column keskipist1 has 6189 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:59.8427949368286,lon:... and first 25 characters of maximum string: lat:67.4902106525773,lon:...
tunnus string Data source did not contain a description for TUNNUS. Column tunnus has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is R-1000 and maximum string is R-999.
rataosoitt string Data source did not contain a description for RATAOSOITT. Column rataosoitt has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: ratanumero:001,ratakilome... and first 25 characters of maximum string: ratanumero:YV 060,ratakil...
sijaintiku string Data source did not contain a description for SIJAINTIKU. Column sijaintiku has 6189 rows, out of which 3 are empty, making the null percent 0.05. Minimum string is and maximum string is tunnus:992,nimi:Äänekoski.
nimi string Data source did not contain a description for NIMI. Column nimi has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aatamilan rumpu and maximum string is Yrttivuori.
nykyinenku string Data source did not contain a description for NYKYINENKU. Column nykyinenku has 6189 rows, out of which 2 are empty, making the null percent 0.03. Minimum string is and maximum string is nimi:Yksityinen.
paivitetty timestamp Data source did not contain a description for PAIVITETTY. Column paivitetty has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2019-06-16 00:00:00 and maximum value is 2020-08-31 00:00:00.
rakenneluo string Data source did not contain a description for RAKENNELUO. Column rakenneluo has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: tunnus:R,nimi:Rautatierum...
sijaintisu string Data source did not contain a description for SIJAINTISU. Column is empty.
kokonaisle string Data source did not contain a description for KOKONAISLE. Column kokonaisle has 6189 rows, out of which 5869 are empty, making the null percent 94.83. Minimum string is and maximum string is arvo:9,yksikko:metri.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 6189 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 (21.2232082961998 6... and first 25 characters of maximum string: POINT (30.944573958021206...
geom_center_x float Longitude of center. Column geom_center_x has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.22 and maximum value is 30.94.
geom_center_y float Latitude of center. Column geom_center_y has 6189 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.84 and maximum value is 67.49.
geom_type string Geometry type. Column geom_type has 6189 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 11, 2020
Created September 11, 2020