Street Part Line
Click here for a data sample
This table contains data from 'Helsingin kaupunkiympariston toimiala' website in Finland. It consists of various columns such as _extract_date, _row_number, osan_id, paatyyppi, paatyyppi_c2, alatyyppi, alatyyppi_c4, materiaali, materiaal0, rakenteell, rakenteel0, talvikunno, talvikunn0, tkp_kiiree, tyhjentava, yllapitolu, yllapitol0, yllapitolk, puhtaanapi, puhtaanap0, puhtaanap1, pituus, leveys, pinta_ala, kadun_nimi, katualueen, katualuee0, katualuee1, osan_nro, paivitetty, geom_geojson, geom_geotext, geom_type, geom_centroid, geom_center_x, and geom_center_y. This table can be utilized for data analytics purposes such as analyzing the length, width, and area of the street parts, identifying the material used for construction, determining the maintenance type and level, and examining the geographical features of the street parts.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted |
|---|
| _row_number | long | The unique identifier of each row |
|---|
| osan_id | int | The unique identifier of the part |
|---|
| paatyyppi | string | The main type of the part |
|---|
| paatyyppi_c2 | int | The secondary type of the part |
|---|
| alatyyppi | string | The sub-type of the part |
|---|
| alatyyppi_c4 | int | The secondary sub-type of the part |
|---|
| materiaali | string | The material of the part |
|---|
| materiaal0 | int | The secondary material of the part |
|---|
| rakenteell | string | The structural information of the part |
|---|
| rakenteel0 | int | The secondary structural information of the part |
|---|
| talvikunno | string | The winter maintenance information of the part |
|---|
| talvikunn0 | int | The secondary winter maintenance information of the part |
|---|
| tkp_kiiree | string | The urgency level of the maintenance |
|---|
| tyhjentava | string | The emptying information of the part |
|---|
| yllapitolu | string | The maintenance type of the part |
|---|
| yllapitol0 | int | The secondary maintenance type of the part |
|---|
| yllapitolk | string | The maintenance class of the part |
|---|
| puhtaanapi | string | The cleanliness information of the part |
|---|
| puhtaanap0 | int | The secondary cleanliness information of the part |
|---|
| puhtaanap1 | int | Additional cleanliness information of the part |
|---|
| pituus | int | The length of the part |
|---|
| leveys | int | The width of the part |
|---|
| pinta_ala | int | The surface area of the part |
|---|
| kadun_nimi | string | The street name of the part |
|---|
| katualueen | string | The street area information of the part |
|---|
| katualuee0 | int | The secondary street area information of the part |
|---|
| katualuee1 | int | Additional street area information of the part |
|---|
| osan_nro | int | The part number |
|---|
| paivitetty | string | The date of the last update for the part |
|---|
| geom_geojson | string | The geometry information in GeoJSON format |
|---|
| geom_geotext | string | The geometry information 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 information |
|---|
