Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4930 | 4930 | 197650 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 10:31:00 AM | 3 | Width 3ft | 6017512.77369 | 2098485.85809 | 37.7430244920913 | -122.38206267634399 | (37.7430244920913, -122.382062676344) | ||
4934 | 4934 | 3524 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:27:00 AM | 3 | 3X3 | 6018232.23392 | 2097945.31305 | 37.7415799713464 | -122.37953740884399 | (37.7415799713464, -122.379537408844) | ||
4936 | 4936 | 3492 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 10:28:00 AM | 3 | 3X3 | 6017600.3443599995 | 2098412.1206099996 | 37.7428268597689 | -122.38175475027599 | (37.7428268597689, -122.381754750276) | ||
4937 | 4937 | 203013 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 2 | Width 3ft | 6017575.06427 | 2098435.51559 | 37.742889701702794 | -122.381843789478 | (37.7428897017028, -122.381843789478) | ||
4938 | 4938 | 203012 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:41:00 AM | 3 | Width 3ft | 6017482.43996 | 2098513.81637 | 37.743099584575795 | -122.382169507733 | (37.7430995845758, -122.382169507733) | ||
5003 | 5003 | 3497 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:36:00 AM | 3 | 3X3 | 6017681.58024 | 2098352.39138 | 37.7426673407245 | -122.38146970386002 | (37.7426673407245, -122.38146970386) | ||
5005 | 5005 | 3535 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 08:14:00 AM | 3 | 3X3 | 6018417.72714 | 2097807.1699900003 | 37.7412108868837 | -122.37888643815799 | (37.7412108868837, -122.378886438158) | ||
5013 | 5013 | 3501 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 10:19:00 AM | 3 | 3X3 | 6017757.788930001 | 2098294.27861 | 37.742511981949605 | -122.381202153752 | (37.7425119819496, -122.381202153752) | ||
5015 | 5015 | 3533 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:14:00 AM | 3 | 3X3 | 6018385.2534300005 | 2097830.3322900003 | 37.7412726954727 | -122.379000330107 | (37.7412726954727, -122.379000330107) | ||
13784 | 13784 | 3536 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/1990 12:00:00 AM | 6 | 3X3 | 6018434.89697 | 2097793.8014700003 | 37.741175126223204 | -122.378826142235 | (37.7411751262232, -122.378826142235) | ||
13807 | 13807 | 3515 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/1990 12:00:00 AM | 12 | 3X3 | 6018092.0886699995 | 2098050.06678 | 37.741859873634205 | -122.380029266058 | (37.7418598736342, -122.380029266058) | ||
13849 | 13849 | 3503 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6017795.07465 | 2098266.33581 | 37.742437314826496 | -122.38107128711201 | (37.7424373148265, -122.381071287112) | |||
13920 | 13920 | 3540 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018504.91252 | 2097742.5518 | 37.7410382647176 | -122.37858049328999 | (37.7410382647176, -122.37858049329) | |||
14225 | 14225 | 3498 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017700.75455 | 2098337.80167 | 37.7426283389164 | -122.381402389631 | (37.7426283389164, -122.381402389631) | |||
14307 | 14307 | 3530 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/1990 12:00:00 AM | 6 | 3X3 | 6018336.58816 | 2097867.32601 | 37.7413715894385 | -122.379171168028 | (37.7413715894385, -122.379171168028) | ||
14413 | 14413 | 3500 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017738.77776 | 2098309.39264 | 37.7425524325559 | -122.381268940124 | (37.7425524325559, -122.381268940124) | |||
14781 | 14781 | 3543 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 3X3 | 6018555.97345 | 2097704.22378 | 37.74093583821671 | -122.378401280909 | (37.7409358382167, -122.378401280909) | ||
14987 | 14987 | 3529 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018316.85209 | 2097881.54987 | 37.7414095570002 | -122.379240396934 | (37.7414095570002, -122.379240396934) | ||
15070 | 15070 | 3495 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017646.36043 | 2098378.21595 | 37.742736305236605 | -122.381593280624 | (37.7427363052366, -122.381593280624) | |||
15250 | 15250 | 3496 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017663.23695 | 2098365.77973 | 37.74270308968379 | -122.381534061174 | (37.7427030896838, -122.381534061174) | |||
15411 | 15411 | 3504 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6017814.43885 | 2098252.58182 | 37.7424006179895 | -122.3810033748 | (37.7424006179895, -122.3810033748) | |||
15487 | 15487 | 3499 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6017721.1126 | 2098322.7096700002 | 37.742588023232 | -122.381330947484 | (37.742588023232, -122.381330947484) | |||
15506 | 15506 | 3509 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017998.366640001 | 2098120.43609 | 37.742047922763795 | -122.380358219176 | (37.7420479227638, -122.380358219176) | ||
15603 | 15603 | 3517 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018124.75716 | 2098026.19045 | 37.741796116207105 | -122.37991464925899 | (37.7417961162071, -122.379914649259) | ||
15955 | 15955 | 3494 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017631.184309999 | 2098389.6910900003 | 37.7427669757157 | -122.38164655374099 | (37.7427669757157, -122.381646553741) | |||
16339 | 16339 | 3548 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 58 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018674.8366 | 2097616.25665 | 37.7407008489755 | -122.37798418701999 | (37.7407008489755, -122.37798418702) | |||
23263 | 23263 | 3508 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 6017980.680269999 | 2098133.15007 | 37.7420818568975 | -122.380420257114 | (37.7420818568975, -122.380420257114) | |||
35082 | 35082 | 214006 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 200x Lawton St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5993658.67007 | 2104606.16817 | 37.7584830376791 | -122.464987428342 | (37.7584830376791, -122.464987428342) | |||
55323 | 55323 | 214007 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 100x Lawton St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5993739.83569 | 2104610.7544299997 | 37.7585003100564 | -122.464707056595 | (37.7585003100564, -122.464707056595) | |||
71193 | 71193 | 89530 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5014 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983074.33103 | 2111736.1703 | 37.7774440004005 | -122.502119816782 | (37.7774440004005, -122.502119816782) | ||
81150 | 81150 | 89541 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5300X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982202.45771 | 2111704.784 | 37.777306562133106 | -122.505133536108 | (37.7773065621331, -122.505133536108) | ||
84065 | 84065 | 89564 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5021 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983068.09266 | 2111680.5005900003 | 37.7772907811029 | -122.502137276438 | (37.7772907811029, -122.502137276438) | ||
84236 | 84236 | 87561 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 1426 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2011 12:00:00 AM | 3 | 3x3 | 5981248.5719800005 | 2105353.680971 | 37.759812110915206 | -122.50796181336901 | (37.7598121109152, -122.507961813369) | ||
89706 | 89706 | 89572 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4901X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983389.31662 | 2111692.03112 | 37.777341307260706 | -122.50102693 | (37.7773413072607, -122.50102693) | ||
90227 | 90227 | 89532 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5130 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982703.43603 | 2111723.1091299998 | 37.777386341369706 | -122.50340187617701 | (37.7773863413697, -122.503401876177) | ||
92891 | 92891 | 89547 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5500 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5981512.1941599995 | 2111683.29996 | 37.777206935443 | -122.507519744478 | (37.777206935443, -122.507519744478) | ||
96395 | 96395 | 89563 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5027 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983042.76149 | 2111679.44242 | 37.7772863874375 | -122.502224825366 | (37.7772863874375, -122.502224825366) | ||
96472 | 96472 | 89558 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5239 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982363.16543 | 2111656.98924 | 37.77718478612329 | -122.504574063555 | (37.7771847861233, -122.504574063555) | ||
97710 | 97710 | 89546 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5450 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5981705.459980001 | 2111690.26917 | 37.777237453835895 | -122.506851705119 | (37.7772374538359, -122.506851705119) | ||
97937 | 97937 | 89571 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4901X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983370.6621900005 | 2111693.23015 | 37.777343504090396 | -122.5010915494 | (37.7773435040904, -122.5010915494) | ||
98051 | 98051 | 89543 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5300X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982144.573969999 | 2111703.4056700002 | 37.7772993717145 | -122.50533366907801 | (37.7772993717145, -122.505333669078) | ||
99525 | 99525 | 89538 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5226 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982399.00612 | 2111713.8845599997 | 37.777343112143996 | -122.50445429746 | (37.777343112144, -122.50445429746) | ||
99596 | 99596 | 89525 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4900X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983384.65726 | 2111746.53595 | 37.7774906880837 | -122.501047080127 | (37.7774906880837, -122.501047080127) | ||
103204 | 103204 | 89548 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5601 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5981205.071959999 | 2111615.6071 | 37.77700297412879 | -122.50857713252199 | (37.7770029741288, -122.508577132522) | ||
108955 | 108955 | 89544 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5324 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982113.874969999 | 2111702.53608 | 37.777295177582204 | -122.505439800548 | (37.7772951775822, -122.505439800548) | ||
110367 | 110367 | 99185 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4345 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/25/2008 12:00:00 AM | 3 | 3x3 | 5982067.9022699995 | 2110283.83078 | 37.7733971225951 | -122.505493646453 | (37.7733971225951, -122.505493646453) | ||
110382 | 110382 | 90732 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4533 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981514.87502 | 2110263.98035 | 37.7733100587697 | -122.507405139203 | (37.7733100587697, -122.507405139203) | ||
111693 | 111693 | 89553 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5301X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982158.297809999 | 2111648.1776099997 | 37.7771485392206 | -122.50528210040001 | (37.7771485392206, -122.5052821004) | ||
112797 | 112797 | 89565 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5001X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983089.7802099995 | 2111680.23644 | 37.777291329944 | -122.50206223387899 | (37.777291329944, -122.502062233879) | ||
116740 | 116740 | 90919 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5048 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 5 | 3x3 | 5982934.22783 | 2111732.57013 | 37.7774258833955 | -122.502604205438 | (37.7774258833955, -122.502604205438) | ||
126333 | 126333 | 89557 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5239 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982344.66025 | 2111655.7855 | 37.777180392486 | -122.504637988559 | (37.777180392486, -122.504637988559) | ||
127746 | 127746 | 89551 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5333 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982065.67399 | 2111646.96238 | 37.7771397519236 | -122.505602419867 | (37.7771397519236, -122.505602419867) | ||
128775 | 128775 | 89533 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5140 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982684.3370199995 | 2111722.3179200003 | 37.7773830461441 | -122.503467886196 | (37.7773830461441, -122.503467886196) | ||
140935 | 140935 | 89566 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5001X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983110.49799 | 2111681.5935 | 37.7772962731377 | -122.501990666002 | (37.7772962731377, -122.501990666002) | ||
142508 | 142508 | 91011 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4622 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5981221.20719 | 2110309.11198 | 37.773416674213706 | -122.508424309329 | (37.7734166742137, -122.508424309329) | ||
143599 | 143599 | 89529 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5000X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983095.8091 | 2111736.71305 | 37.7774467524363 | -122.50204555844 | (37.7774467524363, -122.50204555844) | ||
145358 | 145358 | 90749 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4327 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982140.9261 | 2110286.22946 | 37.773408005745296 | -122.50524122882601 | (37.7734080057453, -122.505241228826) |
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");