Ilmaisin

Tables

Rata ilmaisin, Avoinrata ilmaisin, LatestTSV
No description available for layer avoin:rata_ilmaisin (Ilmaisin)

Column Descriptions

Rata ilmaisin, Avoinrata ilmaisin, Latest

Column	Type	Comment
alkukm_m	string	Data source did not contain a description for ALKUKM_M. Column alkukm_m has 138 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0004+0988 and maximum string is 1020+0559.
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 138 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 349561 and maximum value is 901851.
irrotus_pv	timestamp	Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 138 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:05:33 and maximum value is 2020-05-25 21:05:35.
kpitoalue	int	Data source did not contain a description for KPITOALUE. Column kpitoalue has 138 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 138 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 138 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0004+0988 and maximum string is 1020+0559.
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 138 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 35329 and maximum value is 35467.
pistekm_m	string	Data source did not contain a description for PISTEKM_M. Column pistekm_m has 138 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0004+0988 and maximum string is 1020+0559.
pluku_alku	int	Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 138 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 40988 and maximum value is 10200559.
pluku_lopp	int	Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 138 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 40988 and maximum value is 10200559.
pluku_pist	int	Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 138 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 40988 and maximum value is 10200559.
ratanumero	int	Data source did not contain a description for RATANUMERO. Column ratanumero has 138 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 751.
sijraidtun	int	Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 138 rows, out of which 87 are empty, making the null percent 63.04. Minimum value is 2 and maximum value is 751.
tyyppi	string	Data source did not contain a description for TYYPPI. Column tyyppi has 138 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kuumakäynti-ilmaisin and maximum string is Virroitinvalvontakamera.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 138 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 (22.36143625416631 ... and first 25 characters of maximum string: POINT (30.61706688138272 ...
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 138 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