trees
203 rows where qCaretaker_id = 14 sorted by qSiteInfo 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 4148 | 111380 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
| 11986 | 95043 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 4 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 9 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 87780 | 95040 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 13 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 105081 | 97214 | DPW Maintained 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 300X Claremont Blvd | 1 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 12 | 5993486 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | 1 | 8 | 4 | 59 | 40 | ||||
| 114447 | 97215 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 300X Claremont Blvd | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 20 | 4x12 | 5993486 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | 1 | 8 | 4 | 59 | 40 | |||
| 119304 | 111381 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 3 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
| 120981 | 95046 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 10 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 13 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 141424 | 95044 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 6 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 142881 | 95042 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 11 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 168033 | 111379 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 1 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
| 21486 | 114737 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 455x LILY ST | 1 | Sidewalk: Curb side : Pot | Tree | DPW for City Agency 14 | DPW | 6004484 | 2109981 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | 7 | 9 | 11 | 28852 | 10 | ||||
| 6921 | 95036 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 8033 | 242084 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4185 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 02/16/2016 06:05:00 AM | 1 | Width 3ft | 6002781.49194 | 2101209.46423 | 37.7496782989261 | -122.433193959528 | (37.7496782989261, -122.433193959528) | 2 | 4 | 5 | 28862 | 22 | ||
| 10068 | 49666 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000245.17413 | 2120665.11682 | 37.8029543681198 | -122.443361894237 | (37.8029543681198, -122.443361894237) | 13 | 9 | 1 | 57 | 17 | ||
| 12041 | 242082 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4185 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 1 | Width 3ft | 6002677.73551 | 2101204.84944 | 37.7496597414097 | -122.433552423029 | (37.7496597414097, -122.433552423029) | 2 | 4 | 5 | 28862 | 22 | |||
| 12201 | 140276 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2040 Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998008.2541 | 2109969.0086 | 37.7734578744037 | -122.450331271992 | (37.7734578744037, -122.450331271992) | 15 | 5 | 11 | 29492 | 16 | ||
| 14883 | 242086 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4185 25th St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 02/16/2016 05:57:00 AM | 2 | Width 3ft | 6002948.22198 | 2101215.85126 | 37.7497052929799 | -122.432617857444 | (37.7497052929799, -122.432617857444) | 2 | 4 | 5 | 28862 | 22 | ||
| 15243 | 98997 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | ||||
| 15773 | 242083 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4185 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 1 | Width 3ft | 6002726.52973 | 2101207.22034 | 37.7496690197098 | -122.433383860397 | (37.7496690197098, -122.433383860397) | 2 | 4 | 5 | 28862 | 22 | |||
| 16686 | 99005 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
| 19884 | 109998 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 501X Shotwell St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | ||||
| 21624 | 140275 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2040 Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998028.0276 | 2109971.4803 | 37.773465792675 | -122.450263051124 | (37.773465792675, -122.450263051124) | 15 | 5 | 11 | 29492 | 16 | ||
| 21859 | 98725 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 14 | 3x3 | 6006216.75471 | 2111460.37935 | 37.7780191723707 | -122.422042806835 | (37.7780191723707, -122.422042806835) | 7 | 9 | 11 | 28852 | 10 | |||
| 22315 | 113814 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 06:05:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
| 23754 | 113821 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 4101x 25TH ST | 14 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
| 24920 | 81846 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50020 | 6007049.49584 | 2115692.06976 | 37.7896852939829 | -122.419462344328 | (37.7896852939829, -122.419462344328) | 13 | 9 | 10 | 28858 | 21 |
| 25373 | 110420 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 419X 18TH AVE | 18 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
| 26910 | 111776 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
| 27383 | 109993 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 28942 | 110737 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
| 29374 | 109992 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 29933 | 98726 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 12 | 3x3 | 6006198.51355 | 2111464.4034 | 37.7780291926159 | -122.422106195562 | (37.7780291926159, -122.422106195562) | 7 | 9 | 11 | 28852 | 10 | |||
| 30910 | 110537 | Undocumented 4 | Tree(s) :: 17 | 100X ASHBURY ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | City College | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |||
| 31418 | 110533 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 100X ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | City College | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |||
| 32812 | 99009 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
| 33609 | 98909 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 35002 | 98799 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | ||
| 38877 | 101808 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3149 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 02/03/2015 12:00:00 AM | 3 | 3x3 | 6008718.2 | 2100791.7 | 37.7488661984732 | -122.412634998086 | (37.7488661984732, -122.412634998086) | 2 | 4 | 7 | 28859 | 19 | ||
| 39489 | 111135 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 2 | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | ||
| 40162 | 95366 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3101X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 14 | 3x3 | 6005504.90819 | 2120981.97244 | 37.8041229057048 | -122.425183031522 | (37.8041229057048, -122.425183031522) | 13 | 9 | 1 | 28858 | 17 | ||
| 41067 | 113874 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
| 41337 | 81843 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
| 42549 | 98221 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
| 42721 | 49663 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 7 | Permit Number 46510 | 6000228.83335 | 2120782.17575 | 37.8032748487093 | -122.443426854966 | (37.8032748487093, -122.443426854966) | 13 | 9 | 1 | 57 | 17 | ||
| 43653 | 95034 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 45020 | 111128 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 7 | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | ||
| 45985 | 99003 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
| 47883 | 109990 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 50286 | 113709 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
| 50314 | 98728 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 14 | 3x3 | 6006156.19882 | 2111456.14926 | 37.778004142027 | -122.42225199096 | (37.778004142027, -122.42225199096) | 7 | 9 | 11 | 28852 | 10 | |||
| 50801 | 95033 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 50984 | 95035 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 51749 | 49665 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000243.34961 | 2120687.49551 | 37.8030157099616 | -122.443369816371 | (37.8030157099616, -122.443369816371) | 13 | 9 | 1 | 57 | 17 | ||
| 52668 | 113708 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
| 56181 | 110400 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 419X 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 28 | 3x3 | 5990269.5497 | 2112500.03817 | 37.7799614584413 | -122.477285287094 | (37.7799614584413, -122.477285287094) | 11 | 6 | 2 | 55 | 26 | ||
| 56631 | 110401 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 419X 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 27 | 3x3 | 5990271.90904 | 2112469.3758 | 37.7798774049655 | -122.4772748837 | (37.7798774049655, -122.4772748837) | 11 | 6 | 2 | 55 | 26 | ||
| 56816 | 98996 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2190X North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000702 | 2120685 | 37.8030350020674 | -122.441782472194 | (37.8030350020674, -122.441782472194) | 13 | 9 | 1 | 57 | 17 | |||
| 56896 | 98734 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 14 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | 7 | 9 | 11 | 28852 | 10 | |||
| 57725 | 109996 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 62704 | 98219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
| 63694 | 109991 | Undocumented 4 | Quercus spp :: Oak 254 | 501X Shotwell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 64581 | 99308 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1902X 41st Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
| 65235 | 113871 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
| 65648 | 98733 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 13 | 3x3 | 6006078.7 | 2111522.5 | 37.778181953323 | -122.422524803295 | (37.778181953323, -122.422524803295) | 7 | 9 | 11 | 28852 | 10 | |||
| 67675 | 110738 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
| 68320 | 137118 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2150 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 0 | Width 4ft | Permit Number 771149 | 6000490.48443 | 2120659.70119 | 37.8029534840902 | -122.442512606897 | (37.8029534840902, -122.442512606897) | 13 | 9 | 1 | 57 | 17 | |
| 72030 | 109988 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 72388 | 82383 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 09/11/2012 12:00:00 AM | 3 | 3x3 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 | |
| 73001 | 98796 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950@Washington Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768771 | 6010177.18626 | 2117200.01626 | 37.7940014192822 | -122.408747227007 | (37.7940014192822, -122.408747227007) | 3 | 1 | 10 | 28857 | 4 | |
| 73737 | 113813 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
| 74558 | 111133 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
| 75069 | 47415 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 05/14/2002 12:00:00 AM | 9 | Permit Number 45326 | 6000240.55787 | 2120707.38669 | 37.8030701666099 | -122.443380906816 | (37.8030701666099, -122.443380906816) | 13 | 9 | 1 | 57 | 17 | ||
| 75284 | 113868 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
| 76830 | 99000 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |||
| 76955 | 99004 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
| 77560 | 95038 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 78158 | 113866 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 301x BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001207 | 2109749 | 37.7730363312645 | -122.439250600749 | (37.7730363312645, -122.439250600749) | 15 | 5 | 11 | 29492 | 10 | ||||
| 78186 | 98801 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010237.16405 | 2117207.30409 | 37.79402478906 | -122.408540211182 | (37.79402478906, -122.408540211182) | 3 | 1 | 10 | 28857 | 4 | |
| 78336 | 98729 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 13 | 3x3 | 6006140.89781 | 2111454.63858 | 37.7779991309825 | -122.422304815319 | (37.7779991309825, -122.422304815319) | 7 | 9 | 11 | 28852 | 10 | |||
| 78526 | 254583 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1439 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Private | 08/02/2016 06:38:00 AM | 3x3 | 6005488 | 2119883 | 37.8011044543754 | -122.425163298445 | (37.8011044543754, -122.425163298445) | 13 | 9 | 1 | 57 | 17 | ||
| 82558 | 98222 | DPW Maintained 1 | Eucalyptus macarthuri :: Camden Wollybutt 516 | 1501X 42nd Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
| 83447 | 109986 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 83791 | 98908 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 87127 | 99008 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
| 87336 | 113817 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 06:00:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
| 87604 | 81841 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
| 87682 | 113810 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4101x 25TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |||
| 88456 | 113809 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 06/15/2016 07:36:00 AM | 3 | 5x5 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
| 89248 | 109987 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 501X Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 89407 | 98217 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
| 90434 | 113818 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 05:57:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
| 94178 | 98727 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 360 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 12 | 3x3 | 6006176.94483 | 2111455.11485 | 37.7780024719703 | -122.422180149508 | (37.7780024719703, -122.422180149508) | 7 | 9 | 11 | 28852 | 10 | |||
| 94774 | 99002 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |||
| 95484 | 98999 | DPW Maintained 1 | Tristania conferta :: 61 | 2190X North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771149 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |
| 95513 | 98800 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010265.98354 | 2117209.83013 | 37.7940333389111 | -122.408440670611 | (37.7940333389111, -122.408440670611) | 3 | 1 | 10 | 28857 | 4 |
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) );