Street_Tree_List

Data source: data.sfgov.org

467 rows where qSpecies = 68

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
256 221894 Undocumented 2 Geijera parviflora :: Australian Willow 68 3164 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6008618.9330400005 2101573.97925 37.75100859049479 -122.41303356944799 (37.7510085904948, -122.413033569448)
260 221893 Undocumented 2 Geijera parviflora :: Australian Willow 68 3164 25th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6008601.79804 2101572.78068 37.751004337584796 -122.41309273944599 (37.7510043375848, -122.413092739446)
509 38234 Permitted Site 1 Geijera parviflora :: Australian Willow 68 0 16th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1998 12:00:00 AM     Permit Number 40352          
1016 225959 Permitted Site 1 Geijera parviflora :: Australian Willow 68 20 Newman St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/15/2005 12:00:00 AM 12 Width 3ft Permit Number 48238 6006979.14621 2096796.63822 37.7377988968125 -122.41836543223101 (37.7377988968125, -122.418365432231)
1698 225957 Undocumented 2 Geijera parviflora :: Australian Willow 68 38 Newman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007027.0 2096768.0 37.7377229562927 -122.418197948284 (37.7377229562927, -122.418197948284)
2992 43017 Permitted Site 1 Geijera parviflora :: Australian Willow 68   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2000 12:00:00 AM     Permit Number 42880          
3164 10171 Permitted Site 1 Geijera parviflora :: Australian Willow 68 1032 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/23/2017 12:00:00 AM 3 2x3 Permit Number 779560 6005695.79144 2102951.17521 37.7546255252659 -122.423239982539 (37.7546255252659, -122.423239982539)
3545 43015 Permitted Site 1 Geijera parviflora :: Australian Willow 68   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2000 12:00:00 AM     Permit Number 42880          
3668 43018 Permitted Site 1 Geijera parviflora :: Australian Willow 68   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2000 12:00:00 AM     Permit Number 42880          
4219 244047 Undocumented 2 Geijera parviflora :: Australian Willow 68 400 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5997955.5586 2109119.1735 37.771121429752895 -122.450452276113 (37.7711214297529, -122.450452276113)
4435 34068 Permitted Site 1 Geijera parviflora :: Australian Willow 68 955 Kennedy Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37965          
5326 38231 Permitted Site 1 Geijera parviflora :: Australian Willow 68 0 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1998 12:00:00 AM     Permit Number 40352          
5586 43016 Permitted Site 1 Geijera parviflora :: Australian Willow 68   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2000 12:00:00 AM     Permit Number 42880          
5795 10694 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 1250 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001838.4236 2110502.6134 37.7751414763631 -122.43712039839399 (37.7751414763631, -122.437120398394)
6485 29768 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 640 Francisco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/01/1991 12:00:00 AM 6 6x6   6008286.5569 2121053.0319999997 37.8044747652934 -122.415561939011 (37.8044747652934, -122.415561939011)
6607 34069 Permitted Site 1 Geijera parviflora :: Australian Willow 68 955 Kennedy Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37965          
6875 26546 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 570 Francisco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/19/1997 12:00:00 AM 6 4X4   6008578.3106 2121094.8201 37.804605899968 -122.41455525494301 (37.804605899968, -122.414555254943)
7043 34072 Permitted Site 1 Geijera parviflora :: Australian Willow 68 955 Kennedy Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37965          
7187 22760 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 1620 Turk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 4X4   6002287.3238 2112301.156 37.7801053300032 -122.43569625863701 (37.7801053300032, -122.435696258637)
7921 29760 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 500 Francisco St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   6008840.5335 2121127.883 37.804711410621294 -122.41365014448401 (37.8047114106213, -122.413650144484)
7991 38232 Permitted Site 1 Geijera parviflora :: Australian Willow 68 0 16th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1998 12:00:00 AM     Permit Number 40352          
9590 34067 Permitted Site 1 Geijera parviflora :: Australian Willow 68 955 Kennedy Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37965          
9818 46930 Permitted Site 1 Geijera parviflora :: Australian Willow 68 1 Pacheco St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.743524195830396 -122.459369067857 (37.7435241958304, -122.459369067857)
9820 46927 Permitted Site 1 Geijera parviflora :: Australian Willow 68 1 Pacheco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.743524195830396 -122.459369067857 (37.7435241958304, -122.459369067857)
9821 46929 Permitted Site 1 Geijera parviflora :: Australian Willow 68 1 Pacheco St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.743524195830396 -122.459369067857 (37.7435241958304, -122.459369067857)
9825 46928 Permitted Site 1 Geijera parviflora :: Australian Willow 68 1 Pacheco St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.743524195830396 -122.459369067857 (37.7435241958304, -122.459369067857)
9953 107188 Permitted Site 1 Geijera parviflora :: Australian Willow 68 1500 PAGE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/15/2014 12:00:00 AM 3 3x3 Permit Number 773122 5999274.2 2109122.8 37.771206769657205 -122.445891326497 (37.7712067696572, -122.445891326497)
10500 34071 Permitted Site 1 Geijera parviflora :: Australian Willow 68 955 Kennedy Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37965          
10511 38233 Permitted Site 1 Geijera parviflora :: Australian Willow 68 0 16th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1998 12:00:00 AM     Permit Number 40352          
10930 109686 Permitted Site 1 Geijera parviflora :: Australian Willow 68 190 Onondaga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/27/2015 12:00:00 AM 3 3x3 Permit Number 772797 6000260.82873 2091434.8524 37.7226961949641 -122.441209260793 (37.7226961949641, -122.441209260793)
11919 108571 Permitted Site 1 Geijera parviflora :: Australian Willow 68 223 Sweeny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 772573 6009406.56 2094751.33642 37.732319284403204 -122.409828317318 (37.7323192844032, -122.409828317318)
12244 45154 Permitted Site 1 Geijera parviflora :: Australian Willow 68 1683 Precita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/22/2001 12:00:00 AM     Permit Number 44007          
12798 34070 Permitted Site 1 Geijera parviflora :: Australian Willow 68 955 Kennedy Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/1997 12:00:00 AM     Permit Number 37965          
13344 187697 Permitted Site 1 Geijera parviflora :: Australian Willow 68 1256 Treat Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1         6008667.10840058 2101226.16540452 37.7500562758063 -122.41284238591601 (37.7500562758063, -122.412842385916)
13345 69222 Permitted Site 1 Geijera parviflora :: Australian Willow 68 1250 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/15/2001 12:00:00 AM   3x3 Permit Number 33274 6008665.27491562 2101259.70225891 37.750148257591896 -122.412851097008 (37.7501482575919, -122.412851097008)
13521 49830 Permitted Site 1 Geijera parviflora :: Australian Willow 68 225 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/11/2003 12:00:00 AM 5 3x3 Permit Number 46613 6013486.20588 2106002.24827 37.7634396826096 -122.396512309398 (37.7634396826096, -122.396512309398)
13795 78433 Undocumented 2 Geijera parviflora :: Australian Willow 68 870 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/09/2016 12:00:00 AM 3     6011558.925919999 2104265.3143 37.7585630053957 -122.403056007737 (37.7585630053957, -122.403056007737)
14322 115881 Permitted Site 1 Geijera parviflora :: Australian Willow 68 1663 La Salle Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/01/2016 12:00:00 AM 3   Permit Number 773046 6015043.9945 2096491.0960099997 37.737410632491 -122.39045976502199 (37.737410632491, -122.390459765022)
17382 10079 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 614 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3X3   6005561.0033 2105378.47551 37.7612827162343 -122.423878706238 (37.7612827162343, -122.423878706238)
17464 10037 Permitted Site 1 Geijera parviflora :: Australian Willow 68 351 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x2   6005536.7714599995 2106975.8845599997 37.765667455319 -122.424076117338 (37.765667455319, -122.424076117338)
17889 10131 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 899 Guerrero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/04/1992 12:00:00 AM 6 3X3   6005716.194490001 2103799.35315 37.7569555760466 -122.42322971137699 (37.7569555760466, -122.423229711377)
18217 10091 Permitted Site 1 Geijera parviflora :: Australian Willow 68 708 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/07/1992 12:00:00 AM 50 3X3   6005589.43333 2104821.82229 37.759755882347704 -122.42374079792299 (37.7597558823477, -122.423740797923)
18333 27660 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 1360 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3x3   6005798.597080001 2101052.0301599996 37.7494167122272 -122.42274949589199 (37.7494167122272, -122.422749495892)
18959 10130 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 899 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/04/1992 12:00:00 AM 6 3X3   6005717.32362 2103778.4665900003 37.7568982901448 -122.423224321766 (37.7568982901448, -122.423224321766)
19073 10152 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 981 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6005742.33218 2103287.1896599997 37.7555507693625 -122.42310291418801 (37.7555507693625, -122.423102914188)
19086 10155 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 988 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2x2   6005676.86794 2103220.79798 37.7553647787894 -122.423324590769 (37.7553647787894, -122.423324590769)
19478 10071 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 563 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2x3   6005607.25335 2105721.20389 37.7622263784702 -122.423743116346 (37.7622263784702, -122.423743116346)
19491 10032 Permitted Site 1 Geijera parviflora :: Australian Willow 68 315 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X2   6005527.20527 2107119.43239 37.7660610633959 -122.424119414293 (37.7660610633959, -122.424119414293)
19662 10000 Permitted Site 1 Geijera parviflora :: Australian Willow 68 136 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     90 2X2   6005403.547780001 2108183.22689 37.7689750062251 -122.424622801709 (37.7689750062251, -122.424622801709)
19692 65477 Permitted Site 1 Geijera parviflora :: Australian Willow 68 400 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/12/1989 12:00:00 AM     Permit Number 28358 5994782.15079154 2091255.17859292 37.7218892499679 -122.46013471597601 (37.7218892499679, -122.460134715976)
19723 26529 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 2747 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 3x3   6008970.13177 2102467.22828 37.75348096079001 -122.41188219893101 (37.75348096079, -122.411882198931)
20077 115127 Permitted Site 1 Geijera parviflora :: Australian Willow 68 499X MAIN ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
20120 10020 Permitted Site 1 Geijera parviflora :: Australian Willow 68 250 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     32 2x2   6005442.42406 2107520.98643 37.767158847823 -122.42444122050101 (37.767158847823, -122.424441220501)
20175 10089 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 700 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X3   6005586.51976 2104851.24563 37.7598365074586 -122.423752966647 (37.7598365074586, -122.423752966647)
20284 10112 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 821 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   6005694.086069999 2104163.28117 37.7579535897166 -122.423332040744 (37.7579535897166, -122.423332040744)
20351 10165 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 1019 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x4   6005763.39401 2102897.6669099997 37.7544824188306 -122.423002391551 (37.7544824188306, -122.423002391551)
20893 10068 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 549 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2x3   6005603.73706 2105778.3330099997 37.762383043055 -122.423759340124 (37.762383043055, -122.423759340124)
21251 10061 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 490 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 2X2   6005517.65207 2106131.14555 37.7633469229371 -122.424082167969 (37.7633469229371, -122.424082167969)
21466 10087 Permitted Site 1 Geijera parviflora :: Australian Willow 68 673 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 2X2   6005642.33302 2105078.4944700003 37.7604636299235 -122.423576092482 (37.7604636299235, -122.423576092482)
21505 10026 Permitted Site 1 Geijera parviflora :: Australian Willow 68 290 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 2x3   6005455.03663 2107324.1386599997 37.7666190630424 -122.424383592842 (37.7666190630424, -122.424383592842)
21573 10054 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 426 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X2   6005501.955709999 2106458.62904 37.764245228771 -122.42415974799201 (37.764245228771, -122.424159747992)
21621 10076 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 600 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     70 2x2   6005555.84644 2105437.30746 37.7614439637781 -122.423900725242 (37.7614439637781, -122.423900725242)
21713 10001 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 145 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X2   6005474.27283 2108090.23028 37.768723653813204 -122.42437155270201 (37.7687236538132, -122.424371552702)
21782 10227 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 1404 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x3   6005821.31625 2100751.5734599996 37.7485930087737 -122.422649583919 (37.7485930087737, -122.422649583919)
21827 26513 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 2864 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6008948.96043 2101783.0813599997 37.7516012590109 -122.41190707235701 (37.7516012590109, -122.411907072357)
22152 10132 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 899 Guerrero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/04/1992 12:00:00 AM 6 3X3   6005714.0796 2103814.39751 37.756996764997 -122.42323809485599 (37.756996764997, -122.423238094856)
23948 32109 Permitted Site 1 Geijera parviflora :: Australian Willow 68 431 Noe St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 11   Permit Number 35479 6002988.87793 2105732.43045 37.7621090484283 -122.43279988020299 (37.7621090484283, -122.432799880203)
24547 83274 Undocumented 2 Geijera parviflora :: Australian Willow 68 1639X Taylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/21/2006 12:00:00 AM 5     6008741.72565 2118600.6509700003 37.7977667125146 -122.41381320433001 (37.7977667125146, -122.41381320433)
24867 128872 Undocumented 2 Geijera parviflora :: Australian Willow 68 1270 Clay St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   6008617.8933 2116985.80522 37.7933257892186 -122.414127394165 (37.7933257892186, -122.414127394165)
24972 49768 Permitted Site 1 Geijera parviflora :: Australian Willow 68 333 Schwerin St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM 7   Permit Number 46559 6008671.05987 2086426.1944 37.7094189460104 -122.411783070238 (37.7094189460104, -122.411783070238)
25421 192408 Undocumented 2 Geijera parviflora :: Australian Willow 68 799 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6011594.92882 2104699.3900200003 37.759756891395796 -122.40296202319999 (37.7597568913958, -122.4029620232)
25801 225955 Undocumented 2 Geijera parviflora :: Australian Willow 68 245 Roanoke St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6003637.7380800005 2095933.74555 37.735240927214704 -122.42985676608299 (37.7352409272147, -122.429856766083)
26692 219004 Undocumented 2 Geijera parviflora :: Australian Willow 68 1655 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 3ft   5993378.4627 2104217.9895 37.7574010390349 -122.46592829725 (37.7574010390349, -122.46592829725)
26806 34502 Permitted Site 1 Geijera parviflora :: Australian Willow 68 1415 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/17/1997 12:00:00 AM 9   Permit Number 38224 6013698.3172 2104744.62684 37.759998331483494 -122.39569055749399 (37.7599983314835, -122.395690557494)
27086 225956 Undocumented 2 Geijera parviflora :: Australian Willow 68 126 Fairmount St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004690.92985 2097272.0847099996 37.738975290087104 -122.426310750952 (37.7389752900871, -122.426310750952)
27127 225952 Undocumented 2 Geijera parviflora :: Australian Willow 68 800 Alvarado St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001178.257669999 2102625.59939 37.753475588250396 -122.438839459988 (37.7534755882504, -122.438839459988)
27884 225899 Undocumented 2 Geijera parviflora :: Australian Willow 68 1398 Bryant St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6009375.43724 2107898.5512099997 37.7684168680618 -122.41086412858 (37.7684168680618, -122.41086412858)
28224 48556 Permitted Site 1 Geijera parviflora :: Australian Willow 68 615 Central Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/23/2002 12:00:00 AM 3   Permit Number 45872 5999645.29400405 2110579.50430317 37.7752276921804 -122.444712423834 (37.7752276921804, -122.444712423834)
28376 66066 Permitted Site 1 Geijera parviflora :: Australian Willow 68 1431 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/06/1990 12:00:00 AM 11   Permit Number 29106 6013625.10181 2104739.90322 37.7599812884231 -122.395943445033 (37.7599812884231, -122.395943445033)
28449 113387 Permitted Site 1 Geijera parviflora :: Australian Willow 68 185 CASTENADA AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3     5994493.0 2100782.0 37.7480309194949 -122.461824674651 (37.7480309194949, -122.461824674651)
28869 83275 Undocumented 2 Geijera parviflora :: Australian Willow 68 1639X Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/21/2006 12:00:00 AM 5     6008740.14676 2118614.90766 37.797805769189296 -122.413819676732 (37.7978057691893, -122.413819676732)
29018 247759 Undocumented 2 Geijera parviflora :: Australian Willow 68 75 Alpine Ter 1 : 4 Tree 1 Private 1     10 Width 3ft   6001668.74952 2108376.80716 37.7692948959648 -122.437555068929 (37.7692948959648, -122.437555068929)
29070 225918 Undocumented 2 Geijera parviflora :: Australian Willow 68 1619 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6009320.793740001 2100001.018 37.746728962386705 -122.41049539576001 (37.7467289623867, -122.41049539576)
29808 225970 Undocumented 2 Geijera parviflora :: Australian Willow 68 2846 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6009214.745180001 2103362.9385 37.7559541000213 -122.411099534231 (37.7559541000213, -122.411099534231)
29911 245456 Undocumented 2 Geijera parviflora :: Australian Willow 68 2800 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6007901.4813 2106811.8898 37.765350391343496 -122.415885464882 (37.7653503913435, -122.415885464882)
30003 219010 Undocumented 2 Geijera parviflora :: Australian Willow 68 157 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5995318.0566300005 2090927.8253099998 37.7210212256375 -122.458258556898 (37.7210212256375, -122.458258556898)
31008 49769 Permitted Site 1 Geijera parviflora :: Australian Willow 68 333 Schwerin St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM 4   Permit Number 46559 6008658.89925 2086391.1157900002 37.70932194511621 -122.411822622426 (37.7093219451162, -122.411822622426)
31018 244415 Undocumented 2 Geijera parviflora :: Australian Willow 68 630 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6003443.0612 2109684.1199 37.7729851758016 -122.43151115772899 (37.7729851758016, -122.431511157729)
31199 176506 Undocumented 2 Geijera parviflora :: Australian Willow 68 178 Brookdale Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6005608.52394 2087094.5334400001 37.7110817807597 -122.42241517113001 (37.7110817807597, -122.42241517113)
31526 95134 Permitted Site 1 Geijera parviflora :: Australian Willow 68 450@ Wayland Somerset St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6010117.366119999 2092259.39432 37.7255167458877 -122.40719528853501 (37.7255167458877, -122.407195288535)
31692 219005 Undocumented 2 Geijera parviflora :: Australian Willow 68 1838 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5992852.04405 2102933.06242 37.7538425808737 -122.467655401194 (37.7538425808737, -122.467655401194)
32129 225911 Undocumented 2 Geijera parviflora :: Australian Willow 68 886 Guerrero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6005643.7507 2103817.72642 37.75700193611971 -122.42348155572999 (37.7570019361197, -122.42348155573)
33224 32625 Permitted Site 1 Geijera parviflora :: Australian Willow 68 75 Boardman Pl 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM 15   Permit Number 37080 6011878.08124 2109949.48586 37.774188278987204 -122.402351882652 (37.7741882789872, -122.402351882652)
33404 225968 Undocumented 2 Geijera parviflora :: Australian Willow 68 3599 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   6005865.3441 2101966.56287 37.751931574603894 -122.422583660903 (37.7519315746039, -122.422583660903)
33600 49767 Permitted Site 1 Geijera parviflora :: Australian Willow 68 333 Schwerin St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM 7   Permit Number 46559 6008676.28834 2086439.38255 37.7094554512839 -122.41176593097 (37.7094554512839, -122.41176593097)
35324 245162 Undocumented 2 Geijera parviflora :: Australian Willow 68 1308 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6000247.8581 2109240.6853 37.7715860006418 -122.44253187989901 (37.7715860006418, -122.442531879899)
35468 49765 Permitted Site 1 Geijera parviflora :: Australian Willow 68 333 Schwerin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM 5   Permit Number 46559 6008653.27394 2086377.17589 37.7092833534188 -122.411841080097 (37.7092833534188, -122.411841080097)
35780 128877 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 1237x Robert C Levy Tunl 6 Median : Yard 3 Tree 1 DPW 2     3     6007635.0884300005 2118146.70213 37.796458073045 -122.417610293998 (37.796458073045, -122.417610293998)
35910 219003 Undocumented 2 Geijera parviflora :: Australian Willow 68 1461 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5993948.08517 2105555.3752599997 37.7611059976579 -122.464055414128 (37.7611059976579, -122.464055414128)
36158 65448 Permitted Site 1 Geijera parviflora :: Australian Willow 68 72 05th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/08/1989 12:00:00 AM 9   Permit Number 28322 5994279.76671 2115099.7417900003 37.7873314010144 -122.46360098807399 (37.7873314010144, -122.463600988074)

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 94.527ms · Data source: data.sfgov.org