trees

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

✎ 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) ▲
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
118846 106794 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 199X ARLINGTON ST 51 Median : Cutout Tree DPW 1     18     6005045 2097131 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639) 2 7 5 63 7
124274 106792 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 199X ARLINGTON ST 1 Median : Cutout Tree DPW 1     15     6005045 2097131 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639) 2 7 5 63 7
134080 114044 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 549X ARLINGTON ST   Median : Cutout Tree Private 2     70     6003400 2095634 37.7344044281823 -122.430657330781 (37.7344044281823, -122.430657330781) 2 7 5 63 7
144923 224243 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 39 Front Yard : Yard Tree Private 2     20     6004771.77471 2096643.75237 37.73725460102 -122.425986510284 (37.73725460102, -122.425986510284) 2 7 5 63 7
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
149188 92034 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 2 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
151340 111511 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 800x BOSWORTH ST 6 Front Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
153588 224221 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1000 San Jose Ave 63 Front Yard : Yard Tree Private 2     15     6005093.24107 2097044.161 37.7383721957242 -122.424903531393 (37.7383721957242, -122.424903531393) 2 7 5 28859 7
154172 224228 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 18 Front Yard : Yard Tree Private 2     15     6004840.27089 2096702.34469 37.7374193532181 -122.425753856564 (37.7374193532181, -122.425753856564) 2 7 5 63 7
157947 224235 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 25 Front Yard : Yard Tree Private 2     17     6004831.64132 2096688.95275 37.7373820943173 -122.425782740103 (37.7373820943173, -122.425782740103) 2 7 5 63 7
158171 111538 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 900x BOSWORTH ST 16 Front Yard : Yard Tree DPW 1     28     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
160808 169607 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 118 Saint Mary's Ave 1 Sidewalk: Property side : Yard Tree DPW 1     0 Width 3ft   6003956.18287 2095944.61673 37.7352888053199 -122.42875656067 (37.7352888053199, -122.42875656067) 2 7 5 63 7
164002 111525 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 900x BOSWORTH ST 3 Front Yard : Yard Tree DPW 1     26     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
164270 92039 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 7 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
166193 224231 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 21 Front Yard : Yard Tree Private 2     23     6004851.9976 2096696.37519 37.7374036249796 -122.425712887063 (37.7374036249796, -122.425712887063) 2 7 5 63 7
177479 111548 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 900x BOSWORTH ST 26 Front Yard : Yard Tree DPW 1     40     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
187643 224241 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 41 Front Yard : Yard Tree Private 2     15     6004764.42793 2096634.95876 37.7372300405369 -122.42601128569 (37.7372300405369, -122.42601128569) 2 7 5 63 7
188995 119265 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1317 Bosworth St 1 Sidewalk: Property side : Cutout Tree Private 2           6000208 2096491 37.7365761953737 -122.441754571906 (37.7365761953737, -122.441754571906) 2 7 5 63 7
190588 224226 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 16 Front Yard : Yard Tree Private 2     13     6004846.93797 2096712.62979 37.7374479705325 -122.42573153718 (37.7374479705325, -122.42573153718) 2 7 5 63 7
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
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
142039 24268 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 350X Winding Way 6 Median : Cutout Tree DPW 1     12 8   6001111.91618 2086587.12369 37.7094338594537 -122.437920185566 (37.7094338594537, -122.437920185566) 9 7 6 28861 5
151807 24267 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 350X Winding Way 5 Median : Cutout Tree DPW 1     12 8   6001124.44895 2086586.86413 37.7094338594468 -122.437876851744 (37.7094338594468, -122.437876851744) 9 7 6 28861 5
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
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
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

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