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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
95085 | 95085 | 68000 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1993 12:00:00 AM | Permit Number 31725 | 5995961.29385488 | 2091144.32738343 | 37.721652630536205 | -122.456050733712 | (37.7216526305362, -122.456050733712) | ||
45132 | 45132 | 179472 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 416 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003621.62429 | 2091003.33187 | 37.7217022030671 | -122.42956096376999 | (37.7217022030671, -122.42956096377) | |||
125428 | 125428 | 66993 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 325 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1992 12:00:00 AM | Permit Number 30346 | 5995859.19605633 | 2091190.56071344 | 37.7217737155135 | -122.45640699791299 | (37.7217737155135, -122.456406997913) | ||
98778 | 98778 | 67011 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 319 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30366 | 5995876.19861024 | 2091190.26348134 | 37.72177387546721 | -122.456348203392 | (37.7217738754672, -122.456348203392) | ||
146192 | 146192 | 67989 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 315 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31713 | 5995887.533650599 | 2091190.06532653 | 37.721773982086795 | -122.45630900702801 | (37.7217739820868, -122.456309007028) | ||
66106 | 66106 | 215000 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 315 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995844.93384 | 2091196.3600700002 | 37.7217888203826 | -122.456456717528 | (37.7217888203826, -122.456456717528) | |||
179056 | 179056 | 214998 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 325 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995781.08431 | 2091198.7105 | 37.721791608276895 | -122.456677597298 | (37.7217916082769, -122.456677597298) | |||
68087 | 68087 | 214999 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 325 Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995798.02713 | 2091198.56158 | 37.7217921721658 | -122.456619019966 | (37.7217921721658, -122.456619019966) | |||
78798 | 78798 | 107120 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 249 HOLLOWAY AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5996083.0 | 2091212.0 | 37.721845428506604 | -122.455634919471 | (37.7218454285066, -122.455634919471) | |||
49766 | 49766 | 214997 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 324 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5995789.64183 | 2091235.7059799999 | 37.721893680423 | -122.45665069048799 | (37.721893680423, -122.456650690488) | |||
68188 | 68188 | 30929 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 318 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 11 | Permit Number 34742 | 5995819.094930001 | 2091235.72912 | 37.7218954349953 | -122.45654888092899 | (37.7218954349953, -122.456548880929) | |
104824 | 104824 | 67990 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 324 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31715 | 5995860.10496142 | 2091242.55276948 | 37.7219165255419 | -122.45640761373998 | (37.7219165255419, -122.45640761374) | ||
68086 | 68086 | 30941 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1101 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 10 | Permit Number 34750 | 5995913.71268 | 2091275.1809 | 37.7220091920614 | -122.45622466453199 | (37.7220091920614, -122.456224664532) | |
74279 | 74279 | 217708 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1125 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5996389.2535 | 2091794.3451 | 37.723461980378104 | -122.454618335706 | (37.7234619803781, -122.454618335706) | |||
35663 | 35663 | 217714 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1199 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5996346.1405 | 2091806.7339 | 37.7234935241877 | -122.45476826329599 | (37.7234935241877, -122.454768263296) | |||
11462 | 11462 | 26316 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2049 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999538.37389 | 2091931.2083 | 37.7240178943838 | -122.443742263404 | (37.7240178943838, -122.443742263404) | |||
18100 | 18100 | 26318 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2031 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999629.75367 | 2092055.7224299998 | 37.7243649931268 | -122.443435318496 | (37.7243649931268, -122.443435318496) | |||
39322 | 39322 | 217596 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1637 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5994881.6994 | 2092227.6519 | 37.7245651536401 | -122.459861012566 | (37.7245651536401, -122.459861012566) | |||
113555 | 113555 | 25233 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1637 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 5994903.8518199995 | 2092233.64445 | 37.7245828817054 | -122.459784868939 | (37.7245828817054, -122.459784868939) | |||
99289 | 99289 | 62804 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1999 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23161 | 5999778.16418017 | 2092287.72080324 | 37.725010469703896 | -122.442938938279 | (37.7250104697039, -122.442938938279) | ||
12920 | 12920 | 26322 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1975 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999887.727969999 | 2092429.05718 | 37.7254047928689 | -122.44257033256201 | (37.7254047928689, -122.442570332562) | |||
99248 | 99248 | 62802 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1975 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23159 | 5999892.27432069 | 2092450.57844744 | 37.7254641444646 | -122.44255616077801 | (37.7254641444646, -122.442556160778) | ||
160292 | 160292 | 78534 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 240 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 11 | 6010805.4587900005 | 2092437.2546400002 | 37.7260435984308 | -122.404829115572 | (37.7260435984308, -122.404829115572) | ||
10386 | 10386 | 97218 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 539 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000286.32734 | 2092915.99472 | 37.7267645246623 | -122.441227336289 | (37.7267645246623, -122.441227336289) | |||
126216 | 126216 | 62829 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1901 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1986 12:00:00 AM | Permit Number 23194 | 6000247.30252359 | 2092964.84623807 | 37.7268964366151 | -122.441365747367 | (37.7268964366151, -122.441365747367) | ||
139104 | 139104 | 62796 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1872 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23153 | 6000282.71540486 | 2093136.39817936 | 37.7273694960454 | -122.441255629685 | (37.7273694960454, -122.441255629685) | ||
10986 | 10986 | 26279 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1866 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000327.26475 | 2093225.38093 | 37.7276163597935 | -122.441108004333 | (37.7276163597935, -122.441108004333) | |||
183235 | 183235 | 179488 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1309 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006965.96518 | 2093139.9461599998 | 37.7277576792711 | -122.418151834246 | (37.7277576792711, -122.418151834246) | |||
2263 | 2263 | 22364 | Landmark tree 9 | Schinus terebinthifolius :: Brazilian Pepper 25 | 5490X 03rd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | |||
119968 | 119968 | 104734 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 5490x 03RD ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 9x9 | 6014203.0 | 2093127.0 | 37.7281268221954 | -122.39313217573601 | (37.7281268221954, -122.393132175736) | |||
123840 | 123840 | 62827 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1835 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1986 12:00:00 AM | Permit Number 23192 | 6000500.63320764 | 2093420.59763273 | 37.728162253439706 | -122.44052266476999 | (37.7281622534397, -122.44052266477) | ||
136180 | 136180 | 122800 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1223 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6017230.3941 | 2093111.7012 | 37.7282525286375 | -122.382665199331 | (37.7282525286375, -122.382665199331) | |||
55379 | 55379 | 179487 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Capistrano Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6001448.45649 | 2093575.59463 | 37.728641765884106 | -122.437257104634 | (37.7286417658841, -122.437257104634) | |||
75649 | 75649 | 179486 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Capistrano Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6001448.8581300005 | 2093594.99443 | 37.7286950561315 | -122.437257104643 | (37.7286950561315, -122.437257104643) | |||
174119 | 174119 | 214198 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 165 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994046.026819999 | 2093769.8697900001 | 37.728751613593204 | -122.46286163516301 | (37.7287516135932, -122.462861635163) | |||
147089 | 147089 | 179485 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6001441.34691 | 2093639.06415 | 37.7288156345119 | -122.437286225591 | (37.7288156345119, -122.437286225591) | |||
179488 | 179488 | 214197 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 175 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994005.53316 | 2093797.66398 | 37.7288255972015 | -122.463003639022 | (37.7288255972015, -122.463003639022) | |||
47632 | 47632 | 62229 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 107 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 9 | Permit Number 22354 | 6001481.45016 | 2093645.47099 | 37.728835505929396 | -122.43714804475701 | (37.7288355059294, -122.437148044757) | |
180406 | 180406 | 62238 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2003 12:00:00 AM | 21 | Permit Number 22364 | 6001428.6005 | 2093653.6375099998 | 37.7288549250112 | -122.437331333801 | (37.7288549250112, -122.437331333801) | |
57606 | 57606 | 214196 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 185 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993973.13885 | 2093823.0159 | 37.7288933413334 | -122.46311746621599 | (37.7288933413334, -122.463117466216) | |||
94392 | 94392 | 68407 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 165 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32242 | 5993958.38777264 | 2093823.43780185 | 37.7288936500159 | -122.463168491943 | (37.7288936500159, -122.463168491943) | ||
147195 | 147195 | 215012 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 170 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994032.15409 | 2093824.6886099998 | 37.7289013336223 | -122.462913569218 | (37.7289013336223, -122.462913569218) | |||
92312 | 92312 | 68409 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 175 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32245 | 5993925.68682399 | 2093845.21689491 | 37.7289515662137 | -122.463283120302 | (37.7289515662137, -122.463283120302) | ||
119349 | 119349 | 68408 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 170 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32243 | 5994001.22714578 | 2093857.38366654 | 37.7289893248225 | -122.46302285625299 | (37.7289893248225, -122.463022856253) | ||
43559 | 43559 | 31153 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 45 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 10 | Permit Number 34856 | 5999668.77928 | 2093756.1386900002 | 37.729036168077705 | -122.443422496853 | (37.7290361680777, -122.443422496853) | |
153422 | 153422 | 62259 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 73 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | 9 | Permit Number 22385 | 6001393.61197 | 2093758.63795 | 37.729141243056105 | -122.43745980732099 | (37.7291412430561, -122.437459807321) | |
693 | 693 | 214190 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 393 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2009 12:00:00 AM | 17 | Width 3ft | Permit Number 53039 | 5992606.38416 | 2093945.5647200001 | 37.7291510025005 | -122.46785130231501 | (37.7291510025005, -122.467851302315) | |
100813 | 100813 | 62237 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 61 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | Permit Number 22363 | 6001374.44401127 | 2093790.00837779 | 37.7292262892939 | -122.437528318003 | (37.7292262892939, -122.437528318003) | ||
34304 | 34304 | 62258 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | Permit Number 22384 | 6001321.62543581 | 2093848.87962555 | 37.729384933111604 | -122.437715130621 | (37.7293849331116, -122.437715130621) | ||
94893 | 94893 | 62793 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1759 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23150 | 6000967.03927329 | 2093906.16285207 | 37.7295220513987 | -122.43894506891701 | (37.7295220513987, -122.438945068917) | ||
109083 | 109083 | 26334 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1759 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000966.441902901 | 2093906.9648093998 | 37.729524219400794 | -122.43894719153 | (37.7295242194008, -122.43894719153) | |||
139748 | 139748 | 62232 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 31 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | Permit Number 22358 | 6001252.08087827 | 2093926.39351405 | 37.7295938138913 | -122.437961102136 | (37.7295938138913, -122.437961102136) | ||
115766 | 115766 | 26335 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1751 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6001012.9907615995 | 2093941.6353855 | 37.7296220651879 | -122.438788751294 | (37.7296220651879, -122.438788751294) | |||
113178 | 113178 | 62792 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23149 | 6001049.88033752 | 2093967.86468253 | 37.7296961834546 | -122.438663099148 | (37.7296961834546, -122.438663099148) | ||
676 | 676 | 214191 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 363 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 14 | Width 3ft | Permit Number 10790 | 5992756.72765 | 2094187.53129 | 37.7298240632085 | -122.467349144256 | (37.7298240632085, -122.467349144256) | |
87892 | 87892 | 54921 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 363 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 13 | 4x6 | Permit Number 10790 | 5992776.0461415 | 2094204.68994573 | 37.7298722918639 | -122.467283605749 | (37.7298722918639, -122.467283605749) | |
685 | 685 | 214192 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 359 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 16 | Width 3ft | Permit Number 9509 | 5992777.37887 | 2094232.46292 | 37.7299486265111 | -122.46728101702 | (37.7299486265111, -122.46728101702) | |
167608 | 167608 | 214189 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 364 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992760.98003 | 2094267.6525299998 | 37.7300443017829 | -122.46734026706001 | (37.7300443017829, -122.46734026706) | |||
688 | 688 | 214188 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 358 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1972 12:00:00 AM | 21 | Width 3ft | Permit Number 9461 | 5992780.99407 | 2094319.4986599998 | 37.7301878137975 | -122.467274844971 | (37.7301878137975, -122.467274844971) | |
92161 | 92161 | 48868 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 351 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2002 12:00:00 AM | Permit Number 46076 | 5992826.30636272 | 2094323.11375055 | 37.7302003556086 | -122.467118458519 | (37.7302003556086, -122.467118458519) | |||
680 | 680 | 214193 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 347 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 19 | Width 3ft | Permit Number 9508 | 5992820.4639099995 | 2094345.69157 | 37.7302620114641 | -122.467140297392 | (37.7302620114641, -122.467140297392) | |
146285 | 146285 | 53817 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50398 | 5992946.10042753 | 2094372.20791552 | 37.730342070192 | -122.46670788548799 | (37.730342070192, -122.466707885488) | ||
77105 | 77105 | 214181 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 355 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5992570.4626400005 | 2094410.6821599999 | 37.7304260253276 | -122.468009303302 | (37.7304260253276, -122.468009303302) | |||
54130 | 54130 | 200066 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1563 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6015094.0337 | 2094004.9347 | 37.730586913455205 | -122.39011312209601 | (37.7305869134552, -122.390113122096) | |||
169541 | 169541 | 214180 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 350 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 3ft | 5992555.06379 | 2094476.42863 | 37.7306056595249 | -122.46806731945499 | (37.7306056595249, -122.468067319455) | |||
149551 | 149551 | 214194 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 335 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992857.93725 | 2094480.72645 | 37.730634946832296 | -122.46702056164601 | (37.7306349468323, -122.467020561646) | |||
151737 | 151737 | 214182 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 347 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992605.035 | 2094526.5774700001 | 37.7307462415431 | -122.467898209135 | (37.7307462415431, -122.467898209135) | |||
186374 | 186374 | 214195 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 333 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5992867.77854 | 2094524.25297 | 37.730755027909105 | -122.466989702314 | (37.7307550279091, -122.466989702314) | |||
54642 | 54642 | 214183 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 347 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5992610.48002 | 2094547.7964400002 | 37.730804817991704 | -122.467880927762 | (37.7308048179917, -122.467880927762) | |||
59752 | 59752 | 98611 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1537 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6015388.0762 | 2094133.544 | 37.730956353088004 | -122.38910554087299 | (37.730956353088, -122.389105540873) | |||
157493 | 157493 | 214184 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 333 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992621.78111 | 2094609.7810400003 | 37.730975664888895 | -122.467846365021 | (37.7309756648889, -122.467846365021) | |||
183293 | 183293 | 108585 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 36 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009820.40384 | 2094253.9343599998 | 37.7309767080873 | -122.408362486264 | (37.7309767080873, -122.408362486264) | |||
130526 | 130526 | 98610 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1537 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | 6015377.6336 | 2094141.2385 | 37.7309769017577 | -122.389142180051 | (37.7309769017577, -122.389142180051) | |||
98091 | 98091 | 112610 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 333 SANTA ANA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992649.0 | 2094625.0 | 37.7310190240744 | -122.46775337202101 | (37.7310190240744, -122.467753372021) | ||||
108895 | 108895 | 112609 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 333 SANTA ANA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992649.0 | 2094625.0 | 37.7310190240744 | -122.46775337202101 | (37.7310190240744, -122.467753372021) | ||||
22874 | 22874 | 179489 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 36 Goettingen St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6009813.802999999 | 2094277.0712700002 | 37.7310398674871 | -122.40838693792801 | (37.7310398674871, -122.408386937928) | |||
30904 | 30904 | 214185 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 333 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5992626.04523 | 2094642.7577 | 37.731066456833794 | -122.467834020931 | (37.7310664568338, -122.467834020931) | |||
117076 | 117076 | 108586 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 38 Goettingen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009809.0 | 2094307.0 | 37.731121776456796 | -122.408405653048 | (37.7311217764568, -122.408405653048) | ||||
159312 | 159312 | 214187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 326 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5992855.73996 | 2094664.9505099999 | 37.7311406536124 | -122.467041546448 | (37.7311406536124, -122.467041546448) | |||
171229 | 171229 | 214186 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 329 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992628.861169999 | 2094691.7651 | 37.7312011815816 | -122.46782784889 | (37.7312011815816, -122.46782784889) | |||
25617 | 25617 | 214202 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 80 El Verano Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5994588.98117 | 2094805.70057 | 37.7316270105613 | -122.461059668986 | (37.7316270105613, -122.461059668986) | |||
102317 | 102317 | 32425 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 275 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 36952 | 5994490.2461397005 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) | ||||
103250 | 103250 | 32424 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 275 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 36952 | 5994490.2461397005 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) | ||||
34902 | 34902 | 215020 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 501 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5998758.39397 | 2094948.38752 | 37.732257843614704 | -122.44665550384701 | (37.7322578436147, -122.446655503847) | |||
170597 | 170597 | 215011 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 240 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 5992624.77756 | 2095177.6880700001 | 37.7325351693537 | -122.467877296305 | (37.7325351693537, -122.467877296305) | |||
182269 | 182269 | 215010 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 220 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 5992623.69978 | 2095247.7676 | 37.7327275280451 | -122.467886117771 | (37.7327275280451, -122.467886117771) | |||
57971 | 57971 | 215009 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 220 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5992622.02484 | 2095272.1230799998 | 37.73279430540261 | -122.467893679258 | (37.7327943054026, -122.467893679258) | |||
186011 | 186011 | 215015 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Fernwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994765.23071 | 2095304.12361 | 37.7330056991393 | -122.460486446495 | (37.7330056991393, -122.460486446495) | |||
138250 | 138250 | 215016 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Rosewood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994826.24251 | 2095308.69182 | 37.7330217520514 | -122.460275845063 | (37.7330217520514, -122.460275845063) | |||
136198 | 136198 | 247576 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 350x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6008435.75806 | 2095170.56175 | 37.733415932988 | -122.413214248635 | (37.733415932988, -122.413214248635) | ||||
33555 | 33555 | 214199 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 159 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994376.25623 | 2095510.5029900002 | 37.7335499814343 | -122.46184618277 | (37.7335499814343, -122.46184618277) | |||
14374 | 14374 | 26131 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | |||
38840 | 38840 | 215014 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 158 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994270.1897599995 | 2095584.01107 | 37.7337457098893 | -122.462218211614 | (37.7337457098893, -122.462218211614) | |||
15206 | 15206 | 26133 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1504 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 5x5 | 6015522.1816 | 2095153.8991 | 37.7337654760523 | -122.388713114387 | (37.7337654760523, -122.388713114387) | |||
151449 | 151449 | 247579 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6008670.31016 | 2095309.15662 | 37.733809649895704 | -122.412413126286 | (37.7338096498957, -122.412413126286) | ||||
66500 | 66500 | 214200 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 145 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994280.889330001 | 2095617.0626299998 | 37.7338370774039 | -122.462183616499 | (37.7338370774039, -122.462183616499) | |||
41498 | 41498 | 214201 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 145 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994272.70142 | 2095629.8656 | 37.733871759758394 | -122.462212852568 | (37.7338717597584, -122.462212852568) | |||
153666 | 153666 | 197537 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 266 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6012934.68235 | 2095259.36475 | 37.7339113173389 | -122.39766632393601 | (37.7339113173389, -122.397666323936) | |||
14458 | 14458 | 94035 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 32 | 5x5 | 6015684.8669 | 2095240.1882 | 37.7340114236329 | -122.388156677838 | (37.7340114236329, -122.388156677838) | ||
15674 | 15674 | 94034 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6015674.4242 | 2095246.7836 | 37.7340289546749 | -122.388193241926 | (37.7340289546749, -122.388193241926) |
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");