trees
305 rows where qSpecies_id = 49 sorted by SiteOrder 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 75137 | 193419 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 610 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015956.40459 | 2106139.49843 | 37.7639537018206 | -122.387978189259 | (37.7639537018206, -122.387978189259) | 14 | 3 | 8 | 28856 | 29 | |||
| 75169 | 193432 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 572 Missouri St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6013532.898 | 2104416.89533 | 37.7590892490991 | -122.396239697014 | (37.7590892490991, -122.396239697014) | 10 | 3 | 8 | 28856 | 29 | |||
| 80556 | 230423 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 387 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007832.95914 | 2105672.86461 | 37.7622190400112 | -122.416041797198 | (37.7622190400112, -122.416041797198) | 8 | 4 | 7 | 28859 | 19 | |||
| 87561 | 93246 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 990 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369 | 2103119 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | 2 | 4 | 5 | 28862 | 22 | ||
| 91411 | 230405 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010473.72719 | 2104680.02328 | 37.7596410425128 | -122.406838360202 | (37.7596410425128, -122.406838360202) | 10 | 4 | 8 | 28859 | 19 | |||
| 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 | |
| 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 | ||
| 106536 | 252993 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 107920 | 251756 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 233 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001887 | 2086528 | 37.7093155646434 | -122.43523714505 | (37.7093155646434, -122.43523714505) | 9 | 7 | 6 | 28861 | 5 | ||||
| 109916 | 230413 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 310 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2016 08:33:00 AM | 1 | Width 7ft | 6004826.22566 | 2106515.98799 | 37.7643645463025 | -122.426500991746 | (37.7643645463025, -122.426500991746) | 8 | 4 | 5 | 28859 | 3 | ||
| 109949 | 117154 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014461.75742 | 2103731.13458 | 37.757257938912 | -122.3929792544 | (37.757257938912, -122.3929792544) | 10 | 3 | 8 | 28856 | 29 | |||
| 113355 | 93239 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004217.7 | 2105335.5 | 37.761088789181 | -122.428521561971 | (37.761088789181, -122.428521561971) | 2 | 4 | 5 | 28862 | 3 | ||
| 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 | |||
| 124024 | 177454 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1651 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001501.63972 | 2094151.35591 | 37.7302256977428 | -122.43711445329 | (37.7302256977428, -122.43711445329) | 9 | 7 | 6 | 28861 | 25 | |||
| 127114 | 251755 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 201X Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 11:50:00 AM | 3 | 3x3 | 6002020 | 2086565 | 37.7094247104414 | -122.434780120464 | (37.7094247104414, -122.434780120464) | 9 | 7 | 6 | 28861 | 5 | ||
| 135873 | 193409 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 551 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010674.14728 | 2105512.66894 | 37.7619385126714 | -122.406203867837 | (37.7619385126714, -122.406203867837) | 10 | 4 | 8 | 28859 | 19 | |||
| 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 | |
| 141793 | 94257 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2777X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.409573390285 | (37.7597963985886, -122.409573390285) | 2 | 4 | 8 | 28859 | 19 | |||
| 144366 | 123782 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1100 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992174.17281 | 2110703.76964 | 37.7751397174253 | -122.470565540203 | (37.7751397174253, -122.470565540203) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | ||
| 153197 | 230396 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 675 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010452.66825 | 2105159.82839 | 37.7609573010551 | -122.406945010817 | (37.7609573010551, -122.406945010817) | 10 | 4 | 8 | 28859 | 19 | |||
| 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 |
| 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 | |
| 160673 | 18475 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1260 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2013 12:00:00 AM | 3 | 3x3 | 6010550.21333 | 2101942.07688 | 37.7521275305728 | -122.406380911075 | (37.7521275305728, -122.406380911075) | 10 | 4 | 7 | 28859 | 19 | ||
| 166488 | 193413 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2200 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011171.17043 | 2105584.01117 | 37.7621621911485 | -122.404489872412 | (37.7621621911485, -122.404489872412) | 8 | 3 | 8 | 28856 | 29 | |||
| 167252 | 193415 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1425 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6015129.4675 | 2101818.79874 | 37.7520441382513 | -122.390536410622 | (37.7520441382513, -122.390536410622) | 10 | 3 | 8 | 28856 | 1 | |||
| 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 | |||
| 169178 | 78830 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 35 Laura St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/2017 04:01:00 PM | 3 | 5997431.0713 | 2086896.39523 | 37.7100730444948 | -122.450664016958 | (37.7100730444948, -122.450664016958) | 9 | 7 | 6 | 28861 | 25 | ||
| 172302 | 230416 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003629.87373 | 2095518.06271 | 37.7340991110765 | -122.429854315422 | (37.7340991110765, -122.429854315422) | 2 | 7 | 5 | 28861 | 25 | |||
| 180617 | 101611 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 681 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 6011008.34199 | 2105144.37638 | 37.7609459516243 | -122.40502208042 | (37.7609459516243, -122.40502208042) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 |
| 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 | ||
| 38581 | 29817 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1695X Evans Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 128424 | 230404 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 995 Potrero Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010493.00859 | 2104414.71875 | 37.7589136546545 | -122.406752977672 | (37.7589136546545, -122.406752977672) | 10 | 4 | 8 | 28859 | 19 | |||
| 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 |
| 93417 | 94253 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2125 BRYANT ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |||
| 179340 | 253003 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 10331 | 128078 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 245 North Point St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:25:00 PM | 3 | Width 4ft | 6009589.18536 | 2121879.68336 | 37.8068176775527 | -122.411112486276 | (37.8068176775527, -122.411112486276) | 3 | 1 | 10 | 308 | 23 | ||
| 19186 | 261345 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Columbus Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2020 02:12:00 PM | 3 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | 3 | 1 | 10 | 308 | 23 | ||
| 146871 | 253002 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 19221 | 4665 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Columbus Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2020 02:10:00 PM | 3 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | 3 | 1 | 10 | 308 | 23 | ||
| 35901 | 94252 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2125 BRYANT ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |||
| 104540 | 143848 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2900 Balboa St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5986608 | 2111175 | 37.7761101535306 | -122.489854574072 | (37.7761101535306, -122.489854574072) | 11 | 6 | 2 | 55 | 26 | ||
| 136380 | 230403 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 995 Potrero Ave | 10 | : | Tree | Private 2 | 4 | Width 2ft | 6010508.06667 | 2104211.71419 | 37.7583570921231 | -122.406686593337 | (37.7583570921231, -122.406686593337) | 10 | 4 | 8 | 28859 | 19 | |||
| 139187 | 202028 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 10 | : | Tree | Private 2 | 3 | Width 3ft | 6013610.79633 | 2091351.15014 | 37.7232177810632 | -122.395055126189 | (37.7232177810632, -122.395055126189) | 10 | 3 | 8 | 58 | 1 | |||
| 160987 | 253001 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |||
| 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 | |||||||||||||
| 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 | |
| 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 | ||
| 6939 | 177453 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1651 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001481.52618 | 2094146.78927 | 37.7302120154671 | -122.437183661494 | (37.7302120154671, -122.437183661494) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |
| 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 |
| 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 | |||
| 9834 | 166214 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 3066 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6009114.2324 | 2101605.68016 | 37.7511234258036 | -122.411323007657 | (37.7511234258036, -122.411323007657) | 2 | 4 | 7 | 28859 | 19 | |||
| 11491 | 160766 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 695 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6003187.32082 | 2089217.65008 | 37.7167745145126 | -122.430934858059 | (37.7167745145126, -122.430934858059) | 9 | 7 | 6 | 28861 | 5 | |||
| 12735 | 216702 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 251 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 08:30:00 AM | 3 | Width 2ft | 5994715.94794 | 2090284.84641 | 37.7192211417229 | -122.460293291913 | (37.7192211417229, -122.460293291913) | 9 | 8 | 6 | 28861 | 24 | ||
| 14386 | 160654 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 527 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2017 12:00:00 AM | 3 | 3x3 | 6001557.28645 | 2090682.81807 | 37.7207050428777 | -122.436673891586 | (37.7207050428777, -122.436673891586) | 9 | 7 | 6 | 28861 | 5 | ||
| 14395 | 258175 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 221 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x4 | 6010133.63921 | 2094113.44484 | 37.7306084895202 | -122.40726967409 | (37.7306084895202, -122.40726967409) | 10 | 3 | 7 | 309 | 28 | ||
| 14623 | 171726 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1151 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6007369.69842 | 2093265.62582 | 37.7281254849051 | -122.416765017588 | (37.7281254849051, -122.416765017588) | 9 | 3 | 7 | 309 | 5 | ||
| 15123 | 171866 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 845 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Width 3ft | 6009218.01961 | 2091423.53982 | 37.7231712923965 | -122.410245276296 | (37.7231712923965, -122.410245276296) | 9 | 3 | 7 | 309 | 28 | ||
| 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 | |
| 15663 | 117153 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6014462.23102 | 2103712.78244 | 37.757207574192 | -122.392976332502 | (37.757207574192, -122.392976332502) | 10 | 3 | 8 | 28856 | 29 | |||
| 15803 | 150046 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 790 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 6015435.45037 | 2105401.72927 | 37.7618990720098 | -122.389728496571 | (37.7618990720098, -122.389728496571) | 10 | 3 | 8 | 28856 | 29 | |||
| 16233 | 258379 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1139 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007502.57934 | 2093306.87278 | 37.728246213244 | -122.416308562579 | (37.728246213244, -122.416308562579) | 9 | 3 | 7 | 309 | 5 | |||
| 16517 | 162307 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 757 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6010810.72096 | 2091174.85054 | 37.7225775923629 | -122.404722090874 | (37.7225775923629, -122.404722090874) | 10 | 3 | 7 | 309 | 28 | |||
| 20891 | 93298 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 869 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004381 | 2103841 | 37.7569944861757 | -122.427850284713 | (37.7569944861757, -122.427850284713) | 2 | 4 | 5 | 28862 | 3 | ||
| 21263 | 18341 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 425 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2014 12:00:00 AM | 3 | 3x3 | 6010391.567 | 2106310.47571 | 37.7641132991006 | -122.407237448759 | (37.7641132991006, -122.407237448759) | 8 | 4 | 8 | 28859 | 19 | ||
| 21356 | 193433 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 588 Missouri St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6013536.39974 | 2104342.74788 | 37.758885851209 | -122.396222389564 | (37.758885851209, -122.396222389564) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 24838 | 230411 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2901 Cesar Chavez St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6010009.79778 | 2100525.6899 | 37.7482081987543 | -122.408149874844 | (37.7482081987543, -122.408149874844) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||
| 30060 | 193438 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 170 Scotia Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012250.26105 | 2094642.58391 | 37.7321796295918 | -122.399989292576 | (37.7321796295918, -122.399989292576) | 10 | 3 | 8 | 58 | 1 | |||
| 31136 | 93244 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 910X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004315 | 2103566.4 | 37.7562367654726 | -122.428058969621 | (37.7562367654726, -122.428058969621) | 2 | 4 | 5 | 28862 | 22 | ||
| 36606 | 160510 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 706 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:18:00 PM | 3 | Width 0ft | 6001927.69711 | 2089831.31409 | 37.7183880466434 | -122.435332621096 | (37.7183880466434, -122.435332621096) | 9 | 7 | 6 | 28861 | 5 | |
| 37230 | 208859 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 157 Thrift St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995398.10832 | 2089609.60714 | 37.7174063107347 | -122.457886500157 | (37.7174063107347, -122.457886500157) | 9 | 8 | 6 | 28861 | 24 | |||
| 38708 | 230420 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 143 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005428.86473 | 2102882.34915 | 37.7544214771723 | -122.424158193041 | (37.7544214771723, -122.424158193041) | 2 | 4 | 5 | 28859 | 19 | |||
| 40221 | 193426 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 807 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015414.46793 | 2103902.85001 | 37.7577823075377 | -122.389696374594 | (37.7577823075377, -122.389696374594) | 10 | 3 | 8 | 28856 | 29 | |||
| 40245 | 180646 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 451 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 6ft | 6002230.18825 | 2087673.61332 | 37.7124806510226 | -122.434132874236 | (37.7124806510226, -122.434132874236) | 9 | 7 | 6 | 28861 | 5 | |||
| 40989 | 5473 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 601 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2016 05:56:00 AM | 3 | 4X4 | 6005007.93466 | 2104733.32137 | 37.7594800368996 | -122.425745616993 | (37.7594800368996, -122.425745616993) | 2 | 4 | 5 | 28859 | 19 | ||
| 44046 | 230395 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 675 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010455.48203 | 2105111.38251 | 37.7608244370314 | -122.406931864509 | (37.7608244370314, -122.406931864509) | 10 | 4 | 8 | 28859 | 19 | |||
| 45560 | 93296 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 999X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004559.2 | 2103505.3 | 37.7560828122733 | -122.427210089969 | (37.7560828122733, -122.427210089969) | 2 | 4 | 5 | 28862 | 22 | ||
| 46204 | 251736 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 8 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 11:28:00 AM | 3 | 3x3 | 6002228 | 2087184 | 37.7111361560163 | -122.434105459048 | (37.7111361560163, -122.434105459048) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | ||
| 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 | |
| 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 | |
| 50257 | 193431 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 568 Missouri St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6013531.88693 | 2104447.0848 | 37.7591720865425 | -122.396245309678 | (37.7591720865425, -122.396245309678) | 10 | 3 | 8 | 28856 | 29 | |||
| 51035 | 89723 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1535 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 11:16:00 AM | 3 | 3x3 | 5993886.8268 | 2112071.32228 | 37.7789935335335 | -122.464740465973 | (37.7789935335335, -122.464740465973) | 11 | 6 | 2 | 54 | 11 | ||
| 52022 | 131012 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1661 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006845.95984 | 2116366.0433 | 37.7915243922801 | -122.420214413174 | (37.7915243922801, -122.420214413174) | 13 | 9 | 10 | 28858 | 21 | |||
| 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 | |||
| 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 | |
| 55581 | 18458 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1136 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2006 12:00:00 AM | 3 | 4X4 | 6010508.18213 | 2102591.02821 | 37.7539070559711 | -122.406571988228 | (37.7539070559711, -122.406571988228) | 10 | 4 | 7 | 28859 | 19 | ||
| 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 |
| 57776 | 18381 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 768 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010390.09454 | 2104720.536 | 37.7597476013854 | -122.407130460918 | (37.7597476013854, -122.407130460918) | 10 | 4 | 8 | 28859 | 19 |
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) );