Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 120332 | 120332 | 103422 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1365 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769779 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.46532315146601 | (37.7394617231066, -122.465323151466) | ||||
| 121423 | 121423 | 96856 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 324X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 410x30 | 6008894.018569999 | 2095530.1163 | 37.73442890905461 | -122.4116553033 | (37.7344289090546, -122.4116553033) | |||
| 122547 | 122547 | 176099 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 491 La Grande Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 43 | 6004400.9540099995 | 2089156.27858 | 37.716674693347 | -122.42673555649999 | (37.716674693347, -122.4267355565) | ||||
| 122672 | 122672 | 102060 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 115 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994908.3 | 2098325.8 | 37.741310707397396 | -122.460210667073 | (37.7413107073974, -122.460210667073) | |||||
| 123208 | 123208 | 21500 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985062.8642150005 | 2096221.8871717 | 37.7349626975104 | -122.494097196305 | (37.7349626975104, -122.494097196305) | |||
| 123752 | 123752 | 95982 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Vasquez Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5995122.4 | 2099706.3 | 37.7451135296363 | -122.459570350972 | (37.7451135296363, -122.459570350972) | |||||
| 124625 | 124625 | 111763 | Landmark tree 9 | Cupressus macrocarpa :: Monterey Cypress 47 | 2626 Vallejo St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001000.6 | 2117623.4 | 37.7946456667745 | -122.440529445268 | (37.7946456667745, -122.440529445268) | |||||
| 125647 | 125647 | 85060 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 7070 California St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/03/2007 12:00:00 AM | Permit Number 49405 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 125794 | 125794 | 85238 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 200 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2007 12:00:00 AM | Permit Number 49542 | 5994792.0 | 2096029.0 | 37.7349975719357 | -122.460446404237 | (37.7349975719357, -122.460446404237) | |||
| 125813 | 125813 | 103600 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 50X Hermann St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.42595813798201 | (37.7707643495235, -122.425958137982) | |||||
| 125992 | 125992 | 93107 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 15 Mesa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 3x3 | Permit Number 53163 | 5993680.1 | 2100698.2 | 37.747753995799705 | -122.46462954455299 | (37.7477539957997, -122.464629544553) | ||
| 126354 | 126354 | 114055 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 50 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
| 127498 | 127498 | 11191 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 148 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 5995624.0655798 | 2099382.6906533 | 37.7442538125131 | -122.457812277707 | (37.7442538125131, -122.457812277707) | |||
| 128772 | 128772 | 104998 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 286X CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4x18 | 5993881.0 | 2100258.0 | 37.746556897942 | -122.463902900317 | (37.746556897942, -122.463902900317) | |||
| 129301 | 129301 | 20746 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1692X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984807.486919099 | 2103677.7923597 | 37.755419639160706 | -122.495529849669 | (37.7554196391607, -122.495529849669) | |||
| 129499 | 129499 | 138267 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800x GEARY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5998264.7576 | 2113134.0967 | 37.782163062403704 | -122.44967211707899 | (37.7821630624037, -122.449672117079) | |||
| 130304 | 130304 | 185136 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2690 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 0ft | 5982268.7576 | 2096762.1144 | 37.7362821222461 | -122.503797243162 | (37.7362821222461, -122.503797243162) | |||
| 130519 | 130519 | 142132 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400x GEARY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 46 | Width 0ft | 6000134.3689 | 2113338.3342 | 37.7828306302801 | -122.443218797439 | (37.7828306302801, -122.443218797439) | |||
| 131318 | 131318 | 223802 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 177 Moffitt St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002408.06016 | 2097073.2728 | 37.7383000934596 | -122.434189644859 | (37.7383000934596, -122.434189644859) | |||
| 131331 | 131331 | 206802 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 5994234.49251 | 2106025.56842 | 37.762413528276205 | -122.463098978843 | (37.7624135282762, -122.463098978843) | |||
| 131737 | 131737 | 223810 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 62 Digby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | Width 5ft | 6002815.82616 | 2097712.3092099996 | 37.7400778751 | -122.432825430853 | (37.7400778751, -122.432825430853) | |||
| 132204 | 132204 | 223771 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 512 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001811.3932 | 2102760.00378 | 37.7538806312085 | -122.43665956541099 | (37.7538806312085, -122.436659565411) | |||
| 133209 | 133209 | 183349 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1210 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5981200.6659 | 2106791.7999 | 37.763757948803 | -122.508234239743 | (37.763757948803, -122.508234239743) | |||
| 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) | |||
| 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) | |||
| 136128 | 136128 | 218153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Ashton Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5994153.71185 | 2090014.1877400002 | 37.7184456203604 | -122.46221709555 | (37.7184456203604, -122.46221709555) | ||||
| 137097 | 137097 | 181441 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984891.7288 | 2105036.7347 | 37.759155850149 | -122.49533873513501 | (37.759155850149, -122.495338735135) | |||
| 137510 | 137510 | 118414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 641 48th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 5980997.21538 | 2111360.64896 | 37.7762906814163 | -122.509277221064 | (37.7762906814163, -122.509277221064) | ||||
| 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) | |||
| 137917 | 137917 | 223789 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Storrie St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 3ft | 6000719.29532 | 2105252.42792 | 37.7606620968006 | -122.44061504455401 | (37.7606620968006, -122.440615044554) | |||
| 138140 | 138140 | 206890 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651x 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 3ft | 5991488.45245 | 2104026.5026700003 | 37.756766054720295 | -122.47245067984801 | (37.7567660547203, -122.472450679848) | |||
| 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) | ||||
| 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) | ||||
| 139692 | 139692 | 99826 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Cascade Walk | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992183.1 | 2103187.3 | 37.7545020044945 | -122.469987253468 | (37.7545020044945, -122.469987253468) | |||||
| 140312 | 140312 | 115391 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 21X BELMONT AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 48 | 5996611.0 | 2106266.0 | 37.7632103037359 | -122.45489693849501 | (37.7632103037359, -122.454896938495) | ||||
| 140362 | 140362 | 108359 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5290 DIAMOND HEIGHTS BLVD | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 20 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.43873337410601 | (37.7440198953745, -122.438733374106) | |||
| 140584 | 140584 | 117248 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 299x GRAYSTONE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999641.0 | 2104067.0 | 37.7573457417117 | -122.44425918093 | (37.7573457417117, -122.44425918093) | ||||
| 140844 | 140844 | 102706 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1342 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992135.4 | 2106294.8 | 37.7630316255695 | -122.470378504645 | (37.7630316255695, -122.470378504645) | |||||
| 141156 | 141156 | 104399 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2440X 37th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5984875.46821 | 2098521.80546 | 37.7412666886784 | -122.49491460561501 | (37.7412666886784, -122.494914605615) | |||||
| 141192 | 141192 | 108958 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 22ND AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5989329.4 | 2105769.6 | 37.7614269305246 | -122.48004495307501 | (37.7614269305246, -122.480044953075) | ||||
| 141372 | 141372 | 104398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 3525X Ulloa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 5985120.1668300005 | 2098189.34613 | 37.7403681660846 | -122.494044040088 | (37.7403681660846, -122.494044040088) | ||||
| 141985 | 141985 | 111287 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 450 ROLPH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002226.0 | 2087613.0 | 37.7123139824471 | -122.434143019741 | (37.7123139824471, -122.434143019741) | |||
| 142008 | 142008 | 20523 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
| 142323 | 142323 | 111587 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | ||||
| 142353 | 142353 | 21337 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2592X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 142440 | 142440 | 95072 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 19 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 54021 | 6003434.0 | 2097382.0 | 37.7392059633181 | -122.430664475135 | (37.7392059633181, -122.430664475135) | |||
| 142441 | 142441 | 99120 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 142607 | 142607 | 11185 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 5995900.4612004 | 2099322.604417 | 37.744104705607704 | -122.45685222203001 | (37.7441047056077, -122.45685222203) | |||
| 142681 | 142681 | 20990 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2003X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.49483235574101 | (37.7496436917689, -122.494832355741) | |||
| 143237 | 143237 | 104888 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 146 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 144598 | 144598 | 99662 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1337 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993559.3 | 2097744.3 | 37.7396363671104 | -122.46483277796801 | (37.7396363671104, -122.464832777968) | |||||
| 144625 | 144625 | 13284 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2576 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6000068.810330001 | 2119230.46658 | 37.799005143246 | -122.443869066799 | (37.799005143246, -122.443869066799) | ||
| 144772 | 144772 | 40713 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Crown Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41692 | 5998528.84920016 | 2104703.4154957 | 37.7590296670037 | -122.448151244492 | (37.7590296670037, -122.448151244492) | ||||
| 144877 | 144877 | 120110 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 90X Knollview Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 3x25 | 5997618.0 | 2101448.0 | 37.750038994650396 | -122.45106661992399 | (37.7500389946504, -122.451066619924) | |||
| 145393 | 145393 | 98880 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Lansdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 5994747.9 | 2097283.1 | 37.738438484278895 | -122.460689725403 | (37.7384384842789, -122.460689725403) | ||||
| 145554 | 145554 | 121180 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000x Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | ||||
| 145791 | 145791 | 20851 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1892X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
| 147594 | 147594 | 206851 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3800 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 6ft | 5990535.05203 | 2090576.85379 | 37.7197815380709 | -122.47476621738899 | (37.7197815380709, -122.474766217389) | |||
| 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) | ||||
| 150704 | 150704 | 126418 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2237 Hyde St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6007090.48557 | 2119992.12642 | 37.8014944842289 | -122.41962574124099 | (37.8014944842289, -122.419625741241) | ||||
| 151962 | 151962 | 223796 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 208 States St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6000981.15252 | 2106412.23532 | 37.763861550997895 | -122.43979255609501 | (37.7638615509979, -122.439792556095) | |||
| 152144 | 152144 | 223808 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 6 Miguel St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6003326.01138 | 2097344.7820099997 | 37.739097652747205 | -122.431035195413 | (37.7390976527472, -122.431035195413) | ||||
| 152523 | 152523 | 223698 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 151 | 6004903.42732 | 2096771.39372 | 37.7376125150086 | -122.42554040785801 | (37.7376125150086, -122.425540407858) | ||||
| 153155 | 153155 | 205898 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 142 Bella Vista Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5998216.302630001 | 2097080.2321099997 | 37.738080399879706 | -122.448683118058 | (37.7380803998797, -122.448683118058) | |||
| 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) | |||
| 155412 | 155412 | 223726 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 107 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 32 | Width 7ft | 6007259.15325 | 2098682.1985299997 | 37.742991985195104 | -122.41753090725 | (37.7429919851951, -122.41753090725) | |||
| 156086 | 156086 | 206846 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Brotherhood Way | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 0ft | 5993694.0595 | 2087568.4676400002 | 37.7117037797802 | -122.463628505047 | (37.7117037797802, -122.463628505047) | |||
| 157058 | 157058 | 185451 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 30 | Width 0ft | 5985130.3697 | 2098228.1903 | 37.740475418723506 | -122.49401162519399 | (37.7404754187235, -122.494011625194) | |||
| 157404 | 157404 | 126412 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Jefferson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6000088.69563 | 2121303.7240299997 | 37.804698887418105 | -122.443949299933 | (37.8046988874181, -122.443949299933) | |||
| 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) | ||||
| 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) | ||||
| 159880 | 159880 | 223800 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 50 Hiliritas Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 2ft | 6001424.08839 | 2096900.34292 | 37.7377693720626 | -122.437579347922 | (37.7377693720626, -122.437579347922) | |||
| 160056 | 160056 | 205906 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 20 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 5ft | 6001210.67203 | 2095218.5824 | 37.7331395119639 | -122.438196788261 | (37.7331395119639, -122.438196788261) | |||
| 160062 | 160062 | 176162 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 301 Naglee Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | Width 10ft | 5997669.17463 | 2088536.7397200002 | 37.7145906808916 | -122.449959233558 | (37.7145906808916, -122.449959233558) | |||
| 160898 | 160898 | 186852 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2700 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 0ft | 5985203.396000001 | 2096268.9816 | 37.7351002284248 | -122.493614804408 | (37.7351002284248, -122.493614804408) | |||
| 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) | ||||
| 161313 | 161313 | 122257 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5991472.5237300005 | 2113448.5530000003 | 37.78263554306471 | -122.473192897736 | (37.7826355430647, -122.473192897736) | |||
| 162360 | 162360 | 186263 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1800 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5984973.2141 | 2102324.4773 | 37.7517135119609 | -122.494856946907 | (37.7517135119609, -122.494856946907) | |||
| 164158 | 164158 | 185152 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2500 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5985154.6071 | 2097578.7599 | 37.7386936753561 | -122.49387997533199 | (37.7386936753561, -122.493879975332) | |||
| 164549 | 164549 | 206889 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1646x 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 3ft | 5991480.90681 | 2104023.08965 | 37.7567562467267 | -122.472476526376 | (37.7567562467267, -122.472476526376) | |||
| 165216 | 165216 | 205921 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 335 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | 5997888.47996 | 2095505.4814799998 | 37.7337377607861 | -122.449703111117 | (37.7337377607861, -122.449703111117) | ||||
| 165726 | 165726 | 205902 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Kensington Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5994974.56869 | 2098324.33345 | 37.741310492185605 | -122.45998142862699 | (37.7413104921856, -122.459981428627) | |||
| 166243 | 166243 | 206803 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 300 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5993087.14993 | 2102582.23712 | 37.752892877008705 | -122.466816856226 | (37.7528928770087, -122.466816856226) | ||||
| 166544 | 166544 | 176163 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 654 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6005125.75661 | 2092550.7271200002 | 37.726036063007705 | -122.42447158070601 | (37.7260360630077, -122.424471580706) | ||||
| 166986 | 166986 | 223780 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4071 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | Width 3ft | 6003254.362819999 | 2104156.16383 | 37.757796051860296 | -122.431769121362 | (37.7577960518603, -122.431769121362) | |||
| 167901 | 167901 | 185517 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 56 | Width 0ft | 5984884.6253 | 2100174.2165 | 37.745804297711395 | -122.495004757586 | (37.7458042977114, -122.495004757586) | |||
| 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) | |||
| 168306 | 168306 | 206810 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 66x Santa Monica Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993662.74276 | 2097416.4076799997 | 37.7387420203269 | -122.464451319071 | (37.7387420203269, -122.464451319071) | ||||
| 170501 | 170501 | 205908 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6000855.4988 | 2095527.0411599998 | 37.733966261424 | -122.43944681802799 | (37.733966261424, -122.439446818028) | ||||
| 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) | |||
| 171054 | 171054 | 206834 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Casitas Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 5ft | 5995064.96816 | 2095832.8748700002 | 37.7344747596986 | -122.45948846344 | (37.7344747596986, -122.45948846344) | |||
| 171399 | 171399 | 184735 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984680.1977 | 2106291.6891 | 37.7625892162308 | -122.496162889393 | (37.7625892162308, -122.496162889393) | |||
| 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) | |||
| 172551 | 172551 | 176108 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 6005255.13814 | 2086372.0334299998 | 37.7090780076251 | -122.4235852251 | (37.7090780076251, -122.4235852251) | ||||
| 173594 | 173594 | 118511 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 8131 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 5981763.277969999 | 2112328.08269 | 37.7789921064061 | -122.506699014872 | (37.7789921064061, -122.506699014872) | |||
| 174021 | 174021 | 206805 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 68 Aerial Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 2ft | 5992337.85259 | 2102586.3377799997 | 37.752860862941205 | -122.469408341716 | (37.7528608629412, -122.469408341716) | |||
| 174101 | 174101 | 176141 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 1 | : 4 | Tree 1 | Private 1 | 48 | Width 0ft | 5987562.65817 | 2089512.7313599999 | 37.7166870365437 | -122.484962576069 | (37.7166870365437, -122.484962576069) | |||
| 174433 | 174433 | 223744 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 591 27th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6002700.253169999 | 2100030.0951900003 | 37.746435420069396 | -122.433390619685 | (37.7464354200694, -122.433390619685) | |||
| 175414 | 175414 | 223770 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 340 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007775.55004 | 2105926.88107 | 37.7629132824304 | -122.416258345863 | (37.7629132824304, -122.416258345863) | |||
| 175698 | 175698 | 205893 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1110 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 5998235.76076 | 2095666.83858 | 37.734200671531504 | -122.448514080556 | (37.7342006715315, -122.448514080556) |
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");