trees

194,517 rows sorted by Longitude 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)
27231 118929 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 875 La Playa 5 Sidewalk: Property side : Yard Tree Private 2     5 Width 4ft   5980750.23602 2109645.2788 37.7715662158284 -122.510004109936 (37.7715662158284, -122.510004109936) 11 6 2 55 26
56005 119183 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 770 La Playa 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/13/2018 08:27:00 AM 3 Width 3ft   5980769.13154 2110513.52409 37.7739512764073 -122.510003263739 (37.7739512764073, -122.510003263739) 11 6 2 55 26
64880 90727 DPW Maintained 1 Yucca elephantipes :: Giant Yucca 268 4799X Cabrillo St 4 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 04/07/2008 12:00:00 AM 3 3x3   5980764.077178 2110242.237714 37.773206105836 -122.510000589277 (37.773206105836, -122.510000589277) 11 6 2 55 26
79929 90726 DPW Maintained 1 Quercus frainetto 'Trump' :: Hungarian Oak 406 4799X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 04/14/2008 12:00:00 AM 3 3x3   5980764.077178 2110242.237714 37.773206105836 -122.510000589277 (37.773206105836, -122.510000589277) 11 6 2 55 26
112549 90724 DPW Maintained 1 Yucca elephantipes :: Giant Yucca 268 4799X Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 04/07/2008 12:00:00 AM 3 3x3   5980764.077178 2110242.237714 37.773206105836 -122.510000589277 (37.773206105836, -122.510000589277) 11 6 2 55 26
150599 118930 DPW Maintained 1 Juniperus chinensis :: Juniper 113 875 La Playa 6 Sidewalk: Property side : Yard Tree Private 2     5 Width 4ft   5980751.65283 2109636.5801 37.7715424153171 -122.509998562861 (37.7715424153171, -122.509998562861) 11 6 2 55 26
163057 118681 DPW Maintained 1 Myoporum laetum :: Myoporum 62 4749 Balboa St 5 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   5980787.41659 2110915.95941 37.7750573235101 -122.509969916482 (37.7750573235101, -122.509969916482) 11 6 2 55 26
115445 119185 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 780 La Playa 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 Width 4ft   5980776.33193 2110309.65746 37.7733919433929 -122.50996320874 (37.7733919433929, -122.50996320874) 11 6 2 55 26
138881 119184 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 780 La Playa 2 Sidewalk: Curb side : Cutout Tree DPW 1     10 Width 4ft   5980778.38631 2110329.2751 37.773445928821 -122.509957560132 (37.773445928821, -122.509957560132) 11 6 2 55 26
109830 119187 DPW Maintained 1 Myoporum laetum :: Myoporum 62 850 La Playa 13 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft Permit Number 782354 5980787.15849 2110067.27485 37.7727270706244 -122.509907749465 (37.7727270706244, -122.509907749465) 11 6 2 55 26
40203 119188 DPW Maintained 1 Myoporum laetum :: Myoporum 62 850 La Playa 12 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5980787.75932 2110046.86087 37.7726710552755 -122.509904154395 (37.7726710552755, -122.509904154395) 11 6 2 55 26
190484 119189 DPW Maintained 1 Myoporum laetum :: Myoporum 62 850 La Playa 11 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft Permit Number 782354 5980788.77167 2110011.06332 37.7725728254374 -122.509897992863 (37.7725728254374, -122.509897992863) 11 6 2 55 26
112288 119190 DPW Maintained 1 Myoporum laetum :: Myoporum 62 850 La Playa 10 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5980791.59993 2109976.85312 37.7724790610914 -122.50988566799 (37.7724790610914, -122.50988566799) 11 6 2 55 26
119105 119191 DPW Maintained 1 Myoporum laetum :: Myoporum 62 850 La Playa 9 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft Permit Number 782354 5980791.6714 2109938.71016 37.772374335952 -122.509882586769 (37.772374335952, -122.509882586769) 11 6 2 55 26
65098 119192 DPW Maintained 1 Myoporum laetum :: Myoporum 62 850 La Playa 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5980793.72014 2109909.69069 37.7722947778463 -122.509873343995 (37.7722947778463, -122.509873343995) 11 6 2 55 26
22978 119193 DPW Maintained 1 Myoporum laetum :: Myoporum 62 850 La Playa 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft Permit Number 782354 5980794.10985 2109865.62761 37.7721738165622 -122.509868722143 (37.7721738165622, -122.509868722143) 11 6 2 55 26
171272 118680 DPW Maintained 1 Myoporum laetum :: Myoporum 62 4749 Balboa St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5980818.27434 2110917.35455 37.7750629740894 -122.509863278373 (37.7750629740894, -122.509863278373) 11 6 2 55 26
113108 90287 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4740 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/2008 12:00:00 AM 3 3x3   5980821.75322 2110975.07524 37.775221663232 -122.509855533094 (37.775221663232, -122.509855533094) 11 6 2 55 26
88611 119239 DPW Maintained 1 Myoporum laetum :: Myoporum 62 4750 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   5980810.57035 2110294.51336 37.773352381464 -122.509843650169 (37.773352381464, -122.509843650169) 11 6 2 55 26
149767 119195 DPW Maintained 1 Myoporum laetum :: Myoporum 62 850 La Playa 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft Permit Number 782354 5980799.52647 2109772.22754 37.7719176868632 -122.509843046522 (37.7719176868632, -122.509843046522) 11 6 2 55 26
125731 119197 DPW Maintained 1 Myoporum laetum :: Myoporum 62 850 La Playa 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft Permit Number 782354 5980800.71853 2109703.31069 37.7717285317348 -122.50983380285 (37.7717285317348, -122.50983380285) 11 6 2 55 26
69621 119198 DPW Maintained 1 Myoporum laetum :: Myoporum 62 850 La Playa 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft Permit Number 782354 5980803.32606 2109672.6528 37.7716445079509 -122.509822505626 (37.7716445079509, -122.509822505626) 11 6 2 55 26
73729 119165 DPW Maintained 1 Myoporum laetum :: Myoporum 62 850 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft Permit Number 782354 5980803.057 2109634.63853 37.7715401160565 -122.509820611981 (37.7715401160565, -122.509820611981) 11 6 2 55 26
161441 119186 DPW Maintained 1 Myoporum laetum :: Myoporum 62 850 La Playa 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft Permit Number 782354 5980814 2109919 37.7723215345009 -122.509803887053 (37.7723215345009, -122.509803887053) 11 6 2 55 26
2854 255187 Section 806 (d) 5 Callistemon viminalis :: Weeping Bottlebrush 60 4740 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/27/2018 12:00:00 AM 3 3x3 Permit Number 780757 5980843 2110991 37.7752666409579 -122.509783220192 (37.7752666409579, -122.509783220192) 11 6 2 55 26
179023 118679 DPW Maintained 1 Myoporum laetum :: Myoporum 62 4749 Balboa St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5980848.5753 2110916.87516 37.7750634448303 -122.509758426999 (37.7750634448303, -122.509758426999) 11 6 2 55 26
99647 90723 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4750X Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2008 12:00:00 AM 3 3x3   5980837.13634 2110295.92473 37.7733578233946 -122.509751861232 (37.7733578233946, -122.509751861232) 11 6 2 55 26
70253 118678 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 4749 Balboa St 2 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   5980862.87698 2110909.19366 37.7750431971102 -122.50970838455 (37.7750431971102, -122.50970838455) 11 6 2 55 26
98287 118677 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 4749 Balboa St 1 Sidewalk: Curb side : Pot Tree Private 2     8 Width 3ft   5980875.63021 2110909.60557 37.7750450801709 -122.509664299747 (37.7750450801709, -122.509664299747) 11 6 2 55 26
104894 90949 DPW Maintained 1 Dracaena draco :: Dragon Tree 156 4722 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/11/2008 12:00:00 AM 3 3x3   5980898.40146 2110978.10011 37.7752344887776 -122.509590618998 (37.7752344887776, -122.509590618998) 11 6 2 55 26
22675 59691 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 185 Seal Rock Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   04/30/1981 12:00:00 AM 38 4x3 Permit Number 19118 5980952.62035506 2112920.61231564 37.7805712485973 -122.509547375915 (37.7805712485973, -122.509547375915) 11 6 2 55 26
61294 90296 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4725 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/2008 12:00:00 AM 3 3x3   5980914.47368 2110921.9769 37.7750813387497 -122.509530853193 (37.7750813387497, -122.509530853193) 11 6 2 55 26
39533 183666 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1301 Lower Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5980807.2532 2105649.1672 37.7605974181757 -122.509510037409 (37.7605974181757, -122.509510037409) 1 8 3 29491 35
35726 183667 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1301 Lower Great Hwy 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5980810.0798 2105619.8412 37.7605170641014 -122.509498083519 (37.7605170641014, -122.509498083519) 1 8 3 29491 35
140954 183668 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1301 Lower Great Hwy 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5980813.613 2105594.4018 37.7604474231742 -122.509483974564 (37.7604474231742, -122.509483974564) 1 8 3 29491 35
73513 90955 DPW Maintained 1 Dracaena draco :: Dragon Tree 156 4715 Balboa St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2008 12:00:00 AM 3 3x3   5980930.33673 2110922.83667 37.7750846348075 -122.509476044277 (37.7750846348075, -122.509476044277) 11 6 2 55 26
21280 184330 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1301 Lower Great Hwy 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5980817.5309 2105553.3064 37.7603348180604 -122.509467372357 (37.7603348180604, -122.509467372357) 1 8 3 29491 35
30938 186621 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1301 Lower Great Hwy 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5980819.2183 2105525.4648 37.7602584725403 -122.50945946869 (37.7602584725403, -122.50945946869) 1 8 3 29491 35
144628 58178 Permitted Site 7 Tree(s) :: 17 1225 La Playa St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/10/1978 12:00:00 AM     Permit Number 17165 5980845.45874958 2106718.95428183 37.7635369974083 -122.509457359298 (37.7635369974083, -122.509457359298) 1 8 3 56 35
174792 186622 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1301 Lower Great Hwy 6 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5980820.062 2105514.4969 37.7602284075931 -122.509455736178 (37.7602284075931, -122.509455736178) 1 8 3 29491 35
122073 186623 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1301 Lower Great Hwy 7 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5980820.9057 2105500.9979 37.7601913929735 -122.509451815682 (37.7601913929735, -122.509451815682) 1 8 3 29491 35
38251 250986 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 185 Seal Rock Dr 1 : Tree Private 2     16 Width 3ft   5980980.82201 2112923.78682 37.7805816277787 -122.50945005058 (37.7805816277787, -122.50945005058) 11 6 2 55 26
20492 108957 DPW Maintained 1 Tree(s) :: 17 1401X GREAT HWY 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5   02/10/2015 12:00:00 AM 3 4x4 Permit Number 774900 5980823 2105507 37.7602079965022 -122.509445018403 (37.7602079965022, -122.509445018403) 1 8 3 29491 35
58107 108955 DPW Maintained 1 Tree(s) :: 17 1401X GREAT HWY 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5   02/10/2015 12:00:00 AM 3 4x4 Permit Number 774900 5980823 2105507 37.7602079965022 -122.509445018403 (37.7602079965022, -122.509445018403) 1 8 3 29491 35
91190 108956 DPW Maintained 1 Tree(s) :: 17 1401X GREAT HWY 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5   02/10/2015 12:00:00 AM 3 4x4 Permit Number 774900 5980823 2105507 37.7602079965022 -122.509445018403 (37.7602079965022, -122.509445018403) 1 8 3 29491 35
94765 108953 DPW Maintained 1 Tree(s) :: 17 1401X GREAT HWY 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5   02/10/2015 12:00:00 AM 3 4x4 Permit Number 774900 5980823 2105507 37.7602079965022 -122.509445018403 (37.7602079965022, -122.509445018403) 1 8 3 29491 35
129946 108954 DPW Maintained 1 Tree(s) :: 17 1401X GREAT HWY 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   02/10/2015 12:00:00 AM 3 4x4 Permit Number 774900 5980823 2105507 37.7602079965022 -122.509445018403 (37.7602079965022, -122.509445018403) 1 8 3 29491 35
54754 186624 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1301 Lower Great Hwy 8 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5980825.1241 2105476.531 37.7601244626444 -122.509435409323 (37.7601244626444, -122.509435409323) 1 8 3 29491 35
130791 186487 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1301 Lower Great Hwy 9 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5980829.9285 2105384.5624 37.7598722266182 -122.509411963006 (37.7598722266182, -122.509411963006) 1 8 3 29491 35
171253 90954 DPW Maintained 1 Dracaena draco :: Dragon Tree 156 4715 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2008 12:00:00 AM 3 3x3   5980949.82194 2110923.96182 37.7750888730704 -122.509408725446 (37.7750888730704, -122.509408725446) 11 6 2 55 26
40801 90725 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 4701X Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2008 12:00:00 AM 3 3x3   5980935.00207 2110229.74392 37.773181881349 -122.509408420019 (37.773181881349, -122.509408420019) 11 6 2 55 26
47137 184360 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1301 Lower Great Hwy 10 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5980832.1706 2105363.038 37.7598132590094 -122.509402610218 (37.7598132590094, -122.509402610218) 1 8 3 29491 35
104113 181437 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1300 Lower Great Hwy 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5980841.349 2105728.842 37.7608181926765 -122.509398035086 (37.7608181926765, -122.509398035086) 1 8 3 56 35
45678 181436 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1300 Lower Great Hwy 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5980846.2956 2105673.7233 37.7606671442701 -122.509376833683 (37.7606671442701, -122.509376833683) 1 8 3 56 35
148274 181602 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1300 Lower Great Hwy 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5980850.9081 2105690.7559 37.7607141828477 -122.5093621464 (37.7607141828477, -122.5093621464) 1 8 3 56 35
185693 103704 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4700 Cabrillo St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 4x4   5980950.21824 2110299.88198 37.7733753570212 -122.509360996158 (37.7733753570212, -122.509360996158) 11 6 2 55 26
158077 109510 Undocumented 4 Myoporum laetum :: Myoporum 62 7200X FULTON ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5980935 2109588 37.7714198408482 -122.509360757847 (37.7714198408482, -122.509360757847) 11 6 2 55 8
177151 119238 DPW Maintained 1 Yucca gloriosa :: Spanish Dagger 126 4701 Cabrillo St 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 3ft   5980953.58736 2110230.22563 37.7731842998171 -122.509344168 (37.7731842998171, -122.509344168) 11 6 2 55 26
165904 181601 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1300 Lower Great Hwy 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5980856.8807 2105634.5433 37.7605601913922 -122.509337315457 (37.7605601913922, -122.509337315457) 1 8 3 56 35
115202 186631 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1300 Lower Great Hwy 7 unknown : Yard Tree Private 2     2 Width 0ft   5980860.0426 2105683.7293 37.7606954284135 -122.509330032989 (37.7606954284135, -122.509330032989) 1 8 3 56 35
178636 181600 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1300 Lower Great Hwy 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5980858.6373 2105611.0043 37.7604956636473 -122.509329492114 (37.7604956636473, -122.509329492114) 1 8 3 56 35
79662 186630 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1300 Lower Great Hwy 6 unknown : Yard Tree Private 2     2 Width 0ft   5980860.7453 2105672.8381 37.7606655657469 -122.509326793851 (37.7606655657469, -122.509326793851) 1 8 3 56 35
72016 186632 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1300 Lower Great Hwy 8 unknown : Yard Tree Private 2     5 Width 0ft   5980861.0966 2105687.2426 37.7607051370684 -122.509326648666 (37.7607051370684, -122.509326648666) 1 8 3 56 35
31514 181599 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1300 Lower Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5980858.9886 2105581.4927 37.760414654003 -122.509326085413 (37.760414654003, -122.509326085413) 1 8 3 56 35
181306 186629 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1300 Lower Great Hwy 5 unknown : Yard Tree Private 2     3 Width 0ft   5980862.5019 2105665.4602 37.7606454117292 -122.50932017074 (37.7606454117292, -122.50932017074) 1 8 3 56 35
24254 186636 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1300 Lower Great Hwy 12 unknown : Yard Tree Private 2     3 Width 0ft   5980864.6099 2105729.0507 37.7608201372164 -122.509317602916 (37.7608201372164, -122.509317602916) 1 8 3 56 35
410 183338 DPW Maintained 1 :: 45 1200 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5980889.0479 2106803.3028 37.7637711641625 -122.509312865514 (37.7637711641625, -122.509312865514) 1 8 3 56 35
19971 186635 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1300 Lower Great Hwy 11 unknown : Yard Tree Private 2     4 Width 0ft   5980866.0152 2105705.863 37.7607565533288 -122.50931102062 (37.7607565533288, -122.50931102062) 1 8 3 56 35
255 118456 DPW Maintained 1 Myoporum laetum :: Myoporum 62 490 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   5981010.56733 2112424.984 37.7792138173967 -122.509310094921 (37.7792138173967, -122.509310094921) 11 6 2 55 26
82839 118457 DPW Maintained 1 Myoporum laetum :: Myoporum 62 490 48th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   5981011.74617 2112476.4222 37.779355120923 -122.509309837992 (37.779355120923, -122.509309837992) 11 6 2 55 26
161464 118470 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 510 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5981008.92024 2112222.55161 37.7786579010228 -122.509300755145 (37.7786579010228, -122.509300755145) 11 6 2 55 26
190926 103703 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 4700 Cabrillo St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 4x4   5980967.69346 2110300.1672 37.7733771705098 -122.509300569193 (37.7733771705098, -122.509300569193) 11 6 2 55 26
192063 183260 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1220 La Playa 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5980890.8145 2106708.2585 37.76351030418 -122.509299696626 (37.76351030418, -122.509299696626) 1 8 3 56 35
102296 186625 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1300 Lower Great Hwy 1 unknown : Yard Tree Private 2     2 Width 0ft   5980868.2988 2105582.371 37.7604176144972 -122.50929395155 (37.7604176144972, -122.50929395155) 1 8 3 56 35
150633 183259 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1220 La Playa 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5980894.3477 2106672.2193 37.7634115592808 -122.509284800059 (37.7634115592808, -122.509284800059) 1 8 3 56 35
9102 83833 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1220 La Playa St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2008 12:00:00 AM   3x3 Permit Number 50199 5980896.51884717 2106747.16910548 37.7636174777723 -122.509282857292 (37.7636174777723, -122.509282857292) 1 8 3 56 35
115361 83929 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1220 La Playa St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2008 12:00:00 AM   3x3 Permit Number 50199 5980896.51884717 2106747.16910548 37.7636174777723 -122.509282857292 (37.7636174777723, -122.509282857292) 1 8 3 56 35
47826 186634 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1300 Lower Great Hwy 10 unknown : Yard Tree Private 2     2 Width 0ft   5980874.0957 2105690.7559 37.7607155500113 -122.509281952349 (37.7607155500113, -122.509281952349) 1 8 3 56 35
47281 186628 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1300 Lower Great Hwy 4 unknown : Yard Tree Private 2     5 Width 0ft   5980874.0957 2105652.4611 37.760610403518 -122.509279108369 (37.760610403518, -122.509279108369) 1 8 3 56 35
137718 118414 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 641 48th Ave 1 Sidewalk: Property side : Yard Tree Private 2     26     5980997.21538 2111360.64896 37.7762906814163 -122.509277221064 (37.7762906814163, -122.509277221064) 11 6 2 55 26
96178 186633 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1300 Lower Great Hwy 9 unknown : Yard Tree Private 2     3 Width 0ft   5980876.555 2105686.5399 37.760704119089 -122.509273133786 (37.760704119089, -122.509273133786) 1 8 3 56 35
65395 186627 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1300 Lower Great Hwy 3 unknown : Yard Tree Private 2     3 Width 0ft   5980877.609 2105668.6222 37.7606549843877 -122.509268157881 (37.7606549843877, -122.509268157881) 1 8 3 56 35
26015 186626 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1300 Lower Great Hwy 2 unknown : Yard Tree Private 2     7 Width 0ft   5980879.19 2105650.5288 37.7606053983358 -122.509261346313 (37.7606053983358, -122.509261346313) 1 8 3 56 35
174398 103701 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4700 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   5980981.42101 2110300.97358 37.7733801939619 -122.50925314442 (37.7733801939619, -122.50925314442) 11 6 2 55 26
80411 186483 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 38 unknown : Yard Tree Private 2     5 Width 0ft   5980878.6055 2105409.1394 37.7599425780444 -122.509245441233 (37.7599425780444, -122.509245441233) 1 8 3 56 35
112155 186489 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 35 unknown : Yard Tree Private 2     4 Width 0ft   5980878.6055 2105387.9124 37.759884294807 -122.509243864844 (37.759884294807, -122.509243864844) 1 8 3 56 35
118292 118477 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 562 48th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5981021.8691 2111857.25612 37.7776556713315 -122.509228826135 (37.7776556713315, -122.509228826135) 11 6 2 55 26
45777 186843 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 33 unknown : Yard Tree Private 2     7 Width 0ft   5980882.2296 2105351.6713 37.7597850008387 -122.509228639712 (37.7597850008387, -122.509228639712) 1 8 3 56 35
136225 186490 DPW Maintained 1 Pinus Spp :: Pine Spp 100 1400 Lower Great Hwy 36 unknown : Yard Tree Private 2     1 Width 0ft   5980883.265 2105397.7493 37.7599115788226 -122.509228480711 (37.7599115788226, -122.509228480711) 1 8 3 56 35
112574 186500 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 28 unknown : Yard Tree Private 2     2 Width 0ft   5980882.7473 2105316.9833 37.7596897880858 -122.509224273257 (37.7596897880858, -122.509224273257) 1 8 3 56 35
147901 186499 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 27 unknown : Yard Tree Private 2     1 Width 0ft   5980882.7473 2105311.2882 37.7596741509783 -122.509223850326 (37.7596741509783, -122.509223850326) 1 8 3 56 35
157757 186504 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 32 unknown : Yard Tree Private 2     4 Width 0ft   5980883.7828 2105343.3876 37.7597623477539 -122.509222652886 (37.7597623477539, -122.509222652886) 1 8 3 56 35
74858 186484 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 24 unknown : Yard Tree Private 2     2 Width 0ft   5980883.7828 2105293.6854 37.7596258798004 -122.509218961888 (37.7596258798004, -122.509218961888) 1 8 3 56 35
43382 186503 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 31 unknown : Yard Tree Private 2     4 Width 0ft   5980885.336 2105334.0684 37.7597368514834 -122.509216589167 (37.7597368514834, -122.509216589167) 1 8 3 56 35
187143 186486 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 26 unknown : Yard Tree Private 2     2 Width 0ft   5980884.8182 2105306.6287 37.7596614794268 -122.509216342217 (37.7596614794268, -122.509216342217) 1 8 3 56 35
183259 118478 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 578 48th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5981024.51617 2111800.84509 37.7775009394111 -122.509215478972 (37.7775009394111, -122.509215478972) 11 6 2 55 26
169488 186493 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 23 unknown : Yard Tree Private 2     2 Width 0ft   5980884.8182 2105286.9549 37.7596074608269 -122.509214881201 (37.7596074608269, -122.509214881201) 1 8 3 56 35
186494 186494 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 19 unknown : Yard Tree Private 2     2 Width 0ft   5980884.3005 2105262.6215 37.7595406177816 -122.509214864588 (37.7595406177816, -122.509214864588) 1 8 3 56 35
77041 186492 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 22 unknown : Yard Tree Private 2     2 Width 0ft   5980885.336 2105278.6712 37.759584746696 -122.509212475259 (37.759584746696, -122.509212475259) 1 8 3 56 35
60315 186488 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1400 Lower Great Hwy 34 unknown : Yard Tree Private 2     15 Width 0ft   5980888.4423 2105382.2174 37.7598692379346 -122.50920942184 (37.7598692379346, -122.50920942184) 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)
);