Wow very cool projects =) Would be so cool to have a webgl client displaying postgis tables !
Cheers, Rémi-C 2013/12/12 Frank Henze <[email protected]> > Hi Bobb, > hi all, > > https://hub.sharedgeo.org/apps/x3d/ looks great! > > We have similar requirements for a 3d WebGIS. > A first prototype you can find at: > > http://www2.htw-dresden.de/~s68071/3DWebGIS/ > > For "Projektauswahl:" select "W3DS" > > and then select "Historische Gebäude" (Historical Buildings) > > If there is nothing to see, then press on the left side "Alles anzeigen" > > We use the community buildt Geoserver incl. Web 3D service + X3DOM + JS. > > Some of our problems: > > How to import 3D geometries into PostGIS? > Which formats and interfaces (CAD, X3D)? > Point clouds in PostGIS (also import of). > > Is there a 3D PostGIS interest-group? > If not, should one established? > > Frank > > Am 11.12.2013 17:44, schrieb Basques, Bob (CI-StPaul): > >> All, >> >> Nothing that far along. Did a couple of proofs of concept so far, I’ve >> done a couple of presentations on the Visualizer approach. We tried a >> couple of different things, x3Dom, allover’js >> >> You can see some of them here ( some of the pages take a while to load >> the data in the background, be patient): >> >> https://hub.sharedgeo.org/apps/x3d/ (these will generally need a webGL >> enabled browser) >> >> These are purely intended as a test of just how much data could easily >> be squished into the browser before if blows, so you might experience >> some failures. Ideally the data coming into these would be segmented >> via a SQL call to PostGIS Pointcloud sources. >> >> The last two in the list are using some point clouds cut from our recent >> data collect at 8pt per sq meter for the City (6 billion points in all), >> these are using about 300k points each for example. >> >> Bobb >> >> *From:*[email protected] >> [mailto:[email protected]] *On Behalf Of *Rémi Cura >> *Sent:* Wednesday, December 11, 2013 10:08 AM >> *To:* PostGIS Users Discussion >> *Subject:* Re: [postgis-users] Old question resurfacing >> >> >> 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) <[email protected] >> <mailto:[email protected]>> >> >> >> 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:*[email protected] >> <mailto:[email protected]> >> [mailto:[email protected] >> <mailto:[email protected]>] *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) >> <[email protected] <mailto:[email protected]>> 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:*[email protected] >> <mailto:[email protected]> >> [mailto:[email protected] >> <mailto:[email protected]>] *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) >> <[email protected] <mailto:[email protected]>> 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:*[email protected] >> <mailto:[email protected]> >> [mailto:[email protected] >> <mailto:[email protected]>] *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 <tel: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 >> [email protected] <mailto:[email protected]> >> >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> >> >> >> -- >> >> Gerry Creager >> >> NSSL/CIMMS >> >> 405.325.6371 <tel: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 >> [email protected] <mailto:[email protected]> >> >> 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 >> [email protected] <mailto:[email protected]> >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> >> >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> >> _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
