<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Comic Sans MS";
color:windowtext;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS"">All,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS"">I have a development team wanting to work on this, just need a funded project to work from, otherwise it’s going to happen much more slowly as time permits.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS"">So if you know of any projects in the works, etc. . . .<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS"">Bobb<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Comic Sans MS""><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> postgis-users-bounces@lists.osgeo.org [mailto:postgis-users-bounces@lists.osgeo.org]
<b>On Behalf Of </b>Rémi Cura<br>
<b>Sent:</b> Thursday, December 12, 2013 8:02 AM<br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> Re: [postgis-users] Old question resurfacing<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin-left:.5in">Wow very cool projects =)<o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:.5in">Would be so cool to have a webgl client displaying postgis tables !<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in">Cheers,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:.5in">Rémi-C<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in">
<o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin-left:.5in">2013/12/12 Frank Henze <<a href="mailto:henze@tu-cottbus.de" target="_blank">henze@tu-cottbus.de</a>><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:.5in">Hi Bobb,<br>
hi all,<br>
<br>
<a href="https://hub.sharedgeo.org/apps/x3d/" target="_blank">https://hub.sharedgeo.org/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/~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 anzeigen"<br>
<br>
We use the community buildt Geoserver incl. Web 3D service + 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):<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in">
All,<br>
<br>
Nothing that far along. Did a couple of proofs of concept so far, I’ve<br>
done a couple of presentations on the Visualizer approach. We tried a<br>
couple of different things, x3Dom, allover’js<br>
<br>
You can see some of them here ( some of the pages take a while to load<br>
the data in the background, be patient):<br>
<br>
<a href="https://hub.sharedgeo.org/apps/x3d/" target="_blank">https://hub.sharedgeo.org/apps/x3d/</a> (these will generally need a webGL<br>
enabled browser)<br>
<br>
These are purely intended as a test of just how much data could easily<br>
be squished into the browser before if blows, so you might experience<br>
some failures. Ideally the data coming into these would be segmented<br>
via a SQL call to PostGIS Pointcloud sources.<br>
<br>
The last two in the list are using some point clouds cut from our recent<br>
data collect at 8pt per sq meter for the City (6 billion points in all),<br>
these are using about 300k points each for example.<br>
<br>
Bobb<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:.5in">*From:*<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a><br>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] *On Behalf Of *Rémi Cura<br>
*Sent:* Wednesday, December 11, 2013 10:08 AM<br>
*To:* PostGIS Users Discussion<br>
*Subject:* Re: [postgis-users] Old question resurfacing<o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:.5in"><br>
<br>
I would be very interested to know any attempt to 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 paper/doc about it ?<br>
<br>
Cheers,<br>
<br>
Rémi-C<br>
<br>
2013/12/11 Basques, Bob (CI-StPaul) <<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.mn.us</a><o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:.5in"><mailto:<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.mn.us</a>>><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in">
<br>
<br>
Hmm,<br>
<br>
I’m working with the Minneapolis International Airport (MSP) on a<br>
project, any chance that data is open/accessible enough to play with?<br>
This could tie directly into a project I’m already working on.<br>
<br>
Thanks<br>
<br>
Bobb<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:.5in">*From:*<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>><br>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@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<o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:.5in"><br>
<br>
Bob, all:<br>
<br>
I agree. I'll have to spend some time with pointcloud but it DOES look<br>
very promising.<br>
<br>
Another application? Lidar. Pointed at the sky, not at the ground (we<br>
use 'em to determine cloud layers [ceiling] and sky cover at 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)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in">
<<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.mn.us</a>>> wrote:<br>
<br>
Gerry,<br>
<br>
Remi’s idea about using a point cloud may be spot on for your use. It<br>
allows you to set a point cloud down to a revolution if need be, which<br>
seems like what you are looking for.. If the data becomes too massive<br>
for insertion into DB at real-time speeds, then you could also separate<br>
this revolution into separate DB’s as well, you could separate a whole<br>
number of ways, by elevation, or quadrant, or . . .<br>
<br>
I’m very interested in visualization possibilities with something like<br>
this being available in a database. We’re doing some similar db 3d<br>
visualization stuff on some rather dense point clouds. Your data once<br>
available could use the same visualizer.<br>
<br>
Bobb<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:.5in">*From:*<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>><br>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@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<o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:.5in"><br>
<br>
Bob<br>
<br>
At least preliminarily, I can post-process, so speed of db adds isn't<br>
too troubling. Maintaining accurate representation of the bin-volume<br>
data is, however, important.<br>
<br>
Typical rotation is 1-3 RPM, and a complete volume scan takes ~11 min in<br>
clear air (where you best see biologicals if so inclined) or ~5 min in<br>
one of the storm data collection modes. These are for common WSR88D,<br>
stationary radars. SMARTR's and others we have here that are mobile<br>
present a whole host of other options/data eval and speed problems.<br>
<br>
Current radar data are nominally considered to have a horizontal<br>
resolution of ~250 m, ignoring distortion or keyholing due to<br>
range.Typically 16 elevations are scanned, once or or 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 Phased Array Radar.<br>
When that happens, more data, more resolution, and faster updates.<br>
<br>
gerry<br>
<br>
On Tue, Dec 10, 2013 at 11:05 AM, Basques, Bob (CI-StPaul)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in">
<<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.mn.us</a>>> wrote:<br>
<br>
Gerry,<br>
<br>
Seems like the biggest hangup would be in adding the data to the DB fast<br>
enough. How many points, per revolution, and what is the frequency of a<br>
revolution (stationary Radar, correct, although as I think about it, it<br>
could be mobile if needed, just need to add in the radar location to<br>
each record)?<br>
<br>
Bobb<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:.5in">*From:*<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>><br>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a><br>
<mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@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<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in">
<br>
<br>
I asked this years ago, and I think Paul was less than pleased with me<br>
(:-), but:<br>
<br>
Has anyone, in the ensuing years looked at encoding radar data into a<br>
postGIS database? We've a little idea that might benefit one project,<br>
and getting the radar data into a good geospatial format would be<br>
beneficial.The data, of coure, would start out as radial-distance and<br>
intensity from the radar site, although we could preprocess it by gridding.<br>
<br>
Thanks, Gerry<br>
<br>
--<br>
<br>
Gerry Creager<br>
<br>
NSSL/CIMMS<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:.5in">405.325.6371 <<a href="tel:405.325.6371">tel:405.325.6371</a>><o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:.5in"><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>
_______________________________________________<br>
postgis-users mailing list<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:.5in"><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.osgeo.org</a>><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in">
<br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br>
<br>
<br>
--<br>
<br>
Gerry Creager<br>
<br>
NSSL/CIMMS<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:.5in">405.325.6371 <<a href="tel:405.325.6371">tel:405.325.6371</a>><o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:.5in"><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>
_______________________________________________<br>
postgis-users mailing list<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:.5in"><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.osgeo.org</a>><o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:.5in"><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br>
<br>
<br>
--<br>
<br>
Gerry Creager<br>
<br>
NSSL/CIMMS<br>
<br>
405.325.6371<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>
_______________________________________________<br>
postgis-users mailing list<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-left:.5in"><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.osgeo.org</a>><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.5in">
<br>
<br>
<br>
<br>
_______________________________________________<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-bin/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-left:.5in">_______________________________________________<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-bin/mailman/listinfo/postgis-users</a><o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-left:.5in"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>