Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9321 | 9321 | 11465 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016782.5188136 | 2095601.0665952999 | 37.7350630793796 | -122.384386845805 | (37.7350630793796, -122.384386845805) | ||
| 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) | |
| 15074 | 15074 | 11468 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 6 | 3X3 | 6016817.53474 | 2095601.45988 | 37.735066095427705 | -122.384265809434 | (37.7350660954277, -122.384265809434) | ||
| 15644 | 15644 | 16542 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6016097.47551 | 2098025.0219 | 37.741680865376 | -122.386924304309 | (37.741680865376, -122.386924304309) | |||
| 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) | ||
| 27408 | 27408 | 85487 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Bacon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010399.4592 | 2092794.41628 | 37.727001587734605 | -122.40625779115801 | (37.7270015877346, -122.406257791158) | ||
| 36622 | 36622 | 102487 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2001 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5999337.8085 | 2111150.0142 | 37.7767766147896 | -122.445817121147 | (37.7767766147896, -122.445817121147) | |||
| 43027 | 43027 | 94791 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Laurel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 4 | Permit Number 53892 | 5997983.38903 | 2116351.46746 | 37.79098101110971 | -122.450877583428 | (37.7909810111097, -122.450877583428) | ||
| 53160 | 53160 | 91043 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50399 | 6006460.43386 | 2121423.80416 | 37.8053899957025 | -122.421907764657 | (37.8053899957025, -122.421907764657) | |
| 55755 | 55755 | 48872 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 150 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2002 12:00:00 AM | 6 | 3x3 | Permit Number 46081 | 6011751.8076 | 2120847.07255 | 37.8041034220013 | -122.403555563145 | (37.8041034220013, -122.403555563145) | |
| 63414 | 63414 | 49886 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59@ WILDWOOD Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906105995 | 2092991.57857678 | 37.726705001321996 | -122.457372735726 | (37.726705001322, -122.457372735726) | |||
| 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) | ||
| 84924 | 84924 | 88489 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 85689 | 85689 | 41239 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
| 87043 | 87043 | 96121 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Bennington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767773 | 6007093.0 | 2096944.0 | 37.7382099281297 | -122.417982227017 | (37.7382099281297, -122.417982227017) | |
| 87317 | 87317 | 8192 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1280 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1991 12:00:00 AM | 6 | 3X3 | 6001602.3460099995 | 2111171.39622 | 37.776964363900596 | -122.437984956441 | (37.7769643639006, -122.437984956441) | ||
| 91044 | 91044 | 111484 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1745 FOLSOM ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008026.0 | 2108277.0 | 37.7693802414943 | -122.41555852152901 | (37.7693802414943, -122.415558521529) | ||||
| 94048 | 94048 | 121095 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1691 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6001097.0 | 2111345.0 | 37.7774122850927 | -122.439745549 | (37.7774122850927, -122.439745549) | |||
| 94685 | 94685 | 31311 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 709 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | Permit Number 34949 | 6004473.77987727 | 2110903.29372292 | 37.77639109406471 | -122.428032671161 | (37.7763910940647, -122.428032671161) | |||
| 96588 | 96588 | 49613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
| 97129 | 97129 | 52059 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3165 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2005 12:00:00 AM | Permit Number 48256 | 6006783.78749917 | 2099933.06553583 | 37.746399825173 | -122.419263309296 | (37.746399825173, -122.419263309296) | |||
| 106029 | 106029 | 9979 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 810X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2011 12:00:00 AM | 12 | 3X3 | Permit Number 54081 | 6003050.1396073 | 2111037.6486225 | 37.7766793527515 | -122.432967039601 | (37.7766793527515, -122.432967039601) | |
| 110241 | 110241 | 87072 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 111046 | 111046 | 52906 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 295 Gaven St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 3x3 | Permit Number 48898 | 6009070.24444642 | 2094849.33610342 | 37.732569516932294 | -122.41099796146001 | (37.7325695169323, -122.41099796146) | ||
| 112178 | 112178 | 8108 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 785 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 4 | 3X3 | 6004054.06089 | 2111452.3407900003 | 37.777874887005 | -122.429523762111 | (37.777874887005, -122.429523762111) | ||
| 112997 | 112997 | 106644 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3294 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2014 12:00:00 AM | 3X3 | Permit Number 772448 | 6007856.1 | 2100992.4 | 37.7493688530402 | -122.415630356523 | (37.7493688530402, -122.415630356523) | ||
| 114370 | 114370 | 100412 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201x Linden St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006435.0 | 2110776.0 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | |||
| 115346 | 115346 | 34241 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | |||
| 116608 | 116608 | 16680 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 248 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002873.990875499 | 2106855.8321643 | 37.765187120656705 | -122.433277506161 | (37.7651871206567, -122.433277506161) | |||
| 119903 | 119903 | 95814 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 691 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767553 | 6015464.0 | 2105840.0 | 37.763104051991604 | -122.38966036521799 | (37.7631040519916, -122.389660365218) | |
| 121840 | 121840 | 93814 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426001 | (37.7744697656056, -122.40000821426) | ||
| 122413 | 122413 | 87848 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2480 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50600 | 6006948.0 | 2103912.0 | 37.757334318408 | -122.41897764469499 | (37.757334318408, -122.418977644695) | ||
| 124505 | 124505 | 39115 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 501 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50596 | 6006834.26665835 | 2100862.7419909 | 37.7489553490953 | -122.419154691519 | (37.7489553490953, -122.419154691519) | ||
| 124982 | 124982 | 111868 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3399x 16TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004303.0 | 2106535.0 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | ||||
| 125862 | 125862 | 87680 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.805369133986794 | -122.42172073484699 | (37.8053691339868, -122.421720734847) | ||
| 128120 | 128120 | 43506 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 161 Newman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2000 12:00:00 AM | Permit Number 43184 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.41712235805201 | (37.7377931534639, -122.417122358052) | |||
| 128875 | 128875 | 95303 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 701 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617005 | -122.422419858646 | (37.780652317617, -122.422419858646) | ||
| 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) | ||
| 129350 | 129350 | 47638 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.44983409577299 | (37.7806775849758, -122.449834095773) | |||
| 138813 | 138813 | 69224 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 345 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | 3 | 3x3 | Permit Number 33276 | 6005935.60239934 | 2110883.16438759 | 37.7764184191765 | -122.42297437860701 | (37.7764184191765, -122.422974378607) |
| 141722 | 141722 | 9550 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1195X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.43006254712499 | (37.7797350134544, -122.430062547125) | |||
| 142130 | 142130 | 30656 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Lafayette St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.773163916329295 | -122.41734957960699 | (37.7731639163293, -122.417349579607) |
| 143528 | 143528 | 96049 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324.0 | 2099841.0 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | |
| 144769 | 144769 | 689 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 147739 | 147739 | 42170 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 12 | Permit Number 42460 | 6012634.74531 | 2111162.8232 | 37.7775620361946 | -122.399819646269 | (37.7775620361946, -122.399819646269) | ||
| 151589 | 151589 | 48815 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.97393 | 2102326.82142 | 37.7534023411579 | -122.392859509671 | (37.7534023411579, -122.392859509671) | ||
| 158473 | 158473 | 34253 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 7 | Permit Number 38731 | 6006242.74242 | 2121059.25353 | 37.8043767538414 | -122.42263519386199 | (37.8043767538414, -122.422635193862) | |
| 3820 | 3820 | 193326 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015584.3745800005 | 2102621.5534900003 | 37.754273559383 | -122.389019303814 | (37.754273559383, -122.389019303814) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 22887 | 22887 | 120259 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 130 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5988369.32629 | 2115004.14379 | 37.7867265878172 | -122.484042609601 | (37.7867265878172, -122.484042609601) | |||
| 26025 | 26025 | 136191 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6002535.252730001 | 2118218.14981 | 37.7963659626655 | -122.435261914602 | (37.7963659626655, -122.435261914602) | |||
| 26661 | 26661 | 213931 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 23 Hill Point Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996332.88729 | 2106669.96482 | 37.7643035299972 | -122.455888036623 | (37.7643035299972, -122.455888036623) | |||
| 29178 | 29178 | 197081 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015537.3565 | 2105827.07749 | 37.7630726369229 | -122.389405745189 | (37.7630726369229, -122.389405745189) | |||
| 30474 | 30474 | 138425 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003355.5073 | 2114484.6624 | 37.786161305767706 | -122.432156906104 | (37.7861613057677, -122.432156906104) | |||
| 31141 | 31141 | 123173 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 691 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992843.890869999 | 2110769.52892 | 37.7753589775368 | -122.468253641396 | (37.7753589775368, -122.468253641396) | |||
| 32309 | 32309 | 137616 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2260 Turk Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999176.7198 | 2111892.1732 | 37.77880519340229 | -122.446427777449 | (37.7788051934023, -122.446427777449) | |||
| 32797 | 32797 | 139276 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 725 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004285.6861 | 2111490.9383 | 37.777993978047704 | -122.428725241569 | (37.7779939780477, -122.428725241569) | |||
| 34519 | 34519 | 136225 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3699 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000164.78748 | 2120871.42318 | 37.803516245636004 | -122.44365490235201 | (37.803516245636, -122.443654902352) | |||
| 34527 | 34527 | 123209 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993132.47666 | 2112678.91247 | 37.7806182922184 | -122.46739423754299 | (37.7806182922184, -122.467394237543) | |||
| 38430 | 38430 | 197164 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017108.5730800005 | 2096118.78323 | 37.7365026499645 | -122.383295574057 | (37.7365026499645, -122.383295574057) | |||
| 41009 | 41009 | 239260 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 455 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005530.51021 | 2101066.0904 | 37.7494401890135 | -122.42367754770001 | (37.7494401890135, -122.4236775477) | |||
| 46246 | 46246 | 239327 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Mullen Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009414.17068 | 2099842.42151 | 37.7462987258005 | -122.410161311097 | (37.7462987258005, -122.410161311097) | |||
| 47047 | 47047 | 120253 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5988369.64092 | 2114933.75275 | 37.7865333323848 | -122.48403635730499 | (37.7865333323848, -122.484036357305) | |||
| 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) | |||
| 49202 | 49202 | 197168 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Baldwin Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017908.19776 | 2093591.9406 | 37.729608594643004 | -122.38035534224899 | (37.729608594643, -122.380355342249) | |||
| 49322 | 49322 | 197128 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016765.196409999 | 2098282.20265 | 37.7424239805909 | -122.384633436999 | (37.7424239805909, -122.384633436999) | |||
| 49521 | 49521 | 240131 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0 Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004671.7789900005 | 2103561.17999 | 37.7562426115098 | -122.426824733295 | (37.7562426115098, -122.426824733295) | |||
| 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) | |||
| 53227 | 53227 | 179288 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002296.73031 | 2094454.79419 | 37.7311040332072 | -122.434387409368 | (37.7311040332072, -122.434387409368) | |||
| 54162 | 54162 | 213964 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994850.90322 | 2091215.19212 | 37.7217834109648 | -122.459894162891 | (37.7217834109648, -122.459894162891) | |||
| 57011 | 57011 | 136263 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Montgomery St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6011331.32037 | 2121003.20622 | 37.804508630427 | -122.40502169731 | (37.804508630427, -122.40502169731) | |||
| 57513 | 57513 | 136207 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Laurel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998025.05505 | 2115724.49244 | 37.7892618895784 | -122.45068819790701 | (37.7892618895784, -122.450688197907) | |||
| 59666 | 59666 | 179298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Peru Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004373.55102 | 2093025.79015 | 37.7272979737044 | -122.427105731855 | (37.7272979737044, -122.427105731855) | |||
| 63717 | 63717 | 240167 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 955 Clayton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998784.85204 | 2106603.32437 | 37.764260973182395 | -122.44740261924 | (37.7642609731824, -122.44740261924) | |||
| 66976 | 66976 | 141938 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004007.1195 | 2112144.3973 | 37.779772444920894 | -122.42973552170099 | (37.7797724449209, -122.429735521701) | |||
| 68616 | 68616 | 137867 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2044 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002928.9527 | 2115414.1909 | 37.7886893612244 | -122.43369912921301 | (37.7886893612244, -122.433699129213) | |||
| 71421 | 71421 | 213970 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995027.09423 | 2091143.79671 | 37.721597507607996 | -122.45927995292699 | (37.721597507608, -122.459279952927) | |||
| 73312 | 73312 | 120776 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5989252.7771 | 2114825.68271 | 37.7862879782034 | -122.48097304382 | (37.7862879782034, -122.48097304382) | |||
| 74086 | 74086 | 239242 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010651.99768 | 2101656.70763 | 37.751349662874105 | -122.406008821959 | (37.7513496628741, -122.406008821959) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||||
| 129971 | 129971 | 138441 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003436.7333 | 2114199.9413 | 37.785384138383996 | -122.43185554851802 | (37.785384138384, -122.431855548518) | |||
| 133236 | 133236 | 197121 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Napoleon St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6014057.88074 | 2100147.5071099997 | 37.747395620823 | -122.39412515077 | (37.747395620823, -122.39412515077) | |||
| 134067 | 134067 | 197110 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6012050.80748 | 2105527.2247200003 | 37.7620553876595 | -122.40144353408701 | (37.7620553876595, -122.401443534087) | ||||
| 134201 | 134201 | 239246 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1300 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010306.7199800005 | 2101561.6603599996 | 37.7510693666623 | -122.40719613841298 | (37.7510693666623, -122.407196138413) | |||
| 147690 | 147690 | 136247 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1723 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006549.579919999 | 2116650.11937 | 37.7922876900734 | -122.421260066609 | (37.7922876900734, -122.421260066609) | |||
| 147968 | 147968 | 200740 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014877.3618 | 2094866.6866 | 37.732941090123404 | -122.390922400079 | (37.7329410901234, -122.390922400079) | |||
| 148148 | 148148 | 239334 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3206 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008990.25346 | 2099948.20272 | 37.7465654071644 | -122.411634644342 | (37.7465654071644, -122.411634644342) | |||
| 149063 | 149063 | 239273 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007374.78459 | 2107260.9108700003 | 37.7665536733524 | -122.417739020247 | (37.7665536733524, -122.417739020247) | |||
| 152567 | 152567 | 249824 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 285 Kearny St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6010866.76079 | 2120642.6759099998 | 37.8034927229673 | -122.40660393393999 | (37.8034927229673, -122.40660393394) | |||
| 153317 | 153317 | 179315 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Hamilton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009040.95061 | 2093717.83367 | 37.729461010514605 | -122.411019345266 | (37.7294610105146, -122.411019345266) | |||
| 155091 | 155091 | 138511 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1910 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002975.4335 | 2114139.0808 | 37.785190869930794 | -122.433447155072 | (37.7851908699308, -122.433447155072) | |||
| 156143 | 156143 | 136234 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 928 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008238.09244 | 2115632.75649 | 37.7895893093397 | -122.41534570573299 | (37.7895893093397, -122.415345705733) |
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");