trees

1,732 rows where qLegalStatus_id = 6 sorted by Zip Codes

✎ View and edit SQL

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)
157916 110559 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 320x FULTON ST 1 Sidewalk: Property side : Yard Tree Private 2       10x36   6006080 2112015 37.7795343118474 -122.422555311635 (37.7795343118474, -122.422555311635) 7 9 11 28852 10
160060 258238 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 7 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
161677 105090 Significant Tree 6 :: 45 344 Fulton St 10 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
166073 112419 Significant Tree 6 Picea Spp :: Spruce Spp 200 268 Lily St 1 Back Yard : Yard Tree Private 2   07/29/2015 12:00:00 AM 3     6005334.87738 2110100.0463 37.7742342515583 -122.424996726643 (37.7742342515583, -122.424996726643) 7 9 11 28852 10
167444 105083 Significant Tree 6 :: 45 344 Fulton St 3 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
167525 258528 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 50 Hermann St 4 Sidewalk: Property side : Cutout Tree Private 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
170978 108021 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 455X Ivy St 1 Front Yard : Cutout Tree Private 2           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936) 7 9 11 28852 10
172262 103613 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 3 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
174212 104782 Significant Tree 6 Tree(s) :: 17 246-290X Eddy St 2 Front Yard : Yard Tree Private 2           6009232.7 2113643.9 37.7841842385635 -122.411763863717 (37.7841842385635, -122.411763863717) 14 10 9 28852 36
174521 258525 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 50 Hermann St 1 Sidewalk: Property side : Cutout Tree Private 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
176793 98949 Significant Tree 6 Eucalyptus camaldulensis :: River Red Gum 342 401 Grove St 9 Front Yard : Yard Tree Private 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
182332 258021 Significant Tree 6 Tree(s) :: 17 201x Gough St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6006013 2110374 37.7750247439455 -122.422670446803 (37.7750247439455, -122.422670446803) 7 9 11 28852 10
182906 103611 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 1 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
186789 105088 Significant Tree 6 :: 45 344 Fulton St 8 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
187436 114429 Significant Tree 6 Olea europaea :: Olive Tree 9 455 EDDY ST 1 Sidewalk: Curb side : Pot Tree Private 2     10 3x3   6008254 2113439 37.7835666804498 -122.415135318852 (37.7835666804498, -122.415135318852) 7 10 9 28852 36
194054 121158 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 2 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
419 78519 Significant Tree 6 Tree(s) :: 17 12 Sumner St 1 Front Yard : Yard Tree Private 2     15 3x3   6009421 2110873 37.7765865656959 -122.410916638665 (37.7765865656959, -122.410916638665) 8 2 9 28853 34
1467 259815 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 9 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
3205 259817 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 11 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
3287 259814 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 8 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
5213 84938 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 145 Guerrero St 1 Front Yard : Yard Tree Private 2         Permit Number 49347 6005480 2108218 37.7690748022624 -122.42436083172 (37.7690748022624, -122.42436083172) 8 4 5 28853 19
6413 259813 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 7 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
6612 259812 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 6 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
6691 256248 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 199x Clinton Park 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6005490 2108162 37.7689216043545 -122.424322258789 (37.7689216043545, -122.424322258789) 8 4 5 28853 19
7698 259819 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 13 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
8301 114726 Significant Tree 6 :: 45 520 Townsend St 2 Front Yard : Yard Tree Private 2           6012508.1 2109575.3 37.7731959986981 -122.400146236912 (37.7731959986981, -122.400146236912) 14 2 9 28853 34
9200 259821 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 15 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
9674 97174 Significant Tree 6 Tristaniopsis laurina :: Swamp Myrtle 1 26 Gilbert St   Sidewalk: Property side : Cutout Tree Private 2 FUF         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458) 14 2 9 28853 34
9703 264868 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 145 Guerrero St 1 Side Yard : Yard Tree Private 2       3x3   6005490 2108162 37.7689216043545 -122.424322258789 (37.7689216043545, -122.424322258789) 8 4 5 28853 19
12030 259810 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
13096 259808 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
13203 259818 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 12 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
13753 259809 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
14597 106873 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 38 08th St 4 Front Yard : Cutout Tree Private 2         Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
14819 259822 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 16 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
14961 259823 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 17 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
16309 259807 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
16536 259816 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 10 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
17902 113640 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 545X Minna St 1 Sidewalk: Property side : Cutout Tree Private 2           6010081.18772 2112137.85468 37.7800965567953 -122.408722101319 (37.7800965567953, -122.408722101319) 14 2 9 28853 34
18661 259820 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 14 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
18707 259811 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 5 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
19958 104685 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 7 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
22296 113639 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1X Russ St 3 Sidewalk: Property side : Cutout Tree Private 2           6009949.39418 2111947.85897 37.7795674908256 -122.409164626268 (37.7795674908256, -122.409164626268) 14 2 9 28853 34
24833 104679 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 1 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
33143 116090 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 19
33161 254729 Significant Tree 6 Cryptomeria japonica :: Japanese Cryptomeria 420 1940 Mission St 6 Sidewalk: Property side : Yard Tree Private 2       Width 0ft   6006763.6807 2106952.0622 37.7656712394659 -122.419830807079 (37.7656712394659, -122.419830807079) 8 4 7 28853 19
37577 100056 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 401X Tehama St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.7809848079497 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
43381 104682 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 4 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
47325 104683 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 5 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
48610 256247 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 199x Clinton Park 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6005490 2108162 37.7689216043545 -122.424322258789 (37.7689216043545, -122.424322258789) 8 4 5 28853 19
51708 173779 Significant Tree 6 Ficus macrophylla :: Morton Bay Fig 322 99X Cleveland St 2 Side Yard : Yard Tree Private 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
54660 116089 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 19
64486 104680 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 2 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
66793 84935 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 145 Guerrero St 1 Front Yard : Yard Tree Private 2   06/06/2007 12:00:00 AM     Permit Number 49347 6005480 2108218 37.7690748022624 -122.42436083172 (37.7690748022624, -122.42436083172) 8 4 5 28853 19
67051 113134 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 50 03rd St 2 Front Yard : Yard Tree Private 2   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968) 12 2 9 28853 6
67412 107136 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 700X Stevenson St 1 Front Yard : Yard Tree Private 2   07/31/2014 12:00:00 AM     Permit Number 769156 6008444.34042 2111440.428 37.7780897748997 -122.414335356247 (37.7780897748997, -122.414335356247) 8 2 9 28853 34
69806 106872 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 38 08th St 3 Front Yard : Cutout Tree Private 2   07/31/2014 12:00:00 AM     Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
76208 106874 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 38 08th St 5 Front Yard : Cutout Tree Private 2         Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
77590 173780 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 99X Cleveland St 3 Side Yard : Yard Tree Private 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
78403 258093 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1825 Mission St 7 Front Yard : Yard Tree Private 2   04/04/2019 12:00:00 AM 3 3X3   6006778.7933 2107821.9347 37.7680605555842 -122.419840266187 (37.7680605555842, -122.419840266187) 8 4 7 28853 19
87462 107036 Significant Tree 6 Tree(s) :: 17 350 08th St   Sidewalk: Property side : Cutout Tree Private 2   07/23/2014 12:00:00 AM   7x7 Permit Number 772214 6009826 2110084 37.7744428576765 -122.409459923405 (37.7744428576765, -122.409459923405) 8 2 9 28853 34
93652 115295 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 500X 08TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010511 2109243 37.7721720235673 -122.407031076357 (37.7721720235673, -122.407031076357) 14 2 9 28853 34
94582 256246 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 199x Clinton Park 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6005490 2108162 37.7689216043545 -122.424322258789 (37.7689216043545, -122.424322258789) 8 4 5 28853 19
96610 116088 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 19
101123 256285 Significant Tree 6 Persea americana :: Avocado 34 155x Caledonia St 1 Back Yard : Yard Tree Private 2       3x3   6006400 2106945 37.765631353558 -122.421088199968 (37.765631353558, -122.421088199968) 8 4 7 28853 19
104445 104681 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 3 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
105286 108275 Significant Tree 6 Arecastrum romanzoffianum :: Queen Palm 135 1800x ALAMEDA ST 5 Front Yard : Cutout Tree Private 2     15     6011533 2107928 37.7686184708296 -122.403403344125 (37.7686184708296, -122.403403344125) 8 2 8 28853 20
109218 107137 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 700X Stevenson St 2 Front Yard : Yard Tree Private 2   07/31/2014 12:00:00 AM     Permit Number 769156 6008444.34042 2111440.428 37.7780897748997 -122.414335356247 (37.7780897748997, -122.414335356247) 8 2 9 28853 34
110899 114725 Significant Tree 6 :: 45 520 Townsend St 1 Front Yard : Yard Tree Private 2           6012508.1 2109575.3 37.7731959986981 -122.400146236912 (37.7731959986981, -122.400146236912) 14 2 9 28853 34
112975 107342 Significant Tree 6 Prunus laurocerasus :: English laurel 371 110 JULIAN AVE 1 Back Yard : Yard Tree Private 2     100     6006340.8 2107214.1 37.7663669011591 -122.421312071366 (37.7663669011591, -122.421312071366) 8 4 7 28853 19
113295 113637 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1X Russ St 1 Sidewalk: Property side : Cutout Tree Private 2           6009949.39418 2111947.85897 37.7795674908256 -122.409164626268 (37.7795674908256, -122.409164626268) 14 2 9 28853 34
115063 107139 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 700X Stevenson St 4 Front Yard : Yard Tree Private 2   07/31/2014 12:00:00 AM     Permit Number 769156 6008444.34042 2111440.428 37.7780897748997 -122.414335356247 (37.7780897748997, -122.414335356247) 8 2 9 28853 34
115499 113638 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 1X Russ St 2 Sidewalk: Property side : Cutout Tree Private 2           6009949.39418 2111947.85897 37.7795674908256 -122.409164626268 (37.7795674908256, -122.409164626268) 14 2 9 28853 34
122222 116087 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 19
126309 258077 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 291 Duboce Ave 4 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   6005037.67201 2108401.42033 37.7695534429634 -122.425903876974 (37.7695534429634, -122.425903876974) 8 4 5 28853 19
135261 106871 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 38 08th St 2 Front Yard : Cutout Tree Private 2   07/31/2014 12:00:00 AM     Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
143592 105678 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 101X 03RD ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4   6012079.1 2114345.8 37.7862707590298 -122.401965633825 (37.7862707590298, -122.401965633825) 12 2 9 28853 6
145519 173778 Significant Tree 6 Tree(s) :: 17 99X Cleveland St 1 Side Yard : Cutout Tree Private 2       3x3   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
146386 107343 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 110 JULIAN AVE 2 Back Yard : Yard Tree Private 2     15     6006340.8 2107214.1 37.7663669011591 -122.421312071366 (37.7663669011591, -122.421312071366) 8 4 7 28853 19
148345 104684 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 6 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
151585 254728 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1940 Mission St 5 Sidewalk: Property side : Yard Tree Private 2       Width 0ft   6006763.6807 2106952.0622 37.7656712394659 -122.419830807079 (37.7656712394659, -122.419830807079) 8 4 7 28853 19
153818 100055 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 401X Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.7809848079497 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
156075 258076 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 291 Duboce Ave 3 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   6005037.67201 2108401.42033 37.7695534429634 -122.425903876974 (37.7695534429634, -122.425903876974) 8 4 5 28853 19
158154 258096 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 941 Mission St 4 Sidewalk: Property side : Yard Tree Private 2   05/13/2019 12:00:00 AM 3 3x3   6010493.2294 2112796.27211 37.7819274857178 -122.407343084927 (37.7819274857178, -122.407343084927) 14 2 9 28853 34
162331 97175 Significant Tree 6 Tristaniopsis laurina :: Swamp Myrtle 1 26 Gilbert St   Sidewalk: Property side : Cutout Tree Private 2 FUF         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458) 14 2 9 28853 34
167489 104452 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1045 Mission St 1 Sidewalk: Property side : Cutout Tree Private 2       2x6 Permit Number 770594 6009749.9 2112056.4 37.7798543407434 -122.409862429103 (37.7798543407434, -122.409862429103) 14 2 9 28853 34
171136 84937 Significant Tree 6 Tree(s) :: 17 145 Guerrero St 1 Front Yard : Yard Tree Private 2         Permit Number 770120 6005480 2108218 37.7690748022624 -122.42436083172 (37.7690748022624, -122.42436083172) 8 4 5 28853 19
174218 113641 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 545X Minna St 2 Sidewalk: Property side : Cutout Tree Private 2           6010081.18772 2112137.85468 37.7800965567953 -122.408722101319 (37.7800965567953, -122.408722101319) 14 2 9 28853 34
175722 107138 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 700X Stevenson St 3 Front Yard : Yard Tree Private 2   07/31/2014 12:00:00 AM     Permit Number 769156 6008444.34042 2111440.428 37.7780897748997 -122.414335356247 (37.7780897748997, -122.414335356247) 8 2 9 28853 34
181750 6099 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 500X 08th St 1 Sidewalk: Property side : Cutout Tree Private 2     18 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
182623 106870 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 38 08th St 1 Front Yard : Cutout Tree Private 2   07/31/2014 12:00:00 AM 2   Permit Number 769156 6008504.13663 2111439.18954 37.7780897331906 -122.414128411309 (37.7780897331906, -122.414128411309) 8 2 9 28853 34
182777 84936 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 145 Guerrero St 1 Front Yard : Yard Tree Private 2           6005480 2108218 37.7690748022624 -122.42436083172 (37.7690748022624, -122.42436083172) 8 4 5 28853 19
184663 113133 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 50 03rd St 1 Front Yard : Yard Tree Private 2   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968) 12 2 9 28853 6
188934 100054 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 401X Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.7809848079497 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
18276 119614 Significant Tree 6 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2X Sutter St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6012582 2115890 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916) 4 1 10 28854 6
101055 119613 Significant Tree 6 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2X Sutter St 1 Sidewalk: Property side : Cutout Tree Private 2     12 3x3   6012582 2115890 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916) 4 1 10 28854 6
2213 261044 Significant Tree 6 Tilia cordata :: Littleleaf Linden 12 499x Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2019 12:00:00 AM 3 3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6
9218 106080 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 188 The Embarcadero 1 Front Yard : Yard Tree Private 2   03/20/2014 12:00:00 AM     Permit Number 771259 6015087.8131 2116516.98611 37.7923997963133 -122.391708043282 (37.7923997963133, -122.391708043282) 12 2 9 28855 6
9433 261043 Significant Tree 6 Tilia cordata :: Littleleaf Linden 12 499x Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6
16799 261042 Significant Tree 6 Tilia cordata :: Littleleaf Linden 12 499x Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2019 12:00:00 AM 3 3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);