We are updating a field in sql and alter
We will also be using Massachusetts/Boston data for these examples.
For desktop users, the Enterprise DB one-click installer exists as well for Mac/OSX and Linux desktops, so you should be able to follow along without too much fuss.
Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance.
Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.
We'll need to match this descriptive projection to an SRID (the id field of a spatial ref record in the spatial_ref_sys table) if we ever want to reproject our data.
The easiest data to load into Post GIS is ESRI shape data since Post GIS comes packaged with a nice command line tool called shp2pgsql which converts ESRI shape files into Post GIS specific SQL statements that can then be loaded into a Post GIS database.
If you are on linux or have Wget handy - you can do the below to download the file after you have cded into the folder you want to put it in.
We will not go into too much detail here since the install wizard (at least the windows one) is pretty good. You can use something like psql or the pg Admin query window to create a database and spatially enable your database.
This is the way to go if you have only a terminal interface to your db or you have a butt load of extensions you want to enable.
Post GIS is an open source, freely available, and fairly OGC compliant spatial database extender for the Postgre SQL Database Management System.
In a nutshell it adds spatial functions such as distance, area, union, intersection, and specialty geometry data types to the database.