sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5100 253781 3 47 90 Cuesta Ct 5 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5107 253780 3 47 90 Cuesta Ct 4 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5095 253779 3 47 90 Cuesta Ct 3 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5089 253778 3 47 90 Cuesta Ct 2 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5105 253777 3 47 90 Cuesta Ct 1 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5055 253765 6 42 1366 Guerrero St 2 7 1 1       3X3   6005800.0848900005 2101007.6677599996 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761)
4923 253718 6 47 227 Madison St 1 7 1 1       3x3   6005690.0 2092595.0 37.726189474375204 -122.422524168298 (37.7261894743752, -122.422524168298)
4881 253712 2 128 339 Vienna St 1 7 1 1       Width 3ft   6003970.0 2091429.0 37.7228907132276 -122.428387044746 (37.7228907132276, -122.428387044746)
4693 253655 2 36 1048 Ingalls St 1 7 1 1       3x3   6018024.0 2094000.0 37.7307354351655 -122.379983340658 (37.7307354351655, -122.379983340658)
4553 253637 6 3 701 Noe St 2 7 1 1       Width 3ft   6003144.80454 2104133.37104 37.757727257313704 -122.43214639144101 (37.7577272573137, -122.432146391441)
4383 253609 2 224 318 Utah St 2 7 1 1       Width 4ft Permit Number 780845 6010580.39617 2106780.39752 37.7654141639451 -122.40661745795299 (37.7654141639451, -122.406617457953)
4105 253605 2 5 301 Teresita Blvd 1 7 1 1       3x3   5997753.0 2098469.0 37.741867117319 -122.45038506263799 (37.741867117319, -122.450385062638)
3804 253558 2 143 1240 Wisconsin St 1 7 1 1           6012830.0 2101639.0 37.7514226163546 -122.39847574638901 (37.7514226163546, -122.398475746389)
4771 253556 1 17 27 Ceres St 2 7 1 1 1 10/25/2017 12:00:00 AM 3   Permit Number 780682 6013919.66127 2093997.4229599999 37.730501082737604 -122.394172607985 (37.7305010827376, -122.394172607985)
3759 253555 1 71 27 Ceres St 1 7 1 1 1         6013919.66127 2093997.4229599999 37.730501082737604 -122.394172607985 (37.7305010827376, -122.394172607985)
3662 253513 6 216 1545 05th Ave 1 7 1 1   08/14/2012 12:00:00 AM   3x3 Permit Number 768941 5994803.920580001 2105050.88998 37.7597700982665 -122.461058902115 (37.7597700982665, -122.461058902115)
3534 253482 6 19 2179 41st Ave 1 7 1 1       3x5   5983532.0 2100331.0 37.74615550514321 -122.49969345420799 (37.7461555051432, -122.499693454208)
3699 253406 2 17 1555 Evans Ave 9 7 1 1   09/18/2017 12:00:00 AM 3 3x3 Permit Number 780731 6015916.0 2098279.0 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434)
3313 253405 2 204 1555 Evans Ave 8 7 1 1       3x3   6015916.0 2098279.0 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434)
3311 253404 2 204 1555 Evans Ave 7 7 1 1       3x3   6015916.0 2098279.0 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434)
3692 253403 2 17 1555 Evans Ave 6 7 1 1   09/18/2017 12:00:00 AM 3 3x3 Permit Number 780731 6015916.0 2098279.0 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434)
3697 253402 2 17 1555 Evans Ave 5 7 1 1   09/18/2017 12:00:00 AM 3 3x3 Permit Number 780731 6015916.0 2098279.0 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434)
3686 253401 2 17 1555 Evans Ave 4 7 1 1   09/18/2017 12:00:00 AM 3 3x3 Permit Number 780731 6015916.0 2098279.0 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434)
3286 253400 2 204 1555 Evans Ave 3 7 1 1       3x3   6015916.0 2098279.0 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434)
3303 253399 2 204 1555 Evans Ave 2 7 1 1       3x3   6015916.0 2098279.0 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434)
3690 253398 2 17 1555 Evans Ave 1 7 1 1   09/18/2017 12:00:00 AM 3 3x3 Permit Number 780731 6015916.0 2098279.0 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434)
3703 253397 2 17 400x Newhall St 2 7 1 1   09/18/2017 12:00:00 AM 3 3x3 Permit Number 780731 6016185.0 2098125.0 37.741960230665995 -122.38662864108801 (37.741960230666, -122.386628641088)
3696 253396 2 17 400x Newhall St 1 7 1 1   09/18/2017 12:00:00 AM 3 3x3 Permit Number 780731 6016185.0 2098125.0 37.741960230665995 -122.38662864108801 (37.741960230666, -122.386628641088)
3284 253385 2 53 1100 Golden Gate Ave 1 7 1 1           6004275.0 2112509.0 37.780788718892204 -122.428834805692 (37.7807887188922, -122.428834805692)
3283 253384 6 203 55 Cerritos Ave 1 7 1 1       10x10   5992588.0 2092941.0 37.7263916542788 -122.46784182223999 (37.7263916542788, -122.46784182224)
3256 253373 6 44 78 Peralta Ave 1 7 1 1       3x3   6010457.0 2100357.0 37.7477700431666 -122.406591570174 (37.7477700431666, -122.406591570174)
3050 253291 2 47 650 Peru Ave 7 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3049 253290 2 47 650 Peru Ave 6 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3046 253289 2 47 650 Peru Ave 5 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3044 253288 2 47 650 Peru Ave 4 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
2848 253255 6 47 270 Castenada Ave 2 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3138 253254 6 3 270 Castenada Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2854 253253 6 5 99X Lopez Ave 4 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2874 253252 6 3 99X Lopez Ave 3 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2859 253251 6 3 99X Lopez Ave 2 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2869 253250 6 3 99X Lopez Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2736 253183 6 143 5159 Diamond Heights Blvd 1 7 1 1           6000808.0 2099903.0 37.745978911495 -122.439924689335 (37.745978911495, -122.439924689335)
2734 253182 6 143 5157 Diamond Heights Blvd 1 7 1 1           6000788.0 2100195.0 37.7467795353698 -122.44001478039101 (37.7467795353698, -122.440014780391)
3723 253167 3 12 1X Brotherhood Way 1 7 1 2                    
2691 253165 6 180 1451 Bay St 3 7 1 1       3x3   6003691.0 2120547.0 37.802825946660796 -122.431429119577 (37.8028259466608, -122.431429119577)
3034 253070 2 3 132 Sagamore St 2 7 1 1       Width 0ft Permit Number 780451 5995539.3842400005 2087458.9579900003 37.7115092483173 -122.45724268539699 (37.7115092483173, -122.457242685397)
2179 252925 3 71 700 Sanchez St 2 7 1 2           6003672.0 2104202.0 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181)
2186 252924 3 47 700 Sanchez St 1 7 1 2           6003672.0 2104202.0 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181)
2126 252903 2 64 215 Capistrano Ave   7 1 1       3x3   6001180.0 2093207.0 37.727614424830705 -122.438158778943 (37.7276144248307, -122.438158778943)
3693 252877 2 103 1400 Baker St 2 7 1 1       3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
3689 252876 2 5 1400 Baker St 1 7 1 1       3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
3756 252875 2 5 2400 Post St 2 7 1 1       3x3   6000387.0 2114050.0 37.784799083264396 -122.44239591065 (37.7847990832644, -122.44239591065)
3694 252874 2 5 2400 Post St 1 7 1 1       3x3   6000387.0 2114050.0 37.784799083264396 -122.44239591065 (37.7847990832644, -122.44239591065)
2081 252873 2 5 1501 Broderick St 7 7 1 1       3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
3851 252871 2 5 2557 Sutter St   7 1 1       3x3   5999847.0 2113975.0 37.7845623594454 -122.444258736096 (37.7845623594454, -122.444258736096)
2071 252870 2 36 716 McAllister St 1 7 1 1       3x3   6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
2497 252857 2 17 124 Persia Ave 2 7 1 1       3x3 Permit Number 780172 6002102.0 2091308.0 37.7224525933916 -122.43483567372 (37.7224525933916, -122.43483567372)
1933 252830 6 75 3852 17th St 9 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1957 252829 6 161 3852 17th St 8 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1930 252828 6 161 3852 17th St 7 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1938 252827 6 75 3852 17th St 6 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1932 252826 6 75 3852 17th St 5 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1947 252825 6 163 3852 17th St 4 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1936 252824 6 75 3852 17th St 3 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1950 252823 6 22 3852 17th St 2 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1939 252822 6 114 3852 17th St 1 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1907 251816 2 158 1800 Ellis St 1 7 1 1       3x3   6002197.0 2113045.0 37.782142606902205 -122.436061972283 (37.7821426069022, -122.436061972283)
1822 251717 3 47 1000X San Jose Ave 1 7 1 2           6004710.0 2096486.0 37.736817957153605 -122.426188866367 (37.7368179571536, -122.426188866367)
1820 251716 6 47 3929 19th St 1 7 1 1           6003450.0 2104734.0 37.75939373993371 -122.431133769968 (37.7593937399337, -122.431133769968)
1633 251599 2 47 740 Moraga St 1 7 1 1       3x3   5992006.0 2103899.0 37.756445907456396 -122.470651540396 (37.7564459074564, -122.470651540396)
1557 251590 2 41 340x Vicente St 3 7 1 1       3x3   5991910.0 2097743.0 37.739537567792894 -122.47053520105601 (37.7395375677929, -122.470535201056)
1299 251494 3 3 900 Bosworth St 36 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1283 251493 3 3 900 Bosworth St 35 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1286 251492 3 3 900 Bosworth St 34 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1295 251491 3 3 900 Bosworth St 33 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1298 251490 3 3 900 Bosworth St 32 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1272 251489 3 3 900 Bosworth St 31 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1316 251488 3 3 900 Bosworth St 30 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1288 251487 3 3 900 Bosworth St 29 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1290 251486 3 3 900 Bosworth St 28 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1338 251485 3 3 900 Bosworth St 6 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1332 251484 3 3 900 Bosworth St 7 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1322 251483 3 3 900 Bosworth St 8 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1282 251482 3 3 900 Bosworth St 1 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1310 251480 6 3 51 Peralta Ave 1 7 1 1       3x3   6010641.0 2100362.0 37.747794064611604 -122.40595565659201 (37.7477940646116, -122.405955656592)
1694 251475 2 110 151 32nd Ave 3 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
1686 251474 2 110 151 32nd Ave 2 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
1712 251473 2 110 151 32nd Ave 1 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
1177 251471 3 137 2423 Market St 1 7 1 2                    
999 251422 2 47 480x De Long St   7 1 1       3x3   5992963.0 2086633.0 37.709093057147996 -122.466087289133 (37.709093057148, -122.466087289133)
1719 251394 6 154 203 Corbett Ave 1 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779803 6000094.0 2105620.0 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122)
767 251382 2 58 731 Huron Ave 1 7 1 1       2x5   5997668.0 2087467.0 37.7116533538928 -122.449886244657 (37.7116533538928, -122.449886244657)
239 251252 3 63 321X Corbett Ave 3 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
238 251251 3 63 321X Corbett Ave 2 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
247 251250 3 63 321X Corbett Ave 1 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
240 251249 5 64 161 Lundys Ln 1 7 2 1       3x3   6006716.0 2098685.0 37.7429691002686 -122.41940918518 (37.7429691002686, -122.41940918518)
78 251199 6 3 900X 14th St 4 7 1 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
93 251198 6 3 900X 14th St 3 7 1 1           6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
95 251197 6 3 900X 14th St 3 7 1 1   03/22/2017 12:00:00 AM 3   Permit Number 779570 6002798.55883 2107703.57748 37.7675105430125 -122.43359899801901 (37.7675105430125, -122.433598998019)
23162 251173 6 75 367 Jersey St 2 7 1 1       Width 3ft   6002770.52649 2101500.0126900002 37.7504754543841 -122.43325263672399 (37.7504754543841, -122.433252636724)
23001 251172 6 3 363 Jersey St 2 7 1 1           6002784.74363 2101501.25508 37.750479672211 -122.433203561601 (37.750479672211, -122.433203561601)
Powered by Datasette · Query took 24.388ms · Data source: data.sfgov.org