Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87176 | 87176 | 49716 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 Fitzgerald Ave | 2 | 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) | |||
87304 | 87304 | 69106 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1759 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53521 | 5992465.35094064 | 2103624.41175427 | 37.7557185116538 | -122.46904297416401 | (37.7557185116538, -122.469042974164) | ||
87339 | 87339 | 51446 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 136 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2004 12:00:00 AM | Permit Number 47764 | 6007118.41110322 | 2097197.36823587 | 37.7389070513459 | -122.41791232337299 | (37.7389070513459, -122.417912323373) | ||
87507 | 87507 | 122894 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
87518 | 87518 | 122881 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
87753 | 87753 | 52896 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1642 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 3x3 | Permit Number 48894 | 5992495.5632863 | 2104272.70590883 | 37.757500303864 | -122.468985668503 | (37.757500303864, -122.468985668503) | ||
87923 | 87923 | 38326 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1321 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40382 | 6007185.31462295 | 2107795.24197408 | 37.7680101568657 | -122.418432256219 | (37.7680101568657, -122.418432256219) | ||
87928 | 87928 | 122879 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
88037 | 88037 | 44499 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 201-299 University St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43800 | 6008059.14986161 | 2093005.8506393996 | 37.7274509525396 | -122.41436317931101 | (37.7274509525396, -122.414363179311) | ||
88548 | 88548 | 44478 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 295 Harvard St | 3 | 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) | ||
88585 | 88585 | 50128 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 87 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46850 | 5993081.6533874 | 2098481.02287194 | 37.741631671781704 | -122.466537795041 | (37.7416316717817, -122.466537795041) | ||
88628 | 88628 | 42066 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 94 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42378 | 6007297.03712767 | 2098828.5050365003 | 37.7433958417804 | -122.41741028115601 | (37.7433958417804, -122.417410281156) | ||
88636 | 88636 | 45708 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 192 Graystone Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774637 | 5999327.035480901 | 2103995.03426473 | 37.757130224218294 | -122.44533981581499 | (37.7571302242183, -122.445339815815) | |||
88701 | 88701 | 50132 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 142 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46855 | 5992868.12184957 | 2098174.48278055 | 37.740777665804295 | -122.467253825322 | (37.7407776658043, -122.467253825322) | ||
89344 | 89344 | 41974 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42321 | 5993590.54370591 | 2094553.01083875 | 37.73087568091729 | -122.464493096634 | (37.7308756809173, -122.464493096634) | ||
89372 | 89372 | 40462 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 359 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53741 | 6007744.62011623 | 2097429.10653822 | 37.7395785763375 | -122.415763581182 | (37.7395785763375, -122.415763581182) | |
89541 | 89541 | 85045 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2051 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | Permit Number 49390 | 6001416.0 | 2115465.0 | 37.7887429058152 | -122.43893735552 | (37.7887429058152, -122.43893735552) | |||
89597 | 89597 | 122877 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
89782 | 89782 | 122888 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
89852 | 89852 | 36100 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 299 on 16th St Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46587 | 6004891.74541508 | 2106619.46330166 | 37.7646523685012 | -122.426281744676 | (37.7646523685012, -122.426281744676) | ||
89859 | 89859 | 36303 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 95 Rossmoor Dr | 2 | 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) | ||
89907 | 89907 | 53134 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400@ JENNINGS Yosemite Ave | 1 | 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) | |||
89911 | 89911 | 122886 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
90143 | 90143 | 122880 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
90288 | 90288 | 42615 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1791 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42678 | 6004482.657553299 | 2118388.26400306 | 37.7969434489311 | -122.428535613258 | (37.7969434489311, -122.428535613258) | |||
90436 | 90436 | 47697 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45495 | 6001748.90360557 | 2096547.6107593998 | 37.7368193138397 | -122.436431068172 | (37.7368193138397, -122.436431068172) | ||
90455 | 90455 | 44500 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 201-299 University St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43800 | 6008059.14986161 | 2093005.8506393996 | 37.7274509525396 | -122.41436317931101 | (37.7274509525396, -122.414363179311) | ||
90618 | 90618 | 45343 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2001 12:00:00 AM | Permit Number 44173 | 5992459.1856169 | 2089877.0607820998 | 37.7179713877014 | -122.46806434863701 | (37.7179713877014, -122.468064348637) | |||
90678 | 90678 | 53135 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400@ JENNINGS Yosemite Ave | 5 | 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) | |||
91118 | 91118 | 81458 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1111 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49734 | 5989787.55086775 | 2099004.4958045 | 37.742878352926795 | -122.47796582741002 | (37.7428783529268, -122.47796582741) | ||
91130 | 91130 | 120518 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 520 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010156.0 | 2108818.0 | 37.7709851997146 | -122.40822907662901 | (37.7709851997146, -122.408229076629) | ||||
91167 | 91167 | 49644 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 801 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46499 | 5995372.30079404 | 2094225.05720401 | 37.73007774990221 | -122.458309584309 | (37.7300777499022, -122.458309584309) | ||
91209 | 91209 | 43720 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 330 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43360 | 5996862.80956904 | 2089634.81461711 | 37.717559566270104 | -122.45282555230301 | (37.7175595662701, -122.452825552303) | ||
91338 | 91338 | 51051 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 576 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2004 12:00:00 AM | Permit Number 47521 | 6001462.66856911 | 2100892.46706057 | 37.7487329984112 | -122.43773179090599 | (37.7487329984112, -122.437731790906) | ||
91427 | 91427 | 50366 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 650 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47033 | 6013801.09440663 | 2111163.84907188 | 37.777629805669996 | -122.39578489606001 | (37.77762980567, -122.39578489606) | |||
91430 | 91430 | 51896 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 109 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48107 | 5995812.81263218 | 2088671.52692975 | 37.7148543797151 | -122.45638527464199 | (37.7148543797151, -122.456385274642) | |||
91502 | 91502 | 46482 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2751 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44674 | 5998701.67830404 | 2113131.15168999 | 37.782179963011 | -122.44816036243799 | (37.782179963011, -122.448160362438) | |||
91610 | 91610 | 41890 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 Duboce Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2000 12:00:00 AM | Permit Number 42259 | 6004099.97108515 | 2108358.83625404 | 37.7693834800973 | -122.429144312501 | (37.7693834800973, -122.429144312501) | |||
91702 | 91702 | 42611 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1791 Green St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42678 | 6004482.657553299 | 2118388.26400306 | 37.7969434489311 | -122.428535613258 | (37.7969434489311, -122.428535613258) | |||
91780 | 91780 | 50195 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1723 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2003 12:00:00 AM | Permit Number 46901 | 6014617.12557199 | 2095043.2497264 | 37.7334114532812 | -122.39183445293001 | (37.7334114532812, -122.39183445293) | |||
92096 | 92096 | 50738 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Laguna Honda Blvd | 2 | 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) | |||
92146 | 92146 | 48980 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 172 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2002 12:00:00 AM | Permit Number 46167 | 6008803.70405073 | 2097765.62184156 | 37.740562054589404 | -122.412125489927 | (37.7405620545894, -122.412125489927) | |||
92288 | 92288 | 81453 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 730 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49733 | 5997103.70386372 | 2108221.85987986 | 37.768608846124 | -122.45333406278401 | (37.768608846124, -122.453334062784) | ||
92491 | 92491 | 52760 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 495REVISED Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2006 12:00:00 AM | Permit Number 48803 | 6001219.18694752 | 2103383.06204982 | 37.7555577263806 | -122.438752191862 | (37.7555577263806, -122.438752191862) | |||
92916 | 92916 | 51996 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 638 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2005 12:00:00 AM | Permit Number 48214 | 6007180.55657071 | 2091593.69856849 | 37.723524092459 | -122.417300457881 | (37.723524092459, -122.417300457881) | |||
93130 | 93130 | 45295 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 579 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44135 | 6008739.69125312 | 2096133.78564239 | 37.7360777960739 | -122.412231517033 | (37.7360777960739, -122.412231517033) | ||
93182 | 93182 | 50365 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 650 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47033 | 6013801.09440663 | 2111163.84907188 | 37.777629805669996 | -122.39578489606001 | (37.77762980567, -122.39578489606) | |||
93187 | 93187 | 41892 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 Duboce Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2000 12:00:00 AM | Permit Number 42259 | 6004099.97108515 | 2108358.83625404 | 37.7693834800973 | -122.429144312501 | (37.7693834800973, -122.429144312501) | |||
93514 | 93514 | 85000 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2810 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2007 12:00:00 AM | Permit Number 49365 | 6002583.4 | 2117847.8 | 37.7953518121835 | -122.43506881386699 | (37.7953518121835, -122.435068813867) | |||
93527 | 93527 | 41780 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1033 Washington St | 1 | 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) | ||
93768 | 93768 | 42504 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 330 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42618 | 5996830.46899068 | 2095091.05738492 | 37.732539264109505 | -122.453331038571 | (37.7325392641095, -122.453331038571) | ||
93959 | 93959 | 42229 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 21 Merlin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42485 | 6011996.26663606 | 2111495.41936146 | 37.7784396539352 | -122.402051758962 | (37.7784396539352, -122.402051758962) | ||
93965 | 93965 | 42104 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 305 Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42409 | 5999382.77994639 | 2094344.80390055 | 37.730636191213996 | -122.444453504412 | (37.730636191214, -122.444453504412) | ||
94146 | 94146 | 110101 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1348 Douglass St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 3x3 | Permit Number 774671 | 6001379.0 | 2099692.0 | 37.7454320431231 | -122.437935141467 | (37.7454320431231, -122.437935141467) | |||
94279 | 94279 | 50919 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2211 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47421 | 5991497.58573776 | 2100075.7858708 | 37.7459189440829 | -122.47213113111799 | (37.7459189440829, -122.472131131118) | ||
94321 | 94321 | 44504 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301-399 University St | 9 | 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) | ||
94367 | 94367 | 50344 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 10 | 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) | |||
95018 | 95018 | 84916 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 179 Josiah Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2007 12:00:00 AM | Permit Number 49337 | 5996552.2 | 2089341.7 | 37.7167369380148 | -122.453878025955 | (37.7167369380148, -122.453878025955) | |||
95038 | 95038 | 46484 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2751 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44674 | 5998701.67830404 | 2113131.15168999 | 37.782179963011 | -122.44816036243799 | (37.782179963011, -122.448160362438) | |||
95149 | 95149 | 122869 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2900X Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5996824.0 | 2087575.0 | 37.7119015691826 | -122.45281111027501 | (37.7119015691826, -122.452811110275) | ||||
95213 | 95213 | 113810 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4101x 25TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | |||
95220 | 95220 | 47990 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2551 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45722 | 5991710.5771825 | 2098071.20668689 | 37.7404272065184 | -122.47124861836201 | (37.7404272065184, -122.471248618362) | ||
95280 | 95280 | 52099 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 610 Rockdale Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | Permit Number 48291 | 5997859.75445468 | 2098006.30716482 | 37.740602784001005 | -122.449982602547 | (37.740602784001, -122.449982602547) | |||
95558 | 95558 | 67502 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 239 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52566 | 5998080.25865148 | 2094213.26396261 | 37.730200608271495 | -122.448947026221 | (37.7302006082715, -122.448947026221) | |
95613 | 95613 | 40835 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2001 12:00:00 AM | Permit Number 44013 | 6005959.59269247 | 2110712.95216168 | 37.775952411307394 | -122.422879289341 | (37.7759524113074, -122.422879289341) | |||
95723 | 95723 | 44505 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301-399 University St | 11 | 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) | ||
95797 | 95797 | 114729 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1930 35TH AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/03/2015 12:00:00 AM | 4x4 | 5985421.0 | 2102058.0 | 37.7510080399178 | -122.493288836187 | (37.7510080399178, -122.493288836187) | |||
95940 | 95940 | 52780 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1360@ JUDAH 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2006 12:00:00 AM | Permit Number 48824 | 5985578.993883401 | 2105959.75073826 | 37.7617304118264 | -122.493029870185 | (37.7617304118264, -122.493029870185) | |||
96000 | 96000 | 40028 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1566 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52304 | 6015421.32187962 | 2095579.21927044 | 37.7349277287796 | -122.389091506131 | (37.7349277287796, -122.389091506131) | ||
96745 | 96745 | 95879 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 815 Lombard St | 2 | 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) | |
96783 | 96783 | 49643 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 801 Miramar Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46499 | 5995372.30079404 | 2094225.05720401 | 37.73007774990221 | -122.458309584309 | (37.7300777499022, -122.458309584309) | ||
97033 | 97033 | 42917 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 920 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43809 | 6009113.37386606 | 2103791.50832264 | 37.757125170600794 | -122.411480388013 | (37.7571251706008, -122.411480388013) | ||
97069 | 97069 | 36289 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 68drive Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1998 12:00:00 AM | Permit Number 39282 | 5990862.16369743 | 2094546.76991481 | 37.7307008871423 | -122.47392500050199 | (37.7307008871423, -122.473925000502) | ||
97093 | 97093 | 82123 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 80 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49835 | 5996967.31083744 | 2099143.77644415 | 37.7436748904507 | -122.45315040559099 | (37.7436748904507, -122.453150405591) | ||
97183 | 97183 | 41864 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 750 14th St | 2 | 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) | ||
97839 | 97839 | 48768 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 506 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | Permit Number 46026 | 6003601.56047909 | 2105327.63695873 | 37.76103231235221 | -122.430651960825 | (37.7610323123522, -122.430651960825) | |||
97908 | 97908 | 52053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 199 Leland Ave | 5 | 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) | |||
98024 | 98024 | 36297 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 77 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1998 12:00:00 AM | Permit Number 39285 | 5990823.610041 | 2094477.66064549 | 37.7305088972996 | -122.47405324468299 | (37.7305088972996, -122.474053244683) | ||
98139 | 98139 | 64711 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2609 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 775401 | 5987378.59458857 | 2114604.15746818 | 37.7855706107791 | -122.48744086841299 | (37.7855706107791, -122.487440868413) | |||
98632 | 98632 | 114614 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2400X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 773266 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||
98750 | 98750 | 50339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 16 | 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) | |||
99342 | 99342 | 95260 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
99670 | 99670 | 50145 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 875@ ITALY Vienna St | 5 | 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) | |||
99706 | 99706 | 52093 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600 Rockdale Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2005 12:00:00 AM | Permit Number 48289 | 5997880.65002852 | 2097973.6742378003 | 37.7405143774984 | -122.44990800276699 | (37.7405143774984, -122.449908002767) | ||
99754 | 99754 | 114624 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2400X Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 773266 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||
99822 | 99822 | 50735 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Laguna Honda Blvd | 5 | 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) | |||
100145 | 100145 | 40836 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2001 12:00:00 AM | Permit Number 44013 | 6005959.59269247 | 2110712.95216168 | 37.775952411307394 | -122.422879289341 | (37.7759524113074, -122.422879289341) | |||
100569 | 100569 | 122874 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
100645 | 100645 | 88216 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1500 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51215 | 6015591.6 | 2094077.6 | 37.730814022139505 | -122.38839801578001 | (37.7308140221395, -122.38839801578) | ||
100705 | 100705 | 122895 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
100735 | 100735 | 41742 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 333 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | Permit Number 47006 | 6006627.37896455 | 2097889.42911265 | 37.740779649003294 | -122.419659177974 | (37.7407796490033, -122.419659177974) | ||
100810 | 100810 | 42249 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 603 Natoma St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42495 | 6009703.09193941 | 2111483.74896598 | 37.7782793527016 | -122.409983922333 | (37.7782793527016, -122.409983922333) | ||
100861 | 100861 | 95685 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 295 Oxford St | 4 | 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) | |
101216 | 101216 | 49646 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 801 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46499 | 5995372.30079404 | 2094225.05720401 | 37.73007774990221 | -122.458309584309 | (37.7300777499022, -122.458309584309) | ||
101263 | 101263 | 52730 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2015 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/2006 12:00:00 AM | Permit Number 48785 | 6003257.686389 | 2119258.9998921 | 37.7992648663558 | -122.43283653798599 | (37.7992648663558, -122.432836537986) | ||
101306 | 101306 | 44479 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 295 Harvard St | 4 | 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) | ||
101773 | 101773 | 36269 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 2 | 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) | ||
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) | ||||
101940 | 101940 | 52610 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900 Gilman Ave | 7 | 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) | |||
101967 | 101967 | 41972 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Darien Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42321 | 5993590.54370591 | 2094553.01083875 | 37.73087568091729 | -122.464493096634 | (37.7308756809173, -122.464493096634) |
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");