Re: [Qgis-user] Import German population data
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
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
Re: [Qgis-user] Import German population data
Hi, I just copied you example lines to a text file, drag-dropped it into QGIS, used “Create points layer from table”, set the coordinate system to 3035, X,Y according to your settings, and got two points in Flensburg. Am 06.07.24 um 14:23 schrieb 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 -- Dipl.-Geogr. Bernd Vogelgesang Kappel 17 91355 Hiltpoltstein Tel: 09192-3499427 mobil: 0163-1860160 m...@berndvogelgesang.deBEGIN:VCARD VERSION:4.0 N:Vogelgesang;Bernd;;; FN:Dipl-Geogr. Bernd Vogelgesang EMAIL;PREF=1:m...@berndvogelgesang.de TEL;TYPE=cell;VALUE=TEXT:+491631860160 TEL;TYPE=work;VALUE=TEXT:+4991923499427 ADR:;;Kappel 17;Hiltpoltstein;;91355; END:VCARD ___ 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
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
Re: [Qgis-user] Import German population data
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 -- --- North River Geographic Systems, Inc https://northrivergeographic.com rjh...@northrivergeographic.com ___ 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
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