trees
1,977 rows where qSpecies_id = 41 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30200 | 98503 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 208 Glenview Dr | Back Yard : Yard | Tree | Private 2 | 5998871 | 2100779 | 37.7482737407191 | -122.446685565827 | (37.7482737407191, -122.446685565827) | 2 | 5 | 5 | 63 | 38 | ||||||
| 75016 | 98140 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 315 San Marcos Ave | Front Yard : Yard | Tree | Private 2 | 5992920.8 | 2100212.1 | 37.7463754865467 | -122.467219803339 | (37.7463754865467, -122.467219803339) | 1 | 8 | 4 | 29491 | 40 | ||||||
| 112679 | 106961 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 325 DWIGHT ST | Sidewalk: Curb side : Yard | Tree | Private 2 | 6010604 | 2091349 | 37.7230442144558 | -122.405448941518 | (37.7230442144558, -122.405448941518) | 10 | 3 | 7 | 309 | 28 | ||||||
| 120937 | 109516 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 105 MIDCREST WAY | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 12x12 | 5998180.4 | 2101012.8 | 37.7488762246558 | -122.4490904711 | (37.7488762246558, -122.4490904711) | 1 | 5 | 4 | 63 | 38 | ||||
| 135134 | 113440 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 190 BEACON ST | Back Yard : Yard | Tree | Private 2 | 32 | 3x3 | 6003193 | 2097540 | 37.7396261385587 | -122.431509020833 | (37.7396261385587, -122.431509020833) | 2 | 7 | 5 | 63 | 7 | ||||
| 139381 | 109706 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 96 CRESTA VISTA DR | Back Yard : Cutout | Tree | Private 2 | 5995602.1 | 2096103.5 | 37.7352487002973 | -122.457651008037 | (37.7352487002973, -122.457651008037) | 9 | 7 | 4 | 59 | 40 | ||||||
| 157400 | 97685 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 84 Coventry Ct | Back Yard : Yard | Tree | Private 2 | 5997084 | 2096485 | 37.7363812239889 | -122.452555087132 | (37.7363812239889, -122.452555087132) | 9 | 7 | 4 | 59 | 40 | ||||||
| 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 | ||||||
| 171687 | 251422 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 480x De Long St | Front Yard : Yard | Tree | Private 2 | 3x3 | 5992963 | 2086633 | 37.709093057148 | -122.466087289133 | (37.709093057148, -122.466087289133) | 9 | 8 | 6 | 28861 | 25 | |||||
| 172476 | 98706 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 353 UPPER TER | Unaccepted Street : Yard | Tree | Private 2 | 5999086.1 | 2105914.9 | 37.7623879420949 | -122.446311165521 | (37.7623879420949, -122.446311165521) | 15 | 5 | 5 | 29492 | 9 | ||||||
| 191057 | 100769 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 3701 21st St | Front Yard : Yard | Tree | Private 2 | 55 | Street tree w/in RoW | 6003717 | 2103606 | 37.7563116466144 | -122.43012988292 | (37.7563116466144, -122.43012988292) | 2 | 4 | 5 | 28862 | 22 | ||||
| 3191 | 19565 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | -11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 100ST | |||||||||||||
| 19615 | 19566 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | -9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 100ST | |||||||||||||
| 80 | 260998 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard | Tree | SFUSD 4 | 10x10 | ||||||||||||||
| 106 | 251438 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2501X Santiago St | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 251 | 187669 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 554 Valley St | 1 | Median : Yard | Tree | Private 2 | 6002324 | 2099197 | 37.7441265828549 | -122.434632098307 | (37.7441265828549, -122.434632098307) | 2 | 7 | 5 | 63 | 22 | |||||
| 394 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 299x Avalon Ave | 1 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
| 509 | 19905 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 120ST | |||||||||||||
| 703 | 262210 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2011 Bay Shore Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6012422 | 2088364 | 37.7149494891568 | -122.398955034798 | (37.7149494891568, -122.398955034798) | 10 | 3 | 8 | 309 | 1 | ||||
| 838 | 264883 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1624 48th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5981321 | 2103997 | 37.7560913197894 | -122.50761065519 | (37.7560913197894, -122.50761065519) | 1 | 8 | 3 | 56 | 35 | ||||
| 945 | 217846 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Woodacre Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 54 | 5991427.31798 | 2095733.50913 | 37.7339920935414 | -122.472057659936 | (37.7339920935414, -122.472057659936) | 1 | 8 | 4 | 64 | 40 | ||||
| 1051 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
| 2239 | 253844 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 150 Junipero Serra Blvd | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 5991384 | 2095197 | 37.7325164679088 | -122.472168327848 | (37.7325164679088, -122.472168327848) | 1 | 8 | 4 | 64 | 40 | ||||
| 2282 | 19424 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | 1 | 8 | 3 | 64 | 35 | |||
| 2599 | 122257 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Clement St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/16/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 784386 | 5991472.52373 | 2113448.553 | 37.7826355430647 | -122.473192897736 | (37.7826355430647, -122.473192897736) | 11 | 6 | 2 | 54 | 26 | |
| 2644 | 113698 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 80 LINARES AVE | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 5994154.8 | 2102090.7 | 37.7516048020548 | -122.463089089164 | (37.7516048020548, -122.463089089164) | 1 | 8 | 4 | 29491 | 40 | |||||
| 4336 | 20312 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 101X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
| 4372 | 21160 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5985027.9083074 | 2099542.6271361 | 37.744078511576 | -122.494462762583 | (37.744078511576, -122.494462762583) | 1 | 8 | 3 | 29491 | 35 | |||
| 5238 | 92559 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | |||
| 5438 | 20428 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 485X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 40 | |||||||||||||
| 6028 | 261967 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 299x Portola Dr | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 6226 | 261544 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X Sloat Blvd | 1 | Median : Cutout | Tree | Private 2 | 10x10 | 5989247 | 2095899 | 37.7343200773404 | -122.47960770916 | (37.7343200773404, -122.47960770916) | 1 | 8 | 4 | 64 | 35 | ||||
| 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 | ||||
| 6858 | 261031 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 150 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6011107 | 2121175 | 37.8049677916951 | -122.405810090856 | (37.8049677916951, -122.405810090856) | 3 | 1 | 10 | 308 | 23 | ||||
| 7257 | 260076 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 43 Rockwood Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995749 | 2098768 | 37.7425732008551 | -122.457335823598 | (37.7425732008551, -122.457335823598) | 1 | 8 | 4 | 59 | 40 | ||||
| 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 | ||||
| 7283 | 176114 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Zoo Rd | 1 | Front Yard : Yard | Tree | Private 2 | 24 | Width 10ft | 5982696.49512 | 2094384.4536 | 37.7297788507039 | -122.502142508582 | (37.7297788507039, -122.502142508582) | 1 | 8 | 4 | 64 | 14 | |||
| 7781 | 102468 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 50 Saint Germain Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5998217.7 | 2104179.8 | 37.7575741573713 | -122.449189617767 | (37.7575741573713, -122.449189617767) | 15 | 5 | 4 | 28862 | 38 | |||||
| 7813 | 206807 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 11x Saint Francis Blvd | 1 | Median : Yard | Tree | DPW 1 | 12 | 5991689.22153 | 2095992.93147 | 37.7347195542573 | -122.471171081279 | (37.7347195542573, -122.471171081279) | 9 | 8 | 4 | 59 | 40 | ||||
| 8411 | 19699 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY11 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 40ST | |||||||||||||
| 8421 | 126411 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3398 Pierce St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 3ft | 6001324.1548 | 2120088.88928 | 37.8014336702784 | -122.439586737243 | (37.8014336702784, -122.439586737243) | 13 | 9 | 1 | 57 | 17 | |||
| 9387 | 19932 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
| 10025 | 264885 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1279 44th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 787806 | 5982392 | 2106415 | 37.7627934961857 | -122.504085938563 | (37.7627934961857, -122.504085938563) | 1 | 8 | 3 | 56 | 35 | |||
| 10088 | 253978 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 441 Detroit St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x10 | 5999396 | 2094599 | 37.7313349085161 | -122.444426062201 | (37.7313349085161, -122.444426062201) | 9 | 7 | 4 | 59 | 40 | ||||
| 10143 | 256870 | Planning Code 138.1 required 2 | Cupressus macrocarpa :: Monterey Cypress 41 | 30X Bernal Heights Blvd | 1 | Back Yard : Cutout | Tree | Private 2 | 12x6 | ||||||||||||||
| 10153 | 262205 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Lois Ln | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6012244 | 2087959 | 37.7138275196569 | -122.39954186434 | (37.7138275196569, -122.39954186434) | 10 | 3 | 8 | 309 | 1 | ||||
| 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 | |||
| 10672 | 223744 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 591 27th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6002700.25317 | 2100030.09519 | 37.7464354200694 | -122.433390619685 | (37.7464354200694, -122.433390619685) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||||
| 11463 | 260828 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 165 Cerritos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5991854 | 2092943 | 37.7263547341381 | -122.470379348754 | (37.7263547341381, -122.470379348754) | 9 | 8 | 4 | 59 | 40 | ||||
| 11921 | 263623 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 980 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008397 | 2119007 | 37.7988630807128 | -122.415034830901 | (37.7988630807128, -122.415034830901) | 5 | 1 | 10 | 308 | 32 | ||||
| 12152 | 255704 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 201X Hernandez Ave | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5995122 | 2099706 | 37.7451126829106 | -122.459571712369 | (37.7451126829106, -122.459571712369) | 1 | 8 | 4 | 59 | 40 | ||||
| 12287 | 95982 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 Vasquez Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5995122.4 | 2099706.3 | 37.7451135296363 | -122.459570350972 | (37.7451135296363, -122.459570350972) | 1 | 8 | 4 | 59 | 40 | |||||
| 12390 | 20412 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
| 12971 | 253842 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100X Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5991400 | 2095443 | 37.7331928478719 | -122.472130937334 | (37.7331928478719, -122.472130937334) | 1 | 8 | 4 | 64 | 40 | ||||
| 13064 | 19694 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY7 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 12ST | |||||||||||||
| 13149 | 260567 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
| 13318 | 262248 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 4210 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
| 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 | ||||
| 13718 | 251364 | Private 9 | Cupressus macrocarpa :: Monterey Cypress 41 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | |||||||||||||||
| 13972 | 260573 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 129 Edgehill Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5994858 | 2098970 | 37.7430766268484 | -122.460431252252 | (37.7430766268484, -122.460431252252) | 1 | 8 | 4 | 59 | 40 | ||||
| 13998 | 206803 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 300 Ortega St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5993087.14993 | 2102582.23712 | 37.7528928770087 | -122.466816856226 | (37.7528928770087, -122.466816856226) | 1 | 8 | 4 | 56 | 12 | ||||
| 14203 | 20280 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
| 14256 | 258777 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x10 | 5993535 | 2092458 | 37.725120092529 | -122.464533057261 | (37.725120092529, -122.464533057261) | 9 | 8 | 4 | 59 | 40 | ||||
| 14608 | 259056 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99 Cedro Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784357 | 5992279 | 2093128 | 37.7268872622364 | -122.468923614031 | (37.7268872622364, -122.468923614031) | 9 | 8 | 4 | 59 | 40 | |
| 15210 | 260508 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 299 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994794 | 2101316 | 37.7495144720577 | -122.460822530701 | (37.7495144720577, -122.460822530701) | 1 | 8 | 4 | 29491 | 40 | ||||
| 15397 | 20618 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1492X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984803.7392562 | 2105036.6950477 | 37.7591505890295 | -122.495643037613 | (37.7591505890295, -122.495643037613) | 1 | 8 | 3 | 56 | 35 | |||
| 15603 | 251321 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Monument Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | |||||||||||||||
| 16654 | 261545 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Sloat Blvd | 1 | Median : Cutout | Tree | Private 2 | 10x10 | 5989483 | 2096058 | 37.7347703567949 | -122.478803415035 | (37.7347703567949, -122.478803415035) | 1 | 8 | 3 | 64 | 35 | ||||
| 16810 | 254987 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 850 Junipero Serra Blvd | 1 | Median : Cutout | Tree | Private 2 | 10x10 | 5991239 | 2091717 | 37.7229528649662 | -122.472416015965 | (37.7229528649662, -122.472416015965) | 9 | 8 | 4 | 64 | 40 | ||||
| 16989 | 106642 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 4540X 17TH ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5999139 | 2105833 | 37.7621660862312 | -122.446122313424 | (37.7621660862312, -122.446122313424) | 15 | 5 | 5 | 29492 | 3 | ||||
| 17534 | 261947 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 17641 | 262215 | Landmark tree 11 | Cupressus macrocarpa :: Monterey Cypress 41 | 2626 Vallejo St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6001000 | 2117623 | 37.7946445343139 | -122.440531492639 | (37.7946445343139, -122.440531492639) | 13 | 9 | 1 | 57 | 27 | ||||
| 18265 | 249711 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2901 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 5999592.84448 | 2116997.53125 | 37.7928469352999 | -122.445355424115 | (37.7928469352999, -122.445355424115) | 13 | 9 | 1 | 29490 | 27 | ||||
| 18542 | 19869 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY33 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 25ST | |||||||||||||
| 18711 | 262449 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 155 Baker St | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 6000750.251 | 2109577.8851 | 37.7725404908768 | -122.440818271359 | (37.7725404908768, -122.440818271359) | 15 | 5 | 11 | 29492 | 9 | ||||
| 19500 | 20013 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY47 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
| 20228 | 251632 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 14R Amethyst Way | 1 | Back Yard : Yard | Tree | Private 2 | 5999202 | 2100044 | 37.7462745109784 | -122.445488137723 | (37.7462745109784, -122.445488137723) | 2 | 7 | 5 | 63 | 22 | |||||
| 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 | |||
| 21002 | 223796 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 208 States St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 6000981.15252 | 2106412.23532 | 37.7638615509979 | -122.439792556095 | (37.7638615509979, -122.439792556095) | 15 | 5 | 5 | 28862 | 3 | |||
| 21037 | 181441 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1400 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5984891.7288 | 2105036.7347 | 37.759155850149 | -122.495338735135 | (37.759155850149, -122.495338735135) | 1 | 8 | 3 | 56 | 35 | |||
| 21554 | 256452 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 2901 Sunset Blvd | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
| 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 | ||||
| 21615 | 254127 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100X Lake Merced Blvd | 1 | Median : Yard | Tree | DPW 1 | 10x10 | 5983894 | 2095251 | 37.7322284370415 | -122.498066633405 | (37.7322284370415, -122.498066633405) | 1 | 8 | 4 | 64 | 35 | ||||
| 21700 | 206891 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1675x 15th Ave | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 24 | Width 3ft | 5991393.55964 | 2103864.47578 | 37.7563156787487 | -122.472767037095 | (37.7563156787487, -122.472767037095) | 1 | 8 | 4 | 56 | 12 | |||
| 21932 | 85238 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 200 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2007 12:00:00 AM | Permit Number 49542 | 5994792 | 2096029 | 37.7349975719357 | -122.460446404237 | (37.7349975719357, -122.460446404237) | 9 | 8 | 4 | 59 | 40 | |||
| 22040 | 251614 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 64R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999367 | 2100045 | 37.7462866749207 | -122.444917661566 | (37.7462866749207, -122.444917661566) | 2 | 7 | 5 | 63 | 22 | |||||
| 22321 | 256538 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 19 Miguel St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003470 | 2097467 | 37.7394413932778 | -122.430546066859 | (37.7394413932778, -122.430546066859) | 2 | 7 | 5 | 63 | 7 | ||||
| 22778 | 120919 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 198X Miraloma Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x10 | 5994595 | 2096392 | 37.7359829456919 | -122.461153801837 | (37.7359829456919, -122.461153801837) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||||
| 24231 | 93107 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 15 Mesa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 3x3 | Permit Number 53163 | 5993680.1 | 2100698.2 | 37.7477539957997 | -122.464629544553 | (37.7477539957997, -122.464629544553) | 1 | 8 | 4 | 29491 | 40 | ||
| 24527 | 114055 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X LAKE MERCED BLVD | 1 | Median : Cutout | Tree | Private 2 | 50 | 5987837 | 2092819 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | 1 | 8 | 4 | 64 | 14 | ||||
| 24607 | 258657 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10X Mendosa Ave | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 5993533 | 2101170 | 37.749040957039 | -122.465172468022 | (37.749040957039, -122.465172468022) | 1 | 8 | 4 | 29491 | 40 | ||||
| 25399 | 252916 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001472 | 2098865 | 37.7431665844065 | -122.437554349716 | (37.7431665844065, -122.437554349716) | 2 | 7 | 5 | 63 | 7 | ||||
| 25541 | 223788 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 798 Sanchez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 48 | Width 3ft | 6003684.1064 | 2103653.23065 | 37.7564394677117 | -122.430247009802 | (37.7564394677117, -122.430247009802) | 2 | 4 | 5 | 28862 | 3 | |||
| 27160 | 111763 | Landmark tree 11 | Cupressus macrocarpa :: Monterey Cypress 41 | 2626 Vallejo St | 1 | Back Yard : Yard | Tree | Private 2 | 6001000.6 | 2117623.4 | 37.7946456667745 | -122.440529445268 | (37.7946456667745, -122.440529445268) | 13 | 9 | 1 | 57 | 27 | |||||
| 29097 | 223789 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 190 Storrie St | 1 | Front Yard : Yard | Tree | Private 2 | 20 | Width 3ft | 6000719.29532 | 2105252.42792 | 37.7606620968006 | -122.440615044554 | (37.7606620968006, -122.440615044554) | 15 | 4 | 5 | 28862 | 3 | |||
| 29728 | 20746 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1692X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
| 29915 | 11191 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 148 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 48 | 8 | 5995624.0655798 | 2099382.6906533 | 37.7442538125131 | -122.457812277707 | (37.7442538125131, -122.457812277707) | 1 | 8 | 4 | 59 | 40 | |||
| 30129 | 206804 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 60X Aerial Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 4ft | 5992441 | 2102652 | 37.7530471147259 | -122.469056420341 | (37.7530471147259, -122.469056420341) | 1 | 8 | 4 | 56 | 12 |
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) );