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

Velmu pisteet

Velmu pisteet

Tables

Column Descriptions

Velmu Pisteet, Velmuvelmu Pisteet

Column Type Comment
id int Data source did not contain a description for id. Column id has 7291 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 1457.
luke_id int Data source did not contain a description for luke_id. Column luke_id has 7291 rows, out of which 2340 are empty, making the null percent 32.09. Minimum value is 0 and maximum value is 345.
luke_id_gu int Data source did not contain a description for luke_id_gu. Column luke_id_gu has 7291 rows, out of which 1924 are empty, making the null percent 26.39. Minimum value is 1 and maximum value is 655.
menet_id int Data source did not contain a description for menet_id. Column menet_id has 7291 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 3.
menetelma string Data source did not contain a description for menetelma. Column menetelma has 7291 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Gulf-poikaspyynti and maximum string is Valkolevy ja kauha.
sijainti string Data source did not contain a description for sijainti. Column sijainti has 7291 rows, out of which 670 are empty, making the null percent 9.19. Minimum string is and maximum string is Tammisaari.
kausi string Data source did not contain a description for kausi. Column kausi has 7291 rows, out of which 7081 are empty, making the null percent 97.12. Minimum string is and maximum string is syksy.
vuosi int Data source did not contain a description for vuosi. Column vuosi has 7291 rows, out of which 184 are empty, making the null percent 2.52. Minimum value is 2004 and maximum value is 2014.
pvm string Data source did not contain a description for pvm. Column is empty.
pvm2 string Data source did not contain a description for pvm2. Column is empty.
pvm3 string Data source did not contain a description for pvm3. Column is empty.
pvm4 string Data source did not contain a description for pvm4. Column is empty.
pvm5 string Data source did not contain a description for pvm5. Column is empty.
laji_id int Data source did not contain a description for laji_id. Column laji_id has 7291 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 16.
laji string Data source did not contain a description for laji. Column laji has 7291 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ahven and maximum string is piikkikalat.
pres_abs int Data source did not contain a description for pres_abs. Column pres_abs has 7291 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 1.
cpu int Data source did not contain a description for cpu. Column cpu has 7291 rows, out of which 999 are empty, making the null percent 13.70. Minimum value is 0 and maximum value is 656.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 7291 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (20.799175964223814... and first 25 characters of maximum string: POINT (23.397383333042328...
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 7291 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created November 24, 2018
score 0.6707076328330466