fq
Fulcrum query CLI
Installation
npm install fulcrum-query-cli -gSetup
Create a file at ~/.fulcrumrc with your API token in it.
Usage
fq QUERY -f [format] -t [API token]Supported formats are csv, geojson, and json .
Example
Output a CSV to the console
fq 'SELECT feature_type, COUNT(1) FROM "Park Inventory/park_features" GROUP BY feature_type ORDER BY COUNT(1) DESC' -f csvOutput a CSV file
fq 'SELECT feature_type, COUNT(1) FROM "Park Inventory/park_features" GROUP BY feature_type ORDER BY COUNT(1) DESC' -f csv > park-features-by-type.csvView GeoJSON features in geojson.io (requires geojsonio-cli package)
fq 'SELECT * FROM "Park Inventory"' -f geojson | geojsonioFetch records matching a column value. Here we use double quotes on the query and backslash escape the table name.
fq "SELECT * FROM \"Fire Hydrant Inventory\" WHERE hydrant_type = 'Pillar / Aboveground'" -f geojson | geojsonio