Hi Dane, I actually have two goals:
1) I have several adjacent .SHP files that belong to the same logical layer (they are pieces of street network in a city). Naturally, I want to put them all on the same table to make a big layer of street lines. However, achieving this goal is quite easy since SHP2PGSQL utility allows you to add SHP files to existing tables (as opposed to creating new tables). 2) But yes, my second goal is like you described: to create a postgreSQL database VIEW (instead of table) that contain polygon, line, and point data. And yes, this database view is supposed to act like project file. Thus, user just need to open the database views to see the project, instead opening project file(s) on her/his local hard drive. See, the goal is to eliminate the need of project files, and replace them with database views instead. Database views are more organized because they are stored in the database server, as oppossed to project files that are scattered through each user's local hard drive. So how to achieve the goal? Can the geomunion function help me create such view that contains polygon, lines, and points? Thanks, -Kresh --- Dane Springmeyer <[EMAIL PROTECTED]> wrote: > Hi Kreshna, > > Do you mean to visualize your data? To actually view > it in a map > interface? > > Postgis is just a backend for storage, analysis, and > data > manipulation. You can have tables within postgis > that contain both > polygon, line and point data in one table if you > want to. But I don't > think that is what you are asking. > > If you want to view an overlay of different data > then you need to load > your shapefiles in the data viewer like QGis or > uDig, then save > "projects" that view all the data layers together. > > Let me know if I can help anymore, > > dane > > > On Feb 25, 2008, at 8:47 PM, > [EMAIL PROTECTED] 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@postgis.refractions.net > > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > __________________________________________________________________ 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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
