Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker, DBH
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9563 | 9563 | 108596 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 36 Bronte St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 770949 | 6009339.44395 | 2097251.26276 | 37.7391797819084 | -122.410236794344 | (37.7391797819084, -122.410236794344) | ||
77650 | 77650 | 108872 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1317 Grove St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773401 | 6001507.20104 | 2110761.06824 | 37.775832295364104 | -122.438284688432 | (37.7758322953641, -122.438284688432) | |
86334 | 86334 | 108517 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1474 17th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773664 | 5990869.49269 | 2105368.92693 | 37.7604161511877 | -122.474689222748 | (37.7604161511877, -122.474689222748) | |
92920 | 92920 | 108889 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 534 Mangels Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773372 | 5997888.03427 | 2095280.4903 | 37.7331199631343 | -122.449688444288 | (37.7331199631343, -122.449688444288) | |
101815 | 101815 | 96678 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 829 Corbett Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768058 | 5999957.0 | 2102610.0 | 37.753363199287 | -122.443061697185 | (37.753363199287, -122.443061697185) | ||||
110859 | 110859 | 87296 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 710 Silliman St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2008 12:00:00 AM | 3x3 | Permit Number 50309 | 6008719.0 | 2093721.0 | 37.729451645260205 | -122.412132587507 | (37.7294516452602, -122.412132587507) | |||
111222 | 111222 | 108473 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1608 Anza St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773791 | 5993717.35879 | 2112110.81995 | 37.7790922117302 | -122.465329589105 | (37.7790922117302, -122.465329589105) | |||
111529 | 111529 | 94552 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 626 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 52551 | 5998519.0 | 2108536.0 | 37.7695524156732 | -122.44846131585899 | (37.7695524156732, -122.448461315859) | ||
129239 | 129239 | 108878 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 275 Staples Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773301 | 5998271.57935 | 2093779.45417 | 37.7290204086136 | -122.44825438236 | (37.7290204086136, -122.44825438236) | |
140988 | 140988 | 108660 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1462 Blake St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771207 | 5997897.618969999 | 2112846.03551 | 37.781351110742996 | -122.45092146754 | (37.781351110743, -122.45092146754) | |
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) | |||
4984 | 4984 | 44099 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1880 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774618 | 6003969.398019999 | 2119063.44467 | 37.798768262294395 | -122.43035980995701 | (37.7987682622944, -122.430359809957) | |
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) | ||
6209 | 6209 | 91354 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 52063 | 6007623.63084 | 2119707.2305900003 | 37.8007422490107 | -122.417760608464 | (37.8007422490107, -122.417760608464) | |
7392 | 7392 | 61776 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2939 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1993 12:00:00 AM | 6 | 3x3 | 6000507.69204 | 2118417.15605 | 37.7967970320012 | -122.44229197620001 | (37.7967970320012, -122.4422919762) | ||
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) | |
8949 | 8949 | 38494 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1345 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774878 | 6006577.84973 | 2118679.48452 | 37.797861412034294 | -122.42130642757401 | (37.7978614120343, -122.421306427574) |
9396 | 9396 | 27585 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2295X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2000 12:00:00 AM | 6 | 3X3 | 6009694.1199724 | 2103987.6509207003 | 37.7576962911825 | -122.40948577896401 | (37.7576962911825, -122.409485778964) | ||
9493 | 9493 | 29077 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2275 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 5 | 3x3 | 6009685.8295 | 2104144.07057 | 37.7581253197533 | -122.40952549043001 | (37.7581253197533, -122.40952549043) | ||
10028 | 10028 | 161764 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 142 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779227 | 6000990.7389 | 2087787.91218 | 37.7127240669257 | -122.43842496696001 | (37.7127240669257, -122.43842496696) | |
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 | ||||||||
10663 | 10663 | 110033 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 206 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775206 | 6003103.36951 | 2092214.97197 | 37.724999739126794 | -122.431438884895 | (37.7249997391268, -122.431438884895) |
11064 | 11064 | 25312 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 163 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3 | 3X3 | 6000515.96101 | 2091667.5202400002 | 37.7233495775944 | -122.440344004183 | (37.7233495775944, -122.440344004183) | ||
12132 | 12132 | 99909 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 210 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774553 | 6009399.78383 | 2095020.3189400001 | 37.7330574731105 | -122.40987072487499 | (37.7330574731105, -122.409870724875) | |
12240 | 12240 | 44475 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 275 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 8 | 3x3 | Permit Number 43789 | 6006290.74635 | 2092615.37122 | 37.726279281939895 | -122.42044886282301 | (37.7262792819399, -122.420448862823) |
12419 | 12419 | 981 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1604 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2003 12:00:00 AM | 6 | 3X3 | 6001745.7594099995 | 2092854.52102 | 37.7266787581039 | -122.436177732017 | (37.7266787581039, -122.436177732017) | ||
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) | |
13082 | 13082 | 15846 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5256 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | 6 | 3x3 | Permit Number 775938 | 5999899.043409999 | 2088666.4410599999 | 37.7150741519211 | -122.442261231071 | (37.7150741519211, -122.442261231071) | |
13984 | 13984 | 21894 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2068 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2003 12:00:00 AM | 3 | 2X3 | 6015677.89854 | 2105976.47682 | 37.7634906462863 | -122.388930084758 | (37.7634906462863, -122.388930084758) | ||
14019 | 14019 | 95844 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 152 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767916 | 6010308.44062 | 2112179.38157 | 37.7802233055096 | -122.40793885609502 | (37.7802233055096, -122.407938856095) | |
14268 | 14268 | 12235 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1574 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/1997 12:00:00 AM | 6 | 3X3 | 6015715.635319999 | 2096065.54177 | 37.736279382483204 | -122.38810787958201 | (37.7362793824832, -122.388107879582) | ||
14801 | 14801 | 22531 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6619 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2015 08:00:00 AM | 3 | 3X3 | 6012836.07271 | 2089639.80613 | 37.7184756630977 | -122.397613243265 | (37.7184756630977, -122.397613243265) | ||
14912 | 14912 | 61587 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 835 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/31/2010 12:00:00 AM | 12 | 6x4.5 | Permit Number 53711 | 6012777.55952 | 2103581.4940400003 | 37.7567533616886 | -122.39879340469999 | (37.7567533616886, -122.3987934047) |
15042 | 15042 | 94225 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 625 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53569 | 6014481.04423 | 2111852.0491299997 | 37.7795572495918 | -122.393480876451 | (37.7795572495918, -122.393480876451) | |
15100 | 15100 | 48913 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 77 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768553 | 6013169.41892 | 2106659.71709 | 37.765227311822294 | -122.397654097675 | (37.7652273118223, -122.397654097675) | |
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 | ||||||||
16442 | 16442 | 68888 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1958 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1993 12:00:00 AM | 15 | 3x3 | Permit Number 32860 | 6011521.066430001 | 2093598.7946799998 | 37.7292729200062 | -122.40243692791701 | (37.7292729200062, -122.402436927917) | |
16692 | 16692 | 12234 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1570 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 6 | 3X3 | 6015728.02305 | 2096056.7839799998 | 37.7362560216982 | -122.38806443872 | (37.7362560216982, -122.38806443872) | ||
16928 | 16928 | 10096 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 737 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | 3 | 3x3 | 6005665.871 | 2104659.8313700003 | 37.7593154078879 | -122.42346492097602 | (37.7593154078879, -122.423464920976) | ||
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) | ||
19942 | 19942 | 26077 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 261 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 02:44:00 PM | 3 | 3X3 | 5994378.441000001 | 2088053.8388 | 37.7130759052536 | -122.461298276453 | (37.7130759052536, -122.461298276453) | ||
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) | |||
20624 | 20624 | 25466 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 446 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2015 12:00:00 AM | 6 | 3X3 | 5992823.9205 | 2088555.2969999998 | 37.714363200126904 | -122.466707603629 | (37.7143632001269, -122.466707603629) | ||
21230 | 21230 | 28488 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1056 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | 12 | 3X3 | 6005699.27295 | 2102829.0400099996 | 37.754290366819 | -122.423219261259 | (37.754290366819, -122.423219261259) | ||
21524 | 21524 | 29079 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2261 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009682.37784 | 2104210.24464 | 37.7583068254181 | -122.40954209818199 | (37.7583068254181, -122.409542098182) | ||
21591 | 21591 | 27507 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1398 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6005804.30319 | 2100875.6461400003 | 37.7489327240794 | -122.42271723090799 | (37.7489327240794, -122.422717230908) | |||
21694 | 21694 | 10206 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1274 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2010 12:00:00 AM | 3 | 2X2 | 6005768.7769 | 2101585.68354 | 37.7508803192719 | -122.422890537479 | (37.7508803192719, -122.422890537479) | ||
22063 | 22063 | 855 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 378 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1995 12:00:00 AM | 6 | 3X3 | 6008306.24694 | 2095178.0824099998 | 37.7334293112951 | -122.41366253820401 | (37.7334293112951, -122.413662538204) | ||
23614 | 23614 | 41167 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 162 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52563 | 6001487.6244 | 2120266.34307 | 37.801930213864104 | -122.439033785505 | (37.8019302138641, -122.439033785505) |
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) | ||
24232 | 24232 | 72017 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 464 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51206 | 6010897.54847 | 2112072.46722 | 37.7799627080392 | -122.40589331753701 | (37.7799627080392, -122.405893317537) | |
24368 | 24368 | 97053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 87 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2011 12:00:00 AM | 4 | 2x3 | Permit Number 768205 | 6012721.3609 | 2095242.61214 | 37.7338534369729 | -122.39840267086399 | (37.7338534369729, -122.398402670864) | |
24619 | 24619 | 41597 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 552 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49968 | 5983505.71138 | 2112036.0358 | 37.77829267778829 | -122.500649732794 | (37.7782926777883, -122.500649732794) | |
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) | |
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) | |
28712 | 28712 | 82088 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 116 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50668 | 5996122.25454 | 2115757.75082 | 37.789244107281604 | -122.45727402588001 | (37.7892441072816, -122.45727402588) | |
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) | ||
29877 | 29877 | 102353 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 662 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52560 | 5992263.7285400005 | 2110921.14049 | 37.775741736970204 | -122.470271582701 | (37.7757417369702, -122.470271582701) |
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) | |
30659 | 30659 | 51400 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 421 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3 | 3c3 | Permit Number 50561 | 6011183.79367 | 2112305.04226 | 37.7806173092731 | -122.404919441686 | (37.7806173092731, -122.404919441686) | |
31127 | 31127 | 92816 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 410 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53025 | 5997688.97866 | 2114964.50163 | 37.787155913848 | -122.451796128513 | (37.787155913848, -122.451796128513) | |
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) | ||
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) | |
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) | |
35932 | 35932 | 52449 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 447 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48562 | 5992476.75463 | 2112405.61073 | 37.779830003091504 | -122.469642770977 | (37.7798300030915, -122.469642770977) |
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) | ||
36732 | 36732 | 54017 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 848 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49959 | 5985128.25093 | 2110100.49047 | 37.7730733441171 | -122.494894102815 | (37.7730733441171, -122.494894102815) | |
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) | ||
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) | ||
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) | |
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) | ||
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) | ||
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) | |
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) | |
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) | ||
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) | ||
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) | |
52564 | 52564 | 94720 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 24 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 53854 | 5997798.497 | 2113560.5927 | 37.7833074222878 | -122.451315930077 | (37.7833074222878, -122.451315930077) |
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");