StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4641805
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-01-09T21:08:31.473
FavoriteCount
0
LastActivityDate
2011-01-10T17:14:30.613
LastEditDate
2011-01-10T17:14:30.613
LastEditorUserId
306149
OwnerUserId
306149
ParentId
4641494
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
I have used both the Google and Bing Maps APIs. Without more details or requirements, I can only provide general information. <a href="http://code.google.com/intl/en/apis/maps/documentation/directions/" rel="nofollow">Google Directions API</a> <a href="http://msdn.microsoft.com/en-us/library/ff701717.aspx" rel="nofollow">Bing Route Calculation</a> Just from some quick research, I do not believe Open Street Map has a native directions API. For other Open Street Map solutions, look <a href="http://wiki.openstreetmap.org/wiki/Category%3aRouting" rel="nofollow">on their wiki</a> ("YOURS" specifically may be of interest). Google Directions API For the Google Directions API, a sample request for directions between two German cities would look like : <a href="http://maps.googleapis.com/maps/api/directions/json?region=de&language=de&origin=Berlin&destination=Hamburg&sensor=false" rel="nofollow">http://maps.googleapis.com/maps/api/directions/json?region=de&language=de&origin=Berlin&destination=Hamburg&sensor=false</a> Breaking down the <a href="http://code.google.com/apis/maps/documentation/directions/#RequestParameters" rel="nofollow">parameters</a> required: <ul> <li>origin The starting location.</li> <li>destination The destination.</li> <li>sensor Is the request for a device that can sense location?</li> </ul> And the parameters for a German search (optional): <ul> <li>region=de Give Google Maps an idea of where in the world to search by passing in the German top level domain code.</li> <li>language=de Tell Google Maps to return directions in German (<a href="http://spreadsheets.google.com/pub?key=p9pdwsai2hDMsLkXsoM05KQ&gid=1" rel="nofollow">See available languages</a>)</li> </ul> Modify this template request as required. <hr> edit Bing Routing Example Bing requires you to get an API key to work with any data. A sample request for Bing for the routes between two german cities: <a href="http://dev.virtualearth.net/REST/v1/Routes?wayPoint.1=Berlin&waypoint.2=Hamburg&culture=de-DE&key=YOUR_KEY_HERE" rel="nofollow">http://dev.virtualearth.net/REST/v1/Routes?wayPoint.1=Berlin&waypoint.2=Hamburg&culture=de-DE&key=YOUR_KEY_HERE</a> Required Params: <ul> <li>wayPoint.1 The starting location.</li> <li>wayPoint.2 The destination (Note how you can easily add more waypoints). </li> <li>key Insert your Bing Map API key here.</li> </ul> Optional Params: <ul> <li>culture=de-DE The <a href="http://msdn.microsoft.com/en-us/library/ff701709.aspx" rel="nofollow">culture parameter</a> gives Bing an idea of where to search and what to return.</li> </ul> Terms of Use Per the <a href="http://code.google.com/apis/maps/terms.html" rel="nofollow">Google</a> and <a href="http://www.microsoft.com/maps/product/terms.html" rel="nofollow">Bing</a> Maps API terms of use, you must display an image that lets users know you are using the mapping service.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to calculate the route between city X and city Y? #maps
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMatt Bierner
UserOwnerUserId
1. USMatt Bierner
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to calculate the route between city X and city Y? #maps
 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
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COThanks! Would you mind to add an example for Bing? Has Bing the same strange limitation that one can use routing only with the images?
 singulars
 PostPostId
 PO
 UserUserId
 USKarussell
2. COBoth have limitations for free use. The constraints are much more flexible for commercial use, and Bing tend to be more open about the commercial options.
 singulars
 PostPostId
 PO
 UserUserId
 USwinwaed

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.