trees
720 rows where qCaretaker_id = 5 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1809 | 120887 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | 9 | 7 | 8 | 309 | 39 | |||
| 3181 | 103180 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987448.1702 | 2104354.2995 | 37.7574314190685 | -122.486447346513 | (37.7574314190685, -122.486447346513) | 1 | 8 | 3 | 56 | 35 | |||
| 4249 | 98418 | DPW Maintained 1 | Tree(s) :: 17 | 1501X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | |||
| 7532 | 9542 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1100X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6003977.1107 | 2112193.8912 | 37.7799066435706 | -122.429842866574 | (37.7799066435706, -122.429842866574) | 7 | 9 | 11 | 29490 | 41 | ||
| 7534 | 238616 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 4302 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 23 | Width 4ft | 6001186.94921 | 2101750.3744 | 37.7510729252903 | -122.438746691333 | (37.7510729252903, -122.438746691333) | 2 | 4 | 5 | 28862 | 22 | |||
| 7553 | 20501 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1204 Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
| 8543 | 20492 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
| 9629 | 103219 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 3 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987198.2105 | 2103866.2266 | 37.7560767305116 | -122.487275946944 | (37.7560767305116, -122.487275946944) | 1 | 8 | 3 | 56 | 35 | |||
| 11538 | 103186 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 0 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | |||
| 12188 | 102373 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983890.73069 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | 11 | 6 | 2 | 55 | 26 | ||||
| 13314 | 75092 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 288 Eddy St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 16 | 6009056.34359 | 2113588.95965 | 37.7840234906369 | -122.412370111692 | (37.7840234906369, -122.412370111692) | 14 | 10 | 9 | 28852 | 36 | ||||
| 17219 | 25457 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/10/1997 12:00:00 AM | 6 | 3X3 | 5993681.7949 | 2088543.8714 | 37.7143812997511 | -122.463741645146 | (37.7143812997511, -122.463741645146) | 9 | 8 | 6 | 64 | 24 | ||
| 17315 | 236909 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1180 Stanyan St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | Width 3ft | 5997408.17858 | 2106084.98197 | 37.7627589713618 | -122.452126715679 | (37.7627589713618, -122.452126715679) | 15 | 5 | 11 | 29492 | 9 | |||
| 18701 | 4660 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 125 | 5X5 | 6009761.7282 | 2119587.7167 | 37.8005341810425 | -122.410353429867 | (37.8005341810425, -122.410353429867) | 3 | 1 | 10 | 308 | 23 | |||
| 18894 | 9449 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 5 | Front Yard : Yard | Tree | Rec/Park 5 | 12 | 3X3 | 6005556.1262 | 2112420.5622 | 37.780618317973 | -122.424396471178 | (37.780618317973, -122.424396471178) | 7 | 9 | 11 | 28852 | 41 | |||
| 20308 | 103199 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 19 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
| 20492 | 108957 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
| 20532 | 20482 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 42 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
| 24926 | 254202 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1180 Stanyan St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Width 3ft | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
| 24931 | 98427 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1401X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | |||
| 24958 | 99241 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 560X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10 | 4x4 | 6008235.1228 | 2113825.75072 | 37.7846275436788 | -122.415228013286 | (37.7846275436788, -122.415228013286) | 7 | 10 | 9 | 28858 | 36 | |||
| 25869 | 102376 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 38th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 5984157.51207 | 2109978.36457 | 37.7726811489417 | -122.498242937742 | (37.7726811489417, -122.498242937742) | 11 | 6 | 2 | 55 | 26 | ||||
| 26044 | 9456 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005442.4 | 2112406.4818 | 37.7805732339777 | -122.424788902821 | (37.7805732339777, -122.424788902821) | 7 | 9 | 11 | 28852 | 41 | ||
| 26553 | 103213 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 27281 | 103222 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 8 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987186.3641 | 2104162.3873 | 37.7568892163494 | -122.487338668246 | (37.7568892163494, -122.487338668246) | 1 | 8 | 3 | 56 | 35 | |||
| 28157 | 98421 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501X Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | |||
| 28941 | 103177 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2201 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 29082 | 101513 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 240X DRUMM ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6013870 | 2117910 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | 3 | 1 | 10 | 28860 | 6 | ||||
| 30472 | 100032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 3x3 | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | ||
| 30841 | 87987 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300x Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/23/2015 03:33:00 PM | 3 | 3x3 | Permit Number 51027 | 6008990.567 | 2113714.34992 | 37.7843640908799 | -122.412606542572 | (37.7843640908799, -122.412606542572) | 14 | 10 | 9 | 28852 | 36 | |
| 31421 | 20481 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
| 32309 | 88409 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009413.9789 | 2117291.03714 | 37.7942085637169 | -122.41139444529 | (37.7942085637169, -122.41139444529) | 3 | 1 | 10 | 28857 | 21 | |
| 32831 | 20504 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1203X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/02/1991 12:00:00 AM | 18 | 10 | 5984781.8902056 | 2107224.2505442 | 37.7651557239541 | -122.495879974111 | (37.7651557239541, -122.495879974111) | 11 | 6 | 2 | 55 | 8 | ||
| 34134 | 103185 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 0 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | |||
| 34971 | 103197 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 15 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
| 36156 | 22614 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.7813650138202 | -122.424863625752 | (37.7813650138202, -122.424863625752) | 7 | 9 | 11 | 28852 | 41 | |||
| 36237 | 22616 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1001 Turk St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005581.297 | 2112717.6262 | 37.7814354041528 | -122.424330527926 | (37.7814354041528, -122.424330527926) | 7 | 9 | 11 | 28852 | 41 | |||
| 37487 | 20499 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
| 37714 | 120886 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009795.1369 | 2087583.7508 | 37.7126603570018 | -122.407979633406 | (37.7126603570018, -122.407979633406) | 9 | 7 | 8 | 309 | 39 | |||
| 37847 | 26134 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1506 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/22/1997 12:00:00 AM | 6 | 3x3 | 6015502.3956 | 2095169.2882 | 37.7338066348029 | -122.388782595026 | (37.7338066348029, -122.388782595026) | 10 | 3 | 8 | 58 | 1 | ||
| 38453 | 20514 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1211X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
| 39579 | 5439 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 500X Dolores St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/01/1990 12:00:00 AM | 45 | 6 | 6004897.25501 | 2105174.42186 | 37.7606849395651 | -122.426159805147 | (37.7606849395651, -122.426159805147) | 2 | 4 | 5 | 28862 | 3 | ||
| 39958 | 20469 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1203X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
| 40789 | 9455 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005466.2284 | 2112408.648 | 37.7805805276453 | -122.424706623116 | (37.7805805276453, -122.424706623116) | 7 | 9 | 11 | 28852 | 41 | ||
| 42048 | 98424 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501X Steiner St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | ||||
| 42087 | 88407 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | 3 | 1 | 10 | 28857 | 21 | |
| 44049 | 26131 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | 10 | 3 | 8 | 58 | 1 | |||
| 44456 | 37238 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 2 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 11 | Permit Number 770085 | 5987346.2909 | 2103736.5081 | 37.7557291928217 | -122.48675431687 | (37.7557291928217, -122.48675431687) | 1 | 8 | 3 | 56 | 35 | ||
| 44769 | 20157 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1100X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 4X4 | 6002895.0285 | 2112125.5503 | 37.7796576600117 | -122.433581380876 | (37.7796576600117, -122.433581380876) | 15 | 9 | 11 | 29490 | 41 | |||
| 44827 | 103231 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 22 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
| 44854 | 101512 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 240X DRUMM ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6013870 | 2117910 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | 3 | 1 | 10 | 28860 | 6 | ||||
| 45125 | 139199 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1900 GEARY BLVD | 27 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 19 | Width 0ft | 6001773.0984 | 2113703.8723 | 37.7839276110688 | -122.437575676931 | (37.7839276110688, -122.437575676931) | 13 | 5 | 11 | 29490 | 13 | |||
| 46680 | 102369 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | Permit Number 769895 | 5984151.59861 | 2110096.53732 | 37.773005270668 | -122.498272122211 | (37.773005270668, -122.498272122211) | 11 | 6 | 2 | 55 | 26 | |||
| 46999 | 103223 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 9 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987183.9948 | 2104224.5811 | 37.7570598454095 | -122.487351430278 | (37.7570598454095, -122.487351430278) | 1 | 8 | 3 | 56 | 35 | |||
| 47944 | 103206 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10 | 3x4 | 5987202.3567 | 2103753.0931 | 37.7557663384655 | -122.487253298879 | (37.7557663384655, -122.487253298879) | 1 | 8 | 3 | 56 | 35 | |||
| 48034 | 98430 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1401X Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | ||||
| 48907 | 103190 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 4 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987454.6857 | 2104172.4568 | 37.7569325082599 | -122.486411463243 | (37.7569325082599, -122.486411463243) | 1 | 8 | 3 | 56 | 35 | |||
| 49590 | 7378 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6010884.8623 | 2111505.4176 | 37.7784050126686 | -122.40589724881 | (37.7784050126686, -122.40589724881) | 14 | 2 | 9 | 28853 | 34 | |||
| 49997 | 8489 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1900X Geary Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6002220.6585 | 2113766.2282 | 37.7841242607304 | -122.436031749589 | (37.7841242607304, -122.436031749589) | 13 | 5 | 11 | 29490 | 13 | |||
| 50658 | 9541 | DPW Maintained 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/02/2014 12:00:00 AM | 3 | 3X3 | Permit Number 771276 | 6003998.856 | 2112198.1457 | 37.7799195567604 | -122.429767943463 | (37.7799195567604, -122.429767943463) | 7 | 9 | 11 | 29490 | 41 | |
| 50955 | 103191 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 6 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 10 | 3x4 | 5987457.055 | 2104097.8243 | 37.7567277258047 | -122.486397790192 | (37.7567277258047, -122.486397790192) | 1 | 8 | 3 | 56 | 35 | |||
| 51716 | 9452 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6005518.2175 | 2112416.7713 | 37.7806057683483 | -122.424527345883 | (37.7806057683483, -122.424527345883) | 7 | 9 | 11 | 28852 | 41 | ||
| 51939 | 103193 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 11 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 10 | 3x4 | 5987467.1245 | 2103820.0255 | 37.7559655526687 | -122.486342572342 | (37.7559655526687, -122.486342572342) | 1 | 8 | 3 | 56 | 35 | |||
| 52190 | 98423 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1501X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | ||
| 55300 | 97892 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401x Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/02/2010 12:00:00 AM | 8 | 3x3 | Permit Number 55034 | 6002514.74306 | 2090342.41745 | 37.7198247442045 | -122.433339952791 | (37.7198247442045, -122.433339952791) | 9 | 7 | 6 | 28861 | 5 | |
| 55400 | 18519 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6009627.5943 | 2119520.0726 | 37.8003409270103 | -122.410812809398 | (37.8003409270103, -122.410812809398) | 3 | 1 | 10 | 308 | 4 | |||
| 56308 | 20477 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1203X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
| 56700 | 102371 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 38th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | Permit Number 769895 | 5984153.68011 | 2110075.48808 | 37.7729475975471 | -122.498263367238 | (37.7729475975471, -122.498263367238) | 11 | 6 | 2 | 55 | 26 | |||
| 56794 | 103220 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 5 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 12 | 3x4 | 5987192.8796 | 2103980.5446 | 37.7563903057657 | -122.487302779252 | (37.7563903057657, -122.487302779252) | 1 | 8 | 3 | 56 | 35 | |||
| 57148 | 20462 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1202X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 10 | 5984687.1705981 | 2107256.1433532 | 37.7652377447603 | -122.496209934631 | (37.7652377447603, -122.496209934631) | 11 | 6 | 2 | 55 | 8 | |||
| 58107 | 108955 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
| 58393 | 26916 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1901 Geary Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6002555.1851 | 2113680.9302 | 37.783909052953 | -122.434868307044 | (37.783909052953, -122.434868307044) | 13 | 5 | 11 | 29490 | 41 | |||
| 59197 | 20485 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
| 60944 | 103228 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 16 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 61115 | 98428 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1401X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | ||||
| 61182 | 120889 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009853.959 | 2087561.9153 | 37.7126036943297 | -122.407774785999 | (37.7126036943297, -122.407774785999) | 9 | 7 | 8 | 309 | 39 | |||
| 61236 | 120890 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009870.8927 | 2087557.0134 | 37.71259118268 | -122.40771591214 | (37.71259118268, -122.40771591214) | 9 | 7 | 8 | 309 | 39 | |||
| 61521 | 9534 | DPW Maintained 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/02/2014 12:00:00 AM | 6 | 3X3 | Permit Number 771276 | 6004154.8546 | 2112220.8365 | 37.779990692526 | -122.429229893302 | (37.779990692526, -122.429229893302) | 7 | 9 | 11 | 29490 | 41 | |
| 61866 | 5444 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500X Dolores St | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 6 | 6004913.15076 | 2105006.62195 | 37.7602250991358 | -122.426092882994 | (37.7602250991358, -122.426092882994) | 2 | 4 | 5 | 28862 | 3 | |||
| 62906 | 20507 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
| 63127 | 5445 | DPW Maintained 1 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 500X Dolores St | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/20/1990 12:00:00 AM | 8 | 6 | 6004913.51654 | 2104964.38719 | 37.7601091531428 | -122.426088611215 | (37.7601091531428, -122.426088611215) | 2 | 4 | 5 | 28862 | 3 | ||
| 63301 | 103211 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 63439 | 9536 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1100X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004118.455 | 2112215.6365 | 37.779974353933 | -122.42935544492 | (37.779974353933, -122.42935544492) | 7 | 9 | 11 | 29490 | 41 | ||
| 66533 | 103176 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2201 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 66825 | 103208 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x4 | 5987188.7333 | 2104102.5628 | 37.7567250927297 | -122.487326080643 | (37.7567250927297, -122.487326080643) | 1 | 8 | 3 | 56 | 35 | |||
| 68153 | 103229 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 18 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
| 68608 | 20475 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1203X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
| 68892 | 102368 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 4 | Permit Number 769895 | 5984151.13176 | 2110133.93549 | 37.7731079279349 | -122.49827649972 | (37.7731079279349, -122.49827649972) | 11 | 6 | 2 | 55 | 26 | |||
| 69907 | 22615 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | 7 | 9 | 11 | 28852 | 41 | |||
| 71193 | 5442 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500X Dolores St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 6 | 6004907.01705 | 2105068.65381 | 37.7603950772802 | -122.426118512771 | (37.7603950772802, -122.426118512771) | 2 | 4 | 5 | 28862 | 3 | |||
| 71695 | 100034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 72745 | 102377 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 870 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 5983889.8768 | 2109995.31333 | 37.7727119887219 | -122.499169955109 | (37.7727119887219, -122.499169955109) | 11 | 6 | 2 | 55 | 26 | ||||
| 74199 | 764 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.7641835827447 | -122.496433785178 | (37.7641835827447, -122.496433785178) | 1 | 8 | 3 | 56 | 35 | |||
| 75072 | 20470 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1203X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.495883339617 | (37.7652050441375, -122.495883339617) | 11 | 6 | 2 | 55 | 8 | |||
| 76512 | 22419 | DPW Maintained 1 | Tristania conferta :: 61 | 5815 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/19/2000 12:00:00 AM | 3 | 3x3 | 6013854.3759 | 2092034.5068 | 37.7251076834032 | -122.394260933329 | (37.7251076834032, -122.394260933329) | 10 | 3 | 8 | 58 | 1 | ||
| 76887 | 9451 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005532.2979 | 2112418.9375 | 37.7806125113537 | -122.424478789137 | (37.7806125113537, -122.424478789137) | 7 | 9 | 11 | 28852 | 41 | ||
| 77265 | 20512 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1211X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
| 77305 | 5434 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 500X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/14/2009 12:00:00 AM | 3 | 6 | 6004889.66204 | 2105352.28361 | 37.7611728766429 | -122.426198728713 | (37.7611728766429, -122.426198728713) | 2 | 4 | 5 | 28862 | 3 | ||
| 78037 | 103221 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 6 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 11 | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | |
| 78077 | 37236 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 8 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | Permit Number 770085 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );