Radan merkki - Radan merkit (RATKOn tietolaji) - Track sign, Avointrack sign, Latest - This service has been deprecated - please visit https://www.smartdatahub.io/ to access data. See the About page for details. //

Track sign, Avointrack sign, Latest

To download the data set, please sign up or log in

Radan merkeillä välitetään tietoa rautatieliikenteelle ja radanpidolle sekä annetaan informaatiota myös radan läheisyydessä liikkuville ihmisille. Radan merkeistä ilmoitetaan merkkirekisterin tunniste, paikka, lukusuunta, puoli, valmistusnumero, merkkityyppi, teksti, asennuskorkeus, -etäisyys ja -rakenne, kiinnitystapa, kiinnitin, kääntyvä (kyllä, ei, ei tiedossa), tulppa, asennuspäivä, valmistusvuosi, perustus, valmistaja, omistaja ja lisätiedot. Aineisto kattaa Väyläviraston omistamat rautatiet.

Field Descriptions

Name	Data type	Description
oid	string	Data source did not contain a description for oid. Column oid has 2 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.3.118.328136 and maximum string is 1.2.246.578.3.118.330698.
type	string	Data source did not contain a description for type. Column type has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: track_sign.
temporalst	string	Data source did not contain a description for temporalst. Column temporalst has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2019-06-25T16:17Z and maximum string is 2019-06-25T16:20Z.
state	string	Data source did not contain a description for state. Column state has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: IN USE.
track_sign	int	Data source did not contain a description for track_sign. Column track_sign has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1387124 and maximum value is 1439997.
place	string	Data source did not contain a description for place. Column place has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Raideopastin O107.
facing_dir	string	Data source did not contain a description for facing_dir. Column facing_dir has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pik-Tur.
track_sig0	string	Data source did not contain a description for track_sig0. Column track_sig0 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: O107.
track_sig1	string	Data source did not contain a description for track_sig1. Column track_sig1 has 2 rows, out of which 1 are empty, making the null percent 50.00. The single string value is: Junakulkutien päätekohta ...
manufactur	string	Data source did not contain a description for manufactur. Column is empty.
installati	string	Data source did not contain a description for installati. Column is empty.
installat0	string	Data source did not contain a description for installat0. Column is empty.
plug	string	Data source did not contain a description for plug. Column is empty.
production	int	Data source did not contain a description for production. Column production has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
installat1	string	Data source did not contain a description for installat1. Column is empty.
warranty_e	string	Data source did not contain a description for warranty_e. Column is empty.
side	string	Data source did not contain a description for side. Column side has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Oikea.
swiveling	string	Data source did not contain a description for swiveling. Column swiveling has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ei tiedossa.
track_sig2	string	Data source did not contain a description for track_sig2. Column track_sig2 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Junakulkutien päätekohta ... and first 25 characters of maximum string: Raideopastimen tunnus...
track_sig3	string	Data source did not contain a description for track_sig3. Column track_sig3 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is T-253 and maximum string is T-259.
track_sig4	string	Data source did not contain a description for track_sig4. Column track_sig4 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tiedossa and maximum string is Muu.
installat2	string	Data source did not contain a description for installat2. Column installat2 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Merkkipylväs and maximum string is Raideopastin.
foundation	string	Data source did not contain a description for foundation. Column foundation has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ei tiedossa.
notes	string	Data source did not contain a description for notes. Column notes has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ['Ei tiedossa'].
name	string	Data source did not contain a description for name. Column name has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: TKUT 107 0200+0745 Junaku... and first 25 characters of maximum string: TKUT 107 0200+0745 Raideo...
owner	string	Data source did not contain a description for owner. Column owner has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ei tiedossa.
maintenanc	string	Data source did not contain a description for maintenanc. Column is empty.
maintenan0	string	Data source did not contain a description for maintenan0. Column is empty.
operating	string	Data source did not contain a description for operating. Column is empty.
accounting	string	Data source did not contain a description for accounting. Column is empty.
locationtr	string	Data source did not contain a description for locationtr. Column locationtr has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: TKUT 107.
routenumbe	int	Data source did not contain a description for routenumbe. Column routenumbe has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 332.
kmm	string	Data source did not contain a description for kmm. Column kmm has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 0200+0745.
km	int	Data source did not contain a description for km. Column km has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 200.
m	int	Data source did not contain a description for m. Column m has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 745.
geom_geojson	string	Geometry in GeoJSON format. Column is empty.
geom_geotext	string	Geometry as GeoText. Column is empty.
geom_center_x	float	Longitude of center. Column is empty.
geom_center_y	float	Latitude of center. Column is empty.
geom_type	string	Geometry type. Column is empty.

Name

Data type

Description

oid

string

