Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5893 | 5893 | 46201 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 6305 | 6305 | 52146 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 145 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2005 12:00:00 AM | Permit Number 48337 | ||||||||
| 9250 | 9250 | 46200 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 11507 | 11507 | 30593 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 269 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34561 | ||||||||
| 13405 | 13405 | 30592 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 269 Walter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34561 | ||||||||
| 109406 | 109406 | 63194 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 420 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | Permit Number 23734 | 5984095.68800959 | 2112985.55374836 | 37.78093439601071 | -122.498678978522 | (37.7809343960107, -122.498678978522) | ||
| 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) | |
| 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) | ||
| 69129 | 69129 | 69449 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 435 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 7 | Permit Number 33559 | 5985596.63224 | 2112961.6611 | 37.7809567074922 | -122.493484787172 | (37.7809567074922, -122.493484787172) | |
| 72842 | 72842 | 69456 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 471 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 5 | Permit Number 33566 | 5985607.3929 | 2112736.22477 | 37.7803383536355 | -122.493430946652 | (37.7803383536355, -122.493430946652) | |
| 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) | ||
| 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) | ||||
| 123759 | 123759 | 38869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2439 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40694 | 5987327.75302366 | 2098677.68678111 | 37.7418379454862 | -122.486447023752 | (37.7418379454862, -122.486447023752) | ||
| 120653 | 120653 | 93044 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 155 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5987698.59819 | 2114939.90173 | 37.7865111255347 | -122.486358421479 | (37.7865111255347, -122.486358421479) | ||||
| 156985 | 156985 | 65109 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 145 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 5 | Permit Number 27078 | 5988958.234730001 | 2114388.99376 | 37.7850718280894 | -122.481960071321 | (37.7850718280894, -122.481960071321) | |
| 175706 | 175706 | 64667 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 155 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 7 | Permit Number 27077 | 5988959.0752 | 2114316.0403299998 | 37.784871567471704 | -122.48195181759701 | (37.7848715674717, -122.481951817597) | |
| 135886 | 135886 | 65108 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 183 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 6 | Permit Number 27075 | 5988968.22756 | 2114128.63613 | 37.7843575407485 | -122.481906421224 | (37.7843575407485, -122.481906421224) | |
| 139387 | 139387 | 3372 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 5951 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5989085.57316 | 2113985.01381 | 37.7839700180526 | -122.48148992901301 | (37.7839700180526, -122.481489929013) | |||
| 70653 | 70653 | 65118 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 127 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 4 | Permit Number 27088 | 5989266.29156 | 2114491.8349900004 | 37.7853721122289 | -122.480901836159 | (37.7853721122289, -122.480901836159) | |
| 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) | |
| 161956 | 161956 | 65112 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 367 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 9 | Permit Number 27081 | 5989323.93516 | 2112879.29731 | 37.78094788727989 | -122.48058432391001 | (37.7809478872799, -122.48058432391) | |
| 46895 | 46895 | 88581 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 515 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51523 | 5989364.701169999 | 2111797.63767 | 37.777980320812 | -122.480364100125 | (37.777980320812, -122.480364100125) | ||
| 43050 | 43050 | 83178 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 743 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51518 | 5990037.32656 | 2110290.0684599997 | 37.7738800155956 | -122.477927036337 | (37.7738800155956, -122.477927036337) | |
| 157386 | 157386 | 49548 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2434@ TARAVAL 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2003 12:00:00 AM | 1 | Permit Number 46439 | 5989857.9655 | 2098790.1552 | 37.742293916006 | -122.47770669165199 | (37.742293916006, -122.477706691652) | ||
| 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) | ||
| 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) | |
| 127900 | 127900 | 69289 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1900 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1994 12:00:00 AM | Permit Number 33361 | 5990665.04614057 | 2102443.50433652 | 37.7523718663796 | -122.47518273070699 | (37.7523718663796, -122.475182730707) | ||
| 137292 | 137292 | 56158 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 447 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 8 | Permit Number 12266 | 5990893.795580001 | 2112339.9216299998 | 37.779558022090605 | -122.475114071606 | (37.7795580220906, -122.475114071606) | ||
| 174380 | 174380 | 56156 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 471 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 12 | Permit Number 12264 | 5990899.19855 | 2112188.99411 | 37.779143929860204 | -122.475084359841 | (37.7791439298602, -122.475084359841) | ||
| 169460 | 169460 | 56218 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 475 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12339 | 5990899.771790001 | 2112161.89837 | 37.779069565646 | -122.475080398267 | (37.779069565646, -122.475080398267) | ||
| 162268 | 162268 | 56219 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 479 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 6 | Permit Number 12340 | 5990900.9414099995 | 2112135.93012 | 37.7789983317715 | -122.475074455932 | (37.7789983317715, -122.475074455932) | ||
| 31313 | 31313 | 56220 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 483 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 10 | Permit Number 12342 | 5990901.62894 | 2112114.24855 | 37.7789388399986 | -122.475070494342 | (37.7789388399986, -122.475070494342) | ||
| 135724 | 135724 | 56157 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 474 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 9 | Permit Number 12265 | 5990948.43736 | 2112161.09667 | 37.7790701847482 | -122.474911987504 | (37.7790701847482, -122.474911987504) | ||
| 109609 | 109609 | 60149 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1719 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19680 | 5990880.97000409 | 2103694.68949662 | 37.755819804064394 | -122.474527341121 | (37.7558198040644, -122.474527341121) | ||
| 128046 | 128046 | 60143 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1610 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19673 | 5990907.91625844 | 2104426.54438296 | 37.7578308453136 | -122.474487560238 | (37.7578308453136, -122.474487560238) | ||
| 100811 | 100811 | 60145 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1622 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19675 | 5990910.59858922 | 2104348.57566212 | 37.757616919266 | -122.474472593844 | (37.757616919266, -122.474472593844) | ||
| 96854 | 96854 | 60150 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1767 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19681 | 5990891.54356846 | 2103381.184277 | 37.754959614042 | -122.474467896907 | (37.754959614042, -122.474467896907) | ||
| 108707 | 108707 | 60148 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1718 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19679 | 5990932.94045417 | 2103696.44229965 | 37.7558276278389 | -122.47434774022301 | (37.7558276278389, -122.474347740223) | ||
| 114089 | 114089 | 60151 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1774 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19682 | 5990945.27627844 | 2103330.68623451 | 37.75482407276029 | -122.47427839119699 | (37.7548240727603, -122.474278391197) | ||
| 27678 | 27678 | 68339 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 410 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32156 | 5991257.09324 | 2112608.74204 | 37.7803171779643 | -122.47387689925101 | (37.7803171779643, -122.473876899251) | |
| 30941 | 30941 | 88552 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 649 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51497 | 5991271.5415199995 | 2111000.35442 | 37.7759018234336 | -122.473709552083 | (37.7759018234336, -122.473709552083) | ||
| 112025 | 112025 | 12667 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1124 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5991972.94269 | 2114825.89139 | 37.7864462960863 | -122.471562077277 | (37.7864462960863, -122.471562077277) | |||
| 114914 | 114914 | 86713 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 938 Garfield St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2007 12:00:00 AM | Permit Number 49699 | 5991527.0 | 2090568.7 | 37.7198165808065 | -122.47133684225099 | (37.7198165808065, -122.471336842251) | ||||
| 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) | ||
| 135435 | 135435 | 68690 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 186 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 6 | Permit Number 32600 | 5992142.590419999 | 2114229.3610400003 | 37.7848182016374 | -122.47093167287201 | (37.7848182016374, -122.470931672872) | |
| 103607 | 103607 | 69109 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1703 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33124 | 5992147.14978807 | 2103857.2761891005 | 37.7563395059652 | -122.470160361019 | (37.7563395059652, -122.470160361019) | ||
| 104090 | 104090 | 87073 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 4 | 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) | |||
| 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) | |||
| 69527 | 69527 | 31227 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2598 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34913 | 5992091.019830001 | 2097838.61761 | 37.7398105749846 | -122.46991627883301 | (37.7398105749846, -122.469916278833) | |
| 187404 | 187404 | 31226 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2598 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 6 | Permit Number 34913 | 5992091.73833 | 2097813.94877 | 37.7397428821404 | -122.469911998937 | (37.7397428821404, -122.469911998937) | |
| 89990 | 89990 | 8937 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4649X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5992538.4516199995 | 2112697.71115 | 37.780635596911104 | -122.469450604294 | (37.7806355969111, -122.469450604294) | |||
| 146318 | 146318 | 8938 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4649X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5992558.61151 | 2112698.79101 | 37.7806397269512 | -122.469380940837 | (37.7806397269512, -122.469380940837) | |||
| 145070 | 145070 | 55270 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 809 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32396 | 5992382.44974981 | 2102648.13821757 | 37.7530331280839 | -122.46925861560499 | (37.7530331280839, -122.469258615605) | ||
| 87025 | 87025 | 69100 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33115 | 5992448.84064151 | 2104114.43419147 | 37.757063031457 | -122.469135733901 | (37.757063031457, -122.469135733901) | ||
| 97120 | 97120 | 31159 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 159 Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34861 | 5992168.57477518 | 2088923.19870563 | 37.7153355266741 | -122.46899947505 | (37.7153355266741, -122.46899947505) | ||
| 126488 | 126488 | 69098 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1658 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33113 | 5992499.06205436 | 2104168.35309074 | 37.757213980437996 | -122.46896597445101 | (37.757213980438, -122.468965974451) | ||
| 111893 | 111893 | 51083 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1662 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | Permit Number 47541 | 5992499.93674596 | 2104142.2648984 | 37.7571423996122 | -122.468961050964 | (37.7571423996122, -122.468961050964) | |||
| 144155 | 144155 | 69099 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1666 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33114 | 5992500.81143839 | 2104116.17668169 | 37.7570708187185 | -122.46895612748199 | (37.7570708187185, -122.468956127482) | ||
| 131135 | 131135 | 58801 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 136 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1979 12:00:00 AM | 11 | Permit Number 18050 | 5992752.10846 | 2114546.65003 | 37.7857246222932 | -122.468846055179 | (37.7857246222932, -122.468846055179) | ||
| 110965 | 110965 | 69113 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 531 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33128 | 5992671.96084609 | 2104547.37916981 | 37.7582646751523 | -122.468395603141 | (37.7582646751523, -122.468395603141) | ||
| 146854 | 146854 | 68934 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 691 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32918 | 5992842.27322 | 2110813.31617 | 37.77547911209629 | -122.46826242331001 | (37.7754791120963, -122.46826242331) | |
| 137742 | 137742 | 102622 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 719 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2014 12:00:00 AM | 1 | Permit Number 772854 | 5992851.12865 | 2110544.54919 | 37.774741661803006 | -122.46821223444401 | (37.774741661803, -122.468212234444) | ||
| 38406 | 38406 | 46422 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 708 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2002 12:00:00 AM | 1 | Permit Number 44644 | 5992896.66955 | 2110586.4046099996 | 37.7748592156207 | -122.468057745767 | (37.7748592156207, -122.468057745767) | ||
| 88863 | 88863 | 92267 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52719 | 5992767.0 | 2098334.0 | 37.7412098217915 | -122.46761506147101 | (37.7412098217915, -122.467615061471) | ||
| 142371 | 142371 | 92268 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52719 | 5992767.0 | 2098334.0 | 37.7412098217915 | -122.46761506147101 | (37.7412098217915, -122.467615061471) | ||
| 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) | |||
| 92861 | 92861 | 8912 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4455X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5993182.362319999 | 2112722.76783 | 37.7807415869386 | -122.46722485031 | (37.7807415869386, -122.46722485031) | |||
| 122051 | 122051 | 48865 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 149 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46856 | 5992881.93152757 | 2098112.87490304 | 37.74060930330371 | -122.46720159873001 | (37.7406093033037, -122.46720159873) | ||
| 84091 | 84091 | 8916 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4455X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5993207.14557 | 2112702.93338 | 37.7806885575202 | -122.467137671277 | (37.7806885575202, -122.467137671277) | |||
| 111184 | 111184 | 8914 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4455X Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5993220.18718 | 2112725.9832200003 | 37.7807525989198 | -122.467094230779 | (37.7807525989198, -122.467094230779) | |||
| 83502 | 83502 | 48864 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 141 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46854 | 5992914.37939707 | 2098147.89875638 | 37.740707342979995 | -122.467091953195 | (37.74070734298, -122.467091953195) | ||
| 108781 | 108781 | 48863 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 141 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46854 | 5992914.37939707 | 2098147.89875638 | 37.740707342979995 | -122.467091953195 | (37.74070734298, -122.467091953195) | ||
| 90960 | 90960 | 48862 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 135 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46853 | 5992938.7152954005 | 2098174.1666423 | 37.7407808726579 | -122.46700971886699 | (37.7407808726579, -122.467009718867) | ||
| 113962 | 113962 | 48861 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 135 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46853 | 5992938.7152954005 | 2098174.1666423 | 37.7407808726579 | -122.46700971886699 | (37.7407808726579, -122.467009718867) | ||
| 93793 | 93793 | 50131 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 131 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46852 | 5992954.93923014 | 2098191.67856897 | 37.7408298924183 | -122.466954895883 | (37.7408298924183, -122.466954895883) | ||
| 160765 | 160765 | 68930 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 768 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | Permit Number 32914 | 5993218.422259999 | 2110247.19429 | 37.7739464110699 | -122.466920079783 | (37.7739464110699, -122.466920079783) | |
| 107964 | 107964 | 69092 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1851 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33107 | 5993111.66975744 | 2102880.65538542 | 37.753713671687706 | -122.46675375369 | (37.7537136716877, -122.46675375369) | ||
| 126104 | 126104 | 41461 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 460 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | Permit Number 42046 | 5993018.50469486 | 2090233.49581681 | 37.7189823574514 | -122.46615693113701 | (37.7189823574514, -122.466156931137) | |||
| 123540 | 123540 | 41462 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 454 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | Permit Number 42047 | 5993018.04440435 | 2090196.48136289 | 37.718880698161605 | -122.46615583377199 | (37.7188806981616, -122.466155833772) | |||
| 120811 | 120811 | 46909 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1347 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44966 | 5993612.09536282 | 2106325.94034121 | 37.7632023982881 | -122.465273422298 | (37.7632023982881, -122.465273422298) | ||
| 60208 | 60208 | 50802 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 539REVISED 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53851 | 5993738.09251 | 2111820.21552 | 37.778295485898 | -122.465236749215 | (37.778295485898, -122.465236749215) |
| 185326 | 185326 | 49094 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 140 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 6 | Permit Number 46242 | 5993992.46837 | 2114616.14539 | 37.785987019084295 | -122.464559844416 | (37.7859870190843, -122.464559844416) | ||
| 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) | |
| 123949 | 123949 | 108443 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 559 05th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773772 | 5994363.45802 | 2111716.68858 | 37.7780472719646 | -122.463065881676 | (37.7780472719646, -122.463065881676) | |||
| 169415 | 169415 | 41926 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 444 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 7 | Permit Number 42286 | 5994688.62474 | 2112489.12651 | 37.7801869053866 | -122.46199705059601 | (37.7801869053866, -122.461997050596) | |
| 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) | |||
| 66013 | 66013 | 36339 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906105995 | 2092991.57857678 | 37.726705001321996 | -122.457372735726 | (37.726705001322, -122.457372735726) | ||
| 88425 | 88425 | 49885 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59@ WILDWOOD Eastwood Dr | 2 | 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) | |||
| 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) | ||
| 18932 | 18932 | 30938 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1106 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 8 | 3x3 | Permit Number 772469 | 5995956.71997 | 2091289.90864 | 37.722052099618104 | -122.456077064214 | (37.7220520996181, -122.456077064214) | |
| 144864 | 144864 | 102763 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 50X Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2013 12:00:00 AM | 3x3 | Permit Number 769605 | 5996378.1 | 2106680.6 | 37.7643353262738 | -122.45573242834699 | (37.7643353262738, -122.455732428347) | |
| 60649 | 60649 | 58694 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3633 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1979 12:00:00 AM | 4 | Permit Number 17970 | 5996855.26576 | 2115960.6148599996 | 37.7898431897625 | -122.454752572401 | (37.7898431897625, -122.454752572401) | ||
| 169703 | 169703 | 36194 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 107 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 39260 | 5997029.24357 | 2115938.23155 | 37.7897917089598 | -122.454149011282 | (37.7897917089598, -122.454149011282) | |||
| 92856 | 92856 | 35042 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 158 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/1998 12:00:00 AM | Permit Number 38609 | 5996885.33354798 | 2089115.06440217 | 37.7161337438742 | -122.45271020646099 | (37.7161337438742, -122.452710206461) | ||
| 95973 | 95973 | 95614 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Temescal Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52561 | 5997427.8 | 2111420.0 | 37.777408683378404 | -122.45244386493 | (37.7774086833784, -122.45244386493) | |
| 150627 | 150627 | 32284 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 31 Temescal Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52573 | 5997438.818 | 2111434.025 | 37.77744782360929 | -122.45240676257099 | (37.7774478236093, -122.452406762571) |
| 170669 | 170669 | 53032 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35GOLDENGATE Temescal Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | 2 | 3x3 | Permit Number 49011 | 5997444.5897 | 2111409.0141 | 37.7773794808628 | -122.45238499119301 | (37.7773794808628, -122.452384991193) | |
| 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) | ||
| 71265 | 71265 | 52637 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2@ PACIFIC Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 8 | Permit Number 48719 | 5997984.07214 | 2116339.1765799997 | 37.7909473027338 | -122.450874333286 | (37.7909473027338, -122.450874333286) | ||
| 104078 | 104078 | 88251 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4903 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51237 | 5997791.1 | 2105582.1 | 37.7614001117653 | -122.450766072013 | (37.7614001117653, -122.450766072013) |
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");