trees
252 rows where qCaretaker_id = 2 and qSpecies_id = 77 sorted by Latitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 131277 | 179170 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 179 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001259.83204 | 2087347.33172 | 37.7115296332658 | -122.437463366848 | (37.7115296332658, -122.437463366848) | 9 | 7 | 6 | 28861 | 5 | |||
| 75784 | 82345 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 254 Dublin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 1 | 3x3 | Permit Number 774176 | 6003940.30685 | 2088972.31262 | 37.7161435078943 | -122.428314680584 | (37.7161435078943, -122.428314680584) | 9 | 7 | 6 | 28861 | 5 | |
| 64342 | 35854 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 142 Russia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/1998 12:00:00 AM | Permit Number 39074 | 6001729.76297614 | 2090780.38588209 | 37.7209827425077 | -122.436084672938 | (37.7209827425077, -122.436084672938) | 9 | 7 | 6 | 28861 | 5 | ||
| 130605 | 35852 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 142 Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/1998 12:00:00 AM | Permit Number 39074 | 6001729.76297614 | 2090780.38588209 | 37.7209827425077 | -122.436084672938 | (37.7209827425077, -122.436084672938) | 9 | 7 | 6 | 28861 | 5 | ||
| 169272 | 35855 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 142 Russia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/1998 12:00:00 AM | Permit Number 39074 | 6001729.76297614 | 2090780.38588209 | 37.7209827425077 | -122.436084672938 | (37.7209827425077, -122.436084672938) | 9 | 7 | 6 | 28861 | 5 | ||
| 154619 | 114678 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 726 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774712 | 6011027.75702 | 2091361.80007 | 37.7231030455441 | -122.40398499124 | (37.7231030455441, -122.40398499124) | 10 | 3 | 7 | 309 | 28 | ||
| 160166 | 202259 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1 Kalmanovitz St | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6013218.01399 | 2093376.88816 | 37.7287581966316 | -122.396554840154 | (37.7287581966316, -122.396554840154) | 10 | 3 | 8 | 58 | 1 | ||||
| 45234 | 202184 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1900 Armstrong Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6013198.98425 | 2093399.22832 | 37.7288184790723 | -122.396622193069 | (37.7288184790723, -122.396622193069) | 10 | 3 | 8 | 58 | 1 | ||||
| 174567 | 202188 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1900 Armstrong Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6013190.44315 | 2093406.40364 | 37.728837705679 | -122.39665222323 | (37.728837705679, -122.39665222323) | 10 | 3 | 8 | 58 | 1 | ||||
| 120545 | 202152 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1951 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6013046.17664 | 2093441.40359 | 37.7289257780866 | -122.397153419018 | (37.7289257780866, -122.397153419018) | 10 | 3 | 8 | 58 | 1 | |||
| 136463 | 213720 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 398 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992203.97011 | 2094317.89279 | 37.7301500773614 | -122.469269557468 | (37.7301500773614, -122.469269557468) | 9 | 8 | 4 | 59 | 40 | |||
| 149200 | 96001 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 321 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767651 | 6013592.98879 | 2094402.89056 | 37.73159625106 | -122.395330363713 | (37.73159625106, -122.395330363713) | 10 | 3 | 8 | 58 | 1 |
| 180557 | 96000 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 315 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767650 | 6013581.92641 | 2094423.84152 | 37.7316531628455 | -122.395370075974 | (37.7316531628455, -122.395370075974) | 10 | 3 | 8 | 58 | 1 |
| 152134 | 196553 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 43 Latona St | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6014415.54504 | 2094422.50935 | 37.7316958338904 | -122.392487974535 | (37.7316958338904, -122.392487974535) | 10 | 3 | 8 | 58 | 1 | |||
| 181865 | 213730 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 290 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992101.64901 | 2095002.48097 | 37.732023872387 | -122.469673110237 | (37.732023872387, -122.469673110237) | 9 | 8 | 4 | 59 | 40 | |||
| 142625 | 196552 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 56 Ledyard St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6011678.30483 | 2094998.2948 | 37.7331244321513 | -122.401991681687 | (37.7331244321513, -122.401991681687) | 10 | 3 | 8 | 58 | 1 | |||
| 114927 | 196551 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 48 Ledyard St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6011647.63932 | 2095039.33012 | 37.7332353949856 | -122.402100585073 | (37.7332353949856, -122.402100585073) | 10 | 3 | 8 | 58 | 1 | |||
| 76508 | 196550 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 44 Ledyard St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6011631.22474 | 2095058.90735 | 37.7332882337562 | -122.402158710982 | (37.7332882337562, -122.402158710982) | 10 | 3 | 8 | 58 | 1 | |||
| 31602 | 196549 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 40 Ledyard St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6011616.35938 | 2095078.64568 | 37.7333416013201 | -122.402211492182 | (37.7333416013201, -122.402211492182) | 10 | 3 | 8 | 58 | 1 | |||
| 29395 | 83672 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 76 Santa Fe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52299 | 6012122.94965 | 2095206.11599 | 37.7337198723641 | -122.400469008954 | (37.7337198723641, -122.400469008954) | 10 | 3 | 8 | 58 | 1 | |
| 135957 | 40046 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1732 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 5 | 7.5x2.5 | Permit Number 767656 | 6014557.3351 | 2095185.10659 | 37.7337976439298 | -122.392051083889 | (37.7337976439298, -122.392051083889) | 10 | 3 | 8 | 58 | 1 |
| 42382 | 84481 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 59 Santa Fe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50146 | 6012081.07031 | 2095312.02235 | 37.7340083335059 | -122.40062123629 | (37.7340083335059, -122.40062123629) | 10 | 3 | 8 | 58 | 1 | |
| 97109 | 239025 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 323 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6006919.22148 | 2096314.31292 | 37.7364711647048 | -122.41853842942 | (37.7364711647048, -122.41853842942) | 2 | 7 | 7 | 28859 | 2 | |||
| 181473 | 46559 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2631 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | 1 | Permit Number 44696 | 5989232.26129309 | 2097435.52728728 | 37.7385381283555 | -122.479771060435 | (37.7385381283555, -122.479771060435) | 1 | 8 | 3 | 29491 | 35 | ||
| 124046 | 44512 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 131 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 10 | 4x4 | Permit Number 43806 | 6004687.03371464 | 2097226.29740092 | 37.7388493482812 | -122.426320962915 | (37.7388493482812, -122.426320962915) | 2 | 7 | 5 | 63 | 7 |
| 10454 | 106790 | Undocumented 4 | Prunus x yedoensis :: Yoshino Cherry 77 | 174 FAIRMOUNT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x6 | 6004503.2 | 2097272.2 | 37.7389649933023 | -122.426959842808 | (37.7389649933023, -122.426959842808) | 2 | 7 | 5 | 63 | 7 | |||
| 33456 | 239029 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 26 Harry St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6003326.30087 | 2097748.91757 | 37.7402073325128 | -122.431063031234 | (37.7402073325128, -122.431063031234) | 2 | 7 | 5 | 63 | 7 | |||
| 67181 | 239028 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 26 Harry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6003397.86036 | 2097787.1303 | 37.7403163105472 | -122.430818333806 | (37.7403163105472, -122.430818333806) | 2 | 7 | 5 | 63 | 7 | ||||
| 35888 | 239027 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 26 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6003403.2403 | 2097795.09814 | 37.740338493218 | -122.430800300593 | (37.740338493218, -122.430800300593) | 2 | 7 | 5 | 63 | 7 | ||||
| 192435 | 5697 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1551 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2007 12:00:00 AM | 3 | 6X6 | 6005311.69042 | 2099268.6032 | 37.7444923466503 | -122.424306405838 | (37.7444923466503, -122.424306405838) | 2 | 7 | 5 | 28859 | 22 | ||
| 140665 | 246630 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3320 Harrison St | 1 | Front Yard : Yard | Tree | Private 2 | 1 | 6009028.43524 | 2099278.75412 | 37.7447293908617 | -122.411455327621 | (37.7447293908617, -122.411455327621) | 2 | 7 | 7 | 28859 | 2 | ||||
| 105268 | 213731 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 72 Merced Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994987.04868 | 2099905.16215 | 37.7456517715262 | -122.460052772716 | (37.7456517715262, -122.460052772716) | 1 | 8 | 4 | 59 | 40 | |||
| 43615 | 114880 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 1687 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2015 12:00:00 AM | 3x3 | 6009362.4 | 2099644 | 37.7457510020701 | -122.4103263211 | (37.7457510020701, -122.4103263211) | 2 | 7 | 7 | 28859 | 2 | |||
| 127131 | 239002 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2 Mirabel Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007267.34733 | 2099764.86466 | 37.7459652050335 | -122.417579291677 | (37.7459652050335, -122.417579291677) | 2 | 7 | 7 | 28859 | 2 | ||||
| 128052 | 238581 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 18 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006358.36528 | 2099816.491 | 37.7460557694506 | -122.420726098652 | (37.7460557694506, -122.420726098652) | 2 | 7 | 5 | 28859 | 2 | |||
| 184976 | 213732 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 475 Dewey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994831.427 | 2100060.8711 | 37.746070357361 | -122.460602166776 | (37.746070357361, -122.460602166776) | 1 | 8 | 4 | 59 | 40 | |||
| 61657 | 246464 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 212 Duncan St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005064.93111 | 2099921.35386 | 37.7462707137301 | -122.425206088515 | (37.7462707137301, -122.425206088515) | 2 | 7 | 5 | 63 | 22 | |||
| 113704 | 239024 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 389 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004038.85397 | 2100110.5602 | 37.7467322107326 | -122.428767625048 | (37.7467322107326, -122.428767625048) | 2 | 7 | 5 | 63 | 22 | |||
| 107927 | 239012 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 417 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009194 | 2100253 | 37.7474137401608 | -122.410951632147 | (37.7474137401608, -122.410951632147) | 2 | 7 | 7 | 28859 | 2 | |||
| 127095 | 32222 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 623 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 15 | Permit Number 35543 | 6009718.6984 | 2100387.54672 | 37.7478125842885 | -122.40914674543 | (37.7478125842885, -122.40914674543) | 2 | 7 | 7 | 28859 | 2 | |
| 174055 | 4162 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3754 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2011 12:00:00 AM | 3 | 3X3 | 6005539.04385 | 2100528.63943 | 37.7479649537167 | -122.423609831438 | (37.7479649537167, -122.423609831438) | 2 | 4 | 5 | 28859 | 19 | ||
| 138650 | 239009 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 60 Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010637.01006 | 2100427.5195 | 37.7479737436878 | -122.405974068569 | (37.7479737436878, -122.405974068569) | 2 | 7 | 7 | 28859 | 2 | |||
| 96537 | 239010 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 60 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010651.97236 | 2100432.84922 | 37.747989214748 | -122.405922704693 | (37.747989214748, -122.405922704693) | 2 | 7 | 7 | 28859 | 2 | |||
| 165888 | 238583 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3726 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005678.26698 | 2100537.88452 | 37.7479981962719 | -122.423129060168 | (37.7479981962719, -122.423129060168) | 2 | 4 | 5 | 28859 | 19 | |||
| 187043 | 239011 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 54 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010666.51854 | 2100440.55381 | 37.7480111833878 | -122.405872946996 | (37.7480111833878, -122.405872946996) | 2 | 7 | 7 | 28859 | 2 | |||
| 174611 | 239023 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 4093 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003318.18687 | 2100656.24769 | 37.7481897266866 | -122.431298564594 | (37.7481897266866, -122.431298564594) | 2 | 4 | 5 | 63 | 22 | |||
| 100212 | 238582 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3456 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006754.5466 | 2100607.36077 | 37.7482496404132 | -122.41941224938 | (37.7482496404132, -122.41941224938) | 2 | 4 | 7 | 28859 | 19 | |||
| 52279 | 196548 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1828 Illinois St | 1 | : | Tree | Private 2 | 7 | Width 4ft | 6016259.97415 | 2100569.45799 | 37.748676359729 | -122.386539809975 | (37.748676359729, -122.386539809975) | 10 | 3 | 8 | 58 | 1 | |||
| 183729 | 239026 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1340 Treat Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008687.9198 | 2100899.65847 | 37.7491609288407 | -122.412747338613 | (37.7491609288407, -122.412747338613) | 2 | 4 | 7 | 28859 | 19 | |||
| 88338 | 213729 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 150 Alton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993589.16073 | 2101660.48807 | 37.7503909504883 | -122.465013883688 | (37.7503909504883, -122.465013883688) | 1 | 8 | 4 | 29491 | 40 | |||
| 152123 | 43636 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 375 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2000 12:00:00 AM | Permit Number 43286 | 6006792.72953639 | 2101606.12998031 | 37.750994184096 | -122.419351056484 | (37.750994184096, -122.419351056484) | 2 | 4 | 7 | 28859 | 19 | ||
| 43319 | 239004 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1299 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010075.23485 | 2101730.69719 | 37.751520546657 | -122.40800856074 | (37.751520546657, -122.40800856074) | 2 | 4 | 7 | 28859 | 19 | |||
| 26278 | 239005 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 250 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6005423.80449 | 2102247.03404 | 37.7526767636284 | -122.424130513718 | (37.7526767636284, -122.424130513718) | 2 | 4 | 5 | 28859 | 19 | |||
| 132173 | 85064 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 57 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2007 12:00:00 AM | Permit Number 49430 | 6005948 | 2102270 | 37.7527694058254 | -122.422319381816 | (37.7527694058254, -122.422319381816) | 2 | 4 | 5 | 28859 | 19 | |||
| 60441 | 46239 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1050 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | 5 | Permit Number 44533 | 6014194.98195 | 2102252.43023 | 37.7531829119855 | -122.393798374016 | (37.7531829119855, -122.393798374016) | 10 | 3 | 8 | 28856 | 29 | ||
| 38026 | 50359 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1044 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 5 | Permit Number 47031 | 6014195.81741 | 2102278.81797 | 37.753255413506 | -122.3937973317 | (37.753255413506, -122.3937973317) | 10 | 3 | 8 | 28856 | 29 | ||
| 115364 | 105908 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1237 NORIEGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2014 12:00:00 AM | 20 | 3x3 | Permit Number 772682 | 5990134.3 | 2103036.1 | 37.7539682014274 | -122.477061416534 | (37.7539682014274, -122.477061416534) | 1 | 8 | 3 | 56 | 35 | |
| 146207 | 213717 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1783 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5991214.07731 | 2103294.38523 | 37.7547399684927 | -122.47334616449 | (37.7547399684927, -122.47334616449) | 1 | 8 | 4 | 56 | 12 | |||
| 166572 | 213719 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 306 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993051.46655 | 2103255.88389 | 37.754740477507 | -122.466989225694 | (37.754740477507, -122.466989225694) | 1 | 8 | 4 | 56 | 12 | |||
| 84016 | 196547 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 970 Wisconsin St | 1 | : | Tree | Private 2 | 10 | Width 6ft | 6012751.32394 | 2103003.67516 | 37.7551653352247 | -122.398843585967 | (37.7551653352247, -122.398843585967) | 10 | 3 | 8 | 28856 | 29 | |||
| 30515 | 238584 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 73 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005403.70836 | 2103296.31784 | 37.7555567183818 | -122.42427463098 | (37.7555567183818, -122.42427463098) | 2 | 4 | 5 | 28859 | 19 | |||
| 25428 | 238585 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 73 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005403.58671 | 2103307.08135 | 37.7555862656019 | -122.424275817175 | (37.7555862656019, -122.424275817175) | 2 | 4 | 5 | 28859 | 19 | |||
| 183984 | 239022 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 927 Church St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6004402.67666 | 2103488.0295 | 37.7560265386112 | -122.42775016985 | (37.7560265386112, -122.42775016985) | 2 | 4 | 5 | 28862 | 22 | |||
| 180974 | 239003 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2392 Bryant St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6009661.58461 | 2103420.7224 | 37.7561378099155 | -122.409558287803 | (37.7561378099155, -122.409558287803) | 2 | 4 | 7 | 28859 | 19 | |||
| 186719 | 213718 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1705 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992771.0421 | 2103829.02772 | 37.7562979917618 | -122.468000688697 | (37.7562979917618, -122.468000688697) | 1 | 8 | 4 | 56 | 12 | |||
| 56628 | 196546 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1017 Rhode Island St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6011946.26987 | 2103466.67493 | 37.7563917406915 | -122.401660256322 | (37.7563917406915, -122.401660256322) | 10 | 3 | 8 | 28856 | 29 | |||
| 54637 | 238586 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 991 San Bruno Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6011096.08107 | 2103736.70014 | 37.7570856908704 | -122.404619530365 | (37.7570856908704, -122.404619530365) | 10 | 4 | 8 | 28859 | 19 | |||
| 51956 | 196545 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 938 Rhode Island St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6011854.06587 | 2104027.62304 | 37.7579268348784 | -122.402018565106 | (37.7579268348784, -122.402018565106) | 10 | 3 | 8 | 28856 | 29 | |||
| 119873 | 239006 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2801 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009817.72923 | 2104524.2582 | 37.7591766191261 | -122.409096148662 | (37.7591766191261, -122.409096148662) | 2 | 4 | 7 | 28859 | 19 | |||
| 56637 | 239007 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2801 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009827.40599 | 2104524.43186 | 37.7591776380486 | -122.409062693893 | (37.7591776380486, -122.409062693893) | 2 | 4 | 7 | 28859 | 19 | |||
| 162524 | 239008 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2801 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009837.36864 | 2104524.2797 | 37.7591777783485 | -122.409028227385 | (37.7591777783485, -122.409028227385) | 2 | 4 | 7 | 28859 | 19 | |||
| 137712 | 35083 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 1541 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | Permit Number 43889 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 147761 | 35082 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 1541 12th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | Permit Number 43889 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 77284 | 44274 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 730 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2001 12:00:00 AM | 4 | Permit Number 43700 | 6011255.06578 | 2104741.61874 | 37.7598538580824 | -122.404140420144 | (37.7598538580824, -122.404140420144) | 10 | 3 | 8 | 28856 | 29 | ||
| 106942 | 62466 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 708 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/2012 12:00:00 AM | 2 | Permit Number 769096 | 6011238.859 | 2104985.8972 | 37.7605236866263 | -122.40421366454 | (37.7605236866263, -122.40421366454) | 10 | 3 | 8 | 28856 | 29 | |
| 173613 | 238599 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007470.12204 | 2105516.97902 | 37.7617706074473 | -122.417285669309 | (37.7617706074473, -122.417285669309) | 2 | 4 | 7 | 28859 | 19 | |||
| 104300 | 196537 | Planning Code 138.1 required 2 | Prunus x yedoensis :: Yoshino Cherry 77 | 526 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782869 | 6010635.96485 | 2105787.36101 | 37.7626906193079 | -122.406355282166 | (37.7626906193079, -122.406355282166) | 8 | 4 | 8 | 28859 | 19 | |
| 139200 | 44049 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3388 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43579 | 6006265.44420171 | 2106129.68857398 | 37.7633851144388 | -122.421495691304 | (37.7633851144388, -122.421495691304) | 8 | 4 | 7 | 28859 | 19 | |||
| 143199 | 44048 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3388 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43579 | 6006265.44420171 | 2106129.68857398 | 37.7633851144388 | -122.421495691304 | (37.7633851144388, -122.421495691304) | 8 | 4 | 7 | 28859 | 19 | |||
| 188992 | 44050 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3388 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43579 | 6006265.44420171 | 2106129.68857398 | 37.7633851144388 | -122.421495691304 | (37.7633851144388, -122.421495691304) | 8 | 4 | 7 | 28859 | 19 | |||
| 21481 | 41610 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
| 83140 | 41607 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
| 84425 | 41604 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
| 147009 | 41609 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
| 151721 | 41603 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 98X Hoff St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | 8 | 3x3 | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |
| 69930 | 57837 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 1339 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2009 12:00:00 AM | 3x3 | Permit Number 52005 | 5994540.33028408 | 2106409.85629846 | 37.763486295989 | -122.46206907635 | (37.763486295989, -122.46206907635) | 1 | 5 | 11 | 56 | 12 | ||
| 119039 | 67591 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 210 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 4 | Permit Number 31158 | 6013702.18081 | 2106068.08806 | 37.763632481088 | -122.395769929855 | (37.763632481088, -122.395769929855) | 14 | 3 | 8 | 28856 | 29 | |
| 129753 | 238587 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 88 Hoff St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006547.66375 | 2106304.16095 | 37.763880083309 | -122.420531969171 | (37.763880083309, -122.420531969171) | 8 | 4 | 7 | 28859 | 19 | |||
| 52161 | 106889 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1040 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2014 12:00:00 AM | 3 | Permit Number 773355 | 6014125.23342 | 2106217.58962 | 37.7640665046851 | -122.394317180299 | (37.7640665046851, -122.394317180299) | 14 | 3 | 8 | 28856 | 29 | ||
| 180977 | 106888 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1040 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2014 12:00:00 AM | 3 | Permit Number 773355 | 6014142.8658 | 2106218.65545 | 37.7640704113316 | -122.394256269225 | (37.7640704113316, -122.394256269225) | 14 | 3 | 8 | 28856 | 29 | ||
| 171028 | 106887 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1040 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2014 12:00:00 AM | 3 | Permit Number 773355 | 6014179.56003 | 2106221.50204 | 37.7640802670231 | -122.394129552957 | (37.7640802670231, -122.394129552957) | 14 | 3 | 8 | 28856 | 29 | ||
| 100238 | 57625 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1040 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2014 12:00:00 AM | 3 | Permit Number 773355 | 6014196.28428 | 2106222.11039 | 37.7640828669594 | -122.394071750814 | (37.7640828669594, -122.394071750814) | 14 | 3 | 8 | 28856 | 29 | ||
| 57891 | 196540 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1751 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012078.91363 | 2106521.10785 | 37.7647859371415 | -122.401416175823 | (37.7647859371415, -122.401416175823) | 14 | 3 | 8 | 28856 | 29 | |||
| 75753 | 196539 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1751 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012100.68573 | 2106521.94936 | 37.7647894624906 | -122.401340930463 | (37.7647894624906, -122.401340930463) | 14 | 3 | 8 | 28856 | 29 | |||
| 176792 | 196538 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1751 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012116.4996 | 2106522.07184 | 37.764790681081 | -122.401286242662 | (37.764790681081, -122.401286242662) | 14 | 3 | 8 | 28856 | 29 | |||
| 77776 | 196541 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1751 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012133.24244 | 2106522.80627 | 37.7647936317506 | -122.401228384779 | (37.7647936317506, -122.401228384779) | 14 | 3 | 8 | 28856 | 29 | |||
| 160650 | 196542 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1751 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012149.92661 | 2106523.64769 | 37.7647968728895 | -122.401170737335 | (37.7647968728895, -122.401170737335) | 14 | 3 | 8 | 28856 | 29 | |||
| 99570 | 114197 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1701x 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6012196.35096 | 2106527.32725 | 37.7648095659429 | -122.4010104251 | (37.7648095659429, -122.4010104251) | 14 | 3 | 8 | 28856 | 29 | |||
| 155378 | 114198 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1701x 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6012211.95597 | 2106527.54933 | 37.7648110462088 | -122.400956466675 | (37.7648110462088, -122.400956466675) | 14 | 3 | 8 | 28856 | 29 | |||
| 93507 | 114199 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1701x 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6012227.07645 | 2106528.11077 | 37.7648134312296 | -122.400904207967 | (37.7648134312296, -122.400904207967) | 14 | 3 | 8 | 28856 | 29 |
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) );