{"repo":"DFE-Digital/gias-query-tool","free":true,"listed":false,"github":"https://github.com/DFE-Digital/gias-query-tool","clone":"git clone https://github.com/DFE-Digital/gias-query-tool.git","description":"The easiest way to write advanced queries against the Get Information About Schools (GIAS) database","language":"SQL","stars":17,"topics":["data","postgis","postgresql","uk-schools","gias","gias-api"],"license":null,"category":"databases-storage","readme_excerpt":"The [Unofficial] GIAS Query Toolkit Ever wanted quickly query the Get Information About Schools dataset but couldn't because it's provided in an unwieldy CSV file that's not properly-encoded and has too many columns? Great, you're in the right place! This set of tools downloads and imports the data into a locally-running PostgreSQL database and lets you take advantage of PostGIS to supercharge your queries. Getting up and running Prerequisites GNU Make , used to run the automatic download and import GNU Iconv , fix file encoding GNU Wget for downloading the GIAS CSV file PostgreSQL with an local superuser account PostGIS for geographic query goodness Running the command To download, cleanse, import and build the data objects only a single command should be required. When debugging, use make refresh to run the import steps without repeatedly downloading the export file. Manual importing The entire import, apart from file cleansing, is written in standard SQL. Executing the statements needs to be done in the correct order, the Makefile is the best place to get a feel for how it works. Sending this data to BigQuery Dependencies The script assumes you have a gias dataset in your BigQuery project and a Google Cloud Storage bucket called rugged-abacus-uploads . Uploading First build the tables in your local database Then run the import Tables and views The importer creates the following database objects: Name Type Description ---- ---- ----------- schools table All schools, both op","default_branch":null,"files":null,"tree":[],"storefront":"/r/DFE-Digital","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/DFE-Digital/gias-query-tool/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}