USDA

d/l spreadsheet

https://search.ams.usda.gov/farmersmarkets/mobile/mobile.html#zipResults

-> Business Directory -> National Farmers Market Diretory -> Export to Excel

from some url, into:

    /home/wendell/angela/farmer

head -1 yields:

    01:37:35 farmer $ head -1 Export.csv | tr ',' '\n'

    vim for cleanup

possible edits:

    x              text,    -- float longitude
    y              text,    -- float latitude

    updateTime     text,  -- timestamp???

prob. need python's csvreader to get quoted strings...

from asdi:

CREATE TABLE farmers(

    position     geometry(Point, 4326),
    );

sql create

here goes...

    02:52:09 farmer $ psql -h localhost -U adminw sqlcarrots < create.sql
    Password for user adminw:
    CREATE TABLE

FINALLY, got it to insert