Importing spatial data files into PostgreSQL

For each of the ATM locations that we currently store inside our ATM database, we will have to supply the geographical data, including longitude and latitude data. After providing these geographical points for PostGIS, the extension will be able to show a world map with location points on it. The steps for this are as follows:

1. Download the zipcoordinates.sql file from GitHub at https://github.com/lequanha/PostgreSQL-12-Development-and-Administration-Projects/blob/master/Chapter 5/zipcoordinates.sql. On your browser, you will see that the script includes a CREATE TABLE statement and an INSERT statement to create and to populate a new table named Zip coordinates:

Figure 5.4 – GitHub file for spatial data

2. Next, execute this SQL file inside pgAdmin to create the new Zip coordinates database table inside the PostgreSQL RDS, as shown in the following screenshot:

Figure 5.5 – Creating the Zip coordinates table

3. Right...