Lipas 207 opastuspiste

Tables

Lipas 207 Opastuspiste, Lipaslipas 207 OpastuspisteTSV
No description available for layer lipas:lipas_207_opastuspiste (lipas_207_opastuspiste)

Column Descriptions

Lipas 207 Opastuspiste, Lipaslipas 207 Opastuspiste

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 622 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 508826 and maximum value is 529913.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 622 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aconitum-kierroksen opast... and first 25 characters of maximum string: Huuhkajankierroksen P-pai...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 622 rows, out of which 516 are empty, making the null percent 82.96. First 25 characters of minimum string: ... and first 25 characters of maximum string: Kannbrobacken idrottområd...
nimi_en	string	Data source did not contain a description for nimi_en. Column is empty.
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 622 rows, out of which 376 are empty, making the null percent 60.45. Minimum string is and maximum string is kitee@kitee.fi.
www	string	Data source did not contain a description for www. Column www has 622 rows, out of which 170 are empty, making the null percent 27.33. First 25 characters of minimum string: ... and first 25 characters of maximum string: http://www.kitee.fi/retke...
puhelinnum	int	Data source did not contain a description for puhelinnum. Column puhelinnum has 622 rows, out of which 548 are empty, making the null percent 88.10. Minimum value is 983911 and maximum value is 505509747.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 622 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.
vapaa_kayt	string	Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 622 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.
rakennusvu	int	Data source did not contain a description for rakennusvu. Column rakennusvu has 622 rows, out of which 498 are empty, making the null percent 80.06. Minimum value is 1935 and maximum value is 2018.
peruskorja	int	Data source did not contain a description for peruskorja. Column peruskorja has 622 rows, out of which 606 are empty, making the null percent 97.43. Minimum value is 1997 and maximum value is 2018.
omistaja	string	Data source did not contain a description for omistaja. Column omistaja has 622 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Valtio.
yllapitaja	string	Data source did not contain a description for yllapitaja. Column yllapitaja has 622 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Valtio.
katuosoite	string	Data source did not contain a description for katuosoite. Column katuosoite has 622 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is (Läntinen) Källvikintie 6 and maximum string is Rautavaarantie 2640.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 622 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 99830.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 622 rows, out of which 102 are empty, making the null percent 16.40. Minimum string is and maximum string is Korpijärvi.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 622 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Enontekiö and maximum string is Lapinlahti.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 622 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 47 and maximum value is 977.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 622 rows, out of which 424 are empty, making the null percent 68.17. Minimum string is and maximum string is Korpijärvi.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 622 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 207.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 622 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Opastuspiste.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
parkkipaik	boolean	Data source did not contain a description for parkkipaik.
yleiso_wc	boolean	Data source did not contain a description for yleiso_wc.
saa_julkai	boolean	Data source did not contain a description for saa_julkai.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 622 rows, out of which 274 are empty, making the null percent 44.05. First 25 characters of minimum string: ... and first 25 characters of maximum string: Latujen ja pururadan opas...
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 622 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.498047478433712... and first 25 characters of maximum string: POINT (28.101277509438333...
geom_center_x	float	Longitude of center. Column geom_center_x has 622 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.50 and maximum value is 31.29.
geom_center_y	float	Latitude of center. Column geom_center_y has 622 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.87 and maximum value is 68.39.
geom_type	string	Geometry type. Column geom_type has 622 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.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	May 5, 2019
Created	June 16, 2018