Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | |
| 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) | |
| 5925 | 5925 | 95365 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 661 Broadway | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 778058 | 6010478.0762 | 2118518.1883 | 37.797637647796996 | -122.40779910526899 | (37.797637647797, -122.407799105269) | ||
| 53643 | 53643 | 95364 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 661 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 3x3 | Permit Number 778058 | 6010448.4751 | 2118513.4790000003 | 37.797623060035 | -122.407901201302 | (37.797623060035, -122.407901201302) | ||
| 79652 | 79652 | 33600 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 252 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777438 | 6006697.50710205 | 2097748.48992484 | 37.7403966115613 | -122.419406704652 | (37.7403966115613, -122.419406704652) | |
| 128818 | 128818 | 115389 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 378 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776292 | 6007259.3 | 2096222.3 | 37.73623765723679 | -122.417356112468 | (37.7362376572368, -122.417356112468) | ||
| 82224 | 82224 | 67145 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Massasoit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1992 12:00:00 AM | Permit Number 775821 | 6010104.62054101 | 2099298.30623793 | 37.7448433809463 | -122.40773544745701 | (37.7448433809463, -122.407735447457) | ||
| 80922 | 80922 | 110524 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 995X Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2015 12:00:00 AM | 3 | Permit Number 775198 | 6003269.726980001 | 2111024.20368 | 37.7766548889563 | -122.43220646236401 | (37.7766548889563, -122.432206462364) | ||
| 138868 | 138868 | 108376 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 995X Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2015 12:00:00 AM | 3 | Permit Number 775198 | 6003269.726980001 | 2111024.20368 | 37.7766548889563 | -122.43220646236401 | (37.7766548889563, -122.432206462364) | ||
| 95677 | 95677 | 59892 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 900 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 3x3 | Permit Number 774687 | 6009909.98280438 | 2103947.38661173 | 37.75759782727221 | -122.408736392824 | (37.7575978272722, -122.408736392824) | |
| 113290 | 113290 | 98121 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 900 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 774687 | 6009897.0 | 2103882.5 | 37.7574189360449 | -122.40877671518999 | (37.7574189360449, -122.40877671519) | ||
| 40781 | 40781 | 101046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 774347 | 6012049.4869099995 | 2119300.00717 | 37.799872179210894 | -122.40241656909201 | (37.7998721792109, -122.402416569092) | ||
| 87927 | 87927 | 101047 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774347 | 6012043.0 | 2119296.0 | 37.799860814363 | -122.40243873444099 | (37.799860814363, -122.402438734441) | |
| 71108 | 71108 | 31557 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 166 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2015 12:00:00 AM | 5 | Permit Number 774125 | 5998574.5828 | 2112531.8751 | 37.7805272390885 | -122.44855688064399 | (37.7805272390885, -122.448556880644) | |
| 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) | |||
| 85640 | 85640 | 108404 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 181-199 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773735 | 6007385.0 | 2107936.0 | 37.7684078844101 | -122.41775154293998 | (37.7684078844101, -122.41775154294) |
| 90141 | 90141 | 91691 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 301-307 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773735 | 6007391.9619889995 | 2107907.789584 | 37.7683308170236 | -122.41772546217501 | (37.7683308170236, -122.417725462175) |
| 113552 | 113552 | 108403 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 301-307 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773735 | 6007391.32185 | 2107918.98153 | 37.768361511451296 | -122.417728469751 | (37.7683615114513, -122.417728469751) |
| 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) | ||
| 22963 | 22963 | 108630 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1469-1471 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772871 | 6002136.635290001 | 2111543.9635799997 | 37.778017709796295 | -122.436163356374 | (37.7780177097963, -122.436163356374) |
| 137742 | 137742 | 102622 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 719 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2014 12:00:00 AM | 1 | Permit Number 772854 | 5992851.12865 | 2110544.54919 | 37.774741661803006 | -122.46821223444401 | (37.774741661803, -122.468212234444) | ||
| 18932 | 18932 | 30938 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1106 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 8 | 3x3 | Permit Number 772469 | 5995956.71997 | 2091289.90864 | 37.722052099618104 | -122.456077064214 | (37.7220520996181, -122.456077064214) | |
| 112997 | 112997 | 106644 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3294 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2014 12:00:00 AM | 3X3 | Permit Number 772448 | 6007856.1 | 2100992.4 | 37.7493688530402 | -122.415630356523 | (37.7493688530402, -122.415630356523) | ||
| 165345 | 165345 | 52196 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2013 12:00:00 AM | 2 | Permit Number 770878 | 6007126.92706 | 2119460.55943 | 37.800036988073295 | -122.419461903656 | (37.8000369880733, -122.419461903656) | ||
| 93295 | 93295 | 104872 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1753 Noe St | 1 | Hanging basket : Yard 27 | Tree 1 | Private 1 | 11/22/2013 12:00:00 AM | Permit Number 770054 | 6003434.1 | 2098036.1 | 37.7410019772539 | -122.430710793678 | (37.7410019772539, -122.430710793678) | |||
| 114882 | 114882 | 102862 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2750X Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | Permit Number 769980 | 6000834.2 | 2116922.3 | 37.792711153164 | -122.44105488676901 | (37.792711153164, -122.441054886769) | |||
| 99121 | 99121 | 102169 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 235 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769763 | 6002117.1 | 2104495.4 | 37.758662980429996 | -122.435726513037 | (37.75866298043, -122.435726513037) |
| 117367 | 117367 | 102168 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 235 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769763 | 6002117.1 | 2104495.4 | 37.758662980429996 | -122.435726513037 | (37.75866298043, -122.435726513037) |
| 87274 | 87274 | 102063 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 284 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769726 | 6006232.8 | 2098354.9 | 37.742035492788204 | -122.42105652774099 | (37.7420354927882, -122.421056527741) |
| 144864 | 144864 | 102763 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 50X Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2013 12:00:00 AM | 3x3 | Permit Number 769605 | 5996378.1 | 2106680.6 | 37.7643353262738 | -122.45573242834699 | (37.7643353262738, -122.455732428347) | |
| 121895 | 121895 | 104495 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 31 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2013 12:00:00 AM | 3x3 | Permit Number 769504 | 6005718.7 | 2099293.0 | 37.7445823088547 | -122.422900781394 | (37.7445823088547, -122.422900781394) | ||
| 15489 | 15489 | 30626 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 769481 | 6008034.8095 | 2108530.1235 | 37.7700757544141 | -122.415545973379 | (37.7700757544141, -122.415545973379) | |
| 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) |
| 94122 | 94122 | 81726 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
| 108386 | 108386 | 81728 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 7 | 4x4 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
| 124741 | 124741 | 81725 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 7 | 4x4 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
| 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) | |||
| 76276 | 76276 | 97604 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 445 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2011 12:00:00 AM | 2 | 3x5 | Permit Number 768351 | 6005714.1676 | 2110999.8082 | 37.7767261972703 | -122.423748680625 | (37.7767261972703, -122.423748680625) | |
| 164073 | 164073 | 97605 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 445 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768351 | 6005728.0342 | 2111001.8882 | 37.7767326912067 | -122.42370085981301 | (37.7767326912067, -122.423700859813) | |
| 91340 | 91340 | 96161 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 6 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767793 | 6003680.0 | 2095311.9 | 37.7335358734479 | -122.429666314328 | (37.7335358734479, -122.429666314328) | |
| 87043 | 87043 | 96121 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Bennington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767773 | 6007093.0 | 2096944.0 | 37.7382099281297 | -122.417982227017 | (37.7382099281297, -122.417982227017) | |
| 113864 | 113864 | 96122 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Bennington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767773 | 6007093.0 | 2096944.0 | 37.7382099281297 | -122.417982227017 | (37.7382099281297, -122.417982227017) | |
| 79651 | 79651 | 96102 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2780X 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | ||
| 103743 | 103743 | 96097 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1999 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009553.0 | 2105475.0 | 37.7617723065941 | -122.41007883348301 | (37.7617723065941, -122.410078833483) | ||
| 108509 | 108509 | 96100 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2780X 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | ||
| 142916 | 142916 | 96107 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2780X 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | ||
| 89963 | 89963 | 100410 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201x Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006435.0 | 2110776.0 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | |||
| 107211 | 107211 | 100415 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201x Linden St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767727 | 6006435.0 | 2110776.0 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | ||||
| 107726 | 107726 | 100414 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201x Linden St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767727 | 6006435.0 | 2110776.0 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | ||||
| 111508 | 111508 | 100413 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201x Linden St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767727 | 6006435.0 | 2110776.0 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | ||||
| 114370 | 114370 | 100412 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201x Linden St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006435.0 | 2110776.0 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | |||
| 146104 | 146104 | 100411 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201x Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006435.0 | 2110776.0 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | |||
| 90917 | 90917 | 96064 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767689 | 6007344.9 | 2099669.6 | 37.7457079931938 | -122.417304374627 | (37.7457079931938, -122.417304374627) | |
| 128071 | 128071 | 96054 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1261 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767682 | 6009524.0 | 2101832.0 | 37.7517678233481 | -122.40992195715201 | (37.7517678233481, -122.409921957152) | |
| 47443 | 47443 | 96053 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 130 Coso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659.0 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | |
| 95440 | 95440 | 96052 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 130 Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659.0 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | |
| 82753 | 82753 | 96048 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324.0 | 2099841.0 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | |
| 85789 | 85789 | 96047 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324.0 | 2099841.0 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | |
| 143528 | 143528 | 96049 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324.0 | 2099841.0 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | |
| 96831 | 96831 | 94879 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 83 Ledyard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767655 | 6011819.0 | 2094865.0 | 37.7327662839989 | -122.40149589318399 | (37.7327662839989, -122.401495893184) |
| 58447 | 58447 | 95867 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 733 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 7 | 3x3 | Permit Number 767588 | 6008296.37826 | 2120666.6947 | 37.8034145323264 | -122.415500582505 | (37.8034145323264, -122.415500582505) |
| 103447 | 103447 | 95815 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 691 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767553 | 6015464.0 | 2105840.0 | 37.763104051991604 | -122.38966036521799 | (37.7631040519916, -122.389660365218) | |
| 105353 | 105353 | 95812 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 691 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767553 | 6015464.0 | 2105840.0 | 37.763104051991604 | -122.38966036521799 | (37.7631040519916, -122.389660365218) | |
| 119903 | 119903 | 95814 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 691 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767553 | 6015464.0 | 2105840.0 | 37.763104051991604 | -122.38966036521799 | (37.7631040519916, -122.389660365218) | |
| 145278 | 145278 | 95794 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1330 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767537 | 6010317.0 | 2101466.0 | 37.750807279737295 | -122.407153846535 | (37.7508072797373, -122.407153846535) | |
| 117456 | 117456 | 95789 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3631 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767532 | 6006103.9 | 2100790.8 | 37.7487166547031 | -122.421675197163 | (37.7487166547031, -122.421675197163) | |
| 126597 | 126597 | 95782 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3619 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767526 | 6005487.0 | 2104873.0 | 37.7598906214089 | -122.42409870422199 | (37.7598906214089, -122.424098704222) | |
| 127340 | 127340 | 95639 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 252 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767405 | 6006489.0 | 2104635.0 | 37.7592936513862 | -122.42061637293301 | (37.7592936513862, -122.420616372933) | |
| 82719 | 82719 | 95625 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3562 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767392 | 6005880.0 | 2105517.0 | 37.7616810754377 | -122.422785274783 | (37.7616810754377, -122.422785274783) | |
| 94784 | 94784 | 95398 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1436 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767272 | 6003848.0 | 2099901.0 | 37.7461460032944 | -122.429412637248 | (37.7461460032944, -122.429412637248) | |
| 110751 | 110751 | 96109 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 219 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | 3x3 | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | ||
| 32762 | 32762 | 96718 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1340 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2011 12:00:00 AM | 8 | Permit Number 767223 | 6008240.6871 | 2116926.6734700003 | 37.79314223396489 | -122.415428369639 | (37.7931422339649, -122.415428369639) | ||
| 79289 | 79289 | 95302 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 701 Golden Gate Ave | 2 | 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) | ||
| 100112 | 100112 | 95304 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 701 Golden Gate Ave | 4 | 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) | ||
| 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) | |||
| 128875 | 128875 | 95303 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 701 Golden Gate Ave | 3 | 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) | ||
| 81307 | 81307 | 20137 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 898 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54088 | 6003009.7075288 | 2111327.5412022998 | 37.777473032235704 | -122.433127623561 | (37.7774730322357, -122.433127623561) | |
| 102823 | 102823 | 20136 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 890 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54087 | 6003007.0 | 2111306.0 | 37.777413731872 | -122.43313545029301 | (37.777413731872, -122.433135450293) | |
| 112082 | 112082 | 9980 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 810X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2011 12:00:00 AM | 24 | 3X3 | Permit Number 54082 | 6003050.1396073 | 2111037.6486225 | 37.7766793527515 | -122.432967039601 | (37.7766793527515, -122.432967039601) | |
| 106029 | 106029 | 9979 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 810X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2011 12:00:00 AM | 12 | 3X3 | Permit Number 54081 | 6003050.1396073 | 2111037.6486225 | 37.7766793527515 | -122.432967039601 | (37.7766793527515, -122.432967039601) | |
| 117017 | 117017 | 95159 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2721 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | |||
| 102409 | 102409 | 70248 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1248 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53999 | 6008664.66375358 | 2101270.88121733 | 37.750178918205705 | -122.41285400071199 | (37.7501789182057, -122.412854000712) | |
| 114505 | 114505 | 69343 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1720 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1994 12:00:00 AM | Permit Number 53930 | 6006626.00049448 | 2116758.13786967 | 37.7925885900314 | -122.421003322231 | (37.7925885900314, -122.421003322231) | |||
| 43027 | 43027 | 94791 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Laurel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 4 | Permit Number 53892 | 5997983.38903 | 2116351.46746 | 37.79098101110971 | -122.450877583428 | (37.7909810111097, -122.450877583428) | ||
| 60208 | 60208 | 50802 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 539REVISED 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53851 | 5993738.09251 | 2111820.21552 | 37.778295485898 | -122.465236749215 | (37.778295485898, -122.465236749215) |
| 100850 | 100850 | 94681 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 284 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53817 | 6001324.0 | 2096497.0 | 37.7366561951725 | -122.43789651967899 | (37.7366561951725, -122.437896519679) | |
| 138677 | 138677 | 94653 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 486 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53792 | 6003723.0 | 2095910.0 | 37.7351805553154 | -122.42956029154499 | (37.7351805553154, -122.429560291545) | |
| 80787 | 80787 | 94914 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3600 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2010 12:00:00 AM | 3x3 | Permit Number 53781 | 6002902.0 | 2106490.0 | 37.764184223284396 | -122.433154488347 | (37.7641842232844, -122.433154488347) | ||
| 34565 | 34565 | 58091 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1750 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2010 12:00:00 AM | 2 | Permit Number 53771 | 6006613.15875288 | 2116850.06123449 | 37.7928402647887 | -122.42105428501101 | (37.7928402647887, -122.421054285011) | ||
| 85984 | 85984 | 57721 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 231 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2010 12:00:00 AM | Permit Number 53634 | 6004597.07146519 | 2109103.26366214 | 37.7714556250816 | -122.42747790523701 | (37.7714556250816, -122.427477905237) | ||
| 6169 | 6169 | 94205 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 225 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 3 | 4 diameter | Permit Number 53606 | 6012323.95366 | 2116081.4267 | 37.791050043982295 | -122.40124050766501 | (37.7910500439823, -122.401240507665) | |
| 63307 | 63307 | 94179 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 603 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53587 | 6010992.28107 | 2105475.07827 | 37.7618530869812 | -122.405100914986 | (37.7618530869812, -122.405100914986) | |
| 96891 | 96891 | 41132 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 11X Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 53576 | 5998162.17039542 | 2108554.54786356 | 37.769582935081296 | -122.449696907216 | (37.7695829350813, -122.449696907216) | |
| 102205 | 102205 | 41131 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 11X Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 53576 | 5998162.17039542 | 2108554.54786356 | 37.769582935081296 | -122.449696907216 | (37.7695829350813, -122.449696907216) | |
| 117174 | 117174 | 94037 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3664 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2010 12:00:00 AM | 3x3 | Permit Number 53447 | 6003979.0 | 2103071.0 | 37.754857498499206 | -122.429185650078 | (37.7548574984992, -122.429185650078) | ||
| 113156 | 113156 | 93971 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3425X 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | 3 | 3x6 | Permit Number 53400 | 6006959.7 | 2100858.4 | 37.748950490031795 | -122.41872063369101 | (37.7489504900318, -122.418720633691) | |
| 128423 | 128423 | 93972 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3425X 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | 3 | 3x6 | Permit Number 53400 | 6006959.7 | 2100858.4 | 37.748950490031795 | -122.41872063369101 | (37.7489504900318, -122.418720633691) | |
| 79184 | 79184 | 93818 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426001 | (37.7744697656056, -122.40000821426) | ||
| 84970 | 84970 | 93820 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426001 | (37.7744697656056, -122.40000821426) |
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");