1

I have multiple CSV-files that I need to import into a database in QGIS 2.18.

The data contains Australian Postal Code information hence does not have x,y (lat/long) coordinates in it.

How can I load all those files into a database?

Taras
  • 32,823
  • 4
  • 66
  • 137
Pratts
  • 11
  • 2
  • @user2856 done. I meant to add all those csv files with no geometry into a database – Pratts Jun 23 '20 at 04:02
  • Is QGIS 2.18 a necessity? Or you can also deploy a QGIS 3? Simply saying YES you can get a "x/y"-coordinates out of a Postal codes, (i) as a Polygon in WKT-format or (ii) as a geocentroid of that polygon in "x/y"-tuples, but would it be sufficient enough for you? Can you provide a sample of that data in csv? Are you okay with some coding or looking for a code free solution? – Taras Jun 23 '20 at 06:01
  • Moreover, if you are willing to import csv-files with no geometry into a database, maybe the GIS SE is not the best place to ask this question, because you do not have a "georeferenced" context, IMHO the Database Administrators can assist you in that. As well as when you mention a database it is highly required to specify that database name/type/configuration etc. – Taras Jun 23 '20 at 06:07
  • Additionally you may try this solutions provided by @csk, but in your case look for Australian Postal Code Data (maybe this is your choice or this one) instead of the property ownership (parcel) polygon data as was mentioned by@csk. – Taras Jun 23 '20 at 06:14

0 Answers0