Helsinki tiet mml 100 k

Tables

Helsinki Tiet Mml 100k, Faris Testhelsinki Tiet Mml 100kTSV
helsinki_tiet_mml_100k

Column Descriptions

Helsinki Tiet Mml 100k, Faris Testhelsinki Tiet Mml 100k

Column	Type	Comment
kohderyhma	int	Data source did not contain a description for Kohderyhma. Column kohderyhma has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 25.
vertikaali	string	Data source did not contain a description for Vertikaali. Column vertikaali has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -11 and maximum value is 1.
kohdeluokk	int	Data source did not contain a description for Kohdeluokk. Column kohdeluokk has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 12111 and maximum value is 12141.
tieluokka	int	Data source did not contain a description for Tieluokka. Column tieluokka has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -29999 and maximum value is 6.
valmiusast	string	Data source did not contain a description for Valmiusast. Column valmiusast has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 3.
tienumero	string	Data source did not contain a description for Tienumero. Column tienumero has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 40915.
paallyste	int	Data source did not contain a description for Paallyste. Column paallyste has 7577 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 2.
yksisuunta	string	Data source did not contain a description for Yksisuunta. Column yksisuunta has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
ajorataluk	string	Data source did not contain a description for Ajorataluk. Column ajorataluk has 7577 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 4.
id	int	Data source did not contain a description for ID. Column id has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21 and maximum value is 54.
tunnus	int	Data source did not contain a description for TUNNUS. Column tunnus has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 101 and maximum value is 801.
suurpiiri	int	Data source did not contain a description for SUURPIIRI. Column suurpiiri has 7577 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 8.
kunta	int	Data source did not contain a description for KUNTA. Column kunta has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 91.
nimi	string	Data source did not contain a description for NIMI. Column nimi has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ALPPIHARJU and maximum string is KALLIO.
nimi_se	string	Data source did not contain a description for NIMI_SE. Column nimi_se has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is BERGHÄLL and maximum string is ÅSHÖJDEN.
suurpiir00	string	Data source did not contain a description for SUURPIIR00. Column suurpiir00 has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ETELÄINEN and maximum string is KESKINEN.
suurpiir01	string	Data source did not contain a description for SUURPIIR01. Column suurpiir01 has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MELLERSTA and maximum string is VÄSTRA.
kunta_nimi	string	Data source did not contain a description for KUNTA_NIMI. Column kunta_nimi has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: HELSINKI.
kunta_ni00	string	Data source did not contain a description for KUNTA_NI00. Column kunta_ni00 has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: HELSINGFORS.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 7577 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 (24.8327191553... and first 25 characters of maximum string: LINESTRING (24.9822672760...
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 7577 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.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	April 12, 2019
Created	October 22, 2018