trees

208 rows where Police Districts = 9 and qLegalStatus_id = 6 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
4164 260061 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 8 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
8078 260059 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 6 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
9215 260060 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 7 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
18171 260058 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 5 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
100242 106956 Significant Tree 6 Tree(s) :: 17 50 Fell St 3 Front Yard : Yard Tree Private 2     14 10x10   6007226 2110908 37.7765593411304 -122.418512280303 (37.7765593411304, -122.418512280303) 7 9 9 28852 36
5414 261208 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1131 Sutter St 1 Front Yard : Cutout Tree Private 2       3x3   6007175 2115019 37.7878442781586 -122.418980353142 (37.7878442781586, -122.418980353142) 13 9 10 28858 21
116546 95242 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2620 Larkin St   Front Yard : Yard Tree Private 2     37   Permit Number 56959 6006630 2120172 37.801962421987 -122.421232011572 (37.801962421987, -122.421232011572) 5 9 1 28858 32
36041 255248 Significant Tree 6 Maytenus boaria :: Mayten 58 209x Willow St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41
85142 255249 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 209x Willow St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41
117546 255247 Significant Tree 6 Maytenus boaria :: Mayten 58 209x Willow St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41
139171 255246 Significant Tree 6 Maytenus boaria :: Mayten 58 209x Willow St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41
177763 255250 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 209x Willow St 5 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41
154508 109210 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2637 Larkin St 1 Front Yard : Yard Tree Private 2   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774817 6006569.78732 2120282.61277 37.8022627417937 -122.421448236261 (37.8022627417937, -122.421448236261) 5 9 1 28858 32
27012 255276 Significant Tree 6 Maytenus boaria :: Mayten 58 263 Willow St 6 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   6006404.75096 2113360.62408 37.7832473828943 -122.421527451234 (37.7832473828943, -122.421527451234) 7 9 11 28858 41
115750 255277 Significant Tree 6 Maytenus boaria :: Mayten 58 263 Willow St 7 Sidewalk: Property side : Cutout Tree Private 2       Width 4ft   6006404.75096 2113360.62408 37.7832473828943 -122.421527451234 (37.7832473828943, -122.421527451234) 7 9 11 28858 41
126646 255275 Significant Tree 6 Maytenus boaria :: Mayten 58 263 Willow St 5 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   6006404.75096 2113360.62408 37.7832473828943 -122.421527451234 (37.7832473828943, -122.421527451234) 7 9 11 28858 41
41224 258232 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 1 Sidewalk: Property side : Cutout Tree Private 2   04/24/2019 12:00:00 AM 3 3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
53621 258239 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 8 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
67916 258235 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
71526 258236 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
103945 258237 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 6 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
120900 258240 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 9 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
138832 258234 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
155172 258233 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 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
69 126274 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1240 Lombard St 1 Sidewalk: Property side : Yard Tree Private 2     24 Width 6ft   6006421.51674 2120105.21307 37.8017672864012 -122.421948716173 (37.8017672864012, -122.421948716173) 5 9 1 28858 32
91423 99643 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 1268 Lombard St 1 Front Yard : Yard Tree Private 2       3x3   6006289 2120073 37.8016713630652 -122.42240499597 (37.8016713630652, -122.42240499597) 5 9 1 28858 32
12063 95300 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 701 Golden Gate Ave   Front Yard : Yard Tree Private 2   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617 -122.422419858646 (37.780652317617, -122.422419858646) 7 9 11 28852 41
151632 95299 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 701 Golden Gate Ave   Front Yard : Yard Tree Private 2   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617 -122.422419858646 (37.780652317617, -122.422419858646) 7 9 11 28852 41
133531 187642 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 2526 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006264 2119500 37.8000966404513 -122.42245076966 (37.8000966404513, -122.42245076966) 13 9 1 28858 32
803 105089 Significant Tree 6 :: 45 344 Fulton St 9 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
15911 105081 Significant Tree 6 :: 45 344 Fulton St 1 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
17108 105086 Significant Tree 6 :: 45 344 Fulton St 6 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
75459 105084 Significant Tree 6 :: 45 344 Fulton St 4 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
91093 105091 Significant Tree 6 :: 45 344 Fulton St 11 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
126537 105082 Significant Tree 6 :: 45 344 Fulton St 2 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
145102 105085 Significant Tree 6 :: 45 344 Fulton St 5 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
154153 105087 Significant Tree 6 :: 45 344 Fulton St 7 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 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
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
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
140481 101742 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1590 Broadway 2 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM 8   Permit Number 769428 6006220.99461 2117990.30451 37.7959489722299 -122.422492252021 (37.7959489722299, -122.422492252021) 13 9 10 28858 32
157383 110560 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 320x FULTON ST 2 Sidewalk: Property side : Yard Tree Private 2       10x36   6006080 2112015 37.7795343118474 -122.422555311635 (37.7795343118474, -122.422555311635) 7 9 11 28852 10
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
55812 101740 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1590 Broadway 3 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM 10   Permit Number 769428 6006182.95151 2117984.64817 37.7959312951427 -122.42262348649 (37.7959312951427, -122.42262348649) 13 9 10 28858 32
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
172328 101741 Significant Tree 6 Tree(s) :: 17 1590 Broadway 1 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM     Permit Number 769428 6006147.8 2117991.4 37.7959478507639 -122.422745597666 (37.7959478507639, -122.422745597666) 13 9 10 28858 32
96773 92813 Significant Tree 6 Tree(s) :: 17 365 Fulton St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3 Permit Number 53020 6006011 2111744 37.7787863189721 -122.42277474798 (37.7787863189721, -122.42277474798) 7 9 11 28852 10
63716 101743 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1590 Broadway 4 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM 12   Permit Number 769428 6006129.33795 2117976.30804 37.7959053703882 -122.422808406898 (37.7959053703882, -122.422808406898) 13 9 10 28858 32
33858 255597 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 20x Starr King Way 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
73188 255598 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 20x Starr King Way 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
79307 255595 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 20x Starr King Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
91730 255599 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 20x Starr King Way 5 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2018 12:00:00 AM 3 3x3   6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
142991 255600 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 20x Starr King Way 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
168619 255596 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 20x Starr King Way 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
181978 107824 Significant Tree 6 Tree(s) :: 17 10 STARR KING WAY 6 Front Yard : Yard Tree Private 2   01/06/2015 12:00:00 AM 3   Permit Number 774657 6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
31523 98952 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 302 Ivy St 18 Front Yard : Yard Tree Private 2           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433) 7 9 11 28852 10
71208 98953 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 302 Ivy St 19 Front Yard : Yard Tree Private 2           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433) 7 9 11 28852 10
80590 98954 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 302 Ivy St 20 Front Yard : Yard Tree Private 2           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433) 7 9 11 28852 10
48151 98950 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 401 Grove St 10 Front Yard : Yard Tree Private 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
60074 98947 Significant Tree 6 Eucalyptus camaldulensis :: River Red Gum 342 401 Grove St 7 Front Yard : Yard Tree Private 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
69454 98948 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 401 Grove St 8 Front Yard : Yard Tree Private 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
140823 98951 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 401 Grove St 11 Front Yard : Yard Tree Private 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 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
72516 258223 Significant Tree 6 Pinus Spp :: Pine Spp 100 53 Starr King Way 1 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft Permit Number 782966 6005764 2113984 37.784922869937 -122.423788535241 (37.784922869937, -122.423788535241) 13 9 11 28858 41
66091 100771 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 450 Hayes St 2 Back Yard : Yard Tree Private 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
100606 100772 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 450 Hayes St 3 Back Yard : Yard Tree Private 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
147643 100770 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 450 Hayes St 1 Back Yard : Yard Tree Private 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
74407 121161 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 5 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
79081 121163 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 7 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
83376 121162 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 6 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
99672 121159 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 3 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
106415 121157 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 1 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
123818 121160 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 4 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
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
164727 99894 Significant Tree 6 Ulmus pumila :: Siberian Elm 99 1636 Bush St 1 Front Yard : Yard Tree Private 2   07/11/2012 12:00:00 AM     Permit Number 768849 6005665 2115204 37.7882670981083 -122.424217840789 (37.7882670981083, -122.424217840789) 13 9 1 28858 41
3436 103654 Significant Tree 6 Tree(s) :: 17 307X Octavia St 3 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
29114 103653 Significant Tree 6 Tree(s) :: 17 307X Octavia St 2 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
108684 103655 Significant Tree 6 Tree(s) :: 17 307X Octavia St 4 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
109449 103656 Significant Tree 6 Tree(s) :: 17 307X Octavia St 5 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
152489 103652 Significant Tree 6 Tree(s) :: 17 307X Octavia St 1 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
192756 94447 Significant Tree 6 Tree(s) :: 17 1103 Gough St 4 Sidewalk: Property side : Cutout Tree Private 2   08/06/2010 12:00:00 AM   3x3 Permit Number 53668 6005549.7 2113553.5 37.7837287235103 -122.424499312595 (37.7837287235103, -122.424499312595) 7 9 11 28858 41
12050 261306 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1555 Union St 1 Front Yard : Cutout Tree Private 2       3x3   6005549 2118864 37.7983099861265 -122.424879674285 (37.7983099861265, -122.424879674285) 13 9 1 57 17
60332 112420 Significant Tree 6 Picea Spp :: Spruce Spp 200 268 Lily St 2 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
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
94077 103591 Significant Tree 6 Juniperus chinensis :: Juniper 113 55X Laguna St 3 Front Yard : Yard Tree Private 2           6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
120358 103590 Significant Tree 6 Juniperus chinensis :: Juniper 113 55X Laguna St 2 Front Yard : Yard Tree Private 2           6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
154569 103589 Significant Tree 6 Juniperus chinensis :: Juniper 113 55X Laguna St 1 Front Yard : Yard Tree Private 2           6005242.6 2108960.5 37.7711001201992 -122.425234826708 (37.7711001201992, -122.425234826708) 7 9 5 28852 10
22312 116999 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 880x MCALLISTER ST 2 Front Yard : Cutout Tree Private 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
99950 117000 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 880x MCALLISTER ST 3 Front Yard : Cutout Tree Private 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
105893 116998 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 880x MCALLISTER ST 1 Front Yard : Cutout Tree Private 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
99529 103588 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 101X Laguna St 1 Front Yard : Yard Tree Private 2           6005198.60314 2109385.58511 37.772264815602 -122.425417269432 (37.772264815602, -122.425417269432) 7 9 5 28852 10
113506 108002 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 461X Ivy St 1 Front Yard : Cutout Tree Private 2           6005199.36333 2111122.83043 37.7770349120596 -122.425538300101 (37.7770349120596, -122.425538300101) 7 9 11 28852 10
65723 108022 Significant Tree 6 Grevillea robusta :: Silk Oak Tree 76 455X Ivy St 2 Front Yard : Cutout Tree Private 2           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936) 7 9 11 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
153500 33327 Significant Tree 6 Arbutus unedo :: Strawberry Tree 106 1629 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2010 12:00:00 AM   3x3 Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued 6005242.65792202 2118493.60609418 37.7972756709044 -122.425913331435 (37.7972756709044, -122.425913331435) 13 9 1 57 17
22976 103600 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 50X Hermann St 1 Front Yard : Yard Tree Private 2           6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
43239 258527 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 50 Hermann St 3 Sidewalk: Property side : Cutout Tree Private 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
60038 258526 Significant Tree 6 Pinus radiata :: Monterey Pine 15 50 Hermann St 2 Sidewalk: Property side : Cutout Tree Private 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 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

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