[GRASS-user] Re: combining and evaluating vector dbf values

[maning sambale]

Geez!!! 2 days of banging my head I just did with sqlite databrowser
in 15 minutes (including create new mapset, download install sqlite,
and run concat to the database)
Thanks again!  And sqlite will be my default db driver for now.

cheers,
maning

On Wed, Nov 26, 2008 at 6:12 PM, Markus Neteler <neteler at osgeo.org> wrote:
> On Wed, Nov 26, 2008 at 10:45 AM, maning sambale
> <emmanuel.sambale at gmail.com> wrote:
>> Thanks for bringing some light into this dark FOSS GIS moments.
>
> :)
> Note that SQLite is the default driver in GRASS 7, so those dark moments
> shouldn't happen any more in future (mhh, maybe there will be others...).
>
> Markus
>
>> On Wed, Nov 26, 2008 at 5:42 PM, Markus Neteler <neteler at osgeo.org> wrote:
>>> On Wed, Nov 26, 2008 at 10:40 AM, maning sambale
>>> <emmanuel.sambale at gmail.com> wrote:
>>>> So, it's really a limitation inherent to the dbf driver?
>>>
>>> Yes. DBF != SQL... we hacked in a couple of SQL statements but not entire SQL92.
>>>
>>>> I guess sqlite it is.  Is it possible to g.copy again the vector from the
>>>> sqlite Mapset to the dbf Mapset?
>>>
>>> Sure!
>>>
>>> Best
>>> Markus
>>>
>>>> cheers,
>>>> maning
>>>>
>>>>
>>>> On Wed, Nov 26, 2008 at 5:36 PM, Markus Neteler <neteler at osgeo.org> wrote:
>>>>> On Tue, Nov 25, 2008 at 9:07 AM, maning sambale
>>>>> <emmanuel.sambale at gmail.com> wrote:
>>>>>> Nearly there but not quite:
>>>>>>
>>>>>> The final column should combine the values from the 2 columns, am I
>>>>>> right that concat doesn't work with dbf?
>>>>>>
>>>>>> So this doesn't work
>>>>>> echo "UPDATE vectormap SET c_COVER = a_COVER || a_value" | db.execute
>>>>>
>>>>> Did you try the SQLite driver?
>>>>>
>>>>> Just create a new mapset, define the connection with "db.connect" (see manual
>>>>> for copy-paste command) and "g.copy" the map from the DBF mapset
>>>>> into the sqlite mapset.
>>>>> Then the joys of SQL are available.
>>>>>
>>>>> Markus
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> |---------|----------------------------------------------------------|
>>>> | __.-._  |"Ohhh. Great warrior. Wars not make one great." -Yoda     |
>>>> | '-._"7' |"Freedom is still the most radical idea of all" -N.Branden|
>>>> |  /'.-c  |Linux registered user #402901, http://counter.li.org/     |
>>>> |  |  /T  |http://esambale.wikispaces.com/ |
>>>> | _)_/L I http://epsg4253.wordpress.com/ |
>>>> |---------|----------------------------------------------------------|
>>>>
>>>
>>>
>>>
>>> --
>>> Open Source Geospatial Foundation
>>> http://www.osgeo.org/
>>> http://www.grassbook.org/
>>>
>>
>>
>>
>> --
>> |---------|----------------------------------------------------------|
>> | __.-._  |"Ohhh. Great warrior. Wars not make one great." -Yoda     |
>> | '-._"7' |"Freedom is still the most radical idea of all" -N.Branden|
>> |  /'.-c  |Linux registered user #402901, http://counter.li.org/     |
>> |  |  /T  |http://esambale.wikispaces.com/ |
>> | _)_/L I http://epsg4253.wordpress.com/ |
>> |---------|----------------------------------------------------------|
>>
>
>
>
> --
> Open Source Geospatial Foundation
> http://www.osgeo.org/
> http://www.grassbook.org/
>



-- 
|---------|----------------------------------------------------------|
| __.-._  |"Ohhh. Great warrior. Wars not make one great." -Yoda     |
| '-._"7' |"Freedom is still the most radical idea of all" -N.Branden|
|  /'.-c  |Linux registered user #402901, http://counter.li.org/     |
|  |  /T  |http://esambale.wikispaces.com/ |
| _)_/L I http://epsg4253.wordpress.com/ |
|---------|----------------------------------------------------------|