Agenda Items in Helsingin kaupunkiympariston toimiala, Finland
Click here for a data sample
This table contains agenda items from the website of the Urban Environment Division of the City of Helsinki. The data originates from Finland (ISO country code 'fi'). It provides information about various agenda items such as their unique IDs, registration numbers, subjects, policy makers, meeting dates, meeting IDs, preparers, introducers, geographical coordinates, URLs for viewing, origin IDs, geojson and geotext formats of the geometry, geometry types, centroids, center coordinates, and the geometry itself. This data can be utilized for data analytics to analyze trends, patterns, and relationships within agenda items, as well as to perform spatial analysis based on the geographical coordinates.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted from the source. |
|---|
| _row_number | long | The sequential number of the row in the table. |
|---|
| id | int | The unique identifier for each record in the table. |
|---|
| register_i | string | The identifier of the register for the record. |
|---|
| subject | string | The subject of the record. |
|---|
| policymake | string | The policy maker associated with the record. |
|---|
| meeting_da | string | The date of the meeting associated with the record. |
|---|
| meeting_id | string | The unique identifier for the meeting associated with the record. |
|---|
| preparer | string | The person who prepared the record. |
|---|
| introducer | string | The entity that introduced the record. |
|---|
| geometry_t | string | The type of geometry associated with the record. |
|---|
| geometry_n | string | The name of the geometry associated with the record. |
|---|
| view_url | string | The URL for viewing the record. |
|---|
| origin_id | string | The identifier of the origin of the record. |
|---|
| geom_geojson | string | The geometry data in GeoJSON format. |
|---|
| geom_geotext | string | The geometry data in Geotext format. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry. |
|---|
| geom | binary | The geometry data. |
|---|
