I am looking for an application that will allow me to draw a box or polygon on a map and then export the definition in a PostGIS database so that I can insert it into my own database.
Currently, my approach is to open Google Earth, find the latitude, longitude, and elevation points that define the box on a map, and then construct a string that can be inserted into a database (similar to this approach using R).
Is there a web application that provides both the GUI front end for drawing polygons and how these polygons are defined as PostGIS geometry data types?
I assume QGIS or ArcGIS have this functionality, but I am looking for something much simpler.