trees
39,840 rows where qLegalStatus_id = 7 sorted by PlantDate 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
72044 | 50652 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 41 Josiah Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47234 | 5996870.80130055 | 2089899.24303395 | 37.7182860829536 | -122.452817003739 | (37.7182860829536, -122.452817003739) | 9 | 8 | 6 | 28861 | 24 | |||
139368 | 50308 | Permitted Site 7 | Prunus spp :: Cherry 68 | 701 (REVISED) Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47019 | 5994734.51143453 | 2090549.74162157 | 37.7199495485694 | -122.460248307265 | (37.7199495485694, -122.460248307265) | 9 | 8 | 6 | 28861 | 24 | |||
145049 | 50642 | Permitted Site 7 | Tree(s) :: 17 | 37 (REVISED) Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47230 | 6002603.72466291 | 2096337.22406414 | 37.7362901764597 | -122.433460549184 | (37.7362901764597, -122.433460549184) | 2 | 7 | 5 | 63 | 7 | |||
155484 | 41272 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 516 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1999 12:00:00 AM | Permit Number 41955 | 5998145.81312844 | 2095035.80887782 | 37.7324628706429 | -122.448779620072 | (37.7324628706429, -122.448779620072) | 9 | 7 | 4 | 59 | 40 | |||
107587 | 24030 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 46 Westbrook Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1994 12:00:00 AM | 6 | 3X4 | 6017366.4256098 | 2095583.6858371 | 37.7350476254936 | -122.382366841972 | (37.7350476254936, -122.382366841972) | 10 | 3 | 8 | 58 | 1 | ||
41815 | 57301 | Permitted Site 7 | Tree(s) :: 17 | 3186 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1985 12:00:00 AM | Permit Number 22637 | 6005614.71991822 | 2106685.37974416 | 37.7648741987262 | -122.42378585233 | (37.7648741987262, -122.42378585233) | 8 | 4 | 5 | 28853 | 19 | |||
97188 | 57197 | Permitted Site 7 | Tree(s) :: 17 | 482 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1974 12:00:00 AM | Permit Number 14478 | 6011757.89685552 | 2110674.77225553 | 37.7761730391644 | -122.402818643695 | (37.7761730391644, -122.402818643695) | 14 | 2 | 9 | 28853 | 34 | |||
7408 | 53652 | Permitted Site 7 | Tree(s) :: 17 | 831 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6588 | 6012089.84873388 | 2112576.989681 | 37.781414618516 | -122.401804066947 | (37.781414618516, -122.401804066947) | 6 | 2 | 9 | 28856 | 34 | |||
47060 | 53660 | Permitted Site 7 | Tree(s) :: 17 | 1501 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6598 | 6006675.09594553 | 2116030.8641893 | 37.790594444627 | -122.420781795009 | (37.790594444627, -122.420781795009) | 13 | 9 | 10 | 28858 | 21 | |||
55385 | 53662 | Permitted Site 7 | Tree(s) :: 17 | 1540 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6600 | 6006708.6321067 | 2116166.6463426 | 37.7909691588781 | -122.420675404796 | (37.7909691588781, -122.420675404796) | 13 | 9 | 10 | 28858 | 21 | |||
78194 | 53605 | Permitted Site 7 | Tree(s) :: 17 | 46 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6535 | 6001976.08337653 | 2107927.03987803 | 37.7680774147604 | -122.436459822555 | (37.7680774147604, -122.436459822555) | 15 | 5 | 5 | 29492 | 3 | |||
100648 | 53653 | Permitted Site 7 | Tree(s) :: 17 | 1222 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6589 | 6006853.69634946 | 2115128.25140491 | 37.7881261577171 | -122.420099762698 | (37.7881261577171, -122.420099762698) | 13 | 9 | 10 | 28858 | 21 | |||
158158 | 53665 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1540 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6603 | 6006700.2941 | 2116215.7306 | 37.7911034621337 | -122.420707740038 | (37.7911034621337, -122.420707740038) | 13 | 9 | 10 | 28858 | 21 | |||
126710 | 46930 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | |
159651 | 46927 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | |
162728 | 46929 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | |
177469 | 46928 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.7435241958304 | -122.459369067857 | (37.7435241958304, -122.459369067857) | 1 | 8 | 4 | 59 | 40 | ||
9743 | 34866 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 579 Miramar Ave | 1 | Median : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | 9 | 7 | 4 | 28861 | 40 | ||
14691 | 69919 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 95 Mercedes Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.7286182461033 | -122.470591251084 | (37.7286182461033, -122.470591251084) | 9 | 8 | 4 | 59 | 40 | ||
21373 | 109405 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 112 ORTEGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 775093 | 5993662.3 | 2102610.6 | 37.7530039316177 | -122.46482995514 | (37.7530039316177, -122.46482995514) | 1 | 8 | 4 | 56 | 12 | ||
46365 | 12564 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 6 | 3X3 | 5994519.02156 | 2114835.96421 | 37.7866209222593 | -122.462754079731 | (37.7866209222593, -122.462754079731) | 11 | 6 | 1 | 54 | 11 | ||
53141 | 71841 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 95 Mercedes Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.7286182461033 | -122.470591251084 | (37.7286182461033, -122.470591251084) | 9 | 8 | 4 | 59 | 40 | ||
58879 | 49069 | Permitted Site 7 | Tristania conferta :: 61 | 1298 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 776020 | 5995836.31315767 | 2092013.47244835 | 37.7240319217297 | -122.45654557668 | (37.7240319217297, -122.45654557668) | 9 | 8 | 4 | 28861 | 40 | ||
108192 | 114981 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 115 Moncada Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | Permit Number 776112 | 5992157.9 | 2093028.6 | 37.7266073370069 | -122.469335018242 | (37.7266073370069, -122.469335018242) | 9 | 8 | 4 | 59 | 40 | |||
139355 | 114987 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 157 Thrift St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | Permit Number 775985 | 5995400.7 | 2089591.3 | 37.7173561925503 | -122.457876217939 | (37.7173561925503, -122.457876217939) | 9 | 8 | 6 | 28861 | 24 | |||
147280 | 114984 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 742 Myra Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | Permit Number 776077 | 5997484.7 | 2098018.8 | 37.7406156184733 | -122.451280290868 | (37.7406156184733, -122.451280290868) | 9 | 7 | 4 | 59 | 40 | |||
177554 | 59937 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1738 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 19410 | 5999529.55338039 | 2110184.14033447 | 37.7741355180618 | -122.445084365992 | (37.7741355180618, -122.445084365992) | 15 | 5 | 11 | 29492 | 16 | ||
6907 | 108593 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 530 Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | ||||||||||
22140 | 108608 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 46 Mirabel Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774593 | 6007564.86266 | 2099909.67409 | 37.7463795558054 | -122.416560777242 | (37.7463795558054, -122.416560777242) | 2 | 7 | 7 | 28859 | 2 | |
23536 | 108612 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 774590 | 6002731.19846 | 2106518.35077 | 37.764252377203 | -122.433747267607 | (37.764252377203, -122.433747267607) | 15 | 5 | 5 | 28862 | 3 | |
27907 | 108600 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
34823 | 108597 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3103 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.38658 | 37.7482534137383 | -122.411410431436 | (37.7482534137383, -122.411410431436) | 2 | 4 | 7 | 28859 | 2 |
42298 | 108621 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 150-198X Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 774592 | 6005405 | 2109611 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | 7 | 9 | 11 | 28852 | 10 | |
50919 | 108598 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3103 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.38658 | 37.7482534137383 | -122.411410431436 | (37.7482534137383, -122.411410431436) | 2 | 4 | 7 | 28859 | 2 |
72188 | 108602 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
76551 | 108603 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
91937 | 108615 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 136 Precita Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774598 | 6007320.4947 | 2100127.53408 | 37.7469640041817 | -122.417421212351 | (37.7469640041817, -122.417421212351) | 2 | 7 | 7 | 28859 | 2 | |
103403 | 108606 | Permitted Site 7 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 31 Milton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774591 | 6003745.94412 | 2095489.02411 | 37.7340259500004 | -122.429450953687 | (37.7340259500004, -122.429450953687) | 2 | 7 | 5 | 28861 | 25 | |
119223 | 103416 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1500 Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 769963 | 5991394 | 2098432 | 37.7413995354896 | -122.472369502423 | (37.7413995354896, -122.472369502423) | 1 | 8 | 4 | 29491 | 40 | |
123315 | 43019 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 247 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774594 | 6005406.63271254 | 2109736.62010922 | 37.773240424192 | -122.424722652703 | (37.773240424192, -122.424722652703) | 7 | 9 | 11 | 28852 | 10 | |
156492 | 108610 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 745 Moultrie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774595 | 6007633.33742 | 2095945.52231 | 37.7354987236975 | -122.416043312411 | (37.7354987236975, -122.416043312411) | 2 | 7 | 7 | 28859 | 2 | |
156521 | 108599 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
157918 | 67731 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1471 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 774581 | 5992402.99511967 | 2105448.3839166 | 37.7607230584725 | -122.46939137901 | (37.7607230584725, -122.46939137901) | 1 | 8 | 4 | 56 | 12 | |
160783 | 103415 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1500 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 769963 | 5991394 | 2098432 | 37.7413995354896 | -122.472369502423 | (37.7413995354896, -122.472369502423) | 1 | 8 | 4 | 29491 | 40 | |
178715 | 108601 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
193662 | 79557 | Permitted Site 7 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 298 | 153 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772536 | 6004741.65189255 | 2108986.02751221 | 37.7711418993687 | -122.426969442731 | (37.7711418993687, -122.426969442731) | 7 | 9 | 11 | 28852 | 10 |
107036 | 95131 | Permitted Site 7 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 1500X North Point St | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/29/2010 12:00:00 AM | Permit Number 54065 | 6003452.6 | 2121222.8 | 37.8046680023994 | -122.432302398634 | (37.8046680023994, -122.432302398634) | 13 | 9 | 1 | 57 | 17 | |||
136443 | 94913 | Permitted Site 7 | Tree(s) :: 17 | 1468 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2010 12:00:00 AM | 3x3 | Permit Number 54063 | 5999646 | 2107504.1 | 37.7667834498072 | -122.444488905866 | (37.7667834498072, -122.444488905866) | 15 | 5 | 5 | 29492 | 9 | ||
185735 | 92211 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Miramar Ave | 5 | Median : Cutout | Tree | Private 2 | 12/29/2010 12:00:00 AM | 2x2 | Permit Number 54064 | 5995384.3 | 2092126.4 | 37.7243160320082 | -122.458116274775 | (37.7243160320082, -122.458116274775) | 9 | 8 | 4 | 28861 | 24 | ||
28458 | 15703 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4260 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2009 12:00:00 AM | 3 | 3X3 | 6003241.43292 | 2093747.96111 | 37.7292168076411 | -122.431070980005 | (37.7292168076411, -122.431070980005) | 9 | 7 | 6 | 28861 | 25 | ||
59997 | 9861 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 1350X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2009 12:00:00 AM | 3 | 4X4 | 6005510.31895 | 2114302.95438 | 37.7857843157652 | -122.424688888506 | (37.7857843157652, -122.424688888506) | 13 | 9 | 1 | 28858 | 41 | ||
104919 | 91086 | Permitted Site 7 | Tree(s) :: 17 | 3555 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2008 12:00:00 AM | 3x3 | Permit Number 51981 | 6003250.7 | 2106477.1 | 37.7641685772715 | -122.431947514847 | (37.7641685772715, -122.431947514847) | 15 | 4 | 5 | 28862 | 3 | ||
4858 | 39677 | Permitted Site 7 | Quercus keloggii :: California Black Oak 282 | 446 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41063 | 5993017.43068395 | 2090147.12878073 | 37.7187451525026 | -122.466154370624 | (37.7187451525026, -122.466154370624) | 9 | 8 | 6 | 64 | 24 | ||
14716 | 39658 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 311 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41051 | 5995887.27205834 | 2090529.96858098 | 37.7199614976995 | -122.456262207219 | (37.7199614976995, -122.456262207219) | 9 | 8 | 6 | 28861 | 24 | ||
18630 | 39605 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4731 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41008 | 5998534.61450841 | 2105650.4500048 | 37.7616303166929 | -122.448199498117 | (37.7616303166929, -122.448199498117) | 15 | 5 | 11 | 29492 | 12 | ||
20061 | 39639 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 556 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41033 | 5992765.12816761 | 2090901.30196023 | 37.7208013690683 | -122.467081273691 | (37.7208013690683, -122.467081273691) | 9 | 8 | 6 | 64 | 24 | ||
23089 | 39641 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 560 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41035 | 5992765.35359829 | 2090929.1002245 | 37.7208777093482 | -122.467082514469 | (37.7208777093482, -122.467082514469) | 9 | 8 | 6 | 64 | 24 | ||
23770 | 39620 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 176 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41019 | 5997495.40415115 | 2106779.2398399 | 37.7646702234482 | -122.451875122756 | (37.7646702234482, -122.451875122756) | 15 | 5 | 11 | 29492 | 9 | ||
26513 | 39670 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
30563 | 39634 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 532 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41029 | 5992763.77558421 | 2090734.51245254 | 37.720343327583 | -122.467073829079 | (37.720343327583, -122.467073829079) | 9 | 8 | 6 | 64 | 24 | ||
31305 | 39632 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 931 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41027 | 5997187.89015647 | 2107294.29840033 | 37.7660668249931 | -122.452975907923 | (37.7660668249931, -122.452975907923) | 15 | 5 | 11 | 29492 | 12 | ||
37242 | 39591 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 45 Southern Heights Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1998 12:00:00 AM | Permit Number 41001 | 6012325.10844747 | 2103966.01708403 | 37.7577839574034 | -122.400385164113 | (37.7577839574034, -122.400385164113) | 10 | 3 | 8 | 28856 | 29 | |||
37755 | 39665 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 720 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41055 | 5993542.26347395 | 2090641.85281267 | 37.7201338116039 | -122.464376148313 | (37.7201338116039, -122.464376148313) | 9 | 8 | 6 | 64 | 24 | ||
39139 | 32754 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 518 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41062 | 5995930.70396007 | 2088752.73433833 | 37.7150841234911 | -122.455983662757 | (37.7150841234911, -122.455983662757) | 9 | 8 | 6 | 28861 | 24 | ||
41380 | 39674 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 510 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41060 | 5994056.62807806 | 2090013.39911729 | 37.7184378644924 | -122.462552614145 | (37.7184378644924, -122.462552614145) | 9 | 8 | 6 | 28861 | 24 | ||
43841 | 39675 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 520 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.7186098185096 | -122.462555624891 | (37.7186098185096, -122.462555624891) | 9 | 8 | 6 | 28861 | 24 | ||
46074 | 39608 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 40X Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 4x4 | Permit Number 41011 | 5998720.01537421 | 2105405.17907901 | 37.7609674612338 | -122.447540618719 | (37.7609674612338, -122.447540618719) | 15 | 5 | 11 | 29492 | 12 | |
48084 | 39666 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41056 | 5993542.5872035 | 2090669.62247691 | 37.7202100790578 | -122.464377044443 | (37.7202100790578, -122.464377044443) | 9 | 8 | 6 | 64 | 24 | ||
48152 | 39645 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 581 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41039 | 5992714.48246081 | 2091068.51314927 | 37.7212575667576 | -122.467268490802 | (37.7212575667576, -122.467268490802) | 9 | 8 | 6 | 64 | 24 | ||
49669 | 39646 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 72 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41040 | 5994176.5137176 | 2090402.3957614 | 37.7195128594848 | -122.462166418076 | (37.7195128594848, -122.462166418076) | 9 | 8 | 6 | 28861 | 24 | ||
52311 | 39618 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 172 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41018 | 5997530.61215046 | 2106784.14607791 | 37.7646857112231 | -122.451753702175 | (37.7646857112231, -122.451753702175) | 15 | 5 | 11 | 29492 | 9 | ||
54164 | 39617 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 143 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1998 12:00:00 AM | Permit Number 41017 | 5997752.15145133 | 2106762.51515119 | 37.7646390036764 | -122.45098590005 | (37.7646390036764, -122.45098590005) | 15 | 5 | 11 | 29492 | 9 | |||
54778 | 39631 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 1578 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41026 | 5997930.04124721 | 2105225.66494664 | 37.7604293831671 | -122.450259840819 | (37.7604293831671, -122.450259840819) | 15 | 5 | 11 | 29492 | 12 | ||
58439 | 39660 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 316 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41052 | 5995871.10695115 | 2090582.25350935 | 37.7201041317861 | -122.456321862645 | (37.7201041317861, -122.456321862645) | 9 | 8 | 6 | 28861 | 24 | ||
58561 | 39663 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.7199324789318 | -122.462649323963 | (37.7199324789318, -122.462649323963) | 9 | 8 | 6 | 28861 | 24 | ||
71721 | 39656 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 446 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41049 | 5994787.45356144 | 2091546.35529022 | 37.7226890563706 | -122.460137470334 | (37.7226890563706, -122.460137470334) | 9 | 8 | 4 | 28861 | 24 | ||
72542 | 39664 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.7199324789318 | -122.462649323963 | (37.7199324789318, -122.462649323963) | 9 | 8 | 6 | 28861 | 24 | ||
78262 | 39669 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 252 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41058 | 5994484.42280423 | 2089355.80023073 | 37.7166568816936 | -122.461026279038 | (37.7166568816936, -122.461026279038) | 9 | 8 | 6 | 28861 | 24 | ||
80831 | 39637 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 551 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41031 | 5992712.7917316 | 2090860.02627115 | 37.7206850149703 | -122.467259183552 | (37.7206850149703, -122.467259183552) | 9 | 8 | 6 | 64 | 24 | ||
80877 | 39671 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
83133 | 39642 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 567 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41036 | 5992713.69345387 | 2090971.21927628 | 37.7209903759396 | -122.467264147401 | (37.7209903759396, -122.467264147401) | 9 | 8 | 6 | 64 | 24 | ||
87808 | 39610 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 263 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41012 | 5996951.50653264 | 2106998.54134507 | 37.7652412023396 | -122.453772147788 | (37.7652412023396, -122.453772147788) | 15 | 5 | 11 | 29492 | 12 | ||
90646 | 39662 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 340 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41053 | 5995802.87923545 | 2090583.42381532 | 37.7201034282275 | -122.456557785922 | (37.7201034282275, -122.456557785922) | 9 | 8 | 6 | 28861 | 24 | ||
95210 | 39622 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | 15 | 5 | 11 | 29492 | 9 | ||
95588 | 39655 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 376 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41048 | 5995065.47024954 | 2088318.86087762 | 37.7138431098389 | -122.458942865732 | (37.7138431098389, -122.458942865732) | 9 | 8 | 6 | 28861 | 24 | ||
98613 | 39686 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41071 | 5993225.03289702 | 2090194.07172722 | 37.7188860218946 | -122.465440187198 | (37.7188860218946, -122.465440187198) | 9 | 8 | 6 | 64 | 24 | ||
100219 | 39676 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 520 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.7186098185096 | -122.462555624891 | (37.7186098185096, -122.462555624891) | 9 | 8 | 6 | 28861 | 24 | ||
102020 | 39633 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1122 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41028 | 5997349.94347033 | 2106507.7642786 | 37.7639164882009 | -122.452358638895 | (37.7639164882009, -122.452358638895) | 15 | 5 | 11 | 29492 | 9 | ||
102385 | 39636 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 545 Arch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41030 | 5992712.45358581 | 2090818.32890073 | 37.7205705046206 | -122.46725732212 | (37.7205705046206, -122.46725732212) | 9 | 8 | 6 | 64 | 24 | ||
106990 | 39650 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 114 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41043 | 5994182.55528924 | 2090689.21166175 | 37.7203007349832 | -122.462166324336 | (37.7203007349832, -122.462166324336) | 9 | 8 | 6 | 28861 | 24 | ||
108083 | 39673 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
110468 | 39625 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 1516 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41023 | 5997885.89044429 | 2105542.94174539 | 37.7612980186879 | -122.450435409974 | (37.7612980186879, -122.450435409974) | 15 | 5 | 11 | 29492 | 12 | ||
115533 | 39619 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 172 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41018 | 5997530.61215046 | 2106784.14607791 | 37.7646857112231 | -122.451753702175 | (37.7646857112231, -122.451753702175) | 15 | 5 | 11 | 29492 | 9 | ||
117813 | 39659 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 311 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41051 | 5995887.27205834 | 2090529.96858098 | 37.7199614976995 | -122.456262207219 | (37.7199614976995, -122.456262207219) | 9 | 8 | 6 | 28861 | 24 | ||
120845 | 39623 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | 15 | 5 | 11 | 29492 | 9 | ||
123359 | 39647 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 76 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41041 | 5994176.75103926 | 2090428.14003501 | 37.719583560751 | -122.462167463801 | (37.719583560751, -122.462167463801) | 9 | 8 | 6 | 28861 | 24 | ||
125006 | 39654 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 326 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41047 | 5994205.8673586 | 2092067.47591786 | 37.7240864587641 | -122.462185647149 | (37.7240864587641, -122.462185647149) | 9 | 8 | 4 | 28861 | 24 | ||
127653 | 39615 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 41 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41016 | 5998377.05402267 | 2106536.9754029 | 37.7640554838896 | -122.44880829126 | (37.7640554838896, -122.44880829126) | 15 | 5 | 11 | 29492 | 9 | ||
131995 | 39652 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 141 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41045 | 5994132.92951736 | 2090837.78725757 | 37.7207058303918 | -122.462348633516 | (37.7207058303918, -122.462348633516) | 9 | 8 | 6 | 28861 | 24 | ||
132908 | 39644 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 574 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41038 | 5992766.14260501 | 2091026.39407151 | 37.7211449001063 | -122.46708685721 | (37.7211449001063, -122.46708685721) | 9 | 8 | 6 | 64 | 24 |
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) );