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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 61392 | 61392 | 230407 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010466.98 | 2104784.69833 | 37.75992807914729 | -122.406869072951 | (37.7599280791473, -122.406869072951) | |||
| 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) | |||
| 61485 | 61485 | 230422 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 387 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007833.76172 | 2105654.7259299997 | 37.7621692805159 | -122.41603773676901 | (37.7621692805159, -122.416037736769) | |||
| 63056 | 63056 | 193414 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 563 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011255.16087 | 2105737.93689 | 37.762589530116 | -122.40421021383999 | (37.762589530116, -122.40421021384) | |||
| 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) | |||
| 66868 | 66868 | 106182 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 26 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2014 12:00:00 AM | 9 | Permit Number 772520 | 5996564.2 | 2114395.4 | 37.7855288291914 | -122.45564644363199 | (37.7855288291914, -122.455646443632) | ||
| 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) | |||
| 67791 | 67791 | 230398 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 625 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010441.3524 | 2105364.41642 | 37.761518420453896 | -122.40699856812901 | (37.7615184204539, -122.406998568129) | |||
| 68017 | 68017 | 208858 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 438 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995058.10493 | 2088636.3102900002 | 37.7147143277695 | -122.458991293911 | (37.7147143277695, -122.458991293911) | |||
| 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) | |||
| 70771 | 70771 | 193438 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 170 Scotia Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012250.26105 | 2094642.5839099998 | 37.7321796295918 | -122.39998929257601 | (37.7321796295918, -122.399989292576) | |||
| 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) | |||
| 74087 | 74087 | 230423 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 387 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007832.95914 | 2105672.86461 | 37.7622190400112 | -122.416041797198 | (37.7622190400112, -122.416041797198) | |||
| 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) | |||
| 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) | |||
| 76597 | 76597 | 46980 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1310 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44998 | 6015320.4365300005 | 2102435.8456200003 | 37.7537490109239 | -122.38991910430799 | (37.7537490109239, -122.389919104308) | ||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | ||
| 82328 | 82328 | 115264 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1634 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775141 | 5989384.4 | 2104210.4 | 37.7571489820097 | -122.47974063936701 | (37.7571489820097, -122.479740639367) | |||
| 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) | ||
| 83678 | 83678 | 99998 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013420.0 | 2115433.0 | 37.7893307029327 | -122.397402707509 | (37.7893307029327, -122.397402707509) | |||
| 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) | |
| 85527 | 85527 | 58794 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1979 12:00:00 AM | Permit Number 18041 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 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) | ||
| 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) | ||
| 86859 | 86859 | 115273 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1314 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775588 | 5985278.7 | 2106245.9 | 37.762498531179396 | -122.49408954164 | (37.7624985311794, -122.49408954164) | |||
| 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) | ||
| 93002 | 93002 | 115285 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 32 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775365 | 6004721.1 | 2096171.8 | 37.7359558621574 | -122.426128127271 | (37.7359558621574, -122.426128127271) | |||
| 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) | ||||
| 94785 | 94785 | 100008 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
| 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) | ||
| 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) | ||
| 101374 | 101374 | 106758 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 445 Grafton Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | Permit Number 772911 | 5995409.1 | 2090523.2 | 37.7199154518997 | -122.457914582927 | (37.7199154518997, -122.457914582927) | ||||
| 101686 | 101686 | 54058 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2011 12:00:00 AM | Permit Number 767754 | 5994238.69785688 | 2106641.55496777 | 37.7641051091536 | -122.46312913118099 | (37.7641051091536, -122.463129131181) | |||
| 103136 | 103136 | 64806 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1375 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2012 12:00:00 AM | 22 | 5x5 | Permit Number 768180 | 6003293.30156995 | 2100236.74825313 | 37.747036468941005 | -122.43135467591999 | (37.747036468941, -122.43135467592) |
| 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) | ||
| 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) | ||
| 109955 | 109955 | 112881 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 634 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2015 12:00:00 AM | Permit Number 773545 | 5985072.5 | 2111537.7 | 37.777016246756894 | -122.49519295395201 | (37.7770162467569, -122.495192953952) | |||
| 110498 | 110498 | 114987 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 157 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | Permit Number 775985 | 5995400.7 | 2089591.3 | 37.7173561925503 | -122.45787621793899 | (37.7173561925503, -122.457876217939) | |||
| 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) | ||
| 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) | |
| 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) |
| 118297 | 118297 | 45655 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2011 12:00:00 AM | Permit Number 767754 | 5994244.0 | 2106639.0 | 37.764098399310704 | -122.463110607355 | (37.7640983993107, -122.463110607355) | |||
| 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) | |
| 119015 | 119015 | 8129 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 899 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2013 12:00:00 AM | 12 | 3X3 | Permit Number 770378 | 6003470.39544 | 2111382.10126 | 37.7776489625125 | -122.431537848369 | (37.7776489625125, -122.431537848369) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 124691 | 124691 | 100003 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
| 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) | ||
| 126378 | 126378 | 45656 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2011 12:00:00 AM | Permit Number 767754 | 5994244.0 | 2106639.0 | 37.764098399310704 | -122.463110607355 | (37.7640983993107, -122.463110607355) | |||
| 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) | ||
| 127359 | 127359 | 34304 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1248 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2016 12:00:00 AM | Permit Number 777415 | 6010821.325282 | 2102511.88817286 | 37.7537072691799 | -122.40548348700099 | (37.7537072691799, -122.405483487001) | ||
| 128958 | 128958 | 100007 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
| 130484 | 130484 | 193429 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1151 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014506.85634 | 2103858.18885 | 37.7576093076281 | -122.39283217206699 | (37.7576093076281, -122.392832172067) | |||
| 132389 | 132389 | 46977 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1310 Minnesota St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44998 | 6015323.660209999 | 2102361.18474 | 37.7535441867291 | -122.38990274114201 | (37.7535441867291, -122.389902741142) | ||
| 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) | |||
| 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) | |||
| 137569 | 137569 | 177457 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1651 San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001558.284440001 | 2094165.3004599998 | 37.730267205960295 | -122.436919623235 | (37.7302672059603, -122.436919623235) | |||
| 138541 | 138541 | 230402 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 995 Potrero Ave | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6010527.0507 | 2103856.48907 | 37.7573827855076 | -122.406595905697 | (37.7573827855076, -122.406595905697) | |||
| 138542 | 138542 | 54682 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1212 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2011 12:00:00 AM | Permit Number 767886 | 5993014.13432891 | 2107214.38358529 | 37.7656073275163 | -122.467406160634 | (37.7656073275163, -122.467406160634) | |||
| 138689 | 138689 | 35331 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2222 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 7 | Permit Number 38797 | 6011102.74031 | 2105580.11017 | 37.7621476554073 | -122.404726272704 | (37.7621476554073, -122.404726272704) |
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");