Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77584 | 77584 | 103197 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 78768 | 78768 | 40741 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 60 Alviso St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1999 12:00:00 AM | Permit Number 41718 | 5992200.51411552 | 2091694.39813825 | 37.7229464099622 | -122.46909064509899 | (37.7229464099622, -122.469090645099) | |||
| 83617 | 83617 | 103231 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 22 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 84664 | 84664 | 103228 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 84701 | 84701 | 42213 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 963 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42480 | 6011658.35372103 | 2111289.20991303 | 37.7778545845813 | -122.403206224165 | (37.7778545845813, -122.403206224165) | ||
| 86342 | 86342 | 45158 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 101 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2001 12:00:00 AM | Permit Number 44011 | 6009592.49240283 | 2098004.38500436 | 37.7412618732658 | -122.409414999284 | (37.7412618732658, -122.409414999284) | ||
| 86906 | 86906 | 43051 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2000 41st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | Permit Number 42904 | 5983558.17532527 | 2101519.50178416 | 37.7494203390776 | -122.499690770945 | (37.7494203390776, -122.499690770945) | ||
| 87206 | 87206 | 103229 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 87515 | 87515 | 43053 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2000 41st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | Permit Number 42904 | 5983558.17532527 | 2101519.50178416 | 37.7494203390776 | -122.499690770945 | (37.7494203390776, -122.499690770945) | ||
| 87623 | 87623 | 31859 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 603 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42495 | 6009703.09193941 | 2111483.74896598 | 37.7782793527016 | -122.409983922333 | (37.7782793527016, -122.409983922333) | ||
| 89755 | 89755 | 43360 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 4200 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43111 | 6001851.83191534 | 2102376.12242955 | 37.7528288829737 | -122.436492245154 | (37.7528288829737, -122.436492245154) | ||
| 91287 | 91287 | 37767 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 757 Bacon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271002 | (37.7258696386057, -122.41005757271) | ||
| 92126 | 92126 | 45316 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 739 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44153 | 5992112.57362646 | 2090471.95346901 | 37.719584794705 | -122.46930570018 | (37.719584794705, -122.46930570018) | ||
| 93162 | 93162 | 42212 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 963 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42480 | 6011658.35372103 | 2111289.20991303 | 37.7778545845813 | -122.403206224165 | (37.7778545845813, -122.403206224165) | |||
| 94387 | 94387 | 87294 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2087 28th Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/20/2008 12:00:00 AM | Permit Number 50307 | 5987541.6 | 2101099.3 | 37.7484995140672 | -122.48588532379298 | (37.7484995140672, -122.485885323793) | ||||
| 94708 | 94708 | 40750 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 50 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41721 | 5992599.375194 | 2093012.15972087 | 37.72658769818779 | -122.467807672314 | (37.7265876981878, -122.467807672314) | ||
| 95169 | 95169 | 43402 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 224 Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43145 | 6000589.19693618 | 2103093.40902085 | 37.754726548937995 | -122.44091010962099 | (37.754726548938, -122.440910109621) | ||
| 95247 | 95247 | 103226 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 95315 | 95315 | 49566 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 156 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2003 12:00:00 AM | Permit Number 46451 | 6005497.65497222 | 2099068.87265965 | 37.743954431092604 | -122.423649179655 | (37.7439544310926, -122.423649179655) | |||
| 99186 | 99186 | 45330 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 471 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44163 | 5993999.8706027 | 2089674.33515151 | 37.7175036072534 | -122.462724216271 | (37.7175036072534, -122.462724216271) | ||
| 99447 | 99447 | 106022 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 181 Buena Vista Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 771765 | 6001436.7 | 2108377.5 | 37.7692836023561 | -122.438357764726 | (37.7692836023561, -122.438357764726) | |||||
| 103336 | 103336 | 43054 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2000 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | Permit Number 42904 | 5983558.17532527 | 2101519.50178416 | 37.7494203390776 | -122.499690770945 | (37.7494203390776, -122.499690770945) | ||
| 104711 | 104711 | 103230 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 107355 | 107355 | 44381 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 71 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/2002 12:00:00 AM | Permit Number 45656 | 5994124.44612639 | 2090395.30324918 | 37.7194903870698 | -122.462345881218 | (37.7194903870698, -122.462345881218) | ||
| 107523 | 107523 | 103198 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 107597 | 107597 | 40755 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 128 Corona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41724 | 5993008.60966906 | 2092048.1240652 | 37.723964314454996 | -122.46632294355 | (37.723964314455, -122.46632294355) | ||
| 108046 | 108046 | 37766 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 757 Bacon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271002 | (37.7258696386057, -122.41005757271) | ||
| 108101 | 108101 | 103227 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 108660 | 108660 | 40793 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 456 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41742 | 5992180.76921934 | 2091949.45696534 | 37.7236455979149 | -122.469177453156 | (37.7236455979149, -122.469177453156) | ||
| 109331 | 109331 | 103194 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 110870 | 110870 | 53043 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 331@ ALABAMA Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2006 12:00:00 AM | Permit Number 49021 | 6009634.4560959 | 2099333.48730709 | 37.7449136491377 | -122.40936367722 | (37.7449136491377, -122.40936367722) | |||
| 111815 | 111815 | 37768 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 757 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271002 | (37.7258696386057, -122.41005757271) | ||
| 113064 | 113064 | 103225 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 116192 | 116192 | 56794 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1303 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/1974 12:00:00 AM | 3x3 | Permit Number 14019 | 6000327.28850998 | 2109204.10022929 | 37.7714900745599 | -122.4422544996 | (37.7714900745599, -122.4422544996) | ||
| 117509 | 117509 | 45308 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 73 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2001 12:00:00 AM | Permit Number 44146 | 5994124.56129727 | 2090407.79680159 | 37.7195246979994 | -122.462346388785 | (37.7195246979994, -122.462346388785) | ||
| 118475 | 118475 | 43262 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 449 Holyoke St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | ||
| 118881 | 118881 | 103195 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 119766 | 119766 | 31857 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 603 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42495 | 6009703.09193941 | 2111483.74896598 | 37.7782793527016 | -122.409983922333 | (37.7782793527016, -122.409983922333) | ||
| 122287 | 122287 | 43359 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 4140 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43110 | 6002236.76771757 | 2102396.97114609 | 37.752907994756704 | -122.43516255919201 | (37.7529079947567, -122.435162559192) | ||
| 122596 | 122596 | 37769 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 757 Bacon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271002 | (37.7258696386057, -122.41005757271) | ||
| 122825 | 122825 | 40754 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 128 Corona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41724 | 5993008.60966906 | 2092048.1240652 | 37.723964314454996 | -122.46632294355 | (37.723964314455, -122.46632294355) | ||
| 124567 | 124567 | 103199 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 125480 | 125480 | 43052 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2000 41st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | Permit Number 42904 | 5983558.17532527 | 2101519.50178416 | 37.7494203390776 | -122.499690770945 | (37.7494203390776, -122.499690770945) | ||
| 127464 | 127464 | 48578 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 600 Beacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2002 12:00:00 AM | Permit Number 45891 | 6009717.95437721 | 2092589.77747592 | 37.7264015474603 | -122.408599322266 | (37.7264015474603, -122.408599322266) | |||
| 139157 | 139157 | 31861 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 603 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42495 | 6009703.09193941 | 2111483.74896598 | 37.7782793527016 | -122.409983922333 | (37.7782793527016, -122.409983922333) | ||
| 140434 | 140434 | 103232 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1600X 29th Ave | 23 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 143547 | 143547 | 37765 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 757 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271002 | (37.7258696386057, -122.41005757271) | ||
| 146077 | 146077 | 35868 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1 Boutwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | Permit Number 39080 | 6010677.15913478 | 2096883.63230355 | 37.7382452410033 | -122.405585668988 | (37.7382452410033, -122.405585668988) | ||
| 146286 | 146286 | 103200 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 182999 | 182999 | 103192 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 0 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | |||
| 16809 | 16809 | 73565 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1501 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770154 | 6015647.31227 | 2096389.49505 | 37.737165106784396 | -122.388366706276 | (37.7371651067844, -122.388366706276) | |
| 37906 | 37906 | 96615 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1224 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767286 | 6008996.31071 | 2117161.4041 | 37.7938291883275 | -122.412830459354 | (37.7938291883275, -122.412830459354) | |
| 42025 | 42025 | 37797 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 407 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 1 | Permit Number 40124 | 6010065.36404 | 2092583.8602200001 | 37.7264047508705 | -122.407397920192 | (37.7264047508705, -122.407397920192) | |
| 69997 | 69997 | 132143 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 525 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004895.042769999 | 2111066.14782 | 37.7768620758709 | -122.42658700288099 | (37.7768620758709, -122.426587002881) | |||
| 73352 | 73352 | 96614 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1224 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767286 | 6008998.07345 | 2117142.60049 | 37.7937776571604 | -122.41282303006399 | (37.7937776571604, -122.412823030064) | |
| 74196 | 74196 | 132144 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 525 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004910.2643099995 | 2111067.91228 | 37.7768677811601 | -122.426534472605 | (37.7768677811601, -122.426534472605) | |||
| 135891 | 135891 | 178101 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 450 Holyoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009849.55094 | 2092272.62028 | 37.7255380696985 | -122.408122039001 | (37.7255380696985, -122.408122039001) | |||
| 152546 | 152546 | 178110 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 200 Morse St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000629.25093 | 2087886.03147 | 37.712972912055 | -122.439681411561 | (37.712972912055, -122.439681411561) | |||
| 160217 | 160217 | 132142 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 525 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004877.96842 | 2111064.0055400003 | 37.7768552284082 | -122.426645915672 | (37.7768552284082, -122.426645915672) | |||
| 167829 | 167829 | 210944 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 471 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5994007.18286 | 2089638.21665 | 37.7174048556293 | -122.462696322689 | (37.7174048556293, -122.462696322689) | |||
| 168586 | 168586 | 210935 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 147 Chaves Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996689.45961 | 2098368.41594 | 37.741530012206795 | -122.454055155315 | (37.7415300122068, -122.454055155315) | |||
| 173546 | 173546 | 178100 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 450 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009850.68827 | 2092261.7739400002 | 37.7255083516043 | -122.40811734273399 | (37.7255083516043, -122.408117342734) | |||
| 188146 | 188146 | 194411 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 98 Ceres St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 1ft | 6013808.40909 | 2093727.99468 | 37.729755103205 | -122.39453836675301 | (37.729755103205, -122.394538366753) | |||
| 24648 | 24648 | 183459 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2530 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989571.117000001 | 2098107.4281 | 37.7404026737429 | -122.47864859712 | (37.7404026737429, -122.47864859712) | |||
| 24748 | 24748 | 210946 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 78 Lobos St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5996128.662169999 | 2088702.9665 | 37.714958832754 | -122.455295843853 | (37.714958832754, -122.455295843853) | ||||
| 24880 | 24880 | 178117 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988789.573419999 | 2089765.1297400002 | 37.717451446800204 | -122.480740256365 | (37.7174514468002, -122.480740256365) | ||||
| 29203 | 29203 | 210954 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 462 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 5999009.76671 | 2094995.92761 | 37.732402733380795 | -122.44578987220301 | (37.7324027333808, -122.445789872203) | |||
| 32653 | 32653 | 194410 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1700x Quesada Ave | 42 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6014359.990180001 | 2095279.52622 | 37.7340459422739 | -122.39273997266899 | (37.7340459422739, -122.392739972669) | ||||
| 36228 | 36228 | 178111 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 200 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6000616.294969999 | 2087881.86398 | 37.712960731619 | -122.43972589293399 | (37.712960731619, -122.439725892934) | |||
| 40916 | 40916 | 140013 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 840 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004880.8164 | 2111850.7611 | 37.7790156271835 | -122.42669210332899 | (37.7790156271835, -122.426692103329) | |||
| 46331 | 46331 | 140232 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2217 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997153.7791 | 2110495.4596 | 37.774854433410894 | -122.453325023475 | (37.7748544334109, -122.453325023475) | |||
| 48860 | 48860 | 183458 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2530 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989571.117000001 | 2098094.1306 | 37.740366162256606 | -122.47864762489401 | (37.7403661622566, -122.478647624894) | |||
| 50063 | 50063 | 194419 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1548 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015902.62004 | 2095929.8973700001 | 37.7359172884615 | -122.387451930266 | (37.7359172884615, -122.387451930266) | |||
| 54944 | 54944 | 234436 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 3734 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6004821.76707 | 2102536.50237 | 37.7534375658093 | -122.42623307379499 | (37.7534375658093, -122.426233073795) | |||
| 60239 | 60239 | 178116 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988774.083930001 | 2089765.9400900002 | 37.7174527715132 | -122.480793855056 | (37.7174527715132, -122.480793855056) | ||||
| 60889 | 60889 | 178099 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 475 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009870.22482 | 2092198.24037 | 37.7253349956071 | -122.40804532773501 | (37.7253349956071, -122.408045327735) | |||
| 63408 | 63408 | 234427 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 268 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008861.7546 | 2107017.31377 | 37.7659683774771 | -122.412578614117 | (37.7659683774771, -122.412578614117) | |||
| 69110 | 69110 | 210971 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1901 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991557.235669999 | 2102412.45554 | 37.752338284906 | -122.47209516077801 | (37.752338284906, -122.472095160778) | |||
| 72371 | 72371 | 210938 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 140 Jules Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5994485.61815 | 2090821.9802299999 | 37.7206827307129 | -122.46112836188699 | (37.7206827307129, -122.461128361887) | |||
| 73084 | 73084 | 194418 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1548 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015914.234209999 | 2095920.1543400001 | 37.7358911793201 | -122.38741109563999 | (37.7358911793201, -122.38741109564) | |||
| 134702 | 134702 | 194412 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 98 Ceres St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 6013804.87459 | 2093712.0734400002 | 37.729711190223 | -122.394549471574 | (37.729711190223, -122.394549471574) | |||
| 150912 | 150912 | 194415 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 352 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011565.081590001 | 2112704.30706 | 37.781734903080896 | -122.403628477474 | (37.7817349030809, -122.403628477474) | |||
| 158242 | 158242 | 210986 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1 Pizarro Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5995099.57616 | 2093947.59024 | 37.7293002171239 | -122.45923233653 | (37.7293002171239, -122.45923233653) | |||
| 160695 | 160695 | 138930 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 666 IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004176.0708 | 2110989.9993 | 37.776612318606794 | -122.429068714009 | (37.7766123186068, -122.429068714009) | |||
| 165883 | 165883 | 178118 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988803.05395 | 2089760.9840900002 | 37.7174408474004 | -122.480693357611 | (37.7174408474004, -122.480693357611) | ||||
| 166317 | 166317 | 182203 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1659 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989632.7475 | 2104072.0115 | 37.7567834283184 | -122.47887164614299 | (37.7567834283184, -122.478871646143) | |||
| 169577 | 169577 | 182437 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1551 20th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989914.2293 | 2104805.4779 | 37.7588136721701 | -122.47795180831801 | (37.7588136721701, -122.477951808318) | |||
| 180562 | 180562 | 210940 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 71 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994126.22956 | 2090303.0599200001 | 37.7192372117057 | -122.462333029842 | (37.7192372117057, -122.462333029842) | |||
| 2074 | 2074 | 141405 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 500 IVY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 3 | Width 0ft | Permit Number 34950 | 6004899.5578 | 2111091.1041 | 37.7769308549567 | -122.426573161514 | (37.7769308549567, -122.426573161514) | |
| 4485 | 4485 | 18883 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2323 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/2009 12:00:00 AM | 3 | 2X2 | 6003550.924930001 | 2115900.91625 | 37.7900610577251 | -122.431581959853 | (37.7900610577251, -122.431581959853) | ||
| 10026 | 10026 | 66781 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 63 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2017 12:00:00 AM | 3 | Permit Number 30050 | 6005821.27951384 | 2106893.65445384 | 37.7654577301272 | -122.423086219508 | (37.7654577301272, -122.423086219508) | |
| 11839 | 11839 | 83664 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 75 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769750 | 6003631.23676 | 2092962.7354 | 37.727082834286705 | -122.429667413832 | (37.7270828342867, -122.429667413832) |
| 15629 | 15629 | 101309 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 250 Napoleon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6012087.5096 | 2099832.08135 | 37.7464198168313 | -122.40091644235399 | (37.7464198168313, -122.400916442354) | |||
| 16192 | 16192 | 101310 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 250 Napoleon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6012064.796159999 | 2099822.57577 | 37.746392449557206 | -122.400994315548 | (37.7463924495572, -122.400994315548) | |||
| 17822 | 17822 | 9388 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 413 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001286.51839 | 2097494.94671 | 37.739394192481896 | -122.43809757416 | (37.7393941924819, -122.43809757416) | |||
| 21776 | 21776 | 15063 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1X Minerva St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5995983.74533 | 2089004.6361 | 37.7157788310068 | -122.455818528899 | (37.7157788310068, -122.455818528899) | |||
| 24147 | 24147 | 210947 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 171 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992177.81487 | 2089015.3385599998 | 37.715589054271 | -122.468974238973 | (37.715589054271, -122.468974238973) | |||
| 25186 | 25186 | 194408 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 670 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014377.03674 | 2104046.7592599997 | 37.758119869848706 | -122.393294339956 | (37.7581198698487, -122.393294339956) | |||
| 25277 | 25277 | 210945 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 78 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5996140.80305 | 2088701.9398299998 | 37.7149567103495 | -122.455253805936 | (37.7149567103495, -122.455253805936) | ||||
| 26193 | 26193 | 210969 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1901 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991556.95578 | 2102433.12062 | 37.7523950096285 | -122.472097634809 | (37.7523950096285, -122.472097634809) |
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");