Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 8596 | 8596 | 115210 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 115 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5997031.37665 | 2115893.5791 | 37.789669227607604 | -122.45413840466298 | (37.7896692276076, -122.454138404663) | |||
| 14147 | 14147 | 11467 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 8 | 3X3 | 6016799.4589 | 2095596.1573400002 | 37.7350505362442 | -122.384327935502 | (37.7350505362442, -122.384327935502) | ||
| 15797 | 15797 | 101777 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1700 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014038.07825 | 2093123.5904299999 | 37.72810829704029 | -122.39370208181101 | (37.7281082970403, -122.393702081811) | |||
| 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) | |
| 23398 | 23398 | 138455 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002947.3238 | 2114874.0081 | 37.787207199109204 | -122.433596947338 | (37.7872071991092, -122.433596947338) | |||
| 23930 | 23930 | 246508 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004932.15845 | 2099866.5422 | 37.7461127118493 | -122.425661300149 | (37.7461127118493, -122.425661300149) | |||
| 24904 | 24904 | 136239 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006621.33402 | 2116991.57937 | 37.7932292991375 | -122.4210360509 | (37.7932292991375, -122.4210360509) | |||
| 25009 | 25009 | 197076 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014915.77906 | 2102946.7050400004 | 37.7551292724085 | -122.39135422264098 | (37.7551292724085, -122.391354222641) | |||
| 26493 | 26493 | 239366 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3544 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004780.37134 | 2103118.67558 | 37.7550337374315 | -122.426417677652 | (37.7550337374315, -122.426417677652) | |||
| 28183 | 28183 | 246963 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 238 Noe St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6002871.51875 | 2106887.2406200003 | 37.765273220394796 | -122.433288301134 | (37.7652732203948, -122.433288301134) | |||
| 28339 | 28339 | 73442 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 8 | 6004223.020830001 | 2091452.87155 | 37.72297057362721 | -122.42751410409402 | (37.7229705736272, -122.427514104094) | ||
| 28532 | 28532 | 120778 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989252.84217 | 2114809.1452099998 | 37.7862425746859 | -122.480971607416 | (37.7862425746859, -122.480971607416) | |||
| 28556 | 28556 | 136259 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2110 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007679.1852400005 | 2119665.2919900003 | 37.800630222272794 | -122.417565392635 | (37.8006302222728, -122.417565392635) | |||
| 28760 | 28760 | 136243 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006695.60451 | 2117001.64443 | 37.7932611216587 | -122.42077978456999 | (37.7932611216587, -122.42077978457) | |||
| 30243 | 30243 | 138452 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002940.8815 | 2114925.0507 | 37.7873469835854 | -122.433622885577 | (37.7873469835854, -122.433622885577) | |||
| 30247 | 30247 | 179306 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 272 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003680.49546 | 2092115.04602 | 37.7247580571263 | -122.429436701757 | (37.7247580571263, -122.429436701757) | |||
| 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) | ||
| 32871 | 32871 | 74007 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2030 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 8 | 6012344.40813 | 2102849.33443 | 37.754718867688105 | -122.40023998938999 | (37.7547188676881, -122.40023998939) | ||
| 35019 | 35019 | 239374 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3517 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004914.04474 | 2103668.95392 | 37.7565522283139 | -122.425994566404 | (37.7565522283139, -122.425994566404) | |||
| 36489 | 36489 | 213993 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 95 Martha Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000354.21561 | 2095866.7572 | 37.7348705009689 | -122.441204268679 | (37.7348705009689, -122.441204268679) | |||
| 36878 | 36878 | 81916 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52300 | 6013111.49661 | 2094334.1897900002 | 37.731380822071706 | -122.396990173153 | (37.7313808220717, -122.396990173153) | |
| 37326 | 37326 | 138443 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003387.7672 | 2114195.0447 | 37.785367917648 | -122.432024606628 | (37.785367917648, -122.432024606628) | |||
| 39213 | 39213 | 239316 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1100 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6010239.40016 | 2102763.26328 | 37.7543649341213 | -122.407513645861 | (37.7543649341213, -122.407513645861) | |||
| 41034 | 41034 | 239281 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 356 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006523.17494 | 2104019.48467 | 37.7576055152006 | -122.420454489001 | (37.7576055152006, -122.420454489001) | |||
| 43844 | 43844 | 245441 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2911 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6007346.0609 | 2106731.0495 | 37.7650971816433 | -122.417800808591 | (37.7650971816433, -122.417800808591) | |||
| 44594 | 44594 | 213965 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994879.14088 | 2091213.45138 | 37.721780255249904 | -122.459796427288 | (37.7217802552499, -122.459796427288) | |||
| 45337 | 45337 | 213911 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1767 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5990895.24857 | 2103389.01356 | 37.754981325851205 | -122.474455655417 | (37.7549813258512, -122.474455655417) | |||
| 45995 | 45995 | 61372 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3240 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32977 | 5999005.452409999 | 2119937.7850900004 | 37.800886538035996 | -122.447599568972 | (37.800886538036, -122.447599568972) | |
| 50427 | 50427 | 179309 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 213 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6003911.34447 | 2092391.41197 | 37.725529964113605 | -122.42865837630801 | (37.7255299641136, -122.428658376308) | |||
| 50738 | 50738 | 120183 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 160 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5987744.35264 | 2114901.48572 | 37.7864083129421 | -122.486197303246 | (37.7864083129421, -122.486197303246) | |||
| 58224 | 58224 | 138058 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1908 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002987.8129 | 2114950.6613 | 37.7874199665492 | -122.43346234376999 | (37.7874199665492, -122.43346234377) | |||
| 60896 | 60896 | 50021 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 137@ FELTON Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 8 | Permit Number 46755 | 6010268.64963 | 2093971.7239700002 | 37.730226909139105 | -122.406792936365 | (37.7302269091391, -122.406792936365) | |
| 62147 | 62147 | 197069 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2224 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010779.09476 | 2106028.62319 | 37.7633610764639 | -122.405877240345 | (37.7633610764639, -122.405877240345) | |||
| 62785 | 62785 | 137713 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1691 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001127.2632 | 2111397.9341 | 37.77755935126 | -122.439644654702 | (37.77755935126, -122.439644654702) | |||
| 63119 | 63119 | 213926 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996340.85636 | 2106804.33971 | 37.764672946334294 | -122.45587018867501 | (37.7646729463343, -122.455870188675) | |||
| 63430 | 63430 | 239351 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 530 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003095.45527 | 2098933.62242 | 37.7434471743571 | -122.43194577520201 | (37.7434471743571, -122.431945775202) | |||
| 66275 | 66275 | 106724 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 421 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6006940.66037 | 2092543.6305799999 | 37.7261189013498 | -122.418197053944 | (37.7261189013498, -122.418197053944) | ||||
| 67006 | 67006 | 240153 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1008 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998136.29263 | 2106764.45676 | 37.764666319205205 | -122.449657403985 | (37.7646663192052, -122.449657403985) | |||
| 69725 | 69725 | 124089 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 601 Funston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5991892.74244 | 2111106.03462 | 37.7762279504105 | -122.47156838077 | (37.7762279504105, -122.47156838077) | ||||
| 70153 | 70153 | 179314 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009038.30764 | 2093734.4569599999 | 37.7295065063148 | -122.411029655989 | (37.7295065063148, -122.411029655989) | |||
| 71265 | 71265 | 52637 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2@ PACIFIC Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 8 | Permit Number 48719 | 5997984.07214 | 2116339.1765799997 | 37.7909473027338 | -122.450874333286 | (37.7909473027338, -122.450874333286) | ||
| 72767 | 72767 | 123103 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992512.64277 | 2112661.1585 | 37.7805337417535 | -122.46953722702601 | (37.7805337417535, -122.469537227026) | |||
| 73847 | 73847 | 138298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2035 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002877.6376 | 2115358.1531 | 37.7885325838594 | -122.433872664746 | (37.7885325838594, -122.433872664746) | |||
| 73880 | 73880 | 122099 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 451 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990895.26927 | 2112314.80254 | 37.7794891374062 | -122.47510713931001 | (37.7794891374062, -122.47510713931) | |||
| 75125 | 75125 | 240132 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0 Chattanooga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004672.38894 | 2103545.66672 | 37.7562000502026 | -122.42682151911801 | (37.7562000502026, -122.426821519118) | |||
| 76255 | 76255 | 240134 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 71 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004662.60035 | 2101609.9701400003 | 37.7508845263036 | -122.42671753050301 | (37.7508845263036, -122.426717530503) | |||
| 76655 | 76655 | 136268 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010216.49831 | 2116997.79235 | 37.7934483632051 | -122.40859693051901 | (37.7934483632051, -122.408596930519) | |||
| 101480 | 101480 | 41382 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 365 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/15/2000 12:00:00 AM | 8 | Permit Number 42018 | 6006233.92875974 | 2101016.91494212 | 37.749344846135294 | -122.421241612166 | (37.7493448461353, -122.421241612166) | |
| 107775 | 107775 | 112864 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | |||
| 109687 | 109687 | 8099 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 765 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 8 | 3X3 | 6004167.348119999 | 2111468.4499 | 37.7779255322683 | -122.429133010837 | (37.7779255322683, -122.429133010837) | ||
| 115937 | 115937 | 197078 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014978.14287 | 2102950.87924 | 37.75514419486029 | -122.391138840404 | (37.7551441948603, -122.391138840404) | |||
| 119315 | 119315 | 136237 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1360 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008213.13941 | 2116925.26925 | 37.7931368299423 | -122.41552358715201 | (37.7931368299423, -122.415523587152) | |||
| 126891 | 126891 | 120181 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 142 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5987742.587230001 | 2115005.98358 | 37.7866951312776 | -122.486211085191 | (37.7866951312776, -122.486211085191) | |||
| 130064 | 130064 | 52155 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1431 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 8 | Permit Number 48347 | 6016125.1581 | 2093936.3843 | 37.7304558237734 | -122.386543560163 | (37.7304558237734, -122.386543560163) | |
| 132220 | 132220 | 102493 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2001 McAllister St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5999461.6709 | 2111166.2585 | 37.7768282889466 | -122.445389813922 | (37.7768282889466, -122.445389813922) | |||
| 135338 | 135338 | 34252 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38731 | 6006224.9654 | 2121058.41971 | 37.804373461439795 | -122.42269665353999 | (37.8043734614398, -122.42269665354) | |
| 135838 | 135838 | 67477 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1543 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 8 | Permit Number 30999 | 6001755.4775 | 2111486.6649 | 37.777838719439295 | -122.437477810444 | (37.7778387194393, -122.437477810444) | |
| 137208 | 137208 | 46512 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2188 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/2002 12:00:00 AM | 8 | Permit Number 44678 | 6002606.94356 | 2118178.75715 | 37.7962618715428 | -122.435011030753 | (37.7962618715428, -122.435011030753) | |
| 137292 | 137292 | 56158 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 447 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 8 | Permit Number 12266 | 5990893.795580001 | 2112339.9216299998 | 37.779558022090605 | -122.475114071606 | (37.7795580220906, -122.475114071606) | ||
| 138826 | 138826 | 10442 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1500 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5998947.4848 | 2108705.37768 | 37.770041973229795 | -122.446991399363 | (37.7700419732298, -122.446991399363) | |||
| 139387 | 139387 | 3372 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 5951 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5989085.57316 | 2113985.01381 | 37.7839700180526 | -122.48148992901301 | (37.7839700180526, -122.481489929013) | |||
| 148850 | 148850 | 137687 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1543 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001767.7027 | 2111487.4536 | 37.7778415800419 | -122.437435575789 | (37.7778415800419, -122.437435575789) | |||
| 150852 | 150852 | 197141 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 502 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6015667.2078 | 2114177.54158 | 37.786008361852396 | -122.38953984758801 | (37.7860083618524, -122.389539847588) | |||
| 151838 | 151838 | 62004 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 8 | Permit Number 33452 | 6004296.2409 | 2120497.97462 | 37.8027256192439 | -122.42933117801701 | (37.8027256192439, -122.429331178017) | |
| 154275 | 154275 | 120315 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 206 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5988712.81851 | 2113914.04057 | 37.7837534650339 | -122.48277430520001 | (37.7837534650339, -122.4827743052) | |||
| 154667 | 154667 | 240198 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 46 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002599.46299 | 2096074.44073 | 37.735568391971604 | -122.433456510332 | (37.7355683919716, -122.433456510332) | |||
| 155527 | 155527 | 56681 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2245 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6002229.691000001 | 2118425.2879 | 37.79691735301029 | -122.436334053014 | (37.7969173530103, -122.436334053014) | ||||
| 160675 | 160675 | 213914 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 04th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5994821.63869 | 2107263.01718 | 37.7658450462296 | -122.46115797296999 | (37.7658450462296, -122.46115797297) | |||
| 160870 | 160870 | 32575 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1557 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | 8 | Permit Number 37049 | 6003995.39147 | 2099192.64268 | 37.7442093614769 | -122.428852485076 | (37.7442093614769, -122.428852485076) | ||
| 161941 | 161941 | 240159 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998651.54584 | 2105549.8388799997 | 37.7613607477167 | -122.447787838447 | (37.7613607477167, -122.447787838447) | |||
| 162571 | 162571 | 240190 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 45 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004298.57929 | 2097992.8261599997 | 37.7409320961319 | -122.427718657607 | (37.7409320961319, -122.427718657607) | |||
| 164016 | 164016 | 42171 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 8 | Permit Number 42460 | 6012613.23479 | 2111182.9254900003 | 37.7776160332845 | -122.399895470812 | (37.7776160332845, -122.399895470812) | ||
| 164550 | 164550 | 239369 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3545 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004721.429330001 | 2103657.39787 | 37.7565096103365 | -122.426659876777 | (37.7565096103365, -122.426659876777) | |||
| 165010 | 165010 | 138445 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003321.1733 | 2114185.7412 | 37.7853385969606 | -122.432254336651 | (37.7853385969606, -122.432254336651) | |||
| 166963 | 166963 | 69319 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1490 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1994 12:00:00 AM | 8 | Permit Number 33400 | 6004756.29564 | 2120212.83745 | 37.801968740827206 | -122.42771882665899 | (37.8019687408272, -122.427718826659) | ||
| 167341 | 167341 | 138453 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002943.8549 | 2114900.2728 | 37.7872791184788 | -122.433610826756 | (37.7872791184788, -122.433610826756) | |||
| 168725 | 168725 | 74150 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 740 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1995 12:00:00 AM | 8 | 6004499.396000001 | 2111088.6935 | 37.776901605564206 | -122.427957272174 | (37.7769016055642, -122.427957272174) | ||
| 171756 | 171756 | 240130 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3517 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004936.2718 | 2103669.98473 | 37.756556314841 | -122.425917770609 | (37.756556314841, -122.425917770609) | |||
| 173465 | 173465 | 240164 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 953 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998770.20666 | 2106657.712 | 37.764409471033 | -122.447457188295 | (37.764409471033, -122.447457188295) | |||
| 179013 | 179013 | 179324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Merrill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009528.37304 | 2094747.8855599998 | 37.7323166349901 | -122.409406936389 | (37.7323166349901, -122.409406936389) | |||
| 180134 | 180134 | 240152 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1520 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998350.81999 | 2105225.15153 | 37.7604520448521 | -122.448804531031 | (37.7604520448521, -122.448804531031) | |||
| 181921 | 181921 | 240165 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 955 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998776.9827 | 2106633.40006 | 37.7643431037773 | -122.447432001889 | (37.7643431037773, -122.447432001889) | |||
| 185841 | 185841 | 120256 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 140 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5988368.86327 | 2114963.36268 | 37.7866145875471 | -122.48404121988199 | (37.7866145875471, -122.484041219882) | |||
| 185942 | 185942 | 69346 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 658 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1994 12:00:00 AM | 8 | Permit Number 33435 | 6012980.70536 | 2103982.94332 | 37.7578669706033 | -122.39811901029199 | (37.7578669706033, -122.398119010292) | ||
| 187068 | 187068 | 136217 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2901 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001997.91666 | 2118237.1003900003 | 37.7963874672615 | -122.43712256517999 | (37.7963874672615, -122.43712256518) | |||
| 187865 | 187865 | 113165 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3902 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5996094.44333 | 2115248.19615 | 37.787843410013 | -122.457333370439 | (37.787843410013, -122.457333370439) | |||
| 188451 | 188451 | 240178 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 425 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008247.1635300005 | 2096824.3418400001 | 37.737946263300294 | -122.413983226571 | (37.7379462633003, -122.413983226571) |
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");