Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15393 | 15393 | 11470 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6016849.3995 | 2095607.3792400002 | 37.7350841106266 | -122.38415605258001 | (37.7350841106266, -122.38415605258) | |||
| 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) | |||
| 14061 | 14061 | 24180 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6016621.33395 | 2095295.74377 | 37.7342158098126 | -122.384922860422 | (37.7342158098126, -122.384922860422) | |||
| 14210 | 14210 | 11472 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6016881.34744 | 2095602.56066 | 37.7350726460825 | -122.384045260583 | (37.7350726460825, -122.384045260583) | |||
| 99658 | 99658 | 23701 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2119X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005103.6033 | 2116867.2333400003 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | |||
| 18752 | 18752 | 10423 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1401 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5999371.8264 | 2108722.9096 | 37.7701143458549 | -122.44552487423 | (37.7701143458549, -122.44552487423) | |||
| 7365 | 7365 | 8095 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 762 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 04/14/1998 12:00:00 AM | 24 | 3X3 | 6004129.5547 | 2111522.3059 | 37.778071268059996 | -122.42926759287201 | (37.77807126806, -122.429267592872) | ||
| 112082 | 112082 | 9980 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 810X Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2011 12:00:00 AM | 24 | 3X3 | Permit Number 54082 | 6003050.1396073 | 2111037.6486225 | 37.7766793527515 | -122.432967039601 | (37.7766793527515, -122.432967039601) | |
| 8606 | 8606 | 8111 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 810 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/1993 12:00:00 AM | 20 | 3X3 | 6003847.5569 | 2111477.6208 | 37.7779326053256 | -122.430239935515 | (37.7779326053256, -122.430239935515) | ||
| 21940 | 21940 | 10478 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5998139.6149 | 2108553.6282 | 37.7695791194599 | -122.44977485921801 | (37.7695791194599, -122.449774859218) | |||
| 92348 | 92348 | 690 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 110499 | 110499 | 10443 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1501 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5998901.98983 | 2108638.08127 | 37.7698545950424 | -122.44714392128901 | (37.7698545950424, -122.447143921289) | |||
| 128988 | 128988 | 10416 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1399 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999442.73592 | 2108734.00442 | 37.7701488573322 | -122.44528039770799 | (37.7701488573322, -122.445280397708) | |||
| 152901 | 152901 | 239239 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Scott St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 6ft | 6002329.06188 | 2108869.34471 | 37.7706848027038 | -122.435306320439 | (37.7706848027038, -122.435306320439) | |||
| 5687 | 5687 | 8096 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 762 Fulton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 04/14/1998 12:00:00 AM | 18 | 3X3 | 6004110.3708 | 2111520.4613 | 37.7780651171853 | -122.429333825297 | (37.7780651171853, -122.429333825297) | ||
| 8100 | 8100 | 14763 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 983 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004471.7203 | 2111860.4178 | 37.7790190047533 | -122.42810802032601 | (37.7790190047533, -122.428108020326) | |||
| 9083 | 9083 | 10613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 34 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1993 12:00:00 AM | 18 | 3X3 | 6016953.501807599 | 2095595.9312573997 | 37.7350584319022 | -122.383795333225 | (37.7350584319022, -122.383795333225) | ||
| 19876 | 19876 | 10381 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1324 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X3 | 5999783.9663 | 2108832.8405 | 37.770439708466604 | -122.44410719203998 | (37.7704397084666, -122.44410719204) | |||
| 31491 | 31491 | 239296 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1114 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009989.84018 | 2102603.83852 | 37.753913217229 | -122.408365447707 | (37.753913217229, -122.408365447707) | |||
| 77437 | 77437 | 10379 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1316 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1990 12:00:00 AM | 18 | 3X3 | 5999827.9509 | 2108872.87214 | 37.7705521343685 | -122.44395792635001 | (37.7705521343685, -122.44395792635) | ||
| 97888 | 97888 | 8079 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 676 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/1998 12:00:00 AM | 18 | 3X3 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | ||
| 103525 | 103525 | 11173 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2717 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006873.7712695 | 2121594.1615236998 | 37.8058810553361 | -122.42048945327299 | (37.8058810553361, -122.420489453273) | |||
| 109838 | 109838 | 98274 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 766 Anderson St | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/23/2012 12:00:00 AM | 18 | Permit Number 768445 | 6007723.0 | 2095324.0 | 37.7337971999422 | -122.41568932106199 | (37.7337971999422, -122.415689321062) | |||
| 29245 | 29245 | 240195 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1787 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6004009.05897 | 2097810.30767 | 37.7404145605961 | -122.42870670406401 | (37.7404145605961, -122.428706704064) | |||
| 41009 | 41009 | 239260 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 455 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005530.51021 | 2101066.0904 | 37.7494401890135 | -122.42367754770001 | (37.7494401890135, -122.4236775477) | |||
| 166740 | 166740 | 239355 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 117 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6005097.05649 | 2098708.2685700003 | 37.7429416735155 | -122.425008707103 | (37.7429416735155, -122.425008707103) | |||
| 188385 | 188385 | 197096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 385 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6014371.98869 | 2105338.4156400003 | 37.7616661979483 | -122.39340218937099 | (37.7616661979483, -122.393402189371) | |||
| 24603 | 24603 | 239251 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3741 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005376.329919999 | 2100765.1364700003 | 37.748605134322794 | -122.42418930690901 | (37.7486051343228, -122.424189306909) | |||
| 44044 | 44044 | 197100 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 372 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6014303.71981 | 2105387.22588 | 37.7617964269902 | -122.393641721993 | (37.7617964269902, -122.393641721993) | |||
| 55551 | 55551 | 197118 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Texas St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6013784.73559 | 2105658.04133 | 37.7625111748734 | -122.39545566804199 | (37.7625111748734, -122.395455668042) | |||
| 62773 | 62773 | 213916 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1221 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5993897.35256 | 2107155.07888 | 37.7654954419723 | -122.46434702200199 | (37.7654954419723, -122.464347022002) | |||
| 144934 | 144934 | 24470 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 50X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 16 | 3x3 | 6006161.54315 | 2109606.56692 | 37.7729259368552 | -122.42210207116699 | (37.7729259368552, -122.422102071167) | ||
| 152686 | 152686 | 197117 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 315 Texas St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013789.951309999 | 2105605.10268 | 37.762366107038105 | -122.395433919764 | (37.7623661070381, -122.395433919764) | |||
| 169810 | 169810 | 239252 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3735 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005431.9472199995 | 2100770.05115 | 37.748621769087 | -122.42399733221501 | (37.748621769087, -122.423997332215) | |||
| 179989 | 179989 | 136255 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1422 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6006750.35587 | 2118407.27559 | 37.797123718848 | -122.42069017253999 | (37.797123718848, -122.42069017254) | |||
| 185363 | 185363 | 136204 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3898 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5996215.93738 | 2115261.69586 | 37.7878874538988 | -122.45691400297399 | (37.7878874538988, -122.456914002974) | |||
| 30852 | 30852 | 240192 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004287.41019 | 2098213.31975 | 37.7415368893219 | -122.42777298295401 | (37.7415368893219, -122.427772982954) | |||
| 35804 | 35804 | 239300 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 927 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009964.45155 | 2103786.9298 | 37.757160299531996 | -122.408536698407 | (37.757160299532, -122.408536698407) | |||
| 53135 | 53135 | 197099 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 361 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6014371.32039 | 2105439.78975 | 37.7619445120636 | -122.39341159536801 | (37.7619445120636, -122.393411595368) | |||
| 69560 | 69560 | 239354 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 187 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6004748.91753 | 2098687.71701 | 37.742865571999104 | -122.42621101343201 | (37.7428655719991, -122.426211013432) | |||
| 69666 | 69666 | 240194 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 48 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004261.63308 | 2097975.00788 | 37.7408810812017 | -122.42784513465901 | (37.7408810812017, -122.427845134659) | |||
| 70530 | 70530 | 73459 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 330 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 15 | 6010582.5171300005 | 2106716.25151 | 37.765238152235206 | -122.40660560128299 | (37.7652381522352, -122.406605601283) | ||
| 130140 | 130140 | 239310 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 460 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005491.5697099995 | 2101034.9456700003 | 37.7493524745442 | -122.42380999086001 | (37.7493524745442, -122.42380999086) | |||
| 148823 | 148823 | 99598 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3001 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 17057 | 6002874.08515 | 2118929.42484 | 37.7983381750246 | -122.434140356598 | (37.7983381750246, -122.434140356598) | |||
| 151351 | 151351 | 213953 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994770.431919999 | 2090973.1015700002 | 37.7211140599462 | -122.460154799032 | (37.7211140599462, -122.460154799032) | |||
| 159725 | 159725 | 213957 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994771.7805 | 2091087.8520099998 | 37.7214292147603 | -122.460158446674 | (37.7214292147603, -122.460158446674) | |||
| 163677 | 163677 | 239332 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3284 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009010.21186 | 2099567.25485 | 37.7455205280624 | -122.411538719955 | (37.7455205280624, -122.411538719955) | |||
| 165260 | 165260 | 54444 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 626 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 15 | Permit Number 10222 | 6014089.82372 | 2104201.41345 | 37.7585285559536 | -122.394298481614 | (37.7585285559536, -122.394298481614) | ||
| 166384 | 166384 | 239241 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6010653.63145 | 2101615.38344 | 37.7512362871225 | -122.406000261299 | (37.7512362871225, -122.406000261299) | |||
| 177196 | 177196 | 213954 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994772.0848 | 2091005.96515 | 37.721204390545104 | -122.460151465241 | (37.7212043905451, -122.460151465241) | |||
| 177889 | 177889 | 239322 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1682 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009287.32125 | 2099523.77754 | 37.7454166887246 | -122.410577445415 | (37.7454166887246, -122.410577445415) | |||
| 186231 | 186231 | 239333 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3258 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009001.08587 | 2099726.03471 | 37.7459559905813 | -122.411581492612 | (37.7459559905813, -122.411581492612) | |||
| 188403 | 188403 | 239243 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 4 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6010651.8200900005 | 2101663.18223 | 37.751367430767395 | -122.40600989216101 | (37.7513674307674, -122.406009892161) | |||
| 14406 | 14406 | 120561 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 245 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6014054.5814 | 2105863.37396 | 37.7630899785332 | -122.394536741704 | (37.7630899785332, -122.394536741704) | |||
| 37414 | 37414 | 239253 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3715 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005658.48797 | 2100784.3269 | 37.7486737543928 | -122.42321497059099 | (37.7486737543928, -122.423214970591) | |||
| 52692 | 52692 | 240154 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 568 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998646.15561 | 2105899.30537 | 37.76231998711071 | -122.44783164083799 | (37.7623199871107, -122.447831640838) | |||
| 54939 | 54939 | 42167 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 14 | Permit Number 42460 | 6012577.4664 | 2111216.9324 | 37.7777074143023 | -122.400021595319 | (37.7777074143023, -122.400021595319) | ||
| 66368 | 66368 | 213958 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5994774.32905 | 2091126.87145 | 37.721536499390105 | -122.460152462564 | (37.7215364993901, -122.460152462564) | |||
| 78871 | 78871 | 102179 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 4354 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002056.0 | 2104132.0 | 37.7576617009806 | -122.435911822312 | (37.7576617009806, -122.435911822312) | |||
| 79899 | 79899 | 239331 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3265 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009040.25236 | 2099669.18 | 37.7458020770125 | -122.411442043712 | (37.7458020770125, -122.411442043712) | |||
| 108092 | 108092 | 61119 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1120 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1983 12:00:00 AM | 14 | 3x3 | Permit Number 20967 | 6007612.89522655 | 2103123.90329719 | 37.7552078032974 | -122.416622341764 | (37.7552078032974, -122.416622341764) | |
| 130889 | 130889 | 68778 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2020 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1993 12:00:00 AM | 14 | 3x3 | Permit Number 32708 | 6006907.41923 | 2118207.98167 | 37.796585358595294 | -122.420132542485 | (37.7965853585953, -122.420132542485) | |
| 131782 | 131782 | 179284 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 721 Goettingen St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 6010763.30464 | 2091319.72205 | 37.7229727292859 | -122.404896194231 | (37.7229727292859, -122.404896194231) | |||
| 133160 | 133160 | 239292 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 900 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009918.7268199995 | 2103885.22613 | 37.7574276383036 | -122.40870176718799 | (37.7574276383036, -122.408701767188) | |||
| 149069 | 149069 | 240177 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 431 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008245.857419999 | 2096810.19574 | 37.7379073478479 | -122.41398674200799 | (37.7379073478479, -122.413986742008) | |||
| 157156 | 157156 | 239261 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1400 Utah St | 5 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6010855.2107 | 2101671.833 | 37.751402557405896 | -122.405307149322 | (37.7514025574059, -122.405307149322) | |||
| 158817 | 158817 | 61793 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2104 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1985 12:00:00 AM | 14 | Permit Number 21816 | 6012153.01638 | 2102841.4950099997 | 37.7546866683749 | -122.40090132743201 | (37.7546866683749, -122.400901327432) | |
| 173537 | 173537 | 197097 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 379 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6014372.8543300005 | 2105361.9972099997 | 37.7617309959041 | -122.39340084578001 | (37.7617309959041, -122.39340084578) | |||
| 183206 | 183206 | 197098 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 373 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6014370.26401 | 2105387.58342 | 37.761801106151204 | -122.393411595362 | (37.7618011061512, -122.393411595362) | |||
| 8758 | 8758 | 7287 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1850 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6003043.7765 | 2114538.1757 | 37.786290560678204 | -122.433239236497 | (37.7862905606782, -122.433239236497) | |||
| 25779 | 25779 | 32030 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3321 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 13 | Permit Number 35417 | 6004551.31558 | 2106568.33958 | 37.764492746462395 | -122.42745555912701 | (37.7644927464624, -122.427455559127) | ||
| 28648 | 28648 | 213960 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994774.81066 | 2091163.6355700002 | 37.7216374725616 | -122.460153459937 | (37.7216374725616, -122.460153459937) | |||
| 36604 | 36604 | 213973 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995027.24606 | 2091045.4090900002 | 37.721327367434604 | -122.459272306869 | (37.7213273674346, -122.459272306869) | |||
| 63227 | 63227 | 136249 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1717 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008299.50959 | 2118376.18019 | 37.797125527381894 | -122.41532749988701 | (37.7971255273819, -122.415327499887) | |||
| 67268 | 67268 | 197120 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6014065.797040001 | 2105649.96536 | 37.7625046287026 | -122.394483006312 | (37.7625046287026, -122.394483006312) | |||
| 74006 | 74006 | 179305 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 226 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003843.99427 | 2092374.03152 | 37.7254784293655 | -122.42888996161899 | (37.7254784293655, -122.428889961619) | |||
| 75783 | 75783 | 213912 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1235 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995137.8838599995 | 2107141.32964 | 37.7655291179984 | -122.460055338482 | (37.7655291179984, -122.460055338482) | |||
| 93193 | 93193 | 69368 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3636 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 13 | Permit Number 33462 | 6002615.01621 | 2121133.0987299997 | 37.8043741790738 | -122.43519451581999 | (37.8043741790738, -122.43519451582) | |
| 148148 | 148148 | 239334 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3206 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008990.25346 | 2099948.20272 | 37.7465654071644 | -122.411634644342 | (37.7465654071644, -122.411634644342) | |||
| 148808 | 148808 | 136271 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 240 Joice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010208.66727 | 2117064.18713 | 37.7936302286056 | -122.40862871256701 | (37.7936302286056, -122.408628712567) | |||
| 158714 | 158714 | 35136 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 714 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 13 | Permit Number 38666 | 6002360.3768 | 2089504.48193 | 37.7175152006551 | -122.43381368236 | (37.7175152006551, -122.43381368236) | |
| 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) | |||
| 169247 | 169247 | 239359 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6003915.03036 | 2100651.96891 | 37.7482117843565 | -122.42923439386699 | (37.7482117843565, -122.429234393867) | |||
| 171428 | 171428 | 197068 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 430 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010884.7435 | 2106309.51664 | 37.764138254402596 | -122.405531618298 | (37.7641382544026, -122.405531618298) | |||
| 173165 | 173165 | 239337 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1534 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009307.10914 | 2100388.95638 | 37.7477933882533 | -122.410570106037 | (37.7477933882533, -122.410570106037) | |||
| 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) | |||
| 176731 | 176731 | 197101 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 37 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6012884.97292 | 2106850.1929599997 | 37.7657344728051 | -122.398651302829 | (37.7657344728051, -122.398651302829) | |||
| 178520 | 178520 | 197119 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 309 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6014067.1485 | 2105627.53504 | 37.7624431150761 | -122.394476761399 | (37.7624431150761, -122.394476761399) | |||
| 180069 | 180069 | 136226 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1570 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004327.39771 | 2120155.21272 | 37.8017862476969 | -122.429198904827 | (37.8017862476969, -122.429198904827) | |||
| 184376 | 184376 | 239329 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3215 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009024.67189 | 2099961.90595 | 37.746604963844206 | -122.411516596636 | (37.7466049638442, -122.411516596636) | |||
| 5596 | 5596 | 7325 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2027 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002881.7283 | 2115306.8957 | 37.7883920762372 | -122.433854846414 | (37.7883920762372, -122.433854846414) | |||
| 6336 | 6336 | 7291 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1899X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6002969.1284 | 2114733.7648 | 37.7868233637677 | -122.433511482074 | (37.7868233637677, -122.433511482074) | |||
| 7823 | 7823 | 7319 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2011 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002893.06 | 2115234.5275 | 37.7881940146245 | -122.433810466039 | (37.7881940146245, -122.433810466039) | |||
| 9296 | 9296 | 11461 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 41X HAWKINS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1992 12:00:00 AM | 12 | 3X3 | 6016935.0 | 2095578.0 | 37.7350081734808 | -122.38385805308201 | (37.7350081734808, -122.383858053082) | ||
| 9522 | 9522 | 7294 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003037.0806 | 2114087.5866 | 37.7850529772079 | -122.43323019463499 | (37.7850529772079, -122.433230194635) | |||
| 13371 | 13371 | 24145 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016696.89665 | 2095171.76192 | 37.7338795595807 | -122.384652980151 | (37.7338795595807, -122.384652980151) | |||
| 13407 | 13407 | 16508 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 325 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016639.93914 | 2098306.03692 | 37.7424824967653 | -122.385068203435 | (37.7424824967653, -122.385068203435) | |||
| 14904 | 14904 | 24147 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016689.05107 | 2095205.54183 | 37.7339718785836 | -122.384682457242 | (37.7339718785836, -122.384682457242) | |||
| 14937 | 14937 | 16560 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 702X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1992 12:00:00 AM | 12 | 3X3 | 6015615.61867 | 2097370.07413 | 37.7398558207833 | -122.38854471268299 | (37.7398558207833, -122.388544712683) | ||
| 15041 | 15041 | 24179 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1990 12:00:00 AM | 12 | 5x3 | 6016625.58798 | 2095312.02915 | 37.7342607615082 | -122.38490928693199 | (37.7342607615082, -122.384909286932) |
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");