sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
200 134567 1 15 99 Grove St 3 1 1 5   07/06/2011 12:00:00 AM 4 Width 4ft   6007561.6986 2111595.58464 37.778466176805296 -122.417399738421 (37.7784661768053, -122.417399738421)
203 134565 1 15 99 Grove St 1 1 1 5     15 Width 4ft   6007431.26589 2111583.6583 37.7784260904314 -122.41785010990299 (37.7784260904314, -122.417850109903)
205 134566 1 15 99 Grove St 2 1 1 5     14 Width 4ft   6007493.55732 2111589.9734900002 37.7784469358085 -122.417635067622 (37.7784469358085, -122.417635067622)
209 134568 1 15 99 Grove St 4 1 1 5   12/17/2009 12:00:00 AM 5 Width 4ft   6007669.37768 2111613.23365 37.778520694605795 -122.41702848568501 (37.7785206946058, -122.417028485685)
214 251244 1 15 99 Grove St 5 1 1 5   05/29/2013 12:00:00 AM       6007340.02606 2111591.01475 37.778441154342296 -122.41816626519301 (37.7784411543423, -122.418166265193)
422 23174 1 15 240 Van Ness Ave 1 1 1 5     5 3x3   6006908.21847 2111432.04348 37.777980343250796 -122.419648771078 (37.7779803432508, -122.419648771078)
79333 14628 1 15 460 McAllister St 1 1 1 5     20 3X3   6006936.4820313 2112240.9458517 37.7802029857658 -122.419608403425 (37.7802029857658, -122.419608403425)
83247 9951 1 15 95X Grove St 2 1 1 5     18 3X3   6007383.306516 2111592.002729 37.778446303098505 -122.418016611499 (37.7784463030985, -122.418016611499)
94107 9952 1 15 95X Grove St 3 1 1 5   07/06/2011 12:00:00 AM 3 3x3   6007383.306516 2111592.002729 37.778446303098505 -122.418016611499 (37.7784463030985, -122.418016611499)
101592 14098 1 15 1480X Market St 1 1 1 5     12 4x4   6007076.6773563 2110527.4337913003 37.7755059900951 -122.419001832587 (37.7755059900951, -122.419001832587)
102104 14627 1 15 410X McAllister St 2 1 1 5     35 3X3   6007165.245080001 2112272.29684 37.780301951255105 -122.41881922945299 (37.7803019512551, -122.418819229453)
108539 26896 1 15 460 McAllister St 2 1 1 5     20 3X3   6006936.4820313 2112240.9458517 37.7802029857658 -122.419608403425 (37.7802029857658, -122.419608403425)
113247 14103 1 15 1525 Market St 2 1 1 5     12 4X4   6006946.0284757 2110289.3486746997 37.774844907593 -122.419436884969 (37.774844907593, -122.419436884969)
113688 9953 1 15 95X Grove St 4 1 1 5   12/17/2009 12:00:00 AM 12 3X3   6007383.306516 2111592.002729 37.778446303098505 -122.418016611499 (37.7784463030985, -122.418016611499)
121181 9950 1 15 95X Grove St 1 1 1 5     18 3X3   6007383.306516 2111592.002729 37.778446303098505 -122.418016611499 (37.7784463030985, -122.418016611499)
122208 14099 1 15 1484 Market St 1 1 1 5     12 4X4   6007056.5524178 2110508.208095 37.7754520676647 -122.419070085744 (37.7754520676647, -122.419070085744)
122483 14102 1 15 1525 Market St 1 1 1 5     12 4X4   6006946.0284757 2110289.3486746997 37.774844907593 -122.419436884969 (37.774844907593, -122.419436884969)
Powered by Datasette · Query took 26.018ms · Data source: data.sfgov.org