trees
310 rows where Police Districts = 7 and qSpecies_id = 65 sorted by qCareAssistant descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1937 | 78248 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 734 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6002539.24351 | 2089283.26415 | 37.716917933889 | -122.433179625239 | (37.716917933889, -122.433179625239) | 9 | 7 | 6 | 28861 | 5 | |||
| 2206 | 70527 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 25 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004201.75826 | 2093380.33154 | 37.7282617492704 | -122.427724869209 | (37.7282617492704, -122.427724869209) | 9 | 7 | 6 | 28861 | 5 | |||
| 3223 | 70495 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 41 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004160.99444 | 2093317.30941 | 37.7280863985552 | -122.427861302663 | (37.7280863985552, -122.427861302663) | 9 | 7 | 6 | 28861 | 5 | |||
| 3392 | 70645 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 67 Lamartine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6002626.20323 | 2094469.32888 | 37.7311626384362 | -122.433249403638 | (37.7311626384362, -122.433249403638) | 9 | 7 | 5 | 28861 | 25 | |||
| 3472 | 95121 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 68 Lamartine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54048 | 6002661 | 2094358 | 37.7308589285589 | -122.433121153797 | (37.7308589285589, -122.433121153797) | 9 | 7 | 5 | 28861 | 25 | |
| 3753 | 64301 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 151 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1988 12:00:00 AM | Permit Number 25112 | 6004932.6099578 | 2099277.06478887 | 37.7444941674798 | -122.425617791869 | (37.7444941674798, -122.425617791869) | 2 | 7 | 5 | 63 | 22 | ||
| 7022 | 70397 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 130 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 21 | 6006350.25387 | 2093285.00079 | 37.7281212922586 | -122.420290654116 | (37.7281212922586, -122.420290654116) | 9 | 7 | 7 | 309 | 5 | |||
| 8616 | 47055 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45042 | 5994940.24503133 | 2097052.6739603 | 37.7378168558175 | -122.460008006142 | (37.7378168558175, -122.460008006142) | 9 | 7 | 4 | 59 | 40 | ||
| 8943 | 73896 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004393.10182 | 2091444.69797 | 37.7229577492801 | -122.426925586868 | (37.7229577492801, -122.426925586868) | 9 | 7 | 6 | 28861 | 5 | |||
| 9579 | 74128 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004381.29063 | 2091452.37119 | 37.7229781503978 | -122.426966961977 | (37.7229781503978, -122.426966961977) | 9 | 7 | 6 | 28861 | 5 | |||
| 13672 | 70491 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 26 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6005035.04728 | 2091735.87999 | 37.7237935486115 | -122.424727215697 | (37.7237935486115, -122.424727215697) | 9 | 7 | 6 | 28861 | 5 | |||
| 13677 | 73831 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 102 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6010808.25129 | 2088026.19044 | 37.713931877121 | -122.404509096323 | (37.713931877121, -122.404509096323) | 9 | 7 | 8 | 309 | 39 | |||
| 14111 | 74492 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6004373.61085 | 2091456.86354 | 37.7229900511464 | -122.42699382922 | (37.7229900511464, -122.42699382922) | 9 | 7 | 6 | 28861 | 5 | |||
| 16080 | 67500 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 518 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1997 12:00:00 AM | Permit Number 31028 | 5997975.78487802 | 2094419.07569222 | 37.7307597431483 | -122.449323026732 | (37.7307597431483, -122.449323026732) | 9 | 7 | 4 | 59 | 40 | ||
| 16687 | 74647 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004365.04367 | 2091463.54141 | 37.7230079026666 | -122.42702391962 | (37.7230079026666, -122.42702391962) | 9 | 7 | 6 | 28861 | 5 | |||
| 16813 | 160908 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6002284.55838 | 2090317.50092 | 37.7197432674186 | -122.434133839205 | (37.7197432674186, -122.434133839205) | 9 | 7 | 6 | 28861 | 5 | |
| 18137 | 70176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 307 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 3.5x4 to 3.5x7 | 6004287.81152 | 2091470.53201 | 37.7230227297861 | -122.42729139329 | (37.7230227297861, -122.42729139329) | 9 | 7 | 6 | 28861 | 5 | ||
| 19668 | 66266 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 658 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1990 12:00:00 AM | Permit Number 29373 | 5997726.05518981 | 2098148.01561628 | 37.7409842298876 | -122.450455094169 | (37.7409842298876, -122.450455094169) | 9 | 7 | 4 | 59 | 40 | ||
| 20861 | 66314 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 32 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29429 | 6001885.6486627 | 2094955.45184976 | 37.7324553817298 | -122.435844396286 | (37.7324553817298, -122.435844396286) | 9 | 7 | 5 | 63 | 40 | ||
| 21507 | 62444 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 221 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25105 | 6005138.76094737 | 2098996.79373606 | 37.7437362535856 | -122.424885027142 | (37.7437362535856, -122.424885027142) | 2 | 7 | 5 | 63 | 22 | ||
| 22865 | 66317 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 125 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29434 | 6001244.97910985 | 2094913.4211357 | 37.732303560745 | -122.438056328119 | (37.732303560745, -122.438056328119) | 9 | 7 | 4 | 63 | 40 | ||
| 23336 | 63134 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 27 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23649 | 6007447.90223159 | 2099378.78534919 | 37.7449152757931 | -122.416927606356 | (37.7449152757931, -122.416927606356) | 2 | 7 | 7 | 28859 | 2 | ||
| 30781 | 65559 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 301 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1990 12:00:00 AM | Permit Number 28458 | 5995039.18564511 | 2096207.71663667 | 37.735502500801 | -122.459604741585 | (37.735502500801, -122.459604741585) | 9 | 7 | 4 | 59 | 40 | ||
| 30892 | 64152 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 426 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24931 | 6003142.3642398 | 2099236.03637221 | 37.7442801920451 | -122.431805163973 | (37.7442801920451, -122.431805163973) | 2 | 7 | 5 | 63 | 22 | ||
| 31519 | 65560 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 310 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1990 12:00:00 AM | Permit Number 28459 | 5995012.80467967 | 2096143.76494049 | 37.7353253881276 | -122.459691319295 | (37.7353253881276, -122.459691319295) | 9 | 7 | 4 | 59 | 40 | ||
| 33233 | 67291 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 701 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | 19 | Permit Number 30767 | 6005304.50618 | 2092488.24493 | 37.725874593313 | -122.423849212975 | (37.725874593313, -122.423849212975) | 9 | 7 | 7 | 309 | 5 | |
| 33290 | 63461 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 45 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1987 12:00:00 AM | Permit Number 24052 | 6006867.21716204 | 2099801.68707108 | 37.7460437878528 | -122.418965501899 | (37.7460437878528, -122.418965501899) | 2 | 7 | 7 | 28859 | 2 | ||
| 35130 | 63135 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 25 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23650 | 6007455.65629161 | 2099393.17627053 | 37.7449552262088 | -122.416901813576 | (37.7449552262088, -122.416901813576) | 2 | 7 | 7 | 28859 | 2 | ||
| 37651 | 64302 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 121 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1988 12:00:00 AM | Permit Number 25113 | 6005123.1483335 | 2099287.66798911 | 37.7445340460317 | -122.42495970266 | (37.7445340460317, -122.42495970266) | 2 | 7 | 5 | 63 | 22 | ||
| 38682 | 158242 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003158.9626 | 2096376.80466 | 37.7364303417798 | -122.431543687401 | (37.7364303417798, -122.431543687401) | 2 | 7 | 5 | 63 | 7 |
| 42101 | 59432 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3045 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1994 12:00:00 AM | Permit Number 18794 | 6002901.09620901 | 2096034.49584779 | 37.7354758211207 | -122.432410798093 | (37.7354758211207, -122.432410798093) | 2 | 7 | 5 | 63 | 7 | ||
| 45102 | 52520 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 54 Norton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 30 | Permit Number 48621 | 6001810.81862 | 2092293.71669 | 37.7251426126309 | -122.4359127153 | (37.7251426126309, -122.4359127153) | 9 | 7 | 6 | 28861 | 25 | |
| 48996 | 94666 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53803 | 6004020 | 2095225 | 37.7333165119994 | -122.428484644893 | (37.7333165119994, -122.428484644893) | 9 | 7 | 5 | 28861 | 25 | |
| 50747 | 65523 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 721 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1990 12:00:00 AM | 21 | Permit Number 28410 | 6001369.75843 | 2089371.25057 | 37.7170931137224 | -122.437228255287 | (37.7170931137224, -122.437228255287) | 9 | 7 | 6 | 28861 | 5 | |
| 51560 | 68866 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 50 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32829 | 5999664.63009036 | 2093804.62136616 | 37.72916905361 | -122.443440322014 | (37.72916905361, -122.443440322014) | 9 | 7 | 4 | 63 | 40 | ||
| 55051 | 67285 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 119 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | Permit Number 30761 | 6004716.66423484 | 2092675.63660854 | 37.7263559262182 | -122.425894675863 | (37.7263559262182, -122.425894675863) | 9 | 7 | 6 | 28861 | 5 | ||
| 56987 | 63133 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 28 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23648 | 6007400.02445462 | 2099399.55358264 | 37.7449696074565 | -122.417094630618 | (37.7449696074565, -122.417094630618) | 2 | 7 | 7 | 28859 | 2 | ||
| 57703 | 64151 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 432 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24930 | 6003105.46054998 | 2099234.08620142 | 37.7442727453071 | -122.431932629736 | (37.7442727453071, -122.431932629736) | 2 | 7 | 5 | 63 | 22 | ||
| 58635 | 63004 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1986 12:00:00 AM | 20 | 4x6 | Permit Number 23414 | 6007279.07639479 | 2096499.56656681 | 37.7370000828457 | -122.417307379598 | (37.7370000828457, -122.417307379598) | 2 | 7 | 7 | 28859 | 2 |
| 60112 | 66322 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 268 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29439 | 6000307.14957074 | 2094979.56664824 | 37.7324318016212 | -122.441303355183 | (37.7324318016212, -122.441303355183) | 9 | 7 | 5 | 63 | 40 | ||
| 60245 | 108910 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) | 2 | 7 | 7 | 28859 | 2 |
| 62771 | 62339 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 67 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1994 12:00:00 AM | Permit Number 22481 | 6004929.22923105 | 2096213.38801269 | 37.7360818148322 | -122.425411499586 | (37.7360818148322, -122.425411499586) | 2 | 7 | 5 | 28859 | 2 | ||
| 62808 | 67908 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31611 | 5999270.9302444 | 2093516.90049213 | 37.7283565792877 | -122.44478069728 | (37.7283565792877, -122.44478069728) | 9 | 7 | 4 | 28861 | 40 | ||
| 63785 | 158240 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003134.83556 | 2096356.78559 | 37.7363740064603 | -122.43162567588 | (37.7363740064603, -122.43162567588) | 2 | 7 | 5 | 63 | 7 |
| 63890 | 35857 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 28 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 28 | 4x6 | Permit Number 39076 | 6002203.07861 | 2092639.23336 | 37.7261135989609 | -122.434581409299 | (37.7261135989609, -122.434581409299) | 9 | 7 | 6 | 28861 | 25 |
| 67823 | 103022 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 40X Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/15/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770067 | 6006901 | 2099544.2 | 37.7453386886112 | -122.418830426928 | (37.7453386886112, -122.418830426928) | 2 | 7 | 7 | 28859 | 2 |
| 67978 | 67941 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 127 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31655 | 6004179.48175958 | 2095714.01541041 | 37.7346682618025 | -122.427968106929 | (37.7346682618025, -122.427968106929) | 2 | 7 | 5 | 28861 | 25 | ||
| 68752 | 65658 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 72 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28578 | 5998676.92004406 | 2096648.99460169 | 37.7369226528823 | -122.44705951572 | (37.7369226528823, -122.44705951572) | 9 | 7 | 4 | 59 | 40 | ||
| 69147 | 33484 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 300 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | 30 | 6x6 | Permit Number 37610 | 6006227.43678663 | 2098258.25526822 | 37.741769825751 | -122.421068211473 | (37.741769825751, -122.421068211473) | 2 | 7 | 7 | 28859 | 2 |
| 71957 | 95120 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 67 Lamartine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54047 | 6002640 | 2094338 | 37.7308028218422 | -122.433192325631 | (37.7308028218422, -122.433192325631) | 9 | 7 | 5 | 28861 | 25 | |
| 72103 | 40424 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 175 Valdez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2016 12:00:00 AM | 3 | Permit Number 778380 | 5996165.75170379 | 2094545.8989408 | 37.7310042675093 | -122.455589722394 | (37.7310042675093, -122.455589722394) | 9 | 7 | 4 | 28861 | 40 | |
| 73282 | 108847 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 970 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001586.13513 | 2086816.33243 | 37.7100901720951 | -122.436297601751 | (37.7100901720951, -122.436297601751) | 9 | 7 | 6 | 28861 | 5 | |
| 75026 | 64105 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 531 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24871 | 6003137.00791589 | 2098885.2523176 | 37.7433167168502 | -122.431798643811 | (37.7433167168502, -122.431798643811) | 2 | 7 | 5 | 63 | 22 | ||
| 76448 | 108926 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 36 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772355 | 6007347.4 | 2099299.8 | 37.7446927459132 | -122.417269529335 | (37.7446927459132, -122.417269529335) | 2 | 7 | 7 | 28859 | 2 |
| 78160 | 68831 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32782 | 5999950.39080564 | 2094093.84509942 | 37.729979487143 | -122.442473182831 | (37.729979487143, -122.442473182831) | 9 | 7 | 4 | 63 | 40 | ||
| 83049 | 39933 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 180 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 17 | Permit Number 41204 | 6010299.07366 | 2087996.8284 | 37.7138227857583 | -122.406266946271 | (37.7138227857583, -122.406266946271) | 9 | 7 | 8 | 309 | 39 | |
| 83501 | 66304 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 400 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | 3x50 | Permit Number 29418 | 6000123.45614997 | 2094964.38431909 | 37.732379648564 | -122.44193733537 | (37.732379648564, -122.44193733537) | 9 | 7 | 5 | 63 | 40 | |
| 83894 | 108683 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 384 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774613 | 6000302.20846 | 2086863.37515 | 37.7101463059777 | -122.440738464824 | (37.7101463059777, -122.440738464824) | 9 | 7 | 6 | 28861 | 5 |
| 84530 | 62373 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 451 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24914 | 6003654.71208885 | 2098328.44048503 | 37.741817173247 | -122.429968846467 | (37.741817173247, -122.429968846467) | 2 | 7 | 5 | 63 | 7 | ||
| 86106 | 66313 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 22 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29428 | 6001939.09148098 | 2094954.61972241 | 37.7324561325978 | -122.435659572604 | (37.7324561325978, -122.435659572604) | 9 | 7 | 5 | 63 | 40 | ||
| 87022 | 64145 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 447 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24920 | 6002941.41423586 | 2098582.0522051 | 37.7424731102471 | -122.432453304275 | (37.7424731102471, -122.432453304275) | 2 | 7 | 5 | 63 | 22 | ||
| 94208 | 52929 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48913 | 6002555.71096 | 2093126.63865 | 37.7274719160952 | -122.433397195531 | (37.7274719160952, -122.433397195531) | 9 | 7 | 6 | 28861 | 25 |
| 95940 | 68849 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 230 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32812 | 5999215.30905725 | 2094104.51871766 | 37.7299668673625 | -122.44501520736 | (37.7299668673625, -122.44501520736) | 9 | 7 | 4 | 28861 | 40 | ||
| 98307 | 64417 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 48 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1988 12:00:00 AM | Permit Number 25265 | 6003653.48603698 | 2098020.8724606 | 37.7409725927511 | -122.429951151332 | (37.7409725927511, -122.429951151332) | 2 | 7 | 5 | 63 | 7 | ||
| 98833 | 64258 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 184 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25059 | 6004745.64406041 | 2098733.50242163 | 37.742991103255 | -122.426225591142 | (37.742991103255, -122.426225591142) | 2 | 7 | 5 | 63 | 22 | ||
| 102715 | 67506 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 431 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31036 | 5997894.54403764 | 2094074.0284741 | 37.7298076778319 | -122.449579034013 | (37.7298076778319, -122.449579034013) | 9 | 7 | 4 | 28861 | 40 | ||
| 105309 | 35840 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 621 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 18 | 6x7 | Permit Number 39067 | 6002271.78016 | 2090299.14404 | 37.7196921382746 | -122.434176697315 | (37.7196921382746, -122.434176697315) | 9 | 7 | 6 | 28861 | 5 |
| 105667 | 64297 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 219 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25106 | 6005151.45554357 | 2098997.50110191 | 37.7437389128818 | -122.424841182538 | (37.7437389128818, -122.424841182538) | 2 | 7 | 5 | 63 | 22 | ||
| 108513 | 254649 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 929 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781532 | 6000895.17385 | 2091578.90462 | 37.7231278434042 | -122.439026791536 | (37.7231278434042, -122.439026791536) | 9 | 7 | 6 | 28861 | 25 |
| 117767 | 158241 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003145.71012 | 2096365.89505 | 37.7363996353363 | -122.431588728148 | (37.7363996353363, -122.431588728148) | 2 | 7 | 5 | 63 | 7 |
| 118130 | 67911 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 66 Marston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31614 | 5998875.49490681 | 2093226.9126308 | 37.7275377658836 | -122.446126879833 | (37.7275377658836, -122.446126879833) | 9 | 7 | 4 | 28861 | 40 | ||
| 126686 | 64148 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1545 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24927 | 6003347.08832902 | 2099252.09112644 | 37.7443358777099 | -122.431098417838 | (37.7443358777099, -122.431098417838) | 2 | 7 | 5 | 63 | 22 | ||
| 127600 | 39936 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 262 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 11 | Permit Number 41207 | 6009779.33678 | 2088185.9421 | 37.7143129666441 | -122.408076686195 | (37.7143129666441, -122.408076686195) | 9 | 7 | 8 | 309 | 39 | |
| 128238 | 64300 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1987 12:00:00 AM | 6004802.69510738 | 2099321.91565877 | 37.7446099759611 | -122.426070203486 | (37.7446099759611, -122.426070203486) | 2 | 7 | 5 | 63 | 22 | |||
| 132523 | 115548 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 20 | 4x6 | 6007279.07639479 | 2096499.56656681 | 37.7370000828457 | -122.417307379598 | (37.7370000828457, -122.417307379598) | 2 | 7 | 7 | 28859 | 2 | ||
| 132571 | 63129 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 34 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23643 | 6007144.61352889 | 2099320.79872129 | 37.7447389927671 | -122.417972215495 | (37.7447389927671, -122.417972215495) | 2 | 7 | 7 | 28859 | 2 | ||
| 133303 | 160893 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 634 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 08:15:00 AM | 3 | Width 0ft | 6002406.55833 | 2090085.42086 | 37.7191129505803 | -122.433695551007 | (37.7191129505803, -122.433695551007) | 9 | 7 | 6 | 28861 | 5 | |
| 133428 | 94661 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 246 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53798 | 6004650 | 2096961 | 37.7381188082759 | -122.426430123703 | (37.7381188082759, -122.426430123703) | 2 | 7 | 5 | 63 | 7 | |
| 135471 | 66323 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 274 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29440 | 6000269.21852417 | 2094980.11816522 | 37.7324311551198 | -122.441434530926 | (37.7324311551198, -122.441434530926) | 9 | 7 | 5 | 63 | 40 | ||
| 136488 | 109499 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774984 | 6002392.9 | 2096233.9 | 37.7359945088656 | -122.43418207237 | (37.7359945088656, -122.43418207237) | 2 | 7 | 5 | 63 | 7 |
| 137107 | 108890 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 350 Hearst Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773349 | 5999093.24367 | 2094395.39174 | 37.7307585689262 | -122.445458107682 | (37.7307585689262, -122.445458107682) | 9 | 7 | 4 | 59 | 40 | |
| 141890 | 39929 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 137 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | Permit Number 767825 | 6010490.84450997 | 2087849.27835868 | 37.7134283686634 | -122.405593725995 | (37.7134283686634, -122.405593725995) | 9 | 7 | 8 | 309 | 39 | ||
| 144794 | 32372 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 90 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2018 12:00:00 AM | 3 | Permit Number 782452 | 6005529.07574 | 2096212.96171 | 37.7361145169719 | -122.423337554504 | (37.7361145169719, -122.423337554504) | 2 | 7 | 7 | 28859 | 2 | |
| 149484 | 64150 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 412 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24929 | 6003228.47286853 | 2099240.58677175 | 37.7442975672349 | -122.431507743694 | (37.7442975672349, -122.431507743694) | 2 | 7 | 5 | 63 | 22 | ||
| 150684 | 31817 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 378 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 11 | Permit Number 35283 | 6003458.13683 | 2099246.4861 | 37.7443267796662 | -122.43071403582 | (37.7443267796662, -122.43071403582) | 2 | 7 | 5 | 63 | 22 | |
| 152810 | 94662 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 252 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53799 | 6004605 | 2096922 | 37.7380091791898 | -122.426582934947 | (37.7380091791898, -122.426582934947) | 2 | 7 | 5 | 63 | 7 | |
| 161874 | 59173 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 327 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1992 12:00:00 AM | Permit Number 18486 | 6003820.21364245 | 2098630.45378724 | 37.742655803759 | -122.429418128827 | (37.742655803759, -122.429418128827) | 2 | 7 | 5 | 63 | 22 | ||
| 165722 | 64259 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 118 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25060 | 6005164.43101867 | 2098756.56789098 | 37.7430780980429 | -122.424779179687 | (37.7430780980429, -122.424779179687) | 2 | 7 | 5 | 63 | 22 | ||
| 167603 | 108846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 970 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001611.41863 | 2086816.80035 | 37.7100928934503 | -122.436210250619 | (37.7100928934503, -122.436210250619) | 9 | 7 | 6 | 28861 | 5 | |
| 168332 | 64134 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 553 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24905 | 6003001.41812219 | 2098877.69698992 | 37.743288284611 | -122.432266938445 | (37.743288284611, -122.432266938445) | 2 | 7 | 5 | 63 | 22 | ||
| 169503 | 65718 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 206 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | 22 | Permit Number 28650 | 6000369.4893 | 2087691.53319 | 37.7124240746766 | -122.440565289581 | (37.7124240746766, -122.440565289581) | 9 | 7 | 6 | 28861 | 5 | |
| 171813 | 35138 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 832 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 9 | Permit Number 38668 | 6001976.8462 | 2088896.96126 | 37.7158253124776 | -122.435095942923 | (37.7158253124776, -122.435095942923) | 9 | 7 | 6 | 28861 | 5 | |
| 171966 | 64298 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 217 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25107 | 6005164.15015163 | 2098998.20846843 | 37.7437415721643 | -122.424797337889 | (37.7437415721643, -122.424797337889) | 2 | 7 | 5 | 63 | 22 | ||
| 172119 | 64418 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 76 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1988 12:00:00 AM | Permit Number 25266 | 6003598.76227624 | 2097871.53968329 | 37.7405594599669 | -122.430129715298 | (37.7405594599669, -122.430129715298) | 2 | 7 | 5 | 63 | 7 | ||
| 172987 | 95109 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 9 | 3x3 | Permit Number 54038 | 6001824.30736 | 2093468.52552 | 37.7283691373029 | -122.435950110013 | (37.7283691373029, -122.435950110013) | 9 | 7 | 6 | 28861 | 25 |
| 176854 | 67934 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1998 12:00:00 AM | Permit Number 31647 | 6003947.82619719 | 2095984.77824106 | 37.7353986067624 | -122.428788314932 | (37.7353986067624, -122.428788314932) | 2 | 7 | 5 | 63 | 7 | ||
| 176909 | 68818 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32765 | 5999442.86322085 | 2093551.99082798 | 37.7284627395009 | -122.444188839651 | (37.7284627395009, -122.444188839651) | 9 | 7 | 4 | 63 | 40 | ||
| 180750 | 158239 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780004 | 6003126.50979 | 2096349.74034 | 37.7363541898933 | -122.43165395869 | (37.7363541898933, -122.43165395869) | 2 | 7 | 5 | 63 | 7 |
| 183603 | 67515 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 179 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31051 | 5998906.63498153 | 2093763.92891486 | 37.7290140653184 | -122.446057838601 | (37.7290140653184, -122.446057838601) | 9 | 7 | 4 | 28861 | 40 | ||
| 185506 | 63233 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 200x ESMERALDA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1987 12:00:00 AM | Permit Number 23781 | 6007093 | 2098828 | 37.7433829729046 | -122.41811575542 | (37.7433829729046, -122.41811575542) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );