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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77695 | 77695 | 42820 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 77758 | 77758 | 42824 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 6 | 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) | ||
| 78919 | 78919 | 42827 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 1 | 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) | ||
| 82453 | 82453 | 42828 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 4 | 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) | ||
| 102378 | 102378 | 42822 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 8 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||||
| 90034 | 90034 | 42692 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2500 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506045995 | 2119774.0082852 | 37.8008732765742 | -122.42098036158701 | (37.8008732765742, -122.420980361587) | |||
| 119936 | 119936 | 42691 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2500 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506045995 | 2119774.0082852 | 37.8008732765742 | -122.42098036158701 | (37.8008732765742, -122.420980361587) | |||
| 52153 | 52153 | 125934 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1715 Taylor St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6008711.31794 | 2118818.3670900003 | 37.7983627993626 | -122.41393383309799 | (37.7983627993626, -122.413933833098) | |||
| 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) | |
| 82156 | 82156 | 36956 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 16 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39587 | 5994274.56771258 | 2115474.49567321 | 37.7883600733979 | -122.463646184404 | (37.7883600733979, -122.463646184404) | ||
| 91092 | 91092 | 51953 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 82 Mary St | 2 | 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) | |||
| 101349 | 101349 | 51952 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 82 Mary St | 1 | 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) | |||
| 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) | |||
| 130324 | 130324 | 123045 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 568 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991929.81513 | 2111594.03006 | 37.777569997766705 | -122.47147570428301 | (37.7775699977667, -122.471475704283) | |||
| 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) | |
| 176434 | 176434 | 124049 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 651 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5992517.64773 | 2111006.08275 | 37.775989642541795 | -122.469399404795 | (37.7759896425418, -122.469399404795) | |||
| 38985 | 38985 | 123068 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 678 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992266.69336 | 2110864.34538 | 37.7755859643914 | -122.47025718989201 | (37.7755859643914, -122.470257189892) | |||
| 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) | ||
| 105228 | 105228 | 57041 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 1 | Permit Number 31232 | 5999893.57375842 | 2109179.37340811 | 37.7713974526383 | -122.443752960181 | (37.7713974526383, -122.443752960181) | ||
| 81984 | 81984 | 14597 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1245 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2008 12:00:00 AM | 3 | 5999399.25196 | 2108537.97287 | 37.769608122005 | -122.445416710249 | (37.769608122005, -122.445416710249) | |||
| 133308 | 133308 | 222682 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2 Trainor St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008292.2753800005 | 2108046.95875 | 37.768763565716704 | -122.41462120290501 | (37.7687635657167, -122.414621202905) | |||
| 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) | ||||
| 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) | |
| 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) | ||||
| 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) | ||||
| 110619 | 110619 | 108023 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 721 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773960 | 5998996.170080001 | 2108175.50509 | 37.7685898587188 | -122.446784866101 | (37.7685898587188, -122.446784866101) | ||
| 81823 | 81823 | 36071 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1504 Bryant St | 3 | 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) | ||
| 94464 | 94464 | 36069 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1504 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44775 | 6009387.99483758 | 2107777.56202059 | 37.7680853638298 | -122.410812146882 | (37.7680853638298, -122.410812146882) | ||
| 96552 | 96552 | 36068 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1504 Bryant St | 5 | 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) | ||
| 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) | ||
| 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) | ||
| 3095 | 3095 | 204715 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 327 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3 | Width 6ft | Permit Number 51243 | 5996623.78142 | 2106956.86791 | 37.7651079834665 | -122.454902653043 | (37.7651079834665, -122.454902653043) | |
| 53767 | 53767 | 222709 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 290 States St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6000333.10816 | 2106866.5537099997 | 37.7650720879349 | -122.44206655213699 | (37.7650720879349, -122.442066552137) | |||
| 72437 | 72437 | 222707 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 290 States St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 6000349.79562 | 2106864.73806 | 37.7650680535768 | -122.44200870415101 | (37.7650680535768, -122.442008704151) | |||
| 155781 | 155781 | 222708 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 290 States St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6000342.850880001 | 2106861.9429200003 | 37.76505998306129 | -122.442032523579 | (37.7650599830613, -122.442032523579) | |||
| 82422 | 82422 | 113192 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 150X Museum Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 09/11/2015 12:00:00 AM | Permit Number 774288 | 6001029.7 | 2106463.5 | 37.7640050744287 | -122.439628320832 | (37.7640050744287, -122.439628320832) | |||
| 116006 | 116006 | 106924 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 196 States St | 2 | 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 48133 | 48133 | 60575 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 250 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1982 12:00:00 AM | 3 | Permit Number 20188 | 6013715.09373 | 2105885.47906 | 37.763131795228794 | -122.395712472146 | (37.7631317952288, -122.395712472146) | ||
| 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) | |
| 136139 | 136139 | 222692 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 501 York St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6009835.7153900005 | 2105907.76012 | 37.7629764094606 | -122.409131567579 | (37.7629764094606, -122.409131567579) | |||
| 148509 | 148509 | 188398 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 501 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6010694.68122 | 2105889.4054 | 37.7629740945886 | -122.406159391868 | (37.7629740945886, -122.406159391868) | |||
| 147518 | 147518 | 188397 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 501 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6010696.0277 | 2105850.49204 | 37.7628673226003 | -122.406151993137 | (37.7628673226003, -122.406151993137) | |||
| 118481 | 118481 | 52690 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1401@ RIVOLI Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2011 12:00:00 AM | Permit Number 768319 | 5997782.141834901 | 2105912.5855129 | 37.76230702883 | -122.45082088432301 | (37.76230702883, -122.450820884323) | |||
| 77059 | 77059 | 188411 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 398 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014024.24871 | 2105357.36092 | 37.7616988910081 | -122.394606216998 | (37.7616988910081, -122.394606216998) | |||
| 62795 | 62795 | 188412 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 398 Mississippi St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014026.1658 | 2105339.44297 | 37.761649798808996 | -122.394598331744 | (37.761649798809, -122.394598331744) | |||
| 5046 | 5046 | 150652 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 647 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 6011556.07446 | 2105379.04628 | 37.7616209062969 | -122.403144210544 | (37.7616209062969, -122.403144210544) | |||
| 54760 | 54760 | 188413 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 398 Mississippi St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014027.478680001 | 2105319.8341099997 | 37.7615960301482 | -122.394592417822 | (37.7615960301482, -122.394592417822) | |||
| 71501 | 71501 | 188399 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010997.55787 | 2105333.97174 | 37.7614659351153 | -122.40507272844499 | (37.7614659351153, -122.405072728445) | |||
| 36636 | 36636 | 188403 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 700 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6012073.44818 | 2105095.84941 | 37.7608721901295 | -122.401334912194 | (37.7608721901295, -122.401334912194) | ||||
| 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) |
| 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) | |
| 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) | |
| 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) | |
| 171726 | 171726 | 204714 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1484 16th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5991182.79274 | 2105342.1880099997 | 37.7603608823676 | -122.473603723127 | (37.7603608823676, -122.473603723127) | |||
| 183898 | 183898 | 188402 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 654 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012373.88939 | 2104883.09648 | 37.7603047754705 | -122.40028086897 | (37.7603047754705, -122.40028086897) | |||
| 52605 | 52605 | 204713 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1484 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5991184.777919999 | 2105315.94504 | 37.7602889411076 | -122.473594943052 | (37.7602889411076, -122.473594943052) | |||
| 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) | ||
| 18455 | 18455 | 51904 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 168 Caselli Ave | 3 | 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) | |||
| 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) | ||
| 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) | |||
| 167143 | 167143 | 188401 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 909 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015267.441000001 | 2104396.98208 | 37.7591309344718 | -122.39023938074101 | (37.7591309344718, -122.390239380741) | |||
| 18891 | 18891 | 107407 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 171 TWIN PEAKS BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5998631.4 | 2104681.4 | 37.7589750798494 | -122.44779499190099 | (37.7589750798494, -122.447794991901) | ||||
| 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) | |||
| 47522 | 47522 | 188400 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1045 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6015554.8451 | 2104260.21833 | 37.7587713477501 | -122.389235841663 | (37.7587713477501, -122.389235841663) | |||
| 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) | ||
| 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) |
| 78290 | 78290 | 37278 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 700 Sanchez St | 2 | 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) | |||
| 85068 | 85068 | 37279 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 700 Sanchez St | 1 | 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) | |||
| 109099 | 109099 | 37281 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 700 Sanchez St | 5 | 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) | |||
| 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) | |||
| 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) | |||
| 83450 | 83450 | 68449 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 4054 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 04/24/1999 12:00:00 AM | Permit Number 32307 | 6003251.17179249 | 2104206.64930012 | 37.757934492021604 | -122.431783761852 | (37.7579344920216, -122.431783761852) | ||
| 44937 | 44937 | 222679 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 749 Dolores St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6005046.9751 | 2104064.76222 | 37.7576465368663 | -122.425563014118 | (37.7576465368663, -122.425563014118) | |||
| 69867 | 69867 | 222678 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 749 Dolores St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6005045.75661 | 2104048.66592 | 37.7576022713581 | -122.425566082603 | (37.7576022713581, -122.425566082603) | |||
| 89470 | 89470 | 50387 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 296 Liberty St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 107669 | 107669 | 50389 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 296 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 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) | ||||
| 114980 | 114980 | 37338 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 740 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44638 | 6003659.25274291 | 2103921.20422444 | 37.757173851767604 | -122.430352080919 | (37.7571738517676, -122.430352080919) | ||
| 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) | |||
| 63986 | 63986 | 188409 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2033 22nd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6011983.90541 | 2103708.46876 | 37.757057753421 | -122.40154709194799 | (37.757057753421, -122.401547091948) | |||
| 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) | |
| 24848 | 24848 | 188408 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2033 22nd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6011976.80987 | 2103707.86259 | 37.7570556930855 | -122.40157158857299 | (37.7570556930855, -122.401571588573) | |||
| 56499 | 56499 | 222681 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2318 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6011232.98207 | 2103716.09635 | 37.7570367677534 | -122.404144621787 | (37.7570367677534, -122.404144621787) | ||||
| 24677 | 24677 | 111241 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 745X SANCHEZ ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
| 115789 | 115789 | 37339 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 790 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39845 | 6003692.20622256 | 2103684.04749104 | 37.7565245422275 | -122.43022119623501 | (37.7565245422275, -122.430221196235) | ||
| 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) | ||||
| 88809 | 88809 | 37303 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 7 | 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) |
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");