[GRASS-user] Creating temp tables

Tue Jul 17 17:15:00 EDT 2007

> 41a8e3/attachment-0001.html
>
> ------------------------------
>
> Message: 5
> Date: Mon, 16 Jul 2007 12:30:54 -0500
> From: "Nithi, Nachi K \(Karun\)" <karun at research.bell-labs.com>
> Subject: [GRASS-user] Firstpost: Creatng temp tables instead of
> 	regular	tables for vectormaps in mysql
> To: <grassuser at grass.itc.it>
> Message-ID:
> 	<858DDD4F5B8D924C955EB55302E4D1A801229949 at ILEXC1U02.ndc.lucent.com>
> Content-Type: text/plain;	charset="us-ascii"
>
>
> Hi All,
> This is my first post.
>
> When we create vector maps in grass with MYSQL as the database it always
> creates tables that are regular (permanent). I am wondering whether
> there is a way to create temporary tables instead. The problem with
> permanent tables is that Mysql creates corresponding files on the disk
> where the underlying database tables are stored. This in turn leads to
> disk fragmentation,  if we have to create hundreds of maps a day. Any
> idea other than changing the source code? Or will it be made as an
> option?
>
>  
>
> Thanks,
>
> -Karun
>   
Hi Karun,

I suspect MySQL / Grass users must be thin on the ground, because I've 
been wondering the same thing.

My workaround has been:

Create new map (eg, as a vector import)
Create view in MySQL
Use v.db.connect to connect the vector to the view instead of the 
unwanted table
Drop the unwanted MySQL table.

Perhaps the same process may be scriptable instead of trying to edit the 
source code?

V.external creates a read-only map-database link, but I haven't been 
able to get the DSN link working in a Mac, so I don't know if that is 
useful for you.

