Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86559 | 86559 | 41238 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
| 87025 | 87025 | 69100 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33115 | 5992448.84064151 | 2104114.43419147 | 37.757063031457 | -122.469135733901 | (37.757063031457, -122.469135733901) | ||
| 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) | |
| 87293 | 87293 | 52908 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 295 Gaven St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 3x3 | Permit Number 48898 | 6009070.24444642 | 2094849.33610342 | 37.732569516932294 | -122.41099796146001 | (37.7325695169323, -122.41099796146) | ||
| 87368 | 87368 | 48795 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
| 87888 | 87888 | 67079 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 5 Fair Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30476 | 6006639.64114826 | 2099650.94101578 | 37.7456170557754 | -122.419741737079 | (37.7456170557754, -122.419741737079) | ||
| 87921 | 87921 | 88492 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 88077 | 88077 | 111906 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 88425 | 88425 | 49885 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59@ WILDWOOD Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906105995 | 2092991.57857678 | 37.726705001321996 | -122.457372735726 | (37.726705001322, -122.457372735726) | |||
| 88644 | 88644 | 111861 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 201x LOBOS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 5994528.0 | 2088713.0 | 37.714894412350205 | -122.460829096166 | (37.7148944123502, -122.460829096166) | ||||
| 88856 | 88856 | 63299 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3250 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23865 | 6008990.90330008 | 2099756.44910168 | 37.7460389305968 | -122.41161885123199 | (37.7460389305968, -122.411618851232) | ||
| 88863 | 88863 | 92267 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52719 | 5992767.0 | 2098334.0 | 37.7412098217915 | -122.46761506147101 | (37.7412098217915, -122.467615061471) | ||
| 88975 | 88975 | 93819 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 8 | 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) | ||
| 89401 | 89401 | 93828 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 17 | 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) | ||
| 89683 | 89683 | 59918 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 942 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1981 12:00:00 AM | Permit Number 19387 | 6009922.90971034 | 2103712.90059838 | 37.7569547053635 | -122.40867514442101 | (37.7569547053635, -122.408675144421) | ||
| 89744 | 89744 | 93822 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 11 | 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) | ||
| 89771 | 89771 | 63983 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3931 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | Permit Number 24727 | 6004128.82081194 | 2104203.26376934 | 37.757974907554996 | -122.42874823995301 | (37.757974907555, -122.428748239953) | ||
| 89773 | 89773 | 38663 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 840 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | 5x3 | Permit Number 40585 | 6001023.37265886 | 2111553.49114647 | 37.7779805578681 | -122.44001520291401 | (37.7779805578681, -122.440015202914) | ||
| 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) | |||
| 90049 | 90049 | 62441 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22604 | 5999768.9190223 | 2105384.80396899 | 37.76097140351521 | -122.44391146753901 | (37.7609714035152, -122.443911467539) | ||
| 90171 | 90171 | 59898 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 956 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | 9x6 | Permit Number 19365. I marked for a basin expansion. 9'x 6'. SB | 6009927.21867861 | 2103634.73860088 | 37.756740331390205 | -122.40865472852501 | (37.7567403313902, -122.408654728525) | |
| 90181 | 90181 | 63298 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3244 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23864 | 6008988.97404286 | 2099790.91777784 | 37.746133465739604 | -122.411627957335 | (37.7461334657396, -122.411627957335) | ||
| 90200 | 90200 | 88490 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 90314 | 90314 | 67148 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 455 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1992 12:00:00 AM | Permit Number 30579 | 6008250.85869537 | 2096720.89398869 | 37.7376624256589 | -122.413963134562 | (37.7376624256589, -122.413963134562) | ||
| 90598 | 90598 | 43924 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1100X HAMPSHIRE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43515 | 6010276.0 | 2102522.0 | 37.7537045273505 | -122.407370066225 | (37.7537045273505, -122.407370066225) | ||
| 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) | |
| 90960 | 90960 | 48862 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 135 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46853 | 5992938.7152954005 | 2098174.1666423 | 37.7407808726579 | -122.46700971886699 | (37.7407808726579, -122.467009718867) | ||
| 91044 | 91044 | 111484 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1745 FOLSOM ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008026.0 | 2108277.0 | 37.7693802414943 | -122.41555852152901 | (37.7693802414943, -122.415558521529) | ||||
| 91102 | 91102 | 102673 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 616 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997561.0 | 2108438.0 | 37.7692285123205 | -122.451767914676 | (37.7692285123205, -122.451767914676) | ||||
| 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) | |
| 91440 | 91440 | 48465 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 375 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2002 12:00:00 AM | Permit Number 45827 | 6006568.21841965 | 2103932.82117518 | 37.7573700955813 | -122.42029255920099 | (37.7573700955813, -122.420292559201) | ||
| 91593 | 91593 | 87849 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2480 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50600 | 6006948.0 | 2103912.0 | 37.757334318408 | -122.41897764469499 | (37.757334318408, -122.418977644695) | ||
| 91648 | 91648 | 72405 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 266-272 Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2011 12:00:00 AM | 3x3 | 6003874.79643463 | 2104534.37929684 | 37.7588696917871 | -122.42965037889601 | (37.7588696917871, -122.429650378896) | |||
| 91690 | 91690 | 85246 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 121 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2007 12:00:00 AM | Permit Number 49547 | 6001091.3 | 2089693.7 | 37.717962654310206 | -122.43821383738899 | (37.7179626543102, -122.438213837389) | |||
| 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) | |||
| 91771 | 91771 | 65172 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 332 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 27153 | 6003474.08618593 | 2091790.3446491002 | 37.72385481082 | -122.430127080192 | (37.72385481082, -122.430127080192) | ||
| 91868 | 91868 | 68119 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31865 | 6006388.61214572 | 2099880.1544955 | 37.746232279707705 | -122.420626027293 | (37.7462322797077, -122.420626027293) | ||
| 92232 | 92232 | 67147 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 553 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1992 12:00:00 AM | Permit Number 30578 | 6008211.14735723 | 2096290.50771504 | 37.7364784485579 | -122.414069997052 | (37.7364784485579, -122.414069997052) | ||
| 92284 | 92284 | 47639 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.44983409577299 | (37.7806775849758, -122.449834095773) | |||
| 92366 | 92366 | 41896 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 510 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42261 | 6001830.47411913 | 2101497.37413797 | 37.7504148362587 | -122.436503213655 | (37.7504148362587, -122.436503213655) | ||
| 92458 | 92458 | 93817 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 6 | 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) | ||
| 92555 | 92555 | 120872 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 16 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003333.0 | 2105685.0 | 37.761998326992504 | -122.43160630843398 | (37.7619983269925, -122.431606308434) | ||||
| 92856 | 92856 | 35042 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 158 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/1998 12:00:00 AM | Permit Number 38609 | 5996885.33354798 | 2089115.06440217 | 37.7161337438742 | -122.45271020646099 | (37.7161337438742, -122.452710206461) | ||
| 93085 | 93085 | 67308 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2675 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | Permit Number 30789 | 6010066.20973841 | 2103947.45749317 | 37.7576067709091 | -122.40819609919399 | (37.7576067709091, -122.408196099194) | ||
| 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) | |||
| 93128 | 93128 | 64332 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 49 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25160 | 6004309.77102344 | 2097969.94151847 | 37.740869893208604 | -122.427678330625 | (37.7408698932086, -122.427678330625) | ||
| 93254 | 93254 | 60828 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 90 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20507 | 6004536.75040405 | 2101647.15007876 | 37.750979497718895 | -122.427155379561 | (37.7509794977189, -122.427155379561) | ||
| 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) | |||
| 93319 | 93319 | 113204 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3225 26TH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008227.0 | 2100905.0 | 37.7491497143695 | -122.41434158844801 | (37.7491497143695, -122.414341588448) | ||||
| 93327 | 93327 | 112843 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1415 EVANS AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016481.0 | 2097724.0 | 37.7408755487739 | -122.385577218432 | (37.7408755487739, -122.385577218432) | |||||
| 93668 | 93668 | 48814 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
| 93793 | 93793 | 50131 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 131 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46852 | 5992954.93923014 | 2098191.67856897 | 37.7408298924183 | -122.466954895883 | (37.7408298924183, -122.466954895883) | ||
| 93881 | 93881 | 48807 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
| 94048 | 94048 | 121095 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1691 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6001097.0 | 2111345.0 | 37.7774122850927 | -122.439745549 | (37.7774122850927, -122.439745549) | |||
| 94294 | 94294 | 115222 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2252 15TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002543.0 | 2107122.0 | 37.76589916997111 | -122.434441354631 | (37.7658991699711, -122.434441354631) | ||||
| 94359 | 94359 | 67883 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | ||
| 94556 | 94556 | 63324 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 19 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1987 12:00:00 AM | Permit Number 23897 | 6008111.26600081 | 2100057.57736111 | 37.7468163795111 | -122.414681837006 | (37.7468163795111, -122.414681837006) | ||
| 94685 | 94685 | 31311 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 709 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | Permit Number 34949 | 6004473.77987727 | 2110903.29372292 | 37.77639109406471 | -122.428032671161 | (37.7763910940647, -122.428032671161) | |||
| 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) | |
| 94904 | 94904 | 63334 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 247 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1987 12:00:00 AM | Permit Number 23907 | 6010224.52665543 | 2100035.09829556 | 37.7468731626874 | -122.40737276493999 | (37.7468731626874, -122.40737276494) | ||
| 95001 | 95001 | 48798 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
| 95194 | 95194 | 59283 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1940 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | Permit Number 18619 | 6006528.93574422 | 2117463.80018293 | 37.794520690460104 | -122.421389306077 | (37.7945206904601, -122.421389306077) | ||
| 95224 | 95224 | 52907 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 295 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 3x3 | Permit Number 48898 | 6009070.24444642 | 2094849.33610342 | 37.732569516932294 | -122.41099796146001 | (37.7325695169323, -122.41099796146) | ||
| 95367 | 95367 | 63519 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 827 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24129 | 6009937.41426671 | 2104399.10208054 | 37.758839672708795 | -122.40867338931001 | (37.7588396727088, -122.40867338931) | ||
| 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) | |
| 95467 | 95467 | 49612 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
| 95499 | 95499 | 111870 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3399x 16TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004303.0 | 2106535.0 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | ||||
| 95539 | 95539 | 67093 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 437 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30495 | 6008258.04848699 | 2096798.93207666 | 37.7378771049848 | -122.413943794807 | (37.7378771049848, -122.413943794807) | ||
| 95623 | 95623 | 67035 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4212 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/09/1996 12:00:00 AM | Permit Number 30409 4212-4216 25th ST | 6002474.90568284 | 2101241.03339883 | 37.749747583750704 | -122.434256401684 | (37.7497475837507, -122.434256401684) | ||
| 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) | |
| 95835 | 95835 | 67360 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 878 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/1994 12:00:00 AM | Permit Number 30849 | 6009901.77638254 | 2104097.66995535 | 37.7580100118956 | -122.40877537631799 | (37.7580100118956, -122.408775376318) | ||
| 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) | |||
| 95973 | 95973 | 95614 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Temescal Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52561 | 5997427.8 | 2111420.0 | 37.777408683378404 | -122.45244386493 | (37.7774086833784, -122.45244386493) | |
| 96134 | 96134 | 85085 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
| 96588 | 96588 | 49613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
| 96753 | 96753 | 33599 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 250 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2000 12:00:00 AM | Permit Number 38023 | 6006702.31961164 | 2097757.35977095 | 37.740421237233704 | -122.419390693943 | (37.7404212372337, -122.419390693943) | ||
| 96839 | 96839 | 65258 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1121 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1994 12:00:00 AM | Permit Number 28057 | 6009490.15544197 | 2102642.26317624 | 37.753990728209 | -122.41009619440399 | (37.753990728209, -122.410096194404) | ||
| 96854 | 96854 | 60150 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1767 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19681 | 5990891.54356846 | 2103381.184277 | 37.754959614042 | -122.474467896907 | (37.754959614042, -122.474467896907) | ||
| 96879 | 96879 | 63313 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 200 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/17/1987 12:00:00 AM | Permit Number 23879 | 6010030.97718344 | 2099875.64853201 | 37.7464245137314 | -122.408030801171 | (37.7464245137314, -122.408030801171) | ||
| 97041 | 97041 | 68464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 52 Badger St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | Permit Number 32326 | 6002331.05144197 | 2094486.37219697 | 37.7311926873179 | -122.434271012127 | (37.7311926873179, -122.434271012127) | ||
| 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) | |||
| 97068 | 97068 | 58255 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 571 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | Permit Number 17259 | 6014416.53359593 | 2104469.54096159 | 37.759282931321295 | -122.39318732494499 | (37.7592829313213, -122.393187324945) | ||
| 97120 | 97120 | 31159 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 159 Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34861 | 5992168.57477518 | 2088923.19870563 | 37.7153355266741 | -122.46899947505 | (37.7153355266741, -122.46899947505) | ||
| 97129 | 97129 | 52059 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3165 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2005 12:00:00 AM | Permit Number 48256 | 6006783.78749917 | 2099933.06553583 | 37.746399825173 | -122.419263309296 | (37.746399825173, -122.419263309296) | |||
| 97467 | 97467 | 33438 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 193 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37541 | 6006477.65745838 | 2098616.29315883 | 37.74276701964221 | -122.420228434519 | (37.7427670196422, -122.420228434519) | |||
| 97538 | 97538 | 48793 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
| 97674 | 97674 | 43564 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 526 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43225 | 6003158.767551099 | 2098938.54547266 | 37.7434642809487 | -122.431727208875 | (37.7434642809487, -122.431727208875) | ||
| 97789 | 97789 | 31405 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4249 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | Permit Number 34995 | 6002250.83987816 | 2104099.74238816 | 37.757584195724796 | -122.435235679993 | (37.7575841957248, -122.435235679993) | ||
| 97895 | 97895 | 63879 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 875 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24585 | 6003771.56035728 | 2103192.85822001 | 37.75518034706371 | -122.42991172572901 | (37.7551803470637, -122.429911725729) | ||
| 98062 | 98062 | 67352 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 717 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | Permit Number 30839 | 6009877.21421947 | 2104936.10972509 | 37.7603108025835 | -122.40891947836398 | (37.7603108025835, -122.408919478364) | ||
| 98228 | 98228 | 83904 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50528 | 6000071.45882216 | 2091861.79510204 | 37.7238576929528 | -122.441894497682 | (37.7238576929528, -122.441894497682) | ||
| 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) | |||
| 98807 | 98807 | 111488 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1745 FOLSOM ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008026.0 | 2108277.0 | 37.7693802414943 | -122.41555852152901 | (37.7693802414943, -122.415558521529) | ||||
| 99506 | 99506 | 63530 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 646 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | Permit Number 24142 | 6007872.84604316 | 2104161.66223949 | 37.7580718687454 | -122.415796831621 | (37.7580718687454, -122.415796831621) | ||
| 99727 | 99727 | 112868 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 99825 | 99825 | 60629 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 461 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20255 | 6003690.91133261 | 2096147.61954597 | 37.7358311876742 | -122.429688175872 | (37.7358311876742, -122.429688175872) | ||
| 99992 | 99992 | 83347 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4008 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52602 | 6002921.13723992 | 2105359.07912113 | 37.7610800735552 | -122.433007493787 | (37.7610800735552, -122.433007493787) | |
| 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) | ||
| 100240 | 100240 | 63340 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3215 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1987 12:00:00 AM | Permit Number 23913 | 6009031.24649306 | 2099966.16715639 | 37.7466170329515 | -122.41149416326999 | (37.7466170329515, -122.41149416327) | ||
| 100440 | 100440 | 60621 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20246 | 6004468.77441112 | 2096758.98359533 | 37.7375538708016 | -122.42704232686 | (37.7375538708016, -122.42704232686) |
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");