trees

484 rows where qSpecies_id = 56 sorted by Zip Codes 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)
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
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
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
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
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
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
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
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
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
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
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
74910 114400 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1X HIGUERA AVE 3 Sidewalk: Property side : Cutout Tree Private 2     22 3x3   5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
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
82854 114075 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 24 HIGUERA AVE 1 Sidewalk: Curb side : Yard Tree Private 2     26     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
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
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
93771 29600 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 900X Junipero Serra Blvd 9 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991176.92289 2091079.14193 37.7211978713578 -122.472584119478 (37.7211978713578, -122.472584119478) 9 8 4 64 40
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
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
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
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
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
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
134035 114403 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1X HIGUERA AVE 6 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3   5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
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
139166 176348 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 0 Fuente Ave 2 Sidewalk: Curb side : Yard Tree Private 2     26     5989603.79735 2090546.09261 37.7196430676648 -122.477982952958 (37.7196430676648, -122.477982952958) 1 8 4 64 14
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
142283 114069 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2 HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree Private 2     40     5988091 2090188 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801) 1 8 4 64 14
152308 256445 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3001 Sunset Blvd 29 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
152776 253841 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 80X Junipero Serra Blvd 1 Median : Yard Tree Private 2       3x3   5991405 2095520 37.733404559811 -122.472119261767 (37.733404559811, -122.472119261767) 1 8 4 64 40
157123 66251 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 35 HIGUERA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   10/24/1990 12:00:00 AM     Permit Number 29352 5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
158118 114076 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 24 HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree Private 2     24     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
166600 254313 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190X Junipero Serra Blvd 5 Median : Yard Tree Private 2       10x10   5991377 2095081 37.732197556005 -122.472184075725 (37.732197556005, -122.472184075725) 1 8 4 64 40
171148 256446 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 3001 Sunset Blvd 30 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
173822 254318 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 210 Junipero Serra Blvd 1 Median : Cutout Tree Private 2       10x10   5991371 2094995 37.7319610744091 -122.472198552297 (37.7319610744091, -122.472198552297) 1 8 4 64 40
177622 254294 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 110 Junipero Serra Blvd 6 Median : Yard Tree Private 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
178630 254286 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100X Junipero Serra Blvd 2 Median : Yard Tree Private 2       3x3   5991400 2095443 37.7331928478719 -122.472130937334 (37.7331928478719, -122.472130937334) 1 8 4 64 40
179028 208978 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 700 Junipero Serra Blvd 109 : Tree Private 2     14 Width 0ft   5991241.87233 2091923.37185 37.7235196771825 -122.47242112456 (37.7235196771825, -122.47242112456) 9 8 4 64 40
3064 111546 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 900x BOSWORTH ST 24 Front Yard : Yard Tree DPW 1     15     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
3109 224224 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 14 Front Yard : Yard Tree Private 2     18     6004854.03678 2096713.39587 37.7374504751573 -122.425707047762 (37.7374504751573, -122.425707047762) 2 7 5 63 7
3562 209013 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 412 Baden St 1 Side Yard : Yard Tree Private 2     20     6000780.48794 2095392.50815 37.7335925958074 -122.439696511209 (37.7335925958074, -122.439696511209) 9 7 5 63 40
4907 209031 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 36 Martha Ave 8 Front Yard : Yard Tree Private 2     6     6000753.40861 2095578.70975 37.734102320757 -122.43980347745 (37.734102320757, -122.43980347745) 9 7 5 63 40
5310 209020 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 33 Martha Ave 4 : Yard Tree Private 2     12     6000767.68455 2095534.49854 37.7339817396554 -122.439750952547 (37.7339817396554, -122.439750952547) 9 7 5 63 40
6347 224265 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 58 Poppy Ln 1 Back Yard : Yard Tree Private 2     38     6002671.84671 2096513.90824 37.7367791753169 -122.433237644116 (37.7367791753169, -122.433237644116) 2 7 5 63 7
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
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
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
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
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
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
29552 209015 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 412 Baden St 3 Side Yard : Yard Tree Private 2     12     6000779.78636 2095479.1538 37.7338304646942 -122.439705146498 (37.7338304646942, -122.439705146498) 9 7 5 63 40
30561 224223 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 13 Front Yard : Yard Tree Private 2     21     6004855.41269 2096718.43509 37.7374643894683 -122.425702649156 (37.7374643894683, -122.425702649156) 2 7 5 63 7
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
31048 209011 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 408 Baden St 3 Front Yard : Yard Tree Private 2     13     6000782.19416 2095354.33843 37.7334878877384 -122.439687876799 (37.7334878877384, -122.439687876799) 9 7 5 63 40
32721 209023 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 34 Martha Ave 3 Front Yard : Yard Tree Private 2     20     6000780.47253 2095565.1582 37.7340666518368 -122.439708938014 (37.7340666518368, -122.439708938014) 9 7 5 63 40
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
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
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
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
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
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
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
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
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
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
73242 224246 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 483 Valley St 10 Sidewalk: Curb side : Yard Tree Private 2     55     6002830.24391 2099168.61142 37.7440773607828 -122.432879592517 (37.7440773607828, -122.432879592517) 2 7 5 63 22
74892 209034 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 38 Martha Ave 3 Front Yard : Yard Tree Private 2     30     6000740.95615 2095584.22378 37.7341167521787 -122.439846924607 (37.7341167521787, -122.439846924607) 9 7 5 63 40
77703 224237 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 29 Front Yard : Yard Tree Private 2     19     6004814.56562 2096681.78705 37.7373614539559 -122.425841268876 (37.7373614539559, -122.425841268876) 2 7 5 63 7
77709 209026 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 36 Martha Ave 3 Front Yard : Yard Tree Private 2     24     6000767.091 2095571.91906 37.7340844539158 -122.439755686569 (37.7340844539158, -122.439755686569) 9 7 5 63 40
78464 224232 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 22 Front Yard : Yard Tree Private 2     6     6004847.66693 2096700.74316 37.7374153737207 -122.425728171024 (37.7374153737207, -122.425728171024) 2 7 5 63 7
78746 224242 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 40 Front Yard : Yard Tree Private 2     5     6004773.22407 2096631.25513 37.7372203683314 -122.425980609816 (37.7372203683314, -122.425980609816) 2 7 5 63 7
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
81662 209017 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 33 Martha Ave 1 : Yard Tree Private 2     25     6000774.79116 2095519.58157 37.7339411856303 -122.439725313784 (37.7339411856303, -122.439725313784) 9 7 5 63 40
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
82650 209042 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 419 Baden St 7 Front Yard : Yard Tree Private 2     7     6000746.1619 2095340.78312 37.7334486170489 -122.439811478728 (37.7334486170489, -122.439811478728) 9 7 5 63 40
82743 209039 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 419 Baden St 4 Front Yard : Yard Tree Private 2     1     6000750.66308 2095345.51302 37.7334618604699 -122.439796255913 (37.7334618604699, -122.439796255913) 9 7 5 63 40
84225 209038 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 419 Baden St 3 Front Yard : Yard Tree Private 2     6     6000746.77902 2095349.32051 37.7334720938659 -122.439809957065 (37.7334720938659, -122.439809957065) 9 7 5 63 40
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
89376 209032 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 38 Martha Ave 1 Front Yard : Yard Tree Private 2     5     6000749.17916 2095580.79962 37.7341078183059 -122.439818249733 (37.7341078183059, -122.439818249733) 9 7 5 63 40
89483 224222 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 3 Front Yard : Yard Tree Private 2     14     6004869.89816 2096730.73115 37.7374989702074 -122.425653440952 (37.7374989702074, -122.425653440952) 2 7 5 63 7
90994 113367 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 6X Christopher Dr 1 Front Yard : Yard Tree DPW 1     25     5996701.11551 2103988.82524 37.7569629284433 -122.454420756361 (37.7569629284433, -122.454420756361) 1 5 4 63 12
99245 224225 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 15 Front Yard : Yard Tree Private 2     32     6004862.25492 2096710.90423 37.737444098063 -122.425678456492 (37.737444098063, -122.425678456492) 2 7 5 63 7
100794 209022 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 34 Martha Ave 2 Front Yard : Yard Tree Private 2     33     6000785.93499 2095562.56819 37.7340598511869 -122.439689867014 (37.7340598511869, -122.439689867014) 9 7 5 63 40

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