MML - Maastotietokanta - rakennelma

Tables

• Rakennelma, MaastotietokantarakennelmaTSV

  Maanmittauslaitoksen maastotietokannan rakennelmat (viivamuotoinen geometria)

• features
• rakennelma

Column Descriptions

Rakennelma, Maastotietokantarakennelma

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 41729 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 41729.
gid	int	Data source did not contain a description for gid. Column gid has 41729 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 86739979 and maximum value is 1588023471.
sijaintita	int	Data source did not contain a description for sijaintita. Column sijaintita has 41729 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 100000.
korkeustar	int	Data source did not contain a description for korkeustar. Column korkeustar has 41729 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 100001.
aineistola	int	Data source did not contain a description for aineistola. Column aineistola has 41729 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 6.
alkupvm	timestamp	Data source did not contain a description for alkupvm. Column alkupvm has 41729 rows, out of which 3 are empty, making the null percent 0.01. Minimum value is 2006-11-17 00:00:00 and maximum value is 2014-08-15 00:00:00.
kulkutapa	int	Data source did not contain a description for kulkutapa. Column kulkutapa has 41729 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 2.
kohderyhma	int	Data source did not contain a description for kohderyhma. Column kohderyhma has 41729 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 27.
kohdeluokk	int	Data source did not contain a description for kohdeluokk. Column kohdeluokk has 41729 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 45700.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 41729 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 (19.5908920281... and first 25 characters of maximum string: LINESTRING (27.7219652116...
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 41729 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	April 12, 2019
Created	November 26, 2018