sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
92394 115737 6 6 9x Yerba Buena Ave 1 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776557 5993642.277480001 2097056.1949900002 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033)
85354 116746 2 37 9x BLANKEN AVE 1 1 1 1       3x3   6011671.0 2087411.0 37.71229086541071 -122.40148388608 (37.7122908654107, -122.40148388608)
88764 116749 2 37 9x BLANKEN AVE 4 1 1 1       3x3   6011671.0 2087411.0 37.71229086541071 -122.40148388608 (37.7122908654107, -122.40148388608)
108617 116747 2 37 9x BLANKEN AVE 2 1 1 1       3x3   6011671.0 2087411.0 37.71229086541071 -122.40148388608 (37.7122908654107, -122.40148388608)
120023 116748 2 37 9x BLANKEN AVE 3 1 1 1       3x3   6011671.0 2087411.0 37.71229086541071 -122.40148388608 (37.7122908654107, -122.40148388608)
72210 16475 3 114 9X Newhall St 9 1 1 2     18 3X3   6018697.204870099 2097076.1109207 37.73921894851821 -122.37786936428301 (37.7392189485182, -122.377869364283)
90238 16471 1 114 9X Newhall St 5 1 1 1     3 3X3   6018697.204870099 2097076.1109207 37.73921894851821 -122.37786936428301 (37.7392189485182, -122.377869364283)
96388 16476 1 114 9X Newhall St 10 1 1 1     12 3X3   6018697.204870099 2097076.1109207 37.73921894851821 -122.37786936428301 (37.7392189485182, -122.377869364283)
115131 16473 3 114 9X Newhall St 7 1 1 2     12 3X3   6018697.204870099 2097076.1109207 37.73921894851821 -122.37786936428301 (37.7392189485182, -122.377869364283)
118199 16470 3 36 9X Newhall St 4 1 1 2     12 3X3   6018697.204870099 2097076.1109207 37.73921894851821 -122.37786936428301 (37.7392189485182, -122.377869364283)
140227 16472 3 114 9X Newhall St 6 1 1 2     18 3X3   6018697.204870099 2097076.1109207 37.73921894851821 -122.37786936428301 (37.7392189485182, -122.377869364283)
142877 16478 3 155 9X Newhall St 12 1 1 2   05/16/1997 12:00:00 AM 6 3X3   6018697.204870099 2097076.1109207 37.73921894851821 -122.37786936428301 (37.7392189485182, -122.377869364283)
96198 13301 3 60 9X Lyell St 1 11 1 2     18 6   6003085.685949201 2094681.4720202 37.7317711908882 -122.43167603243099 (37.7317711908882, -122.431676032431)
138487 13304 3 60 9X Lyell St 4 11 1 2     12 15   6003085.685949201 2094681.4720202 37.7317711908882 -122.43167603243099 (37.7317711908882, -122.431676032431)
141679 13302 3 60 9X Lyell St 2 11 1 2     12 10   6003085.685949201 2094681.4720202 37.7317711908882 -122.43167603243099 (37.7317711908882, -122.431676032431)
142098 13303 3 60 9X Lyell St 3 11 1 2     18 15   6003085.685949201 2094681.4720202 37.7317711908882 -122.43167603243099 (37.7317711908882, -122.431676032431)
97285 102172 1 18 9X Hattie St 2 1 1 1 1 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769765 6000621.0 2105580.9 37.7615584024391 -122.440978567809 (37.7615584024391, -122.440978567809)
143029 102171 1 18 9X Hattie St 1 1 1 1 1 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769765 6000621.0 2105580.9 37.7615584024391 -122.440978567809 (37.7615584024391, -122.440978567809)
23018 12977 3 22 9X Castro St 2 1 1 2   03/26/1990 12:00:00 AM 4 3X3   6002070.87849 2108590.79545 37.7699053099025 -122.436179442539 (37.7699053099025, -122.436179442539)
139866 115801 2 103 9M CAIRE TER 1 7 1 1           6012720.0 2101959.0 37.7522951385919 -122.398878598484 (37.7522951385919, -122.398878598484)
81662 115444 2 5 99x Vandewater St 5 1 1 1       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249)
97297 115442 2 5 99x Vandewater St 3 1 1 1       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249)
112326 115441 2 5 99x Vandewater St 2 1 1 1       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249)
113661 115440 2 5 99x Vandewater St 1 1 1 1       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249)
115493 115443 2 5 99x Vandewater St 4 1 1 1       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249)
2733 253189 2 15 99x The Embarcadero 12 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2735 253188 2 15 99x The Embarcadero 11 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2737 253186 2 15 99x The Embarcadero 9 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2738 253184 2 15 99x The Embarcadero 7 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2739 253185 2 15 99x The Embarcadero 8 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2741 253190 2 15 99x The Embarcadero 13 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2744 253187 2 15 99x The Embarcadero 10 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
77511 121374 2 161 99x Santa Marina St 2 1 1 1       3x3   6006202.0 2097575.0 37.73989232614821 -122.421107660096 (37.7398923261482, -122.421107660096)
98900 121373 2 161 99x Santa Marina St 1 1 1 1       3x3   6006202.0 2097575.0 37.73989232614821 -122.421107660096 (37.7398923261482, -122.421107660096)
109131 121376 2 161 99x Santa Marina St 4 1 1 1       3x3   6006202.0 2097575.0 37.73989232614821 -122.421107660096 (37.7398923261482, -122.421107660096)
120908 121375 2 161 99x Santa Marina St 3 1 1 1       3x3   6006202.0 2097575.0 37.73989232614821 -122.421107660096 (37.7398923261482, -122.421107660096)
41263 218719 3 37 99x San Marcos Ave 1 11 1 2     5 Width 5ft   5993701.46816 2100309.93296 37.7466891448909 -122.464527467374 (37.7466891448909, -122.464527467374)
42882 211250 3 3 99x San Marcos Ave 9 11 1 2     33 Width 5ft   5993746.09289 2100276.06203 37.7465987162755 -122.464370702046 (37.7465987162755, -122.464370702046)
43117 219165 3 14 99x San Marcos Ave 8 11 1 2     7 Width 5ft   5993760.22324 2100276.5052799997 37.7466007478231 -122.46432187335199 (37.7466007478231, -122.464321873352)
44102 209213 3 22 99x San Marcos Ave 23 11 1 2     2 Width 5ft   5993777.82606 2100247.64237 37.7465225122089 -122.46425891004101 (37.7465225122089, -122.464258910041)
47921 211249 3 3 99x San Marcos Ave 4 11 1 2     23 Width 5ft   5993726.26019 2100287.2096700002 37.74662818164779 -122.464440090141 (37.7466281816478, -122.464440090141)
56613 211254 3 3 99x San Marcos Ave 15 11 1 2     31 Width 5ft   5993790.37609 2100225.91603 37.7464635805444 -122.46421393671899 (37.7464635805444, -122.464213936719)
60137 209212 3 22 99x San Marcos Ave 22 11 1 2     2 Width 5ft   5993771.94389 2100232.96399 37.746481870051106 -122.4642781843 (37.7464818700511, -122.4642781843)
60262 219167 3 14 99x San Marcos Ave 13 11 1 2     8 Width 5ft   5993768.02883 2100241.187 37.7465042226907 -122.464292318936 (37.7465042226907, -122.464292318936)
61181 211251 3 3 99x San Marcos Ave 10 11 1 2     14 Width 5ft   5993753.32003 2100266.28903 37.746572298679794 -122.464345002125 (37.7465722986798, -122.464345002125)
74481 218721 3 37 99x San Marcos Ave 3 11 1 2     7 Width 5ft   5993716.07745 2100297.78462 37.746656630797794 -122.464476068412 (37.7466566307978, -122.464476068412)
75541 209208 3 22 99x San Marcos Ave 18 11 1 2     3 Width 5ft   5993802.83706 2100253.03783 37.7465387683529 -122.46417281704399 (37.7465387683529, -122.464172817044)
76824 219162 3 14 99x San Marcos Ave 5 11 1 2     6 Width 5ft   5993732.15666 2100284.86554 37.74662208515711 -122.46441953075501 (37.7466220851571, -122.464419530755)
123719 209209 3 22 99x San Marcos Ave 19 11 1 2     3 Width 5ft   5993795.21392 2100243.94669 37.746513367011 -122.464198516942 (37.746513367011, -122.464198516942)
134757 209210 3 22 99x San Marcos Ave 20 11 1 2     1 Width 5ft   5993788.41941 2100238.90873 37.746499142429705 -122.464221645739 (37.7464991424297, -122.464221645739)
147824 218720 3 37 99x San Marcos Ave 2 11 1 2     5 Width 5ft   5993709.38363 2100297.55504 37.746655614559295 -122.464499198102 (37.7466556145593, -122.464499198102)
153512 219166 3 14 99x San Marcos Ave 12 11 1 2     8 Width 5ft   5993758.91368 2100249.51951 37.7465265762511 -122.46432444273 (37.7465265762511, -122.46432444273)
154163 219163 3 14 99x San Marcos Ave 6 11 1 2     6 Width 5ft   5993739.16637 2100264.73593 37.746567218412 -122.46439383083599 (37.746567218412, -122.464393830836)
156535 219164 3 14 99x San Marcos Ave 7 11 1 2     6 Width 5ft   5993746.9601 2100281.9643 37.7466149724013 -122.464368131807 (37.7466149724013, -122.464368131807)
157795 209207 3 22 99x San Marcos Ave 17 11 1 2     3 Width 5ft   5993815.86849 2100254.24474 37.7465428332992 -122.46412784372801 (37.7465428332992, -122.464127843728)
160858 211253 3 3 99x San Marcos Ave 14 11 1 2     25 Width 5ft   5993783.32 2100243.82658 37.7465123516796 -122.46423963577 (37.7465123516796, -122.46423963577)
178018 209211 3 22 99x San Marcos Ave 21 11 1 2     2 Width 5ft   5993782.2667 2100229.04683 37.7464717095186 -122.46424220511601 (37.7464717095186, -122.464242205116)
184665 211252 3 3 99x San Marcos Ave 11 11 1 2     28 Width 5ft   5993772.95985 2100263.65639 37.7465662021668 -122.464276899165 (37.7465662021668, -122.464276899165)
144546 33745 1 37 99x SAN JOSE AVE 6 1 1 1   12/11/1996 12:00:00 AM 10 4x4 Permit Number 37802 6006338.0 2102697.0 37.7539638411405 -122.421001003808 (37.7539638411405, -122.421001003808)
166 251230 2 55 99x Ogden Ave 2 1 1 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
167 251232 2 55 99x Ogden Ave 1 1 1 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
3258 253374 2 55 99x Ogden Ave 3 1 1 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
129004 108871 7 17 99x OAKWOOD ST 1 13 1 1           6005305.0 2104962.0 37.760124716943295 -122.424734485609 (37.7601247169433, -122.424734485609)
1384 251515 6 3 99x Mountview Ct 1 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1409 251514 6 3 99x Mountview Ct 2 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
13137 13326 3 2 99x Mansell St 2 1 1 2     6 3X3   6011657.72731 2090650.48596 37.72118509918629 -122.40175732193799 (37.7211850991863, -122.401757321938)
93628 13325 3 11 99x Mansell St 1 1 1 2   06/10/1992 12:00:00 AM 12 4x9   6004718.9472012 2089729.3577775 37.7182662183542 -122.42567717675699 (37.7182662183542, -122.425677176757)
9827 173704 1 11 99x Majestic Ave 2 1 1 1 1     3x3   5997184.0 2089426.0 37.7170046100656 -122.451700294591 (37.7170046100656, -122.451700294591)
9830 60472 1 11 99x Majestic Ave 1 1 1 1 1 11/24/1982 12:00:00 AM   3x3 Permit Number 20066 5997184.0 2089426.0 37.7170046100656 -122.451700294591 (37.7170046100656, -122.451700294591)
65538 110519 2 44 99x JULIAN AVE 3 1 1 1     1 3x3   6006400.0 2107588.0 37.7673968795345 -122.421133861104 (37.7673968795345, -122.421133861104)
95125 110520 2 44 99x JULIAN AVE 4 1 1 1     1 3x3   6006400.0 2107588.0 37.7673968795345 -122.421133861104 (37.7673968795345, -122.421133861104)
113014 110518 2 44 99x JULIAN AVE 2 1 1 1     1 3x3   6006400.0 2107588.0 37.7673968795345 -122.421133861104 (37.7673968795345, -122.421133861104)
114259 110522 2 44 99x JULIAN AVE 6 1 1 1     1 3x3   6006400.0 2107588.0 37.7673968795345 -122.421133861104 (37.7673968795345, -122.421133861104)
114942 110521 2 44 99x JULIAN AVE 5 1 1 1     1 3x3   6006400.0 2107588.0 37.7673968795345 -122.421133861104 (37.7673968795345, -122.421133861104)
115187 110517 2 44 99x JULIAN AVE 1 1 1 1     1 3x3   6006400.0 2107588.0 37.7673968795345 -122.421133861104 (37.7673968795345, -122.421133861104)
53479 108406 2 2 99x Hyde St 2 1 1 1   12/31/2015 12:00:00 AM 12 3x3 Permit Number 773269 6008120.84483 2112658.906 37.7814172463574 -122.41554073723302 (37.7814172463574, -122.415540737233)
135927 108405 2 2 99x Hyde St 1 1 1 1   12/31/2015 12:00:00 AM 11 3x3 Permit Number 773269 6008118.29339 2112682.65315 37.7814823069089 -122.41555124581001 (37.7814823069089, -122.41555124581)
151164 108408 2 2 99x Hyde St 4 1 1 1   12/31/2015 12:00:00 AM 11 3x3 Permit Number 773269 6008126.98045 2112612.39837 37.7812898924571 -122.41551621722601 (37.7812898924571, -122.415516217226)
170033 108407 2 2 99x Hyde St 3 1 1 1   12/31/2015 12:00:00 AM 12 3x3 Permit Number 773269 6008123.88182 2112634.14044 37.7813494167874 -122.415528476779 (37.7813494167874, -122.415528476779)
182575 108410 2 2 99x Hyde St 6 1 1 1   12/31/2015 12:00:00 AM 10 3x3 Permit Number 773269 6008131.8663 2112579.02445 37.781198530314995 -122.41549695101801 (37.781198530315, -122.415496951018)
184627 108409 2 2 99x Hyde St 5 1 1 1   12/31/2015 12:00:00 AM 13 3x3 Permit Number 773269 6008129.59407 2112591.6747 37.78123313714521 -122.41550570771601 (37.7812331371452, -122.415505707716)
88315 108412 2 134 99x HYDE ST 8 1 1 1   12/31/2015 12:00:00 AM   3x3 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338)
92393 108411 2 134 99x HYDE ST 7 1 1 1   12/31/2015 12:00:00 AM   3x3 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338)
107281 108413 2 134 99x HYDE ST 9 1 1 1   12/31/2015 12:00:00 AM   3x3 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338)
112409 108414 2 134 99x HYDE ST 10 1 1 1   12/31/2015 12:00:00 AM   3x3 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338)
91188 111312 2 176 99x GILROY ST 3 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
96975 111311 2 176 99x GILROY ST 2 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
123880 111310 2 176 99x GILROY ST 1 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
49231 114226 6 140 99x FONT BLVD 2 2 1 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
79797 114240 6 60 99x FONT BLVD 16 2 1 1           5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
80545 114228 6 140 99x FONT BLVD 4 2 1 1     7     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
86013 114235 6 140 99x FONT BLVD 11 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105010 114230 6 140 99x FONT BLVD 6 2 1 1     30     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105245 114225 6 60 99x FONT BLVD 1 2 1 1     48     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105541 114227 6 140 99x FONT BLVD 3 2 1 1     16     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
112189 114231 6 140 99x FONT BLVD 7 2 1 1     10     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
117729 114237 6 140 99x FONT BLVD 13 2 1 1     14     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
125709 114234 6 140 99x FONT BLVD 10 2 1 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
128194 114232 6 140 99x FONT BLVD 8 2 1 1     15     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
128290 114229 6 140 99x FONT BLVD 5 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
138891 114238 6 140 99x FONT BLVD 14 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
Powered by Datasette · Query took 90.174ms · Data source: data.sfgov.org