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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
83117 | 83117 | 14776 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 06/30/1994 12:00:00 AM | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
122469 | 122469 | 14777 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | |||
15868 | 15868 | 16559 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 702X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015638.3263 | 2097400.20162 | 37.7399398030878 | -122.388468300865 | (37.7399398030878, -122.388468300865) | |||
96864 | 96864 | 16562 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 700X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015552.29216 | 2097280.01448 | 37.7396050257983 | -122.388757385673 | (37.7396050257983, -122.388757385673) | |||
117166 | 117166 | 17371 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5999379.151930001 | 2109268.47217 | 37.771612740675394 | -122.44553877169399 | (37.7716127406754, -122.445538771694) | |||
7331 | 7331 | 18088 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3000 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999530.9574 | 2114697.1427 | 37.7865271393644 | -122.445404074823 | (37.7865271393644, -122.445404074823) | |||
9240 | 9240 | 18089 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3000 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5999515.0867 | 2114695.0726 | 37.786520549411996 | -122.445458834419 | (37.786520549412, -122.445458834419) | |||
104059 | 104059 | 19296 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 40X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5995496.87098 | 2110852.98465 | 37.775740993063394 | -122.459082470822 | (37.7757409930634, -122.459082470822) | |||
96083 | 96083 | 19297 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 40X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5995496.87098 | 2110852.98465 | 37.775740993063394 | -122.459082470822 | (37.7757409930634, -122.459082470822) | |||
100314 | 100314 | 19298 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 40X CABRILLO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5995512.0 | 2110798.0 | 37.7755908894339 | -122.459026153947 | (37.7755908894339, -122.459026153947) | |||
11322 | 11322 | 19745 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
108652 | 108652 | 21148 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2292X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
82650 | 82650 | 21149 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2292X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
105178 | 105178 | 21150 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2292X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
118849 | 118849 | 21843 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 148 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5995171.12407 | 2111491.00238 | 37.77747408905871 | -122.460255539349 | (37.7774740890587, -122.460255539349) | |||
180937 | 180937 | 21849 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 199X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2014 12:55:00 PM | 13 | 3X3 | 5995162.858440001 | 2110756.0721 | 37.7754556898629 | -122.460230872912 | (37.7754556898629, -122.460230872912) | ||
44525 | 44525 | 21850 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 199X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5995144.904080001 | 2110755.8457 | 37.775454035467796 | -122.46029296446699 | (37.7754540354678, -122.460292964467) | |||
91463 | 91463 | 21851 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 199X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5995125.29913 | 2110753.8462799997 | 37.7754474178474 | -122.46036063726801 | (37.7754474178474, -122.460360637268) | |||
81830 | 81830 | 21852 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 199X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5995138.68645 | 2110755.95244 | 37.775453970893004 | -122.460314480311 | (37.775453970893, -122.460314480311) | |||
78791 | 78791 | 21853 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 199X Cabrillo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5995153.19322 | 2110756.08274 | 37.7754551631243 | -122.46026430774201 | (37.7754551631243, -122.460264307742) | |||
108026 | 108026 | 21856 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 215X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2003 12:00:00 AM | 18 | 4.5X4.5 | 5994989.01038 | 2110754.0886 | 37.775440242331705 | -122.460832106591 | (37.7754402423317, -122.460832106591) | ||
97107 | 97107 | 21857 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 215X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4.5X4.5 | 5994989.01038 | 2110754.0886 | 37.775440242331705 | -122.460832106591 | (37.7754402423317, -122.460832106591) | |||
16050 | 16050 | 22178 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3950X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015635.4577 | 2097953.7776 | 37.7414596503706 | -122.38851684958999 | (37.7414596503706, -122.38851684959) | |||
16514 | 16514 | 22196 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4049 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015606.879 | 2097560.5249 | 37.7403782752921 | -122.38858822178001 | (37.7403782752921, -122.38858822178) | |||
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) | |||
1073 | 1073 | 22619 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1107 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6004653.0794 | 2112584.8191 | 37.7810182911755 | -122.42753224810801 | (37.7810182911755, -122.427532248108) | |||
79047 | 79047 | 22632 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1171 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6004419.15464 | 2112535.54329 | 37.7808697581914 | -122.428337997055 | (37.7808697581914, -122.428337997055) | |||
141439 | 141439 | 22636 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1181 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 3X3 | 6004533.51826 | 2112418.26728 | 37.780554217860704 | -122.427933997943 | (37.7805542178607, -122.427933997943) | |||
87625 | 87625 | 22676 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1340 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003587.617269999 | 2112577.2889400003 | 37.780937293905204 | -122.431217671135 | (37.7809372939052, -122.431217671135) | |||
20738 | 20738 | 22897 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 201 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006097.55508 | 2108434.56296 | 37.7697042853598 | -122.422240130676 | (37.7697042853598, -122.422240130676) | |||
7015 | 7015 | 23458 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2252 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 4X4 | 6005965.50421 | 2118183.1057 | 37.7964639393172 | -122.423390011952 | (37.7964639393172, -122.423390011952) | |||
88014 | 88014 | 23587 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3251X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.42585514440701 | (37.8066799978444, -122.425855144407) | |||
18205 | 18205 | 24291 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006664.25165 | 2098042.76581 | 37.7412027542911 | -122.41954256203998 | (37.7412027542911, -122.41954256204) | |||
104485 | 104485 | 24342 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600X 39th Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
21799 | 21799 | 24344 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 95 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006121.89128 | 2108467.81183 | 37.7697969514995 | -122.42215831485201 | (37.7697969514995, -122.422158314852) | |||
20052 | 20052 | 24345 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 95 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6006134.19272 | 2108466.72229 | 37.7697946537198 | -122.42211568701201 | (37.7697946537198, -122.422115687012) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
2267 | 2267 | 27407 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2172 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997059.3832 | 2109492.2362 | 37.772094431296104 | -122.453579103335 | (37.7720944312961, -122.453579103335) | ||
139641 | 139641 | 27408 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2178 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997039.15745 | 2109490.68407 | 37.7720890100789 | -122.453648953362 | (37.7720890100789, -122.453648953362) | ||
84221 | 84221 | 27409 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2178 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997014.41754 | 2109490.27003 | 37.7720864549253 | -122.453734500333 | (37.7720864549253, -122.453734500333) | ||
1630 | 1630 | 27410 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2184 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1999 12:00:00 AM | 8 | 3X3 | 5997011.7697 | 2109487.1799 | 37.7720778184275 | -122.453743436192 | (37.7720778184275, -122.453743436192) | ||
950 | 950 | 27411 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2198 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5996975.1116 | 2109480.4382 | 37.7720572057802 | -122.453869751853 | (37.7720572057802, -122.453869751853) | ||
14494 | 14494 | 28530 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | Permit Number 769387 | 6010745.98493 | 2111818.73382 | 37.77925753794229 | -122.40639976265301 | (37.7792575379423, -122.406399762653) | ||
14450 | 14450 | 28531 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2012 12:00:00 AM | 18 | 3X3 | Permit Number 769387 | 6010735.412690001 | 2111831.43795 | 37.77929182908439 | -122.406437232011 | (37.7792918290844, -122.406437232011) | |
16574 | 16574 | 28532 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | Permit Number 769387 | 6010727.06736 | 2111841.54231 | 37.7793191064344 | -122.40646681431299 | (37.7793191064344, -122.406466814313) | ||
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) | |
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) | |
83675 | 83675 | 30943 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
117473 | 117473 | 30944 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
104653 | 104653 | 30945 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
110730 | 110730 | 30946 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
140220 | 140220 | 30947 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
113251 | 113251 | 30948 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
128172 | 128172 | 30949 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
118095 | 118095 | 30950 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
140906 | 140906 | 30951 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
116067 | 116067 | 30952 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
116980 | 116980 | 30953 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
126022 | 126022 | 30954 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
111649 | 111649 | 30955 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
143755 | 143755 | 30956 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
102389 | 102389 | 30957 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
114702 | 114702 | 30958 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
106242 | 106242 | 30959 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2401 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34753 | 6002022.0507416995 | 2114644.40993289 | 37.7865242387809 | -122.436781745524 | (37.7865242387809, -122.436781745524) | ||
140014 | 140014 | 30960 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2401 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34753 | 6002022.0507416995 | 2114644.40993289 | 37.7865242387809 | -122.436781745524 | (37.7865242387809, -122.436781745524) | ||
81677 | 81677 | 30962 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1900 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34754 | 6002009.52813319 | 2115026.44418956 | 37.787572495360706 | -122.436852429478 | (37.7875724953607, -122.436852429478) | ||
71747 | 71747 | 30965 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1932 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 12 | Permit Number 34756 | 6001977.8019 | 2115220.4687 | 37.7881034337143 | -122.436976091665 | (37.7881034337143, -122.436976091665) | |
141331 | 141331 | 30966 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1901X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 16 | 3x3 | Permit Number 34757 | 6001967.37934743 | 2115036.16142537 | 37.7875967808045 | -122.436998951614 | (37.7875967808045, -122.436998951614) |
184255 | 184255 | 30967 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1904 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 10 | Permit Number 34758 | 6002512.7183 | 2114848.7346 | 37.787113135862796 | -122.43509877848801 | (37.7871131358628, -122.435098778488) | |
134753 | 134753 | 30968 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1902 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34759 | 6002518.1694 | 2114816.0277 | 37.787023640581396 | -122.435077578769 | (37.7870236405814, -122.435077578769) | |
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) | |
65266 | 65266 | 31485 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 570 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 16 | Permit Number 35049 | 6001528.2352599995 | 2102520.17185 | 37.753206014653294 | -122.43762161514499 | (37.7532060146533, -122.437621615145) | |
147209 | 147209 | 31498 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3246 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Permit Number 35060 | 6006663.4129 | 2103805.86212 | 37.757026859029004 | -122.41995432923001 | (37.757026859029, -122.41995432923) | |||
89144 | 89144 | 31499 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3244 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35060 | 6006677.13820069 | 2103812.71234735 | 37.7570464414299 | -122.41990734792401 | (37.7570464414299, -122.419907347924) | ||||
119648 | 119648 | 31500 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3244 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35060 | 6006677.13820069 | 2103812.71234735 | 37.7570464414299 | -122.41990734792401 | (37.7570464414299, -122.419907347924) | ||||
1250 | 1250 | 31791 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 186 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2017 12:00:00 AM | 3 | Permit Number 779904 | 6001704.83909 | 2107714.56044 | 37.767478581987206 | -122.437382809181 | (37.7674785819872, -122.437382809181) | |
45376 | 45376 | 32233 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1588 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 16 | Permit Number 35549 | 6008740.58515 | 2099494.1022900003 | 37.7453045396752 | -122.412465880499 | (37.7453045396752, -122.412465880499) | |
105147 | 105147 | 32286 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1800 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | Permit Number 36869 | 6001579.61916409 | 2114619.58179026 | 37.7864309126762 | -122.438310666952 | (37.7864309126762, -122.438310666952) | |||
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) | ||||
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) | ||||
144920 | 144920 | 32954 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 673X Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554.0 | 2103938.0 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | |||
30533 | 30533 | 33010 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3622 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42195 | 6005636.60974519 | 2102002.04320044 | 37.7520160884207 | -122.423377179853 | (37.7520160884207, -122.423377179853) | ||
84619 | 84619 | 33457 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37712 | 6006656.20982267 | 2098052.1703387 | 37.7412281240479 | -122.419571034944 | (37.7412281240479, -122.419571034944) | |||
25405 | 25405 | 33648 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 530 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37739 | 6004854.057893401 | 2110753.28886702 | 37.7760007246145 | -122.426706497307 | (37.7760007246145, -122.426706497307) | |||
106967 | 106967 | 33954 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1999 12:00:00 AM | Permit Number 48991 | 6002287.323724099 | 2097040.91143479 | 37.7382043832783 | -122.43460477820899 | (37.7382043832783, -122.434604778209) | |||
109688 | 109688 | 34444 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 74 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38188 | 6004269.61043081 | 2097757.70943651 | 37.7402848805672 | -122.42780207260401 | (37.7402848805672, -122.427802072604) | ||
125697 | 125697 | 34445 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 78 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38189 | 6004271.49317697 | 2097724.19157363 | 37.7401929546681 | -122.427793175192 | (37.7401929546681, -122.427793175192) | ||
111998 | 111998 | 34446 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 84 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38190 | 6004274.31729793 | 2097673.91474862 | 37.7400550657314 | -122.427779829106 | (37.7400550657314, -122.427779829106) | ||
94019 | 94019 | 34503 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1x GUY PL | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462.0 | 2114376.0 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | |||
97675 | 97675 | 34504 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | |||
97485 | 97485 | 34505 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1x GUY PL | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462.0 | 2114376.0 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | |||
95570 | 95570 | 34506 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1x GUY PL | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462.0 | 2114376.0 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) |
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");