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
I 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?