New answers tagged web
I think I figured it out myself... CREATE TABLE buildings_extrude AS SELECT id, st_extrude(geom, 0, 0, height) as the_geom FROM buildings; CREATE TABLE buildings_dump AS SELECT id, st_dump(the_geom) as the_geom FROM buildings_extrude; CREATE TABLE buildings_collect AS SELECT id, st_collect((the_geom).geom) as the_geom FROM buildings_dump GROUP BY id;
According to this paper, you can specify the crs using a url like http://www.opengis.net/def/crs/EPSG/0/4326 , where the last bit is the EPSG code. You can also look for OGC crs codes using a similar URL. I don't know SPARQL, but you might be able to query all the available EPSG and OGC codes from that. EPSG coordinate systems were originally developed for ...
If you are interesting in viewing web maps, a good alternative is my web application called "WMS Viewer on line" it is free, light, easy to use and available at http://wmsviewer-rodis.rhcloud.com/
Top 50 recent answers are included