Street_Tree_List

Data source: data.sfgov.org

3,964 rows where qSpecies = 5 sorted by rowid descending

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189113 123119 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 574 11th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 3ft   5992561.79357 2111542.7313099997 37.7774656852602 -122.469285763443 (37.7774656852602, -122.469285763443)
189080 188626 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3601 03rd St 24 : 4 Tree 1 Private 1     15 Width 3ft   6016050.39554 2099032.09801 37.7444434828812 -122.38715732045799 (37.7444434828812, -122.387157320458)
189032 30841 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 2586 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/06/1995 12:00:00 AM 22   Permit Number 34689 6002395.11591 2116122.86039 37.790604880464294 -122.43559684281799 (37.7906048804643, -122.435596842818)
188967 186602 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 73 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984723.2519 2104439.4316 37.7575059562709 -122.495877337913 (37.7575059562709, -122.495877337913)
188929 203816 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1625 Monterey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5993083.51125 2095334.29452 37.7329916508262 -122.466302734486 (37.7329916508262, -122.466302734486)
188918 139460 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 822 Broderick St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6001026.3641 2111511.4487 37.777865290258 -122.440001839118 (37.777865290258, -122.440001839118)
188911 203784 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2050 09th Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 2ft   5993499.63978 2101506.86367 37.7499639748735 -122.465312293131 (37.7499639748735, -122.465312293131)
188907 220314 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 243 Caselli Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5999834.4826 2104724.5775099997 37.7591623243957 -122.443637281941 (37.7591623243957, -122.443637281941)
188906 220317 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 219 Diamond St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6001761.83081 2104620.92645 37.758987459326896 -122.43696418015399 (37.7589874593269, -122.436964180154)
188905 200550 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1400x La Salle Ave 26 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6016212.9331 2095623.1152 37.7350921083386 -122.386357662249 (37.7350921083386, -122.386357662249)
188802 220245 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 612 28th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 2ft   6001949.357000001 2099449.2483 37.744797921887 -122.43594557473301 (37.744797921887, -122.435945574733)
188772 125012 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 799 Marina Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5999213.87978 2121467.47063 37.8050985506219 -122.44698846615499 (37.8050985506219, -122.446988466155)
188710 125209 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2008 Washington St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   6004952.53327 2116801.7834099997 37.7926139551121 -122.426796690615 (37.7926139551121, -122.426796690615)
188663 174970 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 300 Seneca Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 4ft   5999272.73496 2090903.68447 37.7211813957975 -122.44458671600901 (37.7211813957975, -122.444586716009)
188645 125002 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 69 Cervantes Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6001637.3493099995 2120884.5276099998 37.8036361027929 -122.438559986648 (37.8036361027929, -122.438559986648)
188564 125263 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1183 Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 5ft   6007930.56867 2118531.51253 37.7975312888807 -122.416615139298 (37.7975312888807, -122.416615139298)
188539 125273 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3150 Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 5ft   6005555.61971 2121140.11755 37.8045599961102 -122.425018799299 (37.8045599961102, -122.425018799299)
188416 103938 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2300 Mason St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15     6008916.3437 2121176.0576 37.80484794271371 -122.413391203795 (37.8048479427137, -122.413391203795)
188382 142568 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2237 MASON ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6008908.9878 2120990.33 37.804337568276 -122.413403516875 (37.804337568276, -122.413403516875)
188352 188681 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Middle Point Rd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     6018210.72448 2096306.49238 37.7370789094531 -122.379497963675 (37.7370789094531, -122.379497963675)
188319 220213 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 483 Valley St 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6002841.26892 2099164.12546 37.744065668695995 -122.43284115011801 (37.744065668696, -122.432841150118)
188180 220134 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Duncan St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6006146.14259 2099977.33061 37.7464854349651 -122.421471358739 (37.7464854349651, -122.421471358739)
188120 205124 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1253 Portola Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5994307.62301 2097874.46117 37.740036874108704 -122.462254855373 (37.7400368741087, -122.462254855373)
188064 247316 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 608 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 0ft   6003150.2999 2109300.4667 37.7719151611071 -122.432496446051 (37.7719151611071, -122.432496446051)
188029 249872 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 230 Greenwich St 8 Back Yard : Yard 13 Tree 1 Private 1     9 Width 0ft   6011683.12279 2120489.80597 37.8031186185004 -122.403768099014 (37.8031186185004, -122.403768099014)
188008 187747 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 2x Dukes Ct 5 Median : Yard 3 Tree 1 DPW 2     15     6016140.5122 2096271.0286 37.7368671389145 -122.38665321539801 (37.7368671389145, -122.386653215398)
187982 124833 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 60 Retiro Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6001778.79024 2121390.34711 37.8050329936375 -122.438106779619 (37.8050329936375, -122.438106779619)
187787 125192 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2809 Buchanan St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6003488.35981 2118026.85016 37.795894781780895 -122.431950297892 (37.7958947817809, -122.431950297892)
187749 182048 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1335 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5987389.1636 2106183.4986 37.7624504598719 -122.486785732011 (37.7624504598719, -122.486785732011)
187675 203253 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 345 Hazelwood Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5996049.39925 2095464.3554200002 37.7335194494626 -122.45605834663401 (37.7335194494626, -122.456058346634)
187647 244947 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 301 Fell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6005935.3406 2110680.182 37.7758610639312 -122.42296085412599 (37.7758610639312, -122.422960854126)
187646 200535 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1400x La Salle Ave 11 Median : Cutout 11 Tree 1 DPW 2     9 Width 0ft   6016168.4829 2095664.0064 37.735201926775396 -122.386514194261 (37.7352019267754, -122.386514194261)
187585 124951 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 306 Laurel St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 6ft   5998114.79682 2115399.15749 37.788373742498706 -122.45035424187401 (37.7883737424987, -122.450354241874)
187551 188647 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Cargo Way 10 Median : Yard 3 Tree 1 DPW 2     17     6018073.116719999 2098111.74487 37.7420281826481 -122.38009915058001 (37.7420281826481, -122.38009915058)
187549 125107 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3157 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5999100.48549 2116268.51853 37.7908171411592 -122.447006517363 (37.7908171411592, -122.447006517363)
187365 203897 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3804 19th Ave 3 : 4 Tree 1 Private 1     3 Width 3ft   5990591.46397 2090484.77315 37.7195319761952 -122.474564506644 (37.7195319761952, -122.474564506644)
187271 249543 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1031 Franklin St 4 : 4 Tree 1 Private 1     20 Width 4ft   6006034.95999 2113672.91543 37.7840840006086 -122.42282898338699 (37.7840840006086, -122.422828983387)
187226 250936 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 242 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5987145.66978 2114320.34633 37.7847777601171 -122.488225846157 (37.7847777601171, -122.488225846157)
187078 187718 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 65 Whitney Young Cir 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6016979.12184 2094899.73634 37.733148235390296 -122.383658300306 (37.7331482353903, -122.383658300306)
187075 125066 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3400 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 3ft   5997947.5330300005 2116159.20004 37.7904510433245 -122.45098777287701 (37.7904510433245, -122.450987772877)
187072 187751 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1000 Oakdale Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     29     6018129.3732900005 2093209.5083299999 37.7285707113551 -122.379564150189 (37.7285707113551, -122.379564150189)
186948 188753 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 3ft   6014041.0419 2087033.9211099998 37.7113874378463 -122.393265880017 (37.7113874378463, -122.393265880017)
186858 220271 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 670 27th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6002170.52013 2100053.07336 37.7464684449584 -122.43522401718599 (37.7464684449584, -122.435224017186)
186846 203759 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1701 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 5ft   5991717.96646 2096103.43353 37.735024627670896 -122.471079748847 (37.7350246276709, -122.471079748847)
186826 187734 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 97 Whitney Young Cir 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft   6016672.472159999 2095023.0659400001 37.7334699192814 -122.384727069019 (37.7334699192814, -122.384727069019)
186731 188739 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 7 Median : Yard 3 Tree 1 DPW 2     18 Width 8ft   6014439.36233 2086971.4204900002 37.7112379444543 -122.39188480373801 (37.7112379444543, -122.391884803738)
186711 125251 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1073 Broadway 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6008484.56321 2118250.48158 37.7967907889218 -122.414678266696 (37.7967907889218, -122.414678266696)
186699 181919 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2050 Taraval St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5986766.2 2098960.6531 37.742582146722 -122.488409455551 (37.742582146722, -122.488409455551)
186698 203746 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 265 Wawona St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5992336.242740001 2097529.71539 37.7389765797008 -122.469045933837 (37.7389765797008, -122.469045933837)
186562 203970 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 260 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5992296.07103 2097549.34182 37.739028147731 -122.469186255936 (37.739028147731, -122.469186255936)
186558 187746 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 2x Dukes Ct 4 Median : Yard 3 Tree 1 DPW 2     16     6016141.394640001 2096265.75957 37.7368527200761 -122.38664979707501 (37.7368527200761, -122.386649797075)
186416 203873 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 178 Tara St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 6ft   5997913.09605 2090617.6625599999 37.7203183685688 -122.449265978542 (37.7203183685688, -122.449265978542)
186354 203892 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 173 Eucalyptus Dr 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 2ft   5991062.18306 2094654.07331 37.731007098902104 -122.47324133234501 (37.7310070989021, -122.473241332345)
186352 47483 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1736 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 22   Permit Number 45378 6002071.5211 2114540.3904 37.786241439117205 -122.436603142325 (37.7862414391172, -122.436603142325)
186296 120072 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 101 26th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5987688.32967 2115247.71242 37.7873556870051 -122.486416555037 (37.7873556870051, -122.486416555037)
186271 137825 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1900 WEBSTER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6003434.7492 2115254.5704 37.7882797707326 -122.43193774605601 (37.7882797707326, -122.431937746056)
186269 124818 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2390 Bay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5999369.64058 2120155.2996099996 37.801504580921105 -122.446354985487 (37.8015045809211, -122.446354985487)
186257 185005 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2701 Sunset Blvd 31 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5985036.876 2096499.1731 37.735722529984706 -122.49420747665701 (37.7357225299847, -122.494207476657)
186248 220313 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 90 Caselli Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 5ft   6000504.24211 2104917.08566 37.7597290807509 -122.44133475221201 (37.7597290807509, -122.441334752212)
186122 43982 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 58 Blake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/01/2000 12:00:00 AM 11   Permit Number 43545 5997823.8786 2113381.5676 37.7828173196945 -122.451215205093 (37.7828173196945, -122.451215205093)
186018 184852 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1201 Sunset Blvd 41 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984650.5796 2106852.1548 37.7641263625826 -122.49630668173201 (37.7641263625826, -122.496306681732)
185964 203848 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 535 Castenada Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 4ft   5992829.16774 2099990.2564 37.7457610706327 -122.46752052447701 (37.7457610706327, -122.467520524477)
185932 142456 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 566 FELL ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   6004665.8989 2110556.4961 37.775449740092505 -122.427343367052 (37.7754497400925, -122.427343367052)
185892 187116 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2600 Sunset Blvd 52 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5985139.0056 2097294.5581 37.7379124205271 -122.493912978366 (37.7379124205271, -122.493912978366)
185884 59890 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 3 Atalaya Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/07/1981 12:00:00 AM 12   Permit Number 19356 5998808.9736 2111008.0431 37.77635658928261 -122.447636289265 (37.7763565892826, -122.447636289265)
185877 124826 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 56 Cervantes Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6001759.52883 2120853.50314 37.8035578671766 -122.438134955373 (37.8035578671766, -122.438134955373)
185815 125298 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 822 Pacific Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6010056.95509 2118170.07703 37.7966582351325 -122.40923172685899 (37.7966582351325, -122.409231726859)
185774 143325 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 771 BROADWAY 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   6009931.4643 2118447.2128 37.7974121508724 -122.409685526133 (37.7974121508724, -122.409685526133)
185764 125098 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2005 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   5999415.19221 2115752.15532 37.7894173185149 -122.44588049781 (37.7894173185149, -122.44588049781)
185698 200522 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1477 La Salle Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6016183.5926 2095614.875 37.735067858263506 -122.38645852946199 (37.7350678582635, -122.386458529462)
185666 124985 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2501 Francisco St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 2ft   5999272.60523 2119747.73775 37.8003799831956 -122.44666142950199 (37.8003799831956, -122.446661429502)
185638 97974 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 325 Bowdoin St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2011 12:00:00 AM 14 3x3 Permit Number 767976 6008567.92648 2094152.82902 37.7306288773042 -122.412685380727 (37.7306288773042, -122.412685380727)
185625 188596 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1301 Rhode Island St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 7ft   6011998.11194 2102296.49626 37.7531815791825 -122.401398733471 (37.7531815791825, -122.401398733471)
185614 203928 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 700 Quintara St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5991222.21621 2101152.9176 37.7488605291971 -122.473161852043 (37.7488605291971, -122.473161852043)
185542 122911 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 12th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   5992125.45609 2114866.3571099997 37.786566225914704 -122.471037373124 (37.7865662259147, -122.471037373124)
185538 220222 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 62 Carmel St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   5998653.96279 2105407.43218 37.7609698726686 -122.44776922698999 (37.7609698726686, -122.44776922699)
185469 125239 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 859 O'Farrell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6007196.23625 2113975.33069 37.7849798135129 -122.418832832384 (37.7849798135129, -122.418832832384)
185458 125049 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3101 Van Ness Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6005457.64274 2121120.08776 37.8044994645471 -122.425356431775 (37.8044994645471, -122.425356431775)
185399 124305 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 169 Jordan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   5996209.822430001 2113206.80783 37.782244929320605 -122.456786484191 (37.7822449293206, -122.456786484191)
185372 101136 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1477 Grove St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6000824.6116 2110666.7087 37.7755343608772 -122.44063916358499 (37.7755343608772, -122.440639163585)
185208 247934 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1099 Esmeralda Ave 7 Side Yard : Yard 17 Tree 1 Private 1     14     6010311.02519 2098743.98721 37.7433328939103 -122.406982672633 (37.7433328939103, -122.406982672633)
185191 220232 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 437 Belvedere St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 4ft   5998506.37363 2106647.05925 37.764365140767005 -122.448368942583 (37.764365140767, -122.448368942583)
185154 140112 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 84 VANDEWATER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 Width 0ft   6009019.9173 2121317.2474 37.8052414292046 -122.41304276436001 (37.8052414292046, -122.41304276436)
185085 186871 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2700 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985209.8888 2096365.7780000002 37.7353663853906 -122.493599486872 (37.7353663853906, -122.493599486872)
185060 184887 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1201 Sunset Blvd 75 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984636.53 2106768.6166 37.763896167173705 -122.496349110122 (37.7638961671737, -122.496349110122)
184990 221388 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 671 Church St 57 Front Yard : Yard 7 Tree 1 Private 1     17 Width 3ft   6004298.752230001 2105308.1718200003 37.7610183389455 -122.428239289531 (37.7610183389455, -122.428239289531)
184985 125281 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1200 Greenwich St 7 Front Yard : Yard 7 Tree 1 Private 1     13     6006708.63096 2119779.53165 37.8008892360157 -122.42093202991 (37.8008892360157, -122.42093202991)
184954 122003 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2328 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   5991433.29876 2112038.51637 37.7787616992465 -122.473225729354 (37.7787616992465, -122.473225729354)
184927 123195 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 547 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   5993113.037380001 2111754.36009 37.7780785995771 -122.46739423751998 (37.7780785995771, -122.46739423752)
184741 139925 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1001 TURK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 0ft   6005197.5444 2112663.4649 37.78126501367171 -122.425654271119 (37.7812650136717, -122.425654271119)
184739 247539 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101 Waller St 21 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6000199.67712 2108517.8655 37.7695985727307 -122.442646631948 (37.7695985727307, -122.442646631948)
184701 143327 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 771 BROADWAY 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6009964.4292 2118452.5949 37.7974287760114 -122.409571838576 (37.7974287760114, -122.409571838576)
184607 203680 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1482 15th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 2ft   5991507.32785 2105347.89761 37.760395348885396 -122.472481734348 (37.7603953488854, -122.472481734348)
184594 101654 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 465 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12     5991223.427730001 2112267.5766 37.779378481558396 -122.473968464522 (37.7793784815584, -122.473968464522)
184506 125020 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1430 Jefferson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6002377.05102 2121615.30854 37.805684683751394 -122.43605254010001 (37.8056846837514, -122.4360525401)
184437 125188 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2340 Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 4ft   6002352.16428 2117791.8727700002 37.79518511776371 -122.43586492262199 (37.7951851177637, -122.435864922622)
184426 50822 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 240 Cervantes Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/19/2004 12:00:00 AM 14   Permit Number 47343 6000834.361830001 2121507.8753 37.8053019385925 -122.441383512537 (37.8053019385925, -122.441383512537)
184381 203860 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1025 Junipero Serra Blvd 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   5991248.87422 2090355.17031 37.719214188172 -122.472282658627 (37.719214188172, -122.472282658627)
184256 124645 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 20 Arguello Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   5995523.4178 2115711.6457 37.7890831035356 -122.45934257475001 (37.7890831035356, -122.45934257475)
184215 125154 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2640 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6000699.345380001 2117402.26991 37.794021342853796 -122.441555946776 (37.7940213428538, -122.441555946776)

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