sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5078 253759 2 22 330 Twin Peaks Blvd 3 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5072 253758 2 22 330 Twin Peaks Blvd 2 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5061 253757 2 22 330 Twin Peaks Blvd 1 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
1950 252823 6 22 3852 17th St 2 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1498 251577 2 22 490X Ashbury St 2 1 1 1       3x3   5998892.0 2109203.0 37.7714051474644 -122.447219139052 (37.7714051474644, -122.447219139052)
180523 250923 2 22 278 28th Ave 1 2 1 1     12 Width 4ft   5987155.47583 2114093.09935 37.784154377065605 -122.488175216117 (37.7841543770656, -122.488175216117)
48693 250855 2 22 218 30th Ave 3 2 1 1     3 Width 4ft   5986524.354280001 2114409.87574 37.7849873138589 -122.49038195276 (37.7849873138589, -122.49038195276)
41492 250854 2 22 218 30th Ave 2 2 1 1     3 Width 4ft   5986525.32355 2114391.2850900004 37.7849363258965 -122.49037723133699 (37.7849363258965, -122.490377231337)
187026 250853 2 22 218 30th Ave 1 2 1 1     3 Width 4ft   5986526.42947 2114357.74439 37.7848442973805 -122.490370936979 (37.7848442973805, -122.490370936979)
53403 250850 2 22 237 30th Ave 3 2 1 1     5 Width 4ft   5986483.76145 2114254.92993 37.7845595063632 -122.49051098570801 (37.7845595063632, -122.490510985708)
76459 250849 2 22 237 30th Ave 4 2 1 1     3 Width 4ft   5986484.1216400005 2114229.10483 37.7844886191085 -122.490507838982 (37.7844886191085, -122.490507838982)
26066 250823 2 22 30 Sea View Ter 2 2 1 1     4 Width 4ft   5986296.26976 2114176.2212099996 37.784332441942 -122.491153839973 (37.784332441942, -122.491153839973)
58409 250822 2 22 30 Sea View Ter 1 2 1 1     3 Width 4ft   5986317.22796 2114180.7305400004 37.784346047780296 -122.491081664887 (37.7843460477803, -122.491081664887)
22986 250821 2 22 45 Sea View Ter 2 2 1 1     9 Width 4ft   5986295.23656 2114137.57517 37.7842262706806 -122.49115456935 (37.7842262706806, -122.49115456935)
188900 250817 2 22 45 Sea View Ter 1 2 1 1     5 Width 4ft   5986236.9897 2114116.07021 37.7841638208535 -122.491354496716 (37.7841638208535, -122.491354496716)
134779 250808 2 22 276 31st Ave 2 2 1 1     6 Width 4ft   5986223.649809999 2114092.95913 37.784099584980105 -122.49139894570801 (37.7840995849801, -122.491398945708)
115248 250807 2 22 276 31st Ave 1 2 1 1     5 Width 4ft   5986224.17361 2114083.07798 37.7840724847972 -122.491396406047 (37.7840724847972, -122.491396406047)
34500 250771 2 22 244 32nd Ave 1 4 1 1     8 Width 3ft   5985908.77802 2114250.7634799997 37.7845144656071 -122.49249989847401 (37.7845144656071, -122.492499898474)
60502 250769 2 22 243 32nd Ave 2 4 1 1     2 Width 3ft   5985862.54385 2114271.7143599996 37.7845692873761 -122.49266139422501 (37.7845692873761, -122.492661394225)
42206 250768 2 22 243 32nd Ave 1 4 1 1     2 Width 3ft   5985861.97079 2114274.2224 37.78457614022079 -122.492663561571 (37.7845761402208, -122.492663561571)
151212 250751 2 22 2845 Lake St 4 2 1 1     4 Width 4ft   5986604.01059 2114423.46335 37.785029273534 -122.49010737086901 (37.785029273534, -122.490107370869)
66937 250750 2 22 2845 Lake St 3 2 1 1     3 Width 4ft   5986586.88027 2114424.43756 37.785030948060395 -122.490166707225 (37.7850309480604, -122.490166707225)
24806 250749 2 22 2845 Lake St 2 2 1 1     4 Width 4ft   5986570.97427 2114425.38607 37.785032623492896 -122.490221805991 (37.7850326234929, -122.490221805991)
76228 250748 2 22 2845 Lake St 1 2 1 1     3 Width 4ft   5986552.65802 2114428.21548 37.7850393225459 -122.490285381759 (37.7850393225459, -122.490285381759)
74187 250711 2 22 185 28th Ave 1 2 1 1     9 Width 4ft   5987128.66045 2114611.16114 37.7855752618368 -122.48830607108499 (37.7855752618368, -122.488306071085)
51914 250552 2 22 120 El Camino Del Mar 7 4 1 1     3 Width 4ft   5988200.97229 2115369.68376 37.7877204533879 -122.484651890886 (37.7877204533879, -122.484651890886)
50112 250548 2 22 120 El Camino Del Mar 3 4 1 1     1 Width 4ft   5988224.68514 2115371.29245 37.787726251325395 -122.484569968025 (37.7877262513254, -122.484569968025)
182705 250547 2 22 120 El Camino Del Mar 2 4 1 1     2 Width 4ft   5988224.27982 2115368.83764 37.7877194875147 -122.484571190206 (37.7877194875147, -122.484571190206)
163726 250546 2 22 120 El Camino Del Mar 1 4 1 1     2 Width 4ft   5988227.83471 2115369.81789 37.7877223860179 -122.484558963049 (37.7877223860179, -122.484558963049)
68344 250494 2 22 346 El Camino Del Mar 2 4 1 1     3 Width 3ft   5987480.35945 2115339.08253 37.7875944385888 -122.487142792619 (37.7875944385888, -122.487142792619)
178352 250493 2 22 346 El Camino Del Mar 1 4 1 1     4 Width 3ft   5987501.66991 2115342.63083 37.787605423791106 -122.48706932428499 (37.7876054237911, -122.487069324285)
153211 250244 2 22 3 Mulford Aly 1 2 1 1     6 Width 0ft   6009213.4413 2115812.17165 37.790136709587 -122.411983771956 (37.790136709587, -122.411983771956)
119485 250243 2 22 1 Mulford Aly 1 2 1 1     13 Width 0ft   6009270.11228 2115820.15514 37.7901618096679 -122.41178825844601 (37.7901618096679, -122.411788258446)
156945 250242 2 22 523 Commercial St 6 10 1 1     4 Width 0ft   6012536.17343 2117342.3206700003 37.7945239973486 -122.400594842992 (37.7945239973486, -122.400594842992)
159643 250241 2 22 523 Commercial St 5 10 1 1     5 Width 0ft   6012522.17079 2117340.39818 37.7945179377025 -122.400643159068 (37.7945179377025, -122.400643159068)
137641 250240 2 22 523 Commercial St 4 10 1 1     8 Width 0ft   6012509.92284 2117337.5567099997 37.794509452601105 -122.40068533906201 (37.7945094526011, -122.400685339062)
75844 250239 2 22 523 Commercial St 3 10 1 1     6 Width 0ft   6012493.23475 2117334.36425 37.7944997561019 -122.400742857909 (37.7944997561019, -122.400742857909)
156877 250238 2 22 523 Commercial St 2 10 1 1     6 Width 0ft   6012482.15733 2117334.58927 37.7944997561041 -122.400781203214 (37.7944997561041, -122.400781203214)
59844 250237 2 22 523 Commercial St 1 10 1 1     7 Width 0ft   6012474.90226 2117332.79898 37.7944944357317 -122.400806180977 (37.7944944357317, -122.400806180977)
73537 250236 2 22 520 Commercial St 7 10 1 1     6 Width 0ft   6012472.9903 2117349.79933 37.794541008002895 -122.400813991574 (37.7945410080029, -122.400813991574)
188464 250235 2 22 520 Commercial St 6 10 1 1     11 Width 0ft   6012481.472999999 2117350.27619 37.7945427904834 -122.40078467369601 (37.7945427904834, -122.400784673696)
186459 250234 2 22 520 Commercial St 5 10 1 1     8 Width 0ft   6012500.45193 2117354.10926 37.79455437373571 -122.400719273201 (37.7945543737357, -122.400719273201)
165068 250233 2 22 520 Commercial St 4 10 1 1     8 Width 0ft   6012521.31946 2117354.65914 37.794557047424796 -122.400647107095 (37.7945570474248, -122.400647107095)
169217 250232 2 22 520 Commercial St 3 10 1 1     9 Width 0ft   6012525.89293 2117355.21508 37.794558828975 -122.400631321282 (37.794558828975, -122.400631321282)
180902 250231 2 22 520 Commercial St 2 10 1 1     13 Width 0ft   6012532.440909999 2117356.70467 37.7945632842246 -122.400608768988 (37.7945632842246, -122.400608768988)
175764 250230 2 22 520 Commercial St 1 10 1 1     12 Width 0ft   6012537.64619 2117356.2743599997 37.7945623929982 -122.400590727701 (37.7945623929982, -122.400590727701)
31972 249967 2 22 265 Filbert St 4 7 1 1     11 Width 0ft   6011605.44865 2120090.74048 37.8020185425817 -122.404008793573 (37.8020185425817, -122.404008793573)
49586 249962 2 22 271 Filbert St 2 7 1 1     15 Width 0ft   6011589.39853 2120084.6088 37.802000809738296 -122.40406390314301 (37.8020008097383, -122.404063903143)
74113 249819 2 22 275 Kearny St 1 7 1 1     16 Width 0ft   6010904.45886 2120604.70215 37.803390565377605 -122.40647080008002 (37.8033905653776, -122.40647080008)
159004 249741 2 22 2500 Broderick St 25 7 1 1     14     6000213.465969999 2117180.10756 37.7933836497995 -122.443221170114 (37.7933836497995, -122.443221170114)
46214 249735 2 22 2500 Broderick St 19 7 1 1     10     6000198.719930001 2117216.42615 37.7934825302438 -122.443274802094 (37.7934825302438, -122.443274802094)
170652 249730 2 22 2500 Broderick St 14 7 1 1     8     6000189.62639 2117273.3619 37.7936383422859 -122.443310357702 (37.7936383422859, -122.443310357702)
176995 249729 2 22 2500 Broderick St 13 7 1 1     13     6000196.56443 2117292.56753 37.7936914715225 -122.44328773166201 (37.7936914715225, -122.443287731662)
131494 249728 2 22 2500 Broderick St 12 7 1 1     10     6000179.512490001 2117293.73035 37.7936936919486 -122.44334681623 (37.7936936919486, -122.44334681623)
47701 249727 2 22 2500 Broderick St 11 7 1 1     10     6000218.44673 2117239.64543 37.7935474091368 -122.44320821449101 (37.7935474091368, -122.443208214491)
171349 249726 2 22 2500 Broderick St 10 7 1 1     12     6000203.6914 2117248.8827299997 37.793571930958706 -122.44325993272301 (37.7935719309587, -122.443259932723)
187463 249725 2 22 2500 Broderick St 9 7 1 1     11     6000213.93335 2117265.22883 37.793617397063606 -122.44322566942301 (37.7936173970636, -122.443225669423)
166246 248556 2 22 810 Shrader St 1 1 1 1     8 Width 0ft   5997664.6274 2107719.4855 37.7672615896189 -122.45135764598801 (37.7672615896189, -122.451357645988)
175744 248547 2 22 121 Beulah St 1 1 1 1     18 Width 0ft   5997450.6787 2107765.9697 37.7673769702657 -122.45210101415701 (37.7673769702657, -122.452101014157)
36806 248478 2 22 753 Shrader St 2 1 1 1     20 Width 0ft   5997595.8852 2107895.8834 37.7677419967608 -122.451608139596 (37.7677419967608, -122.451608139596)
70346 248444 2 22 57 Delmar St 1 1 1 1     23 Width 0ft   5999292.0309 2107993.2430000002 37.7681063099283 -122.445748402419 (37.7681063099283, -122.445748402419)
35918 248434 2 22 755 Ashbury St 1 1 1 1     17 Width 0ft   5999044.0139 2107974.1647 37.768039761912796 -122.44660489108101 (37.7680397619128, -122.446604891081)
131587 248417 2 22 707 Shrader St 2 1 1 1     8 Width 0ft   5997572.2646 2108064.8619999997 37.7682046160649 -122.45170203083401 (37.7682046160649, -122.451702030834)
154826 248416 2 22 707 Shrader St 1 1 1 1     5 Width 0ft   5997570.7504 2108081.8205 37.7682510930485 -122.451708491747 (37.7682510930485, -122.451708491747)
38371 248410 2 22 120 Belvedere St 2 1 1 1     5 Width 0ft   5998269.8314 2108078.1865 37.76828112696929 -122.449290188135 (37.7682811269693, -122.449290188135)
51956 248409 2 22 120 Belvedere St 1 1 1 1     5 Width 0ft   5998272.8596 2108056.6857 37.768222264452795 -122.44927816468201 (37.7682222644528, -122.449278164682)
70296 248374 2 22 1607 Waller St 1 1 1 1     6 Width 0ft   5997855.864 2108169.7923 37.7685089656416 -122.450728660067 (37.7685089656416, -122.450728660067)
55921 248345 2 22 27 Delmar St 1 1 1 1     15 Width 0ft   5999266.8961 2108175.2432 37.7686046014369 -122.44584843172899 (37.7686046014369, -122.445848431729)
162754 248259 2 22 128 Lundy's Ln 1 1 1 1     8 Width 3ft   6006747.6015099995 2098802.8037099997 37.743294342673394 -122.41930827066601 (37.7432943426734, -122.419308270666)
131384 248174 2 22 218 Esmeralda Ave 3 17 1 1     18     6007322.63795 2098720.65313 37.7431011449024 -122.41731411847401 (37.7431011449024, -122.417314118474)
51851 248038 2 22 55 Rutledge St 2 7 1 1     3     6010483.83611 2099425.5647299998 37.7452140265169 -122.40643314998002 (37.7452140265169, -122.40643314998)
62112 248024 2 22 447 Franconia St 2 1 1 1     7 Width 2ft   6009975.6682 2098408.38979 37.7423926445946 -122.40811859280899 (37.7423926445946, -122.408118592809)
169723 247968 2 22 16 Joy St 4 7 1 1     3     6010328.07842 2098922.3169299997 37.743823502860295 -122.406936272997 (37.7438235028603, -122.406936272997)
154759 247966 2 22 16 Joy St 2 7 1 1     3     6010335.18608 2098918.4382599997 37.7438132505971 -122.406911422945 (37.7438132505971, -122.406911422945)
147577 247965 2 22 16 Joy St 1 7 1 1     4     6010335.67136 2098911.58269 37.7437944538456 -122.40690926186599 (37.7437944538456, -122.406909261866)
3501 247943 4 22 29 Joy St 6 14 1 2     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297)
158350 247673 2 22 23 Castro St 4 4 1 1     4 Width 4ft   6002150.24034 2108430.52442 37.7694697538428 -122.435893462629 (37.7694697538428, -122.435893462629)
53630 247664 2 22 114 Divisadero St 1 4 1 1     7 Width 3ft   6001955.09074 2108392.82187 37.7693551442537 -122.436565776903 (37.7693551442537, -122.436565776903)
73146 247661 2 22 117 Divisadero St 2 4 1 1     6 Width 4ft   6001902.18667 2108371.43994 37.7692934282776 -122.436747238498 (37.7692934282776, -122.436747238498)
49977 247483 2 22 824 Page St 2 1 1 1     5 Width 0ft   6002602.0641 2109565.622 37.7726121080317 -122.434411792296 (37.7726121080317, -122.434411792296)
183188 247482 2 22 824 Page St 1 1 1 1     4 Width 0ft   6002611.5912 2109567.8206 37.77261868562589 -122.434378994315 (37.7726186856259, -122.434378994315)
53754 247403 2 22 964 Page St 1 1 1 1     8 Width 0ft   6001954.4916 2109478.6178 37.7723364366754 -122.436645580923 (37.7723364366754, -122.436645580923)
152564 247401 2 22 940 Page St 1 1 1 1     16 Width 0ft   6002054.8941 2109494.2208 37.7723849838567 -122.436299396839 (37.7723849838567, -122.436299396839)
156428 247356 2 22 408 Ashbury St 2 1 1 1     14 Width 0ft   5998924.3525 2109125.412 37.771193959092706 -122.44710164599701 (37.7711939590927, -122.447101645997)
30711 247235 2 22 49 Castro St 1 4 1 1     10 Width 4ft   6002189.582769999 2108332.3938700003 37.7692025463843 -122.435750357108 (37.7692025463843, -122.435750357108)
182369 246706 2 22 1 Bonview St 12 2 1 1     13     6007716.07 2099142.6271 37.7442819187879 -122.415983608356 (37.7442819187879, -122.415983608356)
24372 246497 2 22 319 Duncan St 1 4 1 1     15 Width 6ft   6004279.93355 2099832.71811 37.7459829621447 -122.427914200798 (37.7459829621447, -122.427914200798)
170943 246496 2 22 323 Duncan St 1 4 1 1     12 Width 4ft   6004247.31267 2099828.24572 37.745968836490604 -122.42802668078501 (37.7459688364906, -122.428026680785)
59473 246492 2 22 377 Duncan St 1 4 1 1     12 Width 5ft   6004118.95016 2099820.41125 37.7459400617793 -122.42846998271901 (37.7459400617793, -122.428469982719)
133893 246491 2 22 381 Duncan St 1 4 1 1     13 Width 5ft   6004093.63672 2099817.69369 37.745931167494 -122.428557319471 (37.745931167494, -122.428557319471)
187462 246482 2 22 334 Duncan St 1 4 1 1     9 Width 3ft   6004129.100269999 2099867.2658599997 37.7460692880854 -122.42843822405399 (37.7460692880854, -122.428438224054)
39915 246480 2 22 328 Duncan St 1 4 1 1     11 Width 5ft   6004200.75459 2099871.69589 37.7460855064407 -122.428190768384 (37.7460855064407, -122.428190768384)
75176 246478 2 22 324 Duncan St 1 4 1 1     15 Width 5ft   6004249.43735 2099875.64697 37.746099109581706 -122.42802271119 (37.7460991095817, -122.42802271119)
134879 246234 2 22 96 Delmar St 1 1 1 1     3 Width 0ft   5999351.234 2107757.7934 37.76746320468779 -122.44552669312 (37.7674632046878, -122.44552669312)
188470 246191 2 22 38 Delmar St 1 1 1 1     18 Width 0ft   5999302.1757 2108111.8005 37.768432418143504 -122.44572183985301 (37.7684324181435, -122.445721839853)
34549 246175 2 22 1612 Waller St 2 1 1 1     2 Width 0ft   5997837.5428 2108208.5544 37.768614347711605 -122.450794826415 (37.7686143477116, -122.450794826415)
34730 246024 2 22 625 Ashbury St 4 1 1 1     8 Width 0ft   5998967.8524 2108516.3802 37.7695241977125 -122.44690734636299 (37.7695241977125, -122.446907346363)
148630 246023 2 22 625 Ashbury St 3 1 1 1     6 Width 0ft   5998966.0354 2108531.2188 37.76956483694121 -122.446914699193 (37.7695648369412, -122.446914699193)
131445 246022 2 22 625 Ashbury St 2 1 1 1     4 Width 0ft   5998964.2184 2108548.4801 37.769612128289 -122.446922226392 (37.769612128289, -122.446922226392)
66319 246021 2 22 625 Ashbury St 1 1 1 1     5 Width 0ft   5998960.8873 2108562.713 37.769651017916395 -122.446934772849 (37.7696510179164, -122.446934772849)
67247 246013 2 22 67 Central Ave 2 1 1 1     5 Width 0ft   5999925.2465 2108618.8878 37.7698603069003 -122.443603132846 (37.7698603069003, -122.443603132846)
Powered by Datasette · Query took 30.027ms · Data source: data.sfgov.org