Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | |||
| 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) | ||
| 72965 | 72965 | 99863 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 681 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 5981324.99313 | 2111098.19167 | 37.7755893711796 | -122.508123883044 | (37.7755893711796, -122.508123883044) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 549 | 549 | 251321 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | ||||||||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | ||||
| 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) | |||||
| 1652 | 1652 | 251618 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | |||||
| 1736 | 1736 | 251677 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 772x Panorama Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996636.0 | 2102785.0 | 37.7536537924326 | -122.454558985212 | (37.7536537924326, -122.454558985212) | ||||
| 3044 | 3044 | 253288 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 650 Peru Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | |||||
| 3046 | 3046 | 253289 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 650 Peru Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | |||||
| 3049 | 3049 | 253290 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 650 Peru Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | |||||
| 3050 | 3050 | 253291 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 650 Peru Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | |||||
| 3112 | 3112 | 253318 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3113 | 3113 | 253332 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3115 | 3115 | 253329 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3116 | 3116 | 253328 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3119 | 3119 | 253313 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3120 | 3120 | 253308 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3121 | 3121 | 253303 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3122 | 3122 | 253323 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3123 | 3123 | 253306 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3125 | 3125 | 253309 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3127 | 3127 | 253316 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3128 | 3128 | 253330 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3129 | 3129 | 253317 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3130 | 3130 | 253319 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3131 | 3131 | 253310 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3133 | 3133 | 253333 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3135 | 3135 | 253335 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3136 | 3136 | 253320 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3139 | 3139 | 253322 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3140 | 3140 | 253334 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3141 | 3141 | 253311 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3142 | 3142 | 217765 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 470 West Portal Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | Width 10ft | 5991548.70787 | 2096139.0246599999 | 37.7351125606845 | -122.471667523249 | (37.7351125606845, -122.471667523249) | |||
| 3143 | 3143 | 253336 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3145 | 3145 | 253304 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3146 | 3146 | 253314 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3148 | 3148 | 253327 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3150 | 3150 | 253331 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3151 | 3151 | 253312 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3152 | 3152 | 253307 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3153 | 3153 | 253315 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3155 | 3155 | 253305 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3156 | 3156 | 253321 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3496 | 3496 | 253449 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 330 Twin Peaks Blvd | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5998688.0 | 2103995.0 | 37.7570936308358 | -122.44754983450599 | (37.7570936308358, -122.447549834506) | ||||
| 4884 | 4884 | 253710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
| 4891 | 4891 | 253709 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
| 4893 | 4893 | 253707 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
| 4898 | 4898 | 253711 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 5 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
| 4906 | 4906 | 253708 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
| 9172 | 9172 | 173599 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Warren Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5995367.0 | 2102770.0 | 37.7535397418859 | -122.458946354326 | (37.7535397418859, -122.458946354326) | |||
| 9640 | 9640 | 114128 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9648 | 9648 | 114133 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9649 | 9649 | 114125 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9650 | 9650 | 114131 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9662 | 9662 | 114130 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) |
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");