I think the ability to query using SQL based on spatial operation can be very powerful, especially considering spatial files usually take up a lot space - thus querying to only retrieve needed records is desirable. In particular, this aspect of PostgreSQL offers much more than most (free) database systems.
Also, since diving into GIS and the spatial world, I would like to learn PostgreSQL since it supports storing spatial files in an SQL table using the extension PostGIS. First, I would like to be proficient in more than one SQL RDMS. However, I have two reasons for wanting to learn a new SQL RDMS (relational database management system).
I’ve used MySQL for the past 3 years now as my SQL database manager of choice. I cover installation of PostgresSQL, creating schemas, saving data to tables, connecting from R, and running spatial queries.īy Oliver C. About Blog Research Publications Resume & CV Setting up PostgreSQL and PostGIS to Run Spatial Queries in R In this tutorial I will show how to set up PostgreSQL with PostGIS to run spatial queries in R.
0 kommentar(er)
