Re: [Qgis-user] Import German population data

2024-07-06 Thread Jonathan Berschauer via QGIS-User

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@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@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@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@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


Re: [Qgis-user] Import German population data

2024-07-06 Thread 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@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@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


[Qgis-user] Import German population data

2024-07-06 Thread Jonathan Berschauer via QGIS-User

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@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user