Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker, PermitNotes
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) | ||||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | |||
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) |
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) | |||
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) | |||
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) | |||
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 | ||||||||
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) | ||
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 | ||||||||
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) | |||
8318 | 8318 | 24321 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006368.77272 | 2112521.86674 | 37.7809423314653 | -122.42159233103999 | (37.7809423314653, -122.42159233104) | |||
9570 | 9570 | 16824 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2139X O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001076.0 | 2113135.0 | 37.7823259746064 | -122.439946572306 | (37.7823259746064, -122.439946572306) | |||
9706 | 9706 | 5132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2787 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 5X5 | 6002542.444802401 | 2095842.6422614 | 37.734928691439706 | -122.433637082687 | (37.7349286914397, -122.433637082687) | |||
9760 | 9760 | 2247 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 21 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002207.695280001 | 2095600.7924099998 | 37.734245627727 | -122.434777138659 | (37.734245627727, -122.434777138659) | |||
10466 | 10466 | 1196 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3080 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 28 | 3X3 | 5996438.01379 | 2087205.1874 | 37.7108640234246 | -122.45411848649799 | (37.7108640234246, -122.454118486498) | ||
10580 | 10580 | 1280 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5992520.10718 | 2087379.1823 | 37.71111633361279 | -122.467672210425 | (37.7111163336128, -122.467672210425) | |||
10644 | 10644 | 1838 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2201X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011226.77764 | 2087216.18178 | 37.71173113716571 | -122.403005565662 | (37.7117311371657, -122.403005565662) | |||
10647 | 10647 | 19755 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY15 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
10725 | 10725 | 941 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1352 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 5x5 | 6002586.79672 | 2094029.0615 | 37.7299515286195 | -122.43335418993799 | (37.7299515286195, -122.433354189938) | |||
11364 | 11364 | 1271 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992356.50735 | 2087300.8185599998 | 37.7108917180496 | -122.468231949349 | (37.7108917180496, -122.468231949349) | |||
11884 | 11884 | 1270 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5992245.7583099995 | 2087252.3125599998 | 37.7107521351809 | -122.46861119345101 | (37.7107521351809, -122.468611193451) | |||
12454 | 12454 | 1277 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992498.771269999 | 2087369.1133 | 37.7110874546035 | -122.46774522006099 | (37.7110874546035, -122.467745220061) | |||
12581 | 12581 | 1281 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992683.69403 | 2087456.96265 | 37.7113393439098 | -122.46711247059099 | (37.7113393439098, -122.467112470591) | |||
13079 | 13079 | 1273 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | Permit Number 771193 | 5992398.03069 | 2087322.1494900002 | 37.710952685801104 | -122.46808998688499 | (37.7109526858011, -122.468089986885) | ||
13163 | 13163 | 1267 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5992203.06147 | 2087231.00688 | 37.710691168335096 | -122.468757212784 | (37.7106911683351, -122.468757212784) | |||
13410 | 13410 | 14990 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016422.4428900005 | 2097376.45794 | 37.7399180286864 | -122.385755471644 | (37.7399180286864, -122.385755471644) | |||
13495 | 13495 | 14948 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016767.4558 | 2097838.85848 | 37.7412067724716 | -122.384594749942 | (37.7412067724716, -122.384594749942) | |||
13625 | 13625 | 14933 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016941.57525 | 2098184.84614 | 37.7421664120423 | -122.384016788063 | (37.7421664120423, -122.384016788063) | |||
13778 | 13778 | 26456 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 401X Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/13/1997 12:00:00 AM | 6 | 3x3 | 6017743.988609999 | 2096808.9329900001 | 37.7384327587528 | -122.381146620635 | (37.7384327587528, -122.381146620635) | ||
13789 | 13789 | 14992 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016399.93011 | 2097341.84893 | 37.739821753578504 | -122.385830900501 | (37.7398217535785, -122.385830900501) | |||
13826 | 13826 | 26458 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 401X Keith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017771.22225 | 2096841.3441599999 | 37.738523256636896 | -122.381054711725 | (37.7385232566369, -122.381054711725) | |||
13834 | 13834 | 14938 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016907.69513 | 2098053.9241400003 | 37.741805053675 | -122.38412482092501 | (37.741805053675, -122.384124820925) | |||
13902 | 13902 | 14887 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 151 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2006 12:00:00 AM | 3 | 3x3 | 6017068.53164 | 2098456.8281 | 37.7429202372855 | -122.38359673900699 | (37.7429202372855, -122.383596739007) | ||
14130 | 14130 | 12150 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/1996 12:00:00 AM | 2 | 3X3 | 6016234.16268 | 2095665.57813 | 37.735209878118 | -122.386287222793 | (37.735209878118, -122.386287222793) | ||
14260 | 14260 | 14934 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016937.56123 | 2098168.30957 | 37.742120784060795 | -122.38402951616301 | (37.7421207840608, -122.384029516163) | |||
14350 | 14350 | 12152 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/1996 12:00:00 AM | 6 | 3X3 | 6016198.01461 | 2095698.1267099997 | 37.7352972490591 | -122.386414469663 | (37.7352972490591, -122.386414469663) | ||
14352 | 14352 | 14936 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016920.64099 | 2098083.60989 | 37.7418872804668 | -122.38408212471201 | (37.7418872804668, -122.384082124712) | |||
14459 | 14459 | 14937 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016913.42346 | 2098066.4048200003 | 37.741839639797504 | -122.384105882978 | (37.7418396397975, -122.384105882978) | |||
14530 | 14530 | 12145 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6016306.3498599995 | 2095580.8792299998 | 37.734981307347205 | -122.386031740688 | (37.7349813073472, -122.386031740688) | |||
14566 | 14566 | 14942 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016868.17311 | 2097974.63279 | 37.7415851505377 | -122.38425595555401 | (37.7415851505377, -122.384255955554) | |||
15037 | 15037 | 14946 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016823.8175 | 2097912.1941299997 | 37.741411254039 | -122.38440497592899 | (37.741411254039, -122.384404975929) | |||
15253 | 15253 | 14890 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 151 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017084.252730001 | 2098515.6728 | 37.743082681818294 | -122.383546475015 | (37.7430826818183, -122.383546475015) | |||
15460 | 15460 | 14875 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 50 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017137.53448 | 2098765.92965 | 37.7437727810994 | -122.383379656173 | (37.7437727810994, -122.383379656173) | |||
15463 | 15463 | 14991 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016409.43425 | 2097357.66427 | 37.739865705229505 | -122.38579914093201 | (37.7398657052295, -122.385799140932) | |||
15486 | 15486 | 14943 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016856.6474 | 2097956.20405 | 37.7415339116704 | -122.38429452477101 | (37.7415339116704, -122.384294524771) | |||
15558 | 15558 | 14894 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 151 Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6017116.82626 | 2098595.36732 | 37.743303307108704 | -122.38343939001899 | (37.7433033071087, -122.383439390019) | ||
15647 | 15647 | 26457 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 401X Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/13/1997 12:00:00 AM | 6 | 3x3 | 6017757.31102 | 2096823.45757 | 37.7384733757484 | -122.381101567303 | (37.7384733757484, -122.381101567303) | ||
15691 | 15691 | 11881 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017730.140319999 | 2096877.36865 | 37.7386199049771 | -122.381199258841 | (37.7386199049771, -122.381199258841) | |||
16015 | 16015 | 12144 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6016321.20053 | 2095553.30546 | 37.734906417192704 | -122.38597847472201 | (37.7349064171927, -122.385978474722) | |||
16139 | 16139 | 19754 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY15 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
16206 | 16206 | 12124 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016510.880609999 | 2095043.15703 | 37.733516147150794 | -122.38528714160499 | (37.7335161471508, -122.385287141605) | |||
16235 | 16235 | 11882 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2002 12:00:00 AM | 6 | 3X3 | 6017717.79122 | 2096860.5282400001 | 37.73857298286829 | -122.38124078595399 | (37.7385729828683, -122.381240785954) | ||
16296 | 16296 | 14940 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016890.87226 | 2098016.163 | 37.7417004391255 | -122.38418036034099 | (37.7417004391255, -122.384180360341) | |||
16332 | 16332 | 26455 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 401X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | Permit Number 769095 | 6017718.24501 | 2096772.8589700002 | 37.738332285595206 | -122.381233122826 | (37.7383322855952, -122.381233122826) | ||
16335 | 16335 | 14985 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016500.60947 | 2097476.87493 | 37.740198078478706 | -122.385492197802 | (37.7401980784787, -122.385492197802) | |||
16427 | 16427 | 4769 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 20 Commer Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6016624.63849 | 2094705.64307 | 37.732595693724605 | -122.384870339116 | (37.7325956937246, -122.384870339116) | |||
16431 | 16431 | 14935 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/14/1989 12:00:00 AM | 12 | 3X3 | 6016933.70411 | 2098147.37147 | 37.742063079043206 | -122.38404139529699 | (37.7420630790432, -122.384041395297) | ||
16630 | 16630 | 4771 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 20 Commer Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6016532.61927 | 2094742.5477 | 37.7326919364855 | -122.385191045451 | (37.7326919364855, -122.385191045451) | |||
16793 | 16793 | 14986 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016489.59625 | 2097461.2360400003 | 37.7401545279128 | -122.385529187825 | (37.7401545279128, -122.385529187825) | |||
17200 | 17200 | 4330 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 831 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001821.43184 | 2095823.4199 | 37.7348349741444 | -122.436128498656 | (37.7348349741444, -122.436128498656) | |||
17365 | 17365 | 2069 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 843 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001701.031909999 | 2095490.9133099997 | 37.7339151466682 | -122.43652097087299 | (37.7339151466682, -122.436520970873) | |||
17402 | 17402 | 2557 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1101 Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001119.92736 | 2095647.46626 | 37.7343119662085 | -122.43854123490802 | (37.7343119662085, -122.438541234908) | |||
17615 | 17615 | 12962 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 65 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001964.35979 | 2095666.44125 | 37.734412066167394 | -122.435623121007 | (37.7344120661674, -122.435623121007) | |||
17626 | 17626 | 5082 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2563 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002286.6614 | 2096942.37452 | 37.7379337860994 | -122.434600024386 | (37.7379337860994, -122.434600024386) | |||
17705 | 17705 | 4348 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 924 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001433.25109 | 2095991.10142 | 37.735273327102796 | -122.43748257546999 | (37.7352733271028, -122.43748257547) | |||
17765 | 17765 | 16205 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 508 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998710.56573 | 2094730.4194599998 | 37.7316566225543 | -122.44680517802401 | (37.7316566225543, -122.446805178024) | |||
17846 | 17846 | 5083 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2566 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6002238.293895099 | 2096914.6597978 | 37.7378549419938 | -122.434765273064 | (37.7378549419938, -122.434765273064) | |||
17901 | 17901 | 16237 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 582 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5998240.26407 | 2094738.81412 | 37.7316527941384 | -122.448431701761 | (37.7316527941384, -122.448431701761) | |||
18008 | 18008 | 4349 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 925 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001343.36929 | 2095994.0746099998 | 37.735276380288795 | -122.437793542132 | (37.7352763802888, -122.437793542132) | |||
18048 | 18048 | 19161 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 91 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 6003505.743559999 | 2107783.3498 | 37.7677696781622 | -122.431158635477 | (37.7677696781622, -122.431158635477) | |||
18112 | 18112 | 16175 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 435 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999172.6391900005 | 2094646.32207 | 37.7314520969304 | -122.445201659842 | (37.7314520969304, -122.445201659842) | |||
18208 | 18208 | 25235 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1495 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 5995409.5475 | 2092077.8007 | 37.7241840406255 | -122.45802548285201 | (37.7241840406255, -122.458025482852) | |||
18247 | 18247 | 4314 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 730 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002222.872380001 | 2095754.0760700002 | 37.7346673711025 | -122.434735624149 | (37.7346673711025, -122.434735624149) | |||
18249 | 18249 | 4385 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5 Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001732.01968 | 2095763.05053 | 37.734664133544506 | -122.43643330766001 | (37.7346641335445, -122.43643330766) | |||
18349 | 18349 | 4320 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 20X Brompton Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002191.35969 | 2095656.04517 | 37.7343964116617 | -122.434837565898 | (37.7343964116617, -122.434837565898) | |||
18773 | 18773 | 24545 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 704 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X4 | 6007936.0377400005 | 2097164.78596 | 37.7388635691031 | -122.415083035373 | (37.7388635691031, -122.415083035373) | |||
18857 | 18857 | 2085 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 921 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001545.78168 | 2095530.67878 | 37.734015510104896 | -122.437060563206 | (37.7340155101049, -122.437060563206) | |||
18905 | 18905 | 2050 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001988.91143 | 2095411.22902 | 37.733712706561896 | -122.435519986756 | (37.7337127065619, -122.435519986756) | |||
18927 | 18927 | 16200 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998771.6064 | 2094729.9860599998 | 37.731658919424504 | -122.446594117934 | (37.7316589194245, -122.446594117934) | |||
18940 | 18940 | 4329 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 828 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6001820.48709 | 2095859.0092200001 | 37.7349326405301 | -122.436134310946 | (37.7349326405301, -122.436134310946) |
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");