sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9947 11824 1 12 1299X Junipero Serra Blvd 14 2 1 13   03/13/2013 12:00:00 AM 2 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
114303 11822 1 2 1299X Junipero Serra Blvd 16 2 1 13     10 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
89093 116527 3 41 5732 GEARY BLVD 1 2 1 6 2     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
455 234501 3 3 2423 Market St 2 2 1 2     12 Width 8ft   6002117.5892 2105782.84009 37.7621980066439 -122.435816935712 (37.7621980066439, -122.435816935712)
789 175382 3 53 80x Junipero Serra Blvd 19 2 1 2     2 Width 3ft   5991305.518069999 2089124.29272 37.7158377779634 -122.471997198511 (37.7158377779634, -122.471997198511)
854 203901 3 5 3794 19th Ave 3 2 1 2     12 Width 3ft   5990470.121669999 2090714.3108400002 37.720155198286 -122.475000685058 (37.720155198286, -122.475000685058)
4797 214559 3 18 1342 Irving St 1 2 1 2   02/18/2009 12:00:00 AM 3 Width 3ft   5991532.56497 2106606.32246 37.7638521099028 -122.472486197695 (37.7638521099028, -122.472486197695)
4821 214558 3 18 1340 Irving St 1 2 1 2   02/18/2009 12:00:00 AM 4 Width 3ft   5991564.93185 2106609.34919 37.7638622938456 -122.472374472204 (37.7638622938456, -122.472374472204)
4903 239064 3 9 68 12th St 3 2 1 2   10/31/2016 12:00:00 AM 3 Width 3ft   6007045.28032 2109725.44965 37.77330216528821 -122.41905354577699 (37.7733021652882, -122.419053545777)
9934 102961 3 12 1299X Junipero Serra Blvd 4 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9935 102960 3 12 1299X Junipero Serra Blvd 3 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9936 102965 3 12 1299X Junipero Serra Blvd 9 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9937 102966 3 12 1299X Junipero Serra Blvd 10 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9939 102963 3 12 1299X Junipero Serra Blvd 6 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9940 102969 3 12 1299X Junipero Serra Blvd 12 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9941 102968 3 12 1299X Junipero Serra Blvd 11 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9943 102967 3 12 1299X Junipero Serra Blvd 13 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9944 11821 3 12 1299X Junipero Serra Blvd 2 2 1 2   03/09/2013 12:00:00 AM 2 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
9945 102971 3 12 1299X Junipero Serra Blvd 18 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
50152 113698 3 47 80 LINARES AVE 1 2 1 2           5994154.8 2102090.7 37.75160480205479 -122.46308908916401 (37.7516048020548, -122.463089089164)
64865 111721 3 276 950X Beach St 2 2 1 2           6005896.0 2121751.0 37.8062565433008 -122.42388434548401 (37.8062565433008, -122.423884345484)
86010 111722 3 276 950X Beach St 3 2 1 2           6005896.0 2121751.0 37.8062565433008 -122.42388434548401 (37.8062565433008, -122.423884345484)
87978 102959 3 37 1299X Junipero Serra Blvd 1 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
88506 98722 3 3 701X Brotherhood Way 1 2 1 2           5991112.8 2087998.1 37.7127343737121 -122.472581254687 (37.7127343737121, -122.472581254687)
91005 102964 3 12 1299X Junipero Serra Blvd 8 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
91241 111724 3 276 950X Beach St 5 2 1 2           6005896.0 2121751.0 37.8062565433008 -122.42388434548401 (37.8062565433008, -122.423884345484)
98926 357 3 37 3690X 19th Ave 4 2 1 2   03/09/2013 12:00:00 AM 2 2   5990489.74295 2091103.38095 37.7212246253626 -122.474961247113 (37.7212246253626, -122.474961247113)
100349 111723 3 276 950X Beach St 4 2 1 2           6005896.0 2121751.0 37.8062565433008 -122.42388434548401 (37.8062565433008, -122.423884345484)
108864 102970 3 37 1299X Junipero Serra Blvd 17 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
114274 110143 3 143 1130X PORTOLA DR 3 2 1 2       3x3   5994964.0 2098019.0 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341)
125197 110465 3 5 1485 FAIRFAX AVE 2 2 1 2     9 3x3   6016296.0 2097688.0 37.7407664622153 -122.38621437638201 (37.7407664622153, -122.386214376382)
2 232565 2 2 940 Elizabeth St 1 2 1 1   03/20/2017 12:00:00 AM 3 Width 4ft Permit Number 779625 6000396.48544 2101998.8644 37.7517102172731 -122.441498017841 (37.7517102172731, -122.441498017841)
27 244214 5 17 342 Scott St 1 2 1 1   03/20/2017 12:00:00 AM 3 Width 0ft Permit Number 779666 6002262.2202 2109717.5413 37.7730099442883 -122.43559821674499 (37.7730099442883, -122.435598216745)
35 183515 2 1 2562 26th Ave 1 2 1 1   03/21/2017 12:00:00 AM 3 Width 0ft Permit Number 779639 5988336.7554 2097879.9474 37.7397063254514 -122.482899813956 (37.7397063254514, -122.482899813956)
50 138938 5 17 632 HAYES ST 1 2 1 1   03/21/2017 12:00:00 AM 3 Width 0ft Permit Number 779650 6004797.9634 2110922.1515 37.7764612085261 -122.426912572117 (37.7764612085261, -122.426912572117)
168 179480 2 25 100 Serrano Dr 1 2 1 1     11     5989599.0 2090767.0 37.7202493457345 -122.478015677124 (37.7202493457345, -122.478015677124)
539 206615 2 66 198 Vasquez Ave 1 2 1 1     6 Width 3ft Permit Number 779324 5994758.52704 2099346.29484 37.7441041156281 -122.460802465585 (37.7441041156281, -122.460802465585)
553 206616 2 66 198 Vasquez Ave 2 2 1 1     5 Width 3ft Permit Number 779324 5994742.56026 2099334.6803900003 37.7440713065495 -122.460856833195 (37.7440713065495, -122.460856833195)
565 206617 2 66 198 Garcia Ave 1 2 1 1     8 Width 3ft   5994686.63181 2099351.09779 37.7441131663853 -122.461051409618 (37.7441131663853, -122.461051409618)
571 206618 2 66 198 Garcia Ave 2 2 1 1     8 Width 3ft Permit Number 779324 5994673.79551 2099409.87557 37.7442738167873 -122.461100053935 (37.7442738167873, -122.461100053935)
608 233928 2 100 8 Octavia St Frontage East 1 2 1 1     29 Width 8ft   6005775.18179 2109348.30824 37.77219502161479 -122.423420179704 (37.7721950216148, -122.423420179704)
721 183636 4 108 1478 47th Ave 1 2 1 1     4 3x9   5981570.9282 2105017.3718 37.7589076903569 -122.506822015648 (37.7589076903569, -122.506822015648)
892 251400 2 111 101 Rhine St 5 2 1 1       Width 3ft   5994375.43496 2086552.5575599999 37.7089535675334 -122.461199910156 (37.7089535675334, -122.461199910156)
1001 238568 1 16 1300 Noe St 1 2 1 1   04/27/2017 12:00:00 AM 3 Width 5ft Permit Number 779731 6003218.5106 2100626.90187 37.7481035005842 -122.431641146931 (37.7481035005842, -122.431641146931)
1006 232567 2 2 947 Elizabeth St 2 2 1 1     16 Width 4ft   6000330.76798 2101953.15424 37.751580964011204 -122.441721996685 (37.7515809640112, -122.441721996685)
1009 223537 1 49 1300 Noe St 2 2 1 1     15 Width 5ft   6003218.0959 2100594.3408 37.7480140720016 -122.431640256605 (37.7480140720016, -122.431640256605)
1103 211013 2 71 500 Junipero Serra Blvd 44 2 1 1     3 Width 0ft   5991332.59313 2093509.69784 37.727880584217 -122.47222310103399 (37.727880584217, -122.472223101034)
1368 141257 2 144 51 COMMONWEALTH AVE 3 2 1 1     6 Width 0ft   5996492.2734 2114210.7856 37.7850177994523 -122.455881936455 (37.7850177994523, -122.455881936455)
1370 141258 2 2 51 COMMONWEALTH AVE 8 2 1 1     4 Width 0ft   5996495.6576 2114088.9538 37.7846834760254 -122.455861417999 (37.7846834760254, -122.455861417999)
1785 228278 2 44 2050 15th St 1 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
1857 251765 2 21 23 Seville St 3 2 1 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1870 251767 2 21 23 Seville St 5 2 1 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1871 176854 2 21 23 Seville St 1 2 1 1     12 Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1876 251766 2 21 23 Seville St 4 2 1 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1878 251764 2 12 187 Seville St 4 2 1 1       Width 6ft   6001178.343719999 2087386.3168 37.7116320444605 -122.43774780171302 (37.7116320444605, -122.437747801713)
2066 252868 2 98 15 Foerster St 2 2 1 1       Width 3ft   5998080.65269 2093664.7185 37.7286944544712 -122.44890616611099 (37.7286944544712, -122.448906166111)
2092 196948 2 9 3536 Jennings St 4 2 1 1     3 Width 3ft   6013049.3063900005 2089480.54762 37.718050242412296 -122.39686501810199 (37.7180502424123, -122.396865018102)
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)
2102 196505 2 18 3536 Jennings St 3 2 1 1     2 Width 3ft   6013064.418880001 2089502.0027700001 37.7181099951501 -122.39681428375299 (37.7181099951501, -122.396814283753)
2180 251495 6 17 2448 Clay St 1 2 1 1   06/28/2017 12:00:00 AM 3 10x10 Permit Number 780000 6003026.0 2116224.0 37.7909183964794 -122.433421252488 (37.7909183964794, -122.433421252488)
2211 188595 2 5 1301 Rhode Island St 3 2 1 1   07/05/2017 12:00:00 AM 3 Width 7ft   6011997.611930001 2102271.8897 37.7531139870419 -122.401398733477 (37.7531139870419, -122.401398733477)
2383 201821 2 48 100 Friedell St 5 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021045.51426 2093266.4470799998 37.7288874606638 -122.369486691782 (37.7288874606638, -122.369486691782)
2387 201822 2 48 100 Friedell St 6 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021035.49669 2093250.0299200001 37.72884183267921 -122.36952018972299 (37.7288418326792, -122.369520189723)
2402 201606 2 44 598 Innes Ave 1 2 1 1   07/12/2017 12:00:00 AM 1 Width 3ft   6020954.32481 2093200.4635700001 37.7287012794353 -122.36979738594101 (37.7287012794353, -122.369797385941)
2408 201820 2 48 100 Friedell St 4 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021056.53291 2093279.09213 37.728922786051506 -122.369449472416 (37.7289227860515, -122.369449472416)
2417 201819 2 48 100 Friedell St 3 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021071.50009 2093300.7706900002 37.7289831323462 -122.369399226393 (37.7289831323462, -122.369399226393)
2465 201607 2 44 598 Innes Ave 2 2 1 1   07/12/2017 12:00:00 AM 1 Width 3ft   6020934.32673 2093214.8340900003 37.7287396409072 -122.36986751418699 (37.7287396409072, -122.369867514187)
2567 252819 2 55 407 Miguel St 1 2 1 1   07/19/2017 12:00:00 AM 3   Permit Number 780051 6004479.0 2096413.0 37.736604456337105 -122.426982337456 (37.7366044563371, -122.426982337456)
2611 248770 2 60 1 Cuesta Ct 4 2 1 1     17 Width 8ft   5999726.1375 2101744.56242 37.7509737525388 -122.44379789365499 (37.7509737525388, -122.443797893655)
2614 248773 2 60 1 Cuesta Ct 1 2 1 1     15 Width 8ft   5999776.82694 2101824.96428 37.751197407653706 -122.44362838043999 (37.7511974076537, -122.44362838044)
2625 248771 2 60 1 Cuesta Ct 3 2 1 1     13 Width 8ft   5999742.36883 2101773.9828 37.751055459558394 -122.4437438777 (37.7510554595584, -122.4437438777)
2626 248769 2 60 1 Cuesta Ct 5 2 1 1     14 Width 8ft   5999705.100819999 2101709.8291 37.7508771833507 -122.443868145114 (37.7508771833507, -122.443868145114)
2629 248772 2 60 1 Cuesta Ct 2 2 1 1     27 Width 8ft   5999759.8487 2101799.49731 37.7511265131926 -122.443685263491 (37.7511265131926, -122.443685263491)
2702 175365 2 12 1 Brotherhood Way 18 2 1 1     7 Width 5ft   5993296.25394 2087788.76232 37.712285726578 -122.465019407322 (37.712285726578, -122.465019407322)
2703 175367 2 12 1 Brotherhood Way 23 2 1 1     5 Width 5ft   5993394.31846 2087754.15211 37.7121963492565 -122.464677958129 (37.7121963492565, -122.464677958129)
2705 175366 2 12 1 Brotherhood Way 22 2 1 1     4 Width 5ft   5993316.47827 2087783.2739799998 37.7122718230516 -122.464949108223 (37.7122718230516, -122.464949108223)
2708 175370 2 12 1 Brotherhood Way 26 2 1 1     5 Width 5ft   5993448.13741 2087722.6413599998 37.712112930839 -122.464489658971 (37.712112930839, -122.464489658971)
2709 175364 2 12 1 Brotherhood Way 15 2 1 1     3 Width 5ft   5993263.021319999 2087797.41727 37.7123075747038 -122.465134896479 (37.7123075747038, -122.465134896479)
2716 175362 2 12 1 Brotherhood Way 10 2 1 1     6 Width 5ft   5993185.52762 2087808.44828 37.7123333942447 -122.46540353654 (37.7123333942447, -122.46540353654)
2720 175369 2 12 1 Brotherhood Way 25 2 1 1     3 Width 5ft   5993431.63462 2087732.39125 37.7121387503812 -122.46454740445101 (37.7121387503812, -122.464547404451)
2721 175371 2 12 1 Brotherhood Way 27 2 1 1     3 Width 5ft   5993471.88559 2087712.01586 37.712085124705204 -122.464406808033 (37.7120851247052, -122.464406808033)
2722 175368 2 12 1 Brotherhood Way 24 2 1 1     2 Width 5ft   5993415.10175 2087740.6954 37.7121605985029 -122.464605149022 (37.7121605985029, -122.464605149022)
2760 251575 6 3 300 Sussex St 1 2 1 1   08/02/2017 12:00:00 AM 3 3x3 Permit Number 780395 6001194.0 2096647.0 37.737060666835205 -122.438356728037 (37.7370606668352, -122.438356728037)
2814 241583 2 37 38X Java St 2 2 1 1     6 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2837 241584 2 37 38X Java St 3 2 1 1     7 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2841 241585 2 37 38X Java St 4 2 1 1     8 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2934 250407 1 2 25 Seacliff Ave 1 2 1 1   10/16/1997 12:00:00 AM 12 Width 4ft Permit Number 38521 5987994.17396 2115794.4903599997 37.78887480516529 -122.485398549405 (37.7888748051653, -122.485398549405)
2940 250421 1 2 49 Seacliff Ave 3 2 1 1     8 Width 4ft   5987880.27353 2115792.69032 37.788863226412296 -122.485792492053 (37.7888632264123, -122.485792492053)
2983 250419 1 2 49 Seacliff Ave 1 2 1 1   07/14/1997 12:00:00 AM 8 Width 4ft Permit Number 38081 5987849.1846199995 2115791.00757 37.7888567944531 -122.48589993045601 (37.7888567944531, -122.485899930456)
2985 250408 1 2 25 Seacliff Ave 2 2 1 1     12 Width 4ft   5988046.91633 2115796.65095 37.7888838100916 -122.485216228949 (37.7888838100916, -122.485216228949)
2987 250422 1 2 49 Seacliff Ave 4 2 1 1     7 Width 4ft   5987891.12003 2115793.8659200002 37.7888670862959 -122.48575505145399 (37.7888670862959, -122.485755051454)
3017 250423 1 2 49 Seacliff Ave 5 2 1 1     7 Width 4ft   5987905.22883 2115793.56651 37.7888670863011 -122.485706215587 (37.7888670863011, -122.485706215587)
3028 191362 2 195 999 Key Ave 2 2 1 1     27     6013336.3333 2089743.8780099999 37.718789267498295 -122.39589132571999 (37.7187892674983, -122.39589132572)
3029 193472 2 196 1059 Jamestown Ave 1 2 1 1     8     6013665.43892 2089838.8488900003 37.719068342415596 -122.39476037791599 (37.7190683424156, -122.394760377916)
3033 253285 2 141 8245 Geary Blvd 1 2 1 1   08/15/2017 12:00:00 AM 3     5981372.0 2112274.0 37.7788205636315 -122.50804856364901 (37.7788205636315, -122.508048563649)
3040 189089 2 74 1033 Le Conte Ave 2 2 1 1     6     6012956.43123 2089677.63232 37.718586227543504 -122.397199861797 (37.7185862275435, -122.397199861797)
3041 182178 2 28 1799X Lawton St 5 2 1 1     8 Width 0ft   5988865.0 2104441.0 37.7577519603078 -122.48155379203999 (37.7577519603078, -122.48155379204)
3065 175836 2 49 101 Rhine St 3 2 1 1     5 Width 3ft   5994366.585519999 2086543.72285 37.70892880020671 -122.46122985488998 (37.7089288002067, -122.46122985489)
3254 244746 2 9 98 12th St 1 2 1 1     15 Width 3ft   6007069.86029 2109755.10428 37.7733849739584 -122.418970623803 (37.7733849739584, -122.418970623803)
3382 122965 2 141 98 09th Ave 4 2 1 1     5 Width 5ft   5993050.799269999 2114904.9128799997 37.786725565514004 -122.467838745487 (37.786725565514, -122.467838745487)
3405 180669 2 73 171 Winding Way 3 2 1 1     0 Width 6ft   6002170.184219999 2086635.71157 37.70962739445179 -122.434266111507 (37.7096273944518, -122.434266111507)
Powered by Datasette · Query took 37.113ms · Data source: data.sfgov.org