trees

8,298 rows where qLegalStatus_id = 4 sorted by PlotSize

✎ 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)
65 264979 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2450 California St 1 Front Yard : Yard Tree MTA 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
117 108152 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
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
144 108797 Undocumented 4 :: 45 501-599 University St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008503.45306 2091469.83252 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961) 9 3 7 309 18
148 108238 Undocumented 4 Tree(s) :: 17 764x JUNIPERO SERRA BLVD 1 Median : Yard Tree Private 2           5991289.6 2092496.8 37.7250969308873 -122.472297921456 (37.7250969308873, -122.472297921456) 9 8 4 64 40
159 117627 Undocumented 4 Pinus radiata :: Monterey Pine 15 890x VERMONT ST 4 Unaccepted Street : Yard Tree Private 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
164 116129 Undocumented 4 Tree(s) :: 17 1601X Armstrong Ave 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6014258.08027 2092570.23406 37.7266011147526 -122.392902822978 (37.7266011147526, -122.392902822978) 10 3 8 58 1
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
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
231 116978 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 111 BAY ST 4 Front Yard : Yard Tree Private 2           6010550 2121704 37.8063891294227 -122.407774985143 (37.8063891294227, -122.407774985143) 3 1 10 308 23
233 100684 Undocumented 4 Tree(s) :: 17 400 California St 3 Sidewalk: Curb side : Pot Tree Private 2           6012367 2116823 37.7930886299645 -122.401143699021 (37.7930886299645, -122.401143699021) 4 1 10 28854 6
301 108803 Undocumented 4 :: 45 401-499 University St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008323.15237 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207) 9 3 7 309 28
315 106681 Undocumented 4 Acer spp :: Maple 88 272 COLLINGWOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6002031.2 2104270.9 37.7580416780136 -122.436007529668 (37.7580416780136, -122.436007529668) 2 4 5 28862 3
350 119661 Undocumented 4 Schinus terebinthifolius :: Brazilian Pepper 93 699x Missouri St 2 Sidewalk: Property side : Yard Tree Private 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
359 113255 Undocumented 4 Tree(s) :: 17 178 Edgewood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5996632.6 2106029.8 37.7625629978497 -122.454805165139 (37.7625629978497, -122.454805165139) 15 5 11 29492 12
361 107141 Undocumented 4 Tree(s) :: 17 3498 16TH ST   Sidewalk: Curb side : Cutout Tree Private 2           6003565.7 2106565.7 37.764429704069 -122.430864344516 (37.764429704069, -122.430864344516) 15 4 5 28862 3
380 116339 Undocumented 4 :: 45 1400X Potrero Ave 19 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6010648.28497 2101378.43149 37.7505853701643 -122.406002059271 (37.7505853701643, -122.406002059271) 10 4 8 28859 19
392 108811 Undocumented 4 :: 45 301-399 University St 5 Sidewalk: Curb side : Cutout Tree Private 2           6008160.40727 2092653.74948 37.7264898456848 -122.413988233103 (37.7264898456848, -122.413988233103) 9 3 7 309 28
403 108117 Undocumented 4 Myoporum laetum :: Myoporum 62 148 28TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2           5987142.8 2114987.8 37.7866102289445 -122.488284841308 (37.7866102289445, -122.488284841308) 11 6 1 55 33
427 114621 Undocumented 4 :: 45 2400X Post St 6 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
466 116275 Undocumented 4 :: 45 700X Greenwich St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
1190 107158 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 101x Elsie St 1 Unaccepted Street : Yard Tree Private 2     20     6007300 2098759 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614) 2 7 7 28859 2
1385 101200 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 502 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2           5994231.2 2106687.3 37.7642302811549 -122.463158383346 (37.7642302811549, -122.463158383346) 11 5 11 56 12
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
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
2945 98684 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 40 Bay View St 1 Sidewalk: Curb side : Cutout Tree Private 2           6014207 2094775 37.7326521179743 -122.393233618799 (37.7326521179743, -122.393233618799) 10 3 8 58 1
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                    
3845 105016 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1099X 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2         Marked for a basin expansion. SB 6015050.3 2102960.5 37.755174615412 -122.390889970266 (37.755174615412, -122.390889970266) 10 3 8 28856 29
3865 105892 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1100 Masonic Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5999444.5 2109060.1 37.7710443339737 -122.445297745357 (37.7710443339737, -122.445297745357) 15 5 11 29492 9
4127 74230 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 1011 Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/1996 12:00:00 AM 10     6011143.4423 2118449.9882 37.7974876128867 -122.405491940883 (37.7974876128867, -122.405491940883) 3 1 10 308 23
4337 106918 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 274 PUTNAM ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6009044.8 2096077.1 37.7359392652864 -122.411172625582 (37.7359392652864, -122.411172625582) 10 7 7 28859 2
4438 254757 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2450 California St 13 Front Yard : Yard Tree MTA 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
4476 112909 Undocumented 4 Tree(s) :: 17 1899X Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2                              
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
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
4645 107053 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 450 Walnut St 4 Sidewalk: Curb side : Cutout Tree Private 2           5998625.9783 2115075.11894 37.7875132600186 -122.448562297399 (37.7875132600186, -122.448562297399) 13 6 1 54 31
4670 107425 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 1600X Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2           5997832.17799 2108247.26578 37.7687203321672 -122.450816174345 (37.7687203321672, -122.450816174345) 15 5 11 29492 9
4853 107519 Undocumented 4 Tree(s) :: 17 100x CHURCH ST   Sidewalk: Curb side : Cutout Tree Private 2           6004015.5 2108290.9 37.7691921614924 -122.429431648714 (37.7691921614924, -122.429431648714) 7 9 5 28862 3
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
4983 112267 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
5748 115724 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 250x Octavia St 1 Side Yard : Yard Tree Dept of Real Estate 7                              
5810 111954 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 73 SEACLIFF AVE 4 Sidewalk: Curb side : Cutout Tree Private 2     24     5987709 2115789 37.7888431121968 -122.486384796167 (37.7888431121968, -122.486384796167) 11 6 1 55 33
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
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                    
6361 116132 Undocumented 4 Tree(s) :: 17 1601X Armstrong Ave 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6014258.08027 2092570.23406 37.7266011147526 -122.392902822978 (37.7266011147526, -122.392902822978) 10 3 8 58 1
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
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
6425 102410 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 55X Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2           6000310.8 2109142 37.7713186232103 -122.442307075209 (37.7713186232103, -122.442307075209) 15 5 11 29492 9
7194 117622 Undocumented 4 Pinus radiata :: Monterey Pine 15 890x VERMONT ST 1 Front Yard : Yard Tree Rec/Park 5           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
7315 108963 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2395x 15TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6001858 2107008 37.7655472468341 -122.436802461881 (37.7655472468341, -122.436802461881) 15 5 5 28862 3
7781 102468 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 50 Saint Germain Ave 1 Sidewalk: Property side : Yard Tree Private 2           5998217.7 2104179.8 37.7575741573713 -122.449189617767 (37.7575741573713, -122.449189617767) 15 5 4 28862 38
7827 115725 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 250X Octavia St 2 Side Yard : Yard Tree Dept of Real Estate 7                              
8152 116289 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
8160 107407 Undocumented 4 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 171 TWIN PEAKS BLVD 1 Front Yard : Yard Tree Private 2     12     5998631.4 2104681.4 37.7589750798494 -122.447794991901 (37.7589750798494, -122.447794991901) 15 5 5 28862 12
8269 99967 Undocumented 4 Ficus nitida :: Laurel Fig 53 2270 Folsom St 9 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
8318 98543 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 555 Teresita Blvd 2 Sidewalk: Property side : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
8384 104821 Undocumented 4 Ficus nitida :: Laurel Fig 53 2173 15TH ST   Sidewalk: Curb side : Cutout Tree Private 2     20     6003063.7 2107068.1 37.7657807169148 -122.432636512343 (37.7657807169148, -122.432636512343) 15 5 5 28862 3
8496 115992 Undocumented 4 Ficus nitida :: Laurel Fig 53 438 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2016 12:00:00 AM 3   Permit Number 778644 5989723.9 2112354.3 37.7795296278249 -122.479162248453 (37.7795296278249, -122.479162248453) 11 6 2 55 26
8638 116994 Undocumented 4 Acer rubrum :: Red Maple 75 600M Divisadero St 1 Median : Cutout Tree DPW 1     3     6001630.0135 2110553.7073 37.7752699186497 -122.43784499429 (37.7752699186497, -122.43784499429) 15 5 11 29492 10
8762 97574 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 501x Presidio Ave 4 Sidewalk: Curb side : Cutout Tree Private 2           5999116.8 2114959.9 37.7872249510267 -122.4468558657 (37.7872249510267, -122.4468558657) 15 6 1 54 31
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
9075 121724 Undocumented 4 Prunus persica :: Peach 306 439X ARLINGTON ST 2 Unaccepted Street : Yard Tree Private 2           6003949.9 2096014.9 37.7354814316621 -122.42878329169 (37.7354814316621, -122.42878329169) 2 7 5 63 7
9226 99970 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2270 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
9335 112908 Undocumented 4 Tree(s) :: 17 1899X Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
9359 114615 Undocumented 4 :: 45 2400X Post St 2 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
9503 109132 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 124 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     8     6008117 2098031 37.7412521699945 -122.414518628477 (37.7412521699945, -122.414518628477) 2 7 7 28859 2
9557 112910 Undocumented 4 Tree(s) :: 17 1899X Beach St 3 Sidewalk: Curb side : Cutout Tree Private 2                              
9679 111947 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 95 SEACLIFF AVE 4 Sidewalk: Curb side : Cutout Tree Private 2     30     5987570 2115773 37.7887910778243 -122.486864535179 (37.7887910778243, -122.486864535179) 11 6 1 55 33
9763 111086 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 582X Los Palmos Dr 1 Sidewalk: Curb side : Cutout Tree Private 2           5996560.16999 2095740.09269 37.7343058616961 -122.454312386561 (37.7343058616961, -122.454312386561) 9 7 4 59 40
10205 173902 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 601x Hearst Ave 2 Sidewalk: Curb side : Cutout Tree Private 2                              
10392 111979 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 39 SEACLIFF AVE 2 Sidewalk: Curb side : Cutout Tree Private 2           5987939 2115796 37.788875735681 -122.485589552136 (37.788875735681, -122.485589552136) 11 6 1 55 33
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
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                              
10564 114630 Undocumented 4 :: 45 2400X Post St 16 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
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                    
11053 116828 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 15 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
11207 108105 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 7 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
11227 106481 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 301X LAWTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2           5993233 2104592 37.7584195821345 -122.466458543785 (37.7584195821345, -122.466458543785) 1 8 4 56 12
11335 112269 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 3 Sidewalk: Curb side : Cutout Tree Private 2                              
11479 110887 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 800 INDIANA ST 21 Sidewalk: Property side : Yard Tree Private 2           6014913.4 2104437.2 37.7592217202179 -122.391466645187 (37.7592217202179, -122.391466645187) 10 3 8 28856 29
11756 108765 Undocumented 4 :: 45 500X Lathrop Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
11763 108805 Undocumented 4 :: 45 401-499 University St 6 Sidewalk: Curb side : Cutout Tree Private 2           6008323.15237 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207) 9 3 7 309 28
11776 108812 Undocumented 4 :: 45 301-399 University St 8 Sidewalk: Curb side : Cutout Tree Private 2           6008160.40727 2092653.74948 37.7264898456848 -122.413988233103 (37.7264898456848, -122.413988233103) 9 3 7 309 28
11878 104919 Undocumented 4 Pinus radiata :: Monterey Pine 15 732 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990421 2090607 37.719857702396 -122.475162650507 (37.719857702396, -122.475162650507) 1 8 4 64 40
12051 106705 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 199X BRIGHTON AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     24     5996224 2090880 37.7209419254054 -122.455123542447 (37.7209419254054, -122.455123542447) 9 8 6 28861 24
12107 108213 Undocumented 4 Myoporum laetum :: Myoporum 62 126 Clement St 2 Sidewalk: Curb side : Cutout Tree Private 2           5995164 2113575 37.783195780257 -122.46043122472 (37.783195780257, -122.46043122472) 11 6 2 54 11
12565 104957 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 759 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
12733 102843 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1101X Portola Dr 10 Sidewalk: Property side : Yard Tree DPW 1                              
12759 113115 Undocumented 4 Myoporum laetum :: Myoporum 62 1x TOMASO CT 3 Sidewalk: Property side : Yard Tree Private 2           6009323 2086334 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552) 9 7 8 309 39
13418 111948 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 75 SEACLIFF AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     22     5987695 2115788 37.7888395504461 -122.486433160149 (37.7888395504461, -122.486433160149) 11 6 1 55 33
13665 109201 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 2401x CASTRO ST 4 Median : Yard Tree DPW 1           6002698 2098487 37.7421983129634 -122.433288166914 (37.7421983129634, -122.433288166914) 2 7 5 63 7
13714 116827 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 14 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
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
14324 100848 Undocumented 4 Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 1 Estero Ave 5 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
14439 104509 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 80 DICHIERA CT   Sidewalk: Curb side : Yard Tree Private 2     14     5998620 2088043 37.7132893442667 -122.446637305723 (37.7132893442667, -122.446637305723) 9 7 6 28861 25
14499 114038 Undocumented 4 Pinus radiata :: Monterey Pine 15 2x Moffitt St 3 Side Yard : Yard Tree Private 2     35     6002767.77413 2096661.31369 37.7371893582097 -122.432916509122 (37.7371893582097, -122.432916509122) 2 7 5 63 7
15050 106111 Undocumented 4 Magnolia champaca :: Champa 141 135 MENDOSA AVE 4 Sidewalk: Property side : Yard Tree Private 2         Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40

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