[Qgis-user] Polygon from text coordinates

Tim Sutton tim at linfiniti.com
Tue Aug 5 16:57:56 EDT 2008


Hi

> On Tue, 2008-08-05 at 12:22 +0200, Agustin Lobo wrote:
>> Tim,
>>
>> what could I read in order to "know a little sql"?

Please bear in mind my reply was a kludge to help you solve an
immediate issue and is definately 'way off the map' in terms of what
we would expect a normal QGIS user to be doing.

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


I think the community team folks may have already compiled such a list
- it would be good to check with them. If I recall it was a list of
learning resources centered around QGIS. Yes I and others plan to
write more tutorial type content on programming with the QGIS api.
Myself and Martin and others already written several tutorlals on
blog.qgis.org though they tend to get out of date as we advance the
code base. For this reason I stopped until QGIS 1.0.0 comes out with
its attendant stable api.

>> Could I open this list in the wiki?

Please feel free - and perhaps discuss with the community team how
this may be linked in to the general plans they have.

Best regards

Tim

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



-- 
Tim Sutton
QGIS Project Steering Committee Member - Release Manager
Visit http://qgis.org for a great open source GIS
Blog: http://tim.linfiniti.com
Skype: timlinux
Irc: timlinux on #qgis at freenode.net


More information about the Qgis-user mailing list