sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
45548 45657 1 53 1330 Union St 1 1 1 1   08/13/2001 12:00:00 AM 18   Permit Number 44353 6006609.23369 2119082.98627 37.798971095388396 -122.421226497612 (37.7989710953884, -122.421226497612)
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)
50637 117189 1 53 1335 Washington St 2 1 1 1     12 3x3   6008262.17379 2117224.41185 37.793960957890896 -122.415375111785 (37.7939609578909, -122.415375111785)
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)
54703 39229 1 53 1335 Washington St 1 1 1 1   12/04/1998 12:00:00 AM 15 3x3 Permit Number 40871 6008226.63206 2117220.6849599998 37.793948727108 -122.41549782608699 (37.793948727108, -122.415497826087)
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)
56269 1048 3 53 2029X Alemany Blvd 1 1 1 2       3X3   6000595.57615 2090275.75201 37.719532630863 -122.439969044998 (37.719532630863, -122.439969044998)
57260 242793 3 53 2x Coso Ave 1 3 1 2     30 Width 9ft   6007083.58829 2099965.0449 37.746504513177 -122.418228897148 (37.746504513177, -122.418228897148)
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)
61015 242794 3 53 2x Coso Ave 4 3 1 2     30     6007112.52178 2099889.35747 37.746298321115 -122.418123483128 (37.746298321115, -122.418123483128)
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)
69286 58907 1 53 354 Peninsula Ave 1 1 1 1   03/07/1980 12:00:00 AM 29   Permit Number 18182 6012260.63611 2086890.34143 37.7108941228427 -122.39940938545601 (37.7108941228427, -122.399409385456)
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)
72528 392 3 53 3790X 19th Ave 3 1 1 2     19 2   5990516.36157 2090620.3648599999 37.7198999256056 -122.47483399727899 (37.7198999256056, -122.474833997279)
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)
77659 7482 3 53 2650X Folsom St 10 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
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)
79283 21830 3 53 1419X Alemany Blvd 2 1 1 2     12 3X6   6002361.46709 2093663.80125 37.7289358208429 -122.43410707985599 (37.7289358208429, -122.434107079856)
79297 11696 1 53 799X Junipero Serra Blvd 15 1 1 13     30 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
79677 10721 3 53 50X Hollis St 8 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
79844 1477 3 53 245 Arguello Blvd 1 1 1 2     35 3X3   5995501.2635699995 2114653.66128 37.7861768902412 -122.45934257653799 (37.7861768902412, -122.459342576538)
79845 933 3 53 1294X Alemany Blvd 1 1 1 2     30 3x3   6002802.17626 2094143.63343 37.7302783338422 -122.432617778446 (37.7302783338422, -122.432617778446)
80029 11626 3 53 300X Junipero Serra Blvd 5 1 1 2     12 4X4   5991444.7104442 2094652.0546396 37.7310236980815 -122.471918736195 (37.7310236980815, -122.471918736195)
80768 10719 3 53 50X Hollis St 6 1 1 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
81090 6279 3 53 1475 Ellis St 2 1 1 2     12 4X4   6003832.24761 2113162.85488 37.782558971887205 -122.430413166544 (37.7825589718872, -122.430413166544)
82094 1645 3 53 881 Arguello Blvd 1 1 1 2     35 6X6   5995652.78213 2110475.54294 37.7747135991516 -122.458515810277 (37.7747135991516, -122.458515810277)
82113 929 3 53 1286X Alemany Blvd 1 1 1 2     25 3x3   6002834.53778 2094157.0386599998 37.73031697676271 -122.432506857514 (37.7303169767627, -122.432506857514)
82725 11620 3 53 80X Junipero Serra Blvd 19 1 1 2     24 2X2   5991396.1674726 2095410.2239213001 37.7331026312309 -122.472141799028 (37.7331026312309, -122.472141799028)
83287 1622 3 53 781 Arguello Blvd 1 1 1 2     21 3X4   5995639.652530001 2110927.44628 37.7759536520848 -122.45859394843201 (37.7759536520848, -122.458593948432)
83537 1032 3 53 1989X Alemany Blvd 2 1 1 2     60 3X6   6000752.12664 2090469.86783 37.7200745396752 -122.439441815719 (37.7200745396752, -122.439441815719)
83607 1433 3 53 100X Arguello Blvd 1 1 1 2     30 5X5   5995535.85964 2115388.7214900004 37.7881971563264 -122.459276133553 (37.7881971563264, -122.459276133553)
83779 1867 3 53 2555 Bay Shore Blvd 8 1 1 2     18 3x3   6010748.9210869 2086419.1045134 37.7095158271004 -122.404601102054 (37.7095158271004, -122.404601102054)
84012 1042 3 53 1999X Alemany Blvd 4 1 1 2     40 4X4   6000738.08152 2090455.78835 37.72003508127371 -122.439489356062 (37.7200350812737, -122.439489356062)
84024 11677 3 53 700X Junipero Serra Blvd 10 1 1 2     24 4x4   5991320.9947906 2093088.5989831001 37.7267236805691 -122.472232513363 (37.7267236805691, -122.472232513363)
84863 1182 3 53 3003 Alemany Blvd 2 1 1 2     24 3x3   5996737.10872 2087300.2249 37.7111421206036 -122.45309160658 (37.7111421206036, -122.45309160658)
85463 1534 3 53 470X Arguello Blvd 3 1 1 2     125 3X3   5995618.147655 2113146.451022 37.7820452142616 -122.458829030077 (37.7820452142616, -122.458829030077)
85887 117255 3 53 1570 31ST AVE 3 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
85915 11690 1 53 799X Junipero Serra Blvd 6 1 1 13     30 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
86397 239 1 53 3010X 19th Ave 1 1 1 5     90 2   5990623.3177 2095139.449 37.73231439650579 -122.474793962374 (37.7323143965058, -122.474793962374)
86527 397 3 53 3790X 19th Ave 8 1 1 2     30 2   5990474.691459999 2090771.6766099997 37.720312975301 -122.474989074306 (37.720312975301, -122.474989074306)
86707 7464 1 53 2599 Folsom St 1 1 1 1     60 3X3   6008286.46562 2103308.5385 37.7557526290701 -122.41430599230301 (37.7557526290701, -122.414305992303)
86737 1428 3 53 75X Arguello Blvd 1 1 1 2     100 5   5995465.63795 2115574.8643900002 37.78870421691 -122.459532573841 (37.78870421691, -122.459532573841)
86841 7477 3 53 2650X Folsom St 5 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
87059 1438 1 53 101X Arguello Blvd 4 1 1 1     35 5   5995477.38208 2115292.8933900003 37.787930676078794 -122.45947151175501 (37.7879306760788, -122.459471511755)
87254 7476 3 53 2650X Folsom St 4 1 1 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
87541 121665 2 53 100 Montalvo Ave 1 1 1 1       3x6   5993653.0 2099666.0 37.7449182738718 -122.46464831295299 (37.7449182738718, -122.464648312953)
87555 19303 1 53 2087X Alemany Blvd 2 1 1 1     35 3X3   6000281.49897 2089976.15715 37.7186921269443 -122.44103321029101 (37.7186921269443, -122.441033210291)
87605 1441 3 53 138 Arguello Blvd 1 1 1 2     42 5X5   5995537.91826 2115271.42403 37.7878752075455 -122.459260513654 (37.7878752075455, -122.459260513654)
87989 395 3 53 3790X 19th Ave 6 1 1 2     32 2   5990486.24663 2090696.51982 37.720107283055604 -122.474943649084 (37.7201072830556, -122.474943649084)
88057 883 3 53 1100X ALEMANY BLVD 1 1 1 2     30 3X6   6003437.0 2094359.0 37.7309056628368 -122.43043846836599 (37.7309056628368, -122.430438468366)
88173 6271 1 53 1420X Ellis St 1 1 1 1     18 4X4   6004021.46971 2113238.82139 37.782778273754104 -122.429763959937 (37.7827782737541, -122.429763959937)
88210 11676 3 53 700X Junipero Serra Blvd 9 1 1 2     24 4x4   5991320.9947906 2093088.5989831001 37.7267236805691 -122.472232513363 (37.7267236805691, -122.472232513363)
88227 51907 1 53 157 Day St 2 1 1 1   07/18/2005 12:00:00 AM     Permit Number 48113 6004926.17092668 2098691.36646376 37.7428856098168 -122.42559837996599 (37.7428856098168, -122.425598379966)
88504 19105 3 53 3155X Alemany Blvd 1 1 1 2     32 3x3   5995592.56281 2086919.9321700002 37.7100322629968 -122.457019923286 (37.7100322629968, -122.457019923286)
88556 11694 1 53 799X Junipero Serra Blvd 11 1 1 13     18 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
89099 6281 3 53 1475 Ellis St 4 1 1 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
89332 391 3 53 3790X 19th Ave 2 1 1 2     34 2   5990530.65648 2090591.3498 37.7198210858115 -122.474782468587 (37.7198210858115, -122.474782468587)
89521 6272 1 53 1420X Ellis St 2 1 1 1     18 4X4   6003992.005369999 2113234.0209999997 37.782763424573005 -122.429865551596 (37.782763424573, -122.429865551596)
Powered by Datasette · Query took 2.581ms · Data source: data.sfgov.org