sf-trees

Data source: data.sfgov.org

Custom SQL query returning 14 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
733 221433 3 109 100x Guerrero St 6 11 1 2   07/15/2016 06:32:00 AM 1 Width 3ft   6005435.4614 2108218.9893400003 37.7690750036386 -122.42451495861201 (37.7690750036386, -122.424514958612)
4325 221461 3 109 300x Guerrero St 6 11 1 2   06/19/2015 10:37:00 AM 2 Width 3ft   6005500.86915 2106969.86586 37.7656489022957 -122.42419986763399 (37.7656489022957, -122.424199867634)
4386 221473 3 109 400x Guerrero St 6 11 1 2   04/29/2015 10:20:00 AM 1 Width 3ft   6005534.54232 2106397.63335 37.764079588928496 -122.424042702116 (37.7640795889285, -122.424042702116)
4431 221450 3 109 200x Guerrero St 6 11 1 2   02/09/2016 11:34:00 AM 1 Width 3ft   6005469.47774 2107557.31332 37.7672601204903 -122.424350229795 (37.7672601204903, -122.424350229795)
4499 221499 3 109 600x Guerrero St 6 11 1 2   02/28/2015 11:01:00 PM 2 Width 3ft   6005601.090469999 2105206.48742 37.760812740428904 -122.42372783238899 (37.7608127404289, -122.423727832389)
5135 152417 3 109 700x Guerrero St 6 11 1 2     0 Width 3ft   6005634.27087 2104624.16733 37.7592156991708 -122.423571674116 (37.7592156991708, -122.423571674116)
32169 221427 3 109 900x Guerrero St 6 11 1 2     6 Width 3ft   6005696.85287 2103501.5592 37.7561368116793 -122.42327543382099 (37.7561368116793, -122.423275433821)
48249 221525 3 109 1200x Guerrero St 6 11 1 2     4 Width 3ft   6005795.99168 2101720.64475 37.7512524272579 -122.422806016491 (37.7512524272579, -122.422806016491)
55100 221486 3 109 500x Guerrero St 6 11 1 2     3 Width 3ft   6005569.00136 2105791.30468 37.7624166992856 -122.423880400579 (37.7624166992856, -122.423880400579)
55774 221419 3 109 800x Guerrero St 6 11 1 2     6 Width 3ft   6005664.4202 2104015.7148700003 37.7575467328056 -122.423424147502 (37.7575467328056, -122.423424147502)
61658 221543 3 109 900x Guerrero St 6 11 1 2     8 Width 3ft   6005707.0284 2103306.91954 37.7556029507207 -122.42322640818999 (37.7556029507207, -122.42322640819)
129563 221535 3 109 1100x Guerrero St 6 11 1 2     4 Width 3ft   6005763.23809 2102308.0919 37.7528635735186 -122.42296102995199 (37.7528635735186, -122.422961029952)
137049 221516 3 109 1300x Guerrero St 6 11 1 2     9 Width 3ft   6005827.472999999 2101138.31675 37.749655264584 -122.42265577304701 (37.749655264584, -122.422655773047)
176764 221549 3 109 1000x Guerrero St 6 11 1 2     1 Width 3ft   6005728.89674 2102911.59468 37.7545187145683 -122.423122682192 (37.7545187145683, -122.423122682192)
Powered by Datasette · Query took 4.425ms · Data source: data.sfgov.org