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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
152838 | 152838 | 237644 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 310 Liberty St | 50 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6003839.23208 | 2103927.37536 | 37.757200989362104 | -122.42973008309099 | (37.7572009893621, -122.429730083091) | |||
102961 | 102961 | 39036 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009448.598999999 | 2105916.703 | 37.762979270155505 | -122.410471107096 | (37.7629792701555, -122.410471107096) | ||
175316 | 175316 | 235818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004748.03107 | 2096617.2038599998 | 37.7371803628754 | -122.426066713609 | (37.7371803628754, -122.426066713609) | ||||
129663 | 129663 | 237865 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1201 San Jose Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004416.51581 | 2096041.25908 | 37.735580206346704 | -122.427171901277 | (37.7355802063467, -122.427171901277) | ||||
177543 | 177543 | 214300 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 42 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5993888.01583 | 2096515.6983900003 | 37.7362818799091 | -122.46360708499701 | (37.7362818799091, -122.463607084997) | ||||
35443 | 35443 | 237864 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1201 San Jose Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004410.62481 | 2096042.76783 | 37.735584015890204 | -122.427192376154 | (37.7355840158902, -122.427192376154) | ||||
110004 | 110004 | 39034 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009405.63 | 2105912.797 | 37.7629661362051 | -122.410619446859 | (37.7629661362051, -122.410619446859) | ||
46004 | 46004 | 212540 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5993897.21452 | 2096501.63961 | 37.7362438080119 | -122.46357426156 | (37.7362438080119, -122.46357426156) | ||||
119962 | 119962 | 39033 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009388.268999999 | 2105911.495 | 37.7629615878496 | -122.410679400873 | (37.7629615878496, -122.410679400873) | ||
55258 | 55258 | 212539 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5993900.48922 | 2096491.80191 | 37.736216984813105 | -122.463562225914 | (37.7362169848131, -122.463562225914) | ||||
140786 | 140786 | 39032 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009362.227000001 | 2105911.495 | 37.7629601277229 | -122.410769471544 | (37.7629601277229, -122.410769471544) | ||
69276 | 69276 | 39031 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009344.866 | 2105909.325 | 37.7629531959614 | -122.410829364237 | (37.7629531959614, -122.410829364237) | ||
165194 | 165194 | 212538 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5993893.90506 | 2096479.6500900001 | 37.736183239558 | -122.463584108238 | (37.736183239558, -122.463584108238) | ||||
142018 | 142018 | 39020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009326.637 | 2105908.456 | 37.7629497877468 | -122.410892350936 | (37.7629497877468, -122.410892350936) | ||
124880 | 124880 | 39029 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009306.238 | 2105908.456 | 37.762948643891 | -122.410962904321 | (37.762948643891, -122.410962904321) | ||
128920 | 128920 | 31250 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990801.243009999 | 2098168.10201 | 37.7406406146101 | -122.474399775861 | (37.7406406146101, -122.474399775861) | ||
176516 | 176516 | 235822 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Eugenia Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006569.74565 | 2098123.14893 | 37.7414181446448 | -122.419875033313 | (37.7414181446448, -122.419875033313) | ||||
115780 | 115780 | 31249 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990802.25301 | 2098150.9350099997 | 37.74059353695289 | -122.474395031258 | (37.7405935369529, -122.474395031258) | ||
20484 | 20484 | 39027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009258.495 | 2105867.224 | 37.7628327529372 | -122.41112511890101 | (37.7628327529372, -122.411125118901) | ||
89371 | 89371 | 31248 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990803.26301 | 2098117.61001 | 37.740502093576005 | -122.474389107834 | (37.740502093576, -122.474389107834) | ||
88180 | 88180 | 31247 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990804.27301 | 2098092.3640099997 | 37.7404328330574 | -122.47438377383499 | (37.7404328330574, -122.474383773835) | ||
144691 | 144691 | 39043 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009263.703 | 2105753.075 | 37.7625196179381 | -122.411099042798 | (37.7625196179381, -122.411099042798) | ||
81527 | 81527 | 39026 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009266.307 | 2105730.9390000002 | 37.762458983569495 | -122.411088472825 | (37.7624589835695, -122.411088472825) | ||
85443 | 85443 | 31246 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990805.283009999 | 2098068.1280099996 | 37.7403663457385 | -122.474378513531 | (37.7403663457385, -122.474378513531) | ||
32300 | 32300 | 196138 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 801 Arkansas St | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6013054.7193 | 2103811.53724 | 37.757400449098604 | -122.39785101412 | (37.7574004490986, -122.39785101412) | ||||
95229 | 95229 | 31251 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990805.283009999 | 2098048.9410099997 | 37.740313663161395 | -122.47437711373101 | (37.7403136631614, -122.474377113731) | ||
125544 | 125544 | 39030 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009267.609 | 2105685.366 | 37.7623339235365 | -122.411080750478 | (37.7623339235365, -122.411080750478) | ||
162715 | 162715 | 235819 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6004808.19427 | 2096683.55845 | 37.7373659577613 | -122.42586342366 | (37.7373659577613, -122.42586342366) | ||||
46448 | 46448 | 196295 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012406.535130001 | 2104796.6998799997 | 37.760069369818396 | -122.400161894071 | (37.7600693698184, -122.400161894071) | ||||
102756 | 102756 | 31260 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990807.30201 | 2098024.7050099997 | 37.740247234298 | -122.47436836476001 | (37.740247234298, -122.47436836476) | ||
126513 | 126513 | 39025 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009268.043 | 2105665.835 | 37.7622803202093 | -122.4110778698 | (37.7622803202093, -122.4110778698) | ||
90496 | 90496 | 39024 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009270.2129999995 | 2105649.776 | 37.76223634755271 | -122.411069230189 | (37.7622363475527, -122.411069230189) | ||
140936 | 140936 | 31266 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990808.3120099995 | 2097974.21301 | 37.740108654737206 | -122.47436118898099 | (37.7401086547372, -122.474361188981) | ||
151012 | 151012 | 196294 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012397.7351 | 2104775.9114900003 | 37.7600117988112 | -122.400190869313 | (37.7600117988112, -122.400190869313) | ||||
174884 | 174884 | 196137 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 801 Arkansas St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6013055.93777 | 2103788.3405299997 | 37.757336823850295 | -122.397845173025 | (37.7573368238503, -122.397845173025) | ||||
96307 | 96307 | 39023 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009270.2129999995 | 2105633.7169999997 | 37.7621922532056 | -122.411068095823 | (37.7621922532056, -122.411068095823) | ||
144186 | 144186 | 31265 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990808.3120099995 | 2097955.0260099997 | 37.740055972157705 | -122.474359789198 | (37.7400559721577, -122.474359789198) | ||
51583 | 51583 | 249891 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 27 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 0ft | 6011455.072819999 | 2120426.06234 | 37.8029308517393 | -122.404552786308 | (37.8029308517393, -122.404552786308) | |||
56155 | 56155 | 196081 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1301 Minnesota St | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6015382.92285 | 2102459.87565 | 37.7538184574574 | -122.389704688841 | (37.7538184574574, -122.389704688841) | ||||
94184 | 94184 | 39022 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009272.384 | 2105615.922 | 37.762143513944004 | -122.411059330144 | (37.762143513944, -122.411059330144) | ||
115267 | 115267 | 31264 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990809.32201 | 2097939.87901 | 37.740014440896104 | -122.47435519202601 | (37.7400144408961, -122.474355192026) | ||
58156 | 58156 | 196080 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1301 Minnesota St | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015379.264690001 | 2102450.5128 | 37.7537925462017 | -122.389716685804 | (37.7537925462017, -122.389716685804) | ||||
69480 | 69480 | 196293 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012394.755369999 | 2104793.13157 | 37.760058915200894 | -122.40020238425899 | (37.7600589152009, -122.400202384259) | ||||
76422 | 76422 | 196116 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1900 19th St | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6011922.16115 | 2105142.4561099997 | 37.760991719900204 | -122.401861426588 | (37.7609917199002, -122.401861426588) | ||||
109096 | 109096 | 31262 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990810.33201 | 2097920.69201 | 37.7399618168302 | -122.474350300123 | (37.7399618168302, -122.474350300123) | ||
139332 | 139332 | 39021 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009273.252 | 2105594.654 | 37.7620851655468 | -122.41105482574801 | (37.7620851655468, -122.411054825748) | ||
152443 | 152443 | 196094 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 26 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014400.8809 | 2105882.83985 | 37.7631626734333 | -122.393340361863 | (37.7631626734333, -122.393340361863) | ||||
29351 | 29351 | 237735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 701 Church St | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 3ft | 6004351.71049 | 2104523.66761 | 37.758867273023604 | -122.42800022455499 | (37.7588672730236, -122.428000224555) | |||
29380 | 29380 | 196093 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 25 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014406.1146599995 | 2105887.9731 | 37.763177058994 | -122.39332261913601 | (37.763177058994, -122.393322619136) | ||||
35147 | 35147 | 196292 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012388.17486 | 2104794.0427599996 | 37.760061050199596 | -122.400225207229 | (37.7600610501996, -122.400225207229) | ||||
112100 | 112100 | 31261 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990810.33201 | 2097905.54401 | 37.7399202243074 | -122.474349195013 | (37.7399202243074, -122.474349195013) | ||
144228 | 144228 | 39028 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009274.554 | 2105576.425 | 37.7620351858869 | -122.41104903498001 | (37.7620351858869, -122.41104903498) | ||
159357 | 159357 | 201952 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 25 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6013392.01965 | 2092548.68574 | 37.726493803536 | -122.395895275553 | (37.726493803536, -122.395895275553) | |||
36899 | 36899 | 237846 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 173 Addison St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002835.73219 | 2096923.0422 | 37.737911858847 | -122.432700238053 | (37.737911858847, -122.432700238053) | |||
90456 | 90456 | 21221 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2392X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
93590 | 93590 | 31252 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990810.33201 | 2097887.3670099997 | 37.7398703149271 | -122.47434786892599 | (37.7398703149271, -122.474347868926) | ||
128037 | 128037 | 39045 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009275.856000001 | 2105555.5919999997 | 37.7619780562366 | -122.41104306028299 | (37.7619780562366, -122.411043060283) | ||
132015 | 132015 | 196092 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 24 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014425.82588 | 2105887.0502299997 | 37.7631756200823 | -122.393254379501 | (37.7631756200823, -122.393254379501) | ||||
132745 | 132745 | 196291 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012380.38083 | 2104793.15065 | 37.7600581660633 | -122.40025210055401 | (37.7600581660633, -122.400252100554) | ||||
44436 | 44436 | 237845 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 173 Addison St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002804.643759999 | 2096952.2944099999 | 37.7379904155119 | -122.432809815017 | (37.7379904155119, -122.432809815017) | |||
62925 | 62925 | 135836 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6008591.776769999 | 2119025.88036 | 37.7989258649019 | -122.41436217388001 | (37.7989258649019, -122.41436217388) | |||
95327 | 95327 | 31259 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990811.34201 | 2097863.1310099997 | 37.7398038276004 | -122.474342608694 | (37.7398038276004, -122.474342608694) | ||
95950 | 95950 | 39051 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009278.893999999 | 2105538.231 | 37.7619305572552 | -122.41103132667601 | (37.7619305572552, -122.411031326676) | ||
143219 | 143219 | 21220 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2392X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
174122 | 174122 | 196290 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012385.57921 | 2104781.3261 | 37.760025988325296 | -122.400233291241 | (37.7600259883253, -122.400233291241) | ||||
98419 | 98419 | 31258 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990812.351009999 | 2097840.9150099996 | 37.739742886616796 | -122.474337499296 | (37.7397428866168, -122.474337499296) | ||
109862 | 109862 | 39052 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009313.616 | 2105488.318 | 37.7617954545913 | -122.410907711009 | (37.7617954545913, -122.410907711009) | ||
52347 | 52347 | 201970 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 21 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013765.00423 | 2092206.62002 | 37.725575303453496 | -122.39458193081998 | (37.7255753034535, -122.39458193082) | |||
54190 | 54190 | 201951 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 21 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013437.11385 | 2092477.4793 | 37.7263007937235 | -122.39573439853999 | (37.7263007937235, -122.39573439854) | |||
92475 | 92475 | 31267 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990813.36101 | 2097821.7280099997 | 37.739690262547796 | -122.47433260742399 | (37.7396902625478, -122.474332607424) | ||
99947 | 99947 | 39057 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009402.158 | 2105494.394 | 37.7618171023683 | -122.410601907375 | (37.7618171023683, -122.410601907375) | ||
105157 | 105157 | 21218 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2392X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
184038 | 184038 | 249689 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2400 Baker St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999718.81935 | 2117298.99939 | 37.7936818775552 | -122.444941227873 | (37.7936818775552, -122.444941227873) | ||||
20385 | 20385 | 39056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009422.123 | 2105494.394 | 37.7618182216771 | -122.410532856099 | (37.7618182216771, -122.410532856099) | ||
53555 | 53555 | 196289 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012382.84954 | 2104763.06022 | 37.7599756820445 | -122.400241449008 | (37.7599756820445, -122.400241449008) | ||||
57508 | 57508 | 135835 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6008609.072240001 | 2119027.30535 | 37.7989307491201 | -122.41430242651899 | (37.7989307491201, -122.414302426519) | |||
62690 | 62690 | 201971 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6013754.580159999 | 2092201.85922 | 37.7255616517262 | -122.394617632995 | (37.7255616517262, -122.394617632995) | ||||
83339 | 83339 | 31245 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990814.37101 | 2097800.52101 | 37.739632092076 | -122.47432756819299 | (37.739632092076, -122.474327568193) | ||
184976 | 184976 | 214230 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 20 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999463.98385 | 2095461.59315 | 37.7337072656774 | -122.444252993784 | (37.7337072656774, -122.444252993784) | ||||
34763 | 34763 | 196288 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012383.755890001 | 2104753.48944 | 37.7599494533344 | -122.40023764215799 | (37.7599494533344, -122.400237642158) | ||||
69088 | 69088 | 237844 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 173 Addison St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002716.29519 | 2097062.95575 | 37.738289254849 | -122.433123183804 | (37.738289254849, -122.433123183804) | |||
79052 | 79052 | 31257 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990814.37101 | 2097777.29501 | 37.739568319433104 | -122.47432587378599 | (37.7395683194331, -122.474325873786) | ||
128704 | 128704 | 39055 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009436.88 | 2105495.262 | 37.7618214323112 | -122.410481878589 | (37.7618214323112, -122.410481878589) | ||
151585 | 151585 | 196077 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 19 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014960.28506 | 2102234.79181 | 37.7531769800583 | -122.391150547759 | (37.7531769800583, -122.391150547759) | ||||
156186 | 156186 | 201950 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 19 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013454.07417 | 2092462.86765 | 37.726261616558205 | -122.39567474381599 | (37.7262616165582, -122.395674743816) | |||
185885 | 185885 | 201972 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 19 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013746.1142 | 2092220.9433400002 | 37.725613582194796 | -122.39464823513501 | (37.7256135821948, -122.394648235135) | |||
24067 | 24067 | 201949 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 18 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) | |||
37934 | 37934 | 249882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | Width 0ft | 6011509.072430001 | 2120419.3733099997 | 37.8029155030083 | -122.40436544761499 | (37.8029155030083, -122.404365447615) | |||
95400 | 95400 | 41060 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 220 10th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1999 12:00:00 AM | Permit Number 41830 | 6008482.96704788 | 2109848.1149541 | 37.7737198300469 | -122.41408905371 | (37.7737198300469, -122.41408905371) | ||
96380 | 96380 | 39016 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009463.356000001 | 2105496.13 | 37.761825299878204 | -122.410390369545 | (37.7618252998782, -122.410390369545) | ||
109275 | 109275 | 31256 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990815.38101 | 2097761.1370099997 | 37.739524012219796 | -122.474321202908 | (37.7395240122198, -122.474321202908) | ||
133863 | 133863 | 196076 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 18 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014971.87416 | 2102223.03647 | 37.753145345506795 | -122.39110964840401 | (37.7531453455068, -122.391109648404) | ||||
153153 | 153153 | 201973 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013730.31809 | 2092219.82075 | 37.725609621562796 | -122.39470276281999 | (37.7256096215628, -122.39470276282) | ||||
180009 | 180009 | 237843 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 173 Addison St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002706.02037 | 2097081.74978 | 37.738340276073 | -122.43316005151199 | (37.738340276073, -122.433160051512) | |||
28786 | 28786 | 214229 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 17 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5999467.99685 | 2095449.76583 | 37.7336750195872 | -122.444238270085 | (37.7336750195872, -122.444238270085) | ||||
49625 | 49625 | 39053 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009484.188999999 | 2105497.432 | 37.7618300427155 | -122.410318408111 | (37.7618300427155, -122.410318408111) | ||
69176 | 69176 | 201948 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 17 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013493.80219 | 2092427.9191599998 | 37.726167864948394 | -122.39553495768801 | (37.7261678649484, -122.395534957688) | |||
72134 | 72134 | 237842 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 173 Addison St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002688.4318699995 | 2097119.2766900002 | 37.738442318562704 | -122.433223544536 | (37.7384423185627, -122.433223544536) | |||
104347 | 104347 | 31255 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991076.92901 | 2097788.40301 | 37.739614026809996 | -122.473418880884 | (37.73961402681, -122.473418880884) | ||
104359 | 104359 | 41051 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 220 10th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1999 12:00:00 AM | Permit Number 41830 | 6008482.96704788 | 2109848.1149541 | 37.7737198300469 | -122.41408905371 | (37.7737198300469, -122.41408905371) |
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");