trees
2,306 rows where qSpecies_id = 15 sorted by rowid descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186240 | 181482 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1400 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984871.1213 | 2105328.0244 | 37.7599544438665 | -122.495431487911 | (37.7599544438665, -122.495431487911) | 1 | 8 | 3 | 56 | 35 | |||
| 186169 | 255374 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Brotherhood Way | 21 | Median : Cutout | Tree | Private 2 | 5x10 | 5988860 | 2088745 | 37.7146545182747 | -122.480422197946 | (37.7146545182747, -122.480422197946) | 1 | 8 | 4 | 64 | 14 | ||||
| 186165 | 178319 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 5988184.71166 | 2090359.26888 | 37.7190476283173 | -122.482874477988 | (37.7190476283173, -122.482874477988) | 1 | 8 | 4 | 64 | 14 | ||||
| 186160 | 194487 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 889 Vermont St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6011310.90217 | 2104196.73215 | 37.7583608404945 | -122.403908964334 | (37.7583608404945, -122.403908964334) | 10 | 3 | 8 | 28856 | 29 | ||||
| 186134 | 21111 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2201X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5985004.6737667 | 2100227.1692458 | 37.7459567185928 | -122.494593556276 | (37.7459567185928, -122.494593556276) | 1 | 8 | 3 | 29491 | 35 | |||
| 186015 | 97536 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 300 Winfield St | 2 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 768224 | 6006649.9 | 2098038.3 | 37.7411896837785 | -122.419591868256 | (37.7411896837785, -122.419591868256) | 2 | 7 | 7 | 28859 | 2 | ||||
| 185979 | 185194 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2500 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985119.413 | 2097901.151 | 37.7395768155997 | -122.49402541183 | (37.7395768155997, -122.49402541183) | 1 | 8 | 3 | 29491 | 35 | |||
| 185927 | 21508 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2800X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5985062.864215 | 2096221.8871717 | 37.7349626975104 | -122.494097196305 | (37.7349626975104, -122.494097196305) | 1 | 8 | 3 | 29491 | 35 | |||
| 185748 | 114117 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 185742 | 111409 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 150x SAN MARCOS AVE | 4 | Median : Yard | Tree | Private 2 | 45 | 5993566 | 2100407 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | 1 | 8 | 4 | 29491 | 40 | ||||
| 185680 | 132195 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Priest St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 6008338.31576 | 2117104.3343 | 37.7936355337159 | -122.415103148693 | (37.7936355337159, -122.415103148693) | 5 | 1 | 10 | 28858 | 21 | |||
| 185670 | 181407 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1500 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 0ft | 5984912.8932 | 2104709.5212 | 37.758258652087 | -122.495241409198 | (37.758258652087, -122.495241409198) | 1 | 8 | 3 | 56 | 35 | |||
| 185468 | 120977 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 794x Gates St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3030 | 3x3 | 6008103 | 2095407 | 37.7340464539486 | -122.414381414226 | (37.7340464539486, -122.414381414226) | 2 | 7 | 7 | 28859 | 2 | |||
| 185407 | 211285 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 446 Circular Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 51 | 5999677.3469 | 2093670.53528 | 37.7288016096033 | -122.443386731723 | (37.7288016096033, -122.443386731723) | 9 | 7 | 4 | 63 | 40 | ||||
| 185275 | 186658 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 15 | Median : Yard | Tree | DPW 1 | 1 | Width 0ft | 5984710.2715 | 2105562.1346 | 37.7605878254343 | -122.496005052394 | (37.7605878254343, -122.496005052394) | 1 | 8 | 3 | 56 | 35 | |||
| 185233 | 186735 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984872.2705 | 2106567.4256 | 37.7633575601075 | -122.495518926934 | (37.7633575601075, -122.495518926934) | 1 | 8 | 3 | 56 | 35 | |||
| 184807 | 251231 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 164 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989598 | 2090848 | 37.7204716934452 | -122.478025052476 | (37.7204716934452, -122.478025052476) | 1 | 8 | 4 | 64 | 14 | ||||
| 184664 | 249698 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Baker St | 30 | Front Yard : Yard | Tree | Private 2 | 23 | 5999693.94716 | 2117283.58349 | 37.7936381300369 | -122.445026178739 | (37.7936381300369, -122.445026178739) | 13 | 9 | 1 | 57 | 27 | ||||
| 184486 | 20865 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1892X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
| 184434 | 211171 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 799X Joost Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5996890.68246 | 2094989.43242 | 37.7322636775066 | -122.453115533756 | (37.7322636775066, -122.453115533756) | 9 | 7 | 4 | 59 | 40 | |||
| 184386 | 116462 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 66 AERIAL WAY | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5992280 | 2102576 | 37.7528291346084 | -122.469607652393 | (37.7528291346084, -122.469607652393) | 1 | 8 | 4 | 56 | 12 | ||||
| 184040 | 111512 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800x BOSWORTH ST | 7 | Front Yard : Yard | Tree | DPW 1 | 36 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 183946 | 112252 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 5301x DIAMOND HEIGHTS BLVD | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 3x3 | 6001927 | 2098732 | 37.7428272563398 | -122.435971568238 | (37.7428272563398, -122.435971568238) | 2 | 7 | 5 | 63 | 22 | ||||
| 183945 | 20802 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1792X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.495403216296 | (37.7535582155387, -122.495403216296) | 1 | 8 | 3 | 56 | 35 | |||
| 183788 | 119619 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5399X Diamond Heights Blvd | 1 | Median : Cutout | Tree | DPW 1 | 14 | 3x3 | 6002094 | 2098221 | 37.7414336554128 | -122.435357585161 | (37.7414336554128, -122.435357585161) | 2 | 7 | 5 | 63 | 7 | |||
| 183601 | 256482 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 168 Moultrie St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 6007766 | 2098288 | 37.7419381097545 | -122.415750458671 | (37.7419381097545, -122.415750458671) | 2 | 7 | 7 | 28859 | 2 | ||||
| 183512 | 87114 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 470 West Portal Ave | 5 | unknown : Yard | Tree | Private 2 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694 | 2096460 | 37.7360022829337 | -122.471188578306 | (37.7360022829337, -122.471188578306) | 1 | 8 | 4 | 29491 | 40 | |||
| 183500 | 98157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 149x Chaves Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | 9 | 7 | 4 | 59 | 40 | |||||
| 183494 | 211110 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 4 | Median : Yard | Tree | DPW 1 | 27 | Width 8ft | 5994195.56932 | 2101082.15648 | 37.7488379463106 | -122.462874943327 | (37.7488379463106, -122.462874943327) | 1 | 8 | 4 | 29491 | 40 | |||
| 183184 | 185168 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2500 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 0ft | 5985132.0298 | 2097721.8603 | 37.7390852696928 | -122.493968579127 | (37.7390852696928, -122.493968579127) | 1 | 8 | 3 | 29491 | 35 | |||
| 183086 | 30137 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 951X Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 6 | 6009107.481074 | 2089998.64143 | 37.7192526227275 | -122.410526818188 | (37.7192526227275, -122.410526818188) | 9 | 3 | 7 | 309 | 28 | ||||
| 182761 | 114936 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 12 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | ||||
| 182311 | 94636 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 170X Crestmont Dr | 1 | Front Yard : Yard | Tree | Private 2 | 09/24/2010 12:00:00 AM | Permit Number 53783 | 5995178.5 | 2103444 | 37.7553795372421 | -122.459647037768 | (37.7553795372421, -122.459647037768) | 1 | 5 | 4 | 63 | 12 | |||
| 182252 | 20657 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.495587616201 | (37.7589182591611, -122.495587616201) | 1 | 8 | 3 | 56 | 35 | |||
| 182174 | 115437 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1 PETER YORKE WAY | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6005775 | 2114336 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | 13 | 9 | 1 | 28858 | 41 | ||||
| 182105 | 2293 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800X Brotherhood Way | 8 | Median : Cutout | Tree | DPW 1 | 30 | 14M | 5990043.77562 | 2088644.17139 | 37.7144463900703 | -122.476323268498 | (37.7144463900703, -122.476323268498) | 1 | 8 | 4 | 64 | 14 | |||
| 182097 | 114929 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 5 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | ||||
| 181967 | 20489 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
| 181936 | 233289 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1101 San Jose Ave | 53 | Front Yard : Yard | Tree | Private 2 | 23 | 6005016.45336 | 2096621.74338 | 37.7372079945558 | -122.425138977499 | (37.7372079945558, -122.425138977499) | 2 | 7 | 5 | 28859 | 2 | ||||
| 181777 | 234519 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5300x Diamond Heights Blvd | 2 | Median : Yard | Tree | DPW 1 | 14 | 6001520.34927 | 2098955.69327 | 37.7434183555852 | -122.437393663999 | (37.7434183555852, -122.437393663999) | 2 | 7 | 5 | 63 | 7 | ||||
| 181739 | 211282 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 690 Mangels Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5996823.61082 | 2095299.81595 | 37.7331120718571 | -122.453369815288 | (37.7331120718571, -122.453369815288) | 9 | 7 | 4 | 59 | 40 | |||
| 181668 | 115651 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 17 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
| 181570 | 21277 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2492X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | 1 | 8 | 3 | 29491 | 35 | |||
| 181558 | 181544 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1300 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 55 | Width 0ft | 5984863.0454 | 2105947.6415 | 37.761655266447 | -122.495505118392 | (37.761655266447, -122.495505118392) | 1 | 8 | 3 | 56 | 35 | |||
| 181489 | 178265 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 12x Canyon Dr | 11 | Median : Cutout | Tree | DPW 1 | 25 | Width 0ft | 6002756.14079 | 2086182.07734 | 37.7084150543766 | -122.432208569675 | (37.7084150543766, -122.432208569675) | 9 | 7 | 6 | 28861 | 5 | |||
| 181357 | 173620 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
| 181053 | 211178 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 522 Orizaba Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 5ft | 5994049.99241 | 2090125.0938 | 37.7187441691801 | -122.462583648419 | (37.7187441691801, -122.462583648419) | 9 | 8 | 6 | 28861 | 24 | |||
| 180982 | 113477 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100x Esmeralda Ave | 10 | Unaccepted Street : Yard | Tree | DPW 1 | 24 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | ||||
| 180950 | 21033 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2101X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | ||||
| 180941 | 233303 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5210 Diamond Heights Blvd | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 3ft | 6001133.97565 | 2099205.48267 | 37.7440822450073 | -122.438747538477 | (37.7440822450073, -122.438747538477) | 2 | 7 | 5 | 63 | 7 | |||
| 180910 | 173627 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800X Brotherhood Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 3x3 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||
| 180810 | 251196 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900X 14th St | 2 | Front Yard : Cutout | Tree | Private 2 | 03/22/2017 12:00:00 AM | 3 | 6002515 | 2107976 | 37.768242455455 | -122.434599270731 | (37.768242455455, -122.434599270731) | 15 | 5 | 5 | 28862 | 3 | |||
| 180807 | 116778 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 398x GAVEN ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 30 | 3x3 | 6008462 | 2094745 | 37.7322489055387 | -122.413093441799 | (37.7322489055387, -122.413093441799) | 9 | 3 | 7 | 309 | 28 | |||
| 180771 | 186619 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 90 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 0ft | 5984733.72 | 2104360.7115 | 37.7572904258336 | -122.495835328738 | (37.7572904258336, -122.495835328738) | 1 | 8 | 3 | 56 | 35 | |||
| 180767 | 20607 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984800.4502923 | 2105635.4093669 | 37.7607942988513 | -122.495698574627 | (37.7607942988513, -122.495698574627) | 1 | 8 | 3 | 56 | 35 | |||
| 180742 | 256453 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2901 Sunset Blvd | 2 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
| 180658 | 178241 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 240 Hahn St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | Width 10ft | 6007345.15685 | 2087110.69087 | 37.7112239590886 | -122.416414074268 | (37.7112239590886, -122.416414074268) | 9 | 7 | 8 | 309 | 39 | |||
| 180499 | 110077 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4099x ALEMANY BLVD | Median : Cutout | Tree | Private 2 | 48 | 5991599 | 2086829 | 37.7095524384103 | -122.470815701049 | (37.7095524384103, -122.470815701049) | 9 | 8 | 4 | 64 | 24 | |||||
| 180411 | 178315 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | 5988883.66138 | 2090326.3057 | 37.7189977636133 | -122.480456095784 | (37.7189977636133, -122.480456095784) | 1 | 8 | 4 | 64 | 14 | ||||
| 180287 | 116659 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199x Esmeralda Ave | 12 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 180184 | 178201 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 121 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | Width 6ft | 6006581.55782 | 2086756.79488 | 37.7102092639221 | -122.419028183127 | (37.7102092639221, -122.419028183127) | 9 | 7 | 8 | 309 | 39 | |||
| 180179 | 30071 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 5 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
| 180168 | 21069 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2192X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | 1 | 8 | 3 | 29491 | 35 | |||
| 180126 | 20655 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.495587616201 | (37.7589182591611, -122.495587616201) | 1 | 8 | 3 | 56 | 35 | |||
| 180056 | 132206 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199 Union St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6012038.33041 | 2119798.95957 | 37.8012415589072 | -122.4024902793 | (37.8012415589072, -122.4024902793) | 3 | 1 | 10 | 28860 | 6 | ||||
| 179939 | 194502 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299 Cashmere St | 17 | : | Tree | Private 2 | 14 | 6016706.5669 | 2095967.54314 | 37.7360651504892 | -122.384674961403 | (37.7360651504892, -122.384674961403) | 10 | 3 | 8 | 58 | 1 | ||||
| 179819 | 251504 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 620x Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 5992030 | 2103590 | 37.7555988620986 | -122.470546036282 | (37.7555988620986, -122.470546036282) | 1 | 8 | 4 | 56 | 12 | ||||
| 179446 | 20651 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.495587616201 | (37.7589182591611, -122.495587616201) | 1 | 8 | 3 | 56 | 35 | |||
| 179421 | 201551 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 200 Jerrold Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | 6020116.66531 | 2093486.63817 | 37.7294410644355 | -122.372713061779 | (37.7294410644355, -122.372713061779) | 10 | 3 | 8 | 58 | 1 | ||||
| 179398 | 178182 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1500 Sunnydale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 6ft | 6007434.89131 | 2087402.51035 | 37.7120302804433 | -122.416124582492 | (37.7120302804433, -122.416124582492) | 9 | 7 | 8 | 309 | 39 | |||
| 179370 | 113659 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 855x CLIPPER ST | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 62 | 3x3 | 5999765 | 2100345 | 37.7471331091489 | -122.443562976791 | (37.7471331091489, -122.443562976791) | 2 | 4 | 5 | 63 | 22 | |||
| 179270 | 21407 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2692X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
| 179234 | 178200 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 122 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6006610.83252 | 2086895.84997 | 37.7105927285486 | -122.418936859664 | (37.7105927285486, -122.418936859664) | 9 | 7 | 8 | 309 | 39 | |||
| 179112 | 178239 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 226 Hahn St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | Width 10ft | 6007375.6791 | 2087193.39726 | 37.711452769994 | -122.416314435664 | (37.711452769994, -122.416314435664) | 9 | 7 | 8 | 309 | 39 | |||
| 179053 | 187281 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2401 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984957.9073 | 2098294.0261 | 37.7406460934701 | -122.49461277633 | (37.7406460934701, -122.49461277633) | 1 | 8 | 3 | 29491 | 35 | |||
| 179047 | 111421 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 200x SAN MARCOS AVE | 6 | Median : Yard | Tree | Private 2 | 46 | 5993395 | 2100395 | 37.7469050456608 | -122.465593373526 | (37.7469050456608, -122.465593373526) | 1 | 8 | 4 | 29491 | 40 | ||||
| 179006 | 178196 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 147 Blythdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | Width 6ft | 6006332.21017 | 2086970.84294 | 37.710782950434 | -122.41990515969 | (37.710782950434, -122.41990515969) | 9 | 7 | 8 | 309 | 39 | |||
| 178948 | 117208 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 25 MIDCREST WAY | 1 | Front Yard : Cutout | Tree | Private 2 | 20 | 5997992 | 2100464 | 37.7473585772285 | -122.44970241305 | (37.7473585772285, -122.44970241305) | 1 | 5 | 4 | 63 | 38 | ||||
| 178935 | 4988 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5300 Diamond Heights Blvd | 5 | Median : Cutout | Tree | DPW 1 | 36 | 12 | 6001419.5409281 | 2098992.5811716 | 37.7435139095193 | -122.437744874344 | (37.7435139095193, -122.437744874344) | 2 | 7 | 5 | 63 | 7 | |||
| 178680 | 20571 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
| 178618 | 186993 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2501 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 0ft | 5984972.6512 | 2098104.4212 | 37.7401263524114 | -122.494547824222 | (37.7401263524114, -122.494547824222) | 1 | 8 | 3 | 29491 | 35 | |||
| 178584 | 108144 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 140x TOPAZ WAY | 2 | Front Yard : Yard | Tree | Private 2 | 30 | Permit Number 775551 | 6001767 | 2098265 | 37.7415358930081 | -122.436491384585 | (37.7415358930081, -122.436491384585) | 2 | 7 | 5 | 63 | 7 | |||
| 178529 | 20602 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984800.4502923 | 2105635.4093669 | 37.7607942988513 | -122.495698574627 | (37.7607942988513, -122.495698574627) | 1 | 8 | 3 | 56 | 35 | |||
| 178417 | 185459 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 9 | unknown : Yard | Tree | Private 2 | 28 | Width 0ft | 5985114.4327 | 2098335.7647 | 37.7407698565631 | -122.494074654765 | (37.7407698565631, -122.494074654765) | 1 | 8 | 3 | 29491 | 35 | |||
| 178411 | 99449 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601X 15th Ave | 4 | Median : Cutout | Tree | DPW 1 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | 1 | 8 | 4 | 56 | 12 | |||||
| 178391 | 211139 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 372 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 3ft | 5994206.95246 | 2101338.29958 | 37.749541905936 | -122.462854160898 | (37.749541905936, -122.462854160898) | 1 | 8 | 4 | 29491 | 40 | |||
| 178145 | 184069 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1600 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 0ft | 5984931.4699 | 2103987.4511 | 37.756277135565 | -122.495123918436 | (37.756277135565, -122.495123918436) | 1 | 8 | 3 | 56 | 35 | |||
| 178133 | 108046 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2901X SUNSET BLVD ON RAMP | 3 | Median : Yard | Tree | DPW 1 | 99 | 5985273 | 2095807 | 37.7338358213683 | -122.493340136435 | (37.7338358213683, -122.493340136435) | 1 | 8 | 4 | 64 | 35 | ||||
| 178108 | 247117 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2301 Castro St | 35 | Front Yard : Yard | Tree | Private 2 | 24 | 6002710.25835 | 2098630.25767 | 37.7425923606407 | -122.433256015449 | (37.7425923606407, -122.433256015449) | 2 | 7 | 5 | 63 | 22 | ||||
| 178069 | 104027 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 520X Oak Park Dr | 1 | Back Yard : Yard | Tree | Private 2 | 07/25/2013 12:00:00 AM | Permit Number 770238 | 5995008.5 | 2103700.7 | 37.7560745928775 | -122.460253542676 | (37.7560745928775, -122.460253542676) | 1 | 5 | 4 | 63 | 12 | |||
| 178015 | 120935 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
| 177909 | 211168 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 87 Lippard Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | 6001944.93907 | 2095564.74861 | 37.734131738492 | -122.435682991601 | (37.734131738492, -122.435682991601) | 2 | 7 | 5 | 63 | 7 | ||||
| 177899 | 111535 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x BOSWORTH ST | 13 | Front Yard : Yard | Tree | DPW 1 | 18 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 177881 | 211105 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2187x 09th Ave | 10 | Median : Yard | Tree | DPW 1 | 41 | 5993636.38972 | 2101004.93506 | 37.7485936922599 | -122.464802962985 | (37.7485936922599, -122.464802962985) | 1 | 8 | 4 | 29491 | 40 | ||||
| 177814 | 173756 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X Emil Ln | 2 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5996276 | 2095955 | 37.7348796446223 | -122.455310374086 | (37.7348796446223, -122.455310374086) | 9 | 7 | 4 | 59 | 40 | ||||
| 177799 | 103504 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 148 Huntington Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5984515 | 2095210 | 37.7321522522788 | -122.49591670505 | (37.7321522522788, -122.49591670505) | 1 | 8 | 4 | 64 | 35 | |||||
| 177787 | 114122 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 177760 | 246439 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 485 Duncan St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 6003350.12783 | 2099774.41379 | 37.7457702266151 | -122.431125181601 | (37.7457702266151, -122.431125181601) | 2 | 7 | 5 | 63 | 22 | ||||
| 177739 | 201558 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 200 Jerrold Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 6019824.62434 | 2093697.32313 | 37.7300035121512 | -122.373737272669 | (37.7300035121512, -122.373737272669) | 10 | 3 | 8 | 58 | 1 | |||
| 177711 | 258051 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 764 Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5991289 | 2092496 | 37.725094699561 | -122.472299937282 | (37.725094699561, -122.472299937282) | 9 | 8 | 4 | 64 | 40 |
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) );