From: Peter S. <psa...@gm...> - 2012-12-11 12:18:48
|
Possibly more difficult to set up, but I'm adding more and more CGAL routines to terragear. I just commited a find points within bounding box which improved my lookup times by 20%. To find points within, what you really want is to create a CGAL arrangement, then you can query a point and it should be really quick. See http://www.cgal.org/Manual/3.3/doc_html/cgal_manual/Arrangement_2/Chapter_main.html Pete On Dec 11, 2012 6:02 AM, "Adrian Musceac" <kan...@gm...> wrote: > On Tuesday, December 11, 2012 11:03:41 HB-GRAL wrote: > > > > > Hi Adrian > > > > Maybe this link could contain some useful information for you, I don’t > > know ... > > http://trac.osgeo.org/postgis/wiki/WKTRasterTutorial01 > > > > As far as I understand you're working with sqlite. I don’t know if this > > is the best dbms for what you’re doing (problems with indexing, filelock > > etc.). Here is a postgres alternative which extends sqlite core for GIS: > > https://www.gaia-gis.it/fossil/libspatialite/index > > > > -Yves > > > > Hi Yves, > I have to work with sqlite as it is an embeddable database (like you can > take > the file and use it anywhere). For my purposes it's the only solution. > But the bottleneck is not in sqlite anymore. > Meanwhile I've identified a bug which made my code incredibly slow. > Right now I'm looking at 10 full days to fill a 10x10 degree elevation > database with material info. I will try to optimize even further, I > believe I > can. I'm using output from ogr-decode, srtmchop and terrafit. I will try to > keep the wiki article updated too. > > I tried using GEOS directly but it segfaults quite often with latest > version, > so I abandoned it. Right now I'm using GDAL/OGR with GEOS bindings. > > With this, terrain sampling 100-1000 km away will be possible, as long as > one > keeps the number of sampled points reasonable. Size of the database > remains a > problem, as well as time to get it. > > Cheers, > Adrian > > > > ------------------------------------------------------------------------------ > LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial > Remotely access PCs and mobile devices and provide instant support > Improve your efficiency, and focus on delivering more value-add services > Discover what IT Professionals Know. Rescue delivers > http://p.sf.net/sfu/logmein_12329d2d > _______________________________________________ > Flightgear-scenery mailing list > Fli...@li... > https://lists.sourceforge.net/lists/listinfo/flightgear-scenery > |