Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 158723 | 158723 | 124414 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 100 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 5996072.31903 | 2115814.16927 | 37.7893961490256 | -122.457450879091 | (37.7893961490256, -122.457450879091) | |||
| 186069 | 186069 | 221885 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 100 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008227.02437 | 2099369.6170200002 | 37.7449338966774 | -122.41423288825399 | (37.7449338966774, -122.414232888254) | |||
| 163511 | 163511 | 139915 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1000 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004816.1035 | 2112332.8828 | 37.780335755758706 | -122.426950318013 | (37.7803357557587, -122.426950318013) | |||
| 171646 | 171646 | 139917 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1000 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6004809.1682 | 2112368.8803 | 37.7804342038606 | -122.426976875009 | (37.7804342038606, -122.426976875009) | |||
| 180264 | 180264 | 139916 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1000 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004814.4523 | 2112350.3862 | 37.780383722411706 | -122.42695727726101 | (37.7803837224117, -122.426957277261) | |||
| 40674 | 40674 | 124538 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1001 Balboa St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5992462.99268 | 2111339.00328 | 37.776900593517205 | -122.469612710685 | (37.7769005935172, -122.469612710685) | |||
| 40716 | 40716 | 124539 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1001 Balboa St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5992452.39614 | 2111338.25505 | 37.7768979266396 | -122.46964931253001 | (37.7768979266396, -122.46964931253) | |||
| 60962 | 60962 | 124537 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1001 Balboa St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5992475.11566 | 2111339.64129 | 37.7769030459693 | -122.46957082043801 | (37.7769030459693, -122.469570820438) | |||
| 154198 | 154198 | 124540 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1001 Balboa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5992434.911169999 | 2111337.17059 | 37.7768939384148 | -122.46970971884899 | (37.7768939384148, -122.469709718849) | |||
| 184703 | 184703 | 66782 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1001 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 14 | Permit Number 30052 | 6006921.4512 | 2120474.40868 | 37.802809186066604 | -122.420244926256 | (37.8028091860666, -122.420244926256) | |
| 72675 | 72675 | 91464 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1001 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52106 | 6008023.92041 | 2119932.4105700003 | 37.801383054633796 | -122.416391395149 | (37.8013830546338, -122.416391395149) | |
| 140562 | 140562 | 91465 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1001 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52106 | 6008039.0019 | 2119934.2418 | 37.8013889308135 | -122.416339336112 | (37.8013889308135, -122.416339336112) | |
| 185809 | 185809 | 91462 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1001 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52106 | 6007994.73789 | 2119928.92262 | 37.801371836504295 | -122.41649213272899 | (37.8013718365043, -122.416492132729) | |
| 188811 | 188811 | 91463 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1001 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52106 | 6008009.62404 | 2119930.75783 | 37.8013777126716 | -122.416440749956 | (37.8013777126716, -122.416440749956) | |
| 32779 | 32779 | 67371 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1009 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | 17 | Permit Number 30864 | 5992480.35304 | 2110659.61111 | 37.7750361697588 | -122.469503188985 | (37.7750361697588, -122.469503188985) | |
| 156120 | 156120 | 221935 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 102 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6004836.87593 | 2097581.93653 | 37.7398343216046 | -122.42582818552299 | (37.7398343216046, -122.425828185523) | |||
| 142759 | 142759 | 73831 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 102 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 19 | 6010808.25129 | 2088026.1904400003 | 37.713931877121 | -122.404509096323 | (37.713931877121, -122.404509096323) | ||
| 42022 | 42022 | 221917 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1033 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003826.31981 | 2102255.52555 | 37.7526097533439 | -122.429655503209 | (37.7526097533439, -122.429655503209) | |||
| 155435 | 155435 | 68456 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 107 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | 25 | Permit Number 32318 | 5991466.74972 | 2114692.7979200003 | 37.7860515606903 | -122.47330365010401 | (37.7860515606903, -122.473303650104) | |
| 155229 | 155229 | 125546 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1070 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6007858.97154 | 2118915.83985 | 37.798582528908 | -122.41689012857599 | (37.798582528908, -122.416890128576) | |||
| 65242 | 65242 | 221828 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1070 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6008613.25764 | 2102303.67809 | 37.7530118609308 | -122.413104786776 | (37.7530118609308, -122.413104786776) | |||
| 53079 | 53079 | 221837 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 109 Bartlett St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6006703.42014 | 2103074.3868400003 | 37.755020650507795 | -122.41976406777599 | (37.7550206505078, -122.419764067776) | |||
| 104571 | 104571 | 81299 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 109 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 12 | 3x3 | Permit Number 50541 | 6006708.25661782 | 2103139.88479614 | 37.755200765272704 | -122.419751988993 | (37.7552007652727, -122.419751988993) | |
| 31047 | 31047 | 38227 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1099 Mississippi St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 14 | Permit Number 40351 | 6014264.01456 | 2102105.05687 | 37.7527820922208 | -122.39354933016199 | (37.7527820922208, -122.393549330162) | ||
| 155330 | 155330 | 38225 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1099 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 13 | Permit Number 40351 | 6014263.22127 | 2102058.4146 | 37.7526539784223 | -122.39354880945 | (37.7526539784223, -122.39354880945) | ||
| 33188 | 33188 | 247526 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1101 Waller St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6000042.11565 | 2108480.23517 | 37.76948626629979 | -122.44318892675 | (37.7694862662998, -122.44318892675) | ||||
| 128249 | 128249 | 109405 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 112 ORTEGA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 775093 | 5993662.3 | 2102610.6 | 37.753003931617705 | -122.46482995514 | (37.7530039316177, -122.46482995514) | ||
| 53664 | 53664 | 203513 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 112 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5993653.12973 | 2102595.20165 | 37.7529611229783 | -122.464860549271 | (37.7529611229783, -122.464860549271) | |||
| 168675 | 168675 | 221811 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 115 Clifford Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999522.48156 | 2106496.55689 | 37.764009940030206 | -122.444843701773 | (37.7640099400302, -122.444843701773) | |||
| 55095 | 55095 | 221838 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004035.0330300005 | 2095100.1710299999 | 37.732974610471395 | -122.42842377735 | (37.7329746104714, -122.42842377735) | |||
| 84363 | 84363 | 94666 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53803 | 6004020.0 | 2095225.0 | 37.7333165119994 | -122.428484644893 | (37.7333165119994, -122.428484644893) | |
| 31428 | 31428 | 221908 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1175 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6003228.296569999 | 2101452.81084 | 37.750371807525504 | -122.431666264992 | (37.7503718075255, -122.431666264992) | |||
| 34380 | 34380 | 221910 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1175 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6003225.80615 | 2101486.76003 | 37.750464882852604 | -122.43167730058599 | (37.7504648828526, -122.431677300586) | |||
| 51371 | 51371 | 221911 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1175 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 5ft | 6003226.50292 | 2101503.3413 | 37.750510450614705 | -122.431676074804 | (37.7505104506147, -122.431676074804) | |||
| 71715 | 71715 | 221909 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1175 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 5ft | 6003227.24309 | 2101470.4878 | 37.750420284586205 | -122.43167116991002 | (37.7504202845862, -122.43167116991) | |||
| 49463 | 49463 | 221803 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 118 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6005068.887630001 | 2098748.30494 | 37.743050013041 | -122.42510895543 | (37.743050013041, -122.42510895543) | |||
| 121902 | 121902 | 64259 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 118 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1988 12:00:00 AM | Permit Number 25060 | 6005164.43101867 | 2098756.56789098 | 37.7430780980429 | -122.42477917968701 | (37.7430780980429, -122.424779179687) | ||
| 55437 | 55437 | 203580 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 5999938.98985 | 2094086.49898 | 37.7299586665457 | -122.442512069977 | (37.7299586665457, -122.442512069977) | |||
| 91622 | 91622 | 68831 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32782 | 5999950.39080564 | 2094093.84509942 | 37.729979487143 | -122.442473182831 | (37.729979487143, -122.442473182831) | ||
| 83680 | 83680 | 67285 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 119 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1992 12:00:00 AM | Permit Number 30761 | 6004716.66423484 | 2092675.63660854 | 37.726355926218204 | -122.425894675863 | (37.7263559262182, -122.425894675863) | ||
| 48862 | 48862 | 203590 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999238.54402 | 2093513.75556 | 37.728346095777205 | -122.444892431558 | (37.7283460957772, -122.444892431558) | |||
| 87275 | 87275 | 67908 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31611 | 5999270.9302444 | 2093516.90049213 | 37.728356579287706 | -122.44478069728001 | (37.7283565792877, -122.44478069728) | ||
| 112433 | 112433 | 97220 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 120 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 776182 | 5993132.0 | 2101212.0 | 37.749133146159004 | -122.466562169914 | (37.749133146159, -122.466562169914) | |||
| 139160 | 139160 | 83799 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1200 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 3x3 | Permit Number 53146 | 5982135.42302083 | 2106787.40938389 | 37.7638009337056 | -122.505000931873 | (37.7638009337056, -122.505000931873) | ||
| 181485 | 181485 | 203514 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1206 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5993631.784969999 | 2107236.32673 | 37.765703215944704 | -122.465271454925 | (37.7657032159447, -122.465271454925) | |||
| 183737 | 183737 | 83800 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1206 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50158 | 5982131.5385 | 2106862.8908 | 37.764007955481 | -122.505019961028 | (37.764007955481, -122.505019961028) | |
| 144631 | 144631 | 94833 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1208 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53910 | 5993657.5 | 2107252.8 | 37.7657499301273 | -122.46518370955499 | (37.7657499301273, -122.465183709555) | |
| 71728 | 71728 | 221886 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 121 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006322.71195 | 2097511.22057 | 37.7397240062552 | -122.420685761336 | (37.7397240062552, -122.420685761336) | |||
| 126028 | 126028 | 64302 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 121 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1988 12:00:00 AM | Permit Number 25113 | 6005123.1483335 | 2099287.66798911 | 37.7445340460317 | -122.42495970266 | (37.7445340460317, -122.42495970266) | ||
| 104325 | 104325 | 94832 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1212 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993646.6 | 2107243.8 | 37.7657245899289 | -122.46522075623301 | (37.7657245899289, -122.465220756233) | ||||
| 35991 | 35991 | 221810 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1214 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998223.78162 | 2106145.0747700003 | 37.762970657401205 | -122.44931017573299 | (37.7629706574012, -122.449310175733) | |||
| 117619 | 117619 | 55230 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1214 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2015 12:00:00 AM | 3 | Permit Number 774077 | 5998221.35114249 | 2106191.93019124 | 37.763099171561706 | -122.44932195790199 | (37.7630991715617, -122.449321957902) | |
| 113053 | 113053 | 109068 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1216 COLE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774077 | 5998287.0 | 2106143.6 | 37.762970223958 | -122.44909141982299 | (37.762970223958, -122.449091419823) | |
| 62373 | 62373 | 221809 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1216 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998224.25103 | 2106127.66613 | 37.762922884510104 | -122.449307297897 | (37.7629228845101, -122.449307297897) | |||
| 176064 | 176064 | 221907 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1217 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003244.02772 | 2101149.87665 | 37.749540913080104 | -122.431590240821 | (37.7495409130801, -122.431590240821) | |||
| 151439 | 151439 | 83915 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1218 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50159 | 5982131.5385 | 2106775.0727 | 37.763766832166 | -122.505013452733 | (37.763766832166, -122.505013452733) | |
| 62848 | 62848 | 203505 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1219 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991724.86879 | 2107100.15924 | 37.7652191828301 | -122.471857076945 | (37.7652191828301, -122.471857076945) | |||
| 143625 | 143625 | 114881 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6004593.0 | 2095924.0 | 37.7352682180932 | -122.42655338079099 | (37.7352682180932, -122.426553380791) | |||
| 75174 | 75174 | 203585 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5999428.77785 | 2093578.76175 | 37.7285354426355 | -122.444239456297 | (37.7285354426355, -122.444239456297) | |||
| 139191 | 139191 | 68818 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32765 | 5999442.86322085 | 2093551.99082798 | 37.7284627395009 | -122.44418883965099 | (37.7284627395009, -122.444188839651) | ||
| 65101 | 65101 | 124329 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 122 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995931.07902 | 2113567.14983 | 37.783218323159794 | -122.457776888478 | (37.7832183231598, -122.457776888478) | |||
| 100535 | 100535 | 108501 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1221 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773645 | 5991730.30424 | 2107117.25477 | 37.7652664370978 | -122.471839523232 | (37.7652664370978, -122.471839523232) |
| 4866 | 4866 | 253703 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1221 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998953.0 | 2105574.0 | 37.7614443133046 | -122.44674697738199 | (37.7614443133046, -122.446746977382) | ||||
| 70596 | 70596 | 203562 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1231 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5992350.0078300005 | 2107041.6701599997 | 37.765094739142704 | -122.469690631732 | (37.7650947391427, -122.469690631732) | |||
| 158703 | 158703 | 221787 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 124 27th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 8ft | 6005680.59891 | 2100245.5882599996 | 37.747195749186794 | -122.42310022339399 | (37.7471957491868, -122.423100223394) | |||
| 66407 | 66407 | 221843 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 124 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 2ft | 6004594.79724 | 2095953.61848 | 37.735349645373894 | -122.426549275423 | (37.7353496453739, -122.426549275423) | |||
| 121047 | 121047 | 109153 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 124 LILY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x2 | 6005951.6 | 2110200.9 | 37.7745459888588 | -122.422870538078 | (37.7745459888588, -122.422870538078) | |||
| 9773 | 9773 | 114349 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1240 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x15 | Permit Number 777354 | 5981849.8 | 2106648.5 | 37.7634027199113 | -122.50597849798001 | (37.7634027199113, -122.50597849798) | ||
| 51781 | 51781 | 37529 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1244 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007263.391419999 | 2115650.05703 | 37.789581982560705 | -122.41871930464701 | (37.7895819825607, -122.418719304647) | |
| 56768 | 56768 | 37527 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1244 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 19 | Permit Number 39976 | 6007268.1881 | 2115618.13797 | 37.7894946107457 | -122.41870044408199 | (37.7894946107457, -122.418700444082) | |
| 137710 | 137710 | 37528 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1244 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007265.87204 | 2115633.5342599996 | 37.789536754768 | -122.41870954971901 | (37.789536754768, -122.418709549719) | |
| 166331 | 166331 | 183265 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1249 46th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5981784.0294 | 2106586.8909 | 37.7632296873576 | -122.50620140465901 | (37.7632296873576, -122.506201404659) | |||
| 128213 | 128213 | 66317 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 125 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29434 | 6001244.97910985 | 2094913.4211356998 | 37.732303560745 | -122.43805632811899 | (37.732303560745, -122.438056328119) | ||
| 85108 | 85108 | 115172 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1255 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775163 | 5982077.3 | 2106555.6 | 37.7631610318136 | -122.505184777155 | (37.7631610318136, -122.505184777155) | |||
| 84491 | 84491 | 32893 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1262 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774785 | 5993955.18913569 | 2106899.23772087 | 37.764796302786 | -122.46412840547899 | (37.764796302786, -122.464128405479) | |
| 31679 | 31679 | 181649 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1265 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5986124.6924 | 2106639.2388 | 37.763627996398796 | -122.491192553457 | (37.7636279963988, -122.491192553457) | |||
| 174548 | 174548 | 181650 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1265 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5986125.2828 | 2106621.5286 | 37.763579403609796 | -122.49118920801 | (37.7635794036098, -122.49118920801) | |||
| 88960 | 88960 | 67941 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 127 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31655 | 6004179.48175958 | 2095714.01541041 | 37.734668261802504 | -122.427968106929 | (37.7346682618025, -122.427968106929) | ||
| 67664 | 67664 | 221844 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 127 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6004153.19016 | 2095736.3108599999 | 37.73472799260821 | -122.428060594226 | (37.7347279926082, -122.428060594226) | |||
| 69963 | 69963 | 64114 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1270 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1987 12:00:00 AM | Permit Number 24882 | 5992718.32165221 | 2106821.08244246 | 37.764510344589894 | -122.46840068588101 | (37.7645103445899, -122.468400685881) | ||
| 123536 | 123536 | 114809 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1271 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | Permit Number 775836 | 5987972.1 | 2106659.4 | 37.763791122625 | -122.48480450813801 | (37.763791122625, -122.484804508138) | |||
| 95475 | 95475 | 64103 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1274 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1987 12:00:00 AM | Permit Number 24869 | 5992719.22945305 | 2106794.6949286 | 37.7644379438855 | -122.468395626163 | (37.7644379438855, -122.468395626163) | ||
| 185176 | 185176 | 183675 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1274 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984003.8455 | 2106504.9034 | 37.7631350020634 | -122.498517860637 | (37.7631350020634, -122.498517860637) | |||
| 36004 | 36004 | 203502 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1277 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990781.19981 | 2106711.0066299997 | 37.7640960267437 | -122.47509255800301 | (37.7640960267437, -122.475092558003) | |||
| 82393 | 82393 | 108910 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) |
| 131011 | 131011 | 221822 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007356.42456 | 2097004.67982 | 37.7383913638823 | -122.417075731561 | (37.7383913638823, -122.417075731561) | |||
| 33741 | 33741 | 38113 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1296 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 9 | Permit Number 40278 | 5987108.7979 | 2106493.9222 | 37.7632864483052 | -122.48777820863701 | (37.7632864483052, -122.487778208637) | |
| 183224 | 183224 | 38114 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1296 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 7 | Permit Number 40278 | 5987111.1601 | 2106473.2531 | 37.7632298344396 | -122.487768520051 | (37.7632298344396, -122.487768520051) | |
| 75371 | 75371 | 70397 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 130 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 21 | 6006350.25387 | 2093285.0007900002 | 37.7281212922586 | -122.420290654116 | (37.7281212922586, -122.420290654116) | ||
| 43081 | 43081 | 123202 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1310 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5993110.48216 | 2112011.5710299998 | 37.7787846837447 | -122.467421785255 | (37.7787846837447, -122.467421785255) | |||
| 134473 | 134473 | 123201 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1310 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5993108.251019999 | 2112027.19449 | 37.7788274527304 | -122.46743063997499 | (37.7788274527304, -122.467430639975) | |||
| 148517 | 148517 | 83832 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1311 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50170 | 5981489.3468 | 2106129.5123 | 37.761956505057604 | -122.50718666286899 | (37.7619565050576, -122.507186662869) | |
| 144381 | 144381 | 98032 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 132 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995145.0 | 2113574.0 | 37.783191941507 | -122.460496884135 | (37.783191941507, -122.460496884135) | ||||
| 103908 | 103908 | 109191 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1340 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773400 | 5981564.2 | 2105932.0 | 37.761418601404294 | -122.506913128145 | (37.7614186014043, -122.506913128145) |
| 70461 | 70461 | 203503 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1347 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5991430.943580001 | 2106235.13725 | 37.7628270518373 | -122.47281060475099 | (37.7628270518373, -122.472810604751) | |||
| 105306 | 105306 | 108505 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1347 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773650 | 5991435.09722 | 2106251.4139099997 | 37.7628719836646 | -122.472797425789 | (37.7628719836646, -122.472797425789) |
| 115761 | 115761 | 114784 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1350 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | Permit Number 773262 | 6000262.8 | 2113654.9 | 37.7837071608561 | -122.44279721991501 | (37.7837071608561, -122.442797219915) | |||
| 50652 | 50652 | 221805 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1350 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003874.144859999 | 2100377.76702 | 37.747456575074395 | -122.429356224108 | (37.7474565750744, -122.429356224108) | |||
| 168490 | 168490 | 221806 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1350 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003875.18729 | 2100363.84416 | 37.747418405153496 | -122.429351626769 | (37.7474184051535, -122.429351626769) | |||
| 102691 | 102691 | 115201 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1352 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 775318 | 6003856.3 | 2100365.8 | 37.747422706117 | -122.429417077187 | (37.747422706117, -122.429417077187) |
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");