allenday / bigquery-openstreetmap

bigquery-openstreetmap
BSD 3-Clause "New" or "Revised" License
13 stars 6 forks source link

write QA script to count features for layered_gis queries #58

Open allenday opened 4 years ago

allenday commented 4 years ago
for SQL in `find . -type f -name '*.sql' | sort`; do
    echo -n "$SQL     "; 
    echo "SELECT layer_code,layer_class,layer_name,COUNT(*) AS c FROM ("`cat $SQL`") GROUP BY layer_code,layer_class,layer_name" | bq query --nouse_legacy_sql --quiet --format=json ; 
done