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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20076 | 20076 | 98360 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 807 Francisco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Permit Number 768654 | 6007370.5 | 2120864.5 | 37.8039055703948 | -122.418718664572 | (37.8039055703948, -122.418718664572) | ||||
22912 | 22912 | 210552 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 414 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5995155.65345 | 2100448.38141 | 37.7471530116111 | -122.459509101961 | (37.7471530116111, -122.459509101961) | |||
22945 | 22945 | 104992 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2423 47TH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 10 | 2x6 | Permit Number 775156 | 5981729.7 | 2098576.9 | 37.74123331264771 | -122.505795454359 | (37.7412333126477, -122.505795454359) | |
23367 | 23367 | 208982 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 320 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 45 | Width 3ft | 5993096.565780001 | 2095876.3159599998 | 37.7344806601409 | -122.46629697974501 | (37.7344806601409, -122.466296979745) | |||
23387 | 23387 | 213501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 787 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994873.7468 | 2093233.8423799998 | 37.7273274525845 | -122.459961359351 | (37.7273274525845, -122.459961359351) | |||
23396 | 23396 | 218586 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3666 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5990534.77048 | 2091965.7217599999 | 37.7235950079882 | -122.474868513494 | (37.7235950079882, -122.474868513494) | |||
23409 | 23409 | 218091 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 62 Eastwood Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995658.864080001 | 2092992.02847 | 37.726708612908 | -122.45722974236601 | (37.726708612908, -122.457229742366) | |||
23417 | 23417 | 183167 | Undocumented 2 | :: 54 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.741329561902596 | -122.50344114283101 | (37.7413295619026, -122.503441142831) | |||
23425 | 23425 | 236043 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 821 Duboce Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6001824.27489 | 2108233.40905 | 37.768910001429 | -122.43700684760701 | (37.768910001429, -122.437006847607) | |||
23448 | 23448 | 121887 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 18th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5990232.62779 | 2114784.35142 | 37.78623140306821 | -122.47758002792801 | (37.7862314030682, -122.477580027928) | |||
23485 | 23485 | 206309 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 226 Sadowa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5994744.569130001 | 2087779.6169999999 | 37.712344021541796 | -122.46001297051599 | (37.7123440215418, -122.460012970516) | |||
23492 | 23492 | 202174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013138.83373 | 2093054.0318599998 | 37.7278672922301 | -122.39680594795401 | (37.7278672922301, -122.396805947954) | |||
23531 | 23531 | 212068 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 65 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 6ft | 5994349.34377 | 2097659.88165 | 37.7394500943456 | -122.46209504585501 | (37.7394500943456, -122.462095045855) | |||
23538 | 23538 | 213933 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2176 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991344.08373 | 2100608.05246 | 37.7473715261751 | -122.472700716564 | (37.7473715261751, -122.472700716564) | |||
23557 | 23557 | 213451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5993177.52134 | 2099659.6696900004 | 37.7448734694269 | -122.466291957027 | (37.7448734694269, -122.466291957027) | |||
23577 | 23577 | 118033 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 89 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 5984120.82492 | 2112822.3596099997 | 37.780487786596204 | -122.498579960483 | (37.7804877865962, -122.498579960483) | |||
23683 | 23683 | 250745 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2850 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 4ft | 5986584.92122 | 2114476.3273400003 | 37.7851733080538 | -122.490177303062 | (37.7851733080538, -122.490177303062) | |||
23686 | 23686 | 250437 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 95 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5987583.4221 | 2115772.2854400002 | 37.7887898983715 | -122.48681804471902 | (37.7887898983715, -122.486818044719) | |||
23735 | 23735 | 213223 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 18 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5996685.56427 | 2088703.70423 | 37.7149927956564 | -122.45337101855101 | (37.7149927956564, -122.453371018551) | ||||
23761 | 23761 | 123510 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2714 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 8ft | 5994935.84099 | 2110268.0504400004 | 37.774102650784 | -122.460980795496 | (37.774102650784, -122.460980795496) | |||
23775 | 23775 | 250341 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 26 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5988236.1256800005 | 2115814.85446 | 37.7889448119981 | -122.48456293444599 | (37.7889448119981, -122.484562934446) | |||
23777 | 23777 | 183752 | Undocumented 2 | :: 54 | 2287 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987917.4443 | 2099749.9687 | 37.7448165037016 | -122.484486720736 | (37.7448165037016, -122.484486720736) | |||
23791 | 23791 | 245271 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 217 Ogden Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6008459.65813 | 2096082.8630400002 | 37.7359222563084 | -122.41319610842501 | (37.7359222563084, -122.413196108425) | |||
23835 | 23835 | 182329 | Undocumented 2 | :: 54 | 1501 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985565.7361 | 2104954.3084 | 37.75896897093661 | -122.493001657059 | (37.7589689709366, -122.493001657059) | |||
23912 | 23912 | 118028 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 51 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5984316.15967 | 2112798.24876 | 37.780433038793 | -122.49790243493 | (37.780433038793, -122.49790243493) | |||
23926 | 23926 | 181820 | Undocumented 2 | :: 54 | 2299 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985846.0311 | 2099546.7997 | 37.7441378151504 | -122.491634223287 | (37.7441378151504, -122.491634223287) | |||
23936 | 23936 | 211142 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 5993344.399119999 | 2096880.05499 | 37.7372509740365 | -122.465513038912 | (37.7372509740365, -122.465513038912) | ||||
24030 | 24030 | 136773 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3700 Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 5997087.63405 | 2115382.9814299997 | 37.7882704886466 | -122.453906871501 | (37.7882704886466, -122.453906871501) | |||
24035 | 24035 | 178607 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990327.66617 | 2089955.55198 | 37.7180635775375 | -122.47543773036101 | (37.7180635775375, -122.475437730361) | ||||
24050 | 24050 | 209682 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1849 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5991553.31162 | 2102854.2151599997 | 37.7535510143851 | -122.472140928188 | (37.7535510143851, -122.472140928188) | |||
24053 | 24053 | 181971 | Undocumented 2 | :: 54 | 2467 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985787.1457 | 2098434.4072 | 37.7410800425161 | -122.49175595946801 | (37.7410800425161, -122.491755959468) | |||
24061 | 24061 | 190934 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 9ft | 6015168.60212 | 2102024.17667 | 37.752610233591206 | -122.390415424833 | (37.7526102335912, -122.390415424833) | |||
24069 | 24069 | 204989 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 491 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5995151.4003 | 2098200.0926599996 | 37.7409795263895 | -122.459361016022 | (37.7409795263895, -122.459361016022) | |||
24081 | 24081 | 183742 | Undocumented 2 | :: 54 | 2278 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988578.8889999995 | 2099828.4885 | 37.745070593746796 | -122.482205348546 | (37.7450705937468, -122.482205348546) | |||
24085 | 24085 | 212387 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991919.26492 | 2095494.2164099999 | 37.7333635115101 | -122.47033944313499 | (37.7333635115101, -122.470339443135) | |||
24101 | 24101 | 141230 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 16 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5996536.7759 | 2114447.1732 | 37.7856694107907 | -122.45574506618999 | (37.7856694107907, -122.45574506619) | |||
24148 | 24148 | 182529 | Undocumented 2 | :: 54 | 1583 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986203.973999999 | 2104470.5925 | 37.7576781250927 | -122.490758769583 | (37.7576781250927, -122.490758769583) | |||
24206 | 24206 | 181982 | Undocumented 2 | :: 54 | 2479 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986720.0054 | 2098392.2737 | 37.7410188327151 | -122.488527415956 | (37.7410188327151, -122.488527415956) | |||
24221 | 24221 | 124585 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3979 Washington St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5995656.4760300005 | 2115464.7980400003 | 37.788412975773504 | -122.458864334168 | (37.7884129757735, -122.458864334168) | |||
24227 | 24227 | 203475 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991280.398630001 | 2099387.14513 | 37.7440155431828 | -122.472831922275 | (37.7440155431828, -122.472831922275) | |||
24275 | 24275 | 184454 | Undocumented 2 | :: 54 | 2153 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981374.6331 | 2100381.1786 | 37.7461664541179 | -122.507156946857 | (37.7461664541179, -122.507156946857) | |||
24286 | 24286 | 249978 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 13 Napier Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6011650.66928 | 2120187.96882 | 37.8022880343123 | -122.403859153579 | (37.8022880343123, -122.403859153579) | |||
24330 | 24330 | 205383 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 64 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994182.66644 | 2101796.2621 | 37.750797955763396 | -122.46297136414101 | (37.7507979557634, -122.462971364141) | |||
24337 | 24337 | 198558 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6014602.581680001 | 2096122.3818299999 | 37.73637372225429 | -122.391960171423 | (37.7363737222543, -122.391960171423) | |||
24365 | 24365 | 177331 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 230 Mansell St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6011147.98766 | 2090617.26897 | 37.7210654327147 | -122.403517019111 | (37.7210654327147, -122.403517019111) | |||
24379 | 24379 | 241475 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 939 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6000376.8686 | 2101955.8656599997 | 37.751591035515496 | -122.441562769933 | (37.7515910355155, -122.441562769933) | |||
24402 | 24402 | 182453 | Undocumented 2 | :: 54 | 1500 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986555.3586 | 2104541.3333 | 37.7578928802813 | -122.489548755928 | (37.7578928802813, -122.489548755928) | |||
24414 | 24414 | 205283 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 200 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 6ft | 5994526.48433 | 2100257.0572599997 | 37.7465914866063 | -122.46167083296801 | (37.7465914866063, -122.461670832968) | |||
24416 | 24416 | 212061 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 21 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5994643.85383 | 2097859.63633 | 37.740015523303704 | -122.461091241468 | (37.7400155233037, -122.461091241468) | |||
24441 | 24441 | 213456 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5993116.56669 | 2099668.45247 | 37.7448940675206 | -122.46650336333799 | (37.7448940675206, -122.466503363338) | |||
24576 | 24576 | 250559 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 415 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987302.16749 | 2115278.75264 | 37.7874183980764 | -122.487754859517 | (37.7874183980764, -122.487754859517) | |||
24582 | 24582 | 179929 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 325 Olmstead St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6010709.09006 | 2090936.6373700001 | 37.7219178272384 | -122.405056643155 | (37.7219178272384, -122.405056643155) | |||
24602 | 24602 | 208981 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 310 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | Width 3ft | 5993092.40274 | 2095921.0497 | 37.7346032476459 | -122.466314622626 | (37.7346032476459, -122.466314622626) | |||
24606 | 24606 | 181614 | Undocumented 2 | :: 54 | 1246 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984927.2833 | 2106710.1633 | 37.7637526989564 | -122.49533918573601 | (37.7637526989564, -122.495339185736) | |||
24610 | 24610 | 183977 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1693 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985918.7806 | 2103713.7918 | 37.7555834944248 | -122.49168936146002 | (37.7555834944248, -122.49168936146) | |||
24629 | 24629 | 208390 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 151 Elmwood Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5994957.667859999 | 2092685.59829 | 37.725826932848705 | -122.459631554564 | (37.7258269328487, -122.459631554564) | |||
24630 | 24630 | 184291 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1543 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5983404.3155 | 2104639.3384 | 37.7579775103532 | -122.50045345703501 | (37.7579775103532, -122.500453457035) | |||
24723 | 24723 | 181788 | Undocumented 2 | :: 54 | 3131 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986265.505 | 2098198.358 | 37.740459860841 | -122.49008463083 | (37.740459860841, -122.49008463083) | |||
24755 | 24755 | 117990 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 38 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 10ft | 5984444.7207 | 2112850.37395 | 37.780583695587396 | -122.49746153818899 | (37.7805836955874, -122.497461538189) | |||
24768 | 24768 | 250528 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 76 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5987723.676030001 | 2115494.19027 | 37.7880345047402 | -122.48631236764099 | (37.7880345047402, -122.486312367641) | |||
24777 | 24777 | 123037 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 598 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991936.90153 | 2111420.91872 | 37.777095091129105 | -122.471438573307 | (37.7770950911291, -122.471438573307) | |||
24784 | 24784 | 232225 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4 Germania St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6004247.320040001 | 2108919.60304 | 37.7709315496771 | -122.42867461895099 | (37.7709315496771, -122.428674618951) | |||
24841 | 24841 | 175769 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5989661.94364 | 2089233.64885 | 37.716042798215206 | -122.477686080452 | (37.7160427982152, -122.477686080452) | ||||
24861 | 24861 | 182367 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1511 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5986186.5787 | 2104935.6262 | 37.758953963431 | -122.49085314669901 | (37.758953963431, -122.490853146699) | |||
24903 | 24903 | 201466 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 301 Catalina St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 6017699.909990001 | 2096021.8364 | 37.7362691149141 | -122.38124431128 | (37.7362691149141, -122.38124431128) | |||
24912 | 24912 | 208332 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3688 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5990508.376069999 | 2091529.5417099998 | 37.7223958366684 | -122.47492792990299 | (37.7223958366684, -122.474927929903) | |||
24937 | 24937 | 250897 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 257 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5986796.26236 | 2114206.96718 | 37.7844460622777 | -122.489426325065 | (37.7844460622777, -122.489426325065) | |||
24993 | 24993 | 205648 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 146 Forest Hill Path | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994467.18853 | 2101084.43805 | 37.7488598520055 | -122.461935856854 | (37.7488598520055, -122.461935856854) | |||
25079 | 25079 | 204442 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2395 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5991351.20232 | 2099149.48654 | 37.743367092409294 | -122.472569777984 | (37.7433670924093, -122.472569777984) | |||
25105 | 25105 | 189974 | Undocumented 2 | Cercis occidentalis :: Western Redbud 246 | 875 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6011341.45696 | 2104259.23548 | 37.75853416774461 | -122.40380768986999 | (37.7585341677446, -122.40380768987) | |||
25120 | 25120 | 206614 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 432 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995034.15561 | 2100336.79731 | 37.7468396428317 | -122.45992114704399 | (37.7468396428317, -122.459921147044) | |||
25162 | 25162 | 120283 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 139 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5988317.15466 | 2115062.63745 | 37.786884157218 | -122.484227400222 | (37.786884157218, -122.484227400222) | ||||
25204 | 25204 | 209684 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1853 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991553.70129 | 2102821.79388 | 37.7534620165755 | -122.472137217586 | (37.7534620165755, -122.472137217586) | |||
25231 | 25231 | 140921 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 150 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5996579.2478 | 2113360.6701 | 37.7826885995813 | -122.455519569028 | (37.7826885995813, -122.455519569028) | |||
25262 | 25262 | 237451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4407 24th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6000528.815780001 | 2101672.95433 | 37.7508228849759 | -122.441017024421 | (37.7508228849759, -122.441017024421) | |||
25275 | 25275 | 212516 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1845 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5992439.35548 | 2095372.08993 | 37.7330582393366 | -122.468532478509 | (37.7330582393366, -122.468532478509) | |||
25277 | 25277 | 210945 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 78 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5996140.80305 | 2088701.9398299998 | 37.7149567103495 | -122.455253805936 | (37.7149567103495, -122.455253805936) | ||||
25285 | 25285 | 123524 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 2828 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 8ft | 5994582.70338 | 2110216.80029 | 37.7739416046925 | -122.46219863345199 | (37.7739416046925, -122.462198633452) | |||
25292 | 25292 | 177947 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989601.96089 | 2090504.09134 | 37.7195276360688 | -122.477986231896 | (37.7195276360688, -122.477986231896) | ||||
25293 | 25293 | 182679 | Undocumented 2 | :: 54 | 2631 Moraga St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986083.8267 | 2103639.2241 | 37.7553883964845 | -122.49111310108299 | (37.7553883964845, -122.491113101083) | |||
25300 | 25300 | 117795 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3755 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5983918.45231 | 2111030.33934 | 37.7755555482917 | -122.499147602329 | (37.7755555482917, -122.499147602329) | |||
25380 | 25380 | 124656 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 Presidio Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 7ft | 5995441.43994 | 2115441.36584 | 37.7883362746058 | -122.45960662195401 | (37.7883362746058, -122.459606621954) | |||
25415 | 25415 | 209553 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 95 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5993698.07886 | 2101380.70554 | 37.7496290187806 | -122.46461692652599 | (37.7496290187806, -122.464616926526) | |||
25451 | 25451 | 218361 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 319 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5993708.26635 | 2100090.28038 | 37.746086426450894 | -122.46448801411199 | (37.7460864264509, -122.464488014112) | |||
25462 | 25462 | 250940 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987097.72783 | 2114420.3103099996 | 37.7850494354169 | -122.488399056469 | (37.7850494354169, -122.488399056469) | |||
25464 | 25464 | 213655 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Edgehill Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994743.32278 | 2099041.60515 | 37.7432666390437 | -122.460832960696 | (37.7432666390437, -122.460832960696) | |||
25481 | 25481 | 198281 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017868.75025 | 2099595.89007 | 37.7460920687928 | -122.380908946009 | (37.7460920687928, -122.380908946009) | |||
25523 | 25523 | 140930 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 118 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5996567.4031 | 2113640.2065 | 37.7834554526548 | -122.455580757548 | (37.7834554526548, -122.455580757548) | |||
25554 | 25554 | 219562 | Undocumented 2 | Ulmus americana :: American Elm 119 | 474 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5993376.84863 | 2099471.9511 | 37.7443695406169 | -122.465589090967 | (37.7443695406169, -122.465589090967) | |||
25587 | 25587 | 228713 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 811 Duboce Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6001884.184859999 | 2108235.8291 | 37.7689200513416 | -122.436799796678 | (37.7689200513416, -122.436799796678) | |||
25589 | 25589 | 178865 | Undocumented 2 | Prunus persica :: Peach 330 | 1260 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6000973.92591 | 2087218.6697900002 | 37.711160097322995 | -122.438442319358 | (37.711160097323, -122.438442319358) | |||
25629 | 25629 | 123514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2744 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5994834.09227 | 2110246.18844 | 37.7740367681104 | -122.461331174398 | (37.7740367681104, -122.461331174398) | |||
25670 | 25670 | 232568 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 947 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 4ft | 6000344.26845 | 2101952.87409 | 37.7515809640038 | -122.441675290387 | (37.7515809640038, -122.441675290387) | |||
25709 | 25709 | 238712 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 45 Patton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6005630.08685 | 2096838.1497 | 37.737836843694794 | -122.42303274008002 | (37.7378368436948, -122.42303274008) | |||
25725 | 25725 | 178308 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 5990210.12045 | 2089417.27348 | 37.716578783365605 | -122.47580474370501 | (37.7165787833656, -122.475804743705) | ||||
25734 | 25734 | 237874 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 160 Coso Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6007471.906690001 | 2099585.1841700003 | 37.74548335098721 | -122.41685922338301 | (37.7454833509872, -122.416859223383) | ||||
25739 | 25739 | 212063 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 39 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5994526.15715 | 2097790.3563900003 | 37.7398185241173 | -122.461493163775 | (37.7398185241173, -122.461493163775) | |||
25770 | 25770 | 198550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1743 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6014437.8332 | 2096238.2314099998 | 37.736682673554895 | -122.392537881536 | (37.7366826735549, -122.392537881536) | |||
25771 | 25771 | 198601 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6016359.83761 | 2108655.37305 | 37.770884091558706 | -122.386758280474 | (37.7708840915587, -122.386758280474) | ||||
25836 | 25836 | 222165 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 953 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6000303.115259999 | 2101951.8939 | 37.7515759277946 | -122.441817532557 | (37.7515759277946, -122.441817532557) |
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");