Re: [GRASS-user] Re: [Qgis-user] dbf editor for mac for grass and qgis
On Thu, Sep 25, 2008 at 1:42 PM, Daniel Victoria <[EMAIL PROTECTED]> wrote: > How about using sqlite? Does it have any limits? From my experience, > sqlite is easy to use in grass vectors and, with little effort, you > can connect it to oobase. Or just use sqlitebrowser or the command > line to edit the databases. > > Daniel SQLite is really nice and the driver has been quite improved recently. http://grass.osgeo.org/wiki/Openoffice.org_with_SQL_Databases See also http://sqlitebrowser.sourceforge.net/ https://addons.mozilla.org/en-US/firefox/addon/5817 - SQLite Manager Markus ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Re: [Qgis-user] dbf editor for mac for grass and qgis
maning sambale < > So I am looking (if there are) ways just to make it usable for now. In newer version of GRASS there is always v.db.update . or save you edits to a text file or spreadsheet.csv and when done add in SQL commands to db.execute it. H ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Re: [Qgis-user] dbf editor for mac for grass and qgis
How about using sqlite? Does it have any limits? From my experience, sqlite is easy to use in grass vectors and, with little effort, you can connect it to oobase. Or just use sqlitebrowser or the command line to edit the databases. Daniel On Thu, Sep 25, 2008 at 7:38 AM, maning sambale <[EMAIL PROTECTED]> wrote: > On Thu, Sep 25, 2008 at 6:33 PM, Nikos Alexandris > <[EMAIL PROTECTED]> wrote: >> On Thu, 2008-09-25 at 17:53 +0800, maning sambale wrote: >>> Just finished installing macports gnumeric and it does have the 65K row >>> limit >>> >> >> Oh! I am so sorry for the mis-information. I remembered a discussion we >> had at some point about those limits. The problem back then was about >> the limit of columns (256).The oss solution for that is 32767 for >> KSpread. >> >> Sorry, >> Nikos > > No need for apologies, I am actually pushing the limits to > spreadsheet apps, which shouldn't be. > >> > > > > -- > |-|--| > | __.-._ |"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| > | _)_/LI > |-|--| > ___ > grass-user mailing list > grass-user@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/grass-user > ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
[GRASS-user] Re: [Qgis-user] dbf editor for mac for grass and qgis
On Thu, Sep 25, 2008 at 6:33 PM, Nikos Alexandris <[EMAIL PROTECTED]> wrote: > On Thu, 2008-09-25 at 17:53 +0800, maning sambale wrote: >> Just finished installing macports gnumeric and it does have the 65K row limit >> > > Oh! I am so sorry for the mis-information. I remembered a discussion we > had at some point about those limits. The problem back then was about > the limit of columns (256).The oss solution for that is 32767 for > KSpread. > > Sorry, > Nikos No need for apologies, I am actually pushing the limits to spreadsheet apps, which shouldn't be. > -- |-|--| | __.-._ |"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| | _)_/LI |-|--| ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
[GRASS-user] Re: [Qgis-user] dbf editor for mac for grass and qgis
On Thu, 2008-09-25 at 17:53 +0800, maning sambale wrote: > Just finished installing macports gnumeric and it does have the 65K row limit > Oh! I am so sorry for the mis-information. I remembered a discussion we had at some point about those limits. The problem back then was about the limit of columns (256).The oss solution for that is 32767 for KSpread. Sorry, Nikos ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
[GRASS-user] Re: [Qgis-user] dbf editor for mac for grass and qgis
With this many records I would seriously consider moving to a professional database, such as PostgreSQL/Postgis or Oracle Spatial. Both should run on a Mac. Postgis is of course easier to install and maintain than Oracle. It is also cheaper. Andreas maning sambale wrote: Just finished installing macports gnumeric and it does have the 65K row limit On Thu, Sep 25, 2008 at 4:56 PM, maning sambale <[EMAIL PROTECTED]> wrote: Thanks for that tip. I'm installing from macports now. But I read somewhere that: GNUmeric could accept more than 256 columns and more of 65000 rows (needs to be re-compiled) On Thu, Sep 25, 2008 at 4:47 PM, Nikos Alexandris <[EMAIL PROTECTED]> wrote: On Thu, 2008-09-25 at 16:38 +0800, maning sambale wrote: Hi, My usual workflow is like this: All my vectors are in GRASS database and I view them with QGIS. For editing vector attributes, I basically browse the GRASS vectors in QGIS then edit the dbf attributes with OpenOffice calc or base. So far so good. This time I have a vector with more than 100K records. Editing with calc is not possible (hitting the limit of 65K rows) and its painstakingly slow in OO base. Can you use Gnumeric? It's faster and limitless :-) ...ok, maybe no limitless but reads bigger files than OOo I'm looking for ways to speed things up. I cannot find a decent dbf editor for mac. Any ideas? cheers, maning -- |-|--| | __.-._ |"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| | _)_/LI |-|--| -- -- Andreas Neumann Böschacherstrasse 6 CH-8624 Grüt (Gossau ZH) Switzerland Phone: ++41-44-2736668 Email: [EMAIL PROTECTED] Web: http://www.carto.net/neumann/ SVG Examples: http://www.carto.net/papers/svg/samples/ SVG.Open: http://www.svgopen.org/ ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Re: [Qgis-user] dbf editor for mac for grass and qgis
On 25/09/08 12:07, maning sambale wrote: Andreas, I agree with you. I actually have postgresql installed on my mac. But this would just be a temporary vector file (an input to a satellite classification). So I am looking (if there are) ways just to make it usable for now. I might consider postgis if all quick and dirty efforts would be fruitless AFAIK, you can change the max number of rows in gnumeric (at least in recent versions) by recompiling. Moritz cheers, maning On Thu, Sep 25, 2008 at 5:57 PM, Andreas Neumann <[EMAIL PROTECTED]> wrote: With this many records I would seriously consider moving to a professional database, such as PostgreSQL/Postgis or Oracle Spatial. Both should run on a Mac. Postgis is of course easier to install and maintain than Oracle. It is also cheaper. Andreas maning sambale wrote: Just finished installing macports gnumeric and it does have the 65K row limit On Thu, Sep 25, 2008 at 4:56 PM, maning sambale <[EMAIL PROTECTED]> wrote: Thanks for that tip. I'm installing from macports now. But I read somewhere that: GNUmeric could accept more than 256 columns and more of 65000 rows (needs to be re-compiled) On Thu, Sep 25, 2008 at 4:47 PM, Nikos Alexandris <[EMAIL PROTECTED]> wrote: On Thu, 2008-09-25 at 16:38 +0800, maning sambale wrote: Hi, My usual workflow is like this: All my vectors are in GRASS database and I view them with QGIS. For editing vector attributes, I basically browse the GRASS vectors in QGIS then edit the dbf attributes with OpenOffice calc or base. So far so good. This time I have a vector with more than 100K records. Editing with calc is not possible (hitting the limit of 65K rows) and its painstakingly slow in OO base. Can you use Gnumeric? It's faster and limitless :-) ...ok, maybe no limitless but reads bigger files than OOo I'm looking for ways to speed things up. I cannot find a decent dbf editor for mac. Any ideas? cheers, maning -- |-|--| | __.-._ |"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| | _)_/LI |-|--| -- -- Andreas Neumann Böschacherstrasse 6 CH-8624 Grüt (Gossau ZH) Switzerland Phone: ++41-44-2736668 Email: [EMAIL PROTECTED] Web: http://www.carto.net/neumann/ SVG Examples: http://www.carto.net/papers/svg/samples/ SVG.Open: http://www.svgopen.org/ ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
[GRASS-user] Re: [Qgis-user] dbf editor for mac for grass and qgis
Andreas, I agree with you. I actually have postgresql installed on my mac. But this would just be a temporary vector file (an input to a satellite classification). So I am looking (if there are) ways just to make it usable for now. I might consider postgis if all quick and dirty efforts would be fruitless cheers, maning On Thu, Sep 25, 2008 at 5:57 PM, Andreas Neumann <[EMAIL PROTECTED]> wrote: > With this many records I would seriously consider moving to a professional > database, such as PostgreSQL/Postgis or Oracle Spatial. Both should run on a > Mac. Postgis is of course easier to install and maintain than Oracle. It is > also cheaper. > > Andreas > > maning sambale wrote: >> >> Just finished installing macports gnumeric and it does have the 65K row >> limit >> >> On Thu, Sep 25, 2008 at 4:56 PM, maning sambale >> <[EMAIL PROTECTED]> wrote: >>> >>> Thanks for that tip. I'm installing from macports now. >>> But I read somewhere that: GNUmeric could accept more than 256 columns >>> and more of 65000 rows (needs to be re-compiled) >>> >>> On Thu, Sep 25, 2008 at 4:47 PM, Nikos Alexandris >>> <[EMAIL PROTECTED]> wrote: On Thu, 2008-09-25 at 16:38 +0800, maning sambale wrote: > > Hi, > > My usual workflow is like this: > > All my vectors are in GRASS database and I view them with QGIS. > For editing vector attributes, I basically browse the GRASS vectors in > QGIS then edit the dbf attributes with OpenOffice calc or base. > So far so good. This time I have a vector with more than 100K > records. Editing with calc is not possible (hitting the limit of 65K > rows) and its painstakingly slow in OO base. Can you use Gnumeric? It's faster and limitless :-) ...ok, maybe no limitless but reads bigger files than OOo > > I'm looking for ways to speed things up. I cannot find a decent dbf > editor for mac. Any ideas? > > cheers, > maning > >>> >>> >>> -- >>> |-|--| >>> | __.-._ |"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| >>> | _)_/LI >>> |-|--| >>> >> >> >> > > -- > > -- > Andreas Neumann > Böschacherstrasse 6 > CH-8624 Grüt (Gossau ZH) > Switzerland > Phone: ++41-44-2736668 > Email: [EMAIL PROTECTED] > > Web: http://www.carto.net/neumann/ > SVG Examples: http://www.carto.net/papers/svg/samples/ > SVG.Open: http://www.svgopen.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| | _)_/LI |-|--| ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
[GRASS-user] Re: [Qgis-user] dbf editor for mac for grass and qgis
Just finished installing macports gnumeric and it does have the 65K row limit On Thu, Sep 25, 2008 at 4:56 PM, maning sambale <[EMAIL PROTECTED]> wrote: > Thanks for that tip. I'm installing from macports now. > But I read somewhere that: GNUmeric could accept more than 256 columns > and more of 65000 rows (needs to be re-compiled) > > On Thu, Sep 25, 2008 at 4:47 PM, Nikos Alexandris > <[EMAIL PROTECTED]> wrote: >> On Thu, 2008-09-25 at 16:38 +0800, maning sambale wrote: >>> Hi, >>> >>> My usual workflow is like this: >>> >>> All my vectors are in GRASS database and I view them with QGIS. >>> For editing vector attributes, I basically browse the GRASS vectors in >>> QGIS then edit the dbf attributes with OpenOffice calc or base. >>> So far so good. This time I have a vector with more than 100K >>> records. Editing with calc is not possible (hitting the limit of 65K >>> rows) and its painstakingly slow in OO base. >> Can you use Gnumeric? It's faster and limitless :-) ...ok, maybe no >> limitless but reads bigger files than OOo >>> >>> I'm looking for ways to speed things up. I cannot find a decent dbf >>> editor for mac. Any ideas? >>> >>> cheers, >>> maning >>> >> >> > > > > -- > |-|--| > | __.-._ |"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| > | _)_/LI > |-|--| > -- |-|--| | __.-._ |"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| | _)_/LI |-|--| ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
[GRASS-user] Re: [Qgis-user] dbf editor for mac for grass and qgis
On Thu, 2008-09-25 at 16:38 +0800, maning sambale wrote: > Hi, > > My usual workflow is like this: > > All my vectors are in GRASS database and I view them with QGIS. > For editing vector attributes, I basically browse the GRASS vectors in > QGIS then edit the dbf attributes with OpenOffice calc or base. > So far so good. This time I have a vector with more than 100K > records. Editing with calc is not possible (hitting the limit of 65K > rows) and its painstakingly slow in OO base. Can you use Gnumeric? It's faster and limitless :-) ...ok, maybe no limitless but reads bigger files than OOo > > I'm looking for ways to speed things up. I cannot find a decent dbf > editor for mac. Any ideas? > > cheers, > maning > ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user