Street_Tree_List

Data source: data.sfgov.org

446 rows where qSpecies = 103 sorted by TreeID

✎ 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
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)
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)
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)
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)
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)
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)
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)
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)
178890 178890 207796 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 145 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     45 Width 10ft   5993217.29355 2096710.01575 37.736776757040204 -122.465940145823 (37.7367767570402, -122.465940145823)
74106 74106 207797 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 145 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     42 Width 10ft   5993240.654130001 2096747.6644599999 37.7368814785997 -122.465862113458 (37.7368814785997, -122.465862113458)
165361 165361 207798 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     41 Width 10ft   5993265.61107 2096796.17632 37.7370161196856 -122.465779350629 (37.7370161196856, -122.465779350629)
40777 40777 207799 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 10ft   5993278.012180001 2096833.03373 37.7371180362587 -122.465739151856 (37.7371180362587, -122.465739151856)
34400 34400 207800 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Santa Clara Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     42 Width 10ft   5993292.571380001 2096874.95335 37.737233976861205 -122.465691859205 (37.7372339768612, -122.465691859205)
153757 153757 207801 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 75 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     41 Width 10ft   5993316.85986 2097021.89165 37.737638833663794 -122.465618555459 (37.7376388336638, -122.465618555459)
165620 165620 207802 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 65 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 10ft   5993322.83202 2097078.2937 37.7377940440554 -122.465602003431 (37.7377940440554, -122.465602003431)
147322 147322 207803 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 55 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 10ft   5993318.6344099995 2097122.65017 37.737915593714106 -122.465619738075 (37.7379155937141, -122.465619738075)
67445 67445 207804 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 55 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 10ft   5993316.273159999 2097156.75234 37.738009093546 -122.46563037885099 (37.738009093546, -122.465630378851)
130507 130507 207805 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 35 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 10ft   5993257.8737699995 2097404.51842 37.738686028527 -122.46585029007099 (37.738686028527, -122.465850290071)
169216 169216 207806 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 35 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 10ft   5993241.00806 2097448.11917 37.738804772329104 -122.46591177043501 (37.7388047723291, -122.465911770435)
60463 60463 207807 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 25 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 10ft   5993231.15579 2097483.74028 37.7389020106052 -122.46594842230199 (37.7389020106052, -122.465948422302)
149306 149306 207808 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 15 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 10ft   5993219.0538800005 2097526.21938 37.7390179494069 -122.46599335061899 (37.7390179494069, -122.465993350619)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
132331 132331 208961 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1575 07th Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 2ft   5993977.82871 2104681.32491 37.75870779624321 -122.463889098911 (37.7587077962432, -122.463889098911)
75990 75990 208962 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 90 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 6ft   5993970.2453 2096804.3744 37.7370792503013 -122.463343727552 (37.7370792503013, -122.463343727552)
29038 29038 208963 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 90 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 6ft   5993939.166669999 2096822.57013 37.7371274206966 -122.463452499655 (37.7371274206966, -122.463452499655)
156141 156141 208964 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 60 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 6ft   5993779.53053 2096936.1958400002 37.737430209820296 -122.46401267564801 (37.7374302098203, -122.464012675648)
114900 114900 208965 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 56 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 6ft   5993745.43898 2096960.72106 37.7374955851482 -122.464132325055 (37.7374955851482, -122.464132325055)
66396 66396 208966 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 44 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     44 Width 6ft   5993666.080159999 2097016.89785 37.7376452584166 -122.46441078125099 (37.7376452584166, -122.464410781251)
188785 188785 208967 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 44 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 6ft   5993630.4889400005 2097044.9006700001 37.737720095508706 -122.46453586883001 (37.7377200955087, -122.46453586883)
52363 52363 208968 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 34 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 6ft   5993576.11533 2097077.3704400002 37.737806114757795 -122.46472622025298 (37.7378061147578, -122.464726220253)
164085 164085 208969 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 30 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 6ft   5993545.78483 2097101.19005 37.737869768775795 -122.46483281598302 (37.7378697687758, -122.464832815983)
188184 188184 208970 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 20 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 6ft   5993484.40904 2097144.7715200002 37.7379858937365 -122.46504818472499 (37.7379858937365, -122.465048184725)
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)
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)
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)
44792 44792 208974 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 130 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 6ft   5994229.97779 2096604.2011400003 37.7365445844613 -122.462431207033 (37.7365445844613, -122.462431207033)
160755 160755 208975 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Yerba Buena Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 6ft   5994177.11325 2096643.32557 37.7366489660835 -122.462616818123 (37.7366489660835, -122.462616818123)
36761 36761 208976 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Yerba Buena Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 6ft   5994151.01662 2096664.6627200001 37.7367060496466 -122.462708592139 (37.7367060496466, -122.462708592139)
149487 149487 208977 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 300x Marietta Dr 45 Median : Cutout 11 Tree 1 DPW 2     27 Width 5ft   5999505.82373 2097502.74743 37.7393141797969 -122.44425497048401 (37.7393141797969, -122.444254970484)
175511 175511 208978 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 700 Junipero Serra Blvd 109 : 4 Tree 1 Private 1     14 Width 0ft   5991241.872330001 2091923.37185 37.723519677182495 -122.47242112456001 (37.7235196771825, -122.47242112456)
151444 151444 208979 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 46 Cragmont Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   5992891.21268 2101728.13425 37.7505364203394 -122.467432335147 (37.7505364203394, -122.467432335147)
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)
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)
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)
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)
36584 36584 208984 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 354 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38 Width 3ft   5993109.71634 2095669.50335 37.7339135629453 -122.466236489538 (37.7339135629453, -122.466236489538)
52384 52384 208985 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 372 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     59 Width 3ft   5993126.32529 2095592.5648700001 37.7337032672843 -122.466173478533 (37.7337032672843, -122.466173478533)
69214 69214 208986 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 372 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 3ft   5993143.09775 2095558.09178 37.7336095804246 -122.46611298742701 (37.7336095804246, -122.466112987427)
179310 179310 208987 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 95 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 3ft   5993980.02644 2096844.0619400002 37.7371887859367 -122.46331278907499 (37.7371887859367, -122.463312789075)
74972 74972 208988 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 85 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 4ft   5993834.637730001 2096941.34521 37.7374475244853 -122.463822519421 (37.7374475244853, -122.463822519421)
147084 147084 208989 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 55 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 4ft   5993734.999890001 2097013.08627 37.7376387653037 -122.46417221806699 (37.7376387653037, -122.464172218067)
56324 56324 208990 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 51 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 4ft   5993670.13129 2097058.8329 37.7377606351295 -122.46439981849899 (37.7377606351295, -122.464399818499)
127109 127109 208991 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 45 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 4ft   5993638.39674 2097082.374 37.73782344378579 -122.46451124811199 (37.7378234437858, -122.464511248112)

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