trees

484 rows where qSpecies_id = 56 sorted by Police Districts 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)
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
11646 23200 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 520X Van Ness Ave 2 Median : Cutout Tree DPW 1     30 9   6006725.22564 2112390.29825 37.7806011691535 -122.420349841196 (37.7806011691535, -122.420349841196) 7 9 9 28852 36
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
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
161732 23202 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 520X Van Ness Ave 4 Median : Cutout Tree DPW 1     24 9   6006708.88776 2112470.99571 37.7808218241176 -122.420412091366 (37.7808218241176, -122.420412091366) 7 9 9 28852 36
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
181400 23183 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 520X Van Ness Ave 3 Median : Cutout Tree DPW 1   06/09/2005 12:00:00 AM 6 3X3   6006719.9876 2112427.32903 37.7807025515155 -122.420370591249 (37.7807025515155, -122.420370591249) 7 9 9 28852 36
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
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
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
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
14982 26911 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 10 Caine Ave 7 Median : Cutout Tree DPW 1     18 10   5997609.86555 2089654.44991 37.7176562610968 -122.450244747607 (37.7176562610968, -122.450244747607) 9 8 6 28861 24
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
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
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
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
58510 254319 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 210 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       10x10   5991371 2094995 37.7319610744091 -122.472198552297 (37.7319610744091, -122.472198552297) 1 8 4 64 40
59512 207781 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 256 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     19 Width 10ft   5993074.74882 2096403.4667 37.7359268257591 -122.466410707985 (37.7359268257591, -122.466410707985) 1 8 4 59 40
61500 208994 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 21 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     29 Width 4ft   5993511.28023 2097168.00802 37.7380512447772 -122.464956965598 (37.7380512447772, -122.464956965598) 1 8 4 59 40
62369 209003 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 96 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     43 Width 3ft   5994450.97172 2101378.39351 37.7496660456507 -122.462013248027 (37.7496660456507, -122.462013248027) 1 8 4 29491 40
62726 207808 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 15 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     25 Width 10ft   5993219.05388 2097526.21938 37.7390179494069 -122.465993350619 (37.7390179494069, -122.465993350619) 1 8 4 59 40
65313 114042 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 LINARES AVE 3 Front Yard : Yard Tree DPW 1       3x3   5994258 2102054 37.7515099774588 -122.462729551044 (37.7515099774588, -122.462729551044) 1 8 4 29491 40
65378 208922 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 201 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     25 Width 10ft   5992403.02946 2096048.00133 37.7349120244605 -122.468707231169 (37.7349120244605, -122.468707231169) 1 8 4 59 40
65949 207807 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 25 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     22 Width 10ft   5993231.15579 2097483.74028 37.7389020106052 -122.465948422302 (37.7389020106052, -122.465948422302) 1 8 4 59 40
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
66814 114041 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 LINARES AVE 2 Front Yard : Yard Tree DPW 1       3x3   5994258 2102054 37.7515099774588 -122.462729551044 (37.7515099774588, -122.462729551044) 1 8 4 29491 40
71372 208972 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 136 Yerba Buena Ave 2 Sidewalk: Curb side : Yard Tree Private 2     26 Width 6ft   5994281.63654 2096550.25213 37.7363994284866 -122.462248690521 (37.7363994284866, -122.462248690521) 9 8 4 59 40
73374 207800 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101 Santa Clara Ave 3 Sidewalk: Curb side : Yard Tree Private 2     42 Width 10ft   5993292.57138 2096874.95335 37.7372339768612 -122.465691859205 (37.7372339768612, -122.465691859205) 1 8 4 59 40
74248 208929 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 501 Saint Francis Blvd 1 Sidewalk: Curb side : Pot Tree Private 2     34 Width 6ft   5993145.62708 2096072.03007 37.735020873007 -122.466141577798 (37.735020873007, -122.466141577798) 1 8 4 59 40
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
75560 207778 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 124 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 10ft   5993200.08857 2096786.31561 37.7369852648432 -122.466005173107 (37.7369852648432, -122.466005173107) 1 8 4 59 40
76480 208928 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 335 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     44 Width 10ft   5992778.53612 2096059.14942 37.7349643200549 -122.467409794552 (37.7349643200549, -122.467409794552) 1 8 4 59 40
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
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
77868 207784 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 270 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     24 Width 10ft   5993081.21532 2096255.53806 37.7355210237716 -122.466377603044 (37.7355210237716, -122.466377603044) 1 8 4 59 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
79003 208937 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 64 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     36 Width 10ft   5991925.34536 2095973.96809 37.7346811406131 -122.470353347532 (37.7346811406131, -122.470353347532) 9 8 4 59 40
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
79769 207767 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 20 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     26 Width 10ft   5993205.66214 2097402.75145 37.7386781648646 -122.466030683288 (37.7386781648646, -122.466030683288) 1 8 4 59 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
80068 207790 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 265 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     39 Width 10ft   5993131.48438 2096255.50329 37.735523828762 -122.466203802777 (37.735523828762, -122.466203802777) 1 8 4 59 40
80518 207797 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 145 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     42 Width 10ft   5993240.65413 2096747.66446 37.7368814785997 -122.465862113458 (37.7368814785997, -122.465862113458) 1 8 4 59 40
81100 207787 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 292 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     15 Width 10ft   5993086.25016 2096104.57414 37.7351068050182 -122.466349227661 (37.7351068050182, -122.466349227661) 1 8 4 59 40
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
81221 208950 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 440 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     26 Width 10ft   5992985.54967 2096006.72468 37.7348323238367 -122.466690272156 (37.7348323238367, -122.466690272156) 9 8 4 59 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
84756 208946 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 300 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 10ft   5992719.83793 2096001.79663 37.7348034547201 -122.467608563598 (37.7348034547201, -122.467608563598) 9 8 4 59 40
85322 208931 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 435 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     27 Width 10ft   5993027.44059 2096068.92828 37.7350055368649 -122.466549961711 (37.7350055368649, -122.466549961711) 1 8 4 59 40
85357 208926 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 301 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     43 Width 10ft   5992668.30531 2096054.89965 37.7349462868375 -122.467790589077 (37.7349462868375, -122.467790589077) 1 8 4 59 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)
);