trees
434 rows where SiteOrder = 1 and qLegalStatus_id = 2 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||
5071 | 254119 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 150 Jennings St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | ||||||||||||
7193 | 254151 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 201 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 4x4 | Permit Number 781165 | |||||||||||
8598 | 121137 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1388x Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
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 | ||||||||||||
14212 | 253124 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 399x Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780530 | |||||||||||
14753 | 259380 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 198X Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
172077 | 258332 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 215X Raccoon Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/29/2019 12:00:00 AM | 3 | 3X3 | Permit Number 776074 | |||||||||||
1992 | 260845 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 6 Cragmont Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/15/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782122 | 5992584.1181 | 2101828.636 | 37.7507946382458 | -122.468501593976 | (37.7507946382458, -122.468501593976) | 1 | 8 | 4 | 29491 | 12 | |
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 | ||||
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 | |
4524 | 183636 | Planning Code 138.1 required 2 | Pittosporum crassifolium :: Karo Tree 95 | 1478 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 3x9 | Permit Number 781673 | 5981570.9282 | 2105017.3718 | 37.7589076903569 | -122.506822015648 | (37.7589076903569, -122.506822015648) | 1 | 8 | 3 | 56 | 35 | |
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 | |
4820 | 253072 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1350 46th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | 6x10 | Permit Number 780489 | 5981849.66657 | 2105897.22193 | 37.7613399178539 | -122.50592325662 | (37.7613399178539, -122.50592325662) | 1 | 8 | 3 | 56 | 35 | |
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 | |
8278 | 258683 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 222 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/06/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782190 | 5990522.43491 | 2094710.12159 | 37.7311297256611 | -122.475111403646 | (37.7311297256611, -122.475111403646) | 1 | 8 | 4 | 64 | 35 | |
9544 | 261378 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1762 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784740 | 5990006.33488 | 2103376.99766 | 37.7548967913393 | -122.477528860126 | (37.7548967913393, -122.477528860126) | 1 | 8 | 3 | 56 | 35 | |
11989 | 261017 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774761 | 5992858 | 2101375 | 37.749564886931 | -122.467521508976 | (37.749564886931, -122.467521508976) | 1 | 8 | 4 | 29491 | 12 | |
14905 | 260579 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1662 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782799 | 5985048 | 2103886 | 37.7560054004173 | -122.494713443881 | (37.7560054004173, -122.494713443881) | 1 | 8 | 3 | 56 | 35 | |
14929 | 256105 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1935 34th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Port | 09/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778629 | 5985666.45669 | 2102048.38182 | 37.7509959848908 | -122.492439326416 | (37.7509959848908, -122.492439326416) | 1 | 8 | 3 | 29491 | 35 |
15585 | 258769 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 1633 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2019 12:00:00 AM | 3 | 3x3 | 5988962.35654 | 2103065.4403 | 37.7539807026125 | -122.481116375927 | (37.7539807026125, -122.481116375927) | 1 | 8 | 3 | 56 | 35 | ||
16409 | 54948 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1531 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/1972 12:00:00 AM | 15 | 6x3 | Permit Number 779312 | 5982470.8167 | 2104681.2673 | 37.7580377938942 | -122.503684942327 | (37.7580377938942, -122.503684942327) | 1 | 8 | 3 | 56 | 35 | |
17863 | 261376 | Planning Code 138.1 required 2 | Olea Majestic Beauty :: 183 | 3015 25th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 4x10 | Permit Number 784883 | 5988814.87181 | 2095155.07295 | 37.7322523337557 | -122.481047245899 | (37.7322523337557, -122.481047245899) | 1 | 8 | 4 | 64 | 35 | |
18060 | 258219 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
20702 | 37086 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1426 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2017 12:00:00 AM | 3 | Permit Number 780691 | 5981873.63686209 | 2105374.96731705 | 37.7599073668224 | -122.505801636192 | (37.7599073668224, -122.505801636192) | 1 | 8 | 3 | 56 | 35 | |
24135 | 254150 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2123 30th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 3x6 | Permit Number 778310 | 5986951.71761 | 2100810.65655 | 37.7476725845461 | -122.487903895201 | (37.7476725845461, -122.487903895201) | 1 | 8 | 3 | 29491 | 35 | |
25630 | 255709 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2458 40th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 775348 | 5983968.47211 | 2098431.39968 | 37.740965323086 | -122.498043953777 | (37.740965323086, -122.498043953777) | 1 | 8 | 3 | 29491 | 35 | |
32475 | 255482 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1559 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2018 12:00:00 AM | 3 | 3x5 | 5993958 | 2104895 | 37.7592933500003 | -122.463973185629 | (37.7592933500003, -122.463973185629) | 1 | 8 | 4 | 56 | 12 | ||
35612 | 255646 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1542 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2018 12:00:00 AM | 3 | 3x5 | Permit Number 779777 | 5989956.05847 | 2104865.26605 | 37.7589802621415 | -122.477811515827 | (37.7589802621415, -122.477811515827) | 1 | 8 | 3 | 56 | 35 | |
35632 | 182616 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1856 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/16/2018 12:00:00 AM | 0 | Width 0ft | Permit Number 780914 | 5987553.0951 | 2102630.1854 | 37.7527035840583 | -122.485957928463 | (37.7527035840583, -122.485957928463) | 1 | 8 | 3 | 56 | 35 | |
36667 | 112972 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4099x ULLOA ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773327 | 5983385 | 2098079 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | 1 | 8 | 3 | 29491 | 35 | |
37533 | 253101 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000x Irving St | 1 | 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 | |
37901 | 251534 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1818 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2017 12:00:00 AM | 3 | 3x3 | 5983226 | 2102732 | 37.7527300247516 | -122.500929082058 | (37.7527300247516, -122.500929082058) | 1 | 8 | 3 | 56 | 35 | ||
38353 | 256715 | Planning Code 138.1 required 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 | 1540 17th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/15/2019 12:00:00 AM | 3 | 4x8 | Permit Number 779534 | 5990911 | 2104908 | 37.7591529734205 | -122.474512031039 | (37.7591529734205, -122.474512031039) | 1 | 8 | 4 | 56 | 12 | |
39420 | 253554 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1855 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778968 | 5986885.63083 | 2102641.2721 | 37.7526951056681 | -122.488266922919 | (37.7526951056681, -122.488266922919) | 1 | 8 | 3 | 56 | 35 | |
42827 | 253341 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1935 46th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 769984 | 5981944.68101 | 2101921.14451 | 37.7504283278742 | -122.505299944249 | (37.7504283278742, -122.505299944249) | 1 | 8 | 3 | 29491 | 35 | |
49225 | 53968 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1354 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773113 | 5988678.33594659 | 2106104.92629407 | 37.7623097958053 | -122.482321255458 | (37.7623097958053, -122.482321255458) | 1 | 8 | 3 | 56 | 35 | ||
53166 | 112854 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2622 JUDAH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 774112 | 5986417 | 2105735 | 37.7611622818619 | -122.49011505097 | (37.7611622818619, -122.49011505097) | 1 | 8 | 3 | 56 | 35 | ||
64249 | 252820 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 2339 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2017 12:00:00 AM | 3 | 3x3 | 5983590.30233 | 2099230.68636 | 37.743137766616 | -122.499410557243 | (37.743137766616, -122.499410557243) | 1 | 8 | 3 | 29491 | 35 | ||
64628 | 113721 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1526 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2015 12:00:00 AM | 3x3 | 5989360 | 2104938.6 | 37.7591470062831 | -122.479878309336 | (37.7591470062831, -122.479878309336) | 1 | 8 | 3 | 56 | 35 | |||
67232 | 256000 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 8 Springfield Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/21/2018 12:00:00 AM | 3 | 6x10 | Permit Number 780036 | 5986792.13129 | 2095812.03329 | 37.733938381975 | -122.488088482457 | (37.733938381975, -122.488088482457) | 1 | 8 | 4 | 64 | 35 | |
68264 | 173898 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 1762 12th Ave | 1 | 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 | |||
77927 | 187639 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1671 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2017 12:00:00 AM | 3 | 3x6 | 5985585 | 2103854 | 37.7559489545124 | -122.492853989295 | (37.7559489545124, -122.492853989295) | 1 | 8 | 3 | 56 | 35 | ||
81070 | 256613 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2214 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781468 | 5985177 | 2100108 | 37.745639596763 | -122.493988903155 | (37.745639596763, -122.493988903155) | 1 | 8 | 3 | 29491 | 35 | |
81759 | 256725 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 432 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781907 | 5993569.91313 | 2105305.27634 | 37.7603974888061 | -122.465345170025 | (37.7603974888061, -122.465345170025) | 1 | 8 | 11 | 56 | 12 | |
82445 | 254665 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1771 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778441 | 5989948 | 2103325 | 37.7547506343258 | -122.477726795598 | (37.7547506343258, -122.477726795598) | 1 | 8 | 3 | 56 | 35 | |
84340 | 115405 | Planning Code 138.1 required 2 | Podocarpus macrophyllus :: Yew Pine 137 | 2050 43RD AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/29/2016 12:00:00 AM | 3 | 3x3 | 5982969 | 2101168 | 37.7484206232379 | -122.50170211889 | (37.7484206232379, -122.50170211889) | 1 | 8 | 3 | 29491 | 35 | ||
93370 | 255421 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2727 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780223 | 5985829 | 2096861 | 37.7367623321138 | -122.491495459369 | (37.7367623321138, -122.491495459369) | 1 | 8 | 3 | 29491 | 35 | |
95009 | 173748 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1259 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773489 | 5989520 | 2106786 | 37.7642287625639 | -122.479460118399 | (37.7642287625639, -122.479460118399) | 1 | 8 | 3 | 56 | 35 | |
102182 | 253344 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2586 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780063 | 5987098.36417 | 2097677.28593 | 37.7390777358027 | -122.487166705945 | (37.7390777358027, -122.487166705945) | 1 | 8 | 3 | 29491 | 35 | |
104008 | 79418 | Planning Code 138.1 required 2 | Brahea edulis :: Guadalupe Palm 218 | 1746 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2001 12:00:00 AM | 3x3 | 5981053.87958296 | 2103176.2415425 | 37.7538220108937 | -122.508473505042 | (37.7538220108937, -122.508473505042) | 1 | 8 | 3 | 56 | 35 | |||
105599 | 256614 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1483 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776026 | 5987111.69916 | 2105187.42749 | 37.7596993421459 | -122.487672186767 | (37.7596993421459, -122.487672186767) | 1 | 8 | 3 | 56 | 35 | |
105730 | 120914 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1356 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2016 12:00:00 AM | 3 | 3x3 | 5989939 | 2106143 | 37.7624875866057 | -122.477963922005 | (37.7624875866057, -122.477963922005) | 1 | 8 | 3 | 56 | 35 | ||
106240 | 122625 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 189 Country Club Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/15/2016 12:00:00 AM | 3 | 4x5 | Permit Number 774974 | 5984222 | 2094938 | 37.7313882480876 | -122.496909587532 | (37.7313882480876, -122.496909587532) | 1 | 8 | 4 | 64 | 35 | |
114870 | 253576 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2622 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 774112 | 5986417 | 2105735 | 37.7611622818619 | -122.49011505097 | (37.7611622818619, -122.49011505097) | 1 | 8 | 3 | 56 | 35 | ||
120709 | 253166 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 2405 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778209 | 5986396.6612 | 2098868.17463 | 37.742306656921 | -122.489680395865 | (37.742306656921, -122.489680395865) | 1 | 8 | 3 | 29491 | 35 | |
125559 | 120527 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1672 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2016 12:00:00 AM | 3 | 3x3 | 5981030 | 2103685 | 37.7552175094175 | -122.508593851446 | (37.7552175094175, -122.508593851446) | 1 | 8 | 3 | 56 | 35 | ||
131553 | 256083 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2187 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781873 | 5989736 | 2100494 | 37.7469651502436 | -122.478252958666 | (37.7469651502436, -122.478252958666) | 1 | 8 | 3 | 29491 | 35 | |
138593 | 56707 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1688 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Permit Number 782197 | 5983170.4061 | 2103643.307 | 37.7552289545408 | -122.501188731534 | (37.7552289545408, -122.501188731534) | 1 | 8 | 3 | 56 | 35 | |||
140218 | 256881 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3075 25th Ave | 1 | 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 | |
144548 | 254740 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1814 42nd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779958 | 5983225 | 2102757 | 37.752798609062 | -122.500934388909 | (37.752798609062, -122.500934388909) | 1 | 8 | 3 | 56 | 35 | |
145605 | 183545 | Planning Code 138.1 required 2 | Agonis flexuosa :: Peppermint Willow 65 | 2580 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | 4x4 | Permit Number 777874 | 5988340.9772 | 2097760.0505 | 37.7393773655768 | -122.482876432223 | (37.7393773655768, -122.482876432223) | 1 | 8 | 3 | 29491 | 35 | |
146537 | 173613 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2955 20th Ave | 1 | 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 | |
151100 | 81972 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1822 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2015 12:00:00 AM | 3 | 3x6 | Permit Number 774361 | 5989407.90008391 | 2102936.76390687 | 37.7536532824256 | -122.479566183797 | (37.7536532824256, -122.479566183797) | 1 | 8 | 3 | 56 | 35 | |
156097 | 253105 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1295 31st Ave | 1 | 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 | |
160246 | 254370 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 1 | 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 | |
160718 | 117479 | Planning Code 138.1 required 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 601 PACHECO ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x9 | 5993107 | 2101833 | 37.7508368102529 | -122.466693753982 | (37.7508368102529, -122.466693753982) | 1 | 8 | 4 | 29491 | 12 | ||||
164050 | 114792 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Linares Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x10 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | 1 | 8 | 4 | 29491 | 40 | ||||
167627 | 256505 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 4023 Pacheco St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 780999 | 5982525.89889 | 2101484.48033 | 37.7492635534225 | -122.50325775688 | (37.7492635534225, -122.50325775688) | 1 | 8 | 3 | 29491 | 35 | |
170704 | 255422 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2398X 44th Ave | 1 | 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 | |
171095 | 122627 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 34 Country Club Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/15/2016 12:00:00 AM | 3 | 3x4 | Permit Number 775279 | 5984731 | 2094410 | 37.7299683129055 | -122.495110985344 | (37.7299683129055, -122.495110985344) | 1 | 8 | 4 | 64 | 35 | |
172845 | 255375 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2699X Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2018 12:00:00 AM | 3 | 3x3 | 5984648 | 2097442 | 37.7382885158105 | -122.495621472041 | (37.7382885158105, -122.495621472041) | 1 | 8 | 3 | 29491 | 35 | ||
178269 | 122626 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 330 Country Club Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/15/2016 12:00:00 AM | 3 | 3x5 | Permit Number 774975 | 5984613 | 2095517 | 37.7330009316807 | -122.495600537949 | (37.7330009316807, -122.495600537949) | 1 | 8 | 4 | 64 | 35 | |
180231 | 254400 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2346 46th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/12/2018 12:00:00 AM | 3 | 3X3 | 5982081.05878 | 2099125.72352 | 37.7427609043033 | -122.504621254744 | (37.7427609043033, -122.504621254744) | 1 | 8 | 3 | 29491 | 35 | ||
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 | |||
184867 | 112863 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2451 19TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2015 12:00:00 AM | 3 | 3x3 | 5990427 | 2098705 | 37.7420931085193 | -122.475732948104 | (37.7420931085193, -122.475732948104) | 1 | 8 | 3 | 29491 | 35 | ||
194213 | 253623 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1331 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778744 | 5983976.42262 | 2106100.27997 | 37.7620224120695 | -122.498582815109 | (37.7620224120695, -122.498582815109) | 1 | 8 | 3 | 56 | 35 | |
194418 | 265072 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2027 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5983517.97374 | 2101348.17171 | 37.7489475550359 | -122.499817124771 | (37.7489475550359, -122.499817124771) | 1 | 8 | 3 | 29491 | 35 | ||||
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 | |
8434 | 255770 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 450 Toland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2018 12:00:00 AM | 3 | Permit Number 779472 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
26571 | 150167 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 333 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779492 | 6014367.55242 | 2105483.96934 | 37.7620656102492 | -122.393427719319 | (37.7620656102492, -122.393427719319) | 10 | 3 | 8 | 28856 | 29 | |
31747 | 173761 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1405 Van Dyke Ave | 1 | 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 | |
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 | |
81706 | 122697 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.99272 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | 10 | 3 | 7 | 309 | 28 | ||
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 | |
115977 | 258090 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1223 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2019 12:00:00 AM | 3 | 4x6 | 6013685 | 2090528 | 37.7209617016481 | -122.394740998302 | (37.7209617016481, -122.394740998302) | 10 | 3 | 8 | 58 | 1 | ||
118980 | 254114 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Newhall St | 1 | 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 | ||
141327 | 253287 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1237 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780510 | 6016839.12241 | 2092718.79414 | 37.7271520593202 | -122.383990506478 | (37.7271520593202, -122.383990506478) | 10 | 3 | 8 | 58 | 1 | |
145785 | 253796 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Scotia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2017 12:00:00 AM | 3 | Permit Number 779938 | 6011980.63004 | 2095004.60122 | 37.7331586170673 | -122.400946899168 | (37.7331586170673, -122.400946899168) | 10 | 3 | 8 | 58 | 1 | ||
147146 | 256033 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1459 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015639 | 2093574 | 37.7294338636754 | -122.388199012441 | (37.7294338636754, -122.388199012441) | 10 | 3 | 8 | 58 | 1 | ||||
161840 | 148099 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 509 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2018 12:00:00 AM | 3 | 4x4 | Permit Number 782106 | 6009909.13224 | 2092063.05855 | 37.7249659929773 | -122.40790129952 | (37.7249659929773, -122.40790129952) | 10 | 3 | 7 | 309 | 28 | |
163344 | 115976 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011653.53869 | 2091254.58415 | 37.7228435956385 | -122.401814242757 | (37.7228435956385, -122.401814242757) | 10 | 3 | 7 | 309 | 28 | |||
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 | |||
174008 | 251470 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 194 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777454 | 6009558.57553 | 2094850.08468 | 37.7325989441491 | -122.409309728531 | (37.7325989441491, -122.409309728531) | 10 | 3 | 7 | 309 | 28 | |
191014 | 122700 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 2895 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.76794 | 37.7253343641976 | -122.402569107292 | (37.7253343641976, -122.402569107292) | 10 | 3 | 7 | 309 | 28 | ||
12151 | 145130 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 218 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2020 12:00:00 AM | 3 | 4x4 | Permit Number 785634 | 5992772.08387 | 2113986.425 | 37.7841875521538 | -122.468736166845 | (37.7841875521538, -122.468736166845) | 11 | 6 | 2 | 54 | 11 | |
12753 | 253419 | Planning Code 138.1 required 2 | :: 45 | 3499 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997570 | 2115996 | 37.7899813188913 | -122.452282225129 | (37.7899813188913, -122.452282225129) | 11 | 6 | 1 | 54 | 31 | ||||
16618 | 251060 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5418 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 777516 | 5990225.155 | 2112720.9896 | 37.7805655538274 | -122.477455019941 | (37.7805655538274, -122.477455019941) | 11 | 6 | 2 | 55 | 26 | ||
17123 | 254549 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 170 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2020 12:00:00 AM | 3 | 3x3 | 5992784 | 2114350 | 37.7851865177567 | -122.46872140612 | (37.7851865177567, -122.46872140612) | 11 | 6 | 2 | 54 | 11 |
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) );