trees
891 rows where qSpecies_id = 75 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
52317 | 88582 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 572 24th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51525 | 5988469.85698 | 2112085.5473 | 37.7787187988439 | -122.483480758311 | (37.7787187988439, -122.483480758311) | 11 | 6 | 2 | 55 | 26 | ||
97317 | 87277 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2417 Bryant St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2008 12:00:00 AM | 3x3 | Permit Number 50297 | 6009714 | 2103272 | 37.7557323884753 | -122.409366521735 | (37.7557323884753, -122.409366521735) | 2 | 4 | 7 | 28859 | 19 | |||
125360 | 92755 | 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 | ||||
173673 | 92758 | 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 | ||||
175622 | 92757 | 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 | ||||
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 | ||||
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 | |||||||||||||
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 | ||
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 | |
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 | ||
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 | |
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 | ||
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 | |||
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 | ||
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 | ||
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 | |
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 | ||||||||||||
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 | ||
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 | |||
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 | |
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 | ||||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |
26661 | 56057 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2857 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2012 12:00:00 AM | Permit Number 769384 | 6009126.12851397 | 2103311.62297626 | 37.7558082292146 | -122.41140237592 | (37.7558082292146, -122.41140237592) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||||
28488 | 220439 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2865 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009873.74767 | 2100752.39413 | 37.7488230598385 | -122.408636324412 | (37.7488230598385, -122.408636324412) | 2 | 4 | 7 | 28859 | 19 | |||
28496 | 175131 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3219 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011901.5218 | 2090720.78574 | 37.7213917301239 | -122.400919526131 | (37.7213917301239, -122.400919526131) | 10 | 7 | 8 | 309 | 28 | |||
28570 | 187924 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013555.31002 | 2115180.42433 | 37.7886447217118 | -122.396916831643 | (37.7886447217118, -122.396916831643) | 12 | 2 | 9 | 28855 | 6 | |||
28769 | 247369 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400x Divisadero St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001726.9821 | 2109863.6289 | 37.7733806494785 | -122.437460131244 | (37.7733806494785, -122.437460131244) | 15 | 5 | 11 | 29492 | 10 | |||
29035 | 24866 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2675 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1996 12:00:00 AM | 3 | 3X3 | 6011160.2152 | 2093140.3949 | 37.7279940984962 | -122.403652189094 | (37.7279940984962, -122.403652189094) | 10 | 3 | 7 | 309 | 28 | ||
29133 | 28674 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3130 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2x3 | 6011742.0620525 | 2091064.4440916 | 37.7223264497375 | -122.401494877675 | (37.7223264497375, -122.401494877675) | 10 | 3 | 7 | 309 | 28 | |||
29533 | 187958 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 43 Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014361.38404 | 2114182.65198 | 37.7859499041048 | -122.394058036143 | (37.7859499041048, -122.394058036143) | 6 | 2 | 9 | 28855 | 6 | |||
29592 | 47957 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 681 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2002 12:00:00 AM | 7 | Permit Number 45687 | 6014451.3801 | 2103976.60292 | 37.7579313656632 | -122.393032317982 | (37.7579313656632, -122.393032317982) | 10 | 3 | 8 | 28856 | 29 | ||
30147 | 115348 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014915.48611 | 2114547.78532 | 37.7869832575075 | -122.39216652446 | (37.7869832575075, -122.39216652446) | 6 | 2 | 9 | 28855 | 6 | |
30239 | 121540 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
31270 | 28843 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 338 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2008 12:00:00 AM | 3 | 3X3 | 5993062.32103 | 2089859.01247 | 37.7179566445716 | -122.465978279778 | (37.7179566445716, -122.465978279778) | 9 | 8 | 6 | 64 | 24 | ||
31665 | 189088 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 693 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009010.6716 | 2111090.12277 | 37.7771597163869 | -122.412351439063 | (37.7771597163869, -122.412351439063) | 8 | 2 | 9 | 28853 | 34 | |||
31808 | 8249 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1515 Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2004 12:00:00 AM | 3 | 3x3 | 6016234 | 2097322 | 37.7397580688138 | -122.386403238688 | (37.7397580688138, -122.386403238688) | 10 | 3 | 8 | 58 | 1 | ||
32571 | 121222 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 690 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6007452 | 2105652 | 37.7621403241605 | -122.417357915219 | (37.7621403241605, -122.417357915219) | 8 | 4 | 7 | 28859 | 19 | |||
33193 | 175132 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3209 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011889.98271 | 2090759.53666 | 37.7214974885945 | -122.400962135093 | (37.7214974885945, -122.400962135093) | 10 | 7 | 8 | 309 | 28 | |||
33789 | 87446 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1419X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6002388.02378 | 2093708.69902 | 37.7290606071124 | -122.434018479663 | (37.7290606071124, -122.434018479663) | 9 | 7 | 6 | 28861 | 25 | ||
34523 | 142929 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 591 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010700.0761 | 2118912.2456 | 37.7987320586367 | -122.407058711866 | (37.7987320586367, -122.407058711866) | 3 | 1 | 10 | 308 | 23 | |||
34900 | 586 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3040 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6008691.81998 | 2102185.56005 | 37.7526919453923 | -122.412824751929 | (37.7526919453923, -122.412824751929) | 2 | 4 | 7 | 28859 | 19 | ||
37025 | 2365 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2500 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3X3 | 6009712.991769 | 2102766.5035064 | 37.7543443518018 | -122.409334337085 | (37.7543443518018, -122.409334337085) | 2 | 4 | 7 | 28859 | 19 | |||
38677 | 59325 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 345 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/1990 12:00:00 AM | 12 | Permit Number 29282 | 6006158.21098 | 2111403.55582 | 37.7778598467005 | -122.422241292597 | (37.7778598467005, -122.422241292597) | 7 | 9 | 11 | 28852 | 10 | ||
39259 | 24875 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2559 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | 3 | 3x3 | 6010991.1509093 | 2093686.6170284 | 37.7294844648724 | -122.404275081222 | (37.7294844648724, -122.404275081222) | 10 | 3 | 7 | 309 | 28 | ||
39847 | 141372 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 500x DIVISADERO ST | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001679.4856 | 2110197.4976 | 37.7742946690664 | -122.437648343185 | (37.7742946690664, -122.437648343185) | 15 | 5 | 11 | 29492 | 10 | |||
40161 | 88150 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 300X Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270 | 2112782 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | 6 | 2 | 9 | 28856 | 34 | ||
41046 | 7375 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2907X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6009449.8972236 | 2102159.1699056 | 37.7526620055733 | -122.410201312287 | (37.7526620055733, -122.410201312287) | 2 | 4 | 7 | 28859 | 19 | ||
41417 | 24862 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2626 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2015 12:00:00 AM | 4 | 3x3 | 6011036.3806 | 2093380.4977 | 37.7286464524247 | -122.404097181781 | (37.7286464524247, -122.404097181781) | 10 | 3 | 7 | 309 | 28 | ||
41884 | 141616 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 700x DIVISADERO ST | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001582.0309 | 2110873.3052 | 37.7761447256429 | -122.438033874836 | (37.7761447256429, -122.438033874836) | 15 | 5 | 11 | 29492 | 10 | |||
42019 | 88168 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 366 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51186 | 6011675 | 2112537 | 37.7812816562818 | -122.403236436508 | (37.7812816562818, -122.403236436508) | 6 | 2 | 9 | 28853 | 34 | ||
42423 | 220490 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3040 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | Width 3ft | 6008734.34434 | 2102169.47366 | 37.7526501625767 | -122.412676557499 | (37.7526501625767, -122.412676557499) | 2 | 4 | 7 | 28859 | 19 | ||
42705 | 203416 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 75 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993822.50089 | 2096951.15994 | 37.7374737738828 | -122.463865194036 | (37.7374737738828, -122.463865194036) | 1 | 8 | 4 | 59 | 40 | |||
44340 | 4154 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3718 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1997 12:00:00 AM | 6 | 3X3 | 6005698.24114 | 2100539.02617 | 37.748002458148 | -122.423060071381 | (37.748002458148, -122.423060071381) | 2 | 4 | 5 | 28859 | 19 | ||
46040 | 82635 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1363 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52502 | 6016495.7737 | 2093658.9613 | 37.7297145851124 | -122.385242953388 | (37.7297145851124, -122.385242953388) | 10 | 3 | 8 | 58 | 1 | |
46554 | 244892 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Divisadero St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001783.197 | 2109529.1582 | 37.7724654721109 | -122.437241723075 | (37.7724654721109, -122.437241723075) | 15 | 5 | 11 | 29492 | 9 | |||
47087 | 220487 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 416 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000636.08004 | 2101486.04738 | 37.7503157923525 | -122.440632691055 | (37.7503157923525, -122.440632691055) | 2 | 4 | 5 | 28862 | 22 | |||
47573 | 854 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 374 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6008336.69687 | 2095197.29776 | 37.7334837823442 | -122.413558622435 | (37.7334837823442, -122.413558622435) | 10 | 7 | 7 | 28859 | 2 | ||
49904 | 1124 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2463 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999036.51586 | 2088791.07267 | 37.715367165446 | -122.445251440001 | (37.715367165446, -122.445251440001) | 9 | 7 | 6 | 28861 | 25 | ||
49928 | 16382 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2413X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999194.33201 | 2088944.07211 | 37.7157962742582 | -122.444716950429 | (37.7157962742582, -122.444716950429) | 9 | 7 | 6 | 28861 | 25 | ||
50503 | 50676 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2009 12:00:00 AM | 2 | 3x3 | Permit Number 53102 | 6011983.41914 | 2112836.30852 | 37.7821207077455 | -122.402190501114 | (37.7821207077455, -122.402190501114) | 6 | 2 | 9 | 28853 | 34 | |
50976 | 256196 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
51014 | 28663 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2826 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011313.9934641 | 2092464.2100287 | 37.7261460240505 | -122.40307302798 | (37.7261460240505, -122.40307302798) | 10 | 3 | 7 | 309 | 28 | |||
51309 | 51960 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3953 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2005 12:00:00 AM | Permit Number 48181 | 6003479.49286747 | 2101832.63497006 | 37.7514289506507 | -122.43082471383 | (37.7514289506507, -122.43082471383) | 2 | 4 | 5 | 28862 | 22 | |||
52833 | 141981 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 961 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004347.2458 | 2111841.6916 | 37.7789605439257 | -122.428537292711 | (37.7789605439257, -122.428537292711) | 7 | 9 | 11 | 29490 | 41 | |||
53217 | 100773 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
53359 | 247516 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 250x Divisadero St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001823.2223 | 2109176.3929 | 37.7714991415406 | -122.437078010881 | (37.7714991415406, -122.437078010881) | 15 | 5 | 11 | 29492 | 9 | |||
54288 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | 1 | 8 | 4 | 59 | 40 | ||
54484 | 220432 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1650 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006509.92654 | 2099814.31154 | 37.7460583262406 | -122.420201864026 | (37.7460583262406, -122.420201864026) | 2 | 7 | 7 | 28859 | 2 | |||
54765 | 203417 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993769.49059 | 2096990.17002 | 37.7375778308529 | -122.46405130512 | (37.7375778308529, -122.46405130512) | 1 | 8 | 4 | 59 | 40 | |||
54975 | 189092 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1442 Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016181.26551 | 2097468.21329 | 37.7401566215255 | -122.386595766675 | (37.7401566215255, -122.386595766675) | 10 | 3 | 8 | 58 | 1 | |||
55001 | 220414 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1601 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009485.69193 | 2106956.65454 | 37.7658368183492 | -122.410416250032 | (37.7658368183492, -122.410416250032) | 8 | 4 | 8 | 28853 | 19 | |||
55314 | 87432 | - 12 | Acer rubrum :: Red Maple 75 | 598X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||
57246 | 125407 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2600 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6003635.60452 | 2117293.35447 | 37.7938891371273 | -122.431388416755 | (37.7938891371273, -122.431388416755) | 13 | 9 | 1 | 29490 | 27 | |||
57551 | 27452 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1635 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6X6 | 6015192.76909 | 2100696.51451 | 37.7489660934285 | -122.390239101956 | (37.7489660934285, -122.390239101956) | 10 | 3 | 8 | 58 | 1 | |||
57733 | 29065 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1001X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138357 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | 7 | 9 | 11 | 29490 | 41 | ||
59081 | 28705 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3028 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2009 12:00:00 AM | 3 | 3X3 | 6011599.0463446 | 2091533.093888 | 37.7236052850781 | -122.402022182135 | (37.7236052850781, -122.402022182135) | 10 | 3 | 7 | 309 | 28 | ||
59653 | 220438 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2814 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6009797.76242 | 2100932.26628 | 37.749312693037 | -122.40891177146 | (37.749312693037, -122.40891177146) | 2 | 4 | 7 | 28859 | 19 | |||
60082 | 29064 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1000X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 03/02/2006 12:00:00 AM | 3 | 3x3 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 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) );