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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 148966 | 148966 | 128477 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 209 Front St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6013057.14783 | 2116642.86942 | 37.7926325108289 | -122.39874308403299 | (37.7926325108289, -122.398743084033) | |||
| 149176 | 149176 | 34264 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 184 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 2 | Permit Number 38068 | 5988062.8335 | 2114793.6134200003 | 37.786130683011606 | -122.48508753620399 | (37.7861306830116, -122.485087536204) | |
| 149624 | 149624 | 128553 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 580 California St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6011468.43757 | 2116718.4282 | 37.7927513319591 | -122.40424543129299 | (37.7927513319591, -122.404245431293) | |||
| 151426 | 151426 | 36880 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2515 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2015 12:00:00 AM | 2 | 3x3 | Permit Number 776215 | 6002666.11082 | 2116940.6214900003 | 37.7928656304089 | -122.43471771865102 | (37.7928656304089, -122.434717718651) | |
| 153920 | 153920 | 34266 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 190 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 2 | Permit Number 38069 | 5988065.55649 | 2114756.40704 | 37.7860286835145 | -122.485075384697 | (37.7860286835145, -122.485075384697) | |
| 156111 | 156111 | 128475 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 209 Front St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6013052.2767199995 | 2116680.71749 | 37.7927361612995 | -122.39876259573201 | (37.7927361612995, -122.398762595732) | |||
| 166907 | 166907 | 36882 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2515 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2015 12:00:00 AM | 2 | Permit Number 776215 | 6002659.2588599995 | 2116979.55031 | 37.7929721299187 | -122.434744211776 | (37.7929721299187, -122.434744211776) | ||
| 169704 | 169704 | 128078 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 109 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6009589.18536 | 2121879.6833599997 | 37.80681767755271 | -122.411112486276 | (37.8068176775527, -122.411112486276) | |||
| 170647 | 170647 | 226535 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Division St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009245.14879 | 2108060.29196 | 37.76885366428721 | -122.411326213745 | (37.7688536642872, -122.411326213745) | |||
| 172312 | 172312 | 190134 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 599 Barneveld Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6011052.12686 | 2097137.70773 | 37.738963838104205 | -122.404307086999 | (37.7389638381042, -122.404307086999) | |||
| 174473 | 174473 | 126918 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3601 Jackson St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5996919.33325 | 2115969.60665 | 37.7898715534869 | -122.45453155590499 | (37.7898715534869, -122.454531555905) | |||
| 174605 | 174605 | 190229 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 49 Stevenson St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6012852.1657300005 | 2115652.48474 | 37.7899017248207 | -122.39938277541701 | (37.7899017248207, -122.399382775417) | |||
| 177385 | 177385 | 128374 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 737 Pine St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6010386.90221 | 2116149.57584 | 37.79112890732429 | -122.40794747430701 | (37.7911289073243, -122.407947474307) | |||
| 178247 | 178247 | 95190 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 422 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 2x2 | 5993138.5929 | 2112550.49199 | 37.7802660375255 | -122.467363737946 | (37.7802660375255, -122.467363737946) | |||
| 182358 | 182358 | 190242 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 New Montgomery St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6012127.59685 | 2115141.75316 | 37.7884589658448 | -122.401853817407 | (37.7884589658448, -122.401853817407) | |||
| 184289 | 184289 | 128376 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 737 Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6010409.072509999 | 2116157.67498 | 37.791152386824606 | -122.407871336803 | (37.7911523868246, -122.407871336803) | |||
| 184656 | 184656 | 190138 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 411 Barneveld Ave | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6011253.6233 | 2097979.03397 | 37.7412851978498 | -122.403669581886 | (37.7412851978498, -122.403669581886) | |||
| 185819 | 185819 | 226536 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Division St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009285.41361 | 2108074.3489 | 37.7688945195891 | -122.411187933104 | (37.7688945195891, -122.411187933104) | |||
| 1403 | 1403 | 122808 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1830 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x4 | 6011911.59203 | 2106562.15691 | 37.7648893115244 | -122.401997787192 | (37.7648893115244, -122.401997787192) | ||
| 1903 | 1903 | 127944 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012622.90875 | 2119176.76577 | 37.7995657819845 | -122.400423640834 | (37.7995657819845, -122.400423640834) | ||
| 1908 | 1908 | 127945 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 2ft | 6012656.99006 | 2119182.6904 | 37.7995839500992 | -122.40030612282601 | (37.7995839500992, -122.400306122826) | ||
| 1911 | 1911 | 127947 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 855 Front St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012711.6665 | 2119148.4967900002 | 37.7994931113801 | -122.400114518675 | (37.7994931113801, -122.400114518675) | ||
| 1913 | 1913 | 127946 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 855 Front St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012709.78092 | 2119164.70922 | 37.7995375216859 | -122.400122182714 | (37.7995375216859, -122.400122182714) | ||
| 1924 | 1924 | 127943 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012601.19681 | 2119174.02118 | 37.7995570351977 | -122.400498579547 | (37.7995570351977, -122.400498579547) | ||
| 2682 | 2682 | 102785 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3343 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5.5x6 | Permit Number 772480 | 6003227.9831 | 2119876.64018 | 37.800959061171206 | -122.43298347232599 | (37.8009590611712, -122.432983472326) | ||
| 2879 | 2879 | 105455 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2307X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777222 | 6003193.66965 | 2116635.80681 | 37.7920586237566 | -122.43287055523899 | (37.7920586237566, -122.432870555239) | |
| 2950 | 2950 | 9693 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 414 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2012 12:00:00 AM | 3 | 3X3 | 6005939.70475 | 2111200.2280099997 | 37.777289230461705 | -122.422982727867 | (37.7772892304617, -122.422982727867) | ||
| 3213 | 3213 | 107592 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1812 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772847 | 5999539.4256 | 2115189.16926 | 37.7878785991598 | -122.44541016857 | (37.7878785991598, -122.44541016857) | |
| 3624 | 3624 | 127356 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2100 Webster St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Width 4ft | 6003284.8942599995 | 2116317.33043 | 37.7911893426569 | -122.432532159241 | (37.7911893426569, -122.432532159241) | ||
| 3628 | 3628 | 127357 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2100 Webster St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Width 4ft | 6003276.2668 | 2116362.2656799997 | 37.791312234126295 | -122.432565221033 | (37.7913122341263, -122.432565221033) | ||
| 3669 | 3669 | 128007 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 450 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6008574.61168 | 2121448.10995 | 37.8055757371873 | -122.414593071218 | (37.8055757371873, -122.414593071218) | ||
| 3671 | 3671 | 128005 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 444 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6008626.93235 | 2121456.53692 | 37.805601814825394 | -122.414412604251 | (37.8056018148254, -122.414412604251) | ||
| 4248 | 4248 | 115669 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600X Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777079 | 6001202.18162 | 2117312.3728400003 | 37.793803143947294 | -122.43980963780399 | (37.7938031439473, -122.439809637804) | |
| 4442 | 4442 | 11124 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2115 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/14/2002 12:00:00 AM | 3 | 3X3 | 6007136.72657 | 2119705.75668 | 37.8007107898386 | -122.41944539839899 | (37.8007107898386, -122.419445398399) | ||
| 4624 | 4624 | 98532 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1805X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999984.2458 | 2115196.51475 | 37.7879241507313 | -122.443871705528 | (37.7879241507313, -122.443871705528) | |||
| 6250 | 6250 | 92077 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1151 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775152 | 6007038.57451 | 2114995.4175 | 37.7877718433296 | -122.41945068732201 | (37.7877718433296, -122.419450687322) | |
| 6868 | 6868 | 88774 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2580 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777079 | 6001246.21661 | 2117291.33076 | 37.79374787431421 | -122.43965576381399 | (37.7937478743142, -122.439655763814) | |
| 6936 | 6936 | 113768 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2580 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777079 | 6001245.42868 | 2117302.08267 | 37.7937773514059 | -122.43965926129101 | (37.7937773514059, -122.439659261291) | |
| 6965 | 6965 | 45818 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2260 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | Permit Number 773615 | 6003397.29034 | 2116914.4207200003 | 37.7928351730475 | -122.43218593195499 | (37.7928351730475, -122.432185931955) | ||
| 7160 | 7160 | 4592 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2016 01:42:00 PM | 3 | 3x3 | 6011401.079390001 | 2118088.92644 | 37.796510626729706 | -122.40457501395299 | (37.7965106267297, -122.404575013953) | ||
| 7205 | 7205 | 18500 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 519X Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6010154.14929 | 2115557.66128 | 37.789490618641295 | -122.408711019419 | (37.7894906186413, -122.408711019419) | |||
| 7221 | 7221 | 109623 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 451 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775170 | 6011938.15364 | 2118065.18841 | 37.79647544883721 | -122.402714938942 | (37.7964754488372, -122.402714938942) | |
| 7416 | 7416 | 106674 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 399 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2014 12:00:00 AM | 3 | 4x6 | Permit Number 773354 | 5998100.3376400005 | 2115239.0542599997 | 37.787933313904 | -122.450392722053 | (37.787933313904, -122.450392722053) | |
| 7752 | 7752 | 115670 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600X Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777079 | 6001200.65079 | 2117319.78555 | 37.7938234101762 | -122.43981546632 | (37.7938234101762, -122.43981546632) | |
| 7893 | 7893 | 113778 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1753 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776886 | 6004527.88766 | 2119441.95127 | 37.7998391633122 | -122.428454248166 | (37.7998391633122, -122.428454248166) | |
| 7894 | 7894 | 19205 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 630 Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1994 12:00:00 AM | 3 | 3X3 | 6012236.37693 | 2117925.3952900004 | 37.7961082565352 | -122.401673184994 | (37.7961082565352, -122.401673184994) | ||
| 8003 | 8003 | 109210 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2637 Larkin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774817 | 6006569.78732 | 2120282.61277 | 37.802262741793704 | -122.421448236261 | (37.8022627417937, -122.421448236261) | |
| 8238 | 8238 | 52038 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3735 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777497 | 5996952.62983 | 2115319.66476 | 37.7880888966189 | -122.45436938564899 | (37.7880888966189, -122.454369385649) | ||
| 8621 | 8621 | 7342 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2142 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6002873.64296 | 2115779.16456 | 37.7896883471937 | -122.433916590893 | (37.7896883471937, -122.433916590893) | ||
| 8849 | 8849 | 95551 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1333 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2016 12:00:00 AM | 3 | Permit Number 779044 | 6007189.57448 | 2115360.3539400003 | 37.7887823728581 | -122.41895414822599 | (37.7887823728581, -122.418954148226) | ||
| 8912 | 8912 | 113777 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1753 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776886 | 6004511.02573 | 2119439.59827 | 37.799831748383 | -122.428512428932 | (37.799831748383, -122.428512428932) | |
| 9212 | 9212 | 60089 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1216 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2016 12:00:00 AM | 3 | Permit Number 19590 | 6007184.48933 | 2118821.16351 | 37.7982846096101 | -122.41921733482799 | (37.7982846096101, -122.419217334828) | ||
| 13361 | 13361 | 117223 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013667.943030001 | 2111389.10897 | 37.7782409101283 | -122.39626130683997 | (37.7782409101283, -122.39626130684) | |
| 13660 | 13660 | 117220 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013718.755890001 | 2111339.55053 | 37.7781076611892 | -122.39608205125799 | (37.7781076611892, -122.396082051258) | |
| 13836 | 13836 | 116024 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1020 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2016 12:00:00 AM | 3 | 3x3 | 6014238.96376 | 2106224.3911099997 | 37.764091501331 | -122.393924293493 | (37.764091501331, -122.393924293493) | ||
| 14073 | 14073 | 100266 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2017 12:00:00 AM | 3 | 1x1 | Permit Number 779105 | 6015095.83494 | 2113421.2206 | 37.783899979542106 | -122.391463765467 | (37.7838999795421, -122.391463765467) | |
| 14154 | 14154 | 117219 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013733.69082 | 2111323.12296 | 37.7780633857557 | -122.39602923405701 | (37.7780633857557, -122.396029234057) | |
| 14214 | 14214 | 69442 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013823.57483 | 2111230.5410599997 | 37.777814177306 | -122.395711802165 | (37.777814177306, -122.395711802165) | |
| 14549 | 14549 | 117222 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013683.04729 | 2111373.4456700003 | 37.7781987427098 | -122.396207957236 | (37.7781987427098, -122.396207957236) | |
| 14669 | 14669 | 85689 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 528 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013589.1885400005 | 2112344.59457 | 37.780860073169706 | -122.396600746047 | (37.7808600731697, -122.396600746047) | ||
| 14702 | 14702 | 117215 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013784.57093 | 2111269.26347 | 37.7779183304931 | -122.395849445217 | (37.7779183304931, -122.395849445217) | |
| 15546 | 15546 | 117216 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013770.84151 | 2111284.28441 | 37.7779588107877 | -122.395897993299 | (37.7779588107877, -122.395897993299) | |
| 15669 | 15669 | 117221 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013696.95586 | 2111359.6496200003 | 37.778161635782396 | -122.39615887494499 | (37.7781616357824, -122.396158874945) | |
| 15804 | 15804 | 25479 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 513 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | 6010415.98374 | 2105766.37654 | 37.7626206925093 | -122.407114642722 | (37.7626206925093, -122.407114642722) | ||
| 16129 | 16129 | 117218 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013744.24197 | 2111311.0843599997 | 37.7780309175198 | -122.395991889732 | (37.7780309175198, -122.395991889732) | |
| 16357 | 16357 | 117217 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013756.29755 | 2111297.17195 | 37.77799338791311 | -122.395949209701 | (37.7779933879131, -122.395949209701) | |
| 16504 | 16504 | 117214 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013802.24625 | 2111251.09103 | 37.7778694163842 | -122.395787025958 | (37.7778694163842, -122.395787025958) | |
| 16778 | 16778 | 111580 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1501-1555 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2015 12:00:00 AM | 3 | 6012799.17131 | 2106096.7853200003 | 37.7636610021682 | -122.39889519177099 | (37.7636610021682, -122.398895191771) | |||
| 17600 | 17600 | 5600 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1120-1122 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 6X6 | 6005086.74805 | 2101818.38067 | 37.751480744460295 | -122.42526561553801 | (37.7514807444603, -122.425265615538) | ||
| 18438 | 18438 | 5591 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1088 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778628 | 6005076.53143 | 2102027.71599 | 37.7520549534969 | -122.425315840853 | (37.7520549534969, -122.425315840853) | |
| 23060 | 23060 | 19038 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3240 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5999276.1857 | 2115361.4423700003 | 37.788336585220996 | -122.44633332442899 | (37.788336585221, -122.446333324429) | |||
| 23903 | 23903 | 128508 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 415 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6011852.868919999 | 2116847.94752 | 37.7931284347821 | -122.40292438836 | (37.7931284347821, -122.40292438836) | |||
| 24311 | 24311 | 95189 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 422 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x2 | Permit Number 767104 | 5993138.35484 | 2112539.16901 | 37.7802349339512 | -122.46736373791401 | (37.7802349339512, -122.467363737914) | ||
| 24553 | 24553 | 218912 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 67 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993729.09341 | 2093249.4084299998 | 37.727304294154294 | -122.463919522093 | (37.7273042941543, -122.463919522093) | |||
| 25126 | 25126 | 50436 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2629 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | 3 | Permit Number 47088 | 6001610.4622 | 2117489.1021 | 37.794311627823504 | -122.438409620012 | (37.7943116278235, -122.438409620012) | ||
| 26888 | 26888 | 128506 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 132 Bush St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012518.245680001 | 2116156.64354 | 37.791267409218705 | -122.400573546136 | (37.7912674092187, -122.400573546136) | |||
| 27772 | 27772 | 87883 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1771 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50853 | 6002287.185880001 | 2120855.36005 | 37.803592960513605 | -122.436309109488 | (37.8035929605136, -122.436309109488) | |
| 31876 | 31876 | 190283 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 199 New Montgomery St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012884.630030001 | 2114398.01689 | 37.786459058895396 | -122.399182357001 | (37.7864590588954, -122.399182357001) | |||
| 33542 | 33542 | 190139 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Barneveld Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011347.78295 | 2098111.56945 | 37.741654371349604 | -122.40335333078501 | (37.7416543713496, -122.403353330785) | |||
| 34732 | 34732 | 100681 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 6012316.03692 | 2116830.7554099998 | 37.793107081281 | -122.401320580594 | (37.793107081281, -122.401320580594) | ||||
| 35364 | 35364 | 128452 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 251 Leidesdorff St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012151.25811 | 2116572.97679 | 37.7923900877774 | -122.401872599739 | (37.7923900877774, -122.401872599739) | |||
| 35452 | 35452 | 127427 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1870 Sacramento St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005811.11401 | 2116269.47164 | 37.791200866578 | -122.423788099553 | (37.791200866578, -122.423788099553) | |||
| 37302 | 37302 | 128464 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 341 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012520.637080001 | 2116804.75779 | 37.7930471108983 | -122.400610820334 | (37.7930471108983, -122.400610820334) | |||
| 37351 | 37351 | 128783 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 159 Maiden Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6011113.569069999 | 2115056.0032 | 37.788166874149795 | -122.405356171363 | (37.7881668741498, -122.405356171363) | |||
| 37796 | 37796 | 127264 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2580 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6001230.031140001 | 2117290.6597599997 | 37.7937451106869 | -122.439711718727 | (37.7937451106869, -122.439711718727) | |||
| 38194 | 38194 | 128461 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 341 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012421.30504 | 2116788.3689900003 | 37.7929965707839 | -122.40095336493 | (37.7929965707839, -122.40095336493) | |||
| 38836 | 38836 | 128483 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 330 Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012246.35245 | 2116465.43051 | 37.7921000977961 | -122.401536006882 | (37.7921000977961, -122.401536006882) | |||
| 39471 | 39471 | 127939 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 475 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007866.305 | 2121993.07142 | 37.80703224409721 | -122.41708291085399 | (37.8070322440972, -122.417082910854) | |||
| 39619 | 39619 | 119456 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 766 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5985728.914919999 | 2110666.6398 | 37.7746629724789 | -122.492858068519 | (37.7746629724789, -122.492858068519) | |||
| 40208 | 40208 | 190282 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 199 New Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012894.58638 | 2114386.5408900003 | 37.7864281033285 | -122.399147104454 | (37.7864281033285, -122.399147104454) | |||
| 40545 | 40545 | 128466 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 339 California St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012617.3816 | 2116817.144 | 37.7930865155706 | -122.400276947047 | (37.7930865155706, -122.400276947047) | |||
| 41155 | 41155 | 190263 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 90 New Montgomery St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012423.70042 | 2114824.63943 | 37.787604766388704 | -122.400807051507 | (37.7876047663887, -122.400807051507) | |||
| 41517 | 41517 | 218917 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113 Edgehill Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 1ft | 5994873.89414 | 2098975.72105 | 37.7430932497504 | -122.46037670942499 | (37.7430932497504, -122.460376709425) | |||
| 41720 | 41720 | 104275 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3675 Washington St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | Permit Number 770437 | 5997228.00193 | 2115684.51457 | 37.7891064651375 | -122.453443003895 | (37.7891064651375, -122.453443003895) | |||
| 43095 | 43095 | 190249 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 New Montgomery St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012276.22435 | 2114985.84699 | 37.788039177600496 | -122.401328625912 | (37.7880391776005, -122.401328625912) | |||
| 43820 | 43820 | 106734 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2652 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3 | Permit Number 770178 | 5999150.643180001 | 2119434.00692 | 37.799511595141894 | -122.447060875059 | (37.7995115951419, -122.447060875059) | ||
| 44069 | 44069 | 41259 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 201 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | 3 | Permit Number 41947 | 6012965.42505 | 2116862.48993 | 37.7932304259924 | -122.39907587276501 | (37.7932304259924, -122.399075872765) | ||
| 44254 | 44254 | 128785 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 159 Maiden Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6011134.895409999 | 2115059.37486 | 37.7881773242683 | -122.405282623008 | (37.7881773242683, -122.405282623008) | |||
| 44891 | 44891 | 128484 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 340 Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6012215.94703 | 2116460.90061 | 37.7920859631489 | -122.40164089212 | (37.7920859631489, -122.40164089212) | |||
| 45775 | 45775 | 190241 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 New Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012114.72864 | 2115154.34395 | 37.788492819034296 | -122.40189922508499 | (37.7884928190343, -122.401899225085) |
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");