trees
979 rows where qSpecies_id = 13 sorted by PlotSize
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 895 | 56729 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1547 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 5 | Permit Number 769649 | 6015653.0224 | 2095684.4557 | 37.7352295280363 | -122.388297771341 | (37.7352295280363, -122.388297771341) | 10 | 3 | 8 | 58 | 1 | ||
| 1439 | 72311 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3769 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5996250.37824 | 2115874.50597 | 37.7895720432509 | -122.456839183887 | (37.7895720432509, -122.456839183887) | 11 | 6 | 1 | 54 | 31 | |||
| 2501 | 78191 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 680 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6015407.71241 | 2105894.14692 | 37.7632496064147 | -122.389858829046 | (37.7632496064147, -122.389858829046) | 14 | 3 | 8 | 28856 | 29 | |||
| 2708 | 50426 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/2014 12:00:00 AM | 3 | Permit Number 773627 | 5997303.25557645 | 2090612.9654569 | 37.7202705700793 | -122.45137364778 | (37.7202705700793, -122.45137364778) | 9 | 8 | 6 | 28861 | 24 | |
| 3356 | 74692 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 200 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011876.44918 | 2119465.43765 | 37.8003167500634 | -122.403026990216 | (37.8003167500634, -122.403026990216) | 3 | 1 | 10 | 308 | 23 | |||
| 3837 | 255657 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1421 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2018 12:00:00 AM | 3 | 6000959.70168 | 2111031.39919 | 37.7765434007218 | -122.44019801367 | (37.7765434007218, -122.44019801367) | 15 | 5 | 11 | 29492 | 10 | |||
| 4723 | 259742 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 259 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/11/2019 12:00:00 AM | 3 | 6005340.35583 | 2109906.90312 | 37.7737042366543 | -122.424964031136 | (37.7737042366543, -122.424964031136) | 7 | 9 | 11 | 28852 | 10 | ||
| 4879 | 260889 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 527 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981905.91133 | 2112171.65096 | 37.7785709887537 | -122.506193994794 | (37.7785709887537, -122.506193994794) | 11 | 6 | 2 | 55 | 26 | |||
| 5226 | 259803 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 5720 | 80737 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 186 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6000043.55254 | 2087718.30936 | 37.7124790304587 | -122.44169374357 | (37.7124790304587, -122.44169374357) | 9 | 7 | 6 | 28861 | 5 | |||
| 6177 | 70542 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 657 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 6001053.4846 | 2110988.4642 | 37.7764308509595 | -122.439870513201 | (37.7764308509595, -122.439870513201) | 15 | 5 | 11 | 29492 | 10 | ||||
| 6589 | 44716 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1879 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/2020 12:00:00 AM | 3 | Permit Number 43838 | 5989679.8369 | 2102593.1522 | 37.7527256083507 | -122.478600649693 | (37.7527256083507, -122.478600649693) | 1 | 8 | 3 | 56 | 35 | |
| 6875 | 260888 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 528 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981946.38688 | 2112159.7169 | 37.7785406040131 | -122.50605309173 | (37.7785406040131, -122.50605309173) | 11 | 6 | 2 | 55 | 26 | |||
| 7356 | 71615 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 536 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5983503.66193 | 2112151.1699 | 37.7786086821922 | -122.500665338334 | (37.7786086821922, -122.500665338334) | 11 | 6 | 2 | 55 | 26 | |||
| 7414 | 70266 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 414 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5988762.33088 | 2112478.21963 | 37.7798139854521 | -122.482497769619 | (37.7798139854521, -122.482497769619) | 11 | 6 | 2 | 55 | 26 | |||
| 7661 | 83659 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 559 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001685.54257 | 2090383.45339 | 37.7198903425557 | -122.436209138162 | (37.7198903425557, -122.436209138162) | 9 | 7 | 6 | 28861 | 5 | |||
| 8309 | 55891 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1981 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/1979 12:00:00 AM | 4 | Permit Number 17936 | 6003525.54431 | 2118603.6465 | 37.7974806237872 | -122.431862837898 | (37.7974806237872, -122.431862837898) | 13 | 9 | 1 | 57 | 17 | ||
| 8414 | 260883 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 122 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5988999.56708 | 2114522.30916 | 37.7854402782048 | -122.481826844764 | (37.7854402782048, -122.481826844764) | 11 | 6 | 2 | 55 | 26 | ||
| 8586 | 50836 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 202 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2004 12:00:00 AM | Permit Number 47354 | 5994277.69303186 | 2105335.48637483 | 37.7605212305047 | -122.462899497742 | (37.7605212305047, -122.462899497742) | 1 | 5 | 11 | 56 | 12 | |||
| 9218 | 106080 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 188 The Embarcadero | 1 | Front Yard : Yard | Tree | Private 2 | 03/20/2014 12:00:00 AM | Permit Number 771259 | 6015087.8131 | 2116516.98611 | 37.7923997963133 | -122.391708043282 | (37.7923997963133, -122.391708043282) | 12 | 2 | 9 | 28855 | 6 | |||
| 9454 | 260881 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 751 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985678.2622 | 2110774.56948 | 37.7749563544765 | -122.493041236092 | (37.7749563544765, -122.493041236092) | 11 | 6 | 2 | 55 | 26 | |||
| 10033 | 80634 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 577 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6013018.0309 | 2104352.7115 | 37.7588843520526 | -122.398015861652 | (37.7588843520526, -122.398015861652) | 10 | 3 | 8 | 28856 | 29 | |||
| 10679 | 259873 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2666 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5996410.48132 | 2110785.34876 | 37.7756077608376 | -122.455917191866 | (37.7756077608376, -122.455917191866) | 11 | 6 | 2 | 54 | 16 | ||
| 11517 | 72252 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 531 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6002585.93283 | 2090796.9641 | 37.7210768666757 | -122.433126335006 | (37.7210768666757, -122.433126335006) | 9 | 7 | 6 | 28861 | 5 | |||
| 11942 | 34949 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1246 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | Permit Number 38547 | 6007519.49351 | 2115461.74269 | 37.7890793334842 | -122.417819862092 | (37.7890793334842, -122.417819862092) | 13 | 1 | 10 | 28858 | 21 | ||
| 12150 | 31352 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2359 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2020 11:52:00 AM | 3 | Permit Number 34962 | 5992611.19724 | 2099415.50216 | 37.7441703551938 | -122.468232424195 | (37.7441703551938, -122.468232424195) | 1 | 8 | 4 | 29491 | 40 | |
| 12808 | 254368 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 590X Orizaba Ave | 1 | Back Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | ||||||||||||
| 13364 | 70607 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1256 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007485.00571 | 2115457.39575 | 37.7890654569562 | -122.417938877483 | (37.7890654569562, -122.417938877483) | 13 | 1 | 10 | 28858 | 21 | |||
| 14077 | 70606 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1250 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007500.28626 | 2115460.0775 | 37.7890736803541 | -122.417886198793 | (37.7890736803541, -122.417886198793) | 13 | 1 | 10 | 28858 | 21 | |||
| 14384 | 65195 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 277 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 2 | Permit Number 27179 | 6002900.88646 | 2091805.07241 | 37.7238627685341 | -122.432109587587 | (37.7238627685341, -122.432109587587) | 9 | 7 | 6 | 28861 | 5 | |
| 15038 | 259861 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 15129 | 102443 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 514 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2013 12:00:00 AM | 1 | Permit Number 770339 | 6013518.76597 | 2104573.81866 | 37.7595193399709 | -122.396299571184 | (37.7595193399709, -122.396299571184) | 10 | 3 | 8 | 28856 | 29 | ||
| 15229 | 259804 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 15796 | 260912 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99x Belvedere St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
| 15945 | 262454 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 230 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 6001065 | 2093436 | 37.7282366652571 | -122.438572735463 | (37.7282366652571, -122.438572735463) | 9 | 7 | 6 | 28861 | 25 | ||
| 18162 | 83433 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 760 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000998.571 | 2089370.50235 | 37.7170699516967 | -122.438511216421 | (37.7170699516967, -122.438511216421) | 9 | 7 | 6 | 28861 | 5 | |||
| 19358 | 259860 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 22457 | 93624 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 149 Collins St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | Permit Number 53164 | 5998064 | 2113562 | 37.783326485193 | -122.450397500912 | (37.783326485193, -122.450397500912) | 15 | 6 | 1 | 54 | 31 | |||
| 26931 | 37803 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010402.90992445 | 2091781.87036726 | 37.7242215408534 | -122.406174555323 | (37.7242215408534, -122.406174555323) | 10 | 3 | 7 | 309 | 28 | ||
| 26944 | 105800 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 207 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2014 12:00:00 AM | 3 | Permit Number 769635 | 6010004.04754 | 2087785.06673 | 37.71322482385 | -122.407271751589 | (37.71322482385, -122.407271751589) | 9 | 7 | 8 | 309 | 39 | ||
| 27335 | 50837 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 202 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2004 12:00:00 AM | Permit Number 47354 | 5994277.69303186 | 2105335.48637483 | 37.7605212305047 | -122.462899497742 | (37.7605212305047, -122.462899497742) | 1 | 5 | 11 | 56 | 12 | |||
| 28513 | 37585 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 210 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40016 | 5999628.99810136 | 2104552.86123042 | 37.7586791121732 | -122.444335603116 | (37.7586791121732, -122.444335603116) | 2 | 4 | 5 | 28862 | 3 | ||
| 30764 | 97025 | Property Tree 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
| 33672 | 103773 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1288 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | |||
| 37880 | 53932 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 140 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 1 | Permit Number 9646 | 5993064.17697 | 2114524.47346 | 37.7856817557629 | -122.467764782699 | (37.7856817557629, -122.467764782699) | 11 | 6 | 2 | 54 | 11 | ||
| 38155 | 43751 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 255 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/2015 12:00:00 AM | 3 | Permit Number 773834 | 5991170.79793 | 2113718.28394 | 37.7833586747671 | -122.474256417664 | (37.7833586747671, -122.474256417664) | 11 | 6 | 2 | 54 | 26 | |
| 40035 | 105251 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 500 36th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 1 | Permit Number 771049 | 5984733.08187 | 2112389.43293 | 37.7793349822998 | -122.496429952441 | (37.7793349822998, -122.496429952441) | 11 | 6 | 2 | 55 | 26 | ||
| 40064 | 84782 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 228 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2007 12:00:00 AM | 5 | Permit No. 49243 | 6013990.15625 | 2105982.37522 | 37.7634131481085 | -122.394767902514 | (37.7634131481085, -122.394767902514) | 14 | 3 | 8 | 28856 | 29 | ||
| 41966 | 49512 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1928& 21st AVE Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2003 12:00:00 AM | 4 | Permit Number 46417 | 5989493.41802 | 2113376.93915 | 37.7823241210106 | -122.480034435471 | (37.7823241210106, -122.480034435471) | 11 | 6 | 2 | 55 | 26 | ||
| 45290 | 112888 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3980 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2015 12:00:00 AM | Permit Number 774440 | 5995705.4 | 2115208.7 | 37.7877126116995 | -122.458676518899 | (37.7877126116995, -122.458676518899) | 11 | 6 | 1 | 54 | 31 | |||
| 46494 | 48393 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1325 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 4 | Permit Number 45775 | 5994526.88441 | 2112095.32134 | 37.7790963088496 | -122.462528007047 | (37.7790963088496, -122.462528007047) | 11 | 6 | 2 | 54 | 11 | |
| 47704 | 108089 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2501X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 773081 | 6010157.47788 | 2105483.07585 | 37.7618283430246 | -122.407988746007 | (37.7618283430246, -122.407988746007) | 10 | 4 | 8 | 28859 | 19 | ||
| 48899 | 84780 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 224 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2007 12:00:00 AM | 4 | Permit No. 49287 | 6013987.25375 | 2106041.39506 | 37.7635750422708 | -122.394782074949 | (37.7635750422708, -122.394782074949) | 14 | 3 | 8 | 28856 | 29 | ||
| 50794 | 69419 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 168 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 9 | Permit Number 33524 | 6001328.44378 | 2087365.87339 | 37.7115844451475 | -122.437227553813 | (37.7115844451475, -122.437227553813) | 9 | 7 | 6 | 28861 | 5 | |
| 53411 | 114722 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788 | 37.7242419338513 | -122.405954818575 | (37.7242419338513, -122.405954818575) | 10 | 3 | 7 | 309 | 28 | |||
| 53557 | 67205 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 123 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1992 12:00:00 AM | 3 | Permit Number 30659 | 5987996.0292 | 2115149.70283 | 37.7871045112839 | -122.485344797558 | (37.7871045112839, -122.485344797558) | 11 | 6 | 1 | 55 | 33 | ||
| 54020 | 95101 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3601x Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 2 | 5999657.71874 | 2120941.08267 | 37.8036785786574 | -122.445414641767 | (37.8036785786574, -122.445414641767) | 13 | 9 | 1 | 57 | 17 | |||
| 57331 | 115763 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 37 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 771927 | 6005378.2 | 2095966 | 37.7354278990147 | -122.423841638688 | (37.7354278990147, -122.423841638688) | 2 | 7 | 7 | 28859 | 2 | ||
| 58994 | 114753 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777133 | 6010495.97692 | 2091580.43732 | 37.7236736527876 | -122.405838652231 | (37.7236736527876, -122.405838652231) | 10 | 3 | 7 | 309 | 28 | ||
| 60873 | 99585 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 301X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2013 12:00:00 AM | 6003014.6 | 2106437.9 | 37.7640475560396 | -122.432761315556 | (37.7640475560396, -122.432761315556) | 15 | 4 | 5 | 28862 | 3 | ||||
| 62070 | 115256 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 277 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 773180 | 5995612.8 | 2091840.6 | 37.7235444201772 | -122.457305721784 | (37.7235444201772, -122.457305721784) | 9 | 8 | 4 | 28861 | 24 | |||
| 63488 | 81662 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 563 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5991577.12734 | 2111607.04314 | 37.7775853186785 | -122.472696706975 | (37.7775853186785, -122.472696706975) | 11 | 6 | 2 | 54 | 26 | |||
| 64837 | 253415 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 Stoneybrook Ave | Front Yard : Cutout | Tree | Private 2 | 08/31/2017 12:00:00 AM | 3 | Permit Number 779907 | 6005926.97731 | 2093972.42686 | 37.7299849530428 | -122.421802746417 | (37.7299849530428, -122.421802746417) | 9 | 7 | 6 | 28861 | 5 | |||
| 66307 | 47394 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 492 03rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/14/2002 12:00:00 AM | 2 | Permit Number 45308 | 5995008.66399 | 2112223.96074 | 37.7794772512056 | -122.460870672851 | (37.7794772512056, -122.460870672851) | 11 | 6 | 2 | 54 | 11 | |
| 66805 | 258499 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 379 Arleta Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 6009061.07772 | 2088406.01218 | 37.7148769915418 | -122.41057481256 | (37.7148769915418, -122.41057481256) | 9 | 7 | 8 | 309 | 39 | |||||
| 67350 | 56947 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 690 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | 5 | Permit Number 14199 | 6012986.78866 | 2103864.51855 | 37.7575421408828 | -122.398089663624 | (37.7575421408828, -122.398089663624) | 10 | 3 | 8 | 28856 | 29 | ||
| 68492 | 108093 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2501X 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 773081 | 6010203.41719 | 2105485.67353 | 37.7618380476045 | -122.40783004262 | (37.7618380476045, -122.40783004262) | 10 | 4 | 8 | 28859 | 19 | ||
| 73635 | 98412 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 19th Ave | 4 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||
| 73688 | 32337 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2626 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | 3 | Permit Number 36899 | 5995236.94633 | 2110306.39824 | 37.7742252654946 | -122.459942005265 | (37.7742252654946, -122.459942005265) | 11 | 6 | 2 | 54 | 11 | ||
| 76660 | 98411 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 19th Ave | 3 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||
| 78939 | 32526 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 871 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2015 12:00:00 AM | Permit Number 776214 | 6007576.4663397 | 2095282.92697428 | 37.7336761840288 | -122.416193025137 | (37.7336761840288, -122.416193025137) | 2 | 7 | 7 | 28859 | 2 | ||
| 79752 | 43146 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 243 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2015 12:00:00 AM | 1 | Permit Number 774635 | 6005976.40354 | 2092622.55461 | 37.7262812865364 | -122.421536041574 | (37.7262812865364, -122.421536041574) | 9 | 7 | 7 | 309 | 5 | |
| 79934 | 106843 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1869 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2014 12:00:00 AM | Permit Number 773317 | 6004088.44172 | 2118602.99638 | 37.7975107321666 | -122.429915018594 | (37.7975107321666, -122.429915018594) | 13 | 9 | 1 | 57 | 17 | |||
| 80013 | 38711 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2000 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2012 12:00:00 AM | 1 | Permit Number 768631 | 5999529.3553 | 2111223.7902 | 37.7769901198015 | -122.445159811212 | (37.7769901198015, -122.445159811212) | 15 | 5 | 11 | 29492 | 16 | ||
| 80624 | 98410 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 19th Ave | 2 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||
| 80677 | 114721 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788 | 37.7242419338513 | -122.405954818575 | (37.7242419338513, -122.405954818575) | 10 | 3 | 7 | 309 | 28 | |||
| 81489 | 45681 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 440 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2001 12:00:00 AM | 8 | Permit Number 44368 | 6014041.20893 | 2105068.96138 | 37.7609079516478 | -122.394527362641 | (37.7609079516478, -122.394527362641) | 10 | 3 | 8 | 28856 | 29 | ||
| 81645 | 47396 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 492 03rd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45308 | 5995005.9977 | 2112260.59137 | 37.7795776757203 | -122.46088255216 | (37.7795776757203, -122.46088255216) | 11 | 6 | 2 | 54 | 11 | |
| 81820 | 104632 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 323 Madrid St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2014 12:00:00 AM | 3 | Permit Number 773809 | 6003337.3 | 2091944.5 | 37.7242703388921 | -122.430610922244 | (37.7242703388921, -122.430610922244) | 9 | 7 | 6 | 28861 | 5 | |||
| 84525 | 30506 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3615 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1998 12:00:00 AM | 6 | Permit Number 40581 | 5997549.20453 | 2115073.94574 | 37.7874484120486 | -122.452287614306 | (37.7874484120486, -122.452287614306) | 11 | 6 | 1 | 54 | 31 | ||
| 84792 | 130969 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 95 Heather Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5997355.4901 | 2113891.63765 | 37.7841910082488 | -122.452872452398 | (37.7841910082488, -122.452872452398) | 15 | 6 | 1 | 54 | 31 | ||||
| 85859 | 258498 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 379 Arleta Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 6009061.07772 | 2088406.01218 | 37.7148769915418 | -122.41057481256 | (37.7148769915418, -122.41057481256) | 9 | 7 | 8 | 309 | 39 | |||||
| 87006 | 113267 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 83 Exeter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | 2 | Permit Number 774551 | 6012507.04437 | 2090789.37208 | 37.7216138123142 | -122.398831200496 | (37.7216138123142, -122.398831200496) | 10 | 3 | 8 | 58 | 1 | ||
| 89243 | 48772 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 766 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2002 12:00:00 AM | 2 | Permit Number 46029 | 5987276.54902 | 2110739.79263 | 37.7749542102717 | -122.487509936801 | (37.7749542102717, -122.487509936801) | 11 | 6 | 2 | 55 | 26 | ||
| 92756 | 52460 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 682@ CABRILLO 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 1 | Permit Number 48571 | 5992268.12798 | 2110826.06835 | 37.7754809489734 | -122.470249439229 | (37.7754809489734, -122.470249439229) | 11 | 6 | 2 | 54 | 11 | |
| 93223 | 41941 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 646 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 10 | Permit Number 42299 | 5994427.44449 | 2111105.89465 | 37.7763738805691 | -122.46280020914 | (37.7763738805691, -122.46280020914) | 11 | 6 | 2 | 54 | 11 | |
| 93952 | 50024 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1704 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 3 | Permit Number 46757 | 6005953.21642 | 2092396.45471 | 37.7256591580411 | -122.421600147046 | (37.7256591580411, -122.421600147046) | 9 | 7 | 7 | 309 | 5 | |
| 94209 | 32342 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 130 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | 1 | Permit Number 770451 | 6006450.26973 | 2105316.80145 | 37.7611635363022 | -122.420798725186 | (37.7611635363022, -122.420798725186) | 2 | 4 | 7 | 28859 | 19 | |
| 97176 | 106368 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 426 Country Club Dr | Sidewalk: Property side : Yard | Tree | Private 2 | 04/23/2014 12:00:00 AM | Permit Number 770073 | 5984817.1 | 2094918.3 | 37.731369010287 | -122.494850794258 | (37.731369010287, -122.494850794258) | 1 | 8 | 4 | 64 | 35 | ||||
| 98737 | 108845 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 420 Woolsey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010479.05335 | 2091857.99264 | 37.7244348155857 | -122.405916697196 | (37.7244348155857, -122.405916697196) | 10 | 3 | 7 | 309 | 28 | |
| 101232 | 107902 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 133 Elsie St | Front Yard : Yard | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | Permit Number 773996 | 6007164.40736 | 2098513.65139 | 37.742523860764 | -122.417846568545 | (37.742523860764, -122.417846568545) | 2 | 7 | 7 | 28859 | 2 | |||
| 104295 | 47397 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 492 03rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/14/2002 12:00:00 AM | 2 | Permit Number 45308 | 5995007.08219 | 2112241.09178 | 37.7795241974528 | -122.460877386845 | (37.7795241974528, -122.460877386845) | 11 | 6 | 2 | 54 | 11 | |
| 104340 | 60605 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 703 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/1983 12:00:00 AM | 5 | Permit Number 20227 | 6001028.5934 | 2111122.4037 | 37.7767971980591 | -122.439966224713 | (37.7767971980591, -122.439966224713) | 15 | 5 | 11 | 29492 | 41 | ||
| 105195 | 99584 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3599X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2013 12:00:00 AM | 6003014.6 | 2106437.9 | 37.7640475560396 | -122.432761315556 | (37.7640475560396, -122.432761315556) | 15 | 4 | 5 | 28862 | 3 | ||||
| 106540 | 130968 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 95 Heather Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5997356.68218 | 2113906.91877 | 37.7842330344764 | -122.452869431598 | (37.7842330344764, -122.452869431598) | 15 | 6 | 1 | 54 | 31 | ||||
| 107527 | 108843 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 420 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010519.10921 | 2091869.71455 | 37.7244692416558 | -122.405779054162 | (37.7244692416558, -122.405779054162) | 10 | 3 | 7 | 309 | 28 | |
| 111243 | 66134 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3259 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2011 12:00:00 AM | 3 | Permit Number 768243 | 5999299.78945 | 2120070.84719 | 37.8012687076388 | -122.446590621369 | (37.8012687076388, -122.446590621369) | 13 | 9 | 1 | 57 | 17 | ||
| 113734 | 38712 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2000 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2012 12:00:00 AM | 1 | Permit Number 768631 | 5999544.5843 | 2111225.8207 | 37.7769965642688 | -122.445107275598 | (37.7769965642688, -122.445107275598) | 15 | 5 | 11 | 29492 | 16 | ||
| 116185 | 52791 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 955@ MOSCOW Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 1 | Permit Number 48832 | 6004754.52241 | 2091271.39974 | 37.7225023397811 | -122.425663900979 | (37.7225023397811, -122.425663900979) | 9 | 7 | 6 | 28861 | 5 | ||
| 116678 | 31977 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 134 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 7 | Permit Number 35376 | 5995230.64434 | 2114664.73917 | 37.7861917443429 | -122.460279644251 | (37.7861917443429, -122.460279644251) | 11 | 6 | 1 | 54 | 11 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );