trees
1,098 rows where qCaretaker_id = 4 sorted by TreeID 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66131 | 99697 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1451 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6007296.6569 | 2117418.12417 | 37.794438530258 | -122.418729647781 | (37.794438530258, -122.418729647781) | 5 | 1 | 10 | 28858 | 32 | ||
| 70628 | 99696 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1451 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 6007201.17567 | 2117403.71838 | 37.7943935992302 | -122.419059002888 | (37.7943935992302, -122.419059002888) | 5 | 1 | 10 | 28858 | 32 | ||
| 39397 | 99695 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.418784695641 | (37.7936275055362, -122.418784695641) | 5 | 1 | 10 | 28858 | 32 | ||
| 118273 | 99694 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.418784695641 | (37.7936275055362, -122.418784695641) | 5 | 1 | 10 | 28858 | 32 | ||
| 77066 | 99693 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.418784695641 | (37.7936275055362, -122.418784695641) | 5 | 1 | 10 | 28858 | 32 | ||
| 3327 | 99692 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 2x2 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.418784695641 | (37.7936275055362, -122.418784695641) | 5 | 1 | 10 | 28858 | 32 | ||
| 24846 | 99691 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 3x3 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.418784695641 | (37.7936275055362, -122.418784695641) | 5 | 1 | 10 | 28858 | 32 | ||
| 94523 | 99689 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150X Alma St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 171377 | 99688 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
| 99360 | 99687 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
| 157508 | 99686 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
| 193525 | 99685 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
| 23622 | 99684 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/04/2013 12:00:00 AM | 8 | 3x3 | Permit Number 770537 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 |
| 67135 | 99683 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/04/2013 12:00:00 AM | 8 | 3x3 | Permit Number 770537 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 |
| 180042 | 99682 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 165 Grattan St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
| 97987 | 99681 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Grattan St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
| 183108 | 99680 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Grattan St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
| 79000 | 99679 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 165 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
| 52988 | 99678 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1250X Shrader St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | Permit Number 770537 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | |
| 56802 | 99677 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/04/2013 12:00:00 AM | 16 | 3x3 | Permit Number 770537 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 |
| 24577 | 99676 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 117961 | 99675 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 37865 | 99674 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 4x4 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 176228 | 99673 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 4x4 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 150789 | 99672 | DPW Maintained 1 | Shrub :: Shrub 66 | 1250X Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 45783 | 99671 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150X Alma St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 114759 | 99670 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 175889 | 99669 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x6 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 167 | 99668 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 55011 | 99667 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 81109 | 99665 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 66778 | 99664 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997932 | 2106516 | 37.7639724300488 | -122.450346083136 | (37.7639724300488, -122.450346083136) | 15 | 5 | 11 | 29492 | 9 | ||
| 111362 | 99557 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | ||
| 157537 | 99556 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | ||
| 122873 | 99555 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | ||
| 115483 | 99554 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 20 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | ||
| 100854 | 99553 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | ||
| 44657 | 99552 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12/28/2016 06:02:00 AM | 3 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | |
| 45651 | 99551 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 26 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | ||
| 67735 | 99550 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 200X Henry St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/19/2016 04:45:00 AM | 3 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | |
| 26191 | 99549 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 20 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | ||
| 83391 | 99548 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | ||
| 192623 | 99547 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | ||
| 50176 | 99498 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 125 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6002794.02408 | 2092508.79842 | 37.7257889832596 | -122.432529234659 | (37.7257889832596, -122.432529234659) | 9 | 7 | 6 | 28861 | 5 | ||
| 126742 | 99373 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X 29th Ave | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986859.5 | 2112566.5 | 37.7799454996166 | -122.489086903101 | (37.7799454996166, -122.489086903101) | 11 | 6 | 2 | 55 | 26 | ||
| 18070 | 99372 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X 29th Ave | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 5986859.5 | 2112566.5 | 37.7799454996166 | -122.489086903101 | (37.7799454996166, -122.489086903101) | 11 | 6 | 2 | 55 | 26 | ||
| 34496 | 99371 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 25 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986853.20034 | 2112633.29686 | 37.7801285370834 | -122.489113608336 | (37.7801285370834, -122.489113608336) | 11 | 6 | 2 | 55 | 26 | ||
| 71997 | 99370 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986851.72562 | 2112647.47743 | 37.7801673868145 | -122.489119752829 | (37.7801673868145, -122.489119752829) | 11 | 6 | 2 | 55 | 26 | ||
| 188415 | 99369 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 5986847.81361 | 2112672.32158 | 37.7802353734381 | -122.489135113122 | (37.7802353734381, -122.489135113122) | 11 | 6 | 2 | 55 | 26 | ||
| 142644 | 99368 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986849.57732 | 2112692.62378 | 37.7802912204421 | -122.489130504747 | (37.7802912204421, -122.489130504747) | 11 | 6 | 2 | 55 | 26 | ||
| 44884 | 99367 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986848.24353 | 2112713.43374 | 37.7803482808136 | -122.489136649255 | (37.7803482808136, -122.489136649255) | 11 | 6 | 2 | 55 | 26 | ||
| 176883 | 99366 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986848.25067 | 2112734.65735 | 37.7804065552175 | -122.489138185351 | (37.7804065552175, -122.489138185351) | 11 | 6 | 2 | 55 | 26 | ||
| 136557 | 99365 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986845.14154 | 2112755.50502 | 37.7804636155038 | -122.489150474302 | (37.7804636155038, -122.489150474302) | 11 | 6 | 2 | 55 | 26 | ||
| 143111 | 99364 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | Permit Number 773617 | 5986846.87705 | 2112774.48123 | 37.7805158200694 | -122.489145865965 | (37.7805158200694, -122.489145865965) | 11 | 6 | 2 | 55 | 26 | |
| 165116 | 99363 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | Permit Number 773617 | 5986845.56233 | 2112796.17507 | 37.7805753084335 | -122.489152009534 | (37.7805753084335, -122.489152009534) | 11 | 6 | 2 | 55 | 26 | |
| 69455 | 99362 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986843.02407 | 2112864.76375 | 37.7807634852432 | -122.489165834601 | (37.7807634852432, -122.489165834601) | 11 | 6 | 2 | 55 | 26 | ||
| 113863 | 99361 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986841.31224 | 2112888.67684 | 37.7808290438523 | -122.489173515193 | (37.7808290438523, -122.489173515193) | 11 | 6 | 2 | 55 | 26 | ||
| 98082 | 99360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986841.26301 | 2112907.24873 | 37.7808800340934 | -122.489175051323 | (37.7808800340934, -122.489175051323) | 11 | 6 | 2 | 55 | 26 | ||
| 80354 | 99359 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986842.11085 | 2112926.24344 | 37.7809322376389 | -122.489173515185 | (37.7809322376389, -122.489173515185) | 11 | 6 | 2 | 55 | 26 | ||
| 40927 | 99358 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986838.55817 | 2112947.10039 | 37.7809892975063 | -122.489187339371 | (37.7809892975063, -122.489187339371) | 11 | 6 | 2 | 55 | 26 | ||
| 181422 | 99357 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986839.06552 | 2112970.96623 | 37.7810548559101 | -122.489187339385 | (37.7810548559101, -122.489187339385) | 11 | 6 | 2 | 55 | 26 | ||
| 33247 | 99356 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986838.12863 | 2112989.55693 | 37.781105845983 | -122.489191947731 | (37.781105845983, -122.489191947731) | 11 | 6 | 2 | 55 | 26 | ||
| 115408 | 99355 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 5986839.02344 | 2113010.76146 | 37.7811641198035 | -122.489190411627 | (37.7811641198035, -122.489190411627) | 11 | 6 | 2 | 55 | 26 | ||
| 77215 | 99354 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986839.80551 | 2113026.66255 | 37.7812078253097 | -122.489188875507 | (37.7812078253097, -122.489188875507) | 11 | 6 | 2 | 55 | 26 | ||
| 96888 | 99353 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986836.83736 | 2113054.13933 | 37.781283095456 | -122.489201164445 | (37.781283095456, -122.489201164445) | 11 | 6 | 2 | 55 | 26 | ||
| 149215 | 99352 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986835.92891 | 2113074.05562 | 37.7813377268782 | -122.489205771916 | (37.7813377268782, -122.489205771916) | 11 | 6 | 2 | 55 | 26 | ||
| 121890 | 99351 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986837.32394 | 2113097.90248 | 37.7814032849786 | -122.489202699651 | (37.7814032849786, -122.489202699651) | 11 | 6 | 2 | 55 | 26 | ||
| 49808 | 99350 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986835.93382 | 2113116.06056 | 37.7814530607414 | -122.489208844148 | (37.7814530607414, -122.489208844148) | 11 | 6 | 2 | 55 | 26 | ||
| 43550 | 99349 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986833.62785 | 2113132.91132 | 37.781499193517 | -122.489218060865 | (37.781499193517, -122.489218060865) | 11 | 6 | 2 | 55 | 26 | ||
| 150203 | 99348 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986834.12581 | 2113156.33503 | 37.7815635374039 | -122.489218060874 | (37.7815635374039, -122.489218060874) | 11 | 6 | 2 | 55 | 26 | ||
| 53024 | 99347 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986832.70752 | 2113173.16715 | 37.7816096708126 | -122.489224205331 | (37.7816096708126, -122.489224205331) | 11 | 6 | 2 | 55 | 26 | ||
| 102014 | 99346 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 32 | 5x5 | 5986570.64094 | 2113156.51142 | 37.7815486383406 | -122.490129593054 | (37.7815486383406, -122.490129593054) | 11 | 6 | 2 | 55 | 26 | ||
| 43418 | 99345 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 5986571.27659 | 2113136.01167 | 37.7814923890114 | -122.490125885703 | (37.7814923890114, -122.490125885703) | 11 | 6 | 2 | 55 | 26 | ||
| 24143 | 99344 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986571.83486 | 2113111.88593 | 37.7814261792312 | -122.490122179259 | (37.7814261792312, -122.490122179259) | 11 | 6 | 2 | 55 | 26 | ||
| 148520 | 99343 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 450 30th Ave | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 5986574.07493 | 2113086.23058 | 37.781355867791 | -122.490112542148 | (37.781355867791, -122.490112542148) | 11 | 6 | 2 | 55 | 26 | ||
| 127692 | 99342 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986574.23671 | 2113063.60704 | 37.7812937594666 | -122.490110317893 | (37.7812937594666, -122.490110317893) | 11 | 6 | 2 | 55 | 26 | ||
| 57556 | 99341 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 4x5 | 5986573.71046 | 2113038.86406 | 37.7812257915862 | -122.49011031791 | (37.7812257915862, -122.49011031791) | 11 | 6 | 2 | 55 | 26 | ||
| 90721 | 99340 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 6x8 | 5986575.04866 | 2113011.09375 | 37.7811496204005 | -122.490103645203 | (37.7811496204005, -122.490103645203) | 11 | 6 | 2 | 55 | 26 | ||
| 155407 | 99339 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3.5x3.5 | 5986576.13047 | 2112991.43823 | 37.7810957151351 | -122.490098456538 | (37.7810957151351, -122.490098456538) | 11 | 6 | 2 | 55 | 26 | ||
| 84709 | 99338 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3X3 | 5986576.26956 | 2112967.74794 | 37.7810306764919 | -122.490096232309 | (37.7810306764919, -122.490096232309) | 11 | 6 | 2 | 55 | 26 | ||
| 125196 | 99337 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 4x4 | 5986576.2181 | 2112940.18967 | 37.7809550063526 | -122.490094382689 | (37.7809550063526, -122.490094382689) | 11 | 6 | 2 | 55 | 26 | ||
| 64192 | 99336 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986577.60051 | 2112919.49158 | 37.7808982560395 | -122.490088077428 | (37.7808982560395, -122.490088077428) | 11 | 6 | 2 | 55 | 26 | ||
| 32232 | 99335 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 450 30th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 3.5x3.5 | 5986578.25407 | 2112899.8451 | 37.780844350584 | -122.490084370963 | (37.780844350584, -122.490084370963) | 11 | 6 | 2 | 55 | 26 | ||
| 123461 | 99334 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986579.77919 | 2112870.79018 | 37.7807646631349 | -122.490076957163 | (37.7807646631349, -122.490076957163) | 11 | 6 | 2 | 55 | 26 | ||
| 85465 | 99333 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 4x4 | 5986581.86078 | 2112837.66907 | 37.7806738435833 | -122.490067319136 | (37.7806738435833, -122.490067319136) | 11 | 6 | 2 | 55 | 26 | ||
| 75990 | 99332 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 4x4 | 5986580.56369 | 2112816.99686 | 37.7806170078534 | -122.490070285368 | (37.7806170078534, -122.490070285368) | 11 | 6 | 2 | 55 | 26 | ||
| 23426 | 99331 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986581.6367 | 2112796.91447 | 37.7805619300043 | -122.490065095801 | (37.7805619300043, -122.490065095801) | 11 | 6 | 2 | 55 | 26 | ||
| 170197 | 99330 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 4x4 | 5986582.50919 | 2112777.47658 | 37.780508610058 | -122.490060647344 | (37.780508610058, -122.490060647344) | 11 | 6 | 2 | 55 | 26 | ||
| 173471 | 99329 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986584.84396 | 2112715.96758 | 37.7803398602424 | -122.490048044897 | (37.7803398602424, -122.490048044897) | 11 | 6 | 2 | 55 | 26 | ||
| 127671 | 99328 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986586.09055 | 2112693.96092 | 37.7802795090296 | -122.490042113304 | (37.7802795090296, -122.490042113304) | 11 | 6 | 2 | 55 | 26 | ||
| 110143 | 99327 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986588.01582 | 2112673.64698 | 37.7802238451734 | -122.490033958427 | (37.7802238451734, -122.490033958427) | 11 | 6 | 2 | 55 | 26 | ||
| 36069 | 99326 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986588.88353 | 2112653.99552 | 37.7801699385412 | -122.490029510836 | (37.7801699385412, -122.490029510836) | 11 | 6 | 2 | 55 | 26 | ||
| 44945 | 99261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3099X Polk St | 1 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x6 | 6005936.6 | 2121383.7 | 37.8052503240173 | -122.42371770971 | (37.8052503240173, -122.42371770971) | 5 | 1 | 1 | 28858 | 32 | ||
| 142206 | 99260 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2015 03:10:00 PM | 3 | 3x3 | 5995894.58408 | 2113075.36458 | 37.7818659153243 | -122.457867546462 | (37.7818659153243, -122.457867546462) | 11 | 6 | 1 | 54 | 31 | |
| 95696 | 99259 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5995893.7088 | 2113098.76002 | 37.7819301026873 | -122.457872268014 | (37.7819301026873, -122.457872268014) | 11 | 6 | 1 | 54 | 31 | ||
| 63809 | 99258 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5995889.58772 | 2113188.82138 | 37.7821771504315 | -122.45789304424 | (37.7821771504315, -122.45789304424) | 11 | 6 | 1 | 54 | 31 | ||
| 185623 | 99257 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5995884.63149 | 2113369.41772 | 37.7826727350965 | -122.457923263549 | (37.7826727350965, -122.457923263549) | 11 | 6 | 1 | 54 | 31 | ||
| 170036 | 99040 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
| 40781 | 99039 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 200X Bartlett St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
| 151982 | 99038 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 |
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) );