<div dir="ltr">Hi<div style>Thanks Paolo</div><div style>How can I store my images to be served as WMS?</div><div style><br></div><div style>@<span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">Pierre</span></div>
<div style><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:13px">The advantages are a lot considering our situation.</span></div><div style><font color="#500050" face="arial, sans-serif">At first, all our base offical regional data are in dxf format, crazy but true..</font></div>
<div style><font color="#500050" face="arial, sans-serif">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.</font></div>
<div style><font color="#500050" face="arial, sans-serif">There is advantage on extraction performance and disk space (14Gb db space against 90Gb dxf)..</font></div><div style><font color="#500050" face="arial, sans-serif">Besides these data there are administrative vectorial data, data on land use, wells, lots of data that can be modified.</font></div>
<div style>The performance over the network is good, expecially when you extract data for small areas.</div><div style><br></div><div style><br></div><div style>I don't know if these performances could be the same with raster...</div>
<div style>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?</div><div style>The refreshing of views are as fast as with ecw?</div>
<div style>Does the postgis database grow up too much with raster?</div><div style><br></div><div style>I don't know.. I'm just testing these possibility but I'm not an IT expert</div><div style><br></div><div style>
Thank you all</div><div style>Pietro</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/2/6 Pierre Racine-2 [via PostGIS] <span dir="ltr"><<a href="/user/SendEmail.jtp?type=node&node=5002546&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>></span><br>
<blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
Pietro,
<br><br>Just two questions:
<br><br>-What advantages did you find in storing vector data in the DB?
<br><br>-Why each of those advantages do not apply to raster?
<br><br>Pierre
<br></div><div><div class="im"><br>> -----Original Message-----
<br>> From: <a href="http://user/SendEmail.jtp?type=node&node=5002528&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a> [mailto:<a href="/user/SendEmail.jtp?type=node&node=5002546&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a>
<br>> <a href="http://user/SendEmail.jtp?type=node&node=5002528&i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a>] On Behalf Of Pietro Rossin
<br>> Sent: Wednesday, February 06, 2013 7:21 AM
<br></div><div class="im">> To: <a href="http://user/SendEmail.jtp?type=node&node=5002528&i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a>
<br>> Subject: [postgis-users] Is it worth to load background raster into postgis?
<br>>
<br></div><div><div class="h5">> Hi all
<div class='shrinkable-quote'><br>> we are building a postgis db to store shared data to e used in my agency.
<br>> While for the vectorial part of our data I'm convinced of the advantage to
<br>> store them into a geodb, for the raster part of data I'm not so convinced.
<br>> I took a look at postgis raster reference page and I realized that postgis
<br>> raster is good if the raster is used to make analysis.
<br>> So, let's say it's ok for dtm raster data, to obtain slope/hillshade/aspect
<br>> on the fly..
<br>> But If the raster we use is only for base/coreographic pourpose, to be
<br>> loaded mainly in desktop mapping applications, is it worth to use postgis?
<br>> Right now most of our raster are in ecw format and I'm searching a way to
<br>> distribute them over LAN..
<br>> May be a mosaic/vrt..
<br>> Ay suggestion?
<br>> Thank you
<br>> Pietro
<br>>
<br>>
<br>>
<br>> --
<br>> View this message in context: <a href="http://postgis.17.n6.nabble.com/Is-it-worth-to-" rel="nofollow" link="external" target="_blank">http://postgis.17.n6.nabble.com/Is-it-worth-to-</a><br>> load-background-raster-into-postgis-tp5002525.html
<br>> Sent from the PostGIS - User mailing list archive at Nabble.com.
<br>> _______________________________________________
<br>> postgis-users mailing list
</div></div></div>> <a href="http://user/SendEmail.jtp?type=node&node=5002528&i=3" rel="nofollow" link="external" target="_blank">[hidden email]</a>
<br>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></div>_______________________________________________
<br>postgis-users mailing list
<br><div class="im"><a href="http://user/SendEmail.jtp?type=node&node=5002528&i=4" rel="nofollow" link="external" target="_blank">[hidden email]</a>
<br><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br>
<br>
<hr noshade size="1" color="#cccccc">
</div><div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif"><div class="im">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
</div><a href="http://postgis.17.n6.nabble.com/Is-it-worth-to-load-background-raster-into-postgis-tp5002525p5002528.html" target="_blank" rel="nofollow" link="external">http://postgis.17.n6.nabble.com/Is-it-worth-to-load-background-raster-into-postgis-tp5002525p5002528.html</a>
</div>
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
To unsubscribe from Is it worth to load background raster into postgis?, <a href="" target="_blank" rel="nofollow" link="external">click here</a>.<br>
<a href="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" rel="nofollow" style="font:9px serif" target="_blank" link="external">NAML</a>
</div></blockquote></div><br></div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://postgis.17.n6.nabble.com/Is-it-worth-to-load-background-raster-into-postgis-tp5002525p5002546.html">Re: Is it worth to load background raster into postgis?</a><br/>
Sent from the <a href="http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html">PostGIS - User mailing list archive</a> at Nabble.com.<br/>