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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.