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

[David William Bitner]

> 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.


Explain what you mean by "open the database views".  Data in a view is still
just data.  PostGIS does not have any internal means to display data (unless
you count looking at text or binary as display).  You can use views (or for
your case, it would seem better to do something like organizing the data
into schemas) to organize your data, but that still is not going to get you
to anything like an ArcView .apr file which controls both links to the where
the data resides as well as information about how to style that data.

>
>
> 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.


I've seen some mighty unorganized databases and some mighty organized file
systems, I'm not quite sure I buy your logic.


>
>
> 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 <blake at hailmail.net> 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,
> > 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
> >
> >
>
>
> __________________________________________________________________
> 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
>



-- 
************************************
David William Bitner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080303/2fcd1e8f/attachment.html>