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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117477 | 117477 | 37344 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 571 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39852 | 5999120.28976365 | 2086823.35415522 | 37.7099690371181 | -122.444820521553 | (37.7099690371181, -122.444820521553) | ||
10668 | 10668 | 108896 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 312 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772786 | 6000205.0169 | 2087170.16849 | 37.7109831566161 | -122.441096373403 | (37.7109831566161, -122.441096373403) |
44585 | 44585 | 37353 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 131 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 4 | Permit Number 39859 | 6000725.3710199995 | 2087720.25032 | 37.7125231844795 | -122.43933731388 | (37.7125231844795, -122.43933731388) | |
27021 | 27021 | 95729 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 247 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767475 | 6004014.48263 | 2088996.54653 | 37.7162142458739 | -122.428060019581 | (37.7162142458739, -122.428060019581) |
103053 | 103053 | 40468 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 111 Caine Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41553 | 5997316.73360061 | 2089179.17157647 | 37.71633447730439 | -122.45122371003599 | (37.7163344773044, -122.451223710036) | ||
101489 | 101489 | 34809 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 55 Rome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38444 | 5999172.71597008 | 2089296.17855447 | 37.716761844805795 | -122.444816960418 | (37.7167618448058, -122.444816960418) | ||
32627 | 32627 | 78659 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 238 Ottawa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 5 | 5998369.991909999 | 2089313.5256400001 | 37.7167636327026 | -122.447592817774 | (37.7167636327026, -122.447592817774) | ||
110971 | 110971 | 38915 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 147 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40726 | 5991915.47880902 | 2089512.34448242 | 37.7169385510534 | -122.469917148086 | (37.7169385510534, -122.469917148086) | ||
128630 | 128630 | 38916 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 151 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40727 | 5991915.78904323 | 2089537.41535132 | 37.7170074074891 | -122.46991790012301 | (37.7170074074891, -122.469917900123) | ||
58289 | 58289 | 95775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 674 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767509 | 6002729.6643199995 | 2089587.30224 | 37.7177635556125 | -122.432543138167 | (37.7177635556125, -122.432543138167) |
113456 | 113456 | 51244 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 31 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47619 | 5997384.45837141 | 2089741.12682177 | 37.7178813535714 | -122.451030121405 | (37.7178813535714, -122.451030121405) | ||
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) | ||
118465 | 118465 | 66236 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 727 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29334 | 5994760.98118392 | 2089897.08979712 | 37.7181590447559 | -122.460109553503 | (37.7181590447559, -122.460109553503) | ||
114939 | 114939 | 43722 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 663 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43362 | 5995378.9819826 | 2089884.66693766 | 37.7181604610324 | -122.457972504918 | (37.7181604610324, -122.457972504918) | ||
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) | ||
145664 | 145664 | 50427 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 575 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47080 | 5996062.43497228 | 2089871.90840865 | 37.718164673097 | -122.45560919316799 | (37.718164673097, -122.455609193168) | ||
98315 | 98315 | 38920 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 748 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40730 | 5994545.96417904 | 2089953.8830186 | 37.718302615811794 | -122.460856883631 | (37.7183026158118, -122.460856883631) | ||
78236 | 78236 | 43735 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 14 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43372 | 5996531.68905486 | 2089965.7239711003 | 37.7184491858628 | -122.453993963558 | (37.7184491858628, -122.453993963558) | ||
108465 | 108465 | 45358 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 434 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44766 | 5993275.26942875 | 2090069.89309509 | 37.7185479545501 | -122.465257525662 | (37.7185479545501, -122.465257525662) | ||
146227 | 146227 | 45359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 438 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44767 | 5993275.62106747 | 2090094.58069454 | 37.718615761020004 | -122.46525810245701 | (37.71861576102, -122.465258102457) | ||
93255 | 93255 | 66254 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 930 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29355 | 5995057.552477599 | 2090124.39622258 | 37.7188002278135 | -122.45910089062099 | (37.7188002278135, -122.459100890621) | ||
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) | ||
95446 | 95446 | 47355 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 375 Ralston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45280 | 5992186.942845901 | 2090329.99196799 | 37.7191993003756 | -122.46903830903099 | (37.7191993003756, -122.469038309031) | ||
138499 | 138499 | 47354 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 375 Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45280 | 5992186.942845901 | 2090329.99196799 | 37.7191993003756 | -122.46903830903099 | (37.7191993003756, -122.469038309031) | ||
82428 | 82428 | 50018 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 375 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46752 | 5992447.36096557 | 2090326.79664317 | 37.7192055701762 | -122.46813791817101 | (37.7192055701762, -122.468137918171) | ||
102760 | 102760 | 43716 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 66 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43357 | 5994471.63688238 | 2090356.83767318 | 37.7194047560126 | -122.461142992014 | (37.7194047560126, -122.461142992014) | ||
78401 | 78401 | 49775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
92628 | 92628 | 49774 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
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) | |
144613 | 144613 | 52967 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 430 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48951 | 5992913.39477217 | 2090514.51004168 | 37.7197478895212 | -122.466540666402 | (37.7197478895212, -122.466540666402) | ||
141140 | 141140 | 47334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 Garfield St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45265 | 5993656.96278859 | 2090531.97182441 | 37.719838715813104 | -122.463971702484 | (37.7198387158131, -122.463971702484) | ||
95077 | 95077 | 66229 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 219 Tara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29326 | 5997887.19527776 | 2090462.5095334998 | 37.7198908728412 | -122.449344335824 | (37.7198908728412, -122.449344335824) | ||
86624 | 86624 | 45788 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 524 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45272 | 5995257.5395659 | 2090592.77790767 | 37.7200977875118 | -122.458443505078 | (37.7200977875118, -122.458443505078) | ||
30204 | 30204 | 74333 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2002 12:00:00 AM | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | ||
101871 | 101871 | 45312 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 333 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44759 | 5991931.79579935 | 2090744.40687829 | 37.7203224367541 | -122.46995040481701 | (37.7203224367541, -122.469950404817) | ||
109806 | 109806 | 43736 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 114 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43373 | 5996541.98319278 | 2090652.82083499 | 37.720336382823 | -122.45400797708 | (37.720336382823, -122.45400797708) | ||
107519 | 107519 | 45309 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 238 Beverly St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44147 | 5991464.05254061 | 2090792.05998046 | 37.7204262308827 | -122.47157069513099 | (37.7204262308827, -122.471570695131) | ||
89772 | 89772 | 45349 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 442 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44764 | 5992505.35292147 | 2090807.04622062 | 37.7205275676125 | -122.467972377091 | (37.7205275676125, -122.467972377091) | ||
107930 | 107930 | 38910 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 542 Arch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40722 | 5992764.33916068 | 2090804.00808724 | 37.7205341782239 | -122.46707693098999 | (37.7205341782239, -122.46707693099) | ||
156668 | 156668 | 70126 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 518 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 4 | 3x3 | Permit Number 767414 | 6003049.75959 | 2090601.9090200001 | 37.720567588703105 | -122.43150910488701 | (37.7205675887031, -122.431509104887) |
138003 | 138003 | 70633 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 514 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 1 | 3x3 | 6003062.45597 | 2090620.0521099998 | 37.720618125211 | -122.43146651207898 | (37.720618125211, -122.431466512079) | |
92867 | 92867 | 47347 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 752 Head St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45273 | 5993544.85331051 | 2090864.0101395 | 37.7207439512448 | -122.464383317404 | (37.7207439512448, -122.464383317404) | ||
143946 | 143946 | 47346 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 752 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45273 | 5993544.85331051 | 2090864.0101395 | 37.7207439512448 | -122.464383317404 | (37.7207439512448, -122.464383317404) | ||
109783 | 109783 | 45351 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 455 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44765 | 5992454.32883637 | 2090891.06433755 | 37.7207553141827 | -122.46815485821001 | (37.7207553141827, -122.46815485821) | ||
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) | |
138659 | 138659 | 50492 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 482 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47128 | 6002953.58784191 | 2090964.55788787 | 37.7215578906721 | -122.43186742076999 | (37.7215578906721, -122.43186742077) | ||
189022 | 189022 | 43336 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 423 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 6 | Permit Number 43093 | 6003416.5357 | 2091104.1943299999 | 37.7219675345615 | -122.430277093028 | (37.7219675345615, -122.430277093028) | |
129270 | 129270 | 43334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 358 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | Permit Number 43091 | 6004071.746453701 | 2091218.44428208 | 37.722318330594604 | -122.428020331334 | (37.7223183305946, -122.428020331334) | ||
93423 | 93423 | 67988 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 229 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31712 | 5995619.71812081 | 2091466.36929796 | 37.7225172692023 | -122.457254747849 | (37.7225172692023, -122.457254747849) | ||
143757 | 143757 | 45440 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 670 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/2001 12:00:00 AM | Permit Number 44227 | 5993413.9529017 | 2091571.4332661 | 37.7226788173129 | -122.46488714503201 | (37.7226788173129, -122.464887145032) | ||
103451 | 103451 | 45442 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 681 Victoria St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44769 | 5993403.20841917 | 2091649.07320251 | 37.7228913782095 | -122.464929921893 | (37.7228913782095, -122.464929921893) | ||
143463 | 143463 | 45441 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 681 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44769 | 5993403.20841917 | 2091649.07320251 | 37.7228913782095 | -122.464929921893 | (37.7228913782095, -122.464929921893) | ||
140485 | 140485 | 45444 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 685 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44774 | 5993415.59875518 | 2091668.68191392 | 37.7229459333721 | -122.464888514787 | (37.7229459333721, -122.464888514787) | ||
143059 | 143059 | 45443 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 685 Victoria St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44774 | 5993415.59875518 | 2091668.68191392 | 37.7229459333721 | -122.464888514787 | (37.7229459333721, -122.464888514787) | ||
132335 | 132335 | 43320 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 283 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 4 | Permit Number 43083 | 6004355.20098 | 2091606.0340900002 | 37.7233985996382 | -122.427068088028 | (37.7233985996382, -122.427068088028) | |
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) | |
129281 | 129281 | 62182 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 15 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1985 12:00:00 AM | Permit Number 22299 | 6000249.38294622 | 2091710.97820224 | 37.7234537213114 | -122.44126862873001 | (37.7234537213114, -122.44126862873) | ||
98221 | 98221 | 62778 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 359 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23133 | 5999779.18606698 | 2091746.98091779 | 37.7235257806679 | -122.442896592659 | (37.7235257806679, -122.442896592659) | ||
145257 | 145257 | 48941 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1343 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46128 | 6011661.44049501 | 2091503.35733972 | 37.7235271168325 | -122.401804405977 | (37.7235271168325, -122.401804405977) | ||
88065 | 88065 | 34303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1219 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38091 | 6011656.31212487 | 2091520.16541192 | 37.7235729821535 | -122.40182331486 | (37.7235729821535, -122.40182331486) | ||
106934 | 106934 | 48938 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1213 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46126 | 6011656.06397948 | 2091520.97870067 | 37.7235752014293 | -122.40182422980101 | (37.7235752014293, -122.401824229801) | ||
95411 | 95411 | 48937 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1211 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47623 | 6011655.9812658 | 2091521.24979215 | 37.7235759411749 | -122.401824534776 | (37.7235759411749, -122.401824534776) | ||
117722 | 117722 | 39200 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 37 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40851 | 6000146.50552582 | 2091764.31450516 | 37.7235943096691 | -122.44162808198 | (37.7235943096691, -122.44162808198) | ||
84180 | 84180 | 62175 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 47 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1985 12:00:00 AM | Permit Number 22291 | 6000099.74307909 | 2091788.55827035 | 37.7236582130811 | -122.44179147021099 | (37.7236582130811, -122.441791470211) | ||
26064 | 26064 | 43329 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 4 | Permit Number 43087 | 6003232.20541 | 2091824.6572900002 | 37.7239353231315 | -122.43096566975402 | (37.7239353231315, -122.430965669754) | |
83505 | 83505 | 62168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 72 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/06/1985 12:00:00 AM | Permit Number 22284 | 6000004.62747849 | 2091896.44349016 | 37.7239490209961 | -122.442128007983 | (37.7239490209961, -122.442128007983) | ||
102699 | 102699 | 66253 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 536 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29354 | 5994796.549278201 | 2092045.80641292 | 37.7240609523315 | -122.460142195142 | (37.7240609523315, -122.460142195142) | ||
109914 | 109914 | 45392 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 321 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44757 | 5994154.29510802 | 2092092.46668837 | 37.7241521077919 | -122.462365734931 | (37.7241521077919, -122.462365734931) | ||
120338 | 120338 | 45393 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 321 Ashton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44757 | 5994154.29510802 | 2092092.46668837 | 37.7241521077919 | -122.462365734931 | (37.7241521077919, -122.462365734931) | ||
158113 | 158113 | 65196 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 326 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 4 | Permit Number 27181 | 6003265.18452 | 2091962.93655 | 37.7243168758021 | -122.43086153005501 | (37.7243168758021, -122.430861530055) | |
95670 | 95670 | 68086 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 848 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31825 | 6001069.78392059 | 2092016.09827478 | 37.7243382114504 | -122.43845450853998 | (37.7243382114504, -122.43845450854) | ||
106265 | 106265 | 62485 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 294 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22656 | 5999878.28397028 | 2092047.35169708 | 37.724356179134205 | -122.442575585932 | (37.7243561791342, -122.442575585932) | ||
90954 | 90954 | 40399 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41505 | 5995604.87049652 | 2092238.79242045 | 37.7246373060188 | -122.457361926036 | (37.7246373060188, -122.457361926036) | ||
122690 | 122690 | 40398 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41505 | 5995604.87049652 | 2092238.79242045 | 37.7246373060188 | -122.457361926036 | (37.7246373060188, -122.457361926036) | ||
142993 | 142993 | 62195 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 105 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1985 12:00:00 AM | Permit Number 22314 | 6000493.57908868 | 2092148.88322612 | 37.7246700159736 | -122.440455881068 | (37.7246700159736, -122.440455881068) | ||
93452 | 93452 | 46779 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 91 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44870 | 6001525.5890631 | 2092130.31455081 | 37.724677740092 | -122.43688703011601 | (37.724677740092, -122.436887030116) | ||
111304 | 111304 | 43319 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 275 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2013 12:00:00 AM | 3x3 | Permit Number 770290 | 6003728.19858152 | 2092097.28955871 | 37.7247120025434 | -122.429270532313 | (37.7247120025434, -122.429270532313) | |
141213 | 141213 | 52530 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 San Juan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48628 | 6001389.835788901 | 2092264.63848184 | 37.725038846492794 | -122.43736592524701 | (37.7250388464928, -122.437365925247) | ||
110676 | 110676 | 49130 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 145 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46259 | 5995112.54626124 | 2092443.49915855 | 37.725171091693 | -122.459078632454 | (37.725171091693, -122.459078632454) | ||
113424 | 113424 | 36445 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1263 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46501 | 5995833.83744398 | 2092429.73059369 | 37.725174725138295 | -122.456584222912 | (37.7251747251383, -122.456584222912) | ||
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) | ||
95071 | 95071 | 46636 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 191 Corona St | 2 | 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) | ||
106577 | 106577 | 40409 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 132 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41511 | 5995166.097552099 | 2092475.68358203 | 37.7252625407548 | -122.458895841519 | (37.7252625407548, -122.458895841519) | ||
115757 | 115757 | 40410 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 132 Southwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41511 | 5995166.097552099 | 2092475.68358203 | 37.7252625407548 | -122.458895841519 | (37.7252625407548, -122.458895841519) | ||
83314 | 83314 | 36446 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1266 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39349 | 5995876.3540718 | 2092492.32516722 | 37.7253490358477 | -122.456441772407 | (37.7253490358477, -122.456441772407) | ||
116365 | 116365 | 62497 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 130 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22669 | 6000642.74847109 | 2092487.44183284 | 37.7256081131818 | -122.439964486743 | (37.7256081131818, -122.439964486743) | ||
127195 | 127195 | 38189 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 541 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/16/2013 12:00:00 AM | Permit Number 770070 | 6011097.98403945 | 2092306.25144746 | 37.7257002373273 | -122.403808654284 | (37.7257002373273, -122.403808654284) | ||
19752 | 19752 | 38951 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Urbano Dr | 2 | 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) | ||
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) | ||
83263 | 83263 | 36386 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
90511 | 90511 | 36385 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
98369 | 98369 | 36387 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
120418 | 120418 | 36384 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
104578 | 104578 | 37887 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1301 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40164 | 5995819.25622169 | 2092686.22988595 | 37.725878173698796 | -122.45665316971001 | (37.7258781736988, -122.45665316971) | ||
134121 | 134121 | 37055 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 283 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 8 | Permit Number 39660 | 6006018.75197 | 2092482.1087099998 | 37.7258980404498 | -122.421379675536 | (37.7258980404498, -122.421379675536) | |
78957 | 78957 | 49137 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) | ||
118253 | 118253 | 49138 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) | ||
122559 | 122559 | 49139 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) | ||
127980 | 127980 | 43280 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 731 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43050 | 6009363.88058907 | 2092426.70066476 | 37.725933936273606 | -122.409811838204 | (37.7259339362736, -122.409811838204) | ||
78556 | 78556 | 40389 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 706 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41499 | 5994916.05908376 | 2092743.92651485 | 37.725984695353105 | -122.459779615207 | (37.7259846953531, -122.459779615207) |
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");