trees
2,306 rows where qSpecies_id = 15 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13832 | 259913 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 23 Cresta Vista Dr | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5995254 | 2096176 | 37.7354277647167 | -122.45885975654 | (37.7354277647167, -122.45885975654) | 9 | 7 | 4 | 59 | 40 | ||||
| 14470 | 261472 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 1 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
| 14751 | 261503 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 10 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 14911 | 264785 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1738 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10x10 | 5991929 | 2103547 | 37.7554749546691 | -122.470892190435 | (37.7554749546691, -122.470892190435) | 1 | 8 | 4 | 56 | 12 | ||||
| 15093 | 119607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 299x Avalon Ave | 3 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
| 15154 | 102838 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 15325 | 261502 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 9 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 15529 | 261501 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 8 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 15991 | 262259 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 Everglade Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 15996 | 258691 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 100x Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
| 16100 | 261494 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 16107 | 262406 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2827 Cesar Chavez St | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010428 | 2100696 | 37.7486992403688 | -122.406715738075 | (37.7486992403688, -122.406715738075) | 2 | 4 | 7 | 28859 | 2 | ||||
| 16196 | 251543 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard | Tree | Private 2 | ||||||||||||||||
| 16522 | 262483 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 10X Alpha St | 1 | Median : Yard | Tree | Private 2 | 3x3 | 6011300 | 2088596 | 37.7155239289484 | -122.402849469545 | (37.7155239289484, -122.402849469545) | 9 | 7 | 8 | 309 | 39 | ||||
| 16627 | 261498 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 5 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 16700 | 262531 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 23X Knollview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5997470 | 2101306 | 37.7496406233362 | -122.451568168016 | (37.7496406233362, -122.451568168016) | 1 | 5 | 4 | 63 | 38 | ||||
| 16781 | 260951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 190 Jackson St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6013038 | 2118237 | 37.7970085486816 | -122.398921272101 | (37.7970085486816, -122.398921272101) | 3 | 1 | 10 | 28860 | 6 | ||||
| 17052 | 261499 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 6 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 17333 | 259266 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 17896 | 100177 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 252 States St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 768965 | 6000636 | 2106677.4 | 37.7645699751489 | -122.44100535545 | (37.7645699751489, -122.44100535545) | 15 | 5 | 5 | 28862 | 3 | ||||
| 17997 | 122419 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2200 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | ||||
| 18320 | 261763 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 315 Montcalm St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009577 | 2099558 | 37.7455268923792 | -122.409578193595 | (37.7455268923792, -122.409578193595) | 2 | 7 | 7 | 28859 | 2 | ||||
| 18372 | 121500 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 251X Pennsylvania Ave | 1 | Back Yard : Yard | Tree | DPW 1 | |||||||||||||||
| 18957 | 259263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 19052 | 260948 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 370 Drumm St | 1 | Side Yard : Yard | Tree | Private 2 | 6013616 | 2118213 | 37.7969748404412 | -122.396919555024 | (37.7969748404412, -122.396919555024) | 3 | 1 | 10 | 28860 | 6 | |||||
| 19174 | 261294 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 801 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 6012760.41981 | 2103766.81895 | 37.7572612683759 | -122.398865686828 | (37.7572612683759, -122.398865686828) | 10 | 3 | 8 | 28856 | 29 | |||||
| 19246 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 3 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784513 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |||
| 19314 | 114270 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 27x ESMERALDA AVE | 2 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 6006799 | 2098981 | 37.743786524331 | -122.41914318493 | (37.743786524331, -122.41914318493) | 2 | 7 | 7 | 28859 | 2 | ||||
| 19616 | 262407 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 300 Font Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x5 | 5990018 | 2089729 | 37.7174235665943 | -122.476491559856 | (37.7174235665943, -122.476491559856) | 1 | 8 | 4 | 64 | 14 | ||||
| 19844 | 254259 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 20737 | 114465 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 404 Noriega St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992802 | 2103239 | 37.754679716601 | -122.467850713731 | (37.754679716601, -122.467850713731) | 1 | 8 | 4 | 56 | 12 | |||||
| 20972 | 254094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 781012 | 5994209 | 2099943 | 37.7457108840866 | -122.462745872627 | (37.7457108840866, -122.462745872627) | 1 | 8 | 4 | 29491 | 40 | |||
| 21767 | 109635 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2X GENEVA AVE | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 5997165.4 | 2091482.5 | 37.7226502134341 | -122.451912865332 | (37.7226502134341, -122.451912865332) | 9 | 8 | 6 | 28861 | 24 | ||||
| 22171 | 251481 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 32 Peralta Ave | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010779 | 2100499 | 37.7481779538542 | -122.405488104269 | (37.7481779538542, -122.405488104269) | 2 | 7 | 7 | 28859 | 2 | ||||
| 22607 | 254291 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 110 Junipero Serra Blvd | 3 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
| 23065 | 98547 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 555@Rio Teresita Blvd | 3 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
| 23171 | 109911 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1062X Carolina St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476 | (37.7552131559276, -122.39986897476) | 10 | 3 | 8 | 28856 | 29 | |||||
| 23401 | 114142 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99 Divisadero St | Front Yard : Yard | Tree | Private 2 | 6001906.1 | 2108188.4 | 37.7687910682296 | -122.436720598265 | (37.7687910682296, -122.436720598265) | 15 | 5 | 5 | 29492 | 3 | ||||||
| 23614 | 173920 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2160X 09th Ave | 8 | Median : Cutout | Tree | DPW 1 | 6x10 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | ||||
| 24444 | 173927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 240 States St | 1 | Back Yard : Yard | Tree | Private 2 | 6001213 | 2106258 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | 15 | 5 | 5 | 28862 | 3 | |||||
| 24612 | 99521 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 20 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | |||
| 24981 | 115647 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 13 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
| 25777 | 257968 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
| 26419 | 256644 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2X Miraloma Dr | 3 | Side Yard : Cutout | Tree | DPW 1 | 10x10 | 5994995 | 2097925 | 37.7402151966004 | -122.459881864698 | (37.7402151966004, -122.459881864698) | 9 | 8 | 4 | 59 | 40 | ||||
| 26584 | 104941 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 133X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | 1 | 8 | 4 | 64 | 14 | ||||||
| 26965 | 111402 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 50x SANTA RITA AVE | 7 | Median : Yard | Tree | Private 2 | 29 | 5993713 | 2100532 | 37.7472995494238 | -122.464503713167 | (37.7472995494238, -122.464503713167) | 1 | 8 | 4 | 29491 | 40 | ||||
| 27633 | 113114 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1x TOMASO CT | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
| 27645 | 251483 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Bosworth St | 8 | Front Yard : Yard | Tree | DPW 1 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | |||||
| 27745 | 115653 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 19 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
| 28217 | 258038 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 55 Mercedes Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5991909 | 2093425 | 37.7276813664439 | -122.470224302167 | (37.7276813664439, -122.470224302167) | 9 | 8 | 4 | 59 | 40 | ||||
| 28314 | 256608 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 279 Oak Park Dr | 2 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5995764 | 2102990 | 37.7541666190925 | -122.457589367448 | (37.7541666190925, -122.457589367448) | 1 | 5 | 4 | 63 | 12 | ||||
| 28400 | 99274 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 16 Joy St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | Permit Number 768828 | 6010347.9 | 2098933.4 | 37.7438550437031 | -122.406868515265 | (37.7438550437031, -122.406868515265) | 2 | 7 | 7 | 28859 | 2 | |||
| 28834 | 251489 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Bosworth St | 31 | Front Yard : Yard | Tree | DPW 1 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | |||||
| 29224 | 116662 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199x Esmeralda Ave | 15 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 29414 | 120559 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 298X Bemis St | 1 | Front Yard : Yard | Tree | Private 2 | 6002876 | 2096191 | 37.7359041225922 | -122.432508740106 | (37.7359041225922, -122.432508740106) | 2 | 7 | 5 | 63 | 7 | |||||
| 29553 | 258673 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 150X Garcia Ave | 3 | Median : Cutout | Tree | Private 2 | 3x3 | 5994686 | 2099448 | 37.7443791992458 | -122.461060616503 | (37.7443791992458, -122.461060616503) | 1 | 8 | 4 | 59 | 40 | ||||
| 29719 | 111573 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1x SUNSET BLVD OFF RAMP | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 5984955 | 2095624 | 37.7333147463652 | -122.494426056577 | (37.7333147463652, -122.494426056577) | 1 | 8 | 4 | 64 | 35 | ||||
| 29992 | 253818 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 219 Concord St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | 9 | 7 | 6 | 28861 | 5 | ||||
| 30069 | 256475 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2901X Sunset Blvd Off Ramp | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5985408 | 2095918 | 37.7341484934627 | -122.49288158081 | (37.7341484934627, -122.49288158081) | 1 | 8 | 3 | 29491 | 35 | ||||
| 30323 | 122488 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 69x Bonview St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
| 30556 | 104909 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 533 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 30619 | 114927 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | ||||
| 30806 | 52742 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 432@ NOE 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2006 12:00:00 AM | Permit Number 48791 | 6003090.32224136 | 2099513.72726182 | 37.7450397163723 | -122.4320049394 | (37.7450397163723, -122.4320049394) | 2 | 7 | 5 | 63 | 22 | |||
| 31165 | 258674 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 150X Garcia Ave | 4 | Median : Cutout | Tree | Private 2 | 3x3 | 5994686 | 2099448 | 37.7443791992458 | -122.461060616503 | (37.7443791992458, -122.461060616503) | 1 | 8 | 4 | 59 | 40 | ||||
| 32242 | 173916 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2160X 09th Ave | 4 | Median : Cutout | Tree | DPW 1 | 6x10 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | ||||
| 33354 | 173755 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X Emil Ln | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5996276 | 2095955 | 37.7348796446223 | -122.455310374086 | (37.7348796446223, -122.455310374086) | 9 | 7 | 4 | 59 | 40 | ||||
| 33460 | 115831 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1X JUNIPERO SERRA BLVD OFF RAMP | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | ||||
| 33684 | 97290 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 55 Hiliritas Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 778896 | 6001461.7 | 2096833.2 | 37.7375871516219 | -122.437444499981 | (37.7375871516219, -122.437444499981) | 2 | 7 | 5 | 63 | 7 | |||||
| 34127 | 254296 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 130X Junipero Serra Blvd | 2 | Median : Yard | Tree | Private 2 | 10x30 | 5991393 | 2095322 | 37.7328602072681 | -122.472146321186 | (37.7328602072681, -122.472146321186) | 1 | 8 | 4 | 64 | 40 | ||||
| 34428 | 251636 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 22R Amethyst Way | 1 | Back Yard : Yard | Tree | Private 2 | 5999148 | 2100052 | 37.7462933941297 | -122.445675437709 | (37.7462933941297, -122.445675437709) | 2 | 7 | 5 | 63 | 22 | |||||
| 34533 | 110193 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 7X CASTRO ST | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002014.1 | 2108690 | 37.7701744750285 | -122.436382938918 | (37.7701744750285, -122.436382938918) | 15 | 5 | 5 | 29492 | 9 | ||||
| 34770 | 251426 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5020 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999455 | 2100046 | 37.7462944425817 | -122.444613441074 | (37.7462944425817, -122.444613441074) | 2 | 7 | 5 | 63 | 22 | |||||
| 35278 | 115415 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 137 ANZAVISTA AVE | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5999865 | 2112093 | 37.7793958997315 | -122.444061187374 | (37.7793958997315, -122.444061187374) | 15 | 5 | 1 | 29490 | 16 | ||||
| 35918 | 109061 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 36 ARBOR ST | Front Yard : Yard | Tree | Private 2 | Permit Number 774913 | 6002094.4 | 2096943.6 | 37.7379262346414 | -122.435264853151 | (37.7379262346414, -122.435264853151) | 2 | 7 | 5 | 63 | 7 | |||||
| 36364 | 115642 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 8 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
| 37079 | 104885 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 134 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 37143 | 257967 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
| 37646 | 110789 | Section 143 10 | Pinus radiata :: Monterey Pine 15 | 850x SANCHEZ ST | 3 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6003717 | 2103349 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | 2 | 4 | 5 | 28862 | 22 | ||||
| 38051 | 108038 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | 5998985.48572 | 2105240.3128 | 37.7605299471227 | -122.446610614338 | (37.7605299471227, -122.446610614338) | 15 | 5 | 5 | 28862 | 12 | ||||||
| 38301 | 79685 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 2 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2008 12:00:00 AM | 3x3 | Permit Number 50355 | 6007801.88811391 | 2088315.49386025 | 37.7145577712837 | -122.414920709681 | (37.7145577712837, -122.414920709681) | 9 | 7 | 8 | 309 | 39 | ||
| 38797 | 173896 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 326x Dellbrook Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997295 | 2102064 | 37.7517118802849 | -122.452228008054 | (37.7517118802849, -122.452228008054) | 1 | 5 | 4 | 63 | 38 | ||||
| 39032 | 251604 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 48R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999482 | 2100041 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | 2 | 7 | 5 | 63 | 22 | |||||
| 39088 | 255806 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 255X Evelyn Way | 1 | Median : Yard | Tree | PUC 8 | 10x10 | 5998108 | 2098711 | 37.742551901709 | -122.449175024155 | (37.742551901709, -122.449175024155) | 9 | 7 | 4 | 59 | 40 | ||||
| 39321 | 120597 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 39580 | 255145 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1601x 19th St | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6012900 | 2105148 | 37.7610614650441 | -122.398479874828 | (37.7610614650441, -122.398479874828) | 10 | 3 | 8 | 28856 | 29 | ||||
| 39981 | 256672 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 15 Kenwood Way | 11 | Back Yard : Yard | Tree | Private 2 | 30x30 | 5994751 | 2093714 | 37.7286387886762 | -122.4604204683 | (37.7286387886762, -122.4604204683) | 9 | 8 | 4 | 59 | 40 | ||||
| 40432 | 110929 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 445 BEACON ST | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002243 | 2098437 | 37.7420352018096 | -122.434857838675 | (37.7420352018096, -122.434857838675) | 2 | 7 | 5 | 63 | 7 | |||||
| 40755 | 95686 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 373 Castenada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2011 12:00:00 AM | Permit Number 56980 | 5993476.3 | 2100002.1 | 37.7458309308973 | -122.465283713064 | (37.7458309308973, -122.465283713064) | 1 | 8 | 4 | 29491 | 40 | |||
| 40774 | 85020 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 299 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994525 | 2094707 | 37.7313523209144 | -122.461273710807 | (37.7313523209144, -122.461273710807) | 9 | 8 | 4 | 59 | 40 | |||||
| 41301 | 108215 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 865 EL CAMINO DEL MAR | 1 | Front Yard : Yard | Tree | Private 2 | 5985761 | 2114995 | 37.7865492821054 | -122.493065995445 | (37.7865492821054, -122.493065995445) | 11 | 6 | 1 | 55 | 33 | |||||
| 43332 | 110591 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1160X PORTOLA DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994964 | 2098019 | 37.7404715144277 | -122.459995857341 | (37.7404715144277, -122.459995857341) | 1 | 8 | 4 | 59 | 40 | ||||
| 43863 | 57589 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 93 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50021 | 6001851.03848289 | 2096750.6660448 | 37.7373826596428 | -122.436092469726 | (37.7373826596428, -122.436092469726) | 2 | 7 | 5 | 63 | 7 | ||
| 43876 | 114817 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 100 RACCOON DR | 1 | Back Yard : Cutout | Tree | Private 2 | 5998725 | 2104028 | 37.757186355085 | -122.447424250084 | (37.757186355085, -122.447424250084) | 15 | 5 | 5 | 63 | 3 | |||||
| 44195 | 98552 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 143@Gladview Skyview Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5997951.6 | 2102231.3 | 37.752208836846 | -122.449969465547 | (37.752208836846, -122.449969465547) | 1 | 5 | 4 | 63 | 38 | |||||
| 44600 | 107186 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 945 Sacramento St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.408109042355 | (37.7928004918921, -122.408109042355) | 3 | 1 | 10 | 28857 | 4 | ||||
| 44800 | 120594 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 44870 | 256450 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 3001 Sunset Blvd | 34 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 45339 | 253119 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 185 Belgrave Ave | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 780239 | 5997636.85301 | 2104869.74588 | 37.7594353359783 | -122.45124816933 | (37.7594353359783, -122.45124816933) | 15 | 5 | 11 | 28862 | 12 | ||||
| 46911 | 113122 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1x TOMASO CT | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
| 47218 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1160 Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.401550680127 | (37.8018575696458, -122.401550680127) | 3 | 1 | 10 | 28860 | 6 |
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) );