trees
8,298 rows where qLegalStatus_id = 4 sorted by Longitude descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | ||||
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 | ||||
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 | ||
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 | ||||
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 | ||||
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 | |||||
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 | ||||
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 | |||
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 | |||||
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 | ||||
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 | ||
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 | |||
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 | ||||
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 | ||||||
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 | |||||
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 | ||||
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 | ||||||
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 | |||
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 | |||
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 | ||||
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 | ||||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | ||
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 | |||
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 | ||||
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 | ||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | |||||
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 | ||||
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 | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );