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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123218 | 123218 | 60670 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 291 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004331.68787007 | 2096689.31302497 | 37.737354818402 | -122.42751133803101 | (37.737354818402, -122.427511338031) | ||
| 10856 | 10856 | 108684 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 46 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 774614 | 6000319.87619 | 2088768.81693 | 37.71537922895679 | -122.44081399618601 | (37.7153792289568, -122.440813996186) | |
| 12043 | 12043 | 108683 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 384 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774613 | 6000302.208459999 | 2086863.37515 | 37.7101463059777 | -122.44073846482401 | (37.7101463059777, -122.440738464824) |
| 13487 | 13487 | 108687 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1076 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 773107 | 6012169.21632 | 2103384.1046599997 | 37.756177459246295 | -122.400883423742 | (37.7561774592463, -122.400883423742) | |
| 110782 | 110782 | 64873 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 710 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | Permit Number 772699 | 6002299.12581357 | 2108836.45328021 | 37.77059279087 | -122.43540751638399 | (37.77059279087, -122.435407516384) | ||
| 83699 | 83699 | 102167 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769761 | 6002448.6 | 2104297.1 | 37.7581373205651 | -122.4345658575 | (37.7581373205651, -122.4345658575) |
| 86638 | 86638 | 59742 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 678 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769762 | 6002373.84394228 | 2104261.94389375 | 37.7580365463466 | -122.43482188178301 | (37.7580365463466, -122.434821881783) |
| 89281 | 89281 | 102176 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 488 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769768 | 5999452.4 | 2104200.8 | 37.7577023616885 | -122.444921049841 | (37.7577023616885, -122.444921049841) |
| 92794 | 92794 | 102177 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 267 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 5 | 6x9 | Permit Number 769769 | 6001804.7 | 2104316.3 | 37.758153465363996 | -122.436794111878 | (37.758153465364, -122.436794111878) |
| 93426 | 93426 | 102165 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3988 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769758 | 6003795.7 | 2104247.9 | 37.7580786087619 | -122.429903496461 | (37.7580786087619, -122.429903496461) |
| 97285 | 97285 | 102172 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 99121 | 99121 | 102169 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 235 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769763 | 6002117.1 | 2104495.4 | 37.758662980429996 | -122.435726513037 | (37.75866298043, -122.435726513037) |
| 111579 | 111579 | 102175 | Permitted Site 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 484 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769767 | 5999426.4 | 2104189.2 | 37.7576690270565 | -122.445010134311 | (37.7576690270565, -122.445010134311) |
| 111655 | 111655 | 102180 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769770 | 6001747.5 | 2103909.1 | 37.7570321415971 | -122.436962782195 | (37.7570321415971, -122.436962782195) |
| 117367 | 117367 | 102168 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 235 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769763 | 6002117.1 | 2104495.4 | 37.758662980429996 | -122.435726513037 | (37.75866298043, -122.435726513037) |
| 117592 | 117592 | 102174 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 10X Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3x3 | Permit Number 769766 | 6000586.1 | 2105578.9 | 37.7615509231117 | -122.44109912879699 | (37.7615509231117, -122.441099128797) | |
| 119070 | 119070 | 58905 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 655 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | Permit Number 769760 | 6002418.15212939 | 2104399.4018003996 | 37.7584164881822 | -122.43467847442601 | (37.7584164881822, -122.434678474426) | ||
| 142248 | 142248 | 102166 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 627 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769759 | 6002435.1 | 2104542.4 | 37.7588100889329 | -122.434630086253 | (37.7588100889329, -122.434630086253) |
| 143029 | 143029 | 102171 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 143949 | 143949 | 102170 | Permitted Site 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 270 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | 6001983.1 | 2104294.8 | 37.758104568963105 | -122.436175590041 | (37.7581045689631, -122.436175590041) | |
| 144941 | 144941 | 102173 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 10X Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3x3 | Permit Number 769766 | 6000586.1 | 2105578.9 | 37.7615509231117 | -122.44109912879699 | (37.7615509231117, -122.441099128797) | |
| 112141 | 112141 | 57610 | Permitted Site 1 | Tree(s) :: 17 | 350 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2009 12:00:00 AM | Permit Number 53125 | 6013182.80165221 | 2105434.53689469 | 37.7618639828655 | -122.39752187603202 | (37.7618639828655, -122.397521876032) | ||
| 45697 | 45697 | 38488 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2003 12:00:00 AM | 12 | Permit Number 47240 | 6008353.25415 | 2118952.7565200003 | 37.7987116832495 | -122.415182364581 | (37.7987116832495, -122.415182364581) | |
| 9831 | 9831 | 36377 | Permitted Site 1 | Tree(s) :: 17 | 160 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2016 12:00:00 AM | 3 | 2x2 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) |
| 9832 | 9832 | 36376 | Permitted Site 1 | Tree(s) :: 17 | 160 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2016 12:00:00 AM | 3 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) | |
| 12540 | 12540 | 108677 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Otsego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | Permit Number 773206 | 6000966.57436 | 2092971.8241299998 | 37.7269565451936 | -122.438879746024 | (37.7269565451936, -122.438879746024) | |
| 22963 | 22963 | 108630 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1469-1471 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772871 | 6002136.635290001 | 2111543.9635799997 | 37.778017709796295 | -122.436163356374 | (37.7780177097963, -122.436163356374) |
| 58949 | 58949 | 108642 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 167 Judson Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774606 | 5998978.54245 | 2093474.85877 | 37.7282244523119 | -122.44578846914 | (37.7282244523119, -122.44578846914) | |
| 80502 | 80502 | 108638 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 414 Hearst Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774605 | 5998661.98035 | 2094402.2163900002 | 37.7307526786149 | -122.446949537766 | (37.7307526786149, -122.446949537766) | |
| 82572 | 82572 | 49426 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 430-438 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | Permit Number 770910 | 5993243.20305227 | 2105992.08375012 | 37.7622644352537 | -122.466525019945 | (37.7622644352537, -122.466525019945) | |
| 87786 | 87786 | 105728 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82-98X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772582 | 6002862.0 | 2108710.0 | 37.7702775320686 | -122.43345149235701 | (37.7702775320686, -122.433451492357) |
| 89823 | 89823 | 66609 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 28- 30 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | Permit Number 773746 | 6005799.80596486 | 2106395.73703004 | 37.7640893550041 | -122.42312509671301 | (37.7640893550041, -122.423125096713) | |
| 96020 | 96020 | 70696 | Permitted Site 1 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 40 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772487 | 6009871.61507193 | 2111016.36108742 | 37.7770054589734 | -122.409367943314 | (37.7770054589734, -122.409367943314) |
| 98622 | 98622 | 108662 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 842 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772817 | 5982646.66004 | 2110014.0281599998 | 37.77269036496121 | -122.50347169236099 | (37.7726903649612, -122.503471692361) |
| 100459 | 100459 | 108658 | Permitted Site 1 | Platanus racemosa :: California Sycamore 81 | 30 Almaden Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774610 | 5995890.4686 | 2112526.48313 | 37.7803585963561 | -122.457842053153 | (37.7803585963561, -122.457842053153) |
| 103987 | 103987 | 108663 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 842 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772817 | 5982645.59315 | 2110033.9904099996 | 37.7727451127869 | -122.50347686125099 | (37.7727451127869, -122.503476861251) |
| 104720 | 104720 | 108666 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 687 45th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774612 | 5981944.00662 | 2111079.6776799997 | 37.7755749935311 | -122.50598122863501 | (37.7755749935311, -122.505981228635) | |
| 104984 | 104984 | 37482 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 1440 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | Permit Number 773208 | 5991178.05147208 | 2105601.75289786 | 37.761073303993705 | -122.473639055541 | (37.7610733039937, -122.473639055541) | |
| 109288 | 109288 | 108633 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2610 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774602 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) |
| 111496 | 111496 | 108667 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 743 45th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773175 | 5981956.75596 | 2110691.0447299997 | 37.7745086716833 | -122.50590830698098 | (37.7745086716833, -122.505908306981) | |
| 111761 | 111761 | 105729 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82-98X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772582 | 6002862.0 | 2108710.0 | 37.7702775320686 | -122.43345149235701 | (37.7702775320686, -122.433451492357) |
| 114454 | 114454 | 108678 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773206 | 6000980.19802 | 2092997.8380200001 | 37.727028748485395 | -122.43883451276501 | (37.7270287484854, -122.438834512765) |
| 115616 | 115616 | 108627 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 223 Douglass St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772318 | 6001122.48631 | 2104986.5175900003 | 37.7599549235553 | -122.439201532761 | (37.7599549235553, -122.439201532761) | |
| 121527 | 121527 | 108628 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 741 Ellis St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774600 | 6007319.99858 | 2113650.90643 | 37.7840959912819 | -122.418381641984 | (37.7840959912819, -122.418381641984) | |
| 121701 | 121701 | 108636 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 68 Mangels Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774603 | 6000942.00546 | 2095224.20835 | 37.7331396755893 | -122.439126041581 | (37.7331396755893, -122.439126041581) | |
| 139385 | 139385 | 108661 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 263 17th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773001 | 5990542.4091 | 2113638.3996200003 | 37.783102910833 | -122.47642453468399 | (37.783102910833, -122.476424534684) | |
| 139421 | 139421 | 108632 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 99 ORD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774601 | 6000898.0 | 2105859.0 | 37.7623377695764 | -122.440040482469 | (37.7623377695764, -122.440040482469) |
| 139650 | 139650 | 108635 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774602 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) |
| 140988 | 140988 | 108660 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1462 Blake St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771207 | 5997897.618969999 | 2112846.03551 | 37.781351110742996 | -122.45092146754 | (37.781351110743, -122.45092146754) | |
| 141705 | 141705 | 108659 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 233 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774611 | 5998294.8298 | 2109868.31432 | 37.773197790362 | -122.449332713458 | (37.773197790362, -122.449332713458) | |
| 145525 | 145525 | 108648 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 196 Lippard Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774607 | 6001751.75522 | 2094959.06379 | 37.7324576925005 | -122.436307555189 | (37.7324576925005, -122.436307555189) | |
| 9818 | 9818 | 46930 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9820 | 9820 | 46927 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9821 | 9821 | 46929 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 19496 | 19496 | 34866 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 579 Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | ||
| 70838 | 70838 | 69919 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 95 Mercedes Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.728618246103295 | -122.470591251084 | (37.7286182461033, -122.470591251084) | ||
| 83196 | 83196 | 71841 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 95 Mercedes Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 776113 | 5991810.08250882 | 2093768.29366569 | 37.728618246103295 | -122.470591251084 | (37.7286182461033, -122.470591251084) | ||
| 141249 | 141249 | 59937 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1738 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 19410 | 5999529.55338039 | 2110184.14033447 | 37.7741355180618 | -122.44508436599199 | (37.7741355180618, -122.445084365992) | ||
| 8180 | 8180 | 21666 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1765 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 4X4 | Permit Number 774582 | 6004178.5577 | 2114595.027 | 37.7865109691436 | -122.42931724201799 | (37.7865109691436, -122.429317242018) |
| 11726 | 11726 | 54377 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1454 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774580 | 5984357.5042 | 2105265.8509 | 37.7597536454069 | -122.49720322400299 | (37.7597536454069, -122.497203224003) |
| 12866 | 12866 | 108593 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 530 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | |||||
| 76019 | 76019 | 108612 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3628 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 774590 | 6002731.19846 | 2106518.35077 | 37.764252377203 | -122.433747267607 | (37.764252377203, -122.433747267607) | |
| 77897 | 77897 | 105128 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1835 47TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774579 | 5981612.2 | 2102591.6 | 37.752249639902296 | -122.506499383522 | (37.7522496399023, -122.506499383522) | |
| 79139 | 79139 | 108621 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 150-198X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 774592 | 6005405.0 | 2109611.0 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | |
| 79978 | 79978 | 108598 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 3103 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.3865799997 | 37.7482534137383 | -122.41141043143601 | (37.7482534137383, -122.411410431436) |
| 90861 | 90861 | 108602 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 47 Manchester St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.3489599996 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) |
| 92533 | 92533 | 108603 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 47 Manchester St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.3489599996 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) |
| 94944 | 94944 | 108615 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 136 Precita Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774598 | 6007320.4947 | 2100127.53408 | 37.746964004181706 | -122.417421212351 | (37.7469640041817, -122.417421212351) | |
| 99743 | 99743 | 108592 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 669 Parker Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774577 | 5997227.20075 | 2110944.62571 | 37.77609193478521 | -122.453103475186 | (37.7760919347852, -122.453103475186) |
| 101065 | 101065 | 108606 | Permitted Site 1 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 31 Milton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774591 | 6003745.94412 | 2095489.0241099999 | 37.7340259500004 | -122.429450953687 | (37.7340259500004, -122.429450953687) | |
| 108897 | 108897 | 103416 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1500 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 769963 | 5991394.0 | 2098432.0 | 37.7413995354896 | -122.472369502423 | (37.7413995354896, -122.472369502423) | |
| 115798 | 115798 | 105995 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 331 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774584 | 5989936.41295 | 2113124.32829 | 37.781656250780294 | -122.478483407908 | (37.7816562507803, -122.478483407908) |
| 116753 | 116753 | 103415 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1500 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 769963 | 5991394.0 | 2098432.0 | 37.7413995354896 | -122.472369502423 | (37.7413995354896, -122.472369502423) | |
| 117752 | 117752 | 108599 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 47 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.3489599996 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) |
| 117776 | 117776 | 67731 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1471 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 774581 | 5992402.99511967 | 2105448.3839166 | 37.7607230584725 | -122.46939137901 | (37.7607230584725, -122.46939137901) | |
| 120168 | 120168 | 108610 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 745 Moultrie St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774595 | 6007633.33742 | 2095945.52231 | 37.7354987236975 | -122.416043312411 | (37.7354987236975, -122.416043312411) | |
| 127069 | 127069 | 108608 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 46 Mirabel Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774593 | 6007564.86266 | 2099909.6740900003 | 37.7463795558054 | -122.416560777242 | (37.7463795558054, -122.416560777242) | |
| 127452 | 127452 | 108600 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 47 Manchester St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.3489599996 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) |
| 128674 | 128674 | 108597 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 3103 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.3865799997 | 37.7482534137383 | -122.41141043143601 | (37.7482534137383, -122.411410431436) |
| 139078 | 139078 | 108601 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 47 Manchester St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.3489599996 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) |
| 142489 | 142489 | 108622 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 244 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 772819 | 6002313.92049 | 2109316.7536299997 | 37.7719124170473 | -122.43539070428301 | (37.7719124170473, -122.435390704283) | |
| 144896 | 144896 | 79557 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 153 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772536 | 6004741.65189255 | 2108986.02751221 | 37.7711418993687 | -122.426969442731 | (37.7711418993687, -122.426969442731) |
| 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) |
| 13067 | 13067 | 83533 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 242 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769751 | 6002979.54268 | 2092016.08462 | 37.724446620113 | -122.43185274573099 | (37.724446620113, -122.431852745731) |
| 186267 | 186267 | 52534 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2957 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2005 12:00:00 AM | 6 | Permit Number 48633 | 6003844.287719999 | 2118934.9851 | 37.7984084579424 | -122.430783559724 | (37.7984084579424, -122.430783559724) | |
| 18397 | 18397 | 39677 | Permitted Site 1 | Quercus keloggii :: California Black Oak 307 | 446 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41063 | 5993017.43068395 | 2090147.12878073 | 37.718745152502606 | -122.46615437062401 | (37.7187451525026, -122.466154370624) | ||
| 23760 | 23760 | 39595 | Permitted Site 1 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust 334 | 343 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 5 | Permit Number 41002 | 6011201.08685 | 2106729.17552 | 37.7653082265272 | -122.40446701436301 | (37.7653082265272, -122.404467014363) | |
| 23981 | 23981 | 39601 | Permitted Site 1 | Brahea edulis :: Guadalupe Palm 115 | 375 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 20 | Permit Number 41004 | 6011207.62517 | 2106615.88788 | 37.76499752963429 | -122.40443642482 | (37.7649975296343, -122.40443642482) | |
| 27849 | 27849 | 39596 | Permitted Site 1 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust 334 | 365 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 3 | Permit Number 41003 | 6011206.39772 | 2106634.59416 | 37.7650488242625 | -122.40444198711799 | (37.7650488242625, -122.404441987118) | |
| 33329 | 33329 | 39598 | Permitted Site 1 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust 334 | 365 Vermont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 6 | Permit Number 41003 | 6011204.97691 | 2106670.11712 | 37.765146282890704 | -122.40444940203001 | (37.7651462828907, -122.40444940203) | |
| 36302 | 36302 | 38643 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 850 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 8 | Permit Number 41006 | 6012722.66852 | 2103506.4045 | 37.7565441236392 | -122.39897796896099 | (37.7565441236392, -122.398977968961) | |
| 42989 | 42989 | 39658 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 311 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41051 | 5995887.27205834 | 2090529.96858098 | 37.7199614976995 | -122.45626220721901 | (37.7199614976995, -122.456262207219) | ||
| 55929 | 55929 | 39589 | Permitted Site 1 | Archontophoenix cunninghamiana :: King Palm 210 | 1108 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 8 | Permit Number 41000 | 6011896.10584 | 2103264.6085900003 | 37.755834111566294 | -122.40181953886001 | (37.7558341115663, -122.40181953886) | |
| 69985 | 69985 | 39594 | Permitted Site 1 | Gleditsia triacanthos 'Sunburst' :: Sunburst Honey Locust 334 | 343 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 3 | Permit Number 41002 | 6011202.82824 | 2106709.39136 | 37.7652540010087 | -122.404459598545 | (37.7652540010087, -122.404459598545) | |
| 77994 | 77994 | 39639 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 556 Arch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41033 | 5992765.12816761 | 2090901.30196023 | 37.7208013690683 | -122.46708127369101 | (37.7208013690683, -122.467081273691) | ||
| 78629 | 78629 | 39631 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1578 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41026 | 5997930.04124721 | 2105225.66494664 | 37.7604293831671 | -122.450259840819 | (37.7604293831671, -122.450259840819) | ||
| 79353 | 79353 | 39646 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 72 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41040 | 5994176.513717599 | 2090402.3957613998 | 37.719512859484794 | -122.462166418076 | (37.7195128594848, -122.462166418076) | ||
| 81242 | 81242 | 39675 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.718609818509606 | -122.462555624891 | (37.7186098185096, -122.462555624891) | ||
| 81356 | 81356 | 39618 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 172 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41018 | 5997530.61215046 | 2106784.14607791 | 37.7646857112231 | -122.45175370217501 | (37.7646857112231, -122.451753702175) | ||
| 81402 | 81402 | 32754 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 518 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41062 | 5995930.70396007 | 2088752.73433833 | 37.7150841234911 | -122.45598366275699 | (37.7150841234911, -122.455983662757) |
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");