sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
64050 139028 2 54 2501 SUTTER ST 4 1 1 1     0 Width 0ft   6000547.3036 2114093.8303 37.7849285655089 -122.44184446112301 (37.7849285655089, -122.441844461123)
1410 139164 2 54 1975 POST ST 5 1 1 1       Width 0ft   6002726.0596 2114048.1262 37.784926980365206 -122.43430340574699 (37.7849269803652, -122.434303405747)
36994 139027 2 54 2501 SUTTER ST 3 1 1 1     0 Width 0ft   6000525.7297 2114092.4384 37.784923514385 -122.441918999732 (37.784923514385, -122.441918999732)
49578 139026 2 54 2501 SUTTER ST 2 1 1 1     0 Width 0ft   6000502.7639999995 2114090.3506 37.784916473139894 -122.44199830353001 (37.7849164731399, -122.44199830353)
7654 139157 2 54 1699 FILLMORE ST 3 1 1 1       Width 0ft   6003069.5459 2114034.3612 37.7849086753549 -122.433114070807 (37.7849086753549, -122.433114070807)
132579 139025 2 54 2501 SUTTER ST 1 1 1 1     0 Width 0ft   6000486.0616 2114086.871 37.7849059672476 -122.442055838439 (37.7849059672476, -122.442055838439)
168796 139024 2 54 2511 SUTTER ST 2 1 1 1     0 Width 0ft   6000470.0552 2114083.3913 37.78489550071689 -122.442110965396 (37.7848955007169, -122.442110965396)
52327 139022 2 54 2557 SUTTER ST 4 1 1 1     0 Width 0ft   6000419.2522 2114077.8239 37.784877318741 -122.44228632704201 (37.784877318741, -122.442286327042)
156101 139019 2 54 2557 SUTTER ST 1 1 1 1     0 Width 0ft   6000372.6248 2114069.4727 37.7848517309131 -122.442447042495 (37.7848517309131, -122.442447042495)
59014 139029 2 54 1535 Broderick St 2 1 1 1     0 Width 0ft   6000616.8967 2114052.0744 37.784817879809204 -122.441600694473 (37.7848178798092, -122.441600694473)
73809 139018 2 54 2569 SUTTER ST 7 1 1 1     0 Width 0ft   6000314.1665 2114058.3378 37.784817825136706 -122.44264848882601 (37.7848178251367, -122.442648488826)
72583 114625 2 54 2400X Post St 11 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
80039 114619 2 54 2400X Post St 4 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
83119 114623 2 54 2400X Post St 8 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
83415 114615 2 54 2400X Post St 2 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
83855 114626 2 54 2400X Post St 12 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
87576 114627 2 54 2400X Post St 13 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
89960 114628 2 54 2400X Post St 14 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
96844 114629 2 54 2400X Post St 15 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
97624 114622 2 54 2400X Post St 7 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
99135 114630 2 54 2400X Post St 16 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
109941 114620 2 54 2400X Post St 5 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
115565 114618 2 54 2400X Post St 3 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
120303 114621 2 54 2400X Post St 6 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
54538 139014 2 54 2569 SUTTER ST 3 1 1 1     0 Width 0ft   6000244.5734 2114049.2907 37.7847890167684 -122.442888607586 (37.7847890167684, -122.442888607586)
38604 139030 2 54 1535 Broderick St 3 1 1 1     0 Width 0ft   6000620.3764 2114029.1087 37.784755020167395 -122.441587007239 (37.7847550201674, -122.441587007239)
168900 139031 2 54 1535 Broderick St 4 1 1 1     0 Width 0ft   6000623.856000001 2114017.2778 37.784722733809 -122.441574119703 (37.784722733809, -122.441574119703)
180411 139043 2 54 1434 BAKER ST 4 1 1 1     0 Width 0ft   6000190.2907 2114006.1429 37.7846674491742 -122.443073307519 (37.7846674491742, -122.443073307519)
161034 140786 2 54 72 COMMONWEALTH AVE 1 2 1 1     0 Width 0ft   5996552.5125 2114073.3864 37.784643994956 -122.455663594493 (37.784643994956, -122.455663594493)
39868 142767 2 54 724 LARKIN ST 1 1 1 1     0 Width 0ft   6007520.0381 2113832.9802 37.7846071803113 -122.41770248523599 (37.7846071803113, -122.417702485236)
46800 141745 2 54 1595 GEARY BLVD 10 1 1 1     0 Width 0ft   6004047.2174 2113886.8031 37.7845589275233 -122.429721115021 (37.7845589275233, -122.429721115021)
60875 138281 2 54 2181 Post St 5 1 1 1     0 Width 0ft   6001824.7124 2113924.8454 37.784537281287896 -122.437412940551 (37.7845372812879, -122.437412940551)
124115 139041 2 54 1434 BAKER ST 2 1 1 1     0 Width 0ft   6000198.6419 2113946.9888 37.7845055034656 -122.443040165571 (37.7845055034656, -122.443040165571)
92851 7876 3 54 1095X Franklin St 1 1 1 2   03/04/2011 12:00:00 AM 3 3x3   6006012.62101 2113826.37447 37.784504100894395 -122.42291717866101 (37.7845041008944, -122.422917178661)
31070 138278 2 54 2181 Post St 2 1 1 1     0 Width 0ft   6001737.3169 2113910.2795 37.784492318138106 -122.437714255164 (37.7844923181381, -122.437714255164)
156816 139034 2 54 1501 BRODERICK ST 1 1 1 1     0 Width 0ft   6000637.7747 2113931.6783 37.7844884926143 -122.441519821021 (37.7844884926143, -122.441519821021)
137192 140325 2 54 1455 LAGUNA ST 1 1 1 1     0 Width 0ft   6004557.9993 2113847.3125 37.7844794061151 -122.42795116719601 (37.7844794061151, -122.427951167196)
51353 138277 2 54 2181 Post St 1 1 1 1     0 Width 0ft   6001707.4914 2113906.1178 37.784479195254995 -122.437817142826 (37.784479195255, -122.437817142826)
183313 139054 2 54 1480 Lyon St 3 1 1 1     0 Width 0ft   5999713.5777 2113947.3354 37.78447878674479 -122.44471834133499 (37.7844787867448, -122.444718341335)
184028 139040 2 54 1434 BAKER ST 1 1 1 1     0 Width 0ft   6000201.4256 2113926.1108 37.7844483365891 -122.44302903507099 (37.7844483365891, -122.443029035071)
5224 253827 1 54 825 Polk St 1 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5228 253828 1 54 825 Polk St 2 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
69387 139039 2 54 1501 BRODERICK ST 6 1 1 1     0 Width 0ft   6000650.9974 2113849.5584 37.7842637658196 -122.441468180362 (37.7842637658196, -122.441468180362)
5222 253825 1 54 725 Ellis St 1 1 1 1 4     3x3   6007393.727109999 2113660.9435900003 37.784127700976896 -122.418127279043 (37.7841277009769, -122.418127279043)
172733 140806 2 54 530 EUCLID AVE 1 2 1 1     0 Width 0ft   5996678.7438 2113864.2417 37.7840769823676 -122.45521175977501 (37.7840769823676, -122.455211759775)
72123 139091 2 54 1408 LYON ST 1 1 1 1     0 Width 0ft   5999733.102000001 2113785.5627 37.7840357150055 -122.44463916277901 (37.7840357150055, -122.444639162779)
39749 139753 2 54 1171 Gough St 1 1 1 1     0 Width 0ft   6005547.6328 2113641.325 37.7839697525349 -122.424512713511 (37.7839697525349, -122.424512713511)
68182 140334 2 54 1561 FILLMORE ST 1 1 1 1     0 Width 0ft   6003122.307 2113686.3043 37.7839559916453 -122.43290666022301 (37.7839559916453, -122.432906660223)
28319 139084 2 54 2512 Post St 2 1 1 1     0 Width 0ft   6000122.7854 2113741.6890000002 37.7839374779531 -122.443287851631 (37.7839374779531, -122.443287851631)
92536 114785 1 54 2459 Post St 1 1 1 1   12/09/2015 12:00:00 AM       6000398.9 2113706.0 37.7838552262656 -122.44233003645701 (37.7838552262656, -122.442330036457)
5211 253829 1 54 869 Ellis St 1 1 1 1 4     3x3   6006713.1749 2113568.2957099997 37.7838349840749 -122.420475171434 (37.7838349840749, -122.420475171434)
189029 140863 2 54 106 JORDAN AVE 1 2 1 1     0 Width 0ft   5996246.41 2113718.2127 37.7836512118011 -122.45669690496901 (37.7836512118011, -122.456696904969)
149988 141161 2 54 2007 Geary Blvd 8 1 1 1     0 Width 0ft   6002005.8356 2113598.0542 37.7836502911761 -122.43676291583598 (37.7836502911761, -122.436762915836)
48404 141143 2 54 2011 Geary Blvd 6 1 1 1     0 Width 0ft   6001931.7546 2113588.2444 37.783619145517896 -122.43701850487301 (37.7836191455179, -122.437018504873)
74672 140885 2 54 112 COMMONWEALTH AVE 1 2 1 1     0 Width 0ft   5996566.0494 2113683.1859999998 37.7835733852629 -122.45558854835899 (37.7835733852629, -122.455588548359)
28402 137551 2 54 1526 Steiner St 7 1 1 1     0 Width 0ft   6002668.0924 2113464.7267 37.7833218226195 -122.434462226416 (37.7833218226195, -122.434462226416)
36535 139766 2 54 1308 Laguna St 4 1 1 1     0 Width 0ft   6004662.1567 2113418.8231 37.7833087728144 -122.427560280444 (37.7833087728144, -122.427560280444)
102661 117259 1 54 670 Eddy St 1 5 2 1       3x3   6007197.5 2113350.2 37.7832634280904 -122.418784110751 (37.7832634280904, -122.418784110751)
68734 139765 2 54 1306 Laguna St 3 1 1 1     0 Width 0ft   6004663.7345 2113397.522 37.7832503745299 -122.427553303818 (37.7832503745299, -122.427553303818)
145653 140372 2 54 1770 O'Farrell St 2 1 1 1     0 Width 0ft   6002814.2684 2113417.5886 37.7832006898016 -122.433953145391 (37.7832006898016, -122.433953145391)
5226 253832 1 54 665 Eddy St 1 1 1 1 4     3x3   6007254.7956 2113297.42725 37.783121752773 -122.41858214693501 (37.783121752773, -122.418582146935)
53717 139776 2 54 1275 Ellis St 3 1 1 1     0 Width 0ft   6004800.935 2113296.4778 37.7829806915655 -122.427071445409 (37.7829806915655, -122.427071445409)
5229 253834 1 54 747 Eddy St 1 1 1 1 4     3x3   6006860.78535 2113242.76542 37.7829494746502 -122.419941385136 (37.7829494746502, -122.419941385136)
34038 140392 2 54 1460 Steiner St 2 1 1 1     0 Width 0ft   6002728.4059 2113323.2276 37.782936725289204 -122.434243446651 (37.7829367252892, -122.434243446651)
129582 139105 2 54 1310 Lyon St 2 1 1 1     0 Width 0ft   5999792.0294 2113376.32 37.782915402867495 -122.444405875371 (37.7829154028675, -122.444405875371)
98644 106968 7 54 351 26th Ave   13 1 1           5987720.26121 2113604.44601 37.7828456076198 -122.48618540122601 (37.7828456076198, -122.486185401226)
178124 140889 2 54 145 COMMONWEALTH AVE 1 2 1 1     0 Width 0ft   5996520.3624 2113408.7259 37.7828171689042 -122.455726761043 (37.7828171689042, -122.455726761043)
177826 140999 2 54 2425 GEARY BLVD 13 1 1 1     0 Width 0ft   6000127.896000001 2113280.4932 37.7826714447065 -122.44323703523399 (37.7826714447065, -122.443237035234)
152366 141748 2 54 2 HOLLIS ST 1 1 1 1     0 Width 0ft   6004017.2728 2113191.4555 37.782647981182606 -122.429775099989 (37.7826479811826, -122.429775099989)
56509 139696 2 54 345 Saint Joseph's Ave 2 1 1 1     0 Width 0ft   6000314.3725 2113207.1569999997 37.7824807138402 -122.442586640867 (37.7824807138402, -122.442586640867)
172823 140400 2 54 650 WILLOW ST 3 1 1 1     0 Width 0ft   6004364.2248 2113098.7472 37.782413067955495 -122.428568183869 (37.7824130679555, -122.428568183869)
37419 141003 2 54 166 COMMONWEALTH AVE 1 2 1 1     0 Width 0ft   5996581.6168 2113251.3598 37.7823885984174 -122.45550347026399 (37.7823885984174, -122.455503470264)
68816 140401 2 54 650 WILLOW ST 4 1 1 1     0 Width 0ft   6004290.5512 2113088.0425 37.7823795059387 -122.428822298842 (37.7823795059387, -122.428822298842)
41104 140367 2 54 690 WILLOW ST 1 1 1 1     0 Width 0ft   6004237.6574 2113081.116 37.782357493618605 -122.429004794114 (37.7823574936186, -122.429004794114)
148856 139245 2 54 1223 WEBSTER ST 3 1 1 1     0 Width 0ft   6003686.6496 2113074.8565 37.7823091017787 -122.430910590356 (37.7823091017787, -122.430910590356)
131825 141805 2 54 1398 WILLOW ST 1 1 1 1     0 Width 0ft   6004242.7853 2113058.4117 37.78229544352121 -122.428985434597 (37.7822954435212, -122.428985434597)
164525 137524 2 54 1300 Pierce St 2 1 1 1     0 Width 0ft   6002282.6726 2113052.5281 37.782168143964896 -122.435766122963 (37.7821681439649, -122.435766122963)
131984 201234 2 54 795 Folsom St 1 1 1 1     0 Width 0ft   6012343.1682 2112809.9895 37.7820685155731 -122.400944074647 (37.7820685155731, -122.400944074647)
39959 141131 2 54 1760 Ellis St 6 1 1 1     0 Width 0ft   6002332.7569 2113004.3119 37.7820385992621 -122.435589403585 (37.7820385992621, -122.435589403585)
73506 140761 2 54 18 Beideman St 3 1 1 1     0 Width 0ft   6001559.8015 2112962.3476 37.7818794437174 -122.43826046410801 (37.7818794437174, -122.438260464108)
31028 139809 2 54 1101 GOUGH ST 9 1 1 1     0 Width 0ft   6005660.0139 2112868.3262 37.7818536339515 -122.424068925498 (37.7818536339515, -122.424068925498)
135552 140125 2 54 1321 Divisadero St 4 1 1 1     0 Width 0ft   6001271.8045 2112891.6174 37.7816688523257 -122.43925172679899 (37.7816688523257, -122.439251726799)
28564 139551 2 54 230 Saint Joseph's Ave 1 1 1 1     0 Width 0ft   6000668.9907 2112886.9641 37.7816217540269 -122.441336837605 (37.7816217540269, -122.441336837605)
2865 253261 1 54 339 18th Ave 1 1 1 1       3x3   5990256.0 2113097.0 37.78159976365421 -122.477375802178 (37.7815997636542, -122.477375802178)
52248 140085 2 54 220 Saint Joseph's Ave 1 1 1 1     0 Width 0ft   6000673.3902 2112844.9998 37.7815067814228 -122.44131860551799 (37.7815067814228, -122.441318605518)
28730 140456 2 54 1459 Eddy St 9 1 1 1     0 Width 0ft   6003479.0697 2112771.1641 37.7814634747388 -122.431607035931 (37.7814634747388, -122.431607035931)
175934 140091 2 54 1250 Scott St 6 1 1 1     0 Width 0ft   6001831.6388 2112795.421 37.781436562836106 -122.43730807844801 (37.7814365628361, -122.437308078448)
52820 141107 2 54 200 Parker Ave 3 1 1 1     0 Width 0ft   5997010.9048 2112879.9419 37.7813934068271 -122.45399149831002 (37.7813934068271, -122.45399149831)
154987 141117 2 54 719 SPRUCE ST 1 1 1 1     0 Width 0ft   5997254.2301 2112852.8681 37.781333017932404 -122.45314776051599 (37.7813330179324, -122.453147760516)
45872 141030 2 54 88 Masonic Ave 3 1 1 1     0 Width 0ft   5998905.3901 2112810.7346 37.781311824276294 -122.44743254381099 (37.7813118242763, -122.447432543811)
149950 141106 2 54 210 Parker Ave 2 1 1 1     0 Width 0ft   5997014.289 2112849.8223 37.781310900385996 -122.45397761479201 (37.781310900386, -122.453977614792)
34444 139926 2 54 1001 TURK ST 2 1 1 1     0 Width 0ft   6005215.378 2112666.1069 37.78127327564229 -122.425592763682 (37.7812732756423, -122.425592763682)
31775 141105 2 54 220 Parker Ave 1 1 1 1     0 Width 0ft   5997021.7343 2112807.858 37.781196104366 -122.45394882631399 (37.781196104366, -122.453948826314)
36850 141882 2 54 1160 WEBSTER ST 1 1 1 1     0 Width 0ft   6003839.6945 2112655.4467 37.7811661774464 -122.430351190021 (37.7811661774464, -122.430351190021)
24523 141857 2 54 1100 TURK ST 1 1 1 1     0 Width 0ft   6004651.3626 2112630.8889 37.781144690344895 -122.42754147050199 (37.7811446903449, -122.427541470502)
131382 141119 2 54 124 Anza St 1 1 1 1     0 Width 0ft   5998714.1818 2112720.5452 37.7810532591781 -122.448087532266 (37.7810532591781, -122.448087532266)
28027 140087 2 54 1210 Scott St 2 1 1 1     0 Width 0ft   6001853.1286 2112643.6389 37.781021029267706 -122.43722286326 (37.7810210292677, -122.43722286326)
183785 141123 2 54 144 Anza St 1 1 1 1     0 Width 0ft   5998637.0216 2112710.0541 37.7810200422428 -122.448353710975 (37.7810200422428, -122.448353710975)
31430 141865 2 54 1198 TURK ST 1 1 1 1     0 Width 0ft   6004361.706 2112589.3295 37.7810141909048 -122.42854057505699 (37.7810141909048, -122.428540575057)
172874 139933 2 54 800 GOUGH ST 7 1 1 1     0 Width 0ft   6005708.0541 2112525.3709 37.7809146750444 -122.42387833426001 (37.7809146750444, -122.42387833426)
136289 137589 2 54 1150 PIERCE ST 10 1 1 1     0 Width 0ft   6002346.2752 2112589.0782 37.780899240130296 -122.435512922421 (37.7808992401303, -122.435512922421)
Powered by Datasette · Query took 17.028ms · Data source: data.sfgov.org