[postgis-users] Can postGIS database views work like .ARP project files?

Mark Leslie mark.leslie at lisasoft.com
Mon Feb 25 22:13:28 PST 2008

PostGIS can contain any supported geometry type in the 'geometry' 
object, and they don't need to be of the same type within a single table 
or view.
If you define a geometry column using 'addGeometryColumn', you can 
define the geometry type as a single type (POLYGON, LINE, etc), or you 
can define it as GEOMETRY, and include a mix.
The difficulty will come when you try to connect a client app to the 
table to visualize.  I'm not sure if/how they will handle mixed feature 

Mark Leslie
Geospatial Software Architect
LISAsoft Pty Ltd
+61 (0)2 8570 5050

Commercial Support for Geospatial Open Source Software

kreshna_iceheart at yahoo.com wrote:
> I wonder about a thing:
> Does postGIS have spatial-related database views that
> work like ArcView .ARP project files?
> See, with project files, it is possible to combine
> several SHP files of various types (polygons, lines,
> etc) , in a single view.
> Now, is it possible to to such thing with postGIS
> database? Are there views to combine various types of
> spatial tables? (polygons, lines, etc)
> Many thanks,
> -Kresh
> __________________________________________________________________
> So be it. If saying "NO" means being alone, then to hell with love, with women, with marriage, with God, religions, bars, nightclubs, computer games, and all the shit life keeps pumping at me. I'll walk alone, but with freedom and a healed pride.
>       ____________________________________________________________________________________
> Never miss a thing.  Make Yahoo your home page. 
> http://www.yahoo.com/r/hs
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list