Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46825 | 46825 | 179482 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5988878.80429 | 2090370.98469 | 37.719120158641296 | -122.48047615337 | (37.7191201586413, -122.48047615337) | ||||
| 54855 | 54855 | 179483 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5988918.9165199995 | 2090347.02209 | 37.7190566943955 | -122.48033574940399 | (37.7190566943955, -122.480335749404) | ||||
| 153866 | 153866 | 179481 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5988902.49405 | 2090393.59661 | 37.7191836220039 | -122.480395922129 | (37.7191836220039, -122.480395922129) | ||||
| 171956 | 171956 | 179479 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989502.72531 | 2090743.3416900001 | 37.7201787974032 | -122.478346734135 | (37.7201787974032, -122.478346734135) | ||||
| 180579 | 180579 | 179484 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5988536.49014 | 2090373.27915 | 37.719106559100396 | -122.48165955597099 | (37.7191065591004, -122.481659555971) | ||||
| 187686 | 187686 | 179478 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989807.06872 | 2090726.39006 | 37.720149915678 | -122.477293493993 | (37.720149915678, -122.477293493993) | ||||
| 106967 | 106967 | 33954 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1999 12:00:00 AM | Permit Number 48991 | 6002287.323724099 | 2097040.91143479 | 37.7382043832783 | -122.43460477820899 | (37.7382043832783, -122.434604778209) | |||
| 53 | 53 | 251187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000800.0 | 2109063.0 | 37.771129578660705 | -122.440609247553 | (37.7711295786607, -122.440609247553) | ||||
| 68 | 68 | 251188 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000800.0 | 2109063.0 | 37.771129578660705 | -122.440609247553 | (37.7711295786607, -122.440609247553) | ||||
| 33262 | 33262 | 245058 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000819.4043 | 2109108.2246 | 37.771254859042294 | -122.440545371757 | (37.7712548590423, -122.440545371757) | |||
| 41432 | 41432 | 245059 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000823.1995 | 2109073.1196 | 37.77115868561361 | -122.44052972578001 | (37.7711586856136, -122.44052972578) | |||
| 65307 | 65307 | 245060 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000828.8922 | 2109039.4379 | 37.7710665282542 | -122.440507618445 | (37.7710665282542, -122.440507618445) | |||
| 5171 | 5171 | 247184 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 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) | |
| 5187 | 5187 | 247186 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.770700815109294 | -122.439956869431 | (37.7707008151093, -122.439956869431) | ||
| 23825 | 23825 | 247187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | |||
| 26119 | 26119 | 247188 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6000957.547669999 | 2108914.20808 | 37.7707300035244 | -122.440053614886 | (37.7707300035244, -122.440053614886) | |||
| 163467 | 163467 | 247185 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6000997.16935 | 2108899.56704 | 37.7706920584128 | -122.43991551320299 | (37.7706920584128, -122.439915513203) | |||
| 24944 | 24944 | 240564 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 10 Hancock St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004144.38287 | 2105130.57099 | 37.7605219536452 | -122.428760524878 | (37.7605219536452, -122.428760524878) | |||
| 53204 | 53204 | 240563 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 10 Hancock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004179.51855 | 2105131.83325 | 37.7605274080343 | -122.42863909661999 | (37.7605274080343, -122.42863909662) | |||
| 125698 | 125698 | 54244 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 10 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 24 | Permit Number 9985 | 6003826.70188878 | 2107089.19403693 | 37.7658818771202 | -122.42999895682699 | (37.7658818771202, -122.429998956827) | ||
| 42864 | 42864 | 197567 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6011782.82118 | 2107497.01248 | 37.767449026680495 | -122.402508917767 | (37.7674490266805, -122.402508917767) | |||
| 44607 | 44607 | 197563 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011871.68658 | 2107504.14213 | 37.767473563784996 | -122.40220204389799 | (37.767473563785, -122.402202043898) | |||
| 52817 | 52817 | 197564 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011853.28866 | 2107502.0789900003 | 37.7674668719146 | -122.402265535131 | (37.7674668719146, -122.402265535131) | |||
| 58063 | 58063 | 197566 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6011795.68975 | 2107497.96925 | 37.7674523721611 | -122.402464474151 | (37.7674523721611, -122.402464474151) | |||
| 61327 | 61327 | 197568 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6011770.36838 | 2107496.4530700003 | 37.7674467954558 | -122.40255195122299 | (37.7674467954558, -122.402551951223) | |||
| 147722 | 147722 | 197561 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011901.49708 | 2107505.7702099998 | 37.7674796980447 | -122.402099047246 | (37.7674796980447, -122.402099047246) | |||
| 154363 | 154363 | 197560 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6011918.46378 | 2107507.65941 | 37.7674858323444 | -122.40204049418502 | (37.7674858323444, -122.402040494185) | |||
| 169400 | 169400 | 197562 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011885.98223 | 2107505.07026 | 37.7674769101657 | -122.402152662133 | (37.7674769101657, -122.402152662133) | |||
| 178891 | 178891 | 197565 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011813.28863 | 2107500.86119 | 37.767461295230795 | -122.40240380501899 | (37.7674612952308, -122.402403805019) | |||
| 55379 | 55379 | 179487 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Capistrano Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6001448.45649 | 2093575.59463 | 37.728641765884106 | -122.437257104634 | (37.7286417658841, -122.437257104634) | |||
| 75649 | 75649 | 179486 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Capistrano Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6001448.8581300005 | 2093594.99443 | 37.7286950561315 | -122.437257104643 | (37.7286950561315, -122.437257104643) | |||
| 147089 | 147089 | 179485 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6001441.34691 | 2093639.06415 | 37.7288156345119 | -122.437286225591 | (37.7288156345119, -122.437286225591) | |||
| 180406 | 180406 | 62238 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2003 12:00:00 AM | 21 | Permit Number 22364 | 6001428.6005 | 2093653.6375099998 | 37.7288549250112 | -122.437331333801 | (37.7288549250112, -122.437331333801) | |
| 11322 | 11322 | 19745 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
| 168 | 168 | 179480 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5989599.0 | 2090767.0 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | ||||
| 100932 | 100932 | 66607 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1991 12:00:00 AM | 12 | Permit Number 29802 | 5989869.39246895 | 2090726.40504468 | 37.7201535727537 | -122.477078065149 | (37.7201535727537, -122.477078065149) | ||
| 149457 | 149457 | 141823 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6004743.395 | 2112299.7812 | 37.7802407554337 | -122.42719949208099 | (37.7802407554337, -122.427199492081) | |||
| 83117 | 83117 | 14776 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 06/30/1994 12:00:00 AM | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
| 110180 | 110180 | 14775 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | |||
| 122469 | 122469 | 14777 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | |||
| 123500 | 123500 | 14771 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 18 | 4x4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | |||
| 126868 | 126868 | 14772 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 06/30/1994 12:00:00 AM | 18 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
| 142048 | 142048 | 12322 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1008X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004729.34594 | 2112297.27395 | 37.7802330766406 | -122.427247915616 | (37.7802330766406, -122.427247915616) | |||
| 24323 | 24323 | 197548 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6011737.58275 | 2107186.1268599997 | 37.766592879273404 | -122.402643527378 | (37.7665928792734, -122.402643527378) | |||
| 30301 | 30301 | 197549 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011738.81307 | 2107215.77896 | 37.766674365946 | -122.402641357327 | (37.766674365946, -122.402641357327) | |||
| 32934 | 32934 | 197552 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011729.09071 | 2107385.60351 | 37.7671401230397 | -122.40268692957399 | (37.7671401230397, -122.402686929574) | |||
| 53284 | 53284 | 197543 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6011744.4821 | 2107062.59215 | 37.7662540659871 | -122.40261097552799 | (37.7662540659871, -122.402610975528) | |||
| 53313 | 53313 | 197550 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6011736.4606800005 | 2107238.9435 | 37.766737839213796 | -122.402651123063 | (37.7667378392138, -122.402651123063) | |||
| 59988 | 59988 | 197546 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011743.17098 | 2107136.9679900003 | 37.7664582120893 | -122.402620741247 | (37.7664582120893, -122.402620741247) | |||
| 137636 | 137636 | 197551 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011729.235280001 | 2107361.85894 | 37.7670749338806 | -122.402684759517 | (37.7670749338806, -122.402684759517) | |||
| 160468 | 160468 | 197544 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6011744.689040001 | 2107088.20402 | 37.766324401967 | -122.402612061007 | (37.766324401967, -122.402612061007) | |||
| 164314 | 164314 | 197545 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6011743.33462 | 2107114.1601 | 37.7663955958981 | -122.40261857118401 | (37.7663955958981, -122.402618571184) | |||
| 173328 | 173328 | 197547 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6011743.058130001 | 2107162.2739 | 37.7665276901155 | -122.402622911324 | (37.7665276901155, -122.402622911324) | |||
| 177504 | 177504 | 197553 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6011728.60069 | 2107407.7927900003 | 37.7672010224355 | -122.402690185116 | (37.7672010224355, -122.402690185116) | |||
| 115289 | 115289 | 105020 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101X ORD ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6000863.0 | 2105739.0 | 37.7620062865301 | -122.44015292861602 | (37.7620062865301, -122.440152928616) | ||||
| 104206 | 104206 | 66239 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29337 | 5995901.80991046 | 2090714.82365274 | 37.720469900548004 | -122.45622531376301 | (37.720469900548, -122.456225313763) | ||
| 63285 | 63285 | 240524 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1023 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5997228.0393199995 | 2107019.29645 | 37.7653140406215 | -122.452817189965 | (37.7653140406215, -122.452817189965) | |||
| 75112 | 75112 | 123757 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 103 Cabrillo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5995251.69378 | 2110760.6379299997 | 37.7754733358801 | -122.459923903312 | (37.7754733358801, -122.459923903312) | |||
| 18223 | 18223 | 14566 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1030 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5999382.6721 | 2109282.399 | 37.771651181181504 | -122.445527596882 | (37.7716511811815, -122.445527596882) | |||
| 136734 | 136734 | 239703 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1048 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5998155.7967300005 | 2106630.88901 | 37.764300691739294 | -122.44958031947701 | (37.7643006917393, -122.449580319477) | |||
| 28634 | 28634 | 141934 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004016.7876 | 2111854.945 | 37.7789782281051 | -122.42968142536199 | (37.7789782281051, -122.429681425362) | |||
| 35537 | 35537 | 141930 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004152.017000001 | 2111873.3634 | 37.7790364568014 | -122.42921492627701 | (37.7790364568014, -122.429214926277) | |||
| 57850 | 57850 | 141929 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050 MCALLISTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 6004201.9404 | 2111879.6644 | 37.7790565838512 | -122.429042670434 | (37.7790565838512, -122.429042670434) | |||
| 177752 | 177752 | 141935 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050 MCALLISTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003990.6142 | 2111850.0981 | 37.7789634376361 | -122.42977162384399 | (37.7789634376361, -122.429771623844) | |||
| 179700 | 179700 | 141933 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004066.711 | 2111861.7308 | 37.77899968697729 | -122.429509204364 | (37.7789996869773, -122.429509204364) | |||
| 117166 | 117166 | 17371 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5999379.151930001 | 2109268.47217 | 37.771612740675394 | -122.44553877169399 | (37.7716127406754, -122.445538771694) | |||
| 46348 | 46348 | 197519 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1055 Natoma St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6007591.229180001 | 2109427.92338 | 37.772515957284206 | -122.417143942455 | (37.7725159572842, -122.417143942455) | |||
| 78819 | 78819 | 96967 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1060 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x9 | Created tree record on 8/15/2011; marked tree basin for expansion. C.Buck | 6003141.0 | 2102066.0 | 37.7520505318065 | -122.432011924137 | (37.7520505318065, -122.432011924137) | |||
| 82175 | 82175 | 67999 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31724 | 5995906.21686349 | 2090968.00525531 | 37.721165330271795 | -122.456228376798 | (37.7211653302718, -122.456228376798) | ||
| 131726 | 131726 | 215001 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995907.45606 | 2090967.9456200001 | 37.72116523766171 | -122.45622408896999 | (37.7211652376617, -122.45622408897) | |||
| 47632 | 47632 | 62229 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 107 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 9 | Permit Number 22354 | 6001481.45016 | 2093645.47099 | 37.728835505929396 | -122.43714804475701 | (37.7288355059294, -122.437148044757) | |
| 143106 | 143106 | 245014 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1070 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5999399.1249 | 2109164.2378 | 37.771327679754 | -122.44546218799 | (37.771327679754, -122.44546218799) | |||
| 39386 | 39386 | 215002 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995954.159990001 | 2091115.9744900002 | 37.7215743707347 | -122.45607334462099 | (37.7215743707347, -122.456073344621) | |||
| 95085 | 95085 | 68000 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1993 12:00:00 AM | Permit Number 31725 | 5995961.29385488 | 2091144.32738343 | 37.721652630536205 | -122.456050733712 | (37.7216526305362, -122.456050733712) | ||
| 99577 | 99577 | 41627 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1095 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | |||
| 116686 | 116686 | 41628 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1095 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | |||
| 54777 | 54777 | 114770 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | ||||
| 60746 | 60746 | 246229 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5999439.8115 | 2107740.3807 | 37.767420450212605 | -122.44521906453001 | (37.7674204502126, -122.44521906453) | |||
| 71565 | 71565 | 246230 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999421.9446 | 2107737.958 | 37.767412778225896 | -122.445280689263 | (37.7674127782259, -122.445280689263) | |||
| 76650 | 76650 | 246228 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5999452.5303 | 2107741.8948 | 37.7674253335335 | -122.44517518096501 | (37.7674253335335, -122.445175180965) | |||
| 104742 | 104742 | 114771 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | ||||
| 121002 | 121002 | 114772 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | ||||
| 122057 | 122057 | 114773 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | ||||
| 134168 | 134168 | 246227 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999464.6435 | 2107744.6203 | 37.767433508471704 | -122.445133479177 | (37.7674335084717, -122.445133479177) | |||
| 51841 | 51841 | 179460 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6000997.30077 | 2089688.71555 | 37.7179436214658 | -122.43853839394698 | (37.7179436214658, -122.438538393947) | |||
| 67398 | 67398 | 179461 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000982.149259999 | 2089697.7577900002 | 37.7179675875255 | -122.43859141348999 | (37.7179675875255, -122.43859141349) | |||
| 158626 | 158626 | 179458 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Italy Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6001021.22839 | 2089673.6831200002 | 37.7179037068739 | -122.438454610411 | (37.7179037068739, -122.438454610411) | |||
| 167077 | 167077 | 179459 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Italy Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6001007.64891 | 2089683.17948 | 37.7179290093058 | -122.43850222861201 | (37.7179290093058, -122.438502228612) | |||
| 3190 | 3190 | 9537 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004100.4915 | 2112210.9093 | 37.779960357201205 | -122.429417251502 | (37.7799603572012, -122.429417251502) | ||
| 7831 | 7831 | 9536 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004118.455 | 2112215.6365 | 37.779974353933 | -122.42935544491999 | (37.779974353933, -122.42935544492) | ||
| 8608 | 8608 | 9533 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6004176.1272 | 2112221.7819 | 37.7799944925987 | -122.429156369266 | (37.7799944925987, -122.429156369266) | |||
| 139901 | 139901 | 9540 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | ||
| 68086 | 68086 | 30941 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1101 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 10 | Permit Number 34750 | 5995913.71268 | 2091275.1809 | 37.7220091920614 | -122.45622466453199 | (37.7220091920614, -122.456224664532) | |
| 173082 | 173082 | 141838 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1103 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004708.7161 | 2112593.1646 | 37.7810443525714 | -122.42734036774401 | (37.7810443525714, -122.427340367744) | |||
| 127798 | 127798 | 12333 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1105X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6004706.6254900005 | 2112590.71039 | 37.78103749568189 | -122.427347425327 | (37.7810374956819, -122.427347425327) | |||
| 1073 | 1073 | 22619 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1107 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6004653.0794 | 2112584.8191 | 37.7810182911755 | -122.42753224810801 | (37.7810182911755, -122.427532248108) | |||
| 74718 | 74718 | 240566 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 111 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000512.65205 | 2104881.02417 | 37.759630543828 | -122.441303078972 | (37.759630543828, -122.441303078972) | |||
| 55322 | 55322 | 239696 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 112 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5997951.3916 | 2106835.98646 | 37.7648521416436 | -122.450302081196 | (37.7648521416436, -122.450302081196) | |||
| 171134 | 171134 | 136408 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1120 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008149.75151 | 2118608.08883 | 37.7977538729053 | -122.41586213153299 | (37.7977538729053, -122.415862131533) | |||
| 67706 | 67706 | 197576 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1121 Jamestown Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6013293.0543 | 2090118.55817 | 37.7198156565414 | -122.39606716838101 | (37.7198156565414, -122.396067168381) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");