Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCareAssistant, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3364 | 3364 | 188226 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 3 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 6 | Width 3ft | Permit Number 37286 | 6013575.41694 | 2105253.06849 | 37.7613875637091 | -122.396151246903 | (37.7613875637091, -122.396151246903) | |
10629 | 10629 | 108781 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005591.90568 | 2088038.18998 | 37.7136719236049 | -122.422539619323 | (37.7136719236049, -122.422539619323) |
22089 | 22089 | 29358 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991885.18 | 2096342.85411 | 37.735691686328295 | -122.470519069219 | (37.7356916863283, -122.470519069219) | ||
22943 | 22943 | 115613 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
24588 | 24588 | 125698 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2107 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5999370.9628800005 | 2116081.41447 | 37.7903188519859 | -122.446057218191 | (37.7903188519859, -122.446057218191) | |||
29668 | 29668 | 205564 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1570 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994021.91378 | 2104924.9541599997 | 37.7593792795413 | -122.46375431661501 | (37.7593792795413, -122.463754316615) | |||
30971 | 30971 | 188230 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 123 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012869.68369 | 2113682.0678 | 37.784492396237 | -122.39918379321001 | (37.784492396237, -122.39918379321) | |||
31054 | 31054 | 205576 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993987.58227 | 2096991.7389900002 | 37.737594705717896 | -122.463297378285 | (37.7375947057179, -122.463297378285) | |||
31995 | 31995 | 204340 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 102 San Ramon Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5995780.03889 | 2092724.36521 | 37.7259806323898 | -122.456791497325 | (37.7259806323898, -122.456791497325) | |||
33243 | 33243 | 204317 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Merced Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994559.82289 | 2099500.03958 | 37.7445148251981 | -122.461500679435 | (37.7445148251981, -122.461500679435) | |||
38063 | 38063 | 185803 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2614 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5986857.6825 | 2101684.1029 | 37.750065347280895 | -122.488293237257 | (37.7500653472809, -122.488293237257) | |||
38652 | 38652 | 204326 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 201 Magellan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5995034.06083 | 2100651.9514 | 37.747704971418 | -122.45994430098699 | (37.747704971418, -122.459944300987) | |||
41287 | 41287 | 205601 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 404 Baden St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6000770.98031 | 2095275.60302 | 37.7332710603101 | -122.43972100331699 | (37.7332710603101, -122.439721003317) | ||||
41519 | 41519 | 204289 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5992459.80825 | 2103811.38116 | 37.7562315606514 | -122.46907574904499 | (37.7562315606514, -122.469075749045) | |||
44018 | 44018 | 205537 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 351 Montecito Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5995962.698480001 | 2094090.23289 | 37.7297414640913 | -122.45625877314698 | (37.7297414640913, -122.456258773147) | |||
44247 | 44247 | 204234 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1315 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993917.53437 | 2106478.71882 | 37.7636394975886 | -122.464228110963 | (37.7636394975886, -122.464228110963) | |||
45487 | 45487 | 221132 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2820 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008864.30785 | 2106343.82537 | 37.764119276915295 | -122.41252217085699 | (37.7641192769153, -122.412522170857) | |||
46153 | 46153 | 221125 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 229 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6009787.17662 | 2099559.77195 | 37.745543532705604 | -122.408851557364 | (37.7455435327056, -122.408851557364) | |||
48243 | 48243 | 205579 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993994.26166 | 2096934.2401 | 37.737437212859795 | -122.463270113518 | (37.7374372128598, -122.463270113518) | |||
49732 | 49732 | 204271 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 347 Parnassus Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 5996376.07988 | 2106550.6126099997 | 37.7639782982901 | -122.455730018544 | (37.7639782982901, -122.455730018544) | |||
50526 | 50526 | 72443 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1069 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 11 | 6008813.774540001 | 2115937.32557 | 37.790457920444005 | -122.413375446746 | (37.790457920444, -122.413375446746) | ||
51734 | 51734 | 204241 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2584 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5992089.60878 | 2097889.18695 | 37.739949343996 | -122.469924838577 | (37.739949343996, -122.469924838577) | |||
52720 | 52720 | 205534 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 521 Wildwood Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994800.3358 | 2093311.73855 | 37.7275371142415 | -122.460220780477 | (37.7275371142415, -122.460220780477) | |||
53922 | 53922 | 221100 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6009350.253169999 | 2105434.72135 | 37.7616503447144 | -122.41077721180599 | (37.7616503447144, -122.410777211806) | |||
56258 | 56258 | 205603 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 845 Detroit St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999427.00683 | 2095718.88382 | 37.7344116156036 | -122.44439931797501 | (37.7344116156036, -122.444399317975) | |||
57169 | 57169 | 221130 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 825 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007982.122380001 | 2102911.62209 | 37.754645686273996 | -122.415330414592 | (37.754645686274, -122.415330414592) | |||
57759 | 57759 | 52679 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984569.7272 | 2111052.9985 | 37.77565594760279 | -122.49689639188101 | (37.7756559476028, -122.496896391881) | ||
63357 | 63357 | 205567 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 7 Locksley Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994181.5204 | 2105002.6453 | 37.759601795201704 | -122.463207960474 | (37.7596017952017, -122.463207960474) | |||
65595 | 65595 | 205524 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 141 Greenwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995982.8575 | 2093718.26393 | 37.7287212839559 | -122.456162198553 | (37.7287212839559, -122.456162198553) | |||
66094 | 66094 | 204267 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992346.7328699995 | 2104590.8969900003 | 37.7583653730678 | -122.469523541303 | (37.7583653730678, -122.469523541303) | |||
67242 | 67242 | 246811 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 161 Brewster St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6010262.216659999 | 2098999.82172 | 37.7440326285028 | -122.40716947078998 | (37.7440326285028, -122.40716947079) | |||
76957 | 76957 | 204251 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996289.61918 | 2089877.93605 | 37.7181942580441 | -122.454824354468 | (37.7181942580441, -122.454824354468) | |||
80760 | 80760 | 122457 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1355x 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013550.0 | 2105274.0 | 37.7614436228031 | -122.39624062117399 | (37.7614436228031, -122.396240621174) | ||||
82779 | 82779 | 40744 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 40 Cedro Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41719 | 5992588.05334035 | 2093209.10678957 | 37.7271278125133 | -122.46786112953899 | (37.7271278125133, -122.467861129539) | ||
84436 | 84436 | 40478 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41556 | 5996299.47149878 | 2089867.48348074 | 37.7181661228901 | -122.454789544621 | (37.7181661228901, -122.454789544621) | ||
85829 | 85829 | 40748 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 Cedro Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41720 | 5992465.74581598 | 2093166.10361938 | 37.7270026730351 | -122.46828081444599 | (37.7270026730351, -122.468280814446) | ||
91552 | 91552 | 112669 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500x LAIDLEY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003128.0 | 2096056.0 | 37.7355477305103 | -122.43162784146999 | (37.7355477305103, -122.43162784147) | ||||
94020 | 94020 | 104295 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3665X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999151.92915 | 2121319.46506 | 37.8046886279394 | -122.44719219431002 | (37.8046886279394, -122.44719219431) | ||||
96908 | 96908 | 113825 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1599x CASTRO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/10/2015 12:00:00 AM | 8 | 3x3 | 6002577.0 | 2101074.0 | 37.749294743689795 | -122.433891418078 | (37.7492947436898, -122.433891418078) | |
102496 | 102496 | 33400 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 333 Santa Ana Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41597 | 5992649.0 | 2094625.0 | 37.7310190240744 | -122.46775337202101 | (37.7310190240744, -122.467753372021) | ||
111989 | 111989 | 40758 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 60 De Soto St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41725 | 5993077.65625848 | 2091558.66043318 | 37.722624350413795 | -122.46604871174499 | (37.7226243504138, -122.466048711745) | ||
118818 | 118818 | 107004 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
126856 | 126856 | 98969 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 825 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
130310 | 130310 | 125702 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1170 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009077.34196 | 2117044.73858 | 37.7935134012698 | -122.41254183184799 | (37.7935134012698, -122.412541831848) | |||
131785 | 131785 | 205539 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 300 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5996016.59596 | 2094154.09063 | 37.7299198958858 | -122.456077059703 | (37.7299198958858, -122.456077059703) | |||
138773 | 138773 | 205568 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 6 Locksley Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5994301.6681 | 2105012.30737 | 37.7596352454884 | -122.462793133809 | (37.7596352454884, -122.462793133809) | |||
140544 | 140544 | 52244 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1550 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48413 | 6013439.04799366 | 2103846.48755141 | 37.7575178110179 | -122.396524293417 | (37.7575178110179, -122.396524293417) | |||
145440 | 145440 | 244151 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 403 Rose St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004595.5153 | 2109633.7909 | 37.772912235932004 | -122.427521090443 | (37.772912235932, -122.427521090443) | |||
147400 | 147400 | 204262 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992421.48169 | 2104887.89672 | 37.7591851761784 | -122.469286646366 | (37.7591851761784, -122.469286646366) | |||
155939 | 155939 | 205607 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 549 Joost Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998498.386580001 | 2094968.0137599998 | 37.7322968768869 | -122.447555816948 | (37.7322968768869, -122.447555816948) | |||
156387 | 156387 | 221165 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1511 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002609.85714 | 2101016.35214 | 37.7491383207878 | -122.433773677812 | (37.7491383207878, -122.433773677812) | |||
158263 | 158263 | 204332 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 351 Kenwood Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993583.80688 | 2093600.7249900002 | 37.7282605495865 | -122.464447270321 | (37.7282605495865, -122.464447270321) | |||
161057 | 161057 | 205573 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 114 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993978.105 | 2097062.9530599997 | 37.7377896958481 | -122.46333531168399 | (37.7377896958481, -122.463335311684) | |||
162837 | 162837 | 204306 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Forest Side Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992602.3256 | 2098798.4802200003 | 37.7424756574394 | -122.46821822299201 | (37.7424756574394, -122.468218222992) | |||
165366 | 165366 | 205592 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 30 Vasquez Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5995689.638259999 | 2100080.55801 | 37.7461737497157 | -122.457636027276 | (37.7461737497157, -122.457636027276) | |||
167069 | 167069 | 187480 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1888 Geneva Ave | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004820.44605 | 2086842.7727 | 37.710346011228104 | -122.42512105938299 | (37.7103460112281, -122.425121059383) | |||
168205 | 168205 | 204353 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1234 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5995888.88324 | 2092255.60969 | 37.72469979093621 | -122.456381351632 | (37.7246997909362, -122.456381351632) | |||
168482 | 168482 | 204344 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 103 San Ramon Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995714.09375 | 2092731.36577 | 37.7259960674539 | -122.457019970111 | (37.7259960674539, -122.457019970111) | |||
169257 | 169257 | 125697 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3011 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6000257.02708 | 2116105.09438 | 37.790434429256 | -122.44299320909599 | (37.790434429256, -122.442993209096) | |||
170226 | 170226 | 183539 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1410 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5988555.4867 | 2097656.6869 | 37.7391060350729 | -122.48212719150601 | (37.7391060350729, -122.482127191506) |
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");