trees

8,298 rows where qLegalStatus_id = 4 sorted by Supervisor Districts

✎ 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)
60084 108595 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1599x GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005333 2119502 37.8000495685335 -122.42567253315 (37.8000495685335, -122.42567253315) 13 9 1 57 17
60295 107695 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2440X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6003685.72045 2116767.65354 37.7924485368973 -122.43117747007 (37.7924485368973, -122.43117747007) 13 9 1 29490 27
60574 34959 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 29 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 38552 5990777 2114840 37.7864157730855 -122.475700726719 (37.7864157730855, -122.475700726719) 11 6 1 54 33
60795 94982 Undocumented 4 Ficus nitida :: Laurel Fig 53 2301 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002562.1 2117394.1 37.7941048599095 -122.435110049481 (37.7941048599095, -122.435110049481) 13 9 1 29490 27
61209 105786 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3230 LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     36 6x4   5999056.8 2119897.7 37.8007794095396 -122.447418998501 (37.8007794095396, -122.447418998501) 13 9 1 57 17
61359 116892 Undocumented 4 Ficus laurel :: 247 2798X LYON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999158 2118194 37.7961072882302 -122.446946138081 (37.7961072882302, -122.446946138081) 13   1 57 30
61388 117060 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 214 SPRUCE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997156 2115480 37.7885407952581 -122.453677346309 (37.7885407952581, -122.453677346309) 11 6 1 54 31
61904 110184 Undocumented 4 Ceratonia siliqua :: Carob 5 1500x LYON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999718 2114083 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347) 15 6 1 29490 31
62297 138612 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2802 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6000495.2401 2114841.3803 37.7869781777261 -122.442078261692 (37.7869781777261, -122.442078261692) 13 6 1 29490 27
62640 121059 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
63386 114634 Undocumented 4 Tree(s) :: 17 2249 BRODERICK ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000268 2116383 37.7911981110048 -122.442975209437 (37.7911981110048, -122.442975209437) 13 6 1 29490 27
63654 99198 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 726 El Camino Del Mar 1 Sidewalk: Curb side : Cutout Tree Private 2           5986369 2114825 37.786118050599 -122.490949979792 (37.786118050599, -122.490949979792) 11 6 1 55 33
64229 113781 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2000X FRANKLIN ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005687 2116921 37.7929827928485 -122.424263888934 (37.7929827928485, -122.424263888934) 13 9 1 28858 27
65160 143531 Undocumented 4 Myoporum laetum :: Myoporum 62 2001 UNION ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6003323.1573 2118580.5634 37.7974057685705 -122.43256150006 (37.7974057685705, -122.43256150006) 13 9 1 57 17
65450 122588 Undocumented 4 Cordyline australis :: Dracena Palm 64 2500X Lyon St 8 Median : Cutout Tree Private 2     13 10x20   5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
65721 101600 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Daniel Burnham Ct 7 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 23334 6006156.1 2114693.3 37.7868925594682 -122.422482411139 (37.7868925594682, -122.422482411139) 13 9 1 28858 41
65934 117632 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 3406 CLAY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998421 2115586 37.7889042820755 -122.449308299768 (37.7889042820755, -122.449308299768) 13 6 1 54 31
65947 103484 Undocumented 4 Ficus nitida :: Laurel Fig 53 2375X Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 9x6   6007909 2120582.3 37.8031610244278 -122.416835141288 (37.8031610244278, -122.416835141288) 5 1 1 308 32
66003 99092 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2801@Broderick Broadway 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000146.4 2117058.8 37.7930467467367 -122.443444504836 (37.7930467467367, -122.443444504836) 13 6 1 29490 27
67018 105420 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2310 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 771076 6003772.4 2116466.9 37.7916276558922 -122.430856083318 (37.7916276558922, -122.430856083318) 13 9 1 29490 27
67334 99615 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
67455 95245 Undocumented 4 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 2626 Larkin St 2 Sidewalk: Property side : Cutout Tree Private 2   08/12/2010 12:00:00 AM 5 3x3 Permit Number 767140 6006627 2120193 37.802019913523 -122.421243885087 (37.802019913523, -122.421243885087) 5 9 1 28858 32
68016 111939 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 90 SEACLIFF AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     24     5987707 2115818 37.7889226212876 -122.486393845778 (37.7889226212876, -122.486393845778) 11 6 1 55 33
68209 103266 Undocumented 4 Myoporum laetum :: Myoporum 62 2365 UNION ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001713 2118319 37.7965961427299 -122.438114305108 (37.7965961427299, -122.438114305108) 13 9 1 57 17
69214 101006 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2801X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003500.6 2117942.3 37.7956633226967 -122.431901904302 (37.7956633226967, -122.431901904302) 13 9 1 57 17
69702 111922 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2 SEACLIFF AVE 1 Sidewalk: Curb side : Yard Tree Private 2     15     5988181 2115833 37.7889914240961 -122.484754991166 (37.7889914240961, -122.484754991166) 11 6 1 55 33
70257 117635 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 100 LOCUST ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997570 2115996 37.7899813188913 -122.452282225129 (37.7899813188913, -122.452282225129) 11 6 1 54 31
70345 255525 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 3 Sidewalk: Property side : Cutout Tree Private 2   07/09/2018 12:00:00 AM 3 3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
70734 100297 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3725 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6003062 2121090 37.8042812134182 -122.43364461008 (37.8042812134182, -122.43364461008) 13 9 1 57 17
71545 122696 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2500X Pierce St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001760 2117029 37.7930568116395 -122.43785923272 (37.7930568116395, -122.43785923272) 13 6 1 29490 27
71643 121056 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
71739 107513 Undocumented 4 Myoporum laetum :: Myoporum 62 2760 GREENWICH ST   Sidewalk: Curb side : Cutout Tree Private 2           5999743 2118796 37.797793624169 -122.444965226189 (37.797793624169, -122.444965226189) 13 9 1 57 17
72587 108102 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 2390X Green St 4 Sidewalk: Curb side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
72634 104807 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 2069 GREEN ST   Sidewalk: Curb side : Cutout Tree Private 2           6003141.4 2118171.7 37.7962728265697 -122.433161198258 (37.7962728265697, -122.433161198258) 13 9 1 57 17
73246 99725 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
73416 101431 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2501X Buchanan St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003643.1 2116935.1 37.7929058867978 -122.431336896261 (37.7929058867978, -122.431336896261) 13 9 1 29490 27
73467 100290 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
73542 117587 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1X NIDO AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999045 2111933 37.778909769135 -122.44688638485 (37.778909769135, -122.44688638485) 15 5 1 54 16
73600 110870 Undocumented 4 Myoporum laetum :: Myoporum 62 343X AUSTIN ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775635 6005575 2115207 37.7882702532087 -122.424529439646 (37.7882702532087, -122.424529439646) 13 9 1 28858 41
73787 116455 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2728 GREEN ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 4x4 Permit Number 778010 5999979 2117809 37.7950970500966 -122.444077646155 (37.7950970500966, -122.444077646155) 13 9 1 57 17
74189 102749 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2490X Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x6   6001093.5 2118310.7 37.7965381017858 -122.440257311894 (37.7965381017858, -122.440257311894) 13 9 1 57 17
74510 121050 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
74980 115241 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 2401 FRANKLIN ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6005332 2118242 37.7965898731316 -122.425586268684 (37.7965898731316, -122.425586268684) 13 9 1 57 17
75143 255642 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 220 Masonic Ave 4 Sidewalk: Property side : Yard Tree Private 2           5999023 2112089 37.7793368479896 -122.446973720271 (37.7793368479896, -122.446973720271) 15 5 1 54 16
75986 137839 Undocumented 4 Olea europaea :: Olive Tree 9 1800 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6005239.1389 2115489.1761 37.7890260654428 -122.425711556168 (37.7890260654428, -122.425711556168) 13 9 1 28858 27
76308 121322 Undocumented 4 Tree(s) :: 17 3699X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
76366 116798 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2120 BROADWAY 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003325 2117599 37.7947107530845 -122.432484978634 (37.7947107530845, -122.432484978634) 13 9 1 29490 27
76855 104702 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2590 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003190.5 2117454 37.7943049924865 -122.432940002135 (37.7943049924865, -122.432940002135) 13 9 1 29490 27
77814 114983 Undocumented 4 Tree(s) :: 17 178 CERVANTES BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777197 6001129 2121320 37.8048028635373 -122.440350399876 (37.8048028635373, -122.440350399876) 13 9 1 57 17
78150 98826 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 2099x Jones St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008101 2119295 37.7996372188946 -122.416079497811 (37.7996372188946, -122.416079497811) 5 1 1 308 32
78350 107828 Undocumented 4 Juniperus chinensis :: Juniper 113 2601 Van Ness Ave 2 Front Yard : Yard Tree Private 2     35   Permit Number 774138 6005744.5 2119283.2 37.7994720432373 -122.424233014169 (37.7994720432373, -122.424233014169) 13 9 1 28858 17
79230 103152 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2190X Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x9   6002428.2 2119190 37.7990283301562 -122.435701904836 (37.7990283301562, -122.435701904836) 13 9 1 57 17
79935 114613 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2199x BAKER ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999856 2116234 37.7907654976997 -122.444389999861 (37.7907654976997, -122.444389999861) 13 6 1 29490 27
80281 98825 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 2099x Jones St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008101 2119295 37.7996372188946 -122.416079497811 (37.7996372188946, -122.416079497811) 5 1 1 308 32
80748 116215 Undocumented 4 Myoporum laetum :: Myoporum 62 3801 SACRAMENTO ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996623 2114922 37.7869781063352 -122.455481088021 (37.7869781063352, -122.455481088021) 11 6 1 54 31
80914 255524 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 2461 Sacramento St 2 Sidewalk: Property side : Cutout Tree Private 2   07/09/2018 12:00:00 AM 3 3x3   6002905 2115842 37.7898626566676 -122.433812591785 (37.7898626566676, -122.433812591785) 13 9 1 29490 27
81078 114978 Undocumented 4 Pinus radiata :: Monterey Pine 15 1 PETER YORKE WAY 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6005775 2114336 37.7858899958642 -122.423775516058 (37.7858899958642, -122.423775516058) 13 9 1 28858 41
81595 116454 Undocumented 4 Tree(s) :: 17 2728 GREEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2   05/27/2016 12:00:00 AM 3 4x4 Permit Number 778010 5999979 2117809 37.7950970500966 -122.444077646155 (37.7950970500966, -122.444077646155) 13 9 1 57 17
81928 107454 Undocumented 4 Tree(s) :: 17 2101 CHESTNUT ST   Sidewalk: Curb side : Cutout Tree Private 2           6001686.4 2119715.1 37.8004279539124 -122.438306415372 (37.8004279539124, -122.438306415372) 13 9 1 57 17
81939 255640 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 220 Masonic Ave 2 Sidewalk: Property side : Yard Tree Private 2           5999023 2112089 37.7793368479896 -122.446973720271 (37.7793368479896, -122.446973720271) 15 5 1 54 16
82621 94976 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 2040@Jackson Franklin St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6005619 2117006 37.7932123416077 -122.42450522172 (37.7932123416077, -122.42450522172) 13 9 1 28858 27
82709 116214 Undocumented 4 Acer buergeranum :: Trident Maple 110 3801 SACRAMENTO ST 6 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2016 12:00:00 AM 3 3x3 Permit Number 778748 5996623 2114922 37.7869781063352 -122.455481088021 (37.7869781063352, -122.455481088021) 11 6 1 54 31
82931 110183 Undocumented 4 Ceratonia siliqua :: Carob 5 1500x LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999718 2114083 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347) 15 6 1 29490 31
82972 110185 Undocumented 4 Ceratonia siliqua :: Carob 5 1500x LYON ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999718 2114083 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347) 15 6 1 29490 31
83951 114090 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2835 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001183.08872 2115909.2328 37.7899493996846 -122.439775055277 (37.7899493996846, -122.439775055277) 13 6 1 29490 27
84584 110693 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 475X PRESIDIO AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998952 2114994 37.7873091646033 -122.447428491422 (37.7873091646033, -122.447428491422) 13 6 1 54 31
84605 110982 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 2597 SACRAMENTO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6002446 2115731 37.7895318223527 -122.435392744034 (37.7895318223527, -122.435392744034) 13 9 1 29490 27
84707 105273 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 232 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5986553.3 2114252.8 37.784557719608 -122.490270252434 (37.784557719608, -122.490270252434) 11 6 1 55 33
85081 113492 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2850 LAKE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5986565 2114493 37.7852179229774 -122.490247450243 (37.7852179229774, -122.490247450243) 11 6 1 55 33
85263 116800 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2120 BROADWAY 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003325 2117599 37.7947107530845 -122.432484978634 (37.7947107530845, -122.432484978634) 13 9 1 29490 27
85651 100050 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
85986 134827 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 991 Chestnut St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007349.29025 2120528.21446 37.8029810213102 -122.418768198988 (37.8029810213102, -122.418768198988) 5 1 1 28858 32
86105 113932 Undocumented 4 Tree(s) :: 17 800 EL CAMINO DEL MAR 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2016 12:00:00 AM   3x3 Permit Number 776988 5985966 2115003 37.7865832348262 -122.492357345241 (37.7865832348262, -122.492357345241) 11 6 1 55 33
86140 114841 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2670 LEAVENWORTH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007398 2121652 37.8060693936166 -122.418679378695 (37.8060693936166, -122.418679378695) 5 1 1 308 23
86583 106716 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 500 El Camino Del Mar 3 Sidewalk: Curb side : Cutout Tree Private 2           5987099 2115331 37.7875500018464 -122.488461609309 (37.7875500018464, -122.488461609309) 11 6 1 55 33
86594 117034 Undocumented 4 Acacia baileyana :: Bailey's Acacia 122 2220x SUTTER ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
86900 103275 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2800X Pine St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6000456.3 2114876.5 37.7870723881298 -122.442215507279 (37.7870723881298, -122.442215507279) 13 6 1 29490 27
86971 138785 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2762 PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6000685.4679 2114860.6917 37.7870420406648 -122.441421504519 (37.7870420406648, -122.441421504519) 13 6 1 29490 27
87664 110838 Undocumented 4 Auranticarpa rhombifolia :: Queensland Pittosporum 237 3900X DIVISADERO ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000216 2121331 37.8047810408361 -122.443510712402 (37.8047810408361, -122.443510712402) 13 9 1 57 17
88078 111951 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 73 SEACLIFF AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     28     5987709 2115789 37.7888431121968 -122.486384796167 (37.7888431121968, -122.486384796167) 11 6 1 55 33
88209 110028 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1900 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003453.1 2115265.7 37.788311370087 -122.431875050364 (37.788311370087, -122.431875050364) 13 9 1 29490 27
88513 104081 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2610 Lake St 5 Sidewalk: Curb side : Cutout Tree Private 2           5987336.5 2114673.6 37.7857588250819 -122.487591604742 (37.7857588250819, -122.487591604742) 11 6 1 55 33
88649 117068 Undocumented 4 Tree(s) :: 17 299X PRESIDIO AVE 4 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2016 12:00:00 AM 3 3x3 Permit Number 778413 5998965 2115900 37.7897975450498 -122.447448751983 (37.7897975450498, -122.447448751983) 13 6 1 54 31
88682 108989 Undocumented 4 :: 45 2073-2099X Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501) 13 9 1 57 17
90033 107359 Undocumented 4 Tree(s) :: 17 3636 Clay St   Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 771771 5997400.59946 2115444.59193 37.7884575935217 -122.452828517416 (37.7884575935217, -122.452828517416) 11 6 1 54 31
90401 250397 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 8 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5988195.49232 2115836.13559 37.789000877549 -122.484705080384 (37.789000877549, -122.484705080384) 11 6 1 55 33
90450 111988 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 31x 25TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     36     5988113 2115801 37.7888996007164 -122.484987910575 (37.7888996007164, -122.484987910575) 11 6 1 55 33
90515 98107 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 850 Jones St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6001068 2114562 37.7862436951175 -122.440076605796 (37.7862436951175, -122.440076605796) 13 6 1 29490 27
91024 107690 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2199 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6003671 2116909 37.7928358039924 -122.431238497045 (37.7928358039924, -122.431238497045) 13 9 1 29490 27
91308 107509 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 240 PIXLEY ST   Sidewalk: Curb side : Cutout Tree Private 2           6002182.3 2118985.3 37.7984523071777 -122.436538140501 (37.7984523071777, -122.436538140501) 13 9 1 57 17
91709 122691 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2590 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001760 2117029 37.7930568116395 -122.43785923272 (37.7930568116395, -122.43785923272) 13 6 1 29490 27
91738 114025 Undocumented 4 Tree(s) :: 17 3151X CLAY ST 3 Sidewalk: Curb side : Cutout Tree Public Library 12       3x3   5999725 2115439 37.7885751609396 -122.444786082443 (37.7885751609396, -122.444786082443) 13 6 1 29490 27
91941 101670 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Daniel Burnham Ct 10 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
92188 109666 Undocumented 4 Tree(s) :: 17 2X NIDO AVE 1 Sidewalk: Property side : Yard Tree Private 2           5999244 2112088 37.7793467258368 -122.446209119816 (37.7793467258368, -122.446209119816) 15 5 1 54 16
92515 100299 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3725 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6003062 2121090 37.8042812134182 -122.43364461008 (37.8042812134182, -122.43364461008) 13 9 1 57 17
92764 100287 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
93186 110692 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 475X PRESIDIO AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998952 2114994 37.7873091646033 -122.447428491422 (37.7873091646033, -122.447428491422) 13 6 1 54 31
93278 131107 Undocumented 4 Maytenus boaria :: Mayten 58 2400 Clay St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003178.6473 2116233.7601 37.7909538542967 -122.432893797319 (37.7909538542967, -122.432893797319) 13 9 1 29490 27
93479 101426 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2501X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003643.1 2116935.1 37.7929058867978 -122.431336896261 (37.7929058867978, -122.431336896261) 13 9 1 29490 27
93782 98137 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3101 Scott St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6000900 2119043.2 37.7985383349139 -122.440979438494 (37.7985383349139, -122.440979438494) 13 9 1 57 17

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