Avoin Data Kaavamääräys
Tables
-
Kaavamaarayspolygon Data from Helsinki City Environment Department, FinlandTSV
This table contains data from 'Helsinki City Environment Department' in Finland. It provides information about various attributes related to 'Kaavamaarays Polygon'. The table includes columns such as '_extract_date', '_row_number', 'gid', 'kaavamaara', 'tyyppi', 'luokka', 'teksti', 'symbolityy', 'maanalaine', 'leveys', 'sitova', 'pintaala', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'angle', 'x_scale', 'y_scale', 'asemakaava', 'rakennusal', 'ymparistoa', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. The data in this table can be utilized for data analytics purposes like analyzing the distribution and density of 'Kaavamaarays' based on different 'tyyppi' and 'luokka' classifications, determining the area and dimensions of...
-
Version History of KaavamaaraysPolygon in Helsingin kaupunkiymparisto DB (Finland)TSV
This table stores the version history of rows extracted from the Helsingin kaupunkiympariston toimiala website. The rows contain various data related to avoindatakaavamaarayskaavamaarayspolygon. The table has additional columns '_start_date' and '_end_date' which represent the extraction dates of each row version. The table contains information such as 'gid', 'kaavamaara', 'tyyppi', 'luokka', 'teksti', 'symbolityy', 'maanalaine', 'leveys', 'sitova', 'pintaala', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'angle', 'x_scale', 'y_scale', 'asemakaava', 'rakennusal', 'ymparistoa', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The information in this table can be utilized in various data analytics tasks, such as analyzing the historical...
Column Descriptions
Kaavamaarayspolygon Data from Helsinki City Environment Department, Finland
Column | Type | Comment |
---|---|---|
_extract_date | date | The date this data was extracted. |
_row_number | long | The row number of the entry. |
gid | int | The unique identifier for the table entry. |
kaavamaara | string | Unknown description. |
tyyppi | string | Unknown description. |
luokka | string | Unknown description. |
teksti | string | Unknown description. |
symbolityy | string | Unknown description. |
maanalaine | boolean | Unknown description. |
leveys | string | Unknown description. |
sitova | boolean | Unknown description. |
pintaala | string | Unknown description. |
yhtluontip | string | Unknown description. |
yhtmuokkau | string | Unknown description. |
yhtdatanom | string | Unknown description. |
angle | string | Unknown description. |
x_scale | string | Unknown description. |
y_scale | string | Unknown description. |
asemakaava | string | Unknown description. |
rakennusal | string | Unknown description. |
ymparistoa | string | Unknown description. |
geom_geojson | string | Unknown description. |
geom_geotext | string | Unknown description. |
geom_type | string | Unknown description. |
geom_centroid | string | Unknown description. |
geom_center_x | double | Unknown description. |
geom_center_y | double | Unknown description. |
geom | binary | Unknown description. |
Version History of KaavamaaraysPolygon in Helsingin kaupunkiymparisto DB (Finland)
Column | Type | Comment |
---|---|---|
_start_date | date | The start date of the validity period for the row version. |
_end_date | date | The end date of the validity period for the row version. |
_row_number | long | The unique identifier of the row version. |
gid | int | The identifier of the row in the base table. |
kaavamaara | string | The value representing the 'kaavamaara' of the row in the base table. |
tyyppi | string | The type of the row in the base table. |
luokka | string | The classification of the row in the base table. |
teksti | string | The text associated with the row in the base table. |
symbolityy | string | The symbol type of the row in the base table. |
maanalaine | boolean | Indicates if the row in the base table is underground. |
leveys | string | The width of the row in the base table. |
sitova | boolean | Indicates if the row in the base table is binding. |
pintaala | string | The area of the row in the base table. |
yhtluontip | string | The timestamp of the row creation in the base table. |
yhtmuokkau | string | The timestamp of the row modification in the base table. |
yhtdatanom | string | The timestamp of the data nomination in the base table. |
angle | string | The angle of the row in the base table. |
x_scale | string | The X scale of the row in the base table. |
y_scale | string | The Y scale of the row in the base table. |
asemakaava | string | The asemakaava associated with the row in the base table. |
rakennusal | string | The rakennusal associated with the row in the base table. |
ymparistoa | string | The ymparistoa associated with the row in the base table. |
geom_geojson | string | The geometry of the row in GeoJSON format. |
geom_geotext | string | The geometry of the row in geotext format. |
geom_type | string | The type of the geometry associated with the row. |
geom_centroid | string | The centroid of the geometry associated with the row. |
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 associated with the row. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | April 23, 2024 |