sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
40 222540 2 20 1 Newburg St 3 1 1 1     6 Width 2ft   6002573.08856 2099992.67614 37.74632546084511 -122.433827665916 (37.7463254608451, -122.433827665916)
65 226926 2 19 1 Newburg St 3 6 1 1     15 Width 4ft   6002574.76935 2099983.89995 37.7463014588644 -122.433821226777 (37.7463014588644, -122.433821226777)
107 142075 2 26 1384X GROVE ST 3 1 1 1     8 Width 0ft   6001166.7226 2110758.8221 37.775806756879895 -122.439462326391 (37.7758067568799, -122.439462326391)
108 192593 2 11 1399X Mission St 3 1 1 1     11 Width 3ft   6008031.0 2110483.0 37.775437677991796 -122.41569744526699 (37.7754376779918, -122.415697445267)
161 142720 2 54 1170 COLUMBUS AVE 3 1 1 1       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078)
257 251260 2 9 1163 South Van Ness Ave 3 1 1 1       Width 3ft   6007684.87734 2102881.8281400003 37.754547168222295 -122.41635626045701 (37.7545471682223, -122.416356260457)
260 221893 2 68 3164 25th St 3 1 1 1     12 Width 3ft   6008601.79804 2101572.78068 37.751004337584796 -122.41309273944599 (37.7510043375848, -122.413092739446)
262 141360 2 55 1499X Hayes St 3 1 1 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
276 173808 2 17 1201 04th St 3 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
280 194427 2 71 905 Minna St 3 1 1 1     15 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
327 191528 2 62 201 16th St 3 1 1 1   04/04/2017 12:00:00 AM 3 Width 5ft   6016052.47786 2107208.19392 37.76689343092 -122.38772046693501 (37.76689343092, -122.387720466935)
452 221749 2 26 275 Grattan St 3 1 2 1     24 Width 4ft   5997432.91763 2106413.5715 37.763662611962 -122.452064861225 (37.763662611962, -122.452064861225)
472 236059 2 26 601X 14th St 3 1 1 1     16 Width 3ft   6004719.95486 2107769.51353 37.7678004187701 -122.42695783742799 (37.7678004187701, -122.426957837428)
478 142161 2 25 490X Baker St 3 1 1 1     8 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
486 98534 2 32 1805X Baker St 3 1 1 1     10 3x3 Permit Number 779899 5999986.755609999 2115164.0145 37.787835056676705 -122.443860686142 (37.7878350566767, -122.443860686142)
541 251317 2 49 399X 12th St 3 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
557 194124 2 41 963 Minna St 3 15 1 1     9 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
558 251320 2 25 35 Park St 3 1 1 1       Width 3ft   6004965.06472 2096463.48809 37.7367705580153 -122.425305393447 (37.7367705580153, -122.425305393447)
593 140072 2 59 601X Octavia St 3 1 1 1     15 Width 0ft   6005402.0 2111410.0 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543)
648 244249 2 11 200 Octavia St 3 1 1 1   04/13/2017 03:00:00 PM 3 Width 0ft   6005669.2453 2110057.8231 37.774137198555 -122.423837083382 (37.774137198555, -122.423837083382)
660 244391 2 98 250 Octavia St 3 1 1 1   04/15/2017 01:16:00 PM 3 Width 0ft   6005650.1507 2110201.4148 37.774530388668 -122.42391334778499 (37.774530388668, -122.423913347785)
720 104746 2 1 700X 20th Ave 3 1 1 1   04/17/2017 12:00:00 AM 3 3x3 Permit Number 779658 5989767.16587 2110527.4876599996 37.774516219561704 -122.478878924469 (37.7745162195617, -122.478878924469)
795 140241 2 22 160 Ashbury St 3 1 1 1     2 Width 0ft   5998775.6798 2110202.3294 37.7741424035345 -122.44769344620701 (37.7741424035345, -122.447693446207)
855 251398 2 94 299 Townsend St 3 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
882 187661 2 17 1155 04th St 3 1 1 1   04/21/2017 12:00:00 AM 3 3x3 Permit Number 779411 6015039.0 2109715.0 37.77372037595529 -122.391401215397 (37.7737203759553, -122.391401215397)
891 251304 2 1 1 Cashmere St 3 13 1 1 5     3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
908 206337 2 114 240 Noriega St 3 1 1 1     20 Width 5ft   5993194.556580001 2103260.73418 37.7547620531274 -122.466494737945 (37.7547620531274, -122.466494737945)
913 107355 2 26 2001 Grant Ave 3 1 1 1     14 3x3   6010310.1611 2121354.7321 37.8054166971664 -122.40858034027201 (37.8054166971664, -122.408580340272)
915 140945 2 60 2060 Ofarrell St 3 1 1 1     23 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
971 251415 2 29 10x Jones St 3 1 1 1   11/19/2005 12:00:00 AM   3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
979 200925 2 79 4100 03rd St 3 1 1 1   04/26/2017 12:00:00 AM 3 Width 0ft   6015478.3928 2097437.2349 37.7400326248174 -122.389023874228 (37.7400326248174, -122.389023874228)
998 106624 2 9 156 Commonwealth Ave 3 1 1 1     9 3x6 Permit Number 778450 5996579.9247 2113340.3647 37.78263288517989 -122.455515759177 (37.7826328851799, -122.455515759177)
1104 218512 2 37 2700x San Jose Ave 3 1 1 1     5 Width 3ft   5997075.0 2088509.0 37.7144804976148 -122.452010931306 (37.7144804976148, -122.452010931306)
1157 251464 2 136 3440 16th St 3 5 1 1       3x3   6003947.0 2106622.0 37.7646058870383 -122.429549548663 (37.7646058870383, -122.429549548663)
1262 251479 2 1 1214 29th Ave 3 1 1 1         Permit Number 779194 5987090.84961 2106996.2792700003 37.7646647351899 -122.48787719677 (37.7646647351899, -122.48787719677)
1265 108488 2 139 1 Rausch St 3 1 1 1   02/22/2017 12:00:00 AM 3 4x4 Permit Number 779048 6009599.94268 2111020.96873 37.777002885413104 -122.410308071481 (37.7770028854131, -122.410308071481)
1360 125405 2 17 2500X Pierce St 3 1 1 1   05/11/2017 12:00:00 AM 3 Width 4ft Permit Number 779167 6001716.65019 2117116.43684 37.7932944253528 -122.438015491236 (37.7932944253528, -122.438015491236)
1368 141257 2 144 51 COMMONWEALTH AVE 3 2 1 1     6 Width 0ft   5996492.2734 2114210.7856 37.7850177994523 -122.455881936455 (37.7850177994523, -122.455881936455)
1487 233540 2 108 660 Clipper St 3 1 1 1   05/19/2017 12:00:00 AM 3 Width 3ft Permit Number 779879 6001114.06108 2100904.6606 37.748746650735505 -122.438938144387 (37.7487466507355, -122.438938144387)
1502 223929 2 39 610 Clipper St 3 1 1 1   05/19/2017 12:00:00 AM 3 Width 2ft Permit Number 779880 6001216.05485 2100901.84413 37.748744719898 -122.43858524950599 (37.748744719898, -122.438585249506)
1549 142039 2 1 1499X Fulton St 3 1 1 1     14 Width 0ft   6000824.0 2111032.0 37.7765373235881 -122.44066748676701 (37.7765373235881, -122.440667486767)
1553 207056 2 45 340 Vicente St 3 1 1 1     2 Width 3ft   5991811.94775 2097766.11202 37.7395953573424 -122.470875903123 (37.7395953573424, -122.470875903123)
1557 251590 2 41 340x Vicente St 3 7 1 1       3x3   5991910.0 2097743.0 37.739537567792894 -122.47053520105601 (37.7395375677929, -122.470535201056)
1580 239668 2 149 180 Dolores St 3 6 1 1     23 Width 4ft   6004776.3298 2107329.36682 37.766595069134105 -122.426731495165 (37.7665950691341, -122.426731495165)
1592 251595 2 39 3698 19th St 3 1 1 1       4x4   6005038.0 2104916.0 37.7599833282319 -122.42565463806999 (37.7599833282319, -122.42565463807)
1600 251625 2 47 76R Amber Dr 3 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1605 251634 2 47 14R Amethyst Way 3 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1613 251616 2 47 64R Amber Dr 3 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1638 251620 2 47 72R Amber Dr 3 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1661 245154 2 16 100 Lyon St 3 1 1 1     5 Width 0ft   6000359.4788 2109307.5305 37.771775902629706 -122.44215057779499 (37.7717759026297, -122.442150577795)
1670 251646 2 16 132 Shipley St 3 1 1 1       3x3   6011949.0 2112390.0 37.7808933270361 -122.40227818697599 (37.7808933270361, -122.402278186976)
1673 223647 2 106 3270 18th St 3 1 1 1     5 Width 3ft   6007640.90679 2105619.03236 37.7620604292697 -122.416702221525 (37.7620604292697, -122.416702221525)
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)
1726 139069 2 108 2211 Post St 3 1 1 1     6 Width 0ft   6001584.0 2113871.0 37.784375747905706 -122.43824186327299 (37.7843757479057, -122.438241863273)
1727 251675 2 108 2201 Post St 3 1 1 1       3x3   6001586.0 2113871.0 37.784375861655995 -122.438234943981 (37.784375861656, -122.438234943981)
1803 200050 2 28 1590 Shafter Ave 3 1 1 1     12 Width 0ft   6014991.2562 2094154.9788 37.730993203361 -122.39047892232401 (37.730993203361, -122.390478922324)
1857 251765 2 21 23 Seville St 3 2 1 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1868 231236 2 2 2000 Bryant St 3 1 1 1     7 Width 4ft   6009517.72345 2105367.35909 37.7614747718611 -122.41019324152599 (37.7614747718611, -122.410193241526)
1874 251773 2 49 90x Seville St 3 1 1 1       3x3   6002045.0 2087474.0 37.7119220445534 -122.434758675533 (37.7119220445534, -122.434758675533)
1905 251810 2 11 2 Hangah St 3 20 1 10 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
1908 127945 2 32 101 Vallejo St 3 1 1 1   06/12/2017 12:00:00 AM 3 Width 2ft   6012656.99006 2119182.6904 37.7995839500992 -122.40030612282601 (37.7995839500992, -122.400306122826)
2002 190904 2 165 5 George Ct 3 1 1 1     25 Width 3ft   6017188.0 2093995.0 37.7306755515034 -122.382873204359 (37.7306755515034, -122.382873204359)
2030 138247 2 108 1599 Scott St 3 1 1 1     6 Width 0ft   6001634.7269 2113859.0317 37.7843457709869 -122.43806550855301 (37.7843457709869, -122.438065508553)
2045 124757 2 17 2040 Broadway 3 1 1 1   06/19/2017 12:00:00 AM 3 Width 4ft Permit Number 779873 6003680.83051 2117635.7933099996 37.7948319494745 -122.431256385468 (37.7948319494745, -122.431256385468)
2046 131756 2 17 1818 Broadway 3 1 1 1     11 Width 4ft   6004733.3748 2117781.6991 37.795292161346104 -122.427624834041 (37.7952921613461, -122.427624834041)
2096 200850 2 15 1411 Market St 3 1 1 1     5 Width 0ft   6007584.0 2110630.0 37.77581616716321 -122.417254147161 (37.7758161671632, -122.417254147161)
2102 196505 2 18 3536 Jennings St 3 2 1 1     2 Width 3ft   6013064.418880001 2089502.0027700001 37.7181099951501 -122.39681428375299 (37.7181099951501, -122.396814283753)
2122 252898 2 48 501x Mount Vernon Ave 3 1 1 1       3x3   5997879.0 2089997.0 37.7186122227881 -122.44933914222901 (37.7186122227881, -122.449339142229)
2123 128055 2 94 449 North Point St 3 1 1 1   06/23/2017 12:00:00 AM 3 Width 3ft Permit Number 780354 6008758.87824 2121765.85838 37.8064585449799 -122.413977880988 (37.8064585449799, -122.413977880988)
2155 235936 2 16 900 Hampshire St 3 1 1 1   06/27/2017 12:00:00 AM 3 Width 3ft   6010180.29259 2103880.6842099996 37.7574298137383 -122.40779684417 (37.7574298137383, -122.40779684417)
2159 251203 2 2 2000X Market St 3 5 1 1   06/27/2017 12:00:00 AM 3 4X4 Permit Number 780227 6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
2211 188595 2 5 1301 Rhode Island St 3 2 1 1   07/05/2017 12:00:00 AM 3 Width 7ft   6011997.611930001 2102271.8897 37.7531139870419 -122.401398733477 (37.7531139870419, -122.401398733477)
2302 97526 2 21 532 Folsom St 3 1 1 1     6 3x3 Permit Number 778941 6013958.0435 2114445.5251 37.7866492675441 -122.395471917224 (37.7866492675441, -122.395471917224)
2309 122433 2 15 598X Folsom St 3 1 1 1     10 4x4 Permit Number 778941 6013698.925 2114193.6044 37.785943135879 -122.396350747311 (37.785943135879, -122.396350747311)
2311 193166 2 21 282 02nd St 3 1 1 1     11 Width 2ft Permit Number 778941 6013536.23807 2114063.46383 37.7855767457266 -122.396904475854 (37.7855767457266, -122.396904475854)
2323 201173 2 15 599X Folsom St 3 1 1 1     6 Width 0ft Permit Number 778941 6013705.0945 2114111.3445 37.7857176125048 -122.39632363473801 (37.7857176125048, -122.396323634738)
2336 195020 2 15 300X 02nd St 3 1 1 1     6 Width 3ft   6013662.142659999 2113947.50545 37.785265358143896 -122.39646074858601 (37.7852653581439, -122.396460748586)
2339 253036 2 11 545 Folsom St 3 1 1 1       3x3   6013839.0 2114264.0 37.786144219590796 -122.395871057304 (37.7861442195908, -122.395871057304)
2394 125087 2 5 2498X Pierce St 3 1 1 1     16 Width 4ft Permit Number 779691 6001734.0 2116823.0 37.7924897105997 -122.437934432064 (37.7924897105997, -122.437934432064)
2417 201819 2 48 100 Friedell St 3 2 1 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021071.50009 2093300.7706900002 37.7289831323462 -122.369399226393 (37.7289831323462, -122.369399226393)
2463 106683 2 5 125 Maple St 3 1 1 1     6 6x300   5996555.44655 2115800.39633 37.789386070660704 -122.45577832652201 (37.7893860706607, -122.455778326522)
2505 127968 2 32 73 Castle St 3 1 1 1     13 Width 1ft   6011251.91529 2119582.84216 37.8006042192626 -122.405196407682 (37.8006042192626, -122.405196407682)
2512 178827 2 88 927 Brazil Ave 3 1 1 1     5 Width 3ft   6004338.08735 2090755.04432 37.7210610008535 -122.427066663506 (37.7210610008535, -122.427066663506)
2535 246841 2 11 301 Broderick St 3 4 1 10     14 Width 3ft   6001195.01805 2109899.62825 37.7734492368388 -122.439302846449 (37.7734492368388, -122.439302846449)
2605 253138 2 41 40 Brady St 3 1 1 1       Width 2ft   6006614.59932 2109591.90022 37.7729112084036 -122.42053385147 (37.7729112084036, -122.42053385147)
2622 238126 2 15 3388 17th St 3 1 1 1   07/24/2017 02:38:00 PM 3 Width 3ft   6006363.87344 2106134.73006 37.7634045065344 -122.421155613935 (37.7634045065344, -122.421155613935)
2625 248771 2 60 1 Cuesta Ct 3 2 1 1     13 Width 8ft   5999742.36883 2101773.9828 37.751055459558394 -122.4437438777 (37.7510554595584, -122.4437438777)
2684 233816 2 41 41 Brady St 3 1 1 1     9 Width 3ft   6006595.43726 2109656.08938 37.7730863765667 -122.420604692871 (37.7730863765667, -122.420604692871)
2692 100830 2 188 1601X North Point St 3 1 1 1     12 3x3   6003038.84698 2120959.7606900004 37.8039222967503 -122.433715418836 (37.8039222967503, -122.433715418836)
2747 177162 2 11 221 Sunnydale Ave 3 1 1 1     12 Width 0ft Permit Number 780274 6007512.10716 2087312.1903 37.711786621718296 -122.415851310014 (37.7117866217183, -122.415851310014)
2783 252852 2 80 100X Langton St 3 1 1 1       2.5x4   6010166.0 2110701.0 37.776156040570996 -122.408327321329 (37.776156040571, -122.408327321329)
2812 206249 2 26 450 Irving St 3 1 1 1     3 Width 3ft   5994303.087119999 2106698.53981 37.7642652836473 -122.46291056368601 (37.7642652836473, -122.462910563686)
2817 253222 2 20 148 Felton St 3 1 1 1       Width 3ft   6010428.10303 2093767.62468 37.729675416078294 -122.406227307752 (37.7296754160783, -122.406227307752)
2824 124729 2 43 198X Division St 3 1 1 1       3x3   6010680.0 2108566.0 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104)
2837 241584 2 37 38X Java St 3 2 1 1     7 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2855 110902 2 1 2300x Franklin St 3 1 1 1     15 3x3   6005485.732559999 2117962.0378900003 37.795829853409295 -122.425034389936 (37.7958298534093, -122.425034389936)
2856 253264 2 75 2425 Ocean Ave 3 1 1 1       3x3   5991946.0 2094328.0 37.730162918760904 -122.470162120918 (37.7301629187609, -122.470162120918)
2864 209183 2 17 140 Kensington Way 3 13 1 1   08/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780524 5994862.40668 2098482.07156 37.741737150351 -122.460380669142 (37.741737150351, -122.460380669142)
2866 253244 2 12 299X Moncada Way 3 1 1 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2901 253237 2 12 101 Paloma Ave 3 1 1 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2907 140271 2 62 2040 Hayes St 3 1 1 1   08/11/2017 12:00:00 AM 3 Width 0ft   5998106.0231 2109982.4655 37.773500418432704 -122.44999404654301 (37.7735004184327, -122.449994046543)
Powered by Datasette · Query took 3.811ms · Data source: data.sfgov.org