trees
194,517 rows sorted by qCareAssistant 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
186898 | 43440 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 2 | Permit Number 43162 | 5999628.40371 | 2091200.8294 | 37.7220175764452 | -122.443378608135 | (37.7220175764452, -122.443378608135) | 9 | 7 | 6 | 28861 | 25 | |
188774 | 107889 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 11/03/2014 12:00:00 AM | 3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |
188837 | 184929 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3301 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 02/20/2015 12:00:00 AM | 3 | 3x3 | 5983789.7803 | 2102191.0584 | 37.7512778353096 | -122.498939496923 | (37.7512778353096, -122.498939496923) | 1 | 8 | 3 | 29491 | 35 | |
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 | ||
1376 | 263620 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 3 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
10225 | 263619 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 2 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
10567 | 263621 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 4 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
11498 | 115743 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 28 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
11694 | 263618 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 1 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
25159 | 116139 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 11 | 6009237.30915 | 2116708.08381 | 37.7925980056535 | -122.411964529145 | (37.7925980056535, -122.411964529145) | 5 | 1 | 10 | 28857 | 21 | |||
26078 | 103365 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 12 | 3x3 | 6009208.54849 | 2116702.78378 | 37.7925818394263 | -122.412063667702 | (37.7925818394263, -122.412063667702) | 5 | 1 | 10 | 28857 | 21 | ||
26865 | 103362 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 12 | 3x3 | 6009111.87446 | 2116690.26678 | 37.7925420462198 | -122.412397279316 | (37.7925420462198, -122.412397279316) | 5 | 1 | 10 | 28857 | 21 | ||
35407 | 94294 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
50482 | 103357 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
51920 | 103361 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
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 | |||
66280 | 94296 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
70238 | 103355 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
72945 | 104450 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2490X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | |||
74389 | 104447 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2490X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | |||
74442 | 103359 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
86887 | 94302 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
87854 | 103360 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
97800 | 115748 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 6 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 24 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
99392 | 94300 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6x6 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||
106391 | 115747 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 5 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 16 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
107985 | 115744 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 24 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
112309 | 115745 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 3 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 20 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
112589 | 115746 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X POND ST | 4 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Rec/Park | 28 | 3x3 | 6003250 | 2106477 | 37.764168263012 | -122.431949928803 | (37.764168263012, -122.431949928803) | 15 | 4 | 5 | 28862 | 3 | ||
121115 | 94298 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
122696 | 103363 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 12 | 3x3 | 6009142.2805 | 2116694.47646 | 37.7925553112212 | -122.412292370693 | (37.7925553112212, -122.412292370693) | 5 | 1 | 10 | 28857 | 21 | ||
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 | |||
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 | |||
134290 | 94304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
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 | |||
153064 | 103364 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1171X Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 3 | 3x3 | 6009173.30525 | 2116699.27717 | 37.7925702336697 | -122.412185363057 | (37.7925702336697, -122.412185363057) | 5 | 1 | 10 | 28857 | 21 | ||
168063 | 103358 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
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 | |||
174866 | 103356 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
177428 | 103354 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
182306 | 103352 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
190388 | 103353 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1000X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Rec/Park | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | 5 | 1 | 10 | 28857 | 21 | ||
615 | 262077 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 565 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 04/16/2020 12:00:00 AM | 3 | 3x3 | 6003870.34162 | 2109702.301 | 37.7730593047529 | -122.430034440005 | (37.7730593047529, -122.430034440005) | 7 | 9 | 11 | 29492 | 10 | |
1192 | 262086 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1526 | 262088 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1542 | 261489 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100X Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
1707 | 262090 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1728 | 262141 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 420X Portola Dr | 2 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
2079 | 263595 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
2444 | 187616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/03/2013 12:00:00 AM | 3x3 | 6013035 | 2114021 | 37.78543223702 | -122.398635644163 | (37.78543223702, -122.398635644163) | 6 | 2 | 9 | 28855 | 6 | ||
3709 | 33773 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2640 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/23/1996 12:00:00 AM | 12 | Permit Number 37820 | 5999639.77056 | 2117940.89784 | 37.7954398489265 | -122.44526091526 | (37.7954398489265, -122.44526091526) | 13 | 9 | 1 | 57 | 17 | |
4032 | 263594 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
4376 | 259271 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1721x Taylor St | 5 | Side Yard : Yard | Tree | DPW 1 | Private | 05/25/2019 12:00:00 AM | 3 | ||||||||||||
4790 | 102992 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 5 | 3x3 | 5993571.87038 | 2110700.08123 | 37.7752103110101 | -122.465730364497 | (37.7752103110101, -122.465730364497) | 11 | 6 | 2 | 54 | 11 | ||
4881 | 259031 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 3 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
4900 | 263589 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012532 | 2112188 | 37.7803712075622 | -122.400247099708 | (37.7803712075622, -122.400247099708) | 6 | 2 | 9 | 28856 | 34 | |||
4935 | 263596 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
5089 | 262085 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
5261 | 262386 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 6005187.2243 | 2109578.99326 | 37.7727952246844 | -122.425470396534 | (37.7727952246844, -122.425470396534) | 7 | 9 | 11 | 28852 | 10 | ||||
5343 | 259035 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 7 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
5519 | 251279 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | |||
5711 | 253201 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Oak St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 11/02/2019 06:09:00 AM | 3 | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |
5722 | 255886 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
5905 | 261162 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 595 Newhall St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 6016024 | 2097656 | 37.7406635379999 | -122.387152626875 | (37.7406635379999, -122.387152626875) | 10 | 3 | 8 | 58 | 1 | |||
6078 | 255898 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 255 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/12/2019 06:17:00 AM | 3 | 3x3 | 6007944 | 2113354 | 37.7833158649371 | -122.416201780533 | (37.7833158649371, -122.416201780533) | 7 | 10 | 9 | 28852 | 36 | |
6781 | 259030 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
6786 | 262148 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 420X Portola Dr | 9 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
6957 | 259032 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 4 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
7643 | 263592 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
7702 | 262097 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 10x Cuesta Ct | 1 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||
8266 | 253200 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Oak St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 11/02/2019 06:07:00 AM | 3 | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |
8619 | 262142 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 420X Portola Dr | 3 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
9305 | 251160 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100X Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
9630 | 248945 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500x Galvez Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 12:00:00 AM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
10029 | 260896 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 866 Kansas St | 1 | Front Yard : Cutout | Tree | DPW 1 | Private | 3x3 | 6011543 | 2104306 | 37.7586738299336 | -122.403113948893 | (37.7586738299336, -122.403113948893) | 10 | 3 | 8 | 28856 | 29 | |||
10051 | 263590 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
10460 | 258772 | Property Tree 8 | Cupressus spp :: Cypress species 337 | 20 Crestline Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 5999139 | 2101332 | 37.7498074496931 | -122.445798597569 | (37.7498074496931, -122.445798597569) | 2 | 5 | 5 | 63 | 38 | |||
10605 | 260507 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 50X Carver St | 1 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 6009420 | 2098346 | 37.742190207281 | -122.410035530349 | (37.742190207281, -122.410035530349) | 10 | 7 | 7 | 28859 | 2 | |||
10888 | 262140 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 420X Portola Dr | 1 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
11644 | 259033 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
11844 | 262089 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
11958 | 262083 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
12093 | 262143 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 420X Portola Dr | 4 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
12562 | 262087 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
13646 | 259034 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 6 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
13846 | 262084 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
14210 | 85214 | - 12 | Jacaranda mimosifolia :: Jacaranda 50 | 2889 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/13/2007 12:00:00 AM | 3 | 3x3 | under 3yr maintenance agreement. ends on 4/13/2007 | 6009588.01504 | 2102148.81833 | 37.7526413233918 | -122.409722943913 | (37.7526413233918, -122.409722943913) | 2 | 4 | 7 | 28859 | 19 |
14634 | 259029 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
15423 | 85309 | - 12 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/26/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.7706407896873 | -122.442827504693 | (37.7706407896873, -122.442827504693) | 15 | 5 | 11 | 29492 | 9 |
15426 | 262040 | DPW Maintained 1 | Tree(s) :: 17 | 740 Jamestown Ave | Back Yard : Yard | Tree | DPW 1 | Private | 6015231.58289 | 2088478.1596 | 37.7154191081975 | -122.38925181324 | (37.7154191081975, -122.38925181324) | 10 | 3 | 8 | 58 | 1 | |||||
15519 | 262098 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 10x Cuesta Ct | 2 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||
15523 | 248949 | DPW Maintained 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1500x Galvez Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 09:13:00 AM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
16157 | 263597 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 03/07/2007 12:00:00 AM | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | ||
17225 | 253199 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 11/02/2019 06:04:00 AM | 3 | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |
17261 | 261487 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100X Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
18291 | 263593 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830x Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012495 | 2112152 | 37.7802702966571 | -122.40037257143 | (37.7802702966571, -122.40037257143) | 6 | 2 | 9 | 28856 | 34 | |||
18853 | 262082 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
19694 | 91181 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
20034 | 255882 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
22229 | 255887 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Columbia Square St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 |
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) );