sf-trees

Data source: data.sfgov.org

Custom SQL query returning 71 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
23793 226377 2 52 267 Anderson St 1 1 1 1     4 Width 3ft   6007909.30084 2097390.1768 37.739480940202 -122.415191429754 (37.739480940202, -122.415191429754)
25685 228535 2 52 1000 15th St 4 1 1 1     4 Width 3ft   6009303.88793 2107359.3535700003 37.766932343692005 -122.411073521351 (37.766932343692, -122.411073521351)
25976 190714 2 52 375 Texas St 2 4 1 1     4 Width 5ft   6013800.48111 2105372.99908 37.761729387017496 -122.39538124017099 (37.7617293870175, -122.395381240171)
26212 226420 2 52 632 Shotwell St 1 1 1 1     4 Width 3ft   6007871.67107 2104237.7229400002 37.7582806479376 -122.41580628094101 (37.7582806479376, -122.415806280941)
27981 229753 2 52 1201 Vermont St 21 9 1 1     4 Width 4ft   6011465.791619999 2102125.84808 37.7526833017063 -122.40322761098899 (37.7526833017063, -122.403227610989)
30560 32977 1 52 448 Pennsylvania Ave 1 1 1 1 1 07/25/2003 12:00:00 AM 4   Permit Number 46744 6014321.91414 2105021.23892 37.76079251737271 -122.393553179256 (37.7607925173727, -122.393553179256)
31243 229777 2 52 1201 Vermont St 47 9 1 1     4 Width 4ft   6011441.00674 2102606.02985 37.7540003912143 -122.403347099413 (37.7540003912143, -122.403347099413)
31398 229872 2 52 3731 23rd St 1 1 1 1     4 Width 3ft   6004865.55222 2102495.62663 37.7533278053416 -122.42607874566299 (37.7533278053416, -122.426078745663)
31417 219235 2 52 5 Sequoia Way 5 2 1 1     4 Width 3ft   5998215.18129 2097817.79881 37.7401055166597 -122.44874010447599 (37.7401055166597, -122.448740104476)
33834 228551 2 52 1398 Florida St 2 1 1 1     4 Width 3ft   6009530.29917 2101073.08548 37.7496843657442 -122.409846607735 (37.7496843657442, -122.409846607735)
35475 229770 2 52 1201 Vermont St 40 9 1 1     4 Width 4ft   6011448.51225 2102466.33912 37.753617250356996 -122.403311317166 (37.753617250357, -122.403311317166)
35984 229773 2 52 1201 Vermont St 43 9 1 1     4 Width 4ft   6011446.65854 2102520.5438599996 37.7537659811344 -122.403321540662 (37.7537659811344, -122.403321540662)
37810 39586 1 52 1011 Rhode Island St 1 1 1 1 1 12/28/1998 12:00:00 AM 4   Permit Number 40997 6011941.43836 2103546.16349 37.756609729177896 -122.401682552328 (37.7566097291779, -122.401682552328)
38097 190683 2 52 1301 Minnesota St 39 7 1 1     4     6015372.42654 2102509.7647599997 37.7539548603504 -122.389744472134 (37.7539548603504, -122.389744472134)
40345 94180 1 52 605 San Bruno Ave 1 1 1 1   06/22/2010 12:00:00 AM 4 3x3 Permit Number 53586 6010991.81939 2105452.40233 37.7617907981332 -122.40510091500201 (37.7617907981332, -122.405100915002)
41876 229756 2 52 1201 Vermont St 24 9 1 1     4 Width 4ft   6011464.1555699995 2102190.87321 37.7528617550894 -122.40323784257299 (37.7528617550894, -122.403237842573)
42016 190686 2 52 801 Mariposa St 3 1 1 1     4 Width 3ft   6014799.41703 2106205.9134299997 37.7640718970256 -122.391984541257 (37.7640718970256, -122.391984541257)
42426 190691 2 52 1005 Minnesota St 1 2 1 1     4 Width 4ft   6015298.330490001 2103800.67785 37.757495323968 -122.39009089187901 (37.757495323968, -122.390090891879)
43371 100400 2 52 88 Manchester St 1 1 1 1     4 6x3   6008223.0 2099495.0 37.7452779444232 -122.41425567326598 (37.7452779444232, -122.414255673266)
44390 229826 2 52 1312 York St 1 1 1 1     4 Width 4ft   6010048.8848 2101524.58992 37.750953146384 -122.408085148809 (37.750953146384, -122.408085148809)
45723 190690 2 52 1003 Minnesota St 1 2 1 1     4 Width 4ft   6015296.6982 2103817.69544 37.757541960103396 -122.39009772585501 (37.7575419601034, -122.390097725855)
47604 69898 2 52 1019 Rhode Island St 1 1 1 1 1 10/07/2000 12:00:00 AM 4     6011946.5334 2103437.3528 37.756311243277004 -122.401657284058 (37.756311243277, -122.401657284058)
49531 226394 2 52 1451 Shotwell St 1 1 1 1     4 Width 3ft   6008031.02829 2099712.8613299998 37.7458653577975 -122.41493489813699 (37.7458653577975, -122.414934898137)
49682 190742 2 52 1617 Kirkwood Ave 1 4 1 1     4 Width 4ft   6015073.9615 2096817.26033 37.738307875303796 -122.390378936647 (37.7383078753038, -122.390378936647)
54680 190737 2 52 168 Utah St 1 1 1 1     4 Width 4ft   6010533.3608099995 2107625.71159 37.767732572127294 -122.406839724475 (37.7677325721273, -122.406839724475)
56727 228536 2 52 1000 15th St 5 1 1 1     4 Width 3ft   6009279.45147 2107357.51638 37.7669259288053 -122.411157913712 (37.7669259288053, -122.411157913712)
58441 229861 2 52 1509 York St 1 1 1 1     4 Width 3ft   6010132.55959 2100497.5838599997 37.7481378987515 -122.407723384842 (37.7481378987515, -122.407723384842)
61430 229754 2 52 1201 Vermont St 22 9 1 1     4 Width 4ft   6011464.93054 2102145.24186 37.7527365046859 -122.403231952908 (37.7527365046859, -122.403231952908)
61585 229787 2 52 1799 15th St 1 1 1 1     4 Width 3ft   6005558.49234 2107230.4627 37.7663676926515 -122.42401909489901 (37.7663676926515, -122.424019094899)
63640 38604 1 52 1556 Revere Ave 1 1 1 1   06/02/2008 12:00:00 AM 4 3x3 Permit Number 50557 6015379.8321 2094216.5354 37.7311837737961 -122.38913983494801 (37.7311837737961, -122.389139834948)
69907 226357 2 52 645 San Jose Ave 1 1 1 1     4 Width 3ft   6005980.007540001 2099557.6277 37.7453236574624 -122.42201602593799 (37.7453236574624, -122.422016025938)
70491 226372 2 52 4222 26th St 2 1 1 1     4 Width 3ft   6002353.94285 2100643.26716 37.748099392475 -122.43463195751801 (37.748099392475, -122.434631957518)
72129 229771 2 52 1201 Vermont St 41 9 1 1     4 Width 4ft   6011447.677180001 2102483.4305 37.7536641328931 -122.403315407293 (37.7536641328931, -122.403315407293)
74899 190694 2 52 99 Missouri St 1 1 1 1     4 Width 3ft   6013445.19565 2106684.95045 37.7653119497171 -122.396702014197 (37.7653119497171, -122.396702014197)
75203 226822 2 52 39 Whitney St 1 1 1 1     4 Width 3ft   6004297.5525 2098038.31795 37.7410569481125 -122.42772544836599 (37.7410569481125, -122.427725448366)
83699 102167 1 52 677 Castro St 1 1 1 1 1 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769761 6002448.6 2104297.1 37.7581373205651 -122.4345658575 (37.7581373205651, -122.4345658575)
106016 226435 2 52 106 Bartlett St 9 1 1 1     4 Width 3ft   6006660.81941 2103136.07502 37.75518763210621 -122.419915770819 (37.7551876321062, -122.419915770819)
113367 34979 1 52 204 Fair Oaks St 2 1 1 1   12/18/1997 12:00:00 AM 4 4.5x5.5 Permit Number 38560 6005404.47969691 2102506.81993306 37.75338898431921 -122.424215816798 (37.7533889843192, -122.424215816798)
119848 229838 2 52 28 Lapidge St 1 1 1 1     4 Width 3ft   6005984.4522400005 2105323.33984 37.7611552229594 -122.422410255427 (37.7611552229594, -122.422410255427)
130013 116873 2 52 1250 17th St 2 1 1 1     4 3x3   6013484.98836 2106649.50082 37.7652168275233 -122.396561894417 (37.7652168275233, -122.396561894417)
134711 229867 2 52 474 Day St 1 1 1 1     4 Width 3ft   6002892.54695 2098627.83365 37.7425960442853 -122.432625542146 (37.7425960442853, -122.432625542146)
136900 229779 2 52 1201 Vermont St 49 9 1 1     4 Width 4ft   6011439.173280001 2102646.69218 37.75411193863 -122.403356300366 (37.75411193863, -122.403356300366)
140184 229768 2 52 1201 Vermont St 38 9 1 1     4 Width 4ft   6011450.10406 2102428.33109 37.7535129775571 -122.40330313873301 (37.7535129775571, -122.403303138733)
147848 229762 2 52 1201 Vermont St 32 9 1 1     4 Width 4ft   6011454.29465 2102314.61303 37.7532009667707 -122.403280647606 (37.7532009667707, -122.403280647606)
149086 229895 2 52 1429 Shotwell St 1 1 1 1     4 Width 2ft   6008018.20821 2099852.6789700002 37.7462485454514 -122.41498912275101 (37.7462485454514, -122.414989122751)
149742 229772 2 52 1201 Vermont St 42 9 1 1     4 Width 4ft   6011446.86383 2102500.86077 37.7537119471592 -122.403319446151 (37.7537119471592, -122.403319446151)
150318 38603 1 52 1556 Revere Ave 3 1 1 1   06/02/2008 12:00:00 AM 4 3x3 Permit Number 50557 6015358.9468 2094230.8253 37.7312218531881 -122.38921303719499 (37.7312218531881, -122.389213037195)
154235 229844 2 52 3676 20th St 1 1 1 1     4 Width 4ft   6005793.115569999 2104343.5803900003 37.7584542377953 -122.423002369088 (37.7584542377953, -122.423002369088)
154343 226352 2 52 3133 18th St 1 1 1 1     4 Width 2ft   6007317.42838 2105554.4356 37.761864862688604 -122.417816432095 (37.7618648626886, -122.417816432095)
155759 226368 2 52 4252 25th St 1 1 1 1     4 Width 4ft   6002219.8956 2101222.17774 37.7496813332396 -122.43513688726001 (37.7496813332396, -122.43513688726)
156248 229848 2 52 3494 21st St 4 1 1 1     4 Width 5ft   6005112.08271 2103723.9282400003 37.75671436528889 -122.42531359166901 (37.7567143652889, -122.425313591669)
157614 190697 2 52 99 Missouri St 5 1 1 1     4 Width 3ft   6013439.7362 2106789.19698 37.7655978837597 -122.396728206045 (37.7655978837597, -122.396728206045)
158140 226358 2 52 603 San Jose Ave 2 1 1 1     4 Width 3ft   6006078.34429 2099888.6136 37.7462380152724 -122.42169949783899 (37.7462380152724, -122.421699497839)
160436 88048 1 52 1555 Jerrold Ave 1 1 1 1   06/24/2008 12:00:00 AM 4 3x3 Permit Number 51058 6015584.72865 2096785.6405200001 37.73824937351 -122.388610732819 (37.73824937351, -122.388610732819)
162409 226436 2 52 106 Bartlett St 10 1 1 1     4 Width 3ft   6006661.6983199995 2103152.67554 37.755233262826295 -122.419913909217 (37.7552332628263, -122.419913909217)
163771 190688 2 52 1001 Minnesota St 2 2 1 1     4 Width 4ft   6015295.35609 2103854.9870599997 37.7576442804869 -122.390104972579 (37.7576442804869, -122.390104972579)
166694 50730 1 52 725 Carolina St 1 1 1 1   02/02/2004 12:00:00 AM 4   Permit Number 47280 6012445.19576 2104545.72863 37.7593824136929 -122.400010559737 (37.7593824136929, -122.400010559737)
169236 190695 2 52 99 Missouri St 2 1 1 1     4 Width 3ft   6013444.76571 2106699.32295 37.765351389493105 -122.39670450891701 (37.7653513894931, -122.396704508917)
170855 35338 1 52 738 Arkansas St 1 1 1 1 1 02/23/1998 12:00:00 AM 4   Permit Number 38803 6013013.2913 2103555.4038400003 37.7566948554054 -122.397976322051 (37.7566948554054, -122.397976322051)
171048 229849 2 52 86 Fair Oaks St 1 1 1 1     4 Width 3ft   6005369.70063 2103246.31322 37.7554174970228 -122.42438868391199 (37.7554174970228, -122.424388683912)
172297 190698 2 52 99 Missouri St 6 1 1 1     4 Width 3ft   6013440.0708800005 2106805.7081400002 37.765643238376796 -122.396728206061 (37.7656432383768, -122.396728206061)
172607 190687 2 52 1001 Minnesota St 3 2 1 1     4 Width 4ft   6015294.95519 2103873.52866 37.7576951695231 -122.390107654354 (37.7576951695231, -122.390107654354)
174390 229887 2 52 87 Manchester St 1 1 1 1     4 Width 3ft   6008255.9932699995 2099554.30466 37.745442635078 -122.414145782603 (37.745442635078, -122.414145782603)
174788 190745 2 52 1617 Kirkwood Ave 1 4 1 1     4 Width 3ft   6015075.48119 2096817.4615200001 37.7383085120296 -122.39037369631501 (37.7383085120296, -122.390373696315)
176880 229750 2 52 365 Fair Oaks St 2 1 1 1     4 Width 4ft   6005497.63156 2101589.27142 37.750874867598206 -122.423828439536 (37.7508748675982, -122.423828439536)
179500 78429 2 52 744 Rhode Island St 1 1 1 1 1 10/07/2000 12:00:00 AM 4 3x3   6011805.9335 2104893.37298 37.7603013058687 -122.402245896623 (37.7603013058687, -122.402245896623)
180024 229767 2 52 1201 Vermont St 37 9 1 1     4 Width 4ft   6011451.55336 2102410.70185 37.7534646524788 -122.40329688663799 (37.7534646524788, -122.403296886638)
180443 229755 2 52 1201 Vermont St 23 9 1 1     4 Width 4ft   6011464.24481 2102169.9708 37.7528043666378 -122.40323606370701 (37.7528043666378, -122.403236063707)
181303 229760 2 52 1201 Vermont St 30 9 1 1     4 Width 4ft   6011458.91565 2102265.65077 37.753066785227105 -122.40326122314501 (37.7530667852271, -122.403261223145)
182980 62086 1 52 508 Connecticut St 1 1 1 1 1 08/20/1985 12:00:00 AM 4   Permit Number 22172 6013224.51154 2104585.93548 37.759536231938206 -122.39731810554501 (37.7595362319382, -122.397318105545)
187160 228539 2 52 1000 15th St 8 1 1 1     4 Width 3ft   6009212.74652 2107353.73928 37.766911816665704 -122.41138836950199 (37.7669118166657, -122.411388369502)
Powered by Datasette · Query took 8.817ms · Data source: data.sfgov.org