trees
305 rows where qSpecies_id = 49 sorted by PermitNotes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4238 | 193153 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 33 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2020 12:00:00 AM | 3 | Width 2ft | Permit Number 785449 | 6013826.51313 | 2114547.38647 | 37.7869216386586 | -122.395934124458 | (37.7869216386586, -122.395934124458) | 6 | 2 | 9 | 28855 | 6 | |
78395 | 132020 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1028 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782077 | 6007946.58222 | 2119968.79133 | 37.8014785977268 | -122.416661599167 | (37.8014785977268, -122.416661599167) | 5 | 1 | 10 | 308 | 32 | |
56180 | 255527 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 730 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782016 | 6003494.63141 | 2110038.24994 | 37.7739604525435 | -122.431358054188 | (37.7739604525435, -122.431358054188) | 15 | 9 | 11 | 29492 | 10 |
15309 | 16874 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 269 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781998 | 6005705.9301 | 2110300.3269 | 37.7748051262311 | -122.423727430112 | (37.7748051262311, -122.423727430112) | 7 | 9 | 11 | 28852 | 10 | |
132572 | 54713 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2701 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2018 12:00:00 AM | 3 | Permit Number 781936 | 6001165.76206 | 2116883.2589 | 37.7926228359235 | -122.43990487064 | (37.7926228359235, -122.43990487064) | 13 | 6 | 1 | 29490 | 27 | ||
47719 | 108874 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 138 Cole St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781829 | 5997812.45112 | 2110130.24113 | 37.773889369558 | -122.451020208331 | (37.773889369558, -122.451020208331) | 15 | 5 | 11 | 29492 | 16 | |
27287 | 255049 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 925 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779631 | 6009075.60356 | 2091383.60862 | 37.7230536656288 | -122.410734764023 | (37.7230536656288, -122.410734764023) | 9 | 3 | 7 | 309 | 28 | |
104688 | 117301 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2238 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778520 | 5985801.3 | 2099978.9 | 37.7453216318219 | -122.491820695636 | (37.7453216318219, -122.491820695636) | 1 | 8 | 3 | 29491 | 35 | ||
151715 | 117300 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2238 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778520 | 5985801.3 | 2099978.9 | 37.7453216318219 | -122.491820695636 | (37.7453216318219, -122.491820695636) | 1 | 8 | 3 | 29491 | 35 | ||
96348 | 115319 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 86 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | Permit Number 777439 | 6000946.9 | 2101238.5 | 37.7496537815844 | -122.439540113547 | (37.7496537815844, -122.439540113547) | 2 | 4 | 5 | 28862 | 22 | ||
29129 | 34304 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1248 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2016 12:00:00 AM | Permit Number 777415 | 6010821.325282 | 2102511.88817286 | 37.7537072691799 | -122.405483487001 | (37.7537072691799, -122.405483487001) | 10 | 4 | 8 | 28859 | 19 | ||
121448 | 115375 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 230 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776301 | 6007067.3 | 2096865.5 | 37.7379929380378 | -122.418065521541 | (37.7379929380378, -122.418065521541) | 2 | 7 | 7 | 28859 | 2 | ||
139355 | 114987 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 157 Thrift St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | Permit Number 775985 | 5995400.7 | 2089591.3 | 37.7173561925503 | -122.457876217939 | (37.7173561925503, -122.457876217939) | 9 | 8 | 6 | 28861 | 24 | |||
139324 | 115273 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1314 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775588 | 5985278.7 | 2106245.9 | 37.7624985311794 | -122.49408954164 | (37.7624985311794, -122.49408954164) | 1 | 8 | 3 | 56 | 35 | |||
102625 | 52820 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2850@ ANZA Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:00:00 PM | 3 | Permit Number 775537 | 5989777.02787 | 2111978.29339 | 37.778500303461 | -122.478950948669 | (37.778500303461, -122.478950948669) | 11 | 6 | 2 | 55 | 26 | ||
146964 | 52821 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2850@ ANZA Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:32:00 PM | 3 | Permit Number 775537 | 5989762.54787 | 2111977.16007 | 37.7784963508186 | -122.479000957003 | (37.7784963508186, -122.479000957003) | 11 | 6 | 2 | 55 | 26 | ||
77890 | 115285 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 32 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775365 | 6004721.1 | 2096171.8 | 37.7359558621574 | -122.426128127271 | (37.7359558621574, -122.426128127271) | 2 | 7 | 5 | 28861 | 2 | |||
74860 | 39178 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1050 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | 2 | 4 | 7 | 28859 | 19 | |
133579 | 39177 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1050 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | 2 | 4 | 7 | 28859 | 19 | |
90449 | 115264 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1634 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775141 | 5989384.4 | 2104210.4 | 37.7571489820097 | -122.479740639367 | (37.7571489820097, -122.479740639367) | 1 | 8 | 3 | 56 | 35 | |||
115784 | 115265 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1634 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775141 | 5989384.4 | 2104210.4 | 37.7571489820097 | -122.479740639367 | (37.7571489820097, -122.479740639367) | 1 | 8 | 3 | 56 | 35 | |||
7720 | 109781 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1335 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775057 | 5991737.5 | 2106325 | 37.7630915327801 | -122.471756892939 | (37.7630915327801, -122.471756892939) | 1 | 8 | 11 | 56 | 12 |
60765 | 109580 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 822 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 10:16:00 AM | 3 | 3x3 | Permit Number 775019 | 6004058.45374 | 2090883.76652 | 37.7213986270377 | -122.428042443214 | (37.7213986270377, -122.428042443214) | 9 | 7 | 6 | 28861 | 5 |
155215 | 109566 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 56 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775012 | 6000375.8 | 2089821 | 37.7182714712375 | -122.440696127295 | (37.7182714712375, -122.440696127295) | 9 | 7 | 6 | 28861 | 25 |
3337 | 261748 | Section 806 (d) 5 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 540 De Haro St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
11461 | 261747 | Section 806 (d) 5 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 540 De Haro St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
15024 | 261746 | Section 806 (d) 5 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 540 De Haro St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
185606 | 43588 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2014 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/2015 12:00:00 AM | 0 | Permit Number 774769 | 5986972.77982158 | 2101544.10082167 | 37.7496876538817 | -122.48788494443 | (37.7496876538817, -122.48788494443) | 1 | 8 | 3 | 29491 | 35 | |
160733 | 108628 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 741 Ellis St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774600 | 6007319.99858 | 2113650.90643 | 37.7840959912819 | -122.418381641984 | (37.7840959912819, -122.418381641984) | 7 | 9 | 9 | 28858 | 36 | |
42298 | 108621 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 150-198X Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 774592 | 6005405 | 2109611 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | 7 | 9 | 11 | 28852 | 10 | |
149431 | 18474 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1260 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | 0 | Permit Number 773798 | 6010545.83787 | 2101980.95756 | 37.7522340435672 | -122.406398781502 | (37.7522340435672, -122.406398781502) | 10 | 4 | 7 | 28859 | 19 |
7799 | 112881 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 634 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2015 12:00:00 AM | Permit Number 773545 | 5985072.5 | 2111537.7 | 37.7770162467569 | -122.495192953952 | (37.7770162467569, -122.495192953952) | 11 | 6 | 2 | 55 | 26 | |||
174483 | 108870 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 636 Lyon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773421 | 6000111.40758 | 2111064.83155 | 37.7765868652264 | -122.443134899814 | (37.7765868652264, -122.443134899814) | 15 | 5 | 11 | 29492 | 16 | |
104437 | 106758 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 445 Grafton Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | Permit Number 772911 | 5995409.1 | 2090523.2 | 37.7199154518997 | -122.457914582927 | (37.7199154518997, -122.457914582927) | 9 | 8 | 6 | 28861 | 24 | ||||
89203 | 108393 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 321 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772685 | 6006734.79675 | 2104244.32387 | 37.7582347949878 | -122.419738566409 | (37.7582347949878, -122.419738566409) | 2 | 4 | 7 | 28859 | 19 |
47271 | 106182 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 26 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2014 12:00:00 AM | 9 | Permit Number 772520 | 5996564.2 | 2114395.4 | 37.7855288291914 | -122.455646443632 | (37.7855288291914, -122.455646443632) | 11 | 6 | 1 | 54 | 31 | ||
175364 | 115252 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 438 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 772344 | 5995084 | 2088641.7 | 37.7147306151804 | -122.458902180491 | (37.7147306151804, -122.458902180491) | 9 | 8 | 6 | 28861 | 24 | |||
143429 | 108627 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 223 Douglass St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772318 | 6001122.48631 | 2104986.51759 | 37.7599549235553 | -122.439201532761 | (37.7599549235553, -122.439201532761) | 2 | 4 | 5 | 28862 | 3 | |
192201 | 84013 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 207 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 771913 | 5997093.91103174 | 2089409.10522836 | 37.7169530610701 | -122.452010468882 | (37.7169530610701, -122.452010468882) | 9 | 8 | 6 | 28861 | 24 | ||
81653 | 109448 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 143 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770854 | 6005451.2 | 2102876.8 | 37.7544075015735 | -122.424080557223 | (37.7544075015735, -122.424080557223) | 2 | 4 | 5 | 28859 | 19 |
148083 | 104967 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 143-147 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | Permit Number 770854 | 6005451.2 | 2102876.8 | 37.7544075015735 | -122.424080557223 | (37.7544075015735, -122.424080557223) | 2 | 4 | 5 | 28859 | 19 | ||
73814 | 99874 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 770597 | 6003616.3 | 2095455.7 | 37.7339271085192 | -122.429896797189 | (37.7339271085192, -122.429896797189) | 2 | 7 | 5 | 28861 | 25 |
156269 | 8129 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 899 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2013 12:00:00 AM | 12 | 3X3 | Permit Number 770378 | 6003470.39544 | 2111382.10126 | 37.7776489625125 | -122.431537848369 | (37.7776489625125, -122.431537848369) | 7 | 9 | 11 | 29492 | 10 | |
174012 | 101369 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2007 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769245 | 5999888.5 | 2111553 | 37.7779145386147 | -122.443941082049 | (37.7779145386147, -122.443941082049) | 15 | 5 | 11 | 29490 | 16 | |
32707 | 100007 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501X Mission St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.7897060631976 | -122.397547983339 | (37.7897060631976, -122.397547983339) | 12 | 2 | 9 | 28855 | 6 | |||
35004 | 100003 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501X Mission St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.7897060631976 | -122.397547983339 | (37.7897060631976, -122.397547983339) | 12 | 2 | 9 | 28855 | 6 | |||
52174 | 99998 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501X Mission St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013420 | 2115433 | 37.7893307029327 | -122.397402707509 | (37.7893307029327, -122.397402707509) | 12 | 2 | 9 | 28855 | 6 | |||
88404 | 100008 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501X Mission St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.7897060631976 | -122.397547983339 | (37.7897060631976, -122.397547983339) | 12 | 2 | 9 | 28855 | 6 | |||
109946 | 64806 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1375 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2012 12:00:00 AM | 22 | 5x5 | Permit Number 768180 | 6003293.30156995 | 2100236.74825313 | 37.747036468941 | -122.43135467592 | (37.747036468941, -122.43135467592) | 2 | 7 | 5 | 63 | 22 |
187255 | 54682 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1212 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2011 12:00:00 AM | Permit Number 767886 | 5993014.13432891 | 2107214.38358529 | 37.7656073275163 | -122.467406160634 | (37.7656073275163, -122.467406160634) | 11 | 8 | 11 | 56 | 12 | |||
192982 | 96632 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1212 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2011 12:00:00 AM | Permit Number 767886 | 5993035.2 | 2107183.3 | 37.7655231963247 | -122.467331039359 | (37.7655231963247, -122.467331039359) | 11 | 8 | 11 | 56 | 12 | |||
21662 | 81651 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1100@ 12th Ave Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | Permit Number 767881 | 5992197.33713 | 2110704.35062 | 37.7751426520596 | -122.470485452724 | (37.7751426520596, -122.470485452724) | 11 | 6 | 2 | 54 | 11 | ||
31727 | 45656 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2011 12:00:00 AM | Permit Number 767754 | 5994244 | 2106639 | 37.7640983993107 | -122.463110607355 | (37.7640983993107, -122.463110607355) | 1 | 5 | 11 | 56 | 12 | |||
103176 | 54058 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2011 12:00:00 AM | Permit Number 767754 | 5994238.69785688 | 2106641.55496777 | 37.7641051091536 | -122.463129131181 | (37.7641051091536, -122.463129131181) | 1 | 5 | 11 | 56 | 12 | |||
167902 | 45655 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2011 12:00:00 AM | Permit Number 767754 | 5994244 | 2106639 | 37.7640983993107 | -122.463110607355 | (37.7640983993107, -122.463110607355) | 1 | 5 | 11 | 56 | 12 | |||
188069 | 95808 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 974 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767552 | 6011863.56882 | 2103875.82821 | 37.7575105701687 | -122.401975028944 | (37.7575105701687, -122.401975028944) | 10 | 3 | 8 | 28856 | 29 |
49718 | 93670 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 12 Robblee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 54071 | 6012650.87025 | 2095997.96753 | 37.7359235585191 | -122.398699370703 | (37.7359235585191, -122.398699370703) | 10 | 3 | 8 | 58 | 1 | |
134063 | 62821 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 165 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2010 12:00:00 AM | 3x3 | Permit Number 53769 | 6004060.48554268 | 2101568.78877881 | 37.7507373914484 | -122.42879676445 | (37.7507373914484, -122.42879676445) | 2 | 4 | 5 | 28862 | 22 | ||
155192 | 50070 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 178 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53758 | 6003140.05481803 | 2105079.35140699 | 37.7603244234929 | -122.432230375273 | (37.7603244234929, -122.432230375273) | 2 | 4 | 5 | 28862 | 3 | |
189972 | 17872 | Section 143 10 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2148 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/21/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53638 | 6003654.7045158 | 2115269.5781823 | 37.7883334451781 | -122.431177809024 | (37.7883334451781, -122.431177809024) | 13 | 9 | 1 | 29490 | 27 |
129187 | 94327 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1132 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2010 12:00:00 AM | 3x3 | Permit Number 53627 | 5995101.4 | 2091446 | 37.7224315574184 | -122.459044970295 | (37.7224315574184, -122.459044970295) | 9 | 8 | 4 | 28861 | 24 | ||
191716 | 56557 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 27 Ardenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2010 12:00:00 AM | Permit Number 53358 | 5991301.89931547 | 2096270.47961182 | 37.7354592201324 | -122.472530401662 | (37.7354592201324, -122.472530401662) | 1 | 8 | 4 | 29491 | 40 | |||
73843 | 93629 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 251 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2010 12:00:00 AM | 3x3 | Permit Number 53264 | 5985797 | 2114222 | 37.7844289534299 | -122.492884487425 | (37.7844289534299, -122.492884487425) | 11 | 6 | 1 | 55 | 33 | ||
185674 | 82560 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 832 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52208 | 6009084.37207289 | 2104307.27777207 | 37.7585397298832 | -122.411617128308 | (37.7585397298832, -122.411617128308) | 2 | 4 | 7 | 28859 | 19 | ||
144083 | 88518 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 133 Kenwood Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51449 | 5994469.5 | 2093573.6 | 37.7282370866894 | -122.46138344933 | (37.7282370866894, -122.46138344933) | 9 | 8 | 4 | 59 | 40 | |||
193859 | 84342 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1153 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50832 | 6005241.68146 | 2120923.06914 | 37.8039462987346 | -122.426089751557 | (37.8039462987346, -122.426089751557) | 13 | 9 | 1 | 28858 | 17 | |
54675 | 87806 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 291 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3 | 3x12 | Permit Number 50584 | 5987096.8 | 2114028.5 | 37.7839735823988 | -122.48837346173 | (37.7839735823988, -122.48837346173) | 11 | 6 | 1 | 55 | 33 | |
60679 | 87807 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 291 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50584 | 5987096.8 | 2114028.5 | 37.7839735823988 | -122.48837346173 | (37.7839735823988, -122.48837346173) | 11 | 6 | 1 | 55 | 33 | |
666 | 49628 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1591 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2003 12:00:00 AM | 3 | Permit Number 46483 | 6007746.40275 | 2109230.16933 | 37.7719816997133 | -122.416593168865 | (37.7719816997133, -122.416593168865) | 8 | 2 | 9 | 28853 | 19 | |
7352 | 49629 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1591 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2003 12:00:00 AM | 3 | Permit Number 46483 | 6007726.58715 | 2109200.55407 | 37.7718992687552 | -122.416659614369 | (37.7718992687552, -122.416659614369) | 8 | 2 | 9 | 28853 | 19 | |
6816 | 46977 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1310 Minnesota St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44998 | 6015323.66021 | 2102361.18474 | 37.7535441867291 | -122.389902741142 | (37.7535441867291, -122.389902741142) | 10 | 3 | 8 | 28856 | 29 | ||
126697 | 46981 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1310 Minnesota St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 1 | Permit Number 44998 | 6015319.9852 | 2102418.03165 | 37.7537000725041 | -122.389919420856 | (37.7537000725041, -122.389919420856) | 10 | 3 | 8 | 28856 | 29 | ||
175179 | 46980 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1310 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44998 | 6015320.43653 | 2102435.84562 | 37.7537490109239 | -122.389919104308 | (37.7537490109239, -122.389919104308) | 10 | 3 | 8 | 28856 | 29 | ||
49816 | 46416 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 700 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015974.86179 | 2105759.18936 | 37.7629104774528 | -122.387887811877 | (37.7629104774528, -122.387887811877) | 10 | 3 | 8 | 28856 | 29 | |
143820 | 46415 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 700 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015975.28241 | 2105780.03754 | 37.7629677453768 | -122.3878878119 | (37.7629677453768, -122.3878878119) | 10 | 3 | 8 | 28856 | 29 | |
136676 | 43256 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 400 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/12/2000 12:00:00 AM | 5 | Permit Number 43041 | 6010098.35132 | 2093185.30376 | 37.7280580348411 | -122.407326264919 | (37.7280580348411, -122.407326264919) | 10 | 3 | 7 | 309 | 28 | |
100823 | 37947 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 255 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40187 | 6013212.35398 | 2105880.56458 | 37.7630903220716 | -122.39745094713 | (37.7630903220716, -122.39745094713) | 14 | 3 | 8 | 28856 | 29 | |
192615 | 37946 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 255 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 6 | Permit Number 40187 | 6013211.43951 | 2105863.92108 | 37.7630445717758 | -122.397452942701 | (37.7630445717758, -122.397452942701) | 14 | 3 | 8 | 28856 | 29 | |
42544 | 37824 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 450X Moscow St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003906.75378 | 2090460.71651 | 37.7202284408775 | -122.428536688136 | (37.7202284408775, -122.428536688136) | 9 | 7 | 6 | 28861 | 5 |
49364 | 35383 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 557 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 6 | Permit Number 38839 | 6011254.22436 | 2105785.28099 | 37.7627194740588 | -122.4042167852 | (37.7627194740588, -122.4042167852) | 8 | 3 | 8 | 28856 | 29 | |
128026 | 35331 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2222 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38797 | 6011102.74031 | 2105580.11017 | 37.7621476554073 | -122.404726272704 | (37.7621476554073, -122.404726272704) | 8 | 3 | 8 | 28856 | 29 | |
82789 | 67599 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 380 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1992 12:00:00 AM | 5 | Permit Number 31168 | 6014306.36915 | 2105365.66412 | 37.7617373703071 | -122.393631049748 | (37.7617373703071, -122.393631049748) | 10 | 3 | 8 | 28856 | 29 | |
69262 | 58794 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2125 BRYANT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/1979 12:00:00 AM | Permit Number 18041 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |||
79191 | 55909 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 3020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Permit Number 11967 | 5986171.45599 | 2111171.12387 | 37.7760740114518 | -122.491364390312 | (37.7760740114518, -122.491364390312) | 11 | 6 | 2 | 55 | 26 | ||
102 | 258152 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 500X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | |||||||||||||
979 | 171867 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 825 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Width 3ft | 6009309.97305 | 2091452.93347 | 37.7232571551673 | -122.409929483882 | (37.7232571551673, -122.409929483882) | 9 | 3 | 7 | 309 | 28 | ||
1355 | 172161 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 224 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6010825.0191 | 2091483.87945 | 37.7234269210881 | -122.404694409734 | (37.7234269210881, -122.404694409734) | 10 | 3 | 7 | 309 | 28 | |||
2615 | 193428 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1151 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014491.22334 | 2103857.32403 | 37.7576060646987 | -122.392886177259 | (37.7576060646987, -122.392886177259) | 10 | 3 | 8 | 28856 | 29 | |||
2698 | 216704 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 251 Faxon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 08:35:00 AM | 3 | Width 2ft | 5994715.27121 | 2090263.18688 | 37.7191616308917 | -122.460294062627 | (37.7191616308917, -122.460294062627) | 9 | 8 | 6 | 28861 | 24 | ||
2951 | 258117 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 601 Brussels St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010889.02957 | 2091945.92933 | 37.724699191929 | -122.404505645081 | (37.724699191929, -122.404505645081) | 10 | 3 | 7 | 309 | 28 | ||
3314 | 193435 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600 Missouri St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6013537.44197 | 2104295.86136 | 37.7587571690323 | -122.396215498963 | (37.7587571690323, -122.396215498963) | 10 | 3 | 8 | 28856 | 29 | |||
3354 | 258363 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 526 Silliman St | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009244.29167 | 2093882.64592 | 37.7299249505577 | -122.410328004922 | (37.7299249505577, -122.410328004922) | 9 | 3 | 7 | 309 | 28 | ||||
3543 | 258123 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 601 Brussels St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010889.02957 | 2091945.92933 | 37.724699191929 | -122.404505645081 | (37.724699191929, -122.404505645081) | 10 | 3 | 7 | 309 | 28 | ||
3712 | 171727 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1151 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6007391.28997 | 2093272.37114 | 37.7281452205055 | -122.416690852302 | (37.7281452205055, -122.416690852302) | 9 | 3 | 7 | 309 | 5 | ||
3719 | 258151 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 500X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | |||||||||||||
3933 | 258362 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 520 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009260.75409 | 2093887.69259 | 37.7299397304564 | -122.410271448334 | (37.7299397304564, -122.410271448334) | 9 | 3 | 7 | 309 | 28 | ||||
5082 | 258116 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2245 Jones St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6008057.63672 | 2120117.2159 | 37.8018923796488 | -122.416287818099 | (37.8018923796488, -122.416287818099) | 5 | 1 | 10 | 308 | 32 | ||||
5303 | 254848 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 914 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x5 | 5999583 | 2111627 | 37.7781002923949 | -122.445003231417 | (37.7781002923949, -122.445003231417) | 15 | 5 | 11 | 29490 | 16 | |||
5799 | 29248 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 470X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6010243.1599 | 2097486.61497 | 37.7398766239144 | -122.40712872252 | (37.7398766239144, -122.40712872252) | 10 | 3 | 7 | 58 | 2 | ||
6295 | 258118 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 601 Brussels St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010889.02957 | 2091945.92933 | 37.724699191929 | -122.404505645081 | (37.724699191929, -122.404505645081) | 10 | 3 | 7 | 309 | 28 |
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) );