[Qgis-user] Polygon from text coordinates

[Justin Fischer]

Agus,

I, personally, only know MySQL from the commandline, but I found a
little tutorial that might help:
http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html

This assumes you use Linux (or some other *nix) and are OK with using
the command line.

Justin


On Tue, 2008-08-05 at 12:22 +0200, Agustin Lobo wrote:
> Tim,
> 
> what could I read in order to "know a little sql"?
> I think that we should make a list of elementary
> readings and tutorials entitled "From elementary to advanced QGIS user:
> material for the initial steps".
> 
> In general, the most prominent advantage
> of QGIS comes when the user becomes able of developing his/her
> own tools with PostGIS, sql, python and the R interface.
> Perhaps we can select (or even write) basic material on these
> tools thinking on the QGIS user (that is, someone who feels
> comfortable with the QGIS menu but needs to develop specific
> tools). I understand that the priority now is writing guides
> and help pages for newcomers, but compiling a list such as the one
> I mention would not take a long time and could be very useful
> for people with some experience.
> Could I open this list in the wiki?
> 
> Agus
> 
> Tim Sutton wrote:
> > Hi
> > 
> > 2008/7/30 Agustin Lobo <aloboaleu at gmail.com>:
> >> Is it possible to define a polygon
> >> (actually easier, just a rectangle)
> >> using text coordinates?
> >> can bookmarks be saved as text files
> >> or exported as shp?
> >>
> > 
> > If you know a little sql you can do some tricks. The bookmarks are
> > stored in an sqlite3 database in your ~/.qgis/qgis.db database.
> > 
> > Using command line sql or one of several free sqlite3 admin frontends,
> > you can query to get out the bookmarks or create new ones e.g.
> > 
> > sqlite3 ~/.qgis/qgis.db
> > 
> > sqlite> select * from tbl_bookmarks;
> > 1|Test||-159.705|-132.842|153.48|136.971|-1
> > 2|test2||-159.705|-132.842|153.48|136.971|-1
> > ...
> > ...
> > 
> > Regards
> > 
> > Tim
> > 
> > 
> > 
> > 
> > 
> > 
> >> Thanks
> >> Agus
> >> --
> >> Dr. Agustin Lobo
> >> Institut de Ciencies de la Terra "Jaume Almera" (CSIC)
> >> LLuis Sole Sabaris s/n
> >> 08028 Barcelona
> >> Spain
> >> Tel. 34 934095410
> >> Fax. 34 934110012
> >> email: Agustin.Lobo at ija.csic.es
> >> http://www.ija.csic.es/gt/obster
> >> _______________________________________________
> >> Qgis-user mailing list
> >> Qgis-user at lists.osgeo.org
> >> http://lists.osgeo.org/mailman/listinfo/qgis-user
> >>
> > 
> > 
> > 
>