trees
891 rows where qSpecies_id = 75 sorted by DBH
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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 24954 | 255884 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 50 Columbia Square St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | |||
| 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 | ||||
| 28512 | 101993 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 4 | 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 | ||||
| 28605 | 88152 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 300X Clementina St | 3 | 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 | ||
| 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 | ||||
| 32270 | 118379 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
| 35828 | 48550 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | ||
| 41561 | 48548 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | ||
| 42035 | 91046 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2574 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2008 12:00:00 AM | 3x3 | Permit Number 51958 | 6010972 | 2093540.2 | 37.7290813641679 | -122.404330986626 | (37.7290813641679, -122.404330986626) | 10 | 3 | 7 | 309 | 28 | ||
| 42224 | 100778 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 6 | 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 | ||
| 42633 | 118377 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 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 | |||
| 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 | ||||
| 47304 | 256005 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
| 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 | ||||
| 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 | ||||
| 47592 | 48549 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
| 47707 | 254263 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 66 Lansing St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6014289.84402 | 2114150.25322 | 37.7858569681792 | -122.394303277683 | (37.7858569681792, -122.394303277683) | 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 | ||||
| 48410 | 255900 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 660 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3x3 | 6012744.76196 | 2111515.06694 | 37.7785353494244 | -122.399463794931 | (37.7785353494244, -122.399463794931) | 6 | 2 | 9 | 28856 | 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||
| 62005 | 100775 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 3 | 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 | ||
| 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 | |||
| 64723 | 118378 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
| 66306 | 103269 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1175 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003540.3 | 2111739 | 37.7786328797101 | -122.431321507712 | (37.7786328797101, -122.431321507712) | 15 | 9 | 11 | 29492 | 41 | ||||
| 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 | ||||
| 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 | ||||
| 71980 | 96783 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 219 Prentiss St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | 10 | 7 | 7 | 28859 | 2 | |||
| 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 | ||||
| 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 | ||||
| 75283 | 118380 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 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 | ||||
| 77418 | 96781 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 219 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | 10 | 7 | 7 | 28859 | 2 | |||
| 79448 | 88153 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 300X Clementina St | 4 | 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 | ||
| 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 | ||||
| 83821 | 100777 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 4x3 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
| 84101 | 255881 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 50 Columbia Square St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | ||||
| 87946 | 101990 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 1 | 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 | ||||
| 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 | |||
| 97512 | 256006 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
| 98992 | 88176 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 366 Clementina St | 9 | 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 | ||
| 100082 | 102507 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1700X Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.435126576612 | (37.782944132882, -122.435126576612) | 15 | 5 | 11 | 29490 | 41 | ||
| 100678 | 94790 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1985 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | Permit Number 53888 | 5993755.4 | 2101986.9 | 37.751296778417 | -122.464462718314 | (37.751296778417, -122.464462718314) | 1 | 8 | 4 | 29491 | 12 | |||
| 101188 | 251420 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2775 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/03/2018 12:00:00 AM | 3x3 | 6000680 | 2114785 | 37.7868338993394 | -122.441434988756 | (37.7868338993394, -122.441434988756) | 13 | 6 | 1 | 29490 | 27 | |||
| 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 | ||||
| 104491 | 100779 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 7 | 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 | ||
| 105887 | 88193 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 364 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51197 | 6011427.8 | 2112687.4 | 37.7816808107693 | -122.40410221959 | (37.7816808107693, -122.40410221959) | 6 | 2 | 9 | 28853 | 34 | ||
| 106018 | 60333 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 4051 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1982 12:00:00 AM | Permit Number 19906 | 6002674.88696195 | 2104708.78701715 | 37.7592805573459 | -122.433812685394 | (37.7592805573459, -122.433812685394) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 106728 | 64005 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 443 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | 5x9 | Permit Number 24752 | 6002309.37367781 | 2100887.25267027 | 37.7487667887863 | -122.434803521117 | (37.7487667887863, -122.434803521117) | 2 | 4 | 5 | 28862 | 22 | |
| 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 | ||||
| 107637 | 94416 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 5800 03rd St | 3 | Front Yard : Yard | Tree | Private 2 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849 | 2092184 | 37.7255178628117 | -122.394289979276 | (37.7255178628117, -122.394289979276) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||||
| 110523 | 251505 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011658.68026 | 2112523.02352 | 37.7812423686803 | -122.403291911611 | (37.7812423686803, -122.403291911611) | 6 | 2 | 9 | 28853 | 34 | ||||
| 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 | ||||
| 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 | |||
| 112518 | 46480 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 425 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2002 12:00:00 AM | Permit Number 44673 | 6005932.49263568 | 2107829.56696454 | 37.7680337988036 | -122.422768076165 | (37.7680337988036, -122.422768076165) | 8 | 4 | 5 | 28853 | 19 | |||
| 114155 | 48551 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | ||||
| 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 | ||||
| 119860 | 88154 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 300X Clementina St | 5 | 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 | ||
| 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 | |||
| 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 | |||
| 121975 | 256175 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 1493 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015764 | 2095228 | 37.7339823414442 | -122.387882237671 | (37.7339823414442, -122.387882237671) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||||
| 122737 | 102508 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1700X Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.435126576612 | (37.782944132882, -122.435126576612) | 15 | 5 | 11 | 29490 | 41 | ||
| 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 | ||||
| 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 | ||||
| 126943 | 96782 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 219 Prentiss St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | 10 | 7 | 7 | 28859 | 2 | |||
| 132870 | 118376 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
| 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 | ||||
| 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 | ||||
| 139980 | 256007 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
| 142769 | 101994 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 5 | 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 |
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) );