Street_Tree_List

Data source: data.sfgov.org

67 rows where PlotSize = "Width 0ft", qSiteInfo = 1 and qSpecies = 48

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
179 182083 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1101 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:33:00 PM 3 Width 0ft   5989775.2775 2098997.3719 37.742858080169505 -122.47800774412599 (37.7428580801695, -122.478007744126)
1386 183693 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983046.6569 2105897.5428 37.7614111825323 -122.501783460946 (37.7614111825323, -122.501783460946)
1390 183692 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983047.3598 2105912.7714 37.761453037237 -122.501782156698 (37.761453037237, -122.501782156698)
1404 183694 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983048.5312 2105875.9885 37.7613521106328 -122.501775383852 (37.7613521106328, -122.501775383852)
1408 183696 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983051.3079 2105837.6039 37.7612468805065 -122.50176294055599 (37.7612468805065, -122.501762940556)
1417 183690 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983045.4855 2105953.0685 37.7615635715471 -122.50179162058001 (37.7615635715471, -122.50179162058)
1419 183699 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983053.3747 2105791.1008 37.761119317578505 -122.501752351825 (37.7611193175785, -122.501752351825)
1428 183691 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft   5983046.4226 2105931.5142 37.76150444459871 -122.50178678479799 (37.7615044445987, -122.501786784798)
1430 183687 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1341 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2017 12:00:00 AM 3 Width 0ft Permit Number 33196 5983043.3769 2106010.2341 37.7617204082059 -122.50180314292801 (37.7617204082059, -122.501803142928)
3913 253116 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 26 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 12:00:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3915 160069 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:26:00 AM 3 Width 0ft   6000296.79811 2090527.7878900003 37.7202076512361 -122.441019880684 (37.7202076512361, -122.441019880684)
3918 253108 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:41:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3922 160059 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 10:50:00 AM 3 Width 0ft   6000588.557440001 2091082.6412900002 37.7217477663201 -122.440051133668 (37.7217477663201, -122.440051133668)
3928 253114 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 24 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:55:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3934 160071 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:31:00 AM 3 Width 0ft   6000209.4859 2090450.10808 37.7199893866688 -122.44131611827 (37.7199893866688, -122.44131611827)
3935 160073 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:36:00 AM 3 Width 0ft   6000082.999340001 2090399.7386 37.7198438772755 -122.44174972458201 (37.7198438772755, -122.441749724582)
3937 253112 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 22 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:51:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3939 160065 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:13:00 AM 3 Width 0ft   6000417.53141 2090750.6791299998 37.7208265358932 -122.440618525839 (37.7208265358932, -122.440618525839)
3946 160063 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:07:00 AM 3 Width 0ft   6000471.59074 2090857.9533099998 37.7211241647202 -122.440439349407 (37.7211241647202, -122.440439349407)
3950 162332 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 36 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 02:06:00 PM 3 Width 0ft   5996526.7373 2090117.21242 37.718864853708205 -122.45402201441001 (37.7188648537082, -122.45402201441)
3960 160061 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:02:00 AM 3 Width 0ft   6000547.454419999 2091000.21878 37.7215191128017 -122.440187308101 (37.7215191128017, -122.440187308101)
3968 253118 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 28 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 01:35:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3973 253110 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1000 Cayuga Ave 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 11:46:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3974 162331 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 26 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 02:09:00 PM 3 Width 0ft   5996526.61739 2090076.5104099999 37.7187530886569 -122.454019490912 (37.7187530886569, -122.454019490912)
3982 159338 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 517 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:04:00 AM 3 Width 0ft   5998112.9338 2087183.20699 37.7108995709325 -122.44832801714199 (37.7108995709325, -122.448328017142)
3992 159336 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 523 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 10:36:00 AM 3 Width 0ft   5998080.57171 2087152.95418 37.7108146533454 -122.448437690352 (37.7108146533454, -122.448437690352)
4058 159346 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:49:00 AM 3 Width 0ft   5998276.6806 2087336.8062099998 37.7113306798385 -122.44777312285 (37.7113306798385, -122.44777312285)
4070 159339 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 517 Ellington Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:12:00 AM 3 Width 0ft   5998126.4578599995 2087195.02696 37.710932799068104 -122.44828212563 (37.7109327990681, -122.44828212563)
4072 159348 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:44:00 AM 3 Width 0ft   5998312.68186 2087372.3667799998 37.711430378688796 -122.447651252104 (37.7114303786888, -122.447651252104)
4077 159345 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:39:00 AM 3 Width 0ft   5998268.07471 2087327.6085 37.7113049331395 -122.447802205131 (37.7113049331395, -122.447802205131)
4091 159347 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 461 Ellington Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2017 11:27:00 AM 3 Width 0ft   5998288.37354 2087349.92963 37.711367382076396 -122.44773365338999 (37.7113673820764, -122.44773365339)
27198 140780 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 5 Encanto Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6000014.7367 2112198.3604 37.7796937331341 -122.44355075738399 (37.7796937331341, -122.443550757384)
28351 248531 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 800 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5997658.267999999 2107761.8815 37.767377634072794 -122.451382700243 (37.7673776340728, -122.451382700243)
28890 182659 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2252 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5986985.3742 2102363.8158 37.7519391046129 -122.487901613135 (37.7519391046129, -122.487901613135)
32349 184697 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1616 43rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5982844.3503 2104136.3629 37.7565635951525 -122.502352798468 (37.7565635951525, -122.502352798468)
34972 244513 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 500 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6004128.882 2109777.8057 37.7732812611379 -122.429145501014 (37.7732812611379, -122.429145501014)
35420 182699 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1659 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5989088.7291 2103739.8915 37.755839910949895 -122.480728726959 (37.7558399109499, -122.480728726959)
37433 184723 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1635 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983115.9866 2103988.5253 37.7561736313112 -122.501402462618 (37.7561736313112, -122.501402462618)
41737 183303 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1286 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5982766.9656 2106385.9546 37.7627357893861 -122.502786935917 (37.7627357893861, -122.502786935917)
43034 140758 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 42 TERRA VISTA AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6000316.7782 2112875.0348 37.781568928755895 -122.442554464995 (37.7815689287559, -122.442554464995)
48320 140696 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 162 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5997358.0622 2109907.9029 37.7732528619693 -122.452575957146 (37.7732528619693, -122.452575957146)
51569 200835 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1101 16th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   6013058.6169 2107038.7182 37.7662617940431 -122.398063928568 (37.7662617940431, -122.398063928568)
58411 248399 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 115 Belvedere St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5998223.6499 2108104.3812 37.768350409277396 -122.449451812394 (37.7683504092774, -122.449451812394)
60263 247309 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 220 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6002790.9139 2109368.8454 37.7720825259473 -122.43374447503099 (37.7720825259473, -122.433744475031)
63459 184208 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1474 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5983740.5189 2105133.2538 37.759353393050105 -122.49932723943 (37.7593533930501, -122.49932723943)
63806 181949 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2450 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5986451.9754 2098568.253 37.7414863814969 -122.489467090095 (37.7414863814969, -122.489467090095)
66926 184599 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1795 40th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983770.6594 2102984.6576 37.7534557168171 -122.499064248064 (37.7534557168171, -122.499064248064)
117673 140302 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 143 COLE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5997780.8586 2110053.3207 37.773676357183 -122.45112394331899 (37.773676357183, -122.451123943319)
130143 182826 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1781 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5986558.6884 2103101.4836 37.7539396409234 -122.48943136928999 (37.7539396409234, -122.48943136929)
131222 247385 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 355 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6002203.8017 2109776.7723 37.7731692596784 -122.435804531936 (37.7731692596784, -122.435804531936)
132639 183523 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2542 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5986781.4828 2097933.2945 37.7397621847049 -122.488281131206 (37.7397621847049, -122.488281131206)
135392 181684 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1347 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5986459.3313 2106064.8642 37.7620704697574 -122.48999290967501 (37.7620704697574, -122.489992909675)
150547 200836 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1101 16th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6013076.6871 2107039.6693 37.766265411985295 -122.398001493496 (37.7662654119853, -122.398001493496)
153218 182607 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1867 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5986269.2088 2102542.1488 37.7523869566931 -122.49039129916001 (37.7523869566931, -122.49039129916)
153529 183672 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1254 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5984312.3195 2106638.1262 37.7635188796404 -122.497460805156 (37.7635188796404, -122.497460805156)
154400 141717 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2545 TURK BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5998369.6346 2111707.5824 37.778252224784005 -122.44920648801201 (37.778252224784, -122.449206488012)
160731 140699 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 224 ASHBURY ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5998816.4363 2109919.7991 37.773368976906205 -122.447532121663 (37.7733689769062, -122.447532121663)
161381 245893 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1001 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6001728.4463 2109399.5631 37.772106523732 -122.437421829009 (37.772106523732, -122.437421829009)
167364 182307 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1509 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5987118.7965 2104973.5941 37.7591126281614 -122.487631931758 (37.7591126281614, -122.487631931758)
171120 184598 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1795 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983770.321 2103008.0087 37.7535198125919 -122.499067143504 (37.7535198125919, -122.499067143504)
172020 184126 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1643 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5986219.0266 2104040.7857 37.756498872957394 -122.490675089245 (37.7564988729574, -122.490675089245)
173458 184640 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1650 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983160.9711 2103902.0944 37.7559389581009 -122.501240500695 (37.7559389581009, -122.501240500695)
176471 182700 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1651 Moraga St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5989102.9459 2103739.8915 37.7558407372502 -122.48067956122401 (37.7558407372502, -122.480679561224)
178120 181690 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1374 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5982168.1662 2105754.9295 37.760967965591604 -122.504811174863 (37.7609679655916, -122.504811174863)
179813 137671 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 756 LYON ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6000049.6788 2111547.4906 37.7779086039439 -122.443383113797 (37.7779086039439, -122.443383113797)
185807 182658 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2242 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5987004.6631 2102364.6195 37.751942436508706 -122.487834969288 (37.7519424365087, -122.487834969288)
188215 183121 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2327 41st Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983581.7952 2099373.3538 37.7435289932417 -122.49945051311 (37.7435289932417, -122.49945051311)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 2868.821ms · Data source: data.sfgov.org