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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 70435 | 70435 | 187490 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 750 Velasco Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6006575.2964699995 | 2086657.1322 | 37.709935258482 | -122.419042759324 | (37.709935258482, -122.419042759324) | ||||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 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) | ||||
| 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) | |||
| 67135 | 67135 | 138603 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2662 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001201.7584 | 2114936.3549 | 37.787279191103295 | -122.439640685052 | (37.7872791911033, -122.439640685052) | |||
| 186614 | 186614 | 247293 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1187 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5999369.2896 | 2108822.0623 | 37.7703864492561 | -122.445540779928 | (37.7703864492561, -122.445540779928) | |||
| 188237 | 188237 | 244215 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997712.0535 | 2108841.8253 | 37.7703459631123 | -122.451274559097 | (37.7703459631123, -122.451274559097) | |||
| 179390 | 179390 | 218976 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 208 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6000663.81639 | 2094977.92785 | 37.73244761315671 | -122.440070159711 | (37.7324476131567, -122.440070159711) | |||
| 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) | |||
| 156396 | 156396 | 192354 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6013388.3658300005 | 2096606.99697 | 37.7376368893361 | -122.39619220741999 | (37.7376368893361, -122.39619220742) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 46622 | 46622 | 248136 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 226 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6010037.88024 | 2099520.31318 | 37.745449227116204 | -122.407981876971 | (37.7454492271162, -122.407981876971) | |||
| 54476 | 54476 | 218970 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 85 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997504.5128 | 2099195.16066 | 37.7438467530404 | -122.45129660546499 | (37.7438467530404, -122.451296605465) | |||
| 69712 | 69712 | 192297 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6010694.42792 | 2105749.21353 | 37.7625891451824 | -122.406150390541 | (37.7625891451824, -122.406150390541) | |||
| 149426 | 149426 | 225781 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3271 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007691.06747 | 2105574.75784 | 37.7619416827748 | -122.416525598274 | (37.7619416827748, -122.416525598274) | |||
| 163347 | 163347 | 218971 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 736 Myra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997513.55349 | 2097982.45512 | 37.7405174763054 | -122.451177906656 | (37.7405174763054, -122.451177906656) | |||
| 172557 | 172557 | 218973 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 550 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5997760.19795 | 2094413.18303 | 37.7307312291661 | -122.450067916609 | (37.7307312291661, -122.450067916609) | |||
| 174186 | 174186 | 225782 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3271 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007716.52666 | 2105576.00343 | 37.761946534627 | -122.416437632899 | (37.761946534627, -122.416437632899) | |||
| 183667 | 183667 | 225780 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3271 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007669.1739300005 | 2105574.3226 | 37.76193925642529 | -122.41660128882401 | (37.7619392564253, -122.416601288824) | |||
| 451 | 451 | 192346 | Planning Code 138.1 required 4 | Fraxinus spp :: Ash Spp 83 | 118 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 770901 | 6007994.19176 | 2110350.5452799997 | 37.7750719195804 | -122.41581539288201 | (37.7750719195804, -122.415815392882) |
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");