trees
891 rows where qSpecies_id = 75 sorted by qLegalStatus_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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | ||||||||||||
| 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 | |||
| 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 | |||
| 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 | ||||||||||||
| 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 | ||||
| 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 | ||||||||||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 24868 | 71898 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 455 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2015 12:00:00 AM | 3 | Permit Number 775644 | 6007926.40343 | 2114015.89838 | 37.7851322881578 | -122.416309554165 | (37.7851322881578, -122.416309554165) | 7 | 10 | 9 | 28858 | 36 | |
| 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 | |||
| 26680 | 187919 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 48 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013100.51395 | 2115046.75094 | 37.7882523600964 | -122.398480985606 | (37.7882523600964, -122.398480985606) | 12 | 2 | 9 | 28855 | 6 | |||
| 27184 | 256213 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 7 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
| 27552 | 187948 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 |
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) );