Database Reference
In-Depth Information
Adding
PostGIS
layers
-
OpenJUMP
GIS
Inthissection,wewillconnecttoPostGISwithOpenJUMPGIS(OpenJUMP)inorder
toaddspatialtablesaslayers.Next,wewilleditthetemporarylayerandupdateitin
a new table in the database.
The
JUMP
inOpenJUMPstandsfor
Java Unified Mapping Platform
.Tolearnmore
about the program, or if you need to install the latest version,go to:
Click on the
Download it here
link on the previously mentioned page to view the
list of installers. You can click on the
View Details
icon next to an installer to make
sure you select the version that suits your operating system. Detailed directions for
installingOpenJUMP,alongwithotherdocumentationandinformation,canbefound
on the OpenJUMP Wiki page at the following link:
Getting ready
Wewillbereusingandbuildingupondatausedinthe
Adding PostGIS layers - QGIS
recipe. If you skipped over this recipe, you will want to do the following:
1. Download the following ZIP file from the U.S. Census Bureau's FTP site:
Theshapefileconsistsofroads,streams,andotherlinefeaturesfoundwithin
Cuyahoga County, Ohio.
2. Extract the ZIP file to your working directory and then load it into your data-
base using
shp2pgsql
. Be sure to specify the spatial reference system,
which is
EPSG: 4269
, and name the table
lines
.
