hnthap / gadm36_to_sql_and_csv

Convert GADM36 Code List to usable SQL script and importable CSV data.

Convert GADM36 Code List to usable SQL script and importable CSV data

Introduction

The GADM36 Code List is freely provided in these links:

List Name	Information	CSV File
Global, Region, Country	here	here
Global - Admin 1	here	here
Global - Admin 2	here	here
Global - Admin 3	here	here

The problem is some people need to use these data with SQL. So I write the schema of necessary tables and some PowerShell script to generate tabular data for these tables, using SQLite 3.

Prerequisites

Command Line Shell For SQLite v3.37.0+

Run this line to check if you have sqlite3:

sqlite3 --version

SQLite v3.37.0+ is needed for STRICT table supports. If you do not have the Command Line Shell For SQLite in your system, refer to the official website for installation instruction.

Internet connection

Internet connection is necessary to download CSV files from FAO sites as mentioned in the Introduction.

Run

In PowerShell:

git clone https://github.com/hnthap/gadm36_to_sql_and_csv.git
Set-Location gadm36_to_sql_and_csv
./main.ps1

After it's done, you will have your resulted files appeared in the out/ directory.

Licenses

This reposity is licensed under MIT License. See the file LICENSE for more.

The GADM36 Code List data is licensed under CC BY 4.0 DEED of the Hand-in-Hand Initiative.

gadm36_to_sql_and_csv's Issues

Some geo_entity_type rows doesn't seem right

Some rows in the generated geo_entity_type.csv doesn't seem right. One of them is empty. Some rows still have the | delimiter. Doesn't it need to be handled properly?