trees
349 rows where qSpecies_id = 155 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1476 | 20456 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 495X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
| 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 | |||||||||||||||
| 7510 | 20015 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY47 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 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 | |||||||||||||
| 11754 | 20074 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY55 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 27X | |||||||||||||
| 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 | |||||||||||||
| 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 | ||||||||||||||
| 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 | ||||
| 115292 | 197579 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 428 08th St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6010214.98706 | 2109650.78059 | 37.773275125388 | -122.408083778259 | (37.773275125388, -122.408083778259) | 14 | 2 | 9 | 28853 | 34 | |||
| 129998 | 197590 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 200 Kansas St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 4ft | 6011401.81383 | 2107103.92491 | 37.7663484192558 | -122.403799114839 | (37.7663484192558, -122.403799114839) | 8 | 2 | 8 | 28853 | 20 | |||
| 146386 | 107343 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 110 JULIAN AVE | 2 | Back Yard : Yard | Tree | Private 2 | 15 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | 8 | 4 | 7 | 28853 | 19 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||||
| 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 | |||
| 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 | |||||
| 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 | ||||
| 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 | |||
| 64643 | 197582 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 851 Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 10ft | 6014984.28202 | 2104444.32589 | 37.7592452203005 | -122.391221997114 | (37.7592452203005, -122.391221997114) | 10 | 3 | 8 | 28856 | 29 | |||
| 75463 | 3774 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1098 Carolina St | 7 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||||
| 106367 | 197586 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1 Jack Balestreri Way | 1 | Front Yard : Yard | Tree | Private 2 | 45 | Width 10ft | 6012374.62872 | 2104733.59825 | 37.7598943275787 | -122.400267811735 | (37.7598943275787, -122.400267811735) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||||
| 130762 | 54448 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 425 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3x5 | Permit Number 10233 | 6011220.56042251 | 2106374.73270267 | 37.764336094761 | -122.404374709215 | (37.764336094761, -122.404374709215) | 8 | 3 | 8 | 28856 | 29 | ||
| 133327 | 255538 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 700x Folsom St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6012646 | 2113072 | 37.7828048233647 | -122.399914812284 | (37.7828048233647, -122.399914812284) | 6 | 2 | 9 | 28856 | 34 | ||||
| 160085 | 97856 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 895 Indiana St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
| 172241 | 197587 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1 Jack Balestreri Way | 3 | Front Yard : Yard | Tree | Private 2 | 12 | 6012433.76366 | 2104761.36078 | 37.7599738546281 | -122.400065241211 | (37.7599738546281, -122.400065241211) | 10 | 3 | 8 | 28856 | 29 | ||||
| 175376 | 197583 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 851 Indiana St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 8ft | 6014993.18258 | 2104474.00413 | 37.7593272043051 | -122.391193288938 | (37.7593272043051, -122.391193288938) | 10 | 3 | 8 | 28856 | 29 | |||
| 175625 | 97854 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 895 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
| 177730 | 197581 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2101 17th St | 1 | Front Yard : Yard | Tree | Private 2 | 35 | 6011118.65336 | 2106461.14792 | 37.7645676761706 | -122.404733263136 | (37.7645676761706, -122.404733263136) | 8 | 3 | 8 | 28856 | 29 | ||||
| 185174 | 255539 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 700x Folsom St | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6012646 | 2113072 | 37.7828048233647 | -122.399914812284 | (37.7828048233647, -122.399914812284) | 6 | 2 | 9 | 28856 | 34 | ||||
| 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 | |||||
| 57200 | 136428 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 7 Kimball Pl | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 6007991.83691 | 2116437.43612 | 37.791784918695 | -122.416254742289 | (37.791784918695, -122.416254742289) | 5 | 1 | 10 | 28858 | 21 | |||
| 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 | ||||
| 85142 | 255249 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 209x Willow St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
| 111707 | 2580 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1668 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6005450.60125 | 2115176.64636 | 37.7881798837348 | -122.424957678647 | (37.7881798837348, -122.424957678647) | 13 | 9 | 1 | 28858 | 41 | |||
| 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 | ||||
| 167150 | 136429 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1101 Greenwich St | 11 | Front Yard : Yard | Tree | Private 2 | 14 | 6007562.30318 | 2119880.18015 | 37.801213673635 | -122.417985095433 | (37.801213673635, -122.417985095433) | 5 | 1 | 1 | 28858 | 32 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 63157 | 116234 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 450 PERALTA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009750 | 2099218 | 37.744603019334 | -122.408955999129 | (37.744603019334, -122.408955999129) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 91810 | 247598 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 900 Tompkins Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6009167.82306 | 2096407.90626 | 37.7368544863348 | -122.410770639572 | (37.7368544863348, -122.410770639572) | 10 | 7 | 7 | 28859 | 2 | |||
| 97217 | 122496 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 69x Bonview St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||||
| 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 | ||||||
| 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 | ||||
| 120274 | 2370 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2516 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4PL | 6009703.1421 | 2102664.68486 | 37.7540642287015 | -122.409361214875 | (37.7540642287015, -122.409361214875) | 2 | 4 | 7 | 28859 | 19 | |||
| 148856 | 240599 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3229 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006780.56286 | 2103771.69804 | 37.7569396517722 | -122.41954675558 | (37.7569396517722, -122.41954675558) | 2 | 4 | 7 | 28859 | 19 | |||
| 153377 | 248058 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 17 Rutledge St | 4 | Side Yard : Yard | Tree | Private 2 | 5 | 6010687.47782 | 2099346.14687 | 37.7450073524216 | -122.405723395139 | (37.7450073524216, -122.405723395139) | 2 | 7 | 7 | 28859 | 2 | ||||
| 155030 | 113150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 45 BRONTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6009384 | 2097185 | 37.7390003361927 | -122.410078062228 | (37.7390003361927, -122.410078062228) | 10 | 7 | 7 | 28859 | 2 | |||
| 156862 | 247974 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 346 Peralta Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6009790.92788 | 2099185.07173 | 37.7445148980554 | -122.408812155357 | (37.7445148980554, -122.408812155357) | 2 | 7 | 7 | 28859 | 2 | ||||
| 159242 | 248069 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 20 Rutledge St | 3 | Side Yard : Yard | Tree | Private 2 | 8 | 6010620.26598 | 2099403.15406 | 37.7451601229588 | -122.405959817907 | (37.7451601229588, -122.405959817907) | 2 | 7 | 7 | 28859 | 2 | ||||
| 163159 | 197580 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2151 17th St | 1 | Front Yard : Yard | Tree | Private 2 | 23 | 6010976.50521 | 2106453.15639 | 37.764537787215 | -122.405224355037 | (37.764537787215, -122.405224355037) | 8 | 4 | 8 | 28859 | 19 | ||||
| 187083 | 247905 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 582 Esmeralda Ave | 3 | Side Yard : Yard | Tree | Private 2 | 4 | 6009839.52244 | 2098719.28889 | 37.7432386818184 | -122.408611272911 | (37.7432386818184, -122.408611272911) | 10 | 7 | 7 | 28859 | 2 | ||||
| 188227 | 240598 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2106 Folsom St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 2ft | 6008077.42241 | 2106097.35182 | 37.763398325498 | -122.415226338718 | (37.763398325498, -122.415226338718) | 8 | 4 | 7 | 28859 | 19 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 154245 | 136439 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013363.76971 | 2118922.4292 | 37.7989087211284 | -122.397842127014 | (37.7989087211284, -122.397842127014) | 3 | 1 | 10 | 28860 | 6 | ||||
| 175737 | 136441 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6013371.77292 | 2118938.4754 | 37.798953225861 | -122.397815559237 | (37.798953225861, -122.397815559237) | 3 | 1 | 10 | 28860 | 6 | ||||
| 177141 | 136444 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6013387.59339 | 2118931.12048 | 37.7989339120187 | -122.397760298614 | (37.7989339120187, -122.397760298614) | 3 | 1 | 10 | 28860 | 6 | ||||
| 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 | ||||
| 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 | ||||
| 69156 | 117179 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 350x Winding Way | 1 | Median : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001167.67306 | 2086580.24641 | 37.7094181465037 | -122.437726988707 | (37.7094181465037, -122.437726988707) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||||
| 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 | ||||
| 116198 | 240600 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 237 Murray St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6005707.57123 | 2095372.66085 | 37.7338173103055 | -122.422660726511 | (37.7338173103055, -122.422660726511) | 2 | 7 | 7 | 28861 | 2 | |||
| 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 | ||||
| 144425 | 215038 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 314 Staples Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5997989.53732 | 2093829.39983 | 37.7291414193406 | -122.449233015693 | (37.7291414193406, -122.449233015693) | 9 | 7 | 4 | 28861 | 40 | ||||
| 152363 | 179494 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 861 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6001008.19959 | 2088780.17342 | 37.7154495883121 | -122.43843566439 | (37.7154495883121, -122.43843566439) | 9 | 7 | 6 | 28861 | 5 | |||
| 165114 | 215037 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 314 Staples Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5997982.72892 | 2093830.46071 | 37.7291439428352 | -122.449256629186 | (37.7291439428352, -122.449256629186) | 9 | 7 | 4 | 28861 | 40 | ||||
| 166518 | 179495 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 350x Winding Way | 3 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6001141.42857 | 2086583.09342 | 37.7094244714452 | -122.43781789759 | (37.7094244714452, -122.43781789759) | 9 | 7 | 6 | 28861 | 5 | |||
| 166770 | 107222 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 327 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2014 12:00:00 AM | 3 | 6x5 | Permit Number 773943 | 6003989.60354 | 2091508.12122 | 37.7231090719178 | -122.428324915783 | (37.7231090719178, -122.428324915783) | 9 | 7 | 6 | 28861 | 5 | |
| 180754 | 96273 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 55@ Alemany Trumbull St | 1 | Back Yard : Yard | Tree | Private 2 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | 9 | 7 | 6 | 28861 | 5 | |||||
| 185995 | 215040 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 88 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5994178.77111 | 2090487.70986 | 37.7197472415137 | -122.46216479907 | (37.7197472415137, -122.46216479907) | 9 | 8 | 6 | 28861 | 24 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 |
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) );