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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90587 | 90587 | 117635 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 LOCUST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997570.0 | 2115996.0 | 37.78998131889129 | -122.452282225129 | (37.7899813188913, -122.452282225129) | ||||
118135 | 118135 | 117636 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 LOCUST ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997570.0 | 2115996.0 | 37.78998131889129 | -122.452282225129 | (37.7899813188913, -122.452282225129) | ||||
1661 | 1661 | 245154 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000359.4788 | 2109307.5305 | 37.771775902629706 | -122.44215057779499 | (37.7717759026297, -122.442150577795) | |||
1669 | 1669 | 245155 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000354.8127 | 2109347.659 | 37.7718858194659 | -122.442169599164 | (37.7718858194659, -122.442169599164) | |||
1675 | 1675 | 245153 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000359.9454 | 2109295.8652 | 37.7717438992436 | -122.44214812628701 | (37.7717438992436, -122.442148126287) | |||
65386 | 65386 | 245152 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000363.2117 | 2109282.8001 | 37.77170821191321 | -122.44213588997101 | (37.7717082119132, -122.442135889971) | |||
134948 | 134948 | 178732 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Morse St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 1ft | 6000912.22914 | 2087974.06631 | 37.713230738679705 | -122.43870965184601 | (37.7132307386797, -122.438709651846) | |||
149450 | 149450 | 178733 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Morse St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 1ft | 6000880.0864 | 2087963.6418299999 | 37.713200286736495 | -122.438820001354 | (37.7132002867365, -122.438820001354) | |||
169744 | 169744 | 236538 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007123.60944 | 2096775.0241200002 | 37.73774768042 | -122.417864419915 | (37.73774768042, -122.417864419915) | |||
56182 | 56182 | 236666 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Rousseau St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003492.24635 | 2095170.16548 | 37.7331360693763 | -122.430305323657 | (37.7331360693763, -122.430305323657) | |||
3019 | 3019 | 20034 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
3951 | 3951 | 20035 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
7527 | 7527 | 20039 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
10575 | 10575 | 20040 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | ST | ||||||||
11812 | 11812 | 20044 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
12976 | 12976 | 20042 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
14695 | 14695 | 20043 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
140743 | 140743 | 66752 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30004 | 5999885.94793997 | 2106981.28514866 | 37.76536161907 | -122.443621406981 | (37.76536161907, -122.443621406981) | ||
172310 | 172310 | 236456 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999868.68972 | 2106959.7144299997 | 37.765301406950606 | -122.44367954919399 | (37.7653014069506, -122.443679549194) | |||
76926 | 76926 | 218105 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996339.83835 | 2094260.2018900001 | 37.730229800455604 | -122.454967243237 | (37.7302298004556, -122.454967243237) | |||
147415 | 147415 | 218106 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996331.64468 | 2094278.9588400002 | 37.730280832489704 | -122.454996924487 | (37.7302808324897, -122.454996924487) | |||
160246 | 160246 | 237862 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1000 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005165.80079 | 2097273.24395 | 37.7390053040631 | -122.424668946839 | (37.7390053040631, -122.424668946839) | ||||
35489 | 35489 | 235853 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1001 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008635.35109 | 2102632.9195 | 37.753917123895896 | -122.41305166110901 | (37.7539171238959, -122.413051661109) | |||
136165 | 136165 | 235854 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1001 Treat Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008634.569490001 | 2102672.5724400003 | 37.7540259580459 | -122.41305716765699 | (37.7540259580459, -122.413057167657) | |||
678 | 678 | 237516 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1004 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779660 | 6003758.05774 | 2102389.1689299997 | 37.752972841143 | -122.429901097271 | (37.752972841143, -122.429901097271) | |
59533 | 59533 | 196133 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1007 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6011938.93616 | 2103592.2223099996 | 37.7567360569294 | -122.401694443163 | (37.7567360569294, -122.401694443163) | |||
79475 | 79475 | 42430 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100@ Detroit Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2011 12:00:00 AM | 3x3 | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
115710 | 115710 | 42429 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100@ Detroit Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2011 12:00:00 AM | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
142249 | 142249 | 42109 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100@ Detroit Judson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2011 12:00:00 AM | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
87893 | 87893 | 41359 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100X Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769972 | 6013404.2023591 | 2111579.81317621 | 37.7787498613905 | -122.397187064886 | (37.7787498613905, -122.397187064886) | |
128122 | 128122 | 41358 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100X Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769972 | 6013404.2023591 | 2111579.81317621 | 37.7787498613905 | -122.397187064886 | (37.7787498613905, -122.397187064886) | |
79959 | 79959 | 42068 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100X Ripley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 8 | 3x3 | Permit Number 42381 | 6015269.0 | 2115673.0 | 37.790092461076604 | -122.39102211089701 | (37.7900924610766, -122.391022110897) |
148511 | 148511 | 212576 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100x Idora Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995353.74805 | 2099410.49817 | 37.74431463161879 | -122.458748984199 | (37.7443146316188, -122.458748984199) | |||
104725 | 104725 | 111962 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100x PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x9 | 6006854.0 | 2098911.0 | 37.74359741722861 | -122.418948043759 | (37.7435974172286, -122.418948043759) | |||
138729 | 138729 | 111963 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100x PROSPECT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x9 | 6006854.0 | 2098911.0 | 37.74359741722861 | -122.418948043759 | (37.7435974172286, -122.418948043759) | |||
53092 | 53092 | 235783 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 14th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007948.83505 | 2107941.71994 | 37.7684553033005 | -122.415801688103 | (37.7684553033005, -122.415801688103) | |||
137001 | 137001 | 235781 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007897.3345800005 | 2107939.92752 | 37.768447486395395 | -122.415979697229 | (37.7684474863954, -122.415979697229) | |||
156459 | 156459 | 235779 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007829.38632 | 2107937.75996 | 37.768437714343 | -122.416214571342 | (37.768437714343, -122.416214571342) | |||
165573 | 165573 | 235780 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007854.40767 | 2107937.9593 | 37.768439668582104 | -122.41612803860399 | (37.7684396685821, -122.416128038604) | |||
168839 | 168839 | 235782 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 14th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007925.97185 | 2107942.18805 | 37.7684553032924 | -122.415880803267 | (37.7684553032924, -122.415880803267) | |||
29767 | 29767 | 140858 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5996504.4566 | 2113783.0205 | 37.7838439696062 | -122.455808853694 | (37.7838439696062, -122.455808853694) | |||
175963 | 175963 | 140859 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5996507.8408 | 2113753.2393 | 37.783762392571795 | -122.45579499216998 | (37.7837623925718, -122.45579499217) | |||
25461 | 25461 | 235806 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005986.071769999 | 2108265.70629 | 37.769234356307 | -122.422613747743 | (37.769234356307, -122.422613747743) | |||
32149 | 32149 | 235797 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005800.37341 | 2108254.71576 | 37.7691937006596 | -122.423255288107 | (37.7691937006596, -122.423255288107) | |||
37778 | 37778 | 235653 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005923.19136 | 2108269.00547 | 37.769239867348 | -122.422831482591 | (37.769239867348, -122.422831482591) | |||
39403 | 39403 | 235652 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005913.15424 | 2108268.21407 | 37.7692371280199 | -122.422866144261 | (37.7692371280199, -122.422866144261) | |||
40572 | 40572 | 235656 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005994.39108 | 2108271.53409 | 37.7692508274014 | -122.422585385825 | (37.7692508274014, -122.422585385825) | |||
43115 | 43115 | 235807 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6006001.717069999 | 2108265.38483 | 37.7692343563017 | -122.42255960854601 | (37.7692343563017, -122.422559608546) | |||
46188 | 46188 | 235802 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005898.049330001 | 2108260.2415400003 | 37.7692143850607 | -122.422917824723 | (37.7692143850607, -122.422917824723) | |||
52309 | 52309 | 234932 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005871.99071 | 2108264.4031599998 | 37.7692243414611 | -122.423008256052 | (37.7692243414611, -122.423008256052) | |||
129555 | 129555 | 235655 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005977.35609 | 2108271.55166 | 37.769249914582296 | -122.422644310309 | (37.7692499145823, -122.422644310309) | |||
133836 | 133836 | 235654 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005956.27341 | 2108269.65644 | 37.769243521299295 | -122.42271709961099 | (37.7692435212993, -122.422717099611) | |||
135884 | 135884 | 235801 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005883.41521 | 2108258.9835599996 | 37.7692101051947 | -122.422968354011 | (37.7692101051947, -122.422968354011) | |||
150245 | 150245 | 235651 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005902.101840001 | 2108266.7779900003 | 37.76923256125679 | -122.422904271909 | (37.7692325612568, -122.422904271909) | |||
155819 | 155819 | 235804 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005947.416619999 | 2108263.38345 | 37.7692257974626 | -122.42274728897301 | (37.7692257974626, -122.422747288973) | |||
157937 | 157937 | 235799 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005830.12565 | 2108255.4029200003 | 37.7691972664816 | -122.423152425439 | (37.7691972664816, -122.423152425439) | |||
162551 | 162551 | 234931 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005830.533969999 | 2108262.59431 | 37.7692170353627 | -122.423151524321 | (37.7692170353627, -122.423151524321) | |||
169766 | 169766 | 235805 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005967.26033 | 2108264.2743599997 | 37.769229363267605 | -122.422678713849 | (37.7692293632676, -122.422678713849) | |||
173816 | 173816 | 235798 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005813.16633 | 2108255.23202 | 37.769195840155795 | -122.423211074736 | (37.7691958401558, -122.423211074736) | |||
177648 | 177648 | 234929 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005801.80623 | 2108262.51921 | 37.7692152079303 | -122.423250886835 | (37.7692152079303, -122.423250886835) | |||
182261 | 182261 | 235803 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005913.18878 | 2108260.70962 | 37.7692165245411 | -122.422865491372 | (37.7692165245411, -122.422865491372) | |||
182974 | 182974 | 235800 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005864.34817 | 2108257.81701 | 37.7692058262066 | -122.423034223044 | (37.7692058262066, -122.423034223044) | |||
188613 | 188613 | 234930 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Clinton Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005817.15804 | 2108261.8712400002 | 37.7692142951364 | -122.42319773960699 | (37.7692142951364, -122.423197739607) | |||
122869 | 122869 | 33500 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37590 | 6006714.87668026 | 2099055.44381023 | 37.7439861925088 | -122.419439344303 | (37.7439861925088, -122.419439344303) | |||
180484 | 180484 | 236964 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006697.04206 | 2099038.8726 | 37.743939687157706 | -122.41949983706999 | (37.7439396871577, -122.41949983707) | |||
125439 | 125439 | 38880 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | ||
29124 | 29124 | 178812 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Dartmouth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008523.958930001 | 2093520.36698 | 37.728889804299506 | -122.412792686959 | (37.7288898042995, -122.412792686959) | |||
36131 | 36131 | 178813 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Dartmouth St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6008521.43939 | 2093527.03063 | 37.728907959836604 | -122.412801868136 | (37.7289079598366, -122.412801868136) | |||
37170 | 37170 | 178817 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Dartmouth St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008503.05611 | 2093585.9209599998 | 37.7290686282173 | -122.41286958258101 | (37.7290686282173, -122.412869582581) | |||
45165 | 45165 | 178814 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Dartmouth St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008515.4618 | 2093543.1863 | 37.7289519843287 | -122.41282367489299 | (37.7289519843287, -122.412823674893) | |||
70467 | 70467 | 178816 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Dartmouth St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008506.49361 | 2093575.4369299999 | 37.7290400342664 | -122.412856957904 | (37.7290400342664, -122.412856957904) | |||
146795 | 146795 | 178815 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Dartmouth St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6008508.63069 | 2093566.3020400002 | 37.7290150717701 | -122.41284892424999 | (37.7290150717701, -122.41284892425) | |||
3039 | 3039 | 236868 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Downey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998866.62555 | 2107543.5611799997 | 37.7668472992937 | -122.44718746183901 | (37.7668472992937, -122.447187461839) | |||
83133 | 83133 | 32376 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Leese St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | ||
90719 | 90719 | 32373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | ||
94155 | 94155 | 32375 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Leese St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | ||
111748 | 111748 | 32374 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Leese St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | ||
1658 | 1658 | 245160 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000314.5004 | 2109304.1699 | 37.7717641118423 | -122.4423059193 | (37.7717641118423, -122.4423059193) | |||
1660 | 1660 | 245161 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000318.8213 | 2109280.9033 | 37.7717004738838 | -122.442289302515 | (37.7717004738838, -122.442289302515) | |||
131134 | 131134 | 218043 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Montalvo Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993702.92374 | 2099723.43076 | 37.7450788422242 | -122.46447985636499 | (37.7450788422242, -122.464479856365) | |||
119263 | 119263 | 31008 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Morse St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
127132 | 127132 | 31009 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
36485 | 36485 | 237452 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005352.05945 | 2096455.1888599999 | 37.7367696263275 | -122.423966792136 | (37.7367696263275, -122.423966792136) | |||
65212 | 65212 | 237454 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005379.236409999 | 2096450.8968900002 | 37.736759375830296 | -122.423872524308 | (37.7367593758303, -122.423872524308) | |||
76074 | 76074 | 237453 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005364.30282 | 2096453.9188299999 | 37.7367668303254 | -122.423924371127 | (37.7367668303254, -122.423924371127) | |||
188219 | 188219 | 237455 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005396.93745 | 2096449.8539900002 | 37.7367575115422 | -122.423811249886 | (37.7367575115422, -122.423811249886) | |||
36396 | 36396 | 178720 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Prague St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004614.94019 | 2090469.4276599998 | 37.7202924114547 | -122.42608934145001 | (37.7202924114547, -122.42608934145) | |||
47908 | 47908 | 178717 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004584.21016 | 2090425.13837 | 37.7201690658377 | -122.426192413645 | (37.7201690658377, -122.426192413645) | |||
67704 | 67704 | 178719 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004605.151740001 | 2090454.0925 | 37.7202497512089 | -122.426122085766 | (37.7202497512089, -122.426122085766) | |||
188042 | 188042 | 178718 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004594.54509 | 2090439.6067599999 | 37.72020937703 | -122.42615771873001 | (37.72020937703, -122.42615771873) | |||
67805 | 67805 | 236970 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006927.749419999 | 2098897.25858 | 37.743563838895504 | -122.41869206151001 | (37.7435638388955, -122.41869206151) | |||
177900 | 177900 | 212470 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Wildwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995931.1257 | 2093291.65457 | 37.7275469474275 | -122.45631020356701 | (37.7275469474275, -122.456310203567) | |||
73796 | 73796 | 236843 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Woodland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5997044.29314 | 2105904.62743 | 37.7622429124985 | -122.45337223805001 | (37.7622429124985, -122.45337223805) | |||
89409 | 89409 | 110150 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Woodland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 5997047.9 | 2105929.4 | 37.762311138426206 | -122.45336155194201 | (37.7623111384262, -122.453361551942) | ||||
75775 | 75775 | 35480 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1011 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | 4 | Permit Number 44832 | 6007756.215530001 | 2093380.89962 | 37.7284637342957 | -122.415436968047 | (37.7284637342957, -122.415436968047) | |
186351 | 186351 | 82720 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1013 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51582 | 5992460.12309 | 2110660.03692 | 37.7750361697564 | -122.46957319916099 | (37.7750361697564, -122.469573199161) | |
160813 | 160813 | 35020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1013 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 7 | Permit Number 38595 | 6012215.58628 | 2103654.42136 | 37.7569222759593 | -122.400742049433 | (37.7569222759593, -122.400742049433) | ||
76947 | 76947 | 236596 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1013 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008039.597519999 | 2101942.4333 | 37.751987743556 | -122.415063052444 | (37.751987743556, -122.415063052444) | |||
32547 | 32547 | 135824 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1013 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6008637.906 | 2118634.49639 | 37.7978538127598 | -122.41417484600099 | (37.7978538127598, -122.414174846001) | ||||
52000 | 52000 | 212591 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1014 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995061.42461 | 2090686.5438599999 | 37.7203439740723 | -122.459128189622 | (37.7203439740723, -122.459128189622) |
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");