[GRASS-user] Creating temp tables

GRASS GRASS user
,
1

41a8e3/attachment-0001.html

------------------------------

Message: 5
Date: Mon, 16 Jul 2007 12:30:54 -0500
From: "Nithi, Nachi K \(Karun\)" <karun@research.bell-labs.com>
Subject: [GRASS-user] Firstpost: Creatng temp tables instead of
  regular tables for vectormaps in mysql
To: <grassuser@grass.itc.it>
Message-ID:
  <858DDD4F5B8D924C955EB55302E4D1A801229949@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@onid.orst.edu
Subject: [GRASS-user] d.slide.show
To: grassuser@grass.itc.it
Message-ID: <20070716103456.bd7l9jp9icckcc08@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@sharechive.com>
Subject: [GRASS-user] One raster from many
To: <grassuser@grass.itc.it>
Message-ID:
  <5F0B60420177CA42B7759C56DC372C1D2CAE9E@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@o2.pl>
Subject: Re: [GRASS-user] One raster from many
To: "Daniel Farnan @ San Francisco" <DanielF@sharechive.com>
Cc: grassuser@grass.itc.it
Message-ID: <469BB612.8010206@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@o2.pl>
Subject: Re: [GRASS-user] One raster from many
To: "Daniel Farnan @ San Francisco" <DanielF@sharechive.com>
Cc: GRASSLIST <grassuser@grass.itc.it>
Message-ID: <469BB9C1.1040202@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. :slight_smile: 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@sharechive.com>
Subject: RE: [GRASS-user] One raster from many
To: <grassuser@grass.itc.it>
Message-ID:
  <5F0B60420177CA42B7759C56DC372C1D2CAEA3@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@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. :slight_smile: 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
*****************************************