sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
94793 106979 3 506 801X Clipper St 1 14 1 2     24     5999765.50041 2100345.59515 37.7471347718267 -122.443561289165 (37.7471347718267, -122.443561289165)
92918 110864 2 504 1798x 22ND ST 1 14 1 1           6012787.0 2103832.0 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858)
82737 106281 2 474 399X Elliot St 2 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
95834 106280 2 474 399X Elliot St 1 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
119057 106282 2 474 399X Elliot St 3 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
122293 117624 2 435 890x VERMONT ST 2 14 1 1           6011292.0 2104239.0 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201)
98413 107527 2 408 2540x LYON ST 1 14 1 1     30   Permit Number 774117 5999227.0 2117510.0 37.7942331479636 -122.44665814715599 (37.7942331479636, -122.446658147156)
143384 116676 3 338 100 Esmeralda Ave 15 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
142115 121724 2 330 439X ARLINGTON ST 2 14 1 1           6003949.9 2096014.9 37.7354814316621 -122.42878329168998 (37.7354814316621, -122.42878329169)
120315 115525 2 318 25 FRANCONIA ST 2 14 1 1       3x3   6010006.0 2099954.0 37.746638251201404 -122.408122694659 (37.7466382512014, -122.408122694659)
62864 108717 2 304 1141 Chestnut St 3 14 1 1     7 3x3   6006358.32966 2120394.6178099997 37.802558354332795 -122.422187945742 (37.8025583543328, -122.422187945742)
4716 253674 3 225 600 x Sanchez St 2 14 1 2       3x3   6003598.0 2104743.0 37.75942683738779 -122.43062255590701 (37.7594268373878, -122.430622555907)
92622 116679 3 211 100 Esmeralda Ave 18 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
105116 105651 2 211 150 BRONTE ST 2 14 1 1     20     6009287.5 2096640.3 37.737499298818996 -122.410373266073 (37.737499298819, -122.410373266073)
115115 105652 2 211 150 BRONTE ST 4 14 1 1     25     6009287.5 2096640.3 37.737499298818996 -122.410373266073 (37.737499298819, -122.410373266073)
144060 33896 1 211 150 Bronte St 1 14 1 1   03/03/1997 12:00:00 AM 25   Permit Number 37869 6009276.59000035 2096641.35700735 37.737501589532705 -122.410411061845 (37.7375015895327, -122.410411061845)
69268 116648 3 193 199x Esmeralda Ave 3 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
79334 116646 3 193 199x Esmeralda Ave 1 14 1 2     2     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
82496 116652 3 193 199x Esmeralda Ave 7 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
112164 116647 3 193 199x Esmeralda Ave 2 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
118788 116651 3 193 199x Esmeralda Ave 6 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
129308 116650 3 193 199x Esmeralda Ave 5 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
145521 116649 3 193 199x Esmeralda Ave 4 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
3506 247939 4 180 29 Joy St 2 14 1 2     12   Permit Number 775404 6010258.299769999 2098917.5156900003 37.7438064148349 -122.40717721395 (37.7438064148349, -122.40717721395)
86166 116675 3 180 100 Esmeralda Ave 14 14 1 2     14     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
94710 101366 2 180 1348 Noe St   14 1 1     24   Owner: Brent Sommer 519-1119 nocmout@gmail.com 6003163.2 2100416.0 37.7475212781449 -122.43181735246 (37.7475212781449, -122.43181735246)
99201 113439 2 180 401x POWHATTAN AVE 1 14 1 1     20 3x3   6008174.0 2098184.0 37.7416754763214 -122.41433236498301 (37.7416754763214, -122.414332364983)
126736 116670 3 180 100 Esmeralda Ave 8 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
87421 111309 2 176 100x GILROY ST 1 14 1 1       30x30   6015178.0 2088529.0 37.7155557353625 -122.38944056945101 (37.7155557353625, -122.389440569451)
91188 111312 2 176 99x GILROY ST 3 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
96975 111311 2 176 99x GILROY ST 2 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
123880 111310 2 176 99x GILROY ST 1 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
84377 107372 2 175 305x GREENWICH ST 1 14 1 1     20     6011370.0 2120243.0 37.8024234525216 -122.40483428789801 (37.8024234525216, -122.404834287898)
116190 117545 2 164 3340x HARRISON ST 1 14 1 1     20 3x3   6008964.0 2099209.0 37.7445342470575 -122.411673205451 (37.7445342470575, -122.411673205451)
42966 112248 3 158 1799X TAYLOR ST 1 14 1 2     15     6008739.0 2118839.0 37.79842100686071 -122.413839504702 (37.7984210068607, -122.413839504702)
123372 116663 3 154 199x Esmeralda Ave 16 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
7555 107448 2 143 1111x Chestnut St 1 14 1 1     50     6006408.68895 2120404.8626200003 37.80258932431129 -122.42201440535801 (37.8025893243113, -122.422014405358)
8668 107450 2 143 1140x Chestnut St 1 14 1 1     60     6006380.05181 2120425.48408 37.802644330436394 -122.42211497023399 (37.8026443304364, -122.422114970234)
26646 107449 2 143 1130x CHESTNUT ST 1 14 1 1     60     6006351.9 2120450.9 37.802712528214705 -122.42221419659701 (37.8027125282147, -122.422214196597)
81729 109625 2 143 312x FILBERT ST 1 14 1 1     14     6011362.9 2120079.8 37.801974948341 -122.40484736081001 (37.801974948341, -122.40484736081)
102335 108605 2 143 1140x CHESTNUT ST 2 14 1 1           6006369.1 2120452.7 37.802718440704204 -122.42215480373899 (37.8027184407042, -122.422154803739)
123800 116680 3 132 100 Esmeralda Ave 19 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
82723 102522 2 129 1X 31st St 2 14 1 1           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233)
95360 116668 3 129 100x Esmeralda Ave 4 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
144190 116667 3 129 100x Esmeralda Ave 3 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
4222 253622 2 128 300x Naglee Ave   14 1 1                    
114717 99960 2 119 279 Filbert St 1 14 1 1         shared responsibility with 1400 Montgomery 6011546.2 2120046.5 37.80189375856779 -122.40421070766001 (37.8018937585678, -122.40421070766)
127330 109501 5 119 1400X on Filbert Montgomery St 1 14 1 1         see 279 Filbert St. Same tree; shared responsibility 6011485.9 2120124.8 37.802105381717894 -122.404424889694 (37.8021053817179, -122.404424889694)
3355 253433 2 116 3 Vulcan Stwy 1 14 1 1       3x3   6000640.0 2106231.0 37.7633444989385 -122.440959493883 (37.7633444989385, -122.440959493883)
93306 116660 3 116 199x Esmeralda Ave 13 14 1 2     8     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
114267 95432 2 116 2675 25th Ave 1 14 1 1     12     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
115606 95435 2 116 2675 25th Ave 2 14 1 1     12     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
82247 116682 3 108 100 Esmeralda Ave 21 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
138825 116683 3 108 100 Esmeralda Ave 22 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
697 251362 2 105 1300X Stanyan St 1 14 1 1       3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
94946 95436 2 103 2675 25th Ave 3 14 1 1     16     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
112606 105901 3 103 11X ELLIOT ST 2 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
114729 96803 2 103 300X Melrose Ave 1 14 1 1     48     5998134.5 2095546.7 37.733865009274204 -122.448855518806 (37.7338650092742, -122.448855518806)
122561 105900 3 103 11X ELLIOT ST 1 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
138343 105902 3 103 11X ELLIOT ST 3 14 1 2     40     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
94709 117610 2 98 391 NEVADA ST 1 14 2 1       3x3   6008958.0 2096497.0 37.737087351465796 -122.41150238578501 (37.7370873514658, -122.411502385785)
85877 103517 1 84 55X MacOndray Ln 1 14 1 1         Permit Number 770452 6008432.0 2119159.0 37.7992824016355 -122.41492448290899 (37.7992824016355, -122.414924482909)
123850 107158 2 71 101x Elsie St 1 14 1 1     20     6007300.0 2098759.0 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614)
3497 247942 4 58 29 Joy St 5 14 1 2     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.40705728398399 (37.7437730949632, -122.407057283984)
3510 247941 4 58 29 Joy St 4 14 1 2     5   Permit Number 775404 6010287.82636 2098909.7574 37.743786764646 -122.40707457072901 (37.743786764646, -122.407074570729)
3511 247940 4 58 29 Joy St 3 14 1 2     5   Permit Number 775404 6010280.31746 2098909.2881400003 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782)
19241 116677 3 58 100 Esmeralda Ave 16 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
127057 116678 3 58 100 Esmeralda Ave 17 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
549 251321 2 47 100X Monument Way 1 14 1 1                    
3496 253449 2 47 330 Twin Peaks Blvd 1 14 1 1       10x10   5998688.0 2103995.0 37.7570936308358 -122.44754983450599 (37.7570936308358, -122.447549834506)
4884 253710 2 47 1 Monument Way 4 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4891 253709 2 47 1 Monument Way 3 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4893 253707 2 47 1 Monument Way 1 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4898 253711 2 47 1 Monument Way 5 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4906 253708 2 47 1 Monument Way 2 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
72511 98376 2 47 199X Cragmont Ave 1 14 1 1           5992899.0 2101153.0 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244)
111080 98377 2 47 199X Cragmont Ave 2 14 1 1           5992899.0 2101153.0 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244)
111257 98379 2 47 199X Cragmont Ave 4 14 1 1           5992899.0 2101153.0 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244)
113837 116669 3 47 100 Esmeralda Ave 6 14 1 2     20     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
121692 98378 1 47 199X Cragmont Ave 3 14 1 1         Permit Number 768647 5992899.0 2101153.0 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244)
127372 112739 2 47 444 Franconia St 3 14 1 1     30     6009949.70212209 2098546.33795552 37.7427699663381 -122.40821810325701 (37.7427699663381, -122.408218103257)
143207 98706 2 47 353 UPPER TER   14 1 1           5999086.1 2105914.9 37.7623879420949 -122.446311165521 (37.7623879420949, -122.446311165521)
160398 121610 2 46 1700 22nd St 1 14 1 1     11     6012951.69217 2103797.77434 37.7573569210097 -122.398206359645 (37.7573569210097, -122.398206359645)
112048 116664 3 42 199x Esmeralda Ave 18 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
123706 112614 1 41 1799x 22ND ST 2 14 1 1   12/09/2015 12:00:00 AM 3   Permit Number 776524 6012792.0 2103743.0 37.7571976263526 -122.398754797925 (37.7571976263526, -122.398754797925)
94398 116654 3 38 199x Esmeralda Ave 9 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
95215 116655 3 38 199x Esmeralda Ave 9 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
95391 113478 3 38 100x ESMERALDA AVE 5 14 1 2     8     6006917.0 2098966.0 37.7437519821991 -122.418734104398 (37.7437519821991, -122.418734104398)
95944 116681 3 38 100 Esmeralda Ave 20 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
82185 111319 2 36 200x PENINSULA AVE 2 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
87976 111318 2 36 200x PENINSULA AVE 1 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
104633 99112 2 36 80X Bradford St 1 14 1 1           6009564.7 2098208.3 37.741820222197596 -122.40952548431801 (37.7418202221976, -122.409525484318)
106969 99110 2 36 94 Bernal Heights Blvd 1 14 1 1           6009548.4 2098143.7 37.741641931317396 -122.409577286243 (37.7416419313174, -122.409577286243)
110332 109200 2 36 2401x CASTRO ST 7 14 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
122748 111320 2 36 200x PENINSULA AVE 3 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
108210 122590 2 30 100 MacOndray Ln 1 14 1 1           6008161.0 2119143.0 37.7992232381339 -122.415861106147 (37.7992232381339, -122.415861106147)
78555 116671 3 28 100 Esmeralda Ave 7 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
4727 253673 3 26 600 x Sanchez St 1 14 1 2       3x3   6003598.0 2104743.0 37.75942683738779 -122.43062255590701 (37.7594268373878, -122.430622555907)
92156 116653 3 26 199x Esmeralda Ave 8 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
3501 247943 4 22 29 Joy St 6 14 1 2     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297)
4552 97357 1 17   7 14 1 1                    
Powered by Datasette · Query took 3.433ms · Data source: data.sfgov.org