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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | ||
| 20572 | 20572 | 27519 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005760.41969 | 2101697.87743 | 37.751187906306896 | -122.42292741057 | (37.7511879063069, -122.42292741057) | ||
| 21550 | 21550 | 27620 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1149 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010601.0802 | 2102491.1542599997 | 37.7536380210979 | -122.40624368710199 | (37.7536380210979, -122.406243687102) | |||
| 13815 | 13815 | 27724 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015353.113480001 | 2101161.82636 | 37.750252634763996 | -122.389717121075 | (37.750252634764, -122.389717121075) | ||
| 15791 | 15791 | 27728 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015202.17288 | 2101166.08495 | 37.750255956855 | -122.390239385253 | (37.750255956855, -122.390239385253) | ||
| 14286 | 14286 | 27729 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015622.7491 | 2101166.85438 | 37.75028138877779 | -122.38878504659999 | (37.7502813887778, -122.3887850466) | ||
| 13686 | 13686 | 27731 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015524.1696 | 2101161.19501 | 37.7502603851148 | -122.38912554882 | (37.7502603851148, -122.38912554882) | ||
| 4328 | 4328 | 28085 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2255 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6002770.4091 | 2114749.1272 | 37.786854268374796 | -122.43420010239201 | (37.7868542683748, -122.434200102392) | |||
| 129333 | 129333 | 28105 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3385X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6007142.16868 | 2100525.74665 | 37.7480473709689 | -122.418066075247 | (37.7480473709689, -122.418066075247) | |||
| 92859 | 92859 | 28143 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 459 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006960.8227954 | 2097937.5089004 | 37.740930442807105 | -122.418509660609 | (37.7409304428071, -122.418509660609) | |||
| 12039 | 12039 | 28243 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3230 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2004 12:00:00 AM | 8 | 2X3 | 6011870.75873 | 2090643.72462 | 37.7211784199346 | -122.401020454343 | (37.7211784199346, -122.401020454343) | ||
| 12568 | 12568 | 28244 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3260 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2003 12:00:00 AM | 12 | 2X3 | 6011894.92216 | 2090508.59301 | 37.7208087239121 | -122.40092743836 | (37.7208087239121, -122.40092743836) | ||
| 11353 | 11353 | 28245 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3312 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2002 12:00:00 AM | 8 | 2X3 | 6011933.46331 | 2090279.87862 | 37.7201828704297 | -122.40077815269899 | (37.7201828704297, -122.400778152699) | ||
| 10377 | 10377 | 28246 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3326 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2002 12:00:00 AM | 3 | 2X3 | 6011947.80562 | 2090200.17318 | 37.7199648154144 | -122.400722979282 | (37.7199648154144, -122.400722979282) | ||
| 114369 | 114369 | 28253 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3432 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2002 12:00:00 AM | 3 | 3X3 | 6012031.1541281 | 2089723.1062284 | 37.718659534499295 | -122.40040137877199 | (37.7186595344993, -122.400401378772) | ||
| 12009 | 12009 | 28254 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3410 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2002 12:00:00 AM | 8 | 3X3 | 6012011.64722 | 2089824.91922 | 37.7189380045612 | -122.400475954423 | (37.7189380045612, -122.400475954423) | ||
| 11481 | 11481 | 28255 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3476 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2003 12:00:00 AM | 6 | 3x3 | 6012058.005419999 | 2089554.66958 | 37.7181985388057 | -122.400296740219 | (37.7181985388057, -122.400296740219) | ||
| 10340 | 10340 | 28256 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3476 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2003 12:00:00 AM | 6 | 3x3 | 6012060.981000001 | 2089540.1901200002 | 37.7181589470551 | -122.400285438425 | (37.7181589470551, -122.400285438425) | ||
| 23228 | 23228 | 28259 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3562 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2004 12:00:00 AM | 10 | 3x3 | 6012127.60331 | 2089140.68412 | 37.717065698801 | -122.400027111788 | (37.717065698801, -122.400027111788) | ||
| 95112 | 95112 | 28260 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3562 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2003 12:00:00 AM | 12 | 3x3 | 6012130.0554759 | 2089144.2345931 | 37.717075584405706 | -122.400018884967 | (37.7170755844057, -122.400018884967) | ||
| 11150 | 11150 | 28262 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3624 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2003 12:00:00 AM | 12 | 3x3 | 6012194.4874599995 | 2088681.14992 | 37.715807638979705 | -122.399763675165 | (37.7158076389797, -122.399763675165) | ||
| 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) | ||
| 12903 | 12903 | 28302 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3410 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6012014.9954 | 2089805.7813099998 | 37.7188856424495 | -122.40046303743799 | (37.7188856424495, -122.400463037438) | |||
| 123542 | 123542 | 28348 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3136 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008810.2764485 | 2100618.7635013 | 37.748396520659 | -122.412304375108 | (37.748396520659, -122.412304375108) | ||
| 124249 | 124249 | 28349 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3138 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008797.6727778 | 2100618.7090393 | 37.748395663859895 | -122.412347954631 | (37.7483956638599, -122.412347954631) | ||
| 144753 | 144753 | 28351 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3168 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008614.019290701 | 2100617.9154502 | 37.7483831772452 | -122.412982970428 | (37.7483831772452, -122.412982970428) | ||
| 97771 | 97771 | 28352 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3170 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008602.0157948 | 2100617.8635816 | 37.748382361007295 | -122.413024474721 | (37.7483823610073, -122.413024474721) | ||
| 124981 | 124981 | 28353 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3178 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008552.8014616 | 2100617.6509205 | 37.7483790142799 | -122.413194642313 | (37.7483790142799, -122.413194642313) | ||
| 142451 | 142451 | 28354 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3182 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008528.194294999 | 2100617.5445899 | 37.7483773408239 | -122.413279726103 | (37.7483773408239, -122.413279726103) | ||
| 117470 | 117470 | 28355 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3188 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2001 12:00:00 AM | 3 | 4x4 | 6008491.5836326 | 2100617.3863908 | 37.7483748509345 | -122.413406314174 | (37.7483748509345, -122.413406314174) | ||
| 140218 | 140218 | 28356 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3188 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008491.5836326 | 2100617.3863908 | 37.7483748509345 | -122.413406314174 | (37.7483748509345, -122.413406314174) | ||
| 93823 | 93823 | 28615 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999987.60975 | 2091601.0392099998 | 37.7231369387356 | -122.442165640215 | (37.7231369387356, -122.442165640215) | |||
| 117446 | 117446 | 28616 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999998.87347 | 2091601.9533400002 | 37.7231400906515 | -122.44212676945601 | (37.7231400906515, -122.442126769456) | |||
| 90559 | 90559 | 28617 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000011.03973 | 2091602.5396 | 37.7231423937331 | -122.44208475527701 | (37.7231423937331, -122.442084755277) | |||
| 144521 | 144521 | 28618 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000023.845509999 | 2091604.32382 | 37.723148022568104 | -122.442040616354 | (37.7231480225681, -122.442040616354) | |||
| 101577 | 101577 | 28619 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6000038.78425 | 2091606.3548299999 | 37.7231544505641 | -122.441989121927 | (37.7231544505641, -122.441989121927) | |||
| 89743 | 89743 | 28620 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6000051.9098 | 2091608.73805 | 37.723161742302 | -122.441943920583 | (37.723161742302, -122.441943920583) | |||
| 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) | ||
| 110260 | 110260 | 28780 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6918 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5985532.54019 | 2112610.11302 | 37.7799877082801 | -122.493680597714 | (37.7799877082801, -122.493680597714) | |||
| 84850 | 84850 | 28781 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6938 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5985497.48939 | 2112543.62929 | 37.7798031124744 | -122.493796951714 | (37.7798031124744, -122.493796951714) | |||
| 80503 | 80503 | 28782 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6938 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5985488.09937 | 2112541.18326 | 37.7797958470089 | -122.493829255147 | (37.7797958470089, -122.493829255147) | |||
| 114388 | 114388 | 28783 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6938 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5985480.3602 | 2112543.9942799998 | 37.7798031124689 | -122.493856235161 | (37.7798031124689, -122.493856235161) | |||
| 7138 | 7138 | 29119 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 509 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008381.9659 | 2113792.89597 | 37.7845455839642 | -122.414717657915 | (37.7845455839642, -122.414717657915) | ||
| 124893 | 124893 | 29668 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500 Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/09/2004 12:00:00 AM | 6 | 6005837.0202043 | 2118942.4447679003 | 37.79854163961021 | -122.42388861727899 | (37.7985416396102, -122.423888617279) | |||
| 154459 | 154459 | 30576 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 268 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52597 | 6003988.43817 | 2108723.63607 | 37.770378817350604 | -122.429556120021 | (37.7703788173506, -122.429556120021) | |
| 40285 | 40285 | 30587 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 68 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 11 | Permit Number 34557 | 6002888.52611 | 2108685.82804 | 37.7702126667237 | -122.43335801118499 | (37.7702126667237, -122.433358011185) | |
| 185754 | 185754 | 30598 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 66 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 12 | Permit Number 34565 | 6004323.10435 | 2108874.18954 | 37.7708111439393 | -122.428409241587 | (37.7708111439393, -122.428409241587) | |
| 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) |
| 165571 | 165571 | 30804 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 14 | Permit Number 34669 | 6001616.65191 | 2095326.1919200001 | 37.733458064439 | -122.43680091003401 | (37.733458064439, -122.436800910034) | |
| 73545 | 73545 | 30881 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 59 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | 1 | Permit Number 34714 | 6004013.78951 | 2108865.19521 | 37.7707689396642 | -122.42947852651301 | (37.7707689396642, -122.429478526513) | ||
| 157439 | 157439 | 30897 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 252 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1995 12:00:00 AM | 7 | Permit Number 34724 | 6007528.97575 | 2097493.2020099997 | 37.739742443263296 | -122.416513727228 | (37.7397424432633, -122.416513727228) | |
| 54523 | 54523 | 31006 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 8 | Permit Number 34780 | 6000669.33593 | 2088075.8661099998 | 37.713496437089894 | -122.43955646516599 | (37.7134964370899, -122.439556465166) | |
| 73045 | 73045 | 31021 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 317 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34787 | 6002776.11429 | 2086581.1916200002 | 37.7095120680942 | -122.432168021935 | (37.7095120680942, -122.432168021935) | |
| 178402 | 178402 | 31022 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 8 | Permit Number 34788 | 6002783.56511 | 2086520.12567 | 37.7093448166924 | -122.43213791266001 | (37.7093448166924, -122.43213791266) | |
| 68733 | 68733 | 31023 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34788 | 6002794.80361 | 2086503.3822400002 | 37.7092994800486 | -122.43209787574 | (37.7092994800486, -122.43209787574) | |
| 163282 | 163282 | 31057 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 5 | Permit Number 34809 | 6002747.277969999 | 2087115.5773200002 | 37.7109777400017 | -122.43230582505 | (37.7109777400017, -122.43230582505) | |
| 135851 | 135851 | 31058 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 6 | Permit Number 34809 | 6002732.75221 | 2087097.44922 | 37.71092714054029 | -122.432354735598 | (37.7109271405403, -122.432354735598) | |
| 43257 | 43257 | 31128 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 121 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 11 | 6x4 | Permit Number 34844 | 5998083.53233 | 2093940.2779 | 37.7294512402595 | -122.44891605234501 | (37.7294512402595, -122.448916052345) |
| 48200 | 48200 | 31194 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 354 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46596 | 5993258.721390001 | 2089558.71458 | 37.7171434272164 | -122.46527761436899 | (37.7171434272164, -122.465277614369) | |
| 61324 | 61324 | 31297 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 53 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34941 | 6002026.478019999 | 2105548.36068 | 37.7615490072959 | -122.43611527411899 | (37.7615490072959, -122.436115274119) | ||
| 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) | |
| 37962 | 37962 | 31466 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 512 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35032 | 6002998.75397 | 2102141.19875 | 37.7522489444334 | -122.432509202251 | (37.7522489444334, -122.432509202251) | ||
| 181369 | 181369 | 31513 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2513 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 15 | Permit Number 35071 | 6011012.0661 | 2102261.56789 | 37.7530306081845 | -122.40480623683399 | (37.7530306081845, -122.404806236834) | |
| 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) | |
| 75236 | 75236 | 31704 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 445 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 15 | Permit Number 35206 | 5997671.58785 | 2107448.25781 | 37.7665172660868 | -122.45131400735399 | (37.7665172660868, -122.451314007354) | |
| 156903 | 156903 | 31706 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 465 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 11 | 5x5 | Permit Number 35208 | 5997497.49265 | 2107424.13572 | 37.7664410629264 | -122.451914428032 | (37.7664410629264, -122.451914428032) |
| 164850 | 164850 | 31788 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35258 | 6001692.80487 | 2107894.1622099997 | 37.7679710399513 | -122.437437296395 | (37.7679710399513, -122.437437296395) | |
| 75522 | 75522 | 31904 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2246 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | 3 | Permit Number 47389 | 5992012.51749 | 2100130.96562 | 37.746100239137895 | -122.47035460209999 | (37.7461002391379, -122.4703546021) | |
| 46283 | 46283 | 31905 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2259 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 9 | Permit Number 35330 | 5991969.67434 | 2100068.6545599997 | 37.7459266717829 | -122.47049820945 | (37.7459266717829, -122.47049820945) | |
| 46997 | 46997 | 31908 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2227 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 13 | Permit Number 35333 | 5991730.6123 | 2100240.74702 | 37.746385367410205 | -122.47133738212601 | (37.7463853674102, -122.471337382126) | |
| 69301 | 69301 | 31909 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2227 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 14 | Permit Number 35333 | 5991726.96722 | 2100261.52129 | 37.746442197347605 | -122.471351499672 | (37.7464421973476, -122.471351499672) | |
| 65939 | 65939 | 31911 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2236 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 11 | Permit Number 35335 | 5991758.20148 | 2100218.73627 | 37.7463265274626 | -122.471240379447 | (37.7463265274626, -122.471240379447) | |
| 49985 | 49985 | 31912 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2256 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 9 | Permit Number 35336 | 5991754.81336 | 2100091.67364 | 37.745977450207 | -122.47124283909099 | (37.745977450207, -122.471242839091) | |
| 163806 | 163806 | 31987 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 128 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/2004 12:00:00 AM | 11 | Permit Number 35387 | 5994614.2845 | 2114627.8658 | 37.7860550266291 | -122.462409396175 | (37.7860550266291, -122.462409396175) | |
| 69827 | 69827 | 31988 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 12 | Permit Number 35388 | 5994566.451859999 | 2114623.28431 | 37.786039692573205 | -122.46257455055901 | (37.7860396925732, -122.462574550559) | |
| 32843 | 32843 | 31989 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 6 | Permit Number 35389 | 5994568.75053 | 2114560.8648099997 | 37.78586843793 | -122.462562068449 | (37.78586843793, -122.462562068449) | |
| 48217 | 48217 | 32078 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3847 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 6 | Permit Number 35451 | 6003283.17124 | 2105912.34445 | 37.7626197356314 | -122.431794879733 | (37.7626197356314, -122.431794879733) | |
| 38950 | 38950 | 32086 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3928 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 5 | Permit Number 35459 | 6003448.93768 | 2104799.28963 | 37.759572949446394 | -122.431142104137 | (37.7595729494464, -122.431142104137) | |
| 59928 | 59928 | 32098 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 134 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 8 | Permit Number 35471 | 6002656.28427 | 2105089.46023 | 37.7603247386273 | -122.433904232401 | (37.7603247386273, -122.433904232401) | |
| 133940 | 133940 | 32103 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 237 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 9 | Permit Number 35475 | 6002723.82147 | 2104526.537 | 37.7587829193134 | -122.43363042122101 | (37.7587829193134, -122.433630421221) | |
| 163171 | 163171 | 32104 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 242 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 7 | Permit Number 35476 | 6002688.38371 | 2104495.7919400004 | 37.7586964899576 | -122.433750783787 | (37.7586964899576, -122.433750783787) | |
| 68159 | 68159 | 32124 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 70 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 10 | Permit Number 35486 | 6003846.92621 | 2106756.5408799998 | 37.764969637151 | -122.429905274625 | (37.764969637151, -122.429905274625) | |
| 136726 | 136726 | 32208 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1779 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 5 | Permit Number 35530 | 6009365.92876 | 2099185.56999 | 37.744492451861205 | -122.41028175730601 | (37.7444924518612, -122.410281757306) | |
| 162751 | 162751 | 32321 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 550 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/1996 12:00:00 AM | 11 | Permit Number 36888 | 6002737.460419999 | 2103880.90968 | 37.7570109554122 | -122.43353711207199 | (37.7570109554122, -122.433537112072) | ||
| 69458 | 69458 | 32354 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 116 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | 16 | Permit Number 36908 | 6002648.503 | 2105198.2324099997 | 37.7606229592107 | -122.43393891927299 | (37.7606229592107, -122.433938919273) | |
| 175130 | 175130 | 32497 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 665 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 16 | Permit Number 37002 | 6007442.3069400005 | 2095863.1015400002 | 37.7352616718948 | -122.416697941676 | (37.7352616718948, -122.416697941676) | |
| 176209 | 176209 | 32514 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 814 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 3 | Permit Number 37016 | 6007565.02408 | 2095597.87607 | 37.7345403220735 | -122.41625488347799 | (37.7345403220735, -122.416254883478) | |
| 184129 | 184129 | 32690 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 480 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 1 | Permit Number 37101 | 6010817.622359999 | 2111993.44255 | 37.7797412544913 | -122.406164249981 | (37.7797412544913, -122.406164249981) | |
| 125064 | 125064 | 32691 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 480 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 1 | Permit Number 37101 | 6010795.05101 | 2111971.34075 | 37.7796793055824 | -122.406240776896 | (37.7796793055824, -122.406240776896) | |
| 105993 | 105993 | 32849 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 716 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50467 | 6001761.70945494 | 2102078.76287853 | 37.7520072832286 | -122.43678262007 | (37.7520072832286, -122.43678262007) | |
| 100337 | 100337 | 32947 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37265 | 6012942.48941846 | 2105645.52533205 | 37.762429926839204 | -122.39836783116002 | (37.7624299268392, -122.39836783116) | ||
| 103473 | 103473 | 32988 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 205 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | Permit Number 45058 | 6004189.32426901 | 2109462.38505411 | 37.7724186144331 | -122.428913931102 | (37.7724186144331, -122.428913931102) | ||
| 56604 | 56604 | 33140 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3143 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 6 | Permit Number 37367 | 6001896.074 | 2118984.29093 | 37.798433267540105 | -122.437528496644 | (37.7984332675401, -122.437528496644) | |
| 183771 | 183771 | 33141 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3143 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37367 | 6001898.22805 | 2118969.0422099996 | 37.7983915210181 | -122.437519950413 | (37.7983915210181, -122.437519950413) | |
| 161379 | 161379 | 33142 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3148 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2005 12:00:00 AM | 8 | Permit Number 37368 | 6001934.81136 | 2119023.6664400003 | 37.798543584677894 | -122.437397274777 | (37.7985435846779, -122.437397274777) | |
| 136377 | 136377 | 33273 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1121 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 7 | Permit Number 37442 | 6009382.25638 | 2117052.9627099996 | 37.7935530901583 | -122.41148738125901 | (37.7935530901583, -122.411487381259) | |
| 125207 | 125207 | 33423 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 163 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2015 12:00:00 AM | Permit Number 774515 | 5993446.55612201 | 2094023.66864414 | 37.729413936236604 | -122.464952451879 | (37.7294139362366, -122.464952451879) | ||
| 51525 | 51525 | 33649 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 541 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 8 | Permit Number 37740 | 6004806.91261 | 2110706.66354 | 37.775870037302106 | -122.426866263978 | (37.7758700373021, -122.426866263978) |
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");