[postgis-users] Old question resurfacing

Wed Dec 11 10:42:56 PST 2013

For the PostGIS, processing, and visualization parts, you may want to look
at the presentations that Howard Butler and Paul Ramsey have done in the
last year at FOSS4G NA and FOSS4G.

David.

On Wed, Dec 11, 2013 at 11:33 AM, Gerry Creager - NOAA Affiliate <
gerry.creager at noaa.gov> wrote:

> I'll post a site where you can snag some data for MSP later. I'll also
> look into when we might get some Level II data from the FAA's Terminal
> Doppler Weather Radar. Test data, for sure, but it might help in getting
> them to free up the TDWR Level II... Never know.
>
> gerry
>
>
> On Wed, Dec 11, 2013 at 11:26 AM, Basques, Bob (CI-StPaul) <
> bob.basques at ci.stpaul.mn.us> wrote:
>
>>  Gerry,
>>
>>
>>
>> Any time stamped data for the MSP airport area would work in the near
>> term to play with, the realtime stuff would only be important once I got it
>> displaying alongside/inside  my existing info systems.  I’m all about doing
>> the data mashup stuff, you never know what kinds of uses will pop out of
>> these things once they are presented to folks.
>>
>>
>>
>> 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:* Wednesday, December 11, 2013 11:19 AM
>> *To:* PostGIS Users Discussion
>>
>> *Subject:* Re: [postgis-users] Old question resurfacing
>>
>>
>>
>> The radar data are freely available and while I'm working with an older
>> lidar ceilometer, I can make those data available to you, too. If you need
>> real time WSR88D data, I'll have to work with you on that, and we'll get a
>> data feed from another organization.
>>
>>
>>
>> Specifically, what I'm working on is to push the radar data into a
>> database (pointcloud really does look promising) and retrieve it as point
>> observations for what we call data assimilation to help improve weather
>> models. I'm working on placing other data into a PostGIS database for
>> surface observations, etc.
>>
>>
>>
>> Note that the ceilometer data is a VERY straightforward array every 'n'
>> seconds and won't pose a problem in stuffing it into a database. The
>> intriguing thing about a spatial database for lidar ceilometer data is the
>> ease in plotting individual sites' data. OR, if you were to place a grid of
>> these things out on a test site, to look at tomographs of the lower
>> atmosphere ("Boundary Layer").
>>
>>
>>
>> gerry
>>
>>
>>
>> On Wed, Dec 11, 2013 at 8:49 AM, Basques, Bob (CI-StPaul) <
>> bob.basques at ci.stpaul.mn.us> wrote:
>>
>> 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
>>
>>
>>
>>
>>
>> --
>>
>> 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/ffe8c26c/attachment.html>