<div dir="ltr">I've played a bit with X3DOM-- it's great for meshes, etc., but I haven't seen a good way to color point clouds in it (although, perhaps I'm missing something). Still powerful though, and can leverage ST_AsX3D function.<br>
<br>Best,<br>Steve<br><br><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Dec 18, 2013 at 3:30 AM, Frank Henze <span dir="ltr"><<a href="mailto:henze@tu-cottbus.de" target="_blank">henze@tu-cottbus.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
thanks for this very interesting approach!<br>
<br>
We need LOD not only for point clouds, but also for large 3D models (e.g. 3D city models / CityGML). Is there a solution for PostGIS?<br>
<br>
Interesting approaches for visualization of large 3D can also find on X3DOM (see homepage and search on Youtube).<br>
<br>
Frank<br>
<br>
Am 18.12.2013 09:01, schrieb Rémi Cura:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
Hey,<br>
I contacted the developper of XB PointStream specifically to ask him how<br>
to plug it to a postgres DB.<br>
It is no more an active project and he advised against it.<br>
<br>
At the other hand, with a much better licence (FreeBSD), active dev, and<br>
build in level Of Detail (LOD) feature (scene graph):<br>
<a href="http://potree.org/" target="_blank">http://potree.org/</a><br>
<br>
I asked the same question and it would be possible to plug it to db.<br>
We only need to develop a LOD inside DB to to make it possible to use it<br>
with huge database (I'm talking about 10's of billions at least in base,<br>
and several millions in cache/browser). ( Here my gothub project doc,<br>
the project is not clean enough to be used by others, but the slides<br>
contains some images<br>
:<a href="https://github.com/Remi-C/LOD_ordering_for_patches_of_points/tree/master/doc" target="_blank">https://github.com/Remi-C/<u></u>LOD_ordering_for_patches_of_<u></u>points/tree/master/doc</a> )<br>
<br>
Current WebGL limit with most graphic card seems to be around 10^6<br>
points, it is very small, hence the obligation to have LOD support to<br>
have maybe 10 * 10^6 points in cache in LOD structure in browser, and<br>
display only 10^6 points, but cleverly :<br>
more points close to viewer camera and in front of it, few points when<br>
far from viewer camera, zero point behind camera.<br>
These are very old and effective computer graphics tricks.<br>
<br>
Cheers,<br>
Rémi-C<br>
<br>
<br>
<br>
<br>
<br>
2013/12/17 Basques, Bob (CI-StPaul) <<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.mn.us</a><br></div>
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>>><div class="im"><br>
<br>
Hi Frank,<br>
<br>
I've been watching this approach develop over the past few year.<br>
Some intereing approaches to using the point based methods of<br>
display that I've zeroed in on use feature that they describe as<br>
Surfels and/or Splats. Just Google those two key words and you'll<br>
see what I'm talking about.<br>
<br>
<a href="http://graphics.ucsd.edu/~matthias/Papers/Surfels.pdf" target="_blank">http://graphics.ucsd.edu/~<u></u>matthias/Papers/Surfels.pdf</a><br>
<br>
One drawback to these approaches is that they are sort of a closed<br>
system in that they concentrate on only displaying the point based<br>
features. In the end, as a real world tool, I'll need to<br>
incorporate into this type of visualizers, I means of mixing feature<br>
types. Surface tins, CAD models, and Points. Having the points<br>
reside in a DB will both help with the integration as well as allow<br>
some processing of things to be accomplished on the fly in this<br>
mixed feature viewer.<br>
<br>
Bobb<br>
<br>
<br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br></div><div class="im">
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>] On Behalf Of Frank Henze<br></div><div><div class="h5">
Sent: Sunday, December 15, 2013 2:10 PM<br>
To: PostGIS Users Discussion<br>
Subject: Re: [postgis-users] Old question resurfacing<br>
<br>
I dont know, at which point the downsampling should take place.<br>
An interesting solution for webbased visualization could be XB Point<br>
Stream:<br>
<a href="http://zenit.senecac.on.ca/wiki/index.php/XB_PointStream" target="_blank">http://zenit.senecac.on.ca/<u></u>wiki/index.php/XB_PointStream</a><br>
<br>
Frank<br>
<br>
Am 15.12.2013 00:45, schrieb Rémi Cura:<br>
> I guess everybody has reached the same conclusion :<br>
> using pointcloud is is possible to manage 100's of billions of points<br>
> and retrieve quickly those of interest.<br>
><br>
> Now most of the usage requiere severe downsampling, which isn't a<br>
part<br>
> of anything yet but may come (I'm working on adding this to<br>
pointcloud).<br>
> .<br>
><br>
> Cheers,<br>
><br>
> Rémi-C<br>
><br>
><br>
> 2013/12/12 Basques, Bob (CI-StPaul) <<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.mn.us</a><br>
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>><br></div></div>
> <mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a><div><div class="h5"><br>
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>>>><br>
><br>
> Frank,<br>
><br>
> I don't know about a group, or for that matter centering it<br>
on just<br>
> PostGIS, but I see 3D as the next big Mapping product line that<br>
> people are going to be looking for. PostGIS is a piece in a<br>
bigger<br>
> puzzle. I've been researching different methods for storing and<br>
> segmenting the point cloud data on the server side for a<br>
while now<br>
> and PostGIS has percolated up to near the top of the list.<br>
><br>
> There is a big piece related in how to generalize data for 3D<br>
> scaling in the browser, that's the biggest shortcoming I've<br>
become<br>
> aware of in order to make something run nicely in the<br>
browser, I've<br>
> also of late been forcing myself to think mobile, which has<br>
it's own<br>
> set of criteria as far as the browser goes.<br>
><br>
> I would likely join the list of something call PostGIS 3d, but I<br>
> don't know that there is enough interest for a whole community<br>
> (yet), maybe it's better to stay ahead of the curve though.<br>
><br>
><br>
> Bobb<br>
><br>
><br>
><br>
> -----Original Message-----<br>
> From: <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>><br></div></div><div class="im">
> [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br></div><div><div class="h5">
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>>] On Behalf Of Frank<br>
Henze<br>
> Sent: Thursday, December 12, 2013 1:17 PM<br>
> To: PostGIS Users Discussion<br>
> Subject: Re: [postgis-users] Old question resurfacing<br>
><br>
> Hi all,<br>
><br>
> briefly a few details to<br>
<a href="http://www2.htw-dresden.de/~s68071/3DWebGIS/" target="_blank">http://www2.htw-dresden.de/~<u></u>s68071/3DWebGIS/</a>:<br>
><br>
> - Projektauswahl: Baalbek and Palatin are static X3D<br>
models (no<br>
> PostGIS)<br>
> - Projektauswahl: W3DS is dynamically generated from a<br>
PostGIS 2.0 DB<br>
> via a "GetScene"-request by Geoserver<br>
><br>
> I think Baalbek is too large (too many triangles) and therefore<br>
> possibly leads to crash. Palatin and W3DS should work.<br>
><br>
> The 3D window is a standard WebGL window based on X3DOM. So it<br>
> should run right stable.<br>
><br>
> Once again my question:<br>
> Is there an interest in a PostGIS 3D group?<br>
><br>
> Frank<br>
><br>
> Am 12.12.2013 16:55, schrieb Basques, Bob (CI-StPaul):<br>
> > Frank,<br>
> ><br>
> > Very nice. It froze up for me pretty quickly, I tried both FF<br>
> and Chrome. Still looked good while it ran.<br>
> ><br>
> > This stability aspect is a big piece of being able to make<br>
> something that folks will want to use. Data segregation will<br>
be a<br>
> big piece moving forward I think.<br>
> ><br>
> > Bobb<br>
> ><br>
> ><br>
> ><br>
> > -----Original Message-----<br>
> > From: <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>><br></div></div><div class="im">
> > [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br></div><div><div class="h5">
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>>] On Behalf Of Frank<br>
> > Henze<br>
> > Sent: Thursday, December 12, 2013 6:04 AM<br>
> > To: PostGIS Users Discussion<br>
> > Subject: Re: [postgis-users] Old question resurfacing<br>
> ><br>
> > Hi Bobb,<br>
> > hi all,<br>
> ><br>
> > <a href="https://hub.sharedgeo.org/apps/x3d/" target="_blank">https://hub.sharedgeo.org/<u></u>apps/x3d/</a> looks great!<br>
> ><br>
> > We have similar requirements for a 3d WebGIS.<br>
> > A first prototype you can find at:<br>
> ><br>
> > <a href="http://www2.htw-dresden.de/~s68071/3DWebGIS/" target="_blank">http://www2.htw-dresden.de/~<u></u>s68071/3DWebGIS/</a><br>
> ><br>
> > For "Projektauswahl:" select "W3DS"<br>
> ><br>
> > and then select "Historische Gebäude" (Historical Buildings)<br>
> ><br>
> > If there is nothing to see, then press on the left side "Alles<br>
> anzeigen"<br>
> ><br>
> > We use the community buildt Geoserver incl. Web 3D service +<br>
> X3DOM + JS.<br>
> ><br>
> > Some of our problems:<br>
> ><br>
> > How to import 3D geometries into PostGIS?<br>
> > Which formats and interfaces (CAD, X3D)?<br>
> > Point clouds in PostGIS (also import of).<br>
> ><br>
> > Is there a 3D PostGIS interest-group?<br>
> > If not, should one established?<br>
> ><br>
> > Frank<br>
> ><br>
> > Am 11.12.2013 17:44, schrieb Basques, Bob (CI-StPaul):<br>
> >> All,<br>
> >><br>
> >> Nothing that far along. Did a couple of proofs of<br>
concept so far,<br>
> >> I've done a couple of presentations on the Visualizer<br>
approach. We<br>
> >> tried a couple of different things, x3Dom, allover'js<br>
> >><br>
> >> You can see some of them here ( some of the pages take a<br>
while to<br>
> >> load the data in the background, be patient):<br>
> >><br>
> >> <a href="https://hub.sharedgeo.org/apps/x3d/" target="_blank">https://hub.sharedgeo.org/<u></u>apps/x3d/</a> (these will<br>
generally need a<br>
> >> webGL enabled browser)<br>
> >><br>
> >> These are purely intended as a test of just how much data<br>
could<br>
> >> easily be squished into the browser before if blows, so you<br>
> might experience<br>
> >> some failures. Ideally the data coming into these would be<br>
> segmented<br>
> >> via a SQL call to PostGIS Pointcloud sources.<br>
> >><br>
> >> The last two in the list are using some point clouds cut<br>
from our<br>
> >> recent data collect at 8pt per sq meter for the City (6<br>
billion<br>
> >> points in all), these are using about 300k points each<br>
for example.<br>
> >><br>
> >> Bobb<br>
> >><br>
> >> *From:*<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>><br></div></div><div class="im">
> >> [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br></div><div><div class="h5">
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>>] *On Behalf Of *Rémi<br>
> >> Cura<br>
> >> *Sent:* Wednesday, December 11, 2013 10:08 AM<br>
> >> *To:* PostGIS Users Discussion<br>
> >> *Subject:* Re: [postgis-users] Old question resurfacing<br>
> >><br>
> >> I would be very interested to know any attempt to<br>
visualize 3D point<br>
> >> cloud from data base !<br>
> >><br>
> >> We did the same but our solution is far from perfect.<br>
> >><br>
> >> Bob, is you rporject public/open source, have you any<br>
paper/doc<br>
> about it ?<br>
> >><br>
> >> Cheers,<br>
> >><br>
> >> Rémi-C<br>
> >><br>
> >> 2013/12/11 Basques, Bob (CI-StPaul)<br>
<<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.mn.us</a> <mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>><br>
> <mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a><br>
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>>><br>
> >> <mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a><br>
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>><br>
> <mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a><br>
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>>>>><br>
> >><br>
> >> Hmm,<br>
> >><br>
> >> I'm working with the Minneapolis International Airport<br>
(MSP) on a<br>
> >> project, any chance that data is open/accessible enough<br>
to play<br>
> with?<br>
> >> This could tie directly into a project I'm already<br>
working on.<br>
> >><br>
> >> Thanks<br>
> >><br>
> >> Bobb<br>
> >><br>
> >> *From:*<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>><br>
> >> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>>><br></div></div>
> >> [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><div><div class="h5"><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>><br>
> >> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>>>] *On Behalf Of *Gerry<br>
> >> Creager - NOAA Affiliate<br>
> >> *Sent:* Tuesday, December 10, 2013 2:14 PM<br>
> >><br>
> >><br>
> >> *To:* PostGIS Users Discussion<br>
> >> *Subject:* Re: [postgis-users] Old question resurfacing<br>
> >><br>
> >> Bob, all:<br>
> >><br>
> >> I agree. I'll have to spend some time with pointcloud but<br>
it DOES<br>
> >> look very promising.<br>
> >><br>
> >> Another application? Lidar. Pointed at the sky, not at the<br>
> ground (we<br>
> >> use 'em to determine cloud layers [ceiling] and sky cover at<br>
> airports<br>
> >> for aviation data...).<br>
> >><br>
> >> Thanks, all!<br>
> >><br>
> >> gerry<br>
> >><br>
> >> On Tue, Dec 10, 2013 at 1:49 PM, Basques, Bob (CI-StPaul)<br>
> >> <<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.mn.us</a><br>
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>><br>
> <mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a><br>
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>>><br></div></div><div class="im">
> <mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a><br>
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>><br>
> <mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a><br></div><div><div class="h5">
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>>>>> wrote:<br>
> >><br>
> >> Gerry,<br>
> >><br>
> >> Remi's idea about using a point cloud may be spot on for<br>
your use.<br>
> >> It allows you to set a point cloud down to a revolution<br>
if need be,<br>
> >> which seems like what you are looking for.. If the data<br>
becomes too<br>
> >> massive for insertion into DB at real-time speeds, then<br>
you could<br>
> >> also separate this revolution into separate DB's as well,<br>
you could<br>
> >> separate a whole number of ways, by elevation, or<br>
quadrant, or . . .<br>
> >><br>
> >> I'm very interested in visualization possibilities with<br>
something<br>
> >> like this being available in a database. We're doing some<br>
> similar db<br>
> >> 3d visualization stuff on some rather dense point clouds.<br>
Your data<br>
> >> once available could use the same visualizer.<br>
> >><br>
> >> Bobb<br>
> >><br>
> >> *From:*<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>><br>
> >> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>>><br></div></div>
> >> [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><div class="im"><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>><br>
> >> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br></div><div><div class="h5">
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>>>] *On Behalf Of *Gerry<br>
> >> Creager - NOAA Affiliate<br>
> >> *Sent:* Tuesday, December 10, 2013 1:41 PM<br>
> >> *To:* PostGIS Users Discussion<br>
> >> *Subject:* Re: [postgis-users] Old question resurfacing<br>
> >><br>
> >> Bob<br>
> >><br>
> >> At least preliminarily, I can post-process, so speed of<br>
db adds<br>
> isn't<br>
> >> too troubling. Maintaining accurate representation of the<br>
bin-volume<br>
> >> data is, however, important.<br>
> >><br>
> >> Typical rotation is 1-3 RPM, and a complete volume scan takes<br>
> ~11 min<br>
> >> in clear air (where you best see biologicals if so<br>
inclined) or ~5<br>
> >> min in one of the storm data collection modes. These are<br>
for common<br>
> >> WSR88D, stationary radars. SMARTR's and others we have<br>
here that are<br>
> >> mobile present a whole host of other options/data eval<br>
and speed<br>
> problems.<br>
> >><br>
> >> Current radar data are nominally considered to have a<br>
horizontal<br>
> >> resolution of ~250 m, ignoring distortion or keyholing due to<br>
> >> range.Typically 16 elevations are scanned, once or or<br>
twice in storm<br>
> >> mode and a few less elevations in clear air mode.<br>
> >><br>
> >> Now, the interesting thing that's on the horizon is<br>
Phased Array<br>
> Radar.<br>
> >> When that happens, more data, more resolution, and faster<br>
updates.<br>
> >><br>
> >> gerry<br>
> >><br>
> >> On Tue, Dec 10, 2013 at 11:05 AM, Basques, Bob (CI-StPaul)<br>
> >> <<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.mn.us</a><br>
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>><br>
> <mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a><br>
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>>><br></div></div><div class="im">
> <mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a><br>
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>><br>
> <mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a><br></div><div class="im">
<mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.<u></u>mn.us</a>>>>> wrote:<br>
> >><br>
> >> Gerry,<br>
> >><br>
> >> Seems like the biggest hangup would be in adding the data<br>
to the DB<br>
> >> fast enough. How many points, per revolution, and what<br>
is the<br>
> >> frequency of a revolution (stationary Radar, correct,<br>
although as I<br>
> >> think about it, it could be mobile if needed, just need<br>
to add<br>
> in the<br>
> >> radar location to each record)?<br>
> >><br>
> >> Bobb<br>
> >><br>
> >> *From:*<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>><br>
> >> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>>><br></div>
> >> [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><div class="im"><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>><br>
> >> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a><br></div><div><div class="h5">
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<u></u>lists.osgeo.org</a>>>>] *On Behalf Of *Gerry<br>
> >> Creager - NOAA Affiliate<br>
> >> *Sent:* Tuesday, December 10, 2013 10:52 AM<br>
> >> *To:* PostGIS Users Discussion<br>
> >> *Subject:* [postgis-users] Old question resurfacing<br>
> >><br>
> >> I asked this years ago, and I think Paul was less than<br>
pleased with<br>
> >> me (:-), but:<br>
> >><br>
> >> Has anyone, in the ensuing years looked at encoding radar<br>
data<br>
> into a<br>
> >> postGIS database? We've a little idea that might benefit one<br>
> project,<br>
> >> and getting the radar data into a good geospatial format<br>
would be<br>
> >> beneficial.The data, of coure, would start out as<br>
> radial-distance and<br>
> >> intensity from the radar site, although we could<br>
preprocess it<br>
> by gridding.<br>
> >><br>
> >> Thanks, Gerry<br>
> >><br>
> >> --<br>
> >><br>
> >> Gerry Creager<br>
> >><br>
> >> NSSL/CIMMS<br>
> >><br>
> >> <a href="tel:405.325.6371" value="+14053256371" target="_blank">405.325.6371</a> <tel:<a href="tel:405.325.6371" value="+14053256371" target="_blank">405.325.6371</a>><br>
> >><br>
> >> ++++++++++++++++++++++<br>
> >><br>
> >> "Big whorls have little whorls,<br>
> >><br>
> >> That feed on their velocity;<br>
> >><br>
> >> And little whorls have lesser whorls,<br>
> >><br>
> >> And so on to viscosity."<br>
> >><br>
> >> Lewis Fry Richardson (1881-1953)<br>
> >><br>
> >><br>
> >> ______________________________<u></u>_________________<br>
> >> postgis-users mailing list<br>
> >> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>>><br>
> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>>>><br>
> >> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
> >><br>
> >><br>
> >><br>
> >> --<br>
> >><br>
> >> Gerry Creager<br>
> >><br>
> >> NSSL/CIMMS<br>
> >><br>
> >> <a href="tel:405.325.6371" value="+14053256371" target="_blank">405.325.6371</a> <tel:<a href="tel:405.325.6371" value="+14053256371" target="_blank">405.325.6371</a>><br>
> >><br>
> >> ++++++++++++++++++++++<br>
> >><br>
> >> "Big whorls have little whorls,<br>
> >><br>
> >> That feed on their velocity;<br>
> >><br>
> >> And little whorls have lesser whorls,<br>
> >><br>
> >> And so on to viscosity."<br>
> >><br>
> >> Lewis Fry Richardson (1881-1953)<br>
> >><br>
> >><br>
> >> ______________________________<u></u>_________________<br>
> >> postgis-users mailing list<br>
> >> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>>><br>
> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>>>><br>
> >> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
> >><br>
> >><br>
> >><br>
> >> --<br>
> >><br>
> >> Gerry Creager<br>
> >><br>
> >> NSSL/CIMMS<br>
> >><br>
> >> <a href="tel:405.325.6371" value="+14053256371" target="_blank">405.325.6371</a><br>
> >><br>
> >> ++++++++++++++++++++++<br>
> >><br>
> >> "Big whorls have little whorls,<br>
> >><br>
> >> That feed on their velocity;<br>
> >><br>
> >> And little whorls have lesser whorls,<br>
> >><br>
> >> And so on to viscosity."<br>
> >><br>
> >> Lewis Fry Richardson (1881-1953)<br>
> >><br>
> >><br>
> >> ______________________________<u></u>_________________<br>
> >> postgis-users mailing list<br>
> >> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>>><br>
> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>>>><br>
> >> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
> >><br>
> >><br>
> >><br>
> >> ______________________________<u></u>_________________<br>
> >> postgis-users mailing list<br>
> >> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>>><br>
> >> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
> >><br>
> > ______________________________<u></u>_________________<br>
> > postgis-users mailing list<br>
> > <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>>><br>
> > <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
> ><br>
> ><br>
> > ______________________________<u></u>_________________<br>
> > postgis-users mailing list<br>
> > <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>>><br>
> > <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
> ><br>
> ______________________________<u></u>_________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>>><br>
> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
><br>
><br>
> ______________________________<u></u>_________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>>><br>
> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
><br>
><br>
><br>
><br>
> ______________________________<u></u>_________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
><br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
<br>
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
<br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
</div></div><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
<br>
</blockquote><div class="HOEnZb"><div class="h5">
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
</div></div></blockquote></div><br></div>