sf-trees

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
43355 41527 1 75 1038 Innes Ave 1 1 1 1   04/20/2000 12:00:00 AM 19   Permit Number 42067 6018424.261969999 2095097.67116 37.7337714988594 -122.378675747684 (37.7337714988594, -122.378675747684)
47057 84747 1 75 170 King St 4 1 1 1   05/04/2007 12:00:00 AM 19   Permit No. 49304 6015084.20168 2111522.58673 37.7786861141091 -122.391371241385 (37.7786861141091, -122.391371241385)
160511 33315 1 75 1229 Francisco St 2 1 1 1 1 11/14/1996 12:00:00 AM 19   Permit Number 37460 6005351.66292 2120593.2650099997 37.8030469569032 -122.42568566546001 (37.8030469569032, -122.42568566546)
165317 217452 2 75 248 Thrift St 2 9 1 1     19     5994521.8342699995 2089659.5838400002 37.7174931519523 -122.46091897182801 (37.7174931519523, -122.460918971828)
181886 49328 1 75 650 05th St 1 1 1 1   02/21/2003 12:00:00 AM 19   Permit Number 46321 6013181.12431 2110489.32106 37.775743196927294 -122.397882269155 (37.7757431969273, -122.397882269155)
39861 65881 1 75 122 Palm Ave 1 1 1 1 1 10/28/2010 12:00:00 AM 19 3x3 Permit Number 53867 5995930.99366 2113550.02665 37.783171302573 -122.457775944343 (37.783171302573, -122.457775944343)
145780 28459 1 75 2160X Ocean Ave 6 1 1 1   04/01/2003 12:00:00 AM 19 3x3   5992788.04983 2093457.91659 37.727822529658 -122.467187832651 (37.727822529658, -122.467187832651)
70541 102432 3 75 982 Howard St 2 1 1 2     19 4x4   6010557.78599 2112071.21552 37.779940263668706 -122.40706862532801 (37.7799402636687, -122.407068625328)
13185 98922 2 75 2507 21st Ave 1 1 1 1     19 6x6   5989831.2863 2098268.2421 37.7408593296697 -122.47776079641599 (37.7408593296697, -122.477760796416)
43953 249965 2 75 265 Filbert St 2 7 1 1     19 Width 0ft   6011638.85917 2120086.18138 37.802007891017205 -122.40389285566799 (37.8020078910172, -122.403892855668)
26802 243938 2 75 315 Sanchez St 1 1 1 1     19 Width 3ft   6003592.012490001 2106424.54324 37.764043612453996 -122.43076326292 (37.764043612454, -122.43076326292)
48613 244810 2 75 1346 Hampshire St 1 1 1 1     19 Width 3ft   6010313.90218 2101409.39253 37.750651674745995 -122.407160569311 (37.750651674746, -122.407160569311)
155650 181265 2 75 271 Leland Ave 6 9 1 1     19 Width 3ft   6009530.324580001 2087672.9738099999 37.7128905152502 -122.40890120353201 (37.7128905152502, -122.408901203532)
178669 243943 2 75 671 Church St 56 7 1 1     19 Width 3ft   6004315.82343 2105235.1157 37.7608187101375 -122.428175041065 (37.7608187101375, -122.428175041065)
39967 199470 2 75 1050 03rd St 7 1 1 1     19 Width 5ft   6015462.75637 2109791.03207 37.7739526530238 -122.38994067543001 (37.7739526530238, -122.38994067543)
64963 199457 2 75 1279 03rd St 3 1 1 1     19 Width 5ft   6015609.11002 2108848.45381 37.7713726563476 -122.389368573515 (37.7713726563476, -122.389368573515)
148816 199461 2 75 1279 03rd St 9 1 1 1     19 Width 5ft   6015597.30963 2109009.9155099997 37.7718153404253 -122.389420669423 (37.7718153404253, -122.389420669423)
167534 199452 2 75 1401 03rd St 1 1 1 1     19 Width 5ft   6015631.41317 2108425.60277 37.7702128366907 -122.38926189323799 (37.7702128366907, -122.389261893238)
Powered by Datasette · Query took 8.909ms · Data source: data.sfgov.org