Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantType, qCaretaker, PlotSize
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4012 | 4012 | 252965 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:04:00 PM | 3 | ||||||||
| 4061 | 4061 | 252970 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 12:21:00 PM | 3 | ||||||||
| 4066 | 4066 | 252966 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 111 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 12:19:00 PM | 3 | 5998135.7809 | 2087327.97675 | 37.7112983819328 | -122.448259470506 | (37.7112983819328, -122.448259470506) | |||
| 4074 | 4074 | 252967 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:55:00 PM | 3 | 5998144.81293 | 2087318.48212 | 37.7112728281964 | -122.448227570418 | (37.7112728281964, -122.448227570418) | |||
| 15012 | 15012 | 85551 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 288 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 3 | 6008109.65239 | 2108844.36385 | 37.7709427912139 | -122.41530934075199 | (37.7709427912139, -122.415309340752) | |||
| 52058 | 52058 | 41522 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1001 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 3 | Permit Number 42063 | 6014186.00908 | 2106172.78785 | 37.763946866973704 | -122.39410383682 | (37.7639468669737, -122.39410383682) | ||
| 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) | ||
| 63407 | 63407 | 49549 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2434@ TARAVAL 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2003 12:00:00 AM | 3 | Permit Number 46439 | 5989858.6972 | 2098774.0563 | 37.7422497550695 | -122.47770298517 | (37.7422497550695, -122.47770298517) | ||
| 66931 | 66931 | 38591 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1615 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 3 | Permit Number 40546 | 6015135.7246 | 2094671.1157 | 37.7324184244611 | -122.390015508372 | (37.7324184244611, -122.390015508372) | |
| 70539 | 70539 | 52633 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1725@ POLK Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | 3 | Permit Number 48716 | 6006431.88211 | 2116964.74466 | 37.79314493643 | -122.42168966107 | (37.79314493643, -122.42168966107) | ||
| 80922 | 80922 | 110524 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 995X Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2015 12:00:00 AM | 3 | Permit Number 775198 | 6003269.726980001 | 2111024.20368 | 37.7766548889563 | -122.43220646236401 | (37.7766548889563, -122.432206462364) | ||
| 88760 | 88760 | 18652 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 80 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 6017340.7956251 | 2096041.6846083999 | 37.7363037832445 | -122.38248731128701 | (37.7363037832445, -122.382487311287) | |||
| 97668 | 97668 | 109438 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 940 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 6003118.8 | 2111045.9 | 37.7767059032045 | -122.43273011286101 | (37.7767059032045, -122.432730112861) | |||
| 98119 | 98119 | 117314 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 910 Clayton St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 5998775.9 | 2106883.7 | 37.7650303025851 | -122.447453764259 | (37.7650303025851, -122.447453764259) | |||
| 121744 | 121744 | 107696 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2401 MORAGA ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | ||||
| 128818 | 128818 | 115389 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 378 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776292 | 6007259.3 | 2096222.3 | 37.73623765723679 | -122.417356112468 | (37.7362376572368, -122.417356112468) | ||
| 135259 | 135259 | 69460 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 446 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 3 | Permit Number 33570 | 5985026.614630001 | 2112867.05169 | 37.7806635770894 | -122.495449750327 | (37.7806635770894, -122.495449750327) | |
| 138868 | 138868 | 108376 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 995X Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2015 12:00:00 AM | 3 | Permit Number 775198 | 6003269.726980001 | 2111024.20368 | 37.7766548889563 | -122.43220646236401 | (37.7766548889563, -122.432206462364) | ||
| 147265 | 147265 | 48809 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 3 | Permit Number 46042 | 6014468.625469999 | 2102279.9042599997 | 37.753273552832205 | -122.392853974356 | (37.7532735528322, -122.392853974356) | ||
| 155477 | 155477 | 65116 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 130 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 3 | Permit Number 27086 | 5989313.29751 | 2114460.89745 | 37.7852898986689 | -122.480736945877 | (37.7852898986689, -122.480736945877) | |
| 157108 | 157108 | 101338 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 600 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 3 | Permit Number 32655 | 6008893.4466 | 2120790.6495 | 37.80378842303661 | -122.413443168222 | (37.8037884230366, -122.413443168222) | ||
| 173914 | 173914 | 52631 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1725@ POLK Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | 3 | Permit Number 48716 | 6006396.26388 | 2116959.2497900003 | 37.7931278403295 | -122.421812512039 | (37.7931278403295, -122.421812512039) | ||
| 176231 | 176231 | 43755 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 264 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 3 | Permit Number 43391 | 5990896.100380001 | 2113625.86147 | 37.783088990728004 | -122.47520000357201 | (37.783088990728, -122.475200003572) | |
| 19877 | 19877 | 22862 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 151 Turquoise Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2X2 | 5999932.75509 | 2099167.18309 | 37.7439086722544 | -122.442898328797 | (37.7439086722544, -122.442898328797) | |||
| 102226 | 102226 | 22817 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 57 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 2X2 | 5999134.8661569 | 2099418.6659097997 | 37.7445536617332 | -122.445675315466 | (37.7445536617332, -122.445675315466) | ||
| 119264 | 119264 | 22859 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 199X Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2008 12:00:00 AM | 3 | 2X2 | 5999684.0678837 | 2099006.0084470003 | 37.7434519439013 | -122.443746652137 | (37.7434519439013, -122.443746652137) | ||
| 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) | ||
| 143152 | 143152 | 109439 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 800x STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3.5x6.5 | 6003118.0 | 2111045.0 | 37.7767033866571 | -122.432732815988 | (37.7767033866571, -122.432732815988) | ||
| 4925 | 4925 | 253721 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 260 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2017 12:00:00 AM | 3 | 3.5x9 | Permit Number 780843 | 5994045.0 | 2113761.0 | 37.7836420503516 | -122.464315992766 | (37.7836420503516, -122.464315992766) | |
| 9603 | 9603 | 19972 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100 STAIRWAY44 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 36 | ||||||||
| 5860 | 5860 | 21732 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1961 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1997 12:00:00 AM | 3 | 3X3 | 6003208.5585 | 2114462.4267 | 37.78609191954679 | -122.432663720821 | (37.7860919195468, -122.432663720821) | ||
| 6898 | 6898 | 2436 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 740 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1999 12:00:00 AM | 3 | 3X3 | 6004500.111269999 | 2111079.2700799997 | 37.7768757716325 | -122.427954126177 | (37.7768757716325, -122.427954126177) | ||
| 7656 | 7656 | 7301 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1996 12:00:00 AM | 3 | 3X3 | 6002935.9259 | 2114953.2976 | 37.787424261211704 | -122.43364205043699 | (37.7874242612117, -122.433642050437) | ||
| 9104 | 9104 | 24127 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 140X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016343.6401634 | 2095980.6654178002 | 37.736081103602096 | -122.38593067194799 | (37.7360811036021, -122.385930671948) | ||
| 9107 | 9107 | 24086 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 141X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016393.5495733 | 2095983.6738742 | 37.7360921261264 | -122.38575832291299 | (37.7360921261264, -122.385758322913) | ||
| 9255 | 9255 | 24072 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 161X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016395.7853594 | 2095946.5828375 | 37.735990405317004 | -122.385748008424 | (37.735990405317, -122.385748008424) | ||
| 13999 | 13999 | 10614 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 37 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2001 12:00:00 AM | 3 | 3X3 | 6016916.49156 | 2095577.9947400002 | 37.7350071358711 | -122.383922043589 | (37.7350071358711, -122.383922043589) | ||
| 14099 | 14099 | 11466 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 3 | 3X3 | 6016784.967569999 | 2095560.66167 | 37.73495227093311 | -122.384375566285 | (37.7349522709331, -122.384375566285) | ||
| 14222 | 14222 | 16526 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 375 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016351.58796 | 2098272.95822 | 37.7423757148758 | -122.386062939968 | (37.7423757148758, -122.386062939968) | ||
| 15981 | 15981 | 16561 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 702X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6015590.528940001 | 2097333.28077 | 37.739753403296206 | -122.388628895503 | (37.7397534032962, -122.388628895503) | ||
| 17939 | 17939 | 26869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 890 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 3 | 3X3 | 6001564.842 | 2095930.60071 | 37.7351146866797 | -122.437023288105 | (37.7351146866797, -122.437023288105) | ||
| 19015 | 19015 | 23089 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1360 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/1992 12:00:00 AM | 3 | 3X3 | 6006386.45124 | 2101639.17827 | 37.751062036612 | -122.420758355385 | (37.751062036612, -122.420758355385) | ||
| 20253 | 20253 | 28342 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 3101 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6007042.9194 | 2100397.9596 | 37.747690909992706 | -122.418400216794 | (37.7476909099927, -122.418400216794) | ||
| 21886 | 21886 | 15583 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3177 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1999 12:00:00 AM | 3 | 3X3 | 6006726.259 | 2099810.7255 | 37.7460606669612 | -122.419453558792 | (37.7460606669612, -122.419453558792) | ||
| 22899 | 22899 | 7340 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2126 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/2017 12:00:00 AM | 3 | 3X3 | 6002883.51227 | 2115702.89267 | 37.7894794841288 | -122.433876990144 | (37.7894794841288, -122.433876990144) | ||
| 28455 | 28455 | 21731 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1963 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1997 12:00:00 AM | 3 | 3X3 | 6003249.511404401 | 2114468.5359796 | 37.7861110165037 | -122.432522471352 | (37.7861110165037, -122.432522471352) | ||
| 77627 | 77627 | 1693 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1996 12:00:00 AM | 3 | 3X3 | 6017694.7378197 | 2093654.8040294999 | 37.7297694248505 | -122.38109767205201 | (37.7297694248505, -122.381097672052) | ||
| 77830 | 77830 | 8119 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 850X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6003699.00422 | 2111459.33104 | 37.777873970946295 | -122.43075252591801 | (37.7778739709463, -122.430752525918) | ||
| 80405 | 80405 | 16518 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 330 Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | ||
| 84224 | 84224 | 1689 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 03:07:00 PM | 3 | 3X3 | 6017662.008057199 | 2093645.2163419998 | 37.729741292224205 | -122.381210157278 | (37.7297412922242, -122.381210157278) | ||
| 90769 | 90769 | 4354 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 15X Burnside Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2008 12:00:00 AM | 3 | 3X3 | 6001141.00413 | 2095696.99513 | 37.7344491599181 | -122.43847191328899 | (37.7344491599181, -122.438471913289) | ||
| 91492 | 91492 | 24700 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 6940 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5985447.12642 | 2112543.37928 | 37.77979947939 | -122.493971158415 | (37.77979947939, -122.493971158415) | ||
| 92100 | 92100 | 24565 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2117 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1996 12:00:00 AM | 3 | 3X3 | 6002846.69927 | 2115626.75122 | 37.7892683300519 | -122.433998913998 | (37.7892683300519, -122.433998913998) | ||
| 94770 | 94770 | 8084 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6004115.11785 | 2111289.80956 | 37.7774320731857 | -122.429300951982 | (37.7774320731857, -122.429300951982) | ||
| 96907 | 96907 | 4339 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2016 07:58:00 AM | 3 | 3X3 | 6001465.6431599995 | 2095917.8806599998 | 37.7350741214051 | -122.437365343013 | (37.7350741214051, -122.437365343013) | ||
| 97607 | 97607 | 4924 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 195X Newhall St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 102083 | 102083 | 7332 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2056 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/03/2012 12:00:00 AM | 3 | 3X3 | 6002935.732295901 | 2115346.1432336997 | 37.788502904358104 | -122.433670807541 | (37.7885029043581, -122.433670807541) | ||
| 105873 | 105873 | 24568 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2261 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2004 12:00:00 AM | 3 | 3X3 | 6002770.36332 | 2116069.69305 | 37.790480202582 | -122.43429470698 | (37.790480202582, -122.43429470698) | ||
| 109336 | 109336 | 24667 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4837 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5991998.453509999 | 2112682.51242 | 37.7805626435458 | -122.471317590906 | (37.7805626435458, -122.471317590906) | ||
| 109881 | 109881 | 7323 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2019 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/15/1989 12:00:00 AM | 3 | 3X3 | 6002894.208190001 | 2115251.15318 | 37.7882397296612 | -122.433807682283 | (37.7882397296612, -122.433807682283) | ||
| 110618 | 110618 | 18636 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2000 12:00:00 AM | 3 | 3X3 | 6017095.3922155 | 2096110.4018038001 | 37.736478907812 | -122.38334056309999 | (37.736478907812, -122.3833405631) | ||
| 111741 | 111741 | 7293 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1900 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003023.6659699995 | 2114860.30144 | 37.7871738953822 | -122.43333184030399 | (37.7871738953822, -122.433331840304) | |||
| 115748 | 115748 | 15637 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3620 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1999 12:00:00 AM | 3 | 3X3 | 6005316.03868 | 2097071.29075 | 37.7384592699819 | -122.42413513415899 | (37.7384592699819, -122.424135134159) | ||
| 120754 | 120754 | 7326 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2033 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6002897.31453 | 2115259.18608 | 37.7882619622277 | -122.433797509249 | (37.7882619622277, -122.433797509249) | ||
| 122622 | 122622 | 1699 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 42 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1999 12:00:00 AM | 3 | 3X3 | 6017775.3254178 | 2093648.0174938 | 37.7297552383916 | -122.380818597255 | (37.7297552383916, -122.380818597255) | ||
| 123953 | 123953 | 1701 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 46 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2015 02:11:00 PM | 3 | 3X3 | 6017792.761566999 | 2093643.6318374001 | 37.7297441585391 | -122.38075801318199 | (37.7297441585391, -122.380758013182) | ||
| 126432 | 126432 | 26478 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 120 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/2009 12:00:00 AM | 3 | 3X3 | 6001175.6711954 | 2098684.4538551 | 37.7426539948984 | -122.438566040387 | (37.7426539948984, -122.438566040387) | ||
| 127550 | 127550 | 8787 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3557 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5996079.74366 | 2112826.13121 | 37.781192222594 | -122.457208949284 | (37.781192222594, -122.457208949284) | ||
| 129195 | 129195 | 16492 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016524.668196499 | 2098330.497802 | 37.7425432844059 | -122.385468484111 | (37.7425432844059, -122.385468484111) | ||
| 141543 | 141543 | 8911 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4455X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5993163.7331300005 | 2112722.6581 | 37.7807402102496 | -122.46728928915701 | (37.7807402102496, -122.467289289157) | |||
| 146269 | 146269 | 24686 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 6599X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5986563.55545 | 2112507.59289 | 37.77976647962429 | -122.49010635929599 | (37.7797664796243, -122.490106359296) | ||
| 82778 | 82778 | 18650 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017333.617127299 | 2096134.4813376998 | 37.736558188021704 | -122.38251858534201 | (37.7365581880217, -122.382518585342) | ||
| 83510 | 83510 | 18634 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017078.2420673 | 2096202.8624203 | 37.736731838359795 | -122.383406293435 | (37.7367318383598, -122.383406293435) | ||
| 95631 | 95631 | 18654 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 85 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | ||
| 98845 | 98845 | 18641 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2000 12:00:00 AM | 3 | 3X4 | 6017167.4480367005 | 2096189.4017781997 | 37.7366998078586 | -122.38309692991999 | (37.7366998078586, -122.38309692992) | ||
| 104613 | 104613 | 18637 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 25 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/1998 12:00:00 AM | 3 | 3X4 | 6017121.136185501 | 2096199.8633465 | 37.736725974033604 | -122.383257779638 | (37.7367259740336, -122.383257779638) | ||
| 107927 | 107927 | 18649 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 70 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1999 12:00:00 AM | 3 | 3X4 | 6017298.515724 | 2096054.3606827 | 37.7363362535881 | -122.382634373709 | (37.7363362535881, -122.382634373709) | ||
| 113449 | 113449 | 18638 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 25 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017121.136185501 | 2096199.8633465 | 37.736725974033604 | -122.383257779638 | (37.7367259740336, -122.383257779638) | ||
| 125389 | 125389 | 18655 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 85 Reuel Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | ||
| 2715 | 2715 | 253166 | Planning Code 138.1 required 4 | Pyrus kawakamii :: Evergreen Pear 82 | 2405 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778209 | 5986396.6612 | 2098868.17463 | 37.742306656921 | -122.48968039586501 | (37.742306656921, -122.489680395865) | |
| 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) | |||
| 6813 | 6813 | 52112 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 435 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48303 | 6005739.8209 | 2111002.5816 | 37.776735260452 | -122.423660135383 | (37.776735260452, -122.423660135383) | |
| 8083 | 8083 | 7308 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1919 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2011 12:00:00 AM | 3 | 3x3 | 6002923.2911 | 2115026.9363 | 37.787625737445204 | -122.433691029207 | (37.7876257374452, -122.433691029207) | ||
| 9055 | 9055 | 24107 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 105X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
| 9197 | 9197 | 24149 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006835996 | -122.385890729183 | (37.736379006836, -122.385890729183) | ||
| 9206 | 9206 | 24109 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 105X Whitney Young Cir | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
| 9227 | 9227 | 24151 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006835996 | -122.385890729183 | (37.736379006836, -122.385890729183) | ||
| 10059 | 10059 | 24572 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2122 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/2013 12:00:00 AM | 3 | 3x3 | 6002889.00041 | 2115679.48805 | 37.7894155324538 | -122.433856328234 | (37.7894155324538, -122.433856328234) | ||
| 13396 | 13396 | 85628 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1470 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015957.8963 | 2094137.5833 | 37.730999015226104 | -122.387135841638 | (37.7309990152261, -122.387135841638) | ||
| 13415 | 13415 | 85617 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1274 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017015.0778 | 2093348.1164 | 37.7288897808137 | -122.383426014631 | (37.7288897808137, -122.383426014631) | ||
| 13512 | 13512 | 85658 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1643 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015004.908 | 2094769.8823 | 37.7326823614983 | -122.39047467450001 | (37.7326823614983, -122.3904746745) | ||
| 13554 | 13554 | 85620 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1344 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016632.8917 | 2093635.0593 | 37.729656539473 | -122.384767252586 | (37.729656539473, -122.384767252586) | ||
| 13600 | 13600 | 85619 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1338 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016653.5768 | 2093624.593 | 37.729628945087704 | -122.384695012523 | (37.7296289450877, -122.384695012523) | ||
| 13802 | 13802 | 85643 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1235 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017171.4256 | 2093155.5219 | 37.7283695937915 | -122.38287210620199 | (37.7283695937915, -122.382872106202) | ||
| 13898 | 13898 | 30637 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008025.7883 | 2108500.0528 | 37.7699926802506 | -122.415575048334 | (37.7699926802506, -122.415575048334) | |
| 13961 | 13961 | 85647 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1351 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016557.1838 | 2093613.7118 | 37.7295937360014 | -122.385027498588 | (37.7295937360014, -122.385027498588) | ||
| 14063 | 14063 | 30634 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008069.1402 | 2108631.1108 | 37.770354971481794 | -122.415434374116 | (37.7703549714818, -122.415434374116) | |
| 14120 | 14120 | 85653 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1541 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015555.708 | 2094360.5338 | 37.731588912651404 | -122.388541843069 | (37.7315889126514, -122.388541843069) | ||
| 14131 | 14131 | 85613 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1190 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017458.1534 | 2093022.4369 | 37.728020006278 | -122.38187161186 | (37.728020006278, -122.38187161186) | ||
| 14162 | 14162 | 85622 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1360 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016552.9396 | 2093696.0654 | 37.729819627930105 | -122.385047906896 | (37.7298196279301, -122.385047906896) |
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");