trees
1,069 rows where qSpecies_id = 93 sorted by SiteOrder
This data as json, CSV (advanced)
qCareAssistant ✖
- - 918
- FUF 149
- DPW for City Agency 2
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12244 | 261985 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500x Bancroft Ave | Front Yard : Yard | Tree | Private 2 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||||
16169 | 105247 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1301X COLE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x 5 | 5998246 | 2105821 | 37.7620821004846 | -122.44920998149 | (37.7620821004846, -122.44920998149) | 15 | 5 | 11 | 29492 | 9 | ||||
49327 | 88393 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 124 23rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51371 | 5988714.5 | 2114502.9 | 37.7853704042268 | -122.482811657264 | (37.7853704042268, -122.482811657264) | 11 | 6 | 2 | 55 | 26 | |||
79413 | 251669 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 203 Addison St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002642 | 2097220 | 37.7387162474086 | -122.433391278876 | (37.7387162474086, -122.433391278876) | 2 | 7 | 5 | 63 | 7 | |||||
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 | |||
154719 | 104817 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3170 BALBOA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5985841 | 2111127 | 37.7759335444794 | -122.492504259099 | (37.7759335444794, -122.492504259099) | 11 | 6 | 2 | 55 | 26 | ||||
335 | 102831 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
883 | 240584 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 141 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000210.52128 | 2106191.60222 | 37.7632118519771 | -122.442442087458 | (37.7632118519771, -122.442442087458) | 15 | 5 | 5 | 28862 | 3 | |||
1337 | 27411 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2198 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5996975.1116 | 2109480.4382 | 37.7720572057802 | -122.453869751853 | (37.7720572057802, -122.453869751853) | 15 | 5 | 11 | 29492 | 16 | ||
1613 | 112905 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Bancroft Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 25 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||
2071 | 179437 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 121 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6006551.53826 | 2086713.55756 | 37.7100888527847 | -122.419128872099 | (37.7100888527847, -122.419128872099) | 9 | 7 | 8 | 309 | 39 | |||
2386 | 19745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
3871 | 260928 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 293 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5999961.28455 | 2099340.35663 | 37.7443857918882 | -122.442812113441 | (37.7443857918882, -122.442812113441) | 2 | 7 | 5 | 63 | 22 | |||||
4000 | 79751 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 15 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 5991685.90264393 | 2095891.27109779 | 37.7344402285305 | -122.471175151585 | (37.7344402285305, -122.471175151585) | 9 | 8 | 4 | 59 | 40 | ||||
4235 | 215001 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995907.45606 | 2090967.94562 | 37.7211652376617 | -122.45622408897 | (37.7211652376617, -122.45622408897) | 9 | 8 | 6 | 28861 | 24 | |||
4246 | 67958 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 719 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 11 | Permit Number 31678 | 5987220.95005 | 2111007.3016 | 37.7756854718616 | -122.48772192034 | (37.7756854718616, -122.48772192034) | 11 | 6 | 2 | 55 | 26 | |
4554 | 74167 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1801 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6000438.3175 | 2111300.5273 | 37.7772526604879 | -122.442020948646 | (37.7772526604879, -122.442020948646) | 15 | 5 | 11 | 29492 | 16 | |||
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 | ||
5222 | 240527 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 201 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 5997609 | 2105896 | 37.7622515762528 | -122.451418517771 | (37.7622515762528, -122.451418517771) | 15 | 5 | 11 | 29492 | 9 | |||
5632 | 75772 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3701 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5984063.00264 | 2111035.7891 | 37.7755789903575 | -122.498647978226 | (37.7755789903575, -122.498647978226) | 11 | 6 | 2 | 55 | 26 | |||
5678 | 214198 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 165 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994046.02682 | 2093769.86979 | 37.7287516135932 | -122.462861635163 | (37.7287516135932, -122.462861635163) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
7076 | 215009 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 220 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 5992622.02484 | 2095272.12308 | 37.7327943054026 | -122.467893679258 | (37.7327943054026, -122.467893679258) | 9 | 8 | 4 | 59 | 40 | |||
7213 | 62827 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1835 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1986 12:00:00 AM | Permit Number 23192 | 6000500.63320764 | 2093420.59763273 | 37.7281622534397 | -122.44052266477 | (37.7281622534397, -122.44052266477) | 9 | 7 | 6 | 28861 | 25 | ||
7442 | 240565 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 131 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000404.48259 | 2104877.48466 | 37.7596146626978 | -122.441676928051 | (37.7596146626978, -122.441676928051) | 2 | 4 | 5 | 28862 | 3 | |||
7491 | 70152 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 231 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5993349.44748 | 2113931.04039 | 37.7840688184898 | -122.466734683653 | (37.7840688184898, -122.466734683653) | 11 | 6 | 2 | 54 | 11 | |||
7621 | 239705 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4922 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 5997802.28625 | 2105653.55065 | 37.7615969375718 | -122.450732535394 | (37.7615969375718, -122.450732535394) | 15 | 5 | 11 | 29492 | 9 | |||
7806 | 179447 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 154 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 6006213.66342 | 2087416.73528 | 37.7120005974198 | -122.420346512779 | (37.7120005974198, -122.420346512779) | 9 | 7 | 8 | 309 | 39 | |||
8180 | 197538 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 33 Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6014309.72341 | 2114400.37585 | 37.7865448523989 | -122.39425201814 | (37.7865448523989, -122.39425201814) | 6 | 2 | 9 | 28855 | 6 | |||
8923 | 81053 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 735 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6002545.69492 | 2089214.07107 | 37.7167283109449 | -122.433152384794 | (37.7167283109449, -122.433152384794) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||
9615 | 70386 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1536 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6000423.3259 | 2110656.0694 | 37.7754822883832 | -122.442026539723 | (37.7754822883832, -122.442026539723) | 15 | 5 | 11 | 29492 | 16 | |||
10054 | 63509 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1805 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/1987 12:00:00 AM | 8 | 3x3 | Permit Number 24115 | 6000922.9965 | 2111712.7723 | 37.7784121888349 | -122.440373864948 | (37.7784121888349, -122.440373864948) | 15 | 5 | 11 | 29490 | 41 |
11016 | 53933 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 144 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 17 | Permit Number 9647 | 5993062.86441 | 2114500.7791 | 37.7856166217584 | -122.467767599839 | (37.7856166217584, -122.467767599839) | 11 | 6 | 2 | 54 | 11 | ||
11203 | 239713 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 293 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x6 | 5999986 | 2099353 | 37.7444219165503 | -122.442727560507 | (37.7444219165503, -122.442727560507) | 2 | 7 | 5 | 63 | 22 | |||
11220 | 239703 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1048 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5998155.79673 | 2106630.88901 | 37.7643006917393 | -122.449580319477 | (37.7643006917393, -122.449580319477) | 15 | 5 | 11 | 29492 | 9 | |||
11285 | 239736 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1449 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003357 | 2099848 | 37.7459726666437 | -122.431106669912 | (37.7459726666437, -122.431106669912) | 2 | 7 | 5 | 63 | 22 | |||
11444 | 261994 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |
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 | |
14424 | 46330 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 548 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2002 12:00:00 AM | 11 | Permit Number 44580 | 5996909.4172 | 2109622.8664 | 37.7724445099575 | -122.454107281383 | (37.7724445099575, -122.454107281383) | 15 | 5 | 11 | 29492 | 16 | ||
14741 | 33010 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3622 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42195 | 6005636.60974519 | 2102002.04320044 | 37.7520160884207 | -122.423377179853 | (37.7520160884207, -122.423377179853) | 2 | 4 | 5 | 28859 | 19 | ||
14953 | 239697 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 155 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5997911.0613 | 2106175.96002 | 37.763037567858 | -122.450393989214 | (37.763037567858, -122.450393989214) | 15 | 5 | 11 | 29492 | 9 | |||
15470 | 105248 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1301 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x5 | 5998246 | 2105821 | 37.7620821004846 | -122.44920998149 | (37.7620821004846, -122.44920998149) | 15 | 5 | 11 | 29492 | 9 | |||
16168 | 4153 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3721-3721 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/1989 12:00:00 AM | 6 | 3X3 | 6005701.8016 | 2100493.99134 | 37.7478790037267 | -122.423044558975 | (37.7478790037267, -122.423044558975) | 2 | 4 | 5 | 28859 | 22 | ||
16227 | 138388 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1955 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002442.7156 | 2115026.9125 | 37.7875983916864 | -122.435353722329 | (37.7875983916864, -122.435353722329) | 13 | 9 | 11 | 29490 | 27 | |||
17372 | 2773 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 324 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 5994596.42955 | 2110789.71407 | 37.7755154642019 | -122.462192710849 | (37.7755154642019, -122.462192710849) | 11 | 6 | 2 | 54 | 11 | |||
17552 | 46597 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 170St. 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/09/2002 12:00:00 AM | 11 | Permit Number 44725 | 5993070.73118 | 2114361.72785 | 37.7852352793736 | -122.467730266741 | (37.7852352793736, -122.467730266741) | 11 | 6 | 2 | 54 | 11 | |
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 | ||
17604 | 261710 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3555 16th St | 1 | Front Yard : Yard | Tree | Public Library 12 | 8x8 | 6003221.95473 | 2106496.25325 | 37.7642195378276 | -122.432048304209 | (37.7642195378276, -122.432048304209) | 15 | 4 | 5 | 28862 | 3 | ||||
17629 | 71250 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1240 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6x3 | 6007647.94637 | 2118195.049 | 37.7965915450137 | -122.417569230932 | (37.7965915450137, -122.417569230932) | 5 | 1 | 10 | 28858 | 32 | ||
18292 | 214176 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2570 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991436.65565 | 2097934.35886 | 37.7400356087611 | -122.4721857495 | (37.7400356087611, -122.4721857495) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||||||||||||
18859 | 14566 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1030 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5999382.6721 | 2109282.399 | 37.7716511811815 | -122.445527596882 | (37.7716511811815, -122.445527596882) | 15 | 5 | 11 | 29492 | 9 | |||
19784 | 240541 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 72 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6005497.38826 | 2099648.86664 | 37.7455469474293 | -122.423691331589 | (37.7455469474293, -122.423691331589) | 2 | 7 | 5 | 28859 | 22 | |||
20265 | 240589 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 78 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004277.11991 | 2097713.84146 | 37.7401648539148 | -122.42777298294 | (37.7401648539148, -122.42777298294) | 2 | 7 | 5 | 63 | 7 | |||
20356 | 39764 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 670 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41130 | 6003007.22096458 | 2104433.1722566 | 37.7585426381862 | -122.432643626683 | (37.7585426381862, -122.432643626683) | 2 | 4 | 5 | 28862 | 3 | ||
20400 | 84536 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 124 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988694.18379 | 2114506.16667 | 37.7853781914991 | -122.482882183887 | (37.7853781914991, -122.482882183887) | 11 | 6 | 2 | 55 | 26 | |||
20507 | 2755 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 124 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5995208.65957 | 2110814.76075 | 37.7756194677712 | -122.460076689691 | (37.7756194677712, -122.460076689691) | 11 | 6 | 2 | 54 | 11 | |||
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 | ||
20942 | 116380 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4299X 17TH ST | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 15 | 3x3 | 6000957 | 2105810 | 37.7622065862093 | -122.439832910658 | (37.7622065862093, -122.439832910658) | 15 | 5 | 5 | 28862 | 3 | |||
21269 | 197529 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1399 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013534.71133 | 2105671.72801 | 37.7625348459264 | -122.396321376134 | (37.7625348459264, -122.396321376134) | 14 | 3 | 8 | 28856 | 29 | |||
21426 | 35154 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 838 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2004 12:00:00 AM | Permit Number 47291 | 6002552.46430035 | 2109566.25151631 | 37.7726110209677 | -122.43458340802 | (37.7726110209677, -122.43458340802) | 15 | 5 | 11 | 29492 | 9 | ||
21443 | 22619 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1107 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6004653.0794 | 2112584.8191 | 37.7810182911755 | -122.427532248108 | (37.7810182911755, -122.427532248108) | 7 | 9 | 11 | 29490 | 41 | |||
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 | ||
22649 | 239673 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 51 Tiffany Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 6006373.75126 | 2099735.68708 | 37.7458347673547 | -122.420667160657 | (37.7458347673547, -122.420667160657) | 2 | 7 | 7 | 28859 | 2 | |||
23104 | 136416 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6013522.99602 | 2118258.2651 | 37.797093950371 | -122.397244549101 | (37.797093950371, -122.397244549101) | 3 | 1 | 10 | 28860 | 6 | |||
23373 | 53934 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 148 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1992 12:00:00 AM | 16 | Permit Number 30776 | 5993063.90435 | 2114472.77746 | 37.7855397969799 | -122.467761964704 | (37.7855397969799, -122.467761964704) | 11 | 6 | 2 | 54 | 11 | ||
23571 | 59786 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 401 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/2004 12:00:00 AM | Permit Number 19235 | 5998844.30042115 | 2109361.70149477 | 37.7718381757148 | -122.447395558288 | (37.7718381757148, -122.447395558288) | 15 | 5 | 11 | 29492 | 9 | ||
23990 | 7135 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 336X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5994611.62343 | 2110790.08992 | 37.775517371009 | -122.462140179219 | (37.775517371009, -122.462140179219) | 11 | 6 | 2 | 54 | 11 | |||
24448 | 239724 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 957 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000323.35632 | 2102545.02834 | 37.7532056846093 | -122.441790101437 | (37.7532056846093, -122.441790101437) | 2 | 4 | 5 | 28862 | 22 | |||
25673 | 4159 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3736-3738 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1989 12:00:00 AM | 23 | 3X3 | 6005622.07663 | 2100534.07243 | 37.7479845580381 | -122.4233230934 | (37.7479845580381, -122.4233230934) | 2 | 4 | 5 | 28859 | 19 | ||
25848 | 34445 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 78 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38189 | 6004271.49317697 | 2097724.19157363 | 37.7401929546681 | -122.427793175192 | (37.7401929546681, -122.427793175192) | 2 | 7 | 5 | 63 | 7 | ||
26869 | 66993 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 325 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30346 | 5995859.19605633 | 2091190.56071344 | 37.7217737155135 | -122.456406997913 | (37.7217737155135, -122.456406997913) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |
27418 | 6356 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1234X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001371.4698 | 2112650.1535 | 37.7810115248297 | -122.438889623593 | (37.7810115248297, -122.438889623593) | 15 | 5 | 11 | 29490 | 41 | |||
27845 | 5359 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 233 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6004883.71893 | 2107010.19311 | 37.7657247654982 | -122.426337327709 | (37.7657247654982, -122.426337327709) | 8 | 4 | 5 | 28853 | 19 | |||
27973 | 2748 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 27 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5995513.49163 | 2110771.02145 | 37.7755168992008 | -122.459019040214 | (37.7755168992008, -122.459019040214) | 11 | 6 | 2 | 54 | 11 | |||
28172 | 142669 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 444 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6009205.7299 | 2121176.5543 | 37.8048655501446 | -122.412389783451 | (37.8048655501446, -122.412389783451) | 3 | 1 | 10 | 308 | 23 | |||
28287 | 10404 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1372 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 5999585.1964 | 2108804.377 | 37.7703502135529 | -122.444792689196 | (37.7703502135529, -122.444792689196) | 15 | 5 | 11 | 29492 | 9 | |||
28456 | 239669 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 89 Webster St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6004261.58964 | 2108988.28216 | 37.7711209334157 | -122.428630156483 | (37.7711209334157, -122.428630156483) | 7 | 9 | 11 | 29492 | 10 | |||
28691 | 10384 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5999747.97928 | 2108852.64514 | 37.7704920339747 | -122.44423309424 | (37.7704920339747, -122.44423309424) | 15 | 5 | 11 | 29492 | 9 | |||
29006 | 240570 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 387 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001514.84125 | 2103575.85133 | 37.7561038947038 | -122.437743536251 | (37.7561038947038, -122.437743536251) | 2 | 4 | 5 | 28862 | 3 | |||
29321 | 701 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1401X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005272.9475237 | 2100137.7446563 | 37.7468766226068 | -122.424502181659 | (37.7468766226068, -122.424502181659) | 2 | 7 | 5 | 28859 | 22 | |||
29722 | 39913 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2116 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | Permit Number 770988 | 6000956 | 2115624 | 37.7891532958703 | -122.440540293957 | (37.7891532958703, -122.440540293957) | 13 | 6 | 1 | 29490 | 27 | ||
30521 | 179472 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 416 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003621.62429 | 2091003.33187 | 37.7217022030671 | -122.42956096377 | (37.7217022030671, -122.42956096377) | 9 | 7 | 6 | 28861 | 5 | |||
30995 | 30954 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
31221 | 136411 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 10 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
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 | ||
31319 | 179463 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 90 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6000843.6616 | 2089782.45527 | 37.7181922687385 | -122.439076170523 | (37.7181922687385, -122.439076170523) | 9 | 7 | 6 | 28861 | 5 | |||
31371 | 47783 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 411 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | Permit Number 45557 | 6009328.94293981 | 2121149.73408628 | 37.8047988220658 | -122.4119614934 | (37.8047988220658, -122.4119614934) | 3 | 1 | 10 | 308 | 23 | |||
31474 | 179452 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1851 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6006040.88882 | 2087844.33942 | 37.7131649703554 | -122.420974012957 | (37.7131649703554, -122.420974012957) | 9 | 7 | 8 | 309 | 39 | |||
31790 | 93029 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 45 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5x6 | undocumented | 6004830 | 2101620 | 37.7509215289079 | -122.426139360449 | (37.7509215289079, -122.426139360449) | 2 | 4 | 5 | 28862 | 22 | ||
31796 | 62829 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1901 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1986 12:00:00 AM | Permit Number 23194 | 6000247.30252359 | 2092964.84623807 | 37.7268964366151 | -122.441365747367 | (37.7268964366151, -122.441365747367) | 9 | 7 | 6 | 28861 | 25 | ||
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 | ||
34589 | 5333 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 135 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6004851.68413 | 2107592.33342 | 37.7673213724137 | -122.426489583844 | (37.7673213724137, -122.426489583844) | 8 | 4 | 5 | 28862 | 19 | |||
35143 | 10438 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1474 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5999064.8261 | 2108729.1491 | 37.770113946782 | -122.446587229644 | (37.770113946782, -122.446587229644) | 15 | 5 | 11 | 29492 | 9 | |||
35777 | 10458 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1568 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998619.39853 | 2108748.68603 | 37.7701421372022 | -122.448129358985 | (37.7701421372022, -122.448129358985) | 15 | 5 | 11 | 29492 | 9 | |||
36218 | 116694 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 536 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x4 | 6004835.97758 | 2110737.29191 | 37.7759557786585 | -122.426767902416 | (37.7759557786585, -122.426767902416) | 7 | 9 | 11 | 28852 | 10 | |||
36565 | 109296 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 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) );