Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1810 | 1810 | 251708 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 239 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 3x3 | Permit Number 776109 | 6008639.31193 | 2109768.7769299997 | 37.7735107666471 | -122.413542618094 | (37.7735107666471, -122.413542618094) | ||
| 8020 | 8020 | 2680 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 2085 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2015 12:00:00 AM | 19 | 3X3 | 6003616.3325 | 2114868.6836 | 37.7872305155325 | -122.43128194219 | (37.7872305155325, -122.43128194219) | ||
| 14010 | 14010 | 29020 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 154 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008187.55893 | 2110147.28508 | 37.774524683913896 | -122.41513210056401 | (37.7745246839139, -122.415132100564) | ||
| 14020 | 14020 | 28999 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 241 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008639.31193 | 2109768.7769299997 | 37.7735107666471 | -122.413542618094 | (37.7735107666471, -122.413542618094) | ||
| 14043 | 14043 | 29025 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 250 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008614.8600699995 | 2109695.18627 | 37.77330733098729 | -122.413621994964 | (37.7733073309873, -122.413621994964) | ||
| 14366 | 14366 | 29008 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 123 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008118.46736 | 2110307.2661 | 37.774960070880496 | -122.415382430453 | (37.7749600708805, -122.415382430453) | ||
| 14507 | 14507 | 29010 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 113 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008095.190140001 | 2110335.0874799998 | 37.7750351534761 | -122.415464921674 | (37.7750351534761, -122.415464921674) | ||
| 14608 | 14608 | 29018 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 128 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008069.48566 | 2110276.86185 | 37.774873834897 | -122.41554971607 | (37.774873834897, -122.41554971607) | ||
| 15152 | 15152 | 29034 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 358 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009078.53506 | 2109215.83285 | 37.7720171644901 | -122.411984191933 | (37.7720171644901, -122.411984191933) | ||
| 15223 | 15223 | 29006 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 135 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008170.1889 | 2110256.9147 | 37.774824724723395 | -122.415199949027 | (37.7748247247234, -122.415199949027) | ||
| 15761 | 15761 | 29004 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 151 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008239.15145 | 2110183.90276 | 37.7746281266267 | -122.41495622374399 | (37.7746281266267, -122.414956223744) | ||
| 16199 | 16199 | 29033 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6009042.97746 | 2109247.69972 | 37.772102668444 | -122.412109441391 | (37.772102668444, -122.412109441391) | ||
| 18965 | 18965 | 16628 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 147 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2006 12:00:00 AM | 12 | 3X3 | 6002889.82891 | 2107449.635 | 37.766818457119896 | -122.433265159761 | (37.7668184571199, -122.433265159761) | ||
| 19707 | 19707 | 16635 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 153 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002890.76164 | 2107366.51768 | 37.766590290141394 | -122.43325599389 | (37.7665902901414, -122.43325599389) | |||
| 26010 | 26010 | 59099 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 488 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 13 | Permit Number 18401 | 5993459.272919999 | 2112191.2837799997 | 37.7792982564624 | -122.46622825483101 | (37.7792982564624, -122.466228254831) | ||
| 40032 | 40032 | 45645 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 1020 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2001 12:00:00 AM | 10 | Permit Number 44346 | 6011201.4795699995 | 2118401.58307 | 37.7973579490636 | -122.40528770508999 | (37.7973579490636, -122.40528770509) | ||
| 45528 | 45528 | 59144 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 690 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 10 | Permit Number 18451 | 5992269.28731 | 2110774.7292400002 | 37.775340052701104 | -122.470241689466 | (37.7753400527011, -122.470241689466) | ||
| 49592 | 49592 | 11636 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 56819 | 56819 | 68672 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 260 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 10 | Permit Number 32580 | 5993093.46375 | 2113748.31872 | 37.7835523382358 | -122.467606994541 | (37.7835523382358, -122.467606994541) | |
| 57897 | 57897 | 51033 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 76 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 4 | Permit Number 47508 | 6004871.9247 | 2093005.4504099998 | 37.7272702952631 | -122.42538140772 | (37.7272702952631, -122.42538140772) | ||
| 59605 | 59605 | 30514 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 340 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 22 | Permit Number 42913 | 6008785.20324 | 2113547.07327 | 37.783893261596 | -122.41330519888201 | (37.783893261596, -122.413305198882) | |
| 59720 | 59720 | 56313 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 229 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 12 | Permit Number 12447 | 5993040.18993 | 2113916.11955 | 37.7840099974474 | -122.467803508187 | (37.7840099974474, -122.467803508187) | ||
| 71057 | 71057 | 41070 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 255 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/1999 12:00:00 AM | 3 | Permit Number 41832 | 6008672.12135 | 2109729.96637 | 37.773406044194495 | -122.413426379828 | (37.7734060441945, -122.413426379828) | |
| 75995 | 75995 | 30523 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 23 | Permit Number 34528 | 6008465.79864 | 2112766.79262 | 37.7817328607212 | -122.414354996407 | (37.7817328607212, -122.414354996407) | |
| 79400 | 79400 | 41689 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | Permit Number 42143 | 6001812.465231299 | 2096668.95095007 | 37.737156097415706 | -122.436219989049 | (37.7371560974157, -122.436219989049) | |||
| 84512 | 84512 | 33479 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 84899 | 84899 | 92547 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 99 Santa Marina St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 52890 | 6006207.5 | 2097640.2 | 37.740071660795 | -122.42109327168501 | (37.740071660795, -122.421093271685) | |||
| 87227 | 87227 | 64914 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1989 12:00:00 AM | 4x4 | Permit Number 25941 | 6005478.362986099 | 2099307.48712071 | 37.7446085231046 | -122.42373284962 | (37.7446085231046, -122.42373284962) | |
| 91370 | 91370 | 51032 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 78 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 3 | Permit Number 47507 | 6004848.23489 | 2092967.4640400002 | 37.7271646546122 | -122.425460601145 | (37.7271646546122, -122.425460601145) | ||
| 93732 | 93732 | 11634 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 499X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 94836 | 94836 | 33480 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 97990 | 97990 | 11657 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 699X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
| 105125 | 105125 | 59141 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 588 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 15 | Permit Number 18448 | 5992243.78964 | 2111491.996 | 37.7773079985249 | -122.470382138383 | (37.7773079985249, -122.470382138383) | ||
| 107280 | 107280 | 56260 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 238 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | Permit Number 12386 | 5997570.92464879 | 2106477.05534424 | 37.763844826719705 | -122.451592119849 | (37.7638448267197, -122.451592119849) | |||
| 112329 | 112329 | 33476 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 113355 | 113355 | 14546 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 815 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5999184.70875 | 2110016.19662 | 37.773654699050496 | -122.44626515618 | (37.7736546990505, -122.44626515618) | |||
| 115239 | 115239 | 14548 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 815 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2000 12:00:00 AM | 3 | 3X3 | 5999184.70875 | 2110016.19662 | 37.773654699050496 | -122.44626515618 | (37.7736546990505, -122.44626515618) | ||
| 118261 | 118261 | 33474 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 140993 | 140993 | 56058 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 2858 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2007 12:00:00 AM | 3x3 | Permit Number 49940 | 6009112.81160157 | 2103362.97509043 | 37.7559484836074 | -122.41145205807301 | (37.7559484836074, -122.411452058073) | ||
| 141574 | 141574 | 33477 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 143673 | 143673 | 33478 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 147724 | 147724 | 59101 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 654 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 12 | Permit Number 18403 | 5993502.53489 | 2111016.0685 | 37.7760739276641 | -122.465993175595 | (37.7760739276641, -122.465993175595) | ||
| 151026 | 151026 | 92523 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 275 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52874 | 6008729.08615 | 2109670.8725400004 | 37.773246984679396 | -122.41322515024099 | (37.7732469846794, -122.413225150241) | |
| 158173 | 158173 | 45643 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 1020 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2001 12:00:00 AM | 13 | Permit Number 44346 | 6011195.59877 | 2118453.88611 | 37.797501231757 | -122.40531173944599 | (37.797501231757, -122.405311739446) | ||
| 171215 | 171215 | 44078 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 250 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2000 12:00:00 AM | 16 | Permit Number 43599 | 6012239.93104 | 2118827.2823900003 | 37.7985848203962 | -122.40172431143401 | (37.7985848203962, -122.401724311434) | |
| 172999 | 172999 | 83898 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 661 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50511 | 6001665.34461 | 2093208.93849 | 37.7276473387373 | -122.436481078764 | (37.7276473387373, -122.436481078764) | |
| 177143 | 177143 | 64058 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 3700 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1987 12:00:00 AM | 5 | Permit Number 24817 | 5987163.87734 | 2111884.56933 | 37.7780908722437 | -122.48798381967501 | (37.7780908722437, -122.487983819675) | ||
| 181150 | 181150 | 57868 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 360 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/1999 12:00:00 AM | 7 | Permit Number 16812 | 6008032.73051 | 2113659.8813099996 | 37.784160729883205 | -122.41591647488801 | (37.7841607298832, -122.415916474888) | |
| 183653 | 183653 | 30522 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 25 | Permit Number 34528 | 6008488.127169999 | 2112769.36057 | 37.781741165964704 | -122.414277931689 | (37.7817411659647, -122.414277931689) | |
| 2265 | 2265 | 252991 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005528.0 | 2099293.0 | 37.7445715466522 | -122.423560184697 | (37.7445715466522, -122.423560184697) | ||||
| 4450 | 4450 | 225795 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008004.64414 | 2103879.4657900003 | 37.7573044302625 | -122.415321039155 | (37.7573044302625, -122.415321039155) | |||
| 4515 | 4515 | 225797 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008067.53952 | 2103885.7722400003 | 37.75732528104621 | -122.41510396797301 | (37.7573252810462, -122.415103967973) | |||
| 4518 | 4518 | 225796 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008035.828509999 | 2103884.08468 | 37.7573188652869 | -122.415213517995 | (37.7573188652869, -122.415213517995) | |||
| 4521 | 4521 | 225798 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008119.80842 | 2103888.79141 | 37.757336508198705 | -122.414923414683 | (37.7573365081987, -122.414923414683) | |||
| 23787 | 23787 | 192299 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011852.1113599995 | 2102354.12957 | 37.7533316805221 | -122.401907686797 | (37.7533316805221, -122.401907686797) | |||
| 23985 | 23985 | 192353 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1500 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 2ft | 6015367.9403099995 | 2101545.1725 | 37.7513060448498 | -122.38969261993 | (37.7513060448498, -122.38969261993) | |||
| 24702 | 24702 | 192280 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009110.344190001 | 2108839.3922200003 | 37.7709853309346 | -122.411847556143 | (37.7709853309346, -122.411847556143) | |||
| 25212 | 25212 | 192295 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6010700.612380001 | 2105651.26498 | 37.7623205464704 | -122.406122099663 | (37.7623205464704, -122.406122099663) | |||
| 25322 | 25322 | 192237 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009520.068659999 | 2108454.52562 | 37.7699515539505 | -122.410403121719 | (37.7699515539505, -122.410403121719) | |||
| 25338 | 25338 | 225387 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6004770.30193 | 2101839.2583 | 37.7515201869079 | -122.426361411567 | (37.7515201869079, -122.426361411567) | |||
| 25376 | 25376 | 192340 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007835.1568599995 | 2110517.0734099997 | 37.7755202244095 | -122.416377328869 | (37.7755202244095, -122.416377328869) | |||
| 25993 | 25993 | 192209 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009355.45651 | 2108925.4652 | 37.7712354153226 | -122.41100578260401 | (37.7712354153226, -122.411005782604) | |||
| 27042 | 27042 | 128824 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 600 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011998.07084 | 2115236.9646099997 | 37.7887131646294 | -122.40230865672301 | (37.7887131646294, -122.402308656723) | |||
| 27145 | 27145 | 192211 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009388.568940001 | 2108888.9656700003 | 37.7711370528685 | -122.410888666597 | (37.7711370528685, -122.410888666597) | |||
| 28167 | 28167 | 192309 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6011943.7523300005 | 2107376.90821 | 37.767128230416105 | -122.401943831469 | (37.7671282304161, -122.401943831469) | |||
| 28457 | 28457 | 192322 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011704.5689199995 | 2107781.11389 | 37.7682247360183 | -122.40279956606301 | (37.7682247360183, -122.402799566063) | |||
| 28861 | 28861 | 192349 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 262 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008725.32275 | 2109583.20667 | 37.773006063508504 | -122.413231967974 | (37.7730060635085, -122.413231967974) | |||
| 28875 | 28875 | 109474 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012029.14391 | 2118799.20085 | 37.7984959502925 | -122.402451729872 | (37.7984959502925, -122.402451729872) | |||
| 29899 | 29899 | 192224 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009548.42342 | 2108726.25306 | 37.770699244008895 | -122.410324231382 | (37.7706992440089, -122.410324231382) | |||
| 30042 | 30042 | 192221 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009500.9778 | 2108774.7519400003 | 37.7708297509354 | -122.41049177239599 | (37.7708297509354, -122.410491772396) | |||
| 30174 | 30174 | 225388 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 306 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6004766.979119999 | 2101818.89406 | 37.751464083609996 | -122.426371452475 | (37.75146408361, -122.426371452475) | |||
| 30684 | 30684 | 192318 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6011708.94846 | 2107685.56864 | 37.7679626349073 | -122.402777697245 | (37.7679626349073, -122.402777697245) | |||
| 32277 | 32277 | 218975 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 25 Lakewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993599.79076 | 2092994.2198700001 | 37.726596156286504 | -122.464347997761 | (37.7265961562865, -122.464347997761) | |||
| 32326 | 32326 | 225783 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3251 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007765.10393 | 2105579.72042 | 37.7619594722828 | -122.416269885947 | (37.7619594722828, -122.416269885947) | |||
| 32509 | 32509 | 192275 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009036.05094 | 2108770.66843 | 37.7707924632209 | -122.412099681957 | (37.7707924632209, -122.412099681957) | |||
| 33085 | 33085 | 109480 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6011947.44314 | 2118785.89715 | 37.7984548602505 | -122.402733505447 | (37.7984548602505, -122.402733505447) | |||
| 33435 | 33435 | 192252 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009308.54371 | 2108355.35398 | 37.7696673915621 | -122.411127779219 | (37.7696673915621, -122.411127779219) | |||
| 33563 | 33563 | 192305 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2599 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009925.06485 | 2105936.96188 | 37.763061595931894 | -122.40882459747 | (37.7630615959319, -122.40882459747) | |||
| 33903 | 33903 | 225779 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1559 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999770.51083 | 2107118.5981099997 | 37.765732061717294 | -122.44403054288901 | (37.7657320617173, -122.444030542889) | |||
| 34034 | 34034 | 128825 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 600 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6011989.53481 | 2115248.11567 | 37.7887433063148 | -122.40233897468399 | (37.7887433063148, -122.402338974684) | |||
| 34313 | 34313 | 192355 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 1ft | 6013376.06433 | 2096591.73652 | 37.7375943028269 | -122.39623367064199 | (37.7375943028269, -122.396233670642) | |||
| 34317 | 34317 | 192232 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009598.466630001 | 2108528.5531599997 | 37.7701592110077 | -122.41013717060899 | (37.7701592110077, -122.410137170609) | |||
| 34513 | 34513 | 192213 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009411.17621 | 2108867.66587 | 37.7710798361979 | -122.410808962379 | (37.7710798361979, -122.410808962379) | |||
| 35877 | 35877 | 192283 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009158.56943 | 2108886.63938 | 37.7711177659971 | -122.411684081879 | (37.7711177659971, -122.411684081879) | |||
| 36050 | 36050 | 120307 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988691.32321 | 2114547.3374400004 | 37.785491068319395 | -122.482895098939 | (37.7854910683194, -122.482895098939) | |||
| 36159 | 36159 | 192290 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009249.88348 | 2108971.40543 | 37.771355635782704 | -122.411374211455 | (37.7713556357827, -122.411374211455) | |||
| 36227 | 36227 | 225787 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 46 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004400.603180001 | 2095343.96322 | 37.7336646890731 | -122.42717726484 | (37.7336646890731, -122.42717726484) | |||
| 37040 | 37040 | 248584 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5998013.4865 | 2107655.5885 | 37.7671061143032 | -122.450146392184 | (37.7671061143032, -122.450146392184) | |||
| 37426 | 37426 | 192216 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009448.92717 | 2108828.0279599996 | 37.7709731163511 | -122.410675580336 | (37.7709731163511, -122.410675580336) | |||
| 38564 | 38564 | 192200 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 326 10th St | 0 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008879.18119 | 2109418.2333 | 37.7725617219648 | -122.41268808588998 | (37.7725617219648, -122.41268808589) | |||
| 38913 | 38913 | 192279 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009094.0417599995 | 2108824.03792 | 37.7709422570085 | -122.411902861747 | (37.7709422570085, -122.411902861747) | |||
| 40148 | 40148 | 225812 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 6002912.30789 | 2107203.01713 | 37.7661425797454 | -122.43316978576999 | (37.7661425797454, -122.43316978577) | |||
| 40346 | 40346 | 128822 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 250 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012208.0631 | 2118824.10156 | 37.798574308201204 | -122.401834361485 | (37.7985743082012, -122.401834361485) | |||
| 40518 | 40518 | 192261 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009200.74359 | 2108465.0274400003 | 37.769962483400796 | -122.41150840741001 | (37.7699624834008, -122.41150840741) | |||
| 40753 | 40753 | 192274 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009024.55442 | 2108760.36704 | 37.770763532946795 | -122.412138720645 | (37.7707635329468, -122.412138720645) | |||
| 40849 | 40849 | 225810 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6002901.372830001 | 2107162.40051 | 37.766030436082794 | -122.433204705528 | (37.7660304360828, -122.433204705528) | |||
| 41323 | 41323 | 192218 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009470.84858 | 2108807.6783 | 37.770918469946295 | -122.410598315981 | (37.7709184699463, -122.410598315981) | |||
| 42094 | 42094 | 192240 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009484.38016 | 2108422.4744 | 37.7698615480128 | -122.41052430446001 | (37.7698615480128, -122.41052430446) | |||
| 42728 | 42728 | 192205 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009311.714459999 | 2108971.0789 | 37.7713582069357 | -122.411160311315 | (37.7713582069357, -122.411160311315) | |||
| 42776 | 42776 | 225811 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002903.222130001 | 2107175.55757 | 37.766066667072 | -122.43319924936701 | (37.766066667072, -122.433199249367) |
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");