trees
1,977 rows where qSpecies_id = 41 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82277 | 176120 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3500 Great Hwy | 5 | Median : | Tree | Private 2 | 7 | Width 0ft | 5982240.01029 | 2092829.23573 | 37.7254818117323 | -122.503605476233 | (37.7254818117323, -122.503605476233) | 1 | 8 | 4 | 14 | ||||
| 90717 | 176132 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3500 Great Hwy | 19 | Median : | Tree | Private 2 | 12 | Width 0ft | 5982350.51369 | 2092704.12981 | 37.7251448006637 | -122.503214223478 | (37.7251448006637, -122.503214223478) | 1 | 8 | 4 | 14 | ||||
| 92238 | 176127 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3500 Great Hwy | 14 | Median : | Tree | Private 2 | 2 | Width 0ft | 5982331.98792 | 2092758.60697 | 37.7252932913503 | -122.503282295839 | (37.7252932913503, -122.503282295839) | 1 | 8 | 4 | 14 | ||||
| 147226 | 176126 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3500 Great Hwy | 13 | Median : | Tree | Private 2 | 1 | Width 0ft | 5982340.21435 | 2092760.75831 | 37.7252996819337 | -122.503254017558 | (37.7252996819337, -122.503254017558) | 1 | 8 | 4 | 14 | ||||
| 163651 | 176118 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3500 Great Hwy | 2 | Median : | Tree | Private 2 | 9 | Width 0ft | 5982159.44022 | 2092886.81947 | 37.7256351838922 | -122.503888258162 | (37.7256351838922, -122.503888258162) | 1 | 8 | 4 | 14 | ||||
| 22976 | 103600 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 50X Hermann St | 1 | Front Yard : Yard | Tree | Private 2 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | |||||
| 9730 | 190968 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6011276.3148 | 2104337.18505 | 37.7587445605265 | -122.404038467608 | (37.7587445605265, -122.404038467608) | 10 | 3 | 8 | 28856 | 29 | ||||
| 21639 | 190969 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6011271.58164 | 2104330.23228 | 37.7587252053147 | -122.404054347838 | (37.7587252053147, -122.404054347838) | 10 | 3 | 8 | 28856 | 29 | ||||
| 33593 | 190974 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6011278.73233 | 2104250.41369 | 37.7585064407439 | -122.404024000205 | (37.7585064407439, -122.404024000205) | 10 | 3 | 8 | 28856 | 29 | ||||
| 47684 | 190971 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 42 | 6011272.24417 | 2104307.20268 | 37.7586620081736 | -122.404050435791 | (37.7586620081736, -122.404050435791) | 10 | 3 | 8 | 28856 | 29 | ||||
| 61008 | 190970 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 6011272.79136 | 2104320.91829 | 37.7586996987603 | -122.40404950858 | (37.7586996987603, -122.40404950858) | 10 | 3 | 8 | 28856 | 29 | ||||
| 62210 | 190967 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 43 | 6011275.2709 | 2104408.12846 | 37.7589392970181 | -122.404047070529 | (37.7589392970181, -122.404047070529) | 10 | 3 | 8 | 28856 | 29 | ||||
| 107448 | 190976 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 25 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6011280.21235 | 2104227.17617 | 37.7584427183717 | -122.404017246303 | (37.7584427183717, -122.404017246303) | 10 | 3 | 8 | 28856 | 29 | ||||
| 115534 | 190966 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1912 23rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 45 | 6012683.0695 | 2102873.5527 | 37.7548042439346 | -122.399070498401 | (37.7548042439346, -122.399070498401) | 10 | 3 | 8 | 28856 | 29 | ||||
| 115981 | 190973 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 20 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | 6011275.27355 | 2104274.28266 | 37.7585717863791 | -122.404037642038 | (37.7585717863791, -122.404037642038) | 10 | 3 | 8 | 28856 | 29 | ||||
| 123634 | 190965 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 24th St | 17 | : Yard | Tree | Private 2 | 6 | 6017293.94065 | 2102634.43336 | 37.7544035402038 | -122.383108032109 | (37.7544035402038, -122.383108032109) | 10 | 3 | 8 | 28856 | 29 | ||||
| 143153 | 190977 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 26 | Sidewalk: Curb side : Yard | Tree | Private 2 | 50 | 6011279.98561 | 2104216.03333 | 37.7584121099421 | -122.404017246318 | (37.7584121099421, -122.404017246318) | 10 | 3 | 8 | 28856 | 29 | ||||
| 147755 | 190972 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 6011274.67248 | 2104298.88872 | 37.758639315564 | -122.404041452454 | (37.758639315564, -122.404041452454) | 10 | 3 | 8 | 28856 | 29 | ||||
| 165813 | 190978 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1429 Rhode Island St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 6012034.10728 | 2101710.80673 | 37.7515754115935 | -122.401233099922 | (37.7515754115935, -122.401233099922) | 10 | 3 | 8 | 28856 | 29 | ||||
| 168975 | 190823 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 184 Hooper St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 8ft | 6012465.24563 | 2107532.99928 | 37.7675859124819 | -122.400151016782 | (37.7675859124819, -122.400151016782) | 14 | 3 | 8 | 28856 | 20 | |||
| 189908 | 190975 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 Vermont St | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 6011275.59974 | 2104245.89235 | 37.7584938511263 | -122.40403451598 | (37.7584938511263, -122.40403451598) | 10 | 3 | 8 | 28856 | 29 | ||||
| 6580 | 261206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Leavenworth St | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6007514 | 2120271 | 37.8022840477627 | -122.418179969724 | (37.8022840477627, -122.418179969724) | 5 | 1 | 1 | 28858 | 32 | ||||
| 12495 | 126414 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2836 Larkin St | 10 | Side Yard : Yard | Tree | Private 2 | 12 | 6006501.05561 | 2120998.53971 | 37.8042246191233 | -122.421736962694 | (37.8042246191233, -122.421736962694) | 5 | 9 | 1 | 28858 | 32 | ||||
| 33476 | 139327 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1350x GEARY BLVD | 1 | Median : Cutout | Tree | DPW 1 | 22 | Width 0ft | 6005396.3086 | 2114138.3218 | 37.7853258358528 | -122.425071614426 | (37.7853258358528, -122.425071614426) | 13 | 9 | 11 | 28858 | 41 | |||
| 39021 | 126416 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2836 Larkin St | 12 | Side Yard : Yard | Tree | Private 2 | 46 | 6006501.51207 | 2121012.26216 | 37.8042623232049 | -122.421736358356 | (37.8042623232049, -122.421736358356) | 5 | 9 | 1 | 28858 | 32 | ||||
| 60064 | 139328 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1350x GEARY BLVD | 2 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6005318.1985 | 2114131.1202 | 37.7853016493854 | -122.42534133927 | (37.7853016493854, -122.42534133927) | 13 | 9 | 11 | 28858 | 41 | |||
| 79519 | 139357 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1350x GEARY BLVD | 6 | Median : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6005019.8844 | 2114088.1873 | 37.785166908017 | -122.426370358064 | (37.785166908017, -122.426370358064) | 13 | 9 | 11 | 28858 | 41 | |||
| 139045 | 126415 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2836 Larkin St | 11 | Side Yard : Yard | Tree | Private 2 | 48 | 6006502.51226 | 2121001.4648 | 37.8042327328147 | -122.421732129727 | (37.8042327328147, -122.421732129727) | 5 | 9 | 1 | 28858 | 32 | ||||
| 142043 | 97731 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1150 Francisco St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | Permit Number 50638 | 6005778.11415 | 2120709.05822 | 37.8033889834786 | -122.424218159845 | (37.8033889834786, -122.424218159845) | 5 | 9 | 1 | 28858 | 32 | |
| 151714 | 126418 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2237 Hyde St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6007090.48557 | 2119992.12642 | 37.8014944842289 | -122.419625741241 | (37.8014944842289, -122.419625741241) | 5 | 1 | 1 | 28858 | 32 | ||||
| 174954 | 126417 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2745 Larkin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6006522.5634 | 2120685.74713 | 37.8033669833519 | -122.421640303563 | (37.8033669833519, -122.421640303563) | 5 | 9 | 1 | 28858 | 32 | ||||
| 3038 | 248184 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 216 Esmeralda Ave | 3 | Side Yard : Yard | Tree | Private 2 | 28 | 6007432.52043 | 2098714.89498 | 37.7430915158666 | -122.416933765486 | (37.7430915158666, -122.416933765486) | 2 | 7 | 7 | 28859 | 2 | ||||
| 10605 | 260507 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 50X Carver St | 1 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 6009420 | 2098346 | 37.742190207281 | -122.410035530349 | (37.742190207281, -122.410035530349) | 10 | 7 | 7 | 28859 | 2 | |||
| 13593 | 247903 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 582 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 31 | 6009830.823 | 2098729.70619 | 37.7432667982256 | -122.408642088157 | (37.7432667982256, -122.408642088157) | 10 | 7 | 7 | 28859 | 2 | ||||
| 20540 | 247989 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 130 Mullen Ave | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 10ft | 6009899.29934 | 2099821.33089 | 37.7462679959733 | -122.408482299339 | (37.7462679959733, -122.408482299339) | 2 | 7 | 7 | 28859 | 2 | |||
| 28109 | 223768 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 340 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007779.74156 | 2105912.97739 | 37.762875341838 | -122.41624286402 | (37.762875341838, -122.41624286402) | 8 | 4 | 7 | 28859 | 19 | |||
| 30966 | 112739 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 444 Franconia St | 3 | Unaccepted Street : Yard | Tree | Private 2 | 30 | 6009949.70212209 | 2098546.33795552 | 37.7427699663381 | -122.408218103257 | (37.7427699663381, -122.408218103257) | 10 | 7 | 7 | 28859 | 2 | ||||
| 32016 | 223722 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 201 College Ave | 1 | Front Yard : Yard | Tree | Private 2 | 13 | Width 2ft | 6005269.83523 | 2095874.10119 | 37.7351694473011 | -122.424209762894 | (37.7351694473011, -122.424209762894) | 2 | 7 | 7 | 28859 | 2 | |||
| 32139 | 112726 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 40x BERNAL HEIGHTS BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009324 | 2098099 | 37.7415066181332 | -122.410350033668 | (37.7415066181332, -122.410350033668) | 10 | 7 | 7 | 28859 | 2 | |||
| 35838 | 247988 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 124 Mullen Ave | 2 | Front Yard : Yard | Tree | Private 2 | 29 | Width 10ft | 6009878.9446 | 2099816.70211 | 37.7462541464208 | -122.408552357412 | (37.7462541464208, -122.408552357412) | 2 | 7 | 7 | 28859 | 2 | |||
| 37088 | 223716 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1101 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 18 | 6004761.80581 | 2096370.25265 | 37.7365030690611 | -122.426001513664 | (37.7365030690611, -122.426001513664) | 2 | 7 | 5 | 28859 | 2 | ||||
| 41898 | 223727 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 295 Coso Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6007771.677 | 2099478.19016 | 37.7452064263402 | -122.415815087109 | (37.7452064263402, -122.415815087109) | 2 | 7 | 7 | 28859 | 2 | |||
| 42938 | 112725 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 40x BERNAL HEIGHTS BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6009324 | 2098099 | 37.7415066181332 | -122.410350033668 | (37.7415066181332, -122.410350033668) | 10 | 7 | 7 | 28859 | 2 | |||
| 45889 | 223720 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Crescent Ave | 3 | Side Yard : Yard | Tree | Private 2 | 15 | Width 3ft | 6005295.72226 | 2095902.89747 | 37.7352499770995 | -122.424122309196 | (37.7352499770995, -122.424122309196) | 2 | 7 | 7 | 28859 | 2 | |||
| 50957 | 223726 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 107 Elsie St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 32 | Width 7ft | 6007259.15325 | 2098682.19853 | 37.7429919851951 | -122.41753090725 | (37.7429919851951, -122.41753090725) | 2 | 7 | 7 | 28859 | 2 | |||
| 56525 | 122494 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 69x Bonview St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
| 58208 | 248051 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 25 Rutledge St | 1 | Front Yard : Yard | Tree | Private 2 | 24 | 6010607.15124 | 2099382.29757 | 37.7451021220724 | -122.406003697633 | (37.7451021220724, -122.406003697633) | 2 | 7 | 7 | 28859 | 2 | ||||
| 61381 | 223718 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1101 San Jose Ave | 59 | Front Yard : Yard | Tree | Private 2 | 4 | 6005036.87733 | 2096676.581 | 37.7373597200698 | -122.42507226309 | (37.7373597200698, -122.42507226309) | 2 | 7 | 5 | 28859 | 2 | ||||
| 67575 | 223732 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 201 College Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 6005270.68564 | 2095872.41003 | 37.7351648517715 | -122.424206702478 | (37.7351648517715, -122.424206702478) | 2 | 7 | 7 | 28859 | 2 | |||
| 72041 | 253876 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 56x Ellsworth St | 1 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6008136 | 2098387 | 37.7422307347858 | -122.414478117675 | (37.7422307347858, -122.414478117675) | 2 | 7 | 7 | 28859 | 2 | ||||
| 79818 | 251517 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 145 Bonview St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6007188 | 2098162 | 37.7415596321362 | -122.417740072125 | (37.7415596321362, -122.417740072125) | 2 | 7 | 7 | 28859 | 2 | ||||
| 85648 | 102573 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Park St | 1 | Median : Yard | Tree | DPW 1 | 24 | 6004982.6 | 2096420.1 | 37.7366524147431 | -122.425241679782 | (37.7366524147431, -122.425241679782) | 2 | 7 | 5 | 28859 | 2 | ||||
| 85900 | 247990 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 130 Mullen Ave | 2 | Front Yard : Yard | Tree | Private 2 | 21 | Width 10ft | 6009904.82703 | 2099823.31957 | 37.7462737660155 | -122.408463325425 | (37.7462737660155, -122.408463325425) | 2 | 7 | 7 | 28859 | 2 | |||
| 91893 | 223715 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1101 San Jose Ave | 10 | Front Yard : Yard | Tree | Private 2 | 17 | 6004750.57812 | 2096360.89303 | 37.7364767350963 | -122.426039666491 | (37.7364767350963, -122.426039666491) | 2 | 7 | 5 | 28859 | 2 | ||||
| 93124 | 223769 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 340 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007778.5816 | 2105921.91586 | 37.7628998195803 | -122.416247509035 | (37.7628998195803, -122.416247509035) | 8 | 4 | 7 | 28859 | 19 | |||
| 94042 | 246716 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Bonview St | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 45 | 6007832.06726 | 2099366.51815 | 37.7449031947197 | -122.415598362177 | (37.7449031947197, -122.415598362177) | 2 | 7 | 7 | 28859 | 2 | ||||
| 94207 | 223767 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 35 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010370.7257 | 2099718.90612 | 37.7460131497042 | -122.406844938766 | (37.7460131497042, -122.406844938766) | 2 | 7 | 7 | 28859 | 2 | |||
| 97581 | 248059 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 18 Rutledge St | 1 | Side Yard : Yard | Tree | Private 2 | 41 | 6010698.28988 | 2099365.54136 | 37.7450612101031 | -122.405687374593 | (37.7450612101031, -122.405687374593) | 2 | 7 | 7 | 28859 | 2 | ||||
| 99911 | 223708 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 220 Coso Ave | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 6007533.84485 | 2099558.41005 | 37.7454133189685 | -122.416643154074 | (37.7454133189685, -122.416643154074) | 2 | 7 | 7 | 28859 | 2 | ||||
| 102777 | 223725 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 109 Elsie St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 34 | Width 10ft | 6007250.83201 | 2098665.28415 | 37.7429450738598 | -122.417558481357 | (37.7429450738598, -122.417558481357) | 2 | 7 | 7 | 28859 | 2 | |||
| 104636 | 223697 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1001 San Jose Ave | 50 | Front Yard : Yard | Tree | Private 2 | 50 | 6005304.12461 | 2097202.65687 | 37.7388192990629 | -122.424185667341 | (37.7388192990629, -122.424185667341) | 2 | 7 | 5 | 28859 | 2 | ||||
| 107236 | 223770 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 340 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007775.55004 | 2105926.88107 | 37.7629132824304 | -122.416258345863 | (37.7629132824304, -122.416258345863) | 8 | 4 | 7 | 28859 | 19 | |||
| 113212 | 256719 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 129X Manchester St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6008266 | 2099329 | 37.7448245605916 | -122.414095244275 | (37.7448245605916, -122.414095244275) | 2 | 7 | 7 | 28859 | 2 | ||||
| 115496 | 223694 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1001 San Jose Ave | 8 | Front Yard : Yard | Tree | Private 2 | 65 | 6005104.45792 | 2096735.83838 | 37.7375262448502 | -122.424842819945 | (37.7375262448502, -122.424842819945) | 2 | 7 | 5 | 28859 | 2 | ||||
| 116416 | 223719 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Crescent Ave | 4 | Side Yard : Yard | Tree | Private 2 | 6 | Width 3ft | 6005300.64092 | 2095902.62438 | 37.7352495049691 | -122.424105284154 | (37.7352495049691, -122.424105284154) | 2 | 7 | 7 | 28859 | 2 | |||
| 117507 | 247911 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 399 Franconia St | 2 | Side Yard : Yard | Tree | Private 2 | 39 | 6009944.29918 | 2098783.53182 | 37.7434209465163 | -122.408253510886 | (37.7434209465163, -122.408253510886) | 2 | 7 | 7 | 28859 | 2 | ||||
| 123774 | 223721 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 201 College Ave | 2 | Front Yard : Yard | Tree | Private 2 | 18 | Width 2ft | 6005265.62157 | 2095876.84541 | 37.7351767443941 | -122.424224526166 | (37.7351767443941, -122.424224526166) | 2 | 7 | 7 | 28859 | 2 | |||
| 139584 | 223717 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1101 San Jose Ave | 58 | Front Yard : Yard | Tree | Private 2 | 55 | 6005027.45143 | 2096662.24212 | 37.7373198162667 | -122.425103832873 | (37.7373198162667, -122.425103832873) | 2 | 7 | 5 | 28859 | 2 | ||||
| 140081 | 247991 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 130 Mullen Ave | 3 | Front Yard : Yard | Tree | Private 2 | 25 | Width 10ft | 6009914.62518 | 2099827.74346 | 37.7462864617583 | -122.408429756449 | (37.7462864617583, -122.408429756449) | 2 | 7 | 7 | 28859 | 2 | |||
| 142056 | 116669 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 Esmeralda Ave | 6 | Unaccepted Street : Yard | Tree | DPW 1 | 20 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | ||||
| 142469 | 117064 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 257 PERALTA AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6009832 | 2099662 | 37.745826739133 | -122.408703774946 | (37.745826739133, -122.408703774946) | 2 | 7 | 7 | 28859 | 2 | ||||
| 146136 | 115151 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 15X Highland Ave | 2 | Median : Yard | Tree | DPW 1 | 36 | 6004989.3 | 2096795.8 | 37.7376843808497 | -122.42524524109 | (37.7376843808497, -122.42524524109) | 2 | 7 | 5 | 28859 | 7 | ||||
| 147794 | 115388 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 169x BOCANA ST | 1 | Front Yard : Cutout | Tree | Private 2 | 25 | 40x50 | 6007278 | 2097999 | 37.7411171346524 | -122.417417333034 | (37.7411171346524, -122.417417333034) | 2 | 7 | 7 | 28859 | 2 | |||
| 153798 | 103351 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 15X Highland Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 18 | 6004989.3 | 2096795.8 | 37.7376843808497 | -122.42524524109 | (37.7376843808497, -122.42524524109) | 2 | 7 | 5 | 28859 | 7 | ||||
| 154478 | 96856 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 324X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 36 | 410x30 | 6008894.01857 | 2095530.1163 | 37.7344289090546 | -122.4116553033 | (37.7344289090546, -122.4116553033) | 10 | 7 | 7 | 28859 | 2 | |||
| 159510 | 251717 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000X San Jose Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 6004710 | 2096486 | 37.7368179571536 | -122.426188866367 | (37.7368179571536, -122.426188866367) | 2 | 7 | 5 | 28859 | 7 | |||||
| 160950 | 246711 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Bonview St | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6007747.55824 | 2099198.25056 | 37.7444364187148 | -122.415878666471 | (37.7444364187148, -122.415878666471) | 2 | 7 | 7 | 28859 | 2 | ||||
| 162988 | 223731 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 201 College Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6005275.60501 | 2095869.1731 | 37.7351562416517 | -122.424189464283 | (37.7351562416517, -122.424189464283) | 2 | 7 | 7 | 28859 | 2 | |||
| 163267 | 106929 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 340 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 10x8 | 6007766.2 | 2105923.3 | 37.7629029238803 | -122.41629043085 | (37.7629029238803, -122.41629043085) | 8 | 4 | 7 | 28859 | 19 | |||
| 167411 | 223723 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2900 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010018.43827 | 2101654.33057 | 37.7513076807123 | -122.408199585735 | (37.7513076807123, -122.408199585735) | 2 | 4 | 7 | 28859 | 19 | |||
| 167754 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000 ESMERALDA AVE | Front Yard : Yard | Tree | Private 2 | 6009839 | 2098688 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | 10 | 7 | 7 | 28859 | 2 | ||||||
| 175224 | 247577 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 300x Alemany Blvd | 1 | Median : Yard | Tree | DPW 1 | 44 | 6008700.9232 | 2095336.3735 | 37.7338860994661 | -122.412309210505 | (37.7338860994661, -122.412309210505) | 9 | 7 | 7 | 28859 | 2 | ||||
| 179642 | 258204 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 29 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6005138.67888 | 2096702.23576 | 37.7374359124473 | -122.42472211206 | (37.7374359124473, -122.42472211206) | 2 | 7 | 5 | 28859 | 2 | ||||
| 189210 | 223766 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 317 Elsie St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6006968.55634 | 2098198.91003 | 37.7416486273844 | -122.418501452004 | (37.7416486273844, -122.418501452004) | 2 | 7 | 7 | 28859 | 2 | |||
| 189507 | 223695 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1001 San Jose Ave | 10 | Front Yard : Yard | Tree | Private 2 | 37 | 6005104.91543 | 2096758.07935 | 37.7375873393881 | -122.424842819957 | (37.7375873393881, -122.424842819957) | 2 | 7 | 5 | 28859 | 2 | ||||
| 189870 | 223696 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1001 San Jose Ave | 13 | Front Yard : Yard | Tree | Private 2 | 23 | 6005111.39586 | 2096784.72517 | 37.7376608688401 | -122.42482230912 | (37.7376608688401, -122.42482230912) | 2 | 7 | 5 | 28859 | 2 | ||||
| 65180 | 249866 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1497 Montgomery St | 2 | Side Yard : Yard | Tree | Private 2 | 20 | Width 0ft | 6011357.00506 | 2120690.57104 | 37.8036516466761 | -122.404910787509 | (37.8036516466761, -122.404910787509) | 3 | 1 | 10 | 28860 | 6 | |||
| 98962 | 249865 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1497 Montgomery St | 1 | Side Yard : Yard | Tree | Private 2 | 24 | Width 0ft | 6011350.60192 | 2120707.91777 | 37.8036989186248 | -122.404934168095 | (37.8036989186248, -122.404934168095) | 3 | 1 | 10 | 28860 | 6 | |||
| 2750 | 206896 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Pizarro Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5995094.72754 | 2093951.90742 | 37.7293117922974 | -122.459249411033 | (37.7293117922974, -122.459249411033) | 9 | 7 | 4 | 28861 | 40 | |||
| 4865 | 223711 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1201 San Jose Ave | 43 | Front Yard : Yard | Tree | Private 2 | 27 | 6004453.96026 | 2096061.62765 | 37.7356382512944 | -122.427043891762 | (37.7356382512944, -122.427043891762) | 2 | 7 | 5 | 28861 | 2 | ||||
| 7275 | 261458 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 701X Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5999135 | 2090407 | 37.7198097539444 | -122.445027136249 | (37.7198097539444, -122.445027136249) | 9 | 7 | 6 | 28861 | 25 | ||||
| 8751 | 262427 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Avalon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002848 | 2093194 | 37.7276734535 | -122.432391560875 | (37.7276734535, -122.432391560875) | 9 | 7 | 6 | 28861 | 5 | ||||
| 11014 | 262425 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002848 | 2093194 | 37.7276734535 | -122.432391560875 | (37.7276734535, -122.432391560875) | 9 | 7 | 6 | 28861 | 5 | ||||
| 12393 | 261459 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 701X Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5999135 | 2090407 | 37.7198097539444 | -122.445027136249 | (37.7198097539444, -122.445027136249) | 9 | 7 | 6 | 28861 | 25 | ||||
| 15980 | 262426 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002848 | 2093194 | 37.7276734535 | -122.432391560875 | (37.7276734535, -122.432391560875) | 9 | 7 | 6 | 28861 | 5 | ||||
| 21566 | 176163 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 654 Peru Ave | 1 | Side Yard : Yard | Tree | Private 2 | 23 | 6005125.75661 | 2092550.72712 | 37.7260360630077 | -122.424471580706 | (37.7260360630077, -122.424471580706) | 9 | 7 | 6 | 28861 | 5 | ||||
| 55445 | 253289 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 650 Peru Ave | 5 | Front Yard : Yard | Tree | Private 2 | 6005101.95698 | 2092563.19401 | 37.7260689503102 | -122.424554741032 | (37.7260689503102, -122.424554741032) | 9 | 7 | 6 | 28861 | 5 | |||||
| 57675 | 253290 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 650 Peru Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6005101.95698 | 2092563.19401 | 37.7260689503102 | -122.424554741032 | (37.7260689503102, -122.424554741032) | 9 | 7 | 6 | 28861 | 5 | |||||
| 57945 | 206843 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Lobos St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5996870.71882 | 2088697.52039 | 37.7149864275584 | -122.452730603229 | (37.7149864275584, -122.452730603229) | 9 | 8 | 6 | 28861 | 24 | ||||
| 63969 | 176165 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 654 Peru Ave | 3 | Side Yard : Yard | Tree | Private 2 | 27 | 6005141.81262 | 2092533.90812 | 37.7259907884276 | -122.424414880262 | (37.7259907884276, -122.424414880262) | 9 | 7 | 6 | 28861 | 5 |
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) );