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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51429 | 51429 | 69307 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1522 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 2 | Permit Number 33386 | 5986858.656 | 2104872.1171 | 37.758818824109 | -122.48852415134701 | (37.758818824109, -122.488524151347) | |
| 51435 | 51435 | 65246 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1123 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28040 | 6009230.45296658 | 2102616.7905535 | 37.753906226408 | -122.410992511898 | (37.753906226408, -122.410992511898) | ||
| 51523 | 51523 | 43732 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 769 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43369 | 5994354.80201989 | 2089904.78759744 | 37.718156810292 | -122.461514088361 | (37.718156810292, -122.461514088361) | ||
| 52167 | 52167 | 214406 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993802.78615 | 2096495.7432 | 37.736222176613104 | -122.463900308969 | (37.7362221766131, -122.463900308969) | ||||
| 52353 | 52353 | 40683 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 52 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 3 | Permit Number 41666 | 6003772.100819999 | 2093995.08887 | 37.7299254213136 | -122.429254030544 | (37.7299254213136, -122.429254030544) | |
| 52388 | 52388 | 178914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993788.47929 | 2086756.5816799998 | 37.7094799730978 | -122.463243292153 | (37.7094799730978, -122.463243292153) | ||||
| 52553 | 52553 | 249684 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999742.6330699995 | 2117264.679 | 37.793589001891796 | -122.44485636243 | (37.7935890018918, -122.44485636243) | ||||
| 52734 | 52734 | 69491 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 57 Danton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2003 12:00:00 AM | 3 | Permit Number 33613 | 6002842.65111 | 2094614.47792 | 37.7315734613241 | -122.43251146944999 | (37.7315734613241, -122.43251146945) | |
| 52984 | 52984 | 69922 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1479 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1990 12:00:00 AM | 6 | 5987109.7204 | 2105224.4854 | 37.7598009776001 | -122.487681752733 | (37.7598009776001, -122.487681752733) | ||
| 53597 | 53597 | 42437 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 550 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.45323030571801 | (37.7285785035344, -122.453230305718) | ||
| 53614 | 53614 | 65608 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 235 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | Permit Number 28512 | 6004926.15006729 | 2093819.12850558 | 37.729507538818105 | -122.42525182613899 | (37.7295075388181, -122.425251826139) | ||
| 53715 | 53715 | 72507 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2135 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1996 12:00:00 AM | 6 | 5988189.7462 | 2100767.6803 | 37.747626723008295 | -122.48361976345801 | (37.7476267230083, -122.483619763458) | ||
| 53792 | 53792 | 36410 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 591 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39333 | 5995339.97501455 | 2093247.68753987 | 37.7273922712597 | -122.45835062173599 | (37.7273922712597, -122.458350621736) | ||
| 53793 | 53793 | 33345 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 90 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37482 | 6001488.85408541 | 2094961.63013744 | 37.7324497978026 | -122.437216648553 | (37.7324497978026, -122.437216648553) | ||
| 54410 | 54410 | 34473 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1725 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | 3 | Permit Number 38203 | 6008692.20922 | 2118946.49843 | 37.7987135430497 | -122.414009024508 | (37.7987135430497, -122.414009024508) | ||
| 54613 | 54613 | 43848 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2634 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43470 | 5985245.7192 | 2097273.3217 | 37.7378603541939 | -122.493542458198 | (37.7378603541939, -122.493542458198) | |
| 54903 | 54903 | 249683 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999743.16478 | 2117253.42108 | 37.7935581209611 | -122.44485371304701 | (37.7935581209611, -122.444853713047) | ||||
| 55722 | 55722 | 39388 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 414 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40926 | 6003200.97263054 | 2099519.74958744 | 37.745062524724204 | -122.43162276019501 | (37.7450625247242, -122.431622760195) | ||
| 56036 | 56036 | 42854 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2471 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 6 | Permit Number 42783 | 5987340.671 | 2098461.3118 | 37.74124459004229 | -122.486386476099 | (37.7412445900423, -122.486386476099) | |
| 56224 | 56224 | 50964 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 120 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 4 | Permit Number 47459 | 5996570.7873 | 2113602.9801 | 37.783353433045995 | -122.455566358041 | (37.783353433046, -122.455566358041) | ||
| 56274 | 56274 | 45450 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 191 Corona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44761 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
| 56362 | 56362 | 69494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 368 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 4 | Permit Number 33617 | 5999712.35805 | 2091715.6264799999 | 37.7234358783342 | -122.443125353647 | (37.7234358783342, -122.443125353647) | |
| 57263 | 57263 | 65499 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1520 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 2 | Permit Number 28383 | 5988131.2403 | 2099681.6905 | 37.7446414773793 | -122.48374245837299 | (37.7446414773793, -122.483742458373) | |
| 57598 | 57598 | 43283 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 872 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 6 | Permit Number 43052 | 6010937.3393 | 2090651.3857900002 | 37.72114734204379 | -122.404247572584 | (37.7211473420438, -122.404247572584) | |
| 58079 | 58079 | 178920 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5993797.37837 | 2086767.25523 | 37.7095097928145 | -122.463213309645 | (37.7095097928145, -122.463213309645) | ||||
| 58672 | 58672 | 58722 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 73 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1986 12:00:00 AM | Permit Number 22987 | 6002575.33914396 | 2108761.52820117 | 37.7704027479761 | -122.434446734741 | (37.7704027479761, -122.434446734741) | ||
| 58689 | 58689 | 53262 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1742 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1969 12:00:00 AM | 2 | Permit Number 6152 | 5987525.5316 | 2103414.2811 | 37.7548548926849 | -122.486110800407 | (37.7548548926849, -122.486110800407) | ||
| 58712 | 58712 | 46802 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 90 Ravenwood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44890 | 5994259.763524599 | 2095973.46470501 | 37.7348144532504 | -122.46228249422701 | (37.7348144532504, -122.462282494227) | ||
| 58719 | 58719 | 47693 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 469 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45492 | 6003825.81919033 | 2095934.94010265 | 37.7352548563783 | -122.429206586085 | (37.7352548563783, -122.429206586085) | ||
| 58886 | 58886 | 196424 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1427x Innes Ave | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6016113.33147 | 2096777.48422 | 37.7382562587307 | -122.386782500139 | (37.7382562587307, -122.386782500139) | ||||
| 58952 | 58952 | 36362 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 136 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39316 | 5995674.40918334 | 2093601.67196771 | 37.7283834402433 | -122.45722008615101 | (37.7283834402433, -122.457220086151) | ||
| 59112 | 59112 | 40021 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1530 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41266 | 6015759.6141 | 2095683.1757 | 37.73523191912879 | -122.387929152323 | (37.7352319191288, -122.387929152323) | |
| 60558 | 60558 | 72752 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1542 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1999 12:00:00 AM | 2 | 5988097.7754 | 2104798.077 | 37.758687755802995 | -122.484233325891 | (37.758687755803, -122.484233325891) | ||
| 60980 | 60980 | 70441 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2443 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 2 | 5982992.9824 | 2098498.3633 | 37.741091945342795 | -122.501421735716 | (37.7410919453428, -122.501421735716) | ||
| 61360 | 61360 | 83419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5988867.9747 | 2099162.5294 | 37.7432588555713 | -122.48115699763201 | (37.7432588555713, -122.481156997632) | |||
| 61486 | 61486 | 34637 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1466 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38317 | 5988079.0097 | 2105334.7239 | 37.7601601497095 | -122.484337584053 | (37.7601601497095, -122.484337584053) | ||
| 61537 | 61537 | 71798 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2126 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 1 | 5997657.8233 | 2109919.8494 | 37.7733028345136 | -122.451539910128 | (37.7733028345136, -122.451539910128) | ||
| 61631 | 61631 | 178909 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993779.42986 | 2086768.12245 | 37.70951113998979 | -122.463275405145 | (37.7095111399898, -122.463275405145) | ||||
| 61952 | 61952 | 44806 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1284 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 2 | Permit Number 43901 | 5987417.062999999 | 2106562.4256 | 37.7634925157287 | -122.486717065387 | (37.7634925157287, -122.486717065387) | |
| 62412 | 62412 | 71226 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2267 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987603.3648 | 2099853.8795 | 37.745083520509894 | -122.485580358953 | (37.7450835205099, -122.485580358953) | ||
| 62494 | 62494 | 35301 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3459 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1998 12:00:00 AM | Permit Number 38773 | 6005812.46547868 | 2106053.59345559 | 37.763150623964 | -122.423056990755 | (37.763150623964, -122.423056990755) | |||
| 62567 | 62567 | 49556 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 50 Arco Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2003 12:00:00 AM | 5 | Permit Number 46445 | 5999433.50359 | 2093069.00775 | 37.727136046271895 | -122.44418650420499 | (37.7271360462719, -122.444186504205) | ||
| 63096 | 63096 | 71170 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2127 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 8 | 5987570.8389 | 2100801.7844 | 37.747684319575 | -122.485762384494 | (37.747684319575, -122.485762384494) | ||
| 63241 | 63241 | 73536 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099831.4757 | 37.7450244421871 | -122.485434109471 | (37.7450244421871, -122.485434109471) | ||
| 63659 | 63659 | 38558 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1534 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40523 | 6015743.77247492 | 2095689.90327715 | 37.735249514063895 | -122.38798439240601 | (37.7352495140639, -122.387984392406) | ||
| 63938 | 63938 | 64516 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 709 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 15 | Permit Number 25397 | 6000497.1651 | 2111433.2992 | 37.7776205716937 | -122.441826907997 | (37.7776205716937, -122.441826907997) | |
| 64489 | 64489 | 178947 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 33 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6005285.02544 | 2093071.08332 | 37.727473839721206 | -122.42395798417101 | (37.7274738397212, -122.423957984171) | ||||
| 65110 | 65110 | 49209 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1901 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | 4 | Permit Number 46298 | 6001476.6938 | 2115031.787 | 37.7875568675655 | -122.438696309687 | (37.7875568675655, -122.438696309687) | ||
| 65590 | 65590 | 178916 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993790.44094 | 2086761.47706 | 37.7094935276652 | -122.46323686739599 | (37.7094935276652, -122.463236867396) | ||||
| 65666 | 65666 | 135911 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6011511.78534 | 2119057.5389799997 | 37.7991763890443 | -122.404260153176 | (37.7991763890443, -122.404260153176) | ||||
| 66160 | 66160 | 214405 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993807.85396 | 2096495.9519200001 | 37.73622304175571 | -122.46388280274701 | (37.7362230417557, -122.463882802747) | ||||
| 66194 | 66194 | 43721 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 655 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43361 | 5995440.43888004 | 2089883.51967293 | 37.718160841718394 | -122.45775999315399 | (37.7181608417184, -122.457759993154) | ||
| 66305 | 66305 | 54661 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 2 | Permit Number 10485 | 6012308.35839 | 2086909.49761 | 37.71094938168571 | -122.399245788885 | (37.7109493816857, -122.399245788885) | ||
| 66527 | 66527 | 178915 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993789.8911 | 2086758.89685 | 37.70948641134179 | -122.46323858062 | (37.7094864113418, -122.46323858062) | ||||
| 67287 | 67287 | 63267 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2679 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1986 12:00:00 AM | 4 | Permit Number 23823 | 5988937.7362 | 2097128.8354 | 37.7376789174614 | -122.480766928043 | (37.7376789174614, -122.480766928043) | ||
| 67795 | 67795 | 178907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993774.9758 | 2086763.55645 | 37.7094983462303 | -122.46329046790501 | (37.7094983462303, -122.463290467905) | ||||
| 68046 | 68046 | 71314 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 530 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2012 12:00:00 AM | 2 | Permit Number 769252 | 6003477.6405 | 2090266.5364299999 | 37.7196709718096 | -122.43000614527399 | (37.7196709718096, -122.430006145274) | |
| 68675 | 68675 | 72444 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1733 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1996 12:00:00 AM | 7 | 5999558.0145 | 2110143.3213 | 37.7740250637938 | -122.444982979337 | (37.7740250637938, -122.444982979337) | ||
| 69277 | 69277 | 43352 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4184 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | Permit Number 43104 | 6002499.60919335 | 2104164.95121467 | 37.7577773673085 | -122.43437999795 | (37.7577773673085, -122.43437999795) | ||
| 69325 | 69325 | 65957 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2451 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 6 | Permit Number 28979 | 5987645.5214 | 2098612.1125 | 37.741676413437794 | -122.48534348790501 | (37.7416764134378, -122.485343487905) | ||
| 70310 | 70310 | 43849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2638 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43471 | 5985246.7805 | 2097245.1976 | 37.73778319502121 | -122.49353671716999 | (37.7377831950212, -122.49353671717) | |
| 70581 | 70581 | 106985 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2010 12:00:00 AM | 4 | 6003795.2547 | 2114190.67 | 37.7853789990287 | -122.430614510729 | (37.7853789990287, -122.430614510729) | |||
| 70597 | 70597 | 30894 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 1 | Permit Number 34721 | 5996515.6245 | 2113531.2346 | 37.783153273367205 | -122.45575201055 | (37.7831532733672, -122.45575201055) | ||
| 71730 | 71730 | 31304 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005195.9419 | 2111461.818 | 37.7779654957454 | -122.425574267643 | (37.7779654957454, -122.425574267643) | |
| 71955 | 71955 | 34634 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1334 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2006 12:00:00 AM | 2 | Permit Number 48747 | 5988049.813999999 | 2106208.6368 | 37.762557976115104 | -122.48450265773701 | (37.7625579761151, -122.484502657737) | |
| 72111 | 72111 | 69039 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1465 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 3 | Permit Number 33045 | 5984314.5522 | 2105205.1639 | 37.759584498582896 | -122.497347291362 | (37.7595844985829, -122.497347291362) | |
| 73029 | 73029 | 61076 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2611 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1983 12:00:00 AM | 1 | Permit Number 20913 | 5999537.3607 | 2113600.286 | 37.783515821739705 | -122.445303028393 | (37.7835158217397, -122.445303028393) | |
| 73741 | 73741 | 37222 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2075 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39786 | 5986006.8021 | 2101124.4403 | 37.748478985005896 | -122.49119440423401 | (37.7484789850059, -122.491194404234) | |
| 74008 | 74008 | 70886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2145 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 13 | 5997606.572000001 | 2109869.8792 | 37.77316269418171 | -122.45171358914699 | (37.7731626941817, -122.451713589147) | ||
| 74143 | 74143 | 50554 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2231 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | 3 | Permit Number 47178 | 5988525.9734 | 2100109.7092 | 37.7458396735364 | -122.482408920531 | (37.7458396735364, -122.482408920531) | ||
| 74598 | 74598 | 135903 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6008339.85894 | 2119440.03353 | 37.8000488717233 | -122.41526322892 | (37.8000488717233, -122.41526322892) | ||||
| 74745 | 74745 | 31301 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 529 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 8 | Permit Number 34944 | 6005236.8177 | 2111465.8481 | 37.7779788709631 | -122.425433150534 | (37.7779788709631, -122.425433150534) | |
| 75226 | 75226 | 34636 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1466 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 4 | Permit Number 45216 | 5988080.2573 | 2105318.5059 | 37.760115692139394 | -122.48433207977399 | (37.7601156921394, -122.484332079774) | |
| 75758 | 75758 | 47310 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1107 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45241 | 6010288.16181634 | 2102764.77938432 | 37.7543718262723 | -122.407345121668 | (37.7543718262723, -122.407345121668) | ||
| 75915 | 75915 | 46075 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 126 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2001 12:00:00 AM | 4 | Permit Number 44456 | 5996572.8178 | 2113519.7283 | 37.7831249622244 | -122.455553314082 | (37.7831249622244, -122.455553314082) | ||
| 76367 | 76367 | 45053 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2275 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 4 | Permit Number 43938 | 5988225.1228 | 2099842.9977 | 37.7450898488188 | -122.483429658025 | (37.7450898488188, -122.483429658025) | |
| 76456 | 76456 | 178908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993776.62184 | 2086766.22044 | 37.7095057557476 | -122.463284972138 | (37.7095057557476, -122.463284972138) | ||||
| 76549 | 76549 | 44797 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1206 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 0 | Permit Number 43891 | 5989264.78401364 | 2107125.07259505 | 37.7651449362762 | -122.48036764782499 | (37.7651449362762, -122.480367647825) | |
| 76635 | 76635 | 38116 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1346 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 4 | Permit Number 40280 | 5987121.6044 | 2106101.731 | 37.7622103462776 | -122.487705101187 | (37.7622103462776, -122.487705101187) | |
| 76820 | 76820 | 66242 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 283 Tara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29340 | 5997754.61642905 | 2090213.33999682 | 37.7191991265322 | -122.449784665644 | (37.7191991265322, -122.449784665644) | ||
| 76848 | 76848 | 135910 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6011521.095380001 | 2119068.1217 | 37.799205966851 | -122.404228682307 | (37.799205966851, -122.404228682307) | ||||
| 77162 | 77162 | 42763 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
| 77341 | 77341 | 33704 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 196 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | Permit Number 37772 | 6003356.08500561 | 2108810.32684763 | 37.7705810245056 | -122.431749619478 | (37.7705810245056, -122.431749619478) | ||
| 77348 | 77348 | 50549 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
| 77360 | 77360 | 43354 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4226 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43105 | 6002331.77416149 | 2104155.95516802 | 37.757743138206 | -122.434959796908 | (37.757743138206, -122.434959796908) | ||
| 77370 | 77370 | 37268 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 77502 | 77502 | 42394 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 531 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42554 | 5997433.46765796 | 2095082.84468997 | 37.732551258555105 | -122.451245745641 | (37.7325512585551, -122.451245745641) | ||
| 77516 | 77516 | 63176 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1438 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23713 | 5992757.94867175 | 2105669.22551201 | 37.7613499376947 | -122.468179830058 | (37.7613499376947, -122.468179830058) | ||
| 77549 | 77549 | 36014 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 97 Winfield St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1998 12:00:00 AM | Permit Number 39160 | 6007176.510261099 | 2098875.10334415 | 37.743517008192796 | -122.41783033575001 | (37.7435170081928, -122.41783033575) | |||
| 77553 | 77553 | 64920 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2320 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1989 12:00:00 AM | Permit Number 25948 | 5991486.61980938 | 2099663.95831255 | 37.7447875370964 | -122.47213903609502 | (37.7447875370964, -122.472139036095) | ||
| 77608 | 77608 | 64036 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 444 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 24793 | 6008741.54974036 | 2096719.77289509 | 37.7376868940515 | -122.41226649546302 | (37.7376868940515, -122.412266495463) | ||
| 77678 | 77678 | 50789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6900 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2004 12:00:00 AM | Permit Number 47313 | 5985644.2903515 | 2112526.34575893 | 37.7797642444003 | -122.493287836243 | (37.7797642444003, -122.493287836243) | ||
| 77792 | 77792 | 44459 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 700 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2001 12:00:00 AM | Permit Number 43780 | 5992847.73856031 | 2102166.91818183 | 37.751738698088296 | -122.46761457722201 | (37.7517386980883, -122.467614577222) | |||
| 77817 | 77817 | 67647 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1980 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31246 | 6013237.51927358 | 2096157.49523352 | 37.736394256512206 | -122.39668225739901 | (37.7363942565122, -122.396682257399) | ||
| 77858 | 77858 | 40258 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3502 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 10 | Permit Number 41417 | 6006132.27744777 | 2102027.63127436 | 37.7521143101544 | -122.421664902947 | (37.7521143101544, -122.421664902947) | |
| 77887 | 77887 | 38952 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | ||
| 77910 | 77910 | 50059 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 246 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46789 | 6002684.4080652 | 2104459.13376981 | 37.758595609838096 | -122.433761913311 | (37.7585956098381, -122.433761913311) | ||
| 77921 | 77921 | 41587 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 48 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/19/2000 12:00:00 AM | Permit Number 42095 | 6000324.11613416 | 2101399.22119137 | 37.750059618615495 | -122.441705249653 | (37.7500596186155, -122.441705249653) | ||
| 77960 | 77960 | 68492 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1863 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32367 | 5993733.23917615 | 2102822.62397698 | 37.7535901848349 | -122.464600030151 | (37.7535901848349, -122.464600030151) | ||
| 78018 | 78018 | 45189 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 80 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44032 | 6009648.85827888 | 2099848.14474258 | 37.7463275924044 | -122.409350189836 | (37.7463275924044, -122.409350189836) |
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");