StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2299791
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-02-19T21:39:37.780
FavoriteCount
0
LastActivityDate
2010-02-19T21:39:37.780
LastEditDate
LastEditorUserId
0
OwnerUserId
222908
ParentId
2299668
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
To receive incoming SMSes, you would normally need an SMS gateway which supports incoming SMS. <a href="http://www.clickatell.com/products/sms%5Fgateway.php" rel="nofollow noreferrer">Clickatell</a> is a popular SMS gateway. It works in 200+ countries, and ironically it is being advertised right next to the text box I'm writing this answer! For incoming SMSes, you would have to expose an interface from your server through: HTTP, SMPP, SOAP or FTP. For example if you use the HTTP GET and you provide this URL to Clickatell: <code>http://www.yourdomain.com/incoming-sms/</code>, then Clickatell will send you this type of GET request with every incoming SMS: <pre><code>https://www.yourdomain.com/incoming-sms/? api_id=12345& from=279991235642& to=27123456789& timestamp=2010-02-1921:29:50& text=Here%20is%20the%20messagetext& charset=ISO-8859-1& moMsgId=b2aee337abd962489b123fda9c3480fa </code></pre> As soon as you receive the address within the SMS body, you would have to get the latitude/longitude coordinates through the <a href="http://code.google.com/apis/maps/documentation/geocoding/index.html" rel="nofollow noreferrer">Google Maps API Server-side Geocoding Service</a>. If you are using php, this would look something like this: <pre><code>$url = 'http://maps.google.com/maps/geo?q=Oxford+Street,+London,+UK&output=csv&sensor=false'; $data = @file_get_contents($url); $result = explode(",", $data); echo $result[0]; // status code echo $result[1]; // accuracy echo $result[2]; // latitude echo $result[3]; // longitude </code></pre> Once you get the latitude and longitude, you can store them in a database for later plotting on Google Maps. Note that the server-side geocoding service may only be used in conjunction with displaying results on a Google map; geocoding results without displaying them on a map is prohibited by the <a href="http://code.google.com/apis/maps/terms.html#section_10_12" rel="nofollow noreferrer">Google Maps API Terms of Service License Restrictions</a>. <hr> If you want to use the Clickatell SMS gateway to send a response back via SMS, their API offers a choice of outgoing connection options via: HTTP/S, SMPP, SMTP, FTP, XML, SOAP, COM Object. The HTTP/S method is as simple as this: <code>http://api.clickatell.com/http/sendmsg?to=NUMBER&msg=Message+Body+Here</code> (<a href="http://support.clickatell.com/guides/clickatell/api_guide.php" rel="nofollow noreferrer">Clickatell API Guide</a>). The SMTP method consists of sending a plain-text e-mail to: <code>sms@messaging.clickatell.com</code>, with the following body: <pre><code>user: xxxxx password: xxxxx api_id: xxxxx to: 448311234567 text: Meet me at home </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to create a system that will receive SMS messages with a location in the title and automatically transfer that information into Google Maps?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USDaniel Vassallo
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
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
CommentsPostId
1. This table or related slice is empty.

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.