trees
268 rows where qSpecies_id = 77 sorted by qAddress descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
152123 | 43636 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 375 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2000 12:00:00 AM | Permit Number 43286 | 6006792.72953639 | 2101606.12998031 | 37.750994184096 | -122.419351056484 | (37.750994184096, -122.419351056484) | 2 | 4 | 7 | 28859 | 19 | ||
165888 | 238583 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3726 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005678.26698 | 2100537.88452 | 37.7479981962719 | -122.423129060168 | (37.7479981962719, -122.423129060168) | 2 | 4 | 5 | 28859 | 19 | |||
135030 | 84901 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3710 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2007 12:00:00 AM | 5 | Permit No. 49300 | 5996951.85595 | 2115692.33884 | 37.7891121155896 | -122.454398994017 | (37.7891121155896, -122.454398994017) | 11 | 6 | 1 | 54 | 31 | ||
43837 | 124379 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 37 Jordan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5996169.18438 | 2114263.97819 | 37.785145303794 | -122.457003563892 | (37.785145303794, -122.457003563892) | 11 | 6 | 1 | 54 | 31 | |||
102636 | 124378 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 37 Jordan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5996168.03045 | 2114275.5227 | 37.7851769356666 | -122.457008391438 | (37.7851769356666, -122.457008391438) | 11 | 6 | 1 | 54 | 31 | |||
100212 | 238582 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3456 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006754.5466 | 2100607.36077 | 37.7482496404132 | -122.41941224938 | (37.7482496404132, -122.41941224938) | 2 | 4 | 7 | 28859 | 19 | |||
48308 | 136039 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3434 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999787.69729 | 2120389.72868 | 37.8021721279018 | -122.44492518757 | (37.8021721279018, -122.44492518757) | 13 | 9 | 1 | 57 | 17 | |||
15965 | 136043 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3425 Jackson St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5997844.87788 | 2116098.17267 | 37.7902776009696 | -122.451338548042 | (37.7902776009696, -122.451338548042) | 11 | 6 | 1 | 54 | 31 | |||
83158 | 57747 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3425 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1977 12:00:00 AM | 8 | Permit Number 16667 | 5997831.65027 | 2116097.2527 | 37.7902743175622 | -122.45138424801 | (37.7902743175622, -122.45138424801) | 11 | 6 | 1 | 54 | 31 | ||
182334 | 41184 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3414 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | 4 | Permit Number 41902 | 5999801.39213 | 2120297.1759 | 37.8019187843817 | -122.4448711401 | (37.8019187843817, -122.4448711401) | 13 | 9 | 1 | 57 | 17 | |
118474 | 136041 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3399 Jackson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 5998034.28644 | 2116116.08829 | 37.7903376361102 | -122.450684503481 | (37.7903376361102, -122.450684503481) | 13 | 6 | 1 | 54 | 31 | |||
158227 | 136042 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3399 Jackson St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5998049.07867 | 2116118.00061 | 37.7903437335326 | -122.450633461567 | (37.7903437335326, -122.450633461567) | 13 | 6 | 1 | 54 | 31 | |||
139200 | 44049 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3388 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43579 | 6006265.44420171 | 2106129.68857398 | 37.7633851144388 | -122.421495691304 | (37.7633851144388, -122.421495691304) | 8 | 4 | 7 | 28859 | 19 | |||
143199 | 44048 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3388 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43579 | 6006265.44420171 | 2106129.68857398 | 37.7633851144388 | -122.421495691304 | (37.7633851144388, -122.421495691304) | 8 | 4 | 7 | 28859 | 19 | |||
188992 | 44050 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3388 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43579 | 6006265.44420171 | 2106129.68857398 | 37.7633851144388 | -122.421495691304 | (37.7633851144388, -122.421495691304) | 8 | 4 | 7 | 28859 | 19 | |||
106048 | 61899 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 335 Maple St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1985 12:00:00 AM | 5 | Permit Number 21942 | 5996649.71832 | 2115128.18725 | 37.7875457744774 | -122.455403556547 | (37.7875457744774, -122.455403556547) | 11 | 6 | 1 | 54 | 31 | ||
21481 | 41610 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
83140 | 41607 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
84425 | 41604 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
147009 | 41609 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
140665 | 246630 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3320 Harrison St | 1 | Front Yard : Yard | Tree | Private 2 | 1 | 6009028.43524 | 2099278.75412 | 37.7447293908617 | -122.411455327621 | (37.7447293908617, -122.411455327621) | 2 | 7 | 7 | 28859 | 2 | ||||
97109 | 239025 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 323 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6006919.22148 | 2096314.31292 | 37.7364711647048 | -122.41853842942 | (37.7364711647048, -122.41853842942) | 2 | 7 | 7 | 28859 | 2 | |||
149200 | 96001 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 321 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767651 | 6013592.98879 | 2094402.89056 | 37.73159625106 | -122.395330363713 | (37.73159625106, -122.395330363713) | 10 | 3 | 8 | 58 | 1 |
180557 | 96000 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 315 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767650 | 6013581.92641 | 2094423.84152 | 37.7316531628455 | -122.395370075974 | (37.7316531628455, -122.395370075974) | 10 | 3 | 8 | 58 | 1 |
166572 | 213719 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 306 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993051.46655 | 2103255.88389 | 37.754740477507 | -122.466989225694 | (37.754740477507, -122.466989225694) | 1 | 8 | 4 | 56 | 12 | |||
158219 | 136036 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2901 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001479.25997 | 2118476.71669 | 37.7970158955175 | -122.438934404121 | (37.7970158955175, -122.438934404121) | 13 | 9 | 1 | 57 | 17 | |||
181865 | 213730 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 290 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992101.64901 | 2095002.48097 | 37.732023872387 | -122.469673110237 | (37.732023872387, -122.469673110237) | 9 | 8 | 4 | 59 | 40 | |||
174724 | 136037 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2810 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001581.50265 | 2118066.63071 | 37.7958957233673 | -122.438551222785 | (37.7958957233673, -122.438551222785) | 13 | 9 | 1 | 57 | 17 | |||
56637 | 239007 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2801 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009827.40599 | 2104524.43186 | 37.7591776380486 | -122.409062693893 | (37.7591776380486, -122.409062693893) | 2 | 4 | 7 | 28859 | 19 | |||
119873 | 239006 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2801 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009817.72923 | 2104524.2582 | 37.7591766191261 | -122.409096148662 | (37.7591766191261, -122.409096148662) | 2 | 4 | 7 | 28859 | 19 | |||
162524 | 239008 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2801 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009837.36864 | 2104524.2797 | 37.7591777783485 | -122.409028227385 | (37.7591777783485, -122.409028227385) | 2 | 4 | 7 | 28859 | 19 | |||
135365 | 124512 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2656 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5996425.61433 | 2110792.8133 | 37.7756291250409 | -122.455865383128 | (37.7756291250409, -122.455865383128) | 11 | 6 | 2 | 54 | 16 | |||
181473 | 46559 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2631 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | 1 | Permit Number 44696 | 5989232.26129309 | 2097435.52728728 | 37.7385381283555 | -122.479771060435 | (37.7385381283555, -122.479771060435) | 1 | 8 | 3 | 29491 | 35 | ||
33456 | 239029 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 26 Harry St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003326.30087 | 2097748.91757 | 37.7402073325128 | -122.431063031234 | (37.7402073325128, -122.431063031234) | 2 | 7 | 5 | 63 | 7 | |||
35888 | 239027 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 26 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6003403.2403 | 2097795.09814 | 37.740338493218 | -122.430800300593 | (37.740338493218, -122.430800300593) | 2 | 7 | 5 | 63 | 7 | ||||
67181 | 239028 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 26 Harry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6003397.86036 | 2097787.1303 | 37.7403163105472 | -122.430818333806 | (37.7403163105472, -122.430818333806) | 2 | 7 | 5 | 63 | 7 | ||||
3654 | 47498 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
14337 | 47497 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
37380 | 47499 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
41965 | 47508 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
55306 | 47505 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
60987 | 47504 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
62744 | 47503 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
101900 | 47502 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
104730 | 47500 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
125981 | 47506 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
134097 | 47496 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
169847 | 47509 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
172511 | 47507 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
191629 | 47501 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
75784 | 82345 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 254 Dublin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 1 | 3x3 | Permit Number 774176 | 6003940.30685 | 2088972.31262 | 37.7161435078943 | -122.428314680584 | (37.7161435078943, -122.428314680584) | 9 | 7 | 6 | 28861 | 5 | |
26148 | 250147 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5999210.3991 | 2117472.66602 | 37.7941296904761 | -122.446712900392 | (37.7941296904761, -122.446712900392) | 11 | 1 | 57 | 30 | |||||
57531 | 250151 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 5999220.87756 | 2117406.81737 | 37.7939494861264 | -122.446671903881 | (37.7939494861264, -122.446671903881) | 11 | 1 | 57 | 30 | |||||
88103 | 250148 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | 5999211.58041 | 2117458.26171 | 37.7940902075462 | -122.446707776048 | (37.7940902075462, -122.446707776048) | 11 | 1 | 57 | 30 | |||||
137971 | 250150 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | 5999218.59352 | 2117421.61343 | 37.7939899817095 | -122.446680871938 | (37.7939899817095, -122.446680871938) | 11 | 1 | 57 | 30 | |||||
152580 | 250149 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 4 | Front Yard : Yard | Tree | Private 2 | 6 | 5999215.63832 | 2117439.7417 | 37.794039588317 | -122.446692402146 | (37.794039588317, -122.446692402146) | 11 | 1 | 57 | 30 | |||||
193715 | 250146 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 5999207.44391 | 2117490.79429 | 37.7941792970798 | -122.446724430609 | (37.7941792970798, -122.446724430609) | 11 | 1 | 57 | 30 | |||||
22945 | 250158 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 5 | Side Yard : Yard | Tree | Private 2 | 7 | 5999254.28786 | 2117464.37854 | 37.7941094422474 | -122.446560444632 | (37.7941094422474, -122.446560444632) | 13 | 9 | 1 | 57 | 27 | ||||
84577 | 250155 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 5999259.65981 | 2117410.03204 | 37.7939605280209 | -122.446537945371 | (37.7939605280209, -122.446537945371) | 13 | 9 | 1 | 57 | 27 | ||||
103407 | 250156 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 3 | Side Yard : Yard | Tree | Private 2 | 5 | 5999256.55789 | 2117425.58205 | 37.7940030470443 | -122.446549797562 | (37.7940030470443, -122.446549797562) | 13 | 9 | 1 | 57 | 27 | ||||
124228 | 250157 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 4 | Side Yard : Yard | Tree | Private 2 | 7 | 5999256.81946 | 2117443.67812 | 37.7940527489909 | -122.446550195053 | (37.7940527489909, -122.446550195053) | 13 | 9 | 1 | 57 | 27 | ||||
146504 | 250159 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 6 | Side Yard : Yard | Tree | Private 2 | 8 | 5999252.38937 | 2117479.90418 | 37.7941519630933 | -122.446568131123 | (37.7941519630933, -122.446568131123) | 13 | 9 | 1 | 57 | 27 | ||||
184216 | 250154 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2500 Lyon St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 5999263.26744 | 2117392.55411 | 37.7939127443244 | -122.446524204627 | (37.7939127443244, -122.446524204627) | 13 | 9 | 1 | 57 | 27 | ||||
26278 | 239005 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 250 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6005423.80449 | 2102247.03404 | 37.7526767636284 | -122.424130513718 | (37.7526767636284, -122.424130513718) | 2 | 4 | 5 | 28859 | 19 | |||
90248 | 249642 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2460 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 11 | 5999289.16084 | 2117209.34278 | 37.7934111735351 | -122.446421424722 | (37.7934111735351, -122.446421424722) | 13 | 9 | 1 | 57 | 27 | ||||
184368 | 249641 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2460 Lyon St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 5999290.35855 | 2117187.34 | 37.7933508281386 | -122.446415696946 | (37.7933508281386, -122.446415696946) | 13 | 9 | 1 | 57 | 27 | ||||
16844 | 249665 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 17 | Front Yard : Yard | Tree | Private 2 | 9 | 5999244.57563 | 2117118.96584 | 37.7931604758161 | -122.44656918694 | (37.7931604758161, -122.44656918694) | 11 | 1 | 57 | 30 | |||||
67120 | 249663 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 15 | Front Yard : Yard | Tree | Private 2 | 9 | 5999240.36151 | 2117161.61527 | 37.7932773391397 | -122.446586837907 | (37.7932773391397, -122.446586837907) | 11 | 1 | 57 | 30 | |||||
116012 | 249662 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 14 | Front Yard : Yard | Tree | Private 2 | 12 | 5999235.55005 | 2117182.17249 | 37.7933335089853 | -122.446604965544 | (37.7933335089853, -122.446604965544) | 11 | 1 | 57 | 30 | |||||
130390 | 249661 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 13 | Front Yard : Yard | Tree | Private 2 | 9 | 5999232.65842 | 2117208.86838 | 37.7934066436505 | -122.446616892353 | (37.7934066436505, -122.446616892353) | 11 | 1 | 57 | 30 | |||||
133564 | 249667 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 19 | Front Yard : Yard | Tree | Private 2 | 12 | 5999247.61227 | 2117079.36111 | 37.7930519051704 | -122.446555829313 | (37.7930519051704, -122.446555829313) | 11 | 1 | 57 | 30 | |||||
145142 | 249664 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 16 | Front Yard : Yard | Tree | Private 2 | 10 | 5999241.54149 | 2117138.79958 | 37.7932147607016 | -122.446581112841 | (37.7932147607016, -122.446581112841) | 11 | 1 | 57 | 30 | |||||
189111 | 249666 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 18 | Front Yard : Yard | Tree | Private 2 | 8 | 5999246.11095 | 2117099.98704 | 37.793108452756 | -122.44656250858 | (37.793108452756, -122.44656250858) | 11 | 1 | 57 | 30 | |||||
121753 | 136038 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6001472.99161 | 2118372.51035 | 37.7967294155856 | -122.438948622379 | (37.7967294155856, -122.438948622379) | 13 | 9 | 1 | 57 | 17 | |||
33567 | 249637 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Lyon St | 3 | Side Yard : Yard | Tree | Private 2 | 7 | 5999297.09837 | 2117106.84322 | 37.7931301902456 | -122.4463865832 | (37.7931301902456, -122.4463865832) | 13 | 9 | 1 | 57 | 27 | ||||
38537 | 249640 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Lyon St | 6 | Side Yard : Yard | Tree | Private 2 | 7 | 5999291.59314 | 2117167.12216 | 37.79329538582 | -122.446409970041 | (37.79329538582, -122.446409970041) | 13 | 9 | 1 | 57 | 27 | ||||
67698 | 249638 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Lyon St | 5 | Side Yard : Yard | Tree | Private 2 | 11 | 5999293.71803 | 2117149.90797 | 37.7932482415769 | -122.446401378842 | (37.7932482415769, -122.446401378842) | 13 | 9 | 1 | 57 | 27 | ||||
123301 | 249636 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Lyon St | 2 | Side Yard : Yard | Tree | Private 2 | 10 | 5999299.54264 | 2117085.08931 | 37.7930705993714 | -122.446376560233 | (37.7930705993714, -122.446376560233) | 13 | 9 | 1 | 57 | 27 | ||||
158964 | 249680 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Baker St | 12 | Front Yard : Yard | Tree | Private 2 | 2 | 5999746.74355 | 2117232.18734 | 37.7935000229554 | -122.444839803216 | (37.7935000229554, -122.444839803216) | 13 | 9 | 1 | 57 | 27 | ||||
59098 | 98408 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 24 19th Ave | 2 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | 3 | Permit Number 768590 | 5989918.49451 | 2114923.36913 | 37.7865948726066 | -122.478677005621 | (37.7865948726066, -122.478677005621) | 11 | 6 | 1 | 55 | 33 | ||
108435 | 98407 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 24 19th Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 02/09/2012 12:00:00 AM | 3 | Permit Number 768590 | 5989919.44776 | 2114906.64899 | 37.7865490191546 | -122.478672484402 | (37.7865490191546, -122.478672484402) | 11 | 6 | 1 | 55 | 33 | ||
180974 | 239003 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2392 Bryant St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6009661.58461 | 2103420.7224 | 37.7561378099155 | -122.409558287803 | (37.7561378099155, -122.409558287803) | 2 | 4 | 7 | 28859 | 19 | |||
163299 | 136049 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2258 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999403.25073 | 2120854.72135 | 37.8034269240649 | -122.446289022013 | (37.8034269240649, -122.446289022013) | 13 | 9 | 1 | 57 | 17 | |||
24773 | 98036 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2242 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2011 12:00:00 AM | Permit Number 768378 | 6002381.4 | 2115984.8 | 37.7902250230638 | -122.43563441767 | (37.7902250230638, -122.43563441767) | 13 | 9 | 1 | 29490 | 27 | |||
140943 | 38818 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 221 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/2005 12:00:00 AM | 4 | Permit Number 47857 | 5994895.35063 | 2113953.79381 | 37.7842203879728 | -122.461388106023 | (37.7842203879728, -122.461388106023) | 11 | 6 | 2 | 54 | 11 | |
19457 | 96917 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2151X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768104 | 5988894.20073 | 2110528.61903 | 37.7744685962766 | -122.481898727171 | (37.7744685962766, -122.481898727171) | 11 | 6 | 2 | 55 | 26 | |
61657 | 246464 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 212 Duncan St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005064.93111 | 2099921.35386 | 37.7462707137301 | -122.425206088515 | (37.7462707137301, -122.425206088515) | 2 | 7 | 5 | 63 | 22 | |||
119039 | 67591 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 210 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 4 | Permit Number 31158 | 6013702.18081 | 2106068.08806 | 37.763632481088 | -122.395769929855 | (37.763632481088, -122.395769929855) | 14 | 3 | 8 | 28856 | 29 | |
76440 | 136047 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 20 Cherry St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5996079.9197 | 2115992.25742 | 37.7898855676012 | -122.457437471381 | (37.7898855676012, -122.457437471381) | 11 | 1 | 54 | 31 | |||||
79306 | 136048 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 20 Cherry St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5996075.48126 | 2116002.11474 | 37.7899123782026 | -122.457453541344 | (37.7899123782026, -122.457453541344) | 11 | 1 | 54 | 31 | |||||
126493 | 84727 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 20 Cherry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | 5 | Permit No. 49296 | 5996090.69151 | 2115989.11998 | 37.7898775717477 | -122.457399975051 | (37.7898775717477, -122.457399975051) | 11 | 1 | 54 | 31 | |||
150831 | 136046 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 20 Cherry St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5996087.67176 | 2116001.00322 | 37.78991002647 | -122.45741128312 | (37.78991002647, -122.45741128312) | 11 | 1 | 54 | 31 | |||||
174624 | 122059 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 20 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5990228.03289 | 2114906.05857 | 37.7865653101026 | -122.47760482414 | (37.7865653101026, -122.47760482414) | 11 | 6 | 1 | 55 | 33 | |||
127131 | 239002 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Mirabel Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007267.34733 | 2099764.86466 | 37.7459652050335 | -122.417579291677 | (37.7459652050335, -122.417579291677) | 2 | 7 | 7 | 28859 | 2 | ||||
90085 | 136045 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Laurel St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5997979.66837 | 2116375.74786 | 37.7910474656235 | -122.45089220822 | (37.7910474656235, -122.45089220822) | 13 | 6 | 1 | 54 | 31 | |||
136645 | 94793 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Laurel St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | 5 | Permit Number 53892 | 5997982.2072 | 2116362.36591 | 37.7910108676939 | -122.450882458672 | (37.7910108676939, -122.450882458672) | 13 | 6 | 1 | 54 | 31 | ||
147580 | 136044 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Laurel St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5997978.05362 | 2116388.40928 | 37.7910821380693 | -122.450898708531 | (37.7910821380693, -122.450898708531) | 13 | 6 | 1 | 54 | 31 | |||
62806 | 52709 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1@ JACKSON Cherry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2006 12:00:00 AM | 8 | Permit Number 48767 | 5996047.33493 | 2115997.05017 | 37.7898968555268 | -122.457550557933 | (37.7898968555268, -122.457550557933) | 11 | 1 | 54 | 31 | |||
64185 | 52711 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1@ JACKSON Cherry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2006 12:00:00 AM | 5 | Permit Number 48767 | 5996055.9612 | 2115990.01738 | 37.7898780408886 | -122.457520202963 | (37.7898780408886, -122.457520202963) | 11 | 1 | 54 | 31 | |||
114222 | 52710 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1@ JACKSON Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2006 12:00:00 AM | 7 | Permit Number 48767 | 5996063.73844 | 2115999.96188 | 37.7899057925288 | -122.457494014373 | (37.7899057925288, -122.457494014373) | 11 | 1 | 54 | 31 |
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) );