sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
15790 87061 1 40     19 1 1       3x3 Permit Number 50003          
80300 86765 1 17 500 Brotherhood Way   19 1 1   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
86739 86757 1 84 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
89080 106004 2 103 695X CAMPBELL AVE   19 1 3           6009136.9 2088912.4 37.716271678506 -122.41034847162202 (37.716271678506, -122.410348471622)
89740 86764 1 17 500 Brotherhood Way   19 1 1   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
90997 86768 1 362 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
94096 100243 5 17 1326-1332 Shotwell St   19 1 1           6008043.0 2100485.0 37.7479861507453 -122.41494814206699 (37.7479861507453, -122.414948142067)
105408 86766 1 17 500 Brotherhood Way   19 1 1   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
106936 105441 5 103 425 WAWONA ST   19 1 1           5991587.6 2097036.5 37.737579050883106 -122.471598439568 (37.7375790508831, -122.471598439568)
114230 86759 1 61 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
117147 86767 1 17 500 Brotherhood Way   19 1 1   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
117494 107817 3 3 501X BROTHERHOOD WAY   19 1 2           5991892.0 2087849.0 37.712370053151204 -122.469877266524 (37.7123700531512, -122.469877266524)
117606 86758 1 180 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
117988 86763 1 17 500 Brotherhood Way   19 1 1   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
120349 86760 1 61 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
123656 86762 1 17 500 Brotherhood Way   19 1 1   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
125822 86761 1 61 500 Brotherhood Way   19 1 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
126465 101951 7 17 21 Lyell St   19 1 1           6003106.0 2094969.0 37.7325618289587 -122.43162632292 (37.7325618289587, -122.43162632292)
1691 251656 2 17 31x Malta Dr 1 19 1 1       3x3   5999423.0 2096089.0 37.7354276387403 -122.44443976141001 (37.7354276387403, -122.44443976141)
28131 200245 2 54 1075 Ingerson Ave 1 19 1 1     0 Width 0ft   6013768.3263 2090118.3656 37.71984155975311 -122.394424294358 (37.7198415597531, -122.394424294358)
28513 200177 2 54 1041 Hollister Ave 1 19 1 1     0 Width 0ft   6014650.3204 2089811.8475 37.7190489123065 -122.39135410876001 (37.7190489123065, -122.39135410876)
29647 200249 2 54 1067 Ingerson Ave 1 19 1 1     0 Width 0ft   6013803.2037 2090093.549 37.7197753570889 -122.394301997885 (37.7197753570889, -122.394301997885)
29863 200176 2 54 1047 Hollister Ave 1 19 1 1     0 Width 0ft   6014610.748 2089844.7127 37.7191369573176 -122.391493192738 (37.7191369573176, -122.391493192738)
30792 200164 2 54 1027 Ingerson Ave 1 19 1 1     0 Width 0ft   6014014.4798 2089939.2839 37.7193635176037 -122.393560894555 (37.7193635176037, -122.393560894555)
35785 138256 2 1 2600 GEARY BLVD 1 19 1 1     5 Width 0ft   5999357.6908 2113236.4692 37.7825066175753 -122.44589843946899 (37.7825066175753, -122.445898439469)
37581 200170 2 54 1001 Ingerson Ave 1 19 1 1     0 Width 0ft   6014099.661 2089867.5171 37.71917119290661 -122.393261433304 (37.7191711929066, -122.393261433304)
39813 200248 2 54 1107 Hollister Ave 1 19 1 1     0 Width 0ft   6014274.7183 2090092.8783 37.719799714154504 -122.392672078819 (37.7197997141545, -122.392672078819)
40807 200183 2 54 1197 Hollister Ave 1 19 1 1     0 Width 0ft   6013828.6909 2090422.2008 37.7206791862384 -122.39423689451401 (37.7206791862384, -122.394236894514)
42125 200722 2 54 1476 Oakdale Ave 1 19 1 1     0 Width 0ft   6015747.1852 2094980.6714 37.7333022953684 -122.387923119588 (37.7333022953684, -122.387923119588)
43519 200180 2 54 1031 Hollister Ave 1 19 1 1     0 Width 0ft   6014690.5634 2089785.0188 37.7189774793874 -122.391213128817 (37.7189774793874, -122.391213128817)
44928 200155 2 54 1091 Hollister Ave 1 19 1 1     0 Width 0ft   6014363.9238 2090021.1115 37.719607610680704 -122.39235870744899 (37.7196076106807, -122.392358707449)
47539 186530 2 108 1501 Sunset Blvd 1 19 1 1     2 Width 0ft   5984710.6902 2104914.2643 37.7588089789692 -122.495955809021 (37.7588089789692, -122.495955809021)
48984 200734 2 28 1434 Oakdale Ave 1 19 1 1     7 Width 0ft   6015941.8417 2094834.993 37.7329130736504 -122.387239974213 (37.7329130736504, -122.387239974213)
49295 186515 2 1 1400 Lower Great Hwy 1 19 1 1     3 Width 0ft   5980905.2686 2104984.8589 37.7587791976552 -122.509121721574 (37.7587791976552, -122.509121721574)
49960 105135 3 26 175X ESMERALDA AVE 1 19 1 2     26     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
52467 200157 2 54 1091 Hollister Ave 1 19 1 1     0 Width 0ft   6014392.094 2090006.3557 37.7195686584119 -122.39226030100401 (37.7195686584119, -122.392260301004)
55366 200178 2 54 3201 Ingerson Ave 1 19 1 1     0 Width 0ft   6014218.378 2089782.3359 37.7189438969212 -122.39284511455 (37.7189438969212, -122.39284511455)
58301 200156 2 54 1047 Ingerson Ave 1 19 1 1     0 Width 0ft   6013914.5428 2090009.7093 37.7195513382693 -122.39391126933 (37.7195513382693, -122.39391126933)
61127 200498 2 54 1055 Ingerson Ave 1 19 1 1     0 Width 0ft   6013869.6047 2090039.2209 37.7196298737115 -122.394068670065 (37.7196298737115, -122.394068670065)
73420 200232 2 54 923 Ingerson Ave 1 19 1 1     0 Width 0ft   6014491.3602 2089577.767 37.7183973497527 -122.391887217647 (37.7183973497527, -122.391887217647)
74346 200162 2 54 1035 Ingerson Ave 1 19 1 1     0 Width 0ft   6013970.2124 2089969.4662 37.7194439323961 -122.393716023061 (37.7194439323961, -122.393716023061)
78014 107210 2 3 603 PERALTA AVE 1 19 1 1     30     6009839.9 2098688.7 37.7431547125392 -122.40860781001498 (37.7431547125392, -122.408607810015)
78803 105667 2 36 301X DORADO TER 1 19 1 1           5994306.4 2092922.0 37.726438562961896 -122.461900058607 (37.7264385629619, -122.461900058607)
98700 105140 3 3 125X ESMERALDA AVE 1 19 1 2     12     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
111345 114949 7 3 1X WOODACRE DR 1 19 1 2     30 30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
114979 118322 6 82 720 BATTERY ST 1 19 1 1           6012486.0 2118560.0 37.7978646555778 -122.400854041686 (37.7978646555778, -122.400854041686)
116266 105664 2 17 317X DORADO TER 1 19 1 1     10     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308)
130262 200159 2 5 1043 Ingerson Ave 1 19 1 1     9 Width 0ft   6013947.408 2089985.5634 37.719486864857004 -122.39379597620301 (37.719486864857, -122.393795976203)
131395 183037 2 8 2523 43rd Ave 1 19 1 1     15 Width 0ft   5983009.062000001 2097931.9719 37.7395377337872 -122.50132425344299 (37.7395377337872, -122.501324253443)
131768 200212 2 54 1101 Ingerson Ave 1 19 1 1     0 Width 0ft   6013545.647999999 2090276.655 37.720263809593604 -122.395205102903 (37.7202638095936, -122.395205102903)
133594 200166 2 54 1023 Ingerson Ave 1 19 1 1     0 Width 0ft   6014031.9185 2089919.1624 37.7193092369184 -122.393499207549 (37.7193092369184, -122.393499207549)
137668 200250 2 36 917 Ingerson Ave 1 19 1 1     5 Width 0ft   6014641.601 2089467.7692 37.7181036570096 -122.391360208379 (37.7181036570096, -122.391360208379)
144780 200169 2 54 1061 Hollister Ave 1 19 1 1     0 Width 0ft   6014525.5668 2089911.1138 37.719314553356206 -122.391792274296 (37.7193145533562, -122.391792274296)
147039 200193 2 54 975 Ingerson Ave 1 19 1 1     0 Width 0ft   6014303.5592 2089724.6542 37.7187902452961 -122.392546641558 (37.7187902452961, -122.392546641558)
147744 200731 2 19 1462 Oakdale Ave 1 19 1 1     4 Width 0ft   6015811.2335 2094944.8797 37.7332075665853 -122.387699188627 (37.7332075665853, -122.387699188627)
150420 200167 2 54 1019 Ingerson Ave 1 19 1 1     0 Width 0ft   6014049.3571 2089910.4430000002 37.7192862641022 -122.393438318502 (37.7192862641022, -122.393438318502)
156135 200237 2 5 919 Ingerson Ave 1 19 1 1     4 Width 0ft   6014571.1757 2089512.0366 37.7182212977035 -122.39160673351002 (37.7182212977035, -122.39160673351)
156632 200165 2 54 1071 Hollister Ave 1 19 1 1     0 Width 0ft   6014485.3238 2089939.2839 37.7193896687982 -122.39193334918501 (37.7193896687982, -122.391933349185)
157058 185451 2 47 2400 Sunset Blvd 1 19 1 1     30 Width 0ft   5985130.3697 2098228.1903 37.740475418723506 -122.49401162519399 (37.7404754187235, -122.494011625194)
157610 200239 2 54 1131 Hollister Ave 1 19 1 1     0 Width 0ft   6014148.6234 2090188.791 37.7200560674381 -122.39311465541401 (37.7200560674381, -122.393114655414)
160873 185390 2 154 2300 Sunset Blvd 1 19 1 1     2 Width 0ft   5985092.6382 2098924.4627 37.742384987274704 -122.49419339090001 (37.7423849872747, -122.4941933909)
165416 200238 2 54 917 Ingerson Ave 1 19 1 1     0 Width 0ft   6014595.9922 2089500.6344 37.7181913669776 -122.391520156023 (37.7181913669776, -122.391520156023)
168550 200246 2 54 1071 Ingerson Ave 1 19 1 1     0 Width 0ft   6013781.7407 2090110.9877 37.719822047209 -122.394377408818 (37.719822047209, -122.394377408818)
171950 200244 2 54 1123 Hollister Ave 1 19 1 1     0 Width 0ft   6014193.5615 2090152.5722 37.7199591140845 -122.39295678576201 (37.7199591140845, -122.392956785762)
173333 200730 2 54 1466 Oakdale Ave 1 19 1 1     0 Width 0ft   6015770.4184 2094966.2292 37.733263927070006 -122.387841787924 (37.73326392707, -122.387841787924)
176910 200204 2 54 2 Ingerson Ave 1 19 1 1     0 Width 0ft   6014372.6432 2089670.326 37.71864490712711 -122.392304046142 (37.7186449071271, -122.392304046142)
177358 200205 2 54 1003 Hollister Ave 1 19 1 1     0 Width 0ft   6014813.9755 2089679.7161 37.71869518696921 -122.39077918277701 (37.7186951869692, -122.390779182777)
177805 200235 2 54 923 Ingerson Ave 1 19 1 1     0 Width 0ft   6014534.9569 2089547.5847 37.7183168953073 -122.39173441165 (37.7183168953073, -122.39173441165)
177846 200172 2 54 1053 Hollister Ave 1 19 1 1     0 Width 0ft   6014576.5414 2089866.8464 37.7191958334242 -122.391612979464 (37.7191958334242, -122.391612979464)
179075 200190 2 54 1027 Hollister Ave 1 19 1 1     0 Width 0ft   6014706.6607 2089771.6044 37.7189415394071 -122.391156549139 (37.7189415394071, -122.391156549139)
179207 200191 2 54 981 Ingerson Ave 1 19 1 1     0 Width 0ft   6014255.2675 2089757.5194 37.7188778046353 -122.39271586587799 (37.7188778046353, -122.392715865878)
180173 186625 2 2 1300 Lower Great Hwy 1 19 1 1     2 Width 0ft   5980868.2988 2105582.371 37.76041761449721 -122.50929395155 (37.7604176144972, -122.50929395155)
182449 200194 2 54 1011 Hollister Ave 1 19 1 1     0 Width 0ft   6014781.1104 2089713.2519999999 37.718785446443206 -122.390895127615 (37.7187854464432, -122.390895127615)
182621 200227 2 39 1079 Ingerson Ave 1 19 1 1     11 Width 0ft   6013668.3894 2090192.8153 37.7200404277679 -122.39477495490499 (37.7200404277679, -122.394774954905)
186420 200171 2 54 1059 Hollister Ave 1 19 1 1     0 Width 0ft   6014549.7127 2089886.9679 37.7192495938582 -122.391707122944 (37.7192495938582, -122.391707122944)
187469 200742 2 54 1454 Oakdale Ave 1 19 1 1     0 Width 0ft   6015834.4667 2094922.2745 37.733146784173606 -122.38761728786601 (37.7331467841736, -122.387617287866)
188973 200161 2 54 1083 Hollister Ave 1 19 1 1     0 Width 0ft   6014425.6299 2089982.8806 37.7195060625081 -122.392142737787 (37.7195060625081, -122.392142737787)
30597 200732 2 19 1462 Oakdale Ave 2 19 1 1     4 Width 0ft   6015803.6984 2094934.205 37.7331778386107 -122.387724495212 (37.7331778386107, -122.387724495212)
53419 186531 2 143 1501 Sunset Blvd 2 19 1 1     9 Width 0ft   5984751.3064 2104919.289 37.7588251541556 -122.49581571217699 (37.7588251541556, -122.495815712177)
55679 200228 2 39 1079 Ingerson Ave 2 19 1 1     7 Width 0ft   6013685.1573 2090181.4131 37.7200100518893 -122.394716195485 (37.7200100518893, -122.394716195485)
57892 185452 2 180 2400 Sunset Blvd 2 19 1 1     1 Width 0ft   5985111.1125 2098241.4711 37.7405107574318 -122.49407918667299 (37.7405107574318, -122.494079186673)
74158 138257 2 224 2600 GEARY BLVD 2 19 1 1     4 Width 0ft   5999359.7213 2113228.3471 37.7824844323354 -122.445890830511 (37.7824844323354, -122.445890830511)
85276 105668 2 36 301X DORADO TER 2 19 1 1     12     5994306.4 2092922.0 37.726438562961896 -122.461900058607 (37.7264385629619, -122.461900058607)
85853 114950 7 3 1X WOODACRE DR 2 19 1 2       30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
116169 87111 1 3 470 West Portal Ave 2 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
128729 105136 3 38 175X ESMERALDA AVE 2 19 1 2           6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
137300 142638 2 15 333 BAY ST 2 19 1 1     8 Width 0ft   6009068.3546 2121458.9525 37.8056332348144 -122.41288516543301 (37.8056332348144, -122.412885165433)
145561 105665 2 40 317X DORADO TER 2 19 1 1     24     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308)
152791 185391 2 168 2300 Sunset Blvd 2 19 1 1     1 Width 0ft   5985125.1292 2098935.9595 37.7424184556167 -122.49408189561899 (37.7424184556167, -122.494081895619)
153024 186626 2 47 1300 Lower Great Hwy 2 19 1 1     7 Width 0ft   5980879.19 2105650.5288 37.7606053983358 -122.509261346313 (37.7606053983358, -122.509261346313)
168399 200213 2 54 1101 Ingerson Ave 2 19 1 1     0 Width 0ft   6013590.5861 2090251.1677 37.7201963256026 -122.395047981349 (37.7201963256026, -122.395047981349)
181911 186516 2 1 1400 Lower Great Hwy 2 19 1 1     3 Width 0ft   5980905.2686 2104991.5894 37.758797677676704 -122.509122221366 (37.7587976776767, -122.509122221366)
24598 186532 2 108 1501 Sunset Blvd 3 19 1 1     1 Width 0ft   5984706.503 2104907.5647 37.7587903384946 -122.49596979583599 (37.7587903384946, -122.495969795836)
34013 185453 2 47 2400 Sunset Blvd 3 19 1 1     32 Width 0ft   5985125.7214 2098256.744 37.740553547520705 -122.494029800854 (37.7405535475207, -122.494029800854)
69172 186627 2 1 1300 Lower Great Hwy 3 19 1 1     3 Width 0ft   5980877.609 2105668.6222 37.760654984387706 -122.509268157881 (37.7606549843877, -122.509268157881)
89237 87112 1 3 470 West Portal Ave 3 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
105735 105666 2 40 317X DORADO TER 3 19 1 1     22     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308)
109114 105137 3 3 175X ESMERALDA AVE 3 19 1 2     18     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
137444 142738 2 15 333 BAY ST 3 19 1 1     11 Width 0ft   6009098.7568 2121462.5595 37.805644845194 -122.412780209055 (37.805644845194, -122.412780209055)
138059 200229 2 1 1079 Ingerson Ave 3 19 1 1     4 Width 0ft   6013701.2545 2090170.6816 37.719981480300795 -122.39465980145201 (37.7199814803008, -122.394659801452)
146760 186517 2 164 1400 Lower Great Hwy 3 19 1 1     9 Width 0ft   5980906.8218 2104997.2844 37.7588134060814 -122.509117272676 (37.7588134060814, -122.509117272676)
Powered by Datasette · Query took 3.56ms · Data source: data.sfgov.org