trees
104 rows where Police Districts = 7 and qLegalStatus_id = 2 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3850 | 262121 | Planning Code 138.1 required 2 | Potential Site :: Potential Site 48 | 296x Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004047 | 2098716 | 37.7429035313116 | -122.428640063872 | (37.7429035313116, -122.428640063872) | 2 | 7 | 5 | 63 | 22 | ||||
6487 | 261445 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007092 | 2095790 | 37.7350412423636 | -122.417903903871 | (37.7350412423636, -122.417903903871) | 2 | 7 | 7 | 28859 | 2 | ||||
7182 | 262122 | Planning Code 138.1 required 2 | Potential Site :: Potential Site 48 | 296x Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004047 | 2098716 | 37.7429035313116 | -122.428640063872 | (37.7429035313116, -122.428640063872) | 2 | 7 | 5 | 63 | 22 | ||||
8190 | 261370 | Planning Code 138.1 required 2 | Eriobotrya japonica :: Edible Loquat 119 | 102 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007140 | 2095356 | 37.7338522748733 | -122.417707198486 | (37.7338522748733, -122.417707198486) | 2 | 7 | 7 | 28859 | 2 | ||||
11346 | 261371 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 105 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007217 | 2095358 | 37.7338620991787 | -122.417441127318 | (37.7338620991787, -122.417441127318) | 2 | 7 | 7 | 28859 | 2 | ||||
14175 | 260509 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 436 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5995686 | 2095271 | 37.7329676771739 | -122.457300730651 | (37.7329676771739, -122.457300730651) | 9 | 7 | 4 | 59 | 40 | ||||
33539 | 114537 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 1624 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | 3x4 | 6009248.6 | 2099914.9 | 37.7464884538144 | -122.41073895467 | (37.7464884538144, -122.41073895467) | 2 | 7 | 7 | 28859 | 2 | |||
144520 | 43569 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2000 12:00:00 AM | 3x3 | Permit Number 43230 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 | ||
158236 | 116267 | Planning Code 138.1 required 2 | Acer japonicum :: Japanese Maple 124 | 717 PARIS ST | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001138 | 2089523 | 37.7174966063475 | -122.438040195581 | (37.7174966063475, -122.438040195581) | 9 | 7 | 6 | 28861 | 5 | ||||
170182 | 258184 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 95 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003372 | 2097903 | 37.74063299685 | -122.430916015884 | (37.74063299685, -122.430916015884) | 2 | 7 | 5 | 63 | 7 | ||||
172871 | 256721 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1025 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 776275 | 6009358 | 2098062 | 37.7414069300959 | -122.410229861131 | (37.7414069300959, -122.410229861131) | 10 | 7 | 7 | 28859 | 2 | |||
4773 | 165865 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 275 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x4 | 6006836.83511 | 2097542.23848 | 37.7398381374333 | -122.418910337746 | (37.7398381374333, -122.418910337746) | 2 | 7 | 7 | 28859 | 2 | |||
5173 | 169519 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1753 Noe St | 1 | Front Yard : Yard | Tree | Private 2 | 0 | 8x8 | Permit Number 779099 | 6003417.91334 | 2098032.77345 | 37.7409919262491 | -122.430766523865 | (37.7409919262491, -122.430766523865) | 2 | 7 | 5 | 63 | 7 | ||
21868 | 221950 | Planning Code 138.1 required 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 31 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 780973 | 6006097.6775 | 2099053.58173 | 37.7439462971915 | -122.421573349947 | (37.7439462971915, -122.421573349947) | 2 | 7 | 7 | 28859 | 2 | ||
95475 | 46434 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011096.25435 | 2089701.2859 | 37.7185474406786 | -122.40363143174 | (37.7185474406786, -122.40363143174) | 10 | 7 | 8 | 309 | 28 | |
90355 | 222216 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | 2 | 7 | 5 | 63 | 7 | ||
58996 | 242613 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 48 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Permit Number 777782 | 6007306.44134 | 2099195.30791 | 37.7444035295914 | -122.417403753004 | (37.7444035295914, -122.417403753004) | 2 | 7 | 7 | 28859 | 2 | ||
60942 | 247939 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 29 Joy St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 12 | Permit Number 775404 | 6010258.29977 | 2098917.51569 | 37.7438064148349 | -122.40717721395 | (37.7438064148349, -122.40717721395) | 2 | 7 | 7 | 28859 | 2 | |||
115391 | 224618 | Planning Code 138.1 required 2 | Ficus microcarpa :: Chinese Banyan 97 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | 2 | 7 | 5 | 63 | 7 | ||
37358 | 247943 | Planning Code 138.1 required 2 | Maytenus boaria :: Mayten 58 | 29 Joy St | 6 | Unaccepted Street : Yard | Tree | DPW 1 | 2 | Permit Number 775404 | 6010304.2598 | 2098903.51059 | 37.7437705318851 | -122.407017307297 | (37.7437705318851, -122.407017307297) | 2 | 7 | 7 | 28859 | 2 | |||
3 | 121463 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 415 Oxford St | 2 | 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 | |
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 | |
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 | |
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 | |
7505 | 247942 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 3 | Permit Number 775404 | 6010292.72224 | 2098904.67919 | 37.7437730949632 | -122.407057283984 | (37.7437730949632, -122.407057283984) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
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 | |
12606 | 261830 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 256 Casitas Ave | 2 | 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 | |
14035 | 159355 | Planning Code 138.1 required 2 | Melaleuca quinquenervia :: Cajeput 10 | 417 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998509.88268 | 2087558.19074 | 37.7119518775514 | -122.44698304145 | (37.7119518775514, -122.44698304145) | 9 | 7 | 6 | 28861 | 25 | |
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 | |
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 | |
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 | ||
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 | ||
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 | |
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 | |
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 | |
27220 | 159357 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 49 Naglee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998577.13551 | 2087591.01668 | 37.7120458522191 | -122.446752958004 | (37.7120458522191, -122.446752958004) | 9 | 7 | 6 | 28861 | 25 | |
27355 | 239457 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 165 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001959.66963 | 2096487.1672 | 37.7366653238346 | -122.435698035437 | (37.7366653238346, -122.435698035437) | 2 | 7 | 5 | 63 | 7 | |
32243 | 66394 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 504 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x4 | Permit Number 772815 | 6007447.25872729 | 2096493.62336554 | 37.7369932248849 | -122.41672547553 | (37.7369932248849, -122.41672547553) | 2 | 7 | 7 | 28859 | 2 | |
39006 | 253854 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650 Joost Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | 10x9 | Permit Number 776163 | 5997782.66631 | 2095011.71334 | 37.7323759368037 | -122.450033362597 | (37.7323759368037, -122.450033362597) | 9 | 7 | 4 | 59 | 40 | |
40028 | 57959 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 336 Hanover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774423 | 5999490.29697456 | 2086502.70799744 | 37.7091097236101 | -122.443518692288 | (37.7091097236101, -122.443518692288) | 9 | 7 | 6 | 28861 | 5 | |
41739 | 253164 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 146 Cambridge St | 1 | Front Yard : Cutout | Tree | Private 2 | 07/27/2017 12:00:00 AM | 3 | 4x4 | 6006598.94029 | 2094006.41191 | 37.7301161400075 | -122.419482094225 | (37.7301161400075, -122.419482094225) | 9 | 7 | 7 | 309 | 5 | ||
45743 | 161753 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 175x Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001022 | 2087749 | 37.7126190008501 | -122.43831413288 | (37.7126190008501, -122.43831413288) | 9 | 7 | 6 | 28861 | 5 | |
46971 | 110398 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2St. Ankeny St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011080.03742 | 2089739.99739 | 37.7186528286367 | -122.403690209641 | (37.7186528286367, -122.403690209641) | 10 | 7 | 8 | 309 | 28 | |||
48760 | 255654 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 298X Coso Ave | 2 | Side Yard : Yard | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 10x10 | Permit Number 776462 | 6007785 | 2099424 | 37.7450583812321 | -122.415765181935 | (37.7450583812321, -122.415765181935) | 2 | 7 | 7 | 28859 | 2 | |
48832 | 243143 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 98x Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195 | 2098242 | 37.7417233638646 | -122.421179213365 | (37.7417233638646, -122.421179213365) | 2 | 7 | 7 | 28859 | 2 | ||
51236 | 243740 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 550 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 776473 | 6003047.05577 | 2096015.80768 | 37.7354327831918 | -122.431904827248 | (37.7354327831918, -122.431904827248) | 2 | 7 | 5 | 63 | 7 | |
53406 | 256184 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 412 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 10x3 | Permit Number 770911 | 5998674.66662 | 2094402.01563 | 37.7307528521501 | -122.446905665072 | (37.7307528521501, -122.446905665072) | 9 | 7 | 4 | 59 | 40 | |
58719 | 121093 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 150 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778915 | 5996816.77701 | 2094570.70089 | 37.7311097051787 | -122.453340820219 | (37.7311097051787, -122.453340820219) | 9 | 7 | 4 | 59 | 40 | ||
59056 | 160371 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 868 Edinburgh St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001686.38396 | 2088939.39451 | 37.7159253269669 | -122.436102948002 | (37.7159253269669, -122.436102948002) | 9 | 7 | 6 | 28861 | 5 | |
60006 | 257929 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 255 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781730 | 5999620.44198 | 2090680.5387 | 37.7205885233371 | -122.443368776907 | (37.7205885233371, -122.443368776907) | 9 | 7 | 6 | 28861 | 25 | |
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 | |||
67632 | 159354 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 417x Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998501.29354 | 2087549.7908 | 37.7119283225022 | -122.447012123728 | (37.7119283225022, -122.447012123728) | 9 | 7 | 6 | 28861 | 25 | |
71010 | 251406 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 445 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2017 12:00:00 AM | 3 | 3x3 | 6001636 | 2088904 | 37.7158252789105 | -122.436274566668 | (37.7158252789105, -122.436274566668) | 9 | 7 | 6 | 28861 | 5 | ||
71921 | 256722 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776274 | 6009288 | 2098069 | 37.7414222265504 | -122.410472391962 | (37.7414222265504, -122.410472391962) | 10 | 7 | 7 | 28859 | 2 | |
74714 | 166016 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 3332 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776384 | 6008453.51061 | 2099255.43212 | 37.7446330896597 | -122.413441663829 | (37.7446330896597, -122.413441663829) | 2 | 7 | 7 | 28859 | 2 | |
76325 | 253875 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 274 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777423 | 6003013.5236 | 2093666.24958 | 37.728979528994 | -122.431853049446 | (37.728979528994, -122.431853049446) | 9 | 7 | 6 | 28861 | 25 | |
78754 | 119257 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 191 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2016 12:00:00 AM | 3 | 3x3 | 6010220 | 2098811 | 37.743511802413 | -122.407302138847 | (37.743511802413, -122.407302138847) | 2 | 7 | 7 | 28859 | 2 | ||
84579 | 116262 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 35 La Grande Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/2016 12:00:00 AM | 3 | 3x4 | 6005278.18089 | 2092026.49943 | 37.7246052551119 | -122.42390739822 | (37.7246052551119, -122.42390739822) | 9 | 7 | 6 | 309 | 5 | ||
93272 | 256871 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1025 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776275 | 6009358.6182 | 2098062.94866 | 37.7414095695618 | -122.410227790564 | (37.7414095695618, -122.410227790564) | 10 | 7 | 7 | 28859 | 2 | |
98671 | 256868 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 965 Powhattan Ave | 1 | Side Yard : Yard | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776273 | 6009246.49493 | 2098072.65991 | 37.7414299489627 | -122.410616161073 | (37.7414299489627, -122.410616161073) | 10 | 7 | 7 | 28859 | 2 | |
100425 | 243144 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 98x Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195 | 2098242 | 37.7417233638646 | -122.421179213365 | (37.7417233638646, -122.421179213365) | 2 | 7 | 7 | 28859 | 2 | ||
100907 | 229627 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 3662 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778622 | 6008456.11159 | 2097816.22885 | 37.7406815009641 | -122.413330912287 | (37.7406815009641, -122.413330912287) | 2 | 7 | 7 | 28859 | 2 | |
102650 | 120680 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 522 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2016 12:00:00 AM | 3 | 3x3 | 6003717 | 2090174 | 37.7194304401491 | -122.42917217064 | (37.7194304401491, -122.42917217064) | 9 | 7 | 6 | 28861 | 5 | ||
103770 | 170499 | Planning Code 138.1 required 2 | Rhamnus alaternus :: Italian Buckthorn 29 | 1178 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779173 | 6003338.82121 | 2094328.64534 | 37.7308167537817 | -122.430775723045 | (37.7308167537817, -122.430775723045) | 9 | 7 | 5 | 28861 | 25 | |
108115 | 242845 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 1559 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2018 12:00:00 AM | 3 | 3x3 | 6004609.7731 | 2099770.4554 | 37.7458306574531 | -122.426769226215 | (37.7458306574531, -122.426769226215) | 2 | 7 | 5 | 63 | 22 | ||
112660 | 169518 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1783 Noe St | 1 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780948 | 6003426.12868 | 2097901.04069 | 37.7406306838602 | -122.430728719953 | (37.7406306838602, -122.430728719953) | 2 | 7 | 5 | 63 | 7 | |
113669 | 159358 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 49 Naglee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998584.62871 | 2087583.88571 | 37.712026700246 | -122.446726546692 | (37.712026700246, -122.446726546692) | 9 | 7 | 6 | 28861 | 25 | |
114847 | 253246 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1192 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001173 | 2087586 | 37.7121800264355 | -122.437780563503 | (37.7121800264355, -122.437780563503) | 9 | 7 | 6 | 28861 | 5 | |
120065 | 258340 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 121 Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2019 12:00:00 AM | 3 | 3x3 | 6010033.53413 | 2086907.42536 | 37.7108166491636 | -122.407108010284 | (37.7108166491636, -122.407108010284) | 9 | 7 | 8 | 309 | 39 | ||
122256 | 254396 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 167 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 774780 | 6006150.23201 | 2093073.81475 | 37.7275301484246 | -122.420967149802 | (37.7275301484246, -122.420967149802) | 9 | 7 | 7 | 309 | 5 | |
124453 | 158406 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 50 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2017 12:00:00 AM | 3 | 3X3 | Permit Number 770857 | 6001789.37716 | 2096842.5543 | 37.7376314601307 | -122.436312235543 | (37.7376314601307, -122.436312235543) | 2 | 7 | 5 | 63 | 7 | |
126952 | 175423 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 175 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2017 12:00:00 AM | 3 | Width 3ft | 6004547.44022 | 2093795.9618 | 37.7294225258266 | -122.426559415306 | (37.7294225258266, -122.426559415306) | 9 | 7 | 6 | 28861 | 5 | ||
129107 | 46432 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2St. Ankeny St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2002 12:00:00 AM | 3 | 3x3 | Permit Number 44652 | 6011085.82067 | 2089727.08588 | 37.7186176993268 | -122.403669311209 | (37.7186176993268, -122.403669311209) | 10 | 7 | 8 | 309 | 28 | |
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 | ||
133424 | 254076 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 416 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2017 12:00:00 AM | 3 | 3x3 | 6003139 | 2099532 | 37.7450926486102 | -122.431837924964 | (37.7450926486102, -122.431837924964) | 2 | 7 | 5 | 63 | 22 | ||
134738 | 115357 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 270 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2016 12:00:00 AM | 3 | 3x6 | 5999894.51999 | 2091641.88128 | 37.7232437759734 | -122.442490363056 | (37.7232437759734, -122.442490363056) | 9 | 7 | 6 | 28861 | 25 | ||
142552 | 120109 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 555 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2016 12:00:00 AM | 3 | 3x3 | 5997970 | 2087042 | 37.7105036758619 | -122.448811863159 | (37.7105036758619, -122.448811863159) | 9 | 7 | 6 | 28861 | 25 | ||
147840 | 170500 | Planning Code 138.1 required 2 | Rhamnus alaternus :: Italian Buckthorn 29 | 1178 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779173 | 6003320.2391 | 2094320.37512 | 37.7307929928046 | -122.430839374365 | (37.7307929928046, -122.430839374365) | 9 | 7 | 5 | 28861 | 25 | |
148882 | 159485 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125 Farragut Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782109 | 5997299.08146 | 2087363.42174 | 37.7113478362182 | -122.451153855174 | (37.7113478362182, -122.451153855174) | 9 | 7 | 6 | 28861 | 25 | |
151446 | 170486 | Planning Code 138.1 required 2 | Rhamnus alaternus :: Italian Buckthorn 29 | 121 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779173 | 6003308.3245 | 2094432.02915 | 37.7310988944888 | -122.430888530379 | (37.7310988944888, -122.430888530379) | 9 | 7 | 5 | 28861 | 25 | |
152864 | 124718 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 610 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2018 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 | |
155799 | 256869 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776274 | 6009287.99434 | 2098069.06568 | 37.7414224065761 | -122.410472416169 | (37.7414224065761, -122.410472416169) | 10 | 7 | 7 | 28859 | 2 | |
156678 | 255580 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 384 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778885 | 6003411.13256 | 2099532.22132 | 37.7451086791398 | -122.430896954644 | (37.7451086791398, -122.430896954644) | 2 | 7 | 5 | 63 | 22 | |
158600 | 160369 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 868 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001700.06015 | 2088961.7176 | 37.7159873981889 | -122.436057273237 | (37.7159873981889, -122.436057273237) | 9 | 7 | 6 | 28861 | 5 | |
159683 | 239458 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 165 Sussex St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001977.4736 | 2096494.97635 | 37.7366877772239 | -122.435637038029 | (37.7366877772239, -122.435637038029) | 2 | 7 | 5 | 63 | 7 | |
160778 | 215785 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 16 Agua Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 775074 | 5997502.62133 | 2098608.67839 | 37.7422363073547 | -122.451260857411 | (37.7422363073547, -122.451260857411) | 9 | 7 | 4 | 59 | 40 | |
162589 | 108261 | Planning Code 138.1 required 2 | Melaleuca quinquenervia :: Cajeput 10 | 379 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774479 | 6002548.02456 | 2091247.69967 | 37.7223123355393 | -122.433289563782 | (37.7223123355393, -122.433289563782) | 9 | 7 | 6 | 28861 | 5 | |
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 | ||
168649 | 243745 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 130 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774373 | 6003834.27428 | 2096405.12406 | 37.7365463534355 | -122.429210869408 | (37.7365463534355, -122.429210869408) | 2 | 7 | 5 | 63 | 7 | |
174013 | 257892 | Planning Code 138.1 required 2 | Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 | 91 Canyon Dr | 1 | Front Yard : Yard | Tree | Private 2 | 01/11/2019 12:00:00 AM | 3 | 3x3 | 6002890 | 2086311 | 37.7087766368694 | -122.43175513536 | (37.7087766368694, -122.43175513536) | 9 | 7 | 6 | 28861 | 5 | ||
176317 | 256115 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 503 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 774745 | 6007867.72621 | 2096528.91607 | 37.7371137709195 | -122.41527422465 | (37.7371137709195, -122.41527422465) | 2 | 7 | 7 | 28859 | 2 | |
179761 | 160920 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 666 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779533 | 6002104.11317 | 2090113.36167 | 37.7191725036747 | -122.434742983299 | (37.7191725036747, -122.434742983299) | 9 | 7 | 6 | 28861 | 5 | |
179839 | 160370 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 868 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001693.73373 | 2088950.71414 | 37.715956825716 | -122.436078353349 | (37.715956825716, -122.436078353349) | 9 | 7 | 6 | 28861 | 5 | |
183741 | 255653 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 298X Coso Ave | 1 | Side Yard : Yard | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 10x10 | Permit Number 776462 | 6007785 | 2099424 | 37.7450583812321 | -122.415765181935 | (37.7450583812321, -122.415765181935) | 2 | 7 | 7 | 28859 | 2 |
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) );