Special fields

The GeoSpock database is optimized for event and location based datasets. For best performance, it is important that events and locations are fully defined. This requires some fields to be annotated with a purpose, to indicate how the data in the field should be optimized to provide high performance querying. You should include purpose for the following fields:

Field Description Source format purpose key pair

Example
latitude

The latitude for the event or location

This is restricted to sqlType REAL or DOUBLE

Latitude source data must be specified in its decimal form (eg. -30.5). Each value will be validated based on the min/max latitude range (ie. -90⇔+90)

 purpose: "LATITUDE" 
{
    “id”: “event_latitude”,
    “sourceFieldName”: “lat1”,
    “purpose”: “LATITUDE”,
    “sqlType”: “DOUBLE”
}
longitude

The longitude for the event or location

This is restricted to sqlType REAL or DOUBLE

Longitude source data must be specified in its decimal form (eg. -30.5). Each value will be validated based on the min/max longitude range (ie. -180⇔+180)

 

 purpose: "LONGITUDE" 
{
    “id”: “event_longitude”,
    “sourceFieldName”: “lon1”,
    “purpose”: “LONGITUDE”,
    “sqlType”: “DOUBLE”
}
source ID The ID of the device or individual that associated with the event or location

Source ID fields must be in text form by specifying sqlType: VARCHAR.

 

 purpose: "SOURCE_ID" 
{
“id”: “device_id”,
“sourceFieldName”: “guid”,
“purpose”: “SOURCE_ID”,
“sqlType”: “VARCHAR”
}