Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 665 | 665 | 239151 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Octavia St | 2 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:58:00 PM | 3 | Width 4ft | 6005731.03459 | 2109700.90805 | 37.7731606839629 | -122.423597962203 | (37.7731606839629, -122.423597962203) | ||
| 1093 | 1093 | 244319 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 331 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2017 04:00:00 PM | 3 | Width 0ft | 6005497.6412 | 2110517.1934 | 37.7753888290162 | -122.424463374134 | (37.7753888290162, -122.424463374134) | ||
| 1366 | 1366 | 81793 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.42359327476801 | (37.7767477786156, -122.423593274768) | |
| 3810 | 3810 | 193325 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015584.15702 | 2102639.39931 | 37.754322548171395 | -122.389021302106 | (37.7543225481714, -122.389021302106) | |||
| 4050 | 4050 | 159297 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 120 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:53:00 PM | 3 | Width 0ft | 5998096.339240001 | 2087362.0634299999 | 37.711389721237104 | -122.448398243388 | (37.7113897212371, -122.448398243388) | ||
| 4061 | 4061 | 252970 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 12:21:00 PM | 3 | ||||||||
| 4111 | 4111 | 159295 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 118 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:16:00 PM | 3 | Width 0ft | 5998136.03876 | 2087321.1199900003 | 37.7112795695727 | -122.448258085851 | (37.7112795695727, -122.448258085851) | ||
| 4615 | 4615 | 137866 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2044 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/03/2012 12:00:00 AM | 1 | Width 0ft | 6002931.7599 | 2115390.6101 | 37.7886247736431 | -122.43368773072201 | (37.7886247736431, -122.433687730722) | ||
| 5575 | 5575 | 105537 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2192 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6002561.80287 | 2118173.8704 | 37.796245890587 | -122.435166876954 | (37.796245890587, -122.435166876954) | |||
| 5860 | 5860 | 21732 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1961 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1997 12:00:00 AM | 3 | 3X3 | 6003208.5585 | 2114462.4267 | 37.78609191954679 | -122.432663720821 | (37.7860919195468, -122.432663720821) | ||
| 5925 | 5925 | 95365 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 661 Broadway | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 778058 | 6010478.0762 | 2118518.1883 | 37.797637647796996 | -122.40779910526899 | (37.797637647797, -122.407799105269) | ||
| 6169 | 6169 | 94205 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 225 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 3 | 4 diameter | Permit Number 53606 | 6012323.95366 | 2116081.4267 | 37.791050043982295 | -122.40124050766501 | (37.7910500439823, -122.401240507665) | |
| 6751 | 6751 | 137889 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2034 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002935.6901 | 2115351.8703 | 37.7885186270288 | -122.433671363006 | (37.7885186270288, -122.433671363006) | ||||
| 6898 | 6898 | 2436 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 740 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1999 12:00:00 AM | 3 | 3X3 | 6004500.111269999 | 2111079.2700799997 | 37.7768757716325 | -122.427954126177 | (37.7768757716325, -122.427954126177) | ||
| 7900 | 7900 | 4617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 348 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 10 | 3x3 | 6010597.9091 | 2118822.5443 | 37.7984800429378 | -122.40740591699 | (37.7984800429378, -122.40740591699) | ||
| 8596 | 8596 | 115210 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 115 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5997031.37665 | 2115893.5791 | 37.789669227607604 | -122.45413840466298 | (37.7896692276076, -122.454138404663) | |||
| 8801 | 8801 | 94278 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 850@Golden Gate Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6001005.8896 | 2111653.4167 | 37.7782539328231 | -122.440082850024 | (37.7782539328231, -122.440082850024) | ||||
| 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 | |||||||||
| 9255 | 9255 | 24072 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 161X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016395.7853594 | 2095946.5828375 | 37.735990405317004 | -122.385748008424 | (37.735990405317, -122.385748008424) | ||
| 13142 | 13142 | 27250 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 747 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6006299.28886 | 2093605.00165 | 37.728997072755206 | -122.420489547272 | (37.7289970727552, -122.420489547272) | |||
| 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 | ||||||||
| 14147 | 14147 | 11467 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 8 | 3X3 | 6016799.4589 | 2095596.1573400002 | 37.7350505362442 | -122.384327935502 | (37.7350505362442, -122.384327935502) | ||
| 14424 | 14424 | 6845 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 595X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 6 | 3x3 | 6015936.9719 | 2097716.00593 | 37.7408234823092 | -122.38745772460899 | (37.7408234823092, -122.387457724609) | ||
| 14701 | 14701 | 11464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016788.858519999 | 2095545.6720200002 | 37.734911327499205 | -122.384361070118 | (37.7349113274992, -122.384361070118) | ||
| 14888 | 14888 | 24090 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 125X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1997 12:00:00 AM | 6 | 3x3 | 6016342.364159999 | 2095991.2568 | 37.736110114791 | -122.3859358217 | (37.736110114791, -122.3859358217) | ||
| 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) | ||
| 15334 | 15334 | 30635 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008075.6555 | 2108643.1391 | 37.770388364567104 | -122.41541268929899 | (37.7703883645671, -122.415412689299) | |
| 16295 | 16295 | 27141 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1775 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011398.088769999 | 2095346.30396 | 37.7340643486912 | -122.402984937921 | (37.7340643486912, -122.402984937921) | |||
| 16642 | 16642 | 85639 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1201X Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017307.7565 | 2093058.1427 | 37.7281097410693 | -122.382394026885 | (37.7281097410693, -122.382394026885) | ||
| 17097 | 17097 | 15580 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1998 12:00:00 AM | 6 | 3X3 | 6006815.4591 | 2099977.9757 | 37.746524922000205 | -122.41915697739401 | (37.7465249220002, -122.419156977394) | ||
| 18626 | 18626 | 5933 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1355 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/1990 12:00:00 AM | 3 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | ||
| 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) | |||
| 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) | |
| 19275 | 19275 | 34240 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | |||
| 19725 | 19725 | 114507 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 10 LOMBARD ST | 2 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 23259 | 23259 | 8115 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 830 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/1991 12:00:00 AM | 6 | 3X3 | 6003771.0154 | 2111470.5456 | 37.7779088429261 | -122.430504214514 | (37.7779088429261, -122.430504214514) | ||
| 24461 | 24461 | 138424 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003330.8547 | 2114478.3784 | 37.786142653739 | -122.432241748584 | (37.786142653739, -122.432241748584) | |||
| 25838 | 25838 | 75303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.40656607695699 | (37.7648621726769, -122.406566076957) | ||
| 26202 | 26202 | 239326 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009380.8265 | 2099841.0915200002 | 37.746293204883706 | -122.41027651786001 | (37.7462932048837, -122.41027651786) | |||
| 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) | |||
| 27334 | 27334 | 240136 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 277 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004700.17371 | 2100146.19558 | 37.7468674642611 | -122.426483383002 | (37.7468674642611, -122.426483383002) | |||
| 28069 | 28069 | 239272 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007373.32106 | 2107298.89674 | 37.7666578912871 | -122.417746775107 | (37.7666578912871, -122.417746775107) | |||
| 28124 | 28124 | 239362 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1400 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003888.14228 | 2100073.30368 | 37.7466213818866 | -122.429286114783 | (37.7466213818866, -122.429286114783) | |||
| 28183 | 28183 | 246963 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 238 Noe St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6002871.51875 | 2106887.2406200003 | 37.765273220394796 | -122.433288301134 | (37.7652732203948, -122.433288301134) | |||
| 28239 | 28239 | 120254 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5988369.36546 | 2114920.76145 | 37.7864976459369 | -122.4840363573 | (37.7864976459369, -122.4840363573) | |||
| 28416 | 28416 | 99761 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 4212 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 4212-4216 25th St (4214 is visible address) | 6002485.0 | 2101232.0 | 37.749723353108294 | -122.434220849449 | (37.7497233531083, -122.434220849449) | |||
| 28556 | 28556 | 136259 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2110 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007679.1852400005 | 2119665.2919900003 | 37.800630222272794 | -122.417565392635 | (37.8006302222728, -122.417565392635) | |||
| 28850 | 28850 | 110361 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6008381.52689 | 2115877.48528 | 37.790269335318996 | -122.41486676369699 | (37.790269335319, -122.414866763697) | ||||
| 29146 | 29146 | 179293 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 180 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004018.855 | 2092658.23186 | 37.7262686762461 | -122.428305729646 | (37.7262686762461, -122.428305729646) | |||
| 29246 | 29246 | 138000 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1932 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002970.878 | 2115057.2879 | 37.78771177526961 | -122.433528557906 | (37.7877117752696, -122.433528557906) | |||
| 30190 | 30190 | 136213 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 107 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997027.70911 | 2115921.73522 | 37.78974632646779 | -122.45415312837099 | (37.7897463264678, -122.454153128371) | |||
| 30243 | 30243 | 138452 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002940.8815 | 2114925.0507 | 37.7873469835854 | -122.433622885577 | (37.7873469835854, -122.433622885577) | |||
| 30274 | 30274 | 239311 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 464 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005494.12674 | 2100990.71225 | 37.7492311640921 | -122.423798003785 | (37.7492311640921, -122.423798003785) | |||
| 32871 | 32871 | 74007 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2030 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 8 | 6012344.40813 | 2102849.33443 | 37.754718867688105 | -122.40023998938999 | (37.7547188676881, -122.40023998939) | ||
| 33676 | 33676 | 136238 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1378 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007522.032000001 | 2117818.3708599997 | 37.7955501948379 | -122.41797820753901 | (37.7955501948379, -122.417978207539) | |||
| 35501 | 35501 | 197166 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017812.186480001 | 2093598.1535200002 | 37.729620355985205 | -122.380687698389 | (37.7296203559852, -122.380687698389) | |||
| 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) | |||
| 35976 | 35976 | 181801 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1919 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986905.9682 | 2099586.0566 | 37.744307492185 | -122.487972126615 | (37.744307492185, -122.487972126615) | |||
| 36006 | 36006 | 246059 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 602 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997560.3028 | 2108454.9059 | 37.76927489165771 | -122.451771545977 | (37.7692748916577, -122.451771545977) | |||
| 36094 | 36094 | 136210 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3501 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997980.46007 | 2115787.2108299998 | 37.7894315448801 | -122.450847014574 | (37.7894315448801, -122.450847014574) | |||
| 37187 | 37187 | 179321 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6 Merrill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009462.15792 | 2094931.0044 | 37.732815729946 | -122.409648778469 | (37.732815729946, -122.409648778469) | |||
| 37696 | 37696 | 32199 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1516 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 9 | Permit Number 35524 | 6009302.4465 | 2100450.1305 | 37.7479610974423 | -122.410590548539 | (37.7479610974423, -122.410590548539) | ||
| 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) | |||
| 38106 | 38106 | 142044 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005880.5674 | 2111021.3015 | 37.7767946045442 | -122.423174581774 | (37.7767946045442, -122.423174581774) | |||
| 38610 | 38610 | 213996 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 146 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999758.63525 | 2094089.70358 | 37.7299571835696 | -122.44313580558399 | (37.7299571835696, -122.443135805584) | |||
| 39309 | 39309 | 70680 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 330 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 10 | 6010584.43859 | 2106698.38492 | 37.7651892021367 | -122.406597696229 | (37.7651892021367, -122.406597696229) | ||
| 39644 | 39644 | 121918 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 434 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5990628.47281 | 2112418.69115 | 37.7797589204997 | -122.47603768167 | (37.7797589204997, -122.47603768167) | |||
| 40729 | 40729 | 136253 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 802 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006835.20454 | 2121555.13749 | 37.805771731842704 | -122.420620147698 | (37.8057717318427, -122.420620147698) | |||
| 40908 | 40908 | 197109 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012049.36164 | 2105557.39202 | 37.7621381396801 | -122.401450654931 | (37.7621381396801, -122.401450654931) | ||||
| 41805 | 41805 | 81939 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1567 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50642 | 6006641.29456006 | 2117646.14573466 | 37.7950276999422 | -122.421013482861 | (37.7950276999422, -122.421013482861) | ||
| 42701 | 42701 | 136231 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 828 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009179.0642099995 | 2115849.5687700002 | 37.790237464224894 | -122.412105358482 | (37.7902374642249, -122.412105358482) | |||
| 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) | |||
| 44437 | 44437 | 120251 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 160 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5988366.40775 | 2114885.43189 | 37.7864004688283 | -122.48404399839899 | (37.7864004688283, -122.484043998399) | |||
| 45516 | 45516 | 117917 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5983194.46177 | 2110567.54263 | 37.7742423451733 | -122.501617774429 | (37.7742423451733, -122.501617774429) | |||
| 45950 | 45950 | 197160 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Mabrey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016488.26571 | 2095902.24457 | 37.7358737783612 | -122.385425174944 | (37.7358737783612, -122.385425174944) | |||
| 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) | |||
| 46752 | 46752 | 121094 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1697 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 3x3 | 6001082.7006 | 2111393.2018 | 37.777543821113206 | -122.43979847194099 | (37.7775438211132, -122.439798471941) | ||
| 46947 | 46947 | 117046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2205x Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6002022.6426 | 2114300.8047 | 37.785580820217206 | -122.436755092227 | (37.7855808202172, -122.436755092227) | |||
| 47443 | 47443 | 96053 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 130 Coso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659.0 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | |
| 47463 | 47463 | 70412 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1817 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 4 | 6005464.04095 | 2092680.05814 | 37.7264102753879 | -122.423311341054 | (37.7264102753879, -122.423311341054) | ||
| 48100 | 48100 | 138937 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 609 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004415.7448 | 2111001.1974 | 37.7766566299655 | -122.42824040995899 | (37.7766566299655, -122.428240409959) | |||
| 48558 | 48558 | 31312 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 709 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | Permit Number 34949 | 6004473.77987727 | 2110903.29372292 | 37.77639109406471 | -122.428032671161 | (37.7763910940647, -122.428032671161) | |||
| 48788 | 48788 | 138074 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1900 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6002997.6045 | 2114890.8811 | 37.7872563808289 | -122.43342419332 | (37.7872563808289, -122.43342419332) | |||
| 48839 | 48839 | 139996 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 450 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005498.1729999995 | 2111711.6583 | 37.77866856873 | -122.42454651845101 | (37.77866856873, -122.424546518451) | |||
| 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) | |||
| 52223 | 52223 | 48664 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1715REVISED Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 2 | Permit Number 45950 | 6004825.1941 | 2115340.0212 | 37.788593123793504 | -122.427133123433 | (37.7885931237935, -122.427133123433) | |
| 52547 | 52547 | 136233 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 928 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008241.15126 | 2115615.72807 | 37.789542725373295 | -122.415333916531 | (37.7895427253733, -122.415333916531) | |||
| 53362 | 53362 | 136246 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1723 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006533.72276 | 2116650.00017 | 37.7922864687885 | -122.421314924346 | (37.7922864687885, -122.421314924346) | |||
| 53492 | 53492 | 75980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6555 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1989 12:00:00 AM | 3 | 5986643.29892 | 2112486.62546 | 37.7797135654944 | -122.48982895296699 | (37.7797135654944, -122.489828952967) | ||
| 53523 | 53523 | 48812 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.053730001 | 2102353.10418 | 37.753474456898104 | -122.392864530587 | (37.7534744568981, -122.392864530587) | ||
| 53887 | 53887 | 239257 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3425 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006952.16966 | 2100856.77696 | 37.748945609549104 | -122.41874655860501 | (37.7489456095491, -122.418746558605) | |||
| 54424 | 54424 | 197151 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 99 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6016637.91847 | 2095129.63156 | 37.7337606161438 | -122.384853953468 | (37.7337606161438, -122.384853953468) | |||
| 54454 | 54454 | 239342 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 249 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010242.3381900005 | 2100031.5164900003 | 37.7468643247282 | -122.40731092156 | (37.7468643247282, -122.40731092156) | |||
| 54566 | 54566 | 141886 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1355 EDDY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004027.64 | 2112849.1164 | 37.7817085903995 | -122.429714809344 | (37.7817085903995, -122.429714809344) | |||
| 55248 | 55248 | 197103 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014438.05571 | 2102040.91433 | 37.7526156394141 | -122.392942972153 | (37.7526156394141, -122.392942972153) | |||
| 55899 | 55899 | 239259 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 455 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005530.597 | 2101040.15381 | 37.749368977999 | -122.423675403717 | (37.749368977999, -122.423675403717) | |||
| 56000 | 56000 | 30618 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1645 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 5 | Permit Number 34580 | 6008139.305 | 2108622.0896 | 37.7703341448356 | -122.41519103466601 | (37.7703341448356, -122.415191034666) | |
| 56227 | 56227 | 197135 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015262.92854 | 2096819.7411099998 | 37.738325167482294 | -122.389725749154 | (37.7383251674823, -122.389725749154) | |||
| 56367 | 56367 | 52632 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1725@ POLK Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | 6 | Permit Number 48716 | 6006419.56903 | 2116963.2187099997 | 37.793140052215705 | -122.421732156715 | (37.7931400522157, -122.421732156715) | ||
| 56438 | 56438 | 137615 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2256 Turk Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999208.8698 | 2111896.2343 | 37.7788181803478 | -122.446316850598 | (37.7788181803478, -122.446316850598) |
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");