Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
855 | 855 | 251398 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
1622 | 1622 | 15770 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4770 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001421.7162 | 2091049.3752 | 37.721703820816394 | -122.43716874658399 | (37.7217038208164, -122.437168746584) | ||
2011 | 2011 | 224701 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6007503.74003 | 2102097.0446900004 | 37.7523821439458 | -122.416927083514 | (37.7523821439458, -122.416927083514) | |||
2123 | 2123 | 128055 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 449 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780354 | 6008758.87824 | 2121765.85838 | 37.8064585449799 | -122.413977880988 | (37.8064585449799, -122.413977880988) | |
5741 | 5741 | 64939 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1904 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/1989 12:00:00 AM | 14 | 4x9 | Permit Number 25968 | 6003770.598230001 | 2119034.75591 | 37.798678227572 | -122.431045672521 | (37.798678227572, -122.431045672521) | |
16498 | 16498 | 26003 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014451.27252 | 2095887.995 | 37.7357217425631 | -122.39246692501999 | (37.7357217425631, -122.39246692502) | |||
19276 | 19276 | 108963 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
20042 | 20042 | 24448 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1156 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006348.61536 | 2102840.94797 | 37.7543596874688 | -122.420974512988 | (37.7543596874688, -122.420974512988) | |||
20574 | 20574 | 23101 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1406 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6006426.26721 | 2101342.93585 | 37.7502508667074 | -122.420599640465 | (37.7502508667074, -122.420599640465) | |||
20649 | 20649 | 33653 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 284 Linden St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | |||
20968 | 20968 | 655 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3255X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 06/02/1992 12:00:00 AM | 12 | 3x4 | 6007319.73993 | 2102042.10408 | 37.7522209377659 | -122.41755949396901 | (37.7522209377659, -122.417559493969) | ||
21085 | 21085 | 5576 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1040 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6005062.54747 | 2102282.8606 | 37.752754731270706 | -122.425382354736 | (37.7527547312707, -122.425382354736) | |||
26790 | 26790 | 218822 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 210 Vernon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5992480.53035 | 2089289.94219 | 37.7163605349795 | -122.467947888583 | (37.7163605349795, -122.467947888583) | |||
29802 | 29802 | 224567 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3235 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007896.19994 | 2105583.80933 | 37.7619780702545 | -122.41581676433701 | (37.7619780702545, -122.415816764337) | |||
33417 | 33417 | 224524 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 145 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006710.95301 | 2102956.09091 | 37.754696261449 | -122.419729623734 | (37.754696261449, -122.419729623734) | |||
39298 | 39298 | 126628 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013814.15262 | 2118039.92484 | 37.7965106447043 | -122.396221758237 | (37.7965106447043, -122.396221758237) | |||
40036 | 40036 | 176403 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 332 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5998770.03746 | 2087851.6869599998 | 37.7127726114513 | -122.44610497396201 | (37.7127726114513, -122.446104973962) | |||
40410 | 40410 | 199435 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6014455.52547 | 2095885.24717 | 37.735714433762 | -122.392452028664 | (37.735714433762, -122.392452028664) | |||
46078 | 46078 | 224507 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2201 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008190.11914 | 2105143.7552799997 | 37.760786302161996 | -122.414769064951 | (37.760786302162, -122.414769064951) | |||
46174 | 46174 | 224682 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1390 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6006417.42588 | 2101484.35178 | 37.750638664248704 | -122.42064025206899 | (37.7506386642487, -122.420640252069) | |||
46980 | 46980 | 224690 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3514 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006361.82473 | 2101451.2167700003 | 37.750544549297 | -122.420830173598 | (37.750544549297, -122.420830173598) | |||
47541 | 47541 | 224710 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3278 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6006579.99639 | 2103217.6190400003 | 37.755406979454996 | -122.42020106814199 | (37.755406979455, -122.420201068142) | |||
48186 | 48186 | 224539 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2925 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008666.00775 | 2103876.41315 | 37.7573331968792 | -122.413033560461 | (37.7573331968792, -122.413033560461) | |||
59560 | 59560 | 249546 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 298 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6006094.99565 | 2114034.77585 | 37.785080967461795 | -122.422647004665 | (37.7850809674618, -122.422647004665) | |||
66263 | 66263 | 226492 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2300 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008774.11165 | 2104928.66815 | 37.7602285174483 | -122.412734081726 | (37.7602285174483, -122.412734081726) | |||
66518 | 66518 | 224643 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 7 Heyman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6006383.19422 | 2098395.0871099997 | 37.742154314365 | -122.420539363423 | (37.742154314365, -122.420539363423) | |||
76129 | 76129 | 48040 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3350 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | |||
76726 | 76726 | 218814 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 317 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995878.65108 | 2088143.0591400003 | 37.7134071101336 | -122.45611952571801 | (37.7134071101336, -122.456119525718) | |||
79724 | 79724 | 48785 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1405 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
79935 | 79935 | 52859 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2260on VALLEJO Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.796344678332794 | -122.42333957744499 | (37.7963446783328, -122.423339577445) | |||
79941 | 79941 | 97123 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3305 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 24053 | 6008171.0 | 2104436.0 | 37.758841894289205 | -122.414785099498 | (37.7588418942892, -122.414785099498) | ||
80439 | 80439 | 99116 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
83747 | 83747 | 111387 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 469 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014036.0 | 2112699.0 | 37.7818580461792 | -122.395079826315 | (37.7818580461792, -122.395079826315) | ||||
85104 | 85104 | 98237 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1299X 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 32025 | 5993314.0 | 2106663.0 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | ||||
86230 | 86230 | 114016 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||||
94873 | 94873 | 97190 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 255 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | |||
96990 | 96990 | 99016 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1133 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 29980 | 6008997.0 | 2116859.0 | 37.7929988993441 | -122.41280668476999 | (37.7929988993441, -122.41280668477) | ||||
97035 | 97035 | 47045 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 111 Maiden Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45035 | 6011125.92683466 | 2115044.13243826 | 37.7881349707775 | -122.40531257909599 | (37.7881349707775, -122.405312579096) | |||
97890 | 97890 | 104423 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2362 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 18 | 3x3 | Permit Number 24809 | 6002031.0 | 2107070.0 | 37.7657273142687 | -122.436208531898 | (37.7657273142687, -122.436208531898) | |
100915 | 100915 | 103153 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
103216 | 103216 | 83711 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3955 17TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/25/2005 12:00:00 AM | 12 | 3x3 | 6002562.7 | 2105843.1 | 37.7623887399353 | -122.434281776631 | (37.7623887399353, -122.434281776631) | ||
104415 | 104415 | 101428 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
105684 | 105684 | 116390 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | ||||
113280 | 113280 | 105686 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 3 | Front Yard : Pot 30 | Tree 1 | Private 1 | 6 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
114409 | 114409 | 114807 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2811 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6004778.36642477 | 2119194.00734605 | 37.799172543824504 | -122.427569823594 | (37.7991725438245, -122.427569823594) | ||||
117800 | 117800 | 97724 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
121528 | 121528 | 113877 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 101 HUGO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995437.0 | 2107003.0 | 37.7651664998927 | -122.45901075309999 | (37.7651664998927, -122.4590107531) | ||||
121700 | 121700 | 96965 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3686 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | Permit Number 23795 | 6005734.0 | 2104335.0 | 37.758427342075 | -122.423206207432 | (37.758427342075, -122.423206207432) | ||
123911 | 123911 | 33763 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1580 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | |||
124761 | 124761 | 99286 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2839 Pacific Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6000564.2 | 2116779.0 | 37.7923023065947 | -122.44197880493999 | (37.7923023065947, -122.44197880494) | |||||
128587 | 128587 | 34146 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
128800 | 128800 | 101516 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 610 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 28301 | 6008387.0 | 2114552.0 | 37.7866301828456 | -122.414753982265 | (37.7866301828456, -122.414753982265) | ||
132844 | 132844 | 251013 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3828 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995926.37639 | 2115877.04966 | 37.78956041774 | -122.457960373191 | (37.78956041774, -122.457960373191) | |||
134334 | 134334 | 224670 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009345.18768 | 2104440.47189 | 37.758920077605 | -122.41072451332701 | (37.758920077605, -122.410724513327) | |||
135158 | 135158 | 224706 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3200 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007512.60917 | 2102684.32552 | 37.753995182337 | -122.416938018377 | (37.753995182337, -122.416938018377) | |||
135207 | 135207 | 226471 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3101 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008696.0744900005 | 2105092.67763 | 37.760674469666 | -122.41301557310601 | (37.760674469666, -122.413015573106) | |||
140187 | 140187 | 98987 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 847 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009438.4 | 2115684.0 | 37.789797399949606 | -122.411196371815 | (37.7897973999496, -122.411196371815) | ||||
142421 | 142421 | 101055 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 760 Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008077.0 | 2114493.0 | 37.7864507606031 | -122.41582233096099 | (37.7864507606031, -122.415822330961) | |||
143506 | 143506 | 115027 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
147109 | 147109 | 224686 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3513 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006380.82201 | 2101410.31464 | 37.750433312158606 | -122.42076157599199 | (37.7504333121586, -122.420761575992) | |||
148521 | 148521 | 226488 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2498 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008832.88031 | 2103985.45214 | 37.757641959338706 | -122.41246415471001 | (37.7576419593387, -122.41246415471) | |||
154035 | 154035 | 111611 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 301x Ward St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 9x3 | 6011211.1462900005 | 2089627.82993 | 37.718352162787795 | -122.40322913082599 | (37.7183521627878, -122.403229130826) | |||
154571 | 154571 | 224583 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008562.4540099995 | 2106796.83945 | 37.7653462039852 | -122.413598242063 | (37.7653462039852, -122.413598242063) | |||
164535 | 164535 | 218833 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991183.94041 | 2098426.0210599997 | 37.7413709589947 | -122.473095372371 | (37.7413709589947, -122.473095372371) | |||
170821 | 170821 | 176422 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 538 Bacon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009782.31983 | 2092607.2094299998 | 37.726453016592394 | -122.40837804183701 | (37.7264530165924, -122.408378041837) | |||
171450 | 171450 | 224515 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 439 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007854.81877 | 2105216.20423 | 37.7609663850986 | -122.41593385338699 | (37.7609663850986, -122.415933853387) | |||
176422 | 176422 | 226481 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3235 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6007993.239469999 | 2105048.9001700003 | 37.7605147878543 | -122.415443270504 | (37.7605147878543, -122.415443270504) | |||
176889 | 176889 | 224504 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3771 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007856.89018 | 2097735.38644 | 37.740425864155604 | -122.41539707591002 | (37.7404258641556, -122.41539707591) | |||
178284 | 178284 | 226485 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3120 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008502.54321 | 2105665.76145 | 37.7622371604259 | -122.41372544938999 | (37.7622371604259, -122.41372544939) | |||
178369 | 178369 | 224711 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3287 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006422.5903900005 | 2103751.13112 | 37.756863009738396 | -122.42078330091299 | (37.7568630097384, -122.420783300913) | |||
182174 | 182174 | 224548 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3381 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007664.7835 | 2104406.9953900003 | 37.7587337983464 | -122.416533781209 | (37.7587337983464, -122.416533781209) | |||
185301 | 185301 | 224613 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 525 Burnett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999489.63243 | 2102445.2352299998 | 37.7528841365055 | -122.44466610455 | (37.7528841365055, -122.44466610455) |
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");