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)
767 100549 Undocumented 4 Acer spp :: Maple 88 290X Tehama St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x4                      
3669 103667 Undocumented 4 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
4476 112909 Undocumented 4 Tree(s) :: 17 1899X Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2                              
4983 112267 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
5100 101532 Undocumented 4 Tree(s) :: 17 11323 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
5748 115724 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 250x Octavia St 1 Side Yard : Yard Tree Dept of Real Estate 7                              
6238 103666 Undocumented 4 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7827 115725 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 250X Octavia St 2 Side Yard : Yard Tree Dept of Real Estate 7                              
9335 112908 Undocumented 4 Tree(s) :: 17 1899X Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
9557 112910 Undocumented 4 Tree(s) :: 17 1899X Beach St 3 Sidewalk: Curb side : Cutout Tree Private 2                              
10205 173902 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 601x Hearst Ave 2 Sidewalk: Curb side : Cutout Tree Private 2                              
10489 102839 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 2 Sidewalk: Property side : Yard Tree DPW 1                              
10516 102842 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1101X Portola Dr 8 Sidewalk: Property side : Yard Tree DPW 1                              
10813 100543 Undocumented 4 Acer spp :: Maple 88 290X Tehama St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x4                      
10916 108180 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 835 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
10998 100001 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 501X 01st St 2 Sidewalk: Curb side : Pot Tree Private 2         Address is 100 1st Street                    
11335 112269 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 3 Sidewalk: Curb side : Cutout Tree Private 2                              
12733 102843 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1101X Portola Dr 10 Sidewalk: Property side : Yard Tree DPW 1                              
14524 99746 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 4250 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
15154 102838 Undocumented 4 Pinus radiata :: Monterey Pine 15 1101X Portola Dr 1 Sidewalk: Property side : Yard Tree DPW 1                              
15233 109923 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 214 state st 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
15258 103665 Undocumented 4 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
16355 103663 Undocumented 4 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18064 103664 Undocumented 4 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18422 112268 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2                              
18674 103662 Undocumented 4 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
75255 118899 Undocumented 4 Myoporum laetum :: Myoporum 62 7300 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   5980716.90165 2109609.13106 37.771464998604 -122.510116727255 (37.771464998604, -122.510116727255) 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
146510 183256 Undocumented 4 :: 45 4741 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5980967.1327 2106185.8677 37.7620804693646 -122.508996949452 (37.7620804693646, -122.508996949452) 1 8 3 56 35
127150 105337 Undocumented 4 Tree(s) :: 17 4701X LINCOLN WAY 1 Sidewalk: Curb side : Cutout Tree Private 2       9x4   5981020 2106919 37.7640965553617 -122.508868541389 (37.7640965553617, -122.508868541389) 11 8 3 55 35
102900 255186 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 4650 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981093 2111000 37.7753060927233 -122.50891909698 (37.7753060927233, -122.50891909698) 11 6 2 55 26
157176 118688 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 4645 Balboa St 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   5981105.94918 2110928.32696 37.7751100630106 -122.508868980798 (37.7751100630106, -122.508868980798) 11 6 2 55 26
17829 106868 Undocumented 4 Tree(s) :: 17 1956 GREAT HWY   Sidewalk: Property side : Cutout Tree Private 2           5981193.7 2101737.6 37.7498801477899 -122.507883225183 (37.7498801477899, -122.507883225183) 1 8 3 29491 35
838 264883 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1624 48th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5981321 2103997 37.7560913197894 -122.50761065519 (37.7560913197894, -122.50761065519) 1 8 3 56 35
13893 264884 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1624 48th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5981321 2103997 37.7560913197894 -122.50761065519 (37.7560913197894, -122.50761065519) 1 8 3 56 35
46138 106666 Undocumented 4 Tree(s) :: 17 1878 48TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2           5981378.4 2102298.1 37.7514300033234 -122.507286113612 (37.7514300033234, -122.507286113612) 1 8 3 56 35
154876 112809 Undocumented 4 Myoporum laetum :: Myoporum 62 666 47TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   11/17/2015 12:00:00 AM   3x3 Permit Number 776751 5981389 2111175 37.7758040356864 -122.507908173068 (37.7758040356864, -122.507908173068) 11 6 2 55 26
170569 112810 Undocumented 4 Myoporum laetum :: Myoporum 62 666 47TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   11/17/2015 12:00:00 AM   3x3 Permit Number 776751 5981389 2111175 37.7758040356864 -122.507908173068 (37.7758040356864, -122.507908173068) 11 6 2 55 26
58052 105132 Undocumented 4 Myoporum laetum :: Myoporum 62 1619 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM   3x3 Permit Number 777355 5981562.16 2104041.1764 37.756226819608 -122.506779933984 (37.756226819608, -122.506779933984) 1 8 3 56 35
81816 118419 Undocumented 4 :: 45 5507 Anza St 1 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   5981562.4785 2111629.449 37.7770620385939 -122.507341801673 (37.7770620385939, -122.507341801673) 11 6 2 55 26
39528 184186 Undocumented 4 Myoporum laetum :: Myoporum 62 1651 47th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 0ft   5981569.4938 2103830.3301 37.7556483274352 -122.50673893378 (37.7556483274352, -122.50673893378) 1 8 3 56 35
104855 107143 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1506 47TH AVE 4 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   5981601.8 2104810 37.7583401244926 -122.506699867993 (37.7583401244926, -122.506699867993) 1 8 3 56 35
121385 119124 Undocumented 4 :: 45 601 46th Ave 3 Sidewalk: Property side : Yard Tree Private 2       Width 5ft   5981605.53063 2111566.74083 37.7768923962204 -122.507188220302 (37.7768923962204, -122.507188220302) 11 6 2 55 26
24658 106897 Undocumented 4 Myoporum laetum :: Myoporum 62 2768 GREAT HWY 1 Sidewalk: Curb side : Cutout Tree Private 2           5981642.5 2096616.3 37.735844912626 -122.505951630112 (37.735844912626, -122.505951630112) 1 8 3 29491 35
145950 105192 Undocumented 4 Myoporum laetum :: Myoporum 62 699X 46TH AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3   5981653 2111144 37.7757344699637 -122.506992646039 (37.7757344699637, -122.506992646039) 11 6 2 55 26
463 116745 Undocumented 4 Myoporum laetum :: Myoporum 62 2998x SLOAT BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981657 2096559 37.7356884360348 -122.505897251941 (37.7356884360348, -122.505897251941) 1 8 3 29491 35
168573 107862 Undocumented 4 Myoporum laetum :: Myoporum 62 2788 GREAT HWY 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981657.8 2096559 37.7356884831234 -122.50589448608 (37.7356884831234, -122.50589448608) 1 8 3 29491 35
78834 107860 Undocumented 4 Myoporum laetum :: Myoporum 62 3667 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 777933 5981683.9506 2096685.2741 37.7360367363779 -122.505813433386 (37.7360367363779, -122.505813433386) 1 8 3 29491 35
150270 118550 Undocumented 4 :: 45 8140 Geary Blvd 3 Side Yard : Yard Tree Private 2           5981686.0706 2112397.37669 37.7791778206923 -122.506971243035 (37.7791778206923, -122.506971243035) 11 6 2 55 26
13988 106896 Undocumented 4 Myoporum laetum :: Myoporum 62 2958 SLOAT BLVD   Sidewalk: Curb side : Cutout Tree Private 2           5981703.3 2096579.8 37.7357482722765 -122.505738719186 (37.7357482722765, -122.505738719186) 1 8 3 29491 35
31741 118699 Undocumented 4 Dracaena draco :: Dragon Tree 156 4445 Balboa St 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   5981706.97988 2110951.27348 37.7752084783718 -122.506791621288 (37.7752084783718, -122.506791621288) 11 6 2 55 26
4623 106966 Undocumented 4 Tree(s) :: 17 2391 47TH AVE   Sidewalk: Curb side : Cutout Tree Private 2           5981720.8 2098834.4 37.7419398125124 -122.505845312535 (37.7419398125124, -122.505845312535) 1 8 3 29491 35
21446 107856 Undocumented 4 Myoporum laetum :: Myoporum 62 2938 SLOAT BLVD   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981725.3 2096580 37.7357501162313 -122.505662672753 (37.7357501162313, -122.505662672753) 1 8 3 29491 35
49031 107855 Undocumented 4 Myoporum laetum :: Myoporum 62 2938 SLOAT BLVD   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981725.3 2096580 37.7357501162313 -122.505662672753 (37.7357501162313, -122.505662672753) 1 8 3 29491 35
186051 107857 Undocumented 4 Tree(s) :: 17 2938 SLOAT BLVD   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 774528 5981725.3 2096580 37.7357501162313 -122.505662672753 (37.7357501162313, -122.505662672753) 1 8 3 29491 35
21073 118697 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 4445 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   5981741.45625 2110952.76376 37.7752146003791 -122.506672472372 (37.7752146003791, -122.506672472372) 11 6 2 55 26
3419 259044 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 3649 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981832 2098708 37.7415992976029 -122.505451458513 (37.7415992976029, -122.505451458513) 1 8 3 29491 35
180663 106366 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 9 SEAL ROCK DR   Sidewalk: Curb side : Cutout Tree Private 2           5981833.1 2112945.4 37.7806911884837 -122.506503269885 (37.7806911884837, -122.506503269885) 11 6 2 55 26
910 259043 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 3639 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981868 2098709 37.7416041617746 -122.505327058934 (37.7416041617746, -122.505327058934) 1 8 3 29491 35
19136 102260 Undocumented 4 Tree(s) :: 17 1350 46th Ave 1 Sidewalk: Property side : Cutout Tree Private 2     24 4x6   5981875.8 2105892.8 37.7613293147111 -122.505832545781 (37.7613293147111, -122.505832545781) 1 8 3 56 35
12436 259039 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 3627 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981920 2098711 37.7416127129705 -122.505147411787 (37.7416127129705, -122.505147411787) 1 8 3 29491 35
19150 259041 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 3614 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981967 2098808 37.7418818134636 -122.504992090975 (37.7418818134636, -122.504992090975) 1 8 3 29491 35
18670 259040 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 3615 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981969 2098712 37.7416183416682 -122.504978063323 (37.7416183416682, -122.504978063323) 1 8 3 29491 35
6440 259042 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 3612 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981996 2098820 37.7419164682935 -122.504892709134 (37.7419164682935, -122.504892709134) 1 8 3 29491 35
194143 118792 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 746 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   5982002.3368 2110652.98782 37.7744068613492 -122.505747814892 (37.7744068613492, -122.505747814892) 11 6 2 55 26
192660 112981 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 3880 NORIEGA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982016 2102928 37.7531970663373 -122.505127932021 (37.7531970663373, -122.505127932021) 1 8 3 56 35
125661 115911 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 3698x QUINTARA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5982047 2100859 37.7475179963819 -122.504867427241 (37.7475179963819, -122.504867427241) 1 8 3 29491 35
17612 262236 Undocumented 4 Juniperus chinensis :: Juniper 113 3540 Rivera St 1 Sidewalk: Property side : Cutout Landscaping Private 2       3x3   5982153 2100195 37.7457010726591 -122.504451707081 (37.7457010726591, -122.504451707081) 1 8 3 29491 35
16399 262491 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 3940 Judah St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982210 2105632 37.760632897171 -122.504657384045 (37.760632897171, -122.504657384045) 1 8 3 56 35
17238 262489 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3940 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982210 2105632 37.760632897171 -122.504657384045 (37.760632897171, -122.504657384045) 1 8 3 56 35
17827 262490 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 3940 Judah St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982210 2105632 37.760632897171 -122.504657384045 (37.760632897171, -122.504657384045) 1 8 3 56 35
159537 255244 Undocumented 4 Pinus radiata :: Monterey Pine 15 4300 Clement St 1 Front Yard : Yard Tree Private 2           5982359 2113083 37.7810999474526 -122.504694157984 (37.7810999474526, -122.504694157984) 11 6 2 55 26
127596 183654 Undocumented 4 :: 45 4000 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5982417.4167 2104930.2746 37.7587183575205 -122.503888061559 (37.7587183575205, -122.503888061559) 1 8 3 56 35
35142 102666 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 3399X Wawona St 7 Sidewalk: Property side : Cutout Tree Private 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
70170 102663 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 3399X Wawona St 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
137333 102662 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 3399X Wawona St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
138638 102661 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 3399X Wawona St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
158204 102664 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 3399X Wawona St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
178921 102660 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 3399X Wawona St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
191350 102665 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 3399X Wawona St 6 Sidewalk: Property side : Cutout Tree Private 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
180223 100354 Undocumented 4 Tree(s) :: 17 1242 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5982470.7 2106644.2 37.7634274417273 -122.503830723516 (37.7634274417273, -122.503830723516) 1 8 3 56 35
23118 104735 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1499X 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       2x2   5982473.05016 2105245.16297 37.7595862228156 -122.503718978789 (37.7595862228156, -122.503718978789) 1 8 3 56 35
43484 115963 Undocumented 4 :: 45 847 43RD AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2016 12:00:00 AM 3 3x3   5982585 2109998 37.7726427311472 -122.503683790346 (37.7726427311472, -122.503683790346) 11 6 2 55 26
88587 115931 Undocumented 4 :: 45 847 43RD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2016 12:00:00 AM 3 3x3   5982585 2109998 37.7726427311472 -122.503683790346 (37.7726427311472, -122.503683790346) 11 6 2 55 26
194044 115634 Undocumented 4 Tree(s) :: 17 844 43RD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982626 2109989 37.7726204302856 -122.503541302768 (37.7726204302856, -122.503541302768) 11 6 2 55 26
153097 114554 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1200x 43RD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982778 2106905 37.7641615885028 -122.502787196132 (37.7641615885028, -122.502787196132) 1 8 3 56 35
9568 261150 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3220x Santiago St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982825 2099474 37.7437609086011 -122.502074725774 (37.7437609086011, -122.502074725774) 1 8 3 29491 35
16950 261148 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3220x Santiago St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982825 2099474 37.7437609086011 -122.502074725774 (37.7437609086011, -122.502074725774) 1 8 3 29491 35
12191 113350 Undocumented 4 Tree(s) :: 17 7802x GEARY BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     6 4x8   5982855 2112422 37.7793142001238 -122.502929326548 (37.7793142001238, -122.502929326548) 11 6 2 55 26
70657 113352 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 7802x GEARY BLVD 4 Sidewalk: Curb side : Cutout Tree Private 2     12 5x9   5982855 2112422 37.7793142001238 -122.502929326548 (37.7793142001238, -122.502929326548) 11 6 2 55 26
76536 113351 Undocumented 4 Tree(s) :: 17 7802x GEARY BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5982855 2112422 37.7793142001238 -122.502929326548 (37.7793142001238, -122.502929326548) 11 6 2 55 26
107154 113354 Undocumented 4 Myoporum laetum :: Myoporum 62 7802x GEARY BLVD 6 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5982855 2112422 37.7793142001238 -122.502929326548 (37.7793142001238, -122.502929326548) 11 6 2 55 26
164768 113353 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 7802x GEARY BLVD 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5982855 2112422 37.7793142001238 -122.502929326548 (37.7793142001238, -122.502929326548) 11 6 2 55 26
9014 261225 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2111 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2020 12:00:00 AM 3 4x6   5982897 2100735 37.7472274959484 -122.501919055433 (37.7472274959484, -122.501919055433) 1 8 3 29491 35
122036 255425 Undocumented 4 Pinus radiata :: Monterey Pine 15 2451 43rd Ave 1 Sidewalk: Property side : Cutout Tree Private 2       6x10   5982976 2098446 37.740947172682 -122.501476581088 (37.740947172682, -122.501476581088) 1 8 3 29491 35
62025 183697 Undocumented 4 Olea europaea :: Olive Tree 9 1341 42nd Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5983052.2798 2105821.6343 37.7612030896009 -122.501758397661 (37.7612030896009, -122.501758397661) 1 8 3 56 35
4317 261373 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1701x 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2020 12:00:00 AM 3 3x3   5983095 2103514 37.7548694854578 -122.501439939014 (37.7548694854578, -122.501439939014) 1 8 3 56 35
11446 111248 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 3101x VICENTE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5983195 2097379 37.7380303412956 -122.50064049243 (37.7380303412956, -122.50064049243) 1 8 3 29491 35
59320 111254 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2601x 42ND AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983195 2097379 37.7380303412956 -122.50064049243 (37.7380303412956, -122.50064049243) 1 8 3 29491 35
83458 111255 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2601x 42ND AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983195 2097379 37.7380303412956 -122.50064049243 (37.7380303412956, -122.50064049243) 1 8 3 29491 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)
);