Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16499 | 16499 | 25480 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2006 12:00:00 AM | 3 | 3x3 | 6010409.92318 | 2105901.91388 | 37.7629925082126 | -122.407145158522 | (37.7629925082126, -122.407145158522) | ||
| 16826 | 16826 | 18350 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 459 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2015 06:59:00 AM | 3 | 3x3 | 6010395.85662 | 2106161.99214 | 37.7637058369709 | -122.40721214454099 | (37.7637058369709, -122.407212144541) | ||
| 17958 | 17958 | 18458 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1136 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2006 12:00:00 AM | 3 | 4X4 | 6010508.182130001 | 2102591.0282099997 | 37.753907055971105 | -122.406571988228 | (37.7539070559711, -122.406571988228) | ||
| 18206 | 18206 | 5473 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 601 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2016 05:56:00 AM | 3 | 4X4 | 6005007.93466 | 2104733.32137 | 37.7594800368996 | -122.42574561699301 | (37.7594800368996, -122.425745616993) | ||
| 18510 | 18510 | 27621 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1143 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010597.97715 | 2102516.5515099997 | 37.7537075827479 | -122.406256207463 | (37.7537075827479, -122.406256207463) | ||
| 20449 | 20449 | 18472 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1245 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2015 07:25:00 AM | 3 | 3X3 | 6010625.30786 | 2102050.90235 | 37.7524305418599 | -122.406128887762 | (37.7524305418599, -122.406128887762) | ||
| 20610 | 20610 | 109781 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1335 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775057 | 5991737.5 | 2106325.0 | 37.7630915327801 | -122.471756892939 | (37.7630915327801, -122.471756892939) |
| 21177 | 21177 | 18475 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1260 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2013 12:00:00 AM | 3 | 3x3 | 6010550.213330001 | 2101942.07688 | 37.75212753057279 | -122.406380911075 | (37.7521275305728, -122.406380911075) | ||
| 21253 | 21253 | 18474 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1260 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 0 | Permit Number 773798 | 6010545.83787 | 2101980.95756 | 37.752234043567206 | -122.406398781502 | (37.7522340435672, -122.406398781502) |
| 21711 | 21711 | 18473 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1255 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/2013 12:00:00 AM | 3 | 3x3 | 6010628.31505 | 2101997.99365 | 37.7522854344497 | -122.40611476119301 | (37.7522854344497, -122.406114761193) | ||
| 21944 | 21944 | 18455 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1115 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2015 12:46:00 PM | 3 | 3X3 | 6010591.726009999 | 2102631.1286299997 | 37.754021836464794 | -122.406285897673 | (37.7540218364648, -122.406285897673) | ||
| 34840 | 34840 | 230415 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003663.13723 | 2095538.7313 | 37.7341577459882 | -122.429740786804 | (37.7341577459882, -122.429740786804) | |||
| 35864 | 35864 | 202028 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013610.79633 | 2091351.15014 | 37.723217781063205 | -122.395055126189 | (37.7232177810632, -122.395055126189) | |||
| 37611 | 37611 | 230424 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 387 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007831.12637 | 2105698.0394200003 | 37.76228806116921 | -122.41604991899099 | (37.7622880611692, -122.416049918991) | |||
| 44609 | 44609 | 193420 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015798.54633 | 2105794.6845 | 37.76299817034379 | -122.38850010901001 | (37.7629981703438, -122.38850010901) | |||
| 50998 | 50998 | 202024 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013681.0358 | 2091298.8599 | 37.7230781082384 | -122.394808659817 | (37.7230781082384, -122.394808659817) | |||
| 54038 | 54038 | 202020 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013858.20959 | 2091166.1399 | 37.7227235352339 | -122.39418691350599 | (37.7227235352339, -122.394186913506) | |||
| 57863 | 57863 | 230414 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1295 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003749.35106 | 2095592.3419599999 | 37.7343098303216 | -122.429446540326 | (37.7343098303216, -122.429446540326) | |||
| 59900 | 59900 | 84342 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1153 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50832 | 6005241.68146 | 2120923.0691400003 | 37.8039462987346 | -122.426089751557 | (37.8039462987346, -122.426089751557) | |
| 61446 | 61446 | 230417 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003609.08364 | 2095506.47935 | 37.7340661284367 | -122.42992536726801 | (37.7340661284367, -122.429925367268) | |||
| 69513 | 69513 | 202022 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013717.54523 | 2091271.8320400002 | 37.723005925068605 | -122.39468056126199 | (37.7230059250686, -122.394680561262) | |||
| 70356 | 70356 | 193410 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 551 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010705.60274 | 2105553.4377099997 | 37.762052213957794 | -122.40609794748501 | (37.7620522139578, -122.406097947485) | |||
| 75391 | 75391 | 230416 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003629.87373 | 2095518.0627099997 | 37.734099111076496 | -122.429854315422 | (37.7340991110765, -122.429854315422) | |||
| 79139 | 79139 | 108621 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 150-198X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 774592 | 6005405.0 | 2109611.0 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | |
| 80702 | 80702 | 29817 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1695X Evans Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.74391708243721 | -122.39024991836901 | (37.7439170824372, -122.390249918369) | ||
| 81640 | 81640 | 87806 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 291 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3 | 3x12 | Permit Number 50584 | 5987096.8 | 2114028.5 | 37.783973582398794 | -122.48837346173 | (37.7839735823988, -122.48837346173) | |
| 81669 | 81669 | 117300 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2238 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778520 | 5985801.3 | 2099978.9 | 37.7453216318219 | -122.49182069563601 | (37.7453216318219, -122.491820695636) | ||
| 83398 | 83398 | 93296 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 999X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004559.2 | 2103505.3 | 37.7560828122733 | -122.42721008996901 | (37.7560828122733, -122.427210089969) | ||
| 85263 | 85263 | 99874 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 770597 | 6003616.3 | 2095455.7 | 37.733927108519204 | -122.429896797189 | (37.7339271085192, -122.429896797189) |
| 85349 | 85349 | 87807 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 291 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50584 | 5987096.8 | 2114028.5 | 37.783973582398794 | -122.48837346173 | (37.7839735823988, -122.48837346173) | |
| 86642 | 86642 | 39178 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1050 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | |
| 86692 | 86692 | 93242 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 636 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004253.0 | 2105189.0 | 37.7606885326436 | -122.428389032489 | (37.7606885326436, -122.428389032489) | ||
| 89459 | 89459 | 16928 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 518 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2007 12:00:00 AM | 3 | 2.5 X3 | 6004333.80114 | 2110174.91218 | 37.7743832165186 | -122.42846496781999 | (37.7743832165186, -122.42846496782) | ||
| 90330 | 90330 | 93297 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 985 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004420.0 | 2103163.0 | 37.755135063976205 | -122.42766710326099 | (37.7551350639762, -122.427667103261) | ||
| 91544 | 91544 | 93246 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 990 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369.0 | 2103119.0 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | ||
| 94928 | 94928 | 108393 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 321 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772685 | 6006734.79675 | 2104244.32387 | 37.7582347949878 | -122.419738566409 | (37.7582347949878, -122.419738566409) |
| 94996 | 94996 | 108874 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 138 Cole St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773404 | 5997812.451119999 | 2110130.24113 | 37.773889369558 | -122.45102020833099 | (37.773889369558, -122.451020208331) | |
| 97188 | 97188 | 109448 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 143 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770854 | 6005451.2 | 2102876.8 | 37.7544075015735 | -122.424080557223 | (37.7544075015735, -122.424080557223) |
| 97825 | 97825 | 93239 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 600X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004217.7 | 2105335.5 | 37.761088789181 | -122.428521561971 | (37.761088789181, -122.428521561971) | ||
| 100689 | 100689 | 115319 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 86 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 777439 | 6000946.9 | 2101238.5 | 37.7496537815844 | -122.439540113547 | (37.7496537815844, -122.439540113547) | ||
| 107887 | 107887 | 93247 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 990 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369.0 | 2103119.0 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | ||
| 109745 | 109745 | 115375 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 230 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776301 | 6007067.3 | 2096865.5 | 37.7379929380378 | -122.41806552154101 | (37.7379929380378, -122.418065521541) | ||
| 113588 | 113588 | 93243 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 656 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004259.0 | 2105076.0 | 37.7603786010488 | -122.428360227113 | (37.7603786010488, -122.428360227113) | ||
| 114085 | 114085 | 39177 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1050 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | |
| 115616 | 115616 | 108627 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 223 Douglass St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772318 | 6001122.48631 | 2104986.5175900003 | 37.7599549235553 | -122.439201532761 | (37.7599549235553, -122.439201532761) | |
| 116850 | 116850 | 108870 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 636 Lyon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773421 | 6000111.40758 | 2111064.83155 | 37.7765868652264 | -122.443134899814 | (37.7765868652264, -122.443134899814) | |
| 118040 | 118040 | 109566 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 56 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775012 | 6000375.8 | 2089821.0 | 37.7182714712375 | -122.440696127295 | (37.7182714712375, -122.440696127295) |
| 119249 | 119249 | 93241 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 626 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004249.0 | 2105248.0 | 37.7608503062499 | -122.428407072017 | (37.7608503062499, -122.428407072017) | ||
| 119713 | 119713 | 93245 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 990 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369.0 | 2103119.0 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | ||
| 120541 | 120541 | 93238 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 600X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004217.7 | 2105335.5 | 37.761088789181 | -122.428521561971 | (37.761088789181, -122.428521561971) | ||
| 121527 | 121527 | 108628 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 741 Ellis St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774600 | 6007319.99858 | 2113650.90643 | 37.7840959912819 | -122.418381641984 | (37.7840959912819, -122.418381641984) | |
| 121754 | 121754 | 17176 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1601 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1999 12:00:00 AM | 3 | 4X4 | 6004921.1693652 | 2114736.5058391998 | 37.7869414485048 | -122.426758067349 | (37.7869414485048, -122.426758067349) | ||
| 123112 | 123112 | 18993 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2965 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1999 12:00:00 AM | 3 | 3X3 | 6000621.16815 | 2115478.56365 | 37.7887348935356 | -122.441688325582 | (37.7887348935356, -122.441688325582) | ||
| 124081 | 124081 | 93240 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 600X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004217.7 | 2105335.5 | 37.761088789181 | -122.428521561971 | (37.761088789181, -122.428521561971) | ||
| 124084 | 124084 | 117301 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2238 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778520 | 5985801.3 | 2099978.9 | 37.7453216318219 | -122.49182069563601 | (37.7453216318219, -122.491820695636) | ||
| 124793 | 124793 | 93248 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 990 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369.0 | 2103119.0 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | ||
| 126057 | 126057 | 93244 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 910X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004315.0 | 2103566.4 | 37.7562367654726 | -122.42805896962099 | (37.7562367654726, -122.428058969621) | ||
| 127184 | 127184 | 93298 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 869 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004381.0 | 2103841.0 | 37.75699448617571 | -122.427850284713 | (37.7569944861757, -122.427850284713) | ||
| 140226 | 140226 | 93299 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 801X Church St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004394.3 | 2104124.7 | 37.757774211767796 | -122.427824502367 | (37.7577742117678, -122.427824502367) | ||
| 145233 | 145233 | 18367 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 625 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/2015 09:59:00 AM | 3 | 4X3 | 6010438.66394 | 2105366.85434 | 37.7615249639888 | -122.407008038291 | (37.7615249639888, -122.407008038291) | ||
| 154620 | 154620 | 202023 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013701.15269 | 2091283.23076 | 37.723036312264796 | -122.394738025239 | (37.7230363122648, -122.394738025239) | |||
| 161322 | 161322 | 202025 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013662.901769999 | 2091312.2744599998 | 37.723113933631204 | -122.394872285044 | (37.7231139336312, -122.394872285044) | |||
| 170064 | 170064 | 202026 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013645.7458 | 2091325.32173 | 37.723148804870206 | -122.394932503635 | (37.7231488048702, -122.394932503635) | |||
| 171216 | 171216 | 177456 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1651 San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001539.4565 | 2094159.8919400002 | 37.7302512852618 | -122.436984326781 | (37.7302512852618, -122.436984326781) | |||
| 173435 | 173435 | 230401 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1140 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010508.63913 | 2102581.4092 | 37.753880669869794 | -122.406569730021 | (37.7538806698698, -122.406569730021) | |||
| 175333 | 175333 | 95808 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 974 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767552 | 6011863.56882 | 2103875.82821 | 37.757510570168705 | -122.401975028944 | (37.7575105701687, -122.401975028944) |
| 175470 | 175470 | 202027 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013629.1875599995 | 2091337.20695 | 37.72318051856 | -122.39499057468001 | (37.72318051856, -122.39499057468) | |||
| 184780 | 184780 | 202019 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1350 Fitzgerald Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013890.086209999 | 2091145.17982 | 37.7226677548035 | -122.394075255469 | (37.7226677548035, -122.394075255469) | |||
| 187968 | 187968 | 193409 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 551 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010674.14728 | 2105512.6689400002 | 37.7619385126714 | -122.40620386783701 | (37.7619385126714, -122.406203867837) | |||
| 48188 | 48188 | 117156 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6014458.776219999 | 2103767.54398 | 37.7573577456892 | -122.392992112005 | (37.7573577456892, -122.392992112005) | |||
| 58655 | 58655 | 202021 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013834.37055 | 2091185.2446599999 | 37.722774667999 | -122.39427065747101 | (37.722774667999, -122.394270657471) | |||
| 63152 | 63152 | 177453 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1651 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001481.52618 | 2094146.78927 | 37.7302120154671 | -122.437183661494 | (37.7302120154671, -122.437183661494) | |||
| 63489 | 63489 | 177454 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1651 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001501.639719999 | 2094151.35591 | 37.730225697742796 | -122.43711445328998 | (37.7302256977428, -122.43711445329) | |||
| 71026 | 71026 | 230404 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 995 Potrero Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010493.00859 | 2104414.71875 | 37.7589136546545 | -122.406752977672 | (37.7589136546545, -122.406752977672) | |||
| 135447 | 135447 | 193437 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 420 Bay Shore Blvd | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6010286.5563 | 2097785.62722 | 37.7407000755616 | -122.40699974536501 | (37.7407000755616, -122.406999745365) | |||
| 154854 | 154854 | 177455 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1651 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001518.96973 | 2094154.72477 | 37.7302359329302 | -122.43705478235701 | (37.7302359329302, -122.437054782357) | |||
| 167491 | 167491 | 230403 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 995 Potrero Ave | 10 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6010508.06667 | 2104211.71419 | 37.758357092123106 | -122.406686593337 | (37.7583570921231, -122.406686593337) | |||
| 183229 | 183229 | 230418 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301 San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003572.46167 | 2095485.4349900002 | 37.7340062713591 | -122.43005048006701 | (37.7340062713591, -122.430050480067) | |||
| 13613 | 13613 | 46415 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 700 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015975.2824099995 | 2105780.03754 | 37.7629677453768 | -122.3878878119 | (37.7629677453768, -122.3878878119) | |
| 14228 | 14228 | 46416 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 700 Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015974.86179 | 2105759.1893599997 | 37.7629104774528 | -122.38788781187701 | (37.7629104774528, -122.387887811877) | |
| 23345 | 23345 | 18460 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1146 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/2006 12:00:00 AM | 5 | 3X3 | 6010512.14548 | 2102543.99159 | 37.753778125574 | -122.40655496764099 | (37.753778125574, -122.406554967641) | ||
| 30004 | 30004 | 193411 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 681 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011009.79725 | 2105127.16685 | 37.7608987794618 | -122.40501583552 | (37.7608987794618, -122.40501583552) | |||
| 36283 | 36283 | 193430 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 560 Missouri St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013531.28257 | 2104470.6669900003 | 37.7592368044652 | -122.396249052661 | (37.7592368044652, -122.396249052661) | |||
| 41687 | 41687 | 230410 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010454.77139 | 2105010.4435799997 | 37.7605472416892 | -122.406927207828 | (37.7605472416892, -122.406927207828) | |||
| 55809 | 55809 | 123781 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1100 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992148.272480001 | 2110704.3151 | 37.775139717422704 | -122.47065517411998 | (37.7751397174227, -122.47065517412) | |||
| 58293 | 58293 | 193413 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2200 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011171.17043 | 2105584.0111700003 | 37.7621621911485 | -122.404489872412 | (37.7621621911485, -122.404489872412) | |||
| 60282 | 60282 | 193428 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1151 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014491.22334 | 2103857.32403 | 37.7576060646987 | -122.392886177259 | (37.7576060646987, -122.392886177259) | |||
| 67572 | 67572 | 123782 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1100 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992174.172809999 | 2110703.76964 | 37.7751397174253 | -122.470565540203 | (37.7751397174253, -122.470565540203) | |||
| 74732 | 74732 | 117153 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6014462.23102 | 2103712.78244 | 37.757207574192 | -122.392976332502 | (37.757207574192, -122.392976332502) | |||
| 76703 | 76703 | 230409 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010459.52552 | 2104963.6053 | 37.7604189003367 | -122.406907464126 | (37.7604189003367, -122.406907464126) | |||
| 123713 | 123713 | 67599 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 380 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | 5 | Permit Number 31168 | 6014306.36915 | 2105365.66412 | 37.7617373703071 | -122.393631049748 | (37.7617373703071, -122.393631049748) | |
| 151479 | 151479 | 193416 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1425 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015128.54714 | 2101843.94886 | 37.75211314410829 | -122.390541350608 | (37.7521131441083, -122.390541350608) | |||
| 159837 | 159837 | 193415 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1425 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015129.4675 | 2101818.79874 | 37.75204413825129 | -122.390536410622 | (37.7520441382513, -122.390536410622) | |||
| 182864 | 182864 | 193412 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2200 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011187.90739 | 2105585.43525 | 37.7621670366875 | -122.404432085586 | (37.7621670366875, -122.404432085586) | |||
| 183298 | 183298 | 193436 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 608 Missouri St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013540.38062 | 2104266.7592 | 37.758677424352896 | -122.39620329606899 | (37.7586774243529, -122.396203296069) | |||
| 26296 | 26296 | 193431 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 568 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013531.88693 | 2104447.0848 | 37.7591720865425 | -122.39624530967801 | (37.7591720865425, -122.396245309678) | |||
| 28347 | 28347 | 35383 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 557 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 6 | Permit Number 38839 | 6011254.224359999 | 2105785.2809900003 | 37.7627194740588 | -122.4042167852 | (37.7627194740588, -122.4042167852) | |
| 43230 | 43230 | 81651 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1100@ 12th Ave Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | Permit Number 767881 | 5992197.33713 | 2110704.35062 | 37.7751426520596 | -122.470485452724 | (37.7751426520596, -122.470485452724) | ||
| 45215 | 45215 | 37946 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 255 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40187 | 6013211.43951 | 2105863.92108 | 37.7630445717758 | -122.397452942701 | (37.7630445717758, -122.397452942701) | |
| 54459 | 54459 | 193427 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1151 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014474.19771 | 2103855.91322 | 37.75760124521779 | -122.39294496056499 | (37.7576012452178, -122.392944960565) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");