sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
27303 129201 2 19 245 Marina Blvd 3 9 1 1     11 Width 4ft   6002306.14505 2121870.94259 37.8063825585658 -122.43631622670799 (37.8063825585658, -122.436316226708)
39856 129108 2 19 155 Retiro Way 2 1 1 1     5 Width 3ft   6001855.64531 2121684.5263400003 37.805845102121296 -122.43786189781 (37.8058451021213, -122.43786189781)
59790 129202 2 19 1425 Jefferson St 3 4 1 1     16 Width 2ft   6002378.47119 2121561.31201 37.8055365042628 -122.436043759126 (37.8055365042628, -122.436043759126)
174867 129183 2 19 3751 Broderick St 3 9 1 1     13 Width 6ft   5999581.37766 2121479.41464 37.8051523345622 -122.445717560421 (37.8051523345622, -122.445717560421)
183710 129184 2 19 3751 Broderick St 5 9 1 1     11 Width 6ft   5999584.03647 2121469.20578 37.805124455597 -122.445707624701 (37.805124455597, -122.445707624701)
28788 129185 2 19 3751 Broderick St 6 9 1 1     7 Width 6ft   5999586.95971 2121459.2161 37.8050971935371 -122.445696789672 (37.8050971935371, -122.445696789672)
64054 129186 2 19 3751 Broderick St 8 9 1 1     5 Width 6ft   5999587.90115 2121446.76461 37.8050630588636 -122.445692635729 (37.8050630588636, -122.445692635729)
151282 129146 2 19 1800 Jefferson St 1 9 1 1     5 Width 3ft   6000571.83923 2121374.34413 37.8049203391516 -122.44228241100001 (37.8049203391516, -122.442282411)
35455 129147 2 19 1800 Jefferson St 4 9 1 1     6 Width 3ft   6000543.90951 2121371.39176 37.8049106408804 -122.442378852499 (37.8049106408804, -122.442378852499)
187049 129148 2 19 1800 Jefferson St 5 9 1 1     5 Width 3ft   6000531.19503 2121369.13302 37.8049037142981 -122.442422689958 (37.8049037142981, -122.442422689958)
170371 129149 2 19 1800 Jefferson St 8 9 1 1     6 Width 3ft   6000512.40261 2121367.00013 37.80489678681129 -122.44248756976201 (37.8048967868113, -122.442487569762)
149850 129342 2 19 2550 Leavenworth St 8 9 1 1     8 Width 1ft   6007469.878409999 2121230.31772 37.804915607819204 -122.418400712649 (37.8049156078192, -122.418400712649)
28808 129341 2 19 2550 Leavenworth St 6 9 1 1     4 Width 1ft   6007472.08384 2121212.09706 37.80486570266171 -122.418391787764 (37.8048657026617, -122.418391787764)
185201 129340 2 19 2550 Leavenworth St 5 9 1 1     5 Width 1ft   6007472.2942699995 2121203.00534 37.8048407509518 -122.418390414501 (37.8048407509518, -122.418390414501)
37364 129125 2 19 3750 Divisadero St 3 9 1 1     5 Width 2ft   6000188.47224 2121175.57148 37.8043527059816 -122.44359480245501 (37.8043527059816, -122.443594802455)
167978 129126 2 19 3750 Divisadero St 2 9 1 1     5 Width 2ft   6000189.7805 2121161.41053 37.804313898432206 -122.443589257237 (37.8043138984322, -122.443589257237)
151827 129189 2 19 3725 Scott St 1 4 1 1     17 Width 2ft   6000608.31446 2121159.56549 37.8043326933704 -122.44214075790701 (37.8043326933704, -122.442140757907)
133392 68011 1 19 2550 Leavenworth St 1 1 1 1   04/21/1993 12:00:00 AM 4   Permit Number 31741 6007478.84194 2121154.66744 37.8047083959278 -122.41836432607501 (37.8047083959278, -122.418364326075)
136378 129127 2 19 3740 Divisadero St 3 9 1 1     8 Width 2ft   6000190.96403 2121152.26738 37.8042888612987 -122.44358450433998 (37.8042888612987, -122.44358450434)
67190 129128 2 19 3740 Divisadero St 2 9 1 1     8 Width 2ft   6000191.73272 2121145.1845299997 37.804269457536 -122.443581335121 (37.804269457536, -122.443581335121)
59064 129190 2 19 3725 Scott St 2 4 1 1     11 Width 2ft   6000610.9168300005 2121141.44631 37.8042830912635 -122.44213045078699 (37.8042830912635, -122.442130450787)
59190 129129 2 19 3740 Divisadero St 1 9 1 1     8 Width 2ft   6000192.65427 2121134.45107 37.8042400388971 -122.44357737451901 (37.8042400388971, -122.443577374519)
176649 129200 2 19 3688 Fillmore St 3 4 1 1     12 Width 1ft   6002139.18705 2121127.02263 37.8043304639385 -122.436840724815 (37.8043304639385, -122.436840724815)
65634 129199 2 19 3688 Fillmore St 1 4 1 1     9 Width 1ft   6002142.29562 2121107.7471 37.8042777151067 -122.436828586663 (37.8042777151067, -122.436828586663)
74421 129130 2 19 3718 Divisadero St 2 9 1 1     8 Width 2ft   6000197.85447 2121076.2118900004 37.8040804263317 -122.443555192722 (37.8040804263317, -122.443555192722)
134405 62997 1 19 3718 Divisadero St 1 1 1 1   09/11/2015 12:00:00 AM 6   Permit Number 776580 6000198.89461 2121071.17508 37.8040666559246 -122.443551231218 (37.8040666559246, -122.443551231218)
178710 129150 2 19 1900 Beach St 1 9 1 1     8 Width 2ft   6001109.3535400005 2121039.25511 37.8040308943727 -122.44039824138599 (37.8040308943727, -122.440398241386)
164071 129151 2 19 1900 Beach St 2 9 1 1     8 Width 2ft   6001092.13272 2121036.64706 37.8040227528229 -122.440457647901 (37.8040227528229, -122.440457647901)
66746 129152 2 19 1900 Beach St 4 9 1 1     8 Width 2ft   6001067.53983 2121033.31935 37.8040122154669 -122.44054251423799 (37.8040122154669, -122.440542514238)
186233 129153 2 19 1900 Beach St 5 9 1 1     7 Width 2ft   6001047.32787 2121030.07538 37.8040021574489 -122.44061222609699 (37.8040021574489, -122.440612226097)
26965 66051 1 19 1632 North Point St 1 1 1 1   07/31/1990 12:00:00 AM 12   Permit Number 29090 6002925.71156 2121006.29112 37.8040436368686 -122.434110258988 (37.8040436368686, -122.434110258988)
157817 129204 2 19 3661 Buchanan St 1 9 1 1     6 Width 3ft   6003066.15854 2120964.22459 37.803936103130106 -122.43362122476101 (37.8039361031301, -122.433621224761)
4190 100829 2 19 1601X North Point St 2 1 1 1     12 3x3   6003036.60353 2120959.36193 37.803921074561295 -122.43372315391198 (37.8039210745613, -122.433723153912)
8375 100825 2 19 3661 Buchanan St 2 1 1 1     12 3x3   6003069.70231 2120954.84645 37.803910554290795 -122.43360829069401 (37.8039105542908, -122.433608290694)
156299 129205 2 19 3661 Buchanan St 5 9 1 1     6 Width 3ft   6003070.24764 2120944.99181 37.8038835269778 -122.433605698837 (37.8038835269778, -122.433605698837)
156772 129206 2 19 3661 Buchanan St 6 9 1 1     6 Width 3ft   6003071.01563 2120936.8701299997 37.8038612705514 -122.433602460379 (37.8038612705514, -122.433602460379)
38472 129194 2 19 85 Cervantes Blvd 2 9 1 1     6 Width 1ft   6001552.51444 2120931.86169 37.8037612434571 -122.438856955397 (37.8037612434571, -122.438856955397)
156042 129195 2 19 85 Cervantes Blvd 3 9 1 1     8 Width 1ft   6001565.25504 2120922.94686 37.803737490546105 -122.438812226714 (37.8037374905461, -122.438812226714)
37637 129196 2 19 75 Cervantes Blvd 1 4 1 1     10 Width 2ft   6001591.38038 2120905.5251 37.8036911413025 -122.438720569603 (37.8036911413025, -122.438720569603)
45702 129197 2 19 75 Cervantes Blvd 2 4 1 1     5 Width 2ft   6001606.6144900005 2120894.2374 37.8036610149183 -122.43866704197501 (37.8036610149183, -122.438667041975)
186571 129120 2 19 3632 Fillmore St 3 4 1 1     3 Width 3ft   6002190.78069 2120762.93266 37.803333701254296 -122.43663610388201 (37.8033337012543, -122.436636103882)
62195 84689 2 19 3632 Fillmore St 1 1 1 1 1   3     6002195.05393 2120739.39081 37.80326930438871 -122.436619630107 (37.8032693043887, -122.436619630107)
46533 129358 2 19 2431 Jones St 20 9 1 1     5 Width 3ft   6007962.785209999 2120702.9106099997 37.8034952158822 -122.41665756479799 (37.8034952158822, -122.416657564798)
35741 129306 2 19 1081 Francisco St 2 9 1 1     4 Width 10ft   6006156.05151 2120698.06699 37.8033801368411 -122.42290950959101 (37.8033801368411, -122.422909509591)
169759 129359 2 19 2431 Jones St 21 9 1 1     5 Width 3ft   6007962.685269999 2120698.0317700002 37.8034818141966 -122.41665756481702 (37.8034818141966, -122.416657564817)
52974 129305 2 19 1081 Francisco St 1 9 1 1     5 Width 10ft   6006148.36265 2120696.43143 37.8033752121629 -122.422936000907 (37.8033752121629, -122.422936000907)
65642 129304 2 19 1101 Francisco St 2 9 1 1     4 Width 2ft   6005981.054409999 2120675.3317400003 37.8033078358583 -122.423513477178 (37.8033078358583, -122.423513477178)
145227 129303 2 19 1101 Francisco St 1 9 1 1     3 Width 2ft   6005974.10733 2120674.6115 37.8033054661475 -122.423537466584 (37.8033054661475, -122.423537466584)
163925 129203 2 19 3501 Webster St 1 9 1 1     6 Width 3ft   6002631.88282 2120622.79983 37.802973990429294 -122.43509962745001 (37.8029739904293, -122.43509962745)
265 109354 2 19 900x Chestnut St 1 5 1 1     6 5x45   6007474.1784 2120601.5824599997 37.803189502164294 -122.418341225173 (37.8031895021643, -122.418341225173)
24884 109356 2 19 900x Chestnut St 3 5 1 1     11 5x45   6007464.49344 2120601.01033 37.8031873860571 -122.41837469975 (37.8031873860571, -122.41837469975)
173674 109355 2 19 900x Chestnut St 2 5 1 1     12 5x45   6007469.51339 2120600.5219 37.8031863275346 -122.41835729337299 (37.8031863275346, -122.418357293373)
71497 109357 2 19 900x Chestnut St 4 5 1 1     9 5x45   6007459.04695 2120599.58062 37.8031831538387 -122.41839344609801 (37.8031831538387, -122.418393446098)
48049 109359 2 19 900x Chestnut St 6 5 1 1     8 5x45   6007452.06537 2120598.7604799997 37.8031805089269 -122.41841754792802 (37.8031805089269, -122.418417547928)
171997 109358 2 19 900x Chestnut St 5 5 1 1     7 5x45   6007454.77295 2120598.70497 37.8031805089291 -122.41840817430901 (37.8031805089291, -122.418408174309)
147679 109360 2 19 900x Chestnut St 7 5 1 1     6 5x45   6007448.76613 2120598.25036 37.803178922540205 -122.418428928878 (37.8031789225402, -122.418428928878)
70565 109362 2 19 900x Chestnut St 9 5 1 1     7 5x45   6007443.52896 2120597.58705 37.8031768064372 -122.41844700523701 (37.8031768064372, -122.418447005237)
155176 109361 2 19 900x Chestnut St 8 5 1 1     8 5x45   6007445.84949 2120597.53947 37.803176806427004 -122.418438971581 (37.803176806427, -122.418438971581)
75911 109363 2 19 900x Chestnut St 10 5 1 1     6 5x45   6007417.13772 2120593.69695 37.8031646394947 -122.418538057081 (37.8031646394947, -122.418538057081)
36896 129318 2 19 900 Chestnut St 11 9 1 1     6 Width 5ft   6007412.87531 2120593.39917 37.8031635819044 -122.418552786177 (37.8031635819044, -122.418552786177)
186852 129319 2 19 900 Chestnut St 12 9 1 1     5 Width 5ft   6007409.37859 2120592.7001799997 37.8031614657978 -122.41856483710698 (37.8031614657978, -122.418564837107)
149482 129320 2 19 900 Chestnut St 13 9 1 1     7 Width 5ft   6007405.89372 2120592.57904 37.8031609369869 -122.41857688803002 (37.8031609369869, -122.41857688803)
129688 129131 2 19 3542 Divisadero St 2 9 1 1     5 Width 2ft   6000280.24975 2120491.13146 37.8024786510429 -122.443228011273 (37.8024786510429, -122.443228011273)
135513 129132 2 19 3542 Divisadero St 1 9 1 1     5 Width 2ft   6000281.80115 2120477.64903 37.8024417203612 -122.443221673766 (37.8024417203612, -122.443221673766)
75728 129145 2 19 2399 North Point St 11 9 1 1     10 Width 6ft   5999381.832219999 2120449.61925 37.8023133997084 -122.446333981843 (37.8023133997084, -122.446333981843)
133496 129144 2 19 2399 North Point St 8 9 1 1     5 Width 6ft   5999344.27548 2120444.47832 37.8022971390685 -122.44646357594499 (37.8022971390685, -122.446463575945)
33330 129143 2 19 2399 North Point St 6 9 1 1     5 Width 6ft   5999331.215369999 2120442.50933 37.8022909867986 -122.44650862838199 (37.8022909867986, -122.446508628382)
60331 129142 2 19 2399 North Point St 4 9 1 1     4 Width 6ft   5999327.82814 2120441.93946 37.802289228618 -122.44652030878099 (37.802289228618, -122.446520308781)
173057 129141 2 19 2399 North Point St 3 9 1 1     3 Width 6ft   5999324.440909999 2120441.3696 37.8022874704637 -122.44653198918002 (37.8022874704637, -122.44653198918)
54485 129140 2 19 2399 North Point St 1 9 1 1     5 Width 6ft   5999315.42401 2120440.5968400002 37.8022848336387 -122.44656313629801 (37.8022848336387, -122.446563136298)
59101 129187 2 19 3445 Broderick St 1 4 1 1     6 Width 2ft   5999729.19027 2120417.1315599997 37.8022440296095 -122.44512962056001 (37.8022440296095, -122.44512962056)
135341 129188 2 19 3445 Broderick St 2 4 1 1     4 Width 2ft   5999731.06738 2120400.48948 37.80219844206879 -122.44512192772899 (37.8021984420688, -122.445121927729)
67509 129357 2 19 1181 Chestnut St 3 9 1 1     4 Width 2ft   6006225.24006 2120361.15088 37.8024589549865 -122.422646123319 (37.8024589549865, -122.422646123319)
164147 129198 2 19 3537 Fillmore St 2 4 1 1     8 Width 2ft   6002132.11244 2120360.66499 37.8022258462139 -122.436810313348 (37.8022258462139, -122.436810313348)
174140 49714 1 19 1181@ POLK Chestnut St 1 1 1 1 1 06/03/2003 12:00:00 AM 5   Permit Number 46526 6006207.33741 2120358.03247 37.8024493825888 -122.422707853704 (37.8024493825888, -122.422707853704)
166896 129317 2 19 2644 Larkin St 3 9 1 1     4 Width 3ft   6006616.02783 2120357.98991 37.8024723152946 -122.421293577158 (37.8024723152946, -122.421293577158)
136076 129316 2 19 2644 Larkin St 2 9 1 1     6 Width 3ft   6006618.63379 2120343.47812 37.802432616528 -122.42128352811599 (37.802432616528, -122.421283528116)
175803 129354 3 19 1306x Montgomery St 52 3 1 2     14 Width 8ft   6011388.89614 2120338.61388 37.8026870410416 -122.40477563290199 (37.8026870410416, -122.404775632902)
75147 129353 3 19 1306x Montgomery St 51 3 1 2     6 Width 8ft   6011391.406830001 2120329.06369 37.8026609588854 -122.404766271855 (37.8026609588854, -122.404766271855)
185888 129338 2 19 928 Lombard St 1 9 1 1     6 Width 5ft   6007904.15055 2120316.35403 37.802430530998 -122.41683307021098 (37.802430530998, -122.416833070211)
69391 129339 2 19 928 Lombard St 2 9 1 1     5 Width 3ft   6007894.75128 2120315.04124 37.802426397722 -122.416865503351 (37.802426397722, -122.416865503351)
163136 129352 3 19 1306x Montgomery St 45 3 1 2     3 Width 8ft   6011406.69978 2120255.02893 37.8024585322873 -122.404708135188 (37.8024585322873, -122.404708135188)
27010 61931 1 19 1407 Montgomery St 1 1 1 1   04/11/1985 12:00:00 AM 11   Permit Number 21986 6011381.98525 2120211.6051 37.8023379197065 -122.404790601229 (37.8023379197065, -122.404790601229)
53748 129347 2 19 1407 Montgomery St 2 9 1 1     8 Width 3ft   6011383.96992 2120196.49956 37.802296554515 -122.404782669181 (37.802296554515, -122.404782669181)
151655 129180 2 19 3298 Lyon St 8 9 1 1     15     5998992.55112 2120173.79871 37.8015338304744 -122.447661212108 (37.8015338304744, -122.447661212108)
154652 129351 3 19 1306x Montgomery St 39 3 1 2     1 Width 8ft   6011425.67929 2120161.57643 37.8022029953207 -122.404635873741 (37.8022029953207, -122.404635873741)
188832 129179 2 19 3298 Lyon St 6 9 1 1     13     5998993.68481 2120160.70419 37.801497941247895 -122.44765634587601 (37.8014979412479, -122.447656345876)
26942 129350 3 19 1306x Montgomery St 38 3 1 2     1 Width 8ft   6011425.50986 2120159.17711 37.8021963979046 -122.404636291051 (37.8021963979046, -122.404636291051)
188999 129349 3 19 1306x Montgomery St 35 3 1 2     2 Width 8ft   6011426.64663 2120143.89656 37.8021545047788 -122.40463128093398 (37.8021545047788, -122.404631280934)
27490 129348 3 19 1306x Montgomery St 33 3 1 2     2 Width 8ft   6011427.80927 2120135.82348 37.802132403051 -122.404626688974 (37.802132403051, -122.404626688974)
138216 129178 2 19 3298 Lyon St 4 9 1 1     11     5998998.34734 2120131.24528 37.801417321497794 -122.447638089651 (37.8014173214978, -122.447638089651)
149522 129337 2 19 2240 Leavenworth St 3 9 1 1     4 Width 2ft   6007623.973619999 2120107.6373799997 37.8018416845956 -122.41778782015301 (37.8018416845956, -122.417787820153)
62291 129336 2 19 2240 Leavenworth St 2 9 1 1     3 Width 2ft   6007624.53894 2120096.3685 37.8018107749031 -122.417785064649 (37.8018107749031, -122.417785064649)
95182 16377 3 19 1400X Montgomery St 10 11 1 2     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508)
6044 107491 3 19 1306x Montgomery St 20 11 1 2     8     6011446.048280001 2119975.7461599996 37.8016938891322 -122.40455229795 (37.8016938891322, -122.40455229795)
175305 129291 2 19 1351 Lombard St 2 9 1 1     19 Width 7ft   6005939.01276 2119972.76765 37.8013764014559 -122.423608983393 (37.8013764014559, -122.423608983393)
32280 129119 2 19 1114 Greenwich St 3 17 1 1     18     6007553.05086 2119913.7987599997 37.8013054611424 -122.418019497203 (37.8013054611424, -122.418019497203)
35098 142469 2 19 548 VARENNES ST 1 1 1 1     5 Width 0ft   6010746.4928 2119899.9648 37.8014466914345 -122.40696774883999 (37.8014466914345, -122.40696774884)
74501 129333 2 19 1101 Greenwich St 12 7 1 1     1     6007566.1830400005 2119864.34532 37.8011704135381 -122.417970546228 (37.8011704135381, -122.417970546228)
31573 129332 2 19 1101 Greenwich St 10 7 1 1     1     6007563.684280001 2119863.77685 37.8011687120311 -122.417979152724 (37.8011687120311, -122.417979152724)
179802 129331 2 19 1101 Greenwich St 9 7 1 1     2     6007561.62509 2119863.3782 37.8011675015458 -122.41798625015899 (37.8011675015458, -122.417986250159)
Powered by Datasette · Query took 14.181ms · Data source: data.sfgov.org