Workflow to convert mysql qry to geojson file

geojson

#! /usr/bin/env bash
DBHOST=$1
USER=$2
DATABASE=$3
QRYTXT=$4 #(make sure x,y are called longitude and latitude)
OUTFILE=$5


# get data
mysql -h $DBHOST -u $USER -p -e "USE $DATABASE; $QRYTXT;" > tmpfile.txt
# asks for password 

# parse out bad values in txt file, conver to csv
perl -ne 's/\t/,/g; print $_;' tmpfile.txt > tmpfile.csv
perl -ne 's/NULL/None/g; print $_;' tmpfile.csv > $OUTFILE.csv

# make a new vrt file for the csv
perl -ne 's/FILENAME/'$OUTFILE'/g; print $_;' template.vrt > $OUTFILE.vrt

# make the geosjon file
# TODO: force to two dimensions
ogr2ogr -f "GeoJSON" $OUTFILE.js $OUTFILE.vrt 

# clean up (comment out for debugging)
rm tmpfile.*

template.vrt

<OGRVRTDataSource>
    <OGRVRTLayer name="FILENAME">
        <SrcDataSource>FILENAME.csv</SrcDataSource> 
 	<SrcLayer>FILENAM
	<GeometryType>wkbPoint</GeometryType> 
        <LayerSRS>WGS84</LayerSRS>
	<GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/> 
    </OGRVRTLayer>
</OGRVRTDataSource>