trees
11,761 rows where qSpecies_id = 17 sorted by PermitNotes
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14550 | 261641 | DPW Maintained 1 | Tree(s) :: 17 | 689 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | Width 0ft | 5995176 | 2089914 | 37.7182293382848 | -122.45867624436 | (37.7182293382848, -122.45867624436) | 9 | 8 | 6 | 28861 | 24 | ||
| 14604 | 108382 | Undocumented 4 | Tree(s) :: 17 | 30 CASTILLO ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6x12 | 6006869.1 | 2086298.1 | 37.7089659714277 | -122.418001881162 | (37.7089659714277, -122.418001881162) | 9 | 7 | 8 | 309 | 39 | ||||
| 14794 | 243191 | DPW Maintained 1 | Tree(s) :: 17 | 195 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6005498.9458 | 2108425.39088 | 37.7696453177193 | -122.424310051667 | (37.7696453177193, -122.424310051667) | 8 | 4 | 5 | 28853 | 19 | |||
| 15091 | 100993 | Undocumented 4 | Tree(s) :: 17 | 1675 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009464 | 2106858 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | 8 | 4 | 7 | 28853 | 19 | ||||
| 15160 | 260680 | Significant Tree 6 | Tree(s) :: 17 | 1450x Laguna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6004617 | 2113883 | 37.7845807327875 | -122.42774958855 | (37.7845807327875, -122.42774958855) | 13 | 9 | 11 | 28858 | 41 | ||||
| 15162 | 255774 | Undocumented 4 | Tree(s) :: 17 | 300 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004016 | 2097157 | 37.7386211197367 | -122.428636146259 | (37.7386211197367, -122.428636146259) | 2 | 7 | 5 | 63 | 7 | ||||
| 15172 | 260605 | DPW Maintained 1 | Tree(s) :: 17 | 1042 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013961.37936 | 2090032.97981 | 37.719617837314 | -122.393750999085 | (37.719617837314, -122.393750999085) | 10 | 3 | 8 | 58 | 1 | |||
| 15191 | 96232 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
| 15302 | 153219 | DPW Maintained 1 | Tree(s) :: 17 | 1132 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6010246.61428 | 2102612.21341 | 37.7539505885697 | -122.407478048871 | (37.7539505885697, -122.407478048871) | 2 | 4 | 7 | 28859 | 19 | |||
| 15318 | 244196 | DPW Maintained 1 | Tree(s) :: 17 | 508 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998471.7891 | 2108892.6681 | 37.7705290359785 | -122.448650307908 | (37.7705290359785, -122.448650307908) | 15 | 5 | 11 | 29492 | 9 | |||
| 15426 | 262040 | DPW Maintained 1 | Tree(s) :: 17 | 740 Jamestown Ave | Back Yard : Yard | Tree | DPW 1 | Private | 6015231.58289 | 2088478.1596 | 37.7154191081975 | -122.38925181324 | (37.7154191081975, -122.38925181324) | 10 | 3 | 8 | 58 | 1 | |||||
| 15525 | 261460 | Undocumented 4 | Tree(s) :: 17 | 701X Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5999135 | 2090407 | 37.7198097539444 | -122.445027136249 | (37.7198097539444, -122.445027136249) | 9 | 7 | 6 | 28861 | 25 | ||||
| 15590 | 260947 | Private 9 | Tree(s) :: 17 | 143 Gambier St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6005856 | 2093079 | 37.72752779603 | -122.421984681693 | (37.72752779603, -122.421984681693) | 9 | 7 | 7 | 309 | 5 | ||||
| 15642 | 102891 | Undocumented 4 | Tree(s) :: 17 | 115 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008968 | 2112966 | 37.7823080347026 | -122.412631696322 | (37.7823080347026, -122.412631696322) | 7 | 10 | 9 | 28852 | 36 | ||||
| 15657 | 259657 | Significant Tree 6 | Tree(s) :: 17 | 132 Sagamore St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995545 | 2087474 | 37.7115508726991 | -122.457224363425 | (37.7115508726991, -122.457224363425) | 9 | 8 | 6 | 28861 | 24 | ||||
| 15713 | 261808 | DPW Maintained 1 | Tree(s) :: 17 | 2355 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2020 12:00:00 AM | 3 | 5985742 | 2099196 | 37.743168533237 | -122.491968112718 | (37.743168533237, -122.491968112718) | 1 | 8 | 3 | 29491 | 35 | ||
| 15734 | 102859 | Undocumented 4 | Tree(s) :: 17 | 696 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6009251 | 2115330 | 37.7888148901218 | -122.411819735773 | (37.7888148901218, -122.411819735773) | 5 | 1 | 10 | 28852 | 21 | |||
| 15967 | 206142 | DPW Maintained 1 | Tree(s) :: 17 | 1377 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5993310.45546 | 2106106.93767 | 37.7625836746174 | -122.466300768565 | (37.7625836746174, -122.466300768565) | 1 | 8 | 11 | 56 | 12 | |||
| 15968 | 261219 | DPW Maintained 1 | Tree(s) :: 17 | 1901 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 4x6 | 5983159 | 2102154 | 37.7511390637365 | -122.501118029821 | (37.7511390637365, -122.501118029821) | 1 | 8 | 3 | 29491 | 35 | |
| 16125 | 260551 | DPW Maintained 1 | Tree(s) :: 17 | 937 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011850 | 2111438 | 37.7782738288903 | -122.402553714468 | (37.7782738288903, -122.402553714468) | 14 | 2 | 9 | 28856 | 34 | ||||
| 16134 | 106952 | Undocumented 4 | Tree(s) :: 17 | 399X SOMERSET ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6009953 | 2092875 | 37.7271978698015 | -122.407806879765 | (37.7271978698015, -122.407806879765) | 10 | 3 | 7 | 309 | 28 | ||||
| 16232 | 262057 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 8 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
| 16275 | 260607 | DPW Maintained 1 | Tree(s) :: 17 | 1026 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014043.19207 | 2089971.98975 | 37.71945491674 | -122.393463933828 | (37.71945491674, -122.393463933828) | 10 | 3 | 8 | 58 | 1 | |||
| 16631 | 104298 | Permitted Site 7 | Tree(s) :: 17 | 4021 20TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 6003557 | 2104154 | 37.7578072610358 | -122.430722322319 | (37.7578072610358, -122.430722322319) | 2 | 4 | 5 | 28862 | 3 | |||||
| 16678 | 261979 | DPW Maintained 1 | Tree(s) :: 17 | 3471 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005237 | 2103664 | 37.7565568729323 | -122.424877318266 | (37.7565568729323, -122.424877318266) | 2 | 4 | 5 | 28859 | 19 | ||||
| 16744 | 261651 | DPW Maintained 1 | Tree(s) :: 17 | 191 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | 4x4 | 5995473 | 2088701 | 37.7149157919268 | -122.45756193275 | (37.7149157919268, -122.45756193275) | 9 | 8 | 6 | 28861 | 24 | ||
| 16827 | 111314 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
| 16870 | 110525 | DPW Maintained 1 | Tree(s) :: 17 | 1606 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2015 12:00:00 AM | 3 | 3x3 | 5988987.9 | 2103139.4 | 37.7541852610858 | -122.481033456555 | (37.7541852610858, -122.481033456555) | 1 | 8 | 3 | 56 | 35 | ||
| 17025 | 262527 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
| 17077 | 70380 | DPW Maintained 1 | Tree(s) :: 17 | 1427 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982136.0566 | 2105382.6181 | 37.7599438156219 | -122.5048946364 | (37.7599438156219, -122.5048946364) | 1 | 8 | 3 | 56 | 35 | |||
| 17125 | 263631 | Permitted Site 7 | Tree(s) :: 17 | 1362 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2020 12:00:00 AM | 4x4 | 5993972.07205 | 2106233.99914 | 37.7629707045155 | -122.464021718038 | (37.7629707045155, -122.464021718038) | 1 | 5 | 11 | 56 | 12 | |||
| 17248 | 260604 | DPW Maintained 1 | Tree(s) :: 17 | 1058 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013879.56666 | 2090093.96987 | 37.7197807571849 | -122.394038065566 | (37.7197807571849, -122.394038065566) | 10 | 3 | 8 | 58 | 1 | |||
| 17296 | 262054 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 5 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
| 17341 | 260857 | DPW Maintained 1 | Tree(s) :: 17 | 726 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985712.15541 | 2110932.69313 | 37.7753924991275 | -122.492935643751 | (37.7753924991275, -122.492935643751) | 11 | 6 | 2 | 55 | 26 | |||
| 17367 | 112785 | Permitted Site 7 | Tree(s) :: 17 | 160 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | 3x3 | 6007598 | 2107985 | 37.7685544110168 | -122.417018265631 | (37.7685544110168, -122.417018265631) | 8 | 4 | 7 | 28853 | 19 | |||
| 17452 | 97358 | Permitted Site 7 | Tree(s) :: 17 | 8 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
| 17482 | 111313 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
| 17589 | 251643 | DPW Maintained 1 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6007328 | 2121670 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | 5 | 1 | 1 | 28858 | 32 | |||
| 17611 | 56452 | Permitted Site 7 | Tree(s) :: 17 | 1471 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5982761.8650167 | 2105117.76871339 | 37.7592534113712 | -122.50271069963 | (37.7592534113712, -122.50271069963) | 1 | 8 | 3 | 56 | 35 | |||||
| 17700 | 260555 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 502 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2019 12:00:00 AM | 3 | 3x3 | 6011196 | 2109910 | 37.7740417608934 | -122.404708555539 | (37.7740417608934, -122.404708555539) | 14 | 2 | 9 | 28853 | 34 | ||
| 17730 | 25297 | DPW Maintained 1 | Tree(s) :: 17 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:24:00 PM | 3 | 3x3 | 6000520.37509 | 2091718.7559 | 37.723490510353 | -122.440332418218 | (37.723490510353, -122.440332418218) | 9 | 7 | 6 | 28861 | 25 | ||
| 17743 | 261427 | Undocumented 4 | Tree(s) :: 17 | 1001 Potrero Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
| 17782 | 56736 | Permitted Site 7 | Tree(s) :: 17 | 2100 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992602.18859707 | 2101147.35229749 | 37.7489250523556 | -122.468389545401 | (37.7489250523556, -122.468389545401) | 1 | 8 | 4 | 29491 | 40 | |||||
| 17829 | 106868 | Undocumented 4 | Tree(s) :: 17 | 1956 GREAT HWY | Sidewalk: Property side : Cutout | Tree | Private 2 | 5981193.7 | 2101737.6 | 37.7498801477899 | -122.507883225183 | (37.7498801477899, -122.507883225183) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 17888 | 129632 | DPW Maintained 1 | Tree(s) :: 17 | 1224 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2020 11:48:00 PM | 3 | Width 2ft | 6007668.52522 | 2118543.16915 | 37.7975485540748 | -122.417522708125 | (37.7975485540748, -122.417522708125) | 5 | 1 | 10 | 28858 | 32 | ||
| 17927 | 116310 | Undocumented 4 | Tree(s) :: 17 | 1599X Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001671.10835 | 2113777.6056 | 37.7841242646501 | -122.437933807354 | (37.7841242646501, -122.437933807354) | 15 | 6 | 11 | 29490 | 13 | |||||
| 18242 | 261429 | Undocumented 4 | Tree(s) :: 17 | 1001 Potrero Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
| 18448 | 260600 | DPW Maintained 1 | Tree(s) :: 17 | 1122 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014231.13861 | 2090181.46138 | 37.7200405252834 | -122.392828913667 | (37.7200405252834, -122.392828913667) | 10 | 3 | 8 | 58 | 1 | |||
| 18526 | 250107 | Private 9 | Tree(s) :: 17 | 1688 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005911.45005 | 2115583.38163 | 37.7893226981327 | -122.423392144226 | (37.7893226981327, -122.423392144226) | 13 | 9 | 1 | 28858 | 41 | |||
| 18556 | 105475 | Undocumented 4 | Tree(s) :: 17 | 671 Waller St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2014 12:00:00 AM | 3x3 | 6002476.36422 | 2108834.33955 | 37.7705970512656 | -122.434794296397 | (37.7705970512656, -122.434794296397) | 15 | 5 | 11 | 29492 | 9 | ||||
| 18583 | 261810 | DPW Maintained 1 | Tree(s) :: 17 | 2363 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5985744 | 2099145 | 37.7430286178538 | -122.491957443342 | (37.7430286178538, -122.491957443342) | 1 | 8 | 3 | 29491 | 35 | ||
| 18628 | 116483 | Permitted Site 7 | Tree(s) :: 17 | 191 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999138.49956791 | 2107652.6022322 | 37.7671622291215 | -122.446254942292 | (37.7671622291215, -122.446254942292) | 15 | 5 | 5 | 29492 | 9 | |||||
| 18729 | 99529 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
| 18757 | 261980 | DPW Maintained 1 | Tree(s) :: 17 | 718 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6004261 | 2104680 | 37.7592913923108 | -122.428325085778 | (37.7592913923108, -122.428325085778) | 2 | 4 | 5 | 28862 | 3 | ||||
| 18785 | 112889 | DPW Maintained 1 | Tree(s) :: 17 | 107 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992983.7 | 2114758.1 | 37.7863185829105 | -122.468060207768 | (37.7863185829105, -122.468060207768) | 11 | 6 | 2 | 54 | 11 | |||||
| 18970 | 97073 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 19014 | 260601 | DPW Maintained 1 | Tree(s) :: 17 | 1142 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014128.86091 | 2090257.70792 | 37.7202442017659 | -122.393187787982 | (37.7202442017659, -122.393187787982) | 10 | 3 | 8 | 58 | 1 | |||
| 19015 | 261649 | DPW Maintained 1 | Tree(s) :: 17 | 605 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 5995910 | 2089162 | 37.7162066827324 | -122.456084795666 | (37.7162066827324, -122.456084795666) | 9 | 8 | 6 | 28861 | 24 | ||||
| 19064 | 56497 | Permitted Site 7 | Tree(s) :: 17 | 3741 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005586.21647246 | 2100777.61891873 | 37.7486512569257 | -122.423464408239 | (37.7486512569257, -122.423464408239) | 2 | 4 | 5 | 28859 | 19 | |||||
| 19066 | 261424 | Undocumented 4 | Tree(s) :: 17 | 1001 Potrero Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
| 19136 | 102260 | Undocumented 4 | Tree(s) :: 17 | 1350 46th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 4x6 | 5981875.8 | 2105892.8 | 37.7613293147111 | -122.505832545781 | (37.7613293147111, -122.505832545781) | 1 | 8 | 3 | 56 | 35 | |||
| 19304 | 181896 | DPW Maintained 1 | Tree(s) :: 17 | 2343 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986379.7223 | 2099305.8434 | 37.7435073893325 | -122.489771144773 | (37.7435073893325, -122.489771144773) | 1 | 8 | 3 | 29491 | 35 | |||
| 19310 | 261482 | DPW Maintained 1 | Tree(s) :: 17 | 1000 Portola Dr | 11 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
| 19485 | 100992 | Undocumented 4 | Tree(s) :: 17 | 1675 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009464 | 2106858 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | 8 | 4 | 7 | 28853 | 19 | ||||
| 19499 | 261504 | DPW Maintained 1 | Tree(s) :: 17 | 1200X Portola Dr | 11 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
| 19534 | 162670 | DPW Maintained 1 | Tree(s) :: 17 | 30 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | Width 0ft | 5996650.10566 | 2090561.91182 | 37.7200929670042 | -122.453627674296 | (37.7200929670042, -122.453627674296) | 9 | 8 | 6 | 28861 | 24 | ||
| 19547 | 97356 | Permitted Site 7 | Tree(s) :: 17 | 6 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
| 20036 | 102216 | Undocumented 4 | Tree(s) :: 17 | 46 Aloha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5991937.9 | 2104336.6 | 37.7576435040563 | -122.470918928367 | (37.7576435040563, -122.470918928367) | 1 | 8 | 4 | 56 | 12 | |||
| 20171 | 100589 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
| 20195 | 90386 | DPW Maintained 1 | Tree(s) :: 17 | 20 12th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2013 03:31:00 PM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
| 20285 | 97770 | Undocumented 4 | Tree(s) :: 17 | 362 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6007113.7 | 2105238.5 | 37.7609859097905 | -122.418498646119 | (37.7609859097905, -122.418498646119) | 2 | 4 | 7 | 28859 | 19 | |||
| 20424 | 56461 | Permitted Site 7 | Tree(s) :: 17 | 2441 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006975.1781122 | 2104145.58289129 | 37.7579772134709 | -122.418900218081 | (37.7579772134709, -122.418900218081) | 2 | 4 | 7 | 28859 | 19 | |||||
| 20760 | 184403 | DPW Maintained 1 | Tree(s) :: 17 | 2082 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981400.5223 | 2100912.6701 | 37.7476273056723 | -122.507106847904 | (37.7476273056723, -122.507106847904) | 1 | 8 | 3 | 29491 | 35 | |||
| 21010 | 258626 | Undocumented 4 | Tree(s) :: 17 | 43 Carver St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009465 | 2098515 | 37.7426567664404 | -122.40989186085 | (37.7426567664404, -122.40989186085) | 10 | 7 | 7 | 28859 | 2 | ||||
| 21253 | 56470 | Permitted Site 7 | Tree(s) :: 17 | 21 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007021.73787968 | 2099620.54976656 | 37.745555125446 | -122.418418346891 | (37.745555125446, -122.418418346891) | 2 | 7 | 7 | 28859 | 2 | |||||
| 21419 | 100996 | Undocumented 4 | Tree(s) :: 17 | 1675 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009464 | 2106858 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | 8 | 4 | 7 | 28853 | 19 | ||||
| 21607 | 121572 | Permitted Site 7 | Tree(s) :: 17 | 2765 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008296.52707816 | 2106782.09539442 | 37.7652907841924 | -122.414516980797 | (37.7652907841924, -122.414516980797) | 8 | 4 | 7 | 28859 | 19 | |||||
| 21995 | 111152 | Undocumented 4 | Tree(s) :: 17 | 600X MINNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009435 | 2111668 | 37.7787702333332 | -122.410924371776 | (37.7787702333332, -122.410924371776) | 8 | 2 | 9 | 28853 | 34 | ||||
| 22208 | 182566 | DPW Maintained 1 | Tree(s) :: 17 | 2483 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988890.9813 | 2098452.8512 | 37.7413116024246 | -122.481025496381 | (37.7413116024246, -122.481025496381) | 1 | 8 | 3 | 29491 | 35 | |||
| 22280 | 121321 | Undocumented 4 | Tree(s) :: 17 | 3699X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003556 | 2121083 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | 13 | 9 | 1 | 28858 | 17 | ||||
| 22510 | 105723 | Undocumented 4 | Tree(s) :: 17 | 4016 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003514 | 2104212 | 37.7579640789635 | -122.430875173314 | (37.7579640789635, -122.430875173314) | 2 | 4 | 5 | 28862 | 3 | ||||
| 22526 | 56650 | Permitted Site 7 | Tree(s) :: 17 | 455 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993745.91469689 | 2090225.88887329 | 37.7190034116626 | -122.463642026348 | (37.7190034116626, -122.463642026348) | 9 | 8 | 6 | 64 | 24 | |||||
| 22722 | 99750 | Undocumented 4 | Tree(s) :: 17 | 4210 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002521.3 | 2100652.6 | 37.7481345176555 | -122.434053910222 | (37.7481345176555, -122.434053910222) | 2 | 4 | 5 | 28862 | 22 | |||||
| 22839 | 102906 | Undocumented 4 | Tree(s) :: 17 | 4097 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002396 | 2104719 | 37.7592927701818 | -122.43477794069 | (37.7592927701818, -122.43477794069) | 2 | 4 | 5 | 28862 | 3 | ||||
| 22942 | 106274 | Undocumented 4 | Tree(s) :: 17 | 1499X 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012140 | 2107020 | 37.7661591913543 | -122.401239953075 | (37.7661591913543, -122.401239953075) | 14 | 3 | 8 | 28853 | 20 | |||||
| 23096 | 27581 | DPW Maintained 1 | Tree(s) :: 17 | 1299X Illinois St | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/2001 12:00:00 AM | 3 | 3X3 | 6016181.7533979 | 2103053.0321119 | 37.7554914042844 | -122.38698349009 | (37.7554914042844, -122.38698349009) | 10 | 3 | 8 | 28856 | 29 | ||
| 23122 | 56527 | Permitted Site 7 | Tree(s) :: 17 | 4712 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998598.83756135 | 2105705.90676234 | 37.7617862583341 | -122.447981370547 | (37.7617862583341, -122.447981370547) | 15 | 5 | 11 | 29492 | 9 | |||||
| 23342 | 99014 | Permitted Site 7 | Tree(s) :: 17 | 125x Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006331.3 | 2098231.1 | 37.7417011178952 | -122.420707158841 | (37.7417011178952, -122.420707158841) | 2 | 7 | 7 | 28859 | 2 | |||||
| 23617 | 106273 | Undocumented 4 | Tree(s) :: 17 | 1499X 16TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012140 | 2107020 | 37.7661591913543 | -122.401239953075 | (37.7661591913543, -122.401239953075) | 14 | 3 | 8 | 28853 | 20 | |||||
| 23833 | 100765 | Undocumented 4 | Tree(s) :: 17 | 5 Bernice St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008581 | 2108519.7 | 37.7700778198991 | -122.413655963874 | (37.7700778198991, -122.413655963874) | 8 | 2 | 9 | 28853 | 19 | |||
| 24076 | 91328 | DPW Maintained 1 | Tree(s) :: 17 | 5089 Mission St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/05/2007 12:00:00 AM | 3x3 | 6000514.1536 | 2089460.50315 | 37.7172895061936 | -122.440192061387 | (37.7172895061936, -122.440192061387) | 9 | 7 | 6 | 28861 | 5 | ||||
| 24117 | 27426 | DPW Maintained 1 | Tree(s) :: 17 | 98X Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/14/2012 12:00:00 AM | 1 | 3x3 | 6006094.6477071 | 2108521.7458746 | 37.7699435048383 | -122.422256382252 | (37.7699435048383, -122.422256382252) | 8 | 4 | 7 | 28853 | 19 | ||
| 24267 | 56501 | Permitted Site 7 | Tree(s) :: 17 | 1537 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998788.44674872 | 2108641.8195399 | 37.7698583712599 | -122.447536931666 | (37.7698583712599, -122.447536931666) | 15 | 5 | 11 | 29492 | 9 | |||||
| 24298 | 142112 | Undocumented 4 | Tree(s) :: 17 | 33 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998605.4598 | 2110962.5015 | 37.7762199106651 | -122.44833701705 | (37.7762199106651, -122.44833701705) | 15 | 6 | 2 | 29492 | 16 | |||
| 24349 | 97071 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 24577 | 99676 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 24660 | 113305 | Permitted Site 7 | Tree(s) :: 17 | 775 VIENNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002442 | 2089001 | 37.7161373820525 | -122.43349558835 | (37.7161373820525, -122.43349558835) | 9 | 7 | 6 | 28861 | 5 | ||||
| 24723 | 102517 | Undocumented 4 | Tree(s) :: 17 | 498X Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010140.7 | 2089714.5 | 37.7185302998738 | -122.406935337509 | (37.7185302998738, -122.406935337509) | 10 | 7 | 8 | 309 | 39 | |||||
| 25172 | 27441 | DPW Maintained 1 | Tree(s) :: 17 | 1690X Indiana St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6015146.8447845 | 2100681.5042352 | 37.7489223309609 | -122.390396861105 | (37.7489223309609, -122.390396861105) | 10 | 3 | 8 | 58 | 1 | |||
| 25257 | 124734 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );