trees
349 rows where qSpecies_id = 155
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 939 | 240597 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 601x Powhattan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | 6008567.55649 | 2098119.23198 | 37.7415197374453 | -122.412966995358 | (37.7415197374453, -122.412966995358) | 10 | 7 | 7 | 28859 | 2 | ||||
| 1427 | 260648 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 3891 Sacramento St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
| 1476 | 20456 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 495X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
| 3054 | 109568 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 95 Nordhoff St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 777169 | 6000348.8 | 2095645.6 | 37.7342629464917 | -122.441207129815 | (37.7342629464917, -122.441207129815) | 9 | 7 | 5 | 63 | 40 | ||||
| 3222 | 20014 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY47 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 3904 | 121227 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 4299x 17th St | 3 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
| 4006 | 261988 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1599x Armstrong Ave | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6014700 | 2092264 | 37.7257847940592 | -122.391353711711 | (37.7257847940592, -122.391353711711) | 10 | 3 | 8 | 58 | 1 | ||||
| 4071 | 260649 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 3891 Sacramento St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
| 4559 | 109532 | - 12 | Sequoia sempervirens :: Coast Redwood 155 | 818 Goettingen St | 1 | Back Yard : Yard | Tree | Private 2 | 6010847.3 | 2090865.3 | 37.7217296747854 | -122.404573864697 | (37.7217296747854, -122.404573864697) | 10 | 3 | 7 | 309 | 28 | |||||
| 5239 | 112929 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
| 5806 | 186727 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984865.5297 | 2106265.0899 | 37.7625270363386 | -122.49551994066 | (37.7625270363386, -122.49551994066) | 1 | 8 | 3 | 56 | 35 | |||
| 5904 | 181484 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1400 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984898.4123 | 2105356.9862 | 37.7600355628364 | -122.495339238882 | (37.7600355628364, -122.495339238882) | 1 | 8 | 3 | 56 | 35 | |||
| 6540 | 181386 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984899.2058 | 2104514.6528 | 37.7577227962381 | -122.495274374844 | (37.7577227962381, -122.495274374844) | 1 | 8 | 3 | 56 | 35 | |||
| 7282 | 197588 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1 Jack Balestreri Way | 4 | Front Yard : Yard | Tree | Private 2 | 9 | 6012433.89716 | 2104751.224 | 37.7599460287107 | -122.400064067605 | (37.7599460287107, -122.400064067605) | 10 | 3 | 8 | 28856 | 29 | ||||
| 7510 | 20015 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY47 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 7906 | 262219 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 21X Stillings Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000348 | 2095645 | 37.7342612534616 | -122.441209852629 | (37.7342612534616, -122.441209852629) | 9 | 7 | 5 | 63 | 40 | ||||
| 7947 | 247597 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 900 Tompkins Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6009155.97098 | 2096407.45458 | 37.7368525815689 | -122.41081158571 | (37.7368525815689, -122.41081158571) | 10 | 7 | 7 | 28859 | 2 | |||
| 8497 | 186967 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2800 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985210.5401 | 2096146.418 | 37.7347641193316 | -122.493581077021 | (37.7347641193316, -122.493581077021) | 1 | 8 | 3 | 29491 | 35 | |||
| 8504 | 109669 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 200X GELLERT DR | 33 | Median : Cutout | Tree | DPW 1 | 02/26/2015 01:37:00 PM | 3 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||
| 8551 | 19592 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY4 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
| 8687 | 19815 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY24 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
| 8804 | 240602 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 609 28th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001920.90533 | 2099400.25112 | 37.7446617708226 | -122.436040449628 | (37.7446617708226, -122.436040449628) | 2 | 7 | 5 | 63 | 22 | |||
| 9828 | 372 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
| 9964 | 262274 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Montclair Ter | 1 | Side Yard : Yard | Tree | Private 2 | 6007298.70359 | 2120216.09204 | 37.8021211637502 | -122.418921105258 | (37.8021211637502, -122.418921105258) | 5 | 1 | 1 | 28858 | 32 | |||||
| 10029 | 260896 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 866 Kansas St | 1 | Front Yard : Cutout | Tree | DPW 1 | Private | 3x3 | 6011543 | 2104306 | 37.7586738299336 | -122.403113948893 | (37.7586738299336, -122.403113948893) | 10 | 3 | 8 | 28856 | 29 | |||
| 10552 | 185214 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2500 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985123.3973 | 2098105.6751 | 37.7401386169566 | -122.494026705548 | (37.7401386169566, -122.494026705548) | 1 | 8 | 3 | 29491 | 35 | |||
| 10658 | 97853 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 895 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
| 11754 | 20074 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY55 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 27X | |||||||||||||
| 12165 | 260922 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 866 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 774734 | 6011543 | 2104306 | 37.7586738299336 | -122.403113948893 | (37.7586738299336, -122.403113948893) | 10 | 3 | 8 | 28856 | 29 | |||
| 13310 | 263635 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x10 | 5998173 | 2095582 | 37.733964136305 | -122.448724954929 | (37.733964136305, -122.448724954929) | 9 | 7 | 4 | 59 | 40 | ||||
| 14046 | 262297 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 666 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009767 | 2091318 | 37.722912259595 | -122.408340109411 | (37.722912259595, -122.408340109411) | 9 | 3 | 7 | 309 | 28 | ||||
| 14234 | 111268 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 700X BOSWORTH ST | 6 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 14561 | 378 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
| 16052 | 19578 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY4 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 8 | |||||||||||||
| 16197 | 19811 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY24 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
| 16768 | 19816 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY24 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
| 17000 | 19593 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY4 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
| 17522 | 261989 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1501x Armstrong Ave | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6014836 | 2092075 | 37.7252733848281 | -122.390870362971 | (37.7252733848281, -122.390870362971) | 10 | 3 | 8 | 58 | 1 | ||||
| 18013 | 120281 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 11 | Front Yard : Yard | Tree | Private 2 | 15 | 5988339.23027 | 2115128.35436 | 37.7870658824376 | -122.484155845816 | (37.7870658824376, -122.484155845816) | 11 | 6 | 1 | 55 | 33 | ||||
| 18463 | 262218 | Landmark tree 11 | Sequoia sempervirens :: Coast Redwood 155 | 46 Stillings Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000246 | 2095728 | 37.7344833413152 | -122.441568452522 | (37.7344833413152, -122.441568452522) | 9 | 7 | 5 | 63 | 40 | ||||
| 18780 | 240622 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 5413 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6002024.95508 | 2097832.75898 | 37.7403637147149 | -122.435568550141 | (37.7403637147149, -122.435568550141) | 2 | 7 | 5 | 63 | 7 | ||||
| 19465 | 96173 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767806 | ||||||||||||||
| 19674 | 215042 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 689 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | Width 10ft | 5996876.31142 | 2095244.73411 | 37.732963851 | -122.453183641224 | (37.732963851, -122.453183641224) | 9 | 7 | 4 | 59 | 40 | |||
| 20335 | 114509 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 3X VULCAN STWY | 1 | Front Yard : Yard | Tree | Private 2 | 56 | 6000640 | 2106231 | 37.7633444989385 | -122.440959493883 | (37.7633444989385, -122.440959493883) | 15 | 5 | 5 | 28862 | 3 | ||||
| 21279 | 122585 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 2500X Lyon St | 5 | Median : Cutout | Tree | Private 2 | 70 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
| 22018 | 106361 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1645 WEBSTER ST | 2 | Front Yard : Yard | Tree | Private 2 | 30 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | 13 | 9 | 11 | 29490 | 13 | ||||
| 22478 | 249959 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 273 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 23 | Width 0ft | 6011558.55656 | 2120064.53903 | 37.8019439797819 | -122.404169218243 | (37.8019439797819, -122.404169218243) | 3 | 1 | 10 | 308 | 23 | |||
| 22499 | 200496 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3239 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6013542.8885 | 2090062.874 | 37.7196766561509 | -122.395199674544 | (37.7196766561509, -122.395199674544) | 10 | 3 | 8 | 58 | 1 | |||
| 22679 | 108026 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 862 Kansas St | Front Yard : Yard | Tree | Private 2 | Permit Number 774734 | 6011570 | 2104296 | 37.7586478799274 | -122.403019866682 | (37.7586478799274, -122.403019866682) | 10 | 3 | 8 | 28856 | 29 | |||||
| 22779 | 179498 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 892 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6005545.45161 | 2091807.84398 | 37.7240199601485 | -122.422967943043 | (37.7240199601485, -122.422967943043) | 9 | 7 | 6 | 309 | 5 | ||||
| 22789 | 118610 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 349 Point Lobos Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 5981717.62769 | 2112632.61479 | 37.7798255733952 | -122.506879529548 | (37.7798255733952, -122.506879529548) | 11 | 6 | 2 | 55 | 26 | ||||
| 23199 | 112923 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
| 24751 | 185875 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2000 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985024.3241 | 2101081.1994 | 37.7483028028797 | -122.494588557862 | (37.7483028028797, -122.494588557862) | 1 | 8 | 3 | 29491 | 35 | |||
| 24993 | 240627 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 5413 Diamond Heights Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6002066.06456 | 2097929.88214 | 37.7406327271153 | -122.43543335598 | (37.7406327271153, -122.43543335598) | 2 | 7 | 5 | 63 | 7 | ||||
| 25282 | 240601 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 609 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001917.09097 | 2099400.07719 | 37.744661076553 | -122.436053626473 | (37.744661076553, -122.436053626473) | 2 | 7 | 5 | 63 | 22 | |||
| 25852 | 215035 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 639 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 5997171.50868 | 2094376.6234 | 37.7305971411271 | -122.452100459987 | (37.7305971411271, -122.452100459987) | 9 | 7 | 4 | 28861 | 40 | ||||
| 26601 | 258075 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 1300X Wawona St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5988924 | 2097013 | 37.7373600650942 | -122.480805942066 | (37.7373600650942, -122.480805942066) | 1 | 8 | 3 | 29491 | 35 | ||||
| 26627 | 24794 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 7633 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5983299.41691 | 2112375.19824 | 37.7792118059508 | -122.50138846509 | (37.7792118059508, -122.50138846509) | 11 | 6 | 2 | 55 | 26 | |||
| 27029 | 120269 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 107 24th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 15 | 5988324.11159 | 2115191.86053 | 37.7872393720152 | -122.484212811587 | (37.7872393720152, -122.484212811587) | 11 | 6 | 1 | 55 | 33 | ||||
| 27519 | 120272 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 13 | 5988314.62217 | 2115170.46659 | 37.7871800778407 | -122.484244072949 | (37.7871800778407, -122.484244072949) | 11 | 6 | 1 | 55 | 33 | ||||
| 29220 | 379 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
| 29707 | 185566 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2201 Sunset Blvd | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984882.0949 | 2099749.7079 | 37.744638564328 | -122.494982211469 | (37.744638564328, -122.494982211469) | 1 | 8 | 3 | 29491 | 35 | |||
| 29828 | 118443 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 5201 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5982458.0361 | 2111659.95745 | 37.7771985159381 | -122.504246101222 | (37.7771985159381, -122.504246101222) | 11 | 6 | 2 | 55 | 26 | |||
| 29956 | 197589 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1 Jack Balestreri Way | 5 | Front Yard : Yard | Tree | Private 2 | 3 | 6012441.30894 | 2104748.70907 | 37.7599395365119 | -122.40003825707 | (37.7599395365119, -122.40003825707) | 10 | 3 | 8 | 28856 | 29 | ||||
| 30089 | 187307 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2401 Sunset Blvd | 90 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984946.0227 | 2098230.3328 | 37.7404705132188 | -122.494649173616 | (37.7404705132188, -122.494649173616) | 1 | 8 | 3 | 29491 | 35 | |||
| 30542 | 98548 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 132 Hamerton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6001332.8 | 2095440.7 | 37.7337563407686 | -122.437790462907 | (37.7337563407686, -122.437790462907) | 9 | 7 | 5 | 63 | 40 | |||||
| 30831 | 186891 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2700 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985178.2577 | 2096509.7223 | 37.7357597676042 | -122.493719449451 | (37.7357597676042, -122.493719449451) | 1 | 8 | 3 | 29491 | 35 | |||
| 31285 | 377 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
| 31619 | 181387 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984939.8638 | 2104520.2223 | 37.7577404689343 | -122.495134175513 | (37.7577404689343, -122.495134175513) | 1 | 8 | 3 | 56 | 35 | |||
| 31897 | 187392 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2100 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985024.2566 | 2100630.9061 | 37.7470664162932 | -122.494555600597 | (37.7470664162932, -122.494555600597) | 1 | 8 | 3 | 29491 | 35 | |||
| 33270 | 187127 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2600 Sunset Blvd | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985167.6891 | 2097369.3231 | 37.7381193834059 | -122.493819314943 | (37.7381193834059, -122.493819314943) | 1 | 8 | 3 | 29491 | 35 | |||
| 33753 | 186376 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1801 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984798.5659 | 2102512.3907 | 37.7522192455734 | -122.495474752392 | (37.7522192455734, -122.495474752392) | 1 | 8 | 3 | 56 | 35 | |||
| 34103 | 240616 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 685 Sanchez St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 5ft | 6003715.87711 | 2104249.40994 | 37.7580782339321 | -122.430179665856 | (37.7580782339321, -122.430179665856) | 2 | 4 | 5 | 28862 | 3 | |||
| 34175 | 87149 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Bellair Pl | 2 | Back Yard : Yard | Tree | Private 2 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | |||||
| 35501 | 240607 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 888 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6000718.67811 | 2102015.72187 | 37.7517748542418 | -122.44038504473 | (37.7517748542418, -122.44038504473) | 2 | 4 | 5 | 28862 | 22 | |||
| 35596 | 254587 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1270 24th Ave | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5988678 | 2106679 | 37.7638860263594 | -122.482364481098 | (37.7638860263594, -122.482364481098) | 1 | 8 | 3 | 56 | 35 | ||||
| 37051 | 120275 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 5 | Front Yard : Yard | Tree | Private 2 | 11 | 5988318.18285 | 2115148.99603 | 37.7871213331252 | -122.484230178713 | (37.7871213331252, -122.484230178713) | 11 | 6 | 1 | 55 | 33 | ||||
| 37696 | 240603 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 609 28th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001924.96846 | 2099400.16705 | 37.7446617708161 | -122.436026394128 | (37.7446617708161, -122.436026394128) | 2 | 7 | 5 | 63 | 22 | |||
| 38334 | 250138 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2550x Lyon St | 6 | Median : Yard | Tree | DPW 1 | 101 | 5999227.62567 | 2117605.22496 | 37.7944946461503 | -122.446662836939 | (37.7944946461503, -122.446662836939) | 13 | 9 | 1 | 57 | 27 | ||||
| 38735 | 253433 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Vulcan Stwy | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 6000640 | 2106231 | 37.7633444989385 | -122.440959493883 | (37.7633444989385, -122.440959493883) | 15 | 5 | 5 | 28862 | 3 | ||||
| 39128 | 251719 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1301 Clayton St | 1 | Side Yard : Yard | Tree | Private 2 | 5999055 | 2105304 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | 15 | 5 | 5 | 28862 | 12 | |||||
| 40752 | 186924 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2700 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985155.3367 | 2096781.1077 | 37.7365035785089 | -122.493818687918 | (37.7365035785089, -122.493818687918) | 1 | 8 | 3 | 29491 | 35 | |||
| 41329 | 181391 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984921.4841 | 2104558.6525 | 37.757844911537 | -122.495200573085 | (37.757844911537, -122.495200573085) | 1 | 8 | 3 | 56 | 35 | |||
| 41875 | 179497 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 653 Peru Ave | 9 | Side Yard : Yard | Tree | Private 2 | 8 | 6005046.66321 | 2092646.92983 | 37.7262957476241 | -122.424751842734 | (37.7262957476241, -122.424751842734) | 9 | 7 | 6 | 28861 | 5 | ||||
| 42536 | 97945 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2 Mendosa Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.7489597362933 | -122.464854121346 | (37.7489597362933, -122.464854121346) | 1 | 8 | 4 | 29491 | 40 | ||||
| 44152 | 185095 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2801 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985029.9671 | 2095999.845 | 37.7343511038502 | -122.494194570965 | (37.7343511038502, -122.494194570965) | 1 | 8 | 3 | 29491 | 35 | |||
| 45627 | 185725 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2101 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984855.2039 | 2100321.3236 | 37.7462064913622 | -122.495117336885 | (37.7462064913622, -122.495117336885) | 1 | 8 | 3 | 29491 | 35 | |||
| 47009 | 185730 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2101 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984911.7584 | 2100300.7286 | 37.7461532538825 | -122.494920263061 | (37.7461532538825, -122.494920263061) | 1 | 8 | 3 | 29491 | 35 | |||
| 47483 | 113358 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
| 48099 | 181395 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984933.1803 | 2104579.26 | 37.7579021787746 | -122.495161642957 | (37.7579021787746, -122.495161642957) | 1 | 8 | 3 | 56 | 35 | |||
| 48563 | 197584 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 851 Indiana St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 10ft | 6014983.28625 | 2104495.6281 | 37.7593860298711 | -122.391229027092 | (37.7593860298711, -122.391229027092) | 10 | 3 | 8 | 28856 | 29 | |||
| 49215 | 120268 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 107 24th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 5988313.3781 | 2115206.48473 | 37.7872789009445 | -122.484251019639 | (37.7872789009445, -122.484251019639) | 11 | 6 | 1 | 55 | 33 | ||||
| 49510 | 186481 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1601 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984737.1745 | 2103681.0182 | 37.7554243789331 | -122.495773245735 | (37.7554243789331, -122.495773245735) | 1 | 8 | 3 | 56 | 35 | |||
| 50332 | 247596 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 900 Tompkins Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6009145.02453 | 2096408.71868 | 37.73685543873 | -122.410849521814 | (37.73685543873, -122.410849521814) | 10 | 7 | 7 | 28859 | 2 | |||
| 51649 | 181435 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984924.5894 | 2104933.1403 | 37.7588733327201 | -122.495217449651 | (37.7588733327201, -122.495217449651) | 1 | 8 | 3 | 56 | 35 | |||
| 52720 | 181542 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984868.615 | 2105905.3126 | 37.7615393692586 | -122.495482733656 | (37.7615393692586, -122.495482733656) | 1 | 8 | 3 | 56 | 35 | |||
| 53110 | 112918 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
| 53373 | 250136 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2550x Lyon St | 3 | Median : Yard | Tree | DPW 1 | 100 | 5999230.19408 | 2117561.109 | 37.7943736621563 | -122.446650774326 | (37.7943736621563, -122.446650774326) | 13 | 9 | 1 | 57 | 27 | ||||
| 53710 | 185092 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2801 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985016.1492 | 2096009.4757 | 37.7343767385902 | -122.494243052853 | (37.7343767385902, -122.494243052853) | 1 | 8 | 3 | 29491 | 35 | |||
| 54187 | 246775 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 925 Esmeralda Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6009505.54739 | 2098718.43829 | 37.7432176358792 | -122.409766015896 | (37.7432176358792, -122.409766015896) | 2 | 7 | 7 | 28859 | 2 |
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) );