trees
891 rows where qSpecies_id = 75 sorted by PlantType descending
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 | ||||
1480 | 81721 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 998 Indiana St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014944.54926 | 2104094.31483 | 37.7582819600733 | -122.391334945673 | (37.7582819600733, -122.391334945673) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
3170 | 38792 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 655 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 3 | Permit Number 43810 | 6012704.44378 | 2111400.47389 | 37.7782184558633 | -122.399595224034 | (37.7782184558633, -122.399595224034) | 6 | 2 | 9 | 28856 | 34 | |
3351 | 81717 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 998 Indiana St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6014951.75745 | 2104011.46368 | 37.7580548686454 | -122.391304224825 | (37.7580548686454, -122.391304224825) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
5464 | 66327 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1231 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | 4 | Permit Number 29446 | 5987052.1054 | 2106857.6987 | 37.7642819711606 | -122.488001017639 | (37.7642819711606, -122.488001017639) | 1 | 8 | 3 | 56 | 35 | |
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 | ||
9269 | 71335 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 277 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6011311.01378 | 2111537.1063 | 37.7785158463684 | -122.404425254319 | (37.7785158463684, -122.404425254319) | 14 | 2 | 9 | 28856 | 34 | |||
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 | ||||
11352 | 73737 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 595 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6013232.29052 | 2111907.2745 | 37.7796394233505 | -122.397804754791 | (37.7796394233505, -122.397804754791) | 6 | 2 | 9 | 28856 | 34 | |||
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 | ||||||||||||
12995 | 81719 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 998 Indiana St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014948.61072 | 2104053.54358 | 37.7581702363807 | -122.391318049186 | (37.7581702363807, -122.391318049186) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||||||||||||
13737 | 81723 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 998 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014945.42498 | 2104137.64024 | 37.7584009709475 | -122.391334945662 | (37.7584009709475, -122.391334945662) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||||||||||||
14551 | 72302 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 595 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6013261.50947 | 2111935.00833 | 37.7797172012305 | -122.397705618927 | (37.7797172012305, -122.397705618927) | 6 | 2 | 9 | 28856 | 34 | |||
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 | ||||
17355 | 258161 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 335 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009797.86626 | 2110165.76552 | 37.7746657903123 | -122.409563015883 | (37.7746657903123, -122.409563015883) | 8 | 2 | 9 | 28853 | 34 | |||
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 |
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) );