sf-trees

Data source: data.sfgov.org

Custom SQL query returning 67 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
90 241179 1 31 300 Duboce Ave 2 7 1 1   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004783.47466 2108409.88584 37.769562318364 -122.426783739481 (37.769562318364, -122.426783739481)
3582 253484 4 31 1x Gordon St 2 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
6292 87392 1 31 3322 Fillmore St 2 1 1 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002333.63287 2119648.2941900003 37.800281314083705 -122.43606195061199 (37.8002813140837, -122.436061950612)
23598 179958 2 31 162 Tunnel Ave 2 1 1 1     14 Width 3ft   6011915.65824 2087516.33041 37.7125937299935 -122.40064566366999 (37.7125937299935, -122.40064566367)
24481 117708 2 31 4001 Clement St 2 9 1 1     7 Width 7ft   5983029.04687 2113077.7485700003 37.7811249212832 -122.50237578006501 (37.7811249212832, -122.502375780065)
24952 34654 1 31 2000 Kirkham St 2 1 1 1 1 07/28/1997 12:00:00 AM 3   Permit Number 38332 5988619.0903 2105142.8889 37.7596648557466 -122.482455667505 (37.7596648557466, -122.482455667505)
26722 136742 2 31 2900 Broderick St 2 9 1 1     11 Width 4ft   6000053.33945 2118542.13589 37.79711428765071 -122.443873120143 (37.7971142876507, -122.443873120143)
27219 215426 2 31 15 Fairfield Way 2 1 1 1     7 Width 3ft   5993822.27885 2092914.3969599998 37.7263898041365 -122.463573079846 (37.7263898041365, -122.463573079846)
27397 241185 2 31 3781 Cesar Chavez St 2 1 1 1     11 Width 4ft   6005371.2767199995 2100474.34138 37.7478063924621 -122.424186102634 (37.7478063924621, -122.424186102634)
28815 182351 2 31 1501 35th Ave 2 2 1 1     10 Width 0ft   5985257.4301 2104935.3862 37.758898980602005 -122.49406651392 (37.758898980602, -122.49406651392)
33234 215420 2 31 2085 09th Ave 2 2 1 1     7 Width 3ft   5993528.81827 2101394.66819 37.7496575974161 -122.46520324492799 (37.7496575974161, -122.465203244928)
34503 215417 2 31 286 Orizaba Ave 2 10 1 1     12     5994025.97554 2088461.57938 37.7141751725286 -122.46254606394699 (37.7141751725286, -122.462546063947)
39697 241201 2 31 26 Carl St 2 1 1 1     11 Width 4ft   5998490.815219999 2107264.4937400003 37.7660595705173 -122.44846722318898 (37.7660595705173, -122.448467223189)
48125 36793 1 31 1350 Donner Ave 2 1 1 1   05/26/1998 12:00:00 AM 8 3x3 Permit Number 39527 6015250.697000001 2090820.757 37.721852482589796 -122.38934923747601 (37.7218524825898, -122.389349237476)
50744 197985 2 31 669 Mississippi St 2 4 1 1     9 Width 3ft   6014155.897999999 2104063.80675 37.758154390328 -122.394060332116 (37.758154390328, -122.394060332116)
50962 179971 2 31 160 Baltimore Way 2 2 1 1     8 Width 6ft   6002384.15556 2086207.4195700001 37.708463540423104 -122.43349600315001 (37.7084635404231, -122.43349600315)
55615 182655 2 31 2618 Ortega St 2 2 1 1     10 Width 0ft   5985877.3992 2102330.3619999997 37.7517825562574 -122.49173063243201 (37.7517825562574, -122.491730632432)
59569 115612 1 31 1400 16th St 2 1 1 1     7 4x4   6012209.3182 2107055.3618 37.7662601539356 -122.401002678345 (37.7662601539356, -122.401002678345)
61689 42736 1 31 2155 Bay Shore Blvd 2 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
62417 52600 1 31 1360WASHINGTON Jones St 2 1 1 1   02/03/2006 12:00:00 AM 9   Permit Number 48694 6008503.01401 2117214.59757 37.793947543601 -122.41454108323 (37.793947543601, -122.41454108323)
64095 179955 2 31 78 Sala Ter 2 9 1 1     16 Width 6ft   5998862.1125 2088471.1679599998 37.7144788232093 -122.445831259031 (37.7144788232093, -122.445831259031)
66988 179969 2 31 623 Goettingen St 2 1 1 1     4 Width 4ft   6010613.39722 2091824.0219599998 37.7243490517445 -122.40544989510599 (37.7243490517445, -122.405449895106)
69093 114917 1 31 86 Carr St 2 1 1 1   01/04/2016 12:00:00 AM 8   Permit 774770 6012955.87899 2090602.59506 37.721125958889104 -122.397266597771 (37.7211259588891, -122.397266597771)
71330 179970 2 31 307 Athens St 2 1 1 1     7 Width 4ft   6004288.05392 2091472.8528 37.7230291158735 -122.42729072060101 (37.7230291158735, -122.427290720601)
73993 241200 2 31 26 Carl St 2 1 1 1     10 Width 4ft   5998502.5017 2107263.12139 37.7660564705643 -122.448426703328 (37.7660564705643, -122.448426703328)
74241 241197 2 31 285 Mullen Ave 2 1 1 1     8 Width 3ft   6010385.48006 2100017.65971 37.7468342873856 -122.406814971529 (37.7468342873856, -122.406814971529)
78446 16228 3 31 564X Monterey Blvd 2 11 1 2   02/02/2003 12:00:00 AM 12 5   5998342.280841901 2094738.2735002 37.731657141982204 -122.44807897208 (37.7316571419822, -122.44807897208)
78727 16285 3 31 700X Monterey Blvd 2 11 1 2   02/02/2003 12:00:00 AM 12 G   5997448.036427 2094744.2173306 37.7316223027997 -122.45117096626998 (37.7316223027997, -122.45117096627)
78838 16202 3 31 500X Monterey Blvd 2 11 1 2   02/02/2003 12:00:00 AM 12 5   5998782.1299536 2094714.7967047 37.7316178141427 -122.446556643647 (37.7316178141427, -122.446556643647)
80956 34053 1 31 375 Alabama St 2 1 1 1 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
83463 49161 1 31 804 Faxon Ave 2 1 1 1 1 01/23/2003 12:00:00 AM     Permit Number 46282 5994926.32764665 2093370.69967083 37.7277062535492 -122.45978949774499 (37.7277062535492, -122.459789497745)
87474 16273 3 31 692X Monterey Blvd 2 11 1 2   02/02/2003 12:00:00 AM 12 3X3   5997509.7184819 2094751.8939266002 37.7316469123248 -122.450958273614 (37.7316469123248, -122.450958273614)
93667 49070 1 31 1970 Ocean Ave 2 1 1 1 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
94982 39859 1 31 70 13th St 2 1 1 1   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.41483963035499 (37.7696326766808, -122.414839630355)
98175 44261 1 31 300 Duboce Ave 2 1 1 1   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.769656772496795 -122.426413224583 (37.7696567724968, -122.426413224583)
98438 117606 1 31 420 Castro St 2 1 1 1     6 3X3   6002292.2454566 2105806.2278627 37.7622721434766 -122.43521453981701 (37.7622721434766, -122.435214539817)
98537 34079 1 31 240 Shotwell St 2 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
101783 47561 1 31 580 Capp St 2 1 1 1 1 05/14/2002 12:00:00 AM     Permit Number 45422 6007250.69827751 2103936.71356757 37.7574192165742 -122.41793254418002 (37.7574192165742, -122.41793254418)
105310 42309 1 31 249 Edna St 2 1 1 1   06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377)
106308 34076 1 31 2851X 16th St 2 1 1 1 1 12/19/2011 12:00:00 AM 6 3x3 Permit Number 768574 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
108893 44008 1 31 2701X 17th St 2 1 1 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 2 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
113895 52312 1 31 4400HOFFMAN 24th St 2 1 1 1   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281)
113940 107411 1 31 3634 20th St 2 10 1 1       3x3   6006068.0 2104353.0 37.7584956093101 -122.422052363883 (37.7584956093101, -122.422052363883)
116911 109315 2 31 1516 BROADWAY 2 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
118491 106781 1 31 1177 De Haro St 2 5 1 1   06/03/2014 12:00:00 AM     Permit Number 773142 6012276.4 2102941.5 37.7549681417933 -122.400481655091 (37.7549681417933, -122.400481655091)
124789 88372 1 31 45 Sheridan St 2 1 1 1   07/20/2005 12:00:00 AM   2x3 Permit Number 48123 6009306.0 2109414.0 37.77257404455771 -122.411211370961 (37.7725740445577, -122.411211370961)
128240 215433 2 31 20 Lakewood Ave 2 1 1 1     9 Width 3ft   5993594.89235 2092910.6701200001 37.726366466724 -122.464358867875 (37.726366466724, -122.464358867875)
128411 52305 1 31 715 Buena Vista Ave West 2 1 1 1   07/29/2016 12:00:00 AM 3   Permit Number 48465 5999876.8 2107852.1 37.7677521370965 -122.443715612896 (37.7677521370965, -122.443715612896)
132120 241214 2 31 2801 17th St 2 1 1 1     12 Width 3ft   6009008.65245 2106350.93983 37.764146911276704 -122.41202342575899 (37.7641469112767, -122.412023425759)
135775 179965 2 31 86 Arago St 2 9 1 1     9     5999606.18552 2093002.3803299998 37.726962952855104 -122.443584762453 (37.7269629528551, -122.443584762453)
135983 241218 2 31 4130 Cesar Chavez St 2 9 1 1     12 Width 6ft   6003089.92025 2100398.1705 37.7474681682179 -122.43206947603399 (37.7474681682179, -122.432069476034)
136649 141332 2 31 1324 HAYES ST 2 10 1 1     6 Width 0ft   6001489.2623 2110460.5875 37.7750062304087 -122.43832521117099 (37.7750062304087, -122.438325211171)
143287 44011 1 31 405X Florida St 2 1 1 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 2 on Florida 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
145835 80165 1 31 415-421 South Van Ness Ave 2 1 1 1 1 12/23/2011 12:00:00 AM 10 3x3 Permit Number 768604 6007434.83105048 2107262.94030089 37.766562624561 -122.417531473498 (37.766562624561, -122.417531473498)
157611 136748 2 31 165 Marina Blvd 2 9 1 1     4 Width 7ft   6002698.42353 2121575.97678 37.80559494132721 -122.43493757052299 (37.8055949413272, -122.434937570523)
157670 241194 2 31 699 Hampshire St 2 1 1 1     7 Width 3ft   6010150.13435 2105098.1288099997 37.7607709543248 -122.4079869968 (37.7607709543248, -122.4079869968)
158174 241187 2 31 45 Hoff St 2 1 1 1     8 Width 6ft   6006570.58835 2106391.73918 37.7641218444722 -122.420458896575 (37.7641218444722, -122.420458896575)
160016 241207 2 31 1142 South Van Ness Ave 2 1 1 1     10 Width 3ft   6007609.4952 2103000.12596 37.754867747762795 -122.41662533218701 (37.7548677477628, -122.416625332187)
160717 197991 2 31 3419 Jennings St 2 2 1 1     13     6013294.96544 2089742.68292 37.7187836844998 -122.396034235213 (37.7187836844998, -122.396034235213)
163040 82715 1 31 1379 Quesada Ave 2 1 1 1   07/08/2009 12:00:00 AM 11 3x3 Permit Number 52465 6016442.9825 2093699.9014 37.7298240779238 -122.385428311894 (37.7298240779238, -122.385428311894)
164851 247521 2 31 1101 Waller St 2 17 1 1     5     6000007.86979 2108477.01107 37.7694754609529 -122.443307149811 (37.7694754609529, -122.443307149811)
166118 215413 2 31 423 Flood Ave 2 9 1 1     12 Width 6ft   5997941.5079 2094069.28168 37.7297973308762 -122.44941633348999 (37.7297973308762, -122.44941633349)
173453 106777 1 31 1177 De Haro St 2 5 1 1   06/03/2014 12:00:00 AM 5   Permit Number 773142 6012265.00001 2102937.69671 37.7549570630325 -122.400520812589 (37.7549570630325, -122.400520812589)
178056 136744 2 31 2906 Broderick St 2 9 1 1     11 Width 4ft   6000047.06944 2118581.72583 37.7972226334754 -122.44389766175101 (37.7972226334754, -122.443897661751)
181600 241204 2 31 2399 Folsom St 2 1 1 1     7 Width 4ft   6008220.32471 2104519.20022 37.759073114347295 -122.414620398932 (37.7590731143473, -122.414620398932)
187402 179964 2 31 85 South Hill Blvd 2 2 1 1     5 Width 4ft   6002952.82685 2087126.8782400002 37.7110204227269 -122.431596206017 (37.7110204227269, -122.431596206017)
189124 179961 2 31 299 Lathrop Ave 2 1 1 1     5 Width 3ft   6012198.832140001 2086842.9214 37.7107604718955 -122.399619668515 (37.7107604718955, -122.399619668515)
Powered by Datasette · Query took 4.822ms · Data source: data.sfgov.org