sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3410 55823 1 110 107 11th Ave 1 1 1 1   03/09/1973 12:00:00 AM 9   Permit Number 11871 5992391.10091 2114722.33212 37.7861861336889 -122.470107824331 (37.7861861336889, -122.470107824331)
27575 52011 1 110 427 38th Ave 1 1 1 1     10   Permit Number 48229 5984051.86025 2112939.27176 37.7808047486161 -122.498827177749 (37.7808047486161, -122.498827177749)
30048 132396 2 110 2836 Larkin St 2 17 1 1     40     6006504.32212 2120945.10898 37.804078096188704 -122.421721861273 (37.8040780961887, -122.421721861273)
31588 132395 2 110 2836 Larkin St 1 17 1 1     11     6006513.4872 2120932.40539 37.8040437321931 -122.42168924196999 (37.8040437321931, -122.42168924197)
32833 132402 2 110 93 MacOndray Ln 1 9 1 1     15     6008127.0764 2119094.13477 37.7990871592098 -122.41597503153 (37.7990871592098, -122.41597503153)
33032 247630 2 110 286 Bradford St 5 7 1 1     7     6009492.89578 2096949.07994 37.738358653736206 -122.409684901541 (37.7383586537362, -122.409684901541)
37209 178397 2 110 127 Athens St 1 9 1 1     13     6004928.6124599995 2092474.3613599997 37.7258152443728 -122.42514766493 (37.7258152443728, -122.42514766493)
38844 132391 2 110 2833 Larkin St 2 17 1 1     31     6006489.423769999 2120936.29447 37.8040530536607 -122.421772791676 (37.8040530536607, -122.421772791676)
40834 247628 2 110 286 Bradford St 3 7 1 1     9     6009493.85882 2096962.27736 37.738394944962394 -122.409682503062 (37.7383949449624, -122.409682503062)
41441 247627 2 110 286 Bradford St 2 7 1 1     9     6009494.8200900005 2096968.4162599999 37.7384118549208 -122.40967961262699 (37.7384118549208, -122.409679612627)
46330 178393 2 110 73 Capistrano Ave 2 9 1 1     5     6001400.33163 2093764.0907400001 37.729156597198795 -122.437436967259 (37.7291565971988, -122.437436967259)
46631 132401 2 110 2745 Larkin St 6 9 1 1     9     6006539.0247599995 2120646.9147799998 37.8032612878284 -122.421580578682 (37.8032612878284, -122.421580578682)
46960 132377 2 110 20 Reed St 9 9 1 1     13     6008207.47508 2117062.00893 37.793511965045205 -122.415552871766 (37.7935119650452, -122.415552871766)
48727 30819 3 110 151 Lippard Ave 9 1 1 2   02/06/1995 12:00:00 AM 4   Permit Number 34679 6001850.40599 2095237.97524 37.733229124016496 -122.435986447137 (37.7332291240165, -122.435986447137)
48906 211441 3 110 200x Terrace Dr 27 3 1 2     7     5993812.00301 2096546.48985 37.7363620454614 -122.463872125093 (37.7363620454614, -122.463872125093)
52897 132364 2 110 1 Maple St 1 7 1 1     13     5996506.6886 2116107.7681400003 37.7902272326358 -122.455969252601 (37.7902272326358, -122.455969252601)
57300 132363 2 110 1 Maple St 2 7 1 1     19     5996514.49254 2116105.13934 37.7902204625654 -122.455942061589 (37.7902204625654, -122.455942061589)
57438 62163 1 110 80 Santa Ynez Ave 1 1 1 1 1 09/30/1985 12:00:00 AM 11   Permit Number 22278 6000618.37391 2092117.41472 37.724590715777396 -122.440022226756 (37.7245907157774, -122.440022226756)
57817 132397 2 110 2836 Larkin St 3 17 1 1     16     6006502.73263 2120950.76111 37.804093525861795 -122.42172776352899 (37.8040935258618, -122.421727763529)
58870 132398 2 110 2836 Larkin St 4 17 1 1     6     6006507.37075 2120957.5617299997 37.8041124601724 -122.421712196283 (37.8041124601724, -122.421712196283)
61763 132373 2 110 20 Reed St 4 9 1 1     7     6008208.92851 2117034.44521 37.793436363556204 -122.415545890356 (37.7934363635562, -122.415545890356)
64626 132374 2 110 20 Reed St 5 9 1 1     14     6008210.17068 2117040.38905 37.7934527536983 -122.41554201335899 (37.7934527536983, -122.415542013359)
69854 132400 2 110 2745 Larkin St 3 9 1 1     2     6006513.749919999 2120658.41667 37.8032914438996 -122.421668860656 (37.8032914438996, -122.421668860656)
72084 132393 2 110 2833 Larkin St 4 17 1 1     17     6006475.56322 2120927.38496 37.8040278087899 -122.42182012391001 (37.8040278087899, -122.42182012391)
73279 132378 2 110 20 Reed St 10 9 1 1     14     6008205.50053 2117066.58011 37.7935244053907 -122.415560027676 (37.7935244053907, -122.415560027676)
74152 211439 3 110 200x Terrace Dr 25 3 1 2     10     5993818.11195 2096542.33136 37.7363509793232 -122.46385070234699 (37.7363509793232, -122.463850702347)
74625 211440 3 110 200x Terrace Dr 26 3 1 2     10     5993816.62133 2096536.73465 37.736335526247295 -122.463855449888 (37.7363355262473, -122.463855449888)
75547 132405 2 110 2671 Leavenworth St 3 9 1 1     14     6007317.65081 2121868.01026 37.8066579786473 -122.418972771382 (37.8066579786473, -122.418972771382)
75850 132406 2 110 2671 Leavenworth St 4 9 1 1     25     6007315.11916 2121861.5465700002 37.8066400884465 -122.41898107391701 (37.8066400884465, -122.418981073917)
89513 132372 2 110 20 Reed St 3 9 1 1     8     6008211.08199 2117028.50784 37.793420182046 -122.41553801857401 (37.793420182046, -122.415538018574)
97714 102073 6 110 273 Magellan Ave 3 7 1 1           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194)
100796 64213 1 110 1625 Carroll Ave 1 1 1 1   01/15/1988 12:00:00 AM 5   Permit Number 25004 6013920.481000001 2092092.5018 37.7252706002708 -122.39403647132099 (37.7252706002708, -122.394036471321)
130402 132376 2 110 20 Reed St 7 9 1 1     11     6008205.53038 2117047.83844 37.793472947059605 -122.41555859686001 (37.7934729470596, -122.41555859686)
130704 132394 2 110 2833 Larkin St 5 17 1 1     8     6006476.08021 2120921.35396 37.804011278359205 -122.42181790617599 (37.8040112783592, -122.421817906176)
137876 211442 3 110 200x Terrace Dr 28 3 1 2     10     5993811.3668 2096539.9849900003 37.736344148068106 -122.463873852703 (37.7363441480681, -122.463873852703)
147937 30820 3 110 151 Lippard Ave 8 1 1 2   02/06/1995 12:00:00 AM 7   Permit Number 34679 6001842.2487 2095205.8891900002 37.7331405596841 -122.43601235390601 (37.7331405596841, -122.436012353906)
148064 132371 2 110 20 Reed St 2 9 1 1     12     6008212.2961800005 2117019.5633099996 37.7933956908179 -122.41553318381399 (37.7933956908179, -122.415533183814)
151839 211443 3 110 200x Terrace Dr 29 3 1 2     15     5993804.85557 2096543.20667 37.7363526187711 -122.46389659834601 (37.7363526187711, -122.463896598346)
155205 132370 2 110 20 Reed St 1 9 1 1     14     6008212.89333 2117013.5005900003 37.793379077646996 -122.415530688191 (37.793379077647, -122.415530688191)
155600 247629 2 110 286 Bradford St 4 7 1 1     12     6009493.3855 2096955.4623099999 37.738376205786096 -122.409683658684 (37.7383762057861, -122.409683658684)
155855 132392 2 110 2833 Larkin St 3 17 1 1     16     6006479.362930001 2120932.81603 37.8040429353981 -122.421807360741 (37.8040429353981, -122.421807360741)
162232 211438 3 110 200x Terrace Dr 18 3 1 2     14     5993827.4148 2096523.2728799998 37.736299185562004 -122.463817155848 (37.736299185562, -122.463817155848)
163158 132375 2 110 20 Reed St 6 9 1 1     8     6008208.36982 2117045.10307 37.793465596010996 -122.41554857839701 (37.793465596011, -122.415548578397)
164737 211437 3 110 200x Terrace Dr 13 3 1 2     15     5993819.380340001 2096502.3277900002 37.736241212547796 -122.463843414267 (37.7362412125478, -122.463843414267)
168536 132404 2 110 2671 Leavenworth St 2 9 1 1     14     6007312.64985 2121879.37275 37.806688895542294 -122.418990884623 (37.8066888955423, -122.418990884623)
174774 247626 2 110 286 Bradford St 1 7 1 1     8     6009494.96271 2096975.4044400002 37.7384310509429 -122.40967961262501 (37.7384310509429, -122.409679612625)
177265 132399 2 110 2836 Larkin St 5 17 1 1     12     6006512.34183 2120961.63143 37.8041239148476 -122.421695282708 (37.8041239148476, -122.421695282708)
180543 194589 2 110 11 Bridgeview Way 17 9 1 1     2     6016121.54622 2108188.95403 37.7695902108346 -122.387549998659 (37.7695902108346, -122.387549998659)
188984 132403 2 110 93 MacOndray Ln 4 9 1 1     17     6008160.59399 2119098.20458 37.799100218256704 -122.415859337341 (37.7991002182567, -122.415859337341)
740 26411 3 110 34 Maple St 8 5 1 2     3 10   5996554.84409 2116119.62648 37.7902625562289 -122.45580349675699 (37.7902625562289, -122.455803496757)
4530 26410 3 110 34 Maple St 7 5 1 2     3 10   5996557.377619999 2116117.2149400003 37.790256080189295 -122.455794556583 (37.7902560801893, -122.455794556583)
7571 26412 3 110 34 Maple St 9 5 1 2     3 10   5996536.01908 2116115.1957 37.7902493101054 -122.455868309095 (37.7902493101054, -122.455868309095)
8270 26409 3 110 34 Maple St 6 5 1 2     3 10   5996561.54746 2116120.98746 37.790266677821 -122.45578040214599 (37.790266677821, -122.455780402146)
10558 919 3 110 1249 Alemany Blvd 1 1 1 2   01/19/2016 10:57:00 AM 3 3X3   6002980.09082 2094114.94313 37.730209644839896 -122.432000656304 (37.7302096448399, -122.432000656304)
13893 26015 1 110 1638 Oakdale Ave 1 1 1 1   05/05/1997 12:00:00 AM 3 3X3   6014725.62148 2095748.6278099997 37.7353543002582 -122.391508646128 (37.7353543002582, -122.391508646128)
94154 9335 3 110 179 Gold Mine Dr 1 1 1 2     20 3X3   6000859.3677258 2098666.8406913998 37.742587635250004 -122.439658461234 (37.74258763525, -122.439658461234)
21025 28135 3 110 412 Eugenia Ave 1 1 1 2     8 3X4   6006927.15214 2097902.80661 37.740833262445996 -122.418623621291 (37.740833262446, -122.418623621291)
1188 251477 2 110 1590 Lyon St 1 1 1 1       3x3   5999686.0 2114300.0 37.785445538345996 -122.444839109459 (37.785445538346, -122.444839109459)
1686 251474 2 110 151 32nd Ave 2 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
1694 251475 2 110 151 32nd Ave 3 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
1712 251473 2 110 151 32nd Ave 1 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
77572 81877 1 110 1380 12th Ave 1 1 1 1 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773644 5992433.71699481 2106077.08224854 37.7624510738005 -122.46933088918699 (37.7624510738005, -122.469330889187)
98282 2776 3 110 331 Cabrillo St 1 1 1 2     25 4X4   5994564.223130001 2110735.25562 37.775364081338 -122.462300169147 (37.775364081338, -122.462300169147)
7914 20395 3 110 262X Sunset Blvd 40 1 1 2     12 60            
166409 187083 2 110 2600 Sunset Blvd 19 9 1 1     5 Width 0ft   5985170.5104 2097012.8962 37.7371408955553 -122.49378330233499 (37.7371408955553, -122.493783302335)
170091 200714 2 110 1494 Newcomb Ave 2 1 1 1     6 Width 0ft   6015811.8614 2095290.2381 37.7341558860556 -122.38772110560801 (37.7341558860556, -122.387721105608)
30321 132368 2 110 3100 Lyon St 9 9 1 1     10 Width 10ft   5999060.82328 2119520.3698400003 37.7997435923452 -122.44737790226999 (37.7997435923452, -122.44737790227)
31583 132369 2 110 3100 Lyon St 10 9 1 1     14 Width 10ft   5999059.80174 2119527.5303700003 37.7997631948618 -122.44738195283199 (37.7997631948618, -122.447381952832)
33137 132366 2 110 3100 Lyon St 7 9 1 1     12 Width 10ft   5999060.873319999 2119508.71315 37.7997115890667 -122.44737688965 (37.7997115890667, -122.44737688965)
69840 132367 2 110 3100 Lyon St 8 9 1 1     15 Width 10ft   5999061.27495 2119513.94993 37.7997259908076 -122.44737587699801 (37.7997259908076, -122.447375876998)
33012 211434 2 110 910 Kirkham St 2 1 1 1     7 Width 1ft   5992028.493840001 2105269.75757 37.760210948307794 -122.47067358802299 (37.7602109483078, -122.470673588023)
36060 132385 2 110 1468 Greenwich St 2 9 1 1     7 Width 2ft   6005829.912880001 2119675.1182 37.8005529731893 -122.423965339721 (37.8005529731893, -122.423965339721)
41431 132390 2 110 1468 Greenwich St 7 9 1 1     10 Width 2ft   6005781.1261599995 2119669.33652 37.8005343437344 -122.42413375038099 (37.8005343437344, -122.424133750381)
62614 178399 2 110 339 Athens St 3 9 1 1     8 Width 2ft   6004188.88481 2091298.12563 37.7225437445683 -122.42762108566002 (37.7225437445683, -122.42762108566)
71019 132386 2 110 1468 Greenwich St 3 9 1 1     6 Width 2ft   6005813.32494 2119673.13314 37.8005465862138 -122.42402259955799 (37.8005465862138, -122.424022599558)
77181 132389 2 110 1468 Greenwich St 6 1 1 1     6 Width 2ft   6005789.48501 2119659.27806 37.8005071977157 -122.42410410961901 (37.8005071977157, -122.424104109619)
93214 132388 2 110 1468 Greenwich St 5 9 1 1     5 Width 2ft   6005798.70292 2119672.07683 37.800542860316 -122.424073122581 (37.800542860316, -122.424073122581)
177634 132387 2 110 1468 Greenwich St 4 1 1 1     5 Width 2ft   6005806.0966 2119662.42569 37.8005167781868 -122.424046850703 (37.8005167781868, -122.424046850703)
183127 132384 2 110 1468 Greenwich St 1 1 1 1     8 Width 2ft   6005841.24215 2119667.51872 37.80053274655629 -122.4239255951 (37.8005327465563, -122.4239255951)
185315 132360 2 110 2801 Pierce St 2 9 1 1     6 Width 2ft   6001534.76184 2118041.80057 37.795824887369896 -122.43871117439 (37.7958248873699, -122.43871117439)
3467 123897 2 110 107 11th Ave 2 1 1 1     7 Width 3ft   5992391.187940001 2114716.46428 37.7861700272505 -122.47010709580299 (37.7861700272505, -122.470107095803)
31489 194588 2 110 1998 Revere Ave 9 4 1 1     15 Width 3ft   6013005.4518800005 2095968.5066900002 37.7358624145277 -122.397471367135 (37.7358624145277, -122.397471367135)
31835 120792 2 110 547 21st Ave 1 1 1 1     9 Width 3ft   5989370.9651 2111615.14329 37.777479605996795 -122.48032907033001 (37.7774796059968, -122.48032907033)
32365 233960 2 110 329 Montcalm St 2 1 1 1     11 Width 3ft   6009458.35232 2099567.9895200003 37.7455476723052 -122.409989165578 (37.7455476723052, -122.409989165578)
44666 211448 2 110 4140 19th Ave 2 4 1 1     8 Width 3ft   5992076.26551 2088333.24605 37.7137103255345 -122.46927561890101 (37.7137103255345, -122.469275618901)
48017 178395 2 110 61 Lisbon St 1 1 1 1     8 Width 3ft   6003678.4559 2093041.21797 37.727301003537505 -122.429509772582 (37.7273010035375, -122.429509772582)
62454 233971 2 110 175 Clifford Ter 1 1 1 1     13 Width 3ft   5999325.700119999 2106527.04149 37.7640824109973 -122.44552650036002 (37.7640824109973, -122.44552650036)
64368 249601 2 110 2200 Golden Gate Ave 3 9 1 1     17 Width 3ft   5998898.09787 2111497.4092 37.777705355751294 -122.447363215433 (37.7777053557513, -122.447363215433)
66218 233975 2 110 3786 16th St 1 1 1 1     7 Width 3ft   6001886.12679 2106432.54375 37.76396878345871 -122.43666398285299 (37.7639687834587, -122.436663982853)
70254 122245 2 110 47 Lake St 3 9 1 1     12 Width 3ft   5990779.800559999 2114787.3723 37.7862714344884 -122.47568719317199 (37.7862714344884, -122.475687193172)
130991 211451 2 110 151 Lippard Ave 12 1 1 1     5 Width 3ft   6001863.37782 2095280.7937599998 37.7333474307441 -122.435944662819 (37.7333474307441, -122.435944662819)
132382 132365 2 110 1 Dicha Aly 1 2 1 1     11 Width 3ft   5998327.23711 2113735.99188 37.7838192833694 -122.449499349909 (37.7838192833694, -122.449499349909)
133226 122244 2 110 47 Lake St 4 9 1 1     7 Width 3ft   5990784.64686 2114787.2699700003 37.7862714344765 -122.475670418927 (37.7862714344765, -122.475670418927)
135796 233974 2 110 2315 15th St 1 1 1 1     5 Width 3ft   6002049.59534 2107034.31873 37.7656303987394 -122.436141661111 (37.7656303987394, -122.436141661111)
136421 211445 2 110 1313 Bosworth St 1 1 1 1     7 Width 3ft   6000197.7982 2096452.6133 37.736470213222 -122.441787089628 (37.736470213222, -122.441787089628)
138989 211449 2 110 1554 10th Ave 1 1 1 1     6 Width 3ft   5993091.38036 2104901.42473 37.759261008817 -122.466970818352 (37.759261008817, -122.466970818352)
154786 211435 2 110 29 Madrone Ave 2 1 1 1     4 Width 3ft   5992967.24158 2098952.48262 37.742919578079096 -122.466967656341 (37.7429195780791, -122.466967656341)
160795 211447 2 110 4140 19th Ave 1 4 1 1     8 Width 3ft   5992076.98829 2088316.96105 37.7136656526261 -122.46927193614599 (37.7136656526261, -122.469271936146)
160987 132361 2 110 3455 Washington St 1 1 1 1     4 Width 3ft   5998256.938519999 2115827.3267200002 37.7895575156245 -122.449893326728 (37.7895575156245, -122.449893326728)
167782 233962 2 110 341 Day St 1 1 1 1     6 Width 3ft   6003741.086630001 2098630.21283 37.7426506619089 -122.429691709917 (37.7426506619089, -122.429691709917)
170256 211446 2 110 1313 Bosworth St 1 1 1 1     14 Width 3ft   6000201.81389 2096459.5971 37.736489617908504 -122.441773706798 (37.7364896179085, -122.441773706798)
Powered by Datasette · Query took 3.299ms · Data source: data.sfgov.org