Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, qCareAssistant, PermitNotes
qSiteInfo ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145874 | 145874 | 100769 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3701 21st St | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | Street tree w/in RoW | 6003717.0 | 2103606.0 | 37.7563116466144 | -122.43012988292 | (37.7563116466144, -122.43012988292) | ||||
| 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) | ||
| 272 | 272 | 251264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 277 | 277 | 251265 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 293 | 293 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 300 | 300 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 10549 | 10549 | 2290 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989540.89128 | 2088682.16282 | 37.714521528411495 | -122.478064194121 | (37.7145215284115, -122.478064194121) | |
| 11963 | 11963 | 2289 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989454.26944 | 2088678.0808599999 | 37.7145052920719 | -122.478363292437 | (37.7145052920719, -122.478363292437) | |
| 12203 | 12203 | 2287 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989126.18342 | 2088688.6181299998 | 37.7145151729252 | -122.47949804711 | (37.7145151729252, -122.47949804711) | |
| 50101 | 50101 | 121189 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000x Duncan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 7193 | 7193 | 110906 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 2891 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775210 | 5999784.0596900005 | 2117390.4095799997 | 37.7939365889551 | -122.44472206489799 | (37.7939365889551, -122.444722064898) | |
| 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) | ||
| 89354 | 89354 | 111589 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | Permit Number 774260 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
| 82039 | 82039 | 116084 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 127 Edgehill Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | Permit Number 773426 | 5994851.1 | 2098962.7 | 37.7430561859317 | -122.46045458158301 | (37.7430561859317, -122.460454581583) | |||
| 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) | |||
| 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) | ||||
| 127792 | 127792 | 99864 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 681 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768887 | 5981306.2 | 2111092.9 | 37.775573734396204 | -122.508188499048 | (37.7755737343962, -122.508188499048) | ||||
| 98538 | 98538 | 98820 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 28 | Median : Cutout 11 | Tree 1 | Private 1 | 05/09/2010 12:00:00 AM | Permit Number 768820 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | |||
| 119522 | 119522 | 99047 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 240@Casitas Lansdale Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 42 | Permit Number 768724 | 5994955.6 | 2096712.9 | 37.736884803366706 | -122.459930310697 | (37.7368848033667, -122.459930310697) | |||
| 121692 | 121692 | 98378 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 199X Cragmont Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 768647 | 5992899.0 | 2101153.0 | 37.7489576989052 | -122.467363590244 | (37.7489576989052, -122.467363590244) | ||||
| 110409 | 110409 | 98703 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 7070@ 32nd Ave California St | 4 | Front Yard : 25 | Tree 1 | Private 1 | 03/10/2012 12:00:00 AM | Permit Number 767466 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 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) | |||
| 75294 | 75294 | 93205 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 103620 | 103620 | 93204 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 118374 | 118374 | 93206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 139394 | 139394 | 93203 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 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) | ||
| 108304 | 108304 | 41202 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 79 Midcrest Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 53043 | 5998096.00481154 | 2100748.3020607 | 37.748145150880795 | -122.44936325399401 | (37.7481451508808, -122.449363253994) | ||||
| 19685 | 19685 | 92559 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
| 80495 | 80495 | 92565 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Stanyan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
| 83819 | 83819 | 92562 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
| 104492 | 104492 | 92563 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Stanyan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
| 118999 | 118999 | 92564 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Stanyan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
| 126878 | 126878 | 92561 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
| 145203 | 145203 | 92560 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
| 92632 | 92632 | 91152 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 166 Kensington Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52026 | 5994670.3 | 2098755.2 | 37.742476040106396 | -122.46106469780199 | (37.7424760401064, -122.461064697802) | |||
| 110058 | 110058 | 91138 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 166 Kensington Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | Permit Number 52026 | 5994670.3 | 2098755.2 | 37.742476040106396 | -122.46106469780199 | (37.7424760401064, -122.461064697802) | |||
| 110349 | 110349 | 91139 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 166 Kensington Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | Permit Number 52026 | 5994670.3 | 2098755.2 | 37.742476040106396 | -122.46106469780199 | (37.7424760401064, -122.461064697802) | |||
| 104759 | 104759 | 87819 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 390 Lansdale Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 50681 | 5995630.7 | 2096410.1 | 37.736092191921294 | -122.457574304331 | (37.7360921919213, -122.457574304331) | ||||
| 7419 | 7419 | 97731 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1150 Francisco St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | Permit Number 50638 | 6005778.11415 | 2120709.05822 | 37.803388983478605 | -122.42421815984501 | (37.8033889834786, -122.424218159845) | |
| 125657 | 125657 | 87116 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 470 West Portal Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 83377 | 83377 | 87064 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2007 12:00:00 AM | Permit Number 50006 | 6001805.0 | 2096722.0 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | |||
| 92932 | 92932 | 86903 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 233 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2007 12:00:00 AM | 3x3 | Permit Number 49863 | 6001780.0 | 2086418.0 | 37.7090074518569 | -122.435599089406 | (37.7090074518569, -122.435599089406) | ||
| 78630 | 78630 | 85239 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 200 Yerba Buena Ave | 2 | 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 129 | 129 | 20398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 362 | 362 | 187139 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 0ft | 5984937.035 | 2099496.8257 | 37.7439474344515 | -122.494773601416 | (37.7439474344515, -122.494773601416) | |||
| 484 | 484 | 205880 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 44 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 43 | Width 3ft | 5993348.04769 | 2101170.42115 | 37.7490314462559 | -122.46581205990499 | (37.7490314462559, -122.465812059905) | |||
| 503 | 503 | 8533 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001504.6387 | 2113566.4305 | 37.783534963845 | -122.43849459602801 | (37.783534963845, -122.438494596028) | |||
| 549 | 549 | 251321 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | ||||||||||
| 618 | 618 | 20377 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 682 | 682 | 251365 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 712 | 712 | 251366 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 713 | 713 | 251364 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 731 | 731 | 251375 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 747 | 747 | 251378 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 749 | 749 | 251374 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 757 | 757 | 251377 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 763 | 763 | 251373 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 764 | 764 | 251379 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 782 | 782 | 251385 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 784 | 784 | 251384 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 785 | 785 | 251376 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 815 | 815 | 8534 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001381.7916 | 2113512.2830000003 | 37.78337929999999 | -122.43891571692801 | (37.7833793, -122.438915716928) | ||
| 869 | 869 | 124177 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 8X Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10 | Width 9ft | 5995876.0 | 2112606.0 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | |||
| 886 | 886 | 19568 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 100ST | ||||||||
| 961 | 961 | 251408 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 75 Christmas Tree Point Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998776.0 | 2103023.0 | 37.75442978774979 | -122.447175546291 | (37.7544297877498, -122.447175546291) | ||||
| 999 | 999 | 251422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 480x De Long St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992963.0 | 2086633.0 | 37.709093057147996 | -122.466087289133 | (37.709093057148, -122.466087289133) | |||||
| 1029 | 1029 | 251428 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5030 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | ||||
| 1030 | 1030 | 251424 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 5016 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | ||||
| 1098 | 1098 | 251438 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501X Santiago St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 1398 | 1398 | 251517 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 145 Bonview St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6007188.0 | 2098162.0 | 37.7415596321362 | -122.417740072125 | (37.7415596321362, -122.417740072125) | ||||
| 1561 | 1561 | 8580 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1994 12:00:00 AM | 6 | 6 | 6000778.3855 | 2113430.8926 | 37.783121473536795 | -122.44099741813 | (37.7831214735368, -122.44099741813) | ||
| 1600 | 1600 | 251625 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 76R Amber Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999293.0 | 2100015.0 | 37.746200078593205 | -122.44517138727 | (37.7462000785932, -122.44517138727) | |||||
| 1604 | 1604 | 251632 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) | |||||
| 1605 | 1605 | 251634 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) | |||||
| 1608 | 1608 | 251603 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 44R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999509.0 | 2100035.0 | 37.746267320465705 | -122.444425925791 | (37.7462673204657, -122.444425925791) | |||||
| 1609 | 1609 | 251630 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 8R Amethyst Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999237.0 | 2100032.0 | 37.7462435599048 | -122.44536624972099 | (37.7462435599048, -122.445366249721) | |||||
| 1613 | 1613 | 251616 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 64R Amber Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999367.0 | 2100045.0 | 37.746286674920704 | -122.44491766156601 | (37.7462866749207, -122.444917661566) | |||||
| 1618 | 1618 | 251611 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 56R Amber Dr | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999423.0 | 2100048.0 | 37.7462981080439 | -122.44472423658002 | (37.7462981080439, -122.44472423658) | |||||
| 1619 | 1619 | 251617 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 64R Amber Dr | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999367.0 | 2100045.0 | 37.746286674920704 | -122.44491766156601 | (37.7462866749207, -122.444917661566) | |||||
| 1623 | 1623 | 251613 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 60R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999394.0 | 2100048.0 | 37.7462964530913 | -122.444824514752 | (37.7462964530913, -122.444824514752) | |||||
| 1624 | 1624 | 251624 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 76R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999293.0 | 2100015.0 | 37.746200078593205 | -122.44517138727 | (37.7462000785932, -122.44517138727) | |||||
| 1625 | 1625 | 251623 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 76R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999293.0 | 2100015.0 | 37.746200078593205 | -122.44517138727 | (37.7462000785932, -122.44517138727) | |||||
| 1626 | 1626 | 251635 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999176.0 | 2100050.0 | 37.746289501198795 | -122.445578473632 | (37.7462895011988, -122.445578473632) | |||||
| 1628 | 1628 | 251629 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 8R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999237.0 | 2100032.0 | 37.7462435599048 | -122.44536624972099 | (37.7462435599048, -122.445366249721) | |||||
| 1629 | 1629 | 251631 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 8R Amethyst Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999237.0 | 2100032.0 | 37.7462435599048 | -122.44536624972099 | (37.7462435599048, -122.445366249721) | |||||
| 1631 | 1631 | 251621 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | |||||
| 1632 | 1632 | 251628 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 2R Amethyst Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999263.0 | 2100016.0 | 37.746201111936706 | -122.44527519504999 | (37.7462011119367, -122.44527519505) | |||||
| 1633 | 1633 | 251599 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 740 Moraga St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992006.0 | 2103899.0 | 37.756445907456396 | -122.470651540396 | (37.7564459074564, -122.470651540396) | ||||
| 1637 | 1637 | 251619 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | |||||
| 1638 | 1638 | 251620 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | |||||
| 1639 | 1639 | 251615 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 64R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999367.0 | 2100045.0 | 37.746286674920704 | -122.44491766156601 | (37.7462866749207, -122.444917661566) | |||||
| 1640 | 1640 | 251622 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | |||||
| 1641 | 1641 | 251627 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2R Amethyst Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999263.0 | 2100016.0 | 37.746201111936706 | -122.44527519504999 | (37.7462011119367, -122.44527519505) | |||||
| 1643 | 1643 | 251614 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 64R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999367.0 | 2100045.0 | 37.746286674920704 | -122.44491766156601 | (37.7462866749207, -122.444917661566) | |||||
| 1645 | 1645 | 251626 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 2R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999263.0 | 2100016.0 | 37.746201111936706 | -122.44527519504999 | (37.7462011119367, -122.44527519505) | |||||
| 1646 | 1646 | 251633 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) |
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");