sf-trees

Data source: data.sfgov.org

Custom SQL query returning 56 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
168151 188426 2 304 1033 Le Conte Ave 1 2 1 1     3     6012945.165080001 2089685.0060700001 37.718605847172796 -122.397239321332 (37.7186058471728, -122.397239321332)
148629 222750 2 304 106 Chattanooga St 3 10 1 1     1 Width 4ft   6004701.63015 2102998.9916 37.754700661810396 -122.426681464997 (37.7547006618104, -122.426681464997)
62864 108717 2 304 1141 Chestnut St 3 14 1 1     7 3x3   6006358.32966 2120394.6178099997 37.802558354332795 -122.422187945742 (37.8025583543328, -122.422187945742)
176450 125938 2 304 1141 Chestnut St 4 7 1 1     5     6006363.6774 2120394.85285 37.8025593013256 -122.422169456568 (37.8025593013256, -122.422169456568)
168296 246742 2 304 136 Ripley St 2 9 1 1     11 Width 8ft   6008894.39188 2099076.6587 37.7441669620301 -122.41190454706499 (37.7441669620301, -122.411904547065)
74329 205952 2 304 140 Edgehill Way 1 7 1 1     20 Width 3ft   5994898.923880001 2098946.32405 37.743013972722395 -122.460288034466 (37.7430139727224, -122.460288034466)
78117 205953 2 304 140 Edgehill Way 2 7 1 1     7 Width 3ft   5994919.2811199995 2098952.6598099996 37.7430325401195 -122.4602181041 (37.7430325401195, -122.4602181041)
157042 205954 2 304 140 Edgehill Way 3 7 1 1     12 Width 3ft   5994947.0604 2098964.00202 37.743065280840604 -122.460122873099 (37.7430652808406, -122.460122873099)
179577 188427 2 304 15 Baldwin Ct 6 9 1 1     20 Width 3ft   6017957.00667 2093516.4296900001 37.729403949426796 -122.380181357598 (37.7294039494268, -122.380181357598)
185586 188424 2 304 1551 20th St 3 4 1 1     5 Width 3ft   6013353.62551 2104726.9613900003 37.7599306458005 -122.396881449639 (37.7599306458005, -122.396881449639)
182333 205938 2 304 172 Marston Ave 1 9 1 1     14     5998412.01013 2093231.0214799999 37.727522568613296 -122.447729439158 (37.7275225686133, -122.447729439158)
188568 124552 2 304 18 Palm Ave 1 9 1 1     17 Width 7ft   5995913.7095 2114356.4263299997 37.7853844674695 -122.45789411412599 (37.7853844674695, -122.457894114126)
187459 123818 2 304 1909 Anza St 4 9 1 1     26     5992783.81054 2112023.2086400003 37.778797772816 -122.468552707605 (37.778797772816, -122.468552707605)
178671 188425 2 304 1951 Revere Ave 2 7 1 1     8     6013071.87286 2095884.6645799999 37.7356358995807 -122.39723584456101 (37.7356358995807, -122.397235844561)
134190 205957 2 304 21 Flood Ave 2 9 1 1     1 Width 2ft   6000251.93963 2094041.30638 37.7298524116556 -122.441426926424 (37.7298524116556, -122.441426926424)
185752 185621 2 304 2100 Sunset Blvd 1 9 1 1     3 Width 0ft   5985076.793 2100297.0456 37.746152800876295 -122.494349331231 (37.7461528008763, -122.494349331231)
105016 87475 1 304 2170 Vallejo St 1 5 1 1   05/13/2008 12:00:00 AM   3x3 Permit Number 50384 6003181.0 2117910.0 37.7955565121873 -122.433005467627 (37.7955565121873, -122.433005467627)
172195 187246 2 304 2401 Sunset Blvd 29 9 1 1     3 Width 0ft   5984930.6842 2098473.0381 37.7411360187671 -122.494720096528 (37.7411360187671, -122.494720096528)
149050 181985 2 304 2475 34th Ave 1 2 1 1     6 Width 0ft   5985788.8378 2098402.2572 37.740991866121895 -122.491747742703 (37.7409918661219, -122.491747742703)
59021 247993 2 304 260 Peralta Ave 2 17 1 1     16     6009745.41433 2099623.13704 37.7457151800111 -122.409000435623 (37.7457151800111, -122.409000435623)
166987 247992 2 304 260 Peralta Ave 1 17 1 1     14     6009735.72559 2099644.7711400003 37.7457740397574 -122.40903546421998 (37.7457740397574, -122.40903546422)
68095 185133 2 304 2685 34th Ave 1 1 1 1     21 Width 0ft   5985812.3151 2097090.9126 37.7373926359354 -122.491570064184 (37.7373926359354, -122.491570064184)
68879 185134 2 304 2685 34th Ave 2 1 1 1     22 Width 0ft   5985813.3764 2097101.5255 37.737421838158205 -122.49156717580601 (37.7374218381582, -122.491567175806)
76108 205955 2 304 280 Joost Ave 2 9 1 1     12 Width 5ft   6000206.38741 2094986.03791 37.7324438297042 -122.44165217692101 (37.7324438297042, -122.441652176921)
58530 125936 2 304 3640 Fillmore St 2 4 1 1     12 Width 6ft   6002183.33436 2120790.5318400003 37.803409058151104 -122.43666384886801 (37.8034090581511, -122.436663848868)
62032 125937 2 304 3640 Fillmore St 3 4 1 1     17 Width 6ft   6002179.26509 2120811.82356 37.8034672883377 -122.43667945570401 (37.8034672883377, -122.436679455704)
72790 117715 2 304 3945 Clement St 4 9 1 1     18 Width 8ft   5983236.22223 2113083.20923 37.7811520854734 -122.50165947240801 (37.7811520854734, -122.501659472408)
186353 175823 2 304 396 Sweeny St 2 9 1 1     3 Width 6ft   6008495.77883 2094494.2725900002 37.731562358299705 -122.412958939219 (37.7315623582997, -122.412958939219)
69160 205941 2 304 400 Junipero Serra Blvd 26 4 1 1     14 Width 0ft   5991352.1529 2093883.98785 37.7289094230078 -122.472182754742 (37.7289094230078, -122.472182754742)
171926 118061 2 304 444 36th Ave 1 2 1 1     4 Width 4ft   5984717.2376 2112866.39163 37.7806436447067 -122.496519969041 (37.7806436447067, -122.496519969041)
58817 205951 2 304 448 Dewey Blvd 1 2 1 1     6 Width 3ft   5994925.1846900005 2100230.71916 37.746542111141 -122.46029027108999 (37.746542111141, -122.46029027109)
171753 205950 2 304 448 Dewey Blvd 2 2 1 1     6 Width 3ft   5994914.216019999 2100220.64838 37.7465138283535 -122.460327469743 (37.7465138283535, -122.460327469743)
174763 222751 2 304 465 Collingwood St 1 10 1 1     7 Width 8ft   6002166.472080001 2103160.19285 37.7549996270445 -122.43546024751998 (37.7549996270445, -122.43546024752)
25354 205939 2 304 48 Ashton Ave 1 9 1 1     17     5994177.6716 2090250.93018 37.719097037971395 -122.46215143695801 (37.7190970379714, -122.462151436958)
17742 29583 3 304 500X Junipero Serra Blvd 5 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991356.34632 2093796.5361 37.7286695450513 -122.472161885972 (37.7286695450513, -122.472161885972)
62302 222752 2 304 51 Mirabel Ave 1 1 1 1     5 Width 3ft   6007601.30619 2099973.28331 37.746556261965 -122.416439264254 (37.746556261965, -122.416439264254)
148586 205940 2 304 515 Bright St 1 9 1 1     16 Width 8ft   5993754.48866 2090585.8186599999 37.7199921862674 -122.46363849832501 (37.7199921862674, -122.463638498325)
182939 222753 2 304 53 Mirabel Ave 2 1 1 1     13 Width 3ft   6007621.03284 2099982.0606 37.7465814717634 -122.41637167303101 (37.7465814717634, -122.416371673031)
116329 112363 6 304 540 10th Ave 3 7 1 1     24 6x6   5992860.82014 2111778.58973 37.778130563709 -122.468268503132 (37.778130563709, -122.468268503132)
60335 44204 1 304 590 Funston Ave 2 1 1 1     7   Permit Number 43652 5991935.62252 2111429.6910599996 37.7771191035962 -122.47144363711901 (37.7771191035962, -122.471443637119)
158876 44202 1 304 590 Funston Ave 3 1 1 1     7   Permit Number 43652 5991936.49237 2111436.2317 37.7771371127331 -122.47144110476499 (37.7771371127331, -122.471441104765)
41558 205942 2 304 700 Junipero Serra Blvd 41 4 1 1     1 Width 0ft   5991261.76371 2092534.5655 37.7251990144957 -122.47239689950399 (37.7251990144957, -122.472396899504)
45009 205946 2 304 700 Junipero Serra Blvd 59 4 1 1     2 Width 0ft   5991258.02195 2092404.54695 37.7248417993064 -122.472400360108 (37.7248417993064, -122.472400360108)
57018 205947 2 304 700 Junipero Serra Blvd 156 4 1 1     3 Width 0ft   5991175.5044 2091410.84585 37.722108566227796 -122.472613194561 (37.7221085662278, -122.472613194561)
63989 205945 2 304 700 Junipero Serra Blvd 53 4 1 1     2 Width 0ft   5991256.72778 2092439.9608099998 37.724938962062 -122.472407414382 (37.724938962062, -122.472407414382)
133970 205948 2 304 700 Junipero Serra Blvd 159 4 1 1     2 Width 0ft   5991180.56722 2091389.80327 37.7220510815648 -122.47259416039101 (37.7220510815648, -122.472594160391)
160855 205943 2 304 700 Junipero Serra Blvd 47 4 1 1     1 Width 0ft   5991257.407000001 2092470.35654 37.7250224604945 -122.472407281286 (37.7250224604945, -122.472407281286)
168924 205944 2 304 700 Junipero Serra Blvd 51 4 1 1     1 Width 0ft   5991238.87457 2092458.9920700002 37.724990183842394 -122.472470517115 (37.7249901838424, -122.472470517115)
169329 205949 2 304 700 Junipero Serra Blvd 164 4 1 1     2 Width 0ft   5991178.36244 2091356.45164 37.7219593786163 -122.47259935129601 (37.7219593786163, -122.472599351296)
19000 30051 3 304 700X Junipero Serra Blvd 1 11 1 2     3 3X3   5991309.16462 2093067.2657700002 37.7266644202262 -122.472271855075 (37.7266644202262, -122.472271855075)
21379 11753 3 304 700X Junipero Serra Blvd 36 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991274.57378 2092596.10409 37.725368725576 -122.472357100898 (37.725368725576, -122.472357100898)
182250 205956 2 304 780 Joost Ave 2 9 1 1     20     5996930.45359 2095027.6669599998 37.7323709396728 -122.45298079555401 (37.7323709396728, -122.452980795554)
34366 125940 2 304 81 MacOndray Ln 4 9 1 1     30 Width 6ft   6008296.20115 2119114.47997 37.7991525291135 -122.415391242038 (37.7991525291135, -122.415391242038)
173535 125939 2 304 81 MacOndray Ln 1 9 1 1     22 Width 6ft   6008257.6935 2119111.01163 37.7991408415295 -122.41552424635599 (37.7991408415295, -122.415524246356)
45170 222749 2 304 924 Church St 2 1 1 1     21 Width 3ft   6004343.4992 2103490.3475900004 37.7560295558269 -122.427954990428 (37.7560295558269, -122.427954990428)
66061 222748 2 304 924 Church St 1 1 1 1     18 Width 3ft   6004341.63237 2103506.8700200003 37.7560748169134 -122.42796262386899 (37.7560748169134, -122.427962623869)
Powered by Datasette · Query took 3.013ms · Data source: data.sfgov.org