trees
8,298 rows where qLegalStatus_id = 4 sorted by Fire Prevention Districts
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 | ||||||||||||
121 | 120916 | Undocumented 4 | Tree(s) :: 17 | 1430 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778800 | 5990886 | 2105639 | 37.7611586563939 | -122.474651843595 | (37.7611586563939, -122.474651843595) | 1 | 8 | 4 | 56 | 12 | |
125 | 92934 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 339 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5992211 | 2096907 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) | 1 | 8 | 4 | 59 | 40 | ||||
128 | 110722 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
188 | 112351 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992711 | 2097652 | 37.7393339885882 | -122.467759098278 | (37.7393339885882, -122.467759098278) | 1 | 8 | 4 | 59 | 40 | ||||
197 | 104920 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 750 Gonzalez Dr | 1 | Median : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
208 | 107457 | Undocumented 4 | Prunus spp :: Cherry 68 | 2682 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991487.4 | 2097177.7 | 37.7379609526954 | -122.471955163509 | (37.7379609526954, -122.471955163509) | 1 | 8 | 4 | 29491 | 40 | |||||
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 | ||||
230 | 114428 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 34x HIGUERA AVE | 2 | Median : Yard | Tree | Private 2 | 56 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||||
451 | 114938 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 14 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 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 | ||||
501 | 108350 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1501x RIVERA ST | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5988383 | 2100343 | 37.7464719103157 | -122.482920391178 | (37.7464719103157, -122.482920391178) | 1 | 8 | 3 | 29491 | 35 | ||||
515 | 262251 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 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 | |||
709 | 102222 | Undocumented 4 | Tree(s) :: 17 | 30 Aloha Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5992101.6 | 2104316.3 | 37.7575972316932 | -122.470351313846 | (37.7575972316932, -122.470351313846) | 1 | 8 | 4 | 56 | 12 | |||
731 | 262111 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2021 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991247 | 2101647 | 37.7502185858925 | -122.473112177678 | (37.7502185858925, -122.473112177678) | 1 | 8 | 4 | 29491 | 12 | ||||
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 | ||||
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 | ||||
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 | ||||
1070 | 261149 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 322x Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991839 | 2099782 | 37.7451320352893 | -122.470929181064 | (37.7451320352893, -122.470929181064) | 1 | 8 | 4 | 29491 | 40 | ||||
1096 | 106130 | Undocumented 4 | Pittosporum spp :: Pittosporum spp 170 | 2402 26TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5988342.2 | 2098891.1 | 37.7424830020357 | -122.482955078155 | (37.7424830020357, -122.482955078155) | 1 | 8 | 3 | 29491 | 35 | |||
1361 | 105851 | Undocumented 4 | Tree(s) :: 17 | 2590 16TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991465.4 | 2097806.4 | 37.7396859298071 | -122.472077039908 | (37.7396859298071, -122.472077039908) | 1 | 8 | 4 | 29491 | 40 | |||||
1477 | 112866 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 750 VICENTE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990595 | 2097751 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | 1 | 8 | 4 | 29491 | 40 | ||||
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 | ||||
1948 | 113530 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 2598x 30TH AVE | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5987135 | 2097625 | 37.7389363086492 | -122.487036198648 | (37.7389363086492, -122.487036198648) | 1 | 8 | 3 | 29491 | 35 | ||||
1969 | 104927 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Gonzalez Dr | 2 | Median : Yard | Tree | Private 2 | 10 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | ||||
2230 | 256764 | Undocumented 4 | Tree(s) :: 17 | 25 Serrano Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/25/2019 12:00:00 AM | 3 | 6x6 | Permit Number 782398 | 5990027 | 2090605 | 37.7198293671123 | -122.476524410241 | (37.7198293671123, -122.476524410241) | 1 | 8 | 4 | 64 | 14 | |
2343 | 99661 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1365 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.465323151466 | (37.7394617231066, -122.465323151466) | 1 | 8 | 4 | 59 | 40 | |||||
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 | ||||
3033 | 121390 | Undocumented 4 | Shrub :: Shrub 66 | 1301x 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993851 | 2106604 | 37.7639796518152 | -122.464467327674 | (37.7639796518152, -122.464467327674) | 1 | 8 | 11 | 56 | 12 | ||||
3085 | 262583 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2801X 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992317 | 2097142 | 37.7379108993029 | -122.469084256099 | (37.7379108993029, -122.469084256099) | 1 | 8 | 4 | 59 | 40 | ||||
3312 | 102758 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1392 09TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5993422.3 | 2106025.2 | 37.7623656970292 | -122.465908002531 | (37.7623656970292, -122.465908002531) | 1 | 8 | 11 | 56 | 12 | |||
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 | ||||
3496 | 98500 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1670 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990941.3 | 2104038.3 | 37.7567667631156 | -122.474343775715 | (37.7567667631156, -122.474343775715) | 1 | 8 | 4 | 56 | 12 | ||||
3790 | 262255 | Undocumented 4 | Tree(s) :: 17 | 4210 Ocean Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
3872 | 262252 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
4084 | 259522 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 309 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994311 | 2099921 | 37.7456563517477 | -122.462391578862 | (37.7456563517477, -122.462391578862) | 1 | 8 | 4 | 29491 | 40 | ||||
4197 | 262260 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 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 | ||
4509 | 262192 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1799x 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992411 | 2103494 | 37.7553572944486 | -122.469221443954 | (37.7553572944486, -122.469221443954) | 1 | 8 | 4 | 56 | 12 | ||||
4569 | 104897 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 303 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 | |||||
4620 | 115387 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 34 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x8 | 5992895.1 | 2098893.2 | 37.7427526388588 | -122.467212790357 | (37.7427526388588, -122.467212790357) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||||||
4872 | 262191 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1799x 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992411 | 2103494 | 37.7553572944486 | -122.469221443954 | (37.7553572944486, -122.469221443954) | 1 | 8 | 4 | 56 | 12 | ||||
4918 | 104883 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 132 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990322.1 | 2090011.1 | 37.7182157760013 | -122.475461023549 | (37.7182157760013, -122.475461023549) | 1 | 8 | 4 | 64 | 14 | |||||
5279 | 258778 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 701X Ortega Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5991876 | 2102480 | 37.7525421857889 | -122.470997752755 | (37.7525421857889, -122.470997752755) | 1 | 8 | 4 | 29491 | 12 | ||||
5330 | 121676 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 65 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993867 | 2101351 | 37.7495571916966 | -122.464030639739 | (37.7495571916966, -122.464030639739) | 1 | 8 | 4 | 29491 | 40 | ||||
6071 | 258212 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2501 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987967 | 2106401 | 37.7630813299835 | -122.484803190012 | (37.7630813299835, -122.484803190012) | 1 | 8 | 3 | 56 | 35 | ||||
6145 | 117568 | Undocumented 4 | Tree(s) :: 17 | 2636 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990923 | 2095039.4 | 37.7320570487265 | -122.473750606168 | (37.7320570487265, -122.473750606168) | 1 | 8 | 4 | 64 | 40 | |||||
6380 | 110632 | Undocumented 4 | Tree(s) :: 17 | 1051X Mandalay Ln | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5991736.20076 | 2101819.33429 | 37.7507200830769 | -122.47143306251 | (37.7507200830769, -122.47143306251) | 1 | 8 | 4 | 29491 | 12 | |||||
6381 | 118299 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 275 OLYMPIA WAY | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996383 | 2101914 | 37.7512477308097 | -122.455370966371 | (37.7512477308097, -122.455370966371) | 1 | 5 | 4 | 63 | 38 | ||||
6387 | 114260 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 800x BROTHERHOOD WAY | 1 | Front Yard : Cutout | Tree | Private 2 | 7 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||||
6537 | 261310 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 1751 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987774 | 2103374 | 37.7547587692818 | -122.485248582837 | (37.7547587692818, -122.485248582837) | 1 | 8 | 3 | 56 | 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 | ||||
7257 | 260076 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 43 Rockwood Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995749 | 2098768 | 37.7425732008551 | -122.457335823598 | (37.7425732008551, -122.457335823598) | 1 | 8 | 4 | 59 | 40 | ||||
7536 | 262249 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 4210 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
8234 | 121391 | Undocumented 4 | Shrub :: Shrub 66 | 1301x 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993851 | 2106604 | 37.7639796518152 | -122.464467327674 | (37.7639796518152, -122.464467327674) | 1 | 8 | 11 | 56 | 12 | ||||
8430 | 112946 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2567 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991374 | 2097953 | 37.7400831663883 | -122.472403743487 | (37.7400831663883, -122.472403743487) | 1 | 8 | 4 | 29491 | 40 | ||||
8486 | 260633 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 801 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991525 | 2103169 | 37.7544136927394 | -122.472261779786 | (37.7544136927394, -122.472261779786) | 1 | 8 | 4 | 56 | 12 | ||||
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 | ||
8597 | 262037 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1002x Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5995668 | 2098205 | 37.7410226892773 | -122.45757517033 | (37.7410226892773, -122.45757517033) | 1 | 7 | 4 | 59 | 40 | ||||
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 | ||||
8847 | 110165 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 129x GARCES DR | 1 | Front Yard : Yard | Tree | Private 2 | 23 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||
9441 | 258084 | Undocumented 4 | Tree(s) :: 17 | 1300x 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1972 12:00:00 AM | 3x3 | 5993647 | 2106626 | 37.7640282963708 | -122.465174495477 | (37.7640282963708, -122.465174495477) | 1 | 8 | 11 | 56 | 12 | |||
9493 | 116897 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 180 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992666 | 2097552 | 37.7390568153225 | -122.467907415395 | (37.7390568153225, -122.467907415395) | 1 | 8 | 4 | 59 | 40 | ||||
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 | ||||
9638 | 254322 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 220 Junipero Serra Blvd | 3 | Median : Cutout | Tree | Private 2 | 10x10 | 5991369 | 2094955 | 37.731851128725 | -122.472202551974 | (37.731851128725, -122.472202551974) | 1 | 8 | 4 | 64 | 40 | ||||
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 | ||||
9803 | 262258 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 Everglade Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
10159 | 262253 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
10436 | 105254 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 130 GONZALEZ DR | Front Yard : Yard | Tree | Private 2 | 2 | 5990327 | 2090136 | 37.7185590045312 | -122.47545320092 | (37.7185590045312, -122.47545320092) | 1 | 8 | 4 | 64 | 14 |
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) );