trees
8,298 rows where qLegalStatus_id = 4 sorted by qSpecies_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52 | 264970 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1026 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014048 | 2089990 | 37.7195046364539 | -122.393448574201 | (37.7195046364539, -122.393448574201) | 10 | 3 | 8 | 58 | 1 | ||||
| 1229 | 264907 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 1551 | 260493 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1799 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2019 12:00:00 AM | 3 | 3x3 | 6006327 | 2116970 | 37.7931534514646 | -122.422052933674 | (37.7931534514646, -122.422052933674) | 13 | 9 | 10 | 28858 | 32 | ||
| 2168 | 254831 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
| 2879 | 261758 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 49 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007215 | 2095432 | 37.7340651744382 | -122.417453284567 | (37.7340651744382, -122.417453284567) | 2 | 7 | 7 | 28859 | 2 | ||||
| 2913 | 264905 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 3728 | 264799 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 698 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009708 | 2091117 | 37.7223570514359 | -122.408529889307 | (37.7223570514359, -122.408529889307) | 10 | 3 | 7 | 309 | 28 | ||||
| 3957 | 101709 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95X Milton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003767.7 | 2095277.7 | 37.7334469335284 | -122.429360672359 | (37.7334469335284, -122.429360672359) | 2 | 7 | 5 | 28861 | 25 | ||||
| 4232 | 264908 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 4620 | 115387 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 34 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x8 | 5992895.1 | 2098893.2 | 37.7427526388588 | -122.467212790357 | (37.7427526388588, -122.467212790357) | 1 | 8 | 4 | 59 | 40 | |||
| 5077 | 254635 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5330 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:21:00 PM | 3 | 3x3 | 5999632 | 2088389 | 37.7142971380253 | -122.443164330284 | (37.7142971380253, -122.443164330284) | 9 | 7 | 6 | 28861 | 25 | ||
| 5119 | 254683 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1985 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:28:00 PM | 3 | 3x3 | 5999858 | 2092352 | 37.7251915169836 | -122.442667568748 | (37.7251915169836, -122.442667568748) | 9 | 7 | 6 | 28861 | 25 | ||
| 5493 | 264903 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 6071 | 258212 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2501 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987967 | 2106401 | 37.7630813299835 | -122.484803190012 | (37.7630813299835, -122.484803190012) | 1 | 8 | 3 | 56 | 35 | ||||
| 6616 | 116997 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 21 ROSEMONT PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778206 | 6005158 | 2108058 | 37.7686172926755 | -122.425463223206 | (37.7686172926755, -122.425463223206) | 8 | 4 | 5 | 28853 | 19 | |
| 6675 | 264798 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 698 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009708 | 2091117 | 37.7223570514359 | -122.408529889307 | (37.7223570514359, -122.408529889307) | 10 | 3 | 7 | 309 | 28 | ||||
| 6742 | 264909 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 7675 | 260491 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1799 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2019 12:00:00 AM | 3 | 3x3 | 6006327 | 2116970 | 37.7931534514646 | -122.422052933674 | (37.7931534514646, -122.422052933674) | 13 | 9 | 10 | 28858 | 32 | ||
| 8033 | 242084 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4185 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 02/16/2016 06:05:00 AM | 1 | Width 3ft | 6002781.49194 | 2101209.46423 | 37.7496782989261 | -122.433193959528 | (37.7496782989261, -122.433193959528) | 2 | 4 | 5 | 28862 | 22 | ||
| 8895 | 260492 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1799 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2019 12:00:00 AM | 3 | 3x3 | 6006327 | 2116970 | 37.7931534514646 | -122.422052933674 | (37.7931534514646, -122.422052933674) | 13 | 9 | 10 | 28858 | 32 | ||
| 9014 | 261225 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2111 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2020 12:00:00 AM | 3 | 4x6 | 5982897 | 2100735 | 37.7472274959484 | -122.501919055433 | (37.7472274959484, -122.501919055433) | 1 | 8 | 3 | 29491 | 35 | ||
| 10487 | 260490 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1799 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2019 12:00:00 AM | 3 | 3x3 | 6006327 | 2116970 | 37.7931534514646 | -122.422052933674 | (37.7931534514646, -122.422052933674) | 13 | 9 | 10 | 28858 | 32 | ||
| 11018 | 258435 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2511 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2019 06:07:00 PM | 3 | 3x3 | 5987985 | 2106413 | 37.7631153270305 | -122.484741815217 | (37.7631153270305, -122.484741815217) | 1 | 8 | 3 | 56 | 35 | ||
| 11104 | 98125 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1298X Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010839.8 | 2102289.6 | 37.7530979479228 | -122.40540394341 | (37.7530979479228, -122.40540394341) | 10 | 4 | 8 | 28859 | 19 | |||
| 11477 | 261366 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 39 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007224 | 2095531 | 37.7343375131321 | -122.417429182406 | (37.7343375131321, -122.417429182406) | 2 | 7 | 7 | 28859 | 2 | ||||
| 12041 | 242082 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4185 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 1 | Width 3ft | 6002677.73551 | 2101204.84944 | 37.7496597414097 | -122.433552423029 | (37.7496597414097, -122.433552423029) | 2 | 4 | 5 | 28862 | 22 | |||
| 14781 | 256563 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2504 Bush St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2019 12:00:00 AM | 3 | 3x3 | 6001466 | 2114633 | 37.7864612926293 | -122.438704721697 | (37.7864612926293, -122.438704721697) | 13 | 6 | 1 | 29490 | 27 | |||
| 15329 | 264906 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 15387 | 254816 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2687 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5997223 | 2088538 | 37.7145686012354 | -122.451501477097 | (37.7145686012354, -122.451501477097) | 9 | 8 | 6 | 28861 | 24 | ||
| 15549 | 264810 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 56 Keystone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994250 | 2093087 | 37.7268883657721 | -122.462106990145 | (37.7268883657721, -122.462106990145) | 9 | 8 | 4 | 28861 | 40 | ||||
| 15773 | 242083 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4185 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 1 | Width 3ft | 6002726.52973 | 2101207.22034 | 37.7496690197098 | -122.433383860397 | (37.7496690197098, -122.433383860397) | 2 | 4 | 5 | 28862 | 22 | |||
| 16017 | 254863 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x5 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
| 16174 | 107381 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 14 MOSS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | 14 | 2 | 9 | 28853 | 34 | ||||||
| 17023 | 254832 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
| 17824 | 254830 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x5 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
| 17933 | 264904 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 19029 | 110863 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1608 20TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013178 | 2104809 | 37.7601461286042 | -122.397494610871 | (37.7601461286042, -122.397494610871) | 10 | 3 | 8 | 28856 | 29 | ||||
| 19907 | 102028 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 20806 | 102022 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 22229 | 255887 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Columbia Square St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
| 23430 | 111771 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1350 12TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992447 | 2106254 | 37.7629376108266 | -122.469297826347 | (37.7629376108266, -122.469297826347) | 1 | 8 | 11 | 56 | 12 | ||||
| 25244 | 107382 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 14 MOSS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | 14 | 2 | 9 | 28853 | 34 | ||||||
| 27147 | 251588 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1430 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990886 | 2105639 | 37.7611586563939 | -122.474651843595 | (37.7611586563939, -122.474651843595) | 1 | 8 | 4 | 56 | 12 | ||||
| 27830 | 111201 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800x CAYUGA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6001173 | 2092267 | 37.7250330011493 | -122.438115670551 | (37.7250330011493, -122.438115670551) | 9 | 7 | 6 | 28861 | 25 | |||
| 28026 | 99572 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
| 28490 | 111716 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2390x MASON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
| 28614 | 182551 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2565 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986541.5452 | 2105693.4321 | 37.7610554202125 | -122.489681251316 | (37.7610554202125, -122.489681251316) | 1 | 8 | 3 | 56 | 35 | |||
| 30347 | 107266 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
| 31856 | 110225 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
| 32450 | 103452 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2201X Turk Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999486.1 | 2111876.5 | 37.778779824377 | -122.445356386272 | (37.778779824377, -122.445356386272) | 15 | 5 | 11 | 54 | 16 | ||||
| 33610 | 107268 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
| 34479 | 105879 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2X HARRIET ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 6010365 | 2111813 | 37.7792204741337 | -122.407717349172 | (37.7792204741337, -122.407717349172) | 14 | 2 | 9 | 28853 | 34 | ||||
| 35605 | 116992 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300x BRODERICK ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6001353 | 2109892 | 37.7734372805127 | -122.438755818588 | (37.7734372805127, -122.438755818588) | 15 | 5 | 11 | 29492 | 10 | ||||
| 35858 | 102033 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 35891 | 180620 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6002386.35916 | 2087019.94096 | 37.7106946720927 | -122.433546414645 | (37.7106946720927, -122.433546414645) | 9 | 7 | 6 | 28861 | 5 | |||
| 36173 | 99571 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
| 38321 | 102024 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 41703 | 99570 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
| 42687 | 111231 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 398X VICENTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991792 | 2097792 | 37.7396652854914 | -122.470946758559 | (37.7396652854914, -122.470946758559) | 1 | 8 | 4 | 59 | 40 | ||||
| 48286 | 110226 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
| 48405 | 102030 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 49092 | 111772 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1350 12TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992447 | 2106254 | 37.7629376108266 | -122.469297826347 | (37.7629376108266, -122.469297826347) | 1 | 8 | 11 | 56 | 12 | ||||
| 49682 | 112303 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25x WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005453 | 2109246 | 37.7718959184753 | -122.424527356528 | (37.7718959184753, -122.424527356528) | 7 | 9 | 5 | 28852 | 10 | ||||
| 50333 | 73636 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 701x 27TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/1995 12:00:00 AM | 3x3 | 6001948 | 2099969 | 37.7462249605563 | -122.435987450823 | (37.7462249605563, -122.435987450823) | 2 | 7 | 5 | 63 | 22 | |||
| 50713 | 111202 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800x CAYUGA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001173 | 2092267 | 37.7250330011493 | -122.438115670551 | (37.7250330011493, -122.438115670551) | 9 | 7 | 6 | 28861 | 25 | ||||
| 51376 | 111203 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800x CAYUGA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001173 | 2092267 | 37.7250330011493 | -122.438115670551 | (37.7250330011493, -122.438115670551) | 9 | 7 | 6 | 28861 | 25 | ||||
| 51764 | 111198 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 801x CAYUGA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6001252 | 2092235 | 37.7249496290087 | -122.437840285791 | (37.7249496290087, -122.437840285791) | 9 | 7 | 6 | 28861 | 25 | |||
| 52361 | 102306 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1320 Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006027 | 2108860 | 37.7708684537788 | -122.422514413679 | (37.7708684537788, -122.422514413679) | 8 | 2 | 9 | 28853 | 19 | |||
| 52839 | 115077 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2371X MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008645 | 2121254 | 37.8050467143555 | -122.414335738873 | (37.8050467143555, -122.414335738873) | 3 | 1 | 10 | 308 | 23 | |||
| 59876 | 116749 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 60045 | 256037 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1555 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6x3 | 6015125 | 2093955 | 37.7304515202688 | -122.390002579169 | (37.7304515202688, -122.390002579169) | 10 | 3 | 8 | 58 | 1 | |||
| 60295 | 107695 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2440X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003685.72045 | 2116767.65354 | 37.7924485368973 | -122.43117747007 | (37.7924485368973, -122.43117747007) | 13 | 9 | 1 | 29490 | 27 | ||||
| 62256 | 107267 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
| 62277 | 116746 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 63059 | 102307 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1320 Stevenson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006027 | 2108860 | 37.7708684537788 | -122.422514413679 | (37.7708684537788, -122.422514413679) | 8 | 2 | 9 | 28853 | 19 | |||
| 63372 | 107270 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Long Bridge St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011042.63982 | 2114087.82857 | 37.7855045301642 | -122.405533360616 | (37.7855045301642, -122.405533360616) | 12 | 2 | 9 | 28853 | 34 | ||||
| 63709 | 109830 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 629 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | 5 | 1 | 10 | 28852 | 21 | |||||
| 65669 | 99568 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
| 68278 | 256637 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 350 Laguna Honda Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995221 | 2100899 | 37.7483940544242 | -122.459315767742 | (37.7483940544242, -122.459315767742) | 1 | 8 | 4 | 29491 | 40 | ||||
| 69069 | 101525 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 630 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 15 ft wide public RoW | 6001829 | 2099440 | 37.7447656902201 | -122.436361083968 | (37.7447656902201, -122.436361083968) | 2 | 7 | 5 | 63 | 22 | |||
| 72124 | 251752 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 128 South Hill Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | 9 | 7 | 6 | 28861 | 5 | ||||
| 73542 | 117587 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X NIDO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999045 | 2111933 | 37.778909769135 | -122.44688638485 | (37.778909769135, -122.44688638485) | 15 | 5 | 1 | 54 | 16 | ||||
| 75148 | 105367 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 249 BROAD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5994550.4 | 2088030.5 | 37.71302171758 | -122.460702242455 | (37.71302171758, -122.460702242455) | 9 | 8 | 6 | 28861 | 24 | |||
| 75677 | 103450 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2201X Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999486.1 | 2111876.5 | 37.778779824377 | -122.445356386272 | (37.778779824377, -122.445356386272) | 15 | 5 | 11 | 54 | 16 | |||||
| 75763 | 111787 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55X SHERMAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
| 76443 | 102025 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 77417 | 103451 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2201X Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999486.1 | 2111876.5 | 37.778779824377 | -122.445356386272 | (37.778779824377, -122.445356386272) | 15 | 5 | 11 | 54 | 16 | |||||
| 77754 | 251748 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002576.6751 | 2087720.05109 | 37.7126278178947 | -122.43293862582 | (37.7126278178947, -122.43293862582) | 9 | 7 | 6 | 28861 | 5 | ||||
| 77962 | 97291 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778496 | 6005288 | 2108881 | 37.7708843970709 | -122.425072128908 | (37.7708843970709, -122.425072128908) | 7 | 9 | 5 | 28852 | 10 | ||
| 80187 | 99562 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
| 81639 | 110224 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195x CHURCH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004291 | 2107903 | 37.7681426760471 | -122.428451057009 | (37.7681426760471, -122.428451057009) | 7 | 9 | 5 | 28862 | 3 | ||||
| 82873 | 101639 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 689X Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002123.8 | 2088649.6 | 37.7151544566445 | -122.434570326444 | (37.7151544566445, -122.434570326444) | 9 | 7 | 6 | 28861 | 5 | ||||
| 83034 | 102593 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995407.1 | 2092042.4 | 37.7240866981498 | -122.458031382697 | (37.7240866981498, -122.458031382697) | 9 | 8 | 4 | 28861 | 24 | ||||
| 83223 | 256638 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 350 Laguna Honda Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995221 | 2100899 | 37.7483940544242 | -122.459315767742 | (37.7483940544242, -122.459315767742) | 1 | 8 | 4 | 29491 | 40 | ||||
| 84100 | 77325 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/18/1988 12:00:00 AM | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | |
| 85468 | 95510 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500X 32nd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:35:00 PM | 3 | 3x3 | 5985969.9 | 2112493.2 | 37.7796922752829 | -122.492158984519 | (37.7796922752829, -122.492158984519) | 11 | 6 | 2 | 55 | 26 | ||
| 86558 | 121380 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1195x Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992103 | 2107224 | 37.7655810886811 | -122.470558244073 | (37.7655810886811, -122.470558244073) | 11 | 8 | 11 | 56 | 12 | ||||
| 86799 | 101641 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 689X Amazon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002123.8 | 2088649.6 | 37.7151544566445 | -122.434570326444 | (37.7151544566445, -122.434570326444) | 9 | 7 | 6 | 28861 | 5 | ||||
| 88349 | 117264 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1280 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007807 | 2115863 | 37.7901972632139 | -122.416853563641 | (37.7901972632139, -122.416853563641) | 13 | 1 | 10 | 28858 | 21 | ||||
| 88641 | 251741 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002771 | 2086560 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | 9 | 7 | 6 | 28861 | 5 |
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) );