trees

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

✎ 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)
22 262394 Significant Tree 6 Pinus radiata :: Monterey Pine 15 66 Cleary Ct 1 Sidewalk: Property side : Cutout Tree DPW 1   11/13/2020 12:00:00 AM 3 3x3   6004824 2113713 37.7841256623529 -122.427021325889 (37.7841256623529, -122.427021325889) 13 9 11 28858 41
29 264952 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 2 Front Yard : Yard Tree Private 2   11/13/2020 12:00:00 AM 3     6004818 2113712 37.7841225773231 -122.427042012496 (37.7841225773231, -122.427042012496) 13 9 11 28858 41
31 264951 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 1 Front Yard : Yard Tree Private 2   11/13/2020 12:00:00 AM 3     6004818 2113712 37.7841225773231 -122.427042012496 (37.7841225773231, -122.427042012496) 13 9 11 28858 41
64 264974 Significant Tree 6 Persea americana :: Avocado 34 1868 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003954 2119422 37.7997518904289 -122.430438688757 (37.7997518904289, -122.430438688757) 13 9 1 57 17
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
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
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
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
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
10123 257894 Significant Tree 6 Metrosideros robusta :: Northern Rata Tree 335 1776 Vallejo St 1 Front Yard : Yard Tree Private 2   01/27/2020 12:00:00 AM 3     6005064 2118169 37.7963742870274 -122.426508408066 (37.7963742870274, -122.426508408066) 13 9 1 28858 17
10900 256098 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 1776 Vallejo St 1 Front Yard : Cutout Tree Private 2           6005064.21519 2118169.93221 37.7963768588038 -122.426507729874 (37.7963768588038, -122.426507729874) 13 9 1 28858 17
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
15160 260680 Significant Tree 6 Tree(s) :: 17 1450x Laguna St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6004617 2113883 37.7845807327875 -122.42774958855 (37.7845807327875, -122.42774958855) 13 9 11 28858 41
15591 262378 Significant Tree 6 Yucca spp :: Yucca 289 2172 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002662 2118213 37.796359019498 -122.434822974351 (37.796359019498, -122.434822974351) 13 9 1 57 17
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
16717 262293 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2418 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002408 2117119 37.7933407549318 -122.435623560602 (37.7933407549318, -122.435623560602) 13 9 1 29490 27
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
17242 253971 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
17502 260902 Significant Tree 6 Populus alba :: White Poplar 184 1901 Geary Blvd 1 Sidewalk: Property side : Cutout Tree DPW 1       Width 0ft   6002672 2113572 37.7836165897996 -122.434456380093 (37.7836165897996, -122.434456380093) 13 9 11 29490 41
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
18899 261161 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 2452 Green St 1 Front Yard : Cutout Tree Private 2       3x3   6001304 2118013 37.7957326780501 -122.439507585878 (37.7957326780501, -122.439507585878) 13 9 1 57 17
22018 106361 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1645 WEBSTER ST 2 Front Yard : Yard Tree Private 2     30     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178) 13 9 11 29490 13
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
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
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
30713 99829 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 2398 Broadway 3 Front Yard : Yard Tree Private 2           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376) 13 9 1 29490 27
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
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
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
37483 85089 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 2 Sidewalk: Property side : Cutout Tree Private 2           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
39009 255287 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 2758 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999862 2117824 37.7951315610034 -122.444483561153 (37.7951315610034, -122.444483561153) 13 9 1 57 17
40123 256065 Significant Tree 6 Juniperus chinensis :: Juniper 113 2800 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2018 12:00:00 AM 3 3x3   6002545 2117972 37.7956906526811 -122.435210571933 (37.7956906526811, -122.435210571933) 13 9 1 57 17
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
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
43750 253165 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1451 Bay St 3 Front Yard : Yard Tree Private 2       3x3   6003691 2120547 37.8028259466608 -122.431429119577 (37.8028259466608, -122.431429119577) 13 9 1 57 17
44345 253366 Significant Tree 6 Ficus carica :: Edible Fig 341 20 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004582 2109434 37.7723628942784 -122.427553605007 (37.7723628942784, -122.427553605007) 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
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
56668 113769 Significant Tree 6 Tree(s) :: 17 2550 Broadway 1 Sidewalk: Property side : Cutout Tree Private 2           6001418.65940389 2117313.19689891 37.7938177263924 -122.439060665499 (37.7938177263924, -122.439060665499) 13 9 1 57 27
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
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
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
60900 103616 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 201X Haight St 1 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
62300 99828 Significant Tree 6 Juniperus chinensis :: Juniper 113 2398 Broadway 2 Front Yard : Yard Tree Private 2           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376) 13 9 1 29490 27
62475 107113 Significant Tree 6 Brahea edulis :: Guadalupe Palm 218 2100 MARKET ST   Front Yard : Cutout Tree Private 2           6004034 2107672.1 37.7674941340109 -122.429323526179 (37.7674941340109, -122.429323526179) 7 9 5 28862 3
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
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
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
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
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
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
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
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
75842 103617 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 201X Haight St 2 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
78486 94301 Significant Tree 6 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1150X Fillmore St 5 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
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
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
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
80605 99830 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 2398@Steiner Broadway 1 Front Yard : Cutout Tree Private 2           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376) 13 9 1 29490 27
81315 104261 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1556X O'Farrell St 1 Front Yard : Yard Tree Private 2           6003781.85581 2113525.38813 37.783551542878 -122.430613377711 (37.783551542878, -122.430613377711) 13 9 11 29490 41
82071 106360 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1820 POST ST 1 Front Yard : Yard Tree Private 2     30     6003351.1 2114201.6 37.785383838011 -122.432151932321 (37.785383838011, -122.432151932321) 13 9 11 29490 13
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
84706 103143 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2620 Buchanan St 1 Front Yard : Yard Tree Private 2       3x3   6003626 2117322 37.7939672460834 -122.431423695166 (37.7939672460834, -122.431423695166) 13 9 1 29490 27
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
88383 103615 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 5 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 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
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
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
92073 98492 Significant Tree 6 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2149 Laguna St 1 Front Yard : Yard Tree Private 2           6004211.7 2116183 37.7908730187591 -122.429315856087 (37.7908730187591, -122.429315856087) 13 9 1 29490 27
92359 120121 Significant Tree 6 Juglans hindsii :: Walnut: Black (n.calif) 457 444 Page St 1 Front Yard : Yard Tree Private 2           6004415 2109849 37.7734929358756 -122.428160854421 (37.7734929358756, -122.428160854421) 7 9 11 28852 10
92381 116164 Significant Tree 6 Juniperus chinensis :: Juniper 113 2411 OCTAVIA ST 1 Sidewalk: Curb side : Yard Tree Private 2     13 15x4   6004495 2117637 37.7948813682629 -122.428439330772 (37.7948813682629, -122.428439330772) 13 9 1 28858 27
92540 113772 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2550 Broadway 4 Sidewalk: Property side : Cutout Tree Private 2     4     6001375.31674 2117310.7972 37.7938086711861 -122.439210462719 (37.7938086711861, -122.439210462719) 13 9 1 57 27
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
95437 103618 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 201X Haight St 3 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
98424 94303 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 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
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
99727 258388 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2770 Lombard St 2 Front Yard : Cutout Tree Private 2           5999223 2119112 37.7986315842223 -122.446787313103 (37.7986315842223, -122.446787313103) 13 9 1 57 17
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
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
100759 99832 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 2398@Steiner Broadway 3 Front Yard : Cutout Tree Private 2           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376) 13 9 1 29490 27
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
105107 85090 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 3 Sidewalk: Property side : Cutout Tree Private 2           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
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
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
108843 253969 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
109250 107818 Significant Tree 6 Ficus Spp. :: 101 474 Oak St 1 Sidewalk: Property side : Cutout Tree Private 2       3X3   6004715.2 2110227.8 37.7745500089947 -122.427149405032 (37.7745500089947, -122.427149405032) 7 9 11 28852 10
109809 106362 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1645 WEBSTER ST 1 Front Yard : Yard Tree Private 2     12     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178) 13 9 11 29490 13
110134 103612 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 2 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
110239 94295 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 2 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
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
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
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
118707 94293 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 1 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
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
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
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
124902 257918 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 2200 Vallejo St 1 Front Yard : Yard Tree Private 2       3x3   6002990 2117900 37.7955182191045 -122.433665645084 (37.7955182191045, -122.433665645084) 13 9 1 57 17
125282 110236 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100 BUCHANAN ST 1 Sidewalk: Curb side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3 3x20   6004868.5 2109011.4 37.7712187378523 -122.426532477218 (37.7712187378523, -122.426532477218) 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)
);