Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128507 | 128507 | 110558 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1X Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection | 6007165.9 | 2109609.0 | 37.7729892139286 | -122.418628045346 | (37.7729892139286, -122.418628045346) | |||
| 92282 | 92282 | 9941 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 3 | 5x6 | Resulted descion 9/7/16 -DE | 6010050.959969999 | 2119172.47111 | 37.7994102279433 | -122.40932324608299 | (37.7994102279433, -122.409323246083) | |
| 118402 | 118402 | 54199 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 44 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | 4x4 | Permit Number 9937 | 5995656.55399656 | 2107084.69972772 | 37.765403444810204 | -122.45825728758899 | (37.7654034448102, -122.458257287589) | ||
| 93385 | 93385 | 98591 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2375 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 9808 | 6002830.0 | 2116793.0 | 37.7924696026791 | -122.434140096981 | (37.7924696026791, -122.434140096981) | |||
| 94963 | 94963 | 53929 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1700 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 3x3 | Permit Number 9642 | 6004487.99959123 | 2114676.46033991 | 37.786752078395 | -122.428252455396 | (37.786752078395, -122.428252455396) | ||
| 2914 | 2914 | 225015 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 157 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780170 | 6002699.8255900005 | 2104972.04176 | 37.7600048066089 | -122.433745251143 | (37.7600048066089, -122.433745251143) | |
| 2095 | 2095 | 58908 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 353 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/1980 12:00:00 AM | 13 | 3x3 | Permit Number 780019 | 6009109.47745 | 2109280.29041 | 37.7721958858688 | -122.41188171506501 | (37.7721958858688, -122.411881715065) | |
| 1383 | 1383 | 26841 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 779930 | 6006975.88726 | 2110943.04151 | 37.7766414730488 | -122.419379980819 | (37.7766414730488, -122.419379980819) | ||
| 9804 | 9804 | 59226 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 530 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779363 | 5992552.44717 | 2111818.61025 | 37.7782226338783 | -122.469338181035 | (37.7782226338783, -122.469338181035) | ||
| 78463 | 78463 | 115215 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778.0 | 2103691.0 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | |
| 114654 | 114654 | 95413 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2016 12:00:00 AM | 12 | 3x3 | Permit Number 779045 | 6002523.0 | 2095666.0 | 37.734442568942704 | -122.433691689524 | (37.7344425689427, -122.433691689524) | |
| 100292 | 100292 | 64484 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 436 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1988 12:00:00 AM | Permit Number 778749 | 6014198.52964849 | 2112913.46772182 | 37.782455962378 | -122.39453256733 | (37.782455962378, -122.39453256733) | |||
| 128282 | 128282 | 54027 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 246 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778679 | 6004696.3346429 | 2103995.33974478 | 37.757436100430105 | -122.426770728763 | (37.7574361004301, -122.426770728763) | |
| 65794 | 65794 | 115992 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 438 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2016 12:00:00 AM | 3 | Permit Number 778644 | 5989723.9 | 2112354.3 | 37.7795296278249 | -122.47916224845301 | (37.7795296278249, -122.479162248453) | ||
| 10044 | 10044 | 120656 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 160 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10045 | 10045 | 120661 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10058 | 10058 | 120660 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 126 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10065 | 10065 | 120663 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10066 | 10066 | 120655 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 160 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10073 | 10073 | 120662 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 105263 | 105263 | 104321 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 80 BEAVER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | Permit Number 778510 | 6002416.6 | 2106828.4 | 37.7650858403074 | -122.43485754712201 | (37.7650858403074, -122.434857547122) | ||
| 111237 | 111237 | 104320 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 80 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778510 | 6002383.0 | 2106795.0 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | |
| 110603 | 110603 | 55394 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2271 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2016 12:00:00 AM | 3 | Permit Number 778438 | 6002436.86184357 | 2107050.31699598 | 37.765696320564 | -122.43480333738 | (37.765696320564, -122.43480333738) | ||
| 129314 | 129314 | 98979 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 38 MILEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 778225 | 5999656.0 | 2118689.0 | 37.7974948649915 | -122.44525857219999 | (37.7974948649915, -122.4452585722) | ||
| 95819 | 95819 | 64020 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2344 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 778144 | 6002015.0 | 2107091.0 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) | ||
| 19675 | 19675 | 103628 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 93675 | 93675 | 103631 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 99002 | 99002 | 103629 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 100369 | 100369 | 103635 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 108761 | 108761 | 103633 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 109869 | 109869 | 103630 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 113907 | 113907 | 103634 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 116711 | 116711 | 103637 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 119949 | 119949 | 103632 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 121138 | 121138 | 103636 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 82713 | 82713 | 61493 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3149 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1984 12:00:00 AM | Permit Number 777095 | 5999649.96958977 | 2116015.59113069 | 37.790154046975395 | -122.445087143888 | (37.7901540469754, -122.445087143888) | |||
| 80364 | 80364 | 573 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2990 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 776380 | 6009007.8652800005 | 2102243.7741799997 | 37.752869522851704 | -122.411735919997 | (37.7528695228517, -122.411735919997) | ||
| 116080 | 116080 | 110926 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2970 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 775246 | 5999959.8 | 2116452.8 | 37.79137218692 | -122.444046586367 | (37.79137218692, -122.444046586367) | ||||
| 66642 | 66642 | 4609 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 316 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774670 | 6010771.0363 | 2118706.95943 | 37.7981723635161 | -122.406798689949 | (37.7981723635161, -122.406798689949) | |
| 127656 | 127656 | 94524 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3322 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 774668 | 5988381.0 | 2111924.0 | 37.7782700631784 | -122.48377629744301 | (37.7782700631784, -122.483776297443) | |||
| 124195 | 124195 | 92386 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2810 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774470 | 6001269.0 | 2116290.0 | 37.7909997773984 | -122.439505117215 | (37.7909997773984, -122.439505117215) | |
| 114870 | 114870 | 52589 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 675 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2006 12:00:00 AM | Permit Number 774039 | 5997878.20498734 | 2108284.16023065 | 37.7688242695831 | -122.450659631577 | (37.7688242695831, -122.450659631577) | |||
| 87672 | 87672 | 107653 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 600 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.777813365393705 | -122.424683001313 | (37.7778133653937, -122.424683001313) | ||
| 93269 | 93269 | 107652 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 600 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.777813365393705 | -122.424683001313 | (37.7778133653937, -122.424683001313) | ||
| 103594 | 103594 | 107654 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 600 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.777813365393705 | -122.424683001313 | (37.7778133653937, -122.424683001313) | ||
| 71075 | 71075 | 106808 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 10 LOYOLA TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 772884 | 5998469.3 | 2110801.2 | 37.7757692329232 | -122.44879640789101 | (37.7757692329232, -122.448796407891) | |||
| 92293 | 92293 | 106915 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3832 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 772728 | 5995876.045419999 | 2115884.62189 | 37.7895783172049 | -122.458135060161 | (37.7895783172049, -122.458135060161) | ||||
| 82860 | 82860 | 106525 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 90447 | 90447 | 106522 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 91358 | 91358 | 106526 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 141398 | 141398 | 106523 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 144210 | 144210 | 106521 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 145770 | 145770 | 106524 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 58674 | 58674 | 102786 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3345 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4.5x6 | Permit Number 772480 | 6003174.4 | 2119873.2 | 37.8009465759098 | -122.433168646536 | (37.8009465759098, -122.433168646536) | ||
| 2875 | 2875 | 53666 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1630 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 17 | 3x3 | Permit Number 772472 | 6006654.5213 | 2116532.6022 | 37.7919709328888 | -122.420888619402 | (37.7919709328888, -122.420888619402) |
| 44347 | 44347 | 224728 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1110 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | Permit Number 771820 | 6009984.63313 | 2102660.33541 | 37.754068053508 | -122.40838743973801 | (37.754068053508, -122.408387439738) | ||
| 2631 | 2631 | 105340 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | 12 | Permit Number 770950 | 6000144.5 | 2113810.0 | 37.784126280525605 | -122.44321763524201 | (37.7841262805256, -122.443217635242) | ||
| 134152 | 134152 | 57410 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 109 Wilmot St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1976 12:00:00 AM | 15 | Permit Number 770100 | 6002753.5601 | 2114939.9175 | 37.7873771736852 | -122.434272041026 | (37.7873771736852, -122.434272041026) | ||
| 94295 | 94295 | 101975 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1230 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769454 | 6013882.0 | 2105282.2 | 37.761484606165205 | -122.39509293682801 | (37.7614846061652, -122.395092936828) | |||
| 129433 | 129433 | 101290 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 830 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769326 | 6001055.4 | 2088979.9 | 37.7160006775821 | -122.438286819162 | (37.7160006775821, -122.438286819162) | ||||
| 19468 | 19468 | 6756 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | Permit Number 769095 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
| 82278 | 82278 | 11175 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2740 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | Permit Number 769071 | 6006912.197631501 | 2121679.9811893995 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | ||
| 83569 | 83569 | 11177 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2740 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | Permit Number 769071 | 6006912.197631501 | 2121679.9811893995 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | ||
| 110897 | 110897 | 11176 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2740 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | Permit Number 769071 | 6006912.197631501 | 2121679.9811893995 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | ||
| 126807 | 126807 | 100049 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3233X Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 768990 | 6003300.0 | 2119605.0 | 37.800217292537106 | -122.432714848025 | (37.8002172925371, -122.432714848025) | ||
| 86731 | 86731 | 100705 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 220X 01st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902.0 | 2115015.0 | 37.7882097965006 | -122.39570573165199 | (37.7882097965006, -122.395705731652) | ||
| 97528 | 97528 | 100707 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 220X 01st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902.0 | 2115015.0 | 37.7882097965006 | -122.39570573165199 | (37.7882097965006, -122.395705731652) | ||
| 108521 | 108521 | 100706 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 220X 01st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902.0 | 2115015.0 | 37.7882097965006 | -122.39570573165199 | (37.7882097965006, -122.395705731652) | ||
| 139052 | 139052 | 100710 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 220X 01st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902.0 | 2115015.0 | 37.7882097965006 | -122.39570573165199 | (37.7882097965006, -122.395705731652) | ||
| 141840 | 141840 | 100708 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 220X 01st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902.0 | 2115015.0 | 37.7882097965006 | -122.39570573165199 | (37.7882097965006, -122.395705731652) | ||
| 97157 | 97157 | 9917 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1905X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3x3 | Permit Number 768908 | 6005198.982724099 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | ||
| 83639 | 83639 | 66275 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1065 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1990 12:00:00 AM | 3x3 | Permit Number 768678 | 6007678.31560988 | 2109516.6646006 | 37.7727645184447 | -122.416848989215 | (37.7727645184447, -122.416848989215) | ||
| 92260 | 92260 | 96411 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3828 Jackson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2012 12:00:00 AM | Permit Number 768662 | 5995910.0 | 2115869.0 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | |||
| 145603 | 145603 | 97278 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 60 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768156 | 5995934.7 | 2114107.9 | 37.7847032866401 | -122.45780350364599 | (37.7847032866401, -122.457803503646) | |||
| 145114 | 145114 | 66879 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 277 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 768127 | 6001144.84674667 | 2104743.15871911 | 37.75928799185029 | -122.439106757133 | (37.7592879918503, -122.439106757133) | ||
| 19751 | 19751 | 96542 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | ||||
| 106582 | 106582 | 96541 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | ||||
| 94440 | 94440 | 96410 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3828 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767718 | 5995910.0 | 2115869.0 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | ||||
| 100664 | 100664 | 53710 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4067 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/1970 12:00:00 AM | 14 | Permit Number 6657 | 6002578.30950532 | 2104703.42856113 | 37.7592603634983 | -122.434146313573 | (37.7592603634983, -122.434146313573) | ||
| 104663 | 104663 | 53708 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 350 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/1970 12:00:00 AM | 36 | Permit Number 6655 | 6003550.85725641 | 2106242.74617004 | 37.7635421097395 | -122.430892631532 | (37.7635421097395, -122.430892631532) | ||
| 116882 | 116882 | 98224 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4068 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2012 12:00:00 AM | 3x3 | Permit Number 56734 | 6003417.8 | 2101304.1 | 37.7499742222019 | -122.43100033681401 | (37.7499742222019, -122.431000336814) | ||
| 79776 | 79776 | 94218 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 246 01st St | 3 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | ||
| 90460 | 90460 | 94216 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1X Tehama St | 1 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6013910.7 | 2114841.3 | 37.7877333404996 | -122.395663455814 | (37.7877333404996, -122.395663455814) | ||
| 105416 | 105416 | 94220 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1X Tehama St | 5 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | Permit Number 53568 | 6013910.7 | 2114841.3 | 37.7877333404996 | -122.395663455814 | (37.7877333404996, -122.395663455814) | ||||
| 117229 | 117229 | 94219 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 246 01st St | 4 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | |||
| 143783 | 143783 | 94217 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 246 01st St | 2 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | ||
| 77880 | 77880 | 93215 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 499 Jackson St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53209 | 6011715.0 | 2118034.0 | 37.7963773511427 | -122.403484907832 | (37.7963773511427, -122.403484907832) | |||
| 85878 | 85878 | 92850 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3150 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | Permit Number 53071 | 5999589.0 | 2116381.0 | 37.7911538835614 | -122.44532437717501 | (37.7911538835614, -122.445324377175) | |||
| 127933 | 127933 | 92818 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 95 Burlwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2009 12:00:00 AM | 3x3 | Permit Number 53027 | 5996883.0 | 2096019.0 | 37.7350901820695 | -122.453216393363 | (37.7350901820695, -122.453216393363) | ||
| 101697 | 101697 | 54117 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4356 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | 3x3 | Permit Number 52105 | 6001531.81835159 | 2105282.89107801 | 37.760791976960604 | -122.43780708149201 | (37.7607919769606, -122.437807081492) | ||
| 123227 | 123227 | 91329 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2885 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52056 | 6000915.0 | 2116200.0 | 37.7907325075106 | -122.440723481884 | (37.7907325075106, -122.440723481884) | |||
| 112718 | 112718 | 15263 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1500 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/30/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51766 | 6007587.5132074 | 2110099.4827033 | 37.774359690705296 | -122.417204392502 | (37.7743596907053, -122.417204392502) | |
| 144303 | 144303 | 89021 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500 Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51766 | 6007445.1 | 2110006.7 | 37.7740969185595 | -122.417690449841 | (37.7740969185595, -122.417690449841) | |||
| 100818 | 100818 | 87145 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2405 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226.0 | 2104427.0 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | ||
| 129076 | 129076 | 87146 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2405 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226.0 | 2104427.0 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | ||
| 141248 | 141248 | 87144 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2405 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226.0 | 2104427.0 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | ||
| 116825 | 116825 | 87134 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 65 Mars St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50103 | 5999603.0 | 2105413.0 | 37.761039357097104 | -122.44448733345502 | (37.7610393570971, -122.444487333455) | |||
| 88161 | 88161 | 86905 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 36 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2007 12:00:00 AM | 3x3 | Permit Number 49869 | 6005775.0 | 2106383.0 | 37.7640529822515 | -122.423209987967 | (37.7640529822515, -122.423209987967) | ||
| 82045 | 82045 | 86740 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1275 02nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | |||||
| 49233 | 49233 | 85313 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 610 Brannan St | 1 | unknown : Cutout 12 | Tree 1 | Private 1 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.39955535858401 | (37.7766267904106, -122.399555358584) |
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");