Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 120509 | 120509 | 42825 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 121909 | 121909 | 49971 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 168@ DOUGLASS Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/08/2005 12:00:00 AM | Permit Number 48111 | 6000192.99372442 | 2104905.40226883 | 37.7596792654558 | -122.44241036439301 | (37.7596792654558, -122.442410364393) | ||
| 122747 | 122747 | 37294 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 261 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39823 | 6003941.02088917 | 2104485.98513979 | 37.7587405625745 | -122.42941789284599 | (37.7587405625745, -122.429417892846) | ||
| 123571 | 123571 | 42821 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 124574 | 124574 | 87268 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 727 Moraga St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/05/2008 12:00:00 AM | Permit Number 50290 | 5992077.0 | 2103851.0 | 37.756318217439706 | -122.47040250406201 | (37.7563182174397, -122.470402504062) | ||||
| 124888 | 124888 | 48984 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 4215 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2002 12:00:00 AM | Permit Number 46171 | 6002499.14803074 | 2100605.29142344 | 37.7480033622388 | -122.43412712945299 | (37.7480033622388, -122.434127129453) | ||
| 125182 | 125182 | 34411 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 191 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38159 | 6004342.16299585 | 2097508.24193041 | 37.739604003626795 | -122.427533446458 | (37.7396040036268, -122.427533446458) | ||
| 125292 | 125292 | 40738 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 20 Alviso St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1999 12:00:00 AM | Permit Number 41717 | 5992072.81756498 | 2091384.27409538 | 37.7220875062624 | -122.469509497536 | (37.7220875062624, -122.469509497536) | |||
| 125410 | 125410 | 45536 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 79 Melba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | Permit Number 44293 | 5989585.76469698 | 2094846.08328142 | 37.7314487101847 | -122.478359538262 | (37.7314487101847, -122.478359538262) | |||
| 125842 | 125842 | 37280 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 700 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39817 | 6003661.86134005 | 2104206.66341524 | 37.7579578025996 | -122.430363425655 | (37.7579578025996, -122.430363425655) | |||
| 126150 | 126150 | 42826 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 126538 | 126538 | 43593 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2014 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43254 | 5986663.03161814 | 2101533.45903453 | 37.7496403612652 | -122.488955268867 | (37.7496403612652, -122.488955268867) | ||
| 127057 | 127057 | 116678 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 100 Esmeralda Ave | 17 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 127386 | 127386 | 42819 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 128301 | 128301 | 45396 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 135 Corona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | Permit Number 44206 | 5992967.23882057 | 2092102.4527906997 | 37.72411110068 | -122.466469901656 | (37.72411110068, -122.466469901656) | ||
| 129209 | 129209 | 37309 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 136522 | 136522 | 204722 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 422 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5993793.315830001 | 2090006.70292 | 37.7184043108851 | -122.46346228245501 | (37.7184043108851, -122.463462282455) | ||||
| 138640 | 138640 | 37856 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 50 Ina Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.42496422599702 | (37.7235254489092, -122.424964225997) | |||
| 139508 | 139508 | 37304 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 141053 | 141053 | 51954 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 82 Mary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2005 12:00:00 AM | Permit Number 48176 | 6010868.83737248 | 2112458.01845687 | 37.781019735711006 | -122.40601981145599 | (37.781019735711, -122.406019811456) | |||
| 141381 | 141381 | 42823 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 141695 | 141695 | 37284 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 700 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39817 | 6003661.86134005 | 2104206.66341524 | 37.7579578025996 | -122.430363425655 | (37.7579578025996, -122.430363425655) | |||
| 142039 | 142039 | 36072 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1504 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39187 | 6009387.99483758 | 2107777.56202059 | 37.7680853638298 | -122.410812146882 | (37.7680853638298, -122.410812146882) | ||
| 143101 | 143101 | 37299 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 144682 | 144682 | 106923 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 196 States St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | Permit Number 772939 | 6001039.87531 | 2106387.50014 | 37.7637969766711 | -122.43958767886002 | (37.7637969766711, -122.43958767886) | |||
| 144836 | 144836 | 51903 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 168 Caselli Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48111 | 6000192.99372442 | 2104905.40226883 | 37.7596792654558 | -122.44241036439301 | (37.7596792654558, -122.442410364393) | |||
| 145383 | 145383 | 37308 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 146973 | 146973 | 187576 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 Bishop St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010826.85106 | 2089479.8583099998 | 37.7179243930824 | -122.40454707471301 | (37.7179243930824, -122.404547074713) | ||||
| 149036 | 149036 | 32269 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2033 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 4 | Permit Number 36855 | 6011970.48286 | 2103707.9911700003 | 37.7570556930908 | -122.40159347895 | (37.7570556930908, -122.40159347895) | |
| 149164 | 149164 | 175811 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 15 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6005336.45581 | 2093162.3032099998 | 37.727727212929004 | -122.423786672331 | (37.727727212929, -122.423786672331) | ||||
| 155156 | 155156 | 125935 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1132 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6007463.08276 | 2119890.85277 | 37.8012373932575 | -122.418329199431 | (37.8012373932575, -122.418329199431) | ||||
| 162264 | 162264 | 187573 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 73 Bishop St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6010858.37792 | 2089492.3055900002 | 37.717960332674295 | -122.404438975305 | (37.7179603326743, -122.404438975305) | ||||
| 162790 | 162790 | 222684 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1100 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004829.85448 | 2096667.61167 | 37.7373233955514 | -122.42578739946501 | (37.7373233955514, -122.425787399465) | ||||
| 165288 | 165288 | 188407 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1300x De Haro St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6012285.79175 | 2102196.41625 | 37.7529228280459 | -122.400396843734 | (37.7529228280459, -122.400396843734) | ||||
| 165838 | 165838 | 59091 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 3524 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 1 | Permit Number 18392 | 5992426.174880001 | 2110042.4468799997 | 37.77333847202161 | -122.46964566266001 | (37.7733384720216, -122.46964566266) | ||
| 166591 | 166591 | 222687 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Eugenia Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6006597.39234 | 2098081.5973 | 37.741305610657 | -122.419776492811 | (37.741305610657, -122.419776492811) | ||||
| 171476 | 171476 | 188405 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1300x De Haro St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6012256.82794 | 2102204.54617 | 37.752943535820606 | -122.400497577699 | (37.7529435358206, -122.400497577699) | ||||
| 172205 | 172205 | 222688 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Eugenia Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6006604.22222 | 2098080.62198 | 37.741303317398206 | -122.419752808255 | (37.7413033173982, -122.419752808255) | ||||
| 173385 | 173385 | 175810 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 La Grande Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6005231.38021 | 2091782.6619 | 37.7239330883183 | -122.424051850035 | (37.7239330883183, -122.424051850035) | ||||
| 173848 | 173848 | 188410 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1501 22nd St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6013292.91596 | 2103788.2689099996 | 37.7573498217412 | -122.397025598364 | (37.7573498217412, -122.397025598364) | ||||
| 179565 | 179565 | 222694 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 427 Valley St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6003122.71421 | 2099186.4838799997 | 37.7441430185014 | -122.431869572034 | (37.7441430185014, -122.431869572034) | ||||
| 62729 | 62729 | 96749 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 399X Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1.5x2 | 6003700.0 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | |||
| 79996 | 79996 | 96750 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 399X Liberty St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1.5x2 | 6003700.0 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | |||
| 121505 | 121505 | 96747 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 399X Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 1.5x2 | 6003700.0 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | |||
| 145019 | 145019 | 96748 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 399X Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 1.5x2 | 6003700.0 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | |||
| 117432 | 117432 | 107476 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 69 Mirabel Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2014 12:00:00 AM | 3 | 10x6 | Permit Number 773500 | 6007782.9107099995 | 2100032.55813 | 37.746729228385895 | -122.41581549012899 | (37.7467292283859, -122.415815490129) | ||
| 18868 | 18868 | 15071 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1X Minerva St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5995959.8595900005 | 2089005.6685900001 | 37.7157802951115 | -122.45590116312201 | (37.7157802951115, -122.455901163122) | |||
| 440 | 440 | 157410 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 125 Highland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | 2x5 | 6005546.67522 | 2096690.9332 | 37.7374279129674 | -122.423310672857 | (37.7374279129674, -122.423310672857) | ||
| 767 | 767 | 251382 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 731 Huron Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 17436 | 17436 | 29576 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991377.92956 | 2094240.4375599998 | 37.7298896363903 | -122.47211961513099 | (37.7298896363903, -122.472119615131) | ||
| 17688 | 17688 | 29574 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 3X3 | 5991374.696380001 | 2094208.91815 | 37.729802904883 | -122.472128495928 | (37.729802904883, -122.472128495928) | |||
| 81119 | 81119 | 22153 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1570X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 6015582.155925799 | 2098251.0940713002 | 37.742273066345604 | -122.388721900676 | (37.7422730663456, -122.388721900676) | |||
| 109961 | 109961 | 22155 | Private 5 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1570X FAIRFAX AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3X3 | 6015579.0 | 2098247.0 | 37.74226164995721 | -122.388732527256 | (37.7422616499572, -122.388732527256) | |||
| 145814 | 145814 | 106327 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 37 Elsie St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 772574 | 6007569.3 | 2099210.3 | 37.7444594805766 | -122.4164959017 | (37.7444594805766, -122.4164959017) | ||||
| 185 | 185 | 251243 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 299x Chapman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008953.0 | 2098186.0 | 37.7417246968109 | -122.411638974942 | (37.7417246968109, -122.411638974942) | ||||
| 6711 | 6711 | 31341 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 430 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772811 | 6005729.4209 | 2111051.1148 | 37.7768679337671 | -122.423699563703 | (37.7768679337671, -122.423699563703) | |
| 9782 | 9782 | 159354 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 417x Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998501.29354 | 2087549.7908 | 37.7119283225022 | -122.44701212372802 | (37.7119283225022, -122.447012123728) | |
| 10397 | 10397 | 108837 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 699 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774665 | 6001210.74249 | 2089636.42248 | 37.7178121756617 | -122.437796877731 | (37.7178121756617, -122.437796877731) |
| 10903 | 10903 | 110032 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 630 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775191 | 6002420.02658 | 2090107.3938799999 | 37.719174047824104 | -122.433650566035 | (37.7191740478241, -122.433650566035) |
| 11143 | 11143 | 109071 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 35 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772757 | 5999530.156 | 2088703.36466 | 37.715154504538795 | -122.443538910497 | (37.7151545045388, -122.443538910497) |
| 12013 | 12013 | 116582 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 195 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778001 | 6004664.28928 | 2093799.33843 | 37.729438402445105 | -122.426155697039 | (37.7294384024451, -122.426155697039) | |
| 12022 | 12022 | 108898 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 378 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772818 | 6000293.95374 | 2086893.3367700002 | 37.7102281038126 | -122.440769142495 | (37.7102281038126, -122.440769142495) |
| 12119 | 12119 | 102524 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 154 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2013 12:00:00 AM | 16 | 3x3 | Permit Number 770317 | 6011839.9295 | 2088903.3705900002 | 37.7163980403033 | -122.401004803454 | (37.7163980403033, -122.401004803454) | |
| 12216 | 12216 | 108836 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 699 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774665 | 6001204.89947 | 2089626.81587 | 37.717785465811296 | -122.437816386741 | (37.7177854658113, -122.437816386741) |
| 12503 | 12503 | 93870 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400-422X Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773818 | 6012462.01959 | 2086667.4072599998 | 37.7102932120209 | -122.398697717749 | (37.7102932120209, -122.398697717749) |
| 12527 | 12527 | 108378 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 358 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773808 | 6003377.41913 | 2091635.77484 | 37.7234249209965 | -122.43045021882 | (37.7234249209965, -122.43045021882) |
| 12634 | 12634 | 109574 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774875 | 6002013.87176 | 2089826.5009400002 | 37.7183797243364 | -122.435034407708 | (37.7183797243364, -122.435034407708) |
| 13070 | 13070 | 93869 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400-422X Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773818 | 6012466.99875 | 2086683.8296 | 37.7103385819422 | -122.398681660343 | (37.7103385819422, -122.398681660343) |
| 13992 | 13992 | 108725 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 877 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773104 | 6011895.30838 | 2104315.65478 | 37.758720008153 | -122.401896177292 | (37.758720008153, -122.401896177292) |
| 16644 | 16644 | 80780 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 702 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773102 | 6011234.66837 | 2105019.04099 | 37.760614457905795 | -122.404230490851 | (37.7606144579058, -122.404230490851) |
| 40968 | 40968 | 91228 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 250 Texas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53161 | 6013714.91861 | 2105876.83519 | 37.7631080513185 | -122.39571247215 | (37.7631080513185, -122.39571247215) | |
| 45347 | 45347 | 108716 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 201 Randall St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773302 | 6004213.21698 | 2097517.4141599997 | 37.73962189424871 | -122.427979939698 | (37.7396218942487, -122.427979939698) | |
| 79940 | 79940 | 37260 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39806 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |
| 83513 | 83513 | 102091 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 27 Santa Ana Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769734 | 5992609.4 | 2096703.2 | 37.7367229555432 | -122.468041385671 | (37.7367229555432, -122.468041385671) | |
| 83692 | 83692 | 109401 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
| 84993 | 84993 | 117424 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 600x POWHATTAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008524.0 | 2098073.0 | 37.7413903494898 | -122.41311433102699 | (37.7413903494898, -122.413114331027) | |||
| 90437 | 90437 | 109398 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774632 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | |
| 91902 | 91902 | 91227 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 250 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 3x3 | Permit Number 53161 | 6013717.0 | 2105930.0 | 37.763254145992796 | -122.39570899856199 | (37.7632541459928, -122.395708998562) | ||
| 94670 | 94670 | 109400 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
| 96969 | 96969 | 109399 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
| 97134 | 97134 | 122681 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 598x Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008469.0 | 2098078.0 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | ||||
| 97304 | 97304 | 37262 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801X Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39806 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |
| 105253 | 105253 | 109313 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 3261 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 771278 | 6009056.2 | 2099704.9 | 37.745901050724 | -122.411389421874 | (37.745901050724, -122.411389421874) | |
| 107044 | 107044 | 107197 | Significant Tree 6 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 339 Kirkham St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/07/2014 12:00:00 AM | 3x3 | Permit Number 773549 | 5993785.2645 | 2105241.5874099997 | 37.7602350326789 | -122.464595750688 | (37.7602350326789, -122.464595750688) | ||
| 109034 | 109034 | 88642 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 637 Noe St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51602 | 6003051.0 | 2104517.0 | 37.758775291756294 | -122.43249820666401 | (37.7587752917563, -122.432498206664) | |||
| 110009 | 110009 | 108903 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 772783 | 6001785.77868 | 2087307.18495 | 37.7114492867677 | -122.43564268921001 | (37.7114492867677, -122.43564268921) | ||
| 112848 | 112848 | 37261 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39806 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |
| 114122 | 114122 | 102090 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 27 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769734 | 5992609.4 | 2096703.2 | 37.7367229555432 | -122.468041385671 | (37.7367229555432, -122.468041385671) | |
| 116475 | 116475 | 109575 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774875 | 6002004.0 | 2089808.9 | 37.7183308355338 | -122.43506727205299 | (37.7183308355338, -122.435067272053) |
| 118878 | 118878 | 108906 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 214 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772968 | 6009519.2 | 2097295.6 | 37.7393115967784 | -122.40961840488701 | (37.7393115967784, -122.409618404887) |
| 122286 | 122286 | 97347 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1130 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2011 12:00:00 AM | 3x3 | Permit Number 768267 | 5998216.1 | 2106370.5 | 37.7635891788793 | -122.449352986262 | (37.7635891788793, -122.449352986262) | ||
| 125228 | 125228 | 109402 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
| 125714 | 125714 | 102089 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 27 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769734 | 5992609.4 | 2096703.2 | 37.7367229555432 | -122.468041385671 | (37.7367229555432, -122.468041385671) | |
| 127137 | 127137 | 122679 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 598x Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008469.0 | 2098078.0 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | ||||
| 129111 | 129111 | 51597 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1478 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | 3x3 | Permit Number 47890 | 5999641.13876025 | 2107457.97579425 | 37.766656526924294 | -122.444502404738 | (37.7666565269243, -122.444502404738) | ||
| 140417 | 140417 | 108905 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Cordova St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772783 | 6001785.8 | 2087307.2 | 37.7114493293027 | -122.43564261659901 | (37.7114493293027, -122.435642616599) |
| 140864 | 140864 | 53611 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2266 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 50102 | 5991755.89113084 | 2099997.75858136 | 37.7457196459604 | -122.47123227110201 | (37.7457196459604, -122.471232271102) | ||
| 144281 | 144281 | 122680 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 598x Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008469.0 | 2098078.0 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | ||||
| 167905 | 167905 | 94813 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2948 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53896 | 6002515.07841 | 2118365.04564 | 37.7967681547718 | -122.43534223486799 | (37.7967681547718, -122.435342234868) | |
| 184518 | 184518 | 39934 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 186 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41205 | 6010249.35801 | 2088014.8431799999 | 37.7138694695674 | -122.40644005139299 | (37.7138694695674, -122.406440051393) |
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");