[Qgis-user] Import German population data

[Jonathan Berschauer]

Hello Bernhard,

this was the perfect tip! Thank you very much, you saved my day!

At first, I struggled with the wrong files (on gdz.bkg.bund.de they 
served directly only UTM32), but then i found the whole download 
directory at
https://daten.gdz.bkg.bund.de/produkte/sonstige/geogitter/aktuell/

There I located the LAEA files (for example 
DE_Grid_ETRS89-LAEA_1km.gpkg.zip ).
Using the field calculator, I was able to create new fields and then 
match the data between the different layers.

Thank you very much!
Jonathan


Am 06.07.24 um 16:13 schrieb Bernhard Ströbl via QGIS-User:
> Hallo Jonathan,
> 
> you can import the data as points using the X and Y fields (see manual 
> [1]) but I suspect you want to display them as raster data 
> (Hektarraster). Therefore you need to get the Hektarraster 1km grid data 
> (from here I guess [2]). Each grid cell has an identifier (Field id); 
> change your Gitter_ID_1km field's contents (or create a new field) to 
> match the id field and join your csv data to the Hektarraster - done.
> 
> [1] 
> https://docs.qgis.org/3.34/en/docs/user_manual/managing_data_source/opening_data.html#index-9
> [2] 
> https://gdz.bkg.bund.de/index.php/default/geographische-gitter-fur-deutschland-in-utm-projektion-geogitter-national.html
> 
> hope this helps
> 
> Bernhard
> 
> 
> Am 06.07.24 um 14:47 schrieb Jonathan Berschauer via QGIS-User:
>> Hi Randy,
>>
>> thank you for your quick answer!
>> Yes, i tried this, but then i got no layer, which i can select and 
>> convert into a grid (Vector -> Data Management Tools -> Join 
>> attributes by location (summary) [or something like that, i use an 
>> german ui).
>> Or how is the way to create a 1km/1km grid for this data?
>>
>> Thanks!
>>
>>
>>
>>
>> Am 06.07.24 um 14:39 schrieb Randal Hale via QGIS-User:
>>> Did you change the import to use a custom delimiter of semicolon and 
>>> a geometry definition of "No Geometry"?
>>>
>>> Randy
>>>
>>>
>>> On 7/6/24 08:23, Jonathan Berschauer via QGIS-User wrote:
>>>> Hi everyone!
>>>>
>>>> I want to import German population data ( 
>>>> https://www.statistikportal.de/de/veroeffentlichungen/georeferenzierte-bevoelkerungszahlen ) into QGIS.
>>>> The data is in ETRS89/LAEA / EPSG-3035 format.
>>>> I modified the CSV, so it looks like this:
>>>>
>>>> ==
>>>> Gitter_ID_1km;Zeitraum;Einwohner;X;Y
>>>> CRS3035RES1000mN3516000E4281000;2021;1403;4281000;3516000
>>>> CRS3035RES1000mN3516000E4282000;2021;1804;4282000;3516000
>>>> ==
>>>>
>>>> But when I import it as a layer, no data is shown...
>>>>
>>>> Can anyone help?
>>>>
>>>> Thank you very much!
>>>> Jonathan
>>>>
>>>> _______________________________________________
>>>> QGIS-User mailing list
>>>> QGIS-User at lists.osgeo.org
>>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>> _______________________________________________
>> QGIS-User mailing list
>> QGIS-User at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
> _______________________________________________
> QGIS-User mailing list
> QGIS-User at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>