[postgis-users] Can postGIS database views work like .ARP project files?
Chris Hermansen
chris.hermansen at timberline.ca
Tue Mar 4 09:54:54 PST 2008
The advantage of having all the data in the database relates to
administering it: backing it up (and getting it all in some kind of
compact unit), transferring it to another server, etc.
I think views are probably too limiting. There are a lot of things
needed to control display: the data, the (data-specific) rendering
information (such as symbology to be applied, order of rendering,
transparency, associated text). There are URIs to external datasets.
There's the basic cartographic elements (surround, scale bar, legend,
north arrow). Etc etc.
Another approach would be to create a set of tables that give the same
functionality as e.g. a .apr file
Of course this begs the question - what software will read that set of
"project description tables" and use it in rendering the data?
David William Bitner wrote:
>
>
>
> 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
> <mailto: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 <mailto: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
> <mailto: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
> <mailto:postgis-users at postgis.refractions.net>
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
> --
> ************************************
> David William Bitner
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
--
Regards,
Chris Hermansen · mailto:clh at timberline.ca
tel:+1.604.714.2878 · fax:+1.604.733.0631
Timberline Natural Resource Group · http://www.timberline.ca
401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5
C'est ma façon de parler.
More information about the postgis-users
mailing list