trees

416 rows where Police Districts = 8 and qLegalStatus_id = 6 sorted by Zip Codes

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
1773 116537 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 6 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
9908 215094 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 218 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994821.63014 2087784.20309 37.7123610457095 -122.459746958272 (37.7123610457095, -122.459746958272) 9 8 6 28861 24
10229 264894 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 56 Keystone Way 1 Back Yard : Yard Tree Private 2       3x3   5994156 2093086 37.7268802074189 -122.462431871086 (37.7268802074189, -122.462431871086) 9 8 4 28861 40
15657 259657 Significant Tree 6 Tree(s) :: 17 132 Sagamore St 1 Front Yard : Yard Tree Private 2       3x3   5995545 2087474 37.7115508726991 -122.457224363425 (37.7115508726991, -122.457224363425) 9 8 6 28861 24
48765 98082 Significant Tree 6 Pinus Spp :: Pine Spp 100 525 Grafton Ave 1 Sidewalk: Property side : Cutout Tree Private 2           5995193.7 2090526.9 37.7199132334677 -122.45865940878 (37.7199132334677, -122.45865940878) 9 8 6 28861 24
81780 206842 Significant Tree 6 Tree(s) :: 17 218 Sadowa St 3 Sidewalk: Property side : Cutout Tree Private 2   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994803.1874 2087784.4983 37.712360795684 -122.45981072288 (37.712360795684, -122.45981072288) 9 8 6 28861 24
84393 116534 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 3 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
105492 116536 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 5 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
124365 116951 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 238 299 Tara St 1 Front Yard : Yard Tree Private 2           5997754 2090179.6 37.7191064490611 -122.449784366221 (37.7191064490611, -122.449784366221) 9 8 6 28861 24
125248 106038 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 230 Lakeview Ave   Front Yard : Yard Tree Private 2         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743) 9 8 6 28861 24
137083 106962 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 218 SADOWA ST 3 Sidewalk: Property side : Cutout Tree Private 2     22     5994814 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106) 9 8 6 28861 24
143694 116535 Significant Tree 6 Tree(s) :: 17 598x MOUNT VERNON AVE 4 Back Yard : Yard Tree Private 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
177 253253 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
523 92314 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2783 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985837.7861 2096464.2212 37.7356733962807 -122.491435886509 (37.7356733962807, -122.491435886509) 1 8 3 29491 35
1697 92318 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2787 34th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985842.0312 2096446.1793 37.7356241060746 -122.49141988223 (37.7356241060746, -122.49141988223) 1 8 3 29491 35
5246 262331 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 2140 Wawona St 1 Back Yard : Cutout Tree Private 2       3x3   5986390 2097232 37.7378137677629 -122.489583137449 (37.7378137677629, -122.489583137449) 1 8 3 29491 35
5577 92312 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2711 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985822.132 2096946.3119 37.7369961745626 -122.49152548244 (37.7369961745626, -122.49152548244) 1 8 3 29491 35
6296 260461 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
6931 92315 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2783 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985839.9086 2096474.3035 37.7357012036342 -122.491429290175 (37.7357012036342, -122.491429290175) 1 8 3 29491 35
11618 92317 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2787 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985840.9699 2096433.9745 37.7355905329114 -122.491422653463 (37.7355905329114, -122.491422653463) 1 8 3 29491 35
13252 92316 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2787 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985840.4393 2096424.4229 37.7355642757438 -122.49142378511 (37.7355642757438, -122.49142378511) 1 8 3 29491 35
16256 260911 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 15th Ave 1 Front Yard : Yard Tree Private 2       Width 3ft   5991575 2101572 37.7500316406912 -122.471972478281 (37.7500316406912, -122.471972478281) 1 8 4 29491 12
19246 253252 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 3 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
20150 256573 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 145 Castenada Ave 1 Front Yard : Cutout Tree Private 2       3x3   5994569 2100949 37.74849383418 -122.461573977381 (37.74849383418, -122.461573977381) 1 8 4 29491 40
20972 254094 Significant Tree 6 Pinus radiata :: Monterey Pine 15 320 Magellan Ave 1 Front Yard : Yard Tree Private 2       10x10 Permit Number 781012 5994209 2099943 37.7457108840866 -122.462745872627 (37.7457108840866, -122.462745872627) 1 8 4 29491 40
21303 115100 Significant Tree 6 Tree(s) :: 17 710 PACHECO ST 1 Front Yard : Cutout Tree Private 2   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777305 5992727 2102215 37.7518637464828 -122.468035600741 (37.7518637464828, -122.468035600741) 1 8 4 29491 12
22895 256572 Significant Tree 6 Ilex aquifolium :: European Holly 390 175 Castenada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994536 2100823 37.748145970457 -122.461678955671 (37.748145970457, -122.461678955671) 1 8 4 29491 40
27831 98834 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 333 Pacheco St 3 Sidewalk: Curb side : Cutout Tree Private 2           5994230.9 2100817.4 37.748113026994 -122.462733567037 (37.748113026994, -122.462733567037) 1 8 4 29491 40
35440 97955 Significant Tree 6 Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar 438 2 Mendosa Ave 1 Front Yard : Yard Tree Private 2   12/05/2011 12:00:00 AM     Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
40036 104493 Significant Tree 6 Acer circinatum :: Vine Maple 452 171 SAN MARCOS AVE 1 Front Yard : Yard Tree Private 2         Permit Number 770388 5993514 2100282 37.7466016393389 -122.465173679454 (37.7466016393389, -122.465173679454) 1 8 4 29491 40
42536 97945 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2 Mendosa Ave 1 Front Yard : Yard Tree Private 2         Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
44150 105208 Significant Tree 6 Myoporum laetum :: Myoporum 62 2694 47TH AVE   Front Yard : Yard Tree Private 2           5981878.3 2096771.8 37.7362857499502 -122.505147911282 (37.7362857499502, -122.505147911282) 1 8 3 29491 35
44754 253482 Significant Tree 6 Juniperus chinensis :: Juniper 113 2179 41st Ave 1 Front Yard : Yard Tree Private 2       3x5   5983532 2100331 37.7461555051432 -122.499693454208 (37.7461555051432, -122.499693454208) 1 8 3 29491 35
45348 93222 Significant Tree 6 Tree(s) :: 17 85 Santa Rita Ave 2 Front Yard : Yard Tree Private 2   02/26/2010 12:00:00 AM     Permit Number 53213 5993788 2100441 37.7470540096767 -122.464237765204 (37.7470540096767, -122.464237765204) 1 8 4 29491 40
45577 92320 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 2733 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM 3 3x3   5984522 2096783 37.7364716996862 -122.496008508371 (37.7364716996862, -122.496008508371) 1 8 3 29491 35
48743 253145 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 801X Santiago St 1 Side Yard : Yard Tree Private 2           5990274 2099728 37.7448931297685 -122.476336677657 (37.7448931297685, -122.476336677657) 1 8 3 29491 35
52128 112811 Significant Tree 6 Tree(s) :: 17 2023 43rd Ave 1 Front Yard : Yard Tree Private 2           5982877.4 2101339.2 37.7488853101021 -122.502031530859 (37.7488853101021, -122.502031530859) 1 8 3 29491 35
52558 255280 Significant Tree 6 Olea europaea :: Olive Tree 9 320 Magellan Ave 1 Front Yard : Yard Tree Private 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
55399 92310 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2591 26th Ave 1 Sidewalk: Property side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM   3x3   5988279 2097698.2 37.7392039339278 -122.483086187221 (37.7392039339278, -122.483086187221) 1 8 3 29491 35
59764 105504 Significant Tree 6 Pinus radiata :: Monterey Pine 15 39 MAGELLAN AVE 1 Front Yard : Yard Tree Private 2     18     5994694.1 2101166.3 37.7490976851152 -122.461157135733 (37.7490976851152, -122.461157135733) 1 8 4 29491 40
66315 109521 Significant Tree 6 Tree(s) :: 17 1308 Ulloa St 1 Front Yard : Yard Tree Private 2       3x3   5991965.5 2098469.9 37.7415366593774 -122.470396231887 (37.7415366593774, -122.470396231887) 1 8 4 29491 40
66926 253251 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 2 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
67970 93221 Significant Tree 6 Tree(s) :: 17 85 Santa Rita Ave 1 Front Yard : Yard Tree Private 2   02/26/2010 12:00:00 AM     Permit Number 53213 5993788 2100441 37.7470540096767 -122.464237765204 (37.7470540096767, -122.464237765204) 1 8 4 29491 40
69183 104494 Significant Tree 6 Acer circinatum :: Vine Maple 452 171 SAN MARCOS AVE 2 Front Yard : Yard Tree Private 2         Permit Number 770388 5993514 2100282 37.7466016393389 -122.465173679454 (37.7466016393389, -122.465173679454) 1 8 4 29491 40
76823 255913 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 121 San Marcos Ave 1 Side Yard : Yard Tree Private 2       10x10   5993694 2100263 37.7465598483618 -122.464549884035 (37.7465598483618, -122.464549884035) 1 8 4 29491 40
84029 102075 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 273 Magellan Ave 5 Front Yard : Yard Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
85339 115176 Significant Tree 6 Tree(s) :: 17 460 Pacheco St 1 Front Yard : Yard Tree Private 2   01/14/2016 12:00:00 AM   10x10 Permit Number 775764 5993727.4 2101897.6 37.7510499693469 -122.464553061226 (37.7510499693469, -122.464553061226) 1 8 4 29491 12
94784 253250 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99X Lopez Ave 1 Front Yard : Yard Tree Private 2   01/09/2018 12:00:00 AM 3 10x10 Permit Number 780226 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
95583 102077 Significant Tree 6 Ulmus glabra :: Scotch Elm 531 273 Magellan Ave 7 Front Yard : Yard Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
102553 253254 Significant Tree 6 Pinus radiata :: Monterey Pine 15 270 Castenada Ave 1 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
106522 102073 Significant Tree 6 Pittosporum eugenioides :: Tarata 138 273 Magellan Ave 3 Front Yard : Yard Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
106870 117252 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2500x 34TH AVE 2 Side Yard : Yard Tree SFUSD 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
107089 255281 Significant Tree 6 Olea europaea :: Olive Tree 9 320 Magellan Ave 2 Front Yard : Yard Tree Private 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
107229 255805 Significant Tree 6 Ailanthus altissima :: Tree Of Heaven 333 2 Sola Ave 1 Front Yard : Yard Tree Private 2       10x10   5994994 2100719 37.7478867659483 -122.460087684856 (37.7478867659483, -122.460087684856) 1 8 4 29491 40
107818 98757 Significant Tree 6 Pinus radiata :: Monterey Pine 15 340 Castenada Ave 1 Front Yard : Yard Tree Private 2           5993579.1 2100062.8 37.7460035255592 -122.464932655613 (37.7460035255592, -122.464932655613) 1 8 4 29491 40
110154 102074 Significant Tree 6 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 273 Magellan Ave 4 Front Yard : Yard Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
111294 255282 Significant Tree 6 Olea europaea :: Olive Tree 9 320 Magellan Ave 3 Front Yard : Yard Tree Private 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
112272 105540 Significant Tree 6 Myoporum laetum :: Myoporum 62 2694 47TH AVE 1 Front Yard : Yard Tree Private 2     12     5981878.3 2096771.8 37.7362857499502 -122.505147911282 (37.7362857499502, -122.505147911282) 1 8 3 29491 35
114772 92311 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2211 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM 3 3x3   5986022.3 2100155.2 37.7458186185696 -122.491069496457 (37.7458186185696, -122.491069496457) 1 8 3 29491 35
122278 106109 Significant Tree 6 Magnolia champaca :: Champa 141 135 MENDOSA AVE 2 Sidewalk: Property side : Yard Tree Private 2   04/23/2014 12:00:00 AM     Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
133744 117251 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2500x 34TH AVE 1 Side Yard : Yard Tree SFUSD 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
144280 253255 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 270 Castenada Ave 2 Front Yard : Yard Tree Private 2   01/09/2018 12:00:00 AM 3 10x10 Permit Number 780226 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
145907 187657 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2072 15th Ave 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5991666 2101424 37.7496305363998 -122.47164701446 (37.7496305363998, -122.47164701446) 1 8 4 29491 12
156684 105850 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 44 MENDOSA AVE 1 Sidewalk: Property side : Yard Tree Private 2     100 6x15   5993395.1 2101192.7 37.7490953323683 -122.465650972372 (37.7490953323683, -122.465650972372) 1 8 4 29491 40
159746 253286 Significant Tree 6 Tree(s) :: 17 40 Mendosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2017 12:00:00 AM 3 6x10 Permit Number 780599 5993445 2101187 37.7490825597194 -122.465478005037 (37.7490825597194, -122.465478005037) 1 8 4 29491 40
160882 113234 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2023 43RD AVE 1 Front Yard : Yard Tree Private 2     12 3x3   5982877 2101339 37.7488847374588 -122.502032899239 (37.7488847374588, -122.502032899239) 1 8 3 29491 35
165013 85367 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1990 09th Ave 1 Front Yard : Cutout Tree Private 2   08/17/2007 12:00:00 AM     Permit Number 49643 5993523.3 2101996.8 37.7513105791605 -122.465266058842 (37.7513105791605, -122.465266058842) 1 8 4 29491 12
168382 255283 Significant Tree 6 Olea europaea :: Olive Tree 9 320 Magellan Ave 4 Front Yard : Yard Tree Private 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
176886 117253 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2500x 34TH AVE 3 Side Yard : Yard Tree SFUSD 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
187309 106198 Significant Tree 6 Juniperus scopulorum 'Pat :: Juniper Tree 'Pathfinder' 570 2101 42ND AVE 1 Front Yard : Yard Tree Private 2     18     5983206.1 2100796.8 37.7474153345648 -122.500854798087 (37.7474153345648, -122.500854798087) 1 8 3 29491 35
188800 106107 Significant Tree 6 Magnolia champaca :: Champa 141 135 MENDOSA AVE 1 Sidewalk: Property side : Yard Tree Private 2   04/23/2014 12:00:00 AM     Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
194359 262298 Significant Tree 6 Tree(s) :: 17 1000X Mandalay Ln 1 Side Yard : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 10x10 Permit Number 787936 5991616 2101838 37.7507643799851 -122.471850083311 (37.7507643799851, -122.471850083311) 1 8 4 29491 12
194467 265133 Significant Tree 6 Cordyline australis :: Dracena Palm 64 2166 41st Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/11/2021 12:00:00 AM 3 3x3 Permit Number 783123 5983589.67085 2100408.11005 37.7463706120083 -122.499499736486 (37.7463706120083, -122.499499736486) 1 8 3 29491 35
63 264975 Significant Tree 6 Pinus radiata :: Monterey Pine 15 445 Ortega St 1 Front Yard : Yard Tree Private 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
68 264976 Significant Tree 6 Pinus radiata :: Monterey Pine 15 445 Ortega St 2 Front Yard : Yard Tree Private 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
4096 261159 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 3 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
6747 261157 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 1 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
7291 105130 Significant Tree 6 Tree(s) :: 17 4045 MORAGA ST   Sidewalk: Property side : Yard Tree Private 2           5981665.2 2103465.9 37.7546533409301 -122.506380933635 (37.7546533409301, -122.506380933635) 1 8 3 56 35
8974 260925 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 1900 Noriega St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5987961.4849 2103092.5821 37.7539969916819 -122.484579575666 (37.7539969916819, -122.484579575666) 1 8 3 56 35
9381 261160 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 4 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
10025 264885 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1279 44th Ave 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 787806 5982392 2106415 37.7627934961857 -122.504085938563 (37.7627934961857, -122.504085938563) 1 8 3 56 35
11981 261158 Significant Tree 6 Juniperus californica :: California juniper 295 1100X Moraga St 2 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
13325 259319 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1746 20th Ave 1 Front Yard : Yard Tree Private 2       3x3   5990028 2103516 37.7552797120334 -122.477464095722 (37.7552797120334, -122.477464095722) 1 8 3 56 35
14866 259322 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1721 19th Ave 1 Front Yard : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783194 5990247 2103661 37.7556905489205 -122.476717329726 (37.7556905489205, -122.476717329726) 1 8 3 56 35
14911 264785 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1738 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       10x10   5991929 2103547 37.7554749546691 -122.470892190435 (37.7554749546691, -122.470892190435) 1 8 4 56 12
16055 260578 Significant Tree 6 Tree(s) :: 17 1879 Funston Ave 1 Sidewalk: Property side : Cutout Tree Private 2   05/22/2020 12:00:00 AM 3 Width 3ft Permit Number 784834 5992075.37659 2102679.56742 37.7531016753032 -122.470322812874 (37.7531016753032, -122.470322812874) 1 8 4 56 12
24761 101258 Significant Tree 6 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1049 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992548 2106581 37.7638413023971 -122.468972303767 (37.7638413023971, -122.468972303767) 1 8 11 56 12
31720 254395 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1286 26th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 781556 5988061 2106558 37.7635178832746 -122.484489596097 (37.7635178832746, -122.484489596097) 1 8 3 56 35
43088 112378 Significant Tree 6 :: 45 1850 19TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5990394 2102783 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826) 1 8 4 56 12
43207 111069 Significant Tree 6 Ilex spp :: Holly Species 81 1836 08TH AVE 3 Front Yard : Cutout Tree Private 2       3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
50301 254481 Significant Tree 6 Juniperus chinensis :: Juniper 113 1274 11th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5992738 2106820 37.7645085090972 -122.468332545675 (37.7645085090972, -122.468332545675) 11 8 11 56 12
63888 254137 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1619 47th Ave 1 Side Yard : Yard Tree Private 2       6x6   5981543 2104041 37.756225206981 -122.506846181577 (37.756225206981, -122.506846181577) 1 8 3 56 35
75557 254361 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1749 09th Ave 1 Front Yard : Yard Tree Private 2       6x6   5993372 2103579 37.7556461665355 -122.465904219148 (37.7556461665355, -122.465904219148) 1 8 4 56 12
75962 111070 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 1836 08TH AVE 2 Front Yard : Cutout Tree Private 2     2 3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
83312 254136 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1623 47th Ave 1 Front Yard : Yard Tree Private 2       10x6 Permit Number 781075 5981544 2104016 37.7561566229771 -122.506840869024 (37.7561566229771, -122.506840869024) 1 8 3 56 35
95967 254201 Significant Tree 6 Tree(s) :: 17 55X Aerial Way 1 Side Yard : Yard Tree Private 2       10x10 Permit Number 781191 5992360 2102538 37.7527294198072 -122.469328234463 (37.7527294198072, -122.469328234463) 1 8 4 56 12
97021 105907 Significant Tree 6 Pinus Spp :: Pine Spp 100 1837 30TH AVE 1 Front Yard : Yard Tree Private 2     6     5986904 2102674 37.7527860393128 -122.488205804709 (37.7527860393128, -122.488205804709) 1 8 3 56 35
97746 111068 Significant Tree 6 Ilex spp :: Holly Species 81 1836 08TH AVE 1 Front Yard : Cutout Tree Private 2       3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
99362 99847 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850@14th Ave Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2           5991942 2105939 37.7620435090796 -122.471021481615 (37.7620435090796, -122.471021481615) 1 8 11 56 12
101005 104736 Significant Tree 6 Lagunaria patersonii :: Primrose Tree 6 1499X 44th Ave 1 Front Yard : Yard Tree Private 2         Permit Number 770763 5982473.05016 2105245.16297 37.7595862228156 -122.503718978789 (37.7595862228156, -122.503718978789) 1 8 3 56 35

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