Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58478 | 58478 | 240187 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 84 Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004879.89291 | 2097658.89878 | 37.7400480733545 | -122.425684927129 | (37.7400480733545, -122.425684927129) | |||
| 44512 | 44512 | 38662 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 834 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40585 | 6001015.5346 | 2111586.9168 | 37.778071890037 | -122.440044714881 | (37.778071890037, -122.440044714881) |
| 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) | ||
| 96831 | 96831 | 94879 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 83 Ledyard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767655 | 6011819.0 | 2094865.0 | 37.7327662839989 | -122.40149589318399 | (37.7327662839989, -122.401495893184) |
| 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) | |||
| 66176 | 66176 | 62995 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 828 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1986 12:00:00 AM | 11 | Permit Number 23397 | 6009184.70363 | 2115820.64878 | 37.7901583733657 | -122.412083801744 | (37.7901583733657, -122.412083801744) | ||
| 23839 | 23839 | 239303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 827 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009943.30832 | 2104181.7840400003 | 37.7582432964097 | -122.408637674287 | (37.7582432964097, -122.408637674287) | |||
| 95367 | 95367 | 63519 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 827 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24129 | 6009937.41426671 | 2104399.10208054 | 37.758839672708795 | -122.40867338931001 | (37.7588396727088, -122.40867338931) | ||
| 76559 | 76559 | 239304 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 821 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009936.73456 | 2104250.32887 | 37.758431136907795 | -122.40866524479901 | (37.7584311369078, -122.408665244799) | |||
| 82307 | 82307 | 63520 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 821 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24130 | 6009935.53523311 | 2104433.5559768 | 37.758934170103394 | -122.408682318494 | (37.7589341701034, -122.408682318494) | ||
| 136005 | 136005 | 58814 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 821 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51604 | 6009972.6793599995 | 2116102.82719 | 37.7909773472645 | -122.40937737748101 | (37.7909773472645, -122.409377377481) | |
| 171230 | 171230 | 139289 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 818 STEINER ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 6003024.4912 | 2111210.2718 | 37.777151878241206 | -122.433068101317 | (37.7771518782412, -122.433068101317) | |||
| 3392 | 3392 | 7175 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 814 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 6 | 3X3 | 6003515.4229999995 | 2111193.7442 | 37.7771343327183 | -122.43136863367201 | (37.7771343327183, -122.431368633672) | ||
| 106029 | 106029 | 9979 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 810X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2011 12:00:00 AM | 12 | 3X3 | Permit Number 54081 | 6003050.1396073 | 2111037.6486225 | 37.7766793527515 | -122.432967039601 | (37.7766793527515, -122.432967039601) | |
| 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) | ||
| 140172 | 140172 | 8112 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 810 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 1 | 3X3 | 6003674.72306 | 2111615.24723 | 37.778300702455894 | -122.430847652747 | (37.7783007024559, -122.430847652747) | ||
| 132617 | 132617 | 240206 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 81 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003903.54766 | 2097252.3303400003 | 37.7388765103369 | -122.429031747817 | (37.7388765103369, -122.429031747817) | |||
| 145070 | 145070 | 55270 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 809 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32396 | 5992382.44974981 | 2102648.13821757 | 37.7530331280839 | -122.46925861560499 | (37.7530331280839, -122.469258615605) | ||
| 114519 | 114519 | 67036 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 806 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1992 12:00:00 AM | Permit Number 30411 | 6002415.24936591 | 2103509.46105144 | 37.7559727598381 | -122.434624878851 | (37.7559727598381, -122.434624878851) | ||
| 158844 | 158844 | 136254 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 804 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006813.5477 | 2121550.30022 | 37.8057572293748 | -122.420694750958 | (37.8057572293748, -122.420694750958) | |||
| 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) | |||
| 60462 | 60462 | 136252 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 802 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006854.74284 | 2121556.7809200003 | 37.8057773454026 | -122.420552649091 | (37.8057773454026, -122.420552649091) | |||
| 119585 | 119585 | 109440 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 800x STEINER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 6.5x3.5 | 6003118.0 | 2111045.0 | 37.7767033866571 | -122.432732815988 | (37.7767033866571, -122.432732815988) | ||
| 143152 | 143152 | 109439 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 800x STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3.5x6.5 | 6003118.0 | 2111045.0 | 37.7767033866571 | -122.432732815988 | (37.7767033866571, -122.432732815988) | ||
| 120810 | 120810 | 16331 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 800X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5996797.9550648 | 2094752.6454838002 | 37.7316082025531 | -122.453419021963 | (37.7316082025531, -122.453419021963) | ||
| 160304 | 160304 | 247591 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 800 Tompkins Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6008974.65943 | 2096434.5209700002 | 37.736916732029705 | -122.411440373668 | (37.7369167320297, -122.411440373668) | ||||
| 103836 | 103836 | 63867 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 800 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24570 | 6004993.54117194 | 2103694.96994211 | 37.756628154728496 | -122.42572149078899 | (37.7566281547285, -122.425721490789) | ||
| 88760 | 88760 | 18652 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 80 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 6017340.7956251 | 2096041.6846083999 | 37.7363037832445 | -122.38248731128701 | (37.7363037832445, -122.382487311287) | |||
| 652 | 652 | 237023 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:44:00 PM | 3 | Width 6ft | 6005765.01716 | 2109438.39176 | 37.7724417955802 | -122.423461745458 | (37.7724417955802, -122.423461745458) | ||
| 661 | 661 | 237024 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 5 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:48:00 PM | 3 | Width 6ft | 6005763.84021 | 2109451.72322 | 37.772478334130994 | -122.423466764586 | (37.772478334131, -122.423466764586) | ||
| 663 | 663 | 237022 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 3 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:40:00 PM | 3 | Width 6ft | 6005770.133230001 | 2109412.50366 | 37.772371001847 | -122.423442207693 | (37.772371001847, -122.423442207693) | ||
| 666 | 666 | 237028 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 9 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:55:00 PM | 3 | Width 6ft | 6005756.39315 | 2109517.28856 | 37.7726579404383 | -122.423497186858 | (37.7726579404383, -122.423497186858) | ||
| 146886 | 146886 | 213924 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996368.87449 | 2106798.1483400003 | 37.7646575544173 | -122.455772834368 | (37.7646575544173, -122.455772834368) | |||
| 150197 | 150197 | 239308 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6005350.87512 | 2103602.95194 | 37.756395680627996 | -122.42447915479099 | (37.756395680628, -122.424479154791) | |||
| 173902 | 173902 | 239309 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6005351.1495900005 | 2103566.74632 | 37.7562962839536 | -122.42447563036801 | (37.7562962839536, -122.424475630368) | |||
| 153252 | 153252 | 246026 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998207.6 | 2108524.1023 | 37.7695019383238 | -122.44953757446899 | (37.7695019383238, -122.449537574469) | |||
| 9202 | 9202 | 1709 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 7X Bass Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2006 12:00:00 AM | 5 | 3x3 | 6016610.521033701 | 2095134.7434862 | 37.7337731370994 | -122.384949031469 | (37.7337731370994, -122.384949031469) | ||
| 80017 | 80017 | 8107 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 785 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 3 | 4X4 | 6004040.717119999 | 2111448.77193 | 37.7778643322695 | -122.429569668288 | (37.7778643322695, -122.429569668288) | ||
| 112178 | 112178 | 8108 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 785 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 4 | 3X3 | 6004054.06089 | 2111452.3407900003 | 37.777874887005 | -122.429523762111 | (37.777874887005, -122.429523762111) | ||
| 57706 | 57706 | 139268 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 785 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004071.3646 | 2111459.6159 | 37.7778958423736 | -122.429464421477 | (37.7778958423736, -122.429464421477) | |||
| 147329 | 147329 | 139267 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 785 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004042.8897 | 2111456.1989 | 37.7778848479076 | -122.42956268238501 | (37.7778848479076, -122.429562682385) | |||
| 132038 | 132038 | 239321 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 78 Norwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6008940.36814 | 2099480.93118 | 37.74527958439511 | -122.411774130991 | (37.7452795843951, -122.411774130991) | ||||
| 118962 | 118962 | 51439 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 779 Andover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47759 | 6007378.77949872 | 2095187.90508456 | 37.7334041569913 | -122.416869758383 | (37.7334041569913, -122.416869758383) | |||
| 123178 | 123178 | 51440 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 779 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47759 | 6007378.77949872 | 2095187.90508456 | 37.7334041569913 | -122.416869758383 | (37.7334041569913, -122.416869758383) | |||
| 136565 | 136565 | 123226 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 774 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993220.36068 | 2110224.45324 | 37.773884082118705 | -122.46691172095899 | (37.7738840821187, -122.466911720959) | |||
| 160765 | 160765 | 68930 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 768 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | Permit Number 32914 | 5993218.422259999 | 2110247.19429 | 37.7739464110699 | -122.466920079783 | (37.7739464110699, -122.466920079783) | |
| 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) | |||
| 180005 | 180005 | 72279 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 6 | 5983194.45467 | 2110583.80622 | 37.7742869998631 | -122.501619002427 | (37.7742869998631, -122.501619002427) | ||
| 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) | |||
| 109687 | 109687 | 8099 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 765 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 8 | 3X3 | 6004167.348119999 | 2111468.4499 | 37.7779255322683 | -122.429133010837 | (37.7779255322683, -122.429133010837) | ||
| 111645 | 111645 | 8098 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 765 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 6 | 3X3 | 6004145.13907 | 2111463.64591 | 37.7779110844604 | -122.42920949713002 | (37.7779110844604, -122.42920949713) | ||
| 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) | ||
| 34718 | 34718 | 139271 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 765 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004149.5758 | 2111471.3855 | 37.7779325866279 | -122.42919470092698 | (37.7779325866279, -122.429194700927) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 74659 | 74659 | 240186 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 76 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004876.9244 | 2097755.23098 | 37.740312411980206 | -122.425702045734 | (37.7403124119802, -122.425702045734) | |||
| 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) | |
| 94770 | 94770 | 8084 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6004115.11785 | 2111289.80956 | 37.7774320731857 | -122.429300951982 | (37.7774320731857, -122.429300951982) | ||
| 96942 | 96942 | 8083 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 6 | 3X3 | 6004278.93609 | 2111494.4180400004 | 37.7780031505288 | -122.428748840382 | (37.7780031505288, -122.428748840382) | ||
| 106361 | 106361 | 8086 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2001 12:00:00 AM | 6 | 3X3 | 6004351.32927 | 2111504.25977 | 37.7780342704524 | -122.428499108252 | (37.7780342704524, -122.428499108252) | ||
| 139950 | 139950 | 8082 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1992 12:00:00 AM | 6 | 3X3 | 6004115.11785 | 2111289.80956 | 37.7774320731857 | -122.429300951982 | (37.7774320731857, -122.429300951982) | ||
| 17348 | 17348 | 4322 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 752 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002136.242880001 | 2095781.1252 | 37.7347367232032 | -122.435037065224 | (37.7347367232032, -122.435037065224) | |||
| 20863 | 20863 | 112866 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 99727 | 99727 | 112868 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 107775 | 107775 | 112864 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | |||
| 109062 | 109062 | 112867 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 109983 | 109983 | 112869 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 114300 | 114300 | 112865 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 82778 | 82778 | 18650 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017333.617127299 | 2096134.4813376998 | 37.736558188021704 | -122.38251858534201 | (37.7365581880217, -122.382518585342) | ||
| 44502 | 44502 | 202037 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Crane St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012270.3118199995 | 2090901.9422 | 37.7219097135375 | -122.399657426574 | (37.7219097135375, -122.399657426574) | |||
| 148185 | 148185 | 202038 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Crane St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012275.87253 | 2090920.17769 | 37.7219600944649 | -122.39963948420099 | (37.7219600944649, -122.399639484201) | |||
| 10895 | 10895 | 27085 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 747 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6006317.37103 | 2093607.15152 | 37.729003994832 | -122.420427188268 | (37.729003994832, -122.420427188268) | |||
| 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) | |||
| 59397 | 59397 | 31336 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 745 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 9 | Permit Number 34951 | 6004456.33645 | 2111073.11505 | 37.776856394839 | -122.42810511786001 | (37.776856394839, -122.42810511786) | ||
| 112633 | 112633 | 31338 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 745 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 6x18 | Permit Number 34951 | 6004451.86142632 | 2111060.17267694 | 37.776820605073205 | -122.428119675771 | (37.7768206050732, -122.428119675771) | ||
| 170174 | 170174 | 138832 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 745 BUCHANAN ST | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 6004455.5234 | 2111072.8991 | 37.7768557558926 | -122.428107915053 | (37.7768557558926, -122.428107915053) | |||
| 43050 | 43050 | 83178 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 743 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51518 | 5990037.32656 | 2110290.0684599997 | 37.7738800155956 | -122.477927036337 | (37.7738800155956, -122.477927036337) | |
| 136568 | 136568 | 136260 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 740 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6007759.94756 | 2120993.00482 | 37.8042803312301 | -122.417380065732 | (37.8042803312301, -122.417380065732) | |||
| 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) | ||
| 168725 | 168725 | 74150 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 740 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1995 12:00:00 AM | 8 | 6004499.396000001 | 2111088.6935 | 37.776901605564206 | -122.427957272174 | (37.7769016055642, -122.427957272174) | ||
| 175286 | 175286 | 141309 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 74 PARKER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996869.9521 | 2114088.2769 | 37.784703091925294 | -122.454566442022 | (37.7847030919253, -122.454566442022) | |||
| 9215 | 9215 | 10617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 74 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1992 12:00:00 AM | 6 | 3X3 | 6016731.0735863 | 2095616.8317798001 | 37.7351035225916 | -122.38456580983299 | (37.7351035225916, -122.384565809833) | ||
| 106650 | 106650 | 90391 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 74 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/31/2016 12:00:00 AM | 3 | 3x3 | 6007027.339501999 | 2109746.308859 | 37.7733584293936 | -122.419117085527 | (37.7733584293936, -122.419117085527) | ||
| 26988 | 26988 | 248441 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 739 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998553.128 | 2108007.4759 | 37.7681031739849 | -122.44830520423099 | (37.7681031739849, -122.448305204231) | |||
| 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) | ||
| 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) |
| 118948 | 118948 | 64315 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 73 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25132 | 6004320.83696842 | 2097772.93842025 | 37.74032959360579 | -122.42762603639099 | (37.7403295936058, -122.427626036391) | ||
| 135932 | 135932 | 240188 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 73 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004313.76435 | 2097764.66953 | 37.74030648905929 | -122.42764990171499 | (37.7403064890593, -122.427649901715) | |||
| 26458 | 26458 | 139278 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 725 FULTON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004349.2802 | 2111499.4808 | 37.7780210326226 | -122.42850585599199 | (37.7780210326226, -122.428505855992) | |||
| 32797 | 32797 | 139276 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 725 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004285.6861 | 2111490.9383 | 37.777993978047704 | -122.428725241569 | (37.7779939780477, -122.428725241569) | |||
| 42922 | 42922 | 139277 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 725 FULTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004315.8695 | 2111494.5451 | 37.778005589649 | -122.428621083615 | (37.778005589649, -122.428621083615) | |||
| 48657 | 48657 | 139274 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 725 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004227.9769 | 2111481.8263 | 37.7779656924567 | -122.42892422841899 | (37.7779656924567, -122.428924228419) | |||
| 6678 | 6678 | 48693 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 722 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2003 12:00:00 AM | 4 | 3x3 | Permit Number 45971 | 6001051.9149 | 2111314.295 | 37.7773254106094 | -122.43989931071 | (37.7773254106094, -122.43989931071) | |
| 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) | |||
| 114979 | 114979 | 118322 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 720 BATTERY ST | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 6012486.0 | 2118560.0 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | |||||
| 117099 | 117099 | 67353 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 719 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | Permit Number 30840 | 6009877.74530728 | 2104927.0414579 | 37.7602859329215 | -122.40891700175 | (37.7602859329215, -122.40891700175) | ||
| 183463 | 183463 | 239287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 719 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009892.49651 | 2104739.8354599997 | 37.7597727338352 | -122.40885277595899 | (37.7597727338352, -122.408852775959) | |||
| 137742 | 137742 | 102622 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 719 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2014 12:00:00 AM | 1 | Permit Number 772854 | 5992851.12865 | 2110544.54919 | 37.774741661803006 | -122.46821223444401 | (37.774741661803, -122.468212234444) |
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");