Class materials for week 5
This week we will begin working with spatial data inside PostgreSQL! The powerpoint will provide detailed instructions for connecting to a server to load data. Additionally, it is always helpful to load the data into GIS for visualization purposes.
After this lecture, you should practice loading datasets into your own database.
- Using the command line
- Using the shp2pg_gui
This dataset is in WGS84 projection 4326. You can find data in the classroom database: states
This dataset is in the WGS84 project 4326. You can find data in the classroom database: cities_4326
This dataset is in WGS84 projection 4326. You can find data in the classroom database: cities_txt_4326