Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92691 | 92691 | 52391 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 99103 | 99103 | 52390 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 119408 | 119408 | 52392 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 145547 | 145547 | 52389 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 88514 | 88514 | 28851 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 90239 | 90239 | 28855 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 105963 | 105963 | 28850 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 123223 | 123223 | 28852 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 139447 | 139447 | 28854 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 141442 | 141442 | 28853 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 96428 | 96428 | 117621 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999X BRAZIL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6004288.0 | 2090756.0 | 37.7210607924735 | -122.42723986886601 | (37.7210607924735, -122.427239868866) | |||
| 105246 | 105246 | 117625 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999X BRAZIL AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6004288.0 | 2090756.0 | 37.7210607924735 | -122.42723986886601 | (37.7210607924735, -122.427239868866) | |||
| 116417 | 116417 | 117623 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999X BRAZIL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6004288.0 | 2090756.0 | 37.7210607924735 | -122.42723986886601 | (37.7210607924735, -122.427239868866) | |||
| 164625 | 164625 | 235855 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008625.313519999 | 2102772.01425 | 37.7542984832041 | -122.41309620812001 | (37.7542984832041, -122.41309620812) | |||
| 93261 | 93261 | 67116 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 994 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30535 | 5998844.26522705 | 2106564.92896199 | 37.7641589439786 | -122.447194363227 | (37.7641589439786, -122.447194363227) | ||
| 147971 | 147971 | 236445 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 994 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998851.72609 | 2106478.89575 | 37.763923144673704 | -122.447162366272 | (37.7639231446737, -122.447162366272) | |||
| 155001 | 155001 | 65968 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 990 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 4 | Permit Number 28992 | 6007125.46509 | 2120550.16631 | 37.8030286907859 | -122.419544310327 | (37.8030286907859, -122.419544310327) | ||
| 130993 | 130993 | 236272 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007737.48047 | 2107411.94537 | 37.76698878242561 | -122.416495215585 | (37.7669887824256, -122.416495215585) | |||
| 171691 | 171691 | 236271 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007736.0102 | 2107427.5754299997 | 37.7670316162303 | -122.416501408308 | (37.7670316162303, -122.416501408308) | |||
| 180662 | 180662 | 235668 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Elgin Park | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005845.909440001 | 2108547.05251 | 37.7699989572271 | -122.423118563291 | (37.7699989572271, -122.423118563291) | |||
| 30587 | 30587 | 178835 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001544.783340001 | 2086699.50707 | 37.709767045691294 | -122.436432165527 | (37.7097670456913, -122.436432165527) | |||
| 53625 | 53625 | 178836 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001534.9682599995 | 2086713.04585 | 37.7098036624786 | -122.436467056534 | (37.7098036624786, -122.436467056534) | |||
| 167416 | 167416 | 178834 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6001553.31629 | 2086683.73815 | 37.7097242325659 | -122.43640154631201 | (37.7097242325659, -122.436401546312) | |||
| 176572 | 176572 | 178833 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 6ft | 6001567.75342 | 2086664.56423 | 37.709672405530796 | -122.43635027774401 | (37.7096724055308, -122.436350277744) | |||
| 40596 | 40596 | 69408 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33513 | 6001538.598040001 | 2086768.9797900002 | 37.7099574510375 | -122.43645851206301 | (37.7099574510375, -122.436458512063) | |
| 60318 | 60318 | 178838 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001561.306469999 | 2086771.17725 | 37.7099647751299 | -122.436380184711 | (37.7099647751299, -122.436380184711) | |||
| 99158 | 99158 | 178837 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001551.41306 | 2086770.9715900002 | 37.7099636482706 | -122.43641436345301 | (37.7099636482706, -122.436414363453) | |||
| 108284 | 108284 | 86728 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 980 Huron Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49704 | 5996769.2 | 2086717.1 | 37.7095428329763 | -122.452938628006 | (37.7095428329763, -122.452938628006) | ||||
| 134446 | 134446 | 178705 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 980 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996782.39454 | 2086708.5296099999 | 37.7095200567877 | -122.452892407466 | (37.7095200567877, -122.452892407466) | |||
| 57298 | 57298 | 235757 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005370.52103 | 2099351.03927 | 37.7447220191116 | -122.424108842766 | (37.7447220191116, -122.424108842766) | |||
| 82584 | 82584 | 35849 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Russia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | Permit Number 39073 | 6001624.34206398 | 2090846.82261337 | 37.7211591730388 | -122.43645383368401 | (37.7211591730388, -122.436453833684) | ||
| 97773 | 97773 | 35848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Russia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | Permit Number 39073 | 6001624.34206398 | 2090846.82261337 | 37.7211591730388 | -122.43645383368401 | (37.7211591730388, -122.436453833684) | ||
| 109478 | 109478 | 35846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | Permit Number 39073 | 6001624.34206398 | 2090846.82261337 | 37.7211591730388 | -122.43645383368401 | (37.7211591730388, -122.436453833684) | ||
| 141697 | 141697 | 35847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | Permit Number 39073 | 6001624.34206398 | 2090846.82261337 | 37.7211591730388 | -122.43645383368401 | (37.7211591730388, -122.436453833684) | ||
| 133685 | 133685 | 202276 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012835.94642 | 2093268.61779 | 37.7284396378725 | -122.39786808953998 | (37.7284396378725, -122.39786808954) | |||
| 69810 | 69810 | 65716 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 7 | 3x3 | Permit Number 28648 | 6000919.98791 | 2088014.07766 | 37.7133410423274 | -122.438685700186 | (37.7133410423274, -122.438685700186) |
| 74923 | 74923 | 196096 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013385.07965 | 2106714.42564 | 37.765389536021296 | -122.39691200949301 | (37.7653895360213, -122.396912009493) | |||
| 146941 | 146941 | 196095 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013384.4505199995 | 2106734.28469 | 37.7654440295562 | -122.396915577987 | (37.7654440295562, -122.396915577987) | |||
| 154637 | 154637 | 196097 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 Missouri St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6013386.06824 | 2106698.22763 | 37.7653451148996 | -122.396907454408 | (37.7653451148996, -122.396907454408) | |||
| 174295 | 174295 | 235689 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 Laussat St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004329.17404 | 2109279.26981 | 37.7719237393213 | -122.428417123276 | (37.7719237393213, -122.428417123276) | |||
| 167017 | 167017 | 36182 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 6 | Permit Number 39251 | 5996240.3184 | 2113866.2722 | 37.7840573939643 | -122.456728690929 | (37.7840573939643, -122.456728690929) | |
| 44976 | 44976 | 140824 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 JORDAN AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5996239.98 | 2113878.2862 | 37.784090361774794 | -122.456730730831 | (37.7840903617748, -122.456730730831) | |||
| 63964 | 63964 | 120750 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5989612.2372 | 2114815.30171 | 37.786280363394106 | -122.479728658845 | (37.7862803633941, -122.479728658845) | |||
| 176754 | 176754 | 214245 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 979 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998327.57206 | 2095673.17508 | 37.734223319136206 | -122.44819711722602 | (37.7342233191362, -122.448197117226) | |||
| 146915 | 146915 | 52370 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 975 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | Permit Number 48502 | 6007928.79422 | 2115121.18963 | 37.788167283347796 | -122.416379598764 | (37.7881672833478, -122.416379598764) | |
| 18523 | 18523 | 18424 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 974 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6010455.61637 | 2103584.4912099997 | 37.7566319433297 | -122.40682378579099 | (37.7566319433297, -122.406823785791) | |||
| 38478 | 38478 | 235880 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 973 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009975.15854 | 2103577.7395200003 | 37.7565865095655 | -122.40848491366002 | (37.7565865095655, -122.40848491366) | |||
| 143475 | 143475 | 64218 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 973 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1991 12:00:00 AM | Permit Number 29862 | 6009984.06437644 | 2103548.27292234 | 37.7565060996365 | -122.40845203550501 | (37.7565060996365, -122.408452035505) | ||
| 43287 | 43287 | 196091 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 972 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 6015230.48964 | 2104060.4129 | 37.7582047379774 | -122.390343661653 | (37.7582047379774, -122.390343661653) | |||
| 154710 | 154710 | 57075 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 972 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 10 | Permit Number 14342 | 6015229.87754 | 2104071.31623 | 37.758234642233894 | -122.39034654036999 | (37.7582346422339, -122.39034654037) | ||
| 68679 | 68679 | 237537 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 971 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003805.55781 | 2102629.4172400003 | 37.753635196310704 | -122.42975396728701 | (37.7536351963107, -122.429753967287) | |||
| 84901 | 84901 | 39510 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 971 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40962 | 6003803.3913976 | 2102619.59957595 | 37.7536081166409 | -122.42976075902399 | (37.7536081166409, -122.429760759024) | ||
| 112674 | 112674 | 60274 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 970 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1982 12:00:00 AM | Permit Number 19833 | 6009388.90936805 | 2103526.56251655 | 37.7564131401851 | -122.410508768258 | (37.7564131401851, -122.410508768258) | ||
| 113340 | 113340 | 64937 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 97 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1989 12:00:00 AM | Permit Number 25966 | 6005298.81557078 | 2099297.45080235 | 37.744570828578 | -122.42435297588001 | (37.744570828578, -122.42435297588) | ||
| 169461 | 169461 | 236963 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 97 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006740.09715 | 2099118.2256099996 | 37.7441599977031 | -122.41935659035101 | (37.7441599977031, -122.419356590351) | |||
| 182430 | 182430 | 237511 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 968 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003748.946140001 | 2102626.67476 | 37.75362446022 | -122.429949547331 | (37.75362446022, -122.429949547331) | |||
| 30494 | 30494 | 237489 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 964 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003109.64836 | 2102597.1760400003 | 37.7535072380858 | -122.432158272381 | (37.7535072380858, -122.432158272381) | |||
| 49129 | 49129 | 35866 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 963 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 5 | Permit Number 39078 | 6002010.96914 | 2088348.68943 | 37.714321816885096 | -122.43493881070499 | (37.7143218168851, -122.434938810705) | |
| 49728 | 49728 | 35867 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 963 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 5 | Permit Number 39078 | 6002026.003769999 | 2088372.6219 | 37.7143883838026 | -122.434888555678 | (37.7143883838026, -122.434888555678) | |
| 176927 | 176927 | 40009 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 963 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 5 | Permit Number 41262 | 6018899.57505 | 2094657.4041900001 | 37.732588803110204 | -122.377001897143 | (37.7325888031102, -122.377001897143) | |
| 60955 | 60955 | 237510 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 962 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003748.05714 | 2102650.88909 | 37.7536908967175 | -122.42995434882799 | (37.7536908967175, -122.429954348828) | |||
| 121151 | 121151 | 60275 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 962 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1982 12:00:00 AM | Permit Number 19834 | 6009386.42258333 | 2103571.24243104 | 37.7565356817503 | -122.410520523389 | (37.7565356817503, -122.410520523389) | ||
| 94606 | 94606 | 32687 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 960 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37099 | 6010754.68261964 | 2112249.33418518 | 37.7804403523102 | -122.40640002274999 | (37.7804403523102, -122.40640002275) | ||
| 111576 | 111576 | 32688 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 960 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37099 | 6010754.68261964 | 2112249.33418518 | 37.7804403523102 | -122.40640002274999 | (37.7804403523102, -122.40640002275) | ||
| 183776 | 183776 | 196311 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 960 Harrison St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011645.79902 | 2111357.16189 | 37.7780404638396 | -122.403254436838 | (37.7780404638396, -122.403254436838) | |||
| 14998 | 14998 | 44032 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 96 Lafayette St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2014 12:00:00 AM | 1 | 3x3 | Permit Number 43568 | 6007703.80848 | 2109483.89132 | 37.7726759646606 | -122.41675848404199 | (37.7726759646606, -122.416758484042) | |
| 78917 | 78917 | 46863 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 96 Athens St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | Permit Number 44930 | 6004995.61677719 | 2092705.22653245 | 37.726452934298 | -122.424932453632 | (37.726452934298, -122.424932453632) | |||
| 117062 | 117062 | 46861 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 96 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | Permit Number 44930 | 6004995.61677719 | 2092705.22653245 | 37.726452934298 | -122.424932453632 | (37.726452934298, -122.424932453632) | |||
| 139797 | 139797 | 46862 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 96 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | Permit Number 44930 | 6004995.61677719 | 2092705.22653245 | 37.726452934298 | -122.424932453632 | (37.726452934298, -122.424932453632) | |||
| 67274 | 67274 | 235881 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 959 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009971.32211 | 2103627.1554799997 | 37.7567219798639 | -122.40850166713498 | (37.7567219798639, -122.408501667135) | |||
| 102442 | 102442 | 59902 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 959 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1991 12:00:00 AM | Permit Number 29861 | 6009979.75540702 | 2103626.4349407 | 37.7567204737109 | -122.408472450758 | (37.7567204737109, -122.408472450758) | ||
| 127211 | 127211 | 5818 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 959 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000256.5254907 | 2099603.3351939 | 37.7451246954454 | -122.441810105191 | (37.7451246954454, -122.441810105191) | |||
| 72882 | 72882 | 138939 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 955 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003223.616 | 2110999.5153 | 37.776584486268895 | -122.432364209952 | (37.7765844862689, -122.432364209952) | |||
| 148707 | 148707 | 61690 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 955 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 5 | Permit Number 21687 | 6005208.61729 | 2092129.1744799998 | 37.7248832508401 | -122.424155169531 | (37.7248832508401, -122.424155169531) | |
| 33403 | 33403 | 235882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 953 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009967.484019999 | 2103644.11822 | 37.7567683407994 | -122.408516137227 | (37.7567683407994, -122.408516137227) | |||
| 80244 | 80244 | 66649 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 953 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1991 12:00:00 AM | Permit Number 29860 | 6009977.90870649 | 2103659.93293665 | 37.7568123482779 | -122.408481200185 | (37.7568123482779, -122.408481200185) | ||
| 29675 | 29675 | 237538 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 953 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003803.28547 | 2102705.2140900004 | 37.753843187928794 | -122.42976723138901 | (37.7538431879288, -122.429767231389) | |||
| 118759 | 118759 | 67813 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 953 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31467 | 6003797.921467501 | 2102718.11025253 | 37.7538782940035 | -122.42978670111602 | (37.7538782940035, -122.429786701116) | ||
| 93766 | 93766 | 68476 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 953 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32345 | 6010237.60119466 | 2103674.28020112 | 37.7568662826358 | -122.40758409493999 | (37.7568662826358, -122.40758409494) | ||
| 39836 | 39836 | 235876 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 952 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009932.03776 | 2103654.85051 | 37.7567958240849 | -122.40863948104601 | (37.7567958240849, -122.408639481046) | |||
| 44169 | 44169 | 235875 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 952 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009931.64807 | 2103669.07061 | 37.756834847464205 | -122.40864183186599 | (37.7568348474642, -122.408641831866) | |||
| 32740 | 32740 | 212343 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 950 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5991291.38106 | 2104963.5329400003 | 37.7593274839915 | -122.47320055437099 | (37.7593274839915, -122.473200554371) | |||
| 118281 | 118281 | 69480 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 950 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33601 | 5991346.2855009 | 2104957.41469347 | 37.7593138637867 | -122.473010223799 | (37.7593138637867, -122.473010223799) | ||
| 26006 | 26006 | 237814 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004322.20575 | 2097568.0501599996 | 37.7397670945698 | -122.42760670998301 | (37.7397670945698, -122.427606709983) | |||
| 115483 | 115483 | 237815 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 Whitney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004320.070780001 | 2097586.35556 | 37.7398172362657 | -122.427615395653 | (37.7398172362657, -122.427615395653) | |||
| 24085 | 24085 | 212387 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991919.26492 | 2095494.2164099999 | 37.7333635115101 | -122.47033944313499 | (37.7333635115101, -122.470339443135) | |||
| 50935 | 50935 | 212388 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991917.7194 | 2095510.8633700002 | 37.733409130525295 | -122.470345998274 | (37.7334091305253, -122.470345998274) | |||
| 154535 | 154535 | 212389 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 San Rafael Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991918.06115 | 2095527.0929400001 | 37.7334537126093 | -122.47034599827101 | (37.7334537126093, -122.470345998271) | |||
| 35562 | 35562 | 212363 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 Madrone Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5992815.34336 | 2098532.42809 | 37.7417574462452 | -122.46746233472099 | (37.7417574462452, -122.467462334721) | |||
| 42526 | 42526 | 212362 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992799.6407 | 2098487.39858 | 37.7416329000314 | -122.467513355055 | (37.7416329000314, -122.467513355055) | |||
| 147584 | 147584 | 212364 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 Madrone Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992818.78469 | 2098543.53606 | 37.7417881445977 | -122.467451243405 | (37.7417881445977, -122.467451243405) | |||
| 35355 | 35355 | 70484 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 947 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 5 | 6005167.83048 | 2092104.0549400002 | 37.724811975074104 | -122.424294379186 | (37.7248119750741, -122.424294379186) | ||
| 145993 | 145993 | 106859 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 946 RHODE ISLAND ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 14 | 3x3 | Permit Number 773008 | 6011839.2 | 2104029.4 | 37.7579308843014 | -122.402070102772 | (37.7579308843014, -122.402070102772) | ||
| 131383 | 131383 | 196229 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 945 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010924.601290001 | 2109703.0719999997 | 37.7734584117023 | -122.40563279743601 | (37.7734584117023, -122.405632797436) | |||
| 159207 | 159207 | 196227 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 945 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010900.04295 | 2109677.4840599997 | 37.773386779817706 | -122.405715946037 | (37.7733867798177, -122.405715946037) | |||
| 167526 | 167526 | 196230 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 945 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010940.27995 | 2109717.0071400004 | 37.7734975511022 | -122.405579544073 | (37.7734975511022, -122.405579544073) | |||
| 185969 | 185969 | 196231 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 945 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010957.08191 | 2109733.0709599997 | 37.7735425981523 | -122.40552255492399 | (37.7735425981523, -122.405522554924) | |||
| 186315 | 186315 | 196228 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 945 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010909.1819400005 | 2109688.5937900003 | 37.773417795633605 | -122.40568511549 | (37.7734177956336, -122.40568511549) | |||
| 31661 | 31661 | 139405 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 943 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003118.0992 | 2111326.0356 | 37.7774750461812 | -122.43275255358299 | (37.7774750461812, -122.432752553583) | |||
| 171682 | 171682 | 135825 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 941 Vallejo St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6008892.44244 | 2118672.21795 | 37.7979716806151 | -122.413296744356 | (37.7979716806151, -122.413296744356) |
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");