Street_Tree_List

Data source: data.sfgov.org

3,530 rows where qSpecies = 60

View and edit SQL

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
187 251248 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 829 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6001839.0 2095802.0 37.7347771581377 -122.436066227259 (37.7347771581377, -122.436066227259)
197 251245 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 701 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/04/1992 12:00:00 AM       6002463.96916 2095671.24377 37.73445361741221 -122.433896153002 (37.7344536174122, -122.433896153002)
492 173939 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 570 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/15/2017 12:00:00 AM 3 5xt Permit Number 779890 6014341.0 2104455.0 37.7592388085315 -122.39344754111201 (37.7592388085315, -122.393447541112)
526 18856 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2201 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004191.661859999 2115995.22985 37.790356315029996 -122.429371791378 (37.79035631503, -122.429371791378)
570 22578 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 799X Turk St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006396.3025 2112828.5224900004 37.7817858856438 -122.421518877095 (37.7817858856438, -122.421518877095)
598 22577 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 799X Turk St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006373.00538 2112825.1930299997 37.7817754301315 -122.421599237822 (37.7817754301315, -122.421599237822)
662 206411 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 241 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft Permit Number 779935 5993240.35303 2102520.36003 37.752731819221 -122.466282559112 (37.752731819221, -122.466282559112)
718 99173 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2100 Webster St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3 Permit Number 25928 6003311.25259 2116120.54401 37.790650512059 -122.432426898975 (37.790650512059, -122.432426898975)
794 212187 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     16     6002096.28779 2095466.30888 37.733870041163 -122.435152693763 (37.733870041163, -122.435152693763)
796 212189 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 3 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     16     6002068.0773599995 2095471.6867 37.7338832054473 -122.435250610137 (37.7338832054473, -122.435250610137)
797 212191 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 5 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     16     6002043.865019999 2095478.6742 37.7339010165159 -122.435334819059 (37.7339010165159, -122.435334819059)
800 216493 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Bosworth St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     0 Width 3ft   6001711.3067 2095523.18805 37.734004349526 -122.43648775710301 (37.734004349526, -122.436487757103)
801 212193 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 7 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     14     6002021.19403 2095482.3719 37.7339098820273 -122.43541346386002 (37.7339098820273, -122.43541346386)
804 216488 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Bosworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/29/1998 12:00:00 AM 0 Width 3ft   6001838.4009 2095488.4107 37.7339160801534 -122.43604586623002 (37.7339160801534, -122.43604586623)
810 212202 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 800 Bosworth St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6001677.26505 2095571.4535400001 37.734134940976 -122.43660890297501 (37.734134940976, -122.436608902975)
813 251390 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Bosworth St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       Width 3ft   6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
817 212190 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 Width 4ft   6002054.13349 2095467.56195 37.733871087977 -122.435298523304 (37.733871087977, -122.435298523304)
819 212192 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 Width 4ft   6002033.39335 2095471.77421 37.733881476032295 -122.43537052934201 (37.7338814760323, -122.435370529342)
821 251392 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Bosworth St 9 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2       Width 3ft   6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
829 212194 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     26 Width 4ft   6002001.778390001 2095479.66425 37.733901344755296 -122.43548039589899 (37.7339013447553, -122.435480395899)
832 212195 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 Width 4ft   6001959.954469999 2095488.58892 37.7339234743781 -122.43562563193899 (37.7339234743781, -122.435625631939)
836 212188 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 Width 4ft   6002077.238580001 2095462.75447 37.7338591998391 -122.435218298393 (37.7338591998391, -122.435218298393)
843 216491 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 800x Bosworth St 4 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2   01/29/1998 12:00:00 AM 0 Width 3ft   6001764.68694 2095507.97765 37.733965618424 -122.43630211726601 (37.733965618424, -122.436302117266)
897 22581 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 799X Turk St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006522.42636 2112846.04587 37.7818411112169 -122.42108379139799 (37.7818411112169, -122.421083791398)
898 139815 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1652 Eddy St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     26 Width 0ft   6002517.0 2112708.0 37.7812354643217 -122.434930809638 (37.7812354643217, -122.434930809638)
900 140947 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2060 Ofarrell St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
902 140944 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2060 Ofarrell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
904 140946 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2060 Ofarrell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
907 140952 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2060 Ofarrell St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
915 140945 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2060 Ofarrell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
922 140943 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2060 Ofarrell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
925 139814 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1652 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 0ft   6002517.0 2112708.0 37.7812354643217 -122.434930809638 (37.7812354643217, -122.434930809638)
927 140951 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2060 Ofarrell St 9 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     15 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
929 140950 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2060 Ofarrell St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 0ft   6001488.0 2113369.0 37.7829919235948 -122.438538008913 (37.7829919235948, -122.438538008913)
1077 98926 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 3541 Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 4x4   5997927.34517 2115124.9687799998 37.7876101632223 -122.450983011859 (37.7876101632223, -122.450983011859)
1274 212204 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 920 Bosworth St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 Width 3ft   6001555.51112 2095599.51711 37.7342050772889 -122.437031852331 (37.7342050772889, -122.437031852331)
1277 212203 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 920 Bosworth St 2 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     16     6001598.82808 2095593.8833700002 37.7341920703926 -122.436881688932 (37.7341920703926, -122.436881688932)
1303 212206 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 920 Bosworth St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 Width 3ft   6001486.61652 2095618.44955 37.734253145164 -122.43727139756399 (37.734253145164, -122.437271397564)
1307 212207 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 920 Bosworth St 8 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     11     6001467.5944 2095628.72955 37.7342802902926 -122.43733789885 (37.7342802902926, -122.43733789885)
1438 251533 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1201X Pierce St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   6002292.0 2112799.0 37.7814725496882 -122.43571571002899 (37.7814725496882, -122.435715710029)
1453 251535 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2799 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6002520.0 2095715.0 37.734576941489294 -122.433705562416 (37.7345769414893, -122.433705562416)
1471 251536 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2799 Diamond St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6002520.0 2095715.0 37.734576941489294 -122.433705562416 (37.7345769414893, -122.433705562416)
1543 141557 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 524 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6000673.0 2110815.0 37.7759328964671 -122.44117426506 (37.7759328964671, -122.44117426506)
1614 251637 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1640 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6002593.76659 2112688.5347700003 37.7811863760687 -122.43466384314199 (37.7811863760687, -122.434663843142)
1636 139812 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1624 EDDY ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/17/1997 12:00:00 AM 32 Width 0ft   6002737.4248 2112708.2774 37.7812487388446 -122.434168269296 (37.7812487388446, -122.434168269296)
1832 24314 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 600X Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6006601.99404 2112547.97273 37.781027160014204 -122.420787355977 (37.7810271600142, -122.420787355977)
2258 7812 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 700X Franklin St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006212.78826 2112695.72596 37.7814109097272 -122.422144314234 (37.7814109097272, -122.422144314234)
2401 140740 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2057X O'Farrell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 0ft   6001431.032000001 2113174.7073 37.7824552046492 -122.438721167537 (37.7824552046492, -122.438721167537)
2542 4384 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 5 Chilton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X14   6001725.16099 2095738.6738900002 37.7345968111862 -122.43645527631 (37.7345968111862, -122.43645527631)
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 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)
2620 23170 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 202X Van Ness Ave 2 Median : Cutout 11 Tree 1 DPW 2     30 9   6006871.78386 2111296.65749 37.7776065535391 -122.41976520271601 (37.7776065535391, -122.419765202716)
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 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 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 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 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)
2693 98923 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 3527 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4   5997962.31773 2115134.58282 37.7876385629149 -122.450862707746 (37.7876385629149, -122.450862707746)
2773 114412 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1345 Taylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12     6008898.23064 2117525.75314 37.794824095717395 -122.413195602999 (37.7948240957174, -122.413195602999)
2793 7815 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 700X Franklin St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006205.55902 2112775.31728 37.781629040289005 -122.422174980189 (37.781629040289, -122.422174980189)
2800 248806 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1039 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/1979 12:00:00 AM 18 Width 4ft Permit Number 17875 5997248.91757 2106862.4287 37.7648845181415 -122.45273365463001 (37.7648845181415, -122.45273365463)
2857 41128 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2049 Grove St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268)
2873 41127 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2049 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268)
2880 41129 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2049 Grove St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268)
2898 114413 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1345 Taylor St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22     6008903.22514 2117506.21986 37.7947707425189 -122.413176939363 (37.7947707425189, -122.413176939363)
2937 142168 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1477 GROVE ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6000782.6842 2110659.1833 37.775511310355505 -122.440783660256 (37.7755113103555, -122.440783660256)
3011 142167 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1477 GROVE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6000740.7568 2110654.3455 37.775495639126795 -122.440928349683 (37.7754956391268, -122.440928349683)
3045 141431 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 501 HAYES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/26/2005 12:00:00 AM 17 Width 0ft Permit Number 48304 6005404.7905 2110954.8993 37.776585419130896 -122.42481571306601 (37.7765854191309, -122.424815713066)
3053 126134 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2829 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 5ft Permit Number 779774 6000559.90395 2118036.87537 37.7957558571972 -122.44208400078101 (37.7957558571972, -122.442084000781)
3357 32073 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 3254 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30   Permit Number 35447 5999189.55674 2115674.61094 37.7891915158244 -122.44665558658701 (37.7891915158244, -122.446655586587)
3447 7810 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 700X Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6006241.41357 2112578.9156299997 37.781091791593205 -122.422036983727 (37.7810917915932, -122.422036983727)
3490 141187 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 1802 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Health Dept 8     25 Width 0ft   6002206.3563 2112987.8984 37.7819863518957 -122.436025516484 (37.7819863518957, -122.436025516484)
3494 106527 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2100 Baker St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15     5999890.2062099995 2116153.78918 37.7905472114236 -122.444265881958 (37.7905472114236, -122.444265881958)
3559 24319 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 600X Golden Gate Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3X3   6006449.33086 2112523.89037 37.7809524299494 -122.42131378399901 (37.7809524299494, -122.421313783999)
3685 22584 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 799X Turk St 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6006566.74341 2112845.87169 37.7818431310978 -122.420930462379 (37.7818431310978, -122.420930462379)
3774 99172 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2100 Webster St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3 Permit Number 25928 6003312.12208 2116110.60344 37.7906232670935 -122.432423180296 (37.7906232670935, -122.432423180296)
3898 212122 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 300x Miramar Ave 4 Median : Yard 3 Tree 1 DPW 2     3     5995365.2918 2092257.6675200001 37.724675368963105 -122.45819147914699 (37.7246753689631, -122.458191479147)
3989 22582 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 799X Turk St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006498.64773 2112839.17836 37.7818209142342 -122.421165566743 (37.7818209142342, -122.421165566743)
4186 9424 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 701X Golden Gate Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/01/1994 12:00:00 AM 12 3X3   6006118.832780001 2112436.92682 37.7806950106942 -122.422450960554 (37.7806950106942, -122.422450960554)
4307 22579 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 799X Turk St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006429.75961 2112830.68466 37.7817937088462 -122.42140328454799 (37.7817937088462, -122.421403284548)
4330 70503 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 193 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/25/1994 12:00:00 AM 7     6004252.47977 2092436.6780400001 37.725673555265395 -122.42748232385901 (37.7256735552654, -122.427482323859)
4657 24332 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 600X Golden Gate Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/22/1999 12:00:00 AM 9     6006393.27479 2112527.98365 37.7809605085733 -122.421508000714 (37.7809605085733, -122.421508000714)
4673 253651 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 131 Font Blvd 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
5253 222095 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 116 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     39 12x9   6004345.11847 2101047.98994 37.7493235046981 -122.427775375138 (37.7493235046981, -122.427775375138)
5451 23407 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 1748X Van Ness Ave 3 Median : Cutout 11 Tree 1 DPW 2     30 9   6006159.63822 2116414.10982 37.791617675355795 -122.422592496742 (37.7916176753558, -122.422592496742)
5515 48743 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
5739 99171 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2100 Webster St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3 Permit Number 25928 6003316.34975 2116092.5427599996 37.7905739167998 -122.432407262311 (37.7905739167998, -122.432407262311)
5771 99170 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2100 Webster St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3 Permit Number 25928 6003318.49866 2116076.63924 37.790530371641296 -122.43239869085899 (37.7905303716413, -122.432398690859)
5793 99169 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2100 Webster St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3 Permit Number 25928 6003320.5239 2116054.74736 37.790470376959796 -122.432390119424 (37.7904703769598, -122.432390119424)
5879 24320 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 600X Golden Gate Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6006433.20726 2112530.1062 37.7809685880643 -122.421370005128 (37.7809685880643, -122.421370005128)
5977 98925 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 3541 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 4x4   5997905.152000001 2115121.83421 37.7876002859601 -122.45105956936399 (37.7876002859601, -122.451059569364)
6053 7809 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 700X Franklin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006235.14399 2112561.39045 37.7810433181208 -122.422057428004 (37.7810433181208, -122.422057428004)
6135 48746 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 46023          
6180 113748 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 840X Broadway 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3     6009543.77791 2118449.1609099996 37.7973957673671 -122.411027164876 (37.7973957673671, -122.411027164876)
6223 24318 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 600X Golden Gate Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6006459.0655 2112530.3105599997 37.7809706070487 -122.421280563062 (37.7809706070487, -122.421280563062)
6350 22583 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 799X Turk St 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006548.992330001 2112844.76483 37.7818390913318 -122.42099179435499 (37.7818390913318, -122.420991794355)
6363 99168 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2100 Webster St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3 Permit Number 25928 6003328.674 2116003.83043 37.790331034186295 -122.432358282529 (37.7903310341863, -122.432358282529)
6377 7813 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 700X Franklin St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006213.15076 2112713.3724700003 37.7814593831787 -122.422144314209 (37.7814593831787, -122.422144314209)
6446 107232 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2265 Larkin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   6006749.11596 2119031.04722 37.7988363688534 -122.420738768293 (37.7988363688534, -122.420738768293)
6477 113747 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 840X Broadway 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/29/2016 12:00:00 AM 3     6009570.41641 2118454.8311400004 37.7974128301892 -122.410935389082 (37.7974128301892, -122.410935389082)

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 798.809ms · Data source: data.sfgov.org