Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, DBH, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 532 | 532 | 6761 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1275 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:35:00 PM | 3 | 3x3 | 6017199.30801 | 2096970.01555 | 37.738844977413 | -122.383041088382 | (37.738844977413, -122.383041088382) | ||
| 1830 | 1830 | 251757 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 233 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001887.0 | 2086528.0 | 37.7093155646434 | -122.43523714505 | (37.7093155646434, -122.43523714505) | ||||
| 1839 | 1839 | 251756 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 233 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001887.0 | 2086528.0 | 37.7093155646434 | -122.43523714505 | (37.7093155646434, -122.43523714505) | ||||
| 3944 | 3944 | 251758 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 241 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 10:31:00 AM | 3 | 3x3 | 6001856.0 | 2086522.0 | 37.7092973294849 | -122.435343856961 | (37.7092973294849, -122.435343856961) | ||
| 4335 | 4335 | 251736 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 8 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:28:00 AM | 3 | 3x3 | 6002228.0 | 2087184.0 | 37.711136156016295 | -122.434105459048 | (37.7111361560163, -122.434105459048) | ||
| 4345 | 4345 | 109580 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 822 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 10:16:00 AM | 3 | 3x3 | Permit Number 775019 | 6004058.45374 | 2090883.76652 | 37.7213986270377 | -122.428042443214 | (37.7213986270377, -122.428042443214) |
| 4368 | 4368 | 251755 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 101X Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:50:00 AM | 3 | 3x3 | 6001862.0 | 2086566.0 | 37.709418484595 | -122.43532626528601 | (37.709418484595, -122.435326265286) | ||
| 4405 | 4405 | 251754 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 101X Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:47:00 AM | 3 | 3x3 | 6001862.0 | 2086566.0 | 37.709418484595 | -122.43532626528601 | (37.709418484595, -122.435326265286) | ||
| 13581 | 13581 | 18341 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 425 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2014 12:00:00 AM | 3 | 3x3 | 6010391.567000001 | 2106310.47571 | 37.7641132991006 | -122.407237448759 | (37.7641132991006, -122.407237448759) | ||
| 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) | |
| 15086 | 15086 | 18346 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 447 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2006 12:00:00 AM | 3 | 3x3 | 6010394.89315 | 2106204.37839 | 37.7638221660807 | -122.407218464984 | (37.7638221660807, -122.407218464984) | ||
| 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) | ||
| 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) | ||
| 18743 | 18743 | 18381 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 768 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6010390.09454 | 2104720.536 | 37.7597476013854 | -122.40713046091801 | (37.7597476013854, -122.407130460918) | |||
| 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) | ||
| 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) | ||
| 26639 | 26639 | 117155 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014460.76675 | 2103748.99279 | 37.757306918684 | -122.392983929988 | (37.757306918684, -122.392983929988) | |||
| 36596 | 36596 | 117159 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014455.7871900005 | 2103822.04979 | 37.7575072408736 | -122.39300626284799 | (37.7575072408736, -122.393006262848) | |||
| 47570 | 47570 | 117158 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014455.94065 | 2103803.2979900003 | 37.7574557609929 | -122.393004420141 | (37.7574557609929, -122.393004420141) | |||
| 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) | |||
| 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) | |
| 61175 | 61175 | 117154 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014461.75742 | 2103731.13458 | 37.757257938912 | -122.3929792544 | (37.757257938912, -122.3929792544) | |||
| 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) | |||
| 77661 | 77661 | 94252 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 80296 | 80296 | 94248 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 80407 | 80407 | 94251 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 83236 | 83236 | 94249 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 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) | |
| 85880 | 85880 | 93629 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 251 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2010 12:00:00 AM | 3x3 | Permit Number 53264 | 5985797.0 | 2114222.0 | 37.7844289534299 | -122.492884487425 | (37.7844289534299, -122.492884487425) | ||
| 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) | ||
| 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) | ||
| 93824 | 93824 | 117589 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2698 VALLEJO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000707.0 | 2117582.0 | 37.7945152706116 | -122.44154236468901 | (37.7945152706116, -122.441542364689) | ||||
| 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) | |
| 96459 | 96459 | 94253 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 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) | ||
| 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) | ||
| 108925 | 108925 | 94327 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1132 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2010 12:00:00 AM | 3x3 | Permit Number 53627 | 5995101.4 | 2091446.0 | 37.722431557418396 | -122.459044970295 | (37.7224315574184, -122.459044970295) | ||
| 111534 | 111534 | 62821 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 165 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2010 12:00:00 AM | 3x3 | Permit Number 53769 | 6004060.48554268 | 2101568.78877881 | 37.750737391448396 | -122.42879676445 | (37.7507373914484, -122.42879676445) | ||
| 112590 | 112590 | 104967 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 143-147 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | Permit Number 770854 | 6005451.2 | 2102876.8 | 37.7544075015735 | -122.424080557223 | (37.7544075015735, -122.424080557223) | ||
| 112880 | 112880 | 88518 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 133 Kenwood Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51449 | 5994469.5 | 2093573.6 | 37.728237086689404 | -122.46138344933 | (37.7282370866894, -122.46138344933) | |||
| 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) | ||
| 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) | |
| 116382 | 116382 | 94250 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 116397 | 116397 | 94257 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2777X 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.40957339028499 | (37.7597963985886, -122.409573390285) | |||
| 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) |
| 118363 | 118363 | 50070 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 178 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53758 | 6003140.05481803 | 2105079.35140699 | 37.7603244234929 | -122.432230375273 | (37.7603244234929, -122.432230375273) | |
| 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) | ||
| 119799 | 119799 | 94256 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2777X 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.40957339028499 | (37.7597963985886, -122.409573390285) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 136176 | 136176 | 117160 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014455.03317 | 2103837.45298 | 37.7575494928317 | -122.393009948265 | (37.7575494928317, -122.393009948265) | |||
| 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) | ||
| 144594 | 144594 | 82560 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 832 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52208 | 6009084.37207289 | 2104307.27777207 | 37.7585397298832 | -122.411617128308 | (37.7585397298832, -122.411617128308) | ||
| 145504 | 145504 | 84013 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 207 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 771913 | 5997093.91103174 | 2089409.10522836 | 37.7169530610701 | -122.45201046888201 | (37.7169530610701, -122.452010468882) | ||
| 149115 | 149115 | 93670 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 12 Robblee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 54071 | 6012650.87025 | 2095997.96753 | 37.735923558519104 | -122.39869937070299 | (37.7359235585191, -122.398699370703) | |
| 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) |
| 176083 | 176083 | 117157 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014459.2864 | 2103784.30474 | 37.7574037954676 | -122.39299152024999 | (37.7574037954676, -122.39299152025) | |||
| 179427 | 179427 | 101369 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2007 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769245 | 5999888.5 | 2111553.0 | 37.7779145386147 | -122.44394108204901 | (37.7779145386147, -122.443941082049) |
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");