sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
39582 229804 2 52 10 Crescent Ave 7 17 1 1     6 Width 5ft   6005354.49537 2095898.81655 37.7352420900484 -122.423918818711 (37.7352420900484, -122.423918818711)
161626 226818 2 52 272 Corbett Ave 2 17 1 1     7 Width 3ft   5999639.14958 2105380.58985 37.7609524294432 -122.44435997895599 (37.7609524294432, -122.444359978956)
29106 229884 2 52 137 Bradford St 1 10 1 1     11 Width 5ft   6009563.00843 2097787.4840700002 37.7406646584401 -122.409501640412 (37.7406646584401, -122.409501640412)
60525 226466 2 52 7 28th St 4 10 1 1     3 Width 3ft   6005836.7555 2099627.17961 37.7455065507954 -122.42251630979901 (37.7455065507954, -122.422516309799)
68990 190712 2 52 204 Texas St 2 10 1 1     14 Width 3ft   6013703.78505 2106091.36578 37.763696485831204 -122.395766012395 (37.7636964858312, -122.395766012395)
73729 229870 2 52 3952 26th St 1 10 1 1     9 Width 3ft   6004170.69747 2100746.77802 37.7484865785056 -122.42835706113001 (37.7484865785056, -122.42835706113)
118394 229868 2 52 248 28th St 1 10 1 1     10 Width 3ft   6004337.80093 2099585.8632799997 37.7453084292413 -122.427696518086 (37.7453084292413, -122.427696518086)
120446 229783 2 52 975 San Bruno Ave 1 10 1 1     12 Width 4ft   6011090.02369 2103815.82999 37.7573026253193 -122.404646049572 (37.7573026253193, -122.404646049572)
24100 229778 2 52 1201 Vermont St 48 9 1 1     3 Width 4ft   6011440.8047 2102625.1691799997 37.754052932322395 -122.40334914446301 (37.7540529323224, -122.403349144463)
24885 229758 2 52 1201 Vermont St 28 9 1 1     3 Width 4ft   6011460.45759 2102239.71319 37.7529956524374 -122.40325406633801 (37.7529956524374, -122.403254066338)
27865 229765 2 52 1201 Vermont St 35 9 1 1     3 Width 4ft   6011453.422780001 2102371.80516 37.753357955114396 -122.40328768569401 (37.7533579551144, -122.403287685694)
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)
30489 229761 2 52 1201 Vermont St 31 9 1 1     5 Width 4ft   6011456.4035 2102287.48645 37.753126600912296 -122.40327144663401 (37.7531266009123, -122.403271446634)
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)
33460 229759 2 52 1201 Vermont St 29 9 1 1     6 Width 4ft   6011459.21947 2102251.51401 37.753027985753 -122.403259178089 (37.753027985753, -122.403259178089)
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)
37674 229769 2 52 1201 Vermont St 39 9 1 1     3 Width 4ft   6011449.91996 2102448.3530599996 37.7535679432079 -122.403305183785 (37.7535679432079, -122.403305183785)
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)
42197 226381 2 52 60 Nebraska St 1 9 1 1     7 Width 3ft   6009264.00065 2097705.48363 37.740422744414396 -122.410529710297 (37.7404227444144, -122.410529710297)
45485 229864 2 52 76 Peralta Ave 1 9 1 1     6 Width 5ft   6010511.83754 2100376.53881 37.7478267603098 -122.406403320374 (37.7478267603098, -122.406403320374)
46451 190747 2 52 200 Kansas St 7 9 1 1     13 Width 4ft   6011390.12769 2107238.8028700002 37.766718110788105 -122.40384902720899 (37.7667181107881, -122.403849027209)
50374 226380 2 52 60 Nebraska St 2 9 1 1     13 Width 3ft   6009262.96454 2097691.6296900003 37.740384646425795 -122.410532314727 (37.7403846464258, -122.410532314727)
52880 176585 2 52 205 Seneca Ave 3 9 1 1     1 Width 6ft   5999821.59853 2090369.86807 37.719746961831 -122.442651149242 (37.719746961831, -122.442651149242)
53861 176586 2 52 205 Seneca Ave 4 9 1 1     2 Width 6ft   5999824.12192 2090353.8387799999 37.7197030929005 -122.44264127649099 (37.7197030929005, -122.442641276491)
54362 229782 2 52 1201 Vermont St 52 9 1 1     6 Width 4ft   6011435.782240001 2102697.98371 37.7542525844934 -122.40337163559201 (37.7542525844934, -122.403371635592)
56978 190748 2 52 200 Kansas St 8 9 1 1     18 Width 4ft   6011391.69355 2107207.84436 37.7666331931997 -122.403841432442 (37.7666331931997, -122.403841432442)
59146 229752 2 52 1201 Vermont St 20 9 1 1     3 Width 4ft   6011465.52618 2102102.51804 37.7526192277045 -122.403226887931 (37.7526192277045, -122.403226887931)
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)
61898 229781 2 52 1201 Vermont St 51 9 1 1     3 Width 4ft   6011437.0323 2102686.7718700003 37.754221869065795 -122.40336652384799 (37.7542218690658, -122.403366523848)
70859 226812 2 52 2 Belcher St 5 9 1 1     8 Width 1ft   6003760.63198 2108231.56549 37.7690148102126 -122.430308989291 (37.7690148102126, -122.430308989291)
71654 229780 2 52 1201 Vermont St 50 9 1 1     1 Width 4ft   6011438.150669999 2102669.0861400003 37.7541733704045 -122.40336141212099 (37.7541733704045, -122.403361412121)
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)
73438 190716 2 52 333 Arkansas St 1 9 1 1     7 Width 3ft   6012961.26572 2105490.25457 37.7620046335244 -122.398291995789 (37.7620046335244, -122.398291995789)
108696 226792 2 52 379 Collingwood St 1 9 1 1     6 Width 3ft   6002133.75148 2103664.46985 37.7563823922541 -122.435609479191 (37.7563823922541, -122.435609479191)
130489 229763 2 52 1201 Vermont St 33 9 1 1     2 Width 4ft   6011453.21392 2102329.36922 37.753241423671795 -122.403285422977 (37.7532414236718, -122.403285422977)
136124 229774 2 52 1201 Vermont St 44 9 1 1     3 Width 4ft   6011445.35286 2102545.22023 37.7538336641006 -122.403327791844 (37.7538336641006, -122.403327791844)
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)
138131 201517 2 52 911 Innes Ave 3 9 1 1     2 Width 5ft   6019123.25931 2094488.31096 37.7321368236424 -122.37621683574699 (37.7321368236424, -122.376216835747)
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)
146597 229766 2 52 1201 Vermont St 36 9 1 1     5 Width 4ft   6011452.91917 2102390.65584 37.7534096868171 -122.403290753279 (37.7534096868171, -122.403290753279)
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)
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)
154565 229776 2 52 1201 Vermont St 46 9 1 1     5 Width 4ft   6011441.50409 2102586.88485 37.7539478510307 -122.40334403271002 (37.7539478510307, -122.40334403271)
158462 229757 2 52 1201 Vermont St 26 9 1 1     5 Width 4ft   6011461.99954 2102213.77594 37.752924520553 -122.40324690953301 (37.752924520553, -122.403246909533)
165182 226799 2 52 701 Sanchez St 1 9 1 1     7 Width 3ft   6003733.12478 2104096.2711400003 37.7576587280713 -122.43010909155899 (37.7576587280713, -122.430109091559)
169635 229751 2 52 1201 Vermont St 19 9 1 1     6 Width 4ft   6011465.75975 2102083.1370200003 37.7525660247145 -122.40322471696999 (37.7525660247145, -122.40322471697)
171101 229764 2 52 1201 Vermont St 34 9 1 1     3 Width 4ft   6011452.97986 2102350.02958 37.753298139414 -122.403287685686 (37.753298139414, -122.403287685686)
179268 229775 2 52 1201 Vermont St 45 9 1 1     3 Width 4ft   6011442.57459 2102566.84517 37.7538928862632 -122.40333892097799 (37.7538928862632, -122.403338920978)
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)
180784 226793 2 52 379 Collingwood St 2 9 1 1     6 Width 3ft   6002133.14773 2103676.3157099998 37.756414883846105 -122.435612414605 (37.7564148838461, -122.435612414605)
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)
18620 121737 3 52 1301 Vermont St 12 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
18708 121749 3 52 1201x Vermont St 12 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
38097 190683 2 52 1301 Minnesota St 39 7 1 1     4     6015372.42654 2102509.7647599997 37.7539548603504 -122.389744472134 (37.7539548603504, -122.389744472134)
45346 121804 3 52 1201x Vermont St 22 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
76134 121731 3 52 1301 Vermont St 6 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
83237 121751 3 52 1201x Vermont St 14 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
83874 121745 3 52 1201x Vermont St 8 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
84849 121803 3 52 1201x Vermont St 21 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
85431 121738 3 52 1201x Vermont St 1 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
87306 121748 3 52 1201x Vermont St 11 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
88761 121736 3 52 1301 Vermont St 11 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
90523 121755 3 52 1201x Vermont St 18 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
91849 121726 3 52 1301 Vermont St 1 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
94087 121729 3 52 1301 Vermont St 4 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
97349 121756 3 52 1201x Vermont St 19 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
100467 121733 3 52 1301 Vermont St 8 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
102223 121743 3 52 1201x Vermont St 6 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
106820 121744 3 52 1201x Vermont St 7 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
113793 121754 3 52 1201x Vermont St 17 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
115454 121741 3 52 1201x Vermont St 4 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
115692 121739 3 52 1201x Vermont St 2 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
116473 121727 3 52 1301 Vermont St 2 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
116581 121753 3 52 1201x Vermont St 16 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
118593 121742 3 52 1201x Vermont St 5 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
118602 121752 3 52 1201x Vermont St 15 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
118748 121728 3 52 1301 Vermont St 3 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
123068 121746 3 52 1201x Vermont St 9 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
123543 121747 3 52 1201x Vermont St 10 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
126474 121730 3 52 1301 Vermont St 5 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
129304 121740 3 52 1201x Vermont St 3 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
131666 190744 2 52 2086 Quesada Ave 1 7 1 1     1     6012709.58294 2096557.7365 37.737463838180496 -122.398535643704 (37.7374638381805, -122.398535643704)
135152 226806 2 52 190 Storrie St 8 7 1 1     3 Width 3ft   6000773.9022 2105295.6973200003 37.7607840134024 -122.440429287805 (37.7607840134024, -122.440429287805)
138519 121750 3 52 1201x Vermont St 13 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
145396 121735 3 52 1301 Vermont St 10 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
146000 121757 3 52 1201x Vermont St 20 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
15582 106047 2 52 618- 622 Carolina St 1 5 1 1     15 6x7   6012364.1992 2105044.14437 37.7607464370199 -122.40032569478599 (37.7607464370199, -122.400325694786)
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)
33217 247662 2 52 108 Divisadero St 1 4 1 1     7 Width 3ft   6001959.68947 2108344.83823 37.769223654362605 -122.436546435187 (37.7692236543626, -122.436546435187)
39045 190719 2 52 642 Mississippi St 1 4 1 1     13 Width 4ft   6014091.4532699995 2104130.33792 37.75833348851889 -122.39428786959 (37.7583334885189, -122.39428786959)
45365 201527 2 52 740 Earl St 4 4 1 1     6 Width 5ft   6020341.20189 2093704.82943 37.730052512603294 -122.371951898056 (37.7300525126033, -122.371951898056)
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)
57800 190715 2 52 350 Texas St 1 4 1 1     12 Width 4ft   6013737.51284 2105460.97147 37.7619674375704 -122.395605187539 (37.7619674375704, -122.395605187539)
61921 228526 2 52 405 Florida St 2 4 1 1     1 Width 3ft   6009242.70378 2106296.2843400002 37.7640099687976 -122.41121004561701 (37.7640099687976, -122.411210045617)
63247 190720 2 52 315 Mississippi St 1 4 1 1     8 Width 3ft   6014070.97859 2105596.2230599998 37.762357352140796 -122.394461321843 (37.7623573521408, -122.394461321843)
63954 228524 2 52 29 Pearl St 1 4 1 1     8 Width 3ft   6005636.60822 2108865.67188 37.7708619961085 -122.42386519303999 (37.7708619961085, -122.42386519304)
71295 228531 2 52 1744 Bryant St 1 4 1 1     8 Width 3ft   6009451.253190001 2106552.40785 37.7647249190387 -122.41050681893199 (37.7647249190387, -122.410506818932)
72428 190718 2 52 446 Missouri St 1 4 1 1     6 Width 3ft   6013483.0407 2105010.44498 37.7607162323997 -122.39645373295299 (37.7607162323997, -122.396453732953)
133554 190713 2 52 529 Texas St 3 4 1 1     7 Width 3ft   6013844.9587900005 2104593.96331 37.759592798384105 -122.395172837551 (37.7595927983841, -122.395172837551)
Powered by Datasette · Query took 14.231ms · Data source: data.sfgov.org