trees

116 rows where Fire Prevention Districts = 13 and qLegalStatus_id = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

  • 13 · 116 ✖
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
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
6097 95161 Significant Tree 6 Acer palmatum :: Japanese Maple 216 2721 Pacific Ave   Front Yard : Yard Tree Private 2         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252) 13 6 1 29490 27
7770 98170 Significant Tree 6 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 2324 Sacramento St   Front Yard : Yard Tree Private 2   12/22/2011 12:00:00 AM 3   Permit Number 768454 6003670.2 2115963.1 37.7902385582714 -122.431173718492 (37.7902385582714, -122.431173718492) 13 9 1 29490 27
8183 261995 Significant Tree 6 Phoenix spp :: Date palm (species unknown) 255 2727 Pierce St 2 Front Yard : Yard Tree Private 2   10/07/2020 12:00:00 AM 3 3x3 Permit Number 785198 6001553 2117834 37.7952553588401 -122.438633170174 (37.7952553588401, -122.438633170174) 13 9 1 57 27
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
12411 260714 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2290 Lyon St 1 Back Yard : Cutout Tree Private 2       3x3 Permit Number 784756 5999390 2116615 37.7917850243096 -122.446029746387 (37.7917850243096, -122.446029746387) 13 6 1 29490 27
12590 121368 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 245 Mallorca Way 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 778992 6001431 2120732 37.8032055622797 -122.439263127997 (37.8032055622797, -122.439263127997) 13 9 1 57 17
13981 261996 Significant Tree 6 Phoenix spp :: Date palm (species unknown) 255 2727 Pierce St 1 Front Yard : Yard Tree Private 2   10/07/2020 12:00:00 AM 3 3x3 Permit Number 785198 6001553 2117834 37.7952553588401 -122.438633170174 (37.7952553588401, -122.438633170174) 13 9 1 57 27
14136 112391 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 2201X LYON ST 2 Sidewalk: Property side : Cutout Tree Private 2       3x12   5999307 2116423 37.7912531030346 -122.446303107227 (37.7912531030346, -122.446303107227) 13 6 1 29490 31
14326 112045 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2418 Pacific Ave 1 Front Yard : Yard Tree Private 2   06/26/2020 12:00:00 AM 3 3x3 Permit Number 785474 6002446.95594 2117111.03197 37.7933210893366 -122.435488200226 (37.7933210893366, -122.435488200226) 13 9 1 29490 27
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
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
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
18680 262301 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 2117 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000330 2116040 37.7902598573453 -122.44273605224 (37.7902598573453, -122.44273605224) 13 6 1 29490 27
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
20207 105239 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 6 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
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
24819 122688 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 2590 Pacific Ave 1 Front Yard : Yard Tree Private 2     16 3x8   6001760 2117029 37.7930568116395 -122.43785923272 (37.7930568116395, -122.43785923272) 13 6 1 29490 27
27763 105240 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 10 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
27860 107983 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 2405x Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6001231.00707 2116743.47753 37.7922427464694 -122.439669095376 (37.7922427464694, -122.439669095376) 13 6 1 29490 27
28531 173636 Significant Tree 6 Tree(s) :: 17 2590 Pacific Ave 2 Front Yard : Yard Tree Private 2   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760 2117029 37.7930568116395 -122.43785923272 (37.7930568116395, -122.43785923272) 13 6 1 29490 27
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
32335 173635 Significant Tree 6 Tree(s) :: 17 2590 Pacific Ave 1 Front Yard : Cutout Tree Private 2   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760 2117029 37.7930568116395 -122.43785923272 (37.7930568116395, -122.43785923272) 13 6 1 29490 27
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
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
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
46495 85086 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
48200 108097 Significant Tree 6 Tree(s) :: 17 3370 Washington St 2 Front Yard : Cutout Tree Private 2           5998663.3699 2115944.31994 37.789901994506 -122.448495552231 (37.789901994506, -122.448495552231) 13 6 1 54 31
50429 99288 Significant Tree 6 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 845 Marina Blvd 1 Front Yard : Yard Tree Private 2   06/05/2012 12:00:00 AM 1   Permit Number 768788 5998881.62913 2121328.006 37.8046966310161 -122.448128205765 (37.8046966310161, -122.448128205765) 13 9 1 57 17
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
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
58472 104728 Significant Tree 6 Tree(s) :: 17 3212 Jackson St 1 Front Yard : Cutout Tree Private 2   11/06/2013 12:00:00 AM     Permit Number 770525 5998810.5 2116292.9 37.7908675143955 -122.448011605492 (37.7908675143955, -122.448011605492) 13 6 1 54 31
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
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
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
72773 112366 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 2224 Baker St 1 Front Yard : Cutout Tree Private 2       3x3 Permit Number 775823 5999858.5 2116547.8 37.791627252722 -122.444403911295 (37.791627252722, -122.444403911295) 13 6 1 29490 27
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
73226 114272 Significant Tree 6 Tree(s) :: 17 2241 Sacramento St 1 Front Yard : Cutout Tree Private 2   03/22/2016 12:00:00 AM 3 3x6 Permit Number 776884 6004082.4 2115905.7 37.7901043022718 -122.429743441495 (37.7901043022718, -122.429743441495) 13 9 1 29490 27
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
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
81307 96767 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 2229 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     12   Permit Number 768245 6003236 2116309 37.7911636966224 -122.432700736457 (37.7911636966224, -122.432700736457) 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
81784 93874 Significant Tree 6 Pistacia chinensis :: Chinese Pistache 32 2614 Sacramento St   Front Yard : Tree Private 2   04/14/2010 12:00:00 AM     Permit Number 53370 6002291 2115777 37.7896493226209 -122.435932319436 (37.7896493226209, -122.435932319436) 13 6 1 29490 27
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
82918 107986 Significant Tree 6 Juniperus chinensis :: Juniper 113 2401x SCOTT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001257 2116757 37.7922813550603 -122.439580129378 (37.7922813550603, -122.439580129378) 13 6 1 29490 27
83971 105071 Significant Tree 6 Acacia stenophylla :: Shoestring Acacia 30 1808 Vallejo St 1 Front Yard : Yard Tree Private 2     3   Permit Number 771033 6004794.05676 2118138.55822 37.7962754378239 -122.427440299436 (37.7962754378239, -122.427440299436) 13 9 1 57 17
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
89745 85085 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
90493 108096 Significant Tree 6 Ficus rubiginosa :: Port Jackson Fig 339 3370 Washington St 1 Front Yard : Cutout Tree Private 2     17   Permit Number 773610 5998674.83986 2115933.37372 37.7898725948813 -122.448455078738 (37.7898725948813, -122.448455078738) 13 6 1 54 31
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
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
95081 112874 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2636 Vallejo St 1 Sidewalk: Property side : Cutout Tree Private 2   08/25/2015 12:00:00 AM 13 3x3 Permit Number 776037 6000935.48392 2117605.97258 37.7945941075731 -122.440753504176 (37.7945941075731, -122.440753504176) 13 9 1 57 27
98322 107720 Significant Tree 6 Tree(s) :: 17 2301x Baker St 3 Front Yard : Yard Tree Private 2   10/20/2014 12:00:00 AM 3   Permit Number 773397 5999765.63181 2116886.19958 37.7925511097437 -122.44474956777 (37.7925511097437, -122.44474956777) 13 6 1 29490 27
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
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
102859 87188 Significant Tree 6 Tree(s) :: 17 2119 Bush St   Front Yard : Yard Tree Private 2   01/29/2008 12:00:00 AM     Permit Number 50204 6002998 2114831 37.7870919849741 -122.433418544226 (37.7870919849741, -122.433418544226) 13 9 11 29490 27
104499 107984 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 2401x SCOTT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001096 2116670 37.7920333111805 -122.440130949989 (37.7920333111805, -122.440130949989) 13 6 1 29490 27
105054 100572 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 3020 Washington St 1 Front Yard : Yard Tree Private 2     3   Permit Number 769157 6000180.60876 2116141.82829 37.790530933705 -122.443260250183 (37.790530933705, -122.443260250183) 13 6 1 29490 27
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
106956 251495 Significant Tree 6 Tree(s) :: 17 2448 Clay St 1 Sidewalk: Curb side : Yard Tree Private 2   06/28/2017 12:00:00 AM 3 10x10 Permit Number 780000 6003026 2116224 37.7909183964794 -122.433421252488 (37.7909183964794, -122.433421252488) 13 9 1 29490 27
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
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
115527 122689 Significant Tree 6 Aesculus hippocastanum :: White Horsechestnut 190 2590 Pacific Ave 2 Front Yard : Yard Tree Private 2     12 3x8   6001760 2117029 37.7930568116395 -122.43785923272 (37.7930568116395, -122.43785923272) 13 6 1 29490 27
117572 105241 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 11 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
117668 105242 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 14 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
118931 85087 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
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
128000 104003 Significant Tree 6 Acer palmatum 'Sango Kaku' :: Coral Bark Maple 550 2109 Steiner St 1 Sidewalk: Property side : Cutout Tree Private 2   07/17/2013 12:00:00 AM     Permit Number 767176 6002333.5 2115633.4 37.7892574480846 -122.435774995524 (37.7892574480846, -122.435774995524) 13 6 1 29490 27
128387 113771 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2550 Broadway 3 Sidewalk: Property side : Cutout Tree Private 2     5     6001386.1067 2117311.2447 37.7938105138862 -122.439173160634 (37.7938105138862, -122.439173160634) 13 9 1 57 27
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
134012 117417 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2835 Washington St 1 Sidewalk: Property side : Yard Tree Private 2       3x10 Permit Number 778177 6001153.1 2116153.5 37.7906183870332 -122.439896334555 (37.7906183870332, -122.439896334555) 13 6 1 29490 27
137101 251410 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2777 Pine St 1 Front Yard : Cutout Tree Private 2       3x3 Permit Number 779015 6000658 2114782 37.7868244087741 -122.441510888069 (37.7868244087741, -122.441510888069) 13 6 1 29490 27
139296 253970 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
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
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
147066 121377 Significant Tree 6 Prunus ilicifoia :: Holly-leaved Cherry 245 2701 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001200 2116539 37.7916795394978 -122.439761713662 (37.7916795394978, -122.439761713662) 13 6 1 29490 27
147409 95215 Significant Tree 6 Acer palmatum :: Japanese Maple 216 2203 Divisadero St   Front Yard : Yard Tree Private 2           6000868 2115894 37.7898896344174 -122.440864138631 (37.7898896344174, -122.440864138631) 13 6 1 29490 27
150357 100434 Significant Tree 6 Tree(s) :: 17 2430 Sacramento St 1 Front Yard : Yard Tree Private 2   09/24/2012 12:00:00 AM     Permit Number 769154 6003168.3 2115899 37.7900341016439 -122.432905672523 (37.7900341016439, -122.432905672523) 13 9 1 29490 27
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
156627 125128 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2545 Baker St 2 Sidewalk: Property side : Yard Tree Private 2     13 Width 4ft   5999632.15337 2117620.57677 37.7945598973812 -122.44526423016 (37.7945598973812, -122.44526423016) 13 9 1 57 27
159837 253968 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
161834 107985 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 2401x SCOTT ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001096 2116670 37.7920333111805 -122.440130949989 (37.7920333111805, -122.440130949989) 13 6 1 29490 27
162406 255994 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 179 Retiro Way 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   6001908 2121813 37.8062008335618 -122.437689923584 (37.8062008335618, -122.437689923584) 13 9 1 57 17
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
166311 127110 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201 Laguna St 1 Sidewalk: Property side : Yard Tree Private 2     23 Width 6ft   6003718.35126 2119752.0994 37.8006449063974 -122.431277695812 (37.8006449063974, -122.431277695812) 13 9 1 57 17
166780 173951 Significant Tree 6 Tree(s) :: 17 2646 Union St 1 Front Yard : Cutout Tree Private 2   04/11/2017 12:00:00 AM 3 10x10 Permit Number 779549 6000338 2118225 37.7962597494046 -122.442865342513 (37.7962597494046, -122.442865342513) 13 9 1 57 17
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
168909 112367 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2770 Broadway 1 Sidewalk: Property side : Cutout Tree Private 2   07/23/2015 12:00:00 AM 3 3x3 Permit Number 774944 6000432.43478 2117179.73451 37.7933951089516 -122.442463497617 (37.7933951089516, -122.442463497617) 13 9 1 57 27

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