Building Restriction Area for Preparing Detailed Plan - Polygon
Click here for a data sample
The 'avoindatarakennuskieltoalue_tunnus_asemakaavan_laatimiseksi__rakennuskieltoalue_tunnus_asemakaavan_laatimiseksipolygon' table contains data sourced from the website of 'Helsinki City Environment Sector' in Finland (ISO country code: fi). It includes various attributes related to building prohibition areas for the drafting of detailed plans. The table provides information such as extract date, row number, ID, type, building prohibition, expiration date, font style, font size, text direction, creation date, modification date, data owner, last update date, geospatial data in GeoJSON and geotext formats, geometry type, centroid coordinates, and the actual geometry itself. This data can be utilized in data analytics for various purposes such as spatial analysis, identifying areas where building is prohibited, monitoring changes in building prohibition areas over time, and understanding the characteristics of different types of building prohibitions.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date and time when the data was extracted. |
|---|
| _row_number | long | The row number of the data in the table. |
|---|
| id | int | The unique identifier for each record in the table. |
|---|
| tyyppi | string | The type of the data. |
|---|
| rakennuski | int | The building code. |
|---|
| paattymisp | string | The date when the record is scheduled to end. |
|---|
| tekstifont | string | The font used for the text. |
|---|
| tekstikoko | float | The font size used for the text. |
|---|
| tekstisuun | int | The text orientation. |
|---|
| luontipvm | string | The creation date of the record. |
|---|
| muokkauspv | string | The last modified date of the record. |
|---|
| datanomist | string | The owner of the data. |
|---|
| paivitetty | string | The timestamp of the latest update. |
|---|
| 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 geometric representation of the data. |
|---|
