Street_Tree_List

Data source: data.sfgov.org

446 rows where qSpecies = 103 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▼
150050 150050 209031 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 36 Martha Ave 8 Front Yard : Yard 7 Tree 1 Private 1     6     6000753.40861 2095578.70975 37.734102320756996 -122.43980347745001 (37.734102320757, -122.43980347745)
130011 130011 209032 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 38 Martha Ave 1 Front Yard : Yard 7 Tree 1 Private 1     5     6000749.17916 2095580.7996200002 37.7341078183059 -122.43981824973301 (37.7341078183059, -122.439818249733)
55842 55842 207761 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 345 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     41 Width 10ft   5993145.033430001 2095739.54752 37.7341079244482 -122.46611947693701 (37.7341079244482, -122.466119476937)
72359 72359 209033 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 38 Martha Ave 2 Front Yard : Yard 7 Tree 1 Private 1     10     6000746.954419999 2095582.5977 37.7341126287783 -122.439826070211 (37.7341126287783, -122.439826070211)
138770 138770 209034 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 38 Martha Ave 3 Front Yard : Yard 7 Tree 1 Private 1     30     6000740.95615 2095584.22378 37.7341167521787 -122.439846924607 (37.7341167521787, -122.439846924607)
43329 43329 111546 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 900x BOSWORTH ST 24 Front Yard : Yard 7 Tree 1 DPW 2     15     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
88008 88008 111551 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 900x BOSWORTH ST 29 Front Yard : Yard 7 Tree 1 DPW 2     27     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
92885 92885 111536 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 900x BOSWORTH ST 14 Front Yard : Yard 7 Tree 1 DPW 2     24     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
100681 100681 111529 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 900x BOSWORTH ST 7 Front Yard : Yard 7 Tree 1 DPW 2     24     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
117576 117576 111525 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 900x BOSWORTH ST 3 Front Yard : Yard 7 Tree 1 DPW 2     26     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
120548 120548 111538 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 900x BOSWORTH ST 16 Front Yard : Yard 7 Tree 1 DPW 2     28     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
141204 141204 111548 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 900x BOSWORTH ST 26 Front Yard : Yard 7 Tree 1 DPW 2     40     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
53855 53855 208983 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 330 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 3ft   5993097.51511 2095800.07009 37.73427136274 -122.466288158284 (37.73427136274, -122.466288158284)
162672 162672 207760 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 333 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 10ft   5993144.47081 2095802.99513 37.734282103340796 -122.46612603120501 (37.7342821033408, -122.466126031205)
131911 131911 207759 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 315 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 10ft   5993145.97421 2095838.45755 37.7343795610583 -122.46612340966999 (37.7343795610583, -122.46612340967)
112663 112663 114044 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 549X ARLINGTON ST   Median : Cutout 11 Tree 1 Private 1     70     6003400.0 2095634.0 37.734404428182295 -122.430657330781 (37.7344044281823, -122.430657330781)
23367 23367 208982 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 320 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     45 Width 3ft   5993096.565780001 2095876.3159599998 37.7344806601409 -122.46629697974501 (37.7344806601409, -122.466296979745)
105598 105598 106227 Property Tree 7 Eucalyptus globulus :: Blue Gum 103 38 Stanford Heights Ave 1 Back Yard : Yard 13 Tree 1 Private 1           5997884.0 2095808.5 37.7345695210024 -122.44974042873999 (37.7345695210024, -122.44974042874)
24602 24602 208981 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 310 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     43 Width 3ft   5993092.40274 2095921.0497 37.7346032476459 -122.466314622626 (37.7346032476459, -122.466314622626)
115179 115179 106275 Property Tree 7 Eucalyptus globulus :: Blue Gum 103 42 Stanford Heights Ave 1 Back Yard : Yard 13 Tree 1 Private 1           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555)
76953 76953 208935 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 3 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 10ft   5991812.79149 2095969.62922 37.7346627188958 -122.47074216493401 (37.7346627188958, -122.470742164934)
152307 152307 208936 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 3 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 10ft   5991855.38456 2095971.03212 37.7346690339426 -122.470595009771 (37.7346690339426, -122.470595009771)
76936 76936 208937 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 64 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     36 Width 10ft   5991925.34536 2095973.96809 37.734681140613105 -122.47035334753201 (37.7346811406131, -122.470353347532)
28258 28258 208938 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 66 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 10ft   5991979.81471 2095977.19537 37.7346931510662 -122.470165265142 (37.7346931510662, -122.470165265142)
185411 185411 208939 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 10ft   5992155.70572 2095974.23732 37.7346951961161 -122.469556940308 (37.7346951961161, -122.469556940308)
165768 165768 208980 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 302 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5993091.73044 2095958.45065 37.7347059025462 -122.46631966423901 (37.7347059025462, -122.466319664239)
26365 26365 208940 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     37 Width 10ft   5992201.32921 2095978.5342700002 37.7347096311457 -122.469399518468 (37.7347096311457, -122.469399518468)
41832 41832 208941 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 130 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 10ft   5992287.573419999 2095984.60456 37.734731282309106 -122.469101787134 (37.7347312823091, -122.469101787134)
64951 64951 208942 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 200 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 10ft   5992406.13159 2095989.66706 37.7347520323855 -122.468692262863 (37.7347520323855, -122.468692262863)
131518 131518 208943 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 200 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     39 Width 10ft   5992457.65692 2095992.19703 37.7347619554908 -122.46851430770701 (37.7347619554908, -122.468514307707)
25657 25657 208945 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 234 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     40 Width 10ft   5992554.30272 2095990.82137 37.73476376044329 -122.46818007286001 (37.7347637604433, -122.46818007286)
180635 180635 208944 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 234 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     41 Width 10ft   5992497.26068 2095992.6782799999 37.73476556447329 -122.468377420108 (37.7347655644733, -122.468377420108)
155663 155663 208953 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 502 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 8ft   5993239.50835 2095986.2551799999 37.734790772481 -122.46581076936701 (37.734790772481, -122.465810769367)
173362 173362 208948 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 340 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 10ft   5992820.42769 2095999.6816200002 37.734803454707496 -122.46726063928499 (37.7348034547075, -122.467260639285)
71759 71759 208946 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 300 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 10ft   5992719.83793 2096001.79663 37.7348034547201 -122.467608563598 (37.7348034547201, -122.467608563598)
167226 167226 208947 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 340 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 10ft   5992761.11825 2096003.55707 37.734810671779705 -122.467465972472 (37.7348106717797, -122.467465972472)
61439 61439 208913 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 25 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     52 Width 10ft   5991855.18446 2096027.3519599999 37.7348236624713 -122.470599802253 (37.7348236624713, -122.470599802253)
153452 153452 208949 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 402 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 10ft   5992933.736169999 2096006.17085 37.7348278128415 -122.46686936763099 (37.7348278128415, -122.466869367631)
24218 24218 208954 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 600 Saint Francis Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 8ft   5993495.97502 2095994.9515900002 37.7348294415148 -122.464924714122 (37.7348294415148, -122.464924714122)
72305 72305 208950 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 440 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 10ft   5992985.54967 2096006.72468 37.734832323836706 -122.46669027215599 (37.7348323238367, -122.466690272156)
70660 70660 208956 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 630 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 8ft   5993584.21489 2095997.1565599998 37.7348405832115 -122.464619800786 (37.7348405832115, -122.464619800786)
33873 33873 208955 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 630 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 8ft   5993530.979180001 2095998.56422 37.7348413791301 -122.464803955838 (37.7348413791301, -122.464803955838)
61081 61081 208914 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 45 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38 Width 10ft   5991964.75621 2096031.6123 37.7348416956868 -122.470221288386 (37.7348416956868, -122.470221288386)
23922 23922 208951 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 440 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     40 Width 10ft   5993021.57409 2096009.5815299999 37.734842246953896 -122.46656593187099 (37.7348422469539, -122.466565931871)
62096 62096 208915 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 47 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 10ft   5992029.43062 2096033.53444 37.734850712276796 -122.469997828452 (37.7348507122768, -122.469997828452)
165006 165006 208952 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 440 Saint Francis Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 10ft   5993062.868430001 2096011.9995 37.734851268974296 -122.466423339872 (37.7348512689743, -122.466423339872)
158211 158211 208916 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 47 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     40 Width 10ft   5992082.23886 2096035.7065400002 37.7348597288875 -122.469815411761 (37.7348597288875, -122.469815411761)
137770 137770 208917 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Saint Francis Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     41 Width 10ft   5992152.90186 2096040.12972 37.734875958047496 -122.46957142927499 (37.7348759580475, -122.469571429275)
49984 49984 208918 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 10ft   5992207.01448 2096041.6179 37.7348831715052 -122.46938445304899 (37.7348831715052, -122.469384453049)
26956 26956 208920 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 135 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 10ft   5992288.77396 2096040.55395 37.734884974665 -122.46910170710301 (37.734884974665, -122.469101707103)
74311 74311 208919 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38 Width 10ft   5992247.91507 2096042.0705099998 37.734886777797996 -122.469243079632 (37.734886777798, -122.469243079632)
173563 173563 208921 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 135 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 10ft   5992336.36345 2096045.4635 37.7349012047205 -122.46893753225001 (37.7349012047205, -122.46893753225)
30943 30943 208922 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 201 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 10ft   5992403.02946 2096048.0013299999 37.7349120244605 -122.46870723116899 (37.7349120244605, -122.468707231169)
159777 159777 208923 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 201 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 10ft   5992447.89906 2096049.02744 37.734917433899 -122.468552177239 (37.734917433899, -122.468552177239)
181826 181826 208924 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 235 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     44 Width 10ft   5992506.66791 2096052.3886900002 37.7349300576612 -122.468349238953 (37.7349300576612, -122.468349238953)
176352 176352 208925 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 235 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     45 Width 10ft   5992554.16067 2096052.7030900002 37.734933663950294 -122.46818506409599 (37.7349336639503, -122.468185064096)
62516 62516 208926 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 301 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     43 Width 10ft   5992668.30531 2096054.89965 37.7349462868375 -122.467790589077 (37.7349462868375, -122.467790589077)
157860 157860 208927 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 301 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     36 Width 10ft   5992731.01578 2096057.52147 37.7349571065737 -122.46757396937299 (37.7349571065737, -122.467573969373)
150553 150553 208928 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 335 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     44 Width 10ft   5992778.536119999 2096059.1494200001 37.7349643200549 -122.467409794552 (37.7349643200549, -122.467409794552)
154936 154936 224219 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1201 San Jose Ave 4 Front Yard : Yard 7 Tree 1 Private 1     7     6004118.53569 2095824.9734900002 37.734969479450896 -122.428186723249 (37.7349694794509, -122.428186723249)
135413 135413 208934 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 405 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 10ft   5992888.064180001 2096062.32962 37.734979374706505 -122.467031351742 (37.7349793747065, -122.467031351742)
65901 65901 208933 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 405 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 10ft   5992936.60702 2096064.2661700002 37.7349874937845 -122.466863664131 (37.7349874937845, -122.466863664131)
164177 164177 224220 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1201 San Jose Ave 5 Front Yard : Yard 7 Tree 1 Private 1     46     6004122.93683 2095831.8247900002 37.734988540591395 -122.42817199506099 (37.7349885405914, -122.428171995061)
50349 50349 208932 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 435 Saint Francis Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     47 Width 10ft   5992980.53983 2096066.6285400002 37.734996515770604 -122.4667119458 (37.7349965157706, -122.4667119458)
76846 76846 208931 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 435 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 10ft   5993027.44059 2096068.9282799999 37.735005536864904 -122.46654996171101 (37.7350055368649, -122.466549961711)
164844 164844 208930 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 435 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     55 Width 10ft   5993068.37064 2096069.711 37.735010047856704 -122.466408510055 (37.7350100478567, -122.466408510055)
65175 65175 208929 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 501 Saint Francis Blvd 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     34 Width 6ft   5993145.62708 2096072.03007 37.735020873007 -122.466141577798 (37.735020873007, -122.466141577798)
137042 137042 207787 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 292 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 10ft   5993086.25016 2096104.5741400002 37.7351068050182 -122.466349227661 (37.7351068050182, -122.466349227661)
184880 184880 208960 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 601 Saint Francis Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     44 Width 8ft   5993401.29019 2096115.48675 37.735154941244396 -122.465260822223 (37.7351549412444, -122.465260822223)
170955 170955 208959 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 601 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 8ft   5993493.92403 2096119.04846 37.7351700624345 -122.46494081468 (37.7351700624345, -122.46494081468)
171833 171833 208958 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 625 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 8ft   5993531.51586 2096121.15742 37.7351780205546 -122.464811000239 (37.7351780205546, -122.464811000239)
69718 69718 208957 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 625 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   5993588.443419999 2096129.23717 37.73520348755321 -122.46461476908001 (37.7352034875532, -122.46461476908)
68451 68451 207786 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 290 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 10ft   5993081.96122 2096160.8531 37.735261085532706 -122.46636814486999 (37.7352610855327, -122.46636814487)
40215 40215 207788 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 285 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 10ft   5993135.10109 2096167.2284099997 37.7352816566244 -122.46618488553001 (37.7352816566244, -122.46618488553)
10119 10119 173856 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 118 Saint Mary's Ave 2 Sidewalk: Property side : Yard 9 Tree 1 DPW 2       Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
168122 168122 169607 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 118 Saint Mary's Ave 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     0 Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
3850 3850 207785 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 290 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   09/28/2017 12:00:00 AM 3 Width 10ft   5993081.87997 2096205.8056700001 37.7353845093885 -122.46637169180299 (37.7353845093885, -122.466371691803)
33664 33664 207789 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 275 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 10ft   5993131.90761 2096210.54353 37.735400404893 -122.46619907325199 (37.735400404893, -122.466199073252)
46031 46031 207784 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 270 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 10ft   5993081.2153199995 2096255.53806 37.735521023771604 -122.466377603044 (37.7355210237716, -122.466377603044)
153159 153159 207790 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 265 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     39 Width 10ft   5993131.48438 2096255.5032900001 37.735523828762005 -122.466203802777 (37.735523828762, -122.466203802777)
887 887 251303 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1 Cashmere St 2 Back Yard : Yard 13 Tree 1 Health Dept 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
896 896 251302 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1 Cashmere St 1 Back Yard : Yard 13 Tree 1 Health Dept 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
148956 148956 207783 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 260 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 10ft   5993078.05201 2096316.5606 37.7356883939084 -122.466392973362 (37.7356883939084, -122.466392973362)
188685 188685 207791 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 255 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 10ft   5993127.95212 2096331.51719 37.7357323401679 -122.466221537416 (37.7357323401679, -122.466221537416)
90489 90489 113805 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 990X OSHAUGHNESSY BLVD 2 Front Yard : Yard 7 Tree 1 Rec/Park 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
109652 109652 113804 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 990X OSHAUGHNESSY BLVD 1 Front Yard : Yard 7 Tree 1 Rec/Park 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
53478 53478 207782 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 260 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 10ft   5993076.07579 2096352.6988099997 37.7357875063795 -122.466402431535 (37.7357875063795, -122.466402431535)
130074 130074 207792 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 255 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 10ft   5993127.3071800005 2096365.9249099998 37.7358267779692 -122.46622626692499 (37.7358267779692, -122.466226266925)
162142 162142 207781 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 256 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 10ft   5993074.748819999 2096403.4667 37.7359268257591 -122.466410707985 (37.7359268257591, -122.466410707985)
51382 51382 207780 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 250 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 10ft   5993075.61435 2096444.65306 37.7360399631594 -122.46641070800501 (37.7360399631594, -122.466410708005)
167382 167382 207793 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 215 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38 Width 10ft   5993139.697869999 2096516.18073 37.7362400578338 -122.466194343712 (37.7362400578338, -122.466194343712)
114512 114512 108201 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 90 Reuel Ct 2 Front Yard : Yard 7 Tree 1 Private 1         Permit Number 774102 6017404.09127 2096025.6169900002 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258)
119476 119476 108200 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 90 Reuel Ct 1 Front Yard : Yard 7 Tree 1 Private 1         Permit Number 774102 6017404.09127 2096025.6169900002 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258)
154505 154505 208971 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 150 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38 Width 6ft   5994318.90627 2096521.2556599998 37.736321957275706 -122.462117732164 (37.7363219572757, -122.462117732164)
29388 29388 207794 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 213 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 10ft   5993149.25155 2096563.99491 37.736371894833 -122.46616478658999 (37.736371894833, -122.46616478659)
187171 187171 208972 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 136 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 6ft   5994281.63654 2096550.25213 37.7363994284866 -122.462248690521 (37.7363994284866, -122.462248690521)
66266 66266 191737 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 200 Helena St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6010885.73151 2096220.33708 37.736435634280895 -122.40481783988199 (37.7364356342809, -122.404817839882)
181003 181003 191736 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 200 Helena St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     57     6010895.577219999 2096228.10312 37.7364575084979 -122.40478434551399 (37.7364575084979, -122.404784345514)
47668 47668 208973 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 136 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 6ft   5994259.725980001 2096572.0955299998 37.7364581434207 -122.46232602774799 (37.7364581434207, -122.462326027748)
133823 133823 207795 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 213 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 10ft   5993167.32945 2096610.60875 37.7365009277821 -122.466105670558 (37.7365009277821, -122.466105670558)

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