Street_Tree_List

Data source: data.sfgov.org

3,530 rows where qSpecies = 60 sorted by qAddress

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 2152.248ms · Data source: data.sfgov.org