sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3284 253385 2 53 1100 Golden Gate Ave 1 7 1 1           6004275.0 2112509.0 37.780788718892204 -122.428834805692 (37.7807887188922, -122.428834805692)
3375 253429 2 53 2198 Anza St 1 1 1 1       5x7   5992046.0 2112030.0 37.7787737730441 -122.471105555235 (37.7787737730441, -122.471105555235)
8324 106867 2 53 1974 Union St 1 1 1 1     14 3x3   6003576.11959 2118663.726 37.797648453467396 -122.431692125901 (37.7976484534674, -122.431692125901)
19652 99912 2 53 3751X Fair Oaks St 1 1 1 1       3x3   6005509.050559999 2101091.11643 37.7495076933522 -122.42375353501998 (37.7495076933522, -122.42375353502)
23924 215624 2 53 900 Junipero Serra Blvd 66 4 1 1     4 Width 0ft   5991139.11135 2090614.21248 37.7199191010706 -122.47268094048201 (37.7199191010706, -122.472680940482)
24510 142976 2 53 392 CHESTNUT ST 1 1 1 1     17 Width 0ft   6009963.6556 2120937.6931 37.80425219968421 -122.409750018417 (37.8042521996842, -122.409750018417)
25535 180581 2 53 1394 Alemany Blvd 1 1 1 1     22 Width 5ft   6002394.23037 2093854.8065099998 37.72946213735921 -122.434007462878 (37.7294621373592, -122.434007462878)
26083 123491 2 53 600 Arguello Blvd 1 2 1 1     30     5995674.45752 2111730.9534 37.77816187055421 -122.458531727532 (37.7781618705542, -122.458531727532)
26368 137075 2 53 689 Hayes St 1 4 1 1     24 Width 5ft   6004617.552730001 2110839.21576 37.776223284701 -122.42753075415001 (37.776223284701, -122.42753075415)
28271 215581 2 53 751 Junipero Serra Blvd 9 2 1 1     25 Width 3ft   5991373.01779 2092318.20321 37.7246113758903 -122.471996546509 (37.7246113758903, -122.471996546509)
29922 215600 2 53 700 Junipero Serra Blvd 67 4 1 1     13 Width 0ft   5991265.7011400005 2092317.6532400001 37.724603655215894 -122.472367482699 (37.7246036552159, -122.472367482699)
30170 180579 2 53 2500 Bay Shore Blvd 3 1 1 1     21 Width 4ft   6010790.74354 2086511.28723 37.7097712796836 -122.404463040238 (37.7097712796836, -122.404463040238)
30230 199847 2 53 1611 Armstrong Ave 5 1 1 1     30 Width 0ft   6014254.2532 2092550.5249 37.7265467847844 -122.392914674805 (37.7265467847844, -122.392914674805)
31393 123644 2 53 445 Arguello Blvd 2 1 1 1     17 Width 3ft   5995555.16132 2113176.03479 37.78212282277371 -122.45904907539101 (37.7821228227737, -122.459049075391)
33957 137078 2 53 1639 Taylor St 4 1 1 1     4 Width 3ft   6008753.16727 2118586.36158 37.7977281199218 -122.413772601749 (37.7977281199218, -122.413772601749)
34555 180593 2 53 2136 Alemany Blvd 1 1 1 1     20 Width 4ft   6000017.35738 2089840.46995 37.718304512220605 -122.44193650477699 (37.7183045122206, -122.441936504777)
34624 142237 2 53 689 HAYES ST 4 1 1 1     18 Width 0ft   6004726.9033 2110859.9695 37.7762864537737 -122.42715395911101 (37.7762864537737, -122.427153959111)
34747 123483 2 53 600 Arguello Blvd 9 2 1 1     34     5995662.44998 2111958.25695 37.7787852957742 -122.458589724568 (37.7787852957742, -122.458589724568)
34942 215575 2 53 95 Kirkham St 3 2 1 1     41 Width 3ft   5994715.1652 2105292.6604299997 37.76042882975 -122.461383388048 (37.76042882975, -122.461383388048)
36173 137082 2 53 1627 Taylor St 2 1 1 1     3 Width 3ft   6008777.375519999 2118389.76877 37.7971896841052 -122.413674921875 (37.7971896841052, -122.413674921875)
36497 215645 2 53 900 Junipero Serra Blvd 88 4 1 1     15 Width 0ft   5991139.08964 2090556.8339200001 37.7197615524271 -122.47267683419099 (37.7197615524271, -122.472676834191)
36799 123470 2 53 778 02nd Ave 1 1 1 1     20 Width 3ft   5995383.59468 2110411.0672400002 37.7745210919414 -122.45944230753099 (37.7745210919414, -122.459442307531)
36822 215590 2 53 501 Junipero Serra Blvd 1 2 1 1     26 Width 3ft   5991474.9385 2093941.2931 37.729073873942795 -122.47176245478701 (37.7290738739428, -122.471762454787)
37126 124641 2 53 60 Arguello Blvd 1 2 1 1     15 Width 3ft   5995529.17868 2115583.09769 37.7887304767053 -122.459313330112 (37.7887304767053, -122.459313330112)
37233 105882 2 53 250 Locust St 3 1 1 1     19     5997612.13513 2115509.12693 37.78864690886571 -122.45210129905001 (37.7886469088657, -122.45210129905)
37355 124688 2 53 460 Arguello Blvd 9 1 1 1     19 Width 4ft   5995612.537930001 2113341.5687 37.782580632849395 -122.458862568059 (37.7825806328494, -122.458862568059)
37961 185716 2 53 2101 Sunset Blvd 48 9 1 1     2 Width 0ft   5984901.6243 2100400.4346 37.746426426174395 -122.49496265549601 (37.7464264261744, -122.494962655496)
38027 215623 2 53 900 Junipero Serra Blvd 65 4 1 1     7 Width 0ft   5991145.2526 2090614.88415 37.7199213008035 -122.472659761464 (37.7199213008035, -122.472659761464)
38177 215644 2 53 900 Junipero Serra Blvd 87 4 1 1     4 Width 0ft   5991153.983659999 2090558.88602 37.7197680491356 -122.472625500878 (37.7197680491356, -122.472625500878)
38271 215583 2 53 751 Junipero Serra Blvd 12 2 1 1     25 Width 3ft   5991379.44831 2092444.8187099998 37.7249594027384 -122.471983541404 (37.7249594027384, -122.471983541404)
38305 116138 2 53 1601X Armstrong Ave 10 1 1 3     30     6014404.0852 2092434.1919 37.7262356791342 -122.39238857399599 (37.7262356791342, -122.392388573996)
39237 215650 2 53 900 Junipero Serra Blvd 101 4 1 1     14 Width 0ft   5991145.973069999 2090449.2056 37.7194664300225 -122.472645197812 (37.7194664300225, -122.472645197812)
39462 215649 2 53 900 Junipero Serra Blvd 93 4 1 1     4 Width 0ft   5991151.37081 2090546.73366 37.7197345305043 -122.472633646933 (37.7197345305043, -122.472633646933)
39612 215615 2 53 900 Junipero Serra Blvd 57 4 1 1     14 Width 0ft   5991138.24471 2090632.0819 37.719968115927 -122.472685238326 (37.719968115927, -122.472685238326)
40956 242792 2 53 1200 San Jose Ave 12 7 1 1     37     6003987.76148 2095934.3227099997 37.7352623274905 -122.42864664822399 (37.7352623274905, -122.428646648224)
41079 215635 2 53 900 Junipero Serra Blvd 78 4 1 1     3 Width 0ft   5991140.257019999 2090584.0200099999 37.7198362663069 -122.47267478013 (37.7198362663069, -122.47267478013)
41864 215599 2 53 700 Junipero Serra Blvd 52 4 1 1     14 Width 0ft   5991273.40065 2092440.71249 37.724941990971395 -122.47234983348999 (37.7249419909714, -122.47234983349)
42957 137072 2 53 3598 Clay St 2 2 1 1     26 Width 4ft   5997679.8137 2115460.2442400004 37.788516566519604 -122.451863614513 (37.7885165665196, -122.451863614513)
43417 215627 2 53 900 Junipero Serra Blvd 69 4 1 1     13 Width 0ft   5991161.91923 2090597.1686900002 37.7198736232612 -122.472600860338 (37.7198736232612, -122.472600860338)
44014 215580 2 53 751 Junipero Serra Blvd 6 2 1 1     24 Width 3ft   5991366.74972 2092229.04743 37.7243662135233 -122.47201171896499 (37.7243662135233, -122.472011718965)
44608 215594 2 53 246 Sagamore St 1 1 1 1     15 Width 4ft   5994531.01193 2087471.53389 37.7114858129011 -122.46072877062299 (37.7114858129011, -122.460728770623)
44990 215603 2 53 700 Junipero Serra Blvd 168 4 1 1     16 Width 0ft   5991175.95809 2091313.6332900003 37.7218416708418 -122.47260454218399 (37.7218416708418, -122.472604542184)
46257 97505 2 53 20X 10th St 2 1 1 1   10/18/2011 12:00:00 AM 12 3x3 Permit Number 768079 6007672.0 2110712.0 37.7760462700595 -122.416955543158 (37.7760462700595, -122.416955543158)
47125 123486 2 53 600 Arguello Blvd 6 2 1 1     24     5995665.690219999 2111872.7664900003 37.7785507478592 -122.458572325088 (37.7785507478592, -122.458572325088)
48389 182457 2 53 1500 31st Ave 5 2 1 1     27 Width 0ft   5986548.9803 2104732.6813 37.7584178970063 -122.48958488521099 (37.7584178970063, -122.489584885211)
49070 137073 2 53 3598 Clay St 3 2 1 1     16 Width 4ft   5997662.024569999 2115459.05462 37.7885122812527 -122.45192507598699 (37.7885122812527, -122.451925075987)
52498 123489 2 53 600 Arguello Blvd 3 2 1 1     20     5995672.03179 2111788.60232 37.7783200198099 -122.458544293173 (37.7783200198099, -122.458544293173)
52532 124686 2 53 460 Arguello Blvd 11 1 1 1     16 Width 4ft   5995607.11329 2113402.43136 37.7827474336358 -122.458885742796 (37.7827474336358, -122.458885742796)
53965 215613 2 53 900 Junipero Serra Blvd 54 4 1 1     6 Width 0ft   5991146.23554 2090648.32868 37.720013188138296 -122.47265880098699 (37.7200131881383, -122.472658800987)
54677 215629 2 53 900 Junipero Serra Blvd 72 4 1 1     6 Width 0ft   5991145.86247 2090596.3241400002 37.7198703748925 -122.47265630087 (37.7198703748925, -122.47265630087)
54701 215577 2 53 95 Kirkham St 5 2 1 1     48 Width 3ft   5994760.78175 2105295.21675 37.7604384740771 -122.461225807922 (37.7604384740771, -122.461225807922)
54836 215643 2 53 900 Junipero Serra Blvd 86 4 1 1     7 Width 0ft   5991150.43358 2090559.55238 37.7197696732999 -122.47263782068701 (37.7197696732999, -122.472637820687)
55354 215614 2 53 900 Junipero Serra Blvd 55 4 1 1     5 Width 0ft   5991140.92054 2090646.29638 37.7200073002795 -122.472677024844 (37.7200073002795, -122.472677024844)
57358 215626 2 53 900 Junipero Serra Blvd 68 4 1 1     3 Width 0ft   5991156.30566 2090612.66695 37.7199158527268 -122.47262139367099 (37.7199158527268, -122.472621393671)
57951 199844 2 53 1617 Armstrong Ave 2 1 1 1     32 Width 0ft   6014142.1837 2092625.4409 37.7267462633936 -122.39330733792801 (37.7267462633936, -122.393307337928)
58162 180588 2 53 1447 Alemany Blvd 3 1 1 1     19 Width 5ft   6002392.55611 2093716.4847400002 37.729082242150795 -122.434003367375 (37.7290822421508, -122.434003367375)
58824 215633 2 53 900 Junipero Serra Blvd 76 4 1 1     4 Width 0ft   5991148.619390001 2090586.20981 37.719842763020104 -122.472646034205 (37.7198427630201, -122.472646034205)
60171 242791 2 53 1001 San Jose Ave 14 7 1 1     5     6005175.70924 2096892.8816200001 37.7379614744454 -122.424607638258 (37.7379614744454, -122.424607638258)
60841 215593 2 53 103 Sagamore St 1 1 1 1     17 Width 3ft   5995757.42889 2087376.9000799998 37.7112964570463 -122.45648314049801 (37.7112964570463, -122.456483140498)
62090 215597 2 53 700 Junipero Serra Blvd 44 4 1 1     15 Width 0ft   5991275.01695 2092498.39745 37.7251004730822 -122.47234844942498 (37.7251004730822, -122.472348449425)
62104 215587 2 53 751 Junipero Serra Blvd 29 2 1 1     27 Width 3ft   5991411.41096 2092949.8935 37.7263480620905 -122.47190984556002 (37.7263480620905, -122.47190984556)
62692 215609 2 53 900 Junipero Serra Blvd 49 4 1 1     6 Width 0ft   5991151.21969 2090669.8888599998 37.7200726755881 -122.472643143781 (37.7200726755881, -122.472643143781)
63629 215620 2 53 900 Junipero Serra Blvd 62 4 1 1     3 Width 0ft   5991138.86268 2090625.2601299998 37.7199494208 -122.472682605115 (37.7199494208, -122.472682605115)
64611 215646 2 53 900 Junipero Serra Blvd 89 4 1 1     21 Width 0ft   5991144.95252 2090553.1611900001 37.71975180739361 -122.47265630084999 (37.7197518073936, -122.47265630085)
64737 215641 2 53 900 Junipero Serra Blvd 84 4 1 1     24 Width 0ft   5991139.80827 2090562.73433 37.719777795098 -122.472674780143 (37.719777795098, -122.472674780143)
65202 215616 2 53 900 Junipero Serra Blvd 58 4 1 1     18 Width 0ft   5991145.54579 2090633.2217299999 37.719971668250295 -122.472660084316 (37.7199716682503, -122.472660084316)
66690 137069 2 53 7 Laurel St 3 1 1 1     15 Width 3ft   5997939.35301 2116349.8609700003 37.7909740791344 -122.45102982968099 (37.7909740791344, -122.451029829681)
66806 123958 2 53 295 07th Ave 5 1 1 1     12 Width 3ft   5993672.37881 2113557.39213 37.7830615134244 -122.46559031264799 (37.7830615134244, -122.465590312648)
66816 124642 2 53 50 Arguello Blvd 1 1 1 1     10 Width 3ft   5995529.95307 2115590.13506 37.7887498439417 -122.459311160683 (37.7887498439417, -122.459311160683)
69626 180591 2 53 1804 Alemany Blvd 1 1 1 1     22 Width 4ft   6001183.24158 2091479.89441 37.72287237033329 -122.438023911598 (37.7228723703333, -122.438023911598)
69819 180585 2 53 177 Santa Rosa Ave 2 1 1 1     3 Width 2ft   6001325.27813 2093179.51545 37.7275472199251 -122.43765458428999 (37.7275472199251, -122.43765458429)
70741 215579 2 53 851 Junipero Serra Blvd 12 2 1 1     12 Width 3ft   5991331.01602 2091664.09591 37.7228129287478 -122.472094084291 (37.7228129287478, -122.472094084291)
70971 215639 2 53 900 Junipero Serra Blvd 82 4 1 1     8 Width 0ft   5991150.62056 2090568.4216099998 37.719794036843794 -122.472637820681 (37.7197940368438, -122.472637820681)
72396 180590 2 53 1159 Alemany Blvd 3 1 1 1     24 Width 4ft   6003628.44812 2094335.41976 37.7308517598817 -122.429774919684 (37.7308517598817, -122.429774919684)
72604 180587 2 53 1473 Alemany Blvd 2 1 1 1     23 Width 4ft   6002172.86661 2093413.1451700001 37.7282368704302 -122.434741167586 (37.7282368704302, -122.434741167586)
73830 215605 2 53 900 Junipero Serra Blvd 39 4 1 1     6 Width 0ft   5991158.3667 2090738.6198 37.7202618075092 -122.472623447724 (37.7202618075092, -122.472623447724)
74903 215591 2 53 233 Sagamore St 1 1 1 1     15 Width 3ft   5994635.3694400005 2087388.76073 37.711264541001206 -122.460362092762 (37.7112645410012, -122.460362092762)
74958 180583 2 53 1114 Alemany Blvd 1 1 1 1     25 Width 4ft   6003761.56491 2094470.84041 37.731231131690706 -122.42932436652599 (37.7312311316907, -122.429324366526)
75277 215631 2 53 900 Junipero Serra Blvd 74 4 1 1     4 Width 0ft   5991145.11917 2090589.24121 37.719850883885606 -122.472658354026 (37.7198508838856, -122.472658354026)
75801 180584 2 53 1114 Alemany Blvd 2 1 1 1     22 Width 4ft   6003732.95256 2094463.1481400002 37.7312083905422 -122.42942273618601 (37.7312083905422, -122.429422736186)
76067 215578 2 53 851 Junipero Serra Blvd 7 2 1 1     25 Width 3ft   5991318.68956 2091495.76578 37.7223500225082 -122.47212443011101 (37.7223500225082, -122.472124430111)
76669 215596 2 53 500 Junipero Serra Blvd 52 4 1 1     13 Width 0ft   5991321.6635 2093392.1066299998 37.7275570755768 -122.472252316385 (37.7275570755768, -122.472252316385)
77050 181893 2 53 2370 29th Ave 1 2 1 1     14 Width 0ft   5987361.9916 2099162.5217 37.7431711693476 -122.486364226347 (37.7431711693476, -122.486364226347)
77875 106884 2 53 180X SAN MARCOS AVE 6 11 1 1 4   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
77976 99913 2 53 3751X Fair Oaks St 2 1 1 1       3x3 Permit Number 768933 6005509.050559999 2101091.11643 37.7495076933522 -122.42375353501998 (37.7495076933522, -122.42375353502)
87541 121665 2 53 100 Montalvo Ave 1 1 1 1       3x6   5993653.0 2099666.0 37.7449182738718 -122.46464831295299 (37.7449182738718, -122.464648312953)
89632 215576 2 53 95 Kirkham St 4 2 1 1     39 Width 3ft   5994736.06961 2105294.2713 37.7604344559039 -122.461311206651 (37.7604344559039, -122.461311206651)
94262 106880 2 53 180X SAN MARCOS AVE 3 11 1 1 4   5     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
99073 108311 2 53 439x ARLINGTON ST 1 13 1 1           6003949.9 2096014.9 37.7354814316621 -122.42878329168998 (37.7354814316621, -122.42878329169)
104261 137068 2 53 7 Laurel St 2 1 1 1     16 Width 3ft   5997936.78651 2116362.08959 37.7910075087313 -122.45103959183001 (37.7910075087313, -122.45103959183)
104287 215601 2 53 700 Junipero Serra Blvd 155 4 1 1     15 Width 0ft   5991211.33426 2091424.54649 37.7221482587196 -122.472490339055 (37.7221482587196, -122.472490339055)
109973 99911 2 53 400 Fair Oaks St 1 1 1 1       3x3   6005460.7 2101331.3 37.750164452601794 -122.42393781012501 (37.7501644526018, -122.423937810125)
117028 137076 2 53 689 Hayes St 4 4 1 1     19 Width 4ft   6004731.627309999 2110853.90859 37.776270079140396 -122.427137185641 (37.7762700791404, -122.427137185641)
125523 106883 2 53 180X SAN MARCOS AVE 4 11 1 1 4   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
129670 215602 2 53 700 Junipero Serra Blvd 166 4 1 1     4 Width 0ft   5991204.303730001 2091328.4883700002 37.7218840999401 -122.47250764202101 (37.7218840999401, -122.472507642021)
129875 215617 2 53 900 Junipero Serra Blvd 59 4 1 1     6 Width 0ft   5991151.604669999 2090631.8002400002 37.71996811591 -122.47263903747299 (37.71996811591, -122.472639037473)
129995 215632 2 53 900 Junipero Serra Blvd 75 4 1 1     7 Width 0ft   5991152.25672 2090589.68226 37.7198525080596 -122.472633714394 (37.7198525080596, -122.472633714394)
130396 215622 2 53 900 Junipero Serra Blvd 64 4 1 1     3 Width 0ft   5991146.64961 2090624.8002099998 37.7199486087273 -122.472655655135 (37.7199486087273, -122.472655655135)
131994 199846 2 53 1613 Armstrong Ave 4 1 1 1     30 Width 0ft   6014210.3999 2092579.1513 37.726622951149395 -122.393068277245 (37.7266229511494, -122.393068277245)
133362 185690 2 53 2101 Sunset Blvd 22 9 1 1     14 Width 0ft   5984904.8934 2100540.6767 37.7468116841536 -122.494961690438 (37.7468116841536, -122.494961690438)
133658 180592 2 53 1804 Alemany Blvd 3 1 1 1     33 Width 4ft   6001143.73267 2091406.4041400002 37.72266833577 -122.438155223402 (37.72266833577, -122.438155223402)
Powered by Datasette · Query took 59.136ms · Data source: data.sfgov.org