1,732 rows where qLegalStatus_id = 6 sorted by Longitude

View and edit SQL

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)
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
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
70249 113112 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1633 OAKDALE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2           6014731 2095647 37.7350755495662 -122.391482947841 (37.7350755495662, -122.391482947841) 10 3 8 58 1
9218 106080 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 188 The Embarcadero 1 Front Yard : Yard Tree Private 2   03/20/2014 12:00:00 AM     Permit Number 771259 6015087.8131 2116516.98611 37.7923997963133 -122.391708043282 (37.7923997963133, -122.391708043282) 12 2 9 28855 6
73440 116094 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
80147 116095 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
118842 116091 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
145439 116093 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
154885 116096 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
170444 116097 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
177168 116092 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
3578 261993 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 1557x Bancroft Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014548 2092008 37.7250734320456 -122.391861276019 (37.7250734320456, -122.391861276019) 10 3 8 58 1
11444 261994 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 1557x Bancroft Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014548 2092008 37.7250734320456 -122.391861276019 (37.7250734320456, -122.391861276019) 10 3 8 58 1
17656 261984 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 1557 Bancroft Ave 4 Sidewalk: Property side : Yard Tree DPW 1           6014517 2091967 37.7249591332222 -122.391965574806 (37.7249591332222, -122.391965574806) 10 3 8 58 1
17557 261982 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 2403 Keith St 3 Sidewalk: Property side : Yard Tree DPW 1           6014456 2092405 37.7261584067484 -122.392207065149 (37.7261584067484, -122.392207065149) 10 3 8 58 1
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
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
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
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
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
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
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
5747 94949 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 116 50 Pomona St   : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
72268 94951 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 116 50 Pomona St   : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
78450 94948 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
101013 94947 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
130983 94950 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 116 50 Pomona St   : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
135218 94946 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
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
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
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
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
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
185499 94945 Significant Tree 6 Aesculus californica :: California Buckeye 168 1820X Palou Ave   : Cutout Tree Rec/Park 5 FUF 04/04/2009 12:00:00 AM       6013714.4 2096294.3 37.7367964240349 -122.395043047708 (37.7367964240349, -122.395043047708) 10 3 8 58 1
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
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
2213 261044 Significant Tree 6 Tilia cordata :: Littleleaf Linden 12 499x Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2019 12:00:00 AM 3 3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6
9433 261043 Significant Tree 6 Tilia cordata :: Littleleaf Linden 12 499x Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6
16799 261042 Significant Tree 6 Tilia cordata :: Littleleaf Linden 12 499x Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2019 12:00:00 AM 3 3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 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
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
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
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
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
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
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
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
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
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
19052 260948 Significant Tree 6 Pinus radiata :: Monterey Pine 15 370 Drumm St 1 Side Yard : Yard Tree Private 2           6013616 2118213 37.7969748404412 -122.396919555024 (37.7969748404412, -122.396919555024) 3 1 10 28860 6
54776 109969 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 1x DAVIS ST 1 Sidewalk: Property side : Cutout Tree Private 2   08/28/2015 12:00:00 AM 18 3x3 Permit Number 774526 6013431.7 2116562.3 37.7924321476874 -122.397441457592 (37.7924321476874, -122.397441457592) 4 2 10 28860 6
144153 109970 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 1x DAVIS ST 2 Sidewalk: Property side : Cutout Tree Private 2   08/28/2015 12:00:00 AM   3x3 Permit Number 774526 6013431.7 2116562.3 37.7924321476874 -122.397441457592 (37.7924321476874, -122.397441457592) 4 2 10 28860 6
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
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
5983 110477 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 131X Washington St 1 Back Yard : Yard Tree Private 2   04/16/2015 12:00:00 AM 3 10x10 Permit Number 774729 6013427.21844 2117958.83498 37.7962664536588 -122.397554954018 (37.7962664536588, -122.397554954018) 3 1 10 28860 6
4419 260950 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 460x Davis Ct 2 Side Yard : Yard Tree Private 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
13002 260949 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 460x Davis Ct 1 Side Yard : Yard Tree Private 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 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
12731 107057 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 601X Davis St 2 Front Yard : Yard Tree Private 2   07/23/2014 12:00:00 AM 9   Permit Number 771755 6013145.32204 2118507.86888 37.7977582696821 -122.398568926718 (37.7977582696821, -122.398568926718) 3 1 10 28860 6
100360 107056 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 601X Davis St 1 Front Yard : Yard Tree Private 2   07/23/2014 12:00:00 AM 12   Permit Number 771755 6013142.97136 2118525.31961 37.7978060542679 -122.39857828598 (37.7978060542679, -122.39857828598) 3 1 10 28860 6
16781 260951 Significant Tree 6 Pinus radiata :: Monterey Pine 15 190 Jackson St 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   6013038 2118237 37.7970085486816 -122.398921272101 (37.7970085486816, -122.398921272101) 3 1 10 28860 6
703 262210 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 2011 Bay Shore Blvd 1 Front Yard : Yard Tree Private 2       3x3   6012422 2088364 37.7149494891568 -122.398955034798 (37.7149494891568, -122.398955034798) 10 3 8 309 1
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
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
175229 107058 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 600X Front St 2 Front Yard : Yard Tree Private 2   07/23/2014 12:00:00 AM 14   Permit Number 771755 6012887.2102 2118277.80134 37.797112176041 -122.399445910496 (37.797112176041, -122.399445910496) 3 1 10 28860 6
129267 98161 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 600 Front St   Front Yard : Yard Tree Private 2   12/21/2011 12:00:00 AM     Permit Number 768589 6012888.4 2118392.6 37.7974274520849 -122.399449857041 (37.7974274520849, -122.399449857041) 3 1 10 28860 6
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
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
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
8301 114726 Significant Tree 6 :: 45 520 Townsend St 2 Front Yard : Yard Tree Private 2           6012508.1 2109575.3 37.7731959986981 -122.400146236912 (37.7731959986981, -122.400146236912) 14 2 9 28853 34
110899 114725 Significant Tree 6 :: 45 520 Townsend St 1 Front Yard : Yard Tree Private 2           6012508.1 2109575.3 37.7731959986981 -122.400146236912 (37.7731959986981, -122.400146236912) 14 2 9 28853 34
18276 119614 Significant Tree 6 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2X Sutter St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6012582 2115890 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916) 4 1 10 28854 6
101055 119613 Significant Tree 6 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2X Sutter St 1 Sidewalk: Property side : Cutout Tree Private 2     12 3x3   6012582 2115890 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916) 4 1 10 28854 6
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
139061 118322 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 720 BATTERY ST 1 unknown : Yard Tree Private 2           6012486 2118560 37.7978646555778 -122.400854041686 (37.7978646555778, -122.400854041686) 3 1 10 28860 6
126483 106838 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 735 Battery St 1 Front Yard : Pot Tree Private 2         Permit Number 773117 6012413.67639 2118682.92207 37.7981981357359 -122.401112945062 (37.7981981357359, -122.401112945062) 3 1 10 28860 6
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
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
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
47218 99951 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1160 Battery St 1 Front Yard : Yard Tree Private 2   06/19/2012 12:00:00 AM     Permit Number 768993 6012314.3 2120017.7 37.8018575696458 -122.401550680127 (37.8018575696458, -122.401550680127) 3 1 10 28860 6
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
64053 96906 Significant Tree 6 Ulmus 'Frontier' :: Frontier Elm 115 1155@Sansome Battery St 1 Front Yard : Yard Tree Private 2   08/05/2011 12:00:00 AM   Plaza Permit Number 768022 6012245 2120028 37.8018819838627 -122.401791216362 (37.8018819838627, -122.401791216362) 3 1 10 28860 6
84386 99192 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1155@Sansome Battery St 3 Front Yard : Yard Tree Private 2       Plaza Permit Number 768022 6012245 2120028 37.8018819838627 -122.401791216362 (37.8018819838627, -122.401791216362) 3 1 10 28860 6
93882 99191 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1155@Sansome Battery St 2 Front Yard : Yard Tree Private 2     9 Plaza Permit Number 768022 6012232.15659 2120086.23158 37.8020411569217 -122.401839756495 (37.8020411569217, -122.401839756495) 3 1 10 28860 6
76886 106942 Significant Tree 6 Tree(s) :: 17 1300@ Embarcadero Battery St 1 Front Yard : Yard Tree Private 2   07/02/2014 12:00:00 AM     Permit Number 772680 6012231.9986 2120618.97397 37.8035039293343 -122.401877773891 (37.8035039293343, -122.401877773891) 3 1 10 28860 6
89552 107399 Significant Tree 6 Tree(s) :: 17 1300X Sansome St 1 Front Yard : Yard Tree Private 2   09/02/2014 12:00:00 AM 3   Permit Number 772689 6012222 2120529 37.8032563246841 -122.401906046114 (37.8032563246841, -122.401906046114) 3 1 10 28860 6
143592 105678 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 101X 03RD ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4   6012079.1 2114345.8 37.7862707590298 -122.401965633825 (37.7862707590298, -122.401965633825) 12 2 9 28853 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
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
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
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
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
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

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