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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188961 | 188961 | 203619 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 624 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6000138.382019999 | 2095835.3347200002 | 37.7347719253748 | -122.441948223841 | (37.7347719253748, -122.441948223841) | |||
12409 | 12409 | 115759 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1718 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998106.99194 | 2088701.9387700001 | 37.7150693216746 | -122.448457855865 | (37.7150693216746, -122.448457855865) | ||
12488 | 12488 | 108566 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 627 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772549 | 6010648.7747599995 | 2091709.2722900002 | 37.7240359509768 | -122.405319522179 | (37.7240359509768, -122.405319522179) |
15008 | 15008 | 108726 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 460 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773097 | 6011176.24234 | 2106141.01313 | 37.7636918767911 | -122.404511540684 | (37.7636918767911, -122.404511540684) |
15919 | 15919 | 96192 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1634 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x6 | 6015129.8118 | 2097200.08447 | 37.739362129854605 | -122.390212570161 | (37.7393621298546, -122.390212570161) | |||
29982 | 29982 | 203614 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2555 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991713.8644900005 | 2098047.40615 | 37.7403620464585 | -122.47123551863001 | (37.7403620464585, -122.47123551863) | |||
31315 | 31315 | 221967 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 448 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003863.12438 | 2096025.37276 | 37.7355052757557 | -122.429084054179 | (37.7355052757557, -122.429084054179) | |||
33302 | 33302 | 203617 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 185 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994473.17466 | 2100793.8774900003 | 37.7480623907666 | -122.46189409053899 | (37.7480623907666, -122.461894090539) | |||
34354 | 34354 | 203616 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 185 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994461.2194300005 | 2100782.80797 | 37.7480313083953 | -122.46193462839199 | (37.7480313083953, -122.461934628392) | |||
35336 | 35336 | 175226 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1150 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6001420.49828 | 2087082.59126 | 37.7108118474628 | -122.43688912273998 | (37.7108118474628, -122.43688912274) | |||
44675 | 44675 | 125559 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 20 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001981.60949 | 2119919.32974 | 37.8010055012508 | -122.43729950587799 | (37.8010055012508, -122.437299505878) | |||
47069 | 47069 | 175223 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 39 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002350.25908 | 2087113.68805 | 37.7109500327891 | -122.433677880228 | (37.7109500327891, -122.433677880228) | |||
53242 | 53242 | 36575 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2959 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | Permit Number 773747 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | |
53899 | 53899 | 175227 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 225 Naylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6002635.08266 | 2086756.92621 | 37.709986599863 | -122.43266799554199 | (37.709986599863, -122.432667995542) | |||
55362 | 55362 | 221956 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 126 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009115.60345 | 2096745.48812 | 37.7377784848985 | -122.41097502309601 | (37.7377784848985, -122.410975023096) | |||
58808 | 58808 | 203618 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 185 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994486.24709 | 2100807.40007 | 37.74810027292239 | -122.461849867291 | (37.7481002729224, -122.461849867291) | |||
67352 | 67352 | 187964 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 211 Terry A Francois Blvd | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6015658.44742 | 2110621.01823 | 37.776242461855205 | -122.38932171163401 | (37.7762424618552, -122.389321711634) | |||
70236 | 70236 | 187966 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 211 Terry A Francois Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6015666.2407 | 2110622.1949 | 37.7762461247865 | -122.38929483449499 | (37.7762461247865, -122.389294834495) | |||
70699 | 70699 | 203595 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 423 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5997934.90621 | 2094082.1225 | 37.729832211087 | -122.44944008101999 | (37.729832211087, -122.44944008102) | |||
71517 | 71517 | 109072 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1570 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769406 | 5992498.7 | 2104770.7 | 37.758867846563795 | -122.469011061686 | (37.7588678465638, -122.469011061686) |
74352 | 74352 | 247232 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 760 Duboce Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002013.60886 | 2108293.7767 | 37.7690865158689 | -122.43635627624701 | (37.7690865158689, -122.436356276247) | |||
75734 | 75734 | 189233 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1919 22nd St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012396.53776 | 2103734.18422 | 37.7571513782439 | -122.400121849061 | (37.7571513782439, -122.400121849061) | |||
79874 | 79874 | 115385 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 375 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776680 | 6007256.8 | 2096298.8 | 37.7364475687434 | -122.41737017570298 | (37.7364475687434, -122.417370175703) | ||
82748 | 82748 | 117377 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 3783 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 775394 | 6003225.8 | 2102971.4 | 37.754541353189204 | -122.43178331278 | (37.7545413531892, -122.43178331278) | ||
85695 | 85695 | 117322 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 590 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778502 | 5984157.3 | 2111842.1 | 37.77779841707871 | -122.49838135403 | (37.7777984170787, -122.49838135403) | ||
110414 | 110414 | 90809 | DPW Maintained 3 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 3351X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2015 11:05:00 AM | 3 | 3x3 | 5985151.309330001 | 2110394.17837 | 37.77388107713121 | -122.494835999778 | (37.7738810771312, -122.494835999778) | ||
114574 | 114574 | 117306 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 732 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778516 | 5981405.4 | 2110730.6 | 37.7745848102238 | -122.507818456039 | (37.7745848102238, -122.507818456039) | ||
118943 | 118943 | 115333 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 667 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 776458 | 5994991.0 | 2111007.6 | 37.7761364319113 | -122.460843601074 | (37.7761364319113, -122.460843601074) | ||
120094 | 120094 | 123429 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 690 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5995057.91765 | 2110847.9262900003 | 37.7757018603334 | -122.460600543143 | (37.7757018603334, -122.460600543143) | |||
125614 | 125614 | 109897 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1734 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775111 | 5987546.7 | 2103468.6 | 37.75500527135279 | -122.486041582178 | (37.7550052713528, -122.486041582178) |
125904 | 125904 | 36574 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2959 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | Permit Number 773747 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | |
127347 | 127347 | 117307 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 714 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778519 | 5981710.1 | 2110853.1 | 37.7749391065248 | -122.506773545049 | (37.7749391065248, -122.506773545049) | ||
129695 | 129695 | 221943 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 237 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006873.22599 | 2096639.71242 | 37.737362050226395 | -122.41872052504401 | (37.7373620502264, -122.418720525044) | |||
134698 | 134698 | 221960 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 75 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006819.46923 | 2099263.44478 | 37.744563206943795 | -122.41909243697799 | (37.7445632069438, -122.419092436978) | |||
138740 | 138740 | 69064 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1359 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | Permit Number 773642 | 5992377.26935607 | 2106205.46978928 | 37.7628003299421 | -122.469535465436 | (37.7628003299421, -122.469535465436) | |
140457 | 140457 | 108526 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1677 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773677 | 5990566.2613699995 | 2103985.48594 | 37.7566000147891 | -122.47563692717699 | (37.7566000147891, -122.475636927177) |
144567 | 144567 | 109033 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2120 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772816 | 5987671.1 | 2103767.6 | 37.755833493421704 | -122.48563331933 | (37.7558334934217, -122.48563331933) |
150141 | 150141 | 125560 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 20 Mallorca Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001979.154630001 | 2119935.63772 | 37.8010501391173 | -122.437309169106 | (37.8010501391173, -122.437309169106) | |||
150529 | 150529 | 189236 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1700 Bancroft Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6013792.02021 | 2092615.53995 | 37.7266996169689 | -122.39451715893499 | (37.7266996169689, -122.394517158935) | |||
159774 | 159774 | 175225 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 762 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002385.00148 | 2087111.8293299999 | 37.7109469004454 | -122.43355766966299 | (37.7109469004454, -122.433557669663) | |||
168407 | 168407 | 189237 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1700 Bancroft Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6013775.5681 | 2092627.0535099998 | 37.726730316242296 | -122.394574839671 | (37.7267303162423, -122.394574839671) | |||
174756 | 174756 | 203615 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 240 Colon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5996037.383230001 | 2094398.48179 | 37.7305921283128 | -122.45602285758899 | (37.7305921283128, -122.456022857589) | |||
178785 | 178785 | 125565 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1907 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5999924.7797300005 | 2115560.6496599996 | 37.7889205779801 | -122.44410362179501 | (37.7889205779801, -122.444103621795) | |||
77285 | 77285 | 221965 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 4001 20th St | 5 | : Yard 23 | Tree 1 | Private 1 | 4 | Width 3ft | 6003646.65326 | 2104187.9271299997 | 37.7579054957544 | -122.43041468480699 | (37.7579054957544, -122.430414684807) | |||
14129 | 14129 | 94615 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1700X Bancroft Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 6 | Permit Number 53777 | 6013900.00533 | 2092534.6262599998 | 37.7264834469268 | -122.39413819274598 | (37.7264834469268, -122.394138192746) | ||
52111 | 52111 | 203610 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 146 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992962.70532 | 2101209.82571 | 37.7491174052506 | -122.467147429924 | (37.7491174052506, -122.467147429924) | |||
76641 | 76641 | 47443 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 651 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 6 | Permit Number 45354 | 5982552.26402 | 2111341.47096 | 37.776329586414796 | -122.503896547887 | (37.7763295864148, -122.503896547887) | |
160726 | 160726 | 37181 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2519 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | 7 | Permit Number 39755 | 6001865.38269 | 2116985.0366700003 | 37.792942091651796 | -122.437491453568 | (37.7929420916518, -122.437491453568) | ||
187046 | 187046 | 203611 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 146 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992953.888809999 | 2101207.94105 | 37.7491117215315 | -122.467177780245 | (37.7491117215315, -122.467177780245) | |||
42665 | 42665 | 203612 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1675 15th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5991397.55944 | 2103884.0392299998 | 37.7563696263767 | -122.472754630933 | (37.7563696263767, -122.472754630933) | |||
68151 | 68151 | 203613 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1762 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5991879.53156 | 2103437.46302 | 37.755171333717 | -122.471055286375 | (37.755171333717, -122.471055286375) | |||
107231 | 107231 | 93572 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 757 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2010 12:00:00 AM | 14 | Permit Number 53252 | 5994718.18671 | 2110428.47346 | 37.7745306031117 | -122.46174532831002 | (37.7745306031117, -122.46174532831) | ||
15094 | 15094 | 52153 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 525 Phelps St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 15 | 5x9 | Permit Number 48345 | 6015376.330519999 | 2098074.72194 | 37.7417773752369 | -122.38942127378701 | (37.7417773752369, -122.389421273787) |
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");