Katujen kunnossapidon tilannekuva

Tables

• Ktkp Tilannekuva, Gisktkp TilannekuvaTSV

  Katujen kunnossapidon tilannekuva.

• features
• ktkp_tilannekuva2

Column Descriptions

Ktkp Tilannekuva, Gisktkp Tilannekuva

Column	Type	Comment
status	string	Data source did not contain a description for status. Column status has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: pe/muu.
reitti_nim	string	Data source did not contain a description for reitti_nim. Column reitti_nim has 7 rows, out of which 2 are empty, making the null percent 28.57. Minimum string is Lauranpolku and maximum string is Pohjoinen Rastitie.
tieluokka	string	Data source did not contain a description for tieluokka. Column tieluokka has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is kevytliikenne and maximum string is seututie.
avg_timest	string	Data source did not contain a description for avg_timest. Column is empty.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (25.0746103813... and first 25 characters of maximum string: LINESTRING (25.0755470998...
geom_center_x	double	Longitude of the centroid of the geometry. Column is empty.
geom_center_y	double	Latitude of the centroid of the geometry. Column is empty.
geom_type	string	Geometry type. Column geom_type has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	September 2, 2023
Created	October 22, 2018