Geospatial and Demographic Data Collection for Stockholm Region

This dataset collection includes several tables, each consisting of related data organized in a structured format. These tables originate from the website of Lantmäteriet (The Land Survey) in Sweden. The dataset focuses on geographic and demographic data. It also includes free data files which are zip-compressed, such as population distribution by gender, public preschools, population by age, and population by Swedish/foreign background, among others. This dataset also contains information about vehicles owned by individuals, categorized by vehicle type and status. The data in this collection is provided in the Shape and MapInfo formats, each delivered in 4 files per layer. The files include geometry files, attribute files in Dbase format, index files, and projection files for the Shape format, and main files/table definitions, attribute files, geometry files, and index files for graphical features for the MapInfo format. Access to this data is free, full and open, but it remains the sole property of the European Union. When distributing or communicating this data, users are obliged to inform the public of its source and not to convey the impression of official endorsement by the Union. If the data has been adapted or modified, this must be clearly stated. This dataset is licensed under CC0 (Creative Commons Zero, https://creativecommons.org/public-domain/cc0/).

Tables

Detailed Geographic and Area Data Analysis from Stockholm CollectionTSV
The table in question is part of a data collection from the Swedish website, 'Lantmäteriet'. It contains crucial geographical and attribute information of geographic features, represented by points, lines, or polygons (areas). The data is organized by specific dates of extraction, each row identified uniquely by the combination of the extraction date and the row number, indicating its order in the extracted data. Key geographical data are included, such as the geometric location and attribute information, represented in specific geographic formats. The table also includes details like object identifiers, specific codes, area measurements in hectares, and remarks. It's worth noting that some fields may not contain any data. The geographic information stored in this table is derived from...
Geospatial Data Table for Stockholm Collection with Land Cover, Area Measurements, and Geometry DetailsTSV
The table is a part of a dataset from the 'Lantmäteriet' website, located in Sweden. It contains data organized into various categories. Each row in the table is uniquely identified by an extraction date and a row number, indicating when the data was pulled and its order in that extraction. The table also includes an 'OBJECTID' and an 'ID', both of which appear to be identifiers for the data entries. There's a 'CODE_12' column, which could represent a specific coding system related to the data, and an 'Area_Ha' that likely refers to a land area measurement in hectares. The 'Remark' column could contain additional notes or comments about the data. The table also holds geometric information about geographic features, originally sourced from a shapefile. This includes the length and area...
Land Cover Classification Data Table for Stockholm AreaTSV
The table is a part of a dataset collection sourced from the website of 'Lantmäteriet' (the Swedish National Land Survey) in Sweden. It contains rich geospatial data and attribute information of geographic features in and around the city of Stockholm. The table includes columns for the date of data extraction and the row number, which together uniquely identify each row of data. Other notable columns contain geographic identifiers, object ids, codes and area measurements. The geographic information, originally in shapefile format, has been transformed into a final geographic format for this dataset. The dataset provides a wealth of information that could be used for various data analytics purposes. For instance, the geographic and area information could be used in environmental studies...
Version History of Base Table Rows in Stockholm Dataset CollectionTSV
This history table is part of a dataset collection sourced from the Swedish website, 'Lantmäteriet'. It stores the version history of geographic features, including various details and changes over time. The table contains unique identifiers for each row, formed by a combination of the date the row was extracted and the row number. This table also includes dates signifying when a new version of the row was extracted, and if there's no 'end date' provided, it signifies that the version of the row is the most recent. Geographic information, initially in the shapefile format, is included, which represents the location and attribute information of geographic features. Features can be represented by points, lines, or polygons. The table contains information such as the unique object...
Version History of Base Table Rows in Stockholm Dataset CollectionTSV
This table is a historical record of geographic features and their associated attributes for a specific area, sourced from the Swedish website 'Lantmäteriet'. The history table tracks the changes in geographic features over time, capturing the version history of each row in its base table. Each entry is uniquely identified by a combination of its start date and a row number. The start date represents when the row was extracted from the data source, while the end date indicates when a new version of the row was extracted. If the end date is null, this signifies that the row is the most current version. Importantly, the table includes geographic information that has been translated from the original shapefile format into a final geographic format. The geographic features are represented...
Version History of Base Table Rows in Stockholm Dataset CollectionTSV
The table is a historical data collection from the 'Lantmäteriet' (The Swedish Land Survey) in Sweden. The table is part of a larger data collection focused on geographic and environmental data. It contains historical versions of rows from its base table, essentially providing a version history for each row. Each row in this table is uniquely identified by a combination of the date of data extraction and the row number from the original data source. The table has additional date columns representing the start and end dates of each version of a row. If the end date is null, it indicates that the version of the row is the most recent. The table contains various columns with geographic and attribute information of geographic features. Some of these features include elements like the area...

Column Descriptions

Detailed Geographic and Area Data Analysis from Stockholm Collection

Column	Type	Comment
_extract_date	date	This column contains the date when the data in each row was extracted from the data source.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date. This, along with the '_extract_date', uniquely identifies each row.
OBJECTID	long	This column contains unique identifiers for each object within the data.
ID	string	This column contains another unique identifier for each object, often prefixed with the country code 'SE' for Sweden.
CODE_12	string	This column contains numerical codes that correspond to specific categories or classifications within the dataset.
Area_Ha	double	This column contains the area measurement of each object, represented in hectares.
Remark	string	This column is designed to contain any additional notes or remarks related to each object, although it may often be empty.
Shape_Leng	double	This column is expected to contain the length of the shape representing each object, but it appears to be empty in the dataset.
Shape_Area	double	This column contains the area of the shape representing each object, calculated in a specific unit of measurement.
geom_geojson	string	This column contains geometric data for each object, represented in the GeoJSON format, which is a widely used format for encoding geographic data structures.
geom_geotext	string	This column contains geometric data for each object, represented in a text format that describes the shapes and coordinates of the objects.
geom_type	string	This column specifies the type of geometric shape used to represent each object, such as a polygon in this dataset.
geom_centroid	string	This column contains the geographic coordinates for the centroid, or geometric center, of each object.
geom_center_x	double	This column represents the X coordinate (latitude) of the center of the geometric shape representing each object.
geom_center_y	double	This column represents the Y coordinate (longitude) of the center of the geometric shape representing each object.

Version History of Base Table Rows in Stockholm Dataset Collection

Column	Type	Comment
_start_date	date	This is a date column that records when the data row was initially extracted from the data source, forming part of the unique identifier for each row in this version history table.
_end_date	date	This date column indicates when a new version of the data row was extracted from the data source. If the value is null, it signifies that the data row is the most recent version.
_row_number	long	This column holds the row number as it appears in the raw data source. In conjunction with '_start_date', it forms a unique identifier for each row in this version history table.
OBJECTID	long	This column contains unique identifiers for the objects in the data set.
ID	string	This column represents a unique identification code for each entry in the data set, typically following the format 'SE_' followed by a series of numbers.
CODE_12	string	This column contains specific codes associated with each data entry.
Area_Ha	double	This column records the area in hectares for each data entry.
Remark	string	This column is reserved for any additional comments or notes regarding each data entry. It can commonly be null if there are no remarks to be made.
Shape_Leng	double	This column is intended to store the length of the shape associated with each data entry.
Shape_Area	double	This column records the area of the shape associated with each data entry.
geom_geojson	string	This column stores the geometric data associated with each entry in GeoJSON format, a popular open standard format designed for representing simple geographical features.
geom_geotext	string	This column holds the geometric data associated with each data entry in a text-based format.
geom_type	string	This column indicates the type of geometric data associated with each data entry (e.g., 'ST_POLYGON' for polygon shapes).
geom_centroid	string	This column stores the geometric center (or 'centroid') of the shape associated with each data entry.
geom_center_x	double	This column records the x-coordinate of the geometric center of the shape associated with each data entry.
geom_center_y	double	This column records the y-coordinate of the geometric center of the shape associated with each data entry.

Land Cover Classification Data Table for Stockholm Area

Column	Type	Comment
_extract_date	date	This column holds the date when the data on the row was extracted from the data source. It plays a crucial role in data versioning, allowing users to understand when the information was last updated.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It helps in uniquely identifying each row of data.
OBJECTID	long	This column stores a unique identification number for each object or feature within the dataset.
ID	string	This column contains a unique identifier for each record, providing a way to reference individual entries.
CODE_12	string	This column holds specific codes related to the data. The meaning of these codes would be defined in the metadata or data dictionary of the dataset.
Area_Ha	double	This column represents the area of the geographical feature in hectares. It's typically used in geographical or environmental datasets.
Remark	string	This column is designated for any additional comments or notes related to the record.
Shape_Leng	double	This column is likely to contain information about the length of a geographical feature, although the sample values provided are not available.
Shape_Area	double	This column captures the calculated area of the geographical feature, represented as a numerical value.
geom_geojson	string	This column stores the geographical data in GeoJSON format, which is a popular open standard format designed for representing simple geographical features, along with their non-spatial attributes.
geom_geotext	string	This column contains geographical data in a text format, likely outlining the coordinates of the geographical feature.
geom_type	string	This column specifies the type of the geometric feature. In this case, it seems to be a polygon.
geom_centroid	string	This column holds the centroid coordinates of the geometric feature. The centroid is the geometric center of a two-dimensional shape.
geom_center_x	double	This column contains the X coordinate (longitude) of the center point of the geographical feature.
geom_center_y	double	This column contains the Y coordinate (latitude) of the center point of the geographical feature.

Version History of Base Table Rows in Stockholm Dataset Collection

Column	Type	Comment
_start_date	date	This column holds the date when a row was first extracted from the data source. The format of the date is YYYY-MM-DD.
_end_date	date	This column contains the date when a newer version of the row was extracted from the data source. The format of the date is YYYY-MM-DD. If this column value is null, it indicates that the row is the most current version.
_row_number	long	This column contains the row number as it appeared in the raw data extracted from the data source. Along with the '_start_date', it forms a unique identifier for each row in this version history table.
OBJECTID	long	This column contains a unique identifier for each object or feature in the dataset.
ID	string	This column contains another unique identifier, which is usually prefixed with 'SE_' to denote the country of origin, Sweden.
CODE_12	string	This column holds a code that represents the class or type of the object or feature, as defined in the CORINE Land Cover (CLC) classification system.
Area_Ha	double	This column contains the area of the object or feature, measured in hectares.
Remark	string	This column is intended for additional notes or comments related to the object or feature. However, it appears to be unused in the current version of the dataset.
Shape_Leng	double	This column is intended to hold the calculated length of the object or feature. It seems to be unused in the current version of the dataset.
Shape_Area	double	This column contains the calculated area of the object or feature, in square meters. This value is typically very close to the 'Area_Ha' multiplied by 10,000.
geom_geojson	string	This column holds the geometric representation of the object or feature in GeoJSON format, a popular open standard format designed for representing simple geographical features.
geom_geotext	string	This column contains the geometric representation of the object or feature in text format.
geom_type	string	This column contains the type of the geometric representation of the object or feature. In this case, all features are polygons.
geom_centroid	string	This column holds the geometric centroid of the object or feature. The centroid is the arithmetic mean position of all the points in the shape.
geom_center_x	double	This column contains the X-coordinate (longitude) of the geometric center of the object or feature.
geom_center_y	double	This column contains the Y-coordinate (latitude) of the geometric center of the object or feature.

Geospatial Data Table for Stockholm Collection with Land Cover, Area Measurements, and Geometry Details

Column	Type	Comment
_extract_date	date	This column contains the date when the data in a particular row was extracted. It is part of a unique identifier for each row, along with the '_row_number' column.
_row_number	long	This column contains the row number in the data as it was extracted from the source. Along with the '_extract_date' column, it forms a unique identifier for each row.
OBJECTID	long	This column holds the unique object identifiers for the data objects in the table.
ID	string	This column provides an additional unique identifier for each entry, typically in a formatted string form.
CODE_12	string	This column contains numerical codes, the meaning of which is dependent on the context of the dataset.
Area_Ha	double	This column represents the area of the corresponding data object, measured in hectares.
Remark	string	This column is reserved for any additional comments or notes related to a particular row.
Shape_Leng	double	This column is meant to contain information about the length of the shape represented by the data object. However, it appears to be unused in the current dataset.
Shape_Area	double	This column provides the calculated area of the shape represented by each data object. It is likely measured in a unit consistent with the dataset, such as square meters.
geom_geojson	string	This column contains the geometrical data of the shape represented by each data object, formatted as a GeoJSON, a type of JSON designed to represent geographical features.
geom_geotext	string	This column holds the geometrical data of the shape in a text format. This can be useful for visualizing the shape or for use with certain software.
geom_type	string	This column describes the geometrical type of the shape represented by each data object. In this dataset, they appear to all be polygons.
geom_centroid	string	This column contains the coordinates of the centroid, or geometric center, of the shape represented by each data object.
geom_center_x	double	This column contains the x-coordinate of the centroid of the shape represented by each data object.
geom_center_y	double	This column contains the y-coordinate of the centroid of the shape represented by each data object.

Version History of Base Table Rows in Stockholm Dataset Collection

Column	Type	Comment
_start_date	date	This column contains the date when the respective row was extracted from the data source.
_end_date	date	This column holds the date when a new version of the respective row was extracted from the data source. If the value is null, it indicates that the row is the most recent version.
_row_number	long	This column contains the number of the row in the raw data extracted from the data source. Together with the '_start_date' column, it forms a unique identifier for each row in this version history table.
OBJECTID	long	This column contains unique identifiers for each object in the table.
ID	string	This column holds unique identifiers for each object, prefixed with 'SE_' to indicate data from Sweden.
CODE_12	string	This column contains specific codes associated with the objects.
Area_Ha	double	This column captures the area of the objects in hectares.
Remark	string	This column may contain additional remarks or notes about the respective objects. If there are no remarks, the value might be null.
Shape_Leng	double	This column holds the lengths of the geometric shapes representing the objects. It might contain null values.
Shape_Area	double	This column contains the area of the geometric shapes representing the objects.
geom_geojson	string	This column stores the geometric representation of the objects in GeoJSON format.
geom_geotext	string	This column contains the geometric representation of the objects in textual format.
geom_type	string	This column specifies the type of the geometric representation of the objects.
geom_centroid	string	This column holds the centroid point of the geometric representation of the objects.
geom_center_x	double	This column contains the x-coordinate of the center point of the geometric representation of the objects.
geom_center_y	double	This column holds the y-coordinate of the center point of the geometric representation of the objects.

Additional Info

Last Updated	September 13, 2024
Created	August 27, 2024