trees
406 rows where qSpecies_id = 110
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37738 | 256569 | Planning Code 138.1 required 2 | Acer buergeranum :: Trident Maple 110 | 2099X Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002352 | 2115365 | 37.7885215412843 | -122.435691777518 | (37.7885215412843, -122.435691777518) | 13 | 6 | 1 | 29490 | 27 | ||||
| 38109 | 221637 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 4055 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002643.00734 | 2104710.17858 | 37.759282569163 | -122.433923039915 | (37.759282569163, -122.433923039915) | 2 | 4 | 5 | 28862 | 3 | |||
| 38374 | 95617 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 2797 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767383 | 6008167 | 2106709.1 | 37.7650830781762 | -122.41495981887 | (37.7650830781762, -122.41495981887) | 8 | 4 | 7 | 28859 | 19 | |
| 38384 | 221588 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1298 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010295.88664 | 2101729.17377 | 37.751528715192 | -122.407245408661 | (37.751528715192, -122.407245408661) | 2 | 4 | 7 | 28859 | 19 | |||
| 38932 | 57960 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 340 Hanover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 1 | Permit Number 772773 | 5999451.90276 | 2086477.9387 | 37.7090395229363 | -122.443649609852 | (37.7090395229363, -122.443649609852) | 9 | 7 | 6 | 28861 | 5 | ||
| 39584 | 256022 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 99 Heron St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010037 | 2109967 | 37.7741334231767 | -122.408721775232 | (37.7741334231767, -122.408721775232) | 8 | 2 | 9 | 28853 | 34 | ||||
| 39799 | 221617 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 800 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008123.88983 | 2097149.51218 | 37.7388321854502 | -122.414432447809 | (37.7388321854502, -122.414432447809) | 2 | 7 | 7 | 28859 | 2 | |||
| 40130 | 1162 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2849X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5997216.55451 | 2087707.32344 | 37.7122873858304 | -122.451463876663 | (37.7122873858304, -122.451463876663) | 9 | 7 | 6 | 28861 | 25 | ||
| 40423 | 221641 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 296 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004397.62951 | 2103975.64883 | 37.7573651408118 | -122.427802367408 | (37.7573651408118, -122.427802367408) | 2 | 4 | 5 | 28862 | 3 | |||
| 40913 | 95819 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 266 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767557 | 6009737.75412 | 2108910.90925 | 37.7712168784866 | -122.409682366366 | (37.7712168784866, -122.409682366366) | 8 | 2 | 9 | 28853 | 34 |
| 41612 | 150666 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 555 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781212 | 6011817.65557 | 2105788.11066 | 37.7627587105623 | -122.402268264562 | (37.7627587105623, -122.402268264562) | 8 | 3 | 8 | 28856 | 29 |
| 43027 | 221627 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 3348 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006051.64751 | 2103193.30025 | 37.7553104210429 | -122.422026534497 | (37.7553104210429, -122.422026534497) | 2 | 4 | 5 | 28859 | 19 | |||
| 43101 | 200960 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1527 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6008413.1986 | 2109048.8424 | 37.7715212967515 | -122.414273832498 | (37.7715212967515, -122.414273832498) | 8 | 2 | 9 | 28853 | 19 | |||
| 43458 | 140825 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 500 Euclid Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5996795.1609 | 2113868.6412 | 37.784095740758 | -122.454809318923 | (37.784095740758, -122.454809318923) | 11 | 6 | 1 | 54 | 31 | |||
| 44232 | 254806 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1199 Sanchez St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779042 | 6003870.87143 | 2101301.44093 | 37.7499925830654 | -122.429433403164 | (37.7499925830654, -122.429433403164) | 2 | 4 | 5 | 28862 | 22 | |
| 44443 | 85683 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 660 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012787.21783 | 2111572.91246 | 37.7786965462587 | -122.399320984791 | (37.7786965462587, -122.399320984791) | 6 | 2 | 9 | 28856 | 34 | ||
| 44546 | 221589 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1298 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010298.25709 | 2101707.85409 | 37.7514703087269 | -122.407235708582 | (37.7514703087269, -122.407235708582) | 2 | 4 | 7 | 28859 | 19 | |||
| 45621 | 221605 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 126 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007327.7514 | 2096972.1243 | 37.7383003605723 | -122.417172563378 | (37.7383003605723, -122.417172563378) | 2 | 7 | 7 | 28859 | 2 | |||
| 46059 | 187800 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2 Heron St | 1 | : | Tree | Private 2 | 2 | Width 2ft | 6009988.42633 | 2110014.66553 | 37.7742615809293 | -122.408893164515 | (37.7742615809293, -122.408893164515) | 8 | 2 | 9 | 28853 | 34 | |||
| 46372 | 24550 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 322 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2003 12:00:00 AM | 12 | 3X3 | 6007090.05329 | 2097287.38684 | 37.739152626479 | -122.418016751571 | (37.739152626479, -122.418016751571) | 2 | 7 | 7 | 28859 | 2 | ||
| 46381 | 221649 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2012 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004056.31613 | 2107188.28381 | 37.7661669549612 | -122.429211835283 | (37.7661669549612, -122.429211835283) | 8 | 4 | 5 | 28862 | 3 | |||
| 46794 | 125330 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1335 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007763.34926 | 2117482.29154 | 37.7946409829411 | -122.417119380172 | (37.7946409829411, -122.417119380172) | 5 | 1 | 10 | 28858 | 32 | |||
| 47111 | 120843 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 295 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5989915.80244 | 2113424.7782 | 37.7824800057862 | -122.47857668806 | (37.7824800057862, -122.47857668806) | 11 | 6 | 2 | 55 | 26 | |||
| 47480 | 221579 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 365 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6005497.37078 | 2101576.73958 | 37.7508404433343 | -122.423828450348 | (37.7508404433343, -122.423828450348) | 2 | 4 | 5 | 28859 | 19 | |||
| 48221 | 1251 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 3802X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3X5 | 5992934.9168 | 2087623.17149 | 37.7118102118326 | -122.466256259321 | (37.7118102118326, -122.466256259321) | 9 | 8 | 4 | 64 | 24 | ||
| 48361 | 32476 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 81 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2016 12:00:00 AM | 2 | Permit Number 773566 | 6000872.74109 | 2105927.69482 | 37.7625249506752 | -122.440132769612 | (37.7625249506752, -122.440132769612) | 15 | 5 | 5 | 28862 | 3 | |
| 49505 | 110655 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 500 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2015 12:00:00 AM | 3 | 3x3 | 6012010 | 2105998.3 | 37.7633465783976 | -122.401617783163 | (37.7633465783976, -122.401617783163) | 8 | 3 | 8 | 28856 | 29 | |
| 49532 | 256566 | Planning Code 138.1 required 2 | Acer buergeranum :: Trident Maple 110 | 2099X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002352 | 2115365 | 37.7885215412843 | -122.435691777518 | (37.7885215412843, -122.435691777518) | 13 | 6 | 1 | 29490 | 27 | ||||
| 51656 | 85694 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 474 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013953.88261 | 2112679.45572 | 37.7817998152473 | -122.39536254686 | (37.7817998152473, -122.39536254686) | 6 | 2 | 9 | 28856 | 6 | ||
| 51777 | 82113 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 879 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49917 | 6009150.8680199 | 2104052.95048314 | 37.7578451346072 | -122.411369187565 | (37.7578451346072, -122.411369187565) | 2 | 4 | 7 | 28859 | 19 | ||
| 51860 | 51384 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1535 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2004 12:00:00 AM | 5 | 3x3 | Permit Number 47713 | 6008370.90757832 | 2109003.97067657 | 37.7713957138636 | -122.41441694433 | (37.7713957138636, -122.41441694433) | 8 | 2 | 9 | 28853 | 19 | |
| 52049 | 85688 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 510 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013697.52765 | 2112441.63878 | 37.7811325632525 | -122.396232748844 | (37.7811325632525, -122.396232748844) | 6 | 2 | 9 | 28856 | 34 | ||
| 52479 | 221633 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6004094.26555 | 2103005.18329 | 37.7546833058068 | -122.428782337947 | (37.7546833058068, -122.428782337947) | 2 | 4 | 5 | 28862 | 22 | |||
| 53472 | 85682 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 660 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012794.81473 | 2111581.55636 | 37.7787207038246 | -122.39929531095 | (37.7787207038246, -122.39929531095) | 6 | 2 | 9 | 28856 | 34 | ||
| 53681 | 99375 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 3921 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768860 | 5996022.78804 | 2115189.92908 | 37.7876793085021 | -122.45757706543 | (37.7876793085021, -122.45757706543) | 11 | 6 | 1 | 54 | 31 | |
| 53714 | 256567 | Planning Code 138.1 required 2 | Acer buergeranum :: Trident Maple 110 | 2099X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002352 | 2115365 | 37.7885215412843 | -122.435691777518 | (37.7885215412843, -122.435691777518) | 13 | 6 | 1 | 29490 | 27 | ||||
| 54178 | 221650 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 81 Ord St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000873.42277 | 2105941.92407 | 37.7625640595034 | -122.44013143234 | (37.7625640595034, -122.44013143234) | 15 | 5 | 5 | 28862 | 3 | |||
| 54315 | 221602 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 316 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006655.32871 | 2096032.75811 | 37.7356832173971 | -122.419430851854 | (37.7356832173971, -122.419430851854) | 2 | 7 | 7 | 28859 | 2 | |||
| 55082 | 108822 | Section 143 10 | Acer buergeranum :: Trident Maple 110 | 101x FREMONT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6013648.6 | 2115847.1 | 37.7904804500674 | -122.396640813258 | (37.7904804500674, -122.396640813258) | 12 | 2 | 9 | 28855 | 6 | ||||
| 55237 | 254182 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2224 25th St | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 01/17/2018 12:00:00 AM | 3 | 3x10 | Permit Number 781201 | 6012201.53175 | 2101903.83488 | 37.7521147641156 | -122.400667680341 | (37.7521147641156, -122.400667680341) | 10 | 3 | 8 | 28856 | 29 |
| 55252 | 24557 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 420 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6007316.28855 | 2097251.94212 | 37.7390680335725 | -122.417232019338 | (37.7390680335725, -122.417232019338) | 2 | 7 | 7 | 28859 | 2 | |||
| 55621 | 42196 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1102 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42472 | 6009955.25206 | 2108867.50993 | 37.7711098996337 | -122.408926966424 | (37.7711098996337, -122.408926966424) | 8 | 2 | 9 | 28853 | 34 | |
| 56061 | 187796 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 660 Bryant St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6012585.74473 | 2111379.92366 | 37.7781554124722 | -122.40000440658 | (37.7781554124722, -122.40000440658) | 6 | 2 | 9 | 28856 | 34 | |||
| 56623 | 81834 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 298X Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2007 12:00:00 AM | 6x6 | Permit Number 49798 | 5997424.88906207 | 2109543.24349754 | 37.7722554301606 | -122.452318476797 | (37.7722554301606, -122.452318476797) | 15 | 5 | 11 | 29492 | 16 | ||
| 56995 | 104974 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 752 Carolina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770765 | 6012376.8 | 2104435.9 | 37.7590770349231 | -122.400239393453 | (37.7590770349231, -122.400239393453) | 10 | 3 | 8 | 28856 | 29 | |||
| 58173 | 221626 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1062 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007406.75349 | 2101144.50432 | 37.7497612281125 | -122.417194987955 | (37.7497612281125, -122.417194987955) | 2 | 4 | 7 | 28859 | 19 | |||
| 59266 | 140826 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 510 Euclid Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5996775.194 | 2113867.2875 | 37.7840908785082 | -122.454878298966 | (37.7840908785082, -122.454878298966) | 11 | 6 | 1 | 54 | 31 | |||
| 59795 | 34603 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 3200 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/2018 12:00:00 AM | 3 | Permit Number 782631 | 5999359.4945 | 2116028.32751 | 37.7901724342632 | -122.446093077744 | (37.7901724342632, -122.446093077744) | 13 | 6 | 1 | 29490 | 31 | |
| 59870 | 28322 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 904 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2003 12:00:00 AM | 16 | 3X3 | 6008321.70986 | 2097162.43684 | 37.7388787847205 | -122.413749390244 | (37.7388787847205, -122.413749390244) | 2 | 7 | 7 | 28859 | 2 | ||
| 60360 | 187811 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 501 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6015693.45346 | 2114236.6161 | 37.7861720222617 | -122.389453170937 | (37.7861720222617, -122.389453170937) | 6 | 2 | 9 | 28856 | 6 | |||
| 60886 | 23947 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2400X Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003237.41295 | 2115911.3949 | 37.7900720546314 | -122.432667433453 | (37.7900720546314, -122.432667433453) | 13 | 9 | 1 | 29490 | 27 | |
| 61619 | 122683 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 425 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000126 | 2110519 | 37.7750889825958 | -122.443045211806 | (37.7750889825958, -122.443045211806) | 15 | 5 | 11 | 29492 | 16 | ||||
| 61662 | 122935 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 366 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992808.12502 | 2113018.7034 | 37.7815325351796 | -122.468541044774 | (37.7815325351796, -122.468541044774) | 11 | 6 | 2 | 54 | 11 | |||
| 62176 | 158618 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 151 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781235 | 6000399.06528 | 2094337.95711 | 37.7306753264052 | -122.440939570324 | (37.7306753264052, -122.440939570324) | 9 | 7 | 4 | 63 | 40 |
| 62281 | 41280 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 850 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2013 12:00:00 AM | 2 | Permit Number 770203 | 6012418.57023 | 2119124.3074 | 37.7994103467575 | -122.401127041994 | (37.7994103467575, -122.401127041994) | 3 | 1 | 10 | 28860 | 6 | ||
| 62467 | 221591 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1705 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009346.65041 | 2099513.2038 | 37.745390981613 | -122.410371547427 | (37.745390981613, -122.410371547427) | 2 | 7 | 7 | 28859 | 2 | |||
| 62944 | 108821 | Section 143 10 | Acer buergeranum :: Trident Maple 110 | 101x FREMONT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | 5x5 | Permit Number 774616 | 6013648.6 | 2115847.1 | 37.7904804500674 | -122.396640813258 | (37.7904804500674, -122.396640813258) | 12 | 2 | 9 | 28855 | 6 | |
| 63214 | 23946 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2400X Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003257.60965 | 2115913.45554 | 37.7900788579916 | -122.432597701832 | (37.7900788579916, -122.432597701832) | 13 | 9 | 1 | 29490 | 27 | |
| 63829 | 187815 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1020 Le Conte Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 2ft | 6013104.71933 | 2089623.63357 | 37.7184462121049 | -122.396683503446 | (37.7184462121049, -122.396683503446) | 10 | 3 | 8 | 58 | 1 | |||
| 64105 | 28316 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 623 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2003 12:00:00 AM | 3 | 3X3 | 6007820.63247 | 2097225.98476 | 37.7390251215162 | -122.415486385782 | (37.7390251215162, -122.415486385782) | 2 | 7 | 7 | 28859 | 2 | ||
| 65826 | 175091 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 315 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998119.37359 | 2088859.05646 | 37.7155014387137 | -122.448426367903 | (37.7155014387137, -122.448426367903) | 9 | 7 | 6 | 28861 | 25 | |||
| 65863 | 104972 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 752 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770765 | 6012376.8 | 2104435.9 | 37.7590770349231 | -122.400239393453 | (37.7590770349231, -122.400239393453) | 10 | 3 | 8 | 28856 | 29 | |||
| 67549 | 175081 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 27 Sears St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 1ft | 5996779.12148 | 2087015.14863 | 37.71036177455 | -122.452925837056 | (37.71036177455, -122.452925837056) | 9 | 7 | 6 | 28861 | 25 | |||
| 67699 | 28320 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 461 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2003 12:00:00 AM | 4 | 3X3 | 6007471.94186 | 2097274.48269 | 37.7391386807167 | -122.416695436156 | (37.7391386807167, -122.416695436156) | 2 | 7 | 7 | 28859 | 2 | ||
| 67771 | 145619 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 683 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 4ft | 5994702.41526 | 2110888.70708 | 37.7757933745952 | -122.461833263111 | (37.7757933745952, -122.461833263111) | 11 | 6 | 2 | 54 | 11 | ||
| 69178 | 108920 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 749 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772808 | 6007640.7 | 2095906.5 | 37.7353919909288 | -122.416015094544 | (37.7353919909288, -122.416015094544) | 2 | 7 | 7 | 28859 | 2 |
| 69574 | 1284 | Significant Tree 6 | Acer buergeranum :: Trident Maple 110 | 3995X Alemany Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3X10 | Permit Number 778829 | 5992111.48083 | 2087185.84409 | 37.7105618710011 | -122.469070448459 | (37.7105618710011, -122.469070448459) | 9 | 8 | 4 | 64 | 24 | ||
| 69733 | 221651 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 26 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004255.76182 | 2098095.16165 | 37.7412106638496 | -122.427873994815 | (37.7412106638496, -122.427873994815) | 2 | 7 | 5 | 63 | 7 | |||
| 69945 | 41432 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1759 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/10/2015 12:00:00 AM | 2 | Permit Number 775670 | 6004639.03495 | 2118408.77646 | 37.7970086191102 | -122.427995972535 | (37.7970086191102, -122.427995972535) | 13 | 9 | 1 | 57 | 17 | |
| 70358 | 175088 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 375 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002107.93429 | 2091559.7629 | 37.7231442147086 | -122.434833155628 | (37.7231442147086, -122.434833155628) | 9 | 7 | 6 | 28861 | 5 | |||
| 70377 | 187817 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 205 Salinas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012612.74982 | 2090602.97089 | 37.7211078816055 | -122.398452729812 | (37.7211078816055, -122.398452729812) | 10 | 3 | 8 | 58 | 1 | |||
| 70425 | 221597 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1485 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003972.05422 | 2099640.99596 | 37.7454391151181 | -122.428965139531 | (37.7454391151181, -122.428965139531) | 2 | 7 | 5 | 63 | 22 | |||
| 70884 | 57132 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 712 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 11 | Permit Number 14405 | 6015417.19786 | 2105711.7795 | 37.7627493909002 | -122.389813282851 | (37.7627493909002, -122.389813282851) | 10 | 3 | 8 | 28856 | 29 | ||
| 71940 | 84452 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1851 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52645 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||
| 72312 | 221632 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1045 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003827.60048 | 2102209.17649 | 37.7524825622315 | -122.429647769055 | (37.7524825622315, -122.429647769055) | 2 | 4 | 5 | 28862 | 22 | |||
| 73655 | 253718 | Significant Tree 6 | Acer buergeranum :: Trident Maple 110 | 227 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | Permit Number 780760 | 6005690 | 2092595 | 37.7261894743752 | -122.422524168298 | (37.7261894743752, -122.422524168298) | 9 | 7 | 7 | 309 | 5 | ||
| 74149 | 140827 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 520 Euclid Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5996759.2882 | 2113866.2722 | 37.7840871783405 | -122.454933253599 | (37.7840871783405, -122.454933253599) | 11 | 6 | 1 | 54 | 31 | |||
| 74474 | 60745 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 422 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2003 12:00:00 AM | Permit Number 20409 | 6007334.40549184 | 2097245.88253216 | 37.7390524145146 | -122.417168949791 | (37.7390524145146, -122.417168949791) | 2 | 7 | 7 | 28859 | 2 | ||
| 74760 | 247359 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 247 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 782017 | 6002737.9071 | 2109456.3066 | 37.7723196648748 | -122.433934082382 | (37.7723196648748, -122.433934082382) | 15 | 5 | 11 | 29492 | 9 | |
| 74992 | 221614 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 801 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001153.3381 | 2102585.18251 | 37.7533631954543 | -122.438922740801 | (37.7533631954543, -122.438922740801) | 2 | 4 | 5 | 28862 | 22 | |||
| 75694 | 115390 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 431 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776328 | 6008802 | 2096760.6 | 37.737802388299 | -122.412060373619 | (37.737802388299, -122.412060373619) | 10 | 7 | 7 | 28859 | 2 | ||
| 76305 | 255877 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 690x Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6012554 | 2111333 | 37.7780248009388 | -122.400110927552 | (37.7780248009388, -122.400110927552) | 6 | 2 | 9 | 28856 | 34 | ||||
| 76936 | 221624 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 620 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007869.47892 | 2104261.83931 | 37.7583467427219 | -122.415815570036 | (37.7583467427219, -122.415815570036) | 2 | 4 | 7 | 28859 | 19 | |||
| 77882 | 221638 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 685 Sanchez St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6003710.0195 | 2104258.56211 | 37.7581030318426 | -122.430200576896 | (37.7581030318426, -122.430200576896) | 2 | 4 | 5 | 28862 | 3 | |||
| 78598 | 221613 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 803 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001111.65366 | 2102583.28849 | 37.7533556231836 | -122.439066758249 | (37.7533556231836, -122.439066758249) | 2 | 4 | 5 | 28862 | 22 | |||
| 78646 | 84451 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1851 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52645 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||
| 78687 | 50434 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 809 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 47087 | 6001988.949 | 2111327.3401 | 37.7774145243393 | -122.436658745183 | (37.7774145243393, -122.436658745183) | 15 | 5 | 11 | 29492 | 41 | |||
| 78782 | 86617 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1090 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010113.47615 | 2109019.50593 | 37.7715361072268 | -122.408390384123 | (37.7715361072268, -122.408390384123) | 14 | 2 | 9 | 28853 | 34 | ||
| 79554 | 221646 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 24 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003262.27959 | 2107436.41306 | 37.7668032747714 | -122.431975970832 | (37.7668032747714, -122.431975970832) | 15 | 5 | 5 | 28862 | 3 | |||
| 81063 | 44002 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1800 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2010 12:00:00 AM | Permit Number 53179 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | |||
| 81131 | 111060 | Permitted Site 7 | Acer buergeranum :: Trident Maple 110 | 1851 Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
| 81273 | 175084 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 3143 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5996169.48396 | 2087012.03723 | 37.7103182761303 | -122.455032634746 | (37.7103182761303, -122.455032634746) | 9 | 7 | 6 | 28861 | 25 | |||
| 81599 | 86619 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1090 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010092.09688 | 2109000.58526 | 37.7714829581888 | -122.408463001672 | (37.7714829581888, -122.408463001672) | 14 | 2 | 9 | 28853 | 34 | ||
| 81907 | 120849 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 459 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5989969.64467 | 2112229.77717 | 37.7792019914887 | -122.47830301452 | (37.7792019914887, -122.47830301452) | 11 | 6 | 2 | 55 | 26 | |||
| 82300 | 221644 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 841 Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004368.61683 | 2104071.54426 | 37.7576268057401 | -122.427909537788 | (37.7576268057401, -122.427909537788) | 2 | 4 | 5 | 28862 | 3 | |||
| 82491 | 246995 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 45 Clipper St | 1 | : | Tree | Private 2 | 2 | Width 4ft | 6004848.08627 | 2101031.42376 | 37.7493064571266 | -122.426034921685 | (37.7493064571266, -122.426034921685) | 2 | 4 | 5 | 28862 | 22 | |||
| 82709 | 116214 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 3801 SACRAMENTO ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996623 | 2114922 | 37.7869781063352 | -122.455481088021 | (37.7869781063352, -122.455481088021) | 11 | 6 | 1 | 54 | 31 | |
| 83118 | 114545 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1219 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 2 | Permit Number 772772 | 6011988.90891 | 2102695.16148 | 37.7542757132549 | -122.401458575266 | (37.7542757132549, -122.401458575266) | 10 | 3 | 8 | 28856 | 29 | ||
| 83242 | 113035 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 251 06th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 1 | 3x3 | 5993975.80165 | 2113783.25834 | 37.7836991768592 | -122.464557007516 | (37.7836991768592, -122.464557007516) | 11 | 6 | 2 | 54 | 11 | |||
| 83540 | 9618 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1400 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2018 12:00:00 AM | 3 | 3X3 | Permit Number 782015 | 6002831.8444 | 2112032.7875 | 37.7793993714118 | -122.433793329826 | (37.7793993714118, -122.433793329826) | 15 | 5 | 11 | 29490 | 41 |
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) );