Data source did not contain a description for oid. Column oid has 2 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.3.118.328136 and maximum string is 1.2.246.578.3.118.330698.

type

string

Data source did not contain a description for type. Column type has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: track_sign.

temporalst

string

Data source did not contain a description for temporalst. Column temporalst has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2019-06-25T16:17Z and maximum string is 2019-06-25T16:20Z.

state

string

Data source did not contain a description for state. Column state has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: IN USE.

track_sign

int

Data source did not contain a description for track_sign. Column track_sign has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1387124 and maximum value is 1439997.

place

string

Data source did not contain a description for place. Column place has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Raideopastin O107.

facing_dir

string

Data source did not contain a description for facing_dir. Column facing_dir has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pik-Tur.

track_sig0

string

Data source did not contain a description for track_sig0. Column track_sig0 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: O107.

track_sig1

string

Data source did not contain a description for track_sig1. Column track_sig1 has 2 rows, out of which 1 are empty, making the null percent 50.00. The single string value is: Junakulkutien päätekohta ...

manufactur

string

Data source did not contain a description for manufactur. Column is empty.

installati

string

Data source did not contain a description for installati. Column is empty.

installat0

string

Data source did not contain a description for installat0. Column is empty.

plug

string

Data source did not contain a description for plug. Column is empty.

production

int

Data source did not contain a description for production. Column production has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.

installat1

string

Data source did not contain a description for installat1. Column is empty.

warranty_e

string

Data source did not contain a description for warranty_e. Column is empty.

side

string

Data source did not contain a description for side. Column side has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Oikea.

swiveling

string

Data source did not contain a description for swiveling. Column swiveling has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ei tiedossa.

track_sig2

string

Data source did not contain a description for track_sig2. Column track_sig2 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Junakulkutien päätekohta ... and first 25 characters of maximum string: Raideopastimen tunnus...

track_sig3

string

Data source did not contain a description for track_sig3. Column track_sig3 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is T-253 and maximum string is T-259.

track_sig4

string

Data source did not contain a description for track_sig4. Column track_sig4 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tiedossa and maximum string is Muu.

installat2

string

Data source did not contain a description for installat2. Column installat2 has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Merkkipylväs and maximum string is Raideopastin.

foundation

string

Data source did not contain a description for foundation. Column foundation has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ei tiedossa.

notes

string

Data source did not contain a description for notes. Column notes has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ['Ei tiedossa'].

name

string

Data source did not contain a description for name. Column name has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: TKUT 107 0200+0745 Junaku... and first 25 characters of maximum string: TKUT 107 0200+0745 Raideo...

owner

string

Data source did not contain a description for owner. Column owner has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ei tiedossa.

maintenanc

string

Data source did not contain a description for maintenanc. Column is empty.

maintenan0

string

Data source did not contain a description for maintenan0. Column is empty.

operating

string

Data source did not contain a description for operating. Column is empty.

accounting

string

Data source did not contain a description for accounting. Column is empty.

locationtr

string

Data source did not contain a description for locationtr. Column locationtr has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: TKUT 107.

routenumbe

int

Data source did not contain a description for routenumbe. Column routenumbe has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 332.

kmm

string

Data source did not contain a description for kmm. Column kmm has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 0200+0745.

int

Data source did not contain a description for km. Column km has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 200.

int

Data source did not contain a description for m. Column m has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 745.

geom_geojson

string

Geometry in GeoJSON format. Column is empty.

geom_geotext

string

Geometry as GeoText. Column is empty.

geom_center_x

float

Longitude of center. Column is empty.

geom_center_y

float

Latitude of center. Column is empty.

geom_type

string

Geometry type. Column is empty.

Additional Information


Last updated	September 8, 2020
Created	September 8, 2020
License	No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapter	ShapefileLoader
Country	fi
Database	fi_liikennevirasto
Id	034990ec-1c56-45ba-b759-85b91faa3583
Package id	efde6515-eeca-4159-b73e-cad3f5dfbedb
Revision id	2aa4308a-c718-4687-976b-135a701bca7d
State	active
Table	avointrack_sign__track_sign_latest_piped

Last updated

September 8, 2020

Created

September 8, 2020

License

No License Provided

Geographic coverage

Geographic granularity

Temporal coverage from

Temporal coverage to

Adapter

ShapefileLoader

Country

Database

fi_liikennevirasto

034990ec-1c56-45ba-b759-85b91faa3583

Package id

efde6515-eeca-4159-b73e-cad3f5dfbedb

Revision id

2aa4308a-c718-4687-976b-135a701bca7d

State

active

Table

avointrack_sign__track_sign_latest_piped

Track sign, Avointrack sign, Latest

Field Descriptions

No sample for this dataset

Additional Information