Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
qLegalStatus ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25301 | 25301 | 190759 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 960 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6011851.68946 | 2103937.20655 | 37.757678438529894 | -122.40202042759701 | (37.7576784385299, -122.402020427597) | |||
26634 | 26634 | 190806 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1924 22nd St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012287.449569999 | 2103786.76177 | 37.7572896615996 | -122.400502813555 | (37.7572896615996, -122.400502813555) | |||
27573 | 27573 | 249744 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 28 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000231.5353 | 2117259.0230400003 | 37.793601361269396 | -122.44316431948799 | (37.7936013612694, -122.443164319488) | |||
32459 | 32459 | 249756 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 40 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6000240.43697 | 2117209.2145 | 37.7934651076862 | -122.443129940195 | (37.7934651076862, -122.443129940195) | |||
37637 | 37637 | 129196 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6001591.38038 | 2120905.5251 | 37.8036911413025 | -122.438720569603 | (37.8036911413025, -122.438720569603) | |||
37997 | 37997 | 249753 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 37 | : 4 | Tree 1 | Private 1 | 7 | Width 1ft | 6000238.5689199995 | 2117223.4057 | 37.793503966475 | -122.44313742344801 | (37.793503966475, -122.443137423448) | |||
39030 | 39030 | 249749 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 33 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6000235.88036 | 2117238.71283 | 37.7935458425285 | -122.44314782591299 | (37.7935458425285, -122.443147825913) | |||
40060 | 40060 | 226881 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 14 Liberty St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 1ft | 6006207.80682 | 2104080.83219 | 37.757756184028395 | -122.42154951882 | (37.7577561840284, -122.42154951882) | |||
40469 | 40469 | 249747 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 31 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000233.56128 | 2117245.74106 | 37.793565007967 | -122.44315635509399 | (37.793565007967, -122.443156355094) | |||
45160 | 45160 | 226880 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1850 Bryant St | 3 | : 4 | Tree 1 | Private 1 | 25 | Width 2ft | 6009467.77548 | 2106133.6543799997 | 37.7635760441104 | -122.41042010180901 | (37.7635760441104, -122.410420101809) | |||
45702 | 45702 | 129197 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6001606.6144900005 | 2120894.2374 | 37.8036610149183 | -122.43866704197501 | (37.8036610149183, -122.438667041975) | |||
46421 | 46421 | 246622 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 37 Norwich St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6009131.1615699995 | 2099436.16764 | 37.7451673750763 | -122.411111235306 | (37.7451673750763, -122.411111235306) | |||
46543 | 46543 | 249746 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 30 | : 4 | Tree 1 | Private 1 | 4 | Width 1ft | 6000233.18821 | 2117249.22853 | 37.7935745623699 | -122.44315789653 | (37.7935745623699, -122.44315789653) | |||
49386 | 49386 | 249751 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 35 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6000236.78022 | 2117230.8297200003 | 37.793524248891295 | -122.443144145909 | (37.7935242488913, -122.443144145909) | |||
51537 | 51537 | 190761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 285 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 21 | Width 3ft | 6013218.562419999 | 2105774.14575 | 37.762798465109995 | -122.397422010521 | (37.76279846511, -122.397422010521) | |||
52094 | 52094 | 249755 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 39 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6000239.615259999 | 2117214.478 | 37.79347951302 | -122.443133161562 | (37.79347951302, -122.443133161562) | |||
52600 | 52600 | 190813 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 870 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6013034.16138 | 2103011.82985 | 37.755203481775105 | -122.39786601663 | (37.7552034817751, -122.39786601663) | |||
52652 | 52652 | 226879 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1850 Bryant St | 2 | : 4 | Tree 1 | Private 1 | 25 | Width 2ft | 6009465.88714 | 2106164.02417 | 37.7636593267514 | -122.41042877757201 | (37.7636593267514, -122.410428777572) | |||
57199 | 57199 | 190807 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1950 22nd St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 6012259.17788 | 2103783.2795599997 | 37.7572785235114 | -122.400600344128 | (37.7572785235114, -122.400600344128) | |||
58583 | 58583 | 226874 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 7 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009580.43955 | 2105432.84678 | 37.7616581013669 | -122.409980954769 | (37.7616581013669, -122.409980954769) | |||
59064 | 59064 | 129190 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3725 Scott St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6000610.9168300005 | 2121141.44631 | 37.8042830912635 | -122.44213045078699 | (37.8042830912635, -122.442130450787) | |||
59101 | 59101 | 129187 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3445 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5999729.19027 | 2120417.1315599997 | 37.8022440296095 | -122.44512962056001 | (37.8022440296095, -122.44512962056) | |||
59790 | 59790 | 129202 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1425 Jefferson St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 2ft | 6002378.47119 | 2121561.31201 | 37.8055365042628 | -122.436043759126 | (37.8055365042628, -122.436043759126) | |||
62997 | 62997 | 249752 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 36 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000236.97181 | 2117227.13869 | 37.7935141252181 | -122.44314321778299 | (37.7935141252181, -122.443143217783) | |||
65018 | 65018 | 249759 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 43 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000241.634269999 | 2117194.01368 | 37.7934234385005 | -122.443124705245 | (37.7934234385005, -122.443124705245) | |||
65634 | 65634 | 129199 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3688 Fillmore St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6002142.29562 | 2121107.7471 | 37.8042777151067 | -122.436828586663 | (37.8042777151067, -122.436828586663) | |||
66764 | 66764 | 226871 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6009582.6933699995 | 2105397.44165 | 37.761561013249 | -122.409970660215 | (37.761561013249, -122.409970660215) | |||
67332 | 67332 | 249758 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 42 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000240.94884 | 2117198.36774 | 37.793435354521996 | -122.44312738972602 | (37.793435354522, -122.443127389726) | |||
67422 | 67422 | 250323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 179 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987396.03432 | 2114802.15795 | 37.7861152804279 | -122.48739508214399 | (37.7861152804279, -122.487395082144) | |||
68529 | 68529 | 176622 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 28 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6009222.269090001 | 2086479.6741900002 | 37.7095966978914 | -122.409881764928 | (37.7095966978914, -122.409881764928) | |||
70038 | 70038 | 249762 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 46 | : 4 | Tree 1 | Private 1 | 20 | Width 1ft | 6000243.900669999 | 2117182.35848 | 37.7933915656126 | -122.443116025908 | (37.7933915656126, -122.443116025908) | |||
70401 | 70401 | 250324 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 179 27th Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987396.8518 | 2114775.1083299997 | 37.7860410575969 | -122.487390266267 | (37.7860410575969, -122.487390266267) | |||
75263 | 75263 | 202046 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 47 Exeter St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012581.44921 | 2090990.21223 | 37.722169424252 | -122.398588087695 | (37.722169424252, -122.398588087695) | |||
130192 | 130192 | 249743 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 27 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000230.51867 | 2117262.97292 | 37.793612148632704 | -122.443168120916 | (37.7936121486327, -122.443168120916) | |||
130684 | 130684 | 190802 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 625 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6011842.77301 | 2105367.13187 | 37.7616041987086 | -122.402151793375 | (37.7616041987086, -122.402151793375) | |||
135341 | 135341 | 129188 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3445 Broderick St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5999731.06738 | 2120400.48948 | 37.80219844206879 | -122.44512192772899 | (37.8021984420688, -122.445121927729) | |||
136197 | 136197 | 249748 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 32 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 6000234.88856 | 2117241.71857 | 37.7935540389482 | -122.443151473582 | (37.7935540389482, -122.443151473582) | |||
136796 | 136796 | 176621 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 20 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6009241.33314 | 2086520.9311099998 | 37.7097110493951 | -122.40981878630801 | (37.7097110493951, -122.409818786308) | |||
138184 | 138184 | 249761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 45 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6000243.02333 | 2117185.9818700003 | 37.793401464464395 | -122.443119321906 | (37.7934014644644, -122.443119321906) | |||
148834 | 148834 | 249750 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 34 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000235.93718 | 2117235.57911 | 37.7935372413976 | -122.443147404144 | (37.7935372413976, -122.443147404144) | |||
149561 | 149561 | 249609 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2310 Golden Gate Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 5998473.33255 | 2111438.47015 | 37.7775192428532 | -122.448828371134 | (37.7775192428532, -122.448828371134) | |||
150183 | 150183 | 226872 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6009582.03352 | 2105410.0194900003 | 37.76159551215571 | -122.40997383032499 | (37.7615955121557, -122.409973830325) | |||
151827 | 151827 | 129189 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3725 Scott St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 2ft | 6000608.31446 | 2121159.56549 | 37.8043326933704 | -122.44214075790701 | (37.8043326933704, -122.442140757907) | |||
153878 | 153878 | 249760 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 44 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6000241.7862599995 | 2117189.5298599997 | 37.7934111357761 | -122.44312385717699 | (37.7934111357761, -122.443123857177) | |||
154750 | 154750 | 226839 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 14 Liberty St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6006174.93663 | 2104077.42455 | 37.7577449739746 | -122.421662955682 | (37.7577449739746, -122.421662955682) | |||
159125 | 159125 | 190803 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 960 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6011852.27614 | 2103926.33475 | 37.757648619711496 | -122.402017634333 | (37.7576486197115, -122.402017634333) | |||
159833 | 159833 | 246621 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 37 Norwich St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6009124.596609999 | 2099436.39802 | 37.745167639486 | -122.41113395216499 | (37.745167639486, -122.411133952165) | |||
160956 | 160956 | 190804 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 960 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6011852.706069999 | 2103917.67826 | 37.7576248748965 | -122.402015538912 | (37.7576248748965, -122.402015538912) | |||
164147 | 164147 | 129198 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3537 Fillmore St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6002132.11244 | 2120360.66499 | 37.8022258462139 | -122.436810313348 | (37.8022258462139, -122.436810313348) | |||
166326 | 166326 | 226838 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 14 Liberty St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 1ft | 6006187.259459999 | 2104078.53237 | 37.757748710656706 | -122.42162041686001 | (37.7577487106567, -122.42162041686) | |||
167115 | 167115 | 226854 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1306 York St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6010039.207119999 | 2101569.82479 | 37.7510768094609 | -122.40812180518 | (37.7510768094609, -122.40812180518) | |||
167156 | 167156 | 190805 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1924 22nd St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012299.62421 | 2103787.4473 | 37.7572922228659 | -122.400460756771 | (37.7572922228659, -122.400460756771) | |||
167799 | 167799 | 226873 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 6 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009581.91025 | 2105420.85963 | 37.7616252698063 | -122.409975021942 | (37.7616252698063, -122.409975021942) | |||
171067 | 171067 | 226876 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2799 18th St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009598.28938 | 2105442.85727 | 37.7616865882978 | -122.409919925863 | (37.7616865882978, -122.409919925863) | |||
171556 | 171556 | 226869 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009583.3453 | 2105371.1765099997 | 37.761488931684 | -122.40996655123101 | (37.761488931684, -122.409966551231) | |||
173393 | 173393 | 249754 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 38 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000238.64594 | 2117219.3423599997 | 37.7934928140037 | -122.443136864991 | (37.7934928140037, -122.443136864991) | |||
174994 | 174994 | 249763 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 47 | : 4 | Tree 1 | Private 1 | 21 | Width 1ft | 6000244.96871 | 2117178.7308099996 | 37.7933816658824 | -122.443112069768 | (37.7933816658824, -122.443112069768) | |||
176649 | 176649 | 129200 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3688 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 1ft | 6002139.18705 | 2121127.02263 | 37.8043304639385 | -122.436840724815 | (37.8043304639385, -122.436840724815) | |||
178683 | 178683 | 226877 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2799 18th St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009607.1639 | 2105442.92865 | 37.761687281655604 | -122.409889237391 | (37.7616872816556, -122.409889237391) | |||
180297 | 180297 | 226868 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6009583.77796 | 2105356.60211 | 37.7614489379435 | -122.40996402594 | (37.7614489379435, -122.40996402594) | |||
181444 | 181444 | 190801 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 625 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6011843.82819 | 2105357.07787 | 37.761576651560205 | -122.402147437048 | (37.7615766515602, -122.402147437048) | |||
182870 | 182870 | 249757 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 41 | : 4 | Tree 1 | Private 1 | 11 | Width 1ft | 6000240.78319 | 2117204.07092 | 37.7934510045092 | -122.443128372672 | (37.7934510045092, -122.443128372672) | |||
183490 | 183490 | 226870 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2001 Bryant St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009582.96211 | 2105385.4738 | 37.7615281673157 | -122.409968885865 | (37.7615281673157, -122.409968885865) | |||
183940 | 183940 | 226878 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2799 18th St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6009615.15158 | 2105443.0181400003 | 37.7616879750304 | -122.409861617432 | (37.7616879750304, -122.409861617432) | |||
184505 | 184505 | 249764 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 48 | : 4 | Tree 1 | Private 1 | 23 | Width 1ft | 6000246.04856 | 2117175.67215 | 37.7933733291772 | -122.44310811365101 | (37.7933733291772, -122.443108113651) | |||
186571 | 186571 | 129120 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002190.78069 | 2120762.93266 | 37.803333701254296 | -122.43663610388201 | (37.8033337012543, -122.436636103882) | |||
186808 | 186808 | 249745 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2500 Broderick St | 29 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6000232.829030001 | 2117254.6491400003 | 37.793589425458606 | -122.44315952880899 | (37.7935894254586, -122.443159528809) | |||
187761 | 187761 | 226875 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2799 18th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6009589.19178 | 2105442.78683 | 37.7616858850104 | -122.409951385948 | (37.7616858850104, -122.409951385948) |
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");