Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, PlantDate, XCoord
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8278 | 8278 | 50402 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 3726 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2003 12:00:00 AM | Permit Number 47053 | ||||||||
| 10323 | 10323 | 50014 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 581@ 20TH ST Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2003 12:00:00 AM | Permit Number 46745 | ||||||||
| 18705 | 18705 | 42887 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 1739 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | Permit Number 42808 | 5987843.90259006 | 2098938.15933649 | 37.7425832072354 | -122.48468147222799 | (37.7425832072354, -122.484681472228) | ||
| 77570 | 77570 | 47323 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 201 Ashton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45255 | 5994138.72426845 | 2091199.26813368 | 37.721698703569004 | -122.46235480758301 | (37.721698703569, -122.462354807583) | ||
| 78268 | 78268 | 42501 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 101 Ridgewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42616 | 5996768.04067706 | 2094421.62938142 | 37.7306975968961 | -122.45349854998699 | (37.7306975968961, -122.453498549987) | ||
| 78692 | 78692 | 42298 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 401 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42525 | 5999402.29017488 | 2094374.77593612 | 37.7307196006106 | -122.444388207964 | (37.7307196006106, -122.444388207964) | ||
| 79504 | 79504 | 42888 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 2249 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | Permit Number 42809 | 5989078.02939805 | 2098299.22635705 | 37.7409006601769 | -122.480367515353 | (37.7409006601769, -122.480367515353) | ||
| 80102 | 80102 | 42877 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 2600 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | Permit Number 42800 | 5986177.48540908 | 2097539.56979109 | 37.73864586337471 | -122.49034051302401 | (37.7386458633747, -122.490340513024) | ||
| 80277 | 80277 | 42015 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 81 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2000 12:00:00 AM | Permit Number 43553 | 5993407.44518311 | 2093531.37372374 | 37.7280599601346 | -122.46505192020001 | (37.7280599601346, -122.4650519202) | ||
| 83419 | 83419 | 47372 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 800 Shields St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | ||
| 89379 | 89379 | 42435 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 526 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42583 | 5996932.58784126 | 2093645.66411185 | 37.7285764124533 | -122.45287370077101 | (37.7285764124533, -122.452873700771) | ||
| 89443 | 89443 | 42886 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 1739 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | Permit Number 42808 | 5987843.90259006 | 2098938.15933649 | 37.7425832072354 | -122.48468147222799 | (37.7425832072354, -122.484681472228) | ||
| 89808 | 89808 | 42878 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 2600 33rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | Permit Number 42800 | 5986177.48540908 | 2097539.56979109 | 37.73864586337471 | -122.49034051302401 | (37.7386458633747, -122.490340513024) | ||
| 90279 | 90279 | 47389 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 635 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2002 12:00:00 AM | Permit Number 45305 | 5995307.12304943 | 2111228.84988639 | 37.7767621096957 | -122.45976608355 | (37.7767621096957, -122.45976608355) | ||
| 91556 | 91556 | 50253 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 4 Appleton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2003 12:00:00 AM | Permit Number 46960 | 6005419.03664412 | 2097155.63101226 | 37.73869666428679 | -122.42378501200001 | (37.7386966642868, -122.423785012) | |||
| 96149 | 96149 | 42473 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 50 Phelan Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997089.26501 | 2092291.2060099998 | 37.7248663685681 | -122.45223437006399 | (37.7248663685681, -122.452234370064) | ||
| 96217 | 96217 | 47361 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 495 Ralston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45282 | 5992197.59018482 | 2091172.33754059 | 37.7215127906483 | -122.46906277657601 | (37.7215127906483, -122.469062776576) | ||
| 98457 | 98457 | 42876 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 2600 33rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | Permit Number 42800 | 5986177.48540908 | 2097539.56979109 | 37.73864586337471 | -122.49034051302401 | (37.7386458633747, -122.490340513024) | ||
| 98710 | 98710 | 42474 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 50 Phelan Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997089.26501 | 2092315.0780099998 | 37.7249319154444 | -122.45223609177499 | (37.7249319154444, -122.452236091775) | ||
| 100397 | 100397 | 42879 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 2600 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | Permit Number 42800 | 5986177.48540908 | 2097539.56979109 | 37.73864586337471 | -122.49034051302401 | (37.7386458633747, -122.490340513024) | ||
| 100695 | 100695 | 42500 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 101 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42616 | 5996768.04067706 | 2094421.62938142 | 37.7306975968961 | -122.45349854998699 | (37.7306975968961, -122.453498549987) | ||
| 102136 | 102136 | 49834 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 581 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | Permit Number 46617 | 6014418.96350161 | 2104425.38264517 | 37.7591618171233 | -122.393175831182 | (37.7591618171233, -122.393175831182) | ||
| 102212 | 102212 | 50252 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 4 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2003 12:00:00 AM | Permit Number 46960 | 6005419.03664412 | 2097155.63101226 | 37.73869666428679 | -122.42378501200001 | (37.7386966642868, -122.423785012) | |||
| 103546 | 103546 | 50488 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 224 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47125 | 5995376.09741425 | 2091446.59628011 | 37.7224489821589 | -122.458095453799 | (37.7224489821589, -122.458095453799) | ||
| 104372 | 104372 | 42436 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 526 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42583 | 5996932.58784126 | 2093645.66411185 | 37.7285764124533 | -122.45287370077101 | (37.7285764124533, -122.452873700771) | ||
| 105086 | 105086 | 45538 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 79 Melba Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | Permit Number 44293 | 5989585.76469698 | 2094846.08328142 | 37.7314487101847 | -122.478359538262 | (37.7314487101847, -122.478359538262) | ||
| 106811 | 106811 | 43035 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 520 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/2000 12:00:00 AM | Permit Number 42895 | 5996958.36097838 | 2093644.93577549 | 37.728575889514296 | -122.45278454952299 | (37.7285758895143, -122.452784549523) | ||
| 107123 | 107123 | 42483 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 50 Phelan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997089.26501 | 2092270.59001 | 37.7248097618985 | -122.452232883188 | (37.7248097618985, -122.452232883188) | ||
| 108558 | 108558 | 42434 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 374 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42582 | 5997611.16867928 | 2093578.88290299 | 37.728431909867396 | -122.450523007754 | (37.7284319098674, -122.450523007754) | ||
| 109401 | 109401 | 47324 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 201 Ashton Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45255 | 5994138.72426845 | 2091199.26813368 | 37.721698703569004 | -122.46235480758301 | (37.721698703569, -122.462354807583) | ||
| 109562 | 109562 | 43119 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 300 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2000 12:00:00 AM | Permit Number 42941 | 6006621.15716652 | 2097502.62281264 | 37.7397172147751 | -122.41965325285601 | (37.7397172147751, -122.419653252856) | ||
| 109960 | 109960 | 51956 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 1017 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2005 12:00:00 AM | 4 | Permit Number 48178 | 5996068.27865943 | 2098393.97710134 | 37.7415645589841 | -122.456204821502 | (37.7415645589841, -122.456204821502) | ||
| 110456 | 110456 | 51239 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 4 Appleton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2004 12:00:00 AM | Permit Number 47610 | 6005419.03664412 | 2097155.63101226 | 37.73869666428679 | -122.42378501200001 | (37.7386966642868, -122.423785012) | |||
| 112989 | 112989 | 43207 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 327 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | Permit Number 42999 | 6008918.68927516 | 2094576.25523687 | 37.7318111956539 | -122.41150263987801 | (37.7318111956539, -122.411502639878) | ||
| 113539 | 113539 | 43600 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 2100 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43258 | 5986372.72253095 | 2100934.40713688 | 37.747978578910896 | -122.489915100755 | (37.7479785789109, -122.489915100755) | ||
| 114783 | 114783 | 43117 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 237 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2000 12:00:00 AM | Permit Number 42940 | 6006781.71304708 | 2097794.65003226 | 37.7405280993025 | -122.41911882648 | (37.7405280993025, -122.41911882648) | ||
| 115151 | 115151 | 49891 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 511@ FORESTER Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2003 12:00:00 AM | Permit Number 46664 | 5998039.61077628 | 2095232.18664158 | 37.732996003551705 | -122.449160927486 | (37.7329960035517, -122.449160927486) | |||
| 122749 | 122749 | 42297 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 401 Detroit St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42525 | 5999402.29017488 | 2094374.77593612 | 37.7307196006106 | -122.444388207964 | (37.7307196006106, -122.444388207964) | ||
| 124332 | 124332 | 52277 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 84 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48439 | 6003312.99624288 | 2097866.34980507 | 37.7405290204798 | -122.431117412884 | (37.7405290204798, -122.431117412884) | ||
| 125324 | 125324 | 42475 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 50 Phelan Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997094.69001 | 2092340.0340099998 | 37.725000749505895 | -122.45221913814 | (37.7250007495059, -122.45221913814) | ||
| 126382 | 126382 | 43601 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 2100 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43258 | 5986372.72253095 | 2100934.40713688 | 37.747978578910896 | -122.489915100755 | (37.7479785789109, -122.489915100755) | ||
| 127422 | 127422 | 47362 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 495 Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45282 | 5992197.59018482 | 2091172.33754059 | 37.7215127906483 | -122.46906277657601 | (37.7215127906483, -122.469062776576) | ||
| 128948 | 128948 | 42503 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 236 Ridgewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42617 | 5996826.95711969 | 2094829.91589439 | 37.7318220309584 | -122.453324333247 | (37.7318220309584, -122.453324333247) | ||
| 129451 | 129451 | 47360 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 495 Ralston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45282 | 5992197.59018482 | 2091172.33754059 | 37.7215127906483 | -122.46906277657601 | (37.7215127906483, -122.469062776576) | ||
| 139261 | 139261 | 46847 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 198 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44916 | 6004181.50847912 | 2092412.60436793 | 37.72560343989 | -122.42772595157301 | (37.72560343989, -122.427725951573) | ||
| 139992 | 139992 | 51240 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 4 Appleton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2004 12:00:00 AM | Permit Number 47610 | 6005419.03664412 | 2097155.63101226 | 37.73869666428679 | -122.42378501200001 | (37.7386966642868, -122.423785012) | |||
| 141228 | 141228 | 47329 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 1018 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45260 | 5995067.13121355 | 2090703.83485678 | 37.7203917790929 | -122.45910971527701 | (37.7203917790929, -122.459109715277) | ||
| 145748 | 145748 | 42108 | Permitted Site 1 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 248 | 574 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42410 | 5997621.59809566 | 2094424.68067867 | 37.7307548669325 | -122.45054790421699 | (37.7307548669325, -122.450547904217) |
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");