Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28139 | 28139 | 247240 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 921 Buena Vista Ave West | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6000040.78347 | 2108630.8128400003 | 37.7698996387736 | -122.443204350999 | (37.7698996387736, -122.443204350999) | |||
31272 | 31272 | 246733 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Ripley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008547.21994 | 2099053.14495 | 37.7440829149855 | -122.413103333461 | (37.7440829149855, -122.413103333461) | |||
32340 | 32340 | 205339 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 331 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992450.822319999 | 2090054.7824900001 | 37.7184588853561 | -122.468106177376 | (37.7184588853561, -122.468106177376) | |||
34044 | 34044 | 247690 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 Central Ave | 5 | : 4 | Tree 1 | Private 1 | 21 | Width 4ft | 5999997.25349 | 2108406.91621 | 37.76928239269029 | -122.44333883563299 | (37.7692823926903, -122.443338835633) | |||
34332 | 34332 | 189296 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 621 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6011838.19125 | 2105389.54808 | 37.7616654928887 | -122.402169215947 | (37.7616654928887, -122.402169215947) | |||
41128 | 41128 | 247681 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 969 Buena Vista Ave West | 8 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 5999993.429380001 | 2108726.41685 | 37.7701594430376 | -122.443375015343 | (37.7701594430376, -122.443375015343) | |||
41235 | 41235 | 247678 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 969 Buena Vista Ave West | 5 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6000000.32593 | 2108756.30606 | 37.770241904566205 | -122.44335330750401 | (37.7702419045662, -122.443353307504) | |||
43002 | 43002 | 249419 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 730 Eddy St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6006909.7842 | 2113298.36761 | 37.783104905109404 | -122.419775815624 | (37.7831049051094, -122.419775815624) | |||
43289 | 43289 | 247682 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 969 Buena Vista Ave West | 9 | : 4 | Tree 1 | Private 1 | 22 | Width 4ft | 6000006.57165 | 2108721.28332 | 37.770146097098795 | -122.443329187717 | (37.7701460970988, -122.443329187717) | |||
44215 | 44215 | 247691 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 Central Ave | 6 | : 4 | Tree 1 | Private 1 | 22 | Width 4ft | 5999995.4075 | 2108418.75948 | 37.7693148060665 | -122.44334607158599 | (37.7693148060665, -122.443346071586) | |||
46880 | 46880 | 247686 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 935 Buena Vista Ave West | 4 | : 4 | Tree 1 | Private 1 | 22 | Width 4ft | 6000019.72764 | 2108674.83291 | 37.7700193061664 | -122.443280344631 | (37.7700193061664, -122.443280344631) | |||
47620 | 47620 | 247689 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 Central Ave | 4 | : 4 | Tree 1 | Private 1 | 24 | Width 4ft | 5999999.2126 | 2108392.11953 | 37.7692418764422 | -122.443330996248 | (37.7692418764422, -122.443330996248) | |||
47712 | 47712 | 247688 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 Central Ave | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6000001.523569999 | 2108377.48913 | 37.769201836821 | -122.443321951756 | (37.769201836821, -122.443321951756) | |||
48237 | 48237 | 205333 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 10 Caine Ave | 15 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5997549.343280001 | 2089570.2528799998 | 37.717421611803495 | -122.45044787838002 | (37.7174216118035, -122.45044787838) | |||
49464 | 49464 | 247675 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 969 Buena Vista Ave West | 2 | : 4 | Tree 1 | Private 1 | 21 | Width 4ft | 5999994.72677 | 2108788.88509 | 37.7703310390855 | -122.443375015355 | (37.7703310390855, -122.443375015355) | |||
50856 | 50856 | 189311 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1763 Revere Ave | 2 | : 4 | Tree 1 | Private 1 | 19 | Width 3ft | 6014243.98109 | 2094996.62918 | 37.733262720903504 | -122.393121267238 | (37.7332627209035, -122.393121267238) | |||
53735 | 53735 | 205341 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1400 Holloway Ave | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5990799.697869999 | 2091134.9811 | 37.7213293495637 | -122.47389213663 | (37.7213293495637, -122.47389213663) | |||
55394 | 55394 | 175880 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6008040.572369999 | 2086224.4613400002 | 37.7088296382554 | -122.413947884988 | (37.7088296382554, -122.413947884988) | |||
56872 | 56872 | 247680 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 969 Buena Vista Ave West | 7 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6000003.68623 | 2108741.82746 | 37.7702023415965 | -122.44334064416901 | (37.7702023415965, -122.443340644169) | |||
57129 | 57129 | 175878 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6008044.64173 | 2086236.91355 | 37.7088640580086 | -122.413934700952 | (37.7088640580086, -122.413934700952) | |||
58296 | 58296 | 247677 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 969 Buena Vista Ave West | 4 | : 4 | Tree 1 | Private 1 | 24 | Width 4ft | 5999999.41375 | 2108762.74792 | 37.7702595402749 | -122.44335692549299 | (37.7702595402749, -122.443356925493) | |||
59015 | 59015 | 205342 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 300 Junipero Serra Blvd | 16 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991388.30508 | 2094512.6918400002 | 37.7306377788136 | -122.47210358291001 | (37.7306377788136, -122.47210358291) | |||
62525 | 62525 | 126096 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3630 Webster St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002623.69745 | 2121110.92365 | 37.8043137851175 | -122.43516288665899 | (37.8043137851175, -122.435162886659) | |||
62757 | 62757 | 189312 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1784 Revere Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6014126.96822 | 2095142.52205 | 37.733656811898 | -122.393536022869 | (37.733656811898, -122.393536022869) | |||
68254 | 68254 | 189281 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 975 Minna St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008056.3994 | 2110189.2113 | 37.7746324316857 | -122.415588777222 | (37.7746324316857, -122.415588777222) | |||
70863 | 70863 | 247687 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 Central Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6000002.20037 | 2108368.10077 | 37.769176097336604 | -122.44331893632601 | (37.7691760973366, -122.443318936326) | |||
72000 | 72000 | 205343 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 300 Junipero Serra Blvd | 33 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5991382.87064 | 2094419.86575 | 37.730382587164605 | -122.472115606868 | (37.7303825871646, -122.472115606868) | |||
73817 | 73817 | 126076 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3099 Baker St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5999384.46531 | 2119405.9114599996 | 37.799447808926395 | -122.446249747728 | (37.7994478089264, -122.446249747728) | |||
75765 | 75765 | 189297 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1458 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6011987.51457 | 2101577.28204 | 37.7512061823217 | -122.40138484163602 | (37.7512061823217, -122.401384841636) | |||
76540 | 76540 | 126077 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3099 Baker St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5999388.2562 | 2119380.27509 | 37.7993776348198 | -122.44623478482299 | (37.7993776348198, -122.446234784823) | |||
130235 | 130235 | 126086 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3747 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6000116.67456 | 2121159.0969700003 | 37.8043033763715 | -122.443842079173 | (37.8043033763715, -122.443842079173) | |||
130646 | 130646 | 202072 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Gould St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012663.72375 | 2090703.30788 | 37.7213862262721 | -122.39828356286101 | (37.7213862262721, -122.398283562861) | |||
130989 | 130989 | 246735 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Ripley St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008576.96579 | 2099053.87477 | 37.744086588741396 | -122.413000530175 | (37.7440865887414, -122.413000530175) | |||
132770 | 132770 | 247683 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 935 Buena Vista Ave West | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6000009.45593 | 2108709.0713 | 37.7701127304395 | -122.443318333778 | (37.7701127304395, -122.443318333778) | |||
134986 | 134986 | 247693 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 Central Ave | 8 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 5999992.61936 | 2108443.98924 | 37.769383921653294 | -122.443357528041 | (37.7693839216533, -122.443357528041) | |||
137200 | 137200 | 246927 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 357 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5998272.3562 | 2107533.69147 | 37.766786226335704 | -122.449242222052 | (37.7667862263357, -122.449242222052) | |||
138010 | 138010 | 245487 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 326 San Jose Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6006168.867740001 | 2101142.03108 | 37.7496847182974 | -122.42147547943001 | (37.7496847182974, -122.42147547943) | |||
147575 | 147575 | 202036 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 74 Crane St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6012239.5705 | 2090921.68995 | 37.721962223161896 | -122.399765078106 | (37.7219622231619, -122.399765078106) | |||
148847 | 148847 | 126085 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3747 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6000116.56752 | 2121160.52429 | 37.8043072893028 | -122.443842552202 | (37.8043072893028, -122.443842552202) | |||
151133 | 151133 | 126087 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3747 Divisadero St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6000117.09871 | 2121156.78395 | 37.804297049633895 | -122.443840445091 | (37.8042970496339, -122.443840445091) | |||
154303 | 154303 | 175879 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6008041.81725 | 2086229.374 | 37.708843197325 | -122.41394392978701 | (37.708843197325, -122.413943929787) | |||
154653 | 154653 | 247237 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 923 Buena Vista Ave West | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6000029.9176199995 | 2108654.05945 | 37.769962848530604 | -122.44324360552 | (37.7699628485306, -122.44324360552) | |||
155610 | 155610 | 247238 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 923 Buena Vista Ave West | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6000033.92777 | 2108644.76792 | 37.7699375649926 | -122.443229067086 | (37.7699375649926, -122.443229067086) | |||
155824 | 155824 | 245493 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1306 York St | 5 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6010040.7656 | 2101553.84202 | 37.7510330115737 | -122.408115288704 | (37.7510330115737, -122.408115288704) | |||
155954 | 155954 | 247241 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 921 Buena Vista Ave West | 2 | : 4 | Tree 1 | Private 1 | 27 | Width 3ft | 6000047.51607 | 2108621.04619 | 37.769873205905796 | -122.443180361598 | (37.7698732059058, -122.443180361598) | |||
157206 | 157206 | 247802 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 464 30th St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6003596.41299 | 2098374.599 | 37.7419406120734 | -122.43017371776001 | (37.7419406120734, -122.43017371776) | |||
157455 | 157455 | 246734 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Ripley St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008557.46884 | 2099053.26982 | 37.7440838331996 | -122.41306790375299 | (37.7440838331996, -122.413067903753) | |||
158991 | 158991 | 247679 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 969 Buena Vista Ave West | 6 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6000001.9279 | 2108749.50236 | 37.7702233146713 | -122.443347277551 | (37.7702233146713, -122.443347277551) | |||
161433 | 161433 | 247558 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 Central Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6000004.98799 | 2108349.4174099998 | 37.7691249564843 | -122.44330795200199 | (37.7691249564843, -122.443307952002) | |||
162195 | 162195 | 247692 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 Central Ave | 7 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 5999993.8992099995 | 2108430.0746299997 | 37.7693457886147 | -122.44335210152201 | (37.7693457886147, -122.443352101522) | |||
162732 | 162732 | 126095 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3630 Webster St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002627.04146 | 2121100.74155 | 37.8042860176436 | -122.435150585742 | (37.8042860176436, -122.435150585742) | |||
164662 | 164662 | 246506 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 251 Duncan St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 5ft | 6004876.605930001 | 2099863.49377 | 37.7461012023225 | -122.42585317680599 | (37.7461012023225, -122.425853176806) | |||
168572 | 168572 | 247684 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 935 Buena Vista Ave West | 2 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6000012.39067 | 2108699.28919 | 37.7700860385779 | -122.44330747986601 | (37.7700860385779, -122.443307479866) | |||
170834 | 170834 | 247676 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 969 Buena Vista Ave West | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 5999996.82032 | 2108772.17609 | 37.7702852797644 | -122.443366573435 | (37.7702852797644, -122.443366573435) | |||
174387 | 174387 | 245486 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 326 San Jose Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006168.67075 | 2101144.6213 | 37.749691819342104 | -122.421476344562 | (37.7496918193421, -122.421476344562) | |||
174715 | 174715 | 202071 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Gould St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012673.40671 | 2090736.3897900002 | 37.7214776018863 | -122.398252411218 | (37.7214776018863, -122.398252411218) | |||
176293 | 176293 | 126098 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1639 Beach St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6002372.64115 | 2121214.12462 | 37.8045828883414 | -122.436039075449 | (37.8045828883414, -122.436039075449) | |||
176962 | 176962 | 175882 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008037.77895 | 2086218.44055 | 37.708812949517394 | -122.413957113834 | (37.7088129495174, -122.413957113834) | |||
177238 | 177238 | 247674 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 969 Buena Vista Ave West | 1 | : 4 | Tree 1 | Private 1 | 21 | Width 4ft | 5999993.189669999 | 2108798.81177 | 37.770358207594704 | -122.443381045292 | (37.7703582075947, -122.443381045292) | |||
177429 | 177429 | 189298 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1470 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6011992.06191 | 2101527.33948 | 37.751069304619605 | -122.40136560696199 | (37.7510693046196, -122.401365606962) | |||
179124 | 179124 | 175881 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 4 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6008040.46364 | 2086219.1455 | 37.7088150359462 | -122.413947884982 | (37.7088150359462, -122.413947884982) | |||
182981 | 182981 | 189306 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 499 Texas St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013832.17688 | 2104822.60916 | 37.7602198992576 | -122.395233060671 | (37.7602198992576, -122.395233060671) | |||
183564 | 183564 | 245599 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 193 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 8ft | 5997474.2586 | 2104104.13255 | 37.7573238430432 | -122.451755267793 | (37.7573238430432, -122.451755267793) | |||
185670 | 185670 | 247668 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6001938.070180001 | 2108499.86475 | 37.7696480903062 | -122.436632313225 | (37.7696480903062, -122.436632313225) | |||
186822 | 186822 | 247685 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 935 Buena Vista Ave West | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6000015.9145599995 | 2108684.2864099997 | 37.7700450456643 | -122.443294213074 | (37.7700450456643, -122.443294213074) | |||
187215 | 187215 | 189310 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1763 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6014232.27573 | 2095006.1382799998 | 37.7332881806876 | -122.393162401334 | (37.7332881806876, -122.393162401334) | |||
187399 | 187399 | 205334 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 73 Margaret Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997009.746259999 | 2089680.74953 | 37.7176941117806 | -122.452320974643 | (37.7176941117806, -122.452320974643) | |||
188530 | 188530 | 126099 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1639 Beach St | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 6ft | 6002384.275669999 | 2121216.1923599998 | 37.8045892267643 | -122.435998961207 | (37.8045892267643, -122.435998961207) |
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");