Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, 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) | ||||
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) | |||
794 | 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 | 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 | 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 | 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 | 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) | ||||
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) | |||
821 | 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 | 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) | |||
1277 | 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 | 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 | 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) | ||||
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) | |||
2620 | 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) | |||
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) | |||
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) | |||
3898 | 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) | ||||
5451 | 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) | |||
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 | ||||||||
7149 | 7149 | 23486 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005800.3407 | 2119014.80575 | 37.7987382537111 | -122.424020688524 | (37.7987382537111, -122.424020688524) | |||
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) | |||
7904 | 7904 | 23169 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 202X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006882.10264 | 2111252.84384 | 37.777486833097896 | -122.419726396954 | (37.7774868330979, -122.419726396954) | |||
8048 | 8048 | 23233 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006624.19189 | 2113053.59601 | 37.782416729491 | -122.42074646829799 | (37.782416729491, -122.420746468298) | |||
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) | |||
8553 | 8553 | 23232 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006628.60579 | 2113016.72655 | 37.7823157437221 | -122.42072857987301 | (37.7823157437221, -122.420728579873) | |||
8649 | 8649 | 23408 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1748X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006154.759930001 | 2116452.2699700003 | 37.7917221783851 | -122.42261208848801 | (37.7917221783851, -122.422612088488) | |||
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) | |||
9682 | 9682 | 13402 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Marietta Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | 5x10 | 5999116.0 | 2097588.0 | 37.7395260150228 | -122.445608931545 | (37.7395260150228, -122.445608931545) | |||
9685 | 9685 | 111779 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 356 Marietta Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 5999368.0 | 2097504.0 | 37.7393097549515 | -122.44473159198601 | (37.7393097549515, -122.444731591986) | ||||
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) | |||
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) | |||
10926 | 10926 | 15989 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 236 Moncada Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35M | 5992398.75579 | 2093455.53191 | 37.7277935021904 | -122.468533444909 | (37.7277935021904, -122.468533444909) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
17538 | 17538 | 30052 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 5991303.9336 | 2092006.82804 | 37.723752419029005 | -122.4722126725 | (37.723752419029, -122.4722126725) | |||
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) | |||
17715 | 17715 | 16378 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Moraga St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 5991088.16435 | 2103840.65792 | 37.756232597572605 | -122.473821451692 | (37.7562325975726, -122.473821451692) | |||
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) |
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");