StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
15369094
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-03-12T18:22:02.567
FavoriteCount
0
LastActivityDate
2013-03-12T19:06:55.273
LastEditDate
2013-03-12T19:06:55.273
LastEditorUserId
894885
OwnerUserId
894885
ParentId
15368717
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
I think it should be possible to do it this way: Convert the <code>x</code> and <code>y</code> coordinates to polar coordinates <code>r</code> and <code>theta</code>, (with the radar as the origin). Subtract the radar's rotation, and convert back to cartesian coordinates. Then you just have to convert to latitude and longitude and add the coordinates of the radar. <pre><code>double r = Math.hypot(radarX, radarY); double theta = Math.atan2(radarY, radarX); theta -= Math.toRadians(Config.RADAR_FACING_DIRECTION); float x = (float) r * Math.cos(theta); float y = (float) r * Math.sin(theta); longitude = metersToLongitude(Config.RADAR_POSITION, y) + Config.RADAR_POSITION.longitude; latitude = metersToLatitude(Config.RADAR_POSITION, x) + Config.RADAR_POSITION.latitude; </code></pre> I found formulae for the length of a degree of latitude and longitude on Wikipedia. A degree of latitude is the same everywhere but longitude gets smaller near the poles. <pre><code>static float metersToLatitude(Position near, float meters) { return meters / 110.6*1000; } static float metersToLongitude(Position near, float meters) { float lat = Math.toRadians(near.latitude); return meters / (111132.954 - 559.822 * Math.cos(2*lat) + 1.175 * Math.cos(4*lat)); } </code></pre> Unfortunately this doesn't seem to work and I can't figure out why. If you want to express your coordinates in positive degrees east/west/north/south you'll also have to check if they're negative and invert them and the direction in that case.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCalculate new coordinates from old coordinates and x and y
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USSamuel Edwin Ward
UserOwnerUserId
1. USSamuel Edwin Ward
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POCalculate new coordinates from old coordinates and x and y
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COThanks. Your answer inspired me. You can find the code I used in my answer below.
 singulars
 PostPostId
 PO
 UserUserId
 USDimme

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.