Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I actually just built something like this, using nothing but CSS3 &amp; JS. Here's the code I wrote for handling the device orientation. The position needs to be smoothed out, but it should help you. It fires events constantly giving the "heading" &amp; "tilt angle". It's tied in to a much larger framework, so you're going to need to pull it out and trigger the events differently, but that's easy to do.</p> <pre><code>( function( $ ){ // interface to the compass that gets normalized $.Klass.add( 'HTML5.Orientation', $.Klass.Observable, { init : function( config ){ this._super(); $( window ).bind( 'deviceorientation', this.bindMethod( 'orientationChange' ) ); this.degrees = 0; this.config = config; } , orientationChange : function( ev ){ /** * beta = angle that top of device is pointing * gamma = angle that side of device is pointing * * In portrait only: if gamma closer to 0, pointing back. If closer to +- 180, pointing forward **/ var oEv = ev.originalEvent , heading = oEv.webkitCompassHeading - ( this.config.zeroDeg || 0 ) , beta = oEv.beta , gamma = oEv.gamma , orient = window.orientation , aOrient = window.orientation % 180 , angle = ( aOrient ? gamma : beta ); // ignore bad data if( oEv.webkitCompassAccuracy == -1 ){ this.trigger( 'bad-compass' ); return; } // if( oEv.webkitCompassAccuracy &gt;= 30 ){ this.trigger( 'inaccurate-compass' ); return; } // I think this means it's warming up :) if( oEv.webkitCompassAccuracy == 0 ){ return; } // normalize left or bottom being up if( ( 90 === orient ) || ( 180 === orient ) ){ angle = -angle; } // if in portrait and leaning forward, flip the angle around 90deg if( !aOrient ){ if( Math.abs( gamma ) &gt; 90 ){ angle = 180 - angle; } } // normalize compass fliping from 0--&gt;359 or visa-versa if( this.lastHeading &amp;&amp; ( Math.abs( heading - this.lastHeading ) &gt; 180 ) ){ this.lastHeading = 360-this.lastHeading; } if( !this.heading ){ this.heading = heading; } this.trigger( 'heading', this.heading = this.heading + heading - this.lastHeading ); this.trigger( 'angle', this.angle = angle ); this.lastHeading = heading; } } ); }( jQuery ) ); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PO3D World with GPS data in Javascript and html5
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USMark Kahn
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis looks like a great augmented reality helper, am I right? Upvoted for sharing! Using device orientation could be a cool feature to add. Now I've got to approach the beginning: rotating the 3d world model with some points in it, dynamically generated from gps data, to show one point at a time. A-la Google Earth without zoom effects.
      singulars
      1. PO
      1. USFrancesco Frapporti
    2. COAhh, guess I mis-read your question. You said "to rotate the world according to the gps data", I thought you meant orientation :) What data are you trying to "rotate" on?
      singulars
      1. PO
      1. USMark Kahn
    3. COOh, no problem. You shared a great bit of code here, I'm tempted to change my mind on this little project so I can use it :DD I wish th earth model to rotate... on it's center to show on the visible face some gps points, one at a time. They will represent user-sent data from across the globe. Maybe is more accurate to say "revolve" instead "rotate"?
      singulars
      1. PO
      1. USFrancesco Frapporti
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload