Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18 | 18 | 96369 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 168 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767919 | 6001162.44444 | 2121276.45677 | 37.8046852096195 | -122.44023153767799 | (37.8046852096195, -122.440231537678) | |
| 31 | 31 | 22614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.781365013820206 | -122.424863625752 | (37.7813650138202, -122.424863625752) | |||
| 85 | 85 | 22613 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168001 | (37.7813375942673, -122.42509837168) | |||
| 105 | 105 | 6251 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/06/2003 12:00:00 AM | 24 | 3X3 | 6004480.8051 | 2113256.6545 | 37.7828532389184 | -122.428176124144 | (37.7828532389184, -122.428176124144) | ||
| 106 | 106 | 10645 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 906 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6003455.1435 | 2110726.9996 | 37.775849351151706 | -122.431543829861 | (37.7758493511517, -122.431543829861) | |||
| 129 | 129 | 20398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 215 | 215 | 17196 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004629.787409999 | 2116932.39582 | 37.792954330542 | -122.42792271466601 | (37.792954330542, -122.427922714666) | |||
| 340 | 340 | 191854 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 573 10th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 24 | Width 6ft | tree is in ROW therefore DPW maintained | 6009977.72395 | 2108375.30106 | 37.7697596664942 | -122.408814503513 | (37.7697596664942, -122.408814503513) | ||
| 452 | 452 | 221749 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 24 | Width 4ft | 5997432.91763 | 2106413.5715 | 37.763662611962 | -122.452064861225 | (37.763662611962, -122.452064861225) | |||
| 464 | 464 | 18999 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3039 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6000252.38525 | 2115449.79519 | 37.7886348840283 | -122.442962190565 | (37.7886348840283, -122.442962190565) | |||
| 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) | |||
| 823 | 823 | 13156 | Permitted Site 1 | Tristania conferta :: 79 | 1875 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003411.9498 | 2119598.2407 | 37.800205081624604 | -122.432326975222 | (37.8002050816246, -122.432326975222) | |||
| 945 | 945 | 26844 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | Permit Number 775213 | 6006969.72882 | 2110998.7322 | 37.7767940394414 | -122.419405236481 | (37.7767940394414, -122.419405236481) | ||
| 1020 | 1020 | 10701 | DPW Maintained 3 | Tristania conferta :: 79 | 1290 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001704.3359 | 2110485.9297 | 37.7750880443133 | -122.43758304169201 | (37.7750880443133, -122.437583041692) | |||
| 1153 | 1153 | 17806 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1881 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6004903.5356 | 2115394.9801 | 37.7887484569995 | -122.42686598915199 | (37.7887484569995, -122.426865989152) | |||
| 1271 | 1271 | 19821 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY25 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 10ST | ||||||||
| 1393 | 1393 | 19861 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY30 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 30ST | ||||||||
| 1429 | 1429 | 102682 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001423.65551 | 2115717.83054 | 37.7894375487454 | -122.438928994703 | (37.7894375487454, -122.438928994703) | |||
| 1440 | 1440 | 222893 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 301 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 4ft | 6004914.2278 | 2106488.73534 | 37.7642946914815 | -122.426194676362 | (37.7642946914815, -122.426194676362) | |||
| 1520 | 1520 | 199389 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 16 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 4ft | 6017439.78771 | 2096071.60272 | 37.7363914002406 | -122.38214713169901 | (37.7363914002406, -122.382147131699) | |||
| 1523 | 1523 | 142666 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2310 MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6008911.1908 | 2121214.7045 | 37.8049537680909 | -122.413411770849 | (37.8049537680909, -122.413411770849) | |||
| 1775 | 1775 | 245411 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2794 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6010069.4683 | 2102240.5937 | 37.7529202865107 | -122.408064458251 | (37.7529202865107, -122.408064458251) | |||
| 1784 | 1784 | 7098 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2006 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5997799.556 | 2109595.5069 | 37.772420388962296 | -122.451026246506 | (37.7724203889623, -122.451026246506) | |||
| 1843 | 1843 | 9890 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005344.337040001 | 2115550.48459 | 37.7892003471598 | -122.42535194865299 | (37.7892003471598, -122.425351948653) | |||
| 1954 | 1954 | 20331 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 2107 | 2107 | 250672 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 726 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 5986349.68151 | 2114864.86182 | 37.786226371002705 | -122.491019750162 | (37.7862263710027, -122.491019750162) | |||
| 2269 | 2269 | 125219 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2269 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 4ft | 6003923.5815 | 2115960.33762 | 37.7902453288032 | -122.430296840347 | (37.7902453288032, -122.430296840347) | |||
| 2300 | 2300 | 6356 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1234X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001371.4698 | 2112650.1535 | 37.7810115248297 | -122.438889623593 | (37.7810115248297, -122.438889623593) | |||
| 2346 | 2346 | 14522 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 616 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5999189.6891 | 2110673.8503 | 37.7754607324086 | -122.446295246866 | (37.7754607324086, -122.446295246866) | |||
| 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) | |||
| 2472 | 2472 | 224776 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 6ft | 6005221.0 | 2098972.0 | 37.743672820465896 | -122.42459890056001 | (37.7436728204659, -122.42459890056) | |||
| 2506 | 2506 | 10385 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1330 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/2017 12:00:00 AM | 24 | 3X3 | 5999759.2979999995 | 2108827.6222 | 37.7704239730353 | -122.444192144461 | (37.7704239730353, -122.444192144461) | ||
| 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) | |||
| 2557 | 2557 | 139640 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 0ft | 6001669.0 | 2112367.0 | 37.7802509803634 | -122.437840034507 | (37.7802509803634, -122.437840034507) | |||
| 2714 | 2714 | 141996 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 WEBSTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 0ft | 6003983.1859 | 2111655.6546 | 37.7784291232811 | -122.42978344870899 | (37.7784291232811, -122.429783448709) | |||
| 2750 | 2750 | 23535 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005732.6393 | 2119914.78395 | 37.8012055419589 | -122.424319001733 | (37.8012055419589, -122.424319001733) | |||
| 2971 | 2971 | 7062 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6000002.1366 | 2109905.8257 | 37.773398298516 | -122.44342962722 | (37.773398298516, -122.44342962722) | |||
| 3010 | 3010 | 245175 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1128 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 0ft | 6000703.1785 | 2108961.6377 | 37.770845749220705 | -122.44093688299 | (37.7708457492207, -122.44093688299) | |||
| 3107 | 3107 | 18939 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 2760 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6001611.94448 | 2115686.46462 | 37.78936213699829 | -122.438275289198 | (37.7893621369983, -122.438275289198) | |||
| 3329 | 3329 | 110970 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2485 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6002790.71835 | 2116462.02658 | 37.791558605188705 | -122.434252340185 | (37.7915586051887, -122.434252340185) | |||
| 3499 | 3499 | 85478 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1745 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6007333.51995 | 2118328.0568 | 37.7969390538357 | -122.41866665564699 | (37.7969390538357, -122.418666655647) | |||
| 3572 | 3572 | 7105 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2130 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 5997237.8283 | 2109516.8856 | 37.7721723399981 | -122.452963630149 | (37.7721723399981, -122.452963630149) | |||
| 3616 | 3616 | 97137 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2929 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 24 | 3x3 | Permit Number 776885 | 6000677.09541 | 2116163.2813 | 37.790618136459706 | -122.441543981264 | (37.7906181364597, -122.441543981264) | |
| 3684 | 3684 | 27830 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013136.88249 | 2119351.75589 | 37.800074911578 | -122.398657381345 | (37.800074911578, -122.398657381345) | |||
| 3757 | 3757 | 6923 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 436 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005320.8239 | 2110648.3853 | 37.775739063409794 | -122.425084363796 | (37.7757390634098, -122.425084363796) | |||
| 3767 | 3767 | 7104 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2100 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5997303.9815 | 2109524.8914 | 37.7721981126985 | -122.452735379757 | (37.7721981126985, -122.452735379757) | |||
| 3794 | 3794 | 29684 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2000X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6006028.673359999 | 2117355.72849 | 37.7941957348865 | -122.42311259358699 | (37.7941957348865, -122.423112593587) | ||||
| 4308 | 4308 | 102694 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2799 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001416.78196 | 2115941.58593 | 37.7900515321059 | -122.43896881846202 | (37.7900515321059, -122.438968818462) | |||
| 4476 | 4476 | 94930 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1771 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004538.80013 | 2118744.2703 | 37.7979241280397 | -122.428366733352 | (37.7979241280397, -122.428366733352) | |||
| 4482 | 4482 | 20388 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 4639 | 4639 | 102681 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001426.627069999 | 2115693.54787 | 37.7893710438761 | -122.43891697256399 | (37.7893710438761, -122.438916972564) | |||
| 5088 | 5088 | 206891 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1675x 15th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | Width 3ft | 5991393.559640001 | 2103864.47578 | 37.756315678748706 | -122.472767037095 | (37.7563156787487, -122.472767037095) | |||
| 5160 | 5160 | 27393 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 2256 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6007130.3947 | 2120101.3253099998 | 37.8017965647292 | -122.41949538901899 | (37.8017965647292, -122.419495389019) | |||
| 5167 | 5167 | 27271 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2134 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2X2 | 6006018.78384 | 2117780.42149 | 37.7953612769429 | -122.42317701472 | (37.7953612769429, -122.42317701472) | |||
| 5282 | 5282 | 20344 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 40 | ||||||||
| 5337 | 5337 | 14719 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 871 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5x5 | 6005011.2646 | 2111934.1612 | 37.779251997589 | -122.426246769427 | (37.779251997589, -122.426246769427) | |||
| 5356 | 5356 | 17193 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004642.48731 | 2116869.91995 | 37.792783506093706 | -122.427874318555 | (37.7927835060937, -122.427874318555) | |||
| 5391 | 5391 | 27795 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 24 | 6013107.19159 | 2119396.29372 | 37.8001955475498 | -122.398763251324 | (37.8001955475498, -122.398763251324) | |||
| 5422 | 5422 | 4684 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 722 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6009311.9987 | 2119994.7358 | 37.801626533850204 | -122.411938460907 | (37.8016265338502, -122.411938460907) | |||
| 5461 | 5461 | 23583 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 3100X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005493.5455 | 2121226.7269099997 | 37.8047942964921 | -122.425239779807 | (37.8047942964921, -122.425239779807) | |||
| 5496 | 5496 | 99696 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1451 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6007201.17567 | 2117403.71838 | 37.794393599230204 | -122.41905900288799 | (37.7943935992302, -122.419059002888) | ||
| 5517 | 5517 | 10700 | DPW Maintained 3 | Tristania conferta :: 79 | 1290 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001738.9392 | 2110489.0192 | 37.775098494652795 | -122.437463562764 | (37.7750984946528, -122.437463562764) | |||
| 5555 | 5555 | 8527 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002529.8149 | 2113677.2092 | 37.7838973955703 | -122.434955812258 | (37.7838973955703, -122.434955812258) | |||
| 5622 | 5622 | 87285 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1820 Webster St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 50302 | 6003460.507999999 | 2115059.4384 | 37.7877454479518 | -122.43183468665801 | (37.7877454479518, -122.431834686658) | ||
| 5704 | 5704 | 17832 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1977 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6004499.0246 | 2115333.9095 | 37.7885578925396 | -122.428261185185 | (37.7885578925396, -122.428261185185) | |||
| 5726 | 5726 | 19857 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY30 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 30ST | ||||||||
| 5730 | 5730 | 4720 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1040 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5x5 | 6008353.7979 | 2120870.8765 | 37.8039783914932 | -122.415316341899 | (37.8039783914932, -122.415316341899) | |||
| 5737 | 5737 | 20074 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY55 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 27X | ||||||||
| 5850 | 5850 | 26674 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1825 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003781.9718 | 2114546.3993 | 37.786354989662705 | -122.430685859171 | (37.7863549896627, -122.430685859171) | |||
| 5902 | 5902 | 27389 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6007143.328369999 | 2120019.7231400004 | 37.801573234283296 | -122.419444839906 | (37.8015732342833, -122.419444839906) | |||
| 5949 | 5949 | 19787 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 100 STAIRWAY19 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 50ST | ||||||||
| 5973 | 5973 | 12978 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 300 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6010840.9455 | 2120711.3367 | 37.803679804278104 | -122.40669811093099 | (37.8036798042781, -122.406698110931) | |||
| 5984 | 5984 | 10644 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 906 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6003470.6525 | 2110728.6613 | 37.775854792789296 | -122.431490298947 | (37.7758547927893, -122.431490298947) | |||
| 6006 | 6006 | 20312 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 101X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 6068 | 6068 | 13109 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1599 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 24 | 3x3 | 6004827.8666 | 2119796.0468 | 37.8008283892799 | -122.427441448129 | (37.8008283892799, -122.427441448129) | ||
| 6081 | 6081 | 19239 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 659 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002066.7434 | 2110793.9605 | 37.7759544182775 | -122.436351446483 | (37.7759544182775, -122.436351446483) | |||
| 6086 | 6086 | 7024 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1124 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002012.3902 | 2110183.0208 | 37.774273842043904 | -122.43649573066601 | (37.7742738420439, -122.436495730666) | |||
| 6122 | 6122 | 23406 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1748X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006168.03383 | 2116381.79756 | 37.7915294275986 | -122.42256115088499 | (37.7915294275986, -122.422561150885) | |||
| 6163 | 6163 | 27270 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2080 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006058.24019 | 2117527.2274 | 37.7946682962453 | -122.423022484211 | (37.7946682962453, -122.423022484211) | |||
| 6206 | 6206 | 11122 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2111 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/1991 12:00:00 AM | 24 | 3X3 | 6007154.50985 | 2119579.5735 | 37.800365324253 | -122.41937490413099 | (37.800365324253, -122.419374904131) | ||
| 6221 | 6221 | 10646 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 906 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6003440.7423 | 2110725.3379 | 37.7758439722804 | -122.431593528606 | (37.7758439722804, -122.431593528606) | |||
| 6222 | 6222 | 27831 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013146.80764 | 2119335.33451 | 37.8000303753641 | -122.39862188328699 | (37.8000303753641, -122.398621883287) | |||
| 6227 | 6227 | 113069 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3108 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6002430.41421 | 2118968.02976 | 37.7984189836099 | -122.43567835378 | (37.7984189836099, -122.43567835378) | |||
| 6384 | 6384 | 96370 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 168 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767919 | 6001150.89126 | 2121288.6307 | 37.8047179782121 | -122.440272392077 | (37.8047179782121, -122.440272392077) | |
| 6394 | 6394 | 8581 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6000715.1007 | 2113420.9091 | 37.7830904567466 | -122.441215640748 | (37.7830904567466, -122.441215640748) | |||
| 6397 | 6397 | 18075 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2945 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999836.3647 | 2114682.6256 | 37.786504708751 | -122.444346400919 | (37.786504708751, -122.444346400919) | |||
| 6402 | 6402 | 23443 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2100X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005986.240069999 | 2117685.53144 | 37.7950988961632 | -122.423282873032 | (37.7950988961632, -122.423282873032) | |||
| 6409 | 6409 | 17195 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2235X Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004631.93349 | 2116900.78038 | 37.7928676439669 | -122.427913035268 | (37.7928676439669, -122.427913035268) | |||
| 6431 | 6431 | 6926 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 474 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005147.8848 | 2110623.4947 | 37.7756609491529 | -122.425680831948 | (37.7756609491529, -122.425680831948) | |||
| 6438 | 6438 | 113068 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3108 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6002431.85216 | 2118952.17162 | 37.7983755229712 | -122.43567224288799 | (37.7983755229712, -122.435672242888) | |||
| 6443 | 6443 | 19238 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 659 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002061.8001 | 2110816.8234 | 37.7760169132006 | -122.43637018327499 | (37.7760169132006, -122.436370183275) | |||
| 6511 | 6511 | 19865 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY30 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 100ST | ||||||||
| 6544 | 6544 | 8114 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 830 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/1991 12:00:00 AM | 24 | 3X3 | 6003807.6781 | 2111475.048 | 37.7779232822146 | -122.430377706699 | (37.7779232822146, -122.430377706699) | ||
| 6676 | 6676 | 102748 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2900 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x5 | Permit Number 20974 | 6001048.4849 | 2118395.3154599997 | 37.7967678705825 | -122.440419145231 | (37.7967678705825, -122.440419145231) | ||
| 6683 | 6683 | 7097 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1988 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x6 | 5997952.7475 | 2109617.0075 | 37.7724881931803 | -122.450497895204 | (37.7724881931803, -122.450497895204) | |||
| 6707 | 6707 | 97136 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2929 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 24 | 3x3 | Permit Number 776885 | 6000665.32299 | 2116159.50281 | 37.790607091004404 | -122.441584441793 | (37.7906070910044, -122.441584441793) | |
| 6799 | 6799 | 20078 | DPW Maintained 3 | Fraxinus velutina 'Glabra' :: Arizona Ash 242 | 100 STAIRWAY56 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5X5 | ||||||||
| 6828 | 6828 | 11159 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2627 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006915.19061 | 2121341.6845 | 37.8051901519615 | -122.420328183697 | (37.8051901519615, -122.420328183697) | |||
| 6857 | 6857 | 18904 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6002312.77813 | 2115782.03277 | 37.789664378452 | -122.435857329676 | (37.789664378452, -122.435857329676) | |||
| 6864 | 6864 | 99895 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2101X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 768908 | 6004333.92311 | 2116670.5989599996 | 37.7922187606381 | -122.428927747522 | (37.7922187606381, -122.428927747522) |
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");