trees
203 rows where qCaretaker_id = 14 sorted by PlantDate descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
52668 | 113708 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
54557 | 246846 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 8 | : | Tree | DPW for City Agency 14 | 14 | Width 3ft | 6001207.38463 | 2109809.38993 | 37.7732021687661 | -122.439253599591 | (37.7732021687661, -122.439253599591) | 15 | 5 | 11 | 29492 | 10 | |||
55624 | 246843 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 5 | : | Tree | DPW for City Agency 14 | 9 | Width 3ft | 6001198.91277 | 2109877.26909 | 37.7733880658265 | -122.439287771129 | (37.7733880658265, -122.439287771129) | 15 | 5 | 11 | 29492 | 10 | |||
56181 | 110400 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 419X 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 28 | 3x3 | 5990269.5497 | 2112500.03817 | 37.7799614584413 | -122.477285287094 | (37.7799614584413, -122.477285287094) | 11 | 6 | 2 | 55 | 26 | ||
56512 | 251807 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 2 Hangah St | 1 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
56631 | 110401 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 419X 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 27 | 3x3 | 5990271.90904 | 2112469.3758 | 37.7798774049655 | -122.4772748837 | (37.7798774049655, -122.4772748837) | 11 | 6 | 2 | 55 | 26 | ||
56896 | 98734 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 14 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | 7 | 9 | 11 | 28852 | 10 | |||
57725 | 109996 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
62704 | 98219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
63694 | 109991 | Undocumented 4 | Quercus spp :: Oak 254 | 501X Shotwell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
64581 | 99308 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1902X 41st Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
65235 | 113871 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
65648 | 98733 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 13 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | 7 | 9 | 11 | 28852 | 10 | |||
67675 | 110738 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
72030 | 109988 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
72776 | 111589 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 730X Lake Merced Blvd | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | Permit Number 774260 | 5987577.49507 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | 1 | 8 | 4 | 64 | 14 | |||
73737 | 113813 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
74558 | 111133 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
75284 | 113868 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
76955 | 99004 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
77560 | 95038 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
78158 | 113866 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
78336 | 98729 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 13 | 3x3 | 6006140.89781 | 2111454.63858 | 37.7779991309825 | -122.422304815319 | (37.7779991309825, -122.422304815319) | 7 | 9 | 11 | 28852 | 10 | |||
82558 | 98222 | DPW Maintained 1 | Eucalyptus macarthuri :: Camden Wollybutt 516 | 1501X 42nd Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
83447 | 109986 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
83791 | 98908 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
87127 | 99008 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
87682 | 113810 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4101x 25TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |||
87780 | 95040 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 13 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
88826 | 111588 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 730X Lake Merced Blvd | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 48 | 5987577.49507 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | 1 | 8 | 4 | 64 | 14 | |||
89248 | 109987 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
89407 | 98217 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
94178 | 98727 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 12 | 3x3 | 6006176.94483 | 2111455.11485 | 37.7780024719703 | -122.422180149508 | (37.7780024719703, -122.422180149508) | 7 | 9 | 11 | 28852 | 10 | |||
95680 | 110403 | Undocumented 4 | Ficus laurel :: 247 | 419X 18TH AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 22 | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | ||
100634 | 110538 | Undocumented 4 | Tree(s) :: 17 | 100X ASHBURY ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | City College | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |||
101614 | 113808 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4101x 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
105081 | 97214 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300X Claremont Blvd | 1 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 12 | 5993486 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | 1 | 8 | 4 | 59 | 40 | ||||
111013 | 113867 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
113343 | 113820 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 4101x 25TH ST | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
114447 | 97215 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 300X Claremont Blvd | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 20 | 4x12 | 5993486 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | 1 | 8 | 4 | 59 | 40 | |||
114523 | 110402 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 419X 18TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
116486 | 109999 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 501X Shotwell St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | ||||
116839 | 99309 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
117136 | 109995 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
117870 | 113873 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
119304 | 111381 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 3 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
120864 | 113819 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4101x 25TH ST | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 7 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
120981 | 95046 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 10 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 13 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
122270 | 95039 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
124026 | 110739 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
124030 | 98735 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 12 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | 7 | 9 | 11 | 28852 | 10 | |||
124997 | 113812 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4101x 25TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 1 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
127023 | 251811 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 4 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
127072 | 246842 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 4 | : | Tree | DPW for City Agency 14 | 15 | Width 4ft | 6001208.43411 | 2109888.06605 | 37.7734182533891 | -122.439255609578 | (37.7734182533891, -122.439255609578) | 15 | 5 | 11 | 29492 | 10 | |||
128478 | 111134 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
128716 | 108973 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 3485X SAN BRUNO AVE | 1 | Median : Yard | Tree | DPW for City Agency 14 | 6011510 | 2091910 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | 10 | 3 | 7 | 309 | 28 | |||||
128875 | 251813 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 2 Hangah St | 6 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
129349 | 95041 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
130117 | 113705 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | ||
135544 | 98731 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 13 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | 7 | 9 | 11 | 28852 | 10 | |||
139078 | 246847 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 9 | : | Tree | DPW for City Agency 14 | 9 | Width 3ft | 6001212.96216 | 2109784.10249 | 37.7731330531814 | -122.439232493392 | (37.7731330531814, -122.439232493392) | 15 | 5 | 11 | 29492 | 10 | |||
139329 | 110406 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 419X 18TH AVE | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
140109 | 246844 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 6 | : | Tree | DPW for City Agency 14 | 17 | Width 3ft | 6001203.63374 | 2109838.69012 | 37.7732824062979 | -122.439268674924 | (37.7732824062979, -122.439268674924) | 15 | 5 | 11 | 29492 | 10 | |||
141424 | 95044 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 6 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
141721 | 98795 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 950@Washington Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | |||
142881 | 95042 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 11 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
143725 | 113706 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
144228 | 251810 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 3 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
147039 | 98216 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1501X 42nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x12 | 5983098.741 | 2104521.6922 | 37.7576365448231 | -122.501501543012 | (37.7576365448231, -122.501501543012) | 1 | 8 | 3 | 56 | 35 | ||
147165 | 98995 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2190X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6000922.9 | 2115860.7 | 37.7898013277865 | -122.44067180053 | (37.7898013277865, -122.44067180053) | 13 | 6 | 1 | 29490 | 27 | ||||
147322 | 113872 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
148472 | 113707 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
152081 | 111131 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
152463 | 109989 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
152631 | 98218 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1501X 42nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 3 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
152727 | 99006 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
153397 | 98220 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1501X 42nd Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
153582 | 246840 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 2 | : | Tree | DPW for City Agency 14 | 19 | Width 3ft | 6001188.51269 | 2109936.21842 | 37.7735493340682 | -122.43932797262 | (37.7735493340682, -122.43932797262) | 15 | 5 | 11 | 29492 | 10 | |||
154938 | 113811 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
155237 | 97217 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 300X Claremont Blvd | 4 | Back Yard : Cutout | Tree | DPW for City Agency 14 | 18 | 5993486 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | 1 | 8 | 4 | 59 | 40 | ||||
157876 | 111096 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 SAINT CHARLES AVE | 31 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 15 | 5992079 | 2088073 | 37.7129959107362 | -122.469247237289 | (37.7129959107362, -122.469247237289) | 9 | 8 | 6 | 64 | 24 | |||
158133 | 246849 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 11 | : | Tree | DPW for City Agency 14 | 9 | Width 3ft | 6001216.86576 | 2109748.14467 | 37.7730345441487 | -122.439216412614 | (37.7730345441487, -122.439216412614) | 15 | 5 | 11 | 29492 | 10 | |||
158369 | 113869 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
167224 | 110540 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 100X ASHBURY ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | City College | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |||
168033 | 111379 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 1 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
168582 | 251809 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 2 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
175403 | 111129 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
175720 | 113865 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
175730 | 254646 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 Saint Charles Ave | 31 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Private | 3x3 | 5992096 | 2088072 | 37.7129941473192 | -122.469188407447 | (37.7129941473192, -122.469188407447) | 9 | 8 | 6 | 64 | 24 | |||
176309 | 97216 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 300X Claremont Blvd | 3 | Back Yard : Cutout | Tree | DPW for City Agency 14 | 5993486 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | 1 | 8 | 4 | 59 | 40 | |||||
177165 | 109994 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
177608 | 113816 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
177877 | 113822 | Undocumented 4 | Melaleuca spp :: Melaleuca spp 117 | 4101x 25TH ST | 15 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 7 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
179503 | 113815 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 4101x 25TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 8 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
180245 | 110414 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 419X 18TH AVE | 15 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
181717 | 246848 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 10 | : | Tree | DPW for City Agency 14 | 14 | Width 3ft | 6001221.88417 | 2109765.97896 | 37.7730837982073 | -122.439200331843 | (37.7730837982073, -122.439200331843) | 15 | 5 | 11 | 29492 | 10 | |||
185385 | 111132 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
187982 | 173659 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 200 Lawton St | 1 | Median : Cutout | Tree | DPW for City Agency 14 | 5993693.06683 | 2104628.21116 | 37.7585455452803 | -122.46487007072 | (37.7585455452803, -122.46487007072) | 1 | 8 | 4 | 56 | 12 | |||||
191754 | 98730 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 13 | 3x3 | 6006126.24494 | 2111454.93961 | 37.7779991309912 | -122.422355526279 | (37.7779991309912, -122.422355526279) | 7 | 9 | 11 | 28852 | 10 | |||
192386 | 98223 | DPW Maintained 1 | Eucalyptus macarthuri :: Camden Wollybutt 516 | 1501X 42nd Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 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) );