Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18677 | 18677 | 88330 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 544 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51318 | 6001416.8 | 2090660.3 | 37.720635228492206 | -122.437157897339 | (37.7206352284922, -122.437157897339) | |||
| 19735 | 19735 | 96580 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | |||
| 37753 | 37753 | 71351 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 118 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2008 12:00:00 AM | 3x3 | Permit Number 50915 | 5999898.11886666 | 2105092.21291824 | 37.7601753897516 | -122.44344360556002 | (37.7601753897516, -122.44344360556) | ||
| 77383 | 77383 | 87991 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 222 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51029 | 6008096.0 | 2113166.0 | 37.7828082078679 | -122.41566260373001 | (37.7828082078679, -122.41566260373) | ||
| 77453 | 77453 | 63489 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 319 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50934 | 6006645.5795297995 | 2096080.30995427 | 37.7358132351331 | -122.419467931102 | (37.7358132351331, -122.419467931102) | ||
| 78043 | 78043 | 88136 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 321 Los Palmos Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51162 | 5997690.0 | 2096237.0 | 37.7357349780848 | -122.450442028597 | (37.7357349780848, -122.450442028597) | |||
| 78575 | 78575 | 88011 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 144 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51041 | 6008609.0 | 2112967.0 | 37.7822906254359 | -122.413873752004 | (37.7822906254359, -122.413873752004) | ||
| 79054 | 79054 | 100424 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 200X Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
| 81470 | 81470 | 83567 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 62 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50867 | 5997102.41885097 | 2106267.4466409 | 37.7632424534183 | -122.453197397762 | (37.7632424534183, -122.453197397762) | ||
| 81498 | 81498 | 88509 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 81712 | 81712 | 88507 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 81820 | 81820 | 84105 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3909 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50417 | 6003719.39167552 | 2102426.4465388 | 37.753073006911706 | -122.430037470862 | (37.7530730069117, -122.430037470862) | ||
| 81908 | 81908 | 89201 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1627 McAllister St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51818 | 6001371.0 | 2111438.0 | 37.7776832317385 | -122.43880436100599 | (37.7776832317385, -122.438804361006) | |||
| 82435 | 82435 | 88162 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 365 Clementina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51185 | 6011732.3 | 2112447.5 | 37.7810391100489 | -122.40303190844999 | (37.7810391100489, -122.40303190845) | |||
| 82544 | 82544 | 87968 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1301 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204.0 | 2110019.0 | 37.773777512847296 | -122.439280334526 | (37.7737775128473, -122.439280334526) | ||
| 82747 | 82747 | 84204 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 655 Sunnydale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.709661919286496 | -122.408259684415 | (37.7096619192865, -122.408259684415) | ||
| 84590 | 84590 | 101631 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1585X Jerrold Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.38905762495199 | (37.7385310737434, -122.389057624952) | ||
| 85750 | 85750 | 88508 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 86093 | 86093 | 84203 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 655 Sunnydale Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.709661919286496 | -122.408259684415 | (37.7096619192865, -122.408259684415) | ||
| 86181 | 86181 | 88027 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 121 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51050 | 6008492.3 | 2112899.8 | 37.782099555755295 | -122.41427272738599 | (37.7820995557553, -122.414272727386) | ||
| 86876 | 86876 | 88243 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2745 Turk Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51229 | 5997744.2 | 2111601.2 | 37.7779243335514 | -122.451362410862 | (37.7779243335514, -122.451362410862) | |||
| 88030 | 88030 | 52826 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3063 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52281 | 6009164.51309648 | 2101559.46503951 | 37.750999349300606 | -122.411145866905 | (37.7509993493006, -122.411145866905) | ||
| 88528 | 88528 | 89323 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 18 Hale St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2008 12:00:00 AM | 3x3 | Permit Number 51913 | 6010478.7 | 2094954.8 | 37.7329379790561 | -122.406135993698 | (37.7329379790561, -122.406135993698) | |||
| 88775 | 88775 | 82759 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 49 Samoset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50251 | 6009929.1659667 | 2099164.47966506 | 37.744466098795 | -122.40833270178899 | (37.744466098795, -122.408332701789) | ||
| 88841 | 88841 | 100425 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
| 89007 | 89007 | 81225 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 225 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49728 | 5994438.42452426 | 2091412.78636228 | 37.7223022264954 | -122.46133430098699 | (37.7223022264954, -122.461334300987) | ||
| 89164 | 89164 | 88499 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1599@ Lane Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51438 | 6015105.8 | 2094319.6 | 37.7314515735977 | -122.39009441777 | (37.7314515735977, -122.39009441777) | ||
| 89917 | 89917 | 91130 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 218 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 52020 | 6002821.3 | 2109296.6 | 37.7718858820629 | -122.433634203014 | (37.7718858820629, -122.433634203014) | ||
| 89938 | 89938 | 88017 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 601 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51044 | 6008420.0 | 2114150.0 | 37.7855282422492 | -122.41461135167101 | (37.7855282422492, -122.414611351671) | ||
| 90125 | 90125 | 87988 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 233 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51028 | 6009741.0 | 2113986.0 | 37.785152065252 | -122.41002947845502 | (37.785152065252, -122.410029478455) | ||
| 90269 | 90269 | 88511 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 90981 | 90981 | 79256 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 627 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50884 | 5996581.50943321 | 2107294.3742688 | 37.7660322643278 | -122.455073251071 | (37.7660322643278, -122.455073251071) | ||
| 91307 | 91307 | 86800 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 71 Miguel St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2007 12:00:00 AM | 3x3 | Permit Number 49752 | 6003860.0 | 2097292.0 | 37.738982969029706 | -122.429185143196 | (37.7389829690297, -122.429185143196) | |||
| 91560 | 91560 | 88337 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 686 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51324 | 6002465.0 | 2089669.0 | 37.717972867232795 | -122.43346379852699 | (37.7179728672328, -122.433463798527) | |||
| 91806 | 91806 | 88523 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 10 Valdez Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51454 | 5996417.0 | 2093827.6 | 37.7290464055545 | -122.45466924520201 | (37.7290464055545, -122.454669245202) | |||
| 91970 | 91970 | 84200 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 655 Sunnydale Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.709661919286496 | -122.408259684415 | (37.7096619192865, -122.408259684415) | ||
| 92023 | 92023 | 101634 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1585X Jerrold Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.38905762495199 | (37.7385310737434, -122.389057624952) | ||
| 92263 | 92263 | 88346 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 351 Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51331 | 6003903.0 | 2091384.0 | 37.722763361623294 | -122.428615443614 | (37.7227633616233, -122.428615443614) | |||
| 93019 | 93019 | 88014 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 77 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51043 | 6008723.4 | 2112463.6 | 37.780914833514 | -122.413442364822 | (37.780914833514, -122.413442364822) | ||
| 94254 | 94254 | 101627 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1585X Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.38905762495199 | (37.7385310737434, -122.389057624952) | ||
| 95196 | 95196 | 83512 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49725 | 5994714.51593994 | 2090381.39140811 | 37.719486148882 | -122.460305233079 | (37.719486148882, -122.460305233079) | ||
| 95661 | 95661 | 87989 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 233 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51028 | 6009741.0 | 2113986.0 | 37.785152065252 | -122.41002947845502 | (37.785152065252, -122.410029478455) | ||
| 97082 | 97082 | 87993 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 248 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51031 | 6008142.6 | 2113255.6 | 37.7830568472778 | -122.415507732402 | (37.7830568472778, -122.415507732402) | ||
| 97864 | 97864 | 87845 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 6 Minerva St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2008 12:00:00 AM | 3x3 | Permit Number 50752 | 5996525.4 | 2089078.3 | 37.7160121664781 | -122.453951648081 | (37.7160121664781, -122.453951648081) | |||
| 98254 | 98254 | 87994 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 248 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51031 | 6008142.6 | 2113255.6 | 37.7830568472778 | -122.415507732402 | (37.7830568472778, -122.415507732402) | ||
| 98815 | 98815 | 43561 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 598 28th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50500 | 6002046.37252319 | 2099459.05244765 | 37.7448303525831 | -122.435610815213 | (37.7448303525831, -122.435610815213) | ||
| 99756 | 99756 | 101628 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1585X Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.38905762495199 | (37.7385310737434, -122.389057624952) | ||
| 99778 | 99778 | 88473 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1554 Jerrold Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51426 | 6015626.2 | 2096846.0 | 37.738417406581604 | -122.38847155599599 | (37.7384174065816, -122.388471555996) | |||
| 99780 | 99780 | 88524 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 840 Powell St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51456 | 6010045.0 | 2116631.0 | 37.792431633933894 | -122.409164435867 | (37.7924316339339, -122.409164435867) | |||
| 100297 | 100297 | 46139 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 206 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51613 | 5998984.25754118 | 2106980.434825 | 37.7653078166494 | -122.44674007091601 | (37.7653078166494, -122.446740070916) | ||
| 101293 | 101293 | 88010 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 301 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51039 | 6008988.0 | 2113534.0 | 37.7838687491965 | -122.412602670053 | (37.7838687491965, -122.412602670053) | ||
| 101858 | 101858 | 35784 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51612 | 6004919.48722825 | 2106038.70275083 | 37.7630593064236 | -122.42614444470101 | (37.7630593064236, -122.426144444701) | ||
| 102080 | 102080 | 88510 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
| 103422 | 103422 | 88738 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 218 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51672 | 6002821.3 | 2109296.6 | 37.7718858820629 | -122.433634203014 | (37.7718858820629, -122.433634203014) | ||
| 103734 | 103734 | 89324 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 16 Hale St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2008 12:00:00 AM | 3x3 | Permit Number 51914 | 6010434.1 | 2094994.4 | 37.7330442175155 | -122.40629297735 | (37.7330442175155, -122.40629297735) | |||
| 104187 | 104187 | 88203 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 436 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51208 | 6011221.0 | 2112104.0 | 37.7800673738175 | -122.40477656866999 | (37.7800673738175, -122.40477656867) | ||
| 105018 | 105018 | 84100 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3909 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50417 | 6003719.39167552 | 2102426.4465388 | 37.753073006911706 | -122.430037470862 | (37.7530730069117, -122.430037470862) | ||
| 105185 | 105185 | 82729 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 49 Samoset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50251 | 6009929.1659667 | 2099164.47966506 | 37.744466098795 | -122.40833270178899 | (37.744466098795, -122.408332701789) | ||
| 105806 | 105806 | 62067 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 240 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50979 | 6009906.39574025 | 2087592.17070432 | 37.7126897048858 | -122.40759567922 | (37.7126897048858, -122.40759567922) | ||
| 105912 | 105912 | 88009 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 360 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51038 | 6008030.0 | 2113635.0 | 37.7840922583142 | -122.415924158968 | (37.7840922583142, -122.415924158968) | ||
| 108122 | 108122 | 88468 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1950 Donner Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51422 | 6011569.2 | 2093583.7 | 37.7292341601061 | -122.402269464083 | (37.7292341601061, -122.402269464083) | |||
| 108496 | 108496 | 121589 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 270x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007359.0 | 2108191.0 | 37.76910659118089 | -122.417859552844 | (37.7691065911809, -122.417859552844) | ||||
| 109188 | 109188 | 87990 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 233 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51028 | 6009741.0 | 2113986.0 | 37.785152065252 | -122.41002947845502 | (37.785152065252, -122.410029478455) | ||
| 109205 | 109205 | 88157 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 353 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51181 | 6011830.6 | 2112533.5 | 37.7812807348582 | -122.40269788763901 | (37.7812807348582, -122.402697887639) | ||
| 110183 | 110183 | 88498 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1599 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51438 | 6015105.8 | 2094319.6 | 37.7314515735977 | -122.39009441777 | (37.7314515735977, -122.39009441777) | ||
| 110408 | 110408 | 88019 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 926 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51046 | 6007429.0 | 2114473.0 | 37.7863593952456 | -122.418062835651 | (37.7863593952456, -122.418062835651) | ||
| 112015 | 112015 | 88138 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 181 Marietta Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51166 | 5998804.0 | 2097893.0 | 37.740345654378096 | -122.44670962705798 | (37.7403456543781, -122.446709627058) | |||
| 112269 | 112269 | 101633 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1585X Jerrold Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.38905762495199 | (37.7385310737434, -122.389057624952) | ||
| 112869 | 112869 | 84205 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 655 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.709661919286496 | -122.408259684415 | (37.7096619192865, -122.408259684415) | ||
| 113219 | 113219 | 62429 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4475 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50961 | 5999555.98449793 | 2105708.06247977 | 37.7618468426508 | -122.44467114765301 | (37.7618468426508, -122.444671147653) | ||
| 113288 | 113288 | 88158 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 353 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51181 | 6011830.6 | 2112533.5 | 37.7812807348582 | -122.40269788763901 | (37.7812807348582, -122.402697887639) | ||
| 113778 | 113778 | 87939 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4489 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50962 | 5999451.0 | 2105708.0 | 37.761840679686706 | -122.44503424165501 | (37.7618406796867, -122.445034241655) | ||
| 115335 | 115335 | 88018 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3926 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51046 | 6004957.7 | 2095821.3 | 37.735006837707296 | -122.42528517225901 | (37.7350068377073, -122.425285172259) | |||
| 116331 | 116331 | 84422 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3324-3330 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50579 | 6007386.65215888 | 2105022.29149516 | 37.7604076136969 | -122.417539297454 | (37.7604076136969, -122.417539297454) | ||
| 116576 | 116576 | 95289 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4400 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015280.0 | 2096693.0 | 37.737978108932 | -122.389657874388 | (37.737978108932, -122.389657874388) | ||||
| 116817 | 116817 | 84201 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 655 Sunnydale Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.709661919286496 | -122.408259684415 | (37.7096619192865, -122.408259684415) | ||
| 117212 | 117212 | 84199 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 655 Sunnydale Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.709661919286496 | -122.408259684415 | (37.7096619192865, -122.408259684415) | ||
| 117680 | 117680 | 95622 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 201 Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767388 | 6007162.9 | 2106147.3 | 37.763484032741204 | -122.418392924595 | (37.7634840327412, -122.418392924595) | |
| 117683 | 117683 | 87995 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 120 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51032 | 6009094.1 | 2112956.3 | 37.782288477237394 | -122.412194758861 | (37.7822884772374, -122.412194758861) | ||
| 118145 | 118145 | 96581 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | |||
| 118308 | 118308 | 81505 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 30 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49730 | 5996533.25550088 | 2090072.07142613 | 37.7187412808671 | -122.453996225339 | (37.7187412808671, -122.453996225339) | ||
| 118427 | 118427 | 88525 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 626x Funston Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51466 | 5991969.3 | 2111151.0 | 37.7763558419216 | -122.47130682669399 | (37.7763558419216, -122.471306826694) | |||
| 121116 | 121116 | 87971 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1301 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204.0 | 2110019.0 | 37.773777512847296 | -122.439280334526 | (37.7737775128473, -122.439280334526) | ||
| 122334 | 122334 | 88185 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 493 Clementina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51192 | 6010910.3 | 2111721.3 | 37.7789991980081 | -122.405824460674 | (37.7789991980081, -122.405824460674) | |||
| 122901 | 122901 | 83991 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 62 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50867 | 5997102.41885097 | 2106267.4466409 | 37.7632424534183 | -122.453197397762 | (37.7632424534183, -122.453197397762) | ||
| 124009 | 124009 | 96578 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | |||
| 124609 | 124609 | 88015 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 77 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51043 | 6008723.4 | 2112463.6 | 37.780914833514 | -122.413442364822 | (37.780914833514, -122.413442364822) | ||
| 125668 | 125668 | 101632 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1585X Jerrold Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.38905762495199 | (37.7385310737434, -122.389057624952) | ||
| 126455 | 126455 | 95623 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 201 Capp St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767388 | 6007162.9 | 2106147.3 | 37.763484032741204 | -122.418392924595 | (37.7634840327412, -122.418392924595) | |
| 126569 | 126569 | 88470 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1519 Innes Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51424 | 6015916.0 | 2096861.0 | 37.7384746486807 | -122.387470605672 | (37.7384746486807, -122.387470605672) | |||
| 127743 | 127743 | 84048 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1006 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49723 | 5995065.73258922 | 2090627.8481306 | 37.7201830572422 | -122.45910905051599 | (37.7201830572422, -122.459109050516) | ||
| 128212 | 128212 | 96579 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | |||
| 138388 | 138388 | 84202 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 655 Sunnydale Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.709661919286496 | -122.408259684415 | (37.7096619192865, -122.408259684415) | ||
| 138631 | 138631 | 88191 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 355 Tehama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51196 | 6011553.0 | 2112651.0 | 37.7815878594503 | -122.40366652245199 | (37.7815878594503, -122.403666522452) | |||
| 139240 | 139240 | 87977 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1372 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51013 | 6001285.0 | 2110422.0 | 37.7748886587191 | -122.43902903105 | (37.7748886587191, -122.43902903105) | ||
| 139567 | 139567 | 87970 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1301 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204.0 | 2110019.0 | 37.773777512847296 | -122.439280334526 | (37.7737775128473, -122.439280334526) | ||
| 140242 | 140242 | 88315 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 157 Edinburg St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51306 | 6004192.4 | 2092727.9 | 37.7264697879052 | -122.427710754996 | (37.7264697879052, -122.427710754996) | |||
| 140474 | 140474 | 88016 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 77 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51043 | 6008723.4 | 2112463.6 | 37.780914833514 | -122.413442364822 | (37.780914833514, -122.413442364822) | ||
| 141032 | 141032 | 96584 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 401x Otsego Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | |||
| 141178 | 141178 | 88506 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) |
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");