Hello everyone, welcome to QGIS Tutorial. Today, we are going to learn how to create points from a Table in QGIS. If you read my previous post about how to open PostgreSQL table in QGIS, you will see how QGIS handles non-spatial table. But, we can easily turn the non-spatial table into a spatially-enabled dataset. For example, if you have a X, Y dataset/table, QGIS can easily plot or display the table using the X and Y information.
What we learn
- Open table in QGIS
- Create points from a table
Steps to Create Points from a Table in QGIS
Step 1. Open the table in QGIS
In order to create points from a table, make sure the table has the X and Y information. For example, I have a topographic mapping data with Easting, Northing and Elevation information. The Table source can be from anywhere like PostgreSQL, MySQL or even from a CSV file. So first, let’s open the table in QGIS.
As you can see from the video above, I have a new table that has X and Y information.
Step 2. Create Points from a Table
To create points from a table in QGIS, I am going to use the Vector Creation in QGIS Toolbox. You will need to open the Toolbox first. Go to Processing | Toolbox. Then, find Vector Creation. Then, double-click Create points layer from table. It will bring up a new window where you can adjust some settings.
Watch the following video for the better steps by steps tutorial.
Thanks for reading this article and I hope you enjoy it. Please support us by sharing this article to keep this website alive and keep up to date with many GIS Tutorials. See you
Etienne Drouin
March 25, 2022I have Geographic coordinates (NAD83) in my table. My project is in NAD83/Quebec Lambert (EPSG: 32198). As I understand, my target CRS is 32198. But the reprojection doesn’t take place because QGIS doesn’t know my initial coordinates are in geographic NAD83. How do I tell QGIS the initial CRS of my table data?