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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 82388 | 82388 | 63744 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 690 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773423 | 6003267.19349485 | 2109664.80045569 | 37.772922159977 | -122.43211812531901 | (37.772922159977, -122.432118125319) |
| 142880 | 142880 | 64577 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3500 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2011 12:00:00 AM | 3 | 4x4 1/2 | Permit Number 767979 | 6006252.59051018 | 2104959.36998238 | 37.7601709691535 | -122.42145702923 | (37.7601709691535, -122.42145702923) | |
| 49119 | 49119 | 65035 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1205 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51820 | 6003879.11104946 | 2101261.18670708 | 37.7498825208731 | -122.429402039878 | (37.7498825208731, -122.429402039878) | ||
| 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) | |
| 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) | |
| 164298 | 164298 | 66134 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3259 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 3 | Permit Number 768243 | 5999299.78945 | 2120070.84719 | 37.8012687076388 | -122.446590621369 | (37.8012687076388, -122.446590621369) | ||
| 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) | ||
| 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) |
| 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) | |
| 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) | |
| 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) | |
| 125226 | 125226 | 70167 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 831 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2015 12:00:00 AM | 3 | Permit Number 773700 | 5981976.78091 | 2110066.45395 | 37.772794906459 | -122.505792724366 | (37.772794906459, -122.505792724366) | |
| 140795 | 140795 | 70259 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 613 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2014 12:00:00 AM | 1 | 3x5 | Permit Number 771047 | 6009849.60881533 | 2105419.99624628 | 37.761637898995104 | -122.409049096462 | (37.7616378989951, -122.409049096462) | |
| 66578 | 66578 | 70266 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 414 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 8 | 5988762.33088 | 2112478.2196299997 | 37.7798139854521 | -122.482497769619 | (37.7798139854521, -122.482497769619) | ||
| 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) |
| 73049 | 73049 | 70606 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1250 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 8 | 6007500.2862599995 | 2115460.0775 | 37.7890736803541 | -122.41788619879298 | (37.7890736803541, -122.417886198793) | ||
| 33867 | 33867 | 70607 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1256 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 9 | 6007485.00571 | 2115457.39575 | 37.78906545695621 | -122.41793887748301 | (37.7890654569562, -122.417938877483) | ||
| 88121 | 88121 | 71505 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 328 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774557 | 6006691.32680411 | 2104197.11487977 | 37.758102721165706 | -122.41988555479601 | (37.7581027211657, -122.419885554796) | |
| 174370 | 174370 | 71615 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 536 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 2 | 5983503.66193 | 2112151.1699 | 37.7786086821922 | -122.500665338334 | (37.7786086821922, -122.500665338334) | ||
| 60143 | 60143 | 72252 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 531 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 1 | 6002585.93283 | 2090796.9641 | 37.7210768666757 | -122.43312633500601 | (37.7210768666757, -122.433126335006) | ||
| 168053 | 168053 | 72311 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3769 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 4 | 5996250.37824 | 2115874.5059700003 | 37.7895720432509 | -122.456839183887 | (37.7895720432509, -122.456839183887) | ||
| 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) | |
| 136360 | 136360 | 74692 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 200 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 6 | 6011876.44918 | 2119465.43765 | 37.8003167500634 | -122.403026990216 | (37.8003167500634, -122.403026990216) | ||
| 65070 | 65070 | 78191 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 680 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 1 | 6015407.71241 | 2105894.14692 | 37.7632496064147 | -122.389858829046 | (37.7632496064147, -122.389858829046) | ||
| 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) | |
| 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) | ||
| 42297 | 42297 | 80634 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 577 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 1 | 6013018.0309 | 2104352.7115 | 37.758884352052604 | -122.398015861652 | (37.7588843520526, -122.398015861652) | ||
| 60469 | 60469 | 80737 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 186 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 1 | 6000043.5525400005 | 2087718.3093599998 | 37.7124790304587 | -122.44169374357 | (37.7124790304587, -122.44169374357) | ||
| 103973 | 103973 | 81044 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4521 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2007 12:00:00 AM | 3x3 | Permit Number 50047 | 6001024.93237313 | 2104618.24519857 | 37.758938185839206 | -122.439512523669 | (37.7589381858392, -122.439512523669) | ||
| 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) | ||
| 77434 | 77434 | 81367 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1001 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/08/2003 12:00:00 AM | 3x3 | 6006914.85774282 | 2114314.60875621 | 37.7858955407321 | -122.41983039718201 | (37.7858955407321, -122.419830397182) | |||
| 69848 | 69848 | 81662 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 563 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5991577.12734 | 2111607.04314 | 37.7775853186785 | -122.472696706975 | (37.7775853186785, -122.472696706975) | |||
| 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) | ||
| 142320 | 142320 | 82180 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 105 Lake St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773769 | 5995179.68463591 | 2114884.08050195 | 37.78679106496129 | -122.46047184952101 | (37.7867910649613, -122.460471849521) | ||
| 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) | ||
| 86015 | 86015 | 82961 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3925 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50821 | 6002789.88777109 | 2105883.76961321 | 37.7625133012574 | -122.433498925711 | (37.7625133012574, -122.433498925711) | ||
| 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) | ||
| 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) | |
| 80419 | 80419 | 83398 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4244X 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/12/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50813 | 6001912.0 | 2104709.0 | 37.7592378221466 | -122.43645112889901 | (37.7592378221466, -122.436451128899) | |
| 35817 | 35817 | 83433 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 760 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 4 | 6000998.571 | 2089370.50235 | 37.7170699516967 | -122.43851121642099 | (37.7170699516967, -122.438511216421) | ||
| 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) |
| 29927 | 29927 | 83659 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 6 | 6001685.54257 | 2090383.4533900002 | 37.7198903425557 | -122.436209138162 | (37.7198903425557, -122.436209138162) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 106163 | 106163 | 84574 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1090X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6003150.0 | 2101890.0 | 37.7515677875779 | -122.43196823442301 | (37.7515677875779, -122.431968234423) |
| 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) | ||
| 49125 | 49125 | 84779 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 224 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2007 12:00:00 AM | 3 | Permit No. 49287 | 6013986.61648 | 2106050.38487 | 37.7635996908854 | -122.394784908699 | (37.7635996908854, -122.394784908699) | ||
| 137475 | 137475 | 84780 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 224 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2007 12:00:00 AM | 4 | Permit No. 49287 | 6013987.25375 | 2106041.39506 | 37.7635750422708 | -122.39478207494899 | (37.7635750422708, -122.394782074949) | ||
| 66339 | 66339 | 84782 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 228 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2007 12:00:00 AM | 5 | Permit No. 49243 | 6013990.15625 | 2105982.3752200003 | 37.763413148108505 | -122.394767902514 | (37.7634131481085, -122.394767902514) | ||
| 169003 | 169003 | 84840 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1107 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2007 12:00:00 AM | 7 | Permit No. 49267 | 6009440.82091 | 2117125.31431 | 37.793755034731795 | -122.411289855968 | (37.7937550347318, -122.411289855968) | ||
| 61056 | 61056 | 85039 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 740 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49387 | 6008855.33926 | 2110725.28618 | 37.776149243538796 | -122.41286298423901 | (37.7761492435388, -122.412862984239) | |
| 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) | ||
| 77791 | 77791 | 85870 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2310 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2007 12:00:00 AM | 3 | 3x3 | 6008150.982530001 | 2104964.863142 | 37.760292906427296 | -122.41489175995599 | (37.7602929064273, -122.414891759956) | ||
| 61699 | 61699 | 86883 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 550 Jersey St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49808 | 6001589.0 | 2101474.0 | 37.750336931820996 | -122.43733657341998 | (37.750336931821, -122.43733657342) | ||||
| 108560 | 108560 | 86950 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1610 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2007 12:00:00 AM | 3x3 | Permit Number 49916 | 6000149.0 | 2110263.0 | 37.7743873828756 | -122.442947262018 | (37.7743873828756, -122.442947262018) | ||
| 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) | |||
| 38918 | 38918 | 87076 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2565 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50014 | 6006601.66741 | 2120051.34913 | 37.8016295480248 | -122.421321483111 | (37.8016295480248, -122.421321483111) | |
| 76542 | 76542 | 87077 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2565 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50014 | 6006603.98041 | 2120038.0860099997 | 37.8015932612686 | -122.421312536668 | (37.8015932612686, -122.421312536668) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 113354 | 113354 | 87851 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 97 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2013 12:00:00 AM | 3x3 | Permit Number 779093 | 6007313.0 | 2098782.0 | 37.7432690474632 | -122.41735179051201 | (37.7432690474632, -122.417351790512) | ||
| 87745 | 87745 | 87898 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50917 | 6007438.0 | 2097723.6 | 37.740369948387794 | -122.41684460251801 | (37.7403699483878, -122.416844602518) | ||
| 100026 | 100026 | 87899 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50917 | 6007438.0 | 2097723.6 | 37.740369948387794 | -122.41684460251801 | (37.7403699483878, -122.416844602518) | ||
| 88613 | 88613 | 87900 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50917 | 6007438.0 | 2097723.6 | 37.740369948387794 | -122.41684460251801 | (37.7403699483878, -122.416844602518) | ||
| 127067 | 127067 | 87902 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 223 Bocana St | 1 | 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) | ||
| 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) | ||
| 110507 | 110507 | 87911 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 101 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50936 | 6007398.0 | 2097753.0 | 37.7404484242714 | -122.41698498961 | (37.7404484242714, -122.41698498961) | ||
| 93883 | 93883 | 87912 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 101 Wool St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50936 | 6007398.0 | 2097753.0 | 37.7404484242714 | -122.41698498961 | (37.7404484242714, -122.41698498961) | ||
| 104650 | 104650 | 87913 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 101 Wool St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50936 | 6007398.0 | 2097753.0 | 37.7404484242714 | -122.41698498961 | (37.7404484242714, -122.41698498961) | ||
| 83905 | 83905 | 87914 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 101 Wool St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50936 | 6007398.0 | 2097753.0 | 37.7404484242714 | -122.41698498961 | (37.7404484242714, -122.41698498961) | ||
| 142629 | 142629 | 87975 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2160 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51010 | 5999212.8 | 2111613.6 | 37.778042363793396 | -122.446282917617 | (37.7780423637934, -122.446282917617) | ||
| 82829 | 82829 | 88007 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1394 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53732 | 5999618.7 | 2107794.0 | 37.7675778847064 | -122.44460417005699 | (37.7675778847064, -122.444604170057) | |
| 168943 | 168943 | 88037 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2301X Lyon St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51052 | 5999275.57165 | 2116691.87228 | 37.7919895603315 | -122.446431199448 | (37.7919895603315, -122.446431199448) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 128361 | 128361 | 88259 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1460 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51244 | 5999422.0 | 2104472.0 | 37.758445274906 | -122.445045681381 | (37.758445274906, -122.445045681381) | |||
| 129116 | 129116 | 88261 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 229 Douglass St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51248 | 6001199.0 | 2104918.0 | 37.7597711445886 | -122.438931999231 | (37.7597711445886, -122.438931999231) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");