PostgreSQL Install + Creating a database and tables

PostgreSQL and the POSTGIS extension for it allows quering of spatial data types, such as finding 2 polygons/points/lines that intersect/are within each other/or are NEAR each other in terms of real distance. Make sure that in order to use the POSTGIS extension you use stackbuilder to import it. As shown in this video. If you want to know how to create basic databases and tables see w3schools. https://www.w3schools.com/sql/sql_create_table.asp With this knowledge you can add more columns to tables using spatial datatypes over the normal existing datatypes Data types link: https://www.postgresql.org/docs/9.5/datatype.html In the next video I'll go over converting existing shapefiles into SQL files, finding keywords to use for queries and performing some queries.