trees
484 rows where qSpecies_id = 56 sorted by PlotSize
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 | ||||
1081 | 52091 | Permitted Site 7 | Eucalyptus globulus :: Blue Gum 56 | 300 Dorantes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2005 12:00:00 AM | Permit Number 48287 | 5993176.51233561 | 2099718.04340733 | 37.7450336906204 | -122.466299687476 | (37.7450336906204, -122.466299687476) | 1 | 8 | 4 | 29491 | 40 | |||
1776 | 247999 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450 Peralta Ave | 3 | Side Yard : Yard | Tree | Private 2 | 35 | 6009750 | 2099218 | 37.744603019334 | -122.408955999129 | (37.744603019334, -122.408955999129) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
3109 | 224224 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 14 | Front Yard : Yard | Tree | Private 2 | 18 | 6004854.03678 | 2096713.39587 | 37.7374504751573 | -122.425707047762 | (37.7374504751573, -122.425707047762) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
4988 | 224247 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 701X Powhattan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 46 | 6008745.22263 | 2098103.60695 | 37.7414868060782 | -122.412351580256 | (37.7414868060782, -122.412351580256) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
6347 | 224265 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 58 Poppy Ln | 1 | Back Yard : Yard | Tree | Private 2 | 38 | 6002671.84671 | 2096513.90824 | 37.7367791753169 | -122.433237644116 | (37.7367791753169, -122.433237644116) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
8712 | 207757 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5994806.26925 | 2105291.62903 | 37.7604312408178 | -122.461068228734 | (37.7604312408178, -122.461068228734) | 15 | 5 | 4 | 56 | 12 | ||||
11269 | 247818 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1158x Jarboe Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 46 | 6009634.53348 | 2096844.36766 | 37.7380790724954 | -122.409187798594 | (37.7380790724954, -122.409187798594) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
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 | |
17952 | 176334 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 287 Hester Ave | 7 | Side Yard : Yard | Tree | Private 2 | 34 | 6012223.87562 | 2087782.54699 | 37.713341893097 | -122.399599040764 | (37.713341893097, -122.399599040764) | 10 | 3 | 8 | 309 | 1 | ||||
20776 | 247930 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 3 | Side Yard : Yard | Tree | Private 2 | 18 | 6010384.98383 | 2098777.78466 | 37.7434298327179 | -122.406729322818 | (37.7434298327179, -122.406729322818) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
21173 | 224240 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 42 | Front Yard : Yard | Tree | Private 2 | 36 | 6004759.95311 | 2096625.2597 | 37.7372031562031 | -122.426026066958 | (37.7372031562031, -122.426026066958) | 2 | 7 | 5 | 63 | 7 | ||||
22151 | 224233 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 23 | Front Yard : Yard | Tree | Private 2 | 22 | 6004845.23458 | 2096693.018 | 37.7373940247252 | -122.42573603111 | (37.7373940247252, -122.42573603111) | 2 | 7 | 5 | 63 | 7 | ||||
23607 | 224229 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 19 | Front Yard : Yard | Tree | Private 2 | 14 | 6004833.29966 | 2096702.67223 | 37.7374198586269 | -122.425777982686 | (37.7374198586269, -122.425777982686) | 2 | 7 | 5 | 63 | 7 | ||||
23613 | 248107 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 138 Rutledge St | 1 | Side Yard : Yard | Tree | Private 2 | 35 | 6010423.63855 | 2099478.50343 | 37.7453560168793 | -122.406645033853 | (37.7453560168793, -122.406645033853) | 2 | 7 | 7 | 28859 | 2 | ||||
23924 | 92900 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 4 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
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 | ||||
30561 | 224223 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 13 | Front Yard : Yard | Tree | Private 2 | 21 | 6004855.41269 | 2096718.43509 | 37.7374643894683 | -122.425702649156 | (37.7374643894683, -122.425702649156) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
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 | ||||
34158 | 191733 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 5 | Front Yard : Yard | Tree | Private 2 | 25 | 6009990.50539 | 2107548.56259 | 37.7674903487254 | -122.408711960091 | (37.7674903487254, -122.408711960091) | 8 | 4 | 8 | 28853 | 19 | ||||
36161 | 106795 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 199X ARLINGTON ST | 55 | Median : Cutout | Tree | DPW 1 | 12 | 6005045 | 2097131 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | 2 | 7 | 5 | 63 | 7 | ||||
36885 | 246762 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Waltham St | 6 | Front Yard : Yard | Tree | Private 2 | 38 | 6009259.9688 | 2098886.63063 | 37.743665689828 | -122.410627040331 | (37.743665689828, -122.410627040331) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
37673 | 246758 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Waltham St | 2 | Front Yard : Yard | Tree | Private 2 | 45 | 6009165.37597 | 2098887.8964 | 37.7436638615084 | -122.410954210088 | (37.7436638615084, -122.410954210088) | 2 | 7 | 7 | 28859 | 2 | ||||
42456 | 191735 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 8 | Front Yard : Yard | Tree | Private 2 | 27 | 6010009.09697 | 2107534.42743 | 37.7674525780981 | -122.408646656734 | (37.7674525780981, -122.408646656734) | 8 | 4 | 8 | 28853 | 19 | ||||
44584 | 116530 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 745X SANCHEZ ST | 7 | Median : Yard | Tree | DPW 1 | 45 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | ||||
44889 | 191727 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1790 23rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6013509.42079 | 2102917.94191 | 37.7549721419751 | -122.396215837988 | (37.7549721419751, -122.396215837988) | 10 | 3 | 8 | 28856 | 29 | ||||
45655 | 121204 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 44 MacOndray Ln | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 52 | 6008473.20212 | 2119153.5676 | 37.7992698007193 | -122.41478152415 | (37.7992698007193, -122.41478152415) | 5 | 1 | 10 | 308 | 32 | ||||
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 | ||||
51387 | 224267 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2300 22nd St | 3 | Front Yard : Yard | Tree | Private 2 | 26 | 6011260.20343 | 2103721.90369 | 37.7570542343818 | -122.40405088815 | (37.7570542343818, -122.40405088815) | 10 | 4 | 8 | 28859 | 19 | ||||
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 | ||||
52709 | 191734 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 7 | Front Yard : Yard | Tree | Private 2 | 22 | 6009976.80194 | 2107534.39117 | 37.7674506697311 | -122.408758358812 | (37.7674506697311, -122.408758358812) | 8 | 4 | 8 | 28853 | 19 | ||||
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 | ||||
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 | ||||
59460 | 207755 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | 5994788.04604 | 2105291.71815 | 37.7604304368423 | -122.461131260407 | (37.7604304368423, -122.461131260407) | 15 | 5 | 4 | 56 | 12 | ||||
59596 | 224230 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 20 | Front Yard : Yard | Tree | Private 2 | 9 | 6004850.15407 | 2096702.70071 | 37.7374208892559 | -122.425719711103 | (37.7374208892559, -122.425719711103) | 2 | 7 | 5 | 63 | 7 | ||||
61418 | 224219 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1201 San Jose Ave | 4 | Front Yard : Yard | Tree | Private 2 | 7 | 6004118.53569 | 2095824.97349 | 37.7349694794509 | -122.428186723249 | (37.7349694794509, -122.428186723249) | 2 | 7 | 5 | 28861 | 2 | ||||
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 | ||||
63828 | 247922 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 7 | Side Yard : Yard | Tree | Private 2 | 24 | 6010270.94858 | 2098720.09099 | 37.7432650373678 | -122.40711956383 | (37.7432650373678, -122.40711956383) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
64704 | 224244 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 38 | Front Yard : Yard | Tree | Private 2 | 23 | 6004777.47133 | 2096641.46229 | 37.7372486349267 | -122.425966651467 | (37.7372486349267, -122.425966651467) | 2 | 7 | 5 | 63 | 7 | ||||
64758 | 191722 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6014479.64038 | 2101959.5389 | 37.7523945096015 | -122.392793471535 | (37.7523945096015, -122.392793471535) | 10 | 3 | 8 | 28856 | 1 | ||||
65072 | 224234 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 24 | Front Yard : Yard | Tree | Private 2 | 13 | 6004836.88053 | 2096694.1378 | 37.7373966273622 | -122.425764994654 | (37.7373966273622, -122.425764994654) | 2 | 7 | 5 | 63 | 7 | ||||
65425 | 191724 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 950x Kansas St | 5 | Median : Yard | Tree | DPW 1 | 43 | 6011608.52294 | 2103823.60133 | 37.7573529289142 | -122.402853412073 | (37.7573529289142, -122.402853412073) | 10 | 3 | 8 | 28856 | 29 | ||||
66487 | 207756 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 49 | 5994800.39892 | 2105292.04488 | 37.7604320448233 | -122.461088561491 | (37.7604320448233, -122.461088561491) | 15 | 5 | 4 | 56 | 12 | ||||
67100 | 247923 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 8 | Side Yard : Yard | Tree | Private 2 | 17 | 6010288.87158 | 2098729.72842 | 37.7432925026595 | -122.407058269637 | (37.7432925026595, -122.407058269637) | 10 | 7 | 7 | 28859 | 2 | ||||
68807 | 43994 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 141 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2000 12:00:00 AM | 18 | Permit Number 43551 | 6010001.85414 | 2107517.13485 | 37.7674046909874 | -122.408670488759 | (37.7674046909874, -122.408670488759) | 8 | 4 | 8 | 28853 | 19 | ||
69473 | 224239 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 36 | Front Yard : Yard | Tree | Private 2 | 37 | 6004801.05123 | 2096666.83115 | 37.7373196246961 | -122.425886930149 | (37.7373196246961, -122.425886930149) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
71078 | 247924 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 9 | Side Yard : Yard | Tree | Private 2 | 23 | 6010297.69523 | 2098727.78354 | 37.7432876562154 | -122.407027622545 | (37.7432876562154, -122.407027622545) | 10 | 7 | 7 | 28859 | 2 | ||||
73242 | 224246 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 483 Valley St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 55 | 6002830.24391 | 2099168.61142 | 37.7440773607828 | -122.432879592517 | (37.7440773607828, -122.432879592517) | 2 | 7 | 5 | 63 | 22 | ||||
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 | ||||
76221 | 224266 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2300 22nd St | 2 | Front Yard : Yard | Tree | Private 2 | 28 | 6011271.09407 | 2103721.28577 | 37.7570531461907 | -122.404013180481 | (37.7570531461907, -122.404013180481) | 10 | 4 | 8 | 28859 | 19 | ||||
77703 | 224237 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 29 | Front Yard : Yard | Tree | Private 2 | 19 | 6004814.56562 | 2096681.78705 | 37.7373614539559 | -122.425841268876 | (37.7373614539559, -122.425841268876) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
78464 | 224232 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 22 | Front Yard : Yard | Tree | Private 2 | 6 | 6004847.66693 | 2096700.74316 | 37.7374153737207 | -122.425728171024 | (37.7374153737207, -122.425728171024) | 2 | 7 | 5 | 63 | 7 | ||||
78746 | 224242 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 40 | Front Yard : Yard | Tree | Private 2 | 5 | 6004773.22407 | 2096631.25513 | 37.7372203683314 | -122.425980609816 | (37.7372203683314, -122.425980609816) | 2 | 7 | 5 | 63 | 7 | ||||
79539 | 95436 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 2675 25th Ave | 3 | Unaccepted Street : Yard | Tree | Private 2 | 16 | 5988610 | 2097126.3 | 37.7376529013161 | -122.481899870051 | (37.7376529013161, -122.481899870051) | 1 | 8 | 3 | 29491 | 35 | ||||
80374 | 248219 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Fair Ave | 2 | Side Yard : Yard | Tree | Private 2 | 38 | 6007128.32554 | 2099340.74379 | 37.7447928407342 | -122.418029950029 | (37.7447928407342, -122.418029950029) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
82854 | 114075 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 24 HIGUERA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||||
87775 | 246757 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Waltham St | 1 | Front Yard : Yard | Tree | Private 2 | 27 | 6009117.20748 | 2098899.99025 | 37.7436943673943 | -122.41112161979 | (37.7436943673943, -122.41112161979) | 2 | 7 | 7 | 28859 | 2 | ||||
88934 | 247919 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 4 | Side Yard : Yard | Tree | Private 2 | 22 | 6010242.48982 | 2098715.37522 | 37.7432504962209 | -122.40721763491 | (37.7432504962209, -122.40721763491) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
89483 | 224222 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 6004869.89816 | 2096730.73115 | 37.7374989702074 | -122.425653440952 | (37.7374989702074, -122.425653440952) | 2 | 7 | 5 | 63 | 7 | ||||
90994 | 113367 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 6X Christopher Dr | 1 | Front Yard : Yard | Tree | DPW 1 | 25 | 5996701.11551 | 2103988.82524 | 37.7569629284433 | -122.454420756361 | (37.7569629284433, -122.454420756361) | 1 | 5 | 4 | 63 | 12 | ||||
96951 | 247928 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 22 | 6010393.74755 | 2098772.89885 | 37.7434169076795 | -122.406698675702 | (37.7434169076795, -122.406698675702) | 10 | 7 | 7 | 28859 | 2 | ||||
97103 | 247917 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 2 | Side Yard : Yard | Tree | Private 2 | 32 | 6010231.88216 | 2098716.76824 | 37.7432537274832 | -122.407254411775 | (37.7432537274832, -122.407254411775) | 10 | 7 | 7 | 28859 | 2 | ||||
99245 | 224225 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 15 | Front Yard : Yard | Tree | Private 2 | 32 | 6004862.25492 | 2096710.90423 | 37.737444098063 | -122.425678456492 | (37.737444098063, -122.425678456492) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
103652 | 247921 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 6 | Side Yard : Yard | Tree | Private 2 | 38 | 6010260.8237 | 2098716.17835 | 37.7432537274883 | -122.407154297447 | (37.7432537274883, -122.407154297447) | 10 | 7 | 7 | 28859 | 2 | ||||
104435 | 106173 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 267 Green St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 771881 | 6011670.8 | 2119368.7 | 37.8000396459541 | -122.403731811098 | (37.8000396459541, -122.403731811098) | 3 | 1 | 10 | 308 | 23 | ||||
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 | ||||
106420 | 224238 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 30 | Front Yard : Yard | Tree | Private 2 | 6 | 6004809.6017 | 2096680.00592 | 37.737356282853 | -122.425858304718 | (37.737356282853, -122.425858304718) | 2 | 7 | 5 | 63 | 7 | ||||
106599 | 224227 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 17 | Front Yard : Yard | Tree | Private 2 | 12 | 6004843.36157 | 2096707.31423 | 37.7374331731056 | -122.425743524245 | (37.7374331731056, -122.425743524245) | 2 | 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 | ||||
110057 | 191738 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 920 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6011311.04969 | 2104026.19787 | 37.757892599481 | -122.403896453867 | (37.757892599481, -122.403896453867) | 10 | 3 | 8 | 28856 | 29 | ||||
111534 | 224236 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 San Jose Ave | 26 | Front Yard : Yard | Tree | Private 2 | 25 | 6004818.97924 | 2096691.85028 | 37.737389334736 | -122.425826725021 | (37.737389334736, -122.425826725021) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
112880 | 191737 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200 Helena St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6010885.73151 | 2096220.33708 | 37.7364356342809 | -122.404817839882 | (37.7364356342809, -122.404817839882) | 10 | 3 | 8 | 58 | 1 | ||||
114444 | 176336 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 287 Hester Ave | 9 | Side Yard : Yard | Tree | Private 2 | 31 | 6012249.60162 | 2087766.47281 | 37.7132991905898 | -122.39950899437 | (37.7132991905898, -122.39950899437) | 10 | 3 | 8 | 309 | 1 |
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) );