Version history of the 'Opev Ooa Alaaste Suomi Tuleva' polygon table from the 'Helsinki City Environment Department' in Finland
Click here for a data sample
This table contains the version history of rows from the 'avoindataopev_ooa_alaaste_suomi_tuleva__opev_ooa_alaaste_suomi_tulevapolygon' base table. Each row represents a specific version of a geographical entity related to education in Finland. The '_start_date' column indicates the date when the row was extracted from the data source, while the '_end_date' column represents 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 table includes various columns such as 'id', 'aluejako', 'kunta', 'tunnus', 'nimi_fi', 'nimi_se', 'toimipiste', 'yhtluontip', 'yhtdatanom', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' which store information related to the geographical entity, educational institutions, creation and modification dates, and geometrical data. This data could be utilized in data analytics to study the spatial distribution of educational regions, analyze the prevalence of educational institutions in different municipalities, track changes over time, and perform geospatial analyses.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | Column indicating the start date of the validity period for the row version. |
|---|
| _end_date | date | Column indicating the end date of the validity period for the row version. |
|---|
| _row_number | long | Column representing the row number of the version history table. |
|---|
| id | int | Column representing the identifier of the base table row. |
|---|
| aluejako | string | Column representing the distribution area of the base table row. |
|---|
| kunta | int | Column representing the municipality of the base table row. |
|---|
| tunnus | int | Column representing the code identifier of the base table row. |
|---|
| nimi_fi | string | Column representing the Finnish name of the base table row. |
|---|
| nimi_se | string | Column representing the Swedish name of the base table row. |
|---|
| toimipiste | int | Column representing the location of the office for the base table row. |
|---|
| yhtluontip | string | Column representing the creation date of the base table row. |
|---|
| yhtdatanom | string | Column representing the data retrieval date of the base table row. |
|---|
| paivitetty | string | Column representing the last updated date of the base table row. |
|---|
| geom_geojson | string | Column containing the geometry data of the base table row in GeoJSON format. |
|---|
| geom_geotext | string | Column containing the geometry data of the base table row in geotext format. |
|---|
| geom_type | string | Column representing the geometry type of the base table row. |
|---|
| geom_centroid | string | Column representing the centroid of the geometry of the base table row. |
|---|
| geom_center_x | double | Column representing the x-coordinate of the center of the geometry of the base table row. |
|---|
| geom_center_y | double | Column representing the y-coordinate of the center of the geometry of the base table row. |
|---|
| geom | binary | Column containing the geometry data of the base table row. |
|---|
