trees

8,298 rows where qLegalStatus_id = 4 sorted by XCoord

✎ 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)
104395 111256 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2601x 42ND AVE 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983195 2097379 37.7380303412956 -122.50064049243 (37.7380303412956, -122.50064049243) 1 8 3 29491 35
137046 111257 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2601x 42ND AVE 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983195 2097379 37.7380303412956 -122.50064049243 (37.7380303412956, -122.50064049243) 1 8 3 29491 35
159636 111258 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2601x 42ND AVE 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983195 2097379 37.7380303412956 -122.50064049243 (37.7380303412956, -122.50064049243) 1 8 3 29491 35
534 183705 Undocumented 4 :: 45 3628 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5983226.2116 2105643.5823 37.7607244242532 -122.501143681764 (37.7607244242532, -122.501143681764) 1 8 3 56 35
11602 122483 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1295 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983305 2106338 37.7626357248351 -122.500922549214 (37.7626357248351, -122.500922549214) 1 8 3 56 35
173644 183350 Undocumented 4 Tree(s) :: 17 1226 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5983375.0645 2106778.1026 37.7638482352302 -122.500712771127 (37.7638482352302, -122.500712771127) 1 8 3 56 35
33668 102791 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1400X 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983413 2105597.3 37.7606083127672 -122.500494252669 (37.7606083127672, -122.500494252669) 1 8 3 56 35
20319 106193 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 3040 TARAVAL ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983698.2 2098878.7 37.742177638004 -122.499011481047 (37.742177638004, -122.499011481047) 1 8 3 29491 35
56634 100228 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 701X 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2016 12:00:00 AM 3 3x3 Permit Number 778265 5983810.9 2111033.8 37.7755587404093 -122.499519901729 (37.7755587404093, -122.499519901729) 11 6 2 55 26
63505 254741 Undocumented 4 Juniperus chinensis :: Juniper 113 1301X 39th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       1x4   5983905 2106262 37.7624622607408 -122.498841782409 (37.7624622607408, -122.498841782409) 1 8 3 56 35
159933 183196 Undocumented 4 Prunus spp :: Cherry 68 2479 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5983931.1246 2098292.1691 37.740580843976 -122.498162805629 (37.740580843976, -122.498162805629) 1 8 3 29491 35
22331 254742 Undocumented 4 Juniperus chinensis :: Juniper 113 1301X 39th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       1x4   5984000 2105977 37.7616853026946 -122.498492164913 (37.7616853026946, -122.498492164913) 1 8 3 56 35
93966 254743 Undocumented 4 Juniperus chinensis :: Juniper 113 1301X 39th Ave 3 Sidewalk: Property side : Cutout Tree Private 2       1x4   5984000 2105977 37.7616853026946 -122.498492164913 (37.7616853026946, -122.498492164913) 1 8 3 56 35
177990 254744 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1301X 39th Ave 4 Sidewalk: Property side : Cutout Tree Private 2       1x4   5984000 2105977 37.7616853026946 -122.498492164913 (37.7616853026946, -122.498492164913) 1 8 3 56 35
157484 105210 Undocumented 4 Tree(s) :: 17 2467 38TH AVE   Sidewalk: Curb side : Cutout Tree Private 2       4x3   5984528 2098448 37.7410436924745 -122.496110565766 (37.7410436924745, -122.496110565766) 1 8 3 29491 35
9641 261036 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1571 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5984631 2104499 37.7576641112124 -122.496200772131 (37.7576641112124, -122.496200772131) 1 8 3 56 35
932 111099 Undocumented 4 Pinus radiata :: Monterey Pine 15 480X LAKESHORE DR 20 Median : Cutout Tree DPW 1       30x200   5984942 2095282 37.7323749444343 -122.494445798495 (37.7323749444343, -122.494445798495) 1 8 4 64 35
73941 256466 Undocumented 4 Syzygium australe :: Eugenia 228 2901X Sunset Blvd 1 Median : Yard Tree Private 2       3x3   5984943 2095249 37.7322843937213 -122.494439909578 (37.7322843937213, -122.494439909578) 1 8 4 64 35
84110 256469 Undocumented 4 Syzygium australe :: Eugenia 228 2901X Sunset Blvd 4 Median : Yard Tree Private 2       3x3   5984943 2095249 37.7322843937213 -122.494439909578 (37.7322843937213, -122.494439909578) 1 8 4 64 35
95683 256468 Undocumented 4 Syzygium australe :: Eugenia 228 2901X Sunset Blvd 3 Median : Yard Tree Private 2       3x3   5984943 2095249 37.7322843937213 -122.494439909578 (37.7322843937213, -122.494439909578) 1 8 4 64 35
111138 256470 Undocumented 4 Syzygium australe :: Eugenia 228 2901X Sunset Blvd 5 Median : Yard Tree Private 2       3x3   5984943 2095249 37.7322843937213 -122.494439909578 (37.7322843937213, -122.494439909578) 1 8 4 64 35
189040 256467 Undocumented 4 Syzygium australe :: Eugenia 228 2901X Sunset Blvd 2 Median : Yard Tree Private 2       3x3   5984943 2095249 37.7322843937213 -122.494439909578 (37.7322843937213, -122.494439909578) 1 8 4 64 35
2361 256460 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 9 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
6708 256455 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2901 Sunset Blvd 4 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
6775 256471 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 15 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
21554 256452 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 2901 Sunset Blvd 1 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
46185 256462 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 11 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
49252 256461 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 10 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
57694 256459 Undocumented 4 Pinus radiata :: Monterey Pine 15 2901 Sunset Blvd 8 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
58609 256463 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 12 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
66605 256473 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 17 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
72373 256454 Undocumented 4 Pinus radiata :: Monterey Pine 15 2901 Sunset Blvd 3 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
84010 256457 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 2901 Sunset Blvd 6 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
97475 256464 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 13 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
113697 256458 Undocumented 4 Pinus radiata :: Monterey Pine 15 2901 Sunset Blvd 7 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
144660 256474 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 18 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
145026 256456 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 2901 Sunset Blvd 5 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
147683 256472 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 16 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
151016 256465 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 14 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
180742 256453 Undocumented 4 Pinus radiata :: Monterey Pine 15 2901 Sunset Blvd 2 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
100851 256441 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3001 Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5984950 2095029 37.7316807417675 -122.494399498116 (37.7316807417675, -122.494399498116) 1 8 4 64 35
149777 256440 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3001 Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5984950 2095029 37.7316807417675 -122.494399498116 (37.7316807417675, -122.494399498116) 1 8 4 64 35
161054 256439 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3001 Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5984950 2095029 37.7316807417675 -122.494399498116 (37.7316807417675, -122.494399498116) 1 8 4 64 35
162804 256442 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3001 Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5984950 2095029 37.7316807417675 -122.494399498116 (37.7316807417675, -122.494399498116) 1 8 4 64 35
228 256437 Undocumented 4 Pinus radiata :: Monterey Pine 15 3001 Sunset Blvd 25 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
8736 256444 Undocumented 4 Alnus rubra :: Red Alder 325 3001 Sunset Blvd 28 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
19357 256415 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 3 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
24901 256416 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 4 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
44870 256450 Undocumented 4 Pinus radiata :: Monterey Pine 15 3001 Sunset Blvd 34 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
56113 256431 Undocumented 4 Pinus radiata :: Monterey Pine 15 3001 Sunset Blvd 19 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
64667 256451 Undocumented 4 Pinus radiata :: Monterey Pine 15 3001 Sunset Blvd 35 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
71787 256414 Undocumented 4 Taxus baccata :: Irish Yew 86 3001 Sunset Blvd 2 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
83031 256421 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 9 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
92052 256448 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 3001 Sunset Blvd 32 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
92802 256419 Undocumented 4 Sequoia sempervirens :: Coast Redwood 155 3001 Sunset Blvd 7 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
93739 256433 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 3001 Sunset Blvd 21 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
101955 256418 Undocumented 4 Sequoia sempervirens :: Coast Redwood 155 3001 Sunset Blvd 6 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
104738 256430 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 3001 Sunset Blvd 18 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
106500 256424 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 12 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
110991 256413 Undocumented 4 Taxus baccata :: Irish Yew 86 3001 Sunset Blvd 1 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
112378 256432 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 3001 Sunset Blvd 20 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
118246 256426 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 14 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
128096 256447 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3001 Sunset Blvd 31 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
128901 256427 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3001 Sunset Blvd 15 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
130062 256429 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3001 Sunset Blvd 17 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
134265 256425 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 13 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
134842 256422 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 10 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
144246 256434 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 22 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
148029 256449 Undocumented 4 Pinus radiata :: Monterey Pine 15 3001 Sunset Blvd 33 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
148780 256423 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 11 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
152308 256445 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3001 Sunset Blvd 29 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
154520 256417 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 5 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
155748 256420 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 8 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
159914 256435 Undocumented 4 Pinus radiata :: Monterey Pine 15 3001 Sunset Blvd 23 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
163182 256443 Undocumented 4 Taxus baccata :: Irish Yew 86 3001 Sunset Blvd 27 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
168096 256438 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3001 Sunset Blvd 26 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
171148 256446 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3001 Sunset Blvd 30 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
171982 256428 Undocumented 4 Ligustrum ovalifolium :: California privet 382 3001 Sunset Blvd 16 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
175560 256436 Undocumented 4 Pinus radiata :: Monterey Pine 15 3001 Sunset Blvd 24 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
31356 106089 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 1446 36TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     14 6x6   5984998.6 2105346.4 37.7600123616364 -122.494991962302 (37.7600123616364, -122.494991962302) 1 8 3 56 35
167536 106088 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 1446 36TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     14 6x10   5984998.6 2105346.4 37.7600123616364 -122.494991962302 (37.7600123616364, -122.494991962302) 1 8 3 56 35
167790 97202 Undocumented 4 Tree(s) :: 17 460 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5985102.2 2112782.3 37.7804352989375 -122.495182016485 (37.7804352989375, -122.495182016485) 11 6 2 55 26
113377 115939 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 607 34TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2016 12:00:00 AM 3 3x3 Permit Number 777685 5985316 2111712 37.7775090776113 -122.494363475489 (37.7775090776113, -122.494363475489) 11 6 2 55 26
1588 260075 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 171X Gellert Dr 1 Median : Yard Tree Private 2       3x3   5985371 2094678 37.7307416178434 -122.492918192866 (37.7307416178434, -122.492918192866) 1 8 4 64 35
408 109629 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 200X GELLERT DR 30 Median : Cutout Tree DPW 1       30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
8504 109669 Undocumented 4 Sequoia sempervirens :: Coast Redwood 155 200X GELLERT DR 33 Median : Cutout Tree DPW 1   02/26/2015 01:37:00 PM 3 30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
112919 109667 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 200X GELLERT DR 31 Median : Cutout Tree DPW 1       30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
139307 109670 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 200X GELLERT DR 34 Median : Cutout Tree DPW 1       30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
173852 109668 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 200X GELLERT DR 32 Median : Cutout Tree DPW 1       30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
30069 256475 Undocumented 4 Pinus radiata :: Monterey Pine 15 2901X Sunset Blvd Off Ramp 1 Median : Yard Tree Private 2       3x3   5985408 2095918 37.7341484934627 -122.49288158081 (37.7341484934627, -122.49288158081) 1 8 3 29491 35
76059 256480 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 2901X Sunset Blvd Off Ramp 6 Median : Yard Tree Private 2       3x3   5985408 2095918 37.7341484934627 -122.49288158081 (37.7341484934627, -122.49288158081) 1 8 3 29491 35
90965 256478 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 2901X Sunset Blvd Off Ramp 4 Median : Yard Tree Private 2       3x3   5985408 2095918 37.7341484934627 -122.49288158081 (37.7341484934627, -122.49288158081) 1 8 3 29491 35
110971 256476 Undocumented 4 Pinus radiata :: Monterey Pine 15 2901X Sunset Blvd Off Ramp 2 Median : Yard Tree Private 2       3x3   5985408 2095918 37.7341484934627 -122.49288158081 (37.7341484934627, -122.49288158081) 1 8 3 29491 35
110982 256481 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 2901X Sunset Blvd Off Ramp 7 Median : Yard Tree Private 2       3x3   5985408 2095918 37.7341484934627 -122.49288158081 (37.7341484934627, -122.49288158081) 1 8 3 29491 35
132188 256479 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 2901X Sunset Blvd Off Ramp 5 Median : Yard Tree Private 2       3x3   5985408 2095918 37.7341484934627 -122.49288158081 (37.7341484934627, -122.49288158081) 1 8 3 29491 35
159904 256477 Undocumented 4 Pinus radiata :: Monterey Pine 15 2901X Sunset Blvd Off Ramp 3 Median : Yard Tree Private 2       3x3   5985408 2095918 37.7341484934627 -122.49288158081 (37.7341484934627, -122.49288158081) 1 8 3 29491 35
64412 92887 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2750 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2     8     5985495 2103001 37.7536015877094 -122.493102400007 (37.7536015877094, -122.493102400007) 1 8 3 56 35
19564 264882 Undocumented 4 Juniperus chinensis :: Juniper 113 2801 Lawton St 1 Sidewalk: Property side : Yard Landscaping Private 2       3x3   5985570 2104278 37.7571122644181 -122.49293709397 (37.7571122644181, -122.49293709397) 1 8 3 56 35
72979 258065 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3233 Irving St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5985670 2106323 37.7627331150852 -122.492741876307 (37.7627331150852, -122.492741876307) 1 8 3 56 35
154719 104817 Undocumented 4 Schinus terebinthifolius :: Brazilian Pepper 93 3170 BALBOA ST   Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5985841 2111127 37.7759335444794 -122.492504259099 (37.7759335444794, -122.492504259099) 11 6 2 55 26

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