trees

1,732 rows where qLegalStatus_id = 6 sorted by Latitude descending

✎ 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)
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
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
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
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
184201 99827 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 2398 Broadway 1 Front Yard : Yard Tree Private 2           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376) 13 9 1 29490 27
187077 99831 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 2398@Steiner Broadway 2 Front Yard : Cutout Tree Private 2           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376) 13 9 1 29490 27
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
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
172310 113770 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2550 Broadway 2 Sidewalk: Property side : Cutout Tree Private 2     5     6001403.30227 2117311.89486 37.7938132775122 -122.439113709125 (37.7938132775122, -122.439113709125) 13 9 1 57 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
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
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
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
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
180419 105351 Significant Tree 6 Pyrus calleryana :: Ornamental Pear 44 2040 Jackson St 1 Front Yard : Yard Tree Private 2   01/16/2014 12:00:00 AM 3   Permit Number 769933 6004399.13095 2117053.27366 37.7932731788779 -122.428729419132 (37.7932731788779, -122.428729419132) 13 9 1 28858 27
171446 257980 Significant Tree 6 Ficus nitida :: Laurel Fig 53 2864 Broadway 3 Front Yard : Yard Tree Private 2         Permit Number 782825 5999909.76407 2117098.92712 37.7931434275556 -122.444266160734 (37.7931434275556, -122.444266160734) 13 9 1 57 27
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
189234 112390 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 2201X LYON ST 1 Sidewalk: Property side : Cutout Tree Private 2       3x12   5999307 2116423 37.7912531030346 -122.446303107227 (37.7912531030346, -122.446303107227) 13 6 1 29490 31
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
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
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
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
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
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
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
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
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
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
44979 39247 Significant Tree 6 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 3524 Jackson St 1 Front Yard : Cutout Tree Private 2   08/22/2002 12:00:00 AM   5x10 Permit Number 772836 5997387.02929021 2116081.37513577 37.7902052526208 -122.452921449726 (37.7902052526208, -122.452921449726) 11 6 1 54 31
104764 115564 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 3524 Jackson St 2 Front Yard : Cutout Tree Private 2       5x10   5997387.02929021 2116081.37513577 37.7902052526208 -122.452921449726 (37.7902052526208, -122.452921449726) 11 6 1 54 31
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
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
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
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
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
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
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
146644 105349 Significant Tree 6 Tree(s) :: 17 151X Spruce St 1 Front Yard : Yard Tree Private 2   01/16/2014 12:00:00 AM     Permit Number 771071 5997060.93638 2115845.70083 37.7895394616557 -122.45403267224 (37.7895394616557, -122.45403267224) 11 6 1 54 31
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
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
26906 110476 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3700 Washington St 1 Back Yard : Yard Tree Private 2   04/16/2015 12:00:00 AM 3 10x10 Permit Number 774729 5997015.1 2115715 37.7891779638687 -122.454181816252 (37.7891779638687, -122.454181816252) 11 6 1 54 31
127638 98241 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 3760 Washington St 1 Front Yard : Yard Tree Private 2   01/10/2012 12:00:00 AM 9   Permit Number 768462 5996814.46778 2115674.04938 37.7890540175629 -122.45487301497 (37.7890540175629, -122.45487301497) 11 6 1 54 31
174679 98491 Significant Tree 6 Robinia pseudoacacia :: Black Locust 286 55X Perine Pl 1 Back Yard : Cutout Tree Private 2         Permit Number 768655 6002130.5 2115544.8 37.7890026421633 -122.436471006098 (37.7890026421633, -122.436471006098) 13 6 1 29490 27
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
61403 111037 Significant Tree 6 Magnolia spp :: Magnolia 224 3991-3997 Washington St 2 Front Yard : Yard Tree Private 2           5995610.3 2115419.4 37.7882856707006 -122.459020806409 (37.7882856707006, -122.459020806409) 11 6 1 54 31
147948 111036 Significant Tree 6 Magnolia spp :: Magnolia 224 3991-3997 Washington St 1 Front Yard : Yard Tree Private 2           5995610.3 2115419.4 37.7882856707006 -122.459020806409 (37.7882856707006, -122.459020806409) 11 6 1 54 31
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
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
11487 260838 Significant Tree 6 Ficus nitida :: Laurel Fig 53 399 Laurel St 1 Side Yard : Cutout Tree Private 2       3x3   5998076 2115238 37.7879290262693 -122.45047684944 (37.7879290262693, -122.45047684944) 11 6 1 54 31
12511 260840 Significant Tree 6 Ficus nitida :: Laurel Fig 53 399 Laurel St 3 Side Yard : Cutout Tree Private 2       3x3   5998076 2115238 37.7879290262693 -122.45047684944 (37.7879290262693, -122.45047684944) 11 6 1 54 31
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
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
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
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
11600 260651 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3751 Sacramento St 2 Front Yard : Cutout Tree Private 2       Width 3ft   5996933 2115011 37.7872402598449 -122.454414995547 (37.7872402598449, -122.454414995547) 11 6 1 54 31
16260 260650 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3751 Sacramento St 1 Front Yard : Cutout Tree Private 2       Width 3ft   5996933 2115011 37.7872402598449 -122.454414995547 (37.7872402598449, -122.454414995547) 11 6 1 54 31
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
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

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