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