trees
6,714 rows where qSpecies_id = 7 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68516 | 35867 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 963 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 5 | Permit Number 39078 | 6002026.00377 | 2088372.6219 | 37.7143883838026 | -122.434888555678 | (37.7143883838026, -122.434888555678) | 9 | 7 | 6 | 28861 | 5 | |
104401 | 178731 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000772.8521 | 2088473.80213 | 37.7145949715528 | -122.439227181988 | (37.7145949715528, -122.439227181988) | 9 | 7 | 6 | 28861 | 5 | |||
187469 | 31047 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 146 Rolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34803 | 6000718.58674958 | 2088518.12227815 | 37.7147135766514 | -122.439417919675 | (37.7147135766514, -122.439417919675) | 9 | 7 | 6 | 28861 | 5 | |||
169694 | 31046 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 146 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 7 | Permit Number 34803 | 6000734.07095 | 2088520.94144 | 37.71472219864 | -122.439364601993 | (37.71472219864, -122.439364601993) | 9 | 7 | 6 | 28861 | 5 | |
75957 | 46750 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 229 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47629 | 5993206.8260224 | 2088718.30816088 | 37.7148328801951 | -122.465395976044 | (37.7148328801951, -122.465395976044) | 9 | 8 | 6 | 64 | 24 | ||
130930 | 178780 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1726 Cayuga Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5998049.19765 | 2088646.54217 | 37.7149139107276 | -122.448653629286 | (37.7149139107276, -122.448653629286) | 9 | 7 | 6 | 28861 | 25 | |||
68170 | 212609 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 206 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994928.26625 | 2088724.26351 | 37.7149483619512 | -122.459446432701 | (37.7149483619512, -122.459446432701) | 9 | 8 | 6 | 28861 | 24 | |||
146404 | 178779 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1726 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998069.5898 | 2088665.24722 | 37.7149664365343 | -122.448584492101 | (37.7149664365343, -122.448584492101) | 9 | 7 | 6 | 28861 | 25 | |||
30703 | 121633 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 715 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778948 | 6002248.64047 | 2088586.43173 | 37.7149880967002 | -122.43413431136 | (37.7149880967002, -122.43413431136) | 9 | 7 | 6 | 28861 | 5 | |
89903 | 49748 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 109@ BRUSSELS Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 5 | Permit Number 46547 | 6011907.82901 | 2088398.16242 | 37.715014627609 | -122.400734636294 | (37.715014627609, -122.400734636294) | 10 | 7 | 8 | 309 | 39 | |
20160 | 212660 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 229 Victoria St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5993215.92884 | 2088803.07717 | 37.7150661605497 | -122.465370667224 | (37.7150661605497, -122.465370667224) | 9 | 8 | 6 | 64 | 24 | |||
34732 | 178746 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 29 Tucker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010967.50075 | 2088490.1416 | 37.7152146916939 | -122.403991297254 | (37.7152146916939, -122.403991297254) | 9 | 7 | 8 | 309 | 39 | |||
20851 | 212631 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 162 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5992215.36031 | 2088948.17723 | 37.7154068147365 | -122.468839581692 | (37.7154068147365, -122.468839581692) | 9 | 8 | 6 | 64 | 24 | |||
94520 | 34801 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 311 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | 7 | Permit Number 38437 | 5998132.09009 | 2088842.02869 | 37.715455411421 | -122.448381188667 | (37.715455411421, -122.448381188667) | 9 | 7 | 6 | 28861 | 25 | |
52540 | 34802 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 314 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | 5 | Permit Number 38438 | 5998143.86832 | 2088884.5785 | 37.7155729168266 | -122.448343540327 | (37.7155729168266, -122.448343540327) | 9 | 7 | 6 | 28861 | 25 | |
158188 | 178748 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1359 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011915.3994 | 2088605.78229 | 37.7155851323373 | -122.400723046733 | (37.7155851323373, -122.400723046733) | 10 | 7 | 8 | 309 | 39 | |||
59065 | 84122 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 Alpha St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50683 | 6011538.02534932 | 2088764.33012973 | 37.7159994174075 | -122.402038569068 | (37.7159994174075, -122.402038569068) | 10 | 7 | 8 | 309 | 39 | ||
139564 | 84281 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50683 | 6011538.02534932 | 2088764.33012973 | 37.7159994174075 | -122.402038569068 | (37.7159994174075, -122.402038569068) | 10 | 7 | 8 | 309 | 39 | ||
169214 | 84282 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50683 | 6011538.02534932 | 2088764.33012973 | 37.7159994174075 | -122.402038569068 | (37.7159994174075, -122.402038569068) | 10 | 7 | 8 | 309 | 39 | ||
75185 | 212677 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 916 Sargent St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5991577.34612 | 2089232.98657 | 37.7161519507271 | -122.471065557542 | (37.7161519507271, -122.471065557542) | 9 | 8 | 6 | 64 | 24 | |||
66392 | 212676 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 124 Sargent St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993606.85369 | 2089199.82617 | 37.7161780760225 | -122.464048258239 | (37.7161780760225, -122.464048258239) | 9 | 8 | 6 | 64 | 24 | |||
131597 | 49786 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 238 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50712 | 6011611.30538 | 2088835.81597 | 37.7161997928658 | -122.401790299209 | (37.7161997928658, -122.401790299209) | 10 | 7 | 8 | 309 | 39 | |
164228 | 47368 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 124 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45288 | 5993691.51889332 | 2089207.56073179 | 37.7162041924331 | -122.463756178051 | (37.7162041924331, -122.463756178051) | 9 | 8 | 6 | 64 | 24 | ||
190580 | 178706 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 811 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001828.84195 | 2089087.65401 | 37.7163405070928 | -122.435621147914 | (37.7163405070928, -122.435621147914) | 9 | 7 | 6 | 28861 | 5 | |||
11416 | 71324 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 591 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6003413.42989 | 2089070.32012 | 37.7163827878013 | -122.43014280626 | (37.7163827878013, -122.43014280626) | 9 | 7 | 6 | 28861 | 5 | |||
181026 | 178714 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 586 Munich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6003370.14037 | 2089081.14738 | 37.7164100651458 | -122.430293207979 | (37.7164100651458, -122.430293207979) | 9 | 7 | 6 | 28861 | 5 | |||
47933 | 178713 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 586 Munich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003379.35224 | 2089095.54155 | 37.716450110166 | -122.430262393596 | (37.716450110166, -122.430262393596) | 9 | 7 | 6 | 28861 | 5 | |||
96065 | 178712 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 586 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6003387.67164 | 2089107.84059 | 37.7164843518593 | -122.43023451461 | (37.7164843518593, -122.43023451461) | 9 | 7 | 6 | 28861 | 5 | |||
29122 | 67572 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 586 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1992 12:00:00 AM | 12 | Permit Number 31127 | 6003393.18937 | 2089118.08355 | 37.7165127893129 | -122.430216172952 | (37.7165127893129, -122.430216172952) | 9 | 7 | 6 | 28861 | 5 | ||
121911 | 35841 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 578 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 12 | Permit Number 39068 | 6003413.6457 | 2089149.24845 | 37.7165995199397 | -122.430147687789 | (37.7165995199397, -122.430147687789) | 9 | 7 | 6 | 28861 | 5 | |
55360 | 178781 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 243 Ottawa Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5998332.41388 | 2089291.42657 | 37.7167008060656 | -122.447721115953 | (37.7167008060656, -122.447721115953) | 9 | 7 | 6 | 28861 | 25 | |||
137399 | 117177 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 763 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6002227.98407 | 2089216.84916 | 37.7167179111844 | -122.434250751077 | (37.7167179111844, -122.434250751077) | 9 | 7 | 6 | 28861 | 5 | |||
99135 | 212654 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 234 Vernon St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5992477.54875 | 2089420.35259 | 37.7167184381913 | -122.467967674587 | (37.7167184381913, -122.467967674587) | 9 | 8 | 6 | 64 | 24 | |||
118627 | 212659 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 335 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5993217.88171 | 2089418.24393 | 37.7167553733424 | -122.465408578168 | (37.7167553733424, -122.465408578168) | 9 | 8 | 6 | 64 | 24 | ||||
16715 | 212653 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 238 Vernon St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5992477.51296 | 2089454.93509 | 37.7168133912952 | -122.467970312297 | (37.7168133912952, -122.467970312297) | 9 | 8 | 6 | 64 | 24 | |||
97321 | 212658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 339 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5993218.69942 | 2089441.88827 | 37.7168203421713 | -122.465407468378 | (37.7168203421713, -122.465407468378) | 9 | 8 | 6 | 64 | 24 | ||||
137995 | 50510 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 731 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 4 | Permit Number 47145 | 6002571.72937 | 2089253.5566 | 37.7168382063032 | -122.433065216203 | (37.7168382063032, -122.433065216203) | 9 | 7 | 6 | 28861 | 5 | |
190622 | 212657 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 343 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5993218.2804 | 2089467.7966 | 37.7168914560454 | -122.465410797693 | (37.7168914560454, -122.465410797693) | 9 | 8 | 6 | 64 | 24 | ||||
17400 | 212661 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 542 Head St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5993519.05172 | 2089481.79849 | 37.7169472436938 | -122.464372202114 | (37.7169472436938, -122.464372202114) | 9 | 8 | 6 | 64 | 24 | |||
189 | 178694 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 184 Mount Vernon Ave | 7 | Side Yard : Yard | Tree | Private 2 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.445565994978 | (37.7169892861082, -122.445565994978) | 9 | 7 | 6 | 28861 | 25 | ||||
3475 | 78427 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 721 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001123.96924 | 2089480.39079 | 37.7173788130682 | -122.438085642862 | (37.7173788130682, -122.438085642862) | 9 | 7 | 6 | 28861 | 5 | |||
49033 | 50507 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 718 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 3 | Permit Number 47142 | 6001083.23309 | 2089505.44127 | 37.7174452792652 | -122.438228242065 | (37.7174452792652, -122.438228242065) | 9 | 7 | 6 | 28861 | 5 | |
63946 | 49759 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 214 Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 5 | Permit Number 46554 | 6011567.181 | 2089303.38657 | 37.7174811846954 | -122.401975665657 | (37.7174811846954, -122.401975665657) | 10 | 7 | 8 | 309 | 39 | |
162435 | 49758 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 214 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 5 | Permit Number 46554 | 6011575.84226 | 2089306.63415 | 37.7174905852902 | -122.401945955659 | (37.7174905852902, -122.401945955659) | 10 | 7 | 8 | 309 | 39 | |
24250 | 178744 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 116 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009931.27178 | 2089353.07877 | 37.7175261903673 | -122.407633779075 | (37.7175261903673, -122.407633779075) | 9 | 7 | 8 | 309 | 39 | |||
56386 | 50506 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 706 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 4 | Permit Number 47141 | 6001113.88434 | 2089552.34071 | 37.717575797871 | -122.438125652794 | (37.717575797871, -122.438125652794) | 9 | 7 | 6 | 28861 | 5 | |
42805 | 45310 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 186 Byxbee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44148 | 5991970.57716924 | 2089762.40966389 | 37.71762835398 | -122.469744896664 | (37.71762835398, -122.469744896664) | 9 | 8 | 6 | 64 | 24 | ||
111788 | 45311 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 186 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44148 | 5991970.57716924 | 2089762.40966389 | 37.71762835398 | -122.469744896664 | (37.71762835398, -122.469744896664) | 9 | 8 | 6 | 64 | 24 | ||
101293 | 212629 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 186 Byxbee St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 5991963.2488 | 2089763.89053 | 37.7176319964934 | -122.469770335036 | (37.7176319964934, -122.469770335036) | 9 | 8 | 6 | 64 | 24 | |||
88010 | 178745 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 109 Delta St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009981.63941 | 2089404.93287 | 37.7176713904018 | -122.407463334166 | (37.7176713904018, -122.407463334166) | 9 | 7 | 8 | 309 | 39 | |||
114084 | 50495 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 678 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 3 | Permit Number 47131 | 6001459.37999 | 2089596.35959 | 37.7177163070325 | -122.436934583487 | (37.7177163070325, -122.436934583487) | 9 | 7 | 6 | 28861 | 5 | |
144888 | 212630 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 186 Byxbee St | 2 | : | Tree | Private 2 | 2 | Width 2ft | 5991963.5826 | 2089803.15651 | 37.7177398306004 | -122.469772038371 | (37.7177398306004, -122.469772038371) | 9 | 8 | 6 | 64 | 24 | |||
54986 | 49787 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 488 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | 5 | Permit Number 46571 | 6010133.11219 | 2089440.66928 | 37.7177779924458 | -122.406942275981 | (37.7177779924458, -122.406942275981) | 10 | 7 | 8 | 309 | 39 | |
12142 | 47373 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 800 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | 9 | 8 | 6 | 64 | 24 | |||
138471 | 47370 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 800 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | 9 | 8 | 6 | 64 | 24 | |||
160739 | 47371 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 800 Shields St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | 9 | 8 | 6 | 64 | 24 | |||
116577 | 35098 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 710 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38640 | 6002142.25029691 | 2089673.27394965 | 37.7179662858223 | -122.43457970714 | (37.7179662858223, -122.43457970714) | 9 | 7 | 6 | 28861 | 5 | ||
126109 | 45345 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 600 Shields St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44173 | 5992459.1856169 | 2089877.0607821 | 37.7179713877014 | -122.468064348637 | (37.7179713877014, -122.468064348637) | 9 | 8 | 6 | 64 | 24 | ||
35475 | 212652 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 313 Vernon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5992443.32484 | 2089879.75405 | 37.717977866774 | -122.468119367735 | (37.717977866774, -122.468119367735) | 9 | 8 | 6 | 64 | 24 | |||
110938 | 212667 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 412 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5993789.73455 | 2089863.57128 | 37.7180110994161 | -122.463464279867 | (37.7180110994161, -122.463464279867) | 9 | 8 | 6 | 64 | 24 | |||
48968 | 35097 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 706 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38639 | 6002155.75551452 | 2089694.71254743 | 37.7180259181087 | -122.434534557618 | (37.7180259181087, -122.434534557618) | 9 | 7 | 6 | 28861 | 5 | ||
135004 | 212651 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 313 Vernon St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 5992449.87546 | 2089900.89697 | 37.718036298412 | -122.46809826243 | (37.718036298412, -122.46809826243) | 9 | 8 | 6 | 64 | 24 | |||
106056 | 212616 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 Margaret Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5997104.53081 | 2089815.91065 | 37.7180706624041 | -122.452003094875 | (37.7180706624041, -122.452003094875) | 9 | 8 | 6 | 28861 | 24 | |||
104800 | 212615 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 32 Margaret Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5997072.36132 | 2089827.80033 | 37.7181014659845 | -122.45211514769 | (37.7181014659845, -122.45211514769) | 9 | 8 | 6 | 28861 | 24 | |||
150187 | 212617 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 Margaret Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5997114.72788 | 2089830.80854 | 37.7181121526199 | -122.451968922426 | (37.7181121526199, -122.451968922426) | 9 | 8 | 6 | 28861 | 24 | |||
65680 | 212621 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Beverly St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5991409.18042 | 2089964.95615 | 37.7181520321783 | -122.471700124589 | (37.7181520321783, -122.471700124589) | 9 | 8 | 6 | 64 | 24 | |||
187849 | 212622 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5991392 | 2089980 | 37.7181923448703 | -122.471760605115 | (37.7181923448703, -122.471760605115) | 9 | 8 | 6 | 64 | 24 | |||
41179 | 212620 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 119 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5991404.09674 | 2089992.64963 | 37.7182277775561 | -122.471719713595 | (37.7182277775561, -122.471719713595) | 9 | 8 | 6 | 64 | 24 | |||
20920 | 212632 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 319 Ralston St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992190.56348 | 2089982.35509 | 37.7182449834113 | -122.469000508175 | (37.7182449834113, -122.469000508175) | 9 | 8 | 6 | 64 | 24 | |||
54450 | 212650 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 319 Vernon St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992450.00346 | 2089979.5572 | 37.7182522876938 | -122.46810353875 | (37.7182522876938, -122.46810353875) | 9 | 8 | 6 | 64 | 24 | |||
137954 | 47326 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 414 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45256 | 5993794.23352089 | 2089951.41466575 | 37.7182525554849 | -122.46345510031 | (37.7182525554849, -122.46345510031) | 9 | 8 | 6 | 64 | 24 | ||
70366 | 68002 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 319 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31727 | 5992442.5315274 | 2089981.57315011 | 37.7182573914808 | -122.468129512391 | (37.7182573914808, -122.468129512391) | 9 | 8 | 6 | 64 | 24 | ||
94642 | 212623 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 222 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5991708.59487 | 2090008.32571 | 37.7182884332397 | -122.470668344073 | (37.7182884332397, -122.470668344073) | 9 | 8 | 6 | 64 | 24 | |||
43050 | 212619 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 123 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5991404.11082 | 2090016.7036 | 37.718293824676 | -122.471721416918 | (37.718293824676, -122.471721416918) | 9 | 8 | 6 | 64 | 24 | |||
13034 | 72256 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 663 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002588.76079 | 2089788.47679 | 37.71830794493 | -122.433044543475 | (37.71830794493, -122.433044543475) | 9 | 7 | 6 | 28861 | 5 | |||
156333 | 212608 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 10 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995646.24598 | 2089933.06973 | 37.7183087156567 | -122.457052192827 | (37.7183087156567, -122.457052192827) | 9 | 8 | 6 | 28861 | 24 | |||
183980 | 50509 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 812 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 4 | Permit Number 47144 | 6003323.52841 | 2089782.38706 | 37.7183328750409 | -122.43050432831 | (37.7183328750409, -122.43050432831) | 9 | 7 | 6 | 28861 | 5 | |
138545 | 212649 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 321 Vernon St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5992450.10328 | 2090020.59644 | 37.7183649772426 | -122.468106177365 | (37.7183649772426, -122.468106177365) | 9 | 8 | 6 | 64 | 24 | |||
64763 | 40484 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 119 Shawnee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1999 12:00:00 AM | 7 | Permit Number 41563 | 5998642.9116 | 2089895.24325 | 37.7183764894551 | -122.446691304085 | (37.7183764894551, -122.446691304085) | 9 | 7 | 6 | 28861 | 25 | |
151243 | 212624 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 226 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5991707.41959 | 2090046.15057 | 37.7183922230931 | -122.470675160026 | (37.7183922230931, -122.470675160026) | 9 | 8 | 6 | 64 | 24 | |||
88313 | 68003 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 327 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31728 | 5992443.22144719 | 2090030.89079527 | 37.718392845598 | -122.468130713203 | (37.718392845598, -122.468130713203) | 9 | 8 | 6 | 64 | 24 | ||
33115 | 212656 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 426 Victoria St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993265.19823 | 2090019.96829 | 37.7184102922832 | -122.465288712912 | (37.7184102922832, -122.465288712912) | 9 | 8 | 6 | 64 | 24 | |||
123713 | 45356 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 426 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44181 | 5993274.56615099 | 2090020.51787313 | 37.7184123415446 | -122.465256372075 | (37.7184123415446, -122.465256372075) | 9 | 8 | 6 | 64 | 24 | ||
76522 | 212607 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 11 Miramar Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5995300.70518 | 2090004.70984 | 37.7184855727191 | -122.458251756207 | (37.7184855727191, -122.458251756207) | 9 | 8 | 6 | 28861 | 24 | |||
24572 | 45317 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 630 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44154 | 5993535.31460225 | 2090042.0802024 | 37.718486580043 | -122.464356645134 | (37.718486580043, -122.464356645134) | 9 | 8 | 6 | 64 | 24 | ||
71266 | 212625 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 239 Monticello St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5991672.93632 | 2090117.56736 | 37.7185863219837 | -122.470799552451 | (37.7185863219837, -122.470799552451) | 9 | 8 | 6 | 64 | 24 | |||
46967 | 212633 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 338 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5992228.53387 | 2090118.36082 | 37.7186206158303 | -122.468879153643 | (37.7186206158303, -122.468879153643) | 9 | 8 | 6 | 64 | 24 | |||
112493 | 212635 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 343 Ralston St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5992191.77345 | 2090130.53473 | 37.7186519185263 | -122.469007103793 | (37.7186519185263, -122.469007103793) | 9 | 8 | 6 | 64 | 24 | |||
18619 | 218147 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 33 Ashton Ave | 1 | : Yard | Tree | Private 2 | 8 | 5994130.90264 | 2090096.18725 | 37.7186694580143 | -122.462301880921 | (37.7186694580143, -122.462301880921) | 9 | 8 | 6 | 28861 | 24 | ||||
55902 | 178747 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 72 Mill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010396.46983 | 2089761.81061 | 37.7186745139889 | -122.406054573181 | (37.7186745139889, -122.406054573181) | 10 | 7 | 8 | 309 | 39 | |||
183926 | 212634 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 343 Ralston St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992192.8402 | 2090144.9525 | 37.7186915678454 | -122.469004465193 | (37.7186915678454, -122.469004465193) | 9 | 8 | 6 | 64 | 24 | |||
128946 | 67977 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 31 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1993 12:00:00 AM | Permit Number 31701 | 5996184.66753333 | 2090103.76165833 | 37.7188083012393 | -122.455203435791 | (37.7188083012393, -122.455203435791) | 9 | 8 | 6 | 28861 | 24 | ||
188582 | 48582 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 366 Stratford Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | Permit Number 45896 | 5991035.37424613 | 2090234.08230991 | 37.7188693517925 | -122.473011814307 | (37.7188693517925, -122.473011814307) | 9 | 8 | 4 | 64 | 40 | ||
81304 | 212618 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 158 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991450.23786 | 2090240.56685 | 37.7189111669923 | -122.471578280835 | (37.7189111669923, -122.471578280835) | 9 | 8 | 6 | 64 | 24 | |||
6310 | 71322 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 426 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6003937.60452 | 2089980.93172 | 37.718912802856 | -122.428395868697 | (37.718912802856, -122.428395868697) | 9 | 7 | 6 | 28861 | 5 | |||
92075 | 68004 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 359 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1994 12:00:00 AM | Permit Number 31729 | 5992445.98112632 | 2090228.1613759 | 37.7189346620375 | -122.468135516498 | (37.7189346620375, -122.468135516498) | 9 | 8 | 6 | 64 | 24 | ||
124258 | 212648 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 359 Vernon St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992453.38509 | 2090231.05356 | 37.7189430308699 | -122.468110134397 | (37.7189430308699, -122.468110134397) | 9 | 8 | 6 | 64 | 24 | |||
150546 | 196263 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1059 Jamestown Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6013674.30393 | 2089830.73604 | 37.7190465590346 | -122.394729166931 | (37.7190465590346, -122.394729166931) | 10 | 3 | 8 | 58 | 1 | ||||
164711 | 50301 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3212 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | Permit Number 47011 | 6014135.02682875 | 2089827.85867998 | 37.7190642634607 | -122.393136412697 | (37.7190642634607, -122.393136412697) | 10 | 3 | 8 | 58 | 1 | ||
96796 | 45346 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 374 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44174 | 5992499.3558781 | 2090326.06927027 | 37.7192065757155 | -122.4679581402 | (37.7192065757155, -122.4679581402) | 9 | 8 | 6 | 64 | 24 |
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) );