[postgis-users] Old question resurfacing

Wed Dec 11 11:04:03 PST 2013

Noted. Thanks.
gerry

On Wed, Dec 11, 2013 at 12:42 PM, David Fawcett <david.fawcett at gmail.com>wrote:

> 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
>>
>
>
> _______________________________________________
> 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)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131211/76c1ace7/attachment.html>