trees
163,064 rows where qCaretaker_id = 2 sorted by qCareAssistant descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
683 | 38304 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
692 | 61241 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1984 12:00:00 AM | Permit Number 21113 | 6003879.55901956 | 2104241.51200503 | 37.7580658175007 | -122.429613020503 | (37.7580658175007, -122.429613020503) | 2 | 4 | 5 | 28862 | 3 | ||
696 | 60808 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2075 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1983 12:00:00 AM | 8 | Permit Number 20486 | 5989723.8885 | 2101238.2089 | 37.7490078493386 | -122.478349246975 | (37.7490078493386, -122.478349246975) | 1 | 8 | 3 | 29491 | 35 | |
700 | 53215 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 770 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/1956 12:00:00 AM | 12 | Permit Number 39 | 6013009.5189 | 2103441.54791 | 37.756382021722 | -122.397981381646 | (37.756382021722, -122.397981381646) | 10 | 3 | 8 | 28856 | 29 | |
701 | 52560 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1742 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 7 | Permit Number 48656 | 5984113.6499 | 2103302.6049 | 37.7543488257224 | -122.497901608629 | (37.7543488257224, -122.497901608629) | 1 | 8 | 3 | 56 | 35 | |
702 | 62566 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 484 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 11 | Permit Number 22767 | 6011457.1056 | 2106150.727 | 37.7637342411783 | -122.403540799888 | (37.7637342411783, -122.403540799888) | 8 | 3 | 8 | 28856 | 29 | |
713 | 38369 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4245 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 5 | Permit Number 40431 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | 1 | 8 | 3 | 56 | 35 | |
715 | 67254 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2107 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 4 | Permit Number 32998 | 5981675.3208 | 2100708.9402 | 37.7470841010946 | -122.506141523298 | (37.7470841010946, -122.506141523298) | 1 | 8 | 3 | 29491 | 35 | |
719 | 80747 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1111 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001772.74556 | 2087054.04067 | 37.7107534679609 | -122.435669635744 | (37.7107534679609, -122.435669635744) | 9 | 7 | 6 | 28861 | 5 | |||
723 | 62606 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 818 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 11 | Permit Number 22914 | 5984501.0298 | 2110256.07846 | 37.7734638082368 | -122.497075193473 | (37.7734638082368, -122.497075193473) | 11 | 6 | 2 | 55 | 26 | |
738 | 55617 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 411 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | 6 | Permit Number 20476 | 5998121.25588 | 2115028.99118 | 37.7873577334097 | -122.45030520092 | (37.7873577334097, -122.45030520092) | 11 | 6 | 1 | 54 | 31 | |
742 | 37975 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 1199 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
745 | 43286 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1200 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 13 | Permit Number 43056 | 6013973.47383 | 2105741.62866 | 37.7627511832352 | -122.394808740727 | (37.7627511832352, -122.394808740727) | 14 | 3 | 8 | 28856 | 29 | |
749 | 72500 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2311 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5986050.4379 | 2098869.9561 | 37.7422913280707 | -122.49087764471 | (37.7422913280707, -122.49087764471) | 1 | 8 | 3 | 29491 | 35 | |||
751 | 261105 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1700X Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6015022 | 2094381 | 37.7316155174388 | -122.390388421118 | (37.7316155174388, -122.390388421118) | 10 | 3 | 8 | 58 | 1 | |
752 | 32695 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1106 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 5 | 3x3 | Permit Number 37103 | 6008138.63139 | 2115547.98028 | 37.7893509440283 | -122.415683826556 | (37.7893509440283, -122.415683826556) | 13 | 1 | 10 | 28858 | 21 |
754 | 34739 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 581 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 3x3 | Permit Number 38389 | 6007302.61875581 | 2103939.58827334 | 37.7574300317864 | -122.417753185833 | (37.7574300317864, -122.417753185833) | 2 | 4 | 7 | 28859 | 19 | |
763 | 81425 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 940 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | 6008220.47523 | 2115740.61826 | 37.7898844812376 | -122.415414298837 | (37.7898844812376, -122.415414298837) | 5 | 1 | 10 | 28858 | 21 | ||
779 | 69766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6014547.15395 | 2096165.56329 | 37.7364892123042 | -122.392154828809 | (37.7364892123042, -122.392154828809) | 10 | 3 | 8 | 58 | 1 | |||
799 | 72078 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 167 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2020 12:00:00 AM | 3 | 5989583.57132 | 2114255.42421 | 37.784741432124 | -122.479786850818 | (37.784741432124, -122.479786850818) | 11 | 6 | 2 | 55 | 26 | ||
800 | 43502 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43180 | 6008272.42807324 | 2096955.00828501 | 37.7383064636933 | -122.413905114955 | (37.7383064636933, -122.413905114955) | 2 | 7 | 7 | 28859 | 2 | ||
809 | 66604 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 795 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1993 12:00:00 AM | 17 | 3x3 | Permit Number 31919 | 6008813.15818 | 2115243.41738 | 37.7885525825831 | -122.413328486829 | (37.7885525825831, -122.413328486829) | 5 | 1 | 10 | 28858 | 21 |
810 | 75303 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.406566076957 | (37.7648621726769, -122.406566076957) | 8 | 4 | 8 | 28853 | 19 | |||
814 | 261435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 371 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007244 | 2095778 | 37.7350168462428 | -122.417377534221 | (37.7350168462428, -122.417377534221) | 2 | 7 | 7 | 28859 | 2 | ||||
818 | 71164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2118 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5988230.9552 | 2100880.1949 | 37.7479380567645 | -122.483485514105 | (37.7479380567645, -122.483485514105) | 1 | 8 | 3 | 29491 | 35 | |||
823 | 33293 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 166 Sproule Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 10 | Permit Number 37451 | 6009221.08576 | 2116982.79677 | 37.7933513902069 | -122.412040085683 | (37.7933513902069, -122.412040085683) | 3 | 1 | 10 | 28857 | 21 | |
835 | 61682 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 27 Ceres St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1984 12:00:00 AM | 4 | Permit Number 21679 | 6013919.66127 | 2093997.42296 | 37.7305010827376 | -122.394172607985 | (37.7305010827376, -122.394172607985) | 10 | 3 | 8 | 58 | 1 | |
839 | 71209 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2170 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988552.6315 | 2100561.3439 | 37.7470812936995 | -122.48234982645 | (37.7470812936995, -122.48234982645) | 1 | 8 | 3 | 29491 | 35 | |||
852 | 108444 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 2 | 3x2.5 | 6014877 | 2117007 | 37.7937335561349 | -122.392471758503 | (37.7937335561349, -122.392471758503) | 12 | 2 | 9 | 28855 | 6 | |
864 | 71270 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1215 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6001794.92 | 2112753.6259 | 37.7813197166319 | -122.437432113692 | (37.7813197166319, -122.437432113692) | 15 | 5 | 11 | 29490 | 41 | |||
865 | 65062 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 481 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1989 12:00:00 AM | Permit Number 27018 | 5982198.4613122 | 2112526.22921648 | 37.7795617740877 | -122.505208255718 | (37.7795617740877, -122.505208255718) | 11 | 6 | 2 | 55 | 26 | ||
868 | 62378 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1985 12:00:00 AM | 24 | Permit Number 22527 | 5986003.03353 | 2111613.32749 | 37.7772783336166 | -122.491979564694 | (37.7772783336166, -122.491979564694) | 11 | 6 | 2 | 55 | 26 | |
869 | 62385 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 642 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1985 12:00:00 AM | 12 | Permit Number 22535 | 6001098.1348 | 2110956.5992 | 37.7763458992435 | -122.439713770865 | (37.7763458992435, -122.439713770865) | 15 | 5 | 11 | 29492 | 10 | |
872 | 73939 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1450 Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988330.9539 | 2099688.5183 | 37.7446718481509 | -122.483052396761 | (37.7446718481509, -122.483052396761) | 1 | 8 | 3 | 29491 | 35 | |||
882 | 31596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1319 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 3 | Permit Number 35123 | 5989912.9927 | 2102412.7013 | 37.7522436720962 | -122.477781174123 | (37.7522436720962, -122.477781174123) | 1 | 8 | 3 | 29491 | 35 | |
886 | 73449 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 238 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004263.46084 | 2092033.98232 | 37.7245684629353 | -122.427415688595 | (37.7245684629353, -122.427415688595) | 9 | 7 | 6 | 28861 | 5 | |||
887 | 60297 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1982 12:00:00 AM | 7 | Permit Number 19862 | 6013032.9382 | 2107035.865 | 37.7662525295396 | -122.398152546702 | (37.7662525295396, -122.398152546702) | 14 | 3 | 8 | 28856 | 20 | |
889 | 72443 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 1069 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6008813.77454 | 2115937.32557 | 37.790457920444 | -122.413375446746 | (37.790457920444, -122.413375446746) | 5 | 1 | 10 | 28858 | 21 | |||
896 | 184943 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000 41st Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 12/12/2019 12:00:00 AM | 3 | 3x10 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 | |
907 | 261102 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1188 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013127 | 2090401 | 37.7205819447786 | -122.396660953022 | (37.7205819447786, -122.396660953022) | 10 | 3 | 8 | 58 | 1 | |
914 | 72135 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 720 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011518.46823 | 2104995.10588 | 37.7605645914089 | -122.403247266572 | (37.7605645914089, -122.403247266572) | 10 | 3 | 8 | 28856 | 29 | |||
915 | 40138 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1979 12:00:00 AM | 12 | Permit Number 41341 | 5982776.0706 | 2104863.9918 | 37.7585574465855 | -122.502642786425 | (37.7585574465855, -122.502642786425) | 1 | 8 | 3 | 56 | 35 | |
918 | 62597 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 7 | Permit Number 22903 | 5984441.0146 | 2110622.99108 | 37.7744677278845 | -122.497309882833 | (37.7744677278845, -122.497309882833) | 11 | 6 | 2 | 55 | 26 | |
923 | 70578 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 201 20th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989595.95127 | 2113926.18919 | 37.7838381644508 | -122.479719921835 | (37.7838381644508, -122.479719921835) | 11 | 6 | 2 | 55 | 26 | |||
930 | 73626 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 249 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994249.97744 | 2086699.51142 | 37.7093498474797 | -122.461644153659 | (37.7093498474797, -122.461644153659) | 9 | 8 | 6 | 28861 | 25 | |||
937 | 95737 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 445 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767484 | 6003120.3 | 2091142.7 | 37.7220564786865 | -122.431303852024 | (37.7220564786865, -122.431303852024) | 9 | 7 | 6 | 28861 | 5 | |
940 | 71166 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2123 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988191.5983 | 2100838.0598 | 37.747820074212 | -122.483618518196 | (37.747820074212, -122.483618518196) | 1 | 8 | 3 | 29491 | 35 | |||
942 | 67185 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 154 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | 12 | Permit Number 30632 | 5998076.31886872 | 2105384.33640813 | 37.7608734252807 | -122.449765371246 | (37.7608734252807, -122.449765371246) | 15 | 5 | 11 | 29492 | 12 | |
948 | 62575 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 836 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 11 | Permit Number 22778 | 6011550.65022 | 2104487.06027 | 37.7591714084613 | -122.403100226493 | (37.7591714084613, -122.403100226493) | 10 | 3 | 8 | 28856 | 29 | |
950 | 72251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001865.6588 | 2091176.05062 | 37.7220768687262 | -122.435643214558 | (37.7220768687262, -122.435643214558) | 9 | 7 | 6 | 28861 | 5 | |||
961 | 76397 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 701 Amador St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6016633.05444 | 2099489.61531 | 37.7457319802501 | -122.38517445926 | (37.7457319802501, -122.38517445926) | 10 | 3 | 8 | 58 | 1 | |||
962 | 41611 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 6 | Permit Number 44542 | 6011801.95167 | 2099599.86034 | 37.7457662552178 | -122.401887553691 | (37.7457662552178, -122.401887553691) | 10 | 3 | 8 | 58 | 1 | |
965 | 184959 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 41st Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 3x10 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 | |
967 | 78568 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1192 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009666.22083 | 2090670.9365 | 37.7211299140849 | -122.408642858878 | (37.7211299140849, -122.408642858878) | 9 | 3 | 7 | 309 | 28 | |||
968 | 71603 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 171 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994523.67906 | 2086453.64687 | 37.7086905122192 | -122.460680397897 | (37.7086905122192, -122.460680397897) | 9 | 8 | 6 | 28861 | 25 | |||
977 | 37516 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | 11 | Permit Number 41076 | 6007956.90243 | 2113828.43772 | 37.7846192815973 | -122.416190755523 | (37.7846192815973, -122.416190755523) | 7 | 10 | 9 | 28858 | 36 | |
979 | 171867 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 825 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Width 3ft | 6009309.97305 | 2091452.93347 | 37.7232571551673 | -122.409929483882 | (37.7232571551673, -122.409929483882) | 9 | 3 | 7 | 309 | 28 | ||
991 | 38251 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1475 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40361 | 6007534.04468586 | 2107333.12590687 | 37.7667609198383 | -122.417193284079 | (37.7667609198383, -122.417193284079) | 8 | 4 | 7 | 28853 | 19 | ||
996 | 70145 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 32 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5991181.63526 | 2114912.21638 | 37.7866375092707 | -122.474306076539 | (37.7866375092707, -122.474306076539) | 11 | 6 | 1 | 54 | 33 | |||
997 | 42493 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092861.95301 | 37.7264342507672 | -122.452230525303 | (37.7264342507672, -122.452230525303) | 9 | 7 | 4 | 28861 | 40 | ||
1001 | 70458 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3222 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982856.1897 | 2099504.4786 | 37.74384642674 | -122.501969135738 | (37.74384642674, -122.501969135738) | 1 | 8 | 3 | 29491 | 35 | |||
1003 | 72752 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1542 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988097.7754 | 2104798.077 | 37.758687755803 | -122.484233325891 | (37.758687755803, -122.484233325891) | 1 | 8 | 3 | 56 | 35 | |||
1009 | 41623 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 5 | Permit Number 44542 | 6011709.24435 | 2099669.58737 | 37.745952536283 | -122.402213025506 | (37.745952536283, -122.402213025506) | 10 | 3 | 8 | 58 | 1 | |
1010 | 70694 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 322 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6010581.57902 | 2106763.68382 | 37.7653683380996 | -122.406612188817 | (37.7653683380996, -122.406612188817) | 8 | 4 | 8 | 28853 | 19 | |||
1015 | 52400 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 47@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2005 12:00:00 AM | Permit Number 48521 | 6005927.5376712 | 2097730.99268597 | 37.7403051709369 | -122.422067716571 | (37.7403051709369, -122.422067716571) | 2 | 7 | 7 | 28859 | 2 | ||
1016 | 84387 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2101 Jerrold Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6012577.97369 | 2099023.613 | 37.7442272813575 | -122.399163722146 | (37.7442272813575, -122.399163722146) | 10 | 3 | 8 | 58 | 1 | |||
1025 | 55220 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 151 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1984 12:00:00 AM | 3 | Permit Number 21451 | 5989581.42537 | 2114369.00761 | 37.7850531755237 | -122.479802589294 | (37.7850531755237, -122.479802589294) | 11 | 6 | 2 | 55 | 26 | |
1027 | 53408 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 732 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/1969 12:00:00 AM | 2 | Permit Number 6307 | 6011253.43466 | 2104717.71315 | 37.7597881275257 | -122.404144378963 | (37.7597881275257, -122.404144378963) | 10 | 3 | 8 | 28856 | 29 | |
1028 | 67081 | Permitted Site 7 | Arbutus unedo :: Strawberry Tree 106 | 345 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1995 12:00:00 AM | Permit Number 30479 | 6006832.91402463 | 2097113.31465906 | 37.7386601871907 | -122.418893482297 | (37.7386601871907, -122.418893482297) | 2 | 7 | 7 | 28859 | 2 | ||
1029 | 65280 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 435 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28085 | 6011091.92612 | 2112217.73363 | 37.7803724445696 | -122.405231107147 | (37.7803724445696, -122.405231107147) | 14 | 2 | 9 | 28853 | 34 | |
1037 | 63388 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 139 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23969 | 6005989.66886949 | 2095872.0431692 | 37.7352044148911 | -122.421720887046 | (37.7352044148911, -122.421720887046) | 2 | 7 | 7 | 28859 | 2 | ||
1050 | 59568 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 636 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1981 12:00:00 AM | Permit Number 18958 | 6007406.54160631 | 2096049.3151302 | 37.7357709619243 | -122.416834784421 | (37.7357709619243, -122.416834784421) | 2 | 7 | 7 | 28859 | 2 | ||
1054 | 72037 | DPW Maintained 1 | Carpinus betulus :: European Hornbeam 165 | 534 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6010993.0833 | 2118650.7238 | 37.7980303757469 | -122.406026374045 | (37.7980303757469, -122.406026374045) | 3 | 1 | 10 | 308 | 23 | |||
1058 | 160441 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 201 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2019 12:00:00 AM | 3 | 4x6 | 6001628.58163 | 2090114.34641 | 37.7191481986061 | -122.436386782123 | (37.7191481986061, -122.436386782123) | 9 | 7 | 6 | 28861 | 5 | |
1063 | 32734 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 808 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37117 | 5995081.95862964 | 2089664.82981262 | 37.7175397705127 | -122.458983271916 | (37.7175397705127, -122.458983271916) | 9 | 8 | 6 | 28861 | 24 | ||
1074 | 80599 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015456.30873 | 2104984.78613 | 37.7607553924711 | -122.389627233831 | (37.7607553924711, -122.389627233831) | 10 | 3 | 8 | 28856 | 29 | |||
1079 | 48011 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1921 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45734 | 5991237.8181057 | 2102332.85604348 | 37.7521012359965 | -122.473193942643 | (37.7521012359965, -122.473193942643) | 1 | 8 | 4 | 29491 | 12 | ||
1089 | 60912 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 149 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/1993 12:00:00 AM | 8 | 3x3 | Permit Number 32000 | 6012148.61414 | 2119800.05377 | 37.8012507194169 | -122.402108723944 | (37.8012507194169, -122.402108723944) | 3 | 1 | 10 | 28860 | 6 |
1097 | 73684 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1050 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007850.01602 | 2119957.29186 | 37.8014415915259 | -122.416994947282 | (37.8014415915259, -122.416994947282) | 5 | 1 | 10 | 308 | 32 | |||
1098 | 31784 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 7 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35255 | 6001631.05677 | 2108636.54376 | 37.7700059251571 | -122.437704050605 | (37.7700059251571, -122.437704050605) | 15 | 5 | 5 | 29492 | 9 | |
1102 | 64618 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 355 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29568 | 6008648.33494852 | 2097105.55483154 | 37.7387409360622 | -122.412616048547 | (37.7387409360622, -122.412616048547) | 10 | 7 | 7 | 28859 | 2 | ||
1106 | 70679 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1111 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008560.05738 | 2116476.80387 | 37.7919249476168 | -122.414291480882 | (37.7919249476168, -122.414291480882) | 5 | 1 | 10 | 28858 | 21 | |||
1114 | 32669 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 750 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | 14 | 2 | 9 | 28853 | 34 | ||
1120 | 57868 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 360 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1977 12:00:00 AM | 7 | Permit Number 16812 | 6008032.73051 | 2113659.88131 | 37.7841607298832 | -122.415916474888 | (37.7841607298832, -122.415916474888) | 7 | 10 | 9 | 28858 | 36 | |
1123 | 72265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 358 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002353.80444 | 2091524.36294 | 37.7230609707806 | -122.433980702666 | (37.7230609707806, -122.433980702666) | 9 | 7 | 6 | 28861 | 5 | |||
1156 | 31893 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 8 | Permit Number 35323 | 6008432.94494 | 2108718.71395 | 37.7706159506067 | -122.414182168285 | (37.7706159506067, -122.414182168285) | 8 | 2 | 9 | 28853 | 19 | |
1158 | 61138 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 142 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1983 12:00:00 AM | 13 | 3x33x3 | Permit Number 20990 | 5997342.1336 | 2110018.8543 | 37.7735565931311 | -122.452639064998 | (37.7735565931311, -122.452639064998) | 15 | 5 | 11 | 29492 | 16 |
1159 | 70451 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2683 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983041.4986 | 2096885.6865 | 37.7366668238827 | -122.5011347377 | (37.7366668238827, -122.5011347377) | 1 | 8 | 3 | 29491 | 35 | |||
1167 | 33310 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1549 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 8 | Permit Number 37457 | 6005491.84423 | 2119228.52143 | 37.7993076406048 | -122.425103401209 | (37.7993076406048, -122.425103401209) | 13 | 9 | 1 | 57 | 17 | |
1187 | 38340 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1517 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 14 | Permit Number 40407 | 5982158.3822 | 2104738.8652 | 37.7581775666431 | -122.504769723467 | (37.7581775666431, -122.504769723467) | 1 | 8 | 3 | 56 | 35 | |
1193 | 63195 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 492 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 7 | Permit Number 23736 | 5984412.04288 | 2112531.45624 | 37.7797061246547 | -122.497551031954 | (37.7797061246547, -122.497551031954) | 11 | 6 | 2 | 55 | 26 | |
1204 | 72270 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 619 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002965.14713 | 2089877.08907 | 37.7185725974338 | -122.431749858784 | (37.7185725974338, -122.431749858784) | 9 | 7 | 6 | 28861 | 5 | |||
1205 | 71779 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1062 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6007509.77749 | 2115111.57122 | 37.7881173017281 | -122.417828646693 | (37.7881173017281, -122.417828646693) | 13 | 1 | 10 | 28858 | 21 | |||
1207 | 39056 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2800X 18th St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009422.123 | 2105494.394 | 37.7618182216771 | -122.410532856099 | (37.7618182216771, -122.410532856099) | 8 | 4 | 7 | 28859 | 19 | ||
1213 | 31454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 625 Douglass St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 16 | Permit Number 35026 | 6001228.91963 | 2102742.34175 | 37.7537990168301 | -122.438672624946 | (37.7537990168301, -122.438672624946) | 2 | 4 | 5 | 28862 | 22 | |
1214 | 44389 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 15 Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/2001 12:00:00 AM | Permit Number 43749 | 6001647.0719332 | 2087964.37014378 | 37.7132458927569 | -122.436169094311 | (37.7132458927569, -122.436169094311) | 9 | 7 | 6 | 28861 | 5 | ||
1218 | 39598 | DPW Maintained 1 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust 179 | 365 Vermont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 6 | Permit Number 41003 | 6011204.97691 | 2106670.11712 | 37.7651462828907 | -122.40444940203 | (37.7651462828907, -122.40444940203) | 8 | 3 | 8 | 28853 | 20 | |
1220 | 75333 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5984432.92075 | 2112122.55763 | 37.7785846311766 | -122.497448611437 | (37.7785846311766, -122.497448611437) | 11 | 6 | 2 | 55 | 26 | |||
1224 | 81614 | DPW Maintained 1 | Tristania conferta :: 61 | 1450@ Shafter Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6017097.2029 | 2092677.3305 | 37.7270524726432 | -122.383095431375 | (37.7270524726432, -122.383095431375) | 10 | 3 | 8 | 58 | 1 | |||
1225 | 70200 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 651 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002623.55844 | 2089844.48662 | 37.7184637093015 | -122.432928262055 | (37.7184637093015, -122.432928262055) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );