trees

484 rows where qSpecies_id = 56 sorted by Supervisor Districts

✎ 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)
819 20315 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
1295 19941 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY38 10 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
2286 20017 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY48 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
2572 20316 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
3457 20016 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY48 0 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
7537 19938 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY38 7 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
8170 19942 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY38 11 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
10058 20314 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
12313 20320 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
13640 19939 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY38 8 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
17517 19940 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY38 9 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
17932 20319 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
19409 20318 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
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
146647 17957 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2500 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6001928.8852 2115030.4127 37.7875788082428 -122.437131721785 (37.7875788082428, -122.437131721785) 13 6 1 29490 27
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
82973 126581 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 556 Pine St 2 Sidewalk: Property side : Yard Tree Private 2     20 Width 5ft   6011285.65956 2116338.25251 37.7916972455684 -122.404851076143 (37.7916972455684, -122.404851076143) 5 1 10 28857 6
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
153947 249920 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 358 Greenwich St 5 Back Yard : Yard Tree Private 2     35 Width 0ft   6011181.16541 2120413.994 37.8028824034529 -122.405499802075 (37.8028824034529, -122.405499802075) 3 1 10 308 23
2730 138025 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     49 Width 0ft   6004878.9655 2114979.8902 37.7876073348692 -122.426921423586 (37.7876073348692, -122.426921423586) 13 9 11 28858 27
2985 138087 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 6 Sidewalk: Curb side : Cutout Tree DPW 1     30 Width 0ft   6004894.5944 2114873.9606 37.7873173623789 -122.426859803648 (37.7873173623789, -122.426859803648) 13 9 11 28858 27
4739 138026 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1     57 Width 0ft   6004881.8597 2114953.842 37.7875359766764 -122.426909554358 (37.7875359766764, -122.426909554358) 13 9 11 28858 27
5001 138027 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 4 Sidewalk: Curb side : Cutout Tree DPW 1     39 Width 0ft   6004885.3328 2114935.3188 37.7874853129815 -122.426896218405 (37.7874853129815, -122.426896218405) 13 9 11 28858 27
6626 138028 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 5 Sidewalk: Curb side : Cutout Tree DPW 1     49 Width 0ft   6004887.6482 2114917.9533 37.7874377625804 -122.426886970359 (37.7874377625804, -122.426886970359) 13 9 11 28858 27
13887 2618 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 5 Sidewalk: Curb side : Cutout Tree DPW 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
16383 7808 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 700X Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6006239.03041 2112534.82936 37.7809706070447 -122.422042095466 (37.7809706070447, -122.422042095466) 7 9 11 28852 41
18571 138024 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     48 Width 0ft   6004873.7558 2115028.5137 37.7877405482561 -122.42694291248 (37.7877405482561, -122.42694291248) 13 9 11 28858 27
28953 2619 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 6 Sidewalk: Curb side : Cutout Tree DPW 1     36 10X10   6004877.75733 2115027.26874 37.7877373561683 -122.426928979241 (37.7877373561683, -122.426928979241) 13 9 11 28858 27
40122 2614 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
47435 2617 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 4 Sidewalk: Curb side : Cutout Tree DPW 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
77234 207754 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1364 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5993663.75343 2106217.17575 37.7629067380829 -122.4650868556 (37.7629067380829, -122.4650868556) 1 8 11 56 12
108912 245009 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1466 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 0ft   5999558.6674 2109145.6245 37.7712856788974 -122.444908986977 (37.7712856788974, -122.444908986977) 15 5 11 29492 9
146721 2615 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
162434 24323 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 600X Golden Gate Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6006332.38089 2112512.31586 37.7809140549901 -122.421717549941 (37.7809140549901, -122.421717549941) 7 9 11 28852 41
165250 2616 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1     42 10X10   6004876.92395 2115038.87855 37.7877691866782 -122.426932689756 (37.7877691866782, -122.426932689756) 13 9 11 28858 27
168667 224263 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11 Germania St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004229.44428 2108900.23084 37.7708773466362 -122.428735070474 (37.7708773466362, -122.428735070474) 7 9 11 29492 10
170276 224264 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11 Germania St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004254.57068 2108904.38845 37.7708901844568 -122.42864845406 (37.7708901844568, -122.42864845406) 7 9 11 29492 10
124476 118438 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 5201 Anza St 6 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5982520.38622 2111663.82262 37.7772127952946 -122.504030702291 (37.7772127952946, -122.504030702291) 11 6 2 55 26
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
66615 185931 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2000 Sunset Blvd 74 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985001.315 2101504.3546 37.749463324704 -122.494699314147 (37.749463324704, -122.494699314147) 1 8 3 29491 35
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
103049 185917 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2000 Sunset Blvd 60 Sidewalk: Property side : Yard Tree Private 2     16 Width 0ft   5985004.5736 2101420.7172 37.7492338700088 -122.494681880668 (37.7492338700088, -122.494681880668) 1 8 3 29491 35
192427 185929 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2000 Sunset Blvd 72 Sidewalk: Property side : Yard Tree Private 2     99 Width 0ft   5985012.7201 2101493.4926 37.7494341681805 -122.494659074897 (37.7494341681805, -122.494659074897) 1 8 3 29491 35
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
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
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
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
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
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
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
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
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
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
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
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
58186 105492 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1575 07TH AVE 6 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 773490 5993962.3 2104771.9 37.7589555970933 -122.463949378571 (37.7589555970933, -122.463949378571) 1 8 4 56 12
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

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