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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78563 | 78563 | 47357 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 401 Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45281 | 5992189.97123037 | 2090518.77996357 | 37.7197178411259 | -122.469041573173 | (37.7197178411259, -122.469041573173) | |||
| 78592 | 78592 | 38001 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2460 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40213 | 5992065.65260132 | 2098696.41331766 | 37.7421643974791 | -122.47006643116 | (37.7421643974791, -122.47006643116) | ||
| 78659 | 78659 | 35985 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 135 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39138 | 6006346.33672477 | 2097504.87289585 | 37.7397079084401 | -122.42060362628901 | (37.7397079084401, -122.420603626289) | ||
| 78726 | 78726 | 38651 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 76 Deming St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/1998 12:00:00 AM | Permit Number 40573 | 5999160.14678713 | 2105227.68643881 | 37.7605052535528 | -122.44600563571501 | (37.7605052535528, -122.446005635715) | |||
| 78834 | 78834 | 47027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 332 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/25/2002 12:00:00 AM | Permit Number 45022 | 6002753.52600326 | 2109683.5809307 | 37.77294459037179 | -122.433896303244 | (37.7729445903718, -122.433896303244) | ||
| 78864 | 78864 | 97952 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2 Mendosa Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | |||||
| 78907 | 78907 | 46184 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 841 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44511 | 5997623.38792866 | 2107669.89260679 | 37.767123058720706 | -122.451496709211 | (37.7671230587207, -122.451496709211) | ||
| 78917 | 78917 | 46863 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 96 Athens St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | Permit Number 44930 | 6004995.61677719 | 2092705.22653245 | 37.726452934298 | -122.424932453632 | (37.726452934298, -122.424932453632) | |||
| 78933 | 78933 | 37575 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 72 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40007 | 6001986.3327137 | 2105443.64764807 | 37.761259209908204 | -122.436246626023 | (37.7612592099082, -122.436246626023) | ||
| 78987 | 78987 | 60586 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1539 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | Permit Number 20203 | 6000401.58465504 | 2110947.80103865 | 37.7762820704764 | -122.442122693377 | (37.7762820704764, -122.442122693377) | ||
| 79000 | 79000 | 39145 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3330 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40820 | 6007564.50118808 | 2100613.04522011 | 37.7483108345809 | -122.416611844962 | (37.7483108345809, -122.416611844962) | |||
| 79052 | 79052 | 31257 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990814.37101 | 2097777.29501 | 37.739568319433104 | -122.47432587378599 | (37.7395683194331, -122.474325873786) | ||
| 79053 | 79053 | 48648 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 136 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45941 | 5993890.54218032 | 2104640.94515626 | 37.758591893357504 | -122.46418804186399 | (37.7585918933575, -122.464188041864) | ||
| 79090 | 79090 | 68593 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1766 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32494 | 5991252.00487941 | 2103443.53443164 | 37.7551516891549 | -122.473225878929 | (37.7551516891549, -122.473225878929) | ||
| 79225 | 79225 | 40774 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 45 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41733 | 5991509.03275031 | 2091578.2410006002 | 37.722587492429106 | -122.47147247116501 | (37.7225874924291, -122.471472471165) | ||
| 79250 | 79250 | 45439 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 660 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2001 12:00:00 AM | Permit Number 44226 | 5993379.37180742 | 2091524.88455142 | 37.7225490119239 | -122.465003304293 | (37.7225490119239, -122.465003304293) | ||
| 79252 | 79252 | 64520 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 433 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | Permit Number 25402 | 6000639.30708593 | 2110429.29392401 | 37.774871925888796 | -122.441263136485 | (37.7748719258888, -122.441263136485) | ||
| 79253 | 79253 | 43518 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3966 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43193 | 6008375.23965972 | 2096657.08362143 | 37.73749420119729 | -122.413528576903 | (37.7374942011973, -122.413528576903) | ||
| 79286 | 79286 | 64552 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 446 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | Permit Number 29779 | 6000207.51332852 | 2110416.28372075 | 37.7748115969963 | -122.442755862923 | (37.7748115969963, -122.442755862923) | ||
| 79329 | 79329 | 58369 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 441 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50945 | 6003608.4206591 | 2096400.34972809 | 37.736520455868 | -122.429991401045 | (37.736520455868, -122.429991401045) | ||
| 79367 | 79367 | 121669 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 92X Fairfield Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993836.0 | 2093526.0 | 37.728069907404794 | -122.463570014172 | (37.7280699074048, -122.463570014172) | ||||
| 79448 | 79448 | 42039 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 186 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42359 | 6004732.95354078 | 2098732.8034677 | 37.742988466771 | -122.42626942175899 | (37.742988466771, -122.426269421759) | ||
| 79449 | 79449 | 42553 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 82 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42645 | 5993073.36121291 | 2094485.358364 | 37.7306600968778 | -122.46627615105 | (37.7306600968778, -122.46627615105) | ||
| 79475 | 79475 | 42430 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100@ Detroit Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2011 12:00:00 AM | 3x3 | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 79541 | 79541 | 31081 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 196 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34818 | 6005439.37562614 | 2108486.56772635 | 37.769809930745 | -122.42452045534901 | (37.769809930745, -122.424520455349) | ||
| 79559 | 79559 | 47344 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 637 Garfield St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45270 | 5992377.81868219 | 2090468.81878363 | 37.7195915118568 | -122.46838862425899 | (37.7195915118568, -122.468388624259) | ||
| 79569 | 79569 | 47924 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 500 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2002 12:00:00 AM | Permit Number 45660 | 6000180.73439645 | 2110607.3459333 | 37.7753346787069 | -122.44286221948201 | (37.7753346787069, -122.442862219482) | ||
| 79574 | 79574 | 71506 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3561 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52227 | 6006556.23822611 | 2104337.9464848 | 37.758481800663795 | -122.420362745806 | (37.7584818006638, -122.420362745806) | ||
| 79582 | 79582 | 42708 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1600 Union St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42723 | 6005315.92998199 | 2118904.40480493 | 37.7984077601464 | -122.42568904485 | (37.7984077601464, -122.42568904485) | |||
| 79595 | 79595 | 31697 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 251 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52273 | 5998844.67635941 | 2107610.34536784 | 37.767029417655294 | -122.447268187302 | (37.7670294176553, -122.447268187302) | ||
| 79606 | 79606 | 48971 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3560 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51299 | 6006551.36018636 | 2104389.75581183 | 37.7586237821624 | -122.420383293607 | (37.7586237821624, -122.420383293607) | ||
| 79621 | 79621 | 43653 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1038 Clayton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43296 | 5998866.89911478 | 2106402.77921975 | 37.7637150147123 | -122.44710440936501 | (37.7637150147123, -122.447104409365) | ||
| 79702 | 79702 | 67195 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 364 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30645 | 6007254.96525843 | 2096501.59955249 | 37.7370043084172 | -122.41739088683 | (37.7370043084172, -122.41739088683) | ||
| 79755 | 79755 | 66153 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 242 Williams Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | Permit Number 29224 | 6012823.28895075 | 2093870.94233966 | 37.730092792538706 | -122.39795408284401 | (37.7300927925387, -122.397954082844) | ||
| 79763 | 79763 | 49051 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 55 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46222 | 5993672.55552624 | 2093155.09549516 | 37.727042075487496 | -122.46410812816002 | (37.7270420754875, -122.46410812816) | ||
| 79822 | 79822 | 39041 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009489.42605904 | 2105918.18139903 | 37.762985618211395 | -122.41033000413601 | (37.7629856182114, -122.410330004136) | ||
| 79920 | 79920 | 68078 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 533 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31816 | 5993378.12281416 | 2101850.02786606 | 37.750899207284604 | -122.465757431223 | (37.7508992072846, -122.465757431223) | ||
| 79971 | 79971 | 32214 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 22 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | Permit Number 35535 | 6009204.03379581 | 2099499.67440684 | 37.7453458370511 | -122.410863739161 | (37.7453458370511, -122.410863739161) | ||
| 79983 | 79983 | 121657 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 393 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994102.0 | 2101414.0 | 37.74974371447 | -122.463222579259 | (37.74974371447, -122.463222579259) | ||||
| 80000 | 80000 | 35936 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 Bache St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/1998 12:00:00 AM | Permit Number 39099 | 6007238.86373216 | 2095730.63225463 | 37.7348864958229 | -122.41739193639299 | (37.7348864958229, -122.417391936393) | |||
| 80061 | 80061 | 62015 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1335 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1986 12:00:00 AM | Permit Number 22951 | 5996759.80767811 | 2106875.81619467 | 37.764893238314 | -122.454426318727 | (37.764893238314, -122.454426318727) | ||
| 80069 | 80069 | 41117 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1799x PAGE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | 4x4 | Permit Number 41862 | 5998015.0 | 2108858.0 | 37.770407716093004 | -122.45022783831399 | (37.770407716093, -122.450227838314) | ||
| 80093 | 80093 | 102989 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 161 Edgewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 3x3 | 5996558.2 | 2106100.3 | 37.762752304882895 | -122.45506758085199 | (37.7627523048829, -122.455067580852) | |||
| 80204 | 80204 | 63681 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1360 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1987 12:00:00 AM | Permit Number 24336 | 6003877.5677897 | 2100349.08682524 | 37.7473780197128 | -122.429342342987 | (37.7473780197128, -122.429342342987) | ||
| 80244 | 80244 | 66649 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 953 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1991 12:00:00 AM | Permit Number 29860 | 6009977.90870649 | 2103659.93293665 | 37.7568123482779 | -122.408481200185 | (37.7568123482779, -122.408481200185) | ||
| 80261 | 80261 | 41467 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4201 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43106 | 6001496.29110136 | 2103344.13246923 | 37.7554665958578 | -122.437791093286 | (37.7554665958578, -122.437791093286) | ||
| 80264 | 80264 | 116708 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2699 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009829.68874677 | 2105460.44811296 | 37.7617478547189 | -122.40912084667299 | (37.7617478547189, -122.409120846673) | ||||
| 80284 | 80284 | 84106 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3909 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50417 | 6003719.39167552 | 2102426.4465388 | 37.753073006911706 | -122.430037470862 | (37.7530730069117, -122.430037470862) | ||
| 80304 | 80304 | 43922 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2713 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43514 | 6009896.870643401 | 2103354.29233864 | 37.7559685890585 | -122.408739899203 | (37.7559685890585, -122.408739899203) | ||
| 80317 | 80317 | 47339 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399 Vernon St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 80392 | 80392 | 98149 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 850 Rockdale Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | |||
| 80450 | 80450 | 50198 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 619 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2003 12:00:00 AM | Permit Number 46904 | 6000550.61015539 | 2111065.53774883 | 37.7766138373401 | -122.441615625625 | (37.7766138373401, -122.441615625625) | ||
| 80459 | 80459 | 34179 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 514 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46223 | 5995415.14715319 | 2092747.45765731 | 37.7260230798326 | -122.458054566673 | (37.7260230798326, -122.458054566673) | ||
| 80514 | 80514 | 34387 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 194 Lippard Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38135 | 6001745.9731421 | 2094969.88286984 | 37.7324870706739 | -122.43632831918801 | (37.7324870706739, -122.436328319188) | ||
| 80751 | 80751 | 32339 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 68 Prosper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36901 | 6003319.50041227 | 2106131.1149739 | 37.7632224860477 | -122.43168485043999 | (37.7632224860477, -122.43168485044) | |||
| 80773 | 80773 | 50600 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1700 Buchanan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Permit Number 47204 | 6004061.24207522 | 2114267.02341516 | 37.7856037113433 | -122.42969972213801 | (37.7856037113433, -122.429699722138) | |||
| 80807 | 80807 | 83950 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1401 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50893 | 5994555.17150406 | 2105978.53841362 | 37.7623028635091 | -122.461986466343 | (37.7623028635091, -122.461986466343) | ||
| 80816 | 80816 | 40492 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 15 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41568 | 5993166.50981737 | 2094885.79509382 | 37.7317649711718 | -122.465983210891 | (37.7317649711718, -122.465983210891) | ||
| 80846 | 80846 | 39083 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3700 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1998 12:00:00 AM | Permit Number 40780 | 6005630.70572311 | 2104338.6748817 | 37.758431602547496 | -122.42356370666201 | (37.7584316025475, -122.423563706662) | |||
| 80874 | 80874 | 61471 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 353 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1984 12:00:00 AM | Permit Number 21414 | 6004212.58352082 | 2106861.11747112 | 37.7652774800544 | -122.428648012847 | (37.7652774800544, -122.428648012847) | ||
| 80935 | 80935 | 52928 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 16SAN JOSE Havelock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48912 | 6000085.98999689 | 2092943.15717176 | 37.7268276925501 | -122.44192184351002 | (37.7268276925501, -122.44192184351) | ||
| 80937 | 80937 | 52102 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 626 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48294 | 5997817.67079409 | 2098058.32410379 | 37.7407432018068 | -122.45013185931299 | (37.7407432018068, -122.450131859313) | ||
| 80938 | 80938 | 32888 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1427 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44963 | 5994250.98670041 | 2105798.55598521 | 37.761791161249704 | -122.463025460455 | (37.7617911612497, -122.463025460455) | ||
| 80958 | 80958 | 40497 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 41 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41570 | 5993155.80977638 | 2094728.71790558 | 37.7313330588046 | -122.46600879303001 | (37.7313330588046, -122.46600879303) | ||
| 80982 | 80982 | 45310 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44148 | 5991970.57716924 | 2089762.40966389 | 37.71762835398 | -122.46974489666401 | (37.71762835398, -122.469744896664) | ||
| 81032 | 81032 | 39130 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 768 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40810 | 6007311.54524885 | 2102837.76548696 | 37.7544051814215 | -122.41764422175501 | (37.7544051814215, -122.417644221755) | ||
| 81074 | 81074 | 48714 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 51 Karen Ct | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45979 | 6010303.31031399 | 2091494.58114447 | 37.7234271327762 | -122.406498623752 | (37.7234271327762, -122.406498623752) | |||
| 81180 | 81180 | 96346 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 673 Brussels St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2012 12:00:00 AM | 3x3 | Permit Number 767711 | 6010983.0 | 2091637.0 | 37.7238561870461 | -122.404159067143 | (37.7238561870461, -122.404159067143) | ||
| 81182 | 81182 | 31279 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991074.90901 | 2097846.97401 | 37.739774730819605 | -122.473430136096 | (37.7397747308196, -122.473430136096) | ||
| 81244 | 81244 | 63085 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 310 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1986 12:00:00 AM | Permit Number 23569 | 6007712.47546838 | 2097668.62839198 | 37.7402344433566 | -122.41589168052099 | (37.7402344433566, -122.415891680521) | ||
| 81316 | 81316 | 94369 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 899@ Fulton 27th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | Permit Number 53639 | 5987555.1 | 2109884.3 | 37.77262150846121 | -122.48648355682501 | (37.7726215084612, -122.486483556825) | |||
| 81375 | 81375 | 68796 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 124 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32735 | 5992415.21095956 | 2098300.4972824 | 37.7410975141236 | -122.46882897436001 | (37.7410975141236, -122.46882897436) | ||
| 81384 | 81384 | 67920 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 20 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31631 | 6004270.31077563 | 2095608.24088843 | 37.734382966985706 | -122.427646546481 | (37.7343829669857, -122.427646546481) | ||
| 81400 | 81400 | 31064 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1446 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34813 | 5991504.54040303 | 2105570.76324803 | 37.7610071175252 | -122.47250762303001 | (37.7610071175252, -122.47250762303) | |||
| 81421 | 81421 | 32115 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 282 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35482 | 6003528.63178105 | 2106643.87985786 | 37.7646422667629 | -122.43099813337 | (37.7646422667629, -122.43099813337) | ||
| 81527 | 81527 | 39026 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009266.307 | 2105730.9390000002 | 37.762458983569495 | -122.411088472825 | (37.7624589835695, -122.411088472825) | ||
| 81592 | 81592 | 57328 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 351 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2008 12:00:00 AM | 3x3 | Permit Number 50341 | 6001814.41957658 | 2103805.34952356 | 37.756751071173206 | -122.43672392277 | (37.7567510711732, -122.43672392277) | ||
| 81604 | 81604 | 52515 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 81621 | 81621 | 49519 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1449 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2003 12:00:00 AM | Permit Number 46424 | 5995879.04529702 | 2093702.97722349 | 37.7286733508005 | -122.456519976637 | (37.7286733508005, -122.456519976637) | ||
| 81706 | 81706 | 66885 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 374 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1991 12:00:00 AM | Permit Number 30198 | 6001120.12194129 | 2104170.93392282 | 37.7577153950238 | -122.43915125455901 | (37.7577153950238, -122.439151254559) | ||
| 81753 | 81753 | 38931 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 35 Lunado Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40736 | 5991490.27673853 | 2091507.27326378 | 37.7223915474749 | -122.47153213710399 | (37.7223915474749, -122.471532137104) | ||
| 81775 | 81775 | 46830 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 544 Excelsior Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44905 | 6003706.54447011 | 2091877.16367868 | 37.724106359808104 | -122.429329698126 | (37.7241063598081, -122.429329698126) | ||
| 81872 | 81872 | 88960 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2949 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2008 12:00:00 AM | 3x3 | Permit Number 51726 | 6009125.0 | 2105426.0 | 37.7616137654244 | -122.41155565798599 | (37.7616137654244, -122.411555657986) | ||
| 82119 | 82119 | 47601 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 472 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45437 | 6008191.88820074 | 2096647.62651881 | 37.7374579370498 | -122.414161842346 | (37.7374579370498, -122.414161842346) | ||
| 82147 | 82147 | 40510 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 445 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | Permit Number 41576 | 5992747.41981015 | 2094935.12337926 | 37.7318762282888 | -122.46743566386299 | (37.7318762282888, -122.467435663863) | |||
| 82213 | 82213 | 67509 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 272 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1992 12:00:00 AM | Permit Number 31039 | 5998950.01298148 | 2094109.39286394 | 37.729965105401796 | -122.445932714817 | (37.7299651054018, -122.445932714817) | ||
| 82220 | 82220 | 33034 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 480 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37314 | 6006775.3193002995 | 2100986.69081725 | 37.7492923645832 | -122.419367324006 | (37.7492923645832, -122.419367324006) | ||
| 82235 | 82235 | 37564 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4682 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40000 | 6000321.56685981 | 2104664.44427037 | 37.759024981532896 | -122.441948400061 | (37.7590249815329, -122.441948400061) | ||
| 82257 | 82257 | 47099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 165 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45080 | 5996567.29517241 | 2111802.74545159 | 37.778410264148896 | -122.455448285784 | (37.7784102641489, -122.455448285784) | ||
| 82274 | 82274 | 42701 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1401 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42720 | 6008024.82454824 | 2099957.661983 | 37.746537177160604 | -122.41497367347401 | (37.7465371771606, -122.414973673474) | ||
| 82303 | 82303 | 116707 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2699 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009829.68874677 | 2105460.44811296 | 37.7617478547189 | -122.40912084667299 | (37.7617478547189, -122.409120846673) | ||||
| 82395 | 82395 | 42818 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 37 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42763 | 6002665.99933847 | 2105683.87636323 | 37.761957413035 | -122.433913121331 | (37.761957413035, -122.433913121331) | ||
| 82417 | 82417 | 37912 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1326 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40173 | 6003866.48361658 | 2100549.13770204 | 37.747926685373 | -122.42939493500099 | (37.747926685373, -122.429394935001) | ||
| 82511 | 82511 | 87478 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2614 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2008 12:00:00 AM | 3x3 | Permit Number 50387 | 6010032.3 | 2105101.4 | 37.7607733382761 | -122.408394765808 | (37.7607733382761, -122.408394765808) | ||
| 82545 | 82545 | 60981 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 326 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20791 | 5994773.12537038 | 2090759.58388194 | 37.720527946354295 | -122.460130027699 | (37.7205279463543, -122.460130027699) | ||
| 82584 | 82584 | 35849 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Russia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | Permit Number 39073 | 6001624.34206398 | 2090846.82261337 | 37.7211591730388 | -122.43645383368401 | (37.7211591730388, -122.436453833684) | ||
| 82609 | 82609 | 32910 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 406 Hugo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37247 | 5994517.31006353 | 2107044.98976253 | 37.7652288816907 | -122.462194760373 | (37.7652288816907, -122.462194760373) | ||
| 82680 | 82680 | 41669 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 500 Corbett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.44465870166599 | (37.7577735947767, -122.444658701666) | ||
| 82714 | 82714 | 32882 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1260 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37226 | 5994263.61077996 | 2106944.00816407 | 37.764937001780204 | -122.463064911552 | (37.7649370017802, -122.463064911552) | ||
| 82783 | 82783 | 36744 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 54 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2004 12:00:00 AM | Permit Number 39515 | 6006467.72203476 | 2108170.42397717 | 37.7689998951656 | -122.420940975809 | (37.7689998951656, -122.420940975809) |
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");