[Qgis-user] Polygon from text coordinates

[Agustin Lobo]

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
>>
> 
> 
> 

-- 
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