PostGIS and Raster Data

Written by charlie   
Tuesday, 29 December 2015 17:47
Searching for information on why PostGIS may be be a better option for storing raster data, I came across a presentation "Advanced spatial analysis with PostGIS" by Pierre Racine from the FOSS4G conference earlier this year. The presentation as a whole is chock full of intriguing ideas and the summary below sealed the deal for me on using PostGIS for large raster data sets.

In summary:

Why store raster in the database?

  • One simple language for everything: SQL
  • Many raster functions are similar to vector ones...Complex spatial analyses can be done with a single SQL query.
  • Raster/Vector interaction -Your vector data are normally already in the database...
  • Performance Analysis processing is generally faster on tiled raster coverage.
  • Data volume - You can work on TB raster coverages without much problems.
  • You can even keep the raster’s data outside the database... ...and use them transparently inside the db with SQL
  • Only metadata are stored inside (extent, SRID, pixel type, nodata) Pixel values area read from the referenced files via GDAL.
  • raster2pgsql –R option
  •  
     

    Connecticut River Tidal Wetlands

    Written by charlie   
    Tuesday, 22 December 2015 00:00
    Below are a few photos of tidal wetlands along the Connecticut River in Essex, CT taken this week during low tide, exposing mud flats. Tidal wetlands provide habitat, nesting, feeding, and refuge areas for shorebirds; serve as a nursery for many species found in the Long Island Sound. The Connecticut River was designated as an Wetland of International Importance by RAMSAR, and is the largest river system in New England. The river includes fresh, salt and brackish tidal wetlands and is a key component linking the Long Island Sound and upland fresh water systems.

    Essex, CT Tidal Marsh

    Essex, CT Tidal Marsh

    Essex, CT Tidal Marsh
     

    New Zealand Wetlands Podcast

    Written by charlie   
    Sunday, 20 December 2015 21:41
    Below is a link for a few podcasts by the Radio New Zealand program Our Changing World about wetlands. I hadn't known Zealand had lost an astounding 90% of its wetlands over the last century. The podcasts arent very long, but are worth a listen.

    Other related stories featured on Our Changing World include the ecology of Waituna Lagoon, flipping (inversion) lakes, and monitoring water quality.
     
     
    More Articles...

    Page 8 of 51

    << Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

    Twitter Feed