How to use the site

Some general info

• You have to name your geometry column "the_geom" for the system to recognize it as a geometry column like SELECT ST_Union(the_geom) as the_geom FROM ..... Other solutions is possible, but for now it was an easy solution to avoid problems if mutiple geometry fields.
• Map1 defines the extent of the map, while Map 2 and 3 will be drawn in the same area as Map1. If you send a new SQL-string to Map1, Map2 and 3 will dissapear because they don't have a valid extent any longer.
• If there is no other maps the Background map will be shown in its full extent but if there are a Map1 the background will follow that extent.
• You can't run insert and update queries. At least not yet. The site is not able to handle the complicated multiuser situation that it would cause.

Using different versions of PostGIS

The default version of PostGIS on PostGISonline is the latest released 1.5 version. But you can also try new functionality comming in PostGIS 2.0.
To do so just add version=trunk in your web-address like http://www.postgisonline.org/map.php?version=trunk
Then you will use a database with the latest trunk installed instead of the latest released PostGIS.

Getting the code behind this site

If you are interested in how this site is built, you can download it from download.jordogskog.no/pgo. there is two files: pgo.sql.tar.gz contains the database pgo.tar.gz contains the php code and more Do whatever you want with this code, but don't blame me if things goes wrong. If you continue to develope it I would appreciate to get a note, just of curiosity. Any suggestions is very welcome