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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 110 | 110 | 97646 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1824 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5988290.0 | 2103126.0 | 37.7541078738982 | -122.48344595561899 | (37.7541078738982, -122.483445955619) | |||
| 260 | 260 | 221893 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.751004337584796 | -122.41309273944599 | (37.7510043375848, -122.413092739446) | |||
| 460 | 460 | 142327 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1652 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999940.0 | 2110256.0 | 37.774356244626205 | -122.44366972691601 | (37.7743562446262, -122.443669726916) | |||
| 470 | 470 | 98535 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1805X Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x6 | Permit Number 779899 | 5999990.232999999 | 2115142.7171 | 37.7877767779168 | -122.44384712433799 | (37.7877767779168, -122.443847124338) | ||
| 777 | 777 | 234744 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 15th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | Width 3ft | 6001486.4222099995 | 2107220.2274599997 | 37.766108846174795 | -122.438102867577 | (37.7661088461748, -122.438102867577) | |||
| 1261 | 1261 | 122608 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1214 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5987092.2626 | 2106978.1702 | 37.7646150951119 | -122.487870979055 | (37.7646150951119, -122.487870979055) | |||
| 1437 | 1437 | 111252 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3129x Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5983208.5024 | 2097401.5189 | 37.7380929647396 | -122.500595473335 | (37.7380929647396, -122.500595473335) | |||
| 1803 | 1803 | 200050 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1590 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6014991.2562 | 2094154.9788 | 37.730993203361 | -122.39047892232401 | (37.730993203361, -122.390478922324) | |||
| 1871 | 1871 | 176854 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | |||
| 1888 | 1888 | 100797 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2471 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002362.24857 | 2116725.90576 | 37.7922588209311 | -122.435753725979 | (37.7922588209311, -122.435753725979) | |||
| 1895 | 1895 | 222302 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 151 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x4 | 6007412.8768 | 2100213.34589 | 37.7472048215433 | -122.41710784185499 | (37.7472048215433, -122.417107841855) | |||
| 1896 | 1896 | 236582 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 607 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | Permit Number 779645 | 6009292.7773400005 | 2105398.5203400003 | 37.7615477221736 | -122.410973441191 | (37.7615477221736, -122.410973441191) | ||
| 2093 | 2093 | 177161 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007505.03845 | 2087315.4239400001 | 37.711795103221604 | -122.41587597032499 | (37.7117951032216, -122.415875970325) | |||
| 2307 | 2307 | 122432 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | Permit Number 778941 | 6013714.3488 | 2114207.9998 | 37.7859835205848 | -122.396298394128 | (37.7859835205848, -122.396298394128) | ||
| 2313 | 2313 | 201193 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 611 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 778941 | 6013579.6483 | 2113996.1808 | 37.7853944182999 | -122.39674956946399 | (37.7853944182999, -122.396749569464) | ||
| 2358 | 2358 | 195024 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013723.336209999 | 2113877.98804 | 37.785077884566604 | -122.39624416214 | (37.7850778845666, -122.39624416214) | |||
| 2521 | 2521 | 141908 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004604.7205 | 2111934.4347 | 37.779229760906205 | -122.42765319377199 | (37.7792297609062, -122.427653193772) | |||
| 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) | |||
| 2689 | 2689 | 207839 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 626X Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994826.85492 | 2091253.8672900002 | 37.721888220645 | -122.459980091334 | (37.721888220645, -122.459980091334) | |||
| 2690 | 2690 | 126183 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1451 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003793.92894 | 2120715.46368 | 37.803294337014606 | -122.431084963893 | (37.8032943370146, -122.431084963893) | |||
| 2692 | 2692 | 100830 | Undocumented 2 | Ficus rubiginosa :: Port Jackson Fig 188 | 1601X North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003038.84698 | 2120959.7606900004 | 37.8039222967503 | -122.433715418836 | (37.8039222967503, -122.433715418836) | |||
| 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) | |||
| 2740 | 2740 | 72022 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 550 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1989 12:00:00 AM | 12 | 4x4 | 6010599.26481 | 2116134.30998 | 37.791098878065796 | -122.40721162653401 | (37.7910988780658, -122.407211626534) | ||
| 2747 | 2747 | 177162 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 780274 | 6007512.10716 | 2087312.1903 | 37.711786621718296 | -122.415851310014 | (37.7117866217183, -122.415851310014) | ||
| 2758 | 2758 | 177160 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 780274 | 6007458.52227 | 2087256.96391 | 37.7116319689192 | -122.416032606129 | (37.7116319689192, -122.416032606129) | ||
| 2852 | 2852 | 215287 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | Permit Number 780412 | 5992944.71929 | 2103190.50616 | 37.7545548052666 | -122.46735363008301 | (37.7545548052666, -122.467353630083) | ||
| 2858 | 2858 | 110567 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 779053 | 6009356.33336 | 2110648.62955 | 37.77596687089571 | -122.411124487731 | (37.7759668708957, -122.411124487731) | ||
| 2895 | 2895 | 114573 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3621 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5997465.48926 | 2115720.33673 | 37.7892184334409 | -122.452623918478 | (37.7892184334409, -122.452623918478) | |||
| 3051 | 3051 | 99233 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008063.2168 | 2121048.832 | 37.8044506767497 | -122.416334531861 | (37.8044506767497, -122.416334531861) | |||
| 3064 | 3064 | 104743 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010761.049240001 | 2116971.9366099997 | 37.7934078523287 | -122.406710911 | (37.7934078523287, -122.406710911) | |||
| 3067 | 3067 | 104742 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010759.24365 | 2116982.20549 | 37.793435947175205 | -122.406717882525 | (37.7934359471752, -122.406717882525) | |||
| 3474 | 3474 | 106212 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 585X Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 12 | 3x5 | 6010752.41967 | 2115858.63176 | 37.790350501826204 | -122.406662277468 | (37.7903505018262, -122.406662277468) | |||
| 3579 | 3579 | 123325 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 798 05th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Permit Number 780721 | 5994467.5512 | 2110242.48836 | 37.7740055063811 | -122.46259882484101 | (37.7740055063811, -122.462598824841) | |||
| 3607 | 3607 | 107433 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3000 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999745.83562 | 2116735.23196 | 37.792135462722705 | -122.444807206383 | (37.7921354627227, -122.444807206383) | |||
| 3632 | 3632 | 122539 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3443 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 779060 | 5998247.97366 | 2115501.74936 | 37.788663053514 | -122.44990087023001 | (37.788663053514, -122.44990087023) | ||
| 3656 | 3656 | 215669 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 100 Cortes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2016 12:00:00 AM | 12 | Width 3ft | Permit Number 777819 | 5993202.34131 | 2099405.04852 | 37.7441757763018 | -122.46618763477 | (37.7441757763018, -122.46618763477) | |
| 3844 | 3844 | 246107 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1899 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997126.5002 | 2108412.0556 | 37.7691323812935 | -122.453268945279 | (37.7691323812935, -122.453268945279) | |||
| 4190 | 4190 | 100829 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1601X North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003036.60353 | 2120959.36193 | 37.803921074561295 | -122.43372315391198 | (37.8039210745613, -122.433723153912) | |||
| 4221 | 4221 | 244055 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997910.1594 | 2109123.3007 | 37.771130163517704 | -122.450609610411 | (37.7711301635177, -122.450609610411) | |||
| 4230 | 4230 | 244048 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 400 Cole St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997950.1933 | 2109141.0477 | 37.771181183618395 | -122.45047241196801 | (37.7711811836184, -122.450472411968) | |||
| 4621 | 4621 | 122573 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2014 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6003898.8446 | 2115409.2515 | 37.7887307847056 | -122.430343093484 | (37.7887307847056, -122.430343093484) | |||
| 4731 | 4731 | 237544 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 7x8 | 6003442.2831 | 2105633.6495 | 37.76186352451221 | -122.43122467539801 | (37.7618635245122, -122.431224675398) | |||
| 5076 | 5076 | 227766 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 65 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6000997.83471 | 2101277.8848900003 | 37.749764821811 | -122.439366802634 | (37.749764821811, -122.439366802634) | |||
| 5162 | 5162 | 110966 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2445 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x5 | 6003013.8449 | 2116487.52825 | 37.791641287967 | -122.433482149098 | (37.791641287967, -122.433482149098) | |||
| 5376 | 5376 | 112253 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3401 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5998472.27762 | 2115859.72352 | 37.789658787381796 | -122.449150614422 | (37.7896587873818, -122.449150614422) | |||
| 5501 | 5501 | 99227 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008003.9616 | 2121103.5041 | 37.8045974602939 | -122.416543465428 | (37.8045974602939, -122.416543465428) | |||
| 5526 | 5526 | 99210 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007993.4855 | 2121112.3432 | 37.8046211410646 | -122.416580345595 | (37.8046211410646, -122.416580345595) | |||
| 5636 | 5636 | 100827 | Undocumented 2 | Ficus rubiginosa :: Port Jackson Fig 188 | 3661 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003081.8479 | 2120946.98391 | 37.8038896549426 | -122.433565697914 | (37.8038896549426, -122.433565697914) | |||
| 5669 | 5669 | 102626 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2039 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001408.07759 | 2115496.16268 | 37.7888280197366 | -122.43896700003799 | (37.7888280197366, -122.438967000038) | |||
| 5762 | 5762 | 107230 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1445 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005960.15833 | 2119639.59713 | 37.8004627936866 | -122.423512110213 | (37.8004627936866, -122.423512110213) | |||
| 5817 | 5817 | 103362 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009111.87446 | 2116690.2667799997 | 37.7925420462198 | -122.41239727931601 | (37.7925420462198, -122.412397279316) | ||
| 5868 | 5868 | 106881 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3261 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778851 | 5999192.38841 | 2115631.9922700003 | 37.789074657915 | -122.446642721777 | (37.789074657915, -122.446642721777) | ||
| 6038 | 6038 | 103363 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009142.2805 | 2116694.47646 | 37.79255531122121 | -122.412292370693 | (37.7925553112212, -122.412292370693) | ||
| 6124 | 6124 | 100807 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2401 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002634.35526 | 2116761.0817299997 | 37.7923708575934 | -122.4348147492 | (37.7923708575934, -122.4348147492) | |||
| 6213 | 6213 | 99229 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008022.9494 | 2121084.5162 | 37.804546392141496 | -122.416476410342 | (37.8045463921415, -122.416476410342) | |||
| 6245 | 6245 | 100808 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2401 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002651.17595 | 2116762.40631 | 37.7923754495237 | -122.43475664402399 | (37.7923754495237, -122.434756644024) | |||
| 6287 | 6287 | 102623 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 351 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010148.1574 | 2120916.7901 | 37.80420514282329 | -122.40911005673401 | (37.8042051428233, -122.409110056734) | |||
| 6622 | 6622 | 103365 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009208.54849 | 2116702.7837799997 | 37.7925818394263 | -122.412063667702 | (37.7925818394263, -122.412063667702) | ||
| 6739 | 6739 | 99228 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008013.4555 | 2121093.6827 | 37.8045710271276 | -122.416509914664 | (37.8045710271276, -122.416509914664) | |||
| 6756 | 6756 | 100826 | Undocumented 2 | Ficus rubiginosa :: Port Jackson Fig 188 | 3661 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003080.13774 | 2120956.29501 | 37.803915123748105 | -122.433572281852 | (37.8039151237481, -122.433572281852) | |||
| 7216 | 7216 | 92890 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 800 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Tree no. 2 on Montgomery | 6011720.98401 | 2118117.86666 | 37.796607963049 | -122.403470105059 | (37.796607963049, -122.403470105059) | ||
| 7337 | 7337 | 106720 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1447 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999672.1743 | 2113882.1261 | 37.7842973761464 | -122.44485689337401 | (37.7842973761464, -122.444856893374) | |||
| 7403 | 7403 | 107472 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1464 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6007706.0171300005 | 2117181.73808 | 37.793812512193604 | -122.417296448573 | (37.7938125121936, -122.417296448573) | |||
| 7611 | 7611 | 93477 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113X Leroy Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1.5x3 | Tree 2 on Leroy | 6008311.901880001 | 2116662.47431 | 37.7924208104303 | -122.415163251278 | (37.7924208104303, -122.415163251278) | ||
| 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) | |||
| 8068 | 8068 | 106333 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 319 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5997602.34127 | 2115286.79464 | 37.7880358825085 | -122.452119136194 | (37.7880358825085, -122.452119136194) | |||
| 8098 | 8098 | 100828 | Undocumented 2 | Ficus rubiginosa :: Port Jackson Fig 188 | 1601X North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003033.04227 | 2120970.8985599997 | 37.8039525490422 | -122.433736302911 | (37.8039525490422, -122.433736302911) | |||
| 8119 | 8119 | 93480 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1356- 1360 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2014 12:00:00 AM | 12 | 3x2 | Permit Number 770976 | 6008293.467119999 | 2116608.96674 | 37.7922728557673 | -122.415223246858 | (37.7922728557673, -122.415223246858) | |
| 8148 | 8148 | 99230 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008035.3898 | 2121073.3853 | 37.8045165290969 | -122.416432570152 | (37.8045165290969, -122.416432570152) | |||
| 8244 | 8244 | 99232 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008054.705 | 2121057.3439 | 37.8044735696368 | -122.416364591045 | (37.8044735696368, -122.416364591045) | |||
| 8322 | 8322 | 106721 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1445 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999673.9299 | 2113871.5922 | 37.7842685529811 | -122.444850062171 | (37.7842685529811, -122.444850062171) | |||
| 8375 | 8375 | 100825 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3661 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003069.70231 | 2120954.84645 | 37.803910554290795 | -122.43360829069401 | (37.8039105542908, -122.433608290694) | |||
| 8426 | 8426 | 99231 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008046.5206 | 2121063.2366 | 37.804489289265106 | -122.416393331612 | (37.8044892892651, -122.416393331612) | |||
| 8515 | 8515 | 105228 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2947 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000635.74462 | 2115830.45364 | 37.789701922466996 | -122.441663156727 | (37.789701922467, -122.441663156727) | |||
| 8535 | 8535 | 94877 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3043 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2010 12:00:00 AM | 12 | 3x3 | 6000192.74031 | 2115767.95632 | 37.7895050707416 | -122.443191412453 | (37.7895050707416, -122.443191412453) | ||
| 8604 | 8604 | 101074 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1969 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003610.72225 | 2118616.0414400003 | 37.797519485292604 | -122.431568985315 | (37.7975194852926, -122.431568985315) | |||
| 8671 | 8671 | 94316 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 849 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008215.32514 | 2115461.17865 | 37.7891169188602 | -122.41541232661699 | (37.7891169188602, -122.415412326617) | |||
| 8715 | 8715 | 107356 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2001 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010305.7737 | 2121389.2048 | 37.8055111049264 | -122.40859795685199 | (37.8055111049264, -122.408597956852) | |||
| 8876 | 8876 | 95278 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 638 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Created record for tree on 2/4/2011. Matches others in row planted around same time in 1979. | 6004779.960630001 | 2110916.39736 | 37.7764443911196 | -122.426974438925 | (37.7764443911196, -122.426974438925) | ||
| 8902 | 8902 | 103249 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2659 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000303.19114 | 2117809.86382 | 37.79511791052 | -122.442955960953 | (37.79511791052, -122.442955960953) | |||
| 9658 | 9658 | 114124 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9700 | 9700 | 167217 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 4043 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002761.86684 | 2104717.31992 | 37.7593089219858 | -122.433512476944 | (37.7593089219858, -122.433512476944) | |||
| 9704 | 9704 | 104747 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2-X FORD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6003502.9 | 2105705.5 | 37.762064243675106 | -122.431020153892 | (37.7620642436751, -122.431020153892) | ||||
| 9709 | 9709 | 121554 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 330 Eureka St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 779292 | 6001441.0 | 2103840.0 | 37.7568249841019 | -122.438017823933 | (37.7568249841019, -122.438017823933) | ||
| 9716 | 9716 | 138189 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1837 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003405.7885 | 2115073.4289 | 37.7877807602684 | -122.43202500502701 | (37.7877807602684, -122.432025005027) | |||
| 9971 | 9971 | 121203 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3041 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | Permit Number 778902 | 5999408.34577 | 2119299.99025 | 37.7991583414361 | -122.446159489987 | (37.7991583414361, -122.446159489987) | ||
| 10169 | 10169 | 105680 | Undocumented 2 | Tree(s) :: 17 | 620 07TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x3 | Permit Number 771004 | 6011709.5 | 2109428.5 | 37.7727483590072 | -122.402898388879 | (37.7727483590072, -122.402898388879) | ||
| 10189 | 10189 | 105689 | Undocumented 2 | Tree(s) :: 17 | 635 08TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | Permit Number 771004 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||
| 10355 | 10355 | 97645 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1750 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5988496.9003 | 2103110.255 | 37.7540766821623 | -122.482729298816 | (37.7540766821623, -122.482729298816) | |||
| 10386 | 10386 | 97218 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 539 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000286.32734 | 2092915.99472 | 37.7267645246623 | -122.441227336289 | (37.7267645246623, -122.441227336289) | |||
| 10409 | 10409 | 104687 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 540 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013068.15068 | 2086901.5117 | 37.7109697693033 | -122.396619189338 | (37.7109697693033, -122.396619189338) | |||
| 10520 | 10520 | 95069 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1924 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5989718.6012 | 2106543.0694 | 37.7635732745448 | -122.478755452983 | (37.7635732745448, -122.478755452983) | ||||
| 10531 | 10531 | 120538 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002576.6751 | 2087720.0510900002 | 37.7126278178947 | -122.43293862581999 | (37.7126278178947, -122.43293862582) | |||
| 10568 | 10568 | 75056 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 12 | 4x4 | 6005836.26564 | 2092311.52216 | 37.7254193565072 | -122.421998406407 | (37.7254193565072, -122.421998406407) | |
| 10633 | 10633 | 78424 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 337 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 12 | 3x3 | 6001367.33803 | 2089018.36243 | 37.716124024086 | -122.43721136872499 | (37.716124024086, -122.437211368725) | |
| 10642 | 10642 | 113534 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3601 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5981793.2608 | 2096687.6431 | 37.7360496742075 | -122.505435686033 | (37.7360496742075, -122.505435686033) | |||
| 10770 | 10770 | 95280 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2345 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5986659.614 | 2102972.3691 | 37.753591018895605 | -122.489072857999 | (37.7535910188956, -122.489072857999) | |||
| 10853 | 10853 | 102802 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1245 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5987672.179 | 2106793.3292 | 37.764141382947706 | -122.485851660773 | (37.7641413829477, -122.485851660773) | |||
| 10872 | 10872 | 95281 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2345 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5986681.7586 | 2102973.0952 | 37.753594305056794 | -122.488996331514 | (37.7535943050568, -122.488996331514) | |||
| 10912 | 10912 | 75399 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 12 | 4x6 | 5988689.6276 | 2099701.3205 | 37.7447278644639 | -122.48181312543501 | (37.7447278644639, -122.481813125435) |
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");