Street_Tree_List

Data source: data.sfgov.org

1,073 rows where qSpecies = 25

View and edit SQL

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)
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)
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 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 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 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 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)
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 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 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 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)
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 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 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 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 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 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 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 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)
3190 9537 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 1100X Golden Gate Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   05/14/1992 12:00:00 AM 3 3X3   6004100.4915 2112210.9093 37.779960357201205 -122.429417251502 (37.7799603572012, -122.429417251502)
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 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 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 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 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 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 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 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)
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 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 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 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)
7831 9536 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 1100X Golden Gate Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   10/14/1994 12:00:00 AM 3 3X3   6004118.455 2112215.6365 37.779974353933 -122.42935544491999 (37.779974353933, -122.42935544492)
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 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 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 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 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 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 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 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 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 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 19745 DPW Maintained 3 Schinus terebinthifolius :: Brazilian Pepper 25 100 STAIRWAY15 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3            
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 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)
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)
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)
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)
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 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 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 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 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 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 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 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 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 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)
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 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 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 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 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 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 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 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 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 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 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 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 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)
19194 5349 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 200X Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/22/2010 12:00:00 AM 12 3x3 Permit Number 53640 6004790.705569999 2107143.57223 37.7660857344886 -122.426668539926 (37.7660857344886, -122.426668539926)
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 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 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 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 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)
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)
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)
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)
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)
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)
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 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 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 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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 329.531ms · Data source: data.sfgov.org