distances.txt

                           name                            |               address_1               | miles_from_laci  
-----------------------------------------------------------+---------------------------------------+------------------
 Youth Green Community Garden                              | 12467 W. Osborne Street               | 17.8526752533434
 Eagle Rockdale Community Garden and Art Park              | 1003 Rockdale Avenue                  | 6.99298846428767
 Milagro Allegro Community Garden                          | 111 S Ave 56                          | 5.28154294629922
 Glassell Park Community Garden                            | 3305 Drew Street                      | 5.50435772214898
 Elysian Valley Community Garden                           | 1816 W Blake Avenue                   | 3.93094291476127
 Fountain Community Gardens                                | 5620 Fountain Avenue                  | 5.73078542701499
 Mansfield Fountain Community Garden                       | 1259 N Mansfield Avenue               | 7.01908053698899
 Rosewood Gardens                                          | 4160 Rosewood Avenue                  | 4.54177014503304
 Wattles Farm                                              | 1714 N Curson Avenue                  | 8.03065950394484
 Norman Harriton Community Garden                          | 2037 N Sanborn Avenue                 | 5.02395990218528
 Manzanita Street Community Garden                         | 1101 Manzanita Street                 |  4.4676947834788
 Jardin Del Rio                                            | 2363 N Riverdale Avenue               | 3.53239667552657
 El Sereno Community Garden                                | 5466 Huntington Drive                 | 5.56748196618774
 Proyecto Jardin                                           | 1718 Bridge Street                    | 1.35406520154708
 Salesian Boys & Girls Club Community Garden               | 2228 E 4th Street                     | 1.30524978495726
 Mothers of East LA Community Garden                       | 1020 S Fickett Street                 | 1.34854698163587
 Solano Canyon Community Garden                            | 545 Solano Avenue                     | 2.33133603430758
 Union Avenue/Cesar Chavez Community Garden                | 1136 S Union Avenue                   |  2.3131476266151
 Moothart Collingnon/Francis Avenue Community Garden       | 2909 Francis Avenue                   | 3.26010434968118
 Yamazaki Memorial Community Garden                        | 961 S Mariposa Avenue                 | 3.74618411666347
 Crenshaw Community Garden                                 | 1423 S Crenshaw Blvd                  |  5.2664133383392
 Good Earth Community Garden                               | 5552 Boden Street                     | 7.58246281407033
 Erika J. Glazer Community Garden                          | 2632 Raymond Avenue                   | 3.60972140394306
 The Learning Garden                                       | 1300 Venice Blvd                      | 2.65454477703678
 Growing Great Dreams                                      | 125 E Martin Luther King Jr Boulevard | 2.93210795634399
 Vermont Square Community Garden                           | 4712 S Vermont Avenue                 | 4.24497457810822
 Epworth Community Garden                                  | 1419 W 65th Street                    | 5.57209119676181
 Fremont Wellness Center & Community Garden                | 7821 S Avalon Blvd                    | 5.28880385919824
 Stanford Avalon Community Garden                          | 658 E 111th Place                     | 7.53816679157458
 Greater Watts Community Garden                            | 660 E 118th Place                     | 8.05314775179765
 Bougainvillea Community Garden                            | 2051 E 103rd Street                   | 6.91303475362796
 Vista Hermosa Gardens                                     | 1590 E 114th Street                   | 7.60551615796184
 Messiah Organic Community Garden                          | 7300 West Manchester Avenue           | 12.0769037488406
 Enrique Noguera Educational Garden                        | 6614 Fountain Avenue                  | 6.71848927996908
 Howard Finn Community Garden                              | 7747 Foothill Blvd                    | 15.5039599923967
 Granada Hills Salad Bowl Garden Club                      | 16003 Rinaldi Street                  | 21.6448546761269
 Rosemary & Thyme Community Garden                         | 10161 Jordan Avenue                   | 25.7455820759418
 Van Nuys Garden Center                                    | 16400 Chase Street                    | 19.3142147567764
 Arleta Community Garden                                   | 8800 Canterbury Avenue                |  16.949719709525
 North Hollywood Community Garden                          | 11800 Weddington Street               | 12.4328620099297
 Tarzana Community Garden                                  | 18702 Erwin Street                    | 20.0629934322488
 Orcutt Ranch Horticultural Center Rancho Sombra del Roble | 23600 Roscoe Blvd                     | 26.2805467518111
 Parkman Gardens                                           | 20800 Burbank Blvd                    | 22.0457939303495
 Sepulveda Garden Center                                   | 16633 Magnolia Boulevard              |  17.170455438422
 Ocean View Farms                                          | 3300 S Centinela Avenue               | 11.9420292967783
 WE Garden                                                 | 1010 Abbot Kinney Blvd                | 13.9532750526629
 Venice Community Garden                                   | 643 Mildred Avenue                    | 13.4690098733362
 Eastwind Community Garden                                 | 110 Eastwind Street                   | 13.7458780144525
 Mar Vista Community Garden                                | 5075 S Slauson Avenue                 | 10.3265711567995
 Holy Nativity Community Garden                            | 6700 West 83rd Street                 |   11.14164014555
 Emerson Avenue Community Garden                           | 6550 W 80th Street                    | 10.8672756596063
 Rosecrans Farms                                           | 561 W 146th Street                    | 10.1229832308403
 Youth Green Community Garden                              | 12467 W. Osborne Street               | 17.8526752533434
 Eagle Rockdale Community Garden and Art Park              | 1003 Rockdale Avenue                  | 6.99298846428767
 Milagro Allegro Community Garden                          | 111 S Ave 56                          | 5.28154294629922
 Glassell Park Community Garden                            | 3305 Drew Street                      | 5.50435772214898
 Elysian Valley Community Garden                           | 1816 W Blake Avenue                   | 3.93094291476127
 Fountain Community Gardens                                | 5620 Fountain Avenue                  | 5.73078542701499
 Mansfield Fountain Community Garden                       | 1259 N Mansfield Avenue               | 7.01908053698899
 Rosewood Gardens                                          | 4160 Rosewood Avenue                  | 4.54177014503304
 Wattles Farm                                              | 1714 N Curson Avenue                  | 8.03065950394484
 Norman Harriton Community Garden                          | 2037 N Sanborn Avenue                 | 5.02395990218528
 Manzanita Street Community Garden                         | 1101 Manzanita Street                 |  4.4676947834788
 Jardin Del Rio                                            | 2363 N Riverdale Avenue               | 3.53239667552657
 El Sereno Community Garden                                | 5466 Huntington Drive                 | 5.56748196618774
 Proyecto Jardin                                           | 1718 Bridge Street                    | 1.35406520154708
 Salesian Boys & Girls Club Community Garden               | 2228 E 4th Street                     | 1.30524978495726
 Mothers of East LA Community Garden                       | 1020 S Fickett Street                 | 1.34854698163587
 Solano Canyon Community Garden                            | 545 Solano Avenue                     | 2.33133603430758
 Union Avenue/Cesar Chavez Community Garden                | 1136 S Union Avenue                   |  2.3131476266151
 Moothart Collingnon/Francis Avenue Community Garden       | 2909 Francis Avenue                   | 3.26010434968118
 Yamazaki Memorial Community Garden                        | 961 S Mariposa Avenue                 | 3.74618411666347
 Crenshaw Community Garden                                 | 1423 S Crenshaw Blvd                  |  5.2664133383392
 Good Earth Community Garden                               | 5552 Boden Street                     | 7.58246281407033
 Erika J. Glazer Community Garden                          | 2632 Raymond Avenue                   | 3.60972140394306
 The Learning Garden                                       | 1300 Venice Blvd                      | 2.65454477703678
 Growing Great Dreams                                      | 125 E Martin Luther King Jr Boulevard | 2.93210795634399
 Vermont Square Community Garden                           | 4712 S Vermont Avenue                 | 4.24497457810822
 Epworth Community Garden                                  | 1419 W 65th Street                    | 5.57209119676181
 Fremont Wellness Center & Community Garden                | 7821 S Avalon Blvd                    | 5.28880385919824
 Stanford Avalon Community Garden                          | 658 E 111th Place                     | 7.53816679157458
 Greater Watts Community Garden                            | 660 E 118th Place                     | 8.05314775179765
 Bougainvillea Community Garden                            | 2051 E 103rd Street                   | 6.91303475362796
 Vista Hermosa Gardens                                     | 1590 E 114th Street                   | 7.60551615796184
 Messiah Organic Community Garden                          | 7300 West Manchester Avenue           | 12.0769037488406
 Enrique Noguera Educational Garden                        | 6614 Fountain Avenue                  | 6.71848927996908
 Howard Finn Community Garden                              | 7747 Foothill Blvd                    | 15.5039599923967
 Granada Hills Salad Bowl Garden Club                      | 16003 Rinaldi Street                  | 21.6448546761269
 Rosemary & Thyme Community Garden                         | 10161 Jordan Avenue                   | 25.7455820759418
 Van Nuys Garden Center                                    | 16400 Chase Street                    | 19.3142147567764
 Arleta Community Garden                                   | 8800 Canterbury Avenue                |  16.949719709525
 North Hollywood Community Garden                          | 11800 Weddington Street               | 12.4328620099297
 Tarzana Community Garden                                  | 18702 Erwin Street                    | 20.0629934322488
 Orcutt Ranch Horticultural Center Rancho Sombra del Roble | 23600 Roscoe Blvd                     | 26.2805467518111
 Parkman Gardens                                           | 20800 Burbank Blvd                    | 22.0457939303495
 Sepulveda Garden Center                                   | 16633 Magnolia Boulevard              |  17.170455438422
 Ocean View Farms                                          | 3300 S Centinela Avenue               | 11.9420292967783
 WE Garden                                                 | 1010 Abbot Kinney Blvd                | 13.9532750526629
 Venice Community Garden                                   | 643 Mildred Avenue                    | 13.4690098733362
 Eastwind Community Garden                                 | 110 Eastwind Street                   | 13.7458780144525
 Mar Vista Community Garden                                | 5075 S Slauson Avenue                 | 10.3265711567995
 Holy Nativity Community Garden                            | 6700 West 83rd Street                 |   11.14164014555
 Emerson Avenue Community Garden                           | 6550 W 80th Street                    | 10.8672756596063
 Rosecrans Farms                                           | 561 W 146th Street                    | 10.1229832308403
(104 rows)

Better query (turns out earthdistance returns results in meters):

psql -d food_oasis_temp -c 'select name, address_1, earth_distance(ll_to_earth(latitude::float, longitude::float), ll_to_earth(34.040691::float,-118.235984::float))/1609.34 as miles_from_laci from api_location;'

Select the ones that are within a given box (here 3000m):

select name, address_1, latitude, longitude from api_location where earth_box(ll_to_earth(34.040691::float,-118.235984::float), 3000) @> ll_to_earth(latitude, longitude);

Note that best practice here is to run this initial box query (which is efficient), then run an earth_distance < ... on the results to get a proper radius.