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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
12987 | 12987 | 1848 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2401 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011043.028059999 | 2086938.1542099998 | 37.7109574665846 | -122.403621108454 | (37.7109574665846, -122.403621108454) | |||
8714 | 8714 | 2466 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1826 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1998 12:00:00 AM | 3 | 4X4 | 6003983.3989 | 2114773.4102 | 37.786989713975295 | -122.43000517250799 | (37.7869897139753, -122.430005172508) | ||
86817 | 86817 | 5934 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1355 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | |||
103857 | 103857 | 7248 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1880X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/04/2015 12:00:00 AM | 6 | 4X4 | 6003177.7471647 | 2114161.423532 | 37.7852636935379 | -122.43274880955 | (37.7852636935379, -122.43274880955) | ||
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) | ||
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) | ||
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) | ||
100117 | 100117 | 8939 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 4649X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5992577.29346 | 2112701.40564 | 37.7806479856044 | -122.469316501972 | (37.7806479856044, -122.469316501972) | |||
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) | |||
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) | |
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) | ||
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) | ||
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) | ||
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) | ||
21863 | 21863 | 16675 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 244 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002863.50303 | 2106836.724 | 37.7651340593044 | -122.433312415546 | (37.7651340593044, -122.433312415546) | |||
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) | |||
78191 | 78191 | 18254 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1830 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1998 12:00:00 AM | 12 | 4X4 | 6003416.3649635 | 2114195.205569 | 37.785369980601395 | -122.431925678527 | (37.7853699806014, -122.431925678527) | ||
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) | ||
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 | ||||||||
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) | |||
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) | |
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) |
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) | |||
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) | |||
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) | |
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) | ||
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) | |||
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) | ||
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) | |||
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) | |||
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) | ||
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) | |
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) | |||
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) | |||
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) | |||
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) | ||
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) | ||
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) |
105009 | 105009 | 85087 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
102660 | 102660 | 85090 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
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) | ||
16538 | 16538 | 85640 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017322.9044 | 2093043.5358 | 37.7280704700942 | -122.382340643729 | (37.7280704700942, -122.382340643729) | ||
79081 | 79081 | 85656 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1699X Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6014788.408146 | 2094944.7735630001 | 37.7331505648623 | -122.39123539488199 | (37.7331505648623, -122.391235394882) | ||
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) | |||
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) | ||
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) | ||
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) | ||
19418 | 19418 | 90383 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.42000143597099 | (37.7740948433326, -122.420001435971) | ||
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) | |
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) | ||
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) | ||||
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) | ||
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) | ||
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) | |
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) | |
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) | |
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | ||||
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) | |||
88644 | 88644 | 111861 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 201x LOBOS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 5994528.0 | 2088713.0 | 37.714894412350205 | -122.460829096166 | (37.7148944123502, -122.460829096166) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | ||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
175148 | 175148 | 136110 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1725 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005929.66848 | 2117544.18385 | 37.7947075984216 | -122.423468565942 | (37.7947075984216, -122.423468565942) | |||
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) | |||
162116 | 162116 | 136199 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2101 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000108.92159 | 2120908.29838 | 37.8036143086235 | -122.443850879042 | (37.8036143086235, -122.443850879042) | |||
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) | |||
167332 | 167332 | 136212 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Spruce St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5997026.477630001 | 2115953.7993900003 | 37.7898342954728 | -122.454159706 | (37.7898342954728, -122.454159706) | |||
156207 | 156207 | 136214 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3601 Jackson St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5996953.554930001 | 2115974.46386 | 37.7898868527455 | -122.45441350368999 | (37.7898868527455, -122.45441350369) | |||
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) | |||
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) | |||
157723 | 157723 | 136241 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006661.2210800005 | 2116996.6606900003 | 37.7932454995431 | -122.42089839975 | (37.7932454995431, -122.42089839975) | |||
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) | |||
162611 | 162611 | 136256 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1422 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006727.18618 | 2118403.8407799997 | 37.7971129818473 | -122.42077010155701 | (37.7971129818473, -122.420770101557) | |||
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) | |||
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) | |||
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) | |||
162115 | 162115 | 138075 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1900 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002996.0585 | 2114912.5257 | 37.7873157236915 | -122.433431089473 | (37.7873157236915, -122.433431089473) | |||
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) | |||
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) | |||
167341 | 167341 | 138453 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002943.8549 | 2114900.2728 | 37.7872791184788 | -122.433610826756 | (37.7872791184788, -122.433610826756) |
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");