sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9197 24149 1 82 100X Whitney Young Cir 9 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016357.373923 2096088.8828188 37.736379006835996 -122.385890729183 (37.736379006836, -122.385890729183)
124104 213976 2 82 1061 Capitol Ave 9 1 1 1     11 Width 3ft   5995023.46765 2090970.5982400002 37.7211217374705 -122.459279952923 (37.7211217374705, -122.459279952923)
107290 48806 1 82 1082Street Pennsylvania Ave 9 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
181973 197091 2 82 1098 Pennsylvania Ave 9 9 1 1     7 Width 5ft   6014475.63706 2102134.7648099996 37.7528754202862 -122.39281957348601 (37.7528754202862, -122.392819573486)
135819 197165 2 82 15 Reuel Ct 9 1 1 1     5 Width 3ft   6017366.51517 2096051.5594799998 37.7363323183867 -122.382399074074 (37.7363323183867, -122.382399074074)
108930 30630 1 82 1690 Folsom St 9 1 1 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008012.82240629 2108413.03711614 37.7697530267823 -122.41561373544901 (37.7697530267823, -122.415613735449)
84970 93820 1 82 178 Bluxome St 9 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
25710 138447 2 82 1820 POST ST 9 1 1 1     2 Width 0ft   6003269.2692 2114178.8859 37.7853168309586 -122.432433419204 (37.7853168309586, -122.432433419204)
167314 138129 2 82 1850 FILLMORE ST 9 1 1 1     2 Width 0ft   6003011.9121 2114750.6049 37.7868720297123 -122.433364664404 (37.7868720297123, -122.433364664404)
75202 197123 2 82 2 Napoleon St 9 4 1 1     4 Width 4ft   6013823.14287 2100134.6938099996 37.7473473883884 -122.39493596693 (37.7473473883884, -122.39493596693)
132220 102493 1 82 2001 McAllister St 9 1 1 1     8 3x3   5999461.6709 2111166.2585 37.7768282889466 -122.445389813922 (37.7768282889466, -122.445389813922)
150336 213982 2 82 201 Lobos St 9 1 1 1     1 Width 3ft   5994935.45629 2088691.9546700001 37.714860062915 -122.459419242599 (37.714860062915, -122.459419242599)
80405 16518 3 82 330 Newhall St 9 1 1 2   03/30/2006 12:00:00 AM 3 3X3   6016409.970087901 2098376.06541 37.742662057146795 -122.385868255606 (37.7426620571468, -122.385868255606)
28648 213960 2 82 360 Faxon Ave 9 1 1 1     13 Width 3ft   5994774.81066 2091163.6355700002 37.7216374725616 -122.460153459937 (37.7216374725616, -122.460153459937)
96662 87399   82 400X Monterey Blvd 9 11 1 2   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815)
89430 16558 3 82 500X Newhall St 9 1 1 2   12/27/1997 12:00:00 AM 3 3x3   6016006.287148001 2097894.9109735 37.74131855784729 -122.387230532448 (37.7413185578473, -122.387230532448)
666 237028 3 82 8 Octavia St 9 4 1 2   04/15/2017 01:55:00 PM 3 Width 6ft   6005756.39315 2109517.28856 37.7726579404383 -122.423497186858 (37.7726579404383, -122.423497186858)
Powered by Datasette · Query took 16.51ms · Data source: data.sfgov.org