trees

484 rows where qSpecies_id = 56 sorted by Neighborhoods (old)

✎ View and edit SQL

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) ▼
161732 23202 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 520X Van Ness Ave 4 Median : Cutout Tree DPW 1     24 9   6006708.88776 2112470.99571 37.7808218241176 -122.420412091366 (37.7808218241176, -122.420412091366) 7 9 9 28852 36
181400 23183 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 520X Van Ness Ave 3 Median : Cutout Tree DPW 1   06/09/2005 12:00:00 AM 6 3X3   6006719.9876 2112427.32903 37.7807025515155 -122.420370591249 (37.7807025515155, -122.420370591249) 7 9 9 28852 36
4881 259031 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 71 Stanton St 3 Unaccepted Street : Yard Tree DPW 1 Private     3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
5343 259035 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 71 Stanton St 7 Unaccepted Street : Yard Tree DPW 1 Private     3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
6781 259030 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 71 Stanton St 2 Unaccepted Street : Yard Tree DPW 1 Private     3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
6957 259032 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 71 Stanton St 4 Unaccepted Street : Yard Tree DPW 1 Private     3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
11644 259033 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 71 Stanton St 5 Unaccepted Street : Yard Tree DPW 1 Private     3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
13646 259034 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 71 Stanton St 6 Unaccepted Street : Yard Tree DPW 1 Private     3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
14634 259029 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 71 Stanton St 1 Unaccepted Street : Yard Tree DPW 1 Private     3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
108717 224262 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 91 Stanton St 2 : Yard Tree Private 2     22 Width 3ft   6000293.691 2103856.20704 37.7568041715846 -122.44198679486 (37.7568041715846, -122.44198679486) 2 4 5 28862 38
181524 121089 Private 9 Eucalyptus globulus :: Blue Gum 56 1X Grand View Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
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
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
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
124 114040 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 LINARES AVE 1 Front Yard : Yard Tree DPW 1     40 3x3   5994258 2102054 37.7515099774588 -122.462729551044 (37.7515099774588, -122.462729551044) 1 8 4 29491 40
686 254311 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190X Junipero Serra Blvd 3 Median : Yard Tree Private 2       10x10   5991377 2095081 37.732197556005 -122.472184075725 (37.732197556005, -122.472184075725) 1 8 4 64 40
891 207770 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 40 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     35 Width 10ft   5993240.61068 2097284.1687 37.7383545825079 -122.465901234858 (37.7383545825079, -122.465901234858) 1 8 4 59 40
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
2446 254284 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 80X Junipero Serra Blvd 8 Median : Yard Tree Private 2       3x3   5991405 2095520 37.733404559811 -122.472119261767 (37.733404559811, -122.472119261767) 1 8 4 64 40
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
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
4266 264742 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 270X Kensington Way 1 Median : Yard Tree Private 2       20x20   5994424 2098888 37.7428264992104 -122.461925951337 (37.7428264992104, -122.461925951337) 1 8 4 59 40
4728 208915 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 55X Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     35 Width 10ft Permit Number 782933 5992083 2096107 37.7350555268004 -122.469817969126 (37.7350555268004, -122.469817969126) 1 8 4 59 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
9638 254322 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 220 Junipero Serra Blvd 3 Median : Cutout Tree Private 2       10x10   5991369 2094955 37.731851128725 -122.472202551974 (37.731851128725, -122.472202551974) 1 8 4 64 40
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
10615 254314 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190X Junipero Serra Blvd 6 Median : Yard Tree Private 2       10x10   5991377 2095081 37.732197556005 -122.472184075725 (37.732197556005, -122.472184075725) 1 8 4 64 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
13030 208963 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 85 Yerba Buena Ave 2 Sidewalk: Curb side : Yard Tree Private 2     30 Width 6ft   5993873 2096938 37.737440549971 -122.463689641388 (37.737440549971, -122.463689641388) 1 8 4 59 40
13191 264743 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 270X Kensington Way 2 Median : Yard Tree Private 2       20x20   5994424 2098888 37.7428264992104 -122.461925951337 (37.7428264992104, -122.461925951337) 1 8 4 59 40
16272 207772 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 60 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     25 Width 10ft   5993256.95856 2097201.9739 37.7381298392237 -122.46583874187 (37.7381298392237, -122.46583874187) 1 8 4 59 40
17188 260389 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 101 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2       10x6   5993303.46118 2096918.61416 37.7373544866644 -122.465657379584 (37.7373544866644, -122.465657379584) 1 8 4 59 40
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
18898 208916 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 55X Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     40 Width 10ft Permit Number 782933 5992083 2096107 37.7350555268004 -122.469817969126 (37.7350555268004, -122.469817969126) 1 8 4 59 40
19448 254323 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 220 Junipero Serra Blvd 4 Median : Cutout Tree Private 2       10x10   5991369 2094955 37.731851128725 -122.472202551974 (37.731851128725, -122.472202551974) 1 8 4 64 40
20382 253206 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2253 09th Ave 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   5993186 2100608 37.7474778324271 -122.466331547971 (37.7474778324271, -122.466331547971) 1 8 4 29491 40
21658 208914 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 45 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     38 Width 10ft   5991964.75621 2096031.6123 37.7348416956868 -122.470221288386 (37.7348416956868, -122.470221288386) 1 8 4 59 40
22036 254321 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 220 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       10x10   5991369 2094955 37.731851128725 -122.472202551974 (37.731851128725, -122.472202551974) 1 8 4 64 40
22782 116019 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2023 09TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   5993447 2101700 37.7504912419676 -122.465508351594 (37.7504912419676, -122.465508351594) 1 8 4 29491 40
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
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
33889 209004 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 156 Kensington Way 4 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   5994803.6888 2098556.09355 37.7419370183784 -122.460589057359 (37.7419370183784, -122.460589057359) 1 8 4 59 40
35780 254316 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200X Junipero Serra Blvd 3 Median : Yard Tree Private 2       10x10   5991374 2095037 37.73207656946 -122.472191241156 (37.73207656946, -122.472191241156) 1 8 4 64 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
36995 254312 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190X Junipero Serra Blvd 4 Median : Yard Tree Private 2       10x10   5991377 2095081 37.732197556005 -122.472184075725 (37.732197556005, -122.472184075725) 1 8 4 64 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
38371 254283 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 80X Junipero Serra Blvd 7 Median : Yard Tree Private 2       3x3   5991405 2095520 37.733404559811 -122.472119261767 (37.733404559811, -122.472119261767) 1 8 4 64 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
42039 207775 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 110 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     27 Width 10ft   5993244.34274 2096906.29835 37.737317260394 -122.465860883191 (37.737317260394, -122.465860883191) 1 8 4 59 40
42550 208970 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 20 Yerba Buena Ave 2 Sidewalk: Curb side : Yard Tree Private 2     28 Width 6ft   5993484.40904 2097144.77152 37.7379858937365 -122.465048184725 (37.7379858937365, -122.465048184725) 1 8 4 59 40
44214 208933 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 405 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     31 Width 10ft   5992936.60702 2096064.26617 37.7349874937845 -122.466863664131 (37.7349874937845, -122.466863664131) 1 8 4 59 40
44574 208991 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 45 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     28 Width 4ft   5993638.39674 2097082.374 37.7378234437858 -122.464511248112 (37.7378234437858, -122.464511248112) 1 8 4 59 40
45573 208969 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 30 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     27 Width 6ft   5993545.78483 2097101.19005 37.7378697687758 -122.464832815983 (37.7378697687758, -122.464832815983) 1 8 4 59 40
47282 207782 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 260 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     24 Width 10ft   5993076.07579 2096352.69881 37.7357875063795 -122.466402431535 (37.7357875063795, -122.466402431535) 1 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
49183 208959 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 601 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     28 Width 8ft   5993493.92403 2096119.04846 37.7351700624345 -122.46494081468 (37.7351700624345, -122.46494081468) 1 8 4 59 40
49989 207806 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 35 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     32 Width 10ft   5993241.00806 2097448.11917 37.7388047723291 -122.465911770435 (37.7388047723291, -122.465911770435) 1 8 4 59 40
51052 207773 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 80 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     58 Width 10ft   5993272.22832 2097088.94625 37.7378203744176 -122.465777737259 (37.7378203744176, -122.465777737259) 1 8 4 59 40
51225 254298 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 140 Junipero Serra Blvd 1 Median : Cutout Tree Private 2       3x3   5991388 2095260 37.73268968153 -122.472159089582 (37.73268968153, -122.472159089582) 1 8 4 64 40
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
55299 208919 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     38 Width 10ft   5992247.91507 2096042.07051 37.734886777798 -122.469243079632 (37.734886777798, -122.469243079632) 1 8 4 59 40
56798 208958 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 625 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     26 Width 8ft   5993531.51586 2096121.15742 37.7351780205546 -122.464811000239 (37.7351780205546, -122.464811000239) 1 8 4 59 40
56919 208997 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 10 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     31 Width 4ft   5993343.64638 2097250.7379 37.7382687332076 -122.465542562746 (37.7382687332076, -122.465542562746) 1 8 4 59 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
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
58510 254319 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 210 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       10x10   5991371 2094995 37.7319610744091 -122.472198552297 (37.7319610744091, -122.472198552297) 1 8 4 64 40
59512 207781 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 256 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     19 Width 10ft   5993074.74882 2096403.4667 37.7359268257591 -122.466410707985 (37.7359268257591, -122.466410707985) 1 8 4 59 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
61500 208994 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 21 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     29 Width 4ft   5993511.28023 2097168.00802 37.7380512447772 -122.464956965598 (37.7380512447772, -122.464956965598) 1 8 4 59 40
62369 209003 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 96 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     43 Width 3ft   5994450.97172 2101378.39351 37.7496660456507 -122.462013248027 (37.7496660456507, -122.462013248027) 1 8 4 29491 40
62726 207808 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 15 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     25 Width 10ft   5993219.05388 2097526.21938 37.7390179494069 -122.465993350619 (37.7390179494069, -122.465993350619) 1 8 4 59 40
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
65313 114042 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 LINARES AVE 3 Front Yard : Yard Tree DPW 1       3x3   5994258 2102054 37.7515099774588 -122.462729551044 (37.7515099774588, -122.462729551044) 1 8 4 29491 40
65378 208922 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 201 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     25 Width 10ft   5992403.02946 2096048.00133 37.7349120244605 -122.468707231169 (37.7349120244605, -122.468707231169) 1 8 4 59 40
65949 207807 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 25 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     22 Width 10ft   5993231.15579 2097483.74028 37.7389020106052 -122.465948422302 (37.7389020106052, -122.465948422302) 1 8 4 59 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
66814 114041 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 LINARES AVE 2 Front Yard : Yard Tree DPW 1       3x3   5994258 2102054 37.7515099774588 -122.462729551044 (37.7515099774588, -122.462729551044) 1 8 4 29491 40
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
73374 207800 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101 Santa Clara Ave 3 Sidewalk: Curb side : Yard Tree Private 2     42 Width 10ft   5993292.57138 2096874.95335 37.7372339768612 -122.465691859205 (37.7372339768612, -122.465691859205) 1 8 4 59 40
74248 208929 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 501 Saint Francis Blvd 1 Sidewalk: Curb side : Pot Tree Private 2     34 Width 6ft   5993145.62708 2096072.03007 37.735020873007 -122.466141577798 (37.735020873007, -122.466141577798) 1 8 4 59 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
75560 207778 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 124 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 10ft   5993200.08857 2096786.31561 37.7369852648432 -122.466005173107 (37.7369852648432, -122.466005173107) 1 8 4 59 40
76480 208928 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 335 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     44 Width 10ft   5992778.53612 2096059.14942 37.7349643200549 -122.467409794552 (37.7349643200549, -122.467409794552) 1 8 4 59 40
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
77856 254300 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 140 Junipero Serra Blvd 3 Median : Cutout Tree Private 2       3x3   5991388 2095260 37.73268968153 -122.472159089582 (37.73268968153, -122.472159089582) 1 8 4 64 40

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);