AI Features
Home
Courses
The Art of PostgreSQL

Administrative Zoning

Learn about geographical breakdown and data normalization

We'll cover the following...

Geographical breakdown

The raw data from the GeoNames website then offers an interesting geographical breakdown in the country_code, admin1_code, and admin2_code.

select geonameid, name, admin1_code, admin2_code
  from raw.geonames
 where country_code = 'FR'
 limit 5
offset 50;

To get an interesting result set, we select randomly from the data for France, where the code has to be expanded to be meaningful. With a USA-based dataset, we get state codes as admin1_code (e.g., IL for Illinois), and ...

Ask