sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4568 142545 3 5 301 FRANCISCO ST 7 1 1 4     20 Width 0ft   6009562.3577 2121186.5007 37.80491286675579 -122.41115633279499 (37.8049128667558, -122.411156332795)
4570 142547 3 5 301 FRANCISCO ST 9 1 1 4     20 Width 0ft   6009612.5597 2121193.6724 37.804935373675605 -122.41098310943799 (37.8049353736756, -122.410983109438)
24594 115551 2 46 925x Minnesota St 3 1 1 4 2   20 18x7   6015277.41921 2104189.44931 37.7585616474178 -122.39019037219299 (37.7585616474178, -122.390190372193)
70878 95154 1 10 250 23rd Ave 10 1 1 4 2   20     5988718.8555 2113711.8550400003 37.783198671909794 -122.48273859805 (37.7831986719098, -122.48273859805)
78104 92958 1 17 300 Seneca Ave 3 1 1 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.721710307674606 -122.444931280306 (37.7217103076746, -122.444931280306)
84647 72535 3 17 150X Alma St 1 1 1 4 2 03/21/1992 12:00:00 AM 20 3x3   5997957.39996807 2106223.02713962 37.763169454232894 -122.45023711317499 (37.7631694542329, -122.450237113175)
86699 32726 3 155 200X Farallones St 7 1 1 4 2 10/29/1996 12:00:00 AM 20 6x9 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.45912868181601 (37.7143256328225, -122.459128681816)
90252 96214 3 5 200X Collingwood St 2 1 1 4 2   20 3x3   6002035.7 2104682.0 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266)
105652 98659 1 43 2110 Greenwich St 13 1 1 4 4   20 7x7   6002683.8 2119245.6 37.799195508176105 -122.434821422435 (37.7991955081761, -122.434821422435)
109574 99554 3 15 200X Henry St 8 1 1 4 2   20 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147)
115759 92960 1 17 300 Seneca Ave 5 1 1 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.721710307674606 -122.444931280306 (37.7217103076746, -122.444931280306)
124517 99549 3 15 200X Henry St 3 1 1 4 2   20 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147)
126562 113465 2 59 450 CHURCH ST 1 1 1 4     20 6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
139294 92959 1 17 300 Seneca Ave 4 1 1 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.721710307674606 -122.444931280306 (37.7217103076746, -122.444931280306)
144074 92957 1 5 300 Seneca Ave 2 1 1 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.721710307674606 -122.444931280306 (37.7217103076746, -122.444931280306)
145041 92956 1 5 300 Seneca Ave 1 1 1 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.721710307674606 -122.444931280306 (37.7217103076746, -122.444931280306)
170121 116065 3 32 693 Vermont St 2 1 1 4 2   20 8x7   6011274.01561 2105377.63125 37.761601265113896 -122.404119643106 (37.7616012651139, -122.404119643106)
Powered by Datasette · Query took 7.498ms · Data source: data.sfgov.org