Get and load the GeoJson document

Teradata Developer Guides

ft:locale
en-US
ft:lastEdition
2026-08-18

The http://geojson.xyz/ website is a fantastic source for open geographical data in GeoJson format. We will load the "Populated Places" dataset that provides with a list of over 1000 significant world cities.

Open you favourite Python 3 interpreter and make sure you have the following packages installed:

  • wget
  • teradatasql
  • getpass

Download and read the cities dataset:

import wget
world_cities=wget.download('https://d2ad6b4ur7yvpq.cloudfront.net/naturalearth-3.3.0/ne_50m_populated_places.geojson')
with open(world_cities) as geo_json:
    jmap = jmap = geo_json.read()