trees

484 rows where qSpecies_id = 56 sorted by DBH

✎ 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)
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
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
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
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
5342 260946 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 351X Upper Ter 3 Unaccepted Street : Yard Tree DPW 1       3x3   5999155 2106055 37.7627765565078 -122.446082944502 (37.7627765565078, -122.446082944502) 15 5 5 29492 9
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
7245 251144 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
8037 257932 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
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
10388 251145 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
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
11415 260944 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 351X Upper Ter 1 Unaccepted Street : Yard Tree DPW 1       3x3   5999155 2106055 37.7627765565078 -122.446082944502 (37.7627765565078, -122.446082944502) 15 5 5 29492 9
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
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
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
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
14474 260945 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 351X Upper Ter 2 Unaccepted Street : Yard Tree DPW 1       3x3   5999155 2106055 37.7627765565078 -122.446082944502 (37.7627765565078, -122.446082944502) 15 5 5 29492 9
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
15695 262389 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 67 Rosenkranz St 1 Side Yard : Yard Tree DPW 1       3x3   6009267 2098344 37.7421761391661 -122.410564417702 (37.7421761391661, -122.410564417702) 10 7 7 28859 2
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
18104 260417 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 335 Corbett Ave 1 Median : Cutout Tree DPW 1       3x3   5999565 2105069 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425) 15 5 5 28862 3
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
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
20018 256139 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 888 Moultrie St 1 Unaccepted Street : Cutout Tree Private 2       3x3   6007515 2095179 37.7333873668614 -122.416398174089 (37.7333873668614, -122.416398174089) 2 7 7 28859 2
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
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
23740 255978 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 1 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
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
30833 258289 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 6 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
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
36331 256763 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
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
37033 92037 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
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
43440 92035 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
43919 113860 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 456 HILL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003369 2103347 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346) 2 4 5 28862 22
45615 251302 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1 Cashmere St 1 Back Yard : Yard Tree Health Dept 13       3x3   6017463 2095772 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696) 10 3 8 58 1
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
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
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
59936 92040 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
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
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
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
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
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
78408 254301 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 140 Junipero Serra Blvd 4 Median : Cutout Tree Private 2       3x3   5991388 2095260 37.73268968153 -122.472159089582 (37.73268968153, -122.472159089582) 1 8 4 64 40
80047 254287 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100X Junipero Serra Blvd 3 Median : Yard Tree Private 2       3x3   5991400 2095443 37.7331928478719 -122.472130937334 (37.7331928478719, -122.472130937334) 1 8 4 64 40
81197 92036 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
81211 116020 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2023 09TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   5993447 2101700 37.7504912419676 -122.465508351594 (37.7504912419676, -122.465508351594) 1 8 4 29491 40
82626 258290 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 7 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
82917 254315 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200X Junipero Serra Blvd 2 Median : Yard Tree Private 2       10x10   5991374 2095037 37.73207656946 -122.472191241156 (37.73207656946, -122.472191241156) 1 8 4 64 40
84733 253848 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 230 Junipero Serra Blvd 3 Median : Yard Tree Private 2       10X10   5991365 2094903 37.7317081183109 -122.472212591573 (37.7317081183109, -122.472212591573) 1 8 4 64 40
85519 113859 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 456 HILL ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003369 2103347 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346) 2 4 5 28862 22
87323 173856 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 118 Saint Mary's Ave 2 Sidewalk: Property side : Yard Tree DPW 1       Width 3ft   6003956.18287 2095944.61673 37.7352888053199 -122.42875656067 (37.7352888053199, -122.42875656067) 2 7 5 63 7
90362 254305 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 170 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       10x10   5991380 2095134 37.732343254282 -122.47217756607 (37.732343254282, -122.47217756607) 1 8 4 64 40
93652 115295 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 500X 08TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010511 2109243 37.7721720235673 -122.407031076357 (37.7721720235673, -122.407031076357) 14 2 9 28853 34
94300 113861 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 456 HILL ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003369 2103347 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346) 2 4 5 28862 22
97567 254310 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190X Junipero Serra Blvd 2 Median : Yard Tree Private 2       10x10   5991377 2095081 37.732197556005 -122.472184075725 (37.732197556005, -122.472184075725) 1 8 4 64 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
101469 254309 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 170 Junipero Serra Blvd 6 Median : Cutout Tree Private 2       10x10   5991380 2095134 37.732343254282 -122.47217756607 (37.732343254282, -122.47217756607) 1 8 4 64 40
104292 253843 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 130X Junipero Serra Blvd 1 Median : Yard Tree Private 2       10x30   5991393 2095322 37.7328602072681 -122.472146321186 (37.7328602072681, -122.472146321186) 1 8 4 64 40
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
104555 258287 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 4 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
104699 114731 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 934 BRANNAN ST   Back Yard : Yard Tree Private 2 Dept of Real Estate     10x10   6010724 2108745 37.7708165471861 -122.406259194073 (37.7708165471861, -122.406259194073) 14 2 9 28853 34
104882 254303 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 140 Junipero Serra Blvd 6 Median : Cutout Tree Private 2       3x3   5991388 2095260 37.73268968153 -122.472159089582 (37.73268968153, -122.472159089582) 1 8 4 64 40
104986 114043 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 LINARES AVE 4 Front Yard : Yard Tree DPW 1       3x3   5994258 2102054 37.7515099774588 -122.462729551044 (37.7515099774588, -122.462729551044) 1 8 4 29491 40
106673 256140 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 892 Moultrie St 1 Side Yard : Yard Tree Private 2       3x3   6007512 2095150 37.7333075704823 -122.416406492547 (37.7333075704823, -122.416406492547) 2 7 7 28859 2
107250 92038 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 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
118601 113862 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 456 HILL ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003369 2103347 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346) 2 4 5 28862 22
119017 105441 Private 9 Eucalyptus globulus :: Blue Gum 56 425 WAWONA ST   unknown : Yard Tree Private 2           5991587.6 2097036.5 37.7375790508831 -122.471598439568 (37.7375790508831, -122.471598439568) 1 8 4 29491 40
119656 114409 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 500X ARBALLO DR 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
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
123942 114396 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 35 HIGUERA AVE 3 Sidewalk: Curb side : Cutout Tree Private 2           5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
124028 257931 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
128096 256447 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3001 Sunset Blvd 31 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
128772 258286 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 3 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
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
130715 251303 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1 Cashmere St 2 Back Yard : Yard Tree Health Dept 13       3x3   6017463 2095772 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696) 10 3 8 58 1
131738 92899 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 208 States St 3 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
132170 253847 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190X Junipero Serra Blvd 1 Median : Yard Tree Private 2       10x10   5991377 2095081 37.732197556005 -122.472184075725 (37.732197556005, -122.472184075725) 1 8 4 64 40
132508 254295 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 110 Junipero Serra Blvd 7 Median : Yard Tree Private 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
134246 258292 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 9 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
137649 108201 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 90 Reuel Ct 2 Front Yard : Yard Tree Private 2         Permit Number 774102 6017404.09127 2096025.61699 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258) 10 3 8 58 1
138399 254281 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 80X Junipero Serra Blvd 5 Median : Yard Tree Private 2       3x3   5991405 2095520 37.733404559811 -122.472119261767 (37.733404559811, -122.472119261767) 1 8 4 64 40
140170 253136 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3059 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x5   5999298 2114593 37.7862278895056 -122.446202552789 (37.7862278895056, -122.446202552789) 15 6 1 29490 31
140860 253846 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 150 Junipero Serra Blvd 3 Median : Cutout Tree Private 2       3x3   5991384 2095197 37.7325164679088 -122.472168327848 (37.7325164679088, -122.472168327848) 1 8 4 64 40
141599 251417 Private 9 Eucalyptus globulus :: Blue Gum 56 418 19th Ave 1 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5990003 2112517 37.7799925618685 -122.478208632121 (37.7799925618685, -122.478208632121) 11 6 2 55 26
145770 258288 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 5 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
147660 92033 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
147696 258285 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 2 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22

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