trees

8,298 rows where qLegalStatus_id = 4 sorted by Zip Codes 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)
48591 114380 Undocumented 4 Pinus radiata :: Monterey Pine 15 437X SERRANO DR   Sidewalk: Curb side : Cutout Tree Private 2     48     5988907 2090368 37.7191136019865 -122.480378474397 (37.7191136019865, -122.480378474397) 1 8 4 64 14
49072 114932 Undocumented 4 Pinus radiata :: Monterey Pine 15 4400x OCEAN AVE 8 Front Yard : Cutout Tree Private 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 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
49555 175375 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 10 Junipero Serra Blvd 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5991400.23386 2088781.36253 37.714901655676 -122.471644844135 (37.714901655676, -122.471644844135) 9 8 6 64 24
50491 211736 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2560 Ocean Ave 2 : Tree Private 2     11 Width 3ft   5991128.88067 2094900.31917 37.7316870897845 -122.473028700209 (37.7316870897845, -122.473028700209) 1 8 4 64 40
51148 105904 Undocumented 4 Pinus radiata :: Monterey Pine 15 700X BROTHERHOOD WAY   Sidewalk: Property side : Yard Tree Private 2         Permit Number 772491 5991178.9 2088065.4 37.7129229890255 -122.472357697274 (37.7129229890255, -122.472357697274) 1 8 4 64 14
53226 114118 Undocumented 4 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 11 Sidewalk: Property side : Yard Tree Private 2     28     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
53316 104931 Undocumented 4 Pinus radiata :: Monterey Pine 15 841 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
53564 114125 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 18 Sidewalk: Property side : Yard Tree Private 2     18     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
53614 255672 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 231 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993718 2088745 37.714935637127 -122.463631095472 (37.714935637127, -122.463631095472) 9 8 6 64 24
54263 99731 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2601 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991009.5 2094863.7 37.7315796303384 -122.473438749026 (37.7315796303384, -122.473438749026) 1 8 4 64 40
54349 114115 Undocumented 4 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 8 Sidewalk: Property side : Yard Tree Private 2     36     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
55130 104947 Undocumented 4 Magnolia spp :: Magnolia 224 532 Gonzalez Dr 4 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
55368 109658 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 29 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
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
56921 255350 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700 Brotherhood Way 31 Sidewalk: Curb side : Cutout Tree Private 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
57324 104918 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 719 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990421 2090607 37.719857702396 -122.475162650507 (37.719857702396, -122.475162650507) 1 8 4 64 40
57332 104890 Undocumented 4 :: 45 150 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2         empty 5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
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
58510 254319 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 210 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       10x10   5991371 2094995 37.7319610744091 -122.472198552297 (37.7319610744091, -122.472198552297) 1 8 4 64 40
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
59019 255359 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700 Brotherhood Way 40 Sidewalk: Curb side : Cutout Tree Private 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
60828 104882 Undocumented 4 Pinus radiata :: Monterey Pine 15 130 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990320.4 2090026.5 37.7182579620451 -122.475468023466 (37.7182579620451, -122.475468023466) 1 8 4 64 14
61080 114116 Undocumented 4 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 9 Sidewalk: Property side : Yard Tree Private 2     18     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
61085 114124 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 17 Sidewalk: Property side : Yard Tree Private 2     12     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
61697 96800 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 295x Arch St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5992696 2088571 37.7143989335186 -122.467150884655 (37.7143989335186, -122.467150884655) 9 8 6 64 24
62630 107496 Undocumented 4 Pinus radiata :: Monterey Pine 15 846x JUNIPERO SERRA BLVD 1 Median : Cutout Tree Private 2     60     5991242 2091754 37.7230546314384 -122.472408341718 (37.7230546314384, -122.472408341718) 9 8 4 64 40
63627 104944 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 532 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
64576 104958 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 759 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
64580 114269 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800x BROTHERHOOD WAY 10 Front Yard : Yard Tree Private 2     38     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
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
65749 104923 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 767 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990385 2090588 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
66095 104946 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 532 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
66603 254984 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 830 Junipero Serra Blvd 1 Median : Yard Tree Private 2       10x10   5991251 2091898 37.7234505406642 -122.472387723412 (37.7234505406642, -122.472387723412) 9 8 4 64 40
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
67460 114261 Undocumented 4 Pinus radiata :: Monterey Pine 15 800x BROTHERHOOD WAY 2 Front Yard : Cutout Tree Private 2     36     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
68086 104901 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 314 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
68688 96845 Undocumented 4 Tree(s) :: 17 239 Ramsell St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5992958 2088782 37.714993409084 -122.466260641305 (37.714993409084, -122.466260641305) 9 8 6 64 24
69737 255346 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700 Brotherhood Way 27 Sidewalk: Curb side : Cutout Tree Private 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
70885 106063 Undocumented 4 Tree(s) :: 17 274 MONTICELLO ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991733.9 2090351.1 37.7192310708749 -122.470605827889 (37.7192310708749, -122.470605827889) 9 8 6 64 24
71653 255362 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700 Brotherhood Way 43 Sidewalk: Curb side : Cutout Tree Private 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
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
72096 114112 Undocumented 4 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 3 Sidewalk: Property side : Yard Tree Private 2     40     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
72193 114077 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 32 HIGUERA AVE 1 Sidewalk: Curb side : Yard Tree Private 2     6     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
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
73000 114215 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 16 HIGUERA AVE 1 Sidewalk: Curb side : Yard Tree Private 2     6     5988029 2090212 37.7186342037977 -122.483401916227 (37.7186342037977, -122.483401916227) 1 8 4 64 14
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
74005 107506 Undocumented 4 Tree(s) :: 17 129 STRATFORD DR 1 Front Yard : Yard Tree Private 2         12' PROW 5990962.6 2091579.6 37.7225595971545 -122.473361447828 (37.7225595971545, -122.473361447828) 9 8 4 64 40
74833 104951 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 600 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
74910 114400 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1X HIGUERA AVE 3 Sidewalk: Property side : Cutout Tree Private 2     22 3x3   5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
75230 109961 Undocumented 4 Pinus radiata :: Monterey Pine 15 115x GARCES DR 1 Sidewalk: Curb side : Cutout Tree Private 2     28 3x3   5989202 2088902 37.7151054701837 -122.479251597893 (37.7151054701837, -122.479251597893) 1 8 4 64 14
75828 114138 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 32 Sidewalk: Property side : Yard Tree Private 2   02/16/2016 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
76023 107819 Undocumented 4 Pinus radiata :: Monterey Pine 15 75X RALSTON ST   Back Yard : Yard Tree Private 2     45   Permit Number 775492 5992193 2088303 37.7136340221674 -122.468869945866 (37.7136340221674, -122.468869945866) 9 8 6 64 24
76825 99728 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2645 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990840.1 2094977 37.7318809123737 -122.474032655501 (37.7318809123737, -122.474032655501) 1 8 4 64 40
78288 114136 Undocumented 4 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 31 Sidewalk: Property side : Yard Tree Private 2     32     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
78327 104953 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 601 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
78402 110167 Undocumented 4 Pinus radiata :: Monterey Pine 15 131x GARCES DR 2 Sidewalk: Property side : Yard Tree Private 2   04/21/2015 12:00:00 AM 3   Permit Number 770873 5989202 2088902 37.7151054701837 -122.479251597893 (37.7151054701837, -122.479251597893) 1 8 4 64 14
79093 111089 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 10x HIGUERA AVE 1 Median : Cutout Tree Private 2   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777485 5988057 2090190 37.7185754269376 -122.483303520979 (37.7185754269376, -122.483303520979) 1 8 4 64 14
79201 115832 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 100 FONT BLVD 1 Sidewalk: Property side : Yard Tree Private 2     2 30x30 Permit Number 777501 5990916 2088996 37.715462969911 -122.473334188491 (37.715462969911, -122.473334188491) 1 8 4 64 14
80100 254362 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 239 Orizaba Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x6   5993970 2088131 37.7132642563577 -122.462715568818 (37.7132642563577, -122.462715568818) 9 8 6 64 24
80560 114268 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800x BROTHERHOOD WAY 9 Front Yard : Yard Tree Private 2     30     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
81726 114266 Undocumented 4 Pittosporum spp :: Pittosporum spp 170 800x BROTHERHOOD WAY 7 Front Yard : Cutout Tree Private 2     9     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
81822 104959 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 759 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
82197 114371 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 821 GONZALEZ DR 2 Sidewalk: Curb side : Yard Tree Private 2     2     5988453 2089765 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061) 1 8 4 64 14
82854 114075 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 24 HIGUERA AVE 1 Sidewalk: Curb side : Yard Tree Private 2     26     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
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
83428 104905 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 419 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
83754 114130 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 23 Sidewalk: Property side : Yard Tree Private 2     24     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
83959 255873 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 300 Stonecrest Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990871 2092383 37.7247602290732 -122.473736664855 (37.7247602290732, -122.473736664855) 9 8 4 64 40
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
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
84436 113237 Undocumented 4 Cedrus deodara :: Deodar Cedar 109 700X JUNIPERO SERRA BLVD 1 Median : Cutout Tree Private 2       3x3   5991325 2093086 37.7267167762023 -122.472218478241 (37.7267167762023, -122.472218478241) 9 8 4 64 40
84888 109654 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 25 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
84894 105259 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 466 GONZALEZ DR 2 Sidewalk: Curb side : Yard Tree Private 2     2     5989603.4 2089229.6 37.7160282834266 -122.477888136934 (37.7160282834266, -122.477888136934) 1 8 4 64 14
85328 114933 Undocumented 4 Pinus radiata :: Monterey Pine 15 4400x OCEAN AVE 9 Front Yard : Cutout Tree Private 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
85555 109655 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 26 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
85877 255357 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700 Brotherhood Way 38 Sidewalk: Curb side : Cutout Tree Private 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
86010 254324 Undocumented 4 Pinus radiata :: Monterey Pine 15 230 Junipero Serra Blvd 1 Median : Cutout Tree Private 2       10x10   5991365 2094903 37.7317081183109 -122.472212591573 (37.7317081183109, -122.472212591573) 1 8 4 64 40
86228 104945 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 532 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
86421 111360 Undocumented 4 Pinus radiata :: Monterey Pine 15 101x SERRANO DR 1 Sidewalk: Curb side : Cutout Tree Private 2     39 3x3   5989748 2090663 37.7199724349458 -122.477493041793 (37.7199724349458, -122.477493041793) 1 8 4 64 14
86425 256320 Undocumented 4 Pinus radiata :: Monterey Pine 15 742 Junipero Serra Blvd 1 Median : Cutout Tree Private 2       20x100   5991284 2092179 37.7242240069018 -122.472294123789 (37.7242240069018, -122.472294123789) 9 8 4 64 40
86867 104902 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 332 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
87061 104723 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 133X Juan Bautista Cir 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 770293 5989605.82194 2089746.43988 37.7174475379801 -122.477917527277 (37.7174475379801, -122.477917527277) 1 8 4 64 14
87325 254308 Undocumented 4 Pinus radiata :: Monterey Pine 15 170 Junipero Serra Blvd 5 Median : Cutout Tree Private 2       10x10   5991380 2095134 37.732343254282 -122.47217756607 (37.732343254282, -122.47217756607) 1 8 4 64 40
88408 255349 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700 Brotherhood Way 30 Sidewalk: Curb side : Cutout Tree Private 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
89101 114259 Undocumented 4 Pinus radiata :: Monterey Pine 15 801x BROTHERHOOD WAY 1 Sidewalk: Curb side : Yard Tree Private 2     28     5989805 2088661 37.7144787470114 -122.477149792402 (37.7144787470114, -122.477149792402) 1 8 4 64 14
90322 107542 Undocumented 4 Pinus radiata :: Monterey Pine 15 2 GARFIELD ST 5 Back Yard : Yard Tree Private 2     40     5993976.6 2090624.3 37.7201106425596 -122.462873531809 (37.7201106425596, -122.462873531809) 9 8 6 64 24
90362 254305 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 170 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       10x10   5991380 2095134 37.732343254282 -122.47217756607 (37.732343254282, -122.47217756607) 1 8 4 64 40
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
92577 114401 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1X HIGUERA AVE 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
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
93618 255344 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700 Brotherhood Way 25 Sidewalk: Curb side : Cutout Tree Private 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
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
93915 104907 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 432 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
94127 119281 Undocumented 4 Leptospermum laevigatum :: Australian Tea Tree 47 59x Ralston St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992077 2088275 37.7135504383964 -122.469268843393 (37.7135504383964, -122.469268843393) 9 8 6 64 24
95002 109656 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 8 Median : Cutout Tree DPW 1   02/27/2015 10:16:00 AM 3     5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
95564 255355 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700 Brotherhood Way 36 Sidewalk: Curb side : Cutout Tree Private 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
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
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
98187 114386 Undocumented 4 Pinus radiata :: Monterey Pine 15 429x ARBALLO DR 1 Front Yard : Yard Tree Private 2     56     5988163 2090444 37.7192790152529 -122.482955732568 (37.7192790152529, -122.482955732568) 1 8 4 64 14

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