sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
52542 131729 2 1 299 Cervantes Blvd 1 1 1 1     10 Width 4ft   6000632.65423 2121592.5821 37.8055230279355 -122.442087629562 (37.8055230279355, -122.442087629562)
25983 131696 2 1 3848 Scott St 6 1 1 1     11 Width 4ft   6000612.30159 2121584.19581 37.805498841559896 -122.44215746010799 (37.8054988415599, -122.442157460108)
154622 131730 2 1 299 Cervantes Blvd 2 1 1 1     13 Width 3ft   6000654.39491 2121581.01271 37.805492500428 -122.44201156220501 (37.805492500428, -122.442011562205)
136503 131697 2 1 3848 Scott St 5 1 1 1     9 Width 3ft   6000608.885530001 2121557.35058 37.8054249370849 -122.44216735356301 (37.8054249370849, -122.442167353563)
69617 131731 2 1 299 Cervantes Blvd 5 1 1 1     11 Width 3ft   6000725.63577 2121533.6715599997 37.8053665737798 -122.44176162442601 (37.8053665737798, -122.441761624426)
34530 131698 2 1 3848 Scott St 4 1 1 1     9 Width 3ft   6000612.76504 2121531.38925 37.805353875335896 -122.44215206329099 (37.8053538753359, -122.442152063291)
165490 131699 2 1 3848 Scott St 3 1 1 1     9 Width 3ft   6000615.89724 2121506.99628 37.8052870772908 -122.442139471852 (37.8052870772908, -122.442139471852)
77901 95656 1 1 499@Cervantes Marina Blvd 2 1 1 1     10 3x3   6000674.0 2121505.0 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064)
86113 95657 1 1 499@Cervantes Marina Blvd 5 1 1 1     10 3x3   6000674.0 2121505.0 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064)
87499 95651 1 1 499@Scott Marina Blvd 3 1 1 1     10 3x3   6000674.0 2121505.0 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064)
89855 95653 1 1 499@Scott Marina Blvd 5 1 1 1     10 3x3   6000674.0 2121505.0 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064)
91775 95650 1 1 499@Scott Marina Blvd 2 1 1 1     10 3x3   6000674.0 2121505.0 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064)
98265 95649 1 1 499@Scott Marina Blvd 1 1 1 1     10 3x3   6000674.0 2121505.0 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064)
120345 95655 1 1 499@Cervantes Marina Blvd 1 1 1 1     10 3x3   6000674.0 2121505.0 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064)
142677 95654 1 1 499@Scott Marina Blvd 6 1 1 1     10 3x3   6000674.0 2121505.0 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064)
144569 95652 1 1 499@Scott Marina Blvd 4 1 1 1     10 3x3   6000674.0 2121505.0 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064)
55011 131700 2 1 3848 Scott St 2 1 1 1     10 Width 3ft   6000620.58826 2121482.5709599997 37.805220279254705 -122.442121483639 (37.8052202792547, -122.442121483639)
30181 131701 2 1 3848 Scott St 1 1 1 1     19 Width 3ft   6000623.28685 2121462.32768 37.8051648504292 -122.44211069086201 (37.8051648504292, -122.442110690862)
94455 114582 2 1 1501 BEACH ST 4 1 1 1     16 3x3   6002979.0 2121285.0 37.8048119223389 -122.43394578498999 (37.8048119223389, -122.43394578499)
109110 114583 2 1 1501 BEACH ST 5 1 1 1     18 3x3   6002979.0 2121285.0 37.8048119223389 -122.43394578498999 (37.8048119223389, -122.43394578499)
117594 114580 2 1 1501 BEACH ST 3 1 1 1     12 3x3   6002979.0 2121285.0 37.8048119223389 -122.43394578498999 (37.8048119223389, -122.43394578499)
133821 131769 2 1 787 Francisco St 2 1 1 1     14 Width 2ft   6007533.34863 2120903.60484 37.804022109787 -122.418157889387 (37.804022109787, -122.418157889387)
89317 85483   1 2448 Hyde St 1 1 1 2     24 3x3   6007028.643792 2120821.987554 37.8037695888063 -122.419898663276 (37.8037695888063, -122.419898663276)
123690 85484   1 2448 Hyde St 2 1 1 2     24 3x3   6007028.643792 2120821.987554 37.8037695888063 -122.419898663276 (37.8037695888063, -122.419898663276)
52201 131767 2 1 2448 Hyde St 2 1 1 1     25 Width 3ft   6007044.7048 2120715.74188 37.8034787699919 -122.419835539578 (37.8034787699919, -122.419835539578)
59114 131766 2 1 2448 Hyde St 1 1 1 1     24 Width 3ft   6007046.8227699995 2120698.6660599997 37.803432003442396 -122.419826997845 (37.8034320034424, -122.419826997845)
58113 131703 2 1 15 Cervantes Blvd 1 1 1 1     13 Width 3ft   6002059.94104 2120580.8033 37.802826185928 -122.43707583099199 (37.802826185928, -122.437075830992)
40182 131702 2 1 15 Cervantes Blvd 2 1 1 1     15 Width 3ft   6002085.7752 2120558.53695 37.80276651681179 -122.436984836681 (37.8027665168118, -122.436984836681)
151251 58055 1 1 1951 Chestnut St 1 1 1 1   10/18/1977 12:00:00 AM 6   Permit Number 17024 6002508.23206 2119853.3281 37.8008542011299 -122.435472445005 (37.8008542011299, -122.435472445005)
58111 131732 2 1 1957 Chestnut St 2 1 1 1     5 Width 3ft   6002493.34846 2119850.49884 37.800845587415104 -122.435523745933 (37.8008455874151, -122.435523745933)
52722 58056 1 1 1957 Chestnut St 1 1 1 1   10/18/1977 12:00:00 AM 5   Permit Number 17025 6002479.0246 2119847.84274 37.8008374809215 -122.435573122311 (37.8008374809215, -122.435573122311)
129286 53959 1 1 1661 Greenwich St 1 1 1 1   03/29/1972 12:00:00 AM     Permit Number 9674 6004995.7689664 2119500.86037361 37.800027377944495 -122.42683940106701 (37.8000273779445, -122.426839401067)
25027 131695 2 1 1661 Greenwich St 2 1 1 1     11 Width 2ft   6004976.36068 2119500.2240400002 37.800024533360705 -122.42690651583901 (37.8000245333607, -122.426906515839)
148556 53965 1 1 753 Davis St 1 1 1 1 1 10/21/1995 12:00:00 AM 17   Permit Number 9680 6013049.6563099995 2119205.04164 37.799667209323 -122.39894891638001 (37.799667209323, -122.39894891638)
160901 76366 2 1 753 Davis St 2 1 1 1 1 10/21/1995 12:00:00 AM 7     6013050.90203 2119190.90632 37.7996284665342 -122.398943613057 (37.7996284665342, -122.398943613057)
74023 76347 2 1 753 Davis St 3 1 1 1 1 10/21/1995 12:00:00 AM 15     6013052.749419999 2119171.30409 37.7995747464454 -122.398935843819 (37.7995747464454, -122.398935843819)
27901 131768 2 1 940 Green St 2 9 1 1     4 Width 3ft   6008521.12765 2119017.9011 37.7988999869032 -122.41460607901699 (37.7988999869032, -122.414606079017)
163665 131694 2 1 1699 Union St 2 1 1 1     19 Width 4ft   6004942.7915199995 2118803.18958 37.798108757064796 -122.426973006318 (37.7981087570648, -122.426973006318)
176815 143359 2 1 1699 UNION ST 2 1 1 1     18 Width 0ft   6004931.6707 2118802.2471 37.7981055404278 -122.42701142046499 (37.7981055404278, -122.427011420465)
86623 107513 2 1 2760 GREENWICH ST   1 1 1           5999743.0 2118796.0 37.797793624169 -122.444965226189 (37.797793624169, -122.444965226189)
151711 143532 2 1 2001 UNION ST 2 1 1 1     19 Width 0ft   6003351.2703 2118581.8709 37.797410952833296 -122.43246431528401 (37.7974109528333, -122.432464315284)
58260 143531 2 1 2001 UNION ST 1 1 1 1     16 Width 0ft   6003323.1573 2118580.5634 37.7974057685705 -122.43256150006 (37.7974057685705, -122.43256150006)
188014 113280 1 1 2001 Union St 2 1 1 1     19     6003340.59835 2118579.59665 37.7974041031652 -122.432501080454 (37.7974041031652, -122.432501080454)
174982 52214 1 1 2001 Union St 1 1 1 1   11/14/2005 12:00:00 AM 17   Permit Number 48397 6003318.2213 2118578.20562 37.797399014802 -122.432578411388 (37.797399014802, -122.432578411388)
7131 116025 1 1 1425 Vallejo St 2 1 1 1   05/02/2016 12:00:00 AM 3 3x3   6006694.6941 2118351.37216 37.796967084814 -122.42087880533501 (37.796967084814, -122.420878805335)
89600 103266 2 1 2365 UNION ST 2 1 1 1       3x3   6001713.0 2118319.0 37.796596142729896 -122.43811430510799 (37.7965961427299, -122.438114305108)
129264 103265 2 1 2365 UNION ST   1 1 1       3x3   6001713.0 2118319.0 37.796596142729896 -122.43811430510799 (37.7965961427299, -122.438114305108)
76639 131727 2 1 2750 Lyon St 1 1 1 1     18 Width 4ft   5999177.276880001 2118259.18627 37.796287373624 -122.44688412951 (37.796287373624, -122.44688412951)
163025 105843 2 1 2740 Lyon St 1 1 1 1     19 6x9 Permit Number 772454 5999179.30231 2118231.5166 37.796211515799605 -122.446875129086 (37.7962115157996, -122.446875129086)
8062 110903 2 1 2300x Franklin St 4 1 1 1     15 3x3   6005480.89181 2117982.83198 37.7958866752705 -122.425052620105 (37.7958866752705, -122.425052620105)
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)
112978 111298 2 1 2300X FRANKLIN ST 1 1 1 1       3x3   6005562.0 2117912.0 37.795696769899294 -122.424766928636 (37.7956967698993, -122.424766928636)
159091 52591 1 1 1690 Broadway 1 1 1 1   01/27/2006 12:00:00 AM 24   Permit Number 48684 6005626.503190001 2117904.3459900003 37.7956793968408 -122.424543191035 (37.7956793968408, -122.424543191035)
5086 110900 2 1 2300x Franklin St 1 1 1 1     15 3x3   6005496.29651 2117906.44165 37.795677796936495 -122.42499387908998 (37.7956777969365, -122.42499387909)
41226 131752 2 1 1690 Broadway 3 1 1 1     8 Width 4ft   6005571.69035 2117900.5185 37.7956657919092 -122.424732581057 (37.7956657919092, -122.424732581057)
167556 131751 2 1 1690 Broadway 2 1 1 1     26 Width 4ft   6005602.995519999 2117899.87458 37.795665791896894 -122.424624213638 (37.7956657918969, -122.424624213638)
46979 131753 2 1 1690 Broadway 4 1 1 1     23 Width 4ft   6005546.70177 2117895.20308 37.795649785753604 -122.42481866775299 (37.7956497857536, -122.424818667753)
47040 131754 2 1 1690 Broadway 5 1 1 1     18 Width 4ft   6005523.755419999 2117889.5545099997 37.7956329801424 -122.424897664214 (37.7956329801424, -122.424897664214)
75161 41044 1 1 1444 Pacific Ave 1 1 1 1 1 01/29/2000 12:00:00 AM     Permit Number 41825 6007214.22869275 2117785.20726397 37.795441807697294 -122.41904090928001 (37.7954418076973, -122.41904090928)
151846 131750 2 1 1715 Broadway 1 1 1 1     21 Width 4ft   6005305.5059400005 2117794.9451099997 37.7953608767593 -122.425646109704 (37.7953608767593, -122.425646109704)
35388 53227 1 1 1419 Pacific Ave 1 1 1 1   07/18/1969 12:00:00 AM 13 3x3 Permit Number 6110 6007265.78904 2117749.89162 37.795347743065 -122.41885999550301 (37.795347743065, -122.418859995503)
8885 53229 1 1 1435 Pacific Ave 1 1 1 1   08/08/2016 12:00:00 AM 3 3x3 Permit Number 6112 6007249.74611 2117746.2070299997 37.795336722764795 -122.41891524533999 (37.7953367227648, -122.41891524534)
30452 131764 2 1 1492 Pacific Ave 1 10 1 1     13 Width 3ft   6007026.74159 2117749.85493 37.7953341794929 -122.419687137974 (37.7953341794929, -122.419687137974)
85073 105050 1 1 2835 Steiner St 2 1 1 1       3x3 Permit Number 771766 6002056.0 2117852.0 37.7953333833033 -122.436894002104 (37.7953333833033, -122.436894002104)
42437 131765 2 1 1492 Pacific Ave 2 10 1 1     13 Width 3ft   6007015.710940001 2117748.69184 37.7953303645668 -122.41972522333599 (37.7953303645668, -122.419725223336)
184821 131744 2 1 2760 Divisadero St 6 1 1 1     16 Width 5ft   6000643.38971 2117843.6395400004 37.7952300397944 -122.44178125031401 (37.7952300397944, -122.441781250314)
59211 131748 2 1 2621 Green St 5 1 1 1     7 Width 4ft   6000554.35554 2117844.3203 37.7952268355 -122.44208937065399 (37.7952268355, -122.442089370654)
168465 131747 2 1 2621 Green St 3 1 1 1     7 Width 4ft   6000509.412269999 2117838.25243 37.7952076133946 -122.442244445228 (37.7952076133946, -122.442244445228)
46518 131745 2 1 2761 Divisadero St 1 1 1 1     7 Width 4ft   6000588.687530001 2117833.1066900003 37.795198002331794 -122.44196977160802 (37.7951980023318, -122.441969771608)
150928 131746 2 1 2621 Green St 2 1 1 1     6 Width 4ft   6000485.91006 2117834.9484099997 37.7951972019456 -122.442325529026 (37.7951972019456, -122.442325529026)
76644 131743 2 1 2760 Divisadero St 5 1 1 1     15 Width 5ft   6000645.36321 2117825.80498 37.795181183232 -122.441773141117 (37.795181183232, -122.441773141117)
58000 131742 2 1 2760 Divisadero St 4 1 1 1     15 Width 5ft   6000648.257180001 2117809.9934900003 37.795137933933795 -122.44176199223499 (37.7951379339338, -122.441761992235)
182272 131763 2 1 1457 Jones St 1 10 1 1     16 Width 3ft   6008417.06699 2117517.79175 37.794775211263705 -122.414859937834 (37.7947752112637, -122.414859937834)
122187 99628 2 1 1856 Pacific Ave 1 1 1 1       3x3   6005263.1 2117519.3 37.7946016288287 -122.425773211932 (37.7946016288287, -122.425773211932)
23645 131755 2 1 1856 Pacific Ave 2 1 1 1     28 Width 4ft   6005252.93645 2117501.9314 37.7945533647075 -122.425807142281 (37.7945533647075, -122.425807142281)
130255 131760 2 1 1350 Jones St 2 1 1 1     20 Width 2ft   6008501.62739 2117179.1057599997 37.793850013919396 -122.414543368407 (37.7938500139194, -122.414543368407)
61230 131762 2 1 24 Priest St 18 9 1 1     11 Width 10ft   6008325.68222 2117173.18984 37.793823884108896 -122.41515173816799 (37.7938238841089, -122.415151738168)
134945 131759 2 1 1350 Jones St 1 1 1 1     18 Width 2ft   6008504.851969999 2117159.14189 37.7937953791974 -122.41453079766899 (37.7937953791974, -122.414530797669)
181863 131761 2 1 24 Priest St 16 9 1 1     6 Width 10ft   6008326.19973 2117161.77492 37.7937925706325 -122.415149139144 (37.7937925706325, -122.415149139144)
161849 131749 2 1 2424 Buchanan St 2 1 1 1     19 Width 4ft   6003697.91067 2116832.49049 37.7926272533989 -122.431139921469 (37.7926272533989, -122.431139921469)
163213 131758 2 1 1109 Jones St 4 1 1 1     12 Width 4ft   6008573.70037 2116368.91585 37.791629479864795 -122.414236639307 (37.7916294798648, -122.414236639307)
41556 131712 2 1 3250 Pacific Ave 2 9 1 1     10 Width 3ft   5998504.875 2116569.78161 37.7916102829449 -122.449089004562 (37.7916102829449, -122.449089004562)
179582 131713 2 1 3250 Pacific Ave 3 9 1 1     5 Width 3ft   5998501.34187 2116568.43338 37.791606378991 -122.449101131933 (37.791606378991, -122.449101131933)
184453 131714 2 1 3250 Pacific Ave 4 9 1 1     8 Width 3ft   5998496.90584 2116567.36238 37.791603184595104 -122.44911640329398 (37.7916031845951, -122.449116403294)
135456 131715 2 1 3250 Pacific Ave 5 9 1 1     4 Width 3ft   5998491.43186 2116566.313 37.791599990194705 -122.449135267491 (37.7915999901947, -122.449135267491)
70891 131716 2 1 3250 Pacific Ave 6 9 1 1     18 Width 3ft   5998485.19807 2116566.1841 37.7915992797271 -122.449156826952 (37.7915992797271, -122.449156826952)
8703 2829 3 1 1200 California St 1 1 1 2     80 3X3   6008547.0936900005 2116310.73962 37.7914682476113 -122.414324580422 (37.7914682476113, -122.414324580422)
3267 2831 3 1 1200 California St 3 1 1 2     75 3X3   6008484.02773 2116302.9533599997 37.791443325609606 -122.414542237062 (37.7914433256096, -122.414542237062)
6574 2832 3 1 1200 California St 4 1 1 2     45 3X3   6008465.75544 2116301.4842 37.7914382651038 -122.414605355047 (37.7914382651038, -122.414605355047)
66867 131741 2 1 2901 Jackson St 2 1 1 1     17 Width 3ft   6000273.04756 2116436.32711 37.7913448210684 -122.44296157632 (37.7913448210684, -122.44296157632)
22903 131740 2 1 2901 Jackson St 1 1 1 1     18 Width 3ft   6000252.76516 2116432.30199 37.7913326127476 -122.443031463558 (37.7913326127476, -122.443031463558)
64283 131739 2 1 2911 Jackson St 2 1 1 1     22 Width 3ft   6000239.33655 2116430.67525 37.7913273804943 -122.443077809215 (37.7913273804943, -122.443077809215)
165758 131738 2 1 2911 Jackson St 1 1 1 1     14 Width 3ft   6000212.4749300005 2116427.2103 37.7913163350409 -122.443170500539 (37.7913163350409, -122.443170500539)
133273 53674 1 1 2324 Divisadero St 1 1 1 1   02/02/1970 12:00:00 AM 27 3x3 Permit Number 6615 6000847.30796 2116375.23213 37.7912097941415 -122.44097026868401 (37.7912097941415, -122.440970268684)
97056 89006 1 1 2200 Webster St 1 1 1 1       3x3 Permit Number 51758 6003287.9 2116231.2 37.7909530209385 -122.432515604779 (37.7909530209385, -122.432515604779)
73443 131737 2 1 2901 Washington St 4 1 1 1     22 Width 4ft   6000792.75525 2116183.5365400002 37.7906803407803 -122.441145259657 (37.7906803407803, -122.441145259657)
157009 131736 2 1 2901 Washington St 3 1 1 1     16 Width 4ft   6000776.55932 2116181.75535 37.7906745275563 -122.44120116870701 (37.7906745275563, -122.441201168707)
26327 131735 2 1 2901 Washington St 2 1 1 1     17 Width 4ft   6000766.13673 2116181.54807 37.7906733647218 -122.441237215332 (37.7906733647218, -122.441237215332)
59506 131734 2 1 2901 Washington St 1 1 1 1     17 Width 4ft   6000749.28539 2116178.9335 37.7906652258746 -122.441295332225 (37.7906652258746, -122.441295332225)
189120 98169 1 1 2941 Washington St 1 1 1 1   11/30/2015 12:00:00 AM 19 3x3 Permit Number 775039 6000613.54695 2116154.22533 37.7905896504327 -122.44176320452299 (37.7905896504327, -122.441763204523)
87239 31218 1 1 2302 Steiner St 6 1 1 1         Permit Number 34907 6002345.06195587 2116106.2366551002 37.79055639288929 -122.43576883650199 (37.7905563928893, -122.435768836502)
Powered by Datasette · Query took 19.288ms · Data source: data.sfgov.org