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                    
4222 253622 2 128 300x Naglee Ave   14 1 1                    
4552 97357 1 17   7 14 1 1                    
4913 97358 1 17   8 14 1 1                    
7011 97356 1 17   6 14 1 1                    
7040 97351 1 17   1 14 1 1                    
8657 97354 1 17   4 14 1 1                    
10631 97353 1 17   3 14 1 1                    
14893 97355 1 17   5 14 1 1                    
16895 97352 1 17   2 14 1 1                    
185502 122532 2 3 1900X Castro St 1 14 1 1                    
94946 95436 2 103 2675 25th Ave 3 14 1 1     16     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
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)
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)
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)
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)
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)
697 251362 2 105 1300X Stanyan St 1 14 1 1       3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
114729 96803 2 103 300X Melrose Ave 1 14 1 1     48     5998134.5 2095546.7 37.733865009274204 -122.448855518806 (37.7338650092742, -122.448855518806)
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)
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)
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)
94793 106979 3 506 801X Clipper St 1 14 1 2     24     5999765.50041 2100345.59515 37.7471347718267 -122.443561289165 (37.7471347718267, -122.443561289165)
82723 102522 2 129 1X 31st St 2 14 1 1           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233)
106463 102521 2 3 1X 31st St 1 14 1 1           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233)
100274 99610 2 17 111 Corwin St   14 2 1           6000616.0 2104331.0 37.7581261988062 -122.44090619353999 (37.7581261988062, -122.44090619354)
3355 253433 2 116 3 Vulcan Stwy 1 14 1 1       3x3   6000640.0 2106231.0 37.7633444989385 -122.440959493883 (37.7633444989385, -122.440959493883)
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)
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)
110332 109200 2 36 2401x CASTRO ST 7 14 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
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)
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)
92684 115379 2 17 4004 20TH ST   14 1 1       3x3   6003604.0 2104237.0 37.758037821948 -122.43056569919399 (37.758037821948, -122.430565699194)
142115 121724 2 330 439X ARLINGTON ST 2 14 1 1           6003949.9 2096014.9 37.7354814316621 -122.42878329168998 (37.7354814316621, -122.42878329169)
79542 115664 2 1 601x PERU AVE 2 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
96239 115665 2 1 601x PERU AVE 3 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
124140 115663 2 1 601x PERU AVE 1 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
139585 115666 2 1 601x PERU AVE 4 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
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)
26646 107449 2 143 1130x CHESTNUT ST 1 14 1 1     60     6006351.9 2120450.9 37.802712528214705 -122.42221419659701 (37.8027125282147, -122.422214196597)
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)
102335 108605 2 143 1140x CHESTNUT ST 2 14 1 1           6006369.1 2120452.7 37.802718440704204 -122.42215480373899 (37.8027184407042, -122.422154803739)
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)
76347 111157 2 1 201x EUGENIA AVE 4 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
82433 111159 2 1 201x EUGENIA AVE 6 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
87282 111156 2 1 201x EUGENIA AVE 3 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
97479 111154 2 1 201x EUGENIA AVE 1 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
100068 111158 2 1 201x EUGENIA AVE 5 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
114760 111155 2 1 201x EUGENIA AVE 2 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
93592 97535 1 3 300 Winfield St 1 14 1 1           6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
106956 97537 1 3 300 Winfield St 3 14 1 1           6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
144308 97536 1 3 300 Winfield St 2 14 1 1         Permit Number 768224 6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
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)
49637 114270 2 3 27x ESMERALDA AVE 2 14 1 1       3x3   6006799.0 2098981.0 37.743786524331 -122.41914318493001 (37.743786524331, -122.41914318493)
108370 102729 2 3 49X Esmeralda Ave 1 14 1 1     24     6006840.1 2099056.7 37.7439966940099 -122.419006438675 (37.7439966940099, -122.419006438675)
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)
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)
95391 113478 3 38 100x ESMERALDA AVE 5 14 1 2     8     6006917.0 2098966.0 37.7437519821991 -122.418734104398 (37.7437519821991, -122.418734104398)
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)
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)
Powered by Datasette · Query took 4.336ms · Data source: data.sfgov.org