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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68678 | 68678 | 217554 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 258 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5994397.0077 | 2088113.6647 | 37.7132412415717 | -122.461238438183 | (37.7132412415717, -122.461238438183) | |||
135125 | 135125 | 178874 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 190 Foote Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998666.63351 | 2088343.6345099998 | 37.7141174818994 | -122.446497740299 | (37.7141174818994, -122.446497740299) | |||
68703 | 68703 | 178875 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 190 Foote Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998646.9675199995 | 2088361.56482 | 37.7141655911394 | -122.446567002474 | (37.7141655911394, -122.446567002474) | |||
177236 | 177236 | 178894 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 38 Curtis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000524.98993 | 2088394.3572900002 | 37.714362726143 | -122.44007819877 | (37.714362726143, -122.44007819877) | |||
18656 | 18656 | 25472 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 205X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/1999 12:00:00 AM | 6 | 3X3 | 5993432.494 | 2088486.2672 | 37.714208763487896 | -122.46459914058599 | (37.7142087634879, -122.464599140586) | ||
22231 | 22231 | 25471 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 237 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993297.6081 | 2088487.2193 | 37.7142036007288 | -122.465065423908 | (37.7142036007288, -122.465065423908) | ||
20466 | 20466 | 18597 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1999 12:00:00 AM | 6 | 3X3 | 5992871.5273 | 2088492.4561 | 37.7141934014371 | -122.466538492306 | (37.7141934014371, -122.466538492306) | ||
46224 | 46224 | 91571 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 511 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52143 | 6010245.730359999 | 2088527.6355299999 | 37.71527728989071 | -122.40648870199 | (37.7152772898907, -122.40648870199) | |
144119 | 144119 | 50873 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 183 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | Permit Number 47383 | 5995201.42685987 | 2088679.26823835 | 37.714840517964 | -122.45849902539601 | (37.714840517964, -122.458499025396) | |||
154579 | 154579 | 214418 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 183 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995206.37473 | 2088687.6179099998 | 37.714863728550604 | -122.458482527651 | (37.7148637285506, -122.458482527651) | |||
72387 | 72387 | 178871 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 276 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998313.518130001 | 2088706.56781 | 37.7150938380738 | -122.44774434904801 | (37.7150938380738, -122.447744349048) | |||
89041 | 89041 | 84214 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Tucker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.580416299 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | ||
112903 | 112903 | 84224 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.580416299 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | ||
75548 | 75548 | 214421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 447 Head St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5993467.538240001 | 2088847.90842 | 37.715203764018796 | -122.46450425768101 | (37.7152037640188, -122.464504257681) | |||
63894 | 63894 | 178877 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 812 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002023.11476 | 2088969.20619 | 37.71602630823671 | -122.434941181287 | (37.7160263082367, -122.434941181287) | |||
24086 | 24086 | 178876 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | |||
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) |
19239 | 19239 | 40472 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 43 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | |||
108190 | 108190 | 40474 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 43 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | |||
108371 | 108371 | 40473 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 43 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | |||
119146 | 119146 | 40471 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 43 Lakeview Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | |||
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) | ||
132838 | 132838 | 178906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 109 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009976.781880001 | 2089389.92306 | 37.7176299046612 | -122.40747906690399 | (37.7176299046612, -122.407479066904) | |||
86444 | 86444 | 50722 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 495 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2004 12:00:00 AM | Permit Number 47274 | 6010067.71310756 | 2089419.28604179 | 37.717715618678206 | -122.40716682601999 | (37.7177156186782, -122.40716682602) | |||
88383 | 88383 | 50723 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 495 Wilde Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2004 12:00:00 AM | Permit Number 47274 | 6010067.71310756 | 2089419.28604179 | 37.717715618678206 | -122.40716682601999 | (37.7177156186782, -122.40716682602) | |||
72768 | 72768 | 178878 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 754 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001997.79635 | 2089434.8838799999 | 37.717303518220206 | -122.435061980046 | (37.7173035182202, -122.435061980046) | |||
165537 | 165537 | 178872 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003905.75349 | 2089465.8631799999 | 37.717496734867396 | -122.428469272232 | (37.7174967348674, -122.428469272232) | |||
54951 | 54951 | 178873 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003894.97731 | 2089471.2893700001 | 37.7175110241788 | -122.428506907095 | (37.7175110241788, -122.428506907095) | |||
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) | ||
48414 | 48414 | 40566 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 687 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 41611 | 6000998.28566 | 2089807.27388 | 37.7182692120226 | -122.43854347959801 | (37.7182692120226, -122.438543479598) | |||
146368 | 146368 | 178879 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 683 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002292.149780001 | 2089824.9266099997 | 37.718391198782 | -122.434072405644 | (37.718391198782, -122.434072405644) | |||
80652 | 80652 | 33821 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 56 Mill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/1985 12:00:00 AM | Permit Number 37837 | 6010417.94927739 | 2089844.96936421 | 37.7189040522027 | -122.40598618211901 | (37.7189040522027, -122.405986182119) | |||
32814 | 32814 | 214424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 732 Shields St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992045.199469999 | 2089870.8873400001 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | |||
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) | ||
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) | ||
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) | ||
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) | ||
87285 | 87285 | 50652 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Josiah Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | Permit Number 47234 | 5996870.80130055 | 2089899.24303395 | 37.718286082953604 | -122.452817003739 | (37.7182860829536, -122.452817003739) | |||
104618 | 104618 | 65461 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 745 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2007 12:00:00 AM | 3x3 | Permit Number 49756 | 5994584.49670969 | 2089901.01202032 | 37.7181596617168 | -122.46071986445101 | (37.7181596617168, -122.460719864451) | ||
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) | ||
152248 | 152248 | 178929 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 236 Niagara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999086.8403199995 | 2089914.7209 | 37.7184553195406 | -122.445158233389 | (37.7184553195406, -122.445158233389) | ||||
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) | ||
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) | ||
166733 | 166733 | 178880 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 641 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002434.092619999 | 2090051.35285 | 37.71902096971979 | -122.433597942217 | (37.7190209697198, -122.433597942217) | |||
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) | ||
55665 | 55665 | 178881 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 631 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002458.40291 | 2090087.03952 | 37.7191203367176 | -122.433516460014 | (37.7191203367176, -122.433516460014) | |||
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) | ||
68245 | 68245 | 214423 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 447 Bright St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5993753.592209999 | 2090152.37899 | 37.718802013579705 | -122.463610156194 | (37.7188020135797, -122.463610156194) | |||
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) | ||
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) | ||
72225 | 72225 | 103482 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 560 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6003141.00472 | 2090240.25972 | 37.719579750897104 | -122.431167899382 | (37.7195797508971, -122.431167899382) | |||
53380 | 53380 | 214420 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 466 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5993273.262130001 | 2090266.31835 | 37.7190871751261 | -122.465278724129 | (37.7190871751261, -122.465278724129) | |||
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) | |
62295 | 62295 | 178901 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 811 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008890.15805 | 2090268.5562 | 37.719981566167995 | -122.411297082012 | (37.719981566168, -122.411297082012) | |||
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) | ||
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) | ||
29059 | 29059 | 214419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 479 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5992969.97647 | 2090349.4269700001 | 37.7192978763685 | -122.466333093823 | (37.7192978763685, -122.466333093823) | |||
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) | ||
12710 | 12710 | 37830 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/09/2007 12:00:00 AM | 3 | 6x6 | Permit Number 49480 | 6003635.85955 | 2090436.9204099998 | 37.7201477680848 | -122.429471383195 | (37.7201477680848, -122.429471383195) |
11797 | 11797 | 37838 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003644.26117 | 2090451.27602 | 37.720187661114295 | -122.429443364835 | (37.7201876611143, -122.429443364835) |
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) | ||
10557 | 10557 | 37839 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003658.0147400005 | 2090473.5929 | 37.720249717041504 | -122.42939741397 | (37.7202497170415, -122.42939741397) |
126541 | 126541 | 84824 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 845 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | Permit No. 49256 | 5996978.8 | 2090483.4 | 37.7198962296133 | -122.45248583240802 | (37.7198962296133, -122.452485832408) | |||
141101 | 141101 | 84825 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 845 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | Permit No. 49256 | 5996978.8 | 2090483.4 | 37.7198962296133 | -122.45248583240802 | (37.7198962296133, -122.452485832408) | |||
13085 | 13085 | 37840 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/09/2007 12:00:00 AM | 3 | 4x6 | Permit Number 49480 | 6003672.4294 | 2090496.5417099998 | 37.7203135455184 | -122.42934922289801 | (37.7203135455184, -122.429349222898) |
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) | ||
153541 | 153541 | 178882 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003684.48265 | 2090515.01932 | 37.7203649633559 | -122.4293088757 | (37.7203649633559, -122.4293088757) | |||
151052 | 151052 | 178883 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003694.22054 | 2090531.28472 | 37.7204101758585 | -122.42927637423 | (37.7204101758585, -122.42927637423) | |||
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) | ||
46837 | 46837 | 178884 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003708.27118 | 2090552.3037299998 | 37.720468684870504 | -122.42922930371599 | (37.7204686848705, -122.429229303716) | |||
70625 | 70625 | 178891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 579 Madrid St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6002452.87445 | 2090566.89512 | 37.720437599790394 | -122.43356984466999 | (37.7204375997904, -122.43356984467) | |||
72821 | 72821 | 178885 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003721.71366 | 2090575.2726099999 | 37.720532513349106 | -122.42918447430401 | (37.7205325133491, -122.429184474304) | |||
178144 | 178144 | 178886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6003733.07859 | 2090591.8271 | 37.7205786116989 | -122.42914636912501 | (37.7205786116989, -122.429146369125) | |||
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) | ||
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) |
184613 | 184613 | 178887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6003747.16271 | 2090614.46015 | 37.720641554351296 | -122.429099297695 | (37.7206415543513, -122.429099297695) | |||
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) | |
55503 | 55503 | 178889 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 487 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003437.2188 | 2090630.2109400001 | 37.720667252470996 | -122.430171799494 | (37.720667252471, -122.430171799494) | |||
131822 | 131822 | 178888 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6003758.58722 | 2090633.91893 | 37.7206956305865 | -122.42906119342501 | (37.7206956305865, -122.429061193425) | |||
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) | |
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) | ||
176135 | 176135 | 214422 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 529 Bright St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993759.81051 | 2090686.52668 | 37.7202690128731 | -122.463627407878 | (37.7202690128731, -122.463627407878) | |||
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) | ||
154431 | 154431 | 178903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011814.45609 | 2090752.0893599999 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | |||
157212 | 157212 | 93809 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 460 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2010 12:00:00 AM | 3 | Permit Number 57622 | 6003467.08848 | 2090756.16475 | 37.7210147855714 | -122.43007752986999 | (37.7210147855714, -122.43007752987) | ||
54864 | 54864 | 178902 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6011813.97335 | 2090761.03311 | 37.721497357285706 | -122.401224985361 | (37.7214973572857, -122.401224985361) | |||
27753 | 27753 | 178904 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011792.88406 | 2090769.7339700002 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | |||
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) | ||
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) | ||
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) | ||
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) |
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");