Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1100 | 1100 | 2952 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2001 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6004785.43 | 2115651.1441 | 37.789445140420604 | -122.427292872615 | (37.7894451404206, -122.427292872615) | |||
| 125830 | 125830 | 22922 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6006142.65939 | 2107729.77965 | 37.7677716622264 | -122.42203404127301 | (37.7677716622264, -122.422034041273) | |||
| 1527 | 1527 | 103937 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2013 12:00:00 AM | 26 | Permit Number 770288 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | ||
| 95139 | 95139 | 64130 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | 24 | Permit Number 24901 | 6002310.61439363 | 2098891.53580323 | 37.743287089709604 | -122.434656544552 | (37.7432870897096, -122.434656544552) | |
| 58995 | 58995 | 191682 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1540 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6015538.54688 | 2096541.66085 | 37.7375768955577 | -122.38875338056299 | (37.7375768955577, -122.388753380563) | |||
| 60557 | 60557 | 223470 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 972 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5998837.19654 | 2106602.69587 | 37.764262238528204 | -122.447221529965 | (37.7642622385282, -122.447221529965) | |||
| 32354 | 32354 | 224078 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 37 Mars St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 5999600.0223900005 | 2105581.97574 | 37.761503152657106 | -122.444509776331 | (37.7615031526571, -122.444509776331) | |||
| 59806 | 59806 | 112676 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1601 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6010481.2 | 2120003.6 | 37.8017163995107 | -122.40789309729799 | (37.8017163995107, -122.407893097298) | |||
| 14726 | 14726 | 6733 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6017061.2899 | 2097158.62505 | 37.7393552338433 | -122.383531422133 | (37.7393552338433, -122.383531422133) | |||
| 20586 | 20586 | 22918 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6006138.942840001 | 2107682.09275 | 37.7676405157139 | -122.422043508318 | (37.7676405157139, -122.422043508318) | |||
| 31343 | 31343 | 55507 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1660 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/25/1989 12:00:00 AM | 20 | Permit Number 23375 | 6004977.3709 | 2119202.3279 | 37.7992066440205 | -122.426881792584 | (37.7992066440205, -122.426881792584) | |
| 91419 | 91419 | 64168 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 770 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1987 12:00:00 AM | 20 | 4x6 | Permit Number 24949 | 5991979.28943 | 2110202.2151 | 37.7737513136845 | -122.471203129362 | (37.7737513136845, -122.471203129362) |
| 115770 | 115770 | 22920 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6006146.186319999 | 2107684.7475900003 | 37.767648213804996 | -122.42201864261699 | (37.767648213805, -122.422018642617) | |||
| 120592 | 120592 | 22919 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6006146.38467 | 2107662.66758 | 37.7675875985285 | -122.422016387826 | (37.7675875985285, -122.422016387826) | |||
| 181924 | 181924 | 223471 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 956 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5998814.740180001 | 2106663.16945 | 37.764427000625 | -122.447303552626 | (37.764427000625, -122.447303552626) | |||
| 186102 | 186102 | 58393 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 511 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/2008 12:00:00 AM | 20 | 3x3 | Permit Number 51724 | 6005404.80617926 | 2110951.74140997 | 37.7765767492195 | -122.424815434114 | (37.7765767492195, -122.424815434114) | |
| 24989 | 24989 | 223551 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1143 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5997699.39696 | 2106553.80105 | 37.764062907387704 | -122.45115331019 | (37.7640629073877, -122.45115331019) | |||
| 160800 | 160800 | 223456 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 508 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5998596.25965 | 2106249.17699 | 37.7632777947483 | -122.448029403535 | (37.7632777947483, -122.448029403535) | |||
| 180062 | 180062 | 223531 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6002360.62699 | 2098888.4177 | 37.743281367239796 | -122.434483391309 | (37.7432813672398, -122.434483391309) | |||
| 6712 | 6712 | 55965 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2740 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 18 | 5x5 | Permit Number 773535 | 6006142.142580001 | 2120235.85685 | 37.8021102410536 | -122.422924771976 | (37.8021102410536, -122.422924771976) | |
| 9137 | 9137 | 7679 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 299X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 18 | 3x3 | 5994818.31491 | 2110743.00765 | 37.7753999939995 | -122.461421774878 | (37.7753999939995, -122.461421774878) | ||
| 14736 | 14736 | 6734 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017044.07799 | 2097171.2102099997 | 37.739388838832504 | -122.383591809817 | (37.7393888388325, -122.383591809817) | |||
| 66265 | 66265 | 59758 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 354 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1981 12:00:00 AM | 18 | 6x9 | Permit Number 19196 | 6003858.35671 | 2091380.59848 | 37.722751495181704 | -122.42876952352199 | (37.7227514951817, -122.428769523522) | |
| 72779 | 72779 | 223459 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 565 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5998606.57278 | 2105920.50648 | 37.762375937532795 | -122.447970068967 | (37.7623759375328, -122.447970068967) | |||
| 137271 | 137271 | 191088 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 01st St | 19 | : Yard 23 | Tree 1 | Private 1 | 18 | 6014455.34951 | 2105889.6924799997 | 37.7631845152826 | -122.393152451232 | (37.7631845152826, -122.393152451232) | ||||
| 138005 | 138005 | 223549 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 900 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5999208.96535 | 2107104.19665 | 37.76566046938579 | -122.445971764578 | (37.7656604693858, -122.445971764578) | |||
| 178544 | 178544 | 223554 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 719 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6007400.1062 | 2095511.2978400001 | 37.734293322378896 | -122.416818929272 | (37.7342933223789, -122.416818929272) | |||
| 851 | 851 | 234149 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3652 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005288.48907 | 2102558.72214 | 37.753524945734 | -122.42462062893601 | (37.753524945734, -122.424620628936) | |||
| 29474 | 29474 | 121021 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1649 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6005068.54414 | 2119516.86917 | 37.800075448478204 | -122.42658871161001 | (37.8000754484782, -122.42658871161) | |||
| 32041 | 32041 | 223379 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2730 22nd St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 7ft | 6009758.65341 | 2103393.8455 | 37.756069450652795 | -122.4092206931 | (37.7560694506528, -122.4092206931) | |||
| 32595 | 32595 | 223390 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 61 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005265.03811 | 2105111.68435 | 37.760533457783104 | -122.42488334431101 | (37.7605334577831, -122.424883344311) | |||
| 45245 | 45245 | 223494 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007979.72729 | 2102967.16381 | 37.754798056597 | -122.415342629177 | (37.754798056597, -122.415342629177) | |||
| 53773 | 53773 | 223550 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1047 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5997652.48315 | 2106877.54396 | 37.7649491371199 | -122.451338921264 | (37.7649491371199, -122.451338921264) | |||
| 146807 | 146807 | 73567 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1549 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 17 | 6015475.76559 | 2096515.7119900002 | 37.7375021654981 | -122.38896863599199 | (37.7375021654981, -122.388968635992) | ||
| 151394 | 151394 | 207540 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1225 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5994824.854040001 | 2107195.02227 | 37.7656585349505 | -122.461141922776 | (37.7656585349505, -122.461141922776) | |||
| 151768 | 151768 | 223466 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 871 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5998671.83935 | 2107146.23742 | 37.7657452169834 | -122.44783258512301 | (37.7657452169834, -122.447832585123) | |||
| 159291 | 159291 | 223373 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Bosworth St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6003068.252 | 2095170.8031799998 | 37.7331137949537 | -122.431771230282 | (37.7331137949537, -122.431771230282) | ||||
| 168321 | 168321 | 223426 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 170 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6009923.953369999 | 2100088.63423 | 37.7470033329491 | -122.408415899671 | (37.7470033329491, -122.408415899671) | |||
| 37221 | 37221 | 223386 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3665 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005227.0374300005 | 2104855.48781 | 37.759827855995205 | -122.42499654287901 | (37.7598278559952, -122.424996542879) | |||
| 39075 | 39075 | 104269 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2867 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 7x7 | 5999338.58115 | 2117675.40642 | 37.7946936832082 | -122.44628396962798 | (37.7946936832082, -122.446283969628) | |||
| 45471 | 45471 | 126516 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3449 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5997745.83933 | 2116374.85745 | 37.7910316321555 | -122.451701179872 | (37.7910316321555, -122.451701179872) | |||
| 45772 | 45772 | 223502 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3433 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006860.5286 | 2101435.1992200003 | 37.7505286654636 | -122.419104477086 | (37.7505286654636, -122.419104477086) | |||
| 46319 | 46319 | 224075 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4377 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000260.08282 | 2105746.79399 | 37.761993343427704 | -122.44223873815399 | (37.7619933434277, -122.442238738154) | |||
| 46387 | 46387 | 248575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 185 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998282.3988 | 2107687.3856 | 37.7672088058363 | -122.449218560454 | (37.7672088058363, -122.449218560454) | |||
| 52431 | 52431 | 176245 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6011861.55971 | 2090354.4495299999 | 37.72038361619379 | -122.401031937775 | (37.7203836161938, -122.401031937775) | |||
| 86352 | 86352 | 49496 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2X ORDWAY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 16 | 3x3 | Permit Number 46411 | 6011821.0 | 2090323.0 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | |
| 91273 | 91273 | 107688 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 300X ALEMANY BLVD | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 6008820.4 | 2095497.5 | 37.734335221774394 | -122.411907523711 | (37.7343352217744, -122.411907523711) | ||||
| 101289 | 101289 | 54727 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1239 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2010 12:00:00 AM | 16 | Permit Number 10570 | 5993898.14221717 | 2107049.18908111 | 37.7652047418661 | -122.464336602201 | (37.7652047418661, -122.464336602201) | ||
| 106062 | 106062 | 22921 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/1999 12:00:00 AM | 16 | 3X3 | 6006144.43338 | 2107707.65753 | 37.767711020193204 | -122.42202633352 | (37.7677110201932, -122.42202633352) | ||
| 129944 | 129944 | 66093 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1052 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1990 12:00:00 AM | 16 | Permit Number 29138 | 6007872.07049 | 2119612.96826 | 37.8004974059005 | -122.41689421958799 | (37.8004974059005, -122.416894219588) | |
| 135385 | 135385 | 207544 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 340 Hugo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5994650.56709 | 2107039.97579 | 37.765222786433796 | -122.461733495911 | (37.7652227864338, -122.461733495911) | |||
| 148922 | 148922 | 248419 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 726 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999075.0539 | 2108056.9885 | 37.7682689481267 | -122.446503486875 | (37.7682689481267, -122.446503486875) | |||
| 164320 | 164320 | 223391 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 41 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6005260.46282 | 2105206.1033799998 | 37.7607924517343 | -122.424905885809 | (37.7607924517343, -122.424905885809) | |||
| 170930 | 170930 | 223469 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 945 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5998759.82917 | 2106683.9118 | 37.7644808160601 | -122.447494967025 | (37.7644808160601, -122.447494967025) | |||
| 174559 | 174559 | 207658 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1347 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 5994853.56719 | 2106361.61895 | 37.7633718782394 | -122.460982201389 | (37.7633718782394, -122.460982201389) | |||
| 175099 | 175099 | 30609 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 365 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 16 | Permit Number 34572 | 6008561.72189 | 2108643.78999 | 37.770417459437496 | -122.41373142536501 | (37.7704174594375, -122.413731425365) | |
| 186771 | 186771 | 223597 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 306 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6007773.4938900005 | 2106023.20364 | 37.7631776462561 | -122.416272279958 | (37.7631776462561, -122.416272279958) | |||
| 1009 | 1009 | 223537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6003218.0959 | 2100594.3408 | 37.7480140720016 | -122.431640256605 | (37.7480140720016, -122.431640256605) | |||
| 28506 | 28506 | 223371 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3527 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006033.70926 | 2105484.59441 | 37.7616007686849 | -122.42225135332899 | (37.7616007686849, -122.422251353329) | |||
| 28721 | 28721 | 223467 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 812 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998670.80107 | 2107458.83461 | 37.7666034705969 | -122.447858683442 | (37.7666034705969, -122.447858683442) | |||
| 29336 | 29336 | 207629 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1256 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5993954.61606 | 2106931.98149 | 37.7648861755735 | -122.464132764815 | (37.7648861755735, -122.464132764815) | |||
| 34451 | 34451 | 224069 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4411 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5999992.96572 | 2105734.65927 | 37.761944797124706 | -122.44316171774099 | (37.7619447971247, -122.443161717741) | |||
| 40030 | 40030 | 223645 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3422 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006716.76064 | 2104985.28573 | 37.760268288171794 | -122.41985352063101 | (37.7602682881718, -122.419853520631) | |||
| 44237 | 44237 | 207563 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1453 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5993327.97162 | 2105609.42801 | 37.7612186539421 | -122.466204030294 | (37.7612186539421, -122.466204030294) | |||
| 52641 | 52641 | 207623 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1209 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5995446.62936 | 2107316.27502 | 37.7660272254875 | -122.45900013246401 | (37.7660272254875, -122.459000132464) | |||
| 53106 | 53106 | 59756 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 410 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1981 12:00:00 AM | 15 | Permit Number 19194 | 6003645.40594 | 2091044.7006599999 | 37.7218171391456 | -122.42948170562 | (37.7218171391456, -122.42948170562) | ||
| 54974 | 54974 | 207657 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1343 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 5994851.17406 | 2106389.13082 | 37.7634472809955 | -122.46099247254699 | (37.7634472809955, -122.460992472547) | |||
| 63479 | 63479 | 207666 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 316 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 6ft | 5993287.90775 | 2103943.6101599997 | 37.756642440205106 | -122.46622153019501 | (37.7566424402051, -122.466221530195) | |||
| 65203 | 65203 | 224090 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004557.93322 | 2109147.67974 | 37.771575367127205 | -122.427616451463 | (37.7715753671272, -122.427616451463) | |||
| 133926 | 133926 | 223454 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 582 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5998651.90281 | 2105834.0074299998 | 37.7621410238197 | -122.447807062365 | (37.7621410238197, -122.447807062365) | |||
| 143974 | 143974 | 58476 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 772 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1978 12:00:00 AM | 15 | 8x7 | Permit Number 17633 | 5998628.49862087 | 2107799.74145876 | 37.767537096550605 | -122.44802954749599 | (37.7675370965506, -122.448029547496) | |
| 150845 | 150845 | 207631 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1253 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5993899.350740001 | 2106950.14127 | 37.7649328521939 | -122.464325230527 | (37.7649328521939, -122.464325230527) | |||
| 169694 | 169694 | 223530 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 606 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6002608.27814 | 2098903.4509099997 | 37.743336699841706 | -122.433628153123 | (37.7433366998417, -122.433628153123) | |||
| 177966 | 177966 | 223438 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 270 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004159.88516 | 2099284.24689 | 37.7444701945428 | -122.428290228918 | (37.7444701945428, -122.428290228918) | |||
| 179873 | 179873 | 223417 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 416 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009130.8253 | 2100056.49852 | 37.7468706478628 | -122.411156208595 | (37.7468706478628, -122.411156208595) | |||
| 183175 | 183175 | 54136 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2443 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | 15 | Permit Number 9869 | 6001890.1565 | 2117687.62066 | 37.7948726132212 | -122.437456069748 | (37.7948726132212, -122.437456069748) | ||
| 184002 | 184002 | 223444 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 319 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003651.97677 | 2099506.05827 | 37.7450504848013 | -122.430062291736 | (37.7450504848013, -122.430062291736) | |||
| 185551 | 185551 | 71394 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1549 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 15 | 6015490.02353 | 2096504.2256900002 | 37.7374714167655 | -122.388918537456 | (37.7374714167655, -122.388918537456) | ||
| 187744 | 187744 | 207546 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1249 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5993899.6739 | 2106983.20983 | 37.7650236684223 | -122.46432651386002 | (37.7650236684223, -122.46432651386) | |||
| 188247 | 188247 | 223414 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 308 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009647.06904 | 2099615.2237400003 | 37.7456879422558 | -122.40933994229799 | (37.7456879422558, -122.409339942298) | |||
| 2771 | 2771 | 248515 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 170 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 14 | Width 0ft | Permit Number 17884 | 5998314.3472 | 2107764.7584 | 37.7674230792249 | -122.44911363069099 | (37.7674230792249, -122.449113630691) | |
| 24108 | 24108 | 223503 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3421 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006951.65327 | 2101439.66063 | 37.750546046666706 | -122.41878967662 | (37.7505460466667, -122.41878967662) | |||
| 29873 | 29873 | 223638 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006702.0078300005 | 2102414.72297 | 37.753209285497704 | -122.41972214857799 | (37.7532092854977, -122.419722148578) | |||
| 30277 | 30277 | 207570 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1425 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5993940.55788 | 2105777.49426 | 37.7617154448214 | -122.464097572554 | (37.7617154448214, -122.464097572554) | |||
| 31518 | 31518 | 223432 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 321 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6006137.48741 | 2107733.43659 | 37.7677814116141 | -122.422052190377 | (37.7677814116141, -122.422052190377) | |||
| 31940 | 31940 | 224063 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 253 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999782.69544 | 2105496.73151 | 37.761279514647704 | -122.44387186291401 | (37.7612795146477, -122.443871862914) | |||
| 34552 | 34552 | 246582 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 198 Laguna St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 6ft | 6005203.89906 | 2109501.9724 | 37.7725846861634 | -122.425407234452 | (37.7725846861634, -122.425407234452) | |||
| 36417 | 36417 | 224061 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 181 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001736.66137 | 2107755.21025 | 37.7675920053907 | -122.437275651355 | (37.7675920053907, -122.437275651355) | |||
| 46094 | 46094 | 207625 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1223 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995447.2053 | 2107231.58705 | 37.7657947273793 | -122.45899200797301 | (37.7657947273793, -122.458992007973) | |||
| 47414 | 47414 | 224062 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 67 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004498.44679 | 2107387.20492 | 37.7667381638479 | -122.427696765417 | (37.7667381638479, -122.427696765417) | |||
| 53895 | 53895 | 207569 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1421 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5993941.19822 | 2105808.00041 | 37.7617992436728 | -122.464097572539 | (37.7617992436728, -122.464097572539) | |||
| 56902 | 56902 | 223440 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 374 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6003528.78647 | 2098662.81871 | 37.7427281663791 | -122.43042810806999 | (37.7427281663791, -122.43042810807) | |||
| 60106 | 60106 | 207624 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1217 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 5995447.45032 | 2107265.73285 | 37.765888496982 | -122.458993633074 | (37.765888496982, -122.458993633074) | |||
| 61122 | 61122 | 207588 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001743.96601 | 2095815.79538 | 37.734809637542604 | -122.43639577894699 | (37.7348096375426, -122.436395778947) | |||
| 61283 | 61283 | 62959 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1175 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 14 | Permit Number 23345 | 6008001.56121 | 2118185.8038 | 37.796586051068296 | -122.416344986535 | (37.7965860510683, -122.416344986535) | |
| 67173 | 67173 | 223624 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 473 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006815.17868 | 2101055.50218 | 37.7494835498253 | -122.41923436977301 | (37.7494835498253, -122.419234369773) | |||
| 67369 | 67369 | 223387 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 79 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6005279.4889400005 | 2104932.34735 | 37.7600418568744 | -122.42482060669701 | (37.7600418568744, -122.424820606697) | |||
| 74779 | 74779 | 126518 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 250 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6001004.1141099995 | 2120049.67751 | 37.8013077849919 | -122.440691404186 | (37.8013077849919, -122.440691404186) | |||
| 102796 | 102796 | 63387 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 181 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | 14 | Permit Number 23968 | 6006281.90561253 | 2095847.6388786 | 37.735153881321004 | -122.42070878449101 | (37.735153881321, -122.420708784491) | |
| 116921 | 116921 | 223461 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 49 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998343.32414 | 2106238.61167 | 37.7632343233256 | -122.448903459151 | (37.7632343233256, -122.448903459151) |
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");