sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
223 23789 3 62 1100X Webster St 4 11 1 2     20 20   6003791.7059 2112684.1999 37.7812424081927 -122.43051925893299 (37.7812424081927, -122.430519258933)
551 1664 3 62 1400X Fell St 5 1 1 2     18 3X3   6000454.8566 2109968.1462 37.7735952220186 -122.441868082855 (37.7735952220186, -122.441868082855)
890 23729 3 62 800X Webster St 4 11 1 2   04/21/2008 12:00:00 AM 3 6   6003943.6522 2111620.2321 37.7783296231018 -122.42991768322901 (37.7783296231018, -122.429917683229)
1473 23922 3 62 1700X Webster St 4 11 1 2   04/21/2008 12:00:00 AM 3 12x1   6003506.5026 2114704.4246 37.786773277055204 -122.431650198179 (37.7867732770552, -122.431650198179)
1529 251578 3 62 1000X Columbus Ave 6 11 1 2                    
1594 4731 3 62 1175X Columbus Ave 2 11 1 2     14 3x3   6007886.219880001 2121257.05551 37.8050124513131 -122.416961809043 (37.8050124513131, -122.416961809043)
1597 4669 3 62 600X Columbus Ave 4 11 1 2   06/25/2014 12:00:00 AM 8 3 Permit Number 769286 6009537.0943 2119751.1708 37.8009703907309 -122.411142309711 (37.8009703907309, -122.411142309711)
1722 23787 3 62 1100X Webster St 2 11 1 2   04/21/2008 12:00:00 AM 3 20   6003801.3315 2112607.883 37.781033406276705 -122.430480512141 (37.7810334062767, -122.430480512141)
1851 4718 3 62 1000X Columbus Ave 5 11 1 2     80 3   6008205.1504 2120957.4944 37.804207866952204 -122.415836885075 (37.8042078669522, -122.415836885075)
1958 23757 3 62 900X Webster St 3 11 1 2     25 20   6003900.3372 2111922.0621 37.7791559204238 -122.43008906318701 (37.7791559204238, -122.430089063187)
2139 23790 3 62 1100X Webster St 5 11 1 2     20 20   6003786.8931 2112715.8268 37.7813289751352 -122.43053816621901 (37.7813289751352, -122.430538166219)
2284 23758 3 62 900X Webster St 4 11 1 2     25 20   6003894.1493 2111953.6889 37.7792424093118 -122.43011272647199 (37.7792424093118, -122.430112726472)
2297 23709 3 62 700X Webster St 4 11 1 2     16 20   6003970.4427 2111382.6873 37.7776789009548 -122.429808057223 (37.7776789009548, -122.429808057223)
3829 4634 3 62 500X Columbus Ave 1 11 1 2   08/19/2006 12:00:00 AM 8 3   6010031.5482 2119295.5915 37.799747198685004 -122.40939911161502 (37.799747198685, -122.409399111615)
3859 23825 3 62 1200X Webster St 4 11 1 2     30 20   6003756.6414 2112968.1539 37.782020088596504 -122.43066083333599 (37.7820200885965, -122.430660833336)
5117 23827 3 62 1200X Webster St 6 11 1 2     20 20   6003747.0158 2113043.0957 37.7822253147353 -122.430699482992 (37.7822253147353, -122.430699482992)
5279 23791 3 62 1100X Webster St 6 11 1 2     3 20   6003783.4554 2112735.7654 37.7813835268154 -122.430551482109 (37.7813835268154, -122.430551482109)
5299 4716 3 62 1000X Columbus Ave 3 11 1 2     70 3   6008306.8566 2120868.0824 37.803968081269204 -122.415478587922 (37.8039680812692, -122.415478587922)
5524 4635 3 62 500X Columbus Ave 2 11 1 2   01/05/1990 12:00:00 AM 35 3   6010009.8735 2119314.4873 37.7997978674726 -122.409475448708 (37.7997978674726, -122.409475448708)
5646 4679 3 62 700X Columbus Ave 6 11 1 2   08/19/2006 12:00:00 AM 6 3x3   6009212.7257 2120043.2180000003 37.801754083871295 -122.412285420728 (37.8017540838713, -122.412285420728)
5830 4674 3 62 700X Columbus Ave 1 11 1 2   09/05/1991 12:00:00 AM 15 3x4   6009400.8826 2119872.8379 37.8012968187356 -122.411622263241 (37.8012968187356, -122.411622263241)
5931 22784 3 62 1880 Turk St 1 1 1 2     6 3X3   6001016.5841 2112130.2222 37.7795637284835 -122.440080052813 (37.7795637284835, -122.440080052813)
6075 23828 3 62 1200X Webster St 7 11 1 2     20 20   6003742.203 2113074.035 37.78230999365589 -122.430718341656 (37.7823099936559, -122.430718341656)
6099 4714 3 62 1000X Columbus Ave 1 11 1 2     80 3   6008373.9156 2120808.2881 37.8038076701269 -122.415242289828 (37.8038076701269, -122.415242289828)
6262 23731 3 62 800X Webster St 6 11 1 2     6 20   6003929.9014 2111682.7982 37.7785006353915 -122.429969716521 (37.7785006353915, -122.429969716521)
6297 4668 3 62 600X Columbus Ave 3 11 1 2     60 3   6009590.6555 2119701.3035 37.8008364710267 -122.41095344028601 (37.8008364710267, -122.410953440286)
6383 4717 3 62 1000X Columbus Ave 4 11 1 2   08/19/2006 12:00:00 AM 6 3   6008242.0329 2120925.0825 37.804120945419 -122.415706953629 (37.804120945419, -122.415706953629)
6398 23727 3 62 800X Webster St 2 11 1 2   04/21/2008 12:00:00 AM 3 6   6003949.8401 2111575.542 37.7782072655707 -122.429893088415 (37.7782072655707, -122.429893088415)
6547 1660 3 62 1400X Fell St 1 1 1 2     18 3X3   6000641.8596 2109991.603 37.7736702824704 -122.441222896356 (37.7736702824704, -122.441222896356)
6589 4667 3 62 600X Columbus Ave 2 11 1 2   10/03/2012 12:00:00 AM 12 3 Permit Number 769286 6009690.8519 2119608.7257 37.80058789320879 -122.410600176031 (37.8005878932088, -122.410600176031)
6800 23823 3 62 1200X Webster St 2 11 1 2     20 20   6003765.5794 2112902.15 37.781839364726 -122.430625200646 (37.781839364726, -122.430625200646)
6803 19590 3 62 100 STAIRWAY4 13 1 1 2     3 60            
6949 23761 3 62 900X Webster St 7 11 1 2     25 20   6003883.1487 2112042.3815 37.7794853141392 -122.430157111124 (37.7794853141392, -122.430157111124)
7054 4734 3 62 1100X Columbus Ave 5 11 1 2     60 3x3   6007950.0877 2121194.0464 37.80484303663339 -122.416736319981 (37.8048430366334, -122.416736319981)
7107 4638 3 62 500X Columbus Ave 5 11 1 2     60 3   6009905.4204 2119408.7236 37.8000507639755 -122.40984355245001 (37.8000507639755, -122.40984355245)
7156 13002 3 62 359 Lombard St 1 1 1 2   08/23/1995 12:00:00 AM 8 3X3   6010611.1408 2120633.1017 37.8034521300977 -122.40748784681101 (37.8034521300977, -122.407487846811)
7162 23924 3 62 1700X Webster St 6 11 1 2     20 12x1   6003487.1069 2114786.6255 37.7869978805436 -122.43172317383998 (37.7869978805436, -122.43172317384)
7231 19588 3 62 100 STAIRWAY4 11 1 1 2     3 60            
7311 23920 3 62 1700X Webster St 2 11 1 2     20 12x12   6003521.972999999 2114612.7568 37.786522457310205 -122.43159012740699 (37.7865224573102, -122.431590127407)
7325 23732 3 62 800X Webster St 7 11 1 2     12 20   6003928.5263 2111708.2372 37.7785704067109 -122.429976288631 (37.7785704067109, -122.429976288631)
7386 23826 3 62 1200X Webster St 5 11 1 2     20 20   6003751.8286 2113008.0312 37.78212930904171 -122.43068032991002 (37.7821293090417, -122.43068032991)
7407 19591 3 62 100 STAIRWAY4 14 1 1 2     3 60            
7438 23859 3 62 1400X Webster St 4 11 1 2     25 3X3   6003649.3852 2113669.4444 37.783939579713504 -122.431081960003 (37.7839395797135, -122.431081960003)
7577 4636 3 62 500X Columbus Ave 3 11 1 2     45 3   6009974.2224 2119345.7236 37.7998816370329 -122.409601021151 (37.7998816370329, -122.409601021151)
7642 23788 3 62 1100X Webster St 3 11 1 2     20 20   6003799.2688 2112646.3852 37.7811390068769 -122.43049039607 (37.7811390068769, -122.43049039607)
7649 4666 3 62 600X Columbus Ave 1 11 1 2   10/03/2012 12:00:00 AM 60 3 Permit Number 769286 6009738.4106 2119565.7843 37.8004726529456 -122.41043256902 (37.8004726529456, -122.41043256902)
7655 4730 3 62 1175X Columbus Ave 1 11 1 2     100 3x3   6007911.57425 2121225.41132 37.8049269905411 -122.41687182377 (37.8049269905411, -122.41687182377)
7804 1666 3 62 1400X Fell St 7 1 1 2     18 3X3   6000356.4682 2109956.4177 37.7735574116821 -122.44220758007401 (37.7735574116821, -122.442207580074)
7873 28650 3 62 1600X Webster St 12 11 1 2     8 6   6003539.955 2114426.6147 37.786012377283896 -122.431514620567 (37.7860123772839, -122.431514620567)
7946 4639 3 62 500X Columbus Ave 6 11 1 2     75 3   6009873.723999999 2119435.9713 37.8001238030697 -122.40995515916201 (37.8001238030697, -122.409955159162)
8006 23900 3 62 1600X Webster St 3 11 1 2     20 6   6003566.3311 2114312.7691 37.7857012808729 -122.43141523648701 (37.7857012808729, -122.431415236487)
8177 4676 3 62 700X Columbus Ave 3 11 1 2     24 3x4   6009334.3928 2119933.7869 37.8014604396574 -122.411856657471 (37.8014604396574, -122.411856657471)
8325 23708 3 62 700X Webster St 3 11 1 2     20     6003978.3577 2111349.4443 37.77758807209621 -122.429778304865 (37.7775880720962, -122.429778304865)
8454 4715 3 62 1000X Columbus Ave 2 11 1 2   08/19/2006 12:00:00 AM 6 3   6008330.3273 2120843.4941 37.803901887177204 -122.415395624015 (37.8039018871772, -122.415395624015)
8475 23759 3 62 900X Webster St 5 11 1 2     25 20   6003889.3366 2111985.3157 37.7793289760816 -122.430131632423 (37.7793289760816, -122.430131632423)
8492 1663 3 62 1400X Fell St 4 1 1 2     18 3X3   6000501.7702 2109972.7072 37.773610418483 -122.44170612948601 (37.773610418483, -122.441706129486)
8513 23760 3 62 900X Webster St 6 11 1 2     25 20   6003885.2113 2112011.4423 37.7794004795956 -122.430147767922 (37.7794004795956, -122.430147767922)
8565 4733 3 62 1100X Columbus Ave 4 11 1 2     20 3x3   6007980.3619 2121165.8966 37.80476744709579 -122.416629557244 (37.8047674470958, -122.416629557244)
8587 4732 3 62 1100X Columbus Ave 3 11 1 2     14 3x3   6008014.3541 2121137.2157 37.8046906082857 -122.41650989053801 (37.8046906082857, -122.416509890538)
8699 23824 3 62 1200X Webster St 3 11 1 2     20 20   6003763.5168 2112936.527 37.78193363853529 -122.430634790088 (37.7819336385353, -122.430634790088)
8814 1661 3 62 1400X Fell St 2 1 1 2     18 3X3   6000589.0817 2109986.3904 37.773652963463796 -122.441405088647 (37.7736529634638, -122.441405088647)
8911 4637 3 62 500X Columbus Ave 4 11 1 2     60 3   6009937.8119 2119380.0857 37.7999739465801 -122.409729442456 (37.7999739465801, -122.409729442456)
9026 4677 3 62 700X Columbus Ave 4 11 1 2     24 3x3   6009299.7627 2119967.4935 37.8015510467699 -122.411978876948 (37.8015510467699, -122.411978876948)
10217 2412 3 62 2770 Bryant St 1 1 1 2   09/18/1996 12:00:00 AM 6 3X3   6009783.25197 2101219.12721 37.7500995368852 -122.40898218658998 (37.7500995368852, -122.40898218659)
12970 19589 3 62 100 STAIRWAY4 12 1 1 2     3 60            
16521 19806 3 62 100 STAIRWAY23 1 1 1 2     6 60ST            
17242 4298 3 62 4350 Cesar Chavez St 1 1 1 2     6 3X3   6001589.80492 2100313.4171 37.7471502929454 -122.437250699681 (37.7471502929454, -122.437250699681)
17278 2375 3 62 2547 Bryant St 1 1 1 2     18 3X3   6009774.35605 2102523.0562 37.753679337750604 -122.409104945855 (37.7536793377506, -122.409104945855)
17306 2392 3 62 2655 Bryant St 1 1 1 2     18 3X3   6009810.34614 2101884.53168 37.751928107698 -122.408935435327 (37.751928107698, -122.408935435327)
17519 2314 3 62 2253 Bryant St 1 1 1 2     12 3x3   6009680.74998 2104241.2199 37.7583917852794 -122.409549914219 (37.7583917852794, -122.409549914219)
17542 2343 3 62 2385 Bryant St 1 1 1 2     23 3X3   6009722.48016 2103476.08894 37.7562932460395 -122.40935159661501 (37.7562932460395, -122.409351596615)
18117 11765 3 62 800X Junipero Serra Blvd 3 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991272.34511 2091581.45548 37.7225826231682 -122.47229087392 (37.7225826231682, -122.47229087392)
18300 2394 3 62 2661 Bryant St 1 1 1 2     18 7X6   6009814.716440001 2101845.61428 37.7518214939686 -122.408917576591 (37.7518214939686, -122.408917576591)
18776 2310 3 62 2227 Bryant St 1 1 1 2     12 3x3   6009672.2386 2104377.81978 37.758766380788 -122.409588991562 (37.758766380788, -122.409588991562)
18937 2410 3 62 2753 Bryant St 1 1 1 2   07/04/2003 12:00:00 AM 3 3x3   6009844.62689 2101286.4895200003 37.7502879367387 -122.40877469949 (37.7502879367387, -122.40877469949)
19206 2364 3 62 2483 Bryant St 1 1 1 2     18 3X3   6009753.556480001 2102901.70574 37.754717859559996 -122.40920359338499 (37.75471785956, -122.409203593385)
19813 29581 3 62 500X Junipero Serra Blvd 3 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991390.5187800005 2093368.54568 37.7274963677541 -122.47201256884199 (37.7274963677541, -122.472012568842)
19955 29580 3 62 500X Junipero Serra Blvd 2 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991386.6913 2093344.7747799999 37.7274308773069 -122.47202406848 (37.7274308773069, -122.47202406848)
20128 11766 3 62 800X Junipero Serra Blvd 4 11 1 2   03/30/2006 12:00:00 AM 3 6X6   5991273.54078 2091606.60865 37.72265175674929 -122.47228857348101 (37.7226517567493, -122.472288573481)
20167 2332 3 62 2318 Bryant St 1 1 1 2     18 6X6   6009643.236190001 2103731.69198 37.7569906343237 -122.409643691024 (37.7569906343237, -122.409643691024)
20543 2353 3 62 2413 Bryant St 1 1 1 2   10/03/2013 12:00:00 AM 3 4X4   6009731.35926 2103287.7886799998 37.7557767132463 -122.409307601761 (37.7557767132463, -122.409307601761)
20799 2336 3 62 2350 Bryant St 1 1 1 2     12 4x4   6009647.84885 2103642.0545799998 37.7567447686625 -122.40962141212201 (37.7567447686625, -122.409621412122)
20957 4302 3 62 4378 Cesar Chavez St 1 1 1 2     12 3X3   6001457.95867 2100305.5079 37.747121080269295 -122.437706046203 (37.7471210802693, -122.437706046203)
21060 2380 3 62 2566 Bryant St 1 1 1 2     6 3x3   6009717.08187 2102390.53262 37.7533122488659 -122.409293662278 (37.7533122488659, -122.409293662278)
21126 2414 3 62 2786 Bryant St 1 1 1 2     12 3X3   6009786.496590001 2101143.3199400003 37.749891568653496 -122.408965618395 (37.7498915686535, -122.408965618395)
21137 2330 3 62 2312 Bryant St 1 1 1 2     18 4X4   6009640.84961 2103785.73358 37.7571388866594 -122.409655759023 (37.7571388866594, -122.409655759023)
21155 2419 3 62 2822 Bryant St 1 1 1 2     12 3x3   6009803.315230001 2100866.84766 37.7491333789981 -122.408887954717 (37.7491333789981, -122.408887954717)
21192 3896 3 62 60 Castro St 1 1 1 2     12 5X5   6002168.7084800005 2107927.71258 37.7680902055206 -122.435793601904 (37.7680902055206, -122.435793601904)
21374 2362 3 62 2473 Bryant St 1 1 1 2     18 3X3   6009749.23862 2102948.41566 37.7548458726476 -122.40922182173 (37.7548458726476, -122.40922182173)
21487 2309 3 62 2213 Bryant St 1 1 1 2     12 3X3   6009668.22468 2104416.43849 37.7588721941234 -122.409605599315 (37.7588721941234, -122.409605599315)
21559 19144 3 62 45 Sanchez St 1 1 1 2     12 3x3   6003508.29583 2108036.92775 37.768466086156394 -122.431167909289 (37.7684660861564, -122.431167909289)
21942 11767 3 62 800X Junipero Serra Blvd 5 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991276.05264 2091631.0711599998 37.7227190701221 -122.472281672976 (37.7227190701221, -122.472281672976)
22378 26756 3 62 1399 Post St 5 1 1 2     6 4X4   6005569.26951 2114444.1495 37.7861753317646 -122.424494982868 (37.7861753317646, -122.424494982868)
22416 26753 3 62 1399 Post St 2 1 1 2     6 4X4   6005527.1532 2114438.07435 37.7861562724304 -122.424640262031 (37.7861562724304, -122.424640262031)
22571 26752 3 62 1399 Post St 1 1 1 2     6 4X4   6005515.49515 2114435.63395 37.7861489132884 -122.424680422175 (37.7861489132884, -122.424680422175)
22634 26754 3 62 1399 Post St 3 1 1 2     6 4X4   6005539.86656 2114440.61457 37.7861639652384 -122.424596457885 (37.7861639652384, -122.424596457885)
22794 26757 3 62 1399 Post St 6 1 1 2     6 4X4   6005593.49204 2114448.7926 37.786189448429205 -122.42441150958099 (37.7861894484292, -122.424411509581)
22804 26755 3 62 1399 Post St 4 1 1 2     6 4X4   6005555.38127 2114442.5721400003 37.7861702164197 -122.424542920326 (37.7861702164197, -122.424542920326)
25223 208086 3 62 800x Junipero Serra Blvd 56 11 1 2     4 Width 0ft   5991357.47228 2092905.4597099999 37.7262229367261 -122.472093069866 (37.7262229367261, -122.472093069866)
26865 200267 3 62 860x Jamestown Ave 4 11 1 2     1 Width 5ft   6014763.4294300005 2089103.4873400002 37.7171101711671 -122.39091365107001 (37.7171101711671, -122.39091365107)
30755 208080 3 62 1000x Junipero Serra Blvd 1 11 1 2     4 Width 0ft   5991162.63824 2089810.37082 37.7177133113937 -122.472541042839 (37.7177133113937, -122.472541042839)
Powered by Datasette · Query took 10.36ms · Data source: data.sfgov.org