<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Hello,<BR>
<BR>
How can I export a Postgis table to access or excel table?<BR>
<BR>
Thanks.<BR><BR><BR>
<DIV>Saludos, <BR>----------- <BR>Antonio García Benlloch <BR><BR><STRONG>Correo: <BR></STRONG>angarben@hotmail.com <BR><A href="mailto:angarben@aaa.upv.es">angarben@aaa.upv.es</A> <BR><BR><STRONG>Web: <BR></STRONG>http://personales.alumno.upv.es/~angarben</DIV><BR><BR>> From: postgis-users-request@postgis.refractions.net<BR>> Subject: postgis-users Digest, Vol 66, Issue 8<BR>> To: postgis-users@postgis.refractions.net<BR>> Date: Tue, 8 Apr 2008 12:00:52 -0700<BR>> <BR>> Send postgis-users mailing list submissions to<BR>> postgis-users@postgis.refractions.net<BR>> <BR>> To subscribe or unsubscribe via the World Wide Web, visit<BR>> http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> or, via email, send a message with subject or body 'help' to<BR>> postgis-users-request@postgis.refractions.net<BR>> <BR>> You can reach the person managing the list at<BR>> postgis-users-owner@postgis.refractions.net<BR>> <BR>> When replying, please edit your Subject line so it is more specific<BR>> than "Re: Contents of postgis-users digest..."<BR>> <BR>> <BR>> Today's Topics:<BR>> <BR>> 1. 1.3.3 Pre-Release Notice (Paul Ramsey)<BR>> 2. SQLite and postGIS (Stephen Woodbridge)<BR>> 3. Re: SQLite and postGIS (William Kyngesburye)<BR>> 4. Re: SQLite and postGIS (Shoaib Burq)<BR>> 5. Loading only data that intersects another feature<BR>> (Marcus C. England)<BR>> 6. Re: postgis mapfile php (nickthegreek-)<BR>> 7. RE: Loading only data that intersects another feature<BR>> (Randall, Eric)<BR>> 8. Re: SQLite and postGIS (Stephen Woodbridge)<BR>> 9. Re: SQLite and postGIS (P Kishor)<BR>> 10. Re: SQLite and postGIS (Stephen Woodbridge)<BR>> 11. Re: SQLite and postGIS (P Kishor)<BR>> 12. Re: SQLite and postGIS (mchapman@texelinc.com)<BR>> 13. Re: SQLite and postGIS (Stephen Woodbridge)<BR>> 14. Best graphical viewer for PostGIS data (Pierre Racine)<BR>> 15. Re: Best graphical viewer for PostGIS data (Chris Hermansen)<BR>> 16. RE: Best graphical viewer for PostGIS data (Obe, Regina)<BR>> 17. RE: Best graphical viewer for PostGIS data (Randall, Eric)<BR>> 18. Re: Best graphical viewer for PostGIS data (Nicolas Ribot)<BR>> 19. R: [postgis-users] Best graphical viewer for PostGIS data<BR>> (P.Rizzi Ag.Mobilit? Ambiente)<BR>> 20. Re: Best graphical viewer for PostGIS data (Kevin Neufeld)<BR>> 21. Re: SQLite and postGIS (Martin Davis)<BR>> 22. Re: SQLite and postGIS (P Kishor)<BR>> <BR>> <BR>> ----------------------------------------------------------------------<BR>> <BR>> Message: 1<BR>> Date: Mon, 7 Apr 2008 14:12:42 -0700<BR>> From: "Paul Ramsey" <pramsey@cleverelephant.ca><BR>> Subject: [postgis-users] 1.3.3 Pre-Release Notice<BR>> To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>> <30fe546d0804071412h6d0c4dd7q25b0e34be63a8f1d@mail.gmail.com><BR>> Content-Type: text/plain; charset=ISO-8859-1<BR>> <BR>> Folks,<BR>> <BR>> 1.3.3 is going to be coming out by the end of this week. If you have<BR>> time, please pull the SVN version and give it a try, to ensure we<BR>> haven't left any big bugs in the bin.<BR>> <BR>> Thanks!<BR>> <BR>> Paul<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 2<BR>> Date: Mon, 07 Apr 2008 17:34:20 -0500<BR>> From: Stephen Woodbridge <woodbri@swoodbridge.com><BR>> Subject: [postgis-users] SQLite and postGIS<BR>> To: Paul Ramsey <pramsey@cleverelephant.ca>, PostGIS Users Discussion<BR>> <postgis-users@postgis.refractions.net><BR>> Message-ID: <47FAA16C.8050104@swoodbridge.com><BR>> Content-Type: text/plain; charset=UTF-8; format=flowed<BR>> <BR>> Hi Paul,<BR>> <BR>> I have started using SQLite for some projects, mostly just as a backing <BR>> store for manipulating some data. I can't help but think it would be <BR>> cool if it would be possible to get something like postGIS running in it.<BR>> <BR>> I know you guys did some analysis of various databases a while back with <BR>> an eye to their spatial potential and suitability for postGIS like <BR>> inclusion - well at least that was my impression.<BR>> <BR>> Did you look at SQLite?<BR>> Have you worked with SQLite?<BR>> Got any thoughts on this? Anyone?<BR>> <BR>> I wish I could say I had a client interested in funding, but <sigh> I <BR>> don't. But I have found myself googling for info on it 4 separate times <BR>> in the past week, which is strange because I have no immediate use.<BR>> <BR>> The use case for something like this would be to build a standalone <BR>> application or web service that has a SQL/Spatial back-end without the <BR>> need for installing and administering a postgres database.<BR>> <BR>> As best as I can tell, the major hurdle would be whether or not it is <BR>> possible for a reasonable amount of effort to integrate a spatial index <BR>> system into SQLite.<BR>> <BR>> Anyway, thought I would ask? See what other people thought?<BR>> <BR>> Thanks,<BR>> -Steve<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 3<BR>> Date: Mon, 7 Apr 2008 16:50:28 -0500<BR>> From: William Kyngesburye <woklist@kyngchaos.com><BR>> Subject: Re: [postgis-users] SQLite and postGIS<BR>> To: PostGIS Users Discussion <postgis-users@postgis.refractions.net><BR>> Message-ID: <F1360DB6-5F15-4FF0-9F96-07F00F26C4B6@kyngchaos.com><BR>> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes<BR>> <BR>> Someone started something already. Basic for now - good for <BR>> exchanging geodata.<BR>> <BR>> http://www.gaia-gis.it/spatialite/<BR>> <BR>> On Apr 7, 2008, at 5:34 PM, Stephen Woodbridge wrote:<BR>> <BR>> > Hi Paul,<BR>> ><BR>> > I have started using SQLite for some projects, mostly just as a <BR>> > backing store for manipulating some data. I can't help but think it <BR>> > would be cool if it would be possible to get something like postGIS <BR>> > running in it.<BR>> ><BR>> > I know you guys did some analysis of various databases a while back <BR>> > with an eye to their spatial potential and suitability for postGIS <BR>> > like inclusion - well at least that was my impression.<BR>> ><BR>> > Did you look at SQLite?<BR>> > Have you worked with SQLite?<BR>> > Got any thoughts on this? Anyone?<BR>> ><BR>> > I wish I could say I had a client interested in funding, but <sigh> <BR>> > I don't. But I have found myself googling for info on it 4 separate <BR>> > times in the past week, which is strange because I have no immediate <BR>> > use.<BR>> ><BR>> > The use case for something like this would be to build a standalone <BR>> > application or web service that has a SQL/Spatial back-end without <BR>> > the need for installing and administering a postgres database.<BR>> ><BR>> > As best as I can tell, the major hurdle would be whether or not it <BR>> > is possible for a reasonable amount of effort to integrate a spatial <BR>> > index system into SQLite.<BR>> ><BR>> > Anyway, thought I would ask? See what other people thought?<BR>> ><BR>> > Thanks,<BR>> > -Steve<BR>> > _______________________________________________<BR>> > postgis-users mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> <BR>> -----<BR>> William Kyngesburye <kyngchaos*at*kyngchaos*dot*com><BR>> http://www.kyngchaos.com/<BR>> <BR>> "Oh, look, I seem to have fallen down a deep, dark hole. Now what <BR>> does that remind me of? Ah, yes - life."<BR>> <BR>> - Marvin<BR>> <BR>> <BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 4<BR>> Date: Tue, 8 Apr 2008 07:52:20 +1000<BR>> From: "Shoaib Burq" <shoaib@nomad-labs.com><BR>> Subject: Re: [postgis-users] SQLite and postGIS<BR>> To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>> <b8b84f110804071452n47dbe3f1y9f8a05b75e30f7f7@mail.gmail.com><BR>> Content-Type: text/plain; charset=ISO-8859-1<BR>> <BR>> You are not alone... I have been using SQLite for my web mapping<BR>> applications precisely because its so quick to get it running.<BR>> <BR>> I have not had the need to do any advance spatial functions but I can<BR>> imagine it would be nice to have.<BR>> <BR>> Has anyone done a preliminary check of how hard it would be to add<BR>> support for Simple Features and Spatial Indices to start with? Perhaps<BR>> its time to start. I'm going to be in the USofA 1-24 May if anyone<BR>> wants to meetup<BR>> <BR>> Shoaib Burq<BR>> --<BR>> http://rails.nomad-labs.com<BR>> <BR>> On Tue, Apr 8, 2008 at 8:34 AM, Stephen Woodbridge<BR>> <woodbri@swoodbridge.com> wrote:<BR>> > Hi Paul,<BR>> ><BR>> > I have started using SQLite for some projects, mostly just as a backing<BR>> > store for manipulating some data. I can't help but think it would be cool if<BR>> > it would be possible to get something like postGIS running in it.<BR>> ><BR>> > I know you guys did some analysis of various databases a while back with an<BR>> > eye to their spatial potential and suitability for postGIS like inclusion -<BR>> > well at least that was my impression.<BR>> ><BR>> > Did you look at SQLite?<BR>> > Have you worked with SQLite?<BR>> > Got any thoughts on this? Anyone?<BR>> ><BR>> > I wish I could say I had a client interested in funding, but <sigh> I<BR>> > don't. But I have found myself googling for info on it 4 separate times in<BR>> > the past week, which is strange because I have no immediate use.<BR>> ><BR>> > The use case for something like this would be to build a standalone<BR>> > application or web service that has a SQL/Spatial back-end without the need<BR>> > for installing and administering a postgres database.<BR>> ><BR>> > As best as I can tell, the major hurdle would be whether or not it is<BR>> > possible for a reasonable amount of effort to integrate a spatial index<BR>> > system into SQLite.<BR>> ><BR>> > Anyway, thought I would ask? See what other people thought?<BR>> ><BR>> > Thanks,<BR>> > -Steve<BR>> > _______________________________________________<BR>> > postgis-users mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> ><BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 5<BR>> Date: Mon, 07 Apr 2008 16:22:31 -0700<BR>> From: "Marcus C. England" <marcuscengland@gmail.com><BR>> Subject: [postgis-users] Loading only data that intersects another<BR>> feature<BR>> To: postgis-users@postgis.refractions.net<BR>> Message-ID: <47FAACB7.7020907@gmail.com><BR>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed<BR>> <BR>> Hi all,<BR>> <BR>> I have a postgis polygon layer representing a site boundary (we will <BR>> call the layer "boundary") and another postgis point layer with a larger <BR>> extent representing California condor observations (we will call the <BR>> layer "condors"). I am using gvSIG which allows SQL restrictions of <BR>> layer loads from postgis. What SQL statement would I use (keep in mind <BR>> the above layer names) to only load the "condors" data that intersects <BR>> "boundary"?<BR>> <BR>> -Marcus<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 6<BR>> Date: Mon, 7 Apr 2008 16:39:00 -0700 (PDT)<BR>> From: nickthegreek- <nickthegreek_@hotmail.com><BR>> Subject: Re: [postgis-users] postgis mapfile php<BR>> To: postgis-users@postgis.refractions.net<BR>> Message-ID: <16543003.post@talk.nabble.com><BR>> Content-Type: text/plain; charset=us-ascii<BR>> <BR>> <BR>> <select namex="mydropdown"><BR>> <BR>> <?php <BR>> for ($lt = 0; $lt < pg_numrows($myresult); $lt++) {<BR>> $id = pg_result($myresult, $lt, 0);<BR>> <BR>> ?><BR>> <option value="name"> <?php echo $id;?> </option><BR>> <?php<BR>> }<BR>> <BR>> ?><BR>> </select><BR>> <BR>> <input type="checkbox" name="layer[]"<BR>> value="countries" <?php echo $countries;?> ><BR>> <BR>> <BR>> i have this select whick takes the results from a column from a database...<BR>> i haven;t put this select in a form cause it will be inside an othe form ..<BR>> but i think it works perfect as it nows... <BR>> <BR>> how can i take the selected value from the menu? which is ? $namex? <BR>> $mydropdown??<BR>> <BR>> and how can i put it here.. like ..<BR>> <BR>> the_geom from ( select gid, the_geom from europe_country where<BR>> name='$namex') as foo using unique gid using srid=-1<BR>> -- <BR>> View this message in context: http://www.nabble.com/postgis-mapfile-php-tp16530438p16543003.html<BR>> Sent from the PostGIS - User mailing list archive at Nabble.com.<BR>> <BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 7<BR>> Date: Mon, 7 Apr 2008 19:49:10 -0400<BR>> From: "Randall, Eric" <ERandall@eriecountygov.org><BR>> Subject: RE: [postgis-users] Loading only data that intersects another<BR>> feature<BR>> To: <marcuscengland@gmail.com>, "PostGIS Users Discussion"<BR>> <postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>> <CD32AE6ACD828644B29601ADC966FDCB01B4A9B7@ex1.eriecountygov.local><BR>> Content-Type: text/plain; charset="iso-8859-1"<BR>> <BR>> select condors.*<BR>> from condors, boundary<BR>> where st_within(condors.the_geom,boundary.the_geom)<BR>> <BR>> or <BR>> <BR>> select condors.*<BR>> from condors, boundary<BR>> where st_intersects(condors.the_geom,boundary.the_geom)<BR>> <BR>> <BR>> I would suggest that you download and install OpenJump and the dbquery plugin.<BR>> That way you can experiment with ad hoc spatial queries<BR>> using the many postgis functions and visually see the results of each.<BR>> A great way to see postgis functionality. Mezogis is also good for this but I like OpenJump.<BR>> <BR>> -Eric<BR>> <BR>> -----Original Message-----<BR>> From: postgis-users-bounces@postgis.refractions.net<BR>> [mailto:postgis-users-bounces@postgis.refractions.net]On Behalf Of<BR>> Marcus C. England<BR>> Sent: Monday, April 07, 2008 7:23 PM<BR>> To: postgis-users@postgis.refractions.net<BR>> Subject: [postgis-users] Loading only data that intersects another<BR>> feature<BR>> <BR>> <BR>> Hi all,<BR>> <BR>> I have a postgis polygon layer representing a site boundary (we will <BR>> call the layer "boundary") and another postgis point layer with a larger <BR>> extent representing California condor observations (we will call the <BR>> layer "condors"). I am using gvSIG which allows SQL restrictions of <BR>> layer loads from postgis. What SQL statement would I use (keep in mind <BR>> the above layer names) to only load the "condors" data that intersects <BR>> "boundary"?<BR>> <BR>> -Marcus<BR>> _______________________________________________<BR>> postgis-users mailing list<BR>> postgis-users@postgis.refractions.net<BR>> http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 8<BR>> Date: Mon, 07 Apr 2008 20:17:20 -0500<BR>> From: Stephen Woodbridge <woodbri@swoodbridge.com><BR>> Subject: Re: [postgis-users] SQLite and postGIS<BR>> To: William Kyngesburye <kyngchaos@kyngchaos.com><BR>> Cc: PostGIS Users Discussion <postgis-users@postgis.refractions.net><BR>> Message-ID: <47FAC7A0.5000109@swoodbridge.com><BR>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed<BR>> <BR>> William,<BR>> <BR>> Thanks for the pointer. I will check it out.<BR>> Doesn't look like they have spatial indexes, but it does look like an <BR>> interesting start.<BR>> <BR>> -Steve<BR>> <BR>> William Kyngesburye wrote:<BR>> > Someone started something already. Basic for now - good for exchanging <BR>> > geodata.<BR>> > <BR>> > http://www.gaia-gis.it/spatialite/<BR>> > <BR>> > On Apr 7, 2008, at 5:34 PM, Stephen Woodbridge wrote:<BR>> > <BR>> >> Hi Paul,<BR>> >><BR>> >> I have started using SQLite for some projects, mostly just as a <BR>> >> backing store for manipulating some data. I can't help but think it <BR>> >> would be cool if it would be possible to get something like postGIS <BR>> >> running in it.<BR>> >><BR>> >> I know you guys did some analysis of various databases a while back <BR>> >> with an eye to their spatial potential and suitability for postGIS <BR>> >> like inclusion - well at least that was my impression.<BR>> >><BR>> >> Did you look at SQLite?<BR>> >> Have you worked with SQLite?<BR>> >> Got any thoughts on this? Anyone?<BR>> >><BR>> >> I wish I could say I had a client interested in funding, but <sigh> I <BR>> >> don't. But I have found myself googling for info on it 4 separate <BR>> >> times in the past week, which is strange because I have no immediate use.<BR>> >><BR>> >> The use case for something like this would be to build a standalone <BR>> >> application or web service that has a SQL/Spatial back-end without the <BR>> >> need for installing and administering a postgres database.<BR>> >><BR>> >> As best as I can tell, the major hurdle would be whether or not it is <BR>> >> possible for a reasonable amount of effort to integrate a spatial <BR>> >> index system into SQLite.<BR>> >><BR>> >> Anyway, thought I would ask? See what other people thought?<BR>> >><BR>> >> Thanks,<BR>> >> -Steve<BR>> >> _______________________________________________<BR>> >> postgis-users mailing list<BR>> >> postgis-users@postgis.refractions.net<BR>> >> http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> > <BR>> > -----<BR>> > William Kyngesburye <kyngchaos*at*kyngchaos*dot*com><BR>> > http://www.kyngchaos.com/<BR>> > <BR>> > "Oh, look, I seem to have fallen down a deep, dark hole. Now what does <BR>> > that remind me of? Ah, yes - life."<BR>> > <BR>> > - Marvin<BR>> > <BR>> > <BR>> <BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 9<BR>> Date: Mon, 7 Apr 2008 21:18:24 -0400<BR>> From: "P Kishor" <punk.kish@gmail.com><BR>> Subject: Re: [postgis-users] SQLite and postGIS<BR>> To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>> <cdf6db500804071818g55286e19odc8e06e23da1f177@mail.gmail.com><BR>> Content-Type: text/plain; charset=ISO-8859-1<BR>> <BR>> On 4/7/08, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:<BR>> > Hi Paul,<BR>> ><BR>> > I have started using SQLite for some projects, mostly just as a backing<BR>> > store for manipulating some data. I can't help but think it would be cool if<BR>> > it would be possible to get something like postGIS running in it.<BR>> ><BR>> > I know you guys did some analysis of various databases a while back with an<BR>> > eye to their spatial potential and suitability for postGIS like inclusion -<BR>> > well at least that was my impression.<BR>> ><BR>> > Did you look at SQLite?<BR>> > Have you worked with SQLite?<BR>> > Got any thoughts on this? Anyone?<BR>> ><BR>> > I wish I could say I had a client interested in funding, but <sigh> I<BR>> > don't. But I have found myself googling for info on it 4 separate times in<BR>> > the past week, which is strange because I have no immediate use.<BR>> ><BR>> > The use case for something like this would be to build a standalone<BR>> > application or web service that has a SQL/Spatial back-end without the need<BR>> > for installing and administering a postgres database.<BR>> ><BR>> > As best as I can tell, the major hurdle would be whether or not it is<BR>> > possible for a reasonable amount of effort to integrate a spatial index<BR>> > system into SQLite.<BR>> ><BR>> > Anyway, thought I would ask? See what other people thought?<BR>> <BR>> Did you see a thread that I started on OSGeo Discuss a few months<BR>> ago... it kinda devolved into (dare I say, degenerated into) a very<BR>> long and unproductive back and forth, but my idea was a SQLiteGIS on<BR>> the lines of PostGIS.<BR>> <BR>> I actually wrote a pretty useful point-in-polygon routine using Perl<BR>> DBD::SQLite unwrapping Shapefiles into a SQLite db and then using<BR>> SQLite for boundary matching. It was for a very large p-in-p (7.5<BR>> million points against 250k polys) that ArcGIS was choking over. Works<BR>> very sweet in Perl/SQLite in about 20% to 30% of the time taken.<BR>> <BR>> I often wonder what would it take to graft Geos inside SQlite. Too bad<BR>> I know nothing about C++.<BR>> <BR>> <BR>> ><BR>> > Thanks,<BR>> > -Steve<BR>> > _______________________________________________<BR>> > postgis-users mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> ><BR>> <BR>> <BR>> -- <BR>> Puneet Kishor http://punkish.eidesis.org/<BR>> Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/<BR>> Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 10<BR>> Date: Mon, 07 Apr 2008 22:02:45 -0500<BR>> From: Stephen Woodbridge <woodbri@swoodbridge.com><BR>> Subject: Re: [postgis-users] SQLite and postGIS<BR>> To: punkish@eidesis.org, PostGIS Users Discussion<BR>> <postgis-users@postgis.refractions.net><BR>> Message-ID: <47FAE055.90002@swoodbridge.com><BR>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed<BR>> <BR>> P Kishor wrote:<BR>> > On 4/7/08, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:<BR>> >> Hi Paul,<BR>> >><BR>> >> I have started using SQLite for some projects, mostly just as a backing<BR>> >> store for manipulating some data. I can't help but think it would be cool if<BR>> >> it would be possible to get something like postGIS running in it.<BR>> >><BR>> >> I know you guys did some analysis of various databases a while back with an<BR>> >> eye to their spatial potential and suitability for postGIS like inclusion -<BR>> >> well at least that was my impression.<BR>> >><BR>> >> Did you look at SQLite?<BR>> >> Have you worked with SQLite?<BR>> >> Got any thoughts on this? Anyone?<BR>> >><BR>> >> I wish I could say I had a client interested in funding, but <sigh> I<BR>> >> don't. But I have found myself googling for info on it 4 separate times in<BR>> >> the past week, which is strange because I have no immediate use.<BR>> >><BR>> >> The use case for something like this would be to build a standalone<BR>> >> application or web service that has a SQL/Spatial back-end without the need<BR>> >> for installing and administering a postgres database.<BR>> >><BR>> >> As best as I can tell, the major hurdle would be whether or not it is<BR>> >> possible for a reasonable amount of effort to integrate a spatial index<BR>> >> system into SQLite.<BR>> >><BR>> >> Anyway, thought I would ask? See what other people thought?<BR>> > <BR>> > Did you see a thread that I started on OSGeo Discuss a few months<BR>> > ago... it kinda devolved into (dare I say, degenerated into) a very<BR>> > long and unproductive back and forth, but my idea was a SQLiteGIS on<BR>> > the lines of PostGIS.<BR>> <BR>> Yes, I think I came across a few of your posting while searching google.<BR>> <BR>> > I actually wrote a pretty useful point-in-polygon routine using Perl<BR>> > DBD::SQLite unwrapping Shapefiles into a SQLite db and then using<BR>> > SQLite for boundary matching. It was for a very large p-in-p (7.5<BR>> > million points against 250k polys) that ArcGIS was choking over. Works<BR>> > very sweet in Perl/SQLite in about 20% to 30% of the time taken.<BR>> <BR>> Did you try this same example in postgis using indexes? It would be <BR>> interesting to see how it compares. P-in-p can be optimized to work much <BR>> faster than the GEOS code so it is likely that some purposed code would <BR>> be much faster than the generalized code in postGIS although there has <BR>> been some discussions on the dev list about changing that. It might even <BR>> be in the newest code, I haven't had a chance to upgrade yet.<BR>> <BR>> > I often wonder what would it take to graft Geos inside SQlite. Too bad<BR>> > I know nothing about C++.<BR>> <BR>> There is a C-API to GEOS, so you do not need to know C++ and I imagine <BR>> that with the work already done at http://www.gaia-gis.it/spatialite/ it <BR>> should be pretty to write wrapper functions to expose more of GEOS <BR>> within spatialite.<BR>> <BR>> I also think that there might be a Perl GEOS SWIG wrapper, but I haven't <BR>> looked for it.<BR>> <BR>> The real limiting issue will be spatial indexes and this is probably the <BR>> most difficult item to develop and integrate into the existing code. I <BR>> have not clue what all it would take.<BR>> <BR>> -Steve<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 11<BR>> Date: Mon, 7 Apr 2008 22:06:57 -0400<BR>> From: "P Kishor" <punk.kish@gmail.com><BR>> Subject: Re: [postgis-users] SQLite and postGIS<BR>> To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>> <cdf6db500804071906l4aa515aey78ccfe30704ff297@mail.gmail.com><BR>> Content-Type: text/plain; charset=ISO-8859-1<BR>> <BR>> On 4/7/08, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:<BR>> > P Kishor wrote:<BR>> ><BR>> > > On 4/7/08, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:<BR>> > ><BR>> > > > Hi Paul,<BR>> > > ><BR>> > > > I have started using SQLite for some projects, mostly just as a backing<BR>> > > > store for manipulating some data. I can't help but think it would be<BR>> > cool if<BR>> > > > it would be possible to get something like postGIS running in it.<BR>> > > ><BR>> > > > I know you guys did some analysis of various databases a while back<BR>> > with an<BR>> > > > eye to their spatial potential and suitability for postGIS like<BR>> > inclusion -<BR>> > > > well at least that was my impression.<BR>> > > ><BR>> > > > Did you look at SQLite?<BR>> > > > Have you worked with SQLite?<BR>> > > > Got any thoughts on this? Anyone?<BR>> > > ><BR>> > > > I wish I could say I had a client interested in funding, but <sigh> I<BR>> > > > don't. But I have found myself googling for info on it 4 separate times<BR>> > in<BR>> > > > the past week, which is strange because I have no immediate use.<BR>> > > ><BR>> > > > The use case for something like this would be to build a standalone<BR>> > > > application or web service that has a SQL/Spatial back-end without the<BR>> > need<BR>> > > > for installing and administering a postgres database.<BR>> > > ><BR>> > > > As best as I can tell, the major hurdle would be whether or not it is<BR>> > > > possible for a reasonable amount of effort to integrate a spatial index<BR>> > > > system into SQLite.<BR>> > > ><BR>> > > > Anyway, thought I would ask? See what other people thought?<BR>> > > ><BR>> > ><BR>> > > Did you see a thread that I started on OSGeo Discuss a few months<BR>> > > ago... it kinda devolved into (dare I say, degenerated into) a very<BR>> > > long and unproductive back and forth, but my idea was a SQLiteGIS on<BR>> > > the lines of PostGIS.<BR>> > ><BR>> ><BR>> > Yes, I think I came across a few of your posting while searching google.<BR>> ><BR>> ><BR>> > > I actually wrote a pretty useful point-in-polygon routine using Perl<BR>> > > DBD::SQLite unwrapping Shapefiles into a SQLite db and then using<BR>> > > SQLite for boundary matching. It was for a very large p-in-p (7.5<BR>> > > million points against 250k polys) that ArcGIS was choking over. Works<BR>> > > very sweet in Perl/SQLite in about 20% to 30% of the time taken.<BR>> > ><BR>> ><BR>> > Did you try this same example in postgis using indexes?<BR>> <BR>> In that specific case, PostGIS was *not* an option. I could not run<BR>> another server (PostGres) on the computer, but running a file-based<BR>> program was not a problem Somehow, SQLite just seems like the right<BR>> thing, small, flexible, powerful. So, I made do with what I had. And<BR>> the success in that encouraged me to think that this could be<BR>> extended.<BR>> <BR>> I also wrote a bunch of Perl modules to work on ArcGIS data<BR>> (Shapefiles as well general crap in SDE) and all-in-all, it worked out<BR>> very well.<BR>> <BR>> <BR>> <BR>> <BR>> > It would be<BR>> > interesting to see how it compares. P-in-p can be optimized to work much<BR>> > faster than the GEOS code so it is likely that some purposed code would be<BR>> > much faster than the generalized code in postGIS although there has been<BR>> > some discussions on the dev list about changing that. It might even be in<BR>> > the newest code, I haven't had a chance to upgrade yet.<BR>> ><BR>> ><BR>> > > I often wonder what would it take to graft Geos inside SQlite. Too bad<BR>> > > I know nothing about C++.<BR>> > ><BR>> ><BR>> > There is a C-API to GEOS, so you do not need to know C++ and I imagine that<BR>> > with the work already done at<BR>> > http://www.gaia-gis.it/spatialite/ it should be pretty to<BR>> > write wrapper functions to expose more of GEOS within spatialite.<BR>> ><BR>> > I also think that there might be a Perl GEOS SWIG wrapper, but I haven't<BR>> > looked for it.<BR>> ><BR>> > The real limiting issue will be spatial indexes and this is probably the<BR>> > most difficult item to develop and integrate into the existing code. I have<BR>> > not clue what all it would take.<BR>> ><BR>> > -Steve<BR>> ><BR>> <BR>> <BR>> -- <BR>> Puneet Kishor<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 12<BR>> Date: Tue, 8 Apr 2008 02:37:21 +0000<BR>> From: mchapman@texelinc.com<BR>> Subject: Re: [postgis-users] SQLite and postGIS<BR>> To: "PostGIS Users Discussion"<BR>> <postgis-users@postgis.refractions.net>, punkish@eidesis.org<BR>> Message-ID:<BR>> <1902653510-1207622475-cardhu_decombobulator_blackberry.rim.net-2120766039-@bxe130.bisx.prod.on.blackberry><BR>> <BR>> Content-Type: text/plain<BR>> <BR>> You should also read what Frank says about it at http://www.gdal.org/ogr/drv_sqlite.html . <BR>> <BR>> I've thought about this as well and I think it would be really useful. <BR>> <BR>> 1. I have code for an rtree that could be used for a very very fast spatial index. It supports serializing itself too. <BR>> <BR>> 2. I would need help integrating into the sqllite query plan but my guess is that it would be fairly easy. We could look at the OGR code to help us get a feel for the sqlite c api and ask the sqlite developers for assistance.<BR>> <BR>> 3. Geos is a piece of cake to use and I can provide any c/c++ code we need to work with the geos api. I also have code the reads ands writes any ogc wkb or wkt for any ogc geometry type.<BR>> <BR>> 4. I would have concerns about the ability to lock the database as frank points out in the OGR docs but we could always wrap the database with a service and place a mutex around each database call. A wrapper service would also open the doors to accepting http requests, if sqlite doesn't have that support already.<BR>> <BR>> 5. I think extending one of the projects you mentioned earlier or using OGR would be the way to go.<BR>> <BR>> Please let me know if anyone is going to embark on this effort because I have been thinking about doing it myself.<BR>> <BR>> Best regards,<BR>> Martin<BR>> <BR>> Sent via BlackBerry by AT&T<BR>> <BR>> -----Original Message-----<BR>> From: Stephen Woodbridge <woodbri@swoodbridge.com><BR>> <BR>> Date: Mon, 07 Apr 2008 22:02:45 <BR>> To:punkish@eidesis.org, PostGIS Users Discussion <postgis-users@postgis.refractions.net><BR>> Subject: Re: [postgis-users] SQLite and postGIS<BR>> <BR>> <BR>> P Kishor wrote:<BR>> > On 4/7/08, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:<BR>> >> Hi Paul,<BR>> >><BR>> >> I have started using SQLite for some projects, mostly just as a backing<BR>> >> store for manipulating some data. I can't help but think it would be cool if<BR>> >> it would be possible to get something like postGIS running in it.<BR>> >><BR>> >> I know you guys did some analysis of various databases a while back with an<BR>> >> eye to their spatial potential and suitability for postGIS like inclusion -<BR>> >> well at least that was my impression.<BR>> >><BR>> >> Did you look at SQLite?<BR>> >> Have you worked with SQLite?<BR>> >> Got any thoughts on this? Anyone?<BR>> >><BR>> >> I wish I could say I had a client interested in funding, but <sigh> I<BR>> >> don't. But I have found myself googling for info on it 4 separate times in<BR>> >> the past week, which is strange because I have no immediate use.<BR>> >><BR>> >> The use case for something like this would be to build a standalone<BR>> >> application or web service that has a SQL/Spatial back-end without the need<BR>> >> for installing and administering a postgres database.<BR>> >><BR>> >> As best as I can tell, the major hurdle would be whether or not it is<BR>> >> possible for a reasonable amount of effort to integrate a spatial index<BR>> >> system into SQLite.<BR>> >><BR>> >> Anyway, thought I would ask? See what other people thought?<BR>> > <BR>> > Did you see a thread that I started on OSGeo Discuss a few months<BR>> > ago... it kinda devolved into (dare I say, degenerated into) a very<BR>> > long and unproductive back and forth, but my idea was a SQLiteGIS on<BR>> > the lines of PostGIS.<BR>> <BR>> Yes, I think I came across a few of your posting while searching google.<BR>> <BR>> > I actually wrote a pretty useful point-in-polygon routine using Perl<BR>> > DBD::SQLite unwrapping Shapefiles into a SQLite db and then using<BR>> > SQLite for boundary matching. It was for a very large p-in-p (7.5<BR>> > million points against 250k polys) that ArcGIS was choking over. Works<BR>> > very sweet in Perl/SQLite in about 20% to 30% of the time taken.<BR>> <BR>> Did you try this same example in postgis using indexes? It would be <BR>> interesting to see how it compares. P-in-p can be optimized to work much <BR>> faster than the GEOS code so it is likely that some purposed code would <BR>> be much faster than the generalized code in postGIS although there has <BR>> been some discussions on the dev list about changing that. It might even <BR>> be in the newest code, I haven't had a chance to upgrade yet.<BR>> <BR>> > I often wonder what would it take to graft Geos inside SQlite. Too bad<BR>> > I know nothing about C++.<BR>> <BR>> There is a C-API to GEOS, so you do not need to know C++ and I imagine <BR>> that with the work already done at http://www.gaia-gis.it/spatialite/ it <BR>> should be pretty to write wrapper functions to expose more of GEOS <BR>> within spatialite.<BR>> <BR>> I also think that there might be a Perl GEOS SWIG wrapper, but I haven't <BR>> looked for it.<BR>> <BR>> The real limiting issue will be spatial indexes and this is probably the <BR>> most difficult item to develop and integrate into the existing code. I <BR>> have not clue what all it would take.<BR>> <BR>> -Steve<BR>> _______________________________________________<BR>> postgis-users mailing list<BR>> postgis-users@postgis.refractions.net<BR>> http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> <BR>> ------------------------------<BR>> <BR>> Message: 13<BR>> Date: Tue, 08 Apr 2008 00:24:12 -0500<BR>> From: Stephen Woodbridge <woodbri@swoodbridge.com><BR>> Subject: Re: [postgis-users] SQLite and postGIS<BR>> To: mchapman@texelinc.com, PostGIS Users Discussion<BR>> <postgis-users@postgis.refractions.net><BR>> Cc: punkish@eidesis.org<BR>> Message-ID: <47FB017C.9030601@swoodbridge.com><BR>> Content-Type: text/plain; charset=UTF-8; format=flowed<BR>> <BR>> Hello Martin,<BR>> <BR>> mchapman@texelinc.com wrote:<BR>> > You should also read what Frank says about it at<BR>> > http://www.gdal.org/ogr/drv_sqlite.html .<BR>> <BR>> Databases basically do not work over NFS mounted filesystems because of <BR>> locking and caching issues. But this is not a SQLite issue, MYSQL, <BR>> Postgres, etc all would have the same issues. I think it is safe to <BR>> ignore that, ot maybe detect that the requested db file is on a non-safe <BR>> filesystem and throw an error.<BR>> <BR>> > I've thought about this as well and I think it would be really<BR>> > useful.<BR>> > <BR>> > 1. I have code for an rtree that could be used for a very very fast<BR>> > spatial index. It supports serializing itself too.<BR>> > <BR>> > 2. I would need help integrating into the sqllite query plan but my<BR>> > guess is that it would be fairly easy. We could look at the OGR code<BR>> > to help us get a feel for the sqlite c api and ask the sqlite<BR>> > developers for assistance.<BR>> > <BR>> > 3. Geos is a piece of cake to use and I can provide any c/c++ code we<BR>> > need to work with the geos api. I also have code the reads ands<BR>> > writes any ogc wkb or wkt for any ogc geometry type.<BR>> > <BR>> > 4. I would have concerns about the ability to lock the database as<BR>> > frank points out in the OGR docs but we could always wrap the<BR>> > database with a service and place a mutex around each database call.<BR>> > A wrapper service would also open the doors to accepting http<BR>> > requests, if sqlite doesn't have that support already.<BR>> > <BR>> > 5. I think extending one of the projects you mentioned earlier or<BR>> > using OGR would be the way to go.<BR>> > <BR>> > Please let me know if anyone is going to embark on this effort<BR>> > because I have been thinking about doing it myself.<BR>> <BR>> Have you checked out http://www.gaia-gis.it/spatialite/ this guys as <BR>> made a good start.<BR>> <BR>> I'm not sure I would be very good at integrating the indexing code into <BR>> the code. I'm still just learning to use the library, but I would be <BR>> happy to build application based on it and be your alpha test guinea <BR>> pig, so to speak.<BR>> <BR>> There seems to be a few vocal supporters here for such an effort if you <BR>> were interested in working on this.<BR>> <BR>> Best regards,<BR>> -Stephen Woodbridge<BR>> http://imaptools.com/<BR>> <BR>> > Best regards, Martin<BR>> > <BR>> > Sent via BlackBerry by AT&T<BR>> > <BR>> > -----Original Message----- From: Stephen Woodbridge<BR>> > <woodbri@swoodbridge.com><BR>> > <BR>> > Date: Mon, 07 Apr 2008 22:02:45 To:punkish@eidesis.org, PostGIS Users<BR>> > Discussion <postgis-users@postgis.refractions.net> Subject: Re:<BR>> > [postgis-users] SQLite and postGIS<BR>> > <BR>> > <BR>> > P Kishor wrote:<BR>> >> On 4/7/08, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:<BR>> >>> Hi Paul,<BR>> >>> <BR>> >>> I have started using SQLite for some projects, mostly just as a<BR>> >>> backing store for manipulating some data. I can't help but think<BR>> >>> it would be cool if it would be possible to get something like<BR>> >>> postGIS running in it.<BR>> >>> <BR>> >>> I know you guys did some analysis of various databases a while<BR>> >>> back with an eye to their spatial potential and suitability for<BR>> >>> postGIS like inclusion - well at least that was my impression.<BR>> >>> <BR>> >>> Did you look at SQLite? Have you worked with SQLite? Got any<BR>> >>> thoughts on this? Anyone?<BR>> >>> <BR>> >>> I wish I could say I had a client interested in funding, but<BR>> >>> <sigh> I don't. But I have found myself googling for info on it 4<BR>> >>> separate times in the past week, which is strange because I have<BR>> >>> no immediate use.<BR>> >>> <BR>> >>> The use case for something like this would be to build a<BR>> >>> standalone application or web service that has a SQL/Spatial<BR>> >>> back-end without the need for installing and administering a<BR>> >>> postgres database.<BR>> >>> <BR>> >>> As best as I can tell, the major hurdle would be whether or not<BR>> >>> it is possible for a reasonable amount of effort to integrate a<BR>> >>> spatial index system into SQLite.<BR>> >>> <BR>> >>> Anyway, thought I would ask? See what other people thought?<BR>> >> Did you see a thread that I started on OSGeo Discuss a few months <BR>> >> ago... it kinda devolved into (dare I say, degenerated into) a very<BR>> >> long and unproductive back and forth, but my idea was a SQLiteGIS<BR>> >> on the lines of PostGIS.<BR>> > <BR>> > Yes, I think I came across a few of your posting while searching<BR>> > google.<BR>> > <BR>> >> I actually wrote a pretty useful point-in-polygon routine using<BR>> >> Perl DBD::SQLite unwrapping Shapefiles into a SQLite db and then<BR>> >> using SQLite for boundary matching. It was for a very large p-in-p<BR>> >> (7.5 million points against 250k polys) that ArcGIS was choking<BR>> >> over. Works very sweet in Perl/SQLite in about 20% to 30% of the<BR>> >> time taken.<BR>> > <BR>> > Did you try this same example in postgis using indexes? It would be <BR>> > interesting to see how it compares. P-in-p can be optimized to work<BR>> > much faster than the GEOS code so it is likely that some purposed<BR>> > code would be much faster than the generalized code in postGIS<BR>> > although there has been some discussions on the dev list about<BR>> > changing that. It might even be in the newest code, I haven't had a<BR>> > chance to upgrade yet.<BR>> > <BR>> >> I often wonder what would it take to graft Geos inside SQlite. Too<BR>> >> bad I know nothing about C++.<BR>> > <BR>> > There is a C-API to GEOS, so you do not need to know C++ and I<BR>> > imagine that with the work already done at<BR>> > http://www.gaia-gis.it/spatialite/ it should be pretty to write<BR>> > wrapper functions to expose more of GEOS within spatialite.<BR>> > <BR>> > I also think that there might be a Perl GEOS SWIG wrapper, but I<BR>> > haven't looked for it.<BR>> > <BR>> > The real limiting issue will be spatial indexes and this is probably<BR>> > the most difficult item to develop and integrate into the existing<BR>> > code. I have not clue what all it would take.<BR>> > <BR>> > -Steve _______________________________________________ postgis-users<BR>> > mailing list postgis-users@postgis.refractions.net <BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> > <BR>> > <BR>> > ------------------------------------------------------------------------<BR>> > <BR>> > <BR>> > _______________________________________________ postgis-users mailing<BR>> > list postgis-users@postgis.refractions.net <BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> <BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 14<BR>> Date: Tue, 8 Apr 2008 11:21:49 -0400<BR>> From: "Pierre Racine" <Pierre.Racine@sbf.ulaval.ca><BR>> Subject: [postgis-users] Best graphical viewer for PostGIS data<BR>> To: <postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>> <D58FF82475EA0A4A9347D3CE16B46E5F32898E@exch-be03.ulaval.ca><BR>> Content-Type: text/plain; charset="US-ASCII"<BR>> <BR>> Hi,<BR>> <BR>> I would like to hear from you guys about the viewer you use to "see"<BR>> PostGIS geometries. Which one is the best and why? How do they support<BR>> views, editing, creation, etc...<BR>> <BR>> I can list a couple of them:<BR>> <BR>> QGIS<BR>> uDIG<BR>> GRASS<BR>> MapServer<BR>> Any others?<BR>> <BR>> Pierre<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 15<BR>> Date: Tue, 08 Apr 2008 08:26:15 -0700<BR>> From: Chris Hermansen <chris.hermansen@timberline.ca><BR>> Subject: Re: [postgis-users] Best graphical viewer for PostGIS data<BR>> To: PostGIS Users Discussion <postgis-users@postgis.refractions.net><BR>> Message-ID: <47FB8E97.1010406@timberline.ca><BR>> Content-Type: text/plain; charset=ISO-8859-1<BR>> <BR>> I seem to use OpenJump and QGIS most often. I like OpenJump's QA tools<BR>> because I seem to regularly receive data that was hiding in the corner<BR>> when the QA was done.<BR>> <BR>> Pierre Racine wrote:<BR>> > Hi,<BR>> ><BR>> > I would like to hear from you guys about the viewer you use to "see"<BR>> > PostGIS geometries. Which one is the best and why? How do they support<BR>> > views, editing, creation, etc...<BR>> ><BR>> > I can list a couple of them:<BR>> ><BR>> > QGIS<BR>> > uDIG<BR>> > GRASS<BR>> > MapServer<BR>> > Any others?<BR>> ><BR>> > Pierre<BR>> > _______________________________________________<BR>> > postgis-users mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> > <BR>> <BR>> <BR>> -- <BR>> Regards,<BR>> <BR>> Chris Hermansen · mailto:clh@timberline.ca<BR>> tel:+1.604.714.2878 · fax:+1.604.733.0631<BR>> Timberline Natural Resource Group · http://www.timberline.ca<BR>> 401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5<BR>> <BR>> C'est ma façon de parler.<BR>> <BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 16<BR>> Date: Tue, 8 Apr 2008 11:47:59 -0400<BR>> From: "Obe, Regina" <robe.dnd@cityofboston.gov><BR>> Subject: RE: [postgis-users] Best graphical viewer for PostGIS data<BR>> To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>> <53F9CF533E1AA14EA1F8C5C08ABC08D203A2BF7E@ZDND.DND.boston.cob><BR>> Content-Type: text/plain; charset="iso-8859-1"<BR>> <BR>> I think there is a gvSIG you can add to the list although I personally haven't used it so can't comment. <BR>> <BR>> -----Original Message-----<BR>> From: postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of Chris Hermansen<BR>> Sent: Tuesday, April 08, 2008 11:26 AM<BR>> To: PostGIS Users Discussion<BR>> Subject: Re: [postgis-users] Best graphical viewer for PostGIS data<BR>> <BR>> I seem to use OpenJump and QGIS most often. I like OpenJump's QA tools<BR>> because I seem to regularly receive data that was hiding in the corner<BR>> when the QA was done.<BR>> <BR>> Pierre Racine wrote:<BR>> > Hi,<BR>> ><BR>> > I would like to hear from you guys about the viewer you use to "see"<BR>> > PostGIS geometries. Which one is the best and why? How do they support<BR>> > views, editing, creation, etc...<BR>> ><BR>> > I can list a couple of them:<BR>> ><BR>> > QGIS<BR>> > uDIG<BR>> > GRASS<BR>> > MapServer<BR>> > Any others?<BR>> ><BR>> > Pierre<BR>> > _______________________________________________<BR>> > postgis-users mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> > <BR>> <BR>> <BR>> -- <BR>> Regards,<BR>> <BR>> Chris Hermansen · mailto:clh@timberline.ca<BR>> tel:+1.604.714.2878 · fax:+1.604.733.0631<BR>> Timberline Natural Resource Group · http://www.timberline.ca<BR>> 401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5<BR>> <BR>> C'est ma façon de parler.<BR>> <BR>> _______________________________________________<BR>> postgis-users mailing list<BR>> postgis-users@postgis.refractions.net<BR>> http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> -----------------------------------------<BR>> The substance of this message, including any attachments, may be<BR>> confidential, legally privileged and/or exempt from disclosure<BR>> pursuant to Massachusetts law. It is intended<BR>> solely for the addressee. If you received this in error, please<BR>> contact the sender and delete the material from any computer.<BR>> <BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 17<BR>> Date: Tue, 8 Apr 2008 11:50:01 -0400<BR>> From: "Randall, Eric" <ERandall@eriecountygov.org><BR>> Subject: RE: [postgis-users] Best graphical viewer for PostGIS data<BR>> To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>> <CD32AE6ACD828644B29601ADC966FDCB01B4A9BB@ex1.eriecountygov.local><BR>> Content-Type: text/plain; charset="iso-8859-1"<BR>> <BR>> I use OpenJump the most because of the dbquery plugin. Immediate viewing of any query that returns a geometry, derived or otherwise, is the most important feature for me. I use it as sort of a tester/designer for automating recurring tasks that have a spatial analytical component. All editing is done in other software, outside of postgres/postgis, and reloaded monthly.<BR>> <BR>> -----Original Message-----<BR>> From: postgis-users-bounces@postgis.refractions.net<BR>> [mailto:postgis-users-bounces@postgis.refractions.net]On Behalf Of<BR>> Pierre Racine<BR>> Sent: Tuesday, April 08, 2008 11:22 AM<BR>> To: postgis-users@postgis.refractions.net<BR>> Subject: [postgis-users] Best graphical viewer for PostGIS data<BR>> <BR>> <BR>> Hi,<BR>> <BR>> I would like to hear from you guys about the viewer you use to "see"<BR>> PostGIS geometries. Which one is the best and why? How do they support<BR>> views, editing, creation, etc...<BR>> <BR>> I can list a couple of them:<BR>> <BR>> QGIS<BR>> uDIG<BR>> GRASS<BR>> MapServer<BR>> Any others?<BR>> <BR>> Pierre<BR>> _______________________________________________<BR>> postgis-users mailing list<BR>> postgis-users@postgis.refractions.net<BR>> http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 18<BR>> Date: Tue, 8 Apr 2008 17:56:55 +0200<BR>> From: "Nicolas Ribot" <nicky666@gmail.com><BR>> Subject: Re: [postgis-users] Best graphical viewer for PostGIS data<BR>> To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>> <28de5e310804080856s33d96e25xe95e01a69a8daedf@mail.gmail.com><BR>> Content-Type: text/plain; charset=ISO-8859-1<BR>> <BR>> > I think there is a gvSIG you can add to the list although I personally haven't used it so can't comment.<BR>> ><BR>> <BR>> Pretty impressive software to display both shapefile and postgis layers.<BR>> Also supports rasters, other spatial DB and some other file formats.<BR>> Very fast to render features on screen.<BR>> <BR>> GUI is.... to close to ArcView 3.2 to my taste...<BR>> <BR>> I personnally use Jump/OpenJump, as the databaseQuery plugin allows to<BR>> directly see results of a PostGIS query and it is so simple to add new<BR>> features by pasting WKT representation into a newly created layer.<BR>> <BR>> Nicolas<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 19<BR>> Date: Tue, 8 Apr 2008 18:01:04 +0200<BR>> From: P.Rizzi Ag.Mobilit? Ambiente <paolo.rizzi@ama-mi.it><BR>> Subject: R: [postgis-users] Best graphical viewer for PostGIS data<BR>> To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>> <6B1D057DB7670E4CA686E2A33445D49F3CD302@SRVEXCHANGE2003.agenzia.dom><BR>> Content-Type: text/plain; charset="iso-8859-1"<BR>> <BR>> Yes, I too use OpenJUMP as a viewer because it's so easy and fast<BR>> to experiment with spatial queries and immediately see their result.<BR>> Never used for editing.<BR>> <BR>> Bye<BR>> Paolo<BR>> <BR>> > -----Messaggio originale-----<BR>> > Da: postgis-users-bounces@postgis.refractions.net<BR>> > [mailto:postgis-users-bounces@postgis.refractions.net]Per conto di<BR>> > Randall, Eric<BR>> > Inviato: martedì 8 aprile 2008 17.50<BR>> > A: PostGIS Users Discussion<BR>> > Oggetto: RE: [postgis-users] Best graphical viewer for PostGIS data<BR>> > <BR>> > <BR>> > I use OpenJump the most because of the dbquery plugin. <BR>> > Immediate viewing of any query that returns a geometry, <BR>> > derived or otherwise, is the most important feature for me. <BR>> > I use it as sort of a tester/designer for automating <BR>> > recurring tasks that have a spatial analytical component. <BR>> > All editing is done in other software, outside of <BR>> > postgres/postgis, and reloaded monthly.<BR>> > <BR>> > -----Original Message-----<BR>> > From: postgis-users-bounces@postgis.refractions.net<BR>> > [mailto:postgis-users-bounces@postgis.refractions.net]On Behalf Of<BR>> > Pierre Racine<BR>> > Sent: Tuesday, April 08, 2008 11:22 AM<BR>> > To: postgis-users@postgis.refractions.net<BR>> > Subject: [postgis-users] Best graphical viewer for PostGIS data<BR>> > <BR>> > <BR>> > Hi,<BR>> > <BR>> > I would like to hear from you guys about the viewer you use to "see"<BR>> > PostGIS geometries. Which one is the best and why? How do they support<BR>> > views, editing, creation, etc...<BR>> > <BR>> > I can list a couple of them:<BR>> > <BR>> > QGIS<BR>> > uDIG<BR>> > GRASS<BR>> > MapServer<BR>> > Any others?<BR>> > <BR>> > Pierre<BR>> > _______________________________________________<BR>> > postgis-users mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> > _______________________________________________<BR>> > postgis-users mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> > <BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 20<BR>> Date: Tue, 08 Apr 2008 10:33:51 -0700<BR>> From: Kevin Neufeld <kneufeld@refractions.net><BR>> Subject: Re: [postgis-users] Best graphical viewer for PostGIS data<BR>> To: PostGIS Users Discussion <postgis-users@postgis.refractions.net><BR>> Message-ID: <47FBAC7F.208@refractions.net><BR>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed<BR>> <BR>> I prefer OpenJump as well. Through plugins I wrote myself, I can view <BR>> or edit data directly in PostGIS pulled either from a single table or <BR>> any SQL query that returns a single geometry column. Since the database <BR>> I often work with is ~150GB I need to be able to load data into Jump <BR>> dynamically, that is, only load data whose bounding box intersects the <BR>> current viewport. (Though the plugin can also ignore the bounding box <BR>> filter and statically load the entire content of any SQL query or table <BR>> entirely in memory).<BR>> <BR>> I don't know the state of any publicly available plugins that permit <BR>> dynamic data editing, but OpenJump does come with a limited dynamic <BR>> viewer plugin that permits the viewing of a single table (optionally <BR>> with filters applied).<BR>> <BR>> Cheers,<BR>> Kevin<BR>> <BR>> Randall, Eric wrote:<BR>> > I use OpenJump the most because of the dbquery plugin. Immediate viewing of any query that returns a geometry, derived or otherwise, is the most important feature for me. I use it as sort of a tester/designer for automating recurring tasks that have a spatial analytical component. All editing is done in other software, outside of postgres/postgis, and reloaded monthly.<BR>> ><BR>> > -----Original Message-----<BR>> > From: postgis-users-bounces@postgis.refractions.net<BR>> > [mailto:postgis-users-bounces@postgis.refractions.net]On Behalf Of<BR>> > Pierre Racine<BR>> > Sent: Tuesday, April 08, 2008 11:22 AM<BR>> > To: postgis-users@postgis.refractions.net<BR>> > Subject: [postgis-users] Best graphical viewer for PostGIS data<BR>> ><BR>> ><BR>> > Hi,<BR>> ><BR>> > I would like to hear from you guys about the viewer you use to "see"<BR>> > PostGIS geometries. Which one is the best and why? How do they support<BR>> > views, editing, creation, etc...<BR>> ><BR>> > I can list a couple of them:<BR>> ><BR>> > QGIS<BR>> > uDIG<BR>> > GRASS<BR>> > MapServer<BR>> > Any others?<BR>> ><BR>> > Pierre<BR>> > _______________________________________________<BR>> > postgis-users mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> > _______________________________________________<BR>> > postgis-users mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> > <BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 21<BR>> Date: Tue, 08 Apr 2008 10:37:22 -0700<BR>> From: Martin Davis <mbdavis@refractions.net><BR>> Subject: Re: [postgis-users] SQLite and postGIS<BR>> To: punkish@eidesis.org, PostGIS Users Discussion<BR>> <postgis-users@postgis.refractions.net><BR>> Message-ID: <47FBAD52.9090407@refractions.net><BR>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed<BR>> <BR>> <BR>> <BR>> P Kishor wrote:<BR>> ><BR>> > I actually wrote a pretty useful point-in-polygon routine using Perl<BR>> > DBD::SQLite unwrapping Shapefiles into a SQLite db and then using<BR>> > SQLite for boundary matching. It was for a very large p-in-p (7.5<BR>> > million points against 250k polys) that ArcGIS was choking over. Works<BR>> > very sweet in Perl/SQLite in about 20% to 30% of the time taken.<BR>> ><BR>> > <BR>> ><BR>> I'm curious about your SQLite spatial solution. <BR>> <BR>> What approach did you use for storing geometry? How did you load the <BR>> shapefiles?<BR>> <BR>> Since SQLite has no spatial index, did you just iterate over all <BR>> geometries for you PIP test? What was your PIP test written in?<BR>> <BR>> What was the advantage of doing this over just using the raw shapefiles <BR>> - was it performance, or ease of data management?<BR>> <BR>> The SQLite Spatial direction seems like an interesting one to pursue for <BR>> just this kind of bulk processing use case.<BR>> ><BR>> ><BR>> > <BR>> <BR>> -- <BR>> Martin Davis<BR>> Senior Technical Architect<BR>> Refractions Research, Inc.<BR>> (250) 383-3022<BR>> <BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> Message: 22<BR>> Date: Wed, 9 Apr 2008 00:26:13 +0530<BR>> From: "P Kishor" <punkish@eidesis.org><BR>> Subject: Re: [postgis-users] SQLite and postGIS<BR>> To: "Martin Davis" <mbdavis@refractions.net><BR>> Cc: PostGIS Users Discussion <postgis-users@postgis.refractions.net><BR>> Message-ID:<BR>> <cdf6db500804081156o6f1d9990h4a5800f77c4d2304@mail.gmail.com><BR>> Content-Type: text/plain; charset=ISO-8859-1<BR>> <BR>> (the reply may look screwy because I am temporarily saddled with a<BR>> hobbled gmail interface on IE something or the other, and it seems to<BR>> have a mind of its own)<BR>> <BR>> I unpacked the shapefiles via a module on CPAN and stored the<BR>> coordinates as text strings (well, everything is a string for SQLite)<BR>> readymade for a p-in-p algorithm that I adapted from the Wolf book<BR>> (Algorithms with Perl or some such title -- Hietanemi et al). IIRC, I<BR>> stored all the x-coords as a string in one col, all the y-coords as a<BR>> string in another col, and that allowed me to reconstruct the arrays I<BR>> needed to do the p-in-p.<BR>> <BR>> Iterating over all the geoms was decidedly silly -- 250k * 7.5m<BR>> results in more than a trillion transactions, if my math is correct.<BR>> Instead, I stored the bounding box of each shape in separate cols, and<BR>> as a first pass, use SQL selects to narrow down the points per poly.<BR>> Then ran the p-in-p on each set.<BR>> <BR>> Re. advantages -- well, I first tried working with ArcGIS/SDE. An<BR>> existing solution was taking about 8 days from start to finish (a lot<BR>> of pre and post work on either side of the overlay), and that is if<BR>> the process didn't explode prematurely. My process took about 2.5 to 3<BR>> days. I do recall building the SQLite db with a bigger page size (I am<BR>> writing all this from memory. I am very far from my computer right<BR>> now).<BR>> <BR>> I have briefly looked at the Spatialite solution and that does look<BR>> like a very cool start. In fact, it gives me enough incentive to try<BR>> and learn C.<BR>> <BR>> I do have one question for you all -- why on earth does Spatialite<BR>> (and also PostGIS as well as ArcGIS) store the geometry as a BLOB?<BR>> What are the advantages? Is it space? Is it speed? Both? I can't<BR>> really understand the reason for all that AsWKT and WKB and AsPoints<BR>> and whatever back-and-forth. Why not just store coords as numbers, or<BR>> a string of coords as, well, a string of coords? Especially in the<BR>> case of PostGIS, PostgreSQL has a col type of arrays, so why not just<BR>> use that? SQLite stores everything as strings anyway, so why bother<BR>> with the back and forth unless there is speed advantage. I don't care<BR>> about the space -- hard disk is cheap.<BR>> <BR>> Many thanks for this conversation. This is very interesting for me. I<BR>> would love to see a truly lightweight but truly real geospatial db<BR>> solution realized, and I am a committed fan of SQLite.<BR>> <BR>> On 4/8/08, Martin Davis <mbdavis@refractions.net> wrote:<BR>> ><BR>> ><BR>> > P Kishor wrote:<BR>> > ><BR>> > > I actually wrote a pretty useful point-in-polygon routine using Perl<BR>> > > DBD::SQLite unwrapping Shapefiles into a SQLite db and then using<BR>> > > SQLite for boundary matching. It was for a very large p-in-p (7.5<BR>> > > million points against 250k polys) that ArcGIS was choking over. Works<BR>> > > very sweet in Perl/SQLite in about 20% to 30% of the time taken.<BR>> > ><BR>> > ><BR>> > ><BR>> > I'm curious about your SQLite spatial solution.<BR>> ><BR>> > What approach did you use for storing geometry? How did you load the<BR>> > shapefiles?<BR>> ><BR>> > Since SQLite has no spatial index, did you just iterate over all<BR>> > geometries for you PIP test? What was your PIP test written in?<BR>> ><BR>> > What was the advantage of doing this over just using the raw shapefiles<BR>> > - was it performance, or ease of data management?<BR>> ><BR>> > The SQLite Spatial direction seems like an interesting one to pursue for<BR>> > just this kind of bulk processing use case.<BR>> > ><BR>> > ><BR>> > ><BR>> ><BR>> > --<BR>> > Martin Davis<BR>> > Senior Technical Architect<BR>> > Refractions Research, Inc.<BR>> > (250) 383-3022<BR>> ><BR>> ><BR>> <BR>> <BR>> -- <BR>> Puneet Kishor http://punkish.eidesis.org/<BR>> Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/<BR>> Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/<BR>> <BR>> <BR>> ------------------------------<BR>> <BR>> _______________________________________________<BR>> postgis-users mailing list<BR>> postgis-users@postgis.refractions.net<BR>> http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> <BR>> <BR>> End of postgis-users Digest, Vol 66, Issue 8<BR>> ********************************************<BR><br /><hr />Tecnología, moda, motor, viajes,.suscríbete a nuestros boletines para estar siempre a la última <a href='http://newsletters.msn.com/hm/maintenanceeses.asp?L=ES&C=ES&P=WCMaintenance&Brand=WL&RU=http%3a%2f%2fmail.live.com' target='_new'>MSN Newsletters</a></body>
</html>