location_post

Description

An FQL table that returns Posts that have locations associated with them and that satisfy at least one of the following conditions:

you were tagged in the Post
a friend was tagged in the Post
you authored the Post
a friend authored the Post

The User object in the Graph API has a corresponding /locations connection. In addition, by including with=location in the URL parameters, the /home, /feed, and/post connections on the User object can be filtered to just those posts containing a location.

Columns

Name

Description

app_id

ID of the application that published the post

author_uid

ID of person publishing the post

coords

struct

Coordinates of the checkin location

latitude float (min: -90) (max: 90)	A float, in decimal degrees, describing the latitude. Minumum is -90.0, maximum is 90.0.
longitude float (min: -180) (max: 180)	A float, in decimal, describing the longitude. Minumum is -180.0, maximum is 180.0.
altitude float	A float, in meters, describing the altitude.
accuracy float	A float, in meters, describing the accuracy.
altitudeAccuracy float	A float describing the accuracy of the altitude.
heading float	A double or null, in degrees, describing the heading direction calculated based on previous position.
speed float	A double or null, in meters/second, describing the speed calculated based on previous position.
timestamp timestamp	A UNIX timestamp for the time of the request

ID of the object associated with this location

latitude

float

Latitude of the checkin location

longitude

float

Longitude of the checkin location

message

string

Message of the post story

page_id

ID of the Facebook page associated with the location or event in the post

page_type

string

Type of the target. For example, page and event

post_id

string

ID of the post story

tagged_uids

array

IDs of users tagged in the checkin

timestamp

UNIX timestamp of the checkin

type

string

The type of post. Either photo, checkin, video, or status

Examples

SELECT ... FROM location_post WHERE checkin_id = A
SELECT ... FROM location_post WHERE id = A
SELECT ... FROM location_post WHERE target_id = A
SELECT ... FROM location_post WHERE page_id = A
SELECT ... FROM location_post WHERE latitude = A AND longitude = B AND distance_meters = C
SELECT ... FROM location_post WHERE author_uid = A
SELECT ... FROM location_post WHERE tagged_uids = A
SELECT ... FROM location_post WHERE post_id = A

Note: Additional filters on other columns can be specified but they may make the query less efficient.

Permissions

To read Posts with location information, you need:

user_photos or friends_photos for Photos
user_status or friends_status for Posts (not including Photos)
user_checkins or friends_checkins for Checkins only (excluding all other types of Posts)

Requesting the user_status or friends_status permissions will return information about Checkins as well as other types of objects.

Tables

location_post

Description

Columns

Examples

Permissions