Skip to Content
Mastering Geospatial Analysis with Python
book

Mastering Geospatial Analysis with Python

by Silas Toms, Paul Crickard, Eric van Rees
April 2018
Beginner to intermediate content levelBeginner to intermediate
440 pages
11h 36m
English
Packt Publishing
Content preview from Mastering Geospatial Analysis with Python

Loading rasters into PostgreSQL

To load a raster into PostgreSQL, you can use the raster2pgsql binary. If it is not in your path, you may need to add it. You should be able to find the binary in your PostgreSQL install directory on Windows at \PostgreSQL\10\bin.

The following command should be executed from your operating system's command line. It will load the TIF you created earlier in this chapter into an existing PostgreSQL database:

>raster2pgsql -I -C -s 4326 C:\Users\Paul\Desktop\BigI.tif public.bigi | psql -U postgres -d pythonspatial

The previous command uses raster2pgsql with the -I (creates an index), -C (adds raster constraints), and -s 4326 (the SRID) parameters. Using the pipe operator on Windows, you send the command to psql ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Learning Geospatial Analysis with Python

Learning Geospatial Analysis with Python

Joel Lawhead

Publisher Resources

ISBN: 9781788293334Supplemental Content