Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
123584 | 123584 | 109253 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1355 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773041 | 5981790.7 | 2105864.5 | 37.7612466017789 | -122.50612476738199 | (37.7612466017789, -122.506124767382) |
106309 | 106309 | 109276 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1558 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773739 | 5982234.4 | 2104492.8 | 37.757506413032104 | -122.504488595501 | (37.7575064130321, -122.504488595501) |
103987 | 103987 | 108663 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 842 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772817 | 5982645.59315 | 2110033.9904099996 | 37.7727451127869 | -122.50347686125099 | (37.7727451127869, -122.503476861251) |
98622 | 98622 | 108662 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 842 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772817 | 5982646.66004 | 2110014.0281599998 | 37.77269036496121 | -122.50347169236099 | (37.7726903649612, -122.503471692361) |
52541 | 52541 | 47432 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 432 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 2 | Permit Number 45343 | 5982855.38785 | 2112869.9347900003 | 37.7805441204791 | -122.50296115463001 | (37.7805441204791, -122.50296115463) | |
110968 | 110968 | 87269 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4109 Irving St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2008 12:00:00 AM | 3x3 | Permit Number 50292 | 5983031.0 | 2106268.0 | 37.762427433139294 | -122.50186502168002 | (37.7624274331393, -122.50186502168) | |||
96439 | 96439 | 107673 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 834 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772907 | 5983266.37919 | 2110104.76952 | 37.77297592784021 | -122.50133476468099 | (37.7729759278402, -122.501334764681) | |
68243 | 68243 | 87490 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 496 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50390 | 5984109.08074 | 2112532.5405200003 | 37.77969133885821 | -122.498599173652 | (37.7796913388582, -122.498599173652) | |
173728 | 173728 | 87489 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 496 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50390 | 5984109.09334 | 2112519.44129 | 37.7796553729161 | -122.498598162167 | (37.7796553729161, -122.498598162167) | |
50948 | 50948 | 85291 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 7350 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | 2 | 4x72 | Permit Number 49578 | 5984127.30348 | 2112512.4695 | 37.779637298343 | -122.498534651264 | (37.779637298343, -122.498534651264) | ||
180284 | 180284 | 105250 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 500 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2014 12:00:00 AM | 1 | Permit Number 771049 | 5984731.6893 | 2112357.9141599997 | 37.7792483592825 | -122.496432443475 | (37.7792483592825, -122.496432443475) | ||
171597 | 171597 | 105251 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 500 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2014 12:00:00 AM | 1 | Permit Number 771049 | 5984733.08187 | 2112389.43293 | 37.779334982299794 | -122.496429952441 | (37.7793349822998, -122.496429952441) | ||
98773 | 98773 | 106368 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 426 Country Club Dr | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/23/2014 12:00:00 AM | Permit Number 770073 | 5984817.1 | 2094918.3 | 37.731369010287 | -122.494850794258 | (37.731369010287, -122.494850794258) | ||||
168503 | 168503 | 78302 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 575 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770704 | 5985015.95011 | 2111950.61478 | 37.7781466811201 | -122.49541903513 | (37.7781466811201, -122.49541903513) | |
66893 | 66893 | 69450 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 438 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 3 | Permit Number 33560 | 5985645.83858 | 2112922.4758599997 | 37.780851994355004 | -122.493311672832 | (37.780851994355, -122.493311672832) | |
79183 | 79183 | 87126 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 438 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2008 12:00:00 AM | 3x3 | Permit Number 50074 | 5985668.2 | 2112929.7 | 37.7808731376826 | -122.493234847229 | (37.7808731376826, -122.493234847229) | ||
62134 | 62134 | 96861 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 387 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768142 | 5986826.57443 | 2113361.96386 | 37.7821276946473 | -122.489259307913 | (37.7821276946473, -122.489259307913) | |
24130 | 24130 | 96862 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 387 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768142 | 5986827.805480001 | 2113344.76478 | 37.7820805427479 | -122.48925378416 | (37.7820805427479, -122.48925378416) | |
90183 | 90183 | 49737 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 251 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2003 12:00:00 AM | 3 | 3x12 | Permit Number 46536 | 5987104.42255848 | 2114202.9919751 | 37.7844531321546 | -122.488359918659 | (37.7844531321546, -122.488359918659) | |
103390 | 103390 | 49736 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 251 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2003 12:00:00 AM | 3 | 3x12 | Permit Number 46536 | 5987104.42255848 | 2114202.9919751 | 37.7844531321546 | -122.488359918659 | (37.7844531321546, -122.488359918659) | |
102366 | 102366 | 109037 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1306 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772801 | 5987138.4 | 2106347.4 | 37.7628858653346 | -122.487665061189 | (37.7628858653346, -122.487665061189) |
99368 | 99368 | 109089 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 218 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 3x3 | 5987170.3 | 2114494.3 | 37.7852568239907 | -122.488153421892 | (37.7852568239907, -122.488153421892) | ||
115316 | 115316 | 109088 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 218 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 5987170.3 | 2114494.3 | 37.7852568239907 | -122.488153421892 | (37.7852568239907, -122.488153421892) | ||
126977 | 126977 | 95932 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 218 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767629 | 5987170.3 | 2114494.3 | 37.7852568239907 | -122.488153421892 | (37.7852568239907, -122.488153421892) |
22964 | 22964 | 109898 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1786 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775112 | 5987249.9 | 2103123.1 | 37.754039320648495 | -122.48704261510099 | (37.7540393206485, -122.487042615101) |
29955 | 29955 | 48772 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 766 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/2002 12:00:00 AM | 2 | Permit Number 46029 | 5987276.54902 | 2110739.79263 | 37.7749542102717 | -122.48750993680099 | (37.7749542102717, -122.487509936801) | ||
109288 | 109288 | 108633 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2610 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774602 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) |
179311 | 179311 | 67205 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 123 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1992 12:00:00 AM | 3 | Permit Number 30659 | 5987996.0292 | 2115149.70283 | 37.7871045112839 | -122.485344797558 | (37.7871045112839, -122.485344797558) | ||
105494 | 105494 | 95926 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 651 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767623 | 5988426.1 | 2111542.8 | 37.777226019991204 | -122.483592327097 | (37.7772260199912, -122.483592327097) | |
155904 | 155904 | 93189 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 651 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53197 | 5988441.61799 | 2111543.24899 | 37.77722815601879 | -122.483538678985 | (37.7772281560188, -122.483538678985) | |
36801 | 36801 | 49512 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1928& 21st AVE Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2003 12:00:00 AM | 4 | Permit Number 46417 | 5989493.41802 | 2113376.93915 | 37.7823241210106 | -122.480034435471 | (37.7823241210106, -122.480034435471) | ||
83616 | 83616 | 30531 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 100 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/1986 12:00:00 AM | 2 | 3x3 | Permit Number 34534 | 5989617.18715 | 2114630.7338900003 | 37.7857738797228 | -122.479698023599 | (37.7857738797228, -122.479698023599) |
156259 | 156259 | 61491 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 178 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1990 12:00:00 AM | 3 | Permit Number 28869 | 5989634.7512 | 2114171.8446400003 | 37.784514919234205 | -122.47960366993601 | (37.7845149192342, -122.479603669936) | |
63085 | 63085 | 65128 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 184 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50320 | 5989636.73328 | 2114131.59369 | 37.7844045165702 | -122.47959386665 | (37.7844045165702, -122.47959386665) | |
174893 | 174893 | 46093 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 100 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2001 12:00:00 AM | 4 | Permit Number 44465 | 5989926.67635 | 2114640.8160200003 | 37.785819536272 | -122.478628027687 | (37.785819536272, -122.478628027687) | ||
89118 | 89118 | 98412 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 19th Ave | 4 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||
91295 | 91295 | 98410 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 19th Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||
96447 | 96447 | 98411 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 19th Ave | 3 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||
153587 | 153587 | 95071 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 319 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767740 | 5990554.377 | 2113243.49278 | 37.7820193005134 | -122.476354274932 | (37.7820193005134, -122.476354274932) | |
128305 | 128305 | 108523 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1655 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773674 | 5990561.39992 | 2104128.4377099997 | 37.7569922406164 | -122.475664177859 | (37.7569922406164, -122.475664177859) |
28196 | 28196 | 88382 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 355 17th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51360 | 5990561.77007 | 2113010.94096 | 37.7813812065074 | -122.476311706446 | (37.7813812065074, -122.476311706446) | ||
122847 | 122847 | 108524 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1669 18th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773675 | 5990564.49357 | 2104037.4684 | 37.756742642361495 | -122.47564683648301 | (37.7567426423615, -122.475646836483) |
110033 | 110033 | 108525 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1673 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773676 | 5990565.37747 | 2104011.47717 | 37.7566713285758 | -122.47564188182501 | (37.7566713285758, -122.475641881825) |
101009 | 101009 | 12725 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1544 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2003 12:00:00 AM | 3 | 3X3 | 5990592.796680001 | 2114771.31925 | 37.7862165141869 | -122.476332998319 | (37.7862165141869, -122.476332998319) | ||
165837 | 165837 | 101128 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 295X 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769229 | 5990852.62725 | 2113482.2447900004 | 37.782692139400204 | -122.47533991256701 | (37.7826921394002, -122.475339912567) | |
106292 | 106292 | 43751 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 255 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2015 12:00:00 AM | 3 | Permit Number 773834 | 5991170.79793 | 2113718.28394 | 37.7833586747671 | -122.474256417664 | (37.7833586747671, -122.474256417664) | |
97135 | 97135 | 72366 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 706 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772932 | 5991332.62885 | 2110561.58816 | 37.7747006286591 | -122.473466226319 | (37.7747006286591, -122.473466226319) | |
95030 | 95030 | 88376 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 563 14th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51354 | 5991545.8 | 2111599.6 | 37.777563068378704 | -122.472804534873 | (37.7775630683787, -122.472804534873) | |||
156900 | 156900 | 102081 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 525 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52509 | 5991566.610309999 | 2111852.8346 | 37.778259586012204 | -122.472751014651 | (37.7782595860122, -122.472751014651) |
139591 | 139591 | 87070 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 395 Byxbee St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
143622 | 143622 | 87071 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 395 Byxbee St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
69222 | 69222 | 68687 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 133 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2014 12:00:00 AM | 1 | 6x6 | Permit Number 771044 | 5992088.87095 | 2114507.13587 | 37.7855777876584 | -122.471137767056 | (37.7855777876584, -122.471137767056) |
97561 | 97561 | 108495 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 133 12th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773787 | 5992089.92921 | 2114572.19418 | 37.7857564810121 | -122.47113884728998 | (37.7857564810121, -122.47113884729) | ||
70176 | 70176 | 94709 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 739 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53847 | 5992236.9095 | 2110392.30167 | 37.7742881380791 | -122.47032583467899 | (37.7742881380791, -122.470325834679) |
27994 | 27994 | 52460 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 682@ CABRILLO 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 1 | Permit Number 48571 | 5992268.12798 | 2110826.06835 | 37.775480948973396 | -122.470249439229 | (37.7754809489734, -122.470249439229) | |
179928 | 179928 | 94708 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 696 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53846 | 5992270.38847 | 2110735.82166 | 37.775233286679104 | -122.470235046427 | (37.7752332866791, -122.470235046427) |
90961 | 90961 | 94705 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 682 12th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53845 | 5992291.3 | 2110837.3 | 37.7755131276945 | -122.470170100471 | (37.7755131276945, -122.470170100471) | ||
141970 | 141970 | 94820 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1227 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53900 | 5992334.0 | 2107055.2 | 37.7651309632558 | -122.469746983482 | (37.7651309632558, -122.469746983482) | |
111675 | 111675 | 81067 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1283 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50902 | 5992359.24137134 | 2106729.49777919 | 37.7642381302347 | -122.46963596784799 | (37.7642381302347, -122.469635967848) | ||
98471 | 98471 | 69097 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1652 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53733 | 5992497.75001654 | 2104207.48539143 | 37.7573213517081 | -122.46897335970101 | (37.7573213517081, -122.468973359701) | |
103299 | 103299 | 83188 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1664 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53557 | 5992810.26262937 | 2104140.01708709 | 37.7571541524742 | -122.467887670443 | (37.7571541524742, -122.467887670443) | ||
126048 | 126048 | 83189 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1670 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53556 | 5992811.58181355 | 2104100.90541778 | 37.7570468381941 | -122.467880263564 | (37.7570468381941, -122.467880263564) | ||
119879 | 119879 | 94144 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1670 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53556 | 5992831.3 | 2104104.9 | 37.757058944886396 | -122.467812361688 | (37.7570589448864, -122.467812361688) | ||
64180 | 64180 | 84410 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 745 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51564 | 5992859.62349 | 2110370.66867 | 37.774264723280204 | -122.468170197773 | (37.7742647232802, -122.468170197773) | |
90318 | 90318 | 94819 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1551 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53898 | 5993027.2 | 2104915.2 | 37.759295127513106 | -122.467193784759 | (37.7592951275131, -122.467193784759) | |
31482 | 31482 | 53932 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 140 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1972 12:00:00 AM | 1 | Permit Number 9646 | 5993064.176969999 | 2114524.47346 | 37.785681755762894 | -122.46776478269899 | (37.7856817557629, -122.467764782699) | ||
98825 | 98825 | 108994 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1819 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773341 | 5993399.9 | 2103085.8 | 37.754293576097496 | -122.465771900659 | (37.7542935760975, -122.465771900659) |
91530 | 91530 | 108518 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 600-602 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773792 | 5993757.5779800005 | 2110759.58067 | 37.7753843907715 | -122.465092287532 | (37.7753843907715, -122.465092287532) |
66641 | 66641 | 50836 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 202 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2004 12:00:00 AM | Permit Number 47354 | 5994277.69303186 | 2105335.48637483 | 37.7605212305047 | -122.462899497742 | (37.7605212305047, -122.462899497742) | |||
129492 | 129492 | 50837 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 202 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2004 12:00:00 AM | Permit Number 47354 | 5994277.69303186 | 2105335.48637483 | 37.7605212305047 | -122.462899497742 | (37.7605212305047, -122.462899497742) | |||
184009 | 184009 | 41941 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 646 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 10 | Permit Number 42299 | 5994427.444490001 | 2111105.89465 | 37.7763738805691 | -122.46280020914 | (37.7763738805691, -122.46280020914) | |
103885 | 103885 | 87238 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 313 04th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | 3x3 | Permit Number 50268 | 5994594.9 | 2113356.1 | 37.7825619851863 | -122.462384185128 | (37.7825619851863, -122.462384185128) | |||
113612 | 113612 | 107438 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 777 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773131 | 5994721.10495 | 2110354.7884 | 37.7743284514501 | -122.46172988985701 | (37.7743284514501, -122.461729889857) | |
110286 | 110286 | 88514 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 640 Faxon Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51446 | 5994921.4 | 2092497.3 | 37.7253078255283 | -122.459743296133 | (37.7253078255283, -122.459743296133) | |||
111710 | 111710 | 12532 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 120 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6x7.4 | 5995061.5103400005 | 2114935.24706 | 37.7869247555074 | -122.460884411661 | (37.7869247555074, -122.460884411661) | |||
52436 | 52436 | 31977 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 134 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 7 | Permit Number 35376 | 5995230.64434 | 2114664.73917 | 37.7861917443429 | -122.460279644251 | (37.7861917443429, -122.460279644251) | |
173281 | 173281 | 32337 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2626 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 3 | Permit Number 36899 | 5995236.946330001 | 2110306.39824 | 37.7742252654946 | -122.459942005265 | (37.7742252654946, -122.459942005265) | ||
188880 | 188880 | 38814 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 286 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51147 | 5995268.26088 | 2113665.38834 | 37.7834499595789 | -122.460077076847 | (37.7834499595789, -122.460077076847) | |
53628 | 53628 | 34942 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 462 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1997 12:00:00 AM | 8 | Permit Number 38539 | 5995310.64413 | 2112404.55918 | 37.7799904974934 | -122.459839088006 | (37.7799904974934, -122.459839088006) | ||
83737 | 83737 | 82146 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1083 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51167 | 5995391.16373818 | 2098013.23554983 | 37.7404802453018 | -122.458518484651 | (37.7404802453018, -122.458518484651) | ||
85604 | 85604 | 115256 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 277 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 773180 | 5995612.8 | 2091840.6 | 37.723544420177205 | -122.457305721784 | (37.7235444201772, -122.457305721784) | |||
81903 | 81903 | 112888 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3980 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2015 12:00:00 AM | Permit Number 774440 | 5995705.4 | 2115208.7 | 37.7877126116995 | -122.458676518899 | (37.7877126116995, -122.458676518899) | |||
87428 | 87428 | 49067 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1298 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50555 | 5995836.31315767 | 2092013.47244835 | 37.724031921729704 | -122.45654557668001 | (37.7240319217297, -122.45654557668) | ||
88138 | 88138 | 88597 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Jordan Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51542 | 5996162.8 | 2114014.5 | 37.7844599367093 | -122.457007600103 | (37.7844599367093, -122.457007600103) | |||
142314 | 142314 | 47094 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 336 Willard North St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51142 | 5996292.61494047 | 2110619.69439374 | 37.775146151844794 | -122.456312937477 | (37.7751461518448, -122.456312937477) | ||
53809 | 53809 | 98842 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 313 Maple St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2012 12:00:00 AM | 1 | Permit Number 768890 | 5996633.94495 | 2115242.03804 | 37.7878574732038 | -122.455466360678 | (37.7878574732038, -122.455466360678) | ||
152466 | 152466 | 94730 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 418 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53862 | 5997217.67326 | 2114882.8026 | 37.7869045857318 | -122.45342083293001 | (37.7869045857318, -122.45342083293) |
99743 | 99743 | 108592 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 669 Parker Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774577 | 5997227.20075 | 2110944.62571 | 37.77609193478521 | -122.453103475186 | (37.7760919347852, -122.453103475186) |
60907 | 60907 | 50426 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 250 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773627 | 5997303.25557645 | 2090612.9654569 | 37.7202705700793 | -122.45137364778 | (37.7202705700793, -122.45137364778) | |
102151 | 102151 | 88269 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1175 Stanyan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51255 | 5997354.0 | 2106147.0 | 37.7629261534889 | -122.452318574624 | (37.7629261534889, -122.452318574624) | |||
105080 | 105080 | 88268 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1158 Stanyan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51254 | 5997417.6 | 2106243.4 | 37.7631944867864 | -122.45210556106701 | (37.7631944867864, -122.452105561067) | |||
56020 | 56020 | 30506 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3615 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1998 12:00:00 AM | 6 | Permit Number 40581 | 5997549.204530001 | 2115073.9457400003 | 37.787448412048604 | -122.45228761430599 | (37.7874484120486, -122.452287614306) | ||
97155 | 97155 | 52415 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 445 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50993 | 5997805.99655674 | 2094075.37872241 | 37.729806319232004 | -122.44988524851401 | (37.729806319232, -122.449885248514) | ||
124910 | 124910 | 93624 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 149 Collins St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | Permit Number 53164 | 5998064.0 | 2113562.0 | 37.783326485193 | -122.450397500912 | (37.783326485193, -122.450397500912) | |||
87360 | 87360 | 88834 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 156 Collins St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51716 | 5998112.0 | 2113497.0 | 37.78315075925521 | -122.45022675387301 | (37.7831507592552, -122.450226753873) | |||
80871 | 80871 | 88242 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2501 Turk Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51228 | 5998431.6 | 2111697.4 | 37.778227810594295 | -122.44899139417299 | (37.7782278105943, -122.448991394173) | ||
105801 | 105801 | 88240 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2501 Turk Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51228 | 5998431.6 | 2111697.4 | 37.778227810594295 | -122.44899139417299 | (37.7782278105943, -122.448991394173) | ||
105983 | 105983 | 88239 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2501 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51228 | 5998431.6 | 2111697.4 | 37.778227810594295 | -122.44899139417299 | (37.7782278105943, -122.448991394173) | ||
107907 | 107907 | 88241 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2501 Turk Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51228 | 5998431.6 | 2111697.4 | 37.778227810594295 | -122.44899139417299 | (37.7782278105943, -122.448991394173) | ||
86784 | 86784 | 105038 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 46 Atalaya Ter | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2015 12:00:00 AM | 3 | 3X4 | Permit Number 771123 | 5998888.1 | 2110865.6 | 37.7759699989755 | -122.44735231528401 | (37.7759699989755, -122.447352315284) |
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");