sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5515 48743 1 60   1 1 1 1         Permit Number 46023          
6135 48746 1 60   4 1 1 1         Permit Number 46023          
6959 48747 1 60   5 1 1 1         Permit Number 46023          
7180 48749 1 60   7 1 1 1         Permit Number 46023          
8095 50823 1 60   2 1 1 1   03/19/2004 12:00:00 AM     Permit Number 47344          
8773 48750 1 60   8 1 1 1         Permit Number 46023          
8939 48748 1 60   6 1 1 1         Permit Number 46023          
9025 48744 1 60   2 1 1 1         Permit Number 46023          
10338 30354 1 60   1 1 1 1   02/17/1956 12:00:00 AM     Permit Number 43          
13566 48742 1 60   10 1 1 1         Permit Number 46023          
14417 48751 1 60   9 1 1 1         Permit Number 46023          
15637 48745 1 60   3 1 1 1         Permit Number 46023          
16857 50824 1 60   1 1 1 1   03/19/2004 12:00:00 AM     Permit Number 47344          
73344 176058 2 60 0 Crespi Dr 2 2 1 1     25     5989854.78687 2090110.33741 37.7184611570226 -122.47708355628599 (37.7184611570226, -122.477083556286)
38217 176045 2 60 0 Font Blvd 1 2 1 1     20     5990157.58815 2089581.85402 37.7170276349961 -122.475998332672 (37.7170276349961, -122.475998332672)
65336 176043 2 60 0 Font Blvd 1 2 1 1     19     5989267.954919999 2090414.23117 37.7192615104927 -122.47913418591499 (37.7192615104927, -122.479134185915)
153599 176040 2 60 0 Font Blvd 2 2 1 1     25     5989182.3515099995 2090508.47222 37.719515300969206 -122.479436972335 (37.7195153009692, -122.479436972335)
161995 176044 2 60 0 Font Blvd 2 2 1 1     21     5990534.22824 2089263.3063400001 37.7161748133009 -122.47467324639099 (37.7161748133009, -122.474673246391)
163843 176041 2 60 0 Font Blvd 1 2 1 1     20     5989102.080019999 2090436.91452 37.71931415859461 -122.479709205217 (37.7193141585946, -122.479709205217)
166239 176046 2 60 0 Font Blvd 2 2 1 1     24     5990073.98867 2089647.08481 37.7172018948419 -122.47629205486 (37.7172018948419, -122.47629205486)
185959 176042 2 60 0 Font Blvd 2 2 1 1     19     5989234.3289 2090278.8910299998 37.7188879474116 -122.47924052173599 (37.7188879474116, -122.479240521736)
40567 176049 2 60 0 Gonzalez Dr 6 2 1 1     18     5989054.79394 2089564.29309 37.716915411303 -122.479808833919 (37.716915411303, -122.479808833919)
40789 176052 2 60 0 Gonzalez Dr 1 2 1 1     17     5989234.209980001 2089407.1197400002 37.716494274064495 -122.47917719598 (37.7164942740645, -122.47917719598)
55378 176054 2 60 0 Gonzalez Dr 2 2 1 1     16     5989245.31981 2089315.2477799999 37.7162426617475 -122.47913207879101 (37.7162426617475, -122.479132078791)
62427 176057 2 60 0 Gonzalez Dr 5 2 1 1     18     5989281.98257 2089351.5172299999 37.7163443777799 -122.479008007435 (37.7163443777799, -122.479008007435)
69208 176048 2 60 0 Gonzalez Dr 1 2 1 1     18     5989010.93647 2089619.81285 37.7170653066825 -122.479964486788 (37.7170653066825, -122.479964486788)
154485 176056 2 60 0 Gonzalez Dr 6 2 1 1     24     5989277.7182599995 2089365.90518 37.7163836358725 -122.47902379861401 (37.7163836358725, -122.479023798614)
160065 176051 2 60 0 Gonzalez Dr 2 2 1 1     25     5989218.52603 2089406.1518400002 37.7164907055632 -122.479231336085 (37.7164907055632, -122.479231336085)
173612 176050 2 60 0 Gonzalez Dr 3 2 1 1     13     5989206.756130001 2089405.10082 37.7164871361381 -122.47927194136999 (37.7164871361381, -122.47927194137)
179359 176053 2 60 0 Gonzalez Dr 1 2 1 1     19     5989219.15665 2089312.55172 37.7162337395604 -122.479222313162 (37.7162337395604, -122.479222313162)
184066 176047 2 60 0 Gonzalez Dr 6 2 1 1     24     5988958.7133 2089588.42281 37.7169760831658 -122.480142699133 (37.7169760831658, -122.480142699133)
187875 176055 2 60 0 Gonzalez Dr 7 2 1 1     24     5989270.85841 2089380.9981799999 37.716424679123705 -122.479048612712 (37.7164246791237, -122.479048612712)
49572 189393 2 60 1 24th St 15 23 1 1     10     6017282.75412 2102644.41979 37.7544303427117 -122.38314741343201 (37.7544303427117, -122.383147413432)
77327 33952 1 60 1 Arbor St 3 1 1 1   04/09/1997 12:00:00 AM     Permit Number 37910 6002287.323724099 2097040.91143479 37.7382043832783 -122.43460477820899 (37.7382043832783, -122.434604778209)
168089 246700 2 60 1 Bonview St 6 2 1 1     23     6007679.27037 2099071.40446 37.744084288253795 -122.41610581094801 (37.7440842882538, -122.416105810948)
42295 212173 2 60 1 Chilton Ave 1 1 1 1     24 Width 3ft   6001737.04216 2095788.25615 37.7347336277483 -122.436417746678 (37.7347336277483, -122.436417746678)
2611 248770 2 60 1 Cuesta Ct 4 2 1 1     17 Width 8ft   5999726.1375 2101744.56242 37.7509737525388 -122.44379789365499 (37.7509737525388, -122.443797893655)
2614 248773 2 60 1 Cuesta Ct 1 2 1 1     15 Width 8ft   5999776.82694 2101824.96428 37.751197407653706 -122.44362838043999 (37.7511974076537, -122.44362838044)
2625 248771 2 60 1 Cuesta Ct 3 2 1 1     13 Width 8ft   5999742.36883 2101773.9828 37.751055459558394 -122.4437438777 (37.7510554595584, -122.4437438777)
2626 248769 2 60 1 Cuesta Ct 5 2 1 1     14 Width 8ft   5999705.100819999 2101709.8291 37.7508771833507 -122.443868145114 (37.7508771833507, -122.443868145114)
2628 248767 2 60 1 Cuesta Ct 1 1 1 1     19 Width 3ft   5999684.377780001 2101641.28638 37.750687799606105 -122.443934882898 (37.7506877996061, -122.443934882898)
2629 248772 2 60 1 Cuesta Ct 2 2 1 1     27 Width 8ft   5999759.8487 2101799.49731 37.7511265131926 -122.443685263491 (37.7511265131926, -122.443685263491)
2632 248768 2 60 1 Cuesta Ct 6 1 1 1     12 Width 3ft   5999691.3486 2101670.41928 37.7507681891085 -122.44391287020399 (37.7507681891085, -122.443912870204)
89582 99611 2 60 1 Entrada Ct 3 9 1 1           5992743.0 2092489.0 37.7251595224946 -122.46727314778099 (37.7251595224946, -122.467273147781)
167099 126287 2 60 1 Florence St 3 9 1 1     21     6008482.5431699995 2118328.02028 37.797003577504604 -122.41469074658998 (37.7970035775046, -122.41469074659)
176940 212100 2 60 1 San Marcos Ave 4 2 1 1     16 Width 4ft   5993916.201859999 2100058.21492 37.746010367202004 -122.46376667868499 (37.746010367202, -122.463766678685)
28874 218292 2 60 1 Woodacre Dr 16 2 1 1     39     5991223.38049 2095418.74528 37.73311602796429 -122.472739784911 (37.7331160279643, -122.472739784911)
58398 218290 2 60 1 Woodacre Dr 14 2 1 1     34     5991251.16534 2095467.63693 37.733251880466 -122.472647289653 (37.733251880466, -122.472647289653)
151782 218282 2 60 1 Woodacre Dr 9 2 1 1     12     5991361.16684 2095634.8342900001 37.7337173290882 -122.47227917194901 (37.7337173290882, -122.472279171949)
153594 218291 2 60 1 Woodacre Dr 15 2 1 1     18     5991233.57986 2095433.30624 37.7331565991011 -122.472705584612 (37.7331565991011, -122.472705584612)
188959 217849 2 60 1 Woodacre Dr 4 2 1 1     33     5991387.06493 2095679.62189 37.7338418033391 -122.47219289908001 (37.7338418033391, -122.47219289908)
51888 189490 2 60 10 Cashmere St 1 1 1 1     23 Width 4ft   6017365.32139 2095872.25334 37.7358399134893 -122.382390730173 (37.7358399134893, -122.382390730173)
178653 222106 2 60 10 Corwin St 1 1 1 1     15 Width 3ft   6001073.13519 2103957.39296 37.7571263896905 -122.439298447871 (37.7571263896905, -122.439298447871)
31686 189484 2 60 10 Garlington Ct 1 4 1 1     17 Width 8ft   6016756.63544 2094656.7103 37.732468633912795 -122.38441058228399 (37.7324686339128, -122.384410582284)
177388 206307 2 60 10 Jules Ave 1 1 1 1     13 Width 2ft   5994456.80406 2089957.2483 37.7183067254442 -122.461165314131 (37.7183067254442, -122.461165314131)
23588 142397 2 60 10 MAYFAIR DR 12 9 1 1     16 Width 0ft   5997908.5687 2114561.3906 37.7860616516624 -122.45100731899299 (37.7860616516624, -122.451007318993)
24862 142424 2 60 10 MAYFAIR DR 39 9 1 1     30 Width 0ft   5997593.3287 2114514.5192 37.78591490273521 -122.452094576108 (37.7859149027352, -122.452094576108)
25216 142438 2 60 10 MAYFAIR DR 53 9 1 1     15 Width 0ft   5997453.3913 2114497.9365 37.7858613541886 -122.452577521257 (37.7858613541886, -122.452577521257)
25943 142412 2 60 10 MAYFAIR DR 27 9 1 1     14 Width 0ft   5997733.6046 2114534.6553 37.7859782253852 -122.45161071556002 (37.7859782253852, -122.45161071556)
28742 142387 2 60 10 MAYFAIR DR 2 9 1 1     18 Width 0ft   5998077.7796 2114584.0649 37.7861335951467 -122.450423532667 (37.7861335951467, -122.450423532667)
29049 142409 2 60 10 MAYFAIR DR 24 9 1 1     27 Width 0ft   5997773.8768 2114540.7469 37.7859972575145 -122.45147182494699 (37.7859972575145, -122.451471824947)
32552 142395 2 60 10 MAYFAIR DR 10 9 1 1     30 Width 0ft   5997933.9503 2114564.4364 37.7860714676838 -122.45091972560499 (37.7860714676838, -122.450919725605)
32757 142398 2 60 10 MAYFAIR DR 13 9 1 1     18 Width 0ft   5997898.7544 2114559.3601 37.7860555145741 -122.451041127193 (37.7860555145741, -122.451041127193)
37218 142400 2 60 10 MAYFAIR DR 15 9 1 1     15 Width 0ft   5997877.4339 2114556.6527 37.7860468601303 -122.451114694716 (37.7860468601303, -122.451114694716)
38226 142419 2 60 10 MAYFAIR DR 34 9 1 1     29 Width 0ft   5997648.4915 2114525.3487 37.7859477973415 -122.451904510544 (37.7859477973415, -122.451904510544)
38991 142434 2 60 10 MAYFAIR DR 49 9 1 1     10 Width 0ft   5997490.7869 2114502.336 37.7858755765928 -122.45244846114599 (37.7858755765928, -122.452448461146)
39124 142417 2 60 10 MAYFAIR DR 32 9 1 1     14 Width 0ft   5997674.55 2114528.3945 37.785957652798 -122.451814575532 (37.785957652798, -122.451814575532)
40238 142386 2 60 10 MAYFAIR DR 1 9 1 1     27 Width 0ft   5998114.6675 2114591.1717 37.786155219669396 -122.450296423393 (37.7861552196694, -122.450296423393)
41642 142427 2 60 10 MAYFAIR DR 42 9 1 1     27 Width 0ft   5997563.2092 2114510.7965 37.7859029558443 -122.45219851203998 (37.7859029558443, -122.45219851204)
42502 142415 2 60 10 MAYFAIR DR 30 9 1 1     17 Width 0ft   5997700.27 2114531.1019 37.785966559642794 -122.451725787187 (37.7859665596428, -122.451725787187)
45228 142439 2 60 10 MAYFAIR DR 54 9 1 1     14 Width 0ft   5997443.9155 2114497.5981 37.7858598821031 -122.45261028028901 (37.7858598821031, -122.452610280289)
46803 142392 2 60 10 MAYFAIR DR 7 9 1 1     37 Width 0ft   5997992.4973 2114571.2048 37.7860934034035 -122.450717657836 (37.7860934034035, -122.450717657836)
49835 142396 2 60 10 MAYFAIR DR 11 9 1 1     22 Width 0ft   5997922.444 2114562.4059 37.7860652337565 -122.450959387654 (37.7860652337565, -122.450959387654)
51820 142425 2 60 10 MAYFAIR DR 40 9 1 1     10 Width 0ft   5997580.8071 2114513.5039 37.7859113977237 -122.45213782389 (37.7859113977237, -122.45213782389)
52759 142449 2 60 10 MAYFAIR DR 64 9 1 1     21 Width 0ft   5997336.6358 2114481.6923 37.785810061623295 -122.452980287706 (37.7858100616233, -122.452980287706)
60448 142435 2 60 10 MAYFAIR DR 50 9 1 1     20 Width 0ft   5997482.3264 2114500.9823 37.7858713749679 -122.452477634253 (37.7858713749679, -122.452477634253)
62029 142422 2 60 10 MAYFAIR DR 37 9 1 1     12 Width 0ft   5997618.0335 2114520.9492 37.7859339729155 -122.452009568816 (37.7859339729155, -122.452009568816)
63642 142411 2 60 10 MAYFAIR DR 26 9 1 1     20 Width 0ft   5997746.1262 2114536.3474 37.785983588517205 -122.45156751655 (37.7859835885172, -122.45156751655)
64888 142430 2 60 10 MAYFAIR DR 45 9 1 1     15 Width 0ft   5997534.1049 2114507.4123 37.7858919964517 -122.452298960079 (37.7858919964517, -122.452298960079)
67815 142414 2 60 10 MAYFAIR DR 29 9 1 1     24 Width 0ft   5997709.7458 2114531.1019 37.7859671023257 -122.451693003671 (37.7859671023257, -122.451693003671)
67964 142402 2 60 10 MAYFAIR DR 17 9 1 1     13 Width 0ft   5997856.7901 2114554.2838 37.7860391738166 -122.45118594545299 (37.7860391738166, -122.451185945453)
69592 142408 2 60 10 MAYFAIR DR 23 9 1 1     12 Width 0ft   5997793.8437 2114545.4848 37.7860114098886 -122.451403087084 (37.7860114098886, -122.451403087084)
73277 142420 2 60 10 MAYFAIR DR 35 9 1 1     30 Width 0ft   5997641.3846 2114523.995 37.785943673381205 -122.45192900064899 (37.7859436733812, -122.451929000649)
73453 142447 2 60 10 MAYFAIR DR 62 9 1 1     23 Width 0ft   5997374.2006 2114486.4302 37.7858252233209 -122.45285066681299 (37.7858252233209, -122.452850666813)
74139 142401 2 60 10 MAYFAIR DR 16 9 1 1     15 Width 0ft   5997867.6196 2114554.9606 37.7860416521682 -122.45114852731301 (37.7860416521682, -122.451148527313)
74824 142399 2 60 10 MAYFAIR DR 14 9 1 1     18 Width 0ft   5997888.9402 2114558.0064 37.786051235795796 -122.45107498386601 (37.7860512357958, -122.451074983866)
75796 142393 2 60 10 MAYFAIR DR 8 9 1 1     18 Width 0ft   5997963.0546 2114567.8206 37.786082425901206 -122.45081927712 (37.7860824259012, -122.45081927712)
120871 142441 2 60 10 MAYFAIR DR 56 9 1 1     17 Width 0ft   5997429.025 2114493.8755 37.78584880764029 -122.452661528246 (37.7858488076403, -122.452661528246)
133275 142433 2 60 10 MAYFAIR DR 48 9 1 1     16 Width 0ft   5997499.5859 2114503.0128 37.7858779390155 -122.45241806806101 (37.7858779390155, -122.452418068061)
134598 142390 2 60 10 MAYFAIR DR 5 9 1 1     23 Width 0ft   5998035.1384 2114578.3117 37.7861153578155 -122.450570644279 (37.7861153578155, -122.450570644279)
136328 142418 2 60 10 MAYFAIR DR 33 9 1 1     25 Width 0ft   5997662.3668 2114527.0408 37.785953238114 -122.451856628165 (37.785953238114, -122.451856628165)
146892 142389 2 60 10 MAYFAIR DR 4 9 1 1     12 Width 0ft   5998056.7974 2114581.3575 37.7861249604509 -122.450495929916 (37.7861249604509, -122.450495929916)
148651 142446 2 60 10 MAYFAIR DR 61 9 1 1     15 Width 0ft   5997383.6764 2114487.7839 37.785829483217896 -122.45281798111 (37.7858294832179, -122.45281798111)
149196 142410 2 60 10 MAYFAIR DR 25 9 1 1     16 Width 0ft   5997761.6936 2114540.07 37.7859947012667 -122.45151392645799 (37.7859947012667, -122.451513926458)
149712 142432 2 60 10 MAYFAIR DR 47 9 1 1     14 Width 0ft   5997511.0923 2114504.0281 37.785881385969 -122.45237833260401 (37.785881385969, -122.452378332604)
150003 142416 2 60 10 MAYFAIR DR 31 9 1 1     11 Width 0ft   5997686.3947 2114529.7482 37.78596204808029 -122.451773694005 (37.7859620480803, -122.451773694005)
153762 142436 2 60 10 MAYFAIR DR 51 9 1 1     12 Width 0ft   5997474.8811 2114498.9518 37.7858653731869 -122.45250324620599 (37.7858653731869, -122.452503246206)
154222 142437 2 60 10 MAYFAIR DR 52 9 1 1     22 Width 0ft   5997464.7285 2114499.2902 37.7858657206584 -122.452538395628 (37.7858657206584, -122.452538395628)
155157 142431 2 60 10 MAYFAIR DR 46 9 1 1     15 Width 0ft   5997523.9523 2114506.3971 37.785888627357004 -122.452334011803 (37.785888627357, -122.452334011803)
157168 142428 2 60 10 MAYFAIR DR 43 9 1 1     13 Width 0ft   5997554.4102 2114510.1197 37.785900593478296 -122.45222890514201 (37.7859005934783, -122.452228905142)
163868 142445 2 60 10 MAYFAIR DR 60 9 1 1     21 Width 0ft   5997392.137 2114489.8144 37.7858355432461 -122.452788856559 (37.7858355432461, -122.452788856559)
Powered by Datasette · Query took 27.879ms · Data source: data.sfgov.org