[GRASS-user] Creating temp tables

[Richard Chirgwin]

41a8e3/attachment-0001.html
------------------------------

Message: 5
Date: Mon, 16 Jul 2007 12:30:54 -0500
From: "Nithi, Nachi K \(Karun\)" <[EMAIL PROTECTED]>
Subject: [GRASS-user] Firstpost: Creatng temp tables instead of
        regular tables for vectormaps in mysql
To: <grassuser@grass.itc.it>
Message-ID:
        <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
Subject: [GRASS-user] d.slide.show
To: grassuser@grass.itc.it
Message-ID: <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
Subject: [GRASS-user] One raster from many
To: <grassuser@grass.itc.it>
Message-ID:
        <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
Subject: Re: [GRASS-user] One raster from many
To: "Daniel Farnan @ San Francisco" <[EMAIL PROTECTED]>
Cc: grassuser@grass.itc.it
Message-ID: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
Subject: Re: [GRASS-user] One raster from many
To: "Daniel Farnan @ San Francisco" <[EMAIL PROTECTED]>
Cc: GRASSLIST <grassuser@grass.itc.it>
Message-ID: <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
Subject: RE: [GRASS-user] One raster from many
To: <grassuser@grass.itc.it>
Message-ID:
        <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
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@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser


End of grassuser Digest, Vol 15, Issue 36
*****************************************

  

_______________________________________________
grassuser mailing list
grassuser@grass.itc.it
http://grass.itc.it/mailman/listinfo/grassuser