sf-trees

Data source: data.sfgov.org

Custom SQL query returning 21 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
916 224714 7 32 3255x 24th St 3 8 1 6     11 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
1791 251711 3 124 902 Market St 3 8 1 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
4182 253620 6 142 1120 South Van Ness Ave 3 8 1 1       Width 3ft   6007603.98274 2103104.1444200003 37.755153048679205 -122.41665176419201 (37.7551530486792, -122.416651764192)
9868 173714 2 1 699x 29th St 3 8 1 1       3x3   6002089.0 2098776.0 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427)
79308 111069 6 163 1836 08TH AVE 3 8 1 1       3x15   5993799.0 2102987.0 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175)
83931 105169 7 60 4755X 03RD ST 3 8 1 19     23 4x4   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
86948 106872 6 26 38 08th St 3 8 1 1   07/31/2014 12:00:00 AM     Permit Number 769156 6008506.93846 2111466.3623599997 37.7781645006636 -122.41412064163201 (37.7781645006636, -122.414120641632)
89222 89359 1 35 308 Tocoloma Ave 3 8 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50704 6012556.9 2087009.2 37.7112369933076 -122.39839375585301 (37.7112369933076, -122.398393755853)
98327 99832 6 198 2398@Steiner Broadway 3 8 1 1           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376)
98650 113044 6 3 500 RAYMOND AVE 3 8 1 1       3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
101205 114262 2 3 800x BROTHERHOOD WAY 3 8 1 1     36     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
102078 117000 6 36 880x MCALLISTER ST 3 8 1 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
102290 31648 1 17 4500 Ulloa St 3 8 1 1   02/13/2009 12:00:00 AM   3x3 Permit Number 52054 5982086.63822537 2098111.49533937 37.7399764418309 -122.504526837106 (37.7399764418309, -122.504526837106)
102481 114925 2 71 4400x OCEAN AVE 3 8 1 1   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
102533 112571 2 141 162 GRAND VIEW AVE 3 8 1 1       3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
105928 109708 6 17 621 Laguna Honda Blvd 3 8 1 1 1 07/29/2015 12:00:00 AM     Permit Number 774799 5995723.9 2099907.4 37.745700269008296 -122.457505029341 (37.7457002690083, -122.457505029341)
106407 88454 6 1 2801 Oakdale Ave 3 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
110241 87072 1 82 395 Byxbee St 3 8 1 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
119427 12711 6 17 1449 Lake St 3 8 1 2   06/01/2000 12:00:00 AM   3   5990998.3321714 2114735.5234974 37.7861417388427 -122.474927352046 (37.7861417388427, -122.474927352046)
123257 116622 2 41 5732X GEARY BLVD 3 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
129431 110789 8 3 850x SANCHEZ ST 3 8 1 1       3x3   6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
Powered by Datasette · Query took 2.673ms · Data source: data.sfgov.org