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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 621 | 621 | 251339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | ||
| 628 | 628 | 251337 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
| 629 | 629 | 251338 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
| 634 | 634 | 251340 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
| 2127 | 2127 | 252902 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2375 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3x3 | 5992177.0 | 2094185.0 | 37.7297836282973 | -122.469353126495 | (37.7297836282973, -122.469353126495) | |||
| 3661 | 3661 | 253519 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 701 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6015696.1864 | 2103920.99342 | 37.7578477430893 | -122.38872333331899 | (37.7578477430893, -122.388723333319) | ||||
| 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 | ||||||||
| 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 | ||||||||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 41807 | 41807 | 91066 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 20 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2008 12:00:00 AM | 3x3 | Permit Number 51973 | 5992794.6 | 2093140.2 | 37.7269505362801 | -122.46714209837799 | (37.7269505362801, -122.467142098378) | ||
| 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) | ||
| 50167 | 50167 | 122876 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 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) | ||
| 63654 | 63654 | 92276 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 776 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52724 | 5993658.0 | 2098140.0 | 37.740728550324505 | -122.46452024264799 | (37.7407285503245, -122.464520242648) | ||
| 64062 | 64062 | 82900 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 444 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49729 | 5996625.78326464 | 2089801.15487038 | 37.7180027123551 | -122.453656843967 | (37.7180027123551, -122.453656843967) | ||
| 69282 | 69282 | 52955 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 516 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48942 | 5993282.16384919 | 2090617.22186434 | 37.72005118470771 | -122.465273429637 | (37.7200511847077, -122.465273429637) | ||
| 70837 | 70837 | 50127 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 83 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46849 | 5993092.89908961 | 2098512.16138225 | 37.7417178192078 | -122.46650117422399 | (37.7417178192078, -122.466501174224) | ||
| 73841 | 73841 | 45292 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 715 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44131 | 6007650.89179087 | 2096068.47070174 | 37.7358373000326 | -122.415991324141 | (37.7358373000326, -122.415991324141) | ||
| 76133 | 76133 | 52477 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 794CRESCENT Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48587 | 6007568.23807281 | 2095743.9678880002 | 37.7349416389836 | -122.41625411529499 | (37.7349416389836, -122.416254115295) | ||
| 77376 | 77376 | 49717 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 Fitzgerald Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
| 77493 | 77493 | 50330 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 77530 | 77530 | 50905 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2094 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47411 | 5991019.11429888 | 2101160.98347731 | 37.7488709142667 | -122.473864759666 | (37.7488709142667, -122.473864759666) | ||
| 77552 | 77552 | 50767 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
| 77583 | 77583 | 51433 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1275 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2004 12:00:00 AM | Permit Number 47752 | 6001334.87709496 | 2110036.2943615 | 37.7738324456338 | -122.43882885035801 | (37.7738324456338, -122.438828850358) | |||
| 77727 | 77727 | 95682 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 295 Oxford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767432 | 6006609.0 | 2092596.0 | 37.7262440224373 | -122.4193473003 | (37.7262440224373, -122.4193473003) | |
| 77784 | 77784 | 66736 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2797 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52344 | 6003927.95408343 | 2118320.58823126 | 37.796726222154206 | -122.430450187693 | (37.7967262221542, -122.430450187693) | ||
| 77816 | 77816 | 52055 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2005 12:00:00 AM | Permit Number 48255 | 6009975.44300852 | 2087511.82859192 | 37.712472966599705 | -122.407351368495 | (37.7124729665997, -122.407351368495) | |||
| 77909 | 77909 | 41779 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1033 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42192 | 6009731.77420403 | 2117422.91465756 | 37.79458848646429 | -122.410304149551 | (37.7945884864643, -122.410304149551) | ||
| 78015 | 78015 | 50126 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 83 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46849 | 5993092.89908961 | 2098512.16138225 | 37.7417178192078 | -122.46650117422399 | (37.7417178192078, -122.466501174224) | ||
| 78273 | 78273 | 44339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 345 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2006 12:00:00 AM | Permit Number 48789 | 5991856.15668521 | 2099757.27425672 | 37.7450651369824 | -122.47086805599501 | (37.7450651369824, -122.470868055995) | ||
| 78406 | 78406 | 120519 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 520 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010156.0 | 2108818.0 | 37.7709851997146 | -122.40822907662901 | (37.7709851997146, -122.408229076629) | ||||
| 78424 | 78424 | 49900 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1480 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 3x3 | Permit Number 46672 | 6007523.70287539 | 2107384.6320859 | 37.766901761926796 | -122.417232704982 | (37.7669017619268, -122.417232704982) | |
| 78487 | 78487 | 36267 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 80 Elmhurst Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39274 | 5991040.15921142 | 2094553.62712809 | 37.730730023706606 | -122.47331014852101 | (37.7307300237066, -122.473310148521) | ||
| 78492 | 78492 | 122871 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2900X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5996824.0 | 2087575.0 | 37.7119015691826 | -122.45281111027501 | (37.7119015691826, -122.452811110275) | ||||
| 78623 | 78623 | 36291 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 71 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1998 12:00:00 AM | Permit Number 39283 | 5990873.51092873 | 2094495.59206602 | 37.730561022921 | -122.473882039472 | (37.730561022921, -122.473882039472) | ||
| 78642 | 78642 | 52012 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 962 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2005 12:00:00 AM | Permit Number 48230 | 5998810.91074237 | 2106684.16503898 | 37.76448443041539 | -122.447318308786 | (37.7644844304154, -122.447318308786) | |||
| 78661 | 78661 | 45709 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 196 Graystone Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775143 | 5999327.035480901 | 2103995.03426473 | 37.757130224218294 | -122.44533981581499 | (37.7571302242183, -122.445339815815) | |||
| 78952 | 78952 | 41863 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 750 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42245 | 6003805.15975445 | 2107763.19492091 | 37.7677313004104 | -122.430121553201 | (37.7677313004104, -122.430121553201) | ||
| 78993 | 78993 | 50337 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 79180 | 79180 | 122891 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 79245 | 79245 | 44509 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401-499 University St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43803 | 6008432.88426873 | 2091786.24775713 | 37.7241231699972 | -122.412984978043 | (37.7241231699972, -122.412984978043) | ||
| 79457 | 79457 | 31951 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1635 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 46712 | 6005318.44165545 | 2115314.81375181 | 37.788551790903604 | -122.425424765275 | (37.7885517909036, -122.425424765275) | ||
| 79555 | 79555 | 36268 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
| 79686 | 79686 | 65664 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 74 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49843 | 5996999.19669028 | 2099166.92645134 | 37.743740282122204 | -122.453041823363 | (37.7437402821222, -122.453041823363) | ||
| 79748 | 79748 | 52609 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900 Gilman Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | Permit Number 48695 | 6016118.74890568 | 2089125.97967621 | 37.717247040692 | -122.386230482369 | (37.717247040692, -122.386230482369) | |||
| 80234 | 80234 | 95862 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 448 Tehama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767574 | 6011005.0 | 2112170.0 | 37.780236519035604 | -122.405528463855 | (37.7802365190356, -122.405528463855) | |
| 80538 | 80538 | 52098 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 610 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48291 | 5997859.75445468 | 2098006.30716482 | 37.740602784001005 | -122.449982602547 | (37.740602784001, -122.449982602547) | ||
| 80644 | 80644 | 106769 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2600X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010715.11393 | 2102268.82005 | 37.753033918516 | -122.405833670893 | (37.753033918516, -122.405833670893) | ||||
| 80667 | 80667 | 52327 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4522DOUGLASS 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48479 | 6001005.01435213 | 2104669.40412599 | 37.759077522158606 | -122.43958507684201 | (37.7590775221586, -122.439585076842) | ||
| 81081 | 81081 | 52056 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2005 12:00:00 AM | Permit Number 48255 | 6009975.44300852 | 2087511.82859192 | 37.712472966599705 | -122.407351368495 | (37.7124729665997, -122.407351368495) | |||
| 81095 | 81095 | 50764 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
| 81227 | 81227 | 42741 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 295 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | Permit Number 45864 | 6012649.44440777 | 2087097.71305381 | 37.711485187600495 | -122.39808010272101 | (37.7114851876005, -122.398080102721) | ||
| 81429 | 81429 | 50329 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 81511 | 81511 | 95543 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 629 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767330 | 6001843.0 | 2099407.0 | 37.744675875464 | -122.43631031345899 | (37.744675875464, -122.436310313459) | |
| 81523 | 81523 | 115220 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 663 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 775475 | 5989383.4 | 2110828.4 | 37.775320149744296 | -122.48022845818001 | (37.7753201497443, -122.48022845818) | |||
| 81750 | 81750 | 44502 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301-399 University St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43801 | 6008166.14565124 | 2092655.50179392 | 37.7264949794548 | -122.413968519598 | (37.7264949794548, -122.413968519598) | ||
| 81847 | 81847 | 51382 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1347 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | Permit Number 47712 | 6009024.8711757995 | 2109648.9829131 | 37.773203482244504 | -122.412200438895 | (37.7732034822445, -122.412200438895) | ||
| 81967 | 81967 | 36302 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 95 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1998 12:00:00 AM | Permit Number 39287 | 5990678.02579925 | 2094412.82621209 | 37.730322444040006 | -122.47455181566299 | (37.73032244404, -122.474551815663) | ||
| 82016 | 82016 | 50342 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 82050 | 82050 | 36296 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 74 Rossmoor Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1998 12:00:00 AM | Permit Number 39284 | 5990814.34200545 | 2094529.58563397 | 37.7306509333598 | -122.474089072475 | (37.7306509333598, -122.474089072475) | ||
| 82053 | 82053 | 45649 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 448 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/2001 12:00:00 AM | Permit Number 44349 | 5997254.92785311 | 2093841.17591199 | 37.729131707876704 | -122.45177345719601 | (37.7291317078767, -122.451773457196) | ||
| 82120 | 82120 | 36292 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 71 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1998 12:00:00 AM | Permit Number 39283 | 5990873.51092873 | 2094495.59206602 | 37.730561022921 | -122.473882039472 | (37.730561022921, -122.473882039472) | ||
| 82273 | 82273 | 52092 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 85 Agua Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48288 | 5996921.99988661 | 2098539.07066275 | 37.742011919418005 | -122.453263432124 | (37.742011919418, -122.453263432124) | ||
| 82392 | 82392 | 41865 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 750 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42245 | 6003805.15975445 | 2107763.19492091 | 37.7677313004104 | -122.430121553201 | (37.7677313004104, -122.430121553201) | ||
| 82780 | 82780 | 82795 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1995 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 771189 | 5989705.78063845 | 2101796.33096673 | 37.7505392542177 | -122.478452670316 | (37.7505392542177, -122.478452670316) | ||
| 82847 | 82847 | 52761 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 495REVISED Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/2006 12:00:00 AM | Permit Number 48803 | 6001219.18694752 | 2103383.06204982 | 37.7555577263806 | -122.438752191862 | (37.7555577263806, -122.438752191862) | ||
| 83343 | 83343 | 115277 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1909 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 777409 | 5988585.4 | 2105743.7 | 37.7613125601848 | -122.48261621096201 | (37.7613125601848, -122.482616210962) | |||
| 83435 | 83435 | 49719 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 Fitzgerald Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
| 83744 | 83744 | 94664 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53801 | 6004018.0 | 2095241.0 | 37.7333603312135 | -122.428492699505 | (37.7333603312135, -122.428492699505) | |
| 83771 | 83771 | 50148 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 875@ ITALY Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2003 12:00:00 AM | Permit Number 46868 | 6002211.52493718 | 2088672.10084916 | 37.7152212186066 | -122.43426871923 | (37.7152212186066, -122.43426871923) | |||
| 83773 | 83773 | 122890 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 83950 | 83950 | 45700 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 399 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2004 12:00:00 AM | Permit Number 47440 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 84063 | 84063 | 95878 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 815 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767594 | 6008458.0 | 2120343.0 | 37.8025348309413 | -122.414918358575 | (37.8025348309413, -122.414918358575) | |
| 84066 | 84066 | 83339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2233 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52332 | 5987590.2167451 | 2100087.03718588 | 37.7457229434205 | -122.485642930331 | (37.7457229434205, -122.485642930331) | ||
| 84374 | 84374 | 122889 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 84890 | 84890 | 50338 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 85203 | 85203 | 122882 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 85307 | 85307 | 50285 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 366 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | Permit Number 46992 | 6004010.39193969 | 2096465.27442072 | 37.73672148125971 | -122.428606241876 | (37.7367214812597, -122.428606241876) | ||
| 85351 | 85351 | 50343 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 85512 | 85512 | 50146 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 875@ ITALY Vienna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2003 12:00:00 AM | Permit Number 46868 | 6002211.52493718 | 2088672.10084916 | 37.7152212186066 | -122.43426871923 | (37.7152212186066, -122.43426871923) | |||
| 85615 | 85615 | 50087 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2467 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46819 | 5992325.61832444 | 2098666.0345421 | 37.7420960101281 | -122.469165348383 | (37.7420960101281, -122.469165348383) | ||
| 85643 | 85643 | 36300 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 83 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1998 12:00:00 AM | Permit Number 39286 | 5990785.99003535 | 2094450.97937948 | 37.7304334580015 | -122.474181355112 | (37.7304334580015, -122.474181355112) | ||
| 85794 | 85794 | 49521 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 436@ SANCHEZ Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2003 12:00:00 AM | Permit Number 46428 | 6003560.35257558 | 2102178.07873328 | 37.75238203899 | -122.430569738079 | (37.75238203899, -122.430569738079) | ||
| 86070 | 86070 | 50739 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47287 | 5995111.97067052 | 2101076.07556684 | 37.7488739902744 | -122.459705610219 | (37.7488739902744, -122.459705610219) | |||
| 86264 | 86264 | 54343 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1356 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2007 12:00:00 AM | 3x3 | Permit Number 49885 | 5994905.19012425 | 2106350.13137489 | 37.7633433067217 | -122.46080282313 | (37.7633433067217, -122.46080282313) | ||
| 86423 | 86423 | 52157 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1625 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | Permit Number 48349 | 6014824.95742785 | 2094210.63428485 | 37.731136795346295 | -122.391057738459 | (37.7311367953463, -122.391057738459) | ||
| 86640 | 86640 | 122875 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 86847 | 86847 | 53136 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400@ JENNINGS Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2006 12:00:00 AM | Permit Number 49070 | 6015681.6329149 | 2091892.45532517 | 37.7248190377031 | -122.38793433454201 | (37.7248190377031, -122.387934334542) | |||
| 86956 | 86956 | 36287 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 65 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1998 12:00:00 AM | Permit Number 39281 | 5990916.21076968 | 2094502.13131499 | 37.7305814511976 | -122.47373489813101 | (37.7305814511976, -122.473734898131) | ||
| 87045 | 87045 | 94137 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2010 12:00:00 AM | 3x3 | 5998307.0 | 2107804.0 | 37.7675304064735 | -122.449141870878 | (37.7675304064735, -122.449141870878) | |||
| 87120 | 87120 | 84741 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 145 FAITH St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2007 12:00:00 AM | Permit No. 49316 | 6010368.1 | 2099076.7 | 37.7442496446424 | -122.406808765329 | (37.7442496446424, -122.406808765329) |
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");