trees
39,840 rows where qLegalStatus_id = 7 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38991 | 107888 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
79021 | 111446 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||||
83216 | 111448 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 38 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6x7 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | |||
92535 | 107891 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
102600 | 107890 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
144463 | 43455 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | Permit Number 43162 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||
147980 | 111447 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||||
188774 | 107889 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 11/03/2014 12:00:00 AM | 3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |
19694 | 91181 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
36901 | 91180 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
65819 | 91179 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
101029 | 108939 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1801 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 01/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774694 | 6004341.9 | 2118349.2 | 37.7968282226561 | -122.429019881342 | (37.7968282226561, -122.429019881342) | 13 | 9 | 1 | 57 | 17 |
115211 | 59556 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 4079 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | Private | 02/03/1981 12:00:00 AM | 15 | Permit Number 18942 | 6003404.16952868 | 2100363.87266154 | 37.7473918055728 | -122.430980375601 | (37.7473918055728, -122.430980375601) | 2 | 4 | 5 | 63 | 22 | |
116514 | 100095 | Permitted Site 7 | Tree(s) :: 17 | 4372 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 07/03/2012 12:00:00 AM | 3x3 | Permit Number 769070 | 6001507 | 2100613.7 | 37.7479700909705 | -122.43755853273 | (37.7479700909705, -122.43755853273) | 2 | 4 | 5 | 28862 | 22 | |
129891 | 106680 | Permitted Site 7 | Tree(s) :: 17 | 2200 LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 06/24/2014 12:00:00 AM | 20 | 3x3 | Permit Number 773028 | 5999398.2 | 2116386.7 | 37.7911586409716 | -122.445984946853 | (37.7911586409716, -122.445984946853) | 13 | 6 | 1 | 29490 | 27 |
133801 | 102879 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1680X Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 07/23/2010 12:00:00 AM | 2 | 4x4 | Permit Number 53643 | 6014844.7 | 2094689.6 | 37.7324530338407 | -122.391022948435 | (37.7324530338407, -122.391022948435) | 10 | 3 | 8 | 58 | 1 |
138944 | 114692 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 391 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | 10 | 3 | 7 | 309 | 28 | ||
141293 | 91178 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
144881 | 106120 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 849X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 6x9 | 5992954.7 | 2110649.6 | 37.7750360842588 | -122.467861605393 | (37.7750360842588, -122.467861605393) | 11 | 6 | 2 | 54 | 11 | |||
175730 | 254646 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 Saint Charles Ave | 31 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Private | 3x3 | 5992096 | 2088072 | 37.7129941473192 | -122.469188407447 | (37.7129941473192, -122.469188407447) | 9 | 8 | 6 | 64 | 24 | |||
185169 | 15159 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 13 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | Private | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | ||
2745 | 260577 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
7157 | 260575 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
8356 | 260576 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
9505 | 260574 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
45479 | 108934 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 361 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774685 | 6006490.6 | 2097118.7 | 37.7386556931549 | -122.42007742591 | (37.7386556931549, -122.42007742591) | 2 | 7 | 7 | 28859 | 2 |
133833 | 108521 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1969 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773668 | 5990944.21476 | 2102008.8699 | 37.7511946505392 | -122.474185618824 | (37.7511946505392, -122.474185618824) | 1 | 8 | 4 | 29491 | 12 |
158582 | 108904 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772986 | 6008567.7 | 2096169.9 | 37.7361673058735 | -122.412828714971 | (37.7361673058735, -122.412828714971) | 10 | 7 | 7 | 28859 | 2 |
30 | 254372 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 62 Tioga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778036 | 6010859.22958 | 2088882.34048 | 37.7162855403434 | -122.404393121162 | (37.7162855403434, -122.404393121162) | 9 | 7 | 8 | 309 | 39 |
340 | 42995 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 436 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42871 | 6004515.16540478 | 2110012.02065503 | 37.7739462176361 | -122.42782598565 | (37.7739462176361, -122.42782598565) | 7 | 9 | 11 | 28852 | 10 | ||
435 | 108949 | Permitted Site 7 | :: 45 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003932.1 | 2088992 | 37.7161971007686 | -122.428344449747 | (37.7161971007686, -122.428344449747) | 9 | 7 | 6 | 28861 | 5 | |||
495 | 69056 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33064 | 5992348.34951393 | 2107046.09564514 | 37.7651067945026 | -122.469696689595 | (37.7651067945026, -122.469696689595) | 11 | 8 | 11 | 56 | 12 | ||
549 | 63156 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1483 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1986 12:00:00 AM | Permit Number 23692 | 5992405.6320278 | 2105370.20909848 | 37.7605085633711 | -122.4693765688 | (37.7605085633711, -122.4693765688) | 1 | 8 | 4 | 56 | 12 | ||
554 | 63105 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23825 | 6006733.57538349 | 2099199.19959074 | 37.7443819667232 | -122.41938488452 | (37.7443819667232, -122.41938488452) | 2 | 7 | 7 | 28859 | 2 | ||
589 | 108776 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 500X Lathrop Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
645 | 38285 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 27 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1998 12:00:00 AM | 12 | 3x12 | Permit Number 40369 | 6007338.83954453 | 2106937.08827094 | 37.7656625095236 | -122.417840391728 | (37.7656625095236, -122.417840391728) | 8 | 4 | 7 | 28853 | 19 |
656 | 37103 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.7640234205488 | -122.508237579769 | (37.7640234205488, -122.508237579769) | 1 | 8 | 3 | 56 | 35 | ||
680 | 47114 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45098 | 6008176.0434029 | 2098254.72889507 | 37.7418697970416 | -122.414330302805 | (37.7418697970416, -122.414330302805) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | |
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 | ||
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 | |
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
1282 | 65048 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1994 12:00:00 AM | Permit Number 27001 | 6008641.92550277 | 2097033.56507471 | 37.7385429081789 | -122.412633121744 | (37.7385429081789, -122.412633121744) | 10 | 7 | 7 | 28859 | 2 | ||
1283 | 41795 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1201 08th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42196 | 6012618.34920617 | 2107219.96513791 | 37.7667349263458 | -122.39959946704 | (37.7667349263458, -122.39959946704) | 14 | 3 | 8 | 28856 | 20 | ||
1288 | 233082 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1418 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785211 | 6001974.22065 | 2099890.10044 | 37.746009810513 | -122.43589113876 | (37.746009810513, -122.43589113876) | 2 | 7 | 5 | 63 | 22 |
1308 | 52427 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004786.32091155 | 2115731.58720361 | 37.7896660673411 | -122.427295522794 | (37.7896660673411, -122.427295522794) | 13 | 9 | 11 | 28858 | 27 |
1370 | 49770 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 333 Schwerin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46559 | 6008566.26332194 | 2086145.27295548 | 37.7086417136506 | -122.412125425298 | (37.7086417136506, -122.412125425298) | 9 | 7 | 8 | 309 | 39 | ||
1371 | 52082 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 138 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/17/2005 12:00:00 AM | Permit Number 48280 | 6004279.40612984 | 2097417.63926751 | 37.7393516795249 | -122.427743978882 | (37.7393516795249, -122.427743978882) | 2 | 7 | 5 | 63 | 7 | ||
1389 | 35341 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 810 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38807 | 6013022.29386504 | 2103288.02203798 | 37.7559611845743 | -122.397926431796 | (37.7559611845743, -122.397926431796) | 10 | 3 | 8 | 28856 | 29 | ||
1410 | 68319 | Permitted Site 7 | Heteromeles arbutifolia :: Toyon 186 | 100 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32134 | 5993677.209627 | 2114838.05789906 | 37.7865781513031 | -122.465666673248 | (37.7865781513031, -122.465666673248) | 11 | 6 | 2 | 54 | 11 | ||
1417 | 88463 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 955X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) | 10 | 3 | 8 | 58 | 1 |
1435 | 68125 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 172 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31874 | 6006033.71828156 | 2099220.36912277 | 37.7444006509706 | -122.421806351312 | (37.7444006509706, -122.421806351312) | 2 | 7 | 5 | 28859 | 2 | ||
1447 | 43059 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 3033 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42909 | 5983784.03584538 | 2100159.31178354 | 37.7456988823219 | -122.498809278198 | (37.7456988823219, -122.498809278198) | 1 | 8 | 3 | 29491 | 35 | ||
1450 | 43844 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2736 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2003 12:00:00 AM | Permit Number 43466 | 5985584.65410627 | 2096702.64202879 | 37.7363132411039 | -122.492328600224 | (37.7363132411039, -122.492328600224) | 1 | 8 | 3 | 29491 | 35 | ||
1452 | 50129 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 126 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46851 | 5992933.01758855 | 2098244.53048723 | 37.740973745145 | -122.467034533605 | (37.740973745145, -122.467034533605) | 1 | 8 | 4 | 59 | 40 | ||
1489 | 69250 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1838 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/1994 12:00:00 AM | Permit Number 33318 | 5991599.04334449 | 2102860.56941142 | 37.7535711078961 | -122.471983242544 | (37.7535711078961, -122.471983242544) | 1 | 8 | 4 | 56 | 12 | ||
1529 | 36010 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.7441837468315 | -122.421946122617 | (37.7441837468315, -122.421946122617) | 2 | 7 | 5 | 28859 | 2 | ||
1539 | 39700 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 360 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.456652788497 | (37.7319575477065, -122.456652788497) | 9 | 7 | 4 | 59 | 40 | ||
1558 | 256904 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1571 37th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782743 | 5984651.59496 | 2104500.79365 | 37.7576702424259 | -122.496129679735 | (37.7576702424259, -122.496129679735) | 1 | 8 | 3 | 56 | 35 | |
1572 | 36143 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1027 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1998 12:00:00 AM | 3x3 | Permit Number 39232 | 5992592.32005608 | 2107256.68934819 | 37.7656991270754 | -122.468868188853 | (37.7656991270754, -122.468868188853) | 11 | 8 | 11 | 56 | 12 | |
1585 | 34112 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1398 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | 9 | 7 | 4 | 28861 | 40 | ||
1619 | 95785 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 347 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767529 | |||||||||||
1627 | 35149 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.7719620248453 | -122.427256837171 | (37.7719620248453, -122.427256837171) | 7 | 9 | 11 | 28852 | 10 | ||
1633 | 50106 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1550 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | 1 | 8 | 4 | 59 | 40 | ||
1651 | 37169 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 151 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1998 12:00:00 AM | Permit Number 39743 | 6005565.93572779 | 2099898.57048032 | 37.7462364463923 | -122.423472053683 | (37.7462364463923, -122.423472053683) | 2 | 7 | 5 | 28859 | 22 | ||
1657 | 40280 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 307 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41432 | 6007215.02535858 | 2105520.83315888 | 37.7617668348059 | -122.418168222107 | (37.7617668348059, -122.418168222107) | 2 | 4 | 7 | 28859 | 19 | ||
1669 | 35520 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41442 | 6005793.71652674 | 2102887.49607432 | 37.7544562030797 | -122.422896805421 | (37.7544562030797, -122.422896805421) | 2 | 4 | 5 | 28859 | 19 | ||
1692 | 61474 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1960 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1984 12:00:00 AM | Permit Number 21417 | 6004396.86379546 | 2107211.14447839 | 37.7662489975602 | -122.428035576337 | (37.7662489975602, -122.428035576337) | 8 | 4 | 5 | 28862 | 3 | ||
1702 | 46741 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 21 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44848 | 5993934.28224784 | 2089153.42556477 | 37.7160695363268 | -122.462913152344 | (37.7160695363268, -122.462913152344) | 9 | 8 | 6 | 64 | 24 | ||
1733 | 36818 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 1319 Egbert Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39533 | 6014721.91392724 | 2090796.36288096 | 37.7217561705213 | -122.391175415466 | (37.7217561705213, -122.391175415466) | 10 | 3 | 8 | 58 | 1 | ||
1812 | 52955 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 516 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48942 | 5993282.16384919 | 2090617.22186434 | 37.7200511847077 | -122.465273429637 | (37.7200511847077, -122.465273429637) | 9 | 8 | 6 | 64 | 24 | ||
1814 | 43257 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 400 Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43041 | 6010158.39254276 | 2093206.15154528 | 37.7281186387281 | -122.407120168437 | (37.7281186387281, -122.407120168437) | 10 | 3 | 7 | 309 | 28 | ||
1868 | 37331 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 700 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39840 | 6003021.44463533 | 2104165.68333023 | 37.7578089842605 | -122.432575328482 | (37.7578089842605, -122.432575328482) | 2 | 4 | 5 | 28862 | 3 | ||
1895 | 73501 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1045 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767446 | 6001962.16426713 | 2101054.16463509 | 37.7492053706113 | -122.436016109621 | (37.7492053706113, -122.436016109621) | 2 | 4 | 5 | 28862 | 22 | |
1907 | 36575 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2959 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | Permit Number 773747 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | 2 | 4 | 7 | 28859 | 19 | |
1980 | 63280 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 363 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23841 | 6006563.98546453 | 2103999.80423144 | 37.7575537770148 | -122.420311952542 | (37.7575537770148, -122.420311952542) | 2 | 4 | 7 | 28859 | 19 | ||
2027 | 32641 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/1999 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
2074 | 64926 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2340 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 25954 | 5991486.3095246 | 2099579.02126823 | 37.7445543038697 | -122.472133919026 | (37.7445543038697, -122.472133919026) | 1 | 8 | 4 | 29491 | 40 | ||
2118 | 73083 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1999 12:00:00 AM | 3x3 | 6007158.13725384 | 2106179.72119915 | 37.7635727856768 | -122.418411696436 | (37.7635727856768, -122.418411696436) | 8 | 4 | 7 | 28859 | 19 | ||
2157 | 66537 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 17 Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1995 12:00:00 AM | Permit Number 29712 | 6000633.94026001 | 2105546.19436908 | 37.76146384633 | -122.440931323073 | (37.76146384633, -122.440931323073) | 15 | 5 | 5 | 28862 | 3 | ||
2171 | 61848 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1985 12:00:00 AM | Permit Number 21887 | 6010218.02478734 | 2103088.23113889 | 37.755256026984 | -122.407610478643 | (37.755256026984, -122.407610478643) | 2 | 4 | 7 | 28859 | 19 | ||
2173 | 63110 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 25 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1986 12:00:00 AM | Permit Number 23613 | 6006806.68286349 | 2099834.22007943 | 37.7461297072747 | -122.419177129276 | (37.7461297072747, -122.419177129276) | 2 | 7 | 7 | 28859 | 2 | ||
2228 | 48000 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1901 16th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45728 | 5991233.33873947 | 2102463.46573508 | 37.752459596695 | -122.47321895744 | (37.752459596695, -122.47321895744) | 1 | 8 | 4 | 29491 | 12 |
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) );