trees

484 rows where qSpecies_id = 56 sorted by qAddress

✎ 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)
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
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
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
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
188383 247937 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1149 Esmeralda Ave 2 Front Yard : Yard Tree Private 2     24     6010236.06133 2098747.86868 37.7433393564296 -122.407242153126 (37.7433393564296, -122.407242153126) 10 7 7 28859 2
162813 191721 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1150x Tennessee St 7 Median : Yard Tree DPW 1     50     6015559.12531 2103608.85918 37.7569830917109 -122.389175557402 (37.7569830917109, -122.389175557402) 10 3 8 28856 29
11269 247818 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1158x Jarboe Ave 1 Unaccepted Street : Yard Tree Private 2     46     6009634.53348 2096844.36766 37.7380790724954 -122.409187798594 (37.7380790724954, -122.409187798594) 10 7 7 28859 2
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
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
143887 207777 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 118 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     34 Width 10ft   5993220.09553 2096827.09916 37.7370984004648 -122.465938963216 (37.7370984004648, -122.465938963216) 1 8 4 59 40
444 105900 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11X ELLIOT ST 1 Unaccepted Street : Yard Tree DPW 1     30     6009059 2088845 37.716082244868 -122.410612975888 (37.716082244868, -122.410612975888) 9 7 8 309 18
136862 105901 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11X ELLIOT ST 2 Unaccepted Street : Yard Tree DPW 1     30     6009059 2088845 37.716082244868 -122.410612975888 (37.716082244868, -122.410612975888) 9 7 8 309 18
189511 105902 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11X ELLIOT ST 3 Unaccepted Street : Yard Tree DPW 1     40     6009059 2088845 37.716082244868 -122.410612975888 (37.716082244868, -122.410612975888) 9 7 8 309 18
158886 247820 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1201 Jarboe Ave 2 Front Yard : Yard Tree Private 2     7     6009707.55977 2096850.28614 37.7380994142676 -122.408935726717 (37.7380994142676, -122.408935726717) 10 7 7 28859 2
165894 247821 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1201 Jarboe Ave 3 Front Yard : Yard Tree Private 2     8     6009717.95526 2096849.33319 37.7380973799798 -122.40889971695 (37.7380973799798, -122.40889971695) 10 7 7 28859 2
167287 247819 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1201 Jarboe Ave 1 Front Yard : Yard Tree Private 2     8     6009694.17454 2096850.55921 37.738099414264 -122.408982025597 (37.738099414264, -122.408982025597) 10 7 7 28859 2
61418 224219 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1201 San Jose Ave 4 Front Yard : Yard Tree Private 2     7     6004118.53569 2095824.97349 37.7349694794509 -122.428186723249 (37.7349694794509, -122.428186723249) 2 7 5 28861 2
128484 224220 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1201 San Jose Ave 5 Front Yard : Yard Tree Private 2     46     6004122.93683 2095831.82479 37.7349885405914 -122.428171995061 (37.7349885405914, -122.428171995061) 2 7 5 28861 2
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
177674 207779 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 126 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     36 Width 10ft   5993175.19587 2096740.86685 37.7368590378112 -122.46608793591 (37.7368590378112, -122.46608793591) 1 8 4 59 40
128317 4837 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 127 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006404.24922 2097646.68025 37.7401005434118 -122.420413452032 (37.7401005434118, -122.420413452032) 2 7 7 28859 2
182896 208941 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 130 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     30 Width 10ft   5992287.57342 2095984.60456 37.7347312823091 -122.469101787134 (37.7347312823091, -122.469101787134) 9 8 4 59 40
134765 208974 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 130 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     25 Width 6ft   5994229.97779 2096604.20114 37.7365445844613 -122.462431207033 (37.7365445844613, -122.462431207033) 9 8 4 59 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
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
115626 208920 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 135 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 10ft   5992288.77396 2096040.55395 37.734884974665 -122.469101707103 (37.734884974665, -122.469101707103) 1 8 4 59 40
112500 209000 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 135 Yerba Buena Ave 5 Sidewalk: Curb side : Yard Tree Private 2     27 Width 4ft   5994206.5655 2096669.18291 37.7367216600723 -122.462516864768 (37.7367216600723, -122.462516864768) 9 8 4 59 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
92601 208973 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 136 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 6ft   5994259.72598 2096572.09553 37.7364581434207 -122.462326027748 (37.7364581434207, -122.462326027748) 9 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
23613 248107 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 138 Rutledge St 1 Side Yard : Yard Tree Private 2     35     6010423.63855 2099478.50343 37.7453560168793 -122.406645033853 (37.7453560168793, -122.406645033853) 2 7 7 28859 2
107735 207766 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 14 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     32 Width 10ft   5993184.09693 2097461.91411 37.7388393665447 -122.466109543018 (37.7388393665447, -122.466109543018) 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
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
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
68807 43994 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 141 Hampshire St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2000 12:00:00 AM 18   Permit Number 43551 6010001.85414 2107517.13485 37.7674046909874 -122.408670488759 (37.7674046909874, -122.408670488759) 8 4 8 28853 19
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
129458 207796 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 145 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     45 Width 10ft   5993217.29355 2096710.01575 37.7367767570402 -122.465940145823 (37.7367767570402, -122.465940145823) 1 8 4 59 40
139286 4843 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 146 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6006528.82493 2097534.91084 37.7398006689526 -122.419974789699 (37.7398006689526, -122.419974789699) 2 7 7 28859 2
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
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
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
175457 247851 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 152 Chapman St 3 Side Yard : Yard Tree Private 2     79     6009070.86749 2098234.59559 37.7418647407582 -122.411234858803 (37.7418647407582, -122.411234858803) 10 7 7 28859 2
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
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
111198 208961 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1575 07th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 2ft   5993977.82871 2104681.32491 37.7587077962432 -122.463889098911 (37.7587077962432, -122.463889098911) 1 5 4 56 12
124057 224245 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 160 Coso Ave 2 Sidewalk: Curb side : Yard Tree Private 2     32     6007485.6356 2099587.10163 37.7454893881214 -122.416811886672 (37.7454893881214, -122.416811886672) 2 7 7 28859 2
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
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
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
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
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
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
108706 209006 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 172 Kensington Way 2 Sidewalk: Curb side : Yard Tree Private 2     21 Width 3ft   5994773.63128 2098602.47798 37.7420626491773 -122.460696346461 (37.7420626491773, -122.460696346461) 1 8 4 59 40
136621 209007 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 172 Kensington Way 3 Sidewalk: Curb side : Yard Tree Private 2     18 Width 3ft   5994745.50567 2098641.39451 37.7421678860404 -122.460796414937 (37.7421678860404, -122.460796414937) 1 8 4 59 40
170594 209005 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 172 Kensington Way 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   5994782.01847 2098589.82391 37.7420283868014 -122.460666429624 (37.7420283868014, -122.460666429624) 1 8 4 59 40
44889 191727 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1790 23rd St 1 Sidewalk: Property side : Yard Tree Private 2     21     6013509.42079 2102917.94191 37.7549721419751 -122.396215837988 (37.7549721419751, -122.396215837988) 10 3 8 28856 29
185421 191728 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1790 23rd St 5 Sidewalk: Property side : Yard Tree Private 2     21     6013472.8835 2102915.30193 37.754962860065 -122.39634201018 (37.754962860065, -122.39634201018) 10 3 8 28856 29
23508 224254 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190 Storrie St 4 Front Yard : Yard Tree Private 2     16 Width 3ft   6000752.12131 2105271.59361 37.7607165903087 -122.440502889194 (37.7607165903087, -122.440502889194) 15 4 5 28862 3
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
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
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
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
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
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
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
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
96359 122535 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 199x Coso Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 3x3   6007478 2099565 37.7454282725128 -122.416836723884 (37.7454282725128, -122.416836723884) 2 7 7 28859 2
181524 121089 Private 9 Eucalyptus globulus :: Blue Gum 56 1X Grand View Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
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
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
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
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
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
112880 191737 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200 Helena St 2 Sidewalk: Curb side : Yard Tree Private 2     5     6010885.73151 2096220.33708 37.7364356342809 -122.404817839882 (37.7364356342809, -122.404817839882) 10 3 8 58 1
146246 191736 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200 Helena St 1 Sidewalk: Curb side : Yard Tree Private 2     57     6010895.57722 2096228.10312 37.7364575084979 -122.404784345514 (37.7364575084979, -122.404784345514) 10 3 8 58 1
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
159364 208943 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     39 Width 10ft   5992457.65692 2095992.19703 37.7347619554908 -122.468514307707 (37.7347619554908, -122.468514307707) 9 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
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
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
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
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
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
776 113502 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200x MANSELL ST 8 Median : Cutout Tree DPW 1     30 3x3   6011136 2090597 37.7210091086741 -122.403557031831 (37.7210091086741, -122.403557031831) 10 3 7 309 28
89575 113506 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200x Mansell St 12 Median : Cutout Tree DPW 1     39 3x3   6011135.08211 2090555.53588 37.7208952054249 -122.403557288932 (37.7208952054249, -122.403557288932) 10 3 7 309 28
179774 176340 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200x Mansell St 15 Median : Cutout Tree DPW 1     8 Width 0ft   6011135.84107 2090535.25569 37.720839562572 -122.403553239308 (37.720839562572, -122.403553239308) 10 7 7 309 28
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
131453 208923 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 201 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     32 Width 10ft   5992447.89906 2096049.02744 37.734917433899 -122.468552177239 (37.734917433899, -122.468552177239) 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)
);