### Amazon S3 Data Integration

The following visits data schema refers specifically to the data Foursquare sends via the Amazon S3 integration.

To learn more, please see the [Amazon S3 Data Integration Guide](https://docs.foursquare.com/developer/docs/amazon-s3).

| Field                       | Description                                                                 | Nullable |
|-----------------------------|-----------------------------------------------------------------------------|----------|
| EventId                     | The ID of the Geofence event                                               | N        |
| ConsumerId                  | The application’s Foursquare consumerId                                    | N        |
| ConsumerType                | DeviceOS Type. One of androidSdk or iosSdk                                 | N        |
| SdkBuild                    | The SDK Build version                                                      | N        |
| InstallId                   | The unique ID created by Pilgrim for each installation                      | N        |
| AdId                        | The user ADID                                                             | Y        |
| EventType                   | The type of notification that is coming through. One of, geofenceEnter, geofenceDwell, geofencePresence, geofenceExit | N        |
| EventLat                    | The latitude of the user when the geofence was triggered                   | N        |
| EventLng                    | The longitude of the user when the geofence was triggered                  | N        |
| Timestamp                   | Time of the arrival in milliseconds since epoch                             | N        |
| GeofenceId                  | The ID of the geofence                                                    | N        |
| GeofenceType                | The type of geofence shape. One of venue, chain, category, circle, polygon | N        |
| GeofenceName                | The geofence name                                                         | N        |
| Radius                      | The geofence radius                                                       | Y        |
| GeofenceLat                 | The latitude of the geofence center                                        | N        |
| GeofenceLng                 | The longitude of the geofence center                                       | N        |
| VenueId                     | The Foursquare ID of the nearest venue to the user when the geofence was triggered | Y        |
| PartnerVenueId              | The partner ID from the venue harmonization process                        | Y        |
| VenueName                   | The Venue name                                                            | Y        |
| Address                     | The address of the venue                                                  | Y        |
| CrossStreet                 | The venue cross street                                                    | Y        |
| City                        | The city of the venue                                                     | Y        |
| State                       | The state of the venue                                                    | Y        |
| Zip                         | The zip of the venue                                                      | Y        |
| CountryCode                 | The country code of the venue                                             | Y        |
| VenueLat                    | The latitude of the venue center                                           | Y        |
| VenueLng                    | The longitude of the venue center                                          | Y        |
| Chain1_id                   | The primary chain Id                                                      | Y        |
| Chain1                      | The primary chain name                                                    | Y        |
| Chain2_id                   | The secondary chain Id                                                    | Y        |
| Chain2                      | The secondary chain name                                                  | Y        |
| Chain3_id                   | The tertiary chain Id                                                     | Y        |
| Chain3                      | The tertiary chain name                                                  | Y        |
| Category_primary_id         | The primary category id                                                  | Y        |
| Category_primary            | The primary category name                                                | Y        |
| Category_secondary_id       | The secondary category id                                                | Y        |
| Category_secondary           | The secondary category name                                              | Y        |
| Category_tertiary_id       | The tertiary category id                                                | Y        |
| Category_tertiary           | The tertiary category name                                              | Y        |