[postgis-users] Is it worth to load background raster into postgis?

[Pietro Rossin]

Hi
Thanks Paolo
How can I store my images to be served as WMS?

@Pierre
The advantages are a lot considering our situation.
At first, all our base offical regional data are in dxf format, crazy but
true..
These are 983 dxf that I converted into three postgis tables, 3D polylines,
block and text placeholders, with indexes on geometry and layer names. All
these data are read only and they are used mainly for background and/or for
data extraction for various pourposes. They can be all queried by spatial
relationship and extracted by layer name.
There is advantage on extraction performance and disk space (14Gb db space
against 90Gb dxf)..
Besides these data there are administrative vectorial data, data on land
use, wells, lots of data that can be modified.
The performance over the network is good, expecially when you extract data
for small areas.


I don't know if these performances could be the same with raster...
I mean, if I load the ecw's on a postgis database, which could be the ratio
on disk space between ecw compressed image and raster table?
The refreshing of views are as fast as with ecw?
Does the postgis database grow up too much with raster?

I don't know.. I'm just testing these possibility but I'm not an  IT expert

Thank you all
Pietro


2013/2/6 Pierre Racine-2 [via PostGIS] <ml-node+s17n5002528h92 at n6.nabble.com
>

> Pietro,
>
> Just two questions:
>
> -What advantages did you find in storing vector data in the DB?
>
> -Why each of those advantages do not apply to raster?
>
> Pierre
>
> > -----Original Message-----
> > From: [hidden email]<http://user/SendEmail.jtp?type=node&node=5002528&i=0>[mailto:
> postgis-users-
> > [hidden email] <http://user/SendEmail.jtp?type=node&node=5002528&i=1>]
> On Behalf Of Pietro Rossin
> > Sent: Wednesday, February 06, 2013 7:21 AM
> > To: [hidden email]<http://user/SendEmail.jtp?type=node&node=5002528&i=2>
> > Subject: [postgis-users] Is it worth to load background raster into
> postgis?
> >
> > Hi all
> > we are building a postgis db to store shared data to e used in my
> agency.
> > While for the vectorial part of our data I'm convinced of the advantage
> to
> > store them into a geodb, for the raster part of data I'm not so
> convinced.
> > I took a look at postgis raster reference page and I realized that
> postgis
> > raster is good if the raster is used to make analysis.
> > So, let's say it's ok for dtm raster data, to obtain
> slope/hillshade/aspect
> > on the fly..
> > But If the raster we use is only for base/coreographic pourpose, to be
> > loaded mainly in desktop mapping applications, is it worth to use
> postgis?
> > Right now most of our raster are in ecw format and I'm searching a way
> to
> > distribute them over LAN..
> > May be a mosaic/vrt..
> > Ay suggestion?
> > Thank you
> > Pietro
> >
> >
> >
> > --
> > View this message in context:
> http://postgis.17.n6.nabble.com/Is-it-worth-to-
> > load-background-raster-into-postgis-tp5002525.html
> > Sent from the PostGIS - User mailing list archive at Nabble.com.
> > _______________________________________________
> > postgis-users mailing list
> > [hidden email] <http://user/SendEmail.jtp?type=node&node=5002528&i=3>
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5002528&i=4>
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
> ------------------------------
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://postgis.17.n6.nabble.com/Is-it-worth-to-load-background-raster-into-postgis-tp5002525p5002528.html
>  To unsubscribe from Is it worth to load background raster into postgis?, click
> here<http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5002525&code=cGllcmlnaXNAZ21haWwuY29tfDUwMDI1MjV8MjMwODY1MTQ5>
> .
> NAML<http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>




--
View this message in context: http://postgis.17.n6.nabble.com/Is-it-worth-to-load-background-raster-into-postgis-tp5002525p5002546.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130208/1dc0fc94/attachment.html>