Liikennepaikat

Tables

Rautatieliikennepaikka, Avoinrautatieliikennepaikka, LatestTSV
Rautatieliikennepaikat ovat pistemäisiä kohteita, joissa junat pysähtyvät. Pisteen sijainti kuvaa useimmiten mahdollisen asemarakennuksen sijaintia. Liikennevirasto ei vastaa luovutettavien tietojen oikeellisuudesta eikä vastaa aineiston käytöstä tietojen käyttäjälle tai kolmannelle osapuolelle mahdollisesti aiheutuvista välittömistä tai välillisistä vahingoista.

Column Descriptions

Rautatieliikennepaikka, Avoinrautatieliikennepaikka, Latest

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 193586 and maximum value is 195174.
id	int	Data source did not contain a description for ID. Column id has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 829.
nimi	string	Data source did not contain a description for NIMI. Column nimi has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahonp?? and maximum string is Äänekoski.
toinen_nim	string	Data source did not contain a description for TOINEN_NIM. Column toinen_nim has 935 rows, out of which 665 are empty, making the null percent 71.12. Minimum string is and maximum string is Övertorneå.
lyhenne	string	Data source did not contain a description for LYHENNE. Column lyhenne has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aho and maximum string is Äs.
koodi	int	Data source did not contain a description for KOODI. Column koodi has 935 rows, out of which 1 are empty, making the null percent 0.11. Minimum value is 1 and maximum value is 99999.
hlo_tavara	string	Data source did not contain a description for HLO_TAVARA. Column hlo_tavara has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is - and maximum string is T.
tyyppi_lyh	string	Data source did not contain a description for TYYPPI_LYH. Column tyyppi_lyh has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is LP and maximum string is SEIS.
tyyppi	string	Data source did not contain a description for TYYPPI. Column tyyppi has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is liikennepaikan osa and maximum string is seisake.
tila	string	Data source did not contain a description for TILA. Column tila has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: käytössä.
avattu	date	Data source did not contain a description for AVATTU. Column is empty.
lakk_pvm	date	Data source did not contain a description for LAKK_PVM. Column is empty.
paiv_pvm	date	Data source did not contain a description for PAIV_PVM. Column is empty.
lisatieto	string	Data source did not contain a description for LISATIETO. Column lisatieto has 935 rows, out of which 846 are empty, making the null percent 90.48. First 25 characters of minimum string: ... and first 25 characters of maximum string: Viinijärven/Kontiomäen su...
x_koord	int	Data source did not contain a description for X_KOORD. Column x_koord has 935 rows, out of which 142 are empty, making the null percent 15.19. Minimum value is 3192486 and maximum value is 6743350.
y_koord	int	Data source did not contain a description for Y_KOORD. Column y_koord has 935 rows, out of which 142 are empty, making the null percent 15.19. Minimum value is 3392053 and maximum value is 7476842.
kunta	string	Data source did not contain a description for KUNTA. Column kunta has 935 rows, out of which 45 are empty, making the null percent 4.81. Minimum string is and maximum string is Äänekoski.
liik_ohj	string	Data source did not contain a description for LIIK_OHJ. Column liik_ohj has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is E and maximum string is M.
radanpito	string	Data source did not contain a description for RADANPITO. Column radanpito has 935 rows, out of which 16 are empty, making the null percent 1.71. Minimum string is and maximum string is K.
kohtaus	string	Data source did not contain a description for KOHTAUS. Column kohtaus has 935 rows, out of which 16 are empty, making the null percent 1.71. Minimum string is and maximum string is K.
yks_rait	string	Data source did not contain a description for YKS_RAIT. Column yks_rait has 935 rows, out of which 15 are empty, making the null percent 1.60. Minimum string is and maximum string is K.
vaihtotmah	string	Data source did not contain a description for VAIHTOTMAH. Column vaihtotmah has 935 rows, out of which 18 are empty, making the null percent 1.93. Minimum string is and maximum string is K.
emo_id	int	Data source did not contain a description for EMO_ID. Column emo_id has 935 rows, out of which 771 are empty, making the null percent 82.46. Minimum value is 131 and maximum value is 762.
alkukm_m	string	Data source did not contain a description for ALKUKM_M. Column alkukm_m has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0159 and maximum string is 1065+0213.
loppukm_m	string	Data source did not contain a description for LOPPUKM_M. Column loppukm_m has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0159 and maximum string is 1069+0750.
pistekm_m	string	Data source did not contain a description for PISTEKM_M. Column pistekm_m has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0159 and maximum string is 1067+0206.
sij_rai_tu	int	Data source did not contain a description for SIJ_RAI_TU. Column sij_rai_tu has 935 rows, out of which 579 are empty, making the null percent 61.93. Minimum value is 2 and maximum value is 751.
rata_nro	int	Data source did not contain a description for RATA_NRO. Column rata_nro has 935 rows, out of which 12 are empty, making the null percent 1.28. Minimum value is 1 and maximum value is 751.
irrotus_pv	timestamp	Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 935 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-05-31 05:08:19 and maximum value is 2020-05-31 05:08:28.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 935 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.22995536519578 ... and first 25 characters of maximum string: POINT (30.941575866540454...
geom_center_x	double	Longitude of the centroid of the geometry. Column is empty.
geom_center_y	double	Latitude of the centroid of the geometry. Column is empty.
geom_type	string	Geometry type. Column geom_type has 935 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.

Additional Info

Last Updated	September 11, 2020
Created	July 9, 2018