Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, qCareAssistant
qSiteInfo ✖
PlantType ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
187 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | ||
800 | 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) | |||
804 | 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) | ||
813 | 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 | 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 | 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) | |||
829 | 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 | 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 | 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) | |||
897 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||
929 | 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 | 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 | 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) | |||
1303 | 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) | |||
1453 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||
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) | |||
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) | |||
2693 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | ||
3989 | 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 | 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 | 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 | 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 | 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) | |||
5253 | 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) | |||
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 | ||||||||||
5739 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||
6777 | 6777 | 26162 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 220 Richardson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999090.095480001 | 2119848.96049 | 37.800647486559704 | -122.447300272802 | (37.8006474865597, -122.447300272802) | |||
6785 | 6785 | 24317 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006479.1525 | 2112537.25416 | 37.7809908049215 | -122.421211565287 | (37.7809908049215, -122.421211565287) | |||
6948 | 6948 | 20002 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY46 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
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 | ||||||||||
7016 | 7016 | 22573 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006249.787140001 | 2112806.77447 | 37.781717908586295 | -122.422024207046 | (37.7817179085863, -122.422024207046) | |||
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 | ||||||||||
7212 | 7212 | 6169 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1075 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2009 12:00:00 AM | 3 | 3x3 | 6005763.6544 | 2113429.69831 | 37.7834008746955 | -122.423750304634 | (37.7834008746955, -122.423750304634) | ||
7248 | 7248 | 65393 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1345 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/1989 12:00:00 AM | 22 | Permit Number 28235 | 6008898.78625 | 2117545.17326 | 37.7948774497893 | -122.41319505442 | (37.7948774497893, -122.41319505442) | ||
7319 | 7319 | 98048 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2251 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003429.10066 | 2116873.98532 | 37.7927259513035 | -122.432072977999 | (37.7927259513035, -122.432072977999) | |||
7445 | 7445 | 99167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003331.11107 | 2115984.74946 | 37.7902787808939 | -122.432348487091 | (37.7902787808939, -122.432348487091) | ||
7696 | 7696 | 19998 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY46 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
7734 | 7734 | 24324 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006305.76929 | 2112511.39113 | 37.7809100152295 | -122.421809546989 | (37.7809100152295, -122.421809546989) | |||
7803 | 7803 | 98047 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2251 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003407.78151 | 2116869.84399 | 37.7927133715759 | -122.43214644721901 | (37.7927133715759, -122.432146447219) | |||
7840 | 7840 | 19005 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3067 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000119.97054 | 2115432.29592 | 37.788579285248495 | -122.443419066834 | (37.7885792852485, -122.443419066834) | |||
7871 | 7871 | 9429 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 727 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005901.79421 | 2112405.20993 | 37.7805956778943 | -122.423199547232 | (37.7805956778943, -122.423199547232) | |||
7920 | 7920 | 98924 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3527 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5997977.38318 | 2115131.5705 | 37.7876311543002 | -122.45081036719999 | (37.7876311543002, -122.4508103672) | |||
7982 | 7982 | 99166 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 25928 | 6003335.0360900005 | 2115969.1620099996 | 37.7902362042855 | -122.43233379308701 | (37.7902362042855, -122.432333793087) | ||
8055 | 8055 | 113745 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009609.4912 | 2118458.30583 | 37.797424561837 | -122.410800425125 | (37.797424561837, -122.410800425125) | ||||
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 | |||||||||
8251 | 8251 | 22580 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006453.23929 | 2112834.51188 | 37.7818055412449 | -122.42132232756 | (37.7818055412449, -122.42132232756) |
JSON shape: default, array, newline-delimited
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");