Street_Tree_List

Data source: data.sfgov.org

479 rows where qSiteInfo = 2 and qSpecies = 5 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 479 ✖
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▼
133501 133501 175075 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1082 Munich St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 6ft   6001955.35702 2087155.69226 37.7110429516559 -122.435045755382 (37.7110429516559, -122.435045755382)
155490 155490 175074 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1082 Munich St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 6ft   6001979.9665 2087165.3446 37.711070852213396 -122.43496138907801 (37.7110708522134, -122.434961389078)
35933 35933 188732 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   6014643.15959 2086929.06971 37.7111329692742 -122.391177465365 (37.7111329692742, -122.391177465365)
42001 42001 188730 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6014544.34623 2086934.52337 37.7111424598152 -122.39151937233 (37.7111424598152, -122.39151937233)
68720 68720 188729 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 3ft   6014522.262519999 2086936.6978200001 37.7111472046498 -122.391595851594 (37.7111472046498, -122.391595851594)
68152 68152 188728 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   6014503.20591 2086938.3794099998 37.7111507641693 -122.39166183394501 (37.7111507641693, -122.391661833945)
165358 165358 188727 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   6014344.673219999 2086951.52191 37.7111780496084 -122.39221068478999 (37.7111780496084, -122.39221068479)
34628 34628 188726 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 3ft   6014282.88696 2086958.43171 37.7111935916762 -122.39242471805001 (37.7111935916762, -122.39242471805)
40250 40250 188750 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 150 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   6014131.496280001 2086972.33958 37.7112233718385 -122.39294893824801 (37.7112233718385, -122.392948938248)
38609 38609 188748 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 150 Executive Park Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   6013906.67984 2086991.4991 37.7112634896854 -122.39372730596399 (37.7112634896854, -122.393727305964)
153046 153046 187709 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   6013649.01686 2087002.29435 37.7112788096526 -122.39461861596399 (37.7112788096526, -122.394618615964)
61209 61209 187708 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   6013663.58022 2087013.01188 37.7113090475516 -122.394569030961 (37.7113090475516, -122.394569030961)
151217 151217 187707 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   6013680.06159 2087022.4997 37.7113360155142 -122.394512730686 (37.7113360155142, -122.394512730686)
27387 27387 187706 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   6013695.628330001 2087031.1132200002 37.7113605319472 -122.394459530409 (37.7113605319472, -122.394459530409)
131541 131541 188752 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   6014065.713880001 2087031.5756700002 37.7113823683797 -122.393180442647 (37.7113823683797, -122.393180442647)
41902 41902 187705 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   6013715.36859 2087039.19615 37.711383823464104 -122.394391868106 (37.7113838234641, -122.394391868106)
186948 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)
166674 166674 188754 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   6014012.046130001 2087036.3540700001 37.7113925073379 -122.393366267763 (37.7113925073379, -122.393366267763)
76746 76746 188755 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   6013963.90027 2087039.17424 37.71139757590579 -122.393532870747 (37.7113975759058, -122.393532870747)
30514 30514 188756 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6013935.51575 2087041.28736 37.711401800917 -122.393631123501 (37.711401800917, -122.393631123501)
26244 26244 187704 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   6013733.429690001 2087045.5271 37.7114022110065 -122.394329886826 (37.7114022110065, -122.394329886826)
71147 71147 188757 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 3ft   6013913.012159999 2087043.8965900003 37.711407714869 -122.393709084803 (37.711407714869, -122.393709084803)
46481 46481 188759 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   6013862.38947 2087046.45952 37.711411938972894 -122.393884230478 (37.7114119389729, -122.393884230478)
181227 181227 188758 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   6013886.48106 2087045.97193 37.711411938995205 -122.39380092898999 (37.7114119389952, -122.39380092899)
160893 160893 187703 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   6013752.04605 2087049.7634299998 37.71141487796321 -122.39426583982099 (37.7114148779632, -122.394265839821)
132228 132228 187702 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6013770.9191 2087051.9111799998 37.7114218243198 -122.39420075947099 (37.7114218243198, -122.394200759471)
136368 136368 174996 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 65 Curtis St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   6000640.5625599995 2088159.86327 37.7137254368584 -122.43966193405501 (37.7137254368584, -122.439661934055)
137195 137195 174997 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 61 Curtis St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 4ft   6000632.91251 2088182.3265900002 37.7137866806885 -122.43968998482 (37.7137866806885, -122.43968998482)
173496 173496 174998 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 47 Curtis St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   6000602.5075 2088281.5503900002 37.714057396398395 -122.43980218511601 (37.7140573963984, -122.439802185116)
59248 59248 175001 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 Newton St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 5ft   6000856.019180001 2088342.93848 37.714240381459 -122.438930350851 (37.714240381459, -122.438930350851)
148080 148080 175002 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 Newton St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   6000849.25835 2088363.04115 37.7142951942344 -122.438955158647 (37.7142951942344, -122.438955158647)
45671 45671 174991 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 42 Curtis St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 4ft   6000531.41546 2088375.4753 37.7143112462302 -122.440054636526 (37.7143112462302, -122.440054636526)
158447 158447 175003 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 Newton St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 5ft   6000843.24005 2088383.1284400001 37.7143500070223 -122.43897739890801 (37.7143500070223, -122.438977398908)
167983 167983 174983 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1005 Madrid St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   6001103.82585 2088413.5291400002 37.7144483038197 -122.438078889846 (37.7144483038197, -122.438078889846)
39003 39003 174984 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1005 Madrid St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 4ft   6001116.49451 2088434.7952400001 37.7145074162652 -122.438036624391 (37.7145074162652, -122.438036624391)
178719 178719 174989 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1000 Madrid St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   6001106.19823 2088490.6966400002 37.714660323495394 -122.438076214354 (37.7146603234954, -122.438076214354)
156554 156554 174988 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1000 Madrid St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   6001118.27335 2088513.9598599998 37.7147248858297 -122.43803614326099 (37.7147248858297, -122.438036143261)
58815 58815 175053 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1100 Junipero Serra Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 3ft   5991263.57125 2088857.38752 37.7151024940541 -122.472122741173 (37.7151024940541, -122.472122741173)
75957 75957 175052 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1100 Junipero Serra Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5991243.240780001 2088948.27208 37.715350864326 -122.472199632304 (37.715350864326, -122.472199632304)
146900 146900 174977 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 861 Lisbon St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 6ft   6001002.8590400005 2088768.34496 37.7154168062239 -122.4384532767 (37.7154168062239, -122.4384532767)
133619 133619 175051 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1100 Junipero Serra Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 3ft   5991233.90488 2088989.0818 37.7154623775575 -122.472234874046 (37.7154623775575, -122.472234874046)
27663 27663 174978 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 861 Lisbon St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 6ft   6001016.58593 2088794.32712 37.7154889282344 -122.43840769096799 (37.7154889282344, -122.438407690968)
147713 147713 174979 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 861 Lisbon St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 6ft   6001031.1498 2088817.30686 37.7155528538591 -122.438358997196 (37.7155528538591, -122.438358997196)
129863 129863 175050 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1100 Junipero Serra Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5991220.94101 2089033.6599400002 37.7155840279702 -122.472282930219 (37.7155840279702, -122.472282930219)
79402 79402 105345   Acacia melanoxylon :: Blackwood Acacia 5 466 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5989603.4 2089229.6 37.7160282834266 -122.477888136934 (37.7160282834266, -122.477888136934)
54078 54078 175055 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 0 Juan Bautista Cir 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 6ft   5989631.25858 2089762.2141 37.717492326377396 -122.47783075799299 (37.7174923263774, -122.477830757993)
146940 146940 175054 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 0 Juan Bautista Cir 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   5989611.995 2089764.5445599998 37.717497607213 -122.477897512877 (37.717497607213, -122.477897512877)
130572 130572 175056 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 0 Juan Bautista Cir 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 6ft   5989706.768680001 2089771.1957900003 37.7175213699925 -122.47757041324199 (37.7175213699925, -122.477570413242)
152170 152170 188724 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 961 Le Conte Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6013382.05808 2089359.66984 37.7177368520568 -122.395706366661 (37.7177368520568, -122.395706366661)
67831 67831 188723 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 961 Le Conte Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6013346.445730001 2089388.2762799999 37.717813418545205 -122.39583146685499 (37.7178134185452, -122.395831466855)
163854 163854 203872 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 9 Granada Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5995594.11167 2089942.67302 37.7183320899249 -122.457233092344 (37.7183320899249, -122.457233092344)
164225 164225 203871 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 9 Granada Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5995594.53815 2089951.54412 37.718356472363794 -122.45723225957799 (37.7183564723638, -122.457232259578)
163702 163702 203870 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 9 Granada Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5995594.9546 2089959.9355900001 37.718379537275894 -122.45723142680401 (37.7183795372759, -122.457231426804)
51801 51801 203869 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 9 Granada Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5995595.19547 2089971.4511099998 37.7184111700071 -122.45723142680401 (37.7184111700071, -122.457231426804)
57390 57390 203868 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 9 Granada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5995595.3460099995 2089978.64807 37.7184309398048 -122.457231426799 (37.7184309398048, -122.457231426799)
55494 55494 188725 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3311 Jennings St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6013382.39836 2089856.6205900002 37.7191013987931 -122.395739991411 (37.7191013987931, -122.395739991411)
154993 154993 203861 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1025 Junipero Serra Blvd 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   5991252.63127 2090414.4123799999 37.7193770697644 -122.472273988268 (37.7193770697644, -122.472273988268)
142221 142221 104943 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 830X Gonzalez Dr   Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
854 854 203901 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 3794 19th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2     12 Width 3ft   5990470.121669999 2090714.3108400002 37.720155198286 -122.475000685058 (37.720155198286, -122.475000685058)
179031 179031 203988 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 665 Faxon Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 3ft   5994873.24978 2092595.62975 37.72557504624321 -122.459916865398 (37.7255750462432, -122.459916865398)
35032 35032 203989 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 665 Faxon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 3ft   5994872.64121 2092622.4417599998 37.725648630558 -122.45992091053999 (37.725648630558, -122.45992091054)
160697 160697 203993 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 62 Eastwood Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 3ft   5995660.26957 2093014.2492400003 37.7267697065318 -122.45722649041599 (37.7267697065318, -122.457226490416)
163378 163378 203992 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 402 Montecito Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 3ft   5995690.08771 2093990.03586 37.7294506943798 -122.457193967347 (37.7294506943798, -122.457193967347)
76886 76886 203850 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 615 Hearst Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 4ft   5997392.45328 2094384.9324299998 37.7306326095115 -122.451337224252 (37.7306326095115, -122.451337224252)
160924 160924 203849 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 615 Hearst Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 4ft   5997371.26354 2094385.62259 37.730633291178606 -122.45141052978501 (37.7306332911786, -122.451410529785)
132566 132566 203830 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 990 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     5995335.27016 2094553.61244 37.730977754916 -122.45846137648998 (37.730977754916, -122.45846137649)
168770 168770 203996 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 855 Monterey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5996332.325619999 2094668.8718700001 37.7313514789886 -122.455022734117 (37.7313514789886, -122.455022734117)
56790 56790 203976 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 155 Monterey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5993355.56121 2095278.1224 37.7328531093825 -122.465358115406 (37.7328531093825, -122.465358115406)
188929 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)
171036 171036 203817 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1615 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 4ft   5993108.74619 2095336.27282 37.7329985387476 -122.46621563515 (37.7329985387476, -122.46621563515)
25388 25388 203818 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1615 Monterey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   5993134.0104 2095339.6445 37.7330092541688 -122.466128535825 (37.7330092541688, -122.466128535825)
43942 43942 203975 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 380 Santa Clara Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 3ft   5993162.43396 2095420.1144400002 37.7332318444753 -122.466036114303 (37.7332318444753, -122.466036114303)
151664 151664 187723 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 57 Progress St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 4ft   6016846.42344 2095098.5772 37.733686877130204 -122.384130920999 (37.7336868771302, -122.384130920999)
44722 44722 188706 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1798 Revere Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6014089.91477 2095172.94813 37.7337382967731 -122.393666257286 (37.7337382967731, -122.393666257286)
153019 153019 188707 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1798 Revere Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6014081.18704 2095173.94358 37.733740545089205 -122.393696501513 (37.7337405450892, -122.393696501513)
186846 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)
106228 106228 203760 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1701 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 5ft   5991731.43964 2096118.43534 37.7350665981268 -122.47103426024401 (37.7350665981268, -122.471034260244)
27032 27032 203761 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1701 Portola Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 5ft   5991748.48888 2096138.80576 37.73512351624029 -122.470976798948 (37.7351235162403, -122.470976798948)
64226 64226 203762 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1701 Portola Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   5991768.27886 2096160.0227700002 37.735182917356894 -122.47090992357 (37.7351829173569, -122.47090992357)
156108 156108 203763 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1701 Portola Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 5ft   5991783.45029 2096172.36825 37.7352176923484 -122.470858369923 (37.7352176923484, -122.470858369923)
67990 67990 203764 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1651 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 5ft   5991822.8552 2096210.8445099997 37.7353256172728 -122.470724935722 (37.7353256172728, -122.470724935722)
72541 72541 203765 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1651 Portola Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 5ft   5991874.878380001 2096270.30542 37.73549189024521 -122.47054940332899 (37.7354918902452, -122.470549403329)
48624 48624 205132 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 191 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5993653.80371 2096240.5389599998 37.7355128624126 -122.464396875039 (37.7355128624126, -122.464396875039)
181463 181463 203766 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1651 Portola Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 5ft   5991897.53803 2096297.49982 37.7355678694505 -122.470473041024 (37.7355678694505, -122.470473041024)
150381 150381 205133 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 191 San Anselmo Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 3ft   5993712.29678 2096286.7052799999 37.735642995219 -122.464197994461 (37.735642995219, -122.464197994461)
157802 157802 203767 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1651 Portola Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 5ft   5991927.15466 2096324.98468 37.7356450483798 -122.47037264697599 (37.7356450483798, -122.470372646976)
154856 154856 203768 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1651 Portola Dr 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 5ft   5991957.08337 2096353.53239 37.7357251635838 -122.47027125112301 (37.7357251635838, -122.470271251123)
149983 149983 203769 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1601 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 5ft   5991977.99978 2096372.22512 37.735777698380204 -122.470200296407 (37.7357776983802, -122.470200296407)
155995 155995 203770 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1601 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 5ft   5992012.042640001 2096406.0099799999 37.735872431168396 -122.470085057304 (37.7358724311684, -122.470085057304)
129812 129812 203771 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1601 Portola Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 5ft   5992039.39943 2096434.69512 37.735952774794605 -122.469992562906 (37.7359527747946, -122.469992562906)
62660 62660 217752 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 435 West Portal Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   5991839.4595 2096525.3752099997 37.736190199410295 -122.470690431444 (37.7361901994103, -122.470690431444)
42043 42043 188631 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 101 Charter Oak Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27     6010953.30174 2096155.7818599998 37.7362621559727 -122.404579676927 (37.7362621559727, -122.404579676927)
55624 55624 217753 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 415 West Portal Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 3ft   5991857.04796 2096555.01202 37.736272591693705 -122.470631779443 (37.7362725916937, -122.470631779443)
75315 75315 188632 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 101 Charter Oak Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6010956.26861 2096182.79853 37.7363365038229 -122.404571320413 (37.7363365038229, -122.404571320413)
74371 74371 203772 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1571 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 5ft   5992186.68475 2096577.02503 37.736352089965294 -122.469493700882 (37.7363520899653, -122.469493700882)
160393 160393 188633 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Helena St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6010969.7403 2096191.55002 37.7363612864506 -122.40452535876999 (37.7363612864506, -122.40452535877)
49587 49587 188634 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Helena St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6010981.22837 2096191.91786 37.736362938482706 -122.404485665384 (37.7363629384827, -122.404485665384)
173880 173880 217754 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 401 West Portal Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 3ft   5991873.84206 2096589.33357 37.7363678011265 -122.470576214823 (37.7363678011265, -122.470576214823)
45504 45504 188636 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Helena St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6011012.07501 2096193.39606 37.7363687211334 -122.404379119099 (37.7363687211334, -122.404379119099)
170633 170633 188637 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Helena St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6011019.03327 2096193.8561200001 37.736370373201105 -122.40435509372699 (37.7363703732011, -122.404355093727)

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