trees
184 rows where SiteOrder = 2 and qLegalStatus_id = 2 sorted by PermitNotes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4912 | 261377 | Planning Code 138.1 required 2 | Olea Majestic Beauty :: 183 | 3015 25th Ave | 2 | 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 | |
19183 | 261351 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 2 | 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 | |
105455 | 256779 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1231 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 782672 | 6001926.50082 | 2110819.32275 | 37.7760160870933 | -122.436838397294 | (37.7760160870933, -122.436838397294) | 15 | 5 | 11 | 29492 | 10 | ||
82212 | 156914 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 2995 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009047.12311 | 2101072.92433 | 37.7496568330138 | -122.411517443787 | (37.7496568330138, -122.411517443787) | 2 | 4 | 7 | 28859 | 19 | |
179256 | 152616 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009096.56353 | 2101019.92176 | 37.7495140728181 | -122.411342732484 | (37.7495140728181, -122.411342732484) | 2 | 4 | 7 | 28859 | 19 | |
761 | 224987 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 484 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782366 | 6003591.74199 | 2105457.02251 | 37.7613870178149 | -122.430695151865 | (37.7613870178149, -122.430695151865) | 15 | 4 | 5 | 28862 | 3 | |
96451 | 225775 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 577 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | Permit Number 782239 | 6002401.77617 | 2104846.28665 | 37.75964259654 | -122.43476706624 | (37.75964259654, -122.43476706624) | 2 | 4 | 5 | 28862 | 3 | ||
22749 | 184649 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1688 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | Permit Number 782197 | 5983169.0582 | 2103665.8835 | 37.7552908641291 | -122.501195062681 | (37.7552908641291, -122.501195062681) | 1 | 8 | 3 | 56 | 35 | ||
6656 | 258684 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 222 Eucalyptus Dr | 2 | 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 | |
16662 | 260846 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 6 Cragmont Ave | 2 | 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 | |
95904 | 256882 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3075 25th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2018 12:00:00 AM | 3 | 3x10 | Permit Number 781920 | 5988824.60597 | 2094879.63635 | 37.7314966214822 | -122.480993433312 | (37.7314966214822, -122.480993433312) | 1 | 8 | 4 | 64 | 35 | |
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 | |
18512 | 260829 | Planning Code 138.1 required 2 | Callistemon viminalis :: Weeping Bottlebrush 60 | 165 Cerritos Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/10/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781510 | 5991854 | 2092943 | 37.7263547341381 | -122.470379348754 | (37.7263547341381, -122.470379348754) | 9 | 8 | 4 | 59 | 40 | |
8699 | 262221 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Chattanooga St | 2 | 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 | |
16371 | 260999 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 77 Belgrave Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 | |
8723 | 254152 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 201 Steuart St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 4x4 | Permit Number 781165 | |||||||||||
9263 | 254120 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 150 Jennings St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | ||||||||||||
74634 | 254115 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Newhall St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | 6018720.08887 | 2097065.44422 | 37.739190920851 | -122.377789500691 | (37.739190920851, -122.377789500691) | 10 | 3 | 8 | 58 | 1 | ||
190939 | 13063 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 590 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2017 12:00:00 AM | 3 | 2X2 | Permit Number 780933 | 6009554.3361 | 2120533.7978 | 37.803120257284 | -122.411137959105 | (37.803120257284, -122.411137959105) | 3 | 1 | 10 | 308 | 23 | |
639 | 261347 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 2 | 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 | |
41357 | 255423 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2398X 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780836 | 5982745 | 2098835 | 37.7420016902952 | -122.502304062071 | (37.7420016902952, -122.502304062071) | 1 | 8 | 3 | 29491 | 35 | |
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 | |
34077 | 256492 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 280 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780675 | 6001741.51076 | 2104267.16046 | 37.7580149486389 | -122.437009129166 | (37.7580149486389, -122.437009129166) | 2 | 4 | 5 | 28862 | 3 | |
5042 | 231235 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009517.2839 | 2105385.27542 | 37.7615239413898 | -122.410196026727 | (37.7615239413898, -122.410196026727) | 2 | 4 | 7 | 28859 | 19 | |
7502 | 236582 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009292.77734 | 2105398.52034 | 37.7615477221736 | -122.410973441191 | (37.7615477221736, -122.410973441191) | 2 | 4 | 7 | 28859 | 19 | |
102847 | 256610 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80 Terra Vista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780481 | 6000092 | 2112863 | 37.7815230689536 | -122.443331223004 | (37.7815230689536, -122.443331223004) | 15 | 5 | 1 | 29490 | 16 | |
16166 | 166316 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008870.16891 | 2103155.64589 | 37.7553655917605 | -122.412276546247 | (37.7553655917605, -122.412276546247) | 2 | 4 | 7 | 28859 | 19 | |
27287 | 255049 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 925 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779631 | 6009075.60356 | 2091383.60862 | 37.7230536656288 | -122.410734764023 | (37.7230536656288, -122.410734764023) | 9 | 3 | 7 | 309 | 28 | |
186623 | 257921 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1490x Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779557 | 6005922 | 2118675 | 37.79781210117 | -122.423575535726 | (37.79781210117, -122.423575535726) | 13 | 9 | 10 | 28858 | 32 | |
8065 | 255771 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 2 | 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 | ||
51709 | 173899 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 1762 12th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | 1 | 8 | 4 | 56 | 12 | |||
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 | |
177206 | 36045 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.7638748076146 | -122.413665776536 | (37.7638748076146, -122.413665776536) | 8 | 4 | 7 | 28859 | 19 | |
161200 | 257940 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 65 Buena Vista Ave East | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779175 | 6001128.17111 | 2108817.40029 | 37.7704739053605 | -122.439456486198 | (37.7704739053605, -122.439456486198) | 15 | 5 | 11 | 29492 | 9 | |
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 | |
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 | |
27168 | 75842 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 2 | 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 | |
60760 | 122593 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 72 Townsend St | 2 | 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 | |
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 | |
169212 | 253102 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000x Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
17897 | 254369 | Planning Code 138.1 required 2 | Citrus spp :: Lemon: Orange: Lime 120 | 590X Orizaba Ave | 2 | Back Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | ||||||||||||
158442 | 254367 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
30240 | 243370 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006249.22799 | 2103449.78821 | 37.7560258191488 | -122.421361454386 | (37.7560258191488, -122.421361454386) | 2 | 4 | 5 | 28859 | 19 | |
135960 | 103695 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1X Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006027.79546 | 2103458.18152 | 37.7560363783091 | -122.422127839194 | (37.7560363783091, -122.422127839194) | 2 | 4 | 5 | 28859 | 19 | |
1675 | 225195 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007206.11976 | 2103835.77909 | 37.7571395647689 | -122.418079559351 | (37.7571395647689, -122.418079559351) | 2 | 4 | 7 | 28859 | 19 | ||
17210 | 225188 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
86852 | 154903 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
184490 | 253342 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 200 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | Permit Number 778434 | 5995550.18022 | 2114806.2223 | 37.7865985940285 | -122.459184390305 | (37.7865985940285, -122.459184390305) | 11 | 6 | 1 | 54 | 31 | |||
126777 | 254698 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 2051 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015756.78552 | 2106043.12781 | 37.763678027819 | -122.388661890454 | (37.763678027819, -122.388661890454) | 14 | 3 | 8 | 28856 | 29 | ||
145856 | 254700 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 2 | 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 | ||
118329 | 172747 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6006022.78943 | 2120387.12776 | 37.8025188570147 | -122.423348551388 | (37.8025188570147, -122.423348551388) | 5 | 9 | 1 | 28858 | 32 |
168133 | 121551 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1125 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778243 | 6009293.51408 | 2111653.12836 | 37.7787214646499 | -122.411412777974 | (37.7787214646499, -122.411412777974) | 8 | 2 | 9 | 28853 | 34 | |
49019 | 113699 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 239 Minerva St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778180 | 5994635.15348587 | 2088996.04011087 | 37.7156777383317 | -122.460479228374 | (37.7156777383317, -122.460479228374) | 9 | 8 | 6 | 28861 | 24 | |
88090 | 85806 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 2 | 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 | |
126119 | 85804 | Planning Code 138.1 required 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 923 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011441.4589 | 2111949.4191 | 37.7796552503769 | -122.404003016031 | (37.7796552503769, -122.404003016031) | 14 | 2 | 9 | 28856 | 34 | |
105170 | 252909 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 3201x 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x6 | Permit Number 777588 | 6007417 | 2106083 | 37.7633217807187 | -122.417509514421 | (37.7633217807187, -122.417509514421) | 8 | 4 | 7 | 28859 | 19 | |
176658 | 252906 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 600 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | 8 | 4 | 7 | 28859 | 19 | |
97662 | 117018 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008125.66458 | 2112987.05621 | 37.7823185388132 | -122.415547303188 | (37.7823185388132, -122.415547303188) | 7 | 10 | 9 | 28852 | 36 | |
164491 | 251061 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 5418 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 777516 | 5990182.6788 | 2112719.9143 | 37.7805601365444 | -122.477601885097 | (37.7805601365444, -122.477601885097) | 11 | 6 | 2 | 55 | 26 | ||
193648 | 147591 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 777516 | 5990250.17652 | 2113053.797 | 37.7814808023322 | -122.477392789959 | (37.7814808023322, -122.477392789959) | 11 | 6 | 2 | 55 | 26 | |
36893 | 152811 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 2901 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6009988.15821 | 2101607.87857 | 37.7511784382559 | -122.40830102207 | (37.7511784382559, -122.40830102207) | 2 | 4 | 7 | 28859 | 19 | |
13037 | 152668 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 811 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777381 | 6008574.99769 | 2103713.14234 | 37.7568797829862 | -122.413336764205 | (37.7568797829862, -122.413336764205) | 2 | 4 | 7 | 28859 | 19 | |
46086 | 115494 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1199X OCEAN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
71090 | 115491 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 BRIGHTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
81974 | 256777 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2828 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777329 | 6003004.23187 | 2118313.15271 | 37.7966534371422 | -122.433645942426 | (37.7966534371422, -122.433645942426) | 13 | 9 | 1 | 57 | 17 | |
72671 | 255301 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1238 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777218 | 6006649 | 2115006 | 37.7877789501949 | -122.420799295532 | (37.7877789501949, -122.420799295532) | 13 | 9 | 10 | 28858 | 21 | |
186896 | 114793 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 10 Linares Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x10 | Permit Number 777094 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | 1 | 8 | 4 | 29491 | 40 | |||
193198 | 111714 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051 | 2113265 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | 11 | 6 | 2 | 55 | 26 | |
120310 | 173614 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2955 20th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.44954 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | 1 | 8 | 4 | 64 | 35 | |
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 | |
52945 | 117454 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 236 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776408 | 6011519 | 2111785 | 37.7792081256956 | -122.403723194086 | (37.7792081256956, -122.403723194086) | 14 | 2 | 9 | 28856 | 34 | |
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 | |
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 | |
6679 | 152982 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006311.85744 | 2102620.48455 | 37.7537522736602 | -122.421085978553 | (37.7537522736602, -122.421085978553) | 2 | 4 | 5 | 28859 | 19 | |
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 | |
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 | |
100024 | 258333 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 215X Raccoon Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/29/2019 12:00:00 AM | 3 | 3X3 | Permit Number 776074 | |||||||||||
70866 | 224462 | Planning Code 138.1 required 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2810 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010311.37562 | 2101086.64633 | 37.7497653433983 | -122.407146558773 | (37.7497653433983, -122.407146558773) | 2 | 4 | 7 | 28859 | 19 | |
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 | |
176004 | 203201 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 189 Hubbell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013028.4198 | 2107143.70013 | 37.7665483691258 | -122.398175741313 | (37.7665483691258, -122.398175741313) | 14 | 3 | 8 | 28856 | 20 | |
185470 | 198582 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013779.59756 | 2107146.17602 | 37.7665969792947 | -122.395577705173 | (37.7665969792947, -122.395577705173) | 14 | 3 | 8 | 28856 | 20 | |
120325 | 112085 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.7905278405438 | -122.396700174955 | (37.7905278405438, -122.396700174955) | 12 | 2 | 9 | 28855 | 6 | |||
57241 | 253248 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
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 | |||
71488 | 190612 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 9 Washburn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 775218 | 6008236.46776 | 2110619.04505 | 37.7758227734432 | -122.414996312823 | (37.7758227734432, -122.414996312823) | 8 | 2 | 9 | 28853 | 34 | |
18342 | 253705 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | |||||||||||
170272 | 31068 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007659.7746 | 2107385.50696 | 37.7669118184545 | -122.4167621155 | (37.7669118184545, -122.4167621155) | 8 | 4 | 7 | 28853 | 19 | |
8046 | 261018 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Cragmont Ave | 2 | 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 | |
1560 | 258220 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 2 | 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 | |
64492 | 117113 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1650 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005663.57094 | 2117913.49378 | 37.7957066076266 | -122.424415580821 | (37.7957066076266, -122.424415580821) | 13 | 9 | 1 | 28858 | 27 | |
193110 | 109470 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | Permit Number 773752 | 6013467.61268 | 2109523.16527 | 37.7731063019529 | -122.396823476633 | (37.7731063019529, -122.396823476633) | 14 | 2 | 9 | 310 | 20 | ||
26508 | 113650 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
154892 | 113645 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
173710 | 243660 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 4471 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2018 12:00:00 AM | 3 | 4x4 | Permit Number 773370 | 6000282.83907 | 2102244.20874 | 37.7523773981989 | -122.441908628496 | (37.7523773981989, -122.441908628496) | 2 | 4 | 5 | 28862 | 22 | |
48155 | 107646 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.76538 | 2115716.99395 | 37.7896817924241 | -122.423878022401 | (37.7896817924241, -122.423878022401) | 13 | 9 | 1 | 28858 | 41 | ||
117515 | 119808 | Planning Code 138.1 required 2 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1634 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773331 | 6006048 | 2115627 | 37.7894501691998 | -122.422922798032 | (37.7894501691998, -122.422922798032) | 13 | 9 | 1 | 28858 | 41 | |
64240 | 112973 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4099x ULLOA ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385 | 2098079 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | 1 | 8 | 3 | 29491 | 35 | ||
96508 | 115347 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 398X HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 773314 | 6014854 | 2114630 | 37.7872055860551 | -122.392385006805 | (37.7872055860551, -122.392385006805) | 6 | 2 | 9 | 28855 | 6 | |
152753 | 115349 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014896.08459 | 2114567.05321 | 37.7870350854597 | -122.392234997951 | (37.7870350854597, -122.392234997951) | 6 | 2 | 9 | 28855 | 6 | |
6889 | 173762 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1405 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773007 | 6015436.02818 | 2092717.71929 | 37.727071439337 | -122.388840955894 | (37.727071439337, -122.388840955894) | 10 | 3 | 8 | 58 | 1 |
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) );