Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12409 | 12409 | 115759 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1718 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998106.99194 | 2088701.9387700001 | 37.7150693216746 | -122.448457855865 | (37.7150693216746, -122.448457855865) | ||
| 12488 | 12488 | 108566 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 627 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772549 | 6010648.7747599995 | 2091709.2722900002 | 37.7240359509768 | -122.405319522179 | (37.7240359509768, -122.405319522179) |
| 14129 | 14129 | 94615 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1700X Bancroft Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 6 | Permit Number 53777 | 6013900.00533 | 2092534.6262599998 | 37.7264834469268 | -122.39413819274598 | (37.7264834469268, -122.394138192746) | ||
| 15008 | 15008 | 108726 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 460 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773097 | 6011176.24234 | 2106141.01313 | 37.7636918767911 | -122.404511540684 | (37.7636918767911, -122.404511540684) |
| 15919 | 15919 | 96192 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1634 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x6 | 6015129.8118 | 2097200.08447 | 37.739362129854605 | -122.390212570161 | (37.7393621298546, -122.390212570161) | |||
| 23384 | 23384 | 121977 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5991207.54931 | 2113971.26516 | 37.78405542008421 | -122.474147738612 | (37.7840554200842, -122.474147738612) | |||
| 24906 | 24906 | 203601 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 601 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5995029.86532 | 2089100.67816 | 37.7159877489258 | -122.459122505898 | (37.7159877489258, -122.459122505898) | |||
| 27926 | 27926 | 221945 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 689 Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007717.88408 | 2096150.9798 | 37.7360676182281 | -122.415765545245 | (37.7360676182281, -122.415765545245) | |||
| 29620 | 29620 | 221957 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 132 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009113.0703300005 | 2096713.66347 | 37.737690959264704 | -122.41098153418301 | (37.7376909592647, -122.410981534183) | |||
| 29982 | 29982 | 203614 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2555 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991713.8644900005 | 2098047.40615 | 37.7403620464585 | -122.47123551863001 | (37.7403620464585, -122.47123551863) | |||
| 31315 | 31315 | 221967 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 448 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003863.12438 | 2096025.37276 | 37.7355052757557 | -122.429084054179 | (37.7355052757557, -122.429084054179) | |||
| 35336 | 35336 | 175226 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1150 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6001420.49828 | 2087082.59126 | 37.7108118474628 | -122.43688912273998 | (37.7108118474628, -122.43688912274) | |||
| 38067 | 38067 | 221962 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 28 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005742.72785 | 2097519.53479 | 37.7397141298992 | -122.42269169289301 | (37.7397141298992, -122.422691692893) | |||
| 43981 | 43981 | 175221 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 127 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001956.44701 | 2093481.30015 | 37.728411719313996 | -122.435494211294 | (37.728411719314, -122.435494211294) | |||
| 44675 | 44675 | 125559 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 20 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001981.60949 | 2119919.32974 | 37.8010055012508 | -122.43729950587799 | (37.8010055012508, -122.437299505878) | |||
| 45300 | 45300 | 221964 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 3783 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003249.85667 | 2102987.38047 | 37.7545865954194 | -122.431701259406 | (37.7545865954194, -122.431701259406) | |||
| 47069 | 47069 | 175223 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 39 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002350.25908 | 2087113.68805 | 37.7109500327891 | -122.433677880228 | (37.7109500327891, -122.433677880228) | |||
| 47896 | 47896 | 203593 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 362 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5997967.6638400005 | 2098207.91651 | 37.7411625285389 | -122.449624019335 | (37.7411625285389, -122.449624019335) | |||
| 49771 | 49771 | 203594 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 362 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5997974.50347 | 2098199.84414 | 37.741140755053394 | -122.44959978891501 | (37.7411407550534, -122.449599788915) | |||
| 50613 | 50613 | 221961 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007321.68387 | 2099648.65051 | 37.745649164396 | -122.417383168412 | (37.745649164396, -122.417383168412) | |||
| 50794 | 50794 | 123228 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 790 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 5993224.042169999 | 2110104.87798 | 37.7735559729611 | -122.46689029165199 | (37.7735559729611, -122.466890291652) | |||
| 52111 | 52111 | 203610 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 146 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992962.70532 | 2101209.82571 | 37.7491174052506 | -122.467147429924 | (37.7491174052506, -122.467147429924) | |||
| 53242 | 53242 | 36575 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2959 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | Permit Number 773747 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | |
| 54406 | 54406 | 221941 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 6 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007387.61833 | 2099831.21968 | 37.7461541678748 | -122.417168110835 | (37.7461541678748, -122.417168110835) | |||
| 54748 | 54748 | 221949 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 130 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005733.16344 | 2096370.9347599999 | 37.7365597919858 | -122.422643161851 | (37.7365597919858, -122.422643161851) | |||
| 55362 | 55362 | 221956 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 126 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009115.60345 | 2096745.48812 | 37.7377784848985 | -122.41097502309601 | (37.7377784848985, -122.410975023096) | |||
| 58877 | 58877 | 221959 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 40 Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006917.95307 | 2099525.2176200002 | 37.7452875218149 | -122.41877045990499 | (37.7452875218149, -122.418770459905) | |||
| 70699 | 70699 | 203595 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 423 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5997934.90621 | 2094082.1225 | 37.729832211087 | -122.44944008101999 | (37.729832211087, -122.44944008102) | |||
| 71517 | 71517 | 109072 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1570 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769406 | 5992498.7 | 2104770.7 | 37.758867846563795 | -122.469011061686 | (37.7588678465638, -122.469011061686) |
| 72338 | 72338 | 123393 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 667 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5995006.92654 | 2111007.28114 | 37.7761364727826 | -122.460788484161 | (37.7761364727826, -122.460788484161) | |||
| 76641 | 76641 | 47443 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 651 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 6 | Permit Number 45354 | 5982552.26402 | 2111341.47096 | 37.776329586414796 | -122.503896547887 | (37.7763295864148, -122.503896547887) | |
| 79874 | 79874 | 115385 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 375 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776680 | 6007256.8 | 2096298.8 | 37.7364475687434 | -122.41737017570298 | (37.7364475687434, -122.417370175703) | ||
| 82748 | 82748 | 117377 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 3783 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 775394 | 6003225.8 | 2102971.4 | 37.754541353189204 | -122.43178331278 | (37.7545413531892, -122.43178331278) | ||
| 85328 | 85328 | 121643 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 362 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x4 | 5997955.0 | 2098188.0 | 37.741107118117 | -122.449666371295 | (37.741107118117, -122.449666371295) | ||||
| 85695 | 85695 | 117322 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 590 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778502 | 5984157.3 | 2111842.1 | 37.77779841707871 | -122.49838135403 | (37.7777984170787, -122.49838135403) | ||
| 93094 | 93094 | 101004 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2801X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2012 12:00:00 AM | 3x3 | Permit Number 769246 | 6003500.6 | 2117942.3 | 37.795663322696704 | -122.43190190430201 | (37.7956633226967, -122.431901904302) | ||
| 96731 | 96731 | 187967 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1551 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015595.88641 | 2096776.8147900002 | 37.73822575820571 | -122.38857153857 | (37.7382257582057, -122.38857153857) | |||
| 103001 | 103001 | 114970 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200X MINERVA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5994532.0 | 2089023.0 | 37.7157458289959 | -122.460837724068 | (37.7157458289959, -122.460837724068) | |||
| 105615 | 105615 | 36540 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 3780 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 768357 | 6008402.05844785 | 2097287.64414787 | 37.7392270883895 | -122.41348043394899 | (37.7392270883895, -122.413480433949) | ||
| 106440 | 106440 | 114968 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200X MINERVA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5994532.0 | 2089023.0 | 37.7157458289959 | -122.460837724068 | (37.7157458289959, -122.460837724068) | |||
| 107231 | 107231 | 93572 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 757 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2010 12:00:00 AM | 14 | Permit Number 53252 | 5994718.18671 | 2110428.47346 | 37.7745306031117 | -122.46174532831002 | (37.7745306031117, -122.46174532831) | ||
| 110414 | 110414 | 90809 | DPW Maintained 3 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 3351X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2015 11:05:00 AM | 3 | 3x3 | 5985151.309330001 | 2110394.17837 | 37.77388107713121 | -122.494835999778 | (37.7738810771312, -122.494835999778) | ||
| 112531 | 112531 | 115208 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1014 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 774282 | 6001957.4 | 2112096.8 | 37.77952547459579 | -122.436822979652 | (37.7795254745958, -122.436822979652) | |||
| 114574 | 114574 | 117306 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 732 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778516 | 5981405.4 | 2110730.6 | 37.7745848102238 | -122.507818456039 | (37.7745848102238, -122.507818456039) | ||
| 117203 | 117203 | 89148 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 5530 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51801 | 5990364.38578 | 2114085.53443 | 37.7843202921023 | -122.47707310075 | (37.7843202921023, -122.47707310075) | |
| 118438 | 118438 | 115207 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1014 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 774282 | 6001957.4 | 2112096.8 | 37.77952547459579 | -122.436822979652 | (37.7795254745958, -122.436822979652) | |||
| 118943 | 118943 | 115333 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 667 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 776458 | 5994991.0 | 2111007.6 | 37.7761364319113 | -122.460843601074 | (37.7761364319113, -122.460843601074) | ||
| 120094 | 120094 | 123429 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 690 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5995057.91765 | 2110847.9262900003 | 37.7757018603334 | -122.460600543143 | (37.7757018603334, -122.460600543143) | |||
| 121037 | 121037 | 114971 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 431 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 771835 | 5997422.4 | 2094904.1 | 37.7320598346121 | -122.45127112251998 | (37.7320598346121, -122.45127112252) | |||
| 125614 | 125614 | 109897 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1734 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775111 | 5987546.7 | 2103468.6 | 37.75500527135279 | -122.486041582178 | (37.7550052713528, -122.486041582178) |
| 125904 | 125904 | 36574 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2959 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | Permit Number 773747 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | |
| 127347 | 127347 | 117307 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 714 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778519 | 5981710.1 | 2110853.1 | 37.7749391065248 | -122.506773545049 | (37.7749391065248, -122.506773545049) | ||
| 128358 | 128358 | 113268 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1034 Hollister Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 774686 | 6014704.8 | 2089850.3 | 37.7191575187873 | -122.391168478676 | (37.7191575187873, -122.391168478676) | |||
| 129695 | 129695 | 221943 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 237 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006873.22599 | 2096639.71242 | 37.737362050226395 | -122.41872052504401 | (37.7373620502264, -122.418720525044) | |||
| 130779 | 130779 | 203598 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995008.49221 | 2089033.0248099999 | 37.715800760085 | -122.459191484793 | (37.715800760085, -122.459191484793) | |||
| 131580 | 131580 | 175220 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 178 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6000035.73488 | 2087742.43428 | 37.7125448266481 | -122.441722494022 | (37.7125448266481, -122.441722494022) | |||
| 133951 | 133951 | 221946 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 689 Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007705.60833 | 2096151.45352 | 37.7360682288544 | -122.415808021131 | (37.7360682288544, -122.415808021131) | |||
| 134698 | 134698 | 221960 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 75 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006819.46923 | 2099263.44478 | 37.744563206943795 | -122.41909243697799 | (37.7445632069438, -122.419092436978) | |||
| 134805 | 134805 | 121976 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5991206.08725 | 2113988.74508 | 37.7841033304005 | -122.474154072624 | (37.7841033304005, -122.474154072624) | |||
| 135119 | 135119 | 175224 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 762 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002402.88459 | 2087125.99028 | 37.710986797965 | -122.43349687280899 | (37.710986797965, -122.433496872809) | |||
| 137427 | 137427 | 118234 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 590 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5984132.17313 | 2111832.6704599997 | 37.7777710528241 | -122.498467578545 | (37.7777710528241, -122.498467578545) | |||
| 137574 | 137574 | 203600 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200 Minerva St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994977.66041 | 2089033.8898200002 | 37.7158013626108 | -122.45929811561399 | (37.7158013626108, -122.459298115614) | |||
| 138740 | 138740 | 69064 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1359 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | Permit Number 773642 | 5992377.26935607 | 2106205.46978928 | 37.7628003299421 | -122.469535465436 | (37.7628003299421, -122.469535465436) | |
| 140457 | 140457 | 108526 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1677 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773677 | 5990566.2613699995 | 2103985.48594 | 37.7566000147891 | -122.47563692717699 | (37.7566000147891, -122.475636927177) |
| 141314 | 141314 | 114969 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200X MINERVA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5994532.0 | 2089023.0 | 37.7157458289959 | -122.460837724068 | (37.7157458289959, -122.460837724068) | |||
| 143315 | 143315 | 101003 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2801X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2012 12:00:00 AM | 3x3 | Permit Number 769246 | 6003500.6 | 2117942.3 | 37.795663322696704 | -122.43190190430201 | (37.7956633226967, -122.431901904302) | ||
| 144567 | 144567 | 109033 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2120 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772816 | 5987671.1 | 2103767.6 | 37.755833493421704 | -122.48563331933 | (37.7558334934217, -122.48563331933) |
| 145912 | 145912 | 203606 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1570 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992477.77859 | 2104773.12978 | 37.7588733092773 | -122.46908359384199 | (37.7588733092773, -122.469083593842) | |||
| 146397 | 146397 | 221963 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 4086 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002569.41757 | 2102410.84038 | 37.7529649603686 | -122.434013186153 | (37.7529649603686, -122.434013186153) | |||
| 146428 | 146428 | 123227 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 790 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 5993222.74872 | 2110119.7569 | 37.7735967518389 | -122.46689584772301 | (37.7735967518389, -122.466895847723) | |||
| 148279 | 148279 | 221942 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 133 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007406.60903 | 2096997.58914 | 37.738374717426204 | -122.41690171544501 | (37.7383747174262, -122.416901715445) | |||
| 149824 | 149824 | 203603 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 533 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995027.64484 | 2088883.389 | 37.7153909965718 | -122.459114456087 | (37.7153909965718, -122.459114456087) | |||
| 150141 | 150141 | 125560 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 20 Mallorca Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001979.154630001 | 2119935.63772 | 37.8010501391173 | -122.437309169106 | (37.8010501391173, -122.437309169106) | |||
| 153354 | 153354 | 203597 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 50 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995113.8822800005 | 2091909.7950400002 | 37.723705745105796 | -122.45903538769 | (37.7237057451058, -122.45903538769) | |||
| 157767 | 157767 | 125567 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2809 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6003482.8439 | 2118067.55033 | 37.7960062212666 | -122.431972291689 | (37.7960062212666, -122.431972291689) | |||
| 159483 | 159483 | 221944 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 375 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6007244.42247 | 2096286.76622 | 37.7364138302231 | -122.417412117593 | (37.7364138302231, -122.417412117593) | |||
| 159774 | 159774 | 175225 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 762 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002385.00148 | 2087111.8293299999 | 37.7109469004454 | -122.43355766966299 | (37.7109469004454, -122.433557669663) | |||
| 160726 | 160726 | 37181 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2519 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | 7 | Permit Number 39755 | 6001865.38269 | 2116985.0366700003 | 37.792942091651796 | -122.437491453568 | (37.7929420916518, -122.437491453568) | ||
| 163497 | 163497 | 108895 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 666 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 1 | 3x3 | Permit Number 774994 | 5987872.85836 | 2111424.89012 | 37.7768700551182 | -122.48549748779399 | (37.7768700551182, -122.485497487794) | |
| 168365 | 168365 | 221947 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 689 Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007672.8407 | 2096154.7937900003 | 37.7360755583335 | -122.41592154886101 | (37.7360755583335, -122.415921548861) | |||
| 169286 | 169286 | 221958 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 779 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008100.58194 | 2095693.3071 | 37.7348324551576 | -122.414410025905 | (37.7348324551576, -122.414410025905) | |||
| 169684 | 169684 | 81047 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 961 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 2 | 6001634.7016900005 | 2086773.55642 | 37.7099754779527 | -122.436126687404 | (37.7099754779527, -122.436126687404) | ||
| 174263 | 174263 | 221950 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 31 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006097.6775 | 2099053.5817299997 | 37.7439462971915 | -122.421573349947 | (37.7439462971915, -122.421573349947) | |||
| 177619 | 177619 | 203602 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 601 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5995030.39824 | 2089062.5673099998 | 37.7158831361758 | -122.45911790587799 | (37.7158831361758, -122.459117905878) | |||
| 177938 | 177938 | 70277 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 481 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/2012 12:00:00 AM | 2 | Permit Number 768624 | 5985297.751569999 | 2112660.9809 | 37.78011363845471 | -122.49449657583901 | (37.7801136384547, -122.494496575839) | |
| 178785 | 178785 | 125565 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1907 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5999924.7797300005 | 2115560.6496599996 | 37.7889205779801 | -122.44410362179501 | (37.7889205779801, -122.444103621795) | |||
| 179068 | 179068 | 175218 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 93 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001014.57653 | 2087970.42853 | 37.713226572126295 | -122.43835564452101 | (37.7132265721263, -122.438355644521) | |||
| 181110 | 181110 | 203599 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200 Minerva St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994990.6649400005 | 2089034.05641 | 37.715802567698105 | -122.459253178313 | (37.7158025676981, -122.459253178313) | |||
| 182032 | 182032 | 121978 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5991208.0697800005 | 2113958.75361 | 37.7840210969883 | -122.474145024774 | (37.7840210969883, -122.474145024774) | |||
| 184134 | 184134 | 221954 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 10 Mateo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003651.78928 | 2096634.4220599998 | 37.737165621192204 | -122.42985814834101 | (37.7371656211922, -122.429858148341) | |||
| 187046 | 187046 | 203611 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 146 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992953.888809999 | 2101207.94105 | 37.7491117215315 | -122.467177780245 | (37.7491117215315, -122.467177780245) | |||
| 33302 | 33302 | 203617 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 185 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994473.17466 | 2100793.8774900003 | 37.7480623907666 | -122.46189409053899 | (37.7480623907666, -122.461894090539) | |||
| 34354 | 34354 | 203616 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 185 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994461.2194300005 | 2100782.80797 | 37.7480313083953 | -122.46193462839199 | (37.7480313083953, -122.461934628392) | |||
| 42665 | 42665 | 203612 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1675 15th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5991397.55944 | 2103884.0392299998 | 37.7563696263767 | -122.472754630933 | (37.7563696263767, -122.472754630933) | |||
| 53131 | 53131 | 203609 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 120 Quintara St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993075.95674 | 2101213.4251599996 | 37.7491338250612 | -122.46675607013901 | (37.7491338250612, -122.466756070139) | |||
| 53899 | 53899 | 175227 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 225 Naylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6002635.08266 | 2086756.92621 | 37.709986599863 | -122.43266799554199 | (37.709986599863, -122.432667995542) | |||
| 58808 | 58808 | 203618 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 185 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994486.24709 | 2100807.40007 | 37.74810027292239 | -122.461849867291 | (37.7481002729224, -122.461849867291) | |||
| 59797 | 59797 | 120754 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 25 20th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5989551.609019999 | 2114996.4613099997 | 37.7867742543083 | -122.47995167641301 | (37.7867742543083, -122.479951676413) | ||||
| 68151 | 68151 | 203613 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1762 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5991879.53156 | 2103437.46302 | 37.755171333717 | -122.471055286375 | (37.755171333717, -122.471055286375) | |||
| 69004 | 69004 | 175219 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 100 Morse St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 1ft | 6000840.49126 | 2087951.89335 | 37.7131657752649 | -122.43895601391199 | (37.7131657752649, -122.438956013912) |
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");