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 ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1659 | 1659 | 251643 | Undocumented 2 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007328.0 | 2121670.0 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | |||
| 154465 | 154465 | 42845 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 704 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 1 | Permit Number 42776 | 6007326.6292 | 2121624.2795 | 37.8059892616711 | -122.41892440226101 | (37.8059892616711, -122.418924402261) | |
| 168893 | 168893 | 41226 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 155 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 8 | Permit Number 41932 | 6001878.60529 | 2121714.18401 | 37.805927839759896 | -122.437784566908 | (37.8059278397599, -122.437784566908) | |
| 8730 | 8730 | 97454 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 758 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2011 12:00:00 AM | 3 | 3x3 | 6007159.12761 | 2121599.09194 | 37.805910669901294 | -122.41950228141899 | (37.8059106699013, -122.419502281419) | |
| 38554 | 38554 | 41215 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1410 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 3 | Permit Number 41923 | 6002447.416669999 | 2121634.7897 | 37.8057421711384 | -122.43581042460899 | (37.8057421711384, -122.435810424609) | |
| 186439 | 186439 | 42699 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 839 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2007 12:00:00 AM | 4 | Permit No. 49315 | 6006686.40585 | 2121480.76195 | 37.805559128512 | -122.421129804292 | (37.805559128512, -122.421129804292) | |
| 29574 | 29574 | 66047 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 465 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 9 | Permit Number 29210 | 6001137.14728 | 2121594.78406 | 37.805557811007795 | -122.44034192404399 | (37.8055578110078, -122.440341924044) | |
| 94948 | 94948 | 48593 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 901 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | Permit Number 45904 | 6006421.8774427 | 2121435.46565789 | 37.8054198406901 | -122.42204202338101 | (37.8054198406901, -122.422042023381) | ||
| 99124 | 99124 | 48594 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 901 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | Permit Number 45904 | 6006421.8774427 | 2121435.46565789 | 37.8054198406901 | -122.42204202338101 | (37.8054198406901, -122.422042023381) | ||
| 117001 | 117001 | 48592 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 901 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | Permit Number 45904 | 6006421.8774427 | 2121435.46565789 | 37.8054198406901 | -122.42204202338101 | (37.8054198406901, -122.422042023381) | ||
| 168983 | 168983 | 68254 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3835 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32056 | 6000569.04912 | 2121537.58273 | 37.8053683895105 | -122.44230379238199 | (37.8053683895105, -122.442303792382) | |
| 176628 | 176628 | 41234 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3743 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 5 | Permit Number 41939 | 6002518.8447 | 2121486.57255 | 37.805339263172606 | -122.435552627664 | (37.8053392631726, -122.435552627664) | |
| 46918 | 46918 | 41227 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 82 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 6 | Permit Number 41933 | 6001259.46454 | 2121509.87595 | 37.805331639599 | -122.43991253733401 | (37.805331639599, -122.439912537334) | |
| 182105 | 182105 | 71431 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 212 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 8 | 6010229.3071 | 2121323.3934 | 37.8053261203342 | -122.408857935135 | (37.8053261203342, -122.408857935135) | ||
| 158249 | 158249 | 65852 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 78 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1990 12:00:00 AM | 8 | Permit Number 28843 | 6001277.60379 | 2121496.88229 | 37.8052969950218 | -122.439848832065 | (37.8052969950218, -122.439848832065) | |
| 75016 | 75016 | 72192 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 81 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1990 12:00:00 AM | 12 | 6001247.5968 | 2121479.41106 | 37.805247315580004 | -122.439951421335 | (37.80524731558, -122.439951421335) | ||
| 136060 | 136060 | 71433 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 270 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 11 | 6010029.1823 | 2121294.154 | 37.805234624598704 | -122.40954843082199 | (37.8052346245987, -122.409548430822) | ||
| 41502 | 41502 | 48591 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2949 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 5 | Permit Number 45903 | 6006416.959980001 | 2121367.79971 | 37.805233769992206 | -122.422054230926 | (37.8052337699922, -122.422054230926) | |
| 35194 | 35194 | 31668 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 215#3 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 11 | Permit Number 35176 | 6010250.9256 | 2121284.082 | 37.8052193918816 | -122.408780346054 | (37.8052193918816, -122.408780346054) | |
| 158307 | 158307 | 69370 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3730 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 10 | Permit Number 33464 | 6002569.58562 | 2121440.71208 | 37.8052162242015 | -122.435373749816 | (37.8052162242015, -122.435373749816) | |
| 165685 | 165685 | 69351 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3747 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 15 | Permit Number 33442 | 6001992.91155 | 2121450.30554 | 37.8052097985611 | -122.437370085564 | (37.8052097985611, -122.437370085564) | |
| 147547 | 147547 | 48590 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2949 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 4 | Permit Number 45903 | 6006418.56669 | 2121358.85125 | 37.8052092904321 | -122.422048034602 | (37.8052092904321, -122.422048034602) | |
| 70374 | 70374 | 41233 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3725 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2014 12:00:00 AM | 3 | Permit Number 773159 | 6002526.96331 | 2121423.4126 | 37.80516630374971 | -122.435520011048 | (37.8051663037497, -122.435520011048) | |
| 174919 | 174919 | 65851 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 71 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1990 12:00:00 AM | 11 | Permit Number 28842 | 6001295.899540001 | 2121445.31789 | 37.8051564543617 | -122.4397818182 | (37.8051564543617, -122.4397818182) | |
| 49277 | 49277 | 68253 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3825 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32055 | 6000581.64191 | 2121452.9297599997 | 37.805136672889205 | -122.44225413274799 | (37.8051366728892, -122.442254132748) | |
| 64632 | 64632 | 71432 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 265 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2015 12:00:00 AM | 6 | Permit Number 774166 | 6010066.2856 | 2121257.2948 | 37.805135497346 | -122.409417426777 | (37.805135497346, -122.409417426777) | |
| 76721 | 76721 | 42842 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2934 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2002 12:00:00 AM | 9 | Permit Number 42774 | 6006475.15983 | 2121324.45799 | 37.805118047034505 | -122.421849742172 | (37.8051180470345, -122.421849742172) | |
| 75740 | 75740 | 65848 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 60 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1990 12:00:00 AM | 9 | Permit Number 28839 | 6001380.15928 | 2121427.38257 | 37.8051120044819 | -122.43948894135599 | (37.8051120044819, -122.439488941356) | |
| 137083 | 137083 | 48357 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 271 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 4 | Permit Number 46907 | 6009989.2786 | 2121248.5013 | 37.805107037626904 | -122.40968329882 | (37.8051070376269, -122.40968329882) | |
| 87943 | 87943 | 65850 | Permitted Site 1 | Tree(s) :: 17 | 67 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1990 12:00:00 AM | 9 | 3x3 | Permit Number 770220 | 6001319.42927239 | 2121416.09155385 | 37.8050775459314 | -122.439698294296 | (37.8050775459314, -122.439698294296) |
| 115588 | 115588 | 65847 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 52 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1990 12:00:00 AM | Permit Number 28838 | 6001431.74012766 | 2121400.87467521 | 37.80504215628579 | -122.439308538888 | (37.8050421562858, -122.439308538888) | ||
| 133812 | 133812 | 41231 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3710 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 7 | Permit Number 41936 | 6002578.78066 | 2121369.73196 | 37.805021853734395 | -122.435336848833 | (37.8050218537344, -122.435336848833) | |
| 171342 | 171342 | 69369 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3715 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33463 | 6002534.674819999 | 2121358.09542 | 37.804987398007704 | -122.43548864898099 | (37.8049873980077, -122.435488648981) | |
| 2368 | 2368 | 68207 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2048 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 10 | Permit Number 31989 | 6009891.7858 | 2121179.0457 | 37.80491086613029 | -122.41001577934601 | (37.8049108661303, -122.410015779346) | |
| 31612 | 31612 | 65846 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 45 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1990 12:00:00 AM | 12 | Permit Number 28837 | 6001437.53726 | 2121346.67782 | 37.804893676057205 | -122.439284590205 | (37.8048936760572, -122.439284590205) | |
| 167002 | 167002 | 65845 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 34 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 5 | Permit Number 28835 | 6001537.37252 | 2121341.98994 | 37.804886485073105 | -122.438938764018 | (37.8048864850731, -122.438938764018) | |
| 99427 | 99427 | 68208 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2060 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 12 | Permit Number 31990 | 6009900.21643537 | 2121162.10763095 | 37.804864830914205 | -122.409985407616 | (37.8048648309142, -122.409985407616) | |
| 184236 | 184236 | 65288 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 7 | Permit Number 28836 | 6001457.593230001 | 2121333.88235 | 37.8048596843835 | -122.439214266819 | (37.8048596843835, -122.439214266819) | |
| 167171 | 167171 | 41176 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1529 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 9 | Permit Number 41895 | 6002871.193109999 | 2121292.04704 | 37.8048251531279 | -122.434319365747 | (37.8048251531279, -122.434319365747) | |
| 167103 | 167103 | 41206 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3720 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 8 | Permit Number 41913 | 5999654.61261 | 2121348.57822 | 37.804797274147504 | -122.445454709292 | (37.8047972741475, -122.445454709292) | |
| 26737 | 26737 | 41177 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1555 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 3 | Permit Number 41896 | 6002761.3685800005 | 2121278.33423 | 37.804781267115104 | -122.43469844348301 | (37.8047812671151, -122.434698443483) | |
| 77695 | 77695 | 42820 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 77758 | 77758 | 42824 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 78919 | 78919 | 42827 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 82453 | 82453 | 42828 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 102378 | 102378 | 42822 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 120509 | 120509 | 42825 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 123571 | 123571 | 42821 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 126150 | 126150 | 42826 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 127386 | 127386 | 42819 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 141381 | 141381 | 42823 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 185496 | 185496 | 41216 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1920 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 7 | Permit Number 41924 | 5999991.94061 | 2121282.68763 | 37.804635607504395 | -122.444282616557 | (37.8046356075044, -122.444282616557) | |
| 56944 | 56944 | 68985 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1938 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32975 | 5999918.5445 | 2121272.0114700003 | 37.804602105955404 | -122.44453584225 | (37.8046021059554, -122.44453584225) | |
| 58258 | 58258 | 71429 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2029 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 6 | 6009865.7372 | 2121062.537 | 37.8045895022466 | -122.41009769333401 | (37.8045895022466, -122.410097693334) | ||
| 164183 | 164183 | 33100 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2257 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 6 | Permit Number 37340 | 6008897.7476 | 2121071.8248 | 37.8045607014693 | -122.41344818166901 | (37.8045607014693, -122.413448181669) | |
| 178125 | 178125 | 68986 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1990 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 18 | Permit Number 32976 | 5999758.99431 | 2121250.9256 | 37.8045351046614 | -122.44508646208999 | (37.8045351046614, -122.44508646209) | |
| 121611 | 121611 | 68984 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1921 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | Permit Number 32974 | 6000030.07373389 | 2121239.89636567 | 37.8045202897238 | -122.44414757690001 | (37.8045202897238, -122.4441475769) | ||
| 177501 | 177501 | 33099 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2257 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | Permit Number 37340 | 6008900.8507 | 2121053.982 | 37.8045118838444 | -122.413436180416 | (37.8045118838444, -122.413436180416) | |
| 53443 | 53443 | 42672 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42700 | 6008565.6692 | 2121051.5528 | 37.80448638863479 | -122.414595938174 | (37.8044863886348, -122.414595938174) | |
| 88168 | 88168 | 42673 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.804451613820206 | -122.41470920319901 | (37.8044516138202, -122.414709203199) | ||
| 101955 | 101955 | 42674 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.804451613820206 | -122.41470920319901 | (37.8044516138202, -122.414709203199) | ||
| 181660 | 181660 | 65536 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3750 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 7 | Permit Number 29012 | 6000660.38848 | 2121196.27662 | 37.804436459834 | -122.44196318856001 | (37.804436459834, -122.44196318856) | |
| 184280 | 184280 | 62154 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2016 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 12 | Permit Number 22268 | 5999531.3312099995 | 2121219.56404 | 37.804435997587206 | -122.445872051358 | (37.8044359975872, -122.445872051358) | |
| 138272 | 138272 | 62151 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2028 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | Permit Number 22265 | 5999505.15205923 | 2121219.35857774 | 37.8044339386067 | -122.445962631474 | (37.8044339386067, -122.445962631474) | ||
| 25492 | 25492 | 62153 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2022 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 10 | Permit Number 22267 | 5999519.37482 | 2121217.44002 | 37.804429482897795 | -122.44591327448 | (37.8044294828978, -122.44591327448) | |
| 32335 | 32335 | 62148 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2040 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 11 | Permit Number 22262 | 5999472.96679 | 2121211.62683 | 37.804410871434705 | -122.446073454522 | (37.8044108714347, -122.446073454522) | |
| 33062 | 33062 | 68979 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3748 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 11 | Permit Number 32969 | 6000173.53852 | 2121195.0306599997 | 37.804405283944895 | -122.443647880443 | (37.8044052839449, -122.443647880443) | |
| 144153 | 144153 | 33098 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2255 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37340 | 6008896.26792228 | 2121013.91069891 | 37.8044016007834 | -122.41344920391701 | (37.8044016007834, -122.413449203917) | ||
| 142395 | 142395 | 34251 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 945 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | Permit Number 38731 | 6006267.52442813 | 2121066.89219972 | 37.8043991257724 | -122.422549976626 | (37.8043991257724, -122.422549976626) | ||
| 158473 | 158473 | 34253 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 7 | Permit Number 38731 | 6006242.74242 | 2121059.25353 | 37.8043767538414 | -122.42263519386199 | (37.8043767538414, -122.422635193862) | |
| 93193 | 93193 | 69368 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3636 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 13 | Permit Number 33462 | 6002615.01621 | 2121133.0987299997 | 37.8043741790738 | -122.43519451581999 | (37.8043741790738, -122.43519451582) | |
| 135338 | 135338 | 34252 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38731 | 6006224.9654 | 2121058.41971 | 37.804373461439795 | -122.42269665353999 | (37.8043734614398, -122.42269665354) | |
| 52609 | 52609 | 34250 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1998 12:00:00 AM | 5 | Permit Number 38731 | 6006204.75677 | 2121056.43709 | 37.8043668775019 | -122.42276644632601 | (37.8043668775019, -122.422766446326) | |
| 127992 | 127992 | 59832 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2080 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1990 12:00:00 AM | Permit Number 19285 | 5999268.33868417 | 2121186.40779193 | 37.8043299394007 | -122.446779769241 | (37.8043299394007, -122.446779769241) | ||
| 59197 | 59197 | 65863 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3738 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1990 12:00:00 AM | 2 | Permit Number 28855 | 6000664.77895 | 2121157.36382 | 37.8043298658938 | -122.441945200307 | (37.8043298658938, -122.441945200307) | |
| 168548 | 168548 | 62150 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2033 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 11 | Permit Number 22264 | 5999463.73231 | 2121165.54346 | 37.8042838116209 | -122.44610209435699 | (37.8042838116209, -122.446102094357) | |
| 55240 | 55240 | 62149 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2037 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 10 | Permit Number 22263 | 5999450.735230001 | 2121163.3015799997 | 37.8042769138086 | -122.446146910269 | (37.8042769138086, -122.446146910269) | |
| 51017 | 51017 | 69367 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3630 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 11 | Permit Number 33461 | 6002617.53648 | 2121095.37594 | 37.8042707453542 | -122.435183094434 | (37.8042707453542, -122.435183094434) | |
| 69178 | 69178 | 41208 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 112 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 5 | Permit Number 41915 | 6001387.72145 | 2121116.10553 | 37.804257751046 | -122.439440444547 | (37.804257751046, -122.439440444547) | |
| 172225 | 172225 | 62147 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2057 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 3 | Permit Number 22261 | 5999361.52655 | 2121151.9257099996 | 37.804240583901795 | -122.44645480395599 | (37.8042405839018, -122.446454803956) | |
| 155464 | 155464 | 41179 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1768 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 8 | Permit Number 41898 | 6001615.11314 | 2121098.9248200003 | 37.8042235156744 | -122.438652307458 | (37.8042235156744, -122.438652307458) | |
| 102387 | 102387 | 62161 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2071 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | Permit Number 22276 | 5999321.04607079 | 2121141.24066237 | 37.8042089334841 | -122.44659412005501 | (37.8042089334841, -122.446594120055) | ||
| 54841 | 54841 | 68232 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 106 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32027 | 6001414.70118 | 2121097.37736 | 37.804207863862096 | -122.439345736027 | (37.8042078638621, -122.439345736027) | |
| 46269 | 46269 | 41181 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1780 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 11 | Permit Number 41899 | 6001559.95191 | 2121091.33566 | 37.8041995397404 | -122.438842652585 | (37.8041995397404, -122.438842652585) | |
| 74880 | 74880 | 41229 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 3618 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 5 | 3x3 | Permit Number 41935 | 6002621.77288 | 2121066.97203 | 37.8041929962699 | -122.435166401228 | (37.8041929962699, -122.435166401228) |
| 149267 | 149267 | 41180 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1780 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 3 | Permit Number 41899 | 6001541.153 | 2121088.1531 | 37.804189731738 | -122.43890747929701 | (37.804189731738, -122.438907479297) | |
| 117952 | 117952 | 35259 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 15 North View Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | Permit Number 38745 | 6006261.16028369 | 2120974.78404058 | 37.8041458613164 | -122.422565451189 | (37.8041458613164, -122.422565451189) | ||
| 37239 | 37239 | 41230 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 3618 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 6 | 3x3 | Permit Number 41935 | 6002625.18254 | 2121047.68706 | 37.804140238442 | -122.43515322167102 | (37.804140238442, -122.435153221671) |
| 49472 | 49472 | 41212 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 6 | Permit Number 41921 | 6002149.73701 | 2121055.69726 | 37.804135222937 | -122.43679910691002 | (37.804135222937, -122.43679910691) | |
| 143724 | 143724 | 42697 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 2502 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42714 | 6007504.11437077 | 2120942.44037002 | 37.8041270967963 | -122.41826181188999 | (37.8041270967963, -122.41826181189) | ||
| 109143 | 109143 | 65821 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3742 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/1990 12:00:00 AM | Permit Number 28810 | 6000186.46170401 | 2121090.90098935 | 37.804120108904705 | -122.443595673922 | (37.8041201089047, -122.443595673922) | ||
| 30583 | 30583 | 68237 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1775 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32032 | 6001656.99546 | 2121058.17098 | 37.8041139989306 | -122.438504449024 | (37.8041139989306, -122.438504449024) | |
| 36510 | 36510 | 41182 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1781 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 10 | Permit Number 41900 | 6001635.93315 | 2121055.7102900003 | 37.8041060444241 | -122.438577160103 | (37.8041060444241, -122.438577160103) | |
| 42096 | 42096 | 41211 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3672 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 7 | Permit Number 41920 | 6002143.7473 | 2121032.61773 | 37.8040715122401 | -122.436818181531 | (37.8040715122401, -122.436818181531) | |
| 165961 | 165961 | 41228 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3612 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 9 | 6x9 | Permit Number 41934 | 6002627.9328 | 2121021.08355 | 37.8040673483864 | -122.43514180026001 | (37.8040673483864, -122.43514180026) |
| 32276 | 32276 | 31868 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3633 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 7 | Permit Number 41912 | 5999648.6988 | 2121058.91348 | 37.804001595372604 | -122.445454333359 | (37.8040015953726, -122.445454333359) | |
| 170376 | 170376 | 65820 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3712 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/1990 12:00:00 AM | 8 | Permit Number 28809 | 6000193.05574 | 2121032.54213 | 37.803960247224204 | -122.443568660075 | (37.8039602472242, -122.443568660075) | |
| 127326 | 127326 | 108693 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950X Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.803910139733794 | -122.440613252117 | (37.8039101397338, -122.440613252117) |
| 139925 | 139925 | 108694 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950X Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.803910139733794 | -122.440613252117 | (37.8039101397338, -122.440613252117) |
| 143086 | 143086 | 108692 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950X Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.803910139733794 | -122.440613252117 | (37.8039101397338, -122.440613252117) |
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");