Opastimet

Tables

Rata opastin, Avoinrata opastin, LatestTSV
No description available for layer avoin:rata_opastin (Opastimet)

Column Descriptions

Rata opastin, Avoinrata opastin, Latest

Column	Type	Comment
alku_jppvm	date	Data source did not contain a description for ALKU_JPPVM. Column is empty.
alkukm_m	string	Data source did not contain a description for ALKUKM_M. Column alkukm_m has 5344 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0544 and maximum string is 1066+0650.
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 5344 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 349525 and maximum value is 909458.
kpitoalue	int	Data source did not contain a description for KPITOALUE. Column kpitoalue has 5344 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	date	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 5344 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.
lo_etj_pvm	date	Data source did not contain a description for LO_ETJ_PVM. Column is empty.
lopp_jppvm	date	Data source did not contain a description for LOPP_JPPVM. Column is empty.
loppukm_m	string	Data source did not contain a description for LOPPUKM_M. Column loppukm_m has 5344 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0544 and maximum string is 1066+0650.
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 is empty.
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 5344 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 697249 and maximum value is 702766.
opa_ajs_vp	string	Data source did not contain a description for OPA_AJS_VP. Column opa_ajs_vp has 5344 rows, out of which 4966 are empty, making the null percent 92.93. Minimum string is and maximum string is X.
opastinnum	int	Data source did not contain a description for OPASTINNUM. Column opastinnum has 5344 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 8183.
opastsuun	string	Data source did not contain a description for OPASTSUUN. Column opastsuun has 5344 rows, out of which 3 are empty, making the null percent 0.06. Minimum string is and maximum string is X.
opasttunn	string	Data source did not contain a description for OPASTTUNN. Column opasttunn has 5344 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 001 and maximum string is Ä2.
opasttyypp	string	Data source did not contain a description for OPASTTYYPP. Column opasttyypp has 5344 rows, out of which 1 are empty, making the null percent 0.02. Minimum string is and maximum string is Tk, turvattava kohta.
pluku_alku	int	Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 5344 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 544 and maximum value is 10660650.
pluku_lopp	int	Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 5344 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 544 and maximum value is 10660650.
pluku_pist	int	Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 5344 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 544 and maximum value is 10660650.
pistekm_m	string	Data source did not contain a description for PISTEKM_M. Column pistekm_m has 5344 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0544 and maximum string is 1066+0650.
ratanumero	int	Data source did not contain a description for RATANUMERO. Column ratanumero has 5344 rows, out of which 10 are empty, making the null percent 0.19. Minimum value is 1 and maximum value is 751.
sijraidtun	int	Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 5344 rows, out of which 4120 are empty, making the null percent 77.10. Minimum value is 2 and maximum value is 751.
tarkenne	string	Data source did not contain a description for TARKENNE. Column tarkenne has 5344 rows, out of which 5236 are empty, making the null percent 97.98. Minimum string is and maximum string is B.
versio	string	Data source did not contain a description for VERSIO. Column versio has 5344 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Historia: 6... and first 25 characters of maximum string: S Kkn-Tku 4950 809 23049 ...
vo_etj_pvm	date	Data source did not contain a description for VO_ETJ_PVM. Column is empty.
irrotus_pv	timestamp	Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 5344 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:04:01 and maximum value is 2020-05-25 21:04:11.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 5344 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.231696957395496... and first 25 characters of maximum string: POINT (30.620869081662107...
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 5344 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 10, 2020
Created	July 9, 2018