trees
1,098 rows where qCaretaker_id = 4 sorted by SiteOrder 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152716 | 96497 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2500X Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5x5 | 6008744 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | 2 | 4 | 7 | 28859 | 19 | |||
| 154088 | 95241 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
| 157508 | 99686 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
| 165008 | 98682 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
| 165305 | 93105 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53160 | 5995888.42271 | 2113224.45495 | 37.7822749237882 | -122.457899654053 | (37.7822749237882, -122.457899654053) | 11 | 6 | 1 | 54 | 31 |
| 168362 | 95269 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2245 Jones St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6x6 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |||
| 169917 | 98974 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6008234.2 | 2102998.9 | 37.7548994960031 | -122.414464835105 | (37.7548994960031, -122.414464835105) | 2 | 4 | 7 | 28859 | 19 | ||
| 170197 | 99330 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 4x4 | 5986582.50919 | 2112777.47658 | 37.780508610058 | -122.490060647344 | (37.780508610058, -122.490060647344) | 11 | 6 | 2 | 55 | 26 | ||
| 174726 | 112028 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2101x 22nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 9x9 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 176834 | 37820 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003945.80086 | 2090498.97809 | 37.7203357084188 | -122.428404441018 | (37.7203357084188, -122.428404441018) | 9 | 7 | 6 | 28861 | 5 |
| 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 | ||||
| 182607 | 100976 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 450X Chestnut St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 5 | Permit Number 37341 | 6009558.1383 | 2120880.7372 | 37.8040730797801 | -122.411149322876 | (37.8040730797801, -122.411149322876) | 3 | 1 | 10 | 308 | 23 | ||
| 183257 | 98751 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
| 184034 | 76675 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 163X London St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 8 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
| 191936 | 100987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
| 192959 | 76112 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
| 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 | |||
| 7708 | 76081 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
| 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 |
| 9739 | 77653 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006717.25868 | 2093269.99639 | 37.7281007670162 | -122.41902083924 | (37.7281007670162, -122.41902083924) | 9 | 3 | 7 | 309 | 5 | ||
| 10649 | 76037 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 4x6 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
| 11183 | 74883 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995886.83117 | 2113252.75826 | 37.7823525456975 | -122.457907208857 | (37.7823525456975, -122.457907208857) | 11 | 6 | 1 | 54 | 31 | |
| 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 | |||
| 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 | ||
| 14855 | 75049 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6003005.92399 | 2092563.39586 | 37.7259509097926 | -122.431800609333 | (37.7259509097926, -122.431800609333) | 9 | 7 | 6 | 28861 | 5 | ||
| 15793 | 42348 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
| 17099 | 96505 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | ||
| 17218 | 77646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006863.07514 | 2093156.65739 | 37.7277977728371 | -122.418508712231 | (37.7277977728371, -122.418508712231) | 9 | 3 | 7 | 309 | 5 | ||
| 17940 | 42637 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:43:00 AM | 3 | 4x4 | Permit Number 42688 | 6005203.48268 | 2118840.06651 | 37.7982247489172 | -122.42607356464 | (37.7982247489172, -122.42607356464) | 13 | 9 | 1 | 57 | 17 |
| 18929 | 76784 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 1 | 3x12 | 5983097.2131 | 2104562.028 | 37.7577472058325 | -122.501509810878 | (37.7577472058325, -122.501509810878) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | ||
| 22336 | 98569 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301X Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
| 23498 | 76685 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 163X London St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
| 25379 | 70471 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 450X Banks St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 32 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
| 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 | ||
| 38417 | 95498 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | 3x3 | 5985976.05543 | 2112422.37376 | 37.7794981665366 | -122.492132474117 | (37.7794981665366, -122.492132474117) | 11 | 6 | 2 | 55 | 26 | |||
| 38478 | 98628 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x4 | 6002274.71062 | 2120096.76485 | 37.8015093491298 | -122.43629795789 | (37.8015093491298, -122.43629795789) | 13 | 9 | 1 | 57 | 17 | ||
| 41372 | 95268 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2245 Jones St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | ||||
| 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 | |||
| 44331 | 95756 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 04:16:00 PM | 3 | 3x3 | Permit Number 767495 | 6003442.24703 | 2092244.67659 | 37.7251005018853 | -122.430269541405 | (37.7251005018853, -122.430269541405) | 9 | 7 | 6 | 28861 | 5 |
| 49228 | 97251 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 301X Excelsior Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003227.5697 | 2092233.02297 | 37.7250563415646 | -122.431010826505 | (37.7250563415646, -122.431010826505) | 9 | 7 | 6 | 28861 | 5 |
| 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 | |||
| 49823 | 98650 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | 5x5 | 6002693.158 | 2119231.97091 | 37.7991586175436 | -122.434788065428 | (37.7991586175436, -122.434788065428) | 13 | 9 | 1 | 57 | 17 | ||
| 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 | ||||
| 56802 | 99677 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/04/2013 12:00:00 AM | 16 | 3x3 | Permit Number 770537 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 |
| 58468 | 100975 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 450X Chestnut St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | Permit Number 37341 | 6009580.8633 | 2120886.4184 | 37.8040899533369 | -122.411071082632 | (37.8040899533369, -122.411071082632) | 3 | 1 | 10 | 308 | 23 | ||
| 62860 | 32726 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 200X Farallones St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/29/1996 12:00:00 AM | 20 | 6x9 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 |
| 66136 | 99033 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
| 66275 | 142545 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301 FRANCISCO ST | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 20 | Width 0ft | 6009562.3577 | 2121186.5007 | 37.8049128667558 | -122.411156332795 | (37.8049128667558, -122.411156332795) | 3 | 1 | 10 | 308 | 23 | |||
| 71171 | 98681 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||||
| 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 | ||||
| 74685 | 30746 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004256.1031 | 2109802.2559 | 37.7733555963905 | -122.428707169176 | (37.7733555963905, -122.428707169176) | 7 | 9 | 11 | 28852 | 10 |
| 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 | |
| 81164 | 95151 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 13 | 5988720.99449 | 2113605.53219 | 37.7829068638151 | -122.482723403965 | (37.7829068638151, -122.482723403965) | 11 | 6 | 2 | 55 | 26 | |||
| 81644 | 110960 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 940 Filbert St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 5x5 | 6008419.49323 | 2119686.5094 | 37.8007301081687 | -122.415005118088 | (37.8007301081687, -122.415005118088) | 5 | 1 | 10 | 308 | 32 | ||
| 83941 | 98943 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400X San Bruno Ave | 7 | 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 | ||
| 84673 | 98750 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
| 87595 | 97901 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 375X Precita Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 6 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
| 96888 | 99353 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986836.83736 | 2113054.13933 | 37.781283095456 | -122.489201164445 | (37.781283095456, -122.489201164445) | 11 | 6 | 2 | 55 | 26 | ||
| 100854 | 99553 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | ||
| 102251 | 95513 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5985988.88946 | 2112008.28561 | 37.7783619491242 | -122.49205757976 | (37.7783619491242, -122.49205757976) | 11 | 6 | 2 | 55 | 26 | |||
| 103631 | 37819 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 450X Moscow St | 7 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003953.55423 | 2090513.34715 | 37.7203756014419 | -122.428378663762 | (37.7203756014419, -122.428378663762) | 9 | 7 | 6 | 28861 | 5 |
| 110301 | 42989 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
| 110693 | 98618 | DPW Maintained 1 | Vitex lucens :: Puriri tree 492 | 2501X Franklin St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6005334.04674 | 2118673.64199 | 37.797775167941 | -122.425609922762 | (37.797775167941, -122.425609922762) | 13 | 9 | 1 | 57 | 17 | ||
| 117978 | 99025 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351X 23rd St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006571 | 2102346.4 | 37.7530143054678 | -122.420170352411 | (37.7530143054678, -122.420170352411) | 2 | 4 | 7 | 28859 | 19 | ||
| 118940 | 95491 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986009.30138 | 2111441.61533 | 37.7768072273274 | -122.491945237383 | (37.7768072273274, -122.491945237383) | 11 | 6 | 2 | 55 | 26 | |||
| 126216 | 225507 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 17 | 6x6 | 6004191.74013 | 2106290.72293 | 37.7637101339293 | -122.428679441106 | (37.7637101339293, -122.428679441106) | 8 | 4 | 5 | 28862 | 3 | |||
| 129482 | 102027 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 132313 | 73528 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4235 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/05/1995 12:00:00 AM | 12 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | 2 | 4 | 5 | 28862 | 3 | |
| 134813 | 122751 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 693 Vermont St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 6011280.99043 | 2105260.13165 | 37.7612790272197 | -122.404087250433 | (37.7612790272197, -122.404087250433) | 10 | 3 | 8 | 28856 | 29 | |||
| 135797 | 97066 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.389755060411 | (37.7351486000155, -122.389755060411) | 10 | 3 | 8 | 58 | 1 | ||
| 149719 | 98608 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6002968.64851 | 2116857.31006 | 37.7926540495901 | -122.433664967757 | (37.7926540495901, -122.433664967757) | 13 | 9 | 1 | 29490 | 27 | ||
| 154352 | 42367 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Foerster St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
| 169090 | 98805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768771 | 6010143.10639 | 2117195.10642 | 37.793986029186 | -122.408864800763 | (37.793986029186, -122.408864800763) | 3 | 1 | 10 | 28857 | 4 |
| 170711 | 95240 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 12 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | |||
| 173163 | 97729 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | Permit Number 50638 | 6005819.00921 | 2120706.70735 | 37.8033848375917 | -122.424076473471 | (37.8033848375917, -122.424076473471) | 5 | 9 | 1 | 28858 | 32 | |
| 175889 | 99669 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x6 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 183831 | 102192 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
| 183898 | 73288 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
| 185618 | 98973 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6008234.2 | 2102998.9 | 37.7548994960031 | -122.414464835105 | (37.7548994960031, -122.414464835105) | 2 | 4 | 7 | 28859 | 19 | ||
| 188665 | 47198 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/2002 12:00:00 AM | 8 | 4x4 | Permit Number 45157 | 5986584.00139 | 2112756.95832 | 37.7804523599117 | -122.490053975567 | (37.7804523599117, -122.490053975567) | 11 | 6 | 2 | 55 | 26 |
| 190317 | 95259 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2290X 14th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5992014.7 | 2099861.3 | 37.745359932747 | -122.470327420537 | (37.745359932747, -122.470327420537) | 1 | 8 | 4 | 29491 | 40 | ||||
| 193525 | 99685 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
| 167 | 99668 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 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 | |||
| 2915 | 223666 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1511 Castro St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/16/2016 05:50:00 AM | 2 | Width 3ft | 6002610.0457 | 2101075.27233 | 37.7493001124297 | -122.433777236447 | (37.7493001124297, -122.433777236447) | 2 | 4 | 5 | 28862 | 22 | ||
| 3324 | 100985 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 03/23/2016 02:34:00 PM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |
| 3404 | 74737 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 151X Palm Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5995889.08215 | 2113282.06845 | 37.7824331529909 | -122.457901543211 | (37.7824331529909, -122.457901543211) | 11 | 6 | 1 | 54 | 31 | ||
| 4815 | 98680 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199X Park St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6006189.1 | 2096374.1 | 37.7365941955595 | -122.421067016387 | (37.7365941955595, -122.421067016387) | 2 | 7 | 7 | 28859 | 2 | ||||
| 5633 | 76756 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x12 | 5983095.0741 | 2104639.3384 | 37.757959352781 | -122.501522927406 | (37.757959352781, -122.501522927406) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | |||
| 6638 | 77652 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006723.02825 | 2093252.77715 | 37.7280538116191 | -122.41899967279 | (37.7280538116191, -122.41899967279) | 9 | 3 | 7 | 309 | 5 | ||
| 7380 | 75048 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6003019.45241 | 2092585.35122 | 37.7260119611657 | -122.431755409402 | (37.7260119611657, -122.431755409402) | 9 | 7 | 6 | 28861 | 5 | ||
| 7775 | 77645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006883.85072 | 2093162.97754 | 37.7278162961767 | -122.418437338432 | (37.7278162961767, -122.418437338432) | 9 | 3 | 7 | 309 | 5 | ||
| 9740 | 75309 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 125 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6002784.56496 | 2092514.51527 | 37.7258041440316 | -122.432562342276 | (37.7258041440316, -122.432562342276) | 9 | 7 | 6 | 28861 | 5 | ||
| 11601 | 95514 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |
| 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 |
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) );