<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">I am fairly new to postgis as well. I do not know of a way to rasterize into another table but just going through a similar project, I have a few ideas. </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><ul><li>Export the vector table using pgsql2shp.</li><li>Then rasterize the shape file using gdal_rasterize.</li><li>Finally import the raster file using raster2pgsql.</li></ul></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">A bit of back and forth but its similar to what I am doing and there are several examples of each on the internet. </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Hope that help!</div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">-jason </div> <br><p style="color:#000;">On April 17, 2014 at 5:25:21 AM, georgew (<a href="mailto:gws293@hotmail.com">gws293@hotmail.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>As a new raster user I have found it extremely difficult to come to grips
<br>with the task of creating a raster table with postgis, in particular from an
<br>existing vector table, a task which is really trivial when done with some
<br>existing s/w packages ( i.e. SAGA, GRASS etc..). Most of the examples I
<br>could find were based on the use of raster2pgsql which implies the prior
<br>existence of a raster file created with an external package, not on using
<br>postgis native capabilities to create such a raster. If you already have a
<br>raster file, postgis has no problem creating a table from it, but what if
<br>you don't? Should you be forced to use one of the external packages?
<br>The postgis manual has a total of two (2) examples on how to create a raster
<br>table with st_asraster, although there are ten (10) different variants. My
<br>point is not a criticism of postgis raster, at the contrary, a suggestion
<br>that it could be much more useful if properly explained to users not
<br>familiar with it. In other words a good postgis raster tutorial would go a
<br>long way to convince users to at least try postgis raster by itself without
<br>recourse to external packages (except perhaps for the visualisation of the
<br>rasters). Specifically, how to create with postgis a raster table from a
<br>vector table, how to extract values from one of the vector attributes and
<br>store them in the raster, resulting in a raster identical to what would have
<br>been created with raster2pgsql. I, with my ignorance of the topic, have not
<br>been able to do that yet.
<br>If such a tutorial has already appeared somewhere I would be delighted to be
<br>pointed in that direction.
<br>Many thanks
<br>
<br>
<br>
<br>
<br>--
<br>View this message in context: http://postgis.17.x6.nabble.com/Postgis-raster-tutorial-tp5006124.html
<br>Sent from the PostGIS - User mailing list archive at Nabble.com.
<br>_______________________________________________
<br>postgis-users mailing list
<br>postgis-users@lists.osgeo.org
<br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
<br></div></div></span></blockquote></body></html>
<br>
<p><font face="Arial" size="2">This transmission contains confidential and privileged
information intended solely for the party identified above. If you receive this message in error, you must not use
it or convey it to others. Please destroy it immediately and contact the sender at
(303) 386-3955 or by return e-mail to the sender.</font></p>