sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
26085 121888 2 168 10 17th Ave 1 2 1 1     9 Width 2ft   5990543.39906 2115002.75523 37.786849107740395 -122.476520812684 (37.7868491077404, -122.476520812684)
13246 187614 2 168 100 Castro St 11 5 1 2       3x3   6002192.0 2107639.0 37.767298794762 -122.43569238083799 (37.767298794762, -122.435692380838)
13247 187613 2 168 100 Castro St 10 5 1 2       3x3   6002192.0 2107639.0 37.767298794762 -122.43569238083799 (37.767298794762, -122.435692380838)
13248 187615 2 168 100 Castro St 12 5 1 2       3x3   6002192.0 2107639.0 37.767298794762 -122.43569238083799 (37.767298794762, -122.435692380838)
13249 187612 2 168 100 Castro St 1 5 1 2       3x3   6002192.0 2107639.0 37.767298794762 -122.43569238083799 (37.767298794762, -122.435692380838)
12731 38212 1 168 108 Wayland St 1 1 1 1 1 07/17/1998 12:00:00 AM 8 3x3 Permit Number 40335 6011170.868009999 2092548.53605 37.726369572089894 -122.403573737557 (37.7263695720899, -122.403573737557)
18537 17028 1 168 1140 Oak St 1 1 1 1     12 3X3   6001519.83997 2109777.5071900003 37.7731324020756 -122.438170492981 (37.7731324020756, -122.438170492981)
182029 234858 2 168 115 Winfield St 1 1 1 1     9 Width 2ft   6007085.582140001 2098738.0087099997 37.743135459435 -122.41813502591002 (37.743135459435, -122.41813502591)
19579 17029 1 168 1153 Oak St 1 1 1 1     12 3X3   6001512.0667 2109715.9891 37.772963046680395 -122.438192973878 (37.7729630466804, -122.438192973878)
17619 17030 1 168 1159 Oak St 1 1 1 1     12 3X3   6001449.2469 2109707.3473 37.772935745446404 -122.438409655481 (37.7729357454464, -122.438409655481)
182921 234863 2 168 116 Winfield St 1 1 1 1     10 Width 3ft   6007043.4928 2098718.4405900002 37.7430793606347 -122.418279172852 (37.7430793606347, -122.418279172852)
171566 234855 2 168 118 Andover St 1 1 1 1     7 Width 3ft   6007577.520219999 2098081.02135 37.7413591949664 -122.41638750560301 (37.7413591949664, -122.416387505603)
61982 234857 2 168 125 Winfield St 1 1 1 1     8 Width 2ft   6007057.29918 2098677.05689 37.74296650740129 -122.418228500567 (37.7429665074013, -122.418228500567)
33293 186732 2 168 1250 Sunset Blvd 1 9 1 1     1 Width 0ft   5984876.9467 2106397.7058 37.762891830958296 -122.49549023544701 (37.7628918309583, -122.495490235447)
62788 186734 2 168 1250 Sunset Blvd 3 9 1 1     1 Width 0ft   5984876.1357 2106411.4914 37.7629296348625 -122.495494057173 (37.7629296348625, -122.495494057173)
43734 184345 2 168 1251 Sunset Blvd 17 9 1 1     1 Width 0ft   5984653.0421 2106395.6187 37.7628729870585 -122.496264477961 (37.7628729870585, -122.496264477961)
185748 212847 2 168 1269 02nd Ave 2 1 1 1     6 Width 3ft   5995455.86214 2106863.98273 37.7647858787024 -122.45893544780701 (37.7647858787024, -122.458935447807)
55292 234854 2 168 130 Andover St 1 1 1 1     5 Width 3ft   6007573.33331 2098019.6233599996 37.7411903742509 -122.41639763464799 (37.7411903742509, -122.416397634648)
169930 184767 2 168 1301 Sunset Blvd 24 9 1 1     1 Width 0ft   5984672.982999999 2106076.3882 37.7619976377511 -122.496171956525 (37.7619976377511, -122.496171956525)
171989 184772 2 168 1301 Sunset Blvd 32 9 1 1     1 Width 0ft   5984713.9927 2106010.1272 37.7618181056778 -122.49602523353201 (37.7618181056778, -122.496025233532)
65840 97111 1 168 1345 Noriega St 2 1 1 1     1   Permit Number 18860 5989755.1906 2103082.2788 37.754072995002204 -122.47837582871401 (37.7540729950022, -122.478375828714)
91939 122722 2 168 1385 Natoma St 1 1 1 1     6 3x3   6007219.0 2107431.0 37.76701193031621 -122.41828991357599 (37.7670119303162, -122.418289913576)
28979 181504 2 168 1400 Sunset Blvd 65 9 1 1     1 Width 0ft   5984912.3363 2105486.7577 37.76039269442371 -122.49530065358499 (37.7603926944237, -122.495300653585)
38450 181510 2 168 1400 Sunset Blvd 70 9 1 1     1 Width 0ft   5984861.096 2105522.4031 37.7604875665076 -122.495480496405 (37.7604875665076, -122.495480496405)
50110 181518 2 168 1400 Sunset Blvd 78 9 1 1     1 Width 0ft   5984884.7668 2105589.5167 37.7606732277268 -122.495403580994 (37.7606732277268, -122.495403580994)
28162 186644 2 168 1401 Sunset Blvd 1 9 1 1     1 Width 0ft   5984678.2391 2105602.2274 37.76069603285129 -122.496118794235 (37.7606960328513, -122.496118794235)
60069 186693 2 168 1401 Sunset Blvd 50 9 1 1     1 Width 0ft   5984710.8996 2105238.1471 37.7596982830602 -122.49597897832399 (37.7596982830602, -122.495978978324)
66894 186651 2 168 1401 Sunset Blvd 8 9 1 1     1 Width 0ft   5984693.4179 2105580.4538 37.7606371377004 -122.49606469199 (37.7606371377004, -122.49606469199)
69316 186690 2 168 1401 Sunset Blvd 47 9 1 1     1 Width 0ft   5984746.4911 2105269.5514 37.759786595015704 -122.495858203478 (37.7597865950157, -122.495858203478)
185531 186659 2 168 1401 Sunset Blvd 16 9 1 1     1 Width 0ft   5984689.126 2105565.0657 37.7605946348949 -122.49607840021002 (37.7605946348949, -122.49607840021)
13160 91380 3 168 1421 Taraval St 1 1 1 2   02/19/2015 01:27:00 PM 3 3x3 Permit Number 52077 5988771.9062 2098963.627 37.742707136361105 -122.48147460973699 (37.7427071363611, -122.481474609737)
53954 47883 1 168 1422 45th Ave 1 1 1 1 1 02/11/2006 12:00:00 AM 5   Permit Number 45630 5982178.8025 2105387.2339 37.7599590039895 -122.504747143589 (37.7599590039895, -122.504747143589)
161191 184192 2 168 1426 38th Ave 1 1 1 1     7 Width 0ft   5984302.3594 2105559.8646 37.7605576926871 -122.497415645594 (37.7605576926871, -122.497415645594)
60903 135662 2 168 1430 Francisco St 2 1 1 1     4 Width 3ft   6004430.55292 2120513.3454 37.802775426403606 -122.42886748667101 (37.8027754264036, -122.428867486671)
49392 49889 1 168 1430@ OCTAVIA Francisco St 1 1 1 1 1 07/01/2003 12:00:00 AM 6   Permit Number 46660 6004450.34869 2120515.08924 37.8027813349583 -122.42879910759599 (37.8027813349583, -122.428799107596)
10804 93408 3 168 1440 Taraval St 1 1 1 2   02/19/2015 03:17:00 PM 3 3x3   5988695.7955 2099025.5303 37.7428726808967 -122.48174230877899 (37.7428726808967, -122.481742308779)
52703 234862 2 168 147 Andover St 1 1 1 1     7 Width 3ft   6007596.66098 2097957.46338 37.741021008521 -122.41631257406 (37.741021008521, -122.41631257406)
160567 139412 2 168 1500 GEARY BLVD 12 1 1 1     9 Width 0ft   6004126.3357 2114029.8613 37.784956209303395 -122.429457598073 (37.7849562093034, -122.429457598073)
173730 186617 2 168 1501 Sunset Blvd 88 9 1 1     1 Width 0ft   5984770.9865 2104379.1354 37.757343195198004 -122.495707807467 (37.757343195198, -122.495707807467)
56749 234865 2 168 152 Beaver St 1 9 1 1     8 Width 1ft   6001951.81755 2106805.77476 37.7649973174046 -122.43646349341299 (37.7649973174046, -122.436463493413)
96882 55827 1 168 154 11th Ave 1 1 1 1   03/09/1973 12:00:00 AM 10 3x3 Permit Number 11876 5992447.89997 2114435.52315 37.785401918703606 -122.469890426632 (37.7854019187036, -122.469890426632)
90439 8411 3 168 1570 Geary Blvd 4 1 1 2     18 3X3   6004211.027185 2114032.026709 37.7849669496355 -122.42916474711001 (37.7849669496355, -122.42916474711)
85518 8412 3 168 1590X Geary Blvd 1 1 1 2     18 3X3   6004120.4992681 2114020.0804586997 37.784929023116796 -122.429477092496 (37.7849290231168, -122.429477092496)
145761 8413 3 168 1590X Geary Blvd 2 1 1 2     18 3X3   6004120.4992681 2114020.0804586997 37.784929023116796 -122.429477092496 (37.7849290231168, -122.429477092496)
76142 234859 2 168 160 Carnelian Way 1 23 1 1     8     6000570.21064 2100519.3738 37.7476577875765 -122.44079113720801 (37.7476577875765, -122.440791137208)
150305 234860 2 168 160 Carnelian Way 2 23 1 1     6     6000574.359 2100517.55086 37.7476530184698 -122.44077666170799 (37.7476530184698, -122.440776661708)
188608 139128 2 168 1601 POST ST 3 1 1 1     4 Width 0ft   6004473.6733 2114291.0091 37.7856929151772 -122.428274539531 (37.7856929151772, -122.428274539531)
24600 234864 2 168 161 Beaver St 1 9 1 1     6 Width 3ft   6001880.22394 2106835.6082900004 37.7650751645184 -122.43671325313998 (37.7650751645184, -122.43671325314)
42841 178684 2 168 161 Delta St 2 1 1 1     1 Width 3ft   6009805.30528 2088917.07553 37.716321963062 -122.40803845872401 (37.716321963062, -122.408038458724)
58090 178683 2 168 161 Delta St 1 1 1 1     1 Width 3ft   6009800.07713 2088901.3026400001 37.7162783612237 -122.408055418121 (37.7162783612237, -122.408055418121)
93139 18222 3 168 1643X Post St 5 1 1 2   01/02/1991 12:00:00 AM 6 3X3   6004309.242075901 2114268.2781924 37.7856211964399 -122.428841803498 (37.7856211964399, -122.428841803498)
21894 17095 1 168 1661 Oak St 1 1 1 1     6 3X3   5999030.0966 2109360.6125 37.7718458009941 -122.446752800648 (37.7718458009941, -122.446752800648)
103208 18224 3 168 1675 Post St 1 1 1 2     12 3X3   6004164.0306229 2114246.6470389 37.7855535827521 -122.429342650039 (37.7855535827521, -122.429342650039)
39854 55830 1 168 170 11th Ave 1 1 1 1   03/09/1973 12:00:00 AM 7   Permit Number 11879 5992452.285209999 2114337.35562 37.7851326311765 -122.469868105299 (37.7851326311765, -122.469868105299)
58154 195951 2 168 1700 Bancroft Ave 12 9 1 1     2 Width 10ft   6013796.32813 2092612.6576200002 37.7266919421623 -122.39450206474 (37.7266919421623, -122.39450206474)
154226 195949 2 168 1700 Bancroft Ave 7 9 1 1     2 Width 10ft   6013845.649730001 2092576.4103400002 37.72659515624 -122.394329023477 (37.72659515624, -122.394329023477)
171830 195952 2 168 1700 Bancroft Ave 14 9 1 1     1 Width 10ft   6013787.58166 2092619.66724 37.7267107029201 -122.39453279185801 (37.7267107029201, -122.394532791858)
183634 195950 2 168 1700 Bancroft Ave 9 9 1 1     1 Width 10ft   6013817.51149 2092596.07971 37.726647600184 -122.394427673718 (37.726647600184, -122.394427673718)
23297 17101 3 168 1711 Oak St 1 1 1 2     8 3X3   5998684.4523 2109317.8876 37.771708738288105 -122.447945326623 (37.7717087382881, -122.447945326623)
11867 93415 3 168 1716 Taraval St 1 1 1 2   03/23/2015 06:26:00 PM 3 3x3   5987861.1638 2098998.3872 37.7427495822889 -122.48462620565901 (37.7427495822889, -122.484626205659)
11729 93414 3 168 1722 Taraval St 1 1 1 2   02/19/2015 03:10:00 PM 3 3x3   5987827.66 2098999.0640000002 37.7427494893985 -122.484742100445 (37.7427494893985, -122.484742100445)
150054 139139 2 168 1730 GEARY BLVD 2 1 1 1     10 Width 0ft   6003434.4937 2113953.4325 37.784707160370296 -122.43184568933998 (37.7847071603703, -122.43184568934)
2062 8436 1 168 1730 Geary Blvd 3 1 1 1   05/28/1997 12:00:00 AM 11 3X3   6003412.8094 2113950.8814 37.784698926436796 -122.431920527552 (37.7846989264368, -122.431920527552)
8545 8434 1 168 1730 Geary Blvd 1 1 1 1   05/28/1997 12:00:00 AM 12 3X3   6003465.1068 2113959.1725 37.784724656301705 -122.4317401882 (37.7847246563017, -122.4317401882)
68838 106982 3 168 1737-1795 Post St 1 1 1 2     10     6003656.2329 2114175.7467 37.7853301466286 -122.431094418652 (37.7853301466286, -122.431094418652)
20032 17103 1 168 1745 Oak St 1 1 1 1     12 3X3   5998656.2538 2109314.8969 37.7716989147196 -122.44804265122801 (37.7716989147196, -122.448042651228)
83387 23889 3 168 1750X Geary Blvd 6 1 1 2     18 3X3   6003201.67908 2113890.07748 37.7845200030062 -122.43264662292299 (37.7845200030062, -122.432646622923)
127916 23888 3 168 1750X Geary Blvd 5 1 1 2     18 3X3   6003201.67908 2113890.07748 37.7845200030062 -122.43264662292299 (37.7845200030062, -122.432646622923)
56065 139135 2 168 1825 POST ST 6 1 1 1     8 Width 0ft   6003465.1068 2114153.0556 37.785257010462 -122.43175403601299 (37.785257010462, -122.431754036013)
148492 139132 2 168 1825 POST ST 3 1 1 1     7 Width 0ft   6003396.2273 2114143.489 37.7852268383201 -122.431991654473 (37.7852268383201, -122.431991654473)
153017 139131 2 168 1825 POST ST 1 1 1 1     18 Width 0ft   6003318.4189 2114130.7336 37.78518740379629 -122.432259936138 (37.7851874037963, -122.432259936138)
6315 18251 1 168 1825 Post St 2 1 1 1     12 3X3   6003359.8742 2114137.1113 37.7852072657709 -122.432116969328 (37.7852072657709, -122.432116969328)
93885 18250 3 168 1825 Post St 1 1 1 2     12 3X3   6003354.45468 2114131.31985 37.7851910566456 -122.432135305453 (37.7851910566456, -122.432135305453)
120388 93418 3 168 1850 TARAVAL ST 2 1 1 2   02/19/2015 01:30:00 PM 3 3x3   5987496.0 2098972.0 37.742655857366294 -122.485886885578 (37.7426558573663, -122.485886885578)
95995 18257 1 168 1855 Post St 1 1 1 1     18 3x3   6003300.7323900005 2114129.45265 37.785182883793794 -122.432321034429 (37.7851828837938, -122.432321034429)
122318 18258 1 168 1855 Post St 2 1 1 1     12 3x3   6003321.44909 2114132.20192 37.785191607243206 -122.43224955752501 (37.7851916072432, -122.432249557525)
146776 139148 2 168 1865 POST ST 1 1 1 1     8 Width 0ft   6003273.137 2114121.8047 37.7851603197126 -122.43241595943 (37.7851603197126, -122.43241595943)
179998 139149 2 168 1865 POST ST 2 1 1 1     9 Width 0ft   6003298.6479 2114126.9069 37.7851757756125 -122.43232806423201 (37.7851757756125, -122.432328064232)
97218 122540 2 168 188 Winfield St 1 9 1 1     20 3x3   6006859.0 2098426.0 37.742265997424504 -122.418896364118 (37.7422659974245, -122.418896364118)
27987 139151 2 168 1881 POST ST 2 1 1 1     6 Width 0ft   6003144.9445 2114104.5849 37.7851057685851 -122.43285823467801 (37.7851057685851, -122.432858234678)
30095 139152 2 168 1881 POST ST 3 1 1 1     8 Width 0ft   6003164.7154 2114107.1359 37.7851138943196 -122.432790015912 (37.7851138943196, -122.432790015912)
49412 139153 2 168 1881 POST ST 4 1 1 1     10 Width 0ft   6003212.5485 2114113.5137 37.785134118902 -122.432624984211 (37.785134118902, -122.432624984211)
148476 139150 2 168 1881 POST ST 1 1 1 1     9 Width 0ft   6003125.8113 2114100.7582 37.785094176231105 -122.432924156018 (37.7850941762311, -122.432924156018)
174573 139154 2 168 1881 POST ST 5 1 1 1     7 Width 0ft   6003238.0594 2114116.0648 37.7851425702811 -122.432536906804 (37.7851425702811, -122.432536906804)
87801 18262 1 168 1895X Post St 1 1 1 1     12 3x3   6003118.209290001 2114097.1727299998 37.785083900253 -122.43295020031799 (37.785083900253, -122.432950200318)
91862 18263 1 168 1895X Post St 2 1 1 1     12 3X3   6003138.05675 2114098.29377 37.7850881040741 -122.43288161451599 (37.7850881040741, -122.432881614516)
92742 18267 1 168 1895X Post St 6 1 1 1     12 3X3   6003219.29534 2114110.16008 37.785125293322295 -122.432601402633 (37.7851252933223, -122.432601402633)
98507 18266 1 168 1895X Post St 5 1 1 1     12 3X3   6003196.88425 2114105.80464 37.7851120634301 -122.43267862671301 (37.7851120634301, -122.432678626713)
114048 18265 3 168 1895X Post St 4 1 1 2     12 3X3   6003117.8494065 2114102.4449837 37.785098356117004 -122.432951822199 (37.785098356117, -122.432951822199)
115725 18264 1 168 1895X Post St 3 1 1 1     12 3X3   6003157.167280001 2114102.73742 37.785101389107496 -122.432815815695 (37.7851013891075, -122.432815815695)
118975 18268 1 168 1895X Post St 7 1 1 1     12 3X3   6003251.63015 2114115.07604 37.7851406249551 -122.43248988562401 (37.7851406249551, -122.432489885624)
73670 135656 2 168 1920 Beach St 3 9 1 1     5 Width 6ft   6001020.2424800005 2121027.2609 37.8039928872331 -122.440705754666 (37.8039928872331, -122.440705754666)
186707 244545 2 168 1921 Oak St 1 1 1 1     7 Width 0ft   5997768.4306 2109193.5582 37.771314959230295 -122.45110492040001 (37.7713149592303, -122.4511049204)
21215 17119 1 168 1931 Oak St 1 1 1 1     18 3X3   5997738.0959 2109188.8584 37.7713003179936 -122.451209509969 (37.7713003179936, -122.451209509969)
17827 17125 1 168 1967 Oak St 1 1 1 1     3 3x3   5997619.3207 2109172.1957 37.7712477652106 -122.451619154414 (37.7712477652106, -122.451619154414)
26992 212838 2 168 200 Thrift St 3 9 1 1     1 Width 3ft   5994980.89281 2089655.7396 37.717509000710294 -122.45933194993299 (37.7175090007103, -122.459331949933)
69092 212837 2 168 200 Thrift St 1 9 1 1     2 Width 3ft   5995022.27605 2089654.8730900001 37.717509000709995 -122.459188845314 (37.71750900071, -122.459188845314)
10782 93456 3 168 2039 Taraval St 1 1 1 2   02/19/2015 01:33:00 PM 3 3x3   5986815.2712 2098896.6914 37.7424093879903 -122.488235084702 (37.7424093879903, -122.488235084702)
19296 17136 1 168 2041 Oak St 1 1 1 1     6 3X3   5997241.2054 2109118.3624 37.7710782917307 -122.45292317759301 (37.7710782917307, -122.452923177593)
18858 17137 1 168 2045 Oak St 1 1 1 1     6 3X3   5997217.7067 2109114.9444 37.7710675601361 -122.453004213188 (37.7710675601361, -122.453004213188)
11200 93423 3 168 2048 Taraval St 2 1 1 2   01/20/2015 12:49:00 PM 3 3x3   5986826.7775 2098962.0068 37.7425893979873 -122.488200098519 (37.7425893979873, -122.488200098519)
Powered by Datasette · Query took 3.197ms · Data source: data.sfgov.org