trees
198 rows where qCareAssistant = "" and qCaretaker_id = 4 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80 | 260998 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard | Tree | SFUSD 4 | 10x10 | ||||||||||||||
| 297 | 113036 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
| 4401 | 258690 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100x Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
| 4591 | 113471 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 28 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 5758 | 262529 | Property Tree 8 | Pinus pinea :: Italian Stone Pine 63 | 555 Portola Dr | 8 | Front Yard : Yard | Tree | SFUSD 4 | 10x10 | 5997546 | 2099815 | 37.7455510557903 | -122.451197845188 | (37.7455510557903, -122.451197845188) | 2 | 7 | 5 | 63 | 7 | ||||
| 6926 | 96580 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 7677 | 258687 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 9 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
| 9009 | 258692 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 100x Whitney Young Cir | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | |||||
| 10723 | 113037 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
| 12066 | 258686 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 8 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
| 12415 | 258693 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 100 Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
| 15342 | 113473 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 30 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 15996 | 258691 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 100x Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
| 16134 | 106952 | Undocumented 4 | Tree(s) :: 17 | 399X SOMERSET ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6009953 | 2092875 | 37.7271978698015 | -122.407806879765 | (37.7271978698015, -122.407806879765) | 10 | 3 | 7 | 309 | 28 | ||||
| 17872 | 258685 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100x Whitney Young Cir | 2 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
| 23905 | 96578 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 31248 | 96579 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 38459 | 107872 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | ||||
| 43317 | 113469 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 47600 | 107870 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | ||||
| 51523 | 107874 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | ||||
| 51808 | 111862 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
| 51837 | 113436 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | ||||
| 52455 | 117257 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1570 31ST AVE | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
| 57689 | 117255 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
| 58400 | 113437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | ||||
| 60043 | 111861 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
| 60432 | 112026 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
| 62536 | 112022 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
| 65054 | 113474 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 31 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 67453 | 173941 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 3750 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6004590 | 2105440 | 37.7613967828987 | -122.427241380377 | (37.7613967828987, -122.427241380377) | 8 | 4 | 5 | 28862 | 3 | ||||
| 68404 | 107869 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | ||||
| 71723 | 79386 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2355 Folsom St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10/30/2009 12:00:00 AM | Permit Number 53016 | 6008491.21757684 | 2104497.38565881 | 37.7590284322587 | -122.4136819767 | (37.7590284322587, -122.4136819767) | 2 | 4 | 7 | 28859 | 19 | |||
| 72835 | 253729 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 73519 | 253732 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 73651 | 112027 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
| 75070 | 253734 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 75199 | 113039 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
| 76617 | 107873 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | ||||
| 81017 | 117256 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
| 82489 | 253724 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 83117 | 113466 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 87145 | 113435 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | ||||
| 88433 | 107871 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | ||||
| 89046 | 113040 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
| 91360 | 110190 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | |||||
| 91388 | 105784 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 04/18/2014 12:00:00 AM | Permit Number 772914 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||
| 91889 | 113472 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 29 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 92761 | 110187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 625 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6006167.62160945 | 2096413.49051844 | 37.7367011423593 | -122.421144072665 | (37.7367011423593, -122.421144072665) | 2 | 7 | 7 | 28859 | 2 | |||||
| 98248 | 94927 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 325 Sanchez St | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/07/2010 12:00:00 AM | 3x3 | Permit Number 53976 | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||
| 106870 | 117252 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 2 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
| 108286 | 253726 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 109856 | 253733 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 115682 | 111766 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1860 HAYES ST | 4 | Front Yard : Yard | Tree | SFUSD 4 | 5998973 | 2110255 | 37.7742982989317 | -122.447014674672 | (37.7742982989317, -122.447014674672) | 15 | 5 | 11 | 29492 | 16 | |||||
| 121060 | 92961 | DPW Maintained 1 | Tree(s) :: 17 | 2051 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/24/2009 12:00:00 AM | 3x3 | Permit Number 53120 | 5985698.5 | 2101265.4 | 37.748848003369 | -122.492270870248 | (37.748848003369, -122.492270870248) | 1 | 8 | 3 | 29491 | 35 | ||
| 122635 | 96583 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 401x Otsego Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | ||||
| 127602 | 253727 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 128118 | 96585 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401x Otsego Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 129395 | 92962 | DPW Maintained 1 | Tree(s) :: 17 | 2051 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/24/2009 12:00:00 AM | 3x3 | Permit Number 53120 | 5985698.5 | 2101265.4 | 37.748848003369 | -122.492270870248 | (37.748848003369, -122.492270870248) | 1 | 8 | 3 | 29491 | 35 | ||
| 129965 | 112024 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
| 132862 | 111863 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
| 133744 | 117251 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 1 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
| 138444 | 253731 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 141407 | 92806 | Permitted Site 7 | Tree(s) :: 17 | 2355 Folsom St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10/30/2009 12:00:00 AM | Permit Number 53016 | 6008199.4 | 2104720.1 | 37.7596235634815 | -122.414706984191 | (37.7596235634815, -122.414706984191) | 2 | 4 | 7 | 28859 | 19 | |||
| 143625 | 113475 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 32 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 144986 | 113038 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
| 147121 | 113467 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 155737 | 117286 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3500 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6002513 | 2120207 | 37.8018255621759 | -122.435481260672 | (37.8018255621759, -122.435481260672) | 13 | 9 | 1 | 57 | 17 | ||||
| 160599 | 253725 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 163044 | 106953 | Undocumented 4 | Tree(s) :: 17 | 399X SOMERSET ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6009953 | 2092875 | 37.7271978698015 | -122.407806879765 | (37.7271978698015, -122.407806879765) | 10 | 3 | 7 | 309 | 28 | |||||
| 166189 | 96581 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 171218 | 107868 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6012494.96542 | 2112152.38808 | 37.7802713603069 | -122.400372718325 | (37.7802713603069, -122.400372718325) | 6 | 2 | 9 | 28856 | 34 | |||||
| 172028 | 96582 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 176122 | 253851 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825X Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6008234 | 2102998 | 37.7548970135718 | -122.414465463083 | (37.7548970135718, -122.414465463083) | 2 | 4 | 7 | 28859 | 19 | ||||
| 176886 | 117253 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 3 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
| 180230 | 96584 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 181086 | 253730 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 183365 | 251680 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 184091 | 92963 | Permitted Site 7 | Tree(s) :: 17 | 1515 Quintara St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/24/2009 12:00:00 AM | 3x3 | Permit Number 53121 | 5988690.8 | 2100920.9 | 37.7480765758445 | -122.481898390884 | (37.7480765758445, -122.481898390884) | 1 | 8 | 3 | 29491 | 35 | ||
| 188448 | 113470 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6x6 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||||
| 190932 | 253728 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 Girard St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x12 | 6010529 | 2093052 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | 10 | 3 | 7 | 309 | 28 | ||||
| 49723 | 115970 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30TH AVE | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 0 | 3x3 | 5986686 | 2104596 | 37.7580506061519 | -122.489100968136 | (37.7580506061519, -122.489100968136) | 1 | 8 | 3 | 56 | 35 | |||
| 55266 | 142521 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/04/2013 12:00:00 AM | 0 | Width 0ft | 6009485.2617 | 2121177.5361 | 37.8048839283261 | -122.411422499274 | (37.8048839283261, -122.411422499274) | 3 | 1 | 10 | 308 | 23 | ||
| 156729 | 115973 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30TH AVE | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 0 | 3x3 | 5986686 | 2104596 | 37.7580506061519 | -122.489100968136 | (37.7580506061519, -122.489100968136) | 1 | 8 | 3 | 56 | 35 | |||
| 83242 | 113035 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 251 06th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 1 | 3x3 | 5993975.80165 | 2113783.25834 | 37.7836991768592 | -122.464557007516 | (37.7836991768592, -122.464557007516) | 11 | 6 | 2 | 54 | 11 | |||
| 56509 | 95507 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985983.58763 | 2112182.96811 | 37.7788412674233 | -122.492088785464 | (37.7788412674233, -122.492088785464) | 11 | 6 | 2 | 55 | 26 | |||
| 80723 | 142526 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | Width 0ft | 6009810.3798 | 2121222.957 | 37.8050268727325 | -122.410300597206 | (37.8050268727325, -122.410300597206) | 3 | 1 | 10 | 308 | 23 | |||
| 106937 | 95512 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985990.17986 | 2112026.52369 | 37.7784121011104 | -122.492054459017 | (37.7784121011104, -122.492054459017) | 11 | 6 | 2 | 55 | 26 | |||
| 152853 | 95517 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985993.99278 | 2111923.13747 | 37.778128454962 | -122.492033654936 | (37.778128454962, -122.492033654936) | 11 | 6 | 2 | 55 | 26 | |||
| 161839 | 95485 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5986006.6183 | 2111569.83262 | 37.7771591186395 | -122.491963960946 | (37.7771591186395, -122.491963960946) | 11 | 6 | 2 | 55 | 26 | |||
| 16064 | 235284 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4235 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 11 | Width 3ft | 6001885.77275 | 2104671.54401 | 37.7591334867264 | -122.436539154285 | (37.7591334867264, -122.436539154285) | 2 | 4 | 5 | 28862 | 3 | |||
| 47875 | 234074 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 11 | Width 3ft | 6011143.5049 | 2101689.85229 | 37.751468148542 | -122.404311456823 | (37.751468148542, -122.404311456823) | 10 | 4 | 8 | 28859 | 19 | |||
| 42099 | 234076 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400 San Bruno Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12 | Width 4ft | 6011147.1312 | 2101589.6307 | 37.751193164657 | -122.404291863299 | (37.751193164657, -122.404291863299) | 10 | 4 | 8 | 28859 | 19 | |||
| 68964 | 113434 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198x HIGHLAND AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12 | 4x4 | 6006173 | 2096415 | 37.7367055902603 | -122.421125584355 | (37.7367055902603, -122.421125584355) | 2 | 7 | 7 | 28859 | 2 | |||
| 9627 | 228661 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 13 | Width 3ft | 6001838.07707 | 2104669.16217 | 37.7591242363206 | -122.436703937943 | (37.7591242363206, -122.436703937943) | 2 | 4 | 5 | 28862 | 3 | |||
| 1119 | 113031 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 251 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | 3x3 | 5993971.49407 | 2113867.66105 | 37.7839306754778 | -122.464578040665 | (37.7839306754778, -122.464578040665) | 11 | 6 | 2 | 54 | 11 | |||
| 18625 | 113033 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 251 06th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | 3x3 | 5993974.82941 | 2113822.74411 | 37.7838075380241 | -122.464563239136 | (37.7838075380241, -122.464563239136) | 11 | 6 | 2 | 54 | 11 | |||
| 121669 | 234075 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400 San Bruno Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | Width 4ft | 6011146.17896 | 2101629.85029 | 37.7513035456277 | -122.404297986789 | (37.7513035456277, -122.404297986789) | 10 | 4 | 8 | 28859 | 19 | |||
| 12179 | 220312 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4235 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 15 | Width 3ft | 6002007.42492 | 2104678.29116 | 37.7591589249724 | -122.436118906483 | (37.7591589249724, -122.436118906483) | 2 | 4 | 5 | 28862 | 3 | |||
| 12520 | 228662 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 16 | Width 3ft | 6001863.4982 | 2104671.44362 | 37.7591319452903 | -122.436616182999 | (37.7591319452903, -122.436616182999) | 2 | 4 | 5 | 28862 | 3 |
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) );