Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 429 | 429 | 142788 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 733 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Polk St Scape will replant | 6007029.0497 | 2113497.6534 | 37.7836588132661 | -122.419377346786 | (37.7836588132661, -122.419377346786) | ||
| 5339 | 5339 | 7304 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1908 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6002992.4511 | 2114925.4093 | 37.7873508941206 | -122.433444491336 | (37.7873508941206, -122.433444491336) | |||
| 7747 | 7747 | 7300 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1900 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6002999.289 | 2114860.4079 | 37.7871728047294 | -122.433416186864 | (37.7871728047294, -122.433416186864) | |||
| 13543 | 13543 | 13319 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 14 Mabrey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1992 12:00:00 AM | 7 | 3X3 | 6016463.59576 | 2095940.9292900001 | 37.7359786339072 | -122.385513164614 | (37.7359786339072, -122.385513164614) | ||
| 21266 | 21266 | 15611 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3361 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2001 12:00:00 AM | 7 | 3X3 | 6006103.7046 | 2098658.8645 | 37.7428628326579 | -122.421524482148 | (37.7428628326579, -122.421524482148) | ||
| 22361 | 22361 | 213977 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994717.86147 | 2090376.1855099997 | 37.719472047173205 | -122.460293291905 | (37.7194720471732, -122.460293291905) | |||
| 23538 | 23538 | 213933 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2176 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991344.08373 | 2100608.05246 | 37.7473715261751 | -122.472700716564 | (37.7473715261751, -122.472700716564) | |||
| 23815 | 23815 | 239298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1475 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 10ft | 6010135.52625 | 2100699.74587 | 37.7486931572616 | -122.407727378721 | (37.7486931572616, -122.407727378721) | |||
| 23855 | 23855 | 213936 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992721.86042 | 2099019.1696099997 | 37.7430885175375 | -122.46782095827801 | (37.7430885175375, -122.467820958278) | |||
| 26220 | 26220 | 136266 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010225.4664 | 2116932.79358 | 37.793270394575295 | -122.40856131286101 | (37.7932703945753, -122.408561312861) | |||
| 26386 | 26386 | 136222 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999346.78651 | 2119715.31037 | 37.8002951834309 | -122.446402399571 | (37.8002951834309, -122.446402399571) | |||
| 26558 | 26558 | 136248 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2023 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008588.60584 | 2119742.27726 | 37.800892734360296 | -122.414423864695 | (37.8008927343603, -122.414423864695) | |||
| 27085 | 27085 | 87158 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Augusta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50139 | 6011083.99361 | 2095446.91838 | 37.7343230701451 | -122.404077946949 | (37.7343230701451, -122.404077946949) | |
| 28029 | 28029 | 124413 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3900 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5996133.62205 | 2115253.7929599998 | 37.787861027515895 | -122.45719822521299 | (37.7878610275159, -122.457198225213) | |||
| 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) | |||
| 32007 | 32007 | 83299 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 25 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52357 | 6014332.78372 | 2094054.3132099998 | 37.7306802456855 | -122.39274835074801 | (37.7306802456855, -122.392748350748) | |
| 33788 | 33788 | 213974 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995026.3935 | 2091022.299 | 37.7212638636298 | -122.459273581222 | (37.7212638636298, -122.459273581222) | |||
| 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) | |||
| 35715 | 35715 | 139272 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 765 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004185.2644 | 2111476.3212 | 37.7779481591061 | -122.429071593475 | (37.7779481591061, -122.429071593475) | |||
| 36414 | 36414 | 136262 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Filbert St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012539.8548099995 | 2120210.2855 | 37.8023989459081 | -122.400783688018 | (37.8023989459081, -122.400783688018) | ||||
| 38038 | 38038 | 136216 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3330 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998869.71206 | 2115631.48922 | 37.7890548395604 | -122.447759099698 | (37.7890548395604, -122.447759099698) | |||
| 39948 | 39948 | 239313 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 496 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005503.510559999 | 2100853.22302 | 37.7488541799866 | -122.423755779701 | (37.7488541799866, -122.423755779701) | |||
| 40517 | 40517 | 31313 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 709 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 7 | Permit Number 34949 | 6004462.32974 | 2110985.15865 | 37.776615227251604 | -122.428078115713 | (37.7766152272516, -122.428078115713) | |
| 42220 | 42220 | 213980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 258 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994759.30681 | 2090307.0454 | 37.7192845888893 | -122.460145025196 | (37.7192845888893, -122.460145025196) | |||
| 44172 | 44172 | 247564 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6008777.64172 | 2095456.26862 | 37.7342196103425 | -122.412052440585 | (37.7342196103425, -122.412052440585) | |||
| 44521 | 44521 | 136250 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2711 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006868.56519 | 2121594.39083 | 37.8058813915667 | -122.420507486038 | (37.8058813915667, -122.420507486038) | |||
| 44555 | 44555 | 138699 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 BAKER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000123.7356 | 2114472.3378 | 37.785943704602 | -122.443337062115 | (37.785943704602, -122.443337062115) | |||
| 46447 | 46447 | 69353 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1337 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33444 | 6004896.60555 | 2120531.0120900003 | 37.8028503021536 | -122.42725596539302 | (37.8028503021536, -122.427255965393) | |
| 46583 | 46583 | 246509 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6004948.2324 | 2099866.59265 | 37.7461137586439 | -122.425605722044 | (37.7461137586439, -122.425605722044) | |||
| 50287 | 50287 | 136198 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2101 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000083.32441 | 2120905.42804 | 37.803604967353394 | -122.443939252695 | (37.8036049673534, -122.443939252695) | |||
| 51119 | 51119 | 182028 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2209 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988891.7451 | 2106459.406 | 37.7632955122177 | -122.481609125496 | (37.7632955122177, -122.481609125496) | |||
| 51338 | 51338 | 182788 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1781 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988111.6274 | 2103184.2484 | 37.754257425098096 | -122.484067075117 | (37.7542574250981, -122.484067075117) | |||
| 53551 | 53551 | 179326 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 327 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003741.707719999 | 2091620.88811 | 37.7234046745582 | -122.429189879225 | (37.7234046745582, -122.429189879225) | |||
| 53643 | 53643 | 95364 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 661 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 3x3 | Permit Number 778058 | 6010448.4751 | 2118513.4790000003 | 37.797623060035 | -122.407901201302 | (37.797623060035, -122.407901201302) | ||
| 53824 | 53824 | 30624 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1655 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35324 | 6008124.7709 | 2108587.5084 | 37.7702383761626 | -122.41523885993 | (37.7702383761626, -122.41523885993) | |
| 55531 | 55531 | 213928 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996333.8532300005 | 2106738.61687 | 37.764492086352 | -122.455889658989 | (37.764492086352, -122.455889658989) | |||
| 56406 | 56406 | 179294 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 187 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004035.67978 | 2092592.11371 | 37.7260880824925 | -122.428242857139 | (37.7260880824925, -122.428242857139) | |||
| 56742 | 56742 | 142824 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1731 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6006563.8602 | 2116843.0613 | 37.7928182655861 | -122.42122436333099 | (37.7928182655861, -122.421224363331) | |||
| 58447 | 58447 | 95867 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 733 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 7 | 3x3 | Permit Number 767588 | 6008296.37826 | 2120666.6947 | 37.8034145323264 | -122.415500582505 | (37.8034145323264, -122.415500582505) |
| 61539 | 61539 | 38704 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1697 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 7 | 3x3 | Permit Number 40612 | 6001060.2221 | 2111388.0751 | 37.7775284649677 | -122.43987586473801 | (37.7775284649677, -122.439875864738) |
| 64020 | 64020 | 82025 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 900-904 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50637 | 6008560.7244 | 2119705.2270299997 | 37.800789437354496 | -122.41451772334 | (37.8007894373545, -122.41451772334) | |
| 64389 | 64389 | 197077 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6014934.55258 | 2102947.77391 | 37.7551332492083 | -122.391289372524 | (37.7551332492083, -122.391289372524) | |||
| 65491 | 65491 | 69396 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 7 | Permit Number 33500 | 6001570.284530001 | 2087031.2786 | 37.7106794663567 | -122.436367757869 | (37.7106794663567, -122.436367757869) | |
| 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) | |
| 69751 | 69751 | 245375 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3583 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005426.8606 | 2097389.365 | 37.7393388868642 | -122.42377457529301 | (37.7393388868642, -122.423774575293) | |||
| 69793 | 69793 | 120774 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5989253.85466 | 2114850.93568 | 37.7863573783569 | -122.48097116542499 | (37.7863573783569, -122.480971165425) | |||
| 70320 | 70320 | 181741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1215 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985810.6327 | 2106942.082 | 37.7644411641486 | -122.492301073815 | (37.7644411641486, -122.492301073815) | |||
| 73250 | 73250 | 136267 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010219.360169999 | 2116967.29713 | 37.79336479099371 | -122.408584876014 | (37.7933647909937, -122.408584876014) | |||
| 73613 | 73613 | 136261 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008598.0245 | 2119155.01738 | 37.7992807940363 | -122.414349696679 | (37.7992807940363, -122.414349696679) | ||||
| 74587 | 74587 | 182789 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1785 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988112.4655 | 2103151.9819 | 37.7541688787672 | -122.484061810783 | (37.7541688787672, -122.484061810783) | |||
| 76552 | 76552 | 136258 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2110 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007680.05725 | 2119655.03643 | 37.800602112147295 | -122.417561647852 | (37.8006021121473, -122.417561647852) | |||
| 81776 | 81776 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 91793 | 91793 | 32025 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2431 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 7 | 4x4 | Permit Number 35414 | 6002714.02785707 | 2116573.3755444 | 37.7918599877301 | -122.434525653083 | (37.7918599877301, -122.434525653083) | |
| 92012 | 92012 | 7320 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2016 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1992 12:00:00 AM | 7 | 3X3 | 6003001.73917 | 2115232.48409 | 37.7881945703662 | -122.433434308795 | (37.7881945703662, -122.433434308795) | ||
| 92855 | 92855 | 24561 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1800 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1999 12:00:00 AM | 7 | 3X3 | 6003046.3255 | 2114475.99542 | 37.786119973984206 | -122.43322597301099 | (37.7861199739842, -122.433225973011) | ||
| 93217 | 93217 | 114390 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 101580 | 101580 | 5925 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1335 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/2016 12:00:00 AM | 7 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | ||
| 102188 | 102188 | 60612 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 76 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | 7 | Permit Number 20236 | 6004870.59253737 | 2097774.41480617 | 37.7403647286117 | -122.42572530389201 | (37.7403647286117, -122.425725303892) | |
| 106591 | 106591 | 7368 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2401 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1996 12:00:00 AM | 7 | 3X3 | 6002726.00787 | 2116542.1867400003 | 37.7917750313387 | -122.43448197129601 | (37.7917750313387, -122.434481971296) | ||
| 108386 | 108386 | 81728 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 7 | 4x4 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
| 115190 | 115190 | 8101 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 765 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 7 | 3X3 | 6004218.15362 | 2111478.37785 | 37.777955667841795 | -122.428957964704 | (37.7779556678418, -122.428957964704) | ||
| 120866 | 120866 | 136257 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2106 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007681.63018 | 2119639.37861 | 37.8005592082118 | -122.417555094503 | (37.8005592082118, -122.417555094503) | |||
| 124741 | 124741 | 81725 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 7 | 4x4 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
| 126901 | 126901 | 239312 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 476 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005497.718090001 | 2100914.6151 | 37.7490224215445 | -122.423780174714 | (37.7490224215445, -122.423780174714) | |||
| 130342 | 130342 | 69357 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1355 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33448 | 6004836.73382 | 2120523.45104 | 37.8028261553684 | -122.42746261343099 | (37.8028261553684, -122.427462613431) | |
| 130355 | 130355 | 136251 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2711 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006870.92139 | 2121576.32062 | 37.8058319081714 | -122.420498048543 | (37.8058319081714, -122.420498048543) | |||
| 132492 | 132492 | 138547 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1640 SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001637.8568 | 2114160.6327 | 37.785174068245894 | -122.438076291996 | (37.7851740682459, -122.438076291996) | |||
| 132810 | 132810 | 138448 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003221.0376 | 2114171.7858 | 37.7852946007927 | -122.43259977843901 | (37.7852946007927, -122.432599778439) | |||
| 134469 | 134469 | 197089 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014473.51573 | 2102162.27258 | 37.7529508329366 | -122.39282883379101 | (37.7529508329366, -122.392828833791) | |||
| 134521 | 134521 | 138951 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 713 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004468.8943 | 2110977.1298 | 37.776593553402705 | -122.42805483469401 | (37.7765935534027, -122.428054834694) | |||
| 136242 | 136242 | 244040 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 540 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997548.4099 | 2108554.3655 | 37.7695473010692 | -122.451819858751 | (37.7695473010692, -122.451819858751) | |||
| 146830 | 146830 | 30616 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1621 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 7 | Permit Number 34577 | 6008176.3922 | 2108702.7792 | 37.7705577837388 | -122.415068461945 | (37.7705577837388, -122.415068461945) | |
| 149008 | 149008 | 120775 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5989253.50277 | 2114844.1258799997 | 37.7863386601165 | -122.48097188408 | (37.7863386601165, -122.48097188408) | |||
| 150726 | 150726 | 239269 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 27 Woodward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6006491.50571 | 2108328.68595 | 37.7694357855487 | -122.420869947001 | (37.7694357855487, -122.420869947001) | |||
| 150866 | 150866 | 48811 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 7 | Permit Number 46042 | 6014468.770930001 | 2102318.37211 | 37.7533791854235 | -122.392856162375 | (37.7533791854235, -122.392856162375) | ||
| 151453 | 151453 | 239348 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 514 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6003174.42252 | 2098938.53683 | 37.7434651446005 | -122.43167307734899 | (37.7434651446005, -122.431673077349) | |||
| 151544 | 151544 | 61576 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2019 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 7 | Permit Number 21538 | 6012377.336080001 | 2102802.45934 | 37.754591994948 | -122.400122823023 | (37.754591994948, -122.400122823023) | |
| 152526 | 152526 | 179327 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 332 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003477.0395 | 2091792.3955 | 37.72386060926979 | -122.430117017306 | (37.7238606092698, -122.430117017306) | |||
| 156747 | 156747 | 179296 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004346.75764 | 2093042.32572 | 37.7273418615316 | -122.42719953383998 | (37.7273418615316, -122.42719953384) | |||
| 157021 | 157021 | 245987 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999858.6241 | 2108792.1061 | 37.7703321208314 | -122.44384602423 | (37.7703321208314, -122.44384602423) | |||
| 157085 | 157085 | 197085 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014468.858580001 | 2102236.49554 | 37.7531543746906 | -122.392850131521 | (37.7531543746906, -122.392850131521) | |||
| 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) | |||
| 157966 | 157966 | 136202 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1337 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004913.0684 | 2120534.02336 | 37.8028595013299 | -122.427199210075 | (37.8028595013299, -122.427199210075) | |||
| 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) | |
| 160941 | 160941 | 213952 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994769.73406 | 2090948.84155 | 37.72104740759529 | -122.460155454611 | (37.7210474075953, -122.460155454611) | |||
| 160970 | 160970 | 59713 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1981 12:00:00 AM | 7 | 3x3 | Permit Number 19144 | 6008363.54406 | 2115876.33125 | 37.790265156173504 | -122.414928901463 | (37.7902651561735, -122.414928901463) | |
| 162016 | 162016 | 138426 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003386.6856 | 2114488.2877 | 37.7861730275843 | -122.432049296465 | (37.7861730275843, -122.432049296465) | |||
| 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) | |||
| 165779 | 165779 | 240173 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 479 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008226.13214 | 2096616.22603 | 37.737373641567395 | -122.414041223846 | (37.7373736415674, -122.414041223846) | |||
| 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) | |||
| 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) | |
| 170258 | 170258 | 138546 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1640 SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001642.2543 | 2114139.7444 | 37.7851169644034 | -122.438059581246 | (37.7851169644034, -122.438059581246) | |||
| 171035 | 171035 | 179335 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1119 Athens St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6001959.57443 | 2087726.76645 | 37.7126112352992 | -122.435071996701 | (37.7126112352992, -122.435071996701) | |||
| 171068 | 171068 | 197090 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014474.311480001 | 2102148.65752 | 37.752913493081294 | -122.39282512948 | (37.7529134930813, -122.39282512948) | |||
| 171342 | 171342 | 69369 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3715 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33463 | 6002534.674819999 | 2121358.09542 | 37.804987398007704 | -122.43548864898099 | (37.8049873980077, -122.435488648981) | |
| 171603 | 171603 | 213948 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 300 Holloway Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995862.50546 | 2091234.8214599998 | 37.7218954350104 | -122.456398757109 | (37.7218954350104, -122.456398757109) | |||
| 172968 | 172968 | 39937 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 327 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50713 | 6009355.370709999 | 2088298.86848 | 37.7145992918994 | -122.40955005091499 | (37.7145992918994, -122.409550050915) | |
| 173762 | 173762 | 124412 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3900 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5996120.28006 | 2115251.26489 | 37.787853319856794 | -122.45724420279 | (37.7878533198568, -122.45724420279) | |||
| 173991 | 173991 | 179297 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Peru Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004358.252069999 | 2093034.47753 | 37.7273209621682 | -122.427159238819 | (37.7273209621682, -122.427159238819) | |||
| 175573 | 175573 | 142841 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1347 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6006737.9132 | 2115595.2008 | 37.7894017611933 | -122.42053351217 | (37.7894017611933, -122.42053351217) |
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");