sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1691 251656 2 17 31x Malta Dr 1 19 1 1       3x3   5999423.0 2096089.0 37.7354276387403 -122.44443976141001 (37.7354276387403, -122.44443976141)
15790 87061 1 40     19 1 1       3x3 Permit Number 50003          
66024 87113 1 3 470 West Portal Ave 4 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)
78803 105667 2 36 301X DORADO TER 1 19 1 1           5994306.4 2092922.0 37.726438562961896 -122.461900058607 (37.7264385629619, -122.461900058607)
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)
85853 114950 7 3 1X WOODACRE DR 2 19 1 2       30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
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)
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)
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)
114979 118322 6 82 720 BATTERY ST 1 19 1 1           6012486.0 2118560.0 37.7978646555778 -122.400854041686 (37.7978646555778, -122.400854041686)
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)
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)
128729 105136 3 38 175X ESMERALDA AVE 2 19 1 2           6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
141981 87114 1 3 470 West Portal Ave 5 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)
143327 87115 1 3 470 West Portal Ave 6 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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
28544 185496 2 105 2400 Sunset Blvd 50 19 1 1     1 Width 0ft   5985141.6583 2098649.8553 37.7416338578085 -122.49400366283501 (37.7416338578085, -122.494003662835)
32088 186539 2 5 1501 Sunset Blvd 10 19 1 1     1 Width 0ft   5984748.3754 2104879.0915 37.7587146113666 -122.49582288356001 (37.7587146113666, -122.49582288356)
35616 185394 2 168 2300 Sunset Blvd 4 19 1 1     1 Width 0ft   5985078.642000001 2098945.9568 37.7424431852403 -122.494243368761 (37.7424431852403, -122.494243368761)
47580 186579 2 116 1501 Sunset Blvd 50 19 1 1     1 Width 0ft   5984739.2681 2104595.0921 37.7579342947119 -122.495833430643 (37.7579342947119, -122.495833430643)
48044 186542 2 108 1501 Sunset Blvd 13 19 1 1     1 Width 0ft   5984733.3013 2104876.5792 37.7587068304654 -122.495874830593 (37.7587068304654, -122.495874830593)
48606 185487 2 129 2400 Sunset Blvd 40 19 1 1     1 Width 0ft   5985139.0022 2098533.6484 37.7413146295557 -122.49400428423901 (37.7413146295557, -122.494004284239)
53924 185395 2 24 2300 Sunset Blvd 7 19 1 1     1 Width 0ft   5985077.1425 2098975.4486 37.7425240740104 -122.494250726815 (37.7425240740104, -122.494250726815)
55166 185499 2 129 2400 Sunset Blvd 53 19 1 1     1 Width 0ft   5985130.3697 2098685.0494 37.741729830798995 -122.494045287668 (37.741729830799, -122.494045287668)
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)
59949 186544 2 108 1501 Sunset Blvd 15 19 1 1     1 Width 0ft   5984717.8085 2104869.8796 37.7586875278599 -122.495927916751 (37.7586875278599, -122.495927916751)
60439 185423 2 24 2300 Sunset Blvd 39 19 1 1     1 Width 0ft   5985071.643999999 2099284.3632 37.7433719482454 -122.494292503743 (37.7433719482454, -122.494292503743)
63349 186499 2 1 1400 Lower Great Hwy 27 19 1 1     1 Width 0ft   5980882.7473 2105311.2882 37.7596741509783 -122.50922385032601 (37.7596741509783, -122.509223850326)
64449 185478 2 180 2400 Sunset Blvd 30 19 1 1     1 Width 0ft   5985137.6741 2098467.2445 37.7411322246193 -122.494003983523 (37.7411322246193, -122.494003983523)
70982 185472 2 129 2400 Sunset Blvd 24 19 1 1     1 Width 0ft   5985147.6347 2098429.3943 37.741028880966894 -122.493966755049 (37.7410288809669, -122.493966755049)
131257 185403 2 180 2300 Sunset Blvd 17 19 1 1     1 Width 0ft   5985110.6332 2099073.9214 37.742796413512 -122.49414218382499 (37.742796413512, -122.494142183825)
147307 186567 2 108 1501 Sunset Blvd 38 19 1 1     1 Width 0ft   5984755.1796 2104685.1177 37.7581824118079 -122.49578504343799 (37.7581824118079, -122.495785043438)
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)
157600 186576 2 3 1501 Sunset Blvd 47 19 1 1     1 Width 0ft   5984768.5788 2104614.3534 37.7579888974289 -122.495733484153 (37.7579888974289, -122.495733484153)
163100 185482 2 129 2400 Sunset Blvd 35 19 1 1     1 Width 0ft   5985148.9628 2098503.7667 37.741233165261896 -122.49396764279498 (37.7412331652619, -122.493967642795)
164558 138264 2 38 2600 GEARY BLVD 32 19 1 1     1 Width 0ft   5999039.2359 2113177.9223 37.7823276740968 -122.44699593627199 (37.7823276740968, -122.446995936272)
167264 186490 2 105 1400 Lower Great Hwy 36 19 1 1     1 Width 0ft   5980883.265 2105397.7493 37.7599115788226 -122.509228480711 (37.7599115788226, -122.509228480711)
174794 186572 2 154 1501 Sunset Blvd 43 19 1 1     1 Width 0ft   5984761.0418 2104653.2947 37.7580953780168 -122.495762422342 (37.7580953780168, -122.495762422342)
178803 186506 2 1 1400 Lower Great Hwy 6 19 1 1     1 Width 0ft   5980906.3041 2105016.4405 37.7588659727132 -122.50912048557801 (37.7588659727132, -122.509120485578)
180584 186563 2 154 1501 Sunset Blvd 34 19 1 1     1 Width 0ft   5984717.9132 2104705.2165 37.7582354149831 -122.495915407531 (37.7582354149831, -122.495915407531)
23747 186497 2 1 1400 Lower Great Hwy 17 19 1 1     2 Width 0ft   5980894.6551 2105244.501 37.7594914745751 -122.509177708249 (37.7594914745751, -122.509177708249)
27191 186631 2 47 1300 Lower Great Hwy 7 19 1 1     2 Width 0ft   5980860.0426 2105683.7293 37.7606954284135 -122.50933003298901 (37.7606954284135, -122.509330032989)
30380 186493 2 1 1400 Lower Great Hwy 23 19 1 1     2 Width 0ft   5980884.8182 2105286.9549 37.7596074608269 -122.509214881201 (37.7596074608269, -122.509214881201)
33000 138260 2 38 2600 GEARY BLVD 28 19 1 1     2 Width 0ft   5999060.2181 2113180.9681 37.7823372358083 -122.446923566676 (37.7823372358083, -122.446923566676)
34689 186540 2 47 1501 Sunset Blvd 11 19 1 1     2 Width 0ft   5984760.5184 2104876.1604 37.7587072745291 -122.49578067192199 (37.7587072745291, -122.495780671922)
35633 185470 2 108 2400 Sunset Blvd 22 19 1 1     2 Width 0ft   5985119.081 2098414.7854 37.7409870981235 -122.49406440544399 (37.7409870981235, -122.494064405444)
37834 185476 2 108 2400 Sunset Blvd 28 19 1 1     2 Width 0ft   5985139.6662 2098449.3154 37.741083112699 -122.49399577462098 (37.741083112699, -122.493995774621)
39570 186559 2 47 1501 Sunset Blvd 30 19 1 1     2 Width 0ft   5984761.8792 2104726.5714 37.7582966244824 -122.495764931436 (37.7582966244824, -122.495764931436)
46197 186496 2 1 1400 Lower Great Hwy 16 19 1 1     2 Width 0ft   5980891.5487 2105237.2527 37.7594713896823 -122.509187913256 (37.7594713896823, -122.509187913256)
Powered by Datasette · Query took 5.257ms · Data source: data.sfgov.org