trees
8,298 rows where qLegalStatus_id = 4 sorted by PlotSize
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 |
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) );