Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25175 | 25175 | 34531 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 635 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | 5 | Permit Number 38240 | 5988437.8449 | 2111647.649 | 37.7775145896121 | -122.483559386935 | (37.7775145896121, -122.483559386935) | ||
| 26432 | 26432 | 141346 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 463 BRODERICK ST | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6001145.1037 | 2110334.7664 | 37.774641176317104 | -122.439506706044 | (37.7746411763171, -122.439506706044) | |||
| 27566 | 27566 | 200054 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1800 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014879.1353 | 2094151.956 | 37.73097868287971 | -122.39086633517 | (37.7309786828797, -122.39086633517) | |||
| 29132 | 29132 | 31972 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995228.46958 | 2114784.79077 | 37.786521248530995 | -122.46029586964701 | (37.786521248531, -122.460295869647) | |
| 29438 | 29438 | 31973 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995224.68838 | 2114814.58842 | 37.7866028473263 | -122.460311111336 | (37.7866028473263, -122.460311111336) | |
| 31525 | 31525 | 214031 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 119 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997420.89454 | 2093944.4368 | 37.7294247417474 | -122.45120714359501 | (37.7294247417474, -122.451207143595) | |||
| 31765 | 31765 | 214029 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000729.59206 | 2094530.6160900001 | 37.7312231430208 | -122.43981069901301 | (37.7312231430208, -122.439810699013) | |||
| 35612 | 35612 | 72078 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 167 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 5 | 5989583.57132 | 2114255.42421 | 37.784741432124 | -122.479786850818 | (37.784741432124, -122.479786850818) | ||
| 38309 | 38309 | 120769 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4500 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5989405.82896 | 2109925.10593 | 37.7728412569544 | -122.48008475013701 | (37.7728412569544, -122.480084750137) | |||
| 41388 | 41388 | 75003 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3501 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 5 | 5997399.304819999 | 2116036.40743 | 37.7900824867734 | -122.452875730442 | (37.7900824867734, -122.452875730442) | ||
| 44130 | 44130 | 41755 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1630 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 5 | Permit Number 42184 | 6008378.01882 | 2118113.9596 | 37.79640994672071 | -122.415037267971 | (37.7964099467207, -122.415037267971) | ||
| 47391 | 47391 | 197344 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 670 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6012519.5716699995 | 2113947.09446 | 37.785200579973605 | -122.40041369075199 | (37.7852005799736, -122.400413690752) | |||
| 48717 | 48717 | 214026 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 124 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6000776.43659 | 2094502.29985 | 37.7311480595383 | -122.43964672023199 | (37.7311480595383, -122.439646720232) | |||
| 59339 | 59339 | 197337 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 501 Amador St | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6017571.01278 | 2099537.71438 | 37.7459158925037 | -122.381934448315 | (37.7459158925037, -122.381934448315) | |||
| 61274 | 61274 | 197334 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1098 Mississippi St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014199.99182 | 2102083.0983599997 | 37.7527182412529 | -122.39376919728501 | (37.7527182412529, -122.393769197285) | |||
| 63135 | 63135 | 82850 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1457 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52367 | 6015981.5985 | 2094038.4652 | 37.730728169212 | -122.387046987845 | (37.730728169212, -122.387046987845) | |
| 68181 | 68181 | 47745 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 5 | Permit Number 45527 | 5982377.51547 | 2113061.47559 | 37.7810419369254 | -122.50462850953998 | (37.7810419369254, -122.50462850954) | |
| 70290 | 70290 | 136305 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1110 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008618.494469999 | 2116385.90895 | 37.7916786547855 | -122.414082854345 | (37.7916786547855, -122.414082854345) | |||
| 70411 | 70411 | 41218 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 21 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 5 | Permit Number 41926 | 6001937.22199 | 2119965.3728 | 37.8011293999489 | -122.43745640431001 | (37.8011293999489, -122.43745640431) | |
| 71181 | 71181 | 240388 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008348.72479 | 2098315.88712 | 37.742047422761296 | -122.413737549756 | (37.7420474227613, -122.413737549756) | |||
| 75380 | 75380 | 40197 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983545.15866 | 2111697.12052 | 37.7773644306872 | -122.50048820674401 | (37.7773644306872, -122.500488206744) | |
| 115944 | 115944 | 69045 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1490 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 5 | Permit Number 33052 | 5984059.2399452 | 2105030.87804217 | 37.7590909914126 | -122.498217402727 | (37.7590909914126, -122.498217402727) | |
| 116622 | 116622 | 214030 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000729.565880001 | 2094512.14983 | 37.7311724374522 | -122.439809466051 | (37.7311724374522, -122.439809466051) | |||
| 119499 | 119499 | 40199 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983584.60152 | 2111699.05511 | 37.7773720577908 | -122.500351906273 | (37.7773720577908, -122.500351906273) | |
| 130150 | 130150 | 240411 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 235 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001924.04211 | 2096180.04982 | 37.7358200267578 | -122.435799247861 | (37.7358200267578, -122.435799247861) | |||
| 132729 | 132729 | 197335 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1512 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014078.36763 | 2102008.61135 | 37.7525069563416 | -122.394184584264 | (37.7525069563416, -122.394184584264) | |||
| 134645 | 134645 | 214022 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 659 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997050.53703 | 2094389.3323099997 | 37.7306251064676 | -122.45251959171101 | (37.7306251064676, -122.452519591711) | |||
| 135840 | 135840 | 117962 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4340 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5985111.43248 | 2111810.6865 | 37.7777680685843 | -122.495078411045 | (37.7777680685843, -122.495078411045) | |||
| 137058 | 137058 | 136304 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1110 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008621.3641800005 | 2116364.4323 | 37.791619846337 | -122.414071405095 | (37.791619846337, -122.414071405095) | |||
| 142203 | 142203 | 197348 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 776 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009001.8467 | 2110254.60923 | 37.7748650979682 | -122.412322898178 | (37.7748650979682, -122.412322898178) | |||
| 146433 | 146433 | 142182 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001064.3503 | 2110400.0934 | 37.7748159516075 | -122.439790732155 | (37.7748159516075, -122.439790732155) | |||
| 147065 | 147065 | 32517 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 837 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | 5 | Permit Number 39421 | 6007583.92915 | 2095468.81341 | 37.734187007231796 | -122.41618038453998 | (37.7341870072318, -122.41618038454) | |
| 147113 | 147113 | 184465 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2182 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5982354.8718 | 2100269.3302 | 37.745917034436296 | -122.503759179813 | (37.7459170344363, -122.503759179813) | |||
| 148592 | 148592 | 179377 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 11 Cross St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000163.43149 | 2088211.60643 | 37.7138403432439 | -122.441314779179 | (37.7138403432439, -122.441314779179) | |||
| 155475 | 155475 | 199669 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1909 Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015195.1623 | 2093397.888 | 37.7289256934462 | -122.38972111920602 | (37.7289256934462, -122.389721119206) | |||
| 155906 | 155906 | 183281 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1267 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981168.1745 | 2106457.5745 | 37.762838347579006 | -122.50832180491899 | (37.762838347579, -122.508321804919) | |||
| 157856 | 157856 | 197349 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 776 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008993.795609999 | 2110246.5783 | 37.7748425951336 | -122.412350180929 | (37.7748425951336, -122.412350180929) | |||
| 157900 | 157900 | 240389 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008913.61949 | 2096192.37009 | 37.7362484143157 | -122.41163431247601 | (37.7362484143157, -122.411634312476) | |||
| 161544 | 161544 | 136308 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1110 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008610.17492 | 2116437.5189799997 | 37.7918198960214 | -122.414115292883 | (37.7918198960214, -122.414115292883) | |||
| 161972 | 161972 | 47744 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 5 | Permit Number 45527 | 5982434.29257 | 2113064.02501 | 37.7810522765206 | -122.504432281557 | (37.7810522765206, -122.504432281557) | |
| 164904 | 164904 | 136309 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1110 Jones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008608.17525 | 2116456.59832 | 37.791872170904796 | -122.41412356216999 | (37.7918721709048, -122.41412356217) | |||
| 164927 | 164927 | 240387 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 310 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008249.57192 | 2097137.15027 | 37.7388053020181 | -122.41399702216002 | (37.7388053020181, -122.41399702216) | |||
| 166318 | 166318 | 136303 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1110 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008623.1195 | 2116351.39928 | 37.7915841594399 | -122.414064409258 | (37.7915841594399, -122.414064409258) | |||
| 169762 | 169762 | 240386 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 310 Gates St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008247.18934 | 2097121.53396 | 37.738762289236895 | -122.41400415558998 | (37.7387622892369, -122.41400415559) | |||
| 171047 | 171047 | 214038 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 638 Head St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993525.3619099995 | 2090091.0611400001 | 37.718620496206796 | -122.46439460152901 | (37.7186204962068, -122.464394601529) | |||
| 172426 | 172426 | 240394 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 27 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001499.24152 | 2098615.40839 | 37.742482813337 | -122.43744228675301 | (37.742482813337, -122.437442286753) | |||
| 172891 | 172891 | 51254 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 258 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50492 | 6005094.58295 | 2093781.1160400002 | 37.7294126791284 | -122.42466683341699 | (37.7294126791284, -122.424666833417) | |
| 177929 | 177929 | 136312 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1201 Sacramento St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008787.57627 | 2116642.7504 | 37.792393373904204 | -122.41351600355499 | (37.7923933739042, -122.413516003555) | |||
| 178425 | 178425 | 42274 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1522 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 5 | Permit Number 42512 | 5987167.45157267 | 2104900.21174724 | 37.7589139779601 | -122.48745827105 | (37.7589139779601, -122.48745827105) | |
| 180367 | 180367 | 240385 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 310 Gates St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008245.55924 | 2097104.87481 | 37.738716455307795 | -122.41400861353 | (37.7387164553078, -122.41400861353) | |||
| 181218 | 181218 | 247182 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 21 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001135.9574 | 2108807.3946 | 37.770446875354295 | -122.439428836098 | (37.7704468753543, -122.439428836098) | |||
| 185123 | 185123 | 42676 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1097 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42702 | 6007858.06857 | 2118865.16486 | 37.7984433372469 | -122.41688966093399 | (37.7984433372469, -122.416889660934) | ||
| 185994 | 185994 | 181319 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1283 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989233.7879 | 2106609.7025 | 37.7637280687606 | -122.48043712751101 | (37.7637280687606, -122.480437127511) | |||
| 186937 | 186937 | 42675 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1097 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42702 | 6007843.31475 | 2118863.44983 | 37.7984377983088 | -122.416940592258 | (37.7984377983088, -122.416940592258) | ||
| 187103 | 187103 | 184430 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3808 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981643.6784 | 2100823.1575 | 37.747395847077996 | -122.50625940628099 | (37.747395847078, -122.506259406281) | |||
| 187182 | 187182 | 247984 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009751.76686 | 2099644.8640900003 | 37.745775193576705 | -122.408980002136 | (37.7457751935767, -122.408980002136) |
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");