trees
349 rows where qSpecies_id = 155 sorted by PlotSize
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 | ||||
| 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 | ||||
| 3904 | 121227 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 4299x 17th St | 3 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
| 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 | |||||
| 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 | ||||
| 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 | |||||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 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 | |||||
| 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 | ||||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 55580 | 136442 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6013378.37764 | 2118933.3014 | 37.7989393870992 | -122.397792341438 | (37.7989393870992, -122.397792341438) | 3 | 1 | 10 | 28860 | 6 | ||||
| 56286 | 112919 | 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 | ||||
| 58049 | 39822 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2190 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982045.5543 | 2100206.3838 | 37.7457260090551 | -122.504824075497 | (37.7457260090551, -122.504824075497) | 1 | 8 | 3 | 29491 | 35 | |
| 58774 | 102106 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 50X Noe St | 8 | Front Yard : Yard | Tree | Private 2 | 12/19/2012 12:00:00 AM | 25 | Permit Number 769282 | 6002816.1 | 2107996.5 | 37.7683158318555 | -122.433559261751 | (37.7683158318555, -122.433559261751) | 15 | 5 | 5 | 28862 | 3 | ||
| 61269 | 240609 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3944 22nd St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | 6002189.65903 | 2102971.08087 | 37.7544816876836 | -122.435366533665 | (37.7544816876836, -122.435366533665) | 2 | 4 | 5 | 28862 | 22 | ||||
| 62301 | 118611 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 349 Point Lobos Ave | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 5981718.68572 | 2112644.15815 | 37.7798573303546 | -122.506876725888 | (37.7798573303546, -122.506876725888) | 11 | 6 | 2 | 55 | 26 | ||||
| 62568 | 136431 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 13 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6008632.90068 | 2119166.62302 | 37.799314619318 | -122.414229834152 | (37.799314619318, -122.414229834152) | 5 | 1 | 10 | 308 | 32 | ||||
| 63647 | 136440 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6013367.06255 | 2118933.37204 | 37.7989389509345 | -122.397831500623 | (37.7989389509345, -122.397831500623) | 3 | 1 | 10 | 28860 | 6 | ||||
| 65651 | 112922 | 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 | ||||
| 65969 | 87150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Bellair Pl | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 50135 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | ||||
| 66311 | 247908 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 582 Esmeralda Ave | 6 | Side Yard : Yard | Tree | Private 2 | 12 | 6009856.31482 | 2098721.18962 | 37.7432448412741 | -122.408553343056 | (37.7432448412741, -122.408553343056) | 10 | 7 | 7 | 28859 | 2 | ||||
| 66374 | 248054 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 19 Rutledge St | 3 | Front Yard : Yard | Tree | Private 2 | 10 | 6010623.78947 | 2099366.66931 | 37.7450601408245 | -122.405945064536 | (37.7450601408245, -122.405945064536) | 2 | 7 | 7 | 28859 | 2 | ||||
| 66718 | 120273 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 16 | 5988307.3728 | 2115160.02273 | 37.7871509798828 | -122.484268387653 | (37.7871509798828, -122.484268387653) | 11 | 6 | 1 | 55 | 33 | ||||
| 68769 | 120270 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 107 24th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 11 | 5988338.64874 | 2115186.15354 | 37.7872245486486 | -122.484162098091 | (37.7872245486486, -122.484162098091) | 11 | 6 | 1 | 55 | 33 | ||||
| 70534 | 104510 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 254 ALLISON ST | 1 | Back Yard : Yard | Tree | Private 2 | 40 | 6000052 | 2087408 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | 9 | 7 | 6 | 28861 | 5 | ||||
| 72541 | 120276 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 6 | Front Yard : Yard | Tree | Private 2 | 13 | 5988325.261 | 2115160.84311 | 37.7871542739482 | -122.484206559328 | (37.7871542739482, -122.484206559328) | 11 | 6 | 1 | 55 | 33 | ||||
| 72583 | 111269 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 700X BOSWORTH ST | 7 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 72665 | 136438 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6013355.98644 | 2118932.37336 | 37.798935591968 | -122.397869757803 | (37.798935591968, -122.397869757803) | 3 | 1 | 10 | 28860 | 6 | ||||
| 74028 | 136430 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1101 Greenwich St | 15 | Front Yard : Yard | Tree | Private 2 | 20 | 6007579.05475 | 2119893.16835 | 37.8012502787406 | -122.417928048762 | (37.8012502787406, -122.417928048762) | 5 | 1 | 1 | 28858 | 32 | ||||
| 74061 | 248065 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 18 Rutledge St | 7 | Side Yard : Yard | Tree | Private 2 | 8 | 6010648.08166 | 2099392.59133 | 37.7451326756473 | -122.405862891685 | (37.7451326756473, -122.405862891685) | 2 | 7 | 7 | 28859 | 2 | ||||
| 74096 | 112921 | 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 | ||||
| 76123 | 240596 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 San Jose Ave | 8 | Front Yard : Yard | Tree | Private 2 | 20 | 6003644.77453 | 2095717.83373 | 37.7346484808287 | -122.429817043043 | (37.7346484808287, -122.429817043043) | 2 | 7 | 5 | 63 | 7 | ||||
| 76481 | 94535 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 265 Dorland St | 1 | Back Yard : Yard | Tree | Private 2 | 6003831 | 2105693 | 37.7620485075454 | -122.429884491233 | (37.7620485075454, -122.429884491233) | 8 | 4 | 5 | 28862 | 3 | |||||
| 77920 | 215022 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5993608.12799 | 2096720.10438 | 37.7368269967784 | -122.464589603347 | (37.7368269967784, -122.464589603347) | 1 | 8 | 4 | 59 | 40 | ||||
| 80763 | 248068 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 20 Rutledge St | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 6010623.83336 | 2099392.33092 | 37.7451306044855 | -122.405946720167 | (37.7451306044855, -122.405946720167) | 2 | 7 | 7 | 28859 | 2 | ||||
| 80811 | 136443 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013384.0493 | 2118922.93531 | 37.7989112401317 | -122.397771987982 | (37.7989112401317, -122.397771987982) | 3 | 1 | 10 | 28860 | 6 | ||||
| 82049 | 116660 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 199x Esmeralda Ave | 13 | Unaccepted Street : Yard | Tree | DPW 1 | 8 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | ||||
| 82071 | 106360 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1820 POST ST | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 6003351.1 | 2114201.6 | 37.785383838011 | -122.432151932321 | (37.785383838011, -122.432151932321) | 13 | 9 | 11 | 29490 | 13 | ||||
| 82381 | 98597 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 400X Steiner St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 768529 | 6004639 | 2109849 | 37.7735056071657 | -122.427386005439 | (37.7735056071657, -122.427386005439) | 7 | 9 | 11 | 28852 | 10 | ||||
| 85358 | 246442 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 485 Duncan St | 4 | Front Yard : Yard | Tree | Private 2 | 40 | 6003379.46073 | 2099778.50621 | 37.7457831256083 | -122.431024044746 | (37.7457831256083, -122.431024044746) | 2 | 7 | 5 | 63 | 22 | ||||
| 87089 | 215025 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5993646.76934 | 2096691.56193 | 37.7367508538673 | -122.464453932502 | (37.7367508538673, -122.464453932502) | 1 | 8 | 4 | 59 | 40 | ||||
| 89099 | 120280 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 10 | Front Yard : Yard | Tree | Private 2 | 15 | 5988322.23801 | 2115131.91384 | 37.7870746664109 | -122.484214895682 | (37.7870746664109, -122.484214895682) | 11 | 6 | 1 | 55 | 33 | ||||
| 94058 | 215043 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 798 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5996915.73734 | 2095029.56264 | 37.732375301382 | -122.453031809567 | (37.732375301382, -122.453031809567) | 9 | 7 | 4 | 59 | 40 | ||||
| 98282 | 246713 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1 Bonview St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6007763.89494 | 2099225.75212 | 37.7445128502976 | -122.415824124379 | (37.7445128502976, -122.415824124379) | 2 | 7 | 7 | 28859 | 2 | ||||
| 99868 | 248066 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 18 Rutledge St | 8 | Side Yard : Yard | Tree | Private 2 | 7 | 6010646.65948 | 2099397.14706 | 37.7451451051559 | -122.405868130216 | (37.7451451051559, -122.405868130216) | 2 | 7 | 7 | 28859 | 2 | ||||
| 101231 | 52819 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1327@ JUDAH 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Permit Number 48844 | 5987385.2929 | 2106232.8495 | 37.7625857382219 | -122.486802743324 | (37.7625857382219, -122.486802743324) | 1 | 8 | 3 | 56 | 35 | |||
| 101348 | 120278 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 8 | Front Yard : Yard | Tree | Private 2 | 14 | 5988337.84774 | 2115148.37916 | 37.7871207843354 | -122.484162098088 | (37.7871207843354, -122.484162098088) | 11 | 6 | 1 | 55 | 33 | ||||
| 102378 | 197585 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 900x Carolina St | 75 | Median : Yard | Tree | DPW 1 | 27 | 6012517.30691 | 2102783.51804 | 37.7545477896502 | -122.399637433715 | (37.7545477896502, -122.399637433715) | 10 | 3 | 8 | 28856 | 29 | ||||
| 102757 | 120263 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 24th Ave | 5 | Side Yard : Yard | Tree | Private 2 | 8 | 5988364.34066 | 2115176.21089 | 37.7871987447814 | -122.484072481257 | (37.7871987447814, -122.484072481257) | 11 | 6 | 1 | 55 | 33 | ||||
| 105934 | 99256 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1466 York St | Back Yard : Yard | Tree | Private 2 | 6010099 | 2100741 | 37.7488043872035 | -122.407856595429 | (37.7488043872035, -122.407856595429) | 2 | 4 | 7 | 28859 | 19 | ||||||
| 108685 | 215027 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5993761.26762 | 2096568.14898 | 37.7364185921533 | -122.464049108976 | (37.7364185921533, -122.464049108976) | 1 | 8 | 4 | 59 | 40 | ||||
| 109809 | 106362 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1645 WEBSTER ST | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | 13 | 9 | 11 | 29490 | 13 | ||||
| 110581 | 113359 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
| 110842 | 39823 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2190 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982046.2311 | 2100191.8316 | 37.7456860925771 | -122.504820657151 | (37.7456860925771, -122.504820657151) | 1 | 8 | 3 | 29491 | 35 | |
| 111744 | 248053 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 19 Rutledge St | 2 | Front Yard : Yard | Tree | Private 2 | 18 | 6010622.54759 | 2099378.68509 | 37.7450930640901 | -122.405950205054 | (37.7450930640901, -122.405950205054) | 2 | 7 | 7 | 28859 | 2 | ||||
| 111807 | 179496 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 653 Peru Ave | 8 | Side Yard : Yard | Tree | Private 2 | 6 | 6005058.40423 | 2092646.41058 | 37.7262949850043 | -122.424711217658 | (37.7262949850043, -122.424711217658) | 9 | 7 | 6 | 28861 | 5 | ||||
| 117566 | 240630 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 32 Harry St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6003226.48563 | 2097681.33135 | 37.7400160997695 | -122.43140332842 | (37.7400160997695, -122.43140332842) | 2 | 7 | 5 | 63 | 7 | ||||
| 118706 | 54927 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 485 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 10 | Permit Number 10801 | 6003402.69319537 | 2099776.66443458 | 37.7457793849362 | -122.430943578835 | (37.7457793849362, -122.430943578835) | 2 | 7 | 5 | 63 | 22 | ||
| 120109 | 105769 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 1 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 02/24/2014 12:00:00 AM | Permit Number 772589 | 5990111.8 | 2090190.8 | 37.7186969947407 | -122.476201051717 | (37.7186969947407, -122.476201051717) | 1 | 8 | 4 | 64 | 14 | |||
| 121121 | 97857 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 895 Indiana St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
| 121642 | 215024 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5993634.34816 | 2096702.85203 | 37.7367811376468 | -122.464497697112 | (37.7367811376468, -122.464497697112) | 1 | 8 | 4 | 59 | 40 | ||||
| 121973 | 39824 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2190 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982047.2464 | 2100175.5874 | 37.7456415502509 | -122.504815942994 | (37.7456415502509, -122.504815942994) | 1 | 8 | 3 | 29491 | 35 | |
| 122518 | 215039 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 179 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 5994134.23715 | 2091156.84385 | 37.7215819583195 | -122.462367242757 | (37.7215819583195, -122.462367242757) | 9 | 8 | 6 | 28861 | 24 | ||||
| 123200 | 215023 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5993620.60867 | 2096711.64912 | 37.736804500228 | -122.464545838734 | (37.736804500228, -122.464545838734) | 1 | 8 | 4 | 59 | 40 | ||||
| 126433 | 136435 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013344.90953 | 2118921.0971 | 37.7989040131614 | -122.397907296408 | (37.7989040131614, -122.397907296408) | 3 | 1 | 10 | 28860 | 6 | ||||
| 126966 | 136434 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 12 Greenwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6012298.4076 | 2120549.33954 | 37.8033164360554 | -122.401643063984 | (37.8033164360554, -122.401643063984) | 3 | 1 | 10 | 28860 | 6 | ||||
| 127099 | 120274 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 4 | Front Yard : Yard | Tree | Private 2 | 9 | 5988307.12698 | 2115148.43075 | 37.7871191372985 | -122.484268387654 | (37.7871191372985, -122.484268387654) | 11 | 6 | 1 | 55 | 33 | ||||
| 127656 | 215036 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 694 Hearst Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 5996922.84392 | 2094438.19015 | 37.7307519414457 | -122.452964569069 | (37.7307519414457, -122.452964569069) | 9 | 7 | 4 | 59 | 40 | ||||
| 129429 | 240624 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 5413 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6002039.42489 | 2097863.52461 | 37.7404490118051 | -122.4355207197 | (37.7404490118051, -122.4355207197) | 2 | 7 | 5 | 63 | 7 | ||||
| 132983 | 136445 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6013392.00591 | 2118921.55061 | 37.7989078811583 | -122.397744358119 | (37.7989078811583, -122.397744358119) | 3 | 1 | 10 | 28860 | 6 | ||||
| 136125 | 136437 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6013352.957 | 2118919.28443 | 37.7988994841762 | -122.397879322098 | (37.7988994841762, -122.397879322098) | 3 | 1 | 10 | 28860 | 6 | ||||
| 136354 | 240623 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 5413 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6002032.85746 | 2097853.11791 | 37.7404200644256 | -122.435542682968 | (37.7404200644256, -122.435542682968) | 2 | 7 | 5 | 63 | 7 | ||||
| 138407 | 136436 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013350.43599 | 2118931.26261 | 37.7989322330038 | -122.397888886371 | (37.7989322330038, -122.397888886371) | 3 | 1 | 10 | 28860 | 6 | ||||
| 139560 | 112145 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 401X ROOSEVELT WAY | 2 | Median : Yard | Tree | DPW 1 | 24 | 6000065 | 2106738 | 37.7647038289299 | -122.442984636734 | (37.7647038289299, -122.442984636734) | 15 | 5 | 5 | 28862 | 3 | ||||
| 140063 | 95435 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 2675 25th Ave | 2 | Unaccepted Street : Yard | Tree | Private 2 | 12 | 5988610 | 2097126.3 | 37.7376529013161 | -122.481899870051 | (37.7376529013161, -122.481899870051) | 1 | 8 | 3 | 29491 | 35 | ||||
| 140694 | 120279 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 9 | Front Yard : Yard | Tree | Private 2 | 14 | 5988331.03377 | 2115139.52576 | 37.7870960786942 | -122.484185023117 | (37.7870960786942, -122.484185023117) | 11 | 6 | 1 | 55 | 33 | ||||
| 140982 | 136433 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2671 Leavenworth St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 6007318.56693 | 2121838.23641 | 37.8065762788357 | -122.418967487863 | (37.8065762788357, -122.418967487863) | 5 | 1 | 1 | 28858 | 32 |
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) );