trees
6,714 rows where qSpecies_id = 7 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
65113 | 214218 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001377.44838 | 2094959.38668 | 37.7324373042189 | -122.437601643014 | (37.7324373042189, -122.437601643014) | 9 | 7 | 5 | 63 | 40 | |||
32586 | 214291 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999381.70111 | 2093509.42542 | 37.7283423752946 | -122.444397221682 | (37.7283423752946, -122.444397221682) | 9 | 7 | 4 | 28861 | 40 | |||
70257 | 117635 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 100 LOCUST ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997570 | 2115996 | 37.7899813188913 | -122.452282225129 | (37.7899813188913, -122.452282225129) | 11 | 6 | 1 | 54 | 31 | ||||
163119 | 117636 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 100 LOCUST ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997570 | 2115996 | 37.7899813188913 | -122.452282225129 | (37.7899813188913, -122.452282225129) | 11 | 6 | 1 | 54 | 31 | ||||
46739 | 245153 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000359.9454 | 2109295.8652 | 37.7717438992436 | -122.442148126287 | (37.7717438992436, -122.442148126287) | 15 | 5 | 11 | 29492 | 9 | |||
70179 | 245155 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000354.8127 | 2109347.659 | 37.7718858194659 | -122.442169599164 | (37.7718858194659, -122.442169599164) | 15 | 5 | 11 | 29492 | 9 | |||
93793 | 245152 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000363.2117 | 2109282.8001 | 37.7717082119132 | -122.442135889971 | (37.7717082119132, -122.442135889971) | 15 | 5 | 11 | 29492 | 9 | |||
117453 | 245154 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000359.4788 | 2109307.5305 | 37.7717759026297 | -122.442150577795 | (37.7717759026297, -122.442150577795) | 15 | 5 | 11 | 29492 | 9 | |||
37576 | 178732 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Morse St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 1ft | 6000912.22914 | 2087974.06631 | 37.7132307386797 | -122.438709651846 | (37.7132307386797, -122.438709651846) | 9 | 7 | 6 | 28861 | 5 | |||
46143 | 178733 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Morse St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 1ft | 6000880.0864 | 2087963.64183 | 37.7132002867365 | -122.438820001354 | (37.7132002867365, -122.438820001354) | 9 | 7 | 6 | 28861 | 5 | |||
190466 | 236538 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007123.60944 | 2096775.02412 | 37.73774768042 | -122.417864419915 | (37.73774768042, -122.417864419915) | 2 | 7 | 7 | 28859 | 2 | |||
93755 | 236666 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Rousseau St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003492.24635 | 2095170.16548 | 37.7331360693763 | -122.430305323657 | (37.7331360693763, -122.430305323657) | 9 | 7 | 5 | 28861 | 25 | |||
604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
3055 | 20039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
4991 | 20043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
7114 | 20035 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
7976 | 20040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
14721 | 20044 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
18800 | 20042 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
88304 | 236456 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999868.68972 | 2106959.71443 | 37.7653014069506 | -122.443679549194 | (37.7653014069506, -122.443679549194) | 15 | 5 | 5 | 29492 | 9 | |||
171814 | 66752 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30004 | 5999885.94793997 | 2106981.28514866 | 37.76536161907 | -122.443621406981 | (37.76536161907, -122.443621406981) | 15 | 5 | 5 | 29492 | 9 | ||
108675 | 218105 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Valdez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996339.83835 | 2094260.20189 | 37.7302298004556 | -122.454967243237 | (37.7302298004556, -122.454967243237) | 9 | 7 | 4 | 28861 | 40 | |||
135696 | 218106 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 Valdez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996331.64468 | 2094278.95884 | 37.7302808324897 | -122.454996924487 | (37.7302808324897, -122.454996924487) | 9 | 7 | 4 | 28861 | 40 | |||
176308 | 237862 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1000 San Jose Ave | 16 | Front Yard : Yard | Tree | Private 2 | 8 | 6005165.80079 | 2097273.24395 | 37.7390053040631 | -122.424668946839 | (37.7390053040631, -122.424668946839) | 2 | 7 | 5 | 28859 | 7 | ||||
55369 | 235854 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1001 Treat Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008634.56949 | 2102672.57244 | 37.7540259580459 | -122.413057167657 | (37.7540259580459, -122.413057167657) | 2 | 4 | 7 | 28859 | 19 | |||
175527 | 235853 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1001 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008635.35109 | 2102632.9195 | 37.7539171238959 | -122.413051661109 | (37.7539171238959, -122.413051661109) | 2 | 4 | 7 | 28859 | 19 | |||
87915 | 237516 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1004 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779660 | 6003758.05774 | 2102389.16893 | 37.752972841143 | -122.429901097271 | (37.752972841143, -122.429901097271) | 2 | 4 | 5 | 28862 | 22 | |
32731 | 196133 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1007 Rhode Island St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6011938.93616 | 2103592.22231 | 37.7567360569294 | -122.401694443163 | (37.7567360569294, -122.401694443163) | 10 | 3 | 8 | 28856 | 29 | |||
44169 | 42430 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100@ Detroit Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2011 12:00:00 AM | 3x3 | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | 9 | 7 | 4 | 28861 | 40 | ||
137621 | 42429 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100@ Detroit Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/13/2011 12:00:00 AM | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | 9 | 7 | 4 | 28861 | 40 | ||
183600 | 42109 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100@ Detroit Judson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/13/2011 12:00:00 AM | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | 9 | 7 | 4 | 28861 | 40 | ||
19962 | 41358 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100X Freelon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769972 | 6013404.2023591 | 2111579.81317621 | 37.7787498613905 | -122.397187064886 | (37.7787498613905, -122.397187064886) | 6 | 2 | 9 | 28856 | 34 | |
74575 | 41359 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100X Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769972 | 6013404.2023591 | 2111579.81317621 | 37.7787498613905 | -122.397187064886 | (37.7787498613905, -122.397187064886) | 6 | 2 | 9 | 28856 | 34 | |
40766 | 42068 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100X Ripley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 8 | 3x3 | Permit Number 42381 | 6015269 | 2115673 | 37.7900924610766 | -122.391022110897 | (37.7900924610766, -122.391022110897) | 6 | 2 | 9 | 28855 | 6 |
132234 | 212576 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100x Idora Ave | 7 | Median : Yard | Tree | DPW 1 | 2 | Width 9ft | 5995353.74805 | 2099410.49817 | 37.7443146316188 | -122.458748984199 | (37.7443146316188, -122.458748984199) | 1 | 8 | 4 | 59 | 40 | |||
126965 | 111962 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 100x PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x9 | 6006854 | 2098911 | 37.7435974172286 | -122.418948043759 | (37.7435974172286, -122.418948043759) | 2 | 7 | 7 | 28859 | 2 | |||
179985 | 111963 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 100x PROSPECT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x9 | 6006854 | 2098911 | 37.7435974172286 | -122.418948043759 | (37.7435974172286, -122.418948043759) | 2 | 7 | 7 | 28859 | 2 | |||
41444 | 235779 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007829.38632 | 2107937.75996 | 37.768437714343 | -122.416214571342 | (37.768437714343, -122.416214571342) | 8 | 4 | 7 | 28853 | 19 | |||
52195 | 235781 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007897.33458 | 2107939.92752 | 37.7684474863954 | -122.415979697229 | (37.7684474863954, -122.415979697229) | 8 | 4 | 7 | 28853 | 19 | |||
140819 | 235783 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 14th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007948.83505 | 2107941.71994 | 37.7684553033005 | -122.415801688103 | (37.7684553033005, -122.415801688103) | 8 | 4 | 7 | 28853 | 19 | |||
171040 | 235780 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007854.40767 | 2107937.9593 | 37.7684396685821 | -122.416128038604 | (37.7684396685821, -122.416128038604) | 8 | 4 | 7 | 28853 | 19 | |||
172714 | 235782 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 14th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007925.97185 | 2107942.18805 | 37.7684553032924 | -122.415880803267 | (37.7684553032924, -122.415880803267) | 8 | 4 | 7 | 28853 | 19 | |||
65312 | 140858 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5996504.4566 | 2113783.0205 | 37.7838439696062 | -122.455808853694 | (37.7838439696062, -122.455808853694) | 11 | 6 | 1 | 54 | 31 | |||
158557 | 140859 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5996507.8408 | 2113753.2393 | 37.7837623925718 | -122.45579499217 | (37.7837623925718, -122.45579499217) | 11 | 6 | 1 | 54 | 31 | |||
21806 | 235804 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005947.41662 | 2108263.38345 | 37.7692257974626 | -122.422747288973 | (37.7692257974626, -122.422747288973) | 8 | 4 | 5 | 28853 | 19 | |||
41162 | 235801 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005883.41521 | 2108258.98356 | 37.7692101051947 | -122.422968354011 | (37.7692101051947, -122.422968354011) | 8 | 4 | 5 | 28853 | 19 | |||
43954 | 235797 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005800.37341 | 2108254.71576 | 37.7691937006596 | -122.423255288107 | (37.7691937006596, -122.423255288107) | 8 | 4 | 5 | 28853 | 19 | |||
45291 | 235651 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005902.10184 | 2108266.77799 | 37.7692325612568 | -122.422904271909 | (37.7692325612568, -122.422904271909) | 8 | 4 | 5 | 28853 | 19 | |||
50086 | 234932 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005871.99071 | 2108264.40316 | 37.7692243414611 | -122.423008256052 | (37.7692243414611, -122.423008256052) | 8 | 4 | 5 | 28853 | 19 | |||
61802 | 234929 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005801.80623 | 2108262.51921 | 37.7692152079303 | -122.423250886835 | (37.7692152079303, -122.423250886835) | 8 | 4 | 5 | 28853 | 19 | |||
62975 | 235652 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005913.15424 | 2108268.21407 | 37.7692371280199 | -122.422866144261 | (37.7692371280199, -122.422866144261) | 8 | 4 | 5 | 28853 | 19 | |||
63151 | 235654 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005956.27341 | 2108269.65644 | 37.7692435212993 | -122.422717099611 | (37.7692435212993, -122.422717099611) | 8 | 4 | 5 | 28853 | 19 | |||
64993 | 235806 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005986.07177 | 2108265.70629 | 37.769234356307 | -122.422613747743 | (37.769234356307, -122.422613747743) | 8 | 4 | 5 | 28853 | 19 | |||
67322 | 234931 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005830.53397 | 2108262.59431 | 37.7692170353627 | -122.423151524321 | (37.7692170353627, -122.423151524321) | 8 | 4 | 5 | 28853 | 19 | |||
74450 | 235800 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005864.34817 | 2108257.81701 | 37.7692058262066 | -122.423034223044 | (37.7692058262066, -122.423034223044) | 8 | 4 | 5 | 28853 | 19 | |||
75165 | 235653 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005923.19136 | 2108269.00547 | 37.769239867348 | -122.422831482591 | (37.769239867348, -122.422831482591) | 8 | 4 | 5 | 28853 | 19 | |||
112721 | 235799 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005830.12565 | 2108255.40292 | 37.7691972664816 | -122.423152425439 | (37.7691972664816, -122.423152425439) | 8 | 4 | 5 | 28853 | 19 | |||
138424 | 235656 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005994.39108 | 2108271.53409 | 37.7692508274014 | -122.422585385825 | (37.7692508274014, -122.422585385825) | 8 | 4 | 5 | 28853 | 19 | |||
142496 | 235805 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005967.26033 | 2108264.27436 | 37.7692293632676 | -122.422678713849 | (37.7692293632676, -122.422678713849) | 8 | 4 | 5 | 28853 | 19 | |||
144164 | 235798 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005813.16633 | 2108255.23202 | 37.7691958401558 | -122.423211074736 | (37.7691958401558, -122.423211074736) | 8 | 4 | 5 | 28853 | 19 | |||
153937 | 235803 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005913.18878 | 2108260.70962 | 37.7692165245411 | -122.422865491372 | (37.7692165245411, -122.422865491372) | 8 | 4 | 5 | 28853 | 19 | |||
154405 | 234930 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005817.15804 | 2108261.87124 | 37.7692142951364 | -122.423197739607 | (37.7692142951364, -122.423197739607) | 8 | 4 | 5 | 28853 | 19 | |||
166239 | 235802 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005898.04933 | 2108260.24154 | 37.7692143850607 | -122.422917824723 | (37.7692143850607, -122.422917824723) | 8 | 4 | 5 | 28853 | 19 | |||
169059 | 235655 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005977.35609 | 2108271.55166 | 37.7692499145823 | -122.422644310309 | (37.7692499145823, -122.422644310309) | 8 | 4 | 5 | 28853 | 19 | |||
175469 | 235807 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Clinton Park | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6006001.71707 | 2108265.38483 | 37.7692343563017 | -122.422559608546 | (37.7692343563017, -122.422559608546) | 8 | 4 | 5 | 28853 | 19 | |||
27499 | 236964 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006697.04206 | 2099038.8726 | 37.7439396871577 | -122.41949983707 | (37.7439396871577, -122.41949983707) | 2 | 7 | 7 | 28859 | 2 | |||
152415 | 33500 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37590 | 6006714.87668026 | 2099055.44381023 | 37.7439861925088 | -122.419439344303 | (37.7439861925088, -122.419439344303) | 2 | 7 | 7 | 28859 | 2 | |||
35102 | 38880 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | 11 | 6 | 1 | 54 | 31 | ||
17193 | 178814 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Dartmouth St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008515.4618 | 2093543.1863 | 37.7289519843287 | -122.412823674893 | (37.7289519843287, -122.412823674893) | 9 | 3 | 7 | 309 | 28 | |||
35494 | 178817 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Dartmouth St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008503.05611 | 2093585.92096 | 37.7290686282173 | -122.412869582581 | (37.7290686282173, -122.412869582581) | 9 | 3 | 7 | 309 | 28 | |||
112872 | 178815 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Dartmouth St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6008508.63069 | 2093566.30204 | 37.7290150717701 | -122.41284892425 | (37.7290150717701, -122.41284892425) | 9 | 3 | 7 | 309 | 28 | |||
115548 | 178812 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Dartmouth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008523.95893 | 2093520.36698 | 37.7288898042995 | -122.412792686959 | (37.7288898042995, -122.412792686959) | 9 | 3 | 7 | 309 | 28 | |||
124503 | 178813 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Dartmouth St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6008521.43939 | 2093527.03063 | 37.7289079598366 | -122.412801868136 | (37.7289079598366, -122.412801868136) | 9 | 3 | 7 | 309 | 28 | |||
176890 | 178816 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Dartmouth St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008506.49361 | 2093575.43693 | 37.7290400342664 | -122.412856957904 | (37.7290400342664, -122.412856957904) | 9 | 3 | 7 | 309 | 28 | |||
35938 | 236868 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Downey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998866.62555 | 2107543.56118 | 37.7668472992937 | -122.447187461839 | (37.7668472992937, -122.447187461839) | 15 | 5 | 11 | 29492 | 9 | |||
40370 | 32376 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Leese St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | 2 | 7 | 7 | 28859 | 2 | ||
69138 | 32373 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | 2 | 7 | 7 | 28859 | 2 | ||
94989 | 32375 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Leese St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | 2 | 7 | 7 | 28859 | 2 | ||
147033 | 32374 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Leese St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | 2 | 7 | 7 | 28859 | 2 | ||
44370 | 245160 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000314.5004 | 2109304.1699 | 37.7717641118423 | -122.4423059193 | (37.7717641118423, -122.4423059193) | 15 | 5 | 11 | 29492 | 9 | |||
48448 | 245161 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000318.8213 | 2109280.9033 | 37.7717004738838 | -122.442289302515 | (37.7717004738838, -122.442289302515) | 15 | 5 | 11 | 29492 | 9 | |||
21970 | 218043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Montalvo Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993702.92374 | 2099723.43076 | 37.7450788422242 | -122.464479856365 | (37.7450788422242, -122.464479856365) | 1 | 8 | 4 | 29491 | 40 | |||
31436 | 31009 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Morse St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | 9 | 7 | 6 | 28861 | 5 | ||
167129 | 31008 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Morse St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | 9 | 7 | 6 | 28861 | 5 | ||
25138 | 237453 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Park St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005364.30282 | 2096453.91883 | 37.7367668303254 | -122.423924371127 | (37.7367668303254, -122.423924371127) | 2 | 7 | 7 | 28859 | 2 | |||
28401 | 237452 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Park St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005352.05945 | 2096455.18886 | 37.7367696263275 | -122.423966792136 | (37.7367696263275, -122.423966792136) | 2 | 7 | 7 | 28859 | 2 | |||
32740 | 237455 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005396.93745 | 2096449.85399 | 37.7367575115422 | -122.423811249886 | (37.7367575115422, -122.423811249886) | 2 | 7 | 7 | 28859 | 2 | |||
74707 | 237454 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005379.23641 | 2096450.89689 | 37.7367593758303 | -122.423872524308 | (37.7367593758303, -122.423872524308) | 2 | 7 | 7 | 28859 | 2 | |||
78895 | 178717 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004584.21016 | 2090425.13837 | 37.7201690658377 | -122.426192413645 | (37.7201690658377, -122.426192413645) | 9 | 7 | 6 | 28861 | 5 | |||
123159 | 178718 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004594.54509 | 2090439.60676 | 37.72020937703 | -122.42615771873 | (37.72020937703, -122.42615771873) | 9 | 7 | 6 | 28861 | 5 | |||
152053 | 178719 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004605.15174 | 2090454.0925 | 37.7202497512089 | -122.426122085766 | (37.7202497512089, -122.426122085766) | 9 | 7 | 6 | 28861 | 5 | |||
181001 | 178720 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Prague St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004614.94019 | 2090469.42766 | 37.7202924114547 | -122.42608934145 | (37.7202924114547, -122.42608934145) | 9 | 7 | 6 | 28861 | 5 | |||
92370 | 236970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006927.74942 | 2098897.25858 | 37.7435638388955 | -122.41869206151 | (37.7435638388955, -122.41869206151) | 2 | 7 | 7 | 28859 | 2 | |||
22228 | 212470 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Wildwood Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995931.1257 | 2093291.65457 | 37.7275469474275 | -122.456310203567 | (37.7275469474275, -122.456310203567) | 9 | 7 | 4 | 28861 | 40 | |||
74019 | 110150 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Woodland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 5997047.9 | 2105929.4 | 37.7623111384262 | -122.453361551942 | (37.7623111384262, -122.453361551942) | 15 | 5 | 11 | 29492 | 12 | ||||
80453 | 236843 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 101 Woodland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5997044.29314 | 2105904.62743 | 37.7622429124985 | -122.45337223805 | (37.7622429124985, -122.45337223805) | 15 | 5 | 11 | 29492 | 12 | |||
6136 | 35480 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1011 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | 4 | Permit Number 44832 | 6007756.21553 | 2093380.89962 | 37.7284637342957 | -122.415436968047 | (37.7284637342957, -122.415436968047) | 9 | 3 | 7 | 309 | 5 | |
68009 | 82720 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1013 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51582 | 5992460.12309 | 2110660.03692 | 37.7750361697564 | -122.469573199161 | (37.7750361697564, -122.469573199161) | 11 | 6 | 2 | 54 | 11 | |
32215 | 35020 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1013 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | 7 | Permit Number 38595 | 6012215.58628 | 2103654.42136 | 37.7569222759593 | -122.400742049433 | (37.7569222759593, -122.400742049433) | 10 | 3 | 8 | 28856 | 29 | ||
164472 | 236596 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1013 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008039.59752 | 2101942.4333 | 37.751987743556 | -122.415063052444 | (37.751987743556, -122.415063052444) | 2 | 4 | 7 | 28859 | 19 |
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) );