Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80 | 80 | 225032 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4425 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2004 12:00:00 AM | 11 | Width 3ft | Permit Number 47310 | 6001257.01437 | 2105216.66208 | 37.7605944983664 | -122.43875275812799 | (37.7605944983664, -122.438752758128) | |
| 87 | 87 | 11032 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007492.86428 | 2117507.22815 | 37.794694232707 | -122.41805706457599 | (37.794694232707, -122.418057064576) | |||
| 116 | 116 | 26163 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999083.87135 | 2119853.9919 | 37.8006609458028 | -122.447322173097 | (37.8006609458028, -122.447322173097) | |||
| 206 | 206 | 4750 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1201 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007660.31382 | 2121409.3470799997 | 37.8054178953714 | -122.417754386066 | (37.8054178953714, -122.417754386066) | |||
| 312 | 312 | 226557 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 320 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 7ft | 6004833.37225 | 2106401.74543 | 37.7640512674875 | -122.42646813862 | (37.7640512674875, -122.42646813862) | |||
| 538 | 538 | 224356 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3122 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 20 | Width 4ft | Permit Number 16121 | 6005963.44888 | 2106707.74991 | 37.7649553019601 | -122.422581275918 | (37.7649553019601, -122.422581275918) | |
| 540 | 540 | 224369 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3159 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | 16 | Width 3ft | Permit Number 18874 | 6005753.01157 | 2106639.16646 | 37.7647551137777 | -122.423304250809 | (37.7647551137777, -122.423304250809) | |
| 542 | 542 | 224353 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3024 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6006632.75905 | 2106740.0972599997 | 37.7650818572521 | -122.42026859194901 | (37.7650818572521, -122.420268591949) | |||
| 544 | 544 | 224355 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3120 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 23 | Width 6ft | Permit Number 16120 | 6005992.7506800005 | 2106707.14788 | 37.7649553019752 | -122.42247988543501 | (37.7649553019752, -122.422479885435) | |
| 559 | 559 | 224354 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3030 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 21 | Width 4ft | Permit Number 16115 | 6006614.25148 | 2106740.2812200002 | 37.7650813194782 | -122.420332618267 | (37.7650813194782, -122.420332618267) | |
| 728 | 728 | 2813 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009225.04881 | 2116342.3210299998 | 37.7915930222591 | -122.41198109107599 | (37.7915930222591, -122.411981091076) | |||
| 910 | 910 | 7954 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1756 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6005736.45543 | 2116153.36588 | 37.7908778543671 | -122.424038156058 | (37.7908778543671, -122.424038156058) | |||
| 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) | ||
| 1450 | 1450 | 18855 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2222 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6003966.78981 | 2116014.3774900003 | 37.790396155900105 | -122.43015119962 | (37.7903961559001, -122.43015119962) | |||
| 1678 | 1678 | 25510 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1845 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005220.005340001 | 2116049.4982 | 37.7905634882709 | -122.42581765535401 | (37.7905634882709, -122.425817655354) | |||
| 1777 | 1777 | 251693 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 1783 | 1783 | 251690 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 1786 | 1786 | 251694 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 1960 | 1960 | 18692 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999079.26803 | 2119858.05546 | 37.800671840202796 | -122.447338395052 | (37.8006718402028, -122.447338395052) | |||
| 2013 | 2013 | 225525 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 27 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1981 12:00:00 AM | 25 | Width 3ft | Permit Number 19152 | 6003169.56249 | 2108141.44694 | 37.7687338691973 | -122.432347023007 | (37.7687338691973, -122.432347023007) | |
| 2116 | 2116 | 11044 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1550 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 6007464.945230001 | 2117711.8455 | 37.795254489665 | -122.418168182118 | (37.795254489665, -122.418168182118) | |||
| 2140 | 2140 | 225336 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3030 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1980 12:00:00 AM | 15 | Width 2ft | Permit Number 18789 | 6002856.92306 | 2096000.60547 | 37.7353802609748 | -122.43256110120899 | (37.7353802609748, -122.432561101209) | |
| 2157 | 2157 | 127892 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 20 | Width 4ft | Resulted descion 9/7/16 -DE | 6010045.66816 | 2119169.32215 | 37.7994012851886 | -122.40934133534999 | (37.7994012851886, -122.40934133535) | |
| 2161 | 2161 | 127894 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6010099.45524 | 2119176.61212 | 37.7994243150494 | -122.40915572694999 | (37.7994243150494, -122.40915572695) | |||
| 2469 | 2469 | 48871 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 535 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2002 12:00:00 AM | 12 | 3x3 | Permit Number 46080 | 6011476.385009999 | 2118326.9888400002 | 37.797168496982 | -122.404331203243 | (37.797168496982, -122.404331203243) | |
| 2586 | 2586 | 225598 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 236 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/1986 12:00:00 AM | 16 | Width 3ft | Permit Number 22999 | 6003567.57753 | 2109171.0221700002 | 37.771583391799396 | -122.431043812717 | (37.7715833917994, -122.431043812717) | |
| 2653 | 2653 | 116000 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1454 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6008456.02855 | 2117561.49656 | 37.7948974030383 | -122.41472821952499 | (37.7948974030383, -122.414728219525) | |||
| 2659 | 2659 | 253154 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1454 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008456.02855 | 2117561.49656 | 37.7948974030383 | -122.41472821952499 | (37.7948974030383, -122.414728219525) | ||||
| 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) | ||
| 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) | ||
| 3018 | 3018 | 128709 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4x Columbus Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 19 | Width 9ft | 6011726.08303 | 2117794.9108 | 37.795721488711294 | -122.403429729102 | (37.7957214887113, -122.403429729102) | |||
| 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) | |
| 3564 | 3564 | 127915 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1175 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6007842.32885 | 2121243.82267 | 37.8049736482837 | -122.417112761139 | (37.8049736482837, -122.417112761139) | |||
| 3574 | 3574 | 127916 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1175 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007863.0053199995 | 2121226.60678 | 37.8049275409425 | -122.417039987112 | (37.8049275409425, -122.417039987112) | |||
| 3725 | 3725 | 51148 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1600X North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 47562 | 6003040.244080001 | 2121015.99755 | 37.804076787673104 | -122.43371460583799 | (37.8040767876731, -122.433714605838) | ||
| 3741 | 3741 | 11063 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1706 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X4 | 6007392.7334199995 | 2118206.86499 | 37.7966096249815 | -122.418453164696 | (37.7966096249815, -122.418453164696) | |||
| 3872 | 3872 | 62953 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1439 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1986 12:00:00 AM | 14 | 3x3 | Permit Number 23336 | 6006137.63839 | 2118621.23272 | 37.797676639130295 | -122.42282554258101 | (37.7976766391303, -122.422825542581) | |
| 3958 | 3958 | 49965 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1809 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2004 12:00:00 AM | 7 | Permit Number 47574 | 5999971.572269999 | 2115235.0808 | 37.7880293201371 | -122.443918325478 | (37.7880293201371, -122.443918325478) | ||
| 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) | |
| 4314 | 4314 | 100306 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1434 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769213 | 6008902.154180001 | 2117844.1551 | 37.795698569500104 | -122.413204553065 | (37.7956985695001, -122.413204553065) | |
| 4476 | 4476 | 94930 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1771 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004538.80013 | 2118744.2703 | 37.7979241280397 | -122.428366733352 | (37.7979241280397, -122.428366733352) | |||
| 4543 | 4543 | 224782 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3870 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/1976 12:00:00 AM | 23 | Width 4ft | Permit Number 16267 | 6004694.83499 | 2101360.27534 | 37.7502007447699 | -122.426588281746 | (37.7502007447699, -122.426588281746) | |
| 5196 | 5196 | 225446 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4633 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1979 12:00:00 AM | 14 | Width 3ft | Permit Number 18031 | 6000267.22366 | 2105166.93872 | 37.760401610855496 | -122.442172414947 | (37.7604016108555, -122.442172414947) | |
| 5232 | 5232 | 11064 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1718 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x4 | 6007387.23956 | 2118261.4099 | 37.79675908240829 | -122.418476044354 | (37.7967590824083, -122.418476044354) | |||
| 5276 | 5276 | 64629 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1824 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1988 12:00:00 AM | 12 | 3x3 | Permit Number 25539 | 6004249.16577 | 2118756.87495 | 37.7979423438312 | -122.429369849745 | (37.7979423438312, -122.429369849745) | |
| 5365 | 5365 | 23511 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2642 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005783.8382 | 2119486.2694099997 | 37.8000318412439 | -122.42411133926599 | (37.8000318412439, -122.424111339266) | |||
| 5444 | 5444 | 7347 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2226 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6002843.64008 | 2115975.51024 | 37.790225759563 | -122.43403443894199 | (37.790225759563, -122.434034438942) | |||
| 5474 | 5474 | 23494 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2517 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6005746.70695 | 2119056.5774 | 37.7988499198478 | -122.424209251152 | (37.7988499198478, -122.424209251152) | |||
| 5534 | 5534 | 11055 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1623 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007391.69604 | 2117910.02014 | 37.7957945046705 | -122.41843569535 | (37.7957945046705, -122.41843569535) | |||
| 5848 | 5848 | 2810 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009146.78627 | 2116331.3706 | 37.7915585638337 | -122.412251105309 | (37.7915585638337, -122.412251105309) | |||
| 5933 | 5933 | 11024 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1421 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 6007479.55159 | 2117260.34001 | 37.7940155898903 | -122.418085617153 | (37.7940155898903, -122.418085617153) | |||
| 6013 | 6013 | 95273 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004855.86616 | 2110874.93767 | 37.776334844721 | -122.42670890691299 | (37.776334844721, -122.426708906913) | |||
| 6046 | 6046 | 69534 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2471 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38589 | 6002877.05945 | 2116466.93377 | 37.7915769792578 | -122.433953952308 | (37.7915769792578, -122.433953952308) | |
| 6246 | 6246 | 44214 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2296 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2001 12:00:00 AM | 7 | 3x3 | Permit Number 43661 | 6002622.65854 | 2117834.05168 | 37.7953162919605 | -122.434931989341 | (37.7953162919605, -122.434931989341) | |
| 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) | |
| 6366 | 6366 | 26161 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999103.92002 | 2119837.46914 | 37.800616724342206 | -122.447251606892 | (37.8006167243422, -122.447251606892) | |||
| 6450 | 6450 | 18841 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2085 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6004830.024730001 | 2116087.16929 | 37.79064487779711 | -122.427169650269 | (37.7906448777971, -122.427169650269) | |||
| 6618 | 6618 | 11039 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1530 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007477.10012 | 2117617.5169599997 | 37.7949961710995 | -122.418119433479 | (37.7949961710995, -122.418119433479) | |||
| 6866 | 6866 | 11041 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1535 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007427.37776 | 2117642.45986 | 37.7950618593598 | -122.418293249932 | (37.7950618593598, -122.418293249932) | |||
| 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) | |
| 6869 | 6869 | 61837 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1945 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2014 12:00:00 AM | 8 | 3x3 | Permit Number 772931 | 6005379.73194 | 2116818.03322 | 37.792682717295 | -122.425319723246 | (37.792682717295, -122.425319723246) | |
| 6910 | 6910 | 2812 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009199.61723 | 2116339.14024 | 37.7915828617187 | -122.41206885950301 | (37.7915828617187, -122.412068859503) | |||
| 6920 | 6920 | 11030 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1456 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007504.98953 | 2117411.4555 | 37.7944319472334 | -122.418008316826 | (37.7944319472334, -122.418008316826) | |||
| 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) | ||
| 7126 | 7126 | 18854 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2222 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003994.67741 | 2116017.3776 | 37.790405972895705 | -122.430054924512 | (37.7904059728957, -122.430054924512) | |||
| 7378 | 7378 | 2811 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009171.094 | 2116334.89627 | 37.791569608406895 | -122.412167249844 | (37.7915696084069, -122.412167249844) | |||
| 7383 | 7383 | 11062 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1706 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X4 | 6007399.48222 | 2118181.2662299997 | 37.796539717095 | -122.418427996257 | (37.796539717095, -122.418427996257) | |||
| 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) | |
| 7546 | 7546 | 7345 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2201 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/1995 12:00:00 AM | 20 | 3x3 | 6002814.8619099995 | 2115881.6003099997 | 37.789966273667396 | -122.434127293036 | (37.7899662736674, -122.434127293036) | ||
| 7684 | 7684 | 101521 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3010 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | Permit Number 23924 | 6000238.846469999 | 2115823.4476799998 | 37.7896600644188 | -122.443035877412 | (37.7896600644188, -122.443035877412) | ||
| 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) | |
| 7865 | 7865 | 4751 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1201 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007679.06678 | 2121391.72732 | 37.8053705712658 | -122.41768823913601 | (37.8053705712658, -122.417688239136) | |||
| 7892 | 7892 | 18840 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2085 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6004805.00638 | 2116081.2171099996 | 37.790627119781796 | -122.42725578824499 | (37.7906271197818, -122.427255788245) | |||
| 7903 | 7903 | 23532 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1991 12:00:00 AM | 9 | 3x3 | 6005730.01613 | 2119881.88283 | 37.8011150557677 | -122.42432573765801 | (37.8011150557677, -122.424325737658) | ||
| 7916 | 7916 | 63582 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1370 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1987 12:00:00 AM | 7 | 3x3 | Permit Number 24205 | 6006460.0817 | 2118715.02595 | 37.797952359573 | -122.42171646446998 | (37.797952359573, -122.42171646447) |
| 7986 | 7986 | 7370 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2420 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002758.068969999 | 2116587.9502 | 37.7919025059375 | -122.434374313431 | (37.7919025059375, -122.434374313431) | |||
| 8053 | 8053 | 11067 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1730 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007383.1618099995 | 2118299.02577 | 37.7968621366329 | -122.418492822987 | (37.7968621366329, -122.418492822987) | |||
| 8211 | 8211 | 11042 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1540 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007470.84511 | 2117656.01984 | 37.7951015383692 | -122.41814380780501 | (37.7951015383692, -122.418143807805) | |||
| 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) | ||
| 8307 | 8307 | 101022 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1979 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003568.32546 | 2118610.54777 | 37.7975019979781 | -122.431715296927 | (37.7975019979781, -122.431715296927) | |||
| 8312 | 8312 | 23512 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2645 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005692.662819999 | 2119431.12255 | 37.7998752737922 | -122.424422916606 | (37.7998752737922, -122.424422916606) | |||
| 8378 | 8378 | 11035 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1516 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007484.17478 | 2117558.36602 | 37.794834155515396 | -122.418090758582 | (37.7948341555154, -122.418090758582) | |||
| 8391 | 8391 | 7856 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 915 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006092.78469 | 2113271.83344 | 37.782985990458606 | -122.422600419785 | (37.7829859904586, -122.422600419785) | |||
| 8446 | 8446 | 11434 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6011450.63994 | 2118045.46213 | 37.7963940539012 | -122.404400461805 | (37.7963940539012, -122.404400461805) | |||
| 8559 | 8559 | 18852 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2222 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6004015.42398 | 2116022.3127099997 | 37.7904206984174 | -122.42998349495701 | (37.7904206984174, -122.429983494957) | |||
| 8577 | 8577 | 11027 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1441 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | owner Victor Seeto signed agreement 3/10/10 to maintain bricks in tree basin in a safe/accessible manner that does not damage tree or restrict growth. | 6007472.87331 | 2117336.51186 | 37.7942243630038 | -122.418114127466 | (37.7942243630038, -122.418114127466) | ||
| 8605 | 8605 | 11123 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2112 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 6007201.8852 | 2119594.93778 | 37.8004101788341 | -122.419212056698 | (37.8004101788341, -122.419212056698) | |||
| 8771 | 8771 | 59654 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1119 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1981 12:00:00 AM | 22 | Permit Number 19075 | 6009431.860719999 | 2117187.86787 | 37.7939262890147 | -122.41132528024201 | (37.7939262890147, -122.411325280242) | ||
| 8783 | 8783 | 7373 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2440 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002748.17801 | 2116678.1241200003 | 37.7921495389154 | -122.43441498617901 | (37.7921495389154, -122.434414986179) | |||
| 8787 | 8787 | 11101 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1954 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007270.585390001 | 2119081.1863 | 37.7990034152267 | -122.418937867815 | (37.7990034152267, -122.418937867815) | |||
| 8800 | 8800 | 63349 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3010 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1987 12:00:00 AM | 16 | 4x4 | Permit Number 23924 | 6000255.01215 | 2115823.74708 | 37.7896618081804 | -122.442979967475 | (37.7896618081804, -122.442979967475) | |
| 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) | ||
| 8889 | 8889 | 43937 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2110 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2000 12:00:00 AM | 24 | 3x3 | Permit Number 43525 | 6001410.86266 | 2115802.65362 | 37.7896697231319 | -122.438979337847 | (37.7896697231319, -122.438979337847) | |
| 8948 | 8948 | 7955 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1756 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005731.7408300005 | 2116171.91633 | 37.790928523081895 | -122.424055788151 | (37.7909285230819, -122.424055788151) | |||
| 8954 | 8954 | 25509 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1845 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005217.05884 | 2116064.11045 | 37.7906034433315 | -122.42582889061701 | (37.7906034433315, -122.425828890617) | |||
| 8961 | 8961 | 11020 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1406 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007534.84234 | 2117200.48968 | 37.793854367544206 | -122.417890060478 | (37.7938543675442, -122.417890060478) | |||
| 8996 | 8996 | 23493 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2513 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6005749.93573 | 2119032.39279 | 37.798783697364705 | -122.42419635758499 | (37.7987836973647, -122.424196357585) | |||
| 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) | ||
| 9981 | 9981 | 56353 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 157 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1973 12:00:00 AM | 5x5 | Permit Number 12495 | 6002706.41661255 | 2104989.75216117 | 37.7600538090993 | -122.43372372180401 | (37.7600538090993, -122.433723721804) |
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");