To download the data set, please sign up or log in

Maankäyttö:Kantakartta:RaideliikenneRakenne

Maankäyttö:Kantakartta:RaideliikenneRakenne

Tables

Column Descriptions

Raideliikennerakenne, Kantaraideliikennerakenne, Full history

Column Type Comment
gml_id string Data source did not contain a description for gml_id. Column gml_id has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: RaideliikenneRakenne.1092... and first 25 characters of maximum string: RaideliikenneRakenne.9584...
kplkoodi int Data source did not contain a description for kplkoodi. Column kplkoodi has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 818110 and maximum value is 8181301.
sijaintiepavarmuus int Data source did not contain a description for sijaintiepavarmuus. Column sijaintiepavarmuus has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
luontitapa string Data source did not contain a description for luontitapa. Column luontitapa has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: maastomittaus.
alkupvm timestamp Data source did not contain a description for alkuPvm. Column alkupvm has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1998-06-01 17:20:15 and maximum value is 2019-01-14 14:27:59.
suuntakulma int Data source did not contain a description for suuntakulma. Column suuntakulma has 734 rows, out of which 77 are empty, making the null percent 10.49. Minimum value is 0 and maximum value is 6.
suuntakulma_uom string Data source did not contain a description for suuntakulma_uom. Column suuntakulma_uom has 734 rows, out of which 77 are empty, making the null percent 10.49. The single string value is: .
raideliikenteentyyppi string Data source did not contain a description for raideliikenteentyyppi. Column raideliikenteentyyppi has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: juna.
tyyppi string Data source did not contain a description for tyyppi. Column tyyppi has 734 rows, out of which 188 are empty, making the null percent 25.61. Minimum string is and maximum string is stoppari.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 734 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 (24.547546 60.... and first 25 characters of maximum string: POINT (24.8504592 60.2234...
geom_center_x float Longitude of center. Column geom_center_x has 734 rows, out of which 64 are empty, making the null percent 8.72. Minimum value is 24.56 and maximum value is 24.85.
geom_center_y float Latitude of center. Column geom_center_y has 734 rows, out of which 64 are empty, making the null percent 8.72. Minimum value is 60.18 and maximum value is 60.22.
geom_type string Geometry type. Column geom_type has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_POINT.
orig_extractdate string The date when the data was originally fetched from the source.

Raideliikennerakenne, Kantaraideliikennerakenne, Latest

Column Type Comment
gml_id string Data source did not contain a description for gml_id. Column gml_id has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: RaideliikenneRakenne.1092... and first 25 characters of maximum string: RaideliikenneRakenne.9584...
kplkoodi int Data source did not contain a description for kplkoodi. Column kplkoodi has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 818110 and maximum value is 8181301.
sijaintiepavarmuus int Data source did not contain a description for sijaintiepavarmuus. Column sijaintiepavarmuus has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
luontitapa string Data source did not contain a description for luontitapa. Column luontitapa has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: maastomittaus.
alkupvm timestamp Data source did not contain a description for alkuPvm. Column alkupvm has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1998-06-01 17:20:15 and maximum value is 2019-01-14 14:27:59.
suuntakulma int Data source did not contain a description for suuntakulma. Column suuntakulma has 734 rows, out of which 77 are empty, making the null percent 10.49. Minimum value is 0 and maximum value is 6.
suuntakulma_uom string Data source did not contain a description for suuntakulma_uom. Column suuntakulma_uom has 734 rows, out of which 77 are empty, making the null percent 10.49. The single string value is: .
raideliikenteentyyppi string Data source did not contain a description for raideliikenteentyyppi. Column raideliikenteentyyppi has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: juna.
tyyppi string Data source did not contain a description for tyyppi. Column tyyppi has 734 rows, out of which 188 are empty, making the null percent 25.61. Minimum string is and maximum string is stoppari.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 734 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 (24.547546 60.... and first 25 characters of maximum string: POINT (24.8504592 60.2234...
geom_center_x float Longitude of center. Column geom_center_x has 734 rows, out of which 64 are empty, making the null percent 8.72. Minimum value is 24.56 and maximum value is 24.85.
geom_center_y float Latitude of center. Column geom_center_y has 734 rows, out of which 64 are empty, making the null percent 8.72. Minimum value is 60.18 and maximum value is 60.22.
geom_type string Geometry type. Column geom_type has 734 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_POINT.

Additional Info

Last Updated September 10, 2020
Created September 8, 2020