Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2333 | 2333 | 253025 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1754 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2017 12:00:00 AM | 3 | 5993444.58369 | 2103545.63859 | 37.7555587516047 | -122.465650780273 | (37.7555587516047, -122.465650780273) | |||
| 5769 | 5769 | 39272 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2740 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | Permit Number 774808 | 5999918.5789 | 2117802.13868 | 37.7950747637355 | -122.44428621834999 | (37.7950747637355, -122.44428621835) | ||
| 5807 | 5807 | 47379 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4453 Manzanita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45296 | ||||||||
| 5982 | 5982 | 39271 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2740 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2015 12:00:00 AM | 3 | Permit Number 774808 | 5999943.4858099995 | 2117805.21945 | 37.7950846436855 | -122.444200258451 | (37.7950846436855, -122.444200258451) | ||
| 7427 | 7427 | 83207 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1630 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 772967 | 6005062.56265 | 2119560.0197 | 37.8001935906169 | -122.426612484272 | (37.8001935906169, -122.426612484272) | |
| 8919 | 8919 | 49958 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1635 REVISED Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 46712 | 6005318.44165545 | 2115314.81375181 | 37.788551790903604 | -122.425424765275 | (37.7885517909036, -122.425424765275) | ||
| 10621 | 10621 | 52188 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 76 Camona Av | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2005 12:00:00 AM | Permit Number 48379 | ||||||||
| 10929 | 10929 | 28307 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2003 12:00:00 AM | 3 | 6000526.74804 | 2093584.98162 | 37.7286151010044 | -122.440444169789 | (37.7286151010044, -122.440444169789) | |||
| 11646 | 11646 | 27701 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1136 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/26/2000 12:00:00 AM | 6 | 6008329.0437900005 | 2093834.9235 | 37.729742566663106 | -122.413488762206 | (37.7297425666631, -122.413488762206) | |||
| 11707 | 11707 | 28306 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 6000533.35164 | 2093598.6883900003 | 37.7286531126447 | -122.440422323457 | (37.7286531126447, -122.440422323457) | |||
| 12427 | 12427 | 35723 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 80 Dartmouth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 772467 | 6008403.94814 | 2093755.2917799999 | 37.729528120608 | -122.41322417987499 | (37.729528120608, -122.413224179875) | |
| 12474 | 12474 | 28305 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 6000543.0489 | 2093613.5897099997 | 37.7286945803894 | -122.440389867794 | (37.7286945803894, -122.440389867794) | |||
| 15164 | 15164 | 51415 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 7121 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2004 12:00:00 AM | Permit Number 47739 | ||||||||
| 18403 | 18403 | 115286 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1649 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775796 | 5992740.3 | 2104249.5 | 37.7574507237441 | -122.468137590024 | (37.7574507237441, -122.468137590024) | |||
| 19101 | 19101 | 50030 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1424 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46762 | 6006666.542202201 | 2093098.6917368 | 37.727627545599205 | -122.41918402186701 | (37.7276275455992, -122.419184021867) | ||
| 20075 | 20075 | 36304 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1998 12:00:00 AM | Permit Number 39288 | 5990632.40828813 | 2094456.10044746 | 37.73043862093321 | -122.474712677246 | (37.7304386209332, -122.474712677246) | ||
| 20081 | 20081 | 47968 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 487 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2002 12:00:00 AM | Permit Number 45698 | 5998723.98262042 | 2097661.13122407 | 37.7397044270458 | -122.446969612962 | (37.7397044270458, -122.446969612962) | |||
| 21052 | 21052 | 16925 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 512 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 25 | 6004419.62206 | 2110173.45228 | 37.7743840640969 | -122.42816799305099 | (37.7743840640969, -122.428167993051) | ||||
| 23024 | 23024 | 2316 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2263 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6009682.41451 | 2104184.36513 | 37.7582357681755 | -122.409540144857 | (37.7582357681755, -122.409540144857) | ||||
| 23242 | 23242 | 1673 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 5994963.861330001 | 2111486.70203 | 37.7774503572538 | -122.460972213003 | (37.7774503572538, -122.460972213003) | ||||
| 23639 | 23639 | 51486 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2576 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2005 12:00:00 AM | 7 | Permit Number 47799 | 5999551.99541 | 2119490.69699 | 37.799690173532 | -122.445676136766 | (37.799690173532, -122.445676136766) | ||
| 24196 | 24196 | 198273 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014246.68754 | 2106694.7124400004 | 37.7653833298046 | -122.393930504207 | (37.7653833298046, -122.393930504207) | ||||
| 24845 | 24845 | 31207 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 141 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34899 | 6004741.8201 | 2109004.9334 | 37.7711938198687 | -122.42697020763 | (37.7711938198687, -122.42697020763) | ||
| 25281 | 25281 | 115053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1280 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 1 | Permit Number 773966 | 6007807.56108 | 2115848.6869799998 | 37.790157994733704 | -122.41685060786699 | (37.7901579947337, -122.416850607867) | ||
| 25717 | 25717 | 53974 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 985 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 4 | Permit Number 9690 | 6009227.8600699995 | 2115996.16493 | 37.790642719446204 | -122.41194689162901 | (37.7906427194462, -122.411946891629) | |
| 26540 | 26540 | 70481 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 934 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 3 | 6005107.91916 | 2092023.60961 | 37.7245877066523 | -122.424495766183 | (37.7245877066523, -122.424495766183) | ||
| 26854 | 26854 | 103532 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2014 12:00:00 AM | 1 | Permit Number 770957 | 6003118.601980001 | 2086861.7562 | 37.7103018500205 | -122.431004337903 | (37.7103018500205, -122.431004337903) | ||
| 26966 | 26966 | 70402 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 212 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 6006462.64225 | 2092921.27798 | 37.727128920939606 | -122.419876323835 | (37.7271289209396, -122.419876323835) | ||
| 27006 | 27006 | 35019 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 27 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 10 | Permit Number 38594 | 6001880.48988 | 2120550.7716599996 | 37.8027335251878 | -122.437694670695 | (37.8027335251878, -122.437694670695) | ||
| 27178 | 27178 | 51035 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 61 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | Permit Number 47510 | 6006881.28082295 | 2099362.73553976 | 37.7448393177024 | -122.418885745068 | (37.7448393177024, -122.418885745068) | |||
| 27967 | 27967 | 44472 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 236 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 8 | Permit Number 43786 | 6006212.75467 | 2092719.23658 | 37.726560078178395 | -122.420725846847 | (37.7265600781784, -122.420725846847) | |
| 28118 | 28118 | 52029 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 55 Elmira St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2005 12:00:00 AM | 5 | Permit Number 48241 | 6011182.06051 | 2096602.5114799999 | 37.737501562957 | -122.403820184153 | (37.737501562957, -122.403820184153) | ||
| 28396 | 28396 | 43970 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 460 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2000 12:00:00 AM | 4 | Permit Number 43535 | 6010585.8055300005 | 2112372.51825 | 37.7807691382115 | -122.406992935695 | (37.7807691382115, -122.406992935695) | ||
| 28936 | 28936 | 49804 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1112SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46599 | 6014208.95643 | 2105755.12489 | 37.7628013312333 | -122.39399522840799 | (37.7628013312333, -122.393995228408) | |
| 29520 | 29520 | 32018 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 729 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 11 | Permit Number 35411 | 6009321.52864 | 2119764.77649 | 37.800995657295395 | -122.41188922351101 | (37.8009956572954, -122.411889223511) | ||
| 30575 | 30575 | 42240 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 532 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 2 | Permit Number 42489 | 6010157.096530001 | 2111965.88499 | 37.7796286197948 | -122.408447363381 | (37.7796286197948, -122.408447363381) | |
| 31240 | 31240 | 53102 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 429@ GEARY BL 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | 4 | Permit Number 49065 | 5994018.99484 | 2112572.39265 | 37.7803769568855 | -122.46431963578999 | (37.7803769568855, -122.46431963579) | ||
| 31345 | 31345 | 54056 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 839 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1972 12:00:00 AM | 12 | Permit Number 9778 | 5985079.18018 | 2110144.91058 | 37.7731924364746 | -122.495067118327 | (37.7731924364746, -122.495067118327) | ||
| 31590 | 31590 | 198270 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014327.719219999 | 2106393.16587 | 37.764559852075 | -122.39362912521099 | (37.764559852075, -122.393629125211) | ||||
| 32574 | 32574 | 52874 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3476@ LAUREL Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2006 12:00:00 AM | 4 | Permit Number 48886 | 5998188.79133 | 2115538.04458 | 37.7887593241423 | -122.45010824850701 | (37.7887593241423, -122.450108248507) | ||
| 33164 | 33164 | 44473 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 258 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 6 | Permit Number 43787 | 6006246.79793 | 2092607.35071 | 37.7262547826049 | -122.420600221446 | (37.7262547826049, -122.420600221446) | |
| 33462 | 33462 | 68846 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 731 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1993 12:00:00 AM | 9 | Permit Number 32807 | 5982263.55129 | 2110779.79011 | 37.774770393997706 | -122.50485363813101 | (37.7747703939977, -122.504853638131) | ||
| 34216 | 34216 | 32016 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2920 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2002 12:00:00 AM | 7 | Permit Number 46155 | 5989557.12792 | 2111970.2291 | 37.7784653891782 | -122.479711067145 | (37.7784653891782, -122.479711067145) | |
| 34306 | 34306 | 44480 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 295 Harvard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43790 | 6006326.11018523 | 2092518.45956429 | 37.72601517641179 | -122.420319736223 | (37.7260151764118, -122.420319736223) | ||
| 34908 | 34908 | 52183 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | 5 | Permit Number 48373 | 6011742.35118 | 2096927.06221 | 37.738423995777104 | -122.401905791943 | (37.7384239957771, -122.401905791943) | |
| 35409 | 35409 | 78535 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 62 Colby St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2000 12:00:00 AM | 6 | 6007981.72204 | 2093794.7148099998 | 37.7296126541786 | -122.41468665108 | (37.7296126541786, -122.41468665108) | ||
| 36031 | 36031 | 103531 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2014 12:00:00 AM | 1 | Permit Number 770957 | 6003099.91342 | 2086880.6888299999 | 37.7103527759382 | -122.43107027978901 | (37.7103527759382, -122.431070279789) | ||
| 36218 | 36218 | 31084 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1397 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 9 | Permit Number 34820 | 6006995.97256 | 2107440.57968 | 37.7670256771058 | -122.419062011995 | (37.7670256771058, -122.419062011995) | |
| 36919 | 36919 | 43183 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 350 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 6 | Permit Number 42986 | 6008206.3757 | 2092356.2981200002 | 37.7256756893785 | -122.41380829041401 | (37.7256756893785, -122.413808290414) | |
| 37392 | 37392 | 45242 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 604 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44093 | 6008555.70872799 | 2091212.30248413 | 37.7225541315384 | -122.41251983895201 | (37.7225541315384, -122.412519838952) | ||
| 37494 | 37494 | 70335 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 320 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 6 | 6009780.67381 | 2094049.10859 | 37.7304120750579 | -122.408485397509 | (37.7304120750579, -122.408485397509) | ||
| 37559 | 37559 | 35018 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 15 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 10 | Permit Number 38593 | 6001898.27273 | 2120571.24867 | 37.8027907607435 | -122.437634600462 | (37.8027907607435, -122.437634600462) | ||
| 38497 | 38497 | 180409 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 141 Rousseau St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6003595.96524 | 2094719.6833400002 | 37.7319050215902 | -122.429914617678 | (37.7319050215902, -122.429914617678) | ||||
| 38853 | 38853 | 70336 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 324 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | 6009735.9866 | 2094035.87413 | 37.7303732333298 | -122.408638954927 | (37.7303732333298, -122.408638954927) | ||
| 38905 | 38905 | 65281 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 443 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1989 12:00:00 AM | 3 | Permit Number 28088 | 6011045.68858 | 2112172.30893 | 37.7802451338574 | -122.405387865261 | (37.7802451338574, -122.405387865261) | |
| 39379 | 39379 | 48916 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 77 Connecticut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 5 | Permit Number 46108 | 6013166.41174 | 2106720.77544 | 37.765394797053496 | -122.39766878180299 | (37.7653947970535, -122.397668781803) | ||
| 39512 | 39512 | 106411 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2159 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2014 12:00:00 AM | 1 | Permit Number 772621 | 6001561.17582 | 2119720.78456 | 37.8004364390406 | -122.438740147849 | (37.8004364390406, -122.438740147849) | ||
| 39912 | 39912 | 68348 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 518 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32167 | 5990339.7966 | 2111825.86021 | 37.7781144278241 | -122.476992997759 | (37.7781144278241, -122.476992997759) | |
| 40418 | 40418 | 42151 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 554 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 7 | Permit Number 42446 | 5989728.75072 | 2111581.12126 | 37.7774069754215 | -122.47908889577499 | (37.7774069754215, -122.479088895775) | |
| 42097 | 42097 | 36754 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1735 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | 6 | Permit Number 39521 | 6011176.308069999 | 2095179.59653 | 37.7335942181978 | -122.403739980819 | (37.7335942181978, -122.403739980819) | ||
| 42337 | 42337 | 52446 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 759 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | Permit Number 48558 | 5992862.05574 | 2110293.7245099996 | 37.7740535957707 | -122.468156185872 | (37.7740535957707, -122.468156185872) | |
| 42471 | 42471 | 69532 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2395 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 6 | Permit Number 38574 | 5999900.2494 | 2119838.00764 | 37.8006636725595 | -122.444496029289 | (37.8006636725595, -122.444496029289) | ||
| 42751 | 42751 | 108789 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 43394 | 43394 | 78532 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 5 | 6010074.13409 | 2092167.4028 | 37.725261736838604 | -122.407338256469 | (37.7252617368386, -122.407338256469) | ||
| 43543 | 43543 | 58803 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2246 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2013 12:00:00 AM | 2 | Permit Number 769648 | 6002177.82636 | 2118813.48385 | 37.7979802907265 | -122.436541316255 | (37.7979802907265, -122.436541316255) | ||
| 43763 | 43763 | 79959 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1719 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 5 | 6014649.309169999 | 2095031.35513 | 37.73338057973321 | -122.39172235292 | (37.7333805797332, -122.39172235292) | ||
| 43937 | 43937 | 33280 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 3 | Permit Number 37445 | 6008548.04554 | 2116881.1658799998 | 37.7930345518418 | -122.414361665778 | (37.7930345518418, -122.414361665778) | |
| 44344 | 44344 | 67959 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 7 | Permit Number 31679 | 5987285.58651 | 2110436.7954700002 | 37.774122792273204 | -122.48745641247 | (37.7741227922732, -122.48745641247) | |
| 45366 | 45366 | 70407 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 231 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 8 | 6006535.83698 | 2092862.23217 | 37.7269709172726 | -122.419619102459 | (37.7269709172726, -122.419619102459) | ||
| 46320 | 46320 | 42868 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2649 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 0 | Permit Number 42791 | 5986726.28385176 | 2097377.23824555 | 37.738232180805895 | -122.48843112739999 | (37.7382321808059, -122.4884311274) | |
| 46618 | 46618 | 47195 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 371 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 6 | Permit Number 45155 | 5986820.372830001 | 2113443.94443 | 37.7823524278539 | -122.489286791849 | (37.7823524278539, -122.489286791849) | |
| 47843 | 47843 | 49309 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1800 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | 7 | Permit Number 46312 | 6000570.14327 | 2093666.4250900003 | 37.7288411968484 | -122.440299988657 | (37.7288411968484, -122.440299988657) | ||
| 47862 | 47862 | 68175 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 58 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | 7 | Permit Number 31946 | 5996349.990780001 | 2111854.0137 | 37.778538561885796 | -122.45620372641399 | (37.7785385618858, -122.456203726414) | |
| 48995 | 48995 | 52026 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 55 Elmira St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2005 12:00:00 AM | 3 | Permit Number 48241 | 6011182.7446 | 2096571.6762 | 37.7374169340467 | -122.403815649781 | (37.7374169340467, -122.403815649781) | ||
| 49606 | 49606 | 198325 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013787.22843 | 2108637.88784 | 37.770693312961996 | -122.39565583825899 | (37.770693312962, -122.395655838259) | ||||
| 49639 | 49639 | 50042 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301-399 University St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46772 | 6008166.14565124 | 2092655.50179392 | 37.7264949794548 | -122.413968519598 | (37.7264949794548, -122.413968519598) | ||
| 50177 | 50177 | 64157 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 744 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 1 | Permit Number 24936 | 5991974.2297 | 2110344.19587 | 37.7741408617904 | -122.471230978045 | (37.7741408617904, -122.471230978045) | |
| 50296 | 50296 | 68581 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1526 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | 0 | Permit Number 775949 | 5985927.704093 | 2104831.6030171 | 37.7586532178591 | -122.491740786234 | (37.7586532178591, -122.491740786234) | ||
| 50678 | 50678 | 80637 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 706 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 4 | 6011239.20103 | 2105002.70461 | 37.7605698551303 | -122.404213664555 | (37.7605698551303, -122.404213664555) | ||
| 51240 | 51240 | 50511 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 758 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47146 | 6002437.29594714 | 2089127.99525636 | 37.71648581608179 | -122.433520918153 | (37.7164858160818, -122.433520918153) | ||
| 51259 | 51259 | 50069 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3782 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46797 | 6003228.77135758 | 2103037.62545429 | 37.7547233610105 | -122.43177776523899 | (37.7547233610105, -122.431777765239) | ||
| 51615 | 51615 | 198272 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014300.74273 | 2106595.72792 | 37.765114544025295 | -122.393736609482 | (37.7651145440253, -122.393736609482) | ||||
| 52023 | 52023 | 68238 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 290 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32036 | 6000949.5088599995 | 2120925.17442 | 37.8037085566624 | -122.440943204485 | (37.8037085566624, -122.440943204485) | |
| 53744 | 53744 | 43786 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 354 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 4 | Permit Number 43416 | 5989368.92132 | 2112957.36095 | 37.78116484258071 | -122.48043441215599 | (37.7811648425807, -122.480434412156) | |
| 53925 | 53925 | 68894 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 47 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 11 | Permit Number 32866 | 6012572.9149400005 | 2090991.6774900001 | 37.722172972090505 | -122.39861769156799 | (37.7221729720905, -122.398617691568) | |
| 55075 | 55075 | 74119 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 7 | 6014130.8006 | 2112451.57445 | 37.7811839433263 | -122.39473452509199 | (37.7811839433263, -122.394734525092) | ||
| 56808 | 56808 | 47721 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2325 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2002 12:00:00 AM | 8 | Permit Number 45805 | 6001839.98608 | 2118371.66878 | 37.7967479784971 | -122.437678679828 | (37.7967479784971, -122.437678679828) | |
| 57296 | 57296 | 47722 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2325 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2002 12:00:00 AM | 8 | Permit Number 45805 | 6001852.4852599995 | 2118373.09609 | 37.796752608195796 | -122.437635532153 | (37.7967526081958, -122.437635532153) | |
| 57724 | 57724 | 84821 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 785 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2007 12:00:00 AM | 3 | Permit No. 49288 | 6011034.41195 | 2104697.2703 | 37.7597197556735 | -122.40490043542 | (37.7597197556735, -122.40490043542) | ||
| 58932 | 58932 | 40193 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3430 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41376 | 6000802.81629 | 2120169.1836 | 37.801624451566894 | -122.441396561715 | (37.8016244515669, -122.441396561715) | ||
| 59226 | 59226 | 198321 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013777.96356 | 2108496.99922 | 37.7703059488766 | -122.39567801282601 | (37.7703059488766, -122.395678012826) | ||||
| 59746 | 59746 | 43181 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 350 University St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 4 | Permit Number 42986 | 6008214.10647 | 2092327.8769599998 | 37.7255980850788 | -122.413779556209 | (37.7255980850788, -122.413779556209) | |
| 60515 | 60515 | 109905 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 224 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6007804.4869 | 2109016.66543 | 37.771398734904 | -122.416377125602 | (37.771398734904, -122.416377125602) | ||||
| 60647 | 60647 | 52028 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 55 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2005 12:00:00 AM | 4 | Permit Number 48241 | 6011185.5155 | 2096540.2757299999 | 37.737330869824 | -122.403803860554 | (37.737330869824, -122.403803860554) | ||
| 60774 | 60774 | 67952 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 564 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 11 | Permit Number 31667 | 5988466.35449 | 2112153.3787599998 | 37.778904841146 | -122.48349784875201 | (37.778904841146, -122.483497848752) | |
| 62060 | 62060 | 44209 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 170 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 3 | Permit Number 43657 | 6004467.73015 | 2094024.43109 | 37.7300453450179 | -122.426851245286 | (37.7300453450179, -122.426851245286) | ||
| 62677 | 62677 | 50483 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2003 12:00:00 AM | 5 | Permit Number 47118 | 5987691.11202 | 2115193.54019 | 37.787207107765 | -122.48640295005501 | (37.787207107765, -122.486402950055) | ||
| 62931 | 62931 | 43669 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 558 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 5 | Permit Number 43312 | 5992237.99153 | 2111666.97481 | 37.7777881075301 | -122.47041494214899 | (37.7777881075301, -122.470414942149) | |
| 63008 | 63008 | 114541 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001X Rhode Island St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011939.68484 | 2103650.19837 | 37.756895288204 | -122.401695928834 | (37.756895288204, -122.401695928834) | ||
| 65118 | 65118 | 52463 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 575@ BALBOA 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 6 | Permit Number 48574 | 5993745.27169 | 2111594.95452 | 37.7776773937563 | -122.465195547979 | (37.7776773937563, -122.465195547979) |
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");