Tips & Tricks
Common solutions to common (and more obscure) problems.
- Use ST_DWithin not ST_Distance for radius queries
- Is it Lon/Lat or Lat/Lon?
- ST_Transform and ST_SetSRID: To project or not to project?
- Getting intersections the faster way
- Fixing a broken postgis raster install
- Upgrading raster from 2.* to 3.*
- Selecting only pixels of particular range of values with ST_Reclass
- Enabling PostGIS raster drivers and out-of-db raster support
- Getting distinct pixel values and pixel value counts of a raster
- Causes for 'postgis.backend' is already set
- Move PostGIS extension to a different schema
- Upgrading postgis_sfcgal to 3.1 or higher