Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 130707 | 130707 | 190965 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 24th St | 17 | : Yard 23 | Tree 1 | Private 1 | 6 | 6017293.94065 | 2102634.4333599997 | 37.754403540203796 | -122.38310803210899 | (37.7544035402038, -122.383108032109) | ||||
| 32031 | 32031 | 190995 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 10x Cashmere St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6017237.22965 | 2095860.87095 | 37.7358015834667 | -122.38283280631599 | (37.7358015834667, -122.382832806316) | ||||
| 167728 | 167728 | 201724 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | 6017165.24184 | 2095383.9343 | 37.7344880327856 | -122.383048514986 | (37.7344880327856, -122.383048514986) | ||||
| 65706 | 65706 | 201723 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6017160.60225 | 2095378.34378 | 37.734472425960895 | -122.383064166774 | (37.7344724259609, -122.383064166774) | ||||
| 55847 | 55847 | 201720 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6017109.38533 | 2095355.2358400002 | 37.734406145933704 | -122.383239634411 | (37.7344061459337, -122.383239634411) | ||||
| 146514 | 146514 | 201719 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6017095.79964 | 2095357.4210400002 | 37.7344113952763 | -122.38328675710501 | (37.7344113952763, -122.383286757105) | ||||
| 58146 | 58146 | 201718 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6017093.28201 | 2095356.3247099998 | 37.7344082458391 | -122.38329538517401 | (37.7344082458391, -122.383295385174) | ||||
| 44565 | 44565 | 201717 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6017089.1408 | 2095350.86435 | 37.7343930239173 | -122.38330932287201 | (37.7343930239173, -122.383309322872) | ||||
| 51235 | 51235 | 201716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6017085.9132900005 | 2095352.6498 | 37.7343977480421 | -122.38332060578001 | (37.7343977480421, -122.38332060578) | ||||
| 138560 | 138560 | 109251 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 53X DEDMAN CT | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 6016647.0 | 2096311.0 | 37.7370049195852 | -122.384904830601 | (37.7370049195852, -122.384904830601) | ||||
| 159868 | 159868 | 190994 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 50x Dedman Ct | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | 6016552.89235 | 2096279.67285 | 37.736913695911 | -122.385228023775 | (37.736913695911, -122.385228023775) | ||||
| 155152 | 155152 | 190988 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 119 Lindsay Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 5ft | 6016552.3921 | 2095641.6616099998 | 37.7351618174613 | -122.385185311358 | (37.7351618174613, -122.385185311358) | |||
| 150471 | 150471 | 201721 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Lindsay Cir | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6016317.40109 | 2095614.0815400002 | 37.7350730858367 | -122.385995846031 | (37.7350730858367, -122.385995846031) | ||||
| 58189 | 58189 | 190989 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6016178.9228300005 | 2096206.88071 | 37.7366931281786 | -122.386515940161 | (37.7366931281786, -122.386515940161) | ||||
| 40086 | 40086 | 190990 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6016177.273030001 | 2096204.98812 | 37.7366878401785 | -122.38652151236201 | (37.7366878401785, -122.386521512362) | ||||
| 24654 | 24654 | 190986 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6016149.69105 | 2100259.24355 | 37.747818469462 | -122.38689953970601 | (37.747818469462, -122.386899539706) | ||||
| 65345 | 65345 | 190991 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016140.771930001 | 2096185.18124 | 37.7366314337791 | -122.38664633287901 | (37.7366314337791, -122.386646332879) | ||||
| 161065 | 161065 | 190992 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016132.65203 | 2096182.1348700002 | 37.7366226195253 | -122.38667419475901 | (37.7366226195253, -122.386674194759) | ||||
| 157706 | 157706 | 190985 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6016130.05616 | 2100249.9564799997 | 37.747791881903 | -122.386966789196 | (37.747791881903, -122.386966789196) | ||||
| 158990 | 158990 | 190984 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6016127.79585 | 2100261.1881 | 37.747822596447705 | -122.38697538852502 | (37.7478225964477, -122.386975388525) | ||||
| 135721 | 135721 | 190993 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6016127.05832 | 2096176.4700900002 | 37.7366067554984 | -122.386693139892 | (37.7366067554984, -122.386693139892) | ||||
| 24493 | 24493 | 190983 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6016115.94828 | 2100251.3725900003 | 37.7477949890666 | -122.387015672733 | (37.7477949890666, -122.387015672733) | ||||
| 159881 | 159881 | 190980 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6016106.6833 | 2100234.37898 | 37.747747815104205 | -122.387046525793 | (37.7477478151042, -122.387046525793) | ||||
| 131402 | 131402 | 190979 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6016095.64833 | 2100226.2738200002 | 37.747724948962606 | -122.387084119257 | (37.7477249489626, -122.387084119257) | ||||
| 167641 | 167641 | 190982 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6016087.28584 | 2100258.68622 | 37.7478134836207 | -122.387115296958 | (37.7478134836207, -122.387115296958) | ||||
| 76851 | 76851 | 190981 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6016079.678669999 | 2100249.91321 | 37.7477889734994 | -122.38714099058998 | (37.7477889734994, -122.38714099059) | ||||
| 105313 | 105313 | 110264 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 220x CASHMERE ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5x40 | 6015982.5 | 2095938.0 | 37.735943960522796 | -122.38717631599701 | (37.7359439605228, -122.387176315997) | ||||
| 115560 | 115560 | 109453 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 951 GILMAN AVE | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||
| 16807 | 16807 | 106757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 36 | 6013321.202330001 | 2089752.82506 | 37.718812992515105 | -122.395944254446 | (37.7188129925151, -122.395944254446) | |||
| 161302 | 161302 | 190966 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1912 23rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | 6012683.0695 | 2102873.5527 | 37.7548042439346 | -122.39907049840099 | (37.7548042439346, -122.399070498401) | ||||
| 185031 | 185031 | 190987 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Topeka Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6012468.98817 | 2095242.94143 | 37.7338402790006 | -122.39927522817 | (37.7338402790006, -122.39927522817) | |||
| 42268 | 42268 | 53726 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1972 12:00:00 AM | 8 | Permit Number 9405 | 6012451.87174 | 2095251.14558 | 37.733861851932296 | -122.399334980939 | (37.7338618519323, -122.399334980939) | ||
| 134629 | 134629 | 45072 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 580 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Permit Number 770844 | 6012040.04022 | 2105787.48822 | 37.7627694124935 | -122.401499066356 | (37.7627694124935, -122.401499066356) | |||
| 44996 | 44996 | 190978 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1429 Rhode Island St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 6012034.10728 | 2101710.80673 | 37.7515754115935 | -122.40123309992201 | (37.7515754115935, -122.401233099922) | ||||
| 139657 | 139657 | 117644 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1111X SANSOME ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x30 | 6011937.0 | 2119613.0 | 37.8007253016149 | -122.402827843034 | (37.8007253016149, -122.402827843034) | ||||
| 186554 | 186554 | 250195 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011875.28376 | 2119779.56963 | 37.8011792152183 | -122.40305313080401 | (37.8011792152183, -122.403053130804) | |||
| 156317 | 156317 | 250196 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011857.70339 | 2119785.90004 | 37.801195615236395 | -122.403114412425 | (37.8011956152364, -122.403114412425) | |||
| 168070 | 168070 | 250204 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 206 Union St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 6011843.5346800005 | 2119802.5611900003 | 37.8012405714539 | -122.403164615272 | (37.8012405714539, -122.403164615272) | |||
| 60552 | 60552 | 250197 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011839.72623 | 2119769.92251 | 37.8011507408769 | -122.403175497057 | (37.8011507408769, -122.403175497057) | |||
| 46469 | 46469 | 250199 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 0ft | 6011821.07725 | 2119768.34547 | 37.8011453692141 | -122.403239919993 | (37.8011453692141, -122.403239919993) | |||
| 46935 | 46935 | 250205 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 212 Union St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6011817.68969 | 2119792.01106 | 37.8012101599872 | -122.4032533082 | (37.8012101599872, -122.4032533082) | |||
| 60877 | 60877 | 250194 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18 Alta St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 0ft | 6011773.11718 | 2119954.14642 | 37.8016528548612 | -122.403418962409 | (37.8016528548612, -122.403418962409) | |||
| 46521 | 46521 | 249857 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 241 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 0ft | 6011495.8307 | 2120401.68392 | 37.8028661922948 | -122.404410025227 | (37.8028661922948, -122.404410025227) | |||
| 39759 | 39759 | 126424 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1306x Montgomery St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6011439.456040001 | 2120033.94187 | 37.801853311934096 | -122.404579209268 | (37.8018533119341, -122.404579209268) | |||
| 25946 | 25946 | 126425 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1306x Montgomery St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 6011438.821769999 | 2120037.4711599997 | 37.8018629670555 | -122.40458165273701 | (37.8018629670555, -122.404581652737) | |||
| 38454 | 38454 | 249866 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1497 Montgomery St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011357.005059999 | 2120690.5710400003 | 37.8036516466761 | -122.404910787509 | (37.8036516466761, -122.404910787509) | |||
| 171449 | 171449 | 249865 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1497 Montgomery St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 0ft | 6011350.601919999 | 2120707.91777 | 37.8036989186248 | -122.404934168095 | (37.8036989186248, -122.404934168095) | |||
| 25637 | 25637 | 190976 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6011280.21235 | 2104227.17617 | 37.758442718371704 | -122.404017246303 | (37.7584427183717, -122.404017246303) | ||||
| 152251 | 152251 | 190977 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 26 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 50 | 6011279.98561 | 2104216.03333 | 37.7584121099421 | -122.40401724631799 | (37.7584121099421, -122.404017246318) | ||||
| 173530 | 173530 | 190974 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6011278.73233 | 2104250.4136900003 | 37.7585064407439 | -122.404024000205 | (37.7585064407439, -122.404024000205) | ||||
| 126894 | 126894 | 190968 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6011276.3148 | 2104337.18505 | 37.7587445605265 | -122.40403846760799 | (37.7587445605265, -122.404038467608) | ||||
| 39647 | 39647 | 190975 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 6011275.59974 | 2104245.89235 | 37.758493851126296 | -122.40403451598 | (37.7584938511263, -122.40403451598) | ||||
| 175510 | 175510 | 190973 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | 6011275.27355 | 2104274.28266 | 37.7585717863791 | -122.404037642038 | (37.7585717863791, -122.404037642038) | ||||
| 57404 | 57404 | 190967 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | 6011275.2709 | 2104408.12846 | 37.7589392970181 | -122.404047070529 | (37.7589392970181, -122.404047070529) | ||||
| 32368 | 32368 | 190972 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6011274.67248 | 2104298.88872 | 37.758639315564 | -122.404041452454 | (37.758639315564, -122.404041452454) | ||||
| 152747 | 152747 | 190970 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 6011272.79136 | 2104320.91829 | 37.758699698760296 | -122.40404950858 | (37.7586996987603, -122.40404950858) | ||||
| 23514 | 23514 | 190971 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | 6011272.24417 | 2104307.20268 | 37.7586620081736 | -122.40405043579099 | (37.7586620081736, -122.404050435791) | ||||
| 35184 | 35184 | 190969 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6011271.58164 | 2104330.23228 | 37.758725205314704 | -122.404054347838 | (37.7587252053147, -122.404054347838) | ||||
| 181873 | 181873 | 250227 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 312 Filbert St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011220.88869 | 2120048.61475 | 37.8018813824768 | -122.40533659221902 | (37.8018813824768, -122.405336592219) | |||
| 46680 | 46680 | 249916 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011201.85513 | 2120410.11068 | 37.8028728976405 | -122.40542793096901 | (37.8028728976405, -122.405427930969) | |||
| 67041 | 67041 | 249828 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 339 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | Width 0ft | 6011201.53996 | 2120373.03951 | 37.802771091668205 | -122.405426409314 | (37.8027710916682, -122.405426409314) | |||
| 132547 | 132547 | 249917 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6011197.83082 | 2120409.77535 | 37.802871751897 | -122.405441833595 | (37.802871751897, -122.405441833595) | |||
| 51446 | 51446 | 249918 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011195.29362 | 2120394.33345 | 37.8028292103611 | -122.405449525493 | (37.8028292103611, -122.405449525493) | |||
| 188593 | 188593 | 249830 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 339 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 0ft | 6011191.13425 | 2120368.12029 | 37.8027570028825 | -122.405462071912 | (37.8027570028825, -122.405462071912) | |||
| 74458 | 74458 | 249919 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011190.2403 | 2120395.87946 | 37.8028331727783 | -122.405467121607 | (37.8028331727783, -122.405467121607) | |||
| 76467 | 76467 | 249921 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6011183.71747 | 2120405.40754 | 37.8028589698347 | -122.40549036550101 | (37.8028589698347, -122.405490365501) | |||
| 170870 | 170870 | 249922 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011172.25119 | 2120397.10621 | 37.802835535282604 | -122.405529459923 | (37.8028355352826, -122.405529459923) | |||
| 179841 | 179841 | 249924 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 0ft | 6011171.36702 | 2120411.09017 | 37.802873882370896 | -122.405533505089 | (37.8028738823709, -122.405533505089) | |||
| 156630 | 156630 | 249923 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 33 | Width 0ft | 6011163.06331 | 2120405.05222 | 37.8028568393309 | -122.40556181483801 | (37.8028568393309, -122.405561814838) | |||
| 176394 | 176394 | 249925 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011155.36985 | 2120409.86411 | 37.802869621408796 | -122.40558877741002 | (37.8028696214088, -122.40558877741) | |||
| 176393 | 176393 | 249926 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011142.49576 | 2120408.96257 | 37.8028664261111 | -122.405633265077 | (37.8028664261111, -122.405633265077) | |||
| 24155 | 24155 | 249927 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011132.35015 | 2120388.99651 | 37.8028110368738 | -122.40566696715099 | (37.8028110368738, -122.405666967151) | |||
| 182295 | 182295 | 249826 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 391 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | Width 0ft | 6011015.83097 | 2120024.81975 | 37.8018045803872 | -122.406044514263 | (37.8018045803872, -122.406044514263) | |||
| 140619 | 140619 | 95331 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 390X Filbert St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
| 130214 | 130214 | 249786 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 161 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6010943.97363 | 2121044.47732 | 37.8046002902368 | -122.406365062323 | (37.8046002902368, -122.406365062323) | |||
| 135517 | 135517 | 249787 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 173 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | Width 0ft | 6010924.52484 | 2121034.4207099997 | 37.8045715892836 | -122.40643165799 | (37.8045715892836, -122.40643165799) | |||
| 158925 | 158925 | 248059 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 41 | 6010698.28988 | 2099365.5413599997 | 37.7450612101031 | -122.40568737459299 | (37.7450612101031, -122.405687374593) | ||||
| 148628 | 148628 | 248051 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6010607.1512400005 | 2099382.29757 | 37.745102122072396 | -122.406003697633 | (37.7451021220724, -122.406003697633) | ||||
| 99355 | 99355 | 106961 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 325 DWIGHT ST | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6010604.0 | 2091349.0 | 37.7230442144558 | -122.405448941518 | (37.7230442144558, -122.405448941518) | ||||||
| 63703 | 63703 | 126423 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 The Embarcadero | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | 6010525.17738 | 2122242.65614 | 37.8078667556044 | -122.40789889741899 | (37.8078667556044, -122.407898897419) | ||||
| 137849 | 137849 | 223767 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 MacEdonia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010370.7257 | 2099718.90612 | 37.746013149704204 | -122.406844938766 | (37.7460131497042, -122.406844938766) | |||
| 40580 | 40580 | 223723 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2900 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010018.43827 | 2101654.33057 | 37.751307680712294 | -122.40819958573499 | (37.7513076807123, -122.408199585735) | |||
| 127372 | 127372 | 112739 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 444 Franconia St | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 30 | 6009949.70212209 | 2098546.33795552 | 37.7427699663381 | -122.40821810325701 | (37.7427699663381, -122.408218103257) | ||||
| 135623 | 135623 | 247911 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 399 Franconia St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 39 | 6009944.29918 | 2098783.53182 | 37.7434209465163 | -122.408253510886 | (37.7434209465163, -122.408253510886) | ||||
| 34768 | 34768 | 247991 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 10ft | 6009914.62518 | 2099827.74346 | 37.7462864617583 | -122.408429756449 | (37.7462864617583, -122.408429756449) | |||
| 65231 | 65231 | 247990 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 10ft | 6009904.82703 | 2099823.3195700003 | 37.7462737660155 | -122.40846332542499 | (37.7462737660155, -122.408463325425) | |||
| 25672 | 25672 | 247989 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 10ft | 6009899.29934 | 2099821.3308900003 | 37.7462679959733 | -122.40848229933901 | (37.7462679959733, -122.408482299339) | |||
| 148452 | 148452 | 247988 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 124 Mullen Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 29 | Width 10ft | 6009878.9446 | 2099816.70211 | 37.746254146420796 | -122.40855235741199 | (37.7462541464208, -122.408552357412) | |||
| 122936 | 122936 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000 ESMERALDA AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009839.0 | 2098688.0 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | ||||||
| 112486 | 112486 | 117064 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 257 PERALTA AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6009832.0 | 2099662.0 | 37.745826739133 | -122.408703774946 | (37.745826739133, -122.408703774946) | ||||
| 34240 | 34240 | 247903 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 582 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6009830.823 | 2098729.7061900003 | 37.743266798225605 | -122.40864208815701 | (37.7432667982256, -122.408642088157) | ||||
| 170557 | 170557 | 223763 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 126 Bradford St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6009530.79254 | 2097866.09723 | 37.740878707894296 | -122.409618578334 | (37.7408787078943, -122.409618578334) | |||
| 174648 | 174648 | 223764 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 126 Bradford St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6009530.67949 | 2097860.55808 | 37.7408634922583 | -122.40961857835899 | (37.7408634922583, -122.409618578359) | |||
| 51584 | 51584 | 223765 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 126 Bradford St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6009530.59471 | 2097856.4038 | 37.7408520807582 | -122.409618578357 | (37.7408520807582, -122.409618578357) | |||
| 176077 | 176077 | 176104 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6009423.2681599995 | 2090026.7428 | 37.7193474820922 | -122.409437239052 | (37.7193474820922, -122.409437239052) | |||
| 82925 | 82925 | 112725 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 40x BERNAL HEIGHTS BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6009324.0 | 2098099.0 | 37.7415066181332 | -122.41035003366801 | (37.7415066181332, -122.410350033668) | |||
| 125828 | 125828 | 112726 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 40x BERNAL HEIGHTS BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6009324.0 | 2098099.0 | 37.7415066181332 | -122.41035003366801 | (37.7415066181332, -122.410350033668) | |||
| 148568 | 148568 | 176105 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 105 | Width 0ft | 6009225.48687 | 2089982.90412 | 37.7192160263732 | -122.41011780460899 | (37.7192160263732, -122.410117804609) | |||
| 66895 | 66895 | 176112 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Tomaso Ct | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009187.4096 | 2086275.4475900002 | 37.7090339795175 | -122.409987838189 | (37.7090339795175, -122.409987838189) | |||
| 183568 | 183568 | 176102 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 62 Tomaso Ct | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 8ft | 6009173.04361 | 2086270.9274900001 | 37.709020763061396 | -122.41003717048099 | (37.7090207630614, -122.410037170481) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");