Skip to content

Instantly share code, notes, and snippets.

CSV Geocoder
-?,--help Print this message
-f,--format <arg> Output format of geocoded values (optional, default: WKT)
Possible values:
- WKT e.g. "POINT (-73.92578 40.839233)"
- latlong e.g. "40.839233,-73.92578"
-icn,--input-column-name <arg> Input column name to geocode (required)
-icsv,--input-csv-file <arg> Input CSV file with path (required)
-ocn,--output-column-name <arg> Output column name for geocoded values (required)
-ocsv,--output-csv-file <arg> Output CSV file with path (optional, default: same as input)
usage: java -jar csv_kit.jar [-?] [-dcn <arg>] [-icsv <arg>] [-mcsv <arg>] [-oci <arg>] [-ocn <arg>] [-ocs <arg>] [-ocsv
<arg>]
CSV kit
-?,--help Print this message
-dcn,--delete-columns-names <arg> Columns' names (comma separated) to delete from the output CSV file (optional)
-icsv,--input-csv-file <arg> Input CSV file with path (required)
-mcsv,--merge-csv-file <arg> CSV file to be merged with input-csv-file (optional)
-oci,--order-column-increment <arg> Column increments for the order column to be added (optional, default: 1)
-ocn,--order-column-name <arg> Column name for the order column to be added (optional)
-ocs,--order-column-start <arg> Column start value for the order column to be added (optional, default: 1)
out.dat
* record1_column1_value, record2_column1_value, record3_column1_value, ... (for all records)
* record1_column2_value, record2_column2_value, record3_column2_value, ... (for all records)
* record1_column3_value, record2_column3_value, record3_column3_value, ... (for all records)
* ... (for all columns sorted alphabetically)
* Little endian encoding.
out.mdat
* column_name (36 bytes), type (1 byte), size (2 bytes), offset (8 bytes)
* column_name (36 bytes), type (1 byte), size (2 bytes), offset (8 bytes)
usage: data_tile_maker [-?] [-csv <arg>] [-dbf <arg>] [-meta <arg>] [-out
<arg>]
Data Tile Maker
-?,--help Print this message
-csv,--csv-file <arg> CSV data file with path (optional: either csv or dbf)
-dbf,--dbf-file <arg> DBF data file with path (optional: either csv or dbf)
-meta,--meta-file <arg> Metadata file with path (required)
-out,--output-path <arg> Output path for data tiles (required)
usage: data_tile_maker [-?] [-csv <arg>] [-dbf <arg>] [-meta <arg>] [-out <arg>]
Data Tile Maker
-?,--help Print this message
-csv,--csv-file <arg> CSV data file with path (optional: either csv or dbf)
-dbf,--dbf-file <arg> DBF data file with path (optional: either csv or dbf)
-meta,--meta-file <arg> Metadata file with path (required)
-out,--output-path <arg> Output path for data tiles (required)
usage: dataset_analyzer [-?] [-csv <arg>] [-imeta <arg>] [-ometa <arg>]
Dataset Analyzer
-?,--help Print this message
-csv,--csv-file <arg> CSV data file with path (required)
-imeta,--input-metadata-file <arg> Merges the output metadata with input metadata (optional)
-ometa,--output-metadata-file <arg> Output file path for metadata (required)
usage: dbf2csv [-?] [-csv <arg>] [-dbf <arg>] [-meta <arg>]
DBF to CSV
-?,--help Print this message
-csv,--csv-file <arg> Output CSV file with path (required)
-dbf,--dbf-file <arg> Input DBF file with path (required)
-meta,--meta-file <arg> Output metadata JSON file with path (optional)
usage: shp2csv [-?] [-csv <arg>] [-meta <arg>] [-shp <arg>]
Shapefile to CSV
-?,--help Print this message
-csv,--csv-file <arg> Output CSV file with path (required)
-meta,--meta-file <arg> Output metadata JSON file with path (optional)
-shp,--shp-file <arg> Input shapefile with path (required)
usage: java -jar shp_splitter [-?] [-shp <arg>]
Shapefile splitter. Splits shapefiles larger than 2GB in smaller ones
-?,--help Print this message
-shp,--shp-file <arg> Input shapefile with path (required)
~/Projects/omni/backend $ rake -T
rake backend:build # Build all backend services and workers
rake backend:deps # Install all backend dependencies
rake backend:list # List configured workers
rake backend:restart[environment] # Restart all services and workers
rake backend:running # List running workers
rake backend:start[environment] # Start all services and workers
rake backend:stop[environment] # Stop all services and workers
rake dbstack:clean[environment] # Clean DB stack