Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7458 | 7458 | 18926 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 2689 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001985.03027 | 2115691.49541 | 37.7893971628975 | -122.43698481780599 | (37.7893971628975, -122.436984817806) | |||
22388 | 22388 | 7124 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005782.02097 | 2115033.60586 | 37.787805844908796 | -122.42380084655301 | (37.7878058449088, -122.423800846553) | ||
22516 | 22516 | 7126 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005719.585390001 | 2115024.0954299998 | 37.7877762068484 | -122.42401618562201 | (37.7877762068484, -122.424016185622) | ||
22574 | 22574 | 7125 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005738.176580001 | 2115026.96294 | 37.7877851299198 | -122.42395206753099 | (37.7877851299198, -122.423952067531) | ||
22706 | 22706 | 7127 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005701.71486 | 2115022.2576200003 | 37.7877701517306 | -122.424077883603 | (37.7877701517306, -122.424077883603) | ||
33240 | 33240 | 189153 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012332.534469999 | 2112551.48713 | 37.781358134807796 | -122.400962694499 | (37.7813581348078, -122.400962694499) | |||
33827 | 33827 | 203454 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993011.06637 | 2099068.7919400004 | 37.743241463417796 | -122.466824576891 | (37.7432414634178, -122.466824576891) | |||
35891 | 35891 | 125523 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 6011207.16585 | 2120734.5295700002 | 37.8037639692824 | -122.40543241409401 | (37.8037639692824, -122.405432414094) | |||
40273 | 40273 | 125508 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008930.4214699995 | 2118571.4914 | 37.797697242591504 | -122.41315819931299 | (37.7976972425915, -122.413158199313) | |||
41144 | 41144 | 175153 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 783 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6001323.552619999 | 2092431.0494099997 | 37.7254920046417 | -122.43760697060101 | (37.7254920046417, -122.437606970601) | |||
48809 | 48809 | 125436 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3157 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001892.570830001 | 2119015.7946 | 37.798519569189 | -122.437542875929 | (37.798519569189, -122.437542875929) | |||
49472 | 49472 | 41212 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 6 | Permit Number 41921 | 6002149.73701 | 2121055.69726 | 37.804135222937 | -122.43679910691002 | (37.804135222937, -122.43679910691) | |
50288 | 50288 | 220659 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 998 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009137.788819999 | 2103468.55533 | 37.756239784053996 | -122.41137313676799 | (37.756239784054, -122.411373136768) | |||
50442 | 50442 | 220612 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 9 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009640.52107 | 2098655.41337 | 37.743052146240295 | -122.409294863773 | (37.7430521462403, -122.409294863773) | |||
58353 | 58353 | 125529 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6010076.61244 | 2116904.10673 | 37.793183289838 | -122.40907433472 | (37.793183289838, -122.40907433472) | |||
61016 | 61016 | 125467 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6008702.23207 | 2116269.4831 | 37.791363680726796 | -122.413784882888 | (37.7913636807268, -122.413784882888) | |||
76690 | 76690 | 35734 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 202 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | 6 | Permit Number 47062 | 6010246.45985 | 2093710.9780400002 | 37.7295097141809 | -122.40685127987899 | (37.7295097141809, -122.406851279879) | |
80980 | 80980 | 27672 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
81629 | 81629 | 27670 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
84998 | 84998 | 16401 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
90024 | 90024 | 27668 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
90399 | 90399 | 27665 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
90762 | 90762 | 16404 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
92549 | 92549 | 27666 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
94446 | 94446 | 27669 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
102801 | 102801 | 18245 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1815X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003482.1216 | 2114150.20266 | 37.7852501414757 | -122.43169496628599 | (37.7852501414757, -122.431694966286) | |||
106158 | 106158 | 16913 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 477 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004718.6652 | 2110142.96999 | 37.774317282432705 | -122.42713137468999 | (37.7743172824327, -122.42713137469) | |||
111562 | 111562 | 27667 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.42375144816299 | (37.7888072668978, -122.423751448163) | |||
115405 | 115405 | 24518 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 365 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005518.5465766 | 2115307.531712 | 37.788543099973396 | -122.424731913891 | (37.7885430999734, -122.424731913891) | |||
118179 | 118179 | 125465 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6008661.04402 | 2116264.72933 | 37.7913483149251 | -122.41392705669399 | (37.7913483149251, -122.413927056694) | |||
118715 | 118715 | 27671 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 310 Austin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | |||
120146 | 120146 | 16406 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
121736 | 121736 | 16403 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
122812 | 122812 | 16907 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 452 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004778.478730001 | 2110233.49325 | 37.774569219476206 | -122.426930917012 | (37.7745692194762, -122.426930917012) | |||
123607 | 123607 | 16942 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
133637 | 133637 | 189200 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 625 Mendell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6016323.4017 | 2097117.36023 | 37.7392011179238 | -122.38607986071699 | (37.7392011179238, -122.386079860717) | |||
136884 | 136884 | 125446 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3615 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003103.6015800005 | 2120772.6345599997 | 37.8034121715947 | -122.433477951057 | (37.8034121715947, -122.433477951057) | |||
143787 | 143787 | 16405 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
145083 | 145083 | 16402 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
148413 | 148413 | 203491 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 27 Melrose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999912.45047 | 2095466.00696 | 37.733744960750705 | -122.44270283418899 | (37.7337449607507, -122.442702834189) | |||
148949 | 148949 | 189196 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012020.7847 | 2107509.88543 | 37.767497654832894 | -122.401686734167 | (37.7674976548329, -122.401686734167) | |||
155868 | 155868 | 125451 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2601 Vallejo St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001095.19419 | 2117566.7818299998 | 37.7944955940578 | -122.44019807567499 | (37.7944955940578, -122.440198075675) | |||
160402 | 160402 | 203463 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 112 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6000775.43585 | 2094454.02267 | 37.731015444602896 | -122.43964672024099 | (37.7310154446029, -122.439646720241) | |||
161839 | 161839 | 125503 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1001 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6007472.5485 | 2120196.7006200003 | 37.802077707171605 | -122.418318141382 | (37.8020777071716, -122.418318141382) | |||
163005 | 163005 | 203456 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5993632.52713 | 2093523.8641700002 | 37.7280523169437 | -122.46427326591001 | (37.7280523169437, -122.46427326591) | |||
168630 | 168630 | 249544 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 298 Myrtle St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6006142.8789800005 | 2114042.34322 | 37.7851044469485 | -122.422481881052 | (37.7851044469485, -122.422481881052) | |||
169437 | 169437 | 220616 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 956 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999753.1781 | 2101988.06706 | 37.7516438994494 | -122.44372187666599 | (37.7516438994494, -122.443721876666) | |||
170392 | 170392 | 125444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6002146.17897 | 2121077.47724 | 37.8041948227854 | -122.436812979831 | (37.8041948227854, -122.436812979831) | |||
171065 | 171065 | 125463 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 935 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006804.241090001 | 2113922.09635 | 37.7848115656375 | -122.42018523378599 | (37.7848115656375, -122.420185233786) | |||
174163 | 174163 | 125486 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6007645.270330001 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | ||||
174700 | 174700 | 118571 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7940 Geary Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5982344.86422 | 2112440.78156 | 37.779335773230294 | -122.50469546097601 | (37.7793357732303, -122.504695460976) | ||||
175547 | 175547 | 189180 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 123 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012900.45208 | 2113712.93045 | 37.7845788525671 | -122.39907951143101 | (37.7845788525671, -122.399079511431) | |||
176261 | 176261 | 125470 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 655 Powell St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6010075.12389 | 2116032.87575 | 37.79079101674171 | -122.40901798411501 | (37.7907910167417, -122.409017984115) | |||
178896 | 178896 | 220609 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 385 Nevada St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6008945.60793 | 2096515.87148 | 37.737138473362 | -122.411546563846 | (37.737138473362, -122.411546563846) | |||
180630 | 180630 | 125526 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 29 Miller Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010063.61505 | 2116985.54141 | 37.7934061616158 | -122.40912505558799 | (37.7934061616158, -122.409125055588) | |||
181538 | 181538 | 125480 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 70 Pleasant St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6008592.70141 | 2116811.8420599997 | 37.7928467140568 | -122.414202246537 | (37.7928467140568, -122.414202246537) | |||
182097 | 182097 | 249536 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6006331.73852 | 2114045.88325 | 37.7851248193023 | -122.421828736708 | (37.7851248193023, -122.421828736708) | |||
185557 | 185557 | 203448 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1880 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991280.817840001 | 2102617.4638400003 | 37.752885184220204 | -122.473065997797 | (37.7528851842202, -122.473065997797) | |||
186609 | 186609 | 249532 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006202.66878 | 2114026.7968200003 | 37.7850651330954 | -122.42227392182801 | (37.7850651330954, -122.422273921828) | |||
188590 | 188590 | 189193 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012073.860090001 | 2107513.44954 | 37.767510402696296 | -122.401503402873 | (37.7675104026963, -122.401503402873) |
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");