Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65849 | 65849 | 116063 | Undocumented 2 | Brachychiton discolor :: 440 | 2100x 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 19 | 3x3 | 6011332.66531 | 2105125.78364 | 37.760913024731295 | -122.403899073603 | (37.7609130247313, -122.403899073603) | ||
| 13536 | 13536 | 78330 | DPW Maintained 3 | Celtis australis :: European Hackberry 282 | 50 Pomona St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014096.48223 | 2094344.10726 | 37.7314628339206 | -122.39358556204999 | (37.7314628339206, -122.39358556205) | |
| 15298 | 15298 | 78326 | DPW Maintained 3 | Celtis australis :: European Hackberry 282 | 50 Pomona St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014084.32077 | 2094282.11607 | 37.7312919429706 | -122.39362326971799 | (37.7312919429706, -122.393623269718) | |
| 16401 | 16401 | 78328 | DPW Maintained 3 | Celtis australis :: European Hackberry 282 | 50 Pomona St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014090.70522 | 2094312.9836799998 | 37.7313770539035 | -122.39360335692601 | (37.7313770539035, -122.393603356926) | |
| 96570 | 96570 | 75019 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 151X Palm Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/31/1997 12:00:00 AM | 6 | 3x3 | 5995892.05475 | 2113163.21783 | 37.782106991639 | -122.45788265611701 | (37.782106991639, -122.457882656117) | |
| 104670 | 104670 | 74737 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 151X Palm Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/31/1997 12:00:00 AM | 6 | 3x3 | 5995889.08215 | 2113282.06845 | 37.7824331529909 | -122.45790154321101 | (37.7824331529909, -122.457901543211) | |
| 16818 | 16818 | 51361 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 50 Pomona St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014122.20154 | 2094470.50183 | 37.7318113167403 | -122.39350548730499 | (37.7318113167403, -122.393505487305) |
| 5546 | 5546 | 98615 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005320.03726 | 2118764.37328 | 37.798023501349505 | -122.42566486054 | (37.7980235013495, -122.42566486054) | ||
| 5823 | 5823 | 98617 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005326.63971 | 2118722.15466 | 37.7979079528477 | -122.425639007743 | (37.7979079528477, -122.425639007743) | ||
| 6105 | 6105 | 98613 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005313.74464 | 2118810.3056400004 | 37.798149264334604 | -122.42568990577601 | (37.7981492643346, -122.425689905776) | ||
| 6347 | 6347 | 98618 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005334.04674 | 2118673.6419900004 | 37.797775167941 | -122.42560992276199 | (37.797775167941, -122.425609922762) | ||
| 6818 | 6818 | 98620 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005340.01128 | 2118634.45898 | 37.797667918390005 | -122.42558649363998 | (37.79766791839, -122.42558649364) | ||
| 6975 | 6975 | 98619 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005336.89801 | 2118653.3555400004 | 37.7977196276222 | -122.425598612003 | (37.7977196276222, -122.425598612003) | ||
| 7173 | 7173 | 98621 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005341.92436 | 2118613.95929 | 37.797611739554 | -122.42557841412399 | (37.797611739554, -122.425578414124) | ||
| 7275 | 7275 | 98612 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005312.4459 | 2118826.60748 | 37.7981939516456 | -122.42569556069598 | (37.7981939516456, -122.425695560696) | ||
| 8823 | 8823 | 98616 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005322.90286 | 2118744.78417 | 37.7979698765663 | -122.425653549774 | (37.7979698765663, -122.425653549774) | ||
| 8829 | 8829 | 98614 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005316.8578699995 | 2118791.40908 | 37.7980975551137 | -122.425677787418 | (37.7980975551137, -122.425677787418) | ||
| 78641 | 78641 | 116976 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 140503 | 140503 | 116975 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 80947 | 80947 | 73875 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 450X Banks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 8 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 94834 | 94834 | 99679 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 165 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 101534 | 101534 | 96499 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2500X Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5x5 | 6008744.0 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | |||
| 102209 | 102209 | 96492 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2500X Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5x5 | 6008744.0 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | |||
| 122693 | 122693 | 96497 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2500X Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5x5 | 6008744.0 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | |||
| 145524 | 145524 | 96494 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2500X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5x5 | 6008744.0 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | |||
| 10658 | 10658 | 75132 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 148X Paris St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 6 | 3x3 | 6002992.1034699995 | 2092540.72564 | 37.725887878997504 | -122.431846767938 | (37.7258878789975, -122.431846767938) | |
| 12293 | 12293 | 75309 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 125 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 5 | 3x3 | 6002784.56496 | 2092514.51527 | 37.7258041440316 | -122.432562342276 | (37.7258041440316, -122.432562342276) | |
| 82646 | 82646 | 42355 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 380X Flood Ave | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 9 | 8x90 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 88765 | 88765 | 42344 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 380X Flood Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 8 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 100633 | 100633 | 42646 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1600X GREEN ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 10 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 100991 | 100991 | 77990 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 163X London St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/01/2000 12:00:00 AM | 8 | 3x3 | 6002837.0 | 2092721.0 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | |
| 118188 | 118188 | 42645 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1600X GREEN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 6 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 120827 | 120827 | 77992 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 163X London St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/01/2000 12:00:00 AM | 16 | 3x3 | 6002837.0 | 2092721.0 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | |
| 143015 | 143015 | 75386 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 163X London St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837.0 | 2092721.0 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | |
| 145137 | 145137 | 77213 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 499X Hearst Ave | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 8 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 10598 | 10598 | 95755 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003450.901459999 | 2092257.0440599998 | 37.725134950402705 | -122.43024050589399 | (37.7251349504027, -122.430240505894) |
| 10694 | 10694 | 95758 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003422.17585 | 2092210.8120900001 | 37.7250063806226 | -122.43033651031901 | (37.7250063806226, -122.430336510319) |
| 10839 | 10839 | 95753 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003478.85461 | 2092303.3656900001 | 37.7252637225375 | -122.430147177848 | (37.7252637225375, -122.430147177848) |
| 11117 | 11117 | 97240 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003400.64895 | 2092179.59067 | 37.7249194341684 | -122.430408699814 | (37.7249194341684, -122.430408699814) |
| 11480 | 11480 | 95754 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003464.56282 | 2092279.46461 | 37.7251972860232 | -122.43019487878999 | (37.7251972860232, -122.43019487879) |
| 12446 | 12446 | 95750 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003564.18987 | 2092436.8443200001 | 37.7256350580097 | -122.429861698861 | (37.7256350580097, -122.429861698861) |
| 14428 | 14428 | 51357 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 50 Pomona St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014147.24137 | 2094593.6145900001 | 37.732150750552 | -122.393427531355 | (37.732150750552, -122.393427531355) |
| 47436 | 47436 | 97241 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003464.0 | 2092306.9 | 37.725272585613105 | -122.430198780788 | (37.7252725856131, -122.430198780788) |
| 6782 | 6782 | 42639 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1651 Union St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/2014 12:00:00 AM | 8 | 3x3 | Permit Number 42688 | 6005258.416780001 | 2118846.41372 | 37.798245281357204 | -122.425883928195 | (37.7982452813572, -122.425883928195) |
| 11215 | 11215 | 75214 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 125 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 14 | 4x5 | 6002868.59368 | 2092460.8085599998 | 37.725661442297294 | -122.432268027453 | (37.7256614422973, -122.432268027453) | |
| 12861 | 12861 | 75133 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 125 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 14 | 4x4 | 6002899.19862 | 2092441.61812 | 37.7256104849218 | -122.43216085884501 | (37.7256104849218, -122.432160858845) | |
| 86699 | 86699 | 32726 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 200X Farallones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 20 | 6x9 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) |
| 87708 | 87708 | 32729 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 200X Farallones St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) |
| 119394 | 119394 | 42643 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1600X GREEN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 12 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 142357 | 142357 | 42987 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2X Yale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 8 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 145909 | 145909 | 42986 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2X Yale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 3 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
| 19132 | 19132 | 96505 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 50161 | 50161 | 96500 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 77523 | 77523 | 96504 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 81171 | 81171 | 96512 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 82707 | 82707 | 96509 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 88001 | 88001 | 96511 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 96688 | 96688 | 96513 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 97136 | 97136 | 96502 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 106182 | 106182 | 96506 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 111371 | 111371 | 96501 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 144736 | 144736 | 96510 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 127671 | 127671 | 71106 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 4235 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2015 07:32:00 AM | 3 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | |
| 13428 | 13428 | 51364 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014150.64944 | 2094610.63008 | 37.732197660973505 | -122.393416939157 | (37.7321976609735, -122.393416939157) |
| 14765 | 14765 | 51356 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/10/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014174.8382 | 2094728.0237900002 | 37.732521344076204 | -122.393341524701 | (37.7325213440762, -122.393341524701) |
| 15350 | 15350 | 78329 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014093.60126 | 2094328.91133 | 37.731420948908294 | -122.39359445903999 | (37.7314209489083, -122.39359445904) | |
| 15526 | 15526 | 78327 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014087.33436 | 2094297.79766 | 37.7313351688787 | -122.39361394824199 | (37.7313351688787, -122.393613948242) | |
| 15539 | 15539 | 78321 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014066.05948 | 2094191.2042200002 | 37.73104130280179 | -122.39368004209999 | (37.7310413028018, -122.3936800421) | |
| 15702 | 15702 | 51369 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014169.21344 | 2094698.3618 | 37.7324395857978 | -122.39335889598999 | (37.7324395857978, -122.39335889599) |
| 15731 | 15731 | 78323 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014072.33534 | 2094216.7042200002 | 37.731111669349204 | -122.393660129315 | (37.7311116693492, -122.393660129315) | |
| 16338 | 16338 | 51366 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014162.991119999 | 2094669.4439299998 | 37.73235983751729 | -122.39337838521601 | (37.7323598375173, -122.393378385216) |
| 16645 | 16645 | 51363 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014143.519230001 | 2094573.1883599998 | 37.7320944574823 | -122.393438970749 | (37.7320944574823, -122.393438970749) |
| 4317 | 4317 | 37823 | DPW Maintained 3 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 450X Moscow St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/11/2017 09:49:00 AM | 3 | 3x3 | Permit Number 40134 | 6003922.69393 | 2090463.29382 | 37.7202364196636 | -122.428481771941 | (37.7202364196636, -122.428481771941) |
| 2229 | 2229 | 43306 | DPW Maintained 3 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 693 Vermont St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/12/2000 12:00:00 AM | 22 | Permit Number 43072 | 6011289.47877 | 2105149.93268 | 37.7609769197604 | -122.404050137204 | (37.7609769197604, -122.404050137204) | |
| 136374 | 136374 | 116064 | DPW Maintained 3 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 693 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 8x7 | 6011272.30638 | 2105412.17877 | 37.761696029365794 | -122.404127986133 | (37.7616960293658, -122.404127986133) | ||
| 64195 | 64195 | 116061 | Undocumented 2 | Melaleuca spp :: Melaleuca spp 130 | 2100x 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 3x3 | 6011385.89017 | 2105128.48272 | 37.7609234092204 | -122.403715181115 | (37.7609234092204, -122.403715181115) | ||
| 79881 | 79881 | 97900 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 375X Precita Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 3x4 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
| 90380 | 90380 | 99550 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 200X Henry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/19/2016 04:45:00 AM | 3 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | |
| 112310 | 112310 | 95267 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2245 Jones St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 760 | 760 | 38424 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1451 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/24/2005 12:00:00 AM | 12 | 3x3 | Permit Number 48015 | 6007280.7970900005 | 2117415.82487 | 37.79443132398921 | -122.418784361633 | (37.7944313239892, -122.418784361633) |
| 13640 | 13640 | 78324 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014075.45071 | 2094231.93865 | 37.731153673106796 | -122.393650424725 | (37.7311536731068, -122.393650424725) | |
| 15170 | 15170 | 51367 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52508 | 6014166.48709 | 2094684.74927 | 37.732402057093296 | -122.39336736943001 | (37.7324020570933, -122.39336736943) |
| 15757 | 15757 | 78202 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014063.31576 | 2094176.7375400001 | 37.731001427778395 | -122.393688515509 | (37.7310014277784, -122.393688515509) | |
| 16070 | 16070 | 78322 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014069.278530001 | 2094204.9289400002 | 37.7310791669665 | -122.393669873461 | (37.7310791669665, -122.393669873461) | |
| 16461 | 16461 | 51365 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014154.93455 | 2094628.60419 | 37.7322472522973 | -122.39340338185801 | (37.7322472522973, -122.393403381858) |
| 16516 | 16516 | 51368 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014172.092119999 | 2094713.43563 | 37.7324811353964 | -122.393349998121 | (37.7324811353964, -122.393349998121) |
| 10679 | 10679 | 43313 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6003041.97819 | 2092624.14713 | 37.726119762901504 | -122.43168030790399 | (37.7261197629015, -122.431680307904) |
| 10805 | 10805 | 76705 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 4 | 3x3 | 6003030.53484 | 2092605.75448 | 37.726068612152794 | -122.431718554264 | (37.7260686121528, -122.431718554264) | |
| 10863 | 10863 | 99498 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 125 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6002794.02408 | 2092508.7984200001 | 37.725788983259605 | -122.432529234659 | (37.7257889832596, -122.432529234659) | ||
| 11783 | 11783 | 75049 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 6 | 3x3 | 6003005.92399 | 2092563.3958599998 | 37.7259509097926 | -122.431800609333 | (37.7259509097926, -122.431800609333) | |
| 12201 | 12201 | 43311 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003068.93568 | 2092663.2521400002 | 37.7262286645003 | -122.431589908071 | (37.7262286645003, -122.431589908071) |
| 12344 | 12344 | 43312 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003053.84834 | 2092643.73268 | 37.7261742132654 | -122.43164067119899 | (37.7261742132654, -122.431640671199) |
| 12381 | 12381 | 75048 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 6 | 3x3 | 6003019.452409999 | 2092585.35122 | 37.7260119611657 | -122.431755409402 | (37.7260119611657, -122.431755409402) | |
| 23245 | 23245 | 76756 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1501X 42nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 2 | 3x12 | 5983095.0741 | 2104639.3384 | 37.757959352781 | -122.501522927406 | (37.757959352781, -122.501522927406) | |
| 23276 | 23276 | 76755 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1501X 42nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 3 | 3x12 | 5983093.5463 | 2104662.8676 | 37.758023867602 | -122.501529951702 | (37.758023867602, -122.501529951702) | |
| 93482 | 93482 | 75385 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 163X London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837.0 | 2092721.0 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | |
| 94986 | 94986 | 77991 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 163X London St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/01/2000 12:00:00 AM | 10 | 3x3 | 6002837.0 | 2092721.0 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | |
| 122095 | 122095 | 43310 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 150X Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6002773.36898986 | 2092525.07870875 | 37.7258325139415 | -122.432601800105 | (37.7258325139415, -122.432601800105) |
| 9734 | 9734 | 173682 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) | |||
| 9739 | 9739 | 173683 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");