trees
1,069 rows where qSpecies_id = 93 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
350 | 119661 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
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 | |||
1203 | 179432 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6006549.42501 | 2086808.72834 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||||||||||||
2724 | 179436 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006488.6944 | 2086721.59328 | 37.7101073779209 | -122.419346642943 | (37.7101073779209, -122.419346642943) | 9 | 7 | 8 | 309 | 39 | |||
3162 | 202093 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2403 Keith St | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | 25 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | ||||
3578 | 261993 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
3780 | 14742 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004772.182 | 2111961.3352 | 37.7793130940377 | -122.427075791541 | (37.7793130940377, -122.427075791541) | 7 | 9 | 11 | 29490 | 41 | |||
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 | ||||
4042 | 197511 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | 6009774.86658 | 2109479.23633 | 37.7727794523332 | -122.409594111377 | (37.7727794523332, -122.409594111377) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | |||
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 | |||
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 | |||
6230 | 262036 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
6859 | 246229 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5999439.8115 | 2107740.3807 | 37.7674204502126 | -122.44521906453 | (37.7674204502126, -122.44521906453) | 15 | 5 | 11 | 29492 | 9 | |||
6864 | 214183 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 347 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5992610.48002 | 2094547.79644 | 37.7308048179917 | -122.467880927762 | (37.7308048179917, -122.467880927762) | 9 | 8 | 4 | 59 | 40 | |||
6965 | 240534 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3250 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2020 12:00:00 AM | 3 | Width 3ft | 6006614.52941 | 2103803.76084 | 37.7570183352315 | -122.420123238094 | (37.7570183352315, -122.420123238094) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
7377 | 14771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 18 | 4x4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
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 | |||
7566 | 264756 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 176 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
7605 | 240540 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 72 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6005500 | 2099675 | 37.7456188511036 | -122.423684158346 | (37.7456188511036, -122.423684158346) | 2 | 7 | 5 | 28859 | 22 | |||
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 | |||
7784 | 197575 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1121 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6013269.3073 | 2090137.6242 | 37.7198666867704 | -122.396150589498 | (37.7198666867704, -122.396150589498) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
8307 | 141930 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004152.017 | 2111873.3634 | 37.7790364568014 | -122.429214926277 | (37.7790364568014, -122.429214926277) | 7 | 9 | 11 | 29490 | 41 | |||
8379 | 114770 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
10308 | 141912 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6004447.1952 | 2111915.047 | 37.7791676154415 | -122.42819675688 | (37.7791676154415, -122.42819675688) | 7 | 9 | 11 | 29490 | 41 | |||
10659 | 136418 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6013527.00347 | 2118227.13229 | 37.797008690162 | -122.397228498003 | (37.797008690162, -122.397228498003) | 3 | 1 | 10 | 28860 | 6 | |||
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 | |
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 | |||
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 | ||||||
13044 | 197544 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6011744.68904 | 2107088.20402 | 37.766324401967 | -122.402612061007 | (37.766324401967, -122.402612061007) | 8 | 2 | 8 | 28853 | 20 | |||
13099 | 197577 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 299x Cashmere St | 5 | Median : Yard | Tree | DPW 1 | 33 | 6016820.77887 | 2095888.49241 | 37.735854408739 | -122.38427457691 | (37.735854408739, -122.38427457691) | 10 | 3 | 8 | 58 | 1 | ||||
13703 | 40148 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
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 | ||
14684 | 246599 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 5 | : | Tree | Private 2 | 18 | Width 3ft | 6005448.39533 | 2109271.63735 | 37.7719660524162 | -122.42454510839 | (37.7719660524162, -122.42454510839) | 7 | 9 | 11 | 28852 | 10 | |||
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 | ||
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 | ||||
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 | |||
16461 | 183905 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5989441.4873 | 2100495.8044 | 37.7469530039163 | -122.479271477973 | (37.7469530039163, -122.479271477973) | 1 | 8 | 3 | 29491 | 35 | |||
16917 | 197539 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 33 Guy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014318.065 | 2114410.62146 | 37.7865734481466 | -122.394223875652 | (37.7865734481466, -122.394223875652) | 6 | 2 | 9 | 28855 | 6 | |||
16930 | 113596 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6013590.96742 | 2118268.55465 | 37.7971259869262 | -122.397010071555 | (37.7971259869262, -122.397010071555) | 3 | 1 | 10 | 28860 | 6 | |||
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 | |||
17515 | 179429 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Brookdale Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6006237.48001 | 2087456.42565 | 37.7121109208587 | -122.420267010915 | (37.7121109208587, -122.420267010915) | 9 | 7 | 8 | 309 | 39 | |||
17557 | 261982 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2403 Keith St | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
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 | ||||
17656 | 261984 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557 Bancroft Ave | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014517 | 2091967 | 37.7249591332222 | -122.391965574806 | (37.7249591332222, -122.391965574806) | 10 | 3 | 8 | 58 | 1 | |||||
17944 | 179467 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 291 France Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001663.65352 | 2090093.9083 | 37.7190940729046 | -122.436264090339 | (37.7190940729046, -122.436264090339) | 9 | 7 | 6 | 28861 | 5 | |||
18019 | 197518 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 407 09th St | 11 | : | Tree | Private 2 | 12 | Width 3ft | 6009751.84387 | 2109320.33027 | 37.772341843132 | -122.409662531815 | (37.772341843132, -122.409662531815) | 14 | 2 | 9 | 28853 | 34 | |||
18053 | 179450 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 49 Brookdale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006580.77916 | 2087379.51909 | 37.7119190900695 | -122.419075015325 | (37.7119190900695, -122.419075015325) | 9 | 7 | 8 | 309 | 39 | |||
18238 | 200676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015656.8366 | 2095323.7293 | 37.7342392575487 | -122.388259416585 | (37.7342392575487, -122.388259416585) | 10 | 3 | 8 | 58 | 1 | |||
18254 | 113592 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6013608.47765 | 2118139.13549 | 37.7967716072789 | -122.396940402888 | (37.7967716072789, -122.396940402888) | 3 | 1 | 10 | 28860 | 6 | |||
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 | |||
19789 | 247187 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 4 | : | Tree | Private 2 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
20431 | 248436 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 755 Ashbury St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5999049.7676 | 2107927.8319 | 37.7679128724009 | -122.446581655831 | (37.7679128724009, -122.446581655831) | 15 | 5 | 11 | 29492 | 9 | |||
20457 | 136393 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3395 Sacramento St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998838.23431 | 2115253.67109 | 37.7880156513567 | -122.447840796819 | (37.7880156513567, -122.447840796819) | 13 | 6 | 1 | 54 | 31 | |||
20493 | 40572 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1750 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.7984424358323 | -122.41375022293 | (37.7984424358323, -122.41375022293) | 3 | 1 | 10 | 308 | 21 | |||
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 | |||
20607 | 123755 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 4ft | 5995425.06371 | 2110766.64717 | 37.7754998049095 | -122.459324614731 | (37.7754998049095, -122.459324614731) | 11 | 6 | 2 | 54 | 11 | |||
20754 | 197513 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | 6009803.31754 | 2109510.05508 | 37.7728656676608 | -122.409497871353 | (37.7728656676608, -122.409497871353) | 14 | 2 | 9 | 28853 | 34 | ||||
20941 | 179443 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 20 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006639.5983 | 2087274.41681 | 37.7116338134302 | -122.418864269997 | (37.7116338134302, -122.418864269997) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
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 | |||
21972 | 197530 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1400 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6013404.894 | 2105708.82045 | 37.7626294689928 | -122.396772970689 | (37.7626294689928, -122.396772970689) | 14 | 3 | 8 | 28856 | 29 | |||
22531 | 138489 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002035.9915 | 2114842.1015 | 37.7870678415341 | -122.436747670692 | (37.7870678415341, -122.436747670692) | 13 | 6 | 11 | 29490 | 27 | |||
22628 | 101981 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | |||
22787 | 215004 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 240 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5996022.14356 | 2090574.20231 | 37.7200906944015 | -122.455799201591 | (37.7200906944015, -122.455799201591) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
23209 | 240568 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 250 Douglass St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001090.59678 | 2104810.17001 | 37.7594689014801 | -122.439299182613 | (37.7594689014801, -122.439299182613) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||
23628 | 179425 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006737.87137 | 2087492.25298 | 37.7122374788398 | -122.418540048182 | (37.7122374788398, -122.418540048182) | 9 | 7 | 8 | 309 | 39 | |||
23706 | 239699 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 157 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997863.73891 | 2105916.05553 | 37.7623212272736 | -122.450538922143 | (37.7623212272736, -122.450538922143) | 15 | 5 | 11 | 29492 | 9 | |||
23977 | 101872 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012644.6557 | 2113099.5202 | 37.782880312512 | -122.39992139618 | (37.782880312512, -122.39992139618) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |||
25497 | 40380 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1700 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1999 12:00:00 AM | 6 | Permit Number 41492 | 6008347.41967 | 2118338.88738 | 37.7970258231379 | -122.415159077534 | (37.7970258231379, -122.415159077534) | 5 | 1 | 10 | 308 | 21 | ||
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 |
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) );