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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
143946 | 143946 | 47346 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 752 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45273 | 5993544.85331051 | 2090864.0101395 | 37.7207439512448 | -122.464383317404 | (37.7207439512448, -122.464383317404) | ||
109783 | 109783 | 45351 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 455 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44765 | 5992454.32883637 | 2090891.06433755 | 37.7207553141827 | -122.46815485821001 | (37.7207553141827, -122.46815485821) | ||
133064 | 133064 | 178900 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1128 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6009581.67769 | 2090926.3916900002 | 37.721826605402 | -122.40895311598699 | (37.721826605402, -122.408953115987) | |||
138659 | 138659 | 50492 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 482 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47128 | 6002953.58784191 | 2090964.55788787 | 37.7215578906721 | -122.43186742076999 | (37.7215578906721, -122.43186742077) | ||
185705 | 185705 | 178890 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 482 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002959.70968 | 2090965.8257900001 | 37.721561719087795 | -122.431846349732 | (37.7215617190878, -122.431846349732) | |||
189022 | 189022 | 43336 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 423 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 6 | Permit Number 43093 | 6003416.5357 | 2091104.1943299999 | 37.7219675345615 | -122.430277093028 | (37.7219675345615, -122.430277093028) | |
153169 | 153169 | 214417 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 182 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5994480.563080001 | 2091128.3543599998 | 37.7215236696771 | -122.461168031889 | (37.7215236696771, -122.461168031889) | |||
129270 | 129270 | 43334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 358 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | Permit Number 43091 | 6004071.746453701 | 2091218.44428208 | 37.722318330594604 | -122.428020331334 | (37.7223183305946, -122.428020331334) | ||
94018 | 94018 | 44526 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 22 Bruce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | Permit Number 43830 | 5997256.62964554 | 2091315.67270028 | 37.722197369742204 | -122.45158547844 | (37.7221973697422, -122.45158547844) | |||
163157 | 163157 | 178893 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 377 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002334.05893 | 2091412.9256900002 | 37.7227538684718 | -122.43404099680201 | (37.7227538684718, -122.434040996802) | |||
93423 | 93423 | 67988 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 229 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31712 | 5995619.71812081 | 2091466.36929796 | 37.7225172692023 | -122.457254747849 | (37.7225172692023, -122.457254747849) | ||
145257 | 145257 | 48941 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1343 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46128 | 6011661.44049501 | 2091503.35733972 | 37.7235271168325 | -122.401804405977 | (37.7235271168325, -122.401804405977) | ||
88065 | 88065 | 34303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1219 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38091 | 6011656.31212487 | 2091520.16541192 | 37.7235729821535 | -122.40182331486 | (37.7235729821535, -122.40182331486) | ||
106934 | 106934 | 48938 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1213 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46126 | 6011656.06397948 | 2091520.97870067 | 37.7235752014293 | -122.40182422980101 | (37.7235752014293, -122.401824229801) | ||
95411 | 95411 | 48937 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1211 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47623 | 6011655.9812658 | 2091521.24979215 | 37.7235759411749 | -122.401824534776 | (37.7235759411749, -122.401824534776) | ||
82524 | 82524 | 46639 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 670 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2002 12:00:00 AM | Permit Number 44768 | 5993413.9529017 | 2091571.4332661 | 37.7226788173129 | -122.46488714503201 | (37.7226788173129, -122.464887145032) | |||
87438 | 87438 | 46637 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 670 Victoria St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2002 12:00:00 AM | Permit Number 44768 | 5993413.9529017 | 2091571.4332661 | 37.7226788173129 | -122.46488714503201 | (37.7226788173129, -122.464887145032) | |||
88018 | 88018 | 46638 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 670 Victoria St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2002 12:00:00 AM | Permit Number 44768 | 5993413.9529017 | 2091571.4332661 | 37.7226788173129 | -122.46488714503201 | (37.7226788173129, -122.464887145032) | |||
143757 | 143757 | 45440 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 670 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/2001 12:00:00 AM | Permit Number 44227 | 5993413.9529017 | 2091571.4332661 | 37.7226788173129 | -122.46488714503201 | (37.7226788173129, -122.464887145032) | ||
172415 | 172415 | 178930 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999988.7456 | 2091602.04327 | 37.723139760387504 | -122.442161785857 | (37.7231397603875, -122.442161785857) | |||
136058 | 136058 | 178931 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000005.37826 | 2091604.23935 | 37.7231467382161 | -122.44210444775801 | (37.7231467382161, -122.442104447758) | |||
132335 | 132335 | 43320 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 283 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 4 | Permit Number 43083 | 6004355.20098 | 2091606.0340900002 | 37.7233985996382 | -122.427068088028 | (37.7233985996382, -122.427068088028) | |
61894 | 61894 | 178932 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000025.30894 | 2091607.27425 | 37.7231562071699 | -122.44203576925501 | (37.7231562071699, -122.442035769255) | |||
25621 | 25621 | 178933 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000047.59686 | 2091609.71589 | 37.723164181455004 | -122.441958899679 | (37.723164181455, -122.441958899679) | |||
86381 | 86381 | 178934 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000059.66319 | 2091611.4621 | 37.7231696637395 | -122.441917314134 | (37.7231696637395, -122.441917314134) | |||
46811 | 46811 | 178935 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000079.03218 | 2091613.78256 | 37.7231771388895 | -122.44185052598 | (37.7231771388895, -122.44185052598) | |||
87038 | 87038 | 49405 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 288@ OCEAN Onondaga Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | Permit Number 46355 | 5999928.15335168 | 2091616.69162038 | 37.7231765280064 | -122.44237229181101 | (37.7231765280064, -122.442372291811) | |||
92286 | 92286 | 49407 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 288@ OCEAN Onondaga Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | Permit Number 46355 | 5999928.15335168 | 2091616.69162038 | 37.7231765280064 | -122.44237229181101 | (37.7231765280064, -122.442372291811) | |||
106418 | 106418 | 49406 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 288@ OCEAN Onondaga Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | Permit Number 46355 | 5999928.15335168 | 2091616.69162038 | 37.7231765280064 | -122.44237229181101 | (37.7231765280064, -122.442372291811) | |||
157657 | 157657 | 178938 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 721 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004184.355719999 | 2091630.4786 | 37.7234560564279 | -122.427660409419 | (37.7234560564279, -122.427660409419) | |||
138713 | 138713 | 178892 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 334 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002432.46703 | 2091647.79412 | 37.723404349001605 | -122.43371759969901 | (37.7234043490016, -122.433717599699) | |||
103451 | 103451 | 45442 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 681 Victoria St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44769 | 5993403.20841917 | 2091649.07320251 | 37.7228913782095 | -122.464929921893 | (37.7228913782095, -122.464929921893) | ||
143463 | 143463 | 45441 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 681 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44769 | 5993403.20841917 | 2091649.07320251 | 37.7228913782095 | -122.464929921893 | (37.7228913782095, -122.464929921893) | ||
140485 | 140485 | 45444 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 685 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44774 | 5993415.59875518 | 2091668.68191392 | 37.7229459333721 | -122.464888514787 | (37.7229459333721, -122.464888514787) | ||
143059 | 143059 | 45443 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 685 Victoria St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44774 | 5993415.59875518 | 2091668.68191392 | 37.7229459333721 | -122.464888514787 | (37.7229459333721, -122.464888514787) | ||
135454 | 135454 | 178949 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1555 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006996.74886 | 2091707.17834 | 37.723825340541204 | -122.417943890293 | (37.7238253405412, -122.417943890293) | |||
129281 | 129281 | 62182 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 15 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1985 12:00:00 AM | Permit Number 22299 | 6000249.38294622 | 2091710.97820224 | 37.7234537213114 | -122.44126862873001 | (37.7234537213114, -122.44126862873) | ||
56362 | 56362 | 69494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 368 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 4 | Permit Number 33617 | 5999712.35805 | 2091715.6264799999 | 37.7234358783342 | -122.443125353647 | (37.7234358783342, -122.443125353647) | |
188281 | 188281 | 178950 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 609 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007192.0962 | 2091723.76737 | 37.723881882739704 | -122.417269780083 | (37.7238818827397, -122.417269780083) | |||
76233 | 76233 | 108192 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 603 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007188.43841 | 2091737.3666 | 37.7239190175192 | -122.417283387741 | (37.7239190175192, -122.417283387741) | |||
98221 | 98221 | 62778 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 359 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23133 | 5999779.18606698 | 2091746.98091779 | 37.7235257806679 | -122.442896592659 | (37.7235257806679, -122.442896592659) | ||
117722 | 117722 | 39200 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 37 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40851 | 6000146.50552582 | 2091764.31450516 | 37.7235943096691 | -122.44162808198 | (37.7235943096691, -122.44162808198) | ||
158371 | 158371 | 178951 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1485 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007220.074 | 2091773.1745900002 | 37.7240191183805 | -122.417176564472 | (37.7240191183805, -122.417176564472) | |||
175403 | 175403 | 178952 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1485 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007251.31205 | 2091779.98256 | 37.7240395689419 | -122.41706906129 | (37.7240395689419, -122.41706906129) | |||
84180 | 84180 | 62175 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 47 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1985 12:00:00 AM | Permit Number 22291 | 6000099.74307909 | 2091788.55827035 | 37.7236582130811 | -122.44179147021099 | (37.7236582130811, -122.441791470211) | ||
49641 | 49641 | 178953 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1433 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007354.96805 | 2091814.90318 | 37.7241412840743 | -122.416713210345 | (37.7241412840743, -122.416713210345) | |||
182343 | 182343 | 178937 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6004445.3973900005 | 2091822.37508 | 37.723997724407795 | -122.426771694853 | (37.7239977244078, -122.426771694853) | ||||
26064 | 26064 | 43329 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 4 | Permit Number 43087 | 6003232.20541 | 2091824.6572900002 | 37.7239353231315 | -122.43096566975402 | (37.7239353231315, -122.430965669754) | |
49485 | 49485 | 178954 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1423 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007391.99195 | 2091825.5129900002 | 37.7241724986518 | -122.41658597517599 | (37.7241724986518, -122.416585975176) | |||
69389 | 69389 | 178955 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1403 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007439.9050900005 | 2091839.2314400002 | 37.724212861121295 | -122.41642131738999 | (37.7242128611213, -122.41642131739) | |||
30791 | 30791 | 178956 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1393 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007451.98675 | 2091842.9041799998 | 37.724223625092 | -122.416379812775 | (37.724223625092, -122.416379812775) | |||
162426 | 162426 | 178957 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1383 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007486.28826 | 2091855.13775 | 37.7242591447243 | -122.41626210321002 | (37.7242591447243, -122.41626210321) | |||
187060 | 187060 | 178958 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007547.64809 | 2091871.91329 | 37.7243086569025 | -122.41605117804 | (37.7243086569025, -122.41605117804) | |||
177949 | 177949 | 178959 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1333 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007585.1415 | 2091886.2374099998 | 37.7243500958617 | -122.41592258217399 | (37.7243500958617, -122.415922582174) | |||
73742 | 73742 | 178960 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1323 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6007600.028630001 | 2091890.26579 | 37.7243619938904 | -122.415871404438 | (37.7243619938904, -122.415871404438) | |||
83505 | 83505 | 62168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 72 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/06/1985 12:00:00 AM | Permit Number 22284 | 6000004.62747849 | 2091896.44349016 | 37.7239490209961 | -122.442128007983 | (37.7239490209961, -122.442128007983) | ||
70668 | 70668 | 178961 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1313 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007631.35752 | 2091897.4568599998 | 37.7243835002773 | -122.415763613493 | (37.7243835002773, -122.415763613493) | |||
53425 | 53425 | 214415 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 20 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995229.56815 | 2091906.8040099998 | 37.7237041820879 | -122.458635267605 | (37.7237041820879, -122.458635267605) | |||
158113 | 158113 | 65196 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 326 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 4 | Permit Number 27181 | 6003265.18452 | 2091962.93655 | 37.7243168758021 | -122.43086153005501 | (37.7243168758021, -122.430861530055) | |
110342 | 110342 | 51519 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1225 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | Permit Number 47822 | 5995038.52615382 | 2091975.35473544 | 37.7238814240936 | -122.45930062456101 | (37.7238814240936, -122.459300624561) | |||
95670 | 95670 | 68086 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 848 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31825 | 6001069.78392059 | 2092016.09827478 | 37.7243382114504 | -122.43845450853998 | (37.7243382114504, -122.43845450854) | ||
102699 | 102699 | 66253 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 536 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29354 | 5994796.549278201 | 2092045.80641292 | 37.7240609523315 | -122.460142195142 | (37.7240609523315, -122.460142195142) | ||
106265 | 106265 | 62485 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 294 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22656 | 5999878.28397028 | 2092047.35169708 | 37.724356179134205 | -122.442575585932 | (37.7243561791342, -122.442575585932) | ||
155831 | 155831 | 178936 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 275 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003706.73664 | 2092066.2006299999 | 37.7246254242075 | -122.429342507659 | (37.7246254242075, -122.429342507659) | |||
109914 | 109914 | 45392 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 321 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44757 | 5994154.29510802 | 2092092.46668837 | 37.7241521077919 | -122.462365734931 | (37.7241521077919, -122.462365734931) | ||
120338 | 120338 | 45393 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 321 Ashton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44757 | 5994154.29510802 | 2092092.46668837 | 37.7241521077919 | -122.462365734931 | (37.7241521077919, -122.462365734931) | ||
111304 | 111304 | 43319 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 275 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2013 12:00:00 AM | 3x3 | Permit Number 770290 | 6003728.19858152 | 2092097.28955871 | 37.7247120025434 | -122.429270532313 | (37.7247120025434, -122.429270532313) | |
157893 | 157893 | 214416 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 539 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994748.7087900005 | 2092127.64393 | 37.724282906628794 | -122.46031349786399 | (37.7242829066288, -122.460313497864) | |||
93452 | 93452 | 46779 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 91 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44870 | 6001525.5890631 | 2092130.31455081 | 37.724677740092 | -122.43688703011601 | (37.724677740092, -122.436887030116) | ||
142993 | 142993 | 62195 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 105 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1985 12:00:00 AM | Permit Number 22314 | 6000493.57908868 | 2092148.88322612 | 37.7246700159736 | -122.440455881068 | (37.7246700159736, -122.440455881068) | ||
49913 | 49913 | 199985 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018147.7753 | 2092169.4169 | 37.725715836336896 | -122.379428312297 | (37.7257158363369, -122.379428312297) | |||
90954 | 90954 | 40399 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41505 | 5995604.87049652 | 2092238.79242045 | 37.7246373060188 | -122.457361926036 | (37.7246373060188, -122.457361926036) | ||
122690 | 122690 | 40398 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41505 | 5995604.87049652 | 2092238.79242045 | 37.7246373060188 | -122.457361926036 | (37.7246373060188, -122.457361926036) | ||
141213 | 141213 | 52530 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 San Juan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48628 | 6001389.835788901 | 2092264.63848184 | 37.725038846492794 | -122.43736592524701 | (37.7250388464928, -122.437365925247) | ||
127195 | 127195 | 38189 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 541 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/16/2013 12:00:00 AM | Permit Number 770070 | 6011097.98403945 | 2092306.25144746 | 37.7257002373273 | -122.403808654284 | (37.7257002373273, -122.403808654284) | ||
42734 | 42734 | 178927 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 169 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000613.31177 | 2092308.08767 | 37.7251139719271 | -122.440053391844 | (37.7251139719271, -122.440053391844) | |||
127980 | 127980 | 43280 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 731 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43050 | 6009363.88058907 | 2092426.70066476 | 37.725933936273606 | -122.409811838204 | (37.7259339362736, -122.409811838204) | ||
113424 | 113424 | 36445 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1263 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46501 | 5995833.83744398 | 2092429.73059369 | 37.725174725138295 | -122.456584222912 | (37.7251747251383, -122.456584222912) | ||
110676 | 110676 | 49130 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 145 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46259 | 5995112.54626124 | 2092443.49915855 | 37.725171091693 | -122.459078632454 | (37.725171091693, -122.459078632454) | ||
106577 | 106577 | 40409 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 132 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41511 | 5995166.097552099 | 2092475.68358203 | 37.7252625407548 | -122.458895841519 | (37.7252625407548, -122.458895841519) | ||
115757 | 115757 | 40410 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 132 Southwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41511 | 5995166.097552099 | 2092475.68358203 | 37.7252625407548 | -122.458895841519 | (37.7252625407548, -122.458895841519) | ||
134121 | 134121 | 37055 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 283 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 8 | Permit Number 39660 | 6006018.75197 | 2092482.1087099998 | 37.7258980404498 | -122.421379675536 | (37.7258980404498, -122.421379675536) | |
116365 | 116365 | 62497 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 130 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22669 | 6000642.74847109 | 2092487.44183284 | 37.7256081131818 | -122.439964486743 | (37.7256081131818, -122.439964486743) | ||
83314 | 83314 | 36446 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1266 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39349 | 5995876.3540718 | 2092492.32516722 | 37.7253490358477 | -122.456441772407 | (37.7253490358477, -122.456441772407) | ||
56274 | 56274 | 45450 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 191 Corona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44761 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
95071 | 95071 | 46636 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 191 Corona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44761 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
128208 | 128208 | 45397 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 191 Corona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2001 12:00:00 AM | Permit Number 44207 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | |||
171275 | 171275 | 199981 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200x Shafter Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6017028.9443 | 2092601.7798 | 37.7268412531355 | -122.38332614590799 | (37.7268412531355, -122.383326145908) | |||
83203 | 83203 | 178962 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 217 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007226.63785 | 2092632.02114 | 37.7263776956646 | -122.417214704709 | (37.7263776956646, -122.417214704709) | |||
85266 | 85266 | 66577 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 177 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | Permit Number 29767 | 6004072.09609947 | 2092646.38340828 | 37.726239155496394 | -122.428120833876 | (37.7262391554964, -122.428120833876) | ||
127658 | 127658 | 68264 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 381 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32070 | 6009731.82582651 | 2092664.31257859 | 37.72660698205 | -122.408556624594 | (37.72660698205, -122.408556624594) | ||
80535 | 80535 | 37888 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1301 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1998 12:00:00 AM | Permit Number 40164 | 5995819.25622169 | 2092686.22988595 | 37.725878173698796 | -122.45665316971001 | (37.7258781736988, -122.45665316971) | |||
104578 | 104578 | 37887 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1301 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40164 | 5995819.25622169 | 2092686.22988595 | 37.725878173698796 | -122.45665316971001 | (37.7258781736988, -122.45665316971) | ||
138307 | 138307 | 37889 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1301 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1998 12:00:00 AM | Permit Number 40164 | 5995819.25622169 | 2092686.22988595 | 37.725878173698796 | -122.45665316971001 | (37.7258781736988, -122.45665316971) | |||
83263 | 83263 | 36386 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
90511 | 90511 | 36385 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
98369 | 98369 | 36387 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
120418 | 120418 | 36384 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
140611 | 140611 | 62494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 84 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22666 | 6000764.49636206 | 2092702.9660143002 | 37.7262068231921 | -122.439559058681 | (37.7262068231921, -122.439559058681) | ||
78957 | 78957 | 49137 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) |
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");