Skip to content

Create a script to load data into the PostGIS database

Script to query the Census REST API, extract data interested by the projects, and load into PostGIS database.

Table 1 :

name type key index
geom geom spatial
geoid number PK index
name varchar
level varchar

Table 2 (SIERRA):

name type key index
geoid number PK, FK index
attribute any

Table 3 (Ameren):

name type key index
geoid number PK, FK index
attribute any
Edited by Edmond Lai