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 at 5:43
  • As per the Tour there should be only one question asked per question. – PolyGeo Jan 4 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. – ThingumaBob Jan 6 at 12:00

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.