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) | ||||
| 352 | 352 | 14742 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004772.182 | 2111961.3352 | 37.779313094037704 | -122.427075791541 | (37.7793130940377, -122.427075791541) | |||
| 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) | ||||
| 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) | |||
| 1570 | 1570 | 5344 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 180 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6004766.753190001 | 2107347.6889299997 | 37.7666448358082 | -122.42676592392999 | (37.7666448358082, -122.42676592393) | |||
| 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) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 4909 | 4909 | 5262 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1234 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001365.3782 | 2112681.2883 | 37.7810966664945 | -122.438912929299 | (37.7810966664945, -122.438912929299) | |||
| 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) | ||||
| 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) | ||
| 5323 | 5323 | 5263 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1234 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001361.3171 | 2112714.792 | 37.781188428076796 | -122.438929380366 | (37.7811884280768, -122.438929380366) | |||
| 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) | |||
| 7072 | 7072 | 5264 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1234 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001356.2408 | 2112747.2805 | 37.7812773444135 | -122.438949270784 | (37.7812773444135, -122.438949270784) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 14458 | 14458 | 94035 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 32 | 5x5 | 6015684.8669 | 2095240.1882 | 37.7340114236329 | -122.388156677838 | (37.7340114236329, -122.388156677838) | ||
| 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) | ||
| 15206 | 15206 | 26133 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1504 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 5x5 | 6015522.1816 | 2095153.8991 | 37.7337654760523 | -122.388713114387 | (37.7337654760523, -122.388713114387) | |||
| 15674 | 15674 | 94034 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6015674.4242 | 2095246.7836 | 37.7340289546749 | -122.388193241926 | (37.7340289546749, -122.388193241926) | ||
| 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) | |||
| 16050 | 16050 | 22178 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3950X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015635.4577 | 2097953.7776 | 37.7414596503706 | -122.38851684958999 | (37.7414596503706, -122.38851684959) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 20111 | 20111 | 5352 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6004792.2174 | 2107120.31816 | 37.7660219698556 | -122.426661654709 | (37.7660219698556, -122.426661654709) | |||
| 20272 | 20272 | 5372 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 266 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6004807.33386 | 2106790.92069 | 37.7651183778313 | -122.426585912012 | (37.7651183778313, -122.426585912012) | |||
| 20711 | 20711 | 10425 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1419 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 5999323.0709 | 2108716.5502 | 37.7700941010229 | -122.445693060933 | (37.7700941010229, -122.445693060933) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 28030 | 28030 | 197577 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 299x Cashmere St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6016820.77887 | 2095888.49241 | 37.735854408739 | -122.38427457691002 | (37.735854408739, -122.38427457691) | ||||
| 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) |
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");