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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 32417 | 32417 | 105247 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1301X COLE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x 5 | 5998246.0 | 2105821.0 | 37.7620821004846 | -122.44920998148999 | (37.7620821004846, -122.44920998149) | ||||
| 82375 | 82375 | 88393 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 124 23rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51371 | 5988714.5 | 2114502.9 | 37.785370404226796 | -122.48281165726401 | (37.7853704042268, -122.482811657264) | |||
| 116776 | 116776 | 104817 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3170 BALBOA ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5985841.0 | 2111127.0 | 37.7759335444794 | -122.49250425909901 | (37.7759335444794, -122.492504259099) | ||||
| 119653 | 119653 | 86882 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49807 | 6011833.0 | 2113224.2 | 37.7831773700909 | -122.40273817385099 | (37.7831773700909, -122.402738173851) | |||
| 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) | ||||
| 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) | |
| 950 | 950 | 27411 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2198 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5996975.1116 | 2109480.4382 | 37.7720572057802 | -122.453869751853 | (37.7720572057802, -122.453869751853) | ||
| 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) | |||
| 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) | ||
| 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) | |
| 2263 | 2263 | 22364 | Landmark tree 9 | Schinus terebinthifolius :: Brazilian Pepper 25 | 5490X 03rd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | |||
| 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) | ||
| 2300 | 2300 | 6356 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1234X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001371.4698 | 2112650.1535 | 37.7810115248297 | -122.438889623593 | (37.7810115248297, -122.438889623593) | |||
| 2506 | 2506 | 10385 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/2017 12:00:00 AM | 24 | 3X3 | 5999759.2979999995 | 2108827.6222 | 37.7704239730353 | -122.444192144461 | (37.7704239730353, -122.444192144461) | ||
| 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) | |||
| 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) | |
| 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) | |||
| 7331 | 7331 | 18088 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3000 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999530.9574 | 2114697.1427 | 37.7865271393644 | -122.445404074823 | (37.7865271393644, -122.445404074823) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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 | ||||||||
| 11462 | 11462 | 26316 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2049 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999538.37389 | 2091931.2083 | 37.7240178943838 | -122.443742263404 | (37.7240178943838, -122.443742263404) | |||
| 12920 | 12920 | 26322 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1975 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999887.727969999 | 2092429.05718 | 37.7254047928689 | -122.44257033256201 | (37.7254047928689, -122.442570332562) | |||
| 14374 | 14374 | 26131 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | |||
| 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) | ||
| 15868 | 15868 | 16559 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 702X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015638.3263 | 2097400.20162 | 37.7399398030878 | -122.388468300865 | (37.7399398030878, -122.388468300865) | |||
| 16514 | 16514 | 22196 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4049 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015606.879 | 2097560.5249 | 37.7403782752921 | -122.38858822178001 | (37.7403782752921, -122.38858822178) | |||
| 17081 | 17081 | 4153 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3721-3721 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/31/1989 12:00:00 AM | 6 | 3X3 | 6005701.8016 | 2100493.99134 | 37.7478790037267 | -122.423044558975 | (37.7478790037267, -122.423044558975) | ||
| 17239 | 17239 | 5333 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 135 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6004851.68413 | 2107592.33342 | 37.767321372413704 | -122.42648958384399 | (37.7673213724137, -122.426489583844) | |||
| 17571 | 17571 | 5359 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 233 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6004883.71893 | 2107010.19311 | 37.765724765498206 | -122.426337327709 | (37.7657247654982, -122.426337327709) | |||
| 17589 | 17589 | 10438 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1474 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5999064.8261 | 2108729.1491 | 37.770113946782 | -122.446587229644 | (37.770113946782, -122.446587229644) | |||
| 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) | |||
| 18205 | 18205 | 24291 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006664.25165 | 2098042.76581 | 37.7412027542911 | -122.41954256203998 | (37.7412027542911, -122.41954256204) | |||
| 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) | |||
| 18248 | 18248 | 5692 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1546 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6005220.41395 | 2099376.74782 | 37.7447841325786 | -122.42462971298401 | (37.7447841325786, -122.424629712984) | |||
| 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) | |||
| 19216 | 19216 | 5559 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 984 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005041.33516 | 2102650.51852 | 37.753763035857794 | -122.425481873703 | (37.7537630358578, -122.425481873703) | |||
| 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) | |||
| 19927 | 19927 | 10223 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1377X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005871.04446 | 2100967.56548 | 37.7491888788632 | -122.42249296966999 | (37.7491888788632, -122.42249296967) | |||
| 20086 | 20086 | 4168 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3782-3788 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/1989 12:00:00 AM | 18 | 3X3 | 6005368.018130001 | 2100519.1181900003 | 37.747929155315596 | -122.42420055471901 | (37.7479291553156, -122.424200554719) | ||
| 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) | ||
| 20406 | 20406 | 4151 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3713-3717 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/31/1989 12:00:00 AM | 6 | 3X3 | 6005727.50138 | 2100496.8829200002 | 37.7478883935431 | -122.422955895692 | (37.7478883935431, -122.422955895692) | ||
| 20738 | 20738 | 22897 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 201 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006097.55508 | 2108434.56296 | 37.7697042853598 | -122.422240130676 | (37.7697042853598, -122.422240130676) | |||
| 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) | ||
| 21799 | 21799 | 24344 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 95 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006121.89128 | 2108467.81183 | 37.7697969514995 | -122.42215831485201 | (37.7697969514995, -122.422158314852) | |||
| 21881 | 21881 | 5738 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1740 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4X4 | 6005286.8727 | 2098237.12847 | 37.741658750152794 | -122.42431887223499 | (37.7416587501528, -122.424318872235) | |||
| 22077 | 22077 | 5514 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 827 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X5 | 6005075.88619 | 2103522.4766599997 | 37.7561591814037 | -122.425424436705 | (37.7561591814037, -122.425424436705) | |||
| 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) | |||
| 23185 | 23185 | 10522 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5997273.9779 | 2108433.2536 | 37.7691990373323 | -122.452760361188 | (37.7691990373323, -122.452760361188) | |||
| 23218 | 23218 | 10460 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1568 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/2008 12:00:00 AM | 12 | 3x3 | 5998627.6282 | 2108670.1782 | 37.7699270451307 | -122.448095239137 | (37.7699270451307, -122.448095239137) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 30968 | 30968 | 138487 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002041.5919 | 2114791.6986 | 37.786929766345 | -122.436724685254 | (37.786929766345, -122.436724685254) | |||
| 32107 | 32107 | 74167 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1801 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 12 | 6000438.3175 | 2111300.5273 | 37.7772526604879 | -122.44202094864599 | (37.7772526604879, -122.442020948646) | ||
| 32674 | 32674 | 123736 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 398 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5994542.01129 | 2110789.2592 | 37.775511081800396 | -122.462380922286 | (37.7755110818004, -122.462380922286) | |||
| 33092 | 33092 | 142733 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 451 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009242.9671 | 2121140.0929 | 37.8047675258137 | -122.412258341021 | (37.8047675258137, -122.412258341021) | |||
| 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) | |||
| 33555 | 33555 | 214199 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 159 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994376.25623 | 2095510.5029900002 | 37.7335499814343 | -122.46184618277 | (37.7335499814343, -122.46184618277) | |||
| 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) | |||
| 34052 | 34052 | 136411 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 160 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6013483.17698 | 2118325.06374 | 37.797275146684 | -122.397387020609 | (37.797275146684, -122.397387020609) | |||
| 34304 | 34304 | 62258 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | Permit Number 22384 | 6001321.62543581 | 2093848.87962555 | 37.729384933111604 | -122.437715130621 | (37.7293849331116, -122.437715130621) | ||
| 34731 | 34731 | 240532 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2911 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009359.969409999 | 2102744.60217 | 37.7542644303799 | -122.410553636735 | (37.7542644303799, -122.410553636735) | |||
| 36655 | 36655 | 123174 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 735 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5992855.85161 | 2110444.11138 | 37.7744661593712 | -122.468188588983 | (37.7744661593712, -122.468188588983) | |||
| 37203 | 37203 | 179446 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 127 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006032.90525 | 2087456.2020599998 | 37.712098777304 | -122.42097406600901 | (37.712098777304, -122.420974066009) | |||
| 37601 | 37601 | 43760 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 249 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 8 | Permit Number 43395 | 5990536.37641 | 2113724.23454 | 37.783338239757704 | -122.47645167744601 | (37.7833382397577, -122.476451677446) | |
| 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) | |||
| 37833 | 37833 | 71250 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1240 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 11 | 6x3 | 6007647.94637 | 2118195.049 | 37.796591545013705 | -122.417569230932 | (37.7965915450137, -122.417569230932) | |
| 37944 | 37944 | 179455 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1651 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6006947.074519999 | 2087492.6533099997 | 37.7122503535477 | -122.417817006765 | (37.7122503535477, -122.417817006765) | |||
| 38198 | 38198 | 43696 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1539 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 8 | Permit Number 43340 | 5993847.57781 | 2112069.22957 | 37.7789855246228 | -122.464876090912 | (37.7789855246228, -122.464876090912) |
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");