trees
310 rows where Police Districts = 7 and qSpecies_id = 65 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6832 | 221870 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 530 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008584.18129 | 2096552.27767 | 37.7372181568784 | -122.412798757353 | (37.7372181568784, -122.412798757353) | 10 | 7 | 7 | 28859 | 2 | |||
48444 | 221887 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4107 Ogden Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008432.72367 | 2096048.99248 | 37.7358277429522 | -122.41328683742 | (37.7358277429522, -122.41328683742) | 10 | 7 | 7 | 28859 | 2 | |||
88122 | 248073 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 440 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6010194.15796 | 2098463.12553 | 37.7425551682987 | -122.407366975408 | (37.7425551682987, -122.407366975408) | 10 | 7 | 7 | 28859 | 2 | |||
103566 | 248075 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 407 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010292.79484 | 2098665.98806 | 37.743117705012 | -122.407040212138 | (37.743117705012, -122.407040212138) | 10 | 7 | 7 | 28859 | 2 | |||
188123 | 248074 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 440 Holladay Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6010189.61639 | 2098448.43347 | 37.742514572897 | -122.407381643363 | (37.742514572897, -122.407381643363) | 10 | 7 | 7 | 28859 | 2 | |||
578 | 221823 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 199X Ogden Ave | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 4ft | 6007760.27568 | 2096148.55485 | 37.7360633428545 | -122.415618808282 | (37.7360633428545, -122.415618808282) | 2 | 7 | 7 | 28859 | 2 | |||
1033 | 221901 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004253.74444 | 2095482.9703 | 37.7340380650904 | -122.427694899296 | (37.7340380650904, -122.427694899296) | 2 | 7 | 5 | 28861 | 25 | |||
1806 | 221820 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 2ft | 6007294.28583 | 2096507.5919 | 37.7370229743371 | -122.417255362169 | (37.7370229743371, -122.417255362169) | 2 | 7 | 7 | 28859 | 2 | |||
2752 | 221825 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008302.15962 | 2096532.14097 | 37.7371470321954 | -122.41377241466 | (37.7371470321954, -122.41377241466) | 2 | 7 | 7 | 28859 | 2 | |||
3673 | 221872 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 619 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007332.3833 | 2097776.98457 | 37.740510589287 | -122.417213566178 | (37.740510589287, -122.417213566178) | 2 | 7 | 7 | 28859 | 2 | |||
3681 | 106711 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3990 FOLSOM ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008366.1 | 2096547.2 | 37.7371919715517 | -122.413552407719 | (37.7371919715517, -122.413552407719) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | ||
4034 | 158226 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 217 Whitney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6004403.18115 | 2097173.01672 | 37.7386870025035 | -122.427298598675 | (37.7386870025035, -122.427298598675) | 2 | 7 | 5 | 63 | 7 | |||
4442 | 221873 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 253 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007019.01293 | 2097474.10434 | 37.7396613127072 | -122.418275612445 | (37.7396613127072, -122.418275612445) | 2 | 7 | 7 | 28859 | 2 | |||
7501 | 262401 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
10220 | 221824 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 199X Ogden Ave | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6007730.82531 | 2096150.27006 | 37.7360663969372 | -122.415720751814 | (37.7360663969372, -122.415720751814) | 2 | 7 | 7 | 28859 | 2 | |||
10474 | 221869 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 673 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007432.02888 | 2095820.07599 | 37.7351429550833 | -122.416730429683 | (37.7351429550833, -122.416730429683) | 2 | 7 | 7 | 28859 | 2 | |||
11272 | 221805 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1350 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003874.14486 | 2100377.76702 | 37.7474565750744 | -122.429356224108 | (37.7474565750744, -122.429356224108) | 2 | 7 | 5 | 63 | 22 | |||
12895 | 221826 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008314.44854 | 2096531.09899 | 37.7371448612571 | -122.413729852457 | (37.7371448612571, -122.413729852457) | 2 | 7 | 7 | 28859 | 2 | |||
17657 | 221821 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x5 | 6007305.19909 | 2096505.34711 | 37.7370174246124 | -122.417217471014 | (37.7370174246124, -122.417217471014) | 2 | 7 | 7 | 28859 | 2 | |||
18580 | 262400 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
19306 | 221827 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008328.718 | 2096529.81834 | 37.7371421461853 | -122.413680425731 | (37.7371421461853, -122.413680425731) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
22793 | 221849 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004448.4556 | 2095570.1665 | 37.7342884984186 | -122.427027930603 | (37.7342884984186, -122.427027930603) | 2 | 7 | 5 | 28861 | 25 | |||
23185 | 241540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 191 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 780010 | 6004426.52656 | 2097222.39048 | 37.7388238918993 | -122.427221397276 | (37.7388238918993, -122.427221397276) | 2 | 7 | 5 | 63 | 7 | |
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 | ||
24861 | 221804 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 266 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 39 | Width 4ft | 6004140.40735 | 2099573.26288 | 37.7452626636546 | -122.42837817451 | (37.7452626636546, -122.42837817451) | 2 | 7 | 5 | 63 | 22 | |||
28695 | 221842 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6004251.52018 | 2095424.77714 | 37.7338781539609 | -122.427698444448 | (37.7338781539609, -122.427698444448) | 2 | 7 | 5 | 28861 | 25 | |||
29348 | 221851 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004484.38042 | 2095546.73676 | 37.7342261969882 | -122.426902058798 | (37.7342261969882, -122.426902058798) | 2 | 7 | 5 | 28861 | 25 | |||
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 | ||
32001 | 221822 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007356.42456 | 2097004.67982 | 37.7383913638823 | -122.417075731561 | (37.7383913638823, -122.417075731561) | 2 | 7 | 7 | 28859 | 2 | |||
32667 | 221878 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 18 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6006985.0649 | 2099647.22119 | 37.7456262946341 | -122.41854704763 | (37.7456262946341, -122.41854704763) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
35034 | 221861 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 246 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004637.65749 | 2096950.59035 | 37.7380895280136 | -122.426472056954 | (37.7380895280136, -122.426472056954) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||
35544 | 221939 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 21 Harry St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6003408.10773 | 2097774.81236 | 37.740283068906 | -122.430782023672 | (37.740283068906, -122.430782023672) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||
38326 | 221845 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004371.42755 | 2095618.1193 | 37.7344158100226 | -122.427297656166 | (37.7344158100226, -122.427297656166) | 2 | 7 | 5 | 28861 | 25 | |||
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 | ||
43199 | 221866 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 53 Wilder St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002528.4957 | 2095557.08411 | 37.734143822686 | -122.433664907521 | (37.734143822686, -122.433664907521) | 2 | 7 | 5 | 63 | 7 | |||
47768 | 221885 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 100 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008227.02437 | 2099369.61702 | 37.7449338966774 | -122.414232888254 | (37.7449338966774, -122.414232888254) | 2 | 7 | 7 | 28859 | 2 | |||
50598 | 221896 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6004330.56552 | 2095607.66514 | 37.7343847942306 | -122.427438185126 | (37.7343847942306, -122.427438185126) | 2 | 7 | 5 | 28861 | 25 | |||
52019 | 119902 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 598 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002915 | 2095952 | 37.7352500947879 | -122.43235683741 | (37.7352500947879, -122.43235683741) | 2 | 7 | 5 | 63 | 7 | ||||
53970 | 221876 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6006954.78098 | 2099597.50642 | 37.7454880840995 | -122.418648240225 | (37.7454880840995, -122.418648240225) | 2 | 7 | 7 | 28859 | 2 | |||
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 |
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 | ||
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 |
64032 | 221815 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3734 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008428.67762 | 2097499.17078 | 37.7398093887782 | -122.413403351802 | (37.7398093887782, -122.413403351802) | 2 | 7 | 7 | 28859 | 2 | |||
64776 | 221819 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 68 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006048.67396 | 2097610.71259 | 37.7399817402673 | -122.421640334157 | (37.7399817402673, -122.421640334157) | 2 | 7 | 7 | 28859 | 2 | |||
65100 | 221877 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006964.5888 | 2099612.44373 | 37.7455296507747 | -122.418615385312 | (37.7455296507747, -122.418615385312) | 2 | 7 | 7 | 28859 | 2 | |||
66471 | 221841 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6004259.60988 | 2095362.69857 | 37.7337081577855 | -122.42766605444 | (37.7337081577855, -122.42766605444) | 2 | 7 | 5 | 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 | ||
69139 | 221840 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6004312.44121 | 2095336.44977 | 37.7336390727743 | -122.427481531566 | (37.7336390727743, -122.427481531566) | 2 | 7 | 5 | 28861 | 25 | |||
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 |
69208 | 119901 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 598 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002915 | 2095952 | 37.7352500947879 | -122.43235683741 | (37.7352500947879, -122.43235683741) | 2 | 7 | 5 | 63 | 7 | ||||
70357 | 221879 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 43 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006986.90322 | 2099718.335 | 37.745821660643 | -122.418545732803 | (37.745821660643, -122.418545732803) | 2 | 7 | 7 | 28859 | 2 | |||
71152 | 221844 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 127 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6004153.19016 | 2095736.31086 | 37.7347279926082 | -122.428060594226 | (37.7347279926082, -122.428060594226) | 2 | 7 | 5 | 28861 | 25 | |||
71384 | 221875 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 319 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6006211.14692 | 2098216.1896 | 37.7416534045787 | -122.421121550328 | (37.7416534045787, -122.421121550328) | 2 | 7 | 7 | 28859 | 2 | |||
72140 | 221898 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004300.13641 | 2095569.34378 | 37.7342778513286 | -122.427540659282 | (37.7342778513286, -122.427540659282) | 2 | 7 | 5 | 28861 | 25 | |||
72457 | 221800 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6004805.17774 | 2099321.48503 | 37.7446089338676 | -122.42606158838 | (37.7446089338676, -122.42606158838) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||
76041 | 59441 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | Permit Number 18804 | 6004258.9190799 | 2095333.58373446 | 37.7336281759245 | -122.42766636908 | (37.7336281759245, -122.42766636908) | 2 | 7 | 5 | 28861 | 25 | |||
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 |
79681 | 221871 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 619 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007314.53376 | 2097779.75076 | 37.7405171804218 | -122.417275479073 | (37.7405171804218, -122.417275479073) | 2 | 7 | 7 | 28859 | 2 | |||
79694 | 221813 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 810 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007573.94838 | 2095674.48731 | 37.7347511816054 | -122.416229453325 | (37.7347511816054, -122.416229453325) | 2 | 7 | 7 | 28859 | 2 | |||
80067 | 221843 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 124 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6004594.79724 | 2095953.61848 | 37.7353496453739 | -122.426549275423 | (37.7353496453739, -122.426549275423) | 2 | 7 | 5 | 28861 | 2 | |||
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 | ||
85330 | 221801 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 378 Valley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003412.45231 | 2099242.88691 | 37.7443143087709 | -122.430871746349 | (37.7443143087709, -122.430871746349) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||
89515 | 221937 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 31 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005028.18878 | 2097255.91505 | 37.7389499498753 | -122.425143513686 | (37.7389499498753, -122.425143513686) | 2 | 7 | 5 | 63 | 7 | |||
92787 | 114424 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 724 MOULTRIE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x2 | 6007601 | 2096031 | 37.735731608506 | -122.416161167234 | (37.735731608506, -122.416161167234) | 2 | 7 | 7 | 28859 | 2 | |||
93692 | 221803 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 118 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6005068.88763 | 2098748.30494 | 37.743050013041 | -122.42510895543 | (37.743050013041, -122.42510895543) | 2 | 7 | 5 | 63 | 22 | |||
95508 | 115201 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1352 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 775318 | 6003856.3 | 2100365.8 | 37.747422706117 | -122.429417077187 | (37.747422706117, -122.429417077187) | 2 | 7 | 5 | 63 | 22 | |||
95633 | 221883 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 34 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007121.00835 | 2099271.28888 | 37.7446017212974 | -122.418050328662 | (37.7446017212974, -122.418050328662) | 2 | 7 | 7 | 28859 | 2 | |||
95747 | 221850 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004464.56621 | 2095558.73638 | 37.7342580248697 | -122.426971417216 | (37.7342580248697, -122.426971417216) | 2 | 7 | 5 | 28861 | 25 | |||
95845 | 221899 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004290.71623 | 2095557.06224 | 37.7342435961597 | -122.427572353179 | (37.7342435961597, -122.427572353179) | 2 | 7 | 5 | 28861 | 25 | |||
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 | ||
100205 | 221884 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 230 Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6007166.67292 | 2098807.97162 | 37.7433321258706 | -122.417859593245 | (37.7433321258706, -122.417859593245) | 2 | 7 | 7 | 28859 | 2 | |||
104584 | 221882 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 36 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007355.35831 | 2099292.63872 | 37.7446735303753 | -122.417241503608 | (37.7446735303753, -122.417241503608) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
106933 | 221895 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 47 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003758.63244 | 2095404.32352 | 37.7337940997194 | -122.429401048121 | (37.7337940997194, -122.429401048121) | 2 | 7 | 5 | 28861 | 25 | |||
109510 | 221880 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 47 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007035.70082 | 2099744.20537 | 37.7458954419332 | -122.418378831241 | (37.7458954419332, -122.418378831241) | 2 | 7 | 7 | 28859 | 2 | |||
115143 | 221806 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1350 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003875.18729 | 2100363.84416 | 37.7474184051535 | -122.429351626769 | (37.7474184051535, -122.429351626769) | 2 | 7 | 5 | 63 | 22 | |||
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 |
121688 | 4845 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 202 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1992 12:00:00 AM | 24 | 3X3 | 6006694.31051 | 2097440.2331 | 37.7395500270059 | -122.41939589432 | (37.7395500270059, -122.41939589432) | 2 | 7 | 7 | 28859 | 2 | ||
121889 | 221935 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 102 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6004836.87593 | 2097581.93653 | 37.7398343216046 | -122.425828185523 | (37.7398343216046, -122.425828185523) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||
126786 | 248223 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 70 Fair Ave | 5 | Side Yard : Yard | Tree | Private 2 | 18 | 6007150.20605 | 2099339.87769 | 37.744791694087 | -122.417954229812 | (37.744791694087, -122.417954229812) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||
128312 | 221938 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 36 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002640.28984 | 2096352.56391 | 37.7363343706279 | -122.433335224139 | (37.7363343706279, -122.433335224139) | 2 | 7 | 5 | 63 | 7 | |||
129007 | 221787 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 124 27th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 8ft | 6005680.59891 | 2100245.58826 | 37.7471957491868 | -122.423100223394 | (37.7471957491868, -122.423100223394) | 2 | 7 | 5 | 28859 | 22 | |||
130024 | 221936 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 48 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003658.55433 | 2098021.59816 | 37.7409748723836 | -122.429933678794 | (37.7409748723836, -122.429933678794) | 2 | 7 | 5 | 63 | 7 | |||
130490 | 221857 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 679 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002187.97645 | 2099712.96384 | 37.7455355755051 | -122.435139333412 | (37.7455355755051, -122.435139333412) | 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 |
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) );