trees
891 rows where qSpecies_id = 75 sorted by YCoord 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 148004 | 109047 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2146 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6000527.7493 | 2120317.86339 | 37.802017012843 | -122.442359096207 | (37.802017012843, -122.442359096207) | 13 | 9 | 1 | 57 | 17 | ||||
| 152887 | 142930 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 581 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010719.0959 | 2118913.2737 | 37.7987359458828 | -122.406992969425 | (37.7987359458828, -122.406992969425) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 67000 | 255258 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 720 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2018 12:00:00 AM | 3 | 3x3 | 6012486 | 2118560 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | 3 | 1 | 10 | 28860 | 6 | ||
| 75008 | 255259 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 720 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2018 12:00:00 AM | 3 | 3x3 | 6012486 | 2118560 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | 3 | 1 | 10 | 28860 | 6 | ||
| 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 | ||
| 26828 | 255255 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 240 Pacific Ave | 2 | 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 | ||
| 108077 | 255257 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 240 Pacific Ave | 4 | 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 | ||
| 157908 | 255254 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 240 Pacific Ave | 1 | 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 | ||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 70440 | 256199 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
| 124340 | 256200 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
| 136981 | 256201 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
| 158385 | 256198 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
| 165926 | 256205 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 10 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
| 172484 | 256197 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
| 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 | ||||
| 47368 | 256212 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
| 80253 | 256209 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
| 107446 | 256207 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
| 122025 | 256210 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
| 155975 | 256208 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
| 193594 | 256211 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 49706 | 125406 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2650 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001656.15712 | 2117548.20785 | 37.7944765158415 | -122.438255746918 | (37.7944765158415, -122.438255746918) | 13 | 9 | 1 | 57 | 27 | |||
| 44631 | 122582 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 2500X Lyon St | 2 | Median : Cutout | Tree | Private 2 | 6 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
| 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 | |||
| 47438 | 107155 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | ||||
| 64187 | 107152 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | In front of Gap Inc. | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | |||
| 102686 | 107153 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | ||||
| 119049 | 107156 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | ||||
| 147641 | 107154 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | ||||
| 91194 | 187903 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 47 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6013582.62491 | 2115938.98616 | 37.7907290759442 | -122.396875529384 | (37.7907290759442, -122.396875529384) | 12 | 2 | 9 | 28855 | 6 | |||
| 76630 | 187902 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 47 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6013611.03319 | 2115912.70701 | 37.790658500748 | -122.396775394381 | (37.790658500748, -122.396775394381) | 12 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 120325 | 112085 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 2 | 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 | |||
| 121820 | 187935 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 211 Spear St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6015174.64356 | 2115822.54351 | 37.7904978368428 | -122.391359037593 | (37.7904978368428, -122.391359037593) | 6 | 2 | 9 | 28855 | 6 | |||
| 112715 | 187934 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 211 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6015195.69866 | 2115800.94411 | 37.7904396983948 | -122.391284677144 | (37.7904396983948, -122.391284677144) | 6 | 2 | 9 | 28855 | 6 | |||
| 136639 | 187910 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 145 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2019 12:00:00 AM | 3 | Width 5ft | 6013716.26626 | 2115794.02597 | 37.7903384868766 | -122.396402968917 | (37.7903384868766, -122.396402968917) | 12 | 2 | 9 | 28855 | 6 | ||
| 37173 | 187933 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 211 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6015208.90661 | 2115787.01653 | 37.7904021894671 | -122.391238004144 | (37.7904021894671, -122.391238004144) | 6 | 2 | 9 | 28855 | 6 | |||
| 134332 | 187909 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 145 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2019 12:00:00 AM | 3 | Width 5ft | 6013732.28694 | 2115779.57523 | 37.7902997000163 | -122.396346524796 | (37.7902997000163, -122.396346524796) | 12 | 2 | 9 | 28855 | 6 | ||
| 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 | |||
| 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 | |||
| 141187 | 187930 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 211 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6015248.50297 | 2115743.86859 | 37.790285912521 | -122.391097985077 | (37.790285912521, -122.391097985077) | 6 | 2 | 9 | 28855 | 6 | |||
| 142792 | 38959 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3186 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1998 12:00:00 AM | 6 | Permit Number 40754 | 5999542.34025 | 2115724.95595 | 37.7893498954312 | -122.445438624911 | (37.7893498954312, -122.445438624911) | 13 | 6 | 1 | 29490 | 27 | ||
| 68507 | 255556 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 100x Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013542 | 2115679 | 37.7900129533755 | -122.396997853926 | (37.7900129533755, -122.396997853926) | 12 | 2 | 9 | 28855 | 6 | ||||
| 76990 | 255558 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 100x Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013542 | 2115679 | 37.7900129533755 | -122.396997853926 | (37.7900129533755, -122.396997853926) | 12 | 2 | 9 | 28855 | 6 | ||||
| 110442 | 255559 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 100x Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013542 | 2115679 | 37.7900129533755 | -122.396997853926 | (37.7900129533755, -122.396997853926) | 12 | 2 | 9 | 28855 | 6 | ||||
| 181572 | 255557 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 100x Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013542 | 2115679 | 37.7900129533755 | -122.396997853926 | (37.7900129533755, -122.396997853926) | 12 | 2 | 9 | 28855 | 6 | ||||
| 73863 | 255534 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 101 01st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013390 | 2115602 | 37.7897930671001 | -122.397518362151 | (37.7897930671001, -122.397518362151) | 12 | 2 | 9 | 28855 | 6 | ||||
| 86808 | 255533 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 101 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013390 | 2115602 | 37.7897930671001 | -122.397518362151 | (37.7897930671001, -122.397518362151) | 12 | 2 | 9 | 28855 | 6 | ||||
| 110784 | 255532 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 101 01st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013390 | 2115602 | 37.7897930671001 | -122.397518362151 | (37.7897930671001, -122.397518362151) | 12 | 2 | 9 | 28855 | 6 | ||||
| 160754 | 255535 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 101 01st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013390 | 2115602 | 37.7897930671001 | -122.397518362151 | (37.7897930671001, -122.397518362151) | 12 | 2 | 9 | 28855 | 6 | ||||
| 160416 | 187917 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 5 Natoma St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013888.85856 | 2115506.90932 | 37.7895597342357 | -122.395785680575 | (37.7895597342357, -122.395785680575) | 12 | 2 | 9 | 28855 | 6 | |||
| 167552 | 187916 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 5 Natoma St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013874.56797 | 2115495.81816 | 37.7895284855 | -122.395834347372 | (37.7895284855, -122.395834347372) | 12 | 2 | 9 | 28855 | 6 | |||
| 99576 | 123540 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 27 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994225.0963 | 2115400.25792 | 37.7881533861032 | -122.463811955609 | (37.7881533861032, -122.463811955609) | 11 | 6 | 1 | 54 | 11 | |||
| 149947 | 187915 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 5 Natoma St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013761.85881 | 2115378.38602 | 37.7891997734024 | -122.396216078116 | (37.7891997734024, -122.396216078116) | 12 | 2 | 9 | 28855 | 6 | |||
| 138104 | 187914 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 5 Natoma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013751.11841 | 2115368.97395 | 37.7891733324224 | -122.39625257892 | (37.7891733324224, -122.39625257892) | 12 | 2 | 9 | 28855 | 6 | |||
| 110293 | 187913 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 5 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013740.8132 | 2115359.33428 | 37.7891462907102 | -122.396287558027 | (37.7891462907102, -122.396287558027) | 12 | 2 | 9 | 28855 | 6 | |||
| 95882 | 187912 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 5 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013728.03817 | 2115347.11788 | 37.7891120364521 | -122.396330901758 | (37.7891120364521, -122.396330901758) | 12 | 2 | 9 | 28855 | 6 | |||
| 110801 | 187940 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015048.62855 | 2115342.19505 | 37.7891719160015 | -122.391761444649 | (37.7891719160015, -122.391761444649) | 6 | 2 | 9 | 28855 | 6 | ||||
| 162663 | 187911 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 5 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013715.2454 | 2115334.02667 | 37.7890753791659 | -122.396374245487 | (37.7890753791659, -122.396374245487) | 12 | 2 | 9 | 28855 | 6 | |||
| 160771 | 187941 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015065.49236 | 2115322.58848 | 37.7891190169896 | -122.391701726057 | (37.7891190169896, -122.391701726057) | 6 | 2 | 9 | 28855 | 6 | ||||
| 34491 | 187942 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015080.74918 | 2115307.92538 | 37.7890796023783 | -122.391647913344 | (37.7890796023783, -122.391647913344) | 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 | ||||
| 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 | ||||
| 46657 | 121543 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
| 48226 | 121547 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
| 73712 | 121545 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
| 117838 | 121542 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
| 139844 | 121546 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
| 186332 | 121541 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
| 71462 | 187943 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015093.73077 | 2115293.30797 | 37.7890401869059 | -122.391601975949 | (37.7890401869059, -122.391601975949) | 6 | 2 | 9 | 28855 | 6 | ||||
| 133882 | 187944 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015109.7038 | 2115276.55289 | 37.7889950679055 | -122.391545539018 | (37.7889950679055, -122.391545539018) | 6 | 2 | 9 | 28855 | 6 | ||||
| 73578 | 187945 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015129.76051 | 2115255.3706 | 37.7889380194338 | -122.391474663423 | (37.7889380194338, -122.391474663423) | 6 | 2 | 9 | 28855 | 6 | ||||
| 34543 | 187929 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013625.5813 | 2115247.15828 | 37.7888318688552 | -122.396678381805 | (37.7888318688552, -122.396678381805) | 12 | 2 | 9 | 28855 | 6 | |||
| 149325 | 187946 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015145.56326 | 2115239.56325 | 37.7888954931699 | -122.391418882079 | (37.7888954931699, -122.391418882079) | 6 | 2 | 9 | 28855 | 6 | ||||
| 32175 | 187928 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013614.18616 | 2115234.9562 | 37.7887977305714 | -122.396716951919 | (37.7887977305714, -122.396716951919) | 12 | 2 | 9 | 28855 | 6 | |||
| 115823 | 187927 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013603.72769 | 2115224.95515 | 37.7887696879241 | -122.396752435596 | (37.7887696879241, -122.396752435596) | 12 | 2 | 9 | 28855 | 6 | |||
| 122606 | 187947 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015161.72984 | 2115222.99296 | 37.7888508922136 | -122.391361788631 | (37.7888508922136, -122.391361788631) | 6 | 2 | 9 | 28855 | 6 | ||||
| 180032 | 187926 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013589.1856 | 2115211.48481 | 37.788731892112 | -122.396801804765 | (37.788731892112, -122.396801804765) | 12 | 2 | 9 | 28855 | 6 | |||
| 93681 | 187925 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013571.0237 | 2115195.4234 | 37.7886867803215 | -122.396863516254 | (37.7886867803215, -122.396863516254) | 12 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 42965 | 49242 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 53211 | 49231 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 106727 | 49229 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 112204 | 49215 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 120509 | 49228 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 179843 | 49216 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 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) );