close

Sign in

To view secure documentation please login with EAN Service Desk, using the link below.

EAN service desk

No EAN Service Desk account?

Please contact your EAN representative

Login
Sign in
Rapid

Geography Database RecommendationsAll Versions

Geography definitions provided in the Rapid Geography APIs can be stored in your database for destination retrieval.

Region

The example below provides the SQL data types of the geography fields as they appear in the Region Descendants and Region API responses and their recommended minimum storage lengths.

{
    "id": “64-BIT INTEGER",
    "type": "STRING(50)",
    "name": "STRING(255)",
    "name_full": "STRING(510)",
    "country_code": "STRING(2)",
    "coordinates": {
        "center_longitude": "DECIMAL(9,6)",
        "center_latitude": "DECIMAL(9,6)",
        "bounding_polygon": {
            "type": "STRING(50)",
            "coordinates": [
                [
                    [
                       "DECIMAL(9,6)",
                       "DECIMAL(9,6)"
                    ],
                    . . .
                ]
            ]
        }
    },
    "ancestors": [
        {
            "id": "64-BIT INTEGER",
            "type": "STRING(50)"
        }
    ],
    "descendants": {
        "STRING(50)": [
           "64-BIT INTEGER"
        ]
    },
    "property_ids": [
       "64-BIT INTEGER"
    ],
    "property_ids_expanded": [
       "64-BIT INTEGER"
    ]
}

Airport

The example below provides the SQL data types of the geography fields as they appear in the Airports and Airport API responses and their recommended minimum storage lengths.

{
    "iata_airport_code": "STRING(3)”,
    "name": "STRING(255)",
    "name_full": "STRING(510)",
    "country_code": "STRING(2)”
    "coordinates": {
        "center_longitude": "DECIMAL(9,6)",
        "center_latitude": "DECIMAL(9,6)"
    },
    "property_ids": [
        "64-BIT INTEGER"
    ],
    "associated_region": {
        "id": "64-BIT INTEGER",
        "type": "STRING(50)",
        "name": "STRING(255)",
        "name_full": "STRING(510)",
        "property_ids": [
            "64-BIT INTEGER"
        ]
    }
}
New Release - EAN Rapid 2.1

EAN Rapid 2.1 has been fully released to production! Find out what's new or see our changelog details to get started. Rapid 2.0 documentation is still available via the version drop-down menu in the upper right corner of each doc page.