sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1524 251544 2 27 863X Ocean Ave   17 1 1       3x3   5997430.0 2091537.0 37.722815009603295 -122.451002133856 (37.7228150096033, -122.451002133856)
1773 251685 2 27 66 Lee Ave 1 1 1 1       3x3   5996558.0 2090330.0 37.719450911009005 -122.453929311088 (37.719450911009, -122.453929311088)
1779 251684 2 27 62 Lee Ave 1 1 1 1       3x3   5996557.0 2090306.0 37.719384955305294 -122.453931035382 (37.7193849553053, -122.453931035382)
2094 252881 2 27 3536 Jennings St 1 2 1 1       Width 3ft   6013049.3063900005 2089480.54762 37.718050242412296 -122.39686501810199 (37.7180502424123, -122.396865018102)
5541 81381 2 27 822 Geary St 1 1 1 1 1 11/08/2003 12:00:00 AM   3x3   6007769.502 2114456.07002 37.7863320683098 -122.41688358241899 (37.7863320683098, -122.416883582419)
89568 87364 1 27 3401 Taraval St 5 1 1 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
94485 87363 1 27 3401 Taraval St 4 1 1 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
102241 121608 2 27 99X Lamartine St 3 1 1 1       3x3   6002710.0 2094292.0 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569)
102463 87366 1 27 3401 Taraval St 7 1 1 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
103991 100461 2 27 236 Wawona St 1 1 1 1           5992450.0 2097712.0 37.7394836593705 -122.468665877071 (37.7394836593705, -122.468665877071)
117773 121606 2 27 99X Lamartine St 1 1 1 1       3x3   6002710.0 2094292.0 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569)
138958 87365 1 27 3401 Taraval St 6 1 1 1   04/08/2008 12:00:00 AM   3x3 Permit Number 50345 5982691.0 2098770.0 37.741820045233396 -122.502485963998 (37.7418200452334, -122.502485963998)
140890 121607 2 27 99X Lamartine St 2 1 1 1       3x3   6002710.0 2094292.0 37.7306804869695 -122.432947039569 (37.7306804869695, -122.432947039569)
31001 176999 2 27 906 Edinburgh St 2 1 1 1     1 Width 6ft   6001595.86635 2088796.01268 37.7155264893371 -122.436405562669 (37.7155264893371, -122.436405562669)
34009 70454 2 27 2631 44th Ave 1 1 1 1 1 06/11/1994 12:00:00 AM 1     5982726.9666 2097193.7529 37.7374942155975 -122.502244984058 (37.7374942155975, -122.502244984058)
34276 182870 2 27 1847 26th Ave 2 2 1 1     1 Width 0ft   5988127.2852 2102724.1956 37.752995155363 -122.483979194232 (37.752995155363, -122.483979194232)
36484 207243 2 27 324 Lakeview Ave 1 4 1 1     1 Width 3ft   5996808.75565 2089668.4523599998 37.7176488300194 -122.453014817795 (37.7176488300194, -122.453014817795)
39694 191411 2 27 462 Thornton Ave 1 9 1 1     1 Width 3ft   6012808.38143 2094403.0124599999 37.7315529172119 -122.39804293216001 (37.7315529172119, -122.39804293216)
42221 207173 2 27 451 Ulloa St 2 2 1 1     1 Width 4ft   5995323.713819999 2098239.63146 37.7410979958728 -122.45876808490601 (37.7410979958728, -122.458768084906)
45169 183658 2 27 1487 48th Ave 1 1 1 1     1 Width 0ft   5981219.3285 2104945.9280000003 37.7586908149842 -122.508032687607 (37.7586908149842, -122.508032687607)
52741 92437 1 27 1974 44th Ave 1 1 1 1 1 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52827 5982618.164 2101679.0263 37.7498031456316 -122.502953108098 (37.7498031456316, -122.502953108098)
57295 207143 2 27 1617 16th Ave 1 1 1 1     1 Width 2ft   5991127.14012 2104370.55559 37.7576898140615 -122.473725315989 (37.7576898140615, -122.473725315989)
59000 227698 2 27 517 Hickory St 1 4 1 1     1 Width 3ft   6004312.97566 2110291.73585 37.7747028072132 -122.428545336007 (37.7747028072132, -122.428545336007)
61927 184535 2 27 1914 47th Ave 1 1 1 1     1 Width 0ft   5981673.4595 2102023.0319999997 37.7506921190217 -122.506245385817 (37.7506921190217, -122.506245385817)
62758 207140 2 27 1682 17th Ave 1 1 1 1     1 Width 3ft   5990920.30999 2103955.3917900003 37.7565379030086 -122.474410316087 (37.7565379030086, -122.474410316087)
73076 207146 2 27 1440 16th Ave 1 2 1 1     1 Width 4ft   5991174.2447 2105585.9909099997 37.7610298052998 -122.47365107156601 (37.7610298052998, -122.473651071566)
73666 184518 2 27 4108 Pacheco St 1 1 1 1     1 Width 0ft   5982209.6889 2101522.5062 37.7493493689338 -122.504354014902 (37.7493493689338, -122.504354014902)
73802 207144 2 27 1617 16th Ave 2 1 1 1     1 Width 2ft   5991126.06401 2104353.71257 37.757643505256205 -122.473727808906 (37.7576435052562, -122.473727808906)
130905 108372 1 27 575 Paris St 2 1 1 1 1   1 3x3   6001633.30512 2090300.73335 37.7196602437916 -122.436383787393 (37.7196602437916, -122.436383787393)
134189 226586 2 27 195 Lexington St 1 1 1 1     1 Width 3ft   6006490.36158 2105010.39 37.760324461620705 -122.420638312212 (37.7603244616207, -122.420638312212)
136966 207147 2 27 1341 12th Ave 1 1 1 1     1 Width 2ft   5992375.35662 2106303.37048 37.7630690288235 -122.469549207953 (37.7630690288235, -122.469549207953)
137436 177005 2 27 362 Arleta Ave 1 1 1 1     1 Width 3ft   6009172.07817 2088408.58756 37.714890285531794 -122.410191328669 (37.7148902855318, -122.410191328669)
138075 227702 2 27 1201 San Jose Ave 44 7 1 1     1     6004467.63219 2096063.7098700001 37.7356447417011 -122.426996770882 (37.7356447417011, -122.426996770882)
150333 207234 2 27 422 Orizaba Ave 2 9 1 1     1 Width 10ft   5994046.18721 2089200.86778 37.716206246401896 -122.462529797908 (37.7162062464019, -122.462529797908)
159577 226592 2 27 4301 26th St 2 9 1 1     1 Width 8ft   6001848.149780001 2100568.16422 37.7478644508775 -122.43637559457198 (37.7478644508775, -122.436375594572)
163723 207169 2 27 526 Judson Ave 1 1 1 1     1 Width 2ft   5996886.48859 2093636.72948 37.728549238251205 -122.453032422917 (37.7285492382512, -122.453032422917)
163757 183296 2 27 1278 42nd Ave 5 2 1 1     1 Width 0ft   5983073.0612 2106475.4841 37.7629995961897 -122.50173490129801 (37.7629995961897, -122.501734901298)
164704 207182 2 27 451 Ulloa St 11 2 1 1     1 Width 4ft   5995335.09015 2098246.93081 37.7411186919637 -122.458729278246 (37.7411186919637, -122.458729278246)
166542 227701 2 27 1201 San Jose Ave 36 7 1 1     1     6004423.64254 2096032.0928 37.7355554408308 -122.427146608748 (37.7355554408308, -122.427146608748)
168553 191409 2 27 1201 20th St 6 9 1 1     1 Width 6ft   6014316.155809999 2104772.8809 37.760110260198495 -122.39355571261999 (37.7601102601985, -122.39355571262)
173335 183659 2 27 1487 48th Ave 2 1 1 1     1 Width 0ft   5981220.5326 2104962.3842 37.7587360699481 -122.50802974468701 (37.7587360699481, -122.508029744687)
177051 207148 2 27 1210 12th Ave 1 1 1 1     1 Width 4ft   5992391.03537 2107185.15973 37.7654910946525 -122.469559175111 (37.7654910946525, -122.469559175111)
177917 177001 2 27 154 Gillette Ave 1 1 1 1     1 Width 3ft   6013011.29164 2086676.67622 37.7103492505861 -122.396799956671 (37.7103492505861, -122.396799956671)
185161 183715 2 27 1226 39th Ave 1 1 1 1     1 Width 0ft   5983995.5254 2106803.3357 37.7639539248956 -122.49856868241899 (37.7639539248956, -122.498568682419)
186733 226608 2 27 1035 Shrader St 1 1 1 1     1 Width 3ft   5997646.28955 2106916.84179 37.765056684330794 -122.451363177783 (37.7650566843308, -122.451363177783)
186756 182869 2 27 1847 26th Ave 1 2 1 1     1 Width 0ft   5988126.7611 2102732.0567 37.753016709320995 -122.48398158304701 (37.753016709321, -122.483981583047)
41674 185771 2 27 1325 Ortega St 2 2 1 1     2 Width 0ft   5989890.4756 2102411.1303 37.7522380517247 -122.47785892610399 (37.7522380517247, -122.477858926104)
52088 177024 2 27 11 Athens St 1 9 1 1     2     6005372.1534 2093185.8595 37.7277939084451 -122.42366493918301 (37.7277939084451, -122.423664939183)
54071 207232 2 27 226 Thrift St 1 10 1 1     2 Width 6ft   5994766.53745 2089660.64097 37.7175101320775 -122.46007322780301 (37.7175101320775, -122.460073227803)
57155 207179 2 27 451 Ulloa St 8 2 1 1     2 Width 4ft   5995334.19857 2098241.75122 37.741104418845794 -122.458731986098 (37.7411044188458, -122.458731986098)
67090 177002 2 27 721 Goettingen St 2 10 1 1     2 Width 4ft   6010761.087830001 2091324.0286400001 37.7229844303778 -122.404904160394 (37.7229844303778, -122.404904160394)
131369 207156 2 27 2426 16th Ave 1 1 1 1     2 Width 3ft   5991402.6198 2098893.19012 37.7426663442825 -122.472373311184 (37.7426663442825, -122.472373311184)
137025 185770 2 27 1325 Ortega St 1 2 1 1     2 Width 0ft   5989884.1917 2102410.6066 37.752236249076205 -122.477880618296 (37.7522362490762, -122.477880618296)
138093 207251 2 27 567 Arch St 1 4 1 1     2 Width 3ft   5992723.294480001 2090942.0276900001 37.720910777190795 -122.46722883836 (37.7209107771908, -122.46722883836)
148774 68284 1 27 665 Bowdoin St 1 1 1 1 1 06/14/2012 12:00:00 AM 2   Permit Number 769020 6009000.66847 2092983.8736400001 37.727443453448 -122.411106781849 (37.727443453448, -122.411106781849)
153744 207155 2 27 606 Santiago St 2 1 1 1     2 Width 3ft   5990983.67458 2099779.50243 37.7450756729987 -122.473886535662 (37.7450756729987, -122.473886535662)
172332 226576 2 27 350 Day St 1 1 1 1     2 Width 2ft   6003654.19113 2098670.4327700003 37.7427561757625 -122.42999503773501 (37.7427561757625, -122.429995037735)
181185 66621 1 27 153 25th Ave 1 1 1 1   05/15/1991 12:00:00 AM 2   Permit Number 29825 5988002.0511 2114993.09117 37.7866748512276 -122.48531246716499 (37.7866748512276, -122.485312467165)
20367 29572 3 27 400X Junipero Serra Blvd 1 11 1 2   04/01/2007 12:00:00 AM 3 3X3   5991380.33669 2094272.13717 37.7299768148765 -122.47211360317 (37.7299768148765, -122.47211360317)
20702 16302 3 27 747 Monterey Blvd 1 1 1 2   11/18/1992 12:00:00 AM 3 3X3   5997139.1851 2094676.1292299998 37.73141766098679 -122.452233809638 (37.7314176609868, -122.452233809638)
21729 29577 3 27 400X Junipero Serra Blvd 6 11 1 2   04/01/2007 12:00:00 AM 3 3X3   5991369.68485 2094223.17677 37.7298417654626 -122.47214686011002 (37.7298417654626, -122.47214686011)
23484 226621 2 27 2498 Harrison St 6 1 1 1     3 Width 3ft   6008827.83459 2103955.23814 37.7575587153899 -122.412479469249 (37.7575587153899, -122.412479469249)
24701 226623 2 27 80 Vicksburg St 2 1 1 1     3 Width 5ft   6004079.6139400005 2102598.16626 37.7535649035083 -122.428803992713 (37.7535649035083, -122.428803992713)
24966 177004 2 27 746 Olmstead St 5 1 1 1     3 Width 2ft   6009463.77429 2090581.8029200002 37.720873831251104 -122.40933637376999 (37.7208738312511, -122.40933637377)
25103 226578 2 27 124 Grattan St 3 1 1 1     3 Width 4ft   5998059.2298099995 2106534.17954 37.76402962709221 -122.44990734536199 (37.7640296270922, -122.449907345362)
25493 207183 2 27 451 Ulloa St 12 2 1 1     3 Width 4ft   5995337.35676 2098242.98475 37.7411079873364 -122.458721155571 (37.7411079873364, -122.458721155571)
31099 226629 2 27 54 Collingwood St 1 1 1 1     3 Width 3ft   6001984.40508 2105553.3896 37.761560425102 -122.43626114684099 (37.761560425102, -122.436261146841)
31229 226622 2 27 2 Vicksburg St 1 1 1 1     3 Width 5ft   6004058.08528 2103018.40015 37.7547175483925 -122.42890840132799 (37.7547175483925, -122.428908401328)
33252 129488 2 27 3320 Baker St 1 1 1 1     3 Width 3ft   5999321.62812 2120233.7842099997 37.801717336245105 -122.44652677938801 (37.8017173362451, -122.446526779388)
33451 191410 2 27 777 Rhode Island St 1 4 1 1     3 Width 3ft   6011870.78856 2104734.77484 37.7598694505299 -122.402010442428 (37.7598694505299, -122.402010442428)
35186 45487 1 27 2934 21st Ave 1 1 1 1 1 07/19/2001 12:00:00 AM 3   Permit Number 44266 5990011.75655 2095686.43247 37.7337808158159 -122.476948200207 (37.7337808158159, -122.476948200207)
36611 207332 2 27 139 Mangels Ave 1 9 1 1     3 Width 10ft   6000483.56606 2095198.0934400002 37.7330418734682 -122.44070911276 (37.7330418734682, -122.44070911276)
37207 207145 2 27 1418 14th Ave 2 9 1 1     3 Width 5ft   5991828.31268 2105750.01462 37.7615180292623 -122.471400907553 (37.7615180292623, -122.471400907553)
40972 185610 2 27 2251 Quintara St 3 1 1 1     3 Width 0ft   5986429.217999999 2100931.4203 37.7479736765682 -122.48971952481001 (37.7479736765682, -122.48971952481)
47592 207190 2 27 212 Hearst Ave 7 9 1 1     3     5999972.7522599995 2094392.56954 37.7308009895699 -122.44241731471399 (37.7308009895699, -122.442417314714)
48704 207278 2 27 575 Dewey Blvd 1 2 1 1     3 Width 4ft   5994134.4568 2099399.45739 37.7442141593615 -122.462964201952 (37.7442141593615, -122.462964201952)
54556 207281 2 27 595 Darien Way 2 2 1 1     3 Width 3ft   5993428.290469999 2094922.6798 37.731881346040794 -122.46508086700001 (37.7318813460408, -122.465080867)
56032 207275 2 27 315 Dorantes Ave 1 2 1 1     3 Width 3ft   5993069.797230001 2099663.50314 37.7448777789813 -122.46666472241999 (37.7448777789813, -122.46666472242)
57515 67671 1 27 1780 Revere Ave 1 1 1 1   11/05/1992 12:00:00 AM 3   Permit Number 31274 6014163.98928 2095111.2366 37.733572965423896 -122.3934058406 (37.7335729654239, -122.3934058406)
58029 207272 2 27 855 Ortega St 2 2 1 1     3 Width 3ft   5991341.884190001 2102447.3188400003 37.7524215459225 -122.472842415544 (37.7524215459225, -122.472842415544)
58753 185611 2 27 2241 Quintara St 4 1 1 1     3 Width 0ft   5986448.3245 2100932.1027 37.747976665787895 -122.489653506406 (37.7479766657879, -122.489653506406)
59680 207153 2 27 37 Cragmont Ave 1 1 1 1     3 Width 3ft   5992857.79641 2101696.45596 37.750447510654396 -122.467545586773 (37.7504475106544, -122.467545586773)
61495 41940 1 27 642 05th Ave 2 1 1 1 1 05/09/2011 12:00:00 AM 3 3x3 Permit Number 767709 5994437.32362 2111135.33206 37.7764552768418 -122.46276817075301 (37.7764552768418, -122.462768170753)
62912 177003 2 27 746 Olmstead St 4 1 1 1     3 Width 2ft   6009476.70201 2090586.0760400002 37.720886288652004 -122.409291987754 (37.720886288652, -122.409291987754)
67812 207165 2 27 501 Laguna Honda Blvd 1 1 1 1     3 Width 3ft   5995466.11989 2100230.17484 37.746571717707205 -122.458419748693 (37.7465717177072, -122.458419748693)
68986 185609 2 27 2261 Quintara St 2 1 1 1     3 Width 0ft   5986412.841 2100929.3732 37.747967099583 -122.489776004492 (37.747967099583, -122.489776004492)
69001 176998 2 27 87 Seneca Ave 2 1 1 1     3 Width 1ft   6000227.51825 2089886.7347900001 37.7184435186304 -122.441213386902 (37.7184435186304, -122.441213386902)
69603 207236 3 27 1x Minerva St 25 11 1 2     3 Width 0ft   5996258.071 2089000.15441 37.7157822655196 -122.45487001484301 (37.7157822655196, -122.454870014843)
70030 177026 2 27 501 Sweeny St 1 9 1 1     3 Width 6ft   6008206.81715 2094351.9900900002 37.7311554564421 -122.41394787781601 (37.7311554564421, -122.413947877816)
70124 207280 2 27 595 Darien Way 1 2 1 1     3 Width 3ft   5993435.14458 2094919.26873 37.731872375313294 -122.46505692344299 (37.7318723753133, -122.465056923443)
73643 207345 2 27 628 Edna St 1 9 1 1     3 Width 10ft   5998591.38299 2094890.7633 37.732090079596794 -122.44722875061399 (37.7320900795968, -122.447228750614)
76937 42890 1 27 2249 Ulloa St 3 1 1 1 1 07/03/2000 12:00:00 AM 3   Permit Number 42809 5988984.6022 2098295.481 37.7408849467502 -122.48069027409402 (37.7408849467502, -122.480690274094)
108882 90815 3 27 3145 Cabrillo St 1 1 1 2   04/07/2008 12:00:00 AM 3 3x3   5985771.299330001 2110409.9607700002 37.7739606832472 -122.49269254584101 (37.7739606832472, -122.492692545841)
116109 115788 1 27 3628 16th St 2 1 1 1 1 03/09/2016 12:00:00 AM 3   Permit Number 777599 6002731.19846 2106518.35077 37.764252377203 -122.433747267607 (37.764252377203, -122.433747267607)
117257 108497 1 27 1339 12th Ave 1 1 1 1 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773641 5992378.78756 2106335.85187 37.7631584124216 -122.46953970622101 (37.7631584124216, -122.469539706221)
130565 207178 2 27 451 Ulloa St 7 2 1 1     3 Width 4ft   5995329.77436 2098242.36362 37.7411058460538 -122.45874732764 (37.7411058460538, -122.45874732764)
133337 177023 2 27 1628 Burrows St 2 1 1 1     3 Width 3ft   6006643.54009 2092125.7831400002 37.7249548539585 -122.419194556805 (37.7249548539585, -122.419194556805)
133764 207351 2 27 662 Mangels Ave 1 9 1 1     3 Width 3ft   5997053.67683 2095305.7853299999 37.7331416469589 -122.45257485054701 (37.7331416469589, -122.452574850547)
135933 176997 2 27 131 Farragut Ave 1 9 1 1     3 Width 6ft   5997268.75573 2087384.8014900002 37.7114048037631 -122.451260209013 (37.7114048037631, -122.451260209013)
136074 207276 2 27 350 Dorantes Ave 1 2 1 1     3 Width 3ft   5992917.36629 2099685.98724 37.7449307166945 -122.467193430259 (37.7449307166945, -122.467193430259)
140281 108494 1 27 734 11th Ave 1 5 1 1 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773785 5992601.40555 2110422.43493 37.7743919431152 -122.469067180848 (37.7743919431152, -122.469067180848)
Powered by Datasette · Query took 4.524ms · Data source: data.sfgov.org