Data source: data.sfgov.org
This data as json, CSV (advanced)
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||||
| 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) | ||
| 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) | |||
| 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) |
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 96562 | 96562 | 95784 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2804 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767528 | 6009367.0 | 2103952.0 | 37.757580067238294 | -122.410614581161 | (37.7575800672383, -122.410614581161) | |
| 96563 | 96563 | 58596 | Permitted Site 1 | Tree(s) :: 17 | 237 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1979 12:00:00 AM | Permit Number 17797 | 5997662.333827 | 2105878.12355001 | 37.762205545901 | -122.451232767817 | (37.762205545901, -122.451232767817) | |||
| 96566 | 96566 | 52598 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 423@ FELL Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | Permit Number 48692 | 6005028.51137557 | 2110420.01312959 | 37.7750954922138 | -122.426079285457 | (37.7750954922138, -122.426079285457) | |||
| 96568 | 96568 | 60791 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 276 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | Permit Number 20465 | 5998453.93543616 | 2112227.70718861 | 37.779685173955706 | -122.44895233828001 | (37.7796851739557, -122.44895233828) | ||
| 96569 | 96569 | 36422 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 300 Montecito Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | |||
| 96571 | 96571 | 120673 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3876 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003780.8 | 2105549.3 | 37.761651098806 | -122.430047862208 | (37.761651098806, -122.430047862208) | ||||
| 96574 | 96574 | 12496 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 96575 | 96575 | 61016 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 160 Swiss Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1983 12:00:00 AM | Permit Number 20832 | 6001288.97314129 | 2096322.54651529 | 37.73617519459229 | -122.438005130092 | (37.7361751945923, -122.438005130092) | ||
| 96577 | 96577 | 39797 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1920 41st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 96579 | 96579 | 69525 | Permitted Site 1 | Tree(s) :: 17 | 331 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37671 | 6006434.40955607 | 2097930.66330617 | 37.740881996913 | -122.420329320725 | (37.740881996913, -122.420329320725) | |||
| 96580 | 96580 | 43346 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 43101 | 5987278.98724374 | 2109843.31804433 | 37.772492884784896 | -122.487435636536 | (37.7724928847849, -122.487435636536) | |||
| 96583 | 96583 | 63710 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 150 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1987 12:00:00 AM | Permit Number 24372 | 6007410.32173139 | 2100162.00836053 | 37.7470637164949 | -122.41711304002399 | (37.7470637164949, -122.417113040024) | ||
| 96585 | 96585 | 92497 | Permitted Site 1 | Tree(s) :: 17 | 2 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2009 12:00:00 AM | 3x3 | Permit Number 52870 | 6003584.0 | 2096729.0 | 37.7374214715094 | -122.43009927166901 | (37.7374214715094, -122.430099271669) | ||
| 96586 | 96586 | 44495 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 493 Oxford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43798 | 6006879.93458161 | 2091734.97887269 | 37.7238950997865 | -122.418349669114 | (37.7238950997865, -122.418349669114) | ||
| 96588 | 96588 | 49613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
| 96589 | 96589 | 61299 | Permitted Site 1 | Tree(s) :: 17 | 1827 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | Permit Number 777864 | 6004251.1107426 | 2118703.69866947 | 37.797796445538395 | -122.429359325581 | (37.7977964455384, -122.429359325581) | ||
| 96591 | 96591 | 18215 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1584 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1997 12:00:00 AM | 3 | 4X4 | 6004599.7258007005 | 2114360.9725003 | 37.78589214879229 | -122.42784342077499 | (37.7858921487923, -122.427843420775) | ||
| 96592 | 96592 | 31517 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1225 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35075 | 6011656.56027463 | 2091519.35210888 | 37.723570762838705 | -122.401822399904 | (37.7235707628387, -122.401822399904) | ||
| 96594 | 96594 | 35649 | Permitted Site 1 | Tree(s) :: 17 | 614 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1998 12:00:00 AM | Permit Number 38977 | 6004449.21597902 | 2110696.79017837 | 37.775822696232 | -122.42810292491899 | (37.775822696232, -122.428102924919) | |||
| 96596 | 96596 | 58407 | Permitted Site 1 | Tree(s) :: 17 | 639 Buena Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | Permit Number 17542 | 5999765.8 | 2107710.4 | 37.7673567328153 | -122.44408936414801 | (37.7673567328153, -122.444089364148) | |||
| 96602 | 96602 | 103819 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1100 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006925.9 | 2114751.5 | 37.787095758933894 | -122.41982320605 | (37.7870957589339, -122.41982320605) | ||
| 96605 | 96605 | 26144 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1500 Oakdale Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/22/1997 12:00:00 AM | 10 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 96606 | 96606 | 39362 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2433 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40917 | 6008235.29946712 | 2104260.15851816 | 37.7583626864034 | -122.41455027836001 | (37.7583626864034, -122.41455027836) | ||
| 96608 | 96608 | 64064 | Permitted Site 1 | Tree(s) :: 17 | 2132 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1987 12:00:00 AM | Permit Number 24824 | 5991339.02868531 | 2100896.13297433 | 37.7481622280084 | -122.472739198028 | (37.7481622280084, -122.472739198028) | |||
| 96609 | 96609 | 35463 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 430 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/1998 12:00:00 AM | Permit Number 38886 | 6007237.08907724 | 2112375.34283194 | 37.780588935594395 | -122.418577996505 | (37.7805889355944, -122.418577996505) | |||
| 96611 | 96611 | 47872 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 745 Clement St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2002 12:00:00 AM | Permit Number 45622 | 5993251.273182 | 2113455.25810423 | 37.7827567838111 | -122.46703972599701 | (37.7827567838111, -122.467039725997) | |||
| 96612 | 96612 | 64961 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 120 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774717 | 6004261.49676722 | 2097472.14872907 | 37.739500336982296 | -122.427809784477 | (37.7395003369823, -122.427809784477) | |||
| 96613 | 96613 | 48836 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3700X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46054 | 6003439.85317318 | 2121384.75473793 | 37.805111964872395 | -122.43235808435 | (37.8051119648724, -122.43235808435) | |||
| 96616 | 96616 | 32176 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 171 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35513 | 5984396.34237134 | 2094161.85808413 | 37.7292673830802 | -122.496249618321 | (37.7292673830802, -122.496249618321) | ||
| 96617 | 96617 | 1732 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
| 96618 | 96618 | 4540 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 66 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1997 12:00:00 AM | 3 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | ||
| 96619 | 96619 | 2639 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1909 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6004357.24991 | 2114951.14345 | 37.787498890276396 | -122.42872440700899 | (37.7874988902764, -122.428724407009) | |||
| 96620 | 96620 | 56888 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 379 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | Permit Number 30734 | 6003470.66871359 | 2108600.18569561 | 37.7700105227729 | -122.431338270509 | (37.7700105227729, -122.431338270509) | ||
| 96621 | 96621 | 17118 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1907 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5997842.841030001 | 2109183.73864 | 37.771292257165896 | -122.4508468245 | (37.7712922571659, -122.4508468245) | |||
| 96622 | 96622 | 65339 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 191 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | Permit Number 28170 | 6001579.20108018 | 2095147.68073524 | 37.7329657853341 | -122.43691761276101 | (37.7329657853341, -122.436917612761) | ||
| 96623 | 96623 | 106177 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 96625 | 96625 | 93062 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2.5x2.5 | Tree 4 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | ||
| 96626 | 96626 | 41567 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 415 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2000 12:00:00 AM | Permit Number 42082 | 5990887.69242211 | 2112576.88642712 | 37.780208308315295 | -122.47515248865801 | (37.7802083083153, -122.475152488658) |
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");