trees
1,069 rows where qSpecies_id = 93 sorted by PlantDate descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
123586 | 68931 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 655 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 12 | Permit Number 32915 | 5992836.31623 | 2110994.2871 | 37.7759756654158 | -122.468296198193 | (37.7759756654158, -122.468296198193) | 11 | 6 | 2 | 54 | 11 | |
184922 | 39497 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 430 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40954 | 6003565.0004553 | 2102762.00333018 | 37.7539856215362 | -122.430595327752 | (37.7539856215362, -122.430595327752) | 2 | 4 | 5 | 28862 | 22 | ||
153954 | 52473 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 454@ ANZA Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | Permit Number 48584 | 5991906.61756296 | 2112344.10243716 | 37.7796281496591 | -122.471610624408 | (37.7796281496591, -122.471610624408) | 11 | 6 | 2 | 54 | 11 | ||
28657 | 80831 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3100 Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.456929197984 | (37.7774658426, -122.456929197984) | 11 | 6 | 2 | 54 | 16 | |
86507 | 80829 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3100 Turk Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.456929197984 | (37.7774658426, -122.456929197984) | 11 | 6 | 2 | 54 | 16 | |
121336 | 80832 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3100 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.456929197984 | (37.7774658426, -122.456929197984) | 11 | 6 | 2 | 54 | 16 | |
139566 | 87081 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 172 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50022 | 6001920 | 2108624 | 37.7699879080732 | -122.436703704361 | (37.7699879080732, -122.436703704361) | 15 | 5 | 5 | 29492 | 9 | ||
33159 | 67820 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 133 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31476 | 6004140.16165068 | 2102371.71829749 | 37.7529465572746 | -122.428578465138 | (37.7529465572746, -122.428578465138) | 2 | 4 | 5 | 28862 | 22 | ||
121175 | 67802 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4022 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31449 | 6003744.51176452 | 2100434.22126683 | 37.7476042452744 | -122.429808512801 | (37.7476042452744, -122.429808512801) | 2 | 4 | 5 | 63 | 22 | ||
134565 | 114875 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1362 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3x3 | 5999587.7 | 2108019.3 | 37.7681947328922 | -122.444727590707 | (37.7681947328922, -122.444727590707) | 15 | 5 | 11 | 29492 | 9 | |||
91572 | 10522 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1855 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2017 12:00:00 AM | 14 | 3X3 | 5997273.9779 | 2108433.2536 | 37.7691990373323 | -122.452760361188 | (37.7691990373323, -122.452760361188) | 15 | 5 | 11 | 29492 | 9 | ||
194298 | 262528 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||
147782 | 240586 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 2 | Width 3ft | Permit Number 37769 | 6003553.87833 | 2108799.61563 | 37.770562824039 | -122.431064686005 | (37.770562824039, -122.431064686005) | 15 | 9 | 11 | 29492 | 10 | |
12227 | 33648 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 530 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37739 | 6004854.0578934 | 2110753.28886702 | 37.7760007246145 | -122.426706497307 | (37.7760007246145, -122.426706497307) | 7 | 9 | 11 | 28852 | 10 | |||
101372 | 101867 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769242 | 6012649.1 | 2113074.7 | 37.7828124097662 | -122.399904277178 | (37.7828124097662, -122.399904277178) | 6 | 2 | 9 | 28856 | 34 | |
88925 | 52283 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 176 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48441 | 6006024.37896521 | 2099203.00634212 | 37.7443524500258 | -122.421837411698 | (37.7443524500258, -122.421837411698) | 2 | 7 | 5 | 28859 | 2 | ||
58081 | 33457 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 300 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37712 | 6006656.20982267 | 2098052.1703387 | 37.7412281240479 | -122.419571034944 | (37.7412281240479, -122.419571034944) | 2 | 7 | 7 | 28859 | 2 | |||
173907 | 48950 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2911 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46135 | 6009399.56446616 | 2102741.17443943 | 37.7542572383471 | -122.410416464523 | (37.7542572383471, -122.410416464523) | 2 | 4 | 7 | 28859 | 19 | ||
27413 | 101870 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779151 | 6012595.5925 | 2113052.7427 | 37.7827491368943 | -122.400087849303 | (37.7827491368943, -122.400087849303) | 6 | 2 | 9 | 28856 | 34 | |
134533 | 68795 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2574 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32734 | 5991441.9162308 | 2097904.96501407 | 37.7399552051973 | -122.472165418715 | (37.7399552051973, -122.472165418715) | 1 | 8 | 4 | 29491 | 40 | ||
174971 | 76749 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200X Farallones St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 8 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
172079 | 214190 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 393 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2009 12:00:00 AM | 17 | Width 3ft | Permit Number 53039 | 5992606.38416 | 2093945.56472 | 37.7291510025005 | -122.467851302315 | (37.7291510025005, -122.467851302315) | 9 | 8 | 4 | 59 | 40 | |
100348 | 38979 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2222 17th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/1998 12:00:00 AM | Permit Number 40762 | 6010839.10372464 | 2106501.59245712 | 37.7646630990658 | -122.405703003871 | (37.7646630990658, -122.405703003871) | 8 | 4 | 8 | 28853 | 19 | |||
176752 | 64740 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1225 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25701 | 6000702.83668032 | 2109256.16819914 | 37.7716544366578 | -122.440959198032 | (37.7716544366578, -122.440959198032) | 15 | 5 | 11 | 29492 | 9 | ||
72102 | 239740 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1314 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2017 12:00:00 AM | 3 | 6x6 | 6003222.89805 | 2100527.56399 | 37.7478309907011 | -122.431618884227 | (37.7478309907011, -122.431618884227) | 2 | 4 | 5 | 63 | 22 | ||
78808 | 48868 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 351 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2002 12:00:00 AM | Permit Number 46076 | 5992826.30636272 | 2094323.11375055 | 37.7302003556086 | -122.467118458519 | (37.7302003556086, -122.467118458519) | 9 | 8 | 4 | 59 | 40 | |||
11580 | 247184 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 1 | : | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | 15 | 5 | 11 | 29492 | 9 | |
115078 | 1630 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 20X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/06/2015 01:42:00 PM | 3 | 3X3 | 5995606.71843 | 2110827.0926 | 37.7756762144924 | -122.458700608592 | (37.7756762144924, -122.458700608592) | 11 | 6 | 2 | 54 | 11 | ||
189632 | 32954 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 673X Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
100878 | 62344 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 16 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22486 | 6005809.69914418 | 2099671.2694643 | 37.7456260851044 | -122.422612999068 | (37.7456260851044, -122.422612999068) | 2 | 7 | 5 | 28859 | 22 | ||
109902 | 62343 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 14 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22485 | 6005822.8575705 | 2099672.01958419 | 37.7456288871148 | -122.422567552448 | (37.7456288871148, -122.422567552448) | 2 | 7 | 5 | 28859 | 22 | ||
111364 | 62348 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 57 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22491 | 6005543.85080152 | 2099604.02987317 | 37.745426458533 | -122.423527484038 | (37.745426458533, -122.423527484038) | 2 | 7 | 5 | 28859 | 22 | ||
162241 | 62350 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 74 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22493 | 6005428.10472053 | 2099649.51598417 | 37.7455448191665 | -122.423930949775 | (37.7455448191665, -122.423930949775) | 2 | 7 | 5 | 28859 | 22 | ||
132607 | 66239 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29337 | 5995901.80991046 | 2090714.82365274 | 37.720469900548 | -122.456225313763 | (37.720469900548, -122.456225313763) | 9 | 8 | 6 | 28861 | 24 | ||
153856 | 86882 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49807 | 6011833 | 2113224.2 | 37.7831773700909 | -122.402738173851 | (37.7831773700909, -122.402738173851) | 6 | 2 | 9 | 28853 | 34 | |||
126597 | 33954 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1999 12:00:00 AM | Permit Number 48991 | 6002287.3237241 | 2097040.91143479 | 37.7382043832783 | -122.434604778209 | (37.7382043832783, -122.434604778209) | 2 | 7 | 5 | 63 | 7 | |||
167002 | 48770 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 560 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | 15 | 3x3 | Permit Number 46028 | 6005170.9549 | 2110973.7304 | 37.7766239145875 | -122.425625959395 | (37.7766239145875, -122.425625959395) | 7 | 9 | 11 | 28852 | 10 | |
169348 | 48771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 562 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | Permit Number 773432 | 6005160.4427442 | 2110970.099276 | 37.77661335041 | -122.425662065534 | (37.77661335041, -122.425662065534) | 7 | 9 | 11 | 28852 | 10 | |||
6032 | 50628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
152092 | 50629 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
63439 | 9536 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004118.455 | 2112215.6365 | 37.779974353933 | -122.42935544492 | (37.779974353933, -122.42935544492) | 7 | 9 | 11 | 29490 | 41 | ||
175086 | 9540 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721316 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | 7 | 9 | 11 | 29490 | 41 | ||
18752 | 51349 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 6401 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2004 12:00:00 AM | Permit Number 47697 | |||||||||||||
74312 | 113590 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 2 | 3x3 | 6013615.62221 | 2118103.5659 | 37.7966743392965 | -122.396913185795 | (37.7966743392965, -122.396913185795) | 3 | 1 | 10 | 28860 | 6 | ||
128505 | 113595 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 2 | 3x3 | 6013594.82153 | 2118250.31526 | 37.7970761204252 | -122.396995455792 | (37.7970761204252, -122.396995455792) | 3 | 1 | 10 | 28860 | 6 | ||
4683 | 62258 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 49 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | Permit Number 22384 | 6001321.62543581 | 2093848.87962555 | 37.7293849331116 | -122.437715130621 | (37.7293849331116, -122.437715130621) | 9 | 7 | 6 | 28861 | 25 | ||
12797 | 62238 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | 21 | Permit Number 22364 | 6001428.6005 | 2093653.63751 | 37.7288549250112 | -122.437331333801 | (37.7288549250112, -122.437331333801) | 9 | 7 | 6 | 28861 | 25 | |
106799 | 62237 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 61 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | Permit Number 22363 | 6001374.44401127 | 2093790.00837779 | 37.7292262892939 | -122.437528318003 | (37.7292262892939, -122.437528318003) | 9 | 7 | 6 | 28861 | 25 | ||
193921 | 62259 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 73 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | 9 | Permit Number 22385 | 6001393.61197 | 2093758.63795 | 37.7291412430561 | -122.437459807321 | (37.7291412430561, -122.437459807321) | 9 | 7 | 6 | 28861 | 25 | |
182662 | 30961 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1900 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/2013 12:00:00 AM | 8 | Permit Number 770536 | 6001993.3657 | 2115129.3914 | 37.7878542434133 | -122.436915720974 | (37.7878542434133, -122.436915720974) | 13 | 6 | 1 | 29490 | 27 | |
81823 | 62229 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 107 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 9 | Permit Number 22354 | 6001481.45016 | 2093645.47099 | 37.7288355059294 | -122.437148044757 | (37.7288355059294, -122.437148044757) | 9 | 7 | 6 | 28861 | 25 | |
186788 | 62232 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 31 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | Permit Number 22358 | 6001252.08087827 | 2093926.39351405 | 37.7295938138913 | -122.437961102136 | (37.7295938138913, -122.437961102136) | 9 | 7 | 6 | 28861 | 25 | ||
23898 | 35110 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
94617 | 38649 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
55375 | 58367 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 48 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1994 12:00:00 AM | Permit Number 17397 | 6003645.80101321 | 2096628.46720423 | 37.7371489313999 | -122.42987842787 | (37.7371489313999, -122.42987842787) | 2 | 7 | 5 | 63 | 7 | ||
108154 | 28531 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 241 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2012 12:00:00 AM | 18 | 3X3 | Permit Number 769387 | 6010735.41269 | 2111831.43795 | 37.7792918290844 | -122.406437232011 | (37.7792918290844, -122.406437232011) | 14 | 2 | 9 | 28853 | 34 | |
31257 | 92610 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3971 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2009 12:00:00 AM | 3x3 | Permit Number 52921 | 6003876 | 2104198 | 37.7579461423488 | -122.429622225876 | (37.7579461423488, -122.429622225876) | 2 | 4 | 5 | 28862 | 3 | ||
163383 | 50263 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 519 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46969 | 6006390.76852581 | 2096193.21285802 | 37.7361088859688 | -122.420356925459 | (37.7361088859688, -122.420356925459) | 2 | 7 | 7 | 28859 | 2 | ||
181204 | 50265 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 35 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46971 | 6005046.20150954 | 2096458.3536408 | 37.7367610435591 | -122.425024502668 | (37.7367610435591, -122.425024502668) | 2 | 7 | 5 | 28859 | 2 | ||
85546 | 32233 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1588 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 16 | Permit Number 35549 | 6008740.58515 | 2099494.10229 | 37.7453045396752 | -122.412465880499 | (37.7453045396752, -122.412465880499) | 2 | 7 | 7 | 28859 | 2 | |
139891 | 50200 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 582 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 8 | 3x4 | Permit Number 46908 | 5988471.49095 | 2112024.91124 | 37.7785524043317 | -122.483470659433 | (37.7785524043317, -122.483470659433) | 11 | 6 | 2 | 55 | 26 |
22630 | 59288 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2067 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1980 12:00:00 AM | 17 | Permit Number 18625 | 6003010.51633 | 2119230.45541 | 37.7991724689015 | -122.433689789967 | (37.7991724689015, -122.433689789967) | 13 | 9 | 1 | 57 | 17 | ||
17584 | 66355 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 842 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1992 12:00:00 AM | 15 | Permit Number 30970 | 6006677.47104 | 2121530.77464 | 37.8056959468756 | -122.421164278004 | (37.8056959468756, -122.421164278004) | 5 | 1 | 1 | 28858 | 32 | ||
129693 | 32286 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1800 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | Permit Number 36869 | 6001579.61916409 | 2114619.58179026 | 37.7864309126762 | -122.438310666952 | (37.7864309126762, -122.438310666952) | 13 | 6 | 11 | 29490 | 27 | |||
61164 | 57496 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2090 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1988 12:00:00 AM | 15 | Permit Number 25529 | 6003581.68174 | 2117969.32312 | 37.7957421173574 | -122.431623277394 | (37.7957421173574, -122.431623277394) | 13 | 9 | 1 | 57 | 17 | ||
89421 | 50433 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 403 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47583 | 5998845.21508396 | 2109355.09330434 | 37.7718200835759 | -122.447391918702 | (37.7718200835759, -122.447391918702) | 15 | 5 | 11 | 29492 | 9 | |||
163960 | 40639 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2740 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | 12 | Permit Number 41638 | 5996441.36597 | 2111293.50073 | 37.7770047854178 | -122.455847097036 | (37.7770047854178, -122.455847097036) | 11 | 6 | 2 | 54 | 16 | ||
173200 | 40640 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2740 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | 12 | Permit Number 41638 | 5996456.82543 | 2111294.67201 | 37.7770088886807 | -122.455793702985 | (37.7770088886807, -122.455793702985) | 11 | 6 | 2 | 54 | 16 | ||
69813 | 54921 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 363 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1972 12:00:00 AM | 13 | 4x6 | Permit Number 10790 | 5992776.0461415 | 2094204.68994573 | 37.7298722918639 | -122.467283605749 | (37.7298722918639, -122.467283605749) | 9 | 8 | 4 | 59 | 40 | |
137637 | 214191 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 363 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 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) | 9 | 8 | 4 | 59 | 40 | |
127043 | 10517 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1827 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1996 12:00:00 AM | 20 | 3X3 | 5997386.3275 | 2108448.0922 | 37.7692462174685 | -122.452372822905 | (37.7692462174685, -122.452372822905) | 15 | 5 | 11 | 29492 | 9 | ||
85000 | 68407 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 165 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32242 | 5993958.38777264 | 2093823.43780185 | 37.7288936500159 | -122.463168491943 | (37.7288936500159, -122.463168491943) | 9 | 8 | 4 | 59 | 40 | ||
90936 | 68409 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 175 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32245 | 5993925.68682399 | 2093845.21689491 | 37.7289515662137 | -122.463283120302 | (37.7289515662137, -122.463283120302) | 9 | 8 | 4 | 59 | 40 | ||
167756 | 68408 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 170 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32243 | 5994001.22714578 | 2093857.38366654 | 37.7289893248225 | -122.463022856253 | (37.7289893248225, -122.463022856253) | 9 | 8 | 4 | 59 | 40 | ||
119092 | 10460 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1568 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/2008 12:00:00 AM | 12 | 3x3 | 5998627.6282 | 2108670.1782 | 37.7699270451307 | -122.448095239137 | (37.7699270451307, -122.448095239137) | 15 | 5 | 11 | 29492 | 9 | ||
108695 | 67438 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2910 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/1992 12:00:00 AM | 8 | 4x4 | Permit Number 30940 | 5989610.64145 | 2111971.49615 | 37.7784719767097 | -122.479526038454 | (37.7784719767097, -122.479526038454) | 11 | 6 | 2 | 55 | 26 |
20931 | 39484 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3828 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46800 | 6004242.77277465 | 2102507.2235091 | 37.7533244292691 | -122.428233272856 | (37.7533244292691, -122.428233272856) | 2 | 4 | 5 | 28862 | 22 | ||
38500 | 50055 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 646 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46785 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341 | (37.7605408596837, -122.42837316341) | 2 | 4 | 5 | 28862 | 3 | |||
85310 | 50056 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 646 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46785 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341 | (37.7605408596837, -122.42837316341) | 2 | 4 | 5 | 28862 | 3 | |||
135718 | 50043 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3920@ SANCHEZ 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46774 | 6003513.59033802 | 2104807.4010588 | 37.759598884966 | -122.430919082048 | (37.759598884966, -122.430919082048) | 2 | 4 | 5 | 28862 | 3 | |||
177149 | 47230 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 890 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 6 | Permit Number 46770 | 6011503.10296 | 2090822.57098 | 37.7216489793918 | -122.40230391012 | (37.7216489793918, -122.40230391012) | 10 | 3 | 7 | 309 | 28 | |
47509 | 43759 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43395 | 5990535.98179 | 2113705.55195 | 37.7832869196807 | -122.476451677439 | (37.7832869196807, -122.476451677439) | 11 | 6 | 2 | 55 | 26 | ||
83828 | 43760 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 8 | Permit Number 43395 | 5990536.37641 | 2113724.23454 | 37.7833382397577 | -122.476451677446 | (37.7833382397577, -122.476451677446) | 11 | 6 | 2 | 55 | 26 | |
54813 | 43677 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 656 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 8 | Permit Number 43320 | 5995359.11762 | 2111077.33678 | 37.7763490847186 | -122.459575243791 | (37.7763490847186, -122.459575243791) | 11 | 6 | 2 | 54 | 11 | |
134266 | 43675 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 611 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 10 | Permit Number 43318 | 5995303.58271 | 2111376.81482 | 37.7771681785952 | -122.459789050934 | (37.7771681785952, -122.459789050934) | 11 | 6 | 2 | 54 | 11 | |
170135 | 43696 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1539 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 8 | Permit Number 43340 | 5993847.57781 | 2112069.22957 | 37.7789855246228 | -122.464876090912 | (37.7789855246228, -122.464876090912) | 11 | 6 | 2 | 54 | 11 | |
189564 | 43657 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 553 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 10 | Permit Number 43301 | 5992810.17 | 2111710.04136 | 37.7779394229571 | -122.468438730278 | (37.7779394229571, -122.468438730278) | 11 | 6 | 2 | 54 | 11 | |
27239 | 56308 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 171 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1973 12:00:00 AM | 14 | 3x3 | Permit Number 12442 | 5993024.02697 | 2114355.61708 | 37.785215804041 | -122.467891402947 | (37.785215804041, -122.467891402947) | 11 | 6 | 2 | 54 | 11 | |
9502 | 65156 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 832 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27135 | 6001006.03746235 | 2102623.98500372 | 37.7534613558838 | -122.439434917257 | (37.7534613558838, -122.439434917257) | 2 | 4 | 5 | 28862 | 22 | ||
174395 | 65162 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 957 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 14 | 4x12 | Permit Number 27142 | 6000403.82793053 | 2102538.64719816 | 37.7531927484611 | -122.441511357285 | (37.7531927484611, -122.441511357285) | 2 | 4 | 5 | 28862 | 22 |
168385 | 54720 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 510 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1972 12:00:00 AM | 9 | Permit Number 10556 | 5983806.7051 | 2112297.13716 | 37.7790272518998 | -122.499627803034 | (37.7790272518998, -122.499627803034) | 11 | 6 | 2 | 55 | 26 | ||
63152 | 92261 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4545 Anza St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52708 | 5984639.1399 | 2111735.34775 | 37.7775335493935 | -122.496706647933 | (37.7775335493935, -122.496706647933) | 11 | 6 | 2 | 55 | 26 | |
128364 | 5349 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004790.70557 | 2107143.57223 | 37.7660857344886 | -122.426668539926 | (37.7660857344886, -122.426668539926) | 8 | 4 | 5 | 28862 | 3 | |
175855 | 10385 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/17/2017 12:00:00 AM | 24 | 3X3 | 5999759.298 | 2108827.6222 | 37.7704239730353 | -122.444192144461 | (37.7704239730353, -122.444192144461) | 15 | 5 | 11 | 29492 | 9 | ||
56600 | 40582 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 | ||
77196 | 40592 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 | ||
90242 | 40591 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 | ||
91134 | 40594 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 | ||
113382 | 40574 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 | ||
128884 | 40584 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );