Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10638 | 10638 | 96234 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/15/2011 12:00:00 AM | Permit Number 767856 | ||||||||||
| 11641 | 11641 | 96232 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | ||||||||||||
| 13297 | 13297 | 173883 | Undocumented 2 | Tree(s) :: 17 | 127 Holloway Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779596 | 5996444.0 | 2091166.0 | 37.721739833175 | -122.454383721237 | (37.721739833175, -122.454383721237) | ||
| 16044 | 16044 | 96231 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | ||||||||||||
| 18642 | 18642 | 106966 | Undocumented 2 | Tree(s) :: 17 | 2391 47TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981720.8 | 2098834.4 | 37.7419398125124 | -122.505845312535 | (37.7419398125124, -122.505845312535) | ||||||
| 19599 | 19599 | 106501 | Undocumented 2 | Tree(s) :: 17 | 1266 09TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5993358.0 | 2106830.8 | 37.764573953722 | -122.46618893715001 | (37.764573953722, -122.46618893715) | |||||
| 25407 | 25407 | 95032 | Tree(s) :: 17 | 211 Maynard St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 6004772.0 | 2093802.0 | 37.729451797878205 | -122.425783519869 | (37.7294517978782, -122.425783519869) | |||||||
| 30135 | 30135 | 105475 | Undocumented 2 | Tree(s) :: 17 | 671 Waller St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2014 12:00:00 AM | 3x3 | 6002476.36422 | 2108834.33955 | 37.770597051265604 | -122.434794296397 | (37.7705970512656, -122.434794296397) | ||||
| 30542 | 30542 | 86751 | Permitted Site 1 | Tree(s) :: 17 | 81 Parker Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | ||||
| 42981 | 42981 | 106868 | Undocumented 2 | Tree(s) :: 17 | 1956 GREAT HWY | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5981193.7 | 2101737.6 | 37.749880147789895 | -122.507883225183 | (37.7498801477899, -122.507883225183) | ||||||
| 50166 | 50166 | 95953 | Significant Tree 6 | Tree(s) :: 17 | 499 Buena Vista East Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/18/2011 12:00:00 AM | 21 | Permit Number 57015 | 6000177.0 | 2107098.0 | 37.7656986843565 | -122.442623109531 | (37.7656986843565, -122.442623109531) | |||
| 62735 | 62735 | 92823 | Permitted Site 1 | Tree(s) :: 17 | 50 Kirkham St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2009 12:00:00 AM | 3x3 | Permit Number 53037 | 5994776.3 | 2105346.5 | 37.760580177714296 | -122.461175855238 | (37.7605801777143, -122.461175855238) | |||
| 77577 | 77577 | 107520 | Undocumented 2 | Tree(s) :: 17 | 2 CHURCH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004041.5 | 2108639.2 | 37.7701499806884 | -122.42936655700701 | (37.7701499806884, -122.429366557007) | ||||||
| 77894 | 77894 | 107651 | Undocumented 2 | Tree(s) :: 17 | 2908 23RD ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009361.7 | 2102802.2 | 37.7544226781239 | -122.41055171892201 | (37.7544226781239, -122.410551718922) | ||||||
| 78075 | 78075 | 104299 | Permitted Site 1 | Tree(s) :: 17 | 4021 20TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x4 | 6003557.0 | 2104154.0 | 37.75780726103579 | -122.430722322319 | (37.7578072610358, -122.430722322319) | |||||
| 78299 | 78299 | 93555 | Permitted Site 1 | Tree(s) :: 17 | 290 Green St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2010 12:00:00 AM | 3x3 | Permit Number 53175 | 6011548.0 | 2119416.0 | 37.80016265957239 | -122.40416007916401 | (37.8001626595724, -122.404160079164) | |||
| 78494 | 78494 | 94522 | Permitted Site 1 | Tree(s) :: 17 | 524 Howard St | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 08/30/2010 12:00:00 AM | Permit Number 53710 | 6013519.0 | 2114878.0 | 37.7878123136723 | -122.397021246793 | (37.7878123136723, -122.397021246793) | ||||
| 78970 | 78970 | 106970 | Undocumented 2 | Tree(s) :: 17 | 30 Piedmont St | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/11/2014 12:00:00 AM | Permit Number 772781 | 5999571.08265 | 2107127.2788400003 | 37.76574451836729 | -122.444720943629 | (37.7657445183673, -122.444720943629) | ||||
| 79071 | 79071 | 95369 | Tree(s) :: 17 | 27 Hartford St | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 02/18/2011 12:00:00 AM | 6002651.0 | 2105744.0 | 37.7621216467866 | -122.433969295968 | (37.7621216467866, -122.433969295968) | ||||||
| 79354 | 79354 | 106559 | Permitted Site 1 | Tree(s) :: 17 | 2630 Bay Shore Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2014 12:00:00 AM | 3x3 | Permit Number 772167 | 6010472.4 | 2086044.7 | 37.7084723291496 | -122.405530459051 | (37.7084723291496, -122.405530459051) | |||
| 79393 | 79393 | 106516 | Permitted Site 1 | Tree(s) :: 17 | 366 Hill St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/07/2014 12:00:00 AM | 3X3 | Permit Number 772751 | 6003996.2 | 2103381.7 | 37.755711581068795 | -122.42914832014 | (37.7557115810688, -122.42914832014) | |||
| 80300 | 80300 | 86765 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 80420 | 80420 | 105844 | Significant Tree 6 | Tree(s) :: 17 | 355 Buena Vista Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/03/2014 12:00:00 AM | Permit Number 771052 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.44021490806801 | (37.767492540377, -122.440214908068) | ||||
| 80431 | 80431 | 106930 | Undocumented 2 | Tree(s) :: 17 | 560 Jersey St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2014 12:00:00 AM | 3X3 | Permit Number 772858 | 6001503.6522699995 | 2101489.5191200003 | 37.750374691310604 | -122.43763282240499 | (37.7503746913106, -122.437632822405) | |||
| 80534 | 80534 | 96292 | Permitted Site 1 | Tree(s) :: 17 | 1294 Union St | Sidewalk: Property side : Pot 6 | Landscaping 2 | Private 1 | 03/21/2011 12:00:00 AM | 6006773.0 | 2119090.0 | 37.7989995844362 | -122.420660308797 | (37.7989995844362, -122.420660308797) | |||||
| 80672 | 80672 | 98502 | Property Tree 7 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999066.0 | 2100737.0 | 37.7481695560511 | -122.44600824337601 | (37.7481695560511, -122.446008243376) | ||||||
| 81042 | 81042 | 112562 | Permitted Site 1 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.47414022419301 | (37.7515380150924, -122.474140224193) | ||||
| 81746 | 81746 | 100074 | Undocumented 2 | Tree(s) :: 17 | 701 Noe St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003070.0 | 2104166.0 | 37.7578126071811 | -122.43240742658399 | (37.7578126071811, -122.432407426584) | ||||||
| 82720 | 82720 | 98465 | Property Tree 7 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | ||||||
| 83455 | 83455 | 89234 | Permitted Site 1 | Tree(s) :: 17 | 239 08th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2008 12:00:00 AM | 3x3 | Permit Number 51868 | 6009415.9 | 2110603.1 | 37.7758451977468 | -122.41091521392 | (37.7758451977468, -122.41091521392) | |||
| 83863 | 83863 | 107650 | Undocumented 2 | Tree(s) :: 17 | 888 DUNCAN ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000841.2 | 2099697.3 | 37.74541599809321 | -122.439795143209 | (37.7454159980932, -122.439795143209) | ||||||
| 84583 | 84583 | 107865 | Permitted Site 1 | Tree(s) :: 17 | 570 BEALE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015852.9 | 2114012.6 | 37.7855657638563 | -122.388885877785 | (37.7855657638563, -122.388885877785) | |||||
| 85065 | 85065 | 86741 | Permitted Site 1 | Tree(s) :: 17 | 1275 02nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2007 12:00:00 AM | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | ||||
| 85738 | 85738 | 89356 | Permitted Site 1 | Tree(s) :: 17 | 3 Peralta Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2008 12:00:00 AM | 3x3 | Permit Number 51937 | 6010899.0 | 2100465.1 | 37.74809158087729 | -122.40507075934099 | (37.7480915808773, -122.405070759341) | |||
| 85837 | 85837 | 100841 | Undocumented 2 | Tree(s) :: 17 | 139 Stillman St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014008.0 | 2112974.0 | 37.782611576233 | -122.39519596308998 | (37.782611576233, -122.39519596309) | |||||
| 86139 | 86139 | 89139 | Permitted Site 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||||
| 87031 | 87031 | 86839 | Permitted Site 1 | Tree(s) :: 17 | 2238 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001026.6 | 2113503.7 | 37.7833355182269 | -122.440143921372 | (37.7833355182269, -122.440143921372) | |||||
| 87250 | 87250 | 93936 | Permitted Site 1 | Tree(s) :: 17 | 230 Seacliff Ave | Sidewalk: Curb side : 21 | Landscaping 2 | Private 1 | 04/26/2010 12:00:00 AM | 37x6 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | ||||
| 87256 | 87256 | 106063 | Undocumented 2 | Tree(s) :: 17 | 274 MONTICELLO ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991733.9 | 2090351.1 | 37.7192310708749 | -122.470605827889 | (37.7192310708749, -122.470605827889) | |||||
| 87795 | 87795 | 107402 | Undocumented 2 | Tree(s) :: 17 | 88 LUNDYS LN | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006885.0 | 2099070.0 | 37.744035741100504 | -122.418852127392 | (37.7440357411005, -122.418852127392) | ||||||
| 87957 | 87957 | 107774 | Permitted Site 1 | Tree(s) :: 17 | 4532 17TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999156.7 | 2105780.6 | 37.762023219674894 | -122.44605732695 | (37.7620232196749, -122.44605732695) | |||||
| 88531 | 88531 | 92637 | Permitted Site 1 | Tree(s) :: 17 | 254 San Jose Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2009 12:00:00 AM | 3x3 | Permit Number 52928 | 6006132.5 | 2101681.8 | 37.7511647494644 | -122.421639572935 | (37.7511647494644, -122.421639572935) | |||
| 88781 | 88781 | 92824 | Permitted Site 1 | Tree(s) :: 17 | 75 Buena Vista Ter | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2009 12:00:00 AM | 3x3 | Permit Number 53038 | 6001499.7 | 2107781.6 | 37.7676509917015 | -122.43809715918002 | (37.7676509917015, -122.43809715918) | |||
| 89122 | 89122 | 107161 | Undocumented 2 | Tree(s) :: 17 | 3772 20TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2014 12:00:00 AM | 3 | 5x5 | Permit Number 773829 | 6005193.3 | 2104336.4 | 37.7584006572295 | -122.42507628966001 | (37.7584006572295, -122.42507628966) | ||
| 89166 | 89166 | 102275 | Property Tree 7 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001225.6 | 2097744.2 | 37.740075118911705 | -122.438326054857 | (37.7400751189117, -122.438326054857) | ||||||
| 89339 | 89339 | 106328 | Permitted Site 1 | Tree(s) :: 17 | 4309 19th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/2014 12:00:00 AM | 3X3 | Permit Number 772711 | 6001662.1 | 2104635.3 | 37.7590212565974 | -122.437310124809 | (37.7590212565974, -122.437310124809) | |||
| 89524 | 89524 | 89326 | Permitted Site 1 | Tree(s) :: 17 | 22 Banbury Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2008 12:00:00 AM | 3x3 | Permit Number 51917 | 5990779.0 | 2090643.0 | 37.7199772923765 | -122.47392780719 | (37.7199772923765, -122.47392780719) | |||
| 89740 | 89740 | 86764 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 90103 | 90103 | 100046 | Property Tree 7 | Tree(s) :: 17 | 562 28th St | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/28/2012 12:00:00 AM | 17 | Permit Number 769057 | 6002262.0 | 2099459.0 | 37.7448424535299 | -122.43486521318898 | (37.7448424535299, -122.434865213189) | |||
| 90271 | 90271 | 94521 | Permitted Site 1 | Tree(s) :: 17 | 524 Howard St | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 08/30/2010 12:00:00 AM | Permit Number 53710 | 6013519.0 | 2114878.0 | 37.7878123136723 | -122.397021246793 | (37.7878123136723, -122.397021246793) | ||||
| 90434 | 90434 | 86778 | Permitted Site 1 | Tree(s) :: 17 | 1201SAWYER Sunnydale Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49246 | 6008311.7 | 2086994.1 | 37.7109581313437 | -122.41306521032699 | (37.7109581313437, -122.413065210327) | |||||
| 90578 | 90578 | 93983 | Permitted Site 1 | Tree(s) :: 17 | 560 Noe St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2010 12:00:00 AM | 3x3 | Permit Number 53407 | 6002980.0 | 2104981.0 | 37.760045297905705 | -122.432776903654 | (37.7600452979057, -122.432776903654) | |||
| 90686 | 90686 | 106490 | Permitted Site 1 | Tree(s) :: 17 | 74 Tehama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2014 12:00:00 AM | 3x3 | Permit Number 772723 | 6013483.0 | 2114541.0 | 37.786884985906404 | -122.397122161673 | (37.7868849859064, -122.397122161673) | |||
| 90699 | 90699 | 107810 | Permitted Site 1 | Tree(s) :: 17 | 2 BARTLETT ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006662.0 | 2103492.0 | 37.7561649865508 | -122.419936943866 | (37.7561649865508, -122.419936943866) | |||||
| 90732 | 90732 | 107620 | Undocumented 2 | Tree(s) :: 17 | 138 CORTLAND AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006430.5 | 2097564.1 | 37.7398752757691 | -122.420316827642 | (37.7398752757691, -122.420316827642) | ||||||
| 90958 | 90958 | 107777 | Permitted Site 1 | Tree(s) :: 17 | 348 DUNCAN ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003988.0 | 2099873.0 | 37.74607704710979 | -122.42892653911899 | (37.7460770471098, -122.428926539119) | |||||
| 91108 | 91108 | 97177 | Property Tree 7 | Tree(s) :: 17 | 257 Roosevelt Way | Back Yard : Yard 13 | Tree 1 | Private 1 | Monterey cypress tree in backyard on private property; not a Significant tree | 6000848.1 | 2107127.9 | 37.765819014897296 | -122.44030407045099 | (37.7658190148973, -122.440304070451) | |||||
| 91444 | 91444 | 107078 | Undocumented 2 | Tree(s) :: 17 | 92 Homestead St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 07/25/2014 12:00:00 AM | 3x3.5 | Permit Number 773562 | 6000948.33481 | 2101213.46128 | 37.7495851129185 | -122.439533357227 | (37.7495851129185, -122.439533357227) | |||
| 92048 | 92048 | 111996 | Significant Tree 6 | Tree(s) :: 17 | 501 Point Lobos Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775626 | 5981249.6 | 2112592.5 | 37.779687857228296 | -122.508495636007 | (37.7796878572283, -122.508495636007) | ||
| 92240 | 92240 | 28968 | DPW Maintained 3 | Tree(s) :: 17 | 2455 Hyde St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | ||||||
| 92476 | 92476 | 107359 | Undocumented 2 | Tree(s) :: 17 | 3636 Clay St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 771771 | 5997400.59946 | 2115444.59193 | 37.788457593521706 | -122.452828517416 | (37.7884575935217, -122.452828517416) | |||||
| 92617 | 92617 | 104826 | Permitted Site 1 | Tree(s) :: 17 | 52 Alpine Ter | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770816 | 6001492.3 | 2108495.8 | 37.769611587105295 | -122.438173923211 | (37.7696115871053, -122.438173923211) | ||||
| 92684 | 92684 | 115379 | Undocumented 2 | Tree(s) :: 17 | 4004 20TH ST | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6003604.0 | 2104237.0 | 37.758037821948 | -122.43056569919399 | (37.758037821948, -122.430565699194) | |||||
| 94096 | 94096 | 100243 | Private 5 | Tree(s) :: 17 | 1326-1332 Shotwell St | unknown : Yard 19 | Tree 1 | Private 1 | 6008043.0 | 2100485.0 | 37.7479861507453 | -122.41494814206699 | (37.7479861507453, -122.414948142067) | ||||||
| 94603 | 94603 | 86780 | Permitted Site 1 | Tree(s) :: 17 | 1201SAWYER Sunnydale Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49246 | 6008311.7 | 2086994.1 | 37.7109581313437 | -122.41306521032699 | (37.7109581313437, -122.413065210327) | |||||
| 94734 | 94734 | 98893 | Property Tree 7 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2100761.0 | 37.7482265448319 | -122.44654941060699 | (37.7482265448319, -122.446549410607) | ||||||
| 94897 | 94897 | 86775 | Permitted Site 1 | Tree(s) :: 17 | 21 Commonwealth Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2007 12:00:00 AM | 3x3 | Permit Number 49747 | 5996467.0 | 2114425.1 | 37.7856047990731 | -122.455984873003 | (37.7856047990731, -122.455984873003) | |||
| 95311 | 95311 | 112564 | Permitted Site 1 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.47414022419301 | (37.7515380150924, -122.474140224193) | ||||
| 95399 | 95399 | 95952 | Undocumented 2 | Tree(s) :: 17 | 46 Bosworth St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 1x1 | 6004452.0 | 2095346.0 | 37.733673188028796 | -122.426999715945 | (37.7336731880288, -122.426999715945) | ||||
| 95507 | 95507 | 104304 | Permitted Site 1 | Tree(s) :: 17 | 414 LIBERTY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | 2x4 | Permit Number 770200 | 6003582.0 | 2103943.0 | 37.7572293215726 | -122.43062080588899 | (37.7572293215726, -122.430620805889) | |||
| 96055 | 96055 | 107245 | Significant Tree 6 | Tree(s) :: 17 | 140 CEDRO AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991993.7 | 2093259.3 | 37.727231291852604 | -122.469919436342 | (37.7272312918526, -122.469919436342) | ||||||
| 96557 | 96557 | 107036 | Significant Tree 6 | Tree(s) :: 17 | 350 08th St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 7x7 | Permit Number 772214 | 6009826.0 | 2110084.0 | 37.774442857676505 | -122.409459923405 | (37.7744428576765, -122.409459923405) | |||
| 97106 | 97106 | 102276 | Private 5 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.43839895973301 | (37.7402178594385, -122.438398959733) | ||||||
| 97448 | 97448 | 107454 | Undocumented 2 | Tree(s) :: 17 | 2101 CHESTNUT ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001686.4 | 2119715.1 | 37.8004279539124 | -122.43830641537201 | (37.8004279539124, -122.438306415372) | ||||||
| 97565 | 97565 | 106145 | Permitted Site 1 | Tree(s) :: 17 | 89 Belgrave Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 771523 | 5998082.7 | 2104872.2 | 37.7594675922154 | -122.449706395213 | (37.7594675922154, -122.449706395213) | |||||
| 97921 | 97921 | 105773 | Permitted Site 1 | Tree(s) :: 17 | 105 Hoffman Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771196 | 6000637.4 | 2102505.5 | 37.75311503846461 | -122.44070124277201 | (37.7531150384646, -122.440701242772) | ||||
| 98130 | 98130 | 95234 | Significant Tree 6 | Tree(s) :: 17 | 7 Almaden Ct | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/25/2011 12:00:00 AM | Permit Number 767129 | 5995849.0 | 2112535.0 | 37.780379598944705 | -122.457986127959 | (37.7803795989447, -122.457986127959) | ||||
| 98291 | 98291 | 98892 | Property Tree 7 | Tree(s) :: 17 | 220 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998935.0 | 2100753.0 | 37.7482060067302 | -122.44646238623999 | (37.7482060067302, -122.44646238624) | ||||||
| 98453 | 98453 | 93908 | Permitted Site 1 | Tree(s) :: 17 | 1238 Sutter St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | Permit Number 53382 | 6006657.0 | 2114990.0 | 37.787735469045295 | -122.420770480664 | (37.7877354690453, -122.420770480664) | ||||
| 98636 | 98636 | 106912 | Permitted Site 1 | Tree(s) :: 17 | 2447 TARAVAL ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5985552.6 | 2098834.9 | 37.7421659771756 | -122.49259640996 | (37.7421659771756, -122.49259640996) | ||||||
| 98769 | 98769 | 112422 | Undocumented 2 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775772 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.43839895973301 | (37.7402178594385, -122.438398959733) | ||
| 98835 | 98835 | 107295 | Undocumented 2 | Tree(s) :: 17 | 218 Howth St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2014 12:00:00 AM | Permit Number 773357 | 5997350.11104 | 2090721.936 | 37.7205724606378 | -122.451219539387 | (37.7205724606378, -122.451219539387) | ||||
| 98890 | 98890 | 107525 | Permitted Site 1 | Tree(s) :: 17 | 3606 TARAVAL ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981997.1 | 2098820.7 | 37.74191845501429 | -122.504888957614 | (37.7419184550143, -122.504888957614) | ||||||
| 99182 | 99182 | 89237 | Permitted Site 1 | Tree(s) :: 17 | 1391 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2014 12:00:00 AM | 3x3 | Permit Number 773358 | 5999019.0 | 2104613.0 | 37.7588094164011 | -122.44644957324199 | (37.7588094164011, -122.446449573242) | |||
| 99502 | 99502 | 94588 | Permitted Site 1 | Tree(s) :: 17 | 4080 24th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2010 12:00:00 AM | 3x3 | Permit Number 53765 | 6002663.9 | 2101828.7 | 37.7513719025488 | -122.433644846842 | (37.7513719025488, -122.433644846842) | |||
| 99533 | 99533 | 100242 | Private 5 | Tree(s) :: 17 | 76 Linda St | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 6005815.0 | 2105046.0 | 37.76038415245 | -122.422976606568 | (37.76038415245, -122.422976606568) | ||||||
| 99802 | 99802 | 98890 | Property Tree 7 | Tree(s) :: 17 | 256 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999134.0 | 2100748.0 | 37.748203642185395 | -122.44577389345 | (37.7482036421854, -122.44577389345) | ||||||
| 99874 | 99874 | 88530 | Permitted Site 1 | Tree(s) :: 17 | 1930x Pine St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772191 | 6004696.0 | 2115413.0 | 37.788786198561795 | -122.427585317117 | (37.7887861985618, -122.427585317117) | ||
| 100274 | 100274 | 99610 | Undocumented 2 | Tree(s) :: 17 | 111 Corwin St | Unaccepted Street : Yard 14 | Landscaping 2 | Private 1 | 6000616.0 | 2104331.0 | 37.7581261988062 | -122.44090619353999 | (37.7581261988062, -122.44090619354) | ||||||
| 100393 | 100393 | 106237 | Undocumented 2 | Tree(s) :: 17 | 607 BRUSSELS ST | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010922.6 | 2091903.6 | 37.724584840413996 | -122.404386617586 | (37.724584840414, -122.404386617586) | ||||||
| 100936 | 100936 | 96291 | Permitted Site 1 | Tree(s) :: 17 | 1294 Union St | Sidewalk: Property side : Pot 6 | Landscaping 2 | Private 1 | 03/21/2011 12:00:00 AM | 6006773.0 | 2119090.0 | 37.7989995844362 | -122.420660308797 | (37.7989995844362, -122.420660308797) | |||||
| 100943 | 100943 | 106496 | Permitted Site 1 | Tree(s) :: 17 | 352 Corbett Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2014 12:00:00 AM | 4X3 | Permit Number 772747 | 5999237.2 | 2105011.2 | 37.759915235247995 | -122.445723576033 | (37.759915235248, -122.445723576033) | |||
| 101229 | 101229 | 85273 | Permitted Site 1 | Tree(s) :: 17 | 36 Santa Cruz Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 5993017.1 | 2086630.8 | 37.709090137513 | -122.465900153218 | (37.709090137513, -122.465900153218) | ||||||
| 101468 | 101468 | 107283 | Undocumented 2 | Tree(s) :: 17 | 4214 26TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002441.8 | 2100664.9 | 37.7481637783896 | -122.434329697409 | (37.7481637783896, -122.434329697409) | ||||||
| 101497 | 101497 | 105219 | Undocumented 2 | Tree(s) :: 17 | 1799X 26TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988124.0 | 2103397.0 | 37.7548423040305 | -122.48403988838899 | (37.7548423040305, -122.484039888389) | |||||
| 102637 | 102637 | 107643 | DPW Maintained 3 | Tree(s) :: 17 | 455 ATHENS ST | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 4x4 | 6003769.0 | 2090659.8 | 37.720767283734105 | -122.429027043999 | (37.7207672837341, -122.429027043999) | ||||
| 103006 | 103006 | 106092 | Permitted Site 1 | Tree(s) :: 17 | 2397 Diamond St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2014 12:00:00 AM | 3x3 | Permit Number 769667 | 6001819.7 | 2097112.6 | 37.7383746657841 | -122.436226715207 | (37.7383746657841, -122.436226715207) | |||
| 103600 | 103600 | 98436 | Property Tree 7 | Tree(s) :: 17 | 238 Glenview Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999035.0 | 2100736.0 | 37.7481650400364 | -122.446115368035 | (37.7481650400364, -122.446115368035) | ||||||
| 103866 | 103866 | 87188 | Significant Tree 6 | Tree(s) :: 17 | 2119 Bush St | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | Permit Number 50204 | 6002998.0 | 2114831.0 | 37.787091984974104 | -122.433418544226 | (37.7870919849741, -122.433418544226) | ||||
| 104353 | 104353 | 98250 | Permitted Site 1 | Tree(s) :: 17 | 650 Eddy St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | Sidewalk landscaping permit adjacent to building. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) |
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");