sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
124086 3 3 168 2X 12th Ave 2 11 1 2     3 16   5992095.57585 2114853.19204 37.7865283500331 -122.471139790973 (37.7865283500331, -122.471139790973)
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)
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)
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)
22735 16395 1 168 299X Myrtle St 1 1 1 1   01/15/1990 12:00:00 AM 6 3X3   6006070.4864 2114008.23449 37.7850067086413 -122.42272991225201 (37.7850067086413, -122.422729912252)
22586 16396 1 168 299X Myrtle St 2 1 1 1   01/15/1990 12:00:00 AM 6 3X3   6006093.31996 2114011.54372 37.7850170832184 -122.422651150523 (37.7850170832184, -122.422651150523)
22771 16397 1 168 299X Myrtle St 3 1 1 1   01/15/1990 12:00:00 AM 6 3X3   6006110.1202 2114012.78935 37.785021451230705 -122.422593115487 (37.7850214512307, -122.422593115487)
22581 16398 1 168 299X Myrtle St 4 1 1 1   01/15/1990 12:00:00 AM 6 3X3   6006124.74935 2114015.2727900003 37.7850290954547 -122.422542679726 (37.7850290954547, -122.422542679726)
19523 16915 1 168 484 Oak St 1 1 1 1     6 3X3   6004711.24143 2110219.61063 37.7745272991249 -122.42716251506 (37.7745272991249, -122.42716251506)
22104 16924 1 168 508 Oak St 1 1 1 1   04/13/2005 12:00:00 AM 12 3X4   6004451.24438 2110184.3203 37.774415694158 -122.42805938013399 (37.774415694158, -122.428059380134)
22233 16926 3 168 514 Oak St 1 5 1 2     18 3X3   6004391.58115 2110176.00513 37.774389487009 -122.42826517381201 (37.774389487009, -122.428265173812)
17530 16968 1 168 767 Oak St 1 1 1 1     12 3X3   6003330.7652 2109962.2092 37.7737423751934 -122.431919463762 (37.7737423751934, -122.431919463762)
22112 17000 1 168 940 Oak St 1 1 1 1     12 3X3   6002487.5182 2109913.8953 37.77356187754221 -122.43483292856399 (37.7735618775422, -122.434832928564)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
63888 30697 1 168 240 Lily St 1 1 1 1 1 01/31/1995 12:00:00 AM 3   Permit Number 34612 6005370.1769 2110115.0914 37.774277555648496 -122.42487568971599 (37.7742775556485, -122.424875689716)
24985 30698 1 168 240 Lily St 2 1 1 1 1 01/31/1995 12:00:00 AM 6   Permit Number 34612 6005345.2585 2110114.4836 37.7742744792738 -122.42496184383499 (37.7742744792738, -122.424961843835)
71601 30699 1 168 240 Lily St 3 1 1 1 1 01/31/1995 12:00:00 AM 3   Permit Number 34612 6005328.8488 2110110.837 37.7742635396666 -122.425018348522 (37.7742635396666, -122.425018348522)
71138 30700 1 168 240 Lily St 4 1 1 1 1 01/31/1995 12:00:00 AM 5   Permit Number 34612 6005310.6159 2110107.7982 37.7742541659126 -122.425081203232 (37.7742541659126, -122.425081203232)
60571 30701 1 168 241 Lily St 1 1 1 1 1 01/31/1995 12:00:00 AM 4   Permit Number 34613 6005368.9614 2110093.8196 37.7742190797874 -122.42487838067 (37.7742190797874, -122.42487838067)
178980 35843 1 168 425 Paris St 1 1 1 1 1 04/23/1998 12:00:00 AM 13   Permit Number 39070 6002146.05039 2091115.78994 37.721927328560206 -122.434669664286 (37.7219273285602, -122.434669664286)
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)
72690 39956 1 168 370 Teddy Ave 1 1 1 1 1 01/25/1999 12:00:00 AM 7   Permit Number 41218 6009202.76969 2088674.77745 37.7156229083553 -122.41010402697901 (37.7156229083553, -122.410104026979)
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)
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)
59264 52753 1 168 59@ ROLPH Newton St 1 1 1 1 1 10/06/2006 12:00:00 AM 7   Permit Number 48796 6000913.35841 2088160.63266 37.713743072553 -122.438719109114 (37.713743072553, -122.438719109114)
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)
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)
43887 72500 2 168 2311 Taraval St 3 1 1 1 1 08/10/1996 12:00:00 AM 1     5986050.4379 2098869.9561 37.7422913280707 -122.49087764471001 (37.7422913280707, -122.49087764471)
29077 91140 1 168 342 21st Ave 1 1 1 1   01/26/2009 12:00:00 AM 1 3x3 Permit Number 52025 5989366.26045 2113048.7976 37.7814157473958 -122.48045031235 (37.7814157473958, -122.48045031235)
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)
101836 92072 1 168 3001 Pacific Ave   5 2 1   06/18/2009 12:00:00 AM     Permit Number 52188 5999733.7 2116663.4 37.791937538515604 -122.444844029888 (37.7919375385156, -122.444844029888)
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)
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)
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)
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)
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)
11519 93424 3 168 2100 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986662.1353 2098956.0844 37.7425635298153 -122.488768940253 (37.7425635298153, -122.488768940253)
12101 93425 3 168 2122 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986588.0209 2098955.4076 37.7425573460454 -122.489025152899 (37.7425573460454, -122.489025152899)
10611 93426 3 168 2150 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986519.4905 2098952.531 37.7425454476092 -122.489261896232 (37.7425454476092, -122.489261896232)
10492 93427 3 168 2150 Taraval St 3 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986487.6789 2098952.531 37.7425435906318 -122.48937188989099 (37.7425435906318, -122.489371889891)
10956 93428 3 168 2222 Taraval St 1 1 1 2   02/19/2015 01:36:00 PM 3 3x3   5986281.7492 2098944.9165 37.7425106597816 -122.490083364444 (37.7425106597816, -122.490083364444)
89147 93429 3 168 2222 Taraval St 2 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986343.0 2098927.0 37.742465042516706 -122.489870262796 (37.7424650425167, -122.489870262796)
11256 93430 3 168 2226 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986248.2454 2098943.2244 37.742504057158996 -122.490199084637 (37.742504057159, -122.490199084637)
11010 93431 3 168 2240 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986207.6348 2098941.1939 37.742496110202296 -122.49033935278798 (37.7424961102023, -122.490339352788)
11014 93432 3 168 2244 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986188.6832 2098942.886 37.7424996493843 -122.49040500535 (37.7424996493843, -122.49040500535)
13132 93433 3 168 2306 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986025.3947 2098937.9789 37.7424766373979 -122.490969239699 (37.7424766373979, -122.490969239699)
10945 93434 3 168 2300 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986059.5753 2098939.671 37.742483280315 -122.490851179477 (37.742483280315, -122.490851179477)
11158 93435 3 168 2302 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5986039.9468 2098937.3019999997 37.742475628974205 -122.490918873767 (37.7424756289742, -122.490918873767)
10303 93436 3 168 2404 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5985728.5988 2098924.1036 37.7424211954642 -122.491994435754 (37.7424211954642, -122.491994435754)
10719 93437 3 168 2408 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5985715.4003 2098924.442 37.7424213531218 -122.492040096469 (37.7424213531218, -122.492040096469)
11517 93438 3 168 2414 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5985694.7566 2098925.7957 37.7424238632874 -122.492111574827 (37.7424238632874, -122.492111574827)
11253 93439 3 168 2545 Taraval St 1 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5985279.5976 2098843.1362 37.7421726252091 -122.49354096012199 (37.7421726252091, -122.493540960122)
127772 93440 3 168 2545 Taraval St 2 1 1 2   02/20/2009 12:00:00 AM 3 3x3   5985345.0 2098863.0 37.7422309915573 -122.49331628538499 (37.7422309915573, -122.493316285385)
11939 93441 3 168 2453 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5985552.0272 2098851.9351 37.7422127174882 -122.492599644801 (37.7422127174882, -122.492599644801)
122182 93442 3 168 2441 TARAVAL ST 1 1 1 2   02/19/2015 01:39:00 PM 3 3x3   5985592.0 2098836.3 37.742172124856204 -122.49246028206998 (37.7421721248562, -122.49246028207)
12982 93443 3 168 2409 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5985719.2076 2098858.0267 37.742239217096795 -122.492022043353 (37.7422392170968, -122.492022043353)
12625 93444 3 168 2401 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5985736.1286 2098858.7036 37.74224206476121 -122.491963586408 (37.7422420647612, -122.491963586408)
101570 93445 3 168 2343 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5985970.8 2098880.2 37.7423148023054 -122.49115375806299 (37.7423148023054, -122.491153758063)
11156 93446 3 168 2343 Taraval St 2 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5985872.427999999 2098863.1876 37.7422623426363 -122.491492641715 (37.7422623426363, -122.491492641715)
12449 93447 3 168 2337 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5985896.456 2098863.5261 37.742264676187 -122.491409586353 (37.742264676187, -122.491409586353)
143362 93448 3 168 2319X Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986046.0 2098887.0 37.7423378667916 -122.490894243278 (37.7423378667916, -122.490894243278)
70845 93449 3 168 2301x Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986031.0 2098812.3 37.7421318842811 -122.490940612353 (37.7421318842811, -122.490940612353)
12231 93450 3 168 2239 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986205.0967 2098876.0477 37.7423170879313 -122.49034333731599 (37.7423170879313, -122.490343337316)
12217 93451 3 168 2239 Taraval St 2 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986220.3256 2098876.0477 37.742317977353395 -122.490290681149 (37.7423179773534, -122.490290681149)
12150 93452 3 168 2149 Taraval St 1 1 1 2   01/03/2015 01:35:00 PM 3 3x3   5986481.2489 2098884.5082 37.742356442825105 -122.489389122116 (37.7423564428251, -122.489389122116)
12074 93453 3 168 2139 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986521.8595 2098886.5388 37.7423643889255 -122.489248854134 (37.7423643889255, -122.489248854134)
12949 93454 3 168 2109 Taraval St 1 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986642.3376 2098891.6151 37.742385358930996 -122.488832656 (37.742385358931, -122.488832656)
12639 93455 3 168 2109 Taraval St 2 1 1 2   02/23/2009 12:00:00 AM 3 3x3   5986657.5666 2098892.2919 37.7423881059963 -122.488780049158 (37.7423881059963, -122.488780049158)
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)
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)
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)
112954 109113 1 168 3301x 19TH ST 2 1 1 1   08/02/2016 12:00:00 AM 3 3x3 Permit Number 778467 6007480.0 2104949.0 37.760211624256 -122.41721125604201 (37.760211624256, -122.417211256042)
96576 115405 4 168 2050 43RD AVE 1 5 1 1   01/29/2016 12:00:00 AM 3 3x3   5982969.0 2101168.0 37.7484206232379 -122.50170211889 (37.7484206232379, -122.50170211889)
57195 117697 2 168 4049 Clement St 2 9 1 1     3 Width 7ft   5982884.20475 2113074.25287 37.781106811569295 -122.50287659442301 (37.7811068115693, -122.502876594423)
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)
Powered by Datasette · Query took 3.519ms · Data source: data.sfgov.org