_start_date | date | The start date of the validity period of the row version. |
_end_date | date | The end date of the validity period of the row version. |
_row_number | long | The row number of the version history row. |
osan_id | int | The ID of the base table row. |
paatyyppi | string | The main type of the base table row. |
paatyyppi_c2 | int | The secondary type of the base table row. |
alatyyppi | string | The sub-type of the base table row. |
alatyyppi_c4 | int | The secondary sub-type of the base table row. |
materiaali | string | The material of the base table row. |
materiaal0 | int | The alternative material of the base table row. |
rakenteell | string | The structural information of the base table row. |
rakenteel0 | int | The alternative structural information of the base table row. |
talvikunno | string | The winter condition of the base table row. |
talvikunn0 | int | The alternative winter condition of the base table row. |
tkp_kiiree | string | The urgency of the maintenance work for the base table row. |
tyhjentava | string | The clearance information of the base table row. |
yllapitolu | string | The maintenance class of the base table row. |
yllapitol0 | int | The alternative maintenance class of the base table row. |
yllapitolk | string | The actual maintenance class of the base table row. |
puhtaanapi | string | The cleanliness information of the base table row. |
puhtaanap0 | int | The alternative cleanliness information of the base table row. |
puhtaanap1 | int | The secondary alternative cleanliness information of the base table row. |
pituus | int | The length of the base table row. |
leveys | int | The width of the base table row. |
pinta_ala | int | The surface area of the base table row. |
kadun_nimi | string | The street name of the base table row. |
katualueen | string | The street area of the base table row. |
katualuee0 | int | The alternative street area of the base table row. |
katualuee1 | int | The secondary alternative street area of the base table row. |
osan_nro | int | The part number of the base table row. |
paivitetty | string | The update date of the base table row. |
geom_geojson | string | The geometry data in GeoJSON format. |
geom_geotext | string | The geometry data in Geotext format. |
geom_type | string | The type of geometry data. |
geom_centroid | string | The centroid of the geometry data. |
geom_center_x | double | The x-coordinate of the center of the geometry data. |
geom_center_y | double | The y-coordinate of the center of the geometry data. |
geom | binary | The geometry data. |