changed sql query to add future events; added geojson example for eventitem