sf-trees

Data source: data.sfgov.org

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5618 87403 3 35 1300 Webster St 8 11 1 2   04/21/2008 12:00:00 AM 10 3x3   6003687.1999 2113392.3659 37.7831809343135 -122.430931353807 (37.7831809343135, -122.430931353807)
5957 28643 3 35 1300 Webster St 5 11 1 2     10 20   6003700.2631 2113325.6745 37.7829985565916 -122.43088139933201 (37.7829985565916, -122.430881399332)
23893 238011 2 35 170 Upper Ter 4 1 1 1     10 Width 4ft   5999678.6983900005 2106620.27376 37.7643585496334 -122.444312287003 (37.7643585496334, -122.444312287003)
26502 196418 2 35 74 Langton St 5 1 1 1     10 Width 3ft   6010052.79507 2110841.7577299997 37.7765361885308 -122.408728861943 (37.7765361885308, -122.408728861943)
38829 248392 2 35 707 Cole St 1 1 1 1     10 Width 0ft   5997906.1336 2108119.2199 37.7683729841331 -122.450551136272 (37.7683729841331, -122.450551136272)
45325 142241 2 35 500 Linden St 1 1 1 1     10 Width 0ft   6004960.5581 2110752.4077 37.776004325764205 -122.42633802213601 (37.7760043257642, -122.426338022136)
46066 67709 1 35 87 Stillman St 1 1 1 1   11/19/1992 12:00:00 AM 10   Permit Number 31320 6013781.91426 2112762.09602 37.7820171606904 -122.395963274202 (37.7820171606904, -122.395963274202)
65666 135911 2 35 400 Vallejo St 4 2 1 1     10     6011511.78534 2119057.5389799997 37.7991763890443 -122.404260153176 (37.7991763890443, -122.404260153176)
73742 178960 2 35 1323 Bacon St 1 1 1 1     10 Width 2ft   6007600.028630001 2091890.26579 37.7243619938904 -122.415871404438 (37.7243619938904, -122.415871404438)
77858 40258 1 35 3502 24th St 2 1 1 1 1 05/13/1999 12:00:00 AM 10   Permit Number 41417 6006132.27744777 2102027.63127436 37.7521143101544 -122.421664902947 (37.7521143101544, -122.421664902947)
95101 97822 2 35 595X Liberty St 1 1 1 1     10 4x4   6002402.0 2104748.0 37.7593727378271 -122.434759263601 (37.7593727378271, -122.434759263601)
103278 42100 1 35 231 Edna St 1 1 1 1   06/21/2000 12:00:00 AM 10 3x6 Permit Number 42406 5998731.52646444 2093591.79431997 37.7285314229156 -122.44665081973 (37.7285314229156, -122.44665081973)
118553 58453 1 35 73 Downey St 1 1 1 1   03/11/2010 12:00:00 AM 10 3x3 Permit Number 53199 5998815.14010882 2107825.71866386 37.767619090536705 -122.44738585168501 (37.7676190905367, -122.447385851685)
135454 178949 2 35 1555 Bacon St 1 1 1 1     10 Width 2ft   6006996.74886 2091707.17834 37.723825340541204 -122.417943890293 (37.7238253405412, -122.417943890293)
150756 104961 1 35 125 Commonwealth Ave 1 1 1 1   11/26/2013 12:00:00 AM 10   Permit Number 770811 5996496.5 2113597.6 37.7833343975689 -122.455822972198 (37.7833343975689, -122.455822972198)
151643 31579 1 35 1766 23rd Ave 1 1 1 1 1 05/10/1995 12:00:00 AM 10   Permit Number 35118 5989083.5648 2103328.988 37.7547113797178 -122.480716506349 (37.7547113797178, -122.480716506349)
156152 237991 2 35 158 College Ave 1 1 1 1     10 Width 2ft   6004819.13057 2095927.0509 37.7352893763874 -122.425771780961 (37.7352893763874, -122.425771780961)
162852 140802 2 35 82 JORDAN AVE 3 2 1 1     10 Width 0ft   5996233.7192 2113991.8267 37.7844017542187 -122.45676060516199 (37.7844017542187, -122.456760605162)
177998 63548 1 35 942 Central Ave 1 1 1 1 1 04/13/1987 12:00:00 AM 10   Permit Number 24164 5999530.709 2111776.0946 37.7785066833069 -122.445194846179 (37.7785066833069, -122.445194846179)
179096 31300 1 35 519 Birch St 2 1 1 1 1 04/12/1995 12:00:00 AM 10   Permit Number 34943 6005263.3007 2111469.3023 37.7779898515936 -122.425341782234 (37.7779898515936, -122.425341782234)
183435 245195 2 35 48 Baker St 1 1 1 1     10 Width 0ft   6000874.4772 2109202.1258 37.7715158240845 -122.440361608185 (37.7715158240845, -122.440361608185)
185796 214455 2 35 449 Baden St 1 17 1 1     10 Width 8ft   6000738.084840001 2095503.40232 37.733894671806 -122.439851058803 (37.733894671806, -122.439851058803)
189051 118424 2 35 5421 Anza St 2 2 1 1     10 Width 3ft   5981802.00316 2111639.4369 37.7771035681701 -122.50651396642 (37.7771035681701, -122.50651396642)
Powered by Datasette · Query took 22.104ms · Data source: data.sfgov.org