Address Point Registration Information for Open Data - Helsinki City Environment Sector, Finland
Click here for a data sample
This table contains data from the 'Helsinki City Environment Sector' website. It represents address information including various attributes such as the extracted date, row number, identifier, street address, postal code, coordinates, and other relevant data. The dataset originates from Finland (ISO country code 'fi'). This table can be utilized for data analytics to perform tasks such as geospatial analysis, address parsing, address quality assessment, and demographic analysis based on location.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted. |
|---|
| _row_number | long | The row number of the data. |
|---|
| id | int | The unique identifier of the record. |
|---|
| nimisto_id | int | The identifier of the location. |
|---|
| katuosoite | string | The street address. |
|---|
| adress | string | The address. |
|---|
| katunimi | string | The street name. |
|---|
| gatan | string | The street. |
|---|
| osoitenume | int | The address number. |
|---|
| nimistokoh | int | The location name. |
|---|
| nimistoko0 | string | The location. |
|---|
| olotila | int | The condition. |
|---|
| olotila_se | string | The condition (Swedish). |
|---|
| kunta | int | The municipality. |
|---|
| kaupungino | int | The town. |
|---|
| kaupungin0 | string | The city. |
|---|
| kaupungin1 | string | The city. |
|---|
| postinumer | int | The postal code. |
|---|
| n | int | The northern coordinate. |
|---|
| e | int | The eastern coordinate. |
|---|
| paivitetty | string | The date when the record was updated. |
|---|
| datanomist | string | The data owner. |
|---|
| 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 geometry center. |
|---|
| geom_center_y | double | The y-coordinate of the geometry center. |
|---|
| geom | binary | The geometry. |
|---|
