trees
736 rows where DBH = 3 and qLegalStatus_id = 2 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64837 | 253415 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 55 Stoneybrook Ave | Front Yard : Cutout | Tree | Private 2 | 08/31/2017 12:00:00 AM | 3 | Permit Number 779907 | 6005926.97731 | 2093972.42686 | 37.7299849530428 | -122.421802746417 | (37.7299849530428, -122.421802746417) | 9 | 7 | 6 | 28861 | 5 | |||
107033 | 104876 | Planning Code 138.1 required 2 | Prunus laurocerasus :: English laurel 371 | 2478 43rd Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | Permit Number 778928 | 5983068.6 | 2098273.8 | 37.7404797966413 | -122.501143676277 | (37.7404797966413, -122.501143676277) | 1 | 8 | 3 | 29491 | 35 | |||
131611 | 255979 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 965 Powhattan Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776273 | 6009246 | 2098072 | 37.7414281092456 | -122.410617825786 | (37.7414281092456, -122.410617825786) | 10 | 7 | 7 | 28859 | 2 | ||
142797 | 115805 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 872 Kansas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | 6011546.4 | 2104246.9 | 37.7585117443173 | -122.403098033012 | (37.7585117443173, -122.403098033012) | 10 | 3 | 8 | 28856 | 29 | |||
163376 | 253126 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 182 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779117 | 6002742.73008 | 2092646.20381 | 37.7261633586637 | -122.432716365158 | (37.7261633586637, -122.432716365158) | 9 | 7 | 6 | 28861 | 5 | ||
184166 | 115674 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1433 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774098 | 5981190.2 | 2105303.4 | 37.7596706142775 | -122.508159957785 | (37.7596706142775, -122.508159957785) | 1 | 8 | 3 | 56 | 35 | ||
27 | 121462 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.724 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | 9 | 7 | 7 | 309 | 28 | |
685 | 151339 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1411 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781016 | 6009578.8057 | 2100900.01209 | 37.7492118628581 | -122.409666655187 | (37.7492118628581, -122.409666655187) | 2 | 4 | 7 | 28859 | 19 | |
1080 | 169338 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1029 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2019 12:00:00 AM | 3 | Width 4ft | 6006781.41851 | 2114264.09095 | 37.7857493130165 | -122.420288474132 | (37.7857493130165, -122.420288474132) | 13 | 9 | 9 | 28858 | 36 | ||
1519 | 154406 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1270 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782729 | 6004450.91353 | 2101490.17776 | 37.7505436337949 | -122.427441030576 | (37.7505436337949, -122.427441030576) | 2 | 4 | 5 | 28862 | 22 | |
1992 | 260845 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 6 Cragmont Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/15/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782122 | 5992584.1181 | 2101828.636 | 37.7507946382458 | -122.468501593976 | (37.7507946382458, -122.468501593976) | 1 | 8 | 4 | 29491 | 12 | |
2224 | 236583 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
2574 | 216200 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1650 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 784456 | 5992806.74011 | 2104217.97153 | 37.7573679916535 | -122.467905522425 | (37.7573679916535, -122.467905522425) | 1 | 8 | 4 | 56 | 12 | |
2678 | 157809 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 647 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781831 | 6002443.37703 | 2099727.28553 | 37.7455893990301 | -122.4342572226 | (37.7455893990301, -122.4342572226) | 2 | 7 | 5 | 63 | 22 | |
3879 | 260548 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1190 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776221 | |||||||||||
4524 | 183636 | Planning Code 138.1 required 2 | Pittosporum crassifolium :: Karo Tree 95 | 1478 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 3x9 | Permit Number 781673 | 5981570.9282 | 2105017.3718 | 37.7589076903569 | -122.506822015648 | (37.7589076903569, -122.506822015648) | 1 | 8 | 3 | 56 | 35 | |
4536 | 224986 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 484 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782366 | 6003589.47712 | 2105476.68017 | 37.7614408647212 | -122.430704387917 | (37.7614408647212, -122.430704387917) | 15 | 4 | 5 | 28862 | 3 | |
4685 | 163919 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 528 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 785290 | 5993187.06549 | 2105302.66577 | 37.7603682343238 | -122.466669061634 | (37.7603682343238, -122.466669061634) | 1 | 8 | 4 | 56 | 12 | |
4743 | 167761 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 451 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780770 | 6000439.87639 | 2107208.3352 | 37.7660166188918 | -122.441721798828 | (37.7660166188918, -122.441721798828) | 15 | 5 | 5 | 29492 | 3 | |
4820 | 253072 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1350 46th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | 6x10 | Permit Number 780489 | 5981849.66657 | 2105897.22193 | 37.7613399178539 | -122.50592325662 | (37.7613399178539, -122.50592325662) | 1 | 8 | 3 | 56 | 35 | |
5071 | 254119 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 150 Jennings St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | ||||||||||||
5412 | 261620 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1633 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2020 12:00:00 AM | 3 | 3x3 | 6006860 | 2117000 | 37.7932658708928 | -122.420210847334 | (37.7932658708928, -122.420210847334) | 13 | 9 | 10 | 28858 | 32 | ||
5422 | 122567 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 241 Flournoy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 3x3 | Permit Number 777809 | 5994026.14526 | 2086558.74537 | 37.7089504501359 | -122.46240754496 | (37.7089504501359, -122.46240754496) | 9 | 8 | 6 | 28861 | 25 | |
5670 | 253203 | Planning Code 138.1 required 2 | Acer buergeranum :: Trident Maple 110 | 349 Mangels Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5999103 | 2095207 | 37.732987611392 | -122.445482716078 | (37.732987611392, -122.445482716078) | 9 | 7 | 4 | 59 | 40 | ||
5901 | 260465 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3933 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2019 12:00:00 AM | 3 | 3x4 | Permit Number 782033 | 6005003.24747 | 2095750.87761 | 37.7348160467336 | -122.425122689163 | (37.7348160467336, -122.425122689163) | 2 | 7 | 7 | 28861 | 2 | |
6077 | 230988 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 44 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2018 12:00:00 AM | 3 | 3x6 | Permit Number 778706 | 6007424.10799 | 2099038.48568 | 37.7439795505181 | -122.416985775987 | (37.7439795505181, -122.416985775987) | 2 | 7 | 7 | 28859 | 2 | |
6587 | 261546 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1955 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2020 12:00:00 AM | 3 | 3X3 | Permit Number 783144 | 5985360.77923 | 2101907.46183 | 37.750591180724 | -122.493485992107 | (37.750591180724, -122.493485992107) | 1 | 8 | 3 | 29491 | 35 | |
6664 | 226514 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1225 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781565 | 6005204.64951 | 2101211.39699 | 37.7498207677153 | -122.424814719741 | (37.7498207677153, -122.424814719741) | 2 | 4 | 5 | 28859 | 19 | |
6762 | 260431 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 181 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2019 12:00:00 AM | 3 | 3x3 | 6013986 | 2115554 | 37.7896944377585 | -122.395452879395 | (37.7896944377585, -122.395452879395) | 12 | 2 | 9 | 28855 | 6 | ||
7193 | 254151 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 201 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 4x4 | Permit Number 781165 | |||||||||||
7195 | 4140 | Planning Code 138.1 required 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3620 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2020 12:00:00 AM | 3 | 3x6 | Permit Number 780969 | 6006062.29639 | 2100597.35658 | 37.7481831571401 | -122.421805323766 | (37.7481831571401, -122.421805323766) | 2 | 4 | 5 | 28859 | 19 | |
7494 | 243413 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 77 Belgrave Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781419 | 5998151.68157 | 2104894.95588 | 37.7595340204918 | -122.449469463666 | (37.7595340204918, -122.449469463666) | 15 | 5 | 11 | 28862 | 12 | |
8008 | 260640 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 3936 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776281 | 6004258 | 2100777 | 37.7485745007292 | -122.428057323873 | (37.7485745007292, -122.428057323873) | 2 | 4 | 5 | 28862 | 22 | |
8011 | 260843 | Planning Code 138.1 required 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1015 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779771 | 6011450.48648 | 2090129.50026 | 37.719743011404 | -122.402437083292 | (37.719743011404, -122.402437083292) | 10 | 7 | 8 | 309 | 28 | |
8102 | 260181 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 3x3 | 6006141 | 2109130 | 37.7716162396968 | -122.422139269172 | (37.7716162396968, -122.422139269172) | 8 | 2 | 9 | 28853 | 19 | ||
8278 | 258683 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 222 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/06/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782190 | 5990522.43491 | 2094710.12159 | 37.7311297256611 | -122.475111403646 | (37.7311297256611, -122.475111403646) | 1 | 8 | 4 | 64 | 35 | |
8319 | 260505 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 760 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784870 | 6007464 | 2105234 | 37.7609932681872 | -122.417286789238 | (37.7609932681872, -122.417286789238) | 2 | 4 | 7 | 28859 | 19 | |
8349 | 163331 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 159 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780897 | 5995371.93865 | 2087733.0149 | 37.7122521261194 | -122.45784123641 | (37.7122521261194, -122.45784123641) | 9 | 8 | 6 | 28861 | 24 | |
8434 | 255770 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2018 12:00:00 AM | 3 | Permit Number 779472 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
8598 | 121137 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1388x Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
8601 | 222646 | Planning Code 138.1 required 2 | Ceanothus Sps :: California lilac 192 | 4209 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2018 12:00:00 AM | 3 | Width 3ft | 6001770.77195 | 2101738.59247 | 37.7510737715579 | -122.436726932715 | (37.7510737715579, -122.436726932715) | 2 | 4 | 5 | 28862 | 22 | ||
8713 | 261829 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 256 Casitas Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781540 | 5994862.12068 | 2096567.59314 | 37.7364804498834 | -122.460242983215 | (37.7364804498834, -122.460242983215) | 9 | 7 | 4 | 59 | 40 | |
8777 | 18349 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 480 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6010308 | 2106081 | 37.7634785336334 | -122.407510304274 | (37.7634785336334, -122.407510304274) | 8 | 4 | 8 | 28859 | 19 | ||
9544 | 261378 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1762 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784740 | 5990006.33488 | 2103376.99766 | 37.7548967913393 | -122.477528860126 | (37.7548967913393, -122.477528860126) | 1 | 8 | 3 | 56 | 35 | |
9750 | 169122 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 210 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2019 12:00:00 AM | 3 | Width 4ft | 6009478.56357 | 2113738.5186 | 37.7844578281201 | -122.410919945006 | (37.7844578281201, -122.410919945006) | 14 | 10 | 9 | 28852 | 36 | ||
10742 | 166681 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 563 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2019 12:00:00 AM | 3 | 3x3 | 6002718.47853 | 2102666.28528 | 37.7536748096657 | -122.433515959096 | (37.7536748096657, -122.433515959096) | 2 | 4 | 5 | 28862 | 22 | ||
11143 | 258742 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 367 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774042 | 6003945 | 2103884 | 37.7570878795298 | -122.429361203627 | (37.7570878795298, -122.429361203627) | 2 | 4 | 5 | 28862 | 3 | |
11330 | 166753 | Planning Code 138.1 required 2 | Schinus molle :: California Pepper 91 | 350 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2019 12:00:00 AM | 3 | 4x4 | Permit Number 781737 | 6002856.72425 | 2101550.76622 | 37.7506197011549 | -122.43295818429 | (37.7506197011549, -122.43295818429) | 2 | 4 | 5 | 28862 | 22 | |
11885 | 157920 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4147 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777832 | 6002961.17206 | 2100636.31842 | 37.7481147664022 | -122.432531686182 | (37.7481147664022, -122.432531686182) | 2 | 4 | 5 | 63 | 22 | |
11989 | 261017 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774761 | 5992858 | 2101375 | 37.749564886931 | -122.467521508976 | (37.749564886931, -122.467521508976) | 1 | 8 | 4 | 29491 | 12 | |
12003 | 166317 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008865.69274 | 2103234.56357 | 37.755582030708 | -122.412297603862 | (37.755582030708, -122.412297603862) | 2 | 4 | 7 | 28859 | 19 | |
12151 | 145130 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 218 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2020 12:00:00 AM | 3 | 4x4 | Permit Number 785634 | 5992772.08387 | 2113986.425 | 37.7841875521538 | -122.468736166845 | (37.7841875521538, -122.468736166845) | 11 | 6 | 2 | 54 | 11 | |
12391 | 221098 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2815 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009314.5684 | 2105431.86525 | 37.7616405016156 | -122.410900429722 | (37.7616405016156, -122.410900429722) | 2 | 4 | 7 | 28859 | 19 | |
12677 | 259879 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Romain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2019 12:00:00 AM | 3 | 3x3 | Permit Number 776294 | 6001192.18773 | 2103413.52714 | 37.7556398401092 | -122.438847746407 | (37.7556398401092, -122.438847746407) | 2 | 4 | 5 | 28862 | 3 | |
12808 | 254368 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 590X Orizaba Ave | 1 | Back Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | ||||||||||||
13014 | 167662 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 24 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | 3x6 | 6000818.42136 | 2106216.38176 | 37.7633145212709 | -122.440341345773 | (37.7633145212709, -122.440341345773) | 15 | 5 | 5 | 28862 | 3 | ||
13165 | 152981 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006333.00148 | 2102621.91378 | 37.753757389911 | -122.421012959005 | (37.753757389911, -122.421012959005) | 2 | 4 | 5 | 28859 | 19 | |
13240 | 157603 | Planning Code 138.1 required 2 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 16 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2020 12:00:00 AM | 3 | 5x5 | Permit Number 784681 | 6000322.25182 | 2101567.57465 | 37.7505217703771 | -122.441723777343 | (37.7505217703771, -122.441723777343) | 2 | 4 | 5 | 28862 | 22 | |
13567 | 243284 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007678.08789 | 2107386.86578 | 37.766916579475 | -122.416698868869 | (37.766916579475, -122.416698868869) | 8 | 4 | 7 | 28853 | 19 | |
14212 | 253124 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 399x Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780530 | |||||||||||
14258 | 261352 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 297 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780859 | 5994172 | 2087374 | 37.7111973453091 | -122.461962532307 | (37.7111973453091, -122.461962532307) | 9 | 8 | 6 | 28861 | 24 | |
14313 | 261295 | Planning Code 138.1 required 2 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 185 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/20/2019 12:00:00 AM | 3 | 3x10 | Permit Number 782878 | 5990774.03183 | 2093262.32002 | 37.727169005397 | -122.474135998689 | (37.727169005397, -122.474135998689) | 9 | 8 | 4 | 64 | 40 | |
14666 | 102429 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 200 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010552.49087 | 2111923.99595 | 37.7795357369219 | -122.407076563634 | (37.7795357369219, -122.407076563634) | 14 | 2 | 9 | 28853 | 34 | |
14905 | 260579 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1662 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782799 | 5985048 | 2103886 | 37.7560054004173 | -122.494713443881 | (37.7560054004173, -122.494713443881) | 1 | 8 | 3 | 56 | 35 | |
14929 | 256105 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1935 34th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Port | 09/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778629 | 5985666.45669 | 2102048.38182 | 37.7509959848908 | -122.492439326416 | (37.7509959848908, -122.492439326416) | 1 | 8 | 3 | 29491 | 35 |
15059 | 254699 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 | ||
15290 | 25338 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
15356 | 251313 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 390 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2019 12:00:00 AM | 3 | 4x4 | Permit Number 779703 | 6003369 | 2099547 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | 2 | 7 | 5 | 63 | 22 | |
15413 | 262220 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781435 | 6004728 | 2102256 | 37.7526620712812 | -122.426537368454 | (37.7526620712812, -122.426537368454) | 2 | 4 | 5 | 28862 | 22 | |
15497 | 33110 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2626 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2020 12:00:00 AM | 3 | Permit Number 769981 | 6000381.41365 | 2118563.70291 | 37.7971922129921 | -122.442739455458 | (37.7971922129921, -122.442739455458) | 13 | 9 | 1 | 57 | 17 | |
15585 | 258769 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 1633 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2019 12:00:00 AM | 3 | 3x3 | 5988962.35654 | 2103065.4403 | 37.7539807026125 | -122.481116375927 | (37.7539807026125, -122.481116375927) | 1 | 8 | 3 | 56 | 35 | ||
15827 | 262585 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2 Byron Ct | 1 | Front Yard : Yard | Tree | Private 2 | 08/19/2020 12:00:00 AM | 3 | 8x8 | Permit Number 781313 | 5999459.72778 | 2086749.57445 | 37.7097858201455 | -122.443642066205 | (37.7097858201455, -122.443642066205) | 9 | 7 | 6 | 28861 | 5 | |
16304 | 162975 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 131 Harold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5996790.92866 | 2090757.22233 | 37.72063731584 | -122.453154991525 | (37.72063731584, -122.453154991525) | 9 | 8 | 6 | 28861 | 24 | |||
16386 | 262532 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 815 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781917 | 5999987.51846 | 2111668.14853 | 37.7782363548085 | -122.443606817465 | (37.7782363548085, -122.443606817465) | 15 | 5 | 11 | 29490 | 16 | |
16474 | 253340 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780536 | 6004464 | 2102825 | 37.7542094840672 | -122.427490860103 | (37.7542094840672, -122.427490860103) | 2 | 4 | 5 | 28862 | 22 | |
16618 | 251060 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5418 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 777516 | 5990225.155 | 2112720.9896 | 37.7805655538274 | -122.477455019941 | (37.7805655538274, -122.477455019941) | 11 | 6 | 2 | 55 | 26 | ||
16780 | 85805 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627 | 2111882 | 37.7794804977568 | -122.403356401218 | (37.7794804977568, -122.403356401218) | 14 | 2 | 9 | 28856 | 34 | |
17123 | 254549 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 170 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2020 12:00:00 AM | 3 | 3x3 | 5992784 | 2114350 | 37.7851865177567 | -122.46872140612 | (37.7851865177567, -122.46872140612) | 11 | 6 | 2 | 54 | 11 | ||
17276 | 72565 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 770847 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | ||
17700 | 260555 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 502 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2019 12:00:00 AM | 3 | 3x3 | 6011196 | 2109910 | 37.7740417608934 | -122.404708555539 | (37.7740417608934, -122.404708555539) | 14 | 2 | 9 | 28853 | 34 | ||
17726 | 65839 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2328 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2018 12:00:00 AM | 3 | 6x6 | Permit Number 772721 | 5999589.88517 | 2120533.82376 | 37.802556482867 | -122.445620078411 | (37.802556482867, -122.445620078411) | 13 | 9 | 1 | 57 | 17 | |
17746 | 262424 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 328 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2020 12:00:00 AM | 3 | 3x3 | 6006735.98718 | 2096026.524 | 37.7356706425738 | -122.419151541699 | (37.7356706425738, -122.419151541699) | 2 | 7 | 7 | 28859 | 2 | ||
17863 | 261376 | Planning Code 138.1 required 2 | Olea Majestic Beauty :: 183 | 3015 25th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 4x10 | Permit Number 784883 | 5988814.87181 | 2095155.07295 | 37.7322523337557 | -122.481047245899 | (37.7322523337557, -122.481047245899) | 1 | 8 | 4 | 64 | 35 | |
17886 | 261591 | Planning Code 138.1 required 2 | :: 45 | 1747 Cayuga Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/28/2020 12:00:00 AM | 3 | Permit Number 784552 | 5998049.81023 | 2088594.07996 | 37.7147698965646 | -122.44864773571 | (37.7147698965646, -122.44864773571) | 9 | 7 | 6 | 28861 | 25 | ||
18060 | 258219 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
18063 | 259659 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4061 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784440 | 6003514 | 2100377 | 37.7474340728524 | -122.430601526112 | (37.7474340728524, -122.430601526112) | 2 | 4 | 5 | 63 | 22 | |
18437 | 260868 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6009475 | 2113668 | 37.7842640010762 | -122.410927291409 | (37.7842640010762, -122.410927291409) | 14 | 10 | 9 | 28852 | 36 | ||
18618 | 170106 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 527 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/18/2020 12:00:00 AM | 3 | 6x10 | Permit Number 783167 | 5997920.28587 | 2095246.22061 | 37.7330277118397 | -122.449574473879 | (37.7330277118397, -122.449574473879) | 9 | 7 | 4 | 59 | 40 | |
18657 | 251312 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1499 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2019 12:00:00 AM | 3 | 4x4 | Permit Number 779703 | 6003369 | 2099547 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | 2 | 7 | 5 | 63 | 22 | |
19030 | 221366 | Planning Code 138.1 required 2 | Quercus suber :: Cork Oak 78 | 55 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2019 12:00:00 AM | 3 | 3x3 | Permit Number 778991 | 6000992.93047 | 2101385.53728 | 37.7500601303816 | -122.439391477336 | (37.7500601303816, -122.439391477336) | 2 | 4 | 5 | 28862 | 22 | |
19087 | 261350 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
19209 | 122592 | Planning Code 138.1 required 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 72 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
19431 | 242096 | Planning Code 138.1 required 2 | Quercus suber :: Cork Oak 78 | 3721 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2019 12:00:00 AM | 3 | 4x4 | Permit Number 769571 | 6003563.92038 | 2103590.2718 | 37.756259789464 | -122.430658162741 | (37.756259789464, -122.430658162741) | 2 | 4 | 5 | 28862 | 22 | |
20472 | 124717 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 610 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 775784 | 6007724.21349 | 2097196.46477 | 37.7389386461297 | -122.415817669649 | (37.7389386461297, -122.415817669649) | 2 | 7 | 7 | 28859 | 2 | |
20702 | 37086 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1426 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2017 12:00:00 AM | 3 | Permit Number 780691 | 5981873.63686209 | 2105374.96731705 | 37.7599073668224 | -122.505801636192 | (37.7599073668224, -122.505801636192) | 1 | 8 | 3 | 56 | 35 | |
21720 | 122796 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 306 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2016 12:00:00 AM | 3 | 3x3 | 6009497.08014 | 2088289.51504 | 37.7145815488228 | -122.4090595839 | (37.7145815488228, -122.4090595839) | 9 | 7 | 8 | 309 | 39 | ||
22723 | 119256 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 195 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2016 12:00:00 AM | 3 | 3x3 | 6010242 | 2098801 | 37.7434855758555 | -122.407225363197 | (37.7434855758555, -122.407225363197) | 2 | 7 | 7 | 28859 | 2 | ||
23551 | 121466 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 79 Harrington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778952 | 6001819.85633 | 2092538.60283 | 37.7258155279415 | -122.435898987028 | (37.7258155279415, -122.435898987028) | 9 | 7 | 6 | 28861 | 25 | |
23615 | 117008 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1315 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | 6006952.61647 | 2093135.11232 | 37.7277436552341 | -122.418197638517 | (37.7277436552341, -122.418197638517) | 9 | 3 | 7 | 309 | 5 | ||
24135 | 254150 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2123 30th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 3x6 | Permit Number 778310 | 5986951.71761 | 2100810.65655 | 37.7476725845461 | -122.487903895201 | (37.7476725845461, -122.487903895201) | 1 | 8 | 3 | 29491 | 35 |
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) );