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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59275 | 59275 | 178730 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Curtis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000522.25708 | 2088403.4652200001 | 37.714387578897295 | -122.440088297264 | (37.7143875788973, -122.440088297264) | |||
| 33557 | 33557 | 212610 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 278 Farallones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994199.47136 | 2088424.58434 | 37.714083582860106 | -122.461943718748 | (37.7140835828601, -122.461943718748) | |||
| 105701 | 105701 | 48564 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 278 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45983 | 5994240.83855888 | 2088432.11877754 | 37.714106652118204 | -122.461801284944 | (37.7141066521182, -122.461801284944) | ||
| 41471 | 41471 | 178731 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000772.8521 | 2088473.80213 | 37.7145949715528 | -122.43922718198799 | (37.7145949715528, -122.439227181988) | |||
| 65752 | 65752 | 178746 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 29 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010967.50075 | 2088490.1416 | 37.715214691693895 | -122.40399129725401 | (37.7152146916939, -122.403991297254) | |||
| 144651 | 144651 | 31047 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 146 Rolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34803 | 6000718.58674958 | 2088518.12227815 | 37.7147135766514 | -122.43941791967501 | (37.7147135766514, -122.439417919675) | |||
| 64613 | 64613 | 31046 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 146 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34803 | 6000734.07095 | 2088520.9414400002 | 37.714722198640004 | -122.439364601993 | (37.71472219864, -122.439364601993) | |
| 13011 | 13011 | 121633 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 715 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778948 | 6002248.64047 | 2088586.4317299998 | 37.7149880967002 | -122.43413431136001 | (37.7149880967002, -122.43413431136) | |
| 72550 | 72550 | 178748 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1359 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011915.3994 | 2088605.7822900002 | 37.715585132337296 | -122.40072304673299 | (37.7155851323373, -122.400723046733) | |||
| 185312 | 185312 | 178780 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1726 Cayuga Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998049.19765 | 2088646.54217 | 37.7149139107276 | -122.448653629286 | (37.7149139107276, -122.448653629286) | |||
| 168712 | 168712 | 178779 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1726 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998069.5898 | 2088665.24722 | 37.7149664365343 | -122.448584492101 | (37.7149664365343, -122.448584492101) | |||
| 87100 | 87100 | 46750 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 229 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47629 | 5993206.8260224005 | 2088718.30816088 | 37.714832880195104 | -122.46539597604401 | (37.7148328801951, -122.465395976044) | ||
| 27522 | 27522 | 212609 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 206 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994928.26625 | 2088724.26351 | 37.7149483619512 | -122.459446432701 | (37.7149483619512, -122.459446432701) | |||
| 89563 | 89563 | 84122 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 Alpha St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50683 | 6011538.02534932 | 2088764.33012973 | 37.715999417407495 | -122.402038569068 | (37.7159994174075, -122.402038569068) | ||
| 110550 | 110550 | 84281 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 Alpha St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50683 | 6011538.02534932 | 2088764.33012973 | 37.715999417407495 | -122.402038569068 | (37.7159994174075, -122.402038569068) | ||
| 122516 | 122516 | 84282 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50683 | 6011538.02534932 | 2088764.33012973 | 37.715999417407495 | -122.402038569068 | (37.7159994174075, -122.402038569068) | ||
| 37111 | 37111 | 212660 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 229 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993215.92884 | 2088803.0771700002 | 37.7150661605497 | -122.46537066722401 | (37.7150661605497, -122.465370667224) | |||
| 160419 | 160419 | 49786 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 238 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50712 | 6011611.305380001 | 2088835.81597 | 37.716199792865794 | -122.401790299209 | (37.7161997928658, -122.401790299209) | |
| 37616 | 37616 | 34801 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 311 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 7 | Permit Number 38437 | 5998132.09009 | 2088842.02869 | 37.715455411421 | -122.44838118866699 | (37.715455411421, -122.448381188667) | |
| 42579 | 42579 | 34802 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 314 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 5 | Permit Number 38438 | 5998143.868319999 | 2088884.5785 | 37.7155729168266 | -122.448343540327 | (37.7155729168266, -122.448343540327) | |
| 46660 | 46660 | 212631 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 162 Ralston St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5992215.360309999 | 2088948.17723 | 37.7154068147365 | -122.46883958169201 | (37.7154068147365, -122.468839581692) | |||
| 152311 | 152311 | 71324 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 591 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 8 | 6003413.42989 | 2089070.32012 | 37.7163827878013 | -122.43014280626001 | (37.7163827878013, -122.43014280626) | ||
| 61521 | 61521 | 178714 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 586 Munich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6003370.14037 | 2089081.14738 | 37.716410065145794 | -122.43029320797899 | (37.7164100651458, -122.430293207979) | |||
| 69695 | 69695 | 178706 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 811 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001828.84195 | 2089087.65401 | 37.716340507092795 | -122.435621147914 | (37.7163405070928, -122.435621147914) | |||
| 35645 | 35645 | 178713 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 586 Munich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6003379.35224 | 2089095.54155 | 37.716450110166 | -122.430262393596 | (37.716450110166, -122.430262393596) | |||
| 36256 | 36256 | 178712 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 586 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6003387.67164 | 2089107.8405900002 | 37.7164843518593 | -122.43023451461 | (37.7164843518593, -122.43023451461) | |||
| 157279 | 157279 | 67572 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 586 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1992 12:00:00 AM | 12 | Permit Number 31127 | 6003393.18937 | 2089118.08355 | 37.716512789312894 | -122.430216172952 | (37.7165127893129, -122.430216172952) | ||
| 182311 | 182311 | 35841 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 578 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 12 | Permit Number 39068 | 6003413.6457 | 2089149.24845 | 37.716599519939706 | -122.430147687789 | (37.7165995199397, -122.430147687789) | |
| 29565 | 29565 | 212676 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 124 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993606.85369 | 2089199.82617 | 37.7161780760225 | -122.464048258239 | (37.7161780760225, -122.464048258239) | |||
| 120897 | 120897 | 47368 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 124 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45288 | 5993691.51889332 | 2089207.56073179 | 37.716204192433096 | -122.463756178051 | (37.7162041924331, -122.463756178051) | ||
| 25796 | 25796 | 117177 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 763 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6002227.984069999 | 2089216.8491599998 | 37.716717911184396 | -122.434250751077 | (37.7167179111844, -122.434250751077) | |||
| 153565 | 153565 | 212677 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 916 Sargent St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5991577.34612 | 2089232.9865700002 | 37.7161519507271 | -122.471065557542 | (37.7161519507271, -122.471065557542) | |||
| 176548 | 176548 | 50510 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 731 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 4 | Permit Number 47145 | 6002571.72937 | 2089253.5566 | 37.71683820630321 | -122.433065216203 | (37.7168382063032, -122.433065216203) | |
| 68549 | 68549 | 178781 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 243 Ottawa Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5998332.41388 | 2089291.4265700001 | 37.7167008060656 | -122.447721115953 | (37.7167008060656, -122.447721115953) | |||
| 157290 | 157290 | 49759 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 214 Harkness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 5 | Permit Number 46554 | 6011567.181 | 2089303.38657 | 37.717481184695394 | -122.401975665657 | (37.7174811846954, -122.401975665657) | |
| 157113 | 157113 | 49758 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 214 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 5 | Permit Number 46554 | 6011575.84226 | 2089306.63415 | 37.7174905852902 | -122.401945955659 | (37.7174905852902, -122.401945955659) | |
| 65024 | 65024 | 178744 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 116 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009931.27178 | 2089353.07877 | 37.717526190367295 | -122.407633779075 | (37.7175261903673, -122.407633779075) | |||
| 184390 | 184390 | 178694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 184 Mount Vernon Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.44556599497801 | (37.7169892861082, -122.445565994978) | ||||
| 169161 | 169161 | 178745 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 109 Delta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009981.63941 | 2089404.9328700001 | 37.7176713904018 | -122.407463334166 | (37.7176713904018, -122.407463334166) | |||
| 28486 | 28486 | 212659 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 335 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5993217.881709999 | 2089418.2439299999 | 37.7167553733424 | -122.465408578168 | (37.7167553733424, -122.465408578168) | ||||
| 135613 | 135613 | 212654 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 234 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5992477.54875 | 2089420.3525900003 | 37.71671843819129 | -122.467967674587 | (37.7167184381913, -122.467967674587) | |||
| 63386 | 63386 | 49787 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 488 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 5 | Permit Number 46571 | 6010133.11219 | 2089440.66928 | 37.7177779924458 | -122.40694227598101 | (37.7177779924458, -122.406942275981) | |
| 164489 | 164489 | 212658 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5993218.6994199995 | 2089441.88827 | 37.716820342171296 | -122.46540746837799 | (37.7168203421713, -122.465407468378) | ||||
| 40323 | 40323 | 212653 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 238 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5992477.51296 | 2089454.93509 | 37.716813391295204 | -122.467970312297 | (37.7168133912952, -122.467970312297) | |||
| 147741 | 147741 | 212657 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 343 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5993218.2804 | 2089467.7966 | 37.716891456045396 | -122.46541079769301 | (37.7168914560454, -122.465410797693) | ||||
| 186770 | 186770 | 78427 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 721 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 2 | 6001123.9692400005 | 2089480.39079 | 37.7173788130682 | -122.43808564286199 | (37.7173788130682, -122.438085642862) | ||
| 181822 | 181822 | 212661 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 542 Head St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993519.05172 | 2089481.7984900002 | 37.716947243693795 | -122.46437220211399 | (37.7169472436938, -122.464372202114) | |||
| 48935 | 48935 | 50507 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 718 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 3 | Permit Number 47142 | 6001083.23309 | 2089505.44127 | 37.717445279265206 | -122.438228242065 | (37.7174452792652, -122.438228242065) | |
| 48190 | 48190 | 50506 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 706 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 4 | Permit Number 47141 | 6001113.88434 | 2089552.34071 | 37.717575797871 | -122.438125652794 | (37.717575797871, -122.438125652794) | |
| 23540 | 23540 | 50495 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 678 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 3 | Permit Number 47131 | 6001459.37999 | 2089596.3595900002 | 37.7177163070325 | -122.436934583487 | (37.7177163070325, -122.436934583487) | |
| 106319 | 106319 | 35098 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 710 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38640 | 6002142.25029691 | 2089673.27394965 | 37.71796628582229 | -122.43457970713999 | (37.7179662858223, -122.43457970714) | ||
| 78557 | 78557 | 35097 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 706 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38639 | 6002155.75551452 | 2089694.71254743 | 37.7180259181087 | -122.43453455761801 | (37.7180259181087, -122.434534557618) | ||
| 46957 | 46957 | 178747 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 72 Mill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010396.46983 | 2089761.8106099998 | 37.7186745139889 | -122.406054573181 | (37.7186745139889, -122.406054573181) | |||
| 80982 | 80982 | 45310 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44148 | 5991970.57716924 | 2089762.40966389 | 37.71762835398 | -122.46974489666401 | (37.71762835398, -122.469744896664) | ||
| 98262 | 98262 | 45311 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44148 | 5991970.57716924 | 2089762.40966389 | 37.71762835398 | -122.46974489666401 | (37.71762835398, -122.469744896664) | ||
| 41983 | 41983 | 212629 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5991963.2488 | 2089763.89053 | 37.717631996493395 | -122.46977033503599 | (37.7176319964934, -122.469770335036) | |||
| 185984 | 185984 | 50509 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 812 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 4 | Permit Number 47144 | 6003323.52841 | 2089782.3870599999 | 37.7183328750409 | -122.43050432831001 | (37.7183328750409, -122.43050432831) | |
| 183763 | 183763 | 72256 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 663 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 6 | 6002588.76079 | 2089788.4767900002 | 37.718307944930004 | -122.43304454347499 | (37.71830794493, -122.433044543475) | ||
| 38214 | 38214 | 212630 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5991963.5826 | 2089803.15651 | 37.7177398306004 | -122.46977203837099 | (37.7177398306004, -122.469772038371) | |||
| 178660 | 178660 | 212616 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Margaret Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997104.530809999 | 2089815.91065 | 37.7180706624041 | -122.452003094875 | (37.7180706624041, -122.452003094875) | |||
| 64560 | 64560 | 212615 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 32 Margaret Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997072.36132 | 2089827.80033 | 37.7181014659845 | -122.45211514769 | (37.7181014659845, -122.45211514769) | |||
| 118911 | 118911 | 50301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3212 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | Permit Number 47011 | 6014135.02682875 | 2089827.85867998 | 37.7190642634607 | -122.39313641269699 | (37.7190642634607, -122.393136412697) | ||
| 173598 | 173598 | 196263 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1059 Jamestown Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6013674.30393 | 2089830.73604 | 37.7190465590346 | -122.394729166931 | (37.7190465590346, -122.394729166931) | ||||
| 30088 | 30088 | 212617 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Margaret Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997114.72788 | 2089830.80854 | 37.7181121526199 | -122.45196892242599 | (37.7181121526199, -122.451968922426) | |||
| 34878 | 34878 | 212667 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 412 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5993789.73455 | 2089863.57128 | 37.7180110994161 | -122.463464279867 | (37.7180110994161, -122.463464279867) | |||
| 104870 | 104870 | 45345 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 600 Shields St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2001 12:00:00 AM | Permit Number 44173 | 5992459.1856169 | 2089877.0607820998 | 37.7179713877014 | -122.46806434863701 | (37.7179713877014, -122.468064348637) | ||
| 137960 | 137960 | 212652 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 313 Vernon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5992443.32484 | 2089879.75405 | 37.717977866774 | -122.468119367735 | (37.717977866774, -122.468119367735) | |||
| 21203 | 21203 | 47373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 800 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | |||
| 113427 | 113427 | 47370 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 800 Shields St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | |||
| 120621 | 120621 | 47371 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 800 Shields St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | |||
| 179812 | 179812 | 40484 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 119 Shawnee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | 7 | Permit Number 41563 | 5998642.9116 | 2089895.24325 | 37.7183764894551 | -122.44669130408501 | (37.7183764894551, -122.446691304085) | |
| 159828 | 159828 | 212651 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 313 Vernon St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992449.87546 | 2089900.8969700001 | 37.718036298411995 | -122.46809826243 | (37.718036298412, -122.46809826243) | |||
| 42760 | 42760 | 212608 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995646.24598 | 2089933.0697299999 | 37.718308715656704 | -122.45705219282699 | (37.7183087156567, -122.457052192827) | |||
| 115130 | 115130 | 47326 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 414 Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45256 | 5993794.23352089 | 2089951.41466575 | 37.7182525554849 | -122.46345510031 | (37.7182525554849, -122.46345510031) | ||
| 43064 | 43064 | 212621 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Beverly St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5991409.18042 | 2089964.95615 | 37.718152032178295 | -122.471700124589 | (37.7181520321783, -122.471700124589) | |||
| 179534 | 179534 | 212650 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 319 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992450.00346 | 2089979.5572 | 37.718252287693794 | -122.46810353875 | (37.7182522876938, -122.46810353875) | |||
| 128 | 128 | 212622 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991392.0 | 2089980.0 | 37.718192344870296 | -122.471760605115 | (37.7181923448703, -122.471760605115) | |||
| 44719 | 44719 | 71322 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 9 | 6003937.60452 | 2089980.93172 | 37.718912802856 | -122.428395868697 | (37.718912802856, -122.428395868697) | ||
| 86619 | 86619 | 68002 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 319 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31727 | 5992442.5315274 | 2089981.57315011 | 37.7182573914808 | -122.468129512391 | (37.7182573914808, -122.468129512391) | ||
| 183426 | 183426 | 212632 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 319 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992190.56348 | 2089982.3550900002 | 37.718244983411296 | -122.46900050817499 | (37.7182449834113, -122.469000508175) | |||
| 64919 | 64919 | 212620 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 119 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5991404.09674 | 2089992.6496299999 | 37.7182277775561 | -122.47171971359501 | (37.7182277775561, -122.471719713595) | |||
| 47186 | 47186 | 200490 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1088 Jamestown Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 6013545.6611 | 2089994.9439 | 37.7194902878281 | -122.39518533478001 | (37.7194902878281, -122.39518533478) | |||
| 34956 | 34956 | 212607 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 11 Miramar Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5995300.7051800005 | 2090004.7098400001 | 37.7184855727191 | -122.458251756207 | (37.7184855727191, -122.458251756207) | |||
| 116437 | 116437 | 212623 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 222 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5991708.59487 | 2090008.3257099998 | 37.71828843323971 | -122.470668344073 | (37.7182884332397, -122.470668344073) | |||
| 146415 | 146415 | 212619 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 123 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991404.11082 | 2090016.7036 | 37.718293824675996 | -122.47172141691799 | (37.718293824676, -122.471721416918) | |||
| 76611 | 76611 | 212656 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993265.19823 | 2090019.9682900002 | 37.7184102922832 | -122.46528871291201 | (37.7184102922832, -122.465288712912) | |||
| 104932 | 104932 | 45356 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 426 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2001 12:00:00 AM | Permit Number 44181 | 5993274.56615099 | 2090020.51787313 | 37.7184123415446 | -122.465256372075 | (37.7184123415446, -122.465256372075) | ||
| 23580 | 23580 | 212649 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 321 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992450.10328 | 2090020.5964400002 | 37.7183649772426 | -122.468106177365 | (37.7183649772426, -122.468106177365) | |||
| 92106 | 92106 | 68003 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 327 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31728 | 5992443.22144719 | 2090030.89079527 | 37.718392845598004 | -122.468130713203 | (37.718392845598, -122.468130713203) | ||
| 125624 | 125624 | 45317 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 630 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44154 | 5993535.31460225 | 2090042.0802023998 | 37.718486580043 | -122.46435664513399 | (37.718486580043, -122.464356645134) | ||
| 73618 | 73618 | 212624 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 226 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991707.41959 | 2090046.15057 | 37.7183922230931 | -122.47067516002599 | (37.7183922230931, -122.470675160026) | |||
| 134154 | 134154 | 200494 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3239 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6013526.9457 | 2090055.2492 | 37.7196548333297 | -122.39525424966499 | (37.7196548333297, -122.395254249665) | |||
| 187506 | 187506 | 212614 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 511 Mount Vernon Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997779.607340001 | 2090076.68387 | 37.7188253303138 | -122.449688439586 | (37.7188253303138, -122.449688439586) | |||
| 37053 | 37053 | 218147 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 33 Ashton Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 8 | 5994130.90264 | 2090096.18725 | 37.7186694580143 | -122.462301880921 | (37.7186694580143, -122.462301880921) | ||||
| 132317 | 132317 | 71316 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 558 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 13 | 6003372.2866 | 2090101.06042 | 37.7192106439431 | -122.43035851582701 | (37.7192106439431, -122.430358515827) | ||
| 109953 | 109953 | 67977 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 31 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | Permit Number 31701 | 5996184.66753333 | 2090103.76165833 | 37.71880830123929 | -122.45520343579099 | (37.7188083012393, -122.455203435791) | ||
| 157855 | 157855 | 212625 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 239 Monticello St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5991672.936319999 | 2090117.5673599998 | 37.71858632198371 | -122.470799552451 | (37.7185863219837, -122.470799552451) | |||
| 178332 | 178332 | 212633 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 338 Ralston St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5992228.533869999 | 2090118.36082 | 37.7186206158303 | -122.468879153643 | (37.7186206158303, -122.468879153643) | |||
| 175920 | 175920 | 196268 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1121 Jamestown Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013281.01333 | 2090127.7740900002 | 37.719840291665896 | -122.396109435604 | (37.7198402916659, -122.396109435604) | ||||
| 174187 | 174187 | 212635 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 343 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992191.77345 | 2090130.53473 | 37.7186519185263 | -122.46900710379299 | (37.7186519185263, -122.469007103793) |
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");