<div dir="ltr">Wow very cool projects =)<div>Would be so cool to have a webgl client displaying postgis tables !</div><div><br></div><div>Cheers,</div><div><br></div><div>Rémi-C<br><div class="gmail_extra"><br><br><div class="gmail_quote">
2013/12/12 Frank Henze <span dir="ltr"><<a href="mailto:henze@tu-cottbus.de" target="_blank">henze@tu-cottbus.de</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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 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):<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
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/<u></u>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<br>
<br></div>
*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>] *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<div class="im"><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><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>
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<br>
<br></div>
*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>>] *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<div class="im"><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)<br></div><div class="im">
<<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>>> 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<br>
<br></div>
*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>>] *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<div class="im"><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)<br></div><div class="im">
<<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>>> 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<br>
<br></div>
*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>>] *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<div class="im"><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<br>
<br></div>
405.325.6371 <tel:405.325.6371><div class="im"><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>
</div><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>><div class="im">
<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></div>
405.325.6371 <tel:405.325.6371><div class="im"><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>
</div><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>><div class="im">
<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>
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>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
</div><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><div class="im"><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>
<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>
</div></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></div></div>