Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10378 | 10378 | 98180 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 622 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768099 | 6007169.16242 | 2091641.99398 | 37.7236560602499 | -122.417343266399 | (37.7236560602499, -122.417343266399) | |
| 87075 | 87075 | 52479 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 119POWHATTAN Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48589 | 6009084.88956475 | 2097947.60140706 | 37.7410775038925 | -122.411166106845 | (37.7410775038925, -122.411166106845) | ||
| 145313 | 145313 | 64085 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2010 12:00:00 AM | Permit Number 54033 | 5990603.92265969 | 2099084.38866457 | 37.7431450674581 | -122.475148901667 | (37.7431450674581, -122.475148901667) | |||
| 37316 | 37316 | 35009 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 4 | Permit Number 38581 | 5999618.3524 | 2114616.3026 | 37.7863101621151 | -122.445095896882 | (37.7863101621151, -122.445095896882) | ||
| 18345 | 18345 | 16909 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 457 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2009 12:00:00 AM | 18 | 3X3 | 6004854.34153 | 2110178.37501 | 37.7744221674765 | -122.42666456674101 | (37.7744221674765, -122.426664566741) | ||
| 111944 | 111944 | 16905 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 441 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 6004878.06154 | 2110135.30859 | 37.774305258573996 | -122.426579447402 | (37.774305258574, -122.426579447402) | ||
| 97690 | 97690 | 48988 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2002 12:00:00 AM | Permit Number 46175 | 6005014.67029629 | 2099626.41666977 | 37.7454580443014 | -122.42535889959998 | (37.7454580443014, -122.4253588996) | ||
| 78213 | 78213 | 37034 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 266 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48449 | 6004870.65820445 | 2098448.14678483 | 37.7422146471398 | -122.42577301954901 | (37.7422146471398, -122.425773019549) | ||
| 131178 | 131178 | 66298 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2920 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1990 12:00:00 AM | 6 | 3x3 | Permit Number 29409 | 6014606.2975 | 2089345.5816 | 37.7177661944335 | -122.391473700889 | (37.7177661944335, -122.391473700889) | |
| 98803 | 98803 | 104725 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2747 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2013 12:00:00 AM | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.794880464642894 | -122.44436863671899 | (37.7948804646429, -122.444368636719) | ||
| 99776 | 99776 | 65445 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 922 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1989 12:00:00 AM | Permit Number 28319 | 6007730.56095344 | 2114797.09154755 | 37.7872662397984 | -122.417042480837 | (37.7872662397984, -122.417042480837) | ||
| 6585 | 6585 | 44092 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2000 12:00:00 AM | 8 | 3x3 | Permit Number 43607 | 6004180.10381 | 2116042.60341 | 37.790485736467296 | -122.429415161181 | (37.7904857364673, -122.429415161181) | |
| 92502 | 92502 | 101350 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 102408 | 102408 | 101353 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949.0 | 2120797.0 | 37.8038089789489 | -122.41325137117902 | (37.8038089789489, -122.413251371179) | |||
| 115563 | 115563 | 101359 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201X Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.41329507143601 | (37.803771736238, -122.413295071436) | ||
| 162169 | 162169 | 101345 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 22 | Permit Number 32655 | 6008773.8267 | 2120774.1665 | 37.803736447762795 | -122.413855954453 | (37.8037364477628, -122.413855954453) | ||
| 105384 | 105384 | 55357 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1972 12:00:00 AM | Permit Number 11290 | 6001956.10378782 | 2101177.25372795 | 37.749542999745 | -122.436045873593 | (37.749542999745, -122.436045873593) | |||
| 111098 | 111098 | 50485 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47121 | 5996542.39678919 | 2090678.14826944 | 37.720405949717104 | -122.45400837564699 | (37.7204059497171, -122.454008375647) | ||
| 16799 | 16799 | 57069 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 920 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 27 | 7x13 | Permit Number 14335 | 6015211.40645 | 2104319.9485 | 37.7589163085501 | -122.390427794128 | (37.7589163085501, -122.390427794128) | |
| 137045 | 137045 | 57079 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 627 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 2 | Permit Number 14346 | 5990318.78395 | 2111097.03664 | 37.7761120602541 | -122.477012417523 | (37.7761120602541, -122.477012417523) | ||
| 183393 | 183393 | 50456 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 993 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 6 | Permit Number 47101 | 6015538.43851 | 2104592.1377 | 37.7596818177679 | -122.38931576171001 | (37.7596818177679, -122.38931576171) | ||
| 134345 | 134345 | 32357 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 716 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 3 | Permit Number 36911 | 6011755.33078 | 2117880.08122 | 37.7959569797808 | -122.40333452058998 | (37.7959569797808, -122.40333452059) | ||
| 83118 | 83118 | 38678 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1377 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.776624556634495 | -122.439428187036 | (37.7766245566345, -122.439428187036) | ||
| 122986 | 122986 | 38679 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1377 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.776624556634495 | -122.439428187036 | (37.7766245566345, -122.439428187036) | ||
| 60958 | 60958 | 48733 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2002 12:00:00 AM | 2 | Permit Number 46013 | 5986739.234 | 2106838.4777 | 37.764210939174106 | -122.489081723593 | (37.7642109391741, -122.489081723593) | ||
| 121552 | 121552 | 4543 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Cleary Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/21/1994 12:00:00 AM | 12 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | ||
| 184974 | 184974 | 42710 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1600 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53744 | 6005271.11771 | 2118900.89126 | 37.7983955805457 | -122.42584385893 | (37.7983955805457, -122.42584385893) |
| 59281 | 59281 | 54994 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 685 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 7 | Permit Number 10872 | 5990951.59437 | 2110751.2702900004 | 37.77519937131321 | -122.47479813592301 | (37.7751993713132, -122.474798135923) | ||
| 54469 | 54469 | 57397 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1190 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 11 | Permit Number 16237 | 6008290.06558 | 2115917.44184 | 37.7903739066804 | -122.41518604372601 | (37.7903739066804, -122.415186043726) | ||
| 93936 | 93936 | 32892 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778801 | 5993897.25914467 | 2107077.09548698 | 37.7652813146396 | -122.464341682773 | (37.7652813146396, -122.464341682773) |
| 33924 | 33924 | 38574 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2012 12:00:00 AM | 1 | Permit Number 769237 | 6015357.8476 | 2094862.6046 | 37.7329565309935 | -122.389260937031 | (37.7329565309935, -122.389260937031) | |
| 55812 | 55812 | 50231 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1255 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 8 | Permit Number 46939 | 5987056.8298 | 2106727.188 | 37.7639239004312 | -122.487975087347 | (37.7639239004312, -122.487975087347) | |
| 95142 | 95142 | 12754 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1730 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 2 | 3X4 | 5990033.131630001 | 2114754.17722 | 37.786136974525 | -122.478268017968 | (37.786136974525, -122.478268017968) | ||
| 185179 | 185179 | 61519 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1161 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1984 12:00:00 AM | 7 | Permit Number 21475 | 6007368.68612 | 2119491.86468 | 37.8001365583177 | -122.418627544125 | (37.8001365583177, -122.418627544125) | ||
| 51167 | 51167 | 32295 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1616 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 5 | Permit Number 36875 | 6011596.3586 | 2107020.1725 | 37.7661293203346 | -122.40312032520201 | (37.7661293203346, -122.403120325202) | ||
| 173778 | 173778 | 71255 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1392 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 1 | 6007494.44606 | 2117816.87319 | 37.795544530015604 | -122.418073553678 | (37.7955445300156, -122.418073553678) | ||
| 67213 | 67213 | 51275 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 744 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 3 | Permit Number 47650 | 5990394.326 | 2110291.56377 | 37.7739048349937 | -122.476692239116 | (37.7739048349937, -122.476692239116) | |
| 3030 | 3030 | 224462 | Planning Code 138.1 required 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2810 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010311.37562 | 2101086.64633 | 37.7497653433983 | -122.40714655877301 | (37.7497653433983, -122.407146558773) | |
| 3035 | 3035 | 240686 | Planning Code 138.1 required 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2810 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010325.27315 | 2101087.17666 | 37.749767577309605 | -122.40709853768499 | (37.7497675773096, -122.407098537685) | |
| 43089 | 43089 | 46211 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2244 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2003 12:00:00 AM | 3 | Permit Number 46882 | 6003263.56021 | 2116449.57494 | 37.7915512424562 | -122.43261542476299 | (37.7915512424562, -122.432615424763) | ||
| 47568 | 47568 | 54838 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 215 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 6 | Permit Number 10692 | 5998766.6122 | 2109946.2443 | 37.773438741186204 | -122.44770637361201 | (37.7734387411862, -122.447706373612) | ||
| 125055 | 125055 | 48453 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 5 | Permit Number 45822 | 5996008.37556 | 2113838.92432 | 37.7839689836389 | -122.45752914479601 | (37.7839689836389, -122.457529144796) | ||
| 146723 | 146723 | 48452 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5996026.36682 | 2113840.43033 | 37.7839741521628 | -122.457467011011 | (37.7839741521628, -122.457467011011) | ||
| 182969 | 182969 | 48451 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5995956.24653 | 2113838.6701 | 37.783965291128204 | -122.457709472605 | (37.7839652911282, -122.457709472605) | ||
| 162829 | 162829 | 51087 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2031REVISED Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2004 12:00:00 AM | 8 | Permit Number 47544 | 6006859.53299 | 2118230.7659 | 37.7966452201661 | -122.42029985774799 | (37.7966452201661, -122.420299857748) | ||
| 157758 | 157758 | 34595 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 224 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38290 | 5999049.11331 | 2115811.8927599997 | 37.7895604321171 | -122.447151385541 | (37.7895604321171, -122.447151385541) | |
| 70774 | 70774 | 31727 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2460 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990175.918 | 2098661.7302 | 37.7419597410001 | -122.476597940821 | (37.7419597410001, -122.476597940821) |
| 131574 | 131574 | 31728 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2460 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990177.7474 | 2098625.5077 | 37.7418603894955 | -122.476588969759 | (37.7418603894955, -122.476588969759) |
| 77131 | 77131 | 54664 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 360 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 1 | Permit Number 10488 | 6012252.975769999 | 2086866.6648099998 | 37.710828684568206 | -122.399434200424 | (37.7108286845682, -122.399434200424) | ||
| 56357 | 56357 | 43807 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 530 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 3 | Permit Number 43437 | 5988458.677999999 | 2112363.29745 | 37.7794807721264 | -122.48353979825899 | (37.7794807721264, -122.483539798259) | |
| 118583 | 118583 | 26205 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 750 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/20/2007 12:00:00 AM | 12 | 3X3 | 6005640.0872799 | 2098758.1364942 | 37.743109258996206 | -122.423134597972 | (37.7431092589962, -122.423134597972) | ||
| 102328 | 102328 | 34270 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.48837297696699 | (37.7872778329962, -122.488372976967) | ||
| 102904 | 102904 | 34272 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.48837581666099 | (37.7872024288867, -122.488375816661) | ||
| 106270 | 106270 | 34269 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.48837297696699 | (37.7872778329962, -122.488372976967) | ||
| 143244 | 143244 | 34271 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.48837581666099 | (37.7872024288867, -122.488375816661) | ||
| 144085 | 144085 | 4551 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 85 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1991 12:00:00 AM | 24 | 3X3 | 6004735.0847094 | 2113637.0202701 | 37.783912012698394 | -122.427323526754 | (37.7839120126984, -122.427323526754) | ||
| 156592 | 156592 | 82944 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52427 | 6009357.52887 | 2110544.0816099998 | 37.775679873857605 | -122.4111129656 | (37.7756798738576, -122.4111129656) | |
| 179336 | 179336 | 82943 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52427 | 6009392.50715 | 2110510.5860099997 | 37.7755898643032 | -122.410989600209 | (37.7755898643032, -122.410989600209) | |
| 88005 | 88005 | 30508 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 363 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | Permit Number 40123 | 6009708.62861324 | 2092740.2698514 | 37.72681424554771 | -122.40864217293199 | (37.7268142455477, -122.408642172932) | ||
| 63792 | 63792 | 64471 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2332 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 4 | Permit Number 25341 | 6003518.39121 | 2116605.0137 | 37.7919924858215 | -122.431744816269 | (37.7919924858215, -122.431744816269) | ||
| 80995 | 80995 | 81638 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 611 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52388 | 6011631.16657043 | 2091602.57917757 | 37.7237978701092 | -122.40191602971301 | (37.7237978701092, -122.401916029713) | ||
| 59444 | 59444 | 80749 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 375 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52325 | 6004167.50654 | 2090267.3011900003 | 37.719712117607 | -122.42762157938101 | (37.719712117607, -122.427621579381) | |
| 49423 | 49423 | 37645 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990141.86983 | 2111994.48348 | 37.7785659364855 | -122.477690019436 | (37.7785659364855, -122.477690019436) | |
| 111844 | 111844 | 37577 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40010 | 5999933.60679892 | 2105019.65180732 | 37.759978178597 | -122.443315658152 | (37.759978178597, -122.443315658152) | ||
| 136981 | 136981 | 37644 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2732 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990120.460530001 | 2111993.16181 | 37.7785610650821 | -122.47776398494499 | (37.7785610650821, -122.477763984945) | |
| 175622 | 175622 | 37630 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 546 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40048 | 5990347.694519999 | 2111641.30179 | 37.777608139525 | -122.476952187306 | (37.777608139525, -122.476952187306) | |
| 5887 | 5887 | 94203 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008148.35783 | 2118956.03523 | 37.7987091687558 | -122.415891605907 | (37.7987091687558, -122.415891605907) | |
| 94707 | 94707 | 94202 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008232.0 | 2118962.0 | 37.798730248485896 | -122.415602598872 | (37.7987302484859, -122.415602598872) | |
| 93338 | 93338 | 42428 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 769 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42578 | 5997011.02141138 | 2094977.36766372 | 37.7322374467316 | -122.45269862641099 | (37.7322374467316, -122.452698626411) | ||
| 62074 | 62074 | 94211 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 465 Missouri St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013546.79092 | 2104912.40006 | 37.760450569952205 | -122.39622637625799 | (37.7604505699522, -122.396226376258) | |
| 172150 | 172150 | 94214 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 465 Missouri St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013545.016969999 | 2104957.62874 | 37.7605746593094 | -122.396235681545 | (37.7605746593094, -122.396235681545) | |
| 116693 | 116693 | 37466 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39937 | 6009086.92753477 | 2097969.49395992 | 37.7411377303504 | -122.411160606325 | (37.7411377303504, -122.411160606325) | ||
| 45843 | 45843 | 31770 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990241.9611 | 2098396.6732 | 37.7412357933409 | -122.47635023030199 | (37.7412357933409, -122.476350230302) | ||
| 57239 | 57239 | 31767 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990299.8313 | 2098399.3806 | 37.741246583105294 | -122.47615033552201 | (37.7412465831053, -122.476150335522) | ||
| 66250 | 66250 | 31765 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990223.0095 | 2098395.3195 | 37.7412309773369 | -122.47641565864299 | (37.7412309773369, -122.476415658643) | ||
| 76229 | 76229 | 31768 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990284.9407 | 2098399.3806 | 37.741245719618895 | -122.47620182139 | (37.7412457196189, -122.47620182139) | ||
| 77958 | 77958 | 31771 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 82228 | 82228 | 31734 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005.0 | 2098357.0 | 37.741113115877795 | -122.47716665025699 | (37.7411131158778, -122.477166650257) | ||
| 95736 | 95736 | 31792 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35262 | 6001241.81019665 | 2108627.72464151 | 37.7699595699392 | -122.439049813001 | (37.7699595699392, -122.439049813001) | ||
| 98035 | 98035 | 31731 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005.0 | 2098357.0 | 37.741113115877795 | -122.47716665025699 | (37.7411131158778, -122.477166650257) | ||
| 99320 | 99320 | 31776 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 100830 | 100830 | 31795 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 141 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35265 | 6001336.75578377 | 2108526.84088843 | 37.7696879701055 | -122.438714168685 | (37.7696879701055, -122.438714168685) | ||
| 105593 | 105593 | 31773 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 117577 | 117577 | 31772 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 145061 | 145061 | 31775 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 147585 | 147585 | 31733 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2495 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 3 | 3x3 | Permit Number 35227 | 5990132.7438 | 2098427.0161 | 37.7413127725673 | -122.476730077237 | (37.7413127725673, -122.476730077237) |
| 174307 | 174307 | 31774 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 0 | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | |
| 184877 | 184877 | 31769 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990271.0654 | 2098396.6732 | 37.7412374811669 | -122.476249599037 | (37.7412374811669, -122.476249599037) | ||
| 95689 | 95689 | 16894 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 361 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2008 12:00:00 AM | 3 | 3X3 | 6005282.37962 | 2110221.51905 | 37.7745648206797 | -122.42518697132401 | (37.7745648206797, -122.425186971324) | ||
| 31094 | 31094 | 87873 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2341 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50845 | 6000097.31037 | 2119864.70248 | 37.8007482115146 | -122.443816038389 | (37.8007482115146, -122.443816038389) | |
| 130376 | 130376 | 84614 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2034 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50834 | 6000478.89565 | 2121006.72285 | 37.8039056520943 | -122.442577640443 | (37.8039056520943, -122.442577640443) | |
| 189123 | 189123 | 84613 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2029-22031 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50833 | 6000517.3597800005 | 2120966.99196 | 37.8037987541811 | -122.442441679147 | (37.8037987541811, -122.442441679147) | |
| 176691 | 176691 | 75284 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1335 Griffith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 3 | 6017835.3471 | 2092484.583 | 37.7265639860027 | -122.380530259866 | (37.7265639860027, -122.380530259866) | ||
| 105851 | 105851 | 55533 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000967.89961965 | 2104951.08442142 | 37.759848834973795 | -122.439733631625 | (37.7598488349738, -122.439733631625) | ||
| 111896 | 111896 | 63101 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 18 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000981.26282803 | 2104951.87977531 | 37.759851779436495 | -122.439687471955 | (37.7598517794365, -122.439687471955) | ||
| 164682 | 164682 | 37224 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1340 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39788 | 5985571.0917 | 2106094.9849 | 37.7621012650414 | -122.49306716261101 | (37.7621012650414, -122.493067162611) | |
| 91731 | 91731 | 83341 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 422-24 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50786 | 6002931.20131858 | 2105783.16408091 | 37.762245079378 | -122.433002986091 | (37.762245079378, -122.433002986091) | ||
| 105637 | 105637 | 96626 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 144733 | 144733 | 96627 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 1485 | 1485 | 115988 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 499 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777967 | 6011781.45666 | 2118040.71778 | 37.7963995082912 | -122.40325542520901 | (37.7963995082912, -122.403255425209) |
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");