What can you do with this PostGIS thing? This talk covers some basic and not­so­basic ways to use PostGIS/PostgreSQL to process spatial data, to build infrastructures, and to do crazy things with data. PostGIS has over 300 functions, which in turn can be used with the many features of the underlying PostgreSQL database. This talk covers some basic and not­so­basic ways to use PostGIS/PostgreSQL to process spatial data, to build infrastructures, and to do crazy things with data. Consider the possibilities: raster, topology, linear referencing, history tracking, web services, overlays, unions, joins, constraints, replication, json, xml, and more!