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

Sote toimeentulotukialue

Sote toimeentulotukialue

Tables

Column Descriptions

Sote toimeentulotukialue, Helsote toimeentulotukialue, Full history

Column Type Comment
gml_id string Data source did not contain a description for gml_id. Column gml_id has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is id110200 and maximum string is id110680.
aluejako string Data source did not contain a description for aluejako. Column aluejako has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: TOIMEENTULOTUKIALUEJAKO.
kunta int Data source did not contain a description for kunta. Column kunta has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 91.
nimi string Data source did not contain a description for nimi. Column nimi has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: ETELÄN SOSIAALIOHJAUS 1 /... and first 25 characters of maximum string: POHJOISEN SOSIAALIOHJAUS ...
nimi_se string Data source did not contain a description for nimi_se. Column nimi_se has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: ETELÄN SOSIAALIOHJAUS 1 /... and first 25 characters of maximum string: POHJOISEN SOSIAALIOHJAUS ...
omistaja string Data source did not contain a description for omistaja. Column omistaja has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: kmo.
toimipiste int Data source did not contain a description for toimipiste. Column toimipiste has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3220 and maximum value is 3244.
tunnus int Data source did not contain a description for tunnus. Column tunnus has 8 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 8.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POLYGON ((24.782804404083... and first 25 characters of maximum string: POLYGON ((25.139704233316...
geom_center_x float Longitude of center. Column geom_center_x has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.88 and maximum value is 25.14.
geom_center_y float Latitude of center. Column geom_center_y has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.07 and maximum value is 60.26.
geom_type string Geometry type. Column geom_type has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Sote toimeentulotukialue, Helsote toimeentulotukialue, Latest

Column Type Comment
gml_id string Data source did not contain a description for gml_id. Column gml_id has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is id110200 and maximum string is id110680.
aluejako string Data source did not contain a description for aluejako. Column aluejako has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: TOIMEENTULOTUKIALUEJAKO.
kunta int Data source did not contain a description for kunta. Column kunta has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 91.
nimi string Data source did not contain a description for nimi. Column nimi has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: ETELÄN SOSIAALIOHJAUS 1 /... and first 25 characters of maximum string: POHJOISEN SOSIAALIOHJAUS ...
nimi_se string Data source did not contain a description for nimi_se. Column nimi_se has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: ETELÄN SOSIAALIOHJAUS 1 /... and first 25 characters of maximum string: POHJOISEN SOSIAALIOHJAUS ...
omistaja string Data source did not contain a description for omistaja. Column omistaja has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: kmo.
toimipiste int Data source did not contain a description for toimipiste. Column toimipiste has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3220 and maximum value is 3244.
tunnus int Data source did not contain a description for tunnus. Column tunnus has 8 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 8.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POLYGON ((24.782804404083... and first 25 characters of maximum string: POLYGON ((25.139704233316...
geom_center_x float Longitude of center. Column geom_center_x has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.88 and maximum value is 25.14.
geom_center_y float Latitude of center. Column geom_center_y has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.07 and maximum value is 60.26.
geom_type string Geometry type. Column geom_type has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POLYGON.

Additional Info

Last Updated September 7, 2020
Created September 7, 2020