[Qgis-user] Import German population data

[Bernhard Ströbl]

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
>