Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
165176 | 165176 | 114986 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1028 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 1 | Permit Number 770492 | 6001259.4385 | 2086848.65908 | 37.7101603659725 | -122.437429040618 | (37.7101603659725, -122.437429040618) | ||
97637 | 97637 | 83771 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 924 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50981 | 6009720.30690757 | 2087000.33290755 | 37.7110542204407 | -122.408197148869 | (37.7110542204407, -122.408197148869) | |
156758 | 156758 | 69419 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 168 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 9 | Permit Number 33524 | 6001328.44378 | 2087365.87339 | 37.7115844451475 | -122.437227553813 | (37.7115844451475, -122.437227553813) | |
51443 | 51443 | 105800 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 207 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2014 12:00:00 AM | 3 | Permit Number 769635 | 6010004.04754 | 2087785.0667299998 | 37.713224823850005 | -122.407271751589 | (37.71322482385, -122.407271751589) | ||
123330 | 123330 | 84225 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1361 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50686 | 6011917.47723073 | 2088615.29524593 | 37.7156113688947 | -122.400716532679 | (37.7156113688947, -122.400716532679) | ||
49439 | 49439 | 83995 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51873 | 6003949.050969999 | 2088987.2537599998 | 37.7161850277922 | -122.428285520976 | (37.7161850277922, -122.428285520976) | |
66636 | 66636 | 82354 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50649 | 6004015.90676212 | 2089097.25184538 | 37.716490841330106 | -122.428062269463 | (37.7164908413301, -122.428062269463) | ||
114640 | 114640 | 108839 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1112 Russia Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770758 | 6003955.6442 | 2089384.8090099997 | 37.7172770009516 | -122.42829104937599 | (37.7172770009516, -122.428291049376) | |
146771 | 146771 | 88351 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51333 | 6002622.22718 | 2089414.5665400003 | 37.7172831683531 | -122.432902166399 | (37.7172831683531, -122.432902166399) | |
106504 | 106504 | 88322 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 645 France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51311 | 6002646.5 | 2089495.7 | 37.717507319615706 | -122.432824059512 | (37.7175073196157, -122.432824059512) | ||
125699 | 125699 | 88320 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 645 France Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51311 | 6002646.5 | 2089495.7 | 37.717507319615706 | -122.432824059512 | (37.7175073196157, -122.432824059512) | |||
129025 | 129025 | 88319 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 631 France Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51310 | 6002604.8 | 2089521.8 | 37.7175766192591 | -122.43297006078501 | (37.7175766192591, -122.432970060785) | |||
11429 | 11429 | 83565 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 647 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769747 | 6003095.84203 | 2089582.30789 | 37.7177706009018 | -122.43127706988199 | (37.7177706009018, -122.431277069882) |
41811 | 41811 | 108815 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 474 Munich St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774652 | 6003779.44726 | 2089723.3814299998 | 37.7181966752665 | -122.42892420414499 | (37.7181966752665, -122.428924204145) | |
11033 | 11033 | 83366 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 618 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52311 | 6003144.474669999 | 2089738.5573200001 | 37.718202383405206 | -122.43112011482701 | (37.7182023834052, -122.431120114827) | |
10886 | 10886 | 83673 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 618 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52311 | 6003154.7737300005 | 2089756.30482 | 37.7182516977425 | -122.43108578140499 | (37.7182516977425, -122.431085781405) | |
144343 | 144343 | 108814 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 470 Munich St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774651 | 6003792.96606 | 2089744.94608 | 37.7182566522639 | -122.42887901198 | (37.7182566522639, -122.42887901198) | |
98401 | 98401 | 88306 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 575 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51300 | 6003350.0 | 2089985.0 | 37.718890705147 | -122.43042727566299 | (37.718890705147, -122.430427275663) | |||
112316 | 112316 | 88332 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 659 Madrid St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51320 | 6002140.0 | 2090092.0 | 37.7191158866353 | -122.434617409737 | (37.7191158866353, -122.434617409737) | |||
127266 | 127266 | 95734 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 626 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767481 | 6002384.8 | 2090170.7 | 37.7193458734928 | -122.43377685304199 | (37.7193458734928, -122.433776853042) | |
103099 | 103099 | 88326 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51315 | 6001911.0 | 2090236.0 | 37.7194982755804 | -122.43541926902701 | (37.7194982755804, -122.435419269027) | |||
120151 | 120151 | 88327 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51315 | 6001911.0 | 2090236.0 | 37.7194982755804 | -122.43541926902701 | (37.7194982755804, -122.435419269027) | ||
124961 | 124961 | 88312 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51303 | 6003514.0 | 2090320.0 | 37.7198198301278 | -122.42988427506201 | (37.7198198301278, -122.429884275062) | |||
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) | |
96004 | 96004 | 95123 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 75 Oneida Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54050 | 6000595.4 | 2090675.6 | 37.720630512863295 | -122.439998309146 | (37.7206305128633, -122.439998309146) | |
13056 | 13056 | 108448 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 90-98X Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6004670.84101 | 2090640.5659299998 | 37.7207654791334 | -122.42590828635599 | (37.7207654791334, -122.425908286356) | |
147335 | 147335 | 95762 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 417 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767499 | 6004100.3891199995 | 2090668.84671 | 37.720810876907 | -122.427882177716 | (37.720810876907, -122.427882177716) |
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) | |||
25430 | 25430 | 113267 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 83 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | 2 | Permit Number 774551 | 6012507.044369999 | 2090789.37208 | 37.7216138123142 | -122.398831200496 | (37.7216138123142, -122.398831200496) | ||
76764 | 76764 | 108377 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 226 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 773810 | 6004631.19295 | 2091083.0586299999 | 37.7219782266077 | -122.42607682199801 | (37.7219782266077, -122.426076821998) | |
10319 | 10319 | 109211 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 819 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773413 | 6011187.7232800005 | 2090968.5283099997 | 37.722032138266 | -122.403404362845 | (37.722032138266, -122.403404362845) | |
71256 | 71256 | 52791 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 955@ MOSCOW Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | 1 | Permit Number 48832 | 6004754.52241 | 2091271.3997400003 | 37.7225023397811 | -122.425663900979 | (37.7225023397811, -122.425663900979) | ||
110088 | 110088 | 114688 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 231 Dwight St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774702 | 6010865.8 | 2091429.3 | 37.723279336417704 | -122.404549596707 | (37.7232793364177, -122.404549596707) | |||
171865 | 171865 | 114755 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 89 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777135 | 6010155.72688 | 2091460.8073900002 | 37.723326139481294 | -122.407006415641 | (37.7233261394813, -122.407006415641) | ||
94923 | 94923 | 88503 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 7 Wheat St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51441 | 6012178.0 | 2091435.0 | 37.723368235520205 | -122.400013942822 | (37.7233682355202, -122.400013942822) | |||
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) | |||
40468 | 40468 | 114753 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 10 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777133 | 6010495.976919999 | 2091580.43732 | 37.723673652787596 | -122.40583865223101 | (37.7236736527876, -122.405838652231) | ||
43802 | 43802 | 65195 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 277 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 2 | Permit Number 27179 | 6002900.88646 | 2091805.0724099998 | 37.723862768534104 | -122.432109587587 | (37.7238627685341, -122.432109587587) | |
78911 | 78911 | 95113 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 887 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54041 | 6001057.0 | 2091844.3 | 37.7238657652599 | -122.43848639746099 | (37.7238657652599, -122.438486397461) | |
120377 | 120377 | 114754 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 83 Karen Ct | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | Permit Number 777134 | 6010271.6 | 2091687.4 | 37.723954799188704 | -122.406621822462 | (37.7239547991887, -122.406621822462) | ||||
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) | ||
124483 | 124483 | 37803 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 465 Woolsey St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010402.90992445 | 2091781.87036726 | 37.7242215408534 | -122.406174555323 | (37.7242215408534, -122.406174555323) | ||
79562 | 79562 | 114722 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 465 Woolsey St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788.0 | 37.724241933851296 | -122.405954818575 | (37.7242419338513, -122.405954818575) | |||
96881 | 96881 | 114721 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 465 Woolsey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788.0 | 37.724241933851296 | -122.405954818575 | (37.7242419338513, -122.405954818575) | |||
143971 | 143971 | 114720 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 465 Woolsey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788.0 | 37.724241933851296 | -122.405954818575 | (37.7242419338513, -122.405954818575) | |||
93548 | 93548 | 104632 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 323 Madrid St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2014 12:00:00 AM | 3 | Permit Number 773809 | 6003337.3 | 2091944.5 | 37.724270338892104 | -122.430610922244 | (37.7242703388921, -122.430610922244) | |||
120650 | 120650 | 110031 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 92X Santa Ynez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774272 | 6000673.3536 | 2092054.19092 | 37.7244202473951 | -122.439827638683 | (37.7244202473951, -122.439827638683) |
10309 | 10309 | 108845 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 420 Woolsey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010479.05335 | 2091857.99264 | 37.7244348155857 | -122.405916697196 | (37.7244348155857, -122.405916697196) | |
145458 | 145458 | 108842 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 420 Woolsey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010509.54502 | 2091864.19266 | 37.7244535448266 | -122.405811727659 | (37.7244535448266, -122.405811727659) | |
10963 | 10963 | 108843 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 420 Woolsey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010519.109209999 | 2091869.71455 | 37.7244692416558 | -122.40577905416201 | (37.7244692416558, -122.405779054162) | |
103156 | 103156 | 87781 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 270 Delano Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50517 | 5999921.6 | 2092148.7 | 37.7246369273224 | -122.44243312170299 | (37.7246369273224, -122.442433121703) | |||
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) | |||
153237 | 153237 | 50024 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1704 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 3 | Permit Number 46757 | 6005953.2164199995 | 2092396.45471 | 37.725659158041104 | -122.421600147046 | (37.7256591580411, -122.421600147046) | |
149661 | 149661 | 95133 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 450@ Wayland Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2010 12:00:00 AM | 1 | 3x3 | Permit Number 54066 | 6010089.84133 | 2092358.2905700002 | 37.725786753837 | -122.407297408351 | (37.725786753837, -122.407297408351) | |
18733 | 18733 | 88323 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 125 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51312 | 6003417.0 | 2092629.0 | 37.7261543381556 | -122.430384225952 | (37.7261543381556, -122.430384225952) | |||
72897 | 72897 | 43147 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 249 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767437 | 6005979.23995 | 2092615.6379200001 | 37.7262624547464 | -122.421525745221 | (37.7262624547464, -122.421525745221) |
153325 | 153325 | 43146 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 243 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774635 | 6005976.40354 | 2092622.5546099998 | 37.7262812865364 | -122.421536041574 | (37.7262812865364, -122.421536041574) | |
180774 | 180774 | 43160 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 261 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767438 | 6006282.82959 | 2092642.1581700002 | 37.7263523869376 | -122.42047813126499 | (37.7263523869376, -122.420478131265) |
22989 | 22989 | 37859 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 127 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | 6 | Permit Number 47618 | 6004006.380580001 | 2093054.46604 | 37.7273559413142 | -122.42837708183399 | (37.7273559413142, -122.428377081834) | |
181883 | 181883 | 62233 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 120 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 3 | Permit Number 22359 | 6001435.36273 | 2093541.49048 | 37.728547379336206 | -122.437299929461 | (37.7285473793362, -122.437299929461) | |
40091 | 40091 | 95676 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 232 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767428 | 6010063.65694 | 2093465.1071400002 | 37.7288243741431 | -122.407465923318 | (37.7288243741431, -122.407465923318) |
82980 | 82980 | 87788 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 114 Theresa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.43466954464199 | (37.7289708079503, -122.434669544642) | |||
91395 | 91395 | 87785 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 114 Theresa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.43466954464199 | (37.7289708079503, -122.434669544642) | |||
120967 | 120967 | 87787 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 114 Theresa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.43466954464199 | (37.7289708079503, -122.434669544642) | |||
121132 | 121132 | 87786 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 114 Theresa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.43466954464199 | (37.7289708079503, -122.434669544642) | |||
10311 | 10311 | 27188 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 258 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 5 | 2X3 | 6002908.14927 | 2093727.2885 | 37.729141154025506 | -122.43222169348999 | (37.7291411540255, -122.43222169349) | ||
11066 | 11066 | 109684 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 250 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773450 | 6005044.41141 | 2093779.7607 | 37.729406123972296 | -122.42484018495001 | (37.7294061239723, -122.42484018495) |
12772 | 12772 | 109685 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 266 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775044 | 6005143.37702 | 2093783.4945099999 | 37.7294219655289 | -122.424498316649 | (37.7294219655289, -122.424498316649) |
123675 | 123675 | 113269 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1328 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 774425 | 6016744.9 | 2093624.7 | 37.7296342890732 | -122.384379303046 | (37.7296342890732, -122.384379303046) | |||
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) | ||
11730 | 11730 | 108558 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 222 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773717 | 6001903.01628 | 2093995.18892 | 37.729819706015704 | -122.43571567476101 | (37.7298197060157, -122.435715674761) |
164563 | 164563 | 61691 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 61 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 4 | Permit Number 31258 | 6014147.06906 | 2093799.2682599998 | 37.7299696274983 | -122.393372558494 | (37.7299696274983, -122.393372558494) | |
12835 | 12835 | 109714 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 250 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772039 | 6005020.03097 | 2094315.2579700002 | 37.7308751035831 | -122.424962554792 | (37.7308751035831, -122.424962554792) |
133294 | 133294 | 70331 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 73 Danton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 6 | 3x3 | Permit Number 54058 | 6002878.82262 | 2094505.5983099998 | 37.731276553757 | -122.43237864406 | (37.731276553757, -122.43237864406) |
131930 | 131930 | 95118 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 70 Danton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54045 | 6002845.36735 | 2094508.37035 | 37.7312822680527 | -122.432494502827 | (37.7312822680527, -122.432494502827) |
76734 | 76734 | 88076 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 674 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51071 | 6011923.037330001 | 2094336.6439200002 | 37.731321332804605 | -122.40109909554701 | (37.7313213328046, -122.401099095547) | |
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) | ||||
123276 | 123276 | 113270 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1570 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 773602 | 6015432.5 | 2094545.1 | 37.732088865659705 | -122.38898068227199 | (37.7320888656597, -122.388980682272) | |||
65040 | 65040 | 84492 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1726 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50144 | 6014424.88297 | 2094914.9156 | 37.733048399857005 | -122.392490121246 | (37.733048399857, -122.392490121246) | |
41605 | 41605 | 30800 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 199 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 4 | Permit Number 34666 | 6001059.22701 | 2095245.3674599999 | 37.7332044430184 | -122.438722291799 | (37.7332044430184, -122.438722291799) | |
91749 | 91749 | 32526 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 871 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2015 12:00:00 AM | Permit Number 776214 | 6007576.4663397 | 2095282.92697428 | 37.733676184028795 | -122.416193025137 | (37.7336761840288, -122.416193025137) | ||
106722 | 106722 | 96167 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1325X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767799 | 6003578.5 | 2095430.2 | 37.7338549505754 | -122.430025664845 | (37.7338549505754, -122.430025664845) |
23030 | 23030 | 17382 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1627 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2015 12:00:00 AM | 1 | 3X3 | Permit Number 776412 | 6014690.32946 | 2095358.97831 | 37.7342824432881 | -122.39160343105 | (37.7342824432881, -122.39160343105) | |
137110 | 137110 | 32048 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 167 Stillings Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1995 12:00:00 AM | 10 | Permit Number 35429 | 5999662.091580001 | 2095748.4383599998 | 37.7345061757178 | -122.443588678099 | (37.7345061757178, -122.443588678099) | ||
17580 | 17580 | 4334 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 852 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001755.94767 | 2095865.71194 | 37.7349473777015 | -122.436357925586 | (37.7349473777015, -122.436357925586) | |||
84122 | 84122 | 115763 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 37 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 771927 | 6005378.2 | 2095966.0 | 37.7354278990147 | -122.42384163868799 | (37.7354278990147, -122.423841638688) | ||
120168 | 120168 | 108610 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 745 Moultrie St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774595 | 6007633.33742 | 2095945.52231 | 37.7354987236975 | -122.416043312411 | (37.7354987236975, -122.416043312411) | |
63323 | 63323 | 96333 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 11 Robblee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767342 | 6012676.77436 | 2095976.0416 | 37.7358647977189 | -122.398608271155 | (37.7358647977189, -122.398608271155) | |
82853 | 82853 | 88479 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1751 Newcomb Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51431 | 6014386.0 | 2096253.8 | 37.7367225430205 | -122.392718181551 | (37.7367225430205, -122.392718181551) | ||
84365 | 84365 | 108933 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773146 | 6008530.3 | 2096373.5 | 37.7367242478568 | -122.41297241357 | (37.7367242478568, -122.41297241357) |
138212 | 138212 | 94884 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2010 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53951 | 6013072.55459 | 2096282.04692 | 37.736727066797 | -122.397261344859 | (37.736727066797, -122.397261344859) |
188017 | 188017 | 94885 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2010 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53951 | 6013050.0613 | 2096298.0841299999 | 37.736769849332 | -122.39734023878599 | (37.736769849332, -122.397340238786) |
108868 | 108868 | 80286 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 280 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50470 | 6004535.68280027 | 2096559.61306431 | 37.73701022767111 | -122.42679679858699 | (37.7370102276711, -122.426796798587) | ||
88766 | 88766 | 84634 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 361 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50931 | 6008966.27725874 | 2096629.00783692 | 37.737450280623605 | -122.411483091014 | (37.7374502806236, -122.411483091014) | ||
3386 | 3386 | 243475 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 109X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779653 | 6007857.826 | 2097024.89565 | 37.738475065558895 | -122.415343555473 | (37.7384750655589, -122.415343555473) | |
3389 | 3389 | 243477 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 109 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779653 | 6007827.749919999 | 2097028.5645299999 | 37.7384834490575 | -122.415447803985 | (37.7384834490575, -122.415447803985) | |
144889 | 144889 | 108925 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 209 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 770705 | 6009037.7 | 2097340.0 | 37.739406516451204 | -122.411286359806 | (37.7394065164512, -122.411286359806) | ||
144271 | 144271 | 33553 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 238 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53983 | 6007052.33241005 | 2097631.90832878 | 37.740096482896 | -122.418171592585 | (37.740096482896, -122.418171592585) | |
110966 | 110966 | 87903 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 223 Bocana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50920 | 6007150.2 | 2097674.7 | 37.7402194874954 | -122.41783623809401 | (37.7402194874954, -122.417836238094) |
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");