8,298 rows where qLegalStatus_id = 4 sorted by Fire Prevention Districts

View and edit SQL

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

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