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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 115333 | 115333 | 30525 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 96 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/2005 12:00:00 AM | 10 | 3x3 | 6008672.39963745 | 2112539.12321188 | 37.7811193385199 | -122.41362414398701 | (37.7811193385199, -122.413624143987) | |
| 135080 | 135080 | 69741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 5 | 6010157.175969999 | 2089735.57492 | 37.7185890892048 | -122.40687987112601 | (37.7185890892048, -122.406879871126) | ||
| 47463 | 47463 | 70412 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1817 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 4 | 6005464.04095 | 2092680.05814 | 37.7264102753879 | -122.423311341054 | (37.7264102753879, -122.423311341054) | ||
| 184861 | 184861 | 70592 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 312 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 4 | 6004234.1327 | 2091472.6068400003 | 37.7230253908821 | -122.42747709790001 | (37.7230253908821, -122.4274770979) | ||
| 59413 | 59413 | 70593 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6004216.40489 | 2091443.51048 | 37.722944495983 | -122.427536307463 | (37.722944495983, -122.427536307463) | ||
| 88949 | 88949 | 70620 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1644 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1994 12:00:00 AM | 12 | 3x3 | 6006824.13924708 | 2117065.21920464 | 37.793442925898105 | -122.42033955937599 | (37.7934429258981, -122.420339559376) | ||
| 157725 | 157725 | 70621 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 713 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 6 | 6004140.669919999 | 2091658.5029099998 | 37.7235305337986 | -122.427813419165 | (37.7235305337986, -122.427813419165) | ||
| 39309 | 39309 | 70680 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 330 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 10 | 6010584.43859 | 2106698.38492 | 37.7651892021367 | -122.406597696229 | (37.7651892021367, -122.406597696229) | ||
| 186437 | 186437 | 71320 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 11 | 6004289.26563 | 2090538.0021799998 | 37.720462289783896 | -122.42721997362601 | (37.7204622897839, -122.427219973626) | ||
| 172651 | 172651 | 71391 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1531 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 4 | 6015562.7322 | 2096452.7948 | 37.737334227876396 | -122.388663558077 | (37.7373342278764, -122.388663558077) | ||
| 48741 | 48741 | 71411 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1556 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 5 | 6015495.2506 | 2094478.7004 | 37.7319100238031 | -122.388759104128 | (37.7319100238031, -122.388759104128) | ||
| 179770 | 179770 | 71586 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 121 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 9 | 5994945.16185 | 2086428.98532 | 37.7086470380903 | -122.459221923276 | (37.7086470380903, -122.459221923276) | ||
| 136079 | 136079 | 72127 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2110 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 10 | 6012120.035209999 | 2102839.43148 | 37.7546791626274 | -122.401015240957 | (37.7546791626274, -122.401015240957) | ||
| 158757 | 158757 | 72128 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2012 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 11 | 6012399.20292 | 2102851.6444 | 37.7547282656006 | -122.400050655116 | (37.7547282656006, -122.400050655116) | ||
| 47148 | 47148 | 72144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1985 12:00:00 AM | 5 | 6000049.527000001 | 2091859.62504 | 37.723850484693706 | -122.441970156497 | (37.7238504846937, -122.441970156497) | ||
| 180005 | 180005 | 72279 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 6 | 5983194.45467 | 2110583.80622 | 37.7742869998631 | -122.501619002427 | (37.7742869998631, -122.501619002427) | ||
| 65322 | 65322 | 73401 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1733 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 6 | 6006559.8799 | 2116866.9427 | 37.7928836135597 | -122.421239831973 | (37.7928836135597, -122.421239831973) | ||
| 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) | ||
| 92485 | 92485 | 73448 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1644 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1994 12:00:00 AM | 12 | 3x3 | 6006824.13924708 | 2117065.21920464 | 37.793442925898105 | -122.42033955937599 | (37.7934429258981, -122.420339559376) | ||
| 70530 | 70530 | 73459 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 330 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 15 | 6010582.5171300005 | 2106716.25151 | 37.765238152235206 | -122.40660560128299 | (37.7652381522352, -122.406605601283) | ||
| 169270 | 169270 | 73714 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2110 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 9 | 6012133.53509 | 2102840.64813 | 37.75468325634171 | -122.400968639917 | (37.7546832563417, -122.400968639917) | ||
| 77012 | 77012 | 73715 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2012 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 9 | 6012416.66148 | 2102853.00124 | 37.7547329645749 | -122.399990373555 | (37.7547329645749, -122.399990373555) | ||
| 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) | ||
| 65822 | 65822 | 74096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1994 12:00:00 AM | 10 | 6001902.78384 | 2087667.7277099998 | 37.712445903022704 | -122.435264062185 | (37.7124459030227, -122.435264062185) | ||
| 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) | ||
| 186653 | 186653 | 75060 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 390x Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 7 | 6010594.46043 | 2106517.2504 | 37.76469240853879 | -122.406550267789 | (37.7646924085388, -122.406550267789) | ||
| 60538 | 60538 | 75145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010592.19708 | 2106537.02068 | 37.76474656661821 | -122.406559489431 | (37.7647465666182, -122.406559489431) | ||
| 25838 | 25838 | 75303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.40656607695699 | (37.7648621726769, -122.406566076957) | ||
| 39170 | 39170 | 75389 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010589.86723 | 2106590.9300700002 | 37.7648944592258 | -122.40657134700199 | (37.7648944592258, -122.406571347002) | ||
| 53492 | 53492 | 75980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6555 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1989 12:00:00 AM | 3 | 5986643.29892 | 2112486.62546 | 37.7797135654944 | -122.48982895296699 | (37.7797135654944, -122.489828952967) | ||
| 181073 | 181073 | 78383 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1490 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 5 | 6015869.5519 | 2094203.8416 | 37.7311760546893 | -122.387445886397 | (37.7311760546893, -122.387445886397) | ||
| 1366 | 1366 | 81793 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.42359327476801 | (37.7767477786156, -122.423593274768) | |
| 64108 | 64108 | 83143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2006 12:00:00 AM | 1 | 6016637.512159999 | 2095504.68596 | 37.7347904181313 | -122.384881478104 | (37.7347904181313, -122.384881478104) | ||
| 8721 | 8721 | 94275 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 850 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6001000.8133 | 2111684.213 | 37.778338202659995 | -122.440102619662 | (37.77833820266, -122.440102619662) | ||||
| 8801 | 8801 | 94278 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 850@Golden Gate Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6001005.8896 | 2111653.4167 | 37.7782539328231 | -122.440082850024 | (37.7782539328231, -122.440082850024) | ||||
| 103743 | 103743 | 96097 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1999 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009553.0 | 2105475.0 | 37.7617723065941 | -122.41007883348301 | (37.7617723065941, -122.410078833483) | ||
| 108509 | 108509 | 96100 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2780X 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | ||
| 79651 | 79651 | 96102 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2780X 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | ||
| 142916 | 142916 | 96107 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2780X 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | ||
| 113290 | 113290 | 98121 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 900 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 774687 | 6009897.0 | 2103882.5 | 37.7574189360449 | -122.40877671518999 | (37.7574189360449, -122.40877671519) | ||
| 28416 | 28416 | 99761 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 4212 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 4212-4216 25th St (4214 is visible address) | 6002485.0 | 2101232.0 | 37.749723353108294 | -122.434220849449 | (37.7497233531083, -122.434220849449) | |||
| 40781 | 40781 | 101046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 774347 | 6012049.4869099995 | 2119300.00717 | 37.799872179210894 | -122.40241656909201 | (37.7998721792109, -122.402416569092) | ||
| 114129 | 114129 | 101280 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2201 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988947.0 | 2106461.0 | 37.7633031017087 | -122.48141813594201 | (37.7633031017087, -122.481418135942) | ||||
| 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) | |||
| 99067 | 99067 | 102143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 442 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003585.0 | 2105673.0 | 37.761979658220206 | -122.43073388246799 | (37.7619796582202, -122.430733882468) | |||
| 114315 | 114315 | 102144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0X Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003601.0 | 2105679.0 | 37.7619970392507 | -122.430678972901 | (37.7619970392507, -122.430678972901) | |||
| 87818 | 87818 | 102145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0X Ford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003601.0 | 2105679.0 | 37.7619970392507 | -122.430678972901 | (37.7619970392507, -122.430678972901) | |||
| 103400 | 103400 | 102146 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0X Ford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003601.0 | 2105679.0 | 37.7619970392507 | -122.430678972901 | (37.7619970392507, -122.430678972901) | |||
| 78871 | 78871 | 102179 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 4354 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002056.0 | 2104132.0 | 37.7576617009806 | -122.435911822312 | (37.7576617009806, -122.435911822312) | |||
| 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) | ||||
| 5178 | 5178 | 104043 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1405 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006090.81059 | 2119657.4034599997 | 37.800519058872396 | -122.42306126657199 | (37.8005190588724, -122.423061266572) | |||
| 5575 | 5575 | 105537 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2192 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6002561.80287 | 2118173.8704 | 37.796245890587 | -122.435166876954 | (37.796245890587, -122.435166876954) | |||
| 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) | ||||
| 164092 | 164092 | 106806 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 167 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 5996526.1156 | 2113255.0824 | 37.7823956347772 | -122.455695748043 | (37.7823956347772, -122.455695748043) | ||||
| 131718 | 131718 | 106807 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 167 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 5996526.1156 | 2113238.8382 | 37.78235103251139 | -122.45569457348499 | (37.7823510325114, -122.455694573485) | ||||
| 10316 | 10316 | 110495 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 230 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003598.79471 | 2092490.0157299999 | 37.7257830144685 | -122.429745863482 | (37.7257830144685, -122.429745863482) | |||
| 11111 | 11111 | 110496 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003585.89382 | 2092469.97138 | 37.7257272466074 | -122.429789031845 | (37.7257272466074, -122.429789031845) | |||
| 47113 | 47113 | 111740 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 498x 11th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5992531.49665 | 2112146.31797 | 37.779121219504106 | -122.46943451634199 | (37.7791212195041, -122.469434516342) | |||
| 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) | ||||
| 139854 | 139854 | 111907 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 107640 | 107640 | 111908 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 145239 | 145239 | 111909 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 111716 | 111716 | 111910 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 141691 | 141691 | 112080 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901x SANTIAGO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5986971.0 | 2099566.0 | 37.744256215511896 | -122.487745790198 | (37.7442562155119, -122.487745790198) | |||
| 144808 | 144808 | 112082 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901x SANTIAGO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5986971.0 | 2099566.0 | 37.744256215511896 | -122.487745790198 | (37.7442562155119, -122.487745790198) | |||
| 114782 | 114782 | 112164 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 701 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011822.0 | 2114512.0 | 37.7867127527861 | -122.4028668317 | (37.7867127527861, -122.4028668317) | ||||
| 100658 | 100658 | 112504 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 601 WILLOW ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/14/2016 10:27:00 AM | 3 | 2x2 | 6004423.0 | 2113018.0 | 37.7821946822097 | -122.42835909048999 | (37.7821946822097, -122.42835909049) | ||
| 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) | |||||
| 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) | |||
| 114300 | 114300 | 112865 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 20863 | 20863 | 112866 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 109062 | 109062 | 112867 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 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) | ||||
| 109983 | 109983 | 112869 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 147868 | 147868 | 113164 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3902 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5996104.12061 | 2115248.7957599997 | 37.7878456121944 | -122.457299932451 | (37.7878456121944, -122.457299932451) | |||
| 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) | |||
| 163550 | 163550 | 113166 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3902 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5996084.69058 | 2115243.98919 | 37.7878312986742 | -122.457366808459 | (37.7878312986742, -122.457366808459) | |||
| 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) | ||||
| 19725 | 19725 | 114507 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 10 LOMBARD ST | 2 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 101671 | 101671 | 114903 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3261 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007278.07200017 | 2102623.89370267 | 37.7538160547365 | -122.41774482262699 | (37.7538160547365, -122.417744822627) | |||
| 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) | |||
| 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) | ||||
| 117317 | 117317 | 115488 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1393 YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6010176.0 | 2101093.0 | 37.7497752121793 | -122.407615143394 | (37.7497752121793, -122.407615143394) | |||
| 58943 | 58943 | 116918 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 109779 | 109779 | 116919 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 108702 | 108702 | 116920 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 121953 | 121953 | 116921 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 110363 | 110363 | 116922 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 900x 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 57643 | 57643 | 117045 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2205x Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6002006.1518 | 2114301.3544 | 37.7855813923399 | -122.436812184863 | (37.7855813923399, -122.436812184863) | |||
| 46947 | 46947 | 117046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2205x Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6002022.6426 | 2114300.8047 | 37.785580820217206 | -122.436755092227 | (37.7855808202172, -122.436755092227) | |||
| 48328 | 48328 | 117078 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1506 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 5x5 | 6003016.0 | 2114040.0 | 37.7849211205465 | -122.433299725252 | (37.7849211205465, -122.433299725252) | |||
| 98800 | 98800 | 117418 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 171 COLERIDGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6006547.0 | 2098715.0 | 37.743041953466296 | -122.41999567036801 | (37.7430419534663, -122.419995670368) | |||
| 45516 | 45516 | 117917 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5983194.46177 | 2110567.54263 | 37.7742423451733 | -122.501617774429 | (37.7742423451733, -122.501617774429) | |||
| 169324 | 169324 | 118185 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5985597.25903 | 2112945.4232900003 | 37.7809121598048 | -122.493481422073 | (37.7809121598048, -122.493481422073) | |||
| 77757 | 77757 | 118287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 240 IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2.5 | 6006177.0 | 2111293.0 | 37.777557347021606 | -122.42216843833201 | (37.7775573470216, -122.422168438332) | ||||
| 116732 | 116732 | 118288 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 240 IVY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2.5 | 6006177.0 | 2111293.0 | 37.777557347021606 | -122.42216843833201 | (37.7775573470216, -122.422168438332) | ||||
| 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) | |||
| 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) | |||
| 49709 | 49709 | 120248 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 164 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5988365.09621 | 2114861.46484 | 37.786334585774604 | -122.484046777757 | (37.7863345857746, -122.484046777757) | |||
| 77045 | 77045 | 120249 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 164 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5988365.91336 | 2114852.64965 | 37.786310429345704 | -122.48404330399599 | (37.7863104293457, -122.484043303996) |
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");