sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5254 253839 3 16 94 Cortland Ave 1 1 1 2       3x3   6006239.0 2097690.0 37.740210176126794 -122.42098789234 (37.7402101761268, -122.42098789234)
4158 253614 2 16 1959x Polk St 1 1 1 1       3x3   6006418.0 2117595.0 37.794874677003605 -122.421782481899 (37.7948746770036, -122.421782481899)
3523 253474 4 16 134 Lunado Way 1 9 1 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
3548 253473 2 16 134 Lunado Way 2 1 1 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
3541 253472 2 16 134 Lunado Way 1 1 1 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
2651 253156 1 16 654 Hampshire St 1 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 40826 6010070.0 2105228.0 37.7611230643779 -122.40827330718099 (37.7611230643779, -122.408273307181)
1670 251646 2 16 132 Shipley St 3 1 1 1       3x3   6011949.0 2112390.0 37.7808933270361 -122.40227818697599 (37.7808933270361, -122.402278186976)
1663 251645 2 16 132 Shipley St 2 1 1 1       3x3   6011949.0 2112390.0 37.7808933270361 -122.40227818697599 (37.7808933270361, -122.402278186976)
1677 251644 2 16 132 Shipley St 1 1 1 1       3x3   6011949.0 2112390.0 37.7808933270361 -122.40227818697599 (37.7808933270361, -122.402278186976)
186216 250997 2 16 415 44th Ave 1 4 1 1     5 Width 3ft   5982186.75835 2112941.64621 37.7807016980586 -122.505279538125 (37.7807016980586, -122.505279538125)
30707 250995 2 16 453 44th Ave 2 4 1 1     5 Width 3ft   5982194.00965 2112744.27477 37.780160200984604 -122.505239820464 (37.7801602009846, -122.505239820464)
69256 250924 2 16 279 28th Ave 1 2 1 1     7 Width 4ft   5987109.1755800005 2114089.0974 37.7841406875769 -122.488335102104 (37.7841406875769, -122.488335102104)
41962 250796 2 16 290 31st Ave 2 2 1 1     5 Width 4ft   5986226.25026 2113990.91468 37.7838195522695 -122.49138243596201 (37.7838195522695, -122.491382435962)
168487 250795 2 16 290 31st Ave 1 2 1 1     5 Width 4ft   5986226.21568 2113977.7713599997 37.7837834624768 -122.491381587892 (37.7837834624768, -122.491381587892)
40407 250787 2 16 277 32nd Ave 1 4 1 1     2 Width 3ft   5985873.31121 2114054.8468299997 37.7839744613866 -122.49260816604601 (37.7839744613866, -122.492608166046)
134897 250785 2 16 270 32nd Ave 1 4 1 1     5 Width 3ft   5985911.734180001 2114095.33531 37.784087877591794 -122.492478221206 (37.7840878775918, -122.492478221206)
66286 250757 2 16 206 32nd Ave 1 4 1 1     8 Width 3ft   5985901.09635 2114492.32613 37.785177277657496 -122.492544270121 (37.7851772776575, -122.492544270121)
27269 250005 2 16 232 Filbert St 3 17 1 1     8 Width 0ft   6011493.8796 2120090.77159 37.802012393927 -122.404394879735 (37.802012393927, -122.404394879735)
159690 249982 2 16 224 Filbert St 3 7 1 1     12 Width 0ft   6011639.74764 2120113.25639 37.8020822820333 -122.403891687471 (37.8020822820333, -122.403891687471)
173495 249974 2 16 28 Napier Ln 1 7 1 1     18 Width 0ft   6011652.50252 2120258.9240099997 37.802482962378704 -122.403857805517 (37.8024829623787, -122.403857805517)
159363 249970 2 16 213 Filbert St 1 13 1 1     31 Width 0ft   6011737.037830001 2120086.51138 37.802014281606205 -122.403553132272 (37.8020142816062, -122.403553132272)
28833 249969 2 16 213 Filbert St 2 13 1 1     28 Width 0ft   6011730.79134 2120085.86253 37.802012151107704 -122.403574702535 (37.8020121511077, -122.403574702535)
182162 249963 2 16 271 Filbert St 1 7 1 1     10 Width 0ft   6011592.60874 2120072.38059 37.8019674134157 -122.404051933175 (37.8019674134157, -122.404051933175)
76837 249945 2 16 325 Filbert St 1 7 1 1     24 Width 0ft   6011292.48387 2120026.50548 37.8018246784261 -122.40508728037399 (37.8018246784261, -122.405087280374)
184115 249937 2 16 339 Filbert St 2 7 1 1     7 Width 0ft   6011248.56733 2120031.66705 37.8018363956996 -122.405239616532 (37.8018363956996, -122.405239616532)
116481 249933 2 16 345 Filbert St 2 7 1 1     7 Width 0ft   6011225.47356 2120026.31802 37.801820417444 -122.405319155254 (37.801820417444, -122.405319155254)
58002 249931 2 16 345 Filbert St 5 4 1 1     5 Width 0ft   6011214.74621 2120016.06231 37.801791658008106 -122.405355554416 (37.8017916580081, -122.405355554416)
51583 249891 2 16 230 Greenwich St 27 13 1 1     15 Width 0ft   6011455.072819999 2120426.06234 37.8029308517393 -122.404552786308 (37.8029308517393, -122.404552786308)
37934 249882 2 16 230 Greenwich St 18 13 1 1     27 Width 0ft   6011509.072430001 2120419.3733099997 37.8029155030083 -122.40436544761499 (37.8029155030083, -122.404365447615)
171246 249875 2 16 230 Greenwich St 11 13 1 1     19 Width 0ft   6011656.00691 2120465.5569700003 37.803050521838706 -122.40386022737499 (37.8030505218387, -122.403860227375)
131807 249873 2 16 230 Greenwich St 9 13 1 1     26 Width 0ft   6011670.78297 2120474.23594 37.8030751776447 -122.403809705266 (37.8030751776447, -122.403809705266)
71454 249847 2 16 289 Greenwich St 4 17 1 1     5 Width 0ft   6011426.79495 2120392.20909 37.8028363185975 -122.40464825831002 (37.8028363185975, -122.40464825831)
63079 249835 2 16 333 Greenwich St 3 7 1 1     10 Width 0ft   6011233.03828 2120380.52255 37.8027933993566 -122.40531793578 (37.8027933993566, -122.40531793578)
35676 249834 2 16 333 Greenwich St 2 7 1 1     9 Width 0ft   6011234.1519 2120371.9476900003 37.8027699171526 -122.40531347785401 (37.8027699171526, -122.405313477854)
39263 249833 2 16 333 Greenwich St 1 7 1 1     7 Width 0ft   6011234.89731 2120366.37397 37.8027546547576 -122.40531050560101 (37.8027546547576, -122.405310505601)
30309 249829 2 16 339 Greenwich St 2 7 1 1     5 Width 0ft   6011201.84726 2120367.04696 37.802754654775704 -122.405424923615 (37.8027546547757, -122.405424923615)
52205 249810 2 16 258 Chestnut St 9 13 1 1     5 Width 0ft   6010696.08755 2121019.21593 37.804517058874396 -122.407221117962 (37.8045170588744, -122.407221117962)
169417 249809 2 16 258 Chestnut St 8 13 1 1     5 Width 0ft   6010708.4562800005 2121025.2354099997 37.804534279087704 -122.407178739215 (37.8045342790877, -122.407178739215)
156801 249808 2 16 258 Chestnut St 7 13 1 1     12 Width 0ft   6010714.23144 2121016.75548 37.80451131849129 -122.40715815553101 (37.8045113184913, -122.407158155531)
53839 249807 2 16 258 Chestnut St 6 13 1 1     7 Width 0ft   6010752.11734 2121021.55825 37.8045266258517 -122.407027386026 (37.8045266258517, -122.407027386026)
184038 249689 2 16 2400 Baker St 21 7 1 1     8     5999718.81935 2117298.99939 37.7936818775552 -122.444941227873 (37.7936818775552, -122.444941227873)
33070 249679 2 16 2400 Baker St 11 7 1 1     8     5999741.43988 2117216.47572 37.793456580320395 -122.44485702433998 (37.7934565803204, -122.44485702434)
187086 249631 2 16 2498 Golden Gate Ave 3 9 1 1     1 Width 10ft   5997554.63334 2111312.07091 37.777119603925904 -122.451997320318 (37.7771196039259, -122.451997320318)
176069 249630 2 16 2498 Golden Gate Ave 2 9 1 1     1 Width 10ft   5997562.87533 2111313.0970900003 37.7771228936381 -122.45196888287701 (37.7771228936381, -122.451968882877)
183103 249629 2 16 2498 Golden Gate Ave 1 9 1 1     1 Width 10ft   5997572.14406 2111315.29965 37.7771294721856 -122.45193697852501 (37.7771294721856, -122.451936978525)
178716 249411 2 16 70 Olive St 1 4 1 1     6 Width 3ft   6007136.98967 2113833.35507 37.7845866470086 -122.41902773346202 (37.7845866470086, -122.419027733462)
183270 248616 2 16 448 Frederick St 2 1 1 1     4 Width 0ft   5997602.0932 2107487.0642 37.7666198391012 -122.45155717513501 (37.7666198391012, -122.451557175135)
185190 248612 2 16 841 Shrader St 1 1 1 1     7 Width 0ft   5997643.278 2107552.7781 37.7668026311269 -122.45141946492201 (37.7668026311269, -122.451419464922)
23619 248592 2 16 825 Shrader St 1 1 1 1     7 Width 0ft   5997630.862000001 2107647.8664 37.7670630083716 -122.45146926878701 (37.7670630083716, -122.451469268787)
54247 248582 2 16 382 Frederick St 1 1 1 1     4 Width 0ft   5998128.2588 2107558.6832 37.7668466041125 -122.44974242989201 (37.7668466041125, -122.449742429892)
173548 248552 2 16 798 Ashbury St 1 1 1 1     6 Width 0ft   5999120.7811 2107716.3058 37.7673361311337 -122.44632081075599 (37.7673361311337, -122.446320810756)
64955 248519 2 16 216 Frederick St 1 1 1 1     2 Width 0ft   5998904.7125 2107666.4904 37.7671870080394 -122.447064573316 (37.7671870080394, -122.447064573316)
186881 248500 2 16 69 Downey St 1 1 1 1     1 Width 0ft   5998823.4029 2107855.6071 37.767701628786995 -122.44735942334499 (37.767701628787, -122.447359423345)
129738 248486 2 16 72 Downey St 1 1 1 1     5 Width 0ft   5998851.7174 2107848.7935 37.767684538298 -122.447260996941 (37.767684538298, -122.447260996941)
148708 248485 2 16 771 Ashbury St 5 1 1 1     4 Width 0ft   5999070.9657 2107769.7551 37.767480044221294 -122.44649696031799 (37.7674800442213, -122.446496960318)
150965 248463 2 16 130 Beulah St 2 1 1 1     6 Width 0ft   5997448.7103 2107810.4856 37.7674990867904 -122.452111034778 (37.7674990867904, -122.452111034778)
407 248462 1 16 130 Beulah St 1 1 1 1     9 Width 0ft Permit Number 779787 5997458.097999999 2107812.3026 37.767504613553 -122.45207869525 (37.767504613553, -122.45207869525)
154130 248393 2 16 9 Downey St 1 1 1 1     6 Width 0ft   5998787.6691 2108112.7090000003 37.768405523514296 -122.447501530188 (37.7684055235143, -122.447501530188)
74444 248368 2 16 714 Ashbury St 2 1 1 1     6 Width 0ft   5999058.3983 2108160.556 37.7685523669565 -122.446568548976 (37.7685523669565, -122.446568548976)
64092 248265 2 16 152 Lundy's Ln 1 1 1 1     3 Width 1ft   6006675.61536 2098670.66738 37.742927471437504 -122.41954780781201 (37.7429274714375, -122.419547807812)
32768 248178 2 16 218 Esmeralda Ave 7 17 1 1     5     6007415.21428 2098671.9184 37.7429725382626 -122.416990561277 (37.7429725382626, -122.416990561277)
130050 248147 2 16 9 Massasoit St 1 1 1 1     7 Width 3ft   6010067.447980001 2099317.93989 37.744895209655795 -122.407865368018 (37.7448952096558, -122.407865368018)
32496 248112 2 16 108 Brewster St 2 17 1 1     8     6010381.20708 2099441.9489 37.745253272029096 -122.406789179892 (37.7452532720291, -122.406789179892)
68171 248071 2 16 378 Holladay Ave 1 1 1 1     9 Width 3ft   6010484.06828 2098878.7944400003 37.743712727062395 -122.40639382801399 (37.7437127270624, -122.406393828014)
156969 248056 2 16 17 Rutledge St 2 17 1 1     6     6010671.1144 2099351.76088 37.7450218521921 -122.405780372559 (37.7450218521921, -122.405780372559)
180928 248055 2 16 17 Rutledge St 1 17 1 1     8     6010658.86611 2099354.83953 37.745029620524605 -122.405822941986 (37.7450296205246, -122.405822941986)
23934 248050 2 16 38 Rutledge St 7 17 1 1     5     6010496.13368 2099436.61391 37.7452450531093 -122.406391405264 (37.7452450531093, -122.406391405264)
30408 248049 2 16 38 Rutledge St 6 17 1 1     8     6010499.7614 2099438.0486 37.7452491953942 -122.40637896223 (37.7452491953942, -122.40637896223)
64801 248042 2 16 43 Rutledge St 2 7 1 1     6     6010523.22894 2099409.2799 37.745171515566796 -122.40629578842301 (37.7451715155668, -122.406295788423)
32465 248037 2 16 55 Rutledge St 1 7 1 1     8     6010488.35763 2099431.59018 37.745230824035204 -122.40641793974599 (37.7452308240352, -122.406417939746)
74729 247959 2 16 12 Joy St 1 7 1 1     12     6010396.832769999 2098907.5359799997 37.743786764640795 -122.40669749401 (37.7437867646408, -122.40669749401)
168699 247958 2 16 10 Joy St 1 7 1 1     11     6010403.29697 2098902.73698 37.7437739492996 -122.406674804102 (37.7437739492996, -122.406674804102)
123929 247956 2 16 6 Joy St 2 7 1 1     8     6010454.452819999 2098883.02488 37.7437226861619 -122.40649652970501 (37.7437226861619, -122.406496529705)
3513 247938 4 16 29 Joy St 1 14 1 2     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056)
164280 247909 2 16 582 Esmeralda Ave 7 17 1 1     5     6009857.303669999 2098747.94229 37.743318353655 -122.408551810625 (37.743318353655, -122.408551810625)
156569 247882 2 16 387 Mayflower St 3 17 1 1     9     6009927.8842 2098400.72535 37.7423689240761 -122.40828327575701 (37.7423689240761, -122.408283275757)
164589 247503 2 16 330 Pierce St 1 1 1 1     5 Width 0ft   6002742.369 2109736.1981 37.7730884309626 -122.433938658377 (37.7730884309626, -122.433938658377)
159815 247496 2 16 537 Steiner St 2 1 1 1     1 Width 0ft   6003128.6225 2110147.2235 37.77423891724071 -122.432631925087 (37.7742389172407, -122.432631925087)
174709 247456 2 16 356 Pierce St 1 1 1 1     10 Width 0ft   6002732.951 2109802.6473 37.773270349556896 -122.43397598715 (37.7732703495569, -122.43397598715)
46528 247319 2 16 212 Pierce St 1 1 1 1     2 Width 0ft   6002805.2257 2109276.6136 37.77183009226471 -122.43368837642299 (37.7718300922647, -122.433688376423)
35997 247303 2 16 871 Page St 1 1 1 1     3 Width 0ft   6002435.7685 2109501.3624 37.772426226241606 -122.434982428911 (37.7724262262416, -122.434982428911)
160110 247064 2 16 636 30th St 2 2 1 1     4 Width 3ft   6002451.51604 2098273.39283 37.7415978111813 -122.434125164359 (37.7415978111813, -122.434125164359)
154255 247009 2 16 401 Valley St 9 17 1 1     13 Width 8ft   6003278.48209 2099193.13161 37.744170100676996 -122.431331435716 (37.744170100677, -122.431331435716)
46005 246996 2 16 41 Clipper St 1 4 1 1     13 Width 3ft   6004880.21483 2101034.21529 37.7493159377957 -122.425924019088 (37.7493159377957, -122.425924019088)
168274 246994 2 16 55 Clipper St 2 4 1 1     12 Width 3ft   6004800.19369 2101026.04405 37.7492889788029 -122.426200152341 (37.7492889788029, -122.426200152341)
30439 246993 2 16 55 Clipper St 1 4 1 1     13 Width 3ft   6004785.89781 2101026.3383400002 37.7492889788082 -122.426249608749 (37.7492889788082, -122.426249608749)
50431 246992 2 16 65 Clipper St 1 4 1 1     15 Width 3ft   6004752.26844 2101024.33311 37.749281571994 -122.426365757074 (37.749281571994, -122.426365757074)
172356 246991 2 16 79 Clipper St 1 4 1 1     16 Width 4ft   6004668.56115 2101021.3093 37.7492685372183 -122.426655003321 (37.7492685372183, -122.426655003321)
175965 246989 2 16 74 Clipper St 1 4 1 1     10 Width 3ft   6004681.91881 2101068.44983 37.749398729370206 -122.426612168643 (37.7493987293702, -122.426612168643)
158089 246988 2 16 70 Clipper St 2 4 1 1     9 Width 3ft   6004704.08454 2101068.9613099997 37.7494013868777 -122.426535555381 (37.7494013868777, -122.426535555381)
186480 246987 2 16 70 Clipper St 1 4 1 1     11 Width 3ft   6004726.23458 2101068.69852 37.749401917482295 -122.426458941248 (37.7494019174823, -122.426458941248)
1681 246983 2 16 38 Clipper St 2 1 1 1     10 Width 4ft Permit Number 779954 6004884.234759999 2101078.02552 37.7494364577399 -122.42591323621201 (37.7494364577399, -122.425913236212)
184567 246981 2 16 34 Clipper St 1 1 1 1     9 Width 3ft   6004919.80069 2101078.0678 37.7494385837369 -122.42579025121799 (37.7494385837369, -122.425790251218)
69227 246948 2 16 205 Frederick St 4 1 1 1     7 Width 3ft   5999042.02587 2107640.28149 37.767122889331 -122.446587742626 (37.767122889331, -122.446587742626)
39987 246947 2 16 205 Frederick St 3 1 1 1     9 Width 3ft   5999023.6641 2107638.02914 37.7671156560985 -122.44665109090201 (37.7671156560985, -122.446651090902)
159282 246946 2 16 205 Frederick St 2 1 1 1     9 Width 3ft   5999004.098730001 2107636.61215 37.7671106477653 -122.446718662333 (37.7671106477653, -122.446718662333)
169180 246945 2 16 205 Frederick St 1 1 1 1     10 Width 3ft   5998978.56709 2107632.07739 37.767096737951604 -122.446806645734 (37.7670967379516, -122.446806645734)
37687 246944 2 16 231 Frederick St 1 1 1 1     3 Width 3ft   5998938.52144 2107624.39933 37.76707336817729 -122.446944604433 (37.7670733681773, -122.446944604433)
180618 246943 2 16 241 Frederick St 1 4 1 1     3 Width 3ft   5998908.7474 2107621.37145 37.7670633533234 -122.44704736995199 (37.7670633533234, -122.447047369952)
131862 246936 2 16 301 Frederick St 1 4 1 1     3 Width 3ft   5998506.42404 2107565.9164400003 37.7668880934274 -122.448434944726 (37.7668880934274, -122.448434944726)
147659 246915 2 16 453 Frederick St 2 4 1 1     7 Width 3ft   5997627.7084 2107444.25662 37.7665037672476 -122.451465489148 (37.7665037672476, -122.451465489148)
Powered by Datasette · Query took 39.87ms · Data source: data.sfgov.org