sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
102335 108605 2 143 1140x CHESTNUT ST 2 14 1 1           6006369.1 2120452.7 37.802718440704204 -122.42215480373899 (37.8027184407042, -122.422154803739)
26646 107449 2 143 1130x CHESTNUT ST 1 14 1 1     60     6006351.9 2120450.9 37.802712528214705 -122.42221419659701 (37.8027125282147, -122.422214196597)
8668 107450 2 143 1140x Chestnut St 1 14 1 1     60     6006380.05181 2120425.48408 37.802644330436394 -122.42211497023399 (37.8026443304364, -122.422114970234)
7555 107448 2 143 1111x Chestnut St 1 14 1 1     50     6006408.68895 2120404.8626200003 37.80258932431129 -122.42201440535801 (37.8025893243113, -122.422014405358)
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)
84377 107372 2 175 305x GREENWICH ST 1 14 1 1     20     6011370.0 2120243.0 37.8024234525216 -122.40483428789801 (37.8024234525216, -122.404834287898)
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)
81729 109625 2 143 312x FILBERT ST 1 14 1 1     14     6011362.9 2120079.8 37.801974948341 -122.40484736081001 (37.801974948341, -122.40484736081)
43848 99190 1 15 1155@Greenwich Battery St 3 14 1 1   04/24/2012 12:00:00 AM 13 Park Permit Number 768770 6012236.89935 2120056.2938 37.801959219714 -122.401821238566 (37.801959219714, -122.401821238566)
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)
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)
108210 122590 2 30 100 MacOndray Ln 1 14 1 1           6008161.0 2119143.0 37.7992232381339 -122.415861106147 (37.7992232381339, -122.415861106147)
42966 112248 3 158 1799X TAYLOR ST 1 14 1 2     15     6008739.0 2118839.0 37.79842100686071 -122.413839504702 (37.7984210068607, -122.413839504702)
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)
3355 253433 2 116 3 Vulcan Stwy 1 14 1 1       3x3   6000640.0 2106231.0 37.7633444989385 -122.440959493883 (37.7633444989385, -122.440959493883)
143207 98706 2 47 353 UPPER TER   14 1 1           5999086.1 2105914.9 37.7623879420949 -122.446311165521 (37.7623879420949, -122.446311165521)
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)
697 251362 2 105 1300X Stanyan St 1 14 1 1       3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
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)
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)
88788 117626 2 3 890x VERMONT ST 3 14 1 1           6011292.0 2104239.0 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201)
122293 117624 2 435 890x VERMONT ST 2 14 1 1           6011292.0 2104239.0 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201)
128665 117627 2 3 890x VERMONT ST 4 14 1 1           6011292.0 2104239.0 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201)
100274 99610 2 17 111 Corwin St   14 2 1           6000616.0 2104331.0 37.7581261988062 -122.44090619353999 (37.7581261988062, -122.44090619354)
92684 115379 2 17 4004 20TH ST   14 1 1       3x3   6003604.0 2104237.0 37.758037821948 -122.43056569919399 (37.758037821948, -122.430565699194)
108019 96539 1 17 952X Kansas St 1 14 1 1   05/25/2011 12:00:00 AM     Permit Number 767960 6011608.51303 2103942.83298 37.757680312097705 -122.40286183184901 (37.7576803120977, -122.402861831849)
83991 96537 1 17 950X Kansas St 1 14 1 1   05/25/2011 12:00:00 AM     Permit Number 767960 6011564.8 2103917.5 37.7576083124183 -122.403011228478 (37.7576083124183, -122.403011228478)
114801 96538 1 17 950X Kansas St 2 14 1 1   05/25/2011 12:00:00 AM     Permit Number 767960 6011564.8 2103917.5 37.7576083124183 -122.403011228478 (37.7576083124183, -122.403011228478)
86227 112615 2 3 1798x 22ND ST 2 14 1 1   05/02/2016 12:00:00 AM 3     6012787.0 2103832.0 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858)
92918 110864 2 504 1798x 22ND ST 1 14 1 1           6012787.0 2103832.0 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858)
160398 121610 2 46 1700 22nd St 1 14 1 1     11     6012951.69217 2103797.77434 37.7573569210097 -122.398206359645 (37.7573569210097, -122.398206359645)
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)
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)
5081 253792 2 1 1698X 08th Ave 2 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5085 253795 2 1 1698X 08th Ave 5 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5092 253791 2 1 1698X 08th Ave 1 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5097 253793 2 1 1698X 08th Ave 3 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5099 253794 2 1 1698X 08th Ave 4 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
99604 106503 2 5 3974 22nd St 1 14 1 1         Permit Number 773286 6002049.0 2102947.0 37.754407578182004 -122.435851245675 (37.754407578182, -122.435851245675)
106187 106504 2 5 3974 22nd St 2 14 1 1         Permit Number 773286 6002049.0 2102947.0 37.754407578182004 -122.435851245675 (37.754407578182, -122.435851245675)
107113 106505 2 5 3975 22nd St 1 14 1 1         Permit Number 773291 6002049.0 2102913.0 37.7543142223274 -122.435848813122 (37.7543142223274, -122.435848813122)
128960 106506 2 5 3975 22nd St 2 14 1 1         Permit Number 773291 6002049.0 2102913.0 37.7543142223274 -122.435848813122 (37.7543142223274, -122.435848813122)
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)
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)
127637 64475 1 17 201 Quintara St 1 14 1 1   03/27/2012 12:00:00 AM     Permit Number 768647 5992886.81207962 2101152.3784099 37.7489552885612 -122.46740569056601 (37.7489552885612, -122.467405690566)
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)
94793 106979 3 506 801X Clipper St 1 14 1 2     24     5999765.50041 2100345.59515 37.7471347718267 -122.443561289165 (37.7471347718267, -122.443561289165)
89419 115524 1 17 25 FRANCONIA ST 1 14 1 1   07/12/2016 12:00:00 AM 3 3x3 Permit Number 777451 6010006.0 2099954.0 37.746638251201404 -122.408122694659 (37.7466382512014, -122.408122694659)
120315 115525 2 318 25 FRANCONIA ST 2 14 1 1       3x3   6010006.0 2099954.0 37.746638251201404 -122.408122694659 (37.7466382512014, -122.408122694659)
139483 115526 1 17 25 FRANCONIA ST 3 14 1 1   07/12/2016 12:00:00 AM 3 3x3 Permit Number 777451 6010006.0 2099954.0 37.746638251201404 -122.408122694659 (37.7466382512014, -122.408122694659)
86301 105759 1 17 1910X CASTRO ST 4 14 1 1   04/10/2014 12:00:00 AM 15   Permit Number 771977 6002617.0 2100030.0 37.746430435118796 -122.43367849259899 (37.7464304351188, -122.433678492599)
105289 105760 1 17 1910X CASTRO ST 5 14 1 1   04/10/2014 12:00:00 AM 15   Permit Number 771977 6002617.0 2100030.0 37.746430435118796 -122.43367849259899 (37.7464304351188, -122.433678492599)
85549 122555 1 17 1910X Castro St 1 14 1 1           6002640.0 2099906.0 37.746091265221295 -122.433590100931 (37.7460912652213, -122.433590100931)
110195 105756 1 17 1910X CASTRO ST 3 14 1 1   04/10/2014 12:00:00 AM 14   Permit Number 771977 6002640.0 2099906.0 37.746091265221295 -122.433590100931 (37.7460912652213, -122.433590100931)
117756 114584 1 17 3300x HARRISON ST 1 14 1 1   02/04/2016 12:00:00 AM 3   Permit Number 777406 6009042.0 2099449.0 37.745197609352005 -122.411420448228 (37.745197609352, -122.411420448228)
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)
108370 102729 2 3 49X Esmeralda Ave 1 14 1 1     24     6006840.1 2099056.7 37.7439966940099 -122.419006438675 (37.7439966940099, -122.419006438675)
80443 105069 2 12 49X Esmeralda Ave 2 14 1 1         Permit Number 771039 6006861.0 2099026.0 37.7439135755866 -122.41893199410299 (37.7439135755866, -122.418931994103)
115043 105070 2 12 49X Esmeralda Ave 3 14 1 1         Permit Number 771039 6006861.0 2099026.0 37.7439135755866 -122.41893199410299 (37.7439135755866, -122.418931994103)
121371 112379 2 3 25x ESMERALDA AVE 1 14 1 1     20 3x3   6006716.0 2099027.0 37.743908155469896 -122.41943344261499 (37.7439081554699, -122.419433442615)
121402 107675 2 2 98x LUNDYS LN 1 14 1 1     14 8x10   6006855.0 2099015.0 37.74388303419929 -122.41895196073901 (37.7438830341993, -122.418951960739)
78442 99274 2 3 16 Joy St 1 14 1 1       3x3 Permit Number 768828 6010347.9 2098933.4 37.7438550437031 -122.406868515265 (37.7438550437031, -122.406868515265)
3513 247938 4 16 29 Joy St 1 14 1 2     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056)
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)
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)
49637 114270 2 3 27x ESMERALDA AVE 2 14 1 1       3x3   6006799.0 2098981.0 37.743786524331 -122.41914318493001 (37.743786524331, -122.41914318493)
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)
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)
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)
19241 116677 3 58 100 Esmeralda Ave 16 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
78555 116671 3 28 100 Esmeralda Ave 7 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
82247 116682 3 108 100 Esmeralda Ave 21 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
86166 116675 3 180 100 Esmeralda Ave 14 14 1 2     14     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
89602 116672 3 3 100 Esmeralda Ave 9 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
92622 116679 3 211 100 Esmeralda Ave 18 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
95360 116668 3 129 100x Esmeralda Ave 4 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
95944 116681 3 38 100 Esmeralda Ave 20 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
97063 116666 3 3 100x Esmeralda Ave 2 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
110832 116665 3 3 100x Esmeralda Ave 1 14 1 2     25     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
113837 116669 3 47 100 Esmeralda Ave 6 14 1 2     20     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
123800 116680 3 132 100 Esmeralda Ave 19 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
126736 116670 3 180 100 Esmeralda Ave 8 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)
138825 116683 3 108 100 Esmeralda Ave 22 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
143384 116676 3 338 100 Esmeralda Ave 15 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
144028 113477 3 3 100x Esmeralda Ave 10 14 1 2     24     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)
95391 113478 3 38 100x ESMERALDA AVE 5 14 1 2     8     6006917.0 2098966.0 37.7437519821991 -122.418734104398 (37.7437519821991, -122.418734104398)
69268 116648 3 193 199x Esmeralda Ave 3 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
77674 116662 3 3 199x Esmeralda Ave 15 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)
92156 116653 3 26 199x Esmeralda Ave 8 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
93306 116660 3 116 199x Esmeralda Ave 13 14 1 2     8     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
94398 116654 3 38 199x Esmeralda Ave 9 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
Powered by Datasette · Query took 2.958ms · Data source: data.sfgov.org