[postgis-users] Old question resurfacing

[Rémi Cura]

I would be very interested to know any attempt to visualize 3D point cloud
from data base !
We did the same but our solution is far from perfect.
Bob, is you rporject public/open source, have you any paper/doc  about it ?

Cheers,

Rémi-C


2013/12/11 Basques, Bob (CI-StPaul) <bob.basques at ci.stpaul.mn.us>

>  Hmm,
>
>
>
> I’m working with the Minneapolis International Airport (MSP) on a project,
> any chance that  data is open/accessible enough to play with?  This could
> tie directly into a project I’m already working on.
>
>
>
> Thanks
>
>
>
> Bobb
>
>
>
>
>
>
>
> *From:* postgis-users-bounces at lists.osgeo.org [mailto:
> postgis-users-bounces at lists.osgeo.org] *On Behalf Of *Gerry Creager -
> NOAA Affiliate
> *Sent:* Tuesday, December 10, 2013 2:14 PM
>
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] Old question resurfacing
>
>
>
> Bob, all:
>
>
>
> I agree. I'll have to spend some time with pointcloud but it DOES look
> very promising.
>
>
>
> Another application? Lidar. Pointed at the sky, not at the ground (we use
> 'em to determine cloud layers [ceiling] and sky cover at airports for
> aviation data...).
>
>
>
> Thanks, all!
>
> gerry
>
>
>
> On Tue, Dec 10, 2013 at 1:49 PM, Basques, Bob (CI-StPaul) <
> bob.basques at ci.stpaul.mn.us> wrote:
>
> Gerry,
>
>
>
> Remi’s idea about using a point cloud may be spot on for your use.  It
> allows you to set a point cloud down to a revolution if need be, which
> seems like what you are looking for..  If the data becomes too massive for
> insertion into DB at real-time speeds, then you could also separate this
> revolution into separate DB’s as well, you could separate a whole number of
> ways, by elevation, or quadrant, or . . .
>
>
>
> I’m very interested in visualization possibilities with something like
> this being available in a database.  We’re doing some similar db 3d
> visualization stuff on some rather dense point clouds.  Your data once
> available could use the same visualizer.
>
>
>
> Bobb
>
>
>
>
>
>
>
> *From:* postgis-users-bounces at lists.osgeo.org [mailto:
> postgis-users-bounces at lists.osgeo.org] *On Behalf Of *Gerry Creager -
> NOAA Affiliate
> *Sent:* Tuesday, December 10, 2013 1:41 PM
> *To:* PostGIS Users Discussion
> *Subject:* Re: [postgis-users] Old question resurfacing
>
>
>
> Bob
>
>
>
> At least preliminarily, I can post-process, so speed of db adds isn't too
> troubling. Maintaining accurate representation of the bin-volume data is,
> however, important.
>
>
>
> Typical rotation is 1-3 RPM, and a complete volume scan takes ~11 min in
> clear air (where you best see biologicals if so inclined) or ~5 min in one
> of the storm data collection modes. These are for common WSR88D, stationary
> radars. SMARTR's and others we have here that are mobile present a whole
> host of other options/data eval and speed problems.
>
>
>
> Current radar data are nominally considered to have a horizontal
> resolution of ~250 m, ignoring distortion or keyholing due to
> range.Typically 16 elevations are scanned, once or or twice in storm mode
> and a few less elevations in clear air mode.
>
>
>
> Now, the interesting thing that's on the horizon is Phased Array Radar.
> When that happens, more data, more resolution, and faster updates.
>
>
>
> gerry
>
>
>
> On Tue, Dec 10, 2013 at 11:05 AM, Basques, Bob (CI-StPaul) <
> bob.basques at ci.stpaul.mn.us> wrote:
>
> Gerry,
>
>
>
> Seems like the biggest hangup would be in adding the data to the DB fast
> enough.  How many points, per revolution, and what is the frequency of a
> revolution (stationary Radar, correct, although as I think about it, it
> could be mobile if needed, just need to add in the radar location to each
> record)?
>
>
>
> Bobb
>
>
>
>
>
>
>
> *From:* postgis-users-bounces at lists.osgeo.org [mailto:
> postgis-users-bounces at lists.osgeo.org] *On Behalf Of *Gerry Creager -
> NOAA Affiliate
> *Sent:* Tuesday, December 10, 2013 10:52 AM
> *To:* PostGIS Users Discussion
> *Subject:* [postgis-users] Old question resurfacing
>
>
>
> I asked this years ago, and I think Paul was less than pleased with me
> (:-), but:
>
>
>
> Has anyone, in the ensuing years looked at encoding radar data into a
> postGIS database? We've a little idea that might benefit one project, and
> getting the radar data into a good geospatial format would be
> beneficial.The data, of coure, would start out as radial-distance and
> intensity from the radar site, although we could preprocess it by gridding.
>
>
>
> Thanks, Gerry
>
> --
>
> Gerry Creager
>
> NSSL/CIMMS
>
> 405.325.6371
>
> ++++++++++++++++++++++
>
> “Big whorls have little whorls,
>
> That feed on their velocity;
>
> And little whorls have lesser whorls,
>
> And so on to viscosity.”
>
> Lewis Fry Richardson (1881-1953)
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
>
>
>
> --
>
> Gerry Creager
>
> NSSL/CIMMS
>
> 405.325.6371
>
> ++++++++++++++++++++++
>
> “Big whorls have little whorls,
>
> That feed on their velocity;
>
> And little whorls have lesser whorls,
>
> And so on to viscosity.”
>
> Lewis Fry Richardson (1881-1953)
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
>
>
>
> --
>
> Gerry Creager
>
> NSSL/CIMMS
>
> 405.325.6371
>
> ++++++++++++++++++++++
>
> “Big whorls have little whorls,
>
> That feed on their velocity;
>
> And little whorls have lesser whorls,
>
> And so on to viscosity.”
>
> Lewis Fry Richardson (1881-1953)
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131211/d75b9c22/attachment.html>