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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10801 | 10801 | 83237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769756 | 6004043.10746 | 2093201.4009 | 37.727761469894794 | -122.42826058457099 | (37.7277614698948, -122.428260584571) |
77900 | 77900 | 99712 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
90054 | 90054 | 99710 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
101806 | 101806 | 99709 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
113083 | 113083 | 99708 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
139212 | 139212 | 99711 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
119018 | 119018 | 62880 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1986 12:00:00 AM | 3x3 | Permit Number 49921 | 6008828.47380472 | 2098062.83988383 | 37.7413795400306 | -122.41206084487 | (37.7413795400306, -122.41206084487) | ||
109631 | 109631 | 94680 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53816 | 6003489.0 | 2095230.0 | 37.733300177534204 | -122.430320814613 | (37.7333001775342, -122.430320814613) | |
77358 | 77358 | 47252 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767654 | 6013117.42744406 | 2089558.25653077 | 37.718267407089 | -122.39663499597201 | (37.718267407089, -122.396634995972) | |
114167 | 114167 | 99706 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100@Moncada Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
119703 | 119703 | 99707 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100@Moncada Paloma Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
92548 | 92548 | 103760 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100X Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006758.9 | 2115521.2 | 37.789199755991795 | -122.420455645258 | (37.7891997559918, -122.420455645258) | ||
106963 | 106963 | 27248 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100X CORTLAND AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2000 12:00:00 AM | 4 | 3X3 | 6006272.0 | 2097672.0 | 37.7401626122958 | -122.420872513823 | (37.7401626122958, -122.420872513823) | ||
31155 | 31155 | 87154 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50137 | 5992080.87589 | 2114715.15142 | 37.7861484784179 | -122.47118058793998 | (37.7861484784179, -122.47118058794) | |
72144 | 72144 | 87155 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50137 | 5992081.9043 | 2114697.2023099996 | 37.7860992546106 | -122.471175721775 | (37.7860992546106, -122.471175721775) | |
153588 | 153588 | 68685 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50137 | 5992080.71456 | 2114734.20286 | 37.7862007790713 | -122.47118253461001 | (37.7862007790713, -122.47118253461) | |
96244 | 96244 | 40667 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Maynard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767516 | 6004070.62612566 | 2093782.39936272 | 37.72935831911229 | -122.428206841061 | (37.7293583191123, -122.428206841061) | |
127500 | 127500 | 40666 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Maynard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767516 | 6004070.62612566 | 2093782.39936272 | 37.72935831911229 | -122.428206841061 | (37.7293583191123, -122.428206841061) | |
120325 | 120325 | 89313 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767419 | 6002340.0 | 2108819.0 | 37.7705471897255 | -122.43526488371799 | (37.7705471897255, -122.435264883718) | |
3103 | 3103 | 238168 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1010 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 14 | Width 4ft | Permit Number 27196 | 6003119.41534 | 2102323.30502 | 37.7527558068522 | -122.432104939916 | (37.7527558068522, -122.432104939916) | |
3084 | 3084 | 238169 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1018 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 2 | Width 4ft | Permit Number 27197 | 6003120.08624 | 2102266.16095 | 37.7525989407879 | -122.432098539422 | (37.7525989407879, -122.432098539422) | |
3629 | 3629 | 103766 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101X Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006706.11036 | 2115484.69473 | 37.7890965465282 | -122.420635698799 | (37.7890965465282, -122.420635698799) | ||
127259 | 127259 | 103765 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101X Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006551.29204 | 2115477.0840000003 | 37.789066922774204 | -122.42117081077 | (37.7890669227742, -122.42117081077) | ||
87465 | 87465 | 51286 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1026 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767263 | 6004381.40328388 | 2102911.72608688 | 37.7544429415209 | -122.42778267914301 | (37.7544429415209, -122.427782679143) | |
2957 | 2957 | 238483 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 13 | Width 3ft | Permit Number 37768 | 6003709.010969999 | 2108821.61027 | 37.7706320052989 | -122.430529650538 | (37.7706320052989, -122.430529650538) | |
2962 | 2962 | 238484 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 7 | Width 3ft | Permit Number 37768 | 6003723.3725 | 2108822.3529 | 37.7706348579377 | -122.430480026835 | (37.7706348579377, -122.430480026835) | |
4600 | 4600 | 103784 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006741.56415 | 2115141.24736 | 37.788155522905505 | -122.420488644345 | (37.7881555229055, -122.420488644345) | ||
8999 | 8999 | 103785 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006767.43674 | 2115144.46398 | 37.7881658129506 | -122.420399357843 | (37.7881658129506, -122.420399357843) | ||
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) | |
97124 | 97124 | 71983 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 3 | 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) | |
143111 | 143111 | 70987 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 4 | 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) | |
102743 | 102743 | 107954 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Danvers St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771125 | 5999967.5 | 2105076.1 | 37.760135104087794 | -122.44320249258301 | (37.7601351040878, -122.443202492583) | |
115650 | 115650 | 107953 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Danvers St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771125 | 5999967.5 | 2105076.1 | 37.760135104087794 | -122.44320249258301 | (37.7601351040878, -122.443202492583) | |
117774 | 117774 | 81336 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771125 | 5999938.45094538 | 2105136.44437451 | 37.760299138392 | -122.44330729346599 | (37.760299138392, -122.443307293466) | |
91235 | 91235 | 47701 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45497 | 6003509.82655426 | 2097791.42406059 | 37.7403344433628 | -122.430431505695 | (37.7403344433628, -122.430431505695) | ||
129147 | 129147 | 47700 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45497 | 6003509.82655426 | 2097791.42406059 | 37.7403344433628 | -122.430431505695 | (37.7403344433628, -122.430431505695) | ||
73 | 73 | 65479 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1051 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1997 12:00:00 AM | 10 | 3x3 | Permit Number 28361 | 6008468.497880001 | 2115537.43749 | 37.789340533487795 | -122.41454177659901 | (37.7893405334878, -122.414541776599) |
81215 | 81215 | 53899 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1057 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2009 12:00:00 AM | Permit Number 52970 | 6011224.04910165 | 2089865.72837227 | 37.7190061040508 | -122.403201256455 | (37.7190061040508, -122.403201256455) | |||
88581 | 88581 | 94959 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.37808815314199 | (37.7364745658864, -122.378088153142) | ||||
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) |
6501 | 6501 | 103875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006702.4202 | 2115509.69435 | 37.7891649813311 | -122.42065024171002 | (37.7891649813311, -122.42065024171) | ||
6991 | 6991 | 103876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006716.01893 | 2115511.31786 | 37.7891702054911 | -122.420603306998 | (37.7891702054911, -122.420603306998) | ||
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) | ||
72980 | 72980 | 69395 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1075 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33499 | 6002066.46838 | 2087158.9447 | 37.711058190666705 | -122.43466196070801 | (37.7110581906667, -122.434661960708) | |
63276 | 63276 | 59606 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1077 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 1 | 3x3 | Permit Number 19007 | 6015566.4484 | 2104073.9972599996 | 37.7582606677124 | -122.38918270881099 | (37.7582606677124, -122.389182708811) | |
72023 | 72023 | 40646 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 108 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | Permit Number 41644 | 6004664.1042599995 | 2094195.33475 | 37.7305257097718 | -122.426184517611 | (37.7305257097718, -122.426184517611) | |
107794 | 107794 | 50098 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 108 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52733 | 5992719.49980491 | 2098392.60521716 | 37.74136799423071 | -122.46778356014099 | (37.7413679942307, -122.467783560141) | ||
56131 | 56131 | 49551 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1084REVISED Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2003 12:00:00 AM | 5 | Permit Number 46441 | 6009968.28689 | 2111507.46699 | 37.7783593364429 | -122.40906818514601 | (37.7783593364429, -122.409068185146) | ||
80030 | 80030 | 84222 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
93504 | 93504 | 84211 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
141941 | 141941 | 84223 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
29713 | 29713 | 88413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51386 | 6009439.10659 | 2116768.27237 | 37.792774588415796 | -122.411270553799 | (37.7927745884158, -122.411270553799) | |
31826 | 31826 | 88412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009452.7788 | 2116769.6537 | 37.792779147992796 | -122.411223344786 | (37.7927791479928, -122.411223344786) | |
81508 | 81508 | 88416 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
97381 | 97381 | 88421 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
112603 | 112603 | 88418 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
116912 | 116912 | 88417 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
138283 | 138283 | 88419 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
146280 | 146280 | 88420 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
153833 | 153833 | 88415 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009399.28346 | 2116763.19844 | 37.792758423123495 | -122.41140798549601 | (37.7927584231235, -122.411407985496) | |
155637 | 155637 | 88414 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009411.74152 | 2116765.8223 | 37.7927663263429 | -122.41136506535 | (37.7927663263429, -122.41136506535) | |
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) | |
99154 | 99154 | 57489 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111X Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52603 | 6002672.27523217 | 2105293.3654228 | 37.760885520528795 | -122.43386350193 | (37.7608855205288, -122.43386350193) |
126623 | 126623 | 56348 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111X Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52603 | 6002684.86057117 | 2105294.05500137 | 37.7608881281181 | -122.433820024128 | (37.7608881281181, -122.433820024128) |
145845 | 145845 | 56621 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1120 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2012 12:00:00 AM | Permit Number 769116 | 6001921.73131937 | 2100826.98518644 | 37.7485792926383 | -122.436139672143 | (37.7485792926383, -122.436139672143) | |||
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) | |
131819 | 131819 | 38505 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1123 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1998 12:00:00 AM | 9 | Permit Number 40496 | 6008719.38643 | 2117949.78915 | 37.795978352179205 | -122.41384444046699 | (37.7959783521792, -122.413844440467) | ||
145112 | 145112 | 94665 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53802 | 6004019.0 | 2095233.0 | 37.733338421606604 | -122.42848867219801 | (37.7333384216066, -122.428488672198) | |
100282 | 100282 | 109418 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771960 | 6000642.7 | 2102407.9 | 37.752847354291504 | -122.44067591422599 | (37.7528473542915, -122.440675914226) |
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) | |
82049 | 82049 | 69397 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | Permit Number 772744 | 6001523.93675849 | 2087030.79827901 | 37.7106755138649 | -122.436527911504 | (37.7106755138649, -122.436527911504) | |
24585 | 24585 | 49743 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 114 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 8 | Permit Number 46542 | 6010621.23603 | 2087831.01483 | 37.7133855110935 | -122.405141759495 | (37.7133855110935, -122.405141759495) | |
123300 | 123300 | 36940 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 11 | Permit Number 39579 | 5994867.05226 | 2114773.19638 | 37.7864686172836 | -122.461545434289 | (37.7864686172836, -122.461545434289) | |
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) | |||
65515 | 65515 | 103235 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 116 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2013 12:00:00 AM | 5 | Permit Number 770114 | 5998278.0 | 2110273.0 | 37.7743079905046 | -122.44942009353998 | (37.7743079905046, -122.44942009354) | ||
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) | |
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) | ||
71708 | 71708 | 66515 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1173 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1991 12:00:00 AM | 7 | Permit Number 29681 | 6007962.75323 | 2118537.74133 | 37.7975502016423 | -122.41650421331 | (37.7975502016423, -122.41650421331) | ||
156227 | 156227 | 52875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 118@ BEACH Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48887 | 6001367.786590001 | 2121129.52184 | 37.8042934541427 | -122.439510392889 | (37.8042934541427, -122.439510392889) | |
185006 | 185006 | 52876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 118@ BEACH Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 3 | Permit Number 48887 | 6001354.74762 | 2121139.05445 | 37.8043188860645 | -122.439556198976 | (37.8043188860645, -122.439556198976) | ||
104135 | 104135 | 16618 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 119 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 6 | 3X3 | 6002884.413921201 | 2107574.4751295 | 37.7671609304618 | -122.433292810769 | (37.7671609304618, -122.433292810769) | ||
55895 | 55895 | 40019 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 12 Latona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 6 | Permit Number 41264 | 6014412.91208 | 2094585.9323200001 | 37.732144413937796 | -122.392508504263 | (37.7321444139378, -122.392508504263) | |
99132 | 99132 | 51392 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 12 Rausch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | Permit Number 47720 | 6009581.33332398 | 2110978.5612901 | 37.77688540137029 | -122.410369452214 | (37.7768854013703, -122.410369452214) | ||
100137 | 100137 | 51393 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 12 Rausch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | Permit Number 47720 | 6009581.33332398 | 2110978.5612901 | 37.77688540137029 | -122.410369452214 | (37.7768854013703, -122.410369452214) | ||
79436 | 79436 | 49639 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46495 | 5996531.16368383 | 2094439.5259582 | 37.7307331551513 | -122.454318757944 | (37.7307331551513, -122.454318757944) | ||
142618 | 142618 | 49640 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46495 | 5996531.16368383 | 2094439.5259582 | 37.7307331551513 | -122.454318757944 | (37.7307331551513, -122.454318757944) | ||
63147 | 63147 | 68401 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 16 | Permit Number 32233 | 6002304.62048 | 2093927.0229599997 | 37.7296553414093 | -122.434322413556 | (37.7296553414093, -122.434322413556) | |
9424 | 9424 | 16412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200X Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | ||
9468 | 9468 | 16413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | ||
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) | ||
81667 | 81667 | 44392 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X ATHENS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492.0 | 2087581.0 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | |||
102329 | 102329 | 44394 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X ATHENS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492.0 | 2087581.0 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | |||
121911 | 121911 | 44393 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X ATHENS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492.0 | 2087581.0 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | |||
118662 | 118662 | 50931 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1207 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2004 12:00:00 AM | Permit Number 47427 | 5990566.91543714 | 2103796.02034286 | 37.7560798303656 | -122.475620830891 | (37.7560798303656, -122.475620830891) | |||
91912 | 91912 | 115432 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 121 Edgehill Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777500 | 5994912.6 | 2098995.5 | 37.7431497843009 | -122.460244308613 | (37.7431497843009, -122.460244308613) | ||
129278 | 129278 | 115431 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 121 Edgehill Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777500 | 5994912.6 | 2098995.5 | 37.7431497843009 | -122.460244308613 | (37.7431497843009, -122.460244308613) | ||
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) |
78855 | 78855 | 54202 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 121 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770897 | 5995407.75355189 | 2107023.99587375 | 37.765222467855295 | -122.459113429254 | (37.7652224678553, -122.459113429254) |
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) | ||
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) |
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");