trees

8,298 rows where qLegalStatus_id = 4 sorted by Location 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)
188310 112373 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 15 VANDEWATER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009208 2121303 37.8052128657777 -122.412390870606 (37.8052128657777, -122.412390870606) 3 1 10 308 23
20044 120894 Undocumented 4 Pittosporum spp :: Pittosporum spp 170 735 Marina Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999444 2121468 37.805113148598 -122.446192149022 (37.805113148598, -122.446192149022) 13 9 1 57 17
164298 120893 Undocumented 4 Pittosporum spp :: Pittosporum spp 170 735 Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999444 2121468 37.805113148598 -122.446192149022 (37.805113148598, -122.446192149022) 13 9 1 57 17
52839 115077 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2371X MASON ST 4 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6008645 2121254 37.8050467143555 -122.414335738873 (37.8050467143555, -122.414335738873) 3 1 10 308 23
55711 112719 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 455 BAY ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008645 2121254 37.8050467143555 -122.414335738873 (37.8050467143555, -122.414335738873) 3 1 10 308 23
76774 112721 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 455 BAY ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008645 2121254 37.8050467143555 -122.414335738873 (37.8050467143555, -122.414335738873) 3 1 10 308 23
77690 112720 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 455 BAY ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008645 2121254 37.8050467143555 -122.414335738873 (37.8050467143555, -122.414335738873) 3 1 10 308 23
78728 112718 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 455 BAY ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008645 2121254 37.8050467143555 -122.414335738873 (37.8050467143555, -122.414335738873) 3 1 10 308 23
89130 112722 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 455 BAY ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008645 2121254 37.8050467143555 -122.414335738873 (37.8050467143555, -122.414335738873) 3 1 10 308 23
105781 112723 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 455 BAY ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008645 2121254 37.8050467143555 -122.414335738873 (37.8050467143555, -122.414335738873) 3 1 10 308 23
116392 115074 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2371X MASON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6008645 2121254 37.8050467143555 -122.414335738873 (37.8050467143555, -122.414335738873) 3 1 10 308 23
118895 115075 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2371X MASON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6008645 2121254 37.8050467143555 -122.414335738873 (37.8050467143555, -122.414335738873) 3 1 10 308 23
184869 115076 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2371X MASON ST 3 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6008645 2121254 37.8050467143555 -122.414335738873 (37.8050467143555, -122.414335738873) 3 1 10 308 23
39590 112840 Undocumented 4 Prunus spp :: Flowering Plum 209 390X FRANCISCO ST 3 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6009568 2121208 37.8049722148904 -122.411138326504 (37.8049722148904, -122.411138326504) 3 1 10 308 23
61014 112834 Undocumented 4 Prunus spp :: Flowering Plum 209 390X FRANCISCO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6009568 2121208 37.8049722148904 -122.411138326504 (37.8049722148904, -122.411138326504) 3 1 10 308 23
164925 112833 Undocumented 4 Prunus spp :: Flowering Plum 209 390X FRANCISCO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6009568 2121208 37.8049722148904 -122.411138326504 (37.8049722148904, -122.411138326504) 3 1 10 308 23
6858 261031 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 150 Chestnut St 1 Front Yard : Yard Tree Private 2       3x3   6011107 2121175 37.8049677916951 -122.405810090856 (37.8049677916951, -122.405810090856) 3 1 10 308 23
62295 106457 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1x CHESTNUT ST 14 Sidewalk: Curb side : Cutout Tree Private 2           6011546 2121132 37.8048742648975 -122.404287845465 (37.8048742648975, -122.404287845465) 3 1 10 28860 6
30525 109918 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 114 PFEIFFER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       2x3   6010269.5 2121152.3 37.8048585915517 -122.408706764133 (37.8048585915517, -122.408706764133) 3 1 10 308 23
16200 103940 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2300 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008943.2 2121170.5 37.804834190774 -122.413297871125 (37.804834190774, -122.413297871125) 3 1 10 308 23
10228 142720 Undocumented 4 :: 45 1170 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078) 5 1 10 308 23
46826 110117 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 160x PFEIFFER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010076 2121146 37.8048304537654 -122.409375949631 (37.8048304537654, -122.409375949631) 3 1 10 308 23
169076 110116 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 160x PFEIFFER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010076 2121146 37.8048304537654 -122.409375949631 (37.8048304537654, -122.409375949631) 3 1 10 308 23
9658 114582 Undocumented 4 Myoporum laetum :: Myoporum 62 1501 BEACH ST 4 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6002979 2121285 37.8048119223389 -122.43394578499 (37.8048119223389, -122.43394578499) 13 9 1 57 17
123822 114583 Undocumented 4 Myoporum laetum :: Myoporum 62 1501 BEACH ST 5 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6002979 2121285 37.8048119223389 -122.43394578499 (37.8048119223389, -122.43394578499) 13 9 1 57 17
167881 114580 Undocumented 4 Myoporum laetum :: Myoporum 62 1501 BEACH ST 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002979 2121285 37.8048119223389 -122.43394578499 (37.8048119223389, -122.43394578499) 13 9 1 57 17
77814 114983 Undocumented 4 Tree(s) :: 17 178 CERVANTES BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777197 6001129 2121320 37.8048028635373 -122.440350399876 (37.8048028635373, -122.440350399876) 13 9 1 57 17
87664 110838 Undocumented 4 Auranticarpa rhombifolia :: Queensland Pittosporum 237 3900X DIVISADERO ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000216 2121331 37.8047810408361 -122.443510712402 (37.8047810408361, -122.443510712402) 13 9 1 57 17
124851 98773 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1500X North Point St 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   6003452.6 2121222.8 37.8046680023994 -122.432302398634 (37.8046680023994, -122.432302398634) 13 9 1 57 17
52051 100288 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
73467 100290 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
92764 100287 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
108094 100289 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
159235 100291 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
121500 98779 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3700X Buchanan St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003247.3 2121194.2 37.8045778314901 -122.433010814251 (37.8045778314901, -122.433010814251) 13 9 1 57 17
121030 101519 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 15X Bellair Pl 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769472 6010051.6 2121037.7 37.8045317217453 -122.409452740826 (37.8045317217453, -122.409452740826) 3 1 10 308 23
163520 101520 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 15X Bellair Pl 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769472 6010051.6 2121037.7 37.8045317217453 -122.409452740826 (37.8045317217453, -122.409452740826) 3 1 10 308 23
16204 114507 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 10 LOMBARD ST 2 Back Yard : Cutout Tree Port 6       4x4   6011932 2120995 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468) 3 1 10 28860 6
21026 114508 Undocumented 4 Maytenus boaria :: Mayten 58 10 LOMBARD ST 3 Back Yard : Cutout Tree Port 6       4x4   6011932 2120995 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468) 3 1 10 28860 6
58595 114506 Undocumented 4 Maytenus boaria :: Mayten 58 10 LOMBARD ST 1 Back Yard : Cutout Tree Port 6       4x4   6011932 2120995 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468) 3 1 10 28860 6
30430 102606 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 300 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010368 2120990 37.8044184722981 -122.408354438035 (37.8044184722981, -122.408354438035) 3 1 10 308 23
157696 102605 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 300 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010368 2120990 37.8044184722981 -122.408354438035 (37.8044184722981, -122.408354438035) 3 1 10 308 23
30378 110304 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3735 BUCHANAN ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002991 2121133 37.8043952513031 -122.433893386438 (37.8043952513031, -122.433893386438) 13 9 1 57 17
139972 110303 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3735 BUCHANAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002991 2121133 37.8043952513031 -122.433893386438 (37.8043952513031, -122.433893386438) 13 9 1 57 17
22170 100293 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3725 Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6003057 2121128 37.8043852677309 -122.433664630457 (37.8043852677309, -122.433664630457) 13 9 1 57 17
105159 100295 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3725 Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6003057 2121128 37.8043852677309 -122.433664630457 (37.8043852677309, -122.433664630457) 13 9 1 57 17
81940 142537 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 2100 POWELL ST 6 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6009436.3973 2120993.5505 37.8043760089549 -122.411578593269 (37.8043760089549, -122.411578593269) 3 1 10 308 23
10172 100673 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
23377 100670 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
80554 100671 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
138476 100672 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
181956 102610 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 340 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010192 2120966 37.8043427169928 -122.408961809577 (37.8043427169928, -122.408961809577) 3 1 10 308 23
36751 121063 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
39975 121061 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
62640 121059 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
71643 121056 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
140072 121060 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
143189 121058 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
145327 121057 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
160138 121055 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
188627 121062 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2901x Polk St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005984 2121043 37.8043175249008 -122.423529438764 (37.8043175249008, -122.423529438764) 5 1 1 28858 32
1730 121323 Undocumented 4 Tree(s) :: 17 3699X Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
22280 121321 Undocumented 4 Tree(s) :: 17 3699X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
45816 121324 Undocumented 4 Tree(s) :: 17 3699X Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
76308 121322 Undocumented 4 Tree(s) :: 17 3699X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
188825 102612 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 376 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010060 2120948 37.8042858984606 -122.409417337419 (37.8042858984606, -122.409417337419) 3 1 10 308 23
70734 100297 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3725 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6003062 2121090 37.8042812134182 -122.43364461008 (37.8042812134182, -122.43364461008) 13 9 1 57 17
92515 100299 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3725 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6003062 2121090 37.8042812134182 -122.43364461008 (37.8042812134182, -122.43364461008) 13 9 1 57 17
186125 98780 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3601X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003551.8 2121073.9 37.8042647862028 -122.431948468614 (37.8042647862028, -122.431948468614) 13 9 1 57 17
160820 256315 Undocumented 4 Cupaniopsis anacardioides :: Carrotwood 195 15 North View Ct 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006234 2121009 37.8042382772915 -122.422661874451 (37.8042382772915, -122.422661874451) 5 9 1 28858 32
173523 122851 Undocumented 4 Tree(s) :: 17 742 Francisco St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6007760 2120975 37.8042308974981 -122.417378607523 (37.8042308974981, -122.417378607523) 5 1 1 308 32
63862 102614 Undocumented 4 Ulmus spp :: Elm Spp 98 394 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009930 2120930 37.8042291902539 -122.40986594338 (37.8042291902539, -122.40986594338) 3 1 10 308 23
36178 108990 Undocumented 4 :: 45 2073-2099X Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501) 13 9 1 57 17
88682 108989 Undocumented 4 :: 45 2073-2099X Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501) 13 9 1 57 17
113379 108992 Undocumented 4 :: 45 2073-2099X Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501) 13 9 1 57 17
137408 108988 Undocumented 4 :: 45 2073-2099X Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501) 13 9 1 57 17
180843 108993 Undocumented 4 :: 45 2073-2099X Jefferson St 6 Sidewalk: Curb side : Cutout Tree Private 2           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501) 13 9 1 57 17
4869 102616 Undocumented 4 Ulmus spp :: Elm Spp 98 2000X Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6009928.4 2120915.8 37.8041901109125 -122.409870477339 (37.8041901109125, -122.409870477339) 3 1 10 308 23
189477 102617 Undocumented 4 Ulmus spp :: Elm Spp 98 2000X Stockton St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6009928.4 2120915.8 37.8041901109125 -122.409870477339 (37.8041901109125, -122.409870477339) 3 1 10 308 23
164283 111289 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 306 AVILA ST 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6000943 2121065 37.804092109664 -122.440975765753 (37.804092109664, -122.440975765753) 13 9 1 57 17
100355 103264 Undocumented 4 Maytenus boaria :: Mayten 58 1660 NORTH POINT ST   Sidewalk: Curb side : Cutout Tree Private 2       3x5   6002814 2121000 37.8040200224121 -122.434496394017 (37.8040200224121, -122.434496394017) 13 9 1 57 17
105319 131987 Undocumented 4 Olea europaea :: Olive Tree 9 2445 Hyde St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006988.11325 2120764.08874 37.8036083299324 -122.420034810474 (37.8036083299324, -122.420034810474) 5 1 1 28858 32
35781 256056 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 418 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010297 2120665 37.8035221265997 -122.408577200527 (37.8035221265997, -122.408577200527) 3 1 10 308 23
82064 117188 Undocumented 4 Ficus nitida :: Laurel Fig 53 200x GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       9x6   6011596 2120619 37.8034684863456 -122.404078688914 (37.8034684863456, -122.404078688914) 3 1 10 28860 6
84659 117187 Undocumented 4 Ficus nitida :: Laurel Fig 53 200x GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       9x6   6011596 2120619 37.8034684863456 -122.404078688914 (37.8034684863456, -122.404078688914) 3 1 10 28860 6
119367 104714 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1043 Francisco St 2 Sidewalk: Property side : Yard Tree Private 2           6006311.1 2120706.2 37.8034112154379 -122.422373535783 (37.8034112154379, -122.422373535783) 5 9 1 28858 32
161844 104713 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1043 Francisco St 1 Sidewalk: Property side : Yard Tree Private 2           6006311.1 2120706.2 37.8034112154379 -122.422373535783 (37.8034112154379, -122.422373535783) 5 9 1 28858 32
58800 108938 Undocumented 4 Ligustrum japonicum :: Japanese Privet 232 431 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6010275.9 2120590.4 37.8033161117204 -122.408644952554 (37.8033161117204, -122.408644952554) 3 1 10 308 23
4710 143042 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 443 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6010246.7521 2120590.0026 37.8033133880365 -122.408745792286 (37.8033133880365, -122.408745792286) 3 1 10 308 23
65947 103484 Undocumented 4 Ficus nitida :: Laurel Fig 53 2375X Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 9x6   6007909 2120582.3 37.8031610244278 -122.416835141288 (37.8031610244278, -122.416835141288) 5 1 1 308 32
100883 103485 Undocumented 4 Ficus nitida :: Laurel Fig 53 2375X Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 9x9   6007909 2120582.3 37.8031610244278 -122.416835141288 (37.8031610244278, -122.416835141288) 5 1 1 308 32
125350 113235 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2001 POWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009409 2120545 37.8031428642343 -122.411641692368 (37.8031428642343, -122.411641692368) 3 1 10 308 23
134443 113236 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2001 POWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009409 2120545 37.8031428642343 -122.411641692368 (37.8031428642343, -122.411641692368) 3 1 10 308 23
85986 134827 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 991 Chestnut St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007349.29025 2120528.21446 37.8029810213102 -122.418768198988 (37.8029810213102, -122.418768198988) 5 1 1 28858 32
85334 256616 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1541X Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011315 2120446 37.8029777664724 -122.405038917948 (37.8029777664724, -122.405038917948) 3 1 10 308 23
28155 106768 Undocumented 4 Olea europaea :: Olive Tree 9 226 Mallorca Way 1 Sidewalk: Curb side : Cutout Tree Private 2       8x9   6001629.46862 2120633.92047 37.8029475537601 -122.438569291156 (37.8029475537601, -122.438569291156) 13 9 1 57 17
145067 143057 Undocumented 4 Melaleuca spp :: Melaleuca spp 117 1851 STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6009959.6794 2120436.8776 37.8028768616805 -122.409728406913 (37.8028768616805, -122.409728406913) 3 1 10 308 23
11284 117186 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
52074 117185 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
182781 117184 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23

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