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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5607 | 260608 | DPW Maintained 1 | Tree(s) :: 17 | 1010 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014125.00477 | 2089910.99969 | 37.7192919954616 | -122.393176869863 | (37.7192919954616, -122.393176869863) | 10 | 3 | 8 | 58 | 1 | |||
5702 | 121171 | Significant Tree 6 | Tree(s) :: 17 | 900x Duncan St | 4 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000584 | 2099647 | 37.745263242779 | -122.440680889831 | (37.745263242779, -122.440680889831) | 2 | 7 | 5 | 63 | 7 | ||||
5837 | 87442 | DPW Maintained 1 | Tree(s) :: 17 | 2801X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3x3 | 5997499.095645 | 2087961.159651 | 37.7130005371424 | -122.450505622879 | (37.7130005371424, -122.450505622879) | 9 | 7 | 6 | 28861 | 25 | |||
5929 | 56671 | Permitted Site 7 | Tree(s) :: 17 | 4019 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003016.37543683 | 2102387.64310455 | 37.7529266215546 | -122.432465865209 | (37.7529266215546, -122.432465865209) | 2 | 4 | 5 | 28862 | 22 | |||||
5994 | 183334 | DPW Maintained 1 | Tree(s) :: 17 | 1211 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982688 | 2106849 | 37.7640025388616 | -122.503094328734 | (37.7640025388616, -122.503094328734) | 1 | 8 | 3 | 56 | 35 | |||
6001 | 262052 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 3 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
6074 | 184628 | DPW Maintained 1 | Tree(s) :: 17 | 1796 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984434.1354 | 2102998.0252 | 37.7535313177823 | -122.496770827925 | (37.7535313177823, -122.496770827925) | 1 | 8 | 3 | 56 | 35 | |||
6145 | 117568 | Undocumented 4 | Tree(s) :: 17 | 2636 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990923 | 2095039.4 | 37.7320570487265 | -122.473750606168 | (37.7320570487265, -122.473750606168) | 1 | 8 | 4 | 64 | 40 | |||||
6147 | 181792 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2020 12:00:00 AM | 3 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | ||
6183 | 261798 | DPW Maintained 1 | Tree(s) :: 17 | 2211 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 4x6 | 5986332 | 2100174 | 37.7458883278603 | -122.489999995029 | (37.7458883278603, -122.489999995029) | 1 | 8 | 3 | 29491 | 35 | ||
6241 | 261939 | DPW Maintained 1 | Tree(s) :: 17 | 1 Verna St | 4 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
6266 | 112694 | Undocumented 4 | Tree(s) :: 17 | 1x CUMBERLAND ST | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6005299 | 2104587 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | 2 | 4 | 5 | 28859 | 19 | ||||
6284 | 181791 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | |||
6304 | 105356 | Undocumented 4 | Tree(s) :: 17 | 207-211 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006236 | 2101921 | 37.7518273734539 | -122.421298642673 | (37.7518273734539, -122.421298642673) | 2 | 4 | 5 | 28859 | 19 | |||
6361 | 116132 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
6380 | 110632 | Undocumented 4 | Tree(s) :: 17 | 1051X Mandalay Ln | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5991736.20076 | 2101819.33429 | 37.7507200830769 | -122.47143306251 | (37.7507200830769, -122.47143306251) | 1 | 8 | 4 | 29491 | 12 | |||||
6455 | 117452 | Undocumented 4 | Tree(s) :: 17 | 1530 HUDSON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016055 | 2097226 | 37.7394845622146 | -122.387015456594 | (37.7394845622146, -122.387015456594) | 10 | 3 | 8 | 58 | 1 | ||||
6510 | 261804 | DPW Maintained 1 | Tree(s) :: 17 | 2363 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5986366 | 2099167 | 37.7431253612957 | -122.489808383417 | (37.7431253612957, -122.489808383417) | 1 | 8 | 3 | 29491 | 35 | ||
6662 | 261811 | DPW Maintained 1 | Tree(s) :: 17 | 2371 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5985746 | 2099098 | 37.7428996853912 | -122.491947068435 | (37.7428996853912, -122.491947068435) | 1 | 8 | 3 | 29491 | 35 | ||||
6714 | 261812 | DPW Maintained 1 | Tree(s) :: 17 | 2375 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5985747 | 2099073 | 37.7428311005617 | -122.491941770585 | (37.7428311005617, -122.491941770585) | 1 | 8 | 3 | 29491 | 35 | ||
6762 | 260431 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 181 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2019 12:00:00 AM | 3 | 3x3 | 6013986 | 2115554 | 37.7896944377585 | -122.395452879395 | (37.7896944377585, -122.395452879395) | 12 | 2 | 9 | 28855 | 6 | ||
6994 | 261813 | DPW Maintained 1 | Tree(s) :: 17 | 2395 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5985739 | 2098982 | 37.7425807714008 | -122.491962733637 | (37.7425807714008, -122.491962733637) | 1 | 8 | 3 | 29491 | 35 | ||
7116 | 261799 | DPW Maintained 1 | Tree(s) :: 17 | 2263 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 4x6 | 5986343 | 2099848 | 37.7449938617898 | -122.489937986338 | (37.7449938617898, -122.489937986338) | 1 | 8 | 3 | 29491 | 35 | ||
7291 | 105130 | Significant Tree 6 | Tree(s) :: 17 | 4045 MORAGA ST | Sidewalk: Property side : Yard | Tree | Private 2 | 5981665.2 | 2103465.9 | 37.7546533409301 | -122.506380933635 | (37.7546533409301, -122.506380933635) | 1 | 8 | 3 | 56 | 35 | ||||||
7347 | 262056 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 7 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
7539 | 100598 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
7552 | 97352 | Permitted Site 7 | Tree(s) :: 17 | 2 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
7623 | 100994 | Undocumented 4 | Tree(s) :: 17 | 1675 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009464 | 2106858 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | 8 | 4 | 7 | 28853 | 19 | ||||
7837 | 96135 | DPW Maintained 1 | Tree(s) :: 17 | 1444X Innes Ave | 1 | Median : Yard | Tree | DPW 1 | 12 | 6016335.2 | 2096661 | 37.7379486980737 | -122.386007263552 | (37.7379486980737, -122.386007263552) | 10 | 3 | 8 | 58 | 1 | ||||
7919 | 73237 | DPW Maintained 1 | Tree(s) :: 17 | 2609 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000014.0127 | 2114014.6742 | 37.7846808214882 | -122.443683781718 | (37.7846808214882, -122.443683781718) | 15 | 6 | 11 | 29490 | 31 | |||
7931 | 260390 | Undocumented 4 | Tree(s) :: 17 | 501x Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009931 | 2112548 | 37.7812143059327 | -122.409270622322 | (37.7812143059327, -122.409270622322) | 14 | 2 | 9 | 28853 | 34 | ||||
7974 | 261809 | DPW Maintained 1 | Tree(s) :: 17 | 2359 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | Width 0ft | 5985743 | 2099172 | 37.7431026941426 | -122.491962888437 | (37.7431026941426, -122.491962888437) | 1 | 8 | 3 | 29491 | 35 | ||
8161 | 262050 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 1 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
8193 | 79990 | DPW Maintained 1 | Tree(s) :: 17 | 3655 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5981694.1032 | 2096684.9357 | 37.7360364047838 | -122.505778307285 | (37.7360364047838, -122.505778307285) | 1 | 8 | 3 | 29491 | 35 | |||
8241 | 56665 | Permitted Site 7 | Tree(s) :: 17 | 4549 Callan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
8260 | 56735 | Permitted Site 7 | Tree(s) :: 17 | 4601 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015154.58866017 | 2096112.48595754 | 37.7363771809952 | -122.390050945039 | (37.7363771809952, -122.390050945039) | 10 | 3 | 8 | 58 | 1 | |||||
8264 | 103300 | Undocumented 4 | Tree(s) :: 17 | 3240 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007996.9 | 2100607.8 | 37.748320741451 | -122.415116245427 | (37.748320741451, -122.415116245427) | 2 | 4 | 7 | 28859 | 19 | ||||
8352 | 84946 | Permitted Site 7 | Tree(s) :: 17 | 1812 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003475 | 2114918 | 37.7873579154126 | -122.431774444579 | (37.7873579154126, -122.431774444579) | 13 | 9 | 11 | 29490 | 27 | |||||
8436 | 260432 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 181 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2019 12:00:00 AM | 3 | 3x3 | 6013986 | 2115554 | 37.7896944377585 | -122.395452879395 | (37.7896944377585, -122.395452879395) | 12 | 2 | 9 | 28855 | 6 | ||
8600 | 260856 | DPW Maintained 1 | Tree(s) :: 17 | 626 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5985689.47211 | 2111611.95975 | 37.7772562449138 | -122.493064158363 | (37.7772562449138, -122.493064158363) | 11 | 6 | 2 | 55 | 26 | |||||
8614 | 255775 | Undocumented 4 | Tree(s) :: 17 | 300 Fairmount St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004016 | 2097157 | 37.7386211197367 | -122.428636146259 | (37.7386211197367, -122.428636146259) | 2 | 7 | 5 | 63 | 7 | ||||
8860 | 260613 | DPW Maintained 1 | Tree(s) :: 17 | 1271 Revere Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6016832.40592 | 2093073.03805 | 37.7281243722496 | -122.384038382899 | (37.7281243722496, -122.384038382899) | 10 | 3 | 8 | 58 | 1 | |||
9258 | 109525 | Permitted Site 7 | Tree(s) :: 17 | 1550 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991168.8 | 2098442.9 | 37.7414164276204 | -122.473148952772 | (37.7414164276204, -122.473148952772) | 1 | 8 | 4 | 29491 | 40 | |||||
9260 | 262526 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
9265 | 261652 | DPW Maintained 1 | Tree(s) :: 17 | 191 Lobos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5995473 | 2088701 | 37.7149157919268 | -122.45756193275 | (37.7149157919268, -122.45756193275) | 9 | 8 | 6 | 28861 | 24 | ||||
9335 | 112908 | Undocumented 4 | Tree(s) :: 17 | 1899X Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
9384 | 111852 | Permitted Site 7 | Tree(s) :: 17 | 187 States St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000958.85547421 | 2106373.84069392 | 37.7637548596233 | -122.439866921627 | (37.7637548596233, -122.439866921627) | 15 | 5 | 5 | 28862 | 3 | |||||
9406 | 111316 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 4 | 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 | ||
9441 | 258084 | Undocumented 4 | Tree(s) :: 17 | 1300x 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1972 12:00:00 AM | 3x3 | 5993647 | 2106626 | 37.7640282963708 | -122.465174495477 | (37.7640282963708, -122.465174495477) | 1 | 8 | 11 | 56 | 12 | |||
9557 | 112910 | Undocumented 4 | Tree(s) :: 17 | 1899X Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
9889 | 116075 | Significant Tree 6 | Tree(s) :: 17 | 88 MONTCALM ST | 1 | Front Yard : Yard | Tree | Private 2 | 6010492 | 2099980 | 37.7467368416425 | -122.406443980671 | (37.7467368416425, -122.406443980671) | 2 | 7 | 7 | 28859 | 2 | |||||
9919 | 106007 | Undocumented 4 | Tree(s) :: 17 | 1800X LANE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014836 | 2094060 | 37.7307237967737 | -122.391009037699 | (37.7307237967737, -122.391009037699) | 10 | 3 | 8 | 58 | 1 | ||||
10059 | 261650 | DPW Maintained 1 | Tree(s) :: 17 | 545 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | Width 0ft | 5993997 | 2090147 | 37.7188012663705 | -122.462768408851 | (37.7188012663705, -122.462768408851) | 9 | 8 | 6 | 64 | 24 | ||
10185 | 97351 | Permitted Site 7 | Tree(s) :: 17 | 1 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
10202 | 261492 | DPW Maintained 1 | Tree(s) :: 17 | 1100X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
10422 | 56667 | Permitted Site 7 | Tree(s) :: 17 | 495 Callan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10439 | 56506 | Permitted Site 7 | Tree(s) :: 17 | 556 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000140.95591591 | 2095509.77922044 | 37.733878172831 | -122.441915966113 | (37.733878172831, -122.441915966113) | 9 | 7 | 5 | 63 | 40 | |||||
10527 | 261801 | DPW Maintained 1 | Tree(s) :: 17 | 2311 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5986355 | 2099480 | 37.7439841331992 | -122.489869433077 | (37.7439841331992, -122.489869433077) | 1 | 8 | 3 | 29491 | 35 | ||
10614 | 260597 | DPW Maintained 1 | Tree(s) :: 17 | 1289 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013389.69367 | 2090749.59472 | 37.7215537330103 | -122.395777310596 | (37.7215537330103, -122.395777310596) | 10 | 3 | 8 | 58 | 1 | ||
10683 | 111476 | Permitted Site 7 | Tree(s) :: 17 | 2x TRAINOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | |||
10723 | 113037 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
10729 | 262053 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 4 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
10796 | 56567 | Permitted Site 7 | Tree(s) :: 17 | 309 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992136.3013072 | 2094883.62123857 | 37.7316995160329 | -122.469544661545 | (37.7316995160329, -122.469544661545) | 9 | 8 | 4 | 59 | 40 | |||||
10988 | 261428 | Undocumented 4 | Tree(s) :: 17 | 1001 Potrero Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
11038 | 262060 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 11 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
11148 | 101952 | Undocumented 4 | Tree(s) :: 17 | 55 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003780.5 | 2096861.5 | 37.7377964134917 | -122.429429325656 | (37.7377964134917, -122.429429325656) | 2 | 7 | 5 | 63 | 7 | |||
11163 | 97769 | Undocumented 4 | Tree(s) :: 17 | 362 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6007113.7 | 2105238.5 | 37.7609859097905 | -122.418498646119 | (37.7609859097905, -122.418498646119) | 2 | 4 | 7 | 28859 | 19 | |||
11169 | 112778 | DPW Maintained 1 | Tree(s) :: 17 | 1899X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | 11 | 6 | 2 | 54 | 11 | |||||
11689 | 260606 | DPW Maintained 1 | Tree(s) :: 17 | 1038 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013981.83254 | 2090017.73229 | 37.7195771072229 | -122.393679232644 | (37.7195771072229, -122.393679232644) | 10 | 3 | 8 | 58 | 1 | |||
11728 | 248542 | DPW Maintained 1 | Tree(s) :: 17 | 258 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998812.5011 | 2107653.6201 | 37.7671464005807 | -122.44738259118 | (37.7671464005807, -122.44738259118) | 15 | 5 | 11 | 29492 | 9 | |||
11804 | 261806 | DPW Maintained 1 | Tree(s) :: 17 | 2206 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2020 12:00:00 AM | 3 | 4x6 | 5986107 | 2100189 | 37.7459163725485 | -122.490779106515 | (37.7459163725485, -122.490779106515) | 1 | 8 | 3 | 29491 | 35 | |
12037 | 260602 | DPW Maintained 1 | Tree(s) :: 17 | 1152 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013444.93607 | 2090417.98033 | 37.7206462592683 | -122.395563129546 | (37.7206462592683, -122.395563129546) | 10 | 3 | 8 | 58 | 1 | |||
12044 | 94493 | Permitted Site 7 | Tree(s) :: 17 | 242 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986861.9 | 2114315.4 | 37.7847476191928 | -122.489207219387 | (37.7847476191928, -122.489207219387) | 11 | 6 | 1 | 55 | 33 | |||||
12099 | 102848 | Undocumented 4 | Tree(s) :: 17 | 31 Guy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6014185 | 2114270 | 37.7861799368485 | -122.394674400267 | (37.7861799368485, -122.394674400267) | 6 | 2 | 9 | 28855 | 6 | |||
12191 | 113350 | Undocumented 4 | Tree(s) :: 17 | 7802x GEARY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x8 | 5982855 | 2112422 | 37.7793142001238 | -122.502929326548 | (37.7793142001238, -122.502929326548) | 11 | 6 | 2 | 55 | 26 | |||
12231 | 96231 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
12274 | 56690 | Permitted Site 7 | Tree(s) :: 17 | 55 Hallam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010204.8585712 | 2110471.70826771 | 37.7755286348545 | -122.408176723323 | (37.7755286348545, -122.408176723323) | 8 | 2 | 9 | 28853 | 34 | |||||
12315 | 56545 | Permitted Site 7 | Tree(s) :: 17 | 99 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006997.81069025 | 2098938.41719823 | 37.7436807955871 | -122.418452724226 | (37.7436807955871, -122.418452724226) | 2 | 7 | 7 | 28859 | 2 | |||||
12345 | 107864 | Permitted Site 7 | Tree(s) :: 17 | 362 BRANNAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014441.4 | 2112297.4 | 37.7807778793576 | -122.393649202889 | (37.7807778793576, -122.393649202889) | 6 | 2 | 9 | 28856 | 6 | |||||
12566 | 56696 | Permitted Site 7 | Tree(s) :: 17 | 1831 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5983776.96653861 | 2102691.49481904 | 37.7526511432753 | -122.499020778367 | (37.7526511432753, -122.499020778367) | 1 | 8 | 3 | 56 | 35 | |||||
12610 | 262055 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 6 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
12696 | 100611 | 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 | |||||
12824 | 71999 | DPW Maintained 1 | Tree(s) :: 17 | 1919 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987523.8589 | 2102195.0257 | 37.7515070489426 | -122.486027091209 | (37.7515070489426, -122.486027091209) | 1 | 8 | 3 | 29491 | 35 | |||
12827 | 261426 | Undocumented 4 | Tree(s) :: 17 | 1001 Potrero Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
12859 | 97357 | Permitted Site 7 | Tree(s) :: 17 | 7 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
12879 | 261642 | DPW Maintained 1 | Tree(s) :: 17 | 689 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5995176 | 2089914 | 37.7182293382848 | -122.45867624436 | (37.7182293382848, -122.45867624436) | 9 | 8 | 6 | 28861 | 24 | ||||
13070 | 181793 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | |||
13071 | 115457 | Permitted Site 7 | Tree(s) :: 17 | 476 FAIR OAKS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005502 | 2100939 | 37.7490896185955 | -122.423767101444 | (37.7490896185955, -122.423767101444) | 2 | 4 | 5 | 28859 | 19 | ||||
13206 | 181790 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | |||
13285 | 261800 | DPW Maintained 1 | Tree(s) :: 17 | 2275 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 4x6 | 5986345 | 2099772 | 37.7447853029759 | -122.489925482159 | (37.7447853029759, -122.489925482159) | 1 | 8 | 3 | 29491 | 35 | ||
13334 | 106393 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 20 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
13376 | 29902 | DPW Maintained 1 | Tree(s) :: 17 | 1716 Divisadero St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6001149.68281092 | 2114264.52722613 | 37.7854315611698 | -122.439772670022 | (37.7854315611698, -122.439772670022) | 15 | 6 | 1 | 29490 | 27 | ||||||
13426 | 260872 | Private 9 | Tree(s) :: 17 | 1736 Fitzgerald Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011805.50809 | 2092676.7551 | 37.7267570649137 | -122.401388810186 | (37.7267570649137, -122.401388810186) | 10 | 3 | 8 | 58 | 1 | |||
13861 | 97353 | Permitted Site 7 | Tree(s) :: 17 | 3 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
13877 | 262059 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 10 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
13931 | 70381 | DPW Maintained 1 | Tree(s) :: 17 | 1454 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5982184.823 | 2105192.1683 | 37.7594237635385 | -122.504711868385 | (37.7594237635385, -122.504711868385) | 1 | 8 | 3 | 56 | 35 | |||
14217 | 107031 | Undocumented 4 | Tree(s) :: 17 | 4022 19TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6002868.3 | 2104782.6 | 37.7594942034983 | -122.433149044029 | (37.7594942034983, -122.433149044029) | 2 | 4 | 5 | 28862 | 3 | |||||
14240 | 174970 | DPW Maintained 1 | Tree(s) :: 17 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 5999272.73496 | 2090903.68447 | 37.7211813957975 | -122.444586716009 | (37.7211813957975, -122.444586716009) | 9 | 7 | 6 | 28861 | 25 | |||
14442 | 260627 | DPW Maintained 1 | Tree(s) :: 17 | 1557 Hudson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6015914.7542 | 2097249.1447 | 37.7395403460526 | -122.387501983912 | (37.7395403460526, -122.387501983912) | 10 | 3 | 8 | 58 | 1 | |||
14469 | 173738 | DPW Maintained 1 | Tree(s) :: 17 | 2500X Lyon St | 5 | Median : Yard | Tree | Private 2 | 3x3 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 |
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) );