Version History of Rents Audiences for Winkki Rents Audiences Polygon
Click here for a data sample
This table contains the version history of the rows from the Helsingin kaupunkiympariston toimiala database table 'winkki_rents_audiencespolygon'. Each row in this table represents a specific version of a row in the base table. The '_start_date' column stores the date when the row was extracted from the data source, while the '_end_date' column stores the date when a new version of the row was extracted. If the '_end_date' value is null, it signifies that the row is the most recent version. The data in this table is sourced from the website of 'Helsingin City Environment', which originates from Finland (ISO country code: 'FI'). Analyzing this data can provide insights into the historical changes and updates made to the rental audience polygon information, event details, location information, license details, and geometrical attributes. By examining the changes over time, trends in event audience information, rental licenses, and event locations can be identified, aiding in data-driven decision making.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date indicating the validity period of the row version. |
|---|
| _end_date | date | The end date indicating the validity period of the row version. |
|---|
| _row_number | long | The number assigned to each row in the table. |
|---|
| event_iden | string | The identifier of the event associated with the row version. |
|---|
| event_star | string | The start date of the event. |
|---|
| event_sta0 | timestamp | The start time of the event. |
|---|
| event_endd | string | The end date of the event. |
|---|
| event_endt | timestamp | The end time of the event. |
|---|
| event_desc | string | The description of the event. |
|---|
| location_d | string | The location of the event. |
|---|
| licence_id | int | The identifier of the licence associated with the row version. |
|---|
| licence_i0 | string | The internal identifier of the licence. |
|---|
| licence_ty | string | The type of licence. |
|---|
| rental_sub | string | The rental subject associated with the row version. |
|---|
| licence_st | string | The status of the licence. |
|---|
| lic_startd | timestamp | The start date of the licence. |
|---|
| licence_en | string | The end date of the licence. |
|---|
| lic_enddat | timestamp | The end date of the licence. |
|---|
| licence_s0 | string | The status of the licence. |
|---|
| licence_de | string | The description of the licence. |
|---|
| licence_ap | string | The application associated with the licence. |
|---|
| restaurant | string | The name of the restaurant associated with the row version. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry 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. |
|---|
