Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78401 | 78401 | 49775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
| 92628 | 92628 | 49774 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
| 25052 | 25052 | 196384 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.781945415491705 | -122.396070069587 | (37.7819454154917, -122.396070069587) | |||
| 179071 | 179071 | 67710 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 7 | Permit Number 31321 | 6013724.697430001 | 2112718.68187 | 37.7818947719595 | -122.396158176154 | (37.7818947719595, -122.396158176154) | |
| 83638 | 83638 | 115104 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 98X HEMLOCK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006944.0 | 2114961.0 | 37.787672014079206 | -122.419775454842 | (37.7876720140792, -122.419775454842) | ||||
| 83985 | 83985 | 115105 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 98X HEMLOCK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006944.0 | 2114961.0 | 37.787672014079206 | -122.419775454842 | (37.7876720140792, -122.419775454842) | ||||
| 88654 | 88654 | 115106 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 98X HEMLOCK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006944.0 | 2114961.0 | 37.787672014079206 | -122.419775454842 | (37.7876720140792, -122.419775454842) | ||||
| 146157 | 146157 | 115103 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 98X HEMLOCK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006944.0 | 2114961.0 | 37.787672014079206 | -122.419775454842 | (37.7876720140792, -122.419775454842) | |||
| 98949 | 98949 | 53019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 98@ 9TH AVE Sotelo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | Permit Number 48999 | 5993583.56657104 | 2101415.66580256 | 37.7497184085015 | -122.46501544964501 | (37.7497184085015, -122.465015449645) | |||
| 92890 | 92890 | 35815 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 985 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39053 | 6006347.1524299 | 2103860.86986085 | 37.7571600746524 | -122.42105198546999 | (37.7571600746524, -122.42105198547) | ||
| 1998 | 1998 | 135937 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 98 Spruce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780098 | 5997052.02369 | 2116054.59656 | 37.7901125223289 | -122.45407860247299 | (37.7901125223289, -122.454078602473) | |
| 94705 | 94705 | 39015 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 979 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1998 12:00:00 AM | Permit Number 40771 | 6009183.08861003 | 2103470.3574564 | 37.756247272923005 | -122.41121660125201 | (37.756247272923, -122.411216601252) | |||
| 112396 | 112396 | 39014 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 979 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40771 | 6009183.08861003 | 2103470.3574564 | 37.756247272923005 | -122.41121660125201 | (37.756247272923, -122.411216601252) | ||
| 138811 | 138811 | 43293 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 975 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43062 | 6012196.286885 | 2103939.61174077 | 37.7577042695859 | -122.40082883013599 | (37.7577042695859, -122.400828830136) | ||
| 25957 | 25957 | 247414 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 971 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001933.8006 | 2109433.5045 | 37.772211390909 | -122.436713922993 | (37.772211390909, -122.436713922993) | |||
| 100714 | 100714 | 39013 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 971 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40770 | 6009180.63440732 | 2103515.04739672 | 37.756369843777 | -122.411228245551 | (37.756369843777, -122.411228245551) | ||
| 77549 | 77549 | 36014 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 97 Winfield St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1998 12:00:00 AM | Permit Number 39160 | 6007176.510261099 | 2098875.10334415 | 37.743517008192796 | -122.41783033575001 | (37.7435170081928, -122.41783033575) | |||
| 87744 | 87744 | 36013 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 97 Winfield St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1998 12:00:00 AM | Permit Number 39160 | 6007176.510261099 | 2098875.10334415 | 37.743517008192796 | -122.41783033575001 | (37.7435170081928, -122.41783033575) | |||
| 111143 | 111143 | 36012 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 97 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39160 | 6007176.510261099 | 2098875.10334415 | 37.743517008192796 | -122.41783033575001 | (37.7435170081928, -122.41783033575) | ||
| 80082 | 80082 | 36180 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 97 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | Permit Number 39250 | 5996187.56440634 | 2113855.50691306 | 37.7840248062044 | -122.45691042062201 | (37.7840248062044, -122.456910420622) | ||
| 139167 | 139167 | 36181 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 97 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1998 12:00:00 AM | Permit Number 39250 | 5996187.56440634 | 2113855.50691306 | 37.7840248062044 | -122.45691042062201 | (37.7840248062044, -122.456910420622) | |||
| 95548 | 95548 | 53021 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 96@ 9TH AVE Sotelo Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | Permit Number 49000 | 5993602.62440104 | 2101416.64083644 | 37.7497221845739 | -122.464949618251 | (37.7497221845739, -122.464949618251) | |||
| 117634 | 117634 | 53020 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 96@ 9TH AVE Sotelo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | Permit Number 49000 | 5993602.62440104 | 2101416.64083644 | 37.7497221845739 | -122.464949618251 | (37.7497221845739, -122.464949618251) | |||
| 126294 | 126294 | 43292 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 969 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43061 | 6012193.84203757 | 2103983.88594083 | 37.75782570042529 | -122.400840395966 | (37.7578257004253, -122.400840395966) | ||
| 101093 | 101093 | 37293 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 967 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39822 | 6004413.58249794 | 2103268.10380845 | 37.755423291318294 | -122.427696784995 | (37.7554232913183, -122.427696784995) | ||
| 142374 | 142374 | 42073 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 96 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42385 | 6007952.35654735 | 2099942.95840002 | 37.746492731947995 | -122.415223220037 | (37.746492731948, -122.415223220037) | ||
| 12328 | 12328 | 26789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 96 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2010 12:00:00 AM | 3 | 3X3 | 6010520.1642 | 2087302.5632 | 37.7119288389604 | -122.40545390649599 | (37.7119288389604, -122.405453906496) | ||
| 10200 | 10200 | 122374 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |||
| 112336 | 112336 | 24168 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 95X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2008 12:00:00 AM | 3 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 116748 | 116748 | 91939 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 947 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 3 | 3x3 | 5992870.0 | 2106592.0 | 37.7638901044666 | -122.467859413197 | (37.7638901044666, -122.467859413197) | ||
| 177998 | 177998 | 63548 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 942 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | 10 | Permit Number 24164 | 5999530.709 | 2111776.0946 | 37.7785066833069 | -122.445194846179 | (37.7785066833069, -122.445194846179) | |
| 178906 | 178906 | 140033 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 940 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001977.6939 | 2111756.5532 | 37.7785923959714 | -122.43672841202 | (37.7785923959714, -122.43672841202) | |||
| 123527 | 123527 | 66315 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 94 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29430 | 6001458.61740114 | 2094962.10093841 | 37.7324493716412 | -122.43732121741002 | (37.7324493716412, -122.43732121741) | ||
| 80278 | 80278 | 42211 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 937 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42479 | 6011834.2594701 | 2111457.32291808 | 37.7783260063796 | -122.40260952625201 | (37.7783260063796, -122.402609526252) | ||
| 125151 | 125151 | 42210 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 937 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42479 | 6011834.2594701 | 2111457.32291808 | 37.7783260063796 | -122.40260952625201 | (37.7783260063796, -122.402609526252) | ||
| 93255 | 93255 | 66254 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 930 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29355 | 5995057.552477599 | 2090124.39622258 | 37.7188002278135 | -122.45910089062099 | (37.7188002278135, -122.459100890621) | ||
| 32988 | 32988 | 196389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013924.26567 | 2112893.70041 | 37.7823864349182 | -122.395480022606 | (37.7823864349182, -122.395480022606) | |||
| 54846 | 54846 | 196390 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013936.7797 | 2112901.90047 | 37.7824096464379 | -122.39543730389799 | (37.7824096464379, -122.395437303898) | |||
| 57720 | 57720 | 196392 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013963.537140001 | 2112927.48749 | 37.7824813907387 | -122.39534652723499 | (37.7824813907387, -122.395346527235) | |||
| 159092 | 159092 | 196393 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013990.372330001 | 2112956.91555 | 37.7825636859099 | -122.395255750564 | (37.7825636859099, -122.395255750564) | |||
| 177156 | 177156 | 196391 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013949.37152 | 2112913.94153 | 37.7824434087757 | -122.395394585209 | (37.7824434087757, -122.395394585209) | |||
| 178433 | 178433 | 137654 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 915 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999488.4062 | 2111737.8529 | 37.77839926671621 | -122.44533843675801 | (37.7783992667162, -122.445338436758) | |||
| 77370 | 77370 | 37268 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 99511 | 99511 | 37265 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 121592 | 121592 | 37267 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 126836 | 126836 | 37264 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 145379 | 145379 | 37266 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 93452 | 93452 | 46779 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 91 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44870 | 6001525.5890631 | 2092130.31455081 | 37.724677740092 | -122.43688703011601 | (37.724677740092, -122.436887030116) | ||
| 80019 | 80019 | 69528 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 91 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 3 | Permit Number 37970 | 5995596.79094541 | 2093236.22494982 | 37.7273755525392 | -122.457461985557 | (37.7273755525392, -122.457461985557) | |
| 136756 | 136756 | 63604 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 900 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1987 12:00:00 AM | 3 | Permit Number 24240 | 5999553.7216 | 2111620.759 | 37.778081485139296 | -122.445104066804 | (37.7780814851393, -122.445104066804) | |
| 79351 | 79351 | 50276 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 90 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46979 | 6004285.87067198 | 2095713.64445309 | 37.734673261546504 | -122.42760025785401 | (37.7346732615465, -122.427600257854) | ||
| 37372 | 37372 | 101729 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 90 Rotteck St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6003352.201090001 | 2094564.6464200001 | 37.731465517513 | -122.43074630169501 | (37.731465517513, -122.430746301695) | |||
| 58712 | 58712 | 46802 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 90 Ravenwood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44890 | 5994259.763524599 | 2095973.46470501 | 37.7348144532504 | -122.46228249422701 | (37.7348144532504, -122.462282494227) | ||
| 53793 | 53793 | 33345 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 90 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37482 | 6001488.85408541 | 2094961.63013744 | 37.7324497978026 | -122.437216648553 | (37.7324497978026, -122.437216648553) | ||
| 86060 | 86060 | 102208 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89X Elgin Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.42309702584299 | (37.7700345996314, -122.423097025843) | |
| 104136 | 104136 | 102207 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89X Elgin Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.42309702584299 | (37.7700345996314, -122.423097025843) | |
| 125650 | 125650 | 102209 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89X Elgin Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.42309702584299 | (37.7700345996314, -122.423097025843) | |
| 58060 | 58060 | 46783 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54062 | 6002335.14709 | 2093516.37756 | 37.7285295350115 | -122.43418753503 | (37.7285295350115, -122.43418753503) |
| 94593 | 94593 | 41878 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89 Belcher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42255 | 6003837.78738221 | 2107818.63847884 | 37.7678853828634 | -122.43001265375099 | (37.7678853828634, -122.430012653751) | ||
| 105101 | 105101 | 41879 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42255 | 6003837.78738221 | 2107818.63847884 | 37.7678853828634 | -122.43001265375099 | (37.7678853828634, -122.430012653751) | ||
| 88392 | 88392 | 40947 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88209 Hoff St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.76357769940321 | -122.42054143219102 | (37.7635776994032, -122.420541432191) | |||
| 140103 | 140103 | 40946 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88209 Hoff St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.76357769940321 | -122.42054143219102 | (37.7635776994032, -122.420541432191) | |||
| 140510 | 140510 | 40945 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88209 Hoff St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.76357769940321 | -122.42054143219102 | (37.7635776994032, -122.420541432191) | |||
| 141926 | 141926 | 40944 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88209 Hoff St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.76357769940321 | -122.42054143219102 | (37.7635776994032, -122.420541432191) | |||
| 44205 | 44205 | 178924 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 88 San Gabriel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6000939.255030001 | 2093544.2007900001 | 37.7285266059143 | -122.43901519111 | (37.7285266059143, -122.43901519111) | |||
| 72044 | 72044 | 178922 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 88 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6000972.29348 | 2093568.3517900002 | 37.7285947987994 | -122.438902705697 | (37.7285947987994, -122.438902705697) | |||
| 146623 | 146623 | 178923 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 88 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6000952.168380001 | 2093553.63725 | 37.7285532510089 | -122.43897122505899 | (37.7285532510089, -122.438971225059) | |||
| 10788 | 10788 | 94995 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010547.3472 | 2087288.7489 | 37.711892427555796 | -122.40535898167299 | (37.7118924275558, -122.405358981673) | |||
| 145842 | 145842 | 40948 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88 Hoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.76357769940321 | -122.42054143219102 | (37.7635776994032, -122.420541432191) | ||
| 57598 | 57598 | 43283 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 872 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 6 | Permit Number 43052 | 6010937.3393 | 2090651.3857900002 | 37.72114734204379 | -122.404247572584 | (37.7211473420438, -122.404247572584) | |
| 141662 | 141662 | 37336 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 870 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39842 | 6003078.2296816 | 2103153.69226969 | 37.7550335181566 | -122.432306667878 | (37.7550335181566, -122.432306667878) | ||
| 46066 | 46066 | 67709 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 87 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1992 12:00:00 AM | 10 | Permit Number 31320 | 6013781.91426 | 2112762.09602 | 37.7820171606904 | -122.395963274202 | (37.7820171606904, -122.395963274202) | ||
| 55073 | 55073 | 214457 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001468.0488 | 2094911.62577 | 37.732311314613106 | -122.43728499800699 | (37.7323113146131, -122.437284998007) | |||
| 77100 | 77100 | 214458 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001469.66795 | 2094911.1287900002 | 37.73231004206529 | -122.437279364672 | (37.7323100420653, -122.437279364672) | |||
| 129720 | 129720 | 214459 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001485.72244 | 2094910.79641 | 37.7323100420719 | -122.437223836928 | (37.7323100420719, -122.437223836928) | |||
| 147356 | 147356 | 214460 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001504.80171 | 2094910.40142 | 37.732310042080606 | -122.437157847364 | (37.7323100420806, -122.437157847364) | |||
| 166910 | 166910 | 214456 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001455.73616 | 2094912.80793 | 37.7323138605989 | -122.437327650168 | (37.7323138605989, -122.437327650168) | |||
| 82704 | 82704 | 47650 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 867 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2002 12:00:00 AM | Permit Number 45454 | 5999132.82266547 | 2107294.05273346 | 37.7661774182509 | -122.446248782885 | (37.7661774182509, -122.446248782885) | |||
| 92024 | 92024 | 83313 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 866 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50442 | 6000836.29031453 | 2102027.17212269 | 37.7518129898376 | -122.43997914777201 | (37.7518129898376, -122.439979147772) | ||
| 107343 | 107343 | 67347 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 861 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | Permit Number 30833 | 6010207.94819742 | 2104213.03336313 | 37.7583439181607 | -122.40772463332199 | (37.7583439181607, -122.407724633322) | ||
| 173041 | 173041 | 238003 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 860 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000870.32995 | 2102023.8969900003 | 37.7518059348134 | -122.439861199541 | (37.7518059348134, -122.439861199541) | |||
| 160226 | 160226 | 178928 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 86 Santa Ysabel Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6000750.4572 | 2093270.2717099998 | 37.7277637154981 | -122.439648243684 | (37.7277637154981, -122.439648243684) | ||||
| 79215 | 79215 | 36343 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 86 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39306 | 5995650.14468705 | 2093191.07979615 | 37.7272546592748 | -122.457274278341 | (37.7272546592748, -122.457274278341) | ||
| 128830 | 128830 | 36344 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 86 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39306 | 5995650.14468705 | 2093191.07979615 | 37.7272546592748 | -122.457274278341 | (37.7272546592748, -122.457274278341) | ||
| 86472 | 86472 | 66166 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 86 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29238 | 6009305.34783638 | 2096949.04599103 | 37.7383480489457 | -122.410333350825 | (37.7383480489457, -122.410333350825) | ||
| 41433 | 41433 | 139465 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 855 CENTRAL AVE | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 5999527.6632 | 2111481.3292 | 37.77769715931579 | -122.445184184965 | (37.7776971593158, -122.445184184965) | |||
| 24086 | 24086 | 178876 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | |||
| 120557 | 120557 | 63018 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 85 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1986 12:00:00 AM | Permit Number 23433 | 6007418.03178322 | 2097829.30038567 | 37.7406590550211 | -122.416921131955 | (37.7406590550211, -122.416921131955) | ||
| 90935 | 90935 | 88734 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 85 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51669 | 6002352.0 | 2108735.0 | 37.7703172279103 | -122.435217366486 | (37.7703172279103, -122.435217366486) | ||
| 80198 | 80198 | 84962 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 85 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51457 | 5998153.0 | 2107172.0 | 37.765786285611206 | -122.44962898742901 | (37.7657862856112, -122.449628987429) | ||
| 143909 | 143909 | 66173 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 85 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29245 | 6009358.22716882 | 2096956.12808697 | 37.738370458956794 | -122.410151019097 | (37.7383704589568, -122.410151019097) | ||
| 95670 | 95670 | 68086 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 848 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31825 | 6001069.78392059 | 2092016.09827478 | 37.7243382114504 | -122.43845450853998 | (37.7243382114504, -122.43845450854) | ||
| 97599 | 97599 | 49648 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 846 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | 3x3 | Permit Number 46502 | 5994903.90764558 | 2093692.37161772 | 37.728588197445205 | -122.459890295145 | (37.7285881974452, -122.459890295145) | |
| 126541 | 126541 | 84824 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 845 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | Permit No. 49256 | 5996978.8 | 2090483.4 | 37.7198962296133 | -122.45248583240802 | (37.7198962296133, -122.452485832408) | |||
| 141101 | 141101 | 84825 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 845 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | Permit No. 49256 | 5996978.8 | 2090483.4 | 37.7198962296133 | -122.45248583240802 | (37.7198962296133, -122.452485832408) | |||
| 85021 | 85021 | 33758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 842 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | Permit Number 37811 | 5981102.7142707 | 2109980.14676383 | 37.77250644827279 | -122.508809756644 | (37.7725064482728, -122.508809756644) | |||
| 140611 | 140611 | 62494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 84 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22666 | 6000764.49636206 | 2092702.9660143002 | 37.7262068231921 | -122.439559058681 | (37.7262068231921, -122.439559058681) | ||
| 118173 | 118173 | 247294 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 836 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002133.2487 | 2109156.7194 | 37.771462740402995 | -122.436004206745 | (37.771462740403, -122.436004206745) | |||
| 161389 | 161389 | 137633 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 835 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000438.3562 | 2111851.2242 | 37.778764736130796 | -122.442060353321 | (37.7787647361308, -122.442060353321) | |||
| 10403 | 10403 | 95015 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 83 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010521.9467 | 2087254.8816 | 37.711798014587295 | -122.40544438972 | (37.7117980145873, -122.40544438972) |
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");