Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30941 | 30941 | 88552 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 649 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51497 | 5991271.5415199995 | 2111000.35442 | 37.7759018234336 | -122.473709552083 | (37.7759018234336, -122.473709552083) | ||
| 42748 | 42748 | 89044 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 44 Surrey St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51783 | 6002618.0 | 2096049.0 | 37.735499589249294 | -122.433390603486 | (37.7354995892493, -122.433390603486) | ||||
| 46895 | 46895 | 88581 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 515 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51523 | 5989364.701169999 | 2111797.63767 | 37.777980320812 | -122.480364100125 | (37.777980320812, -122.480364100125) | ||
| 79618 | 79618 | 86844 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748.0 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | |||
| 80946 | 80946 | 88494 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2617 Quint St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51436 | 6011452.0 | 2093927.0 | 37.7301702475564 | -122.402698769845 | (37.7301702475564, -122.402698769845) | |||
| 85981 | 85981 | 86840 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 320 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49780 | 6008706.2 | 2095448.4 | 37.734193996145 | -122.41229888228001 | (37.734193996145, -122.41229888228) | |||
| 91753 | 91753 | 88469 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 921 Ingerson Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51423 | 6014544.1 | 2089500.7 | 37.7181886666833 | -122.39169953123199 | (37.7181886666833, -122.391699531232) | |||
| 93103 | 93103 | 88423 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1451 Taylor St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51387 | 6008861.0 | 2117824.0 | 37.795640918050104 | -122.413345528397 | (37.7956409180501, -122.413345528397) | |||
| 95922 | 95922 | 86841 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 322 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49781 | 6008668.1 | 2095458.9 | 37.734220688835 | -122.412431348478 | (37.734220688835, -122.412431348478) | |||
| 97062 | 97062 | 86846 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748.0 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | |||
| 98501 | 98501 | 88247 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4348 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51233 | 6000427.0 | 2105801.0 | 37.7621516914162 | -122.441665328495 | (37.7621516914162, -122.441665328495) | |||
| 104078 | 104078 | 88251 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4903 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51237 | 5997791.1 | 2105582.1 | 37.7614001117653 | -122.450766072013 | (37.7614001117653, -122.450766072013) | |||
| 108755 | 108755 | 88422 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1451 Taylor St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51387 | 6008861.0 | 2117824.0 | 37.795640918050104 | -122.413345528397 | (37.7956409180501, -122.413345528397) | |||
| 109804 | 109804 | 86842 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49782 | 6008646.4 | 2095435.0 | 37.7341538468062 | -122.41250468368901 | (37.7341538468062, -122.412504683689) | |||
| 109838 | 109838 | 98274 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 766 Anderson St | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/23/2012 12:00:00 AM | 18 | Permit Number 768445 | 6007723.0 | 2095324.0 | 37.7337971999422 | -122.41568932106199 | (37.7337971999422, -122.415689321062) | |||
| 110087 | 110087 | 86843 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748.0 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | |||
| 113880 | 113880 | 115805 | Planning Code 138.1 required 4 | Pyrus kawakamii :: Evergreen Pear 82 | 872 Kansas St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | 3x3 | 6011546.4 | 2104246.9 | 37.758511744317296 | -122.40309803301201 | (37.7585117443173, -122.403098033012) | |||
| 114914 | 114914 | 86713 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 938 Garfield St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2007 12:00:00 AM | Permit Number 49699 | 5991527.0 | 2090568.7 | 37.7198165808065 | -122.47133684225099 | (37.7198165808065, -122.471336842251) | ||||
| 115259 | 115259 | 86845 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748.0 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | |||
| 115601 | 115601 | 95301 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 701 Golden Gate Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617005 | -122.422419858646 | (37.780652317617, -122.422419858646) | |||
| 123949 | 123949 | 108443 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 559 05th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773772 | 5994363.45802 | 2111716.68858 | 37.7780472719646 | -122.463065881676 | (37.7780472719646, -122.463065881676) | |||
| 123996 | 123996 | 88467 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Augusta St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51421 | 6011176.0 | 2095454.0 | 37.7343476550611 | -122.40376034751101 | (37.7343476550611, -122.403760347511) | |||
| 125782 | 125782 | 88124 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 266 Lexington St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51128 | 6006494.0 | 2104554.0 | 37.7590715260193 | -122.42059333056001 | (37.7590715260193, -122.42059333056) | |||
| 129414 | 129414 | 107809 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 174 14TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773719 | 6007550.6 | 2107982.4 | 37.76854460553329 | -122.417182034417 | (37.7685446055333, -122.417182034417) | ||
| 140091 | 140091 | 88478 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1514 McKinnon Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51430 | 6015856.3 | 2095628.5 | 37.7350871465747 | -122.387591057509 | (37.7350871465747, -122.387591057509) | |||
| 143372 | 143372 | 91610 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1068 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2016 08:13:00 AM | 3 | 3x3 | 6007601.453035 | 2103438.871938 | 37.7560719916571 | -122.416684224173 | (37.7560719916571, -122.416684224173) | |||
| 429 | 429 | 142788 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 733 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Polk St Scape will replant | 6007029.0497 | 2113497.6534 | 37.7836588132661 | -122.419377346786 | (37.7836588132661, -122.419377346786) | ||
| 1108 | 1108 | 244318 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 331 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2017 04:08:00 PM | 3 | Width 0ft | 6005494.8083 | 2110541.2729 | 37.7754547855001 | -122.424474886956 | (37.7754547855001, -122.424474886956) | ||
| 1966 | 1966 | 138440 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/2014 12:00:00 AM | 6 | Width 0ft | 6003498.0109 | 2114207.9928 | 37.7854097192823 | -122.431644121578 | (37.7854097192823, -122.431644121578) | ||
| 2715 | 2715 | 253166 | Planning Code 138.1 required 4 | Pyrus kawakamii :: Evergreen Pear 82 | 2405 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778209 | 5986396.6612 | 2098868.17463 | 37.742306656921 | -122.48968039586501 | (37.742306656921, -122.489680395865) | |
| 3099 | 3099 | 197138 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2617 Quint St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 6 | Width 3ft | Permit Number 51436 | 6011420.8914 | 2093882.2827299999 | 37.7300457263229 | -122.402803173234 | (37.7300457263229, -122.402803173234) | |
| 3392 | 3392 | 7175 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 814 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 6 | 3X3 | 6003515.4229999995 | 2111193.7442 | 37.7771343327183 | -122.43136863367201 | (37.7771343327183, -122.431368633672) | ||
| 3419 | 3419 | 252969 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998180.94106 | 2087280.50358 | 37.711170613109104 | -122.448099970249 | (37.7111706131091, -122.448099970249) | |||||
| 3425 | 3425 | 159220 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 372 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998655.59562 | 2087744.29121 | 37.71247119106079 | -122.446492798529 | (37.7124711910608, -122.446492798529) | |||
| 3814 | 3814 | 193324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015583.67362 | 2102658.4010900003 | 37.7543746962452 | -122.38902430045499 | (37.7543746962452, -122.389024300455) | |||
| 3834 | 3834 | 244219 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 588 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998052.0 | 2108644.0 | 37.76982224415679 | -122.450084429151 | (37.7698222441568, -122.450084429151) | |||
| 3987 | 3987 | 159341 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 40 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:44:00 PM | 3 | Width 0ft | 5998211.297780001 | 2087238.08175 | 37.7110558677139 | -122.44799199802799 | (37.7110558677139, -122.447991998028) | ||
| 4003 | 4003 | 159298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 122 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:11:00 PM | 3 | Width 0ft | 5998090.67137 | 2087368.5047400002 | 37.711407083550704 | -122.448418296488 | (37.7114070835507, -122.448418296488) | ||
| 4012 | 4012 | 252965 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:04:00 PM | 3 | ||||||||
| 4066 | 4066 | 252966 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 111 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 12:19:00 PM | 3 | 5998135.7809 | 2087327.97675 | 37.7112983819328 | -122.448259470506 | (37.7112983819328, -122.448259470506) | |||
| 4074 | 4074 | 252967 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:55:00 PM | 3 | 5998144.81293 | 2087318.48212 | 37.7112728281964 | -122.448227570418 | (37.7112728281964, -122.448227570418) | |||
| 4390 | 4390 | 175420 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | |||
| 4925 | 4925 | 253721 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 260 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2017 12:00:00 AM | 3 | 3.5x9 | Permit Number 780843 | 5994045.0 | 2113761.0 | 37.7836420503516 | -122.464315992766 | (37.7836420503516, -122.464315992766) | |
| 5178 | 5178 | 104043 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1405 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006090.81059 | 2119657.4034599997 | 37.800519058872396 | -122.42306126657199 | (37.8005190588724, -122.423061266572) | |||
| 5339 | 5339 | 7304 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1908 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6002992.4511 | 2114925.4093 | 37.7873508941206 | -122.433444491336 | (37.7873508941206, -122.433444491336) | |||
| 5596 | 5596 | 7325 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2027 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002881.7283 | 2115306.8957 | 37.7883920762372 | -122.433854846414 | (37.7883920762372, -122.433854846414) | |||
| 5893 | 5893 | 46201 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 6305 | 6305 | 52146 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 145 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2005 12:00:00 AM | Permit Number 48337 | ||||||||
| 6336 | 6336 | 7291 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1899X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6002969.1284 | 2114733.7648 | 37.7868233637677 | -122.433511482074 | (37.7868233637677, -122.433511482074) | |||
| 6434 | 6434 | 7318 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2001 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1996 12:00:00 AM | 6 | 3x3 | 6002895.5378 | 2115212.2273 | 37.7881329245579 | -122.43380029876002 | (37.7881329245579, -122.43380029876) | ||
| 6678 | 6678 | 48693 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 722 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2003 12:00:00 AM | 4 | 3x3 | Permit Number 45971 | 6001051.9149 | 2111314.295 | 37.7773254106094 | -122.43989931071 | (37.7773254106094, -122.43989931071) | |
| 6697 | 6697 | 7312 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1940 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6002968.6362 | 2115073.8773 | 37.7877571983499 | -122.433537500112 | (37.7877571983499, -122.433537500112) | |||
| 6813 | 6813 | 52112 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 435 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48303 | 6005739.8209 | 2111002.5816 | 37.776735260452 | -122.423660135383 | (37.776735260452, -122.423660135383) | |
| 7656 | 7656 | 7301 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1996 12:00:00 AM | 3 | 3X3 | 6002935.9259 | 2114953.2976 | 37.787424261211704 | -122.43364205043699 | (37.7874242612117, -122.433642050437) | ||
| 7747 | 7747 | 7300 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1900 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6002999.289 | 2114860.4079 | 37.7871728047294 | -122.433416186864 | (37.7871728047294, -122.433416186864) | |||
| 7823 | 7823 | 7319 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2011 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002893.06 | 2115234.5275 | 37.7881940146245 | -122.433810466039 | (37.7881940146245, -122.433810466039) | |||
| 8083 | 8083 | 7308 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1919 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2011 12:00:00 AM | 3 | 3x3 | 6002923.2911 | 2115026.9363 | 37.787625737445204 | -122.433691029207 | (37.7876257374452, -122.433691029207) | ||
| 8100 | 8100 | 14763 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 983 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004471.7203 | 2111860.4178 | 37.7790190047533 | -122.42810802032601 | (37.7790190047533, -122.428108020326) | |||
| 8221 | 8221 | 5902 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1230 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004519.1281 | 2112960.2158 | 37.7820414601118 | -122.428022411289 | (37.7820414601118, -122.428022411289) | |||
| 8286 | 8286 | 7311 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1932 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | 6002980.7419 | 2115020.0739 | 37.787610154730004 | -122.433491770285 | (37.78761015473, -122.433491770285) | |||
| 8606 | 8606 | 8111 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 810 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/1993 12:00:00 AM | 20 | 3X3 | 6003847.5569 | 2111477.6208 | 37.7779326053256 | -122.430239935515 | (37.7779326053256, -122.430239935515) | ||
| 8758 | 8758 | 7287 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1850 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6003043.7765 | 2114538.1757 | 37.786290560678204 | -122.433239236497 | (37.7862905606782, -122.433239236497) | |||
| 9083 | 9083 | 10613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 34 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1993 12:00:00 AM | 18 | 3X3 | 6016953.501807599 | 2095595.9312573997 | 37.7350584319022 | -122.383795333225 | (37.7350584319022, -122.383795333225) | ||
| 9202 | 9202 | 1709 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 7X Bass Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2006 12:00:00 AM | 5 | 3x3 | 6016610.521033701 | 2095134.7434862 | 37.7337731370994 | -122.384949031469 | (37.7337731370994, -122.384949031469) | ||
| 9215 | 9215 | 10617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 74 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1992 12:00:00 AM | 6 | 3X3 | 6016731.0735863 | 2095616.8317798001 | 37.7351035225916 | -122.38456580983299 | (37.7351035225916, -122.384565809833) | ||
| 9296 | 9296 | 11461 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 41X HAWKINS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1992 12:00:00 AM | 12 | 3X3 | 6016935.0 | 2095578.0 | 37.7350081734808 | -122.38385805308201 | (37.7350081734808, -122.383858053082) | ||
| 9522 | 9522 | 7294 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003037.0806 | 2114087.5866 | 37.7850529772079 | -122.43323019463499 | (37.7850529772079, -122.433230194635) | |||
| 9726 | 9726 | 173663 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 3878 17th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003109.0 | 2105964.0 | 37.7627516946294 | -122.432400964417 | (37.7627516946294, -122.432400964417) | ||||
| 10059 | 10059 | 24572 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2122 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/2013 12:00:00 AM | 3 | 3x3 | 6002889.00041 | 2115679.48805 | 37.7894155324538 | -122.433856328234 | (37.7894155324538, -122.433856328234) | ||
| 10316 | 10316 | 110495 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 230 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003598.79471 | 2092490.0157299999 | 37.7257830144685 | -122.429745863482 | (37.7257830144685, -122.429745863482) | |||
| 10895 | 10895 | 27085 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 747 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6006317.37103 | 2093607.15152 | 37.729003994832 | -122.420427188268 | (37.729003994832, -122.420427188268) | |||
| 11111 | 11111 | 110496 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003585.89382 | 2092469.97138 | 37.7257272466074 | -122.429789031845 | (37.7257272466074, -122.429789031845) | |||
| 11507 | 11507 | 30593 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 269 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34561 | ||||||||
| 13377 | 13377 | 10610 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 29 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6016939.384330001 | 2095525.0457799998 | 37.7348630141201 | -122.38383920883801 | (37.7348630141201, -122.383839208838) | ||
| 13396 | 13396 | 85628 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1470 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015957.8963 | 2094137.5833 | 37.730999015226104 | -122.387135841638 | (37.7309990152261, -122.387135841638) | ||
| 13415 | 13415 | 85617 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1274 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017015.0778 | 2093348.1164 | 37.7288897808137 | -122.383426014631 | (37.7288897808137, -122.383426014631) | ||
| 13512 | 13512 | 85658 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1643 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015004.908 | 2094769.8823 | 37.7326823614983 | -122.39047467450001 | (37.7326823614983, -122.3904746745) | ||
| 13543 | 13543 | 13319 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 14 Mabrey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1992 12:00:00 AM | 7 | 3X3 | 6016463.59576 | 2095940.9292900001 | 37.7359786339072 | -122.385513164614 | (37.7359786339072, -122.385513164614) | ||
| 13554 | 13554 | 85620 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1344 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016632.8917 | 2093635.0593 | 37.729656539473 | -122.384767252586 | (37.729656539473, -122.384767252586) | ||
| 13600 | 13600 | 85619 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1338 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016653.5768 | 2093624.593 | 37.729628945087704 | -122.384695012523 | (37.7296289450877, -122.384695012523) | ||
| 13802 | 13802 | 85643 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1235 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017171.4256 | 2093155.5219 | 37.7283695937915 | -122.38287210620199 | (37.7283695937915, -122.382872106202) | ||
| 13961 | 13961 | 85647 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1351 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016557.1838 | 2093613.7118 | 37.7295937360014 | -122.385027498588 | (37.7295937360014, -122.385027498588) | ||
| 13999 | 13999 | 10614 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 37 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2001 12:00:00 AM | 3 | 3X3 | 6016916.49156 | 2095577.9947400002 | 37.7350071358711 | -122.383922043589 | (37.7350071358711, -122.383922043589) | ||
| 14099 | 14099 | 11466 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 3 | 3X3 | 6016784.967569999 | 2095560.66167 | 37.73495227093311 | -122.384375566285 | (37.7349522709331, -122.384375566285) | ||
| 14120 | 14120 | 85653 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1541 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015555.708 | 2094360.5338 | 37.731588912651404 | -122.388541843069 | (37.7315889126514, -122.388541843069) | ||
| 14131 | 14131 | 85613 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1190 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017458.1534 | 2093022.4369 | 37.728020006278 | -122.38187161186 | (37.728020006278, -122.38187161186) | ||
| 14162 | 14162 | 85622 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1360 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016552.9396 | 2093696.0654 | 37.729819627930105 | -122.385047906896 | (37.7298196279301, -122.385047906896) | ||
| 14204 | 14204 | 85646 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1321 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016609.4363 | 2093572.233 | 37.7294827335965 | -122.38484396608999 | (37.7294827335965, -122.38484396609) | ||
| 14255 | 14255 | 85641 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1215 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017274.7558 | 2093081.4055 | 37.72817179324429 | -122.382509730509 | (37.7281717932443, -122.382509730509) | ||
| 14406 | 14406 | 120561 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 245 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6014054.5814 | 2105863.37396 | 37.7630899785332 | -122.394536741704 | (37.7630899785332, -122.394536741704) | |||
| 14505 | 14505 | 85632 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1582 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015365.5421 | 2094575.4322 | 37.7321684400373 | -122.38921428964 | (37.7321684400373, -122.38921428964) | ||
| 14632 | 14632 | 85652 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1519 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015655.7374 | 2094284.1377 | 37.7313846871586 | -122.388190689138 | (37.7313846871586, -122.388190689138) | ||
| 14774 | 14774 | 85650 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1419 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016182.7975 | 2093891.6734 | 37.730336247224706 | -122.386341174586 | (37.7303362472247, -122.386341174586) | ||
| 14882 | 14882 | 85659 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1623 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015103.6745 | 2094694.6627 | 37.7324813021879 | -122.390127958436 | (37.7324813021879, -122.390127958436) | ||
| 14960 | 14960 | 85627 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1466 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015977.8277 | 2094121.4228 | 37.730955745426606 | -122.387065808076 | (37.7309557454266, -122.387065808076) | ||
| 15002 | 15002 | 85644 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1275 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016975.0441 | 2093297.8038 | 37.728749419657 | -122.383560914081 | (37.728749419657, -122.383560914081) | ||
| 15012 | 15012 | 85551 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 288 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 3 | 6008109.65239 | 2108844.36385 | 37.7709427912139 | -122.41530934075199 | (37.7709427912139, -122.415309340752) | |||
| 15141 | 15141 | 81729 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1200 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015012.434719999 | 2102924.7634900003 | 37.7550743894922 | -122.391018422974 | (37.7550743894922, -122.391018422974) |
| 15196 | 15196 | 85648 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1357 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016534.0204 | 2093632.0271 | 37.7296427448929 | -122.38510885322701 | (37.7296427448929, -122.385108853227) | ||
| 15328 | 15328 | 85611 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1150 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017700.249 | 2092841.4739 | 37.7275364831055 | -122.381022095395 | (37.7275364831055, -122.381022095395) |
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");