trees
1,011 rows where qLegalStatus_id = 2 sorted by qSiteInfo
This data as json, CSV (advanced)
Fire Prevention Districts ✖
qSiteInfo ✖
- Sidewalk: Curb side : Cutout 844
- Sidewalk: Property side : Cutout 56
- Sidewalk: Property side : Yard 47
- Front Yard : Yard 16
- Sidewalk: Curb side : Yard 11
- : 8
- Back Yard : Yard 6
- Unaccepted Street : Yard 6
- Sidewalk: Curb side : Pot 5
- Front Yard : Cutout 4
- Side Yard : Cutout 3
- Side Yard : Yard 3
- Back Yard : Cutout 1
- Unaccepted Street : Cutout 1
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98537 | 196590 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 43 Lafayette St | 2 | : | Tree | Private 2 | 10 | Width 3ft | Permit Number 772992 | 6007565.69447 | 2109618.27361 | 37.7730371773558 | -122.417245760983 | (37.7730371773558, -122.417245760983) | 8 | 2 | 9 | 28853 | 19 | ||
112760 | 196591 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 43 Lafayette St | 3 | : | Tree | Private 2 | 13 | Width 3ft | Permit Number 772992 | 6007555.65106 | 2109624.06249 | 37.7730525072055 | -122.417280912782 | (37.7730525072055, -122.417280912782) | 8 | 2 | 9 | 28853 | 19 | ||
122248 | 249557 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 3 | : | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005881.27559 | 2115126.52616 | 37.7880665835567 | -122.423464052238 | (37.7880665835567, -122.423464052238) | 13 | 9 | 1 | 28858 | 41 | |
143851 | 249555 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 1 | : | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005893.0868 | 2115064.96247 | 37.7878982115887 | -122.423418809148 | (37.7878982115887, -122.423418809148) | 13 | 9 | 1 | 28858 | 41 | |
151779 | 249556 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 2 | : | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005884.08324 | 2115105.79396 | 37.7880098165527 | -122.423452863778 | (37.7880098165527, -122.423452863778) | 13 | 9 | 1 | 28858 | 41 | |
157692 | 249558 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 4 | : | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005877.98213 | 2115146.79048 | 37.7881220384566 | -122.423476888259 | (37.7881220384566, -122.423476888259) | 13 | 9 | 1 | 28858 | 41 | |
173303 | 241645 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 472 Oak St | 1 | : | Tree | Private 2 | 09/17/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 774132 | 6004722.92891 | 2110216.20564 | 37.7745186107768 | -122.427121843201 | (37.7745186107768, -122.427121843201) | 7 | 9 | 11 | 28852 | 10 | |
181676 | 196592 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 43 Lafayette St | 4 | : | Tree | Private 2 | 8 | Width 3ft | Permit Number 772992 | 6007533.59843 | 2109642.31042 | 37.7731013709756 | -122.417358489209 | (37.7731013709756, -122.417358489209) | 8 | 2 | 9 | 28853 | 19 | ||
10143 | 256870 | Planning Code 138.1 required 2 | Cupressus macrocarpa :: Monterey Cypress 41 | 30X Bernal Heights Blvd | 1 | Back Yard : Cutout | Tree | Private 2 | 12x6 | ||||||||||||||
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 | ||||||||||||
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 | ||||||||||||
19663 | 256686 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 11 | Back Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
75229 | 256683 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
127405 | 256685 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 10 | Back Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
185964 | 256684 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 9 | Back Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
37766 | 150676 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 548 Rhode Island St | 1 | Front Yard : Cutout | Tree | Private 2 | 11/07/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780811 | 6011754.98399 | 2105812.52377 | 37.7628222449765 | -122.402486741392 | (37.7628222449765, -122.402486741392) | 8 | 3 | 8 | 28856 | 29 | |
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 | ||
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 | |||
179923 | 122379 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 466 Vernon St | 1 | Front Yard : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 5992521 | 2090937 | 37.7208852925782 | -122.467927737968 | (37.7208852925782, -122.467927737968) | 9 | 8 | 6 | 64 | 24 | ||
1810 | 253859 | Planning Code 138.1 required 2 | Prunus spp :: Cherry 68 | 130 Graystone Ter | 1 | Front Yard : Yard | Tree | Private 2 | 6x6 | Permit Number 780749 | 5998952.88335 | 2104176.47413 | 37.7576070480405 | -122.446646826709 | (37.7576070480405, -122.446646826709) | 2 | 5 | 5 | 28862 | 3 | |||
4535 | 106245 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 566 De Haro St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Permit Number 770844 | 6012026 | 2105714 | 37.7625668468002 | -122.401542461625 | (37.7625668468002, -122.401542461625) | 8 | 3 | 8 | 28856 | 29 | |||
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 | ||
8622 | 256682 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 330 Twin Peaks Blvd | 8 | Front Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
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 | |
23587 | 256680 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 330 Twin Peaks Blvd | 6 | Front Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
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 | |
137347 | 116851 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 83 Panorama Dr | 3 | Front Yard : Yard | Tree | Private 2 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | 1 | 5 | 4 | 59 | 38 | |||
139506 | 254366 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 1 | 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 | ||
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 | ||||
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 | ||
164459 | 116850 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 83 Panorama Dr | 2 | Front Yard : Yard | Tree | Private 2 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | 1 | 5 | 4 | 59 | 38 | |||
173695 | 121962 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 20 16th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 5x10 | Permit Number 778592 | 5990850.71184 | 2114913.60159 | 37.7866221356037 | -122.47545108088 | (37.7866221356037, -122.47545108088) | 11 | 6 | 1 | 54 | 33 | |
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 | ||
176698 | 256681 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 330 Twin Peaks Blvd | 7 | Front Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
183437 | 116849 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 83 Panorama Dr | 1 | Front Yard : Yard | Tree | Private 2 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | 1 | 5 | 4 | 59 | 38 | |||
78128 | 256675 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 330 Twin Peaks Blvd | 3 | Side Yard : Cutout | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
130529 | 256674 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 2 | Side Yard : Cutout | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
158426 | 256673 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 1 | Side Yard : Cutout | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
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 | |
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 | |
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 | |
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 | |
502 | 251299 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2190X Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4X4 | 6003624.7851 | 2107240.8343 | 37.7662868072343 | -122.430708166736 | (37.7662868072343, -122.430708166736) | 7 | 4 | 5 | 28862 | 3 | ||||
524 | 225191 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 5 | 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 | ||
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 | |
642 | 260182 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 2 | 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 | ||
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 | |
728 | 102430 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 200 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010566.09371 | 2111909.33227 | 37.7794962351107 | -122.407028471514 | (37.7794962351107, -122.407028471514) | 14 | 2 | 9 | 28853 | 34 | |
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 | |
982 | 104688 | Planning Code 138.1 required 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 2655 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | 15 | 6 | 1 | 29490 | 27 | |
1023 | 228184 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1190 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 776221 | 6006352.00962 | 2102676.26299 | 37.7539076917969 | -122.420951082919 | (37.7539076917969, -122.420951082919) | 2 | 4 | 5 | 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 | ||
1432 | 228461 | Planning Code 138.1 required 2 | :: 45 | 1813 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 782329 | 6005355.14245 | 2107219.1964 | 37.7663252752163 | -122.424721643507 | (37.7663252752163, -122.424721643507) | 8 | 4 | 5 | 28853 | 19 | ||
1462 | 225196 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007182.851 | 2103832.80652 | 37.7571300930895 | -122.418159821127 | (37.7571300930895, -122.418159821127) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |
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 | ||
1751 | 121138 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1388x Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
1902 | 261997 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 3 | 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 | |
1962 | 122597 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 5 | 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 | |
2139 | 251538 | Planning Code 138.1 required 2 | Brahea edulis :: Guadalupe Palm 218 | 1746 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981086 | 2103156 | 37.753768326371 | -122.508360924805 | (37.753768326371, -122.508360924805) | 1 | 8 | 3 | 56 | 35 | ||||
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 | |
2311 | 256568 | Planning Code 138.1 required 2 | Acer buergeranum :: Trident Maple 110 | 2099X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002352 | 2115365 | 37.7885215412843 | -122.435691777518 | (37.7885215412843, -122.435691777518) | 13 | 6 | 1 | 29490 | 27 | ||||
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 | |
2941 | 261590 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 299x 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006795 | 2107850 | 37.7681385292637 | -122.41978620049 | (37.7681385292637, -122.41978620049) | 8 | 4 | 7 | 28853 | 19 | ||||
3289 | 262310 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1356 20th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2016 12:00:00 AM | 5989914.31197 | 2106134.19071 | 37.7624619657204 | -122.478048663847 | (37.7624619657204, -122.478048663847) | 1 | 8 | 3 | 56 | 35 | |||||
3329 | 260429 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
3426 | 231237 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009518.21853 | 2105339.01767 | 37.7613969805183 | -122.410189528218 | (37.7613969805183, -122.410189528218) | 2 | 4 | 7 | 28859 | 19 | |
3713 | 225189 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 3 | 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 | ||
3779 | 231240 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009523.77815 | 2105243.21899 | 37.7611342507514 | -122.410163536041 | (37.7611342507514, -122.410163536041) | 2 | 4 | 7 | 28859 | 19 | |
3797 | 260871 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198x Eddy St | 4 | 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 | ||
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 | ||||
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 | |||||||||||
3990 | 60261 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776014 | 6008888.61229415 | 2103948.71328851 | 37.7575442102667 | -122.412268813453 | (37.7575442102667, -122.412268813453) | 2 | 4 | 7 | 28859 | 19 | |
4098 | 242321 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006210.72103 | 2102654.46682 | 37.7538398793324 | -122.421438144967 | (37.7538398793324, -122.421438144967) | 2 | 4 | 5 | 28859 | 19 | |
4228 | 254718 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x4 | 6013911 | 2107143 | 37.7665955668607 | -122.39512298129 | (37.7665955668607, -122.39512298129) | 14 | 3 | 8 | 28856 | 20 | ||
4259 | 33111 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 4x4 | Permit Number 769981 | 6000363.34088 | 2118561.77591 | 37.7971858916671 | -122.442801853125 | (37.7971858916671, -122.442801853125) | 13 | 9 | 1 | 57 | 17 | |
4508 | 260546 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 3 | 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 | |
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 | |
4552 | 250073 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1599X Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083 | 2115238 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | 13 | 9 | 1 | 28858 | 41 | |
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 | |
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 | |||
4803 | 260955 | Planning Code 138.1 required 2 | Nyssa sylvatica :: Tupelo: Sour Gum 92 | 1296 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x8 | 6008013 | 2100716 | 37.7486187391462 | -122.4150682294 | (37.7486187391462, -122.4150682294) | 2 | 4 | 7 | 28859 | 19 | ||||
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 | |
5118 | 169123 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 210 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2019 12:00:00 AM | 3 | Width 4ft | 6009469.52117 | 2113800.26568 | 37.7846268637924 | -122.410955591431 | (37.7846268637924, -122.410955591431) | 14 | 10 | 9 | 28852 | 36 | ||
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 | |
5543 | 121277 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
5835 | 118375 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x6 | 6014712.48727 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |
6006 | 253478 | Planning Code 138.1 required 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1222 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984 | 2109753 | 37.7735428603255 | -122.408890010762 | (37.7735428603255, -122.408890010762) | 8 | 2 | 9 | 28853 | 34 | |
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 | |
6093 | 45072 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 596 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | Permit Number 770844 | 6012065 | 2105633 | 37.7623466149115 | -122.401401881236 | (37.7623466149115, -122.401401881236) | 8 | 3 | 8 | 28856 | 29 | ||
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 | ||||
6489 | 225192 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 6 | 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 | ||
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 | |
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 |
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) );