I have multiple geography tables in PostGIS database. All of them have extents of (-180,-90;180,90), probably in their metadata, which makes editing difficult. I'd like to set the extent to exactly the bounding box of them, but I can't find any command to alter them.

Extents are viewed in QGIS by right clicking the layer and click Properties, then click Info tab.

How do I set the extents to exactly the bounding boxes of my geography tables?

  • I do not know your purpose, but take a look at "CHECK" constraint.
    – Ralph Tee
    Jan 4, 2019 at 5:43
  • As per the Tour there should be only one question asked per question.
    – PolyGeo
    Jan 4, 2019 at 5:58
  • in short, you can't; the GEOGRAPHY data type reqires the full spherical 'extent' for all implicit calculations. this datatype is not ecactly meant for GIS based visualization, but for precise trigonometric calculations; load and view your tables as GEOMETRYs, calculate in-DB with GEOGRAPHY.
    – geozelot
    Jan 6, 2019 at 12:00


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.