New answers tagged bounding-rectangle
For Openstreetmap, the parameters are quite simple: http://www.openstreetmap.org/#map=10/47.1911/2.4884 http://www.openstreetmap.org/#map= : base url 10/ : zoom level 47.1911/ : latitude of center, North positive 2.4884 : longitude of center, East positive ...
What do you mean by no spatial view. You mean you are not seeing it in geometry_columns table or your viewer is not loading it? If you are using PostGIS 1.5 or lower, you have to manually add the view to the table geometry_columns table. In PostGIS 2.0+, it will show in list but won't show type. To get type you need to do cast it. Also many views like ...
Based on that answer I'm trying to create new poygon layer that is extent of base layer (also polygon). But statement doesn't work: CREATE OR REPLACE VIEW xxx.extent AS SELECT ST_SetSRID(ST_Extent(geom), 2180) as geom from xxx.buildings_2013; But resulting table isn't spatial. Geometry column in table buildings_2013 is named geom.
Top 50 recent answers are included