sf-trees

Data source: data.sfgov.org

Custom SQL query returning 22 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1791 251711 3 124 902 Market St 3 8 1 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
25675 240946 2 124 192 Laidley St 3 1 1 1     7 Width 2ft   6004126.6518 2097259.6464 37.7389092249709 -122.42826087863199 (37.7389092249709, -122.428260878632)
42363 240915 2 124 315 Lexington St 3 1 1 1     1 Width 3ft   6006533.583380001 2104305.2413 37.7583907231708 -122.420438775123 (37.7583907231708, -122.420438775123)
48334 197414 2 124 1110 04th St 3 1 1 1     6 Width 5ft   6014981.739440001 2109803.00942 37.7739588520651 -122.391605444662 (37.7739588520651, -122.391605444662)
48402 240890 2 124 1201 Treat Ave 3 1 1 1     9 Width 4ft   6008720.4908300005 2101064.55739 37.749615532544 -122.412646362752 (37.749615532544, -122.412646362752)
63145 197385 2 124 1350 04th St 3 1 1 1     5 Width 5ft   6015094.6551 2108827.79856 37.7712874060154 -122.391146668097 (37.7712874060154, -122.391146668097)
63712 197401 2 124 1155 04th St 3 1 1 1     5 Width 5ft   6015056.142469999 2109498.92263 37.7731280268706 -122.391326808588 (37.7731280268706, -122.391326808588)
66327 240908 2 124 725 Florida St 3 1 1 1     10 Width 4ft   6009319.31515 2104845.25039 37.76003005686479 -122.410842580843 (37.7600300568648, -122.410842580843)
71098 240926 2 124 1200 Florida St 3 1 1 1     7 Width 3ft   6009479.18585 2101981.64475 37.752176202776 -122.410087494765 (37.752176202776, -122.410087494765)
72200 197422 2 124 1200 04th St 3 1 1 1     5 Width 5ft   6015001.02116 2109469.2789 37.7730435724386 -122.39151540903099 (37.7730435724386, -122.391515409031)
72493 197408 2 124 1101 04th St 3 1 1 1     4 Width 5ft   6015042.21783 2109774.95767 37.773885184987996 -122.391394276636 (37.773885184988, -122.391394276636)
103276 94983 1 124 480 ELLIS ST 3 1 1 1   12/14/2010 12:00:00 AM   3x3 Permit Number 54004 6008557.0 2113884.0 37.784805566420005 -122.414118544888 (37.78480556642, -122.414118544888)
126401 113639 6 124 1X Russ St 3 5 1 1           6009949.394180001 2111947.85897 37.7795674908256 -122.40916462626801 (37.7795674908256, -122.409164626268)
129742 240935 2 124 2500 Market St 3 1 1 1     7 Width 3ft   6001976.89611 2105831.81092 37.7623244756286 -122.43630704373001 (37.7623244756286, -122.43630704373)
133157 240928 2 124 3380 20th St 3 1 1 1     9 Width 3ft   6007637.32467 2104441.25017 37.75882630980679 -122.416631173298 (37.7588263098068, -122.416631173298)
134173 38980 1 124 300x San Bruno Ave 3 1 1 1 1 06/30/2001 12:00:00 AM 6 3x3 Permit Number 40762 6010859.20416 2106814.33172 37.765522934268205 -122.40565551069099 (37.7655229342682, -122.405655510691)
134685 197394 2 124 1255 04th St 3 1 1 1     4 Width 5ft   6015074.87374 2109163.38918 37.7722077659022 -122.391238555416 (37.7722077659022, -122.391238555416)
134957 197436 2 124 1300 04th St 3 1 1 1     5 Width 5ft   6015031.80159 2108941.72055 37.7715967224486 -122.391372048095 (37.7715967224486, -122.391372048095)
163397 240513 2 124 301 Florida St 3 1 1 1     8 Width 3ft   6009217.99202 2106783.58967 37.765346611393205 -122.411329944146 (37.7653466113932, -122.411329944146)
163979 36875 1 124 2400 Divisadero St 3 1 1 1 1 05/26/1998 12:00:00 AM 6   Permit Number 39539 6000811.564809999 2116611.03172 37.791855202492705 -122.44111086330099 (37.7918552024927, -122.441110863301)
168717 197444 2 124 577 Nelson Rising Ln 3 1 1 1     4 Width 5ft   6013653.6839 2108052.2415 37.7690778293104 -122.396076725459 (37.7690778293104, -122.396076725459)
177644 96393 1 124 800 Tennessee St 3 1 1 1   05/17/2011 12:00:00 AM 4 3x3 Permit Number 767136 6015446.34816 2105205.82612 37.761361768441205 -122.389677121926 (37.7613617684412, -122.389677121926)
Powered by Datasette · Query took 4.52ms · Data source: data.sfgov.org