trees
484 rows where qSpecies_id = 56 sorted by Fire Prevention Districts 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 444 | 105900 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
| 2742 | 261944 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1 Verna St | 9 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
| 3064 | 111546 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x BOSWORTH ST | 24 | Front Yard : Yard | Tree | DPW 1 | 15 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 3394 | 261943 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1 Verna St | 8 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
| 3562 | 209013 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 412 Baden St | 1 | Side Yard : Yard | Tree | Private 2 | 20 | 6000780.48794 | 2095392.50815 | 37.7335925958074 | -122.439696511209 | (37.7335925958074, -122.439696511209) | 9 | 7 | 5 | 63 | 40 | ||||
| 4907 | 209031 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 36 Martha Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6 | 6000753.40861 | 2095578.70975 | 37.734102320757 | -122.43980347745 | (37.734102320757, -122.43980347745) | 9 | 7 | 5 | 63 | 40 | ||||
| 5310 | 209020 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 33 Martha Ave | 4 | : Yard | Tree | Private 2 | 12 | 6000767.68455 | 2095534.49854 | 37.7339817396554 | -122.439750952547 | (37.7339817396554, -122.439750952547) | 9 | 7 | 5 | 63 | 40 | ||||
| 8233 | 111536 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x BOSWORTH ST | 14 | Front Yard : Yard | Tree | DPW 1 | 24 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 10506 | 208985 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 372 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 59 | Width 3ft | 5993088 | 2095554 | 37.7335951664771 | -122.466303177465 | (37.7335951664771, -122.466303177465) | 9 | 8 | 4 | 59 | 40 | |||
| 11816 | 209009 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 408 Baden St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 6000785.2821 | 2095342.66839 | 37.7334560202787 | -122.439676364582 | (37.7334560202787, -122.439676364582) | 9 | 7 | 5 | 63 | 40 | ||||
| 12354 | 264690 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 99 Verna St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5998312 | 2096103 | 37.7354026257891 | -122.448281895759 | (37.7354026257891, -122.448281895759) | 9 | 7 | 4 | 59 | 40 | ||||
| 14982 | 26911 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 10 Caine Ave | 7 | Median : Cutout | Tree | DPW 1 | 18 | 10 | 5997609.86555 | 2089654.44991 | 37.7176562610968 | -122.450244747607 | (37.7176562610968, -122.450244747607) | 9 | 8 | 6 | 28861 | 24 | |||
| 16282 | 65198 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 371 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 34 | Permit Number 27183 | 6003158.74485 | 2091706.48731 | 37.7236066919673 | -122.431211180179 | (37.7236066919673, -122.431211180179) | 9 | 7 | 6 | 28861 | 5 | |
| 17462 | 261945 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1 Verna St | 10 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
| 17551 | 261946 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1 Verna St | 11 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
| 18361 | 173682 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450x Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6008515 | 2088365 | 37.7147337500707 | -122.412459395375 | (37.7147337500707, -122.412459395375) | 9 | 7 | 8 | 309 | 18 | |||
| 21127 | 176347 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 40 Teddy Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 6011214.18105 | 2087815.33758 | 37.7133755951756 | -122.403091220704 | (37.7133755951756, -122.403091220704) | 9 | 7 | 8 | 309 | 39 | ||||
| 27522 | 208948 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 340 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 10ft | 5992820.42769 | 2095999.68162 | 37.7348034547075 | -122.467260639285 | (37.7348034547075, -122.467260639285) | 9 | 8 | 4 | 59 | 40 | |||
| 28767 | 176346 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 40 Teddy Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6011228.44814 | 2087808.7969 | 37.7133584325151 | -122.40304144861 | (37.7133584325151, -122.40304144861) | 9 | 7 | 8 | 309 | 39 | ||||
| 29552 | 209015 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 412 Baden St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6000779.78636 | 2095479.1538 | 37.7338304646942 | -122.439705146498 | (37.7338304646942, -122.439705146498) | 9 | 7 | 5 | 63 | 40 | ||||
| 31048 | 209011 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 408 Baden St | 3 | Front Yard : Yard | Tree | Private 2 | 13 | 6000782.19416 | 2095354.33843 | 37.7334878877384 | -122.439687876799 | (37.7334878877384, -122.439687876799) | 9 | 7 | 5 | 63 | 40 | ||||
| 31382 | 208940 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 10ft | 5992201.32921 | 2095978.53427 | 37.7347096311457 | -122.469399518468 | (37.7347096311457, -122.469399518468) | 9 | 8 | 4 | 59 | 40 | |||
| 32721 | 209023 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 34 Martha Ave | 3 | Front Yard : Yard | Tree | Private 2 | 20 | 6000780.47253 | 2095565.1582 | 37.7340666518368 | -122.439708938014 | (37.7340666518368, -122.439708938014) | 9 | 7 | 5 | 63 | 40 | ||||
| 33046 | 209043 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 690 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 54 | Width 10ft | 5996832.93686 | 2095303.59062 | 37.7331229707542 | -122.453337845278 | (37.7331229707542, -122.453337845278) | 9 | 7 | 4 | 59 | 40 | |||
| 35915 | 208975 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 6ft | 5994177.11325 | 2096643.32557 | 37.7366489660835 | -122.462616818123 | (37.7366489660835, -122.462616818123) | 9 | 8 | 4 | 59 | 40 | |||
| 36671 | 208936 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 3 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 10ft | 5991855.38456 | 2095971.03212 | 37.7346690339426 | -122.470595009771 | (37.7346690339426, -122.470595009771) | 9 | 8 | 4 | 59 | 40 | |||
| 36888 | 209029 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 36 Martha Ave | 6 | Front Yard : Yard | Tree | Private 2 | 18 | 6000758.12976 | 2095576.10922 | 37.7340954490409 | -122.439786968613 | (37.7340954490409, -122.439786968613) | 9 | 7 | 5 | 63 | 40 | ||||
| 37827 | 208942 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 10ft | 5992406.13159 | 2095989.66706 | 37.7347520323855 | -122.468692262863 | (37.7347520323855, -122.468692262863) | 9 | 8 | 4 | 59 | 40 | |||
| 40308 | 208955 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 630 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 8ft | 5993530.97918 | 2095998.56422 | 37.7348413791301 | -122.464803955838 | (37.7348413791301, -122.464803955838) | 9 | 8 | 4 | 59 | 40 | |||
| 41955 | 207763 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 290 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | Width 10ft | 5993266.97338 | 2095443.21542 | 37.7333013044925 | -122.465676373776 | (37.7333013044925, -122.465676373776) | 9 | 8 | 4 | 59 | 40 | |||
| 47520 | 209045 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 300 Melrose Ave | 3 | Side Yard : Yard | Tree | Private 2 | 88 | 5998032.35629 | 2095523.65591 | 37.7337958938523 | -122.449206999226 | (37.7337958938523, -122.449206999226) | 9 | 7 | 4 | 59 | 40 | ||||
| 47849 | 209028 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 36 Martha Ave | 5 | Front Yard : Yard | Tree | Private 2 | 29 | 6000760.3597 | 2095574.56127 | 37.7340913256606 | -122.439779148088 | (37.7340913256606, -122.439779148088) | 9 | 7 | 5 | 63 | 40 | ||||
| 50310 | 176345 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450 Raymond Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | 6008420.88631 | 2088405.51015 | 37.7148397004654 | -122.412787554496 | (37.7148397004654, -122.412787554496) | 9 | 7 | 8 | 309 | 18 | ||||
| 51836 | 209018 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 33 Martha Ave | 3 | : Yard | Tree | Private 2 | 38 | 6000767.57935 | 2095529.42368 | 37.733967799282 | -122.439750952539 | (37.733967799282, -122.439750952539) | 9 | 7 | 5 | 63 | 40 | ||||
| 53008 | 209014 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 412 Baden St | 2 | Side Yard : Yard | Tree | Private 2 | 7 | 6000787.79858 | 2095464.06576 | 37.733789492485 | -122.439676364596 | (37.733789492485, -122.439676364596) | 9 | 7 | 5 | 63 | 40 | ||||
| 56734 | 173683 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450x Raymond Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6008515 | 2088365 | 37.7147337500707 | -122.412459395375 | (37.7147337500707, -122.412459395375) | 9 | 7 | 8 | 309 | 18 | |||
| 57886 | 209012 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 410 Baden St | 1 | Front Yard : Yard | Tree | Private 2 | 24 | 6000789.00569 | 2095372.0781 | 37.7335369844496 | -122.439665598801 | (37.7335369844496, -122.439665598801) | 9 | 7 | 5 | 63 | 40 | ||||
| 58428 | 209046 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 301 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 55 | Width 10ft | 5999983.24986 | 2094934.98428 | 37.7322909323756 | -122.442419949729 | (37.7322909323756, -122.442419949729) | 9 | 7 | 4 | 63 | 40 | |||
| 61319 | 119631 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 265 Fowler Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 3x5 | 5997384 | 2099137 | 37.7436801569324 | -122.451709113802 | (37.7436801569324, -122.451709113802) | 9 | 7 | 4 | 59 | 40 | |||
| 62684 | 106004 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 695X CAMPBELL AVE | unknown : Yard | Tree | Rec/Park 5 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.410348471622 | (37.716271678506, -122.410348471622) | 9 | 7 | 8 | 309 | 39 | ||||||
| 63658 | 209035 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 427 Baden St | 1 | Front Yard : Yard | Tree | Private 2 | 32 | 6000759.78323 | 2095371.55913 | 37.7335338961641 | -122.439766591781 | (37.7335338961641, -122.439766591781) | 9 | 7 | 5 | 63 | 40 | ||||
| 64352 | 209010 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 408 Baden St | 2 | Front Yard : Yard | Tree | Private 2 | 41 | 6000785.06362 | 2095352.20634 | 37.7334821968386 | -122.439677803484 | (37.7334821968386, -122.439677803484) | 9 | 7 | 5 | 63 | 40 | ||||
| 66557 | 13410 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 364 Marietta Dr | 3 | Median : Cutout | Tree | DPW 1 | 12 | 5 | 5999660.108164 | 2097381.7238333 | 37.7389906787724 | -122.443712833155 | (37.7389906787724, -122.443712833155) | 9 | 7 | 4 | 59 | 40 | |||
| 70219 | 111551 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x BOSWORTH ST | 29 | Front Yard : Yard | Tree | DPW 1 | 27 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 71372 | 208972 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 136 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 6ft | 5994281.63654 | 2096550.25213 | 37.7363994284866 | -122.462248690521 | (37.7363994284866, -122.462248690521) | 9 | 8 | 4 | 59 | 40 | |||
| 72158 | 113805 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 990X OSHAUGHNESSY BLVD | 2 | Front Yard : Yard | Tree | Rec/Park 5 | 3x30 | 6000025 | 2096199 | 37.735764003208 | -122.442366322687 | (37.735764003208, -122.442366322687) | 9 | 7 | 4 | 63 | 40 | ||||
| 74892 | 209034 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 38 Martha Ave | 3 | Front Yard : Yard | Tree | Private 2 | 30 | 6000740.95615 | 2095584.22378 | 37.7341167521787 | -122.439846924607 | (37.7341167521787, -122.439846924607) | 9 | 7 | 5 | 63 | 40 | ||||
| 75661 | 176344 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450 Raymond Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6008453.92432 | 2088393.60062 | 37.7148088537086 | -122.412672519523 | (37.7148088537086, -122.412672519523) | 9 | 7 | 8 | 309 | 18 | ||||
| 77709 | 209026 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 36 Martha Ave | 3 | Front Yard : Yard | Tree | Private 2 | 24 | 6000767.091 | 2095571.91906 | 37.7340844539158 | -122.439755686569 | (37.7340844539158, -122.439755686569) | 9 | 7 | 5 | 63 | 40 | ||||
| 79003 | 208937 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 64 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | Width 10ft | 5991925.34536 | 2095973.96809 | 37.7346811406131 | -122.470353347532 | (37.7346811406131, -122.470353347532) | 9 | 8 | 4 | 59 | 40 | |||
| 81221 | 208950 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 440 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 10ft | 5992985.54967 | 2096006.72468 | 37.7348323238367 | -122.466690272156 | (37.7348323238367, -122.466690272156) | 9 | 8 | 4 | 59 | 40 | |||
| 81662 | 209017 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 33 Martha Ave | 1 | : Yard | Tree | Private 2 | 25 | 6000774.79116 | 2095519.58157 | 37.7339411856303 | -122.439725313784 | (37.7339411856303, -122.439725313784) | 9 | 7 | 5 | 63 | 40 | ||||
| 82650 | 209042 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 419 Baden St | 7 | Front Yard : Yard | Tree | Private 2 | 7 | 6000746.1619 | 2095340.78312 | 37.7334486170489 | -122.439811478728 | (37.7334486170489, -122.439811478728) | 9 | 7 | 5 | 63 | 40 | ||||
| 82743 | 209039 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 419 Baden St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6000750.66308 | 2095345.51302 | 37.7334618604699 | -122.439796255913 | (37.7334618604699, -122.439796255913) | 9 | 7 | 5 | 63 | 40 | ||||
| 83967 | 176343 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450 Raymond Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 76 | 6008484.74111 | 2088383.42134 | 37.7147826330863 | -122.412565284366 | (37.7147826330863, -122.412565284366) | 9 | 7 | 8 | 309 | 18 | ||||
| 84225 | 209038 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 419 Baden St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | 6000746.77902 | 2095349.32051 | 37.7334720938659 | -122.439809957065 | (37.7334720938659, -122.439809957065) | 9 | 7 | 5 | 63 | 40 | ||||
| 84756 | 208946 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 300 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 10ft | 5992719.83793 | 2096001.79663 | 37.7348034547201 | -122.467608563598 | (37.7348034547201, -122.467608563598) | 9 | 8 | 4 | 59 | 40 | |||
| 86597 | 208949 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 402 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 10ft | 5992933.73617 | 2096006.17085 | 37.7348278128415 | -122.466869367631 | (37.7348278128415, -122.466869367631) | 9 | 8 | 4 | 59 | 40 | |||
| 89376 | 209032 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 38 Martha Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6000749.17916 | 2095580.79962 | 37.7341078183059 | -122.439818249733 | (37.7341078183059, -122.439818249733) | 9 | 7 | 5 | 63 | 40 | ||||
| 92601 | 208973 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 136 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 6ft | 5994259.72598 | 2096572.09553 | 37.7364581434207 | -122.462326027748 | (37.7364581434207, -122.462326027748) | 9 | 8 | 4 | 59 | 40 | |||
| 93771 | 29600 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991176.92289 | 2091079.14193 | 37.7211978713578 | -122.472584119478 | (37.7211978713578, -122.472584119478) | 9 | 8 | 4 | 64 | 40 | ||
| 97814 | 208935 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 3 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 10ft | 5991812.79149 | 2095969.62922 | 37.7346627188958 | -122.470742164934 | (37.7346627188958, -122.470742164934) | 9 | 8 | 4 | 59 | 40 | |||
| 98944 | 253568 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 301X Sargent St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5993018 | 2089140 | 37.7159798527116 | -122.466079257059 | (37.7159798527116, -122.466079257059) | 9 | 8 | 6 | 64 | 24 | ||||
| 100447 | 208954 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 600 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 8ft | 5993495.97502 | 2095994.95159 | 37.7348294415148 | -122.464924714122 | (37.7348294415148, -122.464924714122) | 9 | 8 | 4 | 59 | 40 | |||
| 100794 | 209022 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 34 Martha Ave | 2 | Front Yard : Yard | Tree | Private 2 | 33 | 6000785.93499 | 2095562.56819 | 37.7340598511869 | -122.439689867014 | (37.7340598511869, -122.439689867014) | 9 | 7 | 5 | 63 | 40 | ||||
| 102459 | 208944 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 234 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 41 | Width 10ft | 5992497.26068 | 2095992.67828 | 37.7347655644733 | -122.468377420108 | (37.7347655644733, -122.468377420108) | 9 | 8 | 4 | 59 | 40 | |||
| 104749 | 111529 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x BOSWORTH ST | 7 | Front Yard : Yard | Tree | DPW 1 | 24 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 105925 | 111513 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 800x BOSWORTH ST | 8 | Front Yard : Yard | Tree | DPW 1 | 16 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
| 107830 | 209027 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 36 Martha Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10 | 6000763.85093 | 2095573.2374 | 37.7340878893448 | -122.439766982962 | (37.7340878893448, -122.439766982962) | 9 | 7 | 5 | 63 | 40 | ||||
| 110387 | 207760 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 333 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 10ft | 5993144.47081 | 2095802.99513 | 37.7342821033408 | -122.466126031205 | (37.7342821033408, -122.466126031205) | 9 | 8 | 4 | 59 | 40 | |||
| 111543 | 209044 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 690 Mangels Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 10ft | 5996811.85436 | 2095301.80777 | 37.7331168670328 | -122.453410604043 | (37.7331168670328, -122.453410604043) | 9 | 7 | 4 | 59 | 40 | |||
| 111670 | 104402 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 301 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6000011.7 | 2094912.1 | 37.7322297190532 | -122.442319949129 | (37.7322297190532, -122.442319949129) | 9 | 7 | 4 | 63 | 40 | |||||
| 111701 | 209033 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 38 Martha Ave | 2 | Front Yard : Yard | Tree | Private 2 | 10 | 6000746.95442 | 2095582.5977 | 37.7341126287783 | -122.439826070211 | (37.7341126287783, -122.439826070211) | 9 | 7 | 5 | 63 | 40 | ||||
| 112500 | 209000 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 135 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 4ft | 5994206.5655 | 2096669.18291 | 37.7367216600723 | -122.462516864768 | (37.7367216600723, -122.462516864768) | 9 | 8 | 4 | 59 | 40 | |||
| 112642 | 208952 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 440 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 10ft | 5993062.86843 | 2096011.9995 | 37.7348512689743 | -122.466423339872 | (37.7348512689743, -122.466423339872) | 9 | 8 | 4 | 59 | 40 | |||
| 114597 | 208945 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 234 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 40 | Width 10ft | 5992554.30272 | 2095990.82137 | 37.7347637604433 | -122.46818007286 | (37.7347637604433, -122.46818007286) | 9 | 8 | 4 | 59 | 40 | |||
| 122223 | 113804 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 990X OSHAUGHNESSY BLVD | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 3x30 | 6000025 | 2096199 | 37.735764003208 | -122.442366322687 | (37.735764003208, -122.442366322687) | 9 | 7 | 4 | 63 | 40 | ||||
| 126689 | 209021 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 34 Martha Ave | 1 | Front Yard : Yard | Tree | Private 2 | 25 | 6000790.06178 | 2095561.69984 | 37.7340577017886 | -122.43967553722 | (37.7340577017886, -122.43967553722) | 9 | 7 | 5 | 63 | 40 | ||||
| 128365 | 208977 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 300x Marietta Dr | 45 | Median : Cutout | Tree | DPW 1 | 27 | Width 5ft | 5999505.82373 | 2097502.74743 | 37.7393141797969 | -122.444254970484 | (37.7393141797969, -122.444254970484) | 9 | 7 | 4 | 59 | 40 | |||
| 129613 | 209008 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 406 Baden St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6000788.7045 | 2095325.02184 | 37.7334077617457 | -122.439663267741 | (37.7334077617457, -122.439663267741) | 9 | 7 | 5 | 63 | 40 | ||||
| 129920 | 106227 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 38 Stanford Heights Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5997884 | 2095808.5 | 37.7345695210024 | -122.44974042874 | (37.7345695210024, -122.44974042874) | 9 | 7 | 4 | 59 | 40 | |||||
| 134765 | 208974 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 130 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 6ft | 5994229.97779 | 2096604.20114 | 37.7365445844613 | -122.462431207033 | (37.7365445844613, -122.462431207033) | 9 | 8 | 4 | 59 | 40 | |||
| 135166 | 207759 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 315 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 10ft | 5993145.97421 | 2095838.45755 | 37.7343795610583 | -122.46612340967 | (37.7343795610583, -122.46612340967) | 9 | 8 | 4 | 59 | 40 | |||
| 136862 | 105901 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
| 138898 | 209036 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 427 Baden St | 2 | Front Yard : Yard | Tree | Private 2 | 41 | 6000750.14831 | 2095370.65935 | 37.7335308771479 | -122.439799837889 | (37.7335308771479, -122.439799837889) | 9 | 7 | 5 | 63 | 40 | ||||
| 140361 | 209041 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 419 Baden St | 6 | Front Yard : Yard | Tree | Private 2 | 1 | 6000751.4342 | 2095340.23559 | 37.7334474137664 | -122.439793211699 | (37.7334474137664, -122.439793211699) | 9 | 7 | 5 | 63 | 40 | ||||
| 140615 | 96803 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 300X Melrose Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 48 | 5998134.5 | 2095546.7 | 37.7338650092742 | -122.448855518806 | (37.7338650092742, -122.448855518806) | 9 | 7 | 4 | 59 | 40 | ||||
| 142039 | 24268 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 350X Winding Way | 6 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6001111.91618 | 2086587.12369 | 37.7094338594537 | -122.437920185566 | (37.7094338594537, -122.437920185566) | 9 | 7 | 6 | 28861 | 5 | |||
| 142760 | 209024 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 36 Martha Ave | 1 | Front Yard : Yard | Tree | Private 2 | 32 | 6000772.29534 | 2095570.30388 | 37.7340803152378 | -122.439737577826 | (37.7340803152378, -122.439737577826) | 9 | 7 | 5 | 63 | 40 | ||||
| 145692 | 208947 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 340 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 10ft | 5992761.11825 | 2096003.55707 | 37.7348106717797 | -122.467465972472 | (37.7348106717797, -122.467465972472) | 9 | 8 | 4 | 59 | 40 | |||
| 147064 | 207761 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 345 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 41 | Width 10ft | 5993145.03343 | 2095739.54752 | 37.7341079244482 | -122.466119476937 | (37.7341079244482, -122.466119476937) | 9 | 8 | 4 | 59 | 40 | |||
| 147597 | 208980 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 302 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993091.73044 | 2095958.45065 | 37.7347059025462 | -122.466319664239 | (37.7347059025462, -122.466319664239) | 9 | 8 | 4 | 59 | 40 | |||
| 147618 | 208986 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 372 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 3ft | 5993088 | 2095554 | 37.7335951664771 | -122.466303177465 | (37.7335951664771, -122.466303177465) | 9 | 8 | 4 | 59 | 40 | |||
| 150726 | 106275 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 42 Stanford Heights Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5997882.5 | 2095834.4 | 37.7346405503947 | -122.449747480555 | (37.7346405503947, -122.449747480555) | 9 | 7 | 4 | 59 | 40 | |||||
| 151340 | 111511 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 800x BOSWORTH ST | 6 | Front Yard : Yard | Tree | DPW 1 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | |||||
| 151807 | 24267 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 350X Winding Way | 5 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6001124.44895 | 2086586.86413 | 37.7094338594468 | -122.437876851744 | (37.7094338594468, -122.437876851744) | 9 | 7 | 6 | 28861 | 5 | |||
| 154387 | 208956 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 630 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 8ft | 5993584.21489 | 2095997.15656 | 37.7348405832115 | -122.464619800786 | (37.7348405832115, -122.464619800786) | 9 | 8 | 4 | 59 | 40 | |||
| 158171 | 111538 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x BOSWORTH ST | 16 | Front Yard : Yard | Tree | DPW 1 | 28 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 159364 | 208943 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 10ft | 5992457.65692 | 2095992.19703 | 37.7347619554908 | -122.468514307707 | (37.7347619554908, -122.468514307707) | 9 | 8 | 4 | 59 | 40 | |||
| 161254 | 207762 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 10ft | 5993165.17049 | 2095669.26931 | 37.7339161197195 | -122.466044752265 | (37.7339161197195, -122.466044752265) | 9 | 8 | 4 | 59 | 40 |
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) );