trees
1,098 rows where qCaretaker_id = 4 sorted by Supervisor Districts 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 102329 | 91788 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 830X Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6012494.965717 | 2112152.388469 | 37.7802713613915 | -122.400372717325 | (37.7802713613915, -122.400372717325) | 6 | 2 | 9 | 28856 | 34 | ||
| 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 | |||||
| 2999 | 94036 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Lane St | 4 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/14/2019 09:52:00 AM | 3 | 5x5 | 6015673.325 | 2095216.0053 | 37.7339443827642 | -122.388194894968 | (37.7339443827642, -122.388194894968) | 10 | 3 | 8 | 58 | 1 | |
| 4078 | 78328 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014090.70522 | 2094312.98368 | 37.7313770539035 | -122.393603356926 | (37.7313770539035, -122.393603356926) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||||
| 5271 | 78323 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014072.33534 | 2094216.70422 | 37.7311116693492 | -122.393660129315 | (37.7311116693492, -122.393660129315) | 10 | 3 | 8 | 58 | 1 | ||
| 5745 | 193934 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6016623.26344 | 2095403.70542 | 37.7345123576517 | -122.384923708478 | (37.7345123576517, -122.384923708478) | 10 | 3 | 8 | 58 | 1 | |||
| 5747 | 94949 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 7113 | 51366 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014162.99112 | 2094669.44393 | 37.7323598375173 | -122.393378385216 | (37.7323598375173, -122.393378385216) | 10 | 3 | 8 | 58 | 1 |
| 7428 | 78326 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014084.32077 | 2094282.11607 | 37.7312919429706 | -122.393623269718 | (37.7312919429706, -122.393623269718) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||||
| 7794 | 78331 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 50 Pomona St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014103.03356 | 2094377.1679 | 37.7315539757311 | -122.393565225657 | (37.7315539757311, -122.393565225657) | 10 | 3 | 8 | 58 | 1 | ||
| 7857 | 78321 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014066.05948 | 2094191.20422 | 37.7310413028018 | -122.3936800421 | (37.7310413028018, -122.3936800421) | 10 | 3 | 8 | 58 | 1 | ||
| 8049 | 51364 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014150.64944 | 2094610.63008 | 37.7321976609735 | -122.393416939157 | (37.7321976609735, -122.393416939157) | 10 | 3 | 8 | 58 | 1 |
| 8094 | 78325 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 50 Pomona St | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014082.07463 | 2094268.00581 | 37.7312530742586 | -122.393630047885 | (37.7312530742586, -122.393630047885) | 10 | 3 | 8 | 58 | 1 | ||
| 8159 | 78322 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 25 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014069.27853 | 2094204.92894 | 37.7310791669665 | -122.393669873461 | (37.7310791669665, -122.393669873461) | 10 | 3 | 8 | 58 | 1 | ||
| 8452 | 116055 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650x Kansas St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/08/2020 12:00:00 AM | 3 | 4x4 | 6011513.13975 | 2105199.40577 | 37.7611252557522 | -122.403280067548 | (37.7611252557522, -122.403280067548) | 10 | 3 | 8 | 28856 | 29 | |
| 8962 | 116061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2100x 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 3x3 | 6011385.89017 | 2105128.48272 | 37.7609234092204 | -122.403715181115 | (37.7609234092204, -122.403715181115) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | |||||
| 11126 | 51368 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014172.09212 | 2094713.43563 | 37.7324811353964 | -122.393349998121 | (37.7324811353964, -122.393349998121) | 10 | 3 | 8 | 58 | 1 |
| 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 | ||||
| 13176 | 78329 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014093.60126 | 2094328.91133 | 37.7314209489083 | -122.39359445904 | (37.7314209489083, -122.39359445904) | 10 | 3 | 8 | 58 | 1 | ||
| 13195 | 78202 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014063.31576 | 2094176.73754 | 37.7310014277784 | -122.393688515509 | (37.7310014277784, -122.393688515509) | 10 | 3 | 8 | 58 | 1 | ||
| 13279 | 108789 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
| 13398 | 51356 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014174.8382 | 2094728.02379 | 37.7325213440762 | -122.393341524701 | (37.7325213440762, -122.393341524701) | 10 | 3 | 8 | 58 | 1 |
| 14250 | 116051 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 650x Kansas St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 4x4 | 6011500.28754 | 2105307.13541 | 37.7614203394907 | -122.403332096897 | (37.7614203394907, -122.403332096897) | 10 | 3 | 8 | 28856 | 29 | ||
| 14678 | 96770 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 6 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015623.8599 | 2095148.9526 | 37.7337575287133 | -122.388361234061 | (37.7337575287133, -122.388361234061) | 10 | 3 | 8 | 58 | 1 | |
| 14886 | 51359 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 50 Pomona St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014112.78564 | 2094416.99761 | 37.7316638818713 | -122.393534297068 | (37.7316638818713, -122.393534297068) | 10 | 3 | 8 | 58 | 1 |
| 15106 | 78327 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014087.33436 | 2094297.79766 | 37.7313351688787 | -122.393613948242 | (37.7313351688787, -122.393613948242) | 10 | 3 | 8 | 58 | 1 | ||
| 15357 | 98942 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400X San Bruno Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 6011147.5 | 2101806.3 | 37.7517881116631 | -122.404305836485 | (37.7517881116631, -122.404305836485) | 10 | 4 | 8 | 28859 | 19 | ||
| 15783 | 78330 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014096.48223 | 2094344.10726 | 37.7314628339206 | -122.39358556205 | (37.7314628339206, -122.39358556205) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||||
| 16291 | 51365 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014154.93455 | 2094628.60419 | 37.7322472522973 | -122.393403381858 | (37.7322472522973, -122.393403381858) | 10 | 3 | 8 | 58 | 1 |
| 16535 | 78324 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014075.45071 | 2094231.93865 | 37.7311536731068 | -122.393650424725 | (37.7311536731068, -122.393650424725) | 10 | 3 | 8 | 58 | 1 | ||
| 17049 | 112023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 17413 | 112021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | ||||
| 18361 | 173682 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450x Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6008515 | 2088365 | 37.7147337500707 | -122.412459395375 | (37.7147337500707, -122.412459395375) | 9 | 7 | 8 | 309 | 18 | |||
| 18431 | 51369 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014169.21344 | 2094698.3618 | 37.7324395857978 | -122.39335889599 | (37.7324395857978, -122.39335889599) | 10 | 3 | 8 | 58 | 1 |
| 18970 | 97073 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 24349 | 97071 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 28466 | 98940 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400X San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6011147.5 | 2101806.3 | 37.7517881116631 | -122.404305836485 | (37.7517881116631, -122.404305836485) | 10 | 4 | 8 | 28859 | 19 | ||
| 30823 | 96774 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015407.2 | 2095381.5 | 37.7343840488548 | -122.389126529878 | (37.7343840488548, -122.389126529878) | 10 | 3 | 8 | 58 | 1 | |
| 31112 | 96772 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x3 | 6015407.2 | 2095381.5 | 37.7343840488548 | -122.389126529878 | (37.7343840488548, -122.389126529878) | 10 | 3 | 8 | 58 | 1 | ||
| 33876 | 115549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 925x Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 20x7 | 6015281.58054 | 2104112.34112 | 37.7583501556473 | -122.390170593412 | (37.7583501556473, -122.390170593412) | 10 | 3 | 8 | 28856 | 29 | ||
| 35366 | 116063 | DPW Maintained 1 | Brachychiton discolor :: 437 | 2100x 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 19 | 3x3 | 6011332.66531 | 2105125.78364 | 37.7609130247313 | -122.403899073603 | (37.7609130247313, -122.403899073603) | 10 | 3 | 8 | 28856 | 29 | ||
| 35455 | 47256 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1035 Gilman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/09/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45198 | 6015368.10493708 | 2089617.80548286 | 37.7185559218928 | -122.388859444456 | (37.7185559218928, -122.388859444456) | 10 | 3 | 8 | 58 | 1 |
| 35970 | 122754 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 693 Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 6011277.36342 | 2105334.1858 | 37.7614821606899 | -122.404105006665 | (37.7614821606899, -122.404105006665) | 10 | 3 | 8 | 28856 | 29 | |||
| 36749 | 122752 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 6011278.80569 | 2105286.3398 | 37.7613508668666 | -122.404096651066 | (37.7613508668666, -122.404096651066) | 10 | 3 | 8 | 28856 | 29 | |||
| 38426 | 115550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 925x Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 20x7 | 6015279.22506 | 2104155.94994 | 37.7584697654838 | -122.390181786362 | (37.7584697654838, -122.390181786362) | 10 | 3 | 8 | 28856 | 29 | ||
| 40315 | 116056 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650x Kansas St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/30/2018 12:00:00 AM | 23 | 4x4 | 6011515.19198 | 2105171.68257 | 37.7610492486475 | -122.403271019449 | (37.7610492486475, -122.403271019449) | 10 | 3 | 8 | 28856 | 29 | |
| 41878 | 116060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100x 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7 | 3x3 | 6011408.71891 | 2105130.5396 | 37.7609303321981 | -122.403636370817 | (37.7609303321981, -122.403636370817) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | |||
| 44433 | 94516 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1106X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 08/27/2010 12:00:00 AM | 2 | Permit Number 53703 | 6012787.7377 | 2102360.94736 | 37.7534025731789 | -122.398672553793 | (37.7534025731789, -122.398672553793) | 10 | 3 | 8 | 28856 | 29 | ||
| 45066 | 51362 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Pomona St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014137.60928 | 2094535.47761 | 37.7319905830836 | -122.393456764727 | (37.7319905830836, -122.393456764727) | 10 | 3 | 8 | 58 | 1 |
| 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 | |||
| 47950 | 97078 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 48321 | 108786 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
| 50714 | 97069 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 6x6 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 54757 | 97063 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.389755060411 | (37.7351486000155, -122.389755060411) | 10 | 3 | 8 | 58 | 1 | ||
| 56734 | 173683 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450x Raymond Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6008515 | 2088365 | 37.7147337500707 | -122.412459395375 | (37.7147337500707, -122.412459395375) | 9 | 7 | 8 | 309 | 18 | |||
| 58864 | 116052 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650x Kansas St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/23/2018 12:00:00 AM | 3 | 4x4 | 6011506.55629 | 2105277.69862 | 37.7613398627543 | -122.403308344903 | (37.7613398627543, -122.403308344903) | 10 | 3 | 8 | 28856 | 29 | |
| 59231 | 97070 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 3x3 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||||
| 61767 | 97068 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1551 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 61919 | 43305 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/12/2000 12:00:00 AM | 6 | Permit Number 43072 | 6011285.67007 | 2105193.27319 | 37.7610957103087 | -122.4040663601 | (37.7610957103087, -122.4040663601) | 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 | ||||
| 63669 | 97067 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1551 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/06/2014 12:00:00 AM | 3 | 3x3 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | |
| 66901 | 97080 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1551 Newcomb Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 67548 | 108784 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2055 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005634.22998 | 2088024.32377 | 37.7136362375916 | -122.422392346349 | (37.7136362375916, -122.422392346349) | 9 | 7 | 8 | 309 | 18 |
| 68022 | 108785 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
| 68065 | 98931 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1401X Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6010911 | 2101810 | 37.7517850526072 | -122.405123950338 | (37.7517850526072, -122.405123950338) | 10 | 4 | 8 | 28859 | 19 | ||
| 69692 | 97082 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 3x3 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 70173 | 66890 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1035 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/07/2005 12:00:00 AM | 6 | 3x3 | Permit Number 45482 | 6015368.10493708 | 2089617.80548286 | 37.7185559218928 | -122.388859444456 | (37.7185559218928, -122.388859444456) | 10 | 3 | 8 | 58 | 1 |
| 70543 | 51357 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 50 Pomona St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014147.24137 | 2094593.61459 | 37.732150750552 | -122.393427531355 | (37.732150750552, -122.393427531355) | 10 | 3 | 8 | 58 | 1 |
| 70634 | 108779 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 2055 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005562.18075 | 2088048.73923 | 37.7136992126121 | -122.422643108799 | (37.7136992126121, -122.422643108799) | 9 | 7 | 8 | 309 | 18 |
| 72268 | 94951 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 72589 | 47255 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1035 Gilman Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 05/09/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45198 | 6015368.10493708 | 2089617.80548286 | 37.7185559218928 | -122.388859444456 | (37.7185559218928, -122.388859444456) | 10 | 3 | 8 | 58 | 1 |
| 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 | ||||
| 73796 | 115552 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 925x Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 15x7 | 6015276.56251 | 2104229.20593 | 37.7586707630633 | -122.390196112573 | (37.7586707630633, -122.390196112573) | 10 | 3 | 8 | 28856 | 29 | ||
| 75977 | 96771 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/08/2011 12:00:00 AM | 8 | 4x3 | 6015407.2 | 2095381.5 | 37.7343840488548 | -122.389126529878 | (37.7343840488548, -122.389126529878) | 10 | 3 | 8 | 58 | 1 | |
| 77291 | 98936 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2641 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | Permit Number 48158 | 6011034 | 2101686.1 | 37.7514517258235 | -122.404689875871 | (37.7514517258235, -122.404689875871) | 10 | 4 | 8 | 28859 | 19 | |
| 78450 | 94948 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
| 79109 | 116057 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2100x 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x3 | 6011480.97635 | 2105135.37266 | 37.760947638753 | -122.40338680266 | (37.760947638753, -122.40338680266) | 10 | 3 | 8 | 28856 | 29 | ||
| 80368 | 51358 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 50 Pomona St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014110.4538 | 2094404.71931 | 37.7316300385939 | -122.393541499766 | (37.7316300385939, -122.393541499766) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );