To download the data set, please sign up or log in
Toimipisterekisteri, palvelut
Tables
-
Tprek Unit Services, Heltprek Unit ServicesTSV
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
Tprek Unit Services, Heltprek Unit Services
| Column | Type | Comment |
|---|---|---|
| address_st | string | Data source did not contain a description for address_st. Column address_st has 32892 rows, out of which 191 are empty, making the null percent 0.58. First 25 characters of minimum string: ... and first 25 characters of maximum string: Mustikkamaantie 8, 00570 ... |
| unit_name | string | Data source did not contain a description for unit_name. Column unit_name has 32892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: "Mortuis" memorial commem... and first 25 characters of maximum string: Mustikkamaan kuntoradan l... |
| address_s0 | string | Data source did not contain a description for address_s0. Column address_s0 has 32892 rows, out of which 191 are empty, making the null percent 0.58. First 25 characters of minimum string: ... and first 25 characters of maximum string: Mustikkamaantie 8, 00570 ... |
| street_nam | string | Data source did not contain a description for street_nam. Column street_nam has 32892 rows, out of which 191 are empty, making the null percent 0.58. Minimum string is and maximum string is MUSTIKKAMAANTIE. |
| address_no | int | Data source did not contain a description for address_no. Column address_no has 32892 rows, out of which 3154 are empty, making the null percent 9.59. Minimum value is 0 and maximum value is 14205. |
| unit_name0 | string | Data source did not contain a description for unit_name0. Column unit_name0 has 32892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 00130Gallery... and first 25 characters of maximum string: Mustikkamaan kuntoradan l... |
| address_s1 | string | Data source did not contain a description for address_s1. Column address_s1 has 32892 rows, out of which 191 are empty, making the null percent 0.58. First 25 characters of minimum string: ... and first 25 characters of maximum string: Mustikkamaantie 8, 00570 ... |
| service_tr | int | Data source did not contain a description for service_tr. Column service_tr has 32892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 9. |
| dept_id | string | Data source did not contain a description for dept_id. Column dept_id has 32892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1000-SF and maximum string is LIV-LIPAS. |
| unit_name1 | string | Data source did not contain a description for unit_name1. Column unit_name1 has 32892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 00130Gallery... and first 25 characters of maximum string: Mustikkamaan kuntoradan l... |
| service_na | string | Data source did not contain a description for service_na. Column service_na has 32892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A1-Chinese and maximum string is Ski track. |
| address_ci | string | Data source did not contain a description for address_ci. Column address_ci has 32892 rows, out of which 164 are empty, making the null percent 0.50. Minimum string is and maximum string is HELSINKI. |
| service_n0 | string | Data source did not contain a description for service_n0. Column service_n0 has 32892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1. luokalta alkava Englan... and first 25 characters of maximum string: Latu... |
| id | int | Data source did not contain a description for id. Column id has 32892 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 56077. |
| service_n1 | string | Data source did not contain a description for service_n1. Column service_n1 has 32892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A1-engelska and maximum string is Skidspår. |
| city_id | int | Data source did not contain a description for city_id. Column city_id has 32892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 49 and maximum value is 1012. |
| service_id | int | Data source did not contain a description for service_id. Column service_id has 32892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 25000 and maximum value is 36089. |
| address_zi | int | Data source did not contain a description for address_zi. Column address_zi has 32892 rows, out of which 778 are empty, making the null percent 2.37. Minimum value is 14 and maximum value is 99950. |
| address_n0 | int | Data source did not contain a description for address_n0. Column address_n0 has 32892 rows, out of which 31874 are empty, making the null percent 96.91. Minimum value is 2 and maximum value is 101. |
| address_le | string | Data source did not contain a description for address_le. Column address_le has 32892 rows, out of which 32493 are empty, making the null percent 98.79. Minimum string is and maximum string is A. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 32892 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 (19.934856057392704... and first 25 characters of maximum string: POINT (24.990089370962068... |
| 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 32892 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 17, 2024 |
|---|---|
| Created | October 22, 2018 |
| tablename | heltprek_unit_services__tprek_unit_services_all_piped |