Street_Tree_List

Data source: data.sfgov.org

446 rows where qSpecies = 103 sorted by rowid descending

✎ 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
189014 189014 209015 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 412 Baden St 3 Side Yard : Yard 17 Tree 1 Private 1     12     6000779.78636 2095479.1538 37.73383046469421 -122.439705146498 (37.7338304646942, -122.439705146498)
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)
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)
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)
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)
186405 186405 224262 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 91 Stanton St 2 : Yard 23 Tree 1 Private 1     22 Width 3ft   6000293.691000001 2103856.2070400002 37.7568041715846 -122.44198679486 (37.7568041715846, -122.44198679486)
186323 186323 224264 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 11 Germania St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6004254.57068 2108904.38845 37.770890184456796 -122.42864845406 (37.7708901844568, -122.42864845406)
186126 186126 246762 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 70 Waltham St 6 Front Yard : Yard 7 Tree 1 Private 1     38     6009259.9688 2098886.63063 37.743665689828 -122.41062704033101 (37.743665689828, -122.410627040331)
185838 185838 209018 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 33 Martha Ave 3 : Yard 23 Tree 1 Private 1     38     6000767.57935 2095529.42368 37.733967799282 -122.439750952539 (37.733967799282, -122.439750952539)
185592 185592 191731 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Hampshire St 3 Front Yard : Yard 7 Tree 1 Private 1     24     6009975.967759999 2107617.96239 37.76768009039721 -122.408767140702 (37.7676800903972, -122.408767140702)
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)
185207 185207 246760 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 70 Waltham St 4 Front Yard : Yard 7 Tree 1 Private 1     23     6009218.12342 2098889.2056 37.7436704139605 -122.410771913907 (37.7436704139605, -122.410771913907)
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)
183947 183947 208992 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 45 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 4ft   5993607.99739 2097104.1803400002 37.7378815660919 -122.46461793558001 (37.7378815660919, -122.46461793558)
183396 183396 176347 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 40 Teddy Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     29     6011214.18105 2087815.3375799998 37.7133755951756 -122.403091220704 (37.7133755951756, -122.403091220704)
183364 183364 247818 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1058 Jarboe Ave 1 Side Yard : Yard 17 Tree 1 Private 1     46     6009634.533480001 2096844.3676599998 37.738079072495395 -122.409187798594 (37.7380790724954, -122.409187798594)
183205 183205 245009 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1466 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 0ft   5999558.6674 2109145.6245 37.7712856788974 -122.44490898697701 (37.7712856788974, -122.444908986977)
182600 182600 209016 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 412 Baden St 4 Side Yard : Yard 17 Tree 1 Private 1     16     6000787.61929 2095495.57167 37.7338759901863 -122.43967924239901 (37.7338759901863, -122.439679242399)
182567 182567 246763 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 70 Waltham St 7 Front Yard : Yard 7 Tree 1 Private 1     27     6009290.72604 2098884.53398 37.74366165725821 -122.410520540796 (37.7436616572582, -122.410520540796)
182141 182141 209011 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 408 Baden St 3 Front Yard : Yard 7 Tree 1 Private 1     13     6000782.1941599995 2095354.33843 37.7334878877384 -122.439687876799 (37.7334878877384, -122.439687876799)
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)
181724 181724 224226 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1100 San Jose Ave 16 Front Yard : Yard 7 Tree 1 Private 1     13     6004846.937969999 2096712.6297900002 37.7374479705325 -122.42573153718 (37.7374479705325, -122.42573153718)
181562 181562 224233 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1100 San Jose Ave 23 Front Yard : Yard 7 Tree 1 Private 1     22     6004845.23458 2096693.0180000002 37.737394024725205 -122.42573603111 (37.7373940247252, -122.42573603111)
181159 181159 224265 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 58 Poppy Ln 1 Back Yard : Yard 13 Tree 1 Private 1     38     6002671.84671 2096513.9082400003 37.7367791753169 -122.433237644116 (37.7367791753169, -122.433237644116)
181129 181129 207771 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 50 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 10ft   5993253.43088 2097238.9026200003 37.7382310327445 -122.465853621172 (37.7382310327445, -122.465853621172)
181095 181095 247932 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1099 Esmeralda Ave 5 Side Yard : Yard 17 Tree 1 Private 1     11     6010369.906140001 2098762.7933799997 37.743387826290395 -122.406780401602 (37.7433878262904, -122.406780401602)
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)
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)
180599 180599 191725 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 950x Kansas St 6 Median : Yard 3 Tree 1 DPW 2     46     6011608.2265 2103816.01851 37.75733209161471 -122.40285390399201 (37.7573320916147, -122.402853903992)
179858 179858 224235 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1100 San Jose Ave 25 Front Yard : Yard 7 Tree 1 Private 1     17     6004831.6413199995 2096688.95275 37.7373820943173 -122.425782740103 (37.7373820943173, -122.425782740103)
179689 179689 176336 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 287 Hester Ave 9 Side Yard : Yard 17 Tree 1 Private 1     31     6012249.60162 2087766.47281 37.713299190589794 -122.39950899437001 (37.7132991905898, -122.39950899437)
179355 179355 207758 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 95 Kirkham St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     45     5994815.677630001 2105291.72467 37.7604320448236 -122.461035696659 (37.7604320448236, -122.461035696659)
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)
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)
178271 178271 176340 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 200x Mansell St 15 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   6011135.84107 2090535.2556900003 37.720839562571996 -122.403553239308 (37.720839562572, -122.403553239308)
178073 178073 224242 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1100 San Jose Ave 40 Front Yard : Yard 7 Tree 1 Private 1     5     6004773.2240699995 2096631.25513 37.7372203683314 -122.425980609816 (37.7372203683314, -122.425980609816)
177301 177301 245010 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1480 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 0ft   5999484.2143 2109133.9912 37.7712494874058 -122.44516568603999 (37.7712494874058, -122.44516568604)
177154 177154 224221 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1000 San Jose Ave 63 Front Yard : Yard 7 Tree 1 Private 1     15     6005093.2410699995 2097044.1609999998 37.7383721957242 -122.424903531393 (37.7383721957242, -122.424903531393)
176724 176724 138028 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1621 Octavia St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     49 Width 0ft   6004887.6482 2114917.9533 37.7874377625804 -122.426886970359 (37.7874377625804, -122.426886970359)
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)
176149 176149 209037 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 419 Baden St 2 Front Yard : Yard 7 Tree 1 Private 1     1     6000749.92806 2095352.54396 37.7334811239592 -122.43979930099701 (37.7334811239592, -122.439799300997)
175986 175986 207763 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 290 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     36 Width 10ft   5993266.97338 2095443.21542 37.7333013044925 -122.46567637377599 (37.7333013044925, -122.465676373776)
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)
175102 175102 224260 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 355 Buena Vista Ave East 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 3ft   6001102.84855 2107909.89342 37.7679806761809 -122.43947901285401 (37.7679806761809, -122.439479012854)
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)
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)
174300 174300 248219 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 70 Fair Ave 2 Side Yard : Yard 17 Tree 1 Private 1     38     6007128.325540001 2099340.74379 37.744792840734206 -122.418029950029 (37.7447928407342, -122.418029950029)
173688 173688 191721 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 1150x Tennessee St 7 Median : Yard 3 Tree 1 DPW 2     50     6015559.12531 2103608.85918 37.75698309171089 -122.389175557402 (37.7569830917109, -122.389175557402)
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)
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)
172652 172652 247821 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1201 Jarboe Ave 3 Front Yard : Yard 7 Tree 1 Private 1     8     6009717.95526 2096849.3331900002 37.7380973799798 -122.40889971695 (37.7380973799798, -122.40889971695)
172222 172222 201510 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1001 Innes Ave 8 Front Yard : Yard 7 Tree 1 Private 1     38     6018594.17439 2094891.11142 37.73321369166371 -122.378073969944 (37.7332136916637, -122.378073969944)
171861 171861 224261 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 355 Buena Vista Ave East 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   6001117.5941 2107921.40745 37.768013130033204 -122.439428835199 (37.7680131300332, -122.439428835199)
171841 171841 176342 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Mansell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6011455.5144 2090588.63485 37.721003982019504 -122.40245197087799 (37.7210039820195, -122.402451970878)
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)
170494 170494 209008 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 406 Baden St 1 Front Yard : Yard 7 Tree 1 Private 1     11     6000788.7045 2095325.02184 37.7334077617457 -122.439663267741 (37.7334077617457, -122.439663267741)
169544 169544 247921 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1098 Esmeralda Ave 6 Side Yard : Yard 17 Tree 1 Private 1     38     6010260.8237 2098716.17835 37.7432537274883 -122.407154297447 (37.7432537274883, -122.407154297447)
169268 169268 246758 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 70 Waltham St 2 Front Yard : Yard 7 Tree 1 Private 1     45     6009165.3759699995 2098887.8964 37.743663861508395 -122.41095421008801 (37.7436638615084, -122.410954210088)
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)
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)
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)
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)
166974 166974 209007 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 172 Kensington Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   5994745.50567 2098641.39451 37.7421678860404 -122.460796414937 (37.7421678860404, -122.460796414937)
166763 166763 247928 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1099 Esmeralda Ave 1 Side Yard : Yard 17 Tree 1 Private 1     22     6010393.74755 2098772.89885 37.7434169076795 -122.406698675702 (37.7434169076795, -122.406698675702)
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)
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)
165522 165522 209035 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 427 Baden St 1 Front Yard : Yard 7 Tree 1 Private 1     32     6000759.78323 2095371.55913 37.733533896164104 -122.43976659178101 (37.7335338961641, -122.439766591781)
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)
165255 165255 224249 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 500x 27th St 14 Median : Cutout 11 Tree 1 DPW 2     48 Width 4ft   6002852.0087 2100065.56768 37.7465414276517 -122.432868400457 (37.7465414276517, -122.432868400457)
165081 165081 207774 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 98 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 10ft   5993269.03182 2097018.73215 37.7376273996789 -122.465783688974 (37.7376273996789, -122.465783688974)
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)
164592 164592 191726 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 700 Missouri St 1 Front Yard : Yard 7 Tree 1 Private 1     14     6013632.69543 2103711.63212 37.757158302141 -122.395845128465 (37.757158302141, -122.395845128465)
164405 164405 191733 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Hampshire St 5 Front Yard : Yard 7 Tree 1 Private 1     25     6009990.5053900005 2107548.56259 37.7674903487254 -122.408711960091 (37.7674903487254, -122.408711960091)
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)
164095 164095 249920 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 358 Greenwich St 5 Back Yard : Yard 13 Tree 1 Private 1     35 Width 0ft   6011181.16541 2120413.994 37.8028824034529 -122.405499802075 (37.8028824034529, -122.405499802075)
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)
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)
162554 162554 224231 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1100 San Jose Ave 21 Front Yard : Yard 7 Tree 1 Private 1     23     6004851.9976 2096696.37519 37.7374036249796 -122.42571288706301 (37.7374036249796, -122.425712887063)
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)
161658 161658 209044 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 690 Mangels Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 10ft   5996811.85436 2095301.80777 37.7331168670328 -122.453410604043 (37.7331168670328, -122.453410604043)
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)
160736 160736 207773 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 80 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     58 Width 10ft   5993272.22832 2097088.94625 37.7378203744176 -122.465777737259 (37.7378203744176, -122.465777737259)
160722 160722 209027 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 36 Martha Ave 4 Front Yard : Yard 7 Tree 1 Private 1     10     6000763.850930001 2095573.2374 37.7340878893448 -122.439766982962 (37.7340878893448, -122.439766982962)
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)
159737 159737 224252 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 177 Powhattan Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     35 Width 3ft   6008209.41115 2098117.01266 37.741493532991 -122.41420518642299 (37.741493532991, -122.414205186423)
159705 159705 191732 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Hampshire St 4 Front Yard : Yard 7 Tree 1 Private 1     18     6009982.19315 2107558.06249 37.7675159677065 -122.408741381426 (37.7675159677065, -122.408741381426)
159119 159119 209012 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 410 Baden St 1 Front Yard : Yard 7 Tree 1 Private 1     24     6000789.00569 2095372.0781 37.7335369844496 -122.439665598801 (37.7335369844496, -122.439665598801)
158665 158665 191729 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Hampshire St 1 Front Yard : Yard 7 Tree 1 Private 1     24     6009963.10998 2107668.13664 37.7678171371844 -122.408815154618 (37.7678171371844, -122.408815154618)
158564 158564 209026 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 36 Martha Ave 3 Front Yard : Yard 7 Tree 1 Private 1     24     6000767.091 2095571.9190599998 37.7340844539158 -122.439755686569 (37.7340844539158, -122.439755686569)
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)
158274 158274 176343 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 450 Raymond Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     76     6008484.74111 2088383.4213400001 37.714782633086294 -122.412565284366 (37.7147826330863, -122.412565284366)
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)
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)
157431 157431 207769 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 40 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     40 Width 10ft   5993228.66009 2097329.84492 37.7384793085579 -122.46594587182899 (37.7384793085579, -122.465945871829)
157173 157173 209039 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 419 Baden St 4 Front Yard : Yard 7 Tree 1 Private 1     1     6000750.66308 2095345.5130200002 37.7334618604699 -122.439796255913 (37.7334618604699, -122.439796255913)
156972 156972 224267 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 2300 22nd St 3 Front Yard : Yard 7 Tree 1 Private 1     26     6011260.203430001 2103721.90369 37.7570542343818 -122.40405088815001 (37.7570542343818, -122.40405088815)
156854 156854 209023 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 34 Martha Ave 3 Front Yard : Yard 7 Tree 1 Private 1     20     6000780.47253 2095565.1582 37.7340666518368 -122.439708938014 (37.7340666518368, -122.439708938014)
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)

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