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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 478 | 478 | 142161 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 490X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
| 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) | ||||
| 676 | 676 | 214191 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 363 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 14 | Width 3ft | Permit Number 10790 | 5992756.72765 | 2094187.53129 | 37.7298240632085 | -122.467349144256 | (37.7298240632085, -122.467349144256) | |
| 680 | 680 | 214193 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 347 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 19 | Width 3ft | Permit Number 9508 | 5992820.4639099995 | 2094345.69157 | 37.7302620114641 | -122.467140297392 | (37.7302620114641, -122.467140297392) | |
| 685 | 685 | 214192 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 359 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 16 | Width 3ft | Permit Number 9509 | 5992777.37887 | 2094232.46292 | 37.7299486265111 | -122.46728101702 | (37.7299486265111, -122.46728101702) | |
| 688 | 688 | 214188 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 358 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1972 12:00:00 AM | 21 | Width 3ft | Permit Number 9461 | 5992780.99407 | 2094319.4986599998 | 37.7301878137975 | -122.467274844971 | (37.7301878137975, -122.467274844971) | |
| 693 | 693 | 214190 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 393 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2009 12:00:00 AM | 17 | Width 3ft | Permit Number 53039 | 5992606.38416 | 2093945.5647200001 | 37.7291510025005 | -122.46785130231501 | (37.7291510025005, -122.467851302315) | |
| 1250 | 1250 | 31791 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 186 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2017 12:00:00 AM | 3 | Permit Number 779904 | 6001704.83909 | 2107714.56044 | 37.767478581987206 | -122.437382809181 | (37.7674785819872, -122.437382809181) | |
| 1630 | 1630 | 27410 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2184 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1999 12:00:00 AM | 8 | 3X3 | 5997011.7697 | 2109487.1799 | 37.7720778184275 | -122.453743436192 | (37.7720778184275, -122.453743436192) | ||
| 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) | |||||
| 1701 | 1701 | 239730 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1709 Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779965 | 6002631.28239 | 2100576.89579 | 37.747932892899705 | -122.43366818554199 | (37.7479328928997, -122.433668185542) | |
| 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) | |
| 1987 | 1987 | 123759 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 201 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2016 12:00:00 AM | 18 | Width 5ft | 5994972.5884300005 | 2110752.02511 | 37.775433631632296 | -122.46088876401501 | (37.7754336316323, -122.460888764015) | ||
| 2267 | 2267 | 27407 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2172 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997059.3832 | 2109492.2362 | 37.772094431296104 | -122.453579103335 | (37.7720944312961, -122.453579103335) | ||
| 2520 | 2520 | 141903 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004752.7943 | 2111956.4883 | 37.7792986892944 | -122.42714251637699 | (37.7792986892944, -122.427142516377) | |||
| 2521 | 2521 | 141908 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004604.7205 | 2111934.4347 | 37.779229760906205 | -122.42765319377199 | (37.7792297609062, -122.427653193772) | |||
| 2523 | 2523 | 141904 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6004738.7382 | 2111954.0648 | 37.7792912400822 | -122.42719096962601 | (37.7792912400822, -122.427190969626) | |||
| 2527 | 2527 | 141910 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6004551.4043 | 2111926.6796 | 37.7792054513567 | -122.42783708385099 | (37.7792054513567, -122.427837083851) | |||
| 2534 | 2534 | 141911 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004522.3227 | 2111922.8021 | 37.7791931595072 | -122.427937412735 | (37.7791931595072, -122.427937412735) | |||
| 2547 | 2547 | 141912 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6004447.1952 | 2111915.047 | 37.7791676154415 | -122.42819675688 | (37.7791676154415, -122.42819675688) | |||
| 2683 | 2683 | 71631 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 678 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2017 12:00:00 AM | 3 | Permit Number 780356 | 5984775.35157 | 2111233.16415 | 37.776162677429205 | -122.496198392825 | (37.7761626774292, -122.496198392825) | |
| 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) | |
| 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) | |||
| 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) | |||
| 5116 | 5116 | 123752 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995621.16362 | 2110827.61225 | 37.77567847155 | -122.45865067705799 | (37.77567847155, -122.458650677058) | |||
| 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) | ||||
| 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) | ||
| 5250 | 5250 | 239740 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1314 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2017 12:00:00 AM | 3 | 6x6 | 6003222.89805 | 2100527.56399 | 37.747830990701104 | -122.431618884227 | (37.7478309907011, -122.431618884227) | ||
| 7015 | 7015 | 23458 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2252 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 4X4 | 6005965.50421 | 2118183.1057 | 37.7964639393172 | -122.423390011952 | (37.7964639393172, -122.423390011952) | |||
| 8322 | 8322 | 106721 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1445 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999673.9299 | 2113871.5922 | 37.7842685529811 | -122.444850062171 | (37.7842685529811, -122.444850062171) | |||
| 8946 | 8946 | 14523 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 625 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4x4 | 5999129.3058 | 2110654.1301 | 37.7754031370148 | -122.446502707181 | (37.7754031370148, -122.446502707181) | |||
| 9240 | 9240 | 18089 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3000 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5999515.0867 | 2114695.0726 | 37.786520549411996 | -122.445458834419 | (37.786520549412, -122.445458834419) | |||
| 9793 | 9793 | 43684 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 583 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779365 | 5993748.11926 | 2111537.7275799997 | 37.777520428161296 | -122.46518153966998 | (37.7775204281613, -122.46518153967) | |
| 9811 | 9811 | 219588 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98x Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005256.0 | 2109297.0 | 37.7720248250001 | -122.42521242385 | (37.7720248250001, -122.42521242385) | ||||
| 9887 | 9887 | 51349 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 6401 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2004 12:00:00 AM | Permit Number 47697 | ||||||||
| 10386 | 10386 | 97218 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 539 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000286.32734 | 2092915.99472 | 37.7267645246623 | -122.441227336289 | (37.7267645246623, -122.441227336289) | |||
| 10986 | 10986 | 26279 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1866 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000327.26475 | 2093225.38093 | 37.7276163597935 | -122.441108004333 | (37.7276163597935, -122.441108004333) | |||
| 11226 | 11226 | 110358 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1830 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5990014.2377 | 2106553.7919 | 37.7636198770855 | -122.477733734661 | (37.7636198770855, -122.477733734661) | |||
| 13580 | 13580 | 44030 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 96 Lafayette St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52444 | 6007681.41962 | 2109502.84398 | 37.7727267448872 | -122.416837272729 | (37.7727267448872, -122.416837272729) | |
| 14450 | 14450 | 28531 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2012 12:00:00 AM | 18 | 3X3 | Permit Number 769387 | 6010735.412690001 | 2111831.43795 | 37.77929182908439 | -122.406437232011 | (37.7792918290844, -122.406437232011) | |
| 14494 | 14494 | 28530 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | Permit Number 769387 | 6010745.98493 | 2111818.73382 | 37.77925753794229 | -122.40639976265301 | (37.7792575379423, -122.406399762653) | ||
| 16574 | 16574 | 28532 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | Permit Number 769387 | 6010727.06736 | 2111841.54231 | 37.7793191064344 | -122.40646681431299 | (37.7793191064344, -122.406466814313) | ||
| 16678 | 16678 | 101870 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779151 | 6012595.5925 | 2113052.7427 | 37.782749136894296 | -122.40008784930299 | (37.7827491368943, -122.400087849303) | |
| 16984 | 16984 | 10523 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5997295.7816 | 2108435.9791 | 37.769207770213704 | -122.452685140494 | (37.7692077702137, -122.452685140494) | |||
| 17707 | 17707 | 10404 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1372 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5999585.1964 | 2108804.377 | 37.7703502135529 | -122.44479268919599 | (37.7703502135529, -122.444792689196) | |||
| 18100 | 18100 | 26318 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2031 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999629.75367 | 2092055.7224299998 | 37.7243649931268 | -122.443435318496 | (37.7243649931268, -122.443435318496) | |||
| 18285 | 18285 | 4239 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4022 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003730.38902 | 2100426.5981900003 | 37.747582514323895 | -122.429856804747 | (37.7475825143239, -122.429856804747) | |||
| 18401 | 18401 | 102831 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | |||
| 18616 | 18616 | 105248 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1301 COLE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x5 | 5998246.0 | 2105821.0 | 37.7620821004846 | -122.44920998148999 | (37.7620821004846, -122.44920998149) | |||
| 18917 | 18917 | 40148 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 580X Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642.0 | 2110547.0 | 37.7754223144781 | -122.42742536240299 | (37.7754223144781, -122.427425362403) | |
| 19376 | 19376 | 10521 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5997344.2343 | 2108442.9441 | 37.769229670497 | -122.452518048778 | (37.769229670497, -122.452518048778) | |||
| 19745 | 19745 | 105202 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 708 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x6 | 5984164.05462 | 2110996.44068 | 37.7754768768809 | -122.49829551344999 | (37.7754768768809, -122.49829551345) | |||
| 20052 | 20052 | 24345 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 95 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6006134.19272 | 2108466.72229 | 37.7697946537198 | -122.42211568701201 | (37.7697946537198, -122.422115687012) | |||
| 20199 | 20199 | 4163 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3755 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1989 12:00:00 AM | 12 | 3X3 | 6005492.3082 | 2100481.8837200003 | 37.747833935087705 | -122.423768117516 | (37.7478339350877, -122.423768117516) | ||
| 20765 | 20765 | 10517 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1827 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1996 12:00:00 AM | 20 | 3X3 | 5997386.3275 | 2108448.0922 | 37.7692462174685 | -122.452372822905 | (37.7692462174685, -122.452372822905) | ||
| 21727 | 21727 | 4159 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3736-3738 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1989 12:00:00 AM | 23 | 3X3 | 6005622.07663 | 2100534.0724299997 | 37.7479845580381 | -122.4233230934 | (37.7479845580381, -122.4233230934) | ||
| 22874 | 22874 | 179489 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 36 Goettingen St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6009813.802999999 | 2094277.0712700002 | 37.7310398674871 | -122.40838693792801 | (37.7310398674871, -122.408386937928) | |||
| 23500 | 23500 | 200674 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6015639.7987 | 2095348.4618 | 37.7343062239298 | -122.38832004816099 | (37.7343062239298, -122.388320048161) | |||
| 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) | |||
| 23959 | 23959 | 123754 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5995442.56449 | 2110764.4731099997 | 37.7754948416879 | -122.45926391827801 | (37.7754948416879, -122.459263918278) | |||
| 24001 | 24001 | 239679 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3426 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6005478.10496 | 2103741.19129 | 37.7567824376811 | -122.42404897940399 | (37.7567824376811, -122.424048979404) | |||
| 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) | |||
| 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) | |||
| 24460 | 24460 | 239706 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4922 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5997784.7842 | 2105653.4799099998 | 37.7615957414698 | -122.450793062454 | (37.7615957414698, -122.450793062454) | |||
| 24499 | 24499 | 114998 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 460 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009108.5473 | 2121165.2365 | 37.8048290202645 | -122.412725294876 | (37.8048290202645, -122.412725294876) | |||
| 24938 | 24938 | 136425 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013547.46214 | 2118092.2461 | 37.7966394636056 | -122.397148242524 | (37.7966394636056, -122.397148242524) | |||
| 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) | |||
| 25129 | 25129 | 138489 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002035.9915 | 2114842.1015 | 37.787067841534096 | -122.436747670692 | (37.7870678415341, -122.436747670692) | |||
| 25184 | 25184 | 239681 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3616 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6005642.96525 | 2101995.98753 | 37.751999819647295 | -122.423354771113 | (37.7519998196473, -122.423354771113) | |||
| 25405 | 25405 | 33648 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 530 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37739 | 6004854.057893401 | 2110753.28886702 | 37.7760007246145 | -122.426706497307 | (37.7760007246145, -122.426706497307) | |||
| 25617 | 25617 | 214202 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 80 El Verano Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5994588.98117 | 2094805.70057 | 37.7316270105613 | -122.461059668986 | (37.7316270105613, -122.461059668986) | |||
| 25682 | 25682 | 183905 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5989441.4873 | 2100495.8044 | 37.746953003916296 | -122.479271477973 | (37.7469530039163, -122.479271477973) | |||
| 25693 | 25693 | 101868 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2014 12:00:00 AM | 6 | 3x3 | Permit Number 771222 | 6012702.0 | 2113175.0 | 37.7830907593936 | -122.39972830907101 | (37.7830907593936, -122.399728309071) | |
| 25697 | 25697 | 136427 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6013551.1495199995 | 2118058.04 | 37.796545747032 | -122.397133083548 | (37.796545747032, -122.397133083548) | |||
| 26091 | 26091 | 138387 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1905 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6001950.5989 | 2115065.5557 | 37.787676536151295 | -122.43705911384 | (37.7876765361513, -122.43705911384) | |||
| 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) | |||
| 26211 | 26211 | 123755 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5995425.063709999 | 2110766.6471700002 | 37.7754998049095 | -122.459324614731 | (37.7754998049095, -122.459324614731) | |||
| 26497 | 26497 | 118237 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 680 38th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 5984156.56832 | 2111248.83134 | 37.7761694298689 | -122.498340055521 | (37.7761694298689, -122.498340055521) | |||
| 26696 | 26696 | 69405 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 781 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 11 | Permit Number 33509 | 6002439.0824 | 2087100.62464 | 37.7109192031396 | -122.43336995327 | (37.7109192031396, -122.43336995327) | |
| 26708 | 26708 | 239688 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 214 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005063.052759999 | 2109561.17817 | 37.7727392922036 | -122.425898651924 | (37.7727392922036, -122.425898651924) | |||
| 26858 | 26858 | 138325 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2492 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001603.2252 | 2114641.6748 | 37.7864929170324 | -122.438230579455 | (37.7864929170324, -122.438230579455) | |||
| 27404 | 27404 | 63509 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1805 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1998 12:00:00 AM | 8 | 3x3 | Permit Number 24115 | 6000922.9965 | 2111712.7723 | 37.7784121888349 | -122.440373864948 | (37.7784121888349, -122.440373864948) |
| 27661 | 27661 | 179429 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Brookdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6006237.48001 | 2087456.42565 | 37.712110920858706 | -122.420267010915 | (37.7121109208587, -122.420267010915) | |||
| 28186 | 28186 | 118223 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5984452.77979 | 2111524.2434799997 | 37.776942997233604 | -122.49733573185 | (37.7769429972336, -122.49733573185) | |||
| 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) | |||
| 28864 | 28864 | 200676 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015656.8366 | 2095323.7293 | 37.7342392575487 | -122.388259416585 | (37.7342392575487, -122.388259416585) | |||
| 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) | |||
| 29182 | 29182 | 136399 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1667 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005091.5128 | 2118475.84475 | 37.7972183598879 | -122.42643506691999 | (37.7972183598879, -122.42643506692) | |||
| 30125 | 30125 | 136417 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6013524.76569 | 2118243.85815 | 37.797054490825 | -122.397237414787 | (37.797054490825, -122.397237414787) | |||
| 30260 | 30260 | 66355 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 842 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1992 12:00:00 AM | 15 | Permit Number 30970 | 6006677.47104 | 2121530.77464 | 37.8056959468756 | -122.421164278004 | (37.8056959468756, -122.421164278004) | ||
| 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) | |||
| 30303 | 30303 | 179468 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 291 France Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001647.16213 | 2090105.1251700001 | 37.719123934899294 | -122.436321896962 | (37.7191239348993, -122.436321896962) | |||
| 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) | |||
| 30401 | 30401 | 197533 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6013601.75095 | 2103896.53741 | 37.757664290394295 | -122.395965104316 | (37.7576642903943, -122.395965104316) | ||||
| 30517 | 30517 | 138404 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002025.4909 | 2114921.9063 | 37.7872863683147 | -122.43678971535299 | (37.7872863683147, -122.436789715353) | |||
| 30533 | 30533 | 33010 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3622 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42195 | 6005636.60974519 | 2102002.04320044 | 37.7520160884207 | -122.423377179853 | (37.7520160884207, -122.423377179853) |
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");