trees
891 rows where qSpecies_id = 75 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 216 | 114440 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2961 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011605 | 2091859 | 37.724500488626 | -122.402024501601 | (37.724500488626, -122.402024501601) | 10 | 3 | 7 | 309 | 28 | ||||
| 353 | 112597 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200X Divisadero St | 7 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001322.3986 | 2112740.3429 | 37.7812563699828 | -122.439065850543 | (37.7812563699828, -122.439065850543) | 15 | 5 | 11 | 29490 | 41 | |||
| 366 | 141325 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 600x DIVISADERO ST | 2 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001625.7293 | 2110577.6985 | 37.775335548851 | -122.437861533023 | (37.775335548851, -122.437861533023) | 15 | 5 | 11 | 29492 | 10 | |||
| 399 | 137749 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1000x DIVISADERO ST | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001417.6643 | 2112072.2982 | 37.7794275088949 | -122.438688395719 | (37.7794275088949, -122.438688395719) | 15 | 5 | 11 | 29490 | 41 | |||
| 409 | 187885 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 23 | : | Tree | Private 2 | 3 | Width 3ft | 6015152.38977 | 2100397.43257 | 37.748142637288 | -122.390357841268 | (37.748142637288, -122.390357841268) | 10 | 3 | 8 | 58 | 1 | |||
| 456 | 247507 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400x Divisadero St | 2 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001724.6395 | 2109878.2699 | 37.7734207168265 | -122.437469283257 | (37.7734207168265, -122.437469283257) | 15 | 5 | 11 | 29492 | 10 | |||
| 544 | 259763 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2701 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2019 12:00:00 AM | 3 | |||||||||||||
| 710 | 256206 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 11 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
| 775 | 584 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3035 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/20/2019 10:48:00 AM | 3 | 4x4 | 6008750.98529 | 2102125.48957 | 37.7525303261177 | -122.412615900926 | (37.7525303261177, -122.412615900926) | 2 | 4 | 7 | 28859 | 19 | ||
| 1240 | 860 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2003 12:00:00 AM | 9 | 3x3 | 6008061.902 | 2095033.66744 | 37.7330190549875 | -122.414497094675 | (37.7330190549875, -122.414497094675) | 2 | 7 | 7 | 28859 | 2 | ||
| 1348 | 261327 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 12 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
| 1468 | 261333 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 831 Broadway | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009625 | 2118347 | 37.7971198129045 | -122.410738895692 | (37.7971198129045, -122.410738895692) | 3 | 1 | 10 | 308 | 4 | ||||
| 1770 | 122656 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 2135 | 187956 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014829.80215 | 2114536.31276 | 37.7869469986487 | -122.392462171218 | (37.7869469986487, -122.392462171218) | 6 | 2 | 9 | 28855 | 6 | |||
| 2474 | 256556 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 5 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:18:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
| 2867 | 8251 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1515 Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2014 12:00:00 AM | 3 | 3x3 | 6016234 | 2097322 | 37.7397580688138 | -122.386403238688 | (37.7397580688138, -122.386403238688) | 10 | 3 | 8 | 58 | 1 | ||
| 3977 | 262296 | Section 806 (d) 5 | Acer rubrum :: Red Maple 75 | 45 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782635 | 5998403.0154 | 2106238.4273 | 37.7632372305534 | -122.448696994498 | (37.7632372305534, -122.448696994498) | 15 | 5 | 11 | 29492 | 9 | |
| 5294 | 8118 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 841 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003718.373 | 2111409.0283 | 37.7777369494126 | -122.430681932079 | (37.7777369494126, -122.430681932079) | 7 | 9 | 11 | 29492 | 10 | ||
| 5375 | 175141 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 199 Hamilton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6009144.52669 | 2093573.47642 | 37.7290704439367 | -122.410651080984 | (37.7290704439367, -122.410651080984) | 9 | 3 | 7 | 309 | 28 | |||
| 5536 | 122646 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 5835 | 118375 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x6 | 6014712.48727 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | 6 | 2 | 9 | 28855 | 6 | |||
| 5868 | 261332 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 831 Broadway | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009625 | 2118347 | 37.7971198129045 | -122.410738895692 | (37.7971198129045, -122.410738895692) | 3 | 1 | 10 | 308 | 4 | ||||
| 6100 | 141590 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 700x DIVISADERO ST | 6 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6001558.8965 | 2111018.1096 | 37.7765410064467 | -122.438124278141 | (37.7765410064467, -122.438124278141) | 15 | 5 | 11 | 29492 | 10 | |||
| 6429 | 84888 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1699X Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643 | 2099756 | 37.7459057132351 | -122.419737575743 | (37.7459057132351, -122.419737575743) | 2 | 7 | 7 | 28859 | 2 | |
| 6716 | 208999 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 10 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 4ft | 5993404.32279 | 2097201.32336 | 37.7381365526709 | -122.465329186907 | (37.7381365526709, -122.465329186907) | 1 | 8 | 4 | 59 | 40 | |||
| 6991 | 112084 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.7905278405438 | -122.396700174955 | (37.7905278405438, -122.396700174955) | 12 | 2 | 9 | 28855 | 6 | |||
| 7657 | 261508 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2415X San Bruno Ave | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 01/15/2020 12:00:00 AM | 3 | 3x3 | 6010698 | 2094549 | 37.7318360017619 | -122.405349245342 | (37.7318360017619, -122.405349245342) | 10 | 3 | 7 | 309 | 28 | ||
| 7971 | 122653 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 8221 | 122657 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 8638 | 116994 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 600M Divisadero St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 6001630.0135 | 2110553.7073 | 37.7752699186497 | -122.43784499429 | (37.7752699186497, -122.43784499429) | 15 | 5 | 11 | 29492 | 10 | ||||
| 8771 | 3468 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3231 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/20/2019 10:37:00 AM | 3 | 4x4 | 6007477.09692 | 2102052.55322 | 37.752258481762 | -122.417016067856 | (37.752258481762, -122.417016067856) | 2 | 4 | 7 | 28859 | 19 | ||
| 9298 | 141986 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1067 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004102.6078 | 2111812.2185 | 37.7788657708335 | -122.429381491168 | (37.7788657708335, -122.429381491168) | 7 | 9 | 11 | 29490 | 41 | |||
| 9549 | 189101 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1444 Galvez Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015952.01721 | 2097639.00089 | 37.7406128754775 | -122.387400332559 | (37.7406128754775, -122.387400332559) | 10 | 3 | 8 | 58 | 1 | |||
| 9905 | 187906 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167 Jessie St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011990.7752 | 2114556.67649 | 37.7868448464448 | -122.402286048678 | (37.7868448464448, -122.402286048678) | 12 | 2 | 9 | 28855 | 6 | |||
| 10505 | 122650 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 10703 | 254081 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1525 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6009448.22373 | 2107633.16245 | 37.7676922528232 | -122.410593622391 | (37.7676922528232, -122.410593622391) | 8 | 4 | 8 | 28853 | 19 | ||||
| 11468 | 2384 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2603 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2005 12:00:00 AM | 3 | 4X4 | 6009796.77853 | 2102081.51983 | 37.7524682333455 | -122.408996251977 | (37.7524682333455, -122.408996251977) | 2 | 4 | 7 | 28859 | 19 | ||
| 11492 | 187952 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014738.2491 | 2114633.83833 | 37.7872096969197 | -122.392785751786 | (37.7872096969197, -122.392785751786) | 6 | 2 | 9 | 28855 | 6 | |||
| 11819 | 122647 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 12330 | 259764 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2701 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2019 12:00:00 AM | 3 | |||||||||||||
| 12580 | 122655 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 13152 | 122648 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 13200 | 261509 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2706 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/2020 12:00:00 AM | 3 | 4x4 | 6011147 | 2092931 | 37.7274184054289 | -122.403683147496 | (37.7274184054289, -122.403683147496) | 10 | 3 | 7 | 309 | 28 | ||
| 13368 | 122658 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 13427 | 208966 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 44 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/17/2018 12:00:00 AM | 3 | Width 6ft | Permit Number 781880 | 5993637 | 2097007 | 37.7376164050624 | -122.464510605988 | (37.7376164050624, -122.464510605988) | 1 | 8 | 4 | 59 | 40 | |
| 13486 | 122649 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 14226 | 122645 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 14297 | 261510 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2706 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/2020 12:00:00 AM | 3 | 4x4 | 6011147 | 2092931 | 37.7274184054289 | -122.403683147496 | (37.7274184054289, -122.403683147496) | 10 | 3 | 7 | 309 | 28 | ||
| 14316 | 256204 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 9 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
| 14390 | 122652 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 15420 | 220483 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3135 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008148.36276 | 2102088.69137 | 37.7523954467163 | -122.414697274784 | (37.7523954467163, -122.414697274784) | 2 | 4 | 7 | 28859 | 19 | |||
| 15425 | 256202 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 7 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
| 15677 | 255256 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 240 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2018 12:00:00 AM | 3 | 3x3 | 6012609 | 2118531 | 37.797791888474 | -122.400426386373 | (37.797791888474, -122.400426386373) | 3 | 1 | 10 | 28860 | 6 | ||
| 15780 | 220419 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1601 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009469.46402 | 2107213.18669 | 37.7665402869247 | -122.410490495353 | (37.7665402869247, -122.410490495353) | 8 | 4 | 8 | 28853 | 19 | |||
| 16082 | 122660 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 16448 | 253390 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2529x Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 16780 | 85805 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627 | 2111882 | 37.7794804977568 | -122.403356401218 | (37.7794804977568, -122.403356401218) | 14 | 2 | 9 | 28856 | 34 | |
| 17021 | 53357 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/1969 12:00:00 AM | 3 | Permit Number 6250 | 6014738.31742 | 2114732.62752 | 37.7874809531407 | -122.392792429224 | (37.7874809531407, -122.392792429224) | 6 | 2 | 9 | 28855 | 6 | ||
| 17046 | 189066 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 521 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6013735.14278 | 2112387.07191 | 37.7809848280366 | -122.396098793052 | (37.7809848280366, -122.396098793052) | 6 | 2 | 9 | 28856 | 34 | |||
| 17288 | 87548 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2809 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2015 12:00:00 AM | 3 | 3x3 | 6011363.6591 | 2092480.1221 | 37.7261924887101 | -122.402902454386 | (37.7261924887101, -122.402902454386) | 10 | 3 | 7 | 309 | 28 | ||
| 17345 | 261328 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 831 Broadway | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009625 | 2118347 | 37.7971198129045 | -122.410738895692 | (37.7971198129045, -122.410738895692) | 3 | 1 | 10 | 308 | 4 | ||||
| 17501 | 251213 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604 | 2111950 | 37.7796659253507 | -122.403440753721 | (37.7796659253507, -122.403440753721) | 14 | 2 | 9 | 28856 | 34 | |
| 17571 | 122654 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 17628 | 243500 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 957 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773003 | 6009168.25876 | 2103593.36659 | 37.7565841965306 | -122.411276577455 | (37.7565841965306, -122.411276577455) | 2 | 4 | 7 | 28859 | 19 | |
| 17637 | 187932 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 211 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6015226.56568 | 2115767.07954 | 37.7903484270771 | -122.391175510261 | (37.7903484270771, -122.391175510261) | 6 | 2 | 9 | 28855 | 6 | |||
| 17771 | 122651 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 17800 | 122661 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 17808 | 114441 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2809 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011711 | 2091301 | 37.7229742506471 | -122.401618870695 | (37.7229742506471, -122.401618870695) | 10 | 3 | 7 | 309 | 28 | ||||
| 17833 | 261334 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 831 Broadway | 7 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009625 | 2118347 | 37.7971198129045 | -122.410738895692 | (37.7971198129045, -122.410738895692) | 3 | 1 | 10 | 308 | 4 | ||||
| 18211 | 49144 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 206 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2003 12:00:00 AM | Permit Number 46269 | 5994953.84956095 | 2088734.37736924 | 37.7149776031797 | -122.459358738579 | (37.7149776031797, -122.459358738579) | 9 | 8 | 6 | 28861 | 24 | |||
| 18300 | 24863 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2636 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2015 12:00:00 AM | 5 | 4x4 | 6011074.2033 | 2093259.325 | 37.7283158506885 | -122.40395790213 | (37.7283158506885, -122.40395790213) | 10 | 3 | 7 | 309 | 28 | ||
| 18374 | 122659 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 18632 | 141321 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 600x DIVISADERO ST | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001606.879 | 2110711.3642 | 37.7757014893927 | -122.437936316665 | (37.7757014893927, -122.437936316665) | 15 | 5 | 11 | 29492 | 10 | |||
| 18758 | 112591 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200X Divisadero St | 1 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | 6001352.6873 | 2112575.8699 | 37.7808064923129 | -122.438949276348 | (37.7808064923129, -122.438949276348) | 15 | 5 | 11 | 29490 | 41 | |||
| 19089 | 203401 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 24 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993518.80789 | 2097119.92672 | 37.7379196595754 | -122.464927448042 | (37.7379196595754, -122.464927448042) | 1 | 8 | 4 | 59 | 40 | |||
| 19278 | 261329 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 831 Broadway | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009625 | 2118347 | 37.7971198129045 | -122.410738895692 | (37.7971198129045, -122.410738895692) | 3 | 1 | 10 | 308 | 4 | ||||
| 19345 | 101991 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | 6 | 2 | 9 | 28855 | 6 | ||||
| 19606 | 261330 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 831 Broadway | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009625 | 2118347 | 37.7971198129045 | -122.410738895692 | (37.7971198129045, -122.410738895692) | 3 | 1 | 10 | 308 | 4 | ||||
| 19613 | 187949 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6015269.3196 | 2115112.5908 | 37.7885537238177 | -122.390981820563 | (37.7885537238177, -122.390981820563) | 6 | 2 | 9 | 28855 | 6 | ||||
| 19741 | 256203 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 8 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
| 20249 | 220440 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2831 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009868.71469 | 2100872.67042 | 37.7491530301063 | -122.408662212302 | (37.7491530301063, -122.408662212302) | 2 | 4 | 7 | 28859 | 19 | |||
| 20764 | 108061 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014711.31667 | 2114762.04187 | 37.7875602184789 | -122.392887905777 | (37.7875602184789, -122.392887905777) | 6 | 2 | 9 | 28855 | 6 | ||
| 20904 | 189063 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 670 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011103.55748 | 2108718.67114 | 37.7707654781809 | -122.40494443566 | (37.7707654781809, -122.40494443566) | 14 | 2 | 9 | 28853 | 34 | |||
| 21214 | 87528 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2684 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2012 12:00:00 AM | 3 | 4x4 | 6011133.0386 | 2093058.8298 | 37.7277686195559 | -122.403740403083 | (37.7277686195559, -122.403740403083) | 10 | 3 | 7 | 309 | 28 | ||
| 21266 | 187936 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 255 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6014368.82149 | 2115126.24847 | 37.7885412160406 | -122.394098386929 | (37.7885412160406, -122.394098386929) | 6 | 2 | 9 | 28855 | 6 | |||
| 21732 | 121544 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
| 22052 | 115353 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014819.91687 | 2114646.31579 | 37.7872484927813 | -122.39250406973 | (37.7872484927813, -122.39250406973) | 6 | 2 | 9 | 28855 | 6 | |
| 22294 | 112595 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200X Divisadero St | 5 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001326.7981 | 2112711.2386 | 37.7811767073085 | -122.439048543991 | (37.7811767073085, -122.439048543991) | 15 | 5 | 11 | 29490 | 41 | |||
| 22594 | 137765 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 900x DIVISADERO ST | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001461.6592 | 2111740.6449 | 37.7785193755481 | -122.438512430085 | (37.7785193755481, -122.438512430085) | 15 | 5 | 11 | 29490 | 41 | |||
| 22984 | 92756 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
| 23188 | 137681 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 900x DIVISADERO ST | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001487.0408 | 2111552.8208 | 37.7780051017696 | -122.438411165508 | (37.7780051017696, -122.438411165508) | 15 | 5 | 11 | 29490 | 41 | |||
| 23226 | 139865 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 752 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005530.836 | 2112064.5728 | 37.7796394301742 | -122.424458633546 | (37.7796394301742, -122.424458633546) | 7 | 9 | 11 | 28852 | 41 | |||
| 23360 | 189070 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1157 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009807.62506 | 2108635.36026 | 37.7704641998942 | -122.409421229304 | (37.7704641998942, -122.409421229304) | 8 | 2 | 9 | 28853 | 34 | |||
| 23670 | 24903 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2810 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2001 12:00:00 AM | 3 | 3X3 | 6011300.9294843 | 2092506.3204879 | 37.7262609211022 | -122.403121150432 | (37.7262609211022, -122.403121150432) | 10 | 3 | 7 | 309 | 28 | ||
| 24019 | 921 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1252 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 3 | 3X3 | 6002917.86629 | 2094183.94733 | 37.730395586884 | -122.432220700641 | (37.730395586884, -122.432220700641) | 9 | 7 | 5 | 28861 | 25 | ||
| 24322 | 187931 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 211 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6015237.31948 | 2115756.16147 | 37.790319045339 | -122.391137539076 | (37.790319045339, -122.391137539076) | 6 | 2 | 9 | 28855 | 6 | |||
| 24380 | 187874 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 10 | : | Tree | Private 2 | 3 | Width 3ft | 6015128.53119 | 2100832.02716 | 37.7493346194117 | -122.390470706171 | (37.7493346194117, -122.390470706171) | 10 | 3 | 8 | 58 | 1 | |||
| 24645 | 220503 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 203 States St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001063.95053 | 2106312.4258 | 37.7635922112288 | -122.439499028168 | (37.7635922112288, -122.439499028168) | 15 | 5 | 5 | 28862 | 3 | |||
| 24829 | 220488 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 4276 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6000665.21266 | 2102890.62449 | 37.7541740808928 | -122.44063268295 | (37.7541740808928, -122.44063268295) | 2 | 4 | 5 | 28862 | 22 | |||
| 25455 | 175146 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 199 Hamilton St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6009095.72656 | 2093731.386 | 37.7295012938507 | -122.410830935508 | (37.7295012938507, -122.410830935508) | 9 | 3 | 7 | 309 | 28 |
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) );