Yleisten alueiden rekisteri, katuosat (point)

Tables

Ylre Katuosat Pointpoint, Hkrylre Katuosat PointTSV
Luontotietojärjestelmässä voi tutustua Helsingin monipuoliseen luontoon. Järjestelmän keskeisimpiä luontoaineistoja ovat luonnonsuojelukohteet, arvokkaat kasvisto- ja kasvillisuuskohteet, linnustollisesti arvokkaat kohteet, arvokkaat geologiset kohteet, tärkeät lepakkoalueet, kääpäkohteet ja arvokkaat metsäluonnon monimuotoisuuskohteet. Palvelusta on yleisöversio ja virkaversio. Yleisöversion tietosisältöä on suodatettu luonnonsuojelusyistä. Virkaversiota käytetään kaupungin sisäisissä suunnittelu- ja tutkimustarkoituksissa. Helsingin Luontotietojärjestelmän avoimena datana julkaistava aineisto koostuu seuraavista WFS-rajapinnan tasoista, jotka on ryhmitelty rauhoitettuihin / rauhoitettaviin kohteisiin, arvokkaisiin luontokohteisiin, vesistöaineistoihin ja muuhun luontotietooon....

Column Descriptions

Ylre Katuosat Pointpoint, Hkrylre Katuosat Point

Column	Type	Comment
osan_id	int	Data source did not contain a description for osan_id. Column osan_id has 117015 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 124586 and maximum value is 562551.
paatyyppi	string	Data source did not contain a description for paatyyppi. Column paatyyppi has 117015 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 117015 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24 and maximum value is 32.
alatyyppi	string	Data source did not contain a description for alatyyppi. Column alatyyppi has 117015 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Valaisimet and maximum string is Yleisökäymälä.
alatyyppi_c4	int	Data source did not contain a description for alatyyppi_c4. Column alatyyppi_c4 has 117015 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60 and maximum value is 515.
materiaali	string	Data source did not contain a description for materiaali. Column materiaali has 117015 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Valaisinpylväs and maximum string is Valonheittäjä.
materiaal0	int	Data source did not contain a description for materiaal0. Column materiaal0 has 117015 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 7209.
rakenteell	string	Data source did not contain a description for rakenteell. Column rakenteell has 117015 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaupunkiympäristö Länsi and maximum string is YTV.
rakenteel0	int	Data source did not contain a description for rakenteel0. Column rakenteel0 has 117015 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 117015 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 117015 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 tkp_kiiree has 117015 rows, out of which 116996 are empty, making the null percent 99.98. Minimum string is and maximum string is C - hoitotapa.
tyhjentava	string	Data source did not contain a description for tyhjentava. Column tyhjentava has 117015 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 117015 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is KA3 and maximum string is KC3.
yllapitol0	int	Data source did not contain a description for yllapitol0. Column yllapitol0 has 117015 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 117015 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Tonttikadut ja vähäliiken... and first 25 characters of maximum string: Yleiskatuvihreä...
puhtaanapi	string	Data source did not contain a description for puhtaanapi. Column puhtaanapi has 117015 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaupunkiympäristö Länsi and maximum string is YTV.
puhtaanap0	int	Data source did not contain a description for puhtaanap0. Column puhtaanap0 has 117015 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 241.
puhtaanap1	int	Data source did not contain a description for puhtaanap1. Column puhtaanap1 has 117015 rows, out of which 880 are empty, making the null percent 0.75. Minimum value is 1 and maximum value is 5.
pituus	int	Data source did not contain a description for pituus. Column pituus has 117015 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
leveys	int	Data source did not contain a description for leveys. Column leveys has 117015 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 36.
pinta_ala	int	Data source did not contain a description for pinta_ala. Column pinta_ala has 117015 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
kadun_nimi	string	Data source did not contain a description for kadun_nimi. Column kadun_nimi has 117015 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kuusamakuja and maximum string is Örskintie.
katualueen	string	Data source did not contain a description for katualueen. Column katualueen has 117015 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 117015 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 31935.
katualuee1	int	Data source did not contain a description for katualuee1. Column katualuee1 has 117015 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 9129.
osan_nro	int	Data source did not contain a description for osan_nro. Column osan_nro has 117015 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 10116.
paivitetty	string	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 117015 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 (24.897032888160954... and first 25 characters of maximum string: POINT (25.230517898253343...
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 117015 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	January 20, 2024
Created	October 22, 2018