pgAdmin is the leading Open Source management tool for Postgres, the world’s most advanced Open Source database. pgAdmin 4 is designed to meet the needs of both novice and experienced Postgres users alike, providing a powerful graphical interface that simplifies the creation, maintenance and use of database objects. https://www.pgadmin.org/docs/pgadmin4/4.28/index.html This post will describe how to…
Category: PostGIS
PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.
Data Storage: Installing PostgreSQL and PostGIS
This post will describe how to install both the PostgreSQL database and the PostGIS geodatabase extension. If you have been following my Criminal Analysis: Data Storage posts then this will be a repeat of information. Installing and Setting up PostgreSQL On a Linux machine, getting PostgreSQL installed and running is pretty easy and straight forward….
Criminal Analysis: Data Storage (part 2)
In this post I will go over setting up a geospatial database using PostGIS, an extension to PostgreSQL. For information about setting up a PostgreSQL database please refer back to my previous Data Storage. Below is the project plan to ensure I load up all my downloaded map data. Installing and Setting up First you…
