trees
1,011 rows where qLegalStatus_id = 2 sorted by Longitude
This data as json, CSV (advanced)
SiteOrder ✖
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||
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 | |||||||||||
4642 | 254121 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 150 Jennings St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | ||||||||||||
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 | ||||||||||||
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 | |||||||||||
8822 | 260549 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1190 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776221 | |||||||||||
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 | ||||||||||||
9600 | 254154 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 201 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 4x4 | Permit Number 781165 | |||||||||||
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 | ||||||||||||
12861 | 253706 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | |||||||||||
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 | |||||||||||||||
15566 | 121139 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1388x Minna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
15617 | 254153 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 201 Steuart St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 4x4 | Permit Number 781165 | |||||||||||
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 | ||||||||||||
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 | |||||||||||
18507 | 254122 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 150 Jennings St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | ||||||||||||
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 | |||||||||||
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 | |||||||||||
4781 | 254118 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Newhall St | 5 | 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 | ||
48804 | 254117 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Newhall St | 4 | 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 | ||
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 | ||
75135 | 254116 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Newhall St | 3 | 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 | ||
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 | |
15059 | 254699 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 | ||
96441 | 254702 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 4 | 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 | ||
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 | ||
191366 | 254701 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 3 | 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 | ||
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 | ||||
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 | ||
161423 | 254697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 2051 03rd St | 1 | 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 | ||
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 | |
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 | |
104520 | 105275 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 64 Townsend St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015531.53579 | 2112438.89481 | 37.7812269075454 | -122.389887748547 | (37.7812269075454, -122.389887748547) | 6 | 2 | 9 | 28856 | 6 | |
29570 | 105276 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 64 Townsend St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015520.22928 | 2112423.42174 | 37.7811837949483 | -122.389925782657 | (37.7811837949483, -122.389925782657) | 6 | 2 | 9 | 28856 | 6 | |
95774 | 105277 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 64 Townsend St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015510.23316 | 2112419.28649 | 37.7811718861147 | -122.38996007562 | (37.7811718861147, -122.38996007562) | 6 | 2 | 9 | 28856 | 6 | |
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 | |
19209 | 122592 | Planning Code 138.1 required 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 72 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
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 | |
34241 | 122599 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 7 | 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 | |
72432 | 122594 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 72 Townsend St | 3 | 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 | |
100384 | 122598 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 6 | 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 | |
111086 | 122596 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 4 | 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 | |
118733 | 72480 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 3 | 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 | |
180599 | 75872 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
17276 | 72565 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 770847 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | ||
177060 | 116640 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 4x4 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | |||
122606 | 187947 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015161.72984 | 2115222.99296 | 37.7888508922136 | -122.391361788631 | (37.7888508922136, -122.391361788631) | 6 | 2 | 9 | 28855 | 6 | ||||
149325 | 187946 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015145.56326 | 2115239.56325 | 37.7888954931699 | -122.391418882079 | (37.7888954931699, -122.391418882079) | 6 | 2 | 9 | 28855 | 6 | ||||
73578 | 187945 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015129.76051 | 2115255.3706 | 37.7889380194338 | -122.391474663423 | (37.7889380194338, -122.391474663423) | 6 | 2 | 9 | 28855 | 6 | ||||
20157 | 121528 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
40138 | 121526 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
52894 | 121531 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
55960 | 121539 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
100470 | 121527 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
103030 | 121533 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
103456 | 121525 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | |||
152599 | 121532 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
170258 | 121530 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
171370 | 121537 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
184177 | 121536 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
184275 | 121529 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
185771 | 121538 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
187581 | 121535 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
190355 | 121534 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
133882 | 187944 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015109.7038 | 2115276.55289 | 37.7889950679055 | -122.391545539018 | (37.7889950679055, -122.391545539018) | 6 | 2 | 9 | 28855 | 6 | ||||
21732 | 121544 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
30239 | 121540 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
46657 | 121543 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
48226 | 121547 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
73712 | 121545 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
117838 | 121542 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
139844 | 121546 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
186332 | 121541 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
71462 | 187943 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015093.73077 | 2115293.30797 | 37.7890401869059 | -122.391601975949 | (37.7890401869059, -122.391601975949) | 6 | 2 | 9 | 28855 | 6 | ||||
34491 | 187942 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015080.74918 | 2115307.92538 | 37.7890796023783 | -122.391647913344 | (37.7890796023783, -122.391647913344) | 6 | 2 | 9 | 28855 | 6 | ||||
160771 | 187941 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015065.49236 | 2115322.58848 | 37.7891190169896 | -122.391701726057 | (37.7891190169896, -122.391701726057) | 6 | 2 | 9 | 28855 | 6 | ||||
110801 | 187940 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015048.62855 | 2115342.19505 | 37.7891719160015 | -122.391761444649 | (37.7891719160015, -122.391761444649) | 6 | 2 | 9 | 28855 | 6 | ||||
30147 | 115348 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014915.48611 | 2114547.78532 | 37.7869832575075 | -122.39216652446 | (37.7869832575075, -122.39216652446) | 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 | |
101037 | 115350 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014880.23802 | 2114582.9179 | 37.7870777663613 | -122.392290933986 | (37.7870777663613, -122.392290933986) | 6 | 2 | 9 | 28855 | 6 | |
47139 | 257910 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 199x Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | 3x3 | 6014800 | 2111540 | 37.778718149686 | -122.392355631341 | (37.778718149686, -122.392355631341) | 6 | 2 | 9 | 28856 | 20 | ||
121157 | 257909 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 199x Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | 3x3 | 6014800 | 2111540 | 37.778718149686 | -122.392355631341 | (37.778718149686, -122.392355631341) | 6 | 2 | 9 | 28856 | 20 | ||
193393 | 257908 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 199x Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | 3x3 | 6014800 | 2111540 | 37.778718149686 | -122.392355631341 | (37.778718149686, -122.392355631341) | 6 | 2 | 9 | 28856 | 20 | ||
153202 | 115351 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014858.41874 | 2114606.67601 | 37.7871417890985 | -122.392368086818 | (37.7871417890985, -122.392368086818) | 6 | 2 | 9 | 28855 | 6 | |
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 | |
184398 | 115346 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 398X HARRISON ST | 1 | 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 | |
60187 | 115352 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014845.33617 | 2114621.37484 | 37.7871814222392 | -122.392414378515 | (37.7871814222392, -122.392414378515) | 6 | 2 | 9 | 28855 | 6 | |
22052 | 115353 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014819.91687 | 2114646.31579 | 37.7872484927813 | -122.39250406973 | (37.7872484927813, -122.39250406973) | 6 | 2 | 9 | 28855 | 6 | |
116898 | 115354 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014804.62773 | 2114662.16926 | 37.7872911737029 | -122.39255807669 | (37.7872911737029, -122.39255807669) | 6 | 2 | 9 | 28855 | 6 | |
134726 | 113241 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 329 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3 | 3x4 | Permit Number 770912 | 6014742.36618 | 2112476.99378 | 37.7812877223957 | -122.39262057329 | (37.7812877223957, -122.39262057329) | 6 | 2 | 9 | 28856 | 6 | |
65353 | 115355 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014786.34664 | 2114681.69198 | 37.7873437633547 | -122.392622692086 | (37.7873437633547, -122.392622692086) | 6 | 2 | 9 | 28855 | 6 | |
93218 | 113240 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 329 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 2 | 3x4 | Permit Number 770912 | 6014728.70394 | 2112464.72966 | 37.7812532891345 | -122.392666980121 | (37.7812532891345, -122.392666980121) | 6 | 2 | 9 | 28856 | 6 | |
36960 | 113338 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2X STANFORD ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727 | 2112481 | 37.7812978691674 | -122.392674013487 | (37.7812978691674, -122.392674013487) | 6 | 2 | 9 | 28856 | 6 | ||
125850 | 113335 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2X STANFORD ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727 | 2112481 | 37.7812978691674 | -122.392674013487 | (37.7812978691674, -122.392674013487) | 6 | 2 | 9 | 28856 | 6 |
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) );