sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
168 179480 2 25 100 Serrano Dr 1 2 1 1     11     5989599.0 2090767.0 37.7202493457345 -122.478015677124 (37.7202493457345, -122.478015677124)
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)
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)
4004 251722 2 26 18 Lobos St 2 2 1 1   10/05/2017 03:08:00 PM 3     5996685.56427 2088703.70423 37.7149927956564 -122.45337101855101 (37.7149927956564, -122.453371018551)
4008 216051 2 12 48 Lobos St 1 2 1 1   10/05/2017 02:54:00 PM 3     5996419.4156599995 2088710.03455 37.7149949180514 -122.454291392827 (37.7149949180514, -122.454291392827)
4014 216033 2 26 4 Lobos St 1 2 1 1   10/05/2017 03:13:00 PM 3     5996833.19651 2088697.5304900003 37.7149843051513 -122.452860296276 (37.7149843051513, -122.452860296276)
4026 216034 2 26 8 Lobos St 1 2 1 1   10/05/2017 03:11:00 PM 3     5996778.28459 2088695.06883 37.714974399131705 -122.45304991653099 (37.7149743991317, -122.453049916531)
4030 216055 2 12 52 Lobos St 3 2 1 1   10/05/2017 02:49:00 PM 3     5996381.618969999 2088696.9088599999 37.714956710372 -122.454421085891 (37.714956710372, -122.454421085891)
4061 252970 5 82 101X Whipple Ave 2 2 1 1   10/05/2017 12:21:00 PM 3              
4092 216045 2 12 36 Lobos St 2 2 1 1   10/05/2017 03:04:00 PM 3     5996513.0629 2088696.2251900001 37.7149623706927 -122.45396671331999 (37.7149623706927, -122.45396671332)
4097 216058 2 12 58 Lobos St 1 2 1 1   10/05/2017 02:35:00 PM 3     5996320.31527 2088710.5585599998 37.7149906732676 -122.45463396169599 (37.7149906732676, -122.454633961696)
4103 216046 2 12 38 Lobos St 1 2 1 1   10/05/2017 03:02:00 PM 3     5996487.74032 2088710.41168 37.7149998715299 -122.454055262356 (37.7149998715299, -122.454055262356)
4117 216048 2 12 40 Lobos St 1 2 1 1   10/05/2017 02:58:00 PM 3     5996463.1782599995 2088711.43982 37.7150012861457 -122.45414023299999 (37.7150012861457, -122.454140233)
9572 100227 2 22 542 Valley St 1 2 1 1     30   Permit Number 769993 6002426.0 2099190.0 37.7441131524814 -122.434278904907 (37.7441131524814, -122.434278904907)
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)
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)
10103 173844 2 143 2X Crestline Dr 1 2 1 1           5999319.0 2101169.0 37.7493701671822 -122.445164434644 (37.7493701671822, -122.445164434644)
10370 107580 2 44 100 Panama St 2 2 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992406.39157 2086830.73395 37.709603859212706 -122.468025367885 (37.7096038592127, -122.468025367885)
10524 107581 2 44 100 Panama St 3 2 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992393.946819999 2086830.9956900002 37.7096038591978 -122.46806839775299 (37.7096038591978, -122.468068397753)
11417 117425 1 170 218 Athens St 1 2 1 1   06/14/2016 12:00:00 AM 3   Permit Number 775470 6004576.76699 2091985.7103900001 37.724453633907 -122.426329194258 (37.724453633907, -122.426329194258)
11907 107582 2 44 100 Panama St 4 2 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992337.55751 2086836.4734200002 37.7096156430274 -122.46826368552 (37.7096156430274, -122.46826368552)
12169 107579 2 44 100 Panama St 1 2 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992416.91174 2086830.03613 37.7096025506984 -122.467988957943 (37.7096025506984, -122.467988957943)
12904 117426 1 48 395 Athens St 1 2 1 1   06/14/2016 12:00:00 AM 3   Permit Number 775297 6003998.920059999 2091015.17385 37.7217560742586 -122.428257595231 (37.7217560742586, -122.428257595231)
16807 106757 2 47 999 Key Ave 1 2 1 1   06/02/2014 12:00:00 AM 36     6013321.202330001 2089752.82506 37.718812992515105 -122.395944254446 (37.7188129925151, -122.395944254446)
18835 114526 6 3 1 TIOGA AVE 2 2 1 1           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341)
19238 104509 2 2 80 DICHIERA CT   2 1 1     14     5998620.0 2088043.0 37.7132893442667 -122.446637305723 (37.7132893442667, -122.446637305723)
19268 104883 2 3 132 Gonzalez Dr 1 2 1 1           5990322.1 2090011.1 37.718215776001294 -122.475461023549 (37.7182157760013, -122.475461023549)
20076 98360 1 3 807 Francisco St 1 2 1 1         Permit Number 768654 6007370.5 2120864.5 37.8039055703948 -122.418718664572 (37.8039055703948, -122.418718664572)
22821 197331 2 45 1501 25th St 12 2 1 1     3     6014124.123369999 2101967.77095 37.752397360459 -122.39402349321199 (37.752397360459, -122.394023493212)
22882 176369 2 39 0 Font Blvd 2 2 1 1     13     5990491.08034 2089186.3269 37.7159609464097 -122.47481676917101 (37.7159609464097, -122.474816769171)
23514 190971 2 47 800 Vermont St 11 2 1 1     42     6011272.24417 2104307.20268 37.7586620081736 -122.40405043579099 (37.7586620081736, -122.404050435791)
23735 213223 2 2 18 Lobos St 1 2 1 1     15     5996685.56427 2088703.70423 37.7149927956564 -122.45337101855101 (37.7149927956564, -122.453371018551)
23763 194461 2 143 2000 25th St 3 2 1 1     27     6012563.257130001 2101880.94422 37.7520720792617 -122.399415164477 (37.7520720792617, -122.399415164477)
23936 211142 2 3 100 Terrace Dr 1 2 1 1     31     5993344.399119999 2096880.05499 37.7372509740365 -122.465513038912 (37.7372509740365, -122.465513038912)
24035 178607 2 15 0 Gonzalez Dr 1 2 1 1     2     5990327.66617 2089955.55198 37.7180635775375 -122.47543773036101 (37.7180635775375, -122.475437730361)
24097 177096 2 55 0 Serrano Dr 3 2 1 1     32     5989524.60255 2090740.4518099998 37.720172132521206 -122.47827090148199 (37.7201721325212, -122.478270901482)
24106 246790 2 75 175 Brewster St 10 2 1 1     8     6010136.6415 2098750.10917 37.74333994367979 -122.40758608083901 (37.7433399436798, -122.407586080839)
24170 206058 2 278 95 Marston Ave 3 2 1 1     7     5998836.80822 2093173.9716299998 37.727390192897 -122.44625681279899 (37.727390192897, -122.446256812799)
24183 175768 2 20 0 Gonzalez Dr 2 2 1 1     13     5989578.68884 2089185.3656400002 37.7159053925979 -122.47797031747801 (37.7159053925979, -122.477970317478)
24210 243997 2 224 483 Valley St 13 2 1 1     15     6002856.13849 2099166.37305 37.7440726834043 -122.432789895044 (37.7440726834043, -122.432789895044)
24565 176109 2 47 520 Carter St 2 2 1 1     15     6005252.95246 2086362.20208 37.7090508894465 -122.42359208063299 (37.7090508894465, -122.423592080633)
24621 205635 2 95 20 Belmont Ave 4 2 1 1     4     5996782.71205 2106151.6508299997 37.762906178688105 -122.454294786868 (37.7629061786881, -122.454294786868)
24748 210946 2 104 78 Lobos St 2 2 1 1     2     5996128.662169999 2088702.9665 37.714958832754 -122.455295843853 (37.714958832754, -122.455295843853)
24760 188680 2 5 2 Middle Point Rd 3 2 1 1     8     6018245.47476 2096448.1212400002 37.7374697107694 -122.37938765012501 (37.7374697107694, -122.379387650125)
24841 175769 2 20 0 Gonzalez Dr 1 2 1 1     6     5989661.94364 2089233.64885 37.716042798215206 -122.477686080452 (37.7160427982152, -122.477686080452)
24880 178117 2 104 0 Gonzalez Dr 3 2 1 1     2     5988789.573419999 2089765.1297400002 37.717451446800204 -122.480740256365 (37.7174514468002, -122.480740256365)
24979 177920 2 41 0 Juan Bautista Cir 4 2 1 1     13     5989764.376630001 2089755.55448 37.7174817656499 -122.477370148614 (37.7174817656499, -122.477370148614)
25162 120283 2 237 139 24th Ave 1 2 1 1     13     5988317.15466 2115062.63745 37.786884157218 -122.484227400222 (37.786884157218, -122.484227400222)
25205 195981 2 86 401 Amador St 12 2 1 1     7     6018524.13374 2099557.3325900002 37.746022348857295 -122.37864001312799 (37.7460223488573, -122.378640013128)
25277 210945 2 104 78 Lobos St 1 2 1 1     3     5996140.80305 2088701.9398299998 37.7149567103495 -122.455253805936 (37.7149567103495, -122.455253805936)
25292 177947 2 41 0 Fuente Ave 1 2 1 1     13     5989601.96089 2090504.09134 37.7195276360688 -122.477986231896 (37.7195276360688, -122.477986231896)
25340 199360 2 36 1451 Rhode Island St 2 2 1 1     19     6012046.6036 2101626.2388 37.7513439035983 -122.401183943899 (37.7513439035983, -122.401183943899)
25485 198641 2 46 419 Mission Bay Blvd North 15 2 1 1     5     6015975.52657 2108754.29642 37.7711344286414 -122.388094538146 (37.7711344286414, -122.388094538146)
25637 190976 2 47 800 Vermont St 25 2 1 1     18     6011280.21235 2104227.17617 37.758442718371704 -122.404017246303 (37.7584427183717, -122.404017246303)
25716 135893 2 35 323 Marina Blvd 2 2 1 1     8     6001843.597519999 2121830.48703 37.806245186226505 -122.437914052191 (37.8062451862265, -122.437914052191)
25725 178308 2 3 0 Font Blvd 1 2 1 1     31     5990210.12045 2089417.27348 37.716578783365605 -122.47580474370501 (37.7165787833656, -122.475804743705)
25734 237874 2 72 160 Coso Ave 1 2 1 1     5     6007471.906690001 2099585.1841700003 37.74548335098721 -122.41685922338301 (37.7454833509872, -122.416859223383)
25771 198601 2 46 456 Mission Bay Blvd South 1 2 1 1     2     6016359.83761 2108655.37305 37.770884091558706 -122.386758280474 (37.7708840915587, -122.386758280474)
25878 207430 2 197 1550 15th Ave 3 2 1 1     10     5991564.83032 2104929.84825 37.759250823982605 -122.47225238743601 (37.7592508239826, -122.472252387436)
26083 123491 2 53 600 Arguello Blvd 1 2 1 1     30     5995674.45752 2111730.9534 37.77816187055421 -122.458531727532 (37.7781618705542, -122.458531727532)
26454 188657 2 5 100 Cargo Way 123 2 1 1     12     6016750.167669999 2099204.87087 37.744956608177205 -122.38474966268801 (37.7449566081772, -122.384749662688)
26455 250503 2 2 27 27th Ave 2 2 1 1     12     5987219.4973 2115634.05688 37.7883891388944 -122.488066995303 (37.7883891388944, -122.488066995303)
26514 193470 2 315 981 Le Conte Ave 4 2 1 1     5     6013233.09279 2089478.4366400002 37.7180546742753 -122.396229595828 (37.7180546742753, -122.396229595828)
26554 178310 2 3 0 Serrano Dr 5 2 1 1     34     5989465.34816 2090743.3229599998 37.7201765760646 -122.478475931633 (37.7201765760646, -122.478475931633)
26589 196520 2 102 1100 Pennsylvania Ave 6 2 1 1     1     6014495.9358 2101776.59314 37.751893084516894 -122.392724321763 (37.7518930845169, -122.392724321763)
26599 176373 2 39 0 Higuera Ave 6 2 1 1     18     5987816.39494 2090204.8052400001 37.7186020727071 -122.484136269073 (37.7186020727071, -122.484136269073)
26910 195984 2 86 401 Amador St 9 2 1 1     5     6018485.16554 2099556.70792 37.7460184853642 -122.378774718093 (37.7460184853642, -122.378774718093)
27096 240267 2 180 517 Powhattan Ave 1 2 1 1     7     6008465.29724 2098131.45059 37.7415475462934 -122.413321437934 (37.7415475462934, -122.413321437934)
27126 177939 2 41 0 Garces Dr 5 2 1 1     9     5989472.35628 2089125.29207 37.7157342731997 -122.478333458321 (37.7157342731997, -122.478333458321)
27306 178328 2 3 0 Gonzalez Dr 2 2 1 1     29     5990317.34225 2090043.8786900002 37.718305502374704 -122.47547986090599 (37.7183055023747, -122.475479860906)
27342 197873 2 178 1798 Revere Ave 4 2 1 1     11     6014074.97715 2095177.8626700002 37.7337509610296 -122.39371824532101 (37.7337509610296, -122.393718245321)
27377 211177 2 3 2 Lobos St 3 2 1 1     10     5996889.59605 2088696.8686799998 37.714985719781 -122.45266530885799 (37.714985719781, -122.452665308858)
27493 136046 2 237 20 Cherry St 5 2 1 1     6     5996087.67176 2116001.0032200003 37.789910026470004 -122.45741128312001 (37.78991002647, -122.45741128312)
27677 118507 2 2 8149 Geary Blvd 6 2 1 1     19     5981701.912719999 2112329.1151099997 37.7789913275143 -122.506911374832 (37.7789913275143, -122.506911374832)
27686 118503 2 2 8149 Geary Blvd 7 2 1 1     21     5981708.0026 2112322.43934 37.7789733564528 -122.506889812546 (37.7789733564528, -122.506889812546)
28068 126421 2 47 957 Green St 2 2 1 1     21     6008400.762999999 2118955.03362 37.7987206054154 -122.415018129477 (37.7987206054154, -122.415018129477)
28275 198639 2 46 419 Mission Bay Blvd North 13 2 1 1     5     6015936.8101699995 2108752.54325 37.7711274696967 -122.38822833839 (37.7711274696967, -122.38822833839)
28294 188658 2 5 100 Cargo Way 124 2 1 1     10     6016703.96276 2099238.37904 37.7450460592258 -122.384911766374 (37.7450460592258, -122.384911766374)
28431 246705 2 362 1 Bonview St 11 2 1 1     3     6007711.520280001 2099134.96568 37.7442606264379 -122.41599879791201 (37.7442606264379, -122.415998797912)
28635 213024 2 16 20 Belmont Ave 9 2 1 1     18     5996733.15757 2106189.67252 37.7630077346534 -122.454468924419 (37.7630077346534, -122.454468924419)
28834 188557 2 140 1790 23rd St 12 2 1 1     13     6013310.23031 2102900.17201 37.7549122641975 -122.39690345423 (37.7549122641975, -122.39690345423)
28874 218292 2 60 1 Woodacre Dr 16 2 1 1     39     5991223.38049 2095418.74528 37.73311602796429 -122.472739784911 (37.7331160279643, -122.472739784911)
29157 175654 2 28 0 Gonzalez Dr 2 2 1 1     7     5989491.89044 2089216.44658 37.7159856948481 -122.478272601196 (37.7159856948481, -122.478272601196)
29194 188256 2 28 1039 Jamestown Ave 7 2 1 1     8     6013789.26124 2089763.6189299999 37.7188686596462 -122.39432710432301 (37.7188686596462, -122.394327104323)
29206 195983 2 86 401 Amador St 10 2 1 1     4     6018491.3513 2099573.26629 37.7460642923356 -122.378754477939 (37.7460642923356, -122.378754477939)
29240 177953 2 41 0 Grijalva Dr 3 2 1 1     15     5989426.93386 2089569.48868 37.7169512897353 -122.47852292122101 (37.7169512897353, -122.478522921221)
29386 177222 2 11 0 Gonzalez Dr 5 2 1 1     12     5989183.517969999 2089355.54971 37.7163497314364 -122.479348640047 (37.7163497314364, -122.479348640047)
29568 247533 2 5 1101 Waller St 14 2 1 1     2     6000119.08328 2108491.6907099998 37.769522108775 -122.44292352241501 (37.769522108775, -122.442923522415)
29723 177927 2 41 0 Bucareli Dr 4 2 1 1     17     5988959.91996 2089504.3338 37.716745265857 -122.48013237763 (37.716745265857, -122.48013237763)
29891 250356 2 108 25 Scenic Way 1 2 1 1     4     5987583.59597 2115669.67297 37.7885081641679 -122.48680990495701 (37.7885081641679, -122.486809904957)
29901 191709 2 190 3535 Jennings St 1 2 1 1     9     6013020.366769999 2089365.2626599998 37.717732082047895 -122.39695697201 (37.7177320820479, -122.39695697201)
Powered by Datasette · Query took 46.76ms · Data source: data.sfgov.org