To download the data set, please sign up or log in

Yleisten alueiden rekisteri, katuosat (line)

Yleisten alueiden rekisteri, katuosat (line)

Tables

Column Descriptions

Ylre katuosat lineline, Hkrylre katuosat line, Latest

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 130909 and maximum value is 566848.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kalusteet ja leikkiväline... and first 25 characters of maximum string: Varusteet...
paatyyppi_c2 int Data source did not contain a description for paatyyppi_c2. Column paatyyppi_c2 has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 26 and maximum value is 32.
alatyyppi string Data source did not contain a description for alatyyppi. Column alatyyppi has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aidat and maximum string is Verkkoaita.
alatyyppi_c4 int Data source did not contain a description for alatyyppi_c4. Column alatyyppi_c4 has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 238 and maximum value is 495.
materiaali string Data source did not contain a description for materiaali. Column materiaali has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aco Drain tmv and maximum string is Verkkoaita.
materiaal0 int Data source did not contain a description for materiaal0. Column materiaal0 has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 82 and maximum value is 7256.
rakenteell string Data source did not contain a description for rakenteell. Column rakenteell has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HELEN and maximum string is Valtio.
rakenteel0 int Data source did not contain a description for rakenteel0. Column rakenteel0 has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 41 and maximum value is 601.
talvikunno string Data source did not contain a description for talvikunno. Column talvikunno has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei talvikunnossapitoa and maximum string is Valtio, Ely-keskus.
talvikunn0 int Data source did not contain a description for talvikunn0. Column talvikunn0 has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 41 and maximum value is 383.
tkp_kiiree string Data source did not contain a description for tkp_kiiree. Column is empty.
tyhjentava string Data source did not contain a description for tyhjentava. Column tyhjentava has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A-luokka and maximum string is Ei talvikunnossapitoa.
yllapitolu string Data source did not contain a description for yllapitolu. Column yllapitolu has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is H1 and maximum string is KC3.
yllapitol0 int Data source did not contain a description for yllapitol0. Column yllapitol0 has 3600 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 90.
yllapitolk string Data source did not contain a description for yllapitolk. Column yllapitolk has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Edustuskatuvihreä and maximum string is Yleiskatuvihreä.
puhtaanapi string Data source did not contain a description for puhtaanapi. Column puhtaanapi has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei toimenpiteitä and maximum string is Kiinteistö / Yksityinen.
puhtaanap0 int Data source did not contain a description for puhtaanap0. Column puhtaanap0 has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 7 and maximum value is 183.
puhtaanap1 int Data source did not contain a description for puhtaanap1. Column puhtaanap1 has 3600 rows, out of which 122 are empty, making the null percent 3.39. Minimum value is 1 and maximum value is 5.
pituus int Data source did not contain a description for pituus. Column pituus has 3600 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 788.
leveys int Data source did not contain a description for leveys. Column leveys has 3600 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 12.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 3600 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 3451.
kadun_nimi string Data source did not contain a description for kadun_nimi. Column kadun_nimi has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A03 and maximum string is Ylä-Malmin tori.
katualueen string Data source did not contain a description for katualueen. Column katualueen has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asuntokatu and maximum string is Tori.
katualuee0 int Data source did not contain a description for katualuee0. Column katualuee0 has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 64 and maximum value is 31935.
katualuee1 int Data source did not contain a description for katualuee1. Column katualuee1 has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 9129.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 3600 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 1264.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3600 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.8329856383... and first 25 characters of maximum string: LINESTRING (25.2321446081...
geom_center_x float Longitude of center. Column is empty.
geom_center_y float Latitude of center. Column is empty.
geom_type string Geometry type. Column geom_type has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING.

Additional Info

Last Updated September 7, 2020
Created August 6, 2018