Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12718 | 12718 | 109057 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 825 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772770 | 5997289.5352300005 | 2087142.99435 | 37.7107420465867 | -122.45117096298401 | (37.7107420465867, -122.451170962984) |
| 12764 | 12764 | 83412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52320 | 6003991.38049 | 2093029.1643599998 | 37.727285619722295 | -122.428427134505 | (37.7272856197223, -122.428427134505) |
| 12882 | 12882 | 62704 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 251 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1986 12:00:00 AM | 8 | 3x3 | Permit Number 23044 | 5999960.32769 | 2091545.33962 | 37.7229824455563 | -122.442255952067 | (37.7229824455563, -122.442255952067) | |
| 13060 | 13060 | 109069 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1065 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772763 | 6002105.570119999 | 2087176.80573 | 37.7111094529054 | -122.434528092094 | (37.7111094529054, -122.434528092094) |
| 13073 | 13073 | 28301 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3336 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2003 12:00:00 AM | 8 | 3X3 | 6011974.103080001 | 2090046.14983 | 37.719543365213 | -122.400621263274 | (37.719543365213, -122.400621263274) | ||
| 13168 | 13168 | 95747 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 223 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767492 | 6002627.86341 | 2092385.97592 | 37.7254423161963 | -122.433094867748 | (37.7254423161963, -122.433094867748) |
| 13234 | 13234 | 82735 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 174 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769757 | 6003803.82611 | 2092820.0296 | 37.726700767200896 | -122.429060604385 | (37.7267007672009, -122.429060604385) |
| 13327 | 13327 | 48822 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 512 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2017 12:00:00 AM | 3 | Permit Number 46801 | 6003066.62090041 | 2102150.20608679 | 37.7522775247752 | -122.43227515114401 | (37.7522775247752, -122.432275151144) | |
| 13385 | 13385 | 108724 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 566 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773100 | 6011759.6093 | 2105732.18704 | 37.762601916479504 | -122.40246509469401 | (37.7626019164795, -122.402465094694) |
| 13745 | 13745 | 4018 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1760 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 3 | 2X3 | 6013908.29896 | 2101074.88916 | 37.7499337000814 | -122.394707332299 | (37.7499337000814, -122.394707332299) | ||
| 13759 | 13759 | 109718 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013027.725819999 | 2089252.6527099998 | 37.7174232872231 | -122.396923644015 | (37.7174232872231, -122.396923644015) | |||
| 13866 | 13866 | 10995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016004.21156 | 2097242.6965900003 | 37.7395275952262 | -122.387192226744 | (37.7395275952262, -122.387192226744) | |||
| 14555 | 14555 | 86928 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 838 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774404 | 6011553.2134300005 | 2104436.20347 | 37.759031910124 | -122.403087784389 | (37.759031910124, -122.403087784389) | |
| 14693 | 14693 | 67488 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1117 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 773109 | 6012239.52235 | 2103185.1315 | 37.7556350439301 | -122.400626303061 | (37.7556350439301, -122.400626303061) | |
| 14945 | 14945 | 44031 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 96 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52444 | 6007775.95033 | 2109430.42042 | 37.772533203581204 | -122.41650514858699 | (37.7725332035812, -122.416505148587) | |
| 15561 | 15561 | 43296 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 589 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | Permit Number 775309 | 6013581.06232 | 2104334.57728 | 37.758865901566296 | -122.39606735184601 | (37.7588659015663, -122.396067351846) | ||
| 16684 | 16684 | 121586 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 855 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012479.74347 | 2103984.1173799997 | 37.7578422788274 | -122.399851639655 | (37.7578422788274, -122.399851639655) | |||
| 16838 | 16838 | 63769 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2013 12:00:00 AM | 18 | 3x3 | Permit Number 768706 | 6013040.47104 | 2113998.55413 | 37.7853709106802 | -122.398615140189 | (37.7853709106802, -122.398615140189) | |
| 16945 | 16945 | 27513 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2001 12:00:00 AM | 8 | 3X3 | 6005754.33518 | 2101803.9188099997 | 37.751478728181795 | -122.422955987444 | (37.7514787281818, -122.422955987444) | ||
| 16975 | 16975 | 4208 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3928 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6004332.42415 | 2100461.61534 | 37.747712737955105 | -122.427777497548 | (37.7477127379551, -122.427777497548) | ||
| 17026 | 17026 | 16614 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | privately planted on dpw street without permit | 6002879.45304 | 2107636.12058 | 37.7673299123847 | -122.433314375152 | (37.7673299123847, -122.433314375152) | ||
| 17165 | 17165 | 23041 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 987 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1994 12:00:00 AM | 12 | 3X3 | 6006352.9755 | 2103862.85209 | 37.7571658456457 | -122.421031987753 | (37.7571658456457, -122.421031987753) | ||
| 17183 | 17183 | 10191 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1163 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/1991 12:00:00 AM | 12 | 2X3 | 6005802.7182 | 2102181.70358 | 37.7525187680511 | -122.422815518735 | (37.7525187680511, -122.422815518735) | ||
| 17251 | 17251 | 4061 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3045 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 12 | 3x3 | 6009371.8230099995 | 2100537.10689 | 37.7482038046704 | -122.41035678685499 | (37.7482038046704, -122.410356786855) | ||
| 17409 | 17409 | 4836 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 123 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2000 12:00:00 AM | 6 | 3X3 | 6006379.67825 | 2097659.7420099997 | 37.7401350234134 | -122.420499335499 | (37.7401350234134, -122.420499335499) | ||
| 17483 | 17483 | 27512 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005753.54797 | 2101830.48031 | 37.75155161552 | -122.422960597352 | (37.75155161552, -122.422960597352) | ||
| 17623 | 17623 | 4137 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3550 Cesar Chavez St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2000 12:00:00 AM | 3 | 3x3 | 6006233.57538 | 2100604.08317 | 37.7482112843407 | -122.421213523093 | (37.7482112843407, -122.421213523093) | ||
| 17628 | 17628 | 27516 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005758.28533 | 2101749.6847900003 | 37.75133003695179 | -122.422938473144 | (37.7513300369518, -122.422938473144) | ||
| 17635 | 17635 | 4185 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3836 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004920.4543 | 2100493.66271 | 37.747833979169705 | -122.42574640029899 | (37.7478339791697, -122.425746400299) | |||
| 17748 | 17748 | 26435 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3919 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1997 12:00:00 AM | 3 | 3X3 | 6004375.00551 | 2100419.95241 | 37.747600749869896 | -122.427627285584 | (37.7476007498699, -122.427627285584) | ||
| 17813 | 17813 | 4106 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3359 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2003 12:00:00 AM | 3 | 3X3 | 6007379.19247 | 2100526.00618 | 37.7480614213048 | -122.417246472374 | (37.7480614213048, -122.417246472374) | ||
| 17860 | 17860 | 101958 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200X Ripley St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/2013 12:00:00 AM | 3x3 | Permit Number 770180 | 6009339.0 | 2099105.0 | 37.744269714821 | -122.410369184032 | (37.744269714821, -122.410369184032) | ||
| 18004 | 18004 | 5790 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 573 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002988.46433 | 2108287.7672099997 | 37.769125358463995 | -122.43298388241301 | (37.769125358464, -122.432983882413) | |||
| 18032 | 18032 | 99798 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 723-725 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001735.0 | 2102034.0 | 37.7518828570558 | -122.43687178091899 | (37.7518828570558, -122.436871780919) | ||||
| 18229 | 18229 | 27514 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005755.80226 | 2101784.51034 | 37.7514255197779 | -122.422949534811 | (37.7514255197779, -122.422949534811) | ||
| 18264 | 18264 | 10085 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 648 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1998 12:00:00 AM | 13 | 3x2 | 6005571.80442 | 2105186.7253099997 | 37.7607568250935 | -122.423827714701 | (37.7607568250935, -122.423827714701) | ||
| 18266 | 18266 | 4090 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3215 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1995 12:00:00 AM | 6 | 3X3 | 6008246.07333 | 2100530.81306 | 37.748123352213504 | -122.41424916149201 | (37.7481233522135, -122.414249161492) | ||
| 18339 | 18339 | 3945 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 129 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2000 12:00:00 AM | 6 | 3X3 | 6002246.22679 | 2107489.51068 | 37.7668914137434 | -122.435494123149 | (37.7668914137434, -122.435494123149) | ||
| 18366 | 18366 | 92323 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2595 27th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3x3 | Permit Number 52755 | 5987970.2 | 2097662.1 | 37.739086838436606 | -122.484151218827 | (37.7390868384366, -122.484151218827) | |
| 18402 | 18402 | 48402 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | Permit Number 53935 | 6012689.64928807 | 2104214.1545054 | 37.7584856101735 | -122.399141839868 | (37.7584856101735, -122.399141839868) | |||
| 18466 | 18466 | 26512 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2862 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2003 12:00:00 AM | 16 | 3X3 | 6008947.332669999 | 2101811.77998 | 37.7516799676748 | -122.41191472918301 | (37.7516799676748, -122.411914729183) | ||
| 18631 | 18631 | 10219 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1361 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2002 12:00:00 AM | 6 | 3X3 | 6005865.11973 | 2101072.64646 | 37.7494770729178 | -122.422520923317 | (37.7494770729178, -122.422520923317) | ||
| 18633 | 18633 | 41286 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 494 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52403 | 6005499.65147882 | 2107857.73967205 | 37.7680867232876 | -122.424267232407 | (37.7680867232876, -122.424267232407) | ||
| 18879 | 18879 | 94134 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Nebraska St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53498 | 6009291.0 | 2097948.0 | 37.7410901551317 | -122.41045347697501 | (37.7410901551317, -122.410453476975) | |||
| 18890 | 18890 | 4111 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3385X Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 3 | 3x3 | 6007239.656 | 2100524.9644 | 37.7480507095515 | -122.41772891157301 | (37.7480507095515, -122.417728911573) | ||
| 19061 | 19061 | 50930 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2287 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47426 | 5991460.4982554 | 2099833.27531374 | 37.745250926286396 | -122.47224169859699 | (37.7452509262864, -122.472241698597) | ||
| 19167 | 19167 | 4207 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3925 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6004350.15957 | 2100418.81646 | 37.747596225391504 | -122.427713120473 | (37.7475962253915, -122.427713120473) | ||
| 19182 | 19182 | 4299 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4366 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001539.555819999 | 2100311.7976 | 37.747142989565 | -122.437424340763 | (37.747142989565, -122.437424340763) | ||
| 19214 | 19214 | 10228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1411 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2002 12:00:00 AM | 6 | 3X3 | 6005886.64477 | 2100667.53648 | 37.7483659479448 | -122.422417708118 | (37.7483659479448, -122.422417708118) | ||
| 19226 | 19226 | 30599 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | 5x7 | Permit Number 34566 | 6004311.30995 | 2108965.65965 | 37.771061631219 | -122.428456559416 | (37.771061631219, -122.428456559416) |
| 19442 | 19442 | 5816 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 949 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 6000363.39173 | 2099612.7288599997 | 37.745156576909 | -122.441441255331 | (37.745156576909, -122.441441255331) | ||
| 19460 | 19460 | 16615 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778956 | 6002889.7801 | 2107581.65027 | 37.7671809360695 | -122.433274762729 | (37.7671809360695, -122.433274762729) | |
| 19466 | 19466 | 12753 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1730 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2000 12:00:00 AM | 12 | 3X3 | 5990048.7235199995 | 2114754.53717 | 37.786138867937495 | -122.478214101082 | (37.7861388679375, -122.478214101082) | ||
| 19589 | 19589 | 4075 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3187 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6008490.22185 | 2100532.98453 | 37.748143025801 | -122.413405055098 | (37.748143025801, -122.413405055098) | ||
| 19764 | 19764 | 4267 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4182 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6002831.44442 | 2100380.32351 | 37.7474045070076 | -122.43296199290899 | (37.7474045070076, -122.432961992909) | ||
| 19771 | 19771 | 31446 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 239 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 7 | Permit Number 35021 | 6002088.5838 | 2104465.22029 | 37.758578494425294 | -122.435822975577 | (37.7585784944253, -122.435822975577) | |
| 19981 | 19981 | 28779 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4065 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2004 12:00:00 AM | 3 | 3X3 | 6003498.496040001 | 2100372.77288 | 37.747421587832 | -122.430654836155 | (37.747421587832, -122.430654836155) | ||
| 20033 | 20033 | 239534 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007215.03698 | 2097696.74866 | 37.7402836768401 | -122.417613619697 | (37.7402836768401, -122.417613619697) | ||||
| 20141 | 20141 | 27518 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 4 | 3x3 | 6005759.73558 | 2101716.47325 | 37.751238927544605 | -122.422931097816 | (37.7512389275446, -122.422931097816) | ||
| 20172 | 20172 | 4056 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2987 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 3 | 3x3 | 6009651.14757 | 2100536.83905 | 37.7482187235208 | -122.409390868191 | (37.7482187235208, -122.409390868191) | ||
| 20479 | 20479 | 73501 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767446 | 6001962.16426713 | 2101054.16463509 | 37.74920537061129 | -122.436016109621 | (37.7492053706113, -122.436016109621) | |
| 20494 | 20494 | 97050 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1841 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2011 12:00:00 AM | 4x4 | Permit Number 768113 | 5989656.1 | 2102823.3 | 37.7533561549786 | -122.478699565369 | (37.7533561549786, -122.478699565369) | ||
| 20524 | 20524 | 26480 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2011 12:00:00 AM | 3 | 3x3 | 6001160.50342 | 2098677.8339 | 37.742634955228894 | -122.438618011821 | (37.7426349552289, -122.438618011821) | ||
| 20662 | 20662 | 84576 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3966 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6003390.40048346 | 2101879.79659646 | 37.7515533971776 | -122.43113617160401 | (37.7515533971776, -122.431136171604) |
| 20694 | 20694 | 4134 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3550 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2000 12:00:00 AM | 3 | 3x3 | 6006304.68418 | 2100605.7275799997 | 37.7482198080922 | -122.42096774735901 | (37.7482198080922, -122.420967747359) | ||
| 20714 | 20714 | 12956 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3 | 5x5 | 6001961.90749 | 2095766.9942400001 | 37.7346880222327 | -122.435638790816 | (37.7346880222327, -122.435638790816) | ||
| 20763 | 20763 | 36 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 773 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003693.31613 | 2107706.2481400003 | 37.7675686032223 | -122.430504342717 | (37.7675686032223, -122.430504342717) | |||
| 20977 | 20977 | 55153 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3933 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2009 12:00:00 AM | 3x3 | Permit Number 52132 | 6003602.67369464 | 2101839.43403285 | 37.7514545976895 | -122.43039922507201 | (37.7514545976895, -122.430399225072) | ||
| 21098 | 21098 | 10199 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X2 | 6005752.31611 | 2101874.30524 | 37.7516718791661 | -122.42296797178801 | (37.7516718791661, -122.422967971788) | |||
| 21236 | 21236 | 92078 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1151 Sutter St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2009 12:00:00 AM | 3x3 | Permit Number 52192 | 6007083.0 | 2115004.0 | 37.7877979108835 | -122.41929759225799 | (37.7877979108835, -122.419297592258) | |||
| 21301 | 21301 | 3944 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 129 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/1999 12:00:00 AM | 6 | 3X3 | 6002248.02502 | 2107476.74068 | 37.7668564525859 | -122.435486989749 | (37.7668564525859, -122.435486989749) | ||
| 21329 | 21329 | 16625 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2007 12:00:00 AM | 3 | 3x3 | 6002893.733109999 | 2107470.63526 | 37.7668763401938 | -122.43325315650401 | (37.7668763401938, -122.433253156504) | ||
| 21380 | 21380 | 4200 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3890 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6004657.19405 | 2100480.3462900002 | 37.7477825352565 | -122.42665579384399 | (37.7477825352565, -122.426655793844) | ||
| 21554 | 21554 | 10197 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2004 12:00:00 AM | 3 | 2X2 | 6005817.7414 | 2101914.20762 | 37.7517851334751 | -122.42274455772301 | (37.7517851334751, -122.422744557723) | ||
| 21660 | 21660 | 10102 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 771 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 3 | 2X2 | 6005674.239019999 | 2104513.09601 | 37.758912979273205 | -122.423425548652 | (37.7589129792732, -122.423425548652) | ||
| 21681 | 21681 | 4232 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3997 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1995 12:00:00 AM | 12 | 3x3 | 6003965.74465 | 2100395.01673 | 37.7475091242643 | -122.429040707768 | (37.7475091242643, -122.429040707768) | ||
| 21989 | 21989 | 10059 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 481 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2010 12:00:00 AM | 3 | 3X3 | 6005579.31828 | 2106221.1938400003 | 37.763597655717504 | -122.42387528793002 | (37.7635976557175, -122.42387528793) | ||
| 21994 | 21994 | 27517 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005756.59865 | 2101732.46517 | 37.7512826606677 | -122.422943082157 | (37.7512826606677, -122.422943082157) | ||
| 22128 | 22128 | 4249 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4043 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1995 12:00:00 AM | 12 | 3X3 | 6003613.964 | 2100376.48243 | 37.7474383143284 | -122.43025582047599 | (37.7474383143284, -122.430255820476) | ||
| 22246 | 22246 | 239535 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007214.411780001 | 2097683.0452099997 | 37.7402460150284 | -122.417614810389 | (37.7402460150284, -122.417614810389) | ||||
| 22297 | 22297 | 237232 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 156 Rivoli St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997863.35341 | 2105946.59714 | 37.7624050647642 | -122.450542457376 | (37.7624050647642, -122.450542457376) | |||
| 22921 | 22921 | 187655 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1548 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779523 | 6003789.0 | 2099328.0 | 37.744569337434 | -122.42957579341999 | (37.744569337434, -122.42957579342) | |
| 22957 | 22957 | 108702 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2382 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772586 | 6001605.971969999 | 2118381.98302 | 37.79676299019629 | -122.438489159966 | (37.7967629901963, -122.438489159966) |
| 22977 | 22977 | 109971 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1435 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2015 12:00:00 AM | 3 | 3x3 | 5999653.8 | 2113835.4 | 37.7841680297741 | -122.444917101722 | (37.7841680297741, -122.444917101722) | ||
| 23166 | 23166 | 26519 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2851 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 1 | 1X1 | Permit Number 777140 | 6009004.2746 | 2101873.01384 | 37.751851296609296 | -122.411722142074 | (37.7518512966093, -122.411722142074) | |
| 23327 | 23327 | 54378 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2105 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2013 12:00:00 AM | 3 | 0 | Permit Number 769000 | 6003486.81156 | 2117545.01589 | 37.7945717009834 | -122.43192123267401 | (37.7945717009834, -122.431921232674) | |
| 23387 | 23387 | 213501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 787 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994873.7468 | 2093233.8423799998 | 37.7273274525845 | -122.459961359351 | (37.7273274525845, -122.459961359351) | |||
| 23502 | 23502 | 214703 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5992960.1777800005 | 2094882.5024400002 | 37.7317440249629 | -122.46669629760001 | (37.7317440249629, -122.4666962976) | |||
| 23557 | 23557 | 213451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5993177.52134 | 2099659.6696900004 | 37.7448734694269 | -122.466291957027 | (37.7448734694269, -122.466291957027) | |||
| 23561 | 23561 | 238503 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 68 Wilder St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002672.92744 | 2095557.23 | 37.7341524174814 | -122.433165572429 | (37.7341524174814, -122.433165572429) | |||
| 23585 | 23585 | 237396 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2797 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008140.86181 | 2106769.2911 | 37.7652468801621 | -122.415054485502 | (37.7652468801621, -122.415054485502) | |||
| 23601 | 23601 | 238482 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003589.43942 | 2108803.81702 | 37.7705763750292 | -122.430941979801 | (37.7705763750292, -122.430941979801) | |||
| 23606 | 23606 | 31666 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4066 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 6 | Permit Number 35467 | 6002585.751619999 | 2104753.963 | 37.7593995412727 | -122.434124187708 | (37.7593995412727, -122.434124187708) | |
| 23638 | 23638 | 179012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6001860.73543 | 2090148.2767900003 | 37.719254552441704 | -122.435586742551 | (37.7192545524417, -122.435586742551) | |||
| 23681 | 23681 | 237227 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Grattan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5997877.39625 | 2106473.17188 | 37.763851709710394 | -122.450531852572 | (37.7638517097104, -122.450531852572) | |||
| 23779 | 23779 | 213682 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6000730.9848 | 2095013.8875 | 37.7325501736469 | -122.43984052053801 | (37.7325501736469, -122.439840520538) | |||
| 23875 | 23875 | 123972 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993617.67519 | 2115041.45387 | 37.78713318686079 | -122.46588743043002 | (37.7871331868608, -122.46588743043) | |||
| 23887 | 23887 | 83255 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5983253.61867 | 2110435.38712 | 37.773882958787205 | -122.501403365431 | (37.7738829587872, -122.501403365431) | |||
| 23939 | 23939 | 179130 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009941.55337 | 2092988.7834299998 | 37.727509654348104 | -122.40785447092199 | (37.7275096543481, -122.407854470922) | |||
| 24054 | 24054 | 179073 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 201 Otsego Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6000546.4255099995 | 2092093.61368 | 37.724521267414296 | -122.440269236362 | (37.7245212674143, -122.440269236362) |
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");