sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
20491 85214   52 2889 24th St 1 1 1 2 3 04/13/2007 12:00:00 AM 3 3x3 under 3yr maintenance agreement. ends on 4/13/2007 6009588.01504 2102148.81833 37.75264132339179 -122.409722943913 (37.7526413233918, -122.409722943913)
42741 85379   18 3390 Cesar Chavez St 6 1 1 2     3 3x3   6007302.06128 2100623.1120599997 37.7483237124677 -122.417520070933 (37.7483237124677, -122.417520070933)
61148 85309   41 1250 Haight St 1 1 1 2 3 07/26/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
80888 87432   6 598X Alemany Blvd 1 1 1 2   04/22/2008 12:00:00 AM 3 3x3   6006099.613365 2094764.868461 37.732170557364995 -122.421262171784 (37.732170557365, -122.421262171784)
82777 85446   127 360Y12 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
83194 87400   82 400X Monterey Blvd 10 11 1 2   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815)
85180 85312   11 1366 Turk St 2 1 1 2     9 3x3   6003535.852940001 2112477.60862 37.780660663043605 -122.431389631549 (37.7806606630436, -122.431389631549)
88231 85433   127 360Y1 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
89317 85483   1 2448 Hyde St 1 1 1 2     24 3x3   6007028.643792 2120821.987554 37.8037695888063 -122.419898663276 (37.8037695888063, -122.419898663276)
91145 87431   6 522X Alemany Blvd 2 1 1 2   04/22/2008 12:00:00 AM 3 3x3   6006584.964111 2094794.1521 37.732278314780295 -122.419586279513 (37.7322783147803, -122.419586279513)
91687 85306   55 1661 Pine St 10 1 1 2     6 3x3   6005989.138522 2115548.501173 37.789231309471795 -122.423120870526 (37.7892313094718, -122.423120870526)
95026 85377   18 3390 Cesar Chavez St 3 1 1 2     3 3x3   6007302.06128 2100623.1120599997 37.7483237124677 -122.417520070933 (37.7483237124677, -122.417520070933)
95845 85448   127 360Y14 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
96265 85437   127 360Y4 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
96662 87399   82 400X Monterey Blvd 9 11 1 2   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815)
97533 85444   127 360Y10 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
98712 85439   127 360Y5 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
99579 85445   127 360Y11 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
102642 85435   127 360Y3 Valencia St   1 1 2 3 08/07/2006 12:00:00 AM 3 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
103498 85440   127 360Y6 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
104112 87433   6 598X Alemany Blvd 2 1 1 2   04/22/2008 12:00:00 AM 3 3x3   6006099.613365 2094764.868461 37.732170557364995 -122.421262171784 (37.732170557365, -122.421262171784)
105765 87423   11 45X Jones St 2 1 1 2   04/22/2008 12:00:00 AM 3 3x3   6009092.517833999 2112687.614007 37.7815506408215 -122.412181237011 (37.7815506408215, -122.412181237011)
105788 85443   127 360Y9 Valencia St   1 1 2 3   6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
107509 87402   16 1300 Webster St 7 11 1 2   04/21/2008 12:00:00 AM 3 3x3   6003725.160049 2113179.0694110002 37.7825974263114 -122.430784800607 (37.7825974263114, -122.430784800607)
108522 113066   47 2X Cranleigh Dr 7 4 1 2   09/09/2015 01:08:00 PM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664)
110133 87430   6 522X Alemany Blvd 1 1 1 2   04/22/2008 12:00:00 AM 3 3x3   6006584.964111 2094794.1521 37.732278314780295 -122.419586279513 (37.7322783147803, -122.419586279513)
117485 87401   82 400X Monterey Blvd 11 11 1 2   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815)
117918 87429   6 500X Alemany Blvd 1 1 1 2   04/22/2008 12:00:00 AM 3 3x3   6006724.46969 2094782.06277 37.7322529772765 -122.419103118684 (37.7322529772765, -122.419103118684)
119480 87425   17 25X Jones St   1 1 2   04/22/2008 12:00:00 AM 3 3x3   6009102.081359 2112621.9601169997 37.781370907497 -122.41214351023399 (37.781370907497, -122.412143510234)
119540 85436   11 1397X Buchanan St 7 1 1 2 3 08/17/2007 12:00:00 AM 3 3x3 Maintenance agreement ends 8/17/2010 6004184.830731 2113056.513958 37.782286952179 -122.429185796304 (37.782286952179, -122.429185796304)
120951 85249   131 1335 Fulton St 1 1 1 2 3 07/19/2007 12:00:00 AM 3 3x3 under 3 yr maintenance agreement. expires 7/19/2010 6001350.124369999 2111060.02557 37.7766442216524 -122.43884948393499 (37.7766442216524, -122.438849483935)
122914 85441   127 360Y7 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
123072 85434   127 360Y2 Valencia St   1 1 2 3 08/23/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
123690 85484   1 2448 Hyde St 2 1 1 2     24 3x3   6007028.643792 2120821.987554 37.8037695888063 -122.419898663276 (37.8037695888063, -122.419898663276)
126348 85447   127 360Y13 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
128811 87422   11 45X Jones St 1 1 1 2   04/22/2008 12:00:00 AM       6009092.517833999 2112687.614007 37.7815506408215 -122.412181237011 (37.7815506408215, -122.412181237011)
129428 85380   18 3390 Cesar Chavez St 5 1 1 2     3 3x3   6007302.06128 2100623.1120599997 37.7483237124677 -122.417520070933 (37.7483237124677, -122.417520070933)
138815 87410   11 898X Ellis St 1 1 1 2   04/22/2008 12:00:00 AM 3 3x3   6006570.640875 2113589.260791 37.783884515657896 -122.42096977598499 (37.7838845156579, -122.420969775985)
140895 85310   41 1250 Haight St 2 1 1 2 3 07/27/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
141531 91166   299 1548x Quesada Ave 4 11 1 2   01/31/2009 12:00:00 AM 3     6015526.48125 2094420.051093 37.7317507154659 -122.388647039673 (37.7317507154659, -122.388647039673)
141737 97434   46 1380x Newcomb Ave 5 11 1 2   09/30/2011 12:00:00 AM 3     6016360.63733 2094893.94179 37.7330981190079 -122.38579618360501 (37.7330981190079, -122.385796183605)
143542 85442   127 360Y8 Valencia St   1 1 2 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
145363 85250   131 1335 Fulton St 2 1 1 2 3 07/19/2007 12:00:00 AM 15 3x3 under 3yr maintenance agreement. Expires 7/19/2010. 6001350.124369999 2111060.02557 37.7766442216524 -122.43884948393499 (37.7766442216524, -122.438849483935)
672 23002 1 81 742 Valencia St 1 1 1 2   02/23/1994 12:00:00 AM 20 3X3   6006210.140269999 2105247.24413 37.7609590106658 -122.421624291141 (37.7609590106658, -122.421624291141)
730 195047 1 15 360 06th St 2 4 1 2   03/26/2005 12:00:00 AM 3 Width 3ft Permit Number 42039 6011214.59355 2111232.18316 37.777673209496605 -122.404737337955 (37.7776732094966, -122.404737337955)
899 23949 1 120 2400X Sacramento St 5 1 1 2   10/15/2014 12:00:00 AM 3 4x4 Permit Number 773408 6003202.444680001 2115904.93175 37.7900523252984 -122.43278795880501 (37.7900523252984, -122.432787958805)
1275 4132 1 8 3550 Cesar Chavez St 3 1 1 2   05/09/2017 12:00:00 AM 3 3x3   6006390.9849 2100603.33536 37.7482181038931 -122.420669151754 (37.7482181038931, -122.420669151754)
4915 7094 1 11 1944 Fell St 2 1 1 2   02/05/2016 07:16:00 AM 3 3X3   5998113.0 2109666.0 37.7726318847498 -122.449947100062 (37.7726318847498, -122.449947100062)
6203 23950 1 120 2400X Sacramento St 6 1 1 2   10/15/2014 12:00:00 AM 3 4x4 Permit Number 773408 6003173.29907 2115903.30394 37.7900462027047 -122.432888683778 (37.7900462027047, -122.432888683778)
6674 5302 1 2 1635 Divisadero St 4 1 1 2     8 3X3   6001111.6921 2113998.3714 37.7846986031206 -122.439885016276 (37.7846986031206, -122.439885016276)
7359 23947 1 120 2400X Sacramento St 3 1 1 2   10/15/2014 12:00:00 AM 3 4x4 Permit Number 773408 6003237.41295 2115911.3949 37.7900720546314 -122.432667433453 (37.7900720546314, -122.432667433453)
7534 5301 1 2 1635 Divisadero St 3 1 1 2     6 3X3   6001109.2323 2114011.9005 37.7847356105359 -122.43989449671301 (37.7847356105359, -122.439894496713)
7630 23948 1 120 2400X Sacramento St 4 1 1 2   10/15/2014 12:00:00 AM 3 4x4 Permit Number 773408 6003227.15919 2115908.88128 37.7900645713585 -122.432702730963 (37.7900645713585, -122.432702730963)
8191 23946 1 120 2400X Sacramento St 2 1 1 2   10/15/2014 12:00:00 AM 3 4x4 Permit Number 773408 6003257.60965 2115913.45554 37.7900788579916 -122.43259770183201 (37.7900788579916, -122.432597701832)
8361 23951 1 120 2400X Sacramento St 7 1 1 2   10/15/2014 12:00:00 AM 3 4x4 Permit Number 773408 6003144.33072 2115898.20328 37.790030554519205 -122.432988547211 (37.7900305545192, -122.432988547211)
12923 111444 1 180 241 Oneida Ave 34 1 1 2 6   14 6x12   5999970.3074 2091024.03837 37.721551640364396 -122.442184051271 (37.7215516403644, -122.442184051271)
15418 94801 1 79 3950X 03rd St 3 1 1 2     6 3x3   6015629.3168 2097929.6865 37.7413931608426 -122.388536401689 (37.7413931608426, -122.388536401689)
15516 22411 1 11 5800 03rd St 10 1 1 2   04/30/2015 07:23:00 AM 3 3X3   6013740.3857 2091977.5191 37.7249448697993 -122.394650999472 (37.7249448697993, -122.394650999472)
18592 5562 1 21 997 Dolores St 1 1 1 2   03/14/2012 12:00:00 AM 3 3x3 Permit Number 768456 6005129.17531 2102577.9580200003 37.7535687642998 -122.425172939503 (37.7535687642998, -122.425172939503)
19194 5349 1 25 200X Dolores St 2 1 1 2   07/22/2010 12:00:00 AM 12 3x3 Permit Number 53640 6004790.705569999 2107143.57223 37.7660857344886 -122.426668539926 (37.7660857344886, -122.426668539926)
22403 9158 1 2 6000 Geary Blvd 4 1 1 2   10/01/1993 12:00:00 AM 3 3X3   5988286.7863 2112649.5845 37.7802568294301 -122.48415543808399 (37.7802568294301, -122.484155438084)
23389 43452 1 180 241 Oneida Ave 12 1 1 2 6 07/18/2000 12:00:00 AM 10   Permit Number 43162 5999577.25447 2091228.40825 37.7220903846374 -122.44355739787599 (37.7220903846374, -122.443557397876)
24577 43433 1 180 241 Oneida Ave 27 1 1 2 6 07/18/2000 12:00:00 AM 16   Permit Number 43162 5999846.51913 2091089.02473 37.7217230223792 -122.442616616172 (37.7217230223792, -122.442616616172)
26060 43443 1 180 241 Oneida Ave 5 1 1 2 6 03/06/2004 12:00:00 AM 6   Permit Number 43162 5999469.30626 2091283.8759 37.722236528981206 -122.44393453036999 (37.7222365289812, -122.44393453037)
28704 43445 1 180 241 Oneida Ave 28 1 1 2 6 07/18/2000 12:00:00 AM 5   Permit Number 43162 5999858.82768 2091082.35027 37.7217053974709 -122.44257358990299 (37.7217053974709, -122.442573589903)
33677 43434 1 180 241 Oneida Ave 26 1 1 2 6 07/18/2000 12:00:00 AM 7   Permit Number 43162 5999832.90051 2091096.8327900001 37.7217436851966 -122.44266425237 (37.7217436851966, -122.44266425237)
39173 43441 1 180 241 Oneida Ave 3 1 1 2 6 01/05/2016 12:00:00 AM 7   Permit Number 774294 5999448.10749 2091294.70392 37.7222650509726 -122.444008586831 (37.7222650509726, -122.444008586831)
39824 43966 1 11 627 Turk St 1 1 1 2 6 08/20/2005 12:00:00 AM 9   Permit Number 43534 6006884.39072 2112892.55093 37.781989200774206 -122.41983486151199 (37.7819892007742, -122.419834861512)
45283 43435 1 180 241 Oneida Ave 25 1 1 2 6 07/18/2000 12:00:00 AM 14   Permit Number 43162 5999819.49506 2091104.19362 37.7217631321556 -122.44271111962699 (37.7217631321556, -122.442711119627)
45429 111443 1 180 241 Oneida Ave 33 1 1 2 6   17     5999927.23458 2091047.72982 37.7216142367899 -122.442334641847 (37.7216142367899, -122.442334641847)
52424 43437 1 180 241 Oneida Ave 1 1 1 2 6 03/06/2004 12:00:00 AM 19   Permit Number 43162 5999381.26407 2091328.9112200001 37.7223551630339 -122.44424210479099 (37.7223551630339, -122.444242104791)
54575 111440 1 180 241 Oneida Ave 30 1 1 2 6   12     5999883.47669 2091070.55057 37.72167440322979 -122.442487538293 (37.7216744032298, -122.442487538293)
63781 43439 1 180 241 Oneida Ave 2 1 1 2 6 01/05/2016 12:00:00 AM 12   Permit Number 774294 5999436.71838 2091300.71882 37.72228091680579 -122.44404838812099 (37.7222809168058, -122.444048388121)
65476 43457 1 180 241 Oneida Ave 7 1 1 2 6 07/18/2000 12:00:00 AM 3   Permit Number 43162 5999502.576 2091265.96486 37.722189247127105 -122.443818239036 (37.7221892471271, -122.443818239036)
66622 43448 1 180 241 Oneida Ave 21 1 1 2 6 07/18/2000 12:00:00 AM 9   Permit Number 43162 5999710.3638 2091158.16281 37.721905097333 -122.443092230725 (37.721905097333, -122.443092230725)
68075 43459 1 180 241 Oneida Ave 17 1 1 2 6 07/18/2000 12:00:00 AM 5   Permit Number 43162 5999660.0285 2091185.4802700002 37.7219772346577 -122.443268187573 (37.7219772346577, -122.443268187573)
70842 27231 1 108 319X Silver Ave 3 1 1 2     12 3x3   6003407.79227 2093529.1013 37.7286252931888 -122.430480251933 (37.7286252931888, -122.430480251933)
70864 43453 1 180 241 Oneida Ave 15 1 1 2 6 07/18/2000 12:00:00 AM 1   Permit Number 43162 5999638.45654 2091195.87208 37.7220045380552 -122.443343502225 (37.7220045380552, -122.443343502225)
71753 43458 1 180 241 Oneida Ave 9 1 1 2 6 07/18/2000 12:00:00 AM 5   Permit Number 43162 5999537.11613 2091248.65338 37.72214368387 -122.443697599487 (37.72214368387, -122.443697599487)
74074 43442 1 180 241 Oneida Ave 4 1 1 2 6 01/05/2016 12:00:00 AM 14   Permit Number 774294 5999458.08811 2091290.64416 37.72225447314511 -122.443973794765 (37.7222544731451, -122.443973794765)
75670 43444 1 180 241 Oneida Ave 6 1 1 2 6 07/18/2000 12:00:00 AM 2   Permit Number 43162 5999490.75065 2091271.846 37.722204720867204 -122.443859538611 (37.7222047208672, -122.443859538611)
82264 107888 1 44 941 Washington St 6 1 1 2 6 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
85417 98474 1 309 531X Franconia St 1 1 1 2     12 6x6   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
89282 91179 1 11 1 Polk St 6 1 1 2 3 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.41829917319299 (37.7785341058364, -122.418299173193)
92062 100665 1 17 63 Walter St 1 1 1 2 1 09/04/2012 12:00:00 AM   3x3 Permit Number 769258 6003201.8 2107946.7 37.768200969529204 -122.432221606092 (37.7682009695292, -122.432221606092)
93570 111448 1 180 241 Oneida Ave 38 1 1 2 6     6x7   5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
94572 98483 1 67 531X Franconia St 8 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
94673 85362 1 41 1250 Haight St 1 1 1 2   08/17/2007 12:00:00 AM     Permit Number 49639 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
95056 98485 1 67 531X Franconia St 10 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
96833 107891 1 17 941 Washington St 9 1 1 2 6         6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
96890 111446 1 180 241 Oneida Ave 36 1 1 2 6         5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
101787 107890 1 17 941 Washington St 8 1 1 2 6         6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
104700 98482 1 309 531X Franconia St 7 1 1 2     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
106253 85363 1 41 1250 Haight St 2 1 1 2   08/17/2007 12:00:00 AM     Permit Number 49639 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
107225 41576 1 5 200 Dolores St 4 1 1 2   07/22/2010 12:00:00 AM 6 3x3 Permit Number 53640 6004804.85382115 2107218.95663379 37.7662935218736 -122.426624972491 (37.7662935218736, -122.426624972491)
111981 43455 1 180 241 Oneida Ave 11 1 1 2 6 07/18/2000 12:00:00 AM     Permit Number 43162 5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
113461 111447 1 180 241 Oneida Ave 37 1 1 2 6         5999776.65760108 2091115.95638647 37.72179298789 -122.442860041334 (37.72179298789, -122.442860041334)
114568 91178 1 11 1 Polk St 5 1 1 2 3 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.41829917319299 (37.7785341058364, -122.418299173193)
117328 12801 1 160 2050 Lake St 1 1 1 2   05/22/2001 12:00:00 AM 3 4   5989040.29385 2114718.07128 37.7859801539539 -122.481700287531 (37.7859801539539, -122.481700287531)
119022 104960 1 54 2895 San Bruno Ave   1 1 2           6011715.1 2091289.8 37.7229437265236 -122.401603910944 (37.7229437265236, -122.401603910944)
119708 98480 1 309 531X Franconia St 5 1 1 2     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
Powered by Datasette · Query took 59.526ms · Data source: data.sfgov.org