Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87838 | 87838 | 1360 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999260.364281501 | 2099960.847629 | 37.7460495263909 | -122.445280344305 | (37.7460495263909, -122.445280344305) | |||
| 174742 | 174742 | 97890 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5x7 | 5994268.275640001 | 2115530.11005 | 37.788512412734796 | -122.46367199178499 | (37.7885124127348, -122.463671991785) | |||
| 127234 | 127234 | 11208 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1001X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | |||
| 99031 | 99031 | 32507 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 100x OGDEN AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37009 | 6007659.0 | 2096105.0 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | ||
| 141513 | 141513 | 39210 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/1999 12:00:00 AM | Permit Number 41852 | 5998202.98711321 | 2108218.1904746 | 37.7686617185434 | -122.449531484363 | (37.7686617185434, -122.449531484363) | ||
| 110154 | 110154 | 92101 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1076 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2009 12:00:00 AM | 3x3 | Permit Number 52984 | 6005698.0 | 2102695.0 | 37.7539222521842 | -122.42321413605801 | (37.7539222521842, -122.423214136058) | ||
| 24685 | 24685 | 32723 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1082 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 12 | Permit Number 37114 | 6007012.43686 | 2114697.78275 | 37.786953139214894 | -122.419519994465 | (37.7869531392149, -122.419519994465) | |
| 145734 | 145734 | 42121 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 110 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42418 | 5999349.45513333 | 2095526.80253467 | 37.7338797805201 | -122.44465363726002 | (37.7338797805201, -122.44465363726) | ||
| 92407 | 92407 | 37521 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1112 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 3x3 | Permit Number 39974 | 6007343.449516599 | 2115114.77721986 | 37.7881167428842 | -122.41840434148199 | (37.7881167428842, -122.418404341482) | |
| 138113 | 138113 | 37523 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1112 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 10 | Permit Number 39974 | 6007334.6804 | 2115172.44683 | 37.7882745958345 | -122.41843877194599 | (37.7882745958345, -122.418438771946) | |
| 153704 | 153704 | 37522 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1112 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 9 | Permit Number 39974 | 6007335.91955 | 2115154.21819 | 37.7882246142201 | -122.418433191643 | (37.7882246142201, -122.418433191643) | |
| 102286 | 102286 | 113325 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1234 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5993019.12807809 | 2107069.22790191 | 37.76520905664 | -122.467378332531 | (37.76520905664, -122.467378332531) | |||
| 104567 | 104567 | 54684 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1234 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1992 12:00:00 AM | 14 | 3x3 | Permit Number 30565 | 5993019.12807809 | 2107069.22790191 | 37.76520905664 | -122.467378332531 | (37.76520905664, -122.467378332531) |
| 144727 | 144727 | 113324 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1234 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5993019.12807809 | 2107069.22790191 | 37.76520905664 | -122.467378332531 | (37.76520905664, -122.467378332531) | |||
| 79810 | 79810 | 68817 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 125 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2007 12:00:00 AM | Permit Number 49379 | 6000058.92001633 | 2094143.32486819 | 37.730121532663105 | -122.442101535638 | (37.7301215326631, -122.442101535638) | ||
| 178982 | 178982 | 51993 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1260 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2005 12:00:00 AM | 14 | Permit Number 48211 | 6007573.69475 | 2118185.59644 | 37.796561412322795 | -122.417825488274 | (37.7965614123228, -122.417825488274) | |
| 167098 | 167098 | 43384 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 127 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2000 12:00:00 AM | 16 | Permit Number 43132 | 5993941.8721 | 2114666.09803 | 37.7861212585447 | -122.464738521118 | (37.7861212585447, -122.464738521118) | ||
| 80819 | 80819 | 12055 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | |||
| 117183 | 117183 | 12054 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | |||
| 120398 | 120398 | 12053 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/29/1993 12:00:00 AM | 6 | 3X3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | ||
| 119632 | 119632 | 45473 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1301 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | Permit Number 44252 | 5993960.36650023 | 2094413.72258595 | 37.730514541433 | -122.463204465727 | (37.730514541433, -122.463204465727) | ||
| 78767 | 78767 | 12056 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 92477 | 92477 | 12059 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 93198 | 93198 | 12058 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 109212 | 109212 | 12062 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 110400 | 110400 | 12057 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 117052 | 117052 | 12065 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 121136 | 121136 | 12060 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 108488 | 108488 | 105973 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1336 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 771235 | 6006462.9 | 2119771.0 | 37.8008519560253 | -122.421781757787 | (37.8008519560253, -122.421781757787) | ||||
| 123804 | 123804 | 105974 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1336 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 771235 | 6006462.9 | 2119771.0 | 37.8008519560253 | -122.421781757787 | (37.8008519560253, -122.421781757787) | ||||
| 14844 | 14844 | 12128 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1400X La Salle Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016480.84106 | 2095117.09347 | 37.73371749994771 | -122.385396148429 | (37.7337174999477, -122.385396148429) | |||
| 43975 | 43975 | 43992 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 141 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | 13 | Permit Number 43551 | 6010011.61771 | 2107517.81839 | 37.7674071146631 | -122.408636765987 | (37.7674071146631, -122.408636765987) | ||
| 81989 | 81989 | 39617 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 143 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1998 12:00:00 AM | Permit Number 41017 | 5997752.15145133 | 2106762.51515119 | 37.7646390036764 | -122.45098590004999 | (37.7646390036764, -122.45098590005) | |||
| 94001 | 94001 | 43523 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1442 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43199 | 6000900.07851404 | 2110723.16086375 | 37.7756936614931 | -122.44038215551001 | (37.7756936614931, -122.44038215551) | ||
| 18999 | 18999 | 4466 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1484 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004525.42539 | 2100206.65772 | 37.747023599154204 | -122.427091952431 | (37.7470235991542, -122.427091952431) | |||
| 40488 | 40488 | 32598 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1488 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 770751 | 5985603.1005 | 2105094.5695 | 37.759356274150704 | -122.492882766578 | (37.7593562741507, -122.492882766578) | ||
| 172347 | 172347 | 32599 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1488 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 770751 | 5985602.7329 | 2105115.8853 | 37.7594147799348 | -122.492885607985 | (37.7594147799348, -122.492885607985) | ||
| 17710 | 17710 | 4470 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1500 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004528.8343 | 2100105.60966 | 37.746746337268206 | -122.42707296863999 | (37.7467463372682, -122.42707296864) | |||
| 65910 | 65910 | 38340 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1517 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2000 12:00:00 AM | 14 | Permit Number 40407 | 5982158.3822 | 2104738.8652 | 37.7581775666431 | -122.504769723467 | (37.7581775666431, -122.504769723467) | |
| 4251 | 4251 | 246122 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1518 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | Permit Number 46036 | 5998379.9097 | 2108286.3815 | 37.768859073318 | -122.448924438468 | (37.768859073318, -122.448924438468) | ||
| 21257 | 21257 | 4479 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1542 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004543.28364 | 2099929.0819200003 | 37.7462624498637 | -122.427010433384 | (37.7462624498637, -122.427010433384) | |||
| 132812 | 132812 | 64381 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1546 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1988 12:00:00 AM | 11 | Permit Number 25221 | 5982207.2717 | 2104557.9741 | 37.757683766928004 | -122.504587243143 | (37.757683766928, -122.504587243143) | ||
| 99641 | 99641 | 48625 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1548 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45922 | 5992473.51988967 | 2104913.75628044 | 37.7592591867123 | -122.46910855694901 | (37.7592591867123, -122.469108556949) | ||
| 17771 | 17771 | 16032 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 155 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5993339.50797 | 2095294.7939400002 | 37.7328979594755 | -122.465414825734 | (37.7328979594755, -122.465414825734) | |||
| 19220 | 19220 | 4482 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1551 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004606.71516 | 2099825.83197 | 37.7459825358766 | -122.426783743093 | (37.7459825358766, -122.426783743093) | |||
| 138666 | 138666 | 42670 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1575 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42698 | 6006081.025120299 | 2117910.0746573997 | 37.7957207841663 | -122.422970868865 | (37.7957207841663, -122.422970868865) | ||
| 30141 | 30141 | 42966 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 160 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 42854 | 5997814.60948514 | 2104925.35351079 | 37.75959819679839 | -122.45063741216002 | (37.7595981967984, -122.45063741216) | |||
| 82947 | 82947 | 46916 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 161 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2013 12:00:00 AM | Permit Number 769519 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.41712235805201 | (37.7377931534639, -122.417122358052) | ||
| 103843 | 103843 | 43507 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 161 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2013 12:00:00 AM | Permit Number 769519 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.41712235805201 | (37.7377931534639, -122.417122358052) | |||
| 89550 | 89550 | 52895 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1642 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 3x3 | Permit Number 48894 | 5992495.5632863 | 2104272.70590883 | 37.757500303864 | -122.468985668503 | (37.757500303864, -122.468985668503) | ||
| 90863 | 90863 | 43515 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 165 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806363999 | (37.7377879152119, -122.41706806364) | ||
| 108551 | 108551 | 43516 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 165 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806363999 | (37.7377879152119, -122.41706806364) | ||
| 118408 | 118408 | 43517 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 165 Newman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43192 | 6007354.1406378 | 2096784.95342482 | 37.7377879152119 | -122.41706806363999 | (37.7377879152119, -122.41706806364) | ||
| 175378 | 175378 | 38350 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1666 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1998 12:00:00 AM | 0 | Permit Number 40417 | 5981619.44120207 | 2103744.31851256 | 37.7554151050669 | -122.506559824318 | (37.7554151050669, -122.506559824318) | |
| 1985 | 1985 | 252841 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1763 Golden Gate Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1998 12:00:00 AM | 3x3 | Permit Number 40601 | 6001163.0 | 2111730.0 | 37.7784731541065 | -122.43954484007 | (37.7784731541065, -122.43954484007) | |||
| 93935 | 93935 | 38688 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1763 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | Permit Number 40601 | 6001154.46973963 | 2111747.51694807 | 37.7785207657155 | -122.439575605477 | (37.7785207657155, -122.439575605477) | ||
| 79414 | 79414 | 55370 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 177 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2011 12:00:00 AM | 2x3 | Permit Number 767959 | 5993373.59500695 | 2094436.22943113 | 37.7305425193622 | -122.465234638195 | (37.7305425193622, -122.465234638195) | ||
| 94433 | 94433 | 38683 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1785 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1998 12:00:00 AM | Permit Number 40599 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | |||
| 97389 | 97389 | 38684 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1785 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1998 12:00:00 AM | Permit Number 40599 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | |||
| 102771 | 102771 | 38682 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1785 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/2000 12:00:00 AM | Permit Number 41971 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | ||
| 123872 | 123872 | 38685 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1785 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1998 12:00:00 AM | Permit Number 40599 | 5999225.65056076 | 2110784.42467282 | 37.7757663950795 | -122.446178803683 | (37.7757663950795, -122.446178803683) | |||
| 94979 | 94979 | 38022 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 180 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40233 | 5992584.62016279 | 2098022.80205393 | 37.740344819144795 | -122.468223027257 | (37.7403448191448, -122.468223027257) | |||
| 98015 | 98015 | 38023 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 180 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40233 | 5992584.62016279 | 2098022.80205393 | 37.740344819144795 | -122.468223027257 | (37.7403448191448, -122.468223027257) | ||
| 48476 | 48476 | 36977 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 181 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 16 | Permit Number 39602 | 5993647.32145 | 2114324.1067 | 37.7851652576674 | -122.46573272346599 | (37.7851652576674, -122.465732723466) | |
| 76522 | 76522 | 36974 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 181 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 10 | Permit Number 39602 | 5993649.0736 | 2114306.93888 | 37.7851182205824 | -122.46572541386601 | (37.7851182205824, -122.465725413866) | |
| 137417 | 137417 | 36975 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 181 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 18 | Permit Number 39602 | 5993649.27312 | 2114287.69971 | 37.785065406576294 | -122.465723325298 | (37.7850654065763, -122.465723325298) | |
| 180448 | 180448 | 36976 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 181 07th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 13 | Permit Number 39602 | 5993648.592619999 | 2114269.68134 | 37.7850158937927 | -122.465724370025 | (37.7850158937927, -122.465724370025) | |
| 115512 | 115512 | 41136 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1890 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41875 | 5997533.67783563 | 2108867.16274176 | 37.7704053182028 | -122.451893385496 | (37.7704053182028, -122.451893385496) | ||
| 12964 | 12964 | 44723 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1946 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 13 | Permit Number 43842 | 5989432.8015 | 2102080.7043 | 37.751304216428 | -122.47941744514699 | (37.751304216428, -122.479417445147) | |
| 143938 | 143938 | 87251 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50275 | 6008259.0 | 2086838.7 | 37.7105284764145 | -122.413236372693 | (37.7105284764145, -122.413236372693) | |||
| 87641 | 87641 | 87256 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Garrison Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50279 | 6008242.3 | 2086782.6 | 37.710373499787394 | -122.413290127101 | (37.7103734997874, -122.413290127101) | |||
| 93982 | 93982 | 69756 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50279 | 6008252.26832326 | 2086801.73422247 | 37.710426598074605 | -122.41325702656601 | (37.7104265980746, -122.413257026566) | ||
| 108241 | 108241 | 87255 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Garrison Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50279 | 6008242.3 | 2086782.6 | 37.710373499787394 | -122.413290127101 | (37.7103734997874, -122.413290127101) | ||
| 132134 | 132134 | 66037 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2000 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1990 12:00:00 AM | 11 | Permit Number 29074 | 5986756.4233 | 2096936.5987 | 37.7370240595256 | -122.488294548713 | (37.7370240595256, -122.488294548713) | ||
| 27432 | 27432 | 66268 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2008 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1990 12:00:00 AM | 12 | Permit Number 29375 | 5986711.6119 | 2096941.9622 | 37.7370361716902 | -122.488449873835 | (37.7370361716902, -122.488449873835) | ||
| 171739 | 171739 | 73437 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 201 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2008 12:00:00 AM | 8 | 4x4 | Permit Number 50063 | 5992414.36096 | 2114080.94062 | 37.784426393924605 | -122.46998063366001 | (37.7844263939246, -122.46998063366) | |
| 82285 | 82285 | 50882 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2055 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47392 | 5991593.93786831 | 2101441.81632133 | 37.7496752859252 | -122.471897503797 | (37.7496752859252, -122.471897503797) | ||
| 167432 | 167432 | 105846 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 227-229 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 772678 | 6008913.98004 | 2110186.85299 | 37.774674124254 | -122.41262205766 | (37.774674124254, -122.41262205766) | ||
| 41375 | 41375 | 45055 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2311 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2011 12:00:00 AM | 1 | Permit Number 767715 | 5988234.443 | 2099548.661 | 37.7442822204704 | -122.483375858058 | (37.7442822204704, -122.483375858058) | ||
| 162693 | 162693 | 61348 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2415 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1984 12:00:00 AM | 24 | Permit Number 21253 | 6004509.78876 | 2117656.60033 | 37.7949360226241 | -122.42838955722999 | (37.7949360226241, -122.42838955723) | ||
| 157487 | 157487 | 38868 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2439 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 7 | Permit Number 40694 | 5987331.8721 | 2098675.8712 | 37.7418332004815 | -122.486432648249 | (37.7418332004815, -122.486432648249) | |
| 184713 | 184713 | 66497 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2468 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51581 | 6001708.326 | 2114654.8124 | 37.786534966555 | -122.43786789884399 | (37.786534966555, -122.437867898844) | |
| 134985 | 134985 | 49935 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2526 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 14 | Permit Number 46695 | 5988329.1563 | 2098089.6264 | 37.7402816069206 | -122.48294145156 | (37.7402816069206, -122.48294145156) | |
| 90990 | 90990 | 84960 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2616 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2007 12:00:00 AM | Permit Number 49352 | 5988993.8 | 2097500.0 | 37.7387012975774 | -122.48060025376301 | (37.7387012975774, -122.480600253763) | |||
| 11531 | 11531 | 43168 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 285 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 14 | 3x3 | Permit Number 42977 | 6005738.99154 | 2092366.96158 | 37.7255660943895 | -122.422338611837 | (37.7255660943895, -122.422338611837) |
| 13735 | 13735 | 22066 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2000 12:00:00 AM | 14 | 3X3 | 6015999.04813 | 2101774.12278 | 37.751969669865396 | -122.387526128851 | (37.7519696698654, -122.387526128851) | ||
| 105824 | 105824 | 97405 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2@Melrose Stanford Heights Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5997807.0 | 2095590.8 | 37.7339673631019 | -122.449990957178 | (37.7339673631019, -122.449990957178) | |||||
| 98607 | 98607 | 39097 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3014 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | 12 | 5x9 | Permit Number 40786 | 6008165.45158313 | 2103310.33864273 | 37.7557507733516 | -122.414724626281 | (37.7557507733516, -122.414724626281) |
| 55781 | 55781 | 115288 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3096 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5999946.68734 | 2116109.2112 | 37.7904280341715 | -122.44406725681002 | (37.7904280341715, -122.44406725681) | |||
| 177926 | 177926 | 68258 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 324 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 13 | Permit Number 32064 | 6009622.37802 | 2092856.7691 | 37.7271292968784 | -122.408948556441 | (37.7271292968784, -122.408948556441) | |
| 140922 | 140922 | 40278 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 327 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41430 | 6006777.24179017 | 2101874.53362521 | 37.751730286943996 | -122.41942365408998 | (37.751730286944, -122.41942365409) | ||
| 97152 | 97152 | 39662 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 340 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41053 | 5995802.87923545 | 2090583.42381532 | 37.7201034282275 | -122.45655778592199 | (37.7201034282275, -122.456557785922) | ||
| 89160 | 89160 | 73475 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 340 Ritch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2008 12:00:00 AM | 3x3 | Permit Number 50288 | 6014252.15043428 | 2111690.62627274 | 37.7791012985319 | -122.394261419296 | (37.7791012985319, -122.394261419296) | ||
| 91233 | 91233 | 44205 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 341 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1986 12:00:00 AM | Permit Number 43653 | 6007751.99799899 | 2097517.30165944 | 37.739821155436 | -122.415744314793 | (37.739821155436, -122.415744314793) | ||
| 80578 | 80578 | 36705 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3690x 19TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005025.9 | 2104880.3 | 37.759884620726204 | -122.425693945182 | (37.7598846207262, -122.425693945182) | ||
| 85345 | 85345 | 36703 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3690x 19TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005025.9 | 2104880.3 | 37.759884620726204 | -122.425693945182 | (37.7598846207262, -122.425693945182) | ||
| 87952 | 87952 | 111303 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3690x 19TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6005025.9 | 2104880.3 | 37.759884620726204 | -122.425693945182 | (37.7598846207262, -122.425693945182) | ||||
| 115777 | 115777 | 36704 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3690x 19TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39496 | 6005025.9 | 2104880.3 | 37.759884620726204 | -122.425693945182 | (37.7598846207262, -122.425693945182) | ||
| 95191 | 95191 | 39732 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41104 | 6004245.08369654 | 2106017.71232833 | 37.7629635309961 | -122.428475481414 | (37.7629635309961, -122.428475481414) | ||
| 109085 | 109085 | 39733 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3698 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41104 | 6004245.08369654 | 2106017.71232833 | 37.7629635309961 | -122.428475481414 | (37.7629635309961, -122.428475481414) |
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");