sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
549 251321 2 47 100X Monument Way 1 14 1 1                    
697 251362 2 105 1300X Stanyan St 1 14 1 1       3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
934 251409 2 3 95x Andover St 1 14 1 1       3x3   6007642.0 2098274.0 37.741892697320296 -122.41617822056101 (37.7418926973203, -122.416178220561)
3355 253433 2 116 3 Vulcan Stwy 1 14 1 1       3x3   6000640.0 2106231.0 37.7633444989385 -122.440959493883 (37.7633444989385, -122.440959493883)
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)
4222 253622 2 128 300x Naglee Ave   14 1 1                    
4552 97357 1 17   7 14 1 1                    
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)
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)
4913 97358 1 17   8 14 1 1                    
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)
7011 97356 1 17   6 14 1 1                    
7040 97351 1 17   1 14 1 1                    
7555 107448 2 143 1111x Chestnut St 1 14 1 1     50     6006408.68895 2120404.8626200003 37.80258932431129 -122.42201440535801 (37.8025893243113, -122.422014405358)
8657 97354 1 17   4 14 1 1                    
8668 107450 2 143 1140x Chestnut St 1 14 1 1     60     6006380.05181 2120425.48408 37.802644330436394 -122.42211497023399 (37.8026443304364, -122.422114970234)
9968 173756 2 3 1X Emil Ln 2 14 1 1       3x3   5996276.0 2095955.0 37.734879644622296 -122.455310374086 (37.7348796446223, -122.455310374086)
9970 173755 2 3 1X Emil Ln 1 14 1 1       3x3   5996276.0 2095955.0 37.734879644622296 -122.455310374086 (37.7348796446223, -122.455310374086)
10631 97353 1 17   3 14 1 1                    
14893 97355 1 17   5 14 1 1                    
16895 97352 1 17   2 14 1 1                    
19241 116677 3 58 100 Esmeralda Ave 16 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
26646 107449 2 143 1130x CHESTNUT ST 1 14 1 1     60     6006351.9 2120450.9 37.802712528214705 -122.42221419659701 (37.8027125282147, -122.422214196597)
42966 112248 3 158 1799X TAYLOR ST 1 14 1 2     15     6008739.0 2118839.0 37.79842100686071 -122.413839504702 (37.7984210068607, -122.413839504702)
49637 114270 2 3 27x ESMERALDA AVE 2 14 1 1       3x3   6006799.0 2098981.0 37.743786524331 -122.41914318493001 (37.743786524331, -122.41914318493)
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)
69268 116648 3 193 199x Esmeralda Ave 3 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
72511 98376 2 47 199X Cragmont Ave 1 14 1 1           5992899.0 2101153.0 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244)
76347 111157 2 1 201x EUGENIA AVE 4 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
77461 107157 2 3 301X Esmeralda Ave 1 14 1 1     28     6007313.0 2098782.0 37.7432690474632 -122.41735179051201 (37.7432690474632, -122.417351790512)
77674 116662 3 3 199x Esmeralda Ave 15 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
78555 116671 3 28 100 Esmeralda Ave 7 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
79334 116646 3 193 199x Esmeralda Ave 1 14 1 2     2     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
79542 115664 2 1 601x PERU AVE 2 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
81729 109625 2 143 312x FILBERT ST 1 14 1 1     14     6011362.9 2120079.8 37.801974948341 -122.40484736081001 (37.801974948341, -122.40484736081)
82185 111319 2 36 200x PENINSULA AVE 2 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
82247 116682 3 108 100 Esmeralda Ave 21 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
82433 111159 2 1 201x EUGENIA AVE 6 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
82496 116652 3 193 199x Esmeralda Ave 7 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
82723 102522 2 129 1X 31st St 2 14 1 1           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233)
84377 107372 2 175 305x GREENWICH ST 1 14 1 1     20     6011370.0 2120243.0 37.8024234525216 -122.40483428789801 (37.8024234525216, -122.404834287898)
85549 122555 1 17 1910X Castro St 1 14 1 1           6002640.0 2099906.0 37.746091265221295 -122.433590100931 (37.7460912652213, -122.433590100931)
86166 116675 3 180 100 Esmeralda Ave 14 14 1 2     14     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
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)
87282 111156 2 1 201x EUGENIA AVE 3 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
87421 111309 2 176 100x GILROY ST 1 14 1 1       30x30   6015178.0 2088529.0 37.7155557353625 -122.38944056945101 (37.7155557353625, -122.389440569451)
87976 111318 2 36 200x PENINSULA AVE 1 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
88788 117626 2 3 890x VERMONT ST 3 14 1 1           6011292.0 2104239.0 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201)
89602 116672 3 3 100 Esmeralda Ave 9 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
91188 111312 2 176 99x GILROY ST 3 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
92156 116653 3 26 199x Esmeralda Ave 8 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
92622 116679 3 211 100 Esmeralda Ave 18 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
92684 115379 2 17 4004 20TH ST   14 1 1       3x3   6003604.0 2104237.0 37.758037821948 -122.43056569919399 (37.758037821948, -122.430565699194)
92918 110864 2 504 1798x 22ND ST 1 14 1 1           6012787.0 2103832.0 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858)
93306 116660 3 116 199x Esmeralda Ave 13 14 1 2     8     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
93493 121630 2 1 96x Valmar Ter 1 14 1 1     12 3x3   6005224.0 2092573.0 37.726102766942205 -122.42413354236 (37.7261027669422, -122.42413354236)
93592 97535 1 3 300 Winfield St 1 14 1 1           6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
94398 116654 3 38 199x Esmeralda Ave 9 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
94709 117610 2 98 391 NEVADA ST 1 14 2 1       3x3   6008958.0 2096497.0 37.737087351465796 -122.41150238578501 (37.7370873514658, -122.411502385785)
94793 106979 3 506 801X Clipper St 1 14 1 2     24     5999765.50041 2100345.59515 37.7471347718267 -122.443561289165 (37.7471347718267, -122.443561289165)
94946 95436 2 103 2675 25th Ave 3 14 1 1     16     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
95215 116655 3 38 199x Esmeralda Ave 9 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
95360 116668 3 129 100x Esmeralda Ave 4 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)
95944 116681 3 38 100 Esmeralda Ave 20 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
96239 115665 2 1 601x PERU AVE 3 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
96975 111311 2 176 99x GILROY ST 2 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
97063 116666 3 3 100x Esmeralda Ave 2 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
97479 111154 2 1 201x EUGENIA AVE 1 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
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)
100068 111158 2 1 201x EUGENIA AVE 5 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
100274 99610 2 17 111 Corwin St   14 2 1           6000616.0 2104331.0 37.7581261988062 -122.44090619353999 (37.7581261988062, -122.44090619354)
101119 109309 2 3 349x MAYFLOWER ST 1 14 1 1           6009941.0 2098430.0 37.7424500403346 -122.40823998935801 (37.7424500403346, -122.408239989358)
101447 116661 3 3 199x Esmeralda Ave 14 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
102335 108605 2 143 1140x CHESTNUT ST 2 14 1 1           6006369.1 2120452.7 37.802718440704204 -122.42215480373899 (37.8027184407042, -122.422154803739)
102606 112729 2 3 444 Franconia St 2 14 1 1     24     6009949.70212209 2098546.33795552 37.7427699663381 -122.40821810325701 (37.7427699663381, -122.408218103257)
104633 99112 2 36 80X Bradford St 1 14 1 1           6009564.7 2098208.3 37.741820222197596 -122.40952548431801 (37.7418202221976, -122.409525484318)
105116 105651 2 211 150 BRONTE ST 2 14 1 1     20     6009287.5 2096640.3 37.737499298818996 -122.410373266073 (37.737499298819, -122.410373266073)
105354 116656 3 3 199x Esmeralda Ave 10 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
105412 116658 3 3 199x Esmeralda Ave 12 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
106463 102521 2 3 1X 31st St 1 14 1 1           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233)
106956 97537 1 3 300 Winfield St 3 14 1 1           6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
106969 99110 2 36 94 Bernal Heights Blvd 1 14 1 1           6009548.4 2098143.7 37.741641931317396 -122.409577286243 (37.7416419313174, -122.409577286243)
108210 122590 2 30 100 MacOndray Ln 1 14 1 1           6008161.0 2119143.0 37.7992232381339 -122.415861106147 (37.7992232381339, -122.415861106147)
108370 102729 2 3 49X Esmeralda Ave 1 14 1 1     24     6006840.1 2099056.7 37.7439966940099 -122.419006438675 (37.7439966940099, -122.419006438675)
110332 109200 2 36 2401x CASTRO ST 7 14 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
110832 116665 3 3 100x Esmeralda Ave 1 14 1 2     25     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
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)
112048 116664 3 42 199x Esmeralda Ave 18 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)
112606 105901 3 103 11X ELLIOT ST 2 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
Powered by Datasette · Query took 3.523ms · Data source: data.sfgov.org