PostGIS: The Spatial Database Engine That Could




Cageyjames & GeoBabbler show

Summary: <p>A huge episode this month. We're not starting this podcast slowly, we dive right into spatial databases. Topics this episode include PostGIS, Spatial SQL, connecting to the database and how to get help. There is so much packed into this 60 minute episode, so please make sure you check out the links below.</p><p>Links:</p><ul> <li><a title="Postgres.app – the easiest way to get started with PostgreSQL on the Mac" rel="nofollow" href="https://postgresapp.com/">Postgres.app – the easiest way to get started with PostgreSQL on the Mac</a></li> <li><a title="The missing package manager for macOS (or Linux) — The missing package manager for macOS (or Linux)" rel="nofollow" href="https://brew.sh/">The missing package manager for macOS (or Linux) — The missing package manager for macOS (or Linux)</a></li> <li><a title="PostgreSQL: Downloads" rel="nofollow" href="https://www.postgresql.org/download/">PostgreSQL: Downloads</a></li> <li><a title="Amazon RDS for PostgreSQL – Amazon Web Services (AWS)" rel="nofollow" href="https://aws.amazon.com/rds/postgresql/">Amazon RDS for PostgreSQL – Amazon Web Services (AWS)</a></li> <li><a title="Chapter 4. Using PostGIS: Data Management and Queries" rel="nofollow" href="https://postgis.net/docs/manual-2.5/using_postgis_dbmanagement.html">Chapter 4. Using PostGIS: Data Management and Queries</a></li> <li><a title="Psql" rel="nofollow" href="http://postgresguide.com/utilities/psql.html">Psql</a></li> <li><a title="pgAdmin - PostgreSQL Tools" rel="nofollow" href="https://www.pgadmin.org/">pgAdmin - PostgreSQL Tools</a></li> <li><a title="DBeaver Community | Free Universal Database Tool" rel="nofollow" href="https://dbeaver.io/">DBeaver Community | Free Universal Database Tool</a></li> <li><a title="GDAL: GDAL - Geospatial Data Abstraction Library" rel="nofollow" href="https://gdal.org/">GDAL: GDAL - Geospatial Data Abstraction Library</a></li> <li><a title="Welcome to the QGIS project!" rel="nofollow" href="https://qgis.org/en/site/">Welcome to the QGIS project!</a></li> <li><a title="ArcGIS Pro | ArcGIS Desktop" rel="nofollow" href="https://pro.arcgis.com/en/pro-app/">ArcGIS Pro | ArcGIS Desktop</a></li> <li><a title="Enterprise PostgreSQL Support &amp; Solutions | Crunchy Data" rel="nofollow" href="https://www.crunchydata.com/">Enterprise PostgreSQL Support &amp; Solutions | Crunchy Data</a></li> <li><a title="How do I do that in PostGIS: illustrating classic GIS tasks: Volume 2 by Dr. Arthur J Lembo Jr. | Goodreads" rel="nofollow" href="https://www.goodreads.com/book/show/30130103-how-do-i-do-that-in-postgis?ac=1&amp;from_search=true">How do I do that in PostGIS: illustrating classic GIS tasks: Volume 2 by Dr. Arthur J Lembo Jr. | Goodreads</a></li> <li><a title="PostGIS in Action by Regina O. Obe | Goodreads" rel="nofollow" href="https://www.goodreads.com/book/show/17286314-postgis-in-action?ac=1&amp;from_search=true">PostGIS in Action by Regina O. Obe | Goodreads</a></li> <li><a title="Postgis Cookbook by Paolo Corti | Goodreads" rel="nofollow" href="https://www.goodreads.com/book/show/20731067-postgis-cookbook?from_search=true">Postgis Cookbook by Paolo Corti | Goodreads</a></li> <li><a title="How To Install and Use PostgreSQL on Ubuntu 18.04 | DigitalOcean" rel="nofollow" href="https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04">How To Install and Use PostgreSQL on Ubuntu 18.04 | DigitalOcean</a></li> <li><a title="How To Install and Use PostgreSQL on CentOS 7 | DigitalOcean" rel="nofollow" href="https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-centos-7">How To Install and Use PostgreSQL on CentOS 7 | DigitalOcean</a></li> <li><a title="How To Install and Configure pgAdmin 4 in Server Mode | DigitalOcean" rel="nofollow" href="https://www.digitalocean.com/community/tutorials/how-to-install-configure-pgadmin4-server-mode">How To Install and Configure pgAdmin 4 in Server Mode | DigitalOcean</a></li> <li><a title="geobabbler/node-gis-server: GeoJSON-based HTTP access to PostGIS with Node" rel="nofollow" href="https://github.com/geobabbler/node-gis-server">geobabbler/node-gis-server: GeoJSON-based HTTP access to PostGIS with Node</a></li> <li><a title="Bachelor Colton still hasn’t jumped the fence and fans are fed up" rel="nofollow" href="https://ftw.usatoday.com/2019/02/bachelor-colton-underwood-fence">Bachelor Colton still hasn’t jumped the fence and fans are fed up</a></li> </ul>