Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96461 | 96461 | 64169 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 762 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1992 12:00:00 AM | 12 | Permit Number 30328 | 5991975.848119999 | 2110258.89161 | 37.773906732993396 | -122.47121916339898 | (37.7739067329934, -122.471219163399) | |
| 96462 | 96462 | 26447 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1899X Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6001375.512630001 | 2112473.63814 | 37.780527088517296 | -122.438862984365 | (37.7805270885173, -122.438862984365) | |||
| 96463 | 96463 | 55157 | Permitted Site 1 | Tree(s) :: 17 | 4109 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1972 12:00:00 AM | Permit Number 11062 | 6002468.2625402 | 2101776.15074155 | 37.7512165121935 | -122.434317626577 | (37.7512165121935, -122.434317626577) | |||
| 96464 | 96464 | 36748 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 76 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51605 | 6006475.0850251 | 2108037.53406909 | 37.768635426061294 | -122.42090607147101 | (37.7686354260613, -122.420906071471) | ||
| 96465 | 96465 | 121662 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 96466 | 96466 | 877 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 96467 | 96467 | 68114 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 9 Powers Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31860 | 6006758.25542917 | 2099860.24648368 | 37.746198442531295 | -122.419346431514 | (37.7461984425313, -122.419346431514) | ||
| 96468 | 96468 | 87593 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2008 12:00:00 AM | 3 | 3x3 | 5991401.185357 | 2095410.335482 | 37.7331032279342 | -122.472124459161 | (37.7331032279342, -122.472124459161) | ||
| 96469 | 96469 | 16330 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 798 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2015 12:00:00 AM | 3 | 3X3 | 5996807.5825755 | 2094755.2467478001 | 37.731615896855104 | -122.45338592568199 | (37.7316158968551, -122.453385925682) | ||
| 96470 | 96470 | 76165 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 49 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1996 12:00:00 AM | 6 | 3x3 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | ||
| 96471 | 96471 | 56770 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 249 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | Permit Number 777118 | 6000646.04543173 | 2102139.76865728 | 37.752111320918495 | -122.440645114373 | (37.7521113209185, -122.440645114373) | |||
| 96472 | 96472 | 89558 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5239 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982363.16543 | 2111656.98924 | 37.77718478612329 | -122.504574063555 | (37.7771847861233, -122.504574063555) | ||
| 96473 | 96473 | 2228 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2110X Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x6 | 6000737.52744 | 2112779.56112 | 37.7813307569521 | -122.44109202584801 | (37.7813307569521, -122.441092025848) | |||
| 96474 | 96474 | 26584 | DPW Maintained 3 | Ulmus 'Prospector' :: Prospector Elm 255 | 1799X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/1998 12:00:00 AM | 6 | 3x3 | 6012271.0640199995 | 2090627.3118900002 | 37.721155676338896 | -122.399635553716 | (37.7211556763389, -122.399635553716) | ||
| 96475 | 96475 | 115137 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | |||||
| 96476 | 96476 | 30421 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 530 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/1956 12:00:00 AM | Permit Number 75 | 6009285.11323863 | 2120849.80325768 | 37.803972827810995 | -122.412091961384 | (37.803972827811, -122.412091961384) | |||
| 96477 | 96477 | 53295 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4109 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767838 | 6002436.35323734 | 2102355.70064678 | 37.7528060072833 | -122.434469405268 | (37.7528060072833, -122.434469405268) | |
| 96478 | 96478 | 68914 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1535 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32893 | 6005691.62707628 | 2118555.83678979 | 37.7974719031724 | -122.42436421109501 | (37.7974719031724, -122.424364211095) | ||
| 96479 | 96479 | 97624 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 333@Clay Battery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012618.0 | 2117355.0 | 37.7945633749541 | -122.400312601987 | (37.7945633749541, -122.400312601987) | |||||
| 96480 | 96480 | 27535 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/05/2001 12:00:00 AM | 15 | 3X3 | 6016127.146980001 | 2102787.87807 | 37.754760323366206 | -122.38715384385 | (37.7547603233662, -122.38715384385) | ||
| 96481 | 96481 | 9034 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5410 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5990186.236190001 | 2112722.6445299997 | 37.7805678394327 | -122.477589778145 | (37.7805678394327, -122.477589778145) | |||
| 96482 | 96482 | 8109 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 790X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6004003.8918437995 | 2111454.7703146 | 37.7778787172016 | -122.429697487702 | (37.7778787172016, -122.429697487702) | |||
| 96483 | 96483 | 39042 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009489.831 | 2105754.377 | 37.76253587140361 | -122.41031703728999 | (37.7625358714036, -122.41031703729) | ||
| 96484 | 96484 | 6324 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1895X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 96485 | 96485 | 112786 | Permitted Site 1 | Tree(s) :: 17 | 160 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | 3x3 | 6007598.0 | 2107985.0 | 37.7685544110168 | -122.41701826563101 | (37.7685544110168, -122.417018265631) | |||
| 96486 | 96486 | 57471 | Permitted Site 1 | Tree(s) :: 17 | 1777 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/1976 12:00:00 AM | Permit Number 16321 | 5998082.14610131 | 2108890.1443394 | 37.770499818572 | -122.449997897967 | (37.770499818572, -122.449997897967) | |||
| 96487 | 96487 | 116805 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1300 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/10/2016 12:00:00 AM | 3 | Permit Number 778212 | 5991565.06136 | 2110684.94877 | 37.7750528005049 | -122.472671199313 | (37.7750528005049, -122.472671199313) | |
| 96488 | 96488 | 64588 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3344 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1988 12:00:00 AM | Permit Number 25489 | 6006043.57087023 | 2103191.45223096 | 37.75530489128629 | -122.422054334702 | (37.7553048912863, -122.422054334702) | ||
| 96489 | 96489 | 50428 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47081 | 5996479.47890892 | 2089951.8399168998 | 37.7184080697361 | -122.454173429085 | (37.7184080697361, -122.454173429085) | ||
| 96490 | 96490 | 114990 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 222 02ND ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6013206.0 | 2114380.0 | 37.786427493175296 | -122.39806922534099 | (37.7864274931753, -122.398069225341) | ||||
| 96491 | 96491 | 82868 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 229- 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52430 | 6009387.0 | 2110633.0 | 37.775925675553296 | -122.411017299189 | (37.7759256755533, -122.411017299189) | ||
| 96492 | 96492 | 14965 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 385 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/1996 12:00:00 AM | 3 | 3X3 | 6016787.6835199995 | 2097759.85667 | 37.7409909681193 | -122.38451930761299 | (37.7409909681193, -122.384519307613) | ||
| 96493 | 96493 | 25349 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 40X Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2003 12:00:00 AM | 3 | 3X3 | 5997270.77757 | 2091437.16647 | 37.722531773344706 | -122.45154533174801 | (37.7225317733447, -122.451545331748) | ||
| 96494 | 96494 | 110186 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | ||||
| 96495 | 96495 | 107714 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1798X 31st Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773637 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | |
| 96496 | 96496 | 50072 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 2523 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46803 | 5991378.06178128 | 2098242.3918878003 | 37.740877997652795 | -122.47241079131001 | (37.7408779976528, -122.47241079131) | ||
| 96497 | 96497 | 9942 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | |||
| 96498 | 96498 | 5928 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1335 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | |||
| 96499 | 96499 | 56746 | Permitted Site 1 | Tree(s) :: 17 | 121 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1974 12:00:00 AM | Permit Number 13961 | 6002801.72361382 | 2108956.50205347 | 37.770950946111796 | -122.433677608083 | (37.7709509461118, -122.433677608083) | |||
| 96500 | 96500 | 59952 | Permitted Site 1 | Tree(s) :: 17 | 50 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1981 12:00:00 AM | Permit Number 19428 | 6011256.14470123 | 2114702.86131244 | 37.787205200658896 | -122.40483800898701 | (37.7872052006589, -122.404838008987) | |||
| 96501 | 96501 | 69421 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 400 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1994 12:00:00 AM | 8 | Permit Number 33526 | 6008905.76984219 | 2106354.06627794 | 37.7641497228891 | -122.41237948925101 | (37.7641497228891, -122.412379489251) | ||
| 96502 | 96502 | 32833 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4606 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37190 | 6000649.80071179 | 2101139.77358101 | 37.7493657890432 | -122.44056041085301 | (37.7493657890432, -122.440560410853) | ||
| 96503 | 96503 | 45828 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 680 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2001 12:00:00 AM | Permit Number 44447 | 6012169.50994414 | 2114476.97613275 | 37.786635983377295 | -122.40166206027901 | (37.7866359833773, -122.401662060279) | |||
| 96504 | 96504 | 90648 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3326 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985315.670548 | 2110447.4548029997 | 37.774036978686105 | -122.494271383414 | (37.7740369786861, -122.494271383414) | |
| 96505 | 96505 | 101990 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 96506 | 96506 | 100063 | Undocumented 2 | Tree(s) :: 17 | 430X Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2012 12:00:00 AM | 3x3 | Permit Number 768595 | 6011459.0 | 2112320.0 | 37.780673759287204 | -122.40396841919399 | (37.7806737592872, -122.403968419194) | ||
| 96507 | 96507 | 65431 | Permitted Site 1 | Tree(s) :: 17 | 610 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775655 | 6008390.72106118 | 2114558.67697013 | 37.786648725258296 | -122.41474158095899 | (37.7866487252583, -122.414741580959) | |
| 96508 | 96508 | 31080 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 196 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34818 | 6005439.37562614 | 2108486.56772635 | 37.769809930745 | -122.42452045534901 | (37.769809930745, -122.424520455349) | ||
| 96509 | 96509 | 23192 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 500 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6006809.13674 | 2112310.98108 | 37.7803881115112 | -122.420053921609 | (37.7803881115112, -122.420053921609) | |||
| 96510 | 96510 | 12313 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 977X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.42656163800899 | (37.7801814652814, -122.426561638009) | |||
| 96511 | 96511 | 42807 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2000 12:00:00 AM | Permit Number 42757 | 6004214.17005009 | 2106015.94399708 | 37.7629569261619 | -122.42858227503 | (37.7629569261619, -122.42858227503) | |||
| 96512 | 96512 | 92578 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2751 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52913 | 5991776.4 | 2096845.5 | 37.7370655343471 | -122.470931764793 | (37.7370655343471, -122.470931764793) | ||
| 96513 | 96513 | 85612 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017578.234449 | 2092916.188247 | 37.7277348985577 | -122.381449098373 | (37.7277348985577, -122.381449098373) | ||
| 96514 | 96514 | 42312 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 301 Edna St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42532 | 5998734.92164885 | 2093801.38025355 | 37.729107090700396 | -122.44665415584801 | (37.7291070907004, -122.446654155848) | ||
| 96515 | 96515 | 12076 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1241X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017245.0743814 | 2094442.9323578998 | 37.7319086387255 | -122.382707045529 | (37.7319086387255, -122.382707045529) | |||
| 96516 | 96516 | 59851 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1119 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1981 12:00:00 AM | Permit Number 19307 | 6017428.44424481 | 2093319.71178593 | 37.7288346243781 | -122.381994988143 | (37.7288346243781, -122.381994988143) | ||
| 96517 | 96517 | 111911 | Undocumented 2 | Tree(s) :: 17 | 203 14TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991427.0 | 2114042.0 | 37.784262348424896 | -122.473393687159 | (37.7842623484249, -122.473393687159) | ||||
| 96518 | 96518 | 39474 | Permitted Site 1 | Tree(s) :: 17 | 30 Ashbury Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40936 | 5999587.55794715 | 2106838.29242396 | 37.7649519741137 | -122.444643186495 | (37.7649519741137, -122.444643186495) | |||
| 96519 | 96519 | 14200 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005370.141556599 | 2108806.2043077 | 37.770683665857796 | -122.42478267708 | (37.7706836658578, -122.42478267708) | |||
| 96520 | 96520 | 60718 | Permitted Site 1 | Tree(s) :: 17 | 62 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1983 12:00:00 AM | Permit Number 20371 | 6005226.82013207 | 2105099.87911684 | 37.7604988846351 | -122.42501468297701 | (37.7604988846351, -122.425014682977) | |||
| 96521 | 96521 | 62611 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2262 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1986 12:00:00 AM | Permit Number 22921 | 5989510.16412079 | 2099957.30856958 | 37.745478424066704 | -122.478994620655 | (37.7454784240667, -122.478994620655) | ||
| 96522 | 96522 | 108113 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 786 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x7 | 5998636.0 | 2107697.0 | 37.76725542331079 | -122.447996203185 | (37.7672554233108, -122.447996203185) | ||||
| 96523 | 96523 | 2448 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1397X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/1998 12:00:00 AM | 3 | 3X3 | 6004179.9853375 | 2113057.7494528 | 37.782290070243 | -122.42920264733499 | (37.782290070243, -122.429202647335) | ||
| 96524 | 96524 | 99660 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1365 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.46532315146601 | (37.7394617231066, -122.465323151466) | |||||
| 96525 | 96525 | 96881 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X San Jose Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
| 96526 | 96526 | 26623 | DPW Maintained 3 | Ulmus 'Prospector' :: Prospector Elm 255 | 1285X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1998 12:00:00 AM | 6 | 3X3 | 6011577.7605432 | 2093254.4735551002 | 37.7283306504833 | -122.402216731645 | (37.7283306504833, -122.402216731645) | ||
| 96527 | 96527 | 27280 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 634 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 3X3 | 6003944.74418 | 2110118.79911 | 37.774207119954 | -122.42980678534599 | (37.774207119954, -122.429806785346) | ||
| 96528 | 96528 | 68858 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 270 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | 7x5 | Permit Number 32821 | 5999625.60484237 | 2094393.46674957 | 37.730783660166395 | -122.443617519141 | (37.7307836601664, -122.443617519141) | |
| 96529 | 96529 | 9076 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 5618 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989554.31102 | 2112758.21214 | 37.7806288074212 | -122.479778486374 | (37.7806288074212, -122.479778486374) | |||
| 96530 | 96530 | 41840 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1700 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42229 | 5990928.97536733 | 2103814.00676311 | 37.7561501991072 | -122.47437003138201 | (37.7561501991072, -122.474370031382) | ||
| 96531 | 96531 | 2118 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100X Bosworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||
| 96532 | 96532 | 102141 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 53 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2012 12:00:00 AM | 3 | 2x3 | Permit Number 769415 | 6002570.6 | 2095528.3 | 37.7340671770771 | -122.433517283514 | (37.7340671770771, -122.433517283514) | |
| 96533 | 96533 | 111583 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1501-1555 Mariposa St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012875.34483574 | 2106095.24513094 | 37.763661017326605 | -122.39863162145599 | (37.7636610173266, -122.398631621456) | |||||
| 96534 | 96534 | 59008 | Permitted Site 1 | Tree(s) :: 17 | 3733 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1980 12:00:00 AM | Permit Number 18299 | 6005431.15703619 | 2104275.5232716 | 37.758246937505206 | -122.424249344104 | (37.7582469375052, -122.424249344104) | |||
| 96535 | 96535 | 5968 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1545X Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1994 12:00:00 AM | 12 | 3X3 | 6003060.99726 | 2112693.12007 | 37.78122547991929 | -122.43304778577401 | (37.7812254799193, -122.433047785774) | ||
| 96536 | 96536 | 60175 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 54 Lapidge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1988 12:00:00 AM | Permit Number 25533 | 6005979.27726365 | 2105187.71035503 | 37.760782524281296 | -122.42241851621 | (37.7607825242813, -122.42241851621) | ||
| 96537 | 96537 | 54826 | Permitted Site 1 | Tree(s) :: 17 | 1446 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | Permit Number 10680 | 6015416.00936396 | 2093138.2264494 | 37.728224958648795 | -122.38893950701001 | (37.7282249586488, -122.38893950701) | |||
| 96538 | 96538 | 67146 | Permitted Site 1 | Tree(s) :: 17 | 133 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1992 12:00:00 AM | 3x3 | Permit Number 30577 | 6005614.88438927 | 2099023.3242476 | 37.7438359821112 | -122.42324058953899 | (37.7438359821112, -122.423240589539) | ||
| 96539 | 96539 | 36278 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 50 Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1998 12:00:00 AM | Permit Number 39278 | 5991022.47129898 | 2094553.69914368 | 37.7307291972141 | -122.473371303037 | (37.7307291972141, -122.473371303037) | |||
| 96540 | 96540 | 69530 | Permitted Site 1 | Tree(s) :: 17 | 2112 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1997 12:00:00 AM | Permit Number 38534 | 6000962.81317482 | 2115616.98760831 | 37.7891344296187 | -122.44051621813 | (37.7891344296187, -122.44051621813) | |||
| 96541 | 96541 | 110246 | Permitted Site 1 | :: 54 | 1706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/01/2015 12:00:00 AM | 3 | 1.5x12 | 5987540.7 | 2103643.4 | 37.755484875136204 | -122.486075162345 | (37.7554848751362, -122.486075162345) | ||
| 96542 | 96542 | 50136 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 262@ CORTLAND Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2003 12:00:00 AM | Permit Number 46866 | 6008960.90662069 | 2097129.15135037 | 37.7388232647458 | -122.41153698562 | (37.7388232647458, -122.41153698562) | |||
| 96543 | 96543 | 76813 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
| 96544 | 96544 | 103840 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1546 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006695.0 | 2116184.4 | 37.7910171377023 | -122.420723832321 | (37.7910171377023, -122.420723832321) | ||
| 96545 | 96545 | 36775 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1500X Carroll Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39524 | 6014783.52216082 | 2091800.79476437 | 37.724517559949795 | -122.391032618645 | (37.7245175599498, -122.391032618645) |
| 96546 | 96546 | 26443 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1430 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6003606.97335 | 2112834.41067 | 37.7816443828524 | -122.431169066991 | (37.7816443828524, -122.431169066991) | |||
| 96547 | 96547 | 23459 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2290X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | Permit Number 769634 | 6005952.25741 | 2118257.8831700003 | 37.7966685117079 | -122.423441167528 | (37.7966685117079, -122.423441167528) | ||
| 96548 | 96548 | 40641 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 187 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | Permit Number 41639 | 6009210.87994007 | 2099144.38708889 | 37.744370680135106 | -122.410814978675 | (37.7443706801351, -122.410814978675) | |||
| 96549 | 96549 | 40312 | Permitted Site 1 | Acer macrophyllum :: Big Leaf Maple 159 | 123 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 6 | 3x3 | Permit Number 41454 | 6006197.01673983 | 2102279.01915111 | 37.752808213839295 | -122.421458875834 | (37.7528082138393, -122.421458875834) |
| 96550 | 96550 | 107116 | DPW Maintained 3 | Tree(s) :: 17 | 300X LIBERTY ST | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6004270.1 | 2103982.4 | 37.757376462852704 | -122.42824389606199 | (37.7573764628527, -122.428243896062) | ||||
| 96551 | 96551 | 33508 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37603 | 6006396.09682229 | 2098460.33665401 | 37.7423342020889 | -122.420499380726 | (37.7423342020889, -122.420499380726) | |||
| 96552 | 96552 | 36068 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1504 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39187 | 6009387.99483758 | 2107777.56202059 | 37.7680853638298 | -122.410812146882 | (37.7680853638298, -122.410812146882) | ||
| 96553 | 96553 | 80519 | Undocumented 2 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 3 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 96554 | 96554 | 100728 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 96555 | 96555 | 28490 | DPW Maintained 3 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 1499X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2003 12:00:00 AM | 12 | 3X3 | 6005277.9300739 | 2099610.0882818 | 37.7454280803333 | -122.42444742702 | (37.7454280803333, -122.42444742702) | ||
| 96556 | 96556 | 24460 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1199X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 06/22/1995 12:00:00 AM | 6 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 96557 | 96557 | 107036 | Significant Tree 6 | Tree(s) :: 17 | 350 08th St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 7x7 | Permit Number 772214 | 6009826.0 | 2110084.0 | 37.774442857676505 | -122.409459923405 | (37.7744428576765, -122.409459923405) | |||
| 96558 | 96558 | 42341 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 136 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42546 | 5998127.62508278 | 2093912.27008524 | 37.729376858931296 | -122.44876160358999 | (37.7293768589313, -122.44876160359) | ||
| 96559 | 96559 | 16227 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 564X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.280841901 | 2094738.2735002 | 37.731657141982204 | -122.44807897208 | (37.7316571419822, -122.44807897208) | ||
| 96560 | 96560 | 95339 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 855@Broadway Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767214 | 6012385.0 | 2119009.0 | 37.79909186757679 | -122.401235100386 | (37.7990918675768, -122.401235100386) |
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");