trees
720 rows where qCaretaker_id = 5
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35850 | 17721 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300X Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3 | 3X3 | Permit Number 768629 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | |
35969 | 29068 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1091X Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004816.84954 | 2112603.0518286 | 37.7810776154036 | -122.426966984587 | (37.7810776154036, -122.426966984587) | 7 | 9 | 11 | 28852 | 41 | ||
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 | |||
37083 | 8501 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1950X Geary Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6002386.4460269 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | 13 | 5 | 11 | 29490 | 13 | |||
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 | |||
39435 | 26643 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2199X Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | ||
39568 | 8500 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1950X Geary Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6002386.4460269 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | 13 | 5 | 11 | 29490 | 13 | |||
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 | ||
39604 | 116148 | Undocumented 4 | Tree(s) :: 17 | 3800X 20th St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004661.9257 | 2104258.88373 | 37.7581577845713 | -122.426908497787 | (37.7581577845713, -122.426908497787) | 2 | 4 | 5 | 28862 | 3 | |||||
39830 | 116130 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 2 | 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 | |||||
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 | |||
40034 | 116284 | Undocumented 4 | :: 45 | 700X Greenwich St | 11 | 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 | |||||
40222 | 87642 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1002X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004813.344433 | 2112300.663017 | 37.7802471321724 | -122.426957567511 | (37.7802471321724, -122.426957567511) | 7 | 9 | 11 | 28852 | 41 | |||||
40310 | 13074 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 645X Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | |||
40573 | 12056 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1330X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6016860.8582794 | 2094712.6673543 | 37.732628043472 | -122.384054150964 | (37.732628043472, -122.384054150964) | 10 | 3 | 8 | 58 | 1 | |||
40623 | 2804 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1070X California St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 50 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | 5 | 1 | 10 | 28857 | 21 | |||
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 | ||
41196 | 100784 | Permitted Site 7 | Tree(s) :: 17 | 2101 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
41340 | 26143 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Oakdale Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
41503 | 22401 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | 10 | 3 | 8 | 58 | 1 | |||
41679 | 26313 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
41809 | 106281 | Undocumented 4 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 | 399X Elliot St | 2 | Unaccepted Street : Yard | Tree | Rec/Park 5 | Permit Number 772905 | 6008798.75873 | 2088103.62049 | 37.7140319762934 | -122.411460149363 | (37.7140319762934, -122.411460149363) | 9 | 7 | 8 | 309 | 39 | ||||
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 | |
42614 | 13380 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1000X Mansell St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
44022 | 17728 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300X Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 05/20/1992 12:00:00 AM | 70 | 3X3 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | ||
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 | ||
44726 | 8521 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.437805961288 | (37.7836169980675, -122.437805961288) | 15 | 5 | 11 | 29490 | 41 | ||
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 | ||||
45000 | 26304 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
45374 | 112650 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 3100X 26TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008747 | 2100981 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | 2 | 4 | 7 | 28859 | 19 | ||||
45542 | 8492 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1950X Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6002386.4460269 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | 13 | 5 | 11 | 29490 | 13 | |||
45808 | 113977 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1180 STANYAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
45892 | 116291 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 7 | 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 | |||||
45983 | 12055 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1300X La Salle Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6016940.8085131 | 2094664.4394135 | 37.7325000389111 | -122.383774384054 | (37.7325000389111, -122.383774384054) | 10 | 3 | 8 | 58 | 1 | |||
46100 | 83398 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4244X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/12/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50813 | 6001912 | 2104709 | 37.7592378221466 | -122.436451128899 | (37.7592378221466, -122.436451128899) | 2 | 4 | 5 | 28862 | 3 | |
46453 | 26644 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2199X Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 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 | |||
46841 | 8522 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1901 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.437805961288 | (37.7836169980675, -122.437805961288) | 15 | 5 | 11 | 29490 | 41 | |||
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 | |||
47426 | 693 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1299X Potrero Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x3 | 6010664.7611959 | 2101498.8811325 | 37.7509170198962 | -122.405953567035 | (37.7509170198962, -122.405953567035) | 10 | 4 | 8 | 28859 | 19 | |||
47489 | 17723 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 90 | 3X3 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | |||
47663 | 9776 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
47978 | 116279 | Undocumented 4 | :: 45 | 700X Greenwich St | 6 | 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 | |||||
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 | ||||
48241 | 114478 | Undocumented 4 | Washingtonia filifera :: California Fan Palm 176 | 45 HOFF ST | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6006591 | 2106401 | 37.7641484227608 | -122.420388955837 | (37.7641484227608, -122.420388955837) | 8 | 4 | 7 | 28859 | 19 | ||||
48323 | 24932 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/22/1996 12:00:00 AM | 18 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
48387 | 116276 | Undocumented 4 | :: 45 | 700X Greenwich St | 3 | 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 | |||||
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 | |||
49202 | 26306 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
49683 | 116229 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1699 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | 13 | 9 | 11 | 29490 | 13 | |||||
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 | |||
50010 | 85052 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 355x Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/27/2007 12:00:00 AM | Permit Number 49332 | 6004826.8 | 2109751.4 | 37.7732482408903 | -122.426729425627 | (37.7732482408903, -122.426729425627) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |
50787 | 24935 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | |||
50831 | 102162 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 4300X 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 5x5 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
51285 | 26645 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2199X Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/22/1998 12:00:00 AM | 6 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | ||
51294 | 9477 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 33 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 05/18/1992 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
51368 | 102161 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 4300X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 5x5 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
51845 | 116302 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1550 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | |||||
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 | ||
52254 | 117170 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
52303 | 27772 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | |||
52462 | 116125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
53280 | 9479 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 35 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/28/1998 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
54379 | 8498 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1950X Geary Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6002386.4460269 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | 13 | 5 | 11 | 29490 | 13 | |||
54626 | 116326 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 6 | 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 | |||||
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 | |||
55561 | 99240 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10 | 4x4 | 6008281 | 2113828 | 37.7846362978531 | -122.415069452341 | (37.7846362978531, -122.415069452341) | 7 | 10 | 9 | 28858 | 36 | |||
55601 | 26299 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
55646 | 111811 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
55728 | 102159 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 4300X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 34 | 6x6 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 | |||
56128 | 116290 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 6 | 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 | |||||
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 | |||
56373 | 24927 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | |||
56409 | 26824 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000X San Jose Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/25/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
57240 | 24925 | Permitted Site 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 2099X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/09/1996 12:00:00 AM | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
57355 | 27773 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | |||
57733 | 29065 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1001X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138357 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | 7 | 9 | 11 | 29490 | 41 | ||
57860 | 13384 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1000X Mansell St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
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 | |||
59108 | 109457 | Undocumented 4 | Eucalyptus cinerea :: Ash-colored Eucalyptus 142 | 951 GILMAN AVE | 43 | Front Yard : Yard | Tree | Rec/Park 5 | 23 | 6015934 | 2089205 | 37.7174537876507 | -122.386874585955 | (37.7174537876507, -122.386874585955) | 10 | 3 | 8 | 58 | 1 |
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) );