Tunnelit ja kallioleikkaukset

Tables

Rata tk yhteinen, Avoinrata tk yhteinen, LatestTSV
No description available for layer avoin:rata_tk_yhteinen (Tunnelit ja kallioleikkaukset)

Column Descriptions

Rata tk yhteinen, Avoinrata tk yhteinen, Latest

Column	Type	Comment
ajo_ohje	string	Data source did not contain a description for AJO_OHJE. Column ajo_ohje has 969 rows, out of which 951 are empty, making the null percent 98.14. First 25 characters of minimum string: ... and first 25 characters of maximum string: Valtatie 6>Simolantielle>...
alkukm_m	string	Data source did not contain a description for ALKUKM_M. Column alkukm_m has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0001+0100 and maximum string is 1023+0050.
alkupvm	date	Data source did not contain a description for ALKUPVM. Column is empty.
id	int	Data source did not contain a description for ID. Column id has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 349127 and maximum value is 904993.
kleik_poht	string	Data source did not contain a description for KLEIK_POHT. Column kleik_poht has 969 rows, out of which 949 are empty, making the null percent 97.94. First 25 characters of minimum string: ... and first 25 characters of maximum string: Viatek Oy tehny kallioper...
kunnpitaja	string	Data source did not contain a description for KUNNPITAJA. Column kunnpitaja has 969 rows, out of which 966 are empty, making the null percent 99.69. The single string value is: .
kpnimi	string	Data source did not contain a description for KPNIMI. Column is empty.
kpitoalue	int	Data source did not contain a description for KPITOALUE. Column kpitoalue has 969 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 12.
latauspvm	int	Data source did not contain a description for LATAUSPVM. Column is empty.
loc_error	string	Data source did not contain a description for LOC_ERROR. Column loc_error has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: NO ERROR.
loppukm_m	string	Data source did not contain a description for LOPPUKM_M. Column loppukm_m has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0002+0100 and maximum string is 1023+0080.
loppupvm	date	Data source did not contain a description for LOPPUPVM. Column is empty.
muutospvm	date	Data source did not contain a description for MUUTOSPVM. Column is empty.
nimi	string	Data source did not contain a description for NIMI. Column nimi has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 5-alueen kallioleikkaukse... and first 25 characters of maximum string: Äetsän kallioleikkaukset...
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 151057 and maximum value is 152029.
omistaja	string	Data source did not contain a description for OMISTAJA. Column omistaja has 969 rows, out of which 1 are empty, making the null percent 0.10. Minimum string is and maximum string is Liikennevirasto.
pluku_alku	int	Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10100 and maximum value is 10230050.
pluku_lopp	int	Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 20100 and maximum value is 10230080.
pluku_pist	int	Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10100 and maximum value is 10230050.
pelastalue	int	Data source did not contain a description for PELASTALUE. Column is empty.
pelareitti	string	Data source did not contain a description for PELAREITTI. Column is empty.
pistekm_m	string	Data source did not contain a description for PISTEKM_M. Column pistekm_m has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0001+0100 and maximum string is 1023+0050.
poisreitti	string	Data source did not contain a description for POISREITTI. Column is empty.
ratanumero	int	Data source did not contain a description for RATANUMERO. Column ratanumero has 969 rows, out of which 1 are empty, making the null percent 0.10. Minimum value is 1 and maximum value is 521.
sijraidtun	int	Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 969 rows, out of which 393 are empty, making the null percent 40.56. Minimum value is 2 and maximum value is 521.
trr_tunnus	string	Data source did not contain a description for TRR_TUNNUS. Column trr_tunnus has 969 rows, out of which 896 are empty, making the null percent 92.47. Minimum string is and maximum string is Åminnen tunneli.
tyyppi	string	Data source did not contain a description for TYYPPI. Column tyyppi has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kallioleikkaus and maximum string is Tunneli.
valmvuosi	int	Data source did not contain a description for VALMVUOSI. Column valmvuosi has 969 rows, out of which 823 are empty, making the null percent 84.93. Minimum value is 1926 and maximum value is 2018.
irrotus_pv	timestamp	Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-05-25 21:03:23 and maximum value is 2020-05-25 21:03:27.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (21.2323497939... and first 25 characters of maximum string: MULTILINESTRING ((29.7710...
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 969 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_MULTILINESTRING.

Additional Info

Last Updated	September 10, 2020
Created	July 9, 2018