Street_Tree_List

Data source: data.sfgov.org

446 rows where qSpecies = 103 sorted by XCoord

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord ▼ YCoord Latitude Longitude Location
1070 1070 19942 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY38 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
3884 3884 20320 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 101X Sunset Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
6027 6027 20016 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY48 0 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
6772 6772 20314 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 101X Sunset Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
7805 7805 19939 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY38 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
8002 8002 19938 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY38 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
8496 8496 20017 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY48 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
12003 12003 20316 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 101X Sunset Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
14348 14348 19941 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY38 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
14547 14547 19940 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY38 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
16276 16276 20315 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 101X Sunset Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
17047 17047 20318 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 101X Sunset Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
17109 17109 20319 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 101X Sunset Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
54495 54495 118438 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 5201 Anza St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5982520.38622 2111663.82262 37.7772127952946 -122.50403070229099 (37.7772127952946, -122.504030702291)
76683 76683 185931 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 2000 Sunset Blvd 74 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985001.315 2101504.3546 37.749463324703996 -122.494699314147 (37.749463324704, -122.494699314147)
174806 174806 185917 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 2000 Sunset Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 0ft   5985004.5736 2101420.7172 37.749233870008794 -122.494681880668 (37.7492338700088, -122.494681880668)
77244 77244 185929 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 2000 Sunset Blvd 72 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5985012.7201 2101493.4926 37.7494341681805 -122.494659074897 (37.7494341681805, -122.494659074897)
109893 109893 114409 Significant Tree 6 Eucalyptus globulus :: Blue Gum 103 500X ARBALLO DR 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
90554 90554 114400 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1X HIGUERA AVE 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     22 3x3   5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
92772 92772 114075 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 24 HIGUERA AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
108603 108603 114396 Permitted Site 1 Eucalyptus globulus :: Blue Gum 103 35 HIGUERA AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
113582 113582 114403 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1X HIGUERA AVE 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 3x3   5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
122260 122260 66251 Permitted Site 1 Eucalyptus globulus :: Blue Gum 103 35 HIGUERA AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/24/1990 12:00:00 AM     Permit Number 29352 5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
138466 138466 114076 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 24 HIGUERA AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
113956 113956 114069 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 2 HIGUERA AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     40     5988091.0 2090188.0 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801)
94946 94946 95436 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 2675 25th Ave 3 Unaccepted Street : Yard 14 Tree 1 Private 1     16     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
54108 54108 176348 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 0 Fuente Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26     5989603.79735 2090546.09261 37.7196430676648 -122.47798295295799 (37.7196430676648, -122.477982952958)
966 966 251417 Private 5 Eucalyptus globulus :: Blue Gum 103 418 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5990003.0 2112517.0 37.779992561868504 -122.478208632121 (37.7799925618685, -122.478208632121)
19139 19139 29600 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 900X Junipero Serra Blvd 9 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991176.92289 2091079.14193 37.7211978713578 -122.472584119478 (37.7211978713578, -122.472584119478)
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)
106936 106936 105441 Private 5 Eucalyptus globulus :: Blue Gum 103 425 WAWONA ST   unknown : Yard 19 Tree 1 Private 1           5991587.6 2097036.5 37.737579050883106 -122.471598439568 (37.7375790508831, -122.471598439568)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
175100 175100 207765 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 356 Santa Ana Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 3ft   5992543.86147 2094436.1305 37.7304943639181 -122.46810311696998 (37.7304943639181, -122.46810311697)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
3843 3843 253568 Significant Tree 6 Eucalyptus globulus :: Blue Gum 103 301X Sargent St 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5993018.0 2089140.0 37.7159798527116 -122.46607925705901 (37.7159798527116, -122.466079257059)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
158456 158456 207762 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 355 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 10ft   5993165.17049 2095669.26931 37.7339161197195 -122.46604475226499 (37.7339161197195, -122.466044752265)

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