trees

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

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes ▼ Neighborhoods (old)
18324 109414 Significant Tree 6 Persea americana :: Avocado 34 4 GUY PL 1 Front Yard : Yard Tree Private 2     14     6014378.1 2114502.6 37.7868293368446 -122.394022608955 (37.7868293368446, -122.394022608955) 6 2 9 28855 6
40244 115123 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 499X MAIN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
45878 173675 Significant Tree 6 Populus trichocarpa :: Black Cottonwood Poplar 464 299x Beale St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
46337 115125 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 499X MAIN ST 3 Sidewalk: Curb side : Cutout Tree Private 2     8     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
48723 96186 Significant Tree 6 Tree(s) :: 17 333 Harrison St 3 Sidewalk: Property side : Tree Private 2         Permit Number 767224 6015127.7 2114620.1 37.7871935976335 -122.39143736362 (37.7871935976335, -122.39143736362) 6 2 9 28855 6
50152 173671 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 299x Beale St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
62378 173676 Significant Tree 6 Populus trichocarpa :: Black Cottonwood Poplar 464 299x Beale St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
65204 100696 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 3 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
67391 173674 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 102 299x Beale St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
68704 173596 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 300 Howard St 1 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 779179 6014439 2115766 37.7903017260092 -122.393900378517 (37.7903017260092, -122.393900378517) 12 2 9 28855 6
68737 104228 Significant Tree 6 Tree(s) :: 17 183 FREMONT ST 1 Front Yard : Yard Tree Private 2     4   Permit Number 770922 6014038 2115456 37.7894282446126 -122.395266095466 (37.7894282446126, -122.395266095466) 12 2 9 28855 6
70762 100699 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 6 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
73225 100695 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 2 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
92116 173673 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 102 299x Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
93660 96184 Significant Tree 6 Tree(s) :: 17 333 Harrison St 1 Sidewalk: Property side : Tree Private 2         Permit Number 767224 6015127.7 2114620.1 37.7871935976335 -122.39143736362 (37.7871935976335, -122.39143736362) 6 2 9 28855 6
98870 100701 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 8 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
100518 100698 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 5 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
110338 115124 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 499X MAIN ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
111755 109415 Significant Tree 6 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 4 GUY PL 2 Front Yard : Yard Tree Private 2           6014378.1 2114502.6 37.7868293368446 -122.394022608955 (37.7868293368446, -122.394022608955) 6 2 9 28855 6
126787 96185 Significant Tree 6 Tree(s) :: 17 333 Harrison St 2 Sidewalk: Property side : Tree Private 2         Permit Number 767224 6015127.7 2114620.1 37.7871935976335 -122.39143736362 (37.7871935976335, -122.39143736362) 6 2 9 28855 6
137482 100694 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 1 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
170900 100697 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 4 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
177074 173678 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 299x Beale St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
181535 173677 Significant Tree 6 Populus trichocarpa :: Black Cottonwood Poplar 464 299x Beale St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
182062 100700 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 200X 01st St 7 Front Yard : Yard Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
182808 173672 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 102 299x Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
684 260585 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
2321 48402 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 706 Wisconsin St 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2010 12:00:00 AM     Permit Number 53935 6012689.64928807 2104214.1545054 37.7584856101735 -122.399141839868 (37.7584856101735, -122.399141839868) 10 3 8 28856 29
3099 104652 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 953 Indiana St 1 Front Yard : Cutout Tree Private 2           6015057.1 2104275.7 37.7587862506702 -122.390958369803 (37.7587862506702, -122.390958369803) 10 3 8 28856 29
4313 105327 Significant Tree 6 Tree(s) :: 17 2051 03rd St 1 Back Yard : Yard Tree Private 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
4938 260583 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
6111 260586 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
6121 260584 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
7964 105328 Significant Tree 6 Tree(s) :: 17 2051 03rd St 2 Back Yard : Yard Tree Private 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
9510 260587 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 890x Harrison St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
12165 260922 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 866 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 774734 6011543 2104306 37.7586738299336 -122.403113948893 (37.7586738299336, -122.403113948893) 10 3 8 28856 29
15941 85313 Significant Tree 6 Ficus nitida :: Laurel Fig 53 610 Brannan St 1 unknown : Cutout Tree Private 2         Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
16794 261146 Significant Tree 6 Ficus Spp. :: 101 375x Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2020 12:00:00 AM 3 3x3   6014494 2112212 37.780546313007 -122.393461254196 (37.780546313007, -122.393461254196) 6 2 9 28856 6
22679 108026 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 862 Kansas St   Front Yard : Yard Tree Private 2         Permit Number 774734 6011570 2104296 37.7586478799274 -122.403019866682 (37.7586478799274, -122.403019866682) 10 3 8 28856 29
23612 253210 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 567 Mississippi St 1 Sidewalk: Property side : Yard Tree Private 2   05/02/2019 12:00:00 AM 3 3x3   6014163 2104519 37.7594046471392 -122.394067636073 (37.7594046471392, -122.394067636073) 10 3 8 28856 29
38818 105964 Significant Tree 6 Tree(s) :: 17 360 MISSOURI ST 1 Front Yard : Yard Tree Private 2           6013401.8 2105413.2 37.7618175880082 -122.396762946114 (37.7618175880082, -122.396762946114) 10 3 8 28856 29
39513 98455 Significant Tree 6 Washingtonia filifera :: California Fan Palm 176 2200 22nd St 1 Front Yard : Yard Tree Private 2           6011565.2 2103754.7 37.7571613219705 -122.402998394603 (37.7571613219705, -122.402998394603) 10 3 8 28856 29
43892 99623 Significant Tree 6 Tree(s) :: 17 380 Connecticut St 1 Front Yard : Yard Tree Private 2   05/23/2012 12:00:00 AM     Permit Number 768850 6013171.4 2105301.7 37.7614986071193 -122.397551993257 (37.7614986071193, -122.397551993257) 10 3 8 28856 29
53862 173726 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1101 Connecticut St 1 Front Yard : Yard Tree Private 2           6013424 2101939 37.7522794251173 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 1
60629 106612 Significant Tree 6 Schinus molle :: California Pepper 91 1189 TENNESSEE ST   Front Yard : Yard Tree Private 2     55     6015654.1 2103577.3 37.7569017014681 -122.388844893024 (37.7569017014681, -122.388844893024) 10 3 8 28856 29
66713 107149 Significant Tree 6 Pinus radiata :: Monterey Pine 15 612 WISCONSIN ST 1 Back Yard : Yard Tree Private 2           6012651.9 2104553.6 37.7594155491308 -122.399296223309 (37.7594155491308, -122.399296223309) 10 3 8 28856 29
67194 106251 Significant Tree 6 Tree(s) :: 17 580 De Haro St 2 Front Yard : Yard Tree Private 2         Permit Number 770844 6012025.9 2105717.4 37.7625761768628 -122.401543046462 (37.7625761768628, -122.401543046462) 8 3 8 28856 29
67239 251216 Significant Tree 6 Myoporum laetum :: Myoporum 62 399X Townsend St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6013957 2110872 37.776837125863 -122.395225113019 (37.776837125863, -122.395225113019) 6 2 9 28856 20
79585 108000 Significant Tree 6 Tree(s) :: 17 1000 Rhode Island St 1 Back Yard : Yard Tree Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774025 6011852.20179 2103661.18899 37.7569205837919 -122.401999252275 (37.7569205837919, -122.401999252275) 10 3 8 28856 29
81334 106255 Significant Tree 6 Tree(s) :: 17 1900X 18th St 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 770844 6012067 2105610 37.7622835736204 -122.401393347502 (37.7622835736204, -122.401393347502) 8 3 8 28856 29
85061 255144 Significant Tree 6 Cupressus sempervirens :: Italian Cypress 204 101x Hawthorne St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013362 2113756 37.7847228211314 -122.3974857221 (37.7847228211314, -122.3974857221) 6 2 9 28856 6
95493 100209 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 701 Rhode Island St 1 Front Yard : Yard Tree Private 2     10   Permit Number 769013 6011855.86556 2105057.10212 37.7607536567646 -122.402084714731 (37.7607536567646, -122.402084714731) 10 3 8 28856 29
103863 251217 Significant Tree 6 Myoporum laetum :: Myoporum 62 399X Townsend St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6013957 2110872 37.776837125863 -122.395225113019 (37.776837125863, -122.395225113019) 6 2 9 28856 20
110183 112361 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 561X Folsom St 1 Front Yard : Yard Tree Private 2   11/16/2015 12:00:00 AM 3 10x30 Permit Number 775828 6013749.7362 2114198.90646 37.7859605214302 -122.396175324952 (37.7859605214302, -122.396175324952) 6 2 9 28856 6
119547 107080 Significant Tree 6 Magnolia x soulangiana :: Saucer Magnolia 147 401X TOWNSEND ST 8 Sidewalk: Property side : Cutout Tree Private 2     14 2x30   6013045 2110022 37.774452457479 -122.398320364295 (37.774452457479, -122.398320364295) 14 2 9 28856 20
133327 255538 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 700x Folsom St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6012646 2113072 37.7828048233647 -122.399914812284 (37.7828048233647, -122.399914812284) 6 2 9 28856 34
135623 258062 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 567 Mississippi St 2 Sidewalk: Property side : Yard Tree Private 2   05/02/2019 12:00:00 AM 3 3x3   6014163 2104519 37.7594046471392 -122.394067636073 (37.7594046471392, -122.394067636073) 10 3 8 28856 29
138347 116585 Significant Tree 6 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 2100 22nd St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2018 12:00:00 AM 30 3x3   6011855.05017 2103755.96694 37.7571809821214 -122.401996064067 (37.7571809821214, -122.401996064067) 10 3 8 28856 29
168413 106611 Significant Tree 6 Callistemon citrinus :: Lemon Bottlebrush 67 1154 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6011908.79849 2103025.72201 37.7551788898075 -122.401758852609 (37.7551788898075, -122.401758852609) 10 3 8 28856 29
177101 96784 Significant Tree 6 Acer palmatum :: Japanese Maple 216 615 Rhode Island St   Sidewalk: Property side : Cutout Tree Private 2   07/19/2011 12:00:00 AM     Permit Number 767987 6011854.6 2105476.9 37.7619062576766 -122.402118605761 (37.7619062576766, -122.402118605761) 10 3 8 28856 29
185174 255539 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 700x Folsom St 17 Sidewalk: Property side : Cutout Tree Private 2       3x3   6012646 2113072 37.7828048233647 -122.399914812284 (37.7828048233647, -122.399914812284) 6 2 9 28856 34
187289 115806 Significant Tree 6 Robinia pseudoacacia :: Black Locust 286 362 MISSOURI ST 1 Front Yard : Cutout Tree Private 2     12 3x3   6013446 2105415 37.7618249904211 -122.39661020099 (37.7618249904211, -122.39661020099) 10 3 8 28856 29
191992 94463 Significant Tree 6 Pinus radiata :: Monterey Pine 15 744 Carolina St 1 : Tree Private 2   06/10/2010 12:00:00 AM     Permit Number 53681 6012327.5 2104524.9 37.7593186601765 -122.400416148756 (37.7593186601765, -122.400416148756) 10 3 8 28856 29
192621 106250 Significant Tree 6 Tree(s) :: 17 580 De Haro St 1 Front Yard : Yard Tree Private 2         Permit Number 770844 6012025.9 2105717.4 37.7625761768628 -122.401543046462 (37.7625761768628, -122.401543046462) 8 3 8 28856 29
34754 101438 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 3 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
44600 107186 Significant Tree 6 Pinus radiata :: Monterey Pine 15 945 Sacramento St 2 Front Yard : Yard Tree Private 2         Permit Number 773422 6010352.63458 2116759.0624 37.7928004918921 -122.408109042355 (37.7928004918921, -122.408109042355) 3 1 10 28857 4
106637 101435 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 1 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
127351 101436 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 2 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
150077 107187 Significant Tree 6 Pinus radiata :: Monterey Pine 15 945 Sacramento St 3 Front Yard : Yard Tree Private 2         Permit Number 773422 6010352.63458 2116759.0624 37.7928004918921 -122.408109042355 (37.7928004918921, -122.408109042355) 3 1 10 28857 4
155139 101440 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 5 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
161031 101439 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 4 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
191590 107016 Significant Tree 6 Tree(s) :: 17 945 SACRAMENTO ST 1 Front Yard : Yard Tree Private 2   01/24/2015 12:00:00 AM     Permit Number 773422 6010352.6 2116759.1 37.7928005931964 -122.408109164657 (37.7928005931964, -122.408109164657) 3 1 10 28857 4
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
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
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
6580 261206 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 2301 Leavenworth St 1 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
8743 261207 Significant Tree 6 Umbellularia californica :: California Bay 326 2301 Leavenworth St 3 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
9964 262274 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 4 Montclair Ter 1 Side Yard : Yard Tree Private 2           6007298.70359 2120216.09204 37.8021211637502 -122.418921105258 (37.8021211637502, -122.418921105258) 5 1 1 28858 32
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
15016 261205 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 2301 Leavenworth St 2 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
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
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
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
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
31713 107635 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 1150 Lombard St 10 Front Yard : Yard Tree Private 2   10/01/2014 12:00:00 AM 3   Permit Number 773092 6006825.00646 2120436.80144 37.8027004912885 -122.420576003873 (37.8027004912885, -122.420576003873) 5 1 1 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
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
51973 106945 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1150 LOMBARD ST 4 Front Yard : Yard Tree Private 2     13   Permit Number 773092 6006825 2120436.8 37.8027004869705 -122.420576026126 (37.8027004869705, -122.420576026126) 5 1 1 28858 32
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
61387 114840 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2455x HYDE ST   Sidewalk: Curb side : Cutout Tree PUC 8     12 3x3   6006980 2120877 37.8039178984324 -122.420070904619 (37.8039178984324, -122.420070904619) 5 1 1 28858 32
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
70399 121205 Significant Tree 6 Cotoneaster SPP :: Cotoneaster 96 930 Chestnut St 1 Front Yard : Yard Tree Private 2     20 3x3   6007386.5238 2120591.43483 37.8031567047665 -122.418643837145 (37.8031567047665, -122.418643837145) 5 1 1 28858 32
71235 98244 Significant Tree 6 Taxus baccata :: Irish Yew 86 901 Bay St 1 Front Yard : Yard Tree Private 2     5     6006420.63185 2121080.7781 37.8044458892203 -122.422021121489 (37.8044458892203, -122.422021121489) 5 1 1 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
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
80380 114184 Significant Tree 6 Tree(s) :: 17 2454 HYDE ST 1 Front Yard : Cutout Tree Private 2   01/07/2016 12:00:00 AM   30x30 Permit Number 776893 6007060 2120781 37.8036588138585 -122.41978724304 (37.8036588138585, -122.41978724304) 5 1 1 28858 32

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