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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5144 | 5144 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Garfield St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x2 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 1683 | 1683 | 251669 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 203 Addison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002642.0 | 2097220.0 | 37.7387162474086 | -122.433391278876 | (37.7387162474086, -122.433391278876) | |||||
| 558 | 558 | 251320 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 35 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6004965.06472 | 2096463.48809 | 37.7367705580153 | -122.425305393447 | (37.7367705580153, -122.425305393447) | ||||
| 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) | ||||
| 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) | ||||
| 150999 | 150999 | 250462 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 290 Seacliff Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5986816.96544 | 2115727.4811 | 37.7886221640356 | -122.489466544563 | (37.7886221640356, -122.489466544563) | |||
| 29127 | 29127 | 250321 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 247 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987414.73446 | 2114306.1636799998 | 37.7847545126541 | -122.487293940769 | (37.7847545126541, -122.487293940769) | |||
| 137903 | 137903 | 250320 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 255 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 5987417.56987 | 2114243.0271099997 | 37.78458132302389 | -122.487279492276 | (37.7845813230239, -122.487279492276) | |||
| 56840 | 56840 | 248529 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 45 Beulah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997709.9004 | 2107802.0064 | 37.7674907631986 | -122.451207005854 | (37.7674907631986, -122.451207005854) | |||
| 30844 | 30844 | 248436 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 755 Ashbury St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999049.7676 | 2107927.8319 | 37.7679128724009 | -122.446581655831 | (37.7679128724009, -122.446581655831) | |||
| 151449 | 151449 | 247579 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6008670.31016 | 2095309.15662 | 37.733809649895704 | -122.412413126286 | (37.7338096498957, -122.412413126286) | ||||
| 136198 | 136198 | 247576 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 350x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6008435.75806 | 2095170.56175 | 37.733415932988 | -122.413214248635 | (37.733415932988, -122.413214248635) | ||||
| 162855 | 162855 | 247472 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 838 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002550.7646 | 2109563.4235 | 37.772603159446 | -122.434589085205 | (37.772603159446, -122.434589085205) | |||
| 171971 | 171971 | 247279 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 403 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998855.5655 | 2109315.1105 | 37.7717108924434 | -122.44735323778299 | (37.7717108924434, -122.447353237783) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |
| 3590 | 3590 | 246905 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 491 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 5997325.00222 | 2107400.6153700002 | 37.76636660087539 | -122.45250934033501 | (37.7663666008754, -122.452509340335) | |||
| 162638 | 162638 | 246599 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 52 Waller St | 5 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6005448.395330001 | 2109271.63735 | 37.771966052416204 | -122.42454510838999 | (37.7719660524162, -122.42454510839) | |||
| 65713 | 65713 | 246598 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 52 Waller St | 4 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6005467.40356 | 2109274.31341 | 37.7719744736758 | -122.424479547814 | (37.7719744736758, -122.424479547814) | |||
| 166887 | 166887 | 246597 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 52 Waller St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6005485.469380001 | 2109277.24468 | 37.7719835424264 | -122.42441726525 | (37.7719835424264, -122.42441726525) | |||
| 75261 | 75261 | 246592 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 22 Waller St | 3 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6005574.158530001 | 2109287.40717 | 37.7720164540359 | -122.42411120528 | (37.7720164540359, -122.42411120528) | |||
| 137146 | 137146 | 246591 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 22 Waller St | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6005592.7822199995 | 2109289.94448 | 37.772024472369296 | -122.424046964897 | (37.7720244723693, -122.424046964897) | |||
| 130577 | 130577 | 246583 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Waller St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6005277.33485 | 2109248.26095 | 37.7718922045878 | -122.425135156289 | (37.7718922045878, -122.425135156289) | |||
| 40326 | 40326 | 246423 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 406 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6003794.9997 | 2099851.1264400003 | 37.746006061224605 | -122.429592349221 | (37.7460060612246, -122.429592349221) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 171585 | 171585 | 246203 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1362 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999565.7884 | 2108011.1099 | 37.7681709945121 | -122.444802791675 | (37.7681709945121, -122.444802791675) | |||
| 172577 | 172577 | 246195 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 44 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999308.8379 | 2108061.5309 | 37.7682947708765 | -122.44569518043899 | (37.7682947708765, -122.445695180439) | |||
| 63925 | 63925 | 246036 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1687 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997980.9324 | 2108530.6132 | 37.7695068460444 | -122.45032207437299 | (37.7695068460444, -122.450322074373) | |||
| 38252 | 38252 | 245993 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1419 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999291.5767 | 2108712.9163 | 37.7700823250716 | -122.44580173719801 | (37.7700823250716, -122.445801737198) | |||
| 24298 | 24298 | 245128 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1260 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000529.8828 | 2109280.0723 | 37.771710219180704 | -122.44155916996799 | (37.7717102191807, -122.441559169968) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 179720 | 179720 | 245039 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 17 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6000809.9165 | 2109164.6772 | 37.77140932347 | -122.440582240102 | (37.77140932347, -122.440582240102) | |||
| 74448 | 74448 | 245018 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1227 Page St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 6000617.788 | 2109248.6444 | 37.7716289338677 | -122.441252845835 | (37.7716289338677, -122.441252845835) | |||
| 71162 | 71162 | 245017 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1221 Page St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6000631.5454 | 2109250.0676 | 37.771633625281204 | -122.441205360431 | (37.7716336252812, -122.441205360431) | |||
| 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) | |||
| 61751 | 61751 | 245011 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1209 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000668.5479 | 2109254.8115 | 37.7716487585204 | -122.441077707327 | (37.7716487585204, -122.441077707327) | |||
| 169570 | 169570 | 240593 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 73 Digby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002622.320780001 | 2097674.9320400003 | 37.7399642691366 | -122.43349182218901 | (37.7399642691366, -122.433491822189) | |||
| 160552 | 160552 | 240592 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 173 Addison St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6002743.40651 | 2097027.59166 | 37.7381936910731 | -122.433026920383 | (37.7381936910731, -122.433026920383) | |||
| 182576 | 182576 | 240591 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Randall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6004224.31251 | 2097557.73547 | 37.7397332350934 | -122.42794444859 | (37.7397332350934, -122.42794444859) | |||
| 131458 | 131458 | 240590 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 84 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004278.144169999 | 2097692.06256 | 37.7401051119636 | -122.42776789007799 | (37.7401051119636, -122.427767890078) | |||
| 172534 | 172534 | 240589 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 78 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004277.11991 | 2097713.84146 | 37.7401648539148 | -122.42777298293998 | (37.7401648539148, -122.42777298294) | |||
| 158458 | 158458 | 240588 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 74 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004274.45467 | 2097751.30027 | 37.740267556492796 | -122.427784866605 | (37.7402675564928, -122.427784866605) | |||
| 180266 | 180266 | 240587 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 58 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004267.39265 | 2097885.16963 | 37.740634731706706 | -122.427818820486 | (37.7406347317067, -122.427818820486) | |||
| 2991 | 2991 | 240586 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 117 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 2 | Width 3ft | Permit Number 37769 | 6003553.878330001 | 2108799.61563 | 37.770562824039004 | -122.431064686005 | (37.770562824039, -122.431064686005) | |
| 186220 | 186220 | 240585 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 334 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999374.09078 | 2105029.48188 | 37.7599732475924 | -122.445251453514 | (37.7599732475924, -122.445251453514) | |||
| 68235 | 68235 | 240584 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 141 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6000210.52128 | 2106191.6022200002 | 37.7632118519771 | -122.442442087458 | (37.7632118519771, -122.442442087458) | |||
| 60008 | 60008 | 240583 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 60 Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000828.16342 | 2106033.71202 | 37.7628135098535 | -122.44029455045401 | (37.7628135098535, -122.440294550454) | |||
| 1891 | 1891 | 240582 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 8 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 15 | Width 3ft | Permit Number 9985 | 6003834.4345 | 2107034.98465 | 37.765733469154796 | -122.429968344076 | (37.7657334691548, -122.429968344076) | |
| 184070 | 184070 | 240581 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 34 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003132.18994 | 2108077.2132 | 37.768555379853 | -122.43247170321699 | (37.768555379853, -122.432471703217) | |||
| 132508 | 132508 | 240580 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3570 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004566.70015 | 2103688.08598 | 37.756585123718295 | -122.427197171329 | (37.7565851237183, -122.427197171329) | |||
| 50278 | 50278 | 240579 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3560 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004617.41249 | 2103694.30226 | 37.756605059890006 | -122.42702223251601 | (37.75660505989, -122.427022232516) | |||
| 68957 | 68957 | 240578 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3636 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004112.69332 | 2103663.95963 | 37.756493193229105 | -122.428765570083 | (37.7564931932291, -122.428765570083) | |||
| 136226 | 136226 | 240577 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3632 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004145.28001 | 2103668.18027 | 37.756506626382 | -122.42865317459999 | (37.756506626382, -122.4286531746) | |||
| 165501 | 165501 | 240576 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3959 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003949.10391 | 2104197.56099 | 37.7579490759979 | -122.42936937040501 | (37.7579490759979, -122.429369370405) | |||
| 54306 | 54306 | 240575 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3971 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003902.14198 | 2104194.35497 | 37.7579376141555 | -122.429531555935 | (37.7579376141555, -122.429531555935) | |||
| 174107 | 174107 | 240574 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 676 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003010.1193699995 | 2104332.09959 | 37.7582652812248 | -122.43262638302099 | (37.7582652812248, -122.432626383021) | |||
| 70647 | 70647 | 240573 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 670 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003005.753769999 | 2104417.0904200003 | 37.758498398109296 | -122.432647552151 | (37.7584983981093, -122.432647552151) | |||
| 50722 | 50722 | 240572 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 210 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6002036.98136 | 2104624.07975 | 37.7590117527075 | -122.436012807155 | (37.7590117527075, -122.436012807155) | |||
| 73355 | 73355 | 240571 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 387 Eureka St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001511.27704 | 2103588.18103 | 37.7561375464167 | -122.43775674549101 | (37.7561375464167, -122.437756745491) | |||
| 171746 | 171746 | 240570 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 387 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001514.84125 | 2103575.85133 | 37.7561038947038 | -122.43774353625099 | (37.7561038947038, -122.437743536251) | |||
| 41351 | 41351 | 240569 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 22 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6000897.89001 | 2104935.4269999997 | 37.759801858378296 | -122.439974637337 | (37.7598018583783, -122.439974637337) | |||
| 158354 | 158354 | 240568 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 250 Douglass St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001090.59678 | 2104810.17001 | 37.759468901480105 | -122.43929918261298 | (37.7594689014801, -122.439299182613) | |||
| 177818 | 177818 | 240567 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 210 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001076.42176 | 2105089.43303 | 37.760234882849296 | -122.43936822445801 | (37.7602348828493, -122.439368224458) | |||
| 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) | |||
| 48114 | 48114 | 240565 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 131 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000404.48259 | 2104877.48466 | 37.7596146626978 | -122.441676928051 | (37.7596146626978, -122.441676928051) | |||
| 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) | |||
| 50574 | 50574 | 240562 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3818 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004117.0123 | 2105424.98126 | 37.761328784908 | -122.428876176805 | (37.761328784908, -122.428876176805) | |||
| 70903 | 70903 | 240561 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3920 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003501.0136400005 | 2104802.03657 | 37.7595834427499 | -122.43096219566401 | (37.7595834427499, -122.430962195664) | |||
| 165240 | 165240 | 240560 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 55 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6003262.809119999 | 2105621.97436 | 37.761821295028795 | -122.431844570873 | (37.7618212950288, -122.431844570873) | |||
| 167575 | 167575 | 240559 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 981 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003807.83193 | 2102569.2157400004 | 37.7534700259438 | -122.42974180934999 | (37.7534700259438, -122.42974180935) | |||
| 181053 | 181053 | 240558 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 983 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003807.25002 | 2102556.49662 | 37.7534350692835 | -122.42974291460199 | (37.7534350692835, -122.429742914602) | |||
| 134958 | 134958 | 240557 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 983 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003809.26979 | 2102545.9517099997 | 37.753406229815 | -122.429735177759 | (37.753406229815, -122.429735177759) | |||
| 146656 | 146656 | 240556 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 985 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003810.48686 | 2102527.4663299997 | 37.7533555422307 | -122.42972965052401 | (37.7533555422307, -122.429729650524) | |||
| 45807 | 45807 | 240555 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 133 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6004136.97088 | 2102299.45232 | 37.752747951271 | -122.428584348611 | (37.752747951271, -122.428584348611) | |||
| 33832 | 33832 | 240554 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3749 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003416.631030001 | 2102998.4591599996 | 37.754626466853 | -122.43112530030399 | (37.754626466853, -122.431125300304) | |||
| 133151 | 133151 | 240553 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3753 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003393.33421 | 2102997.6662 | 37.7546229693892 | -122.431205810308 | (37.7546229693892, -122.431205810308) | |||
| 3336 | 3336 | 240552 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3760 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003400.0 | 2103058.0 | 37.7547890094532 | -122.431187064477 | (37.7547890094532, -122.431187064477) | |||
| 185258 | 185258 | 240551 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3756 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6003427.24726 | 2103041.80363 | 37.754746082084 | -122.431091680056 | (37.754746082084, -122.431091680056) | |||
| 37740 | 37740 | 240550 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 437 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003457.73972 | 2103292.10883 | 37.755435088681104 | -122.43100409237101 | (37.7554350886811, -122.431004092371) | |||
| 67417 | 67417 | 240549 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 426 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6003562.13775 | 2103342.68871 | 37.755579884022396 | -122.430646661337 | (37.7555798840224, -122.430646661337) | |||
| 30398 | 30398 | 240548 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4172 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002753.681480001 | 2101252.12814 | 37.7497938663026 | -122.433293177244 | (37.7497938663026, -122.433293177244) | |||
| 154218 | 154218 | 240547 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4250 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001501.769619999 | 2102352.07867 | 37.752742966328 | -122.437701100834 | (37.752742966328, -122.437701100834) | |||
| 162793 | 162793 | 240546 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4250 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001520.014140001 | 2102352.06442 | 37.752743964562704 | -122.437638007099 | (37.7527439645627, -122.437638007099) | |||
| 147978 | 147978 | 240545 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4390 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001366.11149 | 2101175.74148 | 37.749505311641 | -122.43808597291401 | (37.749505311641, -122.438085972914) | |||
| 62881 | 62881 | 240544 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4394 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001352.20572 | 2101173.84913 | 37.749499324853794 | -122.43813392383801 | (37.7494993248538, -122.438133923838) | |||
| 74432 | 74432 | 240543 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 35 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004965.06472 | 2096463.48809 | 37.7367705580153 | -122.425305393447 | (37.7367705580153, -122.425305393447) | |||
| 68470 | 68470 | 240542 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 16 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005688.97439 | 2099659.64125 | 37.7455873449931 | -122.42302962122601 | (37.7455873449931, -122.423029621226) | |||
| 115837 | 115837 | 240541 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 72 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6005497.388259999 | 2099648.86664 | 37.7455469474293 | -122.423691331589 | (37.7455469474293, -122.423691331589) | |||
| 160905 | 160905 | 240540 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 76 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6005479.08955 | 2099648.54226 | 37.745545023799295 | -122.423754582708 | (37.7455450237993, -122.423754582708) | |||
| 58405 | 58405 | 240539 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 78 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6005465.00298 | 2099647.78115 | 37.745542138759205 | -122.423803237831 | (37.7455421387592, -122.423803237831) | |||
| 151999 | 151999 | 240538 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 57 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005573.724780001 | 2099614.71997 | 37.7454574972629 | -122.42342494431699 | (37.7454574972629, -122.423424944317) |
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");