Fulcrum Query CLI
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
src
.babelrc
.eslintrc
.gitignore
.travis.yml
LICENSE.txt
README.md
fq
package-lock.json
package.json
yarn.lock

README.md

fq

Fulcrum query CLI

Installation

npm install fulcrum-query-cli -g

Setup

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 csv

Output 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.csv

View GeoJSON features in geojson.io (requires geojsonio-cli package)

fq 'SELECT * FROM "Park Inventory"' -f geojson | geojsonio

Fetch 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