PostGIS in Action (2nd)
Where the adventure begins

PostGIS in Action: (ed. #2) Chapter 1 - What is a spatial database?

1st Edition Chapters    PostGIS In Action 2nd Edition Chapters
Download chapter code and data

  • Spatial database in problem solving
  • Spatial data types: geometry, geography, raster, and topology
  • Modeling with spatial in mind
  • Why PostGIS/PostgreSQL for spatial database
  • Loading and querying spatial data

This chapter covers the fundamentals of spatial databases and what you can do with a spatially enabled database that you can't do with a standard relational database. More specifically it covers PostGIS and what spatial data types PostGIS supports. You'll learn about the fundamentals of vector types (geometry,geography,topology) and what each is useful for as well as an introduction to raster based. It concludes with a fast-paced example of loading fast food restaurant longitude latitude data and converting them to geometric points, loading roads data from ESRI shapefiles and doing spatial summaries by joining these two sets of data.

PostGIS in Action,2nd edition MEAP      PostGIS Cookbook    PostgreSQL: Up and Running,2nd Edition    PostGIS 2 Análisis Espacial Avanzado (Spanish Edition)   
Node JS In Action, 2nd Edition    D3.js in Action