sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
7029 13296 1 76 2770 Lombard St 1 1 1 1   01/08/2016 12:00:00 AM 2 3X3 Permit Number 770074 5999335.521430001 2119120.5005900003 37.79866135180829 -122.446398566642 (37.7986613518083, -122.446398566642)
13872 15042 1 76 1024 Mendell St 1 1 1 1   02/28/2008 12:00:00 AM 3 3X3   6015618.91517 2096257.6222 37.7368014371311 -122.388455686999 (37.7368014371311, -122.388455686999)
14802 24222 8 76 54 Whitney Young Cir 1 1 1 1   05/07/2010 12:00:00 AM 3 4x4 this is original dpw basin record. 6017205.2608 2094992.48681 37.7334154068844 -122.38288292190398 (37.7334154068844, -122.382882921904)
14805 15047 1 76 1115 Mendell St 1 1 1 1   02/12/2008 12:00:00 AM 3 3x3   6015512.6554 2096045.3172 37.7362126017611 -122.388808259867 (37.7362126017611, -122.388808259867)
14916 15036 1 76 1011 Mendell St 1 1 1 1     3 3X3   6015667.53207 2096259.4401099999 37.7368091227302 -122.38828772241501 (37.7368091227302, -122.388287722415)
16393 14881 1 76 50 Mendell St 7 1 1 1   02/21/2008 12:00:00 AM 3 3x3   6017041.97386 2098599.86831 37.743311528701504 -122.383698526073 (37.7433115287015, -122.383698526073)
16610 14901 1 76 175 Mendell St 1 1 1 1   02/25/2008 12:00:00 AM 12 3x3   6017044.13522 2098333.33165 37.7425797926155 -122.383672499702 (37.7425797926155, -122.383672499702)
19657 111332 2 76 698x ILLINOIS ST 8 1 1 1       3x3   6015875.0 2105932.0 37.7633794456224 -122.38824526349899 (37.7633794456224, -122.388245263499)
25666 179365 2 76 2300 San Bruno Ave 4 1 1 1     8 Width 3ft   6010237.42069 2095603.4903799999 37.7347056462347 -122.407015869312 (37.7347056462347, -122.407015869312)
25723 104601 1 76 1945 Hyde St 2 1 1 1   10/21/2013 12:00:00 AM 3 3x3 Permit Number 770083 6007231.00881 2119029.9690799997 37.7988605570185 -122.419071181514 (37.7988605570185, -122.419071181514)
27153 197239 2 76 830 Rhode Island St 1 4 1 1     1 Width 6ft   6011827.26305 2104492.53285 37.7592018783746 -122.40214394588999 (37.7592018783746, -122.40214394589)
28170 197234 2 76 1201 Illinois St 9 1 1 1     10 Width 3ft   6016171.82655 2103275.3753400003 37.756101362207296 -122.387033327344 (37.7561013622073, -122.387033327344)
30199 197244 2 76 401 Mendell St 3 4 1 1     3 Width 3ft   6016639.49339 2097549.35813 37.7404047858594 -122.38501703741699 (37.7404047858594, -122.385017037417)
34089 240352 2 76 671 Church St 9 7 1 1     18 Width 3ft   6004316.09652 2104917.27177 37.759946001726604 -122.428151444657 (37.7599460017266, -122.428151444657)
36467 197263 2 76 1322 Hudson Ave 54 1 1 1     5 Width 3ft   6017252.47245 2095336.30143 37.7343620620475 -122.382743613324 (37.7343620620475, -122.382743613324)
37860 201665 2 76 401 08th St 1 7 1 1     4     6010317.6274 2109676.05195 37.7733502610444 -122.407730511973 (37.7733502610444, -122.407730511973)
39134 197231 2 76 670 Illinois St 7 1 1 1     4 Width 3ft   6015968.40199 2105908.71514 37.7633206852369 -122.38792058857901 (37.7633206852369, -122.387920588579)
41463 179363 2 76 2300 San Bruno Ave 2 1 1 1     10 Width 3ft   6010218.26631 2095644.80145 37.734818005735605 -122.407085003796 (37.7348180057356, -122.407085003796)
41507 240358 2 76 671 Church St 23 7 1 1     8 Width 3ft   6004302.67089 2105008.5073599997 37.760195753352 -122.428204379638 (37.760195753352, -122.428204379638)
41673 214008 2 76 222 Sadowa St 1 2 1 1     7 Width 3ft   5994773.560409999 2087779.1496 37.7123444055547 -122.459912734779 (37.7123444055547, -122.459912734779)
42259 197246 2 76 1339 Hudson Ave 1 1 1 1     2 Width 3ft   6017203.85974 2095339.7013299998 37.7343687116489 -122.382911921471 (37.7343687116489, -122.382911921471)
45949 197235 2 76 1101 Illinois St 4 1 1 1     7 Width 3ft   6016151.23089 2103629.8826099997 37.75707362375729 -122.387129280509 (37.7570736237573, -122.387129280509)
46248 197252 2 76 1333 Hudson Ave 5 1 1 1     2 Width 3ft   6017782.90663 2094656.28102 37.7325241508658 -122.38086245283999 (37.7325241508658, -122.38086245284)
46894 197228 2 76 670 Illinois St 4 1 1 1     5 Width 3ft   6015966.4036 2105950.82285 37.7634361932415 -122.38793043883301 (37.7634361932415, -122.387930438833)
48528 240361 2 76 138 Laidley St 2 1 1 1     13 Width 3ft   6003708.025169999 2097591.62928 37.7397970779748 -122.429731967151 (37.7397970779748, -122.429731967151)
48790 136292 2 76 401 Van Ness Ave 6 1 1 1     8 Width 4ft   6006812.66695 2111768.16026 37.7788978558793 -122.420003176823 (37.7788978558793, -122.420003176823)
51251 136291 2 76 401 Van Ness Ave 3 1 1 1     10 Width 4ft   6006783.12153 2111963.42533 37.779432341874 -122.420119247825 (37.779432341874, -122.420119247825)
52745 197242 2 76 151 Mendell St 3 4 1 1     7 Width 3ft   6017080.03361 2098493.68243 37.7430220675307 -122.383559533147 (37.7430220675307, -122.383559533147)
53146 240348 2 76 1201 San Jose Ave 26 7 1 1     1     6004340.86769 2095971.0086599998 37.7353830362869 -122.42742844278798 (37.7353830362869, -122.427428442788)
53585 197269 2 76 623 Mendell St 10 1 1 1     3 Width 3ft   6016467.035209999 2097318.03546 37.7397600798502 -122.385597217932 (37.7397600798502, -122.385597217932)
57512 197265 2 76 1328 Hudson Ave 1 1 1 1     3 Width 3ft   6017187.84442 2095472.38417 37.734732147456604 -122.382976523354 (37.7347321474566, -122.382976523354)
58897 201668 2 76 401 08th St 4 7 1 1     11     6010243.64351 2109736.80769 37.7735129403066 -122.407990719097 (37.7735129403066, -122.407990719097)
59395 104602 1 76 1945 Hyde St 3 1 1 1   10/21/2013 12:00:00 AM 4 3x3 Permit Number 770083 6007233.0949099995 2119016.60883 37.7988239906011 -122.41906301476001 (37.7988239906011, -122.41906301476)
59607 197261 2 76 1322 Hudson Ave 41 1 1 1     1 Width 3ft   6017380.571719999 2095099.80246 37.7337197590624 -122.38228428011499 (37.7337197590624, -122.382284280115)
60058 179364 2 76 2300 San Bruno Ave 3 1 1 1     14 Width 3ft   6010224.85869 2095626.2161299998 37.7347673433273 -122.40706090196501 (37.7347673433273, -122.407060901965)
60807 197262 2 76 1322 Hudson Ave 46 1 1 1     2 Width 3ft   6017335.88738 2095181.6845 37.733942122725395 -122.38244446375201 (37.7339421227254, -122.382444463752)
65823 197268 2 76 623 Mendell St 9 1 1 1     4 Width 3ft   6016457.45945 2097300.20103 37.7397105802781 -122.385629084527 (37.7397105802781, -122.385629084527)
67130 197238 2 76 1101 Illinois St 8 1 1 1     6 Width 3ft   6016145.70434 2103719.54836 37.757319520883705 -122.38715464767901 (37.7573195208837, -122.387154647679)
67475 197240 2 76 301 Mendell St 8 4 1 1     3 Width 3ft   6016921.73157 2097930.91265 37.7414680650873 -122.384067722948 (37.7414680650873, -122.384067722948)
70243 197256 2 76 1320 Hudson Ave 6 1 1 1     2 Width 3ft   6018044.32152 2094632.22344 37.732472518087 -122.37995699832899 (37.732472518087, -122.379956998329)
71356 179370 2 76 2302 San Bruno Ave 4 1 1 1     4 Width 3ft   6010321.94566 2095411.6162900003 37.734183530441705 -122.406710118682 (37.7341835304417, -122.406710118682)
71369 197232 2 76 670 Illinois St 8 1 1 1     4 Width 3ft   6015969.52981 2105893.92675 37.763280141978605 -122.38791565581002 (37.7632801419786, -122.38791565581)
72615 197255 2 76 1320 Hudson Ave 3 1 1 1     1 Width 3ft   6018070.99696 2094637.60558 37.7324887679223 -122.379865147852 (37.7324887679223, -122.379865147852)
74575 240354 2 76 671 Church St 17 7 1 1     13 Width 3ft   6004324.4915 2104963.9062200002 37.7600745238281 -122.428125733918 (37.7600745238281, -122.428125733918)
74976 197271 2 76 621 Mendell St 2 1 1 1     3 Width 3ft   6016522.123869999 2097389.36221 37.739958976617295 -122.385411712102 (37.7399589766173, -122.385411712102)
75378 197257 2 76 1322 Hudson Ave 26 1 1 1     2 Width 3ft   6017533.22144 2094905.154 37.733193723116 -122.38174298627199 (37.733193723116, -122.381742986272)
75680 197250 2 76 1337 Hudson Ave 1 1 1 1     5 Width 3ft   6017426.32364 2094968.1062 37.733360674138105 -122.382116942362 (37.7333606741381, -122.382116942362)
75733 179362 2 76 2300 San Bruno Ave 1 1 1 1     14 Width 3ft   6010207.20881 2095669.3235 37.7348847192535 -122.407124961546 (37.7348847192535, -122.407124961546)
79966 111329 2 76 698x ILLINOIS ST 5 1 1 1       3x3   6015875.0 2105932.0 37.7633794456224 -122.38824526349899 (37.7633794456224, -122.388245263499)
84773 15001 1 76 501 Mendell St 2 1 1 1   02/22/2008 12:00:00 AM 3 3X3   6016547.419430001 2097394.04536 37.739973235060205 -122.38532457596901 (37.7399732350602, -122.385324575969)
86333 111325 2 76 698x ILLINOIS ST 1 1 1 1       3x3   6015875.0 2105932.0 37.7633794456224 -122.38824526349899 (37.7633794456224, -122.388245263499)
87939 111326 2 76 698x ILLINOIS ST 2 1 1 1       3x3   6015875.0 2105932.0 37.7633794456224 -122.38824526349899 (37.7633794456224, -122.388245263499)
89270 10851 1 76 1220X Hudson Ave 3 1 1 1   12/27/2007 12:00:00 AM 3 3X4   6017356.4574634 2095156.0177673001 37.7338727832056 -122.382371560842 (37.7338727832056, -122.382371560842)
96043 49974 1 76 138 Laidley St 1 1 1 1 1 07/18/2003 12:00:00 AM 10 3x6 Permit Number 46725 6003736.17026094 2097556.1914573 37.739701367535 -122.42963212654199 (37.739701367535, -122.429632126542)
96081 111327 2 76 698x ILLINOIS ST 3 1 1 1       3x3   6015875.0 2105932.0 37.7633794456224 -122.38824526349899 (37.7633794456224, -122.388245263499)
99321 111328 2 76 698x ILLINOIS ST 4 1 1 1       3x3   6015875.0 2105932.0 37.7633794456224 -122.38824526349899 (37.7633794456224, -122.388245263499)
104312 15003 1 76 501 Mendell St 4 1 1 1   02/21/2008 12:00:00 AM 3 3X3   6016547.419430001 2097394.04536 37.739973235060205 -122.38532457596901 (37.7399732350602, -122.385324575969)
105309 14878 1 76 50 Mendell St 4 1 1 1   02/10/2012 12:00:00 AM 3 3x3   6017061.80062 2098665.73573 37.74349348316439 -122.383634554347 (37.7434934831644, -122.383634554347)
105453 197270 2 76 621 Mendell St 1 1 1 1     5 Width 3ft   6016507.88272 2097368.67206 37.739901377747294 -122.385459511073 (37.7399013777473, -122.385459511073)
110792 100171 6 76 109 Edgewood Ave 1 7 1 1           5996563.8 2106359.1 37.763463224843996 -122.455066914463 (37.763463224844, -122.455066914463)
118605 111330 2 76 698x ILLINOIS ST 6 1 1 1       3x3   6015875.0 2105932.0 37.7633794456224 -122.38824526349899 (37.7633794456224, -122.388245263499)
119871 15016 1 76 670 Mendell St 2 1 1 1   02/25/2008 12:00:00 AM 5 3x3   6016248.60441 2097127.21289 37.739224031366795 -122.386339165233 (37.7392240313668, -122.386339165233)
123526 111333 2 76 698x ILLINOIS ST 9 1 1 1       3x3   6015875.0 2105932.0 37.7633794456224 -122.38824526349899 (37.7633794456224, -122.388245263499)
124664 15000 1 76 501 Mendell St 1 1 1 1     3 3X3   6016547.419430001 2097394.04536 37.739973235060205 -122.38532457596901 (37.7399732350602, -122.385324575969)
124838 111331 2 76 698x ILLINOIS ST 7 1 1 1       3x3   6015875.0 2105932.0 37.7633794456224 -122.38824526349899 (37.7633794456224, -122.388245263499)
125239 93191 2 76 220 Sadowa St 1 1 1 1     7 3x10   5994811.8 2087851.3 37.712544712734896 -122.459785791066 (37.7125447127349, -122.459785791066)
126922 15008 1 76 600X Mendell St 5 1 1 1   02/25/2008 12:00:00 AM 12 3x3   6016372.25512 2097272.64218 37.7396301943656 -122.385921767044 (37.7396301943656, -122.385921767044)
132253 197245 2 76 401 Mendell St 5 4 1 1     6 Width 3ft   6016656.39457 2097572.2278400003 37.7404685163083 -122.38496019216001 (37.7404685163083, -122.38496019216)
134620 179366 2 76 2300 San Bruno Ave 5 1 1 1     9 Width 3ft   6010245.15068 2095586.7088400002 37.7346600002662 -122.406987961537 (37.7346600002662, -122.406987961537)
134739 197273 2 76 618 Mendell St 5 1 1 1     2 Width 3ft   6016318.01168 2097190.59348 37.7394019032644 -122.38610360101299 (37.7394019032644, -122.386103601013)
135294 197266 2 76 818 Mendell St 3 1 1 1     3 Width 3ft   6015992.3153099995 2096760.75352 37.738203618709 -122.38719975136699 (37.738203618709, -122.387199751367)
137388 197267 2 76 822 Mendell St 1 1 1 1     2 Width 4ft   6015954.57272 2096709.3738 37.738060450238706 -122.387326664599 (37.7380604502387, -122.387326664599)
137449 197230 2 76 670 Illinois St 6 1 1 1     5 Width 3ft   6015968.5174 2105926.2015 37.763368705413896 -122.387921409661 (37.7633687054139, -122.387921409661)
138859 93980 1 76 54 Whitney Young Cir 1 1 1 1   05/07/2010 12:00:00 AM 3 3x3 Permit Number 53404 6016373.3 2096115.1 37.7364518752706 -122.385837492382 (37.7364518752706, -122.385837492382)
143664 179368 2 76 2302 San Bruno Ave 2 1 1 1     12 Width 3ft   6010304.52848 2095452.39798 37.7342945337677 -122.406773208834 (37.7342945337677, -122.406773208834)
145391 98540 2 76 4736 17th St 1 1 1 1     40     5998512.0 2105692.0 37.7617431097225 -122.448280704282 (37.7617431097225, -122.448280704282)
146754 240351 2 76 4090 20th St 1 23 1 1     22 Width 3ft   6003153.88022 2104182.56452 37.7578628454134 -122.432118516979 (37.7578628454134, -122.432118516979)
147369 197233 2 76 1201 Illinois St 1 1 1 1     8 Width 3ft   6016183.784440001 2103092.78575 37.7556006718551 -122.38697923850799 (37.7556006718551, -122.386979238508)
150321 201670 2 76 401 08th St 6 7 1 1     10     6010207.48998 2109776.17317 37.773619004556295 -122.408118556848 (37.7736190045563, -122.408118556848)
150540 197236 2 76 1101 Illinois St 5 1 1 1     7 Width 3ft   6016150.0851300005 2103652.1356900004 37.7571346625573 -122.38713479513001 (37.7571346625573, -122.38713479513)
150816 240350 2 76 4746 17th St 1 1 1 1     6 Width 4ft   5998436.06596 2105691.7221 37.761738005233205 -122.44854330852199 (37.7617380052332, -122.448543308522)
151575 240356 2 76 671 Church St 19 7 1 1     18 Width 3ft   6004321.88535 2104984.17972 37.760130042589005 -122.428136192158 (37.760130042589, -122.428136192158)
152190 240360 2 76 138 Laidley St 1 1 1 1     14 Width 3ft   6003696.80727 2097599.2611700003 37.7398173981643 -122.429771298113 (37.7398173981643, -122.429771298113)
152349 197264 2 76 1322 Hudson Ave 55 1 1 1     2 Width 3ft   6017243.9601 2095358.62855 37.734422897596005 -122.382774596779 (37.734422897596, -122.382774596779)
153574 197226 2 76 670 Illinois St 2 1 1 1     4 Width 3ft   6015965.03581 2105988.90006 37.7635406692923 -122.387937826789 (37.7635406692923, -122.387937826789)
158778 240357 2 76 671 Church St 20 7 1 1     12 Width 3ft   6004316.61445 2104979.98621 37.7601182299832 -122.42815412283701 (37.7601182299832, -122.428154122837)
158951 197237 2 76 1101 Illinois St 6 1 1 1     7 Width 3ft   6016149.20682 2103671.84274 37.757188725307294 -122.38713920722401 (37.7571887253073, -122.387139207224)
159509 136290 2 76 401 Van Ness Ave 1 1 1 1     11 Width 4ft   6006768.37866 2112062.5093799997 37.7797035719992 -122.42017728376601 (37.7797035719992, -122.420177283766)
159917 197258 2 76 1322 Hudson Ave 27 1 1 1     1 Width 3ft   6017525.05376 2094913.62104 37.7332165209287 -122.38177181313299 (37.7332165209287, -122.381771813133)
160148 179369 2 76 2302 San Bruno Ave 3 1 1 1     9 Width 3ft   6010313.94209 2095431.3802900002 37.7342373503731 -122.406739182082 (37.7342373503731, -122.406739182082)
161783 197260 2 76 1322 Hudson Ave 40 1 1 1     23 Width 3ft   6017393.357030001 2095090.62772 37.7336952732179 -122.38223943901698 (37.7336952732179, -122.382239439017)
161864 197227 2 76 670 Illinois St 3 1 1 1     5 Width 3ft   6015965.05283 2105966.21151 37.7634783723591 -122.38793618463001 (37.7634783723591, -122.38793618463)
162859 240362 2 76 138 Laidley St 3 1 1 1     11 Width 3ft   6003721.38231 2097581.21775 37.7397692466514 -122.429685041427 (37.7397692466514, -122.429685041427)
167594 104600 1 76 1945 Hyde St 1 1 1 1   10/21/2013 12:00:00 AM 4 3x3 Permit Number 770083 6007230.70015 2119043.68461 37.798898199037396 -122.419073222948 (37.7988981990374, -122.419073222948)
169362 240349 2 76 4736 17th St 1 1 1 1     27 Width 4ft   5998465.34509 2105692.76775 37.76174255039739 -122.44844211950199 (37.7617425503974, -122.448442119502)
170255 65579 1 76 670 Mendell St 1 1 1 1   01/23/1990 12:00:00 AM 4   Permit Number 28479 6016251.26211 2097105.4929099998 37.739164539819 -122.386328462099 (37.739164539819, -122.386328462099)
170688 197259 2 76 1322 Hudson Ave 31 1 1 1     4 Width 3ft   6017468.44354 2094985.48685 37.73341072412121 -122.381972529223 (37.7334107241212, -122.381972529223)
170701 201667 2 76 401 08th St 3 7 1 1     5     6010257.0488 2109725.83328 37.7734835576458 -122.40794357396099 (37.7734835576458, -122.407943573961)
173028 197225 2 76 670 Illinois St 1 1 1 1     6 Width 3ft   6015963.59101 2106011.38061 37.7636023160031 -122.38794439272199 (37.7636023160031, -122.387944392722)
173614 240353 2 76 671 Church St 10 7 1 1     29 Width 3ft   6004318.107530001 2104946.3678099997 37.7600260063222 -122.42814656311701 (37.7600260063222, -122.428146563117)
174587 240355 2 76 671 Church St 18 7 1 1     19 Width 3ft   6004321.65497 2104972.99929 37.7600993307501 -122.42813619214701 (37.7600993307501, -122.428136192147)
Powered by Datasette · Query took 4.188ms · Data source: data.sfgov.org