Richard Chirgwin
>
>
>
> ------------------------------
>
> Message: 6
> Date: Mon, 16 Jul 2007 10:34:56 -0700
> From: goldneaa at onid.orst.edu
> Subject: [GRASS-user] d.slide.show
> To: grassuser at grass.itc.it
> Message-ID: <20070716103456.bd7l9jp9icckcc08 at webmail.oregonstate.edu>
> Content-Type: text/plain;	charset=ISO-8859-1;	DelSp="Yes";
> 	format="flowed"
>
> I have a quick question about the usage of d.slide.show.  Right now I  
> am able to create a slide show for my raster files.  Two problems I am  
> having so far is that my rasters are out of order.  I know that when I  
> bring them in they are bringing them in in alphabetical order.   
> Example.  raster.1,raster.10,raster100,raster1000,raster.1001.  But  
> this is not the way I want them presented in my show.  I need the  
> raters just to move from 1-1560.  Is there a tool that will order my  
> rasters in this format for presentation in the show.  Second, between  
> my raster files a white screen pops up and has lettering from the file  
> extension of my raster files.  Is there a way for the slideshow to  
> simply just run through the rasters without this interuption.
> Thanks you,
> Aaron
>
>
>
> ------------------------------
>
> Message: 7
> Date: Mon, 16 Jul 2007 10:46:54 -0700
> From: "Daniel Farnan @ San Francisco" <DanielF at sharechive.com>
> Subject: [GRASS-user] One raster from many
> To: <grassuser at grass.itc.it>
> Message-ID:
> 	<5F0B60420177CA42B7759C56DC372C1D2CAE9E at sharechive1.sllc.local>
> Content-Type: text/plain; charset="utf-8"
>
>
> I know I have done this, and cannot find the command online or in the book to refresh my memory. I have eleven srtm rasters to rubbersheet, and would like one file to output to GRASS to run countours from, with r.to.vect - I cannot recall the quilting-rasters command I used several months ago to do this with some orthophotos. Sorry to bother with so simple a question,
> Thank you,
> Daniel  
>
>
>  Daniel Farnan, Professional Services 
>  Office phoneâ–º415-284-9662
>  
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://grass.itc.it/pipermail/grassuser/attachments/20070716/cc82f6d2/attachment-0001.html
>
> ------------------------------
>
> Message: 8
> Date: Mon, 16 Jul 2007 20:16:50 +0200
> From: Maciej Sieczka <tutey at o2.pl>
> Subject: Re: [GRASS-user] One raster from many
> To: "Daniel Farnan @ San Francisco" <DanielF at sharechive.com>
> Cc: grassuser at grass.itc.it
> Message-ID: <469BB612.8010206 at o2.pl>
> Content-Type: text/plain; charset=ISO-8859-2
>
> Daniel Farnan @ San Francisco wrote:
>   
>> I know I have done this, and cannot find the command online or in
>> the book to refresh my memory. I have eleven srtm rasters to
>> rubbersheet, and would like one file to output to GRASS to run
>> countours from, with r.to.vect - I cannot recall the
>> quilting-rasters
>>     
>
> Quilting? Hmm. Maybe you mean r.patch?
>
> Maciek
>
>
>
> ------------------------------
>
> Message: 9
> Date: Mon, 16 Jul 2007 20:32:33 +0200
> From: Maciej Sieczka <tutey at o2.pl>
> Subject: Re: [GRASS-user] One raster from many
> To: "Daniel Farnan @ San Francisco" <DanielF at sharechive.com>
> Cc: GRASSLIST <grassuser at grass.itc.it>
> Message-ID: <469BB9C1.1040202 at o2.pl>
> Content-Type: text/plain; charset=ISO-8859-2
>
> Daniel Farnan @ San Francisco wrote:
>   
>> Tried r.patch and r.cross - did not use these previously, r.patch
>> took over 4 days to process the rasters, and still crashed my
>> machine.
>>     
>
> It's better to reply via the mailing list, so more folks can participate.
>
> r.patch should not fail to process as little as 11 SRTM tiles within 4
> days, either 1" or 3". Propably you have your working region/resolution
> set to big and running out of memory?
>
> try:
>
> g.region rast=rast1,rast2,...,rast11 -a
> r.patch in=rast1,rast2,...,rast11 out=rast_all
>
> Does that still crash? What GRASS version and platform?
>
>   
>> I am not really concerned about the null values,
>>     
>
> No worries. r.patch will treat null transparent.
>
>   
>> the area
>> is large, and the files had to be downloaded piecemeal from USGS, I
>> just want to put them together as one file. :-) thanks for the
>> response - I was hoping it was r.patch when I did the GUI
>> exploration last week, however it seems not.
>>     
>
> Besides r.patch (and multipurpose r.mapcalc) there is not other tool in
> GRASS usefull for "quilting" rasters I guess.
>
> Maciek
>
>
>
> ------------------------------
>
> Message: 10
> Date: Mon, 16 Jul 2007 11:48:13 -0700
> From: "Daniel Farnan @ San Francisco" <DanielF at sharechive.com>
> Subject: RE: [GRASS-user] One raster from many
> To: <grassuser at grass.itc.it>
> Message-ID:
> 	<5F0B60420177CA42B7759C56DC372C1D2CAEA3 at sharechive1.sllc.local>
> Content-Type: text/plain;	charset="us-ascii"
>
> Worked much faster than 4 days, but generated a blank (white) raster.
>  - this may be due to the srtm data(?). All were imported as .tif with
> r.in.gdal.
> I know I had done this another way initialy, as I said, similar to
> resetting the region when subsetting a raster map, I just cannot recall
> what I did. 
> (sorry Maciek, I sent too quickly - meant to include the list).
> -----Original Message-----
> From: Maciej Sieczka [mailto:tutey at o2.pl]
> Sent: Monday, July 16, 2007 11:33 AM
> To: Daniel Farnan @ San Francisco
> Cc: GRASSLIST
> Subject: Re: [GRASS-user] One raster from many
>
> Daniel Farnan @ San Francisco wrote:
>   
>> Tried r.patch and r.cross - did not use these previously, r.patch took
>>     
>
>   
>> over 4 days to process the rasters, and still crashed my machine.
>>     
>
> It's better to reply via the mailing list, so more folks can
> participate.
>
> r.patch should not fail to process as little as 11 SRTM tiles within 4
> days, either 1" or 3". Propably you have your working region/resolution
> set to big and running out of memory?
>
> try:
>
> g.region rast=rast1,rast2,...,rast11 -a
> r.patch in=rast1,rast2,...,rast11 out=rast_all
>
> Does that still crash? What GRASS version and platform?
>
>   
>> I am not really concerned about the null values,
>>     
>
> No worries. r.patch will treat null transparent.
>
>   
>> the area
>> is large, and the files had to be downloaded piecemeal from USGS, I 
>> just want to put them together as one file. :-) thanks for the 
>> response - I was hoping it was r.patch when I did the GUI exploration 
>> last week, however it seems not.
>>     
>
> Besides r.patch (and multipurpose r.mapcalc) there is not other tool in
> GRASS usefull for "quilting" rasters I guess.
>
> Maciek
>
>
>
> ------------------------------
>
> _______________________________________________
> grassuser mailing list
> grassuser at grass.itc.it
> http://grass.itc.it/mailman/listinfo/grassuser
>
>
> End of grassuser Digest, Vol 15, Issue 36
> *****************************************
>
>   