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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109753 | 109753 | 985 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1628 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001654.0889800005 | 2092682.1975 | 37.7262003881553 | -122.436482304747 | (37.7262003881553, -122.436482304747) | |||
| 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) | ||
| 115102 | 115102 | 2681 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 2085 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2015 12:00:00 AM | 22 | 3X3 | 6003609.80751 | 2114718.21117 | 37.7868169864691 | -122.431293772174 | (37.7868169864691, -122.431293772174) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 21141 | 21141 | 16624 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 143 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5x5 | 6002878.48419 | 2107471.6414099997 | 37.7668782377669 | -122.43330597190001 | (37.7668782377669, -122.4333059719) | |||
| 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) | |||
| 19824 | 19824 | 16637 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 159 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002887.79495 | 2107329.82108 | 37.7664893619256 | -122.433263632733 | (37.7664893619256, -122.433263632733) | |||
| 7849 | 7849 | 23269 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 843X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3X3 | 6006584.636609999 | 2113380.90993 | 37.7833132240722 | -122.42090655840201 | (37.7833132240722, -122.420906558402) | |||
| 7259 | 7259 | 23270 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 843X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3X3 | 6006591.05831 | 2113351.86982 | 37.783233848997 | -122.42088227939101 | (37.783233848997, -122.420882279391) | |||
| 8049 | 8049 | 23281 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 843X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6006558.1517199995 | 2113495.8441 | 37.7836273122865 | -122.42100634895901 | (37.7836273122865, -122.421006348959) | |||
| 13842 | 13842 | 25983 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1901 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6013395.85675 | 2096673.78587 | 37.7378206945684 | -122.396170987024 | (37.7378206945684, -122.396170987024) | |||
| 14443 | 14443 | 25984 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1901 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6013408.21183 | 2096665.5323700001 | 37.7377987196205 | -122.396127690947 | (37.7377987196205, -122.396127690947) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 14816 | 14816 | 29032 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 330 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 02:58:00 PM | 3 | 3x3 | 6008959.5053199995 | 2109339.54752 | 37.7723501771487 | -122.412404672648 | (37.7723501771487, -122.412404672648) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 145428 | 145428 | 33475 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 194X COLERIDGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/1996 12:00:00 AM | 40 | Permit Number 37572 | 6006432.0 | 2098629.0 | 37.742799336995795 | -122.420387207052 | (37.7427993369958, -122.420387207052) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 48659 | 48659 | 75815 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6011743.63854 | 2118757.50225 | 37.7983655135139 | -122.403436737532 | (37.7983655135139, -122.403436737532) | ||
| 186545 | 186545 | 75860 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 9 | 6011761.31231 | 2118758.70866 | 37.7983698131588 | -122.40337566547701 | (37.7983698131588, -122.403375665477) | ||
| 47641 | 47641 | 75888 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 13 | 6011802.87578 | 2118766.0417 | 37.7983922692391 | -122.40323235850501 | (37.7983922692391, -122.403232358505) | ||
| 155272 | 155272 | 75920 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 12 | 6011822.33856 | 2118769.3001099997 | 37.7984023029841 | -122.403165240278 | (37.7984023029841, -122.403165240278) | ||
| 146501 | 146501 | 75946 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 13 | 6011842.29348 | 2118770.98259 | 37.7984080370505 | -122.403096308158 | (37.7984080370505, -122.403096308158) | ||
| 138091 | 138091 | 75974 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 15 | 6011885.57896 | 2118777.06264 | 37.7984271485395 | -122.402946954135 | (37.7984271485395, -122.402946954135) | ||
| 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) | |
| 86442 | 86442 | 89466 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 3700 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987138.86697 | 2111884.81108 | 37.77809007701521 | -122.488070356177 | (37.7780900770152, -122.488070356177) | ||
| 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) | |
| 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) | |||
| 101611 | 101611 | 96698 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5997732.0 | 2108845.0 | 37.770355822096704 | -122.451205793491 | (37.7703558220967, -122.451205793491) | |||
| 108119 | 108119 | 98345 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998016.0 | 2107622.0 | 37.767014032658 | -122.45013527715 | (37.767014032658, -122.45013527715) | ||||
| 90352 | 90352 | 107514 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 76 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x10 | 5993384.0 | 2099214.0 | 37.7436616846124 | -122.4655456274 | (37.7436616846124, -122.4655456274) | |||
| 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) | |||
| 130927 | 130927 | 109476 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012009.31763 | 2118795.25368 | 37.7984840054917 | -122.402520057652 | (37.7984840054917, -122.402520057652) | |||
| 73373 | 73373 | 109478 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6011984.93585 | 2118790.70315 | 37.798470149639705 | -122.402604106489 | (37.7984701496397, -122.402604106489) | |||
| 149205 | 149205 | 109479 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6011964.26444 | 2118788.1652 | 37.798462026943895 | -122.402675457803 | (37.7984620269439, -122.402675457803) | |||
| 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) | |||
| 136969 | 136969 | 109481 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6011927.997819999 | 2118783.50855 | 37.7984472160146 | -122.402800624568 | (37.7984472160146, -122.402800624568) | |||
| 101798 | 101798 | 113749 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 459 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5998867.0 | 2109101.0 | 37.7711236529318 | -122.447298272426 | (37.7711236529318, -122.447298272426) | ||||
| 121652 | 121652 | 115825 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 403 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5998362.0 | 2109233.0 | 37.7714572219689 | -122.449054588277 | (37.7714572219689, -122.449054588277) | ||||
| 116506 | 116506 | 116066 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 40 MALTA DR | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 5999623.0 | 2096071.0 | 37.7353896244756 | -122.44374699604401 | (37.7353896244756, -122.443746996044) | |||||
| 174316 | 174316 | 120304 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988688.31832 | 2114612.7837400003 | 37.7856705904605 | -122.482910293069 | (37.7856705904605, -122.482910293069) | |||
| 45941 | 45941 | 120305 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5988689.97406 | 2114597.66035 | 37.7856291622608 | -122.48290345597601 | (37.7856291622608, -122.482903455976) | |||
| 132924 | 132924 | 120306 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 23rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5988689.7691 | 2114567.26931 | 37.7855457051568 | -122.482901936944 | (37.7855457051568, -122.482901936944) | |||
| 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) | |||
| 175310 | 175310 | 120475 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2153 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5988722.30623 | 2114650.7724599997 | 37.7857768742694 | -122.48279549106701 | (37.7857768742694, -122.482795491067) | |||
| 129661 | 129661 | 120476 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2153 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5988709.31254 | 2114650.77812 | 37.785776133796894 | -122.482840445446 | (37.7857761337969, -122.482840445446) | |||
| 179125 | 179125 | 124030 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 101 Funston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5991790.3652800005 | 2114364.58828 | 37.78516912121479 | -122.47216010553801 | (37.7851691212148, -122.472160105538) | |||
| 53357 | 53357 | 128808 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2501 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001383.33039 | 2116587.25055 | 37.7918224564007 | -122.439130852904 | (37.7918224564007, -122.439130852904) | |||
| 72951 | 72951 | 128809 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2798 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000135.50576 | 2117439.15627 | 37.7940904836317 | -122.443509534145 | (37.7940904836317, -122.443509534145) | |||
| 146699 | 146699 | 128810 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2619 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6003992.93502 | 2117891.72487 | 37.7955523541042 | -122.430194727727 | (37.7955523541042, -122.430194727727) | |||
| 135679 | 135679 | 128811 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 360 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008019.0102 | 2113722.70436 | 37.78433245540771 | -122.415968392744 | (37.7843324554077, -122.415968392744) | |||
| 71246 | 71246 | 128812 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 360 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008015.3478 | 2113733.84894 | 37.7843628498196 | -122.415981852889 | (37.7843628498196, -122.415981852889) | |||
| 131457 | 131457 | 128813 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 843 Van Ness Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 6006569.2006 | 2113431.92774 | 37.783452436413 | -122.42096358442 | (37.783452436413, -122.42096358442) | |||
| 62312 | 62312 | 128814 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 843 Van Ness Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 6006609.50703 | 2113290.0026 | 37.783065016591 | -122.420814060425 | (37.783065016591, -122.420814060425) | |||
| 118104 | 118104 | 128815 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6008510.99254 | 2112773.43009 | 37.781753624263295 | -122.41419911600201 | (37.7817536242633, -122.414199116002) | |||
| 62979 | 62979 | 128816 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6008534.849640001 | 2112776.4712099996 | 37.7817633144723 | -122.414116796578 | (37.7817633144723, -122.414116796578) | |||
| 172597 | 172597 | 128817 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008554.10037 | 2112777.08556 | 37.7817660825767 | -122.414050241334 | (37.7817660825767, -122.414050241334) | |||
| 63148 | 63148 | 128818 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 99 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6008590.072819999 | 2112753.6633099997 | 37.7817037910346 | -122.413924135711 | (37.7817037910346, -122.413924135711) | |||
| 42948 | 42948 | 128819 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 99 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6008597.39864 | 2112731.9069 | 37.7816444645714 | -122.41389725225001 | (37.7816444645714, -122.41389725225) | |||
| 166498 | 166498 | 128820 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 99 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6008600.12871 | 2112713.96294 | 37.7815953480768 | -122.413886537756 | (37.7815953480768, -122.413886537756) | |||
| 137651 | 137651 | 128821 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 99 Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6008602.80861 | 2112693.55273 | 37.7815394570312 | -122.41387582233 | (37.7815394570312, -122.41387582233) | |||
| 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) |
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");