Traffic Routes - Helsingin kaupunkiympariston toimiala - Finland
Click here for a data sample
This table contains data on traffic routes in the city of Helsinki. The data is sourced from the website of Helsingin kaupunkiympäristön toimiala, which originates from Finland (ISO country code 'fi'). The table records various details about the traffic routes, such as the extraction date, row number, route type, route number, route name, the date of traffic, the geographic coordinates of the route in both GeoJSON and GeoText format, the type of geometry, the centroid of the geometry, the x-coordinate of the center point, the y-coordinate of the center point, and the complete geometry of the route.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted. |
|---|
| _row_number | long | The sequential number of each row in the table. |
|---|
| vaylatyypp | string | The type of waterway. |
|---|
| dgntasonro | int | The level number of the waterway. |
|---|
| dgntasonim | string | The name of the waterway. |
|---|
| ajo_pvm | timestamp | The date when the measurement was taken. |
|---|
| geom_geojson | string | The geometric representation of the waterway in GeoJSON format. |
|---|
| geom_geotext | string | The geometric representation of the waterway in well-known text format. |
|---|
| geom_type | string | The type of geometric representation used for the waterway. |
|---|
| geom_centroid | string | The centroid point of the waterway. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the waterway. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the waterway. |
|---|
| geom | binary | The full geometric representation of the waterway. |
|---